Files
apskel-pos-backend/migrations/000088_add_cash_advance_to_spending.down.sql
2026-08-13 14:38:28 +07:00

16 lines
417 B
SQL

DROP INDEX IF EXISTS idx_expenses_cash_advance_id;
ALTER TABLE expenses
DROP CONSTRAINT IF EXISTS fk_expenses_cash_advance;
ALTER TABLE expenses
DROP COLUMN IF EXISTS cash_advance_id;
DROP INDEX IF EXISTS idx_purchase_orders_cash_advance_id;
ALTER TABLE purchase_orders
DROP CONSTRAINT IF EXISTS fk_purchase_orders_cash_advance;
ALTER TABLE purchase_orders
DROP COLUMN IF EXISTS cash_advance_id;