"""empty message

Revision ID: a74a638db58f
Revises: 
Create Date: 2019-02-25 00:36:50.280541

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = 'a74a638db58f'
down_revision = None
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_table('project',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('name', sa.String(length=128), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('user',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('email', sa.String(length=256), nullable=True),
    sa.Column('group', sa.String(length=128), nullable=True),
    sa.Column('project_id', sa.Integer(), nullable=False),
    sa.ForeignKeyConstraint(['project_id'], ['project.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('week',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('num', sa.Integer(), nullable=True),
    sa.Column('descr', sa.Text(), nullable=True),
    sa.Column('is_active', sa.Boolean(), nullable=True),
    sa.Column('project_id', sa.Integer(), nullable=False),
    sa.ForeignKeyConstraint(['project_id'], ['project.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('applic',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('user_id', sa.Integer(), nullable=False),
    sa.Column('week_id', sa.Integer(), nullable=False),
    sa.Column('is_all_done', sa.Boolean(), nullable=True),
    sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
    sa.ForeignKeyConstraint(['week_id'], ['week.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('assqt',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('week_id', sa.Integer(), nullable=False),
    sa.Column('user_id', sa.Integer(), nullable=False),
    sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
    sa.ForeignKeyConstraint(['week_id'], ['week.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('check',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('user_id', sa.Integer(), nullable=False),
    sa.Column('week_id', sa.Integer(), nullable=False),
    sa.Column('is_all_done', sa.Boolean(), nullable=True),
    sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
    sa.ForeignKeyConstraint(['week_id'], ['week.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('task',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('week_id', sa.Integer(), nullable=False),
    sa.Column('num', sa.Integer(), nullable=True),
    sa.Column('descr', sa.Text(), nullable=True),
    sa.ForeignKeyConstraint(['week_id'], ['week.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('answer',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('user_id', sa.Integer(), nullable=False),
    sa.Column('task_id', sa.Integer(), nullable=False),
    sa.Column('answer', sa.Text(), nullable=True),
    sa.ForeignKeyConstraint(['task_id'], ['task.id'], ),
    sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('assessment',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('answer_id', sa.Integer(), nullable=False),
    sa.Column('assessed_by_id', sa.Integer(), nullable=False),
    sa.Column('score', sa.Integer(), nullable=True),
    sa.Column('descr', sa.Text(), nullable=True),
    sa.ForeignKeyConstraint(['answer_id'], ['answer.id'], ),
    sa.ForeignKeyConstraint(['assessed_by_id'], ['user.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('assqt_helper',
    sa.Column('answer_id', sa.Integer(), nullable=False),
    sa.Column('assqt_id', sa.Integer(), nullable=False),
    sa.ForeignKeyConstraint(['answer_id'], ['answer.id'], ),
    sa.ForeignKeyConstraint(['assqt_id'], ['assqt.id'], ),
    sa.PrimaryKeyConstraint('answer_id', 'assqt_id')
    )
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_table('assqt_helper')
    op.drop_table('assessment')
    op.drop_table('answer')
    op.drop_table('task')
    op.drop_table('check')
    op.drop_table('assqt')
    op.drop_table('applic')
    op.drop_table('week')
    op.drop_table('user')
    op.drop_table('project')
    # ### end Alembic commands ###

8db1275cb785081279725f4dcf068605b781d6d7
<mask token>


def downgrade():
    op.drop_table('assqt_helper')
    op.drop_table('assessment')
    op.drop_table('answer')
    op.drop_table('task')
    op.drop_table('check')
    op.drop_table('assqt')
    op.drop_table('applic')
    op.drop_table('week')
    op.drop_table('user')
    op.drop_table('project')

<mask token>


def upgrade():
    op.create_table('project', sa.Column('id', sa.Integer(), nullable=False
        ), sa.Column('name', sa.String(length=128), nullable=True), sa.
        PrimaryKeyConstraint('id'))
    op.create_table('user', sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('email', sa.String(length=256), nullable=True), sa.Column
        ('group', sa.String(length=128), nullable=True), sa.Column(
        'project_id', sa.Integer(), nullable=False), sa.
        ForeignKeyConstraint(['project_id'], ['project.id']), sa.
        PrimaryKeyConstraint('id'))
    op.create_table('week', sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('num', sa.Integer(), nullable=True), sa.Column('descr',
        sa.Text(), nullable=True), sa.Column('is_active', sa.Boolean(),
        nullable=True), sa.Column('project_id', sa.Integer(), nullable=
        False), sa.ForeignKeyConstraint(['project_id'], ['project.id']), sa
        .PrimaryKeyConstraint('id'))
    op.create_table('applic', sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('user_id', sa.Integer(), nullable=False), sa.Column(
        'week_id', sa.Integer(), nullable=False), sa.Column('is_all_done',
        sa.Boolean(), nullable=True), sa.ForeignKeyConstraint(['user_id'],
        ['user.id']), sa.ForeignKeyConstraint(['week_id'], ['week.id']), sa
        .PrimaryKeyConstraint('id'))
    op.create_table('assqt', sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('week_id', sa.Integer(), nullable=False), sa.Column(
        'user_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint([
        'user_id'], ['user.id']), sa.ForeignKeyConstraint(['week_id'], [
        'week.id']), sa.PrimaryKeyConstraint('id'))
    op.create_table('check', sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('user_id', sa.Integer(), nullable=False), sa.Column(
        'week_id', sa.Integer(), nullable=False), sa.Column('is_all_done',
        sa.Boolean(), nullable=True), sa.ForeignKeyConstraint(['user_id'],
        ['user.id']), sa.ForeignKeyConstraint(['week_id'], ['week.id']), sa
        .PrimaryKeyConstraint('id'))
    op.create_table('task', sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('week_id', sa.Integer(), nullable=False), sa.Column('num',
        sa.Integer(), nullable=True), sa.Column('descr', sa.Text(),
        nullable=True), sa.ForeignKeyConstraint(['week_id'], ['week.id']),
        sa.PrimaryKeyConstraint('id'))
    op.create_table('answer', sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('user_id', sa.Integer(), nullable=False), sa.Column(
        'task_id', sa.Integer(), nullable=False), sa.Column('answer', sa.
        Text(), nullable=True), sa.ForeignKeyConstraint(['task_id'], [
        'task.id']), sa.ForeignKeyConstraint(['user_id'], ['user.id']), sa.
        PrimaryKeyConstraint('id'))
    op.create_table('assessment', sa.Column('id', sa.Integer(), nullable=
        False), sa.Column('answer_id', sa.Integer(), nullable=False), sa.
        Column('assessed_by_id', sa.Integer(), nullable=False), sa.Column(
        'score', sa.Integer(), nullable=True), sa.Column('descr', sa.Text(),
        nullable=True), sa.ForeignKeyConstraint(['answer_id'], ['answer.id'
        ]), sa.ForeignKeyConstraint(['assessed_by_id'], ['user.id']), sa.
        PrimaryKeyConstraint('id'))
    op.create_table('assqt_helper', sa.Column('answer_id', sa.Integer(),
        nullable=False), sa.Column('assqt_id', sa.Integer(), nullable=False
        ), sa.ForeignKeyConstraint(['answer_id'], ['answer.id']), sa.
        ForeignKeyConstraint(['assqt_id'], ['assqt.id']), sa.
        PrimaryKeyConstraint('answer_id', 'assqt_id'))


def downgrade():
    op.drop_table('assqt_helper')
    op.drop_table('assessment')
    op.drop_table('answer')
    op.drop_table('task')
    op.drop_table('check')
    op.drop_table('assqt')
    op.drop_table('applic')
    op.drop_table('week')
    op.drop_table('user')
    op.drop_table('project')

<mask token>
revision = 'a74a638db58f'
down_revision = None
branch_labels = None
depends_on = None


def upgrade():
    op.create_table('project', sa.Column('id', sa.Integer(), nullable=False
        ), sa.Column('name', sa.String(length=128), nullable=True), sa.
        PrimaryKeyConstraint('id'))
    op.create_table('user', sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('email', sa.String(length=256), nullable=True), sa.Column
        ('group', sa.String(length=128), nullable=True), sa.Column(
        'project_id', sa.Integer(), nullable=False), sa.
        ForeignKeyConstraint(['project_id'], ['project.id']), sa.
        PrimaryKeyConstraint('id'))
    op.create_table('week', sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('num', sa.Integer(), nullable=True), sa.Column('descr',
        sa.Text(), nullable=True), sa.Column('is_active', sa.Boolean(),
        nullable=True), sa.Column('project_id', sa.Integer(), nullable=
        False), sa.ForeignKeyConstraint(['project_id'], ['project.id']), sa
        .PrimaryKeyConstraint('id'))
    op.create_table('applic', sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('user_id', sa.Integer(), nullable=False), sa.Column(
        'week_id', sa.Integer(), nullable=False), sa.Column('is_all_done',
        sa.Boolean(), nullable=True), sa.ForeignKeyConstraint(['user_id'],
        ['user.id']), sa.ForeignKeyConstraint(['week_id'], ['week.id']), sa
        .PrimaryKeyConstraint('id'))
    op.create_table('assqt', sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('week_id', sa.Integer(), nullable=False), sa.Column(
        'user_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint([
        'user_id'], ['user.id']), sa.ForeignKeyConstraint(['week_id'], [
        'week.id']), sa.PrimaryKeyConstraint('id'))
    op.create_table('check', sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('user_id', sa.Integer(), nullable=False), sa.Column(
        'week_id', sa.Integer(), nullable=False), sa.Column('is_all_done',
        sa.Boolean(), nullable=True), sa.ForeignKeyConstraint(['user_id'],
        ['user.id']), sa.ForeignKeyConstraint(['week_id'], ['week.id']), sa
        .PrimaryKeyConstraint('id'))
    op.create_table('task', sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('week_id', sa.Integer(), nullable=False), sa.Column('num',
        sa.Integer(), nullable=True), sa.Column('descr', sa.Text(),
        nullable=True), sa.ForeignKeyConstraint(['week_id'], ['week.id']),
        sa.PrimaryKeyConstraint('id'))
    op.create_table('answer', sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('user_id', sa.Integer(), nullable=False), sa.Column(
        'task_id', sa.Integer(), nullable=False), sa.Column('answer', sa.
        Text(), nullable=True), sa.ForeignKeyConstraint(['task_id'], [
        'task.id']), sa.ForeignKeyConstraint(['user_id'], ['user.id']), sa.
        PrimaryKeyConstraint('id'))
    op.create_table('assessment', sa.Column('id', sa.Integer(), nullable=
        False), sa.Column('answer_id', sa.Integer(), nullable=False), sa.
        Column('assessed_by_id', sa.Integer(), nullable=False), sa.Column(
        'score', sa.Integer(), nullable=True), sa.Column('descr', sa.Text(),
        nullable=True), sa.ForeignKeyConstraint(['answer_id'], ['answer.id'
        ]), sa.ForeignKeyConstraint(['assessed_by_id'], ['user.id']), sa.
        PrimaryKeyConstraint('id'))
    op.create_table('assqt_helper', sa.Column('answer_id', sa.Integer(),
        nullable=False), sa.Column('assqt_id', sa.Integer(), nullable=False
        ), sa.ForeignKeyConstraint(['answer_id'], ['answer.id']), sa.
        ForeignKeyConstraint(['assqt_id'], ['assqt.id']), sa.
        PrimaryKeyConstraint('answer_id', 'assqt_id'))


def downgrade():
    op.drop_table('assqt_helper')
    op.drop_table('assessment')
    op.drop_table('answer')
    op.drop_table('task')
    op.drop_table('check')
    op.drop_table('assqt')
    op.drop_table('applic')
    op.drop_table('week')
    op.drop_table('user')
    op.drop_table('project')

<mask token>
from alembic import op
import sqlalchemy as sa
revision = 'a74a638db58f'
down_revision = None
branch_labels = None
depends_on = None


def upgrade():
    op.create_table('project', sa.Column('id', sa.Integer(), nullable=False
        ), sa.Column('name', sa.String(length=128), nullable=True), sa.
        PrimaryKeyConstraint('id'))
    op.create_table('user', sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('email', sa.String(length=256), nullable=True), sa.Column
        ('group', sa.String(length=128), nullable=True), sa.Column(
        'project_id', sa.Integer(), nullable=False), sa.
        ForeignKeyConstraint(['project_id'], ['project.id']), sa.
        PrimaryKeyConstraint('id'))
    op.create_table('week', sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('num', sa.Integer(), nullable=True), sa.Column('descr',
        sa.Text(), nullable=True), sa.Column('is_active', sa.Boolean(),
        nullable=True), sa.Column('project_id', sa.Integer(), nullable=
        False), sa.ForeignKeyConstraint(['project_id'], ['project.id']), sa
        .PrimaryKeyConstraint('id'))
    op.create_table('applic', sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('user_id', sa.Integer(), nullable=False), sa.Column(
        'week_id', sa.Integer(), nullable=False), sa.Column('is_all_done',
        sa.Boolean(), nullable=True), sa.ForeignKeyConstraint(['user_id'],
        ['user.id']), sa.ForeignKeyConstraint(['week_id'], ['week.id']), sa
        .PrimaryKeyConstraint('id'))
    op.create_table('assqt', sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('week_id', sa.Integer(), nullable=False), sa.Column(
        'user_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint([
        'user_id'], ['user.id']), sa.ForeignKeyConstraint(['week_id'], [
        'week.id']), sa.PrimaryKeyConstraint('id'))
    op.create_table('check', sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('user_id', sa.Integer(), nullable=False), sa.Column(
        'week_id', sa.Integer(), nullable=False), sa.Column('is_all_done',
        sa.Boolean(), nullable=True), sa.ForeignKeyConstraint(['user_id'],
        ['user.id']), sa.ForeignKeyConstraint(['week_id'], ['week.id']), sa
        .PrimaryKeyConstraint('id'))
    op.create_table('task', sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('week_id', sa.Integer(), nullable=False), sa.Column('num',
        sa.Integer(), nullable=True), sa.Column('descr', sa.Text(),
        nullable=True), sa.ForeignKeyConstraint(['week_id'], ['week.id']),
        sa.PrimaryKeyConstraint('id'))
    op.create_table('answer', sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('user_id', sa.Integer(), nullable=False), sa.Column(
        'task_id', sa.Integer(), nullable=False), sa.Column('answer', sa.
        Text(), nullable=True), sa.ForeignKeyConstraint(['task_id'], [
        'task.id']), sa.ForeignKeyConstraint(['user_id'], ['user.id']), sa.
        PrimaryKeyConstraint('id'))
    op.create_table('assessment', sa.Column('id', sa.Integer(), nullable=
        False), sa.Column('answer_id', sa.Integer(), nullable=False), sa.
        Column('assessed_by_id', sa.Integer(), nullable=False), sa.Column(
        'score', sa.Integer(), nullable=True), sa.Column('descr', sa.Text(),
        nullable=True), sa.ForeignKeyConstraint(['answer_id'], ['answer.id'
        ]), sa.ForeignKeyConstraint(['assessed_by_id'], ['user.id']), sa.
        PrimaryKeyConstraint('id'))
    op.create_table('assqt_helper', sa.Column('answer_id', sa.Integer(),
        nullable=False), sa.Column('assqt_id', sa.Integer(), nullable=False
        ), sa.ForeignKeyConstraint(['answer_id'], ['answer.id']), sa.
        ForeignKeyConstraint(['assqt_id'], ['assqt.id']), sa.
        PrimaryKeyConstraint('answer_id', 'assqt_id'))


def downgrade():
    op.drop_table('assqt_helper')
    op.drop_table('assessment')
    op.drop_table('answer')
    op.drop_table('task')
    op.drop_table('check')
    op.drop_table('assqt')
    op.drop_table('applic')
    op.drop_table('week')
    op.drop_table('user')
    op.drop_table('project')

"""empty message

