127be3fb000_added_m2m_forumgroups_table.py 841 B

12345678910111213141516171819202122232425262728293031
  1. """Added m2m forumgroups table
  2. Revision ID: 127be3fb000
  3. Revises: 514ca0a3282c
  4. Create Date: 2015-04-08 22:25:52.809557
  5. """
  6. # revision identifiers, used by Alembic.
  7. revision = '127be3fb000'
  8. down_revision = '514ca0a3282c'
  9. from alembic import op
  10. import sqlalchemy as sa
  11. def upgrade():
  12. ### commands auto generated by Alembic - please adjust! ###
  13. op.create_table('forumgroups',
  14. sa.Column('group_id', sa.Integer(), nullable=False),
  15. sa.Column('forum_id', sa.Integer(), nullable=False),
  16. sa.ForeignKeyConstraint(['forum_id'], ['forums.id'], name='fk_forum_id', use_alter=True),
  17. sa.ForeignKeyConstraint(['group_id'], ['groups.id'], )
  18. )
  19. ### end Alembic commands ###
  20. def downgrade():
  21. ### commands auto generated by Alembic - please adjust! ###
  22. op.drop_table('forumgroups')
  23. ### end Alembic commands ###