-- Seed data for: schcat, clrc, class, cluster, disability, spledu, users
-- Generated from the source CSVs already supplied for the Firebase build.
-- NOTE: `cluster` references `block` (blkcd) and `class` references `schcat`.
-- FOREIGN_KEY_CHECKS is disabled around this batch so cluster rows load fine
-- even before you've imported `block` separately -- import block's own data
-- (not requested in this batch) for full referential integrity.
-- NOTE: `class` has no natural unique key (only an AUTO_INCREMENT id), so
-- unlike the other tables here it is NOT safe to re-run this script blindly --
-- doing so will insert a second copy of all 58 class rows. If you need to
-- re-run just this section, `TRUNCATE class;` first.
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- schcat (8 rows)
INSERT INTO schcat (schcat_id, schcat) VALUES
('1', 'PRIMARY ONLY WITH GRADES 1 TO 4/5'),
('2', 'UPPER PRIMARY WITH GRADES 1 TO 8'),
('3', 'HIGHER SECONDARY WITH GRADES 1 TO 12'),
('4', 'UPPER PRIMARY ONLY WITH GRADES 5/6 TO 8'),
('5', 'HIGHER SECONDARY WITH GRADES 5/6 TO 12'),
('6', 'SECONDARY WITH GRADES 1 TO 10'),
('7', 'SECONDARY WITH GRADES 5/6 TO 10'),
('11', 'AWC')
ON DUPLICATE KEY UPDATE schcat = VALUES(schcat);

-- clrc (44 rows)
INSERT INTO clrc (clrccode, clrcname) VALUES
('192501', 'AUSGRAM-I'),
('192502', 'AUSGRAM-II'),
('192503', 'BHATAR'),
('192504', 'BHATAR WEST'),
('192505', 'BUDBUD'),
('192506', 'DAINHAT'),
('192507', 'GALSI'),
('192508', 'GALSI WEST'),
('192509', 'GUSHKARA-I'),
('192510', 'GUSHKARA-II'),
('192511', 'JAMALPUR'),
('192512', 'JAMALPUR EAST'),
('192513', 'KALANABAGRAM'),
('192514', 'KALNA EAST'),
('192515', 'KALNA NORTH'),
('192516', 'KALNA-III'),
('192517', 'KALNA-IV'),
('192518', 'KATWA EAST'),
('192519', 'KATWA WEST'),
('192520', 'KETUGRAM'),
('192521', 'KETUGRAM WEST'),
('192522', 'KHANDOGHOSH-I'),
('192523', 'KHANDOGHOSH-II'),
('192524', 'MEMARI'),
('192525', 'MONGALKOTE-I'),
('192526', 'MONGALKOTE-II'),
('192527', 'MONGALKOTE-III'),
('192528', 'MONTESWAR-I'),
('192529', 'MONTESWAR-II'),
('192530', 'MONTESWAR-III'),
('192531', 'PURBASTHALI'),
('192532', 'PURBASTHALI NORTH'),
('192533', 'PURBASTHALI SOUTH'),
('192534', 'RAINA-I'),
('192535', 'RAINA-II'),
('192536', 'RAINA-III'),
('192537', 'RAINA-IV'),
('192538', 'SADAR EAST'),
('192539', 'SADAR NORTH'),
('192540', 'SADAR URBAN-I'),
('192541', 'SADAR URBAN-II'),
('192542', 'SADAR WEST'),
('192543', 'SATGACHIA'),
('192544', 'SATGACHIA WEST')
ON DUPLICATE KEY UPDATE clrcname = VALUES(clrcname);

-- class (58 rows) -- id is AUTO_INCREMENT, not inserted explicitly
INSERT INTO class (schcat_id, sclass) VALUES
('1', 'PP'),
('1', 'I'),
('1', 'II'),
('1', 'III'),
('1', 'IV'),
('1', 'V'),
('2', 'PP'),
('2', 'I'),
('2', 'II'),
('2', 'III'),
('2', 'IV'),
('2', 'V'),
('2', 'VI'),
('2', 'VII'),
('2', 'VIII'),
('3', 'PP'),
('3', 'I'),
('3', 'II'),
('3', 'III'),
('3', 'IV'),
('3', 'V'),
('3', 'VI'),
('3', 'VII'),
('3', 'VIII'),
('3', 'IX'),
('3', 'X'),
('3', 'XI'),
('3', 'XII'),
('4', 'V'),
('4', 'VI'),
('4', 'VII'),
('4', 'VIII'),
('5', 'V'),
('5', 'VI'),
('5', 'VII'),
('5', 'VIII'),
('5', 'IX'),
('5', 'X'),
('5', 'XI'),
('5', 'XII'),
('6', 'PP'),
('6', 'I'),
('6', 'II'),
('6', 'III'),
('6', 'IV'),
('6', 'V'),
('6', 'VI'),
('6', 'VII'),
('6', 'VIII'),
('6', 'IX'),
('6', 'X'),
('7', 'V'),
('7', 'VI'),
('7', 'VII'),
('7', 'VIII'),
('7', 'IX'),
('7', 'X'),
('11', 'ICDS');

