[3.13 migration] closes #1896724: some db backend (eg sqlserver) doesn't support ADD COLUMN stable
authorSylvain Thénault <sylvain.thenault@logilab.fr>
Thu, 04 Aug 2011 12:50:55 +0200
branchstable
changeset 7736 8767d03dab17
parent 7735 71adfd6bab38
child 7737 db6d296cc66f
[3.13 migration] closes #1896724: some db backend (eg sqlserver) doesn't support ADD COLUMN
misc/migration/bootstrapmigration_repository.py
--- a/misc/migration/bootstrapmigration_repository.py	Thu Aug 04 12:50:49 2011 +0200
+++ b/misc/migration/bootstrapmigration_repository.py	Thu Aug 04 12:50:55 2011 +0200
@@ -36,7 +36,7 @@
     commit(ask_confirm=False)
 
 if applcubicwebversion <= (3, 13, 0) and cubicwebversion >= (3, 13, 1):
-    sql('ALTER TABLE entities ADD COLUMN asource VARCHAR(64)')
+    sql('ALTER TABLE entities ADD asource VARCHAR(64)')
     sql('UPDATE entities SET asource=cw_name  '
         'FROM cw_CWSource, cw_source_relation '
         'WHERE entities.eid=cw_source_relation.eid_from AND cw_source_relation.eid_to=cw_CWSource.cw_eid')