diff options
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 ; |