-- phpMyAdmin SQL Dump
-- version 2.11.6
--
http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Mar 09 Décembre 2008 à 14:26
-- Version du serveur: 5.0.51
-- Version de PHP: 5.2.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Base de données: `prestanew`
--
-- --------------------------------------------------------
--
-- Structure de la table `ps_product`
--
CREATE TABLE `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(10,2) NOT NULL default '0.00',
`quantity` int(10) unsigned NOT NULL default '0',
`price` decimal(13,6) NOT NULL default '0.000000',
`wholesale_price` decimal(13,6) NOT NULL default '0.000000',
`reduction_price` decimal(10,2) default NULL,
`reduction_percent` float default NULL,
`reduction_from` date default NULL,
`reduction_to` date default NULL,
`reference` varchar(32) default NULL,
`supplier_reference` varchar(32) default NULL,
`weight` float NOT NULL default '0',
`out_of_stock` int(10) unsigned NOT NULL default '2',
`quantity_discount` tinyint(1) default '0',
`active` tinyint(1) unsigned NOT NULL default '0',
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
PRIMARY KEY (`id_product`),
KEY `product_supplier` (`id_supplier`),
KEY `product_manufacturer` (`id_manufacturer`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
--
-- Contenu de la table `ps_product`
--
UPDATE `ps_product` SET `id_product` = 1,`id_supplier` = 1,`id_manufacturer` = 1,`id_tax` = 1,`id_category_default` = 2,`id_color_default` = 2,`on_sale` = 0,`ean13` = '0',`ecotax` = '0.00',`quantity` = 100,`price` = '174.749200',`wholesale_price` = '92.000000',`reduction_price` = '0.00',`reduction_percent` = 10,`reduction_from` = '2008-12-09',`reduction_to` = '2008-12-09',`reference` = '',`supplier_reference` = NULL,`weight` = 0.5,`out_of_stock` = 2,`quantity_discount` = 0,`active` = 1,`date_add` = '2008-12-09 13:23:03',`date_upd` = '2008-12-09 13:23:03' WHERE `ps_product`.`id_product` = 1;
UPDATE `ps_product` SET `id_product` = 2,`id_supplier` = 1,`id_manufacturer` = 1,`id_tax` = 1,`id_category_default` = 2,`id_color_default` = 0,`on_sale` = 0,`ean13` = '0',`ecotax` = '0.00',`quantity` = 12,`price` = '66.053500',`wholesale_price` = '33.000000',`reduction_price` = '0.00',`reduction_percent` = 0,`reduction_from` = '2008-12-09',`reduction_to` = '2008-12-09',`reference` = '',`supplier_reference` = NULL,`weight` = 0,`out_of_stock` = 2,`quantity_discount` = 0,`active` = 1,`date_add` = '2008-12-09 13:23:03',`date_upd` = '2008-12-09 13:23:03' WHERE `ps_product`.`id_product` = 2;
UPDATE `ps_product` SET `id_product` = 5,`id_supplier` = 1,`id_manufacturer` = 1,`id_tax` = 1,`id_category_default` = 4,`id_color_default` = 0,`on_sale` = 0,`ean13` = '0',`ecotax` = '0.00',`quantity` = 274,`price` = '1504.180602',`wholesale_price` = '1000.000000',`reduction_price` = '0.00',`reduction_percent` = 0,`reduction_from` = '2008-12-09',`reduction_to` = '2008-12-09',`reference` = '',`supplier_reference` = NULL,`weight` = 1.36,`out_of_stock` = 2,`quantity_discount` = 0,`active` = 1,`date_add` = '2008-12-09 13:23:03',`date_upd` = '2008-12-09 13:23:03' WHERE `ps_product`.`id_product` = 5;
UPDATE `ps_product` SET `id_product` = 6,`id_supplier` = 1,`id_manufacturer` = 1,`id_tax` = 1,`id_category_default` = 4,`id_color_default` = 0,`on_sale` = 0,`ean13` = '0',`ecotax` = '0.00',`quantity` = 250,`price` = '1170.568561',`wholesale_price` = '0.000000',`reduction_price` = '0.00',`reduction_percent` = 0,`reduction_from` = '2008-12-09',`reduction_to` = '2008-12-09',`reference` = '',`supplier_reference` = NULL,`weight` = 0.75,`out_of_stock` = 2,`quantity_discount` = 0,`active` = 1,`date_add` = '2008-12-09 13:23:03',`date_upd` = '2008-12-09 13:23:03' WHERE `ps_product`.`id_product` = 6;
UPDATE `ps_product` SET `id_product` = 7,`id_supplier` = 0,`id_manufacturer` = 0,`id_tax` = 1,`id_category_default` = 2,`id_color_default` = 0,`on_sale` = 0,`ean13` = '',`ecotax` = '0.00',`quantity` = 180,`price` = '241.638796',`wholesale_price` = '200.000000',`reduction_price` = '0.00',`reduction_percent` = 0,`reduction_from` = '2008-12-09',`reduction_to` = '2008-12-09',`reference` = '',`supplier_reference` = NULL,`weight` = 0,`out_of_stock` = 2,`quantity_discount` = 0,`active` = 1,`date_add` = '2008-04-07 15:27:01',`date_upd` = '2008-04-07 16:18:23' WHERE `ps_product`.`id_product` = 7;
UPDATE `ps_product` SET `id_product` = 8,`id_supplier` = 0,`id_manufacturer` = 0,`id_tax` = 1,`id_category_default` = 3,`id_color_default` = 0,`on_sale` = 0,`ean13` = '',`ecotax` = '0.00',`quantity` = 1,`price` = '25.041806',`wholesale_price` = '0.000000',`reduction_price` = '0.00',`reduction_percent` = 0,`reduction_from` = '2008-12-09',`reduction_to` = '2008-12-09',`reference` = '',`supplier_reference` = NULL,`weight` = 0,`out_of_stock` = 2,`quantity_discount` = 0,`active` = 1,`date_add` = '2008-04-07 17:09:52',`date_upd` = '2008-04-07 17:28:56' WHERE `ps_product`.`id_product` = 8;
UPDATE `ps_product` SET `id_product` = 9,`id_supplier` = 2,`id_manufacturer` = 2,`id_tax` = 1,`id_category_
Partager