Witam serdecznie,
Od jakiegoś czasu próbuje uporać się z problemem wyczyszczenia wszystkich
danych odnośnie zamówień. Mimo moich wszelkich prób kończy się na tym, że
nowe zamówienia zamiast zaczynać się od id1 zaczynają się np. od id18 a przez
to generowane faktury mają nazwy typu 000018.pdf.
Czy istnieje prosta opcja wyzerowania bazy danych tak aby nowe zamówienia
zaczynały się od numeru 1 ?
Znalazłem taki kod na forum:
TRUNCATE TABLE `ps_address` ;
TRUNCATE TABLE `ps_alias`;
TRUNCATE TABLE `ps_attribute`;
TRUNCATE TABLE `ps_attribute_group`;
TRUNCATE TABLE `ps_attribute_group_lang`;
TRUNCATE TABLE `ps_attribute_impact`;
TRUNCATE TABLE `ps_attribute_lang`;
delete FROM `ps_category` WHERE `id_category` <> 1;
delete FROM `ps_category_group` WHERE `id_category` <> 1;
delete FROM `ps_category_lang` WHERE `id_category` <> 1;
TRUNCATE TABLE `ps_category_product`;
TRUNCATE TABLE `ps_connections`;
TRUNCATE TABLE `ps_customer`;
TRUNCATE TABLE `ps_customer_group`;
UPDATE `ps_editorial` SET `body_home_logo_link` = 'http://www.twojastrona.pl' WHERE `ps_editorial`.`id_editorial` =1;
update `ps_editorial_lang` set
`id_lang` = 6,
`body_title` = 'Infolinia: Call me baby..',
`body_subheading`='Nasi konsultancji: Right now!',
`body_paragraph`='<p>Or I <b>kill</b> you, I kill you</p>',
`body_logo_subheading`='All in Prestashop..'
WHERE `id_editorial` = 1 and `id_lang` = 6;
delete from `ps_feature` where `id_feature` > 4;
delete from `ps_feature_lang` where `id_feature` > 4;
delete from `ps_feature_product` where `id_feature` > 4;
TRUNCATE TABLE `ps_feature_value`;
TRUNCATE TABLE `ps_feature_value_lang`;
TRUNCATE TABLE `ps_image`;
TRUNCATE TABLE `ps_image_lang`;
TRUNCATE TABLE `ps_image_type`;
TRUNCATE TABLE `ps_manufacturer`;
TRUNCATE TABLE `ps_manufacturer_lang`;
/* delete from `ps_orders`; */
DELETE FROM `ps_orders`, `ps_order_detail`, `ps_order_discount`,
`ps_order_history`
USING `ps_orders`
INNER JOIN `ps_order_detail`
LEFT JOIN `ps_order_discount` on `ps_orders`.id_order = `ps_order_discount`.id_order
LEFT JOIN `ps_order_history` on `ps_orders`.id_order = `ps_order_history`.id_order
WHERE
`ps_orders`.id_customer= 1 /* tester id */
and `ps_orders`.id_order=`ps_order_detail`.id_order;
DELETE FROM `ps_order_return`, `ps_order_return_detail`
USING `ps_order_return`
INNER JOIN `ps_order_return_detail`
WHERE
`ps_order_return`.id_customer= 1 /* tester id */
and `ps_order_return`.id_order_return=`ps_order_return_detail`.id_order_return;
/* w domyślnej instalacji ten domyślny komunikat o braku towaru jest bezsensowny :) */
UPDATE `ps_order_message_lang`
SET `id_order_message` = 1,
`id_lang` = 6,`name` = 'Opóźnienie',
`message` = 'Witamy,\n\nNiestety, pozycji obecnej na zamówieniu aktualnie brakuje na stanie.'
'Może to spowodować niewielkie opóźnienie w dostawie.\nDziękujemy za wyrozumiałość.\n\nPozdrawiamy,'
WHERE `ps_order_message_lang`.`id_order_message` = 1 AND `ps_order_message_lang`.`id_lang` = 6;
TRUNCATE TABLE `ps_product`;
TRUNCATE TABLE `ps_product_attachment`;
TRUNCATE TABLE `ps_product_attribute`;
TRUNCATE TABLE `ps_product_attribute_combination`;
TRUNCATE TABLE `ps_product_attribute_image`;
TRUNCATE TABLE `ps_product_country_tax`;
TRUNCATE TABLE `ps_product_download`;
TRUNCATE TABLE `ps_product_group_reduction_cache`;
TRUNCATE TABLE `ps_product_lang`;
TRUNCATE TABLE `ps_product_sale`;
TRUNCATE TABLE `ps_product_tag`;
TRUNCATE TABLE `ps_scene`;
TRUNCATE TABLE `ps_scene`;
TRUNCATE TABLE `ps_scene_lang`;
TRUNCATE TABLE `ps_scene_products`;
TRUNCATE TABLE `ps_scene`;
TRUNCATE TABLE `ps_search_index`;
TRUNCATE TABLE `ps_search_word`;
TRUNCATE TABLE `ps_stock_mvt`;
TRUNCATE TABLE `ps_store`;
INSERT INTO `ps_store` (`id_store`, `id_country`, `id_state`, `name`, `address1`, `address2`, `city`, `postcode`,
`latitude`, `longitude`, `hours`, `phone`, `fax`, `email`, `note`, `active`, `date_add`, `date_upd`) VALUES
(1, 14, 0, 'Mój Sklep -DEBEŚCIAK', 'Pl. Bankowy', '', 'Warszawa', '00-095',
52.243099, 21.003187, 'a:7:{i:0;s:13:"09:00 - 19:00";i:1;s:13:"09:00 - 19:00";i:2;s:13:"09:00 -'
'19:00";i:3;s:13:"09:00 - 19:00";i:4;s:13:"09:00 - 19:00";i:5;s:13:"10:00 - 16:00";i:6;s:13:"10:00 - '
'16:00";}', '55555555', '555555555', 'info@mójsklep.pl', '', 1, '2010-11-09 10:53:13', '2011-08-26 '
'01:18:12');
TRUNCATE TABLE `ps_supplier`;
TRUNCATE TABLE `ps_supplier_lang`;Jednak z tego co widzę to nie tylko kasuje dane o produkcie ale "zmienia?"
dane w sklepie:
UPDATE `ps_editorial` SET `body_home_logo_link` = 'http://www.twojastrona.pl' WHERE `ps_editorial`.`id_editorial` =1;`body_title` = 'Infolinia: Call me baby..',
`body_subheading`='Nasi konsultancji: Right now!',
`body_paragraph`='<p>Or I <b>kill</b> you, I kill you</p>',
`body_logo_subheading`='All in Prestashop..'INSERT INTO `ps_store` (`id_store`, `id_country`, `id_state`, `name`, `address1`, `address2`, `city`, `postcode`,
`latitude`, `longitude`, `hours`, `phone`, `fax`, `email`, `note`, `active`, `date_add`, `date_upd`) VALUES
(1, 14, 0, 'Mój Sklep -DEBEŚCIAK', 'Pl. Bankowy', '', 'Warszawa', '00-095',
52.243099, 21.003187, 'a:7:{i:0;s:13:"09:00 - 19:00";i:1;s:13:"09:00 - 19:00";i:2;s:13:"09:00 -'
'19:00";i:3;s:13:"09:00 - 19:00";i:4;s:13:"09:00 - 19:00";i:5;s:13:"10:00 - 16:00";i:6;s:13:"10:00 - '
'16:00";}', '55555555', '555555555', 'info@mójsklep.pl', '', 1, '2010-11-09 10:53:13', '2011-08-26 '
'01:18:12');Jak to zrobić lub co skasować w tym kodzie aby wyczyściło mi wszystkie zamówienia
jakie były dotychczas - demo i testowe ? No i gdzie ten kod mam wkleić w phpMyAdmin ?
Dzięki za pomoc.
