diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/schema.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/sql/schema.sql b/sql/schema.sql index 66364f5..f7216f3 100644 --- a/sql/schema.sql +++ b/sql/schema.sql @@ -43,7 +43,7 @@ CREATE TABLE mailing_list_emails ( list_id BIGINT NOT NULL REFERENCES mailing_lists(id) ON DELETE CASCADE, title TEXT NOT NULL, sender TEXT NOT NULL, - date TIMESTAMPZ NOT NULL, -- everything must be in UTC + date TIMESTAMPTZ NOT NULL, -- everything must be in UTC message_id TEXT, -- no uniqueness guarantee as it's arbitrarily set by senders content BYTEA NOT NULL ); @@ -56,7 +56,7 @@ CREATE TABLE users ( username TEXT UNIQUE, -- NULL when, for example, pubkey_only type user_type NOT NULL, password_hash TEXT, - created_at TIMESTAMPZ NOT NULL DEFAULT NOW() + created_at TIMESTAMPTZ NOT NULL DEFAULT NOW() ); CREATE TABLE ssh_public_keys ( @@ -71,8 +71,8 @@ CREATE TABLE sessions ( session_id BIGINT GENERATED ALWAYS AS IDENTITY PRIMARY KEY, user_id BIGINT NOT NULL REFERENCES users(id) ON DELETE CASCADE, token_hash BYTEA UNIQUE NOT NULL, - created_at TIMESTAMPZ NOT NULL DEFAULT now(), - expires_at TIMESTAMPZ NOT NULL + created_at TIMESTAMPTZ NOT NULL DEFAULT now(), + expires_at TIMESTAMPTZ NOT NULL ); CREATE INDEX IF NOT EXISTS sessions_user_idx ON sessions(user_id); |