diff options
Diffstat (limited to 'animism-align/cli/app/sql/versions')
11 files changed, 18 insertions, 9 deletions
diff --git a/animism-align/cli/app/sql/versions/202006231946_create_database.py b/animism-align/cli/app/sql/versions/202006271347_add_paragraphs.py index b74f9b3..cc134b5 100644 --- a/animism-align/cli/app/sql/versions/202006231946_create_database.py +++ b/animism-align/cli/app/sql/versions/202006271347_add_paragraphs.py @@ -1,8 +1,8 @@ -"""create database +"""add paragraphs -Revision ID: e45386a1498b +Revision ID: 650f7cdb3174 Revises: -Create Date: 2020-06-23 19:46:05.161996 +Create Date: 2020-06-27 13:47:33.766574 """ from alembic import op @@ -11,7 +11,7 @@ import sqlalchemy_utc # revision identifiers, used by Alembic. -revision = 'e45386a1498b' +revision = '650f7cdb3174' down_revision = None branch_labels = None depends_on = None @@ -19,12 +19,9 @@ depends_on = None def upgrade(): # ### commands auto generated by Alembic - please adjust! ### - op.create_table('graph', + op.create_table('paragraph', 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') ) @@ -37,11 +34,23 @@ def upgrade(): sa.Column('created_at', sqlalchemy_utc.sqltypes.UtcDateTime(timezone=True), nullable=True), sa.PrimaryKeyConstraint('id') ) + op.create_table('timestamp', + 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('settings', sa.JSON(), nullable=True), + sa.ForeignKeyConstraint(['paragraph_id'], ['paragraph.id'], ), + sa.PrimaryKeyConstraint('id') + ) # ### end Alembic commands ### def downgrade(): # ### commands auto generated by Alembic - please adjust! ### + op.drop_table('timestamp') op.drop_table('upload') - op.drop_table('graph') + op.drop_table('paragraph') # ### end Alembic commands ### diff --git a/animism-align/cli/app/sql/versions/__pycache__/202006011922_creating_database.cpython-37.pyc b/animism-align/cli/app/sql/versions/__pycache__/202006011922_creating_database.cpython-37.pyc Binary files differdeleted file mode 100644 index a1adb31..0000000 --- a/animism-align/cli/app/sql/versions/__pycache__/202006011922_creating_database.cpython-37.pyc +++ /dev/null diff --git a/animism-align/cli/app/sql/versions/__pycache__/202006011923_adding_pages_table.cpython-37.pyc b/animism-align/cli/app/sql/versions/__pycache__/202006011923_adding_pages_table.cpython-37.pyc Binary files differdeleted file mode 100644 index beeeb71..0000000 --- a/animism-align/cli/app/sql/versions/__pycache__/202006011923_adding_pages_table.cpython-37.pyc +++ /dev/null diff --git a/animism-align/cli/app/sql/versions/__pycache__/202006011925_adding_tiles_table.cpython-37.pyc b/animism-align/cli/app/sql/versions/__pycache__/202006011925_adding_tiles_table.cpython-37.pyc Binary files differdeleted file mode 100644 index 8d16725..0000000 --- a/animism-align/cli/app/sql/versions/__pycache__/202006011925_adding_tiles_table.cpython-37.pyc +++ /dev/null diff --git a/animism-align/cli/app/sql/versions/__pycache__/202006011937_adding_pages.cpython-37.pyc b/animism-align/cli/app/sql/versions/__pycache__/202006011937_adding_pages.cpython-37.pyc Binary files differdeleted file mode 100644 index 35b459c..0000000 --- a/animism-align/cli/app/sql/versions/__pycache__/202006011937_adding_pages.cpython-37.pyc +++ /dev/null diff --git a/animism-align/cli/app/sql/versions/__pycache__/202006011943_adding_database.cpython-37.pyc b/animism-align/cli/app/sql/versions/__pycache__/202006011943_adding_database.cpython-37.pyc Binary files differdeleted file mode 100644 index adf3587..0000000 --- a/animism-align/cli/app/sql/versions/__pycache__/202006011943_adding_database.cpython-37.pyc +++ /dev/null diff --git a/animism-align/cli/app/sql/versions/__pycache__/202006011944_adding_uploads.cpython-37.pyc b/animism-align/cli/app/sql/versions/__pycache__/202006011944_adding_uploads.cpython-37.pyc Binary files differdeleted file mode 100644 index 159dc66..0000000 --- a/animism-align/cli/app/sql/versions/__pycache__/202006011944_adding_uploads.cpython-37.pyc +++ /dev/null diff --git a/animism-align/cli/app/sql/versions/__pycache__/202006021608_creating_database.cpython-37.pyc b/animism-align/cli/app/sql/versions/__pycache__/202006021608_creating_database.cpython-37.pyc Binary files differdeleted file mode 100644 index c5df7ca..0000000 --- a/animism-align/cli/app/sql/versions/__pycache__/202006021608_creating_database.cpython-37.pyc +++ /dev/null diff --git a/animism-align/cli/app/sql/versions/__pycache__/202006041801_add_sort_order_to_tiles.cpython-37.pyc b/animism-align/cli/app/sql/versions/__pycache__/202006041801_add_sort_order_to_tiles.cpython-37.pyc Binary files differdeleted file mode 100644 index 67e35cf..0000000 --- a/animism-align/cli/app/sql/versions/__pycache__/202006041801_add_sort_order_to_tiles.cpython-37.pyc +++ /dev/null diff --git a/animism-align/cli/app/sql/versions/__pycache__/202006231946_create_database.cpython-37.pyc b/animism-align/cli/app/sql/versions/__pycache__/202006231946_create_database.cpython-37.pyc Binary files differdeleted file mode 100644 index dd49abc..0000000 --- a/animism-align/cli/app/sql/versions/__pycache__/202006231946_create_database.cpython-37.pyc +++ /dev/null diff --git a/animism-align/cli/app/sql/versions/__pycache__/202006271347_add_paragraphs.cpython-37.pyc b/animism-align/cli/app/sql/versions/__pycache__/202006271347_add_paragraphs.cpython-37.pyc Binary files differnew file mode 100644 index 0000000..79fc207 --- /dev/null +++ b/animism-align/cli/app/sql/versions/__pycache__/202006271347_add_paragraphs.cpython-37.pyc |