"""create manager clone tables

Revision ID: 6ff518c9af9e
Revises: 
Create Date: 2026-10-15 16:37:39.007662

"""
from typing import Sequence, Union

from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision: str = '6ff518c9af9e'
down_revision: Union[str, Sequence[str], None] = None
branch_labels: Union[str, Sequence[str], None] = None
depends_on: Union[str, Sequence[str], None] = None


def upgrade() -> None:
    """Upgrade schema."""
    # Create manager_clones table
    op.create_table(
        "manager_clones",
        sa.Column("id", sa.Integer, primary_key=True, index=True),
        sa.Column("clone_id", sa.String, unique=True, nullable=False),
        sa.Column("company_id", sa.String, nullable=False, index=True),
        sa.Column("profile", sa.JSON, nullable=False),
        sa.Column("created_at", sa.DateTime, server_default=sa.func.utcnow()),
    )
    # Create manager_clone_versions table
    op.create_table(
        "manager_clone_versions",
        sa.Column("id", sa.Integer, primary_key=True, index=True),
        sa.Column("version_id", sa.String, unique=True, nullable=False),
        sa.Column("clone_id", sa.String, sa.ForeignKey("manager_clones.clone_id"), nullable=False),
        sa.Column("created_by", sa.String, nullable=False),
        sa.Column("status", sa.Enum("draft", "published", "archived", name="clone_status"), nullable=False, server_default="draft"),
        sa.Column("created_at", sa.DateTime, server_default=sa.func.utcnow()),
        sa.Column("published_at", sa.DateTime, nullable=True),
        sa.Column("configuration_snapshot", sa.JSON, nullable=False),
    )
    # Create manager_knowledge table
    op.create_table(
        "manager_knowledge",
        sa.Column("id", sa.Integer, primary_key=True, index=True),
        sa.Column("clone_id", sa.String, sa.ForeignKey("manager_clones.clone_id"), nullable=False),
        sa.Column("file_name", sa.String, nullable=False),
        sa.Column("file_path", sa.String, nullable=False),
        sa.Column("extracted_text", sa.JSON, nullable=True),
        sa.Column("uploaded_at", sa.DateTime, server_default=sa.func.utcnow()),
    )
    # Create manager_blueprints table
    op.create_table(
        "manager_blueprints",
        sa.Column("id", sa.Integer, primary_key=True, index=True),
        sa.Column("clone_id", sa.String, sa.ForeignKey("manager_clones.clone_id"), nullable=False),
        sa.Column("version_id", sa.String, sa.ForeignKey("manager_clone_versions.version_id"), nullable=False),
        sa.Column("blueprint", sa.JSON, nullable=False),
        sa.Column("created_at", sa.DateTime, server_default=sa.func.utcnow()),
    )


def downgrade() -> None:
    """Downgrade schema."""
    # ### commands auto generated by Alembic - please adjust! ###
    pass
    # ### end Alembic commands ###
