summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorThomas Bruederli <bruederli@kolabsys.com>2014-08-14 07:46:16 (GMT)
committerThomas Bruederli <bruederli@kolabsys.com>2014-08-14 07:46:16 (GMT)
commit02b94590bf984b12fefc31691928a99b4e4dea4f (patch)
treeef12d88fa42f043efa52abd4f21b57a0d2d88bc4
parent31ee64d7e187b34247f434d9d5cdce505793461a (diff)
downloadroundcubemail-plugins-kolab-02b94590bf984b12fefc31691928a99b4e4dea4f.tar.gz
Specify default values in Postgres schema (#3110)
-rw-r--r--plugins/calendar/drivers/database/SQL/postgres.initial.sql12
1 files changed, 6 insertions, 6 deletions
diff --git a/plugins/calendar/drivers/database/SQL/postgres.initial.sql b/plugins/calendar/drivers/database/SQL/postgres.initial.sql
index 27223cb..d1a8b03 100644
--- a/plugins/calendar/drivers/database/SQL/postgres.initial.sql
+++ b/plugins/calendar/drivers/database/SQL/postgres.initial.sql
@@ -50,16 +50,16 @@ CREATE TABLE events (
"start" timestamp without time zone DEFAULT now() NOT NULL,
"end" timestamp without time zone DEFAULT now() NOT NULL,
recurrence varchar(255) DEFAULT NULL,
- title character varying(255) NOT NULL,
- description text NOT NULL,
- location character varying(255) NOT NULL,
- categories character varying(255) NOT NULL,
- url character varying(255) NOT NULL,
+ title character varying(255) NOT NULL DEFAULT '',
+ description text NOT NULL DEFAULT '',
+ location character varying(255) NOT NULL DEFAULT '',
+ categories character varying(255) NOT NULL DEFAULT '',
+ url character varying(255) NOT NULL DEFAULT '',
all_day smallint NOT NULL DEFAULT 0,
free_busy smallint NOT NULL DEFAULT 0,
priority smallint NOT NULL DEFAULT 0,
sensitivity smallint NOT NULL DEFAULT 0,
- status character varying(32) NOT NULL,
+ status character varying(32) NOT NULL DEFAULT '',
alarms varchar(255) DEFAULT NULL,
attendees text DEFAULT NULL,
notifyat timestamp without time zone DEFAULT NULL,