/*
SQLyog Ultimate v12.0 (64 bit)
MySQL - 5.5.30-MariaDB-log : Database - traffic_lite_ales2
*********************************************************************
*/


/*!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 `Job` */

CREATE TABLE `Job` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;

/*Data for the table `Job` */

insert  into `Job`(`id`) values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12),(13),(14),(15),(16),(17),(18),(19),(20),(21),(22),(23),(24),(25),(26),(27),(28),(29),(30);

/*Table structure for table `JobFreeTagLink` */

CREATE TABLE `JobFreeTagLink` (
  `id` bigint(20) NOT NULL,
  `JobId` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_ki46fu7rog8dxcbnm5hft1x6j` (`JobId`),
  CONSTRAINT `FK_ki46fu7rog8dxcbnm5hft1x6j` FOREIGN KEY (`JobId`) REFERENCES `Job` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `JobFreeTagLink` */

insert  into `JobFreeTagLink`(`id`,`JobId`) values (37,21),(38,21),(39,21),(40,21),(33,22),(34,22),(35,22),(36,22),(28,23),(29,23),(30,23),(31,23),(32,23),(24,24),(25,24),(26,24),(27,24),(20,25),(21,25),(22,25),(23,25),(16,26),(17,26),(18,26),(19,26),(12,27),(13,27),(14,27),(15,27),(8,28),(9,28),(10,28),(11,28),(1,29),(2,29),(3,29),(4,29),(5,30),(6,30),(7,30);

/*Table structure for table `JobTask` */

CREATE TABLE `JobTask` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `JobId` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_JobTask_JobId_taskDeadline` (`JobId`),
  CONSTRAINT `FK_17u64b8rao72jfekrqkrc2iao` FOREIGN KEY (`JobId`) REFERENCES `Job` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=619 DEFAULT CHARSET=utf8;

/*Data for the table `JobTask` */

insert  into `JobTask`(`id`,`JobId`) values (1,1),(2,1),(3,1),(4,1),(5,2),(6,2),(7,2),(8,2),(9,2),(10,2),(11,2),(12,2),(13,2),(14,2),(15,2),(16,2),(17,2),(18,2),(19,2),(20,2),(21,2),(22,2),(23,2),(24,2),(25,2),(26,2),(27,2),(28,2),(29,2),(30,2),(31,2),(32,2),(33,2),(34,2),(35,2),(36,2),(37,2),(38,2),(39,2),(40,2),(41,2),(42,2),(43,2),(44,2),(45,2),(46,2),(47,2),(48,2),(49,2),(50,2),(51,2),(52,2),(53,2),(54,2),(55,2),(56,2),(57,2),(58,2),(59,2),(60,2),(61,2),(62,2),(63,2),(64,2),(65,3),(66,3),(67,3),(68,3),(69,3),(70,3),(71,3),(72,3),(73,3),(74,3),(75,3),(76,4),(77,4),(78,4),(79,4),(80,4),(81,4),(82,4),(83,4),(84,4),(85,4),(86,4),(87,5),(88,5),(89,5),(90,5),(91,5),(92,5),(93,5),(94,5),(95,5),(96,5),(97,5),(98,5),(99,5),(100,5),(101,5),(102,5),(103,5),(104,6),(105,6),(106,6),(107,6),(108,7),(109,7),(110,7),(111,7),(112,7),(113,7),(114,7),(115,7),(116,7),(117,7),(118,7),(119,7),(120,7),(121,7),(122,7),(123,7),(124,7),(125,7),(126,7),(127,7),(128,7),(129,7),(130,7),(131,7),(132,7),(133,7),(134,7),(135,7),(136,7),(137,7),(138,7),(139,7),(140,7),(141,7),(142,7),(143,7),(144,7),(145,7),(146,7),(147,7),(148,7),(149,7),(150,7),(151,7),(152,7),(153,7),(154,7),(155,7),(156,7),(157,7),(158,7),(159,7),(160,7),(161,7),(162,7),(163,7),(164,7),(165,7),(166,7),(167,7),(168,8),(169,8),(170,8),(171,8),(172,8),(173,8),(174,8),(175,8),(176,8),(177,8),(178,8),(179,9),(180,9),(181,9),(182,9),(183,9),(184,9),(185,9),(186,9),(187,9),(188,9),(189,9),(190,10),(191,10),(192,10),(193,10),(194,10),(195,10),(196,10),(197,10),(198,10),(199,10),(200,10),(201,10),(202,10),(203,10),(204,10),(205,10),(206,10),(207,11),(208,11),(209,11),(210,11),(211,12),(212,12),(213,12),(214,12),(215,12),(216,12),(217,12),(218,12),(219,12),(220,12),(221,12),(222,12),(223,12),(224,12),(225,12),(226,12),(227,12),(228,12),(229,12),(230,12),(231,12),(232,12),(233,12),(234,12),(235,12),(236,12),(237,12),(238,12),(239,12),(240,12),(241,12),(242,12),(243,12),(244,12),(245,12),(246,12),(247,12),(248,12),(249,12),(250,12),(251,12),(252,12),(253,12),(254,12),(255,12),(256,12),(257,12),(258,12),(259,12),(260,12),(261,12),(262,12),(263,12),(264,12),(265,12),(266,12),(267,12),(268,12),(269,12),(270,12),(271,13),(272,13),(273,13),(274,13),(275,13),(276,13),(277,13),(278,13),(279,13),(280,13),(281,13),(282,14),(283,14),(284,14),(285,14),(286,14),(287,14),(288,14),(289,14),(290,14),(291,14),(292,14),(293,15),(294,15),(295,15),(296,15),(297,15),(298,15),(299,15),(300,15),(301,15),(302,15),(303,15),(304,15),(305,15),(306,15),(307,15),(308,15),(309,15),(310,16),(311,16),(312,16),(313,16),(314,17),(315,17),(316,17),(317,17),(318,17),(319,17),(320,17),(321,17),(322,17),(323,17),(324,17),(325,17),(326,17),(327,17),(328,17),(329,17),(330,17),(331,17),(332,17),(333,17),(334,17),(335,17),(336,17),(337,17),(338,17),(339,17),(340,17),(341,17),(342,17),(343,17),(344,17),(345,17),(346,17),(347,17),(348,17),(349,17),(350,17),(351,17),(352,17),(353,17),(354,17),(355,17),(356,17),(357,17),(358,17),(359,17),(360,17),(361,17),(362,17),(363,17),(364,17),(365,17),(366,17),(367,17),(368,17),(369,17),(370,17),(371,17),(372,17),(373,17),(374,18),(375,18),(376,18),(377,18),(378,18),(379,18),(380,18),(381,18),(382,18),(383,18),(384,18),(385,19),(386,19),(387,19),(388,19),(389,19),(390,19),(391,19),(392,19),(393,19),(394,19),(395,19),(396,20),(397,20),(398,20),(399,20),(400,20),(401,20),(402,20),(403,20),(404,20),(405,20),(406,20),(407,20),(408,20),(409,20),(410,20),(411,20),(412,20),(413,21),(414,21),(415,21),(416,21),(417,22),(418,22),(419,22),(420,22),(421,22),(422,22),(423,22),(424,22),(425,22),(426,22),(427,22),(428,22),(429,22),(430,22),(431,22),(432,22),(433,22),(434,22),(435,22),(436,22),(437,22),(438,22),(439,22),(440,22),(441,22),(442,22),(443,22),(444,22),(445,22),(446,22),(447,22),(448,22),(449,22),(450,22),(451,22),(452,22),(453,22),(454,22),(455,22),(456,22),(457,22),(458,22),(459,22),(460,22),(461,22),(462,22),(463,22),(464,22),(465,22),(466,22),(467,22),(468,22),(469,22),(470,22),(471,22),(472,22),(473,22),(474,22),(475,22),(476,22),(477,23),(478,23),(479,23),(480,23),(481,23),(482,23),(483,23),(484,23),(485,23),(486,23),(487,23),(488,24),(489,24),(490,24),(491,24),(492,24),(493,24),(494,24),(495,24),(496,24),(497,24),(498,24),(499,25),(500,25),(501,25),(502,25),(503,25),(504,25),(505,25),(506,25),(507,25),(508,25),(509,25),(510,25),(511,25),(512,25),(513,25),(514,25),(515,25),(516,26),(517,26),(518,26),(519,26),(520,27),(521,27),(522,27),(523,27),(524,27),(525,27),(526,27),(527,27),(528,27),(529,27),(530,27),(531,27),(532,27),(533,27),(534,27),(535,27),(536,27),(537,27),(538,27),(539,27),(540,27),(541,27),(542,27),(543,27),(544,27),(545,27),(546,27),(547,27),(548,27),(549,27),(550,27),(551,27),(552,27),(553,27),(554,27),(555,27),(556,27),(557,27),(558,27),(559,27),(560,27),(561,27),(562,27),(563,27),(564,27),(565,27),(566,27),(567,27),(568,27),(569,27),(570,27),(571,27),(572,27),(573,27),(574,27),(575,27),(576,27),(577,27),(578,27),(579,27),(580,28),(581,28),(582,28),(583,28),(584,28),(585,28),(586,28),(587,28),(588,28),(589,28),(590,28),(591,29),(592,29),(593,29),(594,29),(595,29),(596,29),(597,29),(598,29),(599,29),(600,29),(601,29),(602,30),(603,30),(604,30),(605,30),(606,30),(607,30),(608,30),(609,30),(610,30),(611,30),(612,30),(613,30),(614,30),(615,30),(616,30),(617,30),(618,30);

/*Table structure for table `JobTaskTimeEntry` */

CREATE TABLE `JobTaskTimeEntry` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `JobTaskId` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_87mxndbibykjeon7a7qihl5tf` (`JobTaskId`),
  CONSTRAINT `FK_87mxndbibykjeon7a7qihl5tf` FOREIGN KEY (`JobTaskId`) REFERENCES `JobTask` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=utf8;

/*Data for the table `JobTaskTimeEntry` */

insert  into `JobTaskTimeEntry`(`id`,`JobTaskId`) values (76,88),(77,88),(78,88),(79,88),(80,88),(71,89),(72,89),(73,89),(74,89),(75,89),(51,90),(52,90),(53,90),(54,90),(55,90),(41,299),(42,299),(43,299),(44,299),(45,299),(1,300),(2,300),(3,300),(4,300),(5,300),(6,301),(7,301),(8,301),(9,301),(10,301),(46,411),(47,411),(48,411),(49,411),(50,411),(66,511),(67,511),(68,511),(69,511),(70,511),(81,512),(82,512),(83,512),(84,512),(85,512),(16,513),(17,513),(18,513),(19,513),(20,513),(11,514),(12,514),(13,514),(14,514),(15,514),(61,611),(62,611),(63,611),(64,611),(65,611),(26,613),(27,613),(28,613),(29,613),(30,613),(56,614),(57,614),(58,614),(59,614),(60,614),(21,615),(22,615),(23,615),(24,615),(25,615),(31,616),(32,616),(33,616),(34,616),(35,616),(36,618),(37,618),(38,618),(39,618),(40,618);

/*!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 */;
