equal
deleted
inserted
replaced
1455 FOR EACH ROW BEGIN |
1455 FOR EACH ROW BEGIN |
1456 DELETE FROM tx_entity_actions WHERE tx_uuid=OLD.tx_uuid; |
1456 DELETE FROM tx_entity_actions WHERE tx_uuid=OLD.tx_uuid; |
1457 DELETE FROM tx_relation_actions WHERE tx_uuid=OLD.tx_uuid; |
1457 DELETE FROM tx_relation_actions WHERE tx_uuid=OLD.tx_uuid; |
1458 END;; |
1458 END;; |
1459 ''' |
1459 ''' |
1460 schema += ';;'.join(helper.sqls_create_multicol_unique_index('entities', ['extid'])) |
1460 # define a multi-columns index on a single index to please sqlserver, which doesn't like several |
|
1461 # null entries in a UNIQUE column |
|
1462 schema += ';;'.join(helper.sqls_create_multicol_unique_index('entities', ['extid'], 'entities_extid_idx')) |
1461 schema += ';;\n' |
1463 schema += ';;\n' |
1462 return schema |
1464 return schema |
1463 |
1465 |
1464 |
1466 |
1465 def sql_drop_schema(driver): |
1467 def sql_drop_schema(driver): |