1 -- @tag: part_remove_unneeded_fields
2 -- @description: Removing colums assembly, inventory_accno_id, expense_accno_id, income_accno_id
3 -- @depends: part_type_enum
5 ALTER TABLE parts DROP COLUMN assembly;
6 ALTER TABLE parts DROP COLUMN inventory_accno_id;
7 ALTER TABLE parts DROP COLUMN expense_accno_id;
8 ALTER TABLE parts DROP COLUMN income_accno_id;
10 -- ALTER TABLE parts DROP COLUMN makemodel;