Watch
1
0
Fork
You've already forked arc
0
forked from hesabix/arc
arc/hesabixAPI/migrations/versions/20260706_000001_support_read_csat.py

32 lines
1.2 KiB
Python

"""support ticket read tracking and CSAT
Revision ID: 20260706_000001_support_read_csat
Revises: 20260705_000002_support_phase3
Create Date: 2026-07-06
"""
from __future__ import annotations
import sqlalchemy as sa
from alembic import op
revision = "20260706_000001_support_read_csat"
down_revision = "20260705_000002_support_phase3"
branch_labels = None
depends_on = None
def upgrade() -> None:
op.add_column("support_tickets", sa.Column("user_last_read_at", sa.DateTime(), nullable=True))
op.add_column("support_tickets", sa.Column("operator_last_read_at", sa.DateTime(), nullable=True))
op.add_column("support_tickets", sa.Column("csat_rating", sa.SmallInteger(), nullable=True))
op.add_column("support_tickets", sa.Column("csat_comment", sa.Text(), nullable=True))
op.add_column("support_tickets", sa.Column("csat_submitted_at", sa.DateTime(), nullable=True))
def downgrade() -> None:
op.drop_column("support_tickets", "csat_submitted_at")
op.drop_column("support_tickets", "csat_comment")
op.drop_column("support_tickets", "csat_rating")
op.drop_column("support_tickets", "operator_last_read_at")
op.drop_column("support_tickets", "user_last_read_at")