"""add_marketplace_and_bot_manifests

Revision ID: 879f1a7fc404
Revises: 3716c5b0ab2a
Create Date: 2026-11-18 09:39:41.688597

"""
from typing import Sequence, Union
from alembic import op
import sqlalchemy as sa
from sqlalchemy.dialects import postgresql

# revision identifiers, used by Alembic.
revision: str = '879f1a7fc404'
down_revision: Union[str, None] = '3716c5b0ab2a'
branch_labels: Union[str, Sequence[str], None] = None
depends_on: Union[str, Sequence[str], None] = None


def upgrade() -> None:
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_table('marketplace_modules',
    sa.Column('id', sa.String(length=64), nullable=False),
    sa.Column('name', sa.String(length=100), nullable=False),
    sa.Column('description', sa.String(length=500), nullable=False),
    sa.Column('category', sa.String(length=50), nullable=False),
    sa.Column('version', sa.String(length=20), nullable=False),
    sa.Column('icon', sa.String(length=100), nullable=False),
    sa.Column('config_schema', postgresql.JSONB(astext_type=sa.Text()), nullable=False),
    sa.Column('is_official', sa.Boolean(), nullable=False),
    sa.Column('is_active', sa.Boolean(), nullable=False),
    sa.Column('created_at', sa.DateTime(timezone=True), nullable=False),
    sa.Column('updated_at', sa.DateTime(timezone=True), nullable=False),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('marketplace_templates',
    sa.Column('id', sa.String(length=64), nullable=False),
    sa.Column('name', sa.String(length=150), nullable=False),
    sa.Column('headline', sa.String(length=255), nullable=False),
    sa.Column('description', sa.Text(), nullable=False),
    sa.Column('category', sa.String(length=50), nullable=False),
    sa.Column('icon', sa.String(length=100), nullable=False),
    sa.Column('version', sa.String(length=20), nullable=False),
    sa.Column('author', sa.String(length=100), nullable=False),
    sa.Column('is_official', sa.Boolean(), nullable=False),
    sa.Column('is_featured', sa.Boolean(), nullable=False),
    sa.Column('rating', sa.Float(), nullable=False),
    sa.Column('install_count', sa.Integer(), nullable=False),
    sa.Column('supported_channels', postgresql.JSONB(astext_type=sa.Text()), nullable=False),
    sa.Column('required_permissions', postgresql.JSONB(astext_type=sa.Text()), nullable=False),
    sa.Column('config_schema', postgresql.JSONB(astext_type=sa.Text()), nullable=False),
    sa.Column('default_config', postgresql.JSONB(astext_type=sa.Text()), nullable=False),
    sa.Column('system_templates', postgresql.JSONB(astext_type=sa.Text()), nullable=False),
    sa.Column('mcp_tools', postgresql.JSONB(astext_type=sa.Text()), nullable=False),
    sa.Column('modules', postgresql.JSONB(astext_type=sa.Text()), nullable=False),
    sa.Column('manifest', postgresql.JSONB(astext_type=sa.Text()), nullable=False),
    sa.Column('tags', postgresql.JSONB(astext_type=sa.Text()), nullable=False),
    sa.Column('is_active', sa.Boolean(), nullable=False),
    sa.Column('created_at', sa.DateTime(timezone=True), nullable=False),
    sa.Column('updated_at', sa.DateTime(timezone=True), nullable=False),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_marketplace_templates_category'), 'marketplace_templates', ['category'], unique=False)
    op.create_table('installed_bot_instances',
    sa.Column('id', sa.UUID(), nullable=False),
    sa.Column('template_id', sa.String(length=64), nullable=False),
    sa.Column('bot_id', sa.UUID(), nullable=True),
    sa.Column('name', sa.String(length=255), nullable=False),
    sa.Column('version_installed', sa.String(length=20), nullable=False),
    sa.Column('status', sa.String(length=50), nullable=False),
    sa.Column('custom_config', postgresql.JSONB(astext_type=sa.Text()), nullable=False),
    sa.Column('installed_modules', postgresql.JSONB(astext_type=sa.Text()), nullable=False),
    sa.Column('enabled_mcp_tools', postgresql.JSONB(astext_type=sa.Text()), nullable=False),
    sa.Column('last_deployed_at', sa.DateTime(timezone=True), nullable=True),
    sa.Column('health_status', sa.String(length=50), nullable=False),
    sa.Column('metrics', postgresql.JSONB(astext_type=sa.Text()), nullable=False),
    sa.Column('tenant_id', sa.UUID(), nullable=False),
    sa.Column('created_at', sa.DateTime(timezone=True), nullable=False),
    sa.Column('updated_at', sa.DateTime(timezone=True), nullable=False),
    sa.ForeignKeyConstraint(['bot_id'], ['bots.id'], ondelete='SET NULL'),
    sa.ForeignKeyConstraint(['template_id'], ['marketplace_templates.id'], ondelete='CASCADE'),
    sa.ForeignKeyConstraint(['tenant_id'], ['tenants.id'], ondelete='CASCADE'),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_installed_bot_instances_bot_id'), 'installed_bot_instances', ['bot_id'], unique=False)
    op.create_index(op.f('ix_installed_bot_instances_template_id'), 'installed_bot_instances', ['template_id'], unique=False)
    op.create_index(op.f('ix_installed_bot_instances_tenant_id'), 'installed_bot_instances', ['tenant_id'], unique=False)
    op.create_index('ix_installed_bot_tenant_template', 'installed_bot_instances', ['tenant_id', 'template_id'], unique=False)
    # ### end Alembic commands ###


def downgrade() -> None:
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_index('ix_installed_bot_tenant_template', table_name='installed_bot_instances')
    op.drop_index(op.f('ix_installed_bot_instances_tenant_id'), table_name='installed_bot_instances')
    op.drop_index(op.f('ix_installed_bot_instances_template_id'), table_name='installed_bot_instances')
    op.drop_index(op.f('ix_installed_bot_instances_bot_id'), table_name='installed_bot_instances')
    op.drop_table('installed_bot_instances')
    op.drop_index(op.f('ix_marketplace_templates_category'), table_name='marketplace_templates')
    op.drop_table('marketplace_templates')
    op.drop_table('marketplace_modules')
    # ### end Alembic commands ###
