Add comment for day_change field in conference table definition.

[toast/confclerk.git] / src / dbschema002.sql

diff --git a/src/dbschema002.sql b/src/dbschema002.sql
index c0a3d17f7a7a8851494cfde9f91c5a7f0f0c84b1..d933761604cf0307f793395edbb9798c1a9867ef 100644 (file)
--- a/src/dbschema002.sql
+++ b/src/dbschema002.sql
@@ -8,7 +8,7 @@ CREATE TABLE conference (
        city VARCHAR,
        start INTEGER NOT NULL, -- timezone-less timestamp (Unix Epoch)
        end INTEGER NOT NULL,   -- timezone-less timestamp (Unix Epoch)
-       day_change INTEGER,
+       day_change INTEGER, -- in seconds after midnight
        timeslot_duration INTEGER,
        utc_offset INTEGER DEFAULT NULL, -- if known, conference UTC offset in seconds (e.g. CET = +3600)
        display_time_shift INTEGER DEFAULT NULL, -- if not null, add number in seconds to conference times when showing times