Revision ID: a74a638db58f
Revises: 
Create Date: 2019-02-25 00:36:50.280541

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = 'a74a638db58f'
down_revision = None
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_table('project',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('name', sa.String(length=128), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('user',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('email', sa.String(length=256), nullable=True),
    sa.Column('group', sa.String(length=128), nullable=True),
    sa.Column('project_id', sa.Integer(), nullable=False),
    sa.ForeignKeyConstraint(['project_id'], ['project.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('week',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('num', sa.Integer(), nullable=True),
    sa.Column('descr', sa.Text(), nullable=True),
    sa.Column('is_active', sa.Boolean(), nullable=True),
    sa.Column('project_id', sa.Integer(), nullable=False),
    sa.ForeignKeyConstraint(['project_id'], ['project.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('applic',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('user_id', sa.Integer(), nullable=False),
    sa.Column('week_id', sa.Integer(), nullable=False),
    sa.Column('is_all_done', sa.Boolean(), nullable=True),
    sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
    sa.ForeignKeyConstraint(['week_id'], ['week.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('assqt',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('week_id', sa.Integer(), nullable=False),
    sa.Column('user_id', sa.Integer(), nullable=False),
    sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
    sa.ForeignKeyConstraint(['week_id'], ['week.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('check',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('user_id', sa.Integer(), nullable=False),
    sa.Column('week_id', sa.Integer(), nullable=False),
    sa.Column('is_all_done', sa.Boolean(), nullable=True),
    sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
    sa.ForeignKeyConstraint(['week_id'], ['week.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('task',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('week_id', sa.Integer(), nullable=False),
    sa.Column('num', sa.Integer(), nullable=True),
    sa.Column('descr', sa.Text(), nullable=True),
    sa.ForeignKeyConstraint(['week_id'], ['week.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('answer',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('user_id', sa.Integer(), nullable=False),
    sa.Column('task_id', sa.Integer(), nullable=False),
    sa.Column('answer', sa.Text(), nullable=True),
    sa.ForeignKeyConstraint(['task_id'], ['task.id'], ),
    sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('assessment',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('answer_id', sa.Integer(), nullable=False),
    sa.Column('assessed_by_id', sa.Integer(), nullable=False),
    sa.Column('score', sa.Integer(), nullable=True),
    sa.Column('descr', sa.Text(), nullable=True),
    sa.ForeignKeyConstraint(['answer_id'], ['answer.id'], ),
    sa.ForeignKeyConstraint(['assessed_by_id'], ['user.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('assqt_helper',
    sa.Column('answer_id', sa.Integer(), nullable=False),
    sa.Column('assqt_id', sa.Integer(), nullable=False),
    sa.ForeignKeyConstraint(['answer_id'], ['answer.id'], ),
    sa.ForeignKeyConstraint(['assqt_id'], ['assqt.id'], ),
    sa.PrimaryKeyConstraint('answer_id', 'assqt_id')
    )
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_table('assqt_helper')
    op.drop_table('assessment')
    op.drop_table('answer')
    op.drop_table('task')
    op.drop_table('check')
    op.drop_table('assqt')
    op.drop_table('applic')
    op.drop_table('week')
    op.drop_table('user')
    op.drop_table('project')
    # ### end Alembic commands ###
