Index: trunk/admin/install/upgrades/inportal_upgrade_v1.1.8.sql =================================================================== diff -u -r4446 -r4721 --- trunk/admin/install/upgrades/inportal_upgrade_v1.1.8.sql (.../inportal_upgrade_v1.1.8.sql) (revision 4446) +++ trunk/admin/install/upgrades/inportal_upgrade_v1.1.8.sql (.../inportal_upgrade_v1.1.8.sql) (revision 4721) @@ -9,8 +9,8 @@ UPDATE ConfigurationValues SET Section = 'in-portal:configuration_search' WHERE VariableName LIKE 'SearchRel_%_category' OR VariableName = 'Search_ShowMultiple_category'; -CREATE TABLE PortalUserCustomData (CustomDataId int(11) NOT NULL auto_increment, ResourceId int(10) unsigned NOT NULL default '0', UNIQUE KEY ResourceId (ResourceId), PRIMARY KEY (CustomDataId)); -CREATE TABLE CategoryCustomData (CustomDataId int(11) NOT NULL auto_increment, ResourceId int(10) unsigned NOT NULL default '0', UNIQUE KEY ResourceId (ResourceId), PRIMARY KEY (CustomDataId)); +CREATE TABLE PortalUserCustomData (CustomDataId int(11) NOT NULL auto_increment, ResourceId int(10) unsigned NOT NULL default '0', PRIMARY KEY (CustomDataId)); +CREATE TABLE CategoryCustomData (CustomDataId int(11) NOT NULL auto_increment, ResourceId int(10) unsigned NOT NULL default '0', PRIMARY KEY (CustomDataId)); ALTER TABLE Category ADD CategoryTemplate VARCHAR(255) NOT NULL, ADD ItemTemplate VARCHAR(255) NOT NULL, ADD CachedCategoryTemplate VARCHAR(255) NOT NULL, ADD CachedItemTemplate VARCHAR(255) NOT NULL; ALTER TABLE Category CHANGE AutomaticFilename AutomaticFilename TINYINT(3) UNSIGNED NOT NULL DEFAULT '1';