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.
|
