# HG changeset patch
# User Sylvain Thénault <sylvain.thenault@logilab.fr>
# Date 1485793037 -3600
# Node ID 7d3ee5a516fac1ec214df0615f4c111e31b085b0
# Parent  b54c4d9faf0ddf9370d686e77b537b0e6b8ecdb4
[migration] Fix crash on 3.24 migration

Some sql using a column droped the line above crash migration of cw < 3.24.

diff -r b54c4d9faf0d -r 7d3ee5a516fa cubicweb/misc/migration/3.24.0_Any.py
--- a/cubicweb/misc/migration/3.24.0_Any.py	Fri Jan 27 13:41:24 2017 +0100
+++ b/cubicweb/misc/migration/3.24.0_Any.py	Mon Jan 30 17:17:17 2017 +0100
@@ -6,14 +6,15 @@
 rql('DELETE CWProperty X WHERE X pkey "system.version.pyramid"',
     ask_confirm=False)
 
-sql('DROP TABLE moved_entities')
-sql('ALTER TABLE entities DROP COLUMN asource')
 # before removing extid, ensure it's coherent with cwuri
 for eid, etype, encoded_extid in sql(
         "SELECT eid, type, extid FROM entities, cw_CWSource "
         "WHERE cw_CWSource.cw_name=entities.asource AND cw_CWSource.cw_type='ldapfeed'"):
     sql('UPDATE cw_{} SET cw_cwuri=%(cwuri)s WHERE cw_eid=%(eid)s'.format(etype),
         {'eid': eid, 'cwuri': b64decode(encoded_extid)})
+
+sql('DROP TABLE moved_entities')
+sql('ALTER TABLE entities DROP COLUMN asource')
 sql('ALTER TABLE entities DROP COLUMN extid')
 sql('DROP INDEX entities_type_idx')