-- ============================================================
-- V7: 补充所有表 id 列和遗漏列的字段注释
-- 执行时间：2026-04-08
-- ============================================================

ALTER TABLE t_biz_contest
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_biz_contest_attachment
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_biz_contest_judge
    MODIFY COLUMN `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_biz_contest_notice
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_biz_contest_registration
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_biz_contest_registration_teacher
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_biz_contest_review_rule
    MODIFY COLUMN `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_biz_contest_team
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_biz_contest_team_member
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_biz_contest_work
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_biz_contest_work_attachment
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_biz_contest_work_judge_assignment
    MODIFY COLUMN `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_biz_contest_work_score
    MODIFY COLUMN `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_biz_homework
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_biz_homework_review_rule
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_biz_homework_score
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_biz_homework_submission
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_biz_preset_comment
    MODIFY COLUMN `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_leai_webhook_event
    MODIFY COLUMN `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
    MODIFY COLUMN `create_time` datetime NOT NULL COMMENT '创建时间';

ALTER TABLE t_sys_config
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_sys_dict
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_sys_dict_item
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_sys_log
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_sys_menu
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_sys_permission
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_sys_role
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_sys_role_permission
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_sys_tenant
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_sys_tenant_menu
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_sys_user
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_sys_user_role
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_ugc_review_log
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_ugc_tag
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_ugc_work
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_ugc_work_comment
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_ugc_work_favorite
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_ugc_work_like
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_ugc_work_page
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_ugc_work_report
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_ugc_work_tag
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_user_child
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';

ALTER TABLE t_user_parent_child
    MODIFY COLUMN `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID';
