|
From: FlorinCB <ory...@us...> - 2009-01-28 10:05:53
|
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; } |