From 183718f25f049b34a1c339dc63f01c7629c2d313 Mon Sep 17 00:00:00 2001
From: "Paul S. Owen" <psotfx@users.sourceforge.net>
Date: Tue, 16 Jul 2002 17:30:36 +0000
Subject: This will do a clean install ... it will fail if config isn't
 writeable or any other error occurs ...

git-svn-id: file:///svn/phpbb/trunk@2698 89ea8834-ac86-4346-8a33-228a782c2dd0
---
 phpBB/install/schemas/mysql_schema.sql | 8 +++++---
 1 file changed, 5 insertions(+), 3 deletions(-)

(limited to 'phpBB/install/schemas/mysql_schema.sql')

diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index 04c28e0da4..5276a06e67 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -48,10 +48,10 @@ CREATE TABLE phpbb_auth_options (
 # Table structure for table `phpbb_auth_prefetch`
 #
 CREATE TABLE phpbb_auth_prefetch (
-  user_id mediumint(8) unsigned NOT NULL default '0',
+  user_id mediumint(8)  NOT NULL default '0',
   forum_id mediumint(8) unsigned NOT NULL default '0',
   auth_option_id smallint(5) unsigned NOT NULL default '0',
-  auth_allow_deny tinyint(4) NOT NULL default '1')
+  auth_allow_deny tinyint(4) NOT NULL default '1'
 );
 
 
@@ -60,7 +60,7 @@ CREATE TABLE phpbb_auth_prefetch (
 # Table structure for table `phpbb_auth_users`
 #
 CREATE TABLE phpbb_auth_users (
-  user_id mediumint(8) unsigned NOT NULL default '0',
+  user_id mediumint(8)  NOT NULL default '0',
   forum_id mediumint(8) unsigned NOT NULL default '0',
   auth_option_id smallint(5) unsigned NOT NULL default '0',
   auth_allow_deny tinyint(4) NOT NULL default '1'
@@ -134,6 +134,8 @@ CREATE TABLE phpbb_disallow (
 #
 CREATE TABLE phpbb_forums (
    forum_id smallint(5) UNSIGNED NOT NULL,
+   cat_id smallint(5) UNSIGNED NOT NULL, 
+
    parent_id smallint(5) UNSIGNED NOT NULL, 
    forum_order smallint(5) UNSIGNED DEFAULT '1' NOT NULL, 
 
-- 
cgit v1.2.1

