@@ -0,0 +1,590 @@
+%0A%22%22%22Add roles order column%0A%0ARevision ID: 99925466d6e%0ARevises: 401fb7f0184b%0ACreate Date: 2015-08-05 10:55:43.992382%0A%0A%22%22%22%0A%0Afrom alembic import op%0Aimport sqlalchemy as sa%0A%0A# revision identifiers, used by Alembic.%0Arevision = '99925466d6e'%0Adown_revision = '401fb7f0184b'%0A%0A%0Adef upgrade():%0A  op.add_column(%22roles%22, sa.Column(%22role_order%22, sa.Integer(), nullable=True))%0A  op.execute(%22UPDATE roles SET role_order = id%22)%0A%0A  # creator role should appear before other roles%0A  op.execute(%22UPDATE roles SET role_order = 4 WHERE name='Creator'%22)%0A%0A%0Adef downgrade():%0A  op.drop_column(%22roles%22, %22role_order%22)%0A

Add role_order column to roles table