14 lines
849 B
PL/PgSQL
14 lines
849 B
PL/PgSQL
begin;
|
|
|
|
alter table user add column `daily_ad_times` int(11) NOT NULL DEFAULT '0' COMMENT '每日活动广告次数';
|
|
alter table user add column `mid_aut_adtimes` int(11) NOT NULL DEFAULT '0' COMMENT '中秋活动广告次数';
|
|
alter table user add column `mid_aut_status` int(11) NOT NULL DEFAULT '0' COMMENT '中秋活动奖励状态';
|
|
alter table user add column `daily_draw_status` int(11) NOT NULL DEFAULT '0' COMMENT '每日抽奖活动状态';
|
|
alter table user add column `daily_box_times` int(11) NOT NULL DEFAULT '0' COMMENT '每日宝箱活动次数';
|
|
alter table user add column `daily_box_status` int(11) NOT NULL DEFAULT '0' COMMENT '每日宝箱活动状态';
|
|
alter table user add column `daily_box2_status` int(11) NOT NULL DEFAULT '0' COMMENT '每日宝箱活动2状态';
|
|
|
|
insert into version (version) values(2020092401);
|
|
|
|
commit;
|