plugins/calendar

Aleksander Machniak machniak at kolabsys.com
Thu Dec 13 13:18:40 CET 2012


 plugins/calendar/drivers/database/sql/postgresql.sql |    8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

New commits:
commit e6303a812ef471ed052fddd9b3240c9320297b19
Author: Aleksander Machniak <machniak at kolabsys.com>
Date:   Thu Dec 13 13:18:23 2012 +0100

    Fix typos in DDL file for Postgres

diff --git a/plugins/calendar/drivers/database/sql/postgresql.sql b/plugins/calendar/drivers/database/sql/postgresql.sql
index cff741b..8b88438 100644
--- a/plugins/calendar/drivers/database/sql/postgresql.sql
+++ b/plugins/calendar/drivers/database/sql/postgresql.sql
@@ -43,7 +43,7 @@ CREATE TABLE events (
     event_id integer DEFAULT nextval('event_ids'::regclass) NOT NULL,
     calendar_id integer NOT NULL
         REFERENCES calendars (calendar_id) ON UPDATE CASCADE ON DELETE CASCADE,
-    recurence_id integer NOT NULL DEFAULT 0,
+    recurrence_id integer NOT NULL DEFAULT 0,
     uid varchar(255) NOT NULL DEFAULT '',
     created timestamp without time zone DEFAULT now() NOT NULL,
     changed timestamp without time zone DEFAULT now(),
@@ -61,7 +61,7 @@ CREATE TABLE events (
     sensitivity smallint NOT NULL DEFAULT 0,
     alarms varchar(255) DEFAULT NULL,
     attendees text DEFAULT NULL,
-    notifyat timestamp without time zone DEFAULT NULL
+    notifyat timestamp without time zone DEFAULT NULL,
     PRIMARY KEY (event_id)
 );
 
@@ -79,7 +79,7 @@ CREATE SEQUENCE attachment_ids
 CREATE TABLE attachments (
     attachment_id integer DEFAULT nextval('attachment_ids'::regclass) NOT NULL,
     event_id integer NOT NULL
-        REFERENCES  events (event_id) ON DELETE CASCADE ON UPDATE CASCADE,
+        REFERENCES events (event_id) ON DELETE CASCADE ON UPDATE CASCADE,
     filename varchar(255) NOT NULL DEFAULT '',
     mimetype varchar(255) NOT NULL DEFAULT '',
     size integer NOT NULL DEFAULT 0,
@@ -87,7 +87,7 @@ CREATE TABLE attachments (
     PRIMARY KEY (attachment_id)
 );
 
-CREATE INDEX attachments_user_id_idx ON attachments (user_id);
+CREATE INDEX attachments_user_id_idx ON attachments (event_id);
 
 
 CREATE TABLE itipinvitations (





More information about the commits mailing list