favourite is now tristate instead of bool.

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

diff --git a/src/dbschema001.sql b/src/dbschema001.sql
index eca2c39d42ca219f928927e486e8300d38b36e4c..f55533f3fd7a5bfea957c97b88165c5f765a8068 100644 (file)
--- a/src/dbschema001.sql
+++ b/src/dbschema001.sql
@@ -49,7 +49,7 @@ CREATE TABLE event (
        subtitle VARCHAR,
        abstract VARCHAR,
        description VARCHAR,
-       favourite INTEGER DEFAULT 0,
+        favourite INTEGER DEFAULT 0, -- 0 ... no favourite, 1 ... strong favourite, 2 ... weak favourite/alternative to strong favourite
        alarm INTEGER DEFAULT 0,
        PRIMARY KEY (xid_conference, id)
 );