[geeklog-hg] geeklog: Changed topic parent id to max 128 character length

[geeklog-cvs at lists.geeklog.net]

changeset 9239:b447b74d2a5c
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/b447b74d2a5c
user: Tom <websitemaster at cogeco.net>
date: Tue Jul 30 21:41:12 2013 -0400
description:
Changed topic parent id to max 128 character length

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 |  1 +
 sql/updates/mysql_2.0.0_to_2.0.1.php |  1 +
 sql/updates/pgsql_2.0.0_to_2.0.1.php |  1 +
 6 files changed, 6 insertions(+), 3 deletions(-)

diffs (69 lines):

diff -r a8fab96dbae2 -r b447b74d2a5c sql/mssql_tableanddata.php
--- a/sql/mssql_tableanddata.php	Mon Jul 29 21:31:05 2013 -0400
+++ b/sql/mssql_tableanddata.php	Tue Jul 30 21:41:12 2013 -0400
@@ -390,7 +390,7 @@
     [limitnews] [smallint] NULL ,
     [is_default] [tinyint] NOT NULL ,
     [archive_flag] [tinyint]  NULL ,
-    [parent_id] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
+    [parent_id] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
     [inherit] [tinyint] NOT NULL,
     [hidden] [tinyint] NOT NULL,
     [owner_id] [numeric](8, 0) NOT NULL ,
diff -r a8fab96dbae2 -r b447b74d2a5c sql/mysql_tableanddata.php
--- a/sql/mysql_tableanddata.php	Mon Jul 29 21:31:05 2013 -0400
+++ b/sql/mysql_tableanddata.php	Tue Jul 30 21:41:12 2013 -0400
@@ -412,7 +412,7 @@
   limitnews tinyint(3) default NULL,
   is_default tinyint(1) unsigned NOT NULL DEFAULT '0',
   archive_flag tinyint(1) unsigned NOT NULL DEFAULT '0',
-  parent_id varchar(20) NOT NULL default 'root',
+  parent_id varchar(128) NOT NULL default 'root',
   inherit tinyint(1) NOT NULL default '1',
   hidden tinyint(1) NOT NULL default '0',
   owner_id mediumint(8) unsigned NOT NULL default '1',
diff -r a8fab96dbae2 -r b447b74d2a5c sql/pgsql_tableanddata.php
--- a/sql/pgsql_tableanddata.php	Mon Jul 29 21:31:05 2013 -0400
+++ b/sql/pgsql_tableanddata.php	Tue Jul 30 21:41:12 2013 -0400
@@ -411,7 +411,7 @@
   limitnews smallint default NULL,
   is_default smallint NOT NULL DEFAULT '0',
   archive_flag smallint NOT NULL DEFAULT '0',
-  parent_id varchar(20) NOT NULL default 'root',
+  parent_id varchar(128) NOT NULL default 'root',
   inherit smallint NOT NULL default '1',
   hidden smallint NOT NULL default '0',
   owner_id smallint NOT NULL default '1',
diff -r a8fab96dbae2 -r b447b74d2a5c sql/updates/mssql_2.0.0_to_2.0.1.php
--- a/sql/updates/mssql_2.0.0_to_2.0.1.php	Mon Jul 29 21:31:05 2013 -0400
+++ b/sql/updates/mssql_2.0.0_to_2.0.1.php	Tue Jul 30 21:41:12 2013 -0400
@@ -18,6 +18,7 @@
 // Update all topic ids and Topic name to 128 characters
 $_SQL[] = "ALTER TABLE {$_TABLES['topics']} CHANGE [tid] VARCHAR(128) NOT NULL";
 $_SQL[] = "ALTER TABLE {$_TABLES['topics']} CHANGE [topic] VARCHAR(128) NULL DEFAULT NULL";
+$_SQL[] = "ALTER TABLE {$_TABLES['topics']} CHANGE [parent_id] VARCHAR(128) NOT NULL DEFAULT 'root'";
 $_SQL[] = "ALTER TABLE {$_TABLES['topic_assignments']} CHANGE [tid] VARCHAR(128) NOT NULL";
 $_SQL[] = "ALTER TABLE {$_TABLES['topic_assignments']} CHANGE [id] VARCHAR(128) NOT NULL";
 $_SQL[] = "ALTER TABLE {$_TABLES['sessions']} CHANGE [topic] VARCHAR(128) NOT NULL DEFAULT ''";
diff -r a8fab96dbae2 -r b447b74d2a5c sql/updates/mysql_2.0.0_to_2.0.1.php
--- a/sql/updates/mysql_2.0.0_to_2.0.1.php	Mon Jul 29 21:31:05 2013 -0400
+++ b/sql/updates/mysql_2.0.0_to_2.0.1.php	Tue Jul 30 21:41:12 2013 -0400
@@ -18,6 +18,7 @@
 // Update all topic ids and Topic name to 128 characters
 $_SQL[] = "ALTER TABLE {$_TABLES['topics']} CHANGE `tid` `tid` VARCHAR(128) NOT NULL";
 $_SQL[] = "ALTER TABLE {$_TABLES['topics']} CHANGE `topic` `topic` VARCHAR(128) NULL DEFAULT NULL";
+$_SQL[] = "ALTER TABLE {$_TABLES['topics']} CHANGE `parent_id` `parent_id` VARCHAR(128) NOT NULL DEFAULT 'root'";
 $_SQL[] = "ALTER TABLE {$_TABLES['topic_assignments']} CHANGE `tid` `tid` VARCHAR(128) NOT NULL";
 $_SQL[] = "ALTER TABLE {$_TABLES['topic_assignments']} CHANGE `id` `id` VARCHAR(128) NOT NULL";
 $_SQL[] = "ALTER TABLE {$_TABLES['sessions']} CHANGE `topic` `topic` VARCHAR(128) NOT NULL DEFAULT ''";
diff -r a8fab96dbae2 -r b447b74d2a5c sql/updates/pgsql_2.0.0_to_2.0.1.php
--- a/sql/updates/pgsql_2.0.0_to_2.0.1.php	Mon Jul 29 21:31:05 2013 -0400
+++ b/sql/updates/pgsql_2.0.0_to_2.0.1.php	Tue Jul 30 21:41:12 2013 -0400
@@ -18,6 +18,7 @@
 // Update all topic ids and Topic name to 128 characters
 $_SQL[] = "ALTER TABLE {$_TABLES['topics']} CHANGE `tid` `tid` VARCHAR(128) NOT NULL";
 $_SQL[] = "ALTER TABLE {$_TABLES['topics']} CHANGE `topic` `topic` VARCHAR(128) NULL DEFAULT NULL";
+$_SQL[] = "ALTER TABLE {$_TABLES['topics']} CHANGE `parent_id` `parent_id` VARCHAR(128) NOT NULL DEFAULT 'root'";
 $_SQL[] = "ALTER TABLE {$_TABLES['topic_assignments']} CHANGE `tid` `tid` VARCHAR(128) NOT NULL";
 $_SQL[] = "ALTER TABLE {$_TABLES['topic_assignments']} CHANGE `id` `id` VARCHAR(128) NOT NULL";
 $_SQL[] = "ALTER TABLE {$_TABLES['sessions']} CHANGE `topic` `topic` VARCHAR(128) NOT NULL DEFAULT ''";