Codex Local
bf1233d5df
ci / verify (push) Canceled after 0s
Add customer and operator login, BLE provisioning, device fleet controls, call memory, memoir generation, and refreshed family and maintenance portals. Include API contracts, migrations, firmware sources, tests, assets, and deployment documentation.
15 lines
777 B
PL/PgSQL
15 lines
777 B
PL/PgSQL
BEGIN;
|
|
DROP TRIGGER IF EXISTS household_member_web_event ON household_member;
|
|
DROP FUNCTION IF EXISTS household_member_web_event_trigger();
|
|
DROP INDEX IF EXISTS web_event_household_recent_idx;
|
|
ALTER TABLE web_event ALTER COLUMN expires_at SET DEFAULT (now() + interval '15 minutes');
|
|
DELETE FROM web_event WHERE event_type='household.member.updated';
|
|
ALTER TABLE web_event DROP CONSTRAINT web_event_event_type_check;
|
|
ALTER TABLE web_event ADD CONSTRAINT web_event_event_type_check CHECK (event_type IN (
|
|
'device.presence.changed','device.binding.reset',
|
|
'conversation.started','conversation.completed','conversation.failed',
|
|
'story.created','story.revised','media.upload.completed','export.ready',
|
|
'privacy_request.updated','device.command.updated'));
|
|
|
|
COMMIT;
|