text: CREATE DATABASE  IF NOT EXISTS `capstone` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
  USE `capstone`;
  -- MySQL dump 10.13  Distrib 8.0.16, for Win64 (x86_64)
  --
  -- Host: localhost    Database: capstone
  -- ------------------------------------------------------
  -- Server version	8.0.16
  
  /*!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 */;
   SET NAMES utf8 ;
  /*!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 `activity_evidences`
  --
  
  DROP TABLE IF EXISTS `activity_evidences`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
   SET character_set_client = utf8mb4 ;
  CREATE TABLE `activity_evidences` (
    `activityID` int(11) NOT NULL,
    `documentID` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `activity_evidences`
  --
  
  LOCK TABLES `activity_evidences` WRITE;
  /*!40000 ALTER TABLE `activity_evidences` DISABLE KEYS */;
  INSERT INTO `activity_evidences` VALUES (1,1),(1,4),(1,3),(1,5),(1,2),(2,6),(1,7),(1,13),(1,20),(1,18),(1,10),(1,11),(1,16),(1,21),(1,17),(1,15),(1,14),(1,12),(1,22),(1,19),(1,9),(1,8),(2,27),(2,23),(2,38),(2,26),(2,31),(2,36),(2,24),(2,30),(2,29),(2,45),(2,28),(2,40),(2,25),(2,35),(2,34),(2,42),(2,46),(2,44),(2,41),(2,43),(2,32),(2,37),(2,39),(2,33),(3,47),(3,50),(3,48),(3,49),(3,53),(3,71),(3,54),(3,63),(3,51),(3,73),(3,52),(3,55),(3,74),(3,64),(3,61),(3,66),(3,60),(3,76),(3,79),(3,82),(3,62),(3,67),(3,80),(3,58),(3,93),(3,83),(3,78),(3,90),(3,84),(3,65),(3,97),(3,92),(3,88),(3,94),(3,68),(3,87),(3,75),(3,89),(3,57),(3,70),(3,91),(3,85),(3,86),(3,103),(3,98),(3,96),(3,102),(3,105),(3,99),(3,69),(3,110),(3,56),(3,77),(3,112),(3,109),(3,81),(3,95),(3,104),(3,114),(3,72),(3,59),(3,117),(3,101),(3,111),(3,123),(3,121),(3,115),(3,133),(3,125),(3,126),(3,107),(3,124),(3,127),(3,122),(3,106),(3,134),(3,113),(3,132),(3,128),(3,118),(3,119),(3,142),(3,144),(3,120),(3,143),(3,136),(3,116),(3,131),(3,138),(3,135),(3,140),(3,139),(3,159),(3,137),(3,130),(3,129),(3,141),(3,145),(3,149),(3,155),(3,156),(3,100),(3,146),(3,108),(3,151),(3,161),(3,158),(3,148),(3,147),(3,160),(3,157),(3,152),(3,163),(3,153),(3,162),(3,150),(3,164),(3,171),(3,154),(3,166),(3,165),(3,174),(3,168),(3,176),(3,178),(3,170),(3,175),(3,172),(3,192),(3,177),(3,173),(3,188),(3,169),(3,194),(3,167),(3,182),(3,186),(3,183),(3,198),(3,187),(3,189),(3,181),(3,184),(3,180),(3,193),(3,196),(3,199),(3,179),(3,191),(3,190),(3,200),(3,197),(3,185),(3,195),(11,201),(12,202),(12,201),(12,203),(18,203),(18,204),(18,203),(18,204),(18,205),(18,206),(12,204),(12,203),(18,201),(18,202),(18,203),(18,201),(18,202),(18,203),(18,202),(18,203),(18,204),(18,207),(18,208),(18,209),(18,210),(26,206),(26,205),(26,205),(26,204);
  /*!40000 ALTER TABLE `activity_evidences` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `activity_members`
  --
  
  DROP TABLE IF EXISTS `activity_members`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
   SET character_set_client = utf8mb4 ;
  CREATE TABLE `activity_members` (
    `activity_ID` int(11) NOT NULL,
    `activity_Member` int(11) NOT NULL,
    `measurement_ID` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `activity_members`
  --
  
  LOCK TABLES `activity_members` WRITE;
  /*!40000 ALTER TABLE `activity_members` DISABLE KEYS */;
  INSERT INTO `activity_members` VALUES (26,120,18),(26,121,18),(9,120,18),(15,121,18);
  /*!40000 ALTER TABLE `activity_members` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `activity_outputs`
  --
  
  DROP TABLE IF EXISTS `activity_outputs`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
   SET character_set_client = utf8mb4 ;
  CREATE TABLE `activity_outputs` (
    `output_ID` int(11) NOT NULL AUTO_INCREMENT,
    `activity_ID` int(11) NOT NULL,
    `output` varchar(45) NOT NULL,
    `output_Status` int(11) DEFAULT '0',
    PRIMARY KEY (`output_ID`)
  ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `activity_outputs`
  --
  
  LOCK TABLES `activity_outputs` WRITE;
  /*!40000 ALTER TABLE `activity_outputs` DISABLE KEYS */;
  INSERT INTO `activity_outputs` VALUES (1,18,'test',0),(2,18,'Image of Building',0),(3,18,'Blueprints of building',0),(4,19,'test',0),(5,20,'Pictures',0),(6,18,'testing',0),(7,9,'image',0),(8,9,'syllabus',0),(9,26,'TESTING',0),(10,26,'TESTING TESTING',0),(11,15,'test',0),(12,15,'image',0);
  /*!40000 ALTER TABLE `activity_outputs` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `approved_activities`
  --
  
  DROP TABLE IF EXISTS `approved_activities`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
   SET character_set_client = utf8mb4 ;
  CREATE TABLE `approved_activities` (
    `activity_ID` int(11) NOT NULL AUTO_INCREMENT,
    `activity_name` varchar(45) NOT NULL,
    `target` int(11) DEFAULT NULL,
    `code` tinyint(1) DEFAULT '0',
    `description` mediumtext NOT NULL,
    `measurement_ID` int(11) DEFAULT NULL,
    `current_Score` int(11) NOT NULL DEFAULT '0',
    `deadline` date NOT NULL,
    PRIMARY KEY (`activity_ID`)
  ) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `approved_activities`
  --
  
  LOCK TABLES `approved_activities` WRITE;
  /*!40000 ALTER TABLE `approved_activities` DISABLE KEYS */;
  INSERT INTO `approved_activities` VALUES (1,'123',23,1,'test count',1,5,'0000-00-00'),(2,'123',100,0,'test check',1,100,'0000-00-00'),(3,'123',100,0,'234',1,0,'0000-00-00'),(4,'123',12,1,'234',1,0,'0000-00-00'),(5,'123',100,0,'234',1,0,'0000-00-00'),(6,'123',12,1,'234',1,0,'0000-00-00'),(7,'test',10,1,'test description',2,5,'0000-00-00'),(8,'test 2',15,0,'test description number 2',2,7,'0000-00-00'),(9,'Atesting new measure',50,1,'testing new measure',3,25,'0000-00-00'),(10,'testing new measure part two',60,1,'testing new measure part 2',4,33,'0000-00-00'),(11,'TESTING ACTIVITY',45,1,'TESTING ACTIVITY',14,25,'0000-00-00'),(12,'Checking Activity',100,0,'do stuff here',15,100,'0000-00-00'),(13,'Number of computers that have',50,1,'-photoshop\n-8gb ram',15,0,'0000-00-00'),(14,'Number of Computers that have over * gb ram',80,1,'Table Report',15,0,'0000-00-00'),(15,'Do the Computers have Photoshop installed?',100,0,'Table Report',15,0,'0000-00-00'),(16,'testing',30,1,'testiung',1,0,'0000-00-00'),(17,'testing',30,1,'testiung',1,0,'0000-00-00'),(18,'2',33,1,'WIDTH OF LS BUIILDING',16,0,'0000-00-00'),(19,'1',34,1,'HEIGHT OF LS BUILDING',16,0,'0000-00-00'),(20,'2',33,1,'AREA OF LS BUIILDING',16,0,'0000-00-00'),(21,'testing',10,0,'testing',17,0,'0000-00-00'),(22,'testing1',90,0,'testing1',17,0,'0000-00-00'),(23,'testing date',100,0,'testing date',16,0,'2019-10-31'),(24,'qwe',NULL,0,'qwe',NULL,0,'2019-11-07'),(25,'qwe',NULL,0,'qwe',NULL,0,'2019-11-07'),(26,'THIS IS A TEST',NULL,0,'WHAT IM TRYING TO TEST ATM NOVEMBER 7',NULL,0,'2019-11-30'),(27,'qwer',NULL,0,'qwer',NULL,0,'2019-11-15'),(28,'asdfghjkl',NULL,0,'asdfghjkl',NULL,0,'2019-11-22');
  /*!40000 ALTER TABLE `approved_activities` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `area`
  --
  
  DROP TABLE IF EXISTS `area`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
   SET character_set_client = utf8mb4 ;
  CREATE TABLE `area` (
    `Area_ID` int(11) NOT NULL,
    `Area_Name` varchar(45) DEFAULT NULL,
    PRIMARY KEY (`Area_ID`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `area`
  --
  
  LOCK TABLES `area` WRITE;
  /*!40000 ALTER TABLE `area` DISABLE KEYS */;
  INSERT INTO `area` VALUES (1,'Purposes and Objectives'),(2,'Faculty'),(3,'Instruction'),(4,'Library'),(5,'Laboratories'),(6,'Physial Plan'),(7,'Student Services'),(8,'Administration'),(9,'School and Community');
  /*!40000 ALTER TABLE `area` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `audit_activities`
  --
  
  DROP TABLE IF EXISTS `audit_activities`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
   SET character_set_client = utf8mb4 ;
  CREATE TABLE `audit_activities` (
    `audit_ID` int(11) NOT NULL AUTO_INCREMENT,
    `activity_ID` int(11) NOT NULL,
    `activity_name` varchar(45) NOT NULL,
    `target` int(11) NOT NULL,
    `code` tinyint(1) NOT NULL,
    `description` mediumtext,
    `measurement_ID` int(11) NOT NULL,
    `current_Score` int(11) DEFAULT NULL,
    `status` tinyint(1) DEFAULT NULL,
    PRIMARY KEY (`audit_ID`)
  ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `audit_activities`
  --
  
  LOCK TABLES `audit_activities` WRITE;
  /*!40000 ALTER TABLE `audit_activities` DISABLE KEYS */;
  INSERT INTO `audit_activities` VALUES (1,2,'123',100,0,'test check',7,100,1),(2,1,'123',23,1,'test count',7,12,1),(3,11,'TESTING ACTIVITY',45,1,'TESTING ACTIVITY',14,25,1),(4,12,'Checking Activity',100,0,'do stuff here',15,100,1),(5,1,'123',23,1,'test count',1,5,1);
  /*!40000 ALTER TABLE `audit_activities` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `cycle`
  --
  
  DROP TABLE IF EXISTS `cycle`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
   SET character_set_client = utf8mb4 ;
  CREATE TABLE `cycle` (
    `cycle_ID` int(11) NOT NULL AUTO_INCREMENT,
    `cycle_Name` varchar(45) NOT NULL,
    `start_Date` date NOT NULL,
    `end_Date` date NOT NULL,
    `status` int(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (`cycle_ID`)
  ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `cycle`
  --
  
  LOCK TABLES `cycle` WRITE;
  /*!40000 ALTER TABLE `cycle` DISABLE KEYS */;
  INSERT INTO `cycle` VALUES (0,'No Assigned ','0000-00-00','0000-00-00',4),(10,'TEST CYCLE INSERT','2019-09-05','2019-10-17',4),(11,'TERM 1 AY 2020-2021','2019-09-01','2019-12-15',0);
  /*!40000 ALTER TABLE `cycle` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `documents`
  --
  
  DROP TABLE IF EXISTS `documents`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
   SET character_set_client = utf8mb4 ;
  CREATE TABLE `documents` (
    `Document_ID` int(11) NOT NULL AUTO_INCREMENT,
    `Document_Name` varchar(45) NOT NULL,
    `Document_Route` text NOT NULL,
    `Document_Desc` varchar(300) DEFAULT 'No Description Given.',
    `Document_Ext` varchar(45) NOT NULL,
    `InDrive` tinyint(1) NOT NULL DEFAULT '0',
    `DriveID` varchar(40) DEFAULT '0',
    PRIMARY KEY (`Document_ID`)
  ) ENGINE=InnoDB AUTO_INCREMENT=211 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `documents`
  --
  
  LOCK TABLES `documents` WRITE;
  /*!40000 ALTER TABLE `documents` DISABLE KEYS */;
  INSERT INTO `documents` VALUES (201,'F1institutional-moa-re-ojt.doc','uploads/F1institutional-moa-re-ojt.doc',NULL,'.doc',1,'1fUZrQ9PRlAHFh4DlkF35ed2zvAYEkHMx'),(202,'F1institutional-moa-re-ojt.doc','uploads/F1institutional-moa-re-ojt.doc',NULL,'.doc',1,'1fUZrQ9PRlAHFh4DlkF35ed2zvAYEkHMx'),(203,'LITEPOPRI.docx','uploads/LITEPOPRI.docx',NULL,'.docx',1,'10NhrX-GgGvOax_Ou2lyO-RAxWWBvpKs5'),(204,'ONEDECISIONCANCHANGETHEFUTURE.png','uploads/ONEDECISIONCANCHANGETHEFUTURE.png',NULL,'.png',1,'1cLMYJ3GIck65ETcxNloO0vj347T1utu4'),(205,'PTOUR-2A2SorianoRijaneMayC.doc','uploads/PTOUR-2A2SorianoRijaneMayC.doc',NULL,'.doc',1,'1Y2E65VaC9KMR20o80IZxOCpngBJiidx7'),(206,'MOBAPDEAndroidChallenge1-S18.docx','uploads/MOBAPDEAndroidChallenge1-S18.docx',NULL,'.docx',1,'1ZpAQ7940dglSUD5-8UJumg5nR-i7YYd0'),(207,'04-19-04-35-15-2019.jpg','uploads/04-19-04-35-15-2019.jpg',NULL,'.jpg',1,'1cr9mAUFm-bo2aBT0dTCisfUt7zbogFB8'),(208,'04-19-04-39-33-2019.png','uploads/04-19-04-39-33-2019.png',NULL,'.png',1,'1fGRoFtBbJdiOJ4qaUMBA5WV34QAVLTLs'),(209,'04-19-04-40-40-2019.png','uploads/04-19-04-40-40-2019.png',NULL,'.png',1,'1sd7l9pTS-kF831Cjsgu2TGqpXJBBOxWS'),(210,'04-22-08-25-15-2019.jpg','uploads/04-22-08-25-15-2019.jpg',NULL,'.jpg',1,'1l1tH5tbpXOFMjIvNwBLzvaV79YN6ymcf');
  /*!40000 ALTER TABLE `documents` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `grades`
  --
  
  DROP TABLE IF EXISTS `grades`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
   SET character_set_client = utf8mb4 ;
  CREATE TABLE `grades` (
    `grades_ID` int(11) NOT NULL AUTO_INCREMENT,
    `Rank` int(11) NOT NULL,
    `Code` varchar(45) NOT NULL,
    `Accreditation_ID` int(11) NOT NULL,
    PRIMARY KEY (`grades_ID`)
  ) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `grades`
  --
  
  LOCK TABLES `grades` WRITE;
  /*!40000 ALTER TABLE `grades` DISABLE KEYS */;
  INSERT INTO `grades` VALUES (1,1,'123',10),(2,2,'234',10),(3,3,'345',10),(4,4,'456',10),(5,6,'678',10),(6,5,'567',10),(7,1,'123',11),(8,2,'234',11),(9,3,'345',11),(10,5,'567',11),(11,4,'456',11),(12,6,'678',11),(13,1,'123',12),(14,2,'234',12),(15,3,'345',12),(16,4,'456',12),(17,5,'567',12),(18,1,'A',13),(19,2,'B',13),(20,3,'C',13),(21,4,'D',13),(22,5,'E',13),(23,6,'F',13),(24,7,'G',13),(25,8,'H',13),(26,11,'K',13),(27,10,'J',13),(28,9,'I',13),(29,12,'L',13),(30,13,'M',13),(31,14,'N',13),(32,15,'O',13),(33,16,'P',13),(34,1,'123',14),(35,2,'234',14),(36,3,'345',14),(37,4,'456',14),(38,5,'567',14),(39,6,'678',14),(40,7,'789',14),(41,8,'890',14),(42,1,'123',15),(43,2,'234',15),(44,3,'345',15),(45,4,'456',15),(46,5,'567',15),(47,6,'678',15),(48,1,'123',16),(49,2,'234',16),(50,3,'345',16),(51,6,'678',16),(52,4,'456',16),(53,5,'567',16);
  /*!40000 ALTER TABLE `grades` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `group`
  --
  
  DROP TABLE IF EXISTS `group`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
   SET character_set_client = utf8mb4 ;
  CREATE TABLE `group` (
    `Group_ID` int(11) NOT NULL AUTO_INCREMENT,
    `Group_Name` varchar(45) DEFAULT NULL,
    `Area_ID` int(11) DEFAULT NULL,
    PRIMARY KEY (`Group_ID`)
  ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `group`
  --
  
  LOCK TABLES `group` WRITE;
  /*!40000 ALTER TABLE `group` DISABLE KEYS */;
  INSERT INTO `group` VALUES (0,'No Group Assigned',0),(1,'Analysis',1),(2,'Evaluation',1),(3,'Analysis',2),(4,'Evaluation',2),(5,'Analysis',3),(6,'Evaluation',3),(7,'Analysis',4),(8,'Evaluation',4),(9,'Analysis',5),(10,'Evaluation',5),(11,'Analysis',6),(12,'Evaluation',6),(13,'Analysis',7),(14,'Evaluation',7),(15,'Analysis',8),(16,'Evaluation',8),(17,'Analysis',9),(18,'Evaluation',9),(19,'Test Area',1),(20,'TESTING',2),(21,'RESEARCH GROUP',1);
  /*!40000 ALTER TABLE `group` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `groupdetails`
  --
  
  DROP TABLE IF EXISTS `groupdetails`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
   SET character_set_client = utf8mb4 ;
  CREATE TABLE `groupdetails` (
    `Groupdetails_ID` int(11) NOT NULL,
    `Groupdetails_UserID` int(11) NOT NULL,
    `Groupdetails_Position` varchar(45) NOT NULL DEFAULT 'Member'
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `groupdetails`
  --
  
  LOCK TABLES `groupdetails` WRITE;
  /*!40000 ALTER TABLE `groupdetails` DISABLE KEYS */;
  INSERT INTO `groupdetails` VALUES (1,35,'Member'),(1,47,'Member'),(1,51,'Member'),(1,57,'Member'),(1,56,'Member'),(1,46,'Member'),(1,52,'Member'),(1,49,'Member'),(1,53,'Member'),(1,48,'Member'),(1,73,'Member'),(1,54,'Member'),(1,50,'Member'),(1,55,'Member'),(1,58,'Member'),(1,59,'Member'),(1,69,'Member'),(1,63,'Member'),(1,68,'Member'),(1,62,'Member'),(1,61,'Member'),(1,67,'Member'),(1,60,'Member'),(1,74,'Member'),(1,71,'Member'),(1,72,'Member'),(1,66,'Member'),(1,65,'Member'),(1,70,'Member'),(1,75,'Member'),(1,77,'Member'),(1,64,'Member'),(1,76,'Member'),(1,81,'Member'),(1,79,'Member'),(1,80,'Member'),(1,78,'Member'),(2,82,'Leader'),(2,83,'Member'),(2,84,'Member'),(19,85,'Member'),(19,87,'Member'),(19,86,'Member'),(19,88,'Member'),(19,89,'Member'),(21,91,'Member'),(21,93,'Member'),(21,92,'Member'),(3,94,'Leader'),(3,90,'Member'),(5,98,'Member'),(5,99,'Member'),(5,97,'Member'),(5,96,'Member'),(5,95,'Member'),(7,100,'Member'),(7,103,'Member'),(7,104,'Member'),(7,102,'Member'),(7,101,'Member'),(18,120,'Member'),(18,121,'Member');
  /*!40000 ALTER TABLE `groupdetails` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `measurement`
  --
  
  DROP TABLE IF EXISTS `measurement`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
   SET character_set_client = utf8mb4 ;
  CREATE TABLE `measurement` (
    `measurement_ID` int(11) NOT NULL AUTO_INCREMENT,
    `QualityTarget` int(11) NOT NULL,
    `Procedures` varchar(500) NOT NULL,
    `GroupAssigned` int(11) NOT NULL,
    `metric_ID` int(11) NOT NULL,
    `measurement_Name` varchar(45) NOT NULL,
    `measurement_Description` varchar(200) NOT NULL,
    `Deadline` varchar(45) DEFAULT NULL,
    PRIMARY KEY (`measurement_ID`)
  ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `measurement`
  --
  
  LOCK TABLES `measurement` WRITE;
  /*!40000 ALTER TABLE `measurement` DISABLE KEYS */;
  INSERT INTO `measurement` VALUES (1,123,'123',1,18,'123','123',NULL),(2,123,'SYLLABUS, PHOTO EVIDENCES OF CLASS, ACTIVITIES DONE IN THE CLASS WITH SERVICE LEARNING',1,18,'NO OF COURSES WITH SERVICE LEARNING','KEEP COUNT OF THE NUMBER OF COURSES THAT HAVE SERVICE LEARNING',NULL),(3,123,'ASD',1,20,'MEASUREMENT 1','% OF CURRICULUM AND SYLLABI REVISED BASED ON LEARNER CENTERED PHILOSOPHY AND LSALLIAN GUIDING PRINCIPLES',NULL),(4,123,'EVIDENCES = SYLLABI',1,20,'MEASUREMENT 2','% OF CURRICULUM AND SYLLABI REVISED BASED ON LEARNER CENTERED PHILOSOPHY AND LSALLIAN GUIDING PRINCIPLES',NULL),(5,100,'TESTING INSERT MEASUREMENT UNDER METRIC',20,22,'TESTING INSERT MEASUREMENT UNDER METRIC','TESTING INSERT MEASUREMENT UNDER METRIC',NULL),(14,80,'testing',1,23,'testing','testing',NULL),(15,50,'Steps on how to accomplish this pleasee submit photos of specifications and layouts',21,24,'Status of hardware in Computer Labs','Status of hardware',NULL),(16,100,'TEST',21,25,'LS BUILDING MEASUREMENTS','HOW TALL IS SAINT LA SALLE BUILDING FROM LOWEST TO  HIGHEST POINT',NULL),(17,100,'TESTING ACTIVITIES',21,25,'TESTING ACTIVITIES','TESTING ACTIVITIES',NULL),(18,80,'test',18,25,'test','test',NULL);
  /*!40000 ALTER TABLE `measurement` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `measurements_activities`
  --
  
  DROP TABLE IF EXISTS `measurements_activities`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
   SET character_set_client = utf8mb4 ;
  CREATE TABLE `measurements_activities` (
    `measurement_ID` int(11) NOT NULL,
    `activity_ID` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `measurements_activities`
  --
  
  LOCK TABLES `measurements_activities` WRITE;
  /*!40000 ALTER TABLE `measurements_activities` DISABLE KEYS */;
  INSERT INTO `measurements_activities` VALUES (18,15),(18,9),(1,25),(5,24),(18,26),(17,27),(14,28),(17,28);
  /*!40000 ALTER TABLE `measurements_activities` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `meetingdetails`
  --
  
  DROP TABLE IF EXISTS `meetingdetails`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
   SET character_set_client = utf8mb4 ;
  CREATE TABLE `meetingdetails` (
    `meetings_ID` int(11) NOT NULL,
    `members_ID` int(11) NOT NULL,
    `Status` tinyint(1) NOT NULL DEFAULT '0'
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `meetingdetails`
  --
  
  LOCK TABLES `meetingdetails` WRITE;
  /*!40000 ALTER TABLE `meetingdetails` DISABLE KEYS */;
  INSERT INTO `meetingdetails` VALUES (1,57,0),(1,51,0),(1,55,0),(1,48,0),(1,47,0),(1,49,0),(1,50,0),(1,56,0),(1,53,0),(1,54,0),(1,52,0);
  /*!40000 ALTER TABLE `meetingdetails` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `meetings`
  --
  
  DROP TABLE IF EXISTS `meetings`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
   SET character_set_client = utf8mb4 ;
  CREATE TABLE `meetings` (
    `meetings_ID` int(11) NOT NULL AUTO_INCREMENT,
    `meetingname` varchar(45) NOT NULL,
    `meetingdesc` mediumtext NOT NULL,
    `meeting_creator` int(11) NOT NULL,
    `start_date` datetime NOT NULL,
    `end_date` datetime NOT NULL,
    PRIMARY KEY (`meetings_ID`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `meetings`
  --
  
  LOCK TABLES `meetings` WRITE;
  /*!40000 ALTER TABLE `meetings` DISABLE KEYS */;
  INSERT INTO `meetings` VALUES (1,'Test Meeting','Test Description',46,'2019-07-31 11:11:00','2019-07-31 11:12:00');
  /*!40000 ALTER TABLE `meetings` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `metric`
  --
  
  DROP TABLE IF EXISTS `metric`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
   SET character_set_client = utf8mb4 ;
  CREATE TABLE `metric` (
    `metric_ID` int(11) NOT NULL AUTO_INCREMENT,
    `metric_Name` varchar(200) DEFAULT NULL,
    `metric_Desc` varchar(200) DEFAULT NULL,
    `priority_Level` varchar(45) DEFAULT NULL,
    `date_insert` datetime DEFAULT NULL,
    `group_ID` int(11) DEFAULT '0',
    `source_ID` int(11) DEFAULT NULL,
    `cycle_ID` int(11) NOT NULL DEFAULT '0',
    `duration` varchar(200) NOT NULL,
    `cycle_Status` varchar(11) DEFAULT NULL,
    PRIMARY KEY (`metric_ID`)
  ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `metric`
  --
  
  LOCK TABLES `metric` WRITE;
  /*!40000 ALTER TABLE `metric` DISABLE KEYS */;
  INSERT INTO `metric` VALUES (18,'123','123','High','2019-07-21 00:00:00',1,1,0,'',NULL),(19,'To fully integrate the learner-centered pedagogy and Lasallian guiding principles','to apply these things in all curricular and co-curricular programs','High','2019-07-29 00:00:00',0,1,0,'',NULL),(20,'GOAL TITLE','TO FULLY INTEGRATE THE LEARNER CENTERED PEDAGOGY AND LASALLIAN GUIDING PRINCIPLES IN ALL CURRICULAR AND CO-CURRICULAR PROGRAMS','High','2019-07-29 00:00:00',1,1,0,'',NULL),(21,'TEST METRIC ADD EDIT','TESTING METRIC ADD EDIT','Medium','2019-07-30 00:00:00',19,19,0,'',NULL),(22,'ADDING METRIC UNDER A SOURCE','ADDING METRIC UNDER SOURCE','Low','2019-07-30 00:00:00',20,19,0,'',NULL),(23,'TESTING NEW INSERT','TESTING','Medium','2019-07-31 00:00:00',1,2,10,'','Active'),(24,'To Provide State of the art facilities for learning and research','Quality of hardware in Computer Laboratories','Medium','2019-08-01 00:00:00',21,20,11,'Till 2021','Active'),(25,'HOW TALL BUILDINGS ARE IN DLSU',NULL,NULL,'2019-10-23 00:00:00',21,20,11,'Till 2022','Active');
  /*!40000 ALTER TABLE `metric` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `pending_activities`
  --
  
  DROP TABLE IF EXISTS `pending_activities`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
   SET character_set_client = utf8mb4 ;
  CREATE TABLE `pending_activities` (
    `pending_ID` int(11) NOT NULL AUTO_INCREMENT,
    `activity_ID` int(11) NOT NULL,
    `activity_name` varchar(45) NOT NULL,
    `target` int(11) DEFAULT NULL,
    `code` tinyint(1) DEFAULT NULL,
    `description` mediumtext,
    `measurement_ID` int(11) DEFAULT NULL,
    `current_Score` int(11) DEFAULT NULL,
    `status` tinyint(1) DEFAULT NULL,
    `suggested_Score` int(11) DEFAULT NULL,
    `dateupdated` date NOT NULL,
    `active` tinyint(1) NOT NULL DEFAULT '1',
    `user_ID` int(11) NOT NULL,
    PRIMARY KEY (`pending_ID`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `pending_activities`
  --
  
  LOCK TABLES `pending_activities` WRITE;
  /*!40000 ALTER TABLE `pending_activities` DISABLE KEYS */;
  INSERT INTO `pending_activities` VALUES (1,18,'2',NULL,1,'Hello',NULL,NULL,NULL,100,'2019-11-07',1,46),(2,26,'THIS IS A TEST',NULL,0,'TESTING SUBMISSION BY ROANOSORIA ID NUMBER 120',NULL,NULL,NULL,10,'2019-11-07',1,120),(3,26,'THIS IS A TEST',NULL,0,'TESTING SUBMITION 2',NULL,NULL,NULL,90,'2019-11-07',1,120);
  /*!40000 ALTER TABLE `pending_activities` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `plandetails`
  --
  
  DROP TABLE IF EXISTS `plandetails`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
   SET character_set_client = utf8mb4 ;
  CREATE TABLE `plandetails` (
    `Plan_ID` int(11) NOT NULL,
    `Member_ID` varchar(45) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `plandetails`
  --
  
  LOCK TABLES `plandetails` WRITE;
  /*!40000 ALTER TABLE `plandetails` DISABLE KEYS */;
  INSERT INTO `plandetails` VALUES (7,'57'),(7,'35'),(7,'47'),(7,'56'),(7,'51'),(7,'46'),(7,'71'),(7,'70'),(7,'72'),(7,'62'),(7,'58'),(7,'50'),(7,'52'),(7,'48'),(7,'77'),(7,'59'),(7,'55'),(7,'81'),(7,'74'),(7,'66'),(7,'69'),(7,'76'),(7,'80'),(7,'73'),(7,'54'),(7,'63'),(7,'67'),(7,'78'),(7,'79'),(7,'61'),(7,'65'),(7,'68'),(7,'60'),(7,'49'),(7,'75'),(7,'53'),(7,'64');
  /*!40000 ALTER TABLE `plandetails` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `plans_members`
  --
  
  DROP TABLE IF EXISTS `plans_members`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
   SET character_set_client = utf8mb4 ;
  CREATE TABLE `plans_members` (
    `plan_ID` int(11) NOT NULL,
    `user_ID` int(11) NOT NULL,
    `recommendation_ID` int(11) NOT NULL,
    `group_ID` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `plans_members`
  --
  
  LOCK TABLES `plans_members` WRITE;
  /*!40000 ALTER TABLE `plans_members` DISABLE KEYS */;
  /*!40000 ALTER TABLE `plans_members` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `plansubmissions`
  --
  
  DROP TABLE IF EXISTS `plansubmissions`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
   SET character_set_client = utf8mb4 ;
  CREATE TABLE `plansubmissions` (
    `Submission_ID` int(11) NOT NULL AUTO_INCREMENT,
    `Plan_ID` int(11) DEFAULT NULL,
    `User_ID` int(11) DEFAULT NULL,
    `Submission_Title` varchar(45) DEFAULT NULL,
    `Submission_File` varchar(100) DEFAULT NULL,
    `Submission_Description` varchar(300) DEFAULT NULL,
    `Submission_Date` date DEFAULT NULL,
    `Submission_Status` tinyint(1) DEFAULT '1',
    `Leader_Notes` varchar(45) DEFAULT NULL,
    PRIMARY KEY (`Submission_ID`)
  ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `plansubmissions`
  --
  
  LOCK TABLES `plansubmissions` WRITE;
  /*!40000 ALTER TABLE `plansubmissions` DISABLE KEYS */;
  INSERT INTO `plansubmissions` VALUES (1,7,35,'test','uploads/1.JPG','DESCRIPTION NUMBER 1','2019-07-23',3,'123'),(2,7,35,'TESTING','uploads/asean.docx','DESCRIPTION NUMBER 2','2019-07-24',0,NULL),(3,7,35,'TESTING PART 2','uploads/RoviSorianoA99.docx','DESCRIPTION NUMBER 3','2019-07-24',1,NULL),(4,8,35,'TESTING ANOTHER ONE','uploads/F1institutional-moa-re-ojt.doc','TESTING ANOTHER ONE','2019-07-25',1,NULL),(5,9,35,'TESTI','uploads/F1institutional-moa-re-ojt.doc','ASDASD','2019-07-25',0,NULL),(6,7,46,'Hi','uploads/07-01-01-07-05-2019.jpg','123','2019-07-28',1,NULL),(7,7,46,'645','uploads/06-01-01-45-57-2019.png','634','2019-07-28',1,NULL);
  /*!40000 ALTER TABLE `plansubmissions` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `roles`
  --
  
  DROP TABLE IF EXISTS `roles`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
   SET character_set_client = utf8mb4 ;
  CREATE TABLE `roles` (
    `Role_ID` int(11) NOT NULL,
    `Role_Name` varchar(45) DEFAULT NULL,
    PRIMARY KEY (`Role_ID`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `roles`
  --
  
  LOCK TABLES `roles` WRITE;
  /*!40000 ALTER TABLE `roles` DISABLE KEYS */;
  INSERT INTO `roles` VALUES (1,'Admin'),(2,'QA Officer'),(3,'Department Chair'),(4,'User');
  /*!40000 ALTER TABLE `roles` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `source`
  --
  
  DROP TABLE IF EXISTS `source`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
   SET character_set_client = utf8mb4 ;
  CREATE TABLE `source` (
    `source_ID` int(11) NOT NULL AUTO_INCREMENT,
    `source_Name` varchar(200) DEFAULT NULL,
    `source_Description` mediumtext,
    PRIMARY KEY (`source_ID`)
  ) 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 `source`
  --
  
  LOCK TABLES `source` WRITE;
  /*!40000 ALTER TABLE `source` DISABLE KEYS */;
  INSERT INTO `source` VALUES (1,'PAASCU','PAASCU is governed by a 15-person Board of Directors elected at large by\r\nmembers during the annual General Assembly. It has seven Commissions with five\r\nto seven members each to perform its mandate. These are the Commissions on\r\nGraduate Education, Medical Education, Engineering Education, Tertiary\r\nEducation, Integrated Basic Education, Secondary Education and Elementary\r\nEducation. The Commission members are recommended during the General\r\nAssembly and appointed by the Board.\r\n\r\nThe Commissions plan and initiate projects for each level, revise survey\r\ninstruments, and train accreditors and team chairs. Moreover, they review the\r\nreports of the survey teams before these are submitted to the Board.\r\nPAASCU’s day to day operations are handled by a Secretariat which is headed by\r\nthe Executive Director. The Secretariat takes care of the logistics of the survey\r\nvisits, invites accreditors, prepares reports and forms, and implements the projects\r\nof the Commissions.'),(2,'ABET','At ABET, our purpose is to assure confidence in university programs in STEM (science, technology, engineering and mathematics) disciplines. Our approach, the standards we set and the quality we guarantee, inspires confidence in those who aim to build a better world—one that is safer, more efficient, more comfortable and more sustainable.\r\n\r\nWe accredit college and university programs in the disciplines of applied and natural science, computing, engineering and engineering technology at the associate, bachelor’s and master’s degree levels.\r\n\r\nWith ABET accreditation, students, employers and the society we serve can be confident that a program meets the quality standards that produce graduates prepared to enter a global workforce.\r\n\r\nWe began as the educational standard against which professional engineers in the United States were held for licensure. Today, after more than 80 years, our standards continue to play this fundamental role and have become the basis of quality for STEM disciplines all over the world.\r\n\r\nDeveloped by technical professionals from ABET’s member societies, our criteria focus on what students experience and learn. Sought worldwide, ABET’s voluntary peer-review process is highly respected because it adds critical value to academic programs in the technical disciplines, where quality, precision and safety are of the utmost importance.\r\n\r\nOur more than 2,200 experts come from industry, academia and government. They give their time and effort supporting quality assurance activities around the world by serving as Program Evaluators, commissioners, board members and advisors.\r\n\r\nABET is a nonprofit, non-governmental organization with ISO 9001:2015 certification.'),(3,'TEst Item','AAAAA'),(4,'TEst Item2','1234'),(5,'TEst Item3','2345'),(6,'TEst Item4','1234'),(7,'TEst Item5','1234'),(8,'TEst Item6','1234'),(9,'TEst Item7','1234'),(10,'TEst Item10','1234'),(11,'TEst Item112','1234'),(12,'TEst Item1123','1234'),(13,'TEst Item23423','1234345'),(14,'TEst Item112334','1234'),(15,'TEst Item11432334','1234'),(16,'TEst Item11435623','1234'),(17,'Test ','sihdfsjfsfd'),(18,'dfsadf','asdfasdf'),(19,'TEST SOURCE EDIT','TEST SOURCE EDIT'),(20,'Department Defined','College of computer studies IT Dep');
  /*!40000 ALTER TABLE `source` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `tasks`
  --
  
  DROP TABLE IF EXISTS `tasks`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
   SET character_set_client = utf8mb4 ;
  CREATE TABLE `tasks` (
    `task_ID` int(11) NOT NULL AUTO_INCREMENT,
    `Task_Name` varchar(45) NOT NULL,
    `Task_Desc` varchar(45) NOT NULL,
    `GenObj` varchar(45) NOT NULL,
    `Measurement` varchar(45) NOT NULL,
    `QT` varchar(45) NOT NULL,
    `BaseStandard` varchar(45) NOT NULL,
    `Group` varchar(45) DEFAULT 'Not Assigned',
    `Personnel` varchar(45) DEFAULT 'Not Assigned',
    `Level` varchar(45) DEFAULT 'Not Assigned',
    `plan_ID` int(11) NOT NULL,
    PRIMARY KEY (`task_ID`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `tasks`
  --
  
  LOCK TABLES `tasks` WRITE;
  /*!40000 ALTER TABLE `tasks` DISABLE KEYS */;
  /*!40000 ALTER TABLE `tasks` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `users`
  --
  
  DROP TABLE IF EXISTS `users`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
   SET character_set_client = utf8mb4 ;
  CREATE TABLE `users` (
    `User_ID` int(11) NOT NULL AUTO_INCREMENT,
    `User_First` varchar(45) DEFAULT NULL,
    `User_Last` varchar(45) DEFAULT NULL,
    `email_address` varchar(100) DEFAULT NULL,
    `Role` int(11) DEFAULT NULL,
    `Group` int(11) DEFAULT NULL,
    `ContactNo` varchar(12) DEFAULT NULL,
    `username` varchar(45) DEFAULT NULL,
    `passwd` varchar(100) DEFAULT NULL,
    PRIMARY KEY (`User_ID`),
    UNIQUE KEY `username_UNIQUE` (`username`)
  ) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `users`
  --
  
  LOCK TABLES `users` WRITE;
  /*!40000 ALTER TABLE `users` DISABLE KEYS */;
  INSERT INTO `users` VALUES (35,'Admin','Admin','debug@debug.com',1,1,'99999999999','Admin','$2b$10$w1q.GZyvVMwt9c6aiFjBEuahRim1NOtIgFOY8DYsxoJuN31CsUGsu'),(46,'AdminX','AdminX','debug@debug.com',1,1,'99999999999','AdminX','$2b$10$bWyFihniq34XjVzTZXXMjeqbF1LeG.gP06X2FLc.XZ6vgH5wHo6.e'),(47,'Jayme','Randall','quis.massa.Mauris@amalesuadaid.com',4,1,'0827150506','orci.consectetuer.euismod@convalliserat.co.uk',NULL),(48,'Hedda','Blanchard','dolor.egestas.rhoncus@etmagnisdis.com',4,1,'0532678474','egestas.hendrerit@Maurisblanditenim.co.uk',NULL),(49,'Quentin','Farmer','senectus.et.netus@Nulla.co.uk',4,1,'0424963076','vitae.erat@risusDuisa.net',NULL),(50,'Rooney','Lawson','lectus@utipsumac.com',4,1,'0017842615','ipsum.nunc.id@velitSedmalesuada.edu',NULL),(51,'Fuller','Lawson','lorem.vitae.odio@turpisNulla.com',4,1,'0104998917','ut.pellentesque.eget@Aliquamvulputate.net',NULL),(52,'Naida','Travis','molestie.orci.tincidunt@diamSed.org',4,1,'0396262927','ipsum@hymenaeosMaurisut.com',NULL),(53,'Shelly','Odonnell','consequat.purus@ut.com',4,1,'0741793038','Etiam.gravida.molestie@lectus.edu',NULL),(54,'Nomlanga','Wiley','sociis@imperdietnecleo.net',4,1,'0463195329','ut.pellentesque.eget@semNulla.org',NULL),(55,'Pamela','Payne','cursus.et.magna@cursusaenim.net',4,1,'0336253671','diam@tempus.edu',NULL),(56,'Dale','Fulton','consequat.dolor@vestibulum.edu',4,1,'0621007822','ultricies@Vivamuseuismodurna.co.uk',NULL),(57,'Brock','Tanner','magnis.dis@iaculisaliquetdiam.com',4,1,'0485322526','ornare.lectus.justo@dolorFuscemi.net',NULL),(58,'Drake','Hogan','Integer@nequeMorbi.co.uk',4,1,'0122087593','sed.turpis@arcuVestibulum.net',NULL),(59,'Fitzgerald','Ortiz','arcu@in.edu',4,1,'0353804236','vitae.aliquam.eros@quispedePraesent.edu',NULL),(60,'Isaiah','Kemp','pellentesque@lacinia.co.uk',4,1,'0687689022','enim.Etiam.gravida@enimEtiamgravida.org',NULL),(61,'Cassady','Carson','adipiscing@quisaccumsan.org',4,1,'0822841725','justo@Loremipsumdolor.org',NULL),(62,'Yeo','Allison','Sed.auctor@vulputate.edu',4,1,'0751834790','Nunc.quis@arcuVestibulum.com',NULL),(63,'Daria','Knox','nec.mauris.blandit@rhoncusDonec.co.uk',4,1,'0068744702','neque.sed@quispedePraesent.co.uk',NULL),(64,'Preston','Melton','massa.non@tempusscelerisque.com',4,1,'0385565489','vel.venenatis@non.net',NULL),(65,'Chaim','Walls','ullamcorper.nisl.arcu@Vivamus.org',4,1,'0994904810','vitae.nibh@eget.com',NULL),(66,'Karly','Shaw','nisl.Quisque.fringilla@nonfeugiatnec.co.uk',4,1,'0617257074','penatibus.et@nuncsed.net',NULL),(67,'Maisie','Sharp','ac.mi.eleifend@eratSed.edu',4,1,'0046643354','at.iaculis.quis@malesuadamalesuadaInteger.com',NULL),(68,'Indigo','Mccoy','sit.amet.nulla@feugiatnec.ca',4,1,'0769322656','consectetuer.cursus@risusQuisque.ca',NULL),(69,'Keane','Parsons','Morbi@Aliquameratvolutpat.net',4,1,'0876062059','libero.est@necmaurisblandit.edu',NULL),(70,'Rafael','Schmidt','urna.convallis.erat@ipsum.co.uk',4,1,'0912845172','ac@pretiumneque.com',NULL),(71,'Haley','Wheeler','tristique.aliquet@nibh.net',4,1,'0510355744','sit.amet@Loremipsumdolor.ca',NULL),(72,'William','Dickson','euismod@Aliquamvulputate.com',4,1,'0422612351','convallis.convallis@risusquisdiam.ca',NULL),(73,'Quentin','Church','at.sem.molestie@sapiencursusin.ca',4,1,'0701695380','Donec.tempor.est@feugiat.com',NULL),(74,'Rebekah','Velez','lacus.pede@aaliquet.ca',4,1,'0094284493','Nullam.lobortis@metus.com',NULL),(75,'Lavinia','Yang','dui.nec.urna@faucibus.edu',4,1,'0329088663','dictum.sapien@purus.org',NULL),(76,'Keefe','Ross','elit@nibhsitamet.edu',4,1,'0679701501','dolor.elit.pellentesque@in.com',NULL),(77,'Wendy','Hoover','fringilla.cursus.purus@imperdiet.ca',4,1,'0379574808','orci.tincidunt.adipiscing@malesuada.org',NULL),(78,'Jared','Summers','aliquet@aliquetsem.ca',4,1,'0733466712','Phasellus.elit.pede@quamquisdiam.co.uk',NULL),(79,'Addison','Goodman','orci@disparturientmontes.com',4,1,'0980636012','et.ultrices.posuere@maurisIntegersem.net',NULL),(80,'Patricia','Walsh','Proin.nisl.sem@loremtristiquealiquet.com',4,1,'0297573566','sit.amet@iaculislacus.co.uk',NULL),(81,'Skyler','Gould','risus.Duis.a@rutrummagna.co.uk',4,1,'0540489098','mus.Donec.dignissim@porttitorscelerisque.edu',NULL),(82,'Yetta','Beasley','luctus.aliquet@Morbiquisurna.com',4,2,'0503200466','Cras.convallis.convallis@metuseuerat.com',NULL),(83,'Dexter','Riddle','at.egestas.a@risusaultricies.com',4,2,'0496751635','Cras.eu@etmagnaPraesent.com',NULL),(84,'Lewis','Orr','ac.arcu@etmagnis.org',4,2,'0480299478','commodo@gravidamolestiearcu.edu',NULL),(85,'Geoffrey','Walters','Integer.tincidunt@Etiam.edu',4,19,'0611025254','elementum@malesuadaIntegerid.net',NULL),(86,'Elvis','Frank','consequat@Aeneanegetmagna.edu',4,19,'0359018577','dui.Suspendisse@Quisqueornaretortor.ca',NULL),(87,'Chase','Banks','lectus.Cum@pellentesqueafacilisis.net',4,19,'0756987085','semper.pretium@mauriserateget.edu',NULL),(88,'Adara','Dixon','egestas.Aliquam@semperNam.co.uk',4,19,'0618851512','amet.ante@lectuspedeet.org',NULL),(89,'Derek','Guthrie','enim.nisl.elementum@loremipsum.co.uk',4,19,'0127852498','leo@dolor.co.uk',NULL),(90,'Daquan','Hurst','mattis.Integer.eu@lectussit.ca',4,3,'0751198698','velit@atliberoMorbi.org',NULL),(91,'Gareth','Dyer','quam@quisturpisvitae.org',4,21,'0023856993','est.ac@nec.edu',NULL),(92,'Lucian','Sawyer','tellus.Phasellus.elit@euismod.com',4,21,'0670823754','Nulla.interdum@nislQuisquefringilla.com',NULL),(93,'Donovan','Little','nunc.interdum@miDuisrisus.net',4,21,'0248308253','tempus@nonummy.edu',NULL),(94,'Molly','Foley','lobortis.mauris@porttitor.co.uk',4,3,'0921669041','Donec@Cras.edu',NULL),(95,'Igor','Holman','volutpat.Nulla@vehicularisusNulla.co.uk',4,5,'0573787089','orci.quis@id.org',NULL),(96,'Risa','Hammond','nulla.Integer.urna@ultricesposuerecubilia.ca',4,5,'0824503469','accumsan.convallis@eget.ca',NULL),(97,'Jennifer','Woodard','et@tristique.edu',4,5,'0535069755','mollis.Duis@ac.co.uk',NULL),(98,'Brenna','Hobbs','neque@lacus.co.uk',4,5,'0802762227','aliquet.molestie@semNullainterdum.org',NULL),(99,'Dale','Battle','accumsan@Duisatlacus.com',4,5,'0838195388','eget@vulputate.co.uk',NULL),(100,'Chiquita','Frank','lectus.a@Donecfeugiat.net',4,7,'0436439755','tincidunt.congue@ac.ca',NULL),(101,'Iola','Chen','vulputate.velit@elementum.net',4,7,'0247815078','auctor.ullamcorper@amet.ca',NULL),(102,'Jana','Blanchard','lectus.a.sollicitudin@ipsum.ca',4,7,'0322798799','est.Nunc.ullamcorper@dictumeueleifend.org',NULL),(103,'Ferris','Alexander','diam.dictum@Fuscedolorquam.ca',4,7,'0354503871','orci.consectetuer@nonummy.co.uk',NULL),(104,'Jenette','Singleton','a.neque.Nullam@semper.co.uk',4,7,'0216726577','Suspendisse@sitametluctus.org',NULL),(105,'Slade','Stark','commodo@Fuscemilorem.net',4,NULL,'0234534640','amet@venenatisvel.net',NULL),(106,'Evelyn','Rich','vel.sapien@fermentumconvallis.ca',4,NULL,'0169935725','Ut.semper.pretium@Nunc.co.uk',NULL),(107,'Phyllis','Wolfe','Class@idrisusquis.edu',4,NULL,'0747222437','massa@sodalesatvelit.co.uk',NULL),(108,'Tallulah','Hebert','nunc.ullamcorper@Nullamscelerisque.co.uk',4,NULL,'0282980099','semper.auctor.Mauris@conubia.edu',NULL),(109,'Michael','Garza','dolor.Fusce.feugiat@lobortistellusjusto.net',4,NULL,'0165290651','metus.In@Aenean.org',NULL),(110,'Tucker','Mcleod','quis.urna@viverraDonectempus.co.uk',4,NULL,'0123377019','Fusce.mi@nonquamPellentesque.edu',NULL),(111,'Macy','Benjamin','vitae@ligulaAliquam.org',4,NULL,'0028986385','nibh@Quisquefringilla.edu',NULL),(112,'Xaviera','Kelley','turpis@metus.org',4,NULL,'0781759756','eget.laoreet.posuere@quis.edu',NULL),(113,'Conan','Rose','sodales.elit@sociosquad.com',4,NULL,'0207126016','sit.amet.massa@habitantmorbitristique.ca',NULL),(114,'Jemima','Henderson','elit@nonummyultricies.edu',4,NULL,'0297072047','Aenean@Praesenteudui.co.uk',NULL),(115,'Florence','Hewitt','adipiscing@arcuCurabitur.com',4,NULL,'0217060662','et@posuere.ca',NULL),(116,'Cadman','Baldwin','pharetra@seddolor.org',4,NULL,'0231643413','nisl@tinciduntnibh.ca',NULL),(117,'Fredericka','Yang','odio.Nam@scelerisquesedsapien.co.uk',4,NULL,'0607159193','Mauris@vulputate.org',NULL),(118,'Lucy','Parrish','turpis.In.condimentum@velsapien.net',4,NULL,'0165917109','turpis@est.net',NULL),(119,'Josiah','Buck','non.lorem.vitae@MaurismagnaDuis.com',4,NULL,'0817039008','tellus@nonquam.co.uk',NULL),(120,'ROANO','SORIA','roano@test.com',4,18,'09177825083','ROANOSORIA76','$2b$10$tV6m449Yuj3ofVX2XwZnze83HYRGZp9nlu47CbAooKt2vShvQo6IO'),(121,'EDGE','LORD','EDGELORD@TEST.COM',4,18,'12345569687','EDGELORD77','$2b$10$RzJbaoqrPef.qC8t7G6EaOQovwlhJfc4OTQnY207DLCjPlJj3qHIO');
  /*!40000 ALTER TABLE `users` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `yearlycycle`
  --
  
  DROP TABLE IF EXISTS `yearlycycle`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
   SET character_set_client = utf8mb4 ;
  CREATE TABLE `yearlycycle` (
    `yearlyCycleID` int(11) NOT NULL,
    `cycle_Name` varchar(45) NOT NULL,
    `start_Date` date NOT NULL,
    `end_Date` date NOT NULL,
    `status` int(11) NOT NULL DEFAULT '0',
    `cycle_ID` int(11) NOT NULL,
    PRIMARY KEY (`yearlyCycleID`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `yearlycycle`
  --
  
  LOCK TABLES `yearlycycle` WRITE;
  /*!40000 ALTER TABLE `yearlycycle` DISABLE KEYS */;
  /*!40000 ALTER TABLE `yearlycycle` 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 2019-11-08  2:13:54
  