diff -r 058bb3dc685f -r 0b59724cb3f2 misc/migration/3.7.0_Any.py --- 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)