Added comments to the SQL statements (back in October).

diff --git a/src/dbschema000to001.sql b/src/dbschema000to001.sql
index 64e4ee588015a610320768e67d1b3acc5d9af141..9ef313870267995e62c5de8a3706d387036ad008 100644 (file)
--- a/src/dbschema000to001.sql
+++ b/src/dbschema000to001.sql
@@ -15,8 +15,8 @@ CREATE TABLE conference (
        subtitle VARCHAR,
        venue VARCHAR,
        city VARCHAR,
        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,
        day_change INTEGER,
        timeslot_duration INTEGER,
        active INTEGER DEFAULT 0,

diff --git a/src/dbschema001.sql b/src/dbschema001.sql
index c8eafc33cf4e668bebc202fa2e5dbfd3e66f1751..eca2c39d42ca219f928927e486e8300d38b36e4c 100644 (file)
--- a/src/dbschema001.sql
+++ b/src/dbschema001.sql
@@ -6,8 +6,8 @@ CREATE TABLE conference (
        subtitle VARCHAR,
        venue VARCHAR,
        city VARCHAR,
        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,
        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,
 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,
        duration INTEGER NOT NULL, -- duration of the event in seconds
        xid_track INTEGER NOT NULL REFERENCES track(id),
        type VARCHAR,