N4YHWpNF

1
2#
3# Structure for table "items_base"
4#
5
6DROP TABLE IF EXISTS `items_base`;
7CREATE TABLE `items_base` (
8  `id` int(11) unsigned NOT NULL,
9  `item_name` varchar(70) NOT NULL,
10  `public_name` varchar(56) NOT NULL DEFAULT '',
11  `type` enum('s','i','e','h','v','r','b','p') NOT NULL DEFAULT 's',
12  `width` int(11) NOT NULL DEFAULT '1',
13  `length` int(11) NOT NULL DEFAULT '1',
14  `stack_height` double(4,2) NOT NULL DEFAULT '0.00',
15  `allow_stack` enum('0','1') NOT NULL DEFAULT '0',
16  `allow_sit` enum('0','1') NOT NULL DEFAULT '0',
17  `allow_walk` enum('0','1') NOT NULL DEFAULT '0',
18  `sprite_id` int(11) NOT NULL DEFAULT '0',
19  `allow_recycle` enum('0','1') NOT NULL DEFAULT '0',
20  `allow_trade` enum('0','1') NOT NULL DEFAULT '1',
21  `allow_marketplace_sell` enum('0','1') NOT NULL DEFAULT '1',
22  `allow_gift` enum('0','1') NOT NULL DEFAULT '1',
23  `allow_inventory_stack` enum('0','1') NOT NULL DEFAULT '1',
24  `interaction_type` enum('default','crafting','pet','landscape','gate','wallpaper','floor','guild_forum','scoreboard','bottle','bed','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',
25  `interaction_modes_count` int(11) NOT NULL DEFAULT '1',
26  `multiheight` varchar(1000) DEFAULT NULL,
27  `vending_ids` varchar(255) NOT NULL DEFAULT '',
28  `effect_id` int(3) NOT NULL DEFAULT '0',
29  `wired_id` int(11) NOT NULL DEFAULT '0',
30  `is_rare` enum('0','1') NOT NULL DEFAULT '0',
31  `clothing_id` int(11) NOT NULL DEFAULT '0',
32  `extra_rot` enum('0','1') NOT NULL DEFAULT '0',
33  `customparams` varchar(256) NOT NULL DEFAULT '',
34  `allow_lay` enum('0','1') NOT NULL DEFAULT '0',
35  `effect_id_male` int(3) NOT NULL DEFAULT '0',
36  `effect_id_female` int(3) NOT NULL DEFAULT '0',
37  PRIMARY KEY (`id`,`effect_id_male`) USING BTREE
38) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
39
40#
41# Data for table "items_base"
42#
43
44INSERT INTO `items_base` VALUES (40035,'ads_mpu_300','Neon Left Arrow','s',1,1,1.00,'1','0','1',4069,'1','1','1','1','1','default',1,'','0',0,0,'1',0,'0','','0',0,0),(300003,'ads_mpu_720','Square Glass Window','s',1,1,1.00,'1','0','1',4036,'1','1','1','1','1','default',1,'','0',0,0,'1',0,'0','','0',0,0);