-- cluster (243 rows)
INSERT INTO cluster (clucd, cluname, clrccode, blockcode, area) VALUES
('1925010001', 'GOBINDAPUR JR BASIC SCHOOL', '192502', '192501', 'UKTA'),
('1925010002', 'BERENDA F.P. SCHOOL', '192502', '192501', 'BERENDA'),
('1925010003', 'AUSGRAM HIGH SCHOOL', '192502', '192501', 'AUSGRAM'),
('1925010004', 'GOPAL SAYER ADIBASI F.P SCHOOL', '192501', '192501', 'GUSKARA-II'),
('1925010005', 'DWARIPUR F.P SCHOOL', '192501', '192501', 'DIGNAGAR-II'),
('1925010006', 'DIGNAGAR HATTALA J.B SCHOOL', '192501', '192501', 'DIGNAGAR-I'),
('1925010007', 'BONPAS STATION BAZAR F.P SCHOOL', '192501', '192501', 'BILAGRAM'),
('1925020001', 'KOTA-CHANDIPUR HIGH SCHOO', '192509', '192502', 'KOTA'),
('1925020002', 'HARISPUR F.P. SCHOOL', '192510', '192502', 'AMARPUR'),
('1925020003', 'BHEDIA F.P. SCHOOL', '192510', '192502', 'BHEDIA'),
('1925020004', 'AMRARGARH HIGH SCHOOL', '192509', '192502', 'BHALKI'),
('1925020005', 'GOSWAMI KHANDA MALLICKPUR', '192510', '192502', 'RAMNAGAR'),
('1925020006', 'ERAL ANCHAL HIGH SCHOOL', '192509', '192502', 'ERAL'),
('1925020007', 'DEBSHALA HIGH SCHOOL', '192509', '192502', 'DEBSALA'),
('1925030001', 'MAHATA HIGH SCHOOL', '192504', '192503', 'MAHATA'),
('1925030002', 'ORGRAM HIGH SCHOOL', '192504', '192503', 'SAHEBGANJ-II'),
('1925030003', 'MAHACHANDA F.P. SCHOOL', '192504', '192503', 'MAHACHANDA'),
('1925030004', 'BONPAS SIKHANIKETAN', '192504', '192503', 'BONPAS'),
('1925030005', 'BAMUNARA L.C.D.P. INSTITU', '192504', '192503', 'BAMUNARA'),
('1925030006', 'SAHEBGANJ HIGH SCHOOL', '192504', '192503', 'SAHEBGANJ-I'),
('1925030007', 'KUBAJPUR JR. HIGH SCHOOL', '192503', '192503', 'AMARUN-II'),
('1925030008', 'SUSUNDIGHI H.P. HIGH SCHO', '192503', '192503', 'NITYANANDAPUR'),
('1925030009', 'BARABELUN D.B.B. VIDYALAY', '192503', '192503', 'BAROBELUN-I'),
('1925030010', 'KULCHNADA SATYABATI GIRLS F.P.', '192503', '192503', 'BHATAR'),
('1925030011', 'BALGONA SARADAMONI BALIKA', '192503', '192503', 'BALGONA'),
('1925030012', 'HARGRAM U.S. PUBLIC JR.HI', '192503', '192503', 'AMARUN-I'),
('1925030013', 'NASIGRAM HIGH SCHOOL(PRIMARY)', '192503', '192503', 'BAROBELUN-II'),
('1925030014', 'ARUAR B.M.D.P. INSTITUTION', '192503', '192503', 'ERUAR'),
('1925040001', 'TALIT GURASWAR HIGH SCHOO', '192542', '192504', 'BAGHAR-II'),
('1925040002', 'JAGDABAD S.B. HIGH SCHOOL', '192542', '192504', 'BAGHAR-I'),
('1925040003', 'SHAMBHUCHARAN GUHA SMRITY', '192542', '192504', 'RAYAN-I'),
('1925040004', 'BHITA M.P. INSTITUTION', '192542', '192504', 'RAYAN-II'),
('1925040005', 'BURDWAN HIGH MADRASAH', '192542', '192504', 'BELKASH'),
('1925040006', 'VIDYASAGAR UCHCHA VIDYALA', '192542', '192504', 'SARAITIKAR'),
('1925040007', 'KALIGRAM HIGH SCHOOL', '192539', '192504', 'KSHETIA'),
('1925040008', 'BHANDARDIHI PANCHKARI BA', '192539', '192504', 'BONDUL-I'),
('1925040009', 'KURHMUN F.P. SCHOOL', '192539', '192504', 'KURMUN-I'),
('1925050001', 'BHAITA HARIDAS KAR HIGH SCHOOL', '192544', '192505', 'NABASTHA-II'),
('1925050002', 'BALGONA HIGH SCHOOL', '192539', '192505', 'KURMUN-II'),
('1925050003', 'KADRA A.K. HIGH SCHOOL', '192539', '192505', 'BONDUL-II'),
('1925050005', 'BARSUL C.D.P. HIGH SCHOOL', '192538', '192505', 'BARSUL-I'),
('1925050006', 'MASJID PARA F.P. SCHOOL', '192538', '192505', 'BARSUL-II'),
('1925050007', 'JOTERAM VIDYAPITH', '192538', '192505', 'BAIKUNTHAPUR-I'),
('1925050008', 'SRIRAMPUR HIGH SCHOOL', '192538', '192505', 'BAIKUNTHAPUR-II'),
('1925050009', 'HATGOBINDAPUR M.C. HIGH SCHOOL', '192538', '192505', 'GOBINDAPUR'),
('1925050010', 'SATGACHIA WEST CLRC', '192544', '192505', 'NABASTHA-I'),
('1925060001', 'CHAKTENTUL F.P. SCHOOL', '192505', '192506', 'CHAKTENTUL'),
('1925060002', 'MANKAR BOYS\' F.P. SCHOOL', '192505', '192506', 'MANKAR'),
('1925060003', 'KASBA F.P. SCHOOL', '192505', '192506', 'LOWAPUR-KRISHNAR'),
('1925060004', 'BHIRSIN F.P. SCHOOL', '192505', '192506', 'BUDBUD'),
('1925060005', 'SERORAI DURGADASI F.P SCH', '192508', '192506', 'SERORAI'),
('1925060006', 'MOHULARA RADHA BALLAVPUR', '192508', '192506', 'UCHCHAGRAM'),
('1925060007', 'RAMGOPALPUR F.P SCHOOL', '192508', '192506', 'LOWA-RAMGOPALPUR'),
('1925060008', 'PURSA NO. 2 F.P. SCHOOL', '192508', '192506', 'POTNA-PURSA'),
('1925060009', 'PARAJ NO. 2 F.P. SCHOOL', '192508', '192506', 'PARAJ'),
('1925070001', 'BABLA BAINCHI F.P. SCHOOL', '192507', '192507', 'GALSI'),
('1925070002', 'KURKUBA F.P. SCHOOL', '192507', '192507', 'KURKUBA'),
('1925070003', 'ADRA BOYS F.P. SCHOOL', '192508', '192507', 'ADRA'),
('1925070004', 'MOGALSIMA JR. BASIC SCH', '192507', '192507', 'BHURI'),
('1925070005', 'KISHOREKONA JR. BASIC SCH', '192507', '192507', 'KHANO'),
('1925070006', 'KULGARIA HIGH MADRASAH', '192507', '192507', 'SANKO'),
('1925070007', 'TENTULMURI F.P. SCHOOL', '192507', '192507', 'MOSJIDPUR'),
('1925070008', 'GORAMBA F.P. SCHOOL', '192508', '192507', 'GOHOGRAM'),
('1925070009', 'BELGRAM DASPARA F.P. SCHO', '192507', '192507', 'SATINANDI'),
('1925080001', 'KELIRI MOZIDIA HIGH MADRA', '192512', '192508', 'AJHAPUR'),
('1925080002', 'PANCHRA S.C.R.S. VIDYAMAN', '192512', '192508', 'PANCHRA'),
('1925080003', 'SADIPUR DSS VIDYANKETAN', '192512', '192508', 'BERUGRAM'),
('1925080004', 'JAUGRAM HIGH SCHOOL', '192512', '192508', 'JOUGRAM'),
('1925080005', 'JHAPAN DANGA P.N. VIDYAMA', '192512', '192508', 'ABUJHATI-I'),
('1925080006', 'GOPALPUR M.K. VIDYALAYA', '192512', '192508', 'ABUJHATI-II'),
('1925080007', 'AMARPUR B.A  INSTITUTION', '192511', '192508', 'JOTSRIRAM'),
('1925080008', 'SHIPTAI MAHULA S.R.INSTIT', '192511', '192508', 'PARATAL-II'),
('1925080009', 'KALNA KANSHRA HIGH SCHOOL', '192511', '192508', 'JAMALPUR-II'),
('1925080010', 'PARBATPUR HIGH SCHOOL', '192511', '192508', 'PARATAL-I'),
('1925080011', 'JARAGRAM HIGH SCHOOL', '192511', '192508', 'JARAGRAM'),
('1925080012', 'CHAKDIGHI S.P. INSTITUTIO', '192511', '192508', 'CHAKDIGHI'),
('1925080013', 'JAMALPUR CLRC 1ST FLOOR', '192511', '192508', 'JAMALPUR-I'),
('1925090001', 'BAGHNAPARA C.K.D. GIRLS\'', '192515', '192509', 'BAGHNAPARA'),
('1925090002', 'BEGPUR UNION INSTITUTION', '192515', '192509', 'BEGPUR'),
('1925090003', 'SAHAJPUR F.P. SCHOOL', '192515', '192509', 'KANKURIA'),
('1925090004', 'SULTANPUR JR. BASIC SCHOOL', '192515', '192509', 'SULTANPUR'),
('1925090005', 'ATGHORIA JR. BAISC SCHOOL', '192515', '192509', 'ATGHORIA-SIMLON'),
('1925090006', 'KRISHNADEVPUR HIGH SCHOOL', '192514', '192509', 'KRISHNADEVPUR'),
('1925090007', 'NUTUN GRAM HIGH SCHOOL', '192514', '192509', 'NANDAI'),
('1925090008', 'RAMKRISHNA F.P. SCHOOL', '192514', '192509', 'DHATRIGRAM'),
('1925090009', 'HAT-KALNA GAJALAXMI HIGH', '192514', '192509', 'KALNA MP'),
('1925100001', 'KELENOI F.P. SCHOOL', '192517', '192510', 'KALYANPUR'),
('1925100002', 'ARJUNA PATHARGHATA F.P. SCHOOL', '192517', '192510', 'PINDIRA'),
('1925100003', 'AGRADAHA F.P. SCHOOL', '192516', '192510', 'AKALPOUSH'),
('1925100004', 'BAIDYAPUR RAMKRISHNA VIDYAPITH', '192516', '192510', 'BAIDYAPUR'),
('1925100005', 'DUTTA DARIATAN S.V.VIDYAMANDIR', '192517', '192510', 'ANUKHAL'),
('1925100006', 'BADLA HIGH SCHOOL', '192516', '192510', 'BADLA'),
('1925100007', 'SATGACHI BALIKA VIDYALAYA', '192517', '192510', 'SATGACHI'),
('1925100008', 'BARADHAMAS F.P. SCHOOL', '192516', '192510', 'BARADHAMAS'),
('1925110001', 'JAJIGRAM F.P. SCHOOL', '192519', '192511', 'GOAI'),
('1925110002', 'RAJU CHURPUNI AMALA VIDYA', '192519', '192511', 'KOSHIGRAM'),
('1925110003', 'KATWA WEST CLRC OFFICE', '192519', '192511', 'KHAJURDIHI'),
('1925110004', 'SRIKHANDA HIGH SCHOOL', '192519', '192511', 'SRIKHANDA'),
('1925110005', 'PANCHANANTALA HIGH SCHOOL', '192506', '192511', 'KARAJGRAM'),
('1925110006', 'DEVO-GRAM-BARAMPUR MADHYA', '192506', '192511', 'ALAMPUR'),
('1925110007', 'SUDPUR HIGH SCHOOL', '192506', '192511', 'SUDPUR'),
('1925110008', 'GIDHAGRAM GIDHESWAR VIDYA', '192506', '192511', 'GIDHAGRAM'),
('1925110009', 'CHANDRAPUR F.P. SCHOOL', '192506', '192511', 'SARGRAM'),
('1925120001', 'NANDIGRAM JR. BASIC SCHOOL', '192518', '192512', 'SRIBATI'),
('1925120002', 'MEJHIARY C.B.B VIDYALAYA', '192518', '192512', 'KARUI'),
('1925120003', 'PALSONA F.P. SCHOOL', '192518', '192512', 'PALSONA'),
('1925120004', 'OKERSA HIGH SCHOOL', '192518', '192512', 'SINGHEE'),
('1925120005', 'AGRADWIP U.U.M. VIDYALAYA', '192518', '192512', 'GAZIPUR'),
('1925120006', 'AGRADWIP S.C. SIKSHA NIKETAN', '192518', '192512', 'AGRADWIP'),
('1925120007', 'AKHRA HIGH SCHOOL', '192518', '192512', 'JAGADANANDAPUR'),
('1925130001', 'ANKHONA HIGH SCHOOL', '192521', '192513', 'ANKHONA'),
('1925130002', 'RAIKHA F.P. SCHOOL', '192521', '192513', 'RAJOOR'),
('1925130003', 'AMGORIA GOPALPUR R.G.M. I', '192521', '192513', 'AGARDANGA'),
('1925130004', 'PALITA F.P. SCHOOL', '192521', '192513', 'PALITA'),
('1925130005', 'KOMARPUR JR. HIGH SCHOOL', '192521', '192513', 'MURGRAM-GOPALPUR'),
('1925130006', 'KULAI HIGH SCHOOL', '192521', '192513', 'PANDUGRAM'),
('1925130007', 'BERUGRAM F.P. SCHOOL', '192521', '192513', 'BERUGRAM'),
('1925130008', 'KANDRA R.R.D. F.P. SCHOOL', '192521', '192513', 'KANDRA-JNANDAS'),
('1925140001', 'ROUNDI S.N. JR. HIGH SCHOOL', '192520', '192514', 'NIROLE'),
('1925140002', 'PURULIA MHENDRA BIDYAPITH', '192520', '192514', 'NABAGRAM'),
('1925140003', 'GANGATIKURI A.N. BIDYAMANDIR', '192520', '192514', 'GANGATIKURI'),
('1925140004', 'KETUGRAM S.A.M. INSTITUTION', '192520', '192514', 'KETUGRAM'),
('1925140005', 'MOUGRAM HIGH SCHOOL', '192520', '192514', 'MOUGRAM'),
('1925140006', 'MALIHA F.P. SCHOOL', '192520', '192514', 'BILLESWAR'),
('1925140007', 'KEUGURI HIGH SCHOOL', '192520', '192514', 'SITAHATI'),
('1925150001', 'TELUA SIKARPUR F.P. SCHOOL', '192523', '192515', 'SANKARI-II'),
('1925150002', 'SASANGA HIGH SCHOOL', '192523', '192515', 'SASANGA'),
('1925150003', 'BISNA F.P. SCHOOL', '192523', '192515', 'LODNA'),
('1925150004', 'KHEJURHATI F.P. SCHOOL', '192523', '192515', 'KHANDOGHOSH'),
('1925150005', 'POLEMPUR F.P. SCHOOL', '192523', '192515', 'SANKARI-I'),
('1925150006', 'BOWAI F.P. SCHOOL', '192522', '192515', 'BERUGRAM'),
('1925150007', 'GOPALBERA F.P. SCHOOL', '192522', '192515', 'GOPALBERA'),
('1925150008', 'TORKONA JAGABANDHU H.S.', '192522', '192515', 'KAIYAR'),
('1925150009', 'SAGRAI F.P. SCHOOL', '192522', '192515', 'SAGRAI'),
('1925150010', 'KULEY F.P. SCHOOL', '192522', '192515', 'UKHRID'),
('1925160001', 'GANTAR F.P. SCHOOL', '192524', '192516', 'GOPE-GANTER-I'),
('1925160002', 'RADHAKANTAPUR HIGH SCHOOL', '192524', '192516', 'GOPE-GANTER-II'),
('1925160003', 'SASINARA HIGH SCHOOL', '192524', '192516', 'BAGILA'),
('1925160004', 'DEBIPUR ADARSHA HIGH SCHOOL', '192524', '192516', 'DEBIPUR'),
('1925160007', 'KENNA JR. BASIC SCHOOL', '192513', '192516', 'NIMO-II'),
('1925160008', 'MOHINI MOHAN BASU HIGH SCHOOL', '192513', '192516', 'DURGAPUR'),
('1925160009', 'DALUI BAZAR F.P. SCHOOL', '192513', '192516', 'DALUIBAZAR-I'),
('1925160010', 'BADYADANGA GIRLS HIGH SCHOOL', '192513', '192516', 'NIMO-I'),
('1925160011', 'AMADPUR HIGH SCHOOL', '192513', '192516', 'AMADPUR'),
('1925160012', 'DADPUR JR. BASIC SCHOOL', '192513', '192516', 'DALUIBAZAR-II'),
('1925170001', 'BARARI DIHAPALASON SAPTAP', '192543', '192517', 'BARAPALASON-II'),
('1925170002', 'BHOLANATH BIDYAPITH', '192544', '192517', 'KUCHUT'),
('1925170003', 'TEKAIPUR NO. 2 F.P. SCHOOL', '192543', '192517', 'BOHAR-II'),
('1925170004', 'HARINDANGA F.P. SCHOOL', '192543', '192517', 'BOHAR-I'),
('1925170005', 'BARWA PANCHKARI VIDYAMADIR', '192543', '192517', 'SATGACHIA-II'),
('1925170006', 'JABUI SANTIKANAN JR. BASIC', '192544', '192517', 'BIJUR-I'),
('1925170007', 'ASHAPUR ANANDAMAYEE HIGH SCHO', '192544', '192517', 'BIJUR-II'),
('1925170008', 'SATGACHIA CLRC 1ST FLOOR', '192543', '192517', 'SATGACHIA-I'),
('1925170010', 'MONDALGRAM HIGH SCHOOL', '192543', '192517', 'BARAPALASON-I'),
('1925180001', 'GONPUR HIGH SCHOOL', '192525', '192518', 'CHANAK'),
('1925180002', 'GOTISTHA F.P. SCHOOL', '192525', '192518', 'GOTISTHA'),
('1925180003', 'PALIGRAM F.P. SCHOOL', '192525', '192518', 'PALIGRAM'),
('1925180004', 'PINDIRA HIGH SCHOOL', '192526', '192518', 'BHALUGRAM'),
('1925180005', 'MAJIGRAM BISWESWARI HIGH', '192527', '192518', 'MAJHIGRAM'),
('1925180006', 'MONGALKOTE A.K.M. HIGH SC', '192527', '192518', 'MONGALKOTE'),
('1925180007', 'PALISH GRAM HIGH SCHOOL', '192527', '192518', 'SIMULIA-II'),
('1925180008', 'NEGON DESBANDHU HIGH SCHO', '192527', '192518', 'SIMULIA-I'),
('1925180009', 'JHILO A.H.M. INSTITUTION', '192527', '192518', 'JHILOO-I'),
('1925180010', 'BEBUCHA F.P SCHOOL', '192527', '192518', 'JHILOO-II'),
('1925180011', 'KSHIRGRAM SRI JOGADYA BAN', '192526', '192518', 'KSHIROGRAM'),
('1925180012', 'KHATIRA F.P SCHOOL', '192525', '192518', 'LAKHURIA'),
('1925180013', 'SAOTA F.P. SCHOOL', '192526', '192518', 'NEGON'),
('1925180014', 'BAZAR BONKAPASI S.M HIGH', '192526', '192518', 'KAICHAR-II'),
('1925180015', 'MONGALKOTE-II CLRC OFFICE', '192526', '192518', 'KAICHAR-I'),
('1925190001', 'JAMNA HIGH SCHOOL', '192530', '192519', 'JAMNA'),
('1925190002', 'MADHYAMGRAM P.M. HIGH SCHOOL', '192530', '192519', 'MAJHERGRAM'),
('1925190003', 'SIJNA-UJNA-PANCHAPARA HIGH SCHOOL', '192530', '192519', 'BHAGRA-MULGRAM'),
('1925190004', 'PIPLON A.V. VIDYAMANDIR', '192530', '192519', 'PIPLON'),
('1925190005', 'PUTSURI GIRLS HIGH SCHOOL', '192529', '192519', 'PUTSURI'),
('1925190006', 'BAMUNPARA  ANCHALIK HIGH SCHOOL', '192529', '192519', 'BAMANPARA'),
('1925190007', 'BHURKUNDA B.M. INSTITUTION', '192529', '192519', 'DENUR'),
('1925190008', 'KAIGRAM HIGH SCHOOL', '192529', '192519', 'MAMUDPUR-II'),
('1925190009', 'RAIGRAM HIGH SCHOOL', '192529', '192519', 'MAMUDPUR-I'),
('1925190010', 'BANUI PANCHAPALLI VIDYAMANDIR', '192528', '192519', 'SUSUNIA'),
('1925190011', 'SUSUNA TARA M.J. VIDYAPITH', '192528', '192519', 'BAGHASON'),
('1925190012', 'KUSUMGRAM TYEBA INSTITUTION', '192528', '192519', 'KUSUMGRAM'),
('1925190013', 'SATIKRISHNA MONI GIRLS HIGH SCHOOL', '192528', '192519', 'MONTESWAR'),
('1925200001', 'JAHANNAGAR G.S.F.P. SCHOOL', '192531', '192520', 'JAHANNAGAR'),
('1925200002', 'RAJIBPUR S.S. VIDYAYATAN', '192533', '192520', 'BOGPUR'),
('1925200003', 'PURBASTHALI SOUTH CLRC', '192533', '192520', 'SRIRAMPUR'),
('1925200004', 'PARULDANGA NASRATPUR HIGH SCHOOL', '192533', '192520', 'NASRATPUR'),
('1925200005', 'NADANGHAT F.P. SCHOOL', '192533', '192520', 'NADANGHAT'),
('1925200006', 'SAMUDRAGARH HIGH SCHOOL', '192533', '192520', 'SAMUDRAGARH'),
('1925200007', 'DOGACHIA F.P. SCHOOL', '192531', '192520', 'DOGECHIA'),
('1925210001', 'CHATNI F.P. SCHOOL', '192532', '192521', 'NIMDAHA'),
('1925210002', 'JHOWDAN A.P.C. VIDYAMANDI', '192532', '192521', 'JHOWDANGA'),
('1925210003', 'LAKSHMIPUR F.P. SCHOOL', '192532', '192521', 'MAJIDA'),
('1925210004', 'NARAYANPUR NEHERU F.P. SC', '192532', '192521', 'PATULI'),
('1925210005', 'KUBAJPUR A. F.P. SCHOOL', '192532', '192521', 'MUKSHIMPARA'),
('1925210006', 'HAPANIA S.M. HIGH SCHOOL', '192532', '192521', 'PILLA'),
('1925210007', 'BISWARAMBHA JR. BASIC SCH', '192531', '192521', 'KALEKHANTALA-I'),
('1925210008', 'PURBASTHALI SABITARI BALI', '192531', '192521', 'PURBASTHALI'),
('1925210009', 'SIMLA F.P. SCHOOL', '192531', '192521', 'MERTALA'),
('1925210010', 'PARULIA(2 NO.) G.S. F.P.', '192531', '192521', 'KALEKHANTALA-II'),
('1925220001', 'GOPALNAGAR F.P. SCHOOL', '192535', '192522', 'NATU'),
('1925220002', 'BOKRA B.K. F.P. SCHOOL', '192535', '192522', 'RAINA'),
('1925220003', 'GUNAR F.P. SCHOOL', '192535', '192522', 'MUGURA'),
('1925220004', 'SEHARA BAZAR F.P. SCHOOL', '192534', '192522', 'SEHARA'),
('1925220005', 'SHYAMSUNDAR ADARSHA BALIK', '192534', '192522', 'SHYAMSUNDAR'),
('1925220006', 'NARUGRAM HIGH SCHOOL', '192534', '192522', 'NARUGRAM'),
('1925220007', 'BELSAR F.P. SCHOOL', '192534', '192522', 'HIJALNA'),
('1925220008', 'PALASHAN GIRLS JR. HIGH S', '192535', '192522', 'PALASON'),
('1925230001', 'MOHANPUR BINODPUR JR. HIG', '192536', '192523', 'PAHALANPUR'),
('1925230002', 'BARPUR PASONDA HIGH SCHOO', '192536', '192523', 'ARUI'),
('1925230003', 'JASHAPUR BARATI MD. HIGH', '192536', '192523', 'GOTAN'),
('1925230004', 'BARABAINAN U.S.K.SIKSHANI', '192536', '192523', 'BARA BAINAN'),
('1925230005', 'DOMMARA F.P. SCHOOL', '192537', '192523', 'UCHALAN'),
('1925230006', 'KAITI N.C. HIGH SCHOOL', '192537', '192523', 'KAITY'),
('1925230007', 'PAINTA J.M HIGH SCHOOL', '192537', '192523', 'PAINTA-II'),
('1925230008', 'HAREKRISHNA KONAR SHIKSHA', '192537', '192523', 'PAINTA-I'),
('1925240001', 'BELPUKUR G.S. F.P. SCHOOL', '192541', '192524', 'BURDWAN MP(22,23,24,25)'),
('1925240002', 'MAHARANI ADHIRANI BALIKA VIDYAL', '192541', '192524', 'BURDWAN MP(18,19,20,21)'),
('1925240003', 'ICHLABAD VIVEKANANDA BALIKA', '192541', '192524', 'BURDWAN MP(10,11,12,15)'),
('1925240004', 'SUBHAS VIDYAMANDIR G.S. F', '192541', '192524', 'BURDWAN MP(13,14,16,17)'),
('1925240005', 'BURDWAN TOWN SCHOOL', '192541', '192524', 'BURDWAN MP(9,33,34,35)'),
('1925240006', 'BURDWAN NIVEDITAKANYA VID', '192540', '192524', 'BURDWAN MP(2,25,26,27)'),
('1925240007', 'SAMIMA KHATUN G.S. F.P. S', '192540', '192524', 'BURDWAN MP(1,3,7,9,31)'),
('1925240008', 'BURDWANSRI R.K.S.P. UCHHA', '192540', '192524', 'BURDWAN MP(28,29,30,32)'),
('1925240009', 'DURBARJDIGHI M.F.P. SCHOO', '192540', '192524', 'BURDWAN MP(4,5,6,8,11)'),
('1925250001', 'DAINHAT GIRLS\' HIGH SCHOO', '192506', '192525', 'DAINHAT MP'),
('1925250002', 'CHARPATAIHAT HIGH SCHOOL', '192506', '192525', 'DAINHAT MP'),
('1925250003', 'DAINHAT HIGH SCHOOL', '192506', '192525', 'DAINHAT MP'),
('1925250004', 'DAINHAT CLRC OFFICE', '192506', '192525', 'DAINHAT MP'),
('1925260001', 'G.S.G.P.S.P SCHOOL', '192501', '192526', 'GUSHKARA MP(15)'),
('1925260002', 'GUSHKARA PURBA F.P SCHOOL', '192501', '192526', 'GUSHKARA MP(9,10,11,12)'),
('1925260003', 'KAMALNAGAR F.P. SCHOOL', '192501', '192526', 'GUSHKARA MP(7,8)'),
('1925260004', 'SUSHILA J.P.F.P.SCHOOL', '192501', '192526', 'GUSHKARA MP(1,2,3,4)'),
('1925270001', 'DANGAPARA CHANDI CHARAN F.P.', '192514', '192527', 'KALNA MP'),
('1925270002', 'KALNA MAHARAJ F.P. SCHOOL', '192514', '192527', 'KALNA MP'),
('1925270003', 'MADHUBAN F.P. SCHOOL', '192514', '192527', 'KALNA MP'),
('1925270004', 'GANESWAR JEW F.P. SCHOOL', '192514', '192527', 'HAT-KALNA'),
('1925270005', 'LALJEE MAHARAJ F.P. SCHOOL', '192514', '192527', 'KALNA MP'),
('1925280001', 'KATWA SRI RAMKRISHNA VIDY', '192519', '192528', 'KATWA MP(7,8,17)'),
('1925280002', 'JANAKI LAL SHIKSHASADAN', '192519', '192528', 'KATWA MP'),
('1925280003', 'D.D.C. GIRLS\' H.S. SCHOOL', '192519', '192528', 'KATWA MP(1,5,6,9,11)'),
('1925280004', 'KATWA KASIRAM DAS INSTITU', '192519', '192528', 'KATWA MP'),
('1925290001', 'TALPATA F.P. SCHOOL', '192524', '192529', 'MEMARI MP(7-16)'),
('1925290002', 'KABI SUKANTA SMRITI F.P.', '192524', '192529', 'MEMARI MP(1,2,3,4,5,6)')
ON DUPLICATE KEY UPDATE cluname = VALUES(cluname), clrccode = VALUES(clrccode), blockcode = VALUES(blockcode), area = VALUES(area);

