('vvoc74a5nfjcafjj8atum8r8cju94jbv','95.217.226.245',1752080941,_binary '__ci_last_regenerate|i:1752080941;_prev_url|s:33:\"https://production.tagrit.com/cron/index\";'),('vvocoo93kbqdi9afn3p68p20les48bit','134.122.27.186',1745721181,_binary '__ci_last_regenerate|i:1745721181;_prev_url|s:33:\"https://app.tagrit.com/cron/index\";'),('vvodad62o0cv0kgqudhbnhu0c7cd6e24','95.217.226.245',1752755943,_binary '__ci_last_regenerate|i:1752755941;message-danger|s:0:\"\";__ci_vars|a:1:{s:14:\"message-danger\";s:3:\"new\";}_prev_url|s:33:\"https://production.tagrit.com/cron/index\";'),('vvohdpqgtqods8j55lr24hqb583unm78','159.89.41.160',1746601568,_binary '__ci_last_regenerate|i:1746601568;_prev_url|s:43:\"https://app.tagrit.com/authentication/login\";'),('vvoko9nra6gthu4oldjtm2lq6nijjip5','95.217.226.245',1752349741,_binary '__ci_last_regenerate|i:1752349741;_prev_url|s:33:\"https://production.tagrit.com/cron/index\";'),('vvold48mjbvobblkd9r7ech01qbn8mgq','134.122.27.186',1747130401,_binary '__ci_last_regenerate|i:1747130401;_prev_url|s:63:\"https://app.tagrit.com/admin/events_due/cronjobs/send_reminders\";'),('vvoms63t4se0igvth3av0kpf64aobgfo','104.248.218.35',1746819189,_binary '__ci_last_regenerate|i:1746819188;red_url|s:23:\"https://app.tagrit.com/\";'),('vvorpg07ggj0v31phl4cpc4cqv1vm3ek','95.217.226.245',1749272221,_binary '__ci_last_regenerate|i:1749272221;_prev_url|s:33:\"https://production.tagrit.com/cron/index\";'),('vvoso753dgovccgsfcnf52q80esggjia','139.59.245.220',1746463415,_binary '__ci_last_regenerate|i:1746463415;_prev_url|s:43:\"https://app.tagrit.com/authentication/login\";'),('vvoup40fipqgte8urpr5aeipr3nmaeck','95.217.226.245',1752622862,_binary '__ci_last_regenerate|i:1752622861;message-danger|s:0:\"\";__ci_vars|a:1:{s:14:\"message-danger\";s:3:\"new\";}_prev_url|s:33:\"https://production.tagrit.com/cron/index\";'),('vvp0sbas8cs7sarq5ngho32of7k2ia0v','104.248.218.35',1746242109,_binary '__ci_last_regenerate|i:1746242108;red_url|s:23:\"https://app.tagrit.com/\";'),('vvp4jamfgink9i62mioc302ml42mndes','95.217.226.245',1750885201,_binary '__ci_last_regenerate|i:1750885201;_prev_url|s:63:\"https://production.tagrit.com/admin/events_due/cronjobs/send_reminders\";'),('vvp5dcl4mts21qfcjol9rvpjbsfkv4mk','104.248.218.35',1746007568,_binary '__ci_last_regenerate|i:1746007568;red_url|s:23:\"https://app.tagrit.com/\";'),('vvp6ap2e1ktd8rhf4b0kdgr6imfa79qh','95.217.226.245',1752694201,_binary '__ci_last_regenerate|i:1752694201;_prev_url|s:69:\"https://production.tagrit.com/admin/events_due/cronjobs/send_attendance_list\";'),('vvp7onaloa4kpt84l8r7jqsaqsjk2nvj','95.217.226.245',1748635741,_binary '__ci_last_regenerate|i:1748635741;_prev_url|s:33:\"https://production.tagrit.com/cron/index\";'),('vvpcfhm183dimeffg8larmugoj21fg01','95.217.226.245',1752688201,_binary '__ci_last_regenerate|i:1752688201;_prev_url|s:63:\"https://production.tagrit.com/admin/events_due/cronjobs/send_reminders\";'),('vvpd09lqro0qr399dvh5r8f96lagfsoj','95.217.226.245',1748422381,_binary '__ci_last_regenerate|i:1748422381;_prev_url|s:33:\"https://production.tagrit.com/cron/index\";'),('vvpdr8ggqha3o07qi52tkt0vs1lebasd','134.122.27.186',1746410401,_binary '__ci_last_regenerate|i:1746410401;_prev_url|s:33:\"https://app.tagrit.com/cron/index\";'),('vvpe2oeveenh6ebdbtlr68ttcbnkdfvt','95.217.226.245',1749422101,_binary '__ci_last_regenerate|i:1749422101;_prev_url|s:69:\"https://production.tagrit.com/admin/events_due/cronjobs/send_attendance_list\";'),('vvpfa98ebheur4j9k8kqmg9223f5b1nn','95.217.226.245',1748217001,_binary '__ci_last_regenerate|i:1748217001;_prev_url|s:63:\"https://production.tagrit.com/admin/events_due/cronjobs/send_reminders\";'),('vvpg41i7bsgpp07gk4o8vnsust8hqvda','159.89.41.160',1746327608,_binary '__ci_last_regenerate|i:1746327608;red_url|s:23:\"https://app.tagrit.com/\";'),('vvpied3t7nlo1a60npva6mh2umqbq7mi','95.217.226.245',1750644721,_binary '__ci_last_regenerate|i:1750644721;_prev_url|s:33:\"https://production.tagrit.com/cron/index\";'),('vvpk5smbo6heo5hft6a1gcm1ms4p66jn','95.217.226.245',1753253221,_binary '__ci_last_regenerate|i:1753253221;_prev_url|s:33:\"https://production.tagrit.com/cron/index\";'),('vvplk95a7bk8vo46o84jsvbemj5t4oeo','159.89.41.160',1747051448,_binary '__ci_last_regenerate|i:1747051448;red_url|s:23:\"https://app.tagrit.com/\";'),('vvpq9k5070jn0srhab25kssq1rdfv4gv','104.248.86.98',1747167936,_binary '__ci_last_regenerate|i:1747167936;red_url|s:23:\"https://app.tagrit.com/\";'),('vvpqem2b8e99v0uogf31ml73lcgtghsc','95.217.226.245',1748121001,_binary '__ci_last_regenerate|i:1748121001;_prev_url|s:33:\"https://production.tagrit.com/cron/index\";'),('vvprrhi1lcvd7fvfehckafqoo288ctkp','104.248.218.35',1746475089,_binary '__ci_last_regenerate|i:1746475089;red_url|s:23:\"https://app.tagrit.com/\";'),('vvpth0qnjv5e37sjqhlggdqlksigpioa','95.217.226.245',1751101201,_binary '__ci_last_regenerate|i:1751101201;_prev_url|s:69:\"https://production.tagrit.com/admin/events_due/cronjobs/send_attendance_list\";'),('vvq27g1gnqoa9p0v3bpkgsq61aqtm59e','104.248.86.98',1746202297,_binary '__ci_last_regenerate|i:1746202297;_prev_url|s:43:\"https://app.tagrit.com/authentication/login\";'),('vvq2obuvkphjhrshhtn378vn9011v7hb','104.248.86.98',1746348097,_binary '__ci_last_regenerate|i:1746348097;_prev_url|s:43:\"https://app.tagrit.com/authentication/login\";'),('vvq58ndn0jk7f2knohvcd7527h04nrr2','95.217.226.245',1752258903,_binary '__ci_last_regenerate|i:1752258903;_prev_url|s:33:\"https://production.tagrit.com/cron/index\";'),('vvq5uphiahd5ljafmgapr9jqvvrbt6nv','134.122.27.186',1746543602,_binary '__ci_last_regenerate|i:1746543602;_prev_url|s:33:\"https://app.tagrit.com/cron/index\";'),('vvq9stmu3v9v4mir6cp2a7o065ermud6','104.248.86.98',1747041817,_binary '__ci_last_regenerate|i:1747041817;_prev_url|s:43:\"https://app.tagrit.com/authentication/login\";'),('vvqeql1vfteoed64imd7jdnp93k4gsbc','104.248.218.35',1746587709,_binary '__ci_last_regenerate|i:1746587709;_prev_url|s:43:\"https://app.tagrit.com/authentication/login\";'),('vvqgorr432u6id9ti7qd9ngueism8td0','159.89.41.160',1746311648,_binary '__ci_last_regenerate|i:1746311648;red_url|s:23:\"https://app.tagrit.com/\";'),('vvqhp90q4r5c9uoq9arfo2ej2stbaq8p','134.122.27.186',1746956281,_binary '__ci_last_regenerate|i:1746956281;_prev_url|s:33:\"https://app.tagrit.com/cron/index\";'),('vvqmphoio8pcj5a5jsh5fuo8s31a3map','139.59.245.220',1746838115,_binary '__ci_last_regenerate|i:1746838115;_prev_url|s:43:\"https://app.tagrit.com/authentication/login\";'),('vvqp0t3bst6a5qrifg5eocemepecc4tm','159.89.41.160',1746365168,_binary '__ci_last_regenerate|i:1746365168;_prev_url|s:43:\"https://app.tagrit.com/authentication/login\";'),('vvqp9bba93233q607abr273ljnnutf66','95.217.226.245',1751412301,_binary '__ci_last_regenerate|i:1751412301;_prev_url|s:63:\"https://production.tagrit.com/admin/events_due/cronjobs/send_reminders\";'),('vvqpgkkjp0njl8c0raqik1dj4vome4rg','95.217.226.245',1749645182,_binary '__ci_last_regenerate|i:1749645182;_prev_url|s:33:\"https://production.tagrit.com/cron/index\";'),('vvqs35rkqc832qu6d37nn08b2knuaghk','95.217.226.245',1749521461,_binary '__ci_last_regenerate|i:1749521461;_prev_url|s:33:\"https://production.tagrit.com/cron/index\";'),('vvqse8h6kvujq2b18d2577p8h1l6jout','134.122.27.186',1746101881,_binary '__ci_last_regenerate|i:1746101881;_prev_url|s:33:\"https://app.tagrit.com/cron/index\";'),('vvqtu39bpae4o90louo4tnapp0hs11lk','134.122.27.186',1745978341,_binary '__ci_last_regenerate|i:1745978341;_prev_url|s:33:\"https://app.tagrit.com/cron/index\";'),('vvqv61vgfbmv6c0t127kcvu3eu3308n6','95.217.226.245',1749560401,_binary '__ci_last_regenerate|i:1749560401;_prev_url|s:69:\"https://production.tagrit.com/admin/events_due/cronjobs/send_attendance_list\";'),('vvqvfbs504i22jkh3ddfgd10qi0vip2i','104.248.86.98',1746310177,_binary '__ci_last_regenerate|i:1746310177;_prev_url|s:43:\"https://app.tagrit.com/authentication/login\";'),('vvr3sknnff5660juf9643ugnbuggabav','159.89.41.160',1746222608,_binary '__ci_last_regenerate|i:1746222608;red_url|s:23:\"https://app.tagrit.com/\";'),('vvr46qfndepnrtbf2d77b34ljmcv832r','95.217.226.245',1752161581,_binary '__ci_last_regenerate|i:1752161581;_prev_url|s:33:\"https://production.tagrit.com/cron/index\";'),('vvr56bda5g8onf0ai7s5e80uktj6q5g8','176.58.96.49',1746165139,_binary '__ci_last_regenerate|i:1746165139;_prev_url|s:43:\"https://app.tagrit.com/authentication/login\";'),('vvr7cu01hg7rgl6afareo31iairsl8q9','104.248.86.98',1746728496,_binary '__ci_last_regenerate|i:1746728496;red_url|s:23:\"https://app.tagrit.com/\";'),('vvr8pfdonlbonfgvduihjjl8ljfskmmk','95.217.226.245',1752156001,_binary '__ci_last_regenerate|i:1752156001;_prev_url|s:71:\"https://production.tagrit.com/admin/events_due/cronjobs/process_welcome_emails\";'),('vvr9161cljil6es1pn9lh0jdgiuvbk51','159.89.41.160',1746125648,_binary '__ci_last_regenerate|i:1746125648;red_url|s:23:\"https://app.tagrit.com/\";'),('vvrdjq5l190bqnsuk1ld1nntjmi4addd','104.248.86.98',1746262417,_binary '__ci_last_regenerate|i:1746262417;_prev_url|s:43:\"https://app.tagrit.com/authentication/login\";'),('vvreqtet1j8ditb3uoiiqhioqup3tggv','139.59.245.220',1746541115,_binary '__ci_last_regenerate|i:1746541115;_prev_url|s:43:\"https://app.tagrit.com/authentication/login\";'),('vvrjmmtns0fqt0sbgp1bh0vj55t1vv23','139.59.245.220',1746162635,_binary '__ci_last_regenerate|i:1746162635;_prev_url|s:43:\"https://app.tagrit.com/authentication/login\";'),('vvrlrfuv10tbmv98k4072pe57a40rpvq','139.59.245.220',1746425314,_binary '__ci_last_regenerate|i:1746425314;red_url|s:23:\"https://app.tagrit.com/\";'),('vvrtf24oj6pmotoq9d6qd770s61k291v','159.89.41.160',1746133988,_binary '__ci_last_regenerate|i:1746133988;red_url|s:23:\"https://app.tagrit.com/\";'),('vvs0kv4csfh7bif2s5jsan151tssk56r','159.89.41.160',1746253328,_binary '__ci_last_regenerate|i:1746253328;red_url|s:23:\"https://app.tagrit.com/\";'),('vvs21lbgpu4l3phebkp47h0fafhebd77','159.89.41.160',1747185668,_binary '__ci_last_regenerate|i:1747185668;red_url|s:23:\"https://app.tagrit.com/\";'),('vvs25bpdaqkuc9a6l5bn0fdm4dd9f62e','104.248.86.98',1746346356,_binary '__ci_last_regenerate|i:1746346356;red_url|s:23:\"https://app.tagrit.com/\";'),('vvs7lumps06rleoeir0p5j3r34ktj78c','95.217.226.245',1750856041,_binary '__ci_last_regenerate|i:1750856041;_prev_url|s:33:\"https://production.tagrit.com/cron/index\";'),('vvs8iengat10bmnsll2auevq5eisq9f2','104.248.86.98',1746022417,_binary '__ci_last_regenerate|i:1746022417;_prev_url|s:43:\"https://app.tagrit.com/authentication/login\";'),('vvse0amu5g0eg5jcfnuaek7j3jd7kc6n','134.122.27.186',1746647645,_binary '__ci_last_regenerate|i:1746647641;message-danger|s:0:\"\";__ci_vars|a:1:{s:14:\"message-danger\";s:3:\"new\";}_prev_url|s:33:\"https://app.tagrit.com/cron/index\";'),('vvsfcpu62i32c2kte0rcjb161p77d2oo','104.248.86.98',1746478056,_binary '__ci_last_regenerate|i:1746478056;red_url|s:23:\"https://app.tagrit.com/\";'),('vvssi6ohbiq7r95l92lp1pever2cellr','159.89.41.160',1746295088,_binary '__ci_last_regenerate|i:1746295088;_prev_url|s:43:\"https://app.tagrit.com/authentication/login\";'),('vvstqv1k1vc6bjvulfukvn4taii19von','134.122.27.186',1746053101,_binary '__ci_last_regenerate|i:1746053101;_prev_url|s:63:\"https://app.tagrit.com/admin/events_due/cronjobs/send_reminders\";'),('vvt1a0iknp41sbsqohe8tnh5pi9ttloa','95.217.226.245',1749798001,_binary '__ci_last_regenerate|i:1749798001;_prev_url|s:69:\"https://production.tagrit.com/admin/events_due/cronjobs/send_attendance_list\";'),('vvt1pcgtde4e4ul56i3pv3jlfg178d2h','104.248.86.98',1746977376,_binary '__ci_last_regenerate|i:1746977376;red_url|s:23:\"https://app.tagrit.com/\";'),('vvt40plbba027tdh6j3m8j5ggtogb4fu','139.59.245.220',1746448055,_binary '__ci_last_regenerate|i:1746448055;_prev_url|s:43:\"https://app.tagrit.com/authentication/login\";'),('vvt42c5vrn9b9qj8tuas7ji00qbhh5v3','95.217.226.245',1747706401,_binary '__ci_last_regenerate|i:1747706401;_prev_url|s:69:\"https://production.tagrit.com/admin/events_due/cronjobs/send_attendance_list\";'),('vvt5u7nsckccac68tuf2imfa0lvajbc6','95.217.226.245',1752765601,_binary '__ci_last_regenerate|i:1752765601;_prev_url|s:33:\"https://production.tagrit.com/cron/index\";'),('vvt6nh26uiujn1fdclq47ckto1qnkke8','95.217.226.245',1752057661,_binary '__ci_last_regenerate|i:1752057661;_prev_url|s:33:\"https://production.tagrit.com/cron/index\";'),('vvta8vkj2fvkhrr4g7athqdd4fn5q1ib','95.217.226.245',1752717001,_binary '__ci_last_regenerate|i:1752717001;_prev_url|s:63:\"https://production.tagrit.com/admin/events_due/cronjobs/send_reminders\";'),('vvtah4va0nf4phg5fqltn24u7mv7q6u2','95.217.226.245',1750309982,_binary '__ci_last_regenerate|i:1750309982;_prev_url|s:33:\"https://production.tagrit.com/cron/index\";'),('vvtbpfsbqiuss741jc40e32rvok8bt9e','95.217.226.245',1749531181,_binary '__ci_last_regenerate|i:1749531181;_prev_url|s:33:\"https://production.tagrit.com/cron/index\";'),('vvtc0bnv0h36bd6ahnknphqb1skiiu05','104.248.218.35',1746906129,_binary '__ci_last_regenerate|i:1746906128;red_url|s:23:\"https://app.tagrit.com/\";'),('vvtgdh4488sf81r97hb80pkhaq507lqd','139.59.245.220',1746847414,_binary '__ci_last_regenerate|i:1746847414;red_url|s:23:\"https://app.tagrit.com/\";'),('vvtjbr9s88vlr1rp58jhb3l9lesrubml','139.59.245.220',1746713794,_binary '__ci_last_regenerate|i:1746713794;red_url|s:23:\"https://app.tagrit.com/\";'),('vvtkmrmbgh87he9ounicjk8e5e5aqgdb','95.217.226.245',1753275182,_binary '__ci_last_regenerate|i:1753275182;_prev_url|s:33:\"https://production.tagrit.com/cron/index\";'),('vvtorkpalvj28ttnoor04q63j9opbi80','139.59.245.220',1746179555,_binary '__ci_last_regenerate|i:1746179555;_prev_url|s:43:\"https://app.tagrit.com/authentication/login\";'),('vvtpk5btl1fsiiraaus509n3taiupg2v','95.217.226.245',1751840101,_binary '__ci_last_regenerate|i:1751840101;_prev_url|s:63:\"https://production.tagrit.com/admin/events_due/cronjobs/send_reminders\";'),('vvtuds9pv319buribh1em7n6bj40e6g1','104.248.86.98',1746246997,_binary '__ci_last_regenerate|i:1746246997;_prev_url|s:43:\"https://app.tagrit.com/authentication/login\";'),('vvtv66745s25i84jkhfi39eck3lau18i','104.248.218.35',1746192609,_binary '__ci_last_regenerate|i:1746192608;red_url|s:23:\"https://app.tagrit.com/\";'),('vvu219r4rl92lvt9se2trttcscbogt50','134.122.27.186',1746751501,_binary '__ci_last_regenerate|i:1746751501;_prev_url|s:63:\"https://app.tagrit.com/admin/events_due/cronjobs/send_reminders\";'),('vvuaf7jrb3rak1oaq8ebeacjabhkmdoc','95.217.226.245',1750107721,_binary '__ci_last_regenerate|i:1750107721;_prev_url|s:33:\"https://production.tagrit.com/cron/index\";'),('vvuch1m2eb2aja1bqe1puqrh09hmthc6','95.217.226.245',1751957401,_binary '__ci_last_regenerate|i:1751957401;_prev_url|s:63:\"https://production.tagrit.com/admin/events_due/cronjobs/send_reminders\";'),('vvud025ko28qit1vqv1th1ouefrp30lf','104.248.218.35',1746023409,_binary '__ci_last_regenerate|i:1746023409;_prev_url|s:43:\"https://app.tagrit.com/authentication/login\";'),('vvuidgajakek23e7rjgrjds3o4kfobdo','134.122.27.186',1746166501,_binary '__ci_last_regenerate|i:1746166501;_prev_url|s:33:\"https://app.tagrit.com/cron/index\";'),('vvulg6n29pt8bkcfj36jg61ferdblurk','104.248.86.98',1746858637,_binary '__ci_last_regenerate|i:1746858637;_prev_url|s:43:\"https://app.tagrit.com/authentication/login\";'),('vvup13vv0ok50gg6pa16o0vsmr94lc9q','134.122.27.186',1745457961,_binary '__ci_last_regenerate|i:1745457961;_prev_url|s:33:\"https://app.tagrit.com/cron/index\";'),('vvuqg7a9agm387pdfv958l55vkq1kgsp','139.59.245.220',1746530315,_binary '__ci_last_regenerate|i:1746530315;_prev_url|s:43:\"https://app.tagrit.com/authentication/login\";'),('vvv1n6ua6omfdgn9m8bj19vtn1uuop92','104.248.218.35',1746797109,_binary '__ci_last_regenerate|i:1746797109;_prev_url|s:43:\"https://app.tagrit.com/authentication/login\";'),('vvv78dc20o2njj6pohp9ar5m0lj1l5qj','104.248.86.98',1746999516,_binary '__ci_last_regenerate|i:1746999516;red_url|s:23:\"https://app.tagrit.com/\";'),('vvv9r4fkpkbeimevs37hsqbtq1nc41ak','134.122.27.186',1746806284,_binary '__ci_last_regenerate|i:1746806282;message-danger|s:0:\"\";__ci_vars|a:1:{s:14:\"message-danger\";s:3:\"new\";}_prev_url|s:33:\"https://app.tagrit.com/cron/index\";'),('vvvc3ge1fc653pqrket48tf9oejjqsj7','159.89.41.160',1746731768,_binary '__ci_last_regenerate|i:1746731768;_prev_url|s:43:\"https://app.tagrit.com/authentication/login\";'),('vvvf7t8vd7bmvchd1sap49ocbdr6lsbh','139.59.245.220',1747130674,_binary '__ci_last_regenerate|i:1747130674;red_url|s:23:\"https://app.tagrit.com/\";'),('vvvl1bev990o1esvs44pk4ro2aihskst','104.248.86.98',1746973176,_binary '__ci_last_regenerate|i:1746973176;red_url|s:23:\"https://app.tagrit.com/\";'),('vvvlhbvar3nscul5pm19ocrq9ck27dav','95.217.226.245',1749635041,_binary '__ci_last_regenerate|i:1749635041;_prev_url|s:33:\"https://production.tagrit.com/cron/index\";'),('vvvlpak3p9bu35mtubsqin1jl3kkfqs6','159.89.41.160',1747052408,_binary '__ci_last_regenerate|i:1747052408;_prev_url|s:43:\"https://app.tagrit.com/authentication/login\";'),('vvvn7eg5jrgt9s12blp4d78je1tdd8tp','43.135.142.7',1752604168,_binary '__ci_last_regenerate|i:1752604168;is_mobile|b:1;red_url|s:23:\"https://production.tagrit.com/\";'),('vvvrf9llp87u4rgp7je84jku4uehki6s','95.217.226.245',1752513361,_binary '__ci_last_regenerate|i:1752513361;_prev_url|s:33:\"https://production.tagrit.com/cron/index\";'),('vvvtut1nahego27qkffj9fciislbucpd','95.217.226.245',1752628921,_binary '__ci_last_regenerate|i:1752628921;_prev_url|s:33:\"https://production.tagrit.com/cron/index\";'),('vvvuv17gj7h29scd553bshj6p97vde96','139.59.245.220',1746503915,_binary '__ci_last_regenerate|i:1746503915;_prev_url|s:43:\"https://app.tagrit.com/authentication/login\";');

