From 83081ad7e488c44757e43ff40e83458a2e1451ed Mon Sep 17 00:00:00 2001 From: Cédric Bonhomme Date: Tue, 1 Mar 2016 22:47:53 +0100 Subject: begin integration of the new architecture --- .../2472eddbf44b_update_of_the_user_model.py | 39 ++++++++++++++++++++++ 1 file changed, 39 insertions(+) create mode 100644 migrations/versions/2472eddbf44b_update_of_the_user_model.py (limited to 'migrations') diff --git a/migrations/versions/2472eddbf44b_update_of_the_user_model.py b/migrations/versions/2472eddbf44b_update_of_the_user_model.py new file mode 100644 index 00000000..e0974015 --- /dev/null +++ b/migrations/versions/2472eddbf44b_update_of_the_user_model.py @@ -0,0 +1,39 @@ +"""update of the user model + +Revision ID: 2472eddbf44b +Revises: ac35c979311a +Create Date: 2016-03-01 22:35:03.659694 + +""" + +# revision identifiers, used by Alembic. +revision = '2472eddbf44b' +down_revision = 'ac35c979311a' +branch_labels = None +depends_on = None + +from alembic import op +import sqlalchemy as sa + + +def upgrade(): + op.drop_column('user', 'roles') + op.drop_column('user', 'enabled') + op.add_column('user', sa.Column('is_active', sa.Boolean(), default=False)) + op.add_column('user', sa.Column('is_admin', sa.Boolean(), default=False)) + op.add_column('user', sa.Column('is_api', sa.Boolean(), default=False)) + op.drop_table('role') + + + +def downgrade(): + op.drop_column('user', 'is_active') + op.drop_column('user', 'is_admin') + op.drop_column('user', 'is_api') + op.create_table('role', + sa.Column('id', sa.INTEGER(), nullable=False), + sa.Column('name', sa.VARCHAR(), nullable=True), + sa.Column('user_id', sa.INTEGER(), nullable=True), + sa.ForeignKeyConstraint(['user_id'], ['user.id'], ), + sa.PrimaryKeyConstraint('id'), + sa.UniqueConstraint('name')) -- cgit