('vf5o6vdo1f7tr58jopa9ub6s6rae2qda','134.122.27.186',1742960468,_binary '__ci_last_regenerate|i:1742960468;'),('vf5vemqcbpot09df822jlrv0kntqrf2k','134.122.27.186',1745488447,_binary '__ci_last_regenerate|i:1745488447;'),('vf6vvcgupcud2474tjs2g97gakqqabp8','134.122.27.186',1744485066,_binary '__ci_last_regenerate|i:1744485066;'),('vf8bv60g3k5o44qt6cq63vajpn70skhj','134.122.27.186',1744321205,_binary '__ci_last_regenerate|i:1744321205;'),('vfbl86qv8r0h5g5vngmcsm6c9j7j7d49','134.122.27.186',1741365133,_binary '__ci_last_regenerate|i:1741365133;'),('vfcdqm00t9uq8gcbjlu59vgnlkjqgfal','134.122.27.186',1743657614,_binary '__ci_last_regenerate|i:1743657614;'),('vfct7josfpcg48qkdbqmg3jra62r2rf6','134.122.27.186',1744091407,_binary '__ci_last_regenerate|i:1744091407;'),('vfd35henba7g4le77804453gc5h208pd','134.122.27.186',1743090188,_binary '__ci_last_regenerate|i:1743090188;'),('vfd7v9bflos3m72jqqa960ukmtd24e92','134.122.27.186',1738711569,_binary '__ci_last_regenerate|i:1738711569;'),('vffba0gmld37pen94qfgcfua9gchii4e','134.122.27.186',1745277066,_binary '__ci_last_regenerate|i:1745277066;'),('vffve3hulth3ggb4t4hrnb8cee1timul','134.122.27.186',1742680749,_binary '__ci_last_regenerate|i:1742680749;'),('vfg7o4h6fie12qpn6v2sdrhrknu293he','134.122.27.186',1744316948,_binary '__ci_last_regenerate|i:1744316948;'),('vfipp352i6lnlksdlkourb3vmcmfdr0e','134.122.27.186',1744867624,_binary '__ci_last_regenerate|i:1744867624;'),('vfkclam9fotpmdijodmuobkbc7626nb1','134.122.27.186',1744793406,_binary '__ci_last_regenerate|i:1744793406;'),('vfleb1mm2639qic365qehrf9aersrdgu','134.122.27.186',1742819892,_binary '__ci_last_regenerate|i:1742819892;'),('vflrf63e907jb3bdbke76d15ob7till4','134.122.27.186',1741678929,_binary '__ci_last_regenerate|i:1741678929;'),('vfmdatjed4dbhorsis61ph794mqml9qd','134.122.27.186',1739883636,_binary '__ci_last_regenerate|i:1739883636;'),('vfn52geu3aopjtc43s1ms0ep68r8n924','134.122.27.186',1741551486,_binary '__ci_last_regenerate|i:1741551486;'),('vfp1a24655cqekdsajhu8hsifnf26uac','134.122.27.186',1741470428,_binary '__ci_last_regenerate|i:1741470428;'),('vfsbhlo2u3jabd2bmocm5qhd8une4i3k','134.122.27.186',1745412248,_binary '__ci_last_regenerate|i:1745412248;'),('vfse42dqj3g067q9t9dc7ma00016qd15','134.122.27.186',1743274988,_binary '__ci_last_regenerate|i:1743274988;'),('vfsg444okjgplqbc5kne937uf2n8e532','134.122.27.186',1744621804,_binary '__ci_last_regenerate|i:1744621804;'),('vfunp2hr31j5v2lf7io9pt0gi7bt04ga','134.122.27.186',1745709546,_binary '__ci_last_regenerate|i:1745709546;'),('vfurif9q6kldsembmob5cm4aaj0i7ah0','134.122.27.186',1743879370,_binary '__ci_last_regenerate|i:1743879370;'),('vfv81e6q87h2iq6sbrftsasdt2enki8r','134.122.27.186',1741478525,_binary '__ci_last_regenerate|i:1741478525;'),('vfveq1pe4vc3ovao1q7r6ugqior820s9','134.122.27.186',1742183828,_binary '__ci_last_regenerate|i:1742183827;'),('vg0tftlkmfdmqo6art8hogbah01qtjkv','134.122.27.186',1745434927,_binary '__ci_last_regenerate|i:1745434927;'),('vg1qv6q6sis79e0vn1mgbc2ejk365r26','134.122.27.186',1738476124,_binary '__ci_last_regenerate|i:1738476124;'),('vg4m954noa1rjbnm097jcpblceeupugf','134.122.27.186',1739733729,_binary '__ci_last_regenerate|i:1739733729;'),('vg6v4gfrrhn8lbnves5348rgg82fsbcq','134.122.27.186',1740322451,_binary '__ci_last_regenerate|i:1740322451;'),('vg889gc27qb9kr0obbe0ci3hae1l2r99','134.122.27.186',1741197492,_binary '__ci_last_regenerate|i:1741197492;'),('vg8gcjc6jjcu7uv7m4729d01e5fnq8tq','134.122.27.186',1740490689,_binary '__ci_last_regenerate|i:1740490689;'),('vg9nb7rnkslpimijbtn5nc1lb7k0g804','134.122.27.186',1745394907,_binary '__ci_last_regenerate|i:1745394907;'),('vgctci9pdt09m9k0jo9in848rulnjer3','134.122.27.186',1741501388,_binary '__ci_last_regenerate|i:1741501388;'),('vgdor7nu5hit1at8hbeekuvsmvcmt91o','134.122.27.186',1741292110,_binary '__ci_last_regenerate|i:1741292110;'),('vgea0h0igg99ihgt5abqivgufc7na6t1','134.122.27.186',1740167109,_binary '__ci_last_regenerate|i:1740167109;'),('vgf1u1oe2dv582plftd5bt6rr5nnjrfe','134.122.27.186',1739841730,_binary '__ci_last_regenerate|i:1739841730;'),('vgff528en62bgskdjhsevso4haj6blvs','134.122.27.186',1739333231,_binary '__ci_last_regenerate|i:1739333231;'),('vgkn0klb13b40cpodhcjijc96mlnshem','134.122.27.186',1746711486,_binary '__ci_last_regenerate|i:1746711486;'),('vgkphl7k87jt88t3q1p8knddruaoos6v','134.122.27.186',1740721329,_binary '__ci_last_regenerate|i:1740721329;'),('vglu4p4d685jhf7vpmj2ajglukpjfiuo','134.122.27.186',1739027288,_binary '__ci_last_regenerate|i:1739027288;'),('vgnelig4aivtti7an2net26g6erfl57d','134.122.27.186',1742340973,_binary '__ci_last_regenerate|i:1742340973;'),('vgo1pcrtftqo9tj2chghi787prmlbbd4','134.122.27.186',1747085587,_binary '__ci_last_regenerate|i:1747085587;'),('vgpfnkig824p4dg6bntvn25nfvfvcs4n','134.122.27.186',1746851585,_binary '__ci_last_regenerate|i:1746851585;'),('vgpnp97fdi9o2poqo8c18ln2i28rggcn','134.122.27.186',1739613638,_binary '__ci_last_regenerate|i:1739613638;'),('vgprru0kai0r7b6mbo25d3iedb3oqr1p','134.122.27.186',1746857584,_binary '__ci_last_regenerate|i:1746857584;'),('vgrupo63dgu1a9p966qm1ke3qjbt3v9f','134.122.27.186',1745961546,_binary '__ci_last_regenerate|i:1745961546;'),('vgt44mbend3jscmu2qegjsck1rrf3911','134.122.27.186',1747194144,_binary '__ci_last_regenerate|i:1747194144;'),('vgt71bobmi8hlbam8v5m1nbg89p2ev5u','134.122.27.186',1742739012,_binary '__ci_last_regenerate|i:1742739012;'),('vgttf2nt4seta6mb9plr1sn3he8joarc','134.122.27.186',1739718037,_binary '__ci_last_regenerate|i:1739718037;'),('vgu2tsed9lu2b8ccs6i5tsl3fscslkha','134.122.27.186',1743429251,_binary '__ci_last_regenerate|i:1743429251;'),('vgud9103vtk9vtr86cgk55j7lastfdoc','134.122.27.186',1747032247,_binary '__ci_last_regenerate|i:1747032247;'),('vh16htlaoifofsg4pne5q1v9q5l6i8de','134.122.27.186',1739612530,_binary '__ci_last_regenerate|i:1739612530;'),('vh2qc5398u1moqgptek9foqiksl3navm','134.122.27.186',1741126031,_binary '__ci_last_regenerate|i:1741126031;'),('vh2trfoiakkggm5tpdpal84ncnrk930q','134.122.27.186',1746809404,_binary '__ci_last_regenerate|i:1746809404;'),('vh3nstn1vkl3b4bqk9mgv0nmfqprlc2s','134.122.27.186',1738432946,_binary '__ci_last_regenerate|i:1738432946;'),('vh3stfctvq010ikvpgpmflg059n2a9is','134.122.27.186',1741503846,_binary '__ci_last_regenerate|i:1741503846;'),('vh5sok6jvgjo0juuajtc4jve8uc62o5i','134.122.27.186',1741853829,_binary '__ci_last_regenerate|i:1741853829;'),('vh6q4d2d8usmb6qk3sfbrsjndethjgfe','134.122.27.186',1742646489,_binary '__ci_last_regenerate|i:1742646489;'),('vh6rkc2gsbdhdcq99paqu4erp7037aq5','134.122.27.186',1744241465,_binary '__ci_last_regenerate|i:1744241465;'),('vh8ajnan7dvhh668gcauf709rb5oasvu','134.122.27.186',1747052946,_binary '__ci_last_regenerate|i:1747052946;'),('vh8dl4ultkustlgaddjhl2lpnve4t1fe','134.122.27.186',1740234909,_binary '__ci_last_regenerate|i:1740234909;'),('vh8slk5v6bj390v8spnc9cios72gdub8','134.122.27.186',1745281987,_binary '__ci_last_regenerate|i:1745281987;'),('vhbbco12b94iiub0e2llpd7njeai2gi5','134.122.27.186',1745512688,_binary '__ci_last_regenerate|i:1745512688;'),('vhdvulj9tkr6eu4sm4issksoik8frdt2','134.122.27.186',1744564444,_binary '__ci_last_regenerate|i:1744564444;'),('vhe8mtbf82lgakjlss0qvambo8svjti2','134.122.27.186',1745219408,_binary '__ci_last_regenerate|i:1745219408;'),('vheess10o06ptppm20h8v38h2otshbhl','134.122.27.186',1742966168,_binary '__ci_last_regenerate|i:1742966168;'),('vhhi1kfnut4urisfh78s168jduihidac','134.122.27.186',1739764147,_binary '__ci_last_regenerate|i:1739764147;'),('vhhk581t2ifegj4ko292nq5qmqp8g7rs','134.122.27.186',1738922769,_binary '__ci_last_regenerate|i:1738922769;'),('vhhm29agq9bj2cv30egoso88dthvsckr','134.122.27.186',1739297921,_binary '__ci_last_regenerate|i:1739297921;'),('vhi5gh2mvh1boeuu2p6ho7uc583mf5hs','134.122.27.186',1739579951,_binary '__ci_last_regenerate|i:1739579951;'),('vhk63g9ohovndhmvsf9p9j2gnbtqqkps','134.122.27.186',1746160626,_binary '__ci_last_regenerate|i:1746160626;'),('vhlocgmra5i934uvq5k7f7b1fu7dvdit','134.122.27.186',1743725409,_binary '__ci_last_regenerate|i:1743725409;'),('vhnriolt2vf5uftd11cc9vb0uhdv7ifh','134.122.27.186',1746805987,_binary '__ci_last_regenerate|i:1746805987;'),('vht44jves1k3a08qa7co69jlkouapi6t','134.122.27.186',1744536424,_binary '__ci_last_regenerate|i:1744536424;'),('vhvgp83rnhvigobd5u94rvr1covdin1o','134.122.27.186',1744329007,_binary '__ci_last_regenerate|i:1744329007;'),('vi0k4ml830djuk7bp5qgbon5el4phfh2','134.122.27.186',1739903349,_binary '__ci_last_regenerate|i:1739903349;'),('vi3gvabaiaquv85qv8bagk380m84r9kg','134.122.27.186',1745314922,_binary '__ci_last_regenerate|i:1745314922;'),('vi8btbci1tbq5k9vvroke33lpl5sqqq9','134.122.27.186',1743968170,_binary '__ci_last_regenerate|i:1743968170;'),('vi9ki5fsisjbqfskqghfgg9g5k8qa0ok','134.122.27.186',1741414265,_binary '__ci_last_regenerate|i:1741414265;'),('viafse5hqg9cq9frcf217cs7v3rpc864','134.122.27.186',1746291187,_binary '__ci_last_regenerate|i:1746291187;'),('vibss8miv73i05spisk932v0m35s3b20','134.122.27.186',1746752287,_binary '__ci_last_regenerate|i:1746752287;'),('vidp3c1v1n6cs789h1349frldk7dt2g0','134.122.27.186',1743182412,_binary '__ci_last_regenerate|i:1743182412;'),('vidvr0qt1bhaai22umar9j02edtkmson','134.122.27.186',1745018527,_binary '__ci_last_regenerate|i:1745018527;'),('vie4hkriinmf2h1psrst9fj76vr2crnd','134.122.27.186',1741162749,_binary '__ci_last_regenerate|i:1741162749;'),('vieojnou9l9oslf5ideecu5prggnoq30','134.122.27.186',1739014988,_binary '__ci_last_regenerate|i:1739014988;'),('vifd246814sa8kok2cbcn5qhuqend331','134.122.27.186',1741239610,_binary '__ci_last_regenerate|i:1741239610;'),('vifnvt3bcruarjh7pg90vhgcnqrk6u8n','134.122.27.186',1741559288,_binary '__ci_last_regenerate|i:1741559288;'),('vihnhecle64b2mfs0khl8muo6r2a1rop','134.122.27.186',1742476689,_binary '__ci_last_regenerate|i:1742476689;'),('vii0mnb6pc1t76dki41om54dklgc5hp4','134.122.27.186',1740539764,_binary '__ci_last_regenerate|i:1740539764;'),('vij6jern6hg6e2ue8fm4am003i3n3ghr','134.122.27.186',1742466250,_binary '__ci_last_regenerate|i:1742466250;'),('vikrtqv2068p367lvj6melkdc32j0mg7','134.122.27.186',1746826385,_binary '__ci_last_regenerate|i:1746826385;'),('viljosr7gshl8427931h7rsi5b6ibhu6','134.122.27.186',1744123748,_binary '__ci_last_regenerate|i:1744123748;'),('vimp4g78eh5hklud4r5devp6ut7avngq','134.122.27.186',1746739988,_binary '__ci_last_regenerate|i:1746739988;'),('vinunkg3fueemma8r6bio53d43qtooeq','134.122.27.186',1739433971,_binary '__ci_last_regenerate|i:1739433971;'),('vio7m27l50m462lm25j35h3hkefr64jq','134.122.27.186',1740571391,_binary '__ci_last_regenerate|i:1740571391;'),('viobmjf0800t3pv3kcta2a7h81bc1lng','134.122.27.186',1743425709,_binary '__ci_last_regenerate|i:1743425709;'),('viopbnlmh4dj8vdct2ijq856rd3t1lor','134.122.27.186',1746476767,_binary '__ci_last_regenerate|i:1746476767;'),('viouj7gian2pbis97tb6c47ar9gu29h7','134.122.27.186',1743018671,_binary '__ci_last_regenerate|i:1743018671;'),('vippaql600hu49ip11tf48hp8smj0883','134.122.27.186',1741194612,_binary '__ci_last_regenerate|i:1741194612;'),('vispdelbr0eevv6pl5j3lkh9ntbouuba','134.122.27.186',1744624623,_binary '__ci_last_regenerate|i:1744624623;'),('vistcacgmrdvi53e4ij5h0b59eq5kdaf','134.122.27.186',1740100930,_binary '__ci_last_regenerate|i:1740100930;'),('vitchucd813smij01n8jrdfcbsvp9f9r','134.122.27.186',1740295691,_binary '__ci_last_regenerate|i:1740295691;'),('viu4ikpf6b7ngjjlqig4kucgd7p22ne4','134.122.27.186',1738545730,_binary '__ci_last_regenerate|i:1738545730;'),('viu8s6emd5bq3gl9bt9jgsa5s10v5dqr','134.122.27.186',1745858766,_binary '__ci_last_regenerate|i:1745858766;'),('viudi0ck0hir5850h7lljmispi3ne8nn','134.122.27.186',1738409833,_binary '__ci_last_regenerate|i:1738409831;_prev_url|s:44:\"https://app.tagrit.com/sunbird/ps/cron/index\";'),('vj2a6jsl03vn8iitkskkaotdth8uiiq4','134.122.27.186',1742032749,_binary '__ci_last_regenerate|i:1742032749;'),('vj2nbqd1ilvmu1iqii6kd3sub81oo0nn','134.122.27.186',1742699049,_binary '__ci_last_regenerate|i:1742699049;'),('vj2v8o90ncg2lph6b016volua4p0e1at','134.122.27.186',1743598214,_binary '__ci_last_regenerate|i:1743598214;'),('vj337kv70r65fof43h06vdo0clb2g1jl','134.122.27.186',1744276806,_binary '__ci_last_regenerate|i:1744276806;'),('vj3869iv6ua4n7vetb51mrigbuvrcmnj','134.122.27.186',1738456807,_binary '__ci_last_regenerate|i:1738456807;'),('vj4i5iv2fp4fhjkkjhn5fo90lvv9mds0','134.122.27.186',1742864948,_binary '__ci_last_regenerate|i:1742864948;'),('vj4qamn1hos5ocvpgo75rcfgi4phsqeq','134.122.27.186',1741523226,_binary '__ci_last_regenerate|i:1741523226;'),('vj4qch3bsqpc50kfkfk6akvt8gs5ej4f','134.122.27.186',1740500411,_binary '__ci_last_regenerate|i:1740500411;'),('vj68h265mi5g12v824cahbkh2qcqsnig','134.122.27.186',1738914851,_binary '__ci_last_regenerate|i:1738914851;'),('vj6gscr65q8u44eethpl89ul5ska2vgv','134.122.27.186',1744543445,_binary '__ci_last_regenerate|i:1744543445;'),('vj75caeh1qeujtl19vvlm57i3juha3ni','134.122.27.186',1741335728,_binary '__ci_last_regenerate|i:1741335728;'),('vja9lhffhtcddq0u36dfkujro9mpqb4h','134.122.27.186',1743980470,_binary '__ci_last_regenerate|i:1743980470;'),('vjabo1t3m3mgp9u3eld8ja39c2094595','134.122.27.186',1746758170,_binary '__ci_last_regenerate|i:1746758170;'),('vjaq945dd87rf3arkt1sedtmt199h7kv','134.122.27.186',1744422425,_binary '__ci_last_regenerate|i:1744422425;'),('vjau82vjfg6vsbk70bm5dp435rjnhfun','134.122.27.186',1745081647,_binary '__ci_last_regenerate|i:1745081647;'),('vjdaa0uettrfmaohe3smo0grvp14r58t','134.122.27.186',1743969915,_binary '__ci_last_regenerate|i:1743969914;'),('vjf3bll6bsrbe89b2gblb17sg9tsl03a','134.122.27.186',1741091231,_binary '__ci_last_regenerate|i:1741091231;'),('vjf4reu9gsakktfma0g0gspkkgdovdb1','134.122.27.186',1739568132,_binary '__ci_last_regenerate|i:1739568132;'),('vjf5a0srnhnc5i42553gj47ennluelni','134.122.27.186',1742668444,_binary '__ci_last_regenerate|i:1742668444;'),('vjfu2cfqlf9bhbfqikpotc1opbjb6cnj','134.122.27.186',1741154537,_binary '__ci_last_regenerate|i:1741154537;'),('vjgotnf3t7j89s6uv5ofgl8ooflr3m0f','134.122.27.186',1744411211,_binary '__ci_last_regenerate|i:1744411211;'),('vjhljuiifc2nr8sqldu2dpt2bp0ppr7u','134.122.27.186',1746664385,_binary '__ci_last_regenerate|i:1746664385;'),('vjjsucffhkm60p0bt2ftmrhb8b2rl6rc','134.122.27.186',1741810209,_binary '__ci_last_regenerate|i:1741810209;'),('vjk1nmaqb7npibq1g42oq34rl57iij5k','134.122.27.186',1745040847,_binary '__ci_last_regenerate|i:1745040847;'),('vjkbjo5tams3j9uromvtt32vqrdlim2u','134.122.27.186',1742077632,_binary '__ci_last_regenerate|i:1742077632;'),('vjkcq3h9k3bh5doja11oditfr46vv2qj','134.122.27.186',1742620989,_binary '__ci_last_regenerate|i:1742620989;'),('vjkh8aqdlc9e5vce0eppsjdg9u23t0v6','134.122.27.186',1746466087,_binary '__ci_last_regenerate|i:1746466087;'),('vjmgcmkophoka4a8b3mupbgr5e3gnagf','134.122.27.186',1744342745,_binary '__ci_last_regenerate|i:1744342745;'),('vjmspd0d476rpo0vqr8ra86hu71eudqk','134.122.27.186',1745149626,_binary '__ci_last_regenerate|i:1745149626;'),('vjnhgq5ffook6nk7rsbtd1n0q7uin04v','134.122.27.186',1745806868,_binary '__ci_last_regenerate|i:1745806868;'),('vjpt2k89k0nfmauno0fv3nlrl7unqbf5','134.122.27.186',1744357987,_binary '__ci_last_regenerate|i:1744357987;'),('vk0o6i6jlovckt5t90q8f5908c1usgrg','134.122.27.186',1739662034,_binary '__ci_last_regenerate|i:1739662034;'),('vk1qpll8tj9hun9lfms6buafv4n95a19','134.122.27.186',1746040384,_binary '__ci_last_regenerate|i:1746040384;'),('vk338mhlf73jktraeuu2hb7i31rf1mlj','134.122.27.186',1745462767,_binary '__ci_last_regenerate|i:1745462767;'),('vk37pe2i8ftcqvfo5frnjd0usv88u495','134.122.27.186',1744285927,_binary '__ci_last_regenerate|i:1744285927;'),('vk473u13etauggo5lo3h4u5lt90k47l3','134.122.27.186',1742877430,_binary '__ci_last_regenerate|i:1742877430;'),('vk4kq8k4jgon0med7o1uhk1qfgvefoqn','134.122.27.186',1740444964,_binary '__ci_last_regenerate|i:1740444964;'),('vk5jsd05p2vcoi7t98p73u7f36rsk376','102.219.210.222',1738300229,_binary '__ci_last_regenerate|i:1738300229;red_url|s:32:\"https://sunbird.tagrit.com/admin\";_prev_url|s:47:\"https://sunbird.tagrit.com/admin/authentication\";'),('vk631vlpjh1oqonrjsbo3o5ibgo6nr2o','134.122.27.186',1739652493,_binary '__ci_last_regenerate|i:1739652493;'),('vk9g22c41ls92tbooif99ltcf7sbiea3','134.122.27.186',1743646873,_binary '__ci_last_regenerate|i:1743646873;'),('vkd18q6o32fcjktb97bc2el4d0dl1lpf','134.122.27.186',1741346475,_binary '__ci_last_regenerate|i:1741346475;'),('vkh1kfltrea88vltqoj519vd4l9tcgh0','134.122.27.186',1746326766,_binary '__ci_last_regenerate|i:1746326766;'),('vkh4aadbpj0je89ef51auimuhope4cf8','134.122.27.186',1739884992,_binary '__ci_last_regenerate|i:1739884992;'),('vkhj3mqnkkdfm4md4mc6ltbme1g01u9b','134.122.27.186',1746760627,_binary '__ci_last_regenerate|i:1746760627;'),('vkivhko4ovcke60qmslggd2haviodo23','134.122.27.186',1740165668,_binary '__ci_last_regenerate|i:1740165668;'),('vkjqc7hvnusrs2vqdmul33cf8fq6g4rt','134.122.27.186',1740716292,_binary '__ci_last_regenerate|i:1740716292;'),('vkkkf1ibpbpk1abn3rvscmifq8193vfc','134.122.27.186',1747010946,_binary '__ci_last_regenerate|i:1747010946;'),('vkkkns6sv9oi47ncuj3ar12u5sl81e4i','134.122.27.186',1745146027,_binary '__ci_last_regenerate|i:1745146027;'),('vkkobcvaq1krmg775q3vpso71fd5v0t7','134.122.27.186',1745956929,_binary '__ci_last_regenerate|i:1745956929;'),('vklstnle9sba2gujtj4qlca44h7k376d','134.122.27.186',1745851389,_binary '__ci_last_regenerate|i:1745851389;'),('vkm4k1a344r5r6l637etqaa578equc39','134.122.27.186',1742715014,_binary '__ci_last_regenerate|i:1742715014;'),('vkmn5n4g3q81ov3jv6f6ed6ljb3j6lk3','134.122.27.186',1745681410,_binary '__ci_last_regenerate|i:1745681410;'),('vkn8efkfnj2494r6p82iqi0ig8vpb3iu','134.122.27.186',1739865843,_binary '__ci_last_regenerate|i:1739865843;'),('vkr9nn44c5849fcjgvqv20f8gctnprua','134.122.27.186',1738915934,_binary '__ci_last_regenerate|i:1738915934;'),('vkvmq99ap5s5cf7lte982jeujt0gua2b','134.122.27.186',1745557867,_binary '__ci_last_regenerate|i:1745557867;'),('vl15ki0e1dqvsf5ksgurutee175oaiur','134.122.27.186',1740268450,_binary '__ci_last_regenerate|i:1740268450;'),('vl3s0i4g4467d2l2jvtbkj86g5mkt5g5','134.122.27.186',1745296327,_binary '__ci_last_regenerate|i:1745296327;'),('vl4gfgromtvqbds9k3a6p4ps6mcvluk3','134.122.27.186',1738918089,_binary '__ci_last_regenerate|i:1738918089;'),('vl5rocoif813n4ntamm8ct6ccjuhnvqu','134.122.27.186',1746129787,_binary '__ci_last_regenerate|i:1746129787;'),('vl877e9deisi9025gfpqn7qo98sn45jn','134.122.27.186',1741824909,_binary '__ci_last_regenerate|i:1741824909;'),('vl9oek6h9alkeidpief1krg49vv74ic0','134.122.27.186',1739823283,_binary '__ci_last_regenerate|i:1739823283;'),('vlegbeeodrje53hh98e901js8mlidufv','134.122.27.186',1740805634,_binary '__ci_last_regenerate|i:1740805634;'),('vlg1bv4ltvv9ilt0bfp84ja89gci8lmb','134.122.27.186',1744170248,_binary '__ci_last_regenerate|i:1744170248;'),('vlgfno9ufsc4ub5pgvd6evajcustkdnv','134.122.27.186',1738558576,_binary '__ci_last_regenerate|i:1738558576;'),('vlgol5rtgm50a7ujba92mfc9haqr1d82','134.122.27.186',1742679670,_binary '__ci_last_regenerate|i:1742679669;'),('vli5bigsie3bjrkj2t8b5ldbbiv02tn0','134.122.27.186',1739042587,_binary '__ci_last_regenerate|i:1739042587;'),('vlkqptmqnvp81scjriquldlk0ds8ggn8','134.122.27.186',1742234229,_binary '__ci_last_regenerate|i:1742234229;'),('vll7vgnskk7ql9ohgdtan0uebc9a1dc7','134.122.27.186',1743564851,_binary '__ci_last_regenerate|i:1743564851;'),('vlmm1qc4511s24q5j587acecj0asfio2','134.122.27.186',1743127572,_binary '__ci_last_regenerate|i:1743127572;'),('vlmoutqirj66j60c14dcpnuo8aoorhua','134.122.27.186',1746976809,_binary '__ci_last_regenerate|i:1746976809;'),('vlogged3q7r3b45butb96ds35pullrdb','134.122.27.186',1741870753,_binary '__ci_last_regenerate|i:1741870753;'),('vlppertalankkjdre1v2tfa3l5g1tmm9','134.122.27.186',1738362728,_binary '__ci_last_regenerate|i:1738362726;_prev_url|s:44:\"https://app.tagrit.com/sunbird/ps/cron/index\";'),('vlqjqhcoalhddevirjq8aq2nqnht93u8','134.122.27.186',1739808730,_binary '__ci_last_regenerate|i:1739808730;'),('vlqlakl2ag3modenvhrgis32933ddjuc','134.122.27.186',1741970410,_binary '__ci_last_regenerate|i:1741970410;'),('vlrf20m3sj2v8do6hi9k4l2rrh9f5u26','134.122.27.186',1743614474,_binary '__ci_last_regenerate|i:1743614474;'),('vlsa2iok5v6q0odt1mhfrv4vlq1ubou1','134.122.27.186',1744044369,_binary '__ci_last_regenerate|i:1744044369;'),('vlspm8piq7ncfi0pqign6k4746h6akk8','134.122.27.186',1742048951,_binary '__ci_last_regenerate|i:1742048951;'),('vlti38edqhoo2c7sbu8ajf10jqc2m22t','134.122.27.186',1745749387,_binary '__ci_last_regenerate|i:1745749387;'),('vm0g926mqgid4hlue3sogtjq4j6o9k5d','134.122.27.186',1747058167,_binary '__ci_last_regenerate|i:1747058167;'),('vm3e4uljv7d7bpresvcidquvug1f1shn','134.122.27.186',1746545947,_binary '__ci_last_regenerate|i:1746545947;'),('vm6d8lpif3oocauibeb0mtf92gbv66da','134.122.27.186',1741437306,_binary '__ci_last_regenerate|i:1741437306;'),('vm78p09pqgtsufreqd6f6grs1huk1o7i','134.122.27.186',1744639744,_binary '__ci_last_regenerate|i:1744639744;'),('vm7g0bd9sqoep7ndjskurjg6bjhin4a7','134.122.27.186',1742943491,_binary '__ci_last_regenerate|i:1742943491;'),('vm8ng8b05esfn8vepclhvpqihs3lqf1d','134.122.27.186',1746377768,_binary '__ci_last_regenerate|i:1746377768;'),('vm9fd5rco7t95hfqb6kllkp9vil7urtk','134.122.27.186',1738340651,_binary '__ci_last_regenerate|i:1738340649;_prev_url|s:44:\"https://app.tagrit.com/sunbird/ps/cron/index\";'),('vmaqpm1s0r5v9795dddat5feeu62qh3g','134.122.27.186',1746579663,_binary '__ci_last_regenerate|i:1746579663;'),('vmc2mo9pchmsl00bp0ic4l7q8589ti72','134.122.27.186',1739459385,_binary '__ci_last_regenerate|i:1739459385;'),('vmf6mqhrmbc0u1fo7065lop1a89n0va4','134.122.27.186',1739936949,_binary '__ci_last_regenerate|i:1739936949;'),('vmh06r7qpmtntu9fb50i7qj19ge0kvbt','134.122.27.186',1747036386,_binary '__ci_last_regenerate|i:1747036386;'),('vmhj4hi557ts492m8e0io70ktkucd8r9','134.122.27.186',1744103588,_binary '__ci_last_regenerate|i:1744103588;'),('vmi4lg98orl9d1hg8sd6ea9petsiajd9','134.122.27.186',1742377812,_binary '__ci_last_regenerate|i:1742377812;'),('vml45llal0hkd0spvo7ab1gb4ke610ro','134.122.27.186',1740469270,_binary '__ci_last_regenerate|i:1740469270;'),('vmm2882aof2g85o7vrqeffo02jmfvdj3','134.122.27.186',1742535728,_binary '__ci_last_regenerate|i:1742535728;'),('vmm9ntl5g6nhrhq40jk8viv9fe0asdq8','134.122.27.186',1742446270,_binary '__ci_last_regenerate|i:1742446270;'),('vmo8ekddqch3qdbq3iit5k4ipaptnnaq','134.122.27.186',1741152489,_binary '__ci_last_regenerate|i:1741152489;'),('vmofqarilshkkfgu9orn4u3k12ir8nru','134.122.27.186',1744310585,_binary '__ci_last_regenerate|i:1744310585;'),('vmolnljqca141atk6tpc69s0aql81nd6','134.122.27.186',1742925068,_binary '__ci_last_regenerate|i:1742925068;'),('vmq9grs1iirn8ebegpbtnmeaq58ub18b','134.122.27.186',1741140310,_binary '__ci_last_regenerate|i:1741140310;'),('vmr0gl2ft51fllt5hgi4584624ihc2ih','134.122.27.186',1742232791,_binary '__ci_last_regenerate|i:1742232791;'),('vmsdqj0ck23ddrg1cg6h00buv3s1foaf','134.122.27.186',1740104171,_binary '__ci_last_regenerate|i:1740104171;'),('vn01921ju4quuob353gsc0qdo8eo8pvn','134.122.27.186',1743959651,_binary '__ci_last_regenerate|i:1743959651;'),('vn3fb799960qtl2po1ij8hueo4046s31','134.122.27.186',1742404751,_binary '__ci_last_regenerate|i:1742404751;'),('vn4chu8tsvhrfvvfibujq0shtg1831us','134.122.27.186',1742932999,_binary '__ci_last_regenerate|i:1742932999;'),('vn4om5fd4a79bsdf24qfh8lemdi2j17r','134.122.27.186',1742690891,_binary '__ci_last_regenerate|i:1742690891;'),('vn6aglaojg2lpcuthllm4p1dkojas470','134.122.27.186',1739534830,_binary '__ci_last_regenerate|i:1739534830;'),('vn97elqemio9dp6ehlvrv58g1of2i7po','134.122.27.186',1743566591,_binary '__ci_last_regenerate|i:1743566591;'),('vnahipf11432bij6k08g71oejj0avtgj','134.122.27.186',1742937489,_binary '__ci_last_regenerate|i:1742937489;'),('vnbmnccf8d0s8i8433me6kvnspeq7i2q','134.122.27.186',1746177606,_binary '__ci_last_regenerate|i:1746177606;'),('vndk56cls22ircs7su4s2hvea5u011bf','134.122.27.186',1741684204,_binary '__ci_last_regenerate|i:1741684204;'),('vneguhj939hcdko3p0clhpm0de01o7ie','134.122.27.186',1738945958,_binary '__ci_last_regenerate|i:1738945958;'),('vneqq2o263vaqns3damoqit021v888vh','134.122.27.186',1742258950,_binary '__ci_last_regenerate|i:1742258950;'),('vnfg05iumf1ukqq61eohjaeskc9bqfpu','134.122.27.186',1747003026,_binary '__ci_last_regenerate|i:1747003026;'),('vnj12p8bbqtv77bqar9esttendn4a9ll','134.122.27.186',1742795288,_binary '__ci_last_regenerate|i:1742795288;'),('vnje8kgtu6tdnf91oe60nncluee9c315','134.122.27.186',1742257151,_binary '__ci_last_regenerate|i:1742257151;'),('vnlom9a5ik0jp57aplnbdta4fb72o780','134.122.27.186',1744810865,_binary '__ci_last_regenerate|i:1744810865;'),('vnna5vp92kav8gavga1hi5sj505mi43f','134.122.27.186',1743462784,_binary '__ci_last_regenerate|i:1743462784;'),('vnnbd5vf2oro7ikbet5k9ru1ivulb9b1','134.122.27.186',1742149090,_binary '__ci_last_regenerate|i:1742149090;'),('vnno66g1r3h7tckiiapmmhbiis7ubesf','134.122.27.186',1746574807,_binary '__ci_last_regenerate|i:1746574807;'),('vnpovm0d2l3sauj1rvq36frdupnpk5gj','134.122.27.186',1743567609,_binary '__ci_last_regenerate|i:1743567609;'),('vnqpv892bh3m5gfiorchjodj4sdibtvc','134.122.27.186',1741301410,_binary '__ci_last_regenerate|i:1741301410;'),('vnrdcor18oakf48qgfugco7p7hmfdl4d','134.122.27.186',1742814190,_binary '__ci_last_regenerate|i:1742814190;'),('vnv5e4tqnikgdrs73l4gp8seso3k8ve2','134.122.27.186',1740240611,_binary '__ci_last_regenerate|i:1740240611;'),('vo09v25a5r6l0vjbhs2pdp59esn2lngc','134.122.27.186',1738927030,_binary '__ci_last_regenerate|i:1738927030;'),('vo0bqrcan78885crf6mrlq53kfc26fvh','134.122.27.186',1744054687,_binary '__ci_last_regenerate|i:1744054687;'),('vo0h3ebd1n7o3975dsgdhbf8rkt4524j','134.122.27.186',1745292728,_binary '__ci_last_regenerate|i:1745292728;'),('vo0te83ag3mafoan9l42576fk869h5gs','134.122.27.186',1740304448,_binary '__ci_last_regenerate|i:1740304448;'),('vo2lsq1kc4fhc5qsn58r11rlqikntis3','134.122.27.186',1744620723,_binary '__ci_last_regenerate|i:1744620723;'),('vo51shqq6dg0e8jk6o3435l2rjov3bm2','134.122.27.186',1739809095,_binary '__ci_last_regenerate|i:1739809095;'),('vo7ghtnmo020gf8dj9289qoq9fnje2el','134.122.27.186',1740828428,_binary '__ci_last_regenerate|i:1740828428;'),('vochqqg4a305blmkbbgj9h55uhncn8id','134.122.27.186',1744825447,_binary '__ci_last_regenerate|i:1744825447;'),('vodd4ncknq126d2rbqdvefnaokr95l8a','134.122.27.186',1740794352,_binary '__ci_last_regenerate|i:1740794352;'),('voe1q2tbljdmom12j6s1ht6p2r9mqqfi','134.122.27.186',1740941770,_binary '__ci_last_regenerate|i:1740941770;'),('voef99unoo0al54i7hcij25ooer3797a','134.122.27.186',1738644788,_binary '__ci_last_regenerate|i:1738644788;'),('vogfl03h8fdgnfakree162fnpvo8rhl1','134.122.27.186',1746522967,_binary '__ci_last_regenerate|i:1746522967;'),('voh2nd4ofqn6vojmr6oepkg8nvi67f61','134.122.27.186',1741899791,_binary '__ci_last_regenerate|i:1741899791;'),('voisropces41hutm9mnud3no29ca4n0u','134.122.27.186',1744558865,_binary '__ci_last_regenerate|i:1744558865;'),('vokn3bkuimajp7hs26kftuht7cfgi67s','134.122.27.186',1747021268,_binary '__ci_last_regenerate|i:1747021268;'),('vom2e20ndh90valt0sup5ucf5sg7lrdk','134.122.27.186',1746137586,_binary '__ci_last_regenerate|i:1746137586;'),('vonl1vjdrhkah2rr7l9s6aa6r7bedk4h','134.122.27.186',1745088667,_binary '__ci_last_regenerate|i:1745088667;'),('voo8k8jmmeub4qmbtla762va5c3a8buk','134.122.27.186',1741967957,_binary '__ci_last_regenerate|i:1741967957;'),('vope5m4lcukc5kqj4sk8re91fcsigc61','134.122.27.186',1743573484,_binary '__ci_last_regenerate|i:1743573484;'),('vopso36jpm3ltu01ni3gjmi687pd74pi','134.122.27.186',1742231409,_binary '__ci_last_regenerate|i:1742231409;'),('vos6m4u00rmv74vc4bk4n00u0p5lbqsr','134.122.27.186',1742520970,_binary '__ci_last_regenerate|i:1742520970;'),('vot1i8dfpfclvi5dqfj3jqogkfnc822o','134.122.27.186',1740890464,_binary '__ci_last_regenerate|i:1740890464;'),('vou88npm15ojftor4i79shbb1la9s367','134.122.27.186',1740120848,_binary '__ci_last_regenerate|i:1740120848;'),('vp1olhknemuo5amkieovdonrvnikkg5v','134.122.27.186',1744398428,_binary '__ci_last_regenerate|i:1744398428;'),('vp2ggsjc199pfsunkben7bm7laokevp0','134.122.27.186',1746383709,_binary '__ci_last_regenerate|i:1746383709;'),('vp57erotkfgq2suhaohuhoa1lhkuapa8','134.122.27.186',1742094554,_binary '__ci_last_regenerate|i:1742094554;'),('vp5p1o15s4fbqnhndd0ohtsl1e3j7bar','134.122.27.186',1740545108,_binary '__ci_last_regenerate|i:1740545108;'),('vp6q6d8ni25i4ks3021jc86vdrmbg21s','134.122.27.186',1744212908,_binary '__ci_last_regenerate|i:1744212908;'),('vp7ga6nq4480ut46lr18ark352j690rl','134.122.27.186',1739708109,_binary '__ci_last_regenerate|i:1739708109;'),('vp9ooemdpp0b98iquq28j53dnh06rrql','134.122.27.186',1739934430,_binary '__ci_last_regenerate|i:1739934430;'),('vpa9sm9sfb9e5imddbr99vanjerhugio','134.122.27.186',1742575750,_binary '__ci_last_regenerate|i:1742575750;'),('vpckud82hu0cp3ul7nrhitu5t6ikqu2c','134.122.27.186',1740174607,_binary '__ci_last_regenerate|i:1740174607;'),('vpde7h8smbpi7evvnlbsbfjpp6atosio','134.122.27.186',1739575992,_binary '__ci_last_regenerate|i:1739575992;'),('vpdsbf2p365fi6hdt74o6tor3kddrpif','134.122.27.186',1746822907,_binary '__ci_last_regenerate|i:1746822907;'),('vpe85c1eqf2ba0bosdutr7ccoos0bq1b','134.122.27.186',1740623770,_binary '__ci_last_regenerate|i:1740623770;'),('vpeg7p2fn2bpiv3d78m0hkn81leferii','134.122.27.186',1742038091,_binary '__ci_last_regenerate|i:1742038091;'),('vpgs4okodu3cloq61m1vni86uru8ab58','134.122.27.186',1740099131,_binary '__ci_last_regenerate|i:1740099131;'),('vpheaq4ptchur7hbecfam260r0e35pf8','134.122.27.186',1741281132,_binary '__ci_last_regenerate|i:1741281132;'),('vpi9hi7rl0mm4560bso48j3chv8qvnj3','134.122.27.186',1742705829,_binary '__ci_last_regenerate|i:1742705828;'),('vpie2cqil5plr36j8cc002ij3blnurjq','134.122.27.186',1742865311,_binary '__ci_last_regenerate|i:1742865311;'),('vpieui2nor2i5tc04623kl8a7mi5jbh4','134.122.27.186',1742009409,_binary '__ci_last_regenerate|i:1742009409;'),('vpkf0b4csqmm1kjip1uv2tgbi9bsrbkt','134.122.27.186',1745024473,_binary '__ci_last_regenerate|i:1745024473;'),('vplnkh3dkc6sjtqdbe4uo8et8n8rbvt6','134.122.27.186',1740489969,_binary '__ci_last_regenerate|i:1740489969;'),('vpme2ha61qlfp7qltn9isqd7cojbvi51','134.122.27.186',1741582085,_binary '__ci_last_regenerate|i:1741582085;'),('vpo25jbsntqnjoapbuop6gseirrqdfki','134.122.27.186',1742402949,_binary '__ci_last_regenerate|i:1742402949;'),('vpr8vqm0sqsnn785n4jldb8f17p4k9s8','134.122.27.186',1743787150,_binary '__ci_last_regenerate|i:1743787150;'),('vprdtv4uhgek804il6tlhf9rb867ciip','134.122.27.186',1746926647,_binary '__ci_last_regenerate|i:1746926647;'),('vptlohlll45qpr3u2cn4a527i7aqgdk0','134.122.27.186',1743631993,_binary '__ci_last_regenerate|i:1743631993;'),('vpumrufbsch72c73ss7e0vdaem5bt3bo','134.122.27.186',1742618174,_binary '__ci_last_regenerate|i:1742618174;'),('vpvrhb00aja4928jgsf152geo7ucacj3','134.122.27.186',1738536969,_binary '__ci_last_regenerate|i:1738536969;'),('vq01454v39dotnunos2fg6rdmev6ubkk','134.122.27.186',1742794940,_binary '__ci_last_regenerate|i:1742794940;'),('vq0smmgcs1tpp6h994n71bdqu2arhmc3','134.122.27.186',1745707747,_binary '__ci_last_regenerate|i:1745707747;'),('vq21n6laslqrm0ujape2ld4pp7i27s46','134.122.27.186',1746837009,_binary '__ci_last_regenerate|i:1746837009;'),('vq29coi6rikcs6us97lqr9fsk1oi9qk3','134.122.27.186',1745809747,_binary '__ci_last_regenerate|i:1745809747;'),('vq664vdntncg2ojku45ksercjgtf6uq9','134.122.27.186',1740059349,_binary '__ci_last_regenerate|i:1740059349;'),('vq7dtq8ojq9621h05js8gnbemf1fa7s9','134.122.27.186',1740836709,_binary '__ci_last_regenerate|i:1740836709;'),('vq7gg3a39ugiba96a8raueb09nonbfb2','134.122.27.186',1739431091,_binary '__ci_last_regenerate|i:1739431091;'),('vq88a1brbtv7er7ugstvv7t7js38pgnd','134.122.27.186',1744768265,_binary '__ci_last_regenerate|i:1744768265;'),('vqaq5eio822b8j2hg9hgo7d1tlkg1hik','134.122.27.186',1744130403,_binary '__ci_last_regenerate|i:1744130403;'),('vqbsoe9u155jb66vf02cagtlr2rv39id','134.122.27.186',1740566349,_binary '__ci_last_regenerate|i:1740566349;'),('vqc1or7fieemhrqn9ed171oa2omgupcu','134.122.27.186',1745537947,_binary '__ci_last_regenerate|i:1745537947;'),('vqfd3s3lkmifd3jeas7g91073crt78fu','134.122.27.186',1740017351,_binary '__ci_last_regenerate|i:1740017351;'),('vqg7b6qtedtusa2itmvvc6v6af9irsab','134.122.27.186',1744678444,_binary '__ci_last_regenerate|i:1744678444;'),('vqhqp569auhduvdj2q0pnah5cjle86v6','134.122.27.186',1742901850,_binary '__ci_last_regenerate|i:1742901850;'),('vqirhj6vhi7gepp68rutimsfrjmkfb6u','134.122.27.186',1743955390,_binary '__ci_last_regenerate|i:1743955390;'),('vqj5jijcek2fsq11862vme9u26o592eo','134.122.27.186',1745945348,_binary '__ci_last_regenerate|i:1745945347;'),('vqlnpc1laja2ik1udr88d1i2u86jtcke','134.122.27.186',1739660224,_binary '__ci_last_regenerate|i:1739660224;'),('vqm1pev29u0eq24peq2mrr34s3rdhjd9','134.122.27.186',1743309732,_binary '__ci_last_regenerate|i:1743309732;'),('vqmdmo8ah3blf2np4popk2d6kubahgij','134.122.27.186',1746634026,_binary '__ci_last_regenerate|i:1746634026;'),('vqmndukggvh8een4haohc4ke2qkci9ku','134.122.27.186',1742243108,_binary '__ci_last_regenerate|i:1742243108;'),('vqp8md3kkthkd1rhcl1bip2l66l900na','134.122.27.186',1743674292,_binary '__ci_last_regenerate|i:1743674292;'),('vqs2t5rohip2qnpsrqa03up7sfl5m6bh','134.122.27.186',1742740811,_binary '__ci_last_regenerate|i:1742740811;'),('vr01dai8dp9prr3oq4lmotrpodg0adce','134.122.27.186',1746807304,_binary '__ci_last_regenerate|i:1746807304;'),('vr25e08h5lcgnojsqd607d4eu10mt3fj','134.122.27.186',1743931814,_binary '__ci_last_regenerate|i:1743931814;'),('vr4f0j5cd10jjg29ssr56g0rbqkj4jbg','134.122.27.186',1745272087,_binary '__ci_last_regenerate|i:1745272087;'),('vr5knsnrh2olgikk8rrgvignii471f4r','134.122.27.186',1741645864,_binary '__ci_last_regenerate|i:1741645864;'),('vr7kuu2mqcs388lto5lr2j6918ti4v6f','134.122.27.186',1743798491,_binary '__ci_last_regenerate|i:1743798491;'),('vre0eusd2nuds5ae238ufm1p5cgs27f3','134.122.27.186',1743345548,_binary '__ci_last_regenerate|i:1743345548;'),('vres4i0201ueuqt2hvpuqjudmc7m21ns','134.122.27.186',1740734590,_binary '__ci_last_regenerate|i:1740734590;'),('vrgi1u3b4t0jt4a3r3oolt86ha9t1r13','134.122.27.186',1745479262,_binary '__ci_last_regenerate|i:1745479262;'),('vrhtka8d0kd3a60918m3thopmudj1i0r','134.122.27.186',1744246505,_binary '__ci_last_regenerate|i:1744246505;'),('vriee97poml88nauu4p042a50l2v5rct','134.122.27.186',1745322667,_binary '__ci_last_regenerate|i:1745322667;'),('vrklpsbt1ip4c9hc5jef2vcdl706qbef','134.122.27.186',1746726487,_binary '__ci_last_regenerate|i:1746726487;'),('vrkv7cb3b123p9nc847j4b1llgtsf0r5','134.122.27.186',1742735469,_binary '__ci_last_regenerate|i:1742735469;'),('vrl7spt8hb123lql4561gkjqhff01jqd','134.122.27.186',1746137225,_binary '__ci_last_regenerate|i:1746137225;'),('vrngjo5dlqiqlncbavjpkfpr753vcqso','134.122.27.186',1738510208,_binary '__ci_last_regenerate|i:1738510208;'),('vrog7vch3hg4a6i5if2ua6smakqadmnc','134.122.27.186',1740343269,_binary '__ci_last_regenerate|i:1740343269;'),('vrprqc37mtro23gnvs2b0oe1pchvsacs','134.122.27.186',1742384526,_binary '__ci_last_regenerate|i:1742384526;'),('vrs3pkgckjkv174ecplpet0he66dd6t3','134.122.27.186',1741188491,_binary '__ci_last_regenerate|i:1741188491;'),('vrup6nscuvomnjdhl7u9ui8911jthkik','134.122.27.186',1741251490,_binary '__ci_last_regenerate|i:1741251490;'),('vs0g99v829lba7un5c6m5mr02sm1hhnn','134.122.27.186',1744994168,_binary '__ci_last_regenerate|i:1744994168;'),('vs3jkusjlgoh7ltqe55aeormfbstdpo8','134.122.27.186',1747054686,_binary '__ci_last_regenerate|i:1747054686;'),('vs48393vn8q4p9aeiqelr9d3770o7qlq','134.122.27.186',1745167988,_binary '__ci_last_regenerate|i:1745167988;'),('vs6btf5vdrb7jq5sdusc9dfqr8hmsilv','134.122.27.186',1744466346,_binary '__ci_last_regenerate|i:1744466346;'),('vs8qu5qbgdqs7dbef8k0j386f83lee2o','134.122.27.186',1743454991,_binary '__ci_last_regenerate|i:1743454991;'),('vs9jsnuoo307mcs7jtok58539psko588','134.122.27.186',1743590652,_binary '__ci_last_regenerate|i:1743590652;'),('vscnbrvbvub3ucc60tsibohn2gsa3rl3','134.122.27.186',1744707545,_binary '__ci_last_regenerate|i:1744707545;'),('vsdqsi2l8j9biajlhu6agbkd9ccbkf62','134.122.27.186',1747031527,_binary '__ci_last_regenerate|i:1747031527;'),('vsel0i9h1jn0jh6hsccl1aqlm2egecd1','134.122.27.186',1742039890,_binary '__ci_last_regenerate|i:1742039890;'),('vsf0kahng599bbauhmorocmttsv6ckgn','134.122.27.186',1738405151,_binary '__ci_last_regenerate|i:1738405149;_prev_url|s:44:\"https://app.tagrit.com/sunbird/ps/cron/index\";'),('vsfla3tr4fj7o5ujsfjagj1r2plk2fb9','134.122.27.186',1740306607,_binary '__ci_last_regenerate|i:1740306607;'),('vsfroptfo5amsv6hqbj2b840j8ar9ujq','134.122.27.186',1742873832,_binary '__ci_last_regenerate|i:1742873832;'),('vsksf73srft7qevds2ghm8vu29bppviv','134.122.27.186',1743553150,_binary '__ci_last_regenerate|i:1743553150;'),('vsl0grm1726cvfleru2lnht7vqjj06l5','134.122.27.186',1738520231,_binary '__ci_last_regenerate|i:1738520231;'),('vsnkqn8b1v444154cc9aomv5advfh5ke','134.122.27.186',1740886268,_binary '__ci_last_regenerate|i:1740886268;'),('vsrebcg56hd4hlb0lbsmolbpp0bugven','134.122.27.186',1740656736,_binary '__ci_last_regenerate|i:1740656736;'),('vsrmjchsavo15aik5n93o95g24naut0j','134.122.27.186',1741580286,_binary '__ci_last_regenerate|i:1741580286;'),('vssfldk78c2rqiunqrub71m475s87k6a','134.122.27.186',1745736066,_binary '__ci_last_regenerate|i:1745736066;'),('vsupobv944vflcs79h9fe09ik6mop5s3','134.122.27.186',1743991030,_binary '__ci_last_regenerate|i:1743991030;'),('vsvlvr1spkp3gag61dn3ookjfp843u9d','134.122.27.186',1743027670,_binary '__ci_last_regenerate|i:1743027670;'),('vsvsdni5rcn7s7s1rtpnl61dq3jo37ep','134.122.27.186',1738793888,_binary '__ci_last_regenerate|i:1738793888;'),('vt0ah4kcogm7aam32ur680g5via6rjv3','134.122.27.186',1742585472,_binary '__ci_last_regenerate|i:1742585472;'),('vt12atjlnkj2qphh1uknhlbsu2v6ao4v','134.122.27.186',1741241712,_binary '__ci_last_regenerate|i:1741241712;'),('vt1lmuek67fs0huog0ip1n1tp4rss189','134.122.27.186',1744713244,_binary '__ci_last_regenerate|i:1744713244;'),('vt6fiqkm45ag3k4mpj5d12n4o2ln602q','134.122.27.186',1742620271,_binary '__ci_last_regenerate|i:1742620271;'),('vt7mngkblfvid58mvpl86u0iho64vq7k','134.122.27.186',1742987593,_binary '__ci_last_regenerate|i:1742987593;'),('vt83n7s4n92fud0hapupgs6f3cpilof9','134.122.27.186',1746457809,_binary '__ci_last_regenerate|i:1746457809;'),('vt9r0m00gjueu4rdlol58n0camtr9g25','134.122.27.186',1742794569,_binary '__ci_last_regenerate|i:1742794569;'),('vta4fqqdid8d8s6iaskmjeur931p3i3d','134.122.27.186',1739616852,_binary '__ci_last_regenerate|i:1739616852;'),('vta6vcd6ni66ei82egcfbu4jgamnc9ht','134.122.27.186',1740408848,_binary '__ci_last_regenerate|i:1740408848;'),('vtc8ho0lh2p83ipj0ea15u24tt1r2oou','134.122.27.186',1744606083,_binary '__ci_last_regenerate|i:1744606083;'),('vtcjon2j5vefn594to7fsf2d5k70jeqb','134.122.27.186',1742473814,_binary '__ci_last_regenerate|i:1742473814;'),('vte6ohpscm6vc6jfpe6nngjgguainsar','134.122.27.186',1742487191,_binary '__ci_last_regenerate|i:1742487191;'),('vtgj8lrpijn4kd3v5fseqr0b5hfb164d','134.122.27.186',1746532567,_binary '__ci_last_regenerate|i:1746532567;'),('vth0uo1vq9sc8ub1v25sf7kjqldu5275','134.122.27.186',1746782648,_binary '__ci_last_regenerate|i:1746782648;'),('vthncat8vbqsqq313l28459c37k1dj3t','134.122.27.186',1746558728,_binary '__ci_last_regenerate|i:1746558728;'),('vtiu7vhnbil1j4k53fpndi5sa47s8uj0','134.122.27.186',1742200752,_binary '__ci_last_regenerate|i:1742200752;'),('vtklg7nrtlqrbbpokpaq4dn127ive0a2','134.122.27.186',1742131693,_binary '__ci_last_regenerate|i:1742131693;'),('vtkpqr8l0ehtakht27s75917edsangdi','134.122.27.186',1745457187,_binary '__ci_last_regenerate|i:1745457187;'),('vtm6op7nmmljv15sbnpuj3ibb1c6v8aq','134.122.27.186',1744019770,_binary '__ci_last_regenerate|i:1744019770;'),('vtn711b5tefkub1vtc4jeoen0d7s2qsv','134.122.27.186',1741066268,_binary '__ci_last_regenerate|i:1741066268;'),('vtpnar97duf59keicmc14vqjvc8r9rlt','134.122.27.186',1745634309,_binary '__ci_last_regenerate|i:1745634309;'),('vtq7qv178gk4820hngmbke96okf8mi85','134.122.27.186',1739606524,_binary '__ci_last_regenerate|i:1739606524;'),('vtrffo9es5dt7ftf7drvtfkj753dudd6','134.122.27.186',1740559150,_binary '__ci_last_regenerate|i:1740559150;'),('vtrslecubdpbikq1t30l1vtat2n1fh15','134.122.27.186',1740846013,_binary '__ci_last_regenerate|i:1740846013;'),('vtrvnln0v3fcsdak1fs97dipc1bfvhgk','134.122.27.186',1742500938,_binary '__ci_last_regenerate|i:1742500938;'),('vts0gvhqe16tqpqsnfb6sgqu73s3jk13','134.122.27.186',1738374244,_binary '__ci_last_regenerate|i:1738374244;_prev_url|s:44:\"https://app.tagrit.com/sunbird/ps/cron/index\";'),('vtu2423lsj38m41715duekq8blc9fg19','134.122.27.186',1741462265,_binary '__ci_last_regenerate|i:1741462265;'),('vtun0fvjb88mcdlceosnodkq1f4equ32','134.122.27.186',1742923629,_binary '__ci_last_regenerate|i:1742923629;'),('vtv8eguqlo3i9t6ufbfock8aa7giu9rt','134.122.27.186',1742711468,_binary '__ci_last_regenerate|i:1742711468;'),('vu1v11146fbns62uc2pfu2pqt6bumg4n','134.122.27.186',1742188811,_binary '__ci_last_regenerate|i:1742188811;'),('vu3ejo6kc9a6p8nvaft8be852o37hqdu','134.122.27.186',1741454527,_binary '__ci_last_regenerate|i:1741454527;'),('vu403068dc7sbh1ij5n5557ljjonpgcp','134.122.27.186',1741378505,_binary '__ci_last_regenerate|i:1741378505;'),('vu54r14cpng0ok82d0333hv9fchv9kdl','134.122.27.186',1740952514,_binary '__ci_last_regenerate|i:1740952513;'),('vu6nr21n8d9j2a93ap6kjeuco73ti6su','134.122.27.186',1743250505,_binary '__ci_last_regenerate|i:1743250505;'),('vu73lcvl6m6tr5gbgpa48iefmu5efdla','134.122.27.186',1746116767,_binary '__ci_last_regenerate|i:1746116767;'),('vuaefluijcm4nou5ffhanegq2r2qgc4m','134.122.27.186',1745194988,_binary '__ci_last_regenerate|i:1745194988;'),('vuaqutncrj864a9frf7ivqteq03iq69v','134.122.27.186',1740086053,_binary '__ci_last_regenerate|i:1740086053;'),('vufia9m0l2qs3gpt4kkfr10kaqclbsfl','134.122.27.186',1746129426,_binary '__ci_last_regenerate|i:1746129426;'),('vuglhi03trqlhfpe62n30ibisubuum9q','134.122.27.186',1742886552,_binary '__ci_last_regenerate|i:1742886552;'),('vuhillt898m96crpvgtiut56qekkj1di','134.122.27.186',1740205208,_binary '__ci_last_regenerate|i:1740205208;'),('vui3ot5gqr2gedi5ef2he3hulheot877','134.122.27.186',1741975692,_binary '__ci_last_regenerate|i:1741975692;'),('vukjkit5rb18vndtjf888u3qlljqo28e','134.122.27.186',1746960789,_binary '__ci_last_regenerate|i:1746960789;'),('vum4gs86adr5ml4vvs0enk9pnlb68638','134.122.27.186',1741058468,_binary '__ci_last_regenerate|i:1741058468;'),('vum7j1fsdqartlgaoqn0b858hqtbc9gd','134.122.27.186',1746484084,_binary '__ci_last_regenerate|i:1746484084;'),('vunliqfvlugoninlnh5e1qm40f0e7kb8','134.122.27.186',1746893647,_binary '__ci_last_regenerate|i:1746893647;'),('vupfli47lajjqqh52dc6o8alnuk7ro82','134.122.27.186',1744364107,_binary '__ci_last_regenerate|i:1744364106;'),('vutgs8h6bd3b1nn0cuu1fd6n0p343tg7','134.122.27.186',1746715327,_binary '__ci_last_regenerate|i:1746715327;'),('vuusjlibmnk9jh461i73koggm0nb6oti','134.122.27.186',1739616491,_binary '__ci_last_regenerate|i:1739616491;'),('vuvq13rrmr2rdssv0oo0shlcj69ng0j6','134.122.27.186',1745770808,_binary '__ci_last_regenerate|i:1745770808;'),('vv0j1vtukjt4ucgusu6nen4m8sqi0nh2','134.122.27.186',1745012167,_binary '__ci_last_regenerate|i:1745012167;'),('vv0lh92sarh8qdqdkumto9j74vn0oi0h','134.122.27.186',1743441849,_binary '__ci_last_regenerate|i:1743441849;'),('vv156fvk5pobpuj959us1ape7ve6r36t','134.122.27.186',1739827390,_binary '__ci_last_regenerate|i:1739827390;'),('vv16cbntv62sslot349duv37vc0kgsol','134.122.27.186',1742311278,_binary '__ci_last_regenerate|i:1742311278;'),('vv4pbrbemk7l8l5ai09oq4mbl84oeh73','134.122.27.186',1745384785,_binary '__ci_last_regenerate|i:1745384785;'),('vv75go2a94cm24jk3lk248blurhg5qqt','134.122.27.186',1745766608,_binary '__ci_last_regenerate|i:1745766608;'),('vv8ci83p7nnjpdra3q77jpoiv6ml56t9','134.122.27.186',1746570248,_binary '__ci_last_regenerate|i:1746570248;'),('vv8k1cu6scjjqilrfjo28e9t5sqegrt7','134.122.27.186',1745743090,_binary '__ci_last_regenerate|i:1745743090;'),('vv8mfm4btsrf09npn3r0qcuijshdot8r','134.122.27.186',1739908710,_binary '__ci_last_regenerate|i:1739908710;'),('vvad7djmg91drfaj6bk05ta5m6b01bel','134.122.27.186',1742661014,_binary '__ci_last_regenerate|i:1742661014;'),('vvbpvaavfhg4fimf3i1rurvmcalcknre','134.122.27.186',1743870371,_binary '__ci_last_regenerate|i:1743870371;'),('vvcm0etecl0nsoe5s1i7uermtipl9r96','134.122.27.186',1739831709,_binary '__ci_last_regenerate|i:1739831709;'),('vvdjb7m19ghiegonhikpuiasbsia8fpp','134.122.27.186',1744345208,_binary '__ci_last_regenerate|i:1744345208;'),('vve0rvormmn7h8fkd93fshenrngoal05','134.122.27.186',1744607524,_binary '__ci_last_regenerate|i:1744607524;'),('vvem7k2r0r8h5gcs8fpgv77mkqb79s62','134.122.27.186',1742318773,_binary '__ci_last_regenerate|i:1742318773;'),('vvf9ggt2pkijkpnvm1jmfkuv65k6tbug','134.122.27.186',1741233184,_binary '__ci_last_regenerate|i:1741233184;'),('vvfv61g28714g4bjaf9or32akjd1rbs9','134.122.27.186',1743797111,_binary '__ci_last_regenerate|i:1743797111;'),('vvhjfdm2tgfv98ru129fpe21i0dvafkf','134.122.27.186',1739381831,_binary '__ci_last_regenerate|i:1739381831;'),('vvhpe2b090imsmitk10gtvnuoqn29b49','134.122.27.186',1743523150,_binary '__ci_last_regenerate|i:1743523150;'),('vvld9r2lphj3k6j3tsae5vidhibvun4q','134.122.27.186',1743838088,_binary '__ci_last_regenerate|i:1743838088;'),('vvn6gd24antj51t8g2ri1i5icjlla35q','134.122.27.186',1747092008,_binary '__ci_last_regenerate|i:1747092008;'),('vvtbdv58gdag6p7k0jp0it7l84f96llh','134.122.27.186',1744361226,_binary '__ci_last_regenerate|i:1744361226;'),('vvv65vld4gi3ab8g23cl3ihm8317mh8b','134.122.27.186',1739558052,_binary '__ci_last_regenerate|i:1739558052;');

