SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
DROP TABLE IF EXISTS `gantt_links`;
CREATE TABLE `gantt_links` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`source` int(11) NOT NULL,
`target` int(11) NOT NULL,
`type` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
INSERT INTO `gantt_links` VALUES ('1', '1', '2', '0');
INSERT INTO `gantt_links` VALUES ('2', '1', '3', '0');
INSERT INTO `gantt_links` VALUES ('3', '1', '4', '0');
INSERT INTO `gantt_links` VALUES ('4', '2', '6', '0');
DROP TABLE IF EXISTS `gantt_tasks`;
CREATE TABLE `gantt_tasks` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` varchar(255) NOT NULL,
`start_date` datetime NOT NULL,
`duration` int(11) NOT NULL,
`progress` float NOT NULL,
`sortorder` double NOT NULL DEFAULT '0',
`parent` int(11) NOT NULL,
`deadline` datetime NULL DEFAULT NULL,
`planned_start` datetime NULL DEFAULT NULL,
`planned_end` datetime NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;
INSERT INTO `gantt_tasks` (`id`, `text`, `start_date`, `duration`, `progress`, `sortorder`, `parent`, `deadline`, `planned_start`, `planned_end`) VALUES(1, 'Project #1', '2018-04-01 00:00:00', 5, 0.8, 20, 0, '2018-04-09 00:00:00', '2018-04-01 00:00:00', '2018-04-07 00:00:00');
INSERT INTO `gantt_tasks` (`id`, `text`, `start_date`, `duration`, `progress`, `sortorder`, `parent`, `deadline`, `planned_start`, `planned_end`) VALUES(2, 'Task #1', '2018-04-06 00:00:00', 4, 0.5, 10, 1, '2018-04-11 00:00:00', '2018-04-06 00:00:00', '2018-04-10 00:00:00');
INSERT INTO `gantt_tasks` (`id`, `text`, `start_date`, `duration`, `progress`, `sortorder`, `parent`, `deadline`, `planned_start`, `planned_end`) VALUES(3, 'Task #2', '2018-04-05 00:00:00', 6, 0.7, 20, 1, '2018-04-10 00:00:00', '2018-04-05 00:00:00', '2018-04-14 00:00:00');
INSERT INTO `gantt_tasks` (`id`, `text`, `start_date`, `duration`, `progress`, `sortorder`, `parent`, `deadline`, `planned_start`, `planned_end`) VALUES(4, 'Task #3', '2018-04-07 00:00:00', 2, 0, 30, 1, '2018-04-17 00:00:00', '2018-04-03 00:00:00', '2018-04-05 00:00:00');
INSERT INTO `gantt_tasks` (`id`, `text`, `start_date`, `duration`, `progress`, `sortorder`, `parent`, `deadline`, `planned_start`, `planned_end`) VALUES(5, 'Task #1.1', '2018-04-05 00:00:00', 5, 0.34, 10, 2, '2018-04-10 00:00:00', '2018-04-03 00:00:00', '2018-04-08 00:00:00');
INSERT INTO `gantt_tasks` (`id`, `text`, `start_date`, `duration`, `progress`, `sortorder`, `parent`, `deadline`, `planned_start`, `planned_end`) VALUES(6, 'Task #1.2', '2018-04-11 00:00:00', 4, 0.491477, 20, 2, '2018-04-15 00:00:00', '2018-04-11 00:00:00', '2018-04-16 00:00:00');
INSERT INTO `gantt_tasks` (`id`, `text`, `start_date`, `duration`, `progress`, `sortorder`, `parent`, `deadline`, `planned_start`, `planned_end`) VALUES(7, 'Task #2.1', '2018-04-07 00:00:00', 5, 0.2, 10, 3, '2018-04-11 00:00:00', '2018-04-07 00:00:00', '2018-04-12 00:00:00');
INSERT INTO `gantt_tasks` (`id`, `text`, `start_date`, `duration`, `progress`, `sortorder`, `parent`, `deadline`, `planned_start`, `planned_end`) VALUES(8, 'Task #2.2', '2018-04-06 00:00:00', 4, 0.9, 20, 3, '2018-04-16 00:00:00', '2018-04-06 00:00:00', '2018-04-10 00:00:00');
INSERT INTO `gantt_tasks` (`id`, `text`, `start_date`, `duration`, `progress`, `sortorder`, `parent`, `deadline`, `planned_start`, `planned_end`) VALUES(9, 'Task #3.1', '2018-04-06 00:00:00', 5, 1, 10, 4, '2018-04-16 00:00:00', '2018-04-06 00:00:00', '2018-04-11 00:00:00');
INSERT INTO `gantt_tasks` (`id`, `text`, `start_date`, `duration`, `progress`, `sortorder`, `parent`, `deadline`, `planned_start`, `planned_end`) VALUES(10, 'Task #3.2', '2018-04-06 00:00:00', 3, 0, 20, 4, '2018-04-11 00:00:00', '2018-04-05 00:00:00', '2018-04-08 00:00:00');
INSERT INTO `gantt_tasks` (`id`, `text`, `start_date`, `duration`, `progress`, `sortorder`, `parent`, `deadline`, `planned_start`, `planned_end`) VALUES(11, 'Task #3.3', '2018-04-06 00:00:00', 4, 0.33, 30, 4, '2018-04-10 00:00:00', '2018-04-07 00:00:00', '2018-04-11 00:00:00');
INSERT INTO `gantt_tasks` (`id`, `text`, `start_date`, `duration`, `progress`, `sortorder`, `parent`, `deadline`, `planned_start`, `planned_end`) VALUES(12, 'Project #2', '2018-04-02 00:00:00', 18, 0, 10, 0, '2018-04-04 00:00:00', '2018-04-02 00:00:00', '2018-04-20 00:00:00');
INSERT INTO `gantt_tasks` (`id`, `text`, `start_date`, `duration`, `progress`, `sortorder`, `parent`, `deadline`, `planned_start`, `planned_end`) VALUES(13, 'Task #1', '2018-04-02 00:00:00', 10, 0.2, 15, 12, '2018-04-09 00:00:00', '2018-04-02 00:00:00', '2018-04-12 00:00:00');
INSERT INTO `gantt_tasks` (`id`, `text`, `start_date`, `duration`, `progress`, `sortorder`, `parent`, `deadline`, `planned_start`, `planned_end`) VALUES(14, 'Task #2', '2018-04-04 00:00:00', 4, 0.9, 20, 12, '2018-04-09 00:00:00', '2018-04-04 00:00:00', '2018-04-08 00:00:00');
INSERT INTO `gantt_tasks` (`id`, `text`, `start_date`, `duration`, `progress`, `sortorder`, `parent`, `deadline`, `planned_start`, `planned_end`) VALUES(15, 'Task #3', '2018-04-05 00:00:00', 3, 0.6, 30, 12, '2018-04-09 00:00:00', '2018-04-05 00:00:00', '2018-04-08 00:00:00');
INSERT INTO `gantt_tasks` (`id`, `text`, `start_date`, `duration`, `progress`, `sortorder`, `parent`, `deadline`, `planned_start`, `planned_end`) VALUES(16, 'Task #4', '2018-04-01 00:00:00', 3, 0.214286, 40, 12, '2018-04-05 00:00:00', '2018-04-01 00:00:00', '2018-04-04 00:00:00');
INSERT INTO `gantt_tasks` (`id`, `text`, `start_date`, `duration`, `progress`, `sortorder`, `parent`, `deadline`, `planned_start`, `planned_end`) VALUES(17, 'Task #5', '2018-04-06 00:00:00', 6, 0.5, 50, 12, '2018-04-12 00:00:00', '2018-04-06 00:00:00', '2018-04-12 00:00:00');
INSERT INTO `gantt_tasks` (`id`, `text`, `start_date`, `duration`, `progress`, `sortorder`, `parent`, `deadline`, `planned_start`, `planned_end`) VALUES(18, 'Task #2.1', '2018-04-05 00:00:00', 5, 0.3, 39.999999994179234, 14, '2018-04-09 00:00:00', '2018-04-07 00:00:00', '2018-04-12 00:00:00');
INSERT INTO `gantt_tasks` (`id`, `text`, `start_date`, `duration`, `progress`, `sortorder`, `parent`, `deadline`, `planned_start`, `planned_end`) VALUES(19, 'Task #2.2', '2018-04-05 00:00:00', 6, 0.6, 29.999999995343387, 14, '2018-04-09 00:00:00', '2018-04-08 00:00:00', '2018-04-14 00:00:00');
INSERT INTO `gantt_tasks` (`id`, `text`, `start_date`, `duration`, `progress`, `sortorder`, `parent`, `deadline`, `planned_start`, `planned_end`) VALUES(20, 'Task #2.3', '2018-04-05 00:00:00', 4, 0.512605, 39.99999999534339, 14, '2018-04-08 00:00:00', '2018-04-03 00:00:00', '2018-04-07 00:00:00');
INSERT INTO `gantt_tasks` (`id`, `text`, `start_date`, `duration`, `progress`, `sortorder`, `parent`, `deadline`, `planned_start`, `planned_end`) VALUES(21, 'Task #2.4', '2018-04-05 00:00:00', 6, 0.7, 39.99999999301508, 14, '2018-04-14 00:00:00', '2018-04-07 00:00:00', '2018-04-13 00:00:00');
INSERT INTO `gantt_tasks` (`id`, `text`, `start_date`, `duration`, `progress`, `sortorder`, `parent`, `deadline`, `planned_start`, `planned_end`) VALUES(22, 'Task #4.1', '2018-04-05 00:00:00', 7, 1, 10, 16, '2018-04-15 00:00:00', '2018-04-05 00:00:00', '2018-04-12 00:00:00');
INSERT INTO `gantt_tasks` (`id`, `text`, `start_date`, `duration`, `progress`, `sortorder`, `parent`, `deadline`, `planned_start`, `planned_end`) VALUES(23, 'Task #4.2', '2018-04-05 00:00:00', 5, 1, 20, 16, '2018-04-11 00:00:00', '2018-04-05 00:00:00', '2018-04-10 00:00:00');
INSERT INTO `gantt_tasks` (`id`, `text`, `start_date`, `duration`, `progress`, `sortorder`, `parent`, `deadline`, `planned_start`, `planned_end`) VALUES(24, 'Task #4.3', '2018-04-05 00:00:00', 5, 0, 30, 16, '2018-04-12 00:00:00', '2018-04-0