QzbsNJi9

1-- ----------------------------
2-- Table structure for furniture
3-- ----------------------------
4DROP TABLE IF EXISTS `furniture`;
5CREATE TABLE `furniture` (
6  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
7  `item_name` varchar(70) NOT NULL,
8  `public_name` varchar(56) NOT NULL DEFAULT '',
9  `type` enum('s','i','e','h','v','r','b','p') NOT NULL DEFAULT 's',
10  `width` int(11) NOT NULL DEFAULT '1',
11  `length` int(11) NOT NULL DEFAULT '1',
12  `stack_height` double NOT NULL DEFAULT '0',
13  `can_stack` enum('0','1') NOT NULL DEFAULT '1',
14  `can_sit` enum('0','1') NOT NULL DEFAULT '0',
15  `is_walkable` enum('0','1') NOT NULL DEFAULT '0',
16  `sprite_id` int(11) NOT NULL DEFAULT '0',
17  `allow_recycle` enum('0','1') NOT NULL DEFAULT '1',
18  `allow_trade` enum('0','1') NOT NULL DEFAULT '1',
19  `allow_marketplace_sell` enum('0','1') NOT NULL DEFAULT '1',
20  `allow_gift` enum('0','1') NOT NULL DEFAULT '1',
21  `allow_inventory_stack` enum('0','1') NOT NULL DEFAULT '1',
22  `interaction_type` varchar(25) NOT NULL DEFAULT 'default',
23  `interaction_modes_count` int(11) NOT NULL DEFAULT '1',
24  `vending_ids` varchar(255) NOT NULL DEFAULT '0',
25  `height_adjustable` varchar(50) NOT NULL DEFAULT '0',
26  `effect_id` int(3) NOT NULL DEFAULT '0',
27  `wired_id` int(11) NOT NULL DEFAULT '0',
28  `is_rare` enum('0','1') NOT NULL DEFAULT '0',
29  `clothing_id` int(11) NOT NULL DEFAULT '0',
30  `extra_rot` enum('0','1') NOT NULL DEFAULT '0',
31  PRIMARY KEY (`id`),
32  UNIQUE KEY `id` (`id`) USING BTREE,
33  KEY `sprite_id` (`sprite_id`) USING BTREE
34) ENGINE=InnoDB AUTO_INCREMENT=1000000186 DEFAULT CHARSET=latin1;