--
-- Host: localhost    Database: title4e
-- ------------------------------------------------------


--
-- Table structure for table `ACADEMIC_YEAR`
--

CREATE TABLE `ACADEMIC_YEAR` (
  `YID` int(11) NOT NULL AUTO_INCREMENT,
  `ACADEMIC_YR` varchar(10) NOT NULL,
  `START_YR` int(11) DEFAULT NULL,
  `END_YR` int(11) DEFAULT NULL,
  PRIMARY KEY (`YID`),
  UNIQUE KEY `ACADEMIC_YR` (`ACADEMIC_YR`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ACADEMIC_YEAR`
--

INSERT INTO `ACADEMIC_YEAR` VALUES (1,'2018-2019',NULL,NULL),(2,'2019-2020',NULL,NULL),(3,'2020-2021',NULL,NULL),(4,'2021-2022',NULL,NULL);

--
-- Table structure for table `BUDGET_HEADING`
--

CREATE TABLE `BUDGET_HEADING` (
  `BH_ID` int(11) NOT NULL AUTO_INCREMENT,
  `BUDGET_HEADING` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`BH_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `BUDGET_HEADING`
--

INSERT INTO `BUDGET_HEADING` VALUES (1,'Administrative Staff Costs'),(2,'Faculty Costs'),(3,'IV-E Teaching Staff Costs'),(4,'Fringe Benefits for Administrative Staff Costs'),(5,'Fringe Benefits for Faculty and Teaching Costs'),(6,'Training Operating Costs'),(7,'Training Travel Costs'),(8,'Student Stipend Costs'),(9,'Administrative Operating Costs'),(10,'Administrative Travel Costs');

--
-- Table structure for table `BUDGET_ITEM_TYPE`
--

CREATE TABLE `BUDGET_ITEM_TYPE` (
  `BIT_ID` int(11) NOT NULL AUTO_INCREMENT,
  `TYPE` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`BIT_ID`),
  UNIQUE KEY `TYPE` (`TYPE`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `BUDGET_ITEM_TYPE`
--

INSERT INTO `BUDGET_ITEM_TYPE` VALUES (6,'Administrative Operating Costs'),(7,'Administrative Travel Costs'),(1,'Fringe Benefits for Administrative Staff Costs'),(2,'Fringe Benefits for Faculty and Teaching Costs'),(5,'Student StipendCosts'),(3,'Training Operating Costs'),(4,'Training Travel Costs');

--
-- Table structure for table `CHILD_WELFARE_CURRICULUM`
--

CREATE TABLE `CHILD_WELFARE_CURRICULUM` (
  `PROP_ID` int(11) NOT NULL,
  `COURSE_COURSE_ID` int(11) NOT NULL,
  `REQ_NBR` int(11) NOT NULL,
  `CREATE_USER_ID` int(11) NOT NULL,
  `CREATE_DT` date NOT NULL,
  `MODIFY_USER_ID` int(11) DEFAULT NULL,
  `MODIFY_DT` date DEFAULT NULL,
  PRIMARY KEY (`PROP_ID`,`COURSE_COURSE_ID`),
  KEY `FK_CHILD_WF_CRRCL_COURSE_FK` (`COURSE_COURSE_ID`),
  CONSTRAINT `FK_CHILD_WF_CRRCL_COURSE_FK` FOREIGN KEY (`COURSE_COURSE_ID`) REFERENCES `COURSE` (`COURSE_ID`),
  CONSTRAINT `FK_CHILD_WF_CRRCL_PROP_FK` FOREIGN KEY (`PROP_ID`) REFERENCES `PROPOSAL` (`PROP_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CHILD_WELFARE_CURRICULUM`
--

INSERT INTO `CHILD_WELFARE_CURRICULUM` VALUES (1,1,1,1,'2018-07-11',NULL,NULL),(1,2,2,1,'2018-07-11',NULL,NULL),(2,13,1,1,'2018-07-11',NULL,NULL),(2,14,2,1,'2018-07-11',NULL,NULL),(3,25,1,1,'2018-07-12',1,'2018-07-12'),(3,26,2,1,'2018-07-12',1,'2018-07-12'),(4,39,1,1,'2018-07-12',1,'2018-07-12'),(4,40,2,1,'2018-07-12',1,'2018-07-12'),(5,53,1,1,'2018-07-13',1,'2018-07-13'),(5,54,2,1,'2018-07-13',1,'2018-07-13'),(6,67,1,1,'2018-07-13',1,'2018-07-13'),(6,68,2,1,'2018-07-13',1,'2018-07-13'),(7,79,1,1,'2018-07-13',1,'2018-07-13'),(7,80,2,1,'2018-07-13',1,'2018-07-13'),(8,93,1,1,'2018-07-17',NULL,NULL),(8,94,2,1,'2018-07-17',NULL,NULL),(9,105,1,1,'2018-07-17',NULL,NULL),(9,106,2,1,'2018-07-17',NULL,NULL);

--
-- Table structure for table `COURSE`
--

CREATE TABLE `COURSE` (
  `COURSE_ID` int(11) NOT NULL AUTO_INCREMENT,
  `COURSE_TITLE` varchar(128) DEFAULT NULL,
  `COURSE_NBR` int(11) DEFAULT NULL,
  `COURSE_DESC` varchar(256) DEFAULT NULL,
  `CREATE_USER_ID` int(11) NOT NULL,
  `CREATE_DT` date NOT NULL,
  `MODIFY_USER_ID` int(11) DEFAULT NULL,
  `MODIFY_DT` date DEFAULT NULL,
  PRIMARY KEY (`COURSE_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `COURSE`
--

INSERT INTO `COURSE` VALUES (1,'sdf gfsdg',454545,'g sdfgd f',1,'2018-07-11',NULL,NULL),(2,'sdf gsdfg sdf',3434343,'sdf gsdfg',1,'2018-07-11',NULL,NULL),(3,'sd fgsfdg',454545,'sdf gsdf',1,'2018-07-11',NULL,NULL),(4,'sdf gsdg sd',454545,'f gdsf gsfd gfsd',1,'2018-07-11',NULL,NULL),(5,'dsfgsd gdg',5454545,'sdf gsd fgsd g',1,'2018-07-11',NULL,NULL),(6,'sfd gsfdsdf',66767676,'sd fgsdf gsfdg',1,'2018-07-11',NULL,NULL),(7,'sf dgsdg sd',565656,'dsfgsdf g',1,'2018-07-11',NULL,NULL),(8,'sfd gsfdgsdfg',787878,'sdf gsdfg sdfg',1,'2018-07-11',NULL,NULL),(9,'sd fgsfdg sdg',5656656,'dsgsdfg',1,'2018-07-11',NULL,NULL),(10,'sdfg sdgsfd g',23234234,'s dgdsf gsdfg',1,'2018-07-11',NULL,NULL),(11,'asdfadsfasdfadfs',564646,'sda asdfasdf',1,'2018-07-11',NULL,NULL),(12,'ad sfasdfadsfasdf',57676867,'sad fadsfadsf',1,'2018-07-11',NULL,NULL),(13,'d sfgsdf gsdf',56464645,'sd fas dfsdaf',1,'2018-07-11',NULL,NULL),(14,'dfsgsdf gfds',54645666,'sda fs gdsfg dfsg',1,'2018-07-11',NULL,NULL),(15,'sda fadsf df',45645654,'sadfasd fadsf',1,'2018-07-11',NULL,NULL),(16,'adsf dasfdasf',67678768,'a sdfasd fdsaf',1,'2018-07-11',NULL,NULL),(17,'fdsgsdf gdfs gdfs gdfs',564564,'sfdsg dfs gdfsg sfdgfsd',1,'2018-07-11',NULL,NULL),(18,'dgsd gfds gfdsg sdfgsfd',34345345,'ds gsdf gfsdg sdfg',1,'2018-07-11',NULL,NULL),(19,'dsf gsd gsdfg sdf',6456464,'s fs gdfs gdfs gsdfg',1,'2018-07-11',NULL,NULL),(20,'sdgsdf gsdf gsfdgdg',54545454,'dsfgsdf gsfd gfsdgsfdg',1,'2018-07-11',NULL,NULL),(21,'dfsgsdf gdsfgsdfg',76575677,'sfgfds gdfs gfds g',1,'2018-07-11',NULL,NULL),(22,'f dgfdg fdg fdgfdg',56565666,'d fgsdf fdsg fdg fdg',1,'2018-07-11',NULL,NULL),(23,'d fgdf gdfg dfgdf',657677,'s dfs gdfs gdfs gfd',1,'2018-07-11',NULL,NULL),(24,'d fgfd gfdg fdg',677676,'dfgsd gdsf gdfg fdg',1,'2018-07-11',NULL,NULL),(25,'Course Title1',5643,'child welfare course titles1',1,'2018-07-12',1,'2018-07-12'),(26,'Course Title2',7865,'child welfare course titles2',1,'2018-07-12',1,'2018-07-12'),(27,'Course Title1',4576,'Test Description1',1,'2018-07-12',1,'2018-07-12'),(28,'Course Title2',8934,'Test Description2',1,'2018-07-12',1,'2018-07-12'),(29,'Course Title3',9845,'Test Description3',1,'2018-07-12',1,'2018-07-12'),(30,'Course Title4',9823,'Test Description4',1,'2018-07-12',1,'2018-07-12'),(31,'Course Title5',6754,'Test Description5',1,'2018-07-12',1,'2018-07-12'),(32,'Course Title6',5555,'Test Description6',1,'2018-07-12',1,'2018-07-12'),(33,'Course Title7',8888,'Test Description7',1,'2018-07-12',1,'2018-07-12'),(34,'Course Title8',9999,'Test Description8',1,'2018-07-12',1,'2018-07-12'),(35,'Course Title1',7856,'Test Description1',1,'2018-07-12',1,'2018-07-12'),(36,'Course Title2',8956,'Test Description2',1,'2018-07-12',1,'2018-07-12'),(37,'Course Title3',2354,'Test Description3',1,'2018-07-12',1,'2018-07-12'),(38,'Course Title4',9999,'Test Description4',1,'2018-07-12',1,'2018-07-12'),(39,'Course Title1',6587,'child welfare course titles1',1,'2018-07-12',1,'2018-07-12'),(40,'Course Title2',4365,'child welfare course titles2',1,'2018-07-12',1,'2018-07-12'),(41,'Course Title1',5555,'Test Description1',1,'2018-07-12',1,'2018-07-12'),(42,'Course Title2',4566,'Test Description2',1,'2018-07-12',1,'2018-07-12'),(43,'Course Title3',7899,'Test Description3',1,'2018-07-12',1,'2018-07-12'),(44,'Course Title4',7655,'Test Description4',1,'2018-07-12',1,'2018-07-12'),(45,'Course Title5',4444,'Test Description5',1,'2018-07-12',1,'2018-07-12'),(46,'Course Title6',7689,'Test Description6',1,'2018-07-12',1,'2018-07-12'),(47,'Course Title7',4536,'Test Description7',1,'2018-07-12',1,'2018-07-12'),(48,'Course Title8',9999,'Test Description8',1,'2018-07-12',1,'2018-07-12'),(49,'Course Title1',5555,'Test Description1',1,'2018-07-12',1,'2018-07-12'),(50,'Course Title2',4598,'Test Description2',1,'2018-07-12',1,'2018-07-12'),(51,'Course Title3',6798,'Test Description3',1,'2018-07-12',1,'2018-07-12'),(52,'Course Title4',7654,'Test Description4',1,'2018-07-12',1,'2018-07-12'),(53,'Course Title1',5467,'child welfare course titles1',1,'2018-07-13',1,'2018-07-13'),(54,'Course Title2',8769,'child welfare course titles2',1,'2018-07-13',1,'2018-07-13'),(55,'Course Title1',5467,'Course Description1',1,'2018-07-13',1,'2018-07-13'),(56,'Course Title2',7869,'Course Description2',1,'2018-07-13',1,'2018-07-13'),(57,'Course Title3',4456,'Course Description3',1,'2018-07-13',1,'2018-07-13'),(58,'Course Title4',6798,'Course Description4',1,'2018-07-13',1,'2018-07-13'),(59,'Course Title5',3456,'Course Description5',1,'2018-07-13',1,'2018-07-13'),(60,'Course Title6',7809,'Course Description6',1,'2018-07-13',1,'2018-07-13'),(61,'Course Title7',4564,'Course Description7',1,'2018-07-13',1,'2018-07-13'),(62,'Course Title8',1276,'Course Description8',1,'2018-07-13',1,'2018-07-13'),(63,'Course Title1',8733,'Course Description1',1,'2018-07-13',1,'2018-07-13'),(64,'Course Title2',8756,'Course Description2',1,'2018-07-13',1,'2018-07-13'),(65,'Course Title3',4576,'Course Description3',1,'2018-07-13',1,'2018-07-13'),(66,'Course Title4',6578,'Course Description4',1,'2018-07-13',1,'2018-07-13'),(67,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13'),(68,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13'),(69,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13'),(70,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13'),(71,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13'),(72,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13'),(73,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13'),(74,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13'),(75,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13'),(76,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13'),(77,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13'),(78,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13'),(79,'Course Title11',68841,'child welfare course titles11',1,'2018-07-13',1,'2018-07-13'),(80,'Course Title21',65481,'child welfare course titles21',1,'2018-07-13',1,'2018-07-13'),(81,'Course Title11',12001,'pppp1',1,'2018-07-13',1,'2018-07-13'),(82,'Course Title21',99991,'uuuuuu1',1,'2018-07-13',1,'2018-07-13'),(83,'Course Title31',88881,'yyyyyy1',1,'2018-07-13',1,'2018-07-13'),(84,'Course Title41',77771,'tttt1',1,'2018-07-13',1,'2018-07-13'),(85,'Course Title51',66661,'rrrrrr1',1,'2018-07-13',1,'2018-07-13'),(86,'Course Title61',55551,'wwww1',1,'2018-07-13',1,'2018-07-13'),(87,'Course Title71',46661,'qqqq1',1,'2018-07-13',1,'2018-07-13'),(88,'Course Title81',54671,'eeeeeee1',1,'2018-07-13',1,'2018-07-13'),(89,'Course Title11',65441,'swsswsw1',1,'2018-07-13',1,'2018-07-13'),(90,'Course Title21',89701,'dddeeddede1',1,'2018-07-13',1,'2018-07-13'),(91,'Course Title31',76431,'frfrfrfrffrfr1',1,'2018-07-13',1,'2018-07-13'),(92,'Course Title41',56781,'vgtgtgtgtgtgt1',1,'2018-07-13',1,'2018-07-13'),(93,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(94,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(95,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(96,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(97,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(98,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(99,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(100,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(101,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(102,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(103,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(104,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(105,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(106,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(107,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(108,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(109,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(110,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(111,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(112,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(113,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(114,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(115,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(116,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL);

--
-- Table structure for table `COURSE_TYPE`
--

CREATE TABLE `COURSE_TYPE` (
  `COURSE_TYPE_ID` int(11) NOT NULL AUTO_INCREMENT,
  `COURSE_TYPE` varchar(128) NOT NULL,
  `COMPETENCY_DESC` varchar(256) DEFAULT NULL,
  `FIELD_PLACEMENT_IND` char(1) DEFAULT NULL,
  `CREATE_USER_ID` int(11) NOT NULL,
  `CREATE_DT` date NOT NULL,
  `MODIFY_USER_ID` int(11) DEFAULT NULL,
  `MODIFY_DT` date DEFAULT NULL,
  PRIMARY KEY (`COURSE_TYPE_ID`),
  UNIQUE KEY `COURSE_TYPE` (`COURSE_TYPE`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `COURSE_TYPE`
--

INSERT INTO `COURSE_TYPE` VALUES (1,'Complex Cognitive Skills','Course/program activities that promote reflective thought, critical thinking, cultural competency, quantitative reasoning and intellectual flexibility.',NULL,1,'2018-06-27',NULL,NULL),(2,'Ethical Practice in Child Walfare','Course/program activities that promote ethical standards and values for public child welfare practice.',NULL,1,'2018-06-27',NULL,NULL),(3,'Knowledge Acquisition','Course/program activities that promote student mastery of child welfare knowledge on principles, policies, practice and procedures as taught in the classroom setting. ',NULL,1,'2018-06-27',NULL,NULL),(4,'Practical Competence in Public Child Welfare institutions','Program activities that promote selfawareness, Self-reflection, and understanding of institutional power and authority',NULL,1,'2018-06-27',NULL,NULL),(5,'Academic Achievement','Program activities that assist students\'to maintain required minimum grades for each course in the curriculum.',NULL,1,'2018-06-27',NULL,NULL),(6,'Persistence/ Retention','Program activities that support and guidance to students from enrollment to successful graduation.',NULL,1,'2018-06-27',NULL,NULL),(7,'Incorporation of DFCS New Worker Training Materials','Describe how the new worker training matetials will be used to provide enhanced learning for Title IV-E Students.',NULL,1,'2018-06-27',NULL,NULL),(8,'Knowledge Acquisitions','Course/Program activities that promote student mastery of child welfare knowledge on principles, policies, policies, practice and procedures as taught in the field setting.','Y',1,'2018-06-27',NULL,NULL),(9,'Field Practice Competence','Courses/activities that integrate curriculum knowledge with practice application.','Y',1,'2018-06-27',NULL,NULL),(10,'Additional Experiences','Describe other unique experiences, outside of the classroom, that will be offered to Title IV-E students (e.g, individual/group coaching, mentoring, tutoring, field student chat rooms, etc.) ','Y',1,'2018-06-27',NULL,NULL);

--
-- Table structure for table `CURRICULUM_COMPETENCY`
--

CREATE TABLE `CURRICULUM_COMPETENCY` (
  `CID` int(11) NOT NULL AUTO_INCREMENT,
  `PROP_ID` int(11) NOT NULL,
  `COURSE_TYPE_ID` int(11) DEFAULT NULL,
  `COURSE_ID` int(11) DEFAULT NULL,
  `CREATE_USER_ID` int(11) NOT NULL,
  `CREATE_DT` date NOT NULL,
  `MODIFY_USER_ID` int(11) DEFAULT NULL,
  `MODIFY_DT` date DEFAULT NULL,
  UNIQUE KEY `COURSE_ID` (`COURSE_ID`),
  UNIQUE KEY `unique_index` (`COURSE_ID`,`COURSE_TYPE_ID`),
  KEY `CID` (`CID`),
  KEY `COURSE_TYPE_ID` (`COURSE_TYPE_ID`) USING BTREE,
  KEY `PROP_ID` (`PROP_ID`) USING BTREE,
  CONSTRAINT `FK_CRRCL_CMPTCY_PROP_FK` FOREIGN KEY (`PROP_ID`) REFERENCES `PROPOSAL` (`PROP_ID`),
  CONSTRAINT `FK_CRRCL_COMP_COURSE_FK` FOREIGN KEY (`COURSE_ID`) REFERENCES `COURSE` (`COURSE_ID`),
  CONSTRAINT `FK_CRRCL_COMP_COURSE_TYPE_FK` FOREIGN KEY (`COURSE_TYPE_ID`) REFERENCES `COURSE_TYPE` (`COURSE_TYPE_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CURRICULUM_COMPETENCY`
--

INSERT INTO `CURRICULUM_COMPETENCY` VALUES (1,1,1,3,1,'2018-07-11',NULL,NULL),(2,1,2,4,1,'2018-07-11',NULL,NULL),(3,1,3,5,1,'2018-07-11',NULL,NULL),(4,1,4,6,1,'2018-07-11',NULL,NULL),(5,1,5,7,1,'2018-07-11',NULL,NULL),(6,1,6,8,1,'2018-07-11',NULL,NULL),(7,1,7,9,1,'2018-07-11',NULL,NULL),(8,1,8,10,1,'2018-07-11',NULL,NULL),(9,1,9,11,1,'2018-07-11',NULL,NULL),(10,1,10,12,1,'2018-07-11',NULL,NULL),(11,2,1,15,1,'2018-07-11',NULL,NULL),(12,2,2,16,1,'2018-07-11',NULL,NULL),(13,2,3,17,1,'2018-07-11',NULL,NULL),(14,2,4,18,1,'2018-07-11',NULL,NULL),(15,2,5,19,1,'2018-07-11',NULL,NULL),(16,2,6,20,1,'2018-07-11',NULL,NULL),(17,2,7,21,1,'2018-07-11',NULL,NULL),(18,2,8,22,1,'2018-07-11',NULL,NULL),(19,2,9,23,1,'2018-07-11',NULL,NULL),(20,2,10,24,1,'2018-07-11',NULL,NULL),(21,3,1,27,1,'2018-07-12',1,'2018-07-12'),(22,3,2,28,1,'2018-07-12',1,'2018-07-12'),(23,3,3,29,1,'2018-07-12',1,'2018-07-12'),(24,3,4,30,1,'2018-07-12',1,'2018-07-12'),(25,3,4,31,1,'2018-07-12',1,'2018-07-12'),(26,3,5,32,1,'2018-07-12',1,'2018-07-12'),(27,3,6,33,1,'2018-07-12',1,'2018-07-12'),(28,3,7,34,1,'2018-07-12',1,'2018-07-12'),(29,3,8,35,1,'2018-07-12',1,'2018-07-12'),(30,3,8,36,1,'2018-07-12',1,'2018-07-12'),(31,3,9,37,1,'2018-07-12',1,'2018-07-12'),(32,3,10,38,1,'2018-07-12',1,'2018-07-12'),(33,4,1,41,1,'2018-07-12',1,'2018-07-12'),(34,4,2,42,1,'2018-07-12',1,'2018-07-12'),(35,4,3,43,1,'2018-07-12',1,'2018-07-12'),(36,4,4,44,1,'2018-07-12',1,'2018-07-12'),(37,4,5,45,1,'2018-07-12',1,'2018-07-12'),(38,4,6,46,1,'2018-07-12',1,'2018-07-12'),(39,4,7,47,1,'2018-07-12',1,'2018-07-12'),(40,4,7,48,1,'2018-07-12',1,'2018-07-12'),(41,4,8,49,1,'2018-07-12',1,'2018-07-12'),(42,4,9,50,1,'2018-07-12',1,'2018-07-12'),(43,4,10,51,1,'2018-07-12',1,'2018-07-12'),(44,4,10,52,1,'2018-07-12',1,'2018-07-12'),(45,5,1,55,1,'2018-07-13',1,'2018-07-13'),(46,5,2,56,1,'2018-07-13',1,'2018-07-13'),(47,5,2,57,1,'2018-07-13',1,'2018-07-13'),(48,5,3,58,1,'2018-07-13',1,'2018-07-13'),(49,5,4,59,1,'2018-07-13',1,'2018-07-13'),(50,5,5,60,1,'2018-07-13',1,'2018-07-13'),(51,5,6,61,1,'2018-07-13',1,'2018-07-13'),(52,5,7,62,1,'2018-07-13',1,'2018-07-13'),(53,5,8,63,1,'2018-07-13',1,'2018-07-13'),(54,5,9,64,1,'2018-07-13',1,'2018-07-13'),(55,5,10,65,1,'2018-07-13',1,'2018-07-13'),(56,5,10,66,1,'2018-07-13',1,'2018-07-13'),(57,6,1,69,1,'2018-07-13',1,'2018-07-13'),(58,6,2,70,1,'2018-07-13',1,'2018-07-13'),(59,6,3,71,1,'2018-07-13',1,'2018-07-13'),(60,6,4,72,1,'2018-07-13',1,'2018-07-13'),(61,6,5,73,1,'2018-07-13',1,'2018-07-13'),(62,6,6,74,1,'2018-07-13',1,'2018-07-13'),(63,6,7,75,1,'2018-07-13',1,'2018-07-13'),(64,6,8,76,1,'2018-07-13',1,'2018-07-13'),(65,6,9,77,1,'2018-07-13',1,'2018-07-13'),(66,6,10,78,1,'2018-07-13',1,'2018-07-13'),(67,7,1,81,1,'2018-07-13',1,'2018-07-13'),(68,7,2,82,1,'2018-07-13',1,'2018-07-13'),(69,7,3,83,1,'2018-07-13',1,'2018-07-13'),(70,7,4,84,1,'2018-07-13',1,'2018-07-13'),(71,7,5,85,1,'2018-07-13',1,'2018-07-13'),(72,7,6,86,1,'2018-07-13',1,'2018-07-13'),(73,7,7,87,1,'2018-07-13',1,'2018-07-13'),(74,7,7,88,1,'2018-07-13',1,'2018-07-13'),(75,7,8,89,1,'2018-07-13',1,'2018-07-13'),(76,7,9,90,1,'2018-07-13',1,'2018-07-13'),(77,7,10,91,1,'2018-07-13',1,'2018-07-13'),(78,7,10,92,1,'2018-07-13',1,'2018-07-13'),(79,8,1,95,1,'2018-07-17',NULL,NULL),(80,8,2,96,1,'2018-07-17',NULL,NULL),(81,8,3,97,1,'2018-07-17',NULL,NULL),(82,8,4,98,1,'2018-07-17',NULL,NULL),(83,8,5,99,1,'2018-07-17',NULL,NULL),(84,8,6,100,1,'2018-07-17',NULL,NULL),(85,8,7,101,1,'2018-07-17',NULL,NULL),(86,8,8,102,1,'2018-07-17',NULL,NULL),(87,8,9,103,1,'2018-07-17',NULL,NULL),(88,8,10,104,1,'2018-07-17',NULL,NULL),(89,9,1,107,1,'2018-07-17',NULL,NULL),(90,9,2,108,1,'2018-07-17',NULL,NULL),(91,9,3,109,1,'2018-07-17',NULL,NULL),(92,9,4,110,1,'2018-07-17',NULL,NULL),(93,9,5,111,1,'2018-07-17',NULL,NULL),(94,9,6,112,1,'2018-07-17',NULL,NULL),(95,9,7,113,1,'2018-07-17',NULL,NULL),(96,9,8,114,1,'2018-07-17',NULL,NULL),(97,9,9,115,1,'2018-07-17',NULL,NULL),(98,9,10,116,1,'2018-07-17',NULL,NULL);

--
-- Table structure for table `NONE_PERSONNEL_BUDGET`
--

CREATE TABLE `NONE_PERSONNEL_BUDGET` (
  `BDGT_ID` int(11) NOT NULL AUTO_INCREMENT,
  `PROP_ID` int(11) NOT NULL,
  `BUDGET_ITEM` varchar(128) DEFAULT NULL,
  `SUMMER_BDGT_IND` char(1) DEFAULT NULL,
  `HEADING_ID` int(11) NOT NULL,
  `BUDGET_AMT` decimal(9,2) DEFAULT NULL,
  `PGM_TIME_PCT` decimal(5,2) DEFAULT NULL,
  `BUDGET_JSTFCTN` varchar(512) DEFAULT NULL,
  `CREATE_USER_ID` int(11) NOT NULL,
  `CREATE_DT` date NOT NULL,
  `MODIFY_USER_ID` int(11) DEFAULT NULL,
  `MODIFY_DT` date DEFAULT NULL,
  PRIMARY KEY (`BDGT_ID`),
  KEY `FK_PROPOSED_BDGT_HDG_FK` (`HEADING_ID`),
  KEY `PROP_ID` (`PROP_ID`) USING BTREE,
  KEY `SUMMER_BDGT_IND` (`SUMMER_BDGT_IND`) USING BTREE,
  KEY `BUDGET_ITEM` (`BUDGET_ITEM`) USING BTREE,
  CONSTRAINT `FK_PROPOSED_BDGT_HDG_FK` FOREIGN KEY (`HEADING_ID`) REFERENCES `BUDGET_HEADING` (`BH_ID`),
  CONSTRAINT `FK_PROPOSED_BDGT_PROP_FK` FOREIGN KEY (`PROP_ID`) REFERENCES `PROPOSAL` (`PROP_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=180 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `NONE_PERSONNEL_BUDGET`
--

INSERT INTO `NONE_PERSONNEL_BUDGET` VALUES (1,1,'etrertr','N',6,45454.00,55.00,'dsf gdg dfs gdfs gdfs gsdfg dfsg',1,'2018-07-11',NULL,NULL),(2,1,'ds gfd','N',6,56555.00,44.00,'dfgdfg dfs gdsf gdfs',1,'2018-07-11',NULL,NULL),(3,1,'sd fdfdf','N',7,45443.00,33.00,'sadfsad fsad fsadf sadfadsf',1,'2018-07-11',NULL,NULL),(4,1,'dfgdgdfgfg','N',7,67677.00,76.00,'df gdfg dfg dfgdfg',1,'2018-07-11',NULL,NULL),(5,1,'s dfsd fgfd','N',8,56666.00,66.00,'dfgsdf gdsf gdfs gdfsg d',1,'2018-07-11',NULL,NULL),(7,1,'dsgsd gsdfg','N',9,45656.00,44.00,'sfdsfgdfs gdfs gdfs gdfsg dfs',1,'2018-07-11',NULL,NULL),(9,1,'dfgs dfgdfs','N',10,33344.00,33.00,'dfgsgdfs gfds gfds gfds',1,'2018-07-11',NULL,NULL),(11,2,'dfgfdgfd','N',6,45453.00,22.00,'f gdfsg sfdg fsdgsfdg fsdg',1,'2018-07-11',NULL,NULL),(12,2,'dsf dsdf','N',6,56566.00,77.00,'sdfsdfsd sdf dsfdsf',1,'2018-07-11',NULL,NULL),(13,2,'sdfdfdsf','N',7,45442.00,44.00,'sa dfasd fdsaf asdfdafsd fsa',1,'2018-07-11',NULL,NULL),(15,2,'df gds gdsfg','N',8,45645.00,77.00,'g hdfg hdfg hdfg hdfg',1,'2018-07-11',NULL,NULL),(16,2,'gdfh gfdhgfd','N',8,56567.00,66.00,'g hdfg hdfg hdfg hdfg',1,'2018-07-11',NULL,NULL),(17,2,'dfgdfgffg','N',9,45454.00,33.00,'dgfdsf gdfs gdfs gdfs gsfdg',1,'2018-07-11',NULL,NULL),(19,2,'ads fasdf adsf','N',10,56566.00,77.00,'sadfsdf asf sadfadsf',1,'2018-07-11',NULL,NULL),(21,2,'sdfsadf','Y',6,34544.00,33.00,'gdfs gdf gdfs gfds',1,'2018-07-11',NULL,NULL),(22,2,'dsfsdf','Y',6,35453.00,22.00,'sdfsdfds',1,'2018-07-11',NULL,NULL),(23,2,'sdfasdf','Y',7,34345.00,44.00,'fsd gfds gdfs gfds',1,'2018-07-11',NULL,NULL),(24,2,'dsfsdfs','Y',7,56576.00,66.00,'dsf gdsfgdf',1,'2018-07-11',NULL,NULL),(25,2,'adsf adsfdafs','Y',8,64443.00,33.00,'sa dfasd fadsf dsaf',1,'2018-07-11',NULL,NULL),(26,2,'gdsf gdsf gsdfg','Y',8,33433.00,22.00,'sa dfasd fadsf dsaf',1,'2018-07-11',NULL,NULL),(27,2,'sdfdsfd','Y',9,45454.00,12.00,'sa dfasd fasdf asdf adsffd',1,'2018-07-11',NULL,NULL),(28,2,'s dfsadf asdf','Y',9,34343.00,22.00,'sa dfasd fasdf asdf adsffd',1,'2018-07-11',NULL,NULL),(29,2,'sdfdsfdf','Y',10,45443.00,22.00,'s dfsda fasd fasdf',1,'2018-07-11',NULL,NULL),(30,2,'d sgfsd gs','Y',10,54555.00,44.00,'s dfsda fasd fasdf',1,'2018-07-11',NULL,NULL),(31,3,'tytty yuiyu','N',6,78000.00,67.00,NULL,1,'2018-07-12',1,'2018-07-12'),(32,3,'uertt nnvbn','N',6,86400.00,34.00,NULL,1,'2018-07-12',1,'2018-07-12'),(33,3,'xvcx bnmb','N',7,99000.00,56.00,NULL,1,'2018-07-12',1,'2018-07-12'),(34,3,'efsdf gfhgfhf','N',7,55000.00,89.00,NULL,1,'2018-07-12',1,'2018-07-12'),(35,3,'wewrew tyty','N',8,79000.00,78.00,NULL,1,'2018-07-12',1,'2018-07-12'),(36,3,'iyuiyu ertret','N',8,89000.00,45.00,NULL,1,'2018-07-12',1,'2018-07-12'),(37,3,'adsad fdgdfg','N',8,65700.00,34.00,NULL,1,'2018-07-12',1,'2018-07-12'),(38,3,'iuouiou ererew','N',9,87500.00,67.00,NULL,1,'2018-07-12',1,'2018-07-12'),(39,3,'yuiyi jhjhj','N',9,74000.00,23.00,NULL,1,'2018-07-12',1,'2018-07-12'),(40,3,'dfdgfd hgjhgjg','N',9,67000.00,37.00,NULL,1,'2018-07-12',NULL,NULL),(41,3,'erewr tyrty','N',10,76800.00,45.00,NULL,1,'2018-07-12',1,'2018-07-12'),(42,3,'werewr ytuytut','N',10,98500.00,98.00,NULL,1,'2018-07-12',1,'2018-07-12'),(43,3,'xcxzc vbvbnvb','N',10,45600.00,45.00,NULL,1,'2018-07-12',1,'2018-07-12'),(44,4,'reertre tuuytu','N',6,75000.00,75.00,'xjshdcs jqwhdjwqd',1,'2018-07-12',1,'2018-07-12'),(45,4,'erwrw dssfdsf','N',6,89500.00,67.00,'cdss eeeee',1,'2018-07-12',1,'2018-07-12'),(47,4,'xcvcxv bvnbm','N',7,74000.00,23.00,'vvvvv bbbbbbbb',1,'2018-07-12',1,'2018-07-12'),(50,4,'asdasd ddfgdgd','N',8,66000.00,78.00,'zxcxzcz vcbvbnbvn',1,'2018-07-12',1,'2018-07-12'),(51,4,'cxxzc bvnvnvb','N',8,78000.00,65.00,'zxcxzcz vcbvbnbvn',1,'2018-07-12',1,'2018-07-12'),(53,4,'ouiouiu asdasd','N',9,75000.00,45.00,'wrewrw tyyuytu',1,'2018-07-12',1,'2018-07-12'),(54,4,'bzvczxc ,mnmbnb','N',9,45000.00,32.00,'wrewrw tyyuytu',1,'2018-07-12',1,'2018-07-12'),(56,4,'dsfdfsf jghjhgj','N',10,56000.00,45.00,'dfdg fhgfh',1,'2018-07-12',1,'2018-07-12'),(57,4,'qwewr utyuuty','N',10,76500.00,76.00,'dfdg fhgfh',1,'2018-07-12',1,'2018-07-12'),(59,4,'qwewqe trytry','Y',6,99000.00,78.00,'xzcxzc vbnvbnbv',1,'2018-07-12',1,'2018-07-12'),(61,4,'fdasfads kjlkl','Y',7,88000.00,23.00,'rtytr uytuytu',1,'2018-07-12',1,'2018-07-12'),(63,4,'ewrewr btrytry','Y',8,88000.00,45.00,'qeqe oiuoiu',1,'2018-07-12',1,'2018-07-12'),(65,4,'tuytu uiyuiy','Y',9,88000.00,78.00,'fdfdf khjhj',1,'2018-07-12',1,'2018-07-12'),(67,4,'vnvbn mnbmnbm','Y',10,88000.00,94.00,'dsfsdf fdgdfgfd',1,'2018-07-12',1,'2018-07-12'),(69,4,'zxzxzxc cvbvcbcvb','Y',7,88000.00,65.00,'xcxzc nbmnbmb',1,'2018-07-12',1,'2018-07-12'),(70,4,'sadsada dfgfdg','Y',7,67000.00,67.00,'xcxzc nbmnbmb',1,'2018-07-12',1,'2018-07-12'),(71,4,'xsadvs esrewrw','Y',9,88000.00,89.00,'fdfdf khjhj',1,'2018-07-12',1,'2018-07-12'),(72,4,'esdfsf fghgfhf','N',7,77000.00,67.00,'vvvvv bbbbbbbb',1,'2018-07-12',1,'2018-07-12'),(73,5,'eree tytyu','N',6,44000.00,56.00,'etreter ytry',1,'2018-07-13',1,'2018-07-13'),(76,5,'xzcxzc vbvnbvn','N',7,44000.00,66.00,'ffff kkkkkk',1,'2018-07-13',1,'2018-07-13'),(82,5,'qwewqe etretretre','N',9,44000.00,56.00,'sdfdsfsd fdgfdg',1,'2018-07-13',1,'2018-07-13'),(84,5,'yuiyuiy hjkjhkjk','N',9,44000.00,66.00,'sdfdsfsd fdgfdg',1,'2018-07-13',1,'2018-07-13'),(85,5,'zxcxzc bvbvbc','N',10,44000.00,88.00,'sdfdsf gfhgfhgf',1,'2018-07-13',1,'2018-07-13'),(88,5,'ewrwre trtuytu','Y',6,77000.00,57.00,'iiiiiiii',1,'2018-07-13',1,'2018-07-13'),(91,5,'sdsfs gfhgfhf','Y',7,77000.00,45.00,'bbbbbbb',1,'2018-07-13',1,'2018-07-13'),(94,5,'wrewrw trytryr','Y',8,77000.00,78.00,'eeeeeee',1,'2018-07-13',1,'2018-07-13'),(97,5,'fdsfsdf hgfhgfh','Y',9,77000.00,83.00,'yyyyyyyy',1,'2018-07-13',1,'2018-07-13'),(100,5,'ewtret tuytuty','Y',10,77000.00,45.00,'tttttt',1,'2018-07-13',1,'2018-07-13'),(103,6,'sdfdsf fhfhg','N',6,77800.00,56.00,'jghjhg trytry',1,'2018-07-13',1,'2018-07-13'),(106,6,'ewrewr uytuytut','N',7,65000.00,56.00,'ghjhgj hjkllkj',1,'2018-07-13',1,'2018-07-13'),(109,6,'asdsa hfghgh','N',8,56000.00,34.00,'sdfdsf ghjjhgj',1,'2018-07-13',1,'2018-07-13'),(111,6,'cvcxv nbmbm','N',9,79000.00,34.00,'ewrewr tyytuytu',1,'2018-07-13',1,'2018-07-13'),(114,6,'cxvcxv vbnbvn','N',10,57000.00,45.00,'dsfdfb ghgfh',1,'2018-07-13',1,'2018-07-13'),(117,6,'werwer rtytryrt','Y',6,56000.00,34.00,'ggggg',1,'2018-07-13',1,'2018-07-13'),(120,6,'bvcbcb','Y',7,45600.00,23.00,'iiiiiii',1,'2018-07-13',1,'2018-07-13'),(123,6,'dsfdsf fghgfhf','Y',8,58000.00,23.00,'uuuuuu',1,'2018-07-13',1,'2018-07-13'),(126,6,'sdfsdf gfhfghfg','Y',9,54000.00,67.00,'yyyyyyy',1,'2018-07-13',1,'2018-07-13'),(129,6,'sdfsfsf ghhgh','Y',10,77000.00,67.00,'ttttt',1,'2018-07-13',1,'2018-07-13'),(133,7,'wrre ytutyu','N',6,88000.00,45.00,'uuuuuu',1,'2018-07-13',1,'2018-07-13'),(134,7,'sfdsfds gfhgfhf','N',6,88000.00,78.00,'yyyyyyy',1,'2018-07-13',1,'2018-07-13'),(135,7,'xcvcxv bnbm','N',6,77000.00,55.00,'tttttt',1,'2018-07-13',1,'2018-07-13'),(136,7,'rytryur uioiuoi','N',7,88000.00,56.00,'rrrrrrrr',1,'2018-07-13',1,'2018-07-13'),(137,7,'cxvcxv','N',7,88000.00,89.00,'eee',1,'2018-07-13',1,'2018-07-13'),(138,7,'jkljklj','N',7,88000.00,90.00,'rewr trytrytr',1,'2018-07-13',1,'2018-07-13'),(139,7,'sdfdsf gfjhgjg','N',8,88000.00,45.00,'zxcxzc vnbbvnbv',1,'2018-07-13',1,'2018-07-13'),(140,7,'xvcxv vbnbn','N',8,88000.00,87.00,'zxcxzc vnbbvnbv',1,'2018-07-13',1,'2018-07-13'),(141,7,'hjkhjkh','N',8,88000.00,90.00,'zxcxzc vnbbvnbv',1,'2018-07-13',1,'2018-07-13'),(142,7,'vbcvb vnvbnv','N',9,88000.00,34.00,'sfsd fhfghgf',1,'2018-07-13',1,'2018-07-13'),(143,7,'tyutyu','N',9,88000.00,43.00,'sfsd fhfghgf',1,'2018-07-13',1,'2018-07-13'),(144,7,'dfgfdg','N',9,88000.00,23.00,'sfsd fhfghgf',1,'2018-07-13',1,'2018-07-13'),(145,7,'cvc bnmnb','N',10,88000.00,78.00,'ertret trytry',1,'2018-07-13',1,'2018-07-13'),(146,7,'nbvnv cbcvbc','N',10,88000.00,23.00,'ertret trytry',1,'2018-07-13',1,'2018-07-13'),(147,7,'tyutyut hjhkhjk','N',10,88000.00,77.00,'ertret trytry',1,'2018-07-13',1,'2018-07-13'),(148,7,'etret tyuytu','Y',6,56000.00,43.00,'aaaaa',1,'2018-07-13',1,'2018-07-13'),(150,7,'xzcxc vbnbvn','Y',6,34000.00,78.00,'ooooooo',1,'2018-07-13',1,'2018-07-13'),(151,7,'xcvxcv vbnvbn','Y',7,77700.00,67.00,'iiiiiii',1,'2018-07-13',1,'2018-07-13'),(154,7,'tryrty yuiyuiy','Y',8,67000.00,34.00,'tttttt',1,'2018-07-13',1,'2018-07-13'),(155,7,'fdsafsa gjhgjhg','Y',8,45000.00,67.00,'tttttt',1,'2018-07-13',1,'2018-07-13'),(156,7,'cxvxc vbnvn','Y',8,57800.00,32.00,'tttttt',1,'2018-07-13',1,'2018-07-13'),(157,7,'dsfds gfhfhf','Y',9,67000.00,67.00,'rrrrrrr',1,'2018-07-13',1,'2018-07-13'),(158,7,'xcvcxv vnbvnv','Y',9,45000.00,43.00,'rrrrrrr',1,'2018-07-13',1,'2018-07-13'),(159,7,'ewrewr yuytut','Y',9,23000.00,23.00,'rrrrrrr',1,'2018-07-13',1,'2018-07-13'),(160,7,'iuoiuo jkhjkh','Y',10,75000.00,45.00,'eeeeee',1,'2018-07-13',1,'2018-07-13'),(163,5,NULL,'N',6,NULL,NULL,'etreter ytry',1,'2018-07-13',NULL,NULL),(164,8,NULL,'N',6,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(165,8,NULL,'N',7,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(166,8,NULL,'N',8,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(167,8,NULL,'N',9,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(168,8,NULL,'N',10,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(169,9,NULL,'N',6,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(170,9,NULL,'N',6,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(171,9,NULL,'N',7,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(172,9,NULL,'N',8,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(173,9,NULL,'N',9,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(174,9,NULL,'N',10,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(175,9,NULL,'Y',6,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(176,9,NULL,'Y',7,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(177,9,NULL,'Y',8,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(178,9,NULL,'Y',9,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(179,9,NULL,'Y',10,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL);

--
-- Table structure for table `PERSON`
--

CREATE TABLE `PERSON` (
  `PID` int(11) NOT NULL AUTO_INCREMENT,
  `FULL_NM` varchar(90) NOT NULL,
  `FIRST_NM` varchar(30) DEFAULT NULL,
  `MIDDLE_NM` varchar(30) DEFAULT NULL,
  `LAST_NM` varchar(30) DEFAULT NULL,
  `SUFFIX` varchar(10) DEFAULT NULL,
  `EMAIL` varchar(50) DEFAULT NULL,
  `PHONE_NBR` varchar(11) DEFAULT NULL,
  `PHONE_EXT` int(11) DEFAULT NULL,
  `ROLE` varchar(25) DEFAULT NULL,
  `ADDR_LN_1` varchar(50) DEFAULT NULL,
  `ADDR_LN_2` varchar(20) DEFAULT NULL,
  `CITY` varchar(30) DEFAULT NULL,
  `STATE_ABBREV` varchar(2) DEFAULT NULL,
  `CREATE_USER_ID` int(11) NOT NULL,
  `CREATE_DT` date NOT NULL,
  `MODIFY_USER_ID` int(11) DEFAULT NULL,
  `MODIFY_DT` date DEFAULT NULL,
  `USER_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`PID`),
  UNIQUE KEY `PID` (`PID`),
  KEY `FK_PERSON_USER_FK` (`USER_ID`),
  KEY `FULL_NM` (`FULL_NM`) USING BTREE,
  CONSTRAINT `FK_PERSON_USER_FK` FOREIGN KEY (`USER_ID`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=439 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `PERSON`
--

INSERT INTO `PERSON` VALUES (50,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-27',NULL,NULL,NULL),(51,' SOMEONE1','SOME',NULL,'ONE1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-27',NULL,NULL,NULL),(52,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-27',NULL,NULL,NULL),(53,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-27',NULL,NULL,NULL),(54,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-27',NULL,NULL,NULL),(55,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-27',NULL,NULL,NULL),(56,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-27',NULL,NULL,NULL),(57,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-27',NULL,NULL,NULL),(58,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-28',NULL,NULL,NULL),(59,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-28',NULL,NULL,NULL),(60,'ewd ','ewd',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-28',NULL,NULL,NULL),(61,'weded ewded','weded',NULL,'ewded',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-28',NULL,NULL,NULL),(62,'George','George',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-28',1,'2018-06-29',NULL),(63,'Stephen','Stephen',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-28',1,'2018-06-29',NULL),(64,'Julie','Julie',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-28',1,'2018-06-29',NULL),(65,'asha raj','asha',NULL,'raj',NULL,'asha@gmail.com','87873823568',NULL,NULL,'MR road','600071','chennai','Ta',1,'2018-06-28',1,'2018-06-29',NULL),(66,'arthi rai','arthi',NULL,'rai',NULL,'arthi@gmail.com','4554535',NULL,NULL,'anna salai','600002','chennai','Ta',1,'2018-06-28',1,'2018-06-29',NULL),(67,'Thilaga N','Thilaga',NULL,'N',NULL,'thilaga_eccotitle@gmail.com','(345)356-35',NULL,NULL,'t nagar','600001','chennai','Ta',1,'2018-06-28',1,'2018-06-29',NULL),(68,'Kumar rai','Kumar',NULL,'rai',NULL,'kumar@gmail.com','7890909',NULL,NULL,'anna nagaer','600002','chennai','Ta',1,'2018-06-28',1,'2018-06-29',NULL),(69,'David Arul','David Arul',NULL,'Arul',NULL,'davisarul_rajecco@gmail.com','(235)567-34',NULL,NULL,'t nagar','600001','chennai','Ta',1,'2018-06-28',1,'2018-06-29',NULL),(70,'Suresh rai','Suresh rai',NULL,'rai',NULL,'suresh@gmail.com','3465764',NULL,NULL,'t nagar','600001','chennai','Ta',1,'2018-06-28',1,'2018-06-29',NULL),(72,'Rajesh lilly','Rajesh lilly',NULL,'lilly',NULL,'rajesh_lillyEcco@gmail.com','6739787',NULL,NULL,'1/26, gandhi  road, ariyur','600032','vellore','Ta',1,'2018-06-28',1,'2018-06-29',NULL),(73,'Kumar rai','Kumar rai',NULL,'rai',NULL,'kumar@gmail.com','7890909',NULL,NULL,'1/26, gandhi  road, ariyur','632055','vellore','Ta',1,'2018-06-28',1,'2018-06-29',NULL),(74,'Abdul hasan','Abdul hasan',NULL,'hasan',NULL,'abdulha@gmail.com','2344456',NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-28',1,'2018-06-29',NULL),(75,'abdullah ali','abdullah ali',NULL,'ali',NULL,'aliabdula@gmail.com','6839437',NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-28',1,'2018-06-29',NULL),(76,'fasd fadsf','fasd fadsf',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-28',NULL,NULL,NULL),(77,'sa dasdfads','sa dasdfads',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-28',NULL,NULL,NULL),(78,'sda fafdfd','sda fafdfd',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-28',NULL,NULL,NULL),(79,'adhi sekar','adhi',NULL,'sekar',NULL,'adhi@gmail.com','3245678',NULL,NULL,'t nagar','600023','chennai','Ge',1,'2018-06-29',1,'2018-06-29',NULL),(80,'Ranbir Singh','Ranbir',NULL,'Singh',NULL,'ranbir@gmail.com','(345) 567-3',NULL,NULL,'I-Address1','789432','Atlanda','Ge',1,'2018-06-29',1,'2018-06-29',NULL),(81,'Test test','Test',NULL,'test',NULL,'sadsads@gmail.com','34543543543',NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-29',1,'2018-06-29',NULL),(82,'admin contact','admin',NULL,'contact',NULL,'sddsfds@dfds.com','6576576575',NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-29',1,'2018-06-29',NULL),(83,'Augusta Jimmy','Augusta',NULL,'Jimmy',NULL,'augusta_jimmy@gmail.com','(567) 345-3',NULL,NULL,'No-101, Porchukkal Street','6798','Honolulu','Ha',1,'2018-06-29',1,'2018-06-29',NULL),(84,'Augusta Roshan','Augusta',NULL,'Roshan',NULL,'augusta_roshan@gmail.com','(365) 345-7',NULL,NULL,'No-211, city-apartment','2354','Honolulu','Ha',1,'2018-06-29',1,'2018-06-29',NULL),(85,'Augusta Mark','Augusta',NULL,'Mark',NULL,'mark_augusta@gmail.com','(789) 235-4',NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-29',1,'2018-06-29',NULL),(86,'Admin Test','Admin',NULL,'Test',NULL,'test_adminecco@gmail.com','(564) 347-6',NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-29',1,'2018-06-29',NULL),(87,'Kodi Bang','Kodi',NULL,'Bang',NULL,'kodi_fort@gmail.com','(345)456-67',NULL,NULL,'Con-Address1','568743','Des Moines','Io',1,'2018-06-29',1,'2018-06-29',NULL),(88,'Feng Teng Shan Shan','Feng Teng',NULL,'Shan Shan',NULL,'feng_shan@fort.com','(234)456-35',NULL,NULL,'Ins_Address1','236535','Des Moines','Io',1,'2018-06-29',1,'2018-06-29',NULL),(89,'Julie jorge','Julie',NULL,'jorge',NULL,'julie_jorge@gmail.com','354354353',NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-29',1,'2018-06-29',NULL),(90,'Mirsha Hakeem','Mirsha',NULL,'Hakeem',NULL,'mirsha_hakeem@gmail.com','24324435465',NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-29',1,'2018-06-29',NULL),(91,'Edward Bella','Edward',NULL,'Bella',NULL,'bellaEdward_maridian@gmail.com','(453)234-23',NULL,NULL,'No-278, Con-street1','457665','Detroit','Mi',1,'2018-06-29',1,'2018-06-29',NULL),(92,'Jack Rosali','Jack',NULL,'Rosali',NULL,'rosalin_jackups@gmail.com','(222)349-34',NULL,NULL,'No-345, ins-Address1','346578','Detroit','Mi',1,'2018-06-29',1,'2018-06-29',NULL),(93,'Marry jorge','Marry',NULL,'jorge',NULL,'jorge_marry_georgia@gmail.com','(345)345-24',NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-29',1,'2018-06-29',NULL),(94,'Kevin Paul','Kevin',NULL,'Paul',NULL,'georgia2kevin_paul@gmail.com','(456)456-45',NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-29',1,'2018-06-29',NULL),(95,'Faculty NAme','Faculty NAme',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-29',NULL,NULL,NULL),(96,'IV-E Teaching Staff Name','IV-E Teaching Staff Name',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-29',NULL,NULL,NULL),(97,'Administrative Staff Name','Administrative Staff Name',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-29',NULL,NULL,NULL),(98,'Staff Name2','Staff Name2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-29',NULL,NULL,NULL),(99,'Faculty Name','Faculty Name',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-29',NULL,NULL,NULL),(100,'Faculty2','Faculty2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-29',NULL,NULL,NULL),(101,'IV-E Teaching Staff Name','IV-E Teaching Staff Name',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-29',NULL,NULL,NULL),(102,'Administrative Staff Name','Administrative Staff Name',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-29',1,'2018-06-29',NULL),(103,'Administrative Staff Name2','Administrative Staff Name2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-29',1,'2018-06-29',NULL),(104,'Faculty Name1','Faculty Name1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-29',1,'2018-06-29',NULL),(105,'Faculty Name2','Faculty Name2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-29',1,'2018-06-29',NULL),(106,'IV-E Teaching Staff Name','IV-E Teaching Staff Name',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-29',1,'2018-06-29',NULL),(107,'IV-E Teaching Staff Name12','IV-E Teaching Staff Name12',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-29',1,'2018-06-29',NULL),(108,'Administrative Staff Name','Administrative Staff Name',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-29',1,'2018-07-02',NULL),(109,'Administrative Staff Name2','Administrative Staff Name2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-29',1,'2018-07-02',NULL),(110,'Faculty Name1','Faculty Name1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-29',1,'2018-07-02',NULL),(111,'Faculty Name2','Faculty Name2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-29',1,'2018-07-02',NULL),(112,'IV-E Teaching Staff Name','IV-E Teaching Staff Name',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-29',1,'2018-07-02',NULL),(113,'IV-E Teaching Staff Name12','IV-E Teaching Staff Name12',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-06-29',1,'2018-07-02',NULL),(114,'Administrative Staff Name1','Administrative Staff Name1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',1,'2018-07-02',NULL),(115,'Administrative Staff Name2','Administrative Staff Name2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',1,'2018-07-02',NULL),(116,'Faculty Name1','Faculty Name1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',1,'2018-07-02',NULL),(117,'Faculty Name1','Faculty Name1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',1,'2018-07-02',NULL),(118,'IV-E Teaching Staff1','IV-E Teaching Staff1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',1,'2018-07-02',NULL),(119,'IV-E Teaching Staff2','IV-E Teaching Staff2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',1,'2018-07-02',NULL),(120,'Administrative Staff Name1','Administrative Staff Name1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',1,'2018-07-02',NULL),(121,'Administrative Staff Name2','Administrative Staff Name2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',1,'2018-07-02',NULL),(122,'Faculty1','Faculty1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',1,'2018-07-02',NULL),(123,'Faculty2','Faculty2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',1,'2018-07-02',NULL),(124,'IV-E Teaching Staff  Name1','IV-E Teaching Staff  Name1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',1,'2018-07-02',NULL),(125,'IV-E Teaching Staff  Name2','IV-E Teaching Staff  Name2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',1,'2018-07-02',NULL),(126,'Benjamin','Benjamin',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',NULL,NULL,NULL),(127,'Franklin','Franklin',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',NULL,NULL,NULL),(128,'Rajesh','Rajesh',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',NULL,NULL,NULL),(129,'Benjamin','Benjamin',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',NULL,NULL,NULL),(130,'Franklin','Franklin',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',NULL,NULL,NULL),(131,'Rajesh','Rajesh',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',NULL,NULL,NULL),(132,'Benjamin','Benjamin',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',NULL,NULL,NULL),(133,'Franklin','Franklin',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',NULL,NULL,NULL),(134,'Rajesh','Rajesh',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',NULL,NULL,NULL),(135,'Benjamin','Benjamin',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',NULL,NULL,NULL),(136,'Franklin','Franklin',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',NULL,NULL,NULL),(137,'Rajesh','Rajesh',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',NULL,NULL,NULL),(138,'Benjamin','Benjamin',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',NULL,NULL,NULL),(139,'Franklin','Franklin',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',NULL,NULL,NULL),(140,'Rajesh','Rajesh',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',NULL,NULL,NULL),(141,'Benjamin Franklin','Benjamin',NULL,'Franklin',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',NULL,NULL,NULL),(142,'ajmath khan','ajmath',NULL,'khan',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',NULL,NULL,NULL),(143,'Peter Albert','Peter',NULL,'Albert',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',NULL,NULL,NULL),(144,'Mary joseph','Mary',NULL,'joseph',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',NULL,NULL,NULL),(145,'af asdf asdfadsfadfs','af asdf',NULL,'asdfadsfadfs',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',NULL,NULL,NULL),(146,'s adfasdf sa fdasdf','s adfasdf',NULL,'sa fdasdf',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-02',NULL,NULL,NULL),(147,'Stephen Fleming Fleming Flemin Fleming','Stephen Fleming Fleming Flemin',NULL,'Fleming',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-03',1,'2018-07-03',NULL),(148,'Mark ','Mark ',NULL,'Henry',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-03',1,'2018-07-03',NULL),(149,'Mohan ','Mohan ',NULL,'Rangan',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-03',1,'2018-07-03',NULL),(150,'Mary Johsnon Johsnon Johsnon','Mary Johsnon Johsnon Johsnon',NULL,'Johsnon',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-03',1,'2018-07-04',NULL),(151,'Rajesh ','Rajesh ',NULL,'Kumar',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-03',1,'2018-07-04',NULL),(152,'Mohan ','Mohan ',NULL,'Raj',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-03',1,'2018-07-04',NULL),(153,'shaja khan khan','shaja khan khan',NULL,'khan',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-04',1,'2018-07-04',NULL),(154,'Stephen ','Stephen ',NULL,'Anthony',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-04',1,'2018-07-04',NULL),(155,'Maria ','Maria ',NULL,'Jpseph',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-04',1,'2018-07-04',NULL),(156,'shaja khan khan','shaja khan khan',NULL,'khan',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-04',1,'2018-07-04',NULL),(157,'Stephen Anthony Anthony','Stephen Anthony Anthony',NULL,'Anthony',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-04',1,'2018-07-04',NULL),(158,'Maria Jpseph Jpseph','Maria Jpseph Jpseph',NULL,'Jpseph',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-04',1,'2018-07-04',NULL),(159,'Suresh raj','Suresh',NULL,'raj',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-04',NULL,NULL,NULL),(160,'Lokesh kannah','Lokesh',NULL,'kannah',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-04',NULL,NULL,NULL),(161,'mary johnson','mary',NULL,'johnson',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-04',NULL,NULL,NULL),(162,'Aaliya thabassum','Aaliya',NULL,'thabassum',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-04',NULL,NULL,NULL),(163,'Thiru kumaran','Thiru',NULL,'kumaran',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-04',NULL,NULL,NULL),(164,'joseph raj','joseph',NULL,'raj',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-04',NULL,NULL,NULL),(165,'g sdf dfgdfg dfgdfg dfgdfg dfgdfg','g sdf dfgdfg dfgdfg dfgdfg dfg',NULL,'dfgdfg',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-04',1,'2018-07-05',NULL),(166,'fdsf ','fdsf ',NULL,'dsfdsf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-04',1,'2018-07-05',NULL),(167,'fdsaf ','fdsaf ',NULL,'dsfsdfd',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-04',1,'2018-07-05',NULL),(168,'sdfdf fsdfsdf fsdfsdf fsdfsdf fsdfsdf','sdfdf fsdfsdf fsdfsdf fsdfsdf ',NULL,'fsdfsdf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-04',1,'2018-07-05',NULL),(169,'ggsdfg dsf gg dsf gg dsf gg dsf gg','ggsdfg dsf gg dsf gg dsf gg ds',NULL,'dsf gg',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-04',1,'2018-07-05',NULL),(170,'erwe rererr rererr rererr rererr','erwe rererr rererr rererr rere',NULL,'rererr',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-04',1,'2018-07-05',NULL),(171,'fsfgdfs dfgdgdf','fsfgdfs',NULL,'dfgdgdf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-04',NULL,NULL,NULL),(172,'asds dsdsad','asds',NULL,'dsdsad',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-04',NULL,NULL,NULL),(173,'dsgsdfg gdfvgdfsg','dsgsdfg',NULL,'gdfvgdfsg',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-04',NULL,NULL,NULL),(174,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-04',NULL,NULL,NULL),(175,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-04',NULL,NULL,NULL),(176,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-04',NULL,NULL,NULL),(177,'fsfgdfs dfgdgdf dfgdgdf','fsfgdfs dfgdgdf dfgdgdf',NULL,'dfgdgdf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-04',1,'2018-07-04',NULL),(178,'asds ','asds ',NULL,'dsdsad',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-04',1,'2018-07-04',NULL),(179,'dsgsdfg ','dsgsdfg ',NULL,'gdfvgdfsg',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-04',1,'2018-07-04',NULL),(180,'Kumar Dinesh','Kumar',NULL,'Dinesh',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-07',NULL,NULL,NULL),(181,'Kumar Dinesh','Kumar',NULL,'Dinesh',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-07',NULL,NULL,NULL),(182,'Aaliya Thabassum','Aaliya',NULL,'Thabassum',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-07',NULL,NULL,NULL),(183,'Kumar Dinesh','Kumar',NULL,'Dinesh',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-07',NULL,NULL,NULL),(184,'Aaliya Thabassum','Aaliya',NULL,'Thabassum',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-07',NULL,NULL,NULL),(185,'Stephen Anthony','Stephen',NULL,'Anthony',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-07',NULL,NULL,NULL),(186,'Kumar Dinesh','Kumar',NULL,'Dinesh',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-07',NULL,NULL,NULL),(187,'Aaliya Thabassum','Aaliya',NULL,'Thabassum',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-07',NULL,NULL,NULL),(188,'Stephen Anthony','Stephen',NULL,'Anthony',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-07',NULL,NULL,NULL),(189,'Kumar Dinesh Dinesh Dinesh Dinesh','Kumar Dinesh Dinesh Dinesh Din',NULL,'Dinesh',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-07',1,'2018-07-08',NULL),(190,'Aaliya ','Aaliya ',NULL,'Thabassum',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-07',1,'2018-07-08',NULL),(191,'Stephen ','Stephen ',NULL,'Anthony',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-07',1,'2018-07-08',NULL),(192,'Gsgs555666666 Hshhshs','Gsgs555666666 Hshhshs',NULL,'Hshhshs',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-07',1,'2018-07-09',NULL),(193,'Hshsy ','Hshsy ',NULL,'Jsjshdj',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-07',1,'2018-07-09',NULL),(194,'Hdhdhh ','Hdhdhh ',NULL,'Jdjrjjr',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-07',1,'2018-07-09',NULL),(195,'Test Test1 Test1 Test1 Test1','Test Test1 Test1 Test1 Test1',NULL,'Test1',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(196,'sdfsd ','sdfsd ',NULL,'fdgdf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(197,'test2 ','test2 ',NULL,'t2',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(198,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(199,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(200,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(201,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(202,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(203,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(204,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(205,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(206,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(207,'Test te1 t1','Test te1 t1',NULL,'t1',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(208,'Test te2 ','Test te2 ',NULL,'t2',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(209,'Test te3 ','Test te3 ',NULL,'t3',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(210,'g fgsdf sdfg sdfg sdfg sdfg sd sdfg sdfg','g fgsdf sdfg sdfg sdfg sdfg sd',NULL,'sdfg sdfg',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(211,'rfg ','rfg ',NULL,'dfg dsfg',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(212,'dfsg ','dfsg ',NULL,'dfs g',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(213,'sgfdsg dsfgdsfg dsfgdsfg dsfgd dsfgdsfg','sgfdsg dsfgdsfg dsfgdsfg dsfgd',NULL,'dsfgdsfg',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(214,'dsfg ds fg ds fg ds fg ds fg d ds fg','dsfg ds fg ds fg ds fg ds fg d',NULL,'ds fg',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(215,'ds fdfs sd fgsg sd fgsg sd fgs sd fgsg','ds fdfs sd fgsg sd fgsg sd fgs',NULL,'sd fgsg',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(216,'Test t1','Test',NULL,'t1',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(217,'Test t2','Test',NULL,'t2',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(218,'Test t3','Test',NULL,'t3',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(219,'Test t1 t1 t1','Test t1 t1 t1',NULL,'t1',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(220,'Test ','Test ',NULL,'t2',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(221,'Test ','Test ',NULL,'t3',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(222,'Test tb1 tb1 tb1','Test tb1 tb1 tb1',NULL,'tb1',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(223,'Test te2 te2 te2','Test te2 te2 te2',NULL,'te2',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(224,'Test te3 te3 te3','Test te3 te3 te3',NULL,'te3',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(225,'Test t1','Test t1',NULL,'t1',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(226,'Test t2','Test t2',NULL,'t2',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(227,'Test t3','Test t3',NULL,'t3',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(228,'Test tb1','Test tb1',NULL,'tb1',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(229,'Test tb2','Test tb2',NULL,'tb2',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(230,'Test tb3','Test tb3',NULL,'tb3',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(231,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(232,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(233,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(234,'dfd dfgfdg','dfd',NULL,'dfgfdg',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(235,'tyuyt yuyu','tyuyt',NULL,'yuyu',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(236,'asdsad retrt','asdsad',NULL,'retrt',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(237,'etret etert','etret',NULL,'etert',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(238,'gfhg eret','gfhg',NULL,'eret',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(239,'qwewqe sdsdsf','qwewqe',NULL,'sdsdsf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(240,'erert rtryr','erert',NULL,'rtryr',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(241,'tyytut sdsdf','tyytut',NULL,'sdsdf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(242,'cxvcxv dfgfdg','cxvcxv',NULL,'dfgfdg',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(243,'yutyu sadsd','yutyu',NULL,'sadsd',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(244,'Test tb1','Test',NULL,'tb1',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(245,'Test tb2','Test',NULL,'tb2',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(246,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(247,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(248,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(249,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(250,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(251,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(252,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(253,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(254,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(255,' ',' ',NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(256,' ',' ',NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(257,' ',' ',NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(258,' ',' ',NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(259,' ',' ',NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(260,' ',' ',NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(261,' ',' ',NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(262,' ',' ',NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(263,' ',' ',NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(264,'werewr sfdsf','werewr sfdsf',NULL,'sfdsf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(265,'yrytr ','yrytr ',NULL,'sdfsfs',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(266,'asdsad ','asdsad ',NULL,'hfdhfdh',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(267,'ewwre yttryr','ewwre yttryr',NULL,'yttryr',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(268,'fdfdg hjkhjk','fdfdg hjkhjk',NULL,'hjkhjk',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(269,'rtytry sdfdgfd','rtytry sdfdgfd',NULL,'sdfdgfd',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(270,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(271,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(272,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(273,'asdsa sdfdsf','asdsa',NULL,'sdfdsf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(274,'erer tytryr','erer',NULL,'tytryr',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(275,'cxvcx sdfdsf','cxvcx',NULL,'sdfdsf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(276,'wrwer dgfdg','wrwer',NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(277,'qwdqw ','qwdqw',NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(278,'sadxasd ','sadxasd',NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',1,'2018-07-09',NULL),(279,'werew dfdsfg','werew',NULL,'dfdsfg',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(280,'tuyttu sdfsdf','tuyttu',NULL,'sdfsdf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(281,'xvcxv fghgf','xvcxv',NULL,'fghgf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-09',NULL,NULL,NULL),(282,'dfgdg fgffgh','dfgdg',NULL,'fgffgh',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-10',1,'2018-07-10',NULL),(283,'cvbvbc ','cvbvbc',NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-10',1,'2018-07-10',NULL),(284,'yuty ','yuty',NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-10',1,'2018-07-10',NULL),(285,'ewretr tretet','ewretr',NULL,'tretet',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-10',1,'2018-07-10',NULL),(286,'dgdfg ','dgdfg',NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-10',1,'2018-07-10',NULL),(287,'dgdfg ','dgdfg',NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-10',1,'2018-07-10',NULL),(288,'ewwe etrert','ewwe',NULL,'etrert',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-10',1,'2018-07-10',NULL),(289,'dsfd gjghj','dsfd',NULL,'gjghj',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-10',1,'2018-07-10',NULL),(290,'cxvcxv gjhgj','cxvcxv',NULL,'gjhgj',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-10',1,'2018-07-10',NULL),(291,'sfdf sdfsdf','sfdf',NULL,'sdfsdf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-10',1,'2018-07-10',NULL),(292,'iyui ','iyui',NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-10',1,'2018-07-10',NULL),(293,'hjkhjlk ','hjkhjlk',NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-10',1,'2018-07-10',NULL),(294,'wrew fddsf','wrew',NULL,'fddsf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-10',1,'2018-07-10',NULL),(295,'dsadsa hgfhgf','dsadsa',NULL,'hgfhgf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-10',1,'2018-07-10',NULL),(296,'oiuoi hkhjk','oiuoi',NULL,'hkhjk',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-10',1,'2018-07-10',NULL),(297,'wqeqw asdasd','wqeqw',NULL,'asdasd',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-10',NULL,NULL,NULL),(298,'sfds hfgh','sfds',NULL,'hfgh',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-10',NULL,NULL,NULL),(299,'adsa gfdgd','adsa',NULL,'gfdgd',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-10',NULL,NULL,NULL),(300,'sfsdfds ertret','sfsdfds',NULL,'ertret',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-10',NULL,NULL,NULL),(301,'sfdsg cbvcbc','sfdsg',NULL,'cbvcbc',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-10',NULL,NULL,NULL),(302,'adsad xczcxzc','adsad',NULL,'xczcxzc',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-10',NULL,NULL,NULL),(303,'erewrw dsfsdf','erewrw',NULL,'dsfsdf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-10',1,'2018-07-11',NULL),(304,'gjgh nbvn','gjgh',NULL,'nbvn',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-10',1,'2018-07-11',NULL),(305,'yiyuiyui cbvvccb','yiyuiyui',NULL,'cbvvccb',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-10',1,'2018-07-11',NULL),(306,'adasd ','adasd',NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-10',1,'2018-07-11',NULL),(307,'erewrw dsfsdf','erewrw',NULL,'dsfsdf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-10',NULL,NULL,NULL),(308,'gjgh nbvn','gjgh',NULL,'nbvn',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-10',NULL,NULL,NULL),(309,'yiyuiyui cbvvccb','yiyuiyui',NULL,'cbvvccb',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-10',NULL,NULL,NULL),(310,'adasd gdfg','adasd',NULL,'gdfg',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-10',NULL,NULL,NULL),(311,'rete ewrtewr','rete',NULL,'ewrtewr',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(312,'wrwerw ewrtrwt','wrwerw',NULL,'ewrtrwt',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(313,'f gsdg sd fgsdfg','f gsdg',NULL,'sd fgsdfg',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(314,'s adfasd sdfdsaf','s adfasd',NULL,'sdfdsaf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(315,'dsf g dsgsdg','dsf g',NULL,'dsgsdg',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(316,'rerer ererre','rerer',NULL,'ererre',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(317,'sdgdfs fgdsfgdsf','sdgdfs',NULL,'fgdsfgdsf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(318,'dsfdf dfdfdf','dsfdf',NULL,'dfdfdf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(319,'wwer ewrwe','wwer',NULL,'ewrwe',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(320,'s gdfsg sdfgfsdg','s gdfsg',NULL,'sdfgfsdg',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(321,'dfgdfsg sd fgf','dfgdfsg',NULL,'sd fgf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(322,'sd fgsdf sd fgsfd','sd fgsdf',NULL,'sd fgsfd',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(323,'dfsg ds fgs','dfsg',NULL,'ds fgs',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(324,'dsgdsf sd fg','dsgdsf',NULL,'sd fg',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(325,'sfg dsfg','sfg',NULL,'dsfg',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(326,'fsdfg f dgfdsg','fsdfg',NULL,'f dgfdsg',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(327,'sd fsad sdfsda','sd fsad',NULL,'sdfsda',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(328,'d gddfg dfgdfgf','d gddfg',NULL,'dfgdfgf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(329,'fd ghfgd ghgf','fd ghfgd',NULL,'ghgf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(330,'dfhgh ghhg','dfhgh',NULL,'ghhg',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(331,'dgdf dfgfd','dgdf',NULL,'dfgfd',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(332,'tyty tytyy','tyty',NULL,'tytyy',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(333,'sdadsa s dafdf','sdadsa',NULL,'s dafdf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(334,'gdfg dfgdf','gdfg',NULL,'dfgdf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(335,'sadf dfsdsf','sadf',NULL,'dfsdsf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(336,'tytu yuyu','tytu',NULL,'yuyu',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(337,'sdf sdfdf','sdf',NULL,'sdfdf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(339,'sdfs df sdfsdf','sdfs df',NULL,'sdfsdf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(340,'dfgfd dfgfdg','dfgfd',NULL,'dfgfdg',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(341,'fgdfg dfgfdg','fgdfg',NULL,'dfgfdg',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(342,'dsfs dfdf','dsfs',NULL,'dfdf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(343,'dfgf fgfgg','dfgf',NULL,'fgfgg',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(344,'dgdff fgfgfg','dgdff',NULL,'fgfgfg',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(345,'sdfs sdfdsf','sdfs',NULL,'sdfdsf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(346,'sgfg dfgdfg','sgfg',NULL,'dfgdfg',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(347,'ds gdfs dfgdf','ds gdfs',NULL,'dfgdf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(348,'tryrt tyrty','tryrt',NULL,'tyrty',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(349,'sfsd sdfsdf','sfsd',NULL,'sdfsdf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(350,'dfgdf dfgdfg','dfgdf',NULL,'dfgdfg',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-11',NULL,NULL,NULL),(351,'sdsad gdfgfd','sdsad',NULL,'gdfgfd',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-12',1,'2018-07-12',NULL),(352,'cvcxv dfgdfg','cvcxv',NULL,'dfgdfg',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-12',1,'2018-07-12',NULL),(353,'gfhgfh sdfdsf','gfhgfh',NULL,'sdfdsf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-12',1,'2018-07-12',NULL),(354,'vcbcvb ','vcbcvb',NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-12',1,'2018-07-12',NULL),(355,'fdgdfg ','fdgdfg',NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-12',1,'2018-07-12',NULL),(356,'uiuiyi ','uiuiyi',NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-12',1,'2018-07-12',NULL),(357,'cvbvcbc ','cvbvcbc',NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-12',1,'2018-07-12',NULL),(358,'fhfgh ','fhfgh',NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-12',1,'2018-07-12',NULL),(359,'fhfgh ','fhfgh',NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-12',1,'2018-07-12',NULL),(360,'werewr sdfdsf','werewr',NULL,'sdfdsf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-12',1,'2018-07-12',NULL),(363,'ttyyuyt ertret','ttyyuyt',NULL,'ertret',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-12',1,'2018-07-12',NULL),(366,'wqeqe trytry','wqeqe',NULL,'trytry',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-12',1,'2018-07-12',NULL),(369,'asdsad eretert','asdsad',NULL,'eretert',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-12',1,'2018-07-12',NULL),(371,'reetre uiyui','reetre',NULL,'uiyui',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-12',1,'2018-07-12',NULL),(373,'yuoyuo adsasd','yuoyuo',NULL,'adsasd',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-12',1,'2018-07-12',NULL),(375,'dfddgfd hjkhjk','dfddgfd',NULL,'hjkhjk',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-12',1,'2018-07-12',NULL),(376,'adsad asdasd','adsad',NULL,'asdasd',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-12',1,'2018-07-12',NULL),(378,'fddsf sdsfdsf','fddsf',NULL,'sdsfdsf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(379,'xcxvx dfdfdf','xcxvx',NULL,'dfdfdf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(380,'rewrew sdfsfds','rewrew',NULL,'sdfsfds',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(381,'oiuoiuo khjkkhj','oiuoiuo',NULL,'khjkkhj',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(384,'xcxzc vvbnbvn','xcxzc',NULL,'vvbnbvn',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(385,'yuyu werwrew','yuyu',NULL,'werwrew',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(386,'qweqwe retret','qweqwe',NULL,'retret',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(387,'sdfdsf dfgdfg','sdfdsf',NULL,'dfgdfg',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(388,'zxcxc vnvnb','zxcxc',NULL,'vnvnb',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(389,'adsada fgdfgfd','adsada',NULL,'fgdfgfd',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(390,'xvcxvx bvvcbvc','xvcxvx',NULL,'bvvcbvc',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(391,'wewrew rretret','wewrew',NULL,'rretret',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(392,'cvcbvc sfdsfs','cvcbvc',NULL,'sfdsfs',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(393,'hjghj jkjlkjl','hjghj',NULL,'jkjlkjl',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(395,'adsad fdsfsd','adsad',NULL,'fdsfsd',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(396,'dssfds werewrw','dssfds',NULL,'werewrw',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(399,'iyui tretrer','iyui',NULL,'tretrer',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(402,'werwr sdsfdsf','werwr',NULL,'sdsfdsf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(405,'tyuytu iyui','tyuytu',NULL,'iyui',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(408,'ertret dsgfdg','ertret',NULL,'dsgfdg',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(411,'werewr etret','werewr',NULL,'etret',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(412,'eret tyuytu','eret',NULL,'tyuytu',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(413,'ytutyu wewr','ytutyu',NULL,'wewr',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(414,'ewrewr tyuytu','ewrewr',NULL,'tyuytu',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(415,'sfdsf ghgfhf','sfdsf',NULL,'ghgfhf',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(416,'hgjghj sadsd','hgjghj',NULL,'sadsd',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(417,'xzvvxc vbnbvnbv','xzvvxc',NULL,'vbnbvnbv',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(418,'ytuytuyt wewr','ytuytuyt',NULL,'wewr',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(419,'vxcv bvnbn','vxcv',NULL,'bvnbn',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(420,'sdfds fgfdhgfh','sdfds',NULL,'fgfdhgfh',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(423,'tyutuyt ewrewr','tyutuyt',NULL,'ewrewr',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(426,'dfdfdf fdhgfhfgh','dfdfdf',NULL,'fdhgfhfgh',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(427,'xvcxv dgfdg','xvcxv',NULL,'dgfdg',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13',NULL),(429,'Shayla Bennett','Shayla',NULL,'Bennett',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL,NULL),(430,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL,NULL),(431,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL,NULL),(432,'Marcus Bouligny','Marcus',NULL,'Bouligny',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL,NULL),(433,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL,NULL),(434,' Bouligny',NULL,NULL,'Bouligny',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL,NULL),(435,'Marcus Bouligny','Marcus',NULL,'Bouligny',NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL,NULL),(436,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL,NULL),(437,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL,NULL),(438,' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SE',NULL,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL,NULL);

--
-- Table structure for table `PERSONNEL_BUDGET`
--

CREATE TABLE `PERSONNEL_BUDGET` (
  `PERSONNEL_BDGT_ID` int(11) NOT NULL AUTO_INCREMENT,
  `PROP_ID` int(11) NOT NULL,
  `PERSON_PID` int(11) NOT NULL,
  `SUMMER_BDGT_IND` char(1) DEFAULT NULL,
  `SALARY_BUDGET_HDG_ID` int(11) NOT NULL,
  `BENEFIT_BUDGET_HDG_BHID` int(11) DEFAULT NULL,
  `BASE_SALARY` decimal(9,2) DEFAULT NULL,
  `BENEFIT_RATE` decimal(5,2) DEFAULT NULL,
  `PGM_TIME_PCT` decimal(5,2) DEFAULT NULL,
  `SALARY_REIMBURSEMENT` char(1) DEFAULT NULL,
  `BENEFIT_REIMBURSEMENT` char(1) DEFAULT NULL,
  `CREATE_USER_ID` int(11) NOT NULL,
  `CREATE_DT` date NOT NULL,
  `MODIFY_USER_ID` int(11) DEFAULT NULL,
  `MODIFY_DT` date DEFAULT NULL,
  PRIMARY KEY (`PERSONNEL_BDGT_ID`),
  UNIQUE KEY `PERSON_PID` (`PERSON_PID`),
  KEY `FK_SALARY_BDGT_HDG_FK` (`SALARY_BUDGET_HDG_ID`),
  KEY `FK_BENEFIT_BDGT_HDG_FK` (`BENEFIT_BUDGET_HDG_BHID`),
  KEY `PROP_ID` (`PROP_ID`) USING BTREE,
  KEY `SUMMER_BDGT_IND` (`SUMMER_BDGT_IND`) USING BTREE,
  CONSTRAINT `FK_BENEFIT_BDGT_HDG_FK` FOREIGN KEY (`BENEFIT_BUDGET_HDG_BHID`) REFERENCES `BUDGET_HEADING` (`BH_ID`),
  CONSTRAINT `FK_PERSONNEL_BDGT_PROP_FK` FOREIGN KEY (`PROP_ID`) REFERENCES `PROPOSAL` (`PROP_ID`),
  CONSTRAINT `FK_PERSON_PERSONNEL_BDGT_FK` FOREIGN KEY (`PERSON_PID`) REFERENCES `PERSON` (`PID`),
  CONSTRAINT `FK_SALARY_BDGT_HDG_FK` FOREIGN KEY (`SALARY_BUDGET_HDG_ID`) REFERENCES `BUDGET_HEADING` (`BH_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `PERSONNEL_BUDGET`
--

INSERT INTO `PERSONNEL_BUDGET` VALUES (1,1,333,'N',1,4,45454.00,43.00,33.00,'Y','Y',1,'2018-07-11',NULL,NULL),(2,1,334,'N',1,4,54543.00,23.00,44.00,'Y','Y',1,'2018-07-11',NULL,NULL),(3,1,335,'N',2,5,55432.00,44.00,22.00,'Y','Y',1,'2018-07-11',NULL,NULL),(4,1,336,'N',2,5,67665.00,62.00,44.00,'Y','Y',1,'2018-07-11',NULL,NULL),(5,1,337,'N',3,5,56555.00,33.00,44.00,'Y','Y',1,'2018-07-11',NULL,NULL),(7,2,339,'N',1,4,45454.00,24.00,23.00,'Y','Y',1,'2018-07-11',NULL,NULL),(8,2,340,'N',1,4,56566.00,13.00,66.00,'Y','Y',1,'2018-07-11',NULL,NULL),(9,2,341,'N',2,5,45454.00,12.00,77.00,'Y','Y',1,'2018-07-11',NULL,NULL),(10,2,342,'N',2,5,67676.00,14.00,99.00,'Y','Y',1,'2018-07-11',NULL,NULL),(11,2,343,'N',3,5,66565.00,13.00,42.00,'Y','Y',1,'2018-07-11',NULL,NULL),(12,2,344,'N',3,5,56554.00,15.00,33.00,'Y','Y',1,'2018-07-11',NULL,NULL),(13,2,345,'Y',1,4,54544.00,13.00,33.00,'Y','Y',1,'2018-07-11',NULL,NULL),(14,2,346,'Y',1,4,76766.00,33.00,55.00,'Y','Y',1,'2018-07-11',NULL,NULL),(15,2,347,'Y',2,5,64644.00,13.00,77.00,'Y','Y',1,'2018-07-11',NULL,NULL),(16,2,348,'Y',2,5,45655.00,15.00,44.00,'Y','Y',1,'2018-07-11',NULL,NULL),(17,2,349,'Y',3,5,65756.00,14.00,66.00,'Y','Y',1,'2018-07-11',NULL,NULL),(18,2,350,'Y',3,5,46464.00,16.00,33.00,'Y','Y',1,'2018-07-11',NULL,NULL),(19,3,351,'N',1,4,34000.00,NULL,67.00,'Y','',1,'2018-07-12',1,'2018-07-12'),(20,3,352,'N',1,4,67000.00,NULL,43.00,'Y','',1,'2018-07-12',1,'2018-07-12'),(21,3,353,'N',1,4,88000.00,NULL,23.00,'Y','',1,'2018-07-12',1,'2018-07-12'),(22,3,354,'N',2,5,89800.00,NULL,56.00,'Y','',1,'2018-07-12',1,'2018-07-12'),(23,3,355,'N',2,5,54000.00,NULL,78.00,'Y','',1,'2018-07-12',1,'2018-07-12'),(24,3,356,'N',2,5,45300.00,NULL,59.00,'Y','',1,'2018-07-12',1,'2018-07-12'),(25,3,357,'N',3,5,76500.00,NULL,34.00,'Y','',1,'2018-07-12',1,'2018-07-12'),(26,3,358,'N',3,5,88900.00,NULL,54.00,'Y','',1,'2018-07-12',1,'2018-07-12'),(27,3,359,'N',3,5,67000.00,NULL,43.00,'Y','',1,'2018-07-12',1,'2018-07-12'),(28,4,360,'N',1,4,77000.00,12.00,34.00,'Y','Y',1,'2018-07-12',1,'2018-07-12'),(31,4,363,'N',2,5,77000.00,15.00,78.00,'Y','Y',1,'2018-07-12',1,'2018-07-12'),(34,4,366,'N',3,5,77000.00,18.00,79.00,'Y','Y',1,'2018-07-12',1,'2018-07-12'),(37,4,369,'Y',1,4,99000.00,12.00,56.00,'Y','',1,'2018-07-12',1,'2018-07-12'),(39,4,371,'Y',2,5,99000.00,16.00,78.00,'Y','',1,'2018-07-12',1,'2018-07-12'),(41,4,373,'Y',3,5,99000.00,29.00,38.00,'Y','',1,'2018-07-12',1,'2018-07-12'),(43,4,375,'Y',2,5,99000.00,27.00,32.00,'Y','',1,'2018-07-12',1,'2018-07-12'),(44,4,376,'Y',2,5,99000.00,NULL,78.00,'Y','',1,'2018-07-12',1,'2018-07-12'),(46,5,378,'N',1,4,44000.00,12.00,78.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(47,5,379,'N',1,4,44000.00,14.00,56.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(48,5,380,'N',1,4,44000.00,15.00,45.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(49,5,381,'N',2,5,44000.00,15.00,65.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(52,5,384,'N',3,5,44000.00,14.00,55.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(53,5,385,'N',3,5,44000.00,18.00,77.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(54,5,386,'Y',1,4,77000.00,16.00,66.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(55,5,387,'Y',1,4,77000.00,18.00,77.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(56,5,388,'Y',1,4,77000.00,19.00,88.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(57,5,389,'Y',2,5,77000.00,12.00,77.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(58,5,390,'Y',2,5,77000.00,16.00,54.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(59,5,391,'Y',2,5,77000.00,18.00,89.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(60,5,392,'Y',3,5,77000.00,20.00,67.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(61,5,393,'Y',3,5,77000.00,30.00,88.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(63,6,395,'N',1,4,56700.00,12.00,67.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(64,6,396,'N',2,5,77000.00,14.00,45.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(67,6,399,'N',3,5,88000.00,16.00,45.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(70,6,402,'Y',1,4,56000.00,12.00,67.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(73,6,405,'Y',2,5,77000.00,17.00,23.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(76,6,408,'Y',3,5,65000.00,16.00,45.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(79,7,411,'N',1,4,66000.00,21.00,45.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(80,7,412,'N',1,4,66000.00,22.00,34.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(81,7,413,'N',1,4,66000.00,67.00,12.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(82,7,414,'N',2,5,66000.00,12.00,56.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(83,7,415,'N',2,5,66000.00,13.00,34.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(84,7,416,'N',2,5,66000.00,16.00,66.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(85,7,417,'N',3,5,66000.00,18.00,67.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(86,7,418,'N',3,5,NULL,20.00,23.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(87,7,419,'N',3,5,66000.00,21.00,78.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(88,7,420,'Y',1,4,56000.00,12.00,45.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(91,7,423,'Y',2,5,87000.00,21.00,45.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(94,7,426,'Y',3,5,54000.00,22.00,45.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(95,7,427,'Y',3,5,76000.00,25.00,76.00,'Y','Y',1,'2018-07-13',1,'2018-07-13'),(97,8,429,'N',1,4,200000.00,NULL,75.00,'Y','',1,'2018-07-17',NULL,NULL),(98,8,430,'N',2,5,NULL,NULL,NULL,'','',1,'2018-07-17',NULL,NULL),(99,8,431,'N',3,5,NULL,NULL,NULL,'','',1,'2018-07-17',NULL,NULL),(100,9,432,'N',1,4,20000.00,NULL,50.00,'','',1,'2018-07-17',NULL,NULL),(101,9,433,'N',1,4,NULL,NULL,NULL,'','',1,'2018-07-17',NULL,NULL),(102,9,434,'N',2,5,NULL,NULL,NULL,'','',1,'2018-07-17',NULL,NULL),(103,9,435,'N',3,5,NULL,NULL,NULL,'','',1,'2018-07-17',NULL,NULL),(104,9,436,'Y',1,4,NULL,NULL,NULL,'','',1,'2018-07-17',NULL,NULL),(105,9,437,'Y',2,5,NULL,NULL,NULL,'','',1,'2018-07-17',NULL,NULL),(106,9,438,'Y',3,5,NULL,NULL,NULL,'','',1,'2018-07-17',NULL,NULL);

--
-- Table structure for table `PROPOSAL`
--

CREATE TABLE `PROPOSAL` (
  `PROP_ID` int(11) NOT NULL AUTO_INCREMENT,
  `UID` int(11) NOT NULL,
  `PROPOSAL_NM` varchar(20) DEFAULT NULL,
  `YID` int(11) NOT NULL,
  `PREPARED_BY` int(11) DEFAULT NULL,
  `STATUS_ID` int(11) DEFAULT NULL,
  `FALL_TERM` char(1) DEFAULT NULL,
  `SPRING_TERM` char(1) DEFAULT NULL,
  `SUMMER_TERM` char(1) DEFAULT NULL,
  `SW_PGM_OVERVIEW` varchar(1024) DEFAULT NULL,
  `RECRUITMENT_PLAN` varchar(1024) DEFAULT NULL,
  `RETENTION_PLAN` varchar(1024) DEFAULT NULL,
  `OTH_TRAINING_OPP` varchar(1024) DEFAULT NULL,
  `MATERIAL_PCT` decimal(5,2) DEFAULT NULL,
  `ELIGIBILITY_RATE` decimal(5,2) DEFAULT NULL,
  `FED_SHARE_PCT` decimal(5,2) DEFAULT NULL,
  `ADMIN_SALARY_JSTFCTN` varchar(512) DEFAULT NULL,
  `FACULTY_SALARY_JSTFCTN` varchar(512) DEFAULT NULL,
  `TEACHER_SALARY_JSTFCTN` varchar(512) DEFAULT NULL,
  `ADMIN_FRINGE_JSTFCTN` varchar(512) DEFAULT NULL,
  `FCLTY_TCHR_FRINGE_JSTFCTN` varchar(512) DEFAULT NULL,
  `UPLOAD_FOLDER` longtext,
  `UPLOAD_DOCS` longtext,
  `CREATE_USER_ID` int(11) NOT NULL,
  `CREATE_DT` date NOT NULL,
  `MODIFY_USER_ID` int(11) DEFAULT NULL,
  `MODIFY_DT` date DEFAULT NULL,
  UNIQUE KEY `PROP_ID` (`PROP_ID`),
  KEY `FK_PROP_ACADEMIC_YR_FK` (`YID`),
  KEY `FK_PROP_STATUS_FK` (`STATUS_ID`),
  KEY `FK_USER_PROP_FK` (`PREPARED_BY`),
  KEY `UID` (`UID`,`YID`) USING BTREE,
  CONSTRAINT `FK_PROP_ACADEMIC_YR_FK` FOREIGN KEY (`YID`) REFERENCES `ACADEMIC_YEAR` (`YID`),
  CONSTRAINT `FK_PROP_STATUS_FK` FOREIGN KEY (`STATUS_ID`) REFERENCES `PROPOSAL_STATUS` (`PSID`),
  CONSTRAINT `FK_PROP_UNIV_FK` FOREIGN KEY (`UID`) REFERENCES `UNIVERSITY` (`UID`),
  CONSTRAINT `FK_USER_PROP_FK` FOREIGN KEY (`PREPARED_BY`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `PROPOSAL`
--

INSERT INTO `PROPOSAL` VALUES (1,4,'Proposal 1',1,1,1,'Y',NULL,NULL,'ds fgsdf gdsf gsdf gsdfg sfd','as dfasd fadsf','sdafadsf dasfadsf','ads fasdf asdfadsfadsf',70.00,47.00,NULL,'dsfgsdf gdsf gdsfg sdfg','asdf asdf dsf dsaf asdfdfsa','fsd gdsf gdfs gdfs gdfs g','sfdg sdf gdfs gsdfg sdfg','dsfgsdf gsdf gsdfg sfdg sdfg','a:1:{i:0;a:1:{i:0;s:36:\"250ca2b6-6ab7-47ac-8513-7969872fc9c1\";}}','a:1:{i:0;a:1:{i:0;s:15:\"report_side.png\";}}',1,'2018-07-11',1,'2018-07-11'),(2,2,'Proposal 1',1,1,3,'Y',NULL,'Y','s dafe fdsf dsaf sadfa sdfadsf asdfdsafasdff','fgfds g dfgsdf gd','f sfdg sf gdfs gdfsg','dfsgdfs gfdsg dfs gsfdg fsd',70.00,47.00,NULL,'g dsfg dfs gdfs g','ds fgfdsg fdsg dfsg f','sd fgsdf gfdsg dfs','sdfgsdf gfdsg dfs gdfsg dfsgs','df gsdfg dfs gfdsgs dfgsdf gsd','a:1:{i:0;a:2:{i:0;s:36:\"d099678d-a754-4467-a663-76bebebeebc7\";i:1;s:36:\"28d91d6e-4779-47c7-bdb3-7f9fe488bd03\";}}','a:1:{i:0;a:2:{i:0;s:15:\"report_side.png\";i:1;s:16:\"report_side1.png\";}}',1,'2018-07-11',1,'2018-07-11'),(3,7,'Proposal 1',2,1,3,'Y',NULL,NULL,'Test Process','Test Process','wjedde  xscdsc','jhdkjhd iueqwuei',70.00,47.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-12',1,'2018-07-12'),(4,6,'Proposal 1',2,1,3,'Y','Y','Y','Test Process','efewrfew sfdsf','rtytry fdgfgd','rtyrety dgfdgd',70.00,47.00,NULL,'efwer sdfdsf','ytrytr dfdgg','zcxzc vbbvnbv','ewrewrew sdfdf','sfdsf xccvcxv','a:1:{i:0;a:1:{i:0;s:36:\"af745916-6540-4864-8056-b866f285eb72\";}}','a:1:{i:0;a:1:{i:0;s:22:\"Sample IP - Blank.xlsx\";}}',1,'2018-07-12',1,'2018-07-12'),(5,1,'Proposal 1',2,1,3,'Y','Y',NULL,'Test Process','Test Process1','jhdjhd ueiuq','dhsajdha mancxnc',70.00,47.00,NULL,'dddd ffffff','aaaaa jjjjj','xxxxx mmm','cccc nnnnn','dddddd bbbbbbb','a:1:{i:0;a:1:{i:0;s:36:\"a61458e0-ad9b-4df3-b3bc-efbd096de7ec\";}}','a:1:{i:0;a:1:{i:0;s:36:\"R1 Forsyth County BOE_1478501813.xls\";}}',1,'2018-07-13',1,'2018-07-13'),(6,1,'Proposal 2',3,1,3,'Y','Y','Y',NULL,NULL,NULL,NULL,70.00,47.00,NULL,'ewrewr fgfhgfh','trytry yuiyuoyu','bbvmn hjkhkhj','dsfsd jghjhg','zxcxzc vnbvnvb','a:1:{i:0;a:1:{i:0;s:36:\"f32c9ed1-4fc9-40fa-80dd-563901615765\";}}','a:1:{i:0;a:1:{i:0;s:22:\"Sample IP - Blank.xlsx\";}}',1,'2018-07-13',1,'2018-07-13'),(7,13,'Proposal 1',2,1,3,'Y','Y','Y','dsfsdf drhtry1','sdfds ghgfhf1','xxzcxc vbvnvb1','wrewrew rtgfgfhgfh1',70.00,47.00,NULL,'hhhhhhhhhh','ggggg','fffffff','ssssssssss','iiiiiiiiiiii','a:1:{i:0;a:1:{i:0;s:36:\"c71aaf0d-54ce-4844-b752-56e4138b2d02\";}}','a:1:{i:0;a:1:{i:0;s:22:\"Sample IP - Blank.xlsx\";}}',1,'2018-07-13',1,'2018-07-13'),(8,1,'Proposal 3',1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,70.00,47.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-17',1,'2018-07-17'),(9,1,'Proposal 4',1,1,3,'Y','Y','Y',NULL,NULL,NULL,NULL,70.00,47.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2018-07-17',1,'2018-07-17');

--
-- Table structure for table `PROPOSAL_STATUS`
--

CREATE TABLE `PROPOSAL_STATUS` (
  `PSID` int(11) NOT NULL AUTO_INCREMENT,
  `PROP_STATUS` int(11) NOT NULL,
  `STATUS_DESC` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`PSID`),
  UNIQUE KEY `PROP_STATUS` (`PROP_STATUS`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `PROPOSAL_STATUS`
--

INSERT INTO `PROPOSAL_STATUS` VALUES (1,0,'Submitted'),(2,1,'Under-Review'),(3,2,'Approved'),(4,3,'Declined');

--
-- Table structure for table `PROPOSED_STUDENT_COUNT`
--

CREATE TABLE `PROPOSED_STUDENT_COUNT` (
  `PROP_ID` int(11) NOT NULL,
  `PGM_DEGREE_ABBREV` varchar(3) NOT NULL,
  `DEGREE_DESC` varchar(128) DEFAULT NULL,
  `FULL_TIME_CNT` int(11) DEFAULT NULL,
  `PART_TIME_CNT` int(11) DEFAULT NULL,
  `DFCS_CNT` int(11) DEFAULT NULL,
  `CREATE_USER_ID` int(11) NOT NULL,
  `CREATE_DT` date NOT NULL,
  `MODIFY_USER_ID` int(11) DEFAULT NULL,
  `MODIFY_DT` date DEFAULT NULL,
  PRIMARY KEY (`PROP_ID`,`PGM_DEGREE_ABBREV`),
  CONSTRAINT `FK_STUDENT_CNT_PROP_FK` FOREIGN KEY (`PROP_ID`) REFERENCES `PROPOSAL` (`PROP_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `PROPOSED_STUDENT_COUNT`
--

INSERT INTO `PROPOSED_STUDENT_COUNT` VALUES (1,'BSW',NULL,3545,454,3324,1,'2018-07-11',NULL,NULL),(1,'MSW',NULL,454,4543,55,1,'2018-07-11',NULL,NULL),(2,'BSW',NULL,234324,233,6767,1,'2018-07-11',NULL,NULL),(2,'MSW',NULL,43434,5455,67667,1,'2018-07-11',NULL,NULL),(3,'BSW',NULL,23,56,56,1,'2018-07-12',1,'2018-07-12'),(3,'MSW',NULL,456,278,124,1,'2018-07-12',1,'2018-07-12'),(4,'BSW',NULL,56,43,12,1,'2018-07-12',1,'2018-07-12'),(4,'MSW',NULL,567,879,123,1,'2018-07-12',1,'2018-07-12'),(5,'BSW',NULL,567,345,23,1,'2018-07-13',1,'2018-07-13'),(5,'MSW',NULL,645,457,125,1,'2018-07-13',1,'2018-07-13'),(6,'BSW',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13'),(6,'MSW',NULL,NULL,NULL,NULL,1,'2018-07-13',1,'2018-07-13'),(7,'BSW',NULL,4561,5551,341,1,'2018-07-13',1,'2018-07-13'),(7,'MSW',NULL,6781,3451,1251,1,'2018-07-13',1,'2018-07-13'),(8,'BSW',NULL,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(8,'MSW',NULL,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(9,'BSW',NULL,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL),(9,'MSW',NULL,NULL,NULL,NULL,1,'2018-07-17',NULL,NULL);

--
-- Table structure for table `SMMR_BDGT_HDG_JSTFCTN`
--

CREATE TABLE `SMMR_BDGT_HDG_JSTFCTN` (
  `PROP_ID` int(11) NOT NULL,
  `ADMIN_SALARY_JSTFCTN` varchar(512) DEFAULT NULL,
  `TEACHER_SALARY_JSTFCTN` varchar(512) DEFAULT NULL,
  `FACULTY_SALARY_JSTFCTN` varchar(512) DEFAULT NULL,
  `ADMIN_FRINGE_JSTFCTN` varchar(512) DEFAULT NULL,
  `FCLTY_TCHR_FRINGE_JSTFCTN` varchar(512) DEFAULT NULL,
  UNIQUE KEY `PROP_ID` (`PROP_ID`),
  CONSTRAINT `FK_SMMR_BDGT_PROP_FK` FOREIGN KEY (`PROP_ID`) REFERENCES `PROPOSAL` (`PROP_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `SMMR_BDGT_HDG_JSTFCTN`
--

INSERT INTO `SMMR_BDGT_HDG_JSTFCTN` VALUES (2,'sdfgdf gdfs gsdf gdfsg','df gdfs gdf','sd gdfs gdfs gdfs','dsfgdsfgdfs gdfs gdfsg','f af sd fsa fasf sadfdas'),(4,'dsfsdf ghhfghf','xcxzcxz bvnvbnv','ewqeq trrytry','sadsad fghgfh','trytr yiyuiy'),(5,'zzzzzzz','vvvvvvvvv','ccccccccc','ssssssssssss','llllllllll'),(6,'aaaaaaaa','ddddd','ssssssss','dddddd','ffffff'),(7,'hhhhhh','fffffff','gggggggg','ddddd','sssss'),(9,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `UNIVERSITY`
--

CREATE TABLE `UNIVERSITY` (
  `UID` int(11) NOT NULL AUTO_INCREMENT,
  `EIN_NBR` varchar(10) DEFAULT NULL,
  `NAME` varchar(100) NOT NULL,
  `BSW_DEGREE_IND` char(1) DEFAULT NULL,
  `MSW_DEGREE_IND` char(1) DEFAULT NULL,
  `DUNS_NBR` varchar(30) DEFAULT NULL,
  `CONGRESSIONAL_DISTRICT` varchar(40) DEFAULT NULL,
  `MAIL_ADDR_LN_1` varchar(100) DEFAULT NULL,
  `MAIL_ADDR_LN_2` varchar(25) DEFAULT NULL,
  `MAIL_CITY` varchar(30) DEFAULT NULL,
  `MAIL_STATE` varchar(20) DEFAULT NULL,
  `MAIL_ZIPCODE` varchar(10) DEFAULT NULL,
  `PERF_ADDR_LN_1` varchar(100) DEFAULT NULL,
  `PERF_ADDR_LN_2` varchar(25) DEFAULT NULL,
  `PERF_CITY` varchar(30) DEFAULT NULL,
  `PERF_STATE_ABBREV` varchar(20) DEFAULT NULL,
  `PERF_ZIPCODE` varchar(10) DEFAULT NULL,
  `TITLE_IV_E_CONTACT_ID` int(11) DEFAULT NULL,
  `FINANCIAL_OFFICIER_ID` int(11) DEFAULT NULL,
  `PRINCIPAL_INVSTGTR_ID` int(11) DEFAULT NULL,
  `ADMIN_ID` int(11) DEFAULT NULL,
  `CREATE_USER_ID` int(11) NOT NULL,
  `CREATE_DT` date NOT NULL,
  `MODIFY_USER_ID` int(11) DEFAULT NULL,
  `MODIFY_DT` date DEFAULT NULL,
  PRIMARY KEY (`UID`),
  UNIQUE KEY `EIN_NBR` (`EIN_NBR`),
  KEY `FK_UNIV_CONTACT_FK` (`TITLE_IV_E_CONTACT_ID`),
  KEY `FK_UNIV_FO_FK` (`FINANCIAL_OFFICIER_ID`),
  KEY `FK_UNIV_PRNCPL_INVSTGTR_FK` (`PRINCIPAL_INVSTGTR_ID`),
  KEY `FK_UNIV_ADMIN_FK` (`ADMIN_ID`),
  CONSTRAINT `FK_UNIV_ADMIN_FK` FOREIGN KEY (`ADMIN_ID`) REFERENCES `PERSON` (`PID`),
  CONSTRAINT `FK_UNIV_CONTACT_FK` FOREIGN KEY (`TITLE_IV_E_CONTACT_ID`) REFERENCES `PERSON` (`PID`),
  CONSTRAINT `FK_UNIV_FO_FK` FOREIGN KEY (`FINANCIAL_OFFICIER_ID`) REFERENCES `PERSON` (`PID`),
  CONSTRAINT `FK_UNIV_PRNCPL_INVSTGTR_FK` FOREIGN KEY (`PRINCIPAL_INVSTGTR_ID`) REFERENCES `PERSON` (`PID`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `UNIVERSITY`
--

INSERT INTO `UNIVERSITY` VALUES (1,'453454','Albany State University','Y','Y','54325324','4545','Address1','sdgvsdgsdgsdg','Address2','Georgia','56555','p-Address1','sdgsdg','P-Address2','Georgia','454545',79,80,81,82,1,'2018-06-27',0,'2018-06-29'),(2,'343434','Augusta University','Y','Y','3534563','4545','Mail Address1','sd gsdfg dfs','Mail Address2','Hawaii','334343','Per Address1','wr gwergwre','Per Address2','Hawaii','224544',83,84,85,86,1,'2018-06-27',0,'2018-06-29'),(3,'5860020621','Fort Valley State University','Y','Y','073425951','ga-011','Mail-Address1','dfrg rtgrfg','Mail-Address2','Iowa','885623','Per_Address1','dsafghj','Per-Address2','Iowa','885623',87,88,89,90,1,'2018-06-27',0,'2018-06-29'),(4,'34567','Georgia State University','Y','Y','34567','4567','Mail-Address1','sdfgtjukl','Mail-Address2','Michigan','234566','Per_Address1','dfghjklgfhj','Lansing','Michigan','345674',91,92,93,94,1,'2018-06-27',0,'2018-06-29'),(5,'3245678','Kennesaw State University','Y','Y','3456789','34567','gandhi salai','fghjk','chennai','Tamil Nadu','600012','t nagar','dfgrtuio','chennai','Tamil Nadu','600001',72,73,74,75,1,'2018-06-27',0,'2018-06-29'),(6,'345678','Savannah State University','Y','Y','456789','3445678','dfgthyui','dfghjkl','sdfgthyuio','dfghjk','345674','sdfghjk','fghjk','gfhjk','fghjyuki','456789',67,68,69,70,1,'2018-06-27',0,'2018-06-29'),(7,'4356789','University of Georgia','Y','Y','3456789','456798','gandhi salai','dfghjyukio','chennai','Tamil Nadu','600002','t nagar','gthyjukilo','chennai','Tamil Nadu','600001',69,70,72,73,1,'2018-06-27',0,'2018-06-29'),(8,'123456','Valdosta State University','Y','Y','2345678','3345678','usman street','dfghjkldfg','chennai','Tamil Nadu','600012','gandhi nagar','fghjuio','chennai','Tamil Nadu','600043',65,66,67,68,1,'2018-06-27',0,'2018-06-29'),(9,'345768','Testing','Y','Y','134567','2457856','anna nagar','fghjkgt','chennai','Tamil Nadu','600002','t nagar','dfghjkl','chennai','Tamil Nadu','600023',72,73,74,75,1,'2018-06-27',0,'2018-06-29'),(13,'3465','Testing Process','Y',NULL,'11111','retyrytrytrytr','Test1',NULL,'Test1','Test1','374366','Test2',NULL,'Test2','Test2','325445',65,66,67,68,1,'2018-06-28',0,'2018-06-29');

--
-- Table structure for table `announcements`
--

CREATE TABLE `announcements` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `region` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `agency_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `user_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comments` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attachement` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `read_user_id` longtext COLLATE utf8mb4_unicode_ci,
  `send_status` int(11) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `announcements`
--

INSERT INTO `announcements` VALUES (1,NULL,0,1,'admin','Hi test','','a:3:{i:0;i:1;i:1;i:45;i:2;i:49;}',0,'2018-03-26 13:03:08'),(2,NULL,0,1,'admin','?','','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-03-28 09:03:09'),(3,NULL,0,1,'admin','&nbsp;','28-03-2018-09-09-40/Chrysanthemum.jpg','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-03-28 09:03:09'),(5,NULL,0,1,'admin','&nbsp;','28-03-2018-01-34-38/R1 Forsyth County BOE_1478501813.xls','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-03-28 13:03:34'),(6,NULL,0,1,'admin','Hi everyone','','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-03-28 13:03:35'),(7,NULL,0,1,'admin','Hello','','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-03-30 10:03:08'),(8,NULL,0,1,'admin','&nbsp;','30-03-2018-10-23-48/Hydrangeas.jpg','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-03-30 10:03:23'),(9,NULL,0,1,'admin','?','','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-03-30 10:03:26'),(10,NULL,0,1,'admin','Hi test','','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-04 07:04:24'),(11,NULL,0,1,'admin','Hi test','','a:7:{i:0;i:25;i:1;i:23;i:2;i:1;i:3;i:11;i:4;i:39;i:5;i:45;i:6;i:49;}',0,'2018-04-04 07:04:25'),(12,NULL,0,1,'admin','hiii','','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-04 07:04:25'),(13,NULL,0,1,'admin','&nbsp;','04-04-2018-07-25-56/Sample IP - Blank.xlsx','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-04 07:04:25'),(14,NULL,0,1,'admin','☺','','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-04 07:04:26'),(15,NULL,0,1,'admin','Hi test','','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-05 13:04:58'),(16,NULL,0,1,'admin','Hello','','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-05 14:04:30'),(17,NULL,0,1,'admin','&nbsp;','05-04-2018-02-34-39/Koala.jpg','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-05 14:04:34'),(18,NULL,0,1,'admin','test','','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-05 14:04:35'),(19,NULL,0,1,'admin','&nbsp;','05-04-2018-02-35-37/Chrysanthemum.jpg','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-05 14:04:35'),(20,NULL,0,1,'admin','Hiii','','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-06 05:04:20'),(21,NULL,0,1,'admin','?','','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-06 05:04:34'),(22,NULL,13,1,'admin','Test','','a:4:{i:0;i:1;i:1;i:11;i:2;i:25;i:3;i:45;}',0,'2018-04-06 05:04:40'),(23,'R-2',0,1,'admin','hiii','','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-06 05:04:49'),(24,'R-5',0,1,'admin','test region R-5','','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-06 05:04:52'),(25,NULL,19,1,'admin','&nbsp;','06-04-2018-05-58-19/Lighthouse.jpg','a:4:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:45;}',0,'2018-04-06 05:04:58'),(26,'R-5',0,1,'admin','?','','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-06 05:04:59'),(27,NULL,19,1,'admin','test for unive','','a:4:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:45;}',0,'2018-04-06 06:04:02'),(28,NULL,0,1,'admin','test','','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-06 06:04:03'),(29,NULL,0,1,'admin','??','','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-06 09:04:04'),(30,NULL,0,1,'admin','&nbsp;','06-04-2018-09-04-58/image.png','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-06 09:04:04'),(31,NULL,0,1,'admin','&nbsp;','06-04-2018-09-05-02/image.png','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-06 09:04:05'),(32,NULL,0,1,'admin','Testing annoucement','','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-06 09:04:06'),(33,NULL,0,1,'admin','⚽?','','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-06 09:04:07'),(34,NULL,24,1,'admin','Testing text','','a:3:{i:0;i:1;i:1;i:11;i:2;i:45;}',0,'2018-04-06 09:04:08'),(35,NULL,0,1,'admin','Text msg from android','','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-06 10:04:44'),(36,NULL,0,1,'admin','Thanks','','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-06 10:04:44'),(37,NULL,24,1,'admin','Ok','','a:3:{i:0;i:1;i:1;i:11;i:2;i:45;}',0,'2018-04-06 10:04:45'),(38,'R-5',0,1,'admin','Tested successfully','','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-06 10:04:47'),(39,'R-1',0,1,'admin','Test commend for region','','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-09 05:04:40'),(40,NULL,18,1,'admin','Cambridge University message test','','a:4:{i:0;i:1;i:1;i:11;i:2;i:39;i:3;i:45;}',0,'2018-04-09 11:04:53'),(41,NULL,1,1,'admin','University 1 message','','a:4:{i:0;i:1;i:1;i:11;i:2;i:21;i:3;i:45;}',0,'2018-04-09 11:04:54'),(42,NULL,1,1,'admin','&nbsp;','09-04-2018-12-11-23/Koala.jpg','a:4:{i:0;i:1;i:1;i:11;i:2;i:21;i:3;i:45;}',0,'2018-04-09 12:04:11'),(43,NULL,32,1,'admin','Test','','a:4:{i:0;i:1;i:1;i:11;i:2;i:21;i:3;i:45;}',0,'2018-04-10 05:04:13'),(44,'R-6',0,1,'admin','testing only for region','','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-10 05:04:23'),(45,NULL,19,1,'admin','Message for test','','a:4:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:45;}',0,'2018-04-10 05:04:25'),(46,NULL,0,1,'admin','Test','','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-12 08:04:46'),(47,NULL,0,11,'testing','Tester','','a:8:{i:0;i:23;i:1;i:1;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-17 10:04:19'),(48,NULL,0,1,'admin','Testing for notification','','a:8:{i:0;i:11;i:1;i:1;i:2;i:23;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-17 13:04:25'),(49,NULL,0,11,'testing','Testing from middle user','','a:8:{i:0;i:1;i:1;i:23;i:2;i:11;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-17 13:04:25'),(50,NULL,0,1,'admin','Tested successfully','','a:8:{i:0;i:11;i:1;i:23;i:2;i:1;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-17 13:04:27'),(51,NULL,0,11,'testing','Hi','','a:8:{i:0;i:11;i:1;i:1;i:2;i:23;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-17 13:04:29'),(52,NULL,0,1,'admin','Hello','','a:8:{i:0;i:11;i:1;i:23;i:2;i:1;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-17 13:04:30'),(53,NULL,0,11,'testing','Thank you','','a:8:{i:0;i:23;i:1;i:11;i:2;i:1;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-17 13:04:32'),(54,NULL,0,1,'admin','testing user & admin','','a:8:{i:0;i:23;i:1;i:11;i:2;i:1;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-17 13:04:42'),(55,NULL,0,1,'admin','Testing user & middle admin','','a:8:{i:0;i:11;i:1;i:21;i:2;i:23;i:3;i:1;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-17 13:04:45'),(56,NULL,0,11,'testing','Test from madmin','','a:8:{i:0;i:21;i:1;i:11;i:2;i:23;i:3;i:1;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-17 13:04:47'),(57,NULL,0,11,'testing','Yes testing','','a:8:{i:0;i:21;i:1;i:11;i:2;i:23;i:3;i:1;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-17 14:04:00'),(58,NULL,0,11,'testing','Is it working fine','','a:8:{i:0;i:21;i:1;i:11;i:2;i:23;i:3;i:1;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-17 14:04:01'),(59,NULL,0,11,'testing','No','','a:8:{i:0;i:21;i:1;i:11;i:2;i:23;i:3;i:1;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-17 14:04:04'),(60,NULL,0,1,'admin','Testing from admin','','a:8:{i:0;i:21;i:1;i:11;i:2;i:23;i:3;i:1;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-17 14:04:05'),(61,NULL,0,11,'testing','Ok','','a:8:{i:0;i:23;i:1;i:11;i:2;i:21;i:3;i:1;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-17 14:04:06'),(62,NULL,0,11,'testing','New message','','a:8:{i:0;i:23;i:1;i:21;i:2;i:11;i:3;i:1;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-17 14:04:13'),(63,NULL,0,1,'admin','Today message','','a:8:{i:0;i:11;i:1;i:23;i:2;i:1;i:3;i:21;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-18 07:04:17'),(64,NULL,0,1,'admin','Yes','','a:8:{i:0;i:23;i:1;i:11;i:2;i:21;i:3;i:25;i:4;i:1;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-18 07:04:19'),(65,NULL,0,11,'testing','Ok we are listening','','a:8:{i:0;i:23;i:1;i:21;i:2;i:25;i:3;i:11;i:4;i:1;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-18 07:04:21'),(66,NULL,0,1,'admin','Testing from shaja','','a:8:{i:0;i:23;i:1;i:21;i:2;i:11;i:3;i:1;i:4;i:25;i:5;i:39;i:6;i:45;i:7;i:49;}',0,'2018-04-18 07:04:39'),(67,NULL,0,11,'testing','Test','','a:7:{i:0;i:25;i:1;i:23;i:2;i:1;i:3;i:11;i:4;i:39;i:5;i:45;i:6;i:49;}',0,'2018-04-20 06:04:37'),(68,NULL,0,1,'admin','tested','','a:7:{i:0;i:25;i:1;i:23;i:2;i:1;i:3;i:11;i:4;i:39;i:5;i:45;i:6;i:49;}',0,'2018-04-20 09:04:56'),(69,NULL,0,1,'admin','Testing','','a:6:{i:0;i:1;i:1;i:11;i:2;i:23;i:3;i:39;i:4;i:45;i:5;i:49;}',0,'2018-04-20 12:04:17'),(70,NULL,0,1,'admin','Test message','','a:5:{i:0;i:11;i:1;i:39;i:2;i:1;i:3;i:45;i:4;i:49;}',0,'2018-04-20 12:04:18'),(71,NULL,0,1,'admin','Announcement','','a:4:{i:0;i:39;i:1;i:1;i:2;i:45;i:3;i:49;}',0,'2018-04-20 12:04:20'),(72,NULL,0,1,'admin','hi','','a:3:{i:0;i:1;i:1;i:45;i:2;i:49;}',0,'2018-06-06 06:06:34');

--
-- Table structure for table `costworkbook_comments`
--

CREATE TABLE `costworkbook_comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `user_name` varchar(245) DEFAULT NULL,
  `university_id` int(11) DEFAULT NULL,
  `workbook_id` int(11) DEFAULT NULL,
  `comments` text,
  `view_status` enum('Y','N') DEFAULT NULL,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_date` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `costworkbook_comments`
--

INSERT INTO `costworkbook_comments` VALUES (1,1,'Admin',18,18,'Cost worknbook comments test',NULL,'2018-05-08 08:40:29',NULL),(2,1,'Admin',18,18,'Testing',NULL,'2018-05-08 08:40:46',NULL),(3,25,'abdul',13,13,'Test command',NULL,'2018-05-08 10:16:21',NULL),(4,39,'New',18,18,'Test command from newuser',NULL,'2018-05-09 01:54:11',NULL),(5,1,'Admin',18,18,'Test',NULL,'2018-05-12 03:02:40',NULL);

--
-- Table structure for table `costworkbook_comments_status`
--

CREATE TABLE `costworkbook_comments_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `university_id` int(11) DEFAULT NULL,
  `workbook_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `comment_count` int(11) DEFAULT NULL,
  `status` enum('Y','N') DEFAULT NULL,
  `updated_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `costworkbook_comments_status`
--

INSERT INTO `costworkbook_comments_status` VALUES (1,26,34,1,0,NULL,'2018-04-20 05:48:30'),(2,1,10,1,1,NULL,'2018-04-20 09:50:52'),(3,19,22,1,1,NULL,'2018-04-20 10:04:01'),(4,25,17,23,1,NULL,'2018-04-20 10:04:55'),(5,19,25,23,1,NULL,'2018-04-20 10:07:15'),(6,19,25,1,0,NULL,'2018-04-20 06:07:00'),(7,27,36,39,2,NULL,'2018-04-23 06:59:41'),(8,18,32,11,1,NULL,'2018-04-20 10:15:14'),(9,27,35,39,0,NULL,'2018-04-20 06:21:08'),(10,18,33,39,1,NULL,'2018-04-20 10:38:08'),(11,13,15,25,1,NULL,'2018-04-20 10:40:00'),(12,19,26,1,0,NULL,'2018-04-20 08:59:29'),(13,27,35,1,0,NULL,'2018-04-20 08:59:44'),(14,18,37,1,0,NULL,'2018-04-23 00:31:15'),(15,18,32,25,1,NULL,'2018-04-23 07:37:15'),(16,18,33,25,1,NULL,'2018-04-23 07:37:20'),(17,18,18,1,4,NULL,'2018-05-12 07:02:45'),(18,27,27,1,0,NULL,'2018-05-08 10:01:28'),(19,13,13,25,1,NULL,'2018-05-08 14:16:29'),(20,18,18,25,2,NULL,'2018-05-08 10:19:14'),(21,18,18,39,3,NULL,'2018-05-09 05:54:17'),(22,13,13,1,1,NULL,'2018-06-13 02:46:10'),(23,4,2,1,0,NULL,'2018-07-03 05:01:00'),(24,1,1,1,0,NULL,'2018-07-03 22:31:12');

--
-- Table structure for table `login_levels`
--

CREATE TABLE `login_levels` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `level_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `level_level` int(11) NOT NULL,
  `level_disabled` tinyint(4) DEFAULT NULL,
  `redirect` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `welcome_email` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `login_levels_level_level_unique` (`level_level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `login_levels`
--


--
-- Table structure for table `login_profile_fields`
--

CREATE TABLE `login_profile_fields` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `section` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `public` int(11) DEFAULT NULL,
  `signup` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `login_profile_fields`
--

INSERT INTO `login_profile_fields` VALUES (1,'University Name','text','University Name',1,'optional'),(2,'Priority','text','Priority Area',1,'optional'),(3,'Priority','textarea','Priority Notes',1,'optional'),(4,'Strategies','text','Primary Strategies',1,'optional'),(5,'Strategies','textarea','Secondary Strategies',1,'optional'),(6,'Address','text','Street',1,'optional'),(7,'Address','text','Suite',1,'optional'),(8,'Address','text','City',1,'optional'),(9,'Address','text','State',1,'optional'),(10,'Address','text','Zip',1,'optional'),(11,'Address','text','Phone',1,'optional'),(12,'Address','text','Alt Num',1,'optional'),(13,'Address','text','Website',1,'optional'),(14,'Region','checkbox','Region 1',1,'optional'),(15,'Region','checkbox','Region 2',1,'optional'),(16,'Region','checkbox','Region 3',1,'optional'),(17,'Region','checkbox','Region 4',1,'optional'),(18,'Region','checkbox','Region 5',1,'optional'),(19,'Region','checkbox','Region 6',1,'optional'),(20,'Region','checkbox','ALL',1,'optional'),(21,'Region','checkbox','NA',1,'optional');

--
-- Table structure for table `login_profiles`
--

CREATE TABLE `login_profiles` (
  `p_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `pfield_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `profile_value` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`p_id`)
) ENGINE=InnoDB AUTO_INCREMENT=242 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `login_profiles`
--

INSERT INTO `login_profiles` VALUES (1,14,3,'0'),(2,15,3,'0'),(3,16,3,'0'),(4,17,3,'0'),(5,18,3,'0'),(6,19,3,'0'),(7,20,3,'0'),(8,21,3,'0'),(9,14,8,'0'),(10,15,8,'0'),(11,16,8,'0'),(12,17,8,'0'),(13,18,8,'0'),(14,19,8,'0'),(15,20,8,'0'),(16,21,8,'0'),(17,14,10,'0'),(18,15,10,'0'),(19,16,10,'0'),(20,17,10,'0'),(21,18,10,'0'),(22,19,10,'0'),(23,20,10,'0'),(24,21,10,'0'),(25,14,9,'0'),(26,15,9,'0'),(27,16,9,'0'),(28,17,9,'0'),(29,18,9,'0'),(30,19,9,'0'),(31,20,9,'0'),(32,21,9,'0'),(33,14,7,'0'),(34,15,7,'0'),(35,16,7,'0'),(36,17,7,'0'),(37,18,7,'0'),(38,19,7,'0'),(39,20,7,'0'),(40,21,7,'0'),(41,14,6,'0'),(42,15,6,'0'),(43,16,6,'0'),(44,17,6,'0'),(45,18,6,'0'),(46,19,6,'0'),(47,20,6,'0'),(48,21,6,'0'),(49,14,4,'0'),(50,15,4,'0'),(51,16,4,'0'),(52,17,4,'0'),(53,18,4,'0'),(54,19,4,'0'),(55,20,4,'0'),(56,21,4,'0'),(57,14,11,'0'),(58,15,11,'0'),(59,16,11,'0'),(60,17,11,'0'),(61,18,11,'0'),(62,19,11,'0'),(63,20,11,'0'),(64,21,11,'0'),(65,14,13,'0'),(66,15,13,'0'),(67,16,13,'0'),(68,17,13,'0'),(69,18,13,'0'),(70,19,13,'0'),(71,20,13,'0'),(72,21,13,'0'),(73,14,14,'0'),(74,15,14,'0'),(75,16,14,'0'),(76,17,14,'0'),(77,18,14,'0'),(78,19,14,'0'),(79,20,14,'0'),(80,21,14,'0'),(81,14,12,'0'),(82,15,12,'0'),(83,16,12,'0'),(84,17,12,'0'),(85,18,12,'0'),(86,19,12,'0'),(87,20,12,'0'),(88,21,12,'0'),(89,14,16,'0'),(90,15,16,'0'),(91,16,16,'0'),(92,17,16,'0'),(93,18,16,'0'),(94,19,16,'0'),(95,20,16,'0'),(96,21,16,'0'),(97,14,18,'0'),(98,15,18,'0'),(99,16,18,'0'),(100,17,18,'0'),(101,18,18,'0'),(102,19,18,'0'),(103,20,18,'0'),(104,21,18,'0'),(105,14,17,'0'),(106,15,17,'0'),(107,16,17,'0'),(108,17,17,'0'),(109,18,17,'0'),(110,19,17,'0'),(111,20,17,'0'),(112,21,17,'0'),(113,14,1,'0'),(114,15,1,'0'),(115,16,1,'0'),(116,17,1,'0'),(117,18,1,'0'),(118,19,1,'0'),(119,20,1,'0'),(120,21,1,'0'),(121,14,19,'0'),(122,15,19,'0'),(123,16,19,'0'),(124,17,19,'0'),(125,18,19,'0'),(126,19,19,'0'),(127,20,19,'0'),(128,21,19,'0'),(129,14,20,'0'),(130,15,20,'0'),(131,16,20,'0'),(132,17,20,'0'),(133,18,20,'0'),(134,19,20,'0'),(135,20,20,'0'),(136,21,20,'0'),(137,14,21,'0'),(138,15,21,'0'),(139,16,21,'0'),(140,17,21,'0'),(141,18,21,'0'),(142,19,21,'0'),(143,20,21,'0'),(144,21,21,'0'),(145,14,23,'0'),(146,15,23,'0'),(147,16,23,'0'),(148,17,23,'0'),(149,18,23,'0'),(150,19,23,'0'),(151,20,23,'0'),(152,21,23,'0'),(153,14,24,'0'),(154,15,24,'0'),(155,16,24,'0'),(156,17,24,'0'),(157,18,24,'0'),(158,19,24,'0'),(159,20,24,'0'),(160,21,24,'0'),(161,14,25,'0'),(162,15,25,'0'),(163,16,25,'0'),(164,17,25,'0'),(165,18,25,'0'),(166,19,25,'0'),(167,20,25,'0'),(168,21,25,'0'),(169,14,28,'0'),(170,15,28,'0'),(171,16,28,'0'),(172,17,28,'0'),(173,18,28,'0'),(174,19,28,'0'),(175,20,28,'0'),(176,21,28,'0'),(177,14,29,'0'),(178,15,29,'0'),(179,16,29,'0'),(180,17,29,'0'),(181,18,29,'0'),(182,19,29,'0'),(183,20,29,'0'),(184,21,29,'0'),(185,14,37,'0'),(186,15,37,'0'),(187,16,37,'0'),(188,17,37,'0'),(189,18,37,'0'),(190,19,37,'0'),(191,20,37,'0'),(192,21,37,'0'),(193,14,41,'0'),(194,15,41,'0'),(195,16,41,'0'),(196,17,41,'0'),(197,18,41,'0'),(198,19,41,'0'),(199,20,41,'0'),(200,21,41,'0'),(201,14,35,'0'),(202,15,35,'0'),(203,16,35,'0'),(204,17,35,'0'),(205,18,35,'0'),(206,19,35,'0'),(207,20,35,'0'),(208,21,35,'0'),(209,14,39,'0'),(210,15,39,'0'),(211,16,39,'0'),(212,17,39,'0'),(213,18,39,'0'),(214,19,39,'0'),(215,20,39,'0'),(216,21,39,'0'),(217,14,44,'0'),(218,15,44,'0'),(219,16,44,'0'),(220,17,44,'0'),(221,18,44,'0'),(222,19,44,'0'),(223,20,44,'0'),(224,21,44,'0'),(225,1,44,'Vit university'),(226,14,45,'0'),(227,15,45,'0'),(228,16,45,'0'),(229,17,45,'0'),(230,18,45,'0'),(231,19,45,'0'),(232,20,45,'0'),(233,21,45,'0'),(234,14,47,'0'),(235,15,47,'0'),(236,16,47,'0'),(237,17,47,'0'),(238,18,47,'0'),(239,19,47,'0'),(240,20,47,'0'),(241,21,47,'0');

--
-- Table structure for table `login_timestamps`
--

CREATE TABLE `login_timestamps` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `ip` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `timestamp` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=911 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `login_timestamps`
--

INSERT INTO `login_timestamps` VALUES (1,1,'49.207.183.144','2018-03-29 07:28:42'),(2,1,'49.207.183.144','2018-03-29 09:05:25'),(3,11,'49.207.183.144','2018-03-29 09:08:47'),(4,11,'49.207.183.144','2018-03-29 09:10:22'),(5,12,'49.207.183.144','2018-03-29 09:12:42'),(6,1,'49.207.183.144','2018-03-29 09:13:40'),(7,4,'49.207.183.144','2018-03-29 09:16:57'),(8,12,'49.207.183.144','2018-03-29 09:19:41'),(9,11,'49.207.183.144','2018-03-29 09:47:23'),(10,1,'49.207.183.144','2018-03-29 10:13:08'),(11,1,'49.207.183.144','2018-03-29 10:25:40'),(12,1,'49.207.183.144','2018-03-29 10:39:04'),(13,18,'49.207.183.144','2018-03-29 11:00:21'),(14,1,'172.58.4.85','2018-03-29 12:24:47'),(15,1,'172.58.4.85','2018-03-29 12:31:05'),(16,13,'172.58.4.85','2018-03-29 12:32:19'),(17,1,'131.96.223.145','2018-03-29 04:49:09'),(18,1,'131.96.223.145','2018-03-29 04:51:00'),(19,13,'131.96.223.145','2018-03-29 04:52:29'),(20,1,'131.96.223.145','2018-03-29 04:52:42'),(21,13,'131.96.223.145','2018-03-29 04:53:14'),(22,1,'131.96.223.145','2018-03-29 04:53:37'),(23,1,'49.207.183.144','2018-03-30 05:02:46'),(24,1,'49.207.183.144','2018-03-30 05:09:33'),(25,1,'49.207.183.144','2018-03-30 09:53:29'),(26,19,'49.207.183.144','2018-03-30 10:28:49'),(27,20,'49.207.183.144','2018-03-30 10:39:11'),(28,20,'49.207.183.144','2018-03-30 11:12:11'),(29,1,'49.207.183.144','2018-03-30 01:29:21'),(30,11,'49.207.183.144','2018-03-30 02:07:50'),(31,1,'73.43.56.106','2018-03-31 12:17:14'),(32,1,'73.43.56.106','2018-03-31 12:19:28'),(33,1,'49.207.183.144','2018-03-31 05:12:09'),(34,1,'49.207.183.144','2018-03-31 06:39:07'),(35,11,'49.207.183.144','2018-03-31 06:55:18'),(36,1,'49.207.183.144','2018-03-31 11:26:35'),(37,1,'49.207.183.144','2018-03-31 11:26:36'),(38,1,'49.207.183.144','2018-03-31 11:26:44'),(39,1,'49.207.183.144','2018-03-31 11:53:44'),(40,11,'49.207.183.144','2018-03-31 11:58:45'),(41,4,'49.207.183.144','2018-03-31 12:03:12'),(42,11,'49.207.183.144','2018-03-31 12:13:04'),(43,1,'157.50.89.142','2018-03-31 12:24:15'),(44,1,'96.86.237.161','2018-03-31 01:22:12'),(45,1,'172.58.4.167','2018-03-31 10:18:48'),(46,14,'172.58.4.167','2018-03-31 10:23:59'),(47,1,'172.58.4.167','2018-03-31 10:25:59'),(48,14,'172.58.4.167','2018-03-31 10:26:25'),(49,1,'172.58.4.167','2018-03-31 10:26:48'),(50,14,'172.58.4.167','2018-03-31 10:27:54'),(51,1,'172.58.4.167','2018-03-31 10:28:13'),(52,1,'172.58.4.167','2018-03-31 10:30:37'),(53,14,'172.58.4.167','2018-03-31 10:30:58'),(54,14,'172.58.4.167','2018-03-31 10:32:01'),(55,1,'172.58.4.167','2018-03-31 10:32:22'),(56,14,'172.58.4.167','2018-03-31 10:34:40'),(57,1,'172.58.4.167','2018-03-31 10:35:24'),(58,14,'172.58.4.167','2018-03-31 10:36:51'),(59,1,'172.58.6.231','2018-04-01 01:55:24'),(60,1,'49.207.183.144','2018-04-02 05:03:33'),(61,1,'49.207.183.144','2018-04-02 05:05:05'),(62,21,'49.207.183.144','2018-04-02 05:05:13'),(63,22,'49.207.183.144','2018-04-02 05:17:27'),(64,22,'49.207.183.144','2018-04-02 05:18:29'),(65,23,'49.207.183.144','2018-04-02 05:21:58'),(66,21,'49.207.183.144','2018-04-02 05:25:18'),(67,1,'49.207.183.144','2018-04-02 09:37:25'),(68,1,'49.207.183.144','2018-04-02 11:42:20'),(69,21,'49.207.183.144','2018-04-02 11:43:34'),(70,11,'49.207.183.144','2018-04-02 11:43:57'),(71,1,'96.67.126.34','2018-04-02 12:20:03'),(72,14,'96.67.126.34','2018-04-02 12:20:58'),(73,1,'96.67.126.34','2018-04-02 12:21:44'),(74,21,'49.207.183.144','2018-04-02 01:53:03'),(75,1,'131.96.53.165','2018-04-02 03:10:55'),(76,1,'172.58.7.103','2018-04-03 01:11:01'),(77,1,'49.207.183.144','2018-04-03 04:28:55'),(78,1,'49.207.183.144','2018-04-03 05:10:13'),(79,21,'49.207.183.144','2018-04-03 05:18:18'),(80,11,'49.207.183.144','2018-04-03 05:18:31'),(81,1,'49.207.183.144','2018-04-03 05:22:54'),(82,1,'49.207.183.144','2018-04-03 09:07:52'),(83,1,'49.207.183.144','2018-04-03 11:46:33'),(84,1,'49.207.183.144','2018-04-03 12:03:02'),(85,11,'49.207.183.144','2018-04-03 12:03:52'),(86,21,'49.207.183.144','2018-04-03 12:05:37'),(87,23,'49.207.183.144','2018-04-03 12:08:41'),(88,4,'49.207.183.144','2018-04-03 12:13:34'),(89,23,'49.207.183.144','2018-04-03 12:13:59'),(90,21,'49.207.183.144','2018-04-03 12:15:11'),(91,8,'49.207.183.144','2018-04-03 12:21:09'),(92,1,'96.67.126.34','2018-04-03 12:35:46'),(93,1,'96.67.126.34','2018-04-03 12:48:12'),(94,1,'96.67.126.34','2018-04-03 01:08:30'),(95,1,'49.207.183.144','2018-04-04 05:10:42'),(96,11,'49.207.183.144','2018-04-04 05:22:31'),(97,21,'49.207.183.144','2018-04-04 05:23:18'),(98,1,'49.207.183.144','2018-04-04 05:33:04'),(99,1,'49.207.183.144','2018-04-04 05:33:59'),(100,1,'49.207.183.144','2018-04-04 06:13:34'),(101,11,'49.207.183.144','2018-04-04 07:26:33'),(102,21,'49.207.183.144','2018-04-04 07:36:34'),(103,23,'49.207.183.144','2018-04-04 07:47:01'),(104,25,'49.207.183.144','2018-04-04 09:14:53'),(105,25,'49.207.183.144','2018-04-04 09:19:19'),(106,25,'49.207.183.144','2018-04-04 09:28:56'),(107,21,'49.207.183.144','2018-04-04 09:44:31'),(108,1,'96.67.126.34','2018-04-04 11:48:19'),(109,1,'96.67.126.34','2018-04-04 12:25:16'),(110,1,'96.67.126.34','2018-04-04 12:25:22'),(111,1,'96.67.126.34','2018-04-04 01:06:54'),(112,1,'49.207.183.144','2018-04-04 01:32:45'),(113,1,'49.207.183.144','2018-04-04 02:00:15'),(114,1,'96.67.126.34','2018-04-04 02:14:20'),(115,1,'96.67.126.34','2018-04-04 02:38:57'),(116,1,'131.96.219.108','2018-04-04 03:31:52'),(117,1,'131.96.219.108','2018-04-04 03:50:49'),(118,1,'131.96.219.108','2018-04-04 03:58:09'),(119,1,'172.58.7.35','2018-04-04 04:21:49'),(120,1,'49.207.183.144','2018-04-05 04:42:58'),(121,1,'49.207.183.144','2018-04-05 05:08:57'),(122,1,'49.207.183.144','2018-04-05 05:41:50'),(123,21,'49.207.183.144','2018-04-05 06:30:45'),(124,11,'49.207.183.144','2018-04-05 06:31:01'),(125,1,'49.207.183.144','2018-04-05 09:00:58'),(126,4,'49.207.183.144','2018-04-05 09:37:15'),(127,6,'49.207.183.144','2018-04-05 09:46:47'),(128,1,'157.50.10.161','2018-04-05 11:55:12'),(129,11,'49.207.183.144','2018-04-05 12:00:38'),(130,23,'49.207.183.144','2018-04-05 12:03:57'),(131,1,'49.207.183.144','2018-04-05 01:04:50'),(132,1,'49.207.183.144','2018-04-05 01:08:04'),(133,1,'49.207.183.144','2018-04-05 01:12:12'),(134,1,'49.207.183.144','2018-04-05 01:37:28'),(135,1,'49.207.183.144','2018-04-05 01:43:25'),(136,1,'49.207.183.144','2018-04-05 01:45:01'),(137,1,'96.86.237.161','2018-04-05 01:50:29'),(138,1,'96.86.237.161','2018-04-05 02:12:28'),(139,1,'131.96.53.165','2018-04-05 02:33:21'),(140,1,'131.96.53.165','2018-04-05 04:03:07'),(141,1,'73.106.153.97','2018-04-05 06:35:32'),(142,1,'73.106.153.97','2018-04-05 06:38:35'),(143,1,'49.207.183.144','2018-04-06 04:36:15'),(144,1,'49.207.183.144','2018-04-06 04:36:36'),(145,1,'49.207.183.144','2018-04-06 05:06:14'),(146,1,'49.207.183.144','2018-04-06 05:19:14'),(147,1,'49.207.183.144','2018-04-06 05:19:56'),(148,1,'49.207.183.144','2018-04-06 05:24:40'),(149,1,'49.207.183.144','2018-04-06 05:27:12'),(150,25,'49.207.183.144','2018-04-06 05:42:32'),(151,11,'49.207.183.144','2018-04-06 05:44:56'),(152,24,'49.207.183.144','2018-04-06 05:46:32'),(153,4,'49.207.183.144','2018-04-06 05:48:44'),(154,23,'49.207.183.144','2018-04-06 05:52:13'),(155,1,'49.207.183.144','2018-04-06 06:09:11'),(156,1,'49.207.183.144','2018-04-06 06:58:29'),(157,1,'49.207.183.144','2018-04-06 07:35:01'),(158,1,'49.207.183.144','2018-04-06 07:54:53'),(159,23,'49.207.183.144','2018-04-06 09:09:04'),(160,23,'49.207.183.144','2018-04-06 09:20:28'),(161,1,'42.111.145.74','2018-04-06 10:42:36'),(162,1,'42.111.145.74','2018-04-06 10:43:20'),(163,23,'42.111.145.74','2018-04-06 10:45:48'),(164,1,'42.111.145.74','2018-04-06 10:46:31'),(165,23,'42.111.145.74','2018-04-06 10:47:42'),(166,1,'49.207.183.144','2018-04-06 12:01:12'),(167,1,'42.111.145.74','2018-04-06 12:03:50'),(168,1,'42.111.145.74','2018-04-06 12:03:51'),(169,1,'42.111.145.74','2018-04-06 12:04:03'),(170,1,'49.207.183.144','2018-04-06 12:23:07'),(171,1,'49.207.183.144','2018-04-06 12:25:36'),(172,1,'42.111.145.74','2018-04-06 12:35:27'),(173,1,'49.207.183.144','2018-04-06 01:04:01'),(174,1,'96.84.190.243','2018-04-06 11:07:22'),(175,1,'172.58.153.212','2018-04-06 11:19:42'),(176,1,'157.50.64.230','2018-04-07 12:19:28'),(177,1,'96.67.126.34','2018-04-07 12:12:37'),(178,1,'172.58.153.212','2018-04-07 01:02:38'),(179,1,'49.207.183.144','2018-04-09 04:39:52'),(180,11,'49.207.183.144','2018-04-09 04:45:08'),(181,25,'49.207.183.144','2018-04-09 04:46:08'),(182,21,'49.207.183.144','2018-04-09 04:46:45'),(183,1,'49.207.183.144','2018-04-09 05:16:56'),(184,25,'49.207.183.144','2018-04-09 05:41:38'),(185,1,'157.50.119.104','2018-04-09 05:52:12'),(186,29,'49.207.183.144','2018-04-09 06:26:12'),(187,29,'49.207.183.144','2018-04-09 06:28:01'),(188,1,'49.207.183.144','2018-04-09 06:56:55'),(189,1,'49.207.183.144','2018-04-09 07:40:47'),(190,1,'49.207.183.144','2018-04-09 09:11:48'),(191,1,'49.207.183.144','2018-04-09 10:01:59'),(192,1,'49.207.183.144','2018-04-09 10:37:23'),(193,4,'49.207.183.144','2018-04-09 11:48:49'),(194,1,'157.50.71.110','2018-04-09 12:22:28'),(195,1,'49.207.183.144','2018-04-09 01:10:27'),(196,1,'131.96.53.165','2018-04-09 03:23:09'),(197,1,'131.96.53.165','2018-04-09 07:23:15'),(198,1,'172.58.33.208','2018-04-10 04:23:34'),(199,1,'49.207.183.144','2018-04-10 04:36:49'),(200,21,'49.207.183.144','2018-04-10 04:44:57'),(201,21,'49.207.183.144','2018-04-10 05:02:35'),(202,29,'49.207.183.144','2018-04-10 05:03:46'),(203,1,'49.207.183.144','2018-04-10 05:12:57'),(204,21,'49.207.183.144','2018-04-10 05:13:06'),(205,23,'49.207.183.144','2018-04-10 05:19:48'),(206,29,'49.207.183.144','2018-04-10 05:20:39'),(207,23,'49.207.183.144','2018-04-10 05:22:13'),(208,1,'49.207.183.144','2018-04-10 05:33:39'),(209,1,'49.207.183.144','2018-04-10 06:03:39'),(210,1,'49.207.183.144','2018-04-10 06:09:04'),(211,1,'49.207.183.144','2018-04-10 06:13:04'),(212,1,'49.207.183.144','2018-04-10 06:25:02'),(213,1,'49.207.183.144','2018-04-10 06:32:59'),(214,1,'49.207.183.144','2018-04-10 06:41:44'),(215,1,'49.207.183.144','2018-04-10 06:56:19'),(216,1,'49.207.183.144','2018-04-10 07:05:37'),(217,1,'49.207.183.144','2018-04-10 07:09:03'),(218,21,'49.207.183.144','2018-04-10 07:26:12'),(219,21,'49.207.183.144','2018-04-10 07:39:25'),(220,1,'49.207.183.144','2018-04-10 08:51:42'),(221,1,'49.207.183.144','2018-04-10 09:25:56'),(222,29,'49.207.183.144','2018-04-10 09:45:35'),(223,23,'49.207.183.144','2018-04-10 09:45:51'),(224,1,'49.207.183.144','2018-04-10 10:06:35'),(225,1,'49.207.183.144','2018-04-10 10:44:05'),(226,1,'49.207.183.144','2018-04-10 12:14:47'),(227,1,'49.207.183.144','2018-04-10 12:19:58'),(228,1,'172.58.33.208','2018-04-10 01:39:13'),(229,1,'49.207.183.144','2018-04-10 01:46:58'),(230,21,'49.207.183.144','2018-04-10 01:49:04'),(231,1,'49.207.183.144','2018-04-10 01:49:22'),(232,21,'49.207.183.144','2018-04-10 01:50:04'),(233,1,'49.207.183.144','2018-04-10 01:50:32'),(234,1,'49.207.183.144','2018-04-10 02:02:20'),(235,1,'172.58.33.208','2018-04-10 03:40:59'),(236,1,'131.96.53.165','2018-04-10 03:46:20'),(237,21,'49.207.183.144','2018-04-11 04:30:51'),(238,1,'49.207.183.144','2018-04-11 04:33:00'),(239,11,'49.207.183.144','2018-04-11 04:57:20'),(240,1,'49.207.183.144','2018-04-11 05:11:11'),(241,1,'49.207.183.144','2018-04-11 05:17:06'),(242,1,'49.207.183.144','2018-04-11 05:37:43'),(243,25,'49.207.183.144','2018-04-11 09:14:39'),(244,23,'49.207.183.144','2018-04-11 09:16:31'),(245,1,'49.207.183.144','2018-04-11 09:21:21'),(246,1,'49.207.183.144','2018-04-11 09:22:56'),(247,1,'49.207.183.144','2018-04-11 09:51:44'),(248,1,'49.207.183.144','2018-04-11 10:13:09'),(249,21,'49.207.183.144','2018-04-11 12:20:04'),(250,1,'49.207.183.144','2018-04-11 01:07:31'),(251,1,'49.207.183.144','2018-04-11 01:36:19'),(252,1,'96.92.116.43','2018-04-11 01:50:33'),(253,21,'49.207.183.144','2018-04-11 02:08:08'),(254,1,'131.96.53.165','2018-04-11 06:30:45'),(255,1,'172.58.33.208','2018-04-11 10:49:36'),(256,1,'12.146.21.155','2018-04-12 02:03:41'),(257,1,'49.207.183.144','2018-04-12 04:30:58'),(258,1,'49.207.183.144','2018-04-12 05:17:29'),(259,1,'49.207.183.144','2018-04-12 05:28:04'),(260,21,'49.207.183.144','2018-04-12 06:16:45'),(261,21,'49.207.183.144','2018-04-12 06:22:35'),(262,1,'49.207.183.144','2018-04-12 06:22:42'),(263,1,'49.207.183.144','2018-04-12 06:44:58'),(264,1,'49.207.183.144','2018-04-12 07:26:40'),(265,1,'49.207.183.144','2018-04-12 07:32:27'),(266,11,'49.207.183.144','2018-04-12 07:47:23'),(267,21,'49.207.183.144','2018-04-12 08:47:35'),(268,21,'49.207.183.144','2018-04-12 10:05:35'),(269,1,'49.207.183.144','2018-04-12 10:13:33'),(270,1,'49.207.183.144','2018-04-12 10:24:14'),(271,1,'49.207.183.144','2018-04-12 10:26:11'),(272,23,'49.207.183.144','2018-04-12 10:52:08'),(273,1,'49.207.183.144','2018-04-12 11:41:12'),(274,1,'49.207.183.144','2018-04-12 12:02:14'),(275,21,'49.207.183.144','2018-04-12 12:20:18'),(276,1,'49.207.183.144','2018-04-12 12:21:30'),(277,21,'49.207.183.144','2018-04-12 12:24:06'),(278,1,'49.207.183.144','2018-04-12 12:32:08'),(279,21,'49.207.183.144','2018-04-12 12:33:08'),(280,21,'49.207.183.144','2018-04-12 12:41:28'),(281,21,'49.207.183.144','2018-04-12 01:07:57'),(282,21,'49.207.183.144','2018-04-12 01:34:09'),(283,1,'49.207.183.144','2018-04-12 01:43:48'),(284,1,'73.237.49.116','2018-04-12 02:52:13'),(285,1,'73.106.147.188','2018-04-13 01:55:11'),(286,1,'49.207.183.144','2018-04-13 05:27:20'),(287,1,'49.207.183.144','2018-04-13 05:57:15'),(288,1,'49.207.183.144','2018-04-13 06:02:55'),(289,4,'49.207.183.144','2018-04-13 06:56:51'),(290,1,'49.207.183.144','2018-04-13 11:03:18'),(291,1,'49.207.183.144','2018-04-13 11:23:23'),(292,1,'107.210.153.173','2018-04-13 12:12:24'),(293,1,'107.210.153.173','2018-04-13 12:12:38'),(294,1,'73.70.83.124','2018-04-13 10:49:21'),(295,1,'73.70.83.124','2018-04-14 12:17:53'),(296,1,'73.70.83.124','2018-04-14 12:19:01'),(297,21,'73.70.83.124','2018-04-14 12:19:36'),(298,1,'73.70.83.124','2018-04-14 12:20:13'),(299,21,'73.70.83.124','2018-04-14 12:20:33'),(300,1,'49.207.183.144','2018-04-16 04:36:45'),(301,1,'49.207.183.144','2018-04-16 04:48:06'),(302,1,'49.207.183.144','2018-04-16 09:33:25'),(303,1,'49.207.183.144','2018-04-16 12:09:25'),(304,1,'49.207.183.144','2018-04-16 12:12:55'),(305,1,'49.207.183.144','2018-04-16 12:17:05'),(306,23,'49.207.183.144','2018-04-16 12:20:40'),(307,23,'49.207.183.144','2018-04-16 12:33:47'),(308,1,'49.207.183.144','2018-04-16 12:35:51'),(309,1,'49.207.183.144','2018-04-16 01:38:08'),(310,1,'49.207.183.144','2018-04-16 01:45:48'),(311,1,'49.207.183.144','2018-04-16 01:50:00'),(312,1,'49.207.183.144','2018-04-16 01:51:18'),(313,1,'49.207.183.144','2018-04-16 01:55:34'),(314,1,'73.70.83.124','2018-04-16 03:16:41'),(315,1,'73.70.83.124','2018-04-16 03:35:00'),(316,1,'73.70.83.124','2018-04-16 03:39:59'),(317,1,'73.70.83.124','2018-04-16 04:09:26'),(318,1,'49.207.183.144','2018-04-17 04:38:42'),(319,1,'49.207.183.144','2018-04-17 05:06:43'),(320,1,'49.207.183.144','2018-04-17 05:25:53'),(321,1,'49.207.183.144','2018-04-17 06:46:04'),(322,1,'49.207.183.144','2018-04-17 06:47:21'),(323,1,'49.207.183.144','2018-04-17 06:58:01'),(324,1,'49.207.183.144','2018-04-17 07:45:36'),(325,1,'49.207.183.144','2018-04-17 09:45:33'),(326,1,'49.207.183.144','2018-04-17 10:07:29'),(327,1,'49.207.183.144','2018-04-17 10:09:36'),(328,23,'49.207.183.144','2018-04-17 10:13:42'),(329,11,'49.207.183.144','2018-04-17 10:18:38'),(330,1,'49.207.183.144','2018-04-17 10:22:08'),(331,1,'49.207.183.144','2018-04-17 10:39:51'),(332,1,'49.207.183.144','2018-04-17 11:10:17'),(333,1,'49.207.183.144','2018-04-17 11:12:29'),(334,1,'49.207.183.144','2018-04-17 11:58:23'),(335,1,'49.207.183.144','2018-04-17 12:02:58'),(336,23,'49.207.183.144','2018-04-17 12:20:03'),(337,23,'49.207.183.144','2018-04-17 12:26:00'),(338,1,'49.207.183.144','2018-04-17 12:51:08'),(339,1,'49.207.183.144','2018-04-17 12:53:01'),(340,1,'49.207.183.144','2018-04-17 12:58:12'),(341,23,'49.207.183.144','2018-04-17 01:09:49'),(342,1,'49.207.183.144','2018-04-17 01:13:36'),(343,23,'49.207.183.144','2018-04-17 01:19:00'),(344,1,'49.207.183.144','2018-04-17 01:33:59'),(345,23,'49.207.183.144','2018-04-17 01:34:36'),(346,11,'49.207.183.144','2018-04-17 01:35:19'),(347,1,'49.207.183.144','2018-04-17 01:39:31'),(348,1,'49.207.183.144','2018-04-17 01:40:39'),(349,21,'49.207.183.144','2018-04-17 01:46:20'),(350,1,'49.207.183.144','2018-04-17 01:51:46'),(351,1,'167.114.101.64','2018-04-17 01:52:32'),(352,1,'49.207.183.144','2018-04-17 02:14:38'),(353,1,'49.207.183.144','2018-04-17 02:24:38'),(354,11,'49.207.183.144','2018-04-17 02:25:46'),(355,1,'172.58.33.191','2018-04-17 09:05:24'),(356,1,'172.58.33.191','2018-04-17 09:06:13'),(357,1,'49.207.183.144','2018-04-18 04:46:10'),(358,23,'49.207.183.144','2018-04-18 04:47:16'),(359,1,'49.207.183.144','2018-04-18 04:48:15'),(360,23,'49.207.183.144','2018-04-18 04:48:43'),(361,11,'49.207.183.144','2018-04-18 05:07:51'),(362,21,'49.207.183.144','2018-04-18 05:08:05'),(363,1,'49.207.183.144','2018-04-18 05:17:59'),(364,11,'49.207.183.144','2018-04-18 05:20:07'),(365,1,'49.207.183.144','2018-04-18 05:20:50'),(366,1,'49.207.183.144','2018-04-18 05:21:35'),(367,1,'49.207.183.144','2018-04-18 05:26:08'),(368,1,'49.207.183.144','2018-04-18 05:47:11'),(369,23,'49.207.183.144','2018-04-18 05:48:43'),(370,21,'49.207.183.144','2018-04-18 05:49:12'),(371,1,'49.207.183.144','2018-04-18 05:49:45'),(372,1,'49.207.183.144','2018-04-18 06:03:57'),(373,1,'49.207.183.144','2018-04-18 06:05:12'),(374,1,'49.207.183.144','2018-04-18 06:27:23'),(375,21,'49.207.183.144','2018-04-18 06:35:35'),(376,1,'49.207.183.144','2018-04-18 06:51:09'),(377,1,'157.51.150.162','2018-04-18 06:51:17'),(378,21,'49.207.183.144','2018-04-18 07:09:02'),(379,21,'49.207.183.144','2018-04-18 07:11:45'),(380,23,'49.207.183.144','2018-04-18 07:17:13'),(381,11,'49.207.183.144','2018-04-18 07:17:22'),(382,21,'49.207.183.144','2018-04-18 07:17:32'),(383,21,'49.207.183.144','2018-04-18 07:18:22'),(384,11,'49.207.183.144','2018-04-18 07:18:42'),(385,25,'49.207.183.144','2018-04-18 07:23:51'),(386,25,'49.207.183.144','2018-04-18 07:29:12'),(387,25,'49.207.183.144','2018-04-18 07:33:22'),(388,23,'49.207.183.144','2018-04-18 07:40:22'),(389,28,'49.207.183.144','2018-04-18 07:46:37'),(390,28,'49.207.183.144','2018-04-18 07:48:03'),(391,21,'49.207.183.144','2018-04-18 12:01:03'),(392,21,'49.207.183.144','2018-04-18 12:03:43'),(393,21,'49.207.183.144','2018-04-18 12:04:30'),(394,23,'49.207.183.144','2018-04-18 12:09:41'),(395,23,'49.207.183.144','2018-04-18 12:10:42'),(396,23,'49.207.183.144','2018-04-18 12:10:49'),(397,21,'49.207.183.144','2018-04-18 12:17:07'),(398,21,'49.207.183.144','2018-04-18 12:18:30'),(399,23,'49.207.183.144','2018-04-18 12:21:01'),(400,23,'49.207.183.144','2018-04-18 12:23:36'),(401,28,'49.207.183.144','2018-04-18 12:23:48'),(402,25,'49.207.183.144','2018-04-18 12:24:02'),(403,25,'49.207.183.144','2018-04-18 12:26:50'),(404,21,'49.207.183.144','2018-04-18 12:27:01'),(405,23,'49.207.183.144','2018-04-18 12:31:58'),(406,23,'49.207.183.144','2018-04-18 12:34:16'),(407,23,'49.207.183.144','2018-04-18 12:36:59'),(408,23,'49.207.183.144','2018-04-18 12:41:00'),(409,23,'49.207.183.144','2018-04-18 12:50:22'),(410,1,'49.207.183.144','2018-04-18 01:33:19'),(411,23,'49.207.183.144','2018-04-18 01:36:31'),(412,21,'49.207.183.144','2018-04-18 01:55:28'),(413,1,'131.96.53.165','2018-04-18 03:50:29'),(414,1,'73.70.83.124','2018-04-18 06:16:01'),(415,1,'73.70.83.124','2018-04-18 06:17:54'),(416,21,'73.70.83.124','2018-04-18 06:18:37'),(417,1,'172.58.33.191','2018-04-18 07:56:52'),(418,1,'131.96.53.165','2018-04-18 08:24:50'),(419,1,'49.207.183.144','2018-04-19 04:30:33'),(420,11,'49.207.183.144','2018-04-19 04:33:55'),(421,1,'49.207.183.144','2018-04-19 05:24:51'),(422,28,'49.207.183.144','2018-04-19 05:38:24'),(423,1,'49.207.183.144','2018-04-19 07:40:10'),(424,23,'49.207.183.144','2018-04-19 07:40:51'),(425,37,'49.207.183.144','2018-04-19 09:05:11'),(426,37,'49.207.183.144','2018-04-19 09:14:48'),(427,1,'49.207.183.144','2018-04-19 10:12:07'),(428,1,'49.207.183.144','2018-04-19 10:22:41'),(429,23,'49.207.183.144','2018-04-19 10:23:17'),(430,1,'73.237.49.116','2018-04-19 02:23:52'),(431,1,'49.207.183.144','2018-04-20 04:26:04'),(432,1,'49.207.183.144','2018-04-20 04:26:35'),(433,1,'49.207.183.144','2018-04-20 05:11:35'),(434,11,'49.207.183.144','2018-04-20 05:20:24'),(435,23,'49.207.183.144','2018-04-20 05:24:25'),(436,1,'49.207.183.144','2018-04-20 06:18:33'),(437,25,'49.207.183.144','2018-04-20 06:38:19'),(438,1,'49.207.183.144','2018-04-20 06:42:37'),(439,25,'49.207.183.144','2018-04-20 06:45:38'),(440,39,'49.207.183.144','2018-04-20 07:43:53'),(441,39,'49.207.183.144','2018-04-20 07:44:48'),(442,23,'49.207.183.144','2018-04-20 09:54:31'),(443,25,'49.207.183.144','2018-04-20 09:56:00'),(444,23,'49.207.183.144','2018-04-20 10:02:56'),(445,39,'49.207.183.144','2018-04-20 10:08:26'),(446,39,'49.207.183.144','2018-04-20 10:08:53'),(447,25,'49.207.183.144','2018-04-20 10:33:31'),(448,35,'49.207.183.144','2018-04-20 10:36:04'),(449,23,'49.207.183.144','2018-04-20 10:37:06'),(450,23,'49.207.183.144','2018-04-20 12:29:24'),(451,1,'49.207.183.144','2018-04-20 12:58:45'),(452,39,'49.207.183.144','2018-04-20 01:08:54'),(453,1,'49.207.183.144','2018-04-20 01:10:16'),(454,8,'49.207.183.144','2018-04-20 01:14:24'),(455,8,'49.207.183.144','2018-04-20 01:35:41'),(456,1,'49.207.183.144','2018-04-23 04:17:45'),(457,11,'49.207.183.144','2018-04-23 04:20:47'),(458,39,'49.207.183.144','2018-04-23 06:48:02'),(459,25,'49.207.183.144','2018-04-23 07:17:24'),(460,1,'49.207.183.144','2018-04-23 07:21:55'),(461,1,'49.207.183.144','2018-04-23 08:52:13'),(462,1,'49.207.183.144','2018-04-24 04:39:11'),(463,1,'49.207.183.144','2018-04-24 05:06:17'),(464,1,'49.207.183.144','2018-04-24 05:06:29'),(465,1,'49.207.183.144','2018-04-24 07:14:54'),(466,1,'49.207.183.144','2018-04-24 07:29:29'),(467,1,'49.207.183.144','2018-04-24 07:30:41'),(468,1,'49.207.183.144','2018-04-25 04:46:13'),(469,1,'49.207.183.144','2018-04-25 05:15:18'),(470,1,'49.207.183.144','2018-04-26 06:45:46'),(471,1,'49.207.183.144','2018-04-26 07:41:26'),(472,1,'49.207.183.144','2018-04-26 01:06:17'),(473,1,'49.207.183.144','2018-04-30 06:43:51'),(474,1,'49.207.183.144','2018-04-30 01:58:35'),(475,1,'49.207.183.144','2018-05-02 12:05:08'),(476,1,'49.207.183.144','2018-05-03 05:11:21'),(477,1,'49.207.183.144','2018-05-03 05:14:33'),(478,1,'49.207.183.144','2018-05-03 05:39:10'),(479,1,'49.207.183.144','2018-05-03 06:46:26'),(480,1,'49.207.183.144','2018-05-03 06:57:57'),(481,39,'49.207.183.144','2018-05-03 08:54:34'),(482,1,'157.50.46.94','2018-05-03 09:00:39'),(483,1,'157.50.198.42','2018-05-03 09:36:13'),(484,1,'208.54.36.160','2018-05-03 11:33:44'),(485,1,'50.245.48.19','2018-05-03 11:46:51'),(486,1,'49.207.183.144','2018-05-03 01:30:39'),(487,1,'49.207.183.144','2018-05-03 01:48:20'),(488,1,'49.207.183.144','2018-05-04 05:09:17'),(489,1,'73.237.49.116','2018-05-04 07:41:14'),(490,1,'49.207.183.144','2018-05-07 12:57:18'),(491,1,'12.70.20.155','2018-05-07 07:46:14'),(492,1,'49.207.183.144','2018-05-08 05:31:04'),(493,1,'49.207.183.144','2018-05-08 01:52:57'),(494,25,'49.207.183.144','2018-05-08 02:14:56'),(495,25,'49.207.183.144','2018-05-08 02:27:28'),(496,25,'49.207.183.144','2018-05-08 02:32:45'),(497,1,'98.192.2.132','2018-05-08 02:51:42'),(498,1,'98.192.2.132','2018-05-08 08:31:28'),(499,1,'131.96.53.165','2018-05-08 08:31:43'),(500,39,'49.207.183.144','2018-05-09 05:03:31'),(501,1,'49.207.183.144','2018-05-09 05:08:52'),(502,1,'49.207.183.144','2018-05-09 05:48:54'),(503,25,'49.207.183.144','2018-05-09 05:53:18'),(504,1,'12.70.20.155','2018-05-09 08:08:31'),(505,1,'49.207.183.144','2018-05-10 04:45:50'),(506,25,'49.207.183.144','2018-05-10 04:46:07'),(507,1,'49.207.183.144','2018-05-10 05:43:13'),(508,25,'49.207.183.144','2018-05-10 06:21:09'),(509,1,'49.207.183.144','2018-05-10 08:58:30'),(510,39,'49.207.183.144','2018-05-10 09:44:46'),(511,1,'49.207.183.144','2018-05-10 09:57:26'),(512,1,'49.207.183.144','2018-05-10 09:58:42'),(513,1,'98.192.2.132','2018-05-10 12:17:33'),(514,1,'49.207.183.144','2018-05-10 02:19:57'),(515,1,'73.237.49.116','2018-05-10 06:25:25'),(516,1,'49.207.183.144','2018-05-11 04:36:02'),(517,1,'49.207.183.144','2018-05-11 05:24:51'),(518,1,'49.207.183.144','2018-05-11 05:27:58'),(519,1,'49.207.183.144','2018-05-11 05:34:34'),(520,25,'49.207.183.144','2018-05-11 05:51:45'),(521,1,'49.207.183.144','2018-05-11 05:54:16'),(522,1,'49.207.183.144','2018-05-11 06:17:01'),(523,1,'49.207.183.144','2018-05-11 06:57:43'),(524,25,'49.207.183.144','2018-05-11 01:23:08'),(525,1,'49.207.183.144','2018-05-11 01:39:14'),(526,1,'49.207.183.144','2018-05-11 01:43:38'),(527,1,'49.207.183.144','2018-05-11 01:49:38'),(528,1,'49.207.183.144','2018-05-11 01:51:50'),(529,1,'49.207.183.144','2018-05-11 01:59:10'),(530,1,'49.207.183.144','2018-05-11 02:06:02'),(531,1,'49.207.183.144','2018-05-11 02:18:19'),(532,1,'49.207.183.144','2018-05-12 04:49:31'),(533,1,'49.207.183.144','2018-05-12 05:11:09'),(534,1,'49.207.183.144','2018-05-12 05:29:30'),(535,1,'49.207.183.144','2018-05-12 06:54:13'),(536,1,'49.207.183.144','2018-05-12 07:19:10'),(537,1,'49.207.183.144','2018-05-12 12:50:05'),(538,1,'49.207.183.144','2018-05-14 04:33:40'),(539,1,'49.207.183.144','2018-05-14 04:53:27'),(540,1,'49.207.183.144','2018-05-14 05:10:02'),(541,1,'49.207.183.144','2018-05-14 05:12:19'),(542,1,'49.207.183.144','2018-05-14 06:48:51'),(543,1,'49.207.183.144','2018-05-14 08:09:02'),(544,1,'49.207.183.144','2018-05-14 09:30:58'),(545,1,'49.207.183.144','2018-05-14 12:27:02'),(546,1,'131.96.53.165','2018-05-14 04:17:53'),(547,1,'49.207.183.144','2018-05-15 04:47:02'),(548,1,'49.207.183.144','2018-05-15 05:36:03'),(549,25,'49.207.183.144','2018-05-15 05:48:49'),(550,39,'49.207.183.144','2018-05-15 05:49:38'),(551,1,'49.207.183.144','2018-05-16 12:18:00'),(552,1,'131.96.53.165','2018-05-16 02:47:04'),(553,1,'73.106.147.188','2018-05-16 05:54:36'),(554,1,'131.96.205.199','2018-05-16 07:21:05'),(555,1,'49.207.183.144','2018-05-17 05:17:05'),(556,1,'49.207.183.144','2018-05-17 06:03:40'),(557,39,'49.207.183.144','2018-05-17 06:07:29'),(558,1,'49.207.183.144','2018-05-18 04:46:18'),(559,1,'174.218.16.10','2018-05-18 04:05:44'),(560,1,'131.96.53.165','2018-05-18 07:09:04'),(561,1,'174.218.137.169','2018-05-18 07:59:19'),(562,1,'174.218.137.169','2018-05-18 08:02:15'),(563,1,'73.237.49.116','2018-05-19 05:58:09'),(564,1,'49.207.183.144','2018-05-21 05:16:15'),(565,1,'49.207.183.144','2018-05-21 05:38:07'),(566,1,'49.207.183.144','2018-05-22 04:33:20'),(567,1,'49.207.183.144','2018-05-22 06:53:25'),(568,1,'67.136.128.119','2018-05-22 05:29:01'),(569,1,'49.207.183.144','2018-05-23 05:00:47'),(570,1,'49.207.183.144','2018-05-23 06:12:52'),(571,1,'49.207.183.144','2018-05-23 06:45:29'),(572,39,'49.207.183.144','2018-05-23 08:03:51'),(573,25,'49.207.183.144','2018-05-23 08:05:24'),(574,1,'172.58.2.22','2018-05-23 12:51:28'),(575,1,'67.136.128.119','2018-05-23 03:44:10'),(576,1,'49.207.183.144','2018-05-24 04:31:51'),(577,1,'49.207.183.144','2018-05-24 11:31:38'),(578,1,'49.207.183.144','2018-05-24 12:36:57'),(579,1,'12.206.21.98','2018-05-24 12:50:47'),(580,1,'49.207.183.144','2018-05-25 05:18:34'),(581,1,'49.207.183.144','2018-05-25 05:49:42'),(582,1,'49.207.183.144','2018-05-25 02:22:35'),(583,1,'49.207.183.144','2018-05-26 05:08:37'),(584,1,'49.207.183.144','2018-05-28 05:29:24'),(585,1,'98.192.2.132','2018-05-29 02:10:28'),(586,1,'49.207.183.144','2018-05-29 07:11:41'),(587,1,'49.207.183.144','2018-05-29 11:56:47'),(588,1,'49.207.183.144','2018-05-29 12:39:09'),(589,1,'49.207.183.144','2018-05-29 12:51:39'),(590,1,'96.67.126.34','2018-05-29 02:42:55'),(591,1,'131.96.53.165','2018-05-29 06:33:57'),(592,1,'172.58.4.226','2018-05-29 09:35:51'),(593,1,'49.207.183.144','2018-05-30 04:56:39'),(594,1,'49.207.183.144','2018-05-30 05:28:08'),(595,1,'49.207.183.144','2018-05-30 05:46:41'),(596,1,'49.207.183.144','2018-05-30 06:28:35'),(597,1,'49.207.183.144','2018-05-30 07:45:27'),(598,1,'49.207.183.144','2018-05-30 10:13:27'),(599,1,'98.192.2.132','2018-05-30 11:57:42'),(600,1,'49.207.183.144','2018-05-30 12:26:21'),(601,1,'131.96.53.165','2018-05-30 03:12:52'),(602,1,'49.207.183.144','2018-05-31 05:16:22'),(603,1,'49.207.183.144','2018-05-31 05:19:12'),(604,1,'49.207.183.144','2018-05-31 05:43:46'),(605,1,'49.207.183.144','2018-05-31 08:01:45'),(606,1,'49.207.183.144','2018-05-31 09:00:46'),(607,1,'49.207.183.144','2018-05-31 09:31:47'),(608,1,'49.207.183.144','2018-05-31 09:56:19'),(609,1,'49.207.183.144','2018-05-31 11:49:08'),(610,1,'49.207.183.144','2018-05-31 11:49:26'),(611,1,'49.207.183.144','2018-05-31 12:30:28'),(612,1,'49.207.183.144','2018-05-31 12:40:15'),(613,1,'49.207.183.144','2018-05-31 12:48:58'),(614,1,'96.67.126.34','2018-05-31 12:59:20'),(615,1,'49.207.183.144','2018-05-31 01:02:44'),(616,1,'49.207.183.144','2018-05-31 01:07:59'),(617,1,'131.96.53.165','2018-05-31 06:04:25'),(618,1,'49.207.183.144','2018-06-01 05:26:39'),(619,1,'49.207.183.144','2018-06-01 05:38:05'),(620,1,'49.207.183.144','2018-06-01 11:52:25'),(621,1,'49.207.183.144','2018-06-01 01:00:04'),(622,1,'73.106.147.188','2018-06-01 02:02:23'),(623,1,'73.106.153.97','2018-06-01 04:31:28'),(624,1,'49.207.183.144','2018-06-04 05:03:16'),(625,1,'49.207.183.144','2018-06-04 05:42:14'),(626,1,'131.96.53.165','2018-06-04 04:38:42'),(627,1,'49.207.183.144','2018-06-05 04:57:42'),(628,1,'49.207.183.144','2018-06-05 05:07:39'),(629,1,'49.207.183.144','2018-06-05 08:06:03'),(630,1,'49.207.183.144','2018-06-05 08:12:42'),(631,1,'49.207.183.144','2018-06-05 09:34:18'),(632,1,'49.207.183.144','2018-06-05 09:35:55'),(633,1,'49.207.183.144','2018-06-05 09:55:42'),(634,1,'131.96.53.165','2018-06-05 03:59:19'),(635,1,'131.96.53.165','2018-06-05 07:09:54'),(636,1,'49.207.183.144','2018-06-06 04:34:35'),(637,1,'49.207.183.144','2018-06-06 05:09:47'),(638,1,'49.207.183.144','2018-06-06 05:13:21'),(639,1,'49.207.183.144','2018-06-06 05:15:33'),(640,1,'49.207.183.144','2018-06-06 05:22:03'),(641,1,'49.207.183.144','2018-06-06 05:23:52'),(642,44,'49.207.183.144','2018-06-06 05:26:31'),(643,44,'49.207.183.144','2018-06-06 05:28:30'),(644,1,'49.207.183.144','2018-06-06 05:55:22'),(645,1,'49.207.183.144','2018-06-06 06:32:08'),(646,44,'49.207.183.144','2018-06-06 07:26:49'),(647,1,'49.207.183.144','2018-06-06 07:35:16'),(648,1,'49.207.183.144','2018-06-06 07:41:30'),(649,1,'49.207.183.144','2018-06-06 07:50:29'),(650,1,'49.207.183.144','2018-06-06 07:50:38'),(651,44,'49.207.183.144','2018-06-06 08:56:41'),(652,1,'49.207.183.144','2018-06-06 10:51:07'),(653,39,'49.207.183.144','2018-06-06 11:44:20'),(654,1,'49.207.183.144','2018-06-06 11:56:25'),(655,24,'49.207.183.144','2018-06-06 01:41:00'),(656,1,'131.96.53.165','2018-06-06 05:34:49'),(657,1,'49.207.183.144','2018-06-07 05:35:46'),(658,1,'49.207.183.144','2018-06-07 05:40:34'),(659,1,'49.207.183.144','2018-06-07 05:40:38'),(660,1,'49.207.183.144','2018-06-07 06:13:52'),(661,1,'49.207.183.144','2018-06-07 06:23:44'),(662,1,'49.207.183.144','2018-06-07 09:32:19'),(663,1,'49.207.183.144','2018-06-07 11:38:26'),(664,1,'49.207.183.144','2018-06-07 12:08:57'),(665,1,'49.207.183.144','2018-06-07 01:50:59'),(666,1,'49.207.183.144','2018-06-07 02:08:47'),(667,1,'49.207.183.144','2018-06-07 02:11:26'),(668,1,'131.96.53.165','2018-06-07 05:12:24'),(669,1,'49.207.183.144','2018-06-08 05:06:08'),(670,1,'49.207.183.144','2018-06-08 05:16:33'),(671,1,'49.207.183.144','2018-06-08 05:25:37'),(672,1,'49.207.183.144','2018-06-08 09:30:38'),(673,1,'49.207.183.144','2018-06-08 11:51:24'),(674,1,'49.207.183.144','2018-06-08 11:53:45'),(675,1,'49.207.183.144','2018-06-08 11:54:23'),(676,1,'131.96.53.165','2018-06-08 06:05:00'),(677,1,'67.211.15.50','2018-06-08 08:14:51'),(678,1,'49.207.183.144','2018-06-09 07:23:19'),(679,1,'67.211.15.50','2018-06-09 02:30:56'),(680,1,'73.106.147.188','2018-06-09 05:24:25'),(681,1,'98.192.2.132','2018-06-11 02:10:28'),(682,1,'49.207.183.144','2018-06-11 05:42:46'),(683,1,'49.207.183.144','2018-06-11 05:44:45'),(684,1,'49.207.183.144','2018-06-11 09:04:59'),(685,1,'49.207.183.144','2018-06-11 09:07:34'),(686,1,'49.207.183.144','2018-06-11 10:18:46'),(687,1,'49.207.183.144','2018-06-11 10:27:59'),(688,1,'49.207.183.144','2018-06-11 12:04:24'),(689,1,'49.207.183.144','2018-06-11 12:05:51'),(690,1,'49.207.183.144','2018-06-11 12:08:37'),(691,1,'49.207.183.144','2018-06-11 12:08:37'),(692,1,'49.207.183.144','2018-06-11 01:13:54'),(693,1,'49.207.183.144','2018-06-11 01:17:47'),(694,1,'49.207.183.144','2018-06-11 01:20:33'),(695,1,'49.207.183.144','2018-06-11 01:37:12'),(696,1,'49.207.183.144','2018-06-11 01:55:01'),(697,1,'131.96.53.165','2018-06-11 05:41:36'),(698,1,'49.207.183.144','2018-06-12 05:01:27'),(699,1,'49.207.183.144','2018-06-12 06:07:51'),(700,1,'49.207.183.144','2018-06-12 06:08:26'),(701,1,'49.207.183.144','2018-06-12 09:32:09'),(702,1,'49.207.183.144','2018-06-12 10:51:52'),(703,1,'98.192.2.132','2018-06-13 02:52:05'),(704,1,'49.207.183.144','2018-06-13 05:07:44'),(705,1,'49.207.183.144','2018-06-13 05:10:14'),(706,1,'49.207.183.144','2018-06-13 05:16:47'),(707,1,'49.207.183.144','2018-06-13 05:21:02'),(708,1,'49.207.183.144','2018-06-13 05:58:24'),(709,1,'49.207.183.144','2018-06-13 07:06:36'),(710,44,'49.207.183.144','2018-06-13 07:09:14'),(711,1,'49.207.183.144','2018-06-13 07:35:00'),(712,1,'49.207.183.144','2018-06-13 07:40:38'),(713,1,'49.207.183.144','2018-06-13 07:42:27'),(714,1,'76.105.98.7','2018-06-13 09:01:45'),(715,1,'49.207.183.144','2018-06-13 09:17:20'),(716,1,'49.207.183.144','2018-06-13 10:30:53'),(717,1,'49.207.183.144','2018-06-13 10:32:17'),(718,1,'49.207.183.144','2018-06-13 12:25:03'),(719,1,'76.105.98.7','2018-06-13 01:27:31'),(720,1,'131.96.53.165','2018-06-13 04:37:49'),(721,1,'96.86.237.161','2018-06-13 05:52:20'),(722,1,'172.58.7.69','2018-06-13 06:11:07'),(723,1,'172.58.7.69','2018-06-13 06:36:57'),(724,1,'49.207.183.144','2018-06-14 05:06:31'),(725,1,'49.207.183.144','2018-06-14 05:32:44'),(726,1,'49.207.183.144','2018-06-14 05:42:18'),(727,1,'49.207.183.144','2018-06-14 06:56:08'),(728,1,'73.106.153.97','2018-06-14 01:22:01'),(729,1,'172.58.7.69','2018-06-14 01:55:56'),(730,1,'67.211.15.50','2018-06-14 02:47:52'),(731,1,'172.58.7.69','2018-06-14 03:37:04'),(732,1,'172.58.7.69','2018-06-14 03:40:12'),(733,1,'98.242.68.166','2018-06-14 07:42:24'),(734,1,'98.242.68.166','2018-06-14 07:50:06'),(735,1,'98.242.68.166','2018-06-14 08:00:20'),(736,28,'98.242.68.166','2018-06-14 08:01:11'),(737,1,'98.242.68.166','2018-06-14 08:03:27'),(738,28,'98.242.68.166','2018-06-14 08:10:09'),(739,1,'98.242.68.166','2018-06-14 08:11:17'),(740,28,'98.242.68.166','2018-06-14 08:13:32'),(741,1,'98.242.68.166','2018-06-14 08:26:14'),(742,45,'75.24.110.168','2018-06-15 03:41:07'),(743,1,'76.105.98.7','2018-06-15 08:04:41'),(744,1,'96.86.237.161','2018-06-15 10:07:50'),(745,1,'96.67.126.34','2018-06-16 05:53:31'),(746,1,'73.237.49.116','2018-06-16 06:04:41'),(747,1,'73.106.147.188','2018-06-17 05:40:35'),(748,1,'76.105.98.7','2018-06-18 03:16:36'),(749,1,'49.207.183.144','2018-06-18 04:49:34'),(750,1,'49.207.183.144','2018-06-18 05:03:35'),(751,47,'157.51.89.20','2018-06-18 06:35:56'),(752,47,'157.51.89.20','2018-06-18 06:37:03'),(753,1,'49.207.183.144','2018-06-18 06:46:08'),(754,1,'157.51.89.20','2018-06-18 06:52:36'),(755,1,'49.207.183.144','2018-06-18 08:16:20'),(756,1,'76.105.98.7','2018-06-18 12:28:28'),(757,1,'96.67.126.34','2018-06-18 07:52:26'),(758,1,'172.58.4.85','2018-06-18 08:08:00'),(759,1,'96.67.126.34','2018-06-18 08:14:37'),(760,1,'96.67.126.34','2018-06-18 09:10:20'),(761,1,'49.207.183.144','2018-06-19 04:26:33'),(762,1,'49.207.183.144','2018-06-19 04:36:30'),(763,1,'49.207.183.144','2018-06-19 04:57:32'),(764,49,'131.96.53.170','2018-06-19 02:26:35'),(765,1,'131.96.214.97','2018-06-19 02:46:30'),(766,1,'49.207.183.144','2018-06-20 05:04:33'),(767,1,'49.207.183.144','2018-06-20 05:27:19'),(768,1,'131.96.53.165','2018-06-20 05:42:49'),(769,1,'67.211.15.50','2018-06-21 02:59:28'),(770,1,'49.207.183.144','2018-06-21 05:29:50'),(771,1,'131.96.211.27','2018-06-21 06:07:29'),(772,1,'73.106.147.188','2018-06-22 01:02:33'),(773,1,'49.207.183.144','2018-06-22 05:06:29'),(774,1,'49.207.183.144','2018-06-22 06:55:01'),(775,1,'49.207.183.144','2018-06-22 09:01:47'),(776,1,'96.67.126.34','2018-06-22 07:10:37'),(777,1,'96.67.126.34','2018-06-22 07:18:47'),(778,1,'49.207.183.144','2018-06-23 04:10:56'),(779,1,'73.237.49.116','2018-06-23 06:21:14'),(780,1,'73.106.147.188','2018-06-23 07:50:12'),(781,1,'172.58.4.193','2018-06-25 02:24:49'),(782,1,'73.106.147.188','2018-06-25 03:13:34'),(783,1,'49.207.183.144','2018-06-25 05:01:59'),(784,1,'49.207.183.144','2018-06-25 05:24:04'),(785,1,'172.58.3.49','2018-06-25 12:06:01'),(786,1,'49.207.183.144','2018-06-25 12:06:54'),(787,1,'172.58.3.49','2018-06-25 12:14:20'),(788,1,'67.211.15.50','2018-06-25 12:44:41'),(789,25,'49.207.183.144','2018-06-25 02:00:04'),(790,11,'49.207.183.144','2018-06-25 02:01:46'),(791,1,'172.58.3.49','2018-06-25 07:56:27'),(792,1,'12.206.21.98','2018-06-25 08:13:51'),(793,1,'131.96.53.165','2018-06-25 08:14:29'),(794,1,'172.58.3.49','2018-06-25 10:26:00'),(795,1,'49.207.183.144','2018-06-26 04:04:51'),(796,1,'49.207.183.144','2018-06-26 04:28:42'),(797,1,'49.207.183.144','2018-06-26 05:30:59'),(798,1,'49.207.183.144','2018-06-26 05:37:04'),(799,1,'12.206.21.98','2018-06-26 02:58:30'),(800,1,'98.242.68.166','2018-06-26 08:10:58'),(801,1,'98.242.68.166','2018-06-26 09:43:42'),(802,1,'49.207.183.144','2018-06-27 04:11:31'),(803,1,'49.207.183.144','2018-06-27 04:40:39'),(804,1,'49.207.183.144','2018-06-27 05:02:40'),(805,1,'49.207.183.144','2018-06-27 05:28:46'),(806,1,'49.207.183.144','2018-06-27 06:04:40'),(807,1,'49.207.183.144','2018-06-27 06:31:07'),(808,1,'49.207.183.144','2018-06-27 06:55:16'),(809,25,'49.207.183.144','2018-06-27 07:09:42'),(810,25,'49.207.183.144','2018-06-27 07:25:40'),(811,1,'49.207.183.144','2018-06-27 07:31:18'),(812,25,'49.207.183.144','2018-06-27 07:45:05'),(813,1,'49.207.183.144','2018-06-27 07:46:19'),(814,1,'49.207.183.144','2018-06-27 09:48:16'),(815,1,'49.207.183.144','2018-06-27 10:18:34'),(816,1,'49.207.183.144','2018-06-27 10:20:46'),(817,39,'49.207.183.144','2018-06-27 10:43:46'),(818,1,'172.58.7.101','2018-06-27 01:22:11'),(819,1,'172.58.7.101','2018-06-27 03:02:26'),(820,1,'172.58.7.101','2018-06-27 09:32:07'),(821,1,'49.207.183.144','2018-06-28 04:52:40'),(822,1,'49.207.183.144','2018-06-28 05:04:18'),(823,1,'76.105.98.7','2018-06-29 03:00:08'),(824,1,'49.207.183.144','2018-06-29 05:09:52'),(825,1,'49.207.183.144','2018-06-29 05:20:15'),(826,1,'49.207.183.144','2018-06-29 06:37:35'),(827,1,'49.207.183.144','2018-06-29 12:23:15'),(828,1,'49.207.183.144','2018-06-29 01:42:57'),(829,1,'49.207.183.144','2018-06-29 02:07:16'),(830,1,'73.106.147.188','2018-06-29 03:38:50'),(831,1,'157.51.72.93','2018-06-30 07:05:23'),(832,1,'67.211.15.50','2018-06-30 07:36:52'),(833,1,'73.106.147.188','2018-07-01 03:47:59'),(834,1,'76.105.98.7','2018-07-01 05:25:06'),(835,1,'172.58.4.155','2018-07-01 05:25:43'),(836,1,'96.67.126.34','2018-07-01 06:24:45'),(837,1,'73.106.147.188','2018-07-01 08:19:19'),(838,1,'49.207.183.144','2018-07-02 04:58:27'),(839,1,'49.207.183.144','2018-07-02 05:01:29'),(840,1,'49.207.183.144','2018-07-02 06:56:04'),(841,1,'49.207.183.144','2018-07-02 07:06:01'),(842,1,'73.106.147.188','2018-07-02 07:32:36'),(843,1,'49.207.183.144','2018-07-02 11:54:28'),(844,1,'49.207.183.144','2018-07-02 11:55:37'),(845,1,'49.207.183.144','2018-07-02 12:05:07'),(846,1,'131.96.53.165','2018-07-02 03:03:25'),(847,1,'24.30.10.131','2018-07-02 05:21:44'),(848,1,'172.58.3.193','2018-07-02 05:37:20'),(849,1,'49.207.183.144','2018-07-03 05:32:48'),(850,1,'49.207.183.144','2018-07-03 11:23:56'),(851,1,'49.207.183.144','2018-07-03 01:45:19'),(852,1,'172.58.3.193','2018-07-03 01:45:55'),(853,1,'49.207.183.144','2018-07-03 01:46:11'),(854,1,'157.51.112.101','2018-07-03 05:01:35'),(855,1,'70.158.100.90','2018-07-03 07:09:35'),(856,1,'157.51.101.66','2018-07-04 02:28:40'),(857,1,'49.207.183.144','2018-07-04 05:46:34'),(858,1,'172.58.3.121','2018-07-04 06:28:17'),(859,1,'49.207.183.144','2018-07-04 10:50:36'),(860,1,'172.58.3.121','2018-07-04 01:02:01'),(861,1,'49.207.183.144','2018-07-04 01:38:09'),(862,1,'49.207.183.144','2018-07-04 01:50:38'),(863,1,'96.67.126.34','2018-07-05 05:58:14'),(864,1,'131.96.215.48','2018-07-05 06:14:49'),(865,1,'96.67.126.34','2018-07-05 06:21:50'),(866,1,'49.207.183.144','2018-07-06 04:58:36'),(867,1,'49.207.183.144','2018-07-07 05:04:17'),(868,1,'73.106.147.188','2018-07-07 05:15:30'),(869,1,'24.30.10.131','2018-07-07 03:35:35'),(870,1,'157.51.88.30','2018-07-07 04:23:59'),(871,1,'73.237.49.116','2018-07-07 08:55:32'),(872,1,'96.67.126.34','2018-07-08 02:22:05'),(873,1,'96.67.126.34','2018-07-08 02:24:37'),(874,1,'96.67.126.34','2018-07-08 03:41:00'),(875,1,'67.211.15.50','2018-07-08 05:40:34'),(876,1,'73.106.147.188','2018-07-08 09:32:12'),(877,1,'49.207.183.144','2018-07-09 05:03:21'),(878,1,'49.207.183.144','2018-07-09 05:12:27'),(879,1,'49.207.183.144','2018-07-09 07:17:36'),(880,1,'49.207.183.144','2018-07-09 12:44:05'),(881,1,'172.58.3.238','2018-07-09 03:09:41'),(882,1,'131.96.53.165','2018-07-09 04:05:44'),(883,1,'49.207.183.144','2018-07-10 06:14:23'),(884,1,'49.207.183.144','2018-07-10 07:30:34'),(885,1,'96.67.126.34','2018-07-10 03:01:06'),(886,1,'49.207.183.144','2018-07-11 07:17:40'),(887,1,'49.207.183.144','2018-07-12 05:21:12'),(888,1,'49.207.183.144','2018-07-12 12:13:15'),(889,1,'49.207.183.144','2018-07-13 04:56:48'),(890,1,'49.207.183.144','2018-07-13 05:02:30'),(891,1,'50.243.217.51','2018-07-13 08:11:26'),(892,1,'73.237.49.116','2018-07-15 07:03:00'),(893,1,'96.67.126.34','2018-07-15 07:10:02'),(894,1,'73.237.49.116','2018-07-16 03:57:50'),(895,1,'73.237.49.116','2018-07-16 04:16:41'),(896,1,'157.51.230.46','2018-07-16 05:56:37'),(897,1,'131.96.53.165','2018-07-16 08:51:07'),(898,1,'73.106.147.188','2018-07-16 09:19:02'),(899,1,'67.211.15.50','2018-07-17 01:51:53'),(900,1,'131.96.214.3','2018-07-17 03:05:25'),(901,1,'172.58.3.33','2018-07-17 04:59:30'),(902,1,'131.96.53.165','2018-07-17 05:02:54'),(903,1,'76.105.98.7','2018-07-17 05:08:52'),(904,1,'131.96.53.165','2018-07-17 05:39:50'),(905,1,'172.58.3.33','2018-07-17 09:24:11'),(906,1,'49.207.183.144','2018-07-18 05:11:52'),(907,1,'49.207.183.144','2018-07-19 05:10:45'),(908,1,'76.105.98.7','2018-07-20 05:52:20'),(909,1,'76.105.98.7','2018-07-20 05:55:01'),(910,1,'76.105.98.7','2018-07-20 06:44:40');

--
-- Table structure for table `proposal_comments`
--

CREATE TABLE `proposal_comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `user_name` varchar(245) DEFAULT NULL,
  `university_id` int(11) DEFAULT NULL,
  `proposal_id` int(11) DEFAULT NULL,
  `comments` text,
  `view_status` enum('Y','N') DEFAULT NULL,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_date` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `proposal_comments`
--

INSERT INTO `proposal_comments` VALUES (1,1,'Admin',1,6,'test.',NULL,'2018-07-17 13:24:25',NULL);

--
-- Table structure for table `proposal_comments_status`
--

CREATE TABLE `proposal_comments_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `university_id` int(11) DEFAULT NULL,
  `proposal_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `comment_count` int(11) DEFAULT NULL,
  `status` enum('Y','N') DEFAULT NULL,
  `updated_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `proposal_comments_status`
--

INSERT INTO `proposal_comments_status` VALUES (1,26,34,1,0,NULL,'2018-04-20 05:48:30'),(2,1,10,1,1,NULL,'2018-04-20 09:50:52'),(3,19,22,1,1,NULL,'2018-04-20 10:04:01'),(4,25,17,23,1,NULL,'2018-04-20 10:04:55'),(5,19,25,23,1,NULL,'2018-04-20 10:07:15'),(6,19,25,1,1,NULL,'2018-06-06 06:15:55'),(7,27,36,39,2,NULL,'2018-04-23 06:59:41'),(8,18,32,11,1,NULL,'2018-04-20 10:15:14'),(9,27,35,39,0,NULL,'2018-04-20 06:21:08'),(10,18,33,39,1,NULL,'2018-04-20 10:38:08'),(11,13,15,25,1,NULL,'2018-04-20 10:40:00'),(12,19,26,1,0,NULL,'2018-04-20 08:59:29'),(13,27,35,1,0,NULL,'2018-04-20 08:59:44'),(14,18,37,1,1,NULL,'2018-05-15 05:56:53'),(15,18,32,25,1,NULL,'2018-04-23 07:37:15'),(16,18,33,25,1,NULL,'2018-04-23 07:37:20'),(17,13,4,1,0,NULL,'2018-05-11 05:24:17'),(18,18,32,1,1,NULL,'2018-05-12 02:00:32'),(19,1,1,1,0,NULL,'2018-05-18 12:16:04'),(20,13,15,1,1,NULL,'2018-05-23 11:49:13'),(21,18,33,1,1,NULL,'2018-05-31 11:46:47'),(22,25,17,1,1,NULL,'2018-06-05 04:59:28'),(23,27,36,1,4,NULL,'2018-06-05 09:06:45'),(24,18,45,1,5,NULL,'2018-06-06 06:23:57'),(25,26,47,1,0,NULL,'2018-06-06 02:43:38'),(26,13,15,44,1,NULL,'2018-06-06 04:56:56'),(27,26,27,1,2,NULL,'2018-06-13 07:03:35'),(28,26,27,44,2,NULL,'2018-06-13 03:09:59'),(29,46,52,28,0,NULL,'2018-06-14 16:21:30'),(30,46,53,1,3,NULL,'2018-06-15 22:29:05'),(31,46,54,1,0,NULL,'2018-06-19 11:15:38'),(32,1,6,1,1,NULL,'2018-07-17 17:24:28'),(33,1,5,1,0,NULL,'2018-07-17 13:30:18');

--
-- Table structure for table `region`
--

CREATE TABLE `region` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `region` varchar(254) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `region`
--

INSERT INTO `region` VALUES (1,'R-1'),(2,'R-2'),(3,'R-3'),(4,'R-4'),(5,'R-5'),(6,'R-6');

--
-- Table structure for table `reporting`
--

CREATE TABLE `reporting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `report_name` varchar(245) DEFAULT NULL,
  `university_id` int(11) DEFAULT NULL,
  `rep_semester` varchar(60) DEFAULT NULL,
  `rep_created_by` int(11) DEFAULT NULL,
  `rep_created_on` datetime DEFAULT NULL,
  `rep_updated_by` int(11) DEFAULT NULL,
  `rep_updated_on` datetime DEFAULT NULL,
  `DELETE_IND` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `reporting`
--

INSERT INTO `reporting` VALUES (1,'Programatic Report 1',13,'Summer 2019',1,'2018-04-03 09:46:53',1,'2018-04-05 02:00:19',NULL),(2,'Programatic Report 2',13,'Spring 2019',1,'2018-04-03 09:47:10',1,'2018-04-04 10:49:22',NULL),(3,'Programatic Report 1',18,'Spring 2019',1,'2018-04-03 11:54:17',1,'2018-04-09 07:42:20',NULL),(4,'Programatic Report 1',11,'Fall 2017',11,'2018-04-03 12:17:02',23,'2018-04-06 09:21:19',NULL),(5,'Programatic Report 1',19,'Summer 2019',11,'2018-04-03 12:39:53',28,'2018-04-18 09:07:25',NULL),(6,'Programatic Report 2',18,'Spring 2019',1,'2018-04-03 01:22:11',1,'2018-04-04 12:06:06',NULL),(7,'Programatic Report 3',18,'Summer 2019',1,'2018-04-03 01:23:50',11,'2018-04-04 12:01:33',NULL),(8,'Programatic Report 2',11,'Spring 2020',11,'2018-04-03 01:47:00',1,'2018-04-04 12:05:07',NULL),(9,'Programatic Report 4',18,'Fall 2018',11,'2018-04-03 01:54:56',1,'2018-05-11 09:42:33',NULL),(10,'Programatic Report 3',11,'Fall 2018',11,'2018-04-03 01:56:15',11,'2018-04-03 01:56:15',NULL),(11,'Programatic Report 2',19,'Spring 2020',11,'2018-04-03 01:56:47',1,'2018-04-06 06:14:45',NULL),(12,'Programatic Report 4',11,'Summer 2019',11,'2018-04-03 01:57:25',11,'2018-04-03 01:57:25',NULL),(13,'Programatic Report 1',24,'Spring 2020',1,'2018-04-04 07:20:40',1,'2018-04-04 12:33:39',NULL),(14,'Programatic Report 2',24,'Spring 2020',1,'2018-04-04 07:21:09',1,'2018-04-04 12:32:59',NULL),(15,'Programatic Report 3',24,'Spring 2019',1,'2018-04-04 07:21:26',1,'2018-04-04 01:52:11',NULL),(16,'Programatic Report 1',26,'Fall 2018',1,'2018-04-04 07:21:57',1,'2018-04-04 07:21:57',NULL),(17,'Programatic Report 2',26,'Fall 2020',1,'2018-04-04 07:22:14',23,'2018-04-18 10:57:55',NULL),(18,'Programatic Report 3',19,'Fall 2017',11,'2018-04-04 07:33:11',1,'2018-04-06 09:18:47',NULL),(19,'Programatic Report 1',12,'Spring 2019',1,'2018-04-04 07:34:06',1,'2018-04-04 10:00:22',NULL),(20,'Programatic Report 2',12,'Summer 2019',1,'2018-04-04 07:34:23',1,'2018-04-04 07:34:23',NULL),(21,'Programatic Report 3',12,'Fall 2018',1,'2018-04-04 07:34:35',11,'2018-04-04 11:48:21',NULL),(22,'Programatic Report 5',11,'Fall 2021',23,'2018-04-04 07:47:29',23,'2018-04-04 07:47:29',NULL),(23,'Programatic Report 1',2,'Spring 2020',11,'2018-04-04 09:07:07',1,'2018-04-05 02:19:02',NULL),(27,'Programatic Report 4',19,'Fall 2020',1,'2018-04-04 09:17:55',28,'2018-04-18 09:10:01',NULL),(28,'Programatic Report 1',1,'Spring 2020',1,'2018-04-04 11:42:38',1,'2018-04-04 11:44:28',NULL),(29,'Programatic Report 2',1,'Spring 2019',1,'2018-04-04 11:43:18',1,'2018-04-05 02:08:44',NULL),(30,'Programatic Report 2',2,'Summer 2019',11,'2018-04-04 11:59:48',1,'2018-04-05 02:36:39',NULL),(31,'Programatic Report 4',12,'Spring 2020',1,'2018-04-04 12:35:22',1,'2018-04-04 12:35:22',NULL),(32,'Programatic Report 3',13,'Spring 2020',1,'2018-04-04 04:09:16',1,'2018-04-04 01:12:57',NULL),(33,'Programatic Report 4',13,'Fall 2020',1,'2018-04-04 04:18:20',28,'2018-04-18 09:06:18',NULL),(34,'Programatic Report 6',11,'Spring 2019',1,'2018-04-05 05:59:45',1,'2018-04-04 06:13:37',NULL),(35,'Programatic Report 7',11,'Spring 2019',1,'2018-04-05 05:59:52',1,'2018-04-04 05:59:52',NULL),(36,'Programatic Report 3',1,'Fall 2021',4,'2018-04-05 09:38:24',1,'2018-04-09 07:54:37',NULL),(37,'Programatic Report 1',27,'Spring 2019',6,'2018-04-05 09:51:47',6,'2018-04-04 09:51:47',NULL),(38,'Programatic Report 8',11,'Spring 2020',1,'2018-04-05 11:39:18',1,'2018-04-06 11:22:53',NULL),(39,'Programatic Report 2',27,'Spring 2020',1,'2018-04-05 01:27:50',1,'2018-04-04 01:36:06',NULL),(40,'Programatic Report 3',27,'Fall 2021',1,'2018-04-05 01:35:35',1,'2018-04-04 01:35:35',NULL),(41,'Programatic Report 4',24,'Summer 2019',1,'2018-04-05 01:49:22',1,'2018-04-11 09:06:15',NULL),(42,'Programatic Report 5',24,'Spring 2019',1,'2018-04-06 06:11:28',1,'2018-04-06 07:03:32',NULL),(43,'Programatic Report 6',24,'Spring 2020',1,'2018-04-06 07:04:20',1,'2018-04-06 07:04:20',NULL),(44,'Programatic Report 1',25,'Spring 2020',1,'2018-04-06 07:21:27',1,'2018-04-06 07:21:27',NULL),(45,'Programatic Report 2',25,'Fall 2018',1,'2018-04-06 07:25:41',1,'2018-05-12 09:12:02',NULL),(46,'Programatic Report 1',32,'Fall 2017',1,'2018-04-06 09:15:06',1,'2018-04-06 12:43:34',NULL),(47,'Programatic Report 2',32,'Spring 2019',1,'2018-04-06 12:11:13',1,'2018-04-06 12:11:13',NULL),(48,'Programatic Report 3',32,'Fall 2021',1,'2018-04-06 12:11:16',1,'2018-04-06 12:12:01',NULL),(49,'Programatic Report 4',32,'Summer 2019',1,'2018-04-06 12:13:21',1,'2018-04-06 12:13:21',NULL),(50,'Programatic Report 5',32,'Spring 2019',1,'2018-04-07 12:20:00',29,'2018-04-09 06:56:41',NULL),(51,'Programatic Report 1',34,'Fall 2018',29,'2018-04-09 06:42:29',29,'2018-04-09 06:42:29',NULL),(52,'Programatic Report 2',34,'Spring 2020',29,'2018-04-09 06:45:21',29,'2018-04-09 06:45:21',NULL),(53,'Programatic Report 5',18,'Spring 2018',1,'2018-04-09 07:42:36',1,'2018-04-09 07:42:36',NULL),(54,'Programatic Report 3',2,'Fall 2018',1,'2018-04-09 07:53:41',1,'2018-04-09 07:53:41',NULL),(55,'Programatic Report 4',2,'Summer 2019',1,'2018-04-10 05:49:13',1,'2018-04-10 06:10:40',NULL),(56,'Programatic Report 4',1,'Fall 2020',1,'2018-04-10 06:36:56',1,'2018-04-10 06:36:56',NULL),(57,'Programatic Report 3',34,'Spring 2018',1,'2018-04-10 07:02:14',1,'2018-04-10 07:02:14',NULL),(58,'Programatic Report 5',2,'Fall 2021',1,'2018-04-10 07:21:40',1,'2018-04-10 07:21:40',NULL),(59,'Programatic Report 6',32,'Fall 2018',21,'2018-04-10 07:40:09',1,'2018-04-10 10:38:46',NULL),(60,'Programatic Report ',NULL,NULL,1,'2018-04-10 01:46:27',1,'2018-04-10 01:46:27',NULL),(61,'Programatic Report 5',1,'Spring 2020',21,'2018-04-11 12:40:45',21,'2018-04-11 12:40:45',NULL),(62,'Programatic Report 3',25,'Spring 2018',1,'2018-04-11 01:23:36',1,'2018-04-11 01:28:30',NULL),(63,'Programatic Report 6',2,'Fall 2021',1,'2018-04-12 06:53:53',1,'2018-04-12 06:53:53',NULL),(64,'Programatic Report 3',26,'Spring 2018',1,'2018-04-12 07:24:41',1,'2018-04-12 07:24:41',NULL),(65,'Programatic Report 5',12,'Spring 2020',1,'2018-04-12 08:44:25',1,'2018-04-12 12:10:04',NULL),(66,'Programatic Report 6',1,'Spring 2020',21,'2018-04-12 10:10:14',21,'2018-04-12 10:11:04',NULL),(67,'Programatic Report 4',26,'Summer 2019',1,'2018-04-12 10:34:38',1,'2018-04-12 10:35:55',NULL),(68,'Programatic Report 7',1,'Fall 2017',21,'2018-04-14 12:27:10',21,'2018-04-14 12:27:10',NULL),(69,'Programatic Report 4',27,'Fall 2018',1,'2018-04-23 04:33:11',1,'2018-04-23 04:48:14',NULL),(70,'Programatic Report 4',25,'Fall 2020',1,'2018-05-12 06:40:43',1,'2018-05-12 06:41:00',NULL),(71,'Programatic Report 5',27,'Summer 2019',1,'2018-05-23 07:37:32',1,'2018-05-23 07:38:48',NULL),(72,'Programatic Report 5',26,'Summer 2019',1,'2018-05-31 01:20:10',1,'2018-05-31 01:20:10',NULL),(73,'Programatic Report 6',18,'Fall 2018',1,'2018-06-01 04:33:34',1,'2018-06-01 04:33:34',NULL),(74,'Programatic Report 6',18,'Fall 2018',1,'2018-06-01 04:34:09',1,'2018-06-01 04:34:09',NULL),(75,'Programatic Report 6',18,'Fall 2018',1,'2018-06-01 04:34:12',1,'2018-06-01 04:34:12',NULL),(76,'Programatic Report 6',18,'Fall 2018',1,'2018-06-01 04:34:15',1,'2018-06-01 04:34:15',NULL),(77,'Programatic Report 10',18,NULL,1,'2018-06-12 06:38:07',1,'2018-06-12 06:38:07',NULL),(78,'Programatic Report 7',24,'Spring 2019',1,'2018-06-13 10:01:32',1,'2018-06-13 10:01:32',NULL);

--
-- Table structure for table `reporting_comments`
--

CREATE TABLE `reporting_comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `user_name` varchar(245) DEFAULT NULL,
  `university_id` int(11) DEFAULT NULL,
  `reporting_id` int(11) DEFAULT NULL,
  `node_id` int(11) DEFAULT NULL,
  `node_name` varchar(245) DEFAULT NULL,
  `comments` text,
  `view_status` enum('Y','N') DEFAULT NULL,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_date` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `reporting_comments`
--

INSERT INTO `reporting_comments` VALUES (1,1,'Admin',13,1,1,'Programatic Report 1','Testing from admin',NULL,'2018-04-18 03:43:07',NULL),(2,1,'Admin',25,45,45,'Programatic Report 2','Test commend from oxford (admin)',NULL,'2018-04-18 03:44:35',NULL),(3,1,'Admin',19,27,27,'Programatic Report 2','Tester from testing (admin)',NULL,'2018-04-18 03:45:24',NULL),(4,1,'Admin',19,5,5,'Programatic Report 3','Tester from Testing again (admin)',NULL,'2018-04-18 03:49:53',NULL),(5,1,'Admin',25,44,44,'Programatic Report 3','Testing for sort list',NULL,'2018-04-18 05:08:16',NULL),(6,1,'Admin',13,32,32,'Programatic Report 4','Tester test',NULL,'2018-04-18 05:09:13',NULL),(7,1,'Admin',25,45,45,'Programatic Report 2','Tester',NULL,'2018-04-18 06:14:06',NULL),(8,23,'Thilaga',25,62,62,'Programatic Report 1','Tester',NULL,'2018-04-18 06:55:54',NULL),(9,1,'Admin',11,12,12,'Programatic Report 7','Testing from admin',NULL,'2018-04-18 08:15:47',NULL),(10,1,'Admin',11,34,34,'Programatic Report 5','Testing process',NULL,'2018-04-18 08:28:50',NULL),(11,1,'Admin',11,10,10,'Programatic Report 8','Testing',NULL,'2018-04-18 08:29:41',NULL),(12,23,'Thilaga',11,8,8,'Programatic Report 3','Testing from user',NULL,'2018-04-18 08:39:52',NULL),(13,1,'Admin',32,49,49,'Programatic Report 4','Test',NULL,'2018-04-18 08:47:26',NULL),(14,37,'User',24,13,13,'Programatic Report 4','Tester',NULL,'2018-04-19 05:18:12',NULL),(15,23,'Thilaga',19,11,11,'Programatic Report 4','Testing',NULL,'2018-04-20 01:39:09',NULL),(16,1,'Admin',26,17,17,'Programatic Report 1','Testing',NULL,'2018-04-20 01:52:47',NULL),(17,1,'Admin',25,44,44,'Programatic Report 3','Testing from tester',NULL,'2018-04-20 01:58:05',NULL),(18,23,'Thilaga',25,62,62,'Programatic Report 1','Tested successfully',NULL,'2018-04-20 02:02:20',NULL),(19,1,'Admin',18,3,3,'Programatic Report 2','Hiii',NULL,'2018-04-20 02:14:33',NULL),(20,39,'New',27,40,40,'Programatic Report 3','Test comment from newuser',NULL,'2018-04-20 06:11:22',NULL),(21,11,'Testing',18,7,7,'Programatic Report 4','Tester comments',NULL,'2018-04-20 06:15:40',NULL),(22,1,'Admin',12,20,20,'Programatic Report 5','Hiii',NULL,'2018-04-20 06:18:30',NULL),(23,39,'New',27,37,37,'Programatic Report 1','Hiii',NULL,'2018-04-20 06:21:50',NULL),(24,1,'Admin',13,1,1,'Programatic Report 2','Test process',NULL,'2018-04-20 06:41:27',NULL),(25,1,'Admin',13,33,33,'Programatic Report 1','Test message',NULL,'2018-04-20 09:02:16',NULL),(26,1,'Admin',27,69,69,'Programatic Report 1','Greeting from admin',NULL,'2018-04-23 03:00:33',NULL),(27,1,'Admin',27,37,37,'Programatic Report 2','Hiii',NULL,'2018-04-23 03:14:52',NULL),(28,1,'Admin',27,39,39,'Programatic Report 3','Hellooo',NULL,'2018-04-23 03:15:14',NULL),(29,1,'Admin',27,71,71,'Programatic Report 1','Writing some quotes',NULL,'2018-05-23 03:53:53',NULL);

--
-- Table structure for table `reporting_comments_status`
--

CREATE TABLE `reporting_comments_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `university_id` int(11) DEFAULT NULL,
  `reporting_id` int(11) DEFAULT NULL,
  `node_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `comment_count` int(11) DEFAULT NULL,
  `status` enum('Y','N') DEFAULT NULL,
  `updated_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `reporting_comments_status`
--

INSERT INTO `reporting_comments_status` VALUES (1,13,1,NULL,1,2,NULL,'2018-04-20 10:41:30'),(2,25,45,NULL,1,2,NULL,'2018-04-18 10:14:12'),(3,19,27,NULL,1,1,NULL,'2018-04-18 07:45:27'),(4,19,5,NULL,1,1,NULL,'2018-04-18 07:49:56'),(5,13,1,NULL,28,1,NULL,'2018-04-18 04:51:26'),(6,19,5,NULL,28,1,NULL,'2018-04-18 04:51:32'),(7,19,27,NULL,28,1,NULL,'2018-04-18 04:51:37'),(8,25,45,NULL,28,1,NULL,'2018-04-18 04:51:56'),(9,25,44,NULL,1,2,NULL,'2018-04-20 05:58:09'),(10,13,32,NULL,1,1,NULL,'2018-04-18 09:09:18'),(11,13,32,NULL,28,1,NULL,'2018-04-18 05:38:20'),(12,25,44,NULL,28,1,NULL,'2018-04-18 05:40:19'),(13,25,62,NULL,23,2,NULL,'2018-04-20 06:02:22'),(14,25,62,NULL,1,2,NULL,'2018-06-06 06:44:23'),(15,11,12,NULL,1,1,NULL,'2018-04-18 12:15:50'),(16,13,1,NULL,25,2,NULL,'2018-04-23 11:37:37'),(17,13,32,NULL,25,1,NULL,'2018-04-18 08:26:18'),(18,13,33,NULL,1,1,NULL,'2018-04-20 13:02:21'),(19,11,12,NULL,21,1,NULL,'2018-04-18 08:27:35'),(20,11,34,NULL,1,1,NULL,'2018-04-18 12:28:52'),(21,11,10,NULL,1,1,NULL,'2018-04-18 12:29:44'),(22,11,8,NULL,23,1,NULL,'2018-04-18 12:39:56'),(23,11,8,NULL,21,1,NULL,'2018-04-18 08:46:42'),(24,32,49,NULL,1,1,NULL,'2018-04-18 12:47:30'),(25,11,8,NULL,1,1,NULL,'2018-04-18 14:16:31'),(26,11,34,NULL,21,1,NULL,'2018-04-18 14:19:10'),(27,32,49,NULL,21,1,NULL,'2018-04-18 14:19:17'),(28,11,10,NULL,21,1,NULL,'2018-04-18 14:19:21'),(29,24,13,NULL,37,1,NULL,'2018-04-19 09:18:17'),(30,19,27,NULL,11,1,NULL,'2018-04-20 01:23:19'),(31,19,5,NULL,11,1,NULL,'2018-04-20 01:23:23'),(32,25,62,NULL,11,1,NULL,'2018-04-20 01:23:27'),(33,25,45,NULL,11,2,NULL,'2018-04-20 01:23:30'),(34,25,44,NULL,11,1,NULL,'2018-04-20 01:23:34'),(35,11,8,NULL,11,1,NULL,'2018-04-20 01:23:48'),(36,11,34,NULL,11,1,NULL,'2018-04-20 01:23:53'),(37,11,12,NULL,11,1,NULL,'2018-04-20 01:23:59'),(38,11,10,NULL,11,1,NULL,'2018-04-20 01:24:02'),(39,11,34,NULL,23,1,NULL,'2018-04-20 01:25:12'),(40,11,12,NULL,23,1,NULL,'2018-04-20 01:25:18'),(41,11,10,NULL,23,1,NULL,'2018-04-20 01:25:23'),(42,19,27,NULL,23,1,NULL,'2018-04-20 01:25:27'),(43,19,5,NULL,23,1,NULL,'2018-04-20 01:25:31'),(44,25,45,NULL,23,2,NULL,'2018-04-20 01:25:35'),(45,25,44,NULL,23,1,NULL,'2018-04-20 01:25:38'),(46,24,13,NULL,1,1,NULL,'2018-04-20 01:30:41'),(47,19,11,NULL,23,1,NULL,'2018-04-20 05:39:13'),(48,26,17,NULL,1,1,NULL,'2018-04-20 05:52:51'),(49,18,3,NULL,1,1,NULL,'2018-04-20 06:14:35'),(50,19,11,NULL,1,1,NULL,'2018-04-20 02:21:39'),(51,27,40,NULL,39,1,NULL,'2018-04-20 10:11:26'),(52,18,7,NULL,11,1,NULL,'2018-04-20 10:15:44'),(53,12,20,NULL,1,1,NULL,'2018-04-20 10:18:30'),(54,27,37,NULL,39,1,NULL,'2018-04-20 10:21:54'),(55,27,39,NULL,1,1,NULL,'2018-04-23 07:15:18'),(56,27,69,NULL,1,1,NULL,'2018-04-23 07:00:36'),(57,27,37,NULL,1,2,NULL,'2018-04-23 07:14:56'),(58,13,33,NULL,25,1,NULL,'2018-04-23 07:37:33'),(59,27,71,NULL,1,1,NULL,'2018-05-23 07:53:58'),(60,26,17,NULL,44,1,NULL,'2018-06-06 01:40:19'),(61,13,1,NULL,44,2,NULL,'2018-06-06 06:36:39'),(62,13,33,NULL,44,1,NULL,'2018-06-06 06:36:46'),(63,13,32,NULL,44,1,NULL,'2018-06-06 06:38:52'),(64,18,7,NULL,1,1,NULL,'2018-06-13 01:54:10'),(65,27,40,NULL,1,1,NULL,'2018-06-13 02:12:16');

--
-- Table structure for table `university_old`
--

CREATE TABLE `university_old` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `fullname` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `univ_degree_prog` longtext COLLATE utf8mb4_unicode_ci,
  `univ_semesters` longtext COLLATE utf8mb4_unicode_ci,
  `univ_approced_budget` decimal(18,3) DEFAULT NULL,
  `univ_principle_name` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `univ_principle_phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `univ_principle_email` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `univ_admin_name` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `univ_admin_phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `univ_admin_email` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `univ_mail_addr_street` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `univ_mail_addr_apt` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `univ_mail_addr_city` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `univ_mail_addr_state` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `univ_mail_addr_zip` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `univ_perform_addr_street` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `univ_perform_addr_apt` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `univ_perform_addr_city` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `univ_perform_addr_state` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `univ_perform_addr_zip` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `univ_duns_num` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `univ_ein_num` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `univ_congress_dist` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `region` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modify_by` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `university_old`
--

INSERT INTO `university_old` VALUES (38,'Albany State University','a:2:{i:0;s:3:\"BSW\";i:1;s:3:\"MSW\";}','',0.000,'t','4','t','t','4','t','t',NULL,'t','t','4','t',NULL,'t','t','4','030052815','15860001199681','ga-012','2','admin','2018-06-14 01:27:58',NULL),(39,'Augusta University','a:2:{i:0;s:3:\"BSW\";i:1;s:3:\"MSW\";}','',2.000,'d','e','d','d','d','e','d',NULL,'d','d','3','d',NULL,'c','c','4','09593387','581418202','ga-012','5','admin','2018-06-14 01:31:32',NULL),(40,'Fort Valley State University','a:2:{i:0;s:3:\"BSW\";i:1;s:3:\"MSW\";}','',6.000,'hh','77','mm','m','88','j','j',NULL,'j','j','88','u',NULL,'h','g','89909','073425951','5860020621','ga-011','2','admin','2018-06-14 01:35:33',NULL),(41,'Georgia State University','a:2:{i:0;s:3:\"BSW\";i:1;s:3:\"MSW\";}','',4.000,'g','55','bb','bb','55','bbt','55g',NULL,'g','g','444','g',NULL,'g','g','44','7342951','586002050','ga-05','4','admin','2018-06-14 01:37:11',NULL),(42,'Kennesaw State University','a:2:{i:0;s:3:\"BSW\";i:1;s:3:\"MSW\";}','',3.000,'d','d','f','f','f','f','f',NULL,'f','f','f','f',NULL,'f','f','3','6277758923','371535589','ga-011','3','admin','2018-06-14 01:39:40',NULL),(43,'Savannah State University','a:2:{i:0;s:3:\"BSW\";i:1;s:3:\"MSW\";}','',444.000,'f','f','f','f','f','f','f',NULL,'f','f','33','f',NULL,'f','f','f','8799315','586002069','ga-001','5','admin','2018-06-14 01:42:59',NULL),(44,'University of Georgia','a:2:{i:0;s:3:\"BSW\";i:1;s:3:\"MSW\";}','',4.000,'4','4','4','4','4','4','4',NULL,'4','94','4','4',NULL,'4','4','4','619003127','586001998','ga-0001','3','admin','2018-06-14 01:45:50',NULL),(45,'Valdosta State University','a:2:{i:0;s:3:\"BSW\";i:1;s:3:\"MSW\";}','',4.000,'4','4','4','f','f','f','r',NULL,'r','r','4','f',NULL,'f','f','4','929476745','586002072','ga-0001','4','admin','2018-06-14 01:49:31',NULL),(46,'Testing','a:2:{i:0;s:3:\"BSW\";i:1;s:3:\"MSW\";}','',0.000,'M','5','Mbouligny@progrop.us','M','4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1','admin','2018-06-14 03:47:55',NULL);


