-- 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 `werd`
--

DROP TABLE IF EXISTS `werd`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `werd` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `UserAdd` int(255) DEFAULT NULL,
  `UserEdit` int(255) DEFAULT NULL,
  `DateAdded` date DEFAULT NULL,
  `DateEdited` date DEFAULT NULL,
  `fk_job` int(255) NOT NULL,
  `fk_plumber` int(255) NOT NULL,
  `rndm5` varchar(30) NOT NULL,
  `Serial` varchar(30) NOT NULL,
  `Is0254` varchar(3) NOT NULL,
  `Is0254Reason` varchar(3) DEFAULT NULL,
  `GeyserPosition` varchar(30) NOT NULL,
  `GeyserLocation` varchar(30) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `randomchk` (`rndm5`) USING BTREE,
  KEY `plumber` (`fk_plumber`) USING BTREE,
  KEY `fkjob1` (`fk_job`) USING BTREE,
  CONSTRAINT `fkjob1` FOREIGN KEY (`fk_job`) REFERENCES `job` (`pk_job`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `plumber` FOREIGN KEY (`fk_plumber`) REFERENCES `setup_plumber` (`pk_plumber`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=265 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `werd`
--

LOCK TABLES `werd` WRITE;
/*!40000 ALTER TABLE `werd` DISABLE KEYS */;
INSERT INTO `werd` VALUES (1,27,0,'2016-08-07',NULL,96922,60,'0f6u20160807215048','13456','No','asd','Horisontal','Bathroom - Ensuite'),(2,27,NULL,'2016-08-10',NULL,98413,79,'0xax20160810150720','517116','Yes',NULL,'Horisontal','Passage'),(3,27,NULL,'2016-08-11',NULL,98408,79,'0gq320160811131611','517116','Yes',NULL,'Horisontal','Passage'),(4,27,NULL,'2016-08-12',NULL,98529,3,'0swp20160812150333','None ','Yes',NULL,'Horisontal','Bathroom - Ensuite'),(5,27,NULL,'2016-08-15',NULL,98638,79,'0j1t20160815115707','00000','Yes',NULL,'Horisontal','Passage'),(6,27,NULL,'2016-08-15',NULL,98640,79,'0qrp20160815144027','5/8/16','Yes',NULL,'Horisontal','Passage'),(7,27,NULL,'2016-08-26',NULL,98877,3,'0vxm20160826175548','None ','Yes',NULL,'Horisontal','Passage'),(8,27,NULL,'2016-08-29',NULL,98909,3,'0mqz20160829123535','None ','Yes',NULL,'Vertical','Bedroom - Main'),(9,27,NULL,'2016-09-05',NULL,99243,79,'0a9u20160905114216','00000 ','Yes',NULL,'Horisontal','Passage'),(10,27,NULL,'2016-09-07',NULL,99332,3,'0kh320160907113533','None ','Yes',NULL,'Horisontal','Passage'),(11,27,NULL,'2016-09-07',NULL,99337,3,'04xw20160907142548','None ','Yes',NULL,'Horisontal','Passage'),(12,27,NULL,'2016-09-08',NULL,99343,3,'0b6420160908110326','None ','Yes',NULL,'Horisontal','Passage'),(13,27,NULL,'2016-09-19',NULL,99679,124,'0jo20160919112109','WD001','Yes',NULL,'Horisontal','Bathroom - Main'),(14,27,NULL,'2016-09-19',NULL,99680,124,'0do920160919131727','do not see serial number','Yes',NULL,'Horisontal','Diningroom'),(15,27,NULL,'2016-09-20',NULL,99688,124,'0sk20160920061423','no serial','Yes',NULL,'Horisontal','Passage'),(16,27,NULL,'2016-09-20',NULL,99689,124,'0gao20160920062034','no serial no','Yes',NULL,'Horisontal','Passage'),(17,27,NULL,'2016-09-20',NULL,99578,124,'0pjg20160920131301','none','Yes',NULL,'Horisontal','Passage'),(18,27,NULL,'2016-09-21',NULL,99700,124,'0tr20160921072651','none','Yes',NULL,'Vertical','Passage'),(19,27,NULL,'2016-09-21',NULL,99777,117,'06vd20160921192656','WD001','Yes',NULL,'Horisontal','Bedroom - Main'),(20,27,NULL,'2016-09-22',NULL,99711,124,'0j6120160922064326','none','Yes',NULL,'Horisontal','Bedroom - Second'),(21,27,NULL,'2016-09-22',NULL,99713,124,'0mtr20160922064625','none','Yes',NULL,'Horisontal','Bathroom - Ensuite'),(22,27,NULL,'2016-09-22',NULL,99707,124,'04a920160922134110','none','Yes',NULL,'Horisontal','Bathroom - Guest toilet'),(23,27,NULL,'2016-09-23',NULL,99839,124,'0enj20160923055133','no serial','Yes',NULL,'Horisontal','Passage'),(24,27,NULL,'2016-09-23',NULL,99791,124,'0jch20160923065206','no serial','Yes',NULL,'Horisontal','Bathroom - Guest toilet'),(25,27,NULL,'2016-09-23',NULL,99716,124,'0q3620160923083300','none','Yes',NULL,'Horisontal','Passage'),(26,27,NULL,'2016-09-23',NULL,99765,124,'0xp20160923112020','none','Yes',NULL,'Vertical','Bathroom - Guest toilet'),(27,27,NULL,'2016-09-26',NULL,99702,124,'0aoy20160926053222','none','Yes',NULL,'Horisontal','Passage'),(28,27,NULL,'2016-09-26',NULL,99728,124,'0y4t20160926053438','none','Yes',NULL,'Horisontal','Passage'),(29,27,NULL,'2016-09-26',NULL,99689,114,'0zoh20160926102425','000','Yes',NULL,'Horisontal','Passage'),(30,27,NULL,'2016-09-26',NULL,99708,124,'0v6w20160926132657','none','Yes',NULL,'Horisontal','Lounge'),(31,27,NULL,'2016-09-26',NULL,99717,124,'0q7x20160926132914','none','Yes',NULL,'Horisontal','Passage'),(32,27,NULL,'2016-09-27',NULL,99732,124,'05gh20160927053827','none','Yes',NULL,'Horisontal','Lounge'),(33,27,NULL,'2016-09-27',NULL,99743,124,'05f20160927054111','none','Yes',NULL,'Horisontal','Bathroom - Main'),(34,27,NULL,'2016-09-27',NULL,99697,124,'09o20160927142406','none','Yes',NULL,'Vertical','Passage'),(35,27,NULL,'2016-09-27',NULL,99689,114,'0vp20160927211351','000','Yes',NULL,'Horisontal','Passage'),(36,27,NULL,'2016-09-28',NULL,99708,124,'0ep20160928071501','none','Yes',NULL,'Horisontal','Passage'),(37,27,NULL,'2016-09-28',NULL,99792,3,'08m420160928111029','None ','Yes',NULL,'Horisontal','Passage'),(38,27,NULL,'2016-09-30',NULL,99724,3,'02uc20160930114257','None ','Yes',NULL,'Horisontal','Passage'),(39,27,NULL,'2016-10-04',NULL,99334,124,'0cg420161004124242','None ','Yes',NULL,'Horisontal','Bedroom - Second'),(40,27,NULL,'2016-10-04',NULL,99775,125,'0wqw20161004142016','none','Yes',NULL,'Horisontal','Passage'),(41,27,NULL,'2016-10-05',NULL,100181,127,'0rch20161005124851','WD001','Yes',NULL,'Horisontal','Passage'),(42,27,NULL,'2016-10-05',NULL,100134,127,'0hvp20161005154105','WD001 ','Yes',NULL,'Horisontal','Passage'),(43,27,NULL,'2016-10-05',NULL,99775,125,'05px20161005184351','121/ 122/ 123','Yes',NULL,'Horisontal','Bathroom - Main'),(44,27,NULL,'2016-10-07',NULL,100276,125,'0r2520161007121218','none','Yes',NULL,'Horisontal','Bathroom - Main'),(45,27,NULL,'2016-10-10',NULL,99738,124,'09xa20161010055030','none','Yes',NULL,'Vertical','Bedroom - Main'),(46,27,NULL,'2016-10-10',NULL,100208,124,'0zym20161010055430','none','Yes',NULL,'Horisontal','Bathroom - Main'),(47,27,NULL,'2016-10-11',NULL,100294,127,'0vs520161011130252','WD001 ','Yes',NULL,'Horisontal','Passage'),(48,27,NULL,'2016-10-11',NULL,99691,127,'0nr520161011143732','WD001 ','Yes',NULL,'Horisontal','Passage'),(49,27,NULL,'2016-10-11',NULL,100201,124,'085m20161011175335','none','No','sto','Horisontal','Bathroom - Main'),(50,27,NULL,'2016-10-11',NULL,100201,125,'0q7d20161011174239','none','Yes',NULL,'Horisontal','Bedroom - Second'),(51,27,NULL,'2016-10-13',NULL,99740,124,'0vw320161013055859','none ','Yes',NULL,'Horisontal','Passage'),(52,27,NULL,'2016-10-13',NULL,100366,127,'0rdk20161013145416','WD001 ','Yes',NULL,'Horisontal','Study'),(53,27,NULL,'2016-10-14',NULL,99731,125,'0nk20161014112617','none','No','tpv','Horisontal','Kitchen'),(54,27,NULL,'2016-10-17',NULL,99790,124,'0jmq20161017042756','none','Yes',NULL,'Horisontal','Bedroom - Main'),(55,27,NULL,'2016-10-17',NULL,100212,124,'0bah20161017043205','none','Yes',NULL,'Horisontal','Outside'),(56,27,NULL,'2016-10-17',NULL,99788,124,'0esv20161017115757','none','Yes',NULL,'Horisontal','Passage'),(57,27,NULL,'2016-10-19',NULL,99742,124,'04nh20161019155530','none','Yes',NULL,'Horisontal','Bathroom - Ensuite'),(58,27,NULL,'2016-10-19',NULL,100532,124,'0pz920161019155911','none','Yes',NULL,'Vertical','Bedroom - Main'),(59,27,NULL,'2016-10-20',NULL,99713,3,'08fg20161020103106','None ','No','V b','Horisontal','Passage'),(60,27,NULL,'2016-10-20',NULL,100581,3,'0v8j20161020141616','None ','Yes',NULL,'Horisontal','Passage'),(61,27,NULL,'2016-10-20',NULL,99788,124,'03se20161020173731','none','Yes',NULL,'Horisontal','Kitchen'),(62,27,NULL,'2016-10-27',NULL,100750,125,'07gt20161027110351','none','Yes',NULL,'Horisontal','Passage'),(63,27,NULL,'2016-10-27',NULL,100752,125,'06j520161027122634','none','Yes',NULL,'Horisontal','Lounge'),(64,27,NULL,'2016-10-29',NULL,100752,79,'0r8g20161029120848','000000','Yes',NULL,'Horisontal','Lounge'),(65,27,NULL,'2016-10-31',NULL,100704,124,'0war20161031054859','None ','Yes',NULL,'Horisontal','Bedroom - Main'),(66,27,NULL,'2016-11-01',NULL,100705,3,'0x2g20161101130407','None ','Yes',NULL,'Horisontal','Passage'),(67,27,NULL,'2016-11-03',NULL,100930,127,'0o4v20161103125358','WD001','Yes',NULL,'Vertical','Passage'),(68,27,NULL,'2016-11-04',NULL,100876,3,'01hx20161104105415','None ','Yes',NULL,'Horisontal','Passage'),(69,27,NULL,'2016-11-04',NULL,100873,3,'02e20161104125026','None ','Yes',NULL,'Horisontal','Passage'),(70,27,NULL,'2016-11-10',NULL,99852,3,'0usa20161110113445','None ','Yes',NULL,'Horisontal','Passage'),(71,27,NULL,'2016-11-14',NULL,100426,124,'0mp920161114123024','None','Yes',NULL,'Horisontal','Passage'),(72,27,NULL,'2016-11-14',NULL,101120,124,'0fsm20161114185351','None ','Yes',NULL,'Horisontal','Garrage'),(73,27,NULL,'2016-11-14',NULL,100201,124,'06q20161114185605','None ','Yes',NULL,'Horisontal','Bedroom - Second'),(74,27,NULL,'2016-11-17',NULL,100201,124,'0ydv20161117144423','None ','Yes',NULL,'Horisontal','Bathroom - Main'),(75,27,NULL,'2016-11-18',NULL,101294,124,'0wpe20161118132510','None ','Yes',NULL,'Horisontal','Bathroom - Main'),(76,27,NULL,'2016-11-24',NULL,101519,117,'0mau20161124140306','001','Yes',NULL,'Horisontal','Passage'),(77,27,NULL,'2016-11-24',NULL,101519,117,'05zq20161124141306','001','Yes',NULL,'Vertical','Passage'),(78,27,NULL,'2016-12-05',NULL,101717,124,'0znz20161205134811','None ','Yes',NULL,'Horisontal','Kitchen'),(79,27,NULL,'2016-12-05',NULL,101719,124,'0xmr20161205143547','None ','Yes',NULL,'Horisontal','Garrage'),(80,27,NULL,'2016-12-05',NULL,101723,124,'0n220161205152053','None ','Yes',NULL,'Horisontal','Garrage'),(81,27,NULL,'2016-12-06',NULL,101716,124,'0e1120161206052718','None ','Yes',NULL,'Horisontal','Kitchen'),(82,27,NULL,'2016-12-06',NULL,101724,124,'0p6s20161206110347','I00017','Yes',NULL,'Horisontal','Kitchen'),(83,27,NULL,'2016-12-06',NULL,101718,124,'02et20161206114613','I00016','Yes',NULL,'Horisontal','Garrage'),(84,27,NULL,'2016-12-06',NULL,101720,124,'08ym20161206143816','I00018','Yes',NULL,'Horisontal','Kitchen'),(85,27,NULL,'2016-12-06',NULL,101721,124,'05ne20161206144155','I00015','Yes',NULL,'Horisontal','Kitchen'),(86,27,NULL,'2016-12-06',NULL,101722,124,'0vgf20161206154750','I00019','Yes',NULL,'Horisontal','Garrage'),(87,27,NULL,'2016-12-08',NULL,97218,124,'0o9620161208053750','None ','Yes',NULL,'Vertical','Other'),(88,27,NULL,'2016-12-09',NULL,97218,124,'0dyb20161209055858','None ','Yes',NULL,'Vertical','Other'),(89,27,NULL,'2016-12-12',NULL,101738,125,'0ejh20161212124156','I00008','Yes',NULL,'Horisontal','Passage'),(90,27,NULL,'2016-12-13',NULL,97218,124,'028f20161213130831','None ','Yes',NULL,'Vertical','Other'),(91,27,NULL,'2016-12-19',NULL,102052,124,'0p9e20161219160428','I00012','Yes',NULL,'Horisontal','Passage'),(92,27,NULL,'2016-12-21',NULL,102074,124,'0ez20161221052919','I00015','Yes',NULL,'Vertical','Passage'),(93,27,NULL,'2016-12-23',NULL,102261,124,'0z320161223131834','None ','Yes',NULL,'Horisontal','Passage'),(94,27,NULL,'2016-12-24',NULL,102279,124,'0m7m20161224185622','None ','Yes',NULL,'Vertical','Passage'),(95,27,NULL,'2017-01-17',NULL,101715,124,'0t3j20170117144418','00009','Yes',NULL,'Horisontal','Kitchen'),(96,27,NULL,'2017-01-23',NULL,101718,124,'0zr720170123144525','None ','Yes',NULL,'Horisontal','Garrage'),(97,27,NULL,'2017-01-23',NULL,97384,124,'0o320170123162757','None ','Yes',NULL,'Horisontal','Kitchen'),(98,27,NULL,'2017-01-24',NULL,101721,124,'0pkx20170124053702','None ','Yes',NULL,'Horisontal','Kitchen'),(99,27,NULL,'2017-01-24',NULL,101719,124,'0w7r20170124053900','None ','Yes',NULL,'Horisontal','Garrage'),(100,27,NULL,'2017-01-24',NULL,101716,124,'04kj20170124054116','None ','Yes',NULL,'Horisontal','Kitchen'),(101,27,NULL,'2017-01-24',NULL,101723,124,'0gt20170124054244','None ','Yes',NULL,'Horisontal','Garrage'),(102,27,NULL,'2017-01-24',NULL,101717,124,'0uox20170124054509','None ','Yes',NULL,'Horisontal','Kitchen'),(103,27,NULL,'2017-01-24',NULL,101722,124,'0zk20170124054619','None ','Yes',NULL,'Horisontal','Garrage'),(104,27,NULL,'2017-01-24',NULL,101720,124,'0fym20170124054746','None ','Yes',NULL,'Horisontal','Kitchen'),(105,27,NULL,'2017-01-24',NULL,103084,124,'0hvz20170124135649','None ','Yes',NULL,'Horisontal','Scullery'),(106,27,NULL,'2017-01-25',NULL,103015,124,'04r20170125053044','None ','Yes',NULL,'Horisontal','Bathroom - Ensuite'),(107,27,NULL,'2017-01-28',NULL,103254,124,'0obt20170128065032','None ','Yes',NULL,'Horisontal','Bedroom - Main'),(108,27,NULL,'2017-01-31',NULL,101648,124,'0cy20170131131515','None ','Yes',NULL,'Horisontal','Bathroom - Main'),(109,27,NULL,'2017-02-01',NULL,101650,124,'0x2c20170201063353','None ','Yes',NULL,'Horisontal','Bathroom - Guest toilet'),(110,27,NULL,'2017-02-05',NULL,103384,124,'0r8c20170205064436','None ','Yes',NULL,'Horisontal','Diningroom'),(111,27,NULL,'2017-02-07',NULL,101120,124,'042t20170207162607','None ','Yes',NULL,'Horisontal','Garrage'),(112,27,NULL,'2017-02-08',NULL,101120,124,'077v20170208105608','None ','Yes',NULL,'Horisontal','Garrage'),(113,27,NULL,'2017-02-09',NULL,103538,124,'02oa20170209054524','None ','Yes',NULL,'Horisontal','Bathroom - Main'),(114,27,NULL,'2017-02-09',NULL,103531,124,'0ef120170209054618','None ','Yes',NULL,'Horisontal','Bathroom - Main'),(115,27,NULL,'2017-02-09',NULL,103532,124,'0e1220170209054707','None ','Yes',NULL,'Horisontal','Bathroom - Main'),(116,27,NULL,'2017-02-09',NULL,103533,124,'0tav20170209054804','None ','Yes',NULL,'Horisontal','Bathroom - Main'),(117,27,NULL,'2017-02-09',NULL,103534,124,'07u120170209054851','None ','Yes',NULL,'Horisontal','Bathroom - Main'),(118,27,NULL,'2017-02-09',NULL,103535,124,'076p20170209054921','None ','Yes',NULL,'Horisontal','Bathroom - Main'),(119,27,NULL,'2017-02-09',NULL,103536,124,'0u8e20170209054953','None ','Yes',NULL,'Horisontal','Bathroom - Main'),(120,27,NULL,'2017-02-09',NULL,103537,124,'0oz620170209055025','None ','Yes',NULL,'Horisontal','Bathroom - Main'),(121,27,NULL,'2017-02-09',NULL,103539,124,'08x820170209055059','None ','Yes',NULL,'Horisontal','Bathroom - Main'),(122,27,NULL,'2017-02-09',NULL,103541,124,'0oex20170209055136','None ','Yes',NULL,'Horisontal','Bathroom - Main'),(123,27,NULL,'2017-02-09',NULL,103599,127,'0m5b20170209090112','None','Yes',NULL,'Horisontal','Lounge'),(124,27,NULL,'2017-02-10',NULL,103449,124,'0k8n20170210043257','None ','Yes',NULL,'Vertical','Passage'),(125,27,NULL,'2017-02-10',NULL,103622,124,'0go20170210105446','None ','No','We ','Horisontal','Other'),(126,27,NULL,'2017-02-13',NULL,101648,3,'0v2120170213141659','No','Yes',NULL,'Horisontal','Bathroom - Guest toilet'),(127,27,NULL,'2017-02-15',NULL,103542,79,'0jh20170215133637','00000','Yes',NULL,'Horisontal','Passage'),(128,27,NULL,'2017-03-09',NULL,104027,124,'0gcy20170309054726','None ','Yes',NULL,'Horisontal','Bathroom - Main'),(129,27,NULL,'2017-03-17',NULL,104415,127,'0yqh20170317053453','None ','Yes',NULL,'Vertical','Other'),(130,27,NULL,'2017-03-17',NULL,104468,3,'0k7q20170317113918','None','Yes',NULL,'Vertical','Passage'),(131,27,NULL,'2017-03-24',NULL,104587,124,'04z920170324052311','None ','Yes',NULL,'Horisontal','Passage'),(132,27,NULL,'2017-03-30',NULL,104529,124,'0szt20170330055443','None ','Yes',NULL,'Horisontal','Bedroom - Main'),(133,27,NULL,'2017-03-30',NULL,104675,124,'0b5820170330055716','None ','Yes',NULL,'Horisontal','Garrage'),(134,27,NULL,'2017-03-31',NULL,103447,127,'0ahu20170331170613','None','Yes',NULL,'Horisontal','Passage'),(135,27,NULL,'2017-04-03',NULL,104587,79,'0ew220170403110016','00000','Yes',NULL,'Horisontal','Passage'),(136,27,NULL,'2017-04-03',NULL,104675,79,'0tyt20170403123659','00000','Yes',NULL,'Horisontal','Garrage'),(137,27,NULL,'2017-04-04',NULL,104675,124,'0skr20170404053337','None ','Yes',NULL,'Horisontal','Garrage'),(138,27,NULL,'2017-04-04',NULL,104538,3,'0r4v20170404123624','None','Yes',NULL,'Vertical','Bathroom - Ensuite'),(139,27,NULL,'2017-04-07',NULL,104928,124,'04m820170407065742','None ','Yes',NULL,'Horisontal','Bathroom - Ensuite'),(140,27,NULL,'2017-04-08',NULL,104675,5,'0oo20170408095636','None ','Yes',NULL,'Horisontal','Garrage'),(141,27,NULL,'2017-04-25',NULL,104675,124,'026n20170425060921','None None ','Yes',NULL,'Horisontal','Garrage'),(142,27,NULL,'2017-04-25',NULL,105302,124,'0oxz20170425062056','None ','Yes',NULL,'Vertical','Bathroom - Main'),(143,27,NULL,'2017-04-28',NULL,105302,124,'0e3a20170428055304','None ','Yes',NULL,'Vertical','Bathroom - Ensuite'),(144,27,NULL,'2017-05-03',NULL,105302,124,'0yhb20170503075456','None ','Yes',NULL,'Vertical','Bedroom - Main'),(145,27,NULL,'2017-05-05',NULL,105302,3,'0k5s20170505150330','None ','Yes',NULL,'Vertical','Scullery'),(146,27,NULL,'2017-05-13',NULL,104587,3,'0szv20170513125441','None ','Yes',NULL,'Horisontal','Passage'),(147,27,NULL,'2017-05-16',NULL,105302,127,'0nea20170516200655','None ','Yes',NULL,'Vertical','Passage'),(148,27,NULL,'2017-05-17',NULL,105904,127,'0tu720170517123225','None ','Yes',NULL,'Horisontal','Passage'),(149,27,NULL,'2017-05-25',NULL,105972,3,'0bda20170525151548','None','Yes',NULL,'Horisontal','Passage'),(150,27,NULL,'2017-05-26',NULL,106077,3,'0h6p20170526103755','None','Yes',NULL,'Horisontal','Passage'),(151,27,NULL,'2017-05-26',NULL,106079,3,'067420170526123006','None','Yes',NULL,'Horisontal','Passage'),(152,27,NULL,'2017-05-31',NULL,106208,127,'0st20170531132611','None ','Yes',NULL,'Horisontal','Bedroom - Main'),(153,27,NULL,'2017-06-01',NULL,105302,3,'0a3g20170601165009','None','Yes',NULL,'Vertical','Scullery'),(154,27,NULL,'2017-06-07',NULL,106384,3,'0nxx20170607110821','None ','Yes',NULL,'Horisontal','Passage'),(155,27,NULL,'2017-06-08',NULL,106425,127,'0k6820170608052126','00091','Yes',NULL,'Horisontal','Passage'),(156,27,NULL,'2017-06-08',NULL,106421,127,'071120170608052804','00092','Yes',NULL,'Vertical','Passage'),(157,27,NULL,'2017-06-08',NULL,106455,3,'0pw320170608130126','None ','Yes',NULL,'Horisontal','Passage'),(158,27,NULL,'2017-06-23',NULL,106147,3,'0nja20170623103949','None','Yes',NULL,'Vertical','Bathroom - Main'),(159,27,NULL,'2017-06-29',NULL,106992,3,'0s9j20170629104837','None','Yes',NULL,'Vertical','Bedroom - Main'),(160,27,NULL,'2017-07-05',NULL,107142,127,'065o20170705121552','I00108','Yes',NULL,'Horisontal','Passage'),(161,27,NULL,'2017-07-13',NULL,104529,127,'0anj20170713173330','None','Yes',NULL,'Horisontal','Bathroom - Main'),(162,27,NULL,'2017-09-11',NULL,108680,3,'0a1n20170911213418','None','Yes',NULL,'Horisontal','Bathroom - Ensuite'),(163,27,NULL,'2017-09-20',NULL,108886,3,'0z6o20170920165128','None ','Yes',NULL,'Horisontal','Passage'),(164,27,NULL,'2017-09-21',NULL,108890,3,'0k2h20170921111141','None ','Yes',NULL,'Vertical','Kitchen'),(165,27,NULL,'2017-09-21',NULL,108891,3,'036420170921131517','None ','Yes',NULL,'Horisontal','Passage'),(166,27,NULL,'2017-09-27',NULL,108844,3,'06tx20170927142130','None','Yes',NULL,'Horisontal','Bedroom - Main'),(167,27,NULL,'2017-09-28',NULL,106572,117,'0dvq20170928162814','None ','Yes',NULL,'Horisontal','Kitchen'),(168,27,NULL,'2017-10-19',NULL,109485,117,'0vr820171019142123','None ','Yes',NULL,'Vertical','Bedroom - Main'),(169,27,NULL,'2017-10-19',NULL,109484,117,'0thz20171019142548','None ','Yes',NULL,'Vertical','Bathroom - Main'),(170,27,NULL,'2017-10-19',NULL,109483,117,'093m20171019163156','None ','Yes',NULL,'Horisontal','Bathroom - Main'),(171,27,NULL,'2017-11-02',NULL,109775,3,'0tnu20171102151128','None','Yes',NULL,'Horisontal','Bathroom - Guest toilet'),(172,27,NULL,'2017-11-07',NULL,109892,117,'0w2f20171107172522','I.000160','Yes',NULL,'Horisontal','Bathroom - Main'),(173,27,NULL,'2017-11-14',NULL,109996,3,'0t3420171114115508','None ','Yes',NULL,'Horisontal','Passage'),(174,27,NULL,'2017-12-08',NULL,110586,3,'0suj20171208122012','None','Yes',NULL,'Horisontal','Passage'),(175,27,NULL,'2018-02-01',NULL,111825,3,'0xrq20180201170542','None ','Yes',NULL,'Horisontal','Study'),(176,27,NULL,'2018-02-13',NULL,112027,3,'0q5o20180213113824','None ','Yes',NULL,'Horisontal','Passage'),(177,27,NULL,'2018-02-13',NULL,112031,3,'0ko520180213132449','None ','Yes',NULL,'Horisontal','Passage'),(178,27,NULL,'2018-02-16',NULL,112138,3,'0v1t20180216105121','None','Yes',NULL,'Horisontal','Passage'),(179,27,NULL,'2018-02-22',NULL,112289,3,'058g20180222105802','None','Yes',NULL,'Horisontal','Passage'),(180,27,NULL,'2018-03-02',NULL,112339,3,'0asj20180302173626','None','Yes',NULL,'Vertical','Kitchen'),(181,27,NULL,'2018-03-19',NULL,112901,3,'0c9n20180319140543','None','Yes',NULL,'Vertical','Kitchen'),(182,27,NULL,'2018-03-20',NULL,112901,4,'0a7x20180320144152','Ajdhdjajqk','Yes',NULL,'Vertical','Passage'),(183,27,NULL,'2018-04-04',NULL,113138,3,'02y20180404123357','None','Yes',NULL,'Horisontal','Passage'),(184,27,NULL,'2018-04-10',NULL,113300,3,'0qa120180410111023','None ','Yes',NULL,'Horisontal','Bedroom - Main'),(185,27,NULL,'2018-04-16',NULL,112289,3,'0mzd20180416100046','None','Yes',NULL,'Horisontal','Passage'),(186,27,NULL,'2018-04-17',NULL,113497,4,'0yec20180417122731','Xjajejs','Yes',NULL,'Horisontal','Bathroom - Main'),(187,27,NULL,'2018-04-25',NULL,113654,3,'0pv720180425121254','None','Yes',NULL,'Horisontal','Passage'),(188,27,NULL,'2018-05-11',NULL,114030,3,'05c520180511142016','None','Yes',NULL,'Horisontal','Passage'),(189,27,NULL,'2018-05-23',NULL,114308,3,'0w9w20180523075151','None ','Yes',NULL,'Horisontal','Passage'),(190,27,NULL,'2018-07-13',NULL,115441,128,'0dpe20180713165359','None ','Yes',NULL,'Vertical','Passage'),(191,27,NULL,'2018-07-24',NULL,115739,3,'0pcg20180724123115','None ','Yes',NULL,'Vertical','Passage'),(192,27,NULL,'2018-08-03',NULL,115441,3,'09tu20180803164632','None','Yes',NULL,'Vertical','Passage'),(193,27,NULL,'2018-08-06',NULL,115122,3,'0wet20180806171927','None','Yes',NULL,'Horisontal','Passage'),(194,27,NULL,'2018-08-07',NULL,115122,3,'0an20180807172125','None','Yes',NULL,'Horisontal','Passage'),(195,27,NULL,'2018-08-08',NULL,115122,3,'0pqx20180808173040','None','Yes',NULL,'Horisontal','Passage'),(196,27,NULL,'2018-08-13',NULL,115122,3,'0r8b20180813175553','None','Yes',NULL,'Horisontal','Passage'),(197,27,NULL,'2018-08-14',NULL,115122,3,'02z720180814170952','None','Yes',NULL,'Horisontal','Passage'),(198,27,NULL,'2018-08-15',NULL,115122,3,'019y20180815172603','None','Yes',NULL,'Horisontal','Passage'),(199,27,NULL,'2018-08-17',NULL,115122,3,'0fp320180817153557','None','Yes',NULL,'Horisontal','Passage'),(200,27,NULL,'2018-08-21',NULL,115122,3,'0j5920180821175021','None ','Yes',NULL,'Horisontal','Passage'),(201,27,NULL,'2018-08-21',NULL,115122,3,'0cg420180821175429','None ','Yes',NULL,'Horisontal','Passage'),(202,27,NULL,'2018-08-23',NULL,115122,3,'0j1x20180823152455','None ','Yes',NULL,'Vertical','Passage'),(203,27,NULL,'2018-08-29',NULL,116520,3,'04dw20180829192615','None','Yes',NULL,'Vertical','Passage'),(204,27,NULL,'2018-09-06',NULL,116339,79,'0e5220180906103629','00000 ','Yes',NULL,'Horisontal','Kitchen'),(205,27,NULL,'2018-09-11',NULL,116744,3,'0q1r20180911163257','None ','Yes',NULL,'Vertical','Kitchen'),(206,27,NULL,'2018-09-13',NULL,116789,137,'0wn420180913130738','Unknown ','No','No ','Horisontal','Passage'),(207,27,NULL,'2018-09-20',NULL,116901,3,'0yx220180920102241','None','Yes',NULL,'Horisontal','Passage'),(208,27,NULL,'2018-09-26',NULL,116976,3,'0kg520180926110302','None','Yes',NULL,'Horisontal','Passage'),(209,27,NULL,'2018-10-02',NULL,116901,4,'0y7120181002143557','Cjajaj','Yes',NULL,'Horisontal','Kitchen'),(210,27,NULL,'2018-10-03',NULL,115122,3,'0t4s20181003173628','None','Yes',NULL,'Horisontal','Passage'),(211,27,NULL,'2018-10-16',NULL,117435,3,'0rqg20181016175039','None','Yes',NULL,'Horisontal','Passage'),(212,27,NULL,'2018-10-19',NULL,117485,3,'03cg20181019111217','None','Yes',NULL,'Horisontal','Passage'),(213,27,NULL,'2018-10-26',NULL,117629,3,'0f3720181026133130','None','Yes',NULL,'Horisontal','Passage'),(214,27,NULL,'2018-10-30',NULL,106615,137,'09n420181030143005','None ','No','Non','Horisontal','Bedroom - Main'),(215,27,NULL,'2018-11-02',NULL,117750,3,'0u5c20181102133813','None ','Yes',NULL,'Horisontal','Bathroom - Guest toilet'),(216,27,NULL,'2018-11-12',NULL,117796,3,'0rx520181112142256','None','Yes',NULL,'Horisontal','Kitchen'),(217,27,NULL,'2018-11-24',NULL,118202,3,'0ms420181124140107','None ','Yes',NULL,'Horisontal','Passage'),(218,27,NULL,'2018-11-28',NULL,118270,3,'0dru20181128142218','None','Yes',NULL,'Horisontal','Passage'),(219,27,NULL,'2018-12-10',NULL,118469,3,'0aba20181210111619','None','Yes',NULL,'Horisontal','Kitchen'),(220,27,NULL,'2018-12-10',NULL,117713,3,'0zq20181210122054','None','Yes',NULL,'Vertical','Laundry room'),(221,27,NULL,'2018-12-10',NULL,118479,3,'01z620181210130609','None','Yes',NULL,'Horisontal','Bedroom - Main'),(222,27,NULL,'2018-12-12',NULL,118402,3,'09oz20181212121554','None','Yes',NULL,'Horisontal','Passage'),(223,27,NULL,'2018-12-13',NULL,115122,3,'04x20181213154611','None','Yes',NULL,'Horisontal','Passage'),(224,27,NULL,'2018-12-18',NULL,118270,3,'0wcf20181218162836','None','Yes',NULL,'Vertical','Bathroom - Guest toilet'),(225,27,NULL,'2018-12-21',NULL,118735,3,'0uj420181221150631','None','Yes',NULL,'Horisontal','Kitchen'),(226,27,NULL,'2019-01-10',NULL,119117,137,'0zs120190110152131','None','Yes',NULL,'Horisontal','Bathroom - Main'),(227,27,NULL,'2019-02-01',NULL,119587,137,'0fc820190201113934','None ','Yes',NULL,'Horisontal','Passage'),(228,27,NULL,'2019-02-06',NULL,119117,3,'019j20190206172935','None','Yes',NULL,'Horisontal','Bathroom - Guest toilet'),(229,27,NULL,'2019-02-18',NULL,115122,3,'0tmu20190218164631','None','Yes',NULL,'Horisontal','Passage'),(230,27,NULL,'2019-03-13',NULL,120321,79,'0tf320190313111515','00000 ','Yes',NULL,'Horisontal','Passage'),(231,27,NULL,'2019-05-31',NULL,122109,3,'0f3o20190531105837','No ','Yes',NULL,'Horisontal','Passage'),(232,27,NULL,'2019-06-04',NULL,105302,3,'0w7n20190604150926','None ','Yes',NULL,'Vertical','Passage'),(233,27,NULL,'2019-06-04',NULL,122108,3,'07kv20190604160231','None ','Yes',NULL,'Vertical','Outside'),(234,27,NULL,'2019-07-25',NULL,123466,3,'0ofp20190725142352','None','Yes',NULL,'Horisontal','Kitchen'),(235,27,NULL,'2020-03-06',NULL,129003,138,'0mac20200306103556','None','No','Lag','Horisontal','Passage'),(236,27,NULL,'2020-03-19',NULL,129290,3,'06ws20200319120200','No','Yes',NULL,'Horisontal','Passage'),(237,27,NULL,'2020-04-30',NULL,130304,3,'0mpr20200430182649','No','Yes',NULL,'Horisontal','Passage'),(238,27,NULL,'2020-07-16',NULL,132273,3,'067b20200716120957','No','Yes',NULL,'Vertical','Passage'),(239,27,NULL,'2020-07-20',NULL,132273,3,'0w7g20200720110604','None ','Yes',NULL,'Vertical','Passage'),(240,27,NULL,'2020-08-26',NULL,133388,3,'03k20200826175241','None ','Yes',NULL,'Horisontal','Passage'),(241,27,NULL,'2020-09-02',NULL,133537,3,'0d7w20200902164838','No','Yes',NULL,'Horisontal','Passage'),(242,27,NULL,'2020-09-16',NULL,133876,146,'0tg620200916102133','Unsure','Yes',NULL,'Horisontal','Other'),(243,27,NULL,'2021-02-25',NULL,137590,3,'0yqc20210225144728','No','Yes',NULL,'Horisontal','Passage'),(244,27,NULL,'2021-04-09',NULL,138505,3,'0bw320210409110259','None ','Yes',NULL,'Horisontal','Lounge'),(245,27,NULL,'2021-05-13',NULL,139169,3,'0qgr20210513105110','None ','Yes',NULL,'Horisontal','Bathroom - Ensuite'),(246,27,NULL,'2021-05-25',NULL,139408,146,'0km720210525101844','WD001','No','No ','Horisontal','Passage'),(247,27,NULL,'2021-05-26',NULL,139436,3,'0nkj20210526174803','None ','Yes',NULL,'Horisontal','Passage'),(248,27,NULL,'2021-10-15',NULL,97024,3,'0ync20211015210320','No','Yes',NULL,'Horisontal','Passage'),(249,27,NULL,'2021-10-18',NULL,142388,3,'0k620211018123807','None ','Yes',NULL,'Horisontal','Lounge'),(250,27,NULL,'2021-11-02',NULL,140705,3,'015c20211102152248','No','Yes',NULL,'Vertical','Garrage'),(251,27,NULL,'2022-03-25',NULL,145533,3,'04bo20220325131505','Job is not done sence cable is','Yes',NULL,'Horisontal','Bathroom - Guest toilet'),(252,27,NULL,'2022-04-04',NULL,145533,3,'0ra420220404080658','None ','Yes',NULL,'Horisontal','Passage'),(253,27,NULL,'2022-05-11',NULL,146268,3,'0pw20220511103606','None ','Yes',NULL,'Horisontal','Passage'),(254,27,NULL,'2022-05-12',NULL,146268,3,'09u20220512094528','None ','Yes',NULL,'Horisontal','Passage'),(255,27,NULL,'2022-05-13',NULL,144631,3,'0nv820220513135207','None ','Yes',NULL,'Horisontal','Passage'),(256,27,NULL,'2022-05-23',NULL,146780,3,'01z20220523111218','None ','Yes',NULL,'Horisontal','Passage'),(257,27,NULL,'2022-06-06',NULL,147035,3,'0m4g20220606100125','None ','Yes',NULL,'Horisontal','Passage'),(258,27,NULL,'2022-08-29',NULL,149090,3,'0mwc20220829145848','None ','Yes',NULL,'Horisontal','Passage'),(259,27,NULL,'2022-10-05',NULL,149904,3,'0dw220221005073847','Ni','Yes',NULL,'Horisontal','Passage'),(260,27,NULL,'2022-10-05',NULL,149904,3,'0wma20221005181940','None ','Yes',NULL,'Horisontal','Passage'),(261,27,NULL,'2022-10-31',NULL,150487,138,'0wn520221031130736','0000000','Yes',NULL,'Horisontal','Passage'),(262,27,NULL,'2022-11-01',NULL,149904,3,'0ufn20221101123501','None ','Yes',NULL,'Horisontal','Passage'),(263,27,NULL,'2023-02-04',NULL,152425,3,'0rn620230204123924','No','Yes',NULL,'Horisontal','Passage'),(264,27,NULL,'2023-05-25',NULL,154908,79,'0rth20230525104316','00000','Yes',NULL,'Horisontal','Garrage');
/*!40000 ALTER TABLE `werd` 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:06
