[Phpbb-checkins] CVS: phpBB2/db/schemas mssql_basic.sql,1.6,1.7 mssql_schema.sql,1.16,1.17 mysql_basic.sql,1.7,1.8 mysql_schema.sql,1.11,1.12 oracle_basic.sql,1.1,1.2 oracle_schema.sql,1.3,1.4 postgres_basic.sql,1.7,1.8 postgres_schema.sql,1.13,1.14

[Doug K. <dou...@us...>]

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

Modified Files:
	mssql_basic.sql mssql_schema.sql mysql_basic.sql 
	mysql_schema.sql oracle_basic.sql oracle_schema.sql 
	postgres_basic.sql postgres_schema.sql 
Log Message:
Fixes bug 498620, among others.  A problem with a rank_max value still hanging around in SQL statements.  It was still created by all the schema files, so I changed it there, too.  If I end up creating more problems, I'll revert them to the old values... Actually, I think I'd better. Anyway, don't even ask why I updated Oracle.  I felt like it, plus we may use it someday...
That's it for now! One bug fix... yeah!


Index: mssql_basic.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mssql_basic.sql,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -r1.6 -r1.7
*** mssql_basic.sql	2001/12/16 20:31:12	1.6
--- mssql_basic.sql	2002/01/03 02:27:31	1.7
***************
*** 97,101 ****
  SET IDENTITY_INSERT phpbb_ranks ON;
  
! INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_max, rank_special, rank_image) VALUES (1, 'Site Admin', -1, -1, 1, '');
  
  SET IDENTITY_INSERT phpbb_ranks OFF;
--- 97,101 ----
  SET IDENTITY_INSERT phpbb_ranks ON;
  
! INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES (1, 'Site Admin', -1, 1, '');
  
  SET IDENTITY_INSERT phpbb_ranks OFF;

Index: mssql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mssql_schema.sql,v
retrieving revision 1.16
retrieving revision 1.17
diff -C2 -r1.16 -r1.17
*** mssql_schema.sql	2001/12/20 00:45:41	1.16
--- mssql_schema.sql	2002/01/03 02:27:31	1.17
***************
*** 150,154 ****
  	[rank_title] [varchar] (50) NOT NULL ,
  	[rank_min] [int] NULL ,
- 	[rank_max] [int] NULL ,
  	[rank_special] [smallint] NULL ,
  	[rank_image] [varchar] (50) NULL 
--- 150,153 ----

Index: mysql_basic.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mysql_basic.sql,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -r1.7 -r1.8
*** mysql_basic.sql	2001/12/16 20:31:12	1.7
--- mysql_basic.sql	2002/01/03 02:27:31	1.8
***************
*** 72,76 ****
  
  # -- Ranks
! INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_max, rank_special, rank_image) VALUES ( 1, 'Site Admin', -1, -1, 1, NULL);
  
  
--- 72,76 ----
  
  # -- Ranks
! INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES ( 1, 'Site Admin', -1, 1, NULL);
  
  

Index: mysql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mysql_schema.sql,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -r1.11 -r1.12
*** mysql_schema.sql	2001/12/20 00:45:41	1.11
--- mysql_schema.sql	2002/01/03 02:27:31	1.12
***************
*** 232,236 ****
     rank_title varchar(50) NOT NULL,
     rank_min mediumint(8) DEFAULT '0' NOT NULL,
-    rank_max mediumint(8) DEFAULT '0' NOT NULL,
     rank_special tinyint(1) DEFAULT '0',
     rank_image varchar(255),
--- 232,235 ----

Index: oracle_basic.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/oracle_basic.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** oracle_basic.sql	2001/11/20 22:28:41	1.1
--- oracle_basic.sql	2002/01/03 02:27:31	1.2
***************
*** 71,79 ****
  
  -- Ranks
! INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_max, rank_special, rank_image) VALUES ( '1', 'Site Admin', '-1', '-1', '1', '');
! INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_max, rank_special, rank_image) VALUES ( '2', 'Newbie', '0', '9', '0', '');
! INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_max, rank_special, rank_image) VALUES ( '5', 'Here Often', '10', '49', '0', '');
! INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_max, rank_special, rank_image) VALUES ( '6', 'Should Get Out More', '50', '199', '0', '');
! INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_max, rank_special, rank_image) VALUES ( '7', 'Has No Life', '200', '9999', '0', '');
  
  
--- 71,79 ----
  
  -- Ranks
! INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES ( '1', 'Site Admin', '-1', '1', '');
! INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES ( '2', 'Newbie', '0', '0', '');
! INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES ( '5', 'Here Often', '10', '0', '');
! INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES ( '6', 'Should Get Out More', '50', '0', '');
! INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES ( '7', 'Has No Life', '200', '0', '');
  
  

Index: oracle_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/oracle_schema.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -r1.3 -r1.4
*** oracle_schema.sql	2001/12/10 21:53:27	1.3
--- oracle_schema.sql	2002/01/03 02:27:31	1.4
***************
*** 260,264 ****
     rank_title varchar(50) DEFAULT '' NOT NULL,
     rank_min number(4) DEFAULT '0' NOT NULL,
-    rank_max number(4) DEFAULT '0' NOT NULL,
     rank_special number(4) DEFAULT '0',
     rank_image varchar(255),
--- 260,263 ----

Index: postgres_basic.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/postgres_basic.sql,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -r1.7 -r1.8
*** postgres_basic.sql	2001/12/16 20:31:12	1.7
--- postgres_basic.sql	2002/01/03 02:27:31	1.8
***************
*** 72,76 ****
  
  -- Ranks
! INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_max, rank_special, rank_image) VALUES ( 1, 'Site Admin', -1, -1, 1, NULL);
  
  
--- 72,76 ----
  
  -- Ranks
! INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES ( 1, 'Site Admin', -1, 1, NULL);
  
  

Index: postgres_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/postgres_schema.sql,v
retrieving revision 1.13
retrieving revision 1.14
diff -C2 -r1.13 -r1.14
*** postgres_schema.sql	2001/12/20 00:45:41	1.13
--- postgres_schema.sql	2002/01/03 02:27:31	1.14
***************
*** 227,231 ****
     rank_title varchar(50) DEFAULT '' NOT NULL,
     rank_min int4 DEFAULT '0' NOT NULL,
-    rank_max int4 DEFAULT '0' NOT NULL,
     rank_special int2 DEFAULT '0',
     rank_image varchar(255),
--- 227,230 ----