DROP TABLE IF EXISTS ceb1; 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"); DROP TABLE IF EXISTS ceb2; 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"); DROP TABLE IF EXISTS ceb3; 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","","","","","",""); DROP TABLE IF EXISTS ceb4; 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"); DROP TABLE IF EXISTS user; CREATE TABLE `user` ( `id` mediumint(11) NOT NULL AUTO_INCREMENT, `username` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `active` varchar(150) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; INSERT INTO user VALUES("4","admin","123","active");