[Checkins] SVN: relstorage/branches/1.1/notes/migrate-1.0.1.txt Added Oracle migration script

[Shane Hathaway]

Log message for revision 85487:
  Added Oracle migration script
  

Changed:
  U   relstorage/branches/1.1/notes/migrate-1.0.1.txt

-=-
Modified: relstorage/branches/1.1/notes/migrate-1.0.1.txt
===================================================================
--- relstorage/branches/1.1/notes/migrate-1.0.1.txt	2008-04-19 00:27:20 UTC (rev 85486)
+++ relstorage/branches/1.1/notes/migrate-1.0.1.txt	2008-04-19 00:27:42 UTC (rev 85487)
@@ -55,3 +55,25 @@
         tid         BIGINT NOT NULL PRIMARY KEY
     ) ENGINE = MyISAM;
 
+Oracle:
+
+    CREATE INDEX object_state_prev_tid ON object_state (prev_tid);
+
+    ALTER TABLE transaction ADD empty CHAR DEFAULT 'N' CHECK (empty IN ('N', 'Y'));
+
+    CREATE INDEX current_object_tid ON current_object (tid);
+
+    ALTER TABLE object_ref ADD PRIMARY KEY (tid, zoid, to_zoid);
+    DROP INDEX object_ref_from;
+    DROP INDEX object_ref_tid;
+    DROP INDEX object_ref_to;
+
+    CREATE TABLE pack_state (
+        tid         NUMBER(20) NOT NULL,
+        zoid        NUMBER(20) NOT NULL,
+        PRIMARY KEY (tid, zoid)
+    );
+
+    CREATE TABLE pack_state_tid (
+        tid         NUMBER(20) NOT NULL PRIMARY KEY
+    );