From 9457aed2de7c2f26e6574a7e4ffef57f95cd201a Mon Sep 17 00:00:00 2001 From: Philipp Spitzer Date: Tue, 19 Mar 2013 20:00:01 +0000 Subject: [PATCH] Added comments to the SQL statements (back in October). --- src/dbschema000to001.sql | 4 ++-- src/dbschema001.sql | 6 +++--- 2 files changed, 5 insertions(+), 5 deletions(-) diff --git a/src/dbschema000to001.sql b/src/dbschema000to001.sql index 64e4ee5..9ef3138 100644 --- a/src/dbschema000to001.sql +++ b/src/dbschema000to001.sql @@ -15,8 +15,8 @@ CREATE TABLE conference ( subtitle VARCHAR, venue VARCHAR, city VARCHAR, - start INTEGER NOT NULL, -- timestamp (Unix Epoch) - end INTEGER NOT NULL, -- timestamp (Unix Epoch) + start INTEGER NOT NULL, -- timezone-less timestamp (Unix Epoch) + end INTEGER NOT NULL, -- timezone-less timestamp (Unix Epoch) day_change INTEGER, timeslot_duration INTEGER, active INTEGER DEFAULT 0, diff --git a/src/dbschema001.sql b/src/dbschema001.sql index c8eafc3..eca2c39 100644 --- a/src/dbschema001.sql +++ b/src/dbschema001.sql @@ -6,8 +6,8 @@ CREATE TABLE conference ( subtitle VARCHAR, venue VARCHAR, city VARCHAR, - start INTEGER NOT NULL, -- timestamp (Unix Epoch) - end INTEGER NOT NULL, -- timestamp (Unix Epoch) + start INTEGER NOT NULL, -- timezone-less timestamp (Unix Epoch) + end INTEGER NOT NULL, -- timezone-less timestamp (Unix Epoch) day_change INTEGER, timeslot_duration INTEGER, active INTEGER DEFAULT 0, @@ -39,7 +39,7 @@ CREATE TABLE person ( CREATE TABLE event ( xid_conference INTEGER NOT NULL REFERENCES conference(id), id INTEGER NOT NULL, - start INTEGER NOT NULL, + start INTEGER NOT NULL, -- timezone-less timestamp (Unix Epoch) duration INTEGER NOT NULL, -- duration of the event in seconds xid_track INTEGER NOT NULL REFERENCES track(id), type VARCHAR, -- 2.39.5