ptracker.sql

-- MySQL dump 10.13  Distrib 8.0.25, for Win64 (x86_64)
--
-- Host: localhost    Database: ptracker
-- ------------------------------------------------------
-- Server version	8.0.25

/*!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 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 `choice`
--

DROP TABLE IF EXISTS `choice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `choice` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(20) NOT NULL,
  `value` int NOT NULL,
  `display_value` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `choice`
--

LOCK TABLES `choice` WRITE;
/*!40000 ALTER TABLE `choice` DISABLE KEYS */;
INSERT INTO `choice` VALUES (1,'state',10,'New'),(2,'state',20,'Work in Progress'),(3,'state',30,'On Hold'),(4,'state',40,'Complete');
/*!40000 ALTER TABLE `choice` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `project`
--

DROP TABLE IF EXISTS `project`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `project` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `description` varchar(200) NOT NULL,
  `state` int NOT NULL DEFAULT '10',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `project`
--

LOCK TABLES `project` WRITE;
/*!40000 ALTER TABLE `project` DISABLE KEYS */;
INSERT INTO `project` VALUES (1,'react db app','Build a react app that uses a database',20,'2021-10-22 19:55:05','2021-10-22 20:01:04'),(4,'Obtain ServiceNow CIS-APM Certification','Study for the exam with NowLearning, take exam with webassessor',40,'2021-10-22 19:55:05','2021-09-01 05:00:00'),(5,'Obtain ServiceNow CIS-ITSM Certification','Study for exam with NowLearning, explore ITSM apps, attended Accenture training, take exam with webassessor',40,'2021-10-22 19:55:05','2021-09-01 05:00:00'),(6,'Obtain ServiceNow CAD certification','Get experience working as a developer, then take fundamentals on NowLearning, attend Accenture training, and take the exam with webassessor',30,'2021-10-22 19:55:05','2021-09-01 05:00:00'),(17,'test','test',10,'2021-10-22 20:01:25','2021-10-22 20:01:25');
/*!40000 ALTER TABLE `project` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `task`
--

DROP TABLE IF EXISTS `task`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `task` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `projectId` int unsigned NOT NULL,
  `name` varchar(200) NOT NULL,
  `description` varchar(200) NOT NULL,
  `state` int NOT NULL DEFAULT '10',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `task_ibfk_1` (`projectId`),
  CONSTRAINT `task_ibfk_1` FOREIGN KEY (`projectId`) REFERENCES `project` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `task`
--

LOCK TABLES `task` WRITE;
/*!40000 ALTER TABLE `task` DISABLE KEYS */;
INSERT INTO `task` VALUES (1,1,'Create MySQL database','Create the MySQL database',40,'2021-09-01 05:00:00','2021-09-01 05:00:00'),(2,1,'Populate MySQL database','Populate the database with initial data for UI testing',40,'2021-09-01 05:00:00','2021-09-01 05:00:00'),(7,5,'Study ITSM fundamentals','Study the ITSM fundamentals course on NowLearning',20,'2021-09-01 05:00:00','2021-09-01 05:00:00'),(8,5,'Attend ILT','Once added to class, attend ILT 8/23-8/27',30,'2021-09-01 05:00:00','2021-09-01 05:00:00'),(12,1,'asdf','asdf',40,'2021-09-01 05:00:00','2021-09-01 05:00:00'),(15,1,'Finish state implementation for task','Add select element for task state to appear in task modal when editing a task',40,'2021-09-01 05:00:00','2021-09-01 05:00:00'),(16,6,'Study NowLearning materials','Find any and all Developer related training on NowLearning',10,'2021-09-01 05:00:00','2021-09-01 05:00:00'),(17,6,'Attend ILT','Attend Instructor lead training for ServiceNow Application Development through Accenture',30,'2021-09-01 05:00:00','2021-09-01 05:00:00'),(18,4,'Study Fundamentals','Study Fundamentals of APM in ServiceNow with NowLearning On Demand content',40,'2021-09-01 05:00:00','2021-09-01 05:00:00'),(19,4,'Study Implementation','Study Implementation of APM on ServiceNow On Demand content',40,'2021-09-01 05:00:00','2021-09-01 05:00:00'),(20,4,'Take Exam','Take the certification exam through web assessor',40,'2021-09-01 05:00:00','2021-09-01 05:00:00');
/*!40000 ALTER TABLE `task` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2021-10-22 15:03:19