<filename>src/sw/allotmentclub/alembic/versions/add_sale_history_c3c978348cbf.py
"""Add sale history

Revision ID: <KEY>
Revises: cc8ba97635c1
Create Date: 2016-02-03 21:14:16.233171

"""
from alembic import op
import sqlalchemy as sa

# revision identifiers, used by Alembic.
revision = '<KEY>'
down_revision = '<KEY>'


def upgrade():
    op.create_table(
        'salehistory',
        sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('seller_id', sa.Integer(), nullable=False),
        sa.Column('buyer_id', sa.Integer(), nullable=False),
        sa.Column('date', sa.Date(), nullable=False),
        sa.PrimaryKeyConstraint('id')
    )


def downgrade():
    op.drop_table('salehistory')

<filename>src/sw/allotmentclub/alembic/versions/add_sale_history_c3c978348cbf.py
"""Add sale history

Revision ID: <KEY>
Revises: cc8ba97635c1
Create Date: 2016-02-03 21:14:16.233171

"""
from alembic import op
import sqlalchemy as sa

# revision identifiers, used by Alembic.
revision = '<KEY>'
down_revision = '<KEY>'


def upgrade():
    op.create_table(
        'salehistory',
        sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('seller_id', sa.Integer(), nullable=False),
        sa.Column('buyer_id', sa.Integer(), nullable=False),
        sa.Column('date', sa.Date(), nullable=False),
        sa.PrimaryKeyConstraint('id')
    )


def downgrade():
    op.drop_table('salehistory')

Add sale history  Revision ID: <KEY> Revises: cc8ba97635c1 Create Date: 2016-02-03 21:14:16.233171 # revision identifiers, used by Alembic.