INSERT INTO `books` (`ID`, `Name`, `Author`, `Year`, `Category`, `Cite`, `File`, `Date`, `Descreption`, `APA`, `Chicago`, `Cambridge`, `Cover`, `Org`, `downlaods_count`, `citations_count`, `likes`) VALUES
(1705, 'annual reports 2018.pdf', 'ombudsman', '2018', 'Ombudsman |Annual reports', '', '77063', '0000-00-00 00:00:00', 'It is an honour to submit the Twenty Fourth Annual Report of the Office of the Ombudsman\r\nin pursuant to section 127(5) of the Constitution of the Republic of Malawi and section\r\n9 of the Ombudsman Act which covers the period 1 January 2018 to 31 December\r\n2018', 'ombudsman (2018), annual reports 2018.pdf.', 'ombudsman, annual reports 2018.pdf(2018).', 'ombudsman (2018), annual reports 2018.pdf.', '5.png', 'Neytech Solutions', 0, 0, 3),
(1706, 'Civitas Nyasulu vs Mzuzu High Court.pdf', 'Ombudsman ', '2019 ', 'Ombudsman |Determinations', '', '26581', '0000-00-00 00:00:00', 'The Comploinont herein lodged his comploint ogoinst the judiciory (Mzuzu\r\nHigh Court) with our Mzuzu Office through o letler dqted 22nd Jonuory\r\n2013. The essence of the comploint wos deloy by Mzuzu High court to\r\ndeliver o judgement from lOih Februory 2009 todote.\r\n2. We forworded the comploint to the Respondents for their comments on\r\nthe motter but the evidence on the file shows thot there wqs no ony\r\nresponse f rom them. The motter then went f or vorious on spot\r\ninvestigot ion wherethe Respondents undertook to look into the motter but\r\nnothing come out of it.\r\n3. ft wqs then when the mqtter wqs recommended for q Public Inquiry which\r\nf undertook on l1th Februory 2019. fn qttendonce wos the Comploinont\r\nhimself ond the Respondents who were represented by the Hon T\r\nMosoomphqmbe the Deputy Registror qnd His Worship P Chiotcho the\r\nPrincipol Resident Mogistrote.\r\n4. rt wqs the evidence of the complqinqnt thot he storted his oction in 2000\r\nond it wos being heqrd by Mzikomndo J. He stoted thqt he used to be\r\nrepresentedby lowyers but due to numerous odjournments ot the instonce\r\nof thedefendqnt ond the courts, the lowyers qbqndoned him.\r\n5. He f urther stoted thqt the motter wos lqst heord in Februory 2009 ond on\r\nthot doy it wos presided over by chikopo J who af ter the heoring, stoted\r\nthqt the judgement would 6e delivered by Mzikqmondq J within 30 doys\r\nfrom thot dqte.', 'Ombudsman  (2019 ), Civitas Nyasulu vs Mzuzu High Court.pdf.', 'Ombudsman , Civitas Nyasulu vs Mzuzu High Court.pdf(2019 ).', 'Ombudsman  (2019 ), Civitas Nyasulu vs Mzuzu High Court.pdf.', 'cover.png', 'Neytech Solutions', 0, 0, 3),
(1707, 'Determination on an Inquiry into allegations on Irregular Recrutiment of NOCMA Deputy CEO H Buluma_0.pdf', 'Ombudsman ', '2022', 'Ombudsman |Determinations', '', '93274', '0000-00-00 00:00:00', 'The Office of the Ombudsman (OoO), received a written Complaint dated\r\n5\r\nth March 2021, from Mr. Telephorus Chigwenembe, Mr. Mavuto\r\nNdalahoma, Ms. Margaret Sakala and Ms. Christabel Chikusa, (the First\r\nComplainants), alleging workplace injustice, that they suffered at the National\r\nOil Company of Malawi (NOCMA), (the Respondent), through the actions\r\nof NOCMA’s Deputy CEO Ms. Helen Buluma.\r\n1.1.2 The particulars of the Complaint were that:\r\n1.1.2.1 the First Complainants were victimized for participating in a\r\nlegitimate process of raising grievances with the Employer\r\nNOCMA, yet this was provided for in the Conditions of Service;\r\n1.1.2.2 the charge levelled against the First Complainants by NOCMA\r\nwas outrageous and did not reflect the spirit of the act they were\r\ninvolved in;\r\n1.1.2.3 by suspending the First Complainants and writing an email to all\r\nstaff, the Deputy CEO, Ms. Buluma, had instilled undue fear in\r\nemployees to prevent them from raising grievances with their\r\nEmployer; ', 'Ombudsman  (2022), Determination on an Inquiry into allegations on Irregular Recrutiment of NOCMA Deputy CEO H Buluma_0.pdf.', 'Ombudsman , Determination on an Inquiry into allegations on Irregular Recrutiment of NOCMA Deputy CEO H Buluma_0.pdf(2022).', 'Ombudsman  (2022), Determination on an Inquiry into allegations on Irregular Recrutiment of NOCMA Deputy CEO H Buluma_0.pdf.', 'cover.png', 'Neytech Solutions', 0, 0, 3),
(1708, 'Annual Report 2020.pdf', 'ombudsman', '2020', 'Ombudsman |Annual reports', '', '39450', '0000-00-00 00:00:00', 'It is my honour to submit the Twenty Sixth Annual Report of the Office of the Ombudsman\r\nin pursuant to Section 127(5) of the Constitution of the Republic of Malawi and Section 9\r\nof the Ombudsman Act which covers the period 1 January 2020 to 31 December 2020.\r\nThe report seeks to provide an account of how my Office faired in implementing its\r\nConstitutional mandate and specific commitments of the year under review while\r\ncapturing our key promises for the year ahead.', 'ombudsman (2020), Annual Report 2020.pdf.', 'ombudsman, Annual Report 2020.pdf(2020).', 'ombudsman (2020), Annual Report 2020.pdf.', '5.png', 'Neytech Solutions', 0, 0, 3),
(1709, 'Douglas Zimba and Others vs Malawi Electoral Commission.pdf', 'Ombudsman ', '', 'Ombudsman |Determinations', '', '85320', '0000-00-00 00:00:00', 'The Complqinont lodged this cloim on 26th Moy, 2010 on his own behqlf ond on\r\nbeholf of Mr. B. Sofiyono, Mr F. Bokqli ond Mr. D. Mbero ogoinst the\r\nRespondent, Molqwi Electorql Commission (MEC) cloiming unpoid wages. The\r\nmotter wqs recommended for q public fnguiry which took ploce on 25th\r\nNovember, 20t9. The Complqinonts were represenfed by Douglos M. Zimbo\r\nqnd the Respondent wos represenled by their legol counsel Mr. Dovid M.\r\nBondo.\r\nfn his sworn evidence the Comploinont stqted thqt MEC engoged them for 38\r\ndoys os clerks responsiblefor receiving ond distributing election moteriols in\r\nthe Moy 2009 elections. At the end of the exercise the Comploinonts were\r\noffered K1000 yei their colleogues were given K3000 per doy. The\r\nComploinonts refused to receive the K1000 ond up to dqte they hove not 6een\r\npoid onything', 'Ombudsman  (), Douglas Zimba and Others vs Malawi Electoral Commission.pdf.', 'Ombudsman , Douglas Zimba and Others vs Malawi Electoral Commission.pdf().', 'Ombudsman  (), Douglas Zimba and Others vs Malawi Electoral Commission.pdf.', 'cover.png', 'Neytech Solutions', 0, 0, 3),
(1710, 'Dr. Clement Chaiwaya vs National Assembly.pdf', 'Ombudsman ', '2021', 'Ombudsman |Determinations', '', '47803', '0000-00-00 00:00:00', 'We received o complqint on 161n February,202l f rom the Comploinqnt olleging\r\nthot the Respondent, Notionol Assembly foiled to process the chonge of the\r\ntitle of his off iciol motor vehicle from the Government of Molqwi to his nqme.\r\nqfler he hod poid the purchcse price,\r\nUpon receipt of the comploint, we conducted investigotions qnd estoblished thqt\r\nthe Respondent hod received the funds fon the purchose of fhe cor. We\r\nIherefore, instructed the Respondent to process the poyment by tronsferring\r\nthe moneys to Treosuny for issuing of the generol receipt ond then lhereofter\r\ncommence the chonge of ownership.\r\nAfler a few months we we?e informed thqt the money hod been tronsferred Io\r\nTreosury however, chonge of ownership of the vehicle still hod not 6een\r\nprocessed, Looking ot the grovity of the mqtter qnd deodlock we hod reoched I\r\ndecided to set it down for inquiry which took ploce on 2Bth May,2O2t.\r\nIn the inguiry the Comploinont testif ied thqt he storted his politicol cqreer in\r\n2000 qnd in 2OL4 he ossumed the position of the second Deputy Speaker in fhe\r\n2014 to 2019 politicol colendor, He stoted thot he retired in 2Oi9 qnd thot\r\noont of his conditions of service wos thot he could buv his off iciql vehicle. As\r\nsuch when he wos being bought o vehicle,he mode specificotions os to whqt kind\r\nof cor he required, by requesting qn outomqtic vehicle so thqt he could modify it\r\nto coter for his disobility.\r\n', 'Ombudsman  (2021), Dr. Clement Chaiwaya vs National Assembly.pdf.', 'Ombudsman , Dr. Clement Chaiwaya vs National Assembly.pdf(2021).', 'Ombudsman  (2021), Dr. Clement Chaiwaya vs National Assembly.pdf.', 'cover.png', 'Neytech Solutions', 0, 0, 3),
(1711, 'Emmanuel Silungwe vs Ministry of Labour.pdf', 'Ombudsman ', '2019 ', 'Ombudsman |Determinations', '', '61530', '0000-00-00 00:00:00', 'The Comploinqnt lodged his comploint with our officethrough aletter doted\r\nlOth Moy, 2O1O cloiming unfoir dismissol. He alleged thot he wos dismissed\r\nfrom employment on chorges thot he wos ocguitted on.\r\n2. fnvestigotions foiled to resolve the mqtter ond it wos recommended f or public\r\nrnguiry which first took ploce on !4rh December, 20t7. The Comploinont\r\nrepresented himself ond the Respondent wqs represented by the Accountont\r\nGenerql.\r\n3. In his sworn evidence the Comploinqnt stoted thot he wos employed in 1997\r\nos occounts ossistont. fn August 1998 he wos orrested on suspicion thot he\r\nwos involved tn o robbery of his work ploce. He wos loter on ocquitted ond\r\ncleored of qll his chorges ot Lingodzi Police Stqtion. When he wenl bock to\r\nwork he wos osked to write o report obout the incident ond thenhe wqs told\r\nto resume work but he wos tronsferred to o different deportment', 'Ombudsman  (2019 ), Emmanuel Silungwe vs Ministry of Labour.pdf.', 'Ombudsman , Emmanuel Silungwe vs Ministry of Labour.pdf(2019 ).', 'Ombudsman  (2019 ), Emmanuel Silungwe vs Ministry of Labour.pdf.', 'cover.png', 'Neytech Solutions', 0, 0, 3),
(1712, 'Ezekiel Mtambo vs Ministry of Health.pdf', 'Ombudsman ', '2019 ', 'Ombudsman |Determinations', '', '19768', '0000-00-00 00:00:00', 'he Comploinont lodged this cloim agoinst the Respondents Ministry of Heolth\r\ncloiming solary orreors. The letler of comploint wos received by our Mzuzu office\r\non 2nd Februory, 2008.\r\nZ. When the motten wos ref erred to the Respondents the Chitipo District Heolth\r\nOfficerwrote the Respondent Ministry through their letter doted 25th Septernbe.r,\r\n2009 exploining how the orreors orose ond how fqr the Ministry hod gone towords\r\nthe resolution of the mqtter.\r\n3. The evidence on the file suggests thot the Chitipo District Heqlth Officer wos not\r\nforthcoming with response ofter the office hod conducted severol on spot\r\ninvestigotions. Thus when the motter wos recommended for inguiry which took ploce\r\non l1rh Februory, l}tg. fn ottendonce for the Respondents wos Mr. Kotontho the\r\nChief Humon Resource Monogement Officer, Agness Monongo the Principol Humon\r\nResource Monagement Officer ond Sophie Mloko the Senior Human Resource\r\nMonogement Officer.\r\n4. fn his evidence the Comploinont stoted thot he wos employed by the Respondents in\r\nFebruory, 1990 os o wotchmon ot Kopendo Heolth Centre in Chitipo district. He tuos\r\nloter on promoted to Grode t.\r\n', 'Ombudsman  (2019 ), Ezekiel Mtambo vs Ministry of Health.pdf.', 'Ombudsman , Ezekiel Mtambo vs Ministry of Health.pdf(2019 ).', 'Ombudsman  (2019 ), Ezekiel Mtambo vs Ministry of Health.pdf.', 'cover.png', 'Neytech Solutions', 0, 0, 3),
(1713, 'Annual Report 2017', 'ombudsman', '2017', 'Ombudsman |Annual reports', '', '50460', '0000-00-00 00:00:00', '͙I have the honour to present the Twenty-Third Annual Report of the Ofï€ce of\r\nthe Ombudsman for the period January, 2017 to December, 2017.', 'ombudsman (2017), Annual Report 2017.', 'ombudsman, Annual Report 2017(2017).', 'ombudsman (2017), Annual Report 2017.', '5.png', 'Neytech Solutions', 0, 0, 3),
(1714, 'Harry Baluti vs Phalombe District Council and Mulanje District Council.pdf', 'Ombudsman ', '2022', 'Ombudsman |Determinations', '', '95774', '0000-00-00 00:00:00', 'The Complainant lodged the complaint on behalf of his sick Uncle\r\nthrough a letter dated 22\"d September, 2008. He was claimrng for unpaid\r\npension dues of his Uncle Mr. JJ Saopa who used to work for the\r\nRespondent, Mulanie District Council.\r\n1.2 The evidence in the file shows that the Respondents were not responsive\r\nwith respect to providing evidence and therefore the investigations that\r\nthe Office of the Ombudsman comlnenced on this matter failed to resolvc\r\nthe matter. The matter was thus recofiIlnended for Public Inquiry which\r\ntook place on 1\" March, 2022.', 'Ombudsman  (2022), Harry Baluti vs Phalombe District Council and Mulanje District Council.pdf.', 'Ombudsman , Harry Baluti vs Phalombe District Council and Mulanje District Council.pdf(2022).', 'Ombudsman  (2022), Harry Baluti vs Phalombe District Council and Mulanje District Council.pdf.', 'cover.png', 'Neytech Solutions', 0, 0, 3),
(1715, 'Felix Ngoma vs Ministry of Lands.pdf', 'Ombudsman ', '2020', 'Ombudsman |Determinations', '', '75825', '0000-00-00 00:00:00', 'The Complqinont lodged o comploint in my office through o letter doted 7r^\r\nJune, 2017 in which he olleged unfoir treqtment by Nkhotoboy District Council\r\nqnd Ministry of Lqnds in the monner in which they hondled his comploint qs\r\nregords lond dispurebetweenherself qnd one Mrs Chqrity Modulo.\r\nThe mqtter wos set down for o public inquiry which took ploce on 6th August,\r\n2Ot8 where Ministry of Londs Off iciols were in qttendonce. After the inguiry\r\nI directed thot there should be site visit qnd thqt the locol leodership of the\r\no?es, Ministry of Londs, representotives f rom the Office of the Ombudsmqn\r\nond the officiols from Nkhotoboy District Council should be present. This\r\nindeed took ploce on lOth August, 2018.\r\n', 'Ombudsman  (2020), Felix Ngoma vs Ministry of Lands.pdf.', 'Ombudsman , Felix Ngoma vs Ministry of Lands.pdf(2020).', 'Ombudsman  (2020), Felix Ngoma vs Ministry of Lands.pdf.', 'cover.png', 'Neytech Solutions', 0, 0, 3),
(1716, 'HARRY BALUTI PHALOMBEMULANJE DC.PDF', 'Ombudsman ', '2022', 'Ombudsman |Determinations', '', '50062', '0000-00-00 00:00:00', 'The Complainant lodged the complaint on behalf of his sick Uncle\r\nthrough a letter dated 22\"d September, 2008. He was claimrng for unpaid\r\npension dues of his Uncle Mr. JJ Saopa who used to work for the\r\nRespondent, Mulanie District Council.\r\n1.2 The evidence in the file shows that the Respondents were not responsive\r\nwith respect to providing evidence and therefore the investigations that\r\nthe Office of the Ombudsman comlnenced on this matter failed to resolvc\r\nthe matter. The matter was thus recofiIlnended for Public Inquiry which\r\ntook place on 1\" March, 2022.', 'Ombudsman  (2022), HARRY BALUTI PHALOMBEMULANJE DC.PDF.', 'Ombudsman , HARRY BALUTI PHALOMBEMULANJE DC.PDF(2022).', 'Ombudsman  (2022), HARRY BALUTI PHALOMBEMULANJE DC.PDF.', 'cover.png', 'Neytech Solutions', 0, 0, 3),
(1717, 'Hilary Malunga vs Thyolo District Council.pdf', 'Ombudsman ', '2022', 'Ombudsman |Determinations', '', '21865', '0000-00-00 00:00:00', ' The compratnant, Mr. Hilary Malunga, lodged a complaint with the\r\noffice of the ombudsman (ooo), on 29rh May, 201.3, against the\r\nRespondent, Ministry of Education, claiming unpaid salaries for a period\r\nof 8 months, from February 2003 to September 2003.\r\n1.2 The matter was not resolved during Investigations, as such, it was set\r\ndown for a Public Inquiry on 2\"d a4arch, 2022, in order for me to hear\r\nfrom both patties and\r\n^trrve at a balanced and fair conclusion of the\r\nmaffef.\r\n1,.3 Mr. Victor Malunga testified on oath and stated that he v/as representing\r\nhis late father Mt. Hilary Malunga who passed away on 30n Ap.il, 2020.\r\nMr. Hilary Malunga was teaching at I(have School in Thyolo District,\r\nfrom 2003 until 2070, on a month to month contract basis on Grade PT4.\r\nHe worked for 8 months from February 2003 up to Septemb er. 2003,\r\nwithout receiving his salary. His late father was pursuing this issue but\r\ndespite all his efforts he was never assisted. 7hen his father died in April\r\n2020, he continued to prrsue the matter with the Thyolo DC but the\r\nmatter was not resolved.', 'Ombudsman  (2022), Hilary Malunga vs Thyolo District Council.pdf.', 'Ombudsman , Hilary Malunga vs Thyolo District Council.pdf(2022).', 'Ombudsman  (2022), Hilary Malunga vs Thyolo District Council.pdf.', 'cover.png', 'Neytech Solutions', 0, 0, 3),
(1718, 'KWASHILA MULENGA VS MINISTRY OF LANDS.pdf', 'Ombudsman ', '2023', 'Ombudsman |Determinations', '', '55999', '0000-00-00 00:00:00', 'The complainant lodged a complaint with the Office of the OmbusOmbudsman through a letter dated 13th january, 2020, alleging unfair treatment by the Respondent. she claimed that she applied for a plot from ministry of lands(the ministry), and in 2011, she was allocated a plot number 17/475 for a total value of K369, 299.00. she paid a sum of K150, 000.00 to the ministry as part payment  for the plot. However, later n in 2015, she was informed by the ministry that the plot was allocated to another person without any warning to her.', 'Ombudsman  (2023), KWASHILA MULENGA VS MINISTRY OF LANDS.pdf.', 'Ombudsman , KWASHILA MULENGA VS MINISTRY OF LANDS.pdf(2023).', 'Ombudsman  (2023), KWASHILA MULENGA VS MINISTRY OF LANDS.pdf.', 'cover.png', 'Neytech Solutions', 0, 0, 3),
(1719, 'Jameson Bwanali vs Ministry of Transport and Ministry of Water and Irrigation.pdf', 'Ombudsman ', '2018', 'Ombudsman |Determinations', '', '60404', '0000-00-00 00:00:00', 'The Comploinont storted working f or the Ministry of Works in 1957 os o Woter\r\nPlont Operotor. However the documentqtion qvqilqble shows thot he storted wonk\r\nin t960. The Comploinqnt does not hove ony evidence to show thqt he stqrted\r\nworking in 1957.\r\nHe wos arrested in 1972 on qllegotions of fuel misoppropriqtion but wos loter\r\nocguitted ond reinstqted in his job.\r\nHe wos orrested ogoin in 1974 on suspicion thqt he wos in possession of seditious\r\nmqteriql fnom his fqther who wos working in Tonzqniq qnd wos releqsedinIgT5.\r\nAfter the estoblishment of the Nqtionol Compensotion Tribunol, he lodged his\r\ncomploint there ond wos given on interim poyment of MKzo, OO0.OO qs\r\ncompensotion for unlowful detention.', 'Ombudsman  (2018), Jameson Bwanali vs Ministry of Transport and Ministry of Water and Irrigation.pdf.', 'Ombudsman , Jameson Bwanali vs Ministry of Transport and Ministry of Water and Irrigation.pdf(2018).', 'Ombudsman  (2018), Jameson Bwanali vs Ministry of Transport and Ministry of Water and Irrigation.pdf.', 'cover.png', 'Neytech Solutions', 0, 0, 3),
(1720, 'NOCMA DEPUTY CEO IRREGULAR RECRUITMENT.pdf 1 / 64 100%', 'Ombudsman ', '2022', 'Ombudsman |Determinations', '', '27862', '0000-00-00 00:00:00', '1 The Office of the Ombudsman (OoO), received a written Complaint dated\r\n5\r\nth March 2021, from Mr. Telephorus Chigwenembe, Mr. Mavuto\r\nNdalahoma, Ms. Margaret Sakala and Ms. Christabel Chikusa, (the First\r\nComplainants), alleging workplace injustice, that they suffered at the National\r\nOil Company of Malawi (NOCMA), (the Respondent), through the actions\r\nof NOCMA’s Deputy CEO Ms. Helen Buluma.\r\n1.1.2 The particulars of the Complaint were that:\r\n1.1.2.1 the First Complainants were victimized for participating in a\r\nlegitimate process of raising grievances with the Employer\r\nNOCMA, yet this was provided for in the Conditions of Service;\r\n1.1.2.2 the charge levelled against the First Complainants by NOCMA\r\nwas outrageous and did not reflect the spirit of the act they were\r\ninvolved in;\r\n1.1.2.3 by suspending the First Complainants and writing an email to all\r\nstaff, the Deputy CEO, Ms. Buluma, had instilled undue fear in\r\nemployees to prevent them from raising grievances with their\r\nEmployer;\r\n1.1.2.4 the manner in which the First Complainants’ case had been\r\nhandled was not in compliance with rules of natural justice, as\r\nthe Deputy CEO played the roles of complainant, judge, as well\r\nas the person against whom the grievances were raised; and,\r\n1.1.2.5 the First Complainants were not heard before being suspended', 'Ombudsman  (2022), NOCMA DEPUTY CEO IRREGULAR RECRUITMENT.pdf 1 / 64 100%.', 'Ombudsman , NOCMA DEPUTY CEO IRREGULAR RECRUITMENT.pdf 1 / 64 100%(2022).', 'Ombudsman  (2022), NOCMA DEPUTY CEO IRREGULAR RECRUITMENT.pdf 1 / 64 100%.', 'cover.png', 'Neytech Solutions', 0, 0, 3),
(1721, 'Maumbo vs Ministry of Health.pdf', 'Ombudsman ', '2021', 'Ombudsman |Determinations', '', '12615', '0000-00-00 00:00:00', 'on 24th Aprtl, zorg r mqde o derernrnqtion in this motter ond in the determination, f issue of the suff icienc y of the K4000 compensq to the Comploinont followi ng the omputotion of he\r\nThe issue thqt lo hospitol in 1981\r\nher determinotion wqs whether considering the injury thqt the comproinont,, iough kr suff ered qt birth in 1981, o compensqtion of K4OOO wos reosonoble. r further positioned then thqt my office wiil qsk Legar Aid Burequ for guidcnce on f he sqme since os qn off ice we may not hove f he\r\nbqck\r\ncorrect expertise on the some. r hqd expected Legar Aid to write to us by 3Oth June ZOlg.', 'Ombudsman  (2021), Maumbo vs Ministry of Health.pdf.', 'Ombudsman , Maumbo vs Ministry of Health.pdf(2021).', 'Ombudsman  (2021), Maumbo vs Ministry of Health.pdf.', 'cover.png', 'Neytech Solutions', 0, 0, 3),
(1722, 'Langford Mphande and Others vs Department of Forestry and Ministry of Energy.pdf', 'Ombudsman ', '2018', 'Ombudsman |Determinations', '', '14851', '0000-00-00 00:00:00', 'My off ice received o number of compleints agoinst deportment of Forestry on\r\ndif f erent dotes f rom o number of their employees, some of which hove since\r\nretired ond other ore still working. These clqims were f iled seponotely.\r\nAowever, ofter noting the similority in the cloims, I resolved to conduct q\r\npublic inquiry f or qll the comploints of some time ond Io give one determinotion\r\non the some. The comploints hove been in my of f ice f or some time ond on most\r\nof them there is correspondencebelween my office ond the deportment os\r\nwell os their line ministry. One sod foct is thot despite oll the interventions\r\nsuch os reminders ond on spot investigotions by my office,none of the coses\r\nhovebeen resolved. Therehavebeen q lot of undertokings to moke poyment\r\nbut hove not 6een fulfilled', 'Ombudsman  (2018), Langford Mphande and Others vs Department of Forestry and Ministry of Energy.pdf.', 'Ombudsman , Langford Mphande and Others vs Department of Forestry and Ministry of Energy.pdf(2018).', 'Ombudsman  (2018), Langford Mphande and Others vs Department of Forestry and Ministry of Energy.pdf.', 'cover.png', 'Neytech Solutions', 0, 0, 3),
(1723, 'MWANGUPIRI SAMUEL NGOSI VS ANTI-CORRUPTION BUREAU.pdf', 'Ombudsman ', '2023', 'Ombudsman |Determinations', '', '90467', '0000-00-00 00:00:00', 'The complainant , Mr. mwangupiri Ngosi lodged a complaint with the office of the Ombudsman (OoO), on 1st February 2021, against the Respondent, the Anticorruption Bureau (ACB), alleging that the REspondent unfairly treated him by failing to pay him', 'Ombudsman  (2023), MWANGUPIRI SAMUEL NGOSI VS ANTI-CORRUPTION BUREAU.pdf.', 'Ombudsman , MWANGUPIRI SAMUEL NGOSI VS ANTI-CORRUPTION BUREAU.pdf(2023).', 'Ombudsman  (2023), MWANGUPIRI SAMUEL NGOSI VS ANTI-CORRUPTION BUREAU.pdf.', 'cover.png', 'Neytech Solutions', 0, 0, 3),
(1725, 'Owen Singini vs Ministry of Transport.pdf', 'Ombudsman ', '2020', 'Ombudsman |Determinations', '', '52679', '0000-00-00 00:00:00', 'The comploinont lodged his cloim through o letter doted 5rh July, 2011\r\nalleging unjustifioble grotuity deductions. Tnvestigotions foiled to resolve\r\nthe motter ond it wos recommended f or o public inguiry which wos held on\r\n25th November, 2019. The comploinont wos present ond the Respondent\r\nwos represented by Mn George Mhongo, the Director of Morine\r\nDeportment.\r\nThe evidence shows thot the Comploinont wqs qs\r\nworking os Assistont Director of Morine Servtces\r\nof 29rh August, 2008\r\n(sofety) Deportment\r\nwithin the Ministry of Trcnsport.\r\n3. There seemed to hove been a crisis ot Molowi Loke Service Compony (MLS)\r\nos q result of collopse of the concession agreement belween Government\r\nond the Concessionaire. A steerrng committee composed of dtfferent\r\ngove?nment institutions wos constituted to hondle the process of full tokeover of the compony by Mqlowi Government pending identificotion of new\r\nconcessionoire.\r\n\r\n', 'Ombudsman  (2020), Owen Singini vs Ministry of Transport.pdf.', 'Ombudsman , Owen Singini vs Ministry of Transport.pdf(2020).', 'Ombudsman  (2020), Owen Singini vs Ministry of Transport.pdf.', 'cover.png', 'Neytech Solutions', 0, 0, 3),
(1727, 'Central Medical Stores Trust Report', 'ombudsman', '2021', 'Ombudsman |Investigations', '', '15499', '0000-00-00 00:00:00', 'This is one of the reports following investigations in various parastatals after\r\nreceiving complaints of irregular and nepotistic recruitments, unfair treatment and\r\nabuse of power and public resources among others. ', 'ombudsman (2021), Central Medical Stores Trust Report.', 'ombudsman, Central Medical Stores Trust Report(2021).', 'ombudsman (2021), Central Medical Stores Trust Report.', '5.png', 'Neytech Solutions', 0, 0, 3),
(1728, 'CMST Report Final Version 27 July 2023', 'ombudsman', '2023', 'Ombudsman |Investigations', '', '26755', '0000-00-00 00:00:00', 'The Office of the Ombudsman (OoO), received a Complaint dated\r\n18th July, 2022, from a concerned citizen (Complainant), alleging that\r\nthe Central Medical Stores Trust (CMST)’s Management had planned\r\nto conduct a public sale of its obsolete equipment, including motor\r\nvehicles, without following due procedures. Further, that it was the\r\nintention of the CMST’s management through an identified\r\nAuctioneer, to unduly influence the process. The particulars of the\r\nComplaint are as follows:', 'ombudsman (2023), CMST Report Final Version 27 July 2023.', 'ombudsman, CMST Report Final Version 27 July 2023(2023).', 'ombudsman (2023), CMST Report Final Version 27 July 2023.', '5.png', 'Neytech Solutions', 0, 0, 3),
(1729, 'Rose Kamchacha vs Ministry of Home Affairs.pdf', 'Ombudsman ', '2017', 'Ombudsman |Determinations', '', '84027', '0000-00-00 00:00:00', 'The Comploinont lodged o clqim with our Lllongwe office through o letler\r\ndoted I2r^ October,20!6. rn her letrer, she alleged thqt she wos unfoirly\r\ntreoted by the Respondent allegedly becouse of their ref usql to ollow her\r\n90 on leave ond olso their foilure to communicote lo her thot her opplicotion\r\nto occumulote leave hos been relected.\r\nThe complqint letter wqs ref erred to the Respondent for Jheir comments.\r\nSeverql communicotions were mode ielween the Office, the Respondent\r\nqnd the Comploinont but both porties did not ogree qs such the motter wcls\r\nrecommended f or o public inguiry which took ploce on 23rd November ,zO!7.\r\nThe Respondent wqs represenled by the Assistont Humon Resource\r\nOfficer Mr. Uthon Mkqndqwire.\r\nThe evidence indicotes thqt the Comploinont joined the civil service os on\r\nAccounts clerk in 1978, Tn ?004, she wos posted to the Deportment of\r\nfmmigrotion from PVHO.', 'Ombudsman  (2017), Rose Kamchacha vs Ministry of Home Affairs.pdf.', 'Ombudsman , Rose Kamchacha vs Ministry of Home Affairs.pdf(2017).', 'Ombudsman  (2017), Rose Kamchacha vs Ministry of Home Affairs.pdf.', 'cover.png', 'Neytech Solutions', 0, 0, 3),
(1730, 'VANACIO CHIBAKHA AND DOMINIC CONERIOUS CHIWAULA VS NTCHEU DC AND ESCOM.pdf', 'Ombudsman ', '2023', 'Ombudsman |Determinations', '', '45471', '0000-00-00 00:00:00', 'The office of the ombudsman (OoO) received a complainant, alleging ', 'Ombudsman  (2023), VANACIO CHIBAKHA AND DOMINIC CONERIOUS CHIWAULA VS NTCHEU DC AND ESCOM.pdf.', 'Ombudsman , VANACIO CHIBAKHA AND DOMINIC CONERIOUS CHIWAULA VS NTCHEU DC AND ESCOM.pdf(2023).', 'Ombudsman  (2023), VANACIO CHIBAKHA AND DOMINIC CONERIOUS CHIWAULA VS NTCHEU DC AND ESCOM.pdf.', 'cover.png', 'Neytech Solutions', 0, 0, 3),
(1731, 'Willard John vs Ministry of Gender.pdf', 'Ombudsman ', '2020', 'Ombudsman |Determinations', '', '85303', '0000-00-00 00:00:00', 'The Complainont lodged o comploint with my office cloiming unpoid ollowonces\r\nowed to him by the Respondent, Ministry of Gender, Children & Community.\r\nUpon receipl of the soid comploint, the office of the Ombudsmon ref erred it\r\nto the Respondent for their input. Our efforts proved to be futile os our\r\ninvestigotions culminoted in o deqdlock thus, the motter wos set down for\r\ninguiry held on 26th November, 20L9.\r\nfn the inquiry the Comploinqnt testified thot he wos employedby Government\r\nqs o cook qnd wos working in vorious gove?nment Ministries. fn 2008 he wqs\r\nworking ot Mpembo Boys Home ond whilst there he wos invited to the Stqff\r\nroom by Mr. Logo ond Mr. Nqmqsqni to testify on ollegotions levelled ogoinst\r\na teacher by the nqme of Mrs. Mwqfulirwq, who wos being occused thot she\r\nwos hoving sexuol relqtionships with boys whom she wos teoching. He stoted\r\nthot in his evidence he told them thot he did not know onything concerning\r\nthe motter qnd the occused teacher wos shocked upon heoringthe ollegotions\r\nlevelled ogoinst her qnd qs q result of shock she collopsed ond died.', 'Ombudsman  (2020), Willard John vs Ministry of Gender.pdf.', 'Ombudsman , Willard John vs Ministry of Gender.pdf(2020).', 'Ombudsman  (2020), Willard John vs Ministry of Gender.pdf.', 'cover.png', 'Neytech Solutions', 0, 0, 3),
(1732, 'Ombudsman Act.pdf', 'Ombudsman ', '1996', 'Ombudsman |Legislation', '', '78919', '0000-00-00 00:00:00', '[Ch0307s5]5. Duties and functions of the Ombudsman\r\n(1) Subject to the Constitution, the Ombudsman shall inquire into and investigate in\r\naccordance with the provisions of this Act, and take such action or steps as may be prescribed by\r\nthis Act on any request or complaint in any instance or matter laid before the Ombudsman in\r\naccordance with section 7 (1) or (2), and concerning any alleged instance or matter of abuse of\r\npower or unfair treatment of any person by an official in the employ of any organ of\r\nGovernment, or manifest injustice or conduct by such official which would properly be regarded\r\nas oppressive or unfair in an open and democratic society.\r\n(2) Without derogating from the provisions of subsection (1), any request or complaint in\r\nrespect of any instance or matter referred to in that subsection may include any instance or matter\r\nin respect of which it is alleged—\r\n(a) that any decision or recommendation taken or made by or under the authority of\r\nany organ of Government or any act or omission of such organ is unreasonable, unjust or unfair,\r\nor is based on any practice which may be deemed as such;\r\n(b) that the powers, duties or functions which vest in any organ of Government are\r\nexercised or performed in a manner which is unreasonable, unjust or unfair.', 'Ombudsman  (1996), Ombudsman Act.pdf.', 'Ombudsman , Ombudsman Act.pdf(1996).', 'Ombudsman  (1996), Ombudsman Act.pdf.', 'cover.png', 'Neytech Solutions', 0, 0, 3),
(1733, 'Constitution of Malawi.pdf', 'Ombudsman ', '2006', 'Ombudsman |Legislation', '', '41338', '0000-00-00 00:00:00', 'There shall be no derogation, restrictions or limitation with regard to\r\na. the right to life;\r\nb. the prohibition of torture and cruel, inhuman or degrading treatment\r\nor punishment;\r\nc. the prohibition of genocide;\r\nd. the prohibition of slavery, the slave trade and slave-like practices;\r\ne. the prohibition of imprisonment for failure to meet contractual\r\nobligations;\r\nf. the prohibition on retrospective criminalization and the retrospective\r\nimposition of greater penalties for criminal acts;\r\ng. the right to equality and recognition before the law;\r\nh. the right to freedom of conscience, belief, thought and religion and to\r\nacademic freedom; or', 'Ombudsman  (2006), Constitution of Malawi.pdf.', 'Ombudsman , Constitution of Malawi.pdf(2006).', 'Ombudsman  (2006), Constitution of Malawi.pdf.', 'cover.png', 'Neytech Solutions', 0, 0, 3),
(1734, 'Office of the Ombudsman Strategic Plan 2016 - 2021.pdf', 'Ombudsman ', '2021', 'Ombudsman |Other publications', '', '98728', '0000-00-00 00:00:00', 'The Government of Malawi is keen to improve public\r\nservice delivery in all its institutions with the ultimate\r\nobjective of fostering development of the country. At\r\nthe centre of safeguarding public service delivery,\r\nis the Office of the Ombudsman (OoO). The office is\r\nmandated to ensure that all public institutions work\r\neffectively, efficiently and adhere to the democratic\r\nprinciples of openness, fairness, responsiveness and\r\naccountability. Administratively, performance contract\r\nprogramme puts the office as a last resort of public\r\ncomplaints resolutions. The last strategic plan was a very crucial tool towards\r\nthese envisaged roles. However, due to many other factors, not all that was\r\nplanned was achieved during the period of the plan.\r\nThe majority of complaints received and investigated continued to be labour\r\nrelated. This resulted in cementing a misconception of the office as being a labour\r\ncomplaint handling institution and its underutilisation. In the next five years, the\r\noffice will strive to provide high quality and timely service to members of the\r\npublic. We intend to fully utilise our unique legal mandate which encompasses\r\nmonitoring of public service delivery alongside the public sector reform agenda.\r\nThe main focus will be to reposition the OoO and make it more relevant to the\r\npresent needs of the public.', 'Ombudsman  (2021), Office of the Ombudsman Strategic Plan 2016 - 2021.pdf.', 'Ombudsman , Office of the Ombudsman Strategic Plan 2016 - 2021.pdf(2021).', 'Ombudsman  (2021), Office of the Ombudsman Strategic Plan 2016 - 2021.pdf.', 'cover.png', 'Neytech Solutions', 0, 0, 3),
(1735, '2022-2027 Strategic Plan.pdf', 'Ombudsman ', '2022', 'Ombudsman |Other publications', '', '45856', '0000-00-00 00:00:00', 'We treat all people with courtesy and dignity as well as act\r\nreasonably, impartially, just, unbiased and in an equitable\r\nmanner. ', 'Ombudsman  (2022), 2022-2027 Strategic Plan.pdf.', 'Ombudsman , 2022-2027 Strategic Plan.pdf(2022).', 'Ombudsman  (2022), 2022-2027 Strategic Plan.pdf.', 'cover.png', 'Neytech Solutions', 0, 0, 3),
(1736, 'EXTERNAL VACANCIES FINAL 31.08.2023.pdf', 'Ombudsman ', '2023', 'Ombudsman |Other publications', '', '47055', '0000-00-00 00:00:00', 'The Office of the Ombudsman is a public body established under the Republic of Malawi\r\nConstitution. Section 123 of the Constitution accords the Office of the Ombudsman the\r\nmandate to investigate any and all cases where it is alleged that a person has suffered\r\nan injustice and it does not appear that there is any remedy reasonably available by way\r\nof proceedings in a court or by way of appeal from a court or where there is no other\r\npracticable remedy.\r\nThe Office of the Ombudsman is inviting applications from suitably qualified persons to fill\r\nthe following vacant positions', 'Ombudsman  (2023), EXTERNAL VACANCIES FINAL 31.08.2023.pdf.', 'Ombudsman , EXTERNAL VACANCIES FINAL 31.08.2023.pdf(2023).', 'Ombudsman  (2023), EXTERNAL VACANCIES FINAL 31.08.2023.pdf.', 'cover.png', 'Neytech Solutions', 0, 0, 3),
(1739, 'Institutional Anarchy', 'ombudsman', '2020', 'Ombudsman |Investigations', '', '31005', '0000-00-00 00:00:00', 'The Office of the Ombudsman (OoO) received a complaint on 9th September, 2020\r\nalleging irregular, nepotistic, discriminatory and fraudulent recruitment of Chief\r\nExecutive Officer (CEO) of Malawi Energy Regulatory Authority (MERA) and some\r\nother staff at the Authority. The details of the allegations are as follows:', 'ombudsman (2020), Institutional Anarchy.', 'ombudsman, Institutional Anarchy(2020).', 'ombudsman (2020), Institutional Anarchy.', '5.png', 'Neytech Solutions', 0, 0, 3),
(1740, 'Malawis Unhealed Wounds', 'ombudsman', '2017', 'Ombudsman |Investigations', '', '66962', '0000-00-00 00:00:00', '“Justice will not fail, though wickedness appears strong, and has on its side the armies\r\nand thrones of power, the riches and the glory of the world, and though poor men\r\ncrouch down in despair. Justice will not fail and perish out from the world of men, nor\r\nwill what is really wrong and contrary to God’s real law of justice continually endure.\r\nâ€ Anonymous', 'ombudsman (2017), Malawis Unhealed Wounds.', 'ombudsman, Malawis Unhealed Wounds(2017).', 'ombudsman (2017), Malawis Unhealed Wounds.', '5.png', 'Neytech Solutions', 0, 0, 3),
(1742, '“We are not to simply bandage the wounds of victims beneath the wheels of injustice. We have to drive a spoke into the wheels itself.â€ Dietrich Bonhoeffer', 'ombudsman', '2020', 'Ombudsman |Investigations', '', '22087', '0000-00-00 00:00:00', '1 This Report presents the findings of a Systemic Investigation on the\r\nutilisation of the COVID-19 Response funds by the 5 District Councils of\r\nPhalombe, Zomba, Ntcheu, Lilongwe and Karonga. The Investigation\r\nfollowed on an earlier Investigation that the OoO carried out in 2020.\r\n', 'ombudsman (2020), “We are not to simply bandage the wounds of victims beneath the wheels of injustice. We have to drive a spoke into the wheels itself.â€ Dietrich Bonhoeffer.', 'ombudsman, “We are not to simply bandage the wounds of victims beneath the wheels of injustice. We have to drive a spoke into the wheels itself.â€ Dietrich Bonhoeffer(2020).', 'ombudsman (2020), “We are not to simply bandage the wounds of victims beneath the wheels of injustice. We have to drive a spoke into the wheels itself.â€ Dietrich Bonhoeffer.', '5.png', 'Neytech Solutions', 0, 0, 3),
(1743, 'The Present Toiling The Future Overburdened', 'ombudsman', '2016', 'Ombudsman |Investigations', '', '70972', '0000-00-00 00:00:00', '“The Present Toiling, The Future Overburdenedâ€ is my report as the\r\nOmbudsman of the Republic of Malawi on an investigation into allegations\r\nof maladministration and related irregularities on the purchase and disposal\r\nof the farm machinery under the $50,000,000.00 line of credit from ExportImport Bank of India in 2010. \r\n', 'ombudsman (2016), The Present Toiling The Future Overburdened.', 'ombudsman, The Present Toiling The Future Overburdened(2016).', 'ombudsman (2016), The Present Toiling The Future Overburdened.', '5.png', 'Neytech Solutions', 0, 0, 3),
(1744, 'Upholding the Profession', 'ombudsman', '2021', 'Ombudsman |Investigations', '', '17833', '0000-00-00 00:00:00', '‘Upholding the Profession’ is a report on an investigation that my Office carried out\r\ninto allegations of abuse of power and other acts of maladministration in the procedure\r\nof procuring and engaging South African (SA) lawyers by the former Attorney General\r\n(AG) and Malawi Electoral Commission (MEC).\r\nThe investigation was motivated by a complaint dated 14th April, 2020 lodged with my\r\nOffice by Youth and Society (YAS). The Complaint alleged that the then AG of the\r\nRepublic of Malawi Mr. Kalekeni Kaphale Senior Counsel (SC) committed various acts\r\nof maladministration in the manner in which he procured the services of SA Lawyers\r\nDumisa Buhle Ntsebeza SC and Counsel Elizabeth Makhanani Baloyi-Mere. ', 'ombudsman (2021), Upholding the Profession.', 'ombudsman, Upholding the Profession(2021).', 'ombudsman (2021), Upholding the Profession.', '5.png', 'Neytech Solutions', 0, 0, 3),
(1745, '33rd AU Assembly Dec. February 2020_AUDA-NEPAD.pdf', 'African Union', '2020', 'African Union Publications', '', '47171', '0000-00-00 00:00:00', 'he Assembly,\r\n1. TAKES NOTE WITH APPRECIATION of the Report by the outgoing\r\nChairperson of the NEPAD Heads of State and Government Orientation\r\nCommittee, H.E. Macky Sall, President of the Republic of Senegal;\r\n2. ENDORSES the conclusions and recommendations of the 37th NEPAD HSGOC\r\nSummit;\r\n3. RECALLS that the NEPAD vision and its programme, from inception, has been\r\nan intrinsic part of the African Union System and should remain so, and CALLS\r\nUPON the African Union Commission and AUDA-NEPAD Secretariat to continue\r\nto harmonize their work programmes to prevent duplication of roles;\r\n4. NOTES WITH APPRECIATION the Progress Report presented on behalf of H.E.\r\nMatamela Cyril Ramaphosa, President of the Republic of South Africa as Chair\r\nof the HSGOC High-level Sub-Committee on the Presidential Infrastructure\r\nChampion Initiative (PICI). While commending the Presidential Champions for\r\ntheir commitment, UNDERSCORES the critical need for PICI projects to advance\r\ninter-connectivity among African Countries and sub-regions in order to address\r\ninfrastructure deficits and boost intra-African trade. TAKES NOTE that Financing\r\nin Africa infrastructure reveals a gap of US$90 Billion, thus, impeding the\r\ncontinent’s ability to deliver on critical development objectives. In this regard,\r\nCALLS FOR the implementation of urgent measures aimed at unlocking access\r\nto finance, and REQUESTS AUDA-NEPAD to work closely with the African\r\nDevelopment Bank (AfDB) in order to support the Africa Co-guarantee\r\nPlatform (CGP) in view of increasing the amount of finance available to Africa for\r\nits infrastructure and trade by scaling up risk mitigation;\r\n5. TAKES NOTE of Decision EX.CL/Dec.1063(XXXV) adopting the legal\r\ninstruments of AUDA-NEPAD and NOTES the issues raised by some member\r\nstates of the HSGOC and DECIDES that the principle of non-rotation of the 5\r\ninitiating Member States be retained;\r\n6. FURTHER NOTES Decision Assembly/AU/691(XXXI) nominating the\r\nChairperson of the Commission to Co-Chair the Steering Committee and\r\nDECIDES to replace the Chairperson of the African Union Commission with the\r\nChairperson of the Union;\r\n7. REQUESTS the Commission to amend all relevant AUDA-NEPAD legal\r\ninstruments to include the decisions in paragraphs 5 and 6 above;', 'African Union (2020), 33rd AU Assembly Dec. February 2020_AUDA-NEPAD.pdf.', 'African Union, 33rd AU Assembly Dec. February 2020_AUDA-NEPAD.pdf(2020).', 'African Union (2020), 33rd AU Assembly Dec. February 2020_AUDA-NEPAD.pdf.', '33rd.PNG', 'Neytech Solutions', 0, 0, 3),
(1746, 'African Union Handbook_EN.pdf', 'African Union', '2022', 'African Union Publications', '', '20618', '0000-00-00 00:00:00', 'As Africa continues to strive towards\r\nsustainable development, the need for citizen\r\nengagement and participation in governance\r\nand policy development processes cannot\r\nbe overstated. Citizens are the ultimate\r\nbeneficiaries of government policies, and\r\ntheir active input in policy development and\r\nimplementation processes is critical to ensuring\r\nthe effectiveness, legitimacy, and sustainability\r\nof such policies.\r\nAt the heart of Agenda 2063’s vision for an\r\nintegrated, prosperous, and peaceful Africa, is\r\nthe active participation of its citizens in shaping\r\ntheir future. However, despite the recognition\r\nof the importance of citizen engagement in\r\ngovernance and policy development processes,\r\nefforts to facilitate such engagement have\r\noften been limited and fragmented. Only 19% of\r\nAfricans believe they have a say in their country’s political leadership, while only 28% believe that\r\ntheir government is run for the benefit of all people1\r\n.\r\nThis handbook, therefore, is a timely and relevant resource in support of AU Organs, RECs, and\r\nMember States in developing their capacity to conduct citizen engagement processes much more\r\nconstructively. It offers a comprehensive and practical guide to enhancing citizen engagement\r\nand participation in governance and policy development processes in Africa which is particularly\r\nimportant as we commence the Implementation of the Second Ten Year Implementation Plan of the\r\nAgenda 2063 in line with regional and National Development Plans.\r\nDrawing from experiences across the continent, the handbook provides practical and actionable\r\nsteps towards promoting inclusivity, transparency, and accountability in governance processes by\r\nsharing innovative approaches to effective citizen engagement.\r\nIt builds on ongoing approaches and aims to guide users through the practical steps they can take to\r\nimprove citizen engagement.\r\nWe must recognize that citizen-centered governance is not only a moral obligation but also a strategic\r\nimperative for sustainable development. By empowering citizens to have a voice, we can harness\r\ntheir knowledge, skills, and creativity towards addressing the challenges facing our continent. I\r\nam confident that this handbook will equip African leaders with the necessary tools for creating a\r\nconducive environment for citizen engagement and driving Africa’s development agenda forward.', 'African Union (2022), African Union Handbook_EN.pdf.', 'African Union, African Union Handbook_EN.pdf(2022).', 'African Union (2022), African Union Handbook_EN.pdf.', 'af uni.PNG', 'Neytech Solutions', 0, 0, 3),
(1747, 'Considerations for Regulation of MNCH Medical devices_FINAL July 19.pdf', 'African Union', '2023', 'African Union Publications', '', '27386', '0000-00-00 00:00:00', 'One of the key objectives of the African Medical Devices Forum (AMDF) is building the technical\r\ncapacity of national regulatory agencies (NRAs) in medical devices and in-vitro diagnostics\r\nregulatory frameworks through the development of technical guidance documents. The AMDF\r\nhas developed and published Guidelines on regulatory requirements for issuance of market\r\nauthorization of medical devices including in-vitro diagnostic medical devices; Guidelines for\r\nregistration of medical devices establishments; Guidelines on import and export of medical\r\ndevices including in-vitro diagnostic medical devices; and Guidelines for inspection of\r\nmanufacturing site(s) for assessment of the quality management system of medical devices\r\nbased on ISO 13485:2016.\r\nAdvancements in health technologies call for continuous considerations to carry forward and\r\nstrengthen regulatory systems, and it is important to remain cognizant of areas with specific\r\nconsiderations, such as medical devices for maternal, newborn, and child subpopulations. In view\r\nof that, the AMDF, with the support of the US Agency for International Development (USAID)\r\nMedicines, Technologies, and Pharmaceutical Services (MTaPS) Program implemented by\r\nManagement Sciences for Health, has developed this document entitled Specific Considerations\r\nfor Regulating Maternal, Newborn, and Child Health Medical Devices – Market Authorization. It\r\noutlines specificities when assessing these medical devices at the market authorization phase. It\r\nis to be used with the other guidance documents that the AMDF has developed on market\r\nauthorization for medical devices, including in-vitro diagnostic (IVD) medical devices.\r\nThe AMDF considers this document a key resource that will provide information to NRAs in\r\nadvancing regulatory system strengthening in Africa.\r\n', 'African Union (2023), Considerations for Regulation of MNCH Medical devices_FINAL July 19.pdf.', 'African Union, Considerations for Regulation of MNCH Medical devices_FINAL July 19.pdf(2023).', 'African Union (2023), Considerations for Regulation of MNCH Medical devices_FINAL July 19.pdf.', 'co.PNG', 'Neytech Solutions', 0, 0, 3);
INSERT INTO `books` (`ID`, `Name`, `Author`, `Year`, `Category`, `Cite`, `File`, `Date`, `Descreption`, `APA`, `Chicago`, `Cambridge`, `Cover`, `Org`, `downlaods_count`, `citations_count`, `likes`) VALUES
(1748, 'Guidelines for Risk Analysis for the Testing and Deployment of Genetically Modified Mosquitoes_EN final_0.pdf', 'African Union', '2022', 'African Union Publications', '', '75645', '0000-00-00 00:00:00', 'The African Union (AU)\r\nThe African Union (AU) is a body of 55 member states that make up the\r\ncountries of the African Continent. It was officially launched in 2002 as\r\na successor to the Organization of African Unity (OAU), which ran from\r\n1963 to1999. The decision to re-launch Africa’s pan-African organisation\r\nwas the outcome of a consensus by African leaders that in order to\r\nrealise Africa’s potential, there was a need to re-focus attention from the\r\nfight for decolonisation and ridding the continent of apartheid hitherto\r\npursued under the OAU, towards increased cooperation and integration\r\nof African states to drive Africa’s growth and economic development.\r\nThe AU is guided by its vision of An integrated, prosperous and peaceful\r\nAfrica, driven by its own citizens and representing a dynamic force in\r\nthe global arena [1].\r\nTo realise this vision, the Africa Union developed and adopted a\r\n50-year strategic plan called Agenda 2063 [2]. Agenda 2063 is the\r\ncontinent’s strategic framework that aims to deliver on its goal for\r\ninclusive and sustainable development and is a concrete manifestation\r\nof the pan-African drive for unity, self-determination, freedom, progress\r\nand collective prosperity pursued under Pan-Africanism and African\r\nRenaissance.\r\nThe AU has been steadfast in proposing more enabling and sciencebased approaches to the challenges of the continent. Its report on\r\ngene drives clearly embraces the technology as a realistic option for\r\neffective disease control. A constructive development along this path\r\nwas witnessed at the 29th Ordinary Session of Heads of State and\r\nGovernment of the African Union in Addis Ababa, where pursuant to\r\nDecision Assembly/AU/Dec.649 (XXIX), the session embraced the gene\r\ndrive technology as a realistic option for malaria control. The session,\r\nin its decision, requested the African Union Commission (AUC), West\r\nAfrican Health Organization (WAHO) and African Union Development\r\nAgency-New Partnership for Africa’s Development (AUDA-NEPAD) to\r\ncollectively support the initiative [3].', 'African Union (2022), Guidelines for Risk Analysis for the Testing and Deployment of Genetically Modified Mosquitoes_EN final_0.pdf.', 'African Union, Guidelines for Risk Analysis for the Testing and Deployment of Genetically Modified Mosquitoes_EN final_0.pdf(2022).', 'African Union (2022), Guidelines for Risk Analysis for the Testing and Deployment of Genetically Modified Mosquitoes_EN final_0.pdf.', 'gui.PNG', 'Neytech Solutions', 0, 0, 3),
(1749, 'PIDA PAP2 - Project Prospectus.pd', 'African Union', '2023', 'African Union Publications', '', '29472', '0000-00-00 00:00:00', 'This work is a product of the African Union Development Agency. The designations employed and the presentation of material in this information product\r\ndo not imply the expression of any opinion whatsoever on the part of AUDA-NEPAD concerning the legal or development status of any country, territory,\r\ncity or area or of its authorities, or concerning the delimitation of its frontiers or boundaries.\r\nCountry borders or names do not necessarily reflect official endorsement or acceptance by JICA. The maps in this publication are only for illustrative\r\npurposes and does not imply the expression of any opinion on the part of JICA, concerning the legal status of any country or territory or concerning\r\nthe delimitation of frontiers or boundaries.\r\nRecommended citation:\r\nAfrican Union Development Agency - NEPAD. 2023. 2nd PIDA Priority\r\nAction Plan (2021-2030) - Projects Prospectus. AUDA-NEPAD, Midrand, South Africa.', 'African Union (2023), PIDA PAP2 - Project Prospectus.pd.', 'African Union, PIDA PAP2 - Project Prospectus.pd(2023).', 'African Union (2023), PIDA PAP2 - Project Prospectus.pd.', 'pid.PNG', 'Neytech Solutions', 0, 0, 3),
(1750, '29th AU Assembly Decision 650 - July 2017', 'African Union', '2017', 'African Union Publications', '', '18377', '0000-00-00 00:00:00', 'Decision on the report of H.E paul  kagame president of the republic of Rwanda on the implementation of the decision on the institutional reform of the african Union', 'African Union (2017), 29th AU Assembly Decision 650 - July 2017.', 'African Union, 29th AU Assembly Decision 650 - July 2017(2017).', 'African Union (2017), 29th AU Assembly Decision 650 - July 2017.', '29th.PNG', 'Neytech Solutions', 0, 0, 3),
(1751, '32nd AU Assembly Decision on NEPAD - E - February 2019', 'African Union', '2019 ', 'African Union Publications', '', '53828', '0000-00-00 00:00:00', 'Decision on the African continental free trade area Doc.Assembly ', 'African Union (2019 ), 32nd AU Assembly Decision on NEPAD - E - February 2019.', 'African Union, 32nd AU Assembly Decision on NEPAD - E - February 2019(2019 ).', 'African Union (2019 ), 32nd AU Assembly Decision on NEPAD - E - February 2019.', '29th.PNG', 'Neytech Solutions', 0, 0, 3),
(1752, '34th AU Assembly Decision on AUDA-NEPAD  Feb. 2021 - Eng', 'African Union', '2021', 'African Union Publications', '', '83431', '0000-00-00 00:00:00', 'Decision on the African Union development agency-New partnership for Africas Development(AUDA_NEPAD) Heads of state and government orientation committee (HSGOC)', 'African Union (2021), 34th AU Assembly Decision on AUDA-NEPAD  Feb. 2021 - Eng.', 'African Union, 34th AU Assembly Decision on AUDA-NEPAD  Feb. 2021 - Eng(2021).', 'African Union (2021), 34th AU Assembly Decision on AUDA-NEPAD  Feb. 2021 - Eng.', '34th.PNG', 'Neytech Solutions', 0, 0, 3),
(1754, 'Malawi National Youth Policy 2023 -2028', 'Malawi government', '2023', 'Malawi Government Policies', '', '68305', '0000-00-00 00:00:00', 'The government recognises that the youth constitute the majority of the population. They are a rich resource with varied skills, experiences and capacities, which, if properly prepared and strategically deployed, can contribute positively to their personal and economic development as well as the transformation of the country.\r\nThe National Youth Policy has been revised to consolidate the lessons learnt in the implementation of its predecessor policy and provide a new policy direction for the successful designing and implementation of youth development programmes in line with MW2063 aspirations. The revised Policy will facilitate mainstreaming of youth programming in various development planning instruments and policies and where necessary guide review of the legal and policy frameworks to ensure that they support the youth development agenda and enable the country to attain the economic benefit known as the demographic dividend. It will further continue to provide direction in capacity development for the youth, multi-stakeholder engagement, resource mobilization, and monitoring and evaluation of investment. This will be realised through ten priority areas under the Policy namely- Youth Employment, Enterprise and Skills Development; Youth Inclusion in Governance Systems and Transformative Leadership; Science, Technology and Innovation; Environmental Restoration and Climate Change; Education and Social Skills Development; Health and Nutrition; National Youth Service and Nation Building; Youth in Sports, Creative Industries and Culture; Youth and Social Wellbeing; and Coordination, Mainstreaming and Financing the youth agenda.', 'Malawi government (2023), Malawi National Youth Policy 2023 -2028.', 'Malawi government, Malawi National Youth Policy 2023 -2028(2023).', 'Malawi government (2023), Malawi National Youth Policy 2023 -2028.', 'National Youth Policy 2023-2028 Final.jpg', 'Neytech Solutions', 0, 0, 3),
(1755, 'PRESS RELEASE A TIME FOR ACTION TO RECOVER, DEVELOP, AND PROTECT OUR ECONOMY', 'Malawi Government', '2023', 'Government Press Release', '', '90464', '0000-00-00 00:00:00', 'Five days ago, the Reserve Bank of Malawi announced a 44% realignment\r\nof the kwacha against the dollar to correct supply-demand\r\nimbalances in the forex market. Therefore, as Government, we\r\nimmediately felt concerned about the adverse effects that this\r\nnecessary and long overdue correction would have on Malawians,\r\nespecially the most vulnerable households', 'Malawi Government (2023), PRESS RELEASE A TIME FOR ACTION TO RECOVER, DEVELOP, AND PROTECT OUR ECONOMY.', 'Malawi Government, PRESS RELEASE A TIME FOR ACTION TO RECOVER, DEVELOP, AND PROTECT OUR ECONOMY(2023).', 'Malawi Government (2023), PRESS RELEASE A TIME FOR ACTION TO RECOVER, DEVELOP, AND PROTECT OUR ECONOMY.', 'Screenshot 2023-11-13 213234.png', 'Neytech Solutions', 0, 0, 3),
(1756, 'COUNTRY PROGRAMME EVALUATIONMALAWI', 'Independent Evaluation Office United Nations Development Programme', '2023', 'UN Reports & Docs', '', '29649', '0000-00-00 00:00:00', 'National economic growth in Malawi is heavily reliant on the export of a small number of agricultural commodities, whilst 85 percent of the population depends on small-scale, rain-fed and low-input farming for their livelihoods and household food consumption. Over the past five decades, Malawi has experienced 19 major floods and seven droughts, with these events increasing in frequency, magnitude and scope, and registering cumulative impacts on national growth and poverty levels. Malawi has been characterized as ‘policy rich but implementation poor’, with a stalled decentralization process, limited coordination, and typically short-term donor initiatives all attributing to low policy completion.', 'Independent Evaluation Office United Nations Development Programme (2023), COUNTRY PROGRAMME EVALUATIONMALAWI.', 'Independent Evaluation Office United Nations Development Programme, COUNTRY PROGRAMME EVALUATIONMALAWI(2023).', 'Independent Evaluation Office United Nations Development Programme (2023), COUNTRY PROGRAMME EVALUATIONMALAWI.', 'Screenshot 2023-11-15 055738.png', 'Neytech Solutions', 0, 0, 3),
(1757, 'NATIONAL ADDRESS BY HIS EXCELLENCY DR. LAZARUS McCARTHY CHAKWERA, PRESIDENT OF THE REPUBLIC OF MALAWI', 'H.E Dr. L. Chakwela', '2023', 'Speeches', '', '48925', '0000-00-00 00:00:00', 'Fellow Malawians,\r\nAn hour ago, the Board of the International Monetary Fund\r\napproved the Extended Credit Facility to Malawi that we have\r\nbeen negotiating for the past two years. Under this facility,\r\nMalawi will receive an injection of 174 million dollars over the\r\nnext four years, as well as the resumption of direct budget\r\nsupport from international partners after a 10 year absence\r\nbecause of Cashgate and the financial mismanagement of the\r\nprevious administration.', 'H.E Dr. L. Chakwela (2023), NATIONAL ADDRESS BY HIS EXCELLENCY DR. LAZARUS McCARTHY CHAKWERA, PRESIDENT OF THE REPUBLIC OF MALAWI.', 'H.E Dr. L. Chakwela, NATIONAL ADDRESS BY HIS EXCELLENCY DR. LAZARUS McCARTHY CHAKWERA, PRESIDENT OF THE REPUBLIC OF MALAWI(2023).', 'H.E Dr. L. Chakwela (2023), NATIONAL ADDRESS BY HIS EXCELLENCY DR. LAZARUS McCARTHY CHAKWERA, PRESIDENT OF THE REPUBLIC OF MALAWI.', 'Screenshot 2023-11-16 082821.png', 'Neytech Solutions', 0, 0, 3),
(1758, 'Malawi Data protection policy (Subject to change)', 'Malawi Government (Parliament)', '2023', 'Malawi government Bills', '', '20363', '0000-00-00 00:00:00', 'This Bill seeks to provide for a comprehensive legal framework for the\r\nregulation of the processing and movement of personal data of natural persons,\r\nin compliance with internationally accepted principles of data protection.', 'Malawi Government (Parliament) (2023), Malawi Data protection policy (Subject to change).', 'Malawi Government (Parliament), Malawi Data protection policy (Subject to change)(2023).', 'Malawi Government (Parliament) (2023), Malawi Data protection policy (Subject to change).', 'download (5).jpeg', 'Neytech Solutions', 0, 0, 3),
(1759, 'Windhoek Statement on Artificial Intelligence in Southern Africa', 'UNESCO (SADC)', '2022', 'AI, Local', '', '81065', '0000-00-00 00:00:00', 'We, the Ministers in charge of Higher Education, ICTs, Digital Technologies, Communication, Science and \r\nInnovation from the Southern Africa countries1\r\n, gathered at the UNESCO-Southern Africa sub-Regional Forum on \r\nArtificial Intelligence (SARFAI), co-hosted by the Government of Namibia and UNESCO in Windhoek, from 7 to 9 \r\nSeptember 2022.', 'UNESCO (SADC) (2022), Windhoek Statement on Artificial Intelligence in Southern Africa.', 'UNESCO (SADC), Windhoek Statement on Artificial Intelligence in Southern Africa(2022).', 'UNESCO (SADC) (2022), Windhoek Statement on Artificial Intelligence in Southern Africa.', 'UNESCO.png', 'Neytech Solutions', 0, 0, 3),
(1760, 'An evolution of inequality of opportunity in the nutritional outcomes of under-five children in Malawi', 'Pemphero Norah Mphamba *, Gowokani Chijere Chirwa , Jacob Mazalale', '2024', 'Journals', '', '17201', '0000-00-00 00:00:00', 'Background: Malnutrition among children is a significant public health and development issue, especially in lowand\r\nmiddle-income countries, Malawi inclusive, which contributes to preventable diseases and deaths. Significant\r\nsocioeconomic disparities persist, which affect access to and equal distribution of basic nutrition. This study\r\nanalyzed the extent and trends of Inequality of Opportunity (IOP) in the nutritional outcomes of children aged\r\n0–59 months.\r\nMethods: The study used nationally representative data from the 2006, 2013–14, and 2019-20 Malawi Multiple\r\nIndicator Cluster Survey. In terms of method, we examined IOP in stunting, wasting, and underweight indicators,\r\nusing the Human Opportunity Index and the Dissimilarity Index in 55,723 children. The Shapley-value technique\r\ndecomposed the relative IOP.\r\nResults: We find the largest share of circumstance-driven inequality in stunting (8.96 percent), followed by underweight\r\n(1.91 percent), and then wasting (0.90 percent). The Shapley-value decomposition results indicate the\r\nchild’s age (29.15 percent for stunting, 12.42 percent for underweight, and 52.36 percent for wasting) and\r\ngender (8.28 percent, 18.36 percent and 8.87 percent), wealth (6.36 percent, 22.87 percent and 8.54 percent),\r\nand mother’s education (6.28 percent, 11.29 percent and 5.51 percent) as the dominant contributors to IOP for\r\nall three nutritional outcome indicators; stunting, underweight and wasting, respectively.\r\nConclusion: The findings suggest that policies aimed at narrowing the wealth and education inequality gap could\r\nhelp equalize nutrition opportunities for children in Malawi.', 'Pemphero Norah Mphamba *, Gowokani Chijere Chirwa , Jacob Mazalale (2024), An evolution of inequality of opportunity in the nutritional outcomes of under-five children in Malawi.', 'Pemphero Norah Mphamba *, Gowokani Chijere Chirwa , Jacob Mazalale, An evolution of inequality of opportunity in the nutritional outcomes of under-five children in Malawi(2024).', 'Pemphero Norah Mphamba *, Gowokani Chijere Chirwa , Jacob Mazalale (2024), An evolution of inequality of opportunity in the nutritional outcomes of under-five children in Malawi.', 'Journal.png', 'Neytech Solutions', 0, 0, 3),
(1761, 'Botswana Budget 2024/25', 'PWC', '2024', 'International Finance', '', '45967', '0000-00-00 00:00:00', 'The 2024/2025 Budget marked the end of the second Transitional National Development Plan (“TNDPâ€) deferring National\r\nDevelopment Plan 12 to the financial year 2024/2025. Delivering the 2024/2025 Budget Speech, Minister of Finance and\r\nEconomic Development Honourable Peggy O Serame highlighted that the TNDP is of strategic significance and is guided by\r\nthe following national priorities:\r\n• Infrastructure development and spatial planning\r\n• Sustaining livelihoods\r\n• Agriculture development\r\n• Supporting the private sector through business environment reforms and value chain development\r\n• Research and development\r\n• Innovation and digital transformation\r\n• Green transition\r\n• Education and human capital development\r\n• Tourism development', 'PWC (2024), Botswana Budget 2024/25.', 'PWC, Botswana Budget 2024/25(2024).', 'PWC (2024), Botswana Budget 2024/25.', 'Botswana Budget.png', 'Neytech Solutions', 0, 0, 3),
(1762, 'UNGA 78 ADDRESS BY HIS EXCELLENCY DR. LAZARUS McCARTHY CHAKWERA, ', 'REPUBLIC OF MALAWI', '2023', 'Speeches', '', '25855', '0000-00-00 00:00:00', 'ADDRESS\r\nBY HIS EXCELLENCY DR. LAZARUS McCARTHY CHAKWERA,\r\nPRESIDENT OF THE REPUBLIC OF MALAWI,\r\nDURING THE GENERAL DEBATE OF THE 78TH SESSION OF\r\nTHE UNITED NATIONS GENERAL ASSEMBLY\r\nNEW YORK,\r\nUNITED STATES OF AMERICA,\r\n21ST SEPTEMBER 2023', 'REPUBLIC OF MALAWI (2023), UNGA 78 ADDRESS BY HIS EXCELLENCY DR. LAZARUS McCARTHY CHAKWERA, .', 'REPUBLIC OF MALAWI, UNGA 78 ADDRESS BY HIS EXCELLENCY DR. LAZARUS McCARTHY CHAKWERA, (2023).', 'REPUBLIC OF MALAWI (2023), UNGA 78 ADDRESS BY HIS EXCELLENCY DR. LAZARUS McCARTHY CHAKWERA, .', 'Speech.png', 'Neytech Solutions', 0, 0, 3),
(1763, 'SONA 2024 | TAKING STOCK AND ADVANTAGE OF OUR PROGRESS IN ACHIEVING ECONOMIC RECOVERY AND RESILIENCE', 'DR. LAZARUS McCARTHY CHAKWERA', '2024', 'Speeches', '', '33402', '0000-00-00 00:00:00', 'STATE OF THE NATION ADDRESS\r\nTAKING STOCK AND ADVANTAGE OF OUR\r\nPROGRESS IN ACHIEVING ECONOMIC\r\nRECOVERY AND RESILIENCE\r\nby\r\nHIS EXCELLENCY\r\nDR. LAZARUS McCARTHY CHAKWERA,\r\nPRESIDENT OF THE REPUBLIC OF MALAWI\r\nduring the opening of\r\nTHE 2024/2025 BUDGET MEETING\r\nAT THE FOURTH MEETING IN THE 50TH\r\nSESSION OF PARLIAMENT', 'DR. LAZARUS McCARTHY CHAKWERA (2024), SONA 2024 | TAKING STOCK AND ADVANTAGE OF OUR PROGRESS IN ACHIEVING ECONOMIC RECOVERY AND RESILIENCE.', 'DR. LAZARUS McCARTHY CHAKWERA, SONA 2024 | TAKING STOCK AND ADVANTAGE OF OUR PROGRESS IN ACHIEVING ECONOMIC RECOVERY AND RESILIENCE(2024).', 'DR. LAZARUS McCARTHY CHAKWERA (2024), SONA 2024 | TAKING STOCK AND ADVANTAGE OF OUR PROGRESS IN ACHIEVING ECONOMIC RECOVERY AND RESILIENCE.', 'SONA 2024.png', 'Neytech Solutions', 0, 0, 3);

