summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPhilip Häusler <msquare@notrademark.de>2014-12-16 08:43:41 +0100
committerPhilip Häusler <msquare@notrademark.de>2014-12-17 14:59:40 +0100
commit25889920cf216e46873da968afe4b2dae5fead64 (patch)
tree1c167ecd40a860cc1db93b1daa296af582ed7f58
parent8a51e5d822ce4276e266fefa62c8973344609471 (diff)
prepare for shift types model, add db update
-rw-r--r--db/update.sql9
-rw-r--r--includes/model/ShiftTypes_model.php18
-rw-r--r--public/index.php1
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');