sports_admin/sql.sql

/*体育后台 sql 变更记录*/



/**
Tank.peng 
2019/10/23
各球类赛事表 新增字段 handle_mark 处理备注(赛事取消/作废描述)
*/

ALTER TABLE st_zq_competition ADD COLUMN handle_mark varchar(100) COLLATE "pg_catalog"."default";
COMMENT ON COLUMN "st_zq_competition"."handle_mark" IS '处理备注(赛事取消/作废描述)';

ALTER TABLE st_lq_competition ADD COLUMN handle_mark varchar(100) COLLATE "pg_catalog"."default";
COMMENT ON COLUMN "st_lq_competition"."handle_mark" IS '处理备注(赛事取消/作废描述)';

ALTER TABLE st_wq_competition ADD COLUMN handle_mark varchar(100) COLLATE "pg_catalog"."default";
COMMENT ON COLUMN "st_wq_competition"."handle_mark" IS '处理备注(赛事取消/作废描述)';

ALTER TABLE st_bq_competition ADD COLUMN handle_mark varchar(100) COLLATE "pg_catalog"."default";
COMMENT ON COLUMN "st_bq_competition"."handle_mark" IS '处理备注(赛事取消/作废描述)';