/*
SQLyog Ultimate v12.4.1 (64 bit)
MySQL - 5.7.14 : Database - charts
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
/*Table structure for table `cost_saving` */

DROP TABLE IF EXISTS `cost_saving`;

CREATE TABLE `cost_saving` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `month_0` double(20,2) DEFAULT NULL,
  `month_1` double(20,2) DEFAULT NULL,
  `month_2` double(20,2) DEFAULT NULL,
  `month_3` double(20,2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

/*Data for the table `cost_saving` */

insert  into `cost_saving`(`id`,`month_0`,`month_1`,`month_2`,`month_3`) values 
(1,0.00,6750.00,13500.00,20250.00);

/*Table structure for table `data` */

DROP TABLE IF EXISTS `data`;

CREATE TABLE `data` (
  `month` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `easipak_sub` double(20,2) DEFAULT NULL,
  `bayer_service` double(20,2) DEFAULT NULL,
  `bayer_ctd` double(20,2) DEFAULT NULL,
  PRIMARY KEY (`month`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `data` */

insert  into `data`(`month`,`easipak_sub`,`bayer_service`,`bayer_ctd`) values 
('2018-01',1250.00,500.00,20409.60),
('2018-02',1250.00,500.00,20409.60),
('2018-03',1250.00,500.00,20409.60),
('2018-04',1250.00,500.00,20409.60),
('2018-05',1250.00,500.00,20409.60),
('2018-06',1250.00,500.00,20409.60),
('2018-07',1250.00,500.00,20409.60),
('2018-08',1250.00,500.00,20409.60),
('2018-09',1250.00,500.00,20409.60);

/*Table structure for table `survey` */

DROP TABLE IF EXISTS `survey`;

CREATE TABLE `survey` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL,
  `q1` tinyint(4) DEFAULT NULL,
  `q3` tinyint(4) DEFAULT NULL,
  `q5` tinyint(4) DEFAULT NULL,
  `q12_1` tinyint(4) DEFAULT NULL,
  `q12_2` tinyint(4) DEFAULT NULL,
  `q12_3` tinyint(4) DEFAULT NULL,
  `q12_4` tinyint(4) DEFAULT NULL,
  `q12_5` tinyint(4) DEFAULT NULL,
  `q12_6` tinyint(4) DEFAULT NULL,
  `q53` tinyint(4) DEFAULT NULL,
  `q65` tinyint(4) DEFAULT NULL,
  `q69_1` tinyint(4) DEFAULT NULL,
  `q69_2` tinyint(4) DEFAULT NULL,
  `q69_3` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `survey` */

insert  into `survey`(`id`,`date`,`q1`,`q3`,`q5`,`q12_1`,`q12_2`,`q12_3`,`q12_4`,`q12_5`,`q12_6`,`q53`,`q65`,`q69_1`,`q69_2`,`q69_3`) values 
(1,'2018-08-07 22:09:08',5,4,4,4,3,2,4,3,4,4,NULL,NULL,NULL,NULL),
(9,'2018-08-07 22:09:08',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,6,46,2,3,4),
(10,'2018-08-07 22:09:08',5,NULL,10,1,5,3,4,5,2,4,NULL,NULL,NULL,NULL),
(11,'2018-08-07 22:09:08',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,45,3,4,2),
(12,'2018-08-07 22:09:08',2,4,2,4,3,4,1,3,4,5,NULL,NULL,NULL,NULL),
(13,'2018-08-07 22:09:08',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,6,47,5,3,5),
(14,'2018-08-14 22:09:08',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,6,40,2,3,4),
(24,'2018-08-07 22:09:08',5,4,NULL,3,4,2,2,5,4,6,NULL,NULL,NULL,NULL);

/*Table structure for table `survey_response` */

DROP TABLE IF EXISTS `survey_response`;

CREATE TABLE `survey_response` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `question` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `min_value` float DEFAULT NULL,
  `max_value` float DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `survey_response` */

insert  into `survey_response`(`id`,`question`,`min_value`,`max_value`) values 
(1,'q1',0,10),
(2,'q3',1,5),
(3,'q12',1,5),
(4,'q65',1,50),
(5,'q69',1,5),
(6,'q53',1,6);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
