[geeklog-cvs] geeklog: Fixed MS SQL upgrade for the Polls plugin (bug #0001144)

[geeklog-cvs at lists.geeklog.net]

changeset 7901:63488b7f8b9b
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/63488b7f8b9b
user: Dirk Haun <dirk at haun-online.de>
date: Fri Apr 30 20:06:40 2010 +0200
description:
Fixed MS SQL upgrade for the Polls plugin (bug #0001144)

diffstat:

 plugins/polls/sql/mssql_updates.php |  8 ++++----
 public_html/docs/history            |  6 +++++-
 2 files changed, 9 insertions(+), 5 deletions(-)

diffs (55 lines):

diff -r d0e63bf1f2b3 -r 63488b7f8b9b plugins/polls/sql/mssql_updates.php
--- a/plugins/polls/sql/mssql_updates.php	Wed Apr 28 19:55:24 2010 +0200
+++ b/plugins/polls/sql/mssql_updates.php	Fri Apr 30 20:06:40 2010 +0200
@@ -6,7 +6,7 @@
 // +---------------------------------------------------------------------------+
 // | mssql_updates.php                                                         |
 // +---------------------------------------------------------------------------+
-// | Copyright (C) 2008-2009 by the following authors:                         |
+// | Copyright (C) 2008-2010 by the following authors:                         |
 // |                                                                           |
 // | Authors: Dirk Haun         - dirk AT haun-online DOT de                   |
 // +---------------------------------------------------------------------------+
@@ -45,17 +45,17 @@
 
         // New field post-2.1.0
         "ALTER TABLE {$_TABLES['polltopics']} ADD meta_description [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL AFTER topic, ADD meta_keywords [meta_keywords] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL AFTER meta_description"
-    )
+    ),
 
     '2.1.1' => array(
         // make room to store IPv6 addresses
         "ALTER TABLE {$_TABLES['pollvoters']} ALTER COLUMN [ipaddress] VARCHAR(39) NOT NULL",
 
         "EXEC sp_rename '{$_TABLES['polltopics']}.date', 'created', 'COLUMN'",
-        "ALTER TABLE {$_TABLES['polltopics']} ADD modified [datetime] NULL AFTER created"
+        "ALTER TABLE {$_TABLES['polltopics']} ADD modified [datetime] NULL AFTER created",
         "UPDATE {$_TABLES['polltopics']} SET modified = created"        
     )
-    
+
 );
 
 function update_ConfValues_2_1_0()
diff -r d0e63bf1f2b3 -r 63488b7f8b9b public_html/docs/history
--- a/public_html/docs/history	Wed Apr 28 19:55:24 2010 +0200
+++ b/public_html/docs/history	Fri Apr 30 20:06:40 2010 +0200
@@ -1,6 +1,6 @@
 Geeklog History/Changes:
 
-Apr ??, 2010 (1.7.0rc1)
+May ??, 2010 (1.7.0rc1)
 ------------
 
 Geeklog 1.7.0 now supports PostgreSQL, implemented by Stan Palatnik during the
@@ -26,6 +26,10 @@
   Geeklog.jp group
 - Updated Slovak language files, provided by Miroslav Fikar
 
+Polls Plugin
+------------
+- Fixed MS SQL upgrade (bug #0001144)
+
 Spam-X Plugin
 -------------
 - Removed 'admin_override' entry from language files (bug #0001114)