available app timeslots

CREATE TABLE `avail_apps` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date_av` date NOT NULL,
  `time_av` time DEFAULT NULL,
  PRIMARY KEY (`id`,`date_av`)
) ENGINE=InnoDB AUTO_INCREMENT=7135 DEFAULT CHARSET=utf8


CREATE TABLE `store_open` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `b_user_ID` mediumint(11) unsigned DEFAULT NULL,//service provider ID...foreign key
  `open_time` time DEFAULT NULL,//morning session open
  `close_time` time DEFAULT NULL,
  `open_time_b` time DEFAULT NULL,//evening session open
  `close_time_b` time DEFAULT NULL,
  `day` varchar(12) DEFAULT NULL,//weekdays
  `model_ID` int(11) DEFAULT NULL,//backbone model
  PRIMARY KEY (`id`),
  KEY `b_user_ID` (`b_user_ID`),
  CONSTRAINT `busers_reference` FOREIGN KEY (`b_user_ID`) REFERENCES `business_users` (`crID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8