Index: branches/5.1.x/core/install/install_schema.sql =================================================================== diff -u -N -r13545 -r13559 --- branches/5.1.x/core/install/install_schema.sql (.../install_schema.sql) (revision 13545) +++ branches/5.1.x/core/install/install_schema.sql (.../install_schema.sql) (revision 13559) @@ -1184,6 +1184,7 @@ CREATE TABLE CachedUrls ( UrlId int(11) NOT NULL AUTO_INCREMENT, Url varchar(255) NOT NULL DEFAULT '', + DomainId int(11) NOT NULL DEFAULT '0', `Hash` int(11) NOT NULL DEFAULT '0', Prefixes varchar(255) NOT NULL DEFAULT '', ParsedVars text NOT NULL, @@ -1194,5 +1195,38 @@ KEY `Hash` (`Hash`), KEY Prefixes (Prefixes), KEY Cached (Cached), - KEY LifeTime (LifeTime) + KEY LifeTime (LifeTime), + KEY DomainId (DomainId) +); + +CREATE TABLE SiteDomains ( + DomainId int(11) NOT NULL AUTO_INCREMENT, + DomainName varchar(255) NOT NULL DEFAULT '', + DomainNameUsesRegExp tinyint(4) NOT NULL DEFAULT '0', + SSLUrl varchar(255) NOT NULL DEFAULT '', + SSLUrlUsesRegExp tinyint(4) NOT NULL DEFAULT '0', + AdminEmail varchar(255) NOT NULL DEFAULT '', + Country varchar(3) NOT NULL DEFAULT '', + PrimaryLanguageId int(11) NOT NULL DEFAULT '0', + Languages varchar(255) NOT NULL DEFAULT '', + PrimaryThemeId int(11) NOT NULL DEFAULT '0', + Themes varchar(255) NOT NULL DEFAULT '', + DomainIPRange text, + ExternalUrl varchar(255) NOT NULL DEFAULT '', + RedirectOnIPMatch tinyint(4) NOT NULL DEFAULT '0', + Priority int(11) NOT NULL DEFAULT '0', + PRIMARY KEY (DomainId), + KEY DomainName (DomainName), + KEY DomainNameUsesRegExp (DomainNameUsesRegExp), + KEY SSLUrl (SSLUrl), + KEY SSLUrlUsesRegExp (SSLUrlUsesRegExp), + KEY AdminEmail (AdminEmail), + KEY Country (Country), + KEY PrimaryLanguageId (PrimaryLanguageId), + KEY Languages (Languages), + KEY PrimaryThemeId (PrimaryThemeId), + KEY Themes (Themes), + KEY ExternalUrl (ExternalUrl), + KEY RedirectOnIPMatch (RedirectOnIPMatch), + KEY Priority (Priority) ); \ No newline at end of file