|
From: Doug K. <dou...@us...> - 2002-01-03 02:27:34
|
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 ----
|