[CalendarServer-changes] [11184] CalendarServer/branches/users/gaya/sharedgroups-3/txdav/common/ datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_19_to_20.sql

[source_changes at macosforge.org]

Revision: 11184
          http://trac.calendarserver.org//changeset/11184
Author:   gaya at apple.com
Date:     2013-05-14 17:52:45 -0700 (Tue, 14 May 2013)
Log Message:
-----------
first try at oracle dialect

Modified Paths:
--------------
    CalendarServer/branches/users/gaya/sharedgroups-3/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_19_to_20.sql

Modified: CalendarServer/branches/users/gaya/sharedgroups-3/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_19_to_20.sql
===================================================================
--- CalendarServer/branches/users/gaya/sharedgroups-3/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_19_to_20.sql	2013-05-15 00:34:09 UTC (rev 11183)
+++ CalendarServer/branches/users/gaya/sharedgroups-3/txdav/common/datastore/sql_schema/upgrades/oracle-dialect/upgrade_from_19_to_20.sql	2013-05-15 00:52:45 UTC (rev 11184)
@@ -66,6 +66,7 @@
 create index SHARED_GROUP_BIND_RESOURCE_ID on
   SHARED_GROUP_BIND(GROUP_RESOURCE_ID);
 
+  
 -----------------------------
 -- AddressBook Object kind --
 -----------------------------
@@ -111,7 +112,7 @@
 -----------------------------
 
 alter table ADDRESSBOOK_HOME
-	add column	ADDRESSBOOK_PROPERTY_STORE_ID	integer	default nextval('RESOURCE_ID_SEQ') not null;
+	add (ADDRESSBOOK_PROPERTY_STORE_ID	integer	default nextval('RESOURCE_ID_SEQ') not null);
 
 update ADDRESSBOOK_HOME
 	set	ADDRESSBOOK_PROPERTY_STORE_ID = (
@@ -137,10 +138,10 @@
 --------------------------------
 
 alter table ADDRESSBOOK_OBJECT
-	add column	KIND	integer;  -- enum ADDRESSBOOK_OBJECT_KIND
+	add (KIND	integer);  -- enum ADDRESSBOOK_OBJECT_KIND
 
 alter table ADDRESSBOOK_OBJECT
-	add column	ADDRESSBOOK_HOME_RESOURCE_ID	integer	references ADDRESSBOOK_HOME on delete cascade;
+	add (ADDRESSBOOK_HOME_RESOURCE_ID	integer	references ADDRESSBOOK_HOME on delete cascade);
 
 update ADDRESSBOOK_OBJECT
 	set	ADDRESSBOOK_HOME_RESOURCE_ID = (
@@ -175,15 +176,13 @@
   	
 -- add non null constraints after update and delete are complete
 alter table ADDRESSBOOK_OBJECT
-	alter column KIND
-		set not null;
+	add (KIND not null);
 
 alter table ADDRESSBOOK_OBJECT
-	alter column ADDRESSBOOK_HOME_RESOURCE_ID
-		set not null;
+	add (ADDRESSBOOK_HOME_RESOURCE_ID not null)
 
 alter table ADDRESSBOOK_OBJECT
-	drop column	ADDRESSBOOK_RESOURCE_ID;
+	drop (ADDRESSBOOK_RESOURCE_ID);
 
 	
 ------------------------------------------
@@ -191,7 +190,7 @@
 ------------------------------------------
 
 alter table ADDRESSBOOK_OBJECT_REVISIONS
-	add column	OWNER_ADDRESSBOOK_HOME_RESOURCE_ID	integer	references ADDRESSBOOK_HOME;
+	add (OWNER_ADDRESSBOOK_HOME_RESOURCE_ID	integer	references ADDRESSBOOK_HOME)\x8C;
 
 update ADDRESSBOOK_OBJECT_REVISIONS
 	set	OWNER_ADDRESSBOOK_HOME_RESOURCE_ID = (
@@ -225,7 +224,7 @@
   	);
 
 alter table ADDRESSBOOK_OBJECT_REVISIONS
-	drop column	ADDRESSBOOK_RESOURCE_ID;
+	drop (ADDRESSBOOK_RESOURCE_ID);
 
 
 -------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20130514/dba778c9/attachment.html>