X-Git-Url: https://git.toastfreeware.priv.at/toast/confclerk.git/blobdiff_plain/865aab68022cd94157a469c1d8fce23cde9f9828..80589bbd26540449bb409744dfaffbf889ace7d5:/src/create_tables.sql

diff --git a/src/create_tables.sql b/src/create_tables.sql
index f804900..122c1cf 100644
--- a/src/create_tables.sql
+++ b/src/create_tables.sql
@@ -10,8 +10,7 @@ CREATE TABLE CONFERENCE ( id INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL
     , day_change INTEGER
     , timeslot_duration INTEGER
     , active INTEGER DEFAULT 0
-    , url VARCHAR
-    , map VARCHAR);
+    , url VARCHAR);
 
 CREATE TABLE TRACK ( id INTEGER  PRIMARY KEY AUTOINCREMENT  NOT NULL
     , xid_conference INTEGER NOT NULL
@@ -33,7 +32,7 @@ CREATE TABLE PERSON ( id INTEGER NOT NULL
 CREATE TABLE EVENT ( xid_conference INTEGER  NOT NULL
     , id INTEGER NOT NULL
     , start INTEGER NOT NULL
-    , duration INTEGER NOT NULL
+    , duration INTEGER NOT NULL -- duration of the event in seconds
     , xid_track INTEGER NOT NULL REFERENCES TRACK(id)
     , type VARCHAR
     , language VARCHAR