diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/update.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/db/update.sql b/db/update.sql index e69de29b..402812c4 100644 --- a/db/update.sql +++ b/db/update.sql @@ -0,0 +1,13 @@ +-- drivers license information +CREATE TABLE IF NOT EXISTS `UserDriverLicenses` ( + `user_id` int(11) NOT NULL, + `has_car` tinyint(1) NOT NULL, + `has_license_car` tinyint(1) NOT NULL, + `has_license_3_5t_transporter` tinyint(1) NOT NULL, + `has_license_7_5t_truck` tinyint(1) NOT NULL, + `has_license_12_5t_truck` tinyint(1) NOT NULL, + `has_license_forklift` tinyint(1) NOT NULL, + PRIMARY KEY (`user_id`) +) 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; |