Index: branches/5.2.x/install/install_schema.sql =================================================================== diff -u -N -r13842 -r14090 --- branches/5.2.x/install/install_schema.sql (.../install_schema.sql) (revision 13842) +++ branches/5.2.x/install/install_schema.sql (.../install_schema.sql) (revision 14090) @@ -1,45 +1,45 @@ CREATE TABLE Link ( - LinkId int(11) NOT NULL auto_increment, - Name varchar(255) NOT NULL default '', - l1_Name varchar(255) NOT NULL default '', - l2_Name varchar(255) NOT NULL default '', - l3_Name varchar(255) NOT NULL default '', - l4_Name varchar(255) NOT NULL default '', - l5_Name varchar(255) NOT NULL default '', - AutomaticFilename tinyint(3) unsigned NOT NULL default '1', + LinkId int(11) NOT NULL AUTO_INCREMENT, + `Name` varchar(255) NOT NULL DEFAULT '', + l1_Name varchar(255) NOT NULL DEFAULT '', + l2_Name varchar(255) NOT NULL DEFAULT '', + l3_Name varchar(255) NOT NULL DEFAULT '', + l4_Name varchar(255) NOT NULL DEFAULT '', + l5_Name varchar(255) NOT NULL DEFAULT '', + AutomaticFilename tinyint(3) unsigned NOT NULL DEFAULT '1', Description text, l1_Description text, l2_Description text, l3_Description text, l4_Description text, l5_Description text, - MetaKeywords varchar(255) default NULL, + MetaKeywords varchar(255) DEFAULT NULL, MetaDescription text, - Url varchar(255) NOT NULL default '', - CreatedOn int(10) unsigned default NULL, - Modified int(10) unsigned default NULL, - Expire int(10) unsigned default NULL, - Hits double(20,6) NOT NULL default '0.000000', - CachedRating varchar(10) NOT NULL default '0', - CachedVotesQty int(11) NOT NULL default '0', - CachedReviewsQty int(11) NOT NULL default '0', - CreatedById int(11) NOT NULL default '-1', - ModifiedById int(11) NOT NULL default '-1', - Priority int(11) NOT NULL default '0', - `Status` tinyint(4) NOT NULL default '2', - EditorsPick tinyint(4) NOT NULL default '0', - ResourceId int(11) default NULL, - HotItem tinyint(4) NOT NULL default '2', - PopItem tinyint(4) NOT NULL default '2', - NewItem tinyint(4) NOT NULL default '2', - OrgId int(11) default NULL, - CustomTemplate varchar(255) NOT NULL default '', - ReciprocalLinkFound tinyint(3) unsigned NOT NULL default '0', - PRIMARY KEY (LinkId), + Url varchar(255) NOT NULL DEFAULT '', + CreatedOn int(10) unsigned DEFAULT NULL, + Modified int(10) unsigned DEFAULT NULL, + Expire int(10) unsigned DEFAULT NULL, + Hits double(20,6) NOT NULL DEFAULT '0.000000', + CachedRating varchar(10) NOT NULL DEFAULT '0', + CachedVotesQty int(11) NOT NULL DEFAULT '0', + CachedReviewsQty int(11) NOT NULL DEFAULT '0', + CreatedById int(11) DEFAULT NULL, + ModifiedById int(11) DEFAULT NULL, + Priority int(11) NOT NULL DEFAULT '0', + `Status` tinyint(4) NOT NULL DEFAULT '2', + EditorsPick tinyint(4) NOT NULL DEFAULT '0', + ResourceId int(11) DEFAULT NULL, + HotItem tinyint(4) NOT NULL DEFAULT '2', + PopItem tinyint(4) NOT NULL DEFAULT '2', + NewItem tinyint(4) NOT NULL DEFAULT '2', + OrgId int(11) DEFAULT NULL, + CustomTemplate varchar(255) NOT NULL DEFAULT '', + ReciprocalLinkFound tinyint(3) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (LinkId), UNIQUE KEY ResourceId (ResourceId), - KEY sorting (Priority,Name), + KEY sorting (Priority,`Name`), KEY Hits (Hits), - KEY Name (Name), + KEY `Name` (`Name`), KEY l1_Name (l1_Name), KEY l2_Name (l2_Name), KEY l3_Name (l3_Name),