"""empty message

Revision ID: fbe22e1d0825
Revises: 
Create Date: 2018-08-23 19:26:46.982731

"""
from alembic import op
import sqlalchemy as sa


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


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_table('forms',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('name', sa.String(length=50), nullable=True),
    sa.Column('submissions', sa.Integer(), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('fields',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('label', sa.String(length=50), nullable=True),
    sa.Column('name', sa.String(length=50), nullable=True),
    sa.Column('type', sa.String(length=50), nullable=True),
    sa.Column('form_id', sa.Integer(), nullable=False),
    sa.ForeignKeyConstraint(['form_id'], ['forms.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('submissions',
    sa.Column('user_id', sa.Integer(), nullable=False),
    sa.Column('field_id', sa.Integer(), nullable=False),
    sa.Column('input', sa.String(length=50), nullable=True),
    sa.ForeignKeyConstraint(['field_id'], ['fields.id'], ),
    sa.PrimaryKeyConstraint('user_id', 'field_id')
    )
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_table('submissions')
    op.drop_table('fields')
    op.drop_table('forms')
    # ### end Alembic commands ###

2ab8ed8a351522bbe97734d7d45fbf3f46f46c55
<mask token>

<mask token>


def upgrade():
    op.create_table('forms', sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('name', sa.String(length=50), nullable=True), sa.Column(
        'submissions', sa.Integer(), nullable=True), sa.
        PrimaryKeyConstraint('id'))
    op.create_table('fields', sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('label', sa.String(length=50), nullable=True), sa.Column(
        'name', sa.String(length=50), nullable=True), sa.Column('type', sa.
        String(length=50), nullable=True), sa.Column('form_id', sa.Integer(
        ), nullable=False), sa.ForeignKeyConstraint(['form_id'], [
        'forms.id']), sa.PrimaryKeyConstraint('id'))
    op.create_table('submissions', sa.Column('user_id', sa.Integer(),
        nullable=False), sa.Column('field_id', sa.Integer(), nullable=False
        ), sa.Column('input', sa.String(length=50), nullable=True), sa.
        ForeignKeyConstraint(['field_id'], ['fields.id']), sa.
        PrimaryKeyConstraint('user_id', 'field_id'))


def downgrade():
    op.drop_table('submissions')
    op.drop_table('fields')
    op.drop_table('forms')

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


def upgrade():
    op.create_table('forms', sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('name', sa.String(length=50), nullable=True), sa.Column(
        'submissions', sa.Integer(), nullable=True), sa.
        PrimaryKeyConstraint('id'))
    op.create_table('fields', sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('label', sa.String(length=50), nullable=True), sa.Column(
        'name', sa.String(length=50), nullable=True), sa.Column('type', sa.
        String(length=50), nullable=True), sa.Column('form_id', sa.Integer(
        ), nullable=False), sa.ForeignKeyConstraint(['form_id'], [
        'forms.id']), sa.PrimaryKeyConstraint('id'))
    op.create_table('submissions', sa.Column('user_id', sa.Integer(),
        nullable=False), sa.Column('field_id', sa.Integer(), nullable=False
        ), sa.Column('input', sa.String(length=50), nullable=True), sa.
        ForeignKeyConstraint(['field_id'], ['fields.id']), sa.
        PrimaryKeyConstraint('user_id', 'field_id'))


def downgrade():
    op.drop_table('submissions')
    op.drop_table('fields')
    op.drop_table('forms')

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


def upgrade():
    op.create_table('forms', sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('name', sa.String(length=50), nullable=True), sa.Column(
        'submissions', sa.Integer(), nullable=True), sa.
        PrimaryKeyConstraint('id'))
    op.create_table('fields', sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('label', sa.String(length=50), nullable=True), sa.Column(
        'name', sa.String(length=50), nullable=True), sa.Column('type', sa.
        String(length=50), nullable=True), sa.Column('form_id', sa.Integer(
        ), nullable=False), sa.ForeignKeyConstraint(['form_id'], [
        'forms.id']), sa.PrimaryKeyConstraint('id'))
    op.create_table('submissions', sa.Column('user_id', sa.Integer(),
        nullable=False), sa.Column('field_id', sa.Integer(), nullable=False
        ), sa.Column('input', sa.String(length=50), nullable=True), sa.
        ForeignKeyConstraint(['field_id'], ['fields.id']), sa.
        PrimaryKeyConstraint('user_id', 'field_id'))


def downgrade():
    op.drop_table('submissions')
    op.drop_table('fields')
    op.drop_table('forms')

"""empty message

Revision ID: fbe22e1d0825
Revises: 
Create Date: 2018-08-23 19:26:46.982731

"""
from alembic import op
import sqlalchemy as sa


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


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_table('forms',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('name', sa.String(length=50), nullable=True),
    sa.Column('submissions', sa.Integer(), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('fields',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('label', sa.String(length=50), nullable=True),
    sa.Column('name', sa.String(length=50), nullable=True),
    sa.Column('type', sa.String(length=50), nullable=True),
    sa.Column('form_id', sa.Integer(), nullable=False),
    sa.ForeignKeyConstraint(['form_id'], ['forms.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('submissions',
    sa.Column('user_id', sa.Integer(), nullable=False),
    sa.Column('field_id', sa.Integer(), nullable=False),
    sa.Column('input', sa.String(length=50), nullable=True),
    sa.ForeignKeyConstraint(['field_id'], ['fields.id'], ),
    sa.PrimaryKeyConstraint('user_id', 'field_id')
    )
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_table('submissions')
    op.drop_table('fields')
    op.drop_table('forms')
    # ### end Alembic commands ###
