Index: branches/5.2.x/core/install/install_schema.sql =================================================================== diff -u -N -r14474 -r14572 --- branches/5.2.x/core/install/install_schema.sql (.../install_schema.sql) (revision 14474) +++ branches/5.2.x/core/install/install_schema.sql (.../install_schema.sql) (revision 14572) @@ -1,8 +1,7 @@ CREATE TABLE PermissionConfig ( PermissionConfigId int(11) NOT NULL auto_increment, PermissionName varchar(30) NOT NULL default '', - Description varchar(255) NOT NULL default '', - ErrorMessage varchar(255) NOT NULL default '', + Description varchar(255) NOT NULL default '', ModuleId varchar(20) NOT NULL default '0', PRIMARY KEY (PermissionConfigId), KEY PermissionName (PermissionName) @@ -82,13 +81,6 @@ KEY MailingId (MailingId) ); -CREATE TABLE EmailSubscribers ( - EmailMessageId int(11) NOT NULL default '0', - PortalUserId int(11) NOT NULL default '0', - KEY EmailMessageId (EmailMessageId), - KEY PortalUserId (PortalUserId) -); - CREATE TABLE Events ( EventId int(11) NOT NULL AUTO_INCREMENT, `Event` varchar(40) NOT NULL DEFAULT '', @@ -530,18 +522,6 @@ KEY ACL (ACL) ); -CREATE TABLE Stylesheets ( - StylesheetId int(11) NOT NULL AUTO_INCREMENT, - `Name` varchar(255) NOT NULL DEFAULT '', - Description varchar(255) NOT NULL DEFAULT '', - AdvancedCSS text, - LastCompiled int(10) unsigned DEFAULT NULL, - Enabled int(11) NOT NULL DEFAULT '0', - PRIMARY KEY (StylesheetId), - KEY Enabled (Enabled), - KEY LastCompiled (LastCompiled) -); - CREATE TABLE PopupSizes ( PopupId int(10) unsigned NOT NULL auto_increment, TemplateName varchar(255) NOT NULL default '', @@ -902,11 +882,6 @@ KEY SearchType (SearchType) ); -CREATE TABLE IgnoreKeywords ( - keyword varchar(20) NOT NULL default '', - PRIMARY KEY (keyword) -); - CREATE TABLE SpamControl ( ItemResourceId int(11) NOT NULL default '0', IPaddress varchar(20) NOT NULL default '', @@ -932,39 +907,6 @@ KEY Priority (Priority) ); -CREATE TABLE SysCache ( - SysCacheId int(11) NOT NULL auto_increment, - Name varchar(255) NOT NULL default '', - Value mediumtext, - Expire INT UNSIGNED NULL DEFAULT NULL, - Module varchar(20) default NULL, - Context varchar(255) default NULL, - GroupList varchar(255) NOT NULL default '', - PRIMARY KEY (SysCacheId), - KEY Name (Name) -); - -CREATE TABLE TagLibrary ( - TagId int(11) NOT NULL auto_increment, - name varchar(255) NOT NULL default '', - description text, - example text, - scope varchar(20) NOT NULL default 'global', - PRIMARY KEY (TagId) -); - -CREATE TABLE TagAttributes ( - AttrId int(11) NOT NULL auto_increment, - TagId int(11) NOT NULL default '0', - Name varchar(255) NOT NULL default '', - AttrType varchar(20) default NULL, - DefValue varchar(255) default NULL, - Description TEXT, - Required int(11) NOT NULL default '0', - PRIMARY KEY (AttrId), - KEY TagId (TagId) -); - CREATE TABLE ImportScripts ( ImportId int(11) NOT NULL AUTO_INCREMENT, `Name` varchar(255) NOT NULL DEFAULT '', @@ -979,22 +921,6 @@ KEY `Status` (`Status`) ); -CREATE TABLE StylesheetSelectors ( - SelectorId int(11) NOT NULL AUTO_INCREMENT, - StylesheetId int(11) NOT NULL DEFAULT '0', - `Name` varchar(255) NOT NULL DEFAULT '', - SelectorName varchar(255) NOT NULL DEFAULT '', - SelectorData text, - Description text, - `Type` tinyint(4) NOT NULL DEFAULT '0', - AdvancedCSS text, - ParentId int(11) NOT NULL DEFAULT '0', - PRIMARY KEY (SelectorId), - KEY StylesheetId (StylesheetId), - KEY ParentId (ParentId), - KEY `Type` (`Type`) -); - CREATE TABLE Visits ( VisitId int(11) NOT NULL AUTO_INCREMENT, VisitDate int(10) unsigned DEFAULT NULL,