|
Revision 299, 0.6 kB
(checked in by d0nut, 5 years ago)
|
|
bugfixes
|
| Line | |
|---|
| 1 | DROP TABLE IF EXISTS wcf1_group_application_mail; |
|---|
| 2 | CREATE TABLE wcf1_group_application_mail ( |
|---|
| 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_application_notification; |
|---|
| 11 | CREATE TABLE 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; |
|---|