-- disability (21 rows)
INSERT INTO disability (disability_id, disability_name) VALUES
('1', 'BLINDNESS'),
('2', 'LOW-VISION'),
('3', 'HEARING IMPAIRMENT (DEAF AND HARD OF HEARING)'),
('4', 'SPEECH AND LANGUAGE DISABILITY'),
('5', 'LOCOMOTOR DISABILITY'),
('6', 'MENTAL ILLNESS'),
('7', 'SPECIFIC LEARNING DISABILITIES'),
('8', 'CEREBRAL PALSY'),
('9', 'AUTISM SPECTRUM DISORDER'),
('10', 'MULTIPLE DISABILITIES INCLUDING DEAF BLINDNESS'),
('11', 'LEPROSY CURED PERSONS'),
('12', 'DWARFISM'),
('13', 'INTELLECTUAL DISABILITY'),
('14', 'MUSCULAR DYSTROPHY'),
('15', 'CHRONIC NEUROLOGICAL CONDITIONS'),
('16', 'MULTIPLE SCLEROSIS'),
('17', 'THALASSEMIA'),
('18', 'HEMOPHILIA'),
('19', 'SICKLE CELL DISEASE'),
('20', 'ACID ATTACK VICTIM'),
('21', 'PARKINSONS DISEASE')
ON DUPLICATE KEY UPDATE disability_name = VALUES(disability_name);

