Remove sample data in 1.5.x versions ?

Code: Select all

$tables = array(
    'address',
    'category',
    'category_description',
    'category_to_store',
    'coupon',
    'customer',
    'download',
    'download_description',
    'manufacturer',
    'manufacturer_to_store',
    'product',
    'product_description',
    'product_discount',
    //'product_featured',  //Removed
    'product_image',
    'product_option',
    //'product_option_description',   //Removed
    'product_option_value',
    //'product_option_value_description',   //Removed
    'product_related',
    'product_special',
    'product_to_download',
    'product_to_store',
    'review',
    'store',
    //'store_description',  //Removed
    'product_tag', //remove the "s" at the end of "tag".
    'order',
    'order_download',
    'order_history',
    'order_option',
    'order_product',
    'order_status',
    'order_total',
    'product_to_category',
    //'coupon_description',   //Removed
    'coupon_product',
);

Code: Select all

DELETE FROM attribute;
DELETE FROM attribute_description;
DELETE FROM attribute_group;
DELETE FROM attribute_group_description;
DELETE FROM category;
DELETE FROM category_description;
DELETE FROM category_to_store;
DELETE FROM manufacturer;
DELETE FROM manufacturer_to_store;
DELETE FROM product;
DELETE FROM product_attribute;
DELETE FROM product_description;
DELETE FROM product_discount;
DELETE FROM product_image;
DELETE FROM product_option;
DELETE FROM product_option_value;
DELETE FROM product_related;
DELETE FROM product_reward;
DELETE FROM product_special;
DELETE FROM product_tag;
DELETE FROM product_to_category;
DELETE FROM product_to_store;
DELETE FROM url_alias;

Code: Select all

TRUNCATE attribute;
TRUNCATE attribute_description;
TRUNCATE attribute_group;
TRUNCATE attribute_group_description;
TRUNCATE category;
TRUNCATE category_description;
TRUNCATE category_to_store;
TRUNCATE manufacturer;
TRUNCATE manufacturer_to_store;
TRUNCATE product;
TRUNCATE product_attribute;
TRUNCATE product_description;
TRUNCATE product_discount;
TRUNCATE product_image;
TRUNCATE product_option;
TRUNCATE product_option_value;
TRUNCATE product_related;
TRUNCATE product_reward;
TRUNCATE product_special;
TRUNCATE product_tag;
TRUNCATE product_to_category;
TRUNCATE product_to_store;
TRUNCATE url_alias;

Code: Select all

DELETE FROM attribute;
DELETE FROM attribute_description;
DELETE FROM attribute_group;
DELETE FROM attribute_group_description;
DELETE FROM category;
DELETE FROM category_description;
DELETE FROM category_to_store;
DELETE FROM manufacturer;
DELETE FROM manufacturer_to_store;
DELETE FROM product;
DELETE FROM product_attribute;
DELETE FROM product_description;
DELETE FROM product_discount;
DELETE FROM product_image;
DELETE FROM product_option;
DELETE FROM product_option_value;
DELETE FROM product_related;
DELETE FROM product_reward;
DELETE FROM product_special;
DELETE FROM product_tag;
DELETE FROM product_to_category;
DELETE FROM product_to_store;
DELETE FROM url_alias;

Code: Select all

if(in_array(DB_PREFIX .$table, $all_tables)){