"""create photos

Revision ID: 3cb3966dc4c8
Revises: 1d3aeda57681
Create Date: 2021-05-23 21:12:19.195755

"""
import sqlalchemy as sa
from alembic import op

# revision identifiers, used by Alembic.
revision = "3cb3966dc4c8"
down_revision = "1d3aeda57681"
branch_labels = None
depends_on = None


def upgrade():
    op.create_table(
        "fact_photos",
        sa.Column("post_id", sa.String(), nullable=False),
        sa.Column("photo_path", sa.String(), nullable=False),
        sa.Column("username", sa.String()),
    )


def downgrade():
    op.drop_table("fact_photos")