--
-- Table structure for table `sunbird_tblsetting_asset_allocation`
--

CREATE TABLE `sunbird_tblsetting_asset_allocation` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(150) DEFAULT NULL,
  `meta` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblsetting_asset_allocation`
--


--
-- Table structure for table `sunbird_tblsetting_training`
--

CREATE TABLE `sunbird_tblsetting_training` (
  `id` int NOT NULL AUTO_INCREMENT,
  `training_type` int NOT NULL,
  `position_training` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblsetting_training`
--


--
-- Table structure for table `sunbird_tblsetting_transfer_records`
--

CREATE TABLE `sunbird_tblsetting_transfer_records` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(150) DEFAULT NULL,
  `meta` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblsetting_transfer_records`
--


--
-- Table structure for table `sunbird_tblshared_customer_files`
--

CREATE TABLE `sunbird_tblshared_customer_files` (
  `file_id` int NOT NULL,
  `contact_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblshared_customer_files`
--


--
-- Table structure for table `sunbird_tblspam_filters`
--

CREATE TABLE `sunbird_tblspam_filters` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `rel_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblspam_filters`
--


--
-- Table structure for table `sunbird_tblstaff`
--

CREATE TABLE `sunbird_tblstaff` (
  `staffid` int NOT NULL AUTO_INCREMENT,
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `firstname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `lastname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `facebook` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `linkedin` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `phonenumber` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `skype` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `datecreated` datetime NOT NULL,
  `profile_image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_ip` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `last_activity` datetime DEFAULT NULL,
  `last_password_change` datetime DEFAULT NULL,
  `new_pass_key` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `new_pass_key_requested` datetime DEFAULT NULL,
  `admin` int NOT NULL DEFAULT '0',
  `role` int DEFAULT NULL,
  `active` int NOT NULL DEFAULT '1',
  `default_language` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `direction` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `media_path_slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_not_staff` int NOT NULL DEFAULT '0',
  `hourly_rate` decimal(15,2) NOT NULL DEFAULT '0.00',
  `two_factor_auth_enabled` tinyint(1) DEFAULT '0',
  `two_factor_auth_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `two_factor_auth_code_requested` datetime DEFAULT NULL,
  `email_signature` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `birthday` date DEFAULT NULL,
  `birthplace` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sex` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `marital_status` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nation` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `religion` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `identification` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `days_for_identity` date DEFAULT NULL,
  `home_town` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `resident` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `current_address` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `literacy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `orther_infor` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `job_position` int DEFAULT NULL,
  `workplace` int DEFAULT NULL,
  `place_of_issue` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_account` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `issue_bank` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `records_received` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `Personal_tax_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `google_auth_secret` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `team_manage` int DEFAULT '0',
  `staff_identifi` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_work` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_update` date DEFAULT NULL,
  `fleet_is_driver` int DEFAULT '0',
  `mail_password` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mail_signature` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_email_check` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`staffid`),
  KEY `firstname` (`firstname`),
  KEY `lastname` (`lastname`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblstaff`
