--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/cubicweb/misc/migration/3.23.0_Any.py	Wed Mar 16 11:56:32 2016 +0100
@@ -0,0 +1,24 @@
+# we changed constraint serialization, which also changes their name
+from cubicweb.server.schema2sql import check_constraint
+
+helper = repo.system_source.dbhelper
+
+for table, cstr in sql("""
+    SELECT table_name, constraint_name FROM information_schema.constraint_column_usage
+    WHERE constraint_name LIKE 'cstr%'"""):
+    sql("ALTER TABLE %(table)s DROP CONSTRAINT %(cstr)s" % locals())
+
+for cwconstraint in rql('Any C WHERE R constrained_by C').entities():
+    cwrdef = cwconstraint.reverse_constrained_by[0]
+    rdef = cwrdef.yams_schema()
+    cstr = rdef.constraint_by_eid(cwconstraint.eid)
+    if cstr.type() not in ('BoundaryConstraint', 'IntervalBoundConstraint',
+                           'StaticVocabularyConstraint'):
+        # These cannot be translate into backend CHECK.
+        continue
+    cstrname, check = check_constraint(rdef.subject, rdef.object, rdef.rtype.type,
+                                       cstr, helper, prefix='cw_')
+    args = {'e': rdef.subject.type, 'c': cstrname, 'v': check}
+    sql('ALTER TABLE cw_%(e)s ADD CONSTRAINT %(c)s CHECK(%(v)s)' % args)
+
+commit()