Show create table items

gistfile1.txt

*************************** 1. row ***************************
       Table: items
Create Table: CREATE TABLE `items` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) default NULL,
  `description` text,
  `user_id` int(11) default NULL,
  `listed_at` datetime default NULL,
  `suspended_at` datetime default NULL,
  `expires_at` datetime default NULL,
  `status` enum('draft','forsale','suspended','complete','delisted','deleted','restricted') default 'draft',
  `listing_length` int(11) default NULL,
  `itemtype` enum('handmade','material') default 'handmade',
  `hidden` tinyint(1) default '0',
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  `primary_image` varchar(255) default NULL,
  `default_currency_id` int(11) default NULL,
  `tags_cache` text,
  `views` int(11) default '0',
  `shop_section_id` int(11) default NULL,
  `shop_id` int(11) default NULL,
  `price` decimal(8,2) default NULL,
  `quantity` int(11) default NULL,
  `category_id` int(11) default NULL,
  `subcategory_id` int(11) default NULL,
  `new_subcategory_id` int(11) default NULL,
  `inspiration` text,
  `made_on` date default NULL,
  `place_id` int(11) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`,`listed_at`),
  KEY `index_items_on_user_id` (`user_id`),
  KEY `listed_at` (`listed_at`),
  KEY `expires_at` (`expires_at`),
  KEY `status` (`status`),
  KEY `user_id` (`user_id`,`listed_at`),
  KEY `status_itemtype` (`status`,`itemtype`),
  KEY `items_shop_and_shop_section_index` (`shop_id`,`shop_section_id`),
  KEY `shop_section_id_index_2` (`shop_section_id`),
  KEY `created_at_index` (`created_at`),
  KEY `index_items_on_default_currency_id` (`default_currency_id`),
  KEY `index_items_on_category_id` (`category_id`),
  KEY `index_items_on_subcategory_id` (`subcategory_id`),
  KEY `index_items_on_new_subcategory_id` (`new_subcategory_id`),
  KEY `index_items_on_place_id` (`place_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2748851 DEFAULT CHARSET=utf8
1 row in set (0.00 sec)