blob: 55d4a66927b6800f814d7dc2e005428ba9823922 (
plain)
1
2
3
4
5
6
7
8
9
10
|
CREATE TABLE sessions_tmp (
sessionid varchar(32) DEFAULT '' NOT NULL,
userid bigint unsigned DEFAULT '0' NOT NULL,
lastaccess integer DEFAULT '0' NOT NULL,
PRIMARY KEY (sessionid)
) ENGINE=InnoDB;
insert into sessions_tmp select * from sessions;
drop table sessions;
alter table sessions_tmp rename sessions;
|
