plugins/calendar

[Thomas Brüderli]

 plugins/calendar/drivers/database/SQL/postgres.initial.sql |   12 ++++++------
 1 file changed, 6 insertions(+), 6 deletions(-)

New commits:
commit 02b94590bf984b12fefc31691928a99b4e4dea4f
Author: Thomas Bruederli <bruederli at kolabsys.com>
Date:   Thu Aug 14 09:46:16 2014 +0200

    Specify default values in Postgres schema (#3110)

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,