(2627,'estimate','estimate-thank-you-to-customer','polish','Thank You Email (Sent to Customer After Accept) [polish]','Thank for you accepting estimate','','{companyname} | CRM',NULL,0,1,0),(2628,'tasks','task-deadline-notification','polish','Task Deadline Reminder - Sent to Assigned Members [polish]','Task Deadline Reminder','','{companyname} | CRM',NULL,0,1,0),(2629,'contract','send-contract','polish','Send Contract to Customer [polish]','Contract - {contract_subject}','','{companyname} | CRM',NULL,0,1,0),(2630,'invoice','invoice-payment-recorded-to-staff','polish','Invoice Payment Recorded (Sent to Staff) [polish]','New Invoice Payment','','{companyname} | CRM',NULL,0,1,0),(2631,'ticket','auto-close-ticket','polish','Auto Close Ticket [polish]','Ticket Auto Closed','','{companyname} | CRM',NULL,0,1,0),(2632,'project','new-project-discussion-created-to-staff','polish','New Project Discussion (Sent to Project Members) [polish]','New Project Discussion Created - {project_name}','','{companyname} | CRM',NULL,0,1,0),(2633,'project','new-project-discussion-created-to-customer','polish','New Project Discussion (Sent to Customer Contacts) [polish]','New Project Discussion Created - {project_name}','','{companyname} | CRM',NULL,0,1,0),(2634,'project','new-project-file-uploaded-to-customer','polish','New Project File(s) Uploaded (Sent to Customer Contacts) [polish]','New Project File(s) Uploaded - {project_name}','','{companyname} | CRM',NULL,0,1,0),(2635,'project','new-project-file-uploaded-to-staff','polish','New Project File(s) Uploaded (Sent to Project Members) [polish]','New Project File(s) Uploaded - {project_name}','','{companyname} | CRM',NULL,0,1,0),(2636,'project','new-project-discussion-comment-to-customer','polish','New Discussion Comment  (Sent to Customer Contacts) [polish]','New Discussion Comment','','{companyname} | CRM',NULL,0,1,0),(2637,'project','new-project-discussion-comment-to-staff','polish','New Discussion Comment (Sent to Project Members) [polish]','New Discussion Comment','','{companyname} | CRM',NULL,0,1,0),(2638,'project','staff-added-as-project-member','polish','Staff Added as Project Member [polish]','New project assigned to you','','{companyname} | CRM',NULL,0,1,0),(2639,'estimate','estimate-expiry-reminder','polish','Estimate Expiration Reminder [polish]','Estimate Expiration Reminder','','{companyname} | CRM',NULL,0,1,0),(2640,'proposals','proposal-expiry-reminder','polish','Proposal Expiration Reminder [polish]','Proposal Expiration Reminder','','{companyname} | CRM',NULL,0,1,0),(2641,'staff','new-staff-created','polish','New Staff Created (Welcome Email) [polish]','You are added as staff member','','{companyname} | ERP','',0,1,0),(2642,'client','contact-forgot-password','polish','Forgot Password [polish]','Create New Password','','{companyname} | CRM',NULL,0,1,0),(2643,'client','contact-password-reseted','polish','Password Reset - Confirmation [polish]','Your password has been changed','','{companyname} | CRM',NULL,0,1,0),(2644,'client','contact-set-password','polish','Set New Password [polish]','Set new password on {companyname} ','','{companyname} | CRM',NULL,0,1,0),(2645,'staff','staff-forgot-password','polish','Forgot Password [polish]','Create New Password','','{companyname} | ERP','',0,1,0),(2646,'staff','staff-password-reseted','polish','Password Reset - Confirmation [polish]','Your password has been changed','','{companyname} | ERP','',0,1,0),(2647,'project','assigned-to-project','polish','New Project Created (Sent to Customer Contacts) [polish]','New Project Created','','{companyname} | CRM',NULL,0,1,0),(2648,'tasks','task-added-attachment-to-contacts','polish','New Attachment(s) on Task (Sent to Customer Contacts) [polish]','New Attachment on Task - {task_name}','','{companyname} | CRM',NULL,0,1,0),(2649,'tasks','task-commented-to-contacts','polish','New Comment on Task (Sent to Customer Contacts) [polish]','New Comment on Task - {task_name}','','{companyname} | CRM',NULL,0,1,0),(2650,'leads','new-lead-assigned','polish','New Lead Assigned to Staff Member [polish]','New lead assigned to you','','{companyname} | CRM',NULL,0,1,0),(2651,'client','client-statement','polish','Statement - Account Summary [polish]','Account Statement from {statement_from} to {statement_to}','','{companyname} | CRM',NULL,0,1,0),(2652,'ticket','ticket-assigned-to-admin','polish','New Ticket Assigned (Sent to Staff) [polish]','New support ticket has been assigned to you','','{companyname} | CRM',NULL,0,1,0),(2653,'client','new-client-registered-to-admin','polish','New Customer Registration (Sent to admins) [polish]','New Customer Registration','','{companyname} | CRM',NULL,0,1,0),(2654,'leads','new-web-to-lead-form-submitted','polish','Web to lead form submitted - Sent to lead [polish]','{lead_name} - We Received Your Request','','{companyname} | CRM',NULL,0,0,0),(2655,'staff','two-factor-authentication','polish','Two Factor Authentication [polish]','Confirm Your Login','','{companyname} | CRM',NULL,0,1,0),(2656,'project','project-finished-to-customer','polish','Project Marked as Finished (Sent to Customer Contacts) [polish]','Project Marked as Finished','','{companyname} | CRM',NULL,0,1,0),(2657,'credit_note','credit-note-send-to-client','polish','Send Credit Note To Email [polish]','Credit Note With Number #{credit_note_number} Created','','{companyname} | CRM',NULL,0,1,0),(2658,'tasks','task-status-change-to-staff','polish','Task Status Changed (Sent to Staff) [polish]','Task Status Changed','','{companyname} | CRM',NULL,0,1,0),(2659,'tasks','task-status-change-to-contacts','polish','Task Status Changed (Sent to Customer Contacts) [polish]','Task Status Changed','','{companyname} | CRM',NULL,0,1,0),(2660,'staff','reminder-email-staff','polish','Staff Reminder Email [polish]','You Have a New Reminder!','','{companyname} | ERP','',0,1,0),(2661,'contract','contract-comment-to-client','polish','New Comment  (Sent to Customer Contacts) [polish]','New Contract Comment','','{companyname} | CRM',NULL,0,1,0),(2662,'contract','contract-comment-to-admin','polish','New Comment (Sent to Staff)  [polish]','New Contract Comment','','{companyname} | CRM',NULL,0,1,0),(2663,'subscriptions','send-subscription','polish','Send Subscription to Customer [polish]','Subscription Created','','{companyname} | CRM',NULL,0,1,0),(2664,'subscriptions','subscription-payment-failed','polish','Subscription Payment Failed [polish]','Your most recent invoice payment failed','','{companyname} | CRM',NULL,0,1,0),(2665,'subscriptions','subscription-canceled','polish','Subscription Canceled (Sent to customer primary contact) [polish]','Your subscription has been canceled','','{companyname} | CRM',NULL,0,1,0),(2666,'subscriptions','subscription-payment-succeeded','polish','Subscription Payment Succeeded (Sent to customer primary contact) [polish]','Subscription  Payment Receipt - {subscription_name}','','{companyname} | CRM',NULL,0,1,0),(2667,'contract','contract-expiration-to-staff','polish','Contract Expiration Reminder (Sent to Staff) [polish]','Contract Expiration Reminder','','{companyname} | CRM',NULL,0,1,0),(2668,'gdpr','gdpr-removal-request','polish','Removal Request From Contact (Sent to administrators) [polish]','Data Removal Request Received','','{companyname} | CRM',NULL,0,1,0),(2669,'gdpr','gdpr-removal-request-lead','polish','Removal Request From Lead (Sent to administrators) [polish]','Data Removal Request Received','','{companyname} | CRM',NULL,0,1,0),(2670,'client','client-registration-confirmed','polish','Customer Registration Confirmed [polish]','Your registration is confirmed','','{companyname} | CRM',NULL,0,1,0),(2671,'contract','contract-signed-to-staff','polish','Contract Signed (Sent to Staff) [polish]','Customer Signed a Contract','','{companyname} | CRM',NULL,0,1,0),(2672,'subscriptions','customer-subscribed-to-staff','polish','Customer Subscribed to a Subscription (Sent to administrators and subscription creator) [polish]','Customer Subscribed to a Subscription','','{companyname} | CRM',NULL,0,1,0),(2673,'client','contact-verification-email','polish','Email Verification (Sent to Contact After Registration) [polish]','Verify Email Address','','{companyname} | CRM',NULL,0,1,0),(2674,'client','new-customer-profile-file-uploaded-to-staff','polish','New Customer Profile File(s) Uploaded (Sent to Staff) [polish]','Customer Uploaded New File(s) in Profile','','{companyname} | CRM',NULL,0,1,0),(2675,'staff','event-notification-to-staff','polish','Event Notification (Calendar) [polish]','Upcoming Event - {event_title}','','{companyname} | ERP','',0,1,0),(2676,'subscriptions','subscription-payment-requires-action','polish','Credit Card Authorization Required - SCA [polish]','Important: Confirm your subscription {subscription_name} payment','','{companyname} | CRM',NULL,0,1,0),(2677,'invoice','invoice-due-notice','polish','Invoice Due Notice [polish]','Your {invoice_number} will be due soon','','{companyname} | CRM',NULL,0,1,0),(2678,'estimate_request','estimate-request-submitted-to-staff','polish','Estimate Request Submitted (Sent to Staff) [polish]','New Estimate Request Submitted','','{companyname} | CRM',NULL,0,1,0),(2679,'estimate_request','estimate-request-assigned','polish','Estimate Request Assigned (Sent to Staff) [polish]','New Estimate Request Assigned','','{companyname} | CRM',NULL,0,1,0),(2680,'estimate_request','estimate-request-received-to-user','polish','Estimate Request Received (Sent to User) [polish]','Estimate Request Received','','{companyname} | CRM',NULL,0,0,0),(2681,'notifications','non-billed-tasks-reminder','polish','Non-billed tasks reminder (sent to selected staff members) [polish]','Action required: Completed tasks are not billed','','{companyname} | Speed and Dependability','',0,1,0),(2682,'invoice','invoices-batch-payments','polish','Invoices Payments Recorded in Batch (Sent to Customer) [polish]','We have received your payments','','{companyname} | CRM',NULL,0,1,0),(2683,'contract','contract-sign-reminder','polish','Contract Sign Reminder (Sent to Customer) [polish]','Contract Sign Reminder','','{companyname} | CRM',NULL,0,1,0),(2684,'client','affiliate_management_payout_updated','polish','Affiliate Payout Request Update [polish]','An update regarding your payout request','','{companyname} | CRM',NULL,0,1,0),(2685,'client','affiliate_management_signup_through_affiliate_link','polish','Successful Signup through Affiliate Link [polish]','Congratulations on a successful signup!','','{companyname} | CRM',NULL,0,1,0),(2686,'client','affiliate_management_successful_referral_commission','polish','Successful Referral Commission Notification [polish]','A referral commission received!','','{companyname} | CRM',NULL,0,1,0),(2687,'staff','affiliate_management_new_payout_request_for_admin','polish','Affiliate Payout Request [polish]','You have new affiliate payout request','','{companyname} | CRM',NULL,0,1,0),(2688,'staff','affiliate_management_payout_updated_for_admin','polish','Affiliate Payout Request Updated [polish]','You marked payout: #{payout_id} as {payout_status}','','{companyname} | CRM',NULL,0,1,0),(2689,'staff','affiliate_management_new_affiliate_signup_for_admin','polish','New Affiliate Signup [polish]','A new affiliate signup','','{companyname} | CRM',NULL,0,1,0),(2690,'client','affiliate_management_referral_commission_reversal','polish','Referral Commission Reversal Notification [polish]','A referral commission was reversed!','','{companyname} | CRM',NULL,0,1,0),(2691,'file_sharing','fs-share-staff','polish','Shared to staff [polish]','File Sharing','','{companyname} | ERP','',0,1,0),(2692,'file_sharing','fs-share-client','polish','Shared to client [polish]','File Sharing','','{companyname} | CRM',NULL,0,1,0),(2693,'file_sharing','fs-share-public','polish','Shared to public [polish]','File Sharing','','{companyname} | CRM',NULL,0,1,0),(2694,'notifications','fund-request-updated','polish','Fund Request Updated (sent staff member) [polish]','Fund Request Status Updated','','{companyname} | Speed and Dependability','',0,1,0),(2695,'inventory_warning','inventory-warning-to-staff','polish','Inventory warning (Sent to staff) [polish]','Inventory warning','','{companyname} | CRM',NULL,0,1,0),(2696,'purchase_order','purchase-order-to-contact','polish','Purchase Order (Sent to contact) [polish]','Purchase Order','','{companyname} | CRM',NULL,0,1,0),(2697,'purchase_order','purchase-request-to-contact','polish','Purchase Request (Sent to contact) [polish]','Purchase Request','','{companyname} | CRM',NULL,0,1,0),(2698,'purchase_order','purchase-quotation-to-contact','polish','Purchase Quotation (Sent to contact) [polish]','Purchase Quotation','','{companyname} | CRM',NULL,0,1,0),(2699,'purchase_order','debit-note-to-contact','polish','Debit Note (Sent to contact) [polish]','Debit Note','','{companyname} | CRM',NULL,0,1,0),(2700,'purchase_order','purchase-statement-to-contact','polish','Purchase Statement (Sent to contact) [polish]','Purchase Statement','','{companyname} | CRM',NULL,0,1,0),(2701,'purchase_order','vendor-registration-confirmed','polish','Vendor Registration Confirmed [polish]','Your registration is confirmed','','{companyname} | CRM',NULL,0,1,0),(2702,'purchase_order','purchase-contract-to-contact','polish','Purchase Contract (Sent to contact) [polish]','Purchase Contract','','{companyname} | CRM',NULL,0,1,0),(2703,'purchase_order','new-contact-created','polish','New Contact Added/Registered (Welcome Email) [polish]','New Contact Added/Registered (Welcome Email)','','{companyname} | CRM',NULL,0,1,0),(2704,'purchase_order','purchase-request-approval','polish','Request approval [polish]','Request approval','','{companyname} | CRM',NULL,0,1,0),(2705,'purchase_order','purchase-send-approved','polish','Email send approved [polish]','Email send approved','','{companyname} | CRM',NULL,0,1,0),(2706,'purchase_order','purchase-send-rejected','polish','Email send rejected [polish]','Email send rejected','','{companyname} | CRM',NULL,0,1,0),(2707,'client','new-client-created','french','New Contact Added/Registered (Welcome Email) [french]','Welcome aboard','','{companyname} | CRM',NULL,0,1,0),(2708,'invoice','invoice-send-to-client','french','Send Invoice to Customer [french]','Invoice with number {invoice_number} created','','{companyname} | ERP','',0,1,0),(2709,'ticket','new-ticket-opened-admin','french','New Ticket Opened (Opened by Staff, Sent to Customer) [french]','New Support Ticket Opened','','{companyname} | CRM',NULL,0,1,0),(2710,'ticket','ticket-reply','french','Ticket Reply (Sent to Customer) [french]','New Ticket Reply','','{companyname} | CRM',NULL,0,1,0),(2711,'ticket','ticket-autoresponse','french','New Ticket Opened - Autoresponse [french]','New Support Ticket Opened','','{companyname} | CRM',NULL,0,1,0),(2712,'invoice','invoice-payment-recorded','french','Invoice Payment Recorded (Sent to Customer) [french]','Invoice Payment Recorded','','{companyname} | CRM',NULL,0,1,0),(2713,'invoice','invoice-overdue-notice','french','Invoice Overdue Notice [french]','Invoice Overdue Notice - {invoice_number}','','{companyname} | CRM',NULL,0,1,0),(2714,'invoice','invoice-already-send','french','Invoice Already Sent to Customer [french]','Invoice # {invoice_number} ','','{companyname} | CRM',NULL,0,1,0),(2715,'ticket','new-ticket-created-staff','french','New Ticket Created (Opened by Customer, Sent to Staff Members) [french]','New Ticket Created','','{companyname} | CRM',NULL,0,1,0),(2716,'estimate','estimate-send-to-client','french','Send Estimate to Customer [french]','Estimate # {estimate_number} created','','{companyname} | ERP','',0,1,0),(2717,'ticket','ticket-reply-to-admin','french','Ticket Reply (Sent to Staff) [french]','New Support Ticket Reply','','{companyname} | CRM',NULL,0,1,0),(2718,'estimate','estimate-already-send','french','Estimate Already Sent to Customer [french]','Estimate # {estimate_number} ','','{companyname} | ERP','',0,1,0),(2719,'contract','contract-expiration','french','Contract Expiration Reminder (Sent to Customer Contacts) [french]','Contract Expiration Reminder','','{companyname} | CRM',NULL,0,1,0),(2720,'tasks','task-assigned','french','New Task Assigned (Sent to Staff) [french]','New Task Assigned to You - {task_name}','','{companyname} | CRM',NULL,0,1,0),(2721,'tasks','task-added-as-follower','french','Staff Member Added as Follower on Task (Sent to Staff) [french]','You are added as follower on task - {task_name}','','{companyname} | CRM',NULL,0,1,0),(2722,'tasks','task-commented','french','New Comment on Task (Sent to Staff) [french]','New Comment on Task - {task_name}','','{companyname} | CRM',NULL,0,1,0),(2723,'tasks','task-added-attachment','french','New Attachment(s) on Task (Sent to Staff) [french]','New Attachment on Task - {task_name}','','{companyname} | CRM',NULL,0,1,0),(2724,'estimate','estimate-declined-to-staff','french','Estimate Declined (Sent to Staff) [french]','Customer Declined Estimate','','{companyname} | ERP','',0,1,0),(2725,'estimate','estimate-accepted-to-staff','french','Estimate Accepted (Sent to Staff) [french]','Customer Accepted Estimate','','{companyname} | CRM',NULL,0,1,0),(2726,'proposals','proposal-client-accepted','french','Customer Action - Accepted (Sent to Staff) [french]','Customer Accepted Proposal','','{companyname} | CRM',NULL,0,1,0),(2727,'proposals','proposal-send-to-customer','french','Send Proposal to Customer [french]','Proposal With Number {proposal_number} Created','','{companyname} | CRM',NULL,0,1,0),(2728,'proposals','proposal-client-declined','french','Customer Action - Declined (Sent to Staff) [french]','Client Declined Proposal','','{companyname} | CRM',NULL,0,1,0),(2729,'proposals','proposal-client-thank-you','french','Thank You Email (Sent to Customer After Accept) [french]','Thank for you accepting proposal','','{companyname} | CRM',NULL,0,1,0),(2730,'proposals','proposal-comment-to-client','french','New Comment  (Sent to Customer/Lead) [french]','New Proposal Comment','','{companyname} | CRM',NULL,0,1,0),(2731,'proposals','proposal-comment-to-admin','french','New Comment (Sent to Staff)  [french]','New Proposal Comment','','{companyname} | CRM',NULL,0,1,0),(2732,'estimate','estimate-thank-you-to-customer','french','Thank You Email (Sent to Customer After Accept) [french]','Thank for you accepting estimate','','{companyname} | CRM',NULL,0,1,0),(2733,'tasks','task-deadline-notification','french','Task Deadline Reminder - Sent to Assigned Members [french]','Task Deadline Reminder','','{companyname} | CRM',NULL,0,1,0),(2734,'contract','send-contract','french','Send Contract to Customer [french]','Contract - {contract_subject}','','{companyname} | CRM',NULL,0,1,0),(2735,'invoice','invoice-payment-recorded-to-staff','french','Invoice Payment Recorded (Sent to Staff) [french]','New Invoice Payment','','{companyname} | CRM',NULL,0,1,0),(2736,'ticket','auto-close-ticket','french','Auto Close Ticket [french]','Ticket Auto Closed','','{companyname} | CRM',NULL,0,1,0),(2737,'project','new-project-discussion-created-to-staff','french','New Project Discussion (Sent to Project Members) [french]','New Project Discussion Created - {project_name}','','{companyname} | CRM',NULL,0,1,0),(2738,'project','new-project-discussion-created-to-customer','french','New Project Discussion (Sent to Customer Contacts) [french]','New Project Discussion Created - {project_name}','','{companyname} | CRM',NULL,0,1,0),(2739,'project','new-project-file-uploaded-to-customer','french','New Project File(s) Uploaded (Sent to Customer Contacts) [french]','New Project File(s) Uploaded - {project_name}','','{companyname} | CRM',NULL,0,1,0),(2740,'project','new-project-file-uploaded-to-staff','french','New Project File(s) Uploaded (Sent to Project Members) [french]','New Project File(s) Uploaded - {project_name}','','{companyname} | CRM',NULL,0,1,0),(2741,'project','new-project-discussion-comment-to-customer','french','New Discussion Comment  (Sent to Customer Contacts) [french]','New Discussion Comment','','{companyname} | CRM',NULL,0,1,0),(2742,'project','new-project-discussion-comment-to-staff','french','New Discussion Comment (Sent to Project Members) [french]','New Discussion Comment','','{companyname} | CRM',NULL,0,1,0),(2743,'project','staff-added-as-project-member','french','Staff Added as Project Member [french]','New project assigned to you','','{companyname} | CRM',NULL,0,1,0),(2744,'estimate','estimate-expiry-reminder','french','Estimate Expiration Reminder [french]','Estimate Expiration Reminder','','{companyname} | CRM',NULL,0,1,0),(2745,'proposals','proposal-expiry-reminder','french','Proposal Expiration Reminder [french]','Proposal Expiration Reminder','','{companyname} | CRM',NULL,0,1,0),(2746,'staff','new-staff-created','french','New Staff Created (Welcome Email) [french]','You are added as staff member','','{companyname} | ERP','',0,1,0),(2747,'client','contact-forgot-password','french','Forgot Password [french]','Create New Password','','{companyname} | CRM',NULL,0,1,0),(2748,'client','contact-password-reseted','french','Password Reset - Confirmation [french]','Your password has been changed','','{companyname} | CRM',NULL,0,1,0),(2749,'client','contact-set-password','french','Set New Password [french]','Set new password on {companyname} ','','{companyname} | CRM',NULL,0,1,0),(2750,'staff','staff-forgot-password','french','Forgot Password [french]','Create New Password','','{companyname} | ERP','',0,1,0),(2751,'staff','staff-password-reseted','french','Password Reset - Confirmation [french]','Your password has been changed','','{companyname} | ERP','',0,1,0),(2752,'project','assigned-to-project','french','New Project Created (Sent to Customer Contacts) [french]','New Project Created','','{companyname} | CRM',NULL,0,1,0),(2753,'tasks','task-added-attachment-to-contacts','french','New Attachment(s) on Task (Sent to Customer Contacts) [french]','New Attachment on Task - {task_name}','','{companyname} | CRM',NULL,0,1,0),(2754,'tasks','task-commented-to-contacts','french','New Comment on Task (Sent to Customer Contacts) [french]','New Comment on Task - {task_name}','','{companyname} | CRM',NULL,0,1,0),(2755,'leads','new-lead-assigned','french','New Lead Assigned to Staff Member [french]','New lead assigned to you','','{companyname} | CRM',NULL,0,1,0),(2756,'client','client-statement','french','Statement - Account Summary [french]','Account Statement from {statement_from} to {statement_to}','','{companyname} | CRM',NULL,0,1,0),(2757,'ticket','ticket-assigned-to-admin','french','New Ticket Assigned (Sent to Staff) [french]','New support ticket has been assigned to you','','{companyname} | CRM',NULL,0,1,0),(2758,'client','new-client-registered-to-admin','french','New Customer Registration (Sent to admins) [french]','New Customer Registration','','{companyname} | CRM',NULL,0,1,0),(2759,'leads','new-web-to-lead-form-submitted','french','Web to lead form submitted - Sent to lead [french]','{lead_name} - We Received Your Request','','{companyname} | CRM',NULL,0,0,0),(2760,'staff','two-factor-authentication','french','Two Factor Authentication [french]','Confirm Your Login','','{companyname} | CRM',NULL,0,1,0),(2761,'project','project-finished-to-customer','french','Project Marked as Finished (Sent to Customer Contacts) [french]','Project Marked as Finished','','{companyname} | CRM',NULL,0,1,0),(2762,'credit_note','credit-note-send-to-client','french','Send Credit Note To Email [french]','Credit Note With Number #{credit_note_number} Created','','{companyname} | CRM',NULL,0,1,0),(2763,'tasks','task-status-change-to-staff','french','Task Status Changed (Sent to Staff) [french]','Task Status Changed','','{companyname} | CRM',NULL,0,1,0),(2764,'tasks','task-status-change-to-contacts','french','Task Status Changed (Sent to Customer Contacts) [french]','Task Status Changed','','{companyname} | CRM',NULL,0,1,0),(2765,'staff','reminder-email-staff','french','Staff Reminder Email [french]','You Have a New Reminder!','','{companyname} | ERP','',0,1,0),(2766,'contract','contract-comment-to-client','french','New Comment  (Sent to Customer Contacts) [french]','New Contract Comment','','{companyname} | CRM',NULL,0,1,0),(2767,'contract','contract-comment-to-admin','french','New Comment (Sent to Staff)  [french]','New Contract Comment','','{companyname} | CRM',NULL,0,1,0),(2768,'subscriptions','send-subscription','french','Send Subscription to Customer [french]','Subscription Created','','{companyname} | CRM',NULL,0,1,0),(2769,'subscriptions','subscription-payment-failed','french','Subscription Payment Failed [french]','Your most recent invoice payment failed','','{companyname} | CRM',NULL,0,1,0),(2770,'subscriptions','subscription-canceled','french','Subscription Canceled (Sent to customer primary contact) [french]','Your subscription has been canceled','','{companyname} | CRM',NULL,0,1,0),(2771,'subscriptions','subscription-payment-succeeded','french','Subscription Payment Succeeded (Sent to customer primary contact) [french]','Subscription  Payment Receipt - {subscription_name}','','{companyname} | CRM',NULL,0,1,0),(2772,'contract','contract-expiration-to-staff','french','Contract Expiration Reminder (Sent to Staff) [french]','Contract Expiration Reminder','','{companyname} | CRM',NULL,0,1,0),(2773,'gdpr','gdpr-removal-request','french','Removal Request From Contact (Sent to administrators) [french]','Data Removal Request Received','','{companyname} | CRM',NULL,0,1,0),(2774,'gdpr','gdpr-removal-request-lead','french','Removal Request From Lead (Sent to administrators) [french]','Data Removal Request Received','','{companyname} | CRM',NULL,0,1,0),(2775,'client','client-registration-confirmed','french','Customer Registration Confirmed [french]','Your registration is confirmed','','{companyname} | CRM',NULL,0,1,0),(2776,'contract','contract-signed-to-staff','french','Contract Signed (Sent to Staff) [french]','Customer Signed a Contract','','{companyname} | CRM',NULL,0,1,0),(2777,'subscriptions','customer-subscribed-to-staff','french','Customer Subscribed to a Subscription (Sent to administrators and subscription creator) [french]','Customer Subscribed to a Subscription','','{companyname} | CRM',NULL,0,1,0),(2778,'client','contact-verification-email','french','Email Verification (Sent to Contact After Registration) [french]','Verify Email Address','','{companyname} | CRM',NULL,0,1,0),(2779,'client','new-customer-profile-file-uploaded-to-staff','french','New Customer Profile File(s) Uploaded (Sent to Staff) [french]','Customer Uploaded New File(s) in Profile','','{companyname} | CRM',NULL,0,1,0),(2780,'staff','event-notification-to-staff','french','Event Notification (Calendar) [french]','Upcoming Event - {event_title}','','{companyname} | ERP','',0,1,0),(2781,'subscriptions','subscription-payment-requires-action','french','Credit Card Authorization Required - SCA [french]','Important: Confirm your subscription {subscription_name} payment','','{companyname} | CRM',NULL,0,1,0),(2782,'invoice','invoice-due-notice','french','Invoice Due Notice [french]','Your {invoice_number} will be due soon','','{companyname} | CRM',NULL,0,1,0),(2783,'estimate_request','estimate-request-submitted-to-staff','french','Estimate Request Submitted (Sent to Staff) [french]','New Estimate Request Submitted','','{companyname} | CRM',NULL,0,1,0),(2784,'estimate_request','estimate-request-assigned','french','Estimate Request Assigned (Sent to Staff) [french]','New Estimate Request Assigned','','{companyname} | CRM',NULL,0,1,0),(2785,'estimate_request','estimate-request-received-to-user','french','Estimate Request Received (Sent to User) [french]','Estimate Request Received','','{companyname} | CRM',NULL,0,0,0),(2786,'notifications','non-billed-tasks-reminder','french','Non-billed tasks reminder (sent to selected staff members) [french]','Action required: Completed tasks are not billed','','{companyname} | Speed and Dependability','',0,1,0),(2787,'invoice','invoices-batch-payments','french','Invoices Payments Recorded in Batch (Sent to Customer) [french]','We have received your payments','','{companyname} | CRM',NULL,0,1,0),(2788,'contract','contract-sign-reminder','french','Contract Sign Reminder (Sent to Customer) [french]','Contract Sign Reminder','','{companyname} | CRM',NULL,0,1,0),(2789,'client','affiliate_management_payout_updated','french','Affiliate Payout Request Update [french]','An update regarding your payout request','','{companyname} | CRM',NULL,0,1,0),(2790,'client','affiliate_management_signup_through_affiliate_link','french','Successful Signup through Affiliate Link [french]','Congratulations on a successful signup!','','{companyname} | CRM',NULL,0,1,0),(2791,'client','affiliate_management_successful_referral_commission','french','Successful Referral Commission Notification [french]','A referral commission received!','','{companyname} | CRM',NULL,0,1,0),(2792,'staff','affiliate_management_new_payout_request_for_admin','french','Affiliate Payout Request [french]','You have new affiliate payout request','','{companyname} | CRM',NULL,0,1,0),(2793,'staff','affiliate_management_payout_updated_for_admin','french','Affiliate Payout Request Updated [french]','You marked payout: #{payout_id} as {payout_status}','','{companyname} | CRM',NULL,0,1,0),(2794,'staff','affiliate_management_new_affiliate_signup_for_admin','french','New Affiliate Signup [french]','A new affiliate signup','','{companyname} | CRM',NULL,0,1,0),(2795,'client','affiliate_management_referral_commission_reversal','french','Referral Commission Reversal Notification [french]','A referral commission was reversed!','','{companyname} | CRM',NULL,0,1,0),(2796,'file_sharing','fs-share-staff','french','Shared to staff [french]','File Sharing','','{companyname} | ERP','',0,1,0),(2797,'file_sharing','fs-share-client','french','Shared to client [french]','File Sharing','','{companyname} | CRM',NULL,0,1,0),(2798,'file_sharing','fs-share-public','french','Shared to public [french]','File Sharing','','{companyname} | CRM',NULL,0,1,0),(2799,'notifications','fund-request-updated','french','Fund Request Updated (sent staff member) [french]','Fund Request Status Updated','','{companyname} | Speed and Dependability','',0,1,0),(2800,'inventory_warning','inventory-warning-to-staff','french','Inventory warning (Sent to staff) [french]','Inventory warning','','{companyname} | CRM',NULL,0,1,0),(2801,'purchase_order','purchase-order-to-contact','french','Purchase Order (Sent to contact) [french]','Purchase Order','','{companyname} | CRM',NULL,0,1,0),(2802,'purchase_order','purchase-request-to-contact','french','Purchase Request (Sent to contact) [french]','Purchase Request','','{companyname} | CRM',NULL,0,1,0),(2803,'purchase_order','purchase-quotation-to-contact','french','Purchase Quotation (Sent to contact) [french]','Purchase Quotation','','{companyname} | CRM',NULL,0,1,0),(2804,'purchase_order','debit-note-to-contact','french','Debit Note (Sent to contact) [french]','Debit Note','','{companyname} | CRM',NULL,0,1,0),(2805,'purchase_order','purchase-statement-to-contact','french','Purchase Statement (Sent to contact) [french]','Purchase Statement','','{companyname} | CRM',NULL,0,1,0),(2806,'purchase_order','vendor-registration-confirmed','french','Vendor Registration Confirmed [french]','Your registration is confirmed','','{companyname} | CRM',NULL,0,1,0),(2807,'purchase_order','purchase-contract-to-contact','french','Purchase Contract (Sent to contact) [french]','Purchase Contract','','{companyname} | CRM',NULL,0,1,0),(2808,'purchase_order','new-contact-created','french','New Contact Added/Registered (Welcome Email) [french]','New Contact Added/Registered (Welcome Email)','','{companyname} | CRM',NULL,0,1,0),(2809,'purchase_order','purchase-request-approval','french','Request approval [french]','Request approval','','{companyname} | CRM',NULL,0,1,0),(2810,'purchase_order','purchase-send-approved','french','Email send approved [french]','Email send approved','','{companyname} | CRM',NULL,0,1,0),(2811,'purchase_order','purchase-send-rejected','french','Email send rejected [french]','Email send rejected','','{companyname} | CRM',NULL,0,1,0),(2812,'client','new-client-created','ukrainian','New Contact Added/Registered (Welcome Email) [ukrainian]','Welcome aboard','','{companyname} | CRM',NULL,0,1,0),(2813,'invoice','invoice-send-to-client','ukrainian','Send Invoice to Customer [ukrainian]','Invoice with number {invoice_number} created','','{companyname} | ERP','',0,1,0),(2814,'ticket','new-ticket-opened-admin','ukrainian','New Ticket Opened (Opened by Staff, Sent to Customer) [ukrainian]','New Support Ticket Opened','','{companyname} | CRM',NULL,0,1,0),(2815,'ticket','ticket-reply','ukrainian','Ticket Reply (Sent to Customer) [ukrainian]','New Ticket Reply','','{companyname} | CRM',NULL,0,1,0),(2816,'ticket','ticket-autoresponse','ukrainian','New Ticket Opened - Autoresponse [ukrainian]','New Support Ticket Opened','','{companyname} | CRM',NULL,0,1,0),(2817,'invoice','invoice-payment-recorded','ukrainian','Invoice Payment Recorded (Sent to Customer) [ukrainian]','Invoice Payment Recorded','','{companyname} | CRM',NULL,0,1,0),(2818,'invoice','invoice-overdue-notice','ukrainian','Invoice Overdue Notice [ukrainian]','Invoice Overdue Notice - {invoice_number}','','{companyname} | CRM',NULL,0,1,0),(2819,'invoice','invoice-already-send','ukrainian','Invoice Already Sent to Customer [ukrainian]','Invoice # {invoice_number} ','','{companyname} | CRM',NULL,0,1,0),(2820,'ticket','new-ticket-created-staff','ukrainian','New Ticket Created (Opened by Customer, Sent to Staff Members) [ukrainian]','New Ticket Created','','{companyname} | CRM',NULL,0,1,0),(2821,'estimate','estimate-send-to-client','ukrainian','Send Estimate to Customer [ukrainian]','Estimate # {estimate_number} created','','{companyname} | ERP','',0,1,0),(2822,'ticket','ticket-reply-to-admin','ukrainian','Ticket Reply (Sent to Staff) [ukrainian]','New Support Ticket Reply','','{companyname} | CRM',NULL,0,1,0),(2823,'estimate','estimate-already-send','ukrainian','Estimate Already Sent to Customer [ukrainian]','Estimate # {estimate_number} ','','{companyname} | ERP','',0,1,0),(2824,'contract','contract-expiration','ukrainian','Contract Expiration Reminder (Sent to Customer Contacts) [ukrainian]','Contract Expiration Reminder','','{companyname} | CRM',NULL,0,1,0),(2825,'tasks','task-assigned','ukrainian','New Task Assigned (Sent to Staff) [ukrainian]','New Task Assigned to You - {task_name}','','{companyname} | CRM',NULL,0,1,0),(2826,'tasks','task-added-as-follower','ukrainian','Staff Member Added as Follower on Task (Sent to Staff) [ukrainian]','You are added as follower on task - {task_name}','','{companyname} | CRM',NULL,0,1,0),(2827,'tasks','task-commented','ukrainian','New Comment on Task (Sent to Staff) [ukrainian]','New Comment on Task - {task_name}','','{companyname} | CRM',NULL,0,1,0),(2828,'tasks','task-added-attachment','ukrainian','New Attachment(s) on Task (Sent to Staff) [ukrainian]','New Attachment on Task - {task_name}','','{companyname} | CRM',NULL,0,1,0),(2829,'estimate','estimate-declined-to-staff','ukrainian','Estimate Declined (Sent to Staff) [ukrainian]','Customer Declined Estimate','','{companyname} | ERP','',0,1,0),(2830,'estimate','estimate-accepted-to-staff','ukrainian','Estimate Accepted (Sent to Staff) [ukrainian]','Customer Accepted Estimate','','{companyname} | CRM',NULL,0,1,0),(2831,'proposals','proposal-client-accepted','ukrainian','Customer Action - Accepted (Sent to Staff) [ukrainian]','Customer Accepted Proposal','','{companyname} | CRM',NULL,0,1,0),(2832,'proposals','proposal-send-to-customer','ukrainian','Send Proposal to Customer [ukrainian]','Proposal With Number {proposal_number} Created','','{companyname} | CRM',NULL,0,1,0),(2833,'proposals','proposal-client-declined','ukrainian','Customer Action - Declined (Sent to Staff) [ukrainian]','Client Declined Proposal','','{companyname} | CRM',NULL,0,1,0),(2834,'proposals','proposal-client-thank-you','ukrainian','Thank You Email (Sent to Customer After Accept) [ukrainian]','Thank for you accepting proposal','','{companyname} | CRM',NULL,0,1,0),(2835,'proposals','proposal-comment-to-client','ukrainian','New Comment  (Sent to Customer/Lead) [ukrainian]','New Proposal Comment','','{companyname} | CRM',NULL,0,1,0),(2836,'proposals','proposal-comment-to-admin','ukrainian','New Comment (Sent to Staff)  [ukrainian]','New Proposal Comment','','{companyname} | CRM',NULL,0,1,0),(2837,'estimate','estimate-thank-you-to-customer','ukrainian','Thank You Email (Sent to Customer After Accept) [ukrainian]','Thank for you accepting estimate','','{companyname} | CRM',NULL,0,1,0),(2838,'tasks','task-deadline-notification','ukrainian','Task Deadline Reminder - Sent to Assigned Members [ukrainian]','Task Deadline Reminder','','{companyname} | CRM',NULL,0,1,0),(2839,'contract','send-contract','ukrainian','Send Contract to Customer [ukrainian]','Contract - {contract_subject}','','{companyname} | CRM',NULL,0,1,0),(2840,'invoice','invoice-payment-recorded-to-staff','ukrainian','Invoice Payment Recorded (Sent to Staff) [ukrainian]','New Invoice Payment','','{companyname} | CRM',NULL,0,1,0),(2841,'ticket','auto-close-ticket','ukrainian','Auto Close Ticket [ukrainian]','Ticket Auto Closed','','{companyname} | CRM',NULL,0,1,0),(2842,'project','new-project-discussion-created-to-staff','ukrainian','New Project Discussion (Sent to Project Members) [ukrainian]','New Project Discussion Created - {project_name}','','{companyname} | CRM',NULL,0,1,0),(2843,'project','new-project-discussion-created-to-customer','ukrainian','New Project Discussion (Sent to Customer Contacts) [ukrainian]','New Project Discussion Created - {project_name}','','{companyname} | CRM',NULL,0,1,0),(2844,'project','new-project-file-uploaded-to-customer','ukrainian','New Project File(s) Uploaded (Sent to Customer Contacts) [ukrainian]','New Project File(s) Uploaded - {project_name}','','{companyname} | CRM',NULL,0,1,0),(2845,'project','new-project-file-uploaded-to-staff','ukrainian','New Project File(s) Uploaded (Sent to Project Members) [ukrainian]','New Project File(s) Uploaded - {project_name}','','{companyname} | CRM',NULL,0,1,0),(2846,'project','new-project-discussion-comment-to-customer','ukrainian','New Discussion Comment  (Sent to Customer Contacts) [ukrainian]','New Discussion Comment','','{companyname} | CRM',NULL,0,1,0),(2847,'project','new-project-discussion-comment-to-staff','ukrainian','New Discussion Comment (Sent to Project Members) [ukrainian]','New Discussion Comment','','{companyname} | CRM',NULL,0,1,0),(2848,'project','staff-added-as-project-member','ukrainian','Staff Added as Project Member [ukrainian]','New project assigned to you','','{companyname} | CRM',NULL,0,1,0),(2849,'estimate','estimate-expiry-reminder','ukrainian','Estimate Expiration Reminder [ukrainian]','Estimate Expiration Reminder','','{companyname} | CRM',NULL,0,1,0),(2850,'proposals','proposal-expiry-reminder','ukrainian','Proposal Expiration Reminder [ukrainian]','Proposal Expiration Reminder','','{companyname} | CRM',NULL,0,1,0),(2851,'staff','new-staff-created','ukrainian','New Staff Created (Welcome Email) [ukrainian]','You are added as staff member','','{companyname} | ERP','',0,1,0),(2852,'client','contact-forgot-password','ukrainian','Forgot Password [ukrainian]','Create New Password','','{companyname} | CRM',NULL,0,1,0),(2853,'client','contact-password-reseted','ukrainian','Password Reset - Confirmation [ukrainian]','Your password has been changed','','{companyname} | CRM',NULL,0,1,0),(2854,'client','contact-set-password','ukrainian','Set New Password [ukrainian]','Set new password on {companyname} ','','{companyname} | CRM',NULL,0,1,0),(2855,'staff','staff-forgot-password','ukrainian','Forgot Password [ukrainian]','Create New Password','','{companyname} | ERP','',0,1,0),(2856,'staff','staff-password-reseted','ukrainian','Password Reset - Confirmation [ukrainian]','Your password has been changed','','{companyname} | ERP','',0,1,0),(2857,'project','assigned-to-project','ukrainian','New Project Created (Sent to Customer Contacts) [ukrainian]','New Project Created','','{companyname} | CRM',NULL,0,1,0),(2858,'tasks','task-added-attachment-to-contacts','ukrainian','New Attachment(s) on Task (Sent to Customer Contacts) [ukrainian]','New Attachment on Task - {task_name}','','{companyname} | CRM',NULL,0,1,0),(2859,'tasks','task-commented-to-contacts','ukrainian','New Comment on Task (Sent to Customer Contacts) [ukrainian]','New Comment on Task - {task_name}','','{companyname} | CRM',NULL,0,1,0),(2860,'leads','new-lead-assigned','ukrainian','New Lead Assigned to Staff Member [ukrainian]','New lead assigned to you','','{companyname} | CRM',NULL,0,1,0),(2861,'client','client-statement','ukrainian','Statement - Account Summary [ukrainian]','Account Statement from {statement_from} to {statement_to}','','{companyname} | CRM',NULL,0,1,0),(2862,'ticket','ticket-assigned-to-admin','ukrainian','New Ticket Assigned (Sent to Staff) [ukrainian]','New support ticket has been assigned to you','','{companyname} | CRM',NULL,0,1,0),(2863,'client','new-client-registered-to-admin','ukrainian','New Customer Registration (Sent to admins) [ukrainian]','New Customer Registration','','{companyname} | CRM',NULL,0,1,0),(2864,'leads','new-web-to-lead-form-submitted','ukrainian','Web to lead form submitted - Sent to lead [ukrainian]','{lead_name} - We Received Your Request','','{companyname} | CRM',NULL,0,0,0),(2865,'staff','two-factor-authentication','ukrainian','Two Factor Authentication [ukrainian]','Confirm Your Login','','{companyname} | CRM',NULL,0,1,0),(2866,'project','project-finished-to-customer','ukrainian','Project Marked as Finished (Sent to Customer Contacts) [ukrainian]','Project Marked as Finished','','{companyname} | CRM',NULL,0,1,0),(2867,'credit_note','credit-note-send-to-client','ukrainian','Send Credit Note To Email [ukrainian]','Credit Note With Number #{credit_note_number} Created','','{companyname} | CRM',NULL,0,1,0),(2868,'tasks','task-status-change-to-staff','ukrainian','Task Status Changed (Sent to Staff) [ukrainian]','Task Status Changed','','{companyname} | CRM',NULL,0,1,0),(2869,'tasks','task-status-change-to-contacts','ukrainian','Task Status Changed (Sent to Customer Contacts) [ukrainian]','Task Status Changed','','{companyname} | CRM',NULL,0,1,0),(2870,'staff','reminder-email-staff','ukrainian','Staff Reminder Email [ukrainian]','You Have a New Reminder!','','{companyname} | ERP','',0,1,0),(2871,'contract','contract-comment-to-client','ukrainian','New Comment  (Sent to Customer Contacts) [ukrainian]','New Contract Comment','','{companyname} | CRM',NULL,0,1,0),(2872,'contract','contract-comment-to-admin','ukrainian','New Comment (Sent to Staff)  [ukrainian]','New Contract Comment','','{companyname} | CRM',NULL,0,1,0),(2873,'subscriptions','send-subscription','ukrainian','Send Subscription to Customer [ukrainian]','Subscription Created','','{companyname} | CRM',NULL,0,1,0),(2874,'subscriptions','subscription-payment-failed','ukrainian','Subscription Payment Failed [ukrainian]','Your most recent invoice payment failed','','{companyname} | CRM',NULL,0,1,0),(2875,'subscriptions','subscription-canceled','ukrainian','Subscription Canceled (Sent to customer primary contact) [ukrainian]','Your subscription has been canceled','','{companyname} | CRM',NULL,0,1,0),(2876,'subscriptions','subscription-payment-succeeded','ukrainian','Subscription Payment Succeeded (Sent to customer primary contact) [ukrainian]','Subscription  Payment Receipt - {subscription_name}','','{companyname} | CRM',NULL,0,1,0),(2877,'contract','contract-expiration-to-staff','ukrainian','Contract Expiration Reminder (Sent to Staff) [ukrainian]','Contract Expiration Reminder','','{companyname} | CRM',NULL,0,1,0),(2878,'gdpr','gdpr-removal-request','ukrainian','Removal Request From Contact (Sent to administrators) [ukrainian]','Data Removal Request Received','','{companyname} | CRM',NULL,0,1,0),(2879,'gdpr','gdpr-removal-request-lead','ukrainian','Removal Request From Lead (Sent to administrators) [ukrainian]','Data Removal Request Received','','{companyname} | CRM',NULL,0,1,0),(2880,'client','client-registration-confirmed','ukrainian','Customer Registration Confirmed [ukrainian]','Your registration is confirmed','','{companyname} | CRM',NULL,0,1,0),(2881,'contract','contract-signed-to-staff','ukrainian','Contract Signed (Sent to Staff) [ukrainian]','Customer Signed a Contract','','{companyname} | CRM',NULL,0,1,0),(2882,'subscriptions','customer-subscribed-to-staff','ukrainian','Customer Subscribed to a Subscription (Sent to administrators and subscription creator) [ukrainian]','Customer Subscribed to a Subscription','','{companyname} | CRM',NULL,0,1,0),(2883,'client','contact-verification-email','ukrainian','Email Verification (Sent to Contact After Registration) [ukrainian]','Verify Email Address','','{companyname} | CRM',NULL,0,1,0),(2884,'client','new-customer-profile-file-uploaded-to-staff','ukrainian','New Customer Profile File(s) Uploaded (Sent to Staff) [ukrainian]','Customer Uploaded New File(s) in Profile','','{companyname} | CRM',NULL,0,1,0),(2885,'staff','event-notification-to-staff','ukrainian','Event Notification (Calendar) [ukrainian]','Upcoming Event - {event_title}','','{companyname} | ERP','',0,1,0),(2886,'subscriptions','subscription-payment-requires-action','ukrainian','Credit Card Authorization Required - SCA [ukrainian]','Important: Confirm your subscription {subscription_name} payment','','{companyname} | CRM',NULL,0,1,0),(2887,'invoice','invoice-due-notice','ukrainian','Invoice Due Notice [ukrainian]','Your {invoice_number} will be due soon','','{companyname} | CRM',NULL,0,1,0),(2888,'estimate_request','estimate-request-submitted-to-staff','ukrainian','Estimate Request Submitted (Sent to Staff) [ukrainian]','New Estimate Request Submitted','','{companyname} | CRM',NULL,0,1,0),(2889,'estimate_request','estimate-request-assigned','ukrainian','Estimate Request Assigned (Sent to Staff) [ukrainian]','New Estimate Request Assigned','','{companyname} | CRM',NULL,0,1,0),(2890,'estimate_request','estimate-request-received-to-user','ukrainian','Estimate Request Received (Sent to User) [ukrainian]','Estimate Request Received','','{companyname} | CRM',NULL,0,0,0),(2891,'notifications','non-billed-tasks-reminder','ukrainian','Non-billed tasks reminder (sent to selected staff members) [ukrainian]','Action required: Completed tasks are not billed','','{companyname} | Speed and Dependability','',0,1,0),(2892,'invoice','invoices-batch-payments','ukrainian','Invoices Payments Recorded in Batch (Sent to Customer) [ukrainian]','We have received your payments','','{companyname} | CRM',NULL,0,1,0),(2893,'contract','contract-sign-reminder','ukrainian','Contract Sign Reminder (Sent to Customer) [ukrainian]','Contract Sign Reminder','','{companyname} | CRM',NULL,0,1,0),(2894,'client','affiliate_management_payout_updated','ukrainian','Affiliate Payout Request Update [ukrainian]','An update regarding your payout request','','{companyname} | CRM',NULL,0,1,0),(2895,'client','affiliate_management_signup_through_affiliate_link','ukrainian','Successful Signup through Affiliate Link [ukrainian]','Congratulations on a successful signup!','','{companyname} | CRM',NULL,0,1,0),(2896,'client','affiliate_management_successful_referral_commission','ukrainian','Successful Referral Commission Notification [ukrainian]','A referral commission received!','','{companyname} | CRM',NULL,0,1,0),(2897,'staff','affiliate_management_new_payout_request_for_admin','ukrainian','Affiliate Payout Request [ukrainian]','You have new affiliate payout request','','{companyname} | CRM',NULL,0,1,0),(2898,'staff','affiliate_management_payout_updated_for_admin','ukrainian','Affiliate Payout Request Updated [ukrainian]','You marked payout: #{payout_id} as {payout_status}','','{companyname} | CRM',NULL,0,1,0),(2899,'staff','affiliate_management_new_affiliate_signup_for_admin','ukrainian','New Affiliate Signup [ukrainian]','A new affiliate signup','','{companyname} | CRM',NULL,0,1,0),(2900,'client','affiliate_management_referral_commission_reversal','ukrainian','Referral Commission Reversal Notification [ukrainian]','A referral commission was reversed!','','{companyname} | CRM',NULL,0,1,0),(2901,'file_sharing','fs-share-staff','ukrainian','Shared to staff [ukrainian]','File Sharing','','{companyname} | ERP','',0,1,0),(2902,'file_sharing','fs-share-client','ukrainian','Shared to client [ukrainian]','File Sharing','','{companyname} | CRM',NULL,0,1,0),(2903,'file_sharing','fs-share-public','ukrainian','Shared to public [ukrainian]','File Sharing','','{companyname} | CRM',NULL,0,1,0),(2905,'inventory_warning','inventory-warning-to-staff','ukrainian','Inventory warning (Sent to staff) [ukrainian]','Inventory warning','','{companyname} | CRM',NULL,0,1,0),(2906,'purchase_order','purchase-order-to-contact','ukrainian','Purchase Order (Sent to contact) [ukrainian]','Purchase Order','','{companyname} | CRM',NULL,0,1,0),(2907,'purchase_order','purchase-request-to-contact','ukrainian','Purchase Request (Sent to contact) [ukrainian]','Purchase Request','','{companyname} | CRM',NULL,0,1,0),(2908,'purchase_order','purchase-quotation-to-contact','ukrainian','Purchase Quotation (Sent to contact) [ukrainian]','Purchase Quotation','','{companyname} | CRM',NULL,0,1,0),(2909,'purchase_order','debit-note-to-contact','ukrainian','Debit Note (Sent to contact) [ukrainian]','Debit Note','','{companyname} | CRM',NULL,0,1,0),(2910,'purchase_order','purchase-statement-to-contact','ukrainian','Purchase Statement (Sent to contact) [ukrainian]','Purchase Statement','','{companyname} | CRM',NULL,0,1,0),(2911,'purchase_order','vendor-registration-confirmed','ukrainian','Vendor Registration Confirmed [ukrainian]','Your registration is confirmed','','{companyname} | CRM',NULL,0,1,0),(2912,'purchase_order','purchase-contract-to-contact','ukrainian','Purchase Contract (Sent to contact) [ukrainian]','Purchase Contract','','{companyname} | CRM',NULL,0,1,0),(2913,'purchase_order','new-contact-created','ukrainian','New Contact Added/Registered (Welcome Email) [ukrainian]','New Contact Added/Registered (Welcome Email)','','{companyname} | CRM',NULL,0,1,0),(2914,'purchase_order','purchase-request-approval','ukrainian','Request approval [ukrainian]','Request approval','','{companyname} | CRM',NULL,0,1,0),(2915,'purchase_order','purchase-send-approved','ukrainian','Email send approved [ukrainian]','Email send approved','','{companyname} | CRM',NULL,0,1,0),(2916,'purchase_order','purchase-send-rejected','ukrainian','Email send rejected [ukrainian]','Email send rejected','','{companyname} | CRM',NULL,0,1,0),(3918,'notifications','funds-requested','english','New Fund Request (sent admin)','New Fund Request','<p>Hello staff_name,<br><br>We wanted to inform you that there is a new Fund Request fund_request_number .<br><br>Login to see more details.</p>\r\n<p>Kind Regards,<br><br></p>','{companyname} | Speed and Dependability','',0,1,0),(3919,'notifications','funds-requested','greek','New Fund Request (sent admin) [greek]','New Fund Request','','{companyname} | Speed and Dependability','',0,1,0),(3920,'notifications','funds-requested','chinese','New Fund Request (sent admin) [chinese]','New Fund Request','','{companyname} | Speed and Dependability','',0,1,0),(3921,'notifications','funds-requested','norwegian','New Fund Request (sent admin) [norwegian]','New Fund Request','','{companyname} | Speed and Dependability','',0,1,0),(3922,'notifications','funds-requested','dutch','New Fund Request (sent admin) [dutch]','New Fund Request','','{companyname} | Speed and Dependability','',0,1,0),(3923,'notifications','funds-requested','czech','New Fund Request (sent admin) [czech]','New Fund Request','','{companyname} | Speed and Dependability','',0,1,0),(3924,'notifications','funds-requested','catalan','New Fund Request (sent admin) [catalan]','New Fund Request','','{companyname} | Speed and Dependability','',0,1,0),(3925,'notifications','funds-requested','swedish','New Fund Request (sent admin) [swedish]','New Fund Request','','{companyname} | Speed and Dependability','',0,1,0),(3926,'notifications','funds-requested','romanian','New Fund Request (sent admin) [romanian]','New Fund Request','','{companyname} | Speed and Dependability','',0,1,0),(3927,'notifications','funds-requested','portuguese_br','New Fund Request (sent admin) [portuguese_br]','New Fund Request','','{companyname} | Speed and Dependability','',0,1,0),(3928,'notifications','funds-requested','turkish','New Fund Request (sent admin) [turkish]','New Fund Request','','{companyname} | Speed and Dependability','',0,1,0),(3929,'notifications','funds-requested','italian','New Fund Request (sent admin) [italian]','New Fund Request','','{companyname} | Speed and Dependability','',0,1,0),(3930,'notifications','funds-requested','indonesia','New Fund Request (sent admin) [indonesia]','New Fund Request','','{companyname} | Speed and Dependability','',0,1,0),(3931,'notifications','funds-requested','russian','New Fund Request (sent admin) [russian]','New Fund Request','','{companyname} | Speed and Dependability','',0,1,0),(3932,'notifications','funds-requested','spanish','New Fund Request (sent admin) [spanish]','New Fund Request','','{companyname} | Speed and Dependability','',0,1,0),(3933,'notifications','funds-requested','slovak','New Fund Request (sent admin) [slovak]','New Fund Request','','{companyname} | Speed and Dependability','',0,1,0),(3934,'notifications','funds-requested','bulgarian','New Fund Request (sent admin) [bulgarian]','New Fund Request','','{companyname} | Speed and Dependability','',0,1,0),(3935,'notifications','funds-requested','portuguese','New Fund Request (sent admin) [portuguese]','New Fund Request','','{companyname} | Speed and Dependability','',0,1,0),(3936,'notifications','funds-requested','francais_canada','New Fund Request (sent admin) [francais_canada]','New Fund Request','','{companyname} | Speed and Dependability','',0,1,0),(3937,'notifications','funds-requested','vietnamese','New Fund Request (sent admin) [vietnamese]','New Fund Request','','{companyname} | Speed and Dependability','',0,1,0),(3938,'notifications','funds-requested','persian','New Fund Request (sent admin) [persian]','New Fund Request','','{companyname} | Speed and Dependability','',0,1,0),(3939,'notifications','funds-requested','finnish','New Fund Request (sent admin) [finnish]','New Fund Request','','{companyname} | Speed and Dependability','',0,1,0),(3940,'notifications','funds-requested','german','New Fund Request (sent admin) [german]','New Fund Request','','{companyname} | Speed and Dependability','',0,1,0),(3941,'notifications','funds-requested','japanese','New Fund Request (sent admin) [japanese]','New Fund Request','','{companyname} | Speed and Dependability','',0,1,0),(3942,'notifications','funds-requested','polish','New Fund Request (sent admin) [polish]','New Fund Request','','{companyname} | Speed and Dependability','',0,1,0),(3943,'notifications','funds-requested','french','New Fund Request (sent admin) [french]','New Fund Request','','{companyname} | Speed and Dependability','',0,1,0),(3944,'notifications','funds-requested','ukrainian','New Fund Request (sent admin) [ukrainian]','New Fund Request','','{companyname} | Speed and Dependability','',0,1,0),(6357,'notifications','event-due-registration','greek','Event Registration (sent client) [greek]','event_name, date, location','','{companyname}','',0,1,0),(6358,'notifications','event-reminder','greek','Event Reminder (sent client) [greek]','Upcoming Event Reminder','','{companyname}','',0,1,0),(6359,'notifications','event-due-registration','chinese','Event Registration (sent client) [chinese]','event_name, date, location','','{companyname}','',0,1,0),(6360,'notifications','event-reminder','chinese','Event Reminder (sent client) [chinese]','Upcoming Event Reminder','','{companyname}','',0,1,0),(6361,'notifications','event-due-registration','norwegian','Event Registration (sent client) [norwegian]','event_name, date, location','','{companyname}','',0,1,0),(6362,'notifications','event-reminder','norwegian','Event Reminder (sent client) [norwegian]','Upcoming Event Reminder','','{companyname}','',0,1,0),(6363,'notifications','event-due-registration','dutch','Event Registration (sent client) [dutch]','event_name, date, location','','{companyname}','',0,1,0),(6364,'notifications','event-reminder','dutch','Event Reminder (sent client) [dutch]','Upcoming Event Reminder','','{companyname}','',0,1,0),(6365,'notifications','event-due-registration','czech','Event Registration (sent client) [czech]','event_name, date, location','','{companyname}','',0,1,0),(6366,'notifications','event-reminder','czech','Event Reminder (sent client) [czech]','Upcoming Event Reminder','','{companyname}','',0,1,0),(6367,'notifications','event-due-registration','catalan','Event Registration (sent client) [catalan]','event_name, date, location','','{companyname}','',0,1,0),(6368,'notifications','event-reminder','catalan','Event Reminder (sent client) [catalan]','Upcoming Event Reminder','','{companyname}','',0,1,0),(6369,'notifications','event-due-registration','swedish','Event Registration (sent client) [swedish]','event_name, date, location','','{companyname}','',0,1,0),(6370,'notifications','event-reminder','swedish','Event Reminder (sent client) [swedish]','Upcoming Event Reminder','','{companyname}','',0,1,0),(6371,'notifications','event-due-registration','romanian','Event Registration (sent client) [romanian]','event_name, date, location','','{companyname}','',0,1,0),(6372,'notifications','event-reminder','romanian','Event Reminder (sent client) [romanian]','Upcoming Event Reminder','','{companyname}','',0,1,0),(6373,'notifications','event-due-registration','portuguese_br','Event Registration (sent client) [portuguese_br]','event_name, date, location','','{companyname}','',0,1,0),(6374,'notifications','event-reminder','portuguese_br','Event Reminder (sent client) [portuguese_br]','Upcoming Event Reminder','','{companyname}','',0,1,0),(6375,'notifications','event-due-registration','turkish','Event Registration (sent client) [turkish]','event_name, date, location','','{companyname}','',0,1,0),(6376,'notifications','event-reminder','turkish','Event Reminder (sent client) [turkish]','Upcoming Event Reminder','','{companyname}','',0,1,0),(6377,'notifications','event-due-registration','italian','Event Registration (sent client) [italian]','event_name, date, location','','{companyname}','',0,1,0),(6378,'notifications','event-reminder','italian','Event Reminder (sent client) [italian]','Upcoming Event Reminder','','{companyname}','',0,1,0),(6379,'notifications','event-due-registration','indonesia','Event Registration (sent client) [indonesia]','event_name, date, location','','{companyname}','',0,1,0),(6380,'notifications','event-reminder','indonesia','Event Reminder (sent client) [indonesia]','Upcoming Event Reminder','','{companyname}','',0,1,0),(6381,'notifications','event-due-registration','russian','Event Registration (sent client) [russian]','event_name, date, location','','{companyname}','',0,1,0),(6382,'notifications','event-reminder','russian','Event Reminder (sent client) [russian]','Upcoming Event Reminder','','{companyname}','',0,1,0),(6383,'notifications','event-due-registration','spanish','Event Registration (sent client) [spanish]','event_name, date, location','','{companyname}','',0,1,0),(6384,'notifications','event-reminder','spanish','Event Reminder (sent client) [spanish]','Upcoming Event Reminder','','{companyname}','',0,1,0),(6385,'notifications','event-due-registration','slovak','Event Registration (sent client) [slovak]','event_name, date, location','','{companyname}','',0,1,0),(6386,'notifications','event-reminder','slovak','Event Reminder (sent client) [slovak]','Upcoming Event Reminder','','{companyname}','',0,1,0),(6387,'notifications','event-due-registration','bulgarian','Event Registration (sent client) [bulgarian]','event_name, date, location','','{companyname}','',0,1,0),(6388,'notifications','event-reminder','bulgarian','Event Reminder (sent client) [bulgarian]','Upcoming Event Reminder','','{companyname}','',0,1,0),(6389,'notifications','event-due-registration','portuguese','Event Registration (sent client) [portuguese]','event_name, date, location','','{companyname}','',0,1,0),(6390,'notifications','event-reminder','portuguese','Event Reminder (sent client) [portuguese]','Upcoming Event Reminder','','{companyname}','',0,1,0),(6391,'notifications','event-due-registration','francais_canada','Event Registration (sent client) [francais_canada]','event_name, date, location','','{companyname}','',0,1,0),(6392,'notifications','event-reminder','francais_canada','Event Reminder (sent client) [francais_canada]','Upcoming Event Reminder','','{companyname}','',0,1,0),(6393,'notifications','event-due-registration','vietnamese','Event Registration (sent client) [vietnamese]','event_name, date, location','','{companyname}','',0,1,0),(6394,'notifications','event-reminder','vietnamese','Event Reminder (sent client) [vietnamese]','Upcoming Event Reminder','','{companyname}','',0,1,0),(6395,'notifications','event-due-registration','persian','Event Registration (sent client) [persian]','event_name, date, location','','{companyname}','',0,1,0),(6396,'notifications','event-reminder','persian','Event Reminder (sent client) [persian]','Upcoming Event Reminder','','{companyname}','',0,1,0),(6397,'notifications','event-due-registration','finnish','Event Registration (sent client) [finnish]','event_name, date, location','','{companyname}','',0,1,0),(6398,'notifications','event-reminder','finnish','Event Reminder (sent client) [finnish]','Upcoming Event Reminder','','{companyname}','',0,1,0),(6399,'notifications','event-due-registration','german','Event Registration (sent client) [german]','event_name, date, location','','{companyname}','',0,1,0),(6400,'notifications','event-reminder','german','Event Reminder (sent client) [german]','Upcoming Event Reminder','','{companyname}','',0,1,0),(6401,'notifications','event-due-registration','japanese','Event Registration (sent client) [japanese]','event_name, date, location','','{companyname}','',0,1,0),(6402,'notifications','event-reminder','japanese','Event Reminder (sent client) [japanese]','Upcoming Event Reminder','','{companyname}','',0,1,0),(6403,'notifications','event-due-registration','polish','Event Registration (sent client) [polish]','event_name, date, location','','{companyname}','',0,1,0),(6404,'notifications','event-reminder','polish','Event Reminder (sent client) [polish]','Upcoming Event Reminder','','{companyname}','',0,1,0),(6405,'notifications','event-due-registration','french','Event Registration (sent client) [french]','event_name, date, location','','{companyname}','',0,1,0),(6406,'notifications','event-reminder','french','Event Reminder (sent client) [french]','Upcoming Event Reminder','','{companyname}','',0,1,0),(6407,'notifications','event-due-registration','ukrainian','Event Registration (sent client) [ukrainian]','event_name, date, location','','{companyname}','',0,1,0),(6408,'notifications','event-reminder','ukrainian','Event Reminder (sent client) [ukrainian]','Upcoming Event Reminder','','{companyname}','',0,1,0),(17457,'notifications','event-status-notification','polish','Event Status Update (sent to staff) [polish]','Client Event Status List','','{companyname}','',0,1,0),(17458,'notifications','event-status-notification','indonesia','Event Status Update (sent to staff) [indonesia]','Client Event Status List','','{companyname}','',0,1,0),(17459,'notifications','event-status-notification','german','Event Status Update (sent to staff) [german]','Client Event Status List','','{companyname}','',0,1,0),(17460,'notifications','event-status-notification','czech','Event Status Update (sent to staff) [czech]','Client Event Status List','','{companyname}','',0,1,0),(17461,'notifications','event-status-notification','francais_canada','Event Status Update (sent to staff) [francais_canada]','Client Event Status List','','{companyname}','',0,1,0),(17462,'notifications','event-status-notification','portuguese','Event Status Update (sent to staff) [portuguese]','Client Event Status List','','{companyname}','',0,1,0),(17463,'notifications','event-status-notification','norwegian','Event Status Update (sent to staff) [norwegian]','Client Event Status List','','{companyname}','',0,1,0),(17464,'notifications','event-status-notification','portuguese_br','Event Status Update (sent to staff) [portuguese_br]','Client Event Status List','','{companyname}','',0,1,0),(17465,'notifications','event-status-notification','romanian','Event Status Update (sent to staff) [romanian]','Client Event Status List','','{companyname}','',0,1,0),(17466,'notifications','event-status-notification','russian','Event Status Update (sent to staff) [russian]','Client Event Status List','','{companyname}','',0,1,0),(17467,'notifications','event-status-notification','finnish','Event Status Update (sent to staff) [finnish]','Client Event Status List','','{companyname}','',0,1,0),(17468,'notifications','event-status-notification','bulgarian','Event Status Update (sent to staff) [bulgarian]','Client Event Status List','','{companyname}','',0,1,0),(17469,'notifications','event-status-notification','greek','Event Status Update (sent to staff) [greek]','Client Event Status List','','{companyname}','',0,1,0),(17470,'notifications','event-status-notification','italian','Event Status Update (sent to staff) [italian]','Client Event Status List','','{companyname}','',0,1,0),(17471,'notifications','event-status-notification','swedish','Event Status Update (sent to staff) [swedish]','Client Event Status List','','{companyname}','',0,1,0),(17472,'notifications','event-status-notification','dutch','Event Status Update (sent to staff) [dutch]','Client Event Status List','','{companyname}','',0,1,0),(17473,'notifications','event-status-notification','persian','Event Status Update (sent to staff) [persian]','Client Event Status List','','{companyname}','',0,1,0),(17474,'notifications','event-status-notification','vietnamese','Event Status Update (sent to staff) [vietnamese]','Client Event Status List','','{companyname}','',0,1,0),(17475,'notifications','event-status-notification','spanish','Event Status Update (sent to staff) [spanish]','Client Event Status List','','{companyname}','',0,1,0),(17476,'notifications','event-status-notification','ukrainian','Event Status Update (sent to staff) [ukrainian]','Client Event Status List','','{companyname}','',0,1,0),(17477,'notifications','event-status-notification','catalan','Event Status Update (sent to staff) [catalan]','Client Event Status List','','{companyname}','',0,1,0),(17478,'notifications','event-status-notification','japanese','Event Status Update (sent to staff) [japanese]','Client Event Status List','','{companyname}','',0,1,0),(17479,'notifications','event-status-notification','turkish','Event Status Update (sent to staff) [turkish]','Client Event Status List','','{companyname}','',0,1,0),(17480,'notifications','event-status-notification','chinese','Event Status Update (sent to staff) [chinese]','Client Event Status List','','{companyname}','',0,1,0),(17481,'notifications','event-status-notification','french','Event Status Update (sent to staff) [french]','Client Event Status List','','{companyname}','',0,1,0),(17482,'notifications','event-status-notification','slovak','Event Status Update (sent to staff) [slovak]','Client Event Status List','','{companyname}','',0,1,0),(17487,'notifications','welcome-email','polish','Event Welcome Email (sent client) [polish]','event_name, date, location','','{companyname}',NULL,0,1,0),(17488,'notifications','welcome-email','indonesia','Event Welcome Email (sent client) [indonesia]','event_name, date, location','','{companyname}',NULL,0,1,0),(17489,'notifications','welcome-email','german','Event Welcome Email (sent client) [german]','event_name, date, location','','{companyname}',NULL,0,1,0),(17490,'notifications','welcome-email','czech','Event Welcome Email (sent client) [czech]','event_name, date, location','','{companyname}',NULL,0,1,0),(17491,'notifications','welcome-email','francais_canada','Event Welcome Email (sent client) [francais_canada]','event_name, date, location','','{companyname}',NULL,0,1,0),(17492,'notifications','welcome-email','portuguese','Event Welcome Email (sent client) [portuguese]','event_name, date, location','','{companyname}',NULL,0,1,0),(17493,'notifications','welcome-email','norwegian','Event Welcome Email (sent client) [norwegian]','event_name, date, location','','{companyname}',NULL,0,1,0),(17494,'notifications','welcome-email','portuguese_br','Event Welcome Email (sent client) [portuguese_br]','event_name, date, location','','{companyname}',NULL,0,1,0),(17495,'notifications','welcome-email','romanian','Event Welcome Email (sent client) [romanian]','event_name, date, location','','{companyname}',NULL,0,1,0),(17496,'notifications','welcome-email','russian','Event Welcome Email (sent client) [russian]','event_name, date, location','','{companyname}',NULL,0,1,0),(17497,'notifications','welcome-email','finnish','Event Welcome Email (sent client) [finnish]','event_name, date, location','','{companyname}',NULL,0,1,0),(17498,'notifications','welcome-email','bulgarian','Event Welcome Email (sent client) [bulgarian]','event_name, date, location','','{companyname}',NULL,0,1,0),(17499,'notifications','welcome-email','greek','Event Welcome Email (sent client) [greek]','event_name, date, location','','{companyname}',NULL,0,1,0),(17500,'notifications','welcome-email','italian','Event Welcome Email (sent client) [italian]','event_name, date, location','','{companyname}',NULL,0,1,0),(17501,'notifications','welcome-email','swedish','Event Welcome Email (sent client) [swedish]','event_name, date, location','','{companyname}',NULL,0,1,0),(17502,'notifications','welcome-email','dutch','Event Welcome Email (sent client) [dutch]','event_name, date, location','','{companyname}',NULL,0,1,0),(17503,'notifications','welcome-email','persian','Event Welcome Email (sent client) [persian]','event_name, date, location','','{companyname}',NULL,0,1,0),(17504,'notifications','welcome-email','vietnamese','Event Welcome Email (sent client) [vietnamese]','event_name, date, location','','{companyname}',NULL,0,1,0),(17505,'notifications','welcome-email','spanish','Event Welcome Email (sent client) [spanish]','event_name, date, location','','{companyname}',NULL,0,1,0),(17506,'notifications','welcome-email','ukrainian','Event Welcome Email (sent client) [ukrainian]','event_name, date, location','','{companyname}',NULL,0,1,0),(17507,'notifications','welcome-email','catalan','Event Welcome Email (sent client) [catalan]','event_name, date, location','','{companyname}',NULL,0,1,0),(17508,'notifications','welcome-email','japanese','Event Welcome Email (sent client) [japanese]','event_name, date, location','','{companyname}',NULL,0,1,0),(17509,'notifications','welcome-email','turkish','Event Welcome Email (sent client) [turkish]','event_name, date, location','','{companyname}',NULL,0,1,0),(17510,'notifications','welcome-email','chinese','Event Welcome Email (sent client) [chinese]','event_name, date, location','','{companyname}',NULL,0,1,0),(17511,'notifications','welcome-email','french','Event Welcome Email (sent client) [french]','event_name, date, location','','{companyname}',NULL,0,1,0),(17512,'notifications','welcome-email','slovak','Event Welcome Email (sent client) [slovak]','event_name, date, location','','{companyname}',NULL,0,1,0),(17513,'notifications','event-due-registration','english','Event Registration (sent client)','event_name, date, location','<div>\r\n<p style=\"margin: 0in; text-align: justify;\"><b><span style=\"font-size: 10pt; font-family: \'Century Gothic\', sans-serif; color: #2e75b6;\">Dear client_name,</span></b></p>\r\n<p><b><i><u><span style=\"font-size: 10pt; font-family: \'Century Gothic\', sans-serif; color: #2e75b6; background: #FFFFFF;\">THIS EVENT </span></u></i></b><a href=\"https://www.capabuil.com/wp-content/uploads/2023/06/CAPABUIL-LTD-JUL-DEC-2023-NITA-Certified-CPD-Calendar-New-version.pdf\"><b><i><span style=\"font-size: 10pt; font-family: \'Century Gothic\', sans-serif; color: #2e75b6; background: #FFFFFF;\"><span>WILL</span></span></i></b></a><b><i><u><span style=\"font-size: 10pt; font-family: \'Century Gothic\', sans-serif; color: #2e75b6; background: #FFFFFF;\"> NOT BE CANCELLED OR POSTPONED</span></u></i></b></p>\r\n<p style=\"margin-right: 26.05pt;\"><em><span style=\"font-size: 10pt; font-family: \'Century Gothic\', sans-serif; color: #222222; background: #FFFFFF; font-style: normal;\">We acknowledge your dedication to expand your professional horizons in the journey of career growth and development; thank you for choosing us.</span></em></p>\r\n<p style=\"margin-right: 26.05pt;\"><em><b><span style=\"font-size: 10pt; font-family: \'Century Gothic\', sans-serif; color: #2e75b6; background: #FFFFFF; font-style: normal;\">TRAINING:</span></b></em> <em><span style=\"font-size: 10pt; font-family: \'Century Gothic\', sans-serif; color: #222222; background: #FFFFFF; font-style: normal;\">event_name</span></em></p>\r\n<p style=\"margin-right: 18.95pt;\"><em><b><span style=\"font-size: 10pt; font-family: \'Century Gothic\', sans-serif; color: #2e75b6; background: #FFFFFF; font-style: normal;\">DATES: </span></b></em> <em><b><span style=\"font-size: 10pt; font-family: \'Century Gothic\', sans-serif; color: #000000; background: #FFFFFF; font-style: normal;\">date</span></b></em></p>\r\n<p style=\"margin-right: 18.95pt;\"><em><b><span style=\"font-size: 10pt; font-family: \'Century Gothic\', sans-serif; color: #2e75b6; background: #FFFFFF; font-style: normal;\">VENUE: </span></b></em> <em><b><span style=\"font-size: 10pt; font-family: \'Century Gothic\', sans-serif; color: #000000; background: #FFFFFF; font-style: normal;\">location</span></b></em></p>\r\n<p><em><span style=\"font-size: 10pt; font-family: \'Century Gothic\', sans-serif; color: #222222; background: #FFFFFF; font-style: normal;\">We have attached: the <b> Invitation Letter</b> &amp; <b>Proforma Invoice</b> to help you/your colleagues in getting the necessary approvals for the above-mentioned training. The <strong>Course Content </strong>will be shared within 24 Hours.</span></em></p>\r\n<p style=\"margin-right: 18.95pt;\"><a href=\"https://www.capabuil.com/download-cpd-calenders/?external=1\"><b><span>DOWNLOAD CPD TRAINING CALENDARS</span></b></a> <em><span style=\"font-size: 10pt; font-family: \'Century Gothic\', sans-serif; color: #222222; background: #FFFFFF; font-style: normal;\">to access the full listing of our competency <b>NITA &amp; ODPC APPROVED</b> programs </span></em> <em><b><span style=\"font-size: 10pt; font-family: \'Century Gothic\', sans-serif; color: #2e75b6; background: #FFFFFF; font-style: normal;\">designed to meet your researched needs, rather than standard packages.</span></b></em></p>\r\n<p style=\"text-align: justify;\"><em> <span style=\"font-size: 10pt; font-family: \'Century Gothic\', sans-serif; color: #222222; background: #FFFFFF; font-style: normal;\"> Don\'t hesitate to contact us anytime for more information/support in your learning/development - <span style=\"color: #2e75b6; font-weight: bold;\">0722-998-105</span> / <span style=\"color: #2e75b6; font-weight: bold;\">0717-165-425</span> / <span style=\"color: #2e75b6; font-weight: bold;\">0712-843-395</span> day/ night. </span> </em></p>\r\n</div>','{companyname}','',0,1,0),(17514,'notifications','event-reminder','english','Event Reminder (sent client)','event_name, date, location','<p><b>Dear client_name,</b></p>\r\n<p>We remain grateful for your trust in our affordable quality services.</p>\r\n<p><b><u style=\"color: #0070c0;\">ATTENDANCE CONFIRMATION</u></b></p>\r\n<p>Kindly confirm the Payment and Attendance Status for the training starting next week from <b>date</b> at <b>location</b>.</p>\r\n<p><b>Event Name:</b> event_name</p>\r\n<p><b>Expected Attendees:</b><br>client_list</p>\r\n<p><b><u style=\"color: #0070c0;\">PAYMENT STATUS</u></b></p>\r\n<p>As part of the business capacity recovery measures, the management has approved a policy to require clients to pay for services and seminars upfront for the upcoming months to enable stabilization of business sustainability and funding performance indicators.</p>\r\n<p>Upon approval of the training, we will also require <b>LSO/Commitment Letter</b> from your organization for record purposes.</p>\r\n<p>Kindly share the <b>Payment evidence</b> with our finance team via mail <a href=\"mailto:customerservice@capabuil.com\">customerservice@capabuil.com</a> to enable us firm up the resource facilitation by our training host as well as other service providers.</p>\r\n<p>Kind regards,</p>','{companyname}','',0,1,0),(17515,'notifications','event-status-notification','english','Event Status Update (sent to staff)','CLIENTS EVENT CONFIRMATION STATUSES','<p>event_status_content</p>\r\n<p>Regards,<br>{companyname}</p>','{companyname}','',0,1,0),(17516,'notifications','welcome-email','english','Event Welcome Email (sent client)','event_name, date, location','\n<html>\n<head>\n<meta http-equiv=Content-Type content=\"text/html; charset=windows-1252\">\n<meta name=Generator content=\"Microsoft Word 15 (filtered)\">\n<style>\n@font-face { font-family:\"Cambria Math\"; }\n@font-face { font-family:Calibri; }\n@font-face { font-family:Aptos; }\n@font-face { font-family:\"Century Gothic\"; }\np.MsoNormal, li.MsoNormal, div.MsoNormal {\n    margin:0in;\n    font-size:11.0pt;\n    font-family:\"Calibri\",sans-serif;\n}\na:link, span.MsoHyperlink {\n    color:#0563C1;\n    text-decoration:underline;\n}\np {\n    margin-right:0in;\n    margin-left:0in;\n    font-size:12.0pt;\n    font-family:\"Aptos\",sans-serif;\n}\n</style>\n</head>\n<body lang=EN-US link=\"#0563C1\" vlink=\"#954F72\" style=\"word-wrap:break-word\">\n<div>\n<p style=\"margin:0in;text-align:justify\"><b><span style=\"font-size:10.0pt;font-family:\'Century Gothic\',sans-serif;color:#2E75B6\">Dear client_name,</span></b></p>\n\n<p style=\"margin-right:26.05pt\"><em><span style=\"font-size:10.0pt;font-family:\'Century Gothic\',sans-serif;color:#222222;background:white;font-style:normal\">Thank you for choosing <b>The WORLD\'S BEST CPD PROVIDER</b>.</span></em></p>\n\n<p style=\"margin-right:26.05pt\"><span style=\"font-size:10.0pt;font-family:\'Century Gothic\',sans-serif;color:#222222;background:white;\">We\'re excited to have your colleagues join us for the <b>event_name</b>, scheduled from <b>date</b>, to <b>location</b>.</span></p>\n\n<p style=\"margin-right:26.05pt\"><span style=\"font-size:10.0pt;font-family:\'Century Gothic\',sans-serif;color:#222222;background:white;\">We have attached the <b>Program Outline, Seminar Details</b>, and <b>Information on Accommodations and Amenities</b> to help them plan their week.</span></p>\n\n<p style=\"margin-right:26.05pt\"><span style=\"font-size:10.0pt;font-family:\'Century Gothic\',sans-serif;color:#222222;background:white;\">Expect:</span></p>\n<ul>\n<li><span style=\"font-size:10.0pt;font-family:\'Century Gothic\',sans-serif;color:#222222;background:white;\">Relevant and Up-to-Date Industry Insights</span></li>\n<li><span style=\"font-size:10.0pt;font-family:\'Century Gothic\',sans-serif;color:#222222;background:white;\">Enhanced Skills and Competencies</span></li>\n<li><span style=\"font-size:10.0pt;font-family:\'Century Gothic\',sans-serif;color:#222222;background:white;\">Recognition and Accreditation</span></li>\n</ul>\n\n<p style=\"margin-right:26.05pt\"><span style=\"font-size:10.0pt;font-family:\'Century Gothic\',sans-serif;color:#222222;background:white;\">For further inquiries, reach out to the Event Facilitator directly: <b>Priscilla Nyambura</b> <b>+254 712 843395</b></span></p>\n\n<p style=\"margin:0in\"><span style=\"font-size:10.0pt;font-family:\'Century Gothic\',sans-serif;color:#2E75B6;\">Kind regards,</span></p>\n</div>\n</body>\n</html>','{companyname}',NULL,0,1,0);

