· 8 years ago · Jun 09, 2018, 10:14 AM
1
2CREATE TABLE IF NOT EXISTS `catalog_pages` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `parent_id` int(11) NOT NULL DEFAULT '-1',
5 `caption` varchar(100) NOT NULL,
6 `icon_color` int(11) NOT NULL DEFAULT '1',
7 `icon_image` int(11) NOT NULL DEFAULT '1',
8 `visible` enum('0','1') NOT NULL DEFAULT '1',
9 `enabled` enum('0','1') NOT NULL DEFAULT '1',
10 `min_rank` int(10) unsigned NOT NULL DEFAULT '1',
11 `club_only` enum('0','1') NOT NULL DEFAULT '0',
12 `coming_soon` enum('0','1') NOT NULL DEFAULT '0',
13 `order_num` int(11) NOT NULL,
14 `page_layout` enum('default_3x3','frontpage','spaces','recycler','recycler_info','recycler_prizes','trophies','plasto','marketplace','marketplace_own_ite ms','pets','pets2') NOT NULL DEFAULT 'default_3x3',
15 `page_headline` text NOT NULL,
16 `page_teaser` text NOT NULL,
17 `page_special` text NOT NULL,
18 `page_text1` text NOT NULL,
19 `page_text2` text NOT NULL,
20 `page_text_details` text NOT NULL,
21 `page_text_teaser` text NOT NULL,
22 PRIMARY KEY (`id`)
23) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=146 ;