"""empty message Revision ID: 783d98209305 Revises: Create Date: 2019-04-17 11:23:56.562232 """ from alembic import op import sqlalchemy as sa # revision identifiers, used by Alembic. revision = '783d98209305' down_revision = None branch_labels = None depends_on = None def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('users', sa.Column('id', sa.Integer(), nullable=False), sa.Column('email', sa.String(), nullable=False), sa.Column('_password', sa.Binary(), nullable=False), sa.Column('authenticated', sa.Boolean(), nullable=True), sa.Column('email_confirmation_sent_on', sa.DateTime(), nullable=True), sa.Column('email_confirmed', sa.Boolean(), nullable=True), sa.Column('email_confirmed_on', sa.DateTime(), nullable=True), sa.Column('registered_on', sa.DateTime(), nullable=True), sa.Column('last_logged_in', sa.DateTime(), nullable=True), sa.Column('current_logged_in', sa.DateTime(), nullable=True), sa.Column('role', sa.String(), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email') ) op.create_table('items', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(), nullable=False), sa.Column('notes', sa.String(), nullable=True), sa.Column('user_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['user_id'], ['users.id'], ), sa.PrimaryKeyConstraint('id') ) # ### end Alembic commands ### def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_table('items') op.drop_table('users') # ### end Alembic commands ###