channel VARCHAR NOT NULL,
ts VARCHAR NOT NULL,
sheet_title VARCHAR NOT NULL,
+ tab_name VARCHAR, -- Cache; blown away every time we see a new message.
+ tab_id VARCHAR, -- Ditto.
PRIMARY KEY (channel, ts)
);
CREATE TABLE users_nagged (
userid VARCHAR NOT NULL,
+ ts VARCHAR NOT NULL, -- Of the invitation.
last_nag TIMESTAMP WITH TIME ZONE NOT NULL,
- PRIMARY KEY (userid)
+ PRIMARY KEY (userid, ts)
);
CREATE TABLE group_membership_history (