chongqing-server/sql/ledger_alter_columns.sql

-- =============================================
-- 扩展台账表中可能存放长文本的列
-- 在 ledger_data_import.sql 执行前先运行此脚本
-- =============================================

ALTER TABLE `ledger_supervision_problem`
    MODIFY `problem_desc`     TEXT          COMMENT '问题描述',
    MODIFY `result_handling`  TEXT          COMMENT '处理结果',
    MODIFY `remark`           TEXT          COMMENT '备注',
    MODIFY `evidence_file`    TEXT          COMMENT '佐证附件URL';

ALTER TABLE `ledger_patrol_inspection`
    MODIFY `problem_desc`     TEXT          COMMENT '问题描述',
    MODIFY `result_handling`  TEXT          COMMENT '处理结果',
    MODIFY `evidence_file`    TEXT          COMMENT '佐证附件URL';

ALTER TABLE `ledger_realtime_interception`
    MODIFY `handling_method`  TEXT          COMMENT '处置方式',
    MODIFY `result_handling`  TEXT          COMMENT '处理结果',
    MODIFY `evidence_file`    TEXT          COMMENT '佐证附件URL';

ALTER TABLE `ledger_service_patrol`
    MODIFY `problem_desc`     TEXT          COMMENT '问题描述',
    MODIFY `result_handling`  TEXT          COMMENT '处理结果',
    MODIFY `evidence_file`    TEXT          COMMENT '佐证附件URL';

ALTER TABLE `ledger_complaint`
    MODIFY `complaint_desc`   TEXT          COMMENT '投诉内容',
    MODIFY `result_handling`  TEXT          COMMENT '处理结果',
    MODIFY `evidence_file`    TEXT          COMMENT '佐证附件URL';

ALTER TABLE `ledger_security_test`
    MODIFY `problem_desc`     TEXT          COMMENT '问题描述',
    MODIFY `result_handling`  TEXT          COMMENT '处理结果',
    MODIFY `evidence_file`    TEXT          COMMENT '佐证附件URL';

ALTER TABLE `ledger_unsafe_event`
    MODIFY `event_desc`       TEXT          COMMENT '事件描述',
    MODIFY `result_handling`  TEXT          COMMENT '处理结果',
    MODIFY `evidence_file`    TEXT          COMMENT '佐证附件URL';

ALTER TABLE `ledger_seizure_stats`
    MODIFY `handling_method`  TEXT          COMMENT '处置方式',
    MODIFY `evidence_file`    TEXT          COMMENT '佐证附件URL';

ALTER TABLE `ledger_terminal_bonus`
    MODIFY `evidence_file`    TEXT          COMMENT '佐证附件URL';

ALTER TABLE `ledger_reward_penalty`
    MODIFY `event_desc`       TEXT          COMMENT '事件描述',
    MODIFY `evidence_file`    TEXT          COMMENT '佐证附件URL';

ALTER TABLE `ledger_banner_letter`
    MODIFY `content_desc`     TEXT          COMMENT '内容描述',
    MODIFY `evidence_file`    TEXT          COMMENT '佐证附件URL';