[Phpbb-checkins] CVS: phpBB2/db/schemas mysql_schema.sql,1.2,1.3

[Bart v. B. <ba...@us...>]

Update of /cvsroot/phpbb/phpBB2/db/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv3154

Modified Files:
	mysql_schema.sql 
Log Message:
Oops, smallint is too small for group_id.. Thanks Paul :D

Index: mysql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mysql_schema.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -r1.2 -r1.3
*** mysql_schema.sql	2001/11/23 18:44:11	1.2
--- mysql_schema.sql	2001/11/23 18:52:46	1.3
***************
*** 10,14 ****
  DROP TABLE IF EXISTS phpbb_auth_access;
  CREATE TABLE phpbb_auth_access (
!    group_id smallint(5) DEFAULT '0' NOT NULL,
     forum_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
     auth_view tinyint(1) DEFAULT '0' NOT NULL,
--- 10,14 ----
  DROP TABLE IF EXISTS phpbb_auth_access;
  CREATE TABLE phpbb_auth_access (
!    group_id mediumint(8) DEFAULT '0' NOT NULL,
     forum_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
     auth_view tinyint(1) DEFAULT '0' NOT NULL,
***************
*** 34,38 ****
  DROP TABLE IF EXISTS phpbb_user_group;
  CREATE TABLE phpbb_user_group (
!    group_id smallint(5) DEFAULT '0' NOT NULL,
     user_id mediumint(8) DEFAULT '0' NOT NULL,
     user_pending tinyint(1), 
--- 34,38 ----
  DROP TABLE IF EXISTS phpbb_user_group;
  CREATE TABLE phpbb_user_group (
!    group_id mediumint(8) DEFAULT '0' NOT NULL,
     user_id mediumint(8) DEFAULT '0' NOT NULL,
     user_pending tinyint(1), 
***************
*** 46,50 ****
  DROP TABLE IF EXISTS phpbb_groups;
  CREATE TABLE phpbb_groups (
!    group_id smallint(5) NOT NULL auto_increment,
     group_type tinyint(4) DEFAULT '1' NOT NULL, 
     group_name varchar(40) NOT NULL,
--- 46,50 ----
  DROP TABLE IF EXISTS phpbb_groups;
  CREATE TABLE phpbb_groups (
!    group_id mediumint(8) NOT NULL auto_increment,
     group_type tinyint(4) DEFAULT '1' NOT NULL, 
     group_name varchar(40) NOT NULL,