"""Workspace workflow binding + Agent Runtime durable catalog and execution. Revision ID: 0002 Revises: 0001 Frozen schema; independent of future ORM changes. """ from alembic import op import sqlalchemy as sa revision='0002' down_revision='0001' branch_labels=None depends_on=None def upgrade(): op.create_table('ws_runtime_binding',sa.Column('workspace_id',sa.String(80),sa.ForeignKey('ws_matter.id'),primary_key=True),sa.Column('tenant_id',sa.String(80),nullable=False),sa.Column('workflow_id',sa.String(80),nullable=False),sa.Column('workflow_version',sa.Integer(),nullable=False),sa.Column('base_ids',sa.JSON(),nullable=False),sa.Column('version',sa.Integer(),nullable=False)) op.create_index('ix_ws_runtime_binding_tenant_id','ws_runtime_binding',['tenant_id']) op.create_table('ar_definition',sa.Column('tenant',sa.String(80),primary_key=True),sa.Column('kind',sa.String(24),primary_key=True),sa.Column('id',sa.String(80),primary_key=True),sa.Column('revision',sa.Integer(),nullable=False),sa.Column('body',sa.JSON(),nullable=False),sa.Column('updated_at',sa.String(40),nullable=False)) op.create_table('ar_published',sa.Column('tenant',sa.String(80),primary_key=True),sa.Column('workflow_id',sa.String(80),primary_key=True),sa.Column('version',sa.Integer(),primary_key=True),sa.Column('body',sa.JSON(),nullable=False),sa.Column('created_at',sa.String(40),nullable=False)) op.create_table('ar_run',sa.Column('id',sa.String(80),primary_key=True),sa.Column('tenant',sa.String(80),nullable=False),sa.Column('owner',sa.String(80),nullable=False),sa.Column('workspace',sa.String(80),nullable=False),sa.Column('active_scope',sa.String(200),nullable=True),sa.Column('status',sa.String(32),nullable=False),sa.Column('revision',sa.Integer(),nullable=False),sa.Column('body',sa.JSON(),nullable=False),sa.UniqueConstraint('active_scope')) for col in ('tenant','owner','workspace','status'):op.create_index('ix_ar_run_'+col,'ar_run',[col]) op.create_table('ar_event',sa.Column('run_id',sa.String(80),primary_key=True),sa.Column('sequence',sa.Integer(),primary_key=True),sa.Column('body',sa.JSON(),nullable=False)) op.create_table('ar_command',sa.Column('tenant',sa.String(80),primary_key=True),sa.Column('owner',sa.String(80),primary_key=True),sa.Column('scope',sa.String(200),primary_key=True),sa.Column('key',sa.String(128),primary_key=True),sa.Column('fingerprint',sa.String(64),nullable=False),sa.Column('response',sa.JSON(),nullable=False)) op.create_table('ar_audit',sa.Column('id',sa.String(80),primary_key=True),sa.Column('tenant',sa.String(80),nullable=False),sa.Column('actor',sa.String(80),nullable=False),sa.Column('action',sa.String(80),nullable=False),sa.Column('resource',sa.String(80),nullable=False),sa.Column('at',sa.String(40),nullable=False)) op.create_index('ix_ar_audit_tenant','ar_audit',['tenant']) def downgrade(): for table in ('ar_audit','ar_command','ar_event','ar_run','ar_published','ar_definition','ws_runtime_binding'):op.drop_table(table)