dodil/erp-brick-tax

DODIL ERP brick: tax

src/brick_tax/migrations/00003_v4/down.sql

-- Not run against live data: K3 drops a column only in a later release, after the rollback window.
DROP TABLE IF EXISTS tax_ai_finding;
DROP TABLE IF EXISTS tax_capital_goods;
DROP TABLE IF EXISTS tax_partial_exemption;
DROP TABLE IF EXISTS tax_pva_statement_line;
DROP TABLE IF EXISTS tax_pva_statement;
DROP TABLE IF EXISTS tax_import_entry;
DROP TABLE IF EXISTS tax_trade_declaration_line;
DROP TABLE IF EXISTS tax_trade_declaration;
DROP TABLE IF EXISTS tax_cis_suffered;
DROP TABLE IF EXISTS tax_cis_return;
DROP TABLE IF EXISTS tax_cis_deduction;
DROP TABLE IF EXISTS tax_cis_subcontractor;
DROP TABLE IF EXISTS tax_vat_return_versions;
DROP TABLE IF EXISTS tax_vat_return_entry;
DROP TABLE IF EXISTS tax_vat_return;
DROP TABLE IF EXISTS tax_vat_obligation;
DROP TABLE IF EXISTS tax_vat_liability;
DROP TABLE IF EXISTS tax_vat_error_notice;
DROP TABLE IF EXISTS tax_vat_adjustment;
DROP TABLE IF EXISTS tax_statutory;
DROP TABLE IF EXISTS tax_rule_purchase;
DROP TABLE IF EXISTS tax_hmrc_connection;
DROP TABLE IF EXISTS tax_bad_debt_claim_versions;
DROP TABLE IF EXISTS tax_bad_debt_claim;
ALTER TABLE tax_code DROP COLUMN direction;
ALTER TABLE tax_code DROP COLUMN input_reporting_box;
ALTER TABLE tax_code DROP COLUMN value_box;
ALTER TABLE tax_code DROP COLUMN reclaimable_pct;
ALTER TABLE tax_document DROP COLUMN direction;
ALTER TABLE tax_document_line DROP COLUMN reclaimable_pct;
ALTER TABLE tax_document_line DROP COLUMN input_reporting_box;
ALTER TABLE tax_document_line DROP COLUMN value_box;
ALTER TABLE tax_registration DROP COLUMN accounting_basis;
ALTER TABLE tax_registration DROP COLUMN flat_rate_sector;
ALTER TABLE tax_registration DROP COLUMN flat_rate_pct;
ALTER TABLE tax_registration DROP COLUMN first_year_until;
ALTER TABLE tax_registration DROP COLUMN ni_goods;
ALTER TABLE tax_registration DROP COLUMN partial_exemption_year_end;
ALTER TABLE tax_registration DROP COLUMN expected_turnover;
ALTER TABLE tax_code DROP COLUMN attribution;
ALTER TABLE tax_code DROP COLUMN eu_goods;
ALTER TABLE tax_party DROP COLUMN check_name;
ALTER TABLE tax_party DROP COLUMN check_address;
ALTER TABLE tax_party DROP COLUMN consultation_number;
ALTER TABLE tax_party DROP COLUMN check_flag;
ALTER TABLE tax_party DROP COLUMN confirmed_by;
ALTER TABLE tax_party DROP COLUMN confirm_reason;
ALTER TABLE tax_party DROP COLUMN notice_kind;
ALTER TABLE tax_party DROP COLUMN notice_ref;
ALTER TABLE tax_party DROP COLUMN notice_date;
ALTER TABLE tax_document DROP COLUMN ship_to_country;
ALTER TABLE tax_document DROP COLUMN self_billed;
ALTER TABLE tax_document DROP COLUMN due_date;
ALTER TABLE tax_document_line DROP COLUMN pinned_from;
ALTER TABLE tax_document_line DROP COLUMN attribution;
ALTER TABLE tax_document_line DROP COLUMN eu_goods;