summaryrefslogtreecommitdiff
path: root/db/update.sql
diff options
context:
space:
mode:
authorPhilip Häusler <msquare@notrademark.de>2013-12-28 03:02:51 +0100
committerPhilip Häusler <msquare@notrademark.de>2013-12-28 03:02:51 +0100
commita9fb05b128581b492ff14379e233f026cc618e08 (patch)
tree493898cab05d58969aaeb0d452077033f284d661 /db/update.sql
parentaf47aae69af266398458be904d9d349339f96dba (diff)
force active function
Diffstat (limited to 'db/update.sql')
-rw-r--r--db/update.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/db/update.sql b/db/update.sql
index a67d51aa..407a8539 100644
--- a/db/update.sql
+++ b/db/update.sql
@@ -1,3 +1,6 @@
+/* force active */
+ALTER TABLE `User` ADD `force_active` BOOLEAN NOT NULL AFTER `Aktiv`, ADD INDEX ( `force_active` );
+
/* freeloader */
ALTER TABLE `ShiftEntry` ADD `freeloaded` BOOLEAN NOT NULL, ADD INDEX ( `freeloaded` );
ALTER TABLE `ShiftEntry` ADD `freeload_comment` TEXT NULL DEFAULT NULL;