9 lines
229 B
PL/PgSQL
9 lines
229 B
PL/PgSQL
begin;
|
|
|
|
alter table accounts add `activetime` int(11) NOT NULL DEFAULT '0' COMMENT '最后交互时间';
|
|
UPDATE accounts set activetime=unix_timestamp(now()) WHERE 1=1;
|
|
|
|
insert into version (version) values(2019102301);
|
|
|
|
commit;
|