"""add published_article table

Revision ID: fb8d34fc95ea
Revises: 9eee33ee2f4d
Create Date: 2024-08-21 16:51:26.649792

"""
from alembic import op
import sqlalchemy as sa
from sqlalchemy.dialects import mysql

# revision identifiers, used by Alembic.
revision = "fb8d34fc95ea"
down_revision = "9eee33ee2f4d"
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_table(
        "published_article",
        sa.Column("id", sa.Integer(), autoincrement=False, nullable=False),
        sa.Column("article_id", sa.Integer(), nullable=True),
        sa.Column("date", sa.String(length=128), nullable=True),
        sa.Column("date_gmt", sa.String(length=128), nullable=True),
        sa.Column("modified", sa.String(length=128), nullable=True),
        sa.Column("modified_gmt", sa.String(length=128), nullable=True),
        sa.Column("password", sa.String(length=128), nullable=True),
        sa.Column("slug", sa.String(length=128), nullable=True),
        sa.Column("status", sa.String(length=128), nullable=True),
        sa.Column("type", sa.String(length=128), nullable=True),
        sa.Column("link", sa.String(length=128), nullable=True),
        sa.Column("title", mysql.LONGTEXT(), nullable=True),
        sa.Column("content", mysql.LONGTEXT(), nullable=True),
        sa.Column("featured_media", sa.Integer(), nullable=True),
        sa.Column("template", mysql.LONGTEXT(), nullable=True),
        sa.Column("permalink_template", mysql.LONGTEXT(), nullable=True),
        sa.ForeignKeyConstraint(
            ["article_id"],
            ["auto_written.id"],
        ),
        sa.PrimaryKeyConstraint("id"),
    )
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_table("published_article")
    # ### end Alembic commands ###