-- spledu (89 rows)
INSERT INTO spledu (regno, newregno, spl_edu_name, clrccode, rehab_quali, rehab_validity, contact1, contact2, email, status) VALUES
('A05031', NULL, 'SUMONA MAJUMDAR', '192522', 'PGDSE (MR)', '0000-00-00', NULL, NULL, NULL, '0'),
('A05808', NULL, 'CHANDRAMAN PAL', '192540', 'PGDSE (MR)', '2015-07-08', '6295314283', '9434387912', 'babuyapal@gmail.com', '0'),
('A05853', NULL, 'RAM CHANDRA ADHIKARI', '192541', 'PGDSE (MR)', '2011-06-30', '9732066451', NULL, NULL, '0'),
('A05858', NULL, 'JAYANTA KUMAR SAIN', '192544', 'PGDSE (MR)', '2016-02-14', '9476231900', '7908699328', 'jayantasain2012@gmail.com', '0'),
('A06228', NULL, 'ANITA KAR ACHARYA', '192512', 'PGDSE (MR)', '2021-06-30', '9732166243', '9064507483', 'anitaspecialedu@gmail.com', '0'),
('A06488', NULL, 'SHYAMA PROSAD GHOSH', '192526', 'PGDSE (MR)', '2018-01-14', '9732154151', NULL, 'Shyamaspledu@gmail.Com', '0'),
('A06543', NULL, 'SHYAMALENDU DUTTA', '192530', 'PGDSE(MR)', '2012-08-23', '9732254386', NULL, NULL, '0'),
('A06611', NULL, 'SUSMITA GHOSH (DHAR)', '192517', 'B.ED(HI)', '2023-12-31', '9749231563', NULL, NULL, '0'),
('A06660', NULL, 'SATYABRATA CHATTERJEE', '192526', 'PGDSE(MR)', '2016-07-01', '9641094339', '8250596569', NULL, '0'),
('A06709', NULL, 'SOMNATH SINGHA ROY', '192538', 'DSE (VI)', '0000-00-00', '9732263338', NULL, NULL, '0'),
('A06894', NULL, 'SRIMANTA GOSWAMI', '192536', 'B.ED. (MR)', '2012-12-29', '8512909605', '8370956994', 'srimantagoswami84@gmail.com', '0'),
('A07061', NULL, 'SOUMEN RAY', '192519', 'PGDSE (MR)', '2027-07-07', '9732359724', '7908033549', 'soumenrasy6@gmail.com', '0'),
('A07910', NULL, 'SAMIR KUMAR ROY', '192505', 'PGDSE(MR)', '2013-11-29', '9734276949', NULL, NULL, '0'),
('A08045', NULL, 'KUNTAL SEN', '192506', 'PGDSE (MR)', '0000-00-00', NULL, NULL, NULL, '0'),
('A08105', NULL, 'NUPUR MITRA', '192504', 'PGDSE(MR)', '2016-12-04', '9635323797', NULL, NULL, '0'),
('A08433', NULL, 'ANUPAM DATTA', '192520', 'B.ED. (VI)', '1970-01-01', '9832116989', '8926440963', 'mail.anupam.datta@gmail.com', '0'),
('A09896', NULL, 'HIMANSHU MONDAL', '192521', 'PGDSE (MR)', '2025-06-30', '9476233959', NULL, 'himanshumondal45@gmail.com', '0'),
('A11688', NULL, 'SIBANSU SEKHAR BHANJA', '192522', 'B.Ed. (VI)', '0000-00-00', '7797586283', NULL, NULL, '0'),
('A11803', NULL, 'BINOY KUMAR MONDAL', '192524', 'B.Ed. (HI)', '2013-11-06', '9432655269', NULL, NULL, '0'),
('A12147', NULL, 'NITYANANDA ROY', '192534', 'PGDSE(MR)', '2029-04-13', '9434163753', '9134480362', 'roynityananda899@gmail.com', '0'),
('A12149', NULL, 'RANJAN KUMAR GHOSH', '192524', 'PGDSE (MR)', '2029-07-17', '9475341375', '8918975414', 'ranjanghoshspledu@gmail.com', '0'),
('A12162', NULL, 'CHANDAN HALDER', '192508', 'PGDSE (MR)', '2013-12-17', '9933040978', NULL, 'chandanspecialeducator@gmail.com', '0'),
('A12165', NULL, 'PARITOSH MONDAL', '192531', 'PGDSE (MR)', '0000-00-00', '8900245458', NULL, NULL, '0'),
('A12167', NULL, 'NATARAJ SADHU', '192503', 'P.G.D.S.E. (MR)', '2031-06-04', '9153121571', NULL, 'nataraj196@gmail.com', '0'),
('A12328', NULL, 'INDRANIL MUKHERJEE', '192510', 'B.Ed. (MR)', '0000-00-00', NULL, NULL, NULL, '0'),
('A12673', NULL, 'SILPI MONDAL (HALDER)', '192511', 'B.Ed. (HI)', '2014-03-23', '8944933900', NULL, NULL, '0'),
('A12760', NULL, 'ASHOK ADHIKARI', '192530', 'B.ED. (HI)', '2014-03-31', '8001771429', '8906860543', 'adhikaria199@gmail.com', '0'),
('A13165', NULL, 'JAYDIP BHATTACHARYYA', '192515', 'B.Ed. (HI)', '2014-03-30', '9635382336', NULL, NULL, '0'),
('A14351', NULL, 'DEBKUMAR NANDI', '192538', 'DSE(MR)', '0000-00-00', NULL, NULL, NULL, '0'),
('A15170', NULL, 'RANAJIT GUPTA', '192523', 'B.Ed. (HI)', '0000-00-00', NULL, NULL, NULL, '0'),
('A17769', NULL, 'SRIDHAR SOM', '192539', 'DSE(MR) & B.ED(MR)', '2015-10-07', '8900252093', NULL, NULL, '0'),
('A24034', NULL, 'SOUMEN JASH', '192532', 'DSE (HI) & BED (HH) & ISL', '2024-12-10', '9734711984', '7001537327', 'mars.adii2012@gmail.com', '0'),
('A27298', NULL, 'SOUMEN NAYAK', '192507', 'DSE (HI)', '0000-00-00', NULL, NULL, NULL, '0'),
('A27303', NULL, 'RATNESWAR MUKHERJEE', '192520', 'DSE (HI)', '2027-10-13', '8250071887', '9126495282', 'baishakhimukherjee01@gmail.com', '0'),
('A27568', NULL, 'NIRMAL CHANDRA GHOSH', '192540', 'DSE(HI)', '0000-00-00', NULL, NULL, NULL, '0'),
('A28973', NULL, 'CHANDRACHUR DAS', '192514', 'DSE (MR)', '0000-00-00', NULL, NULL, NULL, '0'),
('A28979', NULL, 'BIJOY GARAI', '192501', 'DSE (HI)', '0000-00-00', NULL, NULL, NULL, '0'),
('A32855', NULL, 'BEAUTY DE', '192503', 'DSE (VI) PRIMARY LEVEL', '0000-00-00', NULL, NULL, NULL, '0'),
('A32927', NULL, 'SANDHYA ROY MAHATA', '192511', 'DSE (VI)', '0000-00-00', NULL, NULL, NULL, '0'),
('A33945', NULL, 'KANIKA RAJAK', '192516', 'B.ED (HI)', '2023-12-31', '9733870218', NULL, NULL, '0'),
('A35607', NULL, 'UTPAL KUMAR CHAKRABORTY', '192529', 'DSE (MR) B.ED  (SPL- MR)', '2019-03-06', '9732090271', NULL, 'utpal271@gmail.com', '0'),
('A35652', NULL, 'BIPLAB KOLEY', '192512', 'DSE(MR) , BED SE DE', '2025-03-31', '9432917658', '9064985515', 'koleybiplab05@gmail.com', '0'),
('A37006', NULL, 'RAJU BAG', '192544', 'DSE (MR) AND B.ED SEDE(H.I)', '2025-05-27', '9153344601', '9832884121', 'amarbag98@gmail.com', '0'),
('A41544', NULL, 'DEBNATH MONDAL', '192518', 'DSE (MR)', '0000-00-00', NULL, NULL, NULL, '0'),
('B05006', NULL, 'BARUN GHAR', '192536', 'DSE (HI)', '0000-00-00', NULL, NULL, NULL, '0'),
('B05299', NULL, 'SUMITA BEJ', '192542', 'DSE(MR)', '2026-07-09', '9474040108', NULL, 'sumitabej1974@gmail.com', '0'),
('B06035', NULL, 'SUSHANTA CHAKRABORTY', '192534', 'DSE (MR)', '2015-07-08', '9609387706', NULL, NULL, '0'),
('B06262', NULL, 'PRASAD KUMAR PRADHAN', '192503', 'DSE (MR)', '2016-02-09', '9732308374', NULL, NULL, '0'),
('B06464', NULL, 'AKSHAY HALDER', '192506', 'DSE(MR)', '0000-00-00', '8927641293', NULL, NULL, '0'),
('B07515', 'A38589', 'SOMA BANERJEE (CHATTERJEE)', '192516', 'B.ED(HI)', '2013-08-01', '9051626958', NULL, NULL, '0'),
('B07516', NULL, 'SOMA BANERJEE (CHATTERJEE)', '192517', 'DSE(HI)', '2013-08-01', '9051626958', NULL, 'nothing@nothing.com', '1'),
('B09480', NULL, 'RUPAK NARAYAN BASU', '192539', 'DSE (HI)', '2016-06-29', '9153401487', NULL, 'rupakspledu@gmail.comcom', '0'),
('B09739', NULL, 'SHANTIRAM DAS', '192527', 'DSE (MR)', '2019-03-20', '9609540526', NULL, 'shantiramspledu@gmail.com', '0'),
('B09918', NULL, 'SRIMANTA DAS', '192523', 'DVTE (MR)', '2011-05-23', '9932953679', '7908985487', 'srimantaspledu@gmail.com', '0'),
('B10063', NULL, 'VIVEKANANDA GHOSH', '192537', 'DVTE (MR)', '2012-07-11', '9434522511', NULL, 'vivekanandaspledu@gmail.cvom', '0'),
('B11210', NULL, 'PARTHA SARATHI SAMANTA', '192528', 'DSE (MR)', '2017-02-09', '9732271120', NULL, NULL, '0'),
('B11642', NULL, 'DEBASIS CHATTERJEE', '192535', 'DSE (MR)', '2017-06-20', '7699287929', NULL, NULL, '0'),
('B11937', NULL, 'NAMITA GUPTA (DEY)', '192507', 'DSE (MR)', '2013-09-30', '7872380175', '9064945353', 'guptanamita7872380175@gmail.com', '0'),
('B12000', NULL, 'KALYAN MUKHERJEE', '192504', 'DSE (HI)', '2013-10-30', '9732014744', NULL, 'subhamaykonar@gmail.com', '1'),
('B12240', NULL, 'SUBIR MUKHERJEE', '192543', 'DSE (HI)', '2011-12-28', '9432101629', NULL, NULL, '0'),
('B12244', NULL, 'JHUMA DAS', '192502', 'DVTE (MR)', '2013-12-29', '9734712603', NULL, NULL, '0'),
('B12249', NULL, 'BUDDHADEV BHATTACHERJYA', '192543', 'DSE (MR)', '2017-06-20', '9732057821', NULL, NULL, '0'),
('B12313', NULL, 'CHANDRANI MUKHERJEE', '192505', 'DSE (HI)', '2013-12-28', '9593490688', NULL, NULL, '0'),
('B12608', NULL, 'SHIBAKALI GHOSH', '192515', 'DSE (MR)', '2024-09-20', '9002593178', NULL, 'shibakali.se@gmail.com', '0'),
('B13212', NULL, 'SAMIR KUMAR GHOSH', '192502', 'DSE (VI)', '2014-06-05', '9333988997', NULL, NULL, '0'),
('B13315', NULL, 'SNEHASISH BANDYOPADHYAY', '192521', 'DSE (MR)', '2012-06-25', '9933552737', NULL, NULL, '0'),
('B14238', NULL, 'PARTHA BISWAS', '192513', 'DSE (MR)', '2012-10-22', '9477078692', NULL, NULL, '0'),
('B14324', NULL, 'PRATIMA DAS', '192518', 'DSE (MR)', '2014-12-06', '9333805599', NULL, NULL, '0'),
('B14348', NULL, 'SAMARESH PAUL', '192511', 'DSE (MR)', '2012-11-28', '7001702023', '9734254005', 'samareshpaul78@gmail.com', '0'),
('B14370', NULL, 'SANDIP KUMAR', '192533', 'DSE(MR)', '2012-11-28', '9734711374', '7001006607', 'sandipspledu4@gmail.com', '0'),
('B16344', NULL, 'LIAKAT ALI SARKAR', '192518', 'DSE (VI)', '2013-04-29', '8637838211', '9563318961', 'liakatalisarkar0@gmail.com', '0'),
('B16372', NULL, 'DULAL BARMAN', '192513', 'DSE (VI)', '0000-00-00', '9851377905', NULL, NULL, '0'),
('B16486', NULL, 'CHANDAN NANDI', '192537', 'DSE (VI)', '2015-04-30', '9732157501', NULL, NULL, '0'),
('B17056', NULL, 'HARI CHARAN KUNDU', '192535', 'DSE (VI)', '2013-06-23', '9064596322', '9432893829', 'haricharan31982@gmail.com', '0'),
('B17143', NULL, 'SUROJIT LET', '192510', 'DSE (VI)', '2015-06-23', '8116601687', NULL, NULL, '0'),
('B17684', NULL, 'ABHIJIT SARKAR', '192504', 'DSE(HI)', '2015-09-24', '9232366487', NULL, NULL, '0'),
('B18124', NULL, 'SANCHITA MAL (KONER)', '192541', 'DSE (VI)', '0000-00-00', NULL, NULL, NULL, '0'),
('B18189', NULL, 'SOMA NATH', '192531', 'DSE (MR)', '2013-11-27', '9153792557', NULL, NULL, '0'),
('B18192', NULL, 'SUMANTA PAUL', '192542', 'DSE (MR)', '2028-05-06', '7001355562', '9232052848', 'sumantapaul576@gmail.com', '0'),
('B18195', NULL, 'CHINMOY DEY', '192519', 'DSE (MR)', '2014-11-27', '9681478777', NULL, NULL, '0'),
('B18344', NULL, 'SK. MAINUDDIN', '192509', 'DSE(HI)', '0000-00-00', NULL, NULL, NULL, '0'),
('B18399', NULL, 'TUSHAR KANTI EBNERJEE', '192533', 'DVR (MR)', '2013-12-21', '9732128963', NULL, NULL, '0'),
('B18403', NULL, 'MAYNA JASH(DAS)', '192528', 'DSE(HI); ISL(A LEVEL)', '2024-12-10', '9832807889', NULL, 'mayna2013@gmail.com', '0'),
('B18405', NULL, 'BAISAKHI CHATTERJEE', '192529', 'DSE (HI)', '2013-12-22', '9153785245', NULL, NULL, '0'),
('B19486', NULL, 'ASHOK DEBNATH', '192506', 'DSE (VI)', '2014-04-27', '9932052332', NULL, NULL, '0'),
('B19676', NULL, 'SIBAPRASAD MONDAL', '192525', 'DSE (VI)', '2016-04-26', '9593102743', '9382538349', 'sibaprasadspledu@gmail.com', '0'),
('B19742', NULL, 'MANIK CHANDRA ROY', '192521', 'DSE (VI)', '2014-04-30', '9635383618', '9641253823', NULL, '0'),
('B19746', NULL, 'RUMPA NANDI MONDAL', '192509', 'DSE(VI)', '2014-04-30', '9647916189', NULL, NULL, '0'),
('B21387', NULL, 'ARABINDA GHOSH', '192532', 'DSE (MR)', '2016-11-16', '9735105030', '8617305271', 'arabindabaghason@gmail.com', '0')
ON DUPLICATE KEY UPDATE spl_edu_name = VALUES(spl_edu_name), clrccode = VALUES(clrccode), status = VALUES(status);
SET FOREIGN_KEY_CHECKS = 1;