--
-- Table structure for table `tblsetting_asset_allocation`
--

CREATE TABLE `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 `tblsetting_asset_allocation`
--


--
-- Table structure for table `tblsetting_training`
--

CREATE TABLE `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 `tblsetting_training`
--


--
-- Table structure for table `tblsetting_transfer_records`
--

CREATE TABLE `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 `tblsetting_transfer_records`
--


--
-- Table structure for table `tblshared_customer_files`
--

CREATE TABLE `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 `tblshared_customer_files`
--


--
-- Table structure for table `tblspam_filters`
--

CREATE TABLE `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 `tblspam_filters`
--


--
-- Table structure for table `tblstaff`
--

CREATE TABLE `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,
  `flutex_api_key` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `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=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblstaff`
--

INSERT INTO `tblstaff` VALUES (1,'kefa@tagrit.com','Kefa','Hamisi','','','','','$2a$08$lqQBS3yG.60Bmr8B8rpDVuHruTZuL3uMrUj2TzJSnmIw4v.g4ZCBi',NULL,'2025-01-06 21:54:35','WhatsApp-Image-2024-11-19-at-10.30.48-PM.jpeg','102.68.78.141','2025-05-28 01:53:41','2025-05-28 03:49:02',NULL,NULL,NULL,1,0,1,'','','kefa-hamisi',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,0,NULL,NULL,NULL,0,NULL,NULL,NULL),(2,'david@tagrit.com','David','Amukowa','','','','','$2a$08$YUAkj5SEz84dP9qiPLv/xOlLaVlov8ngcsbWNra7R4sjkxhz.sHui',NULL,'2025-01-07 03:43:02','david.jpg','102.22.213.122','2025-07-16 13:11:41','2025-07-16 13:11:46','2025-01-08 06:47:28',NULL,NULL,1,1,1,'','','david-amukowa',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,0,NULL,NULL,NULL,0,'david@tagrit.com','','1753281662'),(3,'kevin@tagrit.com','Kevin','Amayi','','','','','$2y$10$RCXjc0mlowWXCpq2YXWw6.P.DmkbJ3PjpO/fVyYtg36FXM1nAaXfq',NULL,'2025-01-07 03:44:06','WhatsApp-Image-2024-11-19-at-7.28.10-PM.jpeg','41.90.70.154','2025-07-19 23:24:55','2025-07-11 12:45:08',NULL,'406394e098ccba7da121d7baf7642129','2025-04-12 19:39:52',1,0,1,'','','kevin-amayi',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,0,NULL,NULL,NULL,0,NULL,NULL,NULL),(4,'vivian@tagrit.com','Vivian','Namvuya','','','','','$2a$08$qC6CTNSmAOMSLpkqubOaKOl86x4xsLgkMxA5/PAKmU9FIXnbQdnK.',NULL,'2025-01-08 06:52:48','WhatsApp-Image-2024-11-21-at-4.03.17-PM-1536x1394.jpeg','102.219.210.222','2025-07-22 11:11:14','2025-07-22 11:15:26',NULL,NULL,NULL,1,1,1,'','','vivian-namvuya',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,0,NULL,NULL,NULL,0,NULL,NULL,NULL),(5,'beatrice@tagrit.com','Beatrice','Ayoo','','','','','$2a$08$XrrKpoIT8PB9XN14jTGTY.PEWunQW2m1Q99qMnDw8tq9R6Popf2EC',NULL,'2025-01-08 06:54:26','Ahendause.jpg','80.240.201.173','2025-01-16 22:33:40','2025-01-16 22:36:49','2025-01-16 22:28:15',NULL,NULL,1,1,1,'','','beatrice-ayoo',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,0,NULL,NULL,NULL,0,NULL,NULL,NULL),(6,'simon@tagrit.com','Simon','Mwachi','','','','','$2a$08$VXs7sACCYTKDd6eByCF0.uEPlalUCEOxMhfEjAinwRzUmXlQMoL3O',NULL,'2025-01-08 06:56:31','WhatsApp-Image-2024-11-19-at-7.27.28-PM.jpeg','197.155.73.25','2025-04-29 05:00:58','2025-04-29 05:01:00',NULL,NULL,NULL,1,1,1,'','','simon-mwachi',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,0,NULL,NULL,NULL,0,NULL,NULL,NULL),(8,'wabuyajames@gmail.com','James','Wabuya','','','','','$2a$08$WYeH8cO32a9qq4UCgF9m/evnqpOVqCQTaEak0LZvKW3NiAjCAc6fO',NULL,'2025-02-12 22:40:00',NULL,'41.90.217.29','2025-02-12 22:43:02','2025-02-12 22:43:07',NULL,NULL,NULL,1,1,1,'','','james-wabuya',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,0,NULL,NULL,NULL,0,NULL,NULL,NULL),(9,'kevinmusungu455@gmail.com','Live','Test','','','','','$2a$08$QIWCMrPDBqVzvH4N.MLrH.Xy.NArNgsyPOaB2qsPGc0tyc6.y6oFS',NULL,'2025-03-25 21:22:40',NULL,'105.163.2.36','2025-07-10 10:03:17','2025-07-10 10:05:09',NULL,NULL,NULL,0,1,1,'','','live-test',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,0,NULL,NULL,NULL,0,NULL,NULL,NULL);

--
-- Table structure for table `tblstaff_departments`
--

CREATE TABLE `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 `tblstaff_departments`
--


--
-- Table structure for table `tblstaff_permissions`
--

CREATE TABLE `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 `tblstaff_permissions`
--


--
-- Table structure for table `tblstock_take`
--

CREATE TABLE `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 `tblstock_take`
--


--
-- Table structure for table `tblstock_take_detail`
--

CREATE TABLE `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 `tblstock_take_detail`
--


--
-- Table structure for table `tblsubscriptions`
--

CREATE TABLE `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 `tblsubscriptions`
--


--
-- Table structure for table `tblsurveyresultsets`
--

CREATE TABLE `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 `tblsurveyresultsets`
--


--
-- Table structure for table `tblsurveys`
--

CREATE TABLE `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 `tblsurveys`
--


--
-- Table structure for table `tblsurveysemailsendcron`
--

CREATE TABLE `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 `tblsurveysemailsendcron`
--


--
-- Table structure for table `tblsurveysendlog`
--

CREATE TABLE `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 `tblsurveysendlog`
--


--
-- Table structure for table `tbltaggables`
--

CREATE TABLE `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 `tbltaggables`
--

INSERT INTO `tbltaggables` VALUES (1,'invoice',1,1),(2,'invoice',1,1),(6,'invoice',1,1),(13,'invoice',1,1),(17,'invoice',1,1),(18,'invoice',1,1),(35,'invoice',1,1),(36,'invoice',1,1),(37,'invoice',1,1),(38,'invoice',1,1),(39,'invoice',1,1),(40,'invoice',1,1),(43,'invoice',1,1),(44,'invoice',1,1),(45,'invoice',1,1),(46,'invoice',1,1),(47,'invoice',1,1),(48,'invoice',1,1),(33,'task',4,1),(34,'task',4,1),(35,'task',4,1),(49,'invoice',1,1),(51,'invoice',1,1),(52,'invoice',1,1),(53,'invoice',1,1),(54,'invoice',1,1),(55,'invoice',1,1),(56,'invoice',1,1),(57,'invoice',1,1),(58,'invoice',1,1),(59,'invoice',1,1),(60,'invoice',1,1),(61,'invoice',1,1),(62,'invoice',1,1),(63,'invoice',1,1),(64,'invoice',1,1),(65,'invoice',1,1),(66,'invoice',1,1),(67,'invoice',1,1),(68,'invoice',1,1);

--
-- Table structure for table `tbltags`
--

CREATE TABLE `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 AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbltags`
--

INSERT INTO `tbltags` VALUES (1,'psaas'),(4,'security'),(2,'tag1'),(3,'tag2');

--
-- Table structure for table `tbltask_assigned`
--

CREATE TABLE `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 `staffid` (`staffid`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbltask_assigned`
--

INSERT INTO `tbltask_assigned` VALUES (52,3,25,3,0),(53,3,26,3,0),(54,3,27,3,0),(55,3,28,3,0),(56,3,29,3,0),(57,3,30,3,0),(58,2,30,3,0),(59,3,31,3,0),(60,3,32,2,0),(61,1,32,2,0),(62,2,32,2,0),(63,3,33,3,0),(64,3,34,3,0),(65,1,34,3,0),(66,2,34,3,0),(67,1,35,3,0),(68,2,36,3,0),(69,3,37,3,0),(70,3,38,3,0),(71,3,39,3,0),(72,3,40,4,0);

--
-- Table structure for table `tbltask_checklist_items`
--

CREATE TABLE `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 `tbltask_checklist_items`
--


--
-- Table structure for table `tbltask_comments`
--

CREATE TABLE `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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbltask_comments`
--

INSERT INTO `tbltask_comments` VALUES (1,'[task_attachment]',40,4,0,7,'2025-05-09 12:38:05');

--
-- Table structure for table `tbltask_followers`
--

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

--
-- Dumping data for table `tbltask_followers`
--

INSERT INTO `tbltask_followers` VALUES (137,2,28),(138,2,31),(139,4,32),(140,6,32),(141,5,32),(142,1,33),(143,2,33),(144,3,34),(145,1,34),(146,2,34),(147,3,35),(148,2,35),(149,3,36),(150,1,36),(151,1,37),(152,2,37),(153,1,38),(154,2,38),(155,2,39),(156,5,40);

--
-- Table structure for table `tbltasks`
--

CREATE TABLE `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 AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbltasks`
--

INSERT INTO `tbltasks` VALUES (25,'Environment - Fix Bugs that Appear when someone changes to development ','<p>There are some errors that appear when someone changes the environment to development.</p>',2,'2025-03-28 19:53:15','2025-03-28',NULL,'2025-04-20 00:35:52',3,0,5,NULL,NULL,0,NULL,0,0,0,NULL,NULL,NULL,0,0,0,0,0.00,0,1,0,0,0),(26,'Documentation - Update Installation Readme to include Composer information','<p>Currently, the Installation file in Github does not have composer information.</p>',2,'2025-03-28 20:03:45','2025-03-28',NULL,'2025-04-19 21:58:24',3,0,5,NULL,NULL,0,NULL,0,0,0,NULL,NULL,NULL,0,0,0,0,0.00,0,1,0,0,0),(27,'SAAS - Normal Clients redirected to Admin Page','<p>When I access the client portal for the tenants in SAAS, I am redirected to the admin page instead of the client portal.<br><br>e.g accessing https://capabuil.tagrit.com/ takes me to https://capabuil.tagrit.com/admin/authentication<br><br>instead of opening the client portal.</p>',2,'2025-03-28 20:07:42','2025-03-28',NULL,'2025-04-19 21:58:34',3,0,5,NULL,NULL,0,NULL,0,0,0,NULL,NULL,NULL,0,0,0,0,0.00,0,1,0,0,0),(28,'UI/UX - Improve the UI/UX for Tagrit System','<p>- We need breadcrumbs on top of pages that clearly indicate where the user is and he can use the same to navigate back and forward...<br><br>-When a user opens a menu , the menu should remain open while the user is navigating to different locations in the system.<br><br>-We should have an highlight color for active menus.&#160;</p>',2,'2025-03-28 20:13:30','2025-03-28',NULL,NULL,3,0,1,NULL,NULL,0,NULL,0,0,0,NULL,NULL,NULL,0,0,0,0,0.00,0,1,0,0,0),(29,'Leads - Increase limit for datatables','<p>Increase limit for datatables</p>',2,'2025-03-31 11:33:07','2025-03-31',NULL,NULL,3,0,1,NULL,NULL,0,NULL,0,0,0,NULL,NULL,NULL,0,0,0,0,0.00,0,1,0,0,0),(30,'Marketing - Follow up SMS marketing with Hostpinnacle','<p>Marketing - Follow up SMS marketing with Hostpinnacle</p>',2,'2025-03-31 11:37:45','2025-03-31',NULL,NULL,3,0,1,NULL,NULL,0,NULL,0,0,0,NULL,NULL,NULL,0,0,0,0,0.00,0,1,0,0,0),(31,'Marketing - Fix Marketing Automation Bug','<p>Marketing - Fix Marketing Automation Bug</p>',2,'2025-03-31 11:41:23','2025-03-31',NULL,NULL,3,0,1,NULL,NULL,0,NULL,0,0,0,NULL,NULL,NULL,0,0,0,0,0.00,0,1,0,0,0),(32,'MPESA DARAJA Integration ','<p>Start the MPESA Daraja Integration&#160; to our Invoice&#160;</p>',3,'2025-04-03 16:30:51','2025-04-03',NULL,NULL,2,0,4,NULL,NULL,0,NULL,0,0,0,NULL,NULL,NULL,0,0,0,0,0.00,0,1,0,0,0),(33,'Security - Update Tagrit deployment.yaml file to improve security, hide all passwords and credentials','<p>Update Tagrit deployment.yaml file to improve security, hide all passwords and credentials</p>',3,'2025-04-11 09:16:16','2025-04-11',NULL,'2025-04-19 22:01:13',3,0,5,NULL,NULL,0,NULL,0,0,0,NULL,NULL,NULL,1,0,0,0,0.00,0,1,0,0,0),(34,'Security - Create a Workflow for backing up clients data.','<p>Create a Workflow for backing up clients data, that will prevent loose of data in case of any attack or downtime.</p>',3,'2025-04-11 09:18:15','2025-04-11',NULL,'2025-04-30 11:51:23',3,0,5,NULL,0,0,NULL,0,0,0,NULL,NULL,NULL,1,0,0,0,0.00,0,1,0,0,0),(35,'Security - Follow up on the current SSL certificate status. Purchase a stronger SSL certificate (e.g., EV or OV SSL), and install it on the server to enhance system security.','<p>Security - Follow up on SSL and Buy a stronger one and install in the system</p>',3,'2025-04-11 09:24:03','2025-04-11',NULL,NULL,3,0,4,NULL,NULL,0,NULL,0,0,0,NULL,NULL,NULL,1,0,0,0,0.00,0,1,0,0,0),(36,'Get latest Perfex CRM update ','<p>Get latest Perfex CRM update&#160;</p>',2,'2025-04-19 22:06:20','2025-04-19',NULL,NULL,3,0,4,NULL,NULL,0,NULL,0,0,0,NULL,NULL,NULL,1,0,0,0,0.00,0,1,0,0,0),(37,'Test APIs for perfex CRM Mobile App','<p>Test APIs for perfex CRM Mobile App</p>',2,'2025-04-19 22:44:17','2025-04-19',NULL,NULL,3,0,1,NULL,NULL,0,NULL,0,0,0,NULL,NULL,NULL,1,0,0,0,0.00,0,1,0,0,0),(38,'Deploy Mobile App for Perfex CRM ','<p>Deploy Mobile App for Perfex CRM&#160;</p>',2,'2025-04-19 22:47:13','2025-04-19',NULL,NULL,3,0,1,NULL,NULL,0,NULL,0,0,0,NULL,NULL,NULL,1,0,0,0,0.00,0,1,0,0,0),(39,'SAAS - Tenants Applications not enabling modules','<p>SAAS - Tenants Applications not enabling modules</p>',4,'2025-04-30 11:53:02','2025-04-30',NULL,NULL,3,0,4,NULL,NULL,0,NULL,0,0,0,NULL,NULL,NULL,1,0,0,0,0.00,0,1,0,0,0),(40,'Add functionality for more than one expense to be recorded. ','<p>&#160;</p>\n<p>Functionality to be added while creating an expense such that one can record more than one expense at a go. Sahzi I can only record one at a time. The plus icon only creates NEW EXPENSE CATEGORY which when used there will be wrong reports because the category will not be mapped.</p>',2,'2025-05-09 12:32:24','2025-05-09',NULL,NULL,4,0,4,NULL,NULL,0,NULL,0,0,0,NULL,NULL,NULL,0,0,0,0,0.00,0,1,0,0,0);

--
-- Table structure for table `tbltasks_checklist_templates`
--

CREATE TABLE `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 `tbltasks_checklist_templates`
--


--
-- Table structure for table `tbltaskstimers`
--

CREATE TABLE `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 `staff_id` (`staff_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbltaskstimers`
--

INSERT INTO `tbltaskstimers` VALUES (1,29,'1745095113','1745098539',3,0.00,NULL);

--
-- Table structure for table `tbltaxes`
--

CREATE TABLE `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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbltaxes`
--


--
-- Table structure for table `tbltemplates`
--

CREATE TABLE `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 `tbltemplates`
--


--
-- Table structure for table `tblticket_attachments`
--

CREATE TABLE `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 `tblticket_attachments`
--


--
-- Table structure for table `tblticket_replies`
--

CREATE TABLE `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 `tblticket_replies`
--


--
-- Table structure for table `tbltickets`
--

CREATE TABLE `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 `tbltickets`
--


--
-- Table structure for table `tbltickets_pipe_log`
--

CREATE TABLE `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 `tbltickets_pipe_log`
--


--
-- Table structure for table `tbltickets_predefined_replies`
--

