From 031fc3057c46245cd62fc39f2d11ee3f0a393e06 Mon Sep 17 00:00:00 2001
From: msquare <msquare@notrademark.de>
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

