Index: groupapplymail/install.sql
===================================================================
--- groupapplymail/install.sql (revision 288)
+++ groupapplymail/install.sql (revision 321)
@@ -1,5 +1,30 @@
-CREATE TABLE IF NOT EXISTS wcf1_groupapplymail (
+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,
-  UNIQUE KEY userID (userID,groupID)
+  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