diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-07-16 17:30:36 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-07-16 17:30:36 +0000 |
| commit | 183718f25f049b34a1c339dc63f01c7629c2d313 (patch) | |
| tree | 7ba2b7247e655a46e19c790b00e8034f17a6f5d1 /phpBB/install/schemas/mysql_schema.sql | |
| parent | 7b1c9135e8d897f917e2d23828345f642a3812e4 (diff) | |
| download | forums-183718f25f049b34a1c339dc63f01c7629c2d313.tar forums-183718f25f049b34a1c339dc63f01c7629c2d313.tar.gz forums-183718f25f049b34a1c339dc63f01c7629c2d313.tar.bz2 forums-183718f25f049b34a1c339dc63f01c7629c2d313.tar.xz forums-183718f25f049b34a1c339dc63f01c7629c2d313.zip | |
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
Diffstat (limited to 'phpBB/install/schemas/mysql_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 8 |
1 files changed, 5 insertions, 3 deletions
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, |