-- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64) -- -- Host: localhost Database: jjlourens2 -- ------------------------------------------------------ -- Server version 5.5.68-MariaDB /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!50503 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `job_solar_survey` -- DROP TABLE IF EXISTS `job_solar_survey`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `job_solar_survey` ( `id` int(11) NOT NULL AUTO_INCREMENT, `salesrep` int(11) DEFAULT NULL, `datecap` date DEFAULT NULL, `fk_job` int(11) NOT NULL, `storeys` varchar(3) DEFAULT NULL, `roofQuality` varchar(20) DEFAULT NULL, `roofMaterials` varchar(50) DEFAULT NULL, `flatroof` varchar(3) DEFAULT NULL, `solarDirection` varchar(30) DEFAULT NULL, `obstructions` varchar(3) DEFAULT NULL, `mixerHouse` varchar(3) DEFAULT NULL, `hotWater` varchar(3) DEFAULT NULL, `problemJob` varchar(3) DEFAULT NULL, `clid` varchar(3) DEFAULT 'No', `clutility` varchar(3) DEFAULT 'No', `signquote` varchar(3) DEFAULT 'No', `proofpay` varchar(3) DEFAULT 'No', `jobgo` varchar(3) DEFAULT 'No', `meternum` varchar(255) DEFAULT '', `barcode` varchar(100) DEFAULT NULL, `coc` varchar(3) DEFAULT 'No', `creditnumber` varchar(255) DEFAULT NULL, `photos` varchar(3) DEFAULT 'No', `quotedo` int(1) DEFAULT NULL, `gps` varchar(3) DEFAULT NULL, `signfinal` varchar(3) DEFAULT 'No', `eskomdocs` varchar(3) DEFAULT NULL, `eskomrebate` varchar(3) DEFAULT NULL, `userCap` int(11) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `fkf11` (`fk_job`) USING BTREE, CONSTRAINT `fkf11` FOREIGN KEY (`fk_job`) REFERENCES `job` (`pk_job`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `job_solar_survey` -- LOCK TABLES `job_solar_survey` WRITE; /*!40000 ALTER TABLE `job_solar_survey` DISABLE KEYS */; INSERT INTO `job_solar_survey` VALUES (1,14,'2013-11-06',45230,'No','Good','Tile','Yes','North','Yes','No','Yes','Yes','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,14),(2,14,'2013-11-07',66454,'Yes','Good','Slate','No','West','Yes','Yes','No','No','Yes','Yes','Yes','Yes','Yes','','','No','','No',1,'','No','No',NULL,14),(3,39,'2013-11-07',66470,'No','Good','Tile','No','North','No','No','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,39),(4,39,'2013-11-07',66468,'No','Good','Tile','No','North','No','No','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,39),(6,39,'2013-11-07',66498,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,39),(8,39,'2013-11-08',66450,'No','Good','Slate','No','North','No','Yes','No','No','Yes','Yes','Yes','Yes','Yes','07110330060','0370404','Yes','0.00','Yes',1,'','Yes','Yes','Yes',39),(9,39,'2013-11-08',66514,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,39),(11,39,'2013-11-11',66587,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,39),(12,39,'2013-11-11',66523,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,39),(13,39,'2013-11-11',66558,'No','Good','Tile','Yes','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,39),(14,39,'2013-11-12',66626,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,39),(15,39,'2013-11-12',66631,'No','Good','IBR','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,39),(16,39,'2013-11-12',66639,'Yes','Good','IBR','Yes','North','No','Yes','No','Yes','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,39),(18,39,'2013-11-13',66642,'No','Good','Tile','No','North','No','Yes','No','No','Yes','Yes','Yes','Yes','Yes','1880289','0370406','Yes','0.00','Yes',1,'','Yes','Yes','Yes',39),(19,39,'2013-11-13',66669,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,39),(20,39,'2013-11-13',66671,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,39),(21,39,'2013-11-13',66672,'No','Good','Slate','Yes','North','No','Yes','No','Yes','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,39),(22,39,'2013-11-13',32487,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,39),(23,39,'2013-11-13',66681,'No','Good','Tile','No','North','No','Yes','No','No','Yes','Yes','Yes','Yes','Yes','','0370408 & 0370409','Yes','0.00','Yes',1,'','Yes','Yes','Yes',39),(25,39,'2013-11-14',66700,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,39),(26,39,'2013-11-14',66718,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','Yes','','0370415','Yes',NULL,'Yes',1,'','Yes','Yes','Yes',39),(27,39,'2013-11-15',66683,'No','Good','Tile','No','North','No','Yes','No','No','Yes','Yes','Yes','Yes','Yes','06695039708','0370407','No','0.00','No',1,'','No','No',NULL,39),(28,39,'2013-11-15',66753,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,39),(29,39,'2013-11-18',66827,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,39),(30,39,'2013-11-18',66876,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,39),(31,39,'2013-11-20',44476,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,39),(32,39,'2013-11-20',66944,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,39),(34,39,'2013-11-22',66996,'No','Good','Tile','No','North','No','Yes','No','No','Yes','Yes','Yes','Yes','Yes','06695039708','0370407','Yes','0.00','Yes',1,'','Yes','Yes','Yes',39),(35,39,'2013-11-22',67034,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,39),(36,39,'2013-11-28',63034,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,39),(37,39,'2013-11-28',65622,'No','Good','Tile','No','North','No','Yes','No','No','Yes','Yes','Yes','Yes','Yes','','0380599 0380600','Yes','0.00','Yes',1,'','Yes','Yes','Yes',39),(38,39,'2013-11-28',66213,'No','Good','Tile','No','North','No','Yes','No','No','Yes','Yes','Yes','Yes','Yes','','0370405','Yes','0.00','Yes',1,'','Yes','Yes','Yes',39),(39,39,'2013-11-28',65918,'No','Good','Tile','No','North','No','Yes','No','No','Yes','Yes','Yes','Yes','Yes','','0370403','Yes','0.00','Yes',1,'','Yes','Yes','Yes',39),(40,39,'2013-12-02',67283,'No','Good','Tile','No','North','No','Yes','Yes','Yes','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,39),(41,39,'2013-12-02',66962,'No','Good','Tile','No','North','No','Yes','No','No','Yes','Yes','Yes','Yes','Yes','','0370406','Yes','0.00','Yes',1,'','Yes','Yes','Yes',39),(42,39,'2013-12-03',67289,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','Yes','','0370410','Yes',NULL,'Yes',1,'','Yes','Yes','Yes',39),(43,39,'2013-12-03',67360,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,39),(44,39,'2013-12-04',67387,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,39),(45,39,'2013-12-05',57665,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,39),(46,32,'2013-12-09',67000,'No','Good','Tile','No','North','No','No','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,32),(47,32,'2013-12-09',67534,'No','Good','Tile','No','North','No','No','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,32),(48,39,'2014-01-06',37925,'No','Fair','Tile','No','North','No','No','No','Yes','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,39),(49,39,'2014-01-06',36474,'No','Good','Tile','No','North','No','No','Yes','Yes','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,39),(50,39,'2014-01-06',38406,'No','Good','Tile','No','North','No','No','Yes','Yes','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,39),(51,39,'2014-01-06',50878,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,39),(52,6,'2014-01-07',68279,'No','Good','Tile','No','North','No','Yes','No','Yes','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,6),(53,41,'2014-01-24',67823,'Yes','Good','Zink','No','North','No','Yes','No','Yes','Yes','Yes','Yes','Yes','Yes','04909375737 SGC:610','0370412','Yes','N/A','Yes',1,'','Yes','Yes','Yes',41),(54,16,'2014-01-24',67659,'No','Good','Tile','No','North','No','No','Yes','Yes','Yes','Yes','Yes','Yes','Yes','01310679152','0370411','Yes','','Yes',1,'','Yes','Yes','Yes',16),(55,6,'2014-01-29',68602,'No','Fair','Tile','No','North','No','No','Yes','Yes','Yes','Yes','Yes','Yes','Yes','64086','0370413','Yes','','Yes',1,'','Yes','Yes','Yes',6),(56,6,'2014-01-29',68613,'No','Good','Tile','No','North','No','No','Yes','Yes','Yes','Yes','Yes','Yes','Yes','07032988243','0370414','Yes','','Yes',1,'','Yes','Yes','Yes',6),(57,6,'2014-01-29',68725,'No','Good','Tile','No','North','No','No','Yes','Yes','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,6),(58,6,'2014-02-04',68953,'No','Fair','Tile','No','South','Yes','Yes','No','','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,6),(59,6,'2014-02-05',69128,'No','Good','Tile','No','West','No','Yes','No','Yes','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,6),(60,14,'2014-02-06',68991,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,14),(61,6,'2014-02-07',69222,'No','Good','Tile','No','North','No','Yes','No','Yes','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,6),(62,6,'2014-02-10',69282,'No','Fair','Tile','Yes','North','No','Yes','No','Yes','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,6),(63,6,'2014-02-12',69362,'Yes','Fair','Tile','No','North','No','Yes','No','Yes','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,6),(64,41,'2014-02-12',68984,'No','Fair','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,41),(65,6,'2014-02-14',69095,'No','Good','IBR','Yes','East','No','Yes','No','Yes','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,6),(66,14,'2014-02-24',69585,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,14),(67,14,'2014-02-24',68755,'No','Good','Slate','Yes','North','Yes','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,14),(68,16,'2014-02-27',69895,'No','Fair','Asbestos','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,16),(69,41,'2014-02-28',69926,'No','Fair','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,41),(70,41,'2014-03-03',70004,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,41),(71,41,'2014-03-03',69807,'No','Fair','Tile','No','North','No','No','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,41),(72,41,'2014-03-03',70012,'No','Fair','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,41),(73,41,'2014-03-03',70019,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,41),(74,41,'2014-03-04',70084,'No','Fair','Zink','Yes','North','Yes','No','No','Yes','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,41),(75,41,'2014-03-04',69879,'No','Good','Tile','No','North','No','Yes','Yes','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,41),(76,41,'2014-03-05',70103,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No','','No',1,NULL,'No',NULL,NULL,41),(77,41,'2014-03-05',70099,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,41),(78,41,'2014-03-06',70139,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,41),(79,41,'2014-03-10',70162,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,41),(80,41,'2014-03-12',70314,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,41),(81,41,'2014-03-13',70309,'No','Good','Tile','No','North','No','No','No','No','No','No','No','No','No','',NULL,'No','','No',1,NULL,'No',NULL,NULL,41),(82,41,'2014-03-17',70422,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,41),(83,41,'2014-03-17',70354,'No','Good','IBR','Yes','North','Yes','Yes','No','Yes','Yes','Yes','Yes','Yes','No','000000000',NULL,'No','0000000000','No',1,NULL,'No',NULL,NULL,41),(84,41,'2014-03-18',70459,'No','Good','Tile','No','North','No','Yes','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,41),(85,41,'2014-03-18',70040,'Yes','Good','Slate','No','North','No','Yes','No','Yes','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,41),(86,44,'2014-10-21',77242,'No','Fair','Tile','No','West','No','Yes','No','No','No','No','No','No','No','',NULL,'No','','No',1,NULL,'No',NULL,NULL,44),(87,30,'2016-01-13',91299,'Yes','Good','IBR','Yes','North','Yes','Yes','Yes','Yes','No','No','No','No','No','','','No','','No',1,'','No','No','No',30),(88,45,'2018-12-04',118416,'Yes','Good','Unknown','Yes','North','No','No','No','No','No','No','No','No','No','',NULL,'No',NULL,'No',1,NULL,'No',NULL,NULL,45); /*!40000 ALTER TABLE `job_solar_survey` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2023-10-09 19:23:20