# HG changeset patch
# User Julien Cristau <julien.cristau@logilab.fr>
# Date 1443534550 -7200
# Node ID ffef8ac383f44ac51243bb31fb02f0ca18a00886
# Parent  93f8d239c708bfacf624b6d5bed53b2a0264d234
moved_entities.extid may not be NULL

diff -r 93f8d239c708 -r ffef8ac383f4 misc/migration/3.21.2_Any.py
--- a/misc/migration/3.21.2_Any.py	Tue Sep 29 15:15:03 2015 +0200
+++ b/misc/migration/3.21.2_Any.py	Tue Sep 29 15:49:10 2015 +0200
@@ -1,1 +1,7 @@
 sync_schema_props_perms('cwuri')
+
+helper = repo.system_source.dbhelper
+cu = session.cnxset.cu
+helper.set_null_allowed(cu, 'moved_entities', 'extid', 'VARCHAR(256)', False)
+
+commit()
diff -r 93f8d239c708 -r ffef8ac383f4 server/sources/native.py
--- a/server/sources/native.py	Tue Sep 29 15:15:03 2015 +0200
+++ b/server/sources/native.py	Tue Sep 29 15:49:10 2015 +0200
@@ -1405,7 +1405,7 @@
 CREATE INDEX entities_type_idx ON entities(type);;
 CREATE TABLE moved_entities (
   eid INTEGER PRIMARY KEY NOT NULL,
-  extid VARCHAR(256) UNIQUE
+  extid VARCHAR(256) UNIQUE NOT NULL
 );;
 
 CREATE TABLE transactions (