From 1c708d6a4ea155710c7f1b752e9bcb01ac75f98d Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Mon, 17 Sep 2018 13:19:48 -0700 Subject: use timestamptz (not WITHOUT TIME ZONE) --- rust/migrations/2018-05-12-001226_init/up.sql | 18 ++++++++++-------- 1 file changed, 10 insertions(+), 8 deletions(-) (limited to 'rust/migrations/2018-05-12-001226_init') diff --git a/rust/migrations/2018-05-12-001226_init/up.sql b/rust/migrations/2018-05-12-001226_init/up.sql index 8b7e3176..7550364c 100644 --- a/rust/migrations/2018-05-12-001226_init/up.sql +++ b/rust/migrations/2018-05-12-001226_init/up.sql @@ -4,6 +4,8 @@ -- columns (especially fixed-size external identifiers, and hashes). This was -- found to cause lookup problems, so switched to TEXT with CHECK constraints. +-- Default timezone (of clients) is expected to be UTC. + CREATE EXTENSION IF NOT EXISTS "uuid-ossp"; @@ -16,7 +18,7 @@ CREATE TABLE editor ( id UUID PRIMARY KEY DEFAULT uuid_generate_v4(), username TEXT NOT NULL UNIQUE, is_admin BOOLEAN NOT NULL DEFAULT false, - registered TIMESTAMP WITHOUT TIME ZONE DEFAULT now() NOT NULL, + registered TIMESTAMP WITH TIME ZONE DEFAULT now() NOT NULL, active_editgroup_id UUID -- REFERENCES( editgroup(id) via ALTER below ); @@ -25,7 +27,7 @@ CREATE INDEX active_editgroup_idx ON editor(active_editgroup_id); CREATE TABLE editgroup ( id UUID PRIMARY KEY DEFAULT uuid_generate_v4(), editor_id UUID REFERENCES editor(id) NOT NULL, - created TIMESTAMP WITHOUT TIME ZONE DEFAULT now() NOT NULL, + created TIMESTAMP WITH TIME ZONE DEFAULT now() NOT NULL, extra_json JSONB, description TEXT ); @@ -37,7 +39,7 @@ ALTER TABLE editor CREATE TABLE changelog ( id BIGSERIAL PRIMARY KEY, editgroup_id UUID REFERENCES editgroup(id) NOT NULL, - timestamp TIMESTAMP WITHOUT TIME ZONE DEFAULT now() NOT NULL + timestamp TIMESTAMP WITH TIME ZONE DEFAULT now() NOT NULL ); -- for "is this editgroup merged" queries @@ -84,7 +86,7 @@ CREATE INDEX creator_ident_rev_idx ON creator_ident(rev_id); CREATE TABLE creator_edit ( id BIGSERIAL PRIMARY KEY, editgroup_id UUID REFERENCES editgroup(id) NOT NULL, - updated TIMESTAMP WITHOUT TIME ZONE DEFAULT now() NOT NULL, + updated TIMESTAMP WITH TIME ZONE DEFAULT now() NOT NULL, ident_id UUID REFERENCES creator_ident(id) NOT NULL, rev_id UUID REFERENCES creator_rev(id), redirect_id UUID REFERENCES creator_ident(id), @@ -125,7 +127,7 @@ CREATE INDEX container_ident_rev_idx ON container_ident(rev_id); CREATE TABLE container_edit ( id BIGSERIAL PRIMARY KEY, editgroup_id UUID REFERENCES editgroup(id) NOT NULL, - updated TIMESTAMP WITHOUT TIME ZONE DEFAULT now() NOT NULL, + updated TIMESTAMP WITH TIME ZONE DEFAULT now() NOT NULL, ident_id UUID REFERENCES container_ident(id) NOT NULL, rev_id UUID REFERENCES container_rev(id), redirect_id UUID REFERENCES container_ident(id), @@ -173,7 +175,7 @@ CREATE INDEX file_ident_rev_idx ON file_ident(rev_id); CREATE TABLE file_edit ( id BIGSERIAL PRIMARY KEY, editgroup_id UUID REFERENCES editgroup(id) NOT NULL, - updated TIMESTAMP WITHOUT TIME ZONE DEFAULT now() NOT NULL, + updated TIMESTAMP WITH TIME ZONE DEFAULT now() NOT NULL, ident_id UUID REFERENCES file_ident(id) NOT NULL, rev_id UUID REFERENCES file_rev(id), redirect_id UUID REFERENCES file_ident(id), @@ -241,7 +243,7 @@ CREATE INDEX release_ident_rev_idx ON release_ident(rev_id); CREATE TABLE release_edit ( id BIGSERIAL PRIMARY KEY, editgroup_id UUID REFERENCES editgroup(id) NOT NULL, - updated TIMESTAMP WITHOUT TIME ZONE DEFAULT now() NOT NULL, + updated TIMESTAMP WITH TIME ZONE DEFAULT now() NOT NULL, ident_id UUID REFERENCES release_ident(id) NOT NULL, rev_id UUID REFERENCES release_rev(id), redirect_id UUID REFERENCES release_ident(id), @@ -269,7 +271,7 @@ CREATE INDEX work_ident_rev_idx ON work_ident(rev_id); CREATE TABLE work_edit ( id BIGSERIAL PRIMARY KEY, editgroup_id UUID REFERENCES editgroup(id) NOT NULL, - updated TIMESTAMP WITHOUT TIME ZONE DEFAULT now() NOT NULL, + updated TIMESTAMP WITH TIME ZONE DEFAULT now() NOT NULL, ident_id UUID REFERENCES work_ident(id) NOT NULL, rev_id UUID REFERENCES work_rev(id), redirect_id UUID REFERENCES work_ident(id), -- cgit v1.2.3