-- --------------------------------------------------------

--
-- Table structure for table `bookshop`
--

CREATE TABLE `bookshop` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `author` varchar(255) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `description` text NOT NULL,
  `cover_image` varchar(255) NOT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `collaboitems`
--

CREATE TABLE `collaboitems` (
  `ID` int(11) NOT NULL,
  `Description` text COLLATE utf8_unicode_ci NOT NULL,
  `File` text COLLATE utf8_unicode_ci NOT NULL,
  `Date` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `Collabo` int(11) NOT NULL,
  `Uploader` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `collaboitems`
--

INSERT INTO `collaboitems` (`ID`, `Description`, `File`, `Date`, `Collabo`, `Uploader`) VALUES
(1, 'The news from AI World', '53572 (1).pdf', '03 June 2023', 4, 0);

-- --------------------------------------------------------

--
-- Table structure for table `collaboitems2`
--

CREATE TABLE `collaboitems2` (
  `ID` int(11) NOT NULL,
  `Description` text COLLATE utf8_unicode_ci NOT NULL,
  `File` text COLLATE utf8_unicode_ci NOT NULL,
  `Date` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `Collabo` int(11) NOT NULL,
  `Uploader` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `collaboitems2`
--

INSERT INTO `collaboitems2` (`ID`, `Description`, `File`, `Date`, `Collabo`, `Uploader`) VALUES
(1, 'the begginng of a new life', 'Tiyeni (Prod by Tbak & Trappy Beatz).jpg', '26 April 2021', 1, 53),
(2, '56756', 'Dona Wane (Prod by Nic Nather & Highgrames).jpg', '26 April 2021', 1, 53),
(3, '6yu6', 'Tiyeni (Prod by Tbak & Trappy Beatz).jpg', '26 April 2021', 1, 64),
(4, 'The done of AI', '53572 (1).pdf', '03 June 2023', 11, 222);

-- --------------------------------------------------------

--
-- Table structure for table `collaborators`
--

CREATE TABLE `collaborators` (
  `ID` int(11) NOT NULL,
  `Fullname` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `Org` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `Date` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `Approval` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `Topic` int(11) NOT NULL,
  `Researcher` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `collaborators`
--

INSERT INTO `collaborators` (`ID`, `Fullname`, `Org`, `Date`, `Approval`, `Topic`, `Researcher`) VALUES
(1, '14', ' Mzuzu University', '12 April 2021', 'Pending', 5, 12),
(2, '', '', '21 April 2021', 'Accepted', 3, 61),
(3, '', '', '25 January 2023', 'Denied', 4, 12),
(4, '', '', '30 January 2023', 'Denied', 6, 14),
(5, '', '', '29 July 2023', 'Accepted', 7, 13);

-- --------------------------------------------------------

--
-- Table structure for table `collaborators2`
--

CREATE TABLE `collaborators2` (
  `ID` int(11) NOT NULL,
  `Fullname` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `Org` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `Date` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `Approval` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `Topic` int(11) NOT NULL,
  `Researcher` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `collaborators2`
--

INSERT INTO `collaborators2` (`ID`, `Fullname`, `Org`, `Date`, `Approval`, `Topic`, `Researcher`) VALUES
(1, '64', '', '26 April 2021', 'Accepted', 5, 53),
(2, '65', '', '26 April 2021', 'Accepted', 5, 53),
(3, '199', ' Neytech', '18 January 2023', 'Pending', 8, 1),
(4, '222', '', '16 May 2023', 'Pending', 7, 73),
(5, '229', '', '01 June 2023', 'Pending', 7, 73),
(6, '73', '', '01 June 2023', 'Pending', 8, 1),
(7, '73', '', '01 June 2023', 'Pending', 2, 53),
(8, '73', '', '01 June 2023', 'Pending', 5, 53),
(9, '227', '', '02 June 2023', 'Pending', 9, 73),
(10, '227', '', '02 June 2023', 'Pending', 7, 73),
(11, '222', '', '03 June 2023', 'Accepted', 10, 218),
(12, '359', '', '04 December 2023', 'Pending', 8, 1),
(13, '507', '', '20 March 2024', 'Pending', 8, 1);

-- --------------------------------------------------------

--
-- Table structure for table `collaborators3`
--

CREATE TABLE `collaborators3` (
  `ID` int(11) NOT NULL,
  `Fullname` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `Org` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `Date` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `Approval` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `Topic` int(11) NOT NULL,
  `Researcher` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `colleges`
--

CREATE TABLE `colleges` (
  `ID` int(11) NOT NULL,
  `Name` varchar(100) NOT NULL,
  `Date` varchar(100) NOT NULL,
  `Status` varchar(100) NOT NULL,
  `Logo` varchar(200) NOT NULL,
  `Username` varchar(100) NOT NULL,
  `Password` text NOT NULL,
  `Package` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `colleges`
--

INSERT INTO `colleges` (`ID`, `Name`, `Date`, `Status`, `Logo`, `Username`, `Password`, `Package`) VALUES
(26, ' AIU', '25 July 2023', 'Deactive', '57481048_321904001803886_6056001069585006592_n.jpg', 'AIU', '$2y$10$Sz9eXJdCUQU9KZ6tGqN56uGuMzFnOzJirfcLj0OojWQnhcNCsAIh.', 'Premium'),
(27, ' Mary Mount', '26 July 2023', 'Deactive', '304211037_765409458180558_4130211484928311860_n.png', 'Marymount', '$2y$10$6U0afBVJk1RNb1cNpGnrQ.EuHaDMKF6dR9xLfPUjn.3fSgw7LKezq', 'Premium'),
(28, ' Ambassador International University', '26 July 2023', 'Deactive', '57481048_321904001803886_6056001069585006592_n.jpg', 'AIUZAMBIA', '$2y$10$VQs.pts3tLriTmgJDw9CQOszzukw4vVINYUqudfHUXNL3Knd3i9wG', 'Premium'),
(29, ' Permaculture Institute Paradise', '26 July 2023', 'Deactive', '17799432_1164610730328066_7913447047466993187_n.jpg', 'PPIMC', '$2y$10$ttk97abSu8vGYurQZI5T5eVrO36ZchIYRg.Pz9dz7QBezuSjj8HmG', 'Premium');

-- --------------------------------------------------------

--
-- Table structure for table `company`
--

CREATE TABLE `company` (
  `ID` int(11) NOT NULL,
  `Name` varchar(100) NOT NULL,
  `Date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `Status` varchar(100) NOT NULL,
  `Logo` varchar(200) NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` text NOT NULL,
  `package` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `company`
--

INSERT INTO `company` (`ID`, `Name`, `Date`, `Status`, `Logo`, `username`, `password`, `package`) VALUES
(12, ' Ney School of Computing', '2024-03-15 17:03:55', 'Deactive', 'transpaternt Neytech.png', 'NeysSchool', '$2y$10$LVjyakJgzpTXs3uE.xnujeFJQulhxwyWjF5zxBXXA/428AVDzQVcq', 'Premium'),
(13, ' EGM International', '2024-02-11 07:54:00', 'Deactive', 'EGM.jpg', 'LLC', '$2y$10$eerFiTeXPyDILX2UcZFLGOC9Xk0axkhRon.a53v/g3NhS1e.VnWO.', 'Premium');

-- --------------------------------------------------------

--
-- Table structure for table `employes`
--

CREATE TABLE `employes` (
  `ID` int(11) NOT NULL,
  `Firstname` varchar(100) NOT NULL,
  `Lastname` varchar(100) NOT NULL,
  `Username` varchar(100) NOT NULL,
  `Password` varchar(100) NOT NULL,
  `Company` varchar(100) NOT NULL,
  `Profile` varchar(100) NOT NULL,
  `Date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `Employee_number` varchar(100) NOT NULL,
  `Status` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `employes`
--

INSERT INTO `employes` (`ID`, `Firstname`, `Lastname`, `Username`, `Password`, `Company`, `Profile`, `Date`, `Employee_number`, `Status`) VALUES
(2, ' Natasha', 'Soko', 'Nata', '12345', ' Jadan', 'blender.png', '2023-01-04 00:00:00', '456456', 'Active'),
(3, ' Eugo', 'Eustace', 'Chiye', '1234', ' Jadan', 'blender.png', '2023-01-04 00:00:00', '44', 'Suspend'),
(4, ' Rein', 'Ford', 'Rein', '12345', ' Jadan', 'blender.png', '2023-01-04 00:00:00', '54', 'Suspend'),
(5, ' Nata', 'Tasha', 'Nata1', '1234', ' Jadan', 'blender.png', '2023-01-05 00:00:00', '544', 'Active'),
(6, ' julia', 'kaya', 'julia', '123', ' Xerographics', 'Screenshot_2022-10-25_18_32_28.png', '2023-01-10 10:20:48', '009', 'Active'),
(7, ' Ichocho', 'Juma', 'Ichocho', '234', ' Xerographics', 'Screenshot_2022-09-21_23_06_04.png', '2023-01-10 10:23:16', '003', 'Suspend'),
(8, ' Mirrie', 'Zimba', 'Mirrrie', '12345', ' Xerographics', 'Screenshot_2022-09-21_22_41_45.png', '2023-01-11 14:04:53', '004', 'Active'),
(9, ' Patience', 'Perera', 'pearl', '123456789', ' CSONA MW', 'DSC_0817.JPG', '2023-01-10 13:02:39', '12345', 'Active'),
(10, ' Kettie ', 'Sambani', 'kettie', '123456789', ' CSONA MW', 'DSC_0161.JPG', '2023-01-10 13:05:04', '23456', 'Active'),
(11, ' Jean', 'Banda', 'Jean', '123456789', ' CSONA MW', 'DSC_0774.JPG', '2023-01-10 13:09:09', '34567', 'Active'),
(12, ' Ben', 'Hamie', 'Ben', 'Ben123', ' Xerographics', '12.png', '2023-01-11 14:09:36', '009', 'Active'),
(13, ' Kondwani', 'Mushali', 'NeyK', '1992Ney!!!!!', ' Neytech', '_DSC0217.jpg', '2023-01-18 01:42:34', '0001', 'Active'),
(14, ' Mwenecho', 'Kayange', 'Necho', '$2y$10$zSOCaEffQ03EThp7rsWUdeNd4yFLiActb3oD1bG4uHCRD9bdpLm42', ' Ney School of Computing', 'Grace.png', '0000-00-00 00:00:00', '111', 'Active'),
(15, ' Charles', 'Ntago', 'Ntedza', '$2y$10$T2QDiU.1WVVZEwIwICFZfuyIkBZzcWzvrHnOUIfUFZY/7yAmALOOe', ' Ney School of Computing', 'Aubrey.png', '2023-07-26 12:58:45', '0009', '1'),
(16, ' Muhamadi', 'Ali', 'Muhamadi', '$2y$10$7Rm1ZpVRrTjlcPIdH4uHj.CyvZuUkce/OPcIBjaCTZQtuO/P9pRBK', ' EGM International', '1667576423618.jpg', '0000-00-00 00:00:00', '1234', 'Active'),
(17, ' Esther', 'Chungu', 'Esther', '$2y$10$lsM33wcJbY7Cxcna/M2obuEkG1.IVVNWG.zi2Uo/C6kARmKmkvyaC', ' EGM International', '161400nigeria05.png', '0000-00-00 00:00:00', '12345', 'Active'),
(18, ' Michael', 'Banda', 'Michael', '$2y$10$iJeR8p2Prm9qwvrckowzfuqz4SINuCMC88g/S1HOPSI17KKfUy4..', ' EGM International', '1668077070296.jpg', '0000-00-00 00:00:00', '123456', 'Active');

-- --------------------------------------------------------

--
-- Table structure for table `library`
--

CREATE TABLE `library` (
  `ID` int(11) NOT NULL,
  `Name` varchar(100) NOT NULL,
  `Status` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `package`
--

CREATE TABLE `package` (
  `ID` int(11) NOT NULL,
  `Items` varchar(100) NOT NULL,
  `Package` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `research`
--

CREATE TABLE `research` (
  `ID` int(11) NOT NULL,
  `Topic` text COLLATE utf8_unicode_ci NOT NULL,
  `First` text COLLATE utf8_unicode_ci NOT NULL,
  `Second` text COLLATE utf8_unicode_ci NOT NULL,
  `Third` text COLLATE utf8_unicode_ci NOT NULL,
  `Fourth` text COLLATE utf8_unicode_ci NOT NULL,
  `Date` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `Last` text COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `research`
--

INSERT INTO `research` (`ID`, `Topic`, `First`, `Second`, `Third`, `Fourth`, `Date`, `Last`) VALUES
(17, '10', 'The surfacing of AI has created a lot of BUZZ and it has taken the internet with storm, as we people try to grapple with this morning star of the New age, in this paper I am going to highlight more on how this new monster of a technology is affecting education, the big question to answer is this \"Will AI be able to Exist with our Traditional Education System?\"\r\n\r\nWalk with me as we are going to unravel this mystery', '', '', '', '03 June 2023', '03 June 2023'),
(18, '11', 'Data analysis was performed using Stata 11 (StatCorp, TX). A modified Poisson regression model was used as previously described [6] to examine the effects of individual antibodies on the outcome, defined as a clinical episode of malaria during 6 months of follow-up. A', '', '', '', '20 March 2024', '20 March 2024');

-- --------------------------------------------------------

--
-- Table structure for table `store_items`
--

CREATE TABLE `store_items` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `author` varchar(255) NOT NULL,
  `year` year(4) NOT NULL,
  `description` text NOT NULL,
  `category` varchar(255) NOT NULL,
  `cover` varchar(255) NOT NULL,
  `hard_cover_price` double NOT NULL,
  `paper_back_price` double NOT NULL,
  `digital_price` double NOT NULL,
  `status` int(11) NOT NULL,
  `rating` float DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `store_items`
--

INSERT INTO `store_items` (`id`, `name`, `author`, `year`, `description`, `category`, `cover`, `hard_cover_price`, `paper_back_price`, `digital_price`, `status`, `rating`, `created_at`, `updated_at`) VALUES
(1, 'The Hundred Years\' War on Palestine: A History of Settler Colonialism and Resistance, 1917-2017', 'Rashid Khalidi ', '0000', 'A landmark history of one hundred years of war waged against the Palestinians from the foremost US historian of the Middle East, told through pivotal events and family history\r\n\r\nIn 1899, Yusuf Diya al-Khalidi, mayor of Jerusalem, alarmed by the Zionist call to create a Jewish national home in Palestine, wrote a letter aimed at Theodore Herzl: the country had an indigenous people who would not easily accept their own displacement. He warned of the perils ahead, ending his note, \"in the name of God, let Palestine be left alone.\" Thus Rashid Khalidi, al-Khalidi\'s great-great-nephew, begins this sweeping history, the first general account of the conflict told from an explicitly Palestinian perspective.\r\nDrawing on a wealth of untapped archival materials and the reports of generations of family members--mayors, judges, scholars, diplomats, and journalists--The Hundred Years\' War on Palestine upends accepted interpretations of the conflict, which tend, at best, to describe a tragic clash between two peoples with claims to the same territory. Instead, Khalidi traces a hundred years of colonial war on the Palestinians, waged first by the Zionist movement and then Israel, but backed by Britain and the United States, the great powers of the age. He highlights the key episodes in this colonial campaign, from the 1917 Balfour Declaration to the destruction of Palestine in 1948, from Israel\'s 1982 invasion of Lebanon to the endless and futile peace process.\r\nOriginal, authoritative, and important, The Hundred Years\' War on Palestine is not a chronicle of victimization, nor does it whitewash the mistakes of Palestinian leaders or deny the emergence of national movements on both sides. In reevaluating the forces arrayed against the Palestinians, it offers an illuminating new view of a conflict that continues to this day.\r\n', '', '9781250787651.jpg', 30000, 25000, 0, 1, NULL, '2023-11-25 21:29:54', NULL),
(2, 'In the Black Fantastic', 'Ekow Eshun', '0000', 'A richly illustrated exploration of Black culture at its most wildly imaginative and artistically ambitious, In the Black Fantastic assembles art and imagery from across the African diaspora. ', '', '9780262047258.jpg', 35000, 0, 0, 1, NULL, '2023-11-25 21:38:12', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `store_sales`
--

CREATE TABLE `store_sales` (
  `id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `customer_email` varchar(255) NOT NULL,
  `price` double NOT NULL,
  `qty` int(11) NOT NULL,
  `status` varchar(85) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime DEFAULT NULL,
  `card_holder` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `students`
--

CREATE TABLE `students` (
  `ID` int(11) NOT NULL,
  `Firstname` varchar(100) NOT NULL,
  `Lastname` varchar(100) NOT NULL,
  `Username` varchar(100) NOT NULL,
  `Password` varchar(100) NOT NULL,
  `Org` varchar(100) NOT NULL,
  `Picture` varchar(100) NOT NULL,
  `Date` varchar(100) NOT NULL,
  `Reg` varchar(100) NOT NULL,
  `Status` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `students`
--

INSERT INTO `students` (`ID`, `Firstname`, `Lastname`, `Username`, `Password`, `Org`, `Picture`, `Date`, `Reg`, `Status`) VALUES
(11, ' praise', 'Reuben', 'Kont', '$2y$10$SwPNaAyvkpf.OlzwFH9.VeZ3RQUlUgwnfH3MMctIU1FNqonrHqAte', ' AIU', 'Picture10.jpg', '26 July 2023', '123', ''),
(13, ' NeyMus', 'Musha', 'NeyMush', '$2y$10$S0TaNJP6DwlBsZGjwznBP.qAyJ5QekjelieayCMdyj0n6EjNgT/je', ' AIU', 'postQueueImg_1673807156.59.jpg', '26 July 2023', '12345', '');

-- --------------------------------------------------------

--
-- Table structure for table `subs`
--

CREATE TABLE `subs` (
  `ID` int(11) NOT NULL,
  `Category` text COLLATE utf8_unicode_ci NOT NULL,
  `Name` text COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `subscribers`
--

CREATE TABLE `subscribers` (
  `ID` int(11) NOT NULL,
  `Email` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `subscribers`
--

INSERT INTO `subscribers` (`ID`, `Email`) VALUES
(1, 'mwaikum@gmail.com'),
(2, 'kiamamvula@gmail.com'),
(3, 'kiamamvula@gmail.com'),
(4, ''),
(5, 'stanislaskobende@gmail.com'),
(6, 'talk2janemanda@hotmail.com'),
(8, 'pnamaqua@gmail.com'),
(9, 'Chinkhunthavincent@gmail.co.com '),
(10, 'Chinkhunthavincent@gmail.co.com '),
(11, 'Chinkhunthavincent@gmail.co.com '),
(12, 'margovillie@gmail.com'),
(13, 'rashidmtupa@gmail.com'),
(14, 'everodo30@mail.ru'),
(15, 'everodo33@mail.ru'),
(16, 'adahjoseph12@gmail.com'),
(17, 'sainaninoah59@gmail.com'),
(18, 'danieljalielchibwe@gmail.com'),
(19, 'mwalwandaishmael@gmail.com'),
(20, 'smatemvu50@gmail.com'),
(23, 'xnBMx'),
(24, '62Mqn'),
(25, ''),
(26, ''),
(27, ''),
(28, ''),
(29, ''),
(30, ''),
(31, ''),
(32, ''),
(33, ''),
(34, 'yI1Pq'),
(35, 'boKnh'),
(36, ''),
(37, ''),
(38, ''),
(39, ''),
(40, ''),
(41, ''),
(42, ''),
(43, ''),
(44, ''),
(45, '1.01hdhrdskzmvbemvz53yr52jx5@mail4u.pw'),
(46, '5.01hdhrdskzmvbemvz53yr52jx5@mail4u.fun'),
(47, '7.01hdhrdskzmvbemvz53yr52jx5@mail4u.run'),
(48, 'cwwxsv'),
(49, 'sdlnqj'),
(50, ''),
(51, ''),
(52, ''),
(53, ''),
(54, ''),
(55, ''),
(56, ''),
(57, ''),
(58, ''),
(59, 'xtq1z2'),
(60, '8dck76'),
(61, ''),
(62, ''),
(63, ''),
(64, ''),
(65, ''),
(66, ''),
(67, ''),
(68, ''),
(69, ''),
(70, ''),
(71, ''),
(72, 'lwfp'),
(73, 'lwfp'),
(74, 'lwfp'),
(75, 'lwfp'),
(76, 'yv0q5s'),
(77, 'xsbuem'),
(78, ''),
(79, ''),
(80, ''),
(81, ''),
(82, ''),
(83, ''),
(84, ''),
(85, ''),
(86, ''),
(87, 'MPHJ'),
(88, 'MPHJ'),
(89, 'MPHJ'),
(90, ''),
(91, '5uzju9'),
(92, '148l45'),
(93, ''),
(94, ''),
(95, ''),
(96, ''),
(97, ''),
(98, ''),
(99, ''),
(100, ''),
(101, ''),
(102, ''),
(103, ''),
(104, 'k3lbza'),
(105, 'sxlug1'),
(106, ''),
(107, ''),
(108, ''),
(109, ''),
(110, ''),
(111, ''),
(112, ''),
(113, ''),
(114, ''),
(115, 'Mumu'),
(116, 'Mumu'),
(117, 'Mumu'),
(118, ''),
(119, '29.01hk6ecdd28rjp4tgf9rrf838v@mail5u.xyz'),
(120, 'b.oris.1.980se.ceno.v@gmail.com\r\n'),
(121, 'galandia@who.int'),
(122, 'aq.u.a.bur.s.e.rvic.e.202.1@gmail.com\r\n'),
(123, '2612.s.u.p.ers.e.r.v.is202.1@gmail.com\r\n'),
(124, 'b.or.is198.0secen.o.v@gmail.com\r\n'),
(125, 'p.u.ti.l.oi.v.a.n.7.35.6.7.81.23@gmail.com\r\n'),
(126, 'EMEKEESYBAXMILI@softbox.site'),
(127, 'p.ut.il.o.i.van7.3.5.67.8.123@gmail.com\r\n'),
(128, ''),
(129, 'jurgenelissa@tekisto.com'),
(130, 'vadimnea66+474z@list.ru');

-- --------------------------------------------------------

--
-- Table structure for table `topics`
--

CREATE TABLE `topics` (
  `ID` int(11) NOT NULL,
  `Name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `Researcher` int(11) NOT NULL,
  `Date` varchar(100) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `topics`
--

INSERT INTO `topics` (`ID`, `Name`, `Researcher`, `Date`) VALUES
(1, 'Malawi Campaign Against Child Marriages With Miss Africa Washington 2019 Nellie Matewere (Trial)', 0, '24 March 2021'),
(2, 'Malawi', 0, '26 March 2021'),
(3, 'MEC Crime Reporting System in USSD', 12, '26 March 2021'),
(4, 'hy', 12, '26 March 2021'),
(5, 'Vehicle Tracking Application', 12, '26 March 2021'),
(6, 'Fish Farming', 14, '12 April 2021'),
(7, 'How food security of a country affect elections in sub-Saharan Africa', 13, '26 July 2023');

-- --------------------------------------------------------

--
-- Table structure for table `topics2`
--

CREATE TABLE `topics2` (
  `ID` int(11) NOT NULL,
  `Name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `Researcher` int(11) NOT NULL,
  `Date` varchar(100) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `topics2`
--

INSERT INTO `topics2` (`ID`, `Name`, `Researcher`, `Date`) VALUES
(2, 'Girl Child Crime Reporting Application', 53, '12 April 2021'),
(3, 'Change  management', 61, '21 April 2021'),
(4, 'Change  management', 61, '21 April 2021'),
(5, 'Loan Tracking System', 53, '26 April 2021'),
(6, 'Vehicle Tracking Application', 64, '26 April 2021'),
(7, 'Poverty in Africa', 73, '08 October 2021'),
(8, 'Cucumber', 1, '10 January 2023'),
(9, 'The AI and Education, how can we co-exist', 73, '01 June 2023'),
(10, 'The AI and Education, how can we co-exist', 218, '03 June 2023'),
(11, 'Civic Education', 507, '20 March 2024');

-- --------------------------------------------------------

--
-- Table structure for table `topics3`
--

CREATE TABLE `topics3` (
  `ID` int(11) NOT NULL,
  `Name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `Researcher` int(11) NOT NULL,
  `Date` varchar(100) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `ID` int(11) NOT NULL,
  `Fullname` varchar(100) DEFAULT NULL,
  `Email` varchar(100) DEFAULT NULL,
  `Phone` varchar(100) DEFAULT NULL,
  `Address` varchar(100) DEFAULT NULL,
  `Username` varchar(100) DEFAULT NULL,
  `Password` text,
  `Org` varchar(100) DEFAULT NULL,
  `Type` varchar(100) DEFAULT NULL,
  `Logo` varchar(200) DEFAULT NULL,
  `Role` varchar(100) DEFAULT NULL,
  `Profile` varchar(100) DEFAULT NULL,
  `Date` varchar(100) DEFAULT NULL,
  `Package` varchar(100) DEFAULT NULL,
  `Approval` varchar(100) DEFAULT NULL,
  `Status` varchar(100) CHARACTER SET utf8 COLLATE utf8_spanish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`ID`, `Fullname`, `Email`, `Phone`, `Address`, `Username`, `Password`, `Org`, `Type`, `Logo`, `Role`, `Profile`, `Date`, `Package`, `Approval`, `Status`) VALUES
(1, 'Kondwani Mushali', 'kmushali9@gmail.com', '+265992235670', 'M1 Road', 'Neytech1', '$argon2i$v=19$m=16,t=2,p=1$c3J3Unp3ZGtmbFhSbnFhQw$H6CVlBMOsGsZbNXLTYXKzg', 'Neytech Solutions', 'Admin', 'neytech trabsparent.png', 'Admin', 'LAB_8236-min.jpg', '', 'Premium', '', ''),
(57, 'Limbani Rashid Mtupanyama', 'rashidmtupa@gmail.com', '', '', 'rashidmtupa@gmail.com', '$2y$10$xUjQFjZ.X4woL3haIjcSKejUhgYSXhCDBVOTULu8JQ3CbDZouztX.', '', 'Individual', '', '', '1536264266127.jpg', '21 April 2021', 'Free', 'Yes', ''),
(61, 'Eddy Kalonga', 'eddykalonga@hotmail.co.uk', '', '', 'eddykalonga@hotmail.co.uk', '$2y$10$N17M4lpeXGIZOzxwpf2E3Oz012EEVzXJ4kIjyNOb25PWkNVhC5C4e', '', 'Individual', '', '', 'logo 1.PNG', '21 April 2021', 'Free', 'Yes', ''),
(62, 'Linly Dumuka', 'dumukalinly@yahoo.com', '', '', 'dumukalinly@yahoo.com', '$2y$10$.yccHywTHJYOSbsfFGJYn..Jy1vnNuKJTOQYdBGNK6uCbVfFISYDu', '', 'Individual', '', '', 'PictureQuotes1573403553.jpg', '22 April 2021', 'Free', 'Yes', ''),
(67, 'Chilunga', 'kizitochilunga@yahoo.co.uk', '', '', 'kizitochilunga@yahoo.co.uk', '$2y$10$cmo3cCMFXPKo4MTojeD3K.8/IJ4oBLFaYHsuCARvTr4EKjBDQMpcm', '', 'Individual', '', '', 'apps.45483.13510798886202835.cf7a3ce1-9895-4097-82d3-e76eae7688f7[1].jpg', '27 April 2021', 'Free', 'Yes', ''),
(72, 'Emmanuell', 'charteenere@gmail.com', '', '', 'charteenere@gmail.com', '$2y$10$5hEtJRrqhL2Houn1Ls0Gcu.Ug7Z4H/YxAu4TJxnu.4o9.wkNs/Lne', '', 'Individual', '', '', '20210520_132557.jpg', '20 May 2021', 'Free', 'Yes', ''),
(75, 'Concepcion Alonso', 'akrebb32@gmail.com', '', '', 'akrebb32@gmail.com', '$2y$10$BrIR4SljwzIllLTAFkzZbOPdWfBlaeWD8h6kQ3nmPodIhCzQz0fre', '', 'Individual', '', '', 'up.php', '21 November 2021', 'Free', 'Yes', ''),
(76, 'Peter Maluwa', 'apitamaluwa@gmail.com', '', '', 'apitamaluwa@gmail.com', '$2y$10$BQutgt38D3id6MxvJHZ.netxfMqK6YmsG1tIqlSZGm62ilP5PrOp2', '', 'Individual', '', '', 'IMG_9511.JPG', '05 December 2021', 'Free', 'Yes', ''),
(156, 'Samuel', 'smartsumana9@gmail.com', '', '', 'smartsumana9@gmail.com', '$2y$10$L7HvD3t/oEx.dLxqirIoYOConJgiagpTJ2meFROw6yn.a0E2Q/7uG', '', 'Individual', '', '', 'inbound7485256742141075226.jpg', '27 December 2021', 'Free', 'Yes', ''),
(163, 'Noah Sainani ', 'sainaninoah59@gmail.com', '', '', 'sainaninoah59@gmail.com', '$2y$10$AarCOauruiXbbhs9bgSZxOLJvexu1Zs.OEK2fwlgwaMUwJJiSE2E2', '', 'Individual', '', '', 'IMG_20210224_083307_1~2.jpg', '10 January 2022', 'Free', 'Yes', ''),
(194, 'joseph Gausi', 'gausijose@gmail.com', NULL, NULL, 'gausijose@gmail.com', '$2y$10$A2PbALiSMI38nCiCWlWl6.Hqo0xu3kfNizzc6eqItgcYdpkP5Zv62', NULL, 'Individual', NULL, NULL, 'IMG_20211026_123119.jpg', '10 January 2023', 'Free', 'Yes', NULL),
(200, 'Charles Innocent', 'phiriinnocentcharles@gmail.com', NULL, NULL, 'phiriinnocentcharles@gmail.com', '$2y$10$BKMYixsUPHMCTtG3HvJ0AuKani2h0o8i862sOo2ErBHW.A0Kcfb3W', NULL, 'Individual', NULL, NULL, 'IMG_20220707_103423_transcpr.jpg', '19 January 2023', 'Free', 'Yes', NULL),
(202, 'patrick kholowa kasiya', 'patrickkasiya6@gmail.com', NULL, NULL, 'patrickkasiya6@gmail.com', '$2y$10$UnK9wUE.ns2v7V3L4.2vaOYTF3vM5piowpmqg7Ak9zlStSfb1H7AC', NULL, 'Individual', NULL, NULL, 'signature.jpg', '01 February 2023', 'Free', 'Yes', NULL),
(205, 'Pilirani Kumasewera ', 'padziwe@gmail.com', NULL, NULL, 'padziwe@gmail.com', '', NULL, 'Individual', NULL, NULL, '16763070123415488515443280520642.jpg', '13 February 2023', 'Free', 'Yes', NULL),
(222, 'Luntha', 'loycemushali@neytechsolutions.com', NULL, NULL, 'loycemushali@neytechsolutions.com', '$2y$10$.u/Is1iKX510L2spEUnl9eh4no4xznJzA4hHlPXWykkI0wpHolH/i', NULL, 'Individual', NULL, NULL, '71041608_5_image.jpg', '16 May 2023', 'Free', 'Yes', 'Active'),
(228, 'Emily Bingo', 'emily.bingo@', NULL, NULL, 'emily.bingo@', '$2y$10$ii9UqHGEWoiLjEnVTs3ve.95CYgEuplgm5wVI.Pak5L4Pkt1pVCae', NULL, 'Individual', NULL, NULL, '', '01 June 2023', 'Free', 'Yes', 'Active'),
(229, 'Dr Paxton Zozie', 'pzozie@gmail.com', NULL, NULL, 'pzozie@gmail.com', '$2y$10$0.scv4nC8O7EgzagiYDT4OqLXhOthv4lxTI6S8uYpZmpfxdtEeLJW', NULL, 'Individual', NULL, NULL, '', '01 June 2023', 'Free', 'Yes', 'Active'),
(231, 'Kondwani', 'info@neytechsolutions.com', NULL, NULL, 'info@neytechsolutions.com', '$2y$10$bO1.wabKEkVrX8nM2Mxv6OLKnfsmJCvF1.tFr4YC3.hHNmvibacUG', NULL, 'Individual', NULL, NULL, 'WhatsApp Image 2023-06-02 at 10.10.51 (1).jpeg', '03 June 2023', 'Free', 'Yes', NULL),
(249, 'Ishmael Mwalwanda', 'mwalwandaishmael@gmail.com', NULL, NULL, 'mwalwandaishmael@gmail.com', '$2y$10$/VLiJdHD9HGJKIbe1yY9H.mD4FFag.AAt8RQj.zeJ5EC2m4qoGSEG', NULL, 'Individual', NULL, NULL, 'download (3).png', '24 July 2023', 'Free', 'Yes', NULL),
(262, 'Angella Nyirongo ', 'anyirongo993@gmail.com', NULL, NULL, 'anyirongo993@gmail.com', '$2y$10$3j3mH1PxmRbG3Gobdv79EO/SdD59mu69OOUlPV3nHhr2LgL/DPnuO', NULL, 'Individual', NULL, NULL, '16903832560746615273267736946191.jpg', '26 July 2023', 'Free', 'Yes', NULL),
(275, 'Limbani', 'christophermsatilomo@gmail.com', NULL, NULL, 'christophermsatilomo@gmail.com', '$2y$10$0kqfDR.QizSQWzZUvRRWOu2XfjIjhhETfiNxqgUen8ob4YORyu9bS', NULL, 'Individual', NULL, NULL, '16904655138047339794248143523521.jpg', '27 July 2023', 'Free', 'Yes', NULL),
(276, 'Fatsani Gunya', 'Fatsani.shgunya@gmail.com', NULL, NULL, 'Fatsani.shgunya@gmail.com', '$2y$10$XqGqAiC.YBs.KzWVPny77OcWaK6k2lrzQexl8bwksAkQFoZ7oCVSa', NULL, 'Individual', NULL, NULL, 'FB_IMG_1657298312003.jpg', '27 July 2023', 'Free', 'Yes', NULL),
(277, 'Andrewclown', 'anomarzen1979@mail.ru', NULL, NULL, 'anomarzen1979@mail.ru', '$2y$10$RYK.S0QKI9y/APyCIY8sAOzI5BiDETXQNwZu4YL8cps.Gre3OxWXS', NULL, 'Individual', NULL, NULL, '', '21 September 2023', 'Free', 'Yes', NULL),
(278, 'DSGVSG', '09de9e8ebf@emailboxa.online', NULL, NULL, '09de9e8ebf@emailboxa.online', '$2y$10$a/zhP7z7pCg/IMuieA6Y9OgKawfT2xaOL8CUawpWDfVEtdtlvv4f6', NULL, 'Individual', NULL, NULL, 'Razz2.php', '05 October 2023', 'Free', 'Yes', NULL),
(279, 'gwerdx23fdsdfsssdfsfsgsddds_www.google.com 462', 'ptag753@gmail.com', NULL, NULL, 'ptag753@gmail.com', '$2y$10$Qt0kkuB9KCgAmQjvvH0/kOvbf395OM3awWuxgx9IddiTyKmppTf0i', NULL, 'Individual', NULL, NULL, '', '12 October 2023', 'Free', 'Yes', NULL),
(280, 'Mfjejdjw uUHHUUJdiwjdiwj твагРГРГРГашоаувауга jhduwifjefheufheuh eufhudfjhuhоа', 'yasen.krasen.13+73589@mail.ru', NULL, NULL, 'yasen.krasen.13+73589@mail.ru', '$2y$10$.qZLEmamA5h6CpDKpF5HYOu6dAhcf7Soz5UcvH9hyJ7K3bABYOfSK', NULL, 'Individual', NULL, NULL, '', '15 October 2023', 'Free', 'Yes', NULL),
(281, 'Igordgs', 's.h.k.ut.kov.i.g.ore.c.z.ekbest@gmail.com\r\n', NULL, NULL, 's.h.k.ut.kov.i.g.ore.c.z.ekbest@gmail.com\r\n', '$2y$10$EELQ.Bj6Wo0vDlWAnAZu7eUaZNRxxl4AyzdzIW/SuxF7iwDLbR8Wu', NULL, 'Individual', NULL, NULL, '', '21 October 2023', 'Free', 'Yes', NULL),
(282, 'Svetleke', 'i.rc.z.enk.os.vetla.n.as.2.030@gmail.com\r\n', NULL, NULL, 'i.rc.z.enk.os.vetla.n.as.2.030@gmail.com\r\n', '$2y$10$iiykM1H9BFHTgeIizaxdB.EdIutC89pEWvAlALnplPTMu.YVQkWMO', NULL, 'Individual', NULL, NULL, '', '26 October 2023', 'Free', 'Yes', NULL),
(283, 'Sergxvu', 's.t.r.iuo.ko.ff.s.t.i.ff.alm.o.st@gmail.com\r\n', NULL, NULL, 's.t.r.iuo.ko.ff.s.t.i.ff.alm.o.st@gmail.com\r\n', '$2y$10$X9l4EQw/i90h4d/F9Z7.Iu4Aarvb1BafMpC9QrTPIANqr6UWkWD0u', NULL, 'Individual', NULL, NULL, '', '29 October 2023', 'Free', 'Yes', NULL),
(284, 'Igorovv', 'sh.k.utkov.ig.o.rec.z.e.k.be.st@gmail.com\r\n', NULL, NULL, 'sh.k.utkov.ig.o.rec.z.e.k.be.st@gmail.com\r\n', '$2y$10$OAPyRxVUHrdSzqYShMaoOum.TJfHTUwtOi33jFkztYl3uP8S2o.lS', NULL, 'Individual', NULL, NULL, '', '29 October 2023', 'Free', 'Yes', NULL),
(285, 'Svetlxfu', 'i.rc.z.e.nko.sve.t.la.n.a.s.2.0.30@gmail.com\r\n', NULL, NULL, 'i.rc.z.e.nko.sve.t.la.n.a.s.2.0.30@gmail.com\r\n', '$2y$10$HLH2rzT3H3oM5m09MOfLf.YGtq/y5FBxhjiqALDAWYM.PaUYW0LUm', NULL, 'Individual', NULL, NULL, '', '29 October 2023', 'Free', 'Yes', NULL),
(286, 'Sergogb', 's.t.r.iuo.ko.f.fs.t.i.ffa.lm.ost@gmail.com\r\n', NULL, NULL, 's.t.r.iuo.ko.f.fs.t.i.ffa.lm.ost@gmail.com\r\n', '$2y$10$o90sr5dbAZKd8bx4MNcIv.ladxMuapnD6oMxErA7DrKGE5znoSmbq', NULL, 'Individual', NULL, NULL, '', '30 October 2023', 'Free', 'Yes', NULL),
(287, 'Igorlww', 'shku.t.k.o.vigo.re.c.ze.kb.e.s.t@gmail.com\r\n', NULL, NULL, 'shku.t.k.o.vigo.re.c.ze.kb.e.s.t@gmail.com\r\n', '$2y$10$VsPmT0Mn1xJ0is78HJVlSO.51u8sHoN.DpQwy5ivxVDgIMejtj2wi', NULL, 'Individual', NULL, NULL, '', '30 October 2023', 'Free', 'Yes', NULL),
(288, 'Svetlnuz', 'ircz.e.nk.o.svetl.an.as.2.0.30@gmail.com\r\n', NULL, NULL, 'ircz.e.nk.o.svetl.an.as.2.0.30@gmail.com\r\n', '$2y$10$NPxyPNkOXl36vzZ/aK/7yOCS0eQU.YtPzZM9Y9TG.HWq4sE1KnAN6', NULL, 'Individual', NULL, NULL, '', '30 October 2023', 'Free', 'Yes', NULL),
(289, 'Sergtua', 's.tr.iu.o.k.o.ff.sti.f.f.a.lm.os.t@gmail.com\r\n', NULL, NULL, 's.tr.iu.o.k.o.ff.sti.f.f.a.lm.os.t@gmail.com\r\n', '$2y$10$eAx6lbMalWoSfFDwQqNWgeo6nFxydpOtFQowY1XXzIA6D4uC7hHRC', NULL, 'Individual', NULL, NULL, '', '30 October 2023', 'Free', 'Yes', NULL),
(290, 'Igorpvp', 's.hk.u.t.k.o.vigorec.ze.k.bes.t@gmail.com\r\n', NULL, NULL, 's.hk.u.t.k.o.vigorec.ze.k.bes.t@gmail.com\r\n', '$2y$10$JkbfeW.Zf8Jo5fRjvS5o1eA7nWNFMoEdYfA0UcOY2eWH7f294eS3.', NULL, 'Individual', NULL, NULL, '', '30 October 2023', 'Free', 'Yes', NULL),
(291, 'Svetlacw', 'ir.cze.nk.os.v.et.l.a.n.a.s2.0.30@gmail.com\r\n', NULL, NULL, 'ir.cze.nk.os.v.et.l.a.n.a.s2.0.30@gmail.com\r\n', '$2y$10$CnyC2SuznztgEFxJ.eL9b.YeHYnT1PF/xKV5lWh5vcbKbLOE2R1IW', NULL, 'Individual', NULL, NULL, '', '30 October 2023', 'Free', 'Yes', NULL),
(292, 'Sergchv', 's.t.r.iuo.ko.ffs.ti.ff.a.lm.o.s.t@gmail.com\r\n', NULL, NULL, 's.t.r.iuo.ko.ffs.ti.ff.a.lm.o.s.t@gmail.com\r\n', '$2y$10$du./GiXuCDGKPeIGFBzgXeoUPUnZBi1XHxCxA93TorXNzZQm7HgzS', NULL, 'Individual', NULL, NULL, '', '31 October 2023', 'Free', 'Yes', NULL),
(293, 'Svetlykw', 'ir.czen.k.osv.e.t.la.nas.2.0.30@gmail.com\r\n', NULL, NULL, 'ir.czen.k.osv.e.t.la.nas.2.0.30@gmail.com\r\n', '$2y$10$cgtiCX3lMpJxOTN2xBSXPO1Y3gzwbrvwGSCQJ0E3UTiaGFE67tJk.', NULL, 'Individual', NULL, NULL, '', '31 October 2023', 'Free', 'Yes', NULL),
(294, 'Igormwp', 'sh.k.u.tk.o.vi.go.r.ec.z.e.k.b.est@gmail.com\r\n', NULL, NULL, 'sh.k.u.tk.o.vi.go.r.ec.z.e.k.b.est@gmail.com\r\n', '$2y$10$prS48hUCsGuLsJoMHrQnu.3Y.uFZ67kV/G/KlS.ac6/nxKIIDh1Na', NULL, 'Individual', NULL, NULL, '', '31 October 2023', 'Free', 'Yes', NULL),
(295, 'Svetluaw', 'i.r.c.z.e.n.k.osv.et.l.an.a.s.20.3.0@gmail.com\r\n', NULL, NULL, 'i.r.c.z.e.n.k.osv.et.l.an.a.s.20.3.0@gmail.com\r\n', '$2y$10$neESCa9cLOBdVJaLVFBeNePq0cd2Oic2HNr2uV3TPK1nTCLkdyHt.', NULL, 'Individual', NULL, NULL, '', '31 October 2023', 'Free', 'Yes', NULL),
(296, 'Serggqe', 's.t.riu.o.koff.s.t.iff.alm.os.t@gmail.com\r\n', NULL, NULL, 's.t.riu.o.koff.s.t.iff.alm.os.t@gmail.com\r\n', '$2y$10$bzH3o3eXRlwwPG.HzMufd.KffFPX1iqQRei9aVNRYLYrrikll/cD6', NULL, 'Individual', NULL, NULL, '', '31 October 2023', 'Free', 'Yes', NULL),
(297, 'Igorhub', 'shk.utk.ov.i.g.orec.zekbe.st@gmail.com\r\n', NULL, NULL, 'shk.utk.ov.i.g.orec.zekbe.st@gmail.com\r\n', '$2y$10$h3Qw5e/..2TD67cMLtQ.eewLTKx3jV9m5yMgkdR9hI3tNdPpRNP0e', NULL, 'Individual', NULL, NULL, '', '31 October 2023', 'Free', 'Yes', NULL),
(298, 'Svetlhlx', 'irc.zen.k.o.s.v.etl.a.n.a.s2.03.0@gmail.com\r\n', NULL, NULL, 'irc.zen.k.o.s.v.etl.a.n.a.s2.03.0@gmail.com\r\n', '$2y$10$LByMpdWf6aeQm528VYnRue8KMkXW75DAaxonbqpmdVM.knmb8p6ye', NULL, 'Individual', NULL, NULL, '', '01 November 2023', 'Free', 'Yes', NULL),
(299, 'Sergmiu', 'striu.ok.o.f.f.st.i.ffalm.os.t@gmail.com\r\n', NULL, NULL, 'striu.ok.o.f.f.st.i.ffalm.os.t@gmail.com\r\n', '$2y$10$F2FMxbVn6mQfIZ5t9hwEBu70cfW8sdGwKJkNGbvfJpd0QSP37AsBC', NULL, 'Individual', NULL, NULL, '', '01 November 2023', 'Free', 'Yes', NULL),
(300, 'Igorhee', 'sh.k.u.t.kov.i.gor.e.c.zekb.es.t@gmail.com\r\n', NULL, NULL, 'sh.k.u.t.kov.i.gor.e.c.zekb.es.t@gmail.com\r\n', '$2y$10$DOaKdS1YrxGUjOlLQrqV8eAJwQyHisja0QsOjej0bAWKgvW7MatHG', NULL, 'Individual', NULL, NULL, '', '01 November 2023', 'Free', 'Yes', NULL),
(301, 'Svetlanadbt', 'kricz.ik.ovay.as.ve.t.la.na@gmail.com\r\n', NULL, NULL, 'kricz.ik.ovay.as.ve.t.la.na@gmail.com\r\n', '$2y$10$coET74FRS62AkvBHwdi7J.r4KU8c4ltOCaOxZNTxQq1/YuMlBwHOG', NULL, 'Individual', NULL, NULL, '', '02 November 2023', 'Free', 'Yes', NULL),
(302, 'Irinrss', 'i.rin.a.20.20.k.o.b.za.r.2.02.0@gmail.com\r\n', NULL, NULL, 'i.rin.a.20.20.k.o.b.za.r.2.02.0@gmail.com\r\n', '$2y$10$8P9YFbC9EdsQBJPLiulsQOyU219v5ZjBYCqJneK7M3uFe.8Pdia16', NULL, 'Individual', NULL, NULL, '', '02 November 2023', 'Free', 'Yes', NULL),
(303, 'Veronagmy', 've.ro.n.i.k.a.sl.o.bo.da.nov.ich@gmail.com\r\n', NULL, NULL, 've.ro.n.i.k.a.sl.o.bo.da.nov.ich@gmail.com\r\n', '$2y$10$1geJfq51VjcyEMquuJXBwOOzRxeytk31O9JmI7s1e.JjY.0XB5IkC', NULL, 'Individual', NULL, NULL, '', '02 November 2023', 'Free', 'Yes', NULL),
(304, 'Svetlanaozk', 'kr.icz.i.k.ov.ay.as.vet.l.a.n.a@gmail.com\r\n', NULL, NULL, 'kr.icz.i.k.ov.ay.as.vet.l.a.n.a@gmail.com\r\n', '$2y$10$z/RqrVMURmFkiLsyZjUVXuDlODojMJPWdf3R3L/nbMQFuvUXvzZzW', NULL, 'Individual', NULL, NULL, '', '03 November 2023', 'Free', 'Yes', NULL),
(305, 'Svetlanaryf', 'k.r.ic.zikovayas.vet.la.n.a@gmail.com\r\n', NULL, NULL, 'k.r.ic.zikovayas.vet.la.n.a@gmail.com\r\n', '$2y$10$WFfXYQBtOjjQQEab90ZoSOsizV7oM39s7yM9ADetDYJjNP9eJa04y', NULL, 'Individual', NULL, NULL, '', '03 November 2023', 'Free', 'Yes', NULL),
(306, 'Irindbq', 'i.r.i.na2020.k.ob.z.ar20.2.0@gmail.com\r\n', NULL, NULL, 'i.r.i.na2020.k.ob.z.ar20.2.0@gmail.com\r\n', '$2y$10$zc6e5y89rXwEqmYSHi4ng.qDNeOvSv0Es6ipfFtZWduHrE4xJmSX2', NULL, 'Individual', NULL, NULL, '', '03 November 2023', 'Free', 'Yes', NULL),
(307, 'Veronaedf', 'v.er.o.n.i.k.as.lob.od.a.n.o.v.ic.h@gmail.com\r\n', NULL, NULL, 'v.er.o.n.i.k.as.lob.od.a.n.o.v.ic.h@gmail.com\r\n', '$2y$10$Q8Atfltc6vrEBpZnkixOZulAfHqZCSTFTRKwUeK52W3hlWJp/GSd.', NULL, 'Individual', NULL, NULL, '', '03 November 2023', 'Free', 'Yes', NULL),
(308, 'Svetlanampl', 'kr.i.cz.i.kov.aya.s.v.etla.na@gmail.com\r\n', NULL, NULL, 'kr.i.cz.i.kov.aya.s.v.etla.na@gmail.com\r\n', '$2y$10$PUVHxNvJx6CaoqDsMK262OscJkbCo5dSZP1AaZo7gxlIoLQw9arjW', NULL, 'Individual', NULL, NULL, '', '04 November 2023', 'Free', 'Yes', NULL),
(309, 'Irinhwf', 'ir.ina.2.0.2.0k.o.b.zar.2.020@gmail.com\r\n', NULL, NULL, 'ir.ina.2.0.2.0k.o.b.zar.2.020@gmail.com\r\n', '$2y$10$feJ.UyBpiX.Q14MKVgYBA.AQUJ4GrD2Kqnhw2MMxyrUFI/3psCQBW', NULL, 'Individual', NULL, NULL, '', '04 November 2023', 'Free', 'Yes', NULL),
(310, 'Veronayrn', 'v.e.ro.nikas.lob.od.a.nov.ich@gmail.com\r\n', NULL, NULL, 'v.e.ro.nikas.lob.od.a.nov.ich@gmail.com\r\n', '$2y$10$Q3n3zrzulxJ5m8GT6azEvu5ShKqw3dv3aJdpti1nKYq2In8uVhSFq', NULL, 'Individual', NULL, NULL, '', '04 November 2023', 'Free', 'Yes', NULL),
(311, 'Davidvnx', 's.e.m.e.cz.e.n.k.oda.vid.bigm.a.n@gmail.com\r\n', NULL, NULL, 's.e.m.e.cz.e.n.k.oda.vid.bigm.a.n@gmail.com\r\n', '$2y$10$83mD1XOaT0qdC69ZZi0ije.Zys1yRqDS.ftA5iXrxDA/oPoVcRzGK', NULL, 'Individual', NULL, NULL, '', '05 November 2023', 'Free', 'Yes', NULL),
(312, 'Vilianarwo', 'v.i.l.l.a.n.um.or.u.c.hko.m.os.t@gmail.com\r\n', NULL, NULL, 'v.i.l.l.a.n.um.or.u.c.hko.m.os.t@gmail.com\r\n', '$2y$10$MKVuSOC91tiN8.va6olY1uIshx64xVDw75QLdLffb6IPbNuslXbJa', NULL, 'Individual', NULL, NULL, '', '05 November 2023', 'Free', 'Yes', NULL),
(313, 'Leonxfh', 'le.on.i.ds.hko.r.obenkov.v.y.a@gmail.com\r\n', NULL, NULL, 'le.on.i.ds.hko.r.obenkov.v.y.a@gmail.com\r\n', '$2y$10$90u/cixM7GOzVFIviQ4jd.iU8R8/bxcCxS16ZJClfydWiXu51bfuC', NULL, 'Individual', NULL, NULL, '', '05 November 2023', 'Free', 'Yes', NULL),
(314, 'Davidbnj', 'sem.e.czenko.david.bi.gm.an@gmail.com\r\n', NULL, NULL, 'sem.e.czenko.david.bi.gm.an@gmail.com\r\n', '$2y$10$UWqQPxCG4AbZpaM7OUPP9uxr4u3jIGiBiHwfTdvFklrSNlRXmY2jq', NULL, 'Individual', NULL, NULL, '', '06 November 2023', 'Free', 'Yes', NULL),
(315, 'Leondbi', 'leon.i.d.s.h.k.o.robe.nk.ov.v.ya@gmail.com\r\n', NULL, NULL, 'leon.i.d.s.h.k.o.robe.nk.ov.v.ya@gmail.com\r\n', '$2y$10$fNTgYA4zoa1pp0yV6OU2De4jfzxoGVfK7J01ENZVivKYUDzEM7KKS', NULL, 'Individual', NULL, NULL, '', '06 November 2023', 'Free', 'Yes', NULL),
(316, 'Vilianavur', 'v.i.ll.a.num.or.u.ch.kom.o.s.t@gmail.com\r\n', NULL, NULL, 'v.i.ll.a.num.or.u.ch.kom.o.s.t@gmail.com\r\n', '$2y$10$TxTOqH0IpcNcovTndHkKWupusIWCERg8CUJrYgYEkJ3LwYuBgvBBu', NULL, 'Individual', NULL, NULL, '', '06 November 2023', 'Free', 'Yes', NULL),
(317, 'Daviddcp', 'sem.ec.z.enk.od.a.vid.b.igm.a.n@gmail.com\r\n', NULL, NULL, 'sem.ec.z.enk.od.a.vid.b.igm.a.n@gmail.com\r\n', '$2y$10$.9ZTEYYdDk/4KBdlMXZEJe4LPIrlhTR1ySd4fSR8pVkVQbHt4KRe6', NULL, 'Individual', NULL, NULL, '', '07 November 2023', 'Free', 'Yes', NULL),
(318, 'Leonpww', 'l.e.oni.dsh.koroben.k.o.v.v.ya@gmail.com\r\n', NULL, NULL, 'l.e.oni.dsh.koroben.k.o.v.v.ya@gmail.com\r\n', '$2y$10$ASjiQIIGI6Ew2WjsVL256.OhsI5spmi9BJc3dXAMStbbcaFV1m6wK', NULL, 'Individual', NULL, NULL, '', '07 November 2023', 'Free', 'Yes', NULL),
(319, 'Vilianaxdc', 'vi.l.l.a.n.u.m.o.ru.chkomos.t@gmail.com\r\n', NULL, NULL, 'vi.l.l.a.n.u.m.o.ru.chkomos.t@gmail.com\r\n', '$2y$10$RQTSYOr9AG2poOLKkEEBSe/eHkdxHmFU0fnPYhk1yJT/VTj.EGrZi', NULL, 'Individual', NULL, NULL, '', '07 November 2023', 'Free', 'Yes', NULL),
(320, 'Leonubs', 'l.eo.nid.sh.k.orob.en.ko.v.v.ya@gmail.com\r\n', NULL, NULL, 'l.eo.nid.sh.k.orob.en.ko.v.v.ya@gmail.com\r\n', '$2y$10$Y15syqqBwDTN4FqwspAnS.4gBvp.oPjE.bqlaQj0u4cE.d67Rmzve', NULL, 'Individual', NULL, NULL, '', '07 November 2023', 'Free', 'Yes', NULL),
(321, 'Davidqnf', 'se.me.c.ze.n.koda.vi.dbi.g.m.an@gmail.com\r\n', NULL, NULL, 'se.me.c.ze.n.koda.vi.dbi.g.m.an@gmail.com\r\n', '$2y$10$tpIhEwxfgwP4OZuQorevu.EV2TthUuDdAIFaWVEUYV54mMcULebf6', NULL, 'Individual', NULL, NULL, '', '07 November 2023', 'Free', 'Yes', NULL),
(322, 'Vilianayox', 'v.il.l.a.nu.mo.r.u.ch.k.o.most@gmail.com\r\n', NULL, NULL, 'v.il.l.a.nu.mo.r.u.ch.k.o.most@gmail.com\r\n', '$2y$10$7kdAvrJCSqCDYOsCQkN3ee.jCV3HeWbj6rdtUFrbP.75RO8aUPqOe', NULL, 'Individual', NULL, NULL, '', '07 November 2023', 'Free', 'Yes', NULL),
(323, 'Juliibs', 'anj.e.l.i.ka.l.o.pistu.c.kl.o.ve@gmail.com\r\n', NULL, NULL, 'anj.e.l.i.ka.l.o.pistu.c.kl.o.ve@gmail.com\r\n', '$2y$10$tMI4IeRBNnGRCmX0v5jggOuf5MDLBGGunm9PDloM/fx8Zc3uv/Nn.', NULL, 'Individual', NULL, NULL, '', '08 November 2023', 'Free', 'Yes', NULL),
(324, 'Vikiflp', 'vik.toriyas.k.u.c.hk.o19.99@gmail.com\r\n', NULL, NULL, 'vik.toriyas.k.u.c.hk.o19.99@gmail.com\r\n', '$2y$10$chATKhXt9YHfFP2V/yQU9.lWXcnIN7JsccjnQJ1Zl5UmuKXc6BopO', NULL, 'Individual', NULL, NULL, '', '08 November 2023', 'Free', 'Yes', NULL),
(325, 'Serzcsu', 'ser.zkr.u.togo.lo.v.th.e.m.an@gmail.com\r\n', NULL, NULL, 'ser.zkr.u.togo.lo.v.th.e.m.an@gmail.com\r\n', '$2y$10$NseG37Ha9GzEv3OnCoA0JOX.1yQ9yZvL7b2Pq6wTdFczMSptKx6Xa', NULL, 'Individual', NULL, NULL, '', '08 November 2023', 'Free', 'Yes', NULL),
(326, 'Vikitnh', 'vik.t.o.riya.sk.u.c.h.k.o.1.999@gmail.com\r\n', NULL, NULL, 'vik.t.o.riya.sk.u.c.h.k.o.1.999@gmail.com\r\n', '$2y$10$DmqFiaGCuiDAB.y7dY/EzOREJfMKpNANFIUpI2Nzl83QpRkbIAaTS', NULL, 'Individual', NULL, NULL, '', '08 November 2023', 'Free', 'Yes', NULL),
(327, 'Julipeb', 'anj.eli.ka.l.o.pi.s.tuc.k.lov.e@gmail.com\r\n', NULL, NULL, 'anj.eli.ka.l.o.pi.s.tuc.k.lov.e@gmail.com\r\n', '$2y$10$9UY/oVe8fG7H5yZ31EIAe.Jo3cJ5a4TUAlLIyoqSnlBncRG//FXOy', NULL, 'Individual', NULL, NULL, '', '08 November 2023', 'Free', 'Yes', NULL),
(328, 'Serzuiv', 's.er.zk.ru.t.o.g.o.l.o.vth.eman@gmail.com\r\n', NULL, NULL, 's.er.zk.ru.t.o.g.o.l.o.vth.eman@gmail.com\r\n', '$2y$10$tLNMhGI83MiZswYvvpr1fuWBiFa8fY0N/G0U1MuBUfoDnWpg1uy6a', NULL, 'Individual', NULL, NULL, '', '09 November 2023', 'Free', 'Yes', NULL),
(329, 'Vikinwd', 'vi.k.tori.ya.s.k.uchko1.99.9@gmail.com\r\n', NULL, NULL, 'vi.k.tori.ya.s.k.uchko1.99.9@gmail.com\r\n', '$2y$10$jw3lIRxEvS/fuN4cevvVzewDijFEtzyFF4Zs8GNy4b6cMKBNNQG.O', NULL, 'Individual', NULL, NULL, '', '09 November 2023', 'Free', 'Yes', NULL),
(330, 'Juligoq', 'anje.l.ik.a.l.o.pist.u.c.kl.ov.e@gmail.com\r\n', NULL, NULL, 'anje.l.ik.a.l.o.pist.u.c.kl.ov.e@gmail.com\r\n', '$2y$10$Icf7ewjbFhv32G3Jb2fjs.CnhA5gvHwdJvsUIjiWFuRrOogwEXJgW', NULL, 'Individual', NULL, NULL, '', '09 November 2023', 'Free', 'Yes', NULL),
(331, 'Serzgcq', 's.er.zk.r.ut.o.g.olo.v.t.hem.a.n@gmail.com\r\n', NULL, NULL, 's.er.zk.r.ut.o.g.olo.v.t.hem.a.n@gmail.com\r\n', '$2y$10$77AkrhblOB02EWb/WpXoo.kVJZDQkvRTgjgi4dry8CZTtnoQperey', NULL, 'Individual', NULL, NULL, '', '09 November 2023', 'Free', 'Yes', NULL),
(332, 'Vikiqnm', 'v.i.k.t.or.iya.s.k.uchko.1999@gmail.com\r\n', NULL, NULL, 'v.i.k.t.or.iya.s.k.uchko.1999@gmail.com\r\n', '$2y$10$O.WgWBraSwjcVtXAe9ov3.J3u7K9XI20pKwjdhVeETCXFG8EdUFMq', NULL, 'Individual', NULL, NULL, '', '10 November 2023', 'Free', 'Yes', NULL),
(333, 'Julidao', 'an.je.l.ika.l.o.p.i.s.t.u.ck.love@gmail.com\r\n', NULL, NULL, 'an.je.l.ika.l.o.p.i.s.t.u.ck.love@gmail.com\r\n', '$2y$10$qX/Qh0cxBxlFQuMYVkuCmO90i4iunfIMdGq75180r/g5jKhcrcCk2', NULL, 'Individual', NULL, NULL, '', '10 November 2023', 'Free', 'Yes', NULL),
(334, 'Serzbov', 's.er.zkru.t.og.o.l.ov.th.e.m.an@gmail.com\r\n', NULL, NULL, 's.er.zkru.t.og.o.l.ov.th.e.m.an@gmail.com\r\n', '$2y$10$40nWPIderj24hAFrpa.2G.ZUu9WD/ZGvOuD/qums8DesCmLF.RlW6', NULL, 'Individual', NULL, NULL, '', '10 November 2023', 'Free', 'Yes', NULL),
(335, 'Juliqjv', 'an.j.elika.l.o.pi.st.u.cklove@gmail.com\r\n', NULL, NULL, 'an.j.elika.l.o.pi.st.u.cklove@gmail.com\r\n', '$2y$10$1ZLFqntQA/eKlKAy/ZKoAeMMP6GKCUVzqS9TvnePtpGSpQF/l9eHe', NULL, 'Individual', NULL, NULL, '', '10 November 2023', 'Free', 'Yes', NULL),
(336, 'Serzcvx', 's.erzk.r.u.t.o.g.o.l.ov.t.heman@gmail.com\r\n', NULL, NULL, 's.erzk.r.u.t.o.g.o.l.ov.t.heman@gmail.com\r\n', '$2y$10$Msvj1mk1s6nVYpE7Ujf4e.UIg6/kfNXh5HebmLGLhANnytlVAzATm', NULL, 'Individual', NULL, NULL, '', '10 November 2023', 'Free', 'Yes', NULL),
(337, 'Juliujt', 'anjel.i.k.a.l.opi.stu.c.klo.ve@gmail.com\r\n', NULL, NULL, 'anjel.i.k.a.l.opi.stu.c.klo.ve@gmail.com\r\n', '$2y$10$/plifN4z2swqbeODGDfKJO6CTFQzvIrt9nH8cVpnGC1Kkp.VYKqmC', NULL, 'Individual', NULL, NULL, '', '11 November 2023', 'Free', 'Yes', NULL),
(338, 'Evabcc', 'e.v.a.st.o.godu.k.lo.veli.fe@gmail.com\r\n', NULL, NULL, 'e.v.a.st.o.godu.k.lo.veli.fe@gmail.com\r\n', '$2y$10$X2Q/C/BwlwOJvk0WNAE.iecFy49NuQMiDXrwMdAC8KkUdLQbBneLy', NULL, 'Individual', NULL, NULL, '', '11 November 2023', 'Free', 'Yes', NULL),
(339, 'Eldarkrs', 'al.e.ks.e.j.st.uk.oru.kov.20.48@gmail.com\r\n', NULL, NULL, 'al.e.ks.e.j.st.uk.oru.kov.20.48@gmail.com\r\n', '$2y$10$YXirUcTMvt9MSv2YHtQhQOt1XI80YLumIHovRpjItWpZjpjKldWDi', NULL, 'Individual', NULL, NULL, '', '12 November 2023', 'Free', 'Yes', NULL),
(340, 'Robqvm', 'rob.e.r.t.bro.w.n.m.o.onm.a.ns@gmail.com\r\n', NULL, NULL, 'rob.e.r.t.bro.w.n.m.o.onm.a.ns@gmail.com\r\n', '$2y$10$.nC4bk/JwilCNbGkGCvuwe2qdCvGnlkQBHA.GIShD/COF49QaVN3a', NULL, 'Individual', NULL, NULL, '', '12 November 2023', 'Free', 'Yes', NULL),
(341, 'Evaaqy', 'ev.a.st.og.oduk.l.ove.lif.e@gmail.com\r\n', NULL, NULL, 'ev.a.st.og.oduk.l.ove.lif.e@gmail.com\r\n', '$2y$10$eskfkgJzuXJqTFyi0XjpoeAdAr4orC9losGCcsugxjS9SJQPhdH6m', NULL, 'Individual', NULL, NULL, '', '12 November 2023', 'Free', 'Yes', NULL),
(342, 'Robedu', 'ro.b.er.t.b.r.o.wn.m.o.o.n.m.ans@gmail.com\r\n', NULL, NULL, 'ro.b.er.t.b.r.o.wn.m.o.o.n.m.ans@gmail.com\r\n', '$2y$10$nnCJTQpja1vwrC/t8zNFSOoWHIdYciXOQl1.YYpRMbxxpu4PSIWt.', NULL, 'Individual', NULL, NULL, '', '12 November 2023', 'Free', 'Yes', NULL),
(343, 'Robogs', 'r.ob.e.r.tb.row.n.m.oonm.a.ns@gmail.com\r\n', NULL, NULL, 'r.ob.e.r.tb.row.n.m.oonm.a.ns@gmail.com\r\n', '$2y$10$jC3ONol5Fd.A1jNmA4VOuuAttGBVYlPJpTp2vijy7jLGjTOF4l9wm', NULL, 'Individual', NULL, NULL, '', '13 November 2023', 'Free', 'Yes', NULL),
(344, 'Evauhv', 'e.v.a.st.o.god.uklo.v.e.life@gmail.com\r\n', NULL, NULL, 'e.v.a.st.o.god.uklo.v.e.life@gmail.com\r\n', '$2y$10$9I6QE5.TDVDPviyluBZfZOtNy3qV/tJY/00qCKeBeKuPvt2.KSv2e', NULL, 'Individual', NULL, NULL, '', '13 November 2023', 'Free', 'Yes', NULL),
(345, 'Eldarqge', 'a.lek.s.ej.s.tu.kor.uko.v.20.48@gmail.com\r\n', NULL, NULL, 'a.lek.s.ej.s.tu.kor.uko.v.20.48@gmail.com\r\n', '$2y$10$A7LohQwgqMxr7risXYbc7uLh2H1H/FFor8sLV2A.1IKkHhn4zhM/q', NULL, 'Individual', NULL, NULL, '', '14 November 2023', 'Free', 'Yes', NULL),
(346, 'Roboff', 'rob.ertb.r.o.w.nm.oo.n.ma.n.s@gmail.com\r\n', NULL, NULL, 'rob.ertb.r.o.w.nm.oo.n.ma.n.s@gmail.com\r\n', '$2y$10$..d2ymRKy.YWPDPFwNNmce1WP68mFjMBhDS/fQkSig6MAvZIareY.', NULL, 'Individual', NULL, NULL, '', '14 November 2023', 'Free', 'Yes', NULL),
(347, 'Evafen', 'evast.o.g.o.d.u.k.lo.v.e.li.fe@gmail.com\r\n', NULL, NULL, 'evast.o.g.o.d.u.k.lo.v.e.li.fe@gmail.com\r\n', '$2y$10$vNiOr5Pf841WpJ7AopNkIOc7mMe3rscuK9sKHyoBLb0I/7LyAzG2O', NULL, 'Individual', NULL, NULL, '', '14 November 2023', 'Free', 'Yes', NULL),
(348, 'Sope Msuku ', 'sopranosope@gmail.com', NULL, NULL, 'sopranosope@gmail.com', '$2y$10$UPhnCXaQ1k0TsG1bYKn7U.T/0RuZEE3X48fqu1E5kuEHZmOnXMi72', NULL, 'Individual', NULL, NULL, 'IMG_20230113_063619.jpg', '15 November 2023', 'Free', 'Yes', NULL),
(349, 'Evakfp', 'e.v.a.st.o.g.o.d.u.kl.ov.e.l.ife@gmail.com\r\n', NULL, NULL, 'e.v.a.st.o.g.o.d.u.kl.ov.e.l.ife@gmail.com\r\n', '$2y$10$qzq8.TYOrQFWSwfbIebiju/QiT0RtVVvOxTqdewQ34C.5U5/3O3R2', NULL, 'Individual', NULL, NULL, '', '15 November 2023', 'Free', 'Yes', NULL),
(350, 'Barros Mweso ', 'mwesobarros@gmail.com', NULL, NULL, 'mwesobarros@gmail.com', '$2y$10$3iDNHaF0U1kRs37wWHHmmectJjihvEPoHIgG8imh9LyxeRrnNbf6u', NULL, 'Individual', NULL, NULL, 'Screenshot_20231114-192139_Facebook.jpg', '15 November 2023', 'Free', 'Yes', NULL),
(351, 'Eldarpud', 'ale.ks.e.j.s.t.uk.oru.ko.v2.04.8@gmail.com\r\n', NULL, NULL, 'ale.ks.e.j.s.t.uk.oru.ko.v2.04.8@gmail.com\r\n', '$2y$10$3I8FYxA15ocq9d4wHGSEf.ylmNA9ouQ.BPXsyOvoTf4rvvyd28Hdm', NULL, 'Individual', NULL, NULL, '', '15 November 2023', 'Free', 'Yes', NULL),
(352, 'Eldarvdu', 'al.ek.s.e.j.s.t.ukoruk.ov20.4.8@gmail.com\r\n', NULL, NULL, 'al.ek.s.e.j.s.t.ukoruk.ov20.4.8@gmail.com\r\n', '$2y$10$FLQMVI4lw/Hy5qTf5jov2OhajcwtaqEnLtiWH5OmQwJm81ZYX9FSq', NULL, 'Individual', NULL, NULL, '', '15 November 2023', 'Free', 'Yes', NULL),
(353, 'Ilushikmih', 's.kreb.co.viliush.ka20.8.6@gmail.com\r\n', NULL, NULL, 's.kreb.co.viliush.ka20.8.6@gmail.com\r\n', '$2y$10$H0YFyM50XsziU5TKEALVF.uDtfS2dsqzvuUt0RTqlALMONdlQ7NJu', NULL, 'Individual', NULL, NULL, '', '17 November 2023', 'Free', 'Yes', NULL),
(354, 'Margaretkxb', 'ma.rgarel.ovet.rob.er.t.s@gmail.com\r\n', NULL, NULL, 'ma.rgarel.ovet.rob.er.t.s@gmail.com\r\n', '$2y$10$HDPF2ArDZ.bvsvi6rDNhw..OgIHGZSiW7tQO3kXDyq/WG1YryaC5G', NULL, 'Individual', NULL, NULL, '', '17 November 2023', 'Free', 'Yes', NULL),
(355, 'Viktorivbx', 'vikt.or.i.ail.oveb.a.c.kc.h.a.m@gmail.com\r\n', NULL, NULL, 'vikt.or.i.ail.oveb.a.c.kc.h.a.m@gmail.com\r\n', '$2y$10$po.LNagNDcY88NOXdIVGDO6lHld91h0m8NMINuOngDnNtDFduUZce', NULL, 'Individual', NULL, NULL, '', '18 November 2023', 'Free', 'Yes', NULL),
(356, 'Margaretaet', 'ma.r.g.a.r.el.ovet.r.ob.e.rts@gmail.com\r\n', NULL, NULL, 'ma.r.g.a.r.el.ovet.r.ob.e.rts@gmail.com\r\n', '$2y$10$tJ6W/dw./SYHi2jp3t9jmu8utn9yaFLskpshrXMPQiU6ENZsAWcnS', NULL, 'Individual', NULL, NULL, '', '18 November 2023', 'Free', 'Yes', NULL),
(357, 'Ilushikidg', 's.kr.ebco.v.il.i.us.hka20.8.6@gmail.com\r\n', NULL, NULL, 's.kr.ebco.v.il.i.us.hka20.8.6@gmail.com\r\n', '$2y$10$xC9l3y5/PQW1UaK/YzTc1.Ny2B5EpAY4HM7PSDsQre4S49n4.RY62', NULL, 'Individual', NULL, NULL, '', '18 November 2023', 'Free', 'Yes', NULL),
(358, 'Test', 'test@example.com', NULL, NULL, 'test@example.com', '$2y$10$BMb42HsWayfVkxYTGqyKM.c/nvmz6m8jdt7FEvsqH6E9FzB7fpHqG', NULL, 'Individual', NULL, NULL, 'notifications.jpg', '04 December 2023', 'Free', 'Yes', NULL),
(359, 'Nyirongo', 'zogula9@gmail.com', NULL, NULL, 'zogula9@gmail.com', '$2y$10$1nOXdY6vOK6y7eevpEK7Uu65r1MyH5AlVrMwnmgdhFWN8i6x9H7fy', NULL, 'Individual', NULL, NULL, '405297154_252591464496246_3419822780336823586_n.jpg', '04 December 2023', 'Free', 'Yes', NULL),
(360, 'Renatirxu', 'c.h.erep.a.novre.n.at2.3.5079@gmail.com\r\n', NULL, NULL, 'c.h.erep.a.novre.n.at2.3.5079@gmail.com\r\n', '$2y$10$YHGxoml86UnBx1NqMdabz.TXz1oX7/SB3lotawA/JwJP3bzR8huiq', NULL, 'Individual', NULL, NULL, '', '05 December 2023', 'Free', 'Yes', NULL),
(361, 'Veronayqf', 'ver.o.n.as.k.ut.e.nk.oal.l.s.ta.r@gmail.com\r\n', NULL, NULL, 'ver.o.n.as.k.ut.e.nk.oal.l.s.ta.r@gmail.com\r\n', '$2y$10$9E.qQZYx8hm9Pc3L6iVI4eGINE4NvK8d3V6uryYfcSfgcDSNvdYde', NULL, 'Individual', NULL, NULL, '', '05 December 2023', 'Free', 'Yes', NULL),
(362, 'Renatibhs', 'c.he.rep.ano.vr.e.na.t.23.5.0.79@gmail.com\r\n', NULL, NULL, 'c.he.rep.ano.vr.e.na.t.23.5.0.79@gmail.com\r\n', '$2y$10$iiUhAaO85l3kV9d2tGRtE.jits35x7UKlvdK/kp169CG/XvPLe2Ye', NULL, 'Individual', NULL, NULL, '', '07 December 2023', 'Free', 'Yes', NULL),
(363, 'Allapva', 'a.l.l.a.h.ear.t.s.urmani.dz.e@gmail.com\r\n', NULL, NULL, 'a.l.l.a.h.ear.t.s.urmani.dz.e@gmail.com\r\n', '$2y$10$e1zt1lmk3txZ7XROGuk9..EVHM84LvShjj49HPGluv87mdRt9FdAa', NULL, 'Individual', NULL, NULL, '', '07 December 2023', 'Free', 'Yes', NULL),
(364, 'Allamwv', 'allah.ear.t.s.ur.m.anidze@gmail.com\r\n', NULL, NULL, 'allah.ear.t.s.ur.m.anidze@gmail.com\r\n', '$2y$10$3u3qmKO.NDtF9wAs3Yki1ug6VtwqfLxWp0FEfSaNXkiEsHiham/vy', NULL, 'Individual', NULL, NULL, '', '11 December 2023', 'Free', 'Yes', NULL),
(365, 'Renatisue', 'c.h.er.e.p.a.novr.en.a.t2.3.50.7.9@gmail.com\r\n', NULL, NULL, 'c.h.er.e.p.a.novr.en.a.t2.3.50.7.9@gmail.com\r\n', '$2y$10$DgGREMVpTzCMb6dGaCHBBOpiiQuaoYFBa0.bN.6lP9qufe4W7RqyG', NULL, 'Individual', NULL, NULL, '', '11 December 2023', 'Free', 'Yes', NULL),
(366, 'Allapnk', 'a.l.l.ah.ea.rt.s.u.rm.a.ni.dze@gmail.com\r\n', NULL, NULL, 'a.l.l.ah.ea.rt.s.u.rm.a.ni.dze@gmail.com\r\n', '$2y$10$uX/0q26Hm.klc2c.P/UKtOY7TMmXjS22C33RdX3GULl/nP.PiTrua', NULL, 'Individual', NULL, NULL, '', '12 December 2023', 'Free', 'Yes', NULL),
(367, 'Renatiogj', 'c.her.e.pano.v.r.e.nat.23.507.9@gmail.com\r\n', NULL, NULL, 'c.her.e.pano.v.r.e.nat.23.507.9@gmail.com\r\n', '$2y$10$oE6/7W4rknnses9MEK3jjuc70rjFH6agFyb3DKltw1yetu8cFfMze', NULL, 'Individual', NULL, NULL, '', '12 December 2023', 'Free', 'Yes', NULL),
(368, 'Allaigu', 'a.ll.ahe.ar.t.sur.mani.dz.e@gmail.com\r\n', NULL, NULL, 'a.ll.ahe.ar.t.sur.mani.dz.e@gmail.com\r\n', '$2y$10$VSaNOY3rjWZulQGUx/2QneaGNwO343bpBUSJbhMpX0VfU4KGIPSg2', NULL, 'Individual', NULL, NULL, '', '14 December 2023', 'Free', 'Yes', NULL),
(369, 'Juliaaoqh', 'ju.li.aa.l.l.be.s.t.ro.b.er.tss@gmail.com\r\n', NULL, NULL, 'ju.li.aa.l.l.be.s.t.ro.b.er.tss@gmail.com\r\n', '$2y$10$Ko7o1Tz4HxJ7tGUO4/cOU.P88D46Oqg5Fa.KuC55AV1F0aLnIMFCe', NULL, 'Individual', NULL, NULL, '', '15 December 2023', 'Free', 'Yes', NULL),
(370, 'Svetldjb', 'ir.czenkosv.etl.a.n.a.s2.03.0@gmail.com\r\n', NULL, NULL, 'ir.czenkosv.etl.a.n.a.s2.03.0@gmail.com\r\n', '$2y$10$TPJgftDHP0d4YuGb7tTdXuO5AQsQYfJdwTx3WK6o2gVnA45UVjq6a', NULL, 'Individual', NULL, NULL, '', '16 December 2023', 'Free', 'Yes', NULL),
(371, 'Juliaaogs', 'j.ul.ia.al.l.be.str.obe.r.t.s.s@gmail.com\r\n', NULL, NULL, 'j.ul.ia.al.l.be.str.obe.r.t.s.s@gmail.com\r\n', '$2y$10$GXYqReOYX8l0NLM8kxSsOODeDKaFvu95AlQEc5uF96bioK4vSbY8W', NULL, 'Individual', NULL, NULL, '', '17 December 2023', 'Free', 'Yes', NULL),
(372, 'Juliaatmr', 'j.ul.i.a.all.bes.tr.o.b.er.ts.s@gmail.com\r\n', NULL, NULL, 'j.ul.i.a.all.bes.tr.o.b.er.ts.s@gmail.com\r\n', '$2y$10$5bpNxDUQ5pX.ZX0F9YzdouMvqQjANs.KqpkPl7Ic8t07m8Ghotdw6', NULL, 'Individual', NULL, NULL, '', '18 December 2023', 'Free', 'Yes', NULL),
(373, 'Juliaaubb', 'ju.liaal.l.b.e.s.t.r.o.be.r.tss@gmail.com\r\n', NULL, NULL, 'ju.liaal.l.b.e.s.t.r.o.be.r.tss@gmail.com\r\n', '$2y$10$IeCDoAxF0zxr/H/EP2S6O.1aLfLMbp6qH6eLUqFaQEh46wE2AN7x2', NULL, 'Individual', NULL, NULL, '', '20 December 2023', 'Free', 'Yes', NULL),
(374, 'Igorvne', 's.hk.u.t.kovig.ore.c.z.e.kb.est@gmail.com\r\n', NULL, NULL, 's.hk.u.t.kovig.ore.c.z.e.kb.est@gmail.com\r\n', '$2y$10$ooXCkKXe/La9RvgeXGg.0eYJp91CEYx9ejXWb3XiPQ35WLs6d5fuy', NULL, 'Individual', NULL, NULL, '', '20 December 2023', 'Free', 'Yes', NULL),
(375, 'Juliaaihd', 'julia.al.l.b.es.t.r.o.be.rts.s@gmail.com\r\n', NULL, NULL, 'julia.al.l.b.es.t.r.o.be.rts.s@gmail.com\r\n', '$2y$10$K3mH.QL.lxddU9Mnhm4OIO/f8fLo7hRHq6dvR58cwUGEYQR3gOuV6', NULL, 'Individual', NULL, NULL, '', '21 December 2023', 'Free', 'Yes', NULL),
(376, 'Igorguy', 's.hkut.kovi.g.ore.cze.kb.e.s.t@gmail.com\r\n', NULL, NULL, 's.hkut.kovi.g.ore.cze.kb.e.s.t@gmail.com\r\n', '$2y$10$OH2.4Hzg99WeasFkgx52CuG3BoPEvYY/xPnKzMLXzAATJs9PXy1FG', NULL, 'Individual', NULL, NULL, '', '22 December 2023', 'Free', 'Yes', NULL),
(377, 'Svetlqlx', 'ircz.e.nko.sv.e.tl.a.na.s2.0.30@gmail.com\r\n', NULL, NULL, 'ircz.e.nko.sv.e.tl.a.na.s2.0.30@gmail.com\r\n', '$2y$10$wUrzbWyMctGY/DWhRKMEjeJdhiVP9Cs21gMR/S0UAaAWuMUvHmJyW', NULL, 'Individual', NULL, NULL, '', '22 December 2023', 'Free', 'Yes', NULL),
(378, 'Svetlanavgf', 'kri.cz.ikovay.a.s.vet.l.an.a@gmail.com\r\n', NULL, NULL, 'kri.cz.ikovay.a.s.vet.l.an.a@gmail.com\r\n', '$2y$10$DVtBYY7GcGlOi47HVXZigOSZBQAqgAOrmYFazmC0whQM6cDz12zce', NULL, 'Individual', NULL, NULL, '', '22 December 2023', 'Free', 'Yes', NULL),
(379, 'Svetlanaexh', 'kr.ic.zikov.a.y.asv.e.tl.ana@gmail.com\r\n', NULL, NULL, 'kr.ic.zikov.a.y.asv.e.tl.ana@gmail.com\r\n', '$2y$10$FspQJqxG8GE9UrawZg5OouGKVXrNSTveILf0VS/vM/OUoqWmKjujq', NULL, 'Individual', NULL, NULL, '', '22 December 2023', 'Free', 'Yes', NULL),
(380, 'Igorxuw', 's.h.ku.tk.o.v.igo.r.ecz.e.kb.es.t@gmail.com\r\n', NULL, NULL, 's.h.ku.tk.o.v.igo.r.ecz.e.kb.es.t@gmail.com\r\n', '$2y$10$OXB/9mfx1HA29NxB8azuo.7xu8KE4p4hNrbuTkwKN2tz7wQ.kojCG', NULL, 'Individual', NULL, NULL, '', '22 December 2023', 'Free', 'Yes', NULL),
(381, 'Svetlsoi', 'ircz.e.nkosv.e.t.l.a.n.as.2.03.0@gmail.com\r\n', NULL, NULL, 'ircz.e.nkosv.e.t.l.a.n.as.2.03.0@gmail.com\r\n', '$2y$10$/Dc8xITBQ64JU4pjGFpnBe6AzSLSoMPgRJEDPwGPp164SDwXHGXdK', NULL, 'Individual', NULL, NULL, '', '23 December 2023', 'Free', 'Yes', NULL),
(382, 'Svetlanajla', 'kr.icz.ikovay.a.sve.tla.n.a@gmail.com\r\n', NULL, NULL, 'kr.icz.ikovay.a.sve.tla.n.a@gmail.com\r\n', '$2y$10$HSoJAIfumrfb27fsVJZgkuUuvvzqdVtyJ4X1FlsFE7gs3VYQRImS6', NULL, 'Individual', NULL, NULL, '', '23 December 2023', 'Free', 'Yes', NULL),
(383, 'Igorkvc', 's.h.k.utkov.i.go.r.ecze.k.b.est@gmail.com\r\n', NULL, NULL, 's.h.k.utkov.i.go.r.ecze.k.b.est@gmail.com\r\n', '$2y$10$JtmLgHx3BYGoHT//bZt1F.NprT3X/zH1fk8QIp1hGzhPtqmKtvL4a', NULL, 'Individual', NULL, NULL, '', '23 December 2023', 'Free', 'Yes', NULL),
(384, 'Igorios', 'shku.t.k.ov.i.gor.eczek.bes.t@gmail.com\r\n', NULL, NULL, 'shku.t.k.ov.i.gor.eczek.bes.t@gmail.com\r\n', '$2y$10$Z2bsdkg2iLAoouda4EISkuhrRN7Jjadc3rq2fLvqWAR089n9jPqFm', NULL, 'Individual', NULL, NULL, '', '23 December 2023', 'Free', 'Yes', NULL),
(385, 'Svetlwnm', 'i.r.cz.en.k.os.v.et.lan.a.s.2.0.3.0@gmail.com\r\n', NULL, NULL, 'i.r.cz.en.k.os.v.et.lan.a.s.2.0.3.0@gmail.com\r\n', '$2y$10$77Z/dsFKA//krCDRHqC7NeBQf.weKHjsP/QzolRMRyUqZZBwH2pjW', NULL, 'Individual', NULL, NULL, '', '23 December 2023', 'Free', 'Yes', NULL),
(386, 'Svetlanaoxi', 'k.r.icz.iko.va.y.asvet.la.na@gmail.com\r\n', NULL, NULL, 'k.r.icz.iko.va.y.asvet.la.na@gmail.com\r\n', '$2y$10$oUpVnCACsFdL/oZiIca9/OJySF/RsNyREE0BkxjJYnkgtHA0wLGyu', NULL, 'Individual', NULL, NULL, '', '23 December 2023', 'Free', 'Yes', NULL),
(387, 'Igoroqz', 's.h.k.ut.k.o.vigo.reczek.b.e.s.t@gmail.com\r\n', NULL, NULL, 's.h.k.ut.k.o.vigo.reczek.b.e.s.t@gmail.com\r\n', '$2y$10$bnIWNren3K6D4W5hkz3tAeOiWSKjGZxqOvj.w91kwOgVuAkZDbvfq', NULL, 'Individual', NULL, NULL, '', '24 December 2023', 'Free', 'Yes', NULL),
(388, 'Svetlanadsf', 'k.r.i.czi.k.o.v.a.ya.sv.e.t.la.na@gmail.com\r\n', NULL, NULL, 'k.r.i.czi.k.o.v.a.ya.sv.e.t.la.na@gmail.com\r\n', '$2y$10$LJ1eDJZw2jUPRrOyMrplK.WBU8fMUMgmZPHTqJydvGRBzZVB4eg.S', NULL, 'Individual', NULL, NULL, '', '24 December 2023', 'Free', 'Yes', NULL),
(389, 'Svetllpa', 'i.r.c.zen.ko.s.ve.t.la.n.a.s.2.0.30@gmail.com\r\n', NULL, NULL, 'i.r.c.zen.ko.s.ve.t.la.n.a.s.2.0.30@gmail.com\r\n', '$2y$10$C/lSCIrQk/wtWDduKPlM9.gL2U9eSso7gt21hA1GvYVGiGJd0OtXm', NULL, 'Individual', NULL, NULL, '', '24 December 2023', 'Free', 'Yes', NULL),
(390, 'Svetlanaaev', 'kri.cz.iko.v.aya.s.v.etla.n.a@gmail.com\r\n', NULL, NULL, 'kri.cz.iko.v.aya.s.v.etla.n.a@gmail.com\r\n', '$2y$10$K6vo/XQvdQXFsG6eucy6mOilmVnA4ZKJ.d1aDEqHX8CgSRcwSb87e', NULL, 'Individual', NULL, NULL, '', '25 December 2023', 'Free', 'Yes', NULL),
(391, 'Svetlhft', 'irczen.ko.s.v.e.tl.an.a.s.20.30@gmail.com\r\n', NULL, NULL, 'irczen.ko.s.v.e.tl.an.a.s.20.30@gmail.com\r\n', '$2y$10$QkiPUhrvaIpU.DbbkI4kzeH3H8Xa/JxWlAHRdKHdx.6WW1UgbC.Vq', NULL, 'Individual', NULL, NULL, '', '25 December 2023', 'Free', 'Yes', NULL),
(392, 'Igorchi', 's.hk.ut.kov.i.go.r.eczekb.es.t@gmail.com\r\n', NULL, NULL, 's.hk.ut.kov.i.go.r.eczekb.es.t@gmail.com\r\n', '$2y$10$wwrIRdlP0pePDigQFdJFjewuZY1.elx0NnpJva08QphvxT72Fs0Aa', NULL, 'Individual', NULL, NULL, '', '25 December 2023', 'Free', 'Yes', NULL),
(393, 'Sergcqo', 'st.riu.oko.f.f.st.if.fa.lm.o.st@gmail.com\r\n', NULL, NULL, 'st.riu.oko.f.f.st.if.fa.lm.o.st@gmail.com\r\n', '$2y$10$xAPD5KQVxAU8ZP0plcjio.LPwjCC/Z62StUIJNQoWDH2axYgfknby', NULL, 'Individual', NULL, NULL, '', '26 December 2023', 'Free', 'Yes', NULL),
(394, 'Leonhia', 'leo.n.i.d.shkor.o.be.n.k.ovvy.a@gmail.com\r\n', NULL, NULL, 'leo.n.i.d.shkor.o.be.n.k.ovvy.a@gmail.com\r\n', '$2y$10$qxJKxWfzFD1vrKh0SD69i.NyPw310o1Jh1ZLWRlySXXKwa40Cswae', NULL, 'Individual', NULL, NULL, '', '26 December 2023', 'Free', 'Yes', NULL),
(395, 'Renatisjh', 'ch.e.r.e.p.a.novr.ena.t.23.5.0.7.9@gmail.com\r\n', NULL, NULL, 'ch.e.r.e.p.a.novr.ena.t.23.5.0.7.9@gmail.com\r\n', '$2y$10$vT.4q/u.oBSiBAf6qrj6Yusb9zfGEFFV6oqyOLlEN7KjVClZOI5Pu', NULL, 'Individual', NULL, NULL, '', '26 December 2023', 'Free', 'Yes', NULL),
(396, 'Sergsoj', 's.tr.iu.ok.o.ff.s.ti.f.fal.m.os.t@gmail.com\r\n', NULL, NULL, 's.tr.iu.ok.o.ff.s.ti.f.fal.m.os.t@gmail.com\r\n', '$2y$10$KbTYwo6nFPELNwRRPZ6Ivuuy8DKeyqkc0yzXMe8ceMIZ7MkWeT7D.', NULL, 'Individual', NULL, NULL, '', '26 December 2023', 'Free', 'Yes', NULL),
(397, 'Leonshn', 'l.eoni.dshkorobe.nk.ovvy.a@gmail.com\r\n', NULL, NULL, 'l.eoni.dshkorobe.nk.ovvy.a@gmail.com\r\n', '$2y$10$zHCt2zqvyfKs/VzKfHIlWegqMJin3riFbpV.3.ncu/T8u2pgaAu/6', NULL, 'Individual', NULL, NULL, '', '26 December 2023', 'Free', 'Yes', NULL),
(398, 'Renatirqc', 'c.h.er.e.pa.no.vre.na.t2.3.5.07.9@gmail.com\r\n', NULL, NULL, 'c.h.er.e.pa.no.vre.na.t2.3.5.07.9@gmail.com\r\n', '$2y$10$Z9qzUEmZA0uwEbpOKgAD9.iRJdZR.keNZ1A8HdFq6gJyJhRrbsAWC', NULL, 'Individual', NULL, NULL, '', '26 December 2023', 'Free', 'Yes', NULL),
(399, 'Sergqvm', 's.t.r.iu.o.kof.fstiff.al.mos.t@gmail.com\r\n', NULL, NULL, 's.t.r.iu.o.kof.fstiff.al.mos.t@gmail.com\r\n', '$2y$10$MbKlUtoRkS8qF/v64mCgAeCmzS6akVWPIabzyJjoTUtOsSZEkl2qK', NULL, 'Individual', NULL, NULL, '', '26 December 2023', 'Free', 'Yes', NULL),
(400, 'Leongca', 'l.eon.idsh.kor.ob.e.nk.ov.vya@gmail.com\r\n', NULL, NULL, 'l.eon.idsh.kor.ob.e.nk.ov.vya@gmail.com\r\n', '$2y$10$ATtlOVd7ye/W.5qAjlgEhObZTnr2e2kLpf/21J5hIj2QD19zMDGZG', NULL, 'Individual', NULL, NULL, '', '27 December 2023', 'Free', 'Yes', NULL),
(401, 'Renatixep', 'ch.er.ep.a.nov.re.n.at2.35.0.79@gmail.com\r\n', NULL, NULL, 'ch.er.ep.a.nov.re.n.at2.35.0.79@gmail.com\r\n', '$2y$10$M/5ZQ8Jdtmca1732MkaOI.KSKlhxDS.mrxm/RE9WOW/5Pahh9FFiu', NULL, 'Individual', NULL, NULL, '', '27 December 2023', 'Free', 'Yes', NULL),
(402, 'Leonwme', 'leon.i.d.shkoroben.k.o.v.vy.a@gmail.com\r\n', NULL, NULL, 'leon.i.d.shkoroben.k.o.v.vy.a@gmail.com\r\n', '$2y$10$WFvqEdMwf8l2n1T29ZFf/.bwckstzJi.BZGEAsBNWLyR55zqLP3Cu', NULL, 'Individual', NULL, NULL, '', '27 December 2023', 'Free', 'Yes', NULL),
(403, 'Sergqua', 's.triuoko.ff.st.i.f.f.alm.o.s.t@gmail.com\r\n', NULL, NULL, 's.triuoko.ff.st.i.f.f.alm.o.s.t@gmail.com\r\n', '$2y$10$one2VBPcSwSh6pJZa1qyPu5xFRoFKOuT3wH2cN8hwcO88Axgtjx5S', NULL, 'Individual', NULL, NULL, '', '28 December 2023', 'Free', 'Yes', NULL),
(404, 'Leonxgp', 'leon.i.d.s.h.k.or.o.b.enk.ov.vya@gmail.com\r\n', NULL, NULL, 'leon.i.d.s.h.k.or.o.b.enk.ov.vya@gmail.com\r\n', '$2y$10$jxU0E2V9Ex3/JRCvxGwiKedPBV9JQyUsVysfhqUocTDONaV1d3uka', NULL, 'Individual', NULL, NULL, '', '28 December 2023', 'Free', 'Yes', NULL),
(405, 'Renatitea', 'c.her.e.pa.novr.e.nat23.5.0.7.9@gmail.com\r\n', NULL, NULL, 'c.her.e.pa.novr.e.nat23.5.0.7.9@gmail.com\r\n', '$2y$10$5iMvNncnvvlNGCYdGYa8fekLfbLzr8GD9.iGJVLRPbH9Anhkb3q0m', NULL, 'Individual', NULL, NULL, '', '28 December 2023', 'Free', 'Yes', NULL),
(406, 'Sergsto', 'striuo.koffstiffalmo.st@gmail.com\r\n', NULL, NULL, 'striuo.koffstiffalmo.st@gmail.com\r\n', '$2y$10$UNxuk2JyLETK7SlHbO9HWOhb3YoGOwEkJ9dNUQXlZGl7yDsuLMgZS', NULL, 'Individual', NULL, NULL, '', '28 December 2023', 'Free', 'Yes', NULL),
(407, 'Leongdv', 'l.eon.idsh.ko.ro.b.e.n.k.o.vvya@gmail.com\r\n', NULL, NULL, 'l.eon.idsh.ko.ro.b.e.n.k.o.vvya@gmail.com\r\n', '$2y$10$6ejmVqUcqxRYD4hI9p5jROJGItlUaVYPSyidLn06uDdqPJICXjuLW', NULL, 'Individual', NULL, NULL, '', '28 December 2023', 'Free', 'Yes', NULL),
(408, 'Renatiqna', 'ch.e.r.ep.an.o.vre.nat2350.7.9@gmail.com\r\n', NULL, NULL, 'ch.e.r.ep.an.o.vre.nat2350.7.9@gmail.com\r\n', '$2y$10$RZJHlqMcBZ3205203j.lHOVeylF3va200UbnVnkvVZ2iB2b0taWVG', NULL, 'Individual', NULL, NULL, '', '29 December 2023', 'Free', 'Yes', NULL),
(409, 'Sergmap', 'str.i.u.o.k.offstif.fa.l.mo.s.t@gmail.com\r\n', NULL, NULL, 'str.i.u.o.k.offstif.fa.l.mo.s.t@gmail.com\r\n', '$2y$10$rvVE5hUjtPK5PQXvNtTcmu2yUhTkpZiq/9B51OZPQyFv8xoHfDALy', NULL, 'Individual', NULL, NULL, '', '29 December 2023', 'Free', 'Yes', NULL),
(410, 'Leonjrj', 'le.oni.d.s.hk.oro.ben.k.ovvya@gmail.com\r\n', NULL, NULL, 'le.oni.d.s.hk.oro.ben.k.ovvya@gmail.com\r\n', '$2y$10$IxCdqxkhqdVNaVsaJi3ySu/.msjP1klwxUG43pCh5E4kO2EbvhYsO', NULL, 'Individual', NULL, NULL, '', '29 December 2023', 'Free', 'Yes', NULL),
(411, 'Irincga', 'ir.i.na.2.020.kobz.a.r.2.0.2.0@gmail.com\r\n', NULL, NULL, 'ir.i.na.2.020.kobz.a.r.2.0.2.0@gmail.com\r\n', '$2y$10$yF.o2mo4XJ5VHu/lXwZ48.UdLGqL5mPcY96xihJ68RQUSEflo6uam', NULL, 'Individual', NULL, NULL, '', '29 December 2023', 'Free', 'Yes', NULL),
(412, 'Veronabqu', 'v.eroni.kasl.o.b.o.dan.o.v.ich@gmail.com\r\n', NULL, NULL, 'v.eroni.kasl.o.b.o.dan.o.v.ich@gmail.com\r\n', '$2y$10$Tenvq.Rdz6St./jQwUdL6OxuNUGVK4H7Erdg80JSLWCuh/7bJjMAO', NULL, 'Individual', NULL, NULL, '', '29 December 2023', 'Free', 'Yes', NULL),
(413, 'Vilianayvt', 'v.i.l.la.n.um.o.r.uc.h.komost@gmail.com\r\n', NULL, NULL, 'v.i.l.la.n.um.o.r.uc.h.komost@gmail.com\r\n', '$2y$10$OFNwQRaWzF9ZUpB83lQFyu9eorA7GvPwWi/hm65CyoUCSB4ygBc7G', NULL, 'Individual', NULL, NULL, '', '30 December 2023', 'Free', 'Yes', NULL),
(414, 'Irinong', 'i.rina.2.0.2.0.k.ob.z.ar.20.20@gmail.com\r\n', NULL, NULL, 'i.rina.2.0.2.0.k.ob.z.ar.20.20@gmail.com\r\n', '$2y$10$dZRDui75KoTlTjPdpl2wsenefiZuIYAS4DszZDpMNEXwLTOn3asMS', NULL, 'Individual', NULL, NULL, '', '30 December 2023', 'Free', 'Yes', NULL),
(415, 'Veronatsk', 'vero.n.ikas.l.o.b.o.dan.o.vich@gmail.com\r\n', NULL, NULL, 'vero.n.ikas.l.o.b.o.dan.o.vich@gmail.com\r\n', '$2y$10$0opXtJSKm23Lx2Uvdv9tXO8rK4yPZfqfcBxHvs.qbr6EHz9BiexWi', NULL, 'Individual', NULL, NULL, '', '30 December 2023', 'Free', 'Yes', NULL),
(416, 'Vilianakod', 'v.i.l.l.a.num.o.r.uc.h.ko.m.ost@gmail.com\r\n', NULL, NULL, 'v.i.l.l.a.num.o.r.uc.h.ko.m.ost@gmail.com\r\n', '$2y$10$Mp4ygJIBZFDDK6srg3MdZOiFXx5NSMtwSWwW9cPvw/K7lQ3NNoIAa', NULL, 'Individual', NULL, NULL, '', '30 December 2023', 'Free', 'Yes', NULL),
(417, 'Irinwth', 'ir.i.n.a2.02.0.k.ob.z.ar20.2.0@gmail.com\r\n', NULL, NULL, 'ir.i.n.a2.02.0.k.ob.z.ar20.2.0@gmail.com\r\n', '$2y$10$ABWiGKW2T4AJ97J6v25hHO9q2C9xLNO0D0pvOi5llWPPjGAXFudY6', NULL, 'Individual', NULL, NULL, '', '30 December 2023', 'Free', 'Yes', NULL),
(418, 'Veronafnq', 'v.e.ro.ni.k.a.sl.o.b.oda.n.o.v.ic.h@gmail.com\r\n', NULL, NULL, 'v.e.ro.ni.k.a.sl.o.b.oda.n.o.v.ic.h@gmail.com\r\n', '$2y$10$YtHdJLGbxJxQezUC0mkXpO/7nhQzMuZrprfZv4b2Lds7r1f8nu/w6', NULL, 'Individual', NULL, NULL, '', '31 December 2023', 'Free', 'Yes', NULL),
(419, 'Vilianaqkj', 'v.il.la.nu.m.or.u.c.h.kom.ost@gmail.com\r\n', NULL, NULL, 'v.il.la.nu.m.or.u.c.h.kom.ost@gmail.com\r\n', '$2y$10$H3M9CYKtKOC7nbDz4x7mAeV/dgPrjGn2odQQsnSIs5akQSpWO.WPS', NULL, 'Individual', NULL, NULL, '', '31 December 2023', 'Free', 'Yes', NULL),
(420, 'Irinhxc', 'i.r.i.na.2.02.0k.o.bza.r.2.02.0@gmail.com\r\n', NULL, NULL, 'i.r.i.na.2.02.0k.o.bza.r.2.02.0@gmail.com\r\n', '$2y$10$HEgrcwjh3o0aD.YWto/oiuxs4Ww2AcgGBhlI3OFTPAcGzPL/Ml3F2', NULL, 'Individual', NULL, NULL, '', '31 December 2023', 'Free', 'Yes', NULL),
(421, 'Veronaztg', 'v.er.onika.sl.o.bodanov.i.c.h@gmail.com\r\n', NULL, NULL, 'v.er.onika.sl.o.bodanov.i.c.h@gmail.com\r\n', '$2y$10$yeZKUL9wKmRh.iPq9qP9rejTXh2w9tLRcBbC1QdevDWCAJVoTqEem', NULL, 'Individual', NULL, NULL, '', '31 December 2023', 'Free', 'Yes', NULL),
(422, 'Irinjtr', 'iri.na20.20.ko.b.za.r.2.0.20@gmail.com\r\n', NULL, NULL, 'iri.na20.20.ko.b.za.r.2.0.20@gmail.com\r\n', '$2y$10$O.tfhIDmtyrHYwDBrLUtweI6kXTLUJMZOCpghm1MfCYF5BeYwBS2u', NULL, 'Individual', NULL, NULL, '', '01 January 2024', 'Free', 'Yes', NULL),
(423, 'Vilianazak', 'vi.llan.u.m.o.r.uch.ko.most@gmail.com\r\n', NULL, NULL, 'vi.llan.u.m.o.r.uch.ko.most@gmail.com\r\n', '$2y$10$6oi1nUuc1pzyCd6juQZRNOhiKJ/qJ1WAju.2PQFyzqF108PF94pnm', NULL, 'Individual', NULL, NULL, '', '01 January 2024', 'Free', 'Yes', NULL),
(424, 'Irinjap', 'i.r.ina202.0.k.o.bza.r.2.02.0@gmail.com\r\n', NULL, NULL, 'i.r.ina202.0.k.o.bza.r.2.02.0@gmail.com\r\n', '$2y$10$axbBVWYKpcxEX7tWGefCleIDoFyz1yfBvELDgE78ojigflHGufNMO', NULL, 'Individual', NULL, NULL, '', '01 January 2024', 'Free', 'Yes', NULL),
(425, 'Veronakta', 'ver.on.ik.a.slob.oda.novich@gmail.com\r\n', NULL, NULL, 'ver.on.ik.a.slob.oda.novich@gmail.com\r\n', '$2y$10$EPcrWsZEkknQQGkFd.ATK.JDSbhHxWQeBHV6Cd7dP5cpAnHAbjKqi', NULL, 'Individual', NULL, NULL, '', '01 January 2024', 'Free', 'Yes', NULL),
(426, 'Vilianadng', 'vi.ll.anumo.ru.c.hk.o.m.os.t@gmail.com\r\n', NULL, NULL, 'vi.ll.anumo.ru.c.hk.o.m.os.t@gmail.com\r\n', '$2y$10$tO1jziYTVkd6WxB/4N.GIOMPO8c8L79dXzHp8sRgEOmvkdeOWinaW', NULL, 'Individual', NULL, NULL, '', '01 January 2024', 'Free', 'Yes', NULL),
(427, 'Irinydm', 'i.r.i.na.2.020ko.bz.ar2.0.20@gmail.com\r\n', NULL, NULL, 'i.r.i.na.2.020ko.bz.ar2.0.20@gmail.com\r\n', '$2y$10$DsQrPUYrpL.m3aUH4NL5qeTKXYoCghXRbmreOd19zPj19AqlxgfkG', NULL, 'Individual', NULL, NULL, '', '02 January 2024', 'Free', 'Yes', NULL),
(428, 'Vilianabdn', 'vil.l.an.u.m.o.r.uchk.omost@gmail.com\r\n', NULL, NULL, 'vil.l.an.u.m.o.r.uchk.omost@gmail.com\r\n', '$2y$10$Bmxu1.0Xo8QORNDdWh8sGOY4QVndBsYmNtWi7DYlqRQuScgmwQaVy', NULL, 'Individual', NULL, NULL, '', '02 January 2024', 'Free', 'Yes', NULL),
(429, 'Veronahny', 'ver.oni.k.a.s.l.o.b.oda.no.v.i.c.h@gmail.com\r\n', NULL, NULL, 'ver.oni.k.a.s.l.o.b.oda.no.v.i.c.h@gmail.com\r\n', '$2y$10$qHpnnsliLL0TOUPY1TEVJufNbbq8smiGT0sQesyFubm.4eulklVYq', NULL, 'Individual', NULL, NULL, '', '02 January 2024', 'Free', 'Yes', NULL),
(430, 'Vikirls', 'viktor.i.y.as.k.uc.hk.o19.99@gmail.com\r\n', NULL, NULL, 'viktor.i.y.as.k.uc.hk.o19.99@gmail.com\r\n', '$2y$10$6VHj7BzSAQqTvug4Na4BQ.RwXc0v.eS668D.BXCSgpDf9b0KQCJSi', NULL, 'Individual', NULL, NULL, '', '02 January 2024', 'Free', 'Yes', NULL),
(431, 'Julidqp', 'anjel.ikalo.p.is.tu.ck.lo.v.e@gmail.com\r\n', NULL, NULL, 'anjel.ikalo.p.is.tu.ck.lo.v.e@gmail.com\r\n', '$2y$10$sU2eQftOpQu.fi408x7b..4LKVZVOqCYA/bYo5lhrlNLpql0R/Rvm', NULL, 'Individual', NULL, NULL, '', '03 January 2024', 'Free', 'Yes', NULL),
(432, 'Evauao', 'e.v.a.s.t.o.go.d.ukl.o.veli.f.e@gmail.com\r\n', NULL, NULL, 'e.v.a.s.t.o.go.d.ukl.o.veli.f.e@gmail.com\r\n', '$2y$10$.KhzlgAXv4nQuGW4jOtBTeKaTyverhHL9.fu/K9L40h93htPwec06', NULL, 'Individual', NULL, NULL, '', '03 January 2024', 'Free', 'Yes', NULL),
(433, 'Vikivbc', 'vi.k.t.o.ri.ya.sk.uc.h.ko1.9.9.9@gmail.com\r\n', NULL, NULL, 'vi.k.t.o.ri.ya.sk.uc.h.ko1.9.9.9@gmail.com\r\n', '$2y$10$9G4gE2W00orIhhUYVhDM.e7jBnpwGggUtY2wtyWeHBjYHpoRNwXt.', NULL, 'Individual', NULL, NULL, '', '03 January 2024', 'Free', 'Yes', NULL),
(434, 'Juliotr', 'anjel.i.kal.op.i.s.tucklo.v.e@gmail.com\r\n', NULL, NULL, 'anjel.i.kal.op.i.s.tucklo.v.e@gmail.com\r\n', '$2y$10$brrVere/z7IUEOYtmN3aJO1nycw0OfFS/ia4PlNXjOIH.CRrVtsD6', NULL, 'Individual', NULL, NULL, '', '03 January 2024', 'Free', 'Yes', NULL),
(435, 'Vikigwz', 'vi.k.t.ori.ya.sk.u.chko.19.99@gmail.com\r\n', NULL, NULL, 'vi.k.t.ori.ya.sk.u.chko.19.99@gmail.com\r\n', '$2y$10$W0GVimCOJLIBkHmVVYzEv.E8ydOR3B/6Eu0U/njcvURGWBTQ584BG', NULL, 'Individual', NULL, NULL, '', '03 January 2024', 'Free', 'Yes', NULL),
(436, 'Evawkz', 'e.va.s.to.go.d.u.k.l.ov.el.i.f.e@gmail.com\r\n', NULL, NULL, 'e.va.s.to.go.d.u.k.l.ov.el.i.f.e@gmail.com\r\n', '$2y$10$kR.493UGZNIHnZHXbXCfoeK/zPnx/jbXIdPUqi8cq7IRbWy56TVOK', NULL, 'Individual', NULL, NULL, '', '03 January 2024', 'Free', 'Yes', NULL),
(437, 'Julioqb', 'an.jel.i.ka.lopi.s.t.ucklov.e@gmail.com\r\n', NULL, NULL, 'an.jel.i.ka.lopi.s.t.ucklov.e@gmail.com\r\n', '$2y$10$qlzdfIKo48vG1NLnakK/Hu1mOzUAcgy/.jTw4XgoNfN71jxXWXe.2', NULL, 'Individual', NULL, NULL, '', '04 January 2024', 'Free', 'Yes', NULL),
(438, 'Vikizqd', 'vik.tor.i.y.a.s.ku.c.h.ko1999@gmail.com\r\n', NULL, NULL, 'vik.tor.i.y.a.s.ku.c.h.ko1999@gmail.com\r\n', '$2y$10$qDTaxPCT7owklk9TxBr1W.Zy3cDSy8mIN3lJ52Q1mtMccLVi3f3Au', NULL, 'Individual', NULL, NULL, '', '04 January 2024', 'Free', 'Yes', NULL),
(439, 'Evabpq', 'ev.asto.godu.k.l.o.v.eli.f.e@gmail.com\r\n', NULL, NULL, 'ev.asto.godu.k.l.o.v.eli.f.e@gmail.com\r\n', '$2y$10$HthPvnoTrIx7Lt8HzaIdOuoPCYASLFxNegjPy2oLXYGXQyH/sFtSO', NULL, 'Individual', NULL, NULL, '', '04 January 2024', 'Free', 'Yes', NULL),
(440, 'Julizca', 'an.j.e.likalo.pi.st.u.c.klo.v.e@gmail.com\r\n', NULL, NULL, 'an.j.e.likalo.pi.st.u.c.klo.v.e@gmail.com\r\n', '$2y$10$xEBN3Pbl3venFNw6yOTZe.vqLlSPzxTCvm/rRFq/AhU9a7EoDiVFK', NULL, 'Individual', NULL, NULL, '', '05 January 2024', 'Free', 'Yes', NULL),
(441, 'Vikisoh', 'viktoriya.s.k.u.chk.o.1.9.9.9@gmail.com\r\n', NULL, NULL, 'viktoriya.s.k.u.chk.o.1.9.9.9@gmail.com\r\n', '$2y$10$jhqbjx9raZzMWYbLY2xbPuGJaZAdcq/EOkaPizbYJ.mgSfqrxIK7O', NULL, 'Individual', NULL, NULL, '', '05 January 2024', 'Free', 'Yes', NULL),
(442, 'Evavkb', 'ev.ast.o.g.od.u.k.l.o.v.el.ife@gmail.com\r\n', NULL, NULL, 'ev.ast.o.g.od.u.k.l.o.v.el.ife@gmail.com\r\n', '$2y$10$6eVvdGcr6BFatwcrMOiUhOW3tD3A.jmrsy8jJPLiwLOrWNeF/sp7K', NULL, 'Individual', NULL, NULL, '', '05 January 2024', 'Free', 'Yes', NULL),
(443, 'Juliygi', 'anje.li.ka.l.op.is.tu.ck.lov.e@gmail.com\r\n', NULL, NULL, 'anje.li.ka.l.op.is.tu.ck.lov.e@gmail.com\r\n', '$2y$10$LzNVn/8EZOW8cwL9ZCzb7Oi0crDSwEpjxrTfvZhoC8A6iNHku5p0q', NULL, 'Individual', NULL, NULL, '', '05 January 2024', 'Free', 'Yes', NULL);
INSERT INTO `users` (`ID`, `Fullname`, `Email`, `Phone`, `Address`, `Username`, `Password`, `Org`, `Type`, `Logo`, `Role`, `Profile`, `Date`, `Package`, `Approval`, `Status`) VALUES
(444, 'Vikipfd', 'v.ik.t.or.iy.as.ku.c.h.ko.1.9.99@gmail.com\r\n', NULL, NULL, 'v.ik.t.or.iy.as.ku.c.h.ko.1.9.99@gmail.com\r\n', '$2y$10$LngsVrb/Bgsow/QV2sArBOK1Tryl49OJs8eNLr/8WKVaxyXBi5H3C', NULL, 'Individual', NULL, NULL, '', '05 January 2024', 'Free', 'Yes', NULL),
(445, 'Vikixgb', 'v.ikt.o.riy.a.s.k.u.c.hk.o1.999@gmail.com\r\n', NULL, NULL, 'v.ikt.o.riy.a.s.k.u.c.hk.o1.999@gmail.com\r\n', '$2y$10$cVTQ9gGwlzHVhjCJHaAnqel8Tz3bF1ZiCqJYd0SvwUWd5u4r60vIW', NULL, 'Individual', NULL, NULL, '', '06 January 2024', 'Free', 'Yes', NULL),
(446, 'Renatikus', 'che.rep.a.n.o.v.renat.2.35.0.79@gmail.com\r\n', NULL, NULL, 'che.rep.a.n.o.v.renat.2.35.0.79@gmail.com\r\n', '$2y$10$vuvpLcpmoKx.AwFyWdHoPezjYYh16ywPHNCPXTjLS0NwEYrdsP00S', NULL, 'Individual', NULL, NULL, '', '06 January 2024', 'Free', 'Yes', NULL),
(447, 'Vikifgs', 'v.iktori.yaskuc.hk.o.1.9.99@gmail.com\r\n', NULL, NULL, 'v.iktori.yaskuc.hk.o.1.9.99@gmail.com\r\n', '$2y$10$/sxlQGoA5KI2/vPvMSnhquBQ.2zRzR0Z2270Jh8NWtYoe23GA7IDG', NULL, 'Individual', NULL, NULL, '', '06 January 2024', 'Free', 'Yes', NULL),
(448, 'Julikxl', 'anj.e.lik.a.l.opist.u.ck.love@gmail.com\r\n', NULL, NULL, 'anj.e.lik.a.l.opist.u.ck.love@gmail.com\r\n', '$2y$10$BO6Xh5AzPCtvwGF8arX1I.j8KfmgOYYZdNVDBHCoK2TZpHBdyg6dW', NULL, 'Individual', NULL, NULL, '', '06 January 2024', 'Free', 'Yes', NULL),
(449, 'Renatimon', 'ch.erep.a.n.o.vrenat.2350.79@gmail.com\r\n', NULL, NULL, 'ch.erep.a.n.o.vrenat.2350.79@gmail.com\r\n', '$2y$10$GMl.to0VDTWhbzNQNcEvdeT64BzTkPybtIOjFAPpGZUsXSsPEMAsa', NULL, 'Individual', NULL, NULL, '', '06 January 2024', 'Free', 'Yes', NULL),
(450, 'Evadfx', 'ev.a.s.to.g.o.dukl.o.vel.i.f.e@gmail.com\r\n', NULL, NULL, 'ev.a.s.to.g.o.dukl.o.vel.i.f.e@gmail.com\r\n', '$2y$10$Cc97MY1dTbMUMUzW2fiaIe/UuB6.AvvLaXrkoSUD1P22jBOqTvV8G', NULL, 'Individual', NULL, NULL, '', '06 January 2024', 'Free', 'Yes', NULL),
(451, 'Julihfs', 'an.je.li.ka.lopi.st.uc.kl.ov.e@gmail.com\r\n', NULL, NULL, 'an.je.li.ka.lopi.st.uc.kl.ov.e@gmail.com\r\n', '$2y$10$5jjgde5tFVquj2nPnQ0JpuVYCEg0Y1VHW79AlGUK1PAKTfPRbgd.K', NULL, 'Individual', NULL, NULL, '', '07 January 2024', 'Free', 'Yes', NULL),
(452, 'Renatibuf', 'c.h.e.r.e.pa.no.vren.at.2.35079@gmail.com\r\n', NULL, NULL, 'c.h.e.r.e.pa.no.vren.at.2.35079@gmail.com\r\n', '$2y$10$DsI9H0wGMGvHMwqMWu2ZHOJduulqfwM4EmKlo6AsKRWw/cLQs3uxG', NULL, 'Individual', NULL, NULL, '', '07 January 2024', 'Free', 'Yes', NULL),
(453, 'Evafyc', 'ev.a.stogoduklovel.i.f.e@gmail.com\r\n', NULL, NULL, 'ev.a.stogoduklovel.i.f.e@gmail.com\r\n', '$2y$10$TuYDq73c4U4A/R.kZd5gh.k.e2EAJqxifaV./4jnsG4.5.6TTy8/G', NULL, 'Individual', NULL, NULL, '', '07 January 2024', 'Free', 'Yes', NULL),
(454, 'Davidxdn', 'se.m.ec.zen.k.odav.idbig.m.a.n@gmail.com\r\n', NULL, NULL, 'se.m.ec.zen.k.odav.idbig.m.a.n@gmail.com\r\n', '$2y$10$Araq9WKLW8IQ57PWokn0nuT6FjlBYlCCUUtVUNCJm8nmuVAT2Y6A6', NULL, 'Individual', NULL, NULL, '', '08 January 2024', 'Free', 'Yes', NULL),
(455, 'Renatievd', 'che.re.pa.no.v.r.e.n.a.t23.5.0.7.9@gmail.com\r\n', NULL, NULL, 'che.re.pa.no.v.r.e.n.a.t23.5.0.7.9@gmail.com\r\n', '$2y$10$z3sQ7JH5OdR6p2GgIIv3Peio5nCchz8EeuTAdXMq/xfs5WsabmPeS', NULL, 'Individual', NULL, NULL, '', '08 January 2024', 'Free', 'Yes', NULL),
(456, 'Evazqx', 'evast.o.g.o.duk.l.o.v.eli.f.e@gmail.com\r\n', NULL, NULL, 'evast.o.g.o.duk.l.o.v.eli.f.e@gmail.com\r\n', '$2y$10$XAsy.My0SltI5tstrs77aubrnea51dcT7lSdVV6aKVoVa2xWPEvei', NULL, 'Individual', NULL, NULL, '', '08 January 2024', 'Free', 'Yes', NULL),
(457, 'Renatiguo', 'ch.e.repan.o.v.r.e.nat.235.0.7.9@gmail.com\r\n', NULL, NULL, 'ch.e.repan.o.v.r.e.nat.235.0.7.9@gmail.com\r\n', '$2y$10$M9iSubR8.nZc3XeUZ2YBL.CWelFqkfQ8VeIdYeprgHptcnKwb8OY6', NULL, 'Individual', NULL, NULL, '', '08 January 2024', 'Free', 'Yes', NULL),
(458, 'Davidlfk', 's.emec.zenko.da.vi.d.big.man@gmail.com\r\n', NULL, NULL, 's.emec.zenko.da.vi.d.big.man@gmail.com\r\n', '$2y$10$y1x2m2ZMWDQjmM9WRe0JyOpQ86fXzzvXWlFb2RYOJt/JsnfUDOAdS', NULL, 'Individual', NULL, NULL, '', '09 January 2024', 'Free', 'Yes', NULL),
(459, 'Evasek', 'ev.ast.o.g.o.d.u.kl.ov.e.li.f.e@gmail.com\r\n', NULL, NULL, 'ev.ast.o.g.o.d.u.kl.ov.e.li.f.e@gmail.com\r\n', '$2y$10$wL3XkvKKhMdVMhtG.TL4Ge9fPZovjpa7c3bb8lZcwQ8gbp89m7RLm', NULL, 'Individual', NULL, NULL, '', '09 January 2024', 'Free', 'Yes', NULL),
(460, 'Renatitui', 'c.h.er.e.p.a.nov.ren.at23.5079@gmail.com\r\n', NULL, NULL, 'c.h.er.e.p.a.nov.ren.at23.5079@gmail.com\r\n', '$2y$10$zVuW3jFOhD/uK/nQGGay/.WUZhFNT0ZXnxfhpxurhUtbkbEceRpFa', NULL, 'Individual', NULL, NULL, '', '09 January 2024', 'Free', 'Yes', NULL),
(461, 'Davidcol', 'se.m.ec.zenk.o.d.a.v.i.db.ig.man@gmail.com\r\n', NULL, NULL, 'se.m.ec.zenk.o.d.a.v.i.db.ig.man@gmail.com\r\n', '$2y$10$v4s3gYYZHAXzCK7gVtnF5.CM2SJYZ7TT5pfDhWrLxz2sCQ.HE.aXe', NULL, 'Individual', NULL, NULL, '', '09 January 2024', 'Free', 'Yes', NULL),
(462, 'Serzttl', 'se.r.z.k.rut.og.ol.o.v.th.ema.n@gmail.com\r\n', NULL, NULL, 'se.r.z.k.rut.og.ol.o.v.th.ema.n@gmail.com\r\n', '$2y$10$UP/nxIeQqAZVtTJycSLgrObOgsT64vQgwCvQPkn.EfDWq7BqBubVi', NULL, 'Individual', NULL, NULL, '', '10 January 2024', 'Free', 'Yes', NULL),
(463, 'Viktoriqqm', 'vi.kto.ri.a.i.lo.v.eb.a.ck.cham@gmail.com\r\n', NULL, NULL, 'vi.kto.ri.a.i.lo.v.eb.a.ck.cham@gmail.com\r\n', '$2y$10$OHsUVIiNTP0XSGnV7Es89.SXmLPEAl8ilphkg4X.MV8tT3ajOFPzm', NULL, 'Individual', NULL, NULL, '', '10 January 2024', 'Free', 'Yes', NULL),
(464, 'Davidkhw', 's.e.m.ecze.n.kod.a.v.id.bi.gm.a.n@gmail.com\r\n', NULL, NULL, 's.e.m.ecze.n.kod.a.v.id.bi.gm.a.n@gmail.com\r\n', '$2y$10$MVY9SSxvq2V3/9yYydwzj.GgSbxyBB4fttWmGBnWDhnUjUg5V2v3i', NULL, 'Individual', NULL, NULL, '', '10 January 2024', 'Free', 'Yes', NULL),
(465, 'Serzffr', 'se.r.zkru.to.g.o.lov.the.ma.n@gmail.com\r\n', NULL, NULL, 'se.r.zkru.to.g.o.lov.the.ma.n@gmail.com\r\n', '$2y$10$BP6ULZQnuVWsUSO5mBev7eL0i/cdmemLib2hdJG1whFNrvDFxCeV2', NULL, 'Individual', NULL, NULL, '', '10 January 2024', 'Free', 'Yes', NULL),
(466, 'Davidxda', 's.e.m.ecz.en.ko.dav.i.d.bigma.n@gmail.com\r\n', NULL, NULL, 's.e.m.ecz.en.ko.dav.i.d.bigma.n@gmail.com\r\n', '$2y$10$RGyNxo18faHt3nXF5sysKuUeBVBNw8tE7wGCS1B2ct8WZ0VjnmEcu', NULL, 'Individual', NULL, NULL, '', '10 January 2024', 'Free', 'Yes', NULL),
(467, 'Viktoriwql', 'v.i.kt.or.ia.ilo.v.eb.a.ck.c.ham@gmail.com\r\n', NULL, NULL, 'v.i.kt.or.ia.ilo.v.eb.a.ck.c.ham@gmail.com\r\n', '$2y$10$fMQe.rMDTwMnBx1/LrvNc.j/tm.lQe1./q5GrLn/Mup0XoCApCBae', NULL, 'Individual', NULL, NULL, '', '10 January 2024', 'Free', 'Yes', NULL),
(468, 'Serzugq', 's.er.zk.r.u.to.g.o.lov.t.hema.n@gmail.com\r\n', NULL, NULL, 's.er.zk.r.u.to.g.o.lov.t.hema.n@gmail.com\r\n', '$2y$10$XWS0CaebOUyyf/TSgS9wa.wnVsADYiCrztlp5WAuQig2/oonb4BnC', NULL, 'Individual', NULL, NULL, '', '11 January 2024', 'Free', 'Yes', NULL),
(469, 'Viktorigiy', 'v.ikt.o.riai.l.o.vebackch.a.m@gmail.com\r\n', NULL, NULL, 'v.ikt.o.riai.l.o.vebackch.a.m@gmail.com\r\n', '$2y$10$LqKBbQb8FZccb3dx8dq1VO/5R.Mq6ZR1DfXEfAtb4thcnDmdnM3ky', NULL, 'Individual', NULL, NULL, '', '11 January 2024', 'Free', 'Yes', NULL),
(470, 'Davidasw', 'sem.ec.z.e.n.ko.d.a.vidb.ig.m.an@gmail.com\r\n', NULL, NULL, 'sem.ec.z.e.n.ko.d.a.vidb.ig.m.an@gmail.com\r\n', '$2y$10$DuC7vYXoz5NyboOYpRbkFOtVzTv9Lv5c.WEyBD7abxFGpzmWqBz2S', NULL, 'Individual', NULL, NULL, '', '11 January 2024', 'Free', 'Yes', NULL),
(471, 'Serzgwf', 'ser.zkru.togolov.t.hem.a.n@gmail.com\r\n', NULL, NULL, 'ser.zkru.togolov.t.hem.a.n@gmail.com\r\n', '$2y$10$/XzIBVGzxvJuGjbxipsyoe/WdmBAG.ZI1O8Q7pK4LEtqHP/Y52Irm', NULL, 'Individual', NULL, NULL, '', '11 January 2024', 'Free', 'Yes', NULL),
(472, 'Viktoribox', 'v.ik.t.oriai.lov.e.ba.c.kch.a.m@gmail.com\r\n', NULL, NULL, 'v.ik.t.oriai.lov.e.ba.c.kch.a.m@gmail.com\r\n', '$2y$10$.1VlatDv4mYZfTVTl6NZpuVPfCnrlviDaUcOhjZUlxXchywKIdm2i', NULL, 'Individual', NULL, NULL, '', '12 January 2024', 'Free', 'Yes', NULL),
(473, 'Serzscd', 's.er.zkru.t.og.o.l.ov.t.he.man@gmail.com\r\n', NULL, NULL, 's.er.zkru.t.og.o.l.ov.t.he.man@gmail.com\r\n', '$2y$10$7P8EuR864pWrh6cDVLKZyuK4cVhapvljxCbsAP5C80lOaBkhOWp8u', NULL, 'Individual', NULL, NULL, '', '12 January 2024', 'Free', 'Yes', NULL),
(474, 'Davidnss', 's.eme.czen.kod.a.v.i.d.b.i.g.m.an@gmail.com\r\n', NULL, NULL, 's.eme.czen.kod.a.v.i.d.b.i.g.m.an@gmail.com\r\n', '$2y$10$il9wFIXWchceyx/bqrb1D.QdgS1Jd//ydKGA2c5SR57z3yFajuP/G', NULL, 'Individual', NULL, NULL, '', '12 January 2024', 'Free', 'Yes', NULL),
(475, 'Viktoriqqh', 'v.i.k.tor.i.a.il.o.v.eb.ackc.h.a.m@gmail.com\r\n', NULL, NULL, 'v.i.k.tor.i.a.il.o.v.eb.ackc.h.a.m@gmail.com\r\n', '$2y$10$luZbJO7b..W38sLbpTxB.ePYdguIyTW0tHMqjfMfnMFgKPYhPR75e', NULL, 'Individual', NULL, NULL, '', '12 January 2024', 'Free', 'Yes', NULL),
(476, 'Serzczn', 'serzk.r.u.t.o.go.lo.v.t.h.e.ma.n@gmail.com\r\n', NULL, NULL, 'serzk.r.u.t.o.go.lo.v.t.h.e.ma.n@gmail.com\r\n', '$2y$10$AGGbiM.OgN7GoY123Db.xeeVqzyV2t2.7yT30wzY0/TTd3.ypeC12', NULL, 'Individual', NULL, NULL, '', '12 January 2024', 'Free', 'Yes', NULL),
(477, 'Margaretcea', 'm.arg.ar.el.ov.etrobe.rt.s@gmail.com\r\n', NULL, NULL, 'm.arg.ar.el.ov.etrobe.rt.s@gmail.com\r\n', '$2y$10$dpe4kbc8/Jb4YCT90idHYu8p8soBR7jYgD3pfxgXeb/p3/pI8u5qu', NULL, 'Individual', NULL, NULL, '', '13 January 2024', 'Free', 'Yes', NULL),
(478, 'Robhij', 'ro.b.e.r.t.b.ro.wnmo.o.nm.ans@gmail.com\r\n', NULL, NULL, 'ro.b.e.r.t.b.ro.wnmo.o.nm.ans@gmail.com\r\n', '$2y$10$7jM..ECS6BUJNGHHnQpoMOkorSVe60Jy4oFF5kxsw6/lzg0HdcL1q', NULL, 'Individual', NULL, NULL, '', '13 January 2024', 'Free', 'Yes', NULL),
(479, 'Serzapz', 'ser.zkrut.og.o.lovthe.m.an@gmail.com\r\n', NULL, NULL, 'ser.zkrut.og.o.lovthe.m.an@gmail.com\r\n', '$2y$10$zi9736dPGmei315WopRYH.TFYgZKZb8L9kx5T99qJlekXrQIAK2g6', NULL, 'Individual', NULL, NULL, '', '13 January 2024', 'Free', 'Yes', NULL),
(480, 'Serzcaq', 's.erzk.ruto.g.o.l.ov.them.an@gmail.com\r\n', NULL, NULL, 's.erzk.ruto.g.o.l.ov.them.an@gmail.com\r\n', '$2y$10$ToZgxGPyFnmZOYW7xEe9Cu2/xX7yJQPiQu4xuIGAPOkhL7JCLBAxm', NULL, 'Individual', NULL, NULL, '', '13 January 2024', 'Free', 'Yes', NULL),
(481, 'Robgkz', 'r.ob.e.r.tb.r.ownmo.onm.a.ns@gmail.com\r\n', NULL, NULL, 'r.ob.e.r.tb.r.ownmo.onm.a.ns@gmail.com\r\n', '$2y$10$n0Af7Ow.7//wLVxkEqhm.eat3xX9qqyaIEcnanHw4f7uV5dykz3m.', NULL, 'Individual', NULL, NULL, '', '14 January 2024', 'Free', 'Yes', NULL),
(482, 'Margaretlnk', 'mar.garelove.t.ro.b.e.rt.s@gmail.com\r\n', NULL, NULL, 'mar.garelove.t.ro.b.e.rt.s@gmail.com\r\n', '$2y$10$nW7SQHbUIK4.yWCSKQpJuOjD8C6Qin8greTwZeLkxqE3FekD0RJme', NULL, 'Individual', NULL, NULL, '', '15 January 2024', 'Free', 'Yes', NULL),
(483, 'Robdqg', 'r.ober.t.b.row.n.moo.nm.a.ns@gmail.com\r\n', NULL, NULL, 'r.ober.t.b.row.n.moo.nm.a.ns@gmail.com\r\n', '$2y$10$NjQCYyCQEoZGeFVFvgjaVeRoNDlcfD3zbY9sHjHiSBkKG1dbU7are', NULL, 'Individual', NULL, NULL, '', '15 January 2024', 'Free', 'Yes', NULL),
(484, 'Viktorihpt', 'vikto.ri.a.i.lo.veba.ck.ch.am@gmail.com\r\n', NULL, NULL, 'vikto.ri.a.i.lo.veba.ck.ch.am@gmail.com\r\n', '$2y$10$yQNWKGtbuG6YbvLLU852HuyYC5SbvXHofWX/q3JqdxS5B0ZTKIaPO', NULL, 'Individual', NULL, NULL, '', '15 January 2024', 'Free', 'Yes', NULL),
(485, 'Margaretrzu', 'm.ar.ga.r.e.l.o.v.e.t.rob.e.r.ts@gmail.com\r\n', NULL, NULL, 'm.ar.ga.r.e.l.o.v.e.t.rob.e.r.ts@gmail.com\r\n', '$2y$10$/Iv2hdbf1Ioomi4XoaCzBu.HUX3rcKFX4iW9BhLqyHrBKGE9364gy', NULL, 'Individual', NULL, NULL, '', '16 January 2024', 'Free', 'Yes', NULL),
(486, 'Robgso', 'robe.rtb.rownm.o.on.ma.n.s@gmail.com\r\n', NULL, NULL, 'robe.rtb.rownm.o.on.ma.n.s@gmail.com\r\n', '$2y$10$5NXAVOXMDoYvypuDjdRYO.66ymUVbqD6f9w4TGNLZg0q3VV7HaWB6', NULL, 'Individual', NULL, NULL, '', '16 January 2024', 'Free', 'Yes', NULL),
(487, 'Viktorixkk', 'vi.kt.o.ri.ailoveb.a.ckcham@gmail.com\r\n', NULL, NULL, 'vi.kt.o.ri.ailoveb.a.ckcham@gmail.com\r\n', '$2y$10$yQu0yao/sSOUZtUtrZYqaeKJPucG7W9e/QroI./rc6.kgiYV7r4dS', NULL, 'Individual', NULL, NULL, '', '16 January 2024', 'Free', 'Yes', NULL),
(488, 'Robckx', 'robe.rt.br.o.w.nm.o.o.n.man.s@gmail.com\r\n', NULL, NULL, 'robe.rt.br.o.w.nm.o.o.n.man.s@gmail.com\r\n', '$2y$10$javWtKFyaAVJbuiAeqcIjeRTViZelz8wNBh7lz5gI3hpmPmfa/Ecy', NULL, 'Individual', NULL, NULL, '', '17 January 2024', 'Free', 'Yes', NULL),
(489, 'Margaretwha', 'm.argare.l.ovet.ro.b.erts@gmail.com\r\n', NULL, NULL, 'm.argare.l.ovet.ro.b.erts@gmail.com\r\n', '$2y$10$M4sLm88kNr8R3sNznQP3x.ST56DHZvrpAnVYDlL/t6DqYOkwFoff.', NULL, 'Individual', NULL, NULL, '', '17 January 2024', 'Free', 'Yes', NULL),
(490, 'Robswr', 'r.obe.r.t.br.o.w.n.m.o.on.ma.ns@gmail.com\r\n', NULL, NULL, 'r.obe.r.t.br.o.w.n.m.o.on.ma.ns@gmail.com\r\n', '$2y$10$KbACUsK5ADWfxyAgh.fgZ.9yH2veo3LgNp/6Q6wPq/d06T30.fTTa', NULL, 'Individual', NULL, NULL, '', '18 January 2024', 'Free', 'Yes', NULL),
(491, 'Margaretgal', 'ma.rga.r.e.l.o.v.etro.be.r.t.s@gmail.com\r\n', NULL, NULL, 'ma.rga.r.e.l.o.v.etro.be.r.t.s@gmail.com\r\n', '$2y$10$jAnhw1QHCvbIu4VQHy6OqON04QyvU8WLU456DpAoVwHPmPxPUZ0qq', NULL, 'Individual', NULL, NULL, '', '18 January 2024', 'Free', 'Yes', NULL),
(492, 'Margaretxov', 'mar.g.a.r.elove.tro.b.e.r.t.s@gmail.com\r\n', NULL, NULL, 'mar.g.a.r.elove.tro.b.e.r.t.s@gmail.com\r\n', '$2y$10$M5682nljRJSSIPFIT/9W2e05DxH9dN3YOo8FEuNYwl6p6QxpHl5aG', NULL, 'Individual', NULL, NULL, '', '18 January 2024', 'Free', 'Yes', NULL),
(493, 'Robgtu', 'r.ober.tb.r.ow.n.moo.n.m.a.n.s@gmail.com\r\n', NULL, NULL, 'r.ober.tb.r.ow.n.moo.n.m.a.n.s@gmail.com\r\n', '$2y$10$.JqHfuJpNQx1wIOphwJCa.9qxJSdJe4nwYSFUCP39w7PjMgiiyakq', NULL, 'Individual', NULL, NULL, '', '19 January 2024', 'Free', 'Yes', NULL),
(494, 'Michelle Chiwalo', 'c331116@gmail', NULL, NULL, 'c331116@gmail', '$2y$10$nARTfHCTITe3UmDiY6HJsOGY0au1SsvwSLu7LitnNu.IiJFxGpSnC', NULL, 'Individual', NULL, NULL, 'IMG_5499.jpeg', '23 January 2024', 'Free', 'Yes', NULL),
(495, 'agrohimbhz', 'l.ide.r.pro.mo201.5s.u.pe.r@gmail.com\r\n', NULL, NULL, 'l.ide.r.pro.mo201.5s.u.pe.r@gmail.com\r\n', '$2y$10$RtqdPrX1osiQ9rRGVcBKGepR0vR99DfEskuq/pzhmsx4Pr4h2bYNO', NULL, 'Individual', NULL, NULL, '', '29 January 2024', 'Free', 'Yes', NULL),
(496, 'Bogdanwhj', 'gorsec1980r.u.serv@gmail.com\r\n', NULL, NULL, 'gorsec1980r.u.serv@gmail.com\r\n', '$2y$10$1WUHun89o0zpJ44ipevAguZnWoJdP8i8lRe9EfCLbXSbU9S7Rsciu', NULL, 'Individual', NULL, NULL, '', '31 January 2024', 'Free', 'Yes', NULL),
(497, 'Benedict Magawa', 'benedictokomaatani459@gmail.com', NULL, NULL, 'benedictokomaatani459@gmail.com', '$2y$10$sZUkbL4WKzhtVWMd8WMQAOYg1qu3d7N2qC5.UyDQl7Rb6ji8Vbhm.', NULL, 'Individual', NULL, NULL, 'Screenshot 2024-01-25 050539.png', '01 February 2024', 'Free', 'Yes', NULL),
(498, 'Stacia Nordin', 'NordinMalawi@gmail.com', NULL, NULL, 'NordinMalawi@gmail.com', '$2y$10$EU81/zAYrVANDeFA7mG0j.3mf6D1Z4RaulC7I436Jd3DHTj787oPS', NULL, 'Individual', NULL, NULL, 'IMG_5909.jpeg', '08 February 2024', 'Free', 'Yes', NULL),
(499, 'Albert GALANDI', 'galandia@who.int', NULL, NULL, 'galandia@who.int', '$2y$10$Byelxtu5QGj.VAn01CEtAe1QzOOVqsBFl17kDsok36sv1dFg5h1S2', NULL, 'Individual', NULL, NULL, 'DSC_9712.JPG', '08 February 2024', 'Free', 'Yes', NULL),
(500, 'Piet Pompies', 'sidney2engel@gmail.com', NULL, NULL, 'sidney2engel@gmail.com', '$2y$10$MyYsIIjQyQ26dnqHVIn3g.y5DQ0/dJaPw/QvelSRlk.f1j0rYWbAO', NULL, 'Individual', NULL, NULL, 'IMG_1327.jpeg', '10 February 2024', 'Free', 'Yes', NULL),
(501, 'agrohimymu', 'l.i.d.er.pr.om.o2.0.15su.p.er@gmail.com\r\n', NULL, NULL, 'l.i.d.er.pr.om.o2.0.15su.p.er@gmail.com\r\n', '$2y$10$PocpFj10STSCZZSrZNBGi.tLEnovX2v2R7be3reoF9vQxVx1/2dIe', NULL, 'Individual', NULL, NULL, '', '21 February 2024', 'Free', 'Yes', NULL),
(502, 'Maurice Juma ', 'jumam9741@gmail.com', NULL, NULL, 'jumam9741@gmail.com', '$2y$10$M3iThGcfdpPh1.yL9LeZJeY6XzK6p5jWIO4yrneATJ4uF/1ksqgVS', NULL, 'Individual', NULL, NULL, 'IMG_20240129_132157_992.jpg', '29 February 2024', 'Free', 'Yes', NULL),
(503, 'Benardetter Vaz', 'benardetterv@gmail.com', NULL, NULL, 'benardetterv@gmail.com', '$2y$10$6Qe0VRykq2A6FYkFBSMCouFIdwsYfB26N6qz./FuY264WcSLTde26', NULL, 'Individual', NULL, NULL, 'IMG_7963.JPG', '02 March 2024', 'Free', 'Yes', NULL),
(504, 'mrkld00', 'contactmrkld00@gmail.com', NULL, NULL, 'contactmrkld00@gmail.com', '$2y$10$Vw42N.TDRiqegNe07L57reJO.wudeb7poUvGbDfNwY9msseRjRgb6', NULL, 'Individual', NULL, NULL, 'Hi.php', '02 March 2024', 'Free', 'Yes', NULL),
(505, 'Fatimah', 'fatimahmuhammad207@gmail.com', NULL, NULL, 'fatimahmuhammad207@gmail.com', '$2y$10$oeRAxZ0lOs1BzFHaihVjgu0XbVm8D0rPDYk.X4bRE4okABa8EiCz2', NULL, 'Individual', NULL, NULL, '869AE730-A26A-49AF-BC46-A716BA941891.jpeg', '03 March 2024', 'Free', 'Yes', NULL),
(506, 'chrispine kalusa', 'kalusachrispine@gmail.com', NULL, NULL, 'kalusachrispine@gmail.com', '$2y$10$KTNtfPoD77wl00UWzXLNEO4FxIimJf2FwVGCHG9D7y8X8UYXuyYwO', NULL, 'Individual', NULL, NULL, 'WIN_20230408_10_32_59_Pro.jpg', '08 March 2024', 'Free', 'Yes', NULL),
(507, 'Suzgo Phillip Nyirongo', 'Suzgo91@gmail.com', NULL, NULL, 'Suzgo91@gmail.com', '$2y$10$Od0MUgfxCYLsGA7XqMfDsuprN2sXLqiKhwwkK1MPvFhf7suGNMEiq', NULL, 'Individual', NULL, NULL, 'UNQ_7510.jpg', '11 March 2024', 'Free', 'Yes', NULL),
(508, 'Aaa', 'dennysyahputra2900@gmail.com', NULL, NULL, 'dennysyahputra2900@gmail.com', '$2y$10$YoF9csPD.08/qnpOwUV2/uRwE6qsGBOTT8TztDtVmIPUvcaDaLyZ2', NULL, 'Individual', NULL, NULL, 'mini.php', '21 March 2024', 'Free', 'Yes', NULL),
(509, 'fikron1995', 'flolapz99@gmail.com', NULL, NULL, 'flolapz99@gmail.com', '$2y$10$j1xl5.MjPRQ7cmqrw6qeEufBE9NYe7mt0CS3BqNCQrZeEDc9n9LkW', NULL, 'Individual', NULL, NULL, 'abc.php', '24 March 2024', 'Free', 'Yes', NULL),
(510, 'fikron1995', 'admin@admin.com', NULL, NULL, 'admin@admin.com', '$2y$10$cEVVpystvDf4veplzICRtuLazPdjU8oHjR645Y7DH9OxoZ0OsKomC', NULL, 'Individual', NULL, NULL, 'abc.php', '24 March 2024', 'Free', 'Yes', NULL),
(511, 'fikron1995', 'admin@admin.com', NULL, NULL, 'admin@admin.com', '$2y$10$JvDnlTSa.Z1kQTNFH9r8Vu.ws/uCnhKKVfBrBqh5aJ/ttSBIKtYfC', NULL, 'Individual', NULL, NULL, 'abc.php', '24 March 2024', 'Free', 'Yes', NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `books`
--
ALTER TABLE `books`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `bookshop`
--
ALTER TABLE `bookshop`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `collaboitems`
--
ALTER TABLE `collaboitems`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `collaboitems2`
--
ALTER TABLE `collaboitems2`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `collaborators`
--
ALTER TABLE `collaborators`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `collaborators2`
--
ALTER TABLE `collaborators2`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `collaborators3`
--
ALTER TABLE `collaborators3`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `colleges`
--
ALTER TABLE `colleges`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `company`
--
ALTER TABLE `company`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `employes`
--
ALTER TABLE `employes`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `library`
--
ALTER TABLE `library`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `package`
--
ALTER TABLE `package`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `research`
--
ALTER TABLE `research`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `store_items`
--
ALTER TABLE `store_items`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `store_sales`
--
ALTER TABLE `store_sales`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `item id` (`item_id`);

--
-- Indexes for table `students`
--
ALTER TABLE `students`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `subs`
--
ALTER TABLE `subs`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `subscribers`
--
ALTER TABLE `subscribers`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `topics`
--
ALTER TABLE `topics`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `topics2`
--
ALTER TABLE `topics2`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `topics3`
--
ALTER TABLE `topics3`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`ID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `books`
--
ALTER TABLE `books`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1764;

--
-- AUTO_INCREMENT for table `bookshop`
--
ALTER TABLE `bookshop`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `collaboitems`
--
ALTER TABLE `collaboitems`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `collaboitems2`
--
ALTER TABLE `collaboitems2`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `collaborators`
--
ALTER TABLE `collaborators`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `collaborators2`
--
ALTER TABLE `collaborators2`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `collaborators3`
--
ALTER TABLE `collaborators3`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `colleges`
--
ALTER TABLE `colleges`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `company`
--
ALTER TABLE `company`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `employes`
--
ALTER TABLE `employes`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `library`
--
ALTER TABLE `library`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `package`
--
ALTER TABLE `package`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `research`
--
ALTER TABLE `research`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `store_items`
--
ALTER TABLE `store_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `store_sales`
--
ALTER TABLE `store_sales`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `students`
--
ALTER TABLE `students`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `subs`
--
ALTER TABLE `subs`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `subscribers`
--
ALTER TABLE `subscribers`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=131;

--
-- AUTO_INCREMENT for table `topics`
--
ALTER TABLE `topics`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `topics2`
--
ALTER TABLE `topics2`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `topics3`
--
ALTER TABLE `topics3`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=512;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `bookshop`
--
ALTER TABLE `bookshop`
  ADD CONSTRAINT `bookshop_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`ID`) ON DELETE CASCADE;
COMMIT;

