| 1 | CREATE TABLE "invoice_expenses" ( |
| 2 | "id" text PRIMARY KEY |
| 3 | "invoice_id" text NOT NULL |
| 4 | "expense_id" text NOT NULL |
| 5 | "created_at" timestamp DEFAULT |
| 6 | CONSTRAINT "invoice_expenses_invoice_id_expense_id_unique" UNIQUE |
| 7 | ); |
| 8 | --> statement-breakpoint |
| 9 | ALTER TABLE "expenses" DROP |
| 10 | --> statement-breakpoint |
| 11 | ALTER TABLE "invoice_expenses" ADD |
| 12 | ALTER TABLE "invoice_expenses" ADD |
| 13 | CREATE INDEX "invoice_expenses_invoice_id_idx" ON |
| 14 | CREATE INDEX "invoice_expenses_expense_id_idx" ON |
| 15 | INSERT INTO "invoice_expenses" ("id", |
| 16 | SELECT 'iexp_' || gen_random_uuid():: |
| 17 | FROM "expenses" |
| 18 | WHERE "invoice_id" IS NOT NULL;-- |
| 19 | ALTER TABLE "expenses" DROP COLUMN |