Skip to content

Instantly share code, notes, and snippets.

View Ndrou's full-sized avatar

Andrew Herrault Ndrou

View GitHub Profile
@Ndrou
Ndrou / clean-db.sql
Created March 8, 2017 10:03
Clean prestashop 1.6 database
DELETE FROM ps_accessory WHERE id_product_1 NOT IN (select p.id_product from ps_product p);
DELETE FROM ps_accessory WHERE id_product_2 NOT IN (select p.id_product from ps_product p);
DELETE FROM ps_address WHERE id_customer NOT IN (select c.id_customer from ps_customer c);
DELETE FROM ps_product_comment WHERE id_product NOT IN (select p.id_product from ps_product p);
DELETE FROM ps_product_comment_grade WHERE id_product_comment NOT IN (select pc.id_product_comment from ps_product_comment pc);
DELETE FROM ps_product_comment_usefulness WHERE id_product_comment NOT IN (select pc.id_product_comment from ps_product_comment pc);
DELETE FROM ps_product_lang WHERE id_product NOT IN (select p.id_product from ps_product p);