[geeklog-hg] geeklog: Removed unused columns from comments table {bug #0001654)

[geeklog-cvs at lists.geeklog.net]

changeset 9170:53915d861ebc
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/53915d861ebc
user: Tom <websitemaster at cogeco.net>
date: Sun Jul 07 09:44:54 2013 -0400
description:
Removed unused columns from comments table {bug #0001654)

diffstat:

 sql/mssql_tableanddata.php           |  2 --
 sql/mysql_tableanddata.php           |  2 --
 sql/pgsql_tableanddata.php           |  2 --
 sql/updates/mssql_2.0.0_to_2.0.1.php |  3 +++
 sql/updates/mysql_2.0.0_to_2.0.1.php |  3 +++
 sql/updates/pgsql_2.0.0_to_2.0.1.php |  2 ++
 6 files changed, 8 insertions(+), 6 deletions(-)

diffs (74 lines):

diff -r 71def4f20e39 -r 53915d861ebc sql/mssql_tableanddata.php
--- a/sql/mssql_tableanddata.php	Sat Jul 06 07:59:15 2013 -0400
+++ b/sql/mssql_tableanddata.php	Sun Jul 07 09:44:54 2013 -0400
@@ -117,8 +117,6 @@
     [date] [datetime] NULL ,
     [title] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
     [comment] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
-    [score] [smallint] NULL ,
-    [reason] [smallint] NULL ,
     [pid] [numeric](10, 0) NULL ,
     [lft] [numeric](10, 0) NULL ,
     [rht] [numeric](10, 0) NULL ,
diff -r 71def4f20e39 -r 53915d861ebc sql/mysql_tableanddata.php
--- a/sql/mysql_tableanddata.php	Sat Jul 06 07:59:15 2013 -0400
+++ b/sql/mysql_tableanddata.php	Sun Jul 07 09:44:54 2013 -0400
@@ -94,8 +94,6 @@
   date datetime default NULL,
   title varchar(128) default NULL,
   comment text,
-  score tinyint(4) NOT NULL default '0',
-  reason tinyint(4) NOT NULL default '0',
   pid int(10) unsigned NOT NULL default '0',
   lft mediumint(10) unsigned NOT NULL default '0',
   rht mediumint(10) unsigned NOT NULL default '0',
diff -r 71def4f20e39 -r 53915d861ebc sql/pgsql_tableanddata.php
--- a/sql/pgsql_tableanddata.php	Sat Jul 06 07:59:15 2013 -0400
+++ b/sql/pgsql_tableanddata.php	Sun Jul 07 09:44:54 2013 -0400
@@ -94,8 +94,6 @@
   date timestamp NOT NULL DEFAULT current_timestamp,
   title varchar(128) default NULL,
   comment text,
-  score smallint NOT NULL default '0',
-  reason smallint NOT NULL default '0',
   pid int NOT NULL default '0',
   lft smallint NOT NULL default '0',
   rht smallint NOT NULL default '0',
diff -r 71def4f20e39 -r 53915d861ebc sql/updates/mssql_2.0.0_to_2.0.1.php
--- a/sql/updates/mssql_2.0.0_to_2.0.1.php	Sat Jul 06 07:59:15 2013 -0400
+++ b/sql/updates/mssql_2.0.0_to_2.0.1.php	Sun Jul 07 09:44:54 2013 -0400
@@ -6,6 +6,9 @@
 // Add Cache Time variable to Blocks table
 $_SQL[] = "ALTER TABLE {$_TABLES['blocks']} ADD `cache_time` INT NOT NULL DEFAULT '0' AFTER `allow_autotags`"; 
 
+// Remove unused columns in Comments table
+$_SQL[] = "ALTER TABLE {$_TABLES['comments']}  DROP `score`, DROP `reason`";
+
 /**
  * Add new config options
  *
diff -r 71def4f20e39 -r 53915d861ebc sql/updates/mysql_2.0.0_to_2.0.1.php
--- a/sql/updates/mysql_2.0.0_to_2.0.1.php	Sat Jul 06 07:59:15 2013 -0400
+++ b/sql/updates/mysql_2.0.0_to_2.0.1.php	Sun Jul 07 09:44:54 2013 -0400
@@ -6,6 +6,9 @@
 // Add Cache Time variable to Blocks table
 $_SQL[] = "ALTER TABLE {$_TABLES['blocks']} ADD `cache_time` INT NOT NULL DEFAULT '0' AFTER `allow_autotags`"; 
 
+// Remove unused columns in Comments table
+$_SQL[] = "ALTER TABLE {$_TABLES['comments']}  DROP `score`, DROP `reason`"; 
+
 /**
  * Add new config options
  *
diff -r 71def4f20e39 -r 53915d861ebc sql/updates/pgsql_2.0.0_to_2.0.1.php
--- a/sql/updates/pgsql_2.0.0_to_2.0.1.php	Sat Jul 06 07:59:15 2013 -0400
+++ b/sql/updates/pgsql_2.0.0_to_2.0.1.php	Sun Jul 07 09:44:54 2013 -0400
@@ -6,6 +6,8 @@
 // Add Cache Time variable to Blocks table
 $_SQL[] = "ALTER TABLE {$_TABLES['blocks']} ADD `cache_time` INT NOT NULL DEFAULT '0' AFTER `allow_autotags`"; 
 
+// Remove unused columns in Comments table
+$_SQL[] = "ALTER TABLE {$_TABLES['comments']}  DROP `score`, DROP `reason`"; 
 
 /**
  * Add new config options