Resolve "Admin logins should gain admin privileges"

Closes #122 (closed)

login/migrations/versions/27761560bbcb_.py

 """empty message
 
-Revision ID: 4cdc1d4ed8d1
+Revision ID: 27761560bbcb
 Revises: 
-Create Date: 2021-11-18 11:46:33.222668
+Create Date: 2021-12-21 06:07:14.857940
 
 """
 from alembic import op
@@ -10,7 +10,7 @@ import sqlalchemy as sa
 
 
 # revision identifiers, used by Alembic.
-revision = '4cdc1d4ed8d1'
+revision = '27761560bbcb'
 down_revision = None
 branch_labels = None
 depends_on = None
@@ -25,21 +25,11 @@ def upgrade():
     sa.PrimaryKeyConstraint('id'),
     sa.UniqueConstraint('slug')
     )
-    op.create_table('user',
-    sa.Column('id', sa.Integer(), nullable=False),
-    sa.Column('email', sa.String(), nullable=True),
-    sa.Column('kratos_id', sa.String(), nullable=True),
-    sa.Column('admin', sa.Boolean(), nullable=True),
-    sa.PrimaryKeyConstraint('id'),
-    sa.UniqueConstraint('email'),
-    sa.UniqueConstraint('kratos_id')
-    )
     op.create_table('app_role',
-    sa.Column('user_id', sa.Integer(), nullable=False),
+    sa.Column('user_id', sa.String(), nullable=False),
     sa.Column('app_id', sa.Integer(), nullable=False),
     sa.Column('role', sa.String(), nullable=True),
     sa.ForeignKeyConstraint(['app_id'], ['app.id'], ),
-    sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
     sa.PrimaryKeyConstraint('user_id', 'app_id')
     )
     # ### end Alembic commands ###
@@ -48,6 +38,5 @@ def upgrade():
 def downgrade():
     # ### commands auto generated by Alembic - please adjust! ###
     op.drop_table('app_role')
-    op.drop_table('user')
     op.drop_table('app')
     # ### end Alembic commands ###