aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/db
diff options
context:
space:
mode:
authordougk_ff7 <dougk_ff7@users.sourceforge.net>2002-01-03 02:27:31 +0000
committerdougk_ff7 <dougk_ff7@users.sourceforge.net>2002-01-03 02:27:31 +0000
commitf18be0f13550500408412ced93426b9159fb8225 (patch)
tree3e438b7d1c3d9b553582e63ab440cfb321a19f26 /phpBB/db
parent95fd5953714a34030371f0a129a153090ded66e4 (diff)
downloadforums-f18be0f13550500408412ced93426b9159fb8225.tar
forums-f18be0f13550500408412ced93426b9159fb8225.tar.gz
forums-f18be0f13550500408412ced93426b9159fb8225.tar.bz2
forums-f18be0f13550500408412ced93426b9159fb8225.tar.xz
forums-f18be0f13550500408412ced93426b9159fb8225.zip
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! git-svn-id: file:///svn/phpbb/trunk@1779 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db')
-rw-r--r--phpBB/db/schemas/mssql_basic.sql2
-rw-r--r--phpBB/db/schemas/mssql_schema.sql1
-rw-r--r--phpBB/db/schemas/mysql_basic.sql2
-rw-r--r--phpBB/db/schemas/mysql_schema.sql1
-rw-r--r--phpBB/db/schemas/oracle_basic.sql10
-rw-r--r--phpBB/db/schemas/oracle_schema.sql1
-rw-r--r--phpBB/db/schemas/postgres_basic.sql2
-rw-r--r--phpBB/db/schemas/postgres_schema.sql1
8 files changed, 8 insertions, 12 deletions
diff --git a/phpBB/db/schemas/mssql_basic.sql b/phpBB/db/schemas/mssql_basic.sql
index e30d330130..f87d46d4fa 100644
--- a/phpBB/db/schemas/mssql_basic.sql
+++ b/phpBB/db/schemas/mssql_basic.sql
@@ -96,7 +96,7 @@ INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_passw
*/
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, '');
+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;
diff --git a/phpBB/db/schemas/mssql_schema.sql b/phpBB/db/schemas/mssql_schema.sql
index 1e278f6cb3..998e05a76a 100644
--- a/phpBB/db/schemas/mssql_schema.sql
+++ b/phpBB/db/schemas/mssql_schema.sql
@@ -149,7 +149,6 @@ CREATE TABLE [phpbb_ranks] (
[rank_id] [int] IDENTITY (1, 1) NOT NULL ,
[rank_title] [varchar] (50) NOT NULL ,
[rank_min] [int] NULL ,
- [rank_max] [int] NULL ,
[rank_special] [smallint] NULL ,
[rank_image] [varchar] (50) NULL
) ON [PRIMARY]
diff --git a/phpBB/db/schemas/mysql_basic.sql b/phpBB/db/schemas/mysql_basic.sql
index 4e9da5af7e..77550ca3aa 100644
--- a/phpBB/db/schemas/mysql_basic.sql
+++ b/phpBB/db/schemas/mysql_basic.sql
@@ -71,7 +71,7 @@ INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_passw
# -- 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);
+INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES ( 1, 'Site Admin', -1, 1, NULL);
# -- Groups
diff --git a/phpBB/db/schemas/mysql_schema.sql b/phpBB/db/schemas/mysql_schema.sql
index 719f6ce083..5e49ee5426 100644
--- a/phpBB/db/schemas/mysql_schema.sql
+++ b/phpBB/db/schemas/mysql_schema.sql
@@ -231,7 +231,6 @@ CREATE TABLE phpbb_ranks (
rank_id smallint(5) UNSIGNED NOT NULL auto_increment,
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),
PRIMARY KEY (rank_id)
diff --git a/phpBB/db/schemas/oracle_basic.sql b/phpBB/db/schemas/oracle_basic.sql
index bc951a6297..384f60b78f 100644
--- a/phpBB/db/schemas/oracle_basic.sql
+++ b/phpBB/db/schemas/oracle_basic.sql
@@ -70,11 +70,11 @@ INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_passw
-- 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', '');
+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', '');
-- Groups
diff --git a/phpBB/db/schemas/oracle_schema.sql b/phpBB/db/schemas/oracle_schema.sql
index 8f68aab9ca..9894cbaef7 100644
--- a/phpBB/db/schemas/oracle_schema.sql
+++ b/phpBB/db/schemas/oracle_schema.sql
@@ -259,7 +259,6 @@ CREATE TABLE phpbb_ranks (
rank_id number(4) NOT NULL,
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),
CONSTRAINT phpbb_ranks_pkey PRIMARY KEY (rank_id)
diff --git a/phpBB/db/schemas/postgres_basic.sql b/phpBB/db/schemas/postgres_basic.sql
index bcc49cc03b..11d171bc6e 100644
--- a/phpBB/db/schemas/postgres_basic.sql
+++ b/phpBB/db/schemas/postgres_basic.sql
@@ -71,7 +71,7 @@ INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_passw
-- 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);
+INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES ( 1, 'Site Admin', -1, 1, NULL);
-- Groups
diff --git a/phpBB/db/schemas/postgres_schema.sql b/phpBB/db/schemas/postgres_schema.sql
index cea66b3204..6f0b6a61ac 100644
--- a/phpBB/db/schemas/postgres_schema.sql
+++ b/phpBB/db/schemas/postgres_schema.sql
@@ -226,7 +226,6 @@ CREATE TABLE phpbb_ranks (
rank_id int4 DEFAULT nextval('phpbb_ranks_id_seq'::text) NOT NULL,
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),
CONSTRAINT phpbb_ranks_pkey PRIMARY KEY (rank_id)
generated by cgit v1.2.1 (git 2.21.0) at 2025-03-16 06:50:39 +0000