[CalendarServer-changes] [12258] CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/ oracle-dialect/upgrade_from_30_to_31.sql

[source_changes at macosforge.org]

Revision: 12258
          http://trac.calendarserver.org//changeset/12258
Author:   cdaboo at apple.com
Date:     2014-01-07 14:00:59 -0800 (Tue, 07 Jan 2014)
Log Message:
-----------
Fix broken SQL.

Modified Paths:
--------------
    CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_30_to_31.sql

Modified: CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_30_to_31.sql
===================================================================
--- CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_30_to_31.sql	2014-01-07 21:55:31 UTC (rev 12257)
+++ CalendarServer/trunk/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_30_to_31.sql	2014-01-07 22:00:59 UTC (rev 12258)
@@ -30,9 +30,9 @@
 end;
 
 alter table ABO_MEMBERS
-	add ("REVISION" integer default nextval('REVISION_SEQ') not null);
+	add ("REVISION" integer not null);
 alter table ABO_MEMBERS
-	add ("REMOVED" boolean default false not null);
+	add ("REMOVED" integer default 0 not null);
 alter table ABO_MEMBERS
 	 drop primary key;
 alter table ABO_MEMBERS
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20140312/50e7a106/attachment.html>