"""empty message

Revision ID: 1444ba317b65
Revises: None
Create Date: 2013-11-25 10:32:40.678287

"""

# revision identifiers, used by Alembic.
revision = '1444ba317b65'
down_revision = None

from alembic import op
import sqlalchemy as sa


def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table('nodes',
    sa.Column('name', sa.String(length=255), nullable=False),
    sa.PrimaryKeyConstraint('name'),
    sa.UniqueConstraint('name')
    )
    op.create_table('packages',
    sa.Column('sha', sa.String(length=64), nullable=False),
    sa.Column('name', sa.String(length=255), nullable=True),
    sa.Column('version', sa.String(length=64), nullable=True),
    sa.Column('uri', sa.String(length=255), nullable=True),
    sa.Column('summary', sa.String(length=255), nullable=True),
    sa.Column('provider', sa.String(length=10), nullable=True),
    sa.Column('architecture', sa.String(length=10), nullable=True),
    sa.PrimaryKeyConstraint('sha'),
    sa.UniqueConstraint('sha')
    )
    op.create_table('node_packages',
    sa.Column('node_name', sa.String(), nullable=False),
    sa.Column('package_sha', sa.Integer(), nullable=False),
    sa.ForeignKeyConstraint(['node_name'], ['nodes.name'], ),
    sa.ForeignKeyConstraint(['package_sha'], ['packages.sha'], ),
    sa.PrimaryKeyConstraint('node_name', 'package_sha')
    )
    ### end Alembic commands ###


def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.drop_table('node_packages')
    op.drop_table('packages')
    op.drop_table('nodes')
    ### end Alembic commands ###

Update db models and migrations to comply with tests
Update db models and migrations to comply with tests

Update test cases to include more scenarios. This required changes in the
db models and collector code.

Delete old migrations and start with a single, new migration.

Signed-off-by: Christoph Kassen <21a19229d09eaaba535d395ba11b820b0886ba87@telekom.de>
