12 lines
417 B
MySQL
12 lines
417 B
MySQL
|
-- 为 lottery_draws 表添加奖池字段
|
||
|
|
ALTER TABLE `lottery_draws`
|
||
|
|
ADD COLUMN `prizePool` BIGINT DEFAULT 0 COMMENT '奖池' AFTER `blueBall`;
|
||
|
|
|
||
|
|
-- 为 dlt_draw_record 表添加奖池字段
|
||
|
|
ALTER TABLE `dlt_draw_record`
|
||
|
|
ADD COLUMN `prizePool` BIGINT DEFAULT 0 COMMENT '奖池' AFTER `backBall2`;
|
||
|
|
|
||
|
|
-- 验证字段是否添加成功
|
||
|
|
-- SELECT * FROM lottery_draws LIMIT 1;
|
||
|
|
-- SELECT * FROM dlt_draw_record LIMIT 1;
|