table.sql

CREATE TABLE `products` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `text` text COLLATE utf8_unicode_ci,
  `price` float DEFAULT NULL,
  `vat` float DEFAULT NULL,
  `shipping_price` float DEFAULT NULL,
  `published` tinyint(1) DEFAULT NULL,
  `product_category_id` int(11) DEFAULT NULL,
  `size_1_stock` int(11) DEFAULT NULL,
  `size_2_stock` int(11) DEFAULT NULL,
  `size_3_stock` int(11) DEFAULT NULL,
  `model_size` int(11) DEFAULT NULL,
  `color` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `materials` text COLLATE utf8_unicode_ci,
  `small_desc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `text_en` text COLLATE utf8_unicode_ci,
  `materials_en` text COLLATE utf8_unicode_ci,
  `small_desc_en` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `position` int(11) DEFAULT '0',
  `outlet` tinyint(1) DEFAULT NULL,
  `rebate` float DEFAULT NULL,
  `image_id` int(11) DEFAULT NULL,
  `menu_color` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `available_a` tinyint(1) DEFAULT '1',
  `quantity_xxs` int(11) DEFAULT NULL,
  `quantity_xs` int(11) DEFAULT NULL,
  `quantity_s` int(11) DEFAULT NULL,
  `quantity_m` int(11) DEFAULT NULL,
  `quantity_l` int(11) DEFAULT NULL,
  `quantity_xl` int(11) DEFAULT NULL,
  `available_b` tinyint(1) DEFAULT '1',
  `quantity_44` int(11) DEFAULT NULL,
  `quantity_46` int(11) DEFAULT NULL,
  `quantity_48` int(11) DEFAULT NULL,
  `quantity_50` int(11) DEFAULT NULL,
  `quantity_52` int(11) DEFAULT NULL,
  `quantity_54` int(11) DEFAULT NULL,
  `available_c` tinyint(1) DEFAULT '1',
  `quantity_28` int(11) DEFAULT NULL,
  `quantity_29` int(11) DEFAULT NULL,
  `quantity_30` int(11) DEFAULT NULL,
  `quantity_31` int(11) DEFAULT NULL,
  `quantity_32` int(11) DEFAULT NULL,
  `quantity_33` int(11) DEFAULT NULL,
  `available_d` tinyint(1) DEFAULT '1',
  `quantity_56` int(11) DEFAULT NULL,
  `quantity_57` int(11) DEFAULT NULL,
  `quantity_58` int(11) DEFAULT NULL,
  `quantity_59` int(11) DEFAULT NULL,
  `quantity_60` int(11) DEFAULT NULL,
  `single_quantity` int(11) DEFAULT NULL,
  `subtitle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fullscreen` tinyint(1) DEFAULT '0',
  `collaborations` tinyint(1) DEFAULT '0',
  `new_arrivals` tinyint(1) DEFAULT '0',
  `book_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `book_collab` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `book_etudes_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `book_isbn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `metadata` text COLLATE utf8_unicode_ci,
  `weight` int(11) DEFAULT NULL,
  `quantity_34` int(11) DEFAULT NULL,
  `quantity_36` int(11) DEFAULT NULL,
  `current_stock_available` int(11) DEFAULT NULL,
  `on_demand` tinyint(1) DEFAULT NULL,
  `sku` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `hidden` tinyint(1) DEFAULT '0',
  `visits` int(11) DEFAULT '0',
  `quantity_42` int(11) DEFAULT NULL,
  `sku_quantity_xxs` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sku_quantity_xs` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sku_quantity_s` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sku_quantity_m` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sku_quantity_l` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sku_quantity_xl` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sku_quantity_44` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sku_quantity_46` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sku_quantity_48` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sku_quantity_50` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sku_quantity_52` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sku_quantity_54` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sku_quantity_28` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sku_quantity_29` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sku_quantity_30` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sku_quantity_31` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sku_quantity_32` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sku_quantity_33` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sku_quantity_34` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sku_quantity_36` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sku_quantity_42` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sku_quantity_56` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sku_quantity_57` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sku_quantity_58` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sku_quantity_59` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sku_quantity_60` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sku_single_quantity` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mobile` tinyint(1) DEFAULT NULL,
  `mobile_sorting` int(11) DEFAULT NULL,
  `available_e` tinyint(1) DEFAULT NULL,
  `quantity_37` int(11) DEFAULT NULL,
  `quantity_38` int(11) DEFAULT NULL,
  `quantity_39` int(11) DEFAULT NULL,
  `quantity_40` int(11) DEFAULT NULL,
  `quantity_41` int(11) DEFAULT NULL,
  `quantity_43` int(11) DEFAULT NULL,
  `quantity_45` int(11) DEFAULT NULL,
  `sku_quantity_37` int(11) DEFAULT NULL,
  `sku_quantity_38` int(11) DEFAULT NULL,
  `sku_quantity_39` int(11) DEFAULT NULL,
  `sku_quantity_40` int(11) DEFAULT NULL,
  `sku_quantity_41` int(11) DEFAULT NULL,
  `sku_quantity_43` int(11) DEFAULT NULL,
  `sku_quantity_45` int(11) DEFAULT NULL,
  `api_id` int(11) DEFAULT NULL,
  `custom_shipping` float DEFAULT NULL,
  `currencies` text COLLATE utf8_unicode_ci,
  `value_cents` int(11) NOT NULL DEFAULT '0',
  `value_currency` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'EUR',
  `home` tinyint(1) DEFAULT '0',
  `home_position` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `title` (`title`)
) ENGINE=MyISAM AUTO_INCREMENT=45125 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;