summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorPhilip Häusler <msquare@notrademark.de>2013-12-27 18:45:27 +0100
committerPhilip Häusler <msquare@notrademark.de>2013-12-27 18:45:27 +0100
commitc589219a962203ddb2a8b3899f964ca5ae5209ef (patch)
treeee8c01d5a839c4bd15365868851562e5d35e897c /db
parent2c41fcdc0902279fd5c651a7ba08dbe7ba02d94b (diff)
freeloader feature
Diffstat (limited to 'db')
-rw-r--r--db/update.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/db/update.sql b/db/update.sql
index c8079f3a..a67d51aa 100644
--- a/db/update.sql
+++ b/db/update.sql
@@ -1,3 +1,7 @@
+/* freeloader */
+ALTER TABLE `ShiftEntry` ADD `freeloaded` BOOLEAN NOT NULL, ADD INDEX ( `freeloaded` );
+ALTER TABLE `ShiftEntry` ADD `freeload_comment` TEXT NULL DEFAULT NULL;
+
/* password recovery */
ALTER TABLE `User` ADD `password_recovery_token` VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `Passwort` ,
ADD INDEX ( `password_recovery_token` );