CREATE TABLE `furniture` (
  `id` int(6) UNSIGNED NOT NULL,
  `public_name` varchar(255) NOT NULL,
  `item_name` varchar(255) NOT NULL,
  `type` enum('s','i','e','h','v','r') NOT NULL DEFAULT 's',
  `width` int(11) NOT NULL DEFAULT '1',
  `length` int(11) NOT NULL DEFAULT '1',
  `stack_height` varchar(255) 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('1','0') 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 '0',
  `allow_inventory_stack` enum('0','1') NOT NULL DEFAULT '0',
  `interaction_type` varchar(50) NOT NULL DEFAULT 'default',
  `interaction_modes_count` int(2) NOT NULL DEFAULT '1',
  `vending_ids` varchar(20) NOT NULL DEFAULT '0',
  `is_arrow` enum('0','1') NOT NULL DEFAULT '0',
  `foot_figure` enum('0','1') NOT NULL DEFAULT '0',
  `stack_multiplier` enum('0','1') NOT NULL DEFAULT '0',
  `subscriber` enum('0','1') NOT NULL DEFAULT '0',
  `effect_id` int(11) NOT NULL DEFAULT '0',
  `variable_heights` varchar(100) NOT NULL DEFAULT '0',
  `flat_id` int(11) NOT NULL DEFAULT '-1',
  `revision` int(11) NOT NULL DEFAULT '49500',
  `description` varchar(255) NOT NULL DEFAULT '',
  `specialtype` int(11) NOT NULL DEFAULT '1',
  `canlayon` enum('1','0') NOT NULL DEFAULT '0',
  `requires_rights` enum('1','0') DEFAULT '1',
  `song_id` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;