2 files changed, 16 insertions, 41 deletions
diff --git a/cli/app/sql/versions/202006011944_adding_uploads.py b/cli/app/sql/versions/202006011944_adding_uploads.py
deleted file mode 100644
index f09f013..0000000
--- a/cli/app/sql/versions/202006011944_adding_uploads.py
+++ /dev/null
@@ -1,37 +0,0 @@
-"""adding uploads
-
-Revision ID: 5b926731a4ac
-Revises: 7acd0c82a048
-Create Date: 2020-06-01 19:44:30.400513
-
-"""
-from alembic import op
-import sqlalchemy as sa
-import sqlalchemy_utc
-
-
-# revision identifiers, used by Alembic.
-revision = '5b926731a4ac'
-down_revision = '7acd0c82a048'
-branch_labels = None
-depends_on = None
-
-
-def upgrade():
-    # ### commands auto generated by Alembic - please adjust! ###
-    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')
-    # ### end Alembic commands ###
diff --git a/cli/app/sql/versions/202006011943_adding_database.py b/cli/app/sql/versions/202006021608_creating_database.py
index 4e5b0e6..7c6e54a 100644
--- a/cli/app/sql/versions/202006011943_adding_database.py
+++ b/cli/app/sql/versions/202006021608_creating_database.py
@@ -1,8 +1,8 @@
-"""adding database
+"""creating database
 
-Revision ID: 7acd0c82a048
+Revision ID: 453787357254
 Revises: 
-Create Date: 2020-06-01 19:43:53.359855
+Create Date: 2020-06-02 16:08:43.195875
 
 """
 from alembic import op
@@ -11,7 +11,7 @@ import sqlalchemy_utc
 
 
 # revision identifiers, used by Alembic.
-revision = '7acd0c82a048'
+revision = '453787357254'
 down_revision = None
 branch_labels = None
 depends_on = None
@@ -23,17 +23,28 @@ def upgrade():
     sa.Column('id', sa.Integer(), nullable=False),
     sa.Column('path', sa.String(length=64, _expect_unicode=True), nullable=False),
     sa.Column('title', sa.String(length=64, _expect_unicode=True), nullable=False),
+    sa.Column('username', sa.String(length=32, _expect_unicode=True), nullable=False),
     sa.Column('description', sa.Text(_expect_unicode=True), nullable=False),
     sa.Column('settings', sa.JSON(), nullable=True),
     sa.Column('created_at', sqlalchemy_utc.sqltypes.UtcDateTime(timezone=True), nullable=True),
     sa.Column('updated_at', sqlalchemy_utc.sqltypes.UtcDateTime(timezone=True), 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')
+    )
     op.create_table('page',
     sa.Column('id', sa.Integer(), nullable=False),
     sa.Column('graph_id', sa.Integer(), nullable=True),
     sa.Column('path', sa.String(length=64, _expect_unicode=True), nullable=False),
     sa.Column('title', sa.String(length=64, _expect_unicode=True), nullable=False),
+    sa.Column('username', sa.String(length=32, _expect_unicode=True), nullable=False),
     sa.Column('description', sa.Text(_expect_unicode=True), nullable=False),
     sa.Column('settings', sa.JSON(), nullable=True),
     sa.Column('created_at', sqlalchemy_utc.sqltypes.UtcDateTime(timezone=True), nullable=True),
@@ -62,5 +73,6 @@ def downgrade():
     # ### commands auto generated by Alembic - please adjust! ###
     op.drop_table('tile')
     op.drop_table('page')
+    op.drop_table('upload')
     op.drop_table('graph')
     # ### end Alembic commands ###