aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorPaul S. Owen <psotfx@users.sourceforge.net>2003-08-22 22:51:12 +0000
committerPaul S. Owen <psotfx@users.sourceforge.net>2003-08-22 22:51:12 +0000
commit115c8d4e7039499be57aeee3ba3f75f5431a606f (patch)
treecc12366b7e00907469dbee67fe658f5ee7fd76ed
parent28b604b69c4cfcdfdc877d019477082dcebd2b52 (diff)
downloadforums-115c8d4e7039499be57aeee3ba3f75f5431a606f.tar
forums-115c8d4e7039499be57aeee3ba3f75f5431a606f.tar.gz
forums-115c8d4e7039499be57aeee3ba3f75f5431a606f.tar.bz2
forums-115c8d4e7039499be57aeee3ba3f75f5431a606f.tar.xz
forums-115c8d4e7039499be57aeee3ba3f75f5431a606f.zip
Dump group moderator table, add field to user_group table
git-svn-id: file:///svn/phpbb/trunk@4419 89ea8834-ac86-4346-8a33-228a782c2dd0
-rw-r--r--phpBB/install/schemas/mysql_schema.sql10
1 files changed, 3 insertions, 7 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index a4d903ec36..0d284a84d6 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -216,12 +216,6 @@ CREATE TABLE phpbb_groups (
PRIMARY KEY (group_id)
);
-# Table: 'phpbb_groups_moderator'
-CREATE TABLE phpbb_groups_moderator (
- group_id mediumint(8) NOT NULL,
- user_id mediumint(8) NOT NULL
-);
-
# Table: 'phpbb_icons'
CREATE TABLE phpbb_icons (
icons_id tinyint(4) UNSIGNED NOT NULL auto_increment,
@@ -634,9 +628,11 @@ CREATE TABLE phpbb_ucp_modules (
CREATE TABLE phpbb_user_group (
group_id mediumint(8) DEFAULT '0' NOT NULL,
user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
+ group_leader tinyint(1) DEFAULT '0' NOT NULL,
user_pending tinyint(1),
KEY group_id (group_id),
- KEY user_id (user_id)
+ KEY user_id (user_id),
+ KEY group_leader (group_leader)
);
# Table: 'phpbb_users'