"""create_prs_info_table

Revision ID: 4aae9b1ffcbe
Revises: eeb45cac0d8b
Create Date: 2021-02-15 10:54:51.222782

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.

revision = '4aae9b1ffcbe'
down_revision = 'eeb45cac0d8b'
branch_labels = None
depends_on = None


def upgrade():
    op.create_table(
        "PRSImportInfo",
        sa.Column('id', sa.Integer(), primary_key=True),
        sa.Column('imported_date',
            sa.Date(),
            server_default=sa.func.current_date(),
            nullable=False,
        ),
        sa.PrimaryKeyConstraint('id', name='pk_PRSImportInfo')
    )
    op.execute("""
        INSERT INTO "PRSImportInfo" (imported_date)
        VALUES (TO_DATE('2020/01/01', 'YYYY/MM/DD'))
    """)

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