[Phpbbkb-checkins] SF.net SVN: phpbbkb: [11] root/install/kb_install.php

[<mar...@us...>]

Revision: 11
          http://svn.sourceforge.net/phpbbkb/?rev=11&view=rev
Author:   markthedaemon
Date:     2006-10-15 11:36:21 -0700 (Sun, 15 Oct 2006)

Log Message:
-----------
Small commit outlining the start of the db schema; please note that this is almost guarenteed to change.

Developers: Report what you think of this in the dev forum, and change it if you wish.

Modified Paths:
--------------
    root/install/kb_install.php

Modified: root/install/kb_install.php
===================================================================
--- root/install/kb_install.php	2006-10-14 03:07:40 UTC (rev 10)
+++ root/install/kb_install.php	2006-10-15 18:36:21 UTC (rev 11)
@@ -36,7 +36,7 @@
 if( !$userdata['session_logged_in'] )
 {
 	$header_location = ( @preg_match('/Microsoft|WebSTAR|Xitami/', getenv('SERVER_SOFTWARE')) ) ? 'Refresh: 0; URL=' : 'Location: ';
-	header($header_location . append_sid("login.$phpEx?redirect=phpbb_sql_generator.$phpEx", true));
+	header($header_location . append_sid("login.$phpEx?redirect=kb_install.$phpEx", true));
 	exit;
 }
 
@@ -54,7 +54,13 @@
 
 
 $sql = array();
-$sql[] = "ALTER TABLE " . $table_prefix . "forums ADD cat_kb tinyint(1) unsigned default 0";
+$sql[] = "CREATE TABLE " . $table_prefix . "kb_categories (
+   cat_id mediumint(8) UNSIGNED NOT NULL auto_increment,
+   cat_title varchar(100),
+   cat_order mediumint(8) UNSIGNED NOT NULL,
+   PRIMARY KEY (cat_id),
+   KEY cat_order (cat_order)
+)";
 
 for( $i = 0; $i < count($sql); $i++ )
 {


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.