summaryrefslogtreecommitdiff
path: root/animism-align/cli/app/sql/versions
diff options
context:
space:
mode:
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 ###