cubicweb/misc/migration/3.21.0_Any.py
changeset 11757 e845746b4d3c
parent 11406 8ed625765a5c
child 11774 51c160677afe
--- a/cubicweb/misc/migration/3.21.0_Any.py	Fri Sep 30 17:36:40 2016 +0200
+++ b/cubicweb/misc/migration/3.21.0_Any.py	Thu Sep 29 11:44:19 2016 +0200
@@ -133,21 +133,7 @@
 for query in helper.sqls_create_multicol_unique_index('entities', ['extid']):
     cu.execute(query)
 
-if 'moved_entities' not in helper.list_tables(cu):
-    sql('''
-    CREATE TABLE moved_entities (
-      eid INTEGER PRIMARY KEY NOT NULL,
-      extid VARCHAR(256) UNIQUE
-    )
-    ''')
-
-moved_entities = sql('SELECT -eid, extid FROM entities WHERE eid < 0',
-                     ask_confirm=False)
-if moved_entities:
-    cu.executemany('INSERT INTO moved_entities (eid, extid) VALUES (%s, %s)',
-                   moved_entities)
-    sql('DELETE FROM entities WHERE eid < 0')
-
+sql('DELETE FROM entities WHERE eid < 0')
 commit()
 
 sync_schema_props_perms('CWEType')