--

INSERT INTO `sunbird_tblstaff` VALUES (1,'mlayfred@gmail.com','FREDRICK','MLAY',NULL,NULL,'+255 752515715',NULL,'$2a$08$5Q8DdHCB2pSGZkDLg//SaOdqom7N9dnccf.tj0C0E1ae3gmE/0nOG','2025-01-31 07:38:48',NULL,'102.219.210.222','2025-01-31 17:41:57','2025-01-31 17:42:04',NULL,NULL,NULL,1,NULL,1,NULL,NULL,NULL,0,0.00,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,0,NULL,NULL,NULL);

--
-- Table structure for table `sunbird_tblstaff_departments`
--

CREATE TABLE `sunbird_tblstaff_departments` (
  `staffdepartmentid` int NOT NULL AUTO_INCREMENT,
  `staffid` int NOT NULL,
  `departmentid` int NOT NULL,
  PRIMARY KEY (`staffdepartmentid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblstaff_departments`
--


--
-- Table structure for table `sunbird_tblstaff_permissions`
--

CREATE TABLE `sunbird_tblstaff_permissions` (
  `staff_id` int NOT NULL,
  `feature` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `capability` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblstaff_permissions`
--


--
-- Table structure for table `sunbird_tblstock_take`
--

CREATE TABLE `sunbird_tblstock_take` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `description` text COMMENT 'the reason stock take',
  `warehouse_id` int DEFAULT NULL,
  `date_stock_take` date DEFAULT NULL,
  `stock_take_code` varchar(100) DEFAULT NULL COMMENT 'số kiểm kê kho',
  `date_add` date DEFAULT NULL,
  `hour_add` date DEFAULT NULL,
  `staff_id` varchar(100) DEFAULT NULL,
  `approval` int DEFAULT '0' COMMENT 'status approval ',
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblstock_take`
--


--
-- Table structure for table `sunbird_tblstock_take_detail`
--

CREATE TABLE `sunbird_tblstock_take_detail` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `stock_take_id` int NOT NULL,
  `commodity_code` varchar(100) DEFAULT NULL,
  `commodity_name` text,
  `unit_id` text,
  `unit_price` varchar(100) DEFAULT NULL,
  `quantity_stock_take` varchar(100) DEFAULT NULL,
  `quantity_accounting_book` varchar(100) DEFAULT NULL,
  `quantity_change` varchar(100) DEFAULT NULL,
  `handling` text,
  `reason` text,
  `approval` int DEFAULT '0' COMMENT 'status approval ',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblstock_take_detail`
--


--
-- Table structure for table `sunbird_tblsubscriptions`
--

CREATE TABLE `sunbird_tblsubscriptions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `description_in_item` tinyint(1) NOT NULL DEFAULT '0',
  `clientid` int NOT NULL,
  `date` date DEFAULT NULL,
  `terms` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `currency` int NOT NULL,
  `tax_id` int NOT NULL DEFAULT '0',
  `stripe_tax_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tax_id_2` int NOT NULL DEFAULT '0',
  `stripe_tax_id_2` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stripe_plan_id` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `stripe_subscription_id` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `next_billing_cycle` bigint DEFAULT NULL,
  `ends_at` bigint DEFAULT NULL,
  `status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` int NOT NULL DEFAULT '1',
  `project_id` int NOT NULL DEFAULT '0',
  `hash` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created` datetime NOT NULL,
  `created_from` int NOT NULL,
  `date_subscribed` datetime DEFAULT NULL,
  `in_test_environment` int DEFAULT NULL,
  `last_sent_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `clientid` (`clientid`),
  KEY `currency` (`currency`),
  KEY `tax_id` (`tax_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblsubscriptions`
--


--
-- Table structure for table `sunbird_tblsurveyresultsets`
--

CREATE TABLE `sunbird_tblsurveyresultsets` (
  `resultsetid` int NOT NULL AUTO_INCREMENT,
  `surveyid` int NOT NULL,
  `ip` varchar(40) NOT NULL,
  `useragent` varchar(150) NOT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY (`resultsetid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblsurveyresultsets`
--


--
-- Table structure for table `sunbird_tblsurveys`
--

CREATE TABLE `sunbird_tblsurveys` (
  `surveyid` int NOT NULL AUTO_INCREMENT,
  `subject` mediumtext NOT NULL,
  `slug` mediumtext NOT NULL,
  `description` text NOT NULL,
  `viewdescription` text,
  `datecreated` datetime NOT NULL,
  `redirect_url` varchar(100) DEFAULT NULL,
  `send` tinyint(1) NOT NULL DEFAULT '0',
  `onlyforloggedin` int DEFAULT '0',
  `fromname` varchar(100) DEFAULT NULL,
  `iprestrict` tinyint(1) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `hash` varchar(32) NOT NULL,
  PRIMARY KEY (`surveyid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblsurveys`
--


--
-- Table structure for table `sunbird_tblsurveysemailsendcron`
--

CREATE TABLE `sunbird_tblsurveysemailsendcron` (
  `id` int NOT NULL AUTO_INCREMENT,
  `surveyid` int NOT NULL,
  `email` varchar(100) NOT NULL,
  `emailid` int DEFAULT NULL,
  `listid` varchar(11) DEFAULT NULL,
  `log_id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblsurveysemailsendcron`
--


--
-- Table structure for table `sunbird_tblsurveysendlog`
--

CREATE TABLE `sunbird_tblsurveysendlog` (
  `id` int NOT NULL AUTO_INCREMENT,
  `surveyid` int NOT NULL,
  `total` int NOT NULL,
  `date` datetime NOT NULL,
  `iscronfinished` int NOT NULL DEFAULT '0',
  `send_to_mail_lists` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblsurveysendlog`
--


--
-- Table structure for table `sunbird_tbltaggables`
--

CREATE TABLE `sunbird_tbltaggables` (
  `rel_id` int NOT NULL,
  `rel_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tag_id` int NOT NULL,
  `tag_order` int NOT NULL DEFAULT '0',
  KEY `rel_id` (`rel_id`),
  KEY `rel_type` (`rel_type`),
  KEY `tag_id` (`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tbltaggables`
--


--
-- Table structure for table `sunbird_tbltags`
--

CREATE TABLE `sunbird_tbltags` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tbltags`
--


--
-- Table structure for table `sunbird_tbltask_assigned`
--

CREATE TABLE `sunbird_tbltask_assigned` (
  `id` int NOT NULL AUTO_INCREMENT,
  `staffid` int NOT NULL,
  `taskid` int NOT NULL,
  `assigned_from` int NOT NULL DEFAULT '0',
  `is_assigned_from_contact` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `taskid` (`taskid`),
  KEY `sunbird_staffid` (`staffid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tbltask_assigned`
--


--
-- Table structure for table `sunbird_tbltask_checklist_items`
--

CREATE TABLE `sunbird_tbltask_checklist_items` (
  `id` int NOT NULL AUTO_INCREMENT,
  `taskid` int NOT NULL,
  `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `finished` int NOT NULL DEFAULT '0',
  `dateadded` datetime NOT NULL,
  `addedfrom` int NOT NULL,
  `finished_from` int DEFAULT '0',
  `list_order` int NOT NULL DEFAULT '0',
  `assigned` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `taskid` (`taskid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tbltask_checklist_items`
--


--
-- Table structure for table `sunbird_tbltask_comments`
--

CREATE TABLE `sunbird_tbltask_comments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `content` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `taskid` int NOT NULL,
  `staffid` int NOT NULL,
  `contact_id` int NOT NULL DEFAULT '0',
  `file_id` int NOT NULL DEFAULT '0',
  `dateadded` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `file_id` (`file_id`),
  KEY `taskid` (`taskid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tbltask_comments`
--


--
-- Table structure for table `sunbird_tbltask_followers`
--

CREATE TABLE `sunbird_tbltask_followers` (
  `id` int NOT NULL AUTO_INCREMENT,
  `staffid` int NOT NULL,
  `taskid` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tbltask_followers`
--


--
-- Table structure for table `sunbird_tbltasks`
--

CREATE TABLE `sunbird_tbltasks` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `priority` int DEFAULT NULL,
  `dateadded` datetime NOT NULL,
  `startdate` date NOT NULL,
  `duedate` date DEFAULT NULL,
  `datefinished` datetime DEFAULT NULL,
  `addedfrom` int NOT NULL,
  `is_added_from_contact` tinyint(1) NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '0',
  `recurring_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `repeat_every` int DEFAULT NULL,
  `recurring` int NOT NULL DEFAULT '0',
  `is_recurring_from` int DEFAULT NULL,
  `cycles` int NOT NULL DEFAULT '0',
  `total_cycles` int NOT NULL DEFAULT '0',
  `custom_recurring` tinyint(1) NOT NULL DEFAULT '0',
  `last_recurring_date` date DEFAULT NULL,
  `rel_id` int DEFAULT NULL,
  `rel_type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_public` tinyint(1) NOT NULL DEFAULT '0',
  `billable` tinyint(1) NOT NULL DEFAULT '0',
  `billed` tinyint(1) NOT NULL DEFAULT '0',
  `invoice_id` int NOT NULL DEFAULT '0',
  `hourly_rate` decimal(15,2) NOT NULL DEFAULT '0.00',
  `milestone` int DEFAULT '0',
  `kanban_order` int DEFAULT '1',
  `milestone_order` int NOT NULL DEFAULT '0',
  `visible_to_client` tinyint(1) NOT NULL DEFAULT '0',
  `deadline_notified` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `rel_id` (`rel_id`),
  KEY `rel_type` (`rel_type`),
  KEY `milestone` (`milestone`),
  KEY `kanban_order` (`kanban_order`),
  KEY `status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tbltasks`
--


--
-- Table structure for table `sunbird_tbltasks_checklist_templates`
--

CREATE TABLE `sunbird_tbltasks_checklist_templates` (
  `id` int NOT NULL AUTO_INCREMENT,
  `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tbltasks_checklist_templates`
--


--
-- Table structure for table `sunbird_tbltaskstimers`
--

CREATE TABLE `sunbird_tbltaskstimers` (
  `id` int NOT NULL AUTO_INCREMENT,
  `task_id` int NOT NULL,
  `start_time` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `end_time` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `staff_id` int NOT NULL,
  `hourly_rate` decimal(15,2) NOT NULL DEFAULT '0.00',
  `note` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `task_id` (`task_id`),
  KEY `sunbird_staff_id` (`staff_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tbltaskstimers`
--


--
-- Table structure for table `sunbird_tbltaxes`
--

CREATE TABLE `sunbird_tbltaxes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `taxrate` decimal(15,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tbltaxes`
--

INSERT INTO `sunbird_tbltaxes` VALUES (1,'Sales VAT',18.00),(2,'Purchase VAT',18.00);

--
-- Table structure for table `sunbird_tbltemplates`
--

CREATE TABLE `sunbird_tbltemplates` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `addedfrom` int NOT NULL,
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tbltemplates`
--


--
-- Table structure for table `sunbird_tblticket_attachments`
--

CREATE TABLE `sunbird_tblticket_attachments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ticketid` int NOT NULL,
  `replyid` int DEFAULT NULL,
  `file_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `filetype` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dateadded` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblticket_attachments`
--


--
-- Table structure for table `sunbird_tblticket_replies`
--

CREATE TABLE `sunbird_tblticket_replies` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ticketid` int NOT NULL,
  `userid` int DEFAULT NULL,
  `contactid` int NOT NULL DEFAULT '0',
  `name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `email` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `date` datetime NOT NULL,
  `message` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `attachment` int DEFAULT NULL,
  `admin` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblticket_replies`
--


--
-- Table structure for table `sunbird_tbltickets`
--

CREATE TABLE `sunbird_tbltickets` (
  `ticketid` int NOT NULL AUTO_INCREMENT,
  `adminreplying` int NOT NULL DEFAULT '0',
  `userid` int NOT NULL,
  `contactid` int NOT NULL DEFAULT '0',
  `merged_ticket_id` int DEFAULT NULL,
  `email` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `department` int NOT NULL,
  `priority` int NOT NULL,
  `status` int NOT NULL,
  `service` int DEFAULT NULL,
  `ticketkey` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `admin` int DEFAULT NULL,
  `date` datetime NOT NULL,
  `project_id` int NOT NULL DEFAULT '0',
  `lastreply` datetime DEFAULT NULL,
  `clientread` int NOT NULL DEFAULT '0',
  `adminread` int NOT NULL DEFAULT '0',
  `assigned` int NOT NULL DEFAULT '0',
  `staff_id_replying` int DEFAULT NULL,
  `cc` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`ticketid`),
  KEY `service` (`service`),
  KEY `department` (`department`),
  KEY `status` (`status`),
  KEY `userid` (`userid`),
  KEY `priority` (`priority`),
  KEY `project_id` (`project_id`),
  KEY `contactid` (`contactid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tbltickets`
--


--
-- Table structure for table `sunbird_tbltickets_pipe_log`
--

CREATE TABLE `sunbird_tbltickets_pipe_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL,
  `email_to` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tbltickets_pipe_log`
--


--
-- Table structure for table `sunbird_tbltickets_predefined_replies`
--

CREATE TABLE `sunbird_tbltickets_predefined_replies` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tbltickets_predefined_replies`
--


--
-- Table structure for table `sunbird_tbltickets_priorities`
--

CREATE TABLE `sunbird_tbltickets_priorities` (
  `priorityid` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`priorityid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tbltickets_priorities`
--

INSERT INTO `sunbird_tbltickets_priorities` VALUES (1,'Low'),(2,'Medium'),(3,'High');

--
-- Table structure for table `sunbird_tbltickets_status`
--

CREATE TABLE `sunbird_tbltickets_status` (
  `ticketstatusid` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `isdefault` int NOT NULL DEFAULT '0',
  `statuscolor` varchar(7) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `statusorder` int DEFAULT NULL,
  PRIMARY KEY (`ticketstatusid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tbltickets_status`
--

INSERT INTO `sunbird_tbltickets_status` VALUES (1,'Open',1,'#ff2d42',1),(2,'In progress',1,'#22c55e',2),(3,'Answered',1,'#2563eb',3),(4,'On Hold',1,'#64748b',4),(5,'Closed',1,'#03a9f4',5);

--
-- Table structure for table `sunbird_tbltodos`
--

CREATE TABLE `sunbird_tbltodos` (
  `todoid` int NOT NULL AUTO_INCREMENT,
  `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `staffid` int NOT NULL,
  `dateadded` datetime NOT NULL,
  `finished` tinyint(1) NOT NULL,
  `datefinished` datetime DEFAULT NULL,
  `item_order` int DEFAULT NULL,
  PRIMARY KEY (`todoid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tbltodos`
--


--
-- Table structure for table `sunbird_tbltracked_mails`
--

CREATE TABLE `sunbird_tbltracked_mails` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `rel_id` int NOT NULL,
  `rel_type` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` datetime NOT NULL,
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `opened` tinyint(1) NOT NULL DEFAULT '0',
  `date_opened` datetime DEFAULT NULL,
  `subject` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tbltracked_mails`
--


--
-- Table structure for table `sunbird_tbltraining_allocation`
--

CREATE TABLE `sunbird_tbltraining_allocation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `training_process_id` varchar(100) NOT NULL,
  `staffid` int DEFAULT NULL,
  `training_type` int DEFAULT NULL,
  `date_add` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `training_name` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tbltraining_allocation`
--


--
-- Table structure for table `sunbird_tbltransfer_records_reception`
--

CREATE TABLE `sunbird_tbltransfer_records_reception` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(150) DEFAULT NULL,
  `meta` varchar(50) DEFAULT NULL,
  `staffid` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tbltransfer_records_reception`
--


--
-- Table structure for table `sunbird_tbltwocheckout_log`
--

CREATE TABLE `sunbird_tbltwocheckout_log` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `reference` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `invoice_id` int NOT NULL,
  `amount` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `attempt_reference` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `invoice_id` (`invoice_id`),
  CONSTRAINT `sunbird_tbltwocheckout_log_ibfk_1` FOREIGN KEY (`invoice_id`) REFERENCES `sunbird_tblinvoices` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tbltwocheckout_log`
--


--
-- Table structure for table `sunbird_tbluser_auto_login`
--

CREATE TABLE `sunbird_tbluser_auto_login` (
  `key_id` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int NOT NULL,
  `user_agent` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_ip` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_login` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `staff` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tbluser_auto_login`
--

INSERT INTO `sunbird_tbluser_auto_login` VALUES ('ac86813432d61185196ee668687be318',1,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36','102.219.210.222','2025-01-31 05:04:13',1),('010cb9aa577108f268edb7211189fc9d',1,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36','102.219.210.222','2025-01-31 16:41:56',1);

--
-- Table structure for table `sunbird_tbluser_meta`
--

CREATE TABLE `sunbird_tbluser_meta` (
  `umeta_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `staff_id` bigint unsigned NOT NULL DEFAULT '0',
  `client_id` bigint unsigned NOT NULL DEFAULT '0',
  `contact_id` bigint unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`umeta_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tbluser_meta`
--


--
-- Table structure for table `sunbird_tblvault`
--

CREATE TABLE `sunbird_tblvault` (
  `id` int NOT NULL AUTO_INCREMENT,
  `customer_id` int NOT NULL,
  `server_address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `port` int DEFAULT NULL,
  `username` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `creator` int NOT NULL,
  `creator_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `visibility` tinyint(1) NOT NULL DEFAULT '1',
  `share_in_projects` tinyint(1) NOT NULL DEFAULT '0',
  `last_updated` datetime DEFAULT NULL,
  `last_updated_from` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_created` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblvault`
--


--
-- Table structure for table `sunbird_tblviews_tracking`
--

CREATE TABLE `sunbird_tblviews_tracking` (
  `id` int NOT NULL AUTO_INCREMENT,
  `rel_id` int NOT NULL,
  `rel_type` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` datetime NOT NULL,
  `view_ip` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblviews_tracking`
--


--
-- Table structure for table `sunbird_tblware_body_type`
--

CREATE TABLE `sunbird_tblware_body_type` (
  `body_type_id` int unsigned NOT NULL AUTO_INCREMENT,
  `body_code` varchar(100) DEFAULT NULL,
  `body_name` text,
  `order` int DEFAULT NULL,
  `display` int DEFAULT NULL COMMENT 'display 1: display (yes)  0: not displayed (no)',
  `note` text,
  PRIMARY KEY (`body_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblware_body_type`
--


--
-- Table structure for table `sunbird_tblware_color`
--

CREATE TABLE `sunbird_tblware_color` (
  `color_id` int unsigned NOT NULL AUTO_INCREMENT,
  `color_code` varchar(100) DEFAULT NULL,
  `color_name` varchar(100) DEFAULT NULL,
  `color_hex` text,
  `order` int DEFAULT NULL,
  `display` int DEFAULT NULL COMMENT 'display 1: display (yes)  0: not displayed (no)',
  `note` text,
  PRIMARY KEY (`color_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblware_color`
--


--
-- Table structure for table `sunbird_tblware_commodity_type`
--

CREATE TABLE `sunbird_tblware_commodity_type` (
  `commodity_type_id` int unsigned NOT NULL AUTO_INCREMENT,
  `commondity_code` varchar(100) DEFAULT NULL,
  `commondity_name` text,
  `order` int DEFAULT NULL,
  `display` int DEFAULT NULL COMMENT 'display 1: display (yes)  0: not displayed (no)',
  `note` text,
  PRIMARY KEY (`commodity_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblware_commodity_type`
--


--
-- Table structure for table `sunbird_tblware_size_type`
--

CREATE TABLE `sunbird_tblware_size_type` (
  `size_type_id` int unsigned NOT NULL AUTO_INCREMENT,
  `size_code` varchar(100) DEFAULT NULL,
  `size_name` text,
  `size_symbol` text,
  `order` int DEFAULT NULL,
  `display` int DEFAULT NULL COMMENT 'display 1: display (yes)  0: not displayed (no)',
  `note` text,
  PRIMARY KEY (`size_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblware_size_type`
--


--
-- Table structure for table `sunbird_tblware_style_type`
--

CREATE TABLE `sunbird_tblware_style_type` (
  `style_type_id` int unsigned NOT NULL AUTO_INCREMENT,
  `style_code` varchar(100) DEFAULT NULL,
  `style_barcode` text,
  `style_name` text,
  `order` int DEFAULT NULL,
  `display` int DEFAULT NULL COMMENT 'display 1: display (yes)  0: not displayed (no)',
  `note` text,
  PRIMARY KEY (`style_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblware_style_type`
--


--
-- Table structure for table `sunbird_tblware_unit_type`
--

CREATE TABLE `sunbird_tblware_unit_type` (
  `unit_type_id` int unsigned NOT NULL AUTO_INCREMENT,
  `unit_code` varchar(100) DEFAULT NULL,
  `unit_name` text,
  `unit_symbol` text,
  `order` int DEFAULT NULL,
  `display` int DEFAULT NULL COMMENT 'display 1: display (yes)  0: not displayed (no)',
  `note` text,
  PRIMARY KEY (`unit_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblware_unit_type`
--


--
-- Table structure for table `sunbird_tblwarehouse`
--

CREATE TABLE `sunbird_tblwarehouse` (
  `warehouse_id` int unsigned NOT NULL AUTO_INCREMENT,
  `warehouse_code` varchar(100) DEFAULT NULL,
  `warehouse_name` text,
  `warehouse_address` text,
  `order` int DEFAULT NULL,
  `display` int DEFAULT NULL COMMENT 'display 1: display (yes)  0: not displayed (no)',
  `note` text,
  `city` text,
  `state` text,
  `zip_code` text,
  `country` text,
  `hide_warehouse_when_out_of_stock` int DEFAULT '0' COMMENT ' 1: yes  0: no',
  PRIMARY KEY (`warehouse_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblwarehouse`
--


--
-- Table structure for table `sunbird_tblweb_to_lead`
--

CREATE TABLE `sunbird_tblweb_to_lead` (
  `id` int NOT NULL AUTO_INCREMENT,
  `form_key` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `lead_source` int NOT NULL,
  `lead_status` int NOT NULL,
  `notify_lead_imported` int NOT NULL DEFAULT '1',
  `notify_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notify_ids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `responsible` int NOT NULL DEFAULT '0',
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `form_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `recaptcha` int NOT NULL DEFAULT '0',
  `submit_btn_name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `submit_btn_text_color` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '#ffffff',
  `submit_btn_bg_color` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '#84c529',
  `success_submit_msg` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `submit_action` int DEFAULT '0',
  `lead_name_prefix` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `submit_redirect_url` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `language` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `allow_duplicate` int NOT NULL DEFAULT '1',
  `mark_public` int NOT NULL DEFAULT '0',
  `track_duplicate_field` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `track_duplicate_field_and` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `create_task_on_duplicate` int NOT NULL DEFAULT '0',
  `dateadded` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sunbird_tblweb_to_lead`
--


--
-- Table structure for table `sunbird_tblwh_activity_log`
--

CREATE TABLE `sunbird_tblwh_activity_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `rel_id` int NOT NULL,
  `rel_type` varchar(45) NOT NULL,
  `staffid` int DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `note` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblwh_activity_log`
--


--
-- Table structure for table `sunbird_tblwh_approval_details`
--

CREATE TABLE `sunbird_tblwh_approval_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `rel_id` int NOT NULL,
  `rel_type` varchar(45) NOT NULL,
  `staffid` varchar(45) DEFAULT NULL,
  `approve` varchar(45) DEFAULT NULL,
  `note` text,
  `date` datetime DEFAULT NULL,
  `approve_action` varchar(255) DEFAULT NULL,
  `reject_action` varchar(255) DEFAULT NULL,
  `approve_value` varchar(255) DEFAULT NULL,
  `reject_value` varchar(255) DEFAULT NULL,
  `staff_approve` int DEFAULT NULL,
  `action` varchar(45) DEFAULT NULL,
  `sender` int DEFAULT NULL,
  `date_send` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblwh_approval_details`
--


--
-- Table structure for table `sunbird_tblwh_approval_setting`
--

CREATE TABLE `sunbird_tblwh_approval_setting` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `related` varchar(255) NOT NULL,
  `setting` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblwh_approval_setting`
--


--
-- Table structure for table `sunbird_tblwh_brand`
--

CREATE TABLE `sunbird_tblwh_brand` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblwh_brand`
--


--
-- Table structure for table `sunbird_tblwh_custom_fields`
--

CREATE TABLE `sunbird_tblwh_custom_fields` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `custom_fields_id` int DEFAULT NULL,
  `warehouse_id` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblwh_custom_fields`
--


--
-- Table structure for table `sunbird_tblwh_goods_delivery_activity_log`
--

CREATE TABLE `sunbird_tblwh_goods_delivery_activity_log` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `rel_id` int DEFAULT NULL,
  `rel_type` varchar(100) DEFAULT NULL,
  `description` mediumtext,
  `additional_data` text,
  `date` datetime DEFAULT NULL,
  `staffid` int DEFAULT NULL,
  `full_name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblwh_goods_delivery_activity_log`
--


--
-- Table structure for table `sunbird_tblwh_inventory_serial_numbers`
--

CREATE TABLE `sunbird_tblwh_inventory_serial_numbers` (
  `id` int NOT NULL AUTO_INCREMENT,
  `commodity_id` int NOT NULL,
  `warehouse_id` int DEFAULT NULL,
  `inventory_manage_id` int DEFAULT NULL,
  `serial_number` varchar(255) DEFAULT NULL,
  `is_used` varchar(20) DEFAULT 'no',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblwh_inventory_serial_numbers`
--


--
-- Table structure for table `sunbird_tblwh_loss_adjustment`
--

CREATE TABLE `sunbird_tblwh_loss_adjustment` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(15) DEFAULT NULL,
  `addfrom` int DEFAULT NULL,
  `reason` longtext,
  `time` datetime DEFAULT NULL,
  `date_create` date NOT NULL,
  `status` int NOT NULL,
  `warehouses` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblwh_loss_adjustment`
--


--
-- Table structure for table `sunbird_tblwh_loss_adjustment_detail`
--

CREATE TABLE `sunbird_tblwh_loss_adjustment_detail` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `items` int DEFAULT NULL,
  `unit` int DEFAULT NULL,
  `current_number` int DEFAULT NULL,
  `updates_number` int DEFAULT NULL,
  `loss_adjustment` int DEFAULT NULL,
  `expiry_date` text,
  `lot_number` text,
  `commodity_name` text,
  `serial_number` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblwh_loss_adjustment_detail`
--


--
-- Table structure for table `sunbird_tblwh_model`
--

CREATE TABLE `sunbird_tblwh_model` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` text,
  `brand_id` int NOT NULL,
  PRIMARY KEY (`id`,`brand_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblwh_model`
--


--
-- Table structure for table `sunbird_tblwh_omni_shipments`
--

CREATE TABLE `sunbird_tblwh_omni_shipments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `cart_id` int DEFAULT NULL,
  `shipment_number` varchar(100) DEFAULT NULL,
  `planned_shipping_date` datetime DEFAULT NULL,
  `shipment_status` varchar(50) DEFAULT NULL,
  `datecreated` datetime DEFAULT NULL,
  `goods_delivery_id` int DEFAULT NULL,
  `shipment_hash` varchar(32) DEFAULT NULL,
  `order_id` int DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblwh_omni_shipments`
--


--
-- Table structure for table `sunbird_tblwh_order_return_details`
--

CREATE TABLE `sunbird_tblwh_order_return_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `order_return_id` int NOT NULL,
  `rel_type_detail_id` int DEFAULT NULL,
  `commodity_code` int DEFAULT NULL,
  `commodity_name` text,
  `quantity` decimal(15,2) DEFAULT '0.00',
  `unit_id` int DEFAULT NULL,
  `unit_price` decimal(15,2) DEFAULT '0.00',
  `sub_total` decimal(15,2) DEFAULT '0.00',
  `tax_id` text,
  `tax_rate` text,
  `tax_name` text,
  `total_amount` decimal(15,2) DEFAULT '0.00',
  `discount` decimal(15,2) DEFAULT '0.00',
  `discount_total` decimal(15,2) DEFAULT '0.00',
  `total_after_discount` decimal(15,2) DEFAULT '0.00',
  `reason_return` varchar(200) DEFAULT NULL,
  `purchase_price` decimal(15,2) DEFAULT '0.00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblwh_order_return_details`
--


--
-- Table structure for table `sunbird_tblwh_order_returns`
--

CREATE TABLE `sunbird_tblwh_order_returns` (
  `id` int NOT NULL AUTO_INCREMENT,
  `rel_id` int DEFAULT NULL,
  `rel_type` varchar(50) NOT NULL COMMENT 'manual, sales_return_order, purchasing_return_order',
  `return_type` varchar(50) DEFAULT NULL COMMENT 'manual, partially, fully',
  `company_id` int DEFAULT NULL,
  `company_name` varchar(500) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phonenumber` varchar(20) DEFAULT NULL,
  `order_number` varchar(500) DEFAULT NULL,
  `order_date` datetime DEFAULT NULL,
  `number_of_item` decimal(15,2) DEFAULT '0.00',
  `order_total` decimal(15,2) DEFAULT '0.00',
  `order_return_number` varchar(200) DEFAULT NULL,
  `order_return_name` varchar(500) DEFAULT NULL,
  `fee_return_order` decimal(15,2) DEFAULT '0.00',
  `refund_loyaty_point` int DEFAULT '0',
  `subtotal` decimal(15,2) DEFAULT '0.00',
  `total_amount` decimal(15,2) DEFAULT '0.00',
  `discount_total` decimal(15,2) DEFAULT '0.00',
  `additional_discount` decimal(15,2) DEFAULT '0.00',
  `adjustment_amount` decimal(15,2) DEFAULT '0.00',
  `total_after_discount` decimal(15,2) DEFAULT '0.00',
  `return_policies_information` text,
  `admin_note` text,
  `approval` int DEFAULT '0',
  `datecreated` datetime DEFAULT NULL,
  `staff_id` int DEFAULT NULL,
  `receipt_delivery_id` int DEFAULT '0',
  `currency` int DEFAULT NULL,
  `return_reason` longtext,
  `receipt_delivery_type` varchar(100) DEFAULT NULL,
  `status` varchar(30) DEFAULT 'draft',
  `discount_type` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblwh_order_returns`
--


--
-- Table structure for table `sunbird_tblwh_order_returns_refunds`
--

CREATE TABLE `sunbird_tblwh_order_returns_refunds` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `order_return_id` int DEFAULT NULL,
  `staff_id` int DEFAULT NULL,
  `refunded_on` date DEFAULT NULL,
  `payment_mode` varchar(40) DEFAULT NULL,
  `note` text,
  `amount` decimal(15,2) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblwh_order_returns_refunds`
--


--
-- Table structure for table `sunbird_tblwh_packing_list_details`
--

CREATE TABLE `sunbird_tblwh_packing_list_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `packing_list_id` int NOT NULL,
  `delivery_detail_id` int DEFAULT NULL,
  `commodity_code` int DEFAULT NULL,
  `commodity_name` text,
  `quantity` decimal(15,2) DEFAULT '0.00',
  `unit_id` int DEFAULT NULL,
  `unit_price` decimal(15,2) DEFAULT '0.00',
  `sub_total` decimal(15,2) DEFAULT '0.00',
  `tax_id` text,
  `tax_rate` text,
  `tax_name` text,
  `total_amount` decimal(15,2) DEFAULT '0.00',
  `discount` decimal(15,2) DEFAULT '0.00',
  `discount_total` decimal(15,2) DEFAULT '0.00',
  `total_after_discount` decimal(15,2) DEFAULT '0.00',
  `serial_number` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblwh_packing_list_details`
--


--
-- Table structure for table `sunbird_tblwh_packing_lists`
--

CREATE TABLE `sunbird_tblwh_packing_lists` (
  `id` int NOT NULL AUTO_INCREMENT,
  `delivery_note_id` int DEFAULT NULL,
  `packing_list_number` varchar(100) DEFAULT NULL,
  `packing_list_name` varchar(200) DEFAULT NULL,
  `width` decimal(15,2) DEFAULT '0.00',
  `height` decimal(15,2) DEFAULT '0.00',
  `lenght` decimal(15,2) DEFAULT '0.00',
  `weight` decimal(15,2) DEFAULT '0.00',
  `volume` decimal(15,2) DEFAULT '0.00',
  `clientid` int DEFAULT NULL,
  `subtotal` decimal(15,2) DEFAULT '0.00',
  `total_amount` decimal(15,2) DEFAULT '0.00',
  `discount_total` decimal(15,2) DEFAULT '0.00',
  `additional_discount` decimal(15,2) DEFAULT '0.00',
  `total_after_discount` decimal(15,2) DEFAULT '0.00',
  `billing_street` varchar(200) DEFAULT NULL,
  `billing_city` varchar(100) DEFAULT NULL,
  `billing_state` varchar(100) DEFAULT NULL,
  `billing_zip` varchar(100) DEFAULT NULL,
  `billing_country` int DEFAULT NULL,
  `shipping_street` varchar(200) DEFAULT NULL,
  `shipping_city` varchar(100) DEFAULT NULL,
  `shipping_state` varchar(100) DEFAULT NULL,
  `shipping_zip` varchar(100) DEFAULT NULL,
  `shipping_country` int DEFAULT NULL,
  `client_note` text,
  `admin_note` text,
  `approval` int DEFAULT '0',
  `datecreated` datetime DEFAULT NULL,
  `staff_id` int DEFAULT NULL,
  `type_of_packing_list` varchar(100) DEFAULT 'total',
  `delivery_status` varchar(100) DEFAULT 'wh_ready_to_deliver',
  `shipping_fee` decimal(15,2) DEFAULT '0.00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblwh_packing_lists`
--


--
-- Table structure for table `sunbird_tblwh_series`
--

CREATE TABLE `sunbird_tblwh_series` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` text,
  `model_id` int NOT NULL,
  PRIMARY KEY (`id`,`model_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblwh_series`
--


--
-- Table structure for table `sunbird_tblwh_staff_warehouses`
--

CREATE TABLE `sunbird_tblwh_staff_warehouses` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `staff_id` int DEFAULT NULL,
  `warehouse_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblwh_staff_warehouses`
--


--
-- Table structure for table `sunbird_tblwh_sub_group`
--

CREATE TABLE `sunbird_tblwh_sub_group` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `sub_group_code` varchar(100) DEFAULT NULL,
  `sub_group_name` text,
  `order` int DEFAULT NULL,
  `display` int DEFAULT NULL COMMENT 'display 1: display (yes)  0: not displayed (no)',
  `note` text,
  `group_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sunbird_tblwh_sub_group`
--



