|
Revision 291, 0.6 kB
(checked in by d0nut, 5 years ago)
|
|
... but allow both to be configured for every group
|
| Line | |
|---|
| 1 | ALTER TABLE `wcf1_group_application` DROP `disableNotification`; |
|---|
| 2 | |
|---|
| 3 | CREATE TABLE IF NOT EXISTS wcf1_group_application_mail ( |
|---|
| 4 | userID int(10) unsigned NOT NULL, |
|---|
| 5 | groupID int(10) unsigned NOT NULL, |
|---|
| 6 | displayNotification tinyint(1) unsigned NOT NULL DEFAULT 0, |
|---|
| 7 | emailNotification tinyint(1) unsigned NOT NULL DEFAULT 0, |
|---|
| 8 | PRIMARY KEY (userID,groupID) |
|---|
| 9 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
|---|
| 10 | |
|---|
| 11 | CREATE TABLE IF NOT EXISTS wcf1_group_application_notification ( |
|---|
| 12 | applicationID int(11) unsigned NOT NULL, |
|---|
| 13 | userID int(10) unsigned NOT NULL, |
|---|
| 14 | PRIMARY KEY (applicationID,userID) |
|---|
| 15 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
|---|
