diff options
Diffstat (limited to 'animism-align/cli/app/sql/versions')
| -rw-r--r-- | animism-align/cli/app/sql/versions/202007041633_create_database.py (renamed from animism-align/cli/app/sql/versions/202006271347_add_paragraphs.py) | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/animism-align/cli/app/sql/versions/202006271347_add_paragraphs.py b/animism-align/cli/app/sql/versions/202007041633_create_database.py index cc134b5..f8336e5 100644 --- a/animism-align/cli/app/sql/versions/202006271347_add_paragraphs.py +++ b/animism-align/cli/app/sql/versions/202007041633_create_database.py @@ -1,8 +1,8 @@ -"""add paragraphs +"""create database -Revision ID: 650f7cdb3174 +Revision ID: f8936a84e584 Revises: -Create Date: 2020-06-27 13:47:33.766574 +Create Date: 2020-07-04 16:33:01.643193 """ from alembic import op @@ -11,7 +11,7 @@ import sqlalchemy_utc # revision identifiers, used by Alembic. -revision = '650f7cdb3174' +revision = 'f8936a84e584' down_revision = None branch_labels = None depends_on = None @@ -34,13 +34,13 @@ def upgrade(): sa.Column('created_at', sqlalchemy_utc.sqltypes.UtcDateTime(timezone=True), nullable=True), sa.PrimaryKeyConstraint('id') ) - op.create_table('timestamp', + op.create_table('annotation', sa.Column('id', sa.Integer(), nullable=False), sa.Column('type', sa.String(length=16, _expect_unicode=True), nullable=False), sa.Column('paragraph_id', sa.Integer(), nullable=True), 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('text', sa.Text(_expect_unicode=True), nullable=True), sa.Column('settings', sa.JSON(), nullable=True), sa.ForeignKeyConstraint(['paragraph_id'], ['paragraph.id'], ), sa.PrimaryKeyConstraint('id') @@ -50,7 +50,7 @@ def upgrade(): def downgrade(): # ### commands auto generated by Alembic - please adjust! ### - op.drop_table('timestamp') + op.drop_table('annotation') op.drop_table('upload') op.drop_table('paragraph') # ### end Alembic commands ### |
