dodil/erp-brick-pos

DODIL ERP brick: point of sale

src/brick_pos/migrations/00002_slice_b/down.sql

-- 00002_slice_b down: drops what the release added.
ALTER TABLE pos_session DROP COLUMN last_receipt_no;
ALTER TABLE pos_session DROP COLUMN claimed_gap_from;
ALTER TABLE pos_session DROP COLUMN claimed_gap_to;
ALTER TABLE pos_session DROP COLUMN posted_at;
ALTER TABLE pos_session DROP COLUMN journal_id;
ALTER TABLE pos_session DROP COLUMN snapshot_no;
ALTER TABLE pos_session DROP COLUMN snapshot_digest;
ALTER TABLE pos_receipt DROP COLUMN original_receipt_id;
ALTER TABLE pos_receipt DROP COLUMN void_reason;
ALTER TABLE pos_receipt DROP COLUMN voided_by;
ALTER TABLE pos_receipt DROP COLUMN voided_at;
ALTER TABLE pos_receipt_line DROP COLUMN original_line_no;
ALTER TABLE pos_receipt_line DROP COLUMN restock;
ALTER TABLE pos_receipt_line DROP COLUMN kind;
ALTER TABLE pos_receipt_line DROP COLUMN voucher_code;
ALTER TABLE pos_receipt_line DROP COLUMN recipe_source;
ALTER TABLE pos_receipt_line DROP COLUMN recipe_ref;
ALTER TABLE pos_receipt_line DROP COLUMN recipe_version;
ALTER TABLE pos_receipt_line DROP COLUMN modifiers;
ALTER TABLE pos_payment_line DROP COLUMN voucher_code;
DROP TABLE IF EXISTS pos_register_snapshot;
DROP TABLE IF EXISTS pos_recipe_line;
DROP TABLE IF EXISTS pos_recipe;
DROP TABLE IF EXISTS pos_line_component;
DROP TABLE IF EXISTS pos_voucher_claim;
DROP TABLE IF EXISTS pos_voucher;
DROP TABLE IF EXISTS pos_category_rule;
DROP TABLE IF EXISTS pos_refund_claim;
DROP TABLE IF EXISTS pos_cash_deposit;