From 70afb94d3b985e314ff1f922294875e43c56fefc Mon Sep 17 00:00:00 2001 From: rubenwardy Date: Sat, 2 Jun 2018 18:22:57 +0100 Subject: Add topics todo list based on forum parser --- migrations/versions/adad68a5e370_.py | 37 ++++++++++++++++++++++++++++++++++++ 1 file changed, 37 insertions(+) create mode 100644 migrations/versions/adad68a5e370_.py (limited to 'migrations') diff --git a/migrations/versions/adad68a5e370_.py b/migrations/versions/adad68a5e370_.py new file mode 100644 index 0000000..9773979 --- /dev/null +++ b/migrations/versions/adad68a5e370_.py @@ -0,0 +1,37 @@ +"""empty message + +Revision ID: adad68a5e370 +Revises: d0bec9e5698e +Create Date: 2018-06-02 18:23:18.123340 + +""" +from alembic import op +import sqlalchemy as sa + + +# revision identifiers, used by Alembic. +revision = 'adad68a5e370' +down_revision = 'd0bec9e5698e' +branch_labels = None +depends_on = None + + +def upgrade(): + # ### commands auto generated by Alembic - please adjust! ### + op.create_table('krock_forum_topic', + sa.Column('topic_id', sa.Integer(), autoincrement=False, nullable=False), + sa.Column('author_id', sa.Integer(), nullable=False), + sa.Column('ttype', sa.Integer(), nullable=False), + sa.Column('title', sa.String(length=200), nullable=False), + sa.Column('name', sa.String(length=30), nullable=True), + sa.Column('link', sa.String(length=50), nullable=True), + sa.ForeignKeyConstraint(['author_id'], ['user.id'], ), + sa.PrimaryKeyConstraint('topic_id') + ) + # ### end Alembic commands ### + + +def downgrade(): + # ### commands auto generated by Alembic - please adjust! ### + op.drop_table('krock_forum_topic') + # ### end Alembic commands ### -- cgit v1.2.3