Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- ----------------------------
- -- Table structure for `catalog_items`
- -- ----------------------------
- DROP TABLE IF EXISTS `catalog_items`;
- CREATE TABLE `catalog_items` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `page_id` int(11) NOT NULL,
- `item_ids` varchar(120) NOT NULL,
- `catalog_name` varchar(100) NOT NULL,
- `cost_credits` int(11) NOT NULL,
- `cost_pixels` int(11) NOT NULL,
- `cost_snow` int(11) NOT NULL DEFAULT '0',
- `amount` int(11) NOT NULL,
- `vip` enum('0','1','2') NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM AUTO_INCREMENT=4294967296 DEFAULT CHARSET=latin1;
- ============================================================================
- CREATE TABLE `catalog_pages` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `parent_id` int(11) NOT NULL DEFAULT '-1',
- `caption` varchar(100) NOT NULL,
- `icon_color` int(11) NOT NULL DEFAULT '1',
- `icon_image` int(11) NOT NULL DEFAULT '1',
- `visible` enum('0','1') NOT NULL DEFAULT '1',
- `enabled` enum('0','1') NOT NULL DEFAULT '1',
- `min_rank` int(10) unsigned NOT NULL DEFAULT '1',
- `club_only` enum('0','1') NOT NULL DEFAULT '0',
- `order_num` int(11) NOT NULL,
- `page_layout` enum('default_3x3','frontpage','spaces','recycler','recycler_info','recycler_prizes','trophies','plasto','marketplace','marketplace_own_items','pets','pets2','club_buy','club_gifts') NOT NULL DEFAULT 'default_3x3',
- `page_headline` text NOT NULL,
- `page_teaser` text NOT NULL,
- `page_special` text NOT NULL,
- `page_text1` text NOT NULL,
- `page_text2` text NOT NULL,
- `page_text_details` text NOT NULL,
- `page_text_teaser` text NOT NULL,
- `vip_only` enum('1','0') NOT NULL DEFAULT '0',
- `page_link_description` text NOT NULL,
- `page_link_pagename` text NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM AUTO_INCREMENT=901 DEFAULT CHARSET=latin1;
- ===================================================================
- CREATE TABLE `furniture` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `public_name` varchar(100) NOT NULL COMMENT 'temp only',
- `item_name` varchar(100) NOT NULL,
- `type` enum('s','i','e','h','v') NOT NULL DEFAULT 's',
- `width` int(11) NOT NULL DEFAULT '1',
- `length` int(11) NOT NULL DEFAULT '1',
- `stack_height` double NOT NULL DEFAULT '1',
- `can_stack` enum('0','1') NOT NULL DEFAULT '1',
- `can_sit` enum('0','1') NOT NULL DEFAULT '0',
- `is_walkable` enum('0','1') NOT NULL DEFAULT '0',
- `sprite_id` int(11) NOT NULL,
- `allow_recycle` enum('0','1') NOT NULL DEFAULT '1',
- `allow_trade` enum('0','1') NOT NULL DEFAULT '1',
- `allow_marketplace_sell` enum('0','1') NOT NULL DEFAULT '1',
- `allow_gift` enum('0','1') NOT NULL DEFAULT '1',
- `allow_inventory_stack` enum('0','1') NOT NULL DEFAULT '1',
- `interaction_type` enum('default','gate','postit','roomeffect','dimmer','trophy','bed','scoreboard','vendingmachine','alert','onewaygate','loveshuffler','habbowheel','dice','bottle','teleport','rentals','pet','roller','water','ball','bb_red_gate','bb_green_gate','bb_yellow_gate','bb_puck','bb_blue_gate','bb_patch','bb_teleport','blue_score','green_score','red_score','yellow_score','fbgate','tagpole','counter','red_goal','blue_goal','yellow_goal','green_goal','wired','wf_trg_onsay','wf_act_saymsg','wf_trg_enterroom','wf_act_moveuser','wf_act_togglefurni','wf_trg_furnistate','wf_trg_onfurni','pressure_pad','wf_trg_offfurni','wf_trg_gameend','wf_trg_gamestart','wf_trg_timer','wf_act_givepoints','wf_trg_attime','wf_trg_atscore','wf_act_moverotate','rollerskate','stickiepole','wf_xtra_random','wf_cnd_trggrer_on_frn','wf_cnd_furnis_hv_avtrs','wf_act_matchfurni','wf_cnd_has_furni_on','puzzlebox','switch') DEFAULT 'default',
- `interaction_modes_count` int(11) NOT NULL DEFAULT '1',
- `vending_ids` varchar(100) NOT NULL DEFAULT '0',
- `is_arrow` enum('0','1') NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM AUTO_INCREMENT=3568407 DEFAULT CHARSET=latin1;
- -- ------
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement