· 9 years ago · Nov 04, 2016, 01:54 PM
1/*
2Navicat MySQL Data Transfer
3
4Source Server : arc
5Source Server Version : 100116
6Source Host : localhost:3306
7Source Database : arc
8
9Target Server Type : MYSQL
10Target Server Version : 100116
11File Encoding : 65001
12
13Date: 2016-11-04 14:50:24
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for catalog_pages
20-- ----------------------------
21DROP TABLE IF EXISTS `catalog_pages`;
22CREATE TABLE `catalog_pages` (
23 `id` int(11) NOT NULL AUTO_INCREMENT,
24 `parent_id` int(11) NOT NULL DEFAULT '-1',
25 `caption_save` varchar(25) NOT NULL DEFAULT '',
26 `caption` varchar(128) NOT NULL,
27 `icon_color` int(5) NOT NULL DEFAULT '1',
28 `icon_image` int(5) NOT NULL DEFAULT '1',
29 `visible` enum('0','1') NOT NULL DEFAULT '1',
30 `enabled` enum('0','1') NOT NULL DEFAULT '1',
31 `min_rank` int(2) NOT NULL DEFAULT '1',
32 `club_only` enum('0','1') NOT NULL DEFAULT '0',
33 `order_num` int(5) NOT NULL DEFAULT '1',
34 `page_layout` enum('default_3x3','club_buy','club_gift','frontpage','spaces','recycler','recycler_info','recycler_prizes','trophies','plasto','marketplace','marketplace_own_items','pets','spaces_new','soundmachine','guilds','guild_furni','info_duckets','info_rentables','info_pets','roomads','single_bundle','sold_ltd_items','badge_display','bots','pets2','pets3','productpage1','room_bundle','recent_purchases') NOT NULL DEFAULT 'default_3x3',
35 `page_headline` text NOT NULL,
36 `page_teaser` text NOT NULL,
37 `page_special` text NOT NULL,
38 `page_text1` text NOT NULL,
39 `page_text2` text NOT NULL,
40 `page_text_details` text NOT NULL,
41 `page_text_teaser` text NOT NULL,
42 `vip_only` enum('1','0') NOT NULL DEFAULT '0',
43 PRIMARY KEY (`id`)
44) ENGINE=MyISAM AUTO_INCREMENT=912364 DEFAULT CHARSET=latin1;
45SET FOREIGN_KEY_CHECKS=1;