(2040,'client','contact-verification-email','francais_canada','Email Verification (Sent to Contact After Registration) [francais_canada]','Verify Email Address','','{companyname} | Service clients',NULL,0,1,0),(2041,'client','new-customer-profile-file-uploaded-to-staff','francais_canada','New Customer Profile File(s) Uploaded (Sent to Staff) [francais_canada]','Customer Uploaded New File(s) in Profile','','{companyname} | Service clients',NULL,0,1,0),(2042,'staff','event-notification-to-staff','francais_canada','Event Notification (Calendar) [francais_canada]','Upcoming Event - {event_title}','','{companyname} | Service clients',NULL,0,1,0),(2043,'subscriptions','subscription-payment-requires-action','francais_canada','Credit Card Authorization Required - SCA [francais_canada]','Important: Confirm your subscription {subscription_name} payment','','{companyname} | Service clients',NULL,0,1,0),(2044,'invoice','invoice-due-notice','francais_canada','Invoice Due Notice [francais_canada]','Your {invoice_number} will be due soon','','{companyname} | Service clients',NULL,0,1,0),(2045,'estimate_request','estimate-request-submitted-to-staff','francais_canada','Estimate Request Submitted (Sent to Staff) [francais_canada]','New Estimate Request Submitted','','{companyname} | Service clients',NULL,0,1,0),(2046,'estimate_request','estimate-request-assigned','francais_canada','Estimate Request Assigned (Sent to Staff) [francais_canada]','New Estimate Request Assigned','','{companyname} | Service clients',NULL,0,1,0),(2047,'estimate_request','estimate-request-received-to-user','francais_canada','Estimate Request Received (Sent to User) [francais_canada]','Estimate Request Received','','{companyname} | Service clients',NULL,0,0,0),(2048,'notifications','non-billed-tasks-reminder','francais_canada','Non-billed tasks reminder (sent to selected staff members) [francais_canada]','Action required: Completed tasks are not billed','','{companyname} | Service clients',NULL,0,1,0),(2049,'invoice','invoices-batch-payments','francais_canada','Invoices Payments Recorded in Batch (Sent to Customer) [francais_canada]','We have received your payments','','{companyname} | Service clients',NULL,0,1,0),(2050,'contract','contract-sign-reminder','francais_canada','Contract Sign Reminder (Sent to Customer) [francais_canada]','Contract Sign Reminder','','{companyname} | Service clients',NULL,0,1,0),(2051,'client','new-client-created','dutch','New Contact Added/Registered (Welcome Email) [dutch]','Welcome aboard','','{companyname} | Service clients','',0,1,0),(2052,'invoice','invoice-send-to-client','dutch','Send Invoice to Customer [dutch]','Invoice with number {invoice_number} created','','{companyname} | Service clients',NULL,0,1,0),(2053,'ticket','new-ticket-opened-admin','dutch','New Ticket Opened (Opened by Staff, Sent to Customer) [dutch]','New Support Ticket Opened','','{companyname} | Service clients',NULL,0,1,0),(2054,'ticket','ticket-reply','dutch','Ticket Reply (Sent to Customer) [dutch]','New Ticket Reply','','{companyname} | Service clients',NULL,0,1,0),(2055,'ticket','ticket-autoresponse','dutch','New Ticket Opened - Autoresponse [dutch]','New Support Ticket Opened','','{companyname} | Service clients',NULL,0,1,0),(2056,'invoice','invoice-payment-recorded','dutch','Invoice Payment Recorded (Sent to Customer) [dutch]','Invoice Payment Recorded','','{companyname} | Service clients',NULL,0,1,0),(2057,'invoice','invoice-overdue-notice','dutch','Invoice Overdue Notice [dutch]','Invoice Overdue Notice - {invoice_number}','','{companyname} | Service clients',NULL,0,1,0),(2058,'invoice','invoice-already-send','dutch','Invoice Already Sent to Customer [dutch]','Invoice # {invoice_number} ','','{companyname} | Service clients',NULL,0,1,0),(2059,'ticket','new-ticket-created-staff','dutch','New Ticket Created (Opened by Customer, Sent to Staff Members) [dutch]','New Ticket Created','','{companyname} | Service clients',NULL,0,1,0),(2060,'estimate','estimate-send-to-client','dutch','Send Estimate to Customer [dutch]','Estimate # {estimate_number} created','','{companyname} | Service clients',NULL,0,1,0),(2061,'ticket','ticket-reply-to-admin','dutch','Ticket Reply (Sent to Staff) [dutch]','New Support Ticket Reply','','{companyname} | Service clients',NULL,0,1,0),(2062,'estimate','estimate-already-send','dutch','Estimate Already Sent to Customer [dutch]','Estimate # {estimate_number} ','','{companyname} | Service clients',NULL,0,1,0),(2063,'contract','contract-expiration','dutch','Contract Expiration Reminder (Sent to Customer Contacts) [dutch]','Contract Expiration Reminder','','{companyname} | Service clients',NULL,0,1,0),(2064,'tasks','task-assigned','dutch','New Task Assigned (Sent to Staff) [dutch]','New Task Assigned to You - {task_name}','','{companyname} | Service clients',NULL,0,1,0),(2065,'tasks','task-added-as-follower','dutch','Staff Member Added as Follower on Task (Sent to Staff) [dutch]','You are added as follower on task - {task_name}','','{companyname} | Service clients',NULL,0,1,0),(2066,'tasks','task-commented','dutch','New Comment on Task (Sent to Staff) [dutch]','New Comment on Task - {task_name}','','{companyname} | Service clients',NULL,0,1,0),(2067,'tasks','task-added-attachment','dutch','New Attachment(s) on Task (Sent to Staff) [dutch]','New Attachment on Task - {task_name}','','{companyname} | Service clients',NULL,0,1,0),(2068,'estimate','estimate-declined-to-staff','dutch','Estimate Declined (Sent to Staff) [dutch]','Customer Declined Estimate','','{companyname} | Service clients',NULL,0,1,0),(2069,'estimate','estimate-accepted-to-staff','dutch','Estimate Accepted (Sent to Staff) [dutch]','Customer Accepted Estimate','','{companyname} | Service clients',NULL,0,1,0),(2070,'proposals','proposal-client-accepted','dutch','Customer Action - Accepted (Sent to Staff) [dutch]','Customer Accepted Proposal','','{companyname} | Service clients',NULL,0,1,0),(2071,'proposals','proposal-send-to-customer','dutch','Send Proposal to Customer [dutch]','Proposal With Number {proposal_number} Created','','{companyname} | Service clients',NULL,0,1,0),(2072,'proposals','proposal-client-declined','dutch','Customer Action - Declined (Sent to Staff) [dutch]','Client Declined Proposal','','{companyname} | Service clients',NULL,0,1,0),(2073,'proposals','proposal-client-thank-you','dutch','Thank You Email (Sent to Customer After Accept) [dutch]','Thank for you accepting proposal','','{companyname} | Service clients',NULL,0,1,0),(2074,'proposals','proposal-comment-to-client','dutch','New Comment  (Sent to Customer/Lead) [dutch]','New Proposal Comment','','{companyname} | Service clients',NULL,0,1,0),(2075,'proposals','proposal-comment-to-admin','dutch','New Comment (Sent to Staff)  [dutch]','New Proposal Comment','','{companyname} | Service clients',NULL,0,1,0),(2076,'estimate','estimate-thank-you-to-customer','dutch','Thank You Email (Sent to Customer After Accept) [dutch]','Thank for you accepting estimate','','{companyname} | Service clients',NULL,0,1,0),(2077,'tasks','task-deadline-notification','dutch','Task Deadline Reminder - Sent to Assigned Members [dutch]','Task Deadline Reminder','','{companyname} | Service clients',NULL,0,1,0),(2078,'contract','send-contract','dutch','Send Contract to Customer [dutch]','Contract - {contract_subject}','','{companyname} | Service clients',NULL,0,1,0),(2079,'invoice','invoice-payment-recorded-to-staff','dutch','Invoice Payment Recorded (Sent to Staff) [dutch]','New Invoice Payment','','{companyname} | Service clients',NULL,0,1,0),(2080,'ticket','auto-close-ticket','dutch','Auto Close Ticket [dutch]','Ticket Auto Closed','','{companyname} | Service clients',NULL,0,1,0),(2081,'project','new-project-discussion-created-to-staff','dutch','New Project Discussion (Sent to Project Members) [dutch]','New Project Discussion Created - {project_name}','','{companyname} | Service clients',NULL,0,1,0),(2082,'project','new-project-discussion-created-to-customer','dutch','New Project Discussion (Sent to Customer Contacts) [dutch]','New Project Discussion Created - {project_name}','','{companyname} | Service clients',NULL,0,1,0),(2083,'project','new-project-file-uploaded-to-customer','dutch','New Project File(s) Uploaded (Sent to Customer Contacts) [dutch]','New Project File(s) Uploaded - {project_name}','','{companyname} | Service clients',NULL,0,1,0),(2084,'project','new-project-file-uploaded-to-staff','dutch','New Project File(s) Uploaded (Sent to Project Members) [dutch]','New Project File(s) Uploaded - {project_name}','','{companyname} | Service clients',NULL,0,1,0),(2085,'project','new-project-discussion-comment-to-customer','dutch','New Discussion Comment  (Sent to Customer Contacts) [dutch]','New Discussion Comment','','{companyname} | Service clients',NULL,0,1,0),(2086,'project','new-project-discussion-comment-to-staff','dutch','New Discussion Comment (Sent to Project Members) [dutch]','New Discussion Comment','','{companyname} | Service clients',NULL,0,1,0),(2087,'project','staff-added-as-project-member','dutch','Staff Added as Project Member [dutch]','New project assigned to you','','{companyname} | Service clients',NULL,0,1,0),(2088,'estimate','estimate-expiry-reminder','dutch','Estimate Expiration Reminder [dutch]','Estimate Expiration Reminder','','{companyname} | Service clients',NULL,0,1,0),(2089,'proposals','proposal-expiry-reminder','dutch','Proposal Expiration Reminder [dutch]','Proposal Expiration Reminder','','{companyname} | Service clients',NULL,0,1,0),(2090,'staff','new-staff-created','dutch','New Staff Created (Welcome Email) [dutch]','You are added as staff member','','{companyname} | Service clients',NULL,0,1,0),(2091,'client','contact-forgot-password','dutch','Forgot Password [dutch]','Create New Password','','{companyname} | Service clients',NULL,0,1,0),(2092,'client','contact-password-reseted','dutch','Password Reset - Confirmation [dutch]','Your password has been changed','','{companyname} | Service clients',NULL,0,1,0),(2093,'client','contact-set-password','dutch','Set New Password [dutch]','Set new password on {companyname} ','','{companyname} | Service clients','',0,1,0),(2094,'staff','staff-forgot-password','dutch','Forgot Password [dutch]','Create New Password','','{companyname} | Service clients',NULL,0,1,0),(2095,'staff','staff-password-reseted','dutch','Password Reset - Confirmation [dutch]','Your password has been changed','','{companyname} | Service clients',NULL,0,1,0),(2096,'project','assigned-to-project','dutch','New Project Created (Sent to Customer Contacts) [dutch]','New Project Created','','{companyname} | Service clients',NULL,0,1,0),(2097,'tasks','task-added-attachment-to-contacts','dutch','New Attachment(s) on Task (Sent to Customer Contacts) [dutch]','New Attachment on Task - {task_name}','','{companyname} | Service clients',NULL,0,1,0),(2098,'tasks','task-commented-to-contacts','dutch','New Comment on Task (Sent to Customer Contacts) [dutch]','New Comment on Task - {task_name}','','{companyname} | Service clients',NULL,0,1,0),(2099,'leads','new-lead-assigned','dutch','New Lead Assigned to Staff Member [dutch]','New lead assigned to you','','{companyname} | Service clients',NULL,0,1,0),(2100,'client','client-statement','dutch','Statement - Account Summary [dutch]','Account Statement from {statement_from} to {statement_to}','','{companyname} | Service clients',NULL,0,1,0),(2101,'ticket','ticket-assigned-to-admin','dutch','New Ticket Assigned (Sent to Staff) [dutch]','New support ticket has been assigned to you','','{companyname} | Service clients',NULL,0,1,0),(2102,'client','new-client-registered-to-admin','dutch','New Customer Registration (Sent to admins) [dutch]','New Customer Registration','','{companyname} | Service clients',NULL,0,1,0),(2103,'leads','new-web-to-lead-form-submitted','dutch','Web to lead form submitted - Sent to lead [dutch]','{lead_name} - We Received Your Request','','{companyname} | Service clients',NULL,0,0,0),(2104,'staff','two-factor-authentication','dutch','Two Factor Authentication [dutch]','Confirm Your Login','','{companyname} | Service clients',NULL,0,1,0),(2105,'project','project-finished-to-customer','dutch','Project Marked as Finished (Sent to Customer Contacts) [dutch]','Project Marked as Finished','','{companyname} | Service clients',NULL,0,1,0),(2106,'credit_note','credit-note-send-to-client','dutch','Send Credit Note To Email [dutch]','Credit Note With Number #{credit_note_number} Created','','{companyname} | Service clients',NULL,0,1,0),(2107,'tasks','task-status-change-to-staff','dutch','Task Status Changed (Sent to Staff) [dutch]','Task Status Changed','','{companyname} | Service clients',NULL,0,1,0),(2108,'tasks','task-status-change-to-contacts','dutch','Task Status Changed (Sent to Customer Contacts) [dutch]','Task Status Changed','','{companyname} | Service clients',NULL,0,1,0),(2109,'staff','reminder-email-staff','dutch','Staff Reminder Email [dutch]','You Have a New Reminder!','','{companyname} | Service clients',NULL,0,1,0),(2110,'contract','contract-comment-to-client','dutch','New Comment  (Sent to Customer Contacts) [dutch]','New Contract Comment','','{companyname} | Service clients',NULL,0,1,0),(2111,'contract','contract-comment-to-admin','dutch','New Comment (Sent to Staff)  [dutch]','New Contract Comment','','{companyname} | Service clients',NULL,0,1,0),(2112,'subscriptions','send-subscription','dutch','Send Subscription to Customer [dutch]','Subscription Created','','{companyname} | Service clients',NULL,0,1,0),(2113,'subscriptions','subscription-payment-failed','dutch','Subscription Payment Failed [dutch]','Your most recent invoice payment failed','','{companyname} | Service clients',NULL,0,1,0),(2114,'subscriptions','subscription-canceled','dutch','Subscription Canceled (Sent to customer primary contact) [dutch]','Your subscription has been canceled','','{companyname} | Service clients',NULL,0,1,0),(2115,'subscriptions','subscription-payment-succeeded','dutch','Subscription Payment Succeeded (Sent to customer primary contact) [dutch]','Subscription  Payment Receipt - {subscription_name}','','{companyname} | Service clients',NULL,0,1,0),(2116,'contract','contract-expiration-to-staff','dutch','Contract Expiration Reminder (Sent to Staff) [dutch]','Contract Expiration Reminder','','{companyname} | Service clients',NULL,0,1,0),(2117,'gdpr','gdpr-removal-request','dutch','Removal Request From Contact (Sent to administrators) [dutch]','Data Removal Request Received','','{companyname} | Service clients',NULL,0,1,0),(2118,'gdpr','gdpr-removal-request-lead','dutch','Removal Request From Lead (Sent to administrators) [dutch]','Data Removal Request Received','','{companyname} | Service clients',NULL,0,1,0),(2119,'client','client-registration-confirmed','dutch','Customer Registration Confirmed [dutch]','Your registration is confirmed','','{companyname} | Service clients',NULL,0,1,0),(2120,'contract','contract-signed-to-staff','dutch','Contract Signed (Sent to Staff) [dutch]','Customer Signed a Contract','','{companyname} | Service clients',NULL,0,1,0),(2121,'subscriptions','customer-subscribed-to-staff','dutch','Customer Subscribed to a Subscription (Sent to administrators and subscription creator) [dutch]','Customer Subscribed to a Subscription','','{companyname} | Service clients',NULL,0,1,0),(2122,'client','contact-verification-email','dutch','Email Verification (Sent to Contact After Registration) [dutch]','Verify Email Address','','{companyname} | Service clients',NULL,0,1,0),(2123,'client','new-customer-profile-file-uploaded-to-staff','dutch','New Customer Profile File(s) Uploaded (Sent to Staff) [dutch]','Customer Uploaded New File(s) in Profile','','{companyname} | Service clients',NULL,0,1,0),(2124,'staff','event-notification-to-staff','dutch','Event Notification (Calendar) [dutch]','Upcoming Event - {event_title}','','{companyname} | Service clients',NULL,0,1,0),(2125,'subscriptions','subscription-payment-requires-action','dutch','Credit Card Authorization Required - SCA [dutch]','Important: Confirm your subscription {subscription_name} payment','','{companyname} | Service clients',NULL,0,1,0),(2126,'invoice','invoice-due-notice','dutch','Invoice Due Notice [dutch]','Your {invoice_number} will be due soon','','{companyname} | Service clients',NULL,0,1,0),(2127,'estimate_request','estimate-request-submitted-to-staff','dutch','Estimate Request Submitted (Sent to Staff) [dutch]','New Estimate Request Submitted','','{companyname} | Service clients',NULL,0,1,0),(2128,'estimate_request','estimate-request-assigned','dutch','Estimate Request Assigned (Sent to Staff) [dutch]','New Estimate Request Assigned','','{companyname} | Service clients',NULL,0,1,0),(2129,'estimate_request','estimate-request-received-to-user','dutch','Estimate Request Received (Sent to User) [dutch]','Estimate Request Received','','{companyname} | Service clients',NULL,0,0,0),(2130,'notifications','non-billed-tasks-reminder','dutch','Non-billed tasks reminder (sent to selected staff members) [dutch]','Action required: Completed tasks are not billed','','{companyname} | Service clients',NULL,0,1,0),(2131,'invoice','invoices-batch-payments','dutch','Invoices Payments Recorded in Batch (Sent to Customer) [dutch]','We have received your payments','','{companyname} | Service clients',NULL,0,1,0),(2132,'contract','contract-sign-reminder','dutch','Contract Sign Reminder (Sent to Customer) [dutch]','Contract Sign Reminder','','{companyname} | Service clients',NULL,0,1,0),(2133,'client','new-client-created','polish','New Contact Added/Registered (Welcome Email) [polish]','Welcome aboard','','{companyname} | Service clients','',0,1,0),(2134,'invoice','invoice-send-to-client','polish','Send Invoice to Customer [polish]','Invoice with number {invoice_number} created','','{companyname} | Service clients',NULL,0,1,0),(2135,'ticket','new-ticket-opened-admin','polish','New Ticket Opened (Opened by Staff, Sent to Customer) [polish]','New Support Ticket Opened','','{companyname} | Service clients',NULL,0,1,0),(2136,'ticket','ticket-reply','polish','Ticket Reply (Sent to Customer) [polish]','New Ticket Reply','','{companyname} | Service clients',NULL,0,1,0),(2137,'ticket','ticket-autoresponse','polish','New Ticket Opened - Autoresponse [polish]','New Support Ticket Opened','','{companyname} | Service clients',NULL,0,1,0),(2138,'invoice','invoice-payment-recorded','polish','Invoice Payment Recorded (Sent to Customer) [polish]','Invoice Payment Recorded','','{companyname} | Service clients',NULL,0,1,0),(2139,'invoice','invoice-overdue-notice','polish','Invoice Overdue Notice [polish]','Invoice Overdue Notice - {invoice_number}','','{companyname} | Service clients',NULL,0,1,0),(2140,'invoice','invoice-already-send','polish','Invoice Already Sent to Customer [polish]','Invoice # {invoice_number} ','','{companyname} | Service clients',NULL,0,1,0),(2141,'ticket','new-ticket-created-staff','polish','New Ticket Created (Opened by Customer, Sent to Staff Members) [polish]','New Ticket Created','','{companyname} | Service clients',NULL,0,1,0),(2142,'estimate','estimate-send-to-client','polish','Send Estimate to Customer [polish]','Estimate # {estimate_number} created','','{companyname} | Service clients',NULL,0,1,0),(2143,'ticket','ticket-reply-to-admin','polish','Ticket Reply (Sent to Staff) [polish]','New Support Ticket Reply','','{companyname} | Service clients',NULL,0,1,0),(2144,'estimate','estimate-already-send','polish','Estimate Already Sent to Customer [polish]','Estimate # {estimate_number} ','','{companyname} | Service clients',NULL,0,1,0),(2145,'contract','contract-expiration','polish','Contract Expiration Reminder (Sent to Customer Contacts) [polish]','Contract Expiration Reminder','','{companyname} | Service clients',NULL,0,1,0),(2146,'tasks','task-assigned','polish','New Task Assigned (Sent to Staff) [polish]','New Task Assigned to You - {task_name}','','{companyname} | Service clients',NULL,0,1,0),(2147,'tasks','task-added-as-follower','polish','Staff Member Added as Follower on Task (Sent to Staff) [polish]','You are added as follower on task - {task_name}','','{companyname} | Service clients',NULL,0,1,0),(2148,'tasks','task-commented','polish','New Comment on Task (Sent to Staff) [polish]','New Comment on Task - {task_name}','','{companyname} | Service clients',NULL,0,1,0),(2149,'tasks','task-added-attachment','polish','New Attachment(s) on Task (Sent to Staff) [polish]','New Attachment on Task - {task_name}','','{companyname} | Service clients',NULL,0,1,0),(2150,'estimate','estimate-declined-to-staff','polish','Estimate Declined (Sent to Staff) [polish]','Customer Declined Estimate','','{companyname} | Service clients',NULL,0,1,0),(2151,'estimate','estimate-accepted-to-staff','polish','Estimate Accepted (Sent to Staff) [polish]','Customer Accepted Estimate','','{companyname} | Service clients',NULL,0,1,0),(2152,'proposals','proposal-client-accepted','polish','Customer Action - Accepted (Sent to Staff) [polish]','Customer Accepted Proposal','','{companyname} | Service clients',NULL,0,1,0),(2153,'proposals','proposal-send-to-customer','polish','Send Proposal to Customer [polish]','Proposal With Number {proposal_number} Created','','{companyname} | Service clients',NULL,0,1,0),(2154,'proposals','proposal-client-declined','polish','Customer Action - Declined (Sent to Staff) [polish]','Client Declined Proposal','','{companyname} | Service clients',NULL,0,1,0),(2155,'proposals','proposal-client-thank-you','polish','Thank You Email (Sent to Customer After Accept) [polish]','Thank for you accepting proposal','','{companyname} | Service clients',NULL,0,1,0),(2156,'proposals','proposal-comment-to-client','polish','New Comment  (Sent to Customer/Lead) [polish]','New Proposal Comment','','{companyname} | Service clients',NULL,0,1,0),(2157,'proposals','proposal-comment-to-admin','polish','New Comment (Sent to Staff)  [polish]','New Proposal Comment','','{companyname} | Service clients',NULL,0,1,0),(2158,'estimate','estimate-thank-you-to-customer','polish','Thank You Email (Sent to Customer After Accept) [polish]','Thank for you accepting estimate','','{companyname} | Service clients',NULL,0,1,0),(2159,'tasks','task-deadline-notification','polish','Task Deadline Reminder - Sent to Assigned Members [polish]','Task Deadline Reminder','','{companyname} | Service clients',NULL,0,1,0),(2160,'contract','send-contract','polish','Send Contract to Customer [polish]','Contract - {contract_subject}','','{companyname} | Service clients',NULL,0,1,0),(2161,'invoice','invoice-payment-recorded-to-staff','polish','Invoice Payment Recorded (Sent to Staff) [polish]','New Invoice Payment','','{companyname} | Service clients',NULL,0,1,0),(2162,'ticket','auto-close-ticket','polish','Auto Close Ticket [polish]','Ticket Auto Closed','','{companyname} | Service clients',NULL,0,1,0),(2163,'project','new-project-discussion-created-to-staff','polish','New Project Discussion (Sent to Project Members) [polish]','New Project Discussion Created - {project_name}','','{companyname} | Service clients',NULL,0,1,0),(2164,'project','new-project-discussion-created-to-customer','polish','New Project Discussion (Sent to Customer Contacts) [polish]','New Project Discussion Created - {project_name}','','{companyname} | Service clients',NULL,0,1,0),(2165,'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} | Service clients',NULL,0,1,0),(2166,'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} | Service clients',NULL,0,1,0),(2167,'project','new-project-discussion-comment-to-customer','polish','New Discussion Comment  (Sent to Customer Contacts) [polish]','New Discussion Comment','','{companyname} | Service clients',NULL,0,1,0),(2168,'project','new-project-discussion-comment-to-staff','polish','New Discussion Comment (Sent to Project Members) [polish]','New Discussion Comment','','{companyname} | Service clients',NULL,0,1,0),(2169,'project','staff-added-as-project-member','polish','Staff Added as Project Member [polish]','New project assigned to you','','{companyname} | Service clients',NULL,0,1,0),(2170,'estimate','estimate-expiry-reminder','polish','Estimate Expiration Reminder [polish]','Estimate Expiration Reminder','','{companyname} | Service clients',NULL,0,1,0),(2171,'proposals','proposal-expiry-reminder','polish','Proposal Expiration Reminder [polish]','Proposal Expiration Reminder','','{companyname} | Service clients',NULL,0,1,0),(2172,'staff','new-staff-created','polish','New Staff Created (Welcome Email) [polish]','You are added as staff member','','{companyname} | Service clients',NULL,0,1,0),(2173,'client','contact-forgot-password','polish','Forgot Password [polish]','Create New Password','','{companyname} | Service clients',NULL,0,1,0),(2174,'client','contact-password-reseted','polish','Password Reset - Confirmation [polish]','Your password has been changed','','{companyname} | Service clients',NULL,0,1,0),(2175,'client','contact-set-password','polish','Set New Password [polish]','Set new password on {companyname} ','','{companyname} | Service clients','',0,1,0),(2176,'staff','staff-forgot-password','polish','Forgot Password [polish]','Create New Password','','{companyname} | Service clients',NULL,0,1,0),(2177,'staff','staff-password-reseted','polish','Password Reset - Confirmation [polish]','Your password has been changed','','{companyname} | Service clients',NULL,0,1,0),(2178,'project','assigned-to-project','polish','New Project Created (Sent to Customer Contacts) [polish]','New Project Created','','{companyname} | Service clients',NULL,0,1,0),(2179,'tasks','task-added-attachment-to-contacts','polish','New Attachment(s) on Task (Sent to Customer Contacts) [polish]','New Attachment on Task - {task_name}','','{companyname} | Service clients',NULL,0,1,0),(2180,'tasks','task-commented-to-contacts','polish','New Comment on Task (Sent to Customer Contacts) [polish]','New Comment on Task - {task_name}','','{companyname} | Service clients',NULL,0,1,0),(2181,'leads','new-lead-assigned','polish','New Lead Assigned to Staff Member [polish]','New lead assigned to you','','{companyname} | Service clients',NULL,0,1,0),(2182,'client','client-statement','polish','Statement - Account Summary [polish]','Account Statement from {statement_from} to {statement_to}','','{companyname} | Service clients',NULL,0,1,0),(2183,'ticket','ticket-assigned-to-admin','polish','New Ticket Assigned (Sent to Staff) [polish]','New support ticket has been assigned to you','','{companyname} | Service clients',NULL,0,1,0),(2184,'client','new-client-registered-to-admin','polish','New Customer Registration (Sent to admins) [polish]','New Customer Registration','','{companyname} | Service clients',NULL,0,1,0),(2185,'leads','new-web-to-lead-form-submitted','polish','Web to lead form submitted - Sent to lead [polish]','{lead_name} - We Received Your Request','','{companyname} | Service clients',NULL,0,0,0),(2186,'staff','two-factor-authentication','polish','Two Factor Authentication [polish]','Confirm Your Login','','{companyname} | Service clients',NULL,0,1,0),(2187,'project','project-finished-to-customer','polish','Project Marked as Finished (Sent to Customer Contacts) [polish]','Project Marked as Finished','','{companyname} | Service clients',NULL,0,1,0),(2188,'credit_note','credit-note-send-to-client','polish','Send Credit Note To Email [polish]','Credit Note With Number #{credit_note_number} Created','','{companyname} | Service clients',NULL,0,1,0),(2189,'tasks','task-status-change-to-staff','polish','Task Status Changed (Sent to Staff) [polish]','Task Status Changed','','{companyname} | Service clients',NULL,0,1,0),(2190,'tasks','task-status-change-to-contacts','polish','Task Status Changed (Sent to Customer Contacts) [polish]','Task Status Changed','','{companyname} | Service clients',NULL,0,1,0),(2191,'staff','reminder-email-staff','polish','Staff Reminder Email [polish]','You Have a New Reminder!','','{companyname} | Service clients',NULL,0,1,0),(2192,'contract','contract-comment-to-client','polish','New Comment  (Sent to Customer Contacts) [polish]','New Contract Comment','','{companyname} | Service clients',NULL,0,1,0),(2193,'contract','contract-comment-to-admin','polish','New Comment (Sent to Staff)  [polish]','New Contract Comment','','{companyname} | Service clients',NULL,0,1,0),(2194,'subscriptions','send-subscription','polish','Send Subscription to Customer [polish]','Subscription Created','','{companyname} | Service clients',NULL,0,1,0),(2195,'subscriptions','subscription-payment-failed','polish','Subscription Payment Failed [polish]','Your most recent invoice payment failed','','{companyname} | Service clients',NULL,0,1,0),(2196,'subscriptions','subscription-canceled','polish','Subscription Canceled (Sent to customer primary contact) [polish]','Your subscription has been canceled','','{companyname} | Service clients',NULL,0,1,0),(2197,'subscriptions','subscription-payment-succeeded','polish','Subscription Payment Succeeded (Sent to customer primary contact) [polish]','Subscription  Payment Receipt - {subscription_name}','','{companyname} | Service clients',NULL,0,1,0),(2198,'contract','contract-expiration-to-staff','polish','Contract Expiration Reminder (Sent to Staff) [polish]','Contract Expiration Reminder','','{companyname} | Service clients',NULL,0,1,0),(2199,'gdpr','gdpr-removal-request','polish','Removal Request From Contact (Sent to administrators) [polish]','Data Removal Request Received','','{companyname} | Service clients',NULL,0,1,0),(2200,'gdpr','gdpr-removal-request-lead','polish','Removal Request From Lead (Sent to administrators) [polish]','Data Removal Request Received','','{companyname} | Service clients',NULL,0,1,0),(2201,'client','client-registration-confirmed','polish','Customer Registration Confirmed [polish]','Your registration is confirmed','','{companyname} | Service clients',NULL,0,1,0),(2202,'contract','contract-signed-to-staff','polish','Contract Signed (Sent to Staff) [polish]','Customer Signed a Contract','','{companyname} | Service clients',NULL,0,1,0),(2203,'subscriptions','customer-subscribed-to-staff','polish','Customer Subscribed to a Subscription (Sent to administrators and subscription creator) [polish]','Customer Subscribed to a Subscription','','{companyname} | Service clients',NULL,0,1,0),(2204,'client','contact-verification-email','polish','Email Verification (Sent to Contact After Registration) [polish]','Verify Email Address','','{companyname} | Service clients',NULL,0,1,0),(2205,'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} | Service clients',NULL,0,1,0),(2206,'staff','event-notification-to-staff','polish','Event Notification (Calendar) [polish]','Upcoming Event - {event_title}','','{companyname} | Service clients',NULL,0,1,0),(2207,'subscriptions','subscription-payment-requires-action','polish','Credit Card Authorization Required - SCA [polish]','Important: Confirm your subscription {subscription_name} payment','','{companyname} | Service clients',NULL,0,1,0),(2208,'invoice','invoice-due-notice','polish','Invoice Due Notice [polish]','Your {invoice_number} will be due soon','','{companyname} | Service clients',NULL,0,1,0),(2209,'estimate_request','estimate-request-submitted-to-staff','polish','Estimate Request Submitted (Sent to Staff) [polish]','New Estimate Request Submitted','','{companyname} | Service clients',NULL,0,1,0),(2210,'estimate_request','estimate-request-assigned','polish','Estimate Request Assigned (Sent to Staff) [polish]','New Estimate Request Assigned','','{companyname} | Service clients',NULL,0,1,0),(2211,'estimate_request','estimate-request-received-to-user','polish','Estimate Request Received (Sent to User) [polish]','Estimate Request Received','','{companyname} | Service clients',NULL,0,0,0),(2212,'notifications','non-billed-tasks-reminder','polish','Non-billed tasks reminder (sent to selected staff members) [polish]','Action required: Completed tasks are not billed','','{companyname} | Service clients',NULL,0,1,0),(2213,'invoice','invoices-batch-payments','polish','Invoices Payments Recorded in Batch (Sent to Customer) [polish]','We have received your payments','','{companyname} | Service clients',NULL,0,1,0),(2214,'contract','contract-sign-reminder','polish','Contract Sign Reminder (Sent to Customer) [polish]','Contract Sign Reminder','','{companyname} | Service clients',NULL,0,1,0),(2215,'webhooks','webhook-failed','english','Webhook failed','Webhook failed','','{companyname} | Service clients',NULL,0,1,0),(2216,'webhooks','webhook-failed','turkish','Webhook failed [turkish]','Webhook failed','','{companyname} | Service clients',NULL,0,1,0),(2217,'webhooks','webhook-failed','norwegian','Webhook failed [norwegian]','Webhook failed','','{companyname} | Service clients',NULL,0,1,0),(2218,'webhooks','webhook-failed','japanese','Webhook failed [japanese]','Webhook failed','','{companyname} | Service clients',NULL,0,1,0),(2219,'webhooks','webhook-failed','russian','Webhook failed [russian]','Webhook failed','','{companyname} | Service clients',NULL,0,1,0),(2220,'webhooks','webhook-failed','ukrainian','Webhook failed [ukrainian]','Webhook failed','','{companyname} | Service clients',NULL,0,1,0),(2221,'webhooks','webhook-failed','swedish','Webhook failed [swedish]','Webhook failed','','{companyname} | Service clients',NULL,0,1,0),(2222,'webhooks','webhook-failed','bulgarian','Webhook failed [bulgarian]','Webhook failed','','{companyname} | Service clients',NULL,0,1,0),(2223,'webhooks','webhook-failed','vietnamese','Webhook failed [vietnamese]','Webhook failed','','{companyname} | Service clients',NULL,0,1,0),(2224,'webhooks','webhook-failed','slovak','Webhook failed [slovak]','Webhook failed','','{companyname} | Service clients',NULL,0,1,0),(2225,'webhooks','webhook-failed','french','Webhook failed [french]','Échec du webhook','','{companyname} | Service clients',NULL,0,1,0),(2226,'webhooks','webhook-failed','persian','Webhook failed [persian]','Webhook failed','','{companyname} | Service clients',NULL,0,1,0),(2227,'webhooks','webhook-failed','catalan','Webhook failed [catalan]','Webhook failed','','{companyname} | Service clients',NULL,0,1,0),(2228,'webhooks','webhook-failed','greek','Webhook failed [greek]','Webhook failed','','{companyname} | Service clients',NULL,0,1,0),(2229,'webhooks','webhook-failed','czech','Webhook failed [czech]','Webhook failed','','{companyname} | Service clients',NULL,0,1,0),(2230,'webhooks','webhook-failed','chinese','Webhook failed [chinese]','Webhook failed','','{companyname} | Service clients',NULL,0,1,0),(2231,'webhooks','webhook-failed','spanish','Webhook failed [spanish]','Webhook failed','','{companyname} | Service clients',NULL,0,1,0),(2232,'webhooks','webhook-failed','portuguese','Webhook failed [portuguese]','Webhook failed','','{companyname} | Service clients',NULL,0,1,0),(2233,'webhooks','webhook-failed','finnish','Webhook failed [finnish]','Webhook failed','','{companyname} | Service clients',NULL,0,1,0),(2234,'webhooks','webhook-failed','italian','Webhook failed [italian]','Webhook failed','','{companyname} | Service clients',NULL,0,1,0),(2235,'webhooks','webhook-failed','indonesia','Webhook failed [indonesia]','Webhook failed','','{companyname} | Service clients',NULL,0,1,0),(2236,'webhooks','webhook-failed','portuguese_br','Webhook failed [portuguese_br]','Webhook failed','','{companyname} | Service clients',NULL,0,1,0),(2237,'webhooks','webhook-failed','german','Webhook failed [german]','Webhook failed','','{companyname} | Service clients',NULL,0,1,0),(2238,'webhooks','webhook-failed','romanian','Webhook failed [romanian]','Webhook failed','','{companyname} | Service clients',NULL,0,1,0),(2239,'webhooks','webhook-failed','francais_canada','Webhook failed [francais_canada]','Webhook failed','','{companyname} | Service clients',NULL,0,1,0),(2240,'webhooks','webhook-failed','dutch','Webhook failed [dutch]','Webhook failed','','{companyname} | Service clients',NULL,0,1,0),(2241,'webhooks','webhook-failed','polish','Webhook failed [polish]','Webhook failed','','{companyname} | Service clients',NULL,0,1,0),(2242,'staff','flexibackup-new-backup-to-staff','english','Flexi Backup Notification','New Backup Available  - {backup_name}','Hi there! <br /><br /> Please find attached a copy of your {backup_type} created on {backup_date}.  <br /><br /> Regards.','{companyname} | CRM',NULL,0,1,0),(2243,'staff','flexibackup-new-backup-to-staff','turkish','Flexi Backup Notification [turkish]','New Backup Available  - {backup_name}','','{companyname} | CRM',NULL,0,1,0),(2244,'staff','flexibackup-new-backup-to-staff','norwegian','Flexi Backup Notification [norwegian]','New Backup Available  - {backup_name}','','{companyname} | CRM',NULL,0,1,0),(2245,'staff','flexibackup-new-backup-to-staff','japanese','Flexi Backup Notification [japanese]','New Backup Available  - {backup_name}','','{companyname} | CRM',NULL,0,1,0),(2246,'staff','flexibackup-new-backup-to-staff','russian','Flexi Backup Notification [russian]','New Backup Available  - {backup_name}','','{companyname} | CRM',NULL,0,1,0),(2247,'staff','flexibackup-new-backup-to-staff','ukrainian','Flexi Backup Notification [ukrainian]','New Backup Available  - {backup_name}','','{companyname} | CRM',NULL,0,1,0),(2248,'staff','flexibackup-new-backup-to-staff','swedish','Flexi Backup Notification [swedish]','New Backup Available  - {backup_name}','','{companyname} | CRM',NULL,0,1,0),(2249,'staff','flexibackup-new-backup-to-staff','bulgarian','Flexi Backup Notification [bulgarian]','New Backup Available  - {backup_name}','','{companyname} | CRM',NULL,0,1,0),(2250,'staff','flexibackup-new-backup-to-staff','vietnamese','Flexi Backup Notification [vietnamese]','New Backup Available  - {backup_name}','','{companyname} | CRM',NULL,0,1,0),(2251,'staff','flexibackup-new-backup-to-staff','slovak','Flexi Backup Notification [slovak]','New Backup Available  - {backup_name}','','{companyname} | CRM',NULL,0,1,0),(2252,'staff','flexibackup-new-backup-to-staff','french','Flexi Backup Notification [french]','New Backup Available  - {backup_name}','','{companyname} | CRM',NULL,0,1,0),(2253,'staff','flexibackup-new-backup-to-staff','persian','Flexi Backup Notification [persian]','New Backup Available  - {backup_name}','','{companyname} | CRM',NULL,0,1,0),(2254,'staff','flexibackup-new-backup-to-staff','catalan','Flexi Backup Notification [catalan]','New Backup Available  - {backup_name}','','{companyname} | CRM',NULL,0,1,0),(2255,'staff','flexibackup-new-backup-to-staff','greek','Flexi Backup Notification [greek]','New Backup Available  - {backup_name}','','{companyname} | CRM',NULL,0,1,0),(2256,'staff','flexibackup-new-backup-to-staff','czech','Flexi Backup Notification [czech]','New Backup Available  - {backup_name}','','{companyname} | CRM',NULL,0,1,0),(2257,'staff','flexibackup-new-backup-to-staff','chinese','Flexi Backup Notification [chinese]','New Backup Available  - {backup_name}','','{companyname} | CRM',NULL,0,1,0),(2258,'staff','flexibackup-new-backup-to-staff','spanish','Flexi Backup Notification [spanish]','New Backup Available  - {backup_name}','','{companyname} | CRM',NULL,0,1,0),(2259,'staff','flexibackup-new-backup-to-staff','portuguese','Flexi Backup Notification [portuguese]','New Backup Available  - {backup_name}','','{companyname} | CRM',NULL,0,1,0),(2260,'staff','flexibackup-new-backup-to-staff','finnish','Flexi Backup Notification [finnish]','New Backup Available  - {backup_name}','','{companyname} | CRM',NULL,0,1,0),(2261,'staff','flexibackup-new-backup-to-staff','italian','Flexi Backup Notification [italian]','New Backup Available  - {backup_name}','','{companyname} | CRM',NULL,0,1,0),(2262,'staff','flexibackup-new-backup-to-staff','indonesia','Flexi Backup Notification [indonesia]','New Backup Available  - {backup_name}','','{companyname} | CRM',NULL,0,1,0),(2263,'staff','flexibackup-new-backup-to-staff','portuguese_br','Flexi Backup Notification [portuguese_br]','New Backup Available  - {backup_name}','','{companyname} | CRM',NULL,0,1,0),(2264,'staff','flexibackup-new-backup-to-staff','german','Flexi Backup Notification [german]','New Backup Available  - {backup_name}','','{companyname} | CRM',NULL,0,1,0),(2265,'staff','flexibackup-new-backup-to-staff','romanian','Flexi Backup Notification [romanian]','New Backup Available  - {backup_name}','','{companyname} | CRM',NULL,0,1,0),(2266,'staff','flexibackup-new-backup-to-staff','francais_canada','Flexi Backup Notification [francais_canada]','New Backup Available  - {backup_name}','','{companyname} | CRM',NULL,0,1,0),(2267,'staff','flexibackup-new-backup-to-staff','dutch','Flexi Backup Notification [dutch]','New Backup Available  - {backup_name}','','{companyname} | CRM',NULL,0,1,0),(2268,'staff','flexibackup-new-backup-to-staff','polish','Flexi Backup Notification [polish]','New Backup Available  - {backup_name}','','{companyname} | CRM',NULL,0,1,0);

