serendipty01.dev
forked from
smokesignal.events/smokesignal
The smokesignal.events web application
1-- Add validated_at column to RSVPs table
2ALTER TABLE rsvps ADD COLUMN validated_at TIMESTAMP WITH TIME ZONE DEFAULT NULL;
3
4-- Create acceptance_tickets table for storing RSVP acceptance tickets
5CREATE TABLE acceptance_tickets (
6 aturi VARCHAR(1024) PRIMARY KEY,
7 did VARCHAR(256) NOT NULL,
8 rsvp_did VARCHAR(256) NOT NULL,
9 event_aturi VARCHAR(1024) NOT NULL,
10 record JSON NOT NULL,
11 created_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW()
12);
13
14CREATE INDEX idx_acceptance_tickets_did ON acceptance_tickets (did);
15CREATE INDEX idx_acceptance_tickets_rsvp_did ON acceptance_tickets (rsvp_did);
16CREATE INDEX idx_acceptance_tickets_event_aturi ON acceptance_tickets (event_aturi);
17
18-- Create acceptance_records table for storing RSVP acceptance records
19CREATE TABLE acceptance_records (
20 aturi VARCHAR(1024) PRIMARY KEY,
21 cid VARCHAR(256) NOT NULL,
22 did VARCHAR(256) NOT NULL,
23 record JSON NOT NULL,
24 created_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(),
25 updated_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW()
26);
27
28CREATE INDEX idx_acceptance_records_did ON acceptance_records (did);