diff options
Diffstat (limited to 'migrations/versions/49b3fa6a4173_add_manager_to_network.py')
-rw-r--r-- | migrations/versions/49b3fa6a4173_add_manager_to_network.py | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/migrations/versions/49b3fa6a4173_add_manager_to_network.py b/migrations/versions/49b3fa6a4173_add_manager_to_network.py new file mode 100644 index 0000000..028c286 --- /dev/null +++ b/migrations/versions/49b3fa6a4173_add_manager_to_network.py @@ -0,0 +1,30 @@ +"""add manager to network + +Revision ID: 49b3fa6a4173 +Revises: 44e4ecea108b +Create Date: 2022-09-21 12:37:26.465495 + +""" +from alembic import op +import sqlalchemy as sa + + +# revision identifiers, used by Alembic. +revision = '49b3fa6a4173' +down_revision = '44e4ecea108b' +branch_labels = None +depends_on = None + + +def upgrade(): + # ### commands auto generated by Alembic - please adjust! ### + op.add_column('network', sa.Column('manager_id', sa.String(), nullable=False)) + op.create_foreign_key(None, 'network', 'user', ['manager_id'], ['id']) + # ### end Alembic commands ### + + +def downgrade(): + # ### commands auto generated by Alembic - please adjust! ### + op.drop_constraint(None, 'network', type_='foreignkey') + op.drop_column('network', 'manager_id') + # ### end Alembic commands ### |