diff options
| -rw-r--r-- | db/update.sql | 9 | ||||
| -rw-r--r-- | includes/model/ShiftTypes_model.php | 18 | ||||
| -rw-r--r-- | public/index.php | 1 |
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'); |