Files
mono/mcs/class/System.Web/SQLiteProviders_DatabaseSchema.sql
Marek Habersack 58eceab2ec 2007-12-08 Marek Habersack <[email protected]>
* TranslationResources.resx: added - string resources for the
	Sqlite providers.
2007-12-08  Marek Habersack  <[email protected]>

	* SQLiteProviders_DatabaseSchema.sql: added
	* Makefile: added support for compiling .resx resources.
	Added SQLiteProviders_DatabaseSchema.sql to EXTRA_DISTFILES.
	Added new resource files to EXTRA_DISTFILES
2007-12-08  Marek Habersack  <[email protected]>

	* HttpRuntime.cs: initialize the Settings Mapping Manager once per
	application, just after initalizing the WebConfigurationManager
2007-12-08  Marek Habersack  <[email protected]>

	* SqliteProfileProvider.cs: added - a Profile Provider for
        Sqlite, based on PostgreSQL Profile Provider code from Daniel
        Nauck <[email protected]>
2007-12-08  Marek Habersack  <[email protected]>

	* TranslationProperties.Designer.cs: added - contains strongly
	typed properties referring to string resources used by the Sqlite
	providers.
2007-12-08  Marek Habersack  <[email protected]>

	* WebConfigurationManager.cs: GetSection now runs each section
	through a mapper (if any is defined for the section) before
	returning it to the caller.
2007-12-08  Marek Habersack  <[email protected]>

	* SqliteRoleProvider.cs: added - a Role Provider for
	Sqlite, based on PostgreSQL Role Provider code from Daniel
	Nauck <[email protected]>

	* SqliteMembershipProvider.cs: added - a Membership Provider for
	Sqlite, based on PostgreSQL Membership Provider code from Daniel
	Nauck <[email protected]>
2007-12-08  Marek Habersack  <[email protected]>

	* SerializationHelper.cs: added - serialization helper for the
	Sqlite Profile Provider.

	* RoleManagerSectionMapper.cs: added - section settings mapper for
	the RoleManager section.

	* MembershipSectionMapper.cs: added - section settings mapper for
	the Membership section.

	* ISectionSettingsMapper.cs: added - interface definition for
	section settings mappers.

	* SettingsMappingWhat.cs: added - describes a single 'what' tag
	instance inside the mapper definition in the settings.map file.

	* SettingsMapping.cs: added - represents a single mapper entry in
	the settings.map file.

	* SettingsMappingManager.cs: added - manages settings mapping as
	defined in the settings.map file.


svn path=/trunk/mcs/; revision=90972
2007-12-07 23:26:18 +00:00

82 lines
3.5 KiB
SQL

CREATE TABLE "Users" (
"pId" character(36) NOT NULL,
"Username" character varying(255) NOT NULL,
"ApplicationName" character varying(255) NOT NULL,
"Email" character varying(128) NULL,
"Comment" character varying(128) NULL,
"Password" character varying(255) NOT NULL,
"PasswordQuestion" character varying(255) NULL,
"PasswordAnswer" character varying(255) NULL,
"IsApproved" boolean NULL,
"LastActivityDate" timestamptz NULL,
"LastLoginDate" timestamptz NULL,
"LastPasswordChangedDate" timestamptz NULL,
"CreationDate" timestamptz NULL,
"IsOnLine" boolean NULL,
"IsLockedOut" boolean NULL,
"LastLockedOutDate" timestamptz NULL,
"FailedPasswordAttemptCount" integer NULL,
"FailedPasswordAttemptWindowStart" timestamptz NULL,
"FailedPasswordAnswerAttemptCount" integer NULL,
"FailedPasswordAnswerAttemptWindowStart" timestamptz NULL,
CONSTRAINT users_pkey PRIMARY KEY ("pId"),
CONSTRAINT users_username_application_unique UNIQUE ("Username", "ApplicationName")
);
CREATE INDEX users_email_index ON "Users" ("Email");
CREATE INDEX users_islockedout_index ON "Users" ("IsLockedOut");
CREATE TABLE "Roles" (
"Rolename" character varying(255) NOT NULL,
"ApplicationName" character varying(255) NOT NULL,
CONSTRAINT roles_pkey PRIMARY KEY ("Rolename", "ApplicationName")
);
CREATE TABLE "UsersInRoles" (
"Username" character varying(255) NOT NULL,
"Rolename" character varying(255) NOT NULL,
"ApplicationName" character varying(255) NOT NULL,
CONSTRAINT usersinroles_pkey PRIMARY KEY ("Username", "Rolename", "ApplicationName"),
CONSTRAINT usersinroles_username_fkey FOREIGN KEY ("Username", "ApplicationName") REFERENCES "Users" ("Username", "ApplicationName") ON DELETE CASCADE,
CONSTRAINT usersinroles_rolename_fkey FOREIGN KEY ("Rolename", "ApplicationName") REFERENCES "Roles" ("Rolename", "ApplicationName") ON DELETE CASCADE
);
CREATE TABLE "Profiles" (
"pId" character(36) NOT NULL,
"Username" character varying(255) NOT NULL,
"ApplicationName" character varying(255) NOT NULL,
"IsAnonymous" boolean NULL,
"LastActivityDate" timestamptz NULL,
"LastUpdatedDate" timestamptz NULL,
CONSTRAINT profiles_pkey PRIMARY KEY ("pId"),
CONSTRAINT profiles_username_application_unique UNIQUE ("Username", "ApplicationName"),
CONSTRAINT profiles_username_fkey FOREIGN KEY ("Username", "ApplicationName") REFERENCES "Users" ("Username", "ApplicationName") ON DELETE CASCADE
);
CREATE INDEX profiles_isanonymous_index ON "Profiles" ("IsAnonymous");
CREATE TABLE "ProfileData" (
"pId" character(36) NOT NULL,
"Profile" character(36) NOT NULL,
"Name" character varying(255) NOT NULL,
"ValueString" text NULL,
"ValueBinary" bytea NULL,
CONSTRAINT profiledata_pkey PRIMARY KEY ("pId"),
CONSTRAINT profiledata_profile_name_unique UNIQUE ("Profile", "Name"),
CONSTRAINT profiledata_profile_fkey FOREIGN KEY ("Profile") REFERENCES "Profiles" ("pId") ON DELETE CASCADE
);
CREATE TABLE "Sessions" (
"SessionId" character varying(80) NOT NULL,
"ApplicationName" character varying(255) NOT NULL,
"Created" timestamptz NOT NULL,
"Expires" timestamptz NOT NULL,
"Timeout" integer NOT NULL,
"Locked" boolean NOT NULL,
"LockId" integer NOT NULL,
"LockDate" timestamptz NOT NULL,
"Data" text NULL,
"Flags" integer NOT NULL,
CONSTRAINT sessions_pkey PRIMARY KEY ("SessionId", "ApplicationName")
);