dodil/erp-brick-gl

DODIL ERP brick: general ledger

src/brick_gl/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 gl_statement_version;
DROP TABLE IF EXISTS gl_statement_node;
DROP TABLE IF EXISTS gl_statement_assignment;
DROP TABLE IF EXISTS gl_statement;
DROP TABLE IF EXISTS gl_split_line;
DROP TABLE IF EXISTS gl_settings;
DROP TABLE IF EXISTS gl_segment;
DROP TABLE IF EXISTS gl_recurring_posting;
DROP TABLE IF EXISTS gl_recurring_journal;
DROP TABLE IF EXISTS gl_reconciliation;
DROP TABLE IF EXISTS gl_profit_centre_segment;
DROP TABLE IF EXISTS gl_profit_centre;
DROP TABLE IF EXISTS gl_period_event;
DROP TABLE IF EXISTS gl_period;
DROP TABLE IF EXISTS gl_object;
DROP TABLE IF EXISTS gl_number_series;
DROP TABLE IF EXISTS gl_migration_run;
DROP TABLE IF EXISTS gl_migration_map;
DROP TABLE IF EXISTS gl_master_audit;
DROP TABLE IF EXISTS gl_ledger;
DROP TABLE IF EXISTS gl_key_figure_value;
DROP TABLE IF EXISTS gl_journal_line;
DROP TABLE IF EXISTS gl_journal_audit;
DROP TABLE IF EXISTS gl_journal;
DROP TABLE IF EXISTS gl_ic_match;
DROP TABLE IF EXISTS gl_ic_document;
DROP TABLE IF EXISTS gl_group_account_map;
DROP TABLE IF EXISTS gl_fx_reval_run;
DROP TABLE IF EXISTS gl_fx_reval_item;
DROP TABLE IF EXISTS gl_fx_rate;
DROP TABLE IF EXISTS gl_fiscal_year;
DROP TABLE IF EXISTS gl_cost_centre_assignment;
DROP TABLE IF EXISTS gl_cost_centre;
DROP TABLE IF EXISTS gl_company_ledger;
DROP TABLE IF EXISTS gl_company_access;
DROP TABLE IF EXISTS gl_company;
DROP TABLE IF EXISTS gl_close_task_list;
DROP TABLE IF EXISTS gl_close_task;
DROP TABLE IF EXISTS gl_close_run;
DROP TABLE IF EXISTS gl_chart;
DROP TABLE IF EXISTS gl_chain_claim;
DROP TABLE IF EXISTS gl_carry_forward;
DROP TABLE IF EXISTS gl_budget_line;
DROP TABLE IF EXISTS gl_budget;
DROP TABLE IF EXISTS gl_balance;
DROP TABLE IF EXISTS gl_audit_export;
DROP TABLE IF EXISTS gl_alt_account;
DROP TABLE IF EXISTS gl_allocation_run;
DROP TABLE IF EXISTS gl_allocation_cycle;
DROP TABLE IF EXISTS gl_ai_finding;
DROP TABLE IF EXISTS gl_accrual_release;
DROP TABLE IF EXISTS gl_accrual;
DROP TABLE IF EXISTS gl_account_map;
DROP TABLE IF EXISTS gl_account_edge;
DROP TABLE IF EXISTS gl_account;