misc/migration/3.7.0_Any.py
changeset 11057 0b59724cb3f2
parent 11052 058bb3dc685f
child 11058 23eb30449fe5
--- a/misc/migration/3.7.0_Any.py	Mon Jan 04 18:40:30 2016 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,40 +0,0 @@
-typemap = repo.system_source.dbhelper.TYPE_MAPPING
-sqls = """
-CREATE TABLE transactions (
-  tx_uuid CHAR(32) PRIMARY KEY NOT NULL,
-  tx_user INTEGER NOT NULL,
-  tx_time %s NOT NULL
-);;
-CREATE INDEX transactions_tx_user_idx ON transactions(tx_user);;
-
-CREATE TABLE tx_entity_actions (
-  tx_uuid CHAR(32) REFERENCES transactions(tx_uuid) ON DELETE CASCADE,
-  txa_action CHAR(1) NOT NULL,
-  txa_public %s NOT NULL,
-  txa_order INTEGER,
-  eid INTEGER NOT NULL,
-  etype VARCHAR(64) NOT NULL,
-  changes %s
-);;
-CREATE INDEX tx_entity_actions_txa_action_idx ON tx_entity_actions(txa_action);;
-CREATE INDEX tx_entity_actions_txa_public_idx ON tx_entity_actions(txa_public);;
-CREATE INDEX tx_entity_actions_eid_idx ON tx_entity_actions(eid);;
-CREATE INDEX tx_entity_actions_etype_idx ON tx_entity_actions(etype);;
-
-CREATE TABLE tx_relation_actions (
-  tx_uuid CHAR(32) REFERENCES transactions(tx_uuid) ON DELETE CASCADE,
-  txa_action CHAR(1) NOT NULL,
-  txa_public %s NOT NULL,
-  txa_order INTEGER,
-  eid_from INTEGER NOT NULL,
-  eid_to INTEGER NOT NULL,
-  rtype VARCHAR(256) NOT NULL
-);;
-CREATE INDEX tx_relation_actions_txa_action_idx ON tx_relation_actions(txa_action);;
-CREATE INDEX tx_relation_actions_txa_public_idx ON tx_relation_actions(txa_public);;
-CREATE INDEX tx_relation_actions_eid_from_idx ON tx_relation_actions(eid_from);;
-CREATE INDEX tx_relation_actions_eid_to_idx ON tx_relation_actions(eid_to)
-""" % (typemap['Datetime'],
-       typemap['Boolean'], typemap['Bytes'], typemap['Boolean'])
-for statement in sqls.split(';;'):
-    sql(statement)