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 '处理备注(赛事取消/作废描述)';

/**
Tank.peng
2019/11/1
篮球结果表 新增 字段
*/
ALTER TABLE st_lq_result ADD COLUMN s_home_score int2 NOT NULL DEFAULT 0;
COMMENT ON COLUMN "st_lq_result"."s_home_score" IS '下半场-主队进球数';

ALTER TABLE st_lq_result ADD COLUMN s_guest_score int2 NOT NULL DEFAULT 0;
COMMENT ON COLUMN "st_lq_result"."s_guest_score" IS '下半场-客队进球数';

/**
Tank.peng
2019/11/5
新增玩法代码
*/
INSERT INTO "public"."st_odds_code" VALUES (498, 'wq', 'ch_3', '第三盘冠军主队', 183, 0,3001007);
INSERT INTO "public"."st_odds_code" VALUES (499, 'wq', 'cg_3', '第三盘冠军客队', 183, 0,3001008);