Changeset View
Changeset View
Standalone View
Standalone View
branches/5.2.x/core/install/install_schema.sql
Show First 20 Lines • Show All 1276 Lines • ▼ Show 20 Line(s) | |||||
PRIMARY KEY (FormId), | PRIMARY KEY (FormId), | ||||
KEY UseSecurityImage (UseSecurityImage), | KEY UseSecurityImage (UseSecurityImage), | ||||
KEY RequireLogin (RequireLogin), | KEY RequireLogin (RequireLogin), | ||||
KEY EnableEmailCommunication (EnableEmailCommunication), | KEY EnableEmailCommunication (EnableEmailCommunication), | ||||
KEY ProcessUnmatchedEmails (ProcessUnmatchedEmails) | KEY ProcessUnmatchedEmails (ProcessUnmatchedEmails) | ||||
); | ); | ||||
CREATE TABLE Semaphores ( | CREATE TABLE Semaphores ( | ||||
SemaphoreId int(11) NOT NULL AUTO_INCREMENT, | `SemaphoreId` int(11) NOT NULL AUTO_INCREMENT, | ||||
SessionKey int(10) unsigned NOT NULL DEFAULT '0', | `SessionKey` int(10) unsigned NOT NULL DEFAULT '0', | ||||
`Timestamp` int(10) unsigned NOT NULL DEFAULT '0', | `Timestamp` int(10) unsigned NOT NULL DEFAULT '0', | ||||
MainPrefix varchar(255) NOT NULL DEFAULT '', | `MainPrefix` varchar(255) NOT NULL DEFAULT '', | ||||
MainIDs text, | `MainIDs` text, | ||||
PRIMARY KEY (SemaphoreId), | `UserId` int(11) DEFAULT NULL, | ||||
KEY SessionKey (SessionKey), | `IpAddress` varchar(15) NOT NULL DEFAULT '', | ||||
`Hostname` varchar(255) NOT NULL DEFAULT '', | |||||
`RequestURI` varchar(255) NOT NULL DEFAULT '', | |||||
`Backtrace` longtext, | |||||
PRIMARY KEY (`SemaphoreId`), | |||||
KEY `SessionKey` (`SessionKey`), | |||||
KEY `Timestamp` (`Timestamp`), | KEY `Timestamp` (`Timestamp`), | ||||
KEY MainPrefix (MainPrefix) | KEY `MainPrefix` (`MainPrefix`) | ||||
); | ); | ||||
CREATE TABLE CachedUrls ( | CREATE TABLE CachedUrls ( | ||||
UrlId int(11) NOT NULL AUTO_INCREMENT, | UrlId int(11) NOT NULL AUTO_INCREMENT, | ||||
Url varchar(255) NOT NULL DEFAULT '', | Url varchar(255) NOT NULL DEFAULT '', | ||||
DomainId int(11) NOT NULL DEFAULT '0', | DomainId int(11) NOT NULL DEFAULT '0', | ||||
`Hash` bigint(11) NOT NULL DEFAULT '0', | `Hash` bigint(11) NOT NULL DEFAULT '0', | ||||
Prefixes varchar(255) NOT NULL DEFAULT '', | Prefixes varchar(255) NOT NULL DEFAULT '', | ||||
▲ Show 20 Lines • Show All 135 Lines • Show Last 20 Lines |