Index: branches/5.2.x/install/install_schema.sql
===================================================================
diff -u -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),
Index: branches/5.2.x/admin_templates/paid_listings/paid_listing_edit.tpl
===================================================================
diff -u -r13842 -r14090
--- branches/5.2.x/admin_templates/paid_listings/paid_listing_edit.tpl (.../paid_listing_edit.tpl) (revision 13842)
+++ branches/5.2.x/admin_templates/paid_listings/paid_listing_edit.tpl (.../paid_listing_edit.tpl) (revision 14090)
@@ -61,16 +61,12 @@
-
-
-
-
-
+
+
+
|
-
|
-