[mxbb-commits] phpbb2mxp/install update_to_latest.php,1.2,1.3

[FlorinCB <ory...@us...>]

Update of /cvsroot/mxbb/phpbb2mxp/install
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv29478

Modified Files:
	update_to_latest.php 
Log Message:
.0.24 simple subforums column

Index: update_to_latest.php
===================================================================
RCS file: /cvsroot/mxbb/phpbb2mxp/install/update_to_latest.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** update_to_latest.php	24 Jan 2009 05:09:55 -0000	1.2
--- update_to_latest.php	28 Jan 2009 10:05:42 -0000	1.3
***************
*** 61,65 ****
  //
  //
! $updates_to_version = '.0.23';
  //
  //
--- 61,65 ----
  //
  //
! $updates_to_version = '.0.24';
  //
  //
***************
*** 683,686 ****
--- 683,719 ----
  
  		break;
+ 
+ 	case '.0.24':
+ 
+ 		// Add search time to the search table
+ 		switch (SQL_LAYER)
+ 		{
+ 			case 'mysql':
+ 			case 'mysql4':
+ 			case 'mysqli':			
+ 				$sql[] = "ALTER TABLE " . FORUMS_TABLE . "
+ 					ADD COLUMN forum_parent int(11) DEFAULT '0' NOT NULL";
+ 				break;
+ 
+ 			case 'postgresql':
+ 				$sql[] = "ALTER TABLE " . FORUMS_TABLE. "
+ 					ADD COLUMN forum_parent int4";
+ 				$sql[] = "ALTER TABLE " . FORUMS_TABLE . "
+ 					ALTER COLUMN forum_parent SET DEFAULT '0'";
+ 				break;
+ 
+ 			case 'mssql-odbc':
+ 			case 'mssql':
+ 				$sql[] = "ALTER TABLE " . FORUMS_TABLE . " ADD
+ 					forum_parent int NOT NULL";
+ 				break;
+ 
+ 			case 'msaccess':
+ 				$sql[] = "ALTER TABLE " . FORUMS_TABLE . " ADD
+ 					forum_parent int NOT NULL";
+ 				break;
+ 		}
+ 
+ 		break;		
  }