1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90
|
--
-- Structure de la table `ps_category_lang`
--
CREATE TABLE IF NOT EXISTS `ps_category_lang` (
`id_category` int(10) unsigned NOT NULL,
`id_lang` int(10) unsigned NOT NULL,
`name` varchar(128) NOT NULL,
`description` text,
`link_rewrite` varchar(128) NOT NULL,
`meta_title` varchar(128) DEFAULT NULL,
`meta_keywords` varchar(255) DEFAULT NULL,
`meta_description` varchar(255) DEFAULT NULL,
UNIQUE KEY `category_lang_index` (`id_category`,`id_lang`),
KEY `category_name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Structure de la table `ps_product`
--
CREATE TABLE IF NOT EXISTS `ps_product` (
`id_product` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_supplier` int(10) unsigned DEFAULT NULL,
`id_manufacturer` int(10) unsigned DEFAULT NULL,
`id_tax` int(10) unsigned NOT NULL,
`id_category_default` int(10) unsigned DEFAULT NULL,
`id_color_default` int(10) unsigned DEFAULT NULL,
`on_sale` tinyint(1) unsigned NOT NULL DEFAULT '0',
`ean13` varchar(13) DEFAULT NULL,
`ecotax` decimal(17,2) NOT NULL DEFAULT '0.00',
`quantity` int(10) unsigned NOT NULL DEFAULT '0',
`price` decimal(20,6) NOT NULL DEFAULT '0.000000',
`wholesale_price` decimal(20,6) NOT NULL DEFAULT '0.000000',
`reduction_price` decimal(17,2) DEFAULT NULL,
`reduction_percent` float DEFAULT NULL,
`reduction_from` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
`reduction_to` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
`reference` varchar(32) DEFAULT NULL,
`supplier_reference` varchar(32) DEFAULT NULL,
`location` varchar(64) DEFAULT NULL,
`weight` float NOT NULL DEFAULT '0',
`out_of_stock` int(10) unsigned NOT NULL DEFAULT '2',
`quantity_discount` tinyint(1) DEFAULT '0',
`customizable` tinyint(2) NOT NULL DEFAULT '0',
`uploadable_files` tinyint(4) NOT NULL DEFAULT '0',
`text_fields` tinyint(4) NOT NULL DEFAULT '0',
`active` tinyint(1) unsigned NOT NULL DEFAULT '0',
`indexed` tinyint(1) NOT NULL DEFAULT '0',
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
`video` varchar(255) DEFAULT NULL,
`en_avant` int(11) NOT NULL DEFAULT '0',
`en_avant_fournisseur` int(11) NOT NULL DEFAULT '999',
`en_avant_metier` int(11) NOT NULL DEFAULT '999',
`en_avant_application` int(11) NOT NULL DEFAULT '999',
PRIMARY KEY (`id_product`),
KEY `product_supplier` (`id_supplier`),
KEY `product_manufacturer` (`id_manufacturer`),
KEY `id_tax` (`id_tax`),
KEY `id_category_default` (`id_category_default`),
KEY `id_color_default` (`id_color_default`),
KEY `date_add` (`date_add`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2125 ;
-- --------------------------------------------------------
--
-- Structure de la table `ps_product_lang`
--
CREATE TABLE IF NOT EXISTS `ps_product_lang` (
`id_product` int(10) unsigned NOT NULL,
`id_lang` int(10) unsigned NOT NULL,
`description` text,
`description_short` text,
`link_rewrite` varchar(128) NOT NULL,
`meta_description` varchar(255) DEFAULT NULL,
`meta_keywords` varchar(255) DEFAULT NULL,
`meta_title` varchar(128) DEFAULT NULL,
`name` varchar(128) NOT NULL,
`available_now` varchar(255) DEFAULT NULL,
`available_later` varchar(255) DEFAULT NULL,
UNIQUE KEY `product_lang_index` (`id_product`,`id_lang`),
KEY `id_lang` (`id_lang`),
KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
Partager