12 lines
383 B
PL/PgSQL
12 lines
383 B
PL/PgSQL
begin;
|
|
|
|
alter table user add column `free_lot_ticket` int(11) NOT NULL DEFAULT '0' COMMENT '免费抽奖券';xes
|
|
alter table user add column `free_dou_lot_ticket` int(11) NOT NULL DEFAULT '0' COMMENT '免费十倍抽奖券';
|
|
UPDATE user set sign_sum=7 WHERE sign_sum >= 7;
|
|
UPDATE actitity set free_times=0, video_times=0;
|
|
|
|
|
|
insert into version (version) values(20200426);
|
|
|
|
commit;
|