dodil/erp-brick-product

src/brick_product/migrations/00004_v4_slice_b/down.sql

-- 00004_v4_slice_b down: the v4 slice B tables and columns go.
DROP TABLE IF EXISTS prod_rounding_profile;
DROP TABLE IF EXISTS prod_site;
DROP TABLE IF EXISTS prod_classification;
DROP TABLE IF EXISTS prod_class;
DROP TABLE IF EXISTS prod_characteristic;
DROP TABLE IF EXISTS prod_product_use;
DROP TABLE IF EXISTS prod_code_series;
DROP TABLE IF EXISTS prod_product_type;
ALTER TABLE prod_product_unit DROP COLUMN IF EXISTS used_ref;
ALTER TABLE prod_product_unit DROP COLUMN IF EXISTS relative_unit_code;
ALTER TABLE prod_template DROP COLUMN IF EXISTS country_of_origin;
ALTER TABLE prod_template DROP COLUMN IF EXISTS commodity_code;
ALTER TABLE prod_template DROP COLUMN IF EXISTS product_type_code;
ALTER TABLE prod_product DROP COLUMN IF EXISTS country_of_origin;
ALTER TABLE prod_product DROP COLUMN IF EXISTS commodity_code;
ALTER TABLE prod_product DROP COLUMN IF EXISTS stocked_default;
ALTER TABLE prod_product DROP COLUMN IF EXISTS product_type_code;