[Checkins] SVN: relstorage/trunk/relstorage/adapters/schema.py Oracle doesn't really allow indexes on temporary tables.

[Shane Hathaway]

Log message for revision 120059:
  Oracle doesn't really allow indexes on temporary tables.
  

Changed:
  U   relstorage/trunk/relstorage/adapters/schema.py

-=-
Modified: relstorage/trunk/relstorage/adapters/schema.py
===================================================================
--- relstorage/trunk/relstorage/adapters/schema.py	2011-02-02 19:24:05 UTC (rev 120058)
+++ relstorage/trunk/relstorage/adapters/schema.py	2011-02-02 20:20:59 UTC (rev 120059)
@@ -348,8 +348,6 @@
             zoid        NUMBER(20) NOT NULL PRIMARY KEY,
             keep_tid    NUMBER(20) NOT NULL
         );
-        CREATE UNIQUE INDEX temp_pack_visit_zoid ON temp_pack_visit (zoid);
-        CREATE INDEX temp_pack_keep_tid ON temp_pack_visit (keep_tid)
 
         # Temporary state during undo: a list of objects
         # to be undone and the tid of the undone state.
@@ -357,7 +355,6 @@
             zoid        NUMBER(20) NOT NULL PRIMARY KEY,
             prev_tid    NUMBER(20) NOT NULL
         );
-        CREATE UNIQUE INDEX temp_undo_zoid ON temp_undo (zoid)
 """
 
 history_preserving_init = """
@@ -652,8 +649,6 @@
             zoid        NUMBER(20) NOT NULL PRIMARY KEY,
             keep_tid    NUMBER(20) NOT NULL
         );
-        CREATE UNIQUE INDEX temp_pack_visit_zoid ON temp_pack_visit (zoid);
-        CREATE INDEX temp_pack_keep_tid ON temp_pack_visit (keep_tid)
 """
 
 history_free_init = """