Fix migration misordering

[cheatdb.git] / migrations / versions / 838081950f27_.py

diff --git a/migrations/versions/838081950f27_.py b/migrations/versions/838081950f27_.py
index f30d547f0b3bf516872189f9ca021f3a1cf286df..b8e5db0736178bc8bd1693964d64740745328d00 100644 (file)
--- a/migrations/versions/838081950f27_.py
+++ b/migrations/versions/838081950f27_.py
@@ -17,14 +17,14 @@ depends_on = None
 
 
 def upgrade():
-       op.create_check_constraint("mp_name_valid", "meta_package", "name ~* '^[a-z0-9_]+$'")
-
        op.execute("""
                DELETE FROM provides AS t USING meta_package AS m WHERE t.metapackage_id = m.id AND NOT (m.name ~* '^[a-z0-9_]+$');
                DELETE FROM dependency AS t USING meta_package AS m WHERE t.meta_package_id = m.id AND NOT (m.name ~* '^[a-z0-9_]+$');
                DELETE FROM meta_package WHERE NOT (name ~* '^[a-z0-9_]+$');
        """)
 
+       op.create_check_constraint("mp_name_valid", "meta_package", "name ~* '^[a-z0-9_]+$'")
+
 
 def downgrade():
        op.drop_constraint("mp_name_valid", "meta_package", type_="check")