kayrozen.com
forked from
smokesignal.events/smokesignal
i18n+filtering fork - fluent-templates v2
1CREATE TABLE events (
2 aturi VARCHAR(1024) PRIMARY KEY,
3 cid VARCHAR(256) NOT NULL,
4 did VARCHAR(256) NOT NULL,
5 lexicon VARCHAR(1024) NOT NULL,
6 record JSON NOT NULL,
7 name VARCHAR(1024) NOT NULL,
8 updated_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW ()
9);
10CREATE INDEX idx_events_did ON events (did);
11CREATE TABLE rsvps (
12 aturi VARCHAR(1024) PRIMARY KEY,
13 cid VARCHAR(256) NOT NULL,
14 did VARCHAR(256) NOT NULL,
15 lexicon VARCHAR(1024) NOT NULL,
16 record JSON NOT NULL,
17 event_aturi VARCHAR(1024) NOT NULL,
18 event_cid VARCHAR(256) NOT NULL,
19 status VARCHAR(1024) NOT NULL DEFAULT 'interested',
20 updated_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW ()
21);
22CREATE INDEX idx_rsvps_did ON rsvps (did);
23CREATE INDEX idx_rsvps_event ON rsvps (event_aturi, event_cid);