From: Philipp Spitzer <philipp@spitzer.priv.at>
Date: Tue, 19 Mar 2013 20:00:01 +0000 (+0000)
Subject: Added comments to the SQL statements (back in October).
X-Git-Tag: 0.6.0~26
X-Git-Url: https://git.toastfreeware.priv.at/toast/confclerk.git/commitdiff_plain/9457aed2de7c2f26e6574a7e4ffef57f95cd201a

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

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,