Compare commits
2
Commits
| Author | SHA1 | Date | |
|---|---|---|---|
|
|
ee51789ee2 | ||
|
|
a083bac65f |
@@ -548,8 +548,7 @@ CREATE TABLE IF NOT EXISTS continuity.prospective_items (
|
|||||||
state TEXT NOT NULL,
|
state TEXT NOT NULL,
|
||||||
revision BIGINT NOT NULL,
|
revision BIGINT NOT NULL,
|
||||||
recorded_at TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
recorded_at TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
||||||
CHECK (revision > 0),
|
CHECK (revision > 0)
|
||||||
CHECK (state <> 'ARMED' OR summary <> '')
|
|
||||||
);
|
);
|
||||||
CREATE TABLE IF NOT EXISTS continuity.action_receipts (
|
CREATE TABLE IF NOT EXISTS continuity.action_receipts (
|
||||||
action_intent_id TEXT PRIMARY KEY,
|
action_intent_id TEXT PRIMARY KEY,
|
||||||
|
|||||||
@@ -6,15 +6,5 @@ ALTER TABLE continuity.prospective_items ADD COLUMN IF NOT EXISTS source_intent_
|
|||||||
ALTER TABLE continuity.prospective_items ADD COLUMN IF NOT EXISTS source_utterance_id TEXT NOT NULL DEFAULT '';
|
ALTER TABLE continuity.prospective_items ADD COLUMN IF NOT EXISTS source_utterance_id TEXT NOT NULL DEFAULT '';
|
||||||
ALTER TABLE continuity.prospective_items ADD COLUMN IF NOT EXISTS summary TEXT NOT NULL DEFAULT '';
|
ALTER TABLE continuity.prospective_items ADD COLUMN IF NOT EXISTS summary TEXT NOT NULL DEFAULT '';
|
||||||
|
|
||||||
DO $$ BEGIN
|
|
||||||
IF NOT EXISTS (SELECT 1 FROM pg_constraint WHERE conname='prospective_items_reminder_metadata_v1' AND conrelid='continuity.prospective_items'::regclass) THEN
|
|
||||||
ALTER TABLE continuity.prospective_items ADD CONSTRAINT prospective_items_reminder_metadata_v1 CHECK (
|
|
||||||
state <> 'ARMED' OR summary <> ''
|
|
||||||
) NOT VALID;
|
|
||||||
END IF;
|
|
||||||
END $$;
|
|
||||||
|
|
||||||
ALTER TABLE continuity.prospective_items VALIDATE CONSTRAINT prospective_items_reminder_metadata_v1;
|
|
||||||
|
|
||||||
RESET ROLE;
|
RESET ROLE;
|
||||||
COMMIT;
|
COMMIT;
|
||||||
|
|||||||
Reference in New Issue
Block a user