H0v7cxJE

1CREATE TABLE IF NOT EXISTS `catalog_items` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `page_id` int(11) NOT NULL,
4  `item_ids` varchar(655) NOT NULL DEFAULT '',
5  `offer_id` int(11) NOT NULL DEFAULT -1,
6  `song_id` int(3) NOT NULL DEFAULT 0,
7  `order_number` int(3) NOT NULL DEFAULT 1,
8  `catalog_name` varchar(100) NOT NULL DEFAULT '',
9  `cost_credits` int(11) NOT NULL DEFAULT 4,
10  `cost_points` int(11) NOT NULL DEFAULT 0,
11  `points_type` int(3) NOT NULL DEFAULT 0,
12  `amount` int(11) NOT NULL DEFAULT 1,
13  `limited_sells` int(11) NOT NULL DEFAULT 0,
14  `limited_stack` int(11) NOT NULL DEFAULT 0,
15  `extradata` varchar(100) NOT NULL DEFAULT '',
16  `have_offer` enum('0','1') NOT NULL DEFAULT '1',
17  `club_only` enum('0','1') NOT NULL DEFAULT '0',
18  PRIMARY KEY (`id`)
19) ENGINE=InnoDB DEFAULT CHARSET=utf8;
20
21CREATE TABLE IF NOT EXISTS `catalog_pages` (
22  `id` int(11) NOT NULL AUTO_INCREMENT,
23  `parent_id` int(11) NOT NULL DEFAULT -1,
24  `caption_save` varchar(25) NOT NULL,
25  `caption` varchar(128) NOT NULL,
26  `icon_color` int(5) NOT NULL DEFAULT 1,
27  `icon_image` int(5) NOT NULL DEFAULT 1,
28  `visible` enum('0','1') NOT NULL DEFAULT '1',
29  `enabled` enum('0','1') NOT NULL DEFAULT '1',
30  `min_rank` int(2) NOT NULL DEFAULT 1,
31  `club_only` enum('0','1') NOT NULL DEFAULT '0',
32  `order_num` int(5) NOT NULL DEFAULT 1,
33  `page_layout` enum('default_3x3','club_buy','club_gift','frontpage','spaces','recycler','recycler_info','recycler_prizes','trophies','plasto','marketplace','marketplace_own_items','spaces_new','soundmachine','guilds','guild_furni','info_duckets','info_rentables','info_pets','roomads','single_bundle','sold_ltd_items','badge_display','bots','pets','pets2','pets3','productpage1','room_bundle','recent_purchases','default_3x3_color_grouping','guild_forum','vip_buy','info_loyalty','loyalty_vip_buy','collectibles','frontpage_featured') NOT NULL DEFAULT 'default_3x3',
34  `page_headline` varchar(1024) NOT NULL DEFAULT '',
35  `page_teaser` varchar(64) NOT NULL DEFAULT '',
36  `page_special` varchar(2048) NOT NULL DEFAULT '',
37  `page_text1` text NOT NULL,
38  `page_text2` text NOT NULL,
39  `page_text_details` text NOT NULL,
40  `page_text_teaser` text NOT NULL,
41  `vip_only` enum('0','1') NOT NULL DEFAULT '0',
42  `includes` varchar(32) NOT NULL DEFAULT '',
43  `room_id` varchar(255) NOT NULL DEFAULT '0',
44  PRIMARY KEY (`id`)
45) ENGINE=InnoDB DEFAULT CHARSET=utf8;
46
47CREATE TABLE IF NOT EXISTS `items_base` (
48  `id` int(11) NOT NULL AUTO_INCREMENT,
49  `sprite_id` int(11) NOT NULL,
50  `item_name` varchar(70) NOT NULL,
51  `public_name` varchar(56) NOT NULL,
52  `width` int(11) NOT NULL DEFAULT 1,
53  `length` int(11) NOT NULL DEFAULT 1,
54  `stack_height` double(4,2) NOT NULL DEFAULT 0.00,
55  `allow_stack` enum('0','1') NOT NULL DEFAULT '0',
56  `allow_sit` enum('0','1') NOT NULL DEFAULT '0',
57  `allow_lay` enum('0','1') NOT NULL DEFAULT '0',
58  `allow_walk` enum('0','1') NOT NULL DEFAULT '0',
59  `allow_gift` enum('0','1') NOT NULL DEFAULT '1',
60  `allow_trade` enum('0','1') NOT NULL DEFAULT '1',
61  `allow_recycle` enum('0','1') NOT NULL DEFAULT '0',
62  `allow_marketplace_sell` enum('0','1') NOT NULL DEFAULT '1',
63  `allow_inventory_stack` enum('0','1') NOT NULL DEFAULT '1',
64  `type` enum('s','i','e','h','v','r','b','p') NOT NULL DEFAULT 's',
65  `interaction_type` enum('default','gate','guild_furni','guild_gate','background_toner','badge_display','mannequin','ads_bg','trophy','vendingmachine','pressureplate','colorplate','multiheight','dice','colorwheel','cannon','teleport','teleporttile','crackable','crackable_master','nest','pet_drink','pet_food','pet_toy','breeding_nest','obstacle','monsterplant_seed','gift','stack_helper','puzzle_box','hopper','costume_hopper','club_hopper','club_gate','club_teleporttile','onewaygate','love_lock','clothing','roller','postit','dimmer','rentable_space','pyramid','musicdisc','fireworks','talking_furni','water_item','water','viking_cotie','tile_fxprovider_nfs','mutearea','information_terminal','external_image','youtube','jukebox','switch','fx_box','blackhole','effect_toggle','room_o_matic','effect_tile','sticky_pole','trap','tent','gym_equipment','handitem','handitem_tile','effect_giver','effect_vendingmachine','crackable_monster','snowboard_slope','timer','wf_trg_walks_on_furni','wf_trg_walks_off_furni','wf_trg_enter_room','wf_trg_says_something','wf_trg_periodically','wf_trg_period_long','wf_trg_state_changed','wf_trg_at_given_time','wf_trg_at_time_long','wf_trg_collision','wf_trg_game_starts','wf_trg_game_ends','wf_trg_bot_reached_stf','wf_trg_bot_reached_avtr','wf_trg_says_command','wf_trg_score_achieved','wf_trg_idles','wf_trg_unidles','wf_trg_starts_dancing','wf_trg_stops_dancing','wf_act_toggle_state','wf_act_reset_timers','wf_act_match_to_sshot','wf_act_move_rotate','wf_act_give_score','wf_act_show_message','wf_act_teleport_to','wf_act_join_team','wf_act_leave_team','wf_act_chase','wf_act_flee','wf_act_move_to_dir','wf_act_give_score_tm','wf_act_toggle_to_rnd','wf_act_move_furni_to','wf_act_give_reward','wf_act_call_stacks','wf_act_kick_user','wf_act_mute_triggerer','wf_act_bot_teleport','wf_act_bot_move','wf_act_bot_talk','wf_act_bot_give_handitem','wf_act_bot_follow_avatar','wf_act_bot_clothes','wf_act_bot_talk_to_avatar','wf_act_give_diamonds','wf_act_give_credits','wf_act_give_duckets','wf_act_give_badge','wf_act_forward_user','wf_act_roller_speed','wf_act_raise_furni','wf_act_lower_furni','wf_act_give_respect','wf_act_alert','wf_act_give_handitem','wf_act_match_to_sshot2','wf_act_give_effect','wf_cnd_has_furni_on','wf_cnd_furnis_hv_avtrs','wf_cnd_stuff_is','wf_cnd_actor_in_group','wf_cnd_user_count_in','wf_cnd_wearing_effect','wf_cnd_wearing_badge','wf_cnd_time_less_than','wf_cnd_match_snapshot','wf_cnd_time_more_than','wf_cnd_not_furni_on','wf_cnd_not_hv_avtrs','wf_cnd_not_stuff_is','wf_cnd_not_user_count','wf_cnd_not_wearing_fx','wf_cnd_not_wearing_b','wf_cnd_not_in_group','wf_cnd_not_in_team','wf_cnd_not_match_snap','wf_cnd_not_trggrer_on','wf_cnd_actor_in_team','wf_cnd_trggrer_on_frn','wf_cnd_has_handitem','wf_cnd_date_rng_active','wf_cnd_motto_contains','wf_cnd_battlebanzai','wf_cnd_not_battlebanzai','wf_cnd_freeze','wf_cnd_not_freeze','wf_cnd_habbo_has_rank','wf_cnd_habbo_not_rank','wf_cnd_habbo_has_diamonds','wf_cnd_habbo_has_credits','wf_cnd_habbo_has_duckets','wf_cnd_not_habbo_has_diamonds','wf_cnd_not_habbo_has_credits','wf_cnd_not_habbo_has_duckets','wf_cnd_habbo_owns_badge','wf_cnd_not_habbo_owns_badge','wf_cnd_habbo_is_dancing','wf_cnd_not_habbo_is_dancing','wf_xtra_random','wf_xtra_unseen','wf_blob','wf_highscore','battlebanzai_timer','battlebanzai_tile','battlebanzai_random_teleport','battlebanzai_sphere','battlebanzai_puck','battlebanzai_gate_blue','battlebanzai_gate_green','battlebanzai_gate_red','battlebanzai_gate_yellow','battlebanzai_counter_blue','battlebanzai_counter_green','battlebanzai_counter_red','battlebanzai_counter_yellow','freeze_block','freeze_tile','freeze_exit','freeze_timer','freeze_gate_blue','freeze_gate_green','freeze_gate_red','freeze_gate_yellow','freeze_counter_blue','freeze_counter_green','freeze_counter_red','freeze_counter_yellow','icetag_pole','icetag_field','bunnyrun_pole','bunnyrun_field','rollerskate_field','football','football_gate','football_counter_blue','football_counter_green','football_counter_red','football_counter_yellow','football_goal_blue','football_goal_green','football_goal_red','football_goal_yellow','snowstorm_tree','snowstorm_machine','snowstorm_pile') NOT NULL DEFAULT 'default',
66  `interaction_modes_count` int(11) NOT NULL DEFAULT 1,
67  `vending_ids` varchar(255) NOT NULL DEFAULT '0',
68  `multiheight` varchar(50) NOT NULL DEFAULT '0',
69  `customparams` varchar(256) NOT NULL DEFAULT '',
70  `effect_id_male` int(3) NOT NULL DEFAULT 0,
71  `effect_id_female` int(3) NOT NULL DEFAULT 0,
72  PRIMARY KEY (`id`)
73) ENGINE=InnoDB DEFAULT CHARSET=utf8;