DROP TABLE IF EXISTS wcf1_group_user_option;
CREATE TABLE wcf1_group_user_option (
  userID int(10) unsigned NOT NULL,
  groupID int(10) unsigned NOT NULL,
  displayNotification tinyint(1) unsigned NOT NULL DEFAULT 0,
  emailNotification tinyint(1) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (userID,groupID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS wcf1_group_user_notification;
CREATE TABLE wcf1_group_user_notification (
  userID int(10) unsigned NOT NULL,
  groupID int(10) unsigned NOT NULL,
  foreignID int(10) unsigned NOT NULL,
  messageType tinyint(3) unsigned NOT NULL,
  slot1 varchar(255), --username
  slot2 varchar(255), --groupleader
  slot3 varchar(255),
  slot4 varchar(255),
  slot5 varchar(255),
  PRIMARY KEY (userID, groupID, foreignID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- messageType 
--		5 = join
--		51 = {$groupleader} wird die Bearbeitung des Benutzers {$username} übernehmen
--		52 = {$groupleader} hat {$username} abgelehnt
--		53 = {$groupleader} hat {$username} akzeptiert
--		6 = application
--		7 = zurücknehmen