From 9de84e3fbae0f2893e9c4f1425afa06899959bf7 Mon Sep 17 00:00:00 2001 From: Cara Salter Date: Wed, 24 Aug 2022 13:15:31 -0400 Subject: flaskify --- migrations/versions/946e687d2d42_roles_users.py | 35 +++++++++++++++++++++++++ 1 file changed, 35 insertions(+) create mode 100644 migrations/versions/946e687d2d42_roles_users.py (limited to 'migrations/versions/946e687d2d42_roles_users.py') diff --git a/migrations/versions/946e687d2d42_roles_users.py b/migrations/versions/946e687d2d42_roles_users.py new file mode 100644 index 0000000..08ebbe2 --- /dev/null +++ b/migrations/versions/946e687d2d42_roles_users.py @@ -0,0 +1,35 @@ +"""roles_users + +Revision ID: 946e687d2d42 +Revises: 81173c1d4f0a +Create Date: 2022-07-25 14:30:56.122119 + +""" +from alembic import op +import sqlalchemy as sa + + +# revision identifiers, used by Alembic. +revision = '946e687d2d42' +down_revision = '81173c1d4f0a' +branch_labels = None +depends_on = None + + +def upgrade(): + # ### commands auto generated by Alembic - please adjust! ### + op.create_table('roles_users', + sa.Column('id', sa.Integer(), nullable=False), + sa.Column('user_id', sa.String(), nullable=True), + sa.Column('role_id', sa.String(), nullable=True), + sa.ForeignKeyConstraint(['role_id'], ['role.id'], ), + sa.ForeignKeyConstraint(['user_id'], ['user.id'], ), + sa.PrimaryKeyConstraint('id') + ) + # ### end Alembic commands ### + + +def downgrade(): + # ### commands auto generated by Alembic - please adjust! ### + op.drop_table('roles_users') + # ### end Alembic commands ### -- cgit v1.2.3