prepare for shift types model, add db update

3 files changed, 28 insertions, 0 deletions

diff --git a/db/update.sql b/db/update.sql
index 7caf7223..d7d91a80 100644
--- a/db/update.sql
+++ b/db/update.sql
@@ -1,3 +1,12 @@
+/* introduce shift types */
+CREATE TABLE IF NOT EXISTS `ShiftTypes` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `name` varchar(255) NOT NULL,
+  `angeltype_id` int(11) DEFAULT NULL,
+  `description` text NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
 /* cleanup */
 ALTER TABLE `User` DROP `ICQ` ;
 
diff --git a/includes/model/ShiftTypes_model.php b/includes/model/ShiftTypes_model.php
new file mode 100644
index 00000000..4c71a3ed
--- /dev/null
+++ b/includes/model/ShiftTypes_model.php
@@ -0,0 +1,18 @@
+<?php
+
+function ShiftType_delete($shifttype_id) {
+}
+
+function ShiftType_update($shifttype_id, $name, $angeltype_id, $description) {
+}
+
+function ShiftType_create($name, $angeltype_id, $description) {
+}
+
+function ShiftType($shifttype_id) {
+}
+
+function ShiftTypes() {
+}
+
+?>
\ No newline at end of file
diff --git a/public/index.php b/public/index.php
index 5c673f0a..54ea1090 100644
--- a/public/index.php
+++ b/public/index.php
@@ -15,6 +15,7 @@ require_once realpath(__DIR__ . '/../includes/model/NeededAngelTypes_model.php')
 require_once realpath(__DIR__ . '/../includes/model/Room_model.php');
 require_once realpath(__DIR__ . '/../includes/model/ShiftEntry_model.php');
 require_once realpath(__DIR__ . '/../includes/model/Shifts_model.php');
+require_once realpath(__DIR__ . '/../includes/model/ShiftTypes_model.php');
 require_once realpath(__DIR__ . '/../includes/model/UserAngelTypes_model.php');
 require_once realpath(__DIR__ . '/../includes/model/UserGroups_model.php');
 require_once realpath(__DIR__ . '/../includes/model/User_model.php');