Index: branches/RC/admin/install/inportal_schema.sql =================================================================== diff -u -r8929 -r9376 --- branches/RC/admin/install/inportal_schema.sql (.../inportal_schema.sql) (revision 8929) +++ branches/RC/admin/install/inportal_schema.sql (.../inportal_schema.sql) (revision 9376) @@ -291,3 +291,18 @@ ) # -------------------------------------------------------- + +CREATE TABLE RelatedSearches ( + RelatedSearchId int(11) NOT NULL auto_increment, + ResourceId int(11) NOT NULL default '0', + Keyword varchar(255) NOT NULL default '', + ItemType tinyint(4) NOT NULL default '0', + Enabled tinyint(4) NOT NULL default '1', + Priority int(11) NOT NULL default '0', + PRIMARY KEY (RelatedSearchId), + KEY Enabled (Enabled), + KEY ItemType (ItemType), + KEY ResourceId (ResourceId) +) + +# -------------------------------------------------------- Index: branches/RC/admin/install/upgrades/inportal_upgrade_v4.2.1.sql =================================================================== diff -u -r9363 -r9376 --- branches/RC/admin/install/upgrades/inportal_upgrade_v4.2.1.sql (.../inportal_upgrade_v4.2.1.sql) (revision 9363) +++ branches/RC/admin/install/upgrades/inportal_upgrade_v4.2.1.sql (.../inportal_upgrade_v4.2.1.sql) (revision 9376) @@ -5,6 +5,8 @@ ALTER TABLE ConfigurationValues CHANGE VariableValue VariableValue TEXT NULL DEFAULT NULL; ALTER TABLE Language ADD AdminInterfaceLang TINYINT UNSIGNED NOT NULL AFTER PrimaryLang, ADD Priority INT NOT NULL AFTER AdminInterfaceLang; + +CREATE TABLE RelatedSearches (RelatedSearchId int(11) NOT NULL auto_increment, ResourceId int(11) NOT NULL default '0', Keyword varchar(255) NOT NULL default '', ItemType tinyint(4) NOT NULL default '0', Enabled tinyint(4) NOT NULL default '1', Priority int(11) NOT NULL default '0', PRIMARY KEY (RelatedSearchId), KEY Enabled (Enabled), KEY ItemType (ItemType), KEY ResourceId (ResourceId)); UPDATE Modules SET Version = '4.2.1' WHERE Name = 'Core'; UPDATE Modules SET Version = '4.2.1' WHERE Name = 'In-Portal'; \ No newline at end of file