 
 LOCK TABLES `status` WRITE;
 
-INSERT INTO `status` (`status_code`, `name`)
+INSERT INTO `status` (`status_code`, `name`, `class`)
 VALUES
-	(100, 'Available'),
-    (200, 'Unavailable'),
-    (300, 'Ordered'),
-    (400, 'In-Stock'),
-    (500, 'Out-of-Stock'),
-    (600, 'Shipped'),
-    (700, 'Scheduled'),
-    (800, 'Confirmed'),
-    (900, 'Active'),
-    (1000, 'Completed'); 
+	(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;
     

    `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,
    PRIMARY KEY         (`availability_id`)
); 


    `customer_id`       int(4) NOT NULL,
    `promotion_id`      int(4),
    `notes`             varchar(255),
    `start_datetime`   datetime NOT NULL,
    `end_datetime`     datetime,
    `repeat`            boolean,
    `staff_id`          int(4),
    `resources`         varchar(255),
    `status_code`       int(4),
    `check_in`          datetime,
    PRIMARY KEY         (`appointment_id`)
); 