CREATE TABLE `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 `tbltickets_predefined_replies`
--


--
-- Table structure for table `tbltickets_priorities`
--

CREATE TABLE `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 `tbltickets_priorities`
--

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

--
-- Table structure for table `tbltickets_status`
--

CREATE TABLE `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 `tbltickets_status`
--

INSERT INTO `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 `tbltodos`
--

CREATE TABLE `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 `tbltodos`
--


--
-- Table structure for table `tbltracked_mails`
--

CREATE TABLE `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 AUTO_INCREMENT=573 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbltracked_mails`
--

INSERT INTO `tbltracked_mails` VALUES (1,'ce4a2fbbbd5fdc80e80210ba960efd22',2,'invoice','2025-01-08 21:01:06','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000002'),(7,'ae943b80728272a21b355787643d06f1',13,'invoice','2025-01-29 13:41:23','reagan.nyadimo@capabuil.com',0,NULL,'Invoice with number INV-000011/01/2025 created'),(12,'9648a4407773c8483c42fb0820cbabdc',17,'invoice','2025-02-07 21:01:33','info@kerali.co.ke',1,'2025-02-19 21:03:29','Invoice with number INV-000015/02/2025 created'),(13,'253c216f653aa1ec3c61fbd321c422b6',18,'invoice','2025-02-07 21:01:48','justinkusola@gmail.com',1,'2025-02-12 11:26:36','Invoice with number INV-000016/02/2025 created'),(14,'ea24396aa2c9ec5a71cba1292575b123',17,'invoice','2025-02-08 21:05:29','info@kerali.co.ke',1,'2025-02-08 21:18:57','Invoice Overdue Notice - INV-000015/02/2025'),(15,'101317a6383842cfe6af69f07cf5f66e',18,'invoice','2025-02-08 21:05:38','justinkusola@gmail.com',1,'2025-02-12 11:27:02','Invoice Overdue Notice - INV-000016/02/2025'),(16,'e2d40b46629e7a2bed7143cb09f1be1b',17,'invoice','2025-02-10 21:03:23','info@kerali.co.ke',0,NULL,'Invoice Overdue Notice - INV-000015/02/2025'),(17,'7568e7a17c33f2742517f3b21de18e5e',18,'invoice','2025-02-10 21:03:36','justinkusola@gmail.com',1,'2025-02-12 11:28:05','Invoice Overdue Notice - INV-000016/02/2025'),(18,'2dceff43161461c3fd00439017649a84',18,'invoice','2025-02-12 21:00:07','justinkusola@gmail.com',1,'2025-03-11 16:00:52','Invoice Overdue Notice - INV-000016/02/2025'),(22,'8278b1ea75cc319087d8fcb9f5abbe3b',18,'invoice','2025-02-14 21:05:18','justinkusola@gmail.com',1,'2025-03-11 16:00:42','Invoice Overdue Notice - INV-000016/02/2025'),(23,'1604e17edb5178345c3dc370f4b9bc88',18,'invoice','2025-02-16 21:04:17','justinkusola@gmail.com',1,'2025-03-11 15:52:18','Invoice Overdue Notice - INV-000016/02/2025'),(24,'55730221daf439aa20c207d8346609fb',18,'invoice','2025-02-18 21:05:23','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000016/02/2025'),(25,'a284aab74149f87f45592c03cf315e3f',18,'invoice','2025-02-20 21:04:19','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000016/02/2025'),(27,'562234ef3b882c3f27a6bde78ff2d7af',18,'invoice','2025-02-22 21:05:52','justinkusola@gmail.com',1,'2025-03-11 16:00:37','Invoice Overdue Notice - INV-000016/02/2025'),(28,'688eca259a2b90f01678cebef41b894c',18,'invoice','2025-02-24 21:03:06','justinkusola@gmail.com',1,'2025-03-11 16:00:25','Invoice Overdue Notice - INV-000016/02/2025'),(30,'66fb5ed6b5a50b1c709f2bfc373bd26f',18,'invoice','2025-02-26 21:03:06','justinkusola@gmail.com',1,'2025-03-11 16:00:10','Invoice Overdue Notice - INV-000016/02/2025'),(31,'b873d0334c3f727152c0cea9b6f06c23',35,'invoice','2025-03-01 21:02:04','reagan.nyadimo@capabuil.com',0,NULL,'Invoice with number INV-000033/03/2025 created'),(32,'18d0e409cf64b97191cdeb9ba4a65053',35,'invoice','2025-03-02 21:04:04','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000033/03/2025'),(33,'a132d66c5a71173a74fad3563fac3308',35,'invoice','2025-03-03 14:24:53','mary.ngile@capabuil.com',0,NULL,'Invoice # INV-000033/03/2025 '),(34,'5f74c582aedd9b677a07d52d67e4d9a7',35,'invoice','2025-03-03 14:24:55','reagan.nyadimo@capabuil.com',0,NULL,'Invoice # INV-000033/03/2025 '),(35,'fd960eef9ca6cea3adc21312441e001f',35,'invoice','2025-03-03 14:24:56','nafisa.ahmed@capabuil.com',0,NULL,'Invoice # INV-000033/03/2025 '),(36,'a8339d933f6732dbebfc39bb3ec0478e',35,'invoice','2025-03-03 14:24:58','dorcas.wangari@capabuil.com',0,NULL,'Invoice # INV-000033/03/2025 '),(37,'e3970c155495bcac89fd51bf14caeed8',35,'invoice','2025-03-04 21:04:05','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000033/03/2025'),(38,'4ee46a3d843666c14658eb5152d04876',35,'invoice','2025-03-04 21:04:06','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000033/03/2025'),(39,'6bc1785fb725643d227568e475100d1f',35,'invoice','2025-03-04 21:04:09','nafisa.ahmed@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000033/03/2025'),(40,'15e72896f64fe5b05c41cced215a8d34',35,'invoice','2025-03-04 21:04:10','dorcas.wangari@capabuil.com',1,'2025-03-05 09:23:19','Invoice Overdue Notice - INV-000033/03/2025'),(41,'d2d219c7c81869beb53ec563cf9057de',1,'invoice','2025-03-05 15:03:44','info@kerali.co.ke',0,NULL,'Invoice with number INV-000001 created'),(42,'11be26866eb5292340eaab9c167a6d43',36,'invoice','2025-03-07 21:01:06','info@kerali.co.ke',1,'2025-03-09 20:37:43','Invoice with number INV-000034/03/2025 created'),(43,'4392c0cdb57c5ade4d6b14932d626792',37,'invoice','2025-03-07 21:01:09','justinkusola@gmail.com',1,'2025-03-11 15:59:18','Invoice with number INV-000035/03/2025 created'),(44,'20d7dc6a1de6e2a94433fc8176cfd597',36,'invoice','2025-03-08 21:03:04','info@kerali.co.ke',0,NULL,'Invoice Overdue Notice - INV-000034/03/2025'),(45,'dc4803660008df28dcb8c3d29edf005e',37,'invoice','2025-03-08 21:03:07','justinkusola@gmail.com',1,'2025-03-11 15:59:06','Invoice Overdue Notice - INV-000035/03/2025'),(46,'2901e1fd8a867aefae94afd89aacbc19',40,'invoice','2025-03-09 21:03:04','salat@goshippingcargo.com',0,NULL,'Invoice with number INV-000038/03/2025 created'),(47,'10d30665f3afd068f6dc1b931f9beb6f',36,'invoice','2025-03-10 21:01:05','info@kerali.co.ke',0,NULL,'Invoice Overdue Notice - INV-000034/03/2025'),(48,'beed5a623d2601da699ddf1a548836a5',41,'invoice','2025-03-21 09:09:39','mary.ngile@capabuil.com',0,NULL,'Invoice with number INV-000039/02/2025 created'),(49,'1d83f121178ce648d3551fd0d89cd599',41,'invoice','2025-03-21 09:09:41','reagan.nyadimo@capabuil.com',0,NULL,'Invoice with number INV-000039/02/2025 created'),(50,'bddaaef4d1763e47ca7fa4b8d6dc2885',41,'invoice','2025-03-21 09:09:42','nafisa.ahmed@capabuil.com',0,NULL,'Invoice with number INV-000039/02/2025 created'),(51,'051bbde4ac3443e03a82ec6da14f3bae',41,'invoice','2025-03-21 09:09:44','dorcas.wangari@capabuil.com',0,NULL,'Invoice with number INV-000039/02/2025 created'),(52,'ea59e3f867677663c7c76caedaee8887',41,'invoice','2025-03-21 21:03:04','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(53,'6187141db3b2b184197d69d6a86c6e77',41,'invoice','2025-03-21 21:03:05','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(54,'cf39b7322717e23083b3aed75463f3fd',41,'invoice','2025-03-21 21:03:07','nafisa.ahmed@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(55,'02b2c6063939fc399940587395358708',41,'invoice','2025-03-21 21:03:08','dorcas.wangari@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(56,'37b74ea8f69ae5a0bc708ec8178da2f9',41,'invoice','2025-03-23 21:00:03','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(57,'23c8e9bc5470fde758258bf66cd99daf',41,'invoice','2025-03-23 21:00:05','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(58,'5c35eaebc217aa11045557ec0f8bea81',41,'invoice','2025-03-23 21:00:06','nafisa.ahmed@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(59,'04bd046e9e2f283b6dc5b988ba393898',41,'invoice','2025-03-23 21:00:08','dorcas.wangari@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(60,'a95b848c8663c466172f5ec526f80d16',41,'invoice','2025-03-25 21:03:03','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(61,'1b2281c0cdb60c1b9a5d1dd028b4115b',41,'invoice','2025-03-25 21:03:04','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(62,'19e268a6264784742f887e3c780a94bc',41,'invoice','2025-03-25 21:03:06','nafisa.ahmed@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(63,'00008f0bdf19d1a90a2b18c85523e3b9',41,'invoice','2025-03-25 21:03:07','dorcas.wangari@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(64,'c6130efd2ea8265c5ee3e7f8483ab8af',41,'invoice','2025-03-28 10:21:41','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(65,'a9095aabc8f20e145538a5795cf8056b',41,'invoice','2025-03-28 10:21:42','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(66,'1dc76381f66c398d18d32842a0b970ef',41,'invoice','2025-03-28 10:21:44','nafisa.ahmed@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(67,'f9eb9d751a63bb94de597c45ad738cd0',41,'invoice','2025-03-28 10:21:45','dorcas.wangari@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(68,'bd61cf1148ebac44ff75818863d80ec8',41,'invoice','2025-03-30 21:03:03','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(69,'6fdef4db25b3271b8bb7ae094c11e688',41,'invoice','2025-03-30 21:03:04','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(70,'4c3cd16ebf114610f3deae1dd756d865',41,'invoice','2025-03-30 21:03:06','nafisa.ahmed@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(71,'e705e92c8fa736bb44aa286113fd465b',41,'invoice','2025-03-30 21:03:07','dorcas.wangari@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(72,'3c9aef84fd46db1893dcbdcfad480878',41,'invoice','2025-04-01 21:02:02','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(73,'588782b2d2ffabc565b1ecb525031d6c',41,'invoice','2025-04-01 21:02:04','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(74,'39f8223e27d25ed3e728dd0e225d5f1c',41,'invoice','2025-04-01 21:02:05','nafisa.ahmed@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(75,'6e0aec877047c67f15c04866dd3e694c',41,'invoice','2025-04-01 21:02:07','dorcas.wangari@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(76,'44493ddfe1c6137265a64ac4a4462ebf',43,'invoice','2025-04-01 21:02:09','mary.ngile@capabuil.com',0,NULL,'Invoice with number INV-000041/04/2025 created'),(77,'c2d1c0b0f442ecdfda9e7f9159edb93d',43,'invoice','2025-04-01 21:02:10','reagan.nyadimo@capabuil.com',0,NULL,'Invoice with number INV-000041/04/2025 created'),(78,'9459fdab4cc4b084471b1663f15b2ea3',43,'invoice','2025-04-01 21:02:12','nafisa.ahmed@capabuil.com',0,NULL,'Invoice with number INV-000041/04/2025 created'),(79,'0ab0e338d1fb18b0b8410dab9039e722',43,'invoice','2025-04-01 21:02:13','dorcas.wangari@capabuil.com',0,NULL,'Invoice with number INV-000041/04/2025 created'),(80,'1c6deffced002bd69dadf2603a6ac5f9',41,'invoice','2025-04-03 21:03:03','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(81,'3fe239329c061c3084b9c529af765d8c',41,'invoice','2025-04-03 21:03:04','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(82,'2eacb16d56f1ef5cee065f99d3272a52',41,'invoice','2025-04-03 21:03:06','nafisa.ahmed@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(83,'47932dca63397bee3338835ef0409437',41,'invoice','2025-04-03 21:03:07','dorcas.wangari@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(84,'db80e0ba47839dbfea15dd4aa2c60a28',41,'invoice','2025-04-05 21:02:04','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(85,'91c0308de20c5790f4ae5960192ed70e',41,'invoice','2025-04-05 21:02:05','reagan.nyadimo@capabuil.com',1,'2025-04-05 21:16:08','Invoice Overdue Notice - INV-000039/02/2025'),(86,'fca8062b996e589e5596d2e3c7c1d8e3',41,'invoice','2025-04-05 21:02:07','nafisa.ahmed@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(87,'aaabfb9101637df178e4525d22b049ce',41,'invoice','2025-04-05 21:02:08','dorcas.wangari@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(88,'e238638bb58e431267839da6243fd5be',41,'invoice','2025-04-07 21:03:03','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(89,'d4ddced3f03b3c6de550fbd30ed6e933',41,'invoice','2025-04-07 21:03:05','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(90,'34ff9200a159ac98765236c517b2cabc',41,'invoice','2025-04-07 21:03:06','nafisa.ahmed@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(91,'ba99d5af98be6f397e0f3b350dab2b64',41,'invoice','2025-04-07 21:03:08','dorcas.wangari@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(92,'8e0baf9b13aa0eb1a04d4def351c6521',44,'invoice','2025-04-07 21:03:11','info@kerali.co.ke',0,NULL,'Invoice with number INV-000042/04/2025 created'),(93,'9a1b844a6f00a83129afef2beb1359b6',45,'invoice','2025-04-07 21:03:14','justinkusola@gmail.com',0,NULL,'Invoice with number INV-000043/04/2025 created'),(94,'8d70f45cf3e5b1261cbc66cad4ec5807',45,'invoice','2025-04-07 21:03:16','gemmotorwash@gmail.com',0,NULL,'Invoice with number INV-000043/04/2025 created'),(95,'6284317c487edf4962d4623c37ccf852',45,'invoice','2025-04-07 21:03:18','duncan.kilon.dk@gmail.com',1,'2025-04-07 21:03:49','Invoice with number INV-000043/04/2025 created'),(96,'2878a306d18233d45d9d9f37677a3ab6',45,'invoice','2025-04-07 21:03:20','duncankilondk@gmail.com',1,'2025-04-07 21:03:54','Invoice with number INV-000043/04/2025 created'),(97,'15cea2d09211fc649e10bce4f60801c7',46,'invoice','2025-04-07 21:03:23','kilakitukazi@gmail.com',1,'2025-04-07 21:10:35','Invoice with number INV-000044/04/2025 created'),(98,'32ccda434d57fa827437c1276ed74f24',45,'invoice','2025-04-08 21:03:04','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(99,'541f476fb7011c5409cbc19157038c56',45,'invoice','2025-04-08 21:03:06','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(100,'e2797478890ab6410373d0207e98710a',45,'invoice','2025-04-08 21:03:08','duncan.kilon.dk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(101,'eafe0b0f6fa2795b0261b3d47e22f186',45,'invoice','2025-04-08 21:03:11','duncankilondk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(102,'386b8c8daa03a8750ba3422a9b110207',47,'invoice','2025-04-08 21:03:13','namvuyavivian@gmail.com',1,'2025-04-14 13:25:21','Invoice with number INV-000045/04/2025 created'),(103,'ff773638c5e83d5f75e78204b32f27c3',41,'invoice','2025-04-09 21:04:03','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(104,'149917f6c6ec9893d52469fef5b971c8',41,'invoice','2025-04-09 21:04:04','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(105,'83f3bc81baebdc3d3a732fb0e1d54996',41,'invoice','2025-04-09 21:04:06','nafisa.ahmed@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(106,'e161a6c505633606cddadb5577d4775f',41,'invoice','2025-04-09 21:04:07','dorcas.wangari@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(107,'ae6d8a85410a42b5a7365ab0acc35134',48,'invoice','2025-04-09 21:04:09','salat@goshippingcargo.com',1,'2025-04-09 21:04:17','Invoice with number INV-000046/04/2025 created'),(108,'87f27c5d062b38440f1868d88537c61d',48,'invoice','2025-04-10 21:01:05','salat@goshippingcargo.com',1,'2025-04-10 22:57:45','Invoice Overdue Notice - INV-000046/04/2025'),(109,'e4b59fd04d957b143c156e15b82c12d9',45,'invoice','2025-04-10 21:01:08','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(110,'e581040f7a67d13b971d4e862cd06b4d',45,'invoice','2025-04-10 21:01:11','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(111,'15499bc9b90341456f4db7850f08bf62',45,'invoice','2025-04-10 21:01:13','duncan.kilon.dk@gmail.com',1,'2025-04-10 21:47:24','Invoice Overdue Notice - INV-000043/04/2025'),(112,'553df270c26c59372755ed4cf3ac470f',45,'invoice','2025-04-10 21:01:15','duncankilondk@gmail.com',1,'2025-04-10 21:47:24','Invoice Overdue Notice - INV-000043/04/2025'),(113,'2dc1c83dd03f50e8945a1e831034dcf5',41,'invoice','2025-04-11 21:01:03','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(114,'daea5580bd80b850c92243d8b6fb5a32',41,'invoice','2025-04-11 21:01:05','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(115,'f3558fc0f6ce562965bf5939699b2e98',41,'invoice','2025-04-11 21:01:06','nafisa.ahmed@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(116,'385f6e4a94719d171ee3201dd1bb886c',41,'invoice','2025-04-11 21:01:08','dorcas.wangari@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(117,'37f6b223e4a99ced1566a64984f42dab',45,'invoice','2025-04-12 21:00:04','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(118,'ad5dd152348e0e40fa359acef3ccc917',45,'invoice','2025-04-12 21:00:06','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(119,'042c008bc68168be1de858c989692bd1',45,'invoice','2025-04-12 21:00:09','duncan.kilon.dk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(120,'8105ef75c185da3abbcceab1acf6b68e',45,'invoice','2025-04-12 21:00:11','duncankilondk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(121,'43186ceac372fcb90dee0739e2b9b97b',48,'invoice','2025-04-12 21:00:13','salat@goshippingcargo.com',1,'2025-04-13 00:07:03','Invoice Overdue Notice - INV-000046/04/2025'),(122,'a260856a7a8b7d00539a0f9f0434f202',41,'invoice','2025-04-13 21:02:03','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(123,'ac8c8fb53e97c0f2f2f510c04057a21a',41,'invoice','2025-04-13 21:02:05','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(124,'ba8486a02227a7db2c4e8f1bdf3d8894',41,'invoice','2025-04-13 21:02:06','nafisa.ahmed@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(125,'13e61831f0daeb969dd557fae9405df7',41,'invoice','2025-04-13 21:02:08','dorcas.wangari@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(126,'121795bd299c48dd877dcd3835a1d195',45,'invoice','2025-04-14 21:01:05','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(127,'1c2843986e367078b052890e7298fbf4',45,'invoice','2025-04-14 21:01:07','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(128,'0dc2baf5d4eef4b02da5847f6db97a39',45,'invoice','2025-04-14 21:01:10','duncan.kilon.dk@gmail.com',1,'2025-04-15 16:36:39','Invoice Overdue Notice - INV-000043/04/2025'),(129,'59b75c8a7f03ee069fe83b90b1426f8c',45,'invoice','2025-04-14 21:01:12','duncankilondk@gmail.com',1,'2025-04-15 16:36:39','Invoice Overdue Notice - INV-000043/04/2025'),(130,'95c6235b49e1f0197b2725aa2a240449',48,'invoice','2025-04-14 21:01:15','salat@goshippingcargo.com',1,'2025-04-14 21:01:23','Invoice Overdue Notice - INV-000046/04/2025'),(131,'f74c45683c1fa9c5a2b583698bdae919',41,'invoice','2025-04-15 21:03:03','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(132,'e628db0f472767636b86e2ec234d3e2d',41,'invoice','2025-04-15 21:03:05','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(133,'fb88cc6992d2824553b3f8f04c7f7600',41,'invoice','2025-04-15 21:03:06','nafisa.ahmed@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(134,'9b0796cde20352dd3483997273ed9b26',41,'invoice','2025-04-15 21:03:08','dorcas.wangari@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(135,'d5b4c5656e0bb821f1118bdd59350c89',45,'invoice','2025-04-16 21:02:05','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(136,'17e5f89a617d2683fa623b0ec9676280',45,'invoice','2025-04-16 21:02:08','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(137,'879f28adc25cfedd505515fcb6565d1c',45,'invoice','2025-04-16 21:02:10','duncan.kilon.dk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(138,'3537ed814b469deea95ef8b315bc6cfa',45,'invoice','2025-04-16 21:02:12','duncankilondk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(139,'5d2f6d168df5b06b1e93265ede8848fe',41,'invoice','2025-04-17 21:02:03','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(140,'6177417a636d3adefa1a72bf6438863f',41,'invoice','2025-04-17 21:02:04','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(141,'725ce9b5ac0cc0e33da920aae71c9706',41,'invoice','2025-04-17 21:02:06','nafisa.ahmed@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(142,'8f382cf604f2e9c4b396ce663cd077e0',41,'invoice','2025-04-17 21:02:07','dorcas.wangari@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(143,'ed5ec595bbc3a8cd92b2030d96278bcf',45,'invoice','2025-04-18 21:02:04','justinkusola@gmail.com',1,'2025-04-19 08:38:22','Invoice Overdue Notice - INV-000043/04/2025'),(144,'c970fe1a7c263c9feb7284a34739a976',45,'invoice','2025-04-18 21:02:06','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(145,'53969d247adf0195f9f6f27995d1f192',45,'invoice','2025-04-18 21:02:08','duncan.kilon.dk@gmail.com',1,'2025-04-20 03:16:46','Invoice Overdue Notice - INV-000043/04/2025'),(146,'270c2232fe2f13adce67ea48d76d509e',45,'invoice','2025-04-18 21:02:10','duncankilondk@gmail.com',1,'2025-04-20 03:16:46','Invoice Overdue Notice - INV-000043/04/2025'),(147,'1857ef58eafe2f8d978a7b9717eb45d7',41,'invoice','2025-04-19 17:02:18','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(148,'9d3d2f87b3303dea81df2af6c3789d98',41,'invoice','2025-04-19 17:02:19','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(149,'db25ba04d589a802f30c87cd49e309a1',41,'invoice','2025-04-19 17:02:21','nafisa.ahmed@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(150,'5ee906849abc1e4e9f1cdd5dc439211f',41,'invoice','2025-04-19 17:02:22','dorcas.wangari@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(151,'17dff76ba20f457f9ff9d3d4285fb73e',45,'invoice','2025-04-20 13:29:08','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(152,'7503dc94bee40b7bf3f5688477ab609f',45,'invoice','2025-04-20 13:29:11','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(153,'0001033178dad87e79f40fc9d1dd1f46',45,'invoice','2025-04-20 13:29:13','duncan.kilon.dk@gmail.com',1,'2025-04-20 15:55:12','Invoice Overdue Notice - INV-000043/04/2025'),(154,'c5531a0f18e5fbc0292dd22df3f7a904',45,'invoice','2025-04-20 13:29:15','duncankilondk@gmail.com',1,'2025-04-20 15:55:12','Invoice Overdue Notice - INV-000043/04/2025'),(155,'29179e8933386231e26210dfc5acc78b',41,'invoice','2025-04-21 21:04:04','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(156,'d33be45dc13fa96128a48b434fb48e0e',41,'invoice','2025-04-21 21:04:05','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(157,'e21a4ee7f84c7f0283be4fd004c3342e',41,'invoice','2025-04-21 21:04:07','nafisa.ahmed@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(158,'7b5453ab923938191cce7730ee1514a5',41,'invoice','2025-04-21 21:04:08','dorcas.wangari@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(159,'ce5b6f0dfb68ac0b5006ec55249eb40a',45,'invoice','2025-04-22 21:01:05','justinkusola@gmail.com',1,'2025-04-22 22:07:21','Invoice Overdue Notice - INV-000043/04/2025'),(160,'950e8de19f90c0a966d3c63bfe1a6501',45,'invoice','2025-04-22 21:01:08','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(161,'728528fdc8e29a42e84b50c1c78eb001',45,'invoice','2025-04-22 21:01:10','duncan.kilon.dk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(162,'05d9f507cee94de261d4c7b409c2b8cb',45,'invoice','2025-04-22 21:01:12','duncankilondk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(163,'a974f67e304943574daff7296326ffd4',41,'invoice','2025-04-23 21:02:03','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(164,'ab829f086f692e81c289005fbc43080b',41,'invoice','2025-04-23 21:02:05','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(165,'d86980452d7149a63bc5e5e98be4593e',41,'invoice','2025-04-23 21:02:06','nafisa.ahmed@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(166,'4e8bbdf90bc13ee4aa03985a4dc8b363',41,'invoice','2025-04-23 21:02:08','dorcas.wangari@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(167,'eb4773f7e3a6be5ffd323ba73b5a18ea',45,'invoice','2025-04-24 21:01:04','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(168,'33e5d9bd9343f95b2c3ad5f3d8709225',45,'invoice','2025-04-24 21:01:07','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(169,'a25fc323b53bafd20f548d18e3efec3e',45,'invoice','2025-04-24 21:01:09','duncan.kilon.dk@gmail.com',1,'2025-04-24 21:01:43','Invoice Overdue Notice - INV-000043/04/2025'),(170,'57f1a122ce6cf5b65624b77c5e320460',45,'invoice','2025-04-24 21:01:12','duncankilondk@gmail.com',1,'2025-04-24 21:01:22','Invoice Overdue Notice - INV-000043/04/2025'),(171,'539df207ddbb372f1d92a27b84318d16',45,'invoice','2025-04-26 21:03:04','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(172,'417d0b443d4e271141ae22f796d86222',45,'invoice','2025-04-26 21:03:06','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(173,'2dfac83c6b117df7ebc5c304e550d193',45,'invoice','2025-04-26 21:03:09','duncan.kilon.dk@gmail.com',1,'2025-04-26 21:03:18','Invoice Overdue Notice - INV-000043/04/2025'),(174,'08371e4e2ef7a5f7d02ee5b0724a8cba',45,'invoice','2025-04-26 21:03:11','duncankilondk@gmail.com',1,'2025-04-26 21:03:17','Invoice Overdue Notice - INV-000043/04/2025'),(175,'d6609b6544fc63cdb1ef3ee8ffd3b1a8',45,'invoice','2025-04-28 21:04:05','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(176,'884687fc700574d65b457bff306361ef',45,'invoice','2025-04-28 21:04:09','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(177,'a678318ff1333b414b1c0266119a75fa',45,'invoice','2025-04-28 21:04:11','duncan.kilon.dk@gmail.com',1,'2025-04-28 21:04:29','Invoice Overdue Notice - INV-000043/04/2025'),(178,'a1412eb30d1a9223be0fbc8e6ca4ea56',45,'invoice','2025-04-28 21:04:14','duncankilondk@gmail.com',1,'2025-04-28 21:04:31','Invoice Overdue Notice - INV-000043/04/2025'),(179,'73a71b075bbe5f90c7b0e8d60ead48da',45,'invoice','2025-04-30 21:02:05','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(180,'c861c9fb4a4aecffcb07b70abb880b98',45,'invoice','2025-04-30 21:02:07','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(181,'73d4a57538e567b197b11c413d5a33ea',45,'invoice','2025-04-30 21:02:09','duncan.kilon.dk@gmail.com',1,'2025-04-30 21:02:16','Invoice Overdue Notice - INV-000043/04/2025'),(182,'9083525ea081f2eadf058c30bea52946',45,'invoice','2025-04-30 21:02:11','duncankilondk@gmail.com',1,'2025-04-30 21:02:20','Invoice Overdue Notice - INV-000043/04/2025'),(183,'7372bd966119fd77c5210e7e6d77db7b',52,'invoice','2025-05-01 21:05:03','mary.ngile@capabuil.com',0,NULL,'Invoice with number INV-000050/05/2025 created'),(184,'3979adbf1f2c0d739f1ca5c7e7043393',52,'invoice','2025-05-01 21:05:05','reagan.nyadimo@capabuil.com',0,NULL,'Invoice with number INV-000050/05/2025 created'),(185,'7312c4b0f0de486b098f1ee62d741fb3',52,'invoice','2025-05-01 21:05:06','nafisa.ahmed@capabuil.com',0,NULL,'Invoice with number INV-000050/05/2025 created'),(186,'e9120b5a7a79649a17be1feea762f17b',52,'invoice','2025-05-01 21:05:08','dorcas.wangari@capabuil.com',1,'2025-05-01 21:05:18','Invoice with number INV-000050/05/2025 created'),(187,'e8b1bf99cd1332c8c4d6707bd184fded',45,'invoice','2025-05-02 21:05:05','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(188,'aeb94e9a9db3c43fc1e57ae302494421',45,'invoice','2025-05-02 21:05:08','gemmotorwash@gmail.com',1,'2025-05-03 13:56:53','Invoice Overdue Notice - INV-000043/04/2025'),(189,'d95b2860aa7d88abfb8126eed0ffd104',45,'invoice','2025-05-02 21:05:10','duncan.kilon.dk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(190,'91bd235ed4e8d48e9db5c0e7cdc8ca57',45,'invoice','2025-05-02 21:05:12','duncankilondk@gmail.com',1,'2025-05-02 21:05:32','Invoice Overdue Notice - INV-000043/04/2025'),(191,'ca0845bcc211d803d3ecb9cf479a897c',45,'invoice','2025-05-04 21:00:05','justinkusola@gmail.com',1,'2025-05-10 05:54:58','Invoice Overdue Notice - INV-000043/04/2025'),(192,'60a8d909c74550c3c15248acdc62bd70',45,'invoice','2025-05-04 21:00:07','gemmotorwash@gmail.com',1,'2025-05-04 21:01:40','Invoice Overdue Notice - INV-000043/04/2025'),(193,'b58b4692ea587abe9fbd16aeec31a813',45,'invoice','2025-05-04 21:00:09','duncan.kilon.dk@gmail.com',1,'2025-05-04 21:00:23','Invoice Overdue Notice - INV-000043/04/2025'),(194,'fbf27b93793c0ea06ee6ce18211c471a',45,'invoice','2025-05-04 21:00:11','duncankilondk@gmail.com',1,'2025-05-04 21:00:20','Invoice Overdue Notice - INV-000043/04/2025'),(195,'267062a113cbc71d9414bc127cbf47b0',45,'invoice','2025-05-10 21:02:03','justinkusola@gmail.com',1,'2025-05-14 11:26:56','Invoice Overdue Notice - INV-000043/04/2025'),(196,'e984cff1d0f13d8b4c6f19f2d6d62681',45,'invoice','2025-05-10 21:02:05','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(197,'e0d2d30cdbc36e8fdf4c609aca293709',45,'invoice','2025-05-10 21:02:06','duncan.kilon.dk@gmail.com',1,'2025-05-10 21:02:11','Invoice Overdue Notice - INV-000043/04/2025'),(198,'79f2953ab6f4feb94e02126669de3c26',45,'invoice','2025-05-10 21:02:08','duncankilondk@gmail.com',1,'2025-05-10 21:02:14','Invoice Overdue Notice - INV-000043/04/2025'),(199,'0c1750c9ce69180a3bcc9d62c6c0dc1e',54,'invoice','2025-05-10 21:02:11','justinkusola@gmail.com',1,'2025-05-14 11:28:00','Invoice Overdue Notice - INV-000052/05/2025'),(200,'3274e1523f0a5467f2f425f1a2858340',54,'invoice','2025-05-10 21:02:12','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(201,'84d1d519abf107282379bae4f430d4fa',54,'invoice','2025-05-10 21:02:14','duncan.kilon.dk@gmail.com',1,'2025-05-10 21:02:19','Invoice Overdue Notice - INV-000052/05/2025'),(202,'f4ca51899e14cf419d276210507669e0',54,'invoice','2025-05-10 21:02:16','duncankilondk@gmail.com',1,'2025-05-10 21:02:20','Invoice Overdue Notice - INV-000052/05/2025'),(203,'ceb134b1030033f716805f930fde5168',45,'invoice','2025-05-12 21:01:03','justinkusola@gmail.com',1,'2025-05-14 11:27:51','Invoice Overdue Notice - INV-000043/04/2025'),(204,'af8532d8ae07efc68cba59c1e8045393',45,'invoice','2025-05-12 21:01:20','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(205,'fcf446b67931aa44e2b1fb8504d4bbe1',45,'invoice','2025-05-12 21:01:21','duncan.kilon.dk@gmail.com',1,'2025-05-12 21:01:26','Invoice Overdue Notice - INV-000043/04/2025'),(206,'66aa10937dc4326a3aaf98b9f1bac7ca',45,'invoice','2025-05-12 21:01:40','duncankilondk@gmail.com',1,'2025-05-12 21:01:49','Invoice Overdue Notice - INV-000043/04/2025'),(207,'3bbd4a09824fdebd9fc2647e2f4d062b',54,'invoice','2025-05-12 21:01:58','justinkusola@gmail.com',1,'2025-05-14 11:27:44','Invoice Overdue Notice - INV-000052/05/2025'),(208,'863a4be980d57b1176d86014a33d969a',54,'invoice','2025-05-12 21:01:58','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(209,'922ebb56198a2f5ea4076c69fe2ee8c9',54,'invoice','2025-05-12 21:01:58','duncan.kilon.dk@gmail.com',1,'2025-05-12 21:02:02','Invoice Overdue Notice - INV-000052/05/2025'),(210,'cdc6d00b9a82f9e95fb832a180b9bc88',54,'invoice','2025-05-12 21:01:59','duncankilondk@gmail.com',1,'2025-05-12 21:02:02','Invoice Overdue Notice - INV-000052/05/2025'),(211,'fb2b855f68e28128c930d838adb749f7',41,'invoice','2025-05-13 08:38:08','nafisa.ahmed@capabuil.com',1,'2025-05-13 09:45:18','Invoice # INV-000039/02/2025 '),(212,'bc51b50dad3a945f0aa2ec35a1c218f4',41,'invoice','2025-05-13 08:38:08','reagan.nyadimo@capabuil.com',0,NULL,'Invoice # INV-000039/02/2025 '),(213,'a7202450bcd0c4c89cc83fddcf7780c0',41,'invoice','2025-05-13 08:38:11','mary.ngile@capabuil.com',0,NULL,'Invoice # INV-000039/02/2025 '),(214,'e72bb76e94f4a370f9cd210dfae9d36a',41,'invoice','2025-05-13 21:05:08','nafisa.ahmed@capabuil.com',1,'2025-05-14 09:40:19','Invoice Overdue Notice - INV-000039/02/2025'),(215,'911f54db946d13c94111baff472c4bc8',41,'invoice','2025-05-13 21:05:16','reagan.nyadimo@capabuil.com',1,'2025-05-14 05:01:30','Invoice Overdue Notice - INV-000039/02/2025'),(216,'bbc42e2c560cb4325be6a11419e4b571',41,'invoice','2025-05-13 21:05:16','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(217,'0f8f3f9996f9a9d3c177fbc14c354984',45,'invoice','2025-05-14 21:00:12','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(218,'eea52aa04d1edb8049bf8c8b2b707024',45,'invoice','2025-05-14 21:00:13','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(219,'65070b96df3ad1a1a84c168cd63c5c19',45,'invoice','2025-05-14 21:00:14','duncan.kilon.dk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(220,'5ad61f130b618894dc3d89aafddba021',45,'invoice','2025-05-14 21:00:17','duncankilondk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(221,'4a1b1fc0684be6618996ddde2ce02b63',54,'invoice','2025-05-14 21:00:18','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(222,'bdac325f94da0a49ce1efedf103af4ea',54,'invoice','2025-05-14 21:00:24','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(223,'0793a852e6b72d13a33d01ec5c71869b',54,'invoice','2025-05-14 21:00:25','duncan.kilon.dk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(224,'c5063de10507c472745f56b371acc595',54,'invoice','2025-05-14 21:00:26','duncankilondk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(225,'f563d7f90de499e1f5e07a5b915fa286',41,'invoice','2025-05-18 15:50:39','nafisa.ahmed@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(226,'3571cd57f6563a7df1347389b8f63aa7',41,'invoice','2025-05-18 15:50:40','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(227,'d3fa1dba50cad7c03bcea430c12d70d6',41,'invoice','2025-05-18 15:50:40','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(228,'c035df70600c27534834e9d24c0dde0b',45,'invoice','2025-05-18 15:50:42','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(229,'e1102fef06e32491a9803939590815af',45,'invoice','2025-05-18 15:50:44','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(230,'a25672d06048b18dd533b189037c46e7',45,'invoice','2025-05-18 15:50:45','duncan.kilon.dk@gmail.com',1,'2025-05-18 15:51:00','Invoice Overdue Notice - INV-000043/04/2025'),(231,'1149cef1df27d161a8fbac95d5eb372d',45,'invoice','2025-05-18 15:50:47','duncankilondk@gmail.com',1,'2025-05-18 15:50:58','Invoice Overdue Notice - INV-000043/04/2025'),(232,'28f3e0046aaa77f8017f1b282fe5b70d',54,'invoice','2025-05-18 15:50:48','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(233,'f76dcddf82b60e102c66528f2c0c9711',54,'invoice','2025-05-18 15:50:50','gemmotorwash@gmail.com',1,'2025-05-19 23:20:37','Invoice Overdue Notice - INV-000052/05/2025'),(234,'3aeb904a56efb3e6c21b0e2150636c8a',54,'invoice','2025-05-18 15:50:52','duncan.kilon.dk@gmail.com',1,'2025-05-18 15:50:59','Invoice Overdue Notice - INV-000052/05/2025'),(235,'1f10d1068af2ffa039c18c55834d329a',54,'invoice','2025-05-18 15:50:53','duncankilondk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(236,'637d8f4a2ae3a4f7cdaf2fbad293a456',41,'invoice','2025-05-24 21:01:02','nafisa.ahmed@capabuil.com',1,'2025-05-26 09:36:18','Invoice Overdue Notice - INV-000039/02/2025'),(237,'5df40c80c6d97716ed84ef50cc214ef7',41,'invoice','2025-05-24 21:01:02','reagan.nyadimo@capabuil.com',1,'2025-05-26 04:47:47','Invoice Overdue Notice - INV-000039/02/2025'),(238,'76d7d5abc82713c5d1c5006713198966',41,'invoice','2025-05-24 21:01:03','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(239,'6d7899fff31cf2f00ac6f3401953477c',45,'invoice','2025-05-24 21:01:08','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(240,'cba3d32faadef38f1a5a431f200db9ca',45,'invoice','2025-05-24 21:01:11','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(241,'6d610f58b65c7df2f7252ddff5d9d01f',45,'invoice','2025-05-24 21:01:12','duncan.kilon.dk@gmail.com',1,'2025-05-24 21:01:30','Invoice Overdue Notice - INV-000043/04/2025'),(242,'e7bbbfe918dcc410a2fb9c50230fc742',45,'invoice','2025-05-24 21:01:13','duncankilondk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(243,'cde20d7c3be58ef7af02228fc9de970e',54,'invoice','2025-05-24 21:01:15','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(244,'f77378d50439c46fbde7537a589e60af',54,'invoice','2025-05-24 21:01:16','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(245,'8ed1bdc351c56f2d1695fabb258b67ba',54,'invoice','2025-05-24 21:01:17','duncan.kilon.dk@gmail.com',1,'2025-05-24 21:01:36','Invoice Overdue Notice - INV-000052/05/2025'),(246,'67c8e2274d0a167bcd5bd3914ba55218',54,'invoice','2025-05-24 21:01:19','duncankilondk@gmail.com',1,'2025-05-24 21:01:26','Invoice Overdue Notice - INV-000052/05/2025'),(247,'c1474c30eccce1602d72b574c24ac3ea',41,'invoice','2025-05-26 21:03:02','nafisa.ahmed@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(248,'b80f04c9cf346ac7dac5f4baabfdc315',41,'invoice','2025-05-26 21:03:03','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(249,'bd09107b73c9fca786bfaaeac171c494',41,'invoice','2025-05-26 21:03:04','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(250,'d35ae11c60e074bf46938098937f4995',45,'invoice','2025-05-26 21:03:05','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(251,'fa0448e090b9b87f3c92fdb1780470b9',45,'invoice','2025-05-26 21:03:06','gemmotorwash@gmail.com',1,'2025-05-27 17:24:22','Invoice Overdue Notice - INV-000043/04/2025'),(252,'843c5b32f570ffa19a4716992768f84e',45,'invoice','2025-05-26 21:03:09','duncan.kilon.dk@gmail.com',1,'2025-05-26 21:03:24','Invoice Overdue Notice - INV-000043/04/2025'),(253,'a1fdbfd8ce16ce60f027348a3fa1b903',45,'invoice','2025-05-26 21:03:10','duncankilondk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(254,'20b4239ee9efcd004c8b2f7d9f084556',54,'invoice','2025-05-26 21:03:11','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(255,'94cbe345994acd8a3cb664786828a1bb',54,'invoice','2025-05-26 21:03:12','gemmotorwash@gmail.com',1,'2025-05-27 17:24:22','Invoice Overdue Notice - INV-000052/05/2025'),(256,'492075189e4f1794d6d16f35ad6f6e9f',54,'invoice','2025-05-26 21:03:14','duncan.kilon.dk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(257,'31b24450b843c2b46c25c1b514249c13',54,'invoice','2025-05-26 21:03:15','duncankilondk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(258,'2bca5634ee25ed678b03668f7fe230de',41,'invoice','2025-05-28 21:04:03','nafisa.ahmed@capabuil.com',1,'2025-05-29 09:24:04','Invoice Overdue Notice - INV-000039/02/2025'),(259,'9bd31934aaf690ce1256b56313221c01',41,'invoice','2025-05-28 21:04:03','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(260,'32c29bfc7e1487f82efca431635473db',41,'invoice','2025-05-28 21:04:04','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(261,'2a73f57a32411cc9bf123982d8bac033',45,'invoice','2025-05-28 21:04:06','justinkusola@gmail.com',1,'2025-05-29 16:45:06','Invoice Overdue Notice - INV-000043/04/2025'),(262,'f803d98319ce7aaf2a825ce76500631d',45,'invoice','2025-05-28 21:04:09','gemmotorwash@gmail.com',1,'2025-05-30 12:43:55','Invoice Overdue Notice - INV-000043/04/2025'),(263,'c78eb869d910d057c138f6dcb14118a5',45,'invoice','2025-05-28 21:04:11','duncan.kilon.dk@gmail.com',1,'2025-05-28 21:04:32','Invoice Overdue Notice - INV-000043/04/2025'),(264,'d471241a12baffe171ea17f9a4bae0c0',45,'invoice','2025-05-28 21:04:12','duncankilondk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(265,'6854b4917b9cba70e3a89db026ecf6f1',54,'invoice','2025-05-28 21:04:13','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(266,'e0da11d62d44b239b1d1eb745a3c0e1b',54,'invoice','2025-05-28 21:04:15','gemmotorwash@gmail.com',1,'2025-05-30 12:43:50','Invoice Overdue Notice - INV-000052/05/2025'),(267,'bd2977a8c096a35ebf0ec40f0653b694',54,'invoice','2025-05-28 21:04:16','duncan.kilon.dk@gmail.com',1,'2025-05-28 21:04:29','Invoice Overdue Notice - INV-000052/05/2025'),(268,'e853e2e6f0bca95888405280a35651b3',54,'invoice','2025-05-28 21:04:18','duncankilondk@gmail.com',1,'2025-05-28 21:04:30','Invoice Overdue Notice - INV-000052/05/2025'),(269,'550cadcaad4171a96e8326d8257448d3',41,'invoice','2025-05-30 21:02:02','nafisa.ahmed@capabuil.com',1,'2025-06-03 08:51:33','Invoice Overdue Notice - INV-000039/02/2025'),(270,'3608ec0c9f2cb4c9aeb03cbc1f62cde1',41,'invoice','2025-05-30 21:02:03','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(271,'fe181c56d665714d042bba05e67e62a1',41,'invoice','2025-05-30 21:02:03','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(272,'00b4ab42e4d32f089bfff55773d82bfc',45,'invoice','2025-05-30 21:02:06','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(273,'2efab39a3b8541eca5511b5180301f2e',45,'invoice','2025-05-30 21:02:07','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(274,'20ea70f31f29f1dce1cfc4c40272f627',45,'invoice','2025-05-30 21:02:08','duncan.kilon.dk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(275,'3bba0484de2771f71749dd6c072a65d2',45,'invoice','2025-05-30 21:02:10','duncankilondk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(276,'21f0aec3f425ccff9280cb3e8175078a',54,'invoice','2025-05-30 21:02:11','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(277,'4e8188654ff512f7aa8ec1b13e3c42aa',54,'invoice','2025-05-30 21:02:12','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(278,'65c1d098aab50a661b5fa3aab2faf9cb',54,'invoice','2025-05-30 21:02:14','duncan.kilon.dk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(279,'f3a668b769cd62e34f7491296eaffe7e',54,'invoice','2025-05-30 21:02:15','duncankilondk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(280,'b69363b42dbc6adb36a89a8827bb8449',41,'invoice','2025-06-01 21:04:02','nafisa.ahmed@capabuil.com',1,'2025-06-03 08:51:30','Invoice Overdue Notice - INV-000039/02/2025'),(281,'95a3a3efb55105aa9fa6553629867c12',41,'invoice','2025-06-01 21:04:03','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(282,'9c894f69f5f36eff8cebdf63b5358b2e',41,'invoice','2025-06-01 21:04:04','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(283,'9708df7ebd5a083c6e47979d36122e9b',45,'invoice','2025-06-01 21:04:05','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(284,'07f361f5f8cb9959dcba5397896a6758',45,'invoice','2025-06-01 21:04:06','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(285,'88687db08180e464e3aa1f1e8e0620c7',45,'invoice','2025-06-01 21:04:08','duncan.kilon.dk@gmail.com',1,'2025-06-01 21:04:14','Invoice Overdue Notice - INV-000043/04/2025'),(286,'fecdf9a0236fe2719ef949fd417f3eed',45,'invoice','2025-06-01 21:04:09','duncankilondk@gmail.com',1,'2025-06-01 21:04:15','Invoice Overdue Notice - INV-000043/04/2025'),(287,'225c3afdef9db33c7559174779f96bf4',54,'invoice','2025-06-01 21:04:10','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(288,'ac87bb7867a11a103f69f6ae6b6c29d4',54,'invoice','2025-06-01 21:04:12','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(289,'5299656eb72c55e00a86c800ec753178',54,'invoice','2025-06-01 21:04:13','duncan.kilon.dk@gmail.com',1,'2025-06-01 21:04:21','Invoice Overdue Notice - INV-000052/05/2025'),(290,'85a9138fea08392ce674d1ade7a15c5e',54,'invoice','2025-06-01 21:04:14','duncankilondk@gmail.com',1,'2025-06-01 21:04:24','Invoice Overdue Notice - INV-000052/05/2025'),(291,'0cc09894ee68b553be4ef8da292fdef8',58,'invoice','2025-06-01 21:04:15','nafisa.ahmed@capabuil.com',1,'2025-06-03 08:51:18','Invoice with number INV-000056/06/2025 created'),(292,'8a39796dcf23339950b171c5b55bb6a9',58,'invoice','2025-06-01 21:04:16','reagan.nyadimo@capabuil.com',0,NULL,'Invoice with number INV-000056/06/2025 created'),(293,'a72773027b0e21921f1ca6c19a468d8e',58,'invoice','2025-06-01 21:04:16','mary.ngile@capabuil.com',0,NULL,'Invoice with number INV-000056/06/2025 created'),(294,'b48e213f64db86dca507bf762e176e64',41,'invoice','2025-06-03 21:01:02','nafisa.ahmed@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(295,'78785515d8b0223437620d5a215cf18a',41,'invoice','2025-06-03 21:01:03','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(296,'10610ae242f2b39794ba4a6f1bf13d87',41,'invoice','2025-06-03 21:01:03','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(297,'17b27bcd4347a3e3d542983f5dd333b7',45,'invoice','2025-06-03 21:01:07','justinkusola@gmail.com',1,'2025-06-24 22:08:35','Invoice Overdue Notice - INV-000043/04/2025'),(298,'fb15a651859503f757383bda7e6ac4c4',45,'invoice','2025-06-03 21:01:08','gemmotorwash@gmail.com',1,'2025-06-04 10:44:09','Invoice Overdue Notice - INV-000043/04/2025'),(299,'915f51e023a128e82057b10b5133c8b6',45,'invoice','2025-06-03 21:01:10','duncan.kilon.dk@gmail.com',1,'2025-06-03 21:01:27','Invoice Overdue Notice - INV-000043/04/2025'),(300,'1a762744d513c0a1927ed4d6a3fa75d4',45,'invoice','2025-06-03 21:01:11','duncankilondk@gmail.com',1,'2025-06-03 21:01:22','Invoice Overdue Notice - INV-000043/04/2025'),(301,'7877daef6a9d3c905c0c0ba7fafbe6fd',54,'invoice','2025-06-03 21:01:12','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(302,'0a31e289ed728d46ce17007fdfb884b5',54,'invoice','2025-06-03 21:01:14','gemmotorwash@gmail.com',1,'2025-06-04 10:44:08','Invoice Overdue Notice - INV-000052/05/2025'),(303,'cc770485d14fa3de6734d82e18763f49',54,'invoice','2025-06-03 21:01:15','duncan.kilon.dk@gmail.com',1,'2025-06-03 21:01:28','Invoice Overdue Notice - INV-000052/05/2025'),(304,'59a3dc8e0e9c6a8b85e02b10f1377530',54,'invoice','2025-06-03 21:01:16','duncankilondk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(305,'2a7dc50a2763c39e435629d27b1f30a9',41,'invoice','2025-06-05 21:00:02','nafisa.ahmed@capabuil.com',1,'2025-06-09 10:43:48','Invoice Overdue Notice - INV-000039/02/2025'),(306,'614936613587ec7dddf27ad33e0f89d5',41,'invoice','2025-06-05 21:00:03','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(307,'abb2b01d2bd9d8e5e061f0cae9987463',41,'invoice','2025-06-05 21:00:04','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(308,'97374d254ad484e3c0011e796b411280',45,'invoice','2025-06-05 21:00:05','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(309,'1ee77c5cdc880de20b4cf88190b7ac29',45,'invoice','2025-06-05 21:00:06','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(310,'6f5e2d39d87f731276f4e35a5704dd59',45,'invoice','2025-06-05 21:00:08','duncan.kilon.dk@gmail.com',1,'2025-06-05 21:00:26','Invoice Overdue Notice - INV-000043/04/2025'),(311,'ea99488f93c52531512df6f4d39f5bc2',45,'invoice','2025-06-05 21:00:09','duncankilondk@gmail.com',1,'2025-06-05 21:00:20','Invoice Overdue Notice - INV-000043/04/2025'),(312,'76644c6254ccc5a0859a3dbc878eeac5',54,'invoice','2025-06-05 21:00:11','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(313,'0c536672d7428828f35ffa077ab85222',54,'invoice','2025-06-05 21:00:12','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(314,'212632d2569b5b8892479f1da6506959',54,'invoice','2025-06-05 21:00:13','duncan.kilon.dk@gmail.com',1,'2025-06-05 21:00:30','Invoice Overdue Notice - INV-000052/05/2025'),(315,'34566aa3d30402d4bc6d16ecc31880aa',54,'invoice','2025-06-05 21:00:15','duncankilondk@gmail.com',1,'2025-06-05 21:00:25','Invoice Overdue Notice - INV-000052/05/2025'),(316,'6bd85d46e822b62c1aa948eed5bac7ec',41,'invoice','2025-06-07 21:03:02','nafisa.ahmed@capabuil.com',1,'2025-06-10 09:27:20','Invoice Overdue Notice - INV-000039/02/2025'),(317,'063144d53494d955636c3d3d2ef60932',41,'invoice','2025-06-07 21:03:03','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(318,'9752b850e2893e3d6d609a21a685a597',41,'invoice','2025-06-07 21:03:04','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(319,'2e7a43755882741cea4dea067250b8f1',45,'invoice','2025-06-07 21:03:06','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(320,'6827d32c6f82140d0a6c2c0e4e186b55',45,'invoice','2025-06-07 21:03:08','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(321,'efef4b3a4b28ca42c004505f083ad3c2',45,'invoice','2025-06-07 21:03:09','duncan.kilon.dk@gmail.com',1,'2025-06-07 21:03:15','Invoice Overdue Notice - INV-000043/04/2025'),(322,'c83f5c8f3bd5a4d17a479d998c4cf431',45,'invoice','2025-06-07 21:03:10','duncankilondk@gmail.com',1,'2025-06-07 21:03:20','Invoice Overdue Notice - INV-000043/04/2025'),(323,'5ab4821ac426b7b1798242a36930e388',54,'invoice','2025-06-07 21:03:12','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(324,'29c0ddf36049bf1e33ba9a8917bb256e',54,'invoice','2025-06-07 21:03:13','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(325,'45f5e15c2c49871bb77ed0e73424514f',54,'invoice','2025-06-07 21:03:14','duncan.kilon.dk@gmail.com',1,'2025-06-07 21:03:24','Invoice Overdue Notice - INV-000052/05/2025'),(326,'4cd662a6b871d58698e64e6c83c43279',54,'invoice','2025-06-07 21:03:16','duncankilondk@gmail.com',1,'2025-06-07 21:03:34','Invoice Overdue Notice - INV-000052/05/2025'),(327,'fb32260b17502f1d0888491fc7afd7fb',59,'invoice','2025-06-07 21:03:17','info@kerali.co.ke',0,NULL,'Invoice with number INV-000057/06/2025 created'),(328,'c3fdb4aa575d46dd165b4e9177624c18',60,'invoice','2025-06-07 21:03:18','justinkusola@gmail.com',0,NULL,'Invoice with number INV-000058/06/2025 created'),(329,'831ea9b3823a019a3afaa41e010aae32',60,'invoice','2025-06-07 21:03:20','gemmotorwash@gmail.com',0,NULL,'Invoice with number INV-000058/06/2025 created'),(330,'2a82a22412eb4b48cc78a01a878fcd30',60,'invoice','2025-06-07 21:03:21','duncan.kilon.dk@gmail.com',1,'2025-06-07 21:03:27','Invoice with number INV-000058/06/2025 created'),(331,'5da9137e526378e2937034548e770510',60,'invoice','2025-06-07 21:03:22','duncankilondk@gmail.com',1,'2025-06-07 21:03:30','Invoice with number INV-000058/06/2025 created'),(332,'d2e77d6e97f5ce133e25f04885235670',61,'invoice','2025-06-07 21:03:24','kilakitukazi@gmail.com',1,'2025-06-08 16:16:53','Invoice with number INV-000059/06/2025 created'),(333,'20bf68496641c28a4e12d476cca0eb9c',59,'invoice','2025-06-08 21:00:03','info@kerali.co.ke',0,NULL,'Invoice Overdue Notice - INV-000057/06/2025'),(334,'9cf46c626c5d35e1d79ff0a9e29eef24',60,'invoice','2025-06-08 21:00:04','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000058/06/2025'),(335,'cc5736b8f3dca7d45bff762232c04f0f',60,'invoice','2025-06-08 21:00:06','gemmotorwash@gmail.com',1,'2025-06-08 21:00:16','Invoice Overdue Notice - INV-000058/06/2025'),(336,'6f4392e908f4c1d8efe22a9887ec91c3',60,'invoice','2025-06-08 21:00:07','duncan.kilon.dk@gmail.com',1,'2025-06-08 21:00:25','Invoice Overdue Notice - INV-000058/06/2025'),(337,'ff51c7ac1fd686024a19fcf1873e7b52',60,'invoice','2025-06-08 21:00:08','duncankilondk@gmail.com',1,'2025-06-08 21:00:16','Invoice Overdue Notice - INV-000058/06/2025'),(338,'76479799524c719ebc90a4e612ce3e32',62,'invoice','2025-06-08 21:00:10','namvuyavivian@gmail.com',1,'2025-06-10 13:00:16','Invoice with number INV-000060/06/2025 created'),(339,'859bd399af030a921b4506b1d2523261',41,'invoice','2025-06-09 21:01:02','nafisa.ahmed@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(340,'5e6e31659f498a8b2a6b09031f83b549',41,'invoice','2025-06-09 21:01:03','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(341,'3b2f527e8e58f574f8fb32a9aad0f115',41,'invoice','2025-06-09 21:01:03','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(342,'a57b7258a062f45d0115064f345c13d0',45,'invoice','2025-06-09 21:01:06','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(343,'20ff0d70eff42a1e5a9024fc24c49de9',45,'invoice','2025-06-09 21:01:08','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(344,'1137bb0de2bdb7f2076f09ec282a2283',45,'invoice','2025-06-09 21:01:10','duncan.kilon.dk@gmail.com',1,'2025-06-09 21:01:30','Invoice Overdue Notice - INV-000043/04/2025'),(345,'5be61ca3377ee55ad5423ba3d32738fa',45,'invoice','2025-06-09 21:01:11','duncankilondk@gmail.com',1,'2025-06-09 21:01:21','Invoice Overdue Notice - INV-000043/04/2025'),(346,'feddc5aa8c0ac57fb5df58f74ef8d1c7',54,'invoice','2025-06-09 21:01:13','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(347,'15ddcd509f842901e763b27e18dd5c86',54,'invoice','2025-06-09 21:01:14','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(348,'af7dc83dc30230d3c35742a29f9edaa4',54,'invoice','2025-06-09 21:01:15','duncan.kilon.dk@gmail.com',1,'2025-06-09 21:01:24','Invoice Overdue Notice - INV-000052/05/2025'),(349,'09cd12889680d5ae51f76b09c77c7b1f',54,'invoice','2025-06-09 21:01:17','duncankilondk@gmail.com',1,'2025-06-09 21:01:25','Invoice Overdue Notice - INV-000052/05/2025'),(350,'7bc17d72443c7c7aa303805272678148',63,'invoice','2025-06-09 21:01:19','salat@goshippingcargo.com',1,'2025-06-09 21:03:42','Invoice with number INV-000061/06/2025 created'),(351,'e7dd8612a56ed5234edaee81162378cc',63,'invoice','2025-06-10 13:46:32','salat@goshippingcargo.com',1,'2025-06-10 14:03:50','Invoice # INV-000061/06/2025 '),(352,'7a07f8f620ba4674aca7269165609140',60,'invoice','2025-06-10 21:05:04','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000058/06/2025'),(353,'27308958422dc0a77eaab4861445caec',60,'invoice','2025-06-10 21:05:05','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000058/06/2025'),(354,'a475d722cab0671323e3bec80dea7018',60,'invoice','2025-06-10 21:05:08','duncan.kilon.dk@gmail.com',1,'2025-06-10 21:05:17','Invoice Overdue Notice - INV-000058/06/2025'),(355,'91d54629061add83676c70dca5ab4d9d',60,'invoice','2025-06-10 21:05:10','duncankilondk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000058/06/2025'),(356,'cc838b9685f1d80ed2519fe45cca9642',41,'invoice','2025-06-11 21:05:02','nafisa.ahmed@capabuil.com',1,'2025-06-12 09:35:30','Invoice Overdue Notice - INV-000039/02/2025'),(357,'b212e3996b9de4ae53ff68728ecd8645',41,'invoice','2025-06-11 21:05:03','reagan.nyadimo@capabuil.com',1,'2025-06-11 21:05:38','Invoice Overdue Notice - INV-000039/02/2025'),(358,'ac1b56399e23884e49262afce6cee67d',41,'invoice','2025-06-11 21:05:04','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(359,'4a20eecc11b4c751fb0caf2bf7f2403c',45,'invoice','2025-06-11 21:05:05','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(360,'2a88b69b53ed5dd94e25d4d2cdc7120d',45,'invoice','2025-06-11 21:05:07','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(361,'f6a42330195b6abbcc3c9aee567f23f0',45,'invoice','2025-06-11 21:05:09','duncan.kilon.dk@gmail.com',1,'2025-06-11 21:05:16','Invoice Overdue Notice - INV-000043/04/2025'),(362,'801bbd516ba1522a896a3c892b4a89ea',45,'invoice','2025-06-11 21:05:10','duncankilondk@gmail.com',1,'2025-06-11 21:05:29','Invoice Overdue Notice - INV-000043/04/2025'),(363,'af2794d1096e0f78b4496d1e9920808d',54,'invoice','2025-06-11 21:05:11','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(364,'99c9696e8d4b3bf24f6045d28caf7254',54,'invoice','2025-06-11 21:05:12','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(365,'81f00834f8be2e04b14e3e3378c54db8',54,'invoice','2025-06-11 21:05:14','duncan.kilon.dk@gmail.com',1,'2025-06-11 21:05:29','Invoice Overdue Notice - INV-000052/05/2025'),(366,'1af959a7c53bf184ef05682db6411e95',54,'invoice','2025-06-11 21:05:15','duncankilondk@gmail.com',1,'2025-06-11 21:05:22','Invoice Overdue Notice - INV-000052/05/2025'),(367,'f0a98b37e46c7c4d6708ced5e3918b82',60,'invoice','2025-06-12 21:03:04','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000058/06/2025'),(368,'53a132f0c2e673f639a7ae0c7934573e',60,'invoice','2025-06-12 21:03:06','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000058/06/2025'),(369,'e8a157f36a3a4bdf33e929e6af5f835b',60,'invoice','2025-06-12 21:03:07','duncan.kilon.dk@gmail.com',1,'2025-06-12 21:03:32','Invoice Overdue Notice - INV-000058/06/2025'),(370,'46bfba115590d5f01f48478a1d7a4ad5',60,'invoice','2025-06-12 21:03:09','duncankilondk@gmail.com',1,'2025-06-12 21:03:30','Invoice Overdue Notice - INV-000058/06/2025'),(371,'7fdcac6cffe0997bf38b739719e58d4c',41,'invoice','2025-06-13 21:01:03','nafisa.ahmed@capabuil.com',1,'2025-06-16 09:33:16','Invoice Overdue Notice - INV-000039/02/2025'),(372,'a100a56c8cc2f7fba0025104684658fa',41,'invoice','2025-06-13 21:01:03','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(373,'b5c7f5831c8f5081deea5bee71fdbb40',41,'invoice','2025-06-13 21:01:04','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(374,'51fb36871531f8de8c5bc1a24aa5d504',45,'invoice','2025-06-13 21:01:09','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(375,'a5e562ebee5ee04bcc6f1dbc862aa1cd',45,'invoice','2025-06-13 21:01:11','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(376,'92251ea57f84de852a6f6a7bfd4af031',45,'invoice','2025-06-13 21:01:12','duncan.kilon.dk@gmail.com',1,'2025-06-13 21:01:19','Invoice Overdue Notice - INV-000043/04/2025'),(377,'51bb24e34214bcba2f3adfab08ade520',45,'invoice','2025-06-13 21:01:13','duncankilondk@gmail.com',1,'2025-06-13 21:01:23','Invoice Overdue Notice - INV-000043/04/2025'),(378,'0ea260b8f8ae9f51b85101e190f41cd1',54,'invoice','2025-06-13 21:01:14','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(379,'6f75765543515da9f8c7ef006843a03b',54,'invoice','2025-06-13 21:01:16','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(380,'efb493826900e264b8299ddbaeab8550',54,'invoice','2025-06-13 21:01:17','duncan.kilon.dk@gmail.com',1,'2025-06-13 21:01:31','Invoice Overdue Notice - INV-000052/05/2025'),(381,'3ee0514b5b3fe14709c16e0dcec09279',54,'invoice','2025-06-13 21:01:18','duncankilondk@gmail.com',1,'2025-06-13 21:01:29','Invoice Overdue Notice - INV-000052/05/2025'),(382,'8854353505417a829172448d677e2dac',60,'invoice','2025-06-14 21:01:03','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000058/06/2025'),(383,'c2b78ded2cc193004c013ccb67c84c54',60,'invoice','2025-06-14 21:01:04','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000058/06/2025'),(384,'63989059e4060c6a4c048cce9d0205aa',60,'invoice','2025-06-14 21:01:05','duncan.kilon.dk@gmail.com',1,'2025-06-14 21:01:14','Invoice Overdue Notice - INV-000058/06/2025'),(385,'6c50a90d777eee4c602a9b4b1e1a10a7',60,'invoice','2025-06-14 21:01:06','duncankilondk@gmail.com',1,'2025-06-14 21:01:17','Invoice Overdue Notice - INV-000058/06/2025'),(386,'37746a1dd4e3fe1542c0260d109ac687',41,'invoice','2025-06-15 21:02:02','nafisa.ahmed@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(387,'bd80c5094eb85fade2f8089efa9236be',41,'invoice','2025-06-15 21:02:03','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(388,'ad1c849b6eceb731593109c5d4b2e0ce',41,'invoice','2025-06-15 21:02:04','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(389,'383ebb02660be0064531d8194dfdb0ab',45,'invoice','2025-06-15 21:02:05','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(390,'c25d4953f86c6f5862fb65e0216af4de',45,'invoice','2025-06-15 21:02:07','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(391,'0628644c72b501c599bcda5f586720ff',45,'invoice','2025-06-15 21:02:08','duncan.kilon.dk@gmail.com',1,'2025-06-15 21:02:16','Invoice Overdue Notice - INV-000043/04/2025'),(392,'39d985305039a3e95e1b337c1baf1103',45,'invoice','2025-06-15 21:02:09','duncankilondk@gmail.com',1,'2025-06-15 21:02:15','Invoice Overdue Notice - INV-000043/04/2025'),(393,'d9deb3d60baacf6691bc1a436a0effe6',54,'invoice','2025-06-15 21:02:10','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(394,'b24783e9ed7c03dbd611025f4ccb3ade',54,'invoice','2025-06-15 21:02:12','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(395,'6be515f34666352918ac185a3c2d2cce',54,'invoice','2025-06-15 21:02:13','duncan.kilon.dk@gmail.com',1,'2025-06-15 21:02:19','Invoice Overdue Notice - INV-000052/05/2025'),(396,'421119078e86a57e95e95afb36149c8e',54,'invoice','2025-06-15 21:02:14','duncankilondk@gmail.com',1,'2025-06-15 21:02:21','Invoice Overdue Notice - INV-000052/05/2025'),(397,'9d50a9d8b7c4dac7066b9774251ca44f',60,'invoice','2025-06-16 21:00:03','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000058/06/2025'),(398,'b4acb5fe8a8ebacbbc8c89355f1b56e3',60,'invoice','2025-06-16 21:00:06','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000058/06/2025'),(399,'5a635733c190b12088d28529edc083dc',60,'invoice','2025-06-16 21:00:07','duncan.kilon.dk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000058/06/2025'),(400,'273ab0b769e2ddc45fa16643ed3431a1',60,'invoice','2025-06-16 21:00:09','duncankilondk@gmail.com',1,'2025-06-16 21:00:32','Invoice Overdue Notice - INV-000058/06/2025'),(401,'6be4254c2dc48d1d09266eb7aa6e2ec7',41,'invoice','2025-06-17 21:00:02','nafisa.ahmed@capabuil.com',1,'2025-06-18 10:14:12','Invoice Overdue Notice - INV-000039/02/2025'),(402,'a99871018f0a6e806492c9d3e1de41ab',41,'invoice','2025-06-17 21:00:03','reagan.nyadimo@capabuil.com',1,'2025-06-18 17:01:01','Invoice Overdue Notice - INV-000039/02/2025'),(403,'d8f7f63645916e0f9b16a2798698b2bc',41,'invoice','2025-06-17 21:00:04','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(404,'d7d9d69e7720700cd138e39bd7c0c978',45,'invoice','2025-06-17 21:00:05','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(405,'af0783e4a267cb58e99e73d2b938761f',45,'invoice','2025-06-17 21:00:08','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(406,'8bd5db3be8b5dd4fba9d7f495e83a96e',45,'invoice','2025-06-17 21:00:09','duncan.kilon.dk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(407,'fb2911cbc0c5e477544621536b3046c8',45,'invoice','2025-06-17 21:00:10','duncankilondk@gmail.com',1,'2025-06-17 21:00:19','Invoice Overdue Notice - INV-000043/04/2025'),(408,'58c947a041508ee7f9ea39c24403872a',54,'invoice','2025-06-17 21:00:12','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(409,'d5e5f8e7a73247e548f562d4035beee4',54,'invoice','2025-06-17 21:00:13','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(410,'0799cae7fc093f7019daac4d17be22c2',54,'invoice','2025-06-17 21:00:14','duncan.kilon.dk@gmail.com',1,'2025-06-17 21:00:23','Invoice Overdue Notice - INV-000052/05/2025'),(411,'044e03f407fba66cc8436caed7048843',54,'invoice','2025-06-17 21:00:15','duncankilondk@gmail.com',1,'2025-06-17 21:00:24','Invoice Overdue Notice - INV-000052/05/2025'),(412,'ab08c624bc463bf6baea3dec3edf27a8',60,'invoice','2025-06-18 21:03:03','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000058/06/2025'),(413,'d62f74c90b3db20822e4e50ea1fafc8a',60,'invoice','2025-06-18 21:03:06','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000058/06/2025'),(414,'23c8eab0ccbe6b0b5de52fc0f39b3e9d',60,'invoice','2025-06-18 21:03:08','duncan.kilon.dk@gmail.com',1,'2025-06-18 21:03:32','Invoice Overdue Notice - INV-000058/06/2025'),(415,'62295bb2da3c019374d455f0025e2985',60,'invoice','2025-06-18 21:03:09','duncankilondk@gmail.com',1,'2025-06-18 21:03:32','Invoice Overdue Notice - INV-000058/06/2025'),(416,'14f2a4b5e4a4abba3eef3013e3dbc9f2',41,'invoice','2025-06-19 21:04:02','nafisa.ahmed@capabuil.com',1,'2025-06-20 08:26:50','Invoice Overdue Notice - INV-000039/02/2025'),(417,'4b0975a360ac16ab2b9057ffe3fb1951',41,'invoice','2025-06-19 21:04:02','reagan.nyadimo@capabuil.com',1,'2025-06-20 08:36:26','Invoice Overdue Notice - INV-000039/02/2025'),(418,'1cb4db5a31c162a73d422736a7b00668',41,'invoice','2025-06-19 21:04:03','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(419,'9712c12ed365e15b29bd6b64724f06b8',45,'invoice','2025-06-19 21:04:04','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(420,'6219022b5db4a0cf9e8c3fb00cdc1bfa',45,'invoice','2025-06-19 21:04:06','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(421,'55e596ca51d656052bab6e75844f974d',45,'invoice','2025-06-19 21:04:07','duncan.kilon.dk@gmail.com',1,'2025-06-19 21:04:15','Invoice Overdue Notice - INV-000043/04/2025'),(422,'6a512bdeb29bb8d5143b26d6b5e3adc9',45,'invoice','2025-06-19 21:04:08','duncankilondk@gmail.com',1,'2025-06-19 21:04:18','Invoice Overdue Notice - INV-000043/04/2025'),(423,'c7a2bcec53d16b737b61064c5a5cef50',54,'invoice','2025-06-19 21:04:10','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(424,'7b2353ae942dfea624f84e44ae828e0e',54,'invoice','2025-06-19 21:04:11','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(425,'f6b09b52e3529924a19a60ce89070e36',54,'invoice','2025-06-19 21:04:12','duncan.kilon.dk@gmail.com',1,'2025-06-19 21:04:21','Invoice Overdue Notice - INV-000052/05/2025'),(426,'7446dde3e140b05a28d77940abbf496a',54,'invoice','2025-06-19 21:04:13','duncankilondk@gmail.com',1,'2025-06-19 21:04:22','Invoice Overdue Notice - INV-000052/05/2025'),(427,'d9ad1121feeff720e5d6ad58864b7543',60,'invoice','2025-06-20 21:04:04','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000058/06/2025'),(428,'305b341763a84902e12e9ce4b1afdc7c',60,'invoice','2025-06-20 21:04:05','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000058/06/2025'),(429,'af5f4e7476acc10f8448494246020aa7',60,'invoice','2025-06-20 21:04:07','duncan.kilon.dk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000058/06/2025'),(430,'7d1943b522896834dce7aa36b00a6e41',60,'invoice','2025-06-20 21:04:09','duncankilondk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000058/06/2025'),(431,'53a1bb35c081f42c6cd45b3e4d8de6fa',41,'invoice','2025-06-21 21:05:02','nafisa.ahmed@capabuil.com',1,'2025-06-23 09:31:46','Invoice Overdue Notice - INV-000039/02/2025'),(432,'e70c3b5aebd4872dd30d4964d8874f8a',41,'invoice','2025-06-21 21:05:03','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(433,'29b42ca6a462a824e0b851a5af218ae2',41,'invoice','2025-06-21 21:05:04','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(434,'6a7117d4cae054a454ac5f83afbf52f4',45,'invoice','2025-06-21 21:05:05','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(435,'3f29d0aab6d13a99799e3fd96f191c70',45,'invoice','2025-06-21 21:05:06','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(436,'1353f92d558c6253c215553f17f2dce3',45,'invoice','2025-06-21 21:05:08','duncan.kilon.dk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(437,'8902fbd8c5e396f8a3b11c9d2a053be2',45,'invoice','2025-06-21 21:05:09','duncankilondk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(438,'6b320dc6f9dec375c663f6c1daa0da42',54,'invoice','2025-06-21 21:05:10','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(439,'ae8ec6ce1918949328cac278fd09503d',54,'invoice','2025-06-21 21:05:12','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(440,'ede58d30cfe00dc3021e9e2188ef0fd9',54,'invoice','2025-06-21 21:05:13','duncan.kilon.dk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(441,'0188a12d365c48c1cf6227af0486b6b6',54,'invoice','2025-06-21 21:05:14','duncankilondk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(442,'ae7e648b6cc3268cd2ec875940b973f0',60,'invoice','2025-06-22 21:01:07','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000058/06/2025'),(443,'e4dbad77959f936205bed865490fa3c1',60,'invoice','2025-06-22 21:01:09','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000058/06/2025'),(444,'155434634f981a5e3051877209d46a1d',60,'invoice','2025-06-22 21:01:10','duncan.kilon.dk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000058/06/2025'),(445,'3ac33d4c2b2fbc6274e33e625dfff5b0',60,'invoice','2025-06-22 21:01:11','duncankilondk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000058/06/2025'),(446,'ee357ebf7576c4b3ce4ebb021bc4360f',41,'invoice','2025-06-23 21:04:06','nafisa.ahmed@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(447,'2d2679dffd4643adc66af6adee5f2bc9',41,'invoice','2025-06-23 21:04:12','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(448,'2b1a74cd5d61259edfda4868079b08d9',41,'invoice','2025-06-23 21:04:18','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(449,'e7e501f2cf2f432aa37eecb881b707d5',45,'invoice','2025-06-23 21:04:23','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(450,'55e562323e91babd5c4b3a38e5bb4d68',45,'invoice','2025-06-23 21:04:27','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(451,'1599ff03cff97e72377adc894f839495',45,'invoice','2025-06-23 21:04:31','duncan.kilon.dk@gmail.com',1,'2025-06-23 21:04:47','Invoice Overdue Notice - INV-000043/04/2025'),(452,'52a4092c054ed8e63339fe5ae3eecc21',45,'invoice','2025-06-23 21:04:37','duncankilondk@gmail.com',1,'2025-06-23 21:04:51','Invoice Overdue Notice - INV-000043/04/2025'),(453,'10551eeb1795fc0b38f16fe17c0ab98f',54,'invoice','2025-06-23 21:04:41','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(454,'62b201299a60d8901cc3ef31dc6331cf',54,'invoice','2025-06-23 21:04:45','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(455,'48932dd12f06368772e81b3ac69d48b6',54,'invoice','2025-06-23 21:04:49','duncan.kilon.dk@gmail.com',1,'2025-06-23 21:05:03','Invoice Overdue Notice - INV-000052/05/2025'),(456,'f77771200ef90e35565687d1822d676b',54,'invoice','2025-06-23 21:04:53','duncankilondk@gmail.com',1,'2025-06-23 21:05:08','Invoice Overdue Notice - INV-000052/05/2025'),(457,'6d5b76f733a73e8127a3f41e734f8102',60,'invoice','2025-06-24 21:00:08','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000058/06/2025'),(458,'f6658166151166dcfa2dd675c6d04269',60,'invoice','2025-06-24 21:00:13','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000058/06/2025'),(459,'e55060a362883332887e850cde904f0a',60,'invoice','2025-06-24 21:00:17','duncan.kilon.dk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000058/06/2025'),(460,'8b0be16f41a017b7d681dd749ce61c39',60,'invoice','2025-06-24 21:00:21','duncankilondk@gmail.com',1,'2025-06-24 21:01:25','Invoice Overdue Notice - INV-000058/06/2025'),(461,'69c93455fc22f2d8ee9032ff53623800',41,'invoice','2025-06-25 21:01:08','nafisa.ahmed@capabuil.com',1,'2025-06-26 08:47:24','Invoice Overdue Notice - INV-000039/02/2025'),(462,'e2f3c484382227f6c709f4f5833b5e8d',41,'invoice','2025-06-25 21:01:13','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(463,'f7f5cb74a02a03220011dd826d18b6c0',41,'invoice','2025-06-25 21:01:17','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(464,'907c310d71d43b70ebdd286b0f8a7742',45,'invoice','2025-06-25 21:01:21','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(465,'4d1944b7b06cd94ab69e686986a06ce9',45,'invoice','2025-06-25 21:01:25','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(466,'d50ab7e3713ea014591ba4416fac5198',45,'invoice','2025-06-25 21:01:30','duncan.kilon.dk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(467,'b6b2d0b19a03a161afcac85b4fdb1a27',45,'invoice','2025-06-25 21:01:33','duncankilondk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(468,'9f7cd00d9552fc927d40556a3755cc61',54,'invoice','2025-06-25 21:01:38','justinkusola@gmail.com',1,'2025-06-26 17:03:08','Invoice Overdue Notice - INV-000052/05/2025'),(469,'16c27ab63a3d916d7ef03778db086826',54,'invoice','2025-06-25 21:01:42','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(470,'ce4efaf1ea96caf6e5a8285ce718f1dd',54,'invoice','2025-06-25 21:01:46','duncan.kilon.dk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(471,'5bd1b5997219a482ecabf0059562cb08',54,'invoice','2025-06-25 21:01:50','duncankilondk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(472,'d185819605c6055928d199b522509942',60,'invoice','2025-06-26 21:02:10','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000058/06/2025'),(473,'dc16d1dd155209a10be5dca854a2483c',60,'invoice','2025-06-26 21:04:00','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000058/06/2025'),(474,'40e4da0f2e1f317a26e850d5c67c4508',60,'invoice','2025-06-26 21:05:11','duncan.kilon.dk@gmail.com',1,'2025-06-26 23:35:00','Invoice Overdue Notice - INV-000058/06/2025'),(475,'8e30e85b235b22a2567249e3d7dc5694',60,'invoice','2025-06-26 21:06:01','duncankilondk@gmail.com',1,'2025-06-26 23:35:00','Invoice Overdue Notice - INV-000058/06/2025'),(476,'327737addf5aac190195c416cda78fea',41,'invoice','2025-06-27 21:03:05','nafisa.ahmed@capabuil.com',1,'2025-06-27 21:39:30','Invoice Overdue Notice - INV-000039/02/2025'),(477,'cdd7625e00f550d07fe78ef1af39d29b',41,'invoice','2025-06-27 21:03:08','reagan.nyadimo@capabuil.com',1,'2025-06-27 21:39:37','Invoice Overdue Notice - INV-000039/02/2025'),(478,'715e695e6aaf8af5769cb26889d7cd3f',41,'invoice','2025-06-27 21:03:11','mary.ngile@capabuil.com',1,'2025-06-27 21:39:38','Invoice Overdue Notice - INV-000039/02/2025'),(479,'df97cb3f21453b13fee15f8c79a148c1',45,'invoice','2025-06-27 21:03:15','justinkusola@gmail.com',1,'2025-06-27 21:39:14','Invoice Overdue Notice - INV-000043/04/2025'),(480,'8f5ba33a7b72c3521d4cb2d481624fbb',45,'invoice','2025-06-27 21:03:18','gemmotorwash@gmail.com',1,'2025-06-27 21:39:17','Invoice Overdue Notice - INV-000043/04/2025'),(481,'ac66fd7c5c2a6bc8319d183350b30a8e',45,'invoice','2025-06-27 21:03:22','duncan.kilon.dk@gmail.com',1,'2025-06-27 21:04:10','Invoice Overdue Notice - INV-000043/04/2025'),(482,'cafff926d85891b62cef923bbda52dca',45,'invoice','2025-06-27 21:03:25','duncankilondk@gmail.com',1,'2025-06-27 21:04:16','Invoice Overdue Notice - INV-000043/04/2025'),(483,'8b465f9dadcb4a0881d9a9d0f438f8aa',54,'invoice','2025-06-27 21:03:28','justinkusola@gmail.com',1,'2025-06-27 21:39:23','Invoice Overdue Notice - INV-000052/05/2025'),(484,'7d247e994430aed0aa93ba8c1428de6f',54,'invoice','2025-06-27 21:03:32','gemmotorwash@gmail.com',1,'2025-06-27 21:39:25','Invoice Overdue Notice - INV-000052/05/2025'),(485,'1fe6ecac65bdb34a42813a1c8d8a4127',54,'invoice','2025-06-27 21:03:35','duncan.kilon.dk@gmail.com',1,'2025-06-27 21:04:21','Invoice Overdue Notice - INV-000052/05/2025'),(486,'71bd40214d150d9b24ab04cfb2ec35aa',54,'invoice','2025-06-27 21:03:38','duncankilondk@gmail.com',1,'2025-06-27 21:04:29','Invoice Overdue Notice - INV-000052/05/2025'),(487,'3b27acd6a29c61e9cd27f411f9cc2e8d',60,'invoice','2025-06-28 21:01:05','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000058/06/2025'),(488,'eafcb1e93b17c317a1ac6d95807190a9',60,'invoice','2025-06-28 21:01:08','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000058/06/2025'),(489,'0936c1a4f5fa9ee31736a55c233bbd01',60,'invoice','2025-06-28 21:01:11','duncan.kilon.dk@gmail.com',1,'2025-06-28 21:01:59','Invoice Overdue Notice - INV-000058/06/2025'),(490,'18aa9c30eb2ef7e3005bb76c389952ea',60,'invoice','2025-06-28 21:01:15','duncankilondk@gmail.com',1,'2025-06-28 21:02:03','Invoice Overdue Notice - INV-000058/06/2025'),(491,'276efdc4f5c440c407da20af92a06f6a',41,'invoice','2025-06-29 21:00:05','nafisa.ahmed@capabuil.com',1,'2025-06-30 09:38:49','Invoice Overdue Notice - INV-000039/02/2025'),(492,'ec61072a6aba404020c364a07a970c24',41,'invoice','2025-06-29 21:00:08','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(493,'6af59c73c0293b39ed98ac7af7908dfb',41,'invoice','2025-06-29 21:00:12','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(494,'117384dc7448f2a4465dfd6f74588727',45,'invoice','2025-06-29 21:00:15','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(495,'3c6633a35fc572f4aa7dba31efab2588',45,'invoice','2025-06-29 21:00:19','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000043/04/2025'),(496,'647a24b7301801652cc2dcfe464ce39f',45,'invoice','2025-06-29 21:00:22','duncan.kilon.dk@gmail.com',1,'2025-06-29 21:01:10','Invoice Overdue Notice - INV-000043/04/2025'),(497,'98ba89a5184d5b47f1f019ee3b3ac013',45,'invoice','2025-06-29 21:00:25','duncankilondk@gmail.com',1,'2025-06-29 21:01:12','Invoice Overdue Notice - INV-000043/04/2025'),(498,'6c346864ca389119abb12d8018f8dd5d',54,'invoice','2025-06-29 21:00:29','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(499,'038c81f6edd4241d8b62263ff172ea16',54,'invoice','2025-06-29 21:00:32','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000052/05/2025'),(500,'7340131542c0efca6d53e92adceca219',54,'invoice','2025-06-29 21:00:35','duncan.kilon.dk@gmail.com',1,'2025-06-29 21:01:24','Invoice Overdue Notice - INV-000052/05/2025'),(501,'522767cc496390cb3799d4b49667a979',54,'invoice','2025-06-29 21:00:38','duncankilondk@gmail.com',1,'2025-06-29 21:01:25','Invoice Overdue Notice - INV-000052/05/2025'),(502,'3e7dd818b315fc68fabe306833cab42b',41,'invoice','2025-07-01 21:01:05','nafisa.ahmed@capabuil.com',1,'2025-07-02 09:29:33','Invoice Overdue Notice - INV-000039/02/2025'),(503,'05b638bf9d35c83fe3479b3def9d37a4',41,'invoice','2025-07-01 21:01:09','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(504,'889f68fe48cc189e1fbe2e29c34aa0d3',41,'invoice','2025-07-01 21:01:12','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(505,'b2ed3db3ba32bed6460f4c366f3d716a',64,'invoice','2025-07-01 21:01:16','nafisa.ahmed@capabuil.com',0,NULL,'Invoice with number INV-000062/07/2025 created'),(506,'15aea096e94aec618982381b31bb9bbf',64,'invoice','2025-07-01 21:01:19','reagan.nyadimo@capabuil.com',0,NULL,'Invoice with number INV-000062/07/2025 created'),(507,'46af0112eae7ca2c125ed8ec299fa57e',64,'invoice','2025-07-01 21:01:22','mary.ngile@capabuil.com',0,NULL,'Invoice with number INV-000062/07/2025 created'),(508,'37fabc3ef90ebd01737611ac40c37714',41,'invoice','2025-07-03 21:01:05','nafisa.ahmed@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(509,'2d28672e69cf84c9ee75d52dc11e1907',41,'invoice','2025-07-03 21:01:08','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(510,'77aae3fbb5f3a48a6b4d2dad44550de5',41,'invoice','2025-07-03 21:01:12','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(511,'94496f4db627b2e80ccd5ebdc8a977e7',41,'invoice','2025-07-05 21:01:05','nafisa.ahmed@capabuil.com',1,'2025-07-07 09:39:30','Invoice Overdue Notice - INV-000039/02/2025'),(512,'e3bdb79b1cafdeb19a54092a2cf316ef',41,'invoice','2025-07-05 21:01:08','reagan.nyadimo@capabuil.com',1,'2025-07-07 09:53:00','Invoice Overdue Notice - INV-000039/02/2025'),(513,'c7a709896de59c2d9b7ecd788eca6391',41,'invoice','2025-07-05 21:01:11','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(514,'4fdcd90fee40f69c58634120d3937509',41,'invoice','2025-07-07 21:01:06','nafisa.ahmed@capabuil.com',1,'2025-07-08 09:32:56','Invoice Overdue Notice - INV-000039/02/2025'),(515,'0da14655f876212d0a37e35575c278ea',41,'invoice','2025-07-07 21:01:09','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(516,'a9bd2afae37c882f20d7c19f987fb96a',41,'invoice','2025-07-07 21:01:12','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(517,'cfc8039c2ac78fb2b42b6e6073ca97c5',65,'invoice','2025-07-07 21:01:16','info@kerali.co.ke',0,NULL,'Invoice with number INV-000063/07/2025 created'),(518,'6651c7bfbad2919ad6d4d1cb5e86b1c1',66,'invoice','2025-07-07 21:01:20','justinkusola@gmail.com',0,NULL,'Invoice with number INV-000064/07/2025 created'),(519,'3961cd742af6c8894bdaf2823ec8fd22',66,'invoice','2025-07-07 21:01:23','gemmotorwash@gmail.com',0,NULL,'Invoice with number INV-000064/07/2025 created'),(520,'2a5beed27b38df897b4cb5f1fa0919dd',66,'invoice','2025-07-07 21:01:26','duncan.kilon.dk@gmail.com',1,'2025-07-07 21:02:14','Invoice with number INV-000064/07/2025 created'),(521,'12ad114d8fc8193600d8de4451155721',66,'invoice','2025-07-07 21:01:30','duncankilondk@gmail.com',1,'2025-07-07 21:02:19','Invoice with number INV-000064/07/2025 created'),(522,'ba224754cf4f23b18720f07c43ad62c2',67,'invoice','2025-07-07 21:01:33','kilakitukazi@gmail.com',0,NULL,'Invoice with number INV-000065/07/2025 created'),(523,'a4f3d49767c2f03c461659b7e1333df3',66,'invoice','2025-07-08 21:04:06','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000064/07/2025'),(524,'040f1f06412f0068c43e41798de71d0b',66,'invoice','2025-07-08 21:04:09','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000064/07/2025'),(525,'6aa0e6cdd79e05b2f48ca2c430306012',66,'invoice','2025-07-08 21:04:12','duncan.kilon.dk@gmail.com',1,'2025-07-08 21:05:02','Invoice Overdue Notice - INV-000064/07/2025'),(526,'044c439135d2e527c58f856370433ec8',66,'invoice','2025-07-08 21:04:16','duncankilondk@gmail.com',1,'2025-07-08 21:05:03','Invoice Overdue Notice - INV-000064/07/2025'),(527,'7fd4640a2d310f5210bd2f75b660c13b',68,'invoice','2025-07-08 21:04:19','namvuyavivian@gmail.com',0,NULL,'Invoice with number INV-000066/07/2025 created'),(528,'21e7ee4127db1524e0e4c0b8ce6dcb25',41,'invoice','2025-07-09 21:05:05','nafisa.ahmed@capabuil.com',1,'2025-07-10 10:17:47','Invoice Overdue Notice - INV-000039/02/2025'),(529,'4f1f8b5f942aaafc84c21fc63fff98d5',41,'invoice','2025-07-09 21:05:09','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(530,'756779c19a38b52512f5e05906753b60',41,'invoice','2025-07-09 21:05:12','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(531,'61e6a3efbd3b4a43482dbf8982a81674',66,'invoice','2025-07-10 21:03:05','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000064/07/2025'),(532,'9ee7cacb2cfe27d3a798ba3012516a07',66,'invoice','2025-07-10 21:03:08','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000064/07/2025'),(533,'e448efdd4da1f77caa62e8fb7aee6393',66,'invoice','2025-07-10 21:03:12','duncan.kilon.dk@gmail.com',1,'2025-07-10 21:04:01','Invoice Overdue Notice - INV-000064/07/2025'),(534,'289547b3e254f55892b0cfbe41136b07',66,'invoice','2025-07-10 21:03:15','duncankilondk@gmail.com',1,'2025-07-10 21:04:04','Invoice Overdue Notice - INV-000064/07/2025'),(535,'cab5404c4a1c83811a58f5aca86ed62e',41,'invoice','2025-07-11 21:01:07','nafisa.ahmed@capabuil.com',1,'2025-07-14 09:22:43','Invoice Overdue Notice - INV-000039/02/2025'),(536,'4b4552d1eca1bd73b38c1f1501264900',41,'invoice','2025-07-11 21:01:11','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(537,'d9a3573b3a9ee7e8138690b4fe32a8ee',41,'invoice','2025-07-11 21:01:14','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(538,'d8f1ce9199255ec6fec6eaf6a44c8463',66,'invoice','2025-07-12 21:04:05','justinkusola@gmail.com',1,'2025-07-12 22:43:31','Invoice Overdue Notice - INV-000064/07/2025'),(539,'de6d8e4d2dd2f74a712e9859e78fc9b0',66,'invoice','2025-07-12 21:04:09','gemmotorwash@gmail.com',1,'2025-07-12 22:43:27','Invoice Overdue Notice - INV-000064/07/2025'),(540,'b7f608be4d915bc5a818ab265b887900',66,'invoice','2025-07-12 21:04:12','duncan.kilon.dk@gmail.com',1,'2025-07-12 21:05:00','Invoice Overdue Notice - INV-000064/07/2025'),(541,'c3a3e66f6924c68c160bcca316b5253a',66,'invoice','2025-07-12 21:04:15','duncankilondk@gmail.com',1,'2025-07-12 21:05:04','Invoice Overdue Notice - INV-000064/07/2025'),(542,'2c35f312ae9e670ae2263f1df2da73d1',41,'invoice','2025-07-13 21:05:05','nafisa.ahmed@capabuil.com',1,'2025-07-14 09:23:06','Invoice Overdue Notice - INV-000039/02/2025'),(543,'1b9774191c8a14eab22c3da9146aae34',41,'invoice','2025-07-13 21:05:08','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(544,'9bbad2057343c8cdd413af5bc9942d20',41,'invoice','2025-07-13 21:05:12','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(545,'be1b9c7bef0d082d0ee0d0ee2f1c26db',66,'invoice','2025-07-14 21:05:05','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000064/07/2025'),(546,'0458e952bebbe6c855033c5a64692949',66,'invoice','2025-07-14 21:05:08','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000064/07/2025'),(547,'86b744e659f1b431dc9a97704126cde1',66,'invoice','2025-07-14 21:05:12','duncan.kilon.dk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000064/07/2025'),(548,'ce15ee158579bcc9696c92bfb03428af',66,'invoice','2025-07-14 21:05:15','duncankilondk@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000064/07/2025'),(549,'6d47f582129ddc3e8eb880e09883ad30',41,'invoice','2025-07-15 21:00:06','nafisa.ahmed@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(550,'628e9c4fc38ac35bf6ba2284f473288b',41,'invoice','2025-07-15 21:00:09','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(551,'e698ba863431b8ae13d40e6800af1352',41,'invoice','2025-07-15 21:00:13','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(552,'2562d7e25742057fc964ce1a9e72c371',66,'invoice','2025-07-16 21:03:05','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000064/07/2025'),(553,'5df5552b5938a34cc0bc562963babe21',66,'invoice','2025-07-16 21:03:08','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000064/07/2025'),(554,'2208d4ddde169333f4283ca3a35228f3',66,'invoice','2025-07-16 21:03:12','duncan.kilon.dk@gmail.com',1,'2025-07-16 21:04:01','Invoice Overdue Notice - INV-000064/07/2025'),(555,'7af15e36ab727001932429d9247cf237',66,'invoice','2025-07-16 21:03:15','duncankilondk@gmail.com',1,'2025-07-16 21:04:05','Invoice Overdue Notice - INV-000064/07/2025'),(556,'f104703370416630f479669af7d66ee7',41,'invoice','2025-07-17 21:03:05','nafisa.ahmed@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(557,'d7a33ec19ce67dbef8e2dbd2cb6348e3',41,'invoice','2025-07-17 21:03:09','reagan.nyadimo@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(558,'35f44d7fe198e2d10bab99f1c65a5fee',41,'invoice','2025-07-17 21:03:12','mary.ngile@capabuil.com',0,NULL,'Invoice Overdue Notice - INV-000039/02/2025'),(559,'b5b692e439812978179192b4445a3b79',66,'invoice','2025-07-18 21:00:06','justinkusola@gmail.com',1,'2025-07-20 10:21:46','Invoice Overdue Notice - INV-000064/07/2025'),(560,'f6b79ae75f6c00c1e6f07f56e62a7f03',66,'invoice','2025-07-18 21:00:09','gemmotorwash@gmail.com',1,'2025-07-20 10:21:42','Invoice Overdue Notice - INV-000064/07/2025'),(561,'a4d0bc4dca979dacf7f90e60befe5b42',66,'invoice','2025-07-18 21:00:12','duncan.kilon.dk@gmail.com',1,'2025-07-18 21:01:13','Invoice Overdue Notice - INV-000064/07/2025'),(562,'70f5484501b7258a27d42be851e97b5a',66,'invoice','2025-07-18 21:00:15','duncankilondk@gmail.com',1,'2025-07-18 21:01:14','Invoice Overdue Notice - INV-000064/07/2025'),(563,'76174c858ed12b66c6ba5f4a4dc67d1a',41,'invoice','2025-07-19 21:02:06','nafisa.ahmed@capabuil.com',1,'2025-07-20 10:21:27','Invoice Overdue Notice - INV-000039/02/2025'),(564,'8ab7fdaeafe8090615116bd818d3911f',41,'invoice','2025-07-19 21:02:09','reagan.nyadimo@capabuil.com',1,'2025-07-20 10:21:32','Invoice Overdue Notice - INV-000039/02/2025'),(565,'476913947972d81a0749b6c9ae8026e2',41,'invoice','2025-07-19 21:02:12','mary.ngile@capabuil.com',1,'2025-07-20 10:21:34','Invoice Overdue Notice - INV-000039/02/2025'),(566,'ba701f74b7950b7fa4715c53b7466781',66,'invoice','2025-07-20 21:02:05','justinkusola@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000064/07/2025'),(567,'45e1cdf1332a951393db12920e04427e',66,'invoice','2025-07-20 21:02:09','gemmotorwash@gmail.com',0,NULL,'Invoice Overdue Notice - INV-000064/07/2025'),(568,'317315ed1c8fe32943153f575f0d0759',66,'invoice','2025-07-20 21:02:12','duncan.kilon.dk@gmail.com',1,'2025-07-20 21:03:03','Invoice Overdue Notice - INV-000064/07/2025'),(569,'cd27dd3cf58b000b03d66091885579d2',66,'invoice','2025-07-20 21:02:15','duncankilondk@gmail.com',1,'2025-07-20 21:03:04','Invoice Overdue Notice - INV-000064/07/2025'),(570,'0eecd25c00ee72c3f9e36639de2622ea',41,'invoice','2025-07-21 21:04:05','nafisa.ahmed@capabuil.com',1,'2025-07-22 11:15:11','Invoice Overdue Notice - INV-000039/02/2025'),(571,'1fd8669badabca66cc69d5287b910ff8',41,'invoice','2025-07-21 21:04:08','reagan.nyadimo@capabuil.com',1,'2025-07-22 11:15:08','Invoice Overdue Notice - INV-000039/02/2025'),(572,'73e20c543ac1d27cc358c9ba89282f62',41,'invoice','2025-07-21 21:04:12','mary.ngile@capabuil.com',1,'2025-07-22 11:15:14','Invoice Overdue Notice - INV-000039/02/2025');

--
-- Table structure for table `tbltraining_allocation`
--

CREATE TABLE `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 `tbltraining_allocation`
--


