· 9 years ago · Nov 04, 2016, 07:22 PM
1-- ----------------------------
2-- Table structure for `catalog_pages`
3-- ----------------------------
4DROP TABLE IF EXISTS `catalog_pages`;
5CREATE TABLE `catalog_pages` (
6 `id` int(11) NOT NULL AUTO_INCREMENT,
7 `parent_id` int(11) NOT NULL DEFAULT '-1',
8 `caption` varchar(35) NOT NULL,
9 `icon_image` int(11) NOT NULL DEFAULT '1',
10 `visible` enum('0','1') NOT NULL DEFAULT '1',
11 `enabled` enum('0','1') NOT NULL DEFAULT '1',
12 `min_rank` int(11) unsigned NOT NULL DEFAULT '1',
13 `min_vip` int(11) NOT NULL DEFAULT '0',
14 `order_num` int(11) NOT NULL,
15 `page_link` varchar(35) NOT NULL DEFAULT '',
16 `page_layout` varchar(35) NOT NULL DEFAULT 'default_3x3',
17 `page_strings_1` text NOT NULL,
18 `page_strings_2` text NOT NULL,
19 PRIMARY KEY (`id`),
20 UNIQUE KEY `id` (`id`) USING BTREE,
21 KEY `order_num` (`order_num`) USING BTREE
22) ENGINE=InnoDB AUTO_INCREMENT=696923122 DEFAULT CHARSET=latin1;