"""Add chat_files table

Revision ID: 32e398217827
Revises: 893cd8ed8c4c
Create Date: 2025-06-06 17:00:31.742688

"""
from alembic import op
import sqlalchemy as sa

revision = '32e398217827'
down_revision = '893cd8ed8c4c'
branch_labels = None
depends_on = None


def upgrade():
    op.create_table('chat_files',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('chat_id', sa.Integer(), nullable=False),
    sa.Column('filename', sa.String(length=255), nullable=False),
    sa.Column('file_path', sa.String(length=512), nullable=False),
    sa.Column('file_type', sa.String(length=100), nullable=False),
    sa.Column('file_size', sa.Integer(), nullable=False),
    sa.Column('created_at', sa.DateTime(), nullable=True),
    sa.ForeignKeyConstraint(['chat_id'], ['chats.id'], ondelete='CASCADE'),
    sa.PrimaryKeyConstraint('id')
    )

def downgrade():
    op.drop_table('chat_files')