--
-- Table structure for table `capabuil_tblestimate_request_forms`
--

CREATE TABLE `capabuil_tblestimate_request_forms` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `form_key` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `form_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `recaptcha` int DEFAULT NULL,
  `status` int NOT NULL,
  `submit_btn_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `submit_btn_bg_color` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '#84c529',
  `submit_btn_text_color` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '#ffffff',
  `success_submit_msg` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `submit_action` int DEFAULT '0',
  `submit_redirect_url` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `language` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dateadded` datetime DEFAULT NULL,
  `notify_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notify_ids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `responsible` int DEFAULT NULL,
  `notify_request_submitted` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `capabuil_tblestimate_request_forms`
--


--
-- Table structure for table `capabuil_tblestimate_request_status`
--

CREATE TABLE `capabuil_tblestimate_request_status` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `statusorder` int DEFAULT NULL,
  `color` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `flag` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `capabuil_tblestimate_request_status`
--

INSERT INTO `capabuil_tblestimate_request_status` VALUES (1,'Cancelled',1,'#808080','cancelled'),(2,'Processing',2,'#007bff','processing'),(3,'Completed',3,'#28a745','completed');

--
-- Table structure for table `capabuil_tblestimate_requests`
--

CREATE TABLE `capabuil_tblestimate_requests` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `submission` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_status_change` datetime DEFAULT NULL,
  `date_estimated` datetime DEFAULT NULL,
  `from_form_id` int DEFAULT NULL,
  `assigned` int DEFAULT NULL,
  `status` int DEFAULT NULL,
  `default_language` int NOT NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `capabuil_tblestimate_requests`
--


--
-- Table structure for table `capabuil_tblestimates`
--

CREATE TABLE `capabuil_tblestimates` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sent` tinyint(1) NOT NULL DEFAULT '0',
  `datesend` datetime DEFAULT NULL,
  `clientid` int NOT NULL,
  `deleted_customer_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `project_id` int NOT NULL DEFAULT '0',
  `number` int NOT NULL,
  `prefix` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number_format` int NOT NULL DEFAULT '0',
  `formatted_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hash` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `datecreated` datetime NOT NULL,
  `date` date NOT NULL,
  `expirydate` date DEFAULT NULL,
  `currency` int NOT NULL,
  `subtotal` decimal(15,2) NOT NULL,
  `total_tax` decimal(15,2) NOT NULL DEFAULT '0.00',
  `total` decimal(15,2) NOT NULL,
  `adjustment` decimal(15,2) DEFAULT NULL,
  `addedfrom` int NOT NULL,
  `status` int NOT NULL DEFAULT '1',
  `clientnote` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `adminnote` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `discount_percent` decimal(15,2) DEFAULT '0.00',
  `discount_total` decimal(15,2) DEFAULT '0.00',
  `discount_type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invoiceid` int DEFAULT NULL,
  `invoiced_date` datetime DEFAULT NULL,
  `terms` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `reference_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sale_agent` int NOT NULL DEFAULT '0',
  `billing_street` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_state` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_zip` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_country` int DEFAULT NULL,
  `shipping_street` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_state` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_zip` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_country` int DEFAULT NULL,
  `include_shipping` tinyint(1) NOT NULL,
  `show_shipping_on_estimate` tinyint(1) NOT NULL DEFAULT '1',
  `show_quantity_as` int NOT NULL DEFAULT '1',
  `pipeline_order` int DEFAULT '1',
  `is_expiry_notified` int NOT NULL DEFAULT '0',
  `acceptance_firstname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `acceptance_lastname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `acceptance_email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `acceptance_date` datetime DEFAULT NULL,
  `acceptance_ip` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `signature` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `short_link` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `clientid` (`clientid`),
  KEY `currency` (`currency`),
  KEY `project_id` (`project_id`),
  KEY `sale_agent` (`sale_agent`),
  KEY `status` (`status`),
  KEY `formatted_number` (`formatted_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `capabuil_tblestimates`
--


--
-- Table structure for table `capabuil_tblevent_attendance_sheets`
--

CREATE TABLE `capabuil_tblevent_attendance_sheets` (
  `id` int NOT NULL AUTO_INCREMENT,
  `event_id` int NOT NULL,
  `location` varchar(255) NOT NULL,
  `venue` varchar(255) NOT NULL,
  `attendance_url` text NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblevent_attendance_sheets`
--

INSERT INTO `capabuil_tblevent_attendance_sheets` VALUES (1,111,'NAKURU','MERICA HOTEL','','2025-07-09 11:50:03','2025-07-28','2025-08-01'),(4,115,'DIANI','BAOBAB HOTEL','','2025-07-10 07:00:37','2025-07-11','2025-07-12'),(11,116,'DIANI','BAOBAB HOTEL','','2025-07-10 07:51:22','2025-07-11','2025-07-11'),(16,116,'MOMBASA','SAROVA WHITESANDS HOTEL','','2025-07-10 08:16:53','2025-07-11','2025-07-11'),(20,123,'DIANI','LEOPARD BEACH RESORT','','2025-07-11 11:31:31','2025-07-14','2025-07-18'),(21,129,'MACHAKOS','SEO HOTEL','','2025-07-14 11:07:26','2025-08-04','2025-08-08'),(22,130,'MOMBASA','SAROVA WHITESANDS HOTEL','','2025-07-15 06:06:50','2025-08-25','2025-08-29'),(23,131,'MOMBASA','SAROVA WHITESANDS HOTEL','','2025-07-16 06:55:08','2025-08-04','2025-08-08'),(24,132,'THIKA','THE LUKE HOTEL','','2025-07-16 12:39:01','2025-07-21','2025-07-25'),(25,133,'MOMBASA','SAROVA WHITESANDS HOTEL','','2025-07-18 12:05:40','2025-08-25','2025-08-29'),(26,111,'NAKURU','MERICA HOTEL','','2025-07-18 14:04:44','2025-08-04','2025-08-08'),(27,111,'KISUMU','IMPERIAL SAROVA HOTEL','','2025-07-21 07:43:55','2025-08-04','2025-08-08'),(28,134,'MOMBASA','SAROVA WHITESANDS HOTEL','','2025-07-21 12:50:53','2025-08-25','2025-08-29'),(29,137,'MOMBASA','SAROVA WHITESANDS HOTEL','','2025-07-21 13:08:27','2025-08-25','2025-08-29'),(30,127,'MOMBASA','SAROVA WHITESANDS HOTEL','','2025-07-21 13:11:43','2025-08-11','2025-08-15'),(31,138,'NAIROBI','HILLPARK HOTEL','','2025-07-22 07:16:59','2025-07-23','2025-07-23'),(32,131,'MOMBASA','SAROVA WHITESANDS HOTEL','','2025-07-22 11:43:39','2025-08-03','2025-08-09'),(33,140,'MOMBASA','SAROVA WHITESANDS HOTEL','','2025-07-25 06:14:34','2025-07-28','2025-08-01'),(34,141,'NAKURU','OLE KEN HOTEL','','2025-07-25 07:44:08','2025-07-28','2025-08-01'),(35,142,'KISUMU','IMPERIAL SAROVA HOTEL','','2025-07-25 08:00:14','2025-07-28','2025-08-01');

--
-- Table structure for table `capabuil_tblevent_unique_codes`
--

CREATE TABLE `capabuil_tblevent_unique_codes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `event_id` int NOT NULL,
  `event_unique_code` varchar(100) NOT NULL,
  `location` varchar(255) NOT NULL,
  `venue` varchar(255) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblevent_unique_codes`
--

INSERT INTO `capabuil_tblevent_unique_codes` VALUES (1,4,'ABAS-MOM-MOM-030225','Mombasa','Mombasa','2025-02-03','2025-02-07','2025-07-08 11:47:03'),(2,5,'ANAL-MAC-MAC-030225','Machakos','Machakos','2025-02-03','2025-02-05','2025-07-08 11:47:03'),(3,3,'ABAB-SAR-SAR-040225','Sarova whitesands,Mombasa','Sarova whitesands,Mombasa','2025-02-04','2025-02-06','2025-07-08 11:47:03'),(4,7,'ABAR-BLO-BLO-030225','Blooming suite, Naivasha','Blooming suite, Naivasha','2025-02-03','2025-02-07','2025-07-08 11:47:03'),(5,14,'ABAP-SAR-SAR-100225','Sarova Imperial Hotel ,Kisumu','Sarova Imperial Hotel ,Kisumu','2025-02-10','2025-02-14','2025-07-08 11:47:03'),(6,7,'ABAR-BLO-BLO-100225','BLOOMING SUITE HOTEL, NAIVASHA	','BLOOMING SUITE HOTEL, NAIVASHA	','2025-02-10','2025-02-14','2025-07-08 11:47:03'),(7,8,'DSAC-SAR-MOM-210725','Mombasa','Sarova WhiteSands Hotel','2025-07-21','2025-06-27','2025-07-08 11:47:03'),(8,9,'DSAI-VIR-VIR-100225','Virtual','Virtual','2025-02-10','2025-02-22','2025-07-08 11:47:03'),(9,18,'BICM-SAR-SAR-170225','Sarova Whitesands Hotel,Mombasa','Sarova Whitesands Hotel,Mombasa','2025-02-17','2025-02-21','2025-07-08 11:47:03'),(10,14,'ABAP-MTM-MTM-170225','Mt.Meru ,Arusha','Mt.Meru ,Arusha','2025-02-17','2025-02-28','2025-07-08 11:47:03'),(11,19,'ABAD-MTM-MTM-170225','Mt.Meru ,Arusha','Mt.Meru ,Arusha','2025-02-17','2025-02-28','2025-07-08 11:47:03'),(12,17,'FUTU-SEO-SEO-170225','Seo Hotel, Machakos','Seo Hotel, Machakos','2025-02-17','2025-02-21','2025-07-08 11:47:03'),(13,16,'DATA-BLO-BLO-170225','Blooming Suites Hotel Naivasha','Blooming Suites Hotel Naivasha','2025-02-17','2025-02-21','2025-07-08 11:47:03'),(14,25,'ABAE-SAR-SAR-240225','Sarova Whitesands Hotel,Mombasa','Sarova Whitesands Hotel,Mombasa','2025-02-24','2025-02-28','2025-07-08 11:47:03'),(15,24,'ABAC-BLO-BLO-240225','BLOOMING SUITE HOTEL, NAIVASHA	','BLOOMING SUITE HOTEL, NAIVASHA	','2025-02-24','2025-02-28','2025-07-08 11:47:03'),(16,9,'DSAI-SEO-SEO-240225','Seo Hotel, Machakos','Seo Hotel, Machakos','2025-02-24','2025-02-28','2025-07-08 11:47:03'),(17,23,'EMPO-SAR-SAR-240225','Sarova Whitesands, Mombasa','Sarova Whitesands, Mombasa','2025-02-24','2025-02-28','2025-07-08 11:47:03'),(18,22,'PUBL-LEO-LEO-240225','LEOPARD BEACH RESORT & SPA, DIANI','LEOPARD BEACH RESORT & SPA, DIANI','2025-02-24','2025-02-28','2025-07-08 11:47:03'),(19,8,'DSAC-BLO-BLO-240225','Blooming Suites Hotel Naivasha','Blooming Suites Hotel Naivasha','2025-02-24','2025-02-28','2025-07-08 11:47:03'),(20,26,'ABAC-BAR-BAR-250225','Baringo','Baringo','2025-02-25','2025-02-26','2025-07-08 11:47:03'),(21,33,'REAG-KWA-KWA-280225','KWALE','KWALE','2025-02-28','2025-03-01','2025-07-08 11:47:03'),(22,41,'ABAB-ENA-ENA-040325','Enashipai Hotel ,Naivasha','Enashipai Hotel ,Naivasha','2025-03-04','2025-03-06','2025-07-08 11:47:03'),(23,40,'ABAS-SEO-SEO-030325','Seo Hotel, Machakos','Seo Hotel, Machakos','2025-03-03','2025-03-07','2025-07-08 11:47:03'),(24,36,'ABAE-SAR-SAR-030325','Sarova Whitesands Hotel,Mombasa','Sarova Whitesands Hotel,Mombasa','2025-03-03','2025-03-07','2025-07-08 11:47:03'),(25,39,'ABAM-SAR-SAR-030325','Sarova Whitesands Hotel,Mombasa','Sarova Whitesands Hotel,Mombasa','2025-03-03','2025-03-10','2025-07-08 11:47:03'),(26,39,'ABAM-MOM-MOM-030325','Mombasa','Mombasa','2025-03-03','2025-03-07','2025-07-08 11:47:03'),(27,44,'ABAN-SAR-SAR-110325','Sarova Imperial, Kisumu','Sarova Imperial, Kisumu','2025-03-11','2025-03-14','2025-07-08 11:47:03'),(28,33,'REAG-MOM-MOM-100325','MOMBASA','MOMBASA','2025-03-10','2025-03-14','2025-07-08 11:47:03'),(29,45,'OPTI-NAI-NAI-100325','NAIVASHA','NAIVASHA','2025-03-10','2025-03-14','2025-07-08 11:47:03'),(30,36,'ABAE-SAR-SAR-100325','Sarova whitesands,Mombasa','Sarova whitesands,Mombasa','2025-03-10','2025-03-14','2025-07-08 11:47:03'),(31,46,'PRIS-SAR-SAR-170325','Sarova whitesands,Mombasa','Sarova whitesands,Mombasa','2025-03-17','2025-03-21','2025-07-08 11:47:03'),(32,44,'ABAN-SAR-SAR-170325','Sarova Imperial, Kisumu','Sarova Imperial, Kisumu','2025-03-17','2025-03-19','2025-07-08 11:47:03'),(33,47,'ABAT-SAR-SAR-170325','Sarova whitesands,Mombasa','Sarova whitesands,Mombasa','2025-03-17','2025-03-21','2025-07-08 11:47:03'),(34,48,'PUBL-SAR-SAR-170325','Sarova Whitesands Hotel Mombasa','Sarova Whitesands Hotel Mombasa','2025-03-17','2025-03-21','2025-07-08 11:47:03'),(35,49,'ABAS-SAR-SAR-240325','Sarova Imperial, Kisumu','Sarova Imperial, Kisumu','2025-03-24','2025-03-28','2025-07-08 11:47:03'),(36,50,'ABAS-SAR-SAR-240325','Sarova Imperial, Kisumu','Sarova Imperial, Kisumu','2025-03-24','2025-03-28','2025-07-08 11:47:03'),(37,51,'ULTI-SAR-SAR-240325','Sarova Whitesands Hotel Mombasa','Sarova Whitesands Hotel Mombasa','2025-03-24','2025-03-28','2025-07-08 11:47:03'),(38,52,'ABAM-NEE-NEE-310325','Neelkanth Sarovar Premier Hotel, Lusaka','Neelkanth Sarovar Premier Hotel, Lusaka','2025-03-31','2025-04-04','2025-07-08 11:47:03'),(39,49,'ABAS-MOM-MOM-240325','Mombasa','Mombasa','2025-03-24','2025-03-28','2025-07-08 11:47:03'),(40,53,'ABAR-SAR-SAR-310325','Sarova whitesands,Mombasa','Sarova whitesands,Mombasa','2025-03-31','2025-04-04','2025-07-08 11:47:03'),(41,53,'ABAR-MOM-MOM-310325','Mombasa','Mombasa','2025-03-31','2025-04-04','2025-07-08 11:47:03'),(42,54,'ABAS-MOM-MOM-310325','Mombasa','Mombasa','2025-03-31','2025-04-04','2025-07-08 11:47:03'),(43,55,'DSAI-MOM-MOM-070425','Mombasa','Mombasa','2025-04-07','2025-04-11','2025-07-08 11:47:03'),(44,63,'ABAR-SAR-SAR-070425','Sarova whitesands,Mombasa','Sarova whitesands,Mombasa','2025-04-07','2025-04-11','2025-07-08 11:47:03'),(45,61,'ABAB-SAR-SAR-070425','Sarova whitesands,Mombasa','Sarova whitesands,Mombasa','2025-04-07','2025-04-11','2025-07-08 11:47:03'),(46,5,'ANAL-SEO-SEO-070425','Seo Hotel Machakos','Seo Hotel Machakos','2025-04-07','2025-04-11','2025-07-08 11:47:03'),(47,64,'FESG-MAC-MAC-070425','machakos','machakos','2025-04-07','2025-04-10','2025-07-08 11:47:03'),(48,62,'FESG-KIS-KIS-070425','kisumu','kisumu','2025-04-07','2025-04-11','2025-07-08 11:47:03'),(49,73,'ABAN-BLO-BLO-140425','Blooming suite, Naivasha','Blooming suite, Naivasha','2025-04-14','2025-04-18','2025-07-08 11:47:03'),(50,66,'UNIQ-BLO-BLO-140425','Blooming Suites Hotel Naivasha','Blooming Suites Hotel Naivasha','2025-04-14','2025-04-18','2025-07-08 11:47:03'),(51,67,'PART-SEO-SEO-140425','Seo Hotel Machakos','Seo Hotel Machakos','2025-04-14','2025-04-15','2025-07-08 11:47:03'),(52,72,'ABAE-SAR-SAR-140425','Sarova whitesands,Mombasa','Sarova whitesands,Mombasa','2025-04-14','2025-04-18','2025-07-08 11:47:03'),(53,71,'LEVE-SEO-SEO-140425','Seo Hotel Machakos','Seo Hotel Machakos','2025-04-14','2025-04-18','2025-07-08 11:47:03'),(54,75,'ABAU-SAR-SAR-140425','Sarova whitesands,Mombasa','Sarova whitesands,Mombasa','2025-04-14','2025-04-18','2025-07-08 11:47:03'),(55,74,'ABAN-SAR-SAR-140425','Sarova whitesands,Mombasa','Sarova whitesands,Mombasa','2025-04-14','2025-04-18','2025-07-08 11:47:03'),(56,69,'WEEK-MOM-MOM-140425','Mombasa','Mombasa','2025-04-14','2025-04-18','2025-07-08 11:47:03'),(57,70,'WEEK-SEO-SEO-140425','Seo Hotel, Machakos','Seo Hotel, Machakos','2025-04-14','2025-04-18','2025-07-08 11:47:03'),(58,70,'WEEK-SEO-SEO-140425','Seo Hotel Machakos','Seo Hotel Machakos','2025-04-14','2025-04-17','2025-07-08 11:47:03'),(59,82,'ASSE-MOM-MOM-210425','Mombasa','Mombasa','2025-04-21','2025-04-25','2025-07-08 11:47:03'),(60,79,'ABAB-SAR-SAR-140425','Sarova whitesands,Mombasa','Sarova whitesands,Mombasa','2025-04-14','2025-04-18','2025-07-08 11:47:03'),(61,78,'WEEK-SAR-SAR-140425','Sarova whitesands,Mombasa','Sarova whitesands,Mombasa','2025-04-14','2025-04-18','2025-07-08 11:47:03'),(62,77,'LEVE-SEO-SEO-140425','Seo Hotel Machakos','Seo Hotel Machakos','2025-04-14','2025-04-18','2025-07-08 11:47:03'),(63,81,'PUBL-SEO-SEO-210425','Seo Hotel Machakos','Seo Hotel Machakos','2025-04-21','2025-04-25','2025-07-08 11:47:03'),(64,84,'ABAB-SAR-SAR-140425','Sarova whitesands,Mombasa','Sarova whitesands,Mombasa','2025-04-14','2025-04-18','2025-07-08 11:47:03'),(65,85,'DSAI-MAA-MAC-280425','MACHAKOS','MAANZONI LODGE','2025-04-28','2025-05-02','2025-07-08 11:47:03'),(66,87,'FESG-BLO-NAI-280425','NAIVASHA','BLOOMING SUITES HOTEL','2025-04-28','2025-05-02','2025-07-08 11:47:03'),(67,108,'SQLT-LEO-DIA-140725','DIANI','LEOPARD BEACH RESORT','2025-07-14','2025-07-18','2025-07-08 11:47:03'),(68,111,'DSAI-MER-NAK-280725','NAKURU','MERICA HOTEL','2025-07-28','2025-08-01','2025-07-09 11:50:03'),(71,115,'CAPA-BAO-DIA-110725','DIANI','BAOBAB HOTEL','2025-07-11','2025-07-12','2025-07-10 07:00:37'),(78,8,'DSAC-LEO-DIA-140725','Diani','Leopard Beach Resort','2025-07-14','2025-07-18','2025-07-10 07:51:22'),(83,116,'DAVI-SAR-MOM-110725','MOMBASA','SAROVA WHITESANDS HOTEL','2025-07-11','2025-07-11','2025-07-10 08:16:53'),(87,123,'ABAH-LEO-DIA-140725','DIANI','LEOPARD BEACH RESORT','2025-07-14','2025-07-18','2025-07-11 11:31:31'),(88,129,'BICE-SEO-MAC-040825','MACHAKOS','SEO HOTEL','2025-08-04','2025-08-08','2025-07-14 11:07:26'),(89,130,'ABAC-SAR-MOM-250825','MOMBASA','SAROVA WHITESANDS HOTEL','2025-08-25','2025-08-29','2025-07-15 06:06:50'),(90,131,'DSAI-SAR-MOM-040825','MOMBASA','SAROVA WHITESANDS HOTEL','2025-08-04','2025-08-08','2025-07-16 06:55:08'),(91,132,'BICT-THE-THI-210725','THIKA','THE LUKE HOTEL','2025-07-21','2025-07-25','2025-07-16 12:39:01'),(92,133,'ABAB-SAR-MOM-250825','MOMBASA','SAROVA WHITESANDS HOTEL','2025-08-25','2025-08-29','2025-07-18 12:05:40'),(93,111,'DSAI-MER-NAK-040825','NAKURU','MERICA HOTEL','2025-08-04','2025-08-08','2025-07-18 14:04:44'),(94,111,'DSAI-IMP-KIS-040825','KISUMU','IMPERIAL SAROVA HOTEL','2025-08-04','2025-08-08','2025-07-21 07:43:55'),(95,134,'ABAP-SAR-MOM-250825','MOMBASA','SAROVA WHITESANDS HOTEL','2025-08-25','2025-08-29','2025-07-21 12:50:53'),(96,137,'DSAI-SAR-MOM-250825','MOMBASA','SAROVA WHITESANDS HOTEL','2025-08-25','2025-08-29','2025-07-21 13:08:27'),(97,127,'DSAI-SAR-MOM-110825','MOMBASA','SAROVA WHITESANDS HOTEL','2025-08-11','2025-08-15','2025-07-21 13:11:43'),(98,138,'PROM-HIL-NAI-230725','NAIROBI','HILLPARK HOTEL','2025-07-23','2025-07-23','2025-07-22 07:16:59'),(99,131,'DSAI-SAR-MOM-030825','MOMBASA','SAROVA WHITESANDS HOTEL','2025-08-03','2025-08-09','2025-07-22 11:43:39'),(100,140,'ABAI-SAR-MOM-280725','MOMBASA','SAROVA WHITESANDS HOTEL','2025-07-28','2025-08-01','2025-07-25 06:14:34'),(101,141,'FESG-OLE-NAK-280725','NAKURU','OLE KEN HOTEL','2025-07-28','2025-08-01','2025-07-25 07:44:08'),(102,142,'DSAI-IMP-KIS-280725','KISUMU','IMPERIAL SAROVA HOTEL','2025-07-28','2025-08-01','2025-07-25 08:00:14');

--
-- Table structure for table `capabuil_tblevents`
--

CREATE TABLE `capabuil_tblevents` (
  `eventid` int NOT NULL AUTO_INCREMENT,
  `title` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `userid` int NOT NULL,
  `start` datetime NOT NULL,
  `end` datetime DEFAULT NULL,
  `public` int NOT NULL DEFAULT '0',
  `color` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `isstartnotified` tinyint(1) NOT NULL DEFAULT '0',
  `reminder_before` int NOT NULL DEFAULT '0',
  `reminder_before_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`eventid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `capabuil_tblevents`
--


--
-- Table structure for table `capabuil_tblevents_due_clients`
--

CREATE TABLE `capabuil_tblevents_due_clients` (
  `id` int NOT NULL AUTO_INCREMENT,
  `full_name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `organization_name` varchar(255) NOT NULL,
  `phone_number` varchar(20) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblevents_due_clients`
--


--
-- Table structure for table `capabuil_tblevents_due_events`
--

CREATE TABLE `capabuil_tblevents_due_events` (
  `id` int NOT NULL AUTO_INCREMENT,
  `event_name_id` int NOT NULL,
  `location_id` int NOT NULL,
  `venue_id` int NOT NULL,
  `setup` enum('Physical','Virtual') NOT NULL,
  `duration` enum('5 Days','7 Days','10 Days','14 Days') NOT NULL DEFAULT '5 Days',
  `division` varchar(255) NOT NULL,
  `type` enum('Local','International') NOT NULL,
  `cost_net` decimal(10,2) NOT NULL DEFAULT '0.00',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `start_date` varchar(255) DEFAULT NULL,
  `end_date` varchar(255) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `event_name_id` (`event_name_id`),
  KEY `location_id` (`location_id`),
  KEY `venue_id` (`venue_id`),
  CONSTRAINT `capabuil_tblevents_due_events_ibfk_1` FOREIGN KEY (`event_name_id`) REFERENCES `capabuil_tblevents_due_name` (`id`) ON DELETE CASCADE,
  CONSTRAINT `capabuil_tblevents_due_events_ibfk_2` FOREIGN KEY (`location_id`) REFERENCES `capabuil_tblevents_due_locations` (`id`) ON DELETE CASCADE,
  CONSTRAINT `capabuil_tblevents_due_events_ibfk_3` FOREIGN KEY (`venue_id`) REFERENCES `capabuil_tblevents_due_venues` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblevents_due_events`
--


--
-- Table structure for table `capabuil_tblevents_due_locations`
--

CREATE TABLE `capabuil_tblevents_due_locations` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=75143 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblevents_due_locations`
--

INSERT INTO `capabuil_tblevents_due_locations` VALUES (75127,'Diani','2025-07-08 11:47:02','2025-07-08 11:47:02'),(75128,'Mombasa','2025-07-08 11:47:02','2025-07-08 11:47:02'),(75129,'Machakos','2025-07-08 11:47:02','2025-07-08 11:47:02'),(75130,'Nakuru','2025-07-08 11:47:02','2025-07-08 11:47:02'),(75131,'Naivasha','2025-07-08 11:47:02','2025-07-08 11:47:02'),(75132,'Kisumu','2025-07-08 11:47:02','2025-07-08 11:47:02'),(75133,'Thika','2025-07-08 11:47:02','2025-07-08 11:47:02'),(75134,'Eldoret','2025-07-08 11:47:02','2025-07-08 11:47:02'),(75135,'Dubai','2025-07-08 11:47:02','2025-07-08 11:47:02'),(75136,'Nanyuki','2025-07-08 11:47:02','2025-07-08 11:47:02'),(75137,'Singapore','2025-07-08 11:47:02','2025-07-08 11:47:02'),(75138,'Nairobi','2025-07-08 11:47:02','2025-07-08 11:47:02'),(75139,'Turkey','2025-07-08 11:47:02','2025-07-08 11:47:02'),(75140,'Uganda','2025-07-08 11:47:02','2025-07-08 11:47:02'),(75141,'Tanzania','2025-07-08 11:47:02','2025-07-08 11:47:02'),(75142,'Rwanda','2025-07-08 11:47:02','2025-07-08 11:47:02');

--
-- Table structure for table `capabuil_tblevents_due_name`
--

CREATE TABLE `capabuil_tblevents_due_name` (
  `id` int NOT NULL AUTO_INCREMENT,
  `event_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblevents_due_name`
--


--
-- Table structure for table `capabuil_tblevents_due_registrations`
--

CREATE TABLE `capabuil_tblevents_due_registrations` (
  `id` int NOT NULL AUTO_INCREMENT,
  `status` enum('Pending','Confirmed','Canceled') NOT NULL DEFAULT 'Pending',
  `payment_status` enum('Pending','Paid') NOT NULL DEFAULT 'Pending',
  `invoice_sent` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `event_detail_id` int NOT NULL,
  `clients` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblevents_due_registrations`
--

INSERT INTO `capabuil_tblevents_due_registrations` VALUES (1,'Pending','Pending',0,'2025-07-09 11:50:03','2025-07-09 11:50:03',99,'a:1:{i:0;a:4:{s:10:\"first_name\";s:6:\"Vickie\";s:9:\"last_name\";s:7:\"Mburugu\";s:5:\"email\";s:19:\"vmburugu@kppf.co.ke\";s:5:\"phone\";s:10:\"0722870347\";}}'),(4,'Pending','Pending',0,'2025-07-10 07:00:37','2025-07-10 07:00:37',102,'a:1:{i:0;a:4:{s:10:\"first_name\";s:5:\"Kevin\";s:9:\"last_name\";s:5:\"Amayi\";s:5:\"email\";s:22:\"amayi@identigate.co.ke\";s:5:\"phone\";s:10:\"0795704301\";}}'),(11,'Pending','Pending',0,'2025-07-10 07:51:22','2025-07-10 07:51:22',109,'a:1:{i:0;a:4:{s:10:\"first_name\";s:5:\"david\";s:9:\"last_name\";s:6:\"Madara\";s:5:\"email\";s:20:\"amkoadavid@gmail.com\";s:5:\"phone\";s:10:\"0701020320\";}}'),(16,'Pending','Pending',0,'2025-07-10 08:16:53','2025-07-10 08:16:53',114,'a:1:{i:0;a:4:{s:10:\"first_name\";s:5:\"David\";s:9:\"last_name\";s:7:\"Amukowa\";s:5:\"email\";s:21:\"davyamukowa@gmail.com\";s:5:\"phone\";s:10:\"0701020320\";}}'),(20,'Pending','Pending',0,'2025-07-11 11:31:31','2025-07-11 11:31:31',118,'a:1:{i:0;a:4:{s:10:\"first_name\";s:7:\"Maureen\";s:9:\"last_name\";s:7:\"Nyasani\";s:5:\"email\";s:23:\"mnyasan@stima-sacco.com\";s:5:\"phone\";s:10:\"0714643397\";}}'),(21,'Pending','Pending',0,'2025-07-14 11:07:26','2025-07-14 11:07:26',119,'a:2:{i:0;a:4:{s:10:\"first_name\";s:8:\"Wycliffe\";s:9:\"last_name\";s:7:\"Museywa\";s:5:\"email\";s:17:\"museywaw@kebs.org\";s:5:\"phone\";s:10:\"0733871003\";}i:1;a:4:{s:10:\"first_name\";s:0:\"\";s:9:\"last_name\";s:0:\"\";s:5:\"email\";s:0:\"\";s:5:\"phone\";s:0:\"\";}}'),(22,'Pending','Pending',0,'2025-07-15 06:06:50','2025-07-15 06:06:50',120,'a:1:{i:0;a:4:{s:10:\"first_name\";s:5:\"Sarah\";s:9:\"last_name\";s:6:\"Munene\";s:5:\"email\";s:20:\"sarainyams@gmail.com\";s:5:\"phone\";s:13:\"+254724010673\";}}'),(23,'Pending','Pending',0,'2025-07-16 06:55:08','2025-07-28 08:08:38',121,'a:2:{i:0;a:5:{s:10:\"first_name\";s:5:\"Evans\";s:9:\"last_name\";s:6:\"Otieno\";s:5:\"email\";s:24:\"evans.otieno@unsacco.org\";s:5:\"phone\";s:10:\"0729712715\";s:20:\"attendance_confirmed\";b:1;}i:1;a:4:{s:10:\"first_name\";s:0:\"\";s:9:\"last_name\";s:0:\"\";s:5:\"email\";s:0:\"\";s:5:\"phone\";s:0:\"\";}}'),(24,'Pending','Pending',0,'2025-07-16 06:58:04','2025-07-16 06:58:04',122,'a:2:{i:0;a:4:{s:10:\"first_name\";s:5:\"Evans\";s:9:\"last_name\";s:6:\"Otieno\";s:5:\"email\";s:24:\"evans.otieno@unsacco.com\";s:5:\"phone\";s:10:\"0729712715\";}i:1;a:4:{s:10:\"first_name\";s:0:\"\";s:9:\"last_name\";s:0:\"\";s:5:\"email\";s:0:\"\";s:5:\"phone\";s:0:\"\";}}'),(25,'Pending','Pending',0,'2025-07-16 12:39:01','2025-07-16 12:39:01',123,'a:1:{i:0;a:4:{s:10:\"first_name\";s:5:\"James\";s:9:\"last_name\";s:7:\"Kariuki\";s:5:\"email\";s:24:\"jkariuki@stima-sacco.com\";s:5:\"phone\";s:13:\"+254727102318\";}}'),(26,'Pending','Pending',0,'2025-07-16 13:07:29','2025-07-16 13:07:29',124,'a:1:{i:0;a:4:{s:10:\"first_name\";s:5:\"James\";s:9:\"last_name\";s:7:\"Kariuki\";s:5:\"email\";s:24:\"jkariuki@stima-sacco.com\";s:5:\"phone\";s:13:\"+254727102318\";}}'),(27,'Pending','Pending',0,'2025-07-16 13:13:01','2025-07-16 13:13:01',125,'a:1:{i:0;a:4:{s:10:\"first_name\";s:5:\"James\";s:9:\"last_name\";s:7:\"Kariuki\";s:5:\"email\";s:24:\"jkariuki@stima-sacco.com\";s:5:\"phone\";s:13:\"+254727102318\";}}'),(28,'Pending','Pending',0,'2025-07-17 06:30:44','2025-07-17 06:30:44',126,'a:1:{i:0;a:4:{s:10:\"first_name\";s:5:\"James\";s:9:\"last_name\";s:7:\"Kariuki\";s:5:\"email\";s:24:\"jkariuki@stima-sacco.com\";s:5:\"phone\";s:3:\"N/A\";}}'),(29,'Pending','Pending',0,'2025-07-17 13:39:44','2025-07-17 13:39:44',127,'a:1:{i:0;a:4:{s:10:\"first_name\";s:6:\"Vickie\";s:9:\"last_name\";s:7:\"Mburugu\";s:5:\"email\";s:19:\"vmburugu@kppf.co.ke\";s:5:\"phone\";s:3:\"N/A\";}}'),(30,'Pending','Pending',0,'2025-07-18 12:05:40','2025-07-18 12:05:40',128,'a:1:{i:0;a:4:{s:10:\"first_name\";s:8:\"Floridah\";s:9:\"last_name\";s:7:\"Mbogori\";s:5:\"email\";s:26:\"floridah.mbogori@wef.co.ke\";s:5:\"phone\";s:3:\"n/a\";}}'),(31,'Pending','Pending',0,'2025-07-18 14:04:44','2025-07-18 14:04:44',129,'a:1:{i:0;a:4:{s:10:\"first_name\";s:6:\"Vickie\";s:9:\"last_name\";s:7:\"Mburugu\";s:5:\"email\";s:19:\"vmburugu@kppf.co.ke\";s:5:\"phone\";s:3:\"N/A\";}}'),(32,'Pending','Pending',0,'2025-07-21 07:43:55','2025-07-21 07:43:55',130,'a:1:{i:0;a:4:{s:10:\"first_name\";s:6:\"Vickie\";s:9:\"last_name\";s:7:\"Mburugu\";s:5:\"email\";s:19:\"vmburugu@kppf.co.ke\";s:5:\"phone\";s:3:\"N/A\";}}'),(33,'Pending','Pending',0,'2025-07-21 12:50:53','2025-07-21 12:50:53',131,'a:1:{i:0;a:4:{s:10:\"first_name\";s:4:\"Mary\";s:9:\"last_name\";s:4:\"Mbai\";s:5:\"email\";s:20:\"marymbai23@gmail.com\";s:5:\"phone\";s:13:\"+254710108449\";}}'),(34,'Pending','Pending',0,'2025-07-21 12:57:45','2025-07-21 12:57:45',132,'a:1:{i:0;a:4:{s:10:\"first_name\";s:4:\"Mary\";s:9:\"last_name\";s:4:\"Mbai\";s:5:\"email\";s:20:\"marymbai23@gmail.com\";s:5:\"phone\";s:3:\"N/A\";}}'),(35,'Pending','Pending',0,'2025-07-21 13:08:27','2025-07-21 13:08:27',133,'a:1:{i:0;a:4:{s:10:\"first_name\";s:4:\"Mary\";s:9:\"last_name\";s:4:\"Mbai\";s:5:\"email\";s:20:\"marymbai23@gmail.com\";s:5:\"phone\";s:13:\"+254710108449\";}}'),(36,'Pending','Pending',0,'2025-07-21 13:11:43','2025-07-21 13:11:43',134,'a:1:{i:0;a:4:{s:10:\"first_name\";s:4:\"Mary\";s:9:\"last_name\";s:4:\"Mbai\";s:5:\"email\";s:20:\"marymbai23@gmail.com\";s:5:\"phone\";s:3:\"N/A\";}}'),(37,'Pending','Pending',0,'2025-07-22 07:16:59','2025-07-22 07:16:59',135,'a:1:{i:0;a:4:{s:10:\"first_name\";s:6:\"Samuel\";s:9:\"last_name\";s:6:\"Mwenda\";s:5:\"email\";s:27:\"mbayasamuelmwenda@gmail.com\";s:5:\"phone\";s:3:\"N/A\";}}'),(38,'Pending','Pending',0,'2025-07-22 11:43:39','2025-07-22 11:43:39',136,'a:1:{i:0;a:4:{s:10:\"first_name\";s:7:\"Maurine\";s:9:\"last_name\";s:6:\"Kitoto\";s:5:\"email\";s:24:\"maurine.kitoto@kpc.co.ke\";s:5:\"phone\";s:10:\"0720063568\";}}'),(39,'Pending','Pending',0,'2025-07-22 12:35:16','2025-07-22 12:35:16',137,'a:1:{i:0;a:4:{s:10:\"first_name\";s:7:\"Maurine\";s:9:\"last_name\";s:6:\"Kitoto\";s:5:\"email\";s:24:\"maurine.kitoto@kpc.co.ke\";s:5:\"phone\";s:10:\"0720063568\";}}'),(40,'Pending','Pending',0,'2025-07-23 06:09:15','2025-07-23 06:09:15',138,'a:1:{i:0;a:4:{s:10:\"first_name\";s:8:\"Mwasambu\";s:9:\"last_name\";s:6:\"Mbango\";s:5:\"email\";s:32:\"mwasambu.mbango@kenpipesacco.com\";s:5:\"phone\";s:3:\"N?A\";}}'),(41,'Pending','Pending',0,'2025-07-25 06:14:34','2025-07-25 06:14:34',139,'a:1:{i:0;a:4:{s:10:\"first_name\";s:4:\"Ruth\";s:9:\"last_name\";s:6:\"Munene\";s:5:\"email\";s:11:\"t@gmail.com\";s:5:\"phone\";s:4:\"0781\";}}'),(42,'Pending','Pending',0,'2025-07-25 07:44:08','2025-07-25 07:44:08',140,'a:1:{i:0;a:4:{s:10:\"first_name\";s:4:\"Lily\";s:9:\"last_name\";s:3:\"Bor\";s:5:\"email\";s:27:\"mbayasamuelmwenda@gmail.com\";s:5:\"phone\";s:3:\"N/A\";}}'),(43,'Pending','Pending',0,'2025-07-25 08:00:14','2025-07-25 08:00:14',141,'a:1:{i:0;a:4:{s:10:\"first_name\";s:8:\"Margaret\";s:9:\"last_name\";s:5:\"Agola\";s:5:\"email\";s:27:\"mbayasamuelmwenda@gmail.com\";s:5:\"phone\";s:3:\"N/A\";}}');

--
-- Table structure for table `capabuil_tblevents_due_venues`
--

CREATE TABLE `capabuil_tblevents_due_venues` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `location_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=119050 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblevents_due_venues`
--

INSERT INTO `capabuil_tblevents_due_venues` VALUES (119012,'Sarova WhiteSands Hotel',75128,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119013,'Voyager Beach Resort Hotel',75128,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119014,'Bamburi Beach Hotel',75128,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119015,'Travellers Beach Hotel',75128,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119016,'Nairobi Safari Club',75138,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119017,'Clarion Hotel',75138,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119018,'HillPark Hotel',75138,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119019,'Baobab Hotel',75127,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119020,'Leopard Beach Resort',75127,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119021,'Nanyuki',75136,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119022,'Seo Hotel',75129,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119023,'Maanzoni Hotel',75129,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119024,'Maanzoni Lodge',75129,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119025,'Blooming Suites Hotel',75131,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119026,'Eseriani Hotel/Resort',75131,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119027,'Lake Naivasha Resort',75131,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119028,'Sarova Woodlands Hotel',75130,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119029,'Ole Ken Hotel',75130,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119030,'Merica Hotel',75130,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119031,'Imperial Sarova Hotel',75132,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119032,'Imperial Express Hotel',75132,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119033,'The Luke Hotel',75133,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119034,'Thika Green Golf Hotel',75133,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119035,'Boma Inn Hotel',75134,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119036,'Eka Hotel',75134,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119037,'Ibis Bencoolen',75137,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119038,'Novotel İstanbul Bosphorus',75139,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119039,'Radisson Blue, Turkey',75139,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119040,'Radisson Sisli',75139,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119041,'Grand Excelsior Hotel',75135,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119042,'Avani Hotel',75135,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119043,'Hilton Garden Inn Al Muraqabat',75135,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119044,'Land Mark Hotel',75135,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119045,'Hotel African',75140,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119046,'Golden Tullip',75140,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119047,'Mt Meru Arusha',75141,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119048,'Onomo Hotel',75142,'2025-07-08 11:47:02','2025-07-08 11:47:02'),(119049,'Park Inn by Radison Blue',75142,'2025-07-08 11:47:02','2025-07-08 11:47:02');

--
-- Table structure for table `capabuil_tblexpenses`
--

CREATE TABLE `capabuil_tblexpenses` (
  `id` int NOT NULL AUTO_INCREMENT,
  `category` int NOT NULL,
  `currency` int NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `tax` int DEFAULT NULL,
  `tax2` int NOT NULL DEFAULT '0',
  `reference_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `expense_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `clientid` int NOT NULL,
  `project_id` int NOT NULL DEFAULT '0',
  `billable` int DEFAULT '0',
  `invoiceid` int DEFAULT NULL,
  `paymentmode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date NOT NULL,
  `recurring_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `repeat_every` int DEFAULT NULL,
  `recurring` int NOT NULL DEFAULT '0',
  `cycles` int NOT NULL DEFAULT '0',
  `total_cycles` int NOT NULL DEFAULT '0',
  `custom_recurring` int NOT NULL DEFAULT '0',
  `last_recurring_date` date DEFAULT NULL,
  `create_invoice_billable` tinyint(1) DEFAULT NULL,
  `send_invoice_to_customer` tinyint(1) NOT NULL,
  `recurring_from` int DEFAULT NULL,
  `dateadded` datetime NOT NULL,
  `addedfrom` int NOT NULL,
  `vendor` int DEFAULT NULL,
  `from_fleet` int NOT NULL DEFAULT '0',
  `due_date` date DEFAULT NULL,
  `date_paid` date DEFAULT NULL,
  `status` int DEFAULT NULL,
  `is_bill` int NOT NULL DEFAULT '0',
  `reason_for_void` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `voided` int NOT NULL DEFAULT '0',
  `approved` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `clientid` (`clientid`),
  KEY `project_id` (`project_id`),
  KEY `category` (`category`),
  KEY `currency` (`currency`)
) ENGINE=InnoDB AUTO_INCREMENT=267 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `capabuil_tblexpenses`
--

INSERT INTO `capabuil_tblexpenses` VALUES (1,9,1,1000.00,0,0,'FR-20250224-24',NULL,'Miscellaneous',0,0,0,NULL,NULL,'2025-02-26',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-02-26 06:33:24',3,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(2,5,1,8000.00,0,0,'FR-20250221-23',NULL,'Hotel Accommodation',0,0,0,NULL,NULL,'2025-02-26',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-02-26 06:33:50',3,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(3,2,1,15000.00,0,0,'FR-20250221-23',NULL,'Transport',0,0,0,NULL,NULL,'2025-02-26',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-02-26 06:33:50',3,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(4,2,1,10000.00,0,0,'FR-20250221-21',NULL,'Transport',0,0,0,NULL,NULL,'2025-02-26',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-02-26 06:34:16',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(5,5,1,12000.00,0,0,'FR-20250221-21',NULL,'Hotel Accommodation',0,0,0,NULL,NULL,'2025-02-26',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-02-26 06:34:16',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(6,9,1,200.00,0,0,'FR-20250221-21',NULL,'Miscellaneous',0,0,0,NULL,NULL,'2025-02-26',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-02-26 06:34:16',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(7,2,1,11520.00,0,0,'FR-20250307-33',NULL,'Transport',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 09:46:51',3,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(8,8,1,0.00,0,0,'FR-20250307-32',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 09:48:17',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(9,6,1,0.00,0,0,'FR-20250307-32',NULL,'Airtime Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 09:48:17',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(10,7,1,0.00,0,0,'FR-20250307-32',NULL,'Client Gifts',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 09:48:17',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(11,2,1,6000.00,0,0,'FR-20250307-32',NULL,'Transport',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 09:48:17',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(12,4,1,0.00,0,0,'FR-20250307-32',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 09:48:17',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(13,3,1,0.00,0,0,'FR-20250307-32',NULL,'Printing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 09:48:17',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(14,2,1,7500.00,0,0,'FR-20250130-1',NULL,'Transport',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 18:49:43',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(15,9,1,0.00,0,0,'FR-20250130-1',NULL,'Miscellaneous',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 18:49:43',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(16,6,1,0.00,0,0,'FR-20250228-27',NULL,'Airtime Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 18:55:21',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(17,7,1,0.00,0,0,'FR-20250228-27',NULL,'Client Gifts',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 18:55:21',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(18,10,1,0.00,0,0,'FR-20250228-27',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 18:55:21',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(19,5,1,0.00,0,0,'FR-20250228-27',NULL,'Hotel Accommodation',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 18:55:21',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(20,4,1,0.00,0,0,'FR-20250228-27',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 18:55:22',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(21,9,1,0.00,0,0,'FR-20250228-27',NULL,'Miscellaneous',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 18:55:22',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(22,3,1,0.00,0,0,'FR-20250228-27',NULL,'Printing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 18:55:22',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(23,8,1,0.00,0,0,'FR-20250228-27',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 18:55:22',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(24,2,1,45500.00,0,0,'FR-20250228-27',NULL,'Transport',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 18:55:22',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(25,6,1,0.00,0,0,'FR-20250228-30',NULL,'Airtime Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 18:56:21',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(26,7,1,0.00,0,0,'FR-20250228-30',NULL,'Client Gifts',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 18:56:21',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(27,10,1,0.00,0,0,'FR-20250228-30',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 18:56:21',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(28,4,1,0.00,0,0,'FR-20250228-30',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 18:56:21',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(29,9,1,0.00,0,0,'FR-20250228-30',NULL,'Miscellaneous',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 18:56:21',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(30,3,1,0.00,0,0,'FR-20250228-30',NULL,'Printing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 18:56:21',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(31,8,1,0.00,0,0,'FR-20250228-30',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 18:56:21',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(32,2,1,4000.00,0,0,'FR-20250228-30',NULL,'Transport',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 18:56:21',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(33,6,1,0.00,0,0,'FR-20250228-29',NULL,'Airtime Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 18:57:20',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(34,7,1,0.00,0,0,'FR-20250228-29',NULL,'Client Gifts',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 18:57:20',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(35,10,1,0.00,0,0,'FR-20250228-29',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 18:57:20',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(36,5,1,0.00,0,0,'FR-20250228-29',NULL,'Hotel Accommodation',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 18:57:20',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(37,4,1,39000.00,0,0,'FR-20250228-29',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 18:57:20',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(38,9,1,0.00,0,0,'FR-20250228-29',NULL,'Miscellaneous',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 18:57:20',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(39,3,1,0.00,0,0,'FR-20250228-29',NULL,'Printing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 18:57:20',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(40,8,1,0.00,0,0,'FR-20250228-29',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 18:57:20',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(41,2,1,0.00,0,0,'FR-20250228-29',NULL,'Transport',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 18:57:20',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(42,2,1,20800.00,0,0,'FR-20250228-31',NULL,'Transport',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 18:59:45',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(43,9,1,0.00,0,0,'FR-20250228-31',NULL,'Miscellaneous',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 18:59:45',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(44,6,1,0.00,0,0,'FR-20250228-31',NULL,'Airtime Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 18:59:45',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(45,6,1,0.00,0,0,'FR-20250228-28',NULL,'Airtime Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:00:43',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(46,7,1,0.00,0,0,'FR-20250228-28',NULL,'Client Gifts',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:00:43',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(47,10,1,0.00,0,0,'FR-20250228-28',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:00:43',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(48,5,1,0.00,0,0,'FR-20250228-28',NULL,'Hotel Accommodation',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:00:43',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(49,4,1,0.00,0,0,'FR-20250228-28',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:00:43',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(50,9,1,0.00,0,0,'FR-20250228-28',NULL,'Miscellaneous',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:00:43',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(51,3,1,0.00,0,0,'FR-20250228-28',NULL,'Printing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:00:43',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(52,8,1,0.00,0,0,'FR-20250228-28',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:00:43',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(53,2,1,0.00,0,0,'FR-20250228-28',NULL,'Transport',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:00:43',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(54,10,1,2000.00,0,0,'FR-20250226-26',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:02:25',3,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(55,5,1,0.00,0,0,'FR-20250221-22',NULL,'Hotel Accommodation',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:07:16',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(56,4,1,0.00,0,0,'FR-20250221-22',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:07:16',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(57,3,1,0.00,0,0,'FR-20250221-22',NULL,'Printing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:07:16',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(58,2,1,0.00,0,0,'FR-20250221-22',NULL,'Transport',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:07:16',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(59,7,1,0.00,0,0,'FR-20250221-22',NULL,'Client Gifts',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:07:16',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(60,10,1,0.00,0,0,'FR-20250221-22',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:07:16',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(61,2,1,0.00,0,0,'FR-20250221-20',NULL,'Transport',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:10:20',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(62,9,1,0.00,0,0,'FR-20250221-20',NULL,'Miscellaneous',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:10:20',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(63,4,1,0.00,0,0,'FR-20250221-20',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:10:20',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(64,3,1,0.00,0,0,'FR-20250221-20',NULL,'Printing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:10:20',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(65,7,1,0.00,0,0,'FR-20250221-20',NULL,'Client Gifts',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:10:20',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(66,5,1,0.00,0,0,'FR-20250221-20',NULL,'Hotel Accommodation',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:10:20',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(67,10,1,0.00,0,0,'FR-20250221-20',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:10:20',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(68,4,1,0.00,0,0,'FR-20250221-19',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:11:12',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(69,2,1,0.00,0,0,'FR-20250221-19',NULL,'Transport',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:11:12',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(70,10,1,0.00,0,0,'FR-20250221-19',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:11:12',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(71,8,1,0.00,0,0,'FR-20250221-19',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:11:12',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(72,3,1,0.00,0,0,'FR-20250221-19',NULL,'Printing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:11:12',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(73,8,1,0.00,0,0,'FR-20250221-18',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:11:32',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(74,2,1,0.00,0,0,'FR-20250221-17',NULL,'Transport',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:12:20',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(75,8,1,0.00,0,0,'FR-20250221-17',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:12:20',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(76,3,1,0.00,0,0,'FR-20250221-17',NULL,'Printing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:12:20',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(77,9,1,0.00,0,0,'FR-20250221-17',NULL,'Miscellaneous',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:12:20',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(78,4,1,0.00,0,0,'FR-20250221-17',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:12:20',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(79,10,1,0.00,0,0,'FR-20250221-17',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:12:20',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(80,7,1,0.00,0,0,'FR-20250221-17',NULL,'Client Gifts',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:12:20',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(81,6,1,0.00,0,0,'FR-20250221-17',NULL,'Airtime Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:12:20',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(82,2,1,12000.00,0,0,'FR-20250214-16',NULL,'Transport',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:15:02',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(83,4,1,0.00,0,0,'FR-20250214-15',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:16:36',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(84,2,1,12000.00,0,0,'FR-20250214-15',NULL,'Transport',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:16:36',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(85,5,1,0.00,0,0,'FR-20250214-15',NULL,'Hotel Accommodation',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:16:36',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(86,3,1,0.00,0,0,'FR-20250214-15',NULL,'Printing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:16:36',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(87,8,1,0.00,0,0,'FR-20250214-15',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:16:36',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(88,6,1,0.00,0,0,'FR-20250214-15',NULL,'Airtime Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:16:36',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(89,2,1,0.00,0,0,'FR-20250214-14',NULL,'Transport',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:18:20',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(90,10,1,0.00,0,0,'FR-20250214-14',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:18:20',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(91,4,1,0.00,0,0,'FR-20250214-14',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:18:20',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(92,3,1,0.00,0,0,'FR-20250214-14',NULL,'Printing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:18:20',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(93,8,1,22500.00,0,0,'FR-20250214-13',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:19:23',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(94,3,1,0.00,0,0,'FR-20250214-13',NULL,'Printing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:19:23',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(95,6,1,0.00,0,0,'FR-20250214-13',NULL,'Airtime Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:19:23',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(96,2,1,0.00,0,0,'FR-20250214-13',NULL,'Transport',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:19:23',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(97,4,1,0.00,0,0,'FR-20250214-13',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:19:23',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(98,5,1,0.00,0,0,'FR-20250214-13',NULL,'Hotel Accommodation',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:19:23',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(99,7,1,0.00,0,0,'FR-20250214-13',NULL,'Client Gifts',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:19:23',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(100,10,1,0.00,0,0,'FR-20250214-13',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:19:23',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(101,9,1,0.00,0,0,'FR-20250214-13',NULL,'Miscellaneous',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:19:23',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(102,2,1,7600.00,0,0,'FR-20250214-10',NULL,'Transport',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:20:44',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(103,8,1,0.00,0,0,'FR-20250214-10',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:20:44',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(104,3,1,0.00,0,0,'FR-20250214-10',NULL,'Printing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:20:44',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(105,9,1,0.00,0,0,'FR-20250214-10',NULL,'Miscellaneous',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:20:44',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(106,7,1,0.00,0,0,'FR-20250214-10',NULL,'Client Gifts',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:20:44',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(107,10,1,0.00,0,0,'FR-20250214-10',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:20:44',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(108,6,1,0.00,0,0,'FR-20250214-10',NULL,'Airtime Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:20:44',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(109,8,1,0.00,0,0,'FR-20250208-9',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:22:30',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(110,10,1,0.00,0,0,'FR-20250208-9',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:22:30',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(111,2,1,3600.00,0,0,'FR-20250208-8',NULL,'Transport',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:24:14',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(112,6,1,0.00,0,0,'FR-20250208-8',NULL,'Airtime Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:24:14',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(113,8,1,0.00,0,0,'FR-20250208-8',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:24:14',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(114,2,1,12000.00,0,0,'FR-20250207-7',NULL,'Transport',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:25:51',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(115,4,1,0.00,0,0,'FR-20250207-7',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:25:51',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(116,9,1,0.00,0,0,'FR-20250207-7',NULL,'Miscellaneous',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:25:51',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(117,7,1,0.00,0,0,'FR-20250207-7',NULL,'Client Gifts',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:25:51',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(118,3,1,0.00,0,0,'FR-20250207-7',NULL,'Printing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:25:51',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(119,8,1,0.00,0,0,'FR-20250207-7',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:25:51',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(120,10,1,0.00,0,0,'FR-20250207-7',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:25:51',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(121,6,1,0.00,0,0,'FR-20250207-7',NULL,'Airtime Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:25:51',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(122,8,1,0.00,0,0,'FR-20250207-6',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:26:32',8,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(123,8,1,29700.00,0,0,'FR-20250131-5',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:28:39',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(124,2,1,0.00,0,0,'FR-20250131-5',NULL,'Transport',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:28:39',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(125,7,1,0.00,0,0,'FR-20250131-5',NULL,'Client Gifts',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:28:39',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(126,5,1,0.00,0,0,'FR-20250131-5',NULL,'Hotel Accommodation',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:28:39',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(127,4,1,0.00,0,0,'FR-20250131-5',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:28:39',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(128,9,1,0.00,0,0,'FR-20250131-5',NULL,'Miscellaneous',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:28:39',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(129,3,1,0.00,0,0,'FR-20250131-5',NULL,'Printing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:28:39',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(130,10,1,0.00,0,0,'FR-20250131-5',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:28:39',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(131,6,1,0.00,0,0,'FR-20250131-5',NULL,'Airtime Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:28:39',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(132,2,1,32950.00,0,0,'FR-20250131-3',NULL,'Transport',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:29:59',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(133,8,1,0.00,0,0,'FR-20250131-3',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:29:59',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(134,9,1,0.00,0,0,'FR-20250131-3',NULL,'Miscellaneous',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:29:59',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(135,2,1,0.00,0,0,'FR-20250131-4',NULL,'Transport',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:30:47',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(136,10,1,0.00,0,0,'FR-20250131-4',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:30:47',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(137,6,1,0.00,0,0,'FR-20250131-4',NULL,'Airtime Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:30:47',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(138,7,1,0.00,0,0,'FR-20250131-4',NULL,'Client Gifts',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:30:47',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(139,3,1,0.00,0,0,'FR-20250131-4',NULL,'Printing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:30:47',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(140,8,1,0.00,0,0,'FR-20250131-4',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:30:47',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(141,4,1,0.00,0,0,'FR-20250131-4',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:30:47',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(142,9,1,0.00,0,0,'FR-20250131-4',NULL,'Miscellaneous',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:30:47',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(143,6,1,25000.00,0,0,'FR-20250131-2',NULL,'Airtime Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:33:12',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(144,7,1,0.00,0,0,'FR-20250131-2',NULL,'Client Gifts',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:33:12',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(145,10,1,0.00,0,0,'FR-20250131-2',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:33:12',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(146,5,1,0.00,0,0,'FR-20250131-2',NULL,'Hotel Accommodation',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:33:12',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(147,4,1,0.00,0,0,'FR-20250131-2',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:33:12',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(148,3,1,0.00,0,0,'FR-20250131-2',NULL,'Printing',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:33:12',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(149,8,1,0.00,0,0,'FR-20250131-2',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:33:12',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(150,2,1,0.00,0,0,'FR-20250131-2',NULL,'Transport',0,0,0,NULL,NULL,'2025-03-12',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-12 19:33:12',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(151,10,1,10000.00,0,0,'FR-20250312-36',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-03-13',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-13 07:11:29',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(152,6,1,0.00,0,0,'FR-20250312-36',NULL,'Airtime Allowance',0,0,0,NULL,NULL,'2025-03-13',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-13 07:11:29',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(153,7,1,0.00,0,0,'FR-20250312-36',NULL,'Client Gifts',0,0,0,NULL,NULL,'2025-03-13',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-13 07:11:29',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(154,4,1,0.00,0,0,'FR-20250312-36',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-03-13',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-13 07:11:29',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(155,9,1,0.00,0,0,'FR-20250312-36',NULL,'Miscellaneous',0,0,0,NULL,NULL,'2025-03-13',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-13 07:11:30',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(156,8,1,0.00,0,0,'FR-20250312-36',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-03-13',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-13 07:11:30',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(157,10,1,14000.00,0,0,'FR-20250312-35',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-03-13',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-13 07:11:35',3,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(158,2,1,16600.00,0,0,'FR-20250313-37',NULL,'Transport',0,0,0,NULL,NULL,'2025-03-14',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-14 08:39:19',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(159,3,1,1000.00,0,0,'FR-20250313-37',NULL,'Printing',0,0,0,NULL,NULL,'2025-03-14',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-14 08:39:19',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(160,10,1,2000.00,0,0,'FR-20250326-46',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-03-27',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-27 19:20:23',3,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(161,2,1,12600.00,0,0,'FR-20250326-46',NULL,'Transport',0,0,0,NULL,NULL,'2025-03-27',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-27 19:20:23',3,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(162,9,1,3400.00,0,0,'FR-20250326-46',NULL,'Miscellaneous',0,0,0,NULL,NULL,'2025-03-27',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-03-27 19:20:23',3,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(163,10,1,18000.00,0,0,'FR-20250423-75',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-04-24',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-04-24 11:24:32',3,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(164,9,1,0.00,0,0,'FR-20250423-75',NULL,'Miscellaneous',0,0,0,NULL,NULL,'2025-04-24',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-04-24 11:24:32',3,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(165,2,1,15000.00,0,0,'FR-20250417-74',NULL,'Transport',0,0,0,NULL,NULL,'2025-04-24',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-04-24 11:26:46',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(166,5,1,0.00,0,0,'FR-20250417-74',NULL,'Hotel Accommodation',0,0,0,NULL,NULL,'2025-04-24',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-04-24 11:26:46',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(167,8,1,0.00,0,0,'FR-20250417-74',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-04-24',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-04-24 11:26:46',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(168,6,1,100.00,0,0,'FR-20250417-74',NULL,'Airtime Allowance',0,0,0,NULL,NULL,'2025-04-24',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-04-24 11:26:46',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(169,10,1,0.00,0,0,'FR-20250417-74',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-04-24',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-04-24 11:26:46',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(170,4,1,0.00,0,0,'FR-20250417-74',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-04-24',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-04-24 11:26:46',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(171,2,1,15000.00,0,0,'FR-20250417-73',NULL,'Transport',0,0,0,NULL,NULL,'2025-04-24',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-04-24 11:27:39',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(172,5,1,0.00,0,0,'FR-20250417-73',NULL,'Hotel Accommodation',0,0,0,NULL,NULL,'2025-04-24',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-04-24 11:27:39',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(173,8,1,0.00,0,0,'FR-20250417-73',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-04-24',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-04-24 11:27:39',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(174,6,1,0.00,0,0,'FR-20250417-73',NULL,'Airtime Allowance',0,0,0,NULL,NULL,'2025-04-24',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-04-24 11:27:39',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(175,10,1,0.00,0,0,'FR-20250417-73',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-04-24',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-04-24 11:27:39',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(176,4,1,0.00,0,0,'FR-20250417-73',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-04-24',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-04-24 11:27:39',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(177,2,1,0.00,0,0,'FR-20250417-72',NULL,'Transport',0,0,0,NULL,NULL,'2025-04-24',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-04-24 11:30:18',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(178,6,1,0.00,0,0,'FR-20250417-72',NULL,'Airtime Allowance',0,0,0,NULL,NULL,'2025-04-24',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-04-24 11:30:18',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(179,5,1,0.00,0,0,'FR-20250417-72',NULL,'Hotel Accommodation',0,0,0,NULL,NULL,'2025-04-24',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-04-24 11:30:18',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(180,8,1,0.00,0,0,'FR-20250417-71',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-04-24',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-04-24 11:30:56',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(181,5,1,0.00,0,0,'FR-20250417-71',NULL,'Hotel Accommodation',0,0,0,NULL,NULL,'2025-04-24',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-04-24 11:30:56',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(182,7,1,0.00,0,0,'FR-20250417-71',NULL,'Client Gifts',0,0,0,NULL,NULL,'2025-04-24',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-04-24 11:30:56',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(183,3,1,0.00,0,0,'FR-20250417-71',NULL,'Printing',0,0,0,NULL,NULL,'2025-04-24',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-04-24 11:30:56',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(184,9,1,0.00,0,0,'FR-20250417-71',NULL,'Miscellaneous',0,0,0,NULL,NULL,'2025-04-24',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-04-24 11:30:56',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(185,2,1,0.00,0,0,'FR-20250417-71',NULL,'Transport',0,0,0,NULL,NULL,'2025-04-24',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-04-24 11:30:56',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(186,4,1,0.00,0,0,'FR-20250417-71',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-04-24',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-04-24 11:30:56',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(187,2,1,15600.00,0,0,'FR-20250425-76',NULL,'Transport',0,0,0,NULL,NULL,'2025-04-25',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-04-25 11:14:41',3,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(188,10,1,2000.00,0,0,'FR-20250711-82',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-07-11',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-11 13:49:51',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(189,8,1,0.00,0,0,'FR-20250711-82',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-07-11',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-11 13:49:51',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(190,2,1,18000.00,0,0,'FR-20250711-82',NULL,'Transport',0,0,0,NULL,NULL,'2025-07-11',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-11 13:49:51',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(191,3,1,0.00,0,0,'FR-20250711-82',NULL,'Printing',0,0,0,NULL,NULL,'2025-07-11',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-11 13:49:51',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(192,9,1,210.00,0,0,'FR-20250711-82',NULL,'Miscellaneous',0,0,0,NULL,NULL,'2025-07-11',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-11 13:49:51',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(193,7,1,0.00,0,0,'FR-20250711-82',NULL,'Client Gifts',0,0,0,NULL,NULL,'2025-07-11',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-11 13:49:51',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(194,6,1,0.00,0,0,'FR-20250711-82',NULL,'Airtime Allowance',0,0,0,NULL,NULL,'2025-07-11',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-11 13:49:51',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(195,4,1,0.00,0,0,'FR-20250711-82',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-07-11',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-11 13:49:51',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(196,2,1,30600.00,0,0,'FR-20250711-81',NULL,'Transport',0,0,0,NULL,NULL,'2025-07-11',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-11 13:57:30',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(197,5,1,4000.00,0,0,'FR-20250711-81',NULL,'Hotel Accommodation',0,0,0,NULL,NULL,'2025-07-11',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-11 13:57:30',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(198,4,1,0.00,0,0,'FR-20250711-81',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-07-11',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-11 13:57:30',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(199,2,1,2000.00,0,0,'FR-20250718-83',NULL,'Transport',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 13:27:25',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(200,4,1,0.00,0,0,'FR-20250718-83',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 13:27:25',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(201,3,1,0.00,0,0,'FR-20250718-83',NULL,'Printing',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 13:27:25',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(202,8,1,0.00,0,0,'FR-20250718-83',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 13:27:25',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(203,2,1,8000.00,0,0,'FR-20250404-55',NULL,'Transport',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:12:22',3,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(204,8,1,0.00,0,0,'FR-20250314-39',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:30:12',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(205,6,1,500.00,0,0,'FR-20250314-39',NULL,'Airtime Allowance',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:30:12',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(206,3,1,0.00,0,0,'FR-20250314-39',NULL,'Printing',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:30:12',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(207,4,1,0.00,0,0,'FR-20250314-39',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:30:12',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(208,10,1,2000.00,0,0,'FR-20250314-39',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:30:12',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(209,7,1,0.00,0,0,'FR-20250314-39',NULL,'Client Gifts',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:30:12',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(210,8,1,6000.00,0,0,'FR-20250321-42',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:37:21',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(211,3,1,0.00,0,0,'FR-20250321-42',NULL,'Printing',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:37:21',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(212,4,1,0.00,0,0,'FR-20250321-42',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:37:21',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(213,10,1,0.00,0,0,'FR-20250321-42',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:37:21',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(214,7,1,0.00,0,0,'FR-20250321-42',NULL,'Client Gifts',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:37:21',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(215,9,1,105.00,0,0,'FR-20250321-42',NULL,'Miscellaneous',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:37:21',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(216,6,1,500.00,0,0,'FR-20250321-43',NULL,'Airtime Allowance',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:41:53',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(217,8,1,0.00,0,0,'FR-20250321-43',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:41:53',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(218,3,1,0.00,0,0,'FR-20250321-43',NULL,'Printing',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:41:53',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(219,4,1,0.00,0,0,'FR-20250321-43',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:41:53',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(220,10,1,0.00,0,0,'FR-20250321-43',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:41:53',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(221,7,1,0.00,0,0,'FR-20250321-43',NULL,'Client Gifts',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:41:53',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(222,9,1,0.00,0,0,'FR-20250321-43',NULL,'Miscellaneous',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:41:53',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(223,2,1,28500.00,0,0,'FR-20250315-40',NULL,'Transport',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:47:03',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(224,3,1,0.00,0,0,'FR-20250315-40',NULL,'Printing',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:47:03',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(225,5,1,0.00,0,0,'FR-20250315-40',NULL,'Hotel Accommodation',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:47:03',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(226,8,1,0.00,0,0,'FR-20250315-40',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:47:03',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(227,4,1,0.00,0,0,'FR-20250315-40',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:47:03',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(228,10,1,0.00,0,0,'FR-20250315-40',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:47:03',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(229,2,1,26600.00,0,0,'FR-20250321-44',NULL,'Transport',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:49:50',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(230,5,1,0.00,0,0,'FR-20250321-44',NULL,'Hotel Accommodation',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:49:50',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(231,3,1,0.00,0,0,'FR-20250321-44',NULL,'Printing',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:49:50',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(232,8,1,0.00,0,0,'FR-20250321-44',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:49:50',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(233,10,1,12000.00,0,0,'FR-20250321-44',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:49:50',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(234,4,1,0.00,0,0,'FR-20250321-44',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 14:49:50',5,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(235,7,1,0.00,0,0,'FR-20250328-48',NULL,'Client Gifts',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 15:03:41',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(236,2,1,13000.00,0,0,'FR-20250328-48',NULL,'Transport',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 15:03:41',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(237,10,1,0.00,0,0,'FR-20250328-48',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 15:03:41',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(238,4,1,0.00,0,0,'FR-20250328-48',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 15:03:41',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(239,3,1,0.00,0,0,'FR-20250328-48',NULL,'Printing',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 15:03:41',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(240,9,1,100.00,0,0,'FR-20250328-48',NULL,'Miscellaneous',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 15:03:41',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(241,8,1,0.00,0,0,'FR-20250328-48',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 15:03:41',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(242,6,1,0.00,0,0,'FR-20250328-48',NULL,'Airtime Allowance',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 15:03:41',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(243,5,1,0.00,0,0,'FR-20250328-48',NULL,'Hotel Accommodation',0,0,0,NULL,NULL,'2025-07-18',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-18 15:03:41',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(244,2,1,2500.00,0,0,'FR-20250722-85',NULL,'Transport',0,0,0,NULL,NULL,'2025-07-22',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-22 13:14:45',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(245,8,1,4000.00,0,0,'FR-20250722-85',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-07-22',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-22 13:14:45',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(246,2,1,16000.00,0,0,'FR-20250718-84',NULL,'Transport',0,0,0,NULL,NULL,'2025-07-23',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-23 14:16:09',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(247,7,1,0.00,0,0,'FR-20250718-84',NULL,'Client Gifts',0,0,0,NULL,NULL,'2025-07-23',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-23 14:16:09',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(248,9,1,0.00,0,0,'FR-20250718-84',NULL,'Miscellaneous',0,0,0,NULL,NULL,'2025-07-23',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-23 14:16:09',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(249,3,1,0.00,0,0,'FR-20250718-84',NULL,'Printing',0,0,0,NULL,NULL,'2025-07-23',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-23 14:16:09',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(250,2,1,34410.00,0,0,'FR-20250725-87',NULL,'Transport',0,0,0,NULL,NULL,'2025-07-25',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-25 09:53:15',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(251,5,1,0.00,0,0,'FR-20250725-87',NULL,'Hotel Accommodation',0,0,0,NULL,NULL,'2025-07-25',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-25 09:53:15',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(252,7,1,0.00,0,0,'FR-20250725-87',NULL,'Client Gifts',0,0,0,NULL,NULL,'2025-07-25',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-25 09:53:15',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(253,4,1,0.00,0,0,'FR-20250725-87',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-07-25',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-25 09:53:15',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(254,3,1,0.00,0,0,'FR-20250725-87',NULL,'Printing',0,0,0,NULL,NULL,'2025-07-25',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-25 09:53:15',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(255,8,1,0.00,0,0,'FR-20250725-87',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-07-25',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-25 09:53:15',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(256,9,1,150.00,0,0,'FR-20250725-87',NULL,'Miscellaneous',0,0,0,NULL,NULL,'2025-07-25',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-25 09:53:15',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(257,10,1,2000.00,0,0,'FR-20250725-87',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-07-25',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-25 09:53:15',4,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(258,2,1,7000.00,0,0,'FR-20250725-88',NULL,'Transport',0,0,0,NULL,NULL,'2025-07-25',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-25 10:28:08',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(259,5,1,10000.00,0,0,'FR-20250725-88',NULL,'Hotel Accommodation',0,0,0,NULL,NULL,'2025-07-25',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-25 10:28:08',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(260,4,1,0.00,0,0,'FR-20250725-88',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-07-25',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-25 10:28:08',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(261,8,1,0.00,0,0,'FR-20250725-88',NULL,'Speaker Costs',0,0,0,NULL,NULL,'2025-07-25',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-25 10:28:08',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(262,2,1,5500.00,0,0,'FR-20250725-89',NULL,'Transport',0,0,0,NULL,NULL,'2025-07-25',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-25 10:33:30',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(263,5,1,3000.00,0,0,'FR-20250725-89',NULL,'Hotel Accommodation',0,0,0,NULL,NULL,'2025-07-25',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-25 10:33:30',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(264,4,1,0.00,0,0,'FR-20250725-89',NULL,'Hotel Conferencing',0,0,0,NULL,NULL,'2025-07-25',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-25 10:33:30',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(265,10,1,7000.00,0,0,'FR-20250725-89',NULL,'CPD Allowance',0,0,0,NULL,NULL,'2025-07-25',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-25 10:33:30',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0),(266,3,1,0.00,0,0,'FR-20250725-89',NULL,'Printing',0,0,0,NULL,NULL,'2025-07-25',NULL,NULL,0,0,0,0,NULL,NULL,0,NULL,'2025-07-25 10:33:30',7,NULL,0,NULL,NULL,NULL,0,NULL,0,0);

--
-- Table structure for table `capabuil_tblexpenses_categories`
--

CREATE TABLE `capabuil_tblexpenses_categories` (
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `capabuil_tblexpenses_categories`
--

INSERT INTO `capabuil_tblexpenses_categories` VALUES (1,'Fleet: Work Order',NULL),(2,'Transport','Transport'),(3,'Printing','Printing'),(4,'Hotel Conferencing','Hotel Conferencing'),(5,'Hotel Accommodation','Hotel Accommodation'),(6,'Airtime Allowance','Airtime Allowance'),(7,'Client Gifts','Client Gifts'),(8,'Speaker Costs','Speaker Costs'),(9,'Miscellaneous','Miscellaneous'),(10,'CPD Allowance','CPD Allowance'),(11,'Additional Funds','Additional Funds'),(12,'ABA 306: STRATEGIC PROJECT LIFECYCLE MANAGEMENT: SECURING FUNDING, AGILE  IMPLEMENTATION, PERFORMANCE EVALUATION, AND TRANSPARENT AI REPORTING','ABA 306: STRATEGIC PROJECT LIFECYCLE MANAGEMENT: SECURING FUNDING, AGILE  IMPLEMENTATION, PERFORMANCE EVALUATION, AND TRANSPARENT AI REPORTING');

--
-- Table structure for table `capabuil_tblfiles`
--

CREATE TABLE `capabuil_tblfiles` (
  `id` int NOT NULL AUTO_INCREMENT,
  `rel_id` int NOT NULL,
  `rel_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `filetype` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `visible_to_customer` int NOT NULL DEFAULT '0',
  `attachment_key` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `external` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `external_link` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `thumbnail_link` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'For external usage',
  `staffid` int NOT NULL,
  `contact_id` int DEFAULT '0',
  `task_comment_id` int NOT NULL DEFAULT '0',
  `dateadded` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `rel_id` (`rel_id`),
  KEY `rel_type` (`rel_type`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `capabuil_tblfiles`
--

INSERT INTO `capabuil_tblfiles` VALUES (1,1,'ma_asset',' 15th-05-2025 Invoice-25045094.pdf','application/pdf',0,'266fa458d9e4ea0b3e747498c0fbbec9',NULL,NULL,NULL,8,0,0,'2025-07-15 08:08:18');

--
-- Table structure for table `capabuil_tblfilter_defaults`
--

CREATE TABLE `capabuil_tblfilter_defaults` (
  `filter_id` int unsigned NOT NULL,
  `staff_id` int NOT NULL,
  `identifier` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `view` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `filter_id` (`filter_id`),
  KEY `capabuil_staff_id` (`staff_id`),
  CONSTRAINT `capabuil_tblfilter_defaults_ibfk_1` FOREIGN KEY (`filter_id`) REFERENCES `capabuil_tblfilters` (`id`) ON DELETE CASCADE,
  CONSTRAINT `capabuil_tblfilter_defaults_ibfk_2` FOREIGN KEY (`staff_id`) REFERENCES `capabuil_tblstaff` (`staffid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `capabuil_tblfilter_defaults`
--


--
-- Table structure for table `capabuil_tblfilters`
--

CREATE TABLE `capabuil_tblfilters` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `builder` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `staff_id` int unsigned NOT NULL,
  `identifier` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_shared` tinyint unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `capabuil_tblfilters`
--


--
-- Table structure for table `capabuil_tblfleet_benefit_and_penalty`
--

CREATE TABLE `capabuil_tblfleet_benefit_and_penalty` (
  `id` int NOT NULL AUTO_INCREMENT,
  `subject` text,
  `criteria_id` int DEFAULT NULL,
  `driver_id` int DEFAULT NULL,
  `type` text,
  `date` date DEFAULT NULL,
  `benefit_formality` text,
  `reward` decimal(15,2) DEFAULT NULL,
  `penalty_formality` text,
  `amount_of_damage` decimal(15,2) DEFAULT NULL,
  `amount_of_compensation` decimal(15,2) DEFAULT NULL,
  `notes` text,
  `addedfrom` int DEFAULT NULL,
  `datecreated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_benefit_and_penalty`
--


--
-- Table structure for table `capabuil_tblfleet_bookings`
--

CREATE TABLE `capabuil_tblfleet_bookings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `subject` text NOT NULL,
  `contactid` int DEFAULT NULL,
  `userid` int DEFAULT NULL,
  `approved` int NOT NULL DEFAULT '0',
  `status` varchar(45) NOT NULL DEFAULT 'new',
  `delivery_date` date DEFAULT NULL,
  `phone` text NOT NULL,
  `receipt_address` text NOT NULL,
  `delivery_address` text NOT NULL,
  `note` text NOT NULL,
  `invoice_id` int NOT NULL DEFAULT '0',
  `admin_note` text,
  `number` text,
  `amount` decimal(15,2) NOT NULL DEFAULT '0.00',
  `invoice_hash` text,
  `rating` int NOT NULL DEFAULT '0',
  `comments` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_bookings`
--


--
-- Table structure for table `capabuil_tblfleet_criterias`
--

CREATE TABLE `capabuil_tblfleet_criterias` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `description` text,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_criterias`
--


--
-- Table structure for table `capabuil_tblfleet_driver_documents`
--

CREATE TABLE `capabuil_tblfleet_driver_documents` (
  `id` int NOT NULL AUTO_INCREMENT,
  `driver_id` int NOT NULL DEFAULT '0',
  `subject` text NOT NULL,
  `description` text,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  `type` varchar(45) NOT NULL DEFAULT 'driver',
  `vehicle_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_driver_documents`
--


--
-- Table structure for table `capabuil_tblfleet_events`
--

CREATE TABLE `capabuil_tblfleet_events` (
  `id` int NOT NULL AUTO_INCREMENT,
  `subject` text NOT NULL,
  `vehicle_id` int DEFAULT NULL,
  `driver_id` int DEFAULT NULL,
  `event_type` text NOT NULL,
  `event_time` datetime NOT NULL,
  `description` text,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_events`
--


--
-- Table structure for table `capabuil_tblfleet_fuel_history`
--

CREATE TABLE `capabuil_tblfleet_fuel_history` (
  `id` int NOT NULL AUTO_INCREMENT,
  `vehicle_id` int DEFAULT NULL,
  `vendor_id` int DEFAULT NULL,
  `fuel_time` datetime NOT NULL,
  `odometer` int DEFAULT NULL,
  `gallons` text,
  `price` decimal(15,2) DEFAULT NULL,
  `fuel_type` text,
  `reference` text,
  `notes` text,
  `addedfrom` int DEFAULT NULL,
  `datecreated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_fuel_history`
--


--
-- Table structure for table `capabuil_tblfleet_garages`
--

CREATE TABLE `capabuil_tblfleet_garages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `country` int NOT NULL DEFAULT '0',
  `city` varchar(100) DEFAULT NULL,
  `zip` varchar(15) DEFAULT NULL,
  `state` varchar(50) DEFAULT NULL,
  `address` text,
  `notes` text,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_garages`
--


--
-- Table structure for table `capabuil_tblfleet_inspection_forms`
--

CREATE TABLE `capabuil_tblfleet_inspection_forms` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `color` text,
  `description` text,
  `addedfrom` int DEFAULT NULL,
  `datecreated` datetime DEFAULT NULL,
  `slug` text,
  `hash` text,
  `recurring` int NOT NULL DEFAULT '0',
  `recurring_type` varchar(10) DEFAULT NULL,
  `custom_recurring` tinyint(1) NOT NULL DEFAULT '0',
  `cycles` int NOT NULL DEFAULT '0',
  `total_cycles` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_inspection_forms`
--


--
-- Table structure for table `capabuil_tblfleet_inspection_question_box`
--

CREATE TABLE `capabuil_tblfleet_inspection_question_box` (
  `boxid` int NOT NULL AUTO_INCREMENT,
  `boxtype` varchar(10) NOT NULL,
  `questionid` int NOT NULL,
  PRIMARY KEY (`boxid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_inspection_question_box`
--


--
-- Table structure for table `capabuil_tblfleet_inspection_question_box_description`
--

CREATE TABLE `capabuil_tblfleet_inspection_question_box_description` (
  `questionboxdescriptionid` int NOT NULL AUTO_INCREMENT,
  `description` mediumtext NOT NULL,
  `boxid` mediumtext NOT NULL,
  `questionid` int NOT NULL,
  `is_fail` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`questionboxdescriptionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_inspection_question_box_description`
--


--
-- Table structure for table `capabuil_tblfleet_inspection_question_forms`
--

CREATE TABLE `capabuil_tblfleet_inspection_question_forms` (
  `questionid` int NOT NULL AUTO_INCREMENT,
  `rel_id` int NOT NULL,
  `rel_type` varchar(20) DEFAULT NULL,
  `question` mediumtext NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `question_order` int NOT NULL,
  PRIMARY KEY (`questionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_inspection_question_forms`
--


--
-- Table structure for table `capabuil_tblfleet_inspection_results`
--

CREATE TABLE `capabuil_tblfleet_inspection_results` (
  `id` int NOT NULL AUTO_INCREMENT,
  `inspection_id` int DEFAULT NULL,
  `boxid` int DEFAULT NULL,
  `boxdescriptionid` int DEFAULT NULL,
  `questionid` int DEFAULT NULL,
  `answer` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_inspection_results`
--


--
-- Table structure for table `capabuil_tblfleet_inspections`
--

CREATE TABLE `capabuil_tblfleet_inspections` (
  `id` int NOT NULL AUTO_INCREMENT,
  `vehicle_id` int DEFAULT NULL,
  `inspection_form_id` int DEFAULT NULL,
  `status` int DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  `datecreated` datetime DEFAULT NULL,
  `recurring` int NOT NULL DEFAULT '0',
  `recurring_type` varchar(10) DEFAULT NULL,
  `custom_recurring` tinyint(1) NOT NULL DEFAULT '0',
  `cycles` int NOT NULL DEFAULT '0',
  `total_cycles` int NOT NULL DEFAULT '0',
  `is_recurring_from` int NOT NULL DEFAULT '0',
  `last_recurring_date` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_inspections`
--


--
-- Table structure for table `capabuil_tblfleet_insurance_categories`
--

CREATE TABLE `capabuil_tblfleet_insurance_categories` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `description` text,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_insurance_categories`
--


--
-- Table structure for table `capabuil_tblfleet_insurance_company`
--

CREATE TABLE `capabuil_tblfleet_insurance_company` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `description` text,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_insurance_company`
--


--
-- Table structure for table `capabuil_tblfleet_insurance_status`
--

CREATE TABLE `capabuil_tblfleet_insurance_status` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `description` text,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_insurance_status`
--


--
-- Table structure for table `capabuil_tblfleet_insurance_types`
--

CREATE TABLE `capabuil_tblfleet_insurance_types` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `description` text,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_insurance_types`
--


--
-- Table structure for table `capabuil_tblfleet_insurances`
--

CREATE TABLE `capabuil_tblfleet_insurances` (
  `id` int NOT NULL AUTO_INCREMENT,
  `vehicle_id` int DEFAULT NULL,
  `insurance_category_id` int DEFAULT NULL,
  `insurance_type_id` int DEFAULT NULL,
  `name` text,
  `status` text,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `description` text,
  `amount` decimal(15,2) NOT NULL,
  `insurance_company_id` int NOT NULL DEFAULT '0',
  `insurance_status_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_insurances`
--


--
-- Table structure for table `capabuil_tblfleet_logbooks`
--

CREATE TABLE `capabuil_tblfleet_logbooks` (
  `id` int NOT NULL AUTO_INCREMENT,
  `vehicle_id` int DEFAULT NULL,
  `driver_id` int DEFAULT NULL,
  `booking_id` int DEFAULT NULL,
  `odometer` int DEFAULT NULL,
  `status` varchar(45) NOT NULL DEFAULT 'new',
  `date` date DEFAULT NULL,
  `description` text,
  `name` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_logbooks`
--


--
-- Table structure for table `capabuil_tblfleet_maintenance_teams`
--

CREATE TABLE `capabuil_tblfleet_maintenance_teams` (
  `id` int NOT NULL AUTO_INCREMENT,
  `staffid` int DEFAULT NULL,
  `garage_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_maintenance_teams`
--


--
-- Table structure for table `capabuil_tblfleet_maintenances`
--

CREATE TABLE `capabuil_tblfleet_maintenances` (
  `id` int NOT NULL AUTO_INCREMENT,
  `vehicle_id` int DEFAULT NULL,
  `supplier_id` int DEFAULT NULL,
  `maintenance_type` varchar(30) DEFAULT NULL,
  `title` varchar(250) DEFAULT NULL,
  `warranty_improvement` int NOT NULL DEFAULT '0',
  `start_date` date DEFAULT NULL,
  `completion_date` date DEFAULT NULL,
  `cost` decimal(15,2) DEFAULT NULL,
  `notes` text,
  `date_creator` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `garage_id` int NOT NULL DEFAULT '0',
  `parts` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_maintenances`
--


--
-- Table structure for table `capabuil_tblfleet_part_groups`
--

CREATE TABLE `capabuil_tblfleet_part_groups` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `description` text,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_part_groups`
--


--
-- Table structure for table `capabuil_tblfleet_part_histories`
--

CREATE TABLE `capabuil_tblfleet_part_histories` (
  `id` int NOT NULL AUTO_INCREMENT,
  `part_id` int NOT NULL,
  `type` text NOT NULL,
  `vehicle_id` int DEFAULT NULL,
  `driver_id` int DEFAULT NULL,
  `start_time` text,
  `end_time` text,
  `start_by` int DEFAULT NULL,
  `end_by` int DEFAULT NULL,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_part_histories`
--


--
-- Table structure for table `capabuil_tblfleet_part_types`
--

CREATE TABLE `capabuil_tblfleet_part_types` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `description` text,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_part_types`
--


--
-- Table structure for table `capabuil_tblfleet_parts`
--

CREATE TABLE `capabuil_tblfleet_parts` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `part_type_id` int DEFAULT NULL,
  `brand` text,
  `model` text,
  `serial_number` text,
  `vehicle_id` int NOT NULL DEFAULT '0',
  `driver_id` int NOT NULL DEFAULT '0',
  `part_group_id` int DEFAULT NULL,
  `status` text,
  `purchase_vendor` int DEFAULT NULL,
  `purchase_date` date DEFAULT NULL,
  `purchase_price` decimal(15,2) DEFAULT NULL,
  `warranty_expiration_date` date DEFAULT NULL,
  `purchase_comments` text,
  `in_service_date` date DEFAULT NULL,
  `estimated_service_life_in_months` int DEFAULT NULL,
  `estimated_resale_value` decimal(15,2) DEFAULT NULL,
  `out_of_service_date` date DEFAULT NULL,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_parts`
--


--
-- Table structure for table `capabuil_tblfleet_time_cards`
--

CREATE TABLE `capabuil_tblfleet_time_cards` (
  `id` int NOT NULL AUTO_INCREMENT,
  `logbook_id` int DEFAULT NULL,
  `driver_id` int DEFAULT NULL,
  `start_time` text NOT NULL,
  `end_time` text NOT NULL,
  `notes` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_time_cards`
--


--
-- Table structure for table `capabuil_tblfleet_vehicle_assignments`
--

CREATE TABLE `capabuil_tblfleet_vehicle_assignments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `driver_id` int NOT NULL,
  `vehicle_id` int NOT NULL,
  `start_time` datetime DEFAULT NULL,
  `starting_odometer` float DEFAULT NULL,
  `end_time` datetime DEFAULT NULL,
  `ending_odometer` float DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_vehicle_assignments`
--


--
-- Table structure for table `capabuil_tblfleet_vehicle_groups`
--

CREATE TABLE `capabuil_tblfleet_vehicle_groups` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `description` text,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_vehicle_groups`
--


--
-- Table structure for table `capabuil_tblfleet_vehicle_histories`
--

CREATE TABLE `capabuil_tblfleet_vehicle_histories` (
  `id` int NOT NULL AUTO_INCREMENT,
  `vehicle_id` int NOT NULL,
  `type` text NOT NULL,
  `from_value` text,
  `to_value` text,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_vehicle_histories`
--


--
-- Table structure for table `capabuil_tblfleet_vehicle_types`
--

CREATE TABLE `capabuil_tblfleet_vehicle_types` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `description` text,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_vehicle_types`
--


--
-- Table structure for table `capabuil_tblfleet_vehicles`
--

CREATE TABLE `capabuil_tblfleet_vehicles` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `vehicle_type_id` int DEFAULT NULL,
  `vehicle_group_id` int DEFAULT NULL,
  `status` text,
  `description` text,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  `model` text,
  `year` text,
  `width` text,
  `height` text,
  `length` text,
  `interior_volume` text,
  `passenger_volume` text,
  `cargo_volume` text,
  `ground_clearance` text,
  `bed_length` text,
  `curb_weight` text,
  `gross_vehicle_weight_rating` text,
  `towing_capacity` text,
  `max_payload` text,
  `epa_city` text,
  `epa_highway` text,
  `epa_combined` text,
  `oil_capacity` text,
  `in_service_date` date DEFAULT NULL,
  `in_service_odometer` int DEFAULT NULL,
  `estimated_service_life_in_months` text,
  `estimated_service_life_in_meter` text,
  `estimated_resale_value` text,
  `out_of_service_date` date DEFAULT NULL,
  `out_of_service_odometer` int DEFAULT NULL,
  `vin` text,
  `license_plate` text,
  `make` text,
  `trim` text,
  `registration_state` text,
  `ownership` text,
  `color` text,
  `body_type` text,
  `body_subtype` text,
  `msrp` text,
  `purchase_vendor` int DEFAULT NULL,
  `purchase_date` date DEFAULT NULL,
  `purchase_price` decimal(15,2) DEFAULT NULL,
  `odometer` int DEFAULT NULL,
  `notes` text,
  `expiration_date` date DEFAULT NULL,
  `max_meter_value` text,
  `engine_summary` text,
  `engine_brand` text,
  `aspiration` text,
  `block_type` text,
  `bore` text,
  `cam_type` text,
  `compression` text,
  `cylinders` text,
  `displacement` text,
  `fuel_induction` text,
  `max_hp` text,
  `max_torque` text,
  `redline_rpm` text,
  `stroke` text,
  `valves` text,
  `transmission_summary` text,
  `transmission_brand` text,
  `transmission_type` text,
  `transmission_gears` text,
  `drive_type` text,
  `brake_system` text,
  `front_track_width` text,
  `rear_track_width` text,
  `wheelbase` text,
  `front_wheel_diameter` text,
  `rear_wheel_diameter` text,
  `rear_axle` text,
  `front_tire_type` text,
  `front_tire_psi` text,
  `rear_tire_type` text,
  `rear_tire_psi` text,
  `fuel_type` text,
  `fuel_quality` text,
  `fuel_tank_1_capacity` text,
  `fuel_tank_2_capacity` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_vehicles`
--


--
-- Table structure for table `capabuil_tblfleet_work_order_details`
--

CREATE TABLE `capabuil_tblfleet_work_order_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `work_order_id` int DEFAULT NULL,
  `part_id` int DEFAULT NULL,
  `item_name` text,
  `qty` int DEFAULT NULL,
  `price` decimal(15,2) DEFAULT NULL,
  `total` decimal(15,2) DEFAULT NULL,
  `description` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_work_order_details`
--


--
-- Table structure for table `capabuil_tblfleet_work_orders`
--

CREATE TABLE `capabuil_tblfleet_work_orders` (
  `id` int NOT NULL AUTO_INCREMENT,
  `subject` text NOT NULL,
  `number` text,
  `vehicle_id` int DEFAULT NULL,
  `driver_id` int DEFAULT NULL,
  `vendor_id` int DEFAULT NULL,
  `invoice_id` int DEFAULT NULL,
  `purchase_order_id` int DEFAULT NULL,
  `status` varchar(45) NOT NULL DEFAULT 'open',
  `issue_date` date DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `complete_date` date DEFAULT NULL,
  `odometer_in` int DEFAULT NULL,
  `odometer_out` int DEFAULT NULL,
  `total` decimal(15,2) DEFAULT NULL,
  `work_requested` text,
  `notes` text,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  `expense_id` int NOT NULL DEFAULT '0',
  `parts` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfleet_work_orders`
--


--
-- Table structure for table `capabuil_tblform_question_box`
--

CREATE TABLE `capabuil_tblform_question_box` (
  `boxid` int NOT NULL AUTO_INCREMENT,
  `boxtype` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `questionid` int NOT NULL,
  PRIMARY KEY (`boxid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `capabuil_tblform_question_box`
--


--
-- Table structure for table `capabuil_tblform_question_box_description`
--

CREATE TABLE `capabuil_tblform_question_box_description` (
  `questionboxdescriptionid` int NOT NULL AUTO_INCREMENT,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `boxid` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `questionid` int NOT NULL,
  PRIMARY KEY (`questionboxdescriptionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `capabuil_tblform_question_box_description`
--


--
-- Table structure for table `capabuil_tblform_questions`
--

CREATE TABLE `capabuil_tblform_questions` (
  `questionid` int NOT NULL AUTO_INCREMENT,
  `rel_id` int NOT NULL,
  `rel_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `question` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `question_order` int NOT NULL,
  PRIMARY KEY (`questionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `capabuil_tblform_questions`
--


--
-- Table structure for table `capabuil_tblform_results`
--

CREATE TABLE `capabuil_tblform_results` (
  `resultid` int NOT NULL AUTO_INCREMENT,
  `boxid` int NOT NULL,
  `boxdescriptionid` int DEFAULT NULL,
  `rel_id` int NOT NULL,
  `rel_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `questionid` int NOT NULL,
  `answer` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `resultsetid` int NOT NULL,
  PRIMARY KEY (`resultid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `capabuil_tblform_results`
--


--
-- Table structure for table `capabuil_tblfs_downloads`
--

CREATE TABLE `capabuil_tblfs_downloads` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hash_share` varchar(255) NOT NULL,
  `time` datetime NOT NULL,
  `ip` varchar(255) NOT NULL,
  `browser_name` varchar(45) DEFAULT NULL,
  `http_user_agent` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfs_downloads`
--


--
-- Table structure for table `capabuil_tblfs_file_overview`
--

CREATE TABLE `capabuil_tblfs_file_overview` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `fileid` varchar(255) NOT NULL,
  `type` varchar(20) DEFAULT NULL,
  `path` text,
  `number` int NOT NULL DEFAULT '0',
  `created_at` varchar(11) DEFAULT NULL,
  `inserted_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `hash` varchar(250) NOT NULL DEFAULT '',
  `dir` int NOT NULL DEFAULT '0',
  `hash_share` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfs_file_overview`
--

INSERT INTO `capabuil_tblfs_file_overview` VALUES (1,'1738168489','directory','Main File Sharing/reagan-nyadimo',0,'1','2025-01-29 16:34:49','2025-01-29 16:34:49','',1,'A1xQah'),(2,'173816848927','directory','modules/file_sharing/uploads/Main File Sharing/reagan-nyadimo/Shared',0,'1','2025-01-29 16:34:49','2025-01-29 16:34:49','',1,'QnmKuo'),(3,'173816848961','directory','modules/file_sharing/uploads/Main File Sharing/.trash/reagan-nyadimo',0,'1','2025-01-29 16:34:49','2025-01-29 16:34:49','',1,'HQlVtX'),(4,'1738168490','directory','/var/www/html/tagrit/modules/file_sharing/uploads/Main File Sharing/reagan-nyadimo',0,'1','2025-01-29 16:34:50','2025-01-29 16:34:50','',1,'pBvXtB'),(5,'173816849071','directory','modules/file_sharing/uploads/Main File Sharing/reagan-nyadimo/Shared',0,'1','2025-01-29 16:34:50','2025-01-29 16:34:50','',1,'kPbJgW'),(6,'1746003386','directory','/var/www/html/tagrit/modules/file_sharing/uploads/Main File Sharing/nafisa-ahmed',0,'6','2025-04-30 08:56:26','2025-04-30 08:56:26','',1,'uo89qk'),(7,'174600338632','directory','modules/file_sharing/uploads/Main File Sharing/nafisa-ahmed/Shared',0,'6','2025-04-30 08:56:26','2025-04-30 08:56:26','',1,'XIC4ty'),(8,'174600338690','directory','modules/file_sharing/uploads/Main File Sharing/.trash/nafisa-ahmed',0,'6','2025-04-30 08:56:26','2025-04-30 08:56:26','',1,'H4HovV');

--
-- Table structure for table `capabuil_tblfs_genenal_ip_share`
--

CREATE TABLE `capabuil_tblfs_genenal_ip_share` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `parrent_id` varchar(11) NOT NULL,
  `ip_share` varchar(20) DEFAULT NULL,
  `inserted_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfs_genenal_ip_share`
--


--
-- Table structure for table `capabuil_tblfs_setting_configuration`
--

CREATE TABLE `capabuil_tblfs_setting_configuration` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(20) DEFAULT NULL,
  `is_read` int NOT NULL DEFAULT '0',
  `is_upload` int NOT NULL DEFAULT '0',
  `is_download` int NOT NULL DEFAULT '0',
  `is_delete` int NOT NULL DEFAULT '0',
  `is_write` int NOT NULL DEFAULT '0',
  `password` varchar(255) DEFAULT NULL,
  `max_size` int NOT NULL DEFAULT '2',
  `min_size` int NOT NULL DEFAULT '1',
  `created_at` varchar(11) DEFAULT NULL,
  `inserted_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `is_share` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfs_setting_configuration`
--


--
-- Table structure for table `capabuil_tblfs_setting_configuration_relationship`
--

CREATE TABLE `capabuil_tblfs_setting_configuration_relationship` (
  `id` int NOT NULL AUTO_INCREMENT,
  `configuration_id` int NOT NULL,
  `rel_type` varchar(45) NOT NULL,
  `rel_id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfs_setting_configuration_relationship`
--


--
-- Table structure for table `capabuil_tblfs_sharing_relationship`
--

CREATE TABLE `capabuil_tblfs_sharing_relationship` (
  `id` int NOT NULL AUTO_INCREMENT,
  `share_id` int NOT NULL,
  `type` varchar(45) NOT NULL,
  `value` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfs_sharing_relationship`
--


--
-- Table structure for table `capabuil_tblfs_sharings`
--

CREATE TABLE `capabuil_tblfs_sharings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `is_read` int NOT NULL DEFAULT '0',
  `is_upload` int NOT NULL DEFAULT '0',
  `is_download` int NOT NULL DEFAULT '0',
  `is_delete` int NOT NULL DEFAULT '0',
  `is_write` int NOT NULL DEFAULT '0',
  `password` varchar(255) DEFAULT NULL,
  `expiration_date_apply` int DEFAULT NULL,
  `expiration_date` date DEFAULT NULL,
  `expiration_date_delete` int DEFAULT NULL,
  `download_limits_apply` int DEFAULT NULL,
  `download_limits` int DEFAULT NULL,
  `download_limits_delete` int DEFAULT NULL,
  `hash_share` varchar(255) DEFAULT NULL,
  `created_at` int NOT NULL,
  `type` varchar(45) NOT NULL,
  `inserted_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `isowner` tinyint DEFAULT NULL,
  `phash` text,
  `locked` tinyint DEFAULT NULL,
  `mime` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `read` tinyint DEFAULT NULL,
  `size` varchar(255) DEFAULT NULL,
  `ts` varchar(255) DEFAULT NULL,
  `write` tinyint DEFAULT NULL,
  `hash` text,
  `url` text,
  `has_been_deleted` int NOT NULL DEFAULT '0',
  `downloads` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblfs_sharings`
--


--
-- Table structure for table `capabuil_tblgdpr_requests`
--

CREATE TABLE `capabuil_tblgdpr_requests` (
  `id` int NOT NULL AUTO_INCREMENT,
  `clientid` int NOT NULL DEFAULT '0',
  `contact_id` int NOT NULL DEFAULT '0',
  `lead_id` int NOT NULL DEFAULT '0',
  `request_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `request_date` datetime NOT NULL,
  `request_from` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `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 `capabuil_tblgdpr_requests`
--


--
-- Table structure for table `capabuil_tblgoals`
--

CREATE TABLE `capabuil_tblgoals` (
  `id` int NOT NULL AUTO_INCREMENT,
  `subject` varchar(191) NOT NULL,
  `description` text NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `goal_type` int NOT NULL,
  `contract_type` int NOT NULL DEFAULT '0',
  `achievement` int NOT NULL,
  `notify_when_fail` tinyint(1) NOT NULL DEFAULT '1',
  `notify_when_achieve` tinyint(1) NOT NULL DEFAULT '1',
  `notified` int NOT NULL DEFAULT '0',
  `staff_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `staff_id` (`staff_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblgoals`
--


--
-- Table structure for table `capabuil_tblgoods_delivery`
--

CREATE TABLE `capabuil_tblgoods_delivery` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `rel_type` int DEFAULT NULL COMMENT 'type goods delivery',
  `rel_document` int DEFAULT NULL COMMENT 'document id of goods delivery',
  `customer_code` text,
  `customer_name` varchar(100) DEFAULT NULL,
  `to_` varchar(100) DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  `description` text COMMENT 'the reason delivery',
  `staff_id` int DEFAULT NULL COMMENT 'salesman',
  `date_c` date DEFAULT NULL,
  `date_add` date DEFAULT NULL,
  `goods_delivery_code` varchar(100) DEFAULT NULL COMMENT 'số chứng từ xuất kho',
  `warehouse_id` int DEFAULT NULL,
  `total_money` varchar(200) DEFAULT NULL,
  `approval` int DEFAULT '0' COMMENT 'status approval ',
  `addedfrom` int DEFAULT NULL,
  `total_discount` varchar(100) DEFAULT NULL,
  `after_discount` varchar(100) DEFAULT NULL,
  `invoice_id` varchar(100) DEFAULT NULL,
  `project` text,
  `type` text,
  `department` int DEFAULT NULL,
  `requester` int DEFAULT NULL,
  `invoice_no` text,
  `pr_order_id` int DEFAULT NULL,
  `type_of_delivery` varchar(100) DEFAULT 'total',
  `additional_discount` decimal(15,2) DEFAULT '0.00',
  `sub_total` decimal(15,2) DEFAULT '0.00',
  `delivery_status` varchar(100) DEFAULT 'ready_for_packing',
  `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 `capabuil_tblgoods_delivery`
--


--
-- Table structure for table `capabuil_tblgoods_delivery_detail`
--

CREATE TABLE `capabuil_tblgoods_delivery_detail` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `goods_delivery_id` int NOT NULL,
  `commodity_code` varchar(100) DEFAULT NULL,
  `commodity_name` text,
  `warehouse_id` text,
  `unit_id` text,
  `quantities` text,
  `unit_price` varchar(100) DEFAULT NULL,
  `total_money` varchar(200) DEFAULT NULL,
  `note` text,
  `discount` varchar(100) DEFAULT NULL,
  `discount_money` varchar(100) DEFAULT NULL,
  `available_quantity` varchar(100) DEFAULT NULL,
  `tax_id` varchar(100) DEFAULT NULL,
  `total_after_discount` varchar(100) DEFAULT NULL,
  `expiry_date` text,
  `lot_number` text,
  `guarantee_period` text,
  `tax_rate` text,
  `tax_name` text,
  `sub_total` decimal(15,2) DEFAULT '0.00',
  `packing_qty` 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 `capabuil_tblgoods_delivery_detail`
--


--
-- Table structure for table `capabuil_tblgoods_delivery_invoices_pr_orders`
--

CREATE TABLE `capabuil_tblgoods_delivery_invoices_pr_orders` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `rel_id` int DEFAULT NULL COMMENT 'goods_delivery_id',
  `rel_type` int DEFAULT NULL COMMENT 'invoice_id or purchase order id',
  `type` varchar(100) DEFAULT NULL COMMENT 'invoice,  purchase_orders',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblgoods_delivery_invoices_pr_orders`
--


--
-- Table structure for table `capabuil_tblgoods_receipt`
--

CREATE TABLE `capabuil_tblgoods_receipt` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `supplier_code` varchar(100) DEFAULT NULL,
  `supplier_name` text,
  `deliver_name` text,
  `buyer_id` int DEFAULT NULL,
  `description` text,
  `pr_order_id` int DEFAULT NULL COMMENT 'code puchase request agree',
  `date_c` date DEFAULT NULL,
  `date_add` date DEFAULT NULL,
  `goods_receipt_code` varchar(100) DEFAULT NULL,
  `warehouse_id` int DEFAULT NULL,
  `total_tax_money` varchar(100) DEFAULT NULL,
  `total_goods_money` varchar(100) DEFAULT NULL,
  `value_of_inventory` varchar(100) DEFAULT NULL,
  `total_money` varchar(100) DEFAULT NULL COMMENT 'total_money = total_tax_money +total_goods_money ',
  `addedfrom` int DEFAULT NULL,
  `approval` int DEFAULT '0',
  `project` text,
  `type` text,
  `department` int DEFAULT NULL,
  `requester` int DEFAULT NULL,
  `expiry_date` date DEFAULT NULL,
  `invoice_no` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblgoods_receipt`
--


--
-- Table structure for table `capabuil_tblgoods_receipt_detail`
--

CREATE TABLE `capabuil_tblgoods_receipt_detail` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `goods_receipt_id` int NOT NULL,
  `commodity_code` varchar(100) DEFAULT NULL,
  `commodity_name` text,
  `warehouse_id` text,
  `unit_id` text,
  `quantities` text,
  `unit_price` varchar(100) DEFAULT NULL,
  `tax` varchar(100) DEFAULT NULL,
  `tax_money` varchar(100) DEFAULT NULL,
  `goods_money` varchar(100) DEFAULT NULL,
  `date_manufacture` date DEFAULT NULL,
  `expiry_date` date DEFAULT NULL,
  `note` text,
  `discount` varchar(100) DEFAULT NULL,
  `discount_money` varchar(100) DEFAULT NULL,
  `lot_number` varchar(100) DEFAULT NULL,
  `tax_rate` text,
  `sub_total` decimal(15,2) DEFAULT '0.00',
  `tax_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 `capabuil_tblgoods_receipt_detail`
--


--
-- Table structure for table `capabuil_tblgoods_transaction_detail`
--

CREATE TABLE `capabuil_tblgoods_transaction_detail` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `goods_receipt_id` int DEFAULT NULL COMMENT 'id_goods_receipt_id or goods_delivery_id',
  `goods_id` int NOT NULL COMMENT ' is id commodity',
  `old_quantity` varchar(100) DEFAULT NULL,
  `quantity` varchar(100) DEFAULT NULL,
  `date_add` datetime DEFAULT NULL,
  `commodity_id` int NOT NULL,
  `warehouse_id` text NOT NULL,
  `note` text,
  `status` int DEFAULT NULL COMMENT '1:Goods receipt note 2:Goods delivery note',
  `purchase_price` varchar(100) DEFAULT NULL,
  `price` varchar(100) DEFAULT NULL,
  `expiry_date` text,
  `lot_number` text,
  `from_stock_name` int DEFAULT NULL,
  `to_stock_name` int DEFAULT NULL,
  `serial_number` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`,`commodity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblgoods_transaction_detail`
--


--
-- Table structure for table `capabuil_tblgroup_checklist`
--

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

--
-- Dumping data for table `capabuil_tblgroup_checklist`
--


--
-- Table structure for table `capabuil_tblgroup_checklist_allocation`
--

CREATE TABLE `capabuil_tblgroup_checklist_allocation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `group_name` varchar(100) NOT NULL,
  `meta` varchar(100) DEFAULT NULL,
  `staffid` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblgroup_checklist_allocation`
--


--
-- Table structure for table `capabuil_tblhr_allocation_asset`
--

CREATE TABLE `capabuil_tblhr_allocation_asset` (
  `allocation_id` int unsigned NOT NULL AUTO_INCREMENT,
  `staff_id` int unsigned NOT NULL,
  `asset_name` varchar(100) DEFAULT NULL,
  `assets_amount` int unsigned NOT NULL,
  `status_allocation` int unsigned DEFAULT '0' COMMENT '1: Allocated 0: Unallocated',
  PRIMARY KEY (`allocation_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblhr_allocation_asset`
--


--
-- Table structure for table `capabuil_tblhr_allowance_type`
--

CREATE TABLE `capabuil_tblhr_allowance_type` (
  `type_id` int unsigned NOT NULL AUTO_INCREMENT,
  `type_name` varchar(200) NOT NULL,
  `allowance_val` decimal(15,2) NOT NULL,
  `taxable` tinyint(1) NOT NULL,
  PRIMARY KEY (`type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblhr_allowance_type`
--


--
-- Table structure for table `capabuil_tblhr_checklist_allocation`
--

CREATE TABLE `capabuil_tblhr_checklist_allocation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `group_id` int DEFAULT NULL,
  `status` int DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblhr_checklist_allocation`
--


--
-- Table structure for table `capabuil_tblhr_contract_template`
--

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

--
-- Dumping data for table `capabuil_tblhr_contract_template`
--


--
-- Table structure for table `capabuil_tblhr_dependent_person`
--

CREATE TABLE `capabuil_tblhr_dependent_person` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `staffid` int unsigned DEFAULT NULL,
  `dependent_name` varchar(100) DEFAULT NULL,
  `relationship` varchar(100) DEFAULT NULL,
  `dependent_bir` date DEFAULT NULL,
  `start_month` date DEFAULT NULL,
  `end_month` date DEFAULT NULL,
  `dependent_iden` varchar(20) NOT NULL,
  `reason` longtext,
  `status` int unsigned DEFAULT '0',
  `status_comment` longtext,
  PRIMARY KEY (`id`,`dependent_iden`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblhr_dependent_person`
--


--
-- Table structure for table `capabuil_tblhr_education`
--

CREATE TABLE `capabuil_tblhr_education` (
  `id` int NOT NULL AUTO_INCREMENT,
  `staff_id` int NOT NULL,
  `admin_id` int NOT NULL,
  `programe_id` int DEFAULT NULL,
  `training_programs_name` text NOT NULL,
  `training_places` text,
  `training_time_from` datetime DEFAULT NULL,
  `training_time_to` datetime DEFAULT NULL,
  `date_create` datetime DEFAULT NULL,
  `training_result` varchar(150) DEFAULT NULL,
  `degree` varchar(150) DEFAULT NULL,
  `notes` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblhr_education`
--


--
-- Table structure for table `capabuil_tblhr_group_checklist_allocation`
--

CREATE TABLE `capabuil_tblhr_group_checklist_allocation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `group_name` varchar(100) NOT NULL,
  `meta` varchar(100) DEFAULT NULL,
  `staffid` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblhr_group_checklist_allocation`
--


--
-- Table structure for table `capabuil_tblhr_job_p`
--

CREATE TABLE `capabuil_tblhr_job_p` (
  `job_id` int unsigned NOT NULL AUTO_INCREMENT,
  `job_name` varchar(100) DEFAULT NULL,
  `description` text,
  PRIMARY KEY (`job_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblhr_job_p`
--


--
-- Table structure for table `capabuil_tblhr_job_position`
--

CREATE TABLE `capabuil_tblhr_job_position` (
  `position_id` int unsigned NOT NULL AUTO_INCREMENT,
  `position_name` varchar(200) NOT NULL,
  `job_position_description` text,
  `job_p_id` int unsigned NOT NULL,
  `position_code` varchar(50) DEFAULT NULL,
  `department_id` text,
  PRIMARY KEY (`position_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblhr_job_position`
--


--
-- Table structure for table `capabuil_tblhr_jp_interview_training`
--

CREATE TABLE `capabuil_tblhr_jp_interview_training` (
  `training_process_id` int unsigned NOT NULL AUTO_INCREMENT,
  `job_position_id` longtext,
  `training_name` varchar(100) DEFAULT NULL,
  `training_type` int DEFAULT NULL,
  `description` text,
  `date_add` datetime DEFAULT NULL,
  `position_training_id` text,
  `mint_point` int DEFAULT NULL,
  `additional_training` varchar(100) DEFAULT '',
  `staff_id` text,
  `time_to_start` date DEFAULT NULL,
  `time_to_end` date DEFAULT NULL,
  PRIMARY KEY (`training_process_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblhr_jp_interview_training`
--


--
-- Table structure for table `capabuil_tblhr_jp_salary_scale`
--

CREATE TABLE `capabuil_tblhr_jp_salary_scale` (
  `salary_scale_id` int unsigned NOT NULL AUTO_INCREMENT,
  `job_position_id` int unsigned NOT NULL,
  `rel_type` varchar(100) DEFAULT NULL COMMENT 'salary:allowance:insurance',
  `rel_id` int DEFAULT NULL,
  `value` text,
  PRIMARY KEY (`salary_scale_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblhr_jp_salary_scale`
--


--
-- Table structure for table `capabuil_tblhr_knowedge_base_article_feedback`
--

CREATE TABLE `capabuil_tblhr_knowedge_base_article_feedback` (
  `articleanswerid` int NOT NULL AUTO_INCREMENT,
  `articleid` int NOT NULL,
  `answer` int NOT NULL,
  `ip` varchar(40) NOT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY (`articleanswerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblhr_knowedge_base_article_feedback`
--


--
-- Table structure for table `capabuil_tblhr_knowledge_base`
--

CREATE TABLE `capabuil_tblhr_knowledge_base` (
  `articleid` int NOT NULL AUTO_INCREMENT,
  `articlegroup` int NOT NULL,
  `subject` mediumtext NOT NULL,
  `description` text NOT NULL,
  `slug` mediumtext NOT NULL,
  `active` tinyint NOT NULL,
  `datecreated` datetime NOT NULL,
  `article_order` int NOT NULL DEFAULT '0',
  `staff_article` int NOT NULL DEFAULT '0',
  `question_answers` int DEFAULT '0',
  `file_name` varchar(255) DEFAULT '',
  `curator` varchar(11) DEFAULT '',
  `benchmark` int DEFAULT '0',
  `score` int DEFAULT '0',
  PRIMARY KEY (`articleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblhr_knowledge_base`
--


--
-- Table structure for table `capabuil_tblhr_knowledge_base_groups`
--

CREATE TABLE `capabuil_tblhr_knowledge_base_groups` (
  `groupid` int NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `group_slug` text,
  `description` mediumtext,
  `active` tinyint NOT NULL,
  `color` varchar(10) DEFAULT '#28B8DA',
  `group_order` int DEFAULT '0',
  PRIMARY KEY (`groupid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblhr_knowledge_base_groups`
--


--
-- Table structure for table `capabuil_tblhr_list_staff_quitting_work`
--

CREATE TABLE `capabuil_tblhr_list_staff_quitting_work` (
  `id` int NOT NULL AUTO_INCREMENT,
  `staffid` int DEFAULT NULL,
  `staff_name` text,
  `department_name` text,
  `role_name` text,
  `email` text,
  `dateoff` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `approval` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblhr_list_staff_quitting_work`
--


--
-- Table structure for table `capabuil_tblhr_p_t_form_question_box`
--

CREATE TABLE `capabuil_tblhr_p_t_form_question_box` (
  `boxid` int NOT NULL AUTO_INCREMENT,
  `boxtype` varchar(10) NOT NULL,
  `questionid` int NOT NULL,
  PRIMARY KEY (`boxid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblhr_p_t_form_question_box`
--


--
-- Table structure for table `capabuil_tblhr_p_t_form_question_box_description`
--

CREATE TABLE `capabuil_tblhr_p_t_form_question_box_description` (
  `questionboxdescriptionid` int NOT NULL AUTO_INCREMENT,
  `description` mediumtext NOT NULL,
  `boxid` mediumtext NOT NULL,
  `questionid` int NOT NULL,
  `correct` int DEFAULT '1' COMMENT '0: correct 1: incorrect',
  PRIMARY KEY (`questionboxdescriptionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblhr_p_t_form_question_box_description`
--


--
-- Table structure for table `capabuil_tblhr_p_t_form_results`
--

CREATE TABLE `capabuil_tblhr_p_t_form_results` (
  `resultid` int NOT NULL AUTO_INCREMENT,
  `boxid` int NOT NULL,
  `boxdescriptionid` int DEFAULT NULL,
  `rel_id` int NOT NULL,
  `rel_type` varchar(20) DEFAULT NULL,
  `questionid` int NOT NULL,
  `answer` text,
  `resultsetid` int NOT NULL,
  PRIMARY KEY (`resultid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblhr_p_t_form_results`
--


--
-- Table structure for table `capabuil_tblhr_p_t_surveyresultsets`
--

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

--
-- Dumping data for table `capabuil_tblhr_p_t_surveyresultsets`
--


--
-- Table structure for table `capabuil_tblhr_position_training`
--

CREATE TABLE `capabuil_tblhr_position_training` (
  `training_id` int NOT NULL AUTO_INCREMENT,
  `subject` mediumtext NOT NULL,
  `training_type` int unsigned NOT NULL,
  `slug` mediumtext NOT NULL,
  `description` text,
  `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,
  `mint_point` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`training_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblhr_position_training`
--


--
-- Table structure for table `capabuil_tblhr_position_training_question_form`
--

CREATE TABLE `capabuil_tblhr_position_training_question_form` (
  `questionid` int NOT NULL AUTO_INCREMENT,
  `rel_id` int NOT NULL,
  `rel_type` varchar(20) DEFAULT NULL,
  `question` mediumtext NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `question_order` int NOT NULL,
  `point` int NOT NULL,
  PRIMARY KEY (`questionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblhr_position_training_question_form`
--


--
-- Table structure for table `capabuil_tblhr_procedure_retire`
--

CREATE TABLE `capabuil_tblhr_procedure_retire` (
  `id` int NOT NULL AUTO_INCREMENT,
  `rel_name` text,
  `option_name` text,
  `status` int DEFAULT '1',
  `people_handle_id` int NOT NULL,
  `procedure_retire_id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `capabuil_tblhr_procedure_retire`
--


--
-- Table structure for table `capabuil_tblhr_procedure_retire_manage`
--

CREATE TABLE `capabuil_tblhr_procedure_retire_manage` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name_procedure_retire` text NOT NULL,
  `department` varchar(250) NOT NULL,
  `datecreator` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
