From 031fc3057c46245cd62fc39f2d11ee3f0a393e06 Mon Sep 17 00:00:00 2001 From: msquare Date: Tue, 27 Sep 2016 17:49:13 +0200 Subject: rename settings to event config and implement mvc pattern on it --- db/update.sql | 32 -------------------------------- 1 file changed, 32 deletions(-) (limited to 'db/update.sql') diff --git a/db/update.sql b/db/update.sql index ba0227d4..e69de29b 100644 --- a/db/update.sql +++ b/db/update.sql @@ -1,32 +0,0 @@ --- 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; - -ALTER TABLE `AngelTypes` ADD `requires_driver_license` BOOLEAN NOT NULL; - --- --------------------------------------------------------------------------------- --- Settings table -DROP TABLE IF EXISTS `Settings`; -CREATE TABLE IF NOT EXISTS `Settings` ( - `event_name` varchar(255) DEFAULT NULL, - `buildup_start_date` int(11) DEFAULT NULL, - `event_start_date` int(11) DEFAULT NULL, - `event_end_date` int(11) DEFAULT NULL, - `teardown_end_date` int(11) DEFAULT NULL, - `event_welcome_msg` varchar(255) DEFAULT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ; - --- Added privilege for Admin Settings -INSERT INTO `Privileges` (`id`, `name`, `desc`) VALUES (39, 'admin_settings', 'Settings Page for Admin'); - -INSERT INTO `GroupPrivileges` (`id`, `group_id`, `privilege_id`) VALUES (218, -4, 39); -- cgit v1.2.3-70-g09d2