From 183718f25f049b34a1c339dc63f01c7629c2d313 Mon Sep 17 00:00:00 2001 From: "Paul S. Owen" 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