15 lines
579 B
MySQL
15 lines
579 B
MySQL
|
-- 修改奖池字段类型：从 BIGINT 改为 DECIMAL(10,2)
|
||
|
|
-- 单位从"元"改为"亿元"
|
||
|
|
|
||
|
|
-- 修改 lottery_draws 表的奖池字段
|
||
|
|
ALTER TABLE `lottery_draws`
|
||
|
|
MODIFY COLUMN `prizePool` DECIMAL(10,2) DEFAULT 0.00 COMMENT '奖池（单位：亿元）';
|
||
|
|
|
||
|
|
-- 修改 dlt_draw_record 表的奖池字段
|
||
|
|
ALTER TABLE `dlt_draw_record`
|
||
|
|
MODIFY COLUMN `prizePool` DECIMAL(10,2) DEFAULT 0.00 COMMENT '奖池（单位：亿元）';
|
||
|
|
|
||
|
|
-- 验证字段类型是否修改成功
|
||
|
|
-- SHOW COLUMNS FROM lottery_draws LIKE 'prizePool';
|
||
|
|
-- SHOW COLUMNS FROM dlt_draw_record LIKE 'prizePool';
|