
CREATE TABLE `ceb1` (
  `ceb1id` int(11) NOT NULL AUTO_INCREMENT,
  `conname` varchar(255) COLLATE latin1_bin NOT NULL,
  `accono` varchar(15) COLLATE latin1_bin NOT NULL,
  `area` varchar(255) COLLATE latin1_bin NOT NULL,
  `csc` varchar(100) COLLATE latin1_bin NOT NULL,
  `address` varchar(255) COLLATE latin1_bin NOT NULL,
  `repno` varchar(100) COLLATE latin1_bin NOT NULL,
  `testdate` date NOT NULL,
  `gprs` varchar(100) COLLATE latin1_bin NOT NULL,
  `tariff` varchar(255) COLLATE latin1_bin NOT NULL,
  `demand` varchar(20) COLLATE latin1_bin NOT NULL,
  PRIMARY KEY (`ceb1id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1 COLLATE=latin1_bin;

INSERT INTO ceb1 VALUES("1","Kumara Jayantha walisinghe Mangala","4570104585","Ambalangoda","Gonapeenuwala","No 459/B, Udugama Rd, Ambalangoda","EMSP/20180429/5","2018-04-21","-","-","30"),
("2","Saman Pushpa Kumara","4570104545","Ambalangoda","Gonapeenuwala","No 459/B, Udugama Rd, Ambalangoda","EMSP/20180429/5","2018-04-21","-","-","30"),
("3","Saman Pushpa Kumara","4570104545","Ambalangoda","Gonapeenuwala","No 459/B, Udugama Rd, Ambalangoda","EMSP/20180429/5","2018-04-21","-","-","30"),
("4","Saman Pushpa Kumara","4570104545","Ambalangoda","Gonapeenuwala","No 459/B, Udugama Rd, Ambalangoda","EMSP/20180429/5","2018-04-21","-","-","30"),
("5","Priyantha Kumara Jayantha walisinghe","4570104545","Ambalangoda","Gonapeenuwala","No 459/B, Udugama Rd, Ambalangoda","EMSP/20180429/5","2018-04-21","-","-","30"),
("6","Priyantha Kumara Jayantha walisinghe","4570104545","Ambalangoda","Gonapeenuwala","No 459/B, Udugama Rd, Ambalangoda","EMSP/20180429/5","2018-04-21","-","-","30"),
("7","Priyantha Kumara Jayantha walisinghe","4570104545","Ambalangoda","Gonapeenuwala","No 459/B, Udugama Rd, Ambalangoda","EMSP/20180429/5","2018-04-21","-","-","30"),
("8","Priyantha Kumara Jayantha walisinghe","4570104400","Galle","Bataduwa","No 452/B, Udugama Rd, Bataduwa","EMSP/20180429/4","2018-04-21","-","-","60"),
("9","Jagath Kumara Jayantha walisinghe","4570104400","Galle","Habaraduwa","No 452/B, Udugama Rd, Habaraduwa","EMSP/20180429/4","2018-04-21","-","-","60"),
("10","Priyantha Kumara Jayantha walisinghe","4570104400","Galle","Bataduwa","No 452/B, Udugama Rd, Bataduwa","EMSP/20180429/4","2018-05-22","-","-","60"),
("11","Priyantha Kumara Jayantha","4570104400","Ambalangoda","Induruwa","No 452/B, GM\'s house, Udugama Rd, Bataduwa","EMSP/20180429/4","2018-04-21","-","-","30"),
("12","Niroshan Kumara rathnayaka de silva","4570104422","Galle","Bataduwa","No 452/B, Udugama Rd, Bataduwa","EMSP/20180530/5","2018-03-05","-","-","30"),
("13","sandasiri Kumara","5416023805","Ambalangoda","Induruwa","No 14, Awariyawatta Road, pamburana, Matara","EM/SP/Test/1","2018-06-27","-","-","60"),
("14","Saman Pushpa Kumara","4570104405","Galle","Galle","No 452/B, Udugama Rd, Bataduwa","EMSP/20180819/","2018-08-19","-","-","60"),
("15","Saman Pushpa Kumara Wickramasinghe","4570104406","Galle","Bataduwa","No 452/B, Udugama Rd, Bataduwa","EMSP/20180819/12","2018-08-19","-","-","30"),
("16","Nimal Kumara Silva","2570101542","Galle","Bataduwa","No 458, Galle Road, Pinnaduwa.","EMSP/20181104/01","2018-11-04","-","-","60"),
("17","Sandasiri Nuwan","25701045875","Ambalangoda","Induruwa","no 458 a, siyambalagaswila north, ruhunu ridiyagama","EMSP/20181104/4","2018-11-04","-","-","60");




CREATE TABLE `ceb2` (
  `ceb2id` int(10) NOT NULL AUTO_INCREMENT,
  `make` varchar(50) NOT NULL,
  `serial` varchar(255) NOT NULL,
  `constant` varchar(50) NOT NULL,
  `mf` varchar(100) NOT NULL,
  `class` varchar(10) NOT NULL,
  `mfdate` year(4) NOT NULL,
  `totaltc` varchar(255) NOT NULL,
  `mdcurrent` varchar(20) NOT NULL,
  `mdhistory` varchar(20) NOT NULL,
  `l1` varchar(20) NOT NULL,
  `l2` varchar(20) NOT NULL,
  `l3` varchar(20) NOT NULL,
  `cl1` varchar(20) NOT NULL,
  `cl2` varchar(20) NOT NULL,
  `cl3` varchar(20) NOT NULL,
  `pf` varchar(20) NOT NULL,
  `punit` varchar(5) NOT NULL,
  `vunit` varchar(5) NOT NULL,
  `aunit` varchar(5) NOT NULL,
  `cunit` varchar(5) NOT NULL,
  PRIMARY KEY (`ceb2id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

INSERT INTO ceb2 VALUES("7","Premier","094001537","40 imp/kWh","-","1.0","2010","8975801","41.5","45.6","233","231","234","7.5","11","12","0.923","kwh","V","kVA","A"),
("6","Premier","094001537","40 imp/kWh","-","1.0","2010","8975801","41.5","45.6","233","231","234","7.5","11","12","0.923","kwh","V","kVA","A"),
("5","Premier","094001537","40 imp/kWh","-","1.0","2010","8975801","41.5","45.6","233","231","234","7.5","11","12","0.923","kwh","V","kVA","A"),
("4","Premier","094001537","40 imp/kWh","-","1.0","2010","8975801","41.5","45.6","233","231","234","7.5","11","12","0.923","kwh","V","kVA","A"),
("3","Premier","094001537","40 imp/kWh","-","1.0","2010","8975801","41.5","45.6","233","231","234","7.5","11","12","0.923","kwh","V","kVA","A"),
("2","Premier","094001537","40 imp/kWh"," -","1.0","2010","8975801","41.5","45.6","233","231","234","7.5","11","12","0.923","kwh","V","kVA","A"),
("1","Premier","094001537","40 imp/kWh","-","1.0","2010","8975801","41.5","45.6","233","231","234","7.5","11","12","0.923","kwh","V","kVA","A"),
("8","Genius","2105578585","10 imp/Kwh","-","1.0","2010","45878","12.5","14.6","233","231","234","7.5","21","2.5","0.856","kwh","V","kVA","A"),
("9","Genius","2105578585","10 imp/Kwh","-","1.0","2010","45878","12.5","14.6","233","231","234","7.5","21","2.5","0.856","kwh","V","kVA","A"),
("10","Genius","2105578585","10 imp/Kwh","-","1.0","2010","45878","12.5","14.6","233","231","234","7.5","21","2.5","0.856","kwh","V","kVA","A"),
("11","Genius","2105578588","20 imp/Kwh","-","1.0","2016","45878","12.5","14.6","233","231","234","7.5","21","2.5","0.856","kwh","V","kVA","A"),
("12","Genius","206375464","160 imp/Kwh","-","1.0","2010","456878956","15.4","14.6","233","231","235","3.8","12","12","0.925","kwh","V","kVA","A"),
("13","Premier","2790356","160 imp/kWh","-","0.5","2015","609","7","8","230","240","240","12","15","45","0.8","kwh","V","kVA","A"),
("14","Premier","094001537","400 imp/kWh","-","1.0","2010","45878478","52","51","230","231","230","45","42","41","0.923","kwh","V","kVA","A"),
("15","Genius","094001537","400 imp/kWh","-","1.0","2010","45878478","52","51","230","231","230","45","42","41","0.923","kwh","V","kVA","A"),
("16","Genius","94584587","20 imp/kWh","-","1.0","2005","478458","45","42","230","235","229","25","41","23","0.845","kwh","V","kVA","A"),
("17","Genius","4577785","40 imp/kWh","-","1.0","2015","7825475","25","74","230","235","231","45","52","42","0.478","kwh","V","kVA","A");




CREATE TABLE `ceb3` (
  `ceb3id` int(10) NOT NULL AUTO_INCREMENT,
  `make_old` varchar(50) NOT NULL,
  `serial_old` varchar(255) NOT NULL,
  `constant_old` varchar(50) NOT NULL,
  `mf_old` varchar(100) NOT NULL,
  `class_old` varchar(10) NOT NULL,
  `mfdate_old` year(4) NOT NULL,
  `totaltc_old` varchar(255) NOT NULL,
  `mdcurrent_old` varchar(20) NOT NULL,
  `mdhistory_old` varchar(20) NOT NULL,
  `l1_old` varchar(20) NOT NULL,
  `l2_old` varchar(20) NOT NULL,
  `l3_old` varchar(20) NOT NULL,
  `cl1_old` varchar(20) NOT NULL,
  `cl2_old` varchar(20) NOT NULL,
  `cl3_old` varchar(20) NOT NULL,
  `pf_old` varchar(20) NOT NULL,
  `punit` varchar(5) NOT NULL,
  `vunit` varchar(5) NOT NULL,
  `aunit` varchar(5) NOT NULL,
  `cunit` varchar(5) NOT NULL,
  `accuracy_old` varchar(10) NOT NULL,
  `wiring_old` varchar(10) NOT NULL,
  `properness_old` varchar(10) NOT NULL,
  `error1_old` varchar(10) NOT NULL,
  `error2_old` varchar(10) NOT NULL,
  `sequence_old` varchar(15) NOT NULL,
  UNIQUE KEY `ceb3id` (`ceb3id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

INSERT INTO ceb3 VALUES("7","Premier","094001537","40 imp/kWh","-","1.0","2010","8975801","41.5","45.6","233","231","234","7.5","11","12","0.923","kwh","V","kVA","A","","","","","",""),
("6","Premier","094001537","40 imp/kWh","-","1.0","2010","8975801","41.5","45.6","233","231","234","7.5","11","12","0.923","kwh","V","kVA","A","","","","","",""),
("5","Premier","094001537","40 imp/kWh","-","1.0","2010","8975801","41.5","45.6","233","231","234","7.5","11","12","0.923","kwh","V","kVA","A","","","","","",""),
("4","Premier","094001537","40 imp/kWh","-","1.0","2010","8975801","41.5","45.6","233","231","234","7.5","11","12","0.923","kwh","V","kVA","A","","","","","",""),
("3","Premier","094001537","40 imp/kWh","-","1.0","2010","8975801","41.5","45.6","233","231","234","7.5","11","12","0.923","kwh","V","kVA","A","","","","","",""),
("2","Premier","094001537","40 imp/kWh"," -","1.0","2010","8975801","41.5","45.6","233","231","234","7.5","11","12","0.923","kwh","V","kVA","A","","","","","",""),
("1","Premier","094001537","40 imp/kWh","-","1.0","2010","8975801","41.5","45.6","233","231","234","7.5","11","12","0.923","kwh","V","kVA","A","","","","","",""),
("8","Genius","2105578585","10 imp/Kwh","-","1.0","2010","45878","12.5","14.6","233","231","234","7.5","21","2.5","0.856","kwh","V","kVA","A","","","","","",""),
("9","Genius","2105578585","10 imp/Kwh","-","1.0","2010","45878","12.5","14.6","233","231","234","7.5","21","2.5","0.856","kwh","V","kVA","A","","","","","",""),
("10","Genius","2105578585","10 imp/Kwh","-","1.0","2010","45878","12.5","14.6","233","231","234","7.5","21","2.5","0.856","kwh","V","kVA","A","","","","","",""),
("11","Genius","2105578588","20 imp/Kwh","-","1.0","2016","45878","12.5","14.6","233","231","234","7.5","21","2.5","0.856","kwh","V","kVA","A","","","","","",""),
("12","Premier","094001533","160 imp/Kwh","-","1.0","2010","456878956","15.4","14.6","233","231","235","3.8","12","12","0.925","kwh","V","kVA","A","","","","","",""),
("13","Premier","2790356","160 imp/kWh","-","0.5","2015","609","7","8","230","240","240","12","15","45","0.8","kwh","V","kVA","A","","","","","",""),
("14","","","","","","0000","","","","","","","","","","","kwh","V","kVA","A","","","","","",""),
("15","Premier 300","9400158","160 imp/kWh","-","0.5","2010","455565","42","41","230","230","230","5","5","5","0.585","kwh","V","kVA","A","OK","OK","Yes","1.58","2.00","Forword"),
("16","","","","","","0000","","","","","","","","","","","kwh","V","kVA","A","","","","","",""),
("17","","","","","","0000","","","","","","","","","","","kwh","V","kVA","A","","","","","","");




CREATE TABLE `ceb4` (
  `ceb4id` int(10) NOT NULL AUTO_INCREMENT,
  `accuracy` varchar(10) NOT NULL,
  `wiring` varchar(10) NOT NULL,
  `properness` varchar(10) NOT NULL,
  `error1` varchar(10) NOT NULL,
  `error2` varchar(10) NOT NULL,
  `sequence` varchar(15) NOT NULL,
  `breaker` varchar(10) NOT NULL,
  `capacity` varchar(10) NOT NULL,
  `overload` varchar(10) NOT NULL,
  `enc` varchar(10) NOT NULL,
  `encfix` varchar(10) NOT NULL,
  `enccon` varchar(15) NOT NULL,
  `terold1` varchar(30) NOT NULL,
  `terold2` varchar(30) NOT NULL,
  `ternew1` varchar(30) NOT NULL,
  `ternew2` varchar(30) NOT NULL,
  `encold1` varchar(30) NOT NULL,
  `encold2` varchar(30) NOT NULL,
  `encnew1` varchar(30) NOT NULL,
  `encnew2` varchar(30) NOT NULL,
  `acttak` varchar(255) NOT NULL,
  `remarks` text NOT NULL,
  `recomend` varchar(255) NOT NULL,
  `team` varchar(20) NOT NULL,
  UNIQUE KEY `ceb4id` (`ceb4id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

INSERT INTO ceb4 VALUES("1","OK","OK","Yes","0.456","1.586","Forword","MCB","32","Yes","Yes","Yes","Good","CEB/DD4/4545454","CEB/DD4/4545457","CEB/DD4/4545478","CEB/DD4/4554589","CEB/DD4/4545442","CEB/DD4/447878","CEB/DD4/78787845","CEB/DD4/5455544","no action","In the above example, we needed four unique elements to get the job done. But that\'s four more elements than are appropriate semantically in our document. Ideal","no recomendation","Team A"),
("2","OK","OK","Yes","0.456","1.586","Forword","MCB","32","Yes","Yes","Yes","Good","CEB/DD4/4545454","CEB/DD4/4545457","CEB/DD4/4545478","CEB/DD4/4554589","CEB/DD4/4545442","CEB/DD4/447878","CEB/DD4/78787845","CEB/DD4/5455544","no action","In the above example, we needed four unique elements to get the job done. But that\'s four more elements than are appropriate semantically in our document. Ideal","no recomendation","Team A"),
("3","OK","OK","Yes","0.456","1.586","Forword","MCB","32","Yes","Yes","Yes","Good","CEB/DD4/4545454","CEB/DD4/4545457","CEB/DD4/4545478","CEB/DD4/4554589","CEB/DD4/4545442","CEB/DD4/447878","CEB/DD4/78787845","CEB/DD4/5455544","no action","In the above example, we needed four unique elements to get the job done. But that\'s four more elements than are appropriate semantically in our document. Ideal","no recomendation","Team A"),
("4","OK","OK","Yes","0.456","1.586","Forword","MCB","32","Yes","Yes","Yes","Good","CEB/DD4/4545454","CEB/DD4/4545457","CEB/DD4/4545478","CEB/DD4/4554589","CEB/DD4/4545442","CEB/DD4/447878","CEB/DD4/78787845","CEB/DD4/5455544","no action","In the above example, we needed four unique elements to get the job done. But that\'s four more elements than are appropriate semantically in our document. Ideal","no recomendation","Team A"),
("5","OK","OK","Yes","0.456","1.586","Forword","MCB","32","Yes","Yes","Yes","Good","CEB/DD4/4545454","CEB/DD4/4545457","CEB/DD4/4545478","CEB/DD4/4554589","CEB/DD4/4545442","CEB/DD4/447878","CEB/DD4/78787845","CEB/DD4/5455544","no action","In the above example, we needed four unique elements to get the job done. But that\'s four more elements than are appropriate semantically in our document. Ideal","no recomendation","Team A"),
("6","OK","OK","Yes","0.456","1.586","Forword","MCB","32","Yes","Yes","Yes","Good","CEB/DD4/4545454","CEB/DD4/4545457","CEB/DD4/4545478","CEB/DD4/4554589","CEB/DD4/4545442","CEB/DD4/447878","CEB/DD4/78787845","CEB/DD4/5455544","no action","In the above example, we needed four unique elements to get the job done. But that\'s four more elements than are appropriate semantically in our document. Ideal","no recomendation\'s here","Team A"),
("7","OK","OK","Yes","0.456","1.586","Forword","MCB","32","Yes","Yes","Yes","Good","CEB/DD4/4545454","CEB/DD4/4545457","CEB/DD4/4545478","CEB/DD4/4554589","CEB/DD4/4545442","CEB/DD4/447878","CEB/DD4/78787845","CEB/DD4/5455544","no action","In the above example, we needed four unique elements to get the job done. But that\'s four more elements than are appropriate semantically in our document. Ideal","no recomendation\'s here","Team A"),
("8","OK","OK","Yes","0.456","2.00","Forword","MCB","63","No","Yes","Yes","Good","CEB/DD4/4545454","CEB/DD4/4545457","CEB/DD4/4545478","CEB/DD4/4554589","CEB/DD4/4545442","","CEB/DD4/78787845","","no action","Mouse Events. onmouseover/onmouseout - When the mouse passes over an element · onmousedown/onmouseup - When pressing/releasing a mouse button · onmousedown - fh","no recomendations","Team B"),
("9","OK","OK","Yes","0.456","2.00","Forword","MCCB","63","No","Yes","Yes","Good","CEB/DD4/4545454","CEB/DD4/4545457","CEB/DD4/4545478","CEB/DD4/4554589","CEB/DD4/4545442","","CEB/DD4/78787845","","no action","Mouse Events. onmouseover/onmouseout - When the mouse passes over an element · onmousedown/onmouseup - When pressing/releasing a mouse button · onmousedown - fh","no recomendation","Team B"),
("10","OK","OK","Yes","0.456","2.00","Forword","MCB","63","No","Yes","Yes","Good","CEB/DD4/4545454","CEB/DD4/4545457","CEB/DD4/4545478","CEB/DD4/4554589","CEB/DD4/4545442","","CEB/DD4/78787845","","no action","Mouse Events. onmouseover/onmouseout - When the mouse passes over an element · onmousedown/onmouseup - When pressing/releasing a mouse button · onmousedown - fh","no recomendation","Team B"),
("11","OK","OK","Yes","0.456","2.001","Forword","MCB","63","No","Yes","Yes","Good","CEB/DD4/4545454","CEB/DD4/4545457","CEB/DD4/4545478","CEB/DD4/4554589","CEB/DD4/4545442","","CEB/DD4/78787845","","no action","Mouse Events. onmouseover/onmouseout - When the mouse passes over an element · onmousedown/onmouseup - When pressing/releasing a mouse button · onmousedown llll","no recomendation","Team C"),
("12","OK","OK","No","0.456","1.586","Forword","MCCB","32","Yes","Yes","No","Moderate","CEB/DD4/4545454","CEB/DD4/45454572","CEB/DD4/4545478","CEB/DD4/4554589","CEB/DD4/4545442","CEB/DD4/YR/456878","CEB/DD4/78787845","","no action here","Mouse Events. onmouseover/onmouseout - QCWhen the mouse\'s passes over an element · onmousedown/onmouseup - When pressing/releasing a mouse button 123 onmousedow","no recomendation here","Team E"),
("13","OK","OK","Yes","0.5","0.7","Forword","MCB","63","No","Yes","Yes","Good","CEB/D4/455636","","CEB/D4/78956","","CEB/D4/456322","","CEB/D4/456325","","No actions taken.","Meter accuracy is satisfactory.","no recomondations","Team A"),
("14","OK","OK","Yes","0.456","1.586","Forword","MCB","63","No","Yes","Yes","Good","CEB/DD4/4545454","CEB/DD4/4545457","CEB/DD4/4545478","CEB/DD4/4554589","","","","","no action here","here is no here","no recomendation","Team B"),
("15","OK","OK","Yes","0.456","2.086","Forword","MCB","63","No","Yes","Yes","Good","CEB/DD4/4545454","CEB/DD4/4545457","CEB/DD4/4545478","CEB/DD4/4554589","CEB/DD4/YR/45632","","","","no action here","here is no here records. how ever we hope to develop it.","no recomendation","Team A"),
("16","OK","OK","Yes","1.485","2.000","Forword","MCB","40","No","Yes","Yes","Good","CEB/DD4/7874847","CEB/DD4/457857","CEB/DD4/45678","CEB/DD4/45678","CEB/D4/45457","","","","No action taken here","no remarks here...","No recommendations","Team B"),
("17","OK","OK","Yes","1.4578","2.044","Forword","MCB","32","Yes","Yes","Yes","Good","CEB/D4/475758","CEB/D4/7878","CEB/D4/78787","CEB/D4/78457","","","","","no details","no","no","Team A");



