|
Autor: yamen Ellouze
|
Datum: 4-02-10 11:48:55
|
| |
INSERT INTO `tt_products` (`uid`, `pid`, `tstamp`, `crdate`, `cruser_id`, `sorting`, `deleted`, `hidden`, `starttime`, `endtime`, `fe_group`, `title`, `subtitle`, `prod_uid`, `related_uid`, `itemnumber`, `ean`, `price`, `price2`, `note`, `note2`, `note_uid`, `unit`, `unit_factor`, `image`, `datasheet`, `www`, `category`, `address`, `inStock`, `tax`, `weight`, `bulkily`, `offer`, `highlight`, `directcost`, `color`, `color2`, `color3`, `size`, `size2`, `size3`, `description`, `gradings`, `material`, `quality`, `additional_type`, `additional`, `special_preparation`, `shipping`, `shipping2`, `handling`, `delivery`, `sellstarttime`, `sellendtime`, `accessory_uid`, `dam_uid`, `graduated_price_uid`, `article_uid`, `text_uid`, `damcat`, `basketminquantity`, `tax_id`, `usebydate`, `bargain`) VALUES (95, 58, 1265273920, 1265193431, 0, 0, 0, 0, 0, 0, 0, 'Test Produkt', '', 0, 0, '', '', 10.00, 0.00, '', '', 0, '', '1', '', '', '', 0, 0, 1, 0.00, 0.000000, 0, 0, 0, 0.00, 'R;G;B', '', '', '', '', '', '', '', '', '', '', '<?xml version="1.0" encoding="iso-8859-1" standalone="yes" ?>\n<T3FlexForms>\n <data>\n <sheet index="sDEF">\n <language index="lDEF">\n <field index="isSingle">\n <value index="vDEF">0</value>\n </field>\n <field index="isImage">\n <value index="vDEF">0</value>\n </field>\n <field index="alwaysInStock">\n <value index="vDEF">0</value>\n </field>\n <field index="noMinPrice">\n <value index="vDEF">0</value>\n </field>\n <field index="noGiftService">\n <value index="vDEF">0</value>\n </field>\n </language>\n </sheet>\n </data>\n</T3FlexForms>', 0, 0.00, 0.00, 0.00, 0, 0, 0, 0, 0, 0, 5, 0, 0, 0.00, 1, 0, 0);
INSERT INTO `tt_products_articles` (`uid`, `pid`, `tstamp`, `crdate`, `cruser_id`, `sorting`, `t3ver_oid`, `t3ver_id`, `t3ver_label`, `deleted`, `hidden`, `starttime`, `endtime`, `fe_group`, `title`, `subtitle`, `itemnumber`, `price`, `price2`, `note`, `image`, `inStock`, `weight`, `color`, `color2`, `color3`, `size`, `size2`, `size3`, `description`, `gradings`, `material`, `quality`, `uid_product`, `basketminquantity`, `config_type`, `config`) VALUES (90, 58, 1265231927, 1265231927, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 'Stick', '', '', 3.00, 0.00, '', '', 1, 0.000000, '', '', '', '', '', '', '', '', '', 'Stick', 0, 0.00, '', '<?xml version="1.0" encoding="iso-8859-1" standalone="yes" ?>\n<T3FlexForms>\n <data>\n <sheet index="sDEF">\n <language index="lDEF">\n <field index="isAddedPrice">\n <value index="vDEF">1</value>\n </field>\n </language>\n </sheet>\n </data>\n</T3FlexForms>'),
(89, 58, 1265271974, 1265223358, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 'L', '', '', 5.00, 0.00, '', '', 1, 0.000000, '', '', '', 'L', '', '', '', '', '', '', 0, 0.00, '', '<?xml version="1.0" encoding="iso-8859-1" standalone="yes" ?>\n<T3FlexForms>\n <data>\n <sheet index="sDEF">\n <language index="lDEF">\n <field index="isAddedPrice">\n <value index="vDEF">1</value>\n </field>\n </language>\n </sheet>\n </data>\n</T3FlexForms>'),
(88, 58, 1265271974, 1265193710, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 'S', '', '', 0.00, 0.00, '', '', 1, 0.000000, 'R;G;B', '', '', 'S', '', '', '', '', '', '', 0, 0.00, '', '<?xml version="1.0" encoding="iso-8859-1" standalone="yes" ?>\n<T3FlexForms>\n <data>\n <sheet index="sDEF">\n <language index="lDEF">\n <field index="isAddedPrice">\n <value index="vDEF">1</value>\n </field>\n </language>\n </sheet>\n </data>\n</T3FlexForms>'),
(87, 58, 1265271974, 1265193710, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 'XL', '', '', 10.00, 0.00, '', '', 1, 0.000000, '', '', '', 'XL', '', '', '', '', '', '', 0, 0.00, '', '<?xml version="1.0" encoding="iso-8859-1" standalone="yes" ?>\n<T3FlexForms>\n <data>\n <sheet index="sDEF">\n <language index="lDEF">\n <field index="isAddedPrice">\n <value index="vDEF">1</value>\n </field>\n </language>\n </sheet>\n </data>\n</T3FlexForms>');
INSERT INTO `tt_products_products_mm_articles` (`uid`, `pid`, `tstamp`, `crdate`, `deleted`, `hidden`, `uid_local`, `uid_foreign`, `tablenames`, `sorting`, `articlesort`) VALUES (56, 58, 1265231927, 1265231927, 0, 0, 95, 90, '', 5, 0),
(55, 58, 1265223358, 1265223358, 0, 0, 95, 89, '', 2, 0),
(54, 58, 1265193710, 1265193710, 0, 0, 95, 88, '', 1, 0),
(53, 58, 1265193710, 1265193710, 0, 0, 95, 87, '', 3, 0);
|
| |
|
