summaryrefslogtreecommitdiff
path: root/db/update.sql
diff options
context:
space:
mode:
authorPhilip Häusler <msquare@notrademark.de>2015-12-20 11:36:12 +0100
committerPhilip Häusler <msquare@notrademark.de>2015-12-20 11:36:12 +0100
commit0ac05d251c0df5fa09a27b7686acc5690b436f31 (patch)
tree12e39fff0fd2c62a624a8c6ee51af4664d557ade /db/update.sql
parent2cb44fe51752bece6413d3a4745cfba79df21884 (diff)
#198 fixed: driving license feature completed - integrated into angeltypes
Diffstat (limited to 'db/update.sql')
-rw-r--r--db/update.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/db/update.sql b/db/update.sql
index 402812c4..ae9c68d7 100644
--- a/db/update.sql
+++ b/db/update.sql
@@ -11,3 +11,5 @@ CREATE TABLE IF NOT EXISTS `UserDriverLicenses` (
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `UserDriverLicenses`
ADD CONSTRAINT `userdriverlicenses_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `User` (`UID`) ON DELETE CASCADE ON UPDATE CASCADE;
+
+ALTER TABLE `AngelTypes` ADD `requires_driver_license` BOOLEAN NOT NULL;