     `column_name`       varchar(35) NOT NULL,
     `previous_value`    varchar(255) NOT NULL,
     `current_value`     varchar(255) NOT NULL,
-    `change_timestamp`  timestamp DEFAULT current_timestamp,
+    `change_datetime`  datetime DEFAULT current_datetime,
     `is_undone`         boolean DEFAULT false,
     PRIMARY KEY         (`change_id`)
 ); 
+
+CREATE TABLE `inventory_count` (
+  `count_date`             date NOT NULL DEFAULT current_date,
+  `open_count_datetime`    datetime DEFAULT current_datetime,
+  `close_count_datetime`   datetime,
+  `open_count_data`        mediumtext DEFAULT 
+    '{"open_count":[
+        {"product_id: ""},
+        {"quantity" : ""}
+    ]',
+  `close_count_data`       mediumtext DEFAULT
+     '{"close_count":[
+        {"product_id: ""},
+        {"quantity" : ""}
+    ]',
+  `is_erroneous`           boolean DEFAULT false,
+    PRIMARY KEY            (`count_date`)
+);
 
 CREATE TABLE `example_phpmvc` (
   `group_id`        int(11) unsigned NOT NULL AUTO_INCREMENT,


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'),


LOCK TABLES `status` WRITE;

INSERT INTO `status` (`status_code`, `name`, `class`)
VALUES
	(100, 'Available', ''),
    (200, 'Unavailable','warning'),
    (300, 'Ordered', 'info'),
    (400, 'In-Stock', ''),
    (500, 'Out-of-Stock','danger'),
    (600, 'Shipped','success'),
    (700, 'Scheduled','info'),
    (800, 'Confirmed','success'),
    (900, 'Active',''),
    (1000, 'Completed',''); 
    
LOCK TABLES `add_on_service` WRITE;
    
