[geeklog-cvs] geeklog: Added page_title to other DBs and to the upgrade SQL

[geeklog-cvs at lists.geeklog.net]

changeset 7838:14e7975aeef8
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/14e7975aeef8
user: Dirk Haun <dirk at haun-online.de>
date: Sat Mar 27 14:36:04 2010 +0100
description:
Added page_title to other DBs and to the upgrade SQL

diffstat:

 language/english_utf-8.php           |   1 +
 sql/mssql_tableanddata.php           |   1 +
 sql/mysql_tableanddata.php           |   2 +-
 sql/pgsql_tableanddata.php           |   1 +
 sql/updates/mssql_1.6.1_to_1.6.2.php |  21 +++++++++++++++++++++
 sql/updates/mysql_1.6.1_to_1.6.2.php |   3 +++
 6 files changed, 28 insertions(+), 1 deletions(-)

diffs (87 lines):

diff -r bf74ab75079f -r 14e7975aeef8 language/english_utf-8.php
--- a/language/english_utf-8.php	Sat Mar 27 13:18:03 2010 +0100
+++ b/language/english_utf-8.php	Sat Mar 27 14:36:04 2010 +0100
@@ -1592,6 +1592,7 @@
     'create_new_adv'=> 'Create New (Adv.)',
     'enabled'       => 'Enabled',
     'title'         => 'Title',
+    'page_title'    => 'Page Title',
     'type'          => 'Type',
     'topic'         => 'Topic',
     'help_url'      => 'Help File URL',
diff -r bf74ab75079f -r 14e7975aeef8 sql/mssql_tableanddata.php
--- a/sql/mssql_tableanddata.php	Sat Mar 27 13:18:03 2010 +0100
+++ b/sql/mssql_tableanddata.php	Sat Mar 27 14:36:04 2010 +0100
@@ -294,6 +294,7 @@
     [tid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
     [date] [datetime] NULL ,
     [title] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+    [page_title] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
     [introtext] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
     [bodytext] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
     [hits] [numeric](8, 0) NOT NULL ,
diff -r bf74ab75079f -r 14e7975aeef8 sql/mysql_tableanddata.php
--- a/sql/mysql_tableanddata.php	Sat Mar 27 13:18:03 2010 +0100
+++ b/sql/mysql_tableanddata.php	Sat Mar 27 14:36:04 2010 +0100
@@ -301,7 +301,7 @@
   tid varchar(20) NOT NULL default 'General',
   date datetime default NULL,
   title varchar(128) default NULL,
-  page_title varchar(128),
+  page_title varchar(128) default NULL,
   introtext text,
   bodytext text,
   hits mediumint(8) unsigned NOT NULL default '0',
diff -r bf74ab75079f -r 14e7975aeef8 sql/pgsql_tableanddata.php
--- a/sql/pgsql_tableanddata.php	Sat Mar 27 13:18:03 2010 +0100
+++ b/sql/pgsql_tableanddata.php	Sat Mar 27 14:36:04 2010 +0100
@@ -296,6 +296,7 @@
   tid varchar(20) NOT NULL default 'General',
   date timestamp NOT NULL default current_timestamp,
   title varchar(128) default NULL,
+  page_title varchar(128) default NULL,
   introtext text,
   bodytext text,
   hits smallint NOT NULL default '0',
diff -r bf74ab75079f -r 14e7975aeef8 sql/updates/mssql_1.6.1_to_1.6.2.php
--- a/sql/updates/mssql_1.6.1_to_1.6.2.php	Sat Mar 27 13:18:03 2010 +0100
+++ b/sql/updates/mssql_1.6.1_to_1.6.2.php	Sat Mar 27 14:36:04 2010 +0100
@@ -32,4 +32,25 @@
 // Insert Group right to allow skipping of the HTML filter
 $_SQL[] = "INSERT INTO {$_TABLES['features']} (ft_name, ft_descr, ft_gl_core) VALUES ('htmlfilter.skip', 'Skip filtering posts for HTML', 1)";
 
+// new alternative page title for stories
+$_SQL[] = "ALTER TABLE {$_TABLES['stories']} ADD [page_title] [varchar] (128) NULL";
+
+/**
+ * Add new config options
+ *
+ */
+function update_ConfValuesFor162()
+{
+    global $_CONF, $_TABLES;
+
+    require_once $_CONF['path_system'] . 'classes/config.class.php';
+
+    $c = config::get_instance();
+
+    // search config options.
+    $c->add('search_def_sort','hits|desc','select',0,6,27,676,TRUE);
+
+    return true;
+}
+
 ?>
diff -r bf74ab75079f -r 14e7975aeef8 sql/updates/mysql_1.6.1_to_1.6.2.php
--- a/sql/updates/mysql_1.6.1_to_1.6.2.php	Sat Mar 27 13:18:03 2010 +0100
+++ b/sql/updates/mysql_1.6.1_to_1.6.2.php	Sat Mar 27 14:36:04 2010 +0100
@@ -32,6 +32,9 @@
 // Insert Group right to allow skipping of the HTML filter
 $_SQL[] = "INSERT INTO {$_TABLES['features']} (ft_name, ft_descr, ft_gl_core) VALUES ('htmlfilter.skip', 'Skip filtering posts for HTML', 1)";
 
+// new alternative page title for stories
+$_SQL[] = "ALTER TABLE {$_TABLES['stories']} ADD page_title varchar(128) default NULL AFTER title";
+
 /**
  * Add new config options
  *