[CalendarServer-changes] [6105] CalendarServer/trunk/txcaldav/calendarstore/postgres_schema_v1.sql

[source_changes at macosforge.org]

Revision: 6105
          http://trac.macosforge.org/projects/calendarserver/changeset/6105
Author:   cdaboo at apple.com
Date:     2010-08-18 10:09:54 -0700 (Wed, 18 Aug 2010)
Log Message:
-----------
Make sure attachment table is cleaned up with calendar object is removed.

Modified Paths:
--------------
    CalendarServer/trunk/txcaldav/calendarstore/postgres_schema_v1.sql

Modified: CalendarServer/trunk/txcaldav/calendarstore/postgres_schema_v1.sql
===================================================================
--- CalendarServer/trunk/txcaldav/calendarstore/postgres_schema_v1.sql	2010-08-18 17:01:32 UTC (rev 6104)
+++ CalendarServer/trunk/txcaldav/calendarstore/postgres_schema_v1.sql	2010-08-18 17:09:54 UTC (rev 6105)
@@ -197,7 +197,7 @@
 ----------------
 
 create table ATTACHMENT (
-  CALENDAR_OBJECT_RESOURCE_ID integer       not null references CALENDAR_OBJECT,
+  CALENDAR_OBJECT_RESOURCE_ID integer       not null references CALENDAR_OBJECT on delete cascade,
   CONTENT_TYPE                varchar(255)  not null,
   SIZE                        integer       not null,
   MD5                         char(32)      not null,
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20100818/a262951a/attachment.html>