Changeset View
Changeset View
Standalone View
Standalone View
branches/5.3.x/core/install/install_schema.sql
| Show First 20 Lines • Show All 1354 Lines • ▼ Show 20 Line(s) | |||||
| PrimaryLanguageId int(11) NOT NULL DEFAULT '0', | PrimaryLanguageId int(11) NOT NULL DEFAULT '0', | ||||
| Languages varchar(255) NOT NULL DEFAULT '', | Languages varchar(255) NOT NULL DEFAULT '', | ||||
| PrimaryThemeId int(11) NOT NULL DEFAULT '0', | PrimaryThemeId int(11) NOT NULL DEFAULT '0', | ||||
| Themes varchar(255) NOT NULL DEFAULT '', | Themes varchar(255) NOT NULL DEFAULT '', | ||||
| DomainIPRange text, | DomainIPRange text, | ||||
| ExternalUrl varchar(255) NOT NULL DEFAULT '', | ExternalUrl varchar(255) NOT NULL DEFAULT '', | ||||
| RedirectOnIPMatch tinyint(4) NOT NULL DEFAULT '0', | RedirectOnIPMatch tinyint(4) NOT NULL DEFAULT '0', | ||||
| Priority int(11) NOT NULL DEFAULT '0', | Priority int(11) NOT NULL DEFAULT '0', | ||||
| `Status` tinyint(4) NOT NULL DEFAULT '1', | |||||
| PRIMARY KEY (DomainId), | PRIMARY KEY (DomainId), | ||||
| KEY DomainName (DomainName), | KEY DomainName (DomainName), | ||||
| KEY DomainNameUsesRegExp (DomainNameUsesRegExp), | KEY DomainNameUsesRegExp (DomainNameUsesRegExp), | ||||
| KEY SSLDomainName (SSLDomainName), | KEY SSLDomainName (SSLDomainName), | ||||
| KEY SSLDomainNameUsesRegExp (SSLDomainNameUsesRegExp), | KEY SSLDomainNameUsesRegExp (SSLDomainNameUsesRegExp), | ||||
| KEY AdminEmail (AdminEmail), | KEY AdminEmail (AdminEmail), | ||||
| KEY Country (Country), | KEY Country (Country), | ||||
| KEY PrimaryLanguageId (PrimaryLanguageId), | KEY PrimaryLanguageId (PrimaryLanguageId), | ||||
| KEY Languages (Languages), | KEY Languages (Languages), | ||||
| KEY PrimaryThemeId (PrimaryThemeId), | KEY PrimaryThemeId (PrimaryThemeId), | ||||
| KEY Themes (Themes), | KEY Themes (Themes), | ||||
| KEY ExternalUrl (ExternalUrl), | KEY ExternalUrl (ExternalUrl), | ||||
| KEY RedirectOnIPMatch (RedirectOnIPMatch), | KEY RedirectOnIPMatch (RedirectOnIPMatch), | ||||
| KEY Priority (Priority) | KEY Priority (Priority), | ||||
| KEY `Status` (`Status`) | |||||
| ); | ); | ||||
| CREATE TABLE CurlLog ( | CREATE TABLE CurlLog ( | ||||
| LogId int(11) NOT NULL AUTO_INCREMENT, | LogId int(11) NOT NULL AUTO_INCREMENT, | ||||
| Message varchar(255) NOT NULL DEFAULT '', | Message varchar(255) NOT NULL DEFAULT '', | ||||
| PageUrl varchar(255) NOT NULL DEFAULT '', | PageUrl varchar(255) NOT NULL DEFAULT '', | ||||
| RequestUrl varchar(255) NOT NULL DEFAULT '', | RequestUrl varchar(255) NOT NULL DEFAULT '', | ||||
| PortalUserId int(11) NOT NULL, | PortalUserId int(11) NOT NULL, | ||||
| ▲ Show 20 Lines • Show All 84 Lines • Show Last 20 Lines | |||||