CREATE TABLE IF NOT EXISTS airship_auth_tokens (
tokenid BIGSERIAL PRIMARY KEY,
userid INTEGER,
selector TEXT,
validator TEXT,
created TIMESTAMP DEFAULT NOW(),
modified TIMESTAMP DEFAULT NOW(),
FOREIGN KEY (userid) REFERENCES airship_users (userid)
);
CREATE UNIQUE INDEX ON airship_auth_tokens (selector);
DROP TRIGGER IF EXISTS update_airship_auth_tokens_modtime ON airship_auth_tokens;
CREATE TRIGGER update_airship_auth_tokens_modtime
BEFORE UPDATE ON airship_auth_tokens
FOR EACH ROW EXECUTE PROCEDURE update_modtime();
|
Download
