|
From: Bart v. B. <ba...@us...> - 2001-11-23 18:52:50
|
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,
|