MySql.Web/src/Properties/schema5.sql (21 lines of code) (raw):
CREATE TABLE my_aspnet_sessions
(
SessionId varchar(191) NOT NULL,
ApplicationId int NOT NULL,
Created datetime NOT NULL,
Expires datetime NOT NULL,
LockDate datetime NOT NULL,
LockId int NOT NULL,
Timeout int NOT NULL,
Locked tinyint(1) NOT NULL,
SessionItems BLOB,
Flags int NOT NULL,
primary key (SessionId,ApplicationId)
) DEFAULT CHARSET=latin1;
/*
Cleaning up timed out sessions.
In 5.1 events provide a support for periodic jobs.
In older version we need a do-it-yourself event.
*/
CREATE TABLE my_aspnet_sessioncleanup
(
LastRun datetime NOT NULL,
IntervalMinutes int NOT NULL
);
INSERT INTO my_aspnet_sessioncleanup(LastRun,IntervalMinutes) values(NOW(), 10);
UPDATE my_aspnet_schemaversion SET version=5;