sql/updates/mysql_1.6.0_to_1.6.1.php
author Dirk Haun <dirk@haun-online.de>
Sun, 01 Nov 2009 09:43:28 +0100
branchHEAD
changeset 7434 aa322b3c4d3d
parent 7428 df55886043f2
parent 7393 d0952e303944
permissions -rw-r--r--
Merged with "timezone" feature branch
     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     // the timezone config option is a dropdown now
    33     $utc = addslashes(serialize('UTC')); // change default timezone to UTC
    34     DB_query("UPDATE {$_TABLES['conf_values']} SET type = 'select', selectionArray = -1, default_value = '$utc' WHERE name = 'timezone' AND group_name = 'Core'");
    35 
    36     return true;
    37 }
    38 
    39 ?>