Useful clean up SQLs

Drop all tables

-- Clean the schema
drop table roles_users;
drop table role;
drop table "user";
drop table inventory_transaction_line;
drop table inventory_transaction;
drop table shipping_line;
drop table shipping;
drop table receiving_line;
drop table receiving;
drop table purchase_order_line;
drop table sales_order_line;
drop table expense;
drop table incoming;
drop table purchase_order;
drop table sales_order;
drop table customer;
drop table product;
drop table payment_method;
drop table supplier;
drop table product_category;
drop table preference;
drop table enum_values;
drop table alembic_version;

-- Update patch version automatically
-- update alembic_version set version_num = '29b31f4d8de6'

Clean all transaction data

-- Clean all the transaction data
-- Please keep in mind the sequence of the statements do matters
-- Since they have foreign key relationship to others
delete from shipping_line;
delete from shipping;
delete from receiving_line;
delete from receiving;
delete from inventory_transaction_line;
delete from inventory_transaction;
delete from purchase_order_line;
delete from sales_order_line;
delete from expense;
delete from incoming;
delete from purchase_order;
delete from sales_order;