[Checkins] SVN: relstorage/branches/1.1/notes/migrate-1.0.1.txt Wrote the MySQL migration script

[Shane Hathaway]

Log message for revision 85484:
  Wrote the MySQL 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-18 23:42:03 UTC (rev 85483)
+++ relstorage/branches/1.1/notes/migrate-1.0.1.txt	2008-04-18 23:42:39 UTC (rev 85484)
@@ -1,10 +1,12 @@
 
-Migrating from version 1.0.1
+Migrating from version 1.0.1 to version 1.1
 
 PostgreSQL:
 
     CREATE INDEX object_state_prev_tid ON object_state (prev_tid);
 
+    DROP TABLE pack_lock;
+
     DROP INDEX pack_object_keep_zoid;
     CREATE INDEX pack_object_keep_false ON pack_object (zoid)
         WHERE keep = false;
@@ -30,3 +32,26 @@
         tid         BIGINT NOT NULL PRIMARY KEY
     );
 
+MySQL:
+
+    CREATE INDEX object_state_prev_tid ON object_state (prev_tid);
+
+    ALTER TABLE transaction ADD COLUMN empty BOOLEAN NOT NULL DEFAULT FALSE;
+
+    CREATE INDEX current_object_tid ON current_object (tid);
+
+    ALTER TABLE object_ref ADD PRIMARY KEY (tid, zoid, to_zoid);
+    ALTER TABLE object_ref DROP INDEX object_ref_from;
+    ALTER TABLE object_ref DROP INDEX object_ref_tid;
+    ALTER TABLE object_ref DROP INDEX object_ref_to;
+
+    CREATE TABLE pack_state (
+        tid         BIGINT NOT NULL,
+        zoid        BIGINT NOT NULL,
+        PRIMARY KEY (tid, zoid)
+    ) ENGINE = MyISAM;
+
+    CREATE TABLE pack_state_tid (
+        tid         BIGINT NOT NULL PRIMARY KEY
+    ) ENGINE = MyISAM;
+