| 1 | DROP TABLE IF EXISTS wcf1_group_user_option; |
|---|
| 2 | CREATE TABLE wcf1_group_user_option ( |
|---|
| 3 | userID int(10) unsigned NOT NULL, |
|---|
| 4 | groupID int(10) unsigned NOT NULL, |
|---|
| 5 | displayNotification tinyint(1) unsigned NOT NULL DEFAULT 0, |
|---|
| 6 | emailNotification tinyint(1) unsigned NOT NULL DEFAULT 0, |
|---|
| 7 | PRIMARY KEY (userID,groupID) |
|---|
| 8 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
|---|
| 9 | |
|---|
| 10 | DROP TABLE IF EXISTS wcf1_group_user_notification; |
|---|
| 11 | CREATE TABLE wcf1_group_user_notification ( |
|---|
| 12 | userID int(10) unsigned NOT NULL, |
|---|
| 13 | groupID int(10) unsigned NOT NULL, |
|---|
| 14 | foreignID int(10) unsigned NOT NULL, |
|---|
| 15 | messageType tinyint(3) unsigned NOT NULL, |
|---|
| 16 | slot1 varchar(255), --username |
|---|
| 17 | slot2 varchar(255), --groupleader |
|---|
| 18 | slot3 varchar(255), |
|---|
| 19 | slot4 varchar(255), |
|---|
| 20 | slot5 varchar(255), |
|---|
| 21 | PRIMARY KEY (userID, groupID, foreignID) |
|---|
| 22 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
|---|
| 23 | |
|---|
| 24 | -- messageType |
|---|
| 25 | -- 5 = join |
|---|
| 26 | -- 51 = {$groupleader} wird die Bearbeitung des Benutzers {$username} ÃŒbernehmen |
|---|
| 27 | -- 52 = {$groupleader} hat {$username} abgelehnt |
|---|
| 28 | -- 53 = {$groupleader} hat {$username} akzeptiert |
|---|
| 29 | -- 6 = application |
|---|
| 30 | -- 7 = zurÃŒcknehmen |
|---|
