-- http://www.phpmyadmin.net
-- 
-- 主機: localhost
-- 建立日期: Jun 03, 2016, 03:45 PM
-- 伺服器版本: 5.0.51
-- PHP 版本: 5.2.6


-- --------------------------------------------------------

-- 
-- 資料表格式： `datasetup_admin_group`
-- 

CREATE TABLE `datasetup_admin_group` (
  `id` int(20) NOT NULL auto_increment,
  `name` varchar(20) NOT NULL,
  `auth` text NULL,
  `control` int(11) default NULL,
  `status` tinyint(4) NOT NULL,
  `create_date` datetime NOT NULL,
  `update_date` datetime NOT NULL,
  `create_name` varchar(20) NOT NULL,
  `update_name` varchar(20) NOT NULL,
  `auth_ch` text COMMENT '程式生成欄位',
  `auth_en` text COMMENT '程式生成欄位',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

-- 
-- 列出以下資料庫的數據： `datasetup_admin_group`
-- 

INSERT INTO `datasetup_admin_group` VALUES (4, '管理者', '293,298,182,315,354,353,372,373,374,355,375,120,121,122,123,124,125', 1, 1, '2011-07-19 15:17:26', '2017-02-21 10:16:51', 'admin', 'vipadmin', '293,298,342,498,477,500,505,501,503,504,542,473,474,475,476,535,536,387,488,489,120,121,122,123,124,378,376,125,502,537,538,539,540', '');
INSERT INTO `datasetup_admin_group` VALUES (7, '系統管理員', '293,298,342,337,338,348,182,315,401,402,403,404,405,387,389,388,390,391,399,392,400,406,120,121,122,123,124,377,378,376,125,396,398', 0, 1, '2014-03-11 15:50:00', '2016-08-17 15:52:06', 'service', 'vipadmin', '473,474,475,476,535,536,541,293,298,342,498,477,500,505,501,503,504,542,387,488,489,120,121,122,123,124,377,378,376,125,396,398,502,537,538,539,540', '569,570,571,572,573,574,575,555,556,559,561,560,563,564,562,557,558,565,566,567,568,552,554,553,543,544,548,549,547,545,546,550,551,576,577,578,579');
INSERT INTO `datasetup_admin_group` VALUES (8, '客戶管理者', '293,298,342,337,338,348,182,315,401,402,403,404,405,387,389,388,390,391,399,392,400,120,121,122,123,124,377,125,396', 2, 1, '2014-03-11 15:58:32', '2017-02-21 10:17:22', 'service', 'vipadmin', '123,124,125', '543,544,545');

-- --------------------------------------------------------

-- 
-- 資料表格式： `datasetup_category`
-- 

CREATE TABLE `datasetup_category` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `root_id` mediumint(8) unsigned NOT NULL default '0',
  `parent_id` mediumint(8) NOT NULL default '0',
  `lft` int(10) NOT NULL default '0',
  `rgt` int(10) NOT NULL default '0',
  `name` varchar(200) NOT NULL,
  `detail` text,
  `sort` double default '0.9',
  `pic` varchar(100) default NULL,
  `file` varchar(100) default NULL,
  `memo` varchar(100) default NULL,
  `status` tinyint(1) NOT NULL default '1',
  `mode` varchar(20) default NULL,
  `depth` tinyint(2) NOT NULL default '0',
  `sys` tinyint(1) NOT NULL default '0',
  `lang` varchar(5) default NULL,
  `update_date` datetime NOT NULL,
  `create_date` datetime NOT NULL,
  `update_name` varchar(15) NOT NULL,
  `create_name` varchar(15) NOT NULL,
  `max_count` text COMMENT '程式生成欄位',
  `b_value` text COMMENT '程式生成欄位',
  `new_type` text COMMENT '程式生成欄位',
  `fordepth` text COMMENT '程式生成欄位',
  `member_id` text COMMENT '程式生成欄位',
  PRIMARY KEY  (`id`),
  KEY `sort` (`sort`),
  KEY `status` (`status`),
  KEY `sys` (`sys`),
  KEY `parent_id` (`parent_id`),
  KEY `root_id` (`root_id`),
  KEY `lft` (`lft`),
  KEY `rgt` (`rgt`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=133 ;

-- 
-- 列出以下資料庫的數據： `datasetup_category`
-- 

INSERT INTO `datasetup_category` VALUES (1, 1, 0, 0, 23, '產品分類', '0|__|0', 1, '', '', 'detail', 1, '', 0, 1, 'ch', '2016-02-23 16:00:19', '2010-01-12 13:28:21', 'admin', '', '2', '內容', '3', '', '');
INSERT INTO `datasetup_category` VALUES (109, 1, 1, 1, 6, '展示類組', '分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊', 1, '', '', '', 1, '', 1, 0, 'ch', '2016-02-23 16:19:20', '2014-02-19 15:27:24', 'vipadmin', 'service', '', '', '', '', '');
INSERT INTO `datasetup_category` VALUES (110, 1, 1, 7, 20, '展架列組', '', 2, '', '', '', 1, '', 1, 0, 'ch', '2014-02-19 15:27:32', '2014-02-19 15:27:32', 'service', 'service', '', '', '', '', '');
INSERT INTO `datasetup_category` VALUES (111, 1, 1, 21, 22, '陳列架列組', '', 3, '', '', '', 1, '', 1, 0, 'ch', '2014-02-19 15:27:45', '2014-02-19 15:27:45', 'service', 'service', '', '', '', '', '');
INSERT INTO `datasetup_category` VALUES (112, 1, 109, 2, 3, '第一分類次分類一', '分類自由區塊分類自由區塊分類自由區塊分類自由區塊分類自由區塊', 1, '', '', '', 1, '', 2, 0, 'ch', '2016-02-23 16:19:05', '2014-02-19 15:29:14', 'vipadmin', 'service', '', '', '', '', '');
INSERT INTO `datasetup_category` VALUES (113, 1, 109, 4, 5, '第一分類次分類二', '<iframe allowfullscreen=\\"\\" frameborder=\\"0\\" height=\\"315\\" src=\\"https://www.youtube.com/embed/Oy3-blsUAlM\\" width=\\"560\\"></iframe>', 2, '', '', '', 1, '', 2, 0, 'ch', '2016-02-23 16:11:12', '2014-02-19 15:29:22', 'service', 'service', '', '', '', '', '');
INSERT INTO `datasetup_category` VALUES (114, 1, 110, 8, 9, '易拉展', '', 1, '', '', '', 1, '', 2, 0, 'ch', '2014-02-19 15:30:07', '2014-02-19 15:30:07', 'service', 'service', '', '', '', '', '');
INSERT INTO `datasetup_category` VALUES (115, 1, 110, 10, 11, '大型展架', '', 2, '', '', '', 1, '', 2, 0, 'ch', '2014-02-19 15:30:30', '2014-02-19 15:30:30', 'service', 'service', '', '', '', '', '');
INSERT INTO `datasetup_category` VALUES (116, 1, 110, 12, 13, 'T字展架', '', 3, '', '', '', 1, '', 2, 0, 'ch', '2014-02-19 15:31:20', '2014-02-19 15:31:20', 'service', 'service', '', '', '', '', '');
INSERT INTO `datasetup_category` VALUES (117, 1, 110, 14, 15, '弓形展架', '', 4, '', '', '', 1, '', 2, 0, 'ch', '2014-02-19 15:31:46', '2014-02-19 15:31:46', 'service', 'service', '', '', '', '', '');
INSERT INTO `datasetup_category` VALUES (118, 1, 110, 16, 17, '易拉鋼組', '', 5, '', '', '', 1, '', 2, 0, 'ch', '2014-02-19 15:32:23', '2014-02-19 15:32:23', 'service', 'service', '', '', '', '', '');
INSERT INTO `datasetup_category` VALUES (119, 1, 110, 18, 19, '快幕秀', '', 6, '', '', '', 1, '', 2, 0, 'ch', '2014-02-19 15:32:48', '2014-02-19 15:32:48', 'service', 'service', '', '', '', '', '');
INSERT INTO `datasetup_category` VALUES (132, 132, 0, 0, 1, 'p2', '0|__|', 2, NULL, NULL, 'detaIL', 1, NULL, 0, 1, 'ch', '2016-05-20 16:18:39', '2016-05-20 16:18:39', '', '', '1', 'detaIL', '3', '', NULL);






-- 
-- 資料表格式： `datasetup_form`
-- 

CREATE TABLE `datasetup_form` (
  `id` int(11) NOT NULL auto_increment,
  `type` text NOT NULL,
  `lang` varchar(20) NOT NULL default 'ch' COMMENT '語系',
  `status` int(11) NOT NULL default '1',
  `create_date` datetime default NULL,
  `update_date` datetime default NULL,
  `create_name` text,
  `update_name` text,
  `name` text COMMENT '聯絡人',
  `company` text COMMENT '公司名稱',
  `company_no` text COMMENT '公司統編',
  `phone` text COMMENT '連絡電話',
  `address` text COMMENT '地址',
  `cellphone` text COMMENT '行動電話',
  `email` text COMMENT '電子郵件',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

-- 
-- 列出以下資料庫的數據： `datasetup_form`
-- 


-- --------------------------------------------------------

-- 
-- 資料表格式： `datasetup_language`
-- 

CREATE TABLE `datasetup_language` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(20) default NULL,
  `detail` varchar(20) default NULL,
  `status` int(2) NOT NULL default '1',
  `sort` double default '0.9',
  `create_date` datetime default NULL,
  `update_date` datetime default NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

-- 
-- 列出以下資料庫的數據： `datasetup_language`
-- 

INSERT INTO `datasetup_language` VALUES (1, '中文', 'ch', 1, 1, '2014-03-20 10:42:15', '2014-03-20 11:37:34');

-- --------------------------------------------------------

-- 
-- 資料表格式： `datasetup_products`
-- 

CREATE TABLE `datasetup_products` (
  `id` int(20) NOT NULL auto_increment,
  `type` varchar(100) NOT NULL,
  `lang` varchar(20) NOT NULL,
  `name` varchar(50) default NULL,
  `detail` text COMMENT '程式自動生成',
  `pic` text,
  `sort` double default '0.9',
  `status` tinyint(4) default NULL,
  `point` varchar(10) default NULL COMMENT '獲得紅利',
  `depoint` int(11) default '0' COMMENT '紅利折扣',
  `create_date` datetime default NULL,
  `update_date` datetime default NULL,
  `create_name` varchar(20) default NULL,
  `update_name` varchar(20) default NULL,
  `price1` int(10) NOT NULL default '0' COMMENT '原價',
  `price2` int(20) NOT NULL default '0' COMMENT '特價',
  `price_desh` double default NULL COMMENT '折扣',
  `stock` text,
  `protype` int(20) default NULL COMMENT '商品種類root_id=1',
  `probrand` int(20) default NULL COMMENT '商品品牌root_id=2',
  `del_pic` varchar(100) default NULL COMMENT '程式自動生成',
  `protype_other` text,
  `probrand_other` text,
  `cook` varchar(10) default NULL COMMENT '是否啟用線上食譜',
  `add_pro` text COMMENT ' 加價購商品',
  `add_price` text COMMENT '加價購商品價錢',
  `add_count` text COMMENT '加價購商品數量',
  `add_pic` text COMMENT '加價購圖片',
  `class` varchar(100) default NULL COMMENT '程式自動生成',
  `memo_1` varchar(100) default NULL COMMENT '程式自動生成',
  `href` varchar(100) default NULL COMMENT '程式自動生成',
  `prolist` varchar(100) default NULL COMMENT '程式自動生成',
  `size` text COMMENT '程式生成欄位',
  `memo` text COMMENT '程式生成欄位',
  `color` text COMMENT '程式生成欄位',
  `stock_no` text COMMENT '程式生成欄位',
  `alies` text COMMENT '程式生成欄位',
  `isnew` text COMMENT '程式生成欄位',
  `stock_pic` text COMMENT '程式生成欄位',
  `stock_status` text COMMENT '程式生成欄位',
  `stock_price` text COMMENT '程式生成欄位',
  PRIMARY KEY  (`id`),
  KEY `type` (`type`),
  KEY `lang` (`lang`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2132 ;

-- 
-- 列出以下資料庫的數據： `datasetup_products`
-- 

INSERT INTO `datasetup_products` VALUES (2113, 'products', 'ch', 'amamn', '花旦是中國傳統戲曲腳色行當[1]，為青年或中年女性的形象，元雜劇就有花旦雜劇一類。經過多個朝代，花旦成了中國各種地方戲曲，譬如漢劇、崑劇、京劇和粵劇，共有的性格造型。其造型則重唸散白，重做功，重神采，不重唱功但要求唱腔的清秀美麗、靈敏乖巧。<br />\r\n<br />\r\n<strong>產品特色：</strong><br />\r\n&nbsp;\r\n<p>有別於傳統的拼圖，拼點子以軟質的像素顆粒(pixel)為素材拼貼出的圖像，其具有特殊的立體質感以及馬賽克拼貼的趣味，完成的作品質感令人驚艷。</p>\r\n\r\n<p>拼點子主要由色素(pixel)和底板(baseplate)組成：</p>\r\n\r\n<p>色素與色塊：<br />\r\n色素(pixel)是組合成圖案的元素，這是一種軟質的塑膠小顆粒，為了方便取用和辨別，色素以色塊(pixel square)為基本單位，每一個色塊上有140顆色素，在每一片色塊的背面都標有代表顏色的數字。</p>\r\n\r\n<p>底板：<br />\r\n底板就像是畫布，我們把每一個色素(Pixel)按照設計圖的指示拼貼在底板的相對位置上，就能輕鬆拼成一幅圖像，就像在畫布上畫畫一樣。</p>\r\n', '55354300.jpg|__|63954900.jpg|__|70255300.jpg|__|24258300.jpg', 1, 1, '22', 100, '2013-11-29 06:15:17', '2016-03-04 15:59:01', 'admin', 'vipadmin', 5000, 5000, 30, '17|__|0|__|20', 0, 0, '76562600.jpg', '', '', '0', '', '', '', '', '113|__|114', '                                                                                                qweq', '', '', '紅|__|灰|__|基本', '                                                                                          尺寸：寬10.2 高12.7公分\r\n標準大底板(4英吋x 5英吋) x 1片\r\n色塊：28片\r\n顏色：24色\r\n(含鑷子x1; 不含外框)\r\n      \r\n      \r\n      \r\n      \r\n      \r\n      \r\n      \r\n      \r\n      \r\n      \r\n      \r\n      \r\n      \r\n      \r\n      ', '#ff0000|__||__|', 'AA03|__|AA02|__|AA01', '', '0', '145707833598.png|__||__|', '1|__|1|__|1', '400|__||__|200');
INSERT INTO `datasetup_products` VALUES (2128, '', 'ch', '100', '#ab08de', '', 3, 1, '', 0, '2014-05-21 11:40:07', '2014-05-21 11:40:07', 'vipadmin', 'vipadmin', 0, 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `datasetup_products` VALUES (2127, '', 'ch', '157', '#00ff00', '', 1, 1, '', 0, '2014-05-21 11:25:01', '2014-06-25 10:31:34', 'vipadmin', 'vipadmin', 999, 999, 0, '', 0, 0, '', '', '', '', '', '', '', '', '113', '      \r\n      ', '', '', '', '      \r\n      ', '', '', '', '', '', '', '');
INSERT INTO `datasetup_products` VALUES (2129, 'products', 'ch', 'test', '22222', '', 2, 1, '', 0, '2014-06-26 14:07:33', '2014-08-28 09:36:44', 'vipadmin', 'vipadmin', 0, 0, 0, '0', 0, 0, '', '', '', '', '', '', '', '', '113|__|115', '                  123123123\r\n      \r\n      \r\n      \r\n      \r\n      ', '', '', '基本', '                  2323\r\n      \r\n      \r\n      \r\n      \r\n      \r\n      \r\n      ', '', '', '', '', '', '', '');
INSERT INTO `datasetup_products` VALUES (2130, 'products2', 'ch', 'Aaaaaaaaaaaaa', 'aaaaaa', '', 1, 1, '', 0, '2014-06-26 14:07:53', '2014-07-10 11:15:32', 'vipadmin', 'vipadmin', 0, 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '120', '                  aaaaaa\r\n      \r\n      \r\n      ', '', '', '', '                  \r\n      aaa\r\n      \r\n      ', '', '', '', '', '', '', '');
INSERT INTO `datasetup_products` VALUES (2131, 'products', 'ch', 'tttttttt', '', '', 3, 1, '', 0, '2016-02-23 14:41:05', '2016-02-23 14:41:05', 'vipadmin', 'vipadmin', 1000, 1000, 0, '', 0, 0, '', '', '', '', '', '', '', '', '112', '      \r\n      ', '', '', '', '      \r\n      ', '', '', 'aaa', '0', '', '', '');

-- --------------------------------------------------------

-- 
-- 資料表格式： `datasetup_setting`
-- 

CREATE TABLE `datasetup_setting` (
  `id` int(20) NOT NULL auto_increment,
  `lang` varchar(20) NOT NULL default 'ch',
  `type` varchar(20) default NULL,
  `name` varchar(100) NOT NULL,
  `detail` text NOT NULL,
  `status` tinyint(4) NOT NULL COMMENT '1=一般 2=優化關鍵字',
  `create_date` datetime NOT NULL,
  `update_date` datetime NOT NULL,
  `create_name` varchar(20) NOT NULL,
  `update_name` varchar(20) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=55 ;

-- 
-- 列出以下資料庫的數據： `datasetup_setting`
-- 

INSERT INTO `datasetup_setting` VALUES (1, 'ch', '', '網站名稱', '網站名稱', 1, '0000-00-00 00:00:00', '2016-06-01 17:15:23', '', 'vipadmin');
INSERT INTO `datasetup_setting` VALUES (2, 'ch', '', '優化關鍵字', '<meta name=\\"keywords\\" content=\\"關鍵字\\">\r\n<meta name=\\"description\\" content=\\"關鍵字內文\\">\r\n<meta name=\\"RATING\\" content=\\"general\\">\r\n<meta name=\\"REVISIT-AFTER\\" content=\\"1 Days\\">\r\n<meta name=\\"ROBOTS\\" content=\\"all\\">\r\n<meta name=\\"googlebot\\" content=\\"index,follow\\">', 2, '0000-00-00 00:00:00', '2016-06-01 17:15:23', '', 'vipadmin');
INSERT INTO `datasetup_setting` VALUES (3, 'ch', '', '收件者 E-Mail', 'Jones@vipcase.net', 1, '0000-00-00 00:00:00', '2016-06-01 17:15:23', '', 'vipadmin');
INSERT INTO `datasetup_setting` VALUES (4, 'ch', '', '寄件者 標題', 'XXX 系統郵件', 1, '0000-00-00 00:00:00', '2016-06-01 17:15:23', '', 'vipadmin');
INSERT INTO `datasetup_setting` VALUES (5, 'ch', '', '寄件者 E-Mail', 'Jones@vipcase.net', 1, '0000-00-00 00:00:00', '2016-06-01 17:15:23', '', 'vipadmin');
INSERT INTO `datasetup_setting` VALUES (16, 'ch', 'post_fee', '運費', '200', 1, '0000-00-00 00:00:00', '2016-06-01 17:15:23', '', 'vipadmin');
INSERT INTO `datasetup_setting` VALUES (17, 'ch', '', '紅利折抵上限(每個商品)', '50', 0, '0000-00-00 00:00:00', '2014-01-22 18:38:58', '', 'service');
INSERT INTO `datasetup_setting` VALUES (18, 'ch', '', '加入會員贈送紅利點數', '100', 3, '0000-00-00 00:00:00', '2014-01-13 10:56:13', '', 'admin');
INSERT INTO `datasetup_setting` VALUES (19, 'ch', '', 'GOOGLE地圖', '<iframe width=\\"425\\" height=\\"350\\" frameborder=\\"0\\" scrolling=\\"no\\" marginheight=\\"0\\" marginwidth=\\"0\\" src=\\"https://maps.google.com.tw/maps?hl=zh-TW&ie=UTF8&ll=23.48575,119.49965&spn=9.854536,16.21582&t=m&z=7&brcurrent=3,0x346ef3065c07572f:0xe711f004bf9c5469,1&output=embed\\"></iframe><br /><small><a href=\\"https://maps.google.com.tw/maps?hl=zh-TW&ie=UTF8&ll=23.48575,119.49965&spn=9.854536,16.21582&t=m&z=7&brcurrent=3,0x346ef3065c07572f:0xe711f004bf9c5469,1&source=embed\\" style=\\"color:#0000FF;text-align:left\\">顯示詳細地圖</a></small>', 2, '0000-00-00 00:00:00', '2014-01-13 10:56:13', '', 'admin');
INSERT INTO `datasetup_setting` VALUES (20, 'ch', '', '首頁跑馬燈文字', '2013/8/27 隆重開幕 KASK安全帽特價中', 1, '0000-00-00 00:00:00', '2014-01-13 10:56:13', '', 'admin');
INSERT INTO `datasetup_setting` VALUES (21, 'ch', '', '首頁跑馬燈連結', 'tw.yahoo.com', 1, '0000-00-00 00:00:00', '2014-01-13 10:56:13', '', 'admin');
INSERT INTO `datasetup_setting` VALUES (22, 'ch', '', 'YouTube 視頻連結', 'https://www.youtube.com/watch?v=44yXE5dC6I0', 1, '0000-00-00 00:00:00', '2014-01-13 10:56:13', '', 'admin');
INSERT INTO `datasetup_setting` VALUES (25, 'ch', '', '全站統一折扣率', '0', 1, '0000-00-00 00:00:00', '2014-01-13 10:56:13', '', 'admin');
INSERT INTO `datasetup_setting` VALUES (46, 'ch', 'website_url', '網域導向頁面', 'index.php', 1, '0000-00-00 00:00:00', '2016-06-01 17:15:23', '', 'vipadmin');
INSERT INTO `datasetup_setting` VALUES (44, 'ch', 'backup', '資料庫備份路徑', '../upload/database_backup/', 1, '0000-00-00 00:00:00', '2016-06-01 17:15:23', '', 'vipadmin');
INSERT INTO `datasetup_setting` VALUES (42, 'ch', 'button', '檔案上傳按鈕連結', 'index.php?class=qa&id=99', 1, '0000-00-00 00:00:00', '2014-06-25 11:18:29', '', 'service');
INSERT INTO `datasetup_setting` VALUES (43, 'ch', 'google_map', 'google map嵌入式語法', '<iframe width="230" height="600" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="https://maps.google.com.tw/maps?hl=zh-TW&amp;q=%E9%AB%98%E9%9B%84%E5%B8%82%E5%B7%A6%E7%87%9F%E5%8D%80%E7%AB%8B%E6%96%87%E8%B7%AF+77+%E8%99%9F&amp;ie=UTF8&amp;hq=&amp;hnear=813%E9%AB%98%E9%9B%84%E5%B8%82%E5%B7%A6%E7%87%9F%E5%8D%80%E7%AB%8B%E6%96%87%E8%B7%AF77%E8%99%9F&amp;t=m&amp;brcurrent=3,0x346e05a2921bd1c9:0xcee6f0be1e1a3c09,0,0x346e43517a7a741b:0x4826a24a54732a37&amp;ll=22.664314,120.304413&amp;spn=0.049106,0.019655&amp;z=14&amp;iwloc=A&amp;output=embed" style="border:solid 1px #fff;"></iframe><br><small><a href="https://maps.google.com.tw/maps?hl=zh-TW&amp;q=%E9%AB%98%E9%9B%84%E5%B8%82%E5%B7%A6%E7%87%9F%E5%8D%80%E7%AB%8B%E6%96%87%E8%B7%AF+77+%E8%99%9F&amp;ie=UTF8&amp;hq=&amp;hnear=813%E9%AB%98%E9%9B%84%E5%B8%82%E5%B7%A6%E7%87%9F%E5%8D%80%E7%AB%8B%E6%96%87%E8%B7%AF77%E8%99%9F&amp;t=m&amp;brcurrent=3,0x346e05a2921bd1c9:0xcee6f0be1e1a3c09,0,0x346e43517a7a741b:0x4826a24a54732a37&amp;ll=22.664314,120.304413&amp;spn=0.049106,0.019655&amp;z=14&amp;iwloc=A&amp;source=embed" style="color:#474d44;text-align:left; font:11px/24px Arial;">顯示詳細地圖</a></small>', 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '');
INSERT INTO `datasetup_setting` VALUES (47, 'ch', 'delay_time', '管理登入閒置時間(秒)', '3600', 1, '0000-00-00 00:00:00', '2016-06-01 17:15:23', '', 'vipadmin');
INSERT INTO `datasetup_setting` VALUES (48, 'ch', 'design', '商品資料最大組數', '5', 3, '0000-00-00 00:00:00', '2016-06-01 17:15:23', '', 'vipadmin');
INSERT INTO `datasetup_setting` VALUES (49, 'ch', 'design', '簡介資訊最大組數', '5', 3, '0000-00-00 00:00:00', '2016-06-01 17:15:23', '', 'vipadmin');
INSERT INTO `datasetup_setting` VALUES (50, 'ch', 'design', '最新消息最大組數', '5', 3, '0000-00-00 00:00:00', '2016-06-01 17:15:23', '', 'vipadmin');
INSERT INTO `datasetup_setting` VALUES (51, 'ch', 'design', '分類最大組數', '2', 3, '0000-00-00 00:00:00', '2016-06-01 17:15:23', '', 'vipadmin');
INSERT INTO `datasetup_setting` VALUES (52, 'ch', 'no_post_fee', '免運費金額', '1600', 1, '0000-00-00 00:00:00', '2016-06-01 17:15:23', '', 'vipadmin');
INSERT INTO `datasetup_setting` VALUES (53, 'ch', 'post_fee2', '達到金額運費', '0', 1, '0000-00-00 00:00:00', '2015-01-20 18:27:52', '', 'vipadmin');
INSERT INTO `datasetup_setting` VALUES (45, 'ch', 'demo_show', '頁面建構中自訂義', '<meta charset=\\"utf-8\\">\r\n<title></title>\r\n<link href=\\"https://fonts.googleapis.com/css?family=Oswald:300\\" rel=\\"stylesheet\\" type=\\"text/css\\" />\r\n<style type=\\"text/css\\">body, html { height:100%; margin:0; font-family: Microsoft JhengHei;}\r\n.fontstyle01 { font-size:36px; color:#746E37;}\r\n.fontstyle02 { font-size:30px; color: #A7A3A4; font-family: \\''Oswald\\'';}\r\n.line { border-bottom:1px #D9D9D9 solid; margin:10px 0; width:300px;}\r\n</style>\r\n<table border=\\"0\\" cellpadding=\\"0\\" cellspacing=\\"0\\" style=\\"height:100%;\\" width=\\"100%\\">\r\n	<tbody>\r\n		<tr>\r\n			<td align=\\"center\\"><img height=\\"auto\\" src=\\"data:image/png;base64,[BLOB]\\" width=\\"250px\\" />\r\n			<div class=\\"fontstyle01\\">網站建構中</div>\r\n\r\n			<div class=\\"line\\">&nbsp;</div>\r\n\r\n			<div class=\\"fontstyle02\\">Construction Site</div>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>', 3, '0000-00-00 00:00:00', '2016-08-25 11:33:48', '', 'vipadmin');
INSERT INTO `datasetup_setting` VALUES (54, 'ch', 'web_css', '編輯器前台式樣檔應用路徑', '../css/main.css', 1, '0000-00-00 00:00:00', '2016-06-01 17:15:23', '', 'vipadmin');

-- --------------------------------------------------------

-- 
-- 資料表格式： `datasetup_shopping_car`
-- 

CREATE TABLE `datasetup_shopping_car` (
  `id` int(20) NOT NULL auto_increment,
  `namespace` text NOT NULL COMMENT '存放命名空間',
  `step` tinyint(1) default '1' COMMENT '購物流程指標',
  `order_no` varchar(30) NOT NULL COMMENT '定單序號',
  `total` int(20) default '0' COMMENT '總價(不含折價 不含運費)',
  `deshpoint` int(11) default NULL COMMENT '扣除紅利點',
  `addpoint` int(11) default NULL COMMENT '新增紅利點',
  `post_fee` int(10) default '0' COMMENT '運費',
  `back_total` int(20) default NULL COMMENT '退款總額',
  `back_money` int(20) default NULL COMMENT '已退金額',
  `paycardmode` tinyint(1) default '0' COMMENT '刷卡方式 1=聯邦 2=國泰世華 3=花旗 4=中信',
  `MerchantNumber` varchar(50) default NULL COMMENT '金流串接商店編號',
  `Code` varchar(30) default NULL COMMENT '金流串接商店編號對應code',
  `Period` tinyint(1) default '0' COMMENT '分期期數',
  `member_id` int(20) default NULL,
  `type` varchar(100) NOT NULL default 'shopping_car',
  `lang` varchar(20) default NULL,
  `status` tinyint(1) default NULL,
  `pay_status` tinyint(1) default '0' COMMENT '付款狀態',
  `paymode_status` varchar(10) default '0' COMMENT '金流狀態 0未付款 1已付款 9失效狀態',
  `cargo_status` tinyint(1) default '0' COMMENT '出貨狀態',
  `email` varchar(50) default NULL,
  `sex` varchar(50) default NULL,
  `company` varchar(50) default NULL,
  `country` varchar(50) default NULL,
  `zip` varchar(50) default NULL,
  `contact_time` varchar(50) default NULL,
  `recive_name` varchar(50) default NULL,
  `recive_email` varchar(50) default NULL,
  `recive_address` varchar(100) default NULL,
  `recive_zip` varchar(50) default NULL,
  `recive_sex` varchar(50) default NULL,
  `recive_phone` varchar(100) default NULL COMMENT '收件人電話',
  `recive_cellphone` varchar(100) default NULL COMMENT '收件人手機',
  `recive_takemode` varchar(20) default NULL COMMENT '取貨方式',
  `unity_no` varchar(40) default NULL COMMENT '統一編號',
  `unity_title` varchar(20) default NULL,
  `checksum` varchar(50) default NULL COMMENT '金流md5檢查碼',
  `name` varchar(30) default NULL,
  `birthday` varchar(30) default NULL,
  `phone` varchar(30) default NULL,
  `cellphone` varchar(30) default NULL,
  `address` text,
  `memo` text COMMENT '備註',
  `create_date` datetime default NULL,
  `update_date` datetime default NULL,
  `cargo_date` datetime default NULL COMMENT '出貨時間',
  `create_name` varchar(20) default NULL,
  `update_name` varchar(20) default NULL,
  `ATMcode` text COMMENT 'ATM轉帳後四碼',
  `s_paycardmode` text COMMENT '程式生成欄位',
  `order_img` longtext COMMENT '訂單圖像',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;

-- 
-- 列出以下資料庫的數據： `datasetup_shopping_car`
-- 


-- --------------------------------------------------------

-- 
-- 資料表格式： `datasetup_shopping_car_groups`
-- 

CREATE TABLE `datasetup_shopping_car_groups` (
  `id` int(11) NOT NULL auto_increment,
  `shopping_car_id` int(11) NOT NULL,
  `shopping_car_list_id` int(11) default NULL,
  `active_name` text NOT NULL,
  `price` int(11) NOT NULL,
  `groupcount` int(11) NOT NULL default '0' COMMENT '活動組合數量',
  `create_date` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

-- 
-- 列出以下資料庫的數據： `datasetup_shopping_car_groups`
-- 


-- --------------------------------------------------------

-- 
-- 資料表格式： `datasetup_shopping_car_list`
-- 

CREATE TABLE `datasetup_shopping_car_list` (
  `shopping_car_list_id` int(20) NOT NULL auto_increment,
  `shopping_car_id` int(20) NOT NULL,
  `count` int(10) NOT NULL default '1',
  `id` int(20) NOT NULL,
  `type` varchar(100) NOT NULL,
  `lang` varchar(20) default NULL,
  `size` text,
  `name` varchar(50) default NULL,
  `detail` text COMMENT '程式自動生成',
  `point` int(11) default NULL COMMENT '獲得紅利點數',
  `depoint` int(11) default NULL COMMENT '可刪減多少紅利',
  `pic` text,
  `sort` int(20) default NULL,
  `status` tinyint(4) default NULL,
  `create_date` datetime default NULL,
  `update_date` datetime default NULL,
  `create_name` varchar(20) default NULL,
  `update_name` varchar(20) default NULL,
  `price1` int(10) default '0' COMMENT '原價',
  `price2` int(20) default '0' COMMENT '特價',
  `stock` int(10) default '0',
  `protype` int(20) default NULL COMMENT '商品種類root_id=1',
  `probrand` int(20) default NULL COMMENT '商品品牌root_id=2',
  `del_pic` varchar(100) default NULL COMMENT '程式自動生成',
  `talkabout` text COMMENT '討論評價內容',
  `talkstar` int(11) default NULL COMMENT '評價等級',
  `talkrequest` text COMMENT '客服回應',
  PRIMARY KEY  (`shopping_car_list_id`),
  KEY `type` (`type`),
  KEY `lang` (`lang`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;

-- 
-- 列出以下資料庫的數據： `datasetup_shopping_car_list`
-- 


-- --------------------------------------------------------

-- 
-- 資料表格式： `datasetup_sysmenu`
-- 

CREATE TABLE `datasetup_sysmenu` (
  `id` int(20) NOT NULL auto_increment,
  `lv` int(20) NOT NULL COMMENT '類似ID 判斷開關 辨識身份',
  `lang` varchar(10) NOT NULL default 'ch' COMMENT '語系',
  `floor` int(20) NOT NULL COMMENT '此分類階層',
  `sort` int(20) NOT NULL,
  `name` varchar(20) NOT NULL,
  `url` varchar(255) NOT NULL default '0',
  `selector` text COMMENT 'jQueryselector',
  `ifview` tinyint(1) NOT NULL,
  `parents` varchar(10) NOT NULL,
  `create_date` datetime NOT NULL,
  `update_date` datetime NOT NULL,
  `create_name` varchar(20) NOT NULL,
  `update_name` varchar(20) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=589 ;

-- 
-- 列出以下資料庫的數據： `datasetup_sysmenu`
-- 
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(84, 123, 'ch', 0, 6, '其他管理', '', '', 1, '0', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(83, 122, 'ch', 1, 2, '後台帳號群組清單', 'admin_group.php', '', 1, '120', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(81, 120, 'ch', 0, 5, '後台帳號管理', '', '', 1, '0', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(82, 121, 'ch', 1, 1, '後台帳號清單', 'admin.php', '', 1, '120', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(85, 124, 'ch', 1, 1, '使用者管理', 'self.php', '', 1, '123', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(86, 125, 'ch', 1, 5, '網站設定', 'setting.php', '', 1, '123', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(320, 293, 'ch', 0, 1, 'Step 1 類組設定', '', '', 1, '0', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(325, 298, 'ch', 1, 1, '一般類組設定', 'about.php?class=set_about', '', 1, '293', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(557, 503, 'ch', 1, 8, '會員相關設定', 'about.php?class=set_member&id=lang', '', 1, '293', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(558, 504, 'ch', 1, 9, '購物相關設定', 'about.php?class=set_shopping&id=lang', '', 1, '293', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(388, 342, 'ch', 1, 3, '商品類組設定 (products)', 'about.php?class=set_pro', '', 1, '293', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(444, 396, 'ch', 1, 6, 'smtp郵件伺服器', 'about.php?class=smtp_mail&id=lang', '', 1, '123', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(435, 387, 'ch', 0, 4, '頁面管理', '', '', 1, '0', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(424, 376, 'ch', 1, 4, '語系管理', 'language.php', '', 1, '123', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(425, 377, 'ch', 1, 2, '系統目錄管理', '_sysmenu_set.php', '', 1, '123', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(426, 378, 'ch', 1, 3, '後台操作記錄', 'system_temp.php', '', 1, '123', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(528, 477, 'ch', 1, 5, '表單模組設定', 'form_set.php', '', 1, '293', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(524, 473, 'ch', 0, 2, 'Step 2 版面設定', '', '', 1, '0', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(525, 474, 'ch', 1, 1, '主板塊設定', 'design.php?type=main', '', 1, '473', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(526, 475, 'ch', 1, 2, '子板塊設定', 'design.php?type=ban', '', 1, '473', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(527, 476, 'ch', 1, 3, '式樣設定', 'design.php?type=css', '', 1, '473', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(446, 398, 'ch', 1, 7, '主機網域跳轉設定', 'url_rewrite.php', '', 1, '123', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(539, 488, 'ch', 1, 15, '訂單信件訊息', 'about.php?class=paymail', '', 1, '387', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(540, 489, 'ch', 1, 16, '出貨信件訊息', 'about.php?class=cargomail', '', 1, '387', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(552, 498, 'ch', 1, 2, '商品分類設定 (category)', 'catemode.php', '', 1, '293', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(556, 502, 'ch', 1, 10, '目錄檔案管理', 'dir_manage.php', '', 1, '123', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(555, 501, 'ch', 1, 7, '各模組顯示設定', 'about.php?class=set_serback&id=lang', '', 1, '293', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(554, 500, 'ch', 1, 6, '圖片集模組設定', 'about.php?class=set_edm', '', 1, '293', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(559, 505, 'ch', 1, 6, '推薦組合模組設定', 'about.php?class=set_dataset', '', 1, '293', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(589, 535, 'ch', 1, 4, '錯誤代碼導向頁面', 'design.php?type=erro', '', 1, '473', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(590, 536, 'ch', 1, 5, '預設安裝樣板', 'example_ban.php', '', 1, '473', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(591, 537, 'ch', 0, 7, '後台選單管理', '', '', 1, '0', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(592, 538, 'ch', 1, 1, '選單設定', 'about.php?class=system_menu', '', 1, '537', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(593, 539, 'ch', 0, 8, '經銷商管理', '', '', 1, '0', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(594, 540, 'ch', 1, 1, '經銷商資料', 'about.php?class=dealers&id=lang', '', 1, '539', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(595, 541, 'ch', 1, 6, '安裝主題', 'skin_setup.php', '', 1, '473', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');
INSERT INTO `datasetup_sysmenu` (`id`, `lv`, `lang`, `floor`, `sort`, `name`, `url`, `selector`, `ifview`, `parents`, `create_date`, `update_date`, `create_name`, `update_name`) VALUES(596, 542, 'ch', 1, 10, '前台選單群組設定', 'about.php?class=set_menu', '', 1, '293', '0000-00-00 00:00:00', '2017-02-21 10:22:55', '', 'vipadmin');





CREATE TABLE IF NOT EXISTS `datasetup_exampleban` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `name` varchar(200) CHARACTER SET utf8 DEFAULT NULL,
  `b_name` text CHARACTER SET utf8,
  `detail` longtext CHARACTER SET utf8,
  `memo` longtext CHARACTER SET utf8,
  `sort` double DEFAULT '0',
  `status` int(11) DEFAULT '1',
  `create_date` datetime DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  `create_name` varchar(200) CHARACTER SET utf8 DEFAULT NULL,
  `update_name` varchar(200) CHARACTER SET utf8 DEFAULT NULL,
  `pic` text CHARACTER SET utf8 COMMENT '程式生成欄位',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;