diff options
| author | Felix Favre <gnomus@gnomus.de> | 2014-12-06 19:02:26 +0100 |
|---|---|---|
| committer | Felix Favre <gnomus@gnomus.de> | 2014-12-06 19:02:26 +0100 |
| commit | 2f445eb90c6267a9f1055d1536838d9b3fe12f3b (patch) | |
| tree | e954579afcbd6399fc8e17a4b5354f19e046e00f /db/update.sql | |
| parent | 3973236f6e4cb76a20fca3b908afd526f293a850 (diff) | |
| parent | 10d7fce163ff28da68b036bd4fae95040fd170a9 (diff) | |
Merge branch 'master' of github.com:engelsystem/engelsystem
Diffstat (limited to 'db/update.sql')
| -rw-r--r-- | db/update.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/db/update.sql b/db/update.sql index 9862c027..7caf7223 100644 --- a/db/update.sql +++ b/db/update.sql @@ -1,3 +1,9 @@ +/* cleanup */ +ALTER TABLE `User` DROP `ICQ` ; + +/* opt-in field for user shiftinfo mails */ +ALTER TABLE `User` ADD `email_shiftinfo` BOOLEAN NOT NULL DEFAULT FALSE COMMENT 'User wants to be informed by mail about changes in his shifts' AFTER `email` ; + /* fix questions */ ALTER TABLE `Questions` CHANGE `AID` `AID` INT( 11 ) NULL DEFAULT NULL ; |