20240618195700_quote_state.sql 311 B

12345
  1. ALTER TABLE melt_quote ADD state TEXT CHECK ( state IN ('UNPAID', 'PENDING', 'PAID' ) ) NOT NULL DEFAULT 'UNPAID';
  2. ALTER TABLE melt_quote ADD payment_preimage TEXT;
  3. ALTER TABLE melt_quote DROP COLUMN paid;
  4. CREATE INDEX IF NOT EXISTS melt_quote_state_index ON melt_quote(state);
  5. DROP INDEX IF EXISTS paid_index;