diff options
author | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-08-22 22:51:12 +0000 |
---|---|---|
committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-08-22 22:51:12 +0000 |
commit | 115c8d4e7039499be57aeee3ba3f75f5431a606f (patch) | |
tree | cc12366b7e00907469dbee67fe658f5ee7fd76ed | |
parent | 28b604b69c4cfcdfdc877d019477082dcebd2b52 (diff) | |
download | forums-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.sql | 10 |
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' |