-- 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 `products` -- DROP TABLE IF EXISTS `products`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `products` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `Insurer` int(11) NOT NULL, `ProductCategory` varchar(255) NOT NULL, `Description` varchar(255) NOT NULL, `UnitType` varchar(40) NOT NULL, `Price` double NOT NULL, PRIMARY KEY (`ID`), KEY `insurer2` (`Insurer`), CONSTRAINT `insurer2` FOREIGN KEY (`Insurer`) REFERENCES `setup_insurer` (`pk_insurer`) ) ENGINE=InnoDB AUTO_INCREMENT=591 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `products` -- LOCK TABLES `products` WRITE; /*!40000 ALTER TABLE `products` DISABLE KEYS */; INSERT INTO `products` VALUES (1,40,'Geyser','Geyser, Kwikhot 50L','each',2474),(2,40,'Geyser','Geyser, Kwikhot 100L','each',2474),(3,40,'Geyser','Geyser, Kwikhot 150L','each',2668),(4,40,'Geyser','Geyser, Kwikhot 200L','each',4278),(5,40,'Geyser','Geyser, Kwikhot 250L','each',7020),(6,40,'Geyser','Fittings - Geyser','each',740),(7,40,'Geyser Component','Drip Tray - 50,100L','each',132),(8,40,'Geyser Component','Drip Tray - 150,200L','each',162),(9,40,'Geyser Component','Drip Tray - 250L','each',185),(10,40,'Geyser Component','Valve','each',452),(11,40,'Geyser Component','Vacuum breaker','each',73),(12,40,'Labour','Labour Geyser Installation -normal','job',1360),(13,40,'Labour','Labour Geyser Installation -after hours','job',1700),(14,40,'Labour','Labour Inspection fee - normal','job',300),(15,40,'Labour','Labour Inspection fee - after hours','job',375),(16,77,'Basin accessories','32mm pop-up waste','no',223),(17,77,'Brickwork','Rebuild 110mm cement stock wall','sqm',231),(18,77,'Brickwork','Rebuild 220mm cement stock wall','sqm',348),(19,77,'Brickwork','Rebuild 110mm semi-face brick wall','sqm',258),(20,77,'Brickwork','Rebuild 220mm semi-face brick wall','sqm',375),(21,77,'Brickwork','Rebuild 110mm face brick wall','sqm',284),(22,77,'Brickwork','Rebuild 220mm face brick wall','sqm',405),(23,77,'Brickwork','Rebuild 110mm cementstock wall, plaster 1 side','sqm',374),(24,77,'Brickwork','Rebuild 220mm cementstock wall, plaster 1 side','sqm',491),(25,77,'Brickwork','Rebuild 110mm semi-face brick wall, plaster 1 side','sqm',401),(26,77,'Brickwork','Rebuild 220mm semi-face brick wall, plaster 1 side','sqm',548),(27,77,'Brickwork','Rebuild 110mm cement stock wall, plaster 2 sideS','sqm',517),(28,77,'Brickwork','Rebuild 220mm cement stock wall, plaster 2 sideS','sqm',634),(29,77,'Ceilings','Replace 4.0mm Nutec ceiling ','sqm',202),(30,77,'Ceilings','Replace 6.4mm Rhino board ceiling','sqm',190),(31,77,'Ceilings','Replace 6.4mm Plastered Rhino board ceiling ','sqm',305),(32,77,'Ceilings','Repair ceiling (any type and thickness)','sqm',98),(33,77,'Ceilings','Replace 9.5mm Rhino board ceiling','sqm',204),(34,77,'Ceilings','Replace 9.5mm Plastered Rhino board ceiling ','sqm',320),(35,77,'Ceilings','Replace 38mm x 38mm Brandering ','sqm',96),(36,77,'Ceilings','Replace 75mm Std Rhino or Nutec cornice ','m',54),(37,77,'Ceilings','Replace 125mm Std Rhino or Nutec cornice','m',88),(38,77,'Ceilings','Replace 75mm Std Polystyrene cornice ','m',50),(39,77,'Ceilings','Replace 125mm Std Polystyrene cornice','m',60),(40,77,'Ceilings','PC val Moulded/special/patterned cornice any type)Cost+15%','each',0),(41,77,'Ceilings','PC val Ceiling rose (any type).Cost+15%','each',0),(42,77,'Ceilings','Replace 50mm Fibreglass insulation/sqm','sqm',75),(43,77,'Ceilings','Replace 75mm Fibreglass insulation/sqm','sqm',75),(44,77,'Ceilings','Tongued and grooved SA pine (knotty pine)1.20m','sqm',430),(45,77,'Ceilings','Tongued and grooved Meranti','sqm',664),(46,77,'Clean','Remove, clean and refit light fitting','each',96),(47,77,'Clean','Remove, clean and refit ceiling fan / chandelier','each',138),(48,77,'Concrete','Readymix concrete supplied and placed on site','per cube',1280),(49,77,'Concrete','Handmixed concrete ','per cube',1590),(50,77,'Concrete','Replace 100mm surface bed/shower floor','sqm',320),(51,77,'Connex fittings','Connex fittings 15mm fittings','no',75),(52,77,'Connex fittings','Connex fittings 22mm fittings','no',103),(53,77,'Connex fittings','Connex fittings 15mm copper to iron wall plate elbow','no',94),(54,77,'Connex fittings','Connex fittings 22mm copper to iron wall plate elbow','no',116),(55,77,'Connex fittings','Connex fittings 15mm copper to galvanised straight coupler','no',66),(56,77,'Connex fittings','Connex fittings 22mm copper to galvanised straight coupler','no',88),(57,77,'Copper pipes','Copper pipe, 15mm fixed to walls in chases, ceilings, roofs','m',109),(58,77,'Copper pipes','Copper pipe, 22mm fixed to walls in chases, ceilings or roofs','m',142),(59,77,'Cornice','Replace 32mm SA Pine scotia','m',53),(60,77,'Cornice','Replace 32mm Meranti scotia','m',65),(61,77,'Cornice','Replace 70mm Pine cornice','m',42),(62,77,'Demolitions','Break up and remove concrete foundations','m',276),(63,77,'Demolitions','Break up and remove concrete foundations with jack hammer','m',172),(64,77,'Demolitions','Break up and remove 100mm surface bed','sqm',103),(65,77,'Demolitions','Break up and remove 100mm surface bed with jack hammer','sqm',55),(66,77,'Demolitions','Break up and remove reinforced 100mm surface bed','sqm',103),(67,77,'Demolitions','Break up and remove 110mm walls','sqm',83),(68,77,'Demolitions','Break up and remove 220mm walls','sqm',124),(69,77,'Demolitions','Break up and remove rock wall','sqm',186),(70,77,'Demolitions','Break up and remove plaster from walls','sqm',68),(71,77,'Demolitions','Break up floor screed','sqm',55),(72,77,'Demolitions','Break up floor screed with jack hammer/light breaker','sqm',27),(73,77,'Demolitions','Break up concrete shower floor','sqm',415),(74,77,'Demolitions','Break up concrete shower floor with jack hammer','sqm',276),(75,77,'Demolitions','Scrape off paint from walls','sqm',24),(76,77,'Demolitions','Remove floor/wall tiles','sqm',68),(77,77,'Demolitions','Remove partitioning','sqm',42),(78,77,'Demolitions','Remove timber skirting','m',14),(79,77,'Demolitions','Remove vinyl tiles','sqm',41),(80,77,'Demolitions','Remove fitted carpets ? once-off fixed amount per claim','Item',382),(81,77,'Demolitions','Remove carpet tiles','sqm',14),(82,77,'Demolitions','Remove corrugated iron sheeting or IBR sheeting','sqm',41),(83,77,'Demolitions','Remove timber roof trusses','m',21),(84,77,'Demolitions','Remove brandering or roof battens','sqm',21),(85,77,'Drywall','Supply and fit (12.5mm and 15mm) fire stop-/ moisture board','sqm',208),(86,77,'Drywall','Replace drywall partitioning complete (frame and board)','sqm',439),(87,77,'Electrical','Supply and fit: External isolator complete','job',660),(88,77,'Excavation & filling','Excavations not exceeding 1m deep','m',29),(89,77,'Excavation & filling','Excavations between 1m and 2m deep','m',103),(90,77,'Excavation & filling','Filling to trenches, compacted in layers not exceeding 1m deep','m',17),(91,77,'Excavation & filling','Filling to trenches, compacted in layers between 1m and 2m deep','m',53),(92,77,'Excavation & filling','Rerouting of sewerage pipes/hour (max 3 hours)','hour',415),(93,77,'Galvanized Fittings','15mm fittings','no',43),(94,77,'Galvanized Fittings','22mm fittings','no',46),(95,77,'Galvanized Pipes','15mm pipe fixed to walls in chases, ceilings, roofs','m',128),(96,77,'Galvanized Pipes','22mm pipe fixed to walls in chases, ceilings or roofs','m',131),(97,77,'Galvanized Pipes','15mm pipes laid in ground not exceeding 1m deep','m',162),(98,77,'Galvanized Pipes','22mm pipes laid in ground not exceeding 1m deep','m',166),(99,77,'Geyser','Geyser Spares','item',830),(100,77,'Geyser','Geyser Platform and labour to construct','job',147),(101,77,'Geyser Component','Element 2 Kw','item',315),(102,77,'Geyser Component','Element 2Kw spiral','item',297),(103,77,'Geyser Component','Element 3 Kw','item',317),(104,77,'Geyser Component','Element 3 Kw spiral','item',321),(105,77,'Geyser Component','Element 4 Kw','item',319),(106,77,'Geyser Component','Element 4 Kw spiral','item',345),(107,77,'Geyser Component','Kwiktherm Thermostat TH 208','item',268),(108,77,'Geyser Component','Kwiktherm Thermostat TH 206','item',248),(109,77,'Geyser Component','Safety valve KH 1.406','item',307),(110,77,'Geyser Component','Apex Banjo valve','item',434),(111,77,'Geyser Component','Cobra Banjo valve','item',1422),(112,77,'Geyser Component','Draincock KH 5.001','item',231),(113,77,'Geyser Component','PRV valve ? multi','item',940),(114,77,'Geyser Component','PRV valve ? mono','item',907),(115,77,'Geyser Component','Masterflo 1 or 2 valve','item',1155),(116,77,'Geyser Component','Cobra masterflo valve','item',1097),(117,77,'Geyser Component','22mm Vacuum breaker','item',133),(118,77,'Geyser Component','22mm Gate valve','item',174),(119,77,'Geyser Component','15mm Spring loaded non-return','item',117),(120,77,'Geyser Component','22mm Spring loaded non-return','item',176),(121,77,'Geyser Component','15mm Swing non-return valve','item',155),(122,77,'Geyser Component','22mm Swing non-return valve','item',178),(123,77,'Labour','Labour to fit moulded each','each',34),(124,77,'Labour','Labour to fit ceiling rose (any type)','each',111),(125,77,'Labour','Add on for shower and walls (waterproofing/bonding liquid)','sqm',11),(126,77,'Labour','Sika waterproofing to shower floors','sqm',385),(127,77,'Labour','Sika waterproofing to shower walls','sqm',169),(128,77,'Labour','Labour, Inspection fee','job',555),(129,77,'Labour','Labour, Assessing fee','job',445),(130,77,'Labour','Startup fee','job',925),(131,77,'Labour','Geyser labour','job',830),(132,77,'Labour','Drip tray: First time labour & spares','job',310),(133,77,'Labour','Labour, Remove toilet and cistern (1 hour)','no',415),(134,77,'Labour','Labour, Remove basin (0.5 hour)','no',207),(135,77,'Labour','Labour, Remove bath (1.5 hours)','no',622),(136,77,'Labour','Labour, Remove sink (0.5 hour)','no',207),(137,77,'Labour','Labour, Build in toilet and cistern (2.5 hours )','no',1037),(138,77,'Labour','Labour, Build in basin (2 hours)','no',830),(139,77,'Labour','Labour, Build in bath (3 hours)','no',1245),(140,77,'Labour','Labour, Refit sink and connect waste (1.5 hours)','no',622),(141,77,'Labour','Labour, Open-up & Close of roof for geyser replacement','job',1035),(142,77,'Labour Tiles','Prepare by chipping surfaces etc. if required','sqm',21),(143,77,'Labour Tiles','Replacement of Vinyl tiles','sqm',125),(144,77,'Labour Tiles','Replacement of Ceramic tiles','sqm',170),(145,77,'Labour Tiles','Replacement of Natural stone tiles(slate)','sqm',176),(146,77,'Labour Tiles','Replacement of Porcelain tiles','sqm',173),(147,77,'Labour Tiles','Clean tiles (fire claims)','each',34),(148,77,'Labour Tiles','Remove old grout and re-grout tiles','each',77),(149,77,'Labour Tiles','Sealant to Porcelain- and Vinyl tiles','sqm',48),(150,77,'Labour Tiles','Sealant to Natural Stone- and Ceramic tiles','sqm',62),(151,77,'Minimum Fee','Minimum fee Ceilings, painting and tiles','job',2670),(152,77,'Painting','Paint PVA on ceilings ','sqm',49),(153,77,'Painting','Paint PVA on walls ','sqm',49),(154,77,'Painting','Paint Enamel to walls ','sqm',72),(155,77,'Painting','Paint Enamel to ceilings','sqm',72),(156,77,'Painting','Paint Double velvet ceilings standard colours','sqm',65),(157,77,'Painting','Paint Double velvet walls standard colours ','sqm',65),(158,77,'Painting','Paint Double velvet & tinted paint walls ','sqm',67),(159,77,'Painting','Paint Double velvet & tinted paint ceilings ','sqm',67),(160,77,'Painting','Painting Velvaglo non-drip ceilings','sqm',52),(161,77,'Painting','Paint Velvaglo non-drip walls ','sqm',52),(162,77,'Painting','Paint Road marking ','sqm',56),(163,77,'Painting','Apply Universal undercoat','sqm',34),(164,77,'Painting','Apply Varnish to timber ceilings (clear)','sqm',100),(165,77,'Painting','Apply Varnish to timber ceilings (coloured)','sqm',110),(166,77,'Painting','Apply Bonding liquid ','sqm',44),(167,77,'Painting','Paint Enamel to doors, windows etc','sqm',82),(168,77,'Painting','Paint Varnish to internal and external timber doors, windows etc. (3coats)','sqm',125),(169,77,'Painting','Paint Enamel to skirting, architraves etc','m',30),(170,77,'Painting','Paint Varnish to skirting, architraves etc','m',37),(171,77,'Painting','Paint two coats enamel on gutters and down pipes','m',50),(172,77,'Painting','Paint two coats painting to fascias and barges','m',48),(173,77,'Pipes other','15mm flexi connector (std) ? 300mm','no',81),(174,77,'Pipes other','15mm flexi connector with stop valve ? 300mm','no',161),(175,77,'Plaster','Rhinolite on walls ','sqm',80),(176,77,'Plaster','Apply 25mm screed','sqm',151),(177,77,'Polycop pipes','Polycop pipe, 15mm laid in ground','m',26),(178,77,'Polycop pipes','Polycop, 22mm laid in ground not exceeding 1m deep','m',32),(179,77,'PVC Fitting','PVC Fitting 50mm bend','no',31),(180,77,'PVC Fitting','PVC Fitting 50mm junction','no',34),(181,77,'PVC Fitting','PVC Fitting 50mm vent valve','no',73),(182,77,'PVC Fitting','PVC Fitting 110mm pipe (SABS approved) laid in ground not exceeding 1m deep','m',232),(183,77,'PVC Fitting','PVC Fitting 110mm pipe (SABS approved) laid in ground between 1m and 2m deep','m',266),(184,77,'PVC Fitting','PVC Fitting 110mm bend','no',107),(185,77,'PVC Fitting','PVC Fitting 110mm junction','no',141),(186,77,'PVC Fitting','PVC Fitting 110mm junction with inspection eye','no',181),(187,77,'PVC Fitting','PVC Fitting 100mm cleaning eye 300mm x 300mm cast iron cover and frame','no',675),(188,77,'PVC Fitting','PVC Fitting 110mm pipes fixed to walls','m',111),(189,77,'PVC Fitting','PVC Fitting 110mm Roding eye','no',90),(190,77,'PVC Fitting','PVC Fitting 110mm reducer','no',112),(191,77,'PVC Fitting','PVC Fitting 110mm double Y-junction','no',454),(192,77,'PVC Fitting','PVC Fitting 110mm reducing junction','no',126),(193,77,'PVC Fitting','PVC Fitting 110mm P-trap','no',152),(194,77,'PVC Fitting','PVC Fitting 110mm 150mm round gulley head including grid','no',84),(195,77,'PVC Fitting','PVC Fitting 110mm 250mm square gulley head including grid','no',205),(196,77,'PVC Fitting','PVC Fitting 110mm PVC to earthenware adaptor','no',143),(197,77,'PVC Fitting','PVC Fitting 100mm PVC to cast iron adaptor','no',167),(198,77,'PVC Pipes','PVC Pipes, 50mm pipes fixed to walls','m',91),(199,77,'Rubble removal','Remove rubble smaller than 1cube - allow once off','cube',747),(200,77,'Rubble removal','Burnt contents or material and stockpile for removal','sqm',68),(201,77,'Rubble removal','Rubble between 1cube - 3cube including transport, load & disposal','Item',1220),(202,77,'Rubble removal','Rubble between 3cube - 6cube including transport, load & disposal','Item',1895),(203,77,'Rubble removal','Rubble between 6cube - 10cube including transport, load and disposal','Item',2318),(204,77,'Solder fittings','Solder fittings, 15mm fittings','no',37),(205,77,'Solder fittings','Solder fittings, 22mm fittings','no',41),(206,77,'Solder fittings','Solder fittings ,15mm copper to iron wall plate elbow','no',101),(207,77,'Solder fittings','Solder fittings, 22mm copper to iron wall plate elbow','no',117),(208,77,'Solder fittings','Solder fittings, 15mm copper to galvanised straight coupler','no',42),(209,77,'Solder fittings','Solder fittings 22mm copper to galvanised straight coupler','no',44),(210,77,'Startup fee','Startup fee Ceilings and Painting','job',925),(211,77,'Startup fee','Startup fee Tiling','job',925),(212,77,'Stop cocks','15mm angle valve','no',147),(213,77,'Tiles','Cost of new wall or floor tiles. Cost+15% ','sqm',0),(214,77,'Trap door','Supply and fit combination metal trapdoor (frame and lid)/each','each',590),(215,77,'Trap door','Make new trapdoor with half round and rhino board/each','each',336),(216,77,'Trap door','Make new trapdoor with metal frame and rhino board','each',568),(217,77,'Trap door','Refit existing trapdoor','each',172),(218,77,'Labour','Uplift and remove bricks or paving ','sqm',34),(219,77,'Brickwork','Plaster walls / Bagging incl. Primer','sqm',143),(220,77,'Clean','Clean uplifted paving','sqm',68),(221,77,'Labour','Remove and refit shower door','job',415),(222,83,'Building materials','Coach screws and plugs','per job',935),(223,83,'Building materials','Putty','per item',416),(224,83,'Building materials','Grouting light grey 1kg','per item',319),(225,83,'Building materials','Tile adhesive 1kg','per item',352),(226,83,'Building materials','Painters Mate','per item',165),(227,83,'Building materials','Nails','per job',352),(228,83,'Building materials','Bostic segamestic','per item',9427),(229,83,'Building materials','Cement / spade','per item',902),(230,83,'Building materials','Cement / bag','per item',902),(231,83,'Building materials','Sand/ spade','per item',484),(232,83,'Building materials','Sand / bag','per item',242),(233,83,'Building materials','Bricks','per item',33),(234,83,'Building materials','Silicone','per item',319),(235,83,'Electrical','Normal Isolator Switch','per item',14192),(236,83,'Electrical','All weather Isolator Switch','per item',16346),(237,83,'Electrical','Twin and earth wire','per item',1221),(238,83,'Electrical','Glands','per item',214),(239,83,'Electrical','Connector box','per item',76),(240,83,'Electrical','Spruage ','per meter',55),(241,83,'Electrical','Bonding & fastners','per meter',2712),(242,83,'Electrical','(wall plugs, scews, nails, cable ties, boding)','each',136),(243,83,'Electrical','Elements-Spiral 3kw','per item',250),(244,83,'Electrical','Elements-Spiral 4kw','per item',280),(245,83,'Electrical','Elements-Bosch 2kw','per item',200),(246,83,'Electrical','Elements-Bosch 3kw','per item',230),(247,83,'Electrical','Elements-Bosch 4kw','per item',250),(248,83,'Electrical','Thermostat VKF11','per item',310),(249,83,'Electrical','Thermostat Kwiktherm ','per item',200),(250,83,'Electrical','10amp 15amp & 20 amp Breaker','per item',180),(251,83,'Electrical','Main 60amp single breaker','per item',240),(252,83,'Electrical','Main 60amp double breaker','per item',250),(253,83,'Electrical','Earth Leakage','per item',1240),(254,83,'Electrical','Wire','per meter',7),(255,83,'Electrical','30 amp breaker','per item',4386),(256,83,'Electrical','30 amp double pole','per item',10526),(257,83,'Fittings - Copper Pipe','15mm Connex fittings','per item',2674),(258,83,'Fittings - Copper Pipe','22mm Connex fittings','per item',5985),(259,83,'Fittings - Copper Pipe','28mm Connex fittings','per item',14805),(260,83,'Fittings - Copper Pipe','15mm Solder fittings','per item',535),(261,83,'Fittings - Copper Pipe','22mm Solder fittings','per item',1567),(262,83,'Fittings - Copper Pipe','28mm Solder fittings','per item',2246),(263,83,'Fittings - Copper Pipe','Connex wall plate 15MM/22MM','per item',4558),(264,83,'Fittings - Copper Pipe','Holderbats','per item',126),(265,83,'Fittings - PVC','IE bend 50mm','per item',96),(266,83,'Fittings - PVC','45deg bend 40mm','per item',826),(267,83,'Fittings - PVC','40mm brackets','per item',128),(268,83,'Fittings - PVC','50mm brackets','per item',152),(269,83,'Fittings - PVC','IE bend 100mm','per item',93),(270,83,'Fittings - PVC','40mm coupling','per item',866),(271,83,'Fittings - PVC','50mm coupling','per item',1028),(272,83,'Fittings - PVC','110mm coupling','per item',2576),(273,83,'Fittings - PVC','40mm tee','per item',144),(274,83,'Fittings - PVC','50mm tee','per item',144),(275,83,'Fittings - PVC','110mm tee','per item',8022),(276,83,'Fittings - PVC','plain bend 40mm','per item',572),(277,83,'Fittings - PVC','plain bend 50mm','per item',878),(278,83,'Fittings - PVC','plain bend 110mm','per item',5894),(279,83,'Fittings - PVC','IE bend 40mm','per item',76),(280,83,'Fittings - PVC','45deg bend 50mm','per item',1172),(281,83,'Fittings - PVC','45deg bend 110mm','per item',6664),(282,83,'Fittings - PVC','45deg junction plain 40mm','per item',144),(283,83,'Fittings - PVC','45deg junction plain 50mm','per item',2732),(284,83,'Fittings - PVC','45deg junction plain 110mm','per item',82),(285,83,'Fittings - PVC','45deg Junction IE 40mm','per item',3078),(286,83,'Fittings - PVC','45deg Junction IE 50mm','per item',2972),(287,83,'Fittings - PVC','45deg Junction IE 110mm','per item',17414),(288,83,'Fittings - PVC','Rodding eye 110mm','per item',6408),(289,83,'Fittings - PVC','SNV bend 110mm','per item',613),(290,83,'Fittings - PVC','snv bend 45deg 110mm','per item',6664),(291,83,'Fittings - PVC','horn bend 110mm','per item',9662),(292,83,'Fittings - PVC','vent valve 2way 110mm','per item',8396),(293,83,'Fittings - PVC','Reducer PVC 50mm to 40mm','per item',734),(294,83,'Geyser','Kwikhot - 150l fatboy 600kpa','per item',301021),(295,83,'Geyser','Kwikhot - 150l slimline 600kpa','per item',283902),(296,83,'Geyser','Kwikhot - 200l 600kpa','per item',455184),(297,83,'Geyser','Kwikhot - 250l 600kpa','per item',777639),(298,83,'Geyser','Kwikhot - 100l 600kpa','per item',263248),(299,83,'Geyser','Kwikhot - 10L undercounter','per item',155089),(300,83,'Geyser','Techron - 50l 100 kpa','per item',243137),(301,83,'Geyser','Techron - 100l normal 100 Kpa','per item',288824),(302,83,'Geyser','Techron - 100l normal 200 kPA','per item',319806),(303,83,'Geyser','Techron - 100l normal 400 kPA','per item',397526),(304,83,'Geyser','Techron - 100l slimline 100 kPA','per item',309303),(305,83,'Geyser','Techron - 100l slimline 200 kPA','per item',377046),(306,83,'Geyser','Techron - 150l normal 100 kPA','per item',356039),(307,83,'Geyser','Techron - 150l normal 200 kPA','per item',400153),(308,83,'Geyser','Techron - 150l normal 400 kPA','per item',494153),(309,83,'Geyser','Techron - 200l 100 kPA','per item',454766),(310,83,'Geyser','Techron - 200l 200 kPA','per item',517256),(311,83,'Geyser','Techron - 200l 400 kPA','per item',697902),(312,83,'Geyser','Duratherm - 100l 400kpa','per item',340181),(313,83,'Geyser','Duratherm - 150l 400kpa','per item',387322),(314,83,'Geyser','Duratherm - 200l 400kpa','per item',587707),(315,83,'Geyser','Duratherm - 250l 400kpa','per item',732818),(316,83,'Geyser','Franki - 100l 400kpa','per item',2024),(317,83,'Geyser','Franki - 150l 400kpa','per item',20845),(318,83,'Geyser - Accessories','Geyser Blanket','per item',23204),(319,83,'Geyser - Accessories','Flange rubber Kwikhot','per item',2457),(320,83,'Geyser - Driptray','Poly drip tray 150L','per item',16727),(321,83,'Geyser - Driptray','Poly drip tray 200L','per item',16727),(322,83,'Geyser - Driptray','Poly drip tray 250L','per item',2308),(323,83,'Geyser - Driptray','Galvanised tray150','per item',2684),(324,83,'Geyser - Driptray','Galvanised tray 200','per item',30344),(325,83,'Geyser - Driptray','Galvanised tray 250L','per item',4026),(326,83,'Geyser - Platform','Battons 38mmx38mm x600mm ','per item',534),(327,83,'Geyser - Platform','Planks 114mm ','per item',2854),(328,83,'Geyser - Valves','22mm NRV - Swing flap','per item',8369),(329,83,'Geyser - Valves','22mm NRV - Spring loaded','per item',13213),(330,83,'Geyser - Valves','PRV - 600KPA - Hiflow','per item',6986),(331,83,'Geyser - Valves','PRV - 400KPA - Masterflow','per item',116609),(332,83,'Geyser - Valves','PRV - 400KPA - Hilfow','per item',6986),(333,83,'Geyser - Valves','PRV - 400KPA - Galeffi','per item',6986),(334,83,'Geyser - Valves','PRV - 200KPA - Masterflow','per item',93841),(335,83,'Geyser - Valves','PRV - 200KPA - Galeffi','per item',6986),(336,83,'Geyser - Valves','PRV - 200KPA - Cobra','per item',45283),(337,83,'Geyser - Valves','PRV - 100KPA - Mali with restricter','per item',62443),(338,83,'Geyser - Valves','Banjo valve','per item',5476),(339,83,'Geyser - Valves','Vacuum breakers -Cobra','per item',10875),(340,83,'Geyser - Valves','Vacuum breakers -KWIKOT','per item',7595),(341,83,'Geyser - Valves','Brass side inlet ballvalve','per item',20108),(342,83,'Geyser - Valves','Still flow inlet ballvalve','per item',10332),(343,83,'Geyser - Valves','Saftey valve - 600PKA','per item',16402),(344,83,'Geyser - Valves','Saftey valve - 400PKA','per item',29177),(345,83,'Geyser - Valves','Saftey valve - 200PKA','per item',29177),(346,83,'Geyser - Valves','Saftey valve - 100PKA','per item',29177),(347,83,'Labour','Callout fee','per callout',26316),(348,83,'Labour','Normal Labour','per hour',45614),(349,83,'Labour','Geyser installation','per job',1400),(350,83,'Labour','Unblock drain Southern Suburbs (callout + 1st hr)','per job',74298),(351,83,'Labour','Unblock drain Northern suburbs (callout + 1st hr)','per job',67544),(352,83,'Labour','Remove rubble less than 1 cube','per job',450),(353,83,'Labour','Remove rubble between 1 & 2 cubes once off','per job',700),(354,83,'Labour','Open & close roof for oher SP (IBR,Tile,Asbestos)','per job',700),(355,83,'Labour','Open & close roof on JJLP geyser (IBR,Tile,Asbestos)','per job',350),(356,83,'Labour','Chop up and remove 900x900 shower floor, install trap and waterproof and lay shower floor. No tiling','per job',1750),(357,83,'Labour','Chop up and remove shower floor larger than 900x900mm, install trap and waterproof and lay shower floor. No tiling','per job',2100),(358,83,'Pipes - Brader','Brader connectors 200mm','per item',614),(359,83,'Pipes - Brader','Brader connectors 300mm','per item',614),(360,83,'Pipes - Brader','Brader connectors mixer connector','per item',7895),(361,83,'Pipes - Brader','Brader connectors 450mm','per item',614),(362,83,'Pipes - Cobra','22mm Cobra Pipe','per meter',3196),(363,83,'Pipes - Cobra','15mm Cobra Pipe','per meter',1652),(364,83,'Pipes - Cobra','22mm Cobra insert','per meter',813),(365,83,'Pipes - Cobra','15mm Cobra insert','per meter',378),(366,83,'Pipes - Cobra','22mm Copper Overflow pipe per meter CLASS0','per meter',5905),(367,83,'Pipes - Copper','15mm Copper Pipe CLASS 1','per meter',4606),(368,83,'Pipes - Copper','15mm Copper Pipe CLASS 2','per meter',6465),(369,83,'Pipes - Copper','22mm Copper Pipe CLASS 0','per meter',7382),(370,83,'Pipes - Copper','22mm Copper Pipe CLASS 1','per meter',11236),(371,83,'Pipes - Copper','22mm Copper Pipe CLASS 2','per meter',8527),(372,83,'Pipes - Copper','28mm Copper Pipe ClASS 0','per meter',7381),(373,83,'Pipes - Copper','28mm Copper Pipe ClASS 1','per meter',16885),(374,83,'Pipes - Poly','22mm Polycop ','per meter',973),(375,83,'Pipes - Poly','15mm Polycop','per meter',463),(376,83,'Pipes - PVC','Black overflow','per meter',1071),(377,83,'Pipes - PVC','40mm Marley','per meter',182),(378,83,'Pipes - PVC','50 mm Marley','per meter',224),(379,83,'Pipes - PVC','110mm underground','per meter',35),(380,83,'Pipes - PVC','110mm above ground','per meter',4325),(381,83,'Pipes - PVC','40mm PVC hosepipe clamp','per item',497),(382,83,'Solar Accessories','Air release valve 15mm','per item',15836),(383,83,'Solar Accessories','Bajo valve','per item',39061),(384,83,'Solar Accessories','Double drain cock','per item',12591),(385,83,'Solar Accessories','PV Panel','per item',20462),(386,83,'Solar Accessories','12V Pump','per item',4639),(387,83,'Solar Accessories','220V Pump','per item',10914),(388,83,'Solar Accessories','15mm Lever Valve','per item',9211),(389,83,'Solar Accessories','22mm Lever Valve','per item',10495),(390,83,'Solar Accessories','R1 Lagging 22mm','per item',11413),(391,83,'Solar Accessories','Mixing valve','per item',45018),(392,83,'Solar Accessories','7 Day Timer','per item',4922),(393,83,'Solar Accessories','Deck Tights','per item',9957),(394,83,'Solar Accessories','Geysermax controller','per item',140812),(395,83,'Solar Accessories','50mm PVC brackets','per item',793),(396,83,'Solar Accessories','Electrical Truncking 25mm','per item',455),(397,83,'Solar Accessories','2x1.6m Solarmax panels (for 200l geyser)','per item',357498),(398,83,'Solar Accessories','1 x 2.3m Solarmax panel (for 150l geyser)','per item',483383),(399,83,'Stop & drain cocks','Single drain cock','per item',11494),(400,83,'Stop & drain cocks','Double drain cock','per item',19114),(401,83,'Stop & drain cocks','15mm Brass Stop cock','per item',17072),(402,83,'Stop & drain cocks','22mm Brass Stop Cock','per item',3866),(403,83,'Stop & drain cocks','Angle valve 15mm','per item',7059),(404,83,'Taps & Basins','Consumeables - Washers','per item',232),(405,83,'Taps & Basins','Consumeables - Jumper','per item',6078),(406,83,'Taps & Basins','Consumeables - Cartridge','per item',4432),(407,83,'Taps & Basins','Grating, Stainless steel with popup','per item',1344),(408,83,'Taps & Basins','Grating, Stainless steel with overflow','per item',6818),(409,83,'Taps & Basins','Grating, Stainless steel without overflow','per item',6589),(410,83,'Taps & Basins','Fixations','per item',292),(411,83,'Taps & Basins','Bath offset bracket','per item',312),(412,83,'Taps & Basins','Plug and chain','per item',5083),(413,83,'Taps & Basins','Bath Grating Stainless steel','per item',7269),(414,83,'Toilet components','Pan collar 110mm','per item',4051),(415,83,'Toilet components','Wax seal','per item',447),(416,83,'Toilet components','Jolly flex long','per item',34637),(417,83,'Toilet components','Jolly flex short','per item',28654),(418,83,'Toilet components','Foxy fit','per item',20662),(419,83,'Toilet components','Flush rubber in','per item',957),(420,83,'Toilet components','Flush rubber over ','per item',957),(421,83,'Toilet components','15mm brass ballvalve side inlet','per item',22981),(422,83,'Toilet components','15mm brass or plastic ballvalve bottom','per item',16726),(423,83,'Toilet components','Still flow','per item',11808),(424,83,'Toilet components','Flush handle','per item',6909),(425,83,'Toilet components','Maxi flush unit','per item',11955),(426,83,'Toilet components','Cyphin unit','per item',2576),(427,83,'Toilet components','Complete flush mechanism','per item',23842),(428,83,'Toilet components','Close couple porcelain complete BETA','per item',75768),(429,83,'Toilet components','Close couple (PAN) Beta Porcelain','per item',3936),(430,83,'Toilet components','Low Level Porcelain','per item',22426),(431,83,'Toilet components','Close couple cistern bottom inlet','per item',43698),(432,83,'Toilet components','Toilet Cistern low level plastic ','per item',25462),(433,83,'Tool Hire','Medium bosch breaker','per day',336),(434,83,'Tool Hire','Big core drill','per day',2772),(435,83,'Tool Hire','Jack hammer','per day',357),(436,83,'Tool Hire','Generator','per day',189),(437,83,'Tool Hire','Circular saw','per day',1302),(438,83,'Tool Hire','Jigsaw','per day',1092),(439,83,'Tool Hire','Grinder','per day',1232),(440,83,'Traps','PVC','per item',3444),(441,83,'Traps','Bottle trap Stainless steel','per item',231),(442,83,'Traps','Sink trap','per item',3444),(443,83,'Traps','Double sink trap','per item',6509),(444,83,'Traps','with overflow','per item',6544),(445,83,'Traps','Trap PVC','per item',4684),(446,83,'Traps','Stainless steel (ISCA)','per item',20044),(447,83,'Traps','Shower trap PVC complete','per item',434),(448,83,'Traps','Shower trap Stainless Steel Complete','per item',20044),(449,95,'Brickwork','75mm Stock brick wall for building in bath etc.',' sqm ',170),(450,95,'Brickwork','110mm Stock brick wall',' sqm ',162),(451,95,'Brickwork','220mm Stock brick wall',' sqm ',280),(452,95,'Brickwork','270mm Stock brick cavity wall with 50mm cavity',' sqm ',290),(453,95,'Brickwork','110mm Semi face brick wall',' sqm ',175),(454,95,'Brickwork','220mm Semi face brick wall',' sqm ',305),(455,95,'Brickwork','270mm Semi face brick cavity wall with 50mm cavity',' sqm ',315),(456,95,'Brickwork','110mm Face brick wall',' sqm ',190),(457,95,'Brickwork','220mm Face brick wall',' sqm ',325),(458,95,'Brickwork','270mm Face brick cavity wall with 50mm cavity',' sqm ',335),(459,95,'Brickwork','110mm Wide lintel built into brickwork',' m ',53),(460,95,'Brickwork','Concrete slab 30mpa not exceeding 100mm thick',' sqm ',170),(461,95,'Brickwork','25mm Screed',' sqm ',83),(462,95,'Brickwork','Clay brick paving',' sqm ',265),(463,95,'Brickwork','Concrete brick paving',' sqm ',185),(464,95,'Brickwork','Cement blocks 90 mm (labour, mortor and blocks)','sqm',310),(465,95,'Brickwork','Cement blocks 140 mm (labour, mortor and blocks)','sqm',360),(466,95,'Brickwork','Cement plaster ','sqm ',77),(467,95,'Brickwork','Rhinolite on walls ',' sqm ',80),(468,95,'Brickwork','Bagging to walls',' sqm ',40),(469,95,'Brickwork','Mortar - 110mm Brickwork',' sqm ',28),(470,95,'Brickwork','Mortar - 220mm Brickwork',' sqm ',50),(471,95,'Brickwork','Mortar - 270mm Brickwork',' sqm ',58),(472,95,'Ceilings','Brandering',' sqm ',44),(473,95,'Ceilings','Nutec cement ceiling (Incl cover strips & 75 mm cornice)',' sqm ',165),(474,95,'Ceilings','Rhinoboard ceiling (Incl. cover strips & 75 mm cornice)',' sqm ',165),(475,95,'Ceilings','Rhinoboard ceiling (incl. cover strips & 125 mm cornice)','sqm',178),(476,95,'Ceilings','Plastered Rhinoboard ceiling',' sqm ',235),(477,95,'Ceilings','Tongued and grooved SA pine (knotty pine) ceiling',' sqm ',300),(478,95,'Ceilings','Tongued and grooved Meranti ceiling',' sqm ',430),(479,95,'Ceilings','Suspended ceilings','sqm',245),(480,95,'Ceilings','Pressed steel trap door and frame 600 x 600 mm',' No ',270),(481,95,'Ceilings','Coved cornice 125 mm',' l/m ',44),(482,95,'Ceilings','Coved cornice 75 mm',' l/m ',35),(483,95,'Ceilings','50mm Fiberglass insulation',' sqm ',40),(484,95,'Ceilings','75mm Fiberglass insulation',' sqm ',47),(485,95,'Ceilings','100mm Fiberglass insulation',' sqm ',53),(486,95,'Demolitions','Break up and remove 75mm brick wall (bath wall)',' sqm ',45),(487,95,'Demolitions','Break up and remove 110mm brick wall',' sqm ',85),(488,95,'Demolitions','Break up and remove 220mm brick wall',' sqm ',120),(489,95,'Demolitions','Take up and remove brick paving ',' sqm ',50),(490,95,'Demolitions','Take up and remove floor tiles',' sqm ',50),(491,95,'Demolitions','Take up and remove wall tiles ',' sqm ',50),(492,95,'Demolitions','Break up and remove screed ',' sqm ',55),(493,95,'Demolitions','Remove timber skirting','l/ m ',7),(494,95,'Demolitions','Break up and remove plaster from brick walls ',' sqm ',40),(495,95,'Demolitions','Remove door and frame 2032 x 813 mm from brick wall','each',120),(496,95,'Demolitions','Remove toilet and cistern','each',150),(497,95,'Demolitions','Remove wash hand basin','each',120),(498,95,'Demolitions','Remove bath','each',230),(499,95,'Demolitions','Take off and remove steel corrugated or IBR roof sheeting',' sqm ',26),(500,95,'Demolitions','Removal of rubble - Fire Claims or claims where building is demolished ','m3',180),(501,95,'Geyser','Geyser, Kwikhot 600i - 50L','each',2742),(502,95,'Geyser','Geyser, Kwikhot 600i 100L','each',2710),(503,95,'Geyser','Geyser, Kwikhot 600i 150L','each',2900),(504,95,'Geyser','Geyser, Kwikhot 600i 200L','each',4500),(505,95,'Geyser','Geyser, Kwikhot 600i 250L','each',7260),(506,95,'Geyser','Geyser, Kwikhot Megaflow 100L','each',4010),(507,95,'Geyser','Geyser, Kwikhot Megaflow 150L','each',4395),(508,95,'Geyser','Geyser, Kwikhot Megaflow 200L','each',5335),(509,95,'Geyser','Sundries','each',670),(510,95,'Geyser Components','Drip Tray - 50,100L','each',135),(511,95,'Geyser Components','Drip Tray - 150,200L','each',165),(512,95,'Geyser Components','Drip Tray - 250L','each',185),(513,95,'Geyser Components','PRV - new kwikhot geysers','each',498),(514,95,'Geyser Components','Vacuum breaker x 2','each',98),(515,95,'Geyser Components','PRV- Kwikot HiFlo KH.3.214 & KH3.216 ','each',498),(516,95,'Geyser Components','PRV- Kwikot HiFlo KH3.114 & KH3.116 - 400.kpa','each',450),(517,95,'Geyser Components','PRV- Kwikot HiFlo KH3.224 &KH3.226 ? 400 kpa','each',498),(518,95,'Geyser Components','PRV- Kwikot HiFlo KH3-204 &KH3-206','each',441),(519,95,'Geyser Components','Kwikflo Closy valve 20mm 100kpa & vac breaker PA1.1L','each',660),(520,95,'Geyser Components','Kwikflo Closy valve 20mm 200kpa & vac breaker PA1.1','each',690),(521,95,'Geyser Components','Kwikflo Closy valve 20mm 400kpa PA1.1','each',640),(522,95,'Geyser Components','Kwiktherm Thermostat TH 208 (20amp)','each',98),(523,95,'Geyser Components','ELK130 4 kw kwiktherm Spiral Element','each',230),(524,95,'Geyser Components','ELK-138 3kw Kwikheat Spiral Element','each',171),(525,95,'Geyser Components','Thermostat VKF11 with leads','each',155),(526,95,'Geyser Components','ELK 126 Kwikheat Element, including gasket','each',150),(527,95,'Geyser Components','ELK 128 Kwikheat Element, including gasket','each',165),(528,95,'Geyser Components','ELK 130 Kwikheat Element, including gasket','each',185),(529,95,'Geyser Components','20 mm Cobra Gate valve 20mm','each',70),(530,95,'Geyser Components','Safety Valve KH 1.406','each',123),(531,95,'Geyser Components','Draincock KH 5.001','each',83),(532,95,'Geyser Components','6 Metre 50mm duct pipe (PIPE 50)','each',65),(533,95,'Geyser Components','KHI.406CX Fi temp & relief valve with compression outlet','each',110),(534,95,'Geyser Components','Caleffi Non-return Valve CxC NR-22','each',90),(535,95,'Labour','Labour Geyser installation ','job',1600),(536,95,'Labour','Labour Geyser Installation -after hours','job',2000),(537,95,'Labour','Labour, Plumbing Inspection fee','job',330),(538,95,'Labour','Labour, Electrical fault finding fee','job',150),(539,95,'Labour','Labour normal','hour',400),(540,95,'Labour','Labout call out fee','job',330),(541,95,'Labour','Build in toilet & cistern','job',800),(542,95,'Labour','Build in bath ( excluding side walls )','job',950),(543,95,'Labour','Build in basin','job',600),(544,95,'Labour','Refit sink & connect waste','job',500),(545,95,'Labour','Labour, Resultants Inspection fee','job',440),(546,95,'Labour','Minimum fee','job',1600),(547,95,'Painting','Two coats PVA/Super Acrylic','sqm',45),(548,95,'Painting','Two coats enamel/Double velvet ','sqm',52),(549,95,'Painting','Two coats painting of roofs ','sqm',54),(550,95,'Painting','Two coats Varnish on wood surfaces, ceilings','sqm',52),(551,95,'Painting','Sand and two coats varnish to wood surfaces','sqm',56),(552,95,'Painting','Painting of skirtings, pelmets etc.','p/m',17),(553,95,'Painting','Washing down of walls, ceilings etc. (smoke damage)','sqm',15),(554,95,'Painting','Two coats enamel paint to steel door frame - 115mm wall','l/m',43),(555,95,'Painting','Two coats enamel paint to steel door frame - 230mm wall','l/m',44),(556,95,'Painting','Two coats varnish to wooden door frame','l/m',41),(557,95,'Painting','Sanding down and two coats varnish to wooden door frame','l/m',44),(558,95,'Painting','Two coats enamel paint to window frames ','sqm',44),(559,95,'Painting','Two coats enamel paint on gutters and downpipes','l/m',36),(560,95,'Paving','Uplift , clean & relay paving','sqm',135),(561,95,'Paving','Labour to lay pavers','sqm',90),(562,95,'Plasterwork','Remove old plaster & apply new','sqm',105),(563,95,'Plasterwork','35 mm screed to floors','sqm',85),(564,95,'Plasterwork','Plaster wall ( new )','sqm',75),(565,95,'Plasterwork','Bagging to walls','sqm',40),(566,95,'Plasterwork','Skim plaster ceilings (entire ceiling and not just the joins)','sqm',75),(567,95,'Plasterwork','Rhinolite walls','sqm',80),(568,95,'Tiling','Prep surface for tiles ( chipping etc )','sqm',12),(569,95,'Tiling','Clean & re-grout tiles ( fire / flooding )','sqm',31),(570,95,'Tiling','Fit ceramic tiles including labour/ glue / grout','sqm',149),(571,112,'Geyser','Geyser, Kwikhot 600 Dual - 50L','each',2474),(572,112,'Geyser','Geyser, Kwikhot 600 Dual 100L','each',2474),(573,112,'Geyser','Geyser, Kwikhot 600 Dual 150L','each',2668),(574,112,'Geyser','Geyser, Kwikhot 600 Dual 200L','each',4278),(575,112,'Geyser','Geyser, Kwikhot 600 Dual 250L','each',7020),(576,112,'Geyser','Geyser, Megaflow 600i Square 100L','each',409574),(577,112,'Geyser','Geyser, Megaflow 600i Square 150L','each',44896),(578,112,'Geyser','Geyser, Megaflow 600i Square 200L','each',544792),(579,112,'Geyser','Fittings - Geyser','each',740),(580,112,'Geyser Component','Drip Tray - 50,100L','each',132),(581,112,'Geyser Component','Drip Tray - 150,200L','each',162),(582,112,'Geyser Component','Drip Tray - 250L','each',185),(583,112,'Geyser Component','Drip Tray Vertical 100/150/200L','each',11899),(584,112,'Geyser Component','Valve','each',452),(585,112,'Geyser Component','Vacuum breaker','each',73),(586,112,'Labour','Labour Geyser Installation -normal','job',1360),(587,112,'Labour','Labour Geyser Installation -after hours','job',1700),(588,112,'Labour','Labour Inspection fee - normal','job',300),(589,112,'Labour','Labour Inspection fee - after hours','job',375),(590,83,'Labour','COC inspection','job',550); /*!40000 ALTER TABLE `products` 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:24