<filename>ocdskingfisher/maindatabase/migrations/versions/c9b3a2f75f20_gather_fetch_info.py
"""gather_fetch_info

Revision ID: <KEY>
Revises: <PASSWORD>
Create Date: 2018-09-12 15:32:56.683032

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '<KEY>'
down_revision = '<PASSWORD>'
branch_labels = None
depends_on = None


def upgrade():
    op.add_column("collection",
                  sa.Column('gather_start_at', sa.DateTime(timezone=False), nullable=True)
                  )
    op.add_column("collection",
                  sa.Column('gather_end_at', sa.DateTime(timezone=False), nullable=True)
                  )
    op.add_column("collection",
                  sa.Column('fetch_start_at', sa.DateTime(timezone=False), nullable=True)
                  )
    op.add_column("collection",
                  sa.Column('fetch_end_at', sa.DateTime(timezone=False), nullable=True)
                  )


def downgrade():
    op.drop_column("collection", 'gather_start_at')
    op.drop_column("collection", 'gather_end_at')
    op.drop_column("collection", 'fetch_start_at')
    op.drop_column("collection", 'fetch_end_at')

<filename>ocdskingfisher/maindatabase/migrations/versions/c9b3a2f75f20_gather_fetch_info.py
"""gather_fetch_info

Revision ID: <KEY>
Revises: <PASSWORD>
Create Date: 2018-09-12 15:32:56.683032

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '<KEY>'
down_revision = '<PASSWORD>'
branch_labels = None
depends_on = None


def upgrade():
    op.add_column("collection",
                  sa.Column('gather_start_at', sa.DateTime(timezone=False), nullable=True)
                  )
    op.add_column("collection",
                  sa.Column('gather_end_at', sa.DateTime(timezone=False), nullable=True)
                  )
    op.add_column("collection",
                  sa.Column('fetch_start_at', sa.DateTime(timezone=False), nullable=True)
                  )
    op.add_column("collection",
                  sa.Column('fetch_end_at', sa.DateTime(timezone=False), nullable=True)
                  )


def downgrade():
    op.drop_column("collection", 'gather_start_at')
    op.drop_column("collection", 'gather_end_at')
    op.drop_column("collection", 'fetch_start_at')
    op.drop_column("collection", 'fetch_end_at')

gather_fetch_info  Revision ID: <KEY> Revises: <PASSWORD> Create Date: 2018-09-12 15:32:56.683032 # revision identifiers, used by Alembic.