"""empty message

Revision ID: 7bec03a1821
Revises: None
Create Date: 2014-03-23 15:40:43.001498

"""

# revision identifiers, used by Alembic.
revision = '7bec03a1821'
down_revision = None

from alembic import op
import sqlalchemy as sa


def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table('categories',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('name', sa.String(length=100), nullable=False),
    sa.PrimaryKeyConstraint('id'),
    sa.UniqueConstraint('name')
    )
    op.create_table('groups',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('category_id', sa.Integer(), nullable=False),
    sa.Column('parent_id', sa.Integer(), nullable=True),
    sa.ForeignKeyConstraint(['category_id'], ['categories.id'], ),
    sa.ForeignKeyConstraint(['parent_id'], ['groups.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('synonyms',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('group_id', sa.Integer(), nullable=False),
    sa.Column('name', sa.String(length=150), nullable=False),
    sa.ForeignKeyConstraint(['group_id'], ['groups.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    ### end Alembic commands ###


def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.drop_table('synonyms')
    op.drop_table('groups')
    op.drop_table('categories')
    ### end Alembic commands ###

c81aa54fa20426c3266a8f4ca7c13310446ea4cd
<mask token>


def upgrade():
    op.create_table('categories', sa.Column('id', sa.Integer(), nullable=
        False), sa.Column('name', sa.String(length=100), nullable=False),
        sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name'))
    op.create_table('groups', sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('category_id', sa.Integer(), nullable=False), sa.Column(
        'parent_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(
        ['category_id'], ['categories.id']), sa.ForeignKeyConstraint([
        'parent_id'], ['groups.id']), sa.PrimaryKeyConstraint('id'))
    op.create_table('synonyms', sa.Column('id', sa.Integer(), nullable=
        False), sa.Column('group_id', sa.Integer(), nullable=False), sa.
        Column('name', sa.String(length=150), nullable=False), sa.
        ForeignKeyConstraint(['group_id'], ['groups.id']), sa.
        PrimaryKeyConstraint('id'))


<mask token>

<mask token>


def upgrade():
    op.create_table('categories', sa.Column('id', sa.Integer(), nullable=
        False), sa.Column('name', sa.String(length=100), nullable=False),
        sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name'))
    op.create_table('groups', sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('category_id', sa.Integer(), nullable=False), sa.Column(
        'parent_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(
        ['category_id'], ['categories.id']), sa.ForeignKeyConstraint([
        'parent_id'], ['groups.id']), sa.PrimaryKeyConstraint('id'))
    op.create_table('synonyms', sa.Column('id', sa.Integer(), nullable=
        False), sa.Column('group_id', sa.Integer(), nullable=False), sa.
        Column('name', sa.String(length=150), nullable=False), sa.
        ForeignKeyConstraint(['group_id'], ['groups.id']), sa.
        PrimaryKeyConstraint('id'))


def downgrade():
    op.drop_table('synonyms')
    op.drop_table('groups')
    op.drop_table('categories')

<mask token>
revision = '7bec03a1821'
down_revision = None
<mask token>


def upgrade():
    op.create_table('categories', sa.Column('id', sa.Integer(), nullable=
        False), sa.Column('name', sa.String(length=100), nullable=False),
        sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name'))
    op.create_table('groups', sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('category_id', sa.Integer(), nullable=False), sa.Column(
        'parent_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(
        ['category_id'], ['categories.id']), sa.ForeignKeyConstraint([
        'parent_id'], ['groups.id']), sa.PrimaryKeyConstraint('id'))
    op.create_table('synonyms', sa.Column('id', sa.Integer(), nullable=
        False), sa.Column('group_id', sa.Integer(), nullable=False), sa.
        Column('name', sa.String(length=150), nullable=False), sa.
        ForeignKeyConstraint(['group_id'], ['groups.id']), sa.
        PrimaryKeyConstraint('id'))


def downgrade():
    op.drop_table('synonyms')
    op.drop_table('groups')
    op.drop_table('categories')

<mask token>
revision = '7bec03a1821'
down_revision = None
from alembic import op
import sqlalchemy as sa


def upgrade():
    op.create_table('categories', sa.Column('id', sa.Integer(), nullable=
        False), sa.Column('name', sa.String(length=100), nullable=False),
        sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name'))
    op.create_table('groups', sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('category_id', sa.Integer(), nullable=False), sa.Column(
        'parent_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(
        ['category_id'], ['categories.id']), sa.ForeignKeyConstraint([
        'parent_id'], ['groups.id']), sa.PrimaryKeyConstraint('id'))
    op.create_table('synonyms', sa.Column('id', sa.Integer(), nullable=
        False), sa.Column('group_id', sa.Integer(), nullable=False), sa.
        Column('name', sa.String(length=150), nullable=False), sa.
        ForeignKeyConstraint(['group_id'], ['groups.id']), sa.
        PrimaryKeyConstraint('id'))


def downgrade():
    op.drop_table('synonyms')
    op.drop_table('groups')
    op.drop_table('categories')

"""empty message

Revision ID: 7bec03a1821
Revises: None
Create Date: 2014-03-23 15:40:43.001498

"""

# revision identifiers, used by Alembic.
revision = '7bec03a1821'
down_revision = None

from alembic import op
import sqlalchemy as sa


def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table('categories',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('name', sa.String(length=100), nullable=False),
    sa.PrimaryKeyConstraint('id'),
    sa.UniqueConstraint('name')
    )
    op.create_table('groups',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('category_id', sa.Integer(), nullable=False),
    sa.Column('parent_id', sa.Integer(), nullable=True),
    sa.ForeignKeyConstraint(['category_id'], ['categories.id'], ),
    sa.ForeignKeyConstraint(['parent_id'], ['groups.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('synonyms',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('group_id', sa.Integer(), nullable=False),
    sa.Column('name', sa.String(length=150), nullable=False),
    sa.ForeignKeyConstraint(['group_id'], ['groups.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    ### end Alembic commands ###


def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.drop_table('synonyms')
    op.drop_table('groups')
    op.drop_table('categories')
    ### end Alembic commands ###