--
-- Table structure for table `tblestimate_request_forms`
--

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


--
-- Table structure for table `tblestimate_request_status`
--

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

INSERT INTO `tblestimate_request_status` VALUES (1,'Annulé',1,'#808080','cancelled'),(2,'Traitement',2,'#007bff','processing'),(3,'Complété',3,'#28a745','completed');

--
-- Table structure for table `tblestimate_requests`
--

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


--
-- Table structure for table `tblestimates`
--

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


--
-- Table structure for table `tblevents`
--

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


--
-- Table structure for table `tblexpenses`
--

CREATE TABLE `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,
  PRIMARY KEY (`id`),
  KEY `clientid` (`clientid`),
  KEY `project_id` (`project_id`),
  KEY `category` (`category`),
  KEY `currency` (`currency`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblexpenses`
--


--
-- Table structure for table `tblexpenses_categories`
--

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

--
-- Dumping data for table `tblexpenses_categories`
--


--
-- Table structure for table `tblextended_email_log_activity`
--

CREATE TABLE `tblextended_email_log_activity` (
  `id` int NOT NULL AUTO_INCREMENT,
  `staffid` int NOT NULL,
  `email_userid` int NOT NULL,
  `description` varchar(255) NOT NULL,
  `datetime` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tblextended_email_log_activity`
--


--
-- Table structure for table `tblextended_email_settings`
--

CREATE TABLE `tblextended_email_settings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `userid` int NOT NULL,
  `mail_engine` varchar(150) NOT NULL,
  `email_protocol` varchar(150) NOT NULL,
  `smtp_encryption` varchar(150) NOT NULL,
  `smtp_host` varchar(150) NOT NULL,
  `smtp_port` varchar(150) NOT NULL,
  `email` varchar(150) NOT NULL,
  `smtp_username` varchar(150) NOT NULL,
  `smtp_password` text NOT NULL,
  `email_charset` varchar(150) NOT NULL,
  `active` tinyint NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tblextended_email_settings`
--


--
-- Table structure for table `tblfiles`
--

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

--
-- Dumping data for table `tblfiles`
--


--
-- Table structure for table `tblfilter_defaults`
--

CREATE TABLE `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 `staff_id` (`staff_id`),
  CONSTRAINT `tblfilter_defaults_ibfk_1` FOREIGN KEY (`filter_id`) REFERENCES `tblfilters` (`id`) ON DELETE CASCADE,
  CONSTRAINT `tblfilter_defaults_ibfk_2` FOREIGN KEY (`staff_id`) REFERENCES `tblstaff` (`staffid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblfilter_defaults`
--


--
-- Table structure for table `tblfilters`
--

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


--
-- Table structure for table `tblflexibackup`
--

CREATE TABLE `tblflexibackup` (
  `id` int NOT NULL AUTO_INCREMENT,
  `backup_name` varchar(255) NOT NULL,
  `backup_type` varchar(255) NOT NULL,
  `backup_data` varchar(255) NOT NULL,
  `datecreated` datetime NOT NULL,
  `uploaded_to_remote` tinyint NOT NULL DEFAULT '0',
  `note` mediumtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tblflexibackup`
--


--
-- Table structure for table `tblform_question_box`
--

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


--
-- Table structure for table `tblform_question_box_description`
--

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


--
-- Table structure for table `tblform_questions`
--

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


--
-- Table structure for table `tblform_results`
--

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


--
-- Table structure for table `tblgdpr_requests`
--

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


--
-- Table structure for table `tblinvoicepaymentrecords`
--

CREATE TABLE `tblinvoicepaymentrecords` (
  `id` int NOT NULL AUTO_INCREMENT,
  `invoiceid` int NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `paymentmode` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `paymentmethod` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date NOT NULL,
  `daterecorded` datetime NOT NULL,
  `note` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `transactionid` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `invoiceid` (`invoiceid`),
  KEY `paymentmethod` (`paymentmethod`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblinvoicepaymentrecords`
--


--
-- Table structure for table `tblinvoices`
--

CREATE TABLE `tblinvoices` (
  `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,
  `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,
  `datecreated` datetime NOT NULL,
  `date` date NOT NULL,
  `duedate` 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 DEFAULT NULL,
  `hash` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int DEFAULT '1',
  `clientnote` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `adminnote` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `last_overdue_reminder` date DEFAULT NULL,
  `last_due_reminder` date DEFAULT NULL,
  `cancel_overdue_reminders` int NOT NULL DEFAULT '0',
  `allowed_payment_modes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `token` longtext 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 NOT NULL,
  `recurring` int NOT NULL DEFAULT '0',
  `recurring_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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 DEFAULT NULL,
  `last_recurring_date` date DEFAULT NULL,
  `terms` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `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_invoice` tinyint(1) NOT NULL DEFAULT '1',
  `show_quantity_as` int NOT NULL DEFAULT '1',
  `project_id` int DEFAULT '0',
  `subscription_id` int NOT NULL DEFAULT '0',
  `short_link` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `currency` (`currency`),
  KEY `clientid` (`clientid`),
  KEY `project_id` (`project_id`),
  KEY `sale_agent` (`sale_agent`),
  KEY `total` (`total`),
  KEY `status` (`status`),
  KEY `formatted_number` (`formatted_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblinvoices`
--


--
-- Table structure for table `tblitem_tax`
--

CREATE TABLE `tblitem_tax` (
  `id` int NOT NULL AUTO_INCREMENT,
  `itemid` int NOT NULL,
  `rel_id` int NOT NULL,
  `rel_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `taxrate` decimal(15,2) NOT NULL,
  `taxname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `itemid` (`itemid`),
  KEY `rel_id` (`rel_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblitem_tax`
--


--
-- Table structure for table `tblitemable`
--

CREATE TABLE `tblitemable` (
  `id` int NOT NULL AUTO_INCREMENT,
  `rel_id` int NOT NULL,
  `rel_type` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `long_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `qty` decimal(15,2) NOT NULL,
  `rate` decimal(15,2) NOT NULL,
  `unit` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_optional` tinyint NOT NULL DEFAULT '0',
  `is_selected` tinyint NOT NULL DEFAULT '1',
  `item_order` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `rel_id` (`rel_id`),
  KEY `rel_type` (`rel_type`),
  KEY `qty` (`qty`),
  KEY `rate` (`rate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblitemable`
--


--
-- Table structure for table `tblitems`
--

CREATE TABLE `tblitems` (
  `id` int NOT NULL AUTO_INCREMENT,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `long_description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `rate` decimal(15,2) NOT NULL,
  `tax` int DEFAULT NULL,
  `tax2` int DEFAULT NULL,
  `unit` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `group_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `tax` (`tax`),
  KEY `tax2` (`tax2`),
  KEY `group_id` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblitems`
--


--
-- Table structure for table `tblitems_groups`
--

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

--
-- Dumping data for table `tblitems_groups`
--


--
-- Table structure for table `tblknowedge_base_article_feedback`
--

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

--
-- Dumping data for table `tblknowedge_base_article_feedback`
--


--
-- Table structure for table `tblknowledge_base`
--

CREATE TABLE `tblknowledge_base` (
  `articleid` int NOT NULL AUTO_INCREMENT,
  `articlegroup` int NOT NULL,
  `subject` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint NOT NULL,
  `datecreated` datetime NOT NULL,
  `article_order` int NOT NULL DEFAULT '0',
  `staff_article` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`articleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblknowledge_base`
--


--
-- Table structure for table `tblknowledge_base_groups`
--

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

--
-- Dumping data for table `tblknowledge_base_groups`
--


--
-- Table structure for table `tbllead_activity_log`
--

CREATE TABLE `tbllead_activity_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `leadid` int NOT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `additional_data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `date` datetime NOT NULL,
  `staffid` int NOT NULL,
  `full_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `custom_activity` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbllead_activity_log`
--

INSERT INTO `tbllead_activity_log` VALUES (1,1,'not_lead_activity_created','','2025-02-21 21:44:10',2,'Loïc Goaper',0),(2,1,'not_activity_new_task_created','a:1:{i:0;s:107:\"<a href=\"https://www.s-mob.fr/admin/tasks/view/1\" onclick=\"init_task_modal(1);return false;\">A rappeler</a>\";}','2025-02-21 21:44:57',2,'Loïc Goaper',0),(3,1,'not_activity_new_reminder_created','a:2:{i:0;s:12:\"Loïc Goaper\";i:1;s:19:\"21-02-2025 16:00:00\";}','2025-02-21 21:46:21',2,'Loïc Goaper',0),(4,1,'Infos manuelle','','2025-02-21 21:47:24',2,'Loïc Goaper',1),(5,1,'not_lead_activity_converted','a:1:{i:0;s:12:\"Loïc Goaper\";}','2025-02-21 21:49:13',2,'Loïc Goaper',0),(6,2,'not_lead_activity_created','','2025-03-17 12:03:59',4,'Elidion Keta',0),(7,3,'not_lead_activity_created','','2025-03-17 12:07:53',4,'Elidion Keta',0),(8,4,'not_lead_activity_created','','2025-03-17 12:10:18',4,'Elidion Keta',0),(9,5,'not_lead_activity_created','','2025-03-17 12:12:17',4,'Elidion Keta',0),(10,6,'not_lead_activity_created','','2025-03-17 12:15:10',4,'Elidion Keta',0),(11,7,'not_lead_activity_created','','2025-03-17 12:18:00',4,'Elidion Keta',0),(12,8,'not_lead_activity_created','','2025-03-17 12:23:05',4,'Elidion Keta',0),(13,9,'not_lead_activity_created','','2025-03-17 12:25:50',4,'Elidion Keta',0),(14,10,'not_lead_activity_created','','2025-03-17 12:28:29',4,'Elidion Keta',0),(15,11,'not_lead_activity_created','','2025-03-17 12:32:36',4,'Elidion Keta',0),(16,12,'not_lead_activity_created','','2025-03-17 12:39:53',4,'Elidion Keta',0),(17,13,'not_lead_activity_created','','2025-03-17 14:15:44',4,'Elidion Keta',0),(18,14,'not_lead_activity_created','','2025-03-17 14:20:08',4,'Elidion Keta',0),(19,15,'not_lead_activity_created','','2025-03-17 14:22:10',4,'Elidion Keta',0),(20,16,'not_lead_activity_created','','2025-03-17 14:27:06',4,'Elidion Keta',0),(21,17,'not_lead_activity_created','','2025-03-17 14:30:26',4,'Elidion Keta',0);

--
-- Table structure for table `tbllead_integration_emails`
--

CREATE TABLE `tbllead_integration_emails` (
  `id` int NOT NULL AUTO_INCREMENT,
  `subject` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `dateadded` datetime NOT NULL,
  `leadid` int NOT NULL,
  `emailid` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbllead_integration_emails`
--


--
-- Table structure for table `tblleads`
--

CREATE TABLE `tblleads` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hash` varchar(65) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `country` int NOT NULL DEFAULT '0',
  `zip` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `assigned` int NOT NULL DEFAULT '0',
  `dateadded` datetime NOT NULL,
  `from_form_id` int NOT NULL DEFAULT '0',
  `status` int NOT NULL,
  `source` int NOT NULL,
  `lastcontact` datetime DEFAULT NULL,
  `dateassigned` date DEFAULT NULL,
  `last_status_change` datetime DEFAULT NULL,
  `addedfrom` int NOT NULL,
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `website` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `leadorder` int DEFAULT '1',
  `phonenumber` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_converted` datetime DEFAULT NULL,
  `lost` tinyint(1) NOT NULL DEFAULT '0',
  `junk` int NOT NULL DEFAULT '0',
  `last_lead_status` int NOT NULL DEFAULT '0',
  `is_imported_from_email_integration` tinyint(1) NOT NULL DEFAULT '0',
  `email_integration_uid` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_public` tinyint(1) NOT NULL DEFAULT '0',
  `default_language` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `client_id` int NOT NULL DEFAULT '0',
  `lead_value` decimal(15,2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `company` (`company`),
  KEY `email` (`email`),
  KEY `assigned` (`assigned`),
  KEY `status` (`status`),
  KEY `source` (`source`),
  KEY `lastcontact` (`lastcontact`),
  KEY `dateadded` (`dateadded`),
  KEY `leadorder` (`leadorder`),
  KEY `from_form_id` (`from_form_id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblleads`
--

INSERT INTO `tblleads` VALUES (1,'69638c077b9856c13dd899b54a129412-1ae30122be0878f82a21d7d6b2778ebd','Michu Sophie','PDG','Michu Inc','',76,'33000','Bordeaux','','',2,'2025-02-21 21:44:10',0,1,3,'2025-02-21 21:44:10',NULL,NULL,2,'sophie@goaper.fr','',1,'','2025-02-21 21:49:13',0,0,0,0,NULL,0,NULL,0,0.00),(2,'7b3d7159c3e7d8766fc333953723f493-ac96f6b24f6f3c66e6f26a457ec0f99e','Sophie CAPERAN','DRH','Actia Automotive','',76,'','','','',4,'2025-03-17 12:03:59',0,2,3,'2025-03-03 12:03:00',NULL,NULL,4,'sophie.caperan@actia.fr','',1,'06 70 46 71 58',NULL,0,0,0,0,NULL,0,NULL,0,0.00),(3,'2e1c6ddaeb4db277b710906f0692b194-5743371bf2a19aef06cc3cf75c8eaa4f','Claire BRIERE','Responsable recrutement','Actia Automotive','',76,'','','','',4,'2025-03-17 12:07:53',0,2,3,'2025-03-03 00:00:00',NULL,NULL,4,'claire.briere@actia.fr','',1,'06 66 70 53 95',NULL,0,0,0,0,NULL,0,NULL,0,0.00),(4,'738ffbb03bca04a571465ef208c5f16d-18143679c05a677db551da7968243899','Jérome FONTANA','DRH','Actia Automotive','',76,'','','','',4,'2025-03-17 12:10:18',0,2,3,'2025-03-03 00:00:00',NULL,NULL,4,'jerome.fontana@actia.fr','',1,'06 84 95 48 58',NULL,0,0,0,0,NULL,1,NULL,0,0.00),(5,'df1d178064bf4d98ffa03e8a448b99ea-ce3cbfcad133fc79000caf97ccb30bb7','Delphine CHOFFEL','RH','Actia Automotive','',76,'','','','',4,'2025-03-17 12:12:17',0,2,3,'2025-03-03 00:00:00',NULL,NULL,4,'delphine.choffel@actia.fr','',1,'05 62 74 43 06',NULL,0,0,0,0,NULL,0,NULL,0,0.00),(6,'821a2f81d2886f0d222b2816f0c3d24c-08a1af52180ebca21bbe01d2ad4f03fa','Véronique GLEIZES','Responsable recrutement','ABO WIND','',76,'','','','',4,'2025-03-17 12:15:10',0,2,3,'2025-03-03 00:00:00',NULL,NULL,4,'veronique.gleizes@abo-wind.fr','',1,'veronique.gleizes@abo-wind.fr',NULL,0,0,0,0,NULL,0,NULL,0,0.00),(7,'a4f38a120d34d26fdfcdf42d0fed352a-ea57135d6987c3fc10d91518c67235f0','Sarah CORBIN','Responsable paie et administration du personnel','ABO WIND','',76,'','','','',4,'2025-03-17 12:18:00',0,2,3,'2025-03-03 00:00:00',NULL,NULL,4,'sarah.corbin@abo-wind.com','',1,'07 88 94 26 14',NULL,0,0,0,0,NULL,0,NULL,0,0.00),(8,'5acd219e5894f36cda39633918a30a0e-786eb52e3189104d15d64f0338986215','Amour MOUKIN','Assistante RH','ADAGIO','',76,'','','','',4,'2025-03-17 12:23:05',0,2,3,'2025-03-03 00:00:00',NULL,NULL,4,'amour.moukin@adagio-city.com','',1,'06 62 67 30 69',NULL,0,0,0,0,NULL,0,NULL,0,0.00),(9,'d11eebc30d429b63c0c890d676c66b10-7d198fcb025966fc494faf46afa2748d','Célia COPER','Directrice adjointe','ADAGIO','',76,'','','','',4,'2025-03-17 12:25:50',0,2,3,'2025-03-03 00:00:00',NULL,NULL,4,'h8989-dm@adagio-city.com','',1,'01 46 39 93 50',NULL,0,0,0,0,NULL,0,NULL,0,0.00),(10,'7259642d47576e6f8377054cb11a2873-bc83a54432bfbb5fe90fd46dd9ba8221','Veronique PARIS','DRH','Groupe ADF','',76,'','','','',4,'2025-03-17 12:28:29',0,2,3,'2025-03-03 00:00:00',NULL,NULL,4,'veronique.paris@groupeadf.com','',1,'06 30 99 30 34',NULL,0,0,0,0,NULL,0,NULL,0,0.00),(11,'371c14af35b497391be70214d2f840ef-41d94ebec16155a9b746bf3d05b5cbd9','Laura JEROME','RH','Groupe ADF','',76,'','','','',4,'2025-03-17 12:32:36',0,2,3,'2025-03-03 00:00:00',NULL,NULL,4,'laura.jerome@groupeadf.com','',1,'06 64 14 45 95',NULL,0,0,0,0,NULL,0,NULL,0,0.00),(12,'96e475de07d63fd011f1b1b7ad62b324-c297dfef36eaa7b8e0f08cbda30ffbc5','Anysia WILLIS','Chargée de recrutement','CAPGEMINI','',76,'','','','',4,'2025-03-17 12:39:53',0,2,3,'2025-03-03 00:00:00',NULL,NULL,4,'anysia.willis@capgemini.com','',1,'07 63 73 15 32',NULL,0,0,0,0,NULL,0,NULL,0,0.00),(13,'a2e1d0e8e1edbfe54681e9bbc5579c66-fe35b7e3627425b8c80bf8a42048e5b6','Sylvia DELELIS','RH','CAPGEMINI','',76,'','','','',4,'2025-03-17 14:15:44',0,2,3,'2025-03-03 00:00:00',NULL,NULL,4,'sylvia.ferreria@capgemini.com','',1,'06 81 98 90 39',NULL,0,0,0,0,NULL,0,NULL,0,0.00),(14,'56db8cee1339b6b9a9656472da603ce6-7c8ef8360dc2c7fc17770ca29d080ca5','Manon SADAILLAN','Talent acquisition','DEVOTEAM','',76,'','','','',4,'2025-03-17 14:20:08',0,2,3,'2025-03-03 00:00:00',NULL,NULL,4,'manon.sadaillan@devoteam.com','',1,'',NULL,0,0,0,0,NULL,0,NULL,0,0.00),(15,'313f8fed076369f21923d4f5d38818e9-78434cc355b1cd192d39a2afa5b0f8f0','Maureen BOURGEON','HRBP','CAPGEMINI','',76,'','','','',4,'2025-03-17 14:22:10',0,2,3,'2025-03-03 00:00:00',NULL,NULL,4,'maureen.bourgeon@capgemini.com','',1,'06 62 30 51 15',NULL,0,0,0,0,NULL,0,NULL,0,0.00),(16,'35bdd3441b73eff27a2cec95e63bd03e-51144660386b8322a0dee8c27555d674','Océane BROUSSIN','Talent acquisition specialist','COLAS RAIL','',76,'','','','',4,'2025-03-17 14:27:06',0,2,3,NULL,NULL,NULL,4,'oceane.broussin@colasrail.com','',1,'',NULL,0,0,0,0,NULL,0,NULL,0,0.00),(17,'1682dc93e7dbf2c9e5a273b7ed626b3a-8f51021b30f5e53188619187dd37e6f8','Samantha DEL ZOTTO','RRH','CAPGEMINI','',76,'','','','',4,'2025-03-17 14:30:26',0,2,3,'2025-03-03 00:00:00',NULL,NULL,4,'samantha.delzotto@capgemini.com','',1,'06 68 91 80 66',NULL,0,0,0,0,NULL,0,NULL,0,0.00);

--
-- Table structure for table `tblleads_email_integration`
--

CREATE TABLE `tblleads_email_integration` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'the ID always must be 1',
  `active` int NOT NULL,
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `imap_server` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `check_every` int NOT NULL DEFAULT '5',
  `responsible` int NOT NULL,
  `lead_source` int NOT NULL,
  `lead_status` int NOT NULL,
  `encryption` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `folder` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_run` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notify_lead_imported` tinyint(1) NOT NULL DEFAULT '1',
  `notify_lead_contact_more_times` tinyint(1) NOT NULL DEFAULT '1',
  `notify_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notify_ids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `mark_public` int NOT NULL DEFAULT '0',
  `only_loop_on_unseen_emails` tinyint(1) NOT NULL DEFAULT '1',
  `delete_after_import` int NOT NULL DEFAULT '0',
  `create_task_if_customer` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblleads_email_integration`
--

INSERT INTO `tblleads_email_integration` VALUES (1,0,'mikel.barthelemy@symbiose-mobilite.com','outlook.office365.com:993','c4f89fe9b2448ee0551787f584b9a1eb86825cf51440fa57e1195df9db5d534e19388f5ab92255c07772ad82c37303d6d10ebb2818b28280058407c03262237b4ToBWkSF1IL5xXAyZmvbIhNdsYgGBJUGfrbtMw93TYc=',10,1,10,2,'ssl','INBOX','',1,1,'assigned','a:0:{}',0,1,0,1);

--
-- Table structure for table `tblleads_sources`
--

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

--
-- Dumping data for table `tblleads_sources`
--

INSERT INTO `tblleads_sources` VALUES (3,'Anciens clients'),(7,'Campagnes de marketing en ligne'),(2,'Facebook'),(1,'Google'),(11,'Lemlist'),(6,'Organismes communautaires'),(4,'Partenariats commerciaux'),(9,'Prospection email'),(8,'Prospection téléphonique'),(5,'Salons et conférences'),(10,'Site Symbiose Mobilité');

--
-- Table structure for table `tblleads_status`
--

CREATE TABLE `tblleads_status` (
  `id` int 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 '#28B8DA',
  `isdefault` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblleads_status`
--

INSERT INTO `tblleads_status` VALUES (1,'Client',1000,'#7cb342',1),(2,'Nouveau ',2,'#007bff',0),(3,'Contacté ',3,'#17a2b8',0),(4,'En cours',4,'#ffc107',0),(5,'Qualifié ',5,'#28a745',0),(6,'Nurturing ',6,'#6f42c1',0),(7,'Proposition envoyée',7,'#fd7e14',0),(8,'Négociation ',8,'#20c997',0),(9,'Gagné ',9,'#007bff',0),(10,'Gagné ',9,'#007bff',0),(11,'Perdu ',11,'#dc3545',0),(12,'Non qualifié',12,'#6c757d',0);

--
-- Table structure for table `tbllistemails`
--

CREATE TABLE `tbllistemails` (
  `emailid` int NOT NULL AUTO_INCREMENT,
  `listid` int NOT NULL,
  `email` varchar(100) NOT NULL,
  `dateadded` datetime NOT NULL,
  PRIMARY KEY (`emailid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbllistemails`
--


--
-- Table structure for table `tblmail_attachment`
--

CREATE TABLE `tblmail_attachment` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `mail_id` int NOT NULL,
  `file_name` varchar(191) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `file_type` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `type` varchar(45) NOT NULL DEFAULT 'inbox',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tblmail_attachment`
--


--
-- Table structure for table `tblmail_conversation`
--

CREATE TABLE `tblmail_conversation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `outbox_id` int DEFAULT NULL,
  `lead_id` int DEFAULT NULL,
  `inbox_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tblmail_conversation`
--


--
-- Table structure for table `tblmail_inbox`
--

CREATE TABLE `tblmail_inbox` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `from_staff_id` int NOT NULL DEFAULT '0',
  `to_staff_id` int NOT NULL DEFAULT '0',
  `to` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `cc` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `bcc` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `sender_name` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `subject` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `body` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `has_attachment` tinyint(1) NOT NULL DEFAULT '0',
  `date_received` datetime NOT NULL,
  `read` tinyint(1) NOT NULL DEFAULT '0',
  `folder` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'inbox',
  `stared` tinyint(1) NOT NULL DEFAULT '0',
  `important` tinyint(1) NOT NULL DEFAULT '0',
  `trash` tinyint(1) NOT NULL DEFAULT '0',
  `from_email` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tblmail_inbox`
--


--
-- Table structure for table `tblmail_outbox`
--

CREATE TABLE `tblmail_outbox` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `sender_staff_id` int NOT NULL DEFAULT '0',
  `to` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `cc` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `bcc` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `sender_name` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `subject` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `body` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `has_attachment` tinyint(1) NOT NULL DEFAULT '0',
  `date_sent` datetime NOT NULL,
  `stared` tinyint(1) NOT NULL DEFAULT '0',
  `important` tinyint(1) NOT NULL DEFAULT '0',
  `trash` tinyint(1) NOT NULL DEFAULT '0',
  `reply_from_id` int DEFAULT NULL,
  `reply_type` varchar(45) NOT NULL DEFAULT 'inbox',
  `draft` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tblmail_outbox`
--


--
-- Table structure for table `tblmail_queue`
--

CREATE TABLE `tblmail_queue` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sender_id` int DEFAULT NULL,
  `engine` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `cc` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `bcc` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `alt_message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` enum('pending','sending','sent','failed') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `headers` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `attachments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblmail_queue`
--


--
-- Table structure for table `tblmaillistscustomfields`
--

CREATE TABLE `tblmaillistscustomfields` (
  `customfieldid` int NOT NULL AUTO_INCREMENT,
  `listid` int NOT NULL,
  `fieldname` varchar(150) NOT NULL,
  `fieldslug` varchar(100) NOT NULL,
  PRIMARY KEY (`customfieldid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tblmaillistscustomfields`
--


--
-- Table structure for table `tblmaillistscustomfieldvalues`
--

CREATE TABLE `tblmaillistscustomfieldvalues` (
  `customfieldvalueid` int NOT NULL AUTO_INCREMENT,
  `listid` int NOT NULL,
  `customfieldid` int NOT NULL,
  `emailid` int NOT NULL,
  `value` varchar(100) NOT NULL,
  PRIMARY KEY (`customfieldvalueid`),
  KEY `listid` (`listid`),
  KEY `customfieldid` (`customfieldid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tblmaillistscustomfieldvalues`
--


--
-- Table structure for table `tblmigrations`
--

CREATE TABLE `tblmigrations` (
  `version` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblmigrations`
--

INSERT INTO `tblmigrations` VALUES (341);

--
-- Table structure for table `tblmilestones`
--

CREATE TABLE `tblmilestones` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `description_visible_to_customer` tinyint(1) DEFAULT '0',
  `start_date` date DEFAULT NULL,
  `due_date` date NOT NULL,
  `project_id` int NOT NULL,
  `color` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `milestone_order` int NOT NULL DEFAULT '0',
  `datecreated` date NOT NULL,
  `hide_from_customer` int DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblmilestones`
--


--
-- Table structure for table `tblmodules`
--

CREATE TABLE `tblmodules` (
  `id` int NOT NULL AUTO_INCREMENT,
  `module_name` varchar(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `installed_version` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblmodules`
--

INSERT INTO `tblmodules` VALUES (1,'exports','1.0.0',1),(2,'backup','2.3.0',1),(3,'menu_setup','2.3.0',1),(4,'surveys','2.3.0',1),(5,'api','2.0.7',1),(6,'mailbox','2.0.3',0),(10,'flexibackup','1.0.2',1),(11,'sm_sharepoint_sync','1.1.0',0),(12,'openai','1.0.0',1);

--
-- Table structure for table `tblnewsfeed_comment_likes`
--

CREATE TABLE `tblnewsfeed_comment_likes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `postid` int NOT NULL,
  `commentid` int NOT NULL,
  `userid` int NOT NULL,
  `dateliked` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblnewsfeed_comment_likes`
--


--
-- Table structure for table `tblnewsfeed_post_comments`
--

CREATE TABLE `tblnewsfeed_post_comments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `content` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `userid` int NOT NULL,
  `postid` int NOT NULL,
  `dateadded` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblnewsfeed_post_comments`
--


--
-- Table structure for table `tblnewsfeed_post_likes`
--

CREATE TABLE `tblnewsfeed_post_likes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `postid` int NOT NULL,
  `userid` int NOT NULL,
  `dateliked` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblnewsfeed_post_likes`
--


--
-- Table structure for table `tblnewsfeed_posts`
--

CREATE TABLE `tblnewsfeed_posts` (
  `postid` int NOT NULL AUTO_INCREMENT,
  `creator` int NOT NULL,
  `datecreated` datetime NOT NULL,
  `visibility` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `pinned` int NOT NULL,
  `datepinned` datetime DEFAULT NULL,
  PRIMARY KEY (`postid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblnewsfeed_posts`
--


--
-- Table structure for table `tblnotes`
--

CREATE TABLE `tblnotes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `rel_id` int NOT NULL,
  `rel_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `date_contacted` datetime DEFAULT NULL,
  `addedfrom` int NOT NULL,
  `dateadded` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `rel_id` (`rel_id`),
  KEY `rel_type` (`rel_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblnotes`
--


--
-- Table structure for table `tblnotifications`
--

CREATE TABLE `tblnotifications` (
  `id` int NOT NULL AUTO_INCREMENT,
  `isread` int NOT NULL DEFAULT '0',
  `isread_inline` tinyint(1) NOT NULL DEFAULT '0',
  `date` datetime NOT NULL,
  `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fromuserid` int NOT NULL,
  `fromclientid` int NOT NULL DEFAULT '0',
  `from_fullname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `touserid` int NOT NULL,
  `fromcompany` int DEFAULT NULL,
  `link` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `additional_data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblnotifications`
--

INSERT INTO `tblnotifications` VALUES (1,1,0,'2025-02-21 21:48:02','not_new_reminder_for',0,0,'',2,1,'leads/index/1','a:1:{i:0;s:41:\"Michu Sophie - sophie@goaper.fr - test...\";}'),(2,0,0,'2026-06-18 03:55:14','not_customer_uploaded_file',0,1,'Michu Sophie',1,NULL,'clients/client/1?group=attachments',NULL),(3,0,0,'2026-06-18 03:55:14','not_customer_uploaded_file',0,1,'Michu Sophie',2,NULL,'clients/client/1?group=attachments',NULL);

--
-- Table structure for table `tbloptions`
--

CREATE TABLE `tbloptions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `autoload` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=553 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbloptions`
--

INSERT INTO `tbloptions` VALUES (1,'dateformat','d-m-Y|%d-%m-%Y',1),(2,'companyname','Symbiose Mobilité',1),(3,'services','1',1),(4,'maximum_allowed_ticket_attachments','4',1),(5,'ticket_attachments_file_extensions','.jpg,.jpeg,.png,.pdf,.doc,.zip,.rar',1),(6,'staff_access_only_assigned_departments','1',1),(7,'use_knowledge_base','1',1),(8,'smtp_email','contact@symbiose-mobilite.com',1),(9,'smtp_password','b0f6f8c899305c4cdf1ef546b3e8f8c8ee39762e0e39fa7f10e379ccc034442ee72292d32749ad5a7430321d6ff824f9f63c12bcf83853979de05566d3a5328fOmFr4pvE42CIksoOdIH6Ff5hk8QZkkbl/DK/XQr+l28=',1),(10,'company_info_format','{company_name}<br />\r\n      {address}<br />\r\n      {zip_code} {city}<br />\r\n      {vat_number_with_label}',0),(11,'smtp_port','587',1),(12,'smtp_host','smtp.office365.com',1),(13,'smtp_email_charset','utf-8',1),(14,'default_timezone','Europe/Paris',1),(15,'clients_default_theme','perfex',1),(16,'company_logo','e45e19eaff40cf667baaed0861eebe0c.png',1),(17,'tables_pagination_limit','25',1),(18,'main_domain','https://symbiose-mobilite.com',1),(19,'allow_registration','0',1),(20,'knowledge_base_without_registration','1',1),(21,'email_signature','',1),(22,'default_staff_role','1',1),(23,'newsfeed_maximum_files_upload','10',1),(24,'contract_expiration_before','4',1),(25,'invoice_prefix','FAC-',1),(26,'decimal_separator',',',1),(27,'thousand_separator',' ',1),(28,'invoice_company_name','Symbiose Mobilité',1),(29,'invoice_company_address','32 RUE DU BOSQUET',1),(30,'invoice_company_city','Pessac',1),(31,'invoice_company_country_code','',1),(32,'invoice_company_postal_code','33600',1),(33,'invoice_company_phonenumber','06 04 53 35 23',1),(34,'view_invoice_only_logged_in','0',1),(35,'invoice_number_format','2',1),(36,'next_invoice_number','1',0),(37,'active_language','french',1),(38,'invoice_number_decrement_on_delete','1',1),(39,'automatically_send_invoice_overdue_reminder_after','1',1),(40,'automatically_resend_invoice_overdue_reminder_after','3',1),(41,'expenses_auto_operations_hour','9',1),(42,'delete_only_on_last_invoice','1',1),(43,'delete_only_on_last_estimate','1',1),(44,'create_invoice_from_recurring_only_on_paid_invoices','0',1),(45,'allow_payment_amount_to_be_modified','1',1),(46,'rtl_support_client','0',1),(47,'limit_top_search_bar_results_to','10',1),(48,'estimate_prefix','DEVIS-',1),(49,'next_estimate_number','1',0),(50,'estimate_number_decrement_on_delete','1',1),(51,'estimate_number_format','1',1),(52,'estimate_auto_convert_to_invoice_on_client_accept','1',1),(53,'exclude_estimate_from_client_area_with_draft_status','1',1),(54,'rtl_support_admin','0',1),(55,'last_cron_run','1781875809',1),(56,'show_sale_agent_on_estimates','1',1),(57,'show_sale_agent_on_invoices','1',1),(58,'predefined_terms_invoice','',1),(59,'predefined_terms_estimate','',1),(60,'default_task_priority','2',1),(61,'dropbox_app_key','',1),(62,'show_expense_reminders_on_calendar','1',1),(63,'only_show_contact_tickets','1',1),(64,'predefined_clientnote_invoice','',1),(65,'predefined_clientnote_estimate','',1),(66,'custom_pdf_logo_image_url','',1),(67,'favicon','favicon.png',1),(68,'invoice_due_after','30',1),(69,'google_api_key','',1),(70,'google_calendar_main_calendar','',1),(71,'default_tax','a:0:{}',1),(72,'show_invoices_on_calendar','1',1),(73,'show_estimates_on_calendar','1',1),(74,'show_contracts_on_calendar','1',1),(75,'show_tasks_on_calendar','1',1),(76,'show_customer_reminders_on_calendar','1',1),(77,'output_client_pdfs_from_admin_area_in_client_language','0',1),(78,'show_lead_reminders_on_calendar','1',1),(79,'send_estimate_expiry_reminder_before','4',1),(80,'leads_default_source','',1),(81,'leads_default_status','',1),(82,'proposal_expiry_reminder_enabled','1',1),(83,'send_proposal_expiry_reminder_before','4',1),(84,'default_contact_permissions','a:2:{i:0;s:1:\"3\";i:1;s:1:\"5\";}',1),(85,'pdf_logo_width','150',1),(86,'access_tickets_to_none_staff_members','0',1),(87,'customer_default_country','76',1),(88,'view_estimate_only_logged_in','0',1),(89,'show_status_on_pdf_ei','1',1),(90,'email_piping_only_replies','0',1),(91,'email_piping_only_registered','0',1),(92,'default_view_calendar','dayGridMonth',1),(93,'email_piping_default_priority','2',1),(94,'total_to_words_lowercase','0',1),(95,'show_tax_per_item','1',1),(96,'total_to_words_enabled','0',1),(97,'receive_notification_on_new_ticket','1',0),(98,'autoclose_tickets_after','0',1),(99,'media_max_file_size_upload','10',1),(100,'client_staff_add_edit_delete_task_comments_first_hour','0',1),(101,'show_projects_on_calendar','1',1),(102,'leads_kanban_limit','50',1),(103,'tasks_reminder_notification_before','2',1),(104,'pdf_font','freesans',1),(105,'pdf_table_heading_color','#e5e7eb',1),(106,'pdf_table_heading_text_color','#030712',1),(107,'pdf_font_size','10',1),(108,'default_leads_kanban_sort','leadorder',1),(109,'default_leads_kanban_sort_type','asc',1),(110,'allowed_files','.png,.jpg,.jpeg,.pdf,.doc,.docx,.xls,.xlsx,.zip,.rar,.txt,.csv',1),(111,'show_all_tasks_for_project_member','1',1),(112,'email_protocol','smtp',1),(113,'calendar_first_day','1',1),(114,'recaptcha_secret_key','',1),(115,'show_help_on_setup_menu','1',1),(116,'show_proposals_on_calendar','1',1),(117,'smtp_encryption','tls',1),(118,'recaptcha_site_key','',1),(119,'smtp_username','mikel.barthelemy@symbiose-mobilite.com',1),(120,'auto_stop_tasks_timers_on_new_timer','1',1),(121,'notification_when_customer_pay_invoice','1',1),(122,'calendar_invoice_color','#ff6f00',1),(123,'calendar_estimate_color','#ff6f00',1),(124,'calendar_proposal_color','#84c529',1),(125,'new_task_auto_assign_current_member','1',1),(126,'calendar_reminder_color','#03a9f4',1),(127,'calendar_contract_color','#b72974',1),(128,'calendar_project_color','#b72974',1),(129,'update_info_message','',1),(130,'show_estimate_reminders_on_calendar','1',1),(131,'show_invoice_reminders_on_calendar','1',1),(132,'show_proposal_reminders_on_calendar','1',1),(133,'proposal_due_after','7',1),(134,'allow_customer_to_change_ticket_status','0',1),(135,'lead_lock_after_convert_to_customer','0',1),(136,'default_proposals_pipeline_sort','pipeline_order',1),(137,'default_proposals_pipeline_sort_type','asc',1),(138,'default_estimates_pipeline_sort','pipeline_order',1),(139,'default_estimates_pipeline_sort_type','asc',1),(140,'use_recaptcha_customers_area','0',1),(141,'remove_decimals_on_zero','0',1),(142,'remove_tax_name_from_item_table','0',1),(143,'pdf_format_invoice','A4-PORTRAIT',1),(144,'pdf_format_estimate','A4-PORTRAIT',1),(145,'pdf_format_proposal','A4-PORTRAIT',1),(146,'pdf_format_payment','A4-PORTRAIT',1),(147,'pdf_format_contract','A4-PORTRAIT',1),(148,'swap_pdf_info','0',1),(149,'exclude_invoice_from_client_area_with_draft_status','1',1),(150,'cron_has_run_from_cli','1',1),(151,'hide_cron_is_required_message','0',0),(152,'auto_assign_customer_admin_after_lead_convert','1',1),(153,'show_transactions_on_invoice_pdf','1',1),(154,'show_pay_link_to_invoice_pdf','1',1),(155,'tasks_kanban_limit','50',1),(156,'purchase_key','b2c7f4d6-bf37-4532-bd5f-d15c387f39a8',1),(157,'estimates_pipeline_limit','50',1),(158,'proposals_pipeline_limit','50',1),(159,'proposal_number_prefix','PRO-',1),(160,'number_padding_prefixes','6',1),(161,'show_page_number_on_pdf','0',1),(162,'calendar_events_limit','4',1),(163,'show_setup_menu_item_only_on_hover','0',1),(164,'company_requires_vat_number_field','1',1),(165,'company_is_required','1',1),(166,'allow_contact_to_delete_files','1',1),(167,'company_vat','FR76 978 995 090',1),(168,'di','1739841386',1),(169,'invoice_auto_operations_hour','21',1),(170,'use_minified_files','1',1),(171,'only_own_files_contacts','0',1),(172,'allow_primary_contact_to_view_edit_billing_and_shipping','0',1),(173,'estimate_due_after','7',1),(174,'staff_members_open_tickets_to_all_contacts','1',1),(175,'time_format','24',1),(176,'delete_activity_log_older_then','1',1),(177,'disable_language','1',1),(178,'company_state','',1),(179,'email_header','<!doctype html>\r\n      <html>\r\n      <head>\r\n      <meta name=\"viewport\" content=\"width=device-width\" />\r\n      <meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\" />\r\n      <style>\r\n      body {\r\n        background-color: #f6f6f6;\r\n        font-family: sans-serif;\r\n        -webkit-font-smoothing: antialiased;\r\n        font-size: 14px;\r\n        line-height: 1.4;\r\n        margin: 0;\r\n        padding: 0;\r\n        -ms-text-size-adjust: 100%;\r\n        -webkit-text-size-adjust: 100%;\r\n      }\r\n      table {\r\n        border-collapse: separate;\r\n        mso-table-lspace: 0pt;\r\n        mso-table-rspace: 0pt;\r\n        width: 100%;\r\n      }\r\n      table td {\r\n        font-family: sans-serif;\r\n        font-size: 14px;\r\n        vertical-align: top;\r\n      }\r\n      /* -------------------------------------\r\n      BODY & CONTAINER\r\n      ------------------------------------- */\r\n      .body {\r\n        background-color: #f6f6f6;\r\n        width: 100%;\r\n      }\r\n      /* Set a max-width, and make it display as block so it will automatically stretch to that width, but will also shrink down on a phone or something */\r\n      \r\n      .container {\r\n        display: block;\r\n        margin: 0 auto !important;\r\n        /* makes it centered */\r\n        max-width: 680px;\r\n        padding: 10px;\r\n        width: 680px;\r\n      }\r\n      /* This should also be a block element, so that it will fill 100% of the .container */\r\n      \r\n      .content {\r\n        box-sizing: border-box;\r\n        display: block;\r\n        margin: 0 auto;\r\n        max-width: 680px;\r\n        padding: 10px;\r\n      }\r\n      /* -------------------------------------\r\n      HEADER, FOOTER, MAIN\r\n      ------------------------------------- */\r\n      \r\n      .main {\r\n        background: #fff;\r\n        border-radius: 3px;\r\n        width: 100%;\r\n      }\r\n      .wrapper {\r\n        box-sizing: border-box;\r\n        padding: 20px;\r\n      }\r\n      .footer {\r\n        clear: both;\r\n        padding-top: 10px;\r\n        text-align: center;\r\n        width: 100%;\r\n      }\r\n      .footer td,\r\n      .footer p,\r\n      .footer span,\r\n      .footer a {\r\n        color: #999999;\r\n        font-size: 12px;\r\n        text-align: center;\r\n      }\r\n      hr {\r\n        border: 0;\r\n        border-bottom: 1px solid #f6f6f6;\r\n        margin: 20px 0;\r\n      }\r\n      /* -------------------------------------\r\n      RESPONSIVE AND MOBILE FRIENDLY STYLES\r\n      ------------------------------------- */\r\n      \r\n      @media only screen and (max-width: 620px) {\r\n        table[class=body] .content {\r\n          padding: 0 !important;\r\n        }\r\n        table[class=body] .container {\r\n          padding: 0 !important;\r\n          width: 100% !important;\r\n        }\r\n        table[class=body] .main {\r\n          border-left-width: 0 !important;\r\n          border-radius: 0 !important;\r\n          border-right-width: 0 !important;\r\n        }\r\n      }\r\n      </style>\r\n      </head>\r\n     <body class=\"\">\r\n      <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"body\">\r\n      <tr>\r\n      <td> </td>\r\n      <td class=\"container\">\r\n      <div class=\"content\">\r\n      <!-- START CENTERED WHITE CONTAINER -->\r\n      <table class=\"main\">\r\n      <!-- START MAIN CONTENT AREA -->\r\n<tr>\r\n                            <td align=\"center\" style=\"padding: 20px 0;\">\r\n                                <img src=\"https://www.s-mob.fr/media/Symbiose-Mobilite-Pack-logo_couleur-fond-clair.jpg\" alt=\"Logo\" style=\"width: 150px; height: auto;\">\r\n                            </td>\r\n                        </tr>\r\n      <tr>\r\n      <td class=\"wrapper\">\r\n      <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n      <tr>\r\n      <td>',1),(180,'show_pdf_signature_invoice','1',0),(181,'show_pdf_signature_estimate','1',0),(182,'signature_image','',0),(183,'email_footer','</td>\r\n      </tr>\r\n      </table>\r\n      </td>\r\n      </tr>\r\n      <!-- END MAIN CONTENT AREA -->\r\n      </table>\r\n      <!-- START FOOTER -->\r\n      <div class=\"footer\">\r\n      <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n      <tr>\r\n      <td class=\"content-block\">\r\n      <span>{companyname}</span>\r\n      </td>\r\n      </tr>\r\n      </table>\r\n      </div>\r\n      <!-- END FOOTER -->\r\n      <!-- END CENTERED WHITE CONTAINER -->\r\n      </div>\r\n      </td>\r\n      <td>&nbsp;</td>\r\n      </tr>\r\n      </table>\r\n      </body>\r\n      </html>',1),(184,'exclude_proposal_from_client_area_with_draft_status','1',1),(185,'pusher_app_key','',1),(186,'pusher_app_secret','',1),(187,'pusher_app_id','',1),(188,'pusher_realtime_notifications','0',1),(189,'pdf_format_statement','A4-PORTRAIT',1),(190,'pusher_cluster','',1),(191,'show_table_export_button','to_all',1),(192,'allow_staff_view_proposals_assigned','1',1),(193,'show_cloudflare_notice','1',0),(194,'task_modal_class','modal-lg',1),(195,'lead_modal_class','modal-xl',1),(196,'show_timesheets_overview_all_members_notice_admins','0',1),(197,'desktop_notifications','0',1),(198,'hide_notified_reminders_from_calendar','1',0),(199,'customer_info_format','{company_name}<br />\r\n      {street}<br />\r\n      {zip_code} {city}<br />\r\n      {vat_number_with_label}',0),(200,'timer_started_change_status_in_progress','1',0),(201,'default_ticket_reply_status','3',1),(202,'default_task_status','auto',1),(203,'email_queue_skip_with_attachments','1',1),(204,'email_queue_enabled','0',1),(205,'last_email_queue_retry','1781875209',1),(206,'auto_dismiss_desktop_notifications_after','0',1),(207,'proposal_info_format','{proposal_to}<br />\r\n      {address}<br />\r\n      {city} {state}<br />\r\n      {country_code} {zip_code}<br />\r\n      {phone}<br />\r\n      {email}',0),(208,'ticket_replies_order','desc',1),(209,'new_recurring_invoice_action','generate_and_send',0),(210,'bcc_emails','',0),(211,'email_templates_language_checks','a:2184:{s:26:\"new-client-created-turkish\";i:1;s:30:\"invoice-send-to-client-turkish\";i:1;s:31:\"new-ticket-opened-admin-turkish\";i:1;s:20:\"ticket-reply-turkish\";i:1;s:27:\"ticket-autoresponse-turkish\";i:1;s:32:\"invoice-payment-recorded-turkish\";i:1;s:30:\"invoice-overdue-notice-turkish\";i:1;s:28:\"invoice-already-send-turkish\";i:1;s:32:\"new-ticket-created-staff-turkish\";i:1;s:31:\"estimate-send-to-client-turkish\";i:1;s:29:\"ticket-reply-to-admin-turkish\";i:1;s:29:\"estimate-already-send-turkish\";i:1;s:27:\"contract-expiration-turkish\";i:1;s:21:\"task-assigned-turkish\";i:1;s:30:\"task-added-as-follower-turkish\";i:1;s:22:\"task-commented-turkish\";i:1;s:29:\"task-added-attachment-turkish\";i:1;s:34:\"estimate-declined-to-staff-turkish\";i:1;s:34:\"estimate-accepted-to-staff-turkish\";i:1;s:32:\"proposal-client-accepted-turkish\";i:1;s:33:\"proposal-send-to-customer-turkish\";i:1;s:32:\"proposal-client-declined-turkish\";i:1;s:33:\"proposal-client-thank-you-turkish\";i:1;s:34:\"proposal-comment-to-client-turkish\";i:1;s:33:\"proposal-comment-to-admin-turkish\";i:1;s:38:\"estimate-thank-you-to-customer-turkish\";i:1;s:34:\"task-deadline-notification-turkish\";i:1;s:21:\"send-contract-turkish\";i:1;s:41:\"invoice-payment-recorded-to-staff-turkish\";i:1;s:25:\"auto-close-ticket-turkish\";i:1;s:47:\"new-project-discussion-created-to-staff-turkish\";i:1;s:50:\"new-project-discussion-created-to-customer-turkish\";i:1;s:45:\"new-project-file-uploaded-to-customer-turkish\";i:1;s:42:\"new-project-file-uploaded-to-staff-turkish\";i:1;s:50:\"new-project-discussion-comment-to-customer-turkish\";i:1;s:47:\"new-project-discussion-comment-to-staff-turkish\";i:1;s:37:\"staff-added-as-project-member-turkish\";i:1;s:32:\"estimate-expiry-reminder-turkish\";i:1;s:32:\"proposal-expiry-reminder-turkish\";i:1;s:25:\"new-staff-created-turkish\";i:1;s:31:\"contact-forgot-password-turkish\";i:1;s:32:\"contact-password-reseted-turkish\";i:1;s:28:\"contact-set-password-turkish\";i:1;s:29:\"staff-forgot-password-turkish\";i:1;s:30:\"staff-password-reseted-turkish\";i:1;s:27:\"assigned-to-project-turkish\";i:1;s:41:\"task-added-attachment-to-contacts-turkish\";i:1;s:34:\"task-commented-to-contacts-turkish\";i:1;s:25:\"new-lead-assigned-turkish\";i:1;s:24:\"client-statement-turkish\";i:1;s:32:\"ticket-assigned-to-admin-turkish\";i:1;s:38:\"new-client-registered-to-admin-turkish\";i:1;s:38:\"new-web-to-lead-form-submitted-turkish\";i:1;s:33:\"two-factor-authentication-turkish\";i:1;s:36:\"project-finished-to-customer-turkish\";i:1;s:34:\"credit-note-send-to-client-turkish\";i:1;s:35:\"task-status-change-to-staff-turkish\";i:1;s:38:\"task-status-change-to-contacts-turkish\";i:1;s:28:\"reminder-email-staff-turkish\";i:1;s:34:\"contract-comment-to-client-turkish\";i:1;s:33:\"contract-comment-to-admin-turkish\";i:1;s:25:\"send-subscription-turkish\";i:1;s:35:\"subscription-payment-failed-turkish\";i:1;s:29:\"subscription-canceled-turkish\";i:1;s:38:\"subscription-payment-succeeded-turkish\";i:1;s:36:\"contract-expiration-to-staff-turkish\";i:1;s:28:\"gdpr-removal-request-turkish\";i:1;s:33:\"gdpr-removal-request-lead-turkish\";i:1;s:37:\"client-registration-confirmed-turkish\";i:1;s:32:\"contract-signed-to-staff-turkish\";i:1;s:36:\"customer-subscribed-to-staff-turkish\";i:1;s:34:\"contact-verification-email-turkish\";i:1;s:51:\"new-customer-profile-file-uploaded-to-staff-turkish\";i:1;s:35:\"event-notification-to-staff-turkish\";i:1;s:44:\"subscription-payment-requires-action-turkish\";i:1;s:26:\"invoice-due-notice-turkish\";i:1;s:43:\"estimate-request-submitted-to-staff-turkish\";i:1;s:33:\"estimate-request-assigned-turkish\";i:1;s:41:\"estimate-request-received-to-user-turkish\";i:1;s:33:\"non-billed-tasks-reminder-turkish\";i:1;s:31:\"invoices-batch-payments-turkish\";i:1;s:30:\"contract-sign-reminder-turkish\";i:1;s:28:\"new-client-created-norwegian\";i:1;s:32:\"invoice-send-to-client-norwegian\";i:1;s:33:\"new-ticket-opened-admin-norwegian\";i:1;s:22:\"ticket-reply-norwegian\";i:1;s:29:\"ticket-autoresponse-norwegian\";i:1;s:34:\"invoice-payment-recorded-norwegian\";i:1;s:32:\"invoice-overdue-notice-norwegian\";i:1;s:30:\"invoice-already-send-norwegian\";i:1;s:34:\"new-ticket-created-staff-norwegian\";i:1;s:33:\"estimate-send-to-client-norwegian\";i:1;s:31:\"ticket-reply-to-admin-norwegian\";i:1;s:31:\"estimate-already-send-norwegian\";i:1;s:29:\"contract-expiration-norwegian\";i:1;s:23:\"task-assigned-norwegian\";i:1;s:32:\"task-added-as-follower-norwegian\";i:1;s:24:\"task-commented-norwegian\";i:1;s:31:\"task-added-attachment-norwegian\";i:1;s:36:\"estimate-declined-to-staff-norwegian\";i:1;s:36:\"estimate-accepted-to-staff-norwegian\";i:1;s:34:\"proposal-client-accepted-norwegian\";i:1;s:35:\"proposal-send-to-customer-norwegian\";i:1;s:34:\"proposal-client-declined-norwegian\";i:1;s:35:\"proposal-client-thank-you-norwegian\";i:1;s:36:\"proposal-comment-to-client-norwegian\";i:1;s:35:\"proposal-comment-to-admin-norwegian\";i:1;s:40:\"estimate-thank-you-to-customer-norwegian\";i:1;s:36:\"task-deadline-notification-norwegian\";i:1;s:23:\"send-contract-norwegian\";i:1;s:43:\"invoice-payment-recorded-to-staff-norwegian\";i:1;s:27:\"auto-close-ticket-norwegian\";i:1;s:49:\"new-project-discussion-created-to-staff-norwegian\";i:1;s:52:\"new-project-discussion-created-to-customer-norwegian\";i:1;s:47:\"new-project-file-uploaded-to-customer-norwegian\";i:1;s:44:\"new-project-file-uploaded-to-staff-norwegian\";i:1;s:52:\"new-project-discussion-comment-to-customer-norwegian\";i:1;s:49:\"new-project-discussion-comment-to-staff-norwegian\";i:1;s:39:\"staff-added-as-project-member-norwegian\";i:1;s:34:\"estimate-expiry-reminder-norwegian\";i:1;s:34:\"proposal-expiry-reminder-norwegian\";i:1;s:27:\"new-staff-created-norwegian\";i:1;s:33:\"contact-forgot-password-norwegian\";i:1;s:34:\"contact-password-reseted-norwegian\";i:1;s:30:\"contact-set-password-norwegian\";i:1;s:31:\"staff-forgot-password-norwegian\";i:1;s:32:\"staff-password-reseted-norwegian\";i:1;s:29:\"assigned-to-project-norwegian\";i:1;s:43:\"task-added-attachment-to-contacts-norwegian\";i:1;s:36:\"task-commented-to-contacts-norwegian\";i:1;s:27:\"new-lead-assigned-norwegian\";i:1;s:26:\"client-statement-norwegian\";i:1;s:34:\"ticket-assigned-to-admin-norwegian\";i:1;s:40:\"new-client-registered-to-admin-norwegian\";i:1;s:40:\"new-web-to-lead-form-submitted-norwegian\";i:1;s:35:\"two-factor-authentication-norwegian\";i:1;s:38:\"project-finished-to-customer-norwegian\";i:1;s:36:\"credit-note-send-to-client-norwegian\";i:1;s:37:\"task-status-change-to-staff-norwegian\";i:1;s:40:\"task-status-change-to-contacts-norwegian\";i:1;s:30:\"reminder-email-staff-norwegian\";i:1;s:36:\"contract-comment-to-client-norwegian\";i:1;s:35:\"contract-comment-to-admin-norwegian\";i:1;s:27:\"send-subscription-norwegian\";i:1;s:37:\"subscription-payment-failed-norwegian\";i:1;s:31:\"subscription-canceled-norwegian\";i:1;s:40:\"subscription-payment-succeeded-norwegian\";i:1;s:38:\"contract-expiration-to-staff-norwegian\";i:1;s:30:\"gdpr-removal-request-norwegian\";i:1;s:35:\"gdpr-removal-request-lead-norwegian\";i:1;s:39:\"client-registration-confirmed-norwegian\";i:1;s:34:\"contract-signed-to-staff-norwegian\";i:1;s:38:\"customer-subscribed-to-staff-norwegian\";i:1;s:36:\"contact-verification-email-norwegian\";i:1;s:53:\"new-customer-profile-file-uploaded-to-staff-norwegian\";i:1;s:37:\"event-notification-to-staff-norwegian\";i:1;s:46:\"subscription-payment-requires-action-norwegian\";i:1;s:28:\"invoice-due-notice-norwegian\";i:1;s:45:\"estimate-request-submitted-to-staff-norwegian\";i:1;s:35:\"estimate-request-assigned-norwegian\";i:1;s:43:\"estimate-request-received-to-user-norwegian\";i:1;s:35:\"non-billed-tasks-reminder-norwegian\";i:1;s:33:\"invoices-batch-payments-norwegian\";i:1;s:32:\"contract-sign-reminder-norwegian\";i:1;s:27:\"new-client-created-japanese\";i:1;s:31:\"invoice-send-to-client-japanese\";i:1;s:32:\"new-ticket-opened-admin-japanese\";i:1;s:21:\"ticket-reply-japanese\";i:1;s:28:\"ticket-autoresponse-japanese\";i:1;s:33:\"invoice-payment-recorded-japanese\";i:1;s:31:\"invoice-overdue-notice-japanese\";i:1;s:29:\"invoice-already-send-japanese\";i:1;s:33:\"new-ticket-created-staff-japanese\";i:1;s:32:\"estimate-send-to-client-japanese\";i:1;s:30:\"ticket-reply-to-admin-japanese\";i:1;s:30:\"estimate-already-send-japanese\";i:1;s:28:\"contract-expiration-japanese\";i:1;s:22:\"task-assigned-japanese\";i:1;s:31:\"task-added-as-follower-japanese\";i:1;s:23:\"task-commented-japanese\";i:1;s:30:\"task-added-attachment-japanese\";i:1;s:35:\"estimate-declined-to-staff-japanese\";i:1;s:35:\"estimate-accepted-to-staff-japanese\";i:1;s:33:\"proposal-client-accepted-japanese\";i:1;s:34:\"proposal-send-to-customer-japanese\";i:1;s:33:\"proposal-client-declined-japanese\";i:1;s:34:\"proposal-client-thank-you-japanese\";i:1;s:35:\"proposal-comment-to-client-japanese\";i:1;s:34:\"proposal-comment-to-admin-japanese\";i:1;s:39:\"estimate-thank-you-to-customer-japanese\";i:1;s:35:\"task-deadline-notification-japanese\";i:1;s:22:\"send-contract-japanese\";i:1;s:42:\"invoice-payment-recorded-to-staff-japanese\";i:1;s:26:\"auto-close-ticket-japanese\";i:1;s:48:\"new-project-discussion-created-to-staff-japanese\";i:1;s:51:\"new-project-discussion-created-to-customer-japanese\";i:1;s:46:\"new-project-file-uploaded-to-customer-japanese\";i:1;s:43:\"new-project-file-uploaded-to-staff-japanese\";i:1;s:51:\"new-project-discussion-comment-to-customer-japanese\";i:1;s:48:\"new-project-discussion-comment-to-staff-japanese\";i:1;s:38:\"staff-added-as-project-member-japanese\";i:1;s:33:\"estimate-expiry-reminder-japanese\";i:1;s:33:\"proposal-expiry-reminder-japanese\";i:1;s:26:\"new-staff-created-japanese\";i:1;s:32:\"contact-forgot-password-japanese\";i:1;s:33:\"contact-password-reseted-japanese\";i:1;s:29:\"contact-set-password-japanese\";i:1;s:30:\"staff-forgot-password-japanese\";i:1;s:31:\"staff-password-reseted-japanese\";i:1;s:28:\"assigned-to-project-japanese\";i:1;s:42:\"task-added-attachment-to-contacts-japanese\";i:1;s:35:\"task-commented-to-contacts-japanese\";i:1;s:26:\"new-lead-assigned-japanese\";i:1;s:25:\"client-statement-japanese\";i:1;s:33:\"ticket-assigned-to-admin-japanese\";i:1;s:39:\"new-client-registered-to-admin-japanese\";i:1;s:39:\"new-web-to-lead-form-submitted-japanese\";i:1;s:34:\"two-factor-authentication-japanese\";i:1;s:37:\"project-finished-to-customer-japanese\";i:1;s:35:\"credit-note-send-to-client-japanese\";i:1;s:36:\"task-status-change-to-staff-japanese\";i:1;s:39:\"task-status-change-to-contacts-japanese\";i:1;s:29:\"reminder-email-staff-japanese\";i:1;s:35:\"contract-comment-to-client-japanese\";i:1;s:34:\"contract-comment-to-admin-japanese\";i:1;s:26:\"send-subscription-japanese\";i:1;s:36:\"subscription-payment-failed-japanese\";i:1;s:30:\"subscription-canceled-japanese\";i:1;s:39:\"subscription-payment-succeeded-japanese\";i:1;s:37:\"contract-expiration-to-staff-japanese\";i:1;s:29:\"gdpr-removal-request-japanese\";i:1;s:34:\"gdpr-removal-request-lead-japanese\";i:1;s:38:\"client-registration-confirmed-japanese\";i:1;s:33:\"contract-signed-to-staff-japanese\";i:1;s:37:\"customer-subscribed-to-staff-japanese\";i:1;s:35:\"contact-verification-email-japanese\";i:1;s:52:\"new-customer-profile-file-uploaded-to-staff-japanese\";i:1;s:36:\"event-notification-to-staff-japanese\";i:1;s:45:\"subscription-payment-requires-action-japanese\";i:1;s:27:\"invoice-due-notice-japanese\";i:1;s:44:\"estimate-request-submitted-to-staff-japanese\";i:1;s:34:\"estimate-request-assigned-japanese\";i:1;s:42:\"estimate-request-received-to-user-japanese\";i:1;s:34:\"non-billed-tasks-reminder-japanese\";i:1;s:32:\"invoices-batch-payments-japanese\";i:1;s:31:\"contract-sign-reminder-japanese\";i:1;s:26:\"new-client-created-russian\";i:1;s:30:\"invoice-send-to-client-russian\";i:1;s:31:\"new-ticket-opened-admin-russian\";i:1;s:20:\"ticket-reply-russian\";i:1;s:27:\"ticket-autoresponse-russian\";i:1;s:32:\"invoice-payment-recorded-russian\";i:1;s:30:\"invoice-overdue-notice-russian\";i:1;s:28:\"invoice-already-send-russian\";i:1;s:32:\"new-ticket-created-staff-russian\";i:1;s:31:\"estimate-send-to-client-russian\";i:1;s:29:\"ticket-reply-to-admin-russian\";i:1;s:29:\"estimate-already-send-russian\";i:1;s:27:\"contract-expiration-russian\";i:1;s:21:\"task-assigned-russian\";i:1;s:30:\"task-added-as-follower-russian\";i:1;s:22:\"task-commented-russian\";i:1;s:29:\"task-added-attachment-russian\";i:1;s:34:\"estimate-declined-to-staff-russian\";i:1;s:34:\"estimate-accepted-to-staff-russian\";i:1;s:32:\"proposal-client-accepted-russian\";i:1;s:33:\"proposal-send-to-customer-russian\";i:1;s:32:\"proposal-client-declined-russian\";i:1;s:33:\"proposal-client-thank-you-russian\";i:1;s:34:\"proposal-comment-to-client-russian\";i:1;s:33:\"proposal-comment-to-admin-russian\";i:1;s:38:\"estimate-thank-you-to-customer-russian\";i:1;s:34:\"task-deadline-notification-russian\";i:1;s:21:\"send-contract-russian\";i:1;s:41:\"invoice-payment-recorded-to-staff-russian\";i:1;s:25:\"auto-close-ticket-russian\";i:1;s:47:\"new-project-discussion-created-to-staff-russian\";i:1;s:50:\"new-project-discussion-created-to-customer-russian\";i:1;s:45:\"new-project-file-uploaded-to-customer-russian\";i:1;s:42:\"new-project-file-uploaded-to-staff-russian\";i:1;s:50:\"new-project-discussion-comment-to-customer-russian\";i:1;s:47:\"new-project-discussion-comment-to-staff-russian\";i:1;s:37:\"staff-added-as-project-member-russian\";i:1;s:32:\"estimate-expiry-reminder-russian\";i:1;s:32:\"proposal-expiry-reminder-russian\";i:1;s:25:\"new-staff-created-russian\";i:1;s:31:\"contact-forgot-password-russian\";i:1;s:32:\"contact-password-reseted-russian\";i:1;s:28:\"contact-set-password-russian\";i:1;s:29:\"staff-forgot-password-russian\";i:1;s:30:\"staff-password-reseted-russian\";i:1;s:27:\"assigned-to-project-russian\";i:1;s:41:\"task-added-attachment-to-contacts-russian\";i:1;s:34:\"task-commented-to-contacts-russian\";i:1;s:25:\"new-lead-assigned-russian\";i:1;s:24:\"client-statement-russian\";i:1;s:32:\"ticket-assigned-to-admin-russian\";i:1;s:38:\"new-client-registered-to-admin-russian\";i:1;s:38:\"new-web-to-lead-form-submitted-russian\";i:1;s:33:\"two-factor-authentication-russian\";i:1;s:36:\"project-finished-to-customer-russian\";i:1;s:34:\"credit-note-send-to-client-russian\";i:1;s:35:\"task-status-change-to-staff-russian\";i:1;s:38:\"task-status-change-to-contacts-russian\";i:1;s:28:\"reminder-email-staff-russian\";i:1;s:34:\"contract-comment-to-client-russian\";i:1;s:33:\"contract-comment-to-admin-russian\";i:1;s:25:\"send-subscription-russian\";i:1;s:35:\"subscription-payment-failed-russian\";i:1;s:29:\"subscription-canceled-russian\";i:1;s:38:\"subscription-payment-succeeded-russian\";i:1;s:36:\"contract-expiration-to-staff-russian\";i:1;s:28:\"gdpr-removal-request-russian\";i:1;s:33:\"gdpr-removal-request-lead-russian\";i:1;s:37:\"client-registration-confirmed-russian\";i:1;s:32:\"contract-signed-to-staff-russian\";i:1;s:36:\"customer-subscribed-to-staff-russian\";i:1;s:34:\"contact-verification-email-russian\";i:1;s:51:\"new-customer-profile-file-uploaded-to-staff-russian\";i:1;s:35:\"event-notification-to-staff-russian\";i:1;s:44:\"subscription-payment-requires-action-russian\";i:1;s:26:\"invoice-due-notice-russian\";i:1;s:43:\"estimate-request-submitted-to-staff-russian\";i:1;s:33:\"estimate-request-assigned-russian\";i:1;s:41:\"estimate-request-received-to-user-russian\";i:1;s:33:\"non-billed-tasks-reminder-russian\";i:1;s:31:\"invoices-batch-payments-russian\";i:1;s:30:\"contract-sign-reminder-russian\";i:1;s:28:\"new-client-created-ukrainian\";i:1;s:32:\"invoice-send-to-client-ukrainian\";i:1;s:33:\"new-ticket-opened-admin-ukrainian\";i:1;s:22:\"ticket-reply-ukrainian\";i:1;s:29:\"ticket-autoresponse-ukrainian\";i:1;s:34:\"invoice-payment-recorded-ukrainian\";i:1;s:32:\"invoice-overdue-notice-ukrainian\";i:1;s:30:\"invoice-already-send-ukrainian\";i:1;s:34:\"new-ticket-created-staff-ukrainian\";i:1;s:33:\"estimate-send-to-client-ukrainian\";i:1;s:31:\"ticket-reply-to-admin-ukrainian\";i:1;s:31:\"estimate-already-send-ukrainian\";i:1;s:29:\"contract-expiration-ukrainian\";i:1;s:23:\"task-assigned-ukrainian\";i:1;s:32:\"task-added-as-follower-ukrainian\";i:1;s:24:\"task-commented-ukrainian\";i:1;s:31:\"task-added-attachment-ukrainian\";i:1;s:36:\"estimate-declined-to-staff-ukrainian\";i:1;s:36:\"estimate-accepted-to-staff-ukrainian\";i:1;s:34:\"proposal-client-accepted-ukrainian\";i:1;s:35:\"proposal-send-to-customer-ukrainian\";i:1;s:34:\"proposal-client-declined-ukrainian\";i:1;s:35:\"proposal-client-thank-you-ukrainian\";i:1;s:36:\"proposal-comment-to-client-ukrainian\";i:1;s:35:\"proposal-comment-to-admin-ukrainian\";i:1;s:40:\"estimate-thank-you-to-customer-ukrainian\";i:1;s:36:\"task-deadline-notification-ukrainian\";i:1;s:23:\"send-contract-ukrainian\";i:1;s:43:\"invoice-payment-recorded-to-staff-ukrainian\";i:1;s:27:\"auto-close-ticket-ukrainian\";i:1;s:49:\"new-project-discussion-created-to-staff-ukrainian\";i:1;s:52:\"new-project-discussion-created-to-customer-ukrainian\";i:1;s:47:\"new-project-file-uploaded-to-customer-ukrainian\";i:1;s:44:\"new-project-file-uploaded-to-staff-ukrainian\";i:1;s:52:\"new-project-discussion-comment-to-customer-ukrainian\";i:1;s:49:\"new-project-discussion-comment-to-staff-ukrainian\";i:1;s:39:\"staff-added-as-project-member-ukrainian\";i:1;s:34:\"estimate-expiry-reminder-ukrainian\";i:1;s:34:\"proposal-expiry-reminder-ukrainian\";i:1;s:27:\"new-staff-created-ukrainian\";i:1;s:33:\"contact-forgot-password-ukrainian\";i:1;s:34:\"contact-password-reseted-ukrainian\";i:1;s:30:\"contact-set-password-ukrainian\";i:1;s:31:\"staff-forgot-password-ukrainian\";i:1;s:32:\"staff-password-reseted-ukrainian\";i:1;s:29:\"assigned-to-project-ukrainian\";i:1;s:43:\"task-added-attachment-to-contacts-ukrainian\";i:1;s:36:\"task-commented-to-contacts-ukrainian\";i:1;s:27:\"new-lead-assigned-ukrainian\";i:1;s:26:\"client-statement-ukrainian\";i:1;s:34:\"ticket-assigned-to-admin-ukrainian\";i:1;s:40:\"new-client-registered-to-admin-ukrainian\";i:1;s:40:\"new-web-to-lead-form-submitted-ukrainian\";i:1;s:35:\"two-factor-authentication-ukrainian\";i:1;s:38:\"project-finished-to-customer-ukrainian\";i:1;s:36:\"credit-note-send-to-client-ukrainian\";i:1;s:37:\"task-status-change-to-staff-ukrainian\";i:1;s:40:\"task-status-change-to-contacts-ukrainian\";i:1;s:30:\"reminder-email-staff-ukrainian\";i:1;s:36:\"contract-comment-to-client-ukrainian\";i:1;s:35:\"contract-comment-to-admin-ukrainian\";i:1;s:27:\"send-subscription-ukrainian\";i:1;s:37:\"subscription-payment-failed-ukrainian\";i:1;s:31:\"subscription-canceled-ukrainian\";i:1;s:40:\"subscription-payment-succeeded-ukrainian\";i:1;s:38:\"contract-expiration-to-staff-ukrainian\";i:1;s:30:\"gdpr-removal-request-ukrainian\";i:1;s:35:\"gdpr-removal-request-lead-ukrainian\";i:1;s:39:\"client-registration-confirmed-ukrainian\";i:1;s:34:\"contract-signed-to-staff-ukrainian\";i:1;s:38:\"customer-subscribed-to-staff-ukrainian\";i:1;s:36:\"contact-verification-email-ukrainian\";i:1;s:53:\"new-customer-profile-file-uploaded-to-staff-ukrainian\";i:1;s:37:\"event-notification-to-staff-ukrainian\";i:1;s:46:\"subscription-payment-requires-action-ukrainian\";i:1;s:28:\"invoice-due-notice-ukrainian\";i:1;s:45:\"estimate-request-submitted-to-staff-ukrainian\";i:1;s:35:\"estimate-request-assigned-ukrainian\";i:1;s:43:\"estimate-request-received-to-user-ukrainian\";i:1;s:35:\"non-billed-tasks-reminder-ukrainian\";i:1;s:33:\"invoices-batch-payments-ukrainian\";i:1;s:32:\"contract-sign-reminder-ukrainian\";i:1;s:26:\"new-client-created-swedish\";i:1;s:30:\"invoice-send-to-client-swedish\";i:1;s:31:\"new-ticket-opened-admin-swedish\";i:1;s:20:\"ticket-reply-swedish\";i:1;s:27:\"ticket-autoresponse-swedish\";i:1;s:32:\"invoice-payment-recorded-swedish\";i:1;s:30:\"invoice-overdue-notice-swedish\";i:1;s:28:\"invoice-already-send-swedish\";i:1;s:32:\"new-ticket-created-staff-swedish\";i:1;s:31:\"estimate-send-to-client-swedish\";i:1;s:29:\"ticket-reply-to-admin-swedish\";i:1;s:29:\"estimate-already-send-swedish\";i:1;s:27:\"contract-expiration-swedish\";i:1;s:21:\"task-assigned-swedish\";i:1;s:30:\"task-added-as-follower-swedish\";i:1;s:22:\"task-commented-swedish\";i:1;s:29:\"task-added-attachment-swedish\";i:1;s:34:\"estimate-declined-to-staff-swedish\";i:1;s:34:\"estimate-accepted-to-staff-swedish\";i:1;s:32:\"proposal-client-accepted-swedish\";i:1;s:33:\"proposal-send-to-customer-swedish\";i:1;s:32:\"proposal-client-declined-swedish\";i:1;s:33:\"proposal-client-thank-you-swedish\";i:1;s:34:\"proposal-comment-to-client-swedish\";i:1;s:33:\"proposal-comment-to-admin-swedish\";i:1;s:38:\"estimate-thank-you-to-customer-swedish\";i:1;s:34:\"task-deadline-notification-swedish\";i:1;s:21:\"send-contract-swedish\";i:1;s:41:\"invoice-payment-recorded-to-staff-swedish\";i:1;s:25:\"auto-close-ticket-swedish\";i:1;s:47:\"new-project-discussion-created-to-staff-swedish\";i:1;s:50:\"new-project-discussion-created-to-customer-swedish\";i:1;s:45:\"new-project-file-uploaded-to-customer-swedish\";i:1;s:42:\"new-project-file-uploaded-to-staff-swedish\";i:1;s:50:\"new-project-discussion-comment-to-customer-swedish\";i:1;s:47:\"new-project-discussion-comment-to-staff-swedish\";i:1;s:37:\"staff-added-as-project-member-swedish\";i:1;s:32:\"estimate-expiry-reminder-swedish\";i:1;s:32:\"proposal-expiry-reminder-swedish\";i:1;s:25:\"new-staff-created-swedish\";i:1;s:31:\"contact-forgot-password-swedish\";i:1;s:32:\"contact-password-reseted-swedish\";i:1;s:28:\"contact-set-password-swedish\";i:1;s:29:\"staff-forgot-password-swedish\";i:1;s:30:\"staff-password-reseted-swedish\";i:1;s:27:\"assigned-to-project-swedish\";i:1;s:41:\"task-added-attachment-to-contacts-swedish\";i:1;s:34:\"task-commented-to-contacts-swedish\";i:1;s:25:\"new-lead-assigned-swedish\";i:1;s:24:\"client-statement-swedish\";i:1;s:32:\"ticket-assigned-to-admin-swedish\";i:1;s:38:\"new-client-registered-to-admin-swedish\";i:1;s:38:\"new-web-to-lead-form-submitted-swedish\";i:1;s:33:\"two-factor-authentication-swedish\";i:1;s:36:\"project-finished-to-customer-swedish\";i:1;s:34:\"credit-note-send-to-client-swedish\";i:1;s:35:\"task-status-change-to-staff-swedish\";i:1;s:38:\"task-status-change-to-contacts-swedish\";i:1;s:28:\"reminder-email-staff-swedish\";i:1;s:34:\"contract-comment-to-client-swedish\";i:1;s:33:\"contract-comment-to-admin-swedish\";i:1;s:25:\"send-subscription-swedish\";i:1;s:35:\"subscription-payment-failed-swedish\";i:1;s:29:\"subscription-canceled-swedish\";i:1;s:38:\"subscription-payment-succeeded-swedish\";i:1;s:36:\"contract-expiration-to-staff-swedish\";i:1;s:28:\"gdpr-removal-request-swedish\";i:1;s:33:\"gdpr-removal-request-lead-swedish\";i:1;s:37:\"client-registration-confirmed-swedish\";i:1;s:32:\"contract-signed-to-staff-swedish\";i:1;s:36:\"customer-subscribed-to-staff-swedish\";i:1;s:34:\"contact-verification-email-swedish\";i:1;s:51:\"new-customer-profile-file-uploaded-to-staff-swedish\";i:1;s:35:\"event-notification-to-staff-swedish\";i:1;s:44:\"subscription-payment-requires-action-swedish\";i:1;s:26:\"invoice-due-notice-swedish\";i:1;s:43:\"estimate-request-submitted-to-staff-swedish\";i:1;s:33:\"estimate-request-assigned-swedish\";i:1;s:41:\"estimate-request-received-to-user-swedish\";i:1;s:33:\"non-billed-tasks-reminder-swedish\";i:1;s:31:\"invoices-batch-payments-swedish\";i:1;s:30:\"contract-sign-reminder-swedish\";i:1;s:28:\"new-client-created-bulgarian\";i:1;s:32:\"invoice-send-to-client-bulgarian\";i:1;s:33:\"new-ticket-opened-admin-bulgarian\";i:1;s:22:\"ticket-reply-bulgarian\";i:1;s:29:\"ticket-autoresponse-bulgarian\";i:1;s:34:\"invoice-payment-recorded-bulgarian\";i:1;s:32:\"invoice-overdue-notice-bulgarian\";i:1;s:30:\"invoice-already-send-bulgarian\";i:1;s:34:\"new-ticket-created-staff-bulgarian\";i:1;s:33:\"estimate-send-to-client-bulgarian\";i:1;s:31:\"ticket-reply-to-admin-bulgarian\";i:1;s:31:\"estimate-already-send-bulgarian\";i:1;s:29:\"contract-expiration-bulgarian\";i:1;s:23:\"task-assigned-bulgarian\";i:1;s:32:\"task-added-as-follower-bulgarian\";i:1;s:24:\"task-commented-bulgarian\";i:1;s:31:\"task-added-attachment-bulgarian\";i:1;s:36:\"estimate-declined-to-staff-bulgarian\";i:1;s:36:\"estimate-accepted-to-staff-bulgarian\";i:1;s:34:\"proposal-client-accepted-bulgarian\";i:1;s:35:\"proposal-send-to-customer-bulgarian\";i:1;s:34:\"proposal-client-declined-bulgarian\";i:1;s:35:\"proposal-client-thank-you-bulgarian\";i:1;s:36:\"proposal-comment-to-client-bulgarian\";i:1;s:35:\"proposal-comment-to-admin-bulgarian\";i:1;s:40:\"estimate-thank-you-to-customer-bulgarian\";i:1;s:36:\"task-deadline-notification-bulgarian\";i:1;s:23:\"send-contract-bulgarian\";i:1;s:43:\"invoice-payment-recorded-to-staff-bulgarian\";i:1;s:27:\"auto-close-ticket-bulgarian\";i:1;s:49:\"new-project-discussion-created-to-staff-bulgarian\";i:1;s:52:\"new-project-discussion-created-to-customer-bulgarian\";i:1;s:47:\"new-project-file-uploaded-to-customer-bulgarian\";i:1;s:44:\"new-project-file-uploaded-to-staff-bulgarian\";i:1;s:52:\"new-project-discussion-comment-to-customer-bulgarian\";i:1;s:49:\"new-project-discussion-comment-to-staff-bulgarian\";i:1;s:39:\"staff-added-as-project-member-bulgarian\";i:1;s:34:\"estimate-expiry-reminder-bulgarian\";i:1;s:34:\"proposal-expiry-reminder-bulgarian\";i:1;s:27:\"new-staff-created-bulgarian\";i:1;s:33:\"contact-forgot-password-bulgarian\";i:1;s:34:\"contact-password-reseted-bulgarian\";i:1;s:30:\"contact-set-password-bulgarian\";i:1;s:31:\"staff-forgot-password-bulgarian\";i:1;s:32:\"staff-password-reseted-bulgarian\";i:1;s:29:\"assigned-to-project-bulgarian\";i:1;s:43:\"task-added-attachment-to-contacts-bulgarian\";i:1;s:36:\"task-commented-to-contacts-bulgarian\";i:1;s:27:\"new-lead-assigned-bulgarian\";i:1;s:26:\"client-statement-bulgarian\";i:1;s:34:\"ticket-assigned-to-admin-bulgarian\";i:1;s:40:\"new-client-registered-to-admin-bulgarian\";i:1;s:40:\"new-web-to-lead-form-submitted-bulgarian\";i:1;s:35:\"two-factor-authentication-bulgarian\";i:1;s:38:\"project-finished-to-customer-bulgarian\";i:1;s:36:\"credit-note-send-to-client-bulgarian\";i:1;s:37:\"task-status-change-to-staff-bulgarian\";i:1;s:40:\"task-status-change-to-contacts-bulgarian\";i:1;s:30:\"reminder-email-staff-bulgarian\";i:1;s:36:\"contract-comment-to-client-bulgarian\";i:1;s:35:\"contract-comment-to-admin-bulgarian\";i:1;s:27:\"send-subscription-bulgarian\";i:1;s:37:\"subscription-payment-failed-bulgarian\";i:1;s:31:\"subscription-canceled-bulgarian\";i:1;s:40:\"subscription-payment-succeeded-bulgarian\";i:1;s:38:\"contract-expiration-to-staff-bulgarian\";i:1;s:30:\"gdpr-removal-request-bulgarian\";i:1;s:35:\"gdpr-removal-request-lead-bulgarian\";i:1;s:39:\"client-registration-confirmed-bulgarian\";i:1;s:34:\"contract-signed-to-staff-bulgarian\";i:1;s:38:\"customer-subscribed-to-staff-bulgarian\";i:1;s:36:\"contact-verification-email-bulgarian\";i:1;s:53:\"new-customer-profile-file-uploaded-to-staff-bulgarian\";i:1;s:37:\"event-notification-to-staff-bulgarian\";i:1;s:46:\"subscription-payment-requires-action-bulgarian\";i:1;s:28:\"invoice-due-notice-bulgarian\";i:1;s:45:\"estimate-request-submitted-to-staff-bulgarian\";i:1;s:35:\"estimate-request-assigned-bulgarian\";i:1;s:43:\"estimate-request-received-to-user-bulgarian\";i:1;s:35:\"non-billed-tasks-reminder-bulgarian\";i:1;s:33:\"invoices-batch-payments-bulgarian\";i:1;s:32:\"contract-sign-reminder-bulgarian\";i:1;s:29:\"new-client-created-vietnamese\";i:1;s:33:\"invoice-send-to-client-vietnamese\";i:1;s:34:\"new-ticket-opened-admin-vietnamese\";i:1;s:23:\"ticket-reply-vietnamese\";i:1;s:30:\"ticket-autoresponse-vietnamese\";i:1;s:35:\"invoice-payment-recorded-vietnamese\";i:1;s:33:\"invoice-overdue-notice-vietnamese\";i:1;s:31:\"invoice-already-send-vietnamese\";i:1;s:35:\"new-ticket-created-staff-vietnamese\";i:1;s:34:\"estimate-send-to-client-vietnamese\";i:1;s:32:\"ticket-reply-to-admin-vietnamese\";i:1;s:32:\"estimate-already-send-vietnamese\";i:1;s:30:\"contract-expiration-vietnamese\";i:1;s:24:\"task-assigned-vietnamese\";i:1;s:33:\"task-added-as-follower-vietnamese\";i:1;s:25:\"task-commented-vietnamese\";i:1;s:32:\"task-added-attachment-vietnamese\";i:1;s:37:\"estimate-declined-to-staff-vietnamese\";i:1;s:37:\"estimate-accepted-to-staff-vietnamese\";i:1;s:35:\"proposal-client-accepted-vietnamese\";i:1;s:36:\"proposal-send-to-customer-vietnamese\";i:1;s:35:\"proposal-client-declined-vietnamese\";i:1;s:36:\"proposal-client-thank-you-vietnamese\";i:1;s:37:\"proposal-comment-to-client-vietnamese\";i:1;s:36:\"proposal-comment-to-admin-vietnamese\";i:1;s:41:\"estimate-thank-you-to-customer-vietnamese\";i:1;s:37:\"task-deadline-notification-vietnamese\";i:1;s:24:\"send-contract-vietnamese\";i:1;s:44:\"invoice-payment-recorded-to-staff-vietnamese\";i:1;s:28:\"auto-close-ticket-vietnamese\";i:1;s:50:\"new-project-discussion-created-to-staff-vietnamese\";i:1;s:53:\"new-project-discussion-created-to-customer-vietnamese\";i:1;s:48:\"new-project-file-uploaded-to-customer-vietnamese\";i:1;s:45:\"new-project-file-uploaded-to-staff-vietnamese\";i:1;s:53:\"new-project-discussion-comment-to-customer-vietnamese\";i:1;s:50:\"new-project-discussion-comment-to-staff-vietnamese\";i:1;s:40:\"staff-added-as-project-member-vietnamese\";i:1;s:35:\"estimate-expiry-reminder-vietnamese\";i:1;s:35:\"proposal-expiry-reminder-vietnamese\";i:1;s:28:\"new-staff-created-vietnamese\";i:1;s:34:\"contact-forgot-password-vietnamese\";i:1;s:35:\"contact-password-reseted-vietnamese\";i:1;s:31:\"contact-set-password-vietnamese\";i:1;s:32:\"staff-forgot-password-vietnamese\";i:1;s:33:\"staff-password-reseted-vietnamese\";i:1;s:30:\"assigned-to-project-vietnamese\";i:1;s:44:\"task-added-attachment-to-contacts-vietnamese\";i:1;s:37:\"task-commented-to-contacts-vietnamese\";i:1;s:28:\"new-lead-assigned-vietnamese\";i:1;s:27:\"client-statement-vietnamese\";i:1;s:35:\"ticket-assigned-to-admin-vietnamese\";i:1;s:41:\"new-client-registered-to-admin-vietnamese\";i:1;s:41:\"new-web-to-lead-form-submitted-vietnamese\";i:1;s:36:\"two-factor-authentication-vietnamese\";i:1;s:39:\"project-finished-to-customer-vietnamese\";i:1;s:37:\"credit-note-send-to-client-vietnamese\";i:1;s:38:\"task-status-change-to-staff-vietnamese\";i:1;s:41:\"task-status-change-to-contacts-vietnamese\";i:1;s:31:\"reminder-email-staff-vietnamese\";i:1;s:37:\"contract-comment-to-client-vietnamese\";i:1;s:36:\"contract-comment-to-admin-vietnamese\";i:1;s:28:\"send-subscription-vietnamese\";i:1;s:38:\"subscription-payment-failed-vietnamese\";i:1;s:32:\"subscription-canceled-vietnamese\";i:1;s:41:\"subscription-payment-succeeded-vietnamese\";i:1;s:39:\"contract-expiration-to-staff-vietnamese\";i:1;s:31:\"gdpr-removal-request-vietnamese\";i:1;s:36:\"gdpr-removal-request-lead-vietnamese\";i:1;s:40:\"client-registration-confirmed-vietnamese\";i:1;s:35:\"contract-signed-to-staff-vietnamese\";i:1;s:39:\"customer-subscribed-to-staff-vietnamese\";i:1;s:37:\"contact-verification-email-vietnamese\";i:1;s:54:\"new-customer-profile-file-uploaded-to-staff-vietnamese\";i:1;s:38:\"event-notification-to-staff-vietnamese\";i:1;s:47:\"subscription-payment-requires-action-vietnamese\";i:1;s:29:\"invoice-due-notice-vietnamese\";i:1;s:46:\"estimate-request-submitted-to-staff-vietnamese\";i:1;s:36:\"estimate-request-assigned-vietnamese\";i:1;s:44:\"estimate-request-received-to-user-vietnamese\";i:1;s:36:\"non-billed-tasks-reminder-vietnamese\";i:1;s:34:\"invoices-batch-payments-vietnamese\";i:1;s:33:\"contract-sign-reminder-vietnamese\";i:1;s:25:\"new-client-created-slovak\";i:1;s:29:\"invoice-send-to-client-slovak\";i:1;s:30:\"new-ticket-opened-admin-slovak\";i:1;s:19:\"ticket-reply-slovak\";i:1;s:26:\"ticket-autoresponse-slovak\";i:1;s:31:\"invoice-payment-recorded-slovak\";i:1;s:29:\"invoice-overdue-notice-slovak\";i:1;s:27:\"invoice-already-send-slovak\";i:1;s:31:\"new-ticket-created-staff-slovak\";i:1;s:30:\"estimate-send-to-client-slovak\";i:1;s:28:\"ticket-reply-to-admin-slovak\";i:1;s:28:\"estimate-already-send-slovak\";i:1;s:26:\"contract-expiration-slovak\";i:1;s:20:\"task-assigned-slovak\";i:1;s:29:\"task-added-as-follower-slovak\";i:1;s:21:\"task-commented-slovak\";i:1;s:28:\"task-added-attachment-slovak\";i:1;s:33:\"estimate-declined-to-staff-slovak\";i:1;s:33:\"estimate-accepted-to-staff-slovak\";i:1;s:31:\"proposal-client-accepted-slovak\";i:1;s:32:\"proposal-send-to-customer-slovak\";i:1;s:31:\"proposal-client-declined-slovak\";i:1;s:32:\"proposal-client-thank-you-slovak\";i:1;s:33:\"proposal-comment-to-client-slovak\";i:1;s:32:\"proposal-comment-to-admin-slovak\";i:1;s:37:\"estimate-thank-you-to-customer-slovak\";i:1;s:33:\"task-deadline-notification-slovak\";i:1;s:20:\"send-contract-slovak\";i:1;s:40:\"invoice-payment-recorded-to-staff-slovak\";i:1;s:24:\"auto-close-ticket-slovak\";i:1;s:46:\"new-project-discussion-created-to-staff-slovak\";i:1;s:49:\"new-project-discussion-created-to-customer-slovak\";i:1;s:44:\"new-project-file-uploaded-to-customer-slovak\";i:1;s:41:\"new-project-file-uploaded-to-staff-slovak\";i:1;s:49:\"new-project-discussion-comment-to-customer-slovak\";i:1;s:46:\"new-project-discussion-comment-to-staff-slovak\";i:1;s:36:\"staff-added-as-project-member-slovak\";i:1;s:31:\"estimate-expiry-reminder-slovak\";i:1;s:31:\"proposal-expiry-reminder-slovak\";i:1;s:24:\"new-staff-created-slovak\";i:1;s:30:\"contact-forgot-password-slovak\";i:1;s:31:\"contact-password-reseted-slovak\";i:1;s:27:\"contact-set-password-slovak\";i:1;s:28:\"staff-forgot-password-slovak\";i:1;s:29:\"staff-password-reseted-slovak\";i:1;s:26:\"assigned-to-project-slovak\";i:1;s:40:\"task-added-attachment-to-contacts-slovak\";i:1;s:33:\"task-commented-to-contacts-slovak\";i:1;s:24:\"new-lead-assigned-slovak\";i:1;s:23:\"client-statement-slovak\";i:1;s:31:\"ticket-assigned-to-admin-slovak\";i:1;s:37:\"new-client-registered-to-admin-slovak\";i:1;s:37:\"new-web-to-lead-form-submitted-slovak\";i:1;s:32:\"two-factor-authentication-slovak\";i:1;s:35:\"project-finished-to-customer-slovak\";i:1;s:33:\"credit-note-send-to-client-slovak\";i:1;s:34:\"task-status-change-to-staff-slovak\";i:1;s:37:\"task-status-change-to-contacts-slovak\";i:1;s:27:\"reminder-email-staff-slovak\";i:1;s:33:\"contract-comment-to-client-slovak\";i:1;s:32:\"contract-comment-to-admin-slovak\";i:1;s:24:\"send-subscription-slovak\";i:1;s:34:\"subscription-payment-failed-slovak\";i:1;s:28:\"subscription-canceled-slovak\";i:1;s:37:\"subscription-payment-succeeded-slovak\";i:1;s:35:\"contract-expiration-to-staff-slovak\";i:1;s:27:\"gdpr-removal-request-slovak\";i:1;s:32:\"gdpr-removal-request-lead-slovak\";i:1;s:36:\"client-registration-confirmed-slovak\";i:1;s:31:\"contract-signed-to-staff-slovak\";i:1;s:35:\"customer-subscribed-to-staff-slovak\";i:1;s:33:\"contact-verification-email-slovak\";i:1;s:50:\"new-customer-profile-file-uploaded-to-staff-slovak\";i:1;s:34:\"event-notification-to-staff-slovak\";i:1;s:43:\"subscription-payment-requires-action-slovak\";i:1;s:25:\"invoice-due-notice-slovak\";i:1;s:42:\"estimate-request-submitted-to-staff-slovak\";i:1;s:32:\"estimate-request-assigned-slovak\";i:1;s:40:\"estimate-request-received-to-user-slovak\";i:1;s:32:\"non-billed-tasks-reminder-slovak\";i:1;s:30:\"invoices-batch-payments-slovak\";i:1;s:29:\"contract-sign-reminder-slovak\";i:1;s:25:\"new-client-created-french\";i:1;s:29:\"invoice-send-to-client-french\";i:1;s:30:\"new-ticket-opened-admin-french\";i:1;s:19:\"ticket-reply-french\";i:1;s:26:\"ticket-autoresponse-french\";i:1;s:31:\"invoice-payment-recorded-french\";i:1;s:29:\"invoice-overdue-notice-french\";i:1;s:27:\"invoice-already-send-french\";i:1;s:31:\"new-ticket-created-staff-french\";i:1;s:30:\"estimate-send-to-client-french\";i:1;s:28:\"ticket-reply-to-admin-french\";i:1;s:28:\"estimate-already-send-french\";i:1;s:26:\"contract-expiration-french\";i:1;s:20:\"task-assigned-french\";i:1;s:29:\"task-added-as-follower-french\";i:1;s:21:\"task-commented-french\";i:1;s:28:\"task-added-attachment-french\";i:1;s:33:\"estimate-declined-to-staff-french\";i:1;s:33:\"estimate-accepted-to-staff-french\";i:1;s:31:\"proposal-client-accepted-french\";i:1;s:32:\"proposal-send-to-customer-french\";i:1;s:31:\"proposal-client-declined-french\";i:1;s:32:\"proposal-client-thank-you-french\";i:1;s:33:\"proposal-comment-to-client-french\";i:1;s:32:\"proposal-comment-to-admin-french\";i:1;s:37:\"estimate-thank-you-to-customer-french\";i:1;s:33:\"task-deadline-notification-french\";i:1;s:20:\"send-contract-french\";i:1;s:40:\"invoice-payment-recorded-to-staff-french\";i:1;s:24:\"auto-close-ticket-french\";i:1;s:46:\"new-project-discussion-created-to-staff-french\";i:1;s:49:\"new-project-discussion-created-to-customer-french\";i:1;s:44:\"new-project-file-uploaded-to-customer-french\";i:1;s:41:\"new-project-file-uploaded-to-staff-french\";i:1;s:49:\"new-project-discussion-comment-to-customer-french\";i:1;s:46:\"new-project-discussion-comment-to-staff-french\";i:1;s:36:\"staff-added-as-project-member-french\";i:1;s:31:\"estimate-expiry-reminder-french\";i:1;s:31:\"proposal-expiry-reminder-french\";i:1;s:24:\"new-staff-created-french\";i:1;s:30:\"contact-forgot-password-french\";i:1;s:31:\"contact-password-reseted-french\";i:1;s:27:\"contact-set-password-french\";i:1;s:28:\"staff-forgot-password-french\";i:1;s:29:\"staff-password-reseted-french\";i:1;s:26:\"assigned-to-project-french\";i:1;s:40:\"task-added-attachment-to-contacts-french\";i:1;s:33:\"task-commented-to-contacts-french\";i:1;s:24:\"new-lead-assigned-french\";i:1;s:23:\"client-statement-french\";i:1;s:31:\"ticket-assigned-to-admin-french\";i:1;s:37:\"new-client-registered-to-admin-french\";i:1;s:37:\"new-web-to-lead-form-submitted-french\";i:1;s:32:\"two-factor-authentication-french\";i:1;s:35:\"project-finished-to-customer-french\";i:1;s:33:\"credit-note-send-to-client-french\";i:1;s:34:\"task-status-change-to-staff-french\";i:1;s:37:\"task-status-change-to-contacts-french\";i:1;s:27:\"reminder-email-staff-french\";i:1;s:33:\"contract-comment-to-client-french\";i:1;s:32:\"contract-comment-to-admin-french\";i:1;s:24:\"send-subscription-french\";i:1;s:34:\"subscription-payment-failed-french\";i:1;s:28:\"subscription-canceled-french\";i:1;s:37:\"subscription-payment-succeeded-french\";i:1;s:35:\"contract-expiration-to-staff-french\";i:1;s:27:\"gdpr-removal-request-french\";i:1;s:32:\"gdpr-removal-request-lead-french\";i:1;s:36:\"client-registration-confirmed-french\";i:1;s:31:\"contract-signed-to-staff-french\";i:1;s:35:\"customer-subscribed-to-staff-french\";i:1;s:33:\"contact-verification-email-french\";i:1;s:50:\"new-customer-profile-file-uploaded-to-staff-french\";i:1;s:34:\"event-notification-to-staff-french\";i:1;s:43:\"subscription-payment-requires-action-french\";i:1;s:25:\"invoice-due-notice-french\";i:1;s:42:\"estimate-request-submitted-to-staff-french\";i:1;s:32:\"estimate-request-assigned-french\";i:1;s:40:\"estimate-request-received-to-user-french\";i:1;s:32:\"non-billed-tasks-reminder-french\";i:1;s:30:\"invoices-batch-payments-french\";i:1;s:29:\"contract-sign-reminder-french\";i:1;s:26:\"new-client-created-persian\";i:1;s:30:\"invoice-send-to-client-persian\";i:1;s:31:\"new-ticket-opened-admin-persian\";i:1;s:20:\"ticket-reply-persian\";i:1;s:27:\"ticket-autoresponse-persian\";i:1;s:32:\"invoice-payment-recorded-persian\";i:1;s:30:\"invoice-overdue-notice-persian\";i:1;s:28:\"invoice-already-send-persian\";i:1;s:32:\"new-ticket-created-staff-persian\";i:1;s:31:\"estimate-send-to-client-persian\";i:1;s:29:\"ticket-reply-to-admin-persian\";i:1;s:29:\"estimate-already-send-persian\";i:1;s:27:\"contract-expiration-persian\";i:1;s:21:\"task-assigned-persian\";i:1;s:30:\"task-added-as-follower-persian\";i:1;s:22:\"task-commented-persian\";i:1;s:29:\"task-added-attachment-persian\";i:1;s:34:\"estimate-declined-to-staff-persian\";i:1;s:34:\"estimate-accepted-to-staff-persian\";i:1;s:32:\"proposal-client-accepted-persian\";i:1;s:33:\"proposal-send-to-customer-persian\";i:1;s:32:\"proposal-client-declined-persian\";i:1;s:33:\"proposal-client-thank-you-persian\";i:1;s:34:\"proposal-comment-to-client-persian\";i:1;s:33:\"proposal-comment-to-admin-persian\";i:1;s:38:\"estimate-thank-you-to-customer-persian\";i:1;s:34:\"task-deadline-notification-persian\";i:1;s:21:\"send-contract-persian\";i:1;s:41:\"invoice-payment-recorded-to-staff-persian\";i:1;s:25:\"auto-close-ticket-persian\";i:1;s:47:\"new-project-discussion-created-to-staff-persian\";i:1;s:50:\"new-project-discussion-created-to-customer-persian\";i:1;s:45:\"new-project-file-uploaded-to-customer-persian\";i:1;s:42:\"new-project-file-uploaded-to-staff-persian\";i:1;s:50:\"new-project-discussion-comment-to-customer-persian\";i:1;s:47:\"new-project-discussion-comment-to-staff-persian\";i:1;s:37:\"staff-added-as-project-member-persian\";i:1;s:32:\"estimate-expiry-reminder-persian\";i:1;s:32:\"proposal-expiry-reminder-persian\";i:1;s:25:\"new-staff-created-persian\";i:1;s:31:\"contact-forgot-password-persian\";i:1;s:32:\"contact-password-reseted-persian\";i:1;s:28:\"contact-set-password-persian\";i:1;s:29:\"staff-forgot-password-persian\";i:1;s:30:\"staff-password-reseted-persian\";i:1;s:27:\"assigned-to-project-persian\";i:1;s:41:\"task-added-attachment-to-contacts-persian\";i:1;s:34:\"task-commented-to-contacts-persian\";i:1;s:25:\"new-lead-assigned-persian\";i:1;s:24:\"client-statement-persian\";i:1;s:32:\"ticket-assigned-to-admin-persian\";i:1;s:38:\"new-client-registered-to-admin-persian\";i:1;s:38:\"new-web-to-lead-form-submitted-persian\";i:1;s:33:\"two-factor-authentication-persian\";i:1;s:36:\"project-finished-to-customer-persian\";i:1;s:34:\"credit-note-send-to-client-persian\";i:1;s:35:\"task-status-change-to-staff-persian\";i:1;s:38:\"task-status-change-to-contacts-persian\";i:1;s:28:\"reminder-email-staff-persian\";i:1;s:34:\"contract-comment-to-client-persian\";i:1;s:33:\"contract-comment-to-admin-persian\";i:1;s:25:\"send-subscription-persian\";i:1;s:35:\"subscription-payment-failed-persian\";i:1;s:29:\"subscription-canceled-persian\";i:1;s:38:\"subscription-payment-succeeded-persian\";i:1;s:36:\"contract-expiration-to-staff-persian\";i:1;s:28:\"gdpr-removal-request-persian\";i:1;s:33:\"gdpr-removal-request-lead-persian\";i:1;s:37:\"client-registration-confirmed-persian\";i:1;s:32:\"contract-signed-to-staff-persian\";i:1;s:36:\"customer-subscribed-to-staff-persian\";i:1;s:34:\"contact-verification-email-persian\";i:1;s:51:\"new-customer-profile-file-uploaded-to-staff-persian\";i:1;s:35:\"event-notification-to-staff-persian\";i:1;s:44:\"subscription-payment-requires-action-persian\";i:1;s:26:\"invoice-due-notice-persian\";i:1;s:43:\"estimate-request-submitted-to-staff-persian\";i:1;s:33:\"estimate-request-assigned-persian\";i:1;s:41:\"estimate-request-received-to-user-persian\";i:1;s:33:\"non-billed-tasks-reminder-persian\";i:1;s:31:\"invoices-batch-payments-persian\";i:1;s:30:\"contract-sign-reminder-persian\";i:1;s:26:\"new-client-created-catalan\";i:1;s:30:\"invoice-send-to-client-catalan\";i:1;s:31:\"new-ticket-opened-admin-catalan\";i:1;s:20:\"ticket-reply-catalan\";i:1;s:27:\"ticket-autoresponse-catalan\";i:1;s:32:\"invoice-payment-recorded-catalan\";i:1;s:30:\"invoice-overdue-notice-catalan\";i:1;s:28:\"invoice-already-send-catalan\";i:1;s:32:\"new-ticket-created-staff-catalan\";i:1;s:31:\"estimate-send-to-client-catalan\";i:1;s:29:\"ticket-reply-to-admin-catalan\";i:1;s:29:\"estimate-already-send-catalan\";i:1;s:27:\"contract-expiration-catalan\";i:1;s:21:\"task-assigned-catalan\";i:1;s:30:\"task-added-as-follower-catalan\";i:1;s:22:\"task-commented-catalan\";i:1;s:29:\"task-added-attachment-catalan\";i:1;s:34:\"estimate-declined-to-staff-catalan\";i:1;s:34:\"estimate-accepted-to-staff-catalan\";i:1;s:32:\"proposal-client-accepted-catalan\";i:1;s:33:\"proposal-send-to-customer-catalan\";i:1;s:32:\"proposal-client-declined-catalan\";i:1;s:33:\"proposal-client-thank-you-catalan\";i:1;s:34:\"proposal-comment-to-client-catalan\";i:1;s:33:\"proposal-comment-to-admin-catalan\";i:1;s:38:\"estimate-thank-you-to-customer-catalan\";i:1;s:34:\"task-deadline-notification-catalan\";i:1;s:21:\"send-contract-catalan\";i:1;s:41:\"invoice-payment-recorded-to-staff-catalan\";i:1;s:25:\"auto-close-ticket-catalan\";i:1;s:47:\"new-project-discussion-created-to-staff-catalan\";i:1;s:50:\"new-project-discussion-created-to-customer-catalan\";i:1;s:45:\"new-project-file-uploaded-to-customer-catalan\";i:1;s:42:\"new-project-file-uploaded-to-staff-catalan\";i:1;s:50:\"new-project-discussion-comment-to-customer-catalan\";i:1;s:47:\"new-project-discussion-comment-to-staff-catalan\";i:1;s:37:\"staff-added-as-project-member-catalan\";i:1;s:32:\"estimate-expiry-reminder-catalan\";i:1;s:32:\"proposal-expiry-reminder-catalan\";i:1;s:25:\"new-staff-created-catalan\";i:1;s:31:\"contact-forgot-password-catalan\";i:1;s:32:\"contact-password-reseted-catalan\";i:1;s:28:\"contact-set-password-catalan\";i:1;s:29:\"staff-forgot-password-catalan\";i:1;s:30:\"staff-password-reseted-catalan\";i:1;s:27:\"assigned-to-project-catalan\";i:1;s:41:\"task-added-attachment-to-contacts-catalan\";i:1;s:34:\"task-commented-to-contacts-catalan\";i:1;s:25:\"new-lead-assigned-catalan\";i:1;s:24:\"client-statement-catalan\";i:1;s:32:\"ticket-assigned-to-admin-catalan\";i:1;s:38:\"new-client-registered-to-admin-catalan\";i:1;s:38:\"new-web-to-lead-form-submitted-catalan\";i:1;s:33:\"two-factor-authentication-catalan\";i:1;s:36:\"project-finished-to-customer-catalan\";i:1;s:34:\"credit-note-send-to-client-catalan\";i:1;s:35:\"task-status-change-to-staff-catalan\";i:1;s:38:\"task-status-change-to-contacts-catalan\";i:1;s:28:\"reminder-email-staff-catalan\";i:1;s:34:\"contract-comment-to-client-catalan\";i:1;s:33:\"contract-comment-to-admin-catalan\";i:1;s:25:\"send-subscription-catalan\";i:1;s:35:\"subscription-payment-failed-catalan\";i:1;s:29:\"subscription-canceled-catalan\";i:1;s:38:\"subscription-payment-succeeded-catalan\";i:1;s:36:\"contract-expiration-to-staff-catalan\";i:1;s:28:\"gdpr-removal-request-catalan\";i:1;s:33:\"gdpr-removal-request-lead-catalan\";i:1;s:37:\"client-registration-confirmed-catalan\";i:1;s:32:\"contract-signed-to-staff-catalan\";i:1;s:36:\"customer-subscribed-to-staff-catalan\";i:1;s:34:\"contact-verification-email-catalan\";i:1;s:51:\"new-customer-profile-file-uploaded-to-staff-catalan\";i:1;s:35:\"event-notification-to-staff-catalan\";i:1;s:44:\"subscription-payment-requires-action-catalan\";i:1;s:26:\"invoice-due-notice-catalan\";i:1;s:43:\"estimate-request-submitted-to-staff-catalan\";i:1;s:33:\"estimate-request-assigned-catalan\";i:1;s:41:\"estimate-request-received-to-user-catalan\";i:1;s:33:\"non-billed-tasks-reminder-catalan\";i:1;s:31:\"invoices-batch-payments-catalan\";i:1;s:30:\"contract-sign-reminder-catalan\";i:1;s:24:\"new-client-created-greek\";i:1;s:28:\"invoice-send-to-client-greek\";i:1;s:29:\"new-ticket-opened-admin-greek\";i:1;s:18:\"ticket-reply-greek\";i:1;s:25:\"ticket-autoresponse-greek\";i:1;s:30:\"invoice-payment-recorded-greek\";i:1;s:28:\"invoice-overdue-notice-greek\";i:1;s:26:\"invoice-already-send-greek\";i:1;s:30:\"new-ticket-created-staff-greek\";i:1;s:29:\"estimate-send-to-client-greek\";i:1;s:27:\"ticket-reply-to-admin-greek\";i:1;s:27:\"estimate-already-send-greek\";i:1;s:25:\"contract-expiration-greek\";i:1;s:19:\"task-assigned-greek\";i:1;s:28:\"task-added-as-follower-greek\";i:1;s:20:\"task-commented-greek\";i:1;s:27:\"task-added-attachment-greek\";i:1;s:32:\"estimate-declined-to-staff-greek\";i:1;s:32:\"estimate-accepted-to-staff-greek\";i:1;s:30:\"proposal-client-accepted-greek\";i:1;s:31:\"proposal-send-to-customer-greek\";i:1;s:30:\"proposal-client-declined-greek\";i:1;s:31:\"proposal-client-thank-you-greek\";i:1;s:32:\"proposal-comment-to-client-greek\";i:1;s:31:\"proposal-comment-to-admin-greek\";i:1;s:36:\"estimate-thank-you-to-customer-greek\";i:1;s:32:\"task-deadline-notification-greek\";i:1;s:19:\"send-contract-greek\";i:1;s:39:\"invoice-payment-recorded-to-staff-greek\";i:1;s:23:\"auto-close-ticket-greek\";i:1;s:45:\"new-project-discussion-created-to-staff-greek\";i:1;s:48:\"new-project-discussion-created-to-customer-greek\";i:1;s:43:\"new-project-file-uploaded-to-customer-greek\";i:1;s:40:\"new-project-file-uploaded-to-staff-greek\";i:1;s:48:\"new-project-discussion-comment-to-customer-greek\";i:1;s:45:\"new-project-discussion-comment-to-staff-greek\";i:1;s:35:\"staff-added-as-project-member-greek\";i:1;s:30:\"estimate-expiry-reminder-greek\";i:1;s:30:\"proposal-expiry-reminder-greek\";i:1;s:23:\"new-staff-created-greek\";i:1;s:29:\"contact-forgot-password-greek\";i:1;s:30:\"contact-password-reseted-greek\";i:1;s:26:\"contact-set-password-greek\";i:1;s:27:\"staff-forgot-password-greek\";i:1;s:28:\"staff-password-reseted-greek\";i:1;s:25:\"assigned-to-project-greek\";i:1;s:39:\"task-added-attachment-to-contacts-greek\";i:1;s:32:\"task-commented-to-contacts-greek\";i:1;s:23:\"new-lead-assigned-greek\";i:1;s:22:\"client-statement-greek\";i:1;s:30:\"ticket-assigned-to-admin-greek\";i:1;s:36:\"new-client-registered-to-admin-greek\";i:1;s:36:\"new-web-to-lead-form-submitted-greek\";i:1;s:31:\"two-factor-authentication-greek\";i:1;s:34:\"project-finished-to-customer-greek\";i:1;s:32:\"credit-note-send-to-client-greek\";i:1;s:33:\"task-status-change-to-staff-greek\";i:1;s:36:\"task-status-change-to-contacts-greek\";i:1;s:26:\"reminder-email-staff-greek\";i:1;s:32:\"contract-comment-to-client-greek\";i:1;s:31:\"contract-comment-to-admin-greek\";i:1;s:23:\"send-subscription-greek\";i:1;s:33:\"subscription-payment-failed-greek\";i:1;s:27:\"subscription-canceled-greek\";i:1;s:36:\"subscription-payment-succeeded-greek\";i:1;s:34:\"contract-expiration-to-staff-greek\";i:1;s:26:\"gdpr-removal-request-greek\";i:1;s:31:\"gdpr-removal-request-lead-greek\";i:1;s:35:\"client-registration-confirmed-greek\";i:1;s:30:\"contract-signed-to-staff-greek\";i:1;s:34:\"customer-subscribed-to-staff-greek\";i:1;s:32:\"contact-verification-email-greek\";i:1;s:49:\"new-customer-profile-file-uploaded-to-staff-greek\";i:1;s:33:\"event-notification-to-staff-greek\";i:1;s:42:\"subscription-payment-requires-action-greek\";i:1;s:24:\"invoice-due-notice-greek\";i:1;s:41:\"estimate-request-submitted-to-staff-greek\";i:1;s:31:\"estimate-request-assigned-greek\";i:1;s:39:\"estimate-request-received-to-user-greek\";i:1;s:31:\"non-billed-tasks-reminder-greek\";i:1;s:29:\"invoices-batch-payments-greek\";i:1;s:28:\"contract-sign-reminder-greek\";i:1;s:24:\"new-client-created-czech\";i:1;s:28:\"invoice-send-to-client-czech\";i:1;s:29:\"new-ticket-opened-admin-czech\";i:1;s:18:\"ticket-reply-czech\";i:1;s:25:\"ticket-autoresponse-czech\";i:1;s:30:\"invoice-payment-recorded-czech\";i:1;s:28:\"invoice-overdue-notice-czech\";i:1;s:26:\"invoice-already-send-czech\";i:1;s:30:\"new-ticket-created-staff-czech\";i:1;s:29:\"estimate-send-to-client-czech\";i:1;s:27:\"ticket-reply-to-admin-czech\";i:1;s:27:\"estimate-already-send-czech\";i:1;s:25:\"contract-expiration-czech\";i:1;s:19:\"task-assigned-czech\";i:1;s:28:\"task-added-as-follower-czech\";i:1;s:20:\"task-commented-czech\";i:1;s:27:\"task-added-attachment-czech\";i:1;s:32:\"estimate-declined-to-staff-czech\";i:1;s:32:\"estimate-accepted-to-staff-czech\";i:1;s:30:\"proposal-client-accepted-czech\";i:1;s:31:\"proposal-send-to-customer-czech\";i:1;s:30:\"proposal-client-declined-czech\";i:1;s:31:\"proposal-client-thank-you-czech\";i:1;s:32:\"proposal-comment-to-client-czech\";i:1;s:31:\"proposal-comment-to-admin-czech\";i:1;s:36:\"estimate-thank-you-to-customer-czech\";i:1;s:32:\"task-deadline-notification-czech\";i:1;s:19:\"send-contract-czech\";i:1;s:39:\"invoice-payment-recorded-to-staff-czech\";i:1;s:23:\"auto-close-ticket-czech\";i:1;s:45:\"new-project-discussion-created-to-staff-czech\";i:1;s:48:\"new-project-discussion-created-to-customer-czech\";i:1;s:43:\"new-project-file-uploaded-to-customer-czech\";i:1;s:40:\"new-project-file-uploaded-to-staff-czech\";i:1;s:48:\"new-project-discussion-comment-to-customer-czech\";i:1;s:45:\"new-project-discussion-comment-to-staff-czech\";i:1;s:35:\"staff-added-as-project-member-czech\";i:1;s:30:\"estimate-expiry-reminder-czech\";i:1;s:30:\"proposal-expiry-reminder-czech\";i:1;s:23:\"new-staff-created-czech\";i:1;s:29:\"contact-forgot-password-czech\";i:1;s:30:\"contact-password-reseted-czech\";i:1;s:26:\"contact-set-password-czech\";i:1;s:27:\"staff-forgot-password-czech\";i:1;s:28:\"staff-password-reseted-czech\";i:1;s:25:\"assigned-to-project-czech\";i:1;s:39:\"task-added-attachment-to-contacts-czech\";i:1;s:32:\"task-commented-to-contacts-czech\";i:1;s:23:\"new-lead-assigned-czech\";i:1;s:22:\"client-statement-czech\";i:1;s:30:\"ticket-assigned-to-admin-czech\";i:1;s:36:\"new-client-registered-to-admin-czech\";i:1;s:36:\"new-web-to-lead-form-submitted-czech\";i:1;s:31:\"two-factor-authentication-czech\";i:1;s:34:\"project-finished-to-customer-czech\";i:1;s:32:\"credit-note-send-to-client-czech\";i:1;s:33:\"task-status-change-to-staff-czech\";i:1;s:36:\"task-status-change-to-contacts-czech\";i:1;s:26:\"reminder-email-staff-czech\";i:1;s:32:\"contract-comment-to-client-czech\";i:1;s:31:\"contract-comment-to-admin-czech\";i:1;s:23:\"send-subscription-czech\";i:1;s:33:\"subscription-payment-failed-czech\";i:1;s:27:\"subscription-canceled-czech\";i:1;s:36:\"subscription-payment-succeeded-czech\";i:1;s:34:\"contract-expiration-to-staff-czech\";i:1;s:26:\"gdpr-removal-request-czech\";i:1;s:31:\"gdpr-removal-request-lead-czech\";i:1;s:35:\"client-registration-confirmed-czech\";i:1;s:30:\"contract-signed-to-staff-czech\";i:1;s:34:\"customer-subscribed-to-staff-czech\";i:1;s:32:\"contact-verification-email-czech\";i:1;s:49:\"new-customer-profile-file-uploaded-to-staff-czech\";i:1;s:33:\"event-notification-to-staff-czech\";i:1;s:42:\"subscription-payment-requires-action-czech\";i:1;s:24:\"invoice-due-notice-czech\";i:1;s:41:\"estimate-request-submitted-to-staff-czech\";i:1;s:31:\"estimate-request-assigned-czech\";i:1;s:39:\"estimate-request-received-to-user-czech\";i:1;s:31:\"non-billed-tasks-reminder-czech\";i:1;s:29:\"invoices-batch-payments-czech\";i:1;s:28:\"contract-sign-reminder-czech\";i:1;s:26:\"new-client-created-chinese\";i:1;s:30:\"invoice-send-to-client-chinese\";i:1;s:31:\"new-ticket-opened-admin-chinese\";i:1;s:20:\"ticket-reply-chinese\";i:1;s:27:\"ticket-autoresponse-chinese\";i:1;s:32:\"invoice-payment-recorded-chinese\";i:1;s:30:\"invoice-overdue-notice-chinese\";i:1;s:28:\"invoice-already-send-chinese\";i:1;s:32:\"new-ticket-created-staff-chinese\";i:1;s:31:\"estimate-send-to-client-chinese\";i:1;s:29:\"ticket-reply-to-admin-chinese\";i:1;s:29:\"estimate-already-send-chinese\";i:1;s:27:\"contract-expiration-chinese\";i:1;s:21:\"task-assigned-chinese\";i:1;s:30:\"task-added-as-follower-chinese\";i:1;s:22:\"task-commented-chinese\";i:1;s:29:\"task-added-attachment-chinese\";i:1;s:34:\"estimate-declined-to-staff-chinese\";i:1;s:34:\"estimate-accepted-to-staff-chinese\";i:1;s:32:\"proposal-client-accepted-chinese\";i:1;s:33:\"proposal-send-to-customer-chinese\";i:1;s:32:\"proposal-client-declined-chinese\";i:1;s:33:\"proposal-client-thank-you-chinese\";i:1;s:34:\"proposal-comment-to-client-chinese\";i:1;s:33:\"proposal-comment-to-admin-chinese\";i:1;s:38:\"estimate-thank-you-to-customer-chinese\";i:1;s:34:\"task-deadline-notification-chinese\";i:1;s:21:\"send-contract-chinese\";i:1;s:41:\"invoice-payment-recorded-to-staff-chinese\";i:1;s:25:\"auto-close-ticket-chinese\";i:1;s:47:\"new-project-discussion-created-to-staff-chinese\";i:1;s:50:\"new-project-discussion-created-to-customer-chinese\";i:1;s:45:\"new-project-file-uploaded-to-customer-chinese\";i:1;s:42:\"new-project-file-uploaded-to-staff-chinese\";i:1;s:50:\"new-project-discussion-comment-to-customer-chinese\";i:1;s:47:\"new-project-discussion-comment-to-staff-chinese\";i:1;s:37:\"staff-added-as-project-member-chinese\";i:1;s:32:\"estimate-expiry-reminder-chinese\";i:1;s:32:\"proposal-expiry-reminder-chinese\";i:1;s:25:\"new-staff-created-chinese\";i:1;s:31:\"contact-forgot-password-chinese\";i:1;s:32:\"contact-password-reseted-chinese\";i:1;s:28:\"contact-set-password-chinese\";i:1;s:29:\"staff-forgot-password-chinese\";i:1;s:30:\"staff-password-reseted-chinese\";i:1;s:27:\"assigned-to-project-chinese\";i:1;s:41:\"task-added-attachment-to-contacts-chinese\";i:1;s:34:\"task-commented-to-contacts-chinese\";i:1;s:25:\"new-lead-assigned-chinese\";i:1;s:24:\"client-statement-chinese\";i:1;s:32:\"ticket-assigned-to-admin-chinese\";i:1;s:38:\"new-client-registered-to-admin-chinese\";i:1;s:38:\"new-web-to-lead-form-submitted-chinese\";i:1;s:33:\"two-factor-authentication-chinese\";i:1;s:36:\"project-finished-to-customer-chinese\";i:1;s:34:\"credit-note-send-to-client-chinese\";i:1;s:35:\"task-status-change-to-staff-chinese\";i:1;s:38:\"task-status-change-to-contacts-chinese\";i:1;s:28:\"reminder-email-staff-chinese\";i:1;s:34:\"contract-comment-to-client-chinese\";i:1;s:33:\"contract-comment-to-admin-chinese\";i:1;s:25:\"send-subscription-chinese\";i:1;s:35:\"subscription-payment-failed-chinese\";i:1;s:29:\"subscription-canceled-chinese\";i:1;s:38:\"subscription-payment-succeeded-chinese\";i:1;s:36:\"contract-expiration-to-staff-chinese\";i:1;s:28:\"gdpr-removal-request-chinese\";i:1;s:33:\"gdpr-removal-request-lead-chinese\";i:1;s:37:\"client-registration-confirmed-chinese\";i:1;s:32:\"contract-signed-to-staff-chinese\";i:1;s:36:\"customer-subscribed-to-staff-chinese\";i:1;s:34:\"contact-verification-email-chinese\";i:1;s:51:\"new-customer-profile-file-uploaded-to-staff-chinese\";i:1;s:35:\"event-notification-to-staff-chinese\";i:1;s:44:\"subscription-payment-requires-action-chinese\";i:1;s:26:\"invoice-due-notice-chinese\";i:1;s:43:\"estimate-request-submitted-to-staff-chinese\";i:1;s:33:\"estimate-request-assigned-chinese\";i:1;s:41:\"estimate-request-received-to-user-chinese\";i:1;s:33:\"non-billed-tasks-reminder-chinese\";i:1;s:31:\"invoices-batch-payments-chinese\";i:1;s:30:\"contract-sign-reminder-chinese\";i:1;s:26:\"new-client-created-spanish\";i:1;s:30:\"invoice-send-to-client-spanish\";i:1;s:31:\"new-ticket-opened-admin-spanish\";i:1;s:20:\"ticket-reply-spanish\";i:1;s:27:\"ticket-autoresponse-spanish\";i:1;s:32:\"invoice-payment-recorded-spanish\";i:1;s:30:\"invoice-overdue-notice-spanish\";i:1;s:28:\"invoice-already-send-spanish\";i:1;s:32:\"new-ticket-created-staff-spanish\";i:1;s:31:\"estimate-send-to-client-spanish\";i:1;s:29:\"ticket-reply-to-admin-spanish\";i:1;s:29:\"estimate-already-send-spanish\";i:1;s:27:\"contract-expiration-spanish\";i:1;s:21:\"task-assigned-spanish\";i:1;s:30:\"task-added-as-follower-spanish\";i:1;s:22:\"task-commented-spanish\";i:1;s:29:\"task-added-attachment-spanish\";i:1;s:34:\"estimate-declined-to-staff-spanish\";i:1;s:34:\"estimate-accepted-to-staff-spanish\";i:1;s:32:\"proposal-client-accepted-spanish\";i:1;s:33:\"proposal-send-to-customer-spanish\";i:1;s:32:\"proposal-client-declined-spanish\";i:1;s:33:\"proposal-client-thank-you-spanish\";i:1;s:34:\"proposal-comment-to-client-spanish\";i:1;s:33:\"proposal-comment-to-admin-spanish\";i:1;s:38:\"estimate-thank-you-to-customer-spanish\";i:1;s:34:\"task-deadline-notification-spanish\";i:1;s:21:\"send-contract-spanish\";i:1;s:41:\"invoice-payment-recorded-to-staff-spanish\";i:1;s:25:\"auto-close-ticket-spanish\";i:1;s:47:\"new-project-discussion-created-to-staff-spanish\";i:1;s:50:\"new-project-discussion-created-to-customer-spanish\";i:1;s:45:\"new-project-file-uploaded-to-customer-spanish\";i:1;s:42:\"new-project-file-uploaded-to-staff-spanish\";i:1;s:50:\"new-project-discussion-comment-to-customer-spanish\";i:1;s:47:\"new-project-discussion-comment-to-staff-spanish\";i:1;s:37:\"staff-added-as-project-member-spanish\";i:1;s:32:\"estimate-expiry-reminder-spanish\";i:1;s:32:\"proposal-expiry-reminder-spanish\";i:1;s:25:\"new-staff-created-spanish\";i:1;s:31:\"contact-forgot-password-spanish\";i:1;s:32:\"contact-password-reseted-spanish\";i:1;s:28:\"contact-set-password-spanish\";i:1;s:29:\"staff-forgot-password-spanish\";i:1;s:30:\"staff-password-reseted-spanish\";i:1;s:27:\"assigned-to-project-spanish\";i:1;s:41:\"task-added-attachment-to-contacts-spanish\";i:1;s:34:\"task-commented-to-contacts-spanish\";i:1;s:25:\"new-lead-assigned-spanish\";i:1;s:24:\"client-statement-spanish\";i:1;s:32:\"ticket-assigned-to-admin-spanish\";i:1;s:38:\"new-client-registered-to-admin-spanish\";i:1;s:38:\"new-web-to-lead-form-submitted-spanish\";i:1;s:33:\"two-factor-authentication-spanish\";i:1;s:36:\"project-finished-to-customer-spanish\";i:1;s:34:\"credit-note-send-to-client-spanish\";i:1;s:35:\"task-status-change-to-staff-spanish\";i:1;s:38:\"task-status-change-to-contacts-spanish\";i:1;s:28:\"reminder-email-staff-spanish\";i:1;s:34:\"contract-comment-to-client-spanish\";i:1;s:33:\"contract-comment-to-admin-spanish\";i:1;s:25:\"send-subscription-spanish\";i:1;s:35:\"subscription-payment-failed-spanish\";i:1;s:29:\"subscription-canceled-spanish\";i:1;s:38:\"subscription-payment-succeeded-spanish\";i:1;s:36:\"contract-expiration-to-staff-spanish\";i:1;s:28:\"gdpr-removal-request-spanish\";i:1;s:33:\"gdpr-removal-request-lead-spanish\";i:1;s:37:\"client-registration-confirmed-spanish\";i:1;s:32:\"contract-signed-to-staff-spanish\";i:1;s:36:\"customer-subscribed-to-staff-spanish\";i:1;s:34:\"contact-verification-email-spanish\";i:1;s:51:\"new-customer-profile-file-uploaded-to-staff-spanish\";i:1;s:35:\"event-notification-to-staff-spanish\";i:1;s:44:\"subscription-payment-requires-action-spanish\";i:1;s:26:\"invoice-due-notice-spanish\";i:1;s:43:\"estimate-request-submitted-to-staff-spanish\";i:1;s:33:\"estimate-request-assigned-spanish\";i:1;s:41:\"estimate-request-received-to-user-spanish\";i:1;s:33:\"non-billed-tasks-reminder-spanish\";i:1;s:31:\"invoices-batch-payments-spanish\";i:1;s:30:\"contract-sign-reminder-spanish\";i:1;s:29:\"new-client-created-portuguese\";i:1;s:33:\"invoice-send-to-client-portuguese\";i:1;s:34:\"new-ticket-opened-admin-portuguese\";i:1;s:23:\"ticket-reply-portuguese\";i:1;s:30:\"ticket-autoresponse-portuguese\";i:1;s:35:\"invoice-payment-recorded-portuguese\";i:1;s:33:\"invoice-overdue-notice-portuguese\";i:1;s:31:\"invoice-already-send-portuguese\";i:1;s:35:\"new-ticket-created-staff-portuguese\";i:1;s:34:\"estimate-send-to-client-portuguese\";i:1;s:32:\"ticket-reply-to-admin-portuguese\";i:1;s:32:\"estimate-already-send-portuguese\";i:1;s:30:\"contract-expiration-portuguese\";i:1;s:24:\"task-assigned-portuguese\";i:1;s:33:\"task-added-as-follower-portuguese\";i:1;s:25:\"task-commented-portuguese\";i:1;s:32:\"task-added-attachment-portuguese\";i:1;s:37:\"estimate-declined-to-staff-portuguese\";i:1;s:37:\"estimate-accepted-to-staff-portuguese\";i:1;s:35:\"proposal-client-accepted-portuguese\";i:1;s:36:\"proposal-send-to-customer-portuguese\";i:1;s:35:\"proposal-client-declined-portuguese\";i:1;s:36:\"proposal-client-thank-you-portuguese\";i:1;s:37:\"proposal-comment-to-client-portuguese\";i:1;s:36:\"proposal-comment-to-admin-portuguese\";i:1;s:41:\"estimate-thank-you-to-customer-portuguese\";i:1;s:37:\"task-deadline-notification-portuguese\";i:1;s:24:\"send-contract-portuguese\";i:1;s:44:\"invoice-payment-recorded-to-staff-portuguese\";i:1;s:28:\"auto-close-ticket-portuguese\";i:1;s:50:\"new-project-discussion-created-to-staff-portuguese\";i:1;s:53:\"new-project-discussion-created-to-customer-portuguese\";i:1;s:48:\"new-project-file-uploaded-to-customer-portuguese\";i:1;s:45:\"new-project-file-uploaded-to-staff-portuguese\";i:1;s:53:\"new-project-discussion-comment-to-customer-portuguese\";i:1;s:50:\"new-project-discussion-comment-to-staff-portuguese\";i:1;s:40:\"staff-added-as-project-member-portuguese\";i:1;s:35:\"estimate-expiry-reminder-portuguese\";i:1;s:35:\"proposal-expiry-reminder-portuguese\";i:1;s:28:\"new-staff-created-portuguese\";i:1;s:34:\"contact-forgot-password-portuguese\";i:1;s:35:\"contact-password-reseted-portuguese\";i:1;s:31:\"contact-set-password-portuguese\";i:1;s:32:\"staff-forgot-password-portuguese\";i:1;s:33:\"staff-password-reseted-portuguese\";i:1;s:30:\"assigned-to-project-portuguese\";i:1;s:44:\"task-added-attachment-to-contacts-portuguese\";i:1;s:37:\"task-commented-to-contacts-portuguese\";i:1;s:28:\"new-lead-assigned-portuguese\";i:1;s:27:\"client-statement-portuguese\";i:1;s:35:\"ticket-assigned-to-admin-portuguese\";i:1;s:41:\"new-client-registered-to-admin-portuguese\";i:1;s:41:\"new-web-to-lead-form-submitted-portuguese\";i:1;s:36:\"two-factor-authentication-portuguese\";i:1;s:39:\"project-finished-to-customer-portuguese\";i:1;s:37:\"credit-note-send-to-client-portuguese\";i:1;s:38:\"task-status-change-to-staff-portuguese\";i:1;s:41:\"task-status-change-to-contacts-portuguese\";i:1;s:31:\"reminder-email-staff-portuguese\";i:1;s:37:\"contract-comment-to-client-portuguese\";i:1;s:36:\"contract-comment-to-admin-portuguese\";i:1;s:28:\"send-subscription-portuguese\";i:1;s:38:\"subscription-payment-failed-portuguese\";i:1;s:32:\"subscription-canceled-portuguese\";i:1;s:41:\"subscription-payment-succeeded-portuguese\";i:1;s:39:\"contract-expiration-to-staff-portuguese\";i:1;s:31:\"gdpr-removal-request-portuguese\";i:1;s:36:\"gdpr-removal-request-lead-portuguese\";i:1;s:40:\"client-registration-confirmed-portuguese\";i:1;s:35:\"contract-signed-to-staff-portuguese\";i:1;s:39:\"customer-subscribed-to-staff-portuguese\";i:1;s:37:\"contact-verification-email-portuguese\";i:1;s:54:\"new-customer-profile-file-uploaded-to-staff-portuguese\";i:1;s:38:\"event-notification-to-staff-portuguese\";i:1;s:47:\"subscription-payment-requires-action-portuguese\";i:1;s:29:\"invoice-due-notice-portuguese\";i:1;s:46:\"estimate-request-submitted-to-staff-portuguese\";i:1;s:36:\"estimate-request-assigned-portuguese\";i:1;s:44:\"estimate-request-received-to-user-portuguese\";i:1;s:36:\"non-billed-tasks-reminder-portuguese\";i:1;s:34:\"invoices-batch-payments-portuguese\";i:1;s:33:\"contract-sign-reminder-portuguese\";i:1;s:26:\"new-client-created-finnish\";i:1;s:30:\"invoice-send-to-client-finnish\";i:1;s:31:\"new-ticket-opened-admin-finnish\";i:1;s:20:\"ticket-reply-finnish\";i:1;s:27:\"ticket-autoresponse-finnish\";i:1;s:32:\"invoice-payment-recorded-finnish\";i:1;s:30:\"invoice-overdue-notice-finnish\";i:1;s:28:\"invoice-already-send-finnish\";i:1;s:32:\"new-ticket-created-staff-finnish\";i:1;s:31:\"estimate-send-to-client-finnish\";i:1;s:29:\"ticket-reply-to-admin-finnish\";i:1;s:29:\"estimate-already-send-finnish\";i:1;s:27:\"contract-expiration-finnish\";i:1;s:21:\"task-assigned-finnish\";i:1;s:30:\"task-added-as-follower-finnish\";i:1;s:22:\"task-commented-finnish\";i:1;s:29:\"task-added-attachment-finnish\";i:1;s:34:\"estimate-declined-to-staff-finnish\";i:1;s:34:\"estimate-accepted-to-staff-finnish\";i:1;s:32:\"proposal-client-accepted-finnish\";i:1;s:33:\"proposal-send-to-customer-finnish\";i:1;s:32:\"proposal-client-declined-finnish\";i:1;s:33:\"proposal-client-thank-you-finnish\";i:1;s:34:\"proposal-comment-to-client-finnish\";i:1;s:33:\"proposal-comment-to-admin-finnish\";i:1;s:38:\"estimate-thank-you-to-customer-finnish\";i:1;s:34:\"task-deadline-notification-finnish\";i:1;s:21:\"send-contract-finnish\";i:1;s:41:\"invoice-payment-recorded-to-staff-finnish\";i:1;s:25:\"auto-close-ticket-finnish\";i:1;s:47:\"new-project-discussion-created-to-staff-finnish\";i:1;s:50:\"new-project-discussion-created-to-customer-finnish\";i:1;s:45:\"new-project-file-uploaded-to-customer-finnish\";i:1;s:42:\"new-project-file-uploaded-to-staff-finnish\";i:1;s:50:\"new-project-discussion-comment-to-customer-finnish\";i:1;s:47:\"new-project-discussion-comment-to-staff-finnish\";i:1;s:37:\"staff-added-as-project-member-finnish\";i:1;s:32:\"estimate-expiry-reminder-finnish\";i:1;s:32:\"proposal-expiry-reminder-finnish\";i:1;s:25:\"new-staff-created-finnish\";i:1;s:31:\"contact-forgot-password-finnish\";i:1;s:32:\"contact-password-reseted-finnish\";i:1;s:28:\"contact-set-password-finnish\";i:1;s:29:\"staff-forgot-password-finnish\";i:1;s:30:\"staff-password-reseted-finnish\";i:1;s:27:\"assigned-to-project-finnish\";i:1;s:41:\"task-added-attachment-to-contacts-finnish\";i:1;s:34:\"task-commented-to-contacts-finnish\";i:1;s:25:\"new-lead-assigned-finnish\";i:1;s:24:\"client-statement-finnish\";i:1;s:32:\"ticket-assigned-to-admin-finnish\";i:1;s:38:\"new-client-registered-to-admin-finnish\";i:1;s:38:\"new-web-to-lead-form-submitted-finnish\";i:1;s:33:\"two-factor-authentication-finnish\";i:1;s:36:\"project-finished-to-customer-finnish\";i:1;s:34:\"credit-note-send-to-client-finnish\";i:1;s:35:\"task-status-change-to-staff-finnish\";i:1;s:38:\"task-status-change-to-contacts-finnish\";i:1;s:28:\"reminder-email-staff-finnish\";i:1;s:34:\"contract-comment-to-client-finnish\";i:1;s:33:\"contract-comment-to-admin-finnish\";i:1;s:25:\"send-subscription-finnish\";i:1;s:35:\"subscription-payment-failed-finnish\";i:1;s:29:\"subscription-canceled-finnish\";i:1;s:38:\"subscription-payment-succeeded-finnish\";i:1;s:36:\"contract-expiration-to-staff-finnish\";i:1;s:28:\"gdpr-removal-request-finnish\";i:1;s:33:\"gdpr-removal-request-lead-finnish\";i:1;s:37:\"client-registration-confirmed-finnish\";i:1;s:32:\"contract-signed-to-staff-finnish\";i:1;s:36:\"customer-subscribed-to-staff-finnish\";i:1;s:34:\"contact-verification-email-finnish\";i:1;s:51:\"new-customer-profile-file-uploaded-to-staff-finnish\";i:1;s:35:\"event-notification-to-staff-finnish\";i:1;s:44:\"subscription-payment-requires-action-finnish\";i:1;s:26:\"invoice-due-notice-finnish\";i:1;s:43:\"estimate-request-submitted-to-staff-finnish\";i:1;s:33:\"estimate-request-assigned-finnish\";i:1;s:41:\"estimate-request-received-to-user-finnish\";i:1;s:33:\"non-billed-tasks-reminder-finnish\";i:1;s:31:\"invoices-batch-payments-finnish\";i:1;s:30:\"contract-sign-reminder-finnish\";i:1;s:26:\"new-client-created-italian\";i:1;s:30:\"invoice-send-to-client-italian\";i:1;s:31:\"new-ticket-opened-admin-italian\";i:1;s:20:\"ticket-reply-italian\";i:1;s:27:\"ticket-autoresponse-italian\";i:1;s:32:\"invoice-payment-recorded-italian\";i:1;s:30:\"invoice-overdue-notice-italian\";i:1;s:28:\"invoice-already-send-italian\";i:1;s:32:\"new-ticket-created-staff-italian\";i:1;s:31:\"estimate-send-to-client-italian\";i:1;s:29:\"ticket-reply-to-admin-italian\";i:1;s:29:\"estimate-already-send-italian\";i:1;s:27:\"contract-expiration-italian\";i:1;s:21:\"task-assigned-italian\";i:1;s:30:\"task-added-as-follower-italian\";i:1;s:22:\"task-commented-italian\";i:1;s:29:\"task-added-attachment-italian\";i:1;s:34:\"estimate-declined-to-staff-italian\";i:1;s:34:\"estimate-accepted-to-staff-italian\";i:1;s:32:\"proposal-client-accepted-italian\";i:1;s:33:\"proposal-send-to-customer-italian\";i:1;s:32:\"proposal-client-declined-italian\";i:1;s:33:\"proposal-client-thank-you-italian\";i:1;s:34:\"proposal-comment-to-client-italian\";i:1;s:33:\"proposal-comment-to-admin-italian\";i:1;s:38:\"estimate-thank-you-to-customer-italian\";i:1;s:34:\"task-deadline-notification-italian\";i:1;s:21:\"send-contract-italian\";i:1;s:41:\"invoice-payment-recorded-to-staff-italian\";i:1;s:25:\"auto-close-ticket-italian\";i:1;s:47:\"new-project-discussion-created-to-staff-italian\";i:1;s:50:\"new-project-discussion-created-to-customer-italian\";i:1;s:45:\"new-project-file-uploaded-to-customer-italian\";i:1;s:42:\"new-project-file-uploaded-to-staff-italian\";i:1;s:50:\"new-project-discussion-comment-to-customer-italian\";i:1;s:47:\"new-project-discussion-comment-to-staff-italian\";i:1;s:37:\"staff-added-as-project-member-italian\";i:1;s:32:\"estimate-expiry-reminder-italian\";i:1;s:32:\"proposal-expiry-reminder-italian\";i:1;s:25:\"new-staff-created-italian\";i:1;s:31:\"contact-forgot-password-italian\";i:1;s:32:\"contact-password-reseted-italian\";i:1;s:28:\"contact-set-password-italian\";i:1;s:29:\"staff-forgot-password-italian\";i:1;s:30:\"staff-password-reseted-italian\";i:1;s:27:\"assigned-to-project-italian\";i:1;s:41:\"task-added-attachment-to-contacts-italian\";i:1;s:34:\"task-commented-to-contacts-italian\";i:1;s:25:\"new-lead-assigned-italian\";i:1;s:24:\"client-statement-italian\";i:1;s:32:\"ticket-assigned-to-admin-italian\";i:1;s:38:\"new-client-registered-to-admin-italian\";i:1;s:38:\"new-web-to-lead-form-submitted-italian\";i:1;s:33:\"two-factor-authentication-italian\";i:1;s:36:\"project-finished-to-customer-italian\";i:1;s:34:\"credit-note-send-to-client-italian\";i:1;s:35:\"task-status-change-to-staff-italian\";i:1;s:38:\"task-status-change-to-contacts-italian\";i:1;s:28:\"reminder-email-staff-italian\";i:1;s:34:\"contract-comment-to-client-italian\";i:1;s:33:\"contract-comment-to-admin-italian\";i:1;s:25:\"send-subscription-italian\";i:1;s:35:\"subscription-payment-failed-italian\";i:1;s:29:\"subscription-canceled-italian\";i:1;s:38:\"subscription-payment-succeeded-italian\";i:1;s:36:\"contract-expiration-to-staff-italian\";i:1;s:28:\"gdpr-removal-request-italian\";i:1;s:33:\"gdpr-removal-request-lead-italian\";i:1;s:37:\"client-registration-confirmed-italian\";i:1;s:32:\"contract-signed-to-staff-italian\";i:1;s:36:\"customer-subscribed-to-staff-italian\";i:1;s:34:\"contact-verification-email-italian\";i:1;s:51:\"new-customer-profile-file-uploaded-to-staff-italian\";i:1;s:35:\"event-notification-to-staff-italian\";i:1;s:44:\"subscription-payment-requires-action-italian\";i:1;s:26:\"invoice-due-notice-italian\";i:1;s:43:\"estimate-request-submitted-to-staff-italian\";i:1;s:33:\"estimate-request-assigned-italian\";i:1;s:41:\"estimate-request-received-to-user-italian\";i:1;s:33:\"non-billed-tasks-reminder-italian\";i:1;s:31:\"invoices-batch-payments-italian\";i:1;s:30:\"contract-sign-reminder-italian\";i:1;s:28:\"new-client-created-indonesia\";i:1;s:32:\"invoice-send-to-client-indonesia\";i:1;s:33:\"new-ticket-opened-admin-indonesia\";i:1;s:22:\"ticket-reply-indonesia\";i:1;s:29:\"ticket-autoresponse-indonesia\";i:1;s:34:\"invoice-payment-recorded-indonesia\";i:1;s:32:\"invoice-overdue-notice-indonesia\";i:1;s:30:\"invoice-already-send-indonesia\";i:1;s:34:\"new-ticket-created-staff-indonesia\";i:1;s:33:\"estimate-send-to-client-indonesia\";i:1;s:31:\"ticket-reply-to-admin-indonesia\";i:1;s:31:\"estimate-already-send-indonesia\";i:1;s:29:\"contract-expiration-indonesia\";i:1;s:23:\"task-assigned-indonesia\";i:1;s:32:\"task-added-as-follower-indonesia\";i:1;s:24:\"task-commented-indonesia\";i:1;s:31:\"task-added-attachment-indonesia\";i:1;s:36:\"estimate-declined-to-staff-indonesia\";i:1;s:36:\"estimate-accepted-to-staff-indonesia\";i:1;s:34:\"proposal-client-accepted-indonesia\";i:1;s:35:\"proposal-send-to-customer-indonesia\";i:1;s:34:\"proposal-client-declined-indonesia\";i:1;s:35:\"proposal-client-thank-you-indonesia\";i:1;s:36:\"proposal-comment-to-client-indonesia\";i:1;s:35:\"proposal-comment-to-admin-indonesia\";i:1;s:40:\"estimate-thank-you-to-customer-indonesia\";i:1;s:36:\"task-deadline-notification-indonesia\";i:1;s:23:\"send-contract-indonesia\";i:1;s:43:\"invoice-payment-recorded-to-staff-indonesia\";i:1;s:27:\"auto-close-ticket-indonesia\";i:1;s:49:\"new-project-discussion-created-to-staff-indonesia\";i:1;s:52:\"new-project-discussion-created-to-customer-indonesia\";i:1;s:47:\"new-project-file-uploaded-to-customer-indonesia\";i:1;s:44:\"new-project-file-uploaded-to-staff-indonesia\";i:1;s:52:\"new-project-discussion-comment-to-customer-indonesia\";i:1;s:49:\"new-project-discussion-comment-to-staff-indonesia\";i:1;s:39:\"staff-added-as-project-member-indonesia\";i:1;s:34:\"estimate-expiry-reminder-indonesia\";i:1;s:34:\"proposal-expiry-reminder-indonesia\";i:1;s:27:\"new-staff-created-indonesia\";i:1;s:33:\"contact-forgot-password-indonesia\";i:1;s:34:\"contact-password-reseted-indonesia\";i:1;s:30:\"contact-set-password-indonesia\";i:1;s:31:\"staff-forgot-password-indonesia\";i:1;s:32:\"staff-password-reseted-indonesia\";i:1;s:29:\"assigned-to-project-indonesia\";i:1;s:43:\"task-added-attachment-to-contacts-indonesia\";i:1;s:36:\"task-commented-to-contacts-indonesia\";i:1;s:27:\"new-lead-assigned-indonesia\";i:1;s:26:\"client-statement-indonesia\";i:1;s:34:\"ticket-assigned-to-admin-indonesia\";i:1;s:40:\"new-client-registered-to-admin-indonesia\";i:1;s:40:\"new-web-to-lead-form-submitted-indonesia\";i:1;s:35:\"two-factor-authentication-indonesia\";i:1;s:38:\"project-finished-to-customer-indonesia\";i:1;s:36:\"credit-note-send-to-client-indonesia\";i:1;s:37:\"task-status-change-to-staff-indonesia\";i:1;s:40:\"task-status-change-to-contacts-indonesia\";i:1;s:30:\"reminder-email-staff-indonesia\";i:1;s:36:\"contract-comment-to-client-indonesia\";i:1;s:35:\"contract-comment-to-admin-indonesia\";i:1;s:27:\"send-subscription-indonesia\";i:1;s:37:\"subscription-payment-failed-indonesia\";i:1;s:31:\"subscription-canceled-indonesia\";i:1;s:40:\"subscription-payment-succeeded-indonesia\";i:1;s:38:\"contract-expiration-to-staff-indonesia\";i:1;s:30:\"gdpr-removal-request-indonesia\";i:1;s:35:\"gdpr-removal-request-lead-indonesia\";i:1;s:39:\"client-registration-confirmed-indonesia\";i:1;s:34:\"contract-signed-to-staff-indonesia\";i:1;s:38:\"customer-subscribed-to-staff-indonesia\";i:1;s:36:\"contact-verification-email-indonesia\";i:1;s:53:\"new-customer-profile-file-uploaded-to-staff-indonesia\";i:1;s:37:\"event-notification-to-staff-indonesia\";i:1;s:46:\"subscription-payment-requires-action-indonesia\";i:1;s:28:\"invoice-due-notice-indonesia\";i:1;s:45:\"estimate-request-submitted-to-staff-indonesia\";i:1;s:35:\"estimate-request-assigned-indonesia\";i:1;s:43:\"estimate-request-received-to-user-indonesia\";i:1;s:35:\"non-billed-tasks-reminder-indonesia\";i:1;s:33:\"invoices-batch-payments-indonesia\";i:1;s:32:\"contract-sign-reminder-indonesia\";i:1;s:32:\"new-client-created-portuguese_br\";i:1;s:36:\"invoice-send-to-client-portuguese_br\";i:1;s:37:\"new-ticket-opened-admin-portuguese_br\";i:1;s:26:\"ticket-reply-portuguese_br\";i:1;s:33:\"ticket-autoresponse-portuguese_br\";i:1;s:38:\"invoice-payment-recorded-portuguese_br\";i:1;s:36:\"invoice-overdue-notice-portuguese_br\";i:1;s:34:\"invoice-already-send-portuguese_br\";i:1;s:38:\"new-ticket-created-staff-portuguese_br\";i:1;s:37:\"estimate-send-to-client-portuguese_br\";i:1;s:35:\"ticket-reply-to-admin-portuguese_br\";i:1;s:35:\"estimate-already-send-portuguese_br\";i:1;s:33:\"contract-expiration-portuguese_br\";i:1;s:27:\"task-assigned-portuguese_br\";i:1;s:36:\"task-added-as-follower-portuguese_br\";i:1;s:28:\"task-commented-portuguese_br\";i:1;s:35:\"task-added-attachment-portuguese_br\";i:1;s:40:\"estimate-declined-to-staff-portuguese_br\";i:1;s:40:\"estimate-accepted-to-staff-portuguese_br\";i:1;s:38:\"proposal-client-accepted-portuguese_br\";i:1;s:39:\"proposal-send-to-customer-portuguese_br\";i:1;s:38:\"proposal-client-declined-portuguese_br\";i:1;s:39:\"proposal-client-thank-you-portuguese_br\";i:1;s:40:\"proposal-comment-to-client-portuguese_br\";i:1;s:39:\"proposal-comment-to-admin-portuguese_br\";i:1;s:44:\"estimate-thank-you-to-customer-portuguese_br\";i:1;s:40:\"task-deadline-notification-portuguese_br\";i:1;s:27:\"send-contract-portuguese_br\";i:1;s:47:\"invoice-payment-recorded-to-staff-portuguese_br\";i:1;s:31:\"auto-close-ticket-portuguese_br\";i:1;s:53:\"new-project-discussion-created-to-staff-portuguese_br\";i:1;s:56:\"new-project-discussion-created-to-customer-portuguese_br\";i:1;s:51:\"new-project-file-uploaded-to-customer-portuguese_br\";i:1;s:48:\"new-project-file-uploaded-to-staff-portuguese_br\";i:1;s:56:\"new-project-discussion-comment-to-customer-portuguese_br\";i:1;s:53:\"new-project-discussion-comment-to-staff-portuguese_br\";i:1;s:43:\"staff-added-as-project-member-portuguese_br\";i:1;s:38:\"estimate-expiry-reminder-portuguese_br\";i:1;s:38:\"proposal-expiry-reminder-portuguese_br\";i:1;s:31:\"new-staff-created-portuguese_br\";i:1;s:37:\"contact-forgot-password-portuguese_br\";i:1;s:38:\"contact-password-reseted-portuguese_br\";i:1;s:34:\"contact-set-password-portuguese_br\";i:1;s:35:\"staff-forgot-password-portuguese_br\";i:1;s:36:\"staff-password-reseted-portuguese_br\";i:1;s:33:\"assigned-to-project-portuguese_br\";i:1;s:47:\"task-added-attachment-to-contacts-portuguese_br\";i:1;s:40:\"task-commented-to-contacts-portuguese_br\";i:1;s:31:\"new-lead-assigned-portuguese_br\";i:1;s:30:\"client-statement-portuguese_br\";i:1;s:38:\"ticket-assigned-to-admin-portuguese_br\";i:1;s:44:\"new-client-registered-to-admin-portuguese_br\";i:1;s:44:\"new-web-to-lead-form-submitted-portuguese_br\";i:1;s:39:\"two-factor-authentication-portuguese_br\";i:1;s:42:\"project-finished-to-customer-portuguese_br\";i:1;s:40:\"credit-note-send-to-client-portuguese_br\";i:1;s:41:\"task-status-change-to-staff-portuguese_br\";i:1;s:44:\"task-status-change-to-contacts-portuguese_br\";i:1;s:34:\"reminder-email-staff-portuguese_br\";i:1;s:40:\"contract-comment-to-client-portuguese_br\";i:1;s:39:\"contract-comment-to-admin-portuguese_br\";i:1;s:31:\"send-subscription-portuguese_br\";i:1;s:41:\"subscription-payment-failed-portuguese_br\";i:1;s:35:\"subscription-canceled-portuguese_br\";i:1;s:44:\"subscription-payment-succeeded-portuguese_br\";i:1;s:42:\"contract-expiration-to-staff-portuguese_br\";i:1;s:34:\"gdpr-removal-request-portuguese_br\";i:1;s:39:\"gdpr-removal-request-lead-portuguese_br\";i:1;s:43:\"client-registration-confirmed-portuguese_br\";i:1;s:38:\"contract-signed-to-staff-portuguese_br\";i:1;s:42:\"customer-subscribed-to-staff-portuguese_br\";i:1;s:40:\"contact-verification-email-portuguese_br\";i:1;s:57:\"new-customer-profile-file-uploaded-to-staff-portuguese_br\";i:1;s:41:\"event-notification-to-staff-portuguese_br\";i:1;s:50:\"subscription-payment-requires-action-portuguese_br\";i:1;s:32:\"invoice-due-notice-portuguese_br\";i:1;s:49:\"estimate-request-submitted-to-staff-portuguese_br\";i:1;s:39:\"estimate-request-assigned-portuguese_br\";i:1;s:47:\"estimate-request-received-to-user-portuguese_br\";i:1;s:39:\"non-billed-tasks-reminder-portuguese_br\";i:1;s:37:\"invoices-batch-payments-portuguese_br\";i:1;s:36:\"contract-sign-reminder-portuguese_br\";i:1;s:25:\"new-client-created-german\";i:1;s:29:\"invoice-send-to-client-german\";i:1;s:30:\"new-ticket-opened-admin-german\";i:1;s:19:\"ticket-reply-german\";i:1;s:26:\"ticket-autoresponse-german\";i:1;s:31:\"invoice-payment-recorded-german\";i:1;s:29:\"invoice-overdue-notice-german\";i:1;s:27:\"invoice-already-send-german\";i:1;s:31:\"new-ticket-created-staff-german\";i:1;s:30:\"estimate-send-to-client-german\";i:1;s:28:\"ticket-reply-to-admin-german\";i:1;s:28:\"estimate-already-send-german\";i:1;s:26:\"contract-expiration-german\";i:1;s:20:\"task-assigned-german\";i:1;s:29:\"task-added-as-follower-german\";i:1;s:21:\"task-commented-german\";i:1;s:28:\"task-added-attachment-german\";i:1;s:33:\"estimate-declined-to-staff-german\";i:1;s:33:\"estimate-accepted-to-staff-german\";i:1;s:31:\"proposal-client-accepted-german\";i:1;s:32:\"proposal-send-to-customer-german\";i:1;s:31:\"proposal-client-declined-german\";i:1;s:32:\"proposal-client-thank-you-german\";i:1;s:33:\"proposal-comment-to-client-german\";i:1;s:32:\"proposal-comment-to-admin-german\";i:1;s:37:\"estimate-thank-you-to-customer-german\";i:1;s:33:\"task-deadline-notification-german\";i:1;s:20:\"send-contract-german\";i:1;s:40:\"invoice-payment-recorded-to-staff-german\";i:1;s:24:\"auto-close-ticket-german\";i:1;s:46:\"new-project-discussion-created-to-staff-german\";i:1;s:49:\"new-project-discussion-created-to-customer-german\";i:1;s:44:\"new-project-file-uploaded-to-customer-german\";i:1;s:41:\"new-project-file-uploaded-to-staff-german\";i:1;s:49:\"new-project-discussion-comment-to-customer-german\";i:1;s:46:\"new-project-discussion-comment-to-staff-german\";i:1;s:36:\"staff-added-as-project-member-german\";i:1;s:31:\"estimate-expiry-reminder-german\";i:1;s:31:\"proposal-expiry-reminder-german\";i:1;s:24:\"new-staff-created-german\";i:1;s:30:\"contact-forgot-password-german\";i:1;s:31:\"contact-password-reseted-german\";i:1;s:27:\"contact-set-password-german\";i:1;s:28:\"staff-forgot-password-german\";i:1;s:29:\"staff-password-reseted-german\";i:1;s:26:\"assigned-to-project-german\";i:1;s:40:\"task-added-attachment-to-contacts-german\";i:1;s:33:\"task-commented-to-contacts-german\";i:1;s:24:\"new-lead-assigned-german\";i:1;s:23:\"client-statement-german\";i:1;s:31:\"ticket-assigned-to-admin-german\";i:1;s:37:\"new-client-registered-to-admin-german\";i:1;s:37:\"new-web-to-lead-form-submitted-german\";i:1;s:32:\"two-factor-authentication-german\";i:1;s:35:\"project-finished-to-customer-german\";i:1;s:33:\"credit-note-send-to-client-german\";i:1;s:34:\"task-status-change-to-staff-german\";i:1;s:37:\"task-status-change-to-contacts-german\";i:1;s:27:\"reminder-email-staff-german\";i:1;s:33:\"contract-comment-to-client-german\";i:1;s:32:\"contract-comment-to-admin-german\";i:1;s:24:\"send-subscription-german\";i:1;s:34:\"subscription-payment-failed-german\";i:1;s:28:\"subscription-canceled-german\";i:1;s:37:\"subscription-payment-succeeded-german\";i:1;s:35:\"contract-expiration-to-staff-german\";i:1;s:27:\"gdpr-removal-request-german\";i:1;s:32:\"gdpr-removal-request-lead-german\";i:1;s:36:\"client-registration-confirmed-german\";i:1;s:31:\"contract-signed-to-staff-german\";i:1;s:35:\"customer-subscribed-to-staff-german\";i:1;s:33:\"contact-verification-email-german\";i:1;s:50:\"new-customer-profile-file-uploaded-to-staff-german\";i:1;s:34:\"event-notification-to-staff-german\";i:1;s:43:\"subscription-payment-requires-action-german\";i:1;s:25:\"invoice-due-notice-german\";i:1;s:42:\"estimate-request-submitted-to-staff-german\";i:1;s:32:\"estimate-request-assigned-german\";i:1;s:40:\"estimate-request-received-to-user-german\";i:1;s:32:\"non-billed-tasks-reminder-german\";i:1;s:30:\"invoices-batch-payments-german\";i:1;s:29:\"contract-sign-reminder-german\";i:1;s:27:\"new-client-created-romanian\";i:1;s:31:\"invoice-send-to-client-romanian\";i:1;s:32:\"new-ticket-opened-admin-romanian\";i:1;s:21:\"ticket-reply-romanian\";i:1;s:28:\"ticket-autoresponse-romanian\";i:1;s:33:\"invoice-payment-recorded-romanian\";i:1;s:31:\"invoice-overdue-notice-romanian\";i:1;s:29:\"invoice-already-send-romanian\";i:1;s:33:\"new-ticket-created-staff-romanian\";i:1;s:32:\"estimate-send-to-client-romanian\";i:1;s:30:\"ticket-reply-to-admin-romanian\";i:1;s:30:\"estimate-already-send-romanian\";i:1;s:28:\"contract-expiration-romanian\";i:1;s:22:\"task-assigned-romanian\";i:1;s:31:\"task-added-as-follower-romanian\";i:1;s:23:\"task-commented-romanian\";i:1;s:30:\"task-added-attachment-romanian\";i:1;s:35:\"estimate-declined-to-staff-romanian\";i:1;s:35:\"estimate-accepted-to-staff-romanian\";i:1;s:33:\"proposal-client-accepted-romanian\";i:1;s:34:\"proposal-send-to-customer-romanian\";i:1;s:33:\"proposal-client-declined-romanian\";i:1;s:34:\"proposal-client-thank-you-romanian\";i:1;s:35:\"proposal-comment-to-client-romanian\";i:1;s:34:\"proposal-comment-to-admin-romanian\";i:1;s:39:\"estimate-thank-you-to-customer-romanian\";i:1;s:35:\"task-deadline-notification-romanian\";i:1;s:22:\"send-contract-romanian\";i:1;s:42:\"invoice-payment-recorded-to-staff-romanian\";i:1;s:26:\"auto-close-ticket-romanian\";i:1;s:48:\"new-project-discussion-created-to-staff-romanian\";i:1;s:51:\"new-project-discussion-created-to-customer-romanian\";i:1;s:46:\"new-project-file-uploaded-to-customer-romanian\";i:1;s:43:\"new-project-file-uploaded-to-staff-romanian\";i:1;s:51:\"new-project-discussion-comment-to-customer-romanian\";i:1;s:48:\"new-project-discussion-comment-to-staff-romanian\";i:1;s:38:\"staff-added-as-project-member-romanian\";i:1;s:33:\"estimate-expiry-reminder-romanian\";i:1;s:33:\"proposal-expiry-reminder-romanian\";i:1;s:26:\"new-staff-created-romanian\";i:1;s:32:\"contact-forgot-password-romanian\";i:1;s:33:\"contact-password-reseted-romanian\";i:1;s:29:\"contact-set-password-romanian\";i:1;s:30:\"staff-forgot-password-romanian\";i:1;s:31:\"staff-password-reseted-romanian\";i:1;s:28:\"assigned-to-project-romanian\";i:1;s:42:\"task-added-attachment-to-contacts-romanian\";i:1;s:35:\"task-commented-to-contacts-romanian\";i:1;s:26:\"new-lead-assigned-romanian\";i:1;s:25:\"client-statement-romanian\";i:1;s:33:\"ticket-assigned-to-admin-romanian\";i:1;s:39:\"new-client-registered-to-admin-romanian\";i:1;s:39:\"new-web-to-lead-form-submitted-romanian\";i:1;s:34:\"two-factor-authentication-romanian\";i:1;s:37:\"project-finished-to-customer-romanian\";i:1;s:35:\"credit-note-send-to-client-romanian\";i:1;s:36:\"task-status-change-to-staff-romanian\";i:1;s:39:\"task-status-change-to-contacts-romanian\";i:1;s:29:\"reminder-email-staff-romanian\";i:1;s:35:\"contract-comment-to-client-romanian\";i:1;s:34:\"contract-comment-to-admin-romanian\";i:1;s:26:\"send-subscription-romanian\";i:1;s:36:\"subscription-payment-failed-romanian\";i:1;s:30:\"subscription-canceled-romanian\";i:1;s:39:\"subscription-payment-succeeded-romanian\";i:1;s:37:\"contract-expiration-to-staff-romanian\";i:1;s:29:\"gdpr-removal-request-romanian\";i:1;s:34:\"gdpr-removal-request-lead-romanian\";i:1;s:38:\"client-registration-confirmed-romanian\";i:1;s:33:\"contract-signed-to-staff-romanian\";i:1;s:37:\"customer-subscribed-to-staff-romanian\";i:1;s:35:\"contact-verification-email-romanian\";i:1;s:52:\"new-customer-profile-file-uploaded-to-staff-romanian\";i:1;s:36:\"event-notification-to-staff-romanian\";i:1;s:45:\"subscription-payment-requires-action-romanian\";i:1;s:27:\"invoice-due-notice-romanian\";i:1;s:44:\"estimate-request-submitted-to-staff-romanian\";i:1;s:34:\"estimate-request-assigned-romanian\";i:1;s:42:\"estimate-request-received-to-user-romanian\";i:1;s:34:\"non-billed-tasks-reminder-romanian\";i:1;s:32:\"invoices-batch-payments-romanian\";i:1;s:31:\"contract-sign-reminder-romanian\";i:1;s:34:\"new-client-created-francais_canada\";i:1;s:38:\"invoice-send-to-client-francais_canada\";i:1;s:39:\"new-ticket-opened-admin-francais_canada\";i:1;s:28:\"ticket-reply-francais_canada\";i:1;s:35:\"ticket-autoresponse-francais_canada\";i:1;s:40:\"invoice-payment-recorded-francais_canada\";i:1;s:38:\"invoice-overdue-notice-francais_canada\";i:1;s:36:\"invoice-already-send-francais_canada\";i:1;s:40:\"new-ticket-created-staff-francais_canada\";i:1;s:39:\"estimate-send-to-client-francais_canada\";i:1;s:37:\"ticket-reply-to-admin-francais_canada\";i:1;s:37:\"estimate-already-send-francais_canada\";i:1;s:35:\"contract-expiration-francais_canada\";i:1;s:29:\"task-assigned-francais_canada\";i:1;s:38:\"task-added-as-follower-francais_canada\";i:1;s:30:\"task-commented-francais_canada\";i:1;s:37:\"task-added-attachment-francais_canada\";i:1;s:42:\"estimate-declined-to-staff-francais_canada\";i:1;s:42:\"estimate-accepted-to-staff-francais_canada\";i:1;s:40:\"proposal-client-accepted-francais_canada\";i:1;s:41:\"proposal-send-to-customer-francais_canada\";i:1;s:40:\"proposal-client-declined-francais_canada\";i:1;s:41:\"proposal-client-thank-you-francais_canada\";i:1;s:42:\"proposal-comment-to-client-francais_canada\";i:1;s:41:\"proposal-comment-to-admin-francais_canada\";i:1;s:46:\"estimate-thank-you-to-customer-francais_canada\";i:1;s:42:\"task-deadline-notification-francais_canada\";i:1;s:29:\"send-contract-francais_canada\";i:1;s:49:\"invoice-payment-recorded-to-staff-francais_canada\";i:1;s:33:\"auto-close-ticket-francais_canada\";i:1;s:55:\"new-project-discussion-created-to-staff-francais_canada\";i:1;s:58:\"new-project-discussion-created-to-customer-francais_canada\";i:1;s:53:\"new-project-file-uploaded-to-customer-francais_canada\";i:1;s:50:\"new-project-file-uploaded-to-staff-francais_canada\";i:1;s:58:\"new-project-discussion-comment-to-customer-francais_canada\";i:1;s:55:\"new-project-discussion-comment-to-staff-francais_canada\";i:1;s:45:\"staff-added-as-project-member-francais_canada\";i:1;s:40:\"estimate-expiry-reminder-francais_canada\";i:1;s:40:\"proposal-expiry-reminder-francais_canada\";i:1;s:33:\"new-staff-created-francais_canada\";i:1;s:39:\"contact-forgot-password-francais_canada\";i:1;s:40:\"contact-password-reseted-francais_canada\";i:1;s:36:\"contact-set-password-francais_canada\";i:1;s:37:\"staff-forgot-password-francais_canada\";i:1;s:38:\"staff-password-reseted-francais_canada\";i:1;s:35:\"assigned-to-project-francais_canada\";i:1;s:49:\"task-added-attachment-to-contacts-francais_canada\";i:1;s:42:\"task-commented-to-contacts-francais_canada\";i:1;s:33:\"new-lead-assigned-francais_canada\";i:1;s:32:\"client-statement-francais_canada\";i:1;s:40:\"ticket-assigned-to-admin-francais_canada\";i:1;s:46:\"new-client-registered-to-admin-francais_canada\";i:1;s:46:\"new-web-to-lead-form-submitted-francais_canada\";i:1;s:41:\"two-factor-authentication-francais_canada\";i:1;s:44:\"project-finished-to-customer-francais_canada\";i:1;s:42:\"credit-note-send-to-client-francais_canada\";i:1;s:43:\"task-status-change-to-staff-francais_canada\";i:1;s:46:\"task-status-change-to-contacts-francais_canada\";i:1;s:36:\"reminder-email-staff-francais_canada\";i:1;s:42:\"contract-comment-to-client-francais_canada\";i:1;s:41:\"contract-comment-to-admin-francais_canada\";i:1;s:33:\"send-subscription-francais_canada\";i:1;s:43:\"subscription-payment-failed-francais_canada\";i:1;s:37:\"subscription-canceled-francais_canada\";i:1;s:46:\"subscription-payment-succeeded-francais_canada\";i:1;s:44:\"contract-expiration-to-staff-francais_canada\";i:1;s:36:\"gdpr-removal-request-francais_canada\";i:1;s:41:\"gdpr-removal-request-lead-francais_canada\";i:1;s:45:\"client-registration-confirmed-francais_canada\";i:1;s:40:\"contract-signed-to-staff-francais_canada\";i:1;s:44:\"customer-subscribed-to-staff-francais_canada\";i:1;s:42:\"contact-verification-email-francais_canada\";i:1;s:59:\"new-customer-profile-file-uploaded-to-staff-francais_canada\";i:1;s:43:\"event-notification-to-staff-francais_canada\";i:1;s:52:\"subscription-payment-requires-action-francais_canada\";i:1;s:34:\"invoice-due-notice-francais_canada\";i:1;s:51:\"estimate-request-submitted-to-staff-francais_canada\";i:1;s:41:\"estimate-request-assigned-francais_canada\";i:1;s:49:\"estimate-request-received-to-user-francais_canada\";i:1;s:41:\"non-billed-tasks-reminder-francais_canada\";i:1;s:39:\"invoices-batch-payments-francais_canada\";i:1;s:38:\"contract-sign-reminder-francais_canada\";i:1;s:24:\"new-client-created-dutch\";i:1;s:28:\"invoice-send-to-client-dutch\";i:1;s:29:\"new-ticket-opened-admin-dutch\";i:1;s:18:\"ticket-reply-dutch\";i:1;s:25:\"ticket-autoresponse-dutch\";i:1;s:30:\"invoice-payment-recorded-dutch\";i:1;s:28:\"invoice-overdue-notice-dutch\";i:1;s:26:\"invoice-already-send-dutch\";i:1;s:30:\"new-ticket-created-staff-dutch\";i:1;s:29:\"estimate-send-to-client-dutch\";i:1;s:27:\"ticket-reply-to-admin-dutch\";i:1;s:27:\"estimate-already-send-dutch\";i:1;s:25:\"contract-expiration-dutch\";i:1;s:19:\"task-assigned-dutch\";i:1;s:28:\"task-added-as-follower-dutch\";i:1;s:20:\"task-commented-dutch\";i:1;s:27:\"task-added-attachment-dutch\";i:1;s:32:\"estimate-declined-to-staff-dutch\";i:1;s:32:\"estimate-accepted-to-staff-dutch\";i:1;s:30:\"proposal-client-accepted-dutch\";i:1;s:31:\"proposal-send-to-customer-dutch\";i:1;s:30:\"proposal-client-declined-dutch\";i:1;s:31:\"proposal-client-thank-you-dutch\";i:1;s:32:\"proposal-comment-to-client-dutch\";i:1;s:31:\"proposal-comment-to-admin-dutch\";i:1;s:36:\"estimate-thank-you-to-customer-dutch\";i:1;s:32:\"task-deadline-notification-dutch\";i:1;s:19:\"send-contract-dutch\";i:1;s:39:\"invoice-payment-recorded-to-staff-dutch\";i:1;s:23:\"auto-close-ticket-dutch\";i:1;s:45:\"new-project-discussion-created-to-staff-dutch\";i:1;s:48:\"new-project-discussion-created-to-customer-dutch\";i:1;s:43:\"new-project-file-uploaded-to-customer-dutch\";i:1;s:40:\"new-project-file-uploaded-to-staff-dutch\";i:1;s:48:\"new-project-discussion-comment-to-customer-dutch\";i:1;s:45:\"new-project-discussion-comment-to-staff-dutch\";i:1;s:35:\"staff-added-as-project-member-dutch\";i:1;s:30:\"estimate-expiry-reminder-dutch\";i:1;s:30:\"proposal-expiry-reminder-dutch\";i:1;s:23:\"new-staff-created-dutch\";i:1;s:29:\"contact-forgot-password-dutch\";i:1;s:30:\"contact-password-reseted-dutch\";i:1;s:26:\"contact-set-password-dutch\";i:1;s:27:\"staff-forgot-password-dutch\";i:1;s:28:\"staff-password-reseted-dutch\";i:1;s:25:\"assigned-to-project-dutch\";i:1;s:39:\"task-added-attachment-to-contacts-dutch\";i:1;s:32:\"task-commented-to-contacts-dutch\";i:1;s:23:\"new-lead-assigned-dutch\";i:1;s:22:\"client-statement-dutch\";i:1;s:30:\"ticket-assigned-to-admin-dutch\";i:1;s:36:\"new-client-registered-to-admin-dutch\";i:1;s:36:\"new-web-to-lead-form-submitted-dutch\";i:1;s:31:\"two-factor-authentication-dutch\";i:1;s:34:\"project-finished-to-customer-dutch\";i:1;s:32:\"credit-note-send-to-client-dutch\";i:1;s:33:\"task-status-change-to-staff-dutch\";i:1;s:36:\"task-status-change-to-contacts-dutch\";i:1;s:26:\"reminder-email-staff-dutch\";i:1;s:32:\"contract-comment-to-client-dutch\";i:1;s:31:\"contract-comment-to-admin-dutch\";i:1;s:23:\"send-subscription-dutch\";i:1;s:33:\"subscription-payment-failed-dutch\";i:1;s:27:\"subscription-canceled-dutch\";i:1;s:36:\"subscription-payment-succeeded-dutch\";i:1;s:34:\"contract-expiration-to-staff-dutch\";i:1;s:26:\"gdpr-removal-request-dutch\";i:1;s:31:\"gdpr-removal-request-lead-dutch\";i:1;s:35:\"client-registration-confirmed-dutch\";i:1;s:30:\"contract-signed-to-staff-dutch\";i:1;s:34:\"customer-subscribed-to-staff-dutch\";i:1;s:32:\"contact-verification-email-dutch\";i:1;s:49:\"new-customer-profile-file-uploaded-to-staff-dutch\";i:1;s:33:\"event-notification-to-staff-dutch\";i:1;s:42:\"subscription-payment-requires-action-dutch\";i:1;s:24:\"invoice-due-notice-dutch\";i:1;s:41:\"estimate-request-submitted-to-staff-dutch\";i:1;s:31:\"estimate-request-assigned-dutch\";i:1;s:39:\"estimate-request-received-to-user-dutch\";i:1;s:31:\"non-billed-tasks-reminder-dutch\";i:1;s:29:\"invoices-batch-payments-dutch\";i:1;s:28:\"contract-sign-reminder-dutch\";i:1;s:25:\"new-client-created-polish\";i:1;s:29:\"invoice-send-to-client-polish\";i:1;s:30:\"new-ticket-opened-admin-polish\";i:1;s:19:\"ticket-reply-polish\";i:1;s:26:\"ticket-autoresponse-polish\";i:1;s:31:\"invoice-payment-recorded-polish\";i:1;s:29:\"invoice-overdue-notice-polish\";i:1;s:27:\"invoice-already-send-polish\";i:1;s:31:\"new-ticket-created-staff-polish\";i:1;s:30:\"estimate-send-to-client-polish\";i:1;s:28:\"ticket-reply-to-admin-polish\";i:1;s:28:\"estimate-already-send-polish\";i:1;s:26:\"contract-expiration-polish\";i:1;s:20:\"task-assigned-polish\";i:1;s:29:\"task-added-as-follower-polish\";i:1;s:21:\"task-commented-polish\";i:1;s:28:\"task-added-attachment-polish\";i:1;s:33:\"estimate-declined-to-staff-polish\";i:1;s:33:\"estimate-accepted-to-staff-polish\";i:1;s:31:\"proposal-client-accepted-polish\";i:1;s:32:\"proposal-send-to-customer-polish\";i:1;s:31:\"proposal-client-declined-polish\";i:1;s:32:\"proposal-client-thank-you-polish\";i:1;s:33:\"proposal-comment-to-client-polish\";i:1;s:32:\"proposal-comment-to-admin-polish\";i:1;s:37:\"estimate-thank-you-to-customer-polish\";i:1;s:33:\"task-deadline-notification-polish\";i:1;s:20:\"send-contract-polish\";i:1;s:40:\"invoice-payment-recorded-to-staff-polish\";i:1;s:24:\"auto-close-ticket-polish\";i:1;s:46:\"new-project-discussion-created-to-staff-polish\";i:1;s:49:\"new-project-discussion-created-to-customer-polish\";i:1;s:44:\"new-project-file-uploaded-to-customer-polish\";i:1;s:41:\"new-project-file-uploaded-to-staff-polish\";i:1;s:49:\"new-project-discussion-comment-to-customer-polish\";i:1;s:46:\"new-project-discussion-comment-to-staff-polish\";i:1;s:36:\"staff-added-as-project-member-polish\";i:1;s:31:\"estimate-expiry-reminder-polish\";i:1;s:31:\"proposal-expiry-reminder-polish\";i:1;s:24:\"new-staff-created-polish\";i:1;s:30:\"contact-forgot-password-polish\";i:1;s:31:\"contact-password-reseted-polish\";i:1;s:27:\"contact-set-password-polish\";i:1;s:28:\"staff-forgot-password-polish\";i:1;s:29:\"staff-password-reseted-polish\";i:1;s:26:\"assigned-to-project-polish\";i:1;s:40:\"task-added-attachment-to-contacts-polish\";i:1;s:33:\"task-commented-to-contacts-polish\";i:1;s:24:\"new-lead-assigned-polish\";i:1;s:23:\"client-statement-polish\";i:1;s:31:\"ticket-assigned-to-admin-polish\";i:1;s:37:\"new-client-registered-to-admin-polish\";i:1;s:37:\"new-web-to-lead-form-submitted-polish\";i:1;s:32:\"two-factor-authentication-polish\";i:1;s:35:\"project-finished-to-customer-polish\";i:1;s:33:\"credit-note-send-to-client-polish\";i:1;s:34:\"task-status-change-to-staff-polish\";i:1;s:37:\"task-status-change-to-contacts-polish\";i:1;s:27:\"reminder-email-staff-polish\";i:1;s:33:\"contract-comment-to-client-polish\";i:1;s:32:\"contract-comment-to-admin-polish\";i:1;s:24:\"send-subscription-polish\";i:1;s:34:\"subscription-payment-failed-polish\";i:1;s:28:\"subscription-canceled-polish\";i:1;s:37:\"subscription-payment-succeeded-polish\";i:1;s:35:\"contract-expiration-to-staff-polish\";i:1;s:27:\"gdpr-removal-request-polish\";i:1;s:32:\"gdpr-removal-request-lead-polish\";i:1;s:36:\"client-registration-confirmed-polish\";i:1;s:31:\"contract-signed-to-staff-polish\";i:1;s:35:\"customer-subscribed-to-staff-polish\";i:1;s:33:\"contact-verification-email-polish\";i:1;s:50:\"new-customer-profile-file-uploaded-to-staff-polish\";i:1;s:34:\"event-notification-to-staff-polish\";i:1;s:43:\"subscription-payment-requires-action-polish\";i:1;s:25:\"invoice-due-notice-polish\";i:1;s:42:\"estimate-request-submitted-to-staff-polish\";i:1;s:32:\"estimate-request-assigned-polish\";i:1;s:40:\"estimate-request-received-to-user-polish\";i:1;s:32:\"non-billed-tasks-reminder-polish\";i:1;s:30:\"invoices-batch-payments-polish\";i:1;s:29:\"contract-sign-reminder-polish\";i:1;s:22:\"webhook-failed-turkish\";i:1;s:24:\"webhook-failed-norwegian\";i:1;s:23:\"webhook-failed-japanese\";i:1;s:22:\"webhook-failed-russian\";i:1;s:24:\"webhook-failed-ukrainian\";i:1;s:22:\"webhook-failed-swedish\";i:1;s:24:\"webhook-failed-bulgarian\";i:1;s:25:\"webhook-failed-vietnamese\";i:1;s:21:\"webhook-failed-slovak\";i:1;s:21:\"webhook-failed-french\";i:1;s:22:\"webhook-failed-persian\";i:1;s:22:\"webhook-failed-catalan\";i:1;s:20:\"webhook-failed-greek\";i:1;s:20:\"webhook-failed-czech\";i:1;s:22:\"webhook-failed-chinese\";i:1;s:22:\"webhook-failed-spanish\";i:1;s:25:\"webhook-failed-portuguese\";i:1;s:22:\"webhook-failed-finnish\";i:1;s:22:\"webhook-failed-italian\";i:1;s:24:\"webhook-failed-indonesia\";i:1;s:28:\"webhook-failed-portuguese_br\";i:1;s:21:\"webhook-failed-german\";i:1;s:23:\"webhook-failed-romanian\";i:1;s:30:\"webhook-failed-francais_canada\";i:1;s:20:\"webhook-failed-dutch\";i:1;s:21:\"webhook-failed-polish\";i:1;s:39:\"flexibackup-new-backup-to-staff-turkish\";i:1;s:41:\"flexibackup-new-backup-to-staff-norwegian\";i:1;s:40:\"flexibackup-new-backup-to-staff-japanese\";i:1;s:39:\"flexibackup-new-backup-to-staff-russian\";i:1;s:41:\"flexibackup-new-backup-to-staff-ukrainian\";i:1;s:39:\"flexibackup-new-backup-to-staff-swedish\";i:1;s:41:\"flexibackup-new-backup-to-staff-bulgarian\";i:1;s:42:\"flexibackup-new-backup-to-staff-vietnamese\";i:1;s:38:\"flexibackup-new-backup-to-staff-slovak\";i:1;s:38:\"flexibackup-new-backup-to-staff-french\";i:1;s:39:\"flexibackup-new-backup-to-staff-persian\";i:1;s:39:\"flexibackup-new-backup-to-staff-catalan\";i:1;s:37:\"flexibackup-new-backup-to-staff-greek\";i:1;s:37:\"flexibackup-new-backup-to-staff-czech\";i:1;s:39:\"flexibackup-new-backup-to-staff-chinese\";i:1;s:39:\"flexibackup-new-backup-to-staff-spanish\";i:1;s:42:\"flexibackup-new-backup-to-staff-portuguese\";i:1;s:39:\"flexibackup-new-backup-to-staff-finnish\";i:1;s:39:\"flexibackup-new-backup-to-staff-italian\";i:1;s:41:\"flexibackup-new-backup-to-staff-indonesia\";i:1;s:45:\"flexibackup-new-backup-to-staff-portuguese_br\";i:1;s:38:\"flexibackup-new-backup-to-staff-german\";i:1;s:40:\"flexibackup-new-backup-to-staff-romanian\";i:1;s:47:\"flexibackup-new-backup-to-staff-francais_canada\";i:1;s:37:\"flexibackup-new-backup-to-staff-dutch\";i:1;s:38:\"flexibackup-new-backup-to-staff-polish\";i:1;}',0),(212,'proposal_accept_identity_confirmation','1',0),(213,'estimate_accept_identity_confirmation','1',0),(214,'new_task_auto_follower_current_member','0',1),(215,'task_biillable_checked_on_creation','1',1),(216,'predefined_clientnote_credit_note','',1),(217,'predefined_terms_credit_note','',1),(218,'next_credit_note_number','1',1),(219,'credit_note_prefix','CN-',1),(220,'credit_note_number_decrement_on_delete','1',1),(221,'pdf_format_credit_note','A4-PORTRAIT',1),(222,'show_pdf_signature_credit_note','1',0),(223,'show_credit_note_reminders_on_calendar','1',1),(224,'show_amount_due_on_invoice','1',1),(225,'show_total_paid_on_invoice','1',1),(226,'show_credits_applied_on_invoice','1',1),(227,'staff_members_create_inline_lead_status','1',1),(228,'staff_members_create_inline_customer_groups','1',1),(229,'staff_members_create_inline_ticket_services','1',1),(230,'staff_members_save_tickets_predefined_replies','1',1),(231,'staff_members_create_inline_contract_types','1',1),(232,'staff_members_create_inline_expense_categories','1',1),(233,'show_project_on_credit_note','1',1),(234,'proposals_auto_operations_hour','9',1),(235,'estimates_auto_operations_hour','9',1),(236,'contracts_auto_operations_hour','9',1),(237,'credit_note_number_format','1',1),(238,'allow_non_admin_members_to_import_leads','0',1),(239,'e_sign_legal_text','En cliquant sur « Signer », je consens à être légalement lié par cette représentation électronique de ma signature.',1),(240,'show_pdf_signature_contract','1',1),(241,'view_contract_only_logged_in','0',1),(242,'show_subscriptions_in_customers_area','1',1),(243,'calendar_only_assigned_tasks','0',1),(244,'after_subscription_payment_captured','send_invoice_and_receipt',1),(245,'mail_engine','phpmailer',1),(246,'gdpr_enable_terms_and_conditions','0',1),(247,'privacy_policy','<p><strong>Politique de Confidentialit&#233;</strong></p>\n<p>1. **Responsable du traitement des donn&#233;es**<br>&#160; &#160;- Identit&#233; : Symbiose Mobilit&#233;<br>&#160; &#160;- Coordonn&#233;es : 32 Rue du Bosquet, 33600 Pessac, France<br>&#160; &#160;- Email : contact@symbiose-mobilite.com<br>&#160; &#160;- Responsable : Mikel Barthelemy</p>\n<p>2. **Donn&#233;es collect&#233;es**<br>&#160; &#160;- Types de donn&#233;es : nom, pr&#233;nom, adresse postale, adresse e-mail, num&#233;ro de t&#233;l&#233;phone<br>&#160; &#160;- M&#233;thodes de collecte : formulaires en ligne, inscriptions, commandes</p>\n<p>3. **Finalit&#233;s du traitement**<br>&#160; &#160;- Gestion des commandes et livraisons<br>&#160; &#160;- Service client<br>&#160; &#160;- Envoi d\'informations commerciales (avec consentement pr&#233;alable)</p>\n<p>4. **Base l&#233;gale du traitement**<br>&#160; &#160;- Ex&#233;cution d\'un contrat<br>&#160; &#160;- Consentement de la personne concern&#233;e<br>&#160; &#160;- Int&#233;r&#234;t l&#233;gitime de l\'entreprise</p>\n<p>5. **Destinataires des donn&#233;es**<br>&#160; &#160;- Services internes de Symbiose Mobilit&#233;<br>&#160; &#160;- Partenaires et sous-traitants impliqu&#233;s dans l\'ex&#233;cution des services</p>\n<p>6. **Dur&#233;e de conservation des donn&#233;es**<br>&#160; &#160;- Les donn&#233;es sont conserv&#233;es pendant la dur&#233;e n&#233;cessaire aux finalit&#233;s pour lesquelles elles ont &#233;t&#233; collect&#233;es, conform&#233;ment aux exigences l&#233;gales.</p>\n<p>7. **Droits des personnes concern&#233;es**<br>&#160; &#160;- Acc&#232;s, rectification, effacement, opposition, limitation, portabilit&#233;<br>&#160; &#160;- Modalit&#233;s d\'exercice : contact@symbiose-mobilite.com</p>\n<p>8. **Transfert de donn&#233;es hors UE**<br>&#160; &#160;- Symbiose Mobilit&#233; ne transf&#232;re pas de donn&#233;es personnelles en dehors de l\'Union Europ&#233;enne.</p>\n<p>9. **S&#233;curit&#233; des donn&#233;es**<br>&#160; &#160;- Des mesures techniques et organisationnelles appropri&#233;es sont mises en place pour prot&#233;ger les donn&#233;es contre tout acc&#232;s non autoris&#233;, divulgation, alt&#233;ration ou destruction.</p>\n<p>10. **Modification de la politique de confidentialit&#233;**<br>&#160; &#160; - Symbiose Mobilit&#233; se r&#233;serve le droit de modifier la pr&#233;sente Politique de Confidentialit&#233; &#224; tout moment. Les modifications seront publi&#233;es sur cette page avec une date de mise &#224; jour.</p>',1),(248,'terms_and_conditions','<p><strong>Protection des donn&#233;es personnelles</strong></p>\n<p>Conform&#233;ment au R&#232;glement (UE) 2016/679 du 27 avril 2016 (RGPD), Symbiose Mobilit&#233; s\'engage &#224; prot&#233;ger les donn&#233;es personnelles de ses clients. Les informations collect&#233;es sont n&#233;cessaires au traitement et &#224; la livraison des commandes, ainsi qu\'&#224; l\'&#233;tablissement des factures. Elles peuvent &#234;tre communiqu&#233;es aux partenaires de Symbiose Mobilit&#233; responsables de l\'ex&#233;cution, du traitement, de la gestion et du paiement des commandes.</p>\n<p>Le client dispose d\'un droit d\'acc&#232;s, de rectification, de suppression et de portabilit&#233; des donn&#233;es le concernant, qu\'il peut exercer en s\'adressant &#224; : contact@symbiose-mobilite.com. Pour plus d\'informations, consultez notre Politique de Confidentialit&#233; disponible sur notre site web.</p>',1),(249,'gdpr_enable_terms_and_conditions_lead_form','0',1),(250,'gdpr_enable_terms_and_conditions_ticket_form','0',1),(251,'gdpr_contact_enable_right_to_be_forgotten','0',1),(252,'show_gdpr_in_customers_menu','1',1),(253,'show_gdpr_link_in_footer','1',1),(254,'enable_gdpr','1',1),(255,'gdpr_on_forgotten_remove_invoices_credit_notes','0',1),(256,'gdpr_on_forgotten_remove_estimates','0',1),(257,'gdpr_enable_consent_for_contacts','0',1),(258,'gdpr_consent_public_page_top_block','<p><strong>Utilisation des cookies et collecte de donn&#233;es</strong></p>\n<p>En poursuivant votre navigation sur ce site, vous acceptez l\'utilisation de cookies pour vous proposer des services et offres adapt&#233;s &#224; vos centres d\'int&#233;r&#234;t. [Lien vers la Politique de Confidentialit&#233;]</p>',1),(259,'gdpr_page_top_information_block','<p><strong>Engagement de Symbiose Mobilit&#233; en mati&#232;re de protection des donn&#233;es</strong></p>\n<p>Chez Symbiose Mobilit&#233;, la confidentialit&#233; et la s&#233;curit&#233; de vos donn&#233;es personnelles sont une priorit&#233;. Conform&#233;ment au RGPD, nous mettons en &#339;uvre toutes les mesures n&#233;cessaires pour prot&#233;ger vos informations et vous permettre de contr&#244;ler vos donn&#233;es. Cette page d&#233;taille nos pratiques en mati&#232;re de collecte, d\'utilisation et de conservation de vos donn&#233;es personnelles.</p>',1),(260,'gdpr_enable_lead_public_form','0',1),(261,'gdpr_show_lead_custom_fields_on_public_form','0',1),(262,'gdpr_lead_attachments_on_public_form','0',1),(263,'gdpr_enable_consent_for_leads','0',1),(264,'gdpr_lead_enable_right_to_be_forgotten','0',1),(265,'allow_staff_view_invoices_assigned','1',1),(266,'gdpr_data_portability_leads','0',1),(267,'gdpr_lead_data_portability_allowed','',1),(268,'gdpr_contact_data_portability_allowed','',1),(269,'gdpr_data_portability_contacts','0',1),(270,'allow_staff_view_estimates_assigned','1',1),(271,'gdpr_after_lead_converted_delete','0',1),(272,'gdpr_show_terms_and_conditions_in_footer','0',1),(273,'save_last_order_for_tables','0',1),(274,'company_logo_dark','5b5d3ec3318961c3f195a1a70f6dab8d.png',1),(275,'customers_register_require_confirmation','1',1),(276,'allow_non_admin_staff_to_delete_ticket_attachments','0',1),(277,'receive_notification_on_new_ticket_replies','1',0),(278,'google_client_id','',1),(279,'enable_google_picker','1',1),(280,'show_ticket_reminders_on_calendar','1',1),(281,'ticket_import_reply_only','0',1),(282,'visible_customer_profile_tabs','a:19:{s:7:\"profile\";b:0;s:8:\"contacts\";b:0;s:5:\"notes\";b:1;s:9:\"statement\";b:0;s:8:\"invoices\";b:0;s:8:\"payments\";b:0;s:9:\"proposals\";b:0;s:12:\"credit_notes\";b:0;s:9:\"estimates\";b:1;s:13:\"subscriptions\";b:0;s:8:\"expenses\";b:0;s:9:\"contracts\";b:0;s:8:\"projects\";b:0;s:5:\"tasks\";b:1;s:7:\"tickets\";b:1;s:11:\"attachments\";b:1;s:5:\"vault\";b:1;s:9:\"reminders\";b:1;s:3:\"map\";b:0;}',0),(283,'show_project_on_invoice','1',1),(284,'show_project_on_estimate','1',1),(285,'staff_members_create_inline_lead_source','1',1),(286,'lead_unique_validation','[\"email\"]',1),(287,'last_upgrade_copy_data','',1),(288,'custom_js_admin_scripts','',1),(289,'custom_js_customer_scripts','0',1),(290,'stripe_webhook_id','',1),(291,'stripe_webhook_signing_secret','',1),(292,'stripe_ideal_webhook_id','',1),(293,'stripe_ideal_webhook_signing_secret','',1),(294,'show_php_version_notice','1',0),(295,'recaptcha_ignore_ips','',1),(296,'show_task_reminders_on_calendar','1',1),(297,'customer_settings','true',1),(298,'tasks_reminder_notification_hour','9',1),(299,'allow_primary_contact_to_manage_other_contacts','0',1),(300,'items_table_amounts_exclude_currency_symbol','1',1),(301,'round_off_task_timer_option','0',1),(302,'round_off_task_timer_time','5',1),(303,'bitly_access_token','',1),(304,'enable_support_menu_badges','0',1),(305,'attach_invoice_to_payment_receipt_email','0',1),(306,'invoice_due_notice_before','2',1),(307,'invoice_due_notice_resend_after','0',1),(308,'_leads_settings','true',1),(309,'show_estimate_request_in_customers_area','0',1),(310,'gdpr_enable_terms_and_conditions_estimate_request_form','0',1),(311,'identification_key','112091347173984147267b3dfc09df71',1),(312,'automatically_stop_task_timer_after_hours','8',1),(313,'automatically_assign_ticket_to_first_staff_responding','0',1),(314,'reminder_for_completed_but_not_billed_tasks','0',1),(315,'staff_notify_completed_but_not_billed_tasks','',1),(316,'reminder_for_completed_but_not_billed_tasks_days','',1),(317,'tasks_reminder_notification_last_notified_day','',1),(318,'staff_related_ticket_notification_to_assignee_only','0',1),(319,'show_pdf_signature_proposal','1',1),(320,'enable_honeypot_spam_validation','0',1),(321,'microsoft_mail_client_id','077406ad-e0b6-495a-9482-59a3e2d2d228',1),(322,'microsoft_mail_client_secret','663ed987e6de2fc065dc2c6872783dce20b3b8bba43a67497668fd8e46e54f98303d69de4495f0042a2e9a79e74b8dca3b2e82904b068c54ed5f7d9bfb501cadCXne0MaXxy4qIV25qQhsEH6js9cFIloOsJnLCP/oN9NvwejQsFSCF9vBaojXH/wUAr36F5USKqtdeCxz6saSww==',1),(323,'microsoft_mail_azure_tenant_id','46d42615-ade0-4e86-8a03-7f00bc033878',1),(324,'google_mail_client_id','',1),(325,'google_mail_client_secret','',1),(326,'google_mail_refresh_token','',1),(327,'automatically_set_logged_in_staff_sales_agent','1',1),(328,'contract_sign_reminder_every_days','0',1),(329,'last_updated_date','1781875671',1),(330,'v310_incompatible_tables','[]',1),(331,'microsoft_mail_refresh_token','1.Aa8AFSbURuCthk6KA38AvAM4eK0GdAe24FpJlIJZo-LS0ihKARKvAA.AgABAwEAAABVrSpeuWamRam2jAF1XRQEAwDs_wUA9P85IV_jJLscoD9aIVq4z-k8CpBcljnbCIwiPyvB2nms90zCTzfhvvuWnGmavQu6EgVMVBFULXVeiuqlYNHkMmLJtChsBoa2VgWquHFIJn-eHcYemEmkr9UyF_1Yq2UhAvOYs6x_F7Nk0sTp57XueQxAgXm5zv-uFLQrMLahPhyuKp56zX7_75b-HAUwio3mE2GqJdH-jsZ8pIU_wqzw-aYiDUUFVgvPzEe_9s8a22_jrwRvf4fCzamKp-jiNDSEc9W6DF0q4fv99F57uDvJ8fWtZAwBSPVCNev2T02fiS41RKeO4z--Z7f9x3J1hJ_swc9os9K_hZsFpioliaeKrJQ9KfS7OzUQue6tSmJeFA55AdVtact_ZfMQXXlopqWb8XfmtZEMXpF6Plm69FRpZGHmdjrzrESLpwz9oQ6uwX5uvGxMS_NKvzBI4TvJPiMHNNWTtmAOjkh44cR-CDcyXJOOp8tRRvcs0RM5tcRXnqg6rVrGglAQ3aEWyffgbRH9wYEEngOb47VJHnjBrVBAOXNEtdk5fRR7kF2a8d1TBe7T_cBFNocM_G6WvKPuBrDikaEiy9mF_J4XpEBnZJCLzLL1XdAnk-aKgFVj-QNhpYwI1UzyFa0m3qcWmJq9fnk08YPPtccRlQcDBiKIoueYOY-q1MDdaUFJH7-Mrz4adu77IwwgPTTh3PizAePaOQaWa-v1dNw0QL_QXCSbivxCrU5CVeFiMaFtmOCAr8mZUGAHmR9F-lCQ8Y-jQEEsTNixONmbSfAalXtSzz1NMk9nwaxIBUJwbblIYYVd-H3cbqKYUZgghBRZMgGx0uCV1pih9GEp6O_eqHfmVPFQMhMm22iO4UXV4X7BmWpE7xi-z70',1),(332,'required_register_fields','[]',0),(333,'allow_non_admin_members_to_delete_tickets_and_replies','1',1),(334,'proposal_auto_convert_to_invoice_on_client_accept','0',1),(335,'show_project_on_proposal','1',1),(336,'disable_ticket_public_url','0',1),(338,'sms_clickatell_api_key','',1),(339,'sms_clickatell_active','0',1),(340,'sms_clickatell_initialized','1',1),(341,'sms_msg91_sender_id','',1),(342,'sms_msg91_api_type','api',1),(343,'sms_msg91_auth_key','',1),(344,'sms_msg91_active','0',1),(345,'sms_msg91_initialized','1',1),(346,'sms_twilio_account_sid','',1),(347,'sms_twilio_auth_token','',1),(348,'sms_twilio_phone_number','',1),(349,'sms_twilio_sender_id','',1),(350,'sms_twilio_active','0',1),(351,'sms_twilio_initialized','1',1),(352,'paymentmethod_payu_money_active','0',1),(353,'paymentmethod_payu_money_label','PayU Money',1),(354,'paymentmethod_payu_money_fee_fixed','0',0),(355,'paymentmethod_payu_money_fee_percent','0',0),(356,'paymentmethod_payu_money_key','',0),(357,'paymentmethod_payu_money_salt','',0),(358,'paymentmethod_payu_money_description_dashboard','Payment for Invoice {invoice_number}',0),(359,'paymentmethod_payu_money_currencies','INR',0),(360,'paymentmethod_payu_money_test_mode_enabled','1',0),(361,'paymentmethod_payu_money_default_selected','1',1),(362,'paymentmethod_payu_money_initialized','1',1),(363,'paymentmethod_stripe_active','0',1),(364,'paymentmethod_stripe_label','Stripe Checkout',1),(365,'paymentmethod_stripe_fee_fixed','0',0),(366,'paymentmethod_stripe_fee_percent','0',0),(367,'paymentmethod_stripe_api_publishable_key','',0),(368,'paymentmethod_stripe_api_secret_key','',0),(369,'paymentmethod_stripe_description_dashboard','Payment for Invoice {invoice_number}',0),(370,'paymentmethod_stripe_currencies','USD,CAD',0),(371,'paymentmethod_stripe_allow_primary_contact_to_update_credit_card','1',0),(372,'paymentmethod_stripe_default_selected','1',1),(373,'paymentmethod_stripe_initialized','1',1),(374,'paymentmethod_stripe_ideal_active','0',1),(375,'paymentmethod_stripe_ideal_label','Stripe iDEAL',1),(376,'paymentmethod_stripe_ideal_api_secret_key','',0),(377,'paymentmethod_stripe_ideal_api_publishable_key','',0),(378,'paymentmethod_stripe_ideal_description_dashboard','Payment for Invoice {invoice_number}',0),(379,'paymentmethod_stripe_ideal_statement_descriptor','Payment for Invoice {invoice_number}',0),(380,'paymentmethod_stripe_ideal_currencies','EUR',0),(381,'paymentmethod_stripe_ideal_default_selected','1',1),(382,'paymentmethod_stripe_ideal_initialized','1',1),(383,'paymentmethod_two_checkout_active','0',1),(384,'paymentmethod_two_checkout_label','2Checkout',1),(385,'paymentmethod_two_checkout_fee_fixed','0',0),(386,'paymentmethod_two_checkout_fee_percent','0',0),(387,'paymentmethod_two_checkout_merchant_code','',0),(388,'paymentmethod_two_checkout_secret_key','',0),(389,'paymentmethod_two_checkout_description','Payment for Invoice {invoice_number}',0),(390,'paymentmethod_two_checkout_currencies','USD, EUR, GBP',0),(391,'paymentmethod_two_checkout_test_mode_enabled','1',0),(392,'paymentmethod_two_checkout_default_selected','1',1),(393,'paymentmethod_two_checkout_initialized','1',1),(394,'paymentmethod_mollie_active','0',1),(395,'paymentmethod_mollie_label','Mollie',1),(396,'paymentmethod_mollie_api_key','',0),(397,'paymentmethod_mollie_description_dashboard','Payment for Invoice {invoice_number}',0),(398,'paymentmethod_mollie_currencies','EUR',0),(399,'paymentmethod_mollie_test_mode_enabled','1',0),(400,'paymentmethod_mollie_default_selected','1',1),(401,'paymentmethod_mollie_initialized','1',1),(402,'paymentmethod_paypal_braintree_active','0',1),(403,'paymentmethod_paypal_braintree_label','Braintree',1),(404,'paymentmethod_paypal_braintree_merchant_id','',0),(405,'paymentmethod_paypal_braintree_api_public_key','',0),(406,'paymentmethod_paypal_braintree_api_private_key','',0),(407,'paymentmethod_paypal_braintree_currencies','USD',0),(408,'paymentmethod_paypal_braintree_paypal_enabled','1',0),(409,'paymentmethod_paypal_braintree_test_mode_enabled','1',0),(410,'paymentmethod_paypal_braintree_default_selected','1',1),(411,'paymentmethod_paypal_braintree_initialized','1',1),(412,'paymentmethod_paypal_checkout_active','0',1),(413,'paymentmethod_paypal_checkout_label','Paypal Smart Checkout',1),(414,'paymentmethod_paypal_checkout_fee_fixed','0',0),(415,'paymentmethod_paypal_checkout_fee_percent','0',0),(416,'paymentmethod_paypal_checkout_client_id','',0),(417,'paymentmethod_paypal_checkout_secret','',0),(418,'paymentmethod_paypal_checkout_payment_description','Payment for Invoice {invoice_number}',0),(419,'paymentmethod_paypal_checkout_currencies','USD,CAD,EUR',0),(420,'paymentmethod_paypal_checkout_test_mode_enabled','1',0),(421,'paymentmethod_paypal_checkout_default_selected','1',1),(422,'paymentmethod_paypal_checkout_initialized','1',1),(423,'paymentmethod_paypal_active','0',1),(424,'paymentmethod_paypal_label','Paypal',1),(425,'paymentmethod_paypal_fee_fixed','0',0),(426,'paymentmethod_paypal_fee_percent','0',0),(427,'paymentmethod_paypal_username','',0),(428,'paymentmethod_paypal_password','',0),(429,'paymentmethod_paypal_signature','',0),(430,'paymentmethod_paypal_description_dashboard','Payment for Invoice {invoice_number}',0),(431,'paymentmethod_paypal_currencies','EUR,USD',0),(432,'paymentmethod_paypal_test_mode_enabled','1',0),(433,'paymentmethod_paypal_default_selected','1',1),(434,'paymentmethod_paypal_initialized','1',1),(435,'paymentmethod_authorize_acceptjs_active','0',1),(436,'paymentmethod_authorize_acceptjs_label','Authorize.net Accept.js',1),(437,'paymentmethod_authorize_acceptjs_public_key','',0),(438,'paymentmethod_authorize_acceptjs_api_login_id','',0),(439,'paymentmethod_authorize_acceptjs_api_transaction_key','',0),(440,'paymentmethod_authorize_acceptjs_description_dashboard','Payment for Invoice {invoice_number}',0),(441,'paymentmethod_authorize_acceptjs_currencies','USD',0),(442,'paymentmethod_authorize_acceptjs_test_mode_enabled','0',0),(443,'paymentmethod_authorize_acceptjs_default_selected','1',1),(444,'paymentmethod_authorize_acceptjs_initialized','1',1),(445,'paymentmethod_instamojo_active','0',1),(446,'paymentmethod_instamojo_label','Instamojo',1),(447,'paymentmethod_instamojo_fee_fixed','0',0),(448,'paymentmethod_instamojo_fee_percent','0',0),(449,'paymentmethod_instamojo_api_key','',0),(450,'paymentmethod_instamojo_auth_token','',0),(451,'paymentmethod_instamojo_description_dashboard','Payment for Invoice {invoice_number}',0),(452,'paymentmethod_instamojo_currencies','INR',0),(453,'paymentmethod_instamojo_test_mode_enabled','1',0),(454,'paymentmethod_instamojo_default_selected','1',1),(455,'paymentmethod_instamojo_initialized','1',1),(456,'auto_backup_enabled','1',1),(457,'auto_backup_every','1',1),(458,'last_auto_backup','1757408884',1),(459,'delete_backups_older_then','14',1),(460,'auto_backup_hour','6',1),(461,'aside_menu_active','{\"dashboard\":{\"id\":\"dashboard\",\"icon\":\"\",\"disabled\":\"false\",\"position\":1},\"leads\":{\"id\":\"leads\",\"icon\":\"\",\"disabled\":\"false\",\"position\":\"10\"},\"customers\":{\"id\":\"customers\",\"icon\":\"\",\"disabled\":\"false\",\"position\":\"15\"},\"sales\":{\"id\":\"sales\",\"icon\":\"\",\"disabled\":\"false\",\"position\":\"20\",\"children\":{\"proposals\":{\"disabled\":\"false\",\"id\":\"proposals\",\"icon\":\"\",\"position\":\"5\"},\"estimates\":{\"disabled\":\"false\",\"id\":\"estimates\",\"icon\":\"\",\"position\":\"10\"},\"invoices\":{\"disabled\":\"false\",\"id\":\"invoices\",\"icon\":\"\",\"position\":\"15\"},\"payments\":{\"disabled\":\"false\",\"id\":\"payments\",\"icon\":\"\",\"position\":\"20\"},\"credit_notes\":{\"disabled\":\"false\",\"id\":\"credit_notes\",\"icon\":\"\",\"position\":\"25\"},\"items\":{\"disabled\":\"false\",\"id\":\"items\",\"icon\":\"\",\"position\":\"30\"}}},\"subscriptions\":{\"id\":\"subscriptions\",\"icon\":\"\",\"disabled\":\"true\",\"position\":\"25\"},\"expenses\":{\"id\":\"expenses\",\"icon\":\"\",\"disabled\":\"true\",\"position\":\"30\"},\"projects\":{\"id\":\"projects\",\"icon\":\"\",\"disabled\":\"false\",\"position\":\"35\"},\"tasks\":{\"id\":\"tasks\",\"icon\":\"\",\"disabled\":\"false\",\"position\":\"40\"},\"sm-sharepoint-sync\":{\"id\":\"sm-sharepoint-sync\",\"icon\":\"\",\"disabled\":\"true\",\"position\":\"45\",\"children\":{\"sm-sharepoint-sync-dashboard\":{\"disabled\":\"false\",\"id\":\"sm-sharepoint-sync-dashboard\",\"icon\":\"\",\"position\":\"5\"},\"sm-sharepoint-sync-settings\":{\"disabled\":\"false\",\"id\":\"sm-sharepoint-sync-settings\",\"icon\":\"\",\"position\":\"10\"}}},\"support\":{\"id\":\"support\",\"icon\":\"\",\"disabled\":\"true\",\"position\":\"50\"},\"contracts\":{\"id\":\"contracts\",\"icon\":\"\",\"disabled\":\"false\",\"position\":\"55\"},\"estimate_request\":{\"id\":\"estimate_request\",\"icon\":\"\",\"disabled\":\"false\",\"position\":\"60\"},\"api-options\":{\"id\":\"api-options\",\"icon\":\"\",\"disabled\":\"false\",\"position\":\"65\",\"children\":{\"api-register-options\":{\"disabled\":\"false\",\"id\":\"api-register-options\",\"icon\":\"\",\"position\":\"5\"},\"api-guide-options\":{\"disabled\":\"false\",\"id\":\"api-guide-options\",\"icon\":\"\",\"position\":\"10\"}}},\"knowledge-base\":{\"id\":\"knowledge-base\",\"icon\":\"\",\"disabled\":\"true\",\"position\":\"70\"},\"utilities\":{\"id\":\"utilities\",\"icon\":\"\",\"disabled\":\"false\",\"position\":\"75\",\"children\":{\"media\":{\"disabled\":\"false\",\"id\":\"media\",\"icon\":\"\",\"position\":\"5\"},\"bulk-pdf-exporter\":{\"disabled\":\"false\",\"id\":\"bulk-pdf-exporter\",\"icon\":\"\",\"position\":\"10\"},\"csv-export\":{\"disabled\":\"false\",\"id\":\"csv-export\",\"icon\":\"\",\"position\":\"15\"},\"calendar\":{\"disabled\":\"false\",\"id\":\"calendar\",\"icon\":\"\",\"position\":\"20\"},\"announcements\":{\"disabled\":\"false\",\"id\":\"announcements\",\"icon\":\"\",\"position\":\"25\"},\"activity-log\":{\"disabled\":\"false\",\"id\":\"activity-log\",\"icon\":\"\",\"position\":\"30\"},\"surveys\":{\"disabled\":\"false\",\"id\":\"surveys\",\"icon\":\"\",\"position\":\"35\"},\"utility_backup\":{\"disabled\":\"false\",\"id\":\"utility_backup\",\"icon\":\"\",\"position\":\"40\"},\"ticket-pipe-log\":{\"disabled\":\"false\",\"id\":\"ticket-pipe-log\",\"icon\":\"\",\"position\":\"45\"},\"flexibackup\":{\"disabled\":\"false\",\"id\":\"flexibackup\",\"icon\":\"\",\"position\":\"50\"}}},\"reports\":{\"id\":\"reports\",\"icon\":\"\",\"disabled\":\"false\",\"position\":\"80\",\"children\":{\"sales-reports\":{\"disabled\":\"false\",\"id\":\"sales-reports\",\"icon\":\"\",\"position\":\"5\"},\"expenses-reports\":{\"disabled\":\"false\",\"id\":\"expenses-reports\",\"icon\":\"\",\"position\":\"10\"},\"expenses-vs-income-reports\":{\"disabled\":\"false\",\"id\":\"expenses-vs-income-reports\",\"icon\":\"\",\"position\":\"15\"},\"leads-reports\":{\"disabled\":\"false\",\"id\":\"leads-reports\",\"icon\":\"\",\"position\":\"20\"},\"timesheets-reports\":{\"disabled\":\"false\",\"id\":\"timesheets-reports\",\"icon\":\"\",\"position\":\"25\"},\"knowledge-base-reports\":{\"disabled\":\"false\",\"id\":\"knowledge-base-reports\",\"icon\":\"\",\"position\":\"30\"}}}}',1),(462,'setup_menu_active','[]',1),(463,'survey_send_emails_per_cron_run','100',1),(464,'last_survey_send_cron','',1),(465,'api_verification_id','MjUyNzgzNTl8MTc5ODB8Z29nb2xvbG98ZjU0OTk1MWMtY2U5NC00NzhjLWFkYWQtZGYyMDY0MDBiZjVl',1),(466,'api_last_verification','1781840226',1),(467,'api_product_token','eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzUxMiJ9.eyJwdXJjaGFzZV9jb2RlIjoiZjU0OTk1MWMtY2U5NC00NzhjLWFkYWQtZGYyMDY0MDBiZjVlIiwiaXRlbV9pZCI6MjUyNzgzNTksImJ1eWVyIjoiZ29nb2xvbG8iLCJwdXJjaGFzZV9jb3VudCI6MSwiYWN0aXZhdGVkX2RvbWFpbiI6Imh0dHBzOi8vd3d3LnMtbW9iLmZyLyIsImlwIjoiNjYuMTMwLjIyLjEzNCIsInB1cmNoYXNlX3RpbWUiOiIyMDI1LTAyLTE4VDA5OjM2OjQxKzExOjAwIiwiY2hlY2tfaW50ZXJ2YWwiOjYwNDgwMH0.Bih7B6TZiOfYCoiDdkKnbfb8ryDndhbA0SA8mS65dGUv1PMSVYW_wfgbnrKeNCcy5OeAOVaL6POiATYkdXAM2A',1),(471,'mailbox_enabled','1',1),(472,'mailbox_imap_server','outlook.office365.com',1),(473,'mailbox_encryption','ssl',1),(474,'mailbox_folder_scan','Boite de réception',1),(475,'mailbox_check_every','3',1),(476,'mailbox_only_loop_on_unseen_emails','1',1),(477,'sms_trigger_invoice_overdue_notice','',0),(478,'sms_trigger_invoice_due_notice','',0),(479,'sms_trigger_invoice_payment_recorded','',0),(480,'sms_trigger_estimate_expiration_reminder','',0),(481,'sms_trigger_proposal_expiration_reminder','',0),(482,'sms_trigger_proposal_new_comment_to_customer','',0),(483,'sms_trigger_proposal_new_comment_to_staff','',0),(484,'sms_trigger_contract_new_comment_to_customer','',0),(485,'sms_trigger_contract_new_comment_to_staff','',0),(486,'sms_trigger_contract_expiration_reminder','',0),(487,'sms_trigger_contract_sign_reminder_to_customer','',0),(488,'sms_trigger_staff_reminder','',0),(489,'webhooks_enabled','1',1),(490,'webhook_cron_has_run_from_cli','0',1),(491,'extended_email_enabled','1',1),(492,'flexibackup_files_backup_schedule','1',1),(493,'flexibackup_database_backup_schedule','1',1),(494,'flexibackup_remote_storage','email',1),(495,'last_flexi_backup_file','1759010145',1),(496,'last_flexi_backup_database','1757408580',1),(497,'flexibackup_retain_for_days','14',1),(498,'flexibackup_include_modules','1',1),(499,'flexibackup_include_application','1',1),(500,'flexibackup_include_uploads','1',1),(501,'flexibackup_include_assets','1',1),(502,'flexibackup_include_system','1',1),(503,'flexibackup_include_resources','1',1),(504,'flexibackup_include_media','1',1),(505,'flexibackup_include_others','1',1),(506,'flexibackup_auto_backup_to_remote_enabled','0',1),(507,'flexibackup_auto_backup_time','22:00',1),(508,'flexibackup_auto_delete_remote_backups','0',1),(509,'flexibackup_backup_name_prefix','backup_symbiose-',1),(510,'flexibackup_ftp_server','ftp.sixa2232.odns.fr',1),(511,'flexibackup_ftp_user','sixa2232',1),(512,'flexibackup_ftp_password','MUM6-qCGQ-V5u}',1),(513,'flexibackup_ftp_path','/backup-sites/Symbiose-CRM',1),(514,'flexibackup_email_address','backupcrm@symbiose-mobilite.com',1),(515,'sm_sp_tenant_id','46d42615-ade0-4e86-8a03-7f00bc033878',1),(516,'sm_sp_client_id','81fe548d-b198-41f2-b9b1-343f576973aa',1),(517,'sm_sp_cert_key_path','/home/symbior-crm/sm_secure/sm_sp_key.pem',1),(518,'sm_sp_cert_pem_path','/home/symbior-crm/sm_secure/sm_sp_cert.pem',1),(519,'sm_sp_sharepoint_host','symbiosemobilite.sharepoint.com',1),(520,'sm_sp_site_path','/sites/CRM',1),(521,'sm_sp_site_id','',1),(522,'sm_sp_drive_id','',1),(523,'sm_sp_root_folder','CRM-Backups',1),(524,'sm_sp_enabled','1',1),(525,'sm_sp_backup_schedule','daily',1),(526,'sm_sp_backup_time','03:00',1),(527,'sm_sp_retain_days','14',1),(528,'sm_sp_include_db','1',1),(529,'sm_sp_include_files','1',1),(530,'sm_sp_min_retry_minutes','180',1),(531,'sm_sp_last_attempt','1781700739',1),(532,'sm_sp_last_success','0',1),(533,'sm_sp_last_error','Private key not found: /home/symbior-crm/sm_secure/sm_sp_key.pem',1),(534,'sm_sp_sync_requested','0',1),(535,'sm_sp_last_sync_at','1781876145',1),(536,'sm_sp_last_sync_status','success',1),(537,'sm_sp_last_sync_message','provisioning: 2 clients / 2 projets. client \"Michu Inc\" team=ad58a960 drive=y docs=y arch=y | client \"Aura Finance\" team=e551c807 drive=y docs=y arch=y | project 1 channel=y folder=y | project 2 channel=y folder=y',1),(538,'ai_provider','openai',1),(539,'ai_system_prompt','You are a support representative.',1),(540,'ai_enable_ticket_summarization','0',1),(541,'ai_enable_ticket_reply_suggestions','0',1),(542,'openai_max_token','500',1),(543,'openai_our_fine_tuned_model','',1),(544,'openai_fine_tuned_model','',1),(545,'openai_fine_tuning_last_job_id','',1),(546,'openai_fine_tuning_base_model','',1),(547,'openai_use_fine_tuning','0',1),(548,'proposal_auto_convert_leads_to_client_on_client_accept','0',1),(549,'einvoice_send_as_credit_note_email_attachment','0',1),(550,'upgraded_from_version','321',1),(551,'openai_api_key','',1),(552,'openai_model','',1);

--
-- Table structure for table `tblpayment_attempts`
--

CREATE TABLE `tblpayment_attempts` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `reference` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `invoice_id` int NOT NULL,
  `amount` double NOT NULL,
  `fee` double NOT NULL,
  `payment_gateway` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblpayment_attempts`
--


--
-- Table structure for table `tblpayment_modes`
--

CREATE TABLE `tblpayment_modes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `show_on_pdf` int NOT NULL DEFAULT '0',
  `invoices_only` int NOT NULL DEFAULT '0',
  `expenses_only` int NOT NULL DEFAULT '0',
  `selected_by_default` int NOT NULL DEFAULT '1',
  `active` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblpayment_modes`
--

INSERT INTO `tblpayment_modes` VALUES (1,'Virement bancaire','',0,0,0,1,1);

--
-- Table structure for table `tblpinned_projects`
--

CREATE TABLE `tblpinned_projects` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int NOT NULL,
  `staff_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `project_id` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblpinned_projects`
--


--
-- Table structure for table `tblproject_activity`
--

CREATE TABLE `tblproject_activity` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int NOT NULL,
  `staff_id` int NOT NULL DEFAULT '0',
  `contact_id` int NOT NULL DEFAULT '0',
  `fullname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `visible_to_customer` int NOT NULL DEFAULT '0',
  `description_key` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Language file key',
  `additional_data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `dateadded` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tblproject_activity`
--

INSERT INTO `tblproject_activity` VALUES (1,1,2,0,'Loïc Goaper',0,'project_activity_uploaded_file','6b0534da8114d271beefcd2d622fd2ae.pdf','2026-06-17 21:49:19'),(2,2,2,0,'Loïc Goaper',1,'project_activity_added_team_member','Loïc Goaper','2026-06-18 14:19:14'),(3,2,2,0,'Loïc Goaper',1,'project_activity_created','','2026-06-18 14:19:14'),(4,2,2,0,'Loïc Goaper',0,'project_activity_uploaded_file','913c6c901d9b2d4cee33171471432013.pdf','2026-06-18 14:19:25'),(5,1,2,0,'Loïc Goaper',1,'project_activity_project_file_removed','document-client-projet-1.pdf','2026-06-18 14:30:16'),(6,1,2,0,'Loïc Goaper',1,'project_activity_project_file_removed','document-client-projet.pdf','2026-06-18 14:30:18'),(7,1,2,0,'Loïc Goaper',1,'project_activity_project_file_removed','sc6-staff-proj.pdf','2026-06-18 14:30:23'),(8,1,2,0,'Loïc Goaper',1,'project_activity_updated','','2026-06-18 14:40:34'),(9,3,2,0,'Loïc Goaper',1,'project_activity_added_team_member','Loïc Goaper','2026-06-18 14:51:27'),(10,3,2,0,'Loïc Goaper',1,'project_activity_created','','2026-06-18 14:51:27');

--
