diff options
| author | Jules Laplace <julescarbon@gmail.com> | 2020-06-27 13:48:55 +0200 |
|---|---|---|
| committer | Jules Laplace <julescarbon@gmail.com> | 2020-06-27 13:48:55 +0200 |
| commit | 2114d5cedf9e24e8aad91f02e419eb9175289126 (patch) | |
| tree | 33f67f53199fc49340f8159a6cef5aec82c73b51 /animism-align/cli/app/sql/versions/202006231946_create_database.py | |
| parent | 3cf70771cb45cc16ec33ffe44e7a1a4799d8f395 (diff) | |
update db, add paragraph table
Diffstat (limited to 'animism-align/cli/app/sql/versions/202006231946_create_database.py')
| -rw-r--r-- | animism-align/cli/app/sql/versions/202006231946_create_database.py | 47 |
1 files changed, 0 insertions, 47 deletions
diff --git a/animism-align/cli/app/sql/versions/202006231946_create_database.py b/animism-align/cli/app/sql/versions/202006231946_create_database.py deleted file mode 100644 index b74f9b3..0000000 --- a/animism-align/cli/app/sql/versions/202006231946_create_database.py +++ /dev/null @@ -1,47 +0,0 @@ -"""create database - -Revision ID: e45386a1498b -Revises: -Create Date: 2020-06-23 19:46:05.161996 - -""" -from alembic import op -import sqlalchemy as sa -import sqlalchemy_utc - - -# revision identifiers, used by Alembic. -revision = 'e45386a1498b' -down_revision = None -branch_labels = None -depends_on = None - - -def upgrade(): - # ### commands auto generated by Alembic - please adjust! ### - op.create_table('graph', - sa.Column('id', sa.Integer(), nullable=False), - sa.Column('type', sa.String(length=16, _expect_unicode=True), nullable=False), - sa.Column('start_ts', sa.Float(), nullable=False), - sa.Column('end_ts', sa.Float(), nullable=True), - sa.Column('sentence', sa.Text(_expect_unicode=True), nullable=True), - sa.Column('settings', sa.JSON(), nullable=True), - sa.PrimaryKeyConstraint('id') - ) - op.create_table('upload', - sa.Column('id', sa.Integer(), nullable=False), - sa.Column('sha256', sa.String(length=256), nullable=False), - sa.Column('fn', sa.String(length=256), nullable=False), - sa.Column('ext', sa.String(length=4, _expect_unicode=True), nullable=False), - sa.Column('username', sa.String(length=16, _expect_unicode=True), nullable=False), - sa.Column('created_at', sqlalchemy_utc.sqltypes.UtcDateTime(timezone=True), nullable=True), - sa.PrimaryKeyConstraint('id') - ) - # ### end Alembic commands ### - - -def downgrade(): - # ### commands auto generated by Alembic - please adjust! ### - op.drop_table('upload') - op.drop_table('graph') - # ### end Alembic commands ### |
