mirror of
https://github.com/BepInEx/mono.git
synced 2026-11-16 17:10:20 -10:00
* ASPState.sql: added - schema for the SQL session state server database. 2009-10-19 Marek Habersack <[email protected]> * SessionStateModule.cs: enabled SQL session state provider. * SessionSQLServerHandler.cs: implemented. Uses System.Data.Common for provider-agnostic implementation. Until an issue with Npgsql's 2.0 factory missing is resolved it defaults to using Mono.Data.Sqlite as the provider. Selecting of the data provider is done by putting DbProviderName in the connection string specified in the <system.web/sessionState> configuration section. svn path=/trunk/mcs/; revision=144412
15 lines
462 B
SQL
15 lines
462 B
SQL
CREATE TABLE Sessions
|
|
(
|
|
SessionId Text(80) NOT NULL,
|
|
ApplicationName Text(255) NOT NULL,
|
|
Created DateTime NOT NULL,
|
|
Expires DateTime NOT NULL,
|
|
LockDate DateTime NOT NULL,
|
|
LockId Integer NOT NULL,
|
|
Timeout Integer NOT NULL,
|
|
Locked YesNo NOT NULL,
|
|
SessionItems Memo,
|
|
Flags Integer NOT NULL,
|
|
CONSTRAINT PKSessions PRIMARY KEY (SessionId, ApplicationName)
|
|
);
|