dodil/erp-brick-purchasing

DODIL ERP brick: purchasing

src/brick_purchasing/migrations/00001_init/down.sql

-- 00001_init down: drops every table the brick made. Destroys the brick's data: a rollback of a first install only.
DROP TABLE IF EXISTS pur_variance_acceptance;
DROP TABLE IF EXISTS pur_tolerance;
DROP TABLE IF EXISTS pur_terms;
DROP TABLE IF EXISTS pur_task;
DROP TABLE IF EXISTS pur_supplier_price;
DROP TABLE IF EXISTS pur_supplier_bank;
DROP TABLE IF EXISTS pur_supplier;
DROP TABLE IF EXISTS pur_source;
DROP TABLE IF EXISTS pur_settings;
DROP TABLE IF EXISTS pur_service_score;
DROP TABLE IF EXISTS pur_self_billing;
DROP TABLE IF EXISTS pur_schedule_release;
DROP TABLE IF EXISTS pur_schedule_line;
DROP TABLE IF EXISTS pur_run_item;
DROP TABLE IF EXISTS pur_rfq_versions;
DROP TABLE IF EXISTS pur_rfq_supplier;
DROP TABLE IF EXISTS pur_rfq_line;
DROP TABLE IF EXISTS pur_rfq;
DROP TABLE IF EXISTS pur_request_versions;
DROP TABLE IF EXISTS pur_request_line;
DROP TABLE IF EXISTS pur_request;
DROP TABLE IF EXISTS pur_release_strategy;
DROP TABLE IF EXISTS pur_release;
DROP TABLE IF EXISTS pur_receipt_versions;
DROP TABLE IF EXISTS pur_receipt_line;
DROP TABLE IF EXISTS pur_receipt;
DROP TABLE IF EXISTS pur_quote;
DROP TABLE IF EXISTS pur_quota;
DROP TABLE IF EXISTS pur_payment_versions;
DROP TABLE IF EXISTS pur_payment_run_versions;
DROP TABLE IF EXISTS pur_payment_run;
DROP TABLE IF EXISTS pur_payment;
DROP TABLE IF EXISTS pur_order_versions;
DROP TABLE IF EXISTS pur_order_send;
DROP TABLE IF EXISTS pur_order_revision;
DROP TABLE IF EXISTS pur_order_line;
DROP TABLE IF EXISTS pur_order_component;
DROP TABLE IF EXISTS pur_order;
DROP TABLE IF EXISTS pur_object;
DROP TABLE IF EXISTS pur_number_series_versions;
DROP TABLE IF EXISTS pur_number_series;
DROP TABLE IF EXISTS pur_number_claim;
DROP TABLE IF EXISTS pur_migration_run;
DROP TABLE IF EXISTS pur_migration_map;
DROP TABLE IF EXISTS pur_migration_check;
DROP TABLE IF EXISTS pur_handover;
DROP TABLE IF EXISTS pur_gate_override;
DROP TABLE IF EXISTS pur_evaluation_weight;
DROP TABLE IF EXISTS pur_evaluation;
DROP TABLE IF EXISTS pur_dp_clearing;
DROP TABLE IF EXISTS pur_down_payment_versions;
DROP TABLE IF EXISTS pur_down_payment;
DROP TABLE IF EXISTS pur_delivery_cost;
DROP TABLE IF EXISTS pur_consignment_withdrawal;
DROP TABLE IF EXISTS pur_claim_versions;
DROP TABLE IF EXISTS pur_cis_deduction;
DROP TABLE IF EXISTS pur_billed_claim;
DROP TABLE IF EXISTS pur_bill_versions;
DROP TABLE IF EXISTS pur_bill_line;
DROP TABLE IF EXISTS pur_bill;
DROP TABLE IF EXISTS pur_approval_limit;
DROP TABLE IF EXISTS pur_allocation;
DROP TABLE IF EXISTS pur_ai_finding;
DROP TABLE IF EXISTS pur_agreement_versions;
DROP TABLE IF EXISTS pur_agreement_line;
DROP TABLE IF EXISTS pur_agreement_claim;
DROP TABLE IF EXISTS pur_agreement;
DROP TABLE IF EXISTS pur_account_map;