     `staff_id`          int(4),
     `resource_id`       int(4),
     `service_id`        int(4),
-    `monday_start`      timestamp NOT NULL,
-    `tuesday_start`     timestamp NOT NULL,
-    `wedday_start`      timestamp NOT NULL,
-    `thursday_start`    timestamp NOT NULL,
-    `friday_start`      timestamp NOT NULL,
-    `saturday_start`    timestamp NOT NULL,
-    `sunday_start`      timestamp NOT NULL,
-    `monday_end`        timestamp NOT NULL,
-    `tuesday_end`       timestamp NOT NULL,
-    `wedday_end`        timestamp NOT NULL,
-    `thursday_end`      timestamp NOT NULL,
-    `friday_end`        timestamp NOT NULL,
-    `saturday_end`      timestamp NOT NULL,
-    `sunday_end`        timestamp NOT NULL,
+    `monday_start`      datetime NOT NULL,
+    `tuesday_start`     datetime NOT NULL,
+    `wedday_start`      datetime NOT NULL,
+    `thursday_start`    datetime NOT NULL,
+    `friday_start`      datetime NOT NULL,
+    `saturday_start`    datetime NOT NULL,
+    `sunday_start`      datetime NOT NULL,
+    `monday_end`        datetime NOT NULL,
+    `tuesday_end`       datetime NOT NULL,
+    `wedday_end`        datetime NOT NULL,
+    `thursday_end`      datetime NOT NULL,
+    `friday_end`        datetime NOT NULL,
+    `saturday_end`      datetime NOT NULL,
+    `sunday_end`        datetime NOT NULL,
     PRIMARY KEY         (`availability_id`)
 ); 
 


LOCK TABLES `appointment` WRITE;

INSERT INTO `appointment` (`service_id`, `customer_id`, `staff_id`, `status_code`, `start_timestamp`)
VALUES
	(1000, 107, 1235, 700, '2016-03-21 08:30'),
    (2010, 282, 2182, 800, '2016-03-18 15:45'),


CREATE TABLE `shift` (
    `shift_id`      int(4) NOT NULL AUTO_INCREMENT,
    `shift_start`   datetime NOT NULL,
    `shift_end`     datetime,
    `staff_id`      int(4),
    PRIMARY KEY     (`shift_id`)
); 