--
-- Table structure for table `tbltransfer_records_reception`
--

CREATE TABLE `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 `tbltransfer_records_reception`
--


--
-- Table structure for table `tbltwocheckout_log`
--

CREATE TABLE `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 `tbltwocheckout_log_ibfk_1` FOREIGN KEY (`invoice_id`) REFERENCES `tblinvoices` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbltwocheckout_log`
--


--
-- Table structure for table `tbluser_auto_login`
--

CREATE TABLE `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 `tbluser_auto_login`
--

INSERT INTO `tbluser_auto_login` VALUES ('d15e02e185746b7f6e4977e9b7f0852b',3,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36','102.0.16.20','2025-01-07 07:29:37',1),('bb80c4c4382cda8e82e354f86d679bcd',6,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36','80.240.201.164','2025-01-08 07:51:19',1),('10f63e97abcb8931188bd21bfca37e8e',5,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36','80.240.201.173','2025-01-16 19:33:40',1),('ecbd8fadd67836e8d841d1c2cb3f9cfa',13,'Mozilla/5.0 (iPhone; CPU iPhone OS 18_2_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.2 Mobile/15E148 Safari/604.1','172.225.119.194','2025-01-18 10:07:55',0),('f7f0437b8a221f592c7d965894781b10',3,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36 Edg/132.0.0.0','197.248.72.93','2025-01-29 16:27:06',1),('b83c14706e11d74095bbd55e011fc5f1',3,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36','197.248.72.93','2025-02-14 05:55:23',1),('4ae45675be2ceefad570f05835f5872d',51,'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Mobile Safari/537.36','41.80.112.172','2025-03-12 07:24:19',0),('ebd1abb71d88fe7bc131cf5649ef8752',9,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36','197.248.72.93','2025-03-25 18:24:31',1),('d57406681d39fa12258d40a046bfc3d2',9,'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','197.248.72.93','2025-04-13 10:13:46',1),('a715aaa189bc0ae88b87b624bcf2f965',3,'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:137.0) Gecko/20100101 Firefox/137.0','41.212.30.161','2025-04-17 03:55:33',0),('88444d599fcd70ebe9d4af98ef570eeb',54,'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/27.0 Chrome/125.0.0.0 Mobile Safari/537.36','105.163.0.40','2025-04-17 07:15:07',0),('2abf687b85a61f830bf5e46557303749',3,'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','197.248.72.93','2025-04-18 21:52:47',1),('ae9f7bb7a17e7ddf8dab2883b17d3f99',3,'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','197.248.43.21','2025-04-22 09:26:54',1),('db5d4808397d42302d040c0e0858a48b',9,'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','197.248.43.21','2025-04-24 12:01:30',1),('2c9c6c5cd6510154798de7103abb7015',3,'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','197.248.43.21','2025-04-29 15:12:49',1),('2536d7a7d90f16ff1bc088bede37f1a9',3,'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','197.248.72.93','2025-05-05 17:18:49',1),('a6477db6571c81bfd1e93016c1b404f1',3,'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','197.248.49.195','2025-05-07 10:51:37',1),('c2bc38e21ba657541c3ae583c6227884',3,'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36','197.248.72.93','2025-05-07 16:13:54',1),('4ec795d28e03439a9616f7e3b394e474',3,'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36','197.248.72.93','2025-05-11 14:21:13',1),('dad2bca13bdbedc5fbc936b69fdccb8c',3,'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36','197.248.49.195','2025-05-19 14:22:13',1),('fdea1076e0131289e11e98ef90210c8f',3,'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36','197.248.49.195','2025-05-22 08:13:31',1);

--
-- Table structure for table `tbluser_meta`
--

CREATE TABLE `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 AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbluser_meta`
--

INSERT INTO `tbluser_meta` VALUES (1,0,0,1,'consent_key','8b533a0a3d0acd528eed7733ef13a894-7a6ea45e75c0528530870caa9245b3d8'),(2,0,0,2,'consent_key','a8431e03a68b8f41c6c0aa775ed6b356-e01f39a64108895c8333b7e1d257d4e9'),(3,0,0,3,'consent_key','1c1c453a2933c4b127c6511e0c3fe359-38d5e798a5ebb8a69a68719f78cd5fff'),(4,0,0,4,'consent_key','8be464f69726a1f7bcae66470e71731b-91e263c649f42594a658808d49ab00b4'),(9,0,0,9,'consent_key','84fb19054a6c499401de04e7651115e4-42b2bbaea3e070c2130db8ba41552812'),(10,0,0,10,'consent_key','99dd443fafe7c614436b3aeaa1449fcd-13eadf34566333d9d83e6817382eb77b'),(13,0,0,13,'consent_key','1e57fc2df3d452e51884b20dfea7999b-aee536e3be1fe914e519b35af2ca58ee'),(15,2,0,0,'recent_searches','[\"demo\"]'),(18,0,0,34,'consent_key','1992013493f050743def9f81519c1084-b23ef7db43368e6e4beb908447892584'),(19,0,0,35,'consent_key','2f907dc46e8275c0b3b22a2f0189a07d-b262554aaf38f426311dcf5438b056e0'),(20,0,0,36,'consent_key','ce072d1c1d43ad880bfb1336361ec890-617fc39797736ec41581568d4236cf19'),(21,0,0,37,'consent_key','bb14e682184d555ed7a5b718373a1487-4a61dcb3f50d0ac729c092b11a364f77'),(22,0,0,38,'consent_key','063a20e606d4b900bbe35a62e047573c-07338eadb809717c9d86194215e1dd56'),(23,0,0,39,'consent_key','a3e46dfef8c902fd00d2cb438375fdcb-65e23868a2518f242aa9f04a831a3657'),(25,0,0,41,'consent_key','66e29850c597dcaab01ae6a6409c1e56-c0549d2758d916b4270dc68d085989b4'),(26,0,0,42,'consent_key','fd0d5bc8a2118c655f8a76fee68e1d9d-c5cf03fac8c45a988232d40d49840c52'),(28,0,0,44,'consent_key','bd163945bf925d4404fed1c8fcf38cea-932efccb5520cd7c8a9a21b517c2e5ca'),(29,0,0,45,'consent_key','a8439f0d8b379b2624827bbfbd81e60d-e61860fda415925b8c1b7b865bc83f3d'),(30,0,0,46,'consent_key','4b5c186f34161162be2b83a1e1abc8d8-3e2dc314e408dbbb29e385630f19d327'),(31,0,0,47,'consent_key','e86eebb383d2767901bdb5a46a9e0378-1d3fff3693f9f05b9d38f8c79600b37b'),(32,0,0,48,'consent_key','4dcde5d50a1cd292d9c699b4416e44e3-fc7d710b914c7cead6e56e0367ce9681'),(33,0,0,49,'consent_key','b3a42726f0ab8a2c89fc100bd871e4d6-deeea966d84ba14067116a9e00967b74'),(34,0,0,50,'consent_key','9327abfd0017b8c32435e72052b425f3-8f287c8f34bf1ee31c266dc2b6c54c91'),(35,0,0,51,'consent_key','9e5297762b8c35a5608cd0ef9d8f9450-70c6990cca310475572a7edd54fbb5ae'),(36,0,0,52,'consent_key','5b5abcf402a4de977fdb58a80dafe27d-0fd0dc0c124343eb0755f805bc76c8cd'),(38,4,0,0,'recent_searches','[\"payroll\"]'),(39,0,0,54,'consent_key','b5d2646b2fb89331056c5f62906c925f-9a2cb11b539ed04dc3beba85c0dde78d'),(41,0,0,56,'consent_key','04700053518e7d12cc4c9f9aed788419-3efb541d9dfb5f02a864dd05d1357ca5'),(42,1,0,0,'recent_searches','[\"journal\",\"journals\"]');

--
-- Table structure for table `tblvault`
--

CREATE TABLE `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 `tblvault`
--


--
-- Table structure for table `tblviews_tracking`
--

CREATE TABLE `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 AUTO_INCREMENT=162 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblviews_tracking`
--

INSERT INTO `tblviews_tracking` VALUES (3,13,'invoice','2025-01-29 12:54:42','102.22.213.122'),(8,18,'invoice','2025-02-18 12:58:30','102.22.213.122'),(9,18,'invoice','2025-02-21 10:49:40','102.22.213.122'),(10,18,'invoice','2025-02-27 18:26:49','105.163.2.133'),(11,35,'invoice','2025-03-03 11:37:10','197.248.58.35'),(12,35,'invoice','2025-03-03 14:52:38','197.248.58.35'),(13,35,'invoice','2025-03-04 09:55:53','197.248.58.35'),(14,35,'invoice','2025-03-04 11:28:25','197.237.28.84'),(15,35,'invoice','2025-03-05 09:26:19','197.248.58.35'),(16,1,'invoice','2025-03-05 15:21:37','105.163.156.76'),(17,35,'invoice','2025-03-06 10:51:42','197.248.58.35'),(18,40,'invoice','2025-03-10 13:10:45','197.248.89.117'),(19,35,'invoice','2025-03-18 10:25:04','197.248.58.35'),(20,17,'invoice','2025-03-18 11:23:47','105.163.156.67'),(21,41,'invoice','2025-03-21 09:11:42','197.237.28.84'),(22,48,'invoice','2025-04-10 03:13:00','43.157.156.190'),(23,48,'invoice','2025-04-11 16:52:13','197.248.104.241'),(24,47,'invoice','2025-04-14 13:25:32','102.219.210.222'),(25,48,'invoice','2025-04-14 23:15:33','43.130.100.35'),(26,1,'kb_article','2025-04-17 06:30:18','20.171.207.203'),(27,2,'kb_article','2025-04-17 06:30:37','20.171.207.203'),(28,41,'invoice','2025-04-17 06:55:07','41.212.30.161'),(29,1,'kb_article','2025-04-18 18:54:11','102.219.210.222'),(30,2,'kb_article','2025-04-18 18:54:14','102.219.210.222'),(31,1,'kb_article','2025-04-19 19:52:35','85.208.96.204'),(32,2,'kb_article','2025-04-20 02:43:57','185.191.171.7'),(33,1,'kb_article','2025-04-21 11:17:23','43.153.19.83'),(34,2,'kb_article','2025-04-21 11:27:20','43.153.54.138'),(35,1,'kb_article','2025-04-23 18:02:02','195.191.219.130'),(36,2,'kb_article','2025-04-23 18:02:03','195.191.219.130'),(37,1,'kb_article','2025-04-25 18:11:25','216.244.66.238'),(38,2,'kb_article','2025-04-25 21:49:08','124.156.226.179'),(39,1,'kb_article','2025-04-25 21:57:45','43.166.142.76'),(40,3,'kb_article','2025-04-25 22:07:37','43.133.14.237'),(41,5,'kb_article','2025-04-25 22:17:53','170.106.180.139'),(42,4,'kb_article','2025-04-25 22:35:31','49.51.243.156'),(43,2,'kb_article','2025-04-26 04:28:11','216.244.66.238'),(44,4,'kb_article','2025-04-27 12:37:45','216.244.66.238'),(45,3,'kb_article','2025-04-28 01:00:32','216.244.66.238'),(46,5,'kb_article','2025-04-28 06:08:33','216.244.66.238'),(47,2,'kb_article','2025-04-29 07:09:27','216.244.66.238'),(48,2,'kb_article','2025-05-01 11:58:37','43.153.73.200'),(49,5,'kb_article','2025-05-01 12:08:20','43.157.95.239'),(50,1,'kb_article','2025-05-01 12:15:23','43.156.168.214'),(51,3,'kb_article','2025-05-01 12:26:03','170.106.165.186'),(52,4,'kb_article','2025-05-01 12:35:08','43.130.47.33'),(53,1,'kb_article','2025-05-01 18:56:04','57.129.81.226'),(54,2,'kb_article','2025-05-01 18:56:15','57.129.81.226'),(55,3,'kb_article','2025-05-01 18:57:30','57.129.81.152'),(56,5,'kb_article','2025-05-01 18:57:33','75.119.136.70'),(57,4,'kb_article','2025-05-01 19:00:07','57.129.81.226'),(58,52,'invoice','2025-05-02 09:44:54','41.90.172.83'),(59,52,'invoice','2025-05-02 12:54:11','41.90.172.83'),(60,52,'invoice','2025-05-02 14:01:15','41.90.172.83'),(61,1,'kb_article','2025-05-03 18:08:44','204.137.14.68'),(62,5,'kb_article','2025-05-03 18:09:50','204.137.14.68'),(63,3,'kb_article','2025-05-09 09:30:16','85.208.96.193'),(64,4,'kb_article','2025-05-09 15:16:34','85.208.96.208'),(65,5,'kb_article','2025-05-09 16:20:03','85.208.96.205'),(66,57,'invoice','2025-05-10 02:30:11','43.155.195.141'),(67,5,'kb_article','2025-05-10 21:13:48','81.209.177.145'),(68,3,'kb_article','2025-05-10 21:13:57','81.209.177.145'),(69,1,'kb_article','2025-05-10 21:14:09','81.209.177.145'),(70,2,'kb_article','2025-05-10 21:14:19','81.209.177.145'),(71,4,'kb_article','2025-05-10 21:14:29','81.209.177.145'),(72,5,'kb_article','2025-05-11 03:43:37','43.153.10.13'),(73,1,'kb_article','2025-05-11 03:50:57','43.153.19.83'),(74,3,'kb_article','2025-05-11 03:59:27','43.133.220.37'),(75,2,'kb_article','2025-05-11 04:16:10','43.134.186.61'),(76,4,'kb_article','2025-05-11 04:19:55','43.135.186.135'),(77,1,'kb_article','2025-05-12 05:31:41','44.215.235.20'),(78,4,'kb_article','2025-05-12 10:00:22','50.16.72.185'),(79,3,'kb_article','2025-05-12 10:16:54','54.209.100.30'),(80,5,'kb_article','2025-05-12 20:59:42','98.83.10.183'),(81,2,'kb_article','2025-05-12 23:18:16','34.206.249.188'),(82,1,'kb_article','2025-05-17 11:46:15','43.153.135.208'),(83,2,'kb_article','2025-05-17 11:53:10','162.62.132.25'),(84,5,'kb_article','2025-05-17 12:03:38','43.166.134.47'),(85,4,'kb_article','2025-05-17 12:14:29','43.159.141.150'),(86,3,'kb_article','2025-05-17 12:23:22','170.106.143.6'),(87,1,'kb_article','2025-05-21 20:36:30','43.153.119.119'),(88,2,'kb_article','2025-05-21 20:46:25','43.159.136.201'),(89,5,'kb_article','2025-05-21 20:57:28','49.51.243.156'),(90,4,'kb_article','2025-05-21 21:08:36','170.106.163.48'),(91,4,'kb_article','2025-05-24 23:28:01','109.123.251.96'),(92,5,'kb_article','2025-05-24 23:28:10','109.123.251.96'),(93,3,'kb_article','2025-05-24 23:28:19','109.123.251.96'),(94,1,'kb_article','2025-05-24 23:28:22','109.123.251.96'),(95,2,'kb_article','2025-05-24 23:28:31','109.123.251.96'),(96,4,'kb_article','2025-05-27 03:33:11','170.106.193.108'),(97,3,'kb_article','2025-05-27 03:43:24','43.157.153.236'),(98,2,'kb_article','2025-05-27 03:52:46','43.157.170.126'),(99,5,'kb_article','2025-05-27 04:04:22','43.166.129.247'),(100,1,'kb_article','2025-05-27 04:12:13','43.157.188.74'),(101,1,'kb_article','2025-05-31 23:30:57','43.135.139.165'),(102,4,'kb_article','2025-05-31 23:40:25','43.131.253.14'),(103,2,'kb_article','2025-05-31 23:49:37','43.156.156.96'),(104,5,'kb_article','2025-06-01 00:00:33','43.130.12.43'),(105,3,'kb_article','2025-06-01 00:11:26','43.153.123.3'),(106,3,'kb_article','2025-06-06 09:48:11','43.166.245.120'),(107,1,'kb_article','2025-06-06 09:57:03','43.157.149.188'),(108,4,'kb_article','2025-06-06 10:08:12','43.135.145.73'),(109,2,'kb_article','2025-06-06 10:18:55','119.28.177.175'),(110,5,'kb_article','2025-06-06 10:28:23','43.135.144.81'),(111,59,'invoice','2025-06-11 10:18:56','102.209.76.52'),(112,2,'kb_article','2025-06-11 10:30:13','43.153.71.132'),(113,5,'kb_article','2025-06-11 10:39:10','43.159.152.187'),(114,1,'kb_article','2025-06-11 10:50:29','43.131.39.179'),(115,4,'kb_article','2025-06-11 11:00:13','43.166.239.145'),(116,1,'kb_article','2025-06-13 02:44:52','20.171.207.186'),(117,5,'kb_article','2025-06-13 02:44:55','20.171.207.186'),(118,3,'kb_article','2025-06-13 02:44:59','20.171.207.186'),(119,4,'kb_article','2025-06-13 02:45:01','20.171.207.186'),(120,2,'kb_article','2025-06-13 02:45:05','20.171.207.186'),(121,1,'kb_article','2025-06-15 20:37:06','43.153.10.13'),(122,3,'kb_article','2025-06-15 20:50:25','49.51.233.46'),(123,4,'kb_article','2025-06-15 20:56:57','162.62.213.187'),(124,2,'kb_article','2025-06-15 21:08:26','43.173.1.57'),(125,5,'kb_article','2025-06-15 21:18:02','43.157.22.57'),(126,1,'kb_article','2025-06-20 21:14:48','43.167.239.66'),(127,2,'kb_article','2025-06-20 21:22:48','43.135.130.202'),(128,5,'kb_article','2025-06-20 21:36:26','43.153.54.14'),(129,54,'invoice','2025-06-24 12:08:57','102.219.210.222'),(130,41,'invoice','2025-06-24 12:09:29','102.219.210.222'),(131,1,'kb_article','2025-06-25 21:10:55','43.153.96.79'),(132,2,'kb_article','2025-06-25 21:22:54','170.106.163.84'),(133,5,'kb_article','2025-06-25 21:28:20','43.135.135.57'),(134,4,'kb_article','2025-06-25 21:36:38','43.135.139.165'),(135,3,'kb_article','2025-06-25 21:48:25','150.109.230.210'),(136,3,'kb_article','2025-07-01 00:45:39','49.51.36.179'),(137,2,'kb_article','2025-07-01 00:55:47','43.157.158.178'),(138,5,'kb_article','2025-07-01 01:05:43','43.157.170.13'),(139,1,'kb_article','2025-07-01 01:15:17','43.153.119.119'),(140,4,'kb_article','2025-07-01 01:25:12','162.62.213.165'),(141,65,'invoice','2025-07-07 22:25:59','102.219.210.222'),(142,1,'kb_article','2025-07-11 04:33:29','43.157.170.126'),(143,4,'kb_article','2025-07-11 04:46:34','170.106.152.218'),(144,3,'kb_article','2025-07-11 04:54:07','43.153.107.22'),(145,2,'kb_article','2025-07-11 05:05:05','43.166.129.247'),(146,5,'kb_article','2025-07-11 05:14:05','43.135.183.82'),(147,41,'invoice','2025-07-12 19:51:18','197.237.24.70'),(148,1,'kb_article','2025-07-15 23:51:13','43.153.7.191'),(149,2,'kb_article','2025-07-16 00:00:54','43.157.179.227'),(150,5,'kb_article','2025-07-16 00:11:46','43.135.139.165'),(151,3,'kb_article','2025-07-16 00:21:24','43.166.244.192'),(152,4,'kb_article','2025-07-16 00:31:51','101.33.66.34'),(153,1,'kb_article','2025-07-17 05:55:08','20.171.207.17'),(154,5,'kb_article','2025-07-17 05:55:10','20.171.207.17'),(155,3,'kb_article','2025-07-17 05:55:12','20.171.207.17'),(156,4,'kb_article','2025-07-17 05:55:16','20.171.207.17'),(157,1,'kb_article','2025-07-20 20:43:46','43.153.10.13'),(158,2,'kb_article','2025-07-20 20:54:55','43.130.16.140'),(159,5,'kb_article','2025-07-20 21:04:27','49.51.178.45'),(160,4,'kb_article','2025-07-20 21:15:25','43.130.12.43'),(161,3,'kb_article','2025-07-20 21:30:16','43.130.131.18');

--
-- Table structure for table `tblware_body_type`
--

CREATE TABLE `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 `tblware_body_type`
--


--
-- Table structure for table `tblware_color`
--

CREATE TABLE `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 `tblware_color`
--


--
-- Table structure for table `tblware_commodity_type`
--

CREATE TABLE `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 `tblware_commodity_type`
--


--
-- Table structure for table `tblware_size_type`
--

CREATE TABLE `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 `tblware_size_type`
--


--
-- Table structure for table `tblware_style_type`
--

CREATE TABLE `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 `tblware_style_type`
--


--
-- Table structure for table `tblware_unit_type`
--

CREATE TABLE `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,
  `category_id` int DEFAULT NULL,
  `unit_measure_type` varchar(100) DEFAULT 'reference',
  `bigger_ratio` decimal(15,5) DEFAULT '0.00000',
  `smaller_ratio` decimal(15,5) DEFAULT '0.00000',
  `rounding` decimal(15,5) DEFAULT '0.00000',
  PRIMARY KEY (`unit_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tblware_unit_type`
--


--
-- Table structure for table `tblwarehouse`
--

CREATE TABLE `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 `tblwarehouse`
--


--
-- Table structure for table `tblweb_to_lead`
--

CREATE TABLE `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 `tblweb_to_lead`
--


--
-- Table structure for table `tblwh_activity_log`
--

CREATE TABLE `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 `tblwh_activity_log`
--


--
-- Table structure for table `tblwh_approval_details`
--

CREATE TABLE `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 `tblwh_approval_details`
--


--
-- Table structure for table `tblwh_approval_setting`
--

CREATE TABLE `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 `tblwh_approval_setting`
--


--
-- Table structure for table `tblwh_brand`
--

CREATE TABLE `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 `tblwh_brand`
--


--
-- Table structure for table `tblwh_custom_fields`
--

CREATE TABLE `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 `tblwh_custom_fields`
--


--
-- Table structure for table `tblwh_goods_delivery_activity_log`
--

CREATE TABLE `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 `tblwh_goods_delivery_activity_log`
--


--
-- Table structure for table `tblwh_inventory_serial_numbers`
--

CREATE TABLE `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 `tblwh_inventory_serial_numbers`
--


--
-- Table structure for table `tblwh_loss_adjustment`
--

CREATE TABLE `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 `tblwh_loss_adjustment`
--


--
-- Table structure for table `tblwh_loss_adjustment_detail`
--

CREATE TABLE `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 `tblwh_loss_adjustment_detail`
--


--
-- Table structure for table `tblwh_model`
--

CREATE TABLE `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 `tblwh_model`
--


--
-- Table structure for table `tblwh_omni_shipments`
--

CREATE TABLE `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 `tblwh_omni_shipments`
--


--
-- Table structure for table `tblwh_order_return_details`
--

CREATE TABLE `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 `tblwh_order_return_details`
--


--
-- Table structure for table `tblwh_order_returns`
--

CREATE TABLE `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 `tblwh_order_returns`
--


--
-- Table structure for table `tblwh_order_returns_refunds`
--

CREATE TABLE `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 `tblwh_order_returns_refunds`
--


--
-- Table structure for table `tblwh_packing_list_details`
--

CREATE TABLE `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 `tblwh_packing_list_details`
--


--
-- Table structure for table `tblwh_packing_lists`
--

CREATE TABLE `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 `tblwh_packing_lists`
--


--
-- Table structure for table `tblwh_series`
--

CREATE TABLE `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 `tblwh_series`
--


--
-- Table structure for table `tblwh_staff_warehouses`
--

CREATE TABLE `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 `tblwh_staff_warehouses`
--


--
-- Table structure for table `tblwh_sub_group`
--

CREATE TABLE `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 `tblwh_sub_group`
--



