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

[geeklog-cvs at lists.geeklog.net]

changeset 7849:ffbda0399cb8
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/ffbda0399cb8
user: Dirk Haun <dirk at haun-online.de>
date: Sat Mar 27 19:25:20 2010 +0100
description:
Added sp_page_title to other DBs and to the upgrade SQL

diffstat:

 plugins/staticpages/language/english_utf-8.php |   1 +
 plugins/staticpages/sql/mssql_install.php      |   3 ++-
 plugins/staticpages/sql/mssql_updates.php      |  10 ++++++----
 plugins/staticpages/sql/mysql_updates.php      |  10 ++++++----
 plugins/staticpages/sql/pgsql_install.php      |   1 +
 5 files changed, 16 insertions(+), 9 deletions(-)

diffs (92 lines):

diff -r 2f957be083f0 -r ffbda0399cb8 plugins/staticpages/language/english_utf-8.php
--- a/plugins/staticpages/language/english_utf-8.php	Fri Mar 26 01:14:44 2010 +0200
+++ b/plugins/staticpages/language/english_utf-8.php	Sat Mar 27 19:25:20 2010 +0100
@@ -40,6 +40,7 @@
     'writtenby' => 'Written By',
     'date' => 'Last Updated',
     'title' => 'Title',
+    'page_title' => 'Page Title',
     'content' => 'Content',
     'hits' => 'Hits',
     'staticpagelist' => 'Static Page List',
diff -r 2f957be083f0 -r ffbda0399cb8 plugins/staticpages/sql/mssql_install.php
--- a/plugins/staticpages/sql/mssql_install.php	Fri Mar 26 01:14:44 2010 +0200
+++ b/plugins/staticpages/sql/mssql_install.php	Sat Mar 27 19:25:20 2010 +0100
@@ -6,7 +6,7 @@
 // +---------------------------------------------------------------------------+
 // | Installation SQL                                                          |
 // +---------------------------------------------------------------------------+
-// | Copyright (C) 2000-2009 by the following authors:                         |
+// | Copyright (C) 2000-2010 by the following authors:                         |
 // |                                                                           |
 // | Authors: Tony Bibbs       - tony AT tonybibbs DOT com                     |
 // |          Tom Willett      - twillett AT users DOT sourceforge DOT net     |
@@ -40,6 +40,7 @@
 CREATE TABLE [dbo].[{$_TABLES['staticpage']}] (
     [sp_id] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
     [sp_title] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+    [sp_page_title] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
     [sp_content] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
     [sp_hits] [numeric](8, 0) NOT NULL ,
     [created] [datetime] NOT NULL ,
diff -r 2f957be083f0 -r ffbda0399cb8 plugins/staticpages/sql/mssql_updates.php
--- a/plugins/staticpages/sql/mssql_updates.php	Fri Mar 26 01:14:44 2010 +0200
+++ b/plugins/staticpages/sql/mssql_updates.php	Sat Mar 27 19:25:20 2010 +0100
@@ -6,7 +6,7 @@
 // +---------------------------------------------------------------------------+
 // | Upgrade SQL                                                               |
 // +---------------------------------------------------------------------------+
-// | Copyright (C) 2009 by the following authors:                              |
+// | Copyright (C) 2009-2010 by the following authors:                         |
 // |                                                                           |
 // | Authors: Tom Homer        - websitemaster AT cogeco DOT net               |
 // +---------------------------------------------------------------------------+
@@ -40,11 +40,13 @@
 
     '1.6.1' => array(
         "ALTER TABLE {$_TABLES['staticpage']} DROP COLUMN sp_uid",
-        "ALTER TABLE {$_TABLES['staticpage']} ADD [draft_flag] [tinyint] NULL AFTER meta_keywords", 
-        
+        "ALTER TABLE {$_TABLES['staticpage']} ADD [draft_flag] [tinyint] NULL AFTER meta_keywords",
+
         "EXEC sp_rename '{$_TABLES['staticpage']}.sp_date', 'created', 'COLUMN'",
         "ALTER TABLE {$_TABLES['staticpage']} ADD [modified] [datetime] NOT NULL AFTER created",
-        "UPDATE {$_TABLES['staticpage']} SET modified = created"
+        "UPDATE {$_TABLES['staticpage']} SET modified = created",
+
+        "ALTER TABLE {$_TABLES['staticpage']} ADD [sp_page_title] [varchar] (128) NOT NULL AFTER sp_title"
     )
 );
 
diff -r 2f957be083f0 -r ffbda0399cb8 plugins/staticpages/sql/mysql_updates.php
--- a/plugins/staticpages/sql/mysql_updates.php	Fri Mar 26 01:14:44 2010 +0200
+++ b/plugins/staticpages/sql/mysql_updates.php	Sat Mar 27 19:25:20 2010 +0100
@@ -41,11 +41,13 @@
 
     '1.6.1' => array(
         "ALTER TABLE {$_TABLES['staticpage']} DROP COLUMN sp_uid",
-        "ALTER TABLE {$_TABLES['staticpage']} ADD draft_flag tinyint(1) unsigned default '0' AFTER meta_keywords", 
-        
+        "ALTER TABLE {$_TABLES['staticpage']} ADD draft_flag tinyint(1) unsigned default '0' AFTER meta_keywords",
+
         "ALTER TABLE {$_TABLES['staticpage']} CHANGE sp_date `created` datetime default NULL",
-        "ALTER TABLE {$_TABLES['staticpage']} ADD modified datetime NOT NULL default '0000-00-00 00:00:00' AFTER `created`", 
-        "UPDATE {$_TABLES['staticpage']} SET modified = `created`"
+        "ALTER TABLE {$_TABLES['staticpage']} ADD modified datetime NOT NULL default '0000-00-00 00:00:00' AFTER `created`",
+        "UPDATE {$_TABLES['staticpage']} SET modified = `created`",
+
+        "ALTER TABLE {$_TABLES['staticpage']} ADD sp_page_title varchar(128) NOT NULL default '' AFTER sp_title"
     )
 
 );
diff -r 2f957be083f0 -r ffbda0399cb8 plugins/staticpages/sql/pgsql_install.php
--- a/plugins/staticpages/sql/pgsql_install.php	Fri Mar 26 01:14:44 2010 +0200
+++ b/plugins/staticpages/sql/pgsql_install.php	Sat Mar 27 19:25:20 2010 +0100
@@ -37,6 +37,7 @@
   sp_id varchar(40) NOT NULL default '',
   sp_uid int NOT NULL default '1',
   sp_title varchar(128) NOT NULL default '',
+  sp_page_title varchar(128) NOT NULL default '',
   sp_content text NOT NULL,
   sp_hits int NOT NULL default '0',
   created timestamp NOT NULL default NULL,