1.1 --- a/sql/updates/mysql_1.6.0_to_1.6.1.php	Sun Sep 20 11:00:03 2009 +0200
     1.2 +++ b/sql/updates/mysql_1.6.0_to_1.6.1.php	Sun Nov 01 09:43:28 2009 +0100
     1.3 @@ -3,10 +3,12 @@
     1.4  // Add meta tag columns to story table 
     1.5  $_SQL[] = "ALTER TABLE {$_TABLES['stories']} ADD meta_description TEXT NULL AFTER frontpage, ADD meta_keywords TEXT NULL AFTER meta_description";
     1.6  
     1.7 -
     1.8  // Add meta tag columns to topics table 
     1.9  $_SQL[] = "ALTER TABLE {$_TABLES['topics']} ADD meta_description TEXT NULL AFTER imageurl, ADD meta_keywords TEXT NULL AFTER meta_description";
    1.10  
    1.11 +// allow bigger values for topic sort number
    1.12 +$_SQL[] = "ALTER TABLE {$_TABLES['topics']} CHANGE sortnum sortnum smallint(3) default NULL";
    1.13 +
    1.14  /**
    1.15   * Add new config options
    1.16   *
    1.17 @@ -24,6 +26,9 @@
    1.18      $c->add('meta_description','Geeklog, the open source content management system designed with security in mind.','text',0,0,NULL,2010,TRUE);
    1.19      $c->add('meta_keywords','Geeklog, Blog, Content Management System, CMS, Open Source, Security','text',0,0,NULL,2020,TRUE);
    1.20  
    1.21 +    // new option to enable / disable closing of comments after x days
    1.22 +    $c->add('article_comment_close_enabled',0,'select',4,21,0, 1685, TRUE);
    1.23 +
    1.24      // the timezone config option is a dropdown now
    1.25      $utc = addslashes(serialize('UTC')); // change default timezone to UTC
    1.26      DB_query("UPDATE {$_TABLES['conf_values']} SET type = 'select', selectionArray = -1, default_value = '$utc' WHERE name = 'timezone' AND group_name = 'Core'");