From 56f0295be203771f59e94162b62fa17d4fea54a3 Mon Sep 17 00:00:00 2001 From: Martin Herkt Date: Tue, 1 Nov 2016 05:17:54 +0100 Subject: init --- migrations/versions/0cd36ecdd937_.py | 42 ++++++++++++++++++++++++++++++++++++ 1 file changed, 42 insertions(+) create mode 100644 migrations/versions/0cd36ecdd937_.py (limited to 'migrations/versions') diff --git a/migrations/versions/0cd36ecdd937_.py b/migrations/versions/0cd36ecdd937_.py new file mode 100644 index 0000000..349cab9 --- /dev/null +++ b/migrations/versions/0cd36ecdd937_.py @@ -0,0 +1,42 @@ +"""empty message + +Revision ID: 0cd36ecdd937 +Revises: None +Create Date: 2016-11-01 05:25:42.691768 + +""" + +# revision identifiers, used by Alembic. +revision = '0cd36ecdd937' +down_revision = None + +from alembic import op +import sqlalchemy as sa + + +def upgrade(): + ### commands auto generated by Alembic - please adjust! ### + op.create_table('URL', + sa.Column('id', sa.Integer(), nullable=False), + sa.Column('url', sa.UnicodeText(), nullable=True), + sa.PrimaryKeyConstraint('id'), + sa.UniqueConstraint('url') + ) + op.create_table('file', + sa.Column('id', sa.Integer(), nullable=False), + sa.Column('sha256', sa.String(), nullable=True), + sa.Column('ext', sa.UnicodeText(), nullable=True), + sa.Column('mime', sa.UnicodeText(), nullable=True), + sa.Column('addr', sa.UnicodeText(), nullable=True), + sa.Column('removed', sa.Boolean(), nullable=True), + sa.PrimaryKeyConstraint('id'), + sa.UniqueConstraint('sha256') + ) + ### end Alembic commands ### + + +def downgrade(): + ### commands auto generated by Alembic - please adjust! ### + op.drop_table('file') + op.drop_table('URL') + ### end Alembic commands ### -- cgit v1.2.3