[geeklog-cvs] geeklog: Allow bigger values for a topic's Sort Order field (fea...

[geeklog-cvs at lists.geeklog.net]

changeset 7393:d0952e303944
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/d0952e303944
user: Dirk Haun <dirk at haun-online.de>
date: Thu Oct 29 11:37:11 2009 +0100
description:
Allow bigger values for a topic's Sort Order field (feature request #0001011)

diffstat:

 public_html/docs/history             |  2 ++
 sql/mysql_tableanddata.php           |  2 +-
 sql/updates/mysql_1.6.0_to_1.6.1.php |  4 +++-
 3 files changed, 6 insertions(+), 2 deletions(-)

diffs (41 lines):

diff -r 3872f0c040e4 -r d0952e303944 public_html/docs/history
--- a/public_html/docs/history	Sun Oct 25 23:15:27 2009 +0000
+++ b/public_html/docs/history	Thu Oct 29 11:37:11 2009 +0100
@@ -3,6 +3,8 @@
 Oct ??, 2009 (1.6.1)
 ------------
 
+- Allow bigger values for a topic's Sort Order field (feature request #0001011)
+  [Dirk]
 - When a Story Admin did not have permission to edit a story, Geeklog threw a
   "call to a member function on a non-object" error when trying to display a
   proper "access denied" message (reported by Chase and Cesar) [Dirk]
diff -r 3872f0c040e4 -r d0952e303944 sql/mysql_tableanddata.php
--- a/sql/mysql_tableanddata.php	Sun Oct 25 23:15:27 2009 +0000
+++ b/sql/mysql_tableanddata.php	Thu Oct 29 11:37:11 2009 +0100
@@ -396,7 +396,7 @@
   imageurl varchar(255) default NULL,
   meta_description TEXT NULL,
   meta_keywords TEXT NULL,
-  sortnum tinyint(3) default NULL,
+  sortnum smallint(3) default NULL,
   limitnews tinyint(3) default NULL,
   is_default tinyint(1) unsigned NOT NULL DEFAULT '0',
   archive_flag tinyint(1) unsigned NOT NULL DEFAULT '0',
diff -r 3872f0c040e4 -r d0952e303944 sql/updates/mysql_1.6.0_to_1.6.1.php
--- a/sql/updates/mysql_1.6.0_to_1.6.1.php	Sun Oct 25 23:15:27 2009 +0000
+++ b/sql/updates/mysql_1.6.0_to_1.6.1.php	Thu Oct 29 11:37:11 2009 +0100
@@ -3,10 +3,12 @@
 // Add meta tag columns to story table 
 $_SQL[] = "ALTER TABLE {$_TABLES['stories']} ADD meta_description TEXT NULL AFTER frontpage, ADD meta_keywords TEXT NULL AFTER meta_description";
 
-
 // Add meta tag columns to topics table 
 $_SQL[] = "ALTER TABLE {$_TABLES['topics']} ADD meta_description TEXT NULL AFTER imageurl, ADD meta_keywords TEXT NULL AFTER meta_description";
 
+// allow bigger values for topic sort number
+$_SQL[] = "ALTER TABLE {$_TABLES['topics']} CHANGE sortnum sortnum smallint(3) default NULL";
+
 /**
  * Add new config options
  *