sql/updates/mysql_1.6.0_to_1.6.1.php
author Dirk Haun <dirk@haun-online.de>
Thu, 29 Oct 2009 11:37:11 +0100
branchHEAD
changeset 7393 d0952e303944
parent 7370 e5bbed84d3b1
child 7434 aa322b3c4d3d
permissions -rw-r--r--
Allow bigger values for a topic's Sort Order field (feature request #0001011)
     1 <?php
     2 
     3 // Add meta tag columns to story table 
     4 $_SQL[] = "ALTER TABLE {$_TABLES['stories']} ADD meta_description TEXT NULL AFTER frontpage, ADD meta_keywords TEXT NULL AFTER meta_description";
     5 
     6 // Add meta tag columns to topics table 
     7 $_SQL[] = "ALTER TABLE {$_TABLES['topics']} ADD meta_description TEXT NULL AFTER imageurl, ADD meta_keywords TEXT NULL AFTER meta_description";
     8 
     9 // allow bigger values for topic sort number
    10 $_SQL[] = "ALTER TABLE {$_TABLES['topics']} CHANGE sortnum sortnum smallint(3) default NULL";
    11 
    12 /**
    13  * Add new config options
    14  *
    15  */
    16 function update_ConfValuesFor161()
    17 {
    18     global $_CONF, $_TABLES;
    19 
    20     require_once $_CONF['path_system'] . 'classes/config.class.php';
    21 
    22     $c = config::get_instance();
    23 
    24     // meta tag config options.
    25     $c->add('meta_tags',0,'select',0,0,23,2000,TRUE);
    26     $c->add('meta_description','Geeklog, the open source content management system designed with security in mind.','text',0,0,NULL,2010,TRUE);
    27     $c->add('meta_keywords','Geeklog, Blog, Content Management System, CMS, Open Source, Security','text',0,0,NULL,2020,TRUE);
    28 
    29     // new option to enable / disable closing of comments after x days
    30     $c->add('article_comment_close_enabled',0,'select',4,21,0, 1685, TRUE);
    31 
    32     return true;
    33 }
    34 
    35 ?>