[2020-08-25 10:26:13] Espo.DEBUG: Schema\Converter - Start: building schema [] [] [2020-08-25 10:26:13] Espo.DEBUG: Rebuild Database for entities: [Account] with dependent entities: [Account, EmailAddress, PhoneNumber, Lead, Document, Attachment, User, TargetList, Contact, VoucherSize, Email, EmailAccount, EmailFolder, EmailFilter, InboundEmail, EmailTemplate, Team, LayoutSet, Portal, KnowledgeBaseArticle, KnowledgeBaseCategory, Case, Task, Call, Meeting, Note, PortalRole, LayoutRecord, Role, EmailTemplateCategory, Tag, CampaignLogRecord, EmailQueueItem, MassEmail, Campaign, Template, CampaignTrackingUrl, Opportunity, UserData, Preferences, DashboardTemplate, DocumentFolder] [] [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Email {"tableName":"email_email_account","parameters":{" type":"manyMany","entity":"EmailAccount","relation Name":"emailEmailAccount","key":"id","foreignKey": "id","midKeys":["emailId","emailAccountId"],"foreign":"emails"}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Email {"tableName":"email_inbound_email","parameters":{" type":"manyMany","entity":"InboundEmail","relation Name":"emailInboundEmail","key":"id","foreignKey": "id","midKeys":["emailId","inboundEmailId"],"foreign":"emails"}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Email {"tableName":"email_email_address","parameters":{" type":"manyMany","entity":"EmailAddress","foreignK ey":"id","foreign":null,"midKeys":["emailId","emailAddressId"],"relationName":"emailEmailAddress","conditions":{ "addressType":"rto"},"additionalColumns":{"address Type":{"type":"varchar","len":"4"}}}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Email {"tableName":"email_user","parameters":{"type":"ma nyMany","entity":"User","relationName":"emailUser" ,"key":"id","foreignKey":"id","midKeys":["emailId","userId"],"foreign":"emails","additionalColumns":{"isRead": {"type":"bool","default":false},"isImportant":{"ty pe":"bool","default":false},"inTrash":{"type":"boo l","default":false},"folderId":{"type":"varchar"," default":null,"maxLength":24}}}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Email {"tableName":"entity_user","parameters":{"type":"m anyMany","entity":"User","relationName":"entityUse r","midKeys":["entityId","userId"],"conditions":{"entityType":"Email"},"additionalCo lumns":{"entityType":{"type":"varchar","len":100}} }} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Email {"tableName":"entity_team","parameters":{"type":"m anyMany","entity":"Team","relationName":"entityTea m","midKeys":["entityId","teamId"],"conditions":{"entityType":"Email"},"additionalCo lumns":{"entityType":{"type":"varchar","len":100}} }} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for InboundEmail {"tableName":"inbound_email_team","parameters":{"t ype":"manyMany","entity":"Team","relationName":"in boundEmailTeam","key":"id","foreignKey":"id","midK eys":["inboundEmailId","teamId"],"foreign":"inboundEmails"}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Note {"tableName":"note_user","parameters":{"type":"man yMany","entity":"User","relationName":"noteUser"," key":"id","foreignKey":"id","midKeys":["noteId","userId"],"foreign":"notes"}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Note {"tableName":"note_portal","parameters":{"type":"m anyMany","entity":"Portal","relationName":"notePor tal","key":"id","foreignKey":"id","midKeys":["noteId","portalId"],"foreign":"notes"}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Note {"tableName":"note_team","parameters":{"type":"man yMany","entity":"Team","relationName":"noteTeam"," key":"id","foreignKey":"id","midKeys":["noteId","teamId"],"foreign":"notes"}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Portal {"tableName":"knowledge_base_article_portal","para meters":{"type":"manyMany","entity":"KnowledgeBase Article","relationName":"knowledgeBaseArticlePorta l","key":"id","foreignKey":"id","midKeys":["portalId","knowledgeBaseArticleId"],"foreign":"portals"}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Portal {"tableName":"portal_portal_role","parameters":{"t ype":"manyMany","entity":"PortalRole","relationNam e":"portalPortalRole","key":"id","foreignKey":"id" ,"midKeys":["portalId","portalRoleId"],"foreign":"portals"}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Portal {"tableName":"portal_user","parameters":{"type":"m anyMany","entity":"User","relationName":"portalUse r","key":"id","foreignKey":"id","midKeys":["portalId","userId"],"foreign":"portals"}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for PortalRole {"tableName":"portal_role_user","parameters":{"typ e":"manyMany","entity":"User","relationName":"port alRoleUser","key":"id","foreignKey":"id","midKeys" :["portalRoleId","userId"],"foreign":"portalRoles"}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Role {"tableName":"role_team","parameters":{"type":"man yMany","entity":"Team","relationName":"roleTeam"," key":"id","foreignKey":"id","midKeys":["roleId","teamId"],"foreign":"roles"}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Role {"tableName":"role_user","parameters":{"type":"man yMany","entity":"User","relationName":"roleUser"," key":"id","foreignKey":"id","midKeys":["roleId","userId"],"foreign":"roles"}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Team {"tableName":"team_user","parameters":{"type":"man yMany","entity":"User","relationName":"teamUser"," key":"id","foreignKey":"id","midKeys":["teamId","userId"],"foreign":"teams","additionalColumns":{"role":{"t ype":"varchar","len":100}}}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for User {"tableName":"entity_email_address","parameters":{ "type":"manyMany","entity":"EmailAddress","relatio nName":"entityEmailAddress","midKeys":["entityId","emailAddressId"],"conditions":{"entityType":"User"},"additionalCol umns":{"entityType":{"type":"varchar","len":100}," primary":{"type":"bool","default":false}}}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for User {"tableName":"entity_phone_number","parameters":{" type":"manyMany","entity":"PhoneNumber","relationN ame":"entityPhoneNumber","midKeys":["entityId","phoneNumberId"],"conditions":{"entityType":"User"},"additionalCol umns":{"entityType":{"type":"varchar","len":100}," primary":{"type":"bool","default":false}}}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for User {"tableName":"target_list_user","parameters":{"typ e":"manyMany","entity":"TargetList","relationName" :"targetListUser","key":"id","foreignKey":"id","mi dKeys":["userId","targetListId"],"foreign":"users","additionalColumns":{"optedOut" :{"type":"bool"}}}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for User {"tableName":"account_portal_user","parameters":{" type":"manyMany","entity":"Account","relationName" :"AccountPortalUser","key":"id","foreignKey":"id", "midKeys":["userId","accountId"],"foreign":"portalUsers"}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for User {"tableName":"call_user","parameters":{"type":"man yMany","entity":"Call","relationName":"callUser"," key":"id","foreignKey":"id","midKeys":["userId","callId"],"foreign":"users","additionalColumns":{"status":{ "type":"varchar","len":"36","default":"None"}} }} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for User {"tableName":"meeting_user","parameters":{"type":" manyMany","entity":"Meeting","relationName":"meeti ngUser","key":"id","foreignKey":"id","midKeys":["userId","meetingId"],"foreign":"users","additionalColumns":{"status":{ "type":"varchar","len":"36","default":"None"}} }} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Account {"tableName":"account_target_list","parameters":{" type":"manyMany","entity":"TargetList","relationNa me":"accountTargetList","key":"id","foreignKey":"i d","midKeys":["accountId","targetListId"],"foreign":"accounts","additionalColumns":{"optedO ut":{"type":"bool"}}}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Account {"tableName":"account_document","parameters":{"typ e":"manyMany","entity":"Document","relationName":" accountDocument","key":"id","foreignKey":"id","mid Keys":["accountId","documentId"],"foreign":"accounts"}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Account {"tableName":"account_contact","parameters":{"type ":"manyMany","entity":"Contact","relationName":"ac countContact","key":"id","foreignKey":"id","midKey s":["accountId","contactId"],"foreign":"accounts","additionalColumns":{"role": {"type":"varchar","len":100},"isInactive":{"type": "bool","default":false}}}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Call {"tableName":"call_lead","parameters":{"type":"man yMany","entity":"Lead","relationName":"callLead"," key":"id","foreignKey":"id","midKeys":["callId","leadId"],"foreign":"calls","additionalColumns":{"status":{ "type":"varchar","len":"36","default":"None"}} }} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Call {"tableName":"call_contact","parameters":{"type":" manyMany","entity":"Contact","relationName":"callC ontact","key":"id","foreignKey":"id","midKeys":["callId","contactId"],"foreign":"calls","additionalColumns":{"status":{ "type":"varchar","len":"36","default":"None"}} }} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Campaign {"tableName":"campaign_target_list_excluding","par ameters":{"type":"manyMany","entity":"TargetList", "relationName":"campaignTargetListExcluding","key" :"id","foreignKey":"id","midKeys":["campaignId","targetListId"],"foreign":"campaignsExcluding"}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Campaign {"tableName":"campaign_target_list","parameters":{ "type":"manyMany","entity":"TargetList","relationN ame":"campaignTargetList","key":"id","foreignKey": "id","midKeys":["campaignId","targetListId"],"foreign":"campaigns"}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Case {"tableName":"case_knowledge_base_article","parame ters":{"type":"manyMany","entity":"KnowledgeBaseAr ticle","relationName":"caseKnowledgeBaseArticle"," key":"id","foreignKey":"id","midKeys":["caseId","knowledgeBaseArticleId"],"foreign":"cases"}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Case {"tableName":"case_contact","parameters":{"type":" manyMany","entity":"Contact","relationName":"caseC ontact","key":"id","foreignKey":"id","midKeys":["caseId","contactId"],"foreign":"cases"}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Contact {"tableName":"tag_contact","parameters":{"type":"m anyMany","entity":"Tag","relationName":"tagContact ","key":"id","foreignKey":"id","midKeys":["contactId","tagId"],"foreign":"beneficiaries"}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Contact {"tableName":"contact_document","parameters":{"typ e":"manyMany","entity":"Document","relationName":" contactDocument","key":"id","foreignKey":"id","mid Keys":["contactId","documentId"],"foreign":"contacts"}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Contact {"tableName":"contact_target_list","parameters":{" type":"manyMany","entity":"TargetList","relationNa me":"contactTargetList","key":"id","foreignKey":"i d","midKeys":["contactId","targetListId"],"foreign":"contacts","additionalColumns":{"optedO ut":{"type":"bool"}}}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Contact {"tableName":"contact_meeting","parameters":{"type ":"manyMany","entity":"Meeting","relationName":"co ntactMeeting","key":"id","foreignKey":"id","midKey s":["contactId","meetingId"],"foreign":"contacts","additionalColumns":{"status ":{"type":"varchar","len":"36","default":"None"}}} } [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Contact {"tableName":"contact_opportunity","parameters":{" type":"manyMany","entity":"Opportunity","relationN ame":"contactOpportunity","key":"id","foreignKey": "id","midKeys":["contactId","opportunityId"],"foreign":"contacts","additionalColumns":{"role": {"type":"varchar","len":50}}}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Document {"tableName":"document_lead","parameters":{"type": "manyMany","entity":"Lead","relationName":"documen tLead","key":"id","foreignKey":"id","midKeys":["documentId","leadId"],"foreign":"documents"}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Document {"tableName":"document_opportunity","parameters":{ "type":"manyMany","entity":"Opportunity","relation Name":"documentOpportunity","key":"id","foreignKey ":"id","midKeys":["documentId","opportunityId"],"foreign":"documents"}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for KnowledgeBaseArticle {"tableName":"knowledge_base_article_knowledge_bas e_category","parameters":{"type":"manyMany","entit y":"KnowledgeBaseCategory","relationName":"knowled geBaseArticleKnowledgeBaseCategory","key":"id","fo reignKey":"id","midKeys":["knowledgeBaseArticleId","knowledgeBaseCategor yId"],"foreign":"articles"}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Lead {"tableName":"lead_target_list","parameters":{"typ e":"manyMany","entity":"TargetList","relationName" :"leadTargetList","key":"id","foreignKey":"id","mi dKeys":["leadId","targetListId"],"foreign":"leads","additionalColumns":{"optedOut" :{"type":"bool"}}}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Lead {"tableName":"lead_meeting","parameters":{"type":" manyMany","entity":"Meeting","relationName":"leadM eeting","key":"id","foreignKey":"id","midKeys":["leadId","meetingId"],"foreign":"leads","additionalColumns":{"status":{ "type":"varchar","len":"36","default":"None"}} }} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for MassEmail {"tableName":"mass_email_target_list_excluding","p arameters":{"type":"manyMany","entity":"TargetList ","relationName":"massEmailTargetListExcluding","k ey":"id","foreignKey":"id","midKeys":["massEmailId","targetListId"],"foreign":"massEmailsExcluding"}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for MassEmail {"tableName":"mass_email_target_list","parameters" :{"type":"manyMany","entity":"TargetList","relatio nName":"massEmailTargetList","key":"id","foreignKe y":"id","midKeys":["massEmailId","targetListId"],"foreign":"massEmails"}} [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: prepareManyMany invoked for Tag {"tableName":"entity_team","parameters":{"type":"m anyMany","entity":"Team","relationName":"EntityTea m","midKeys":["entityId","teamId"],"conditions":{"entityType":"Tag"},"additionalColu mns":{"entityType":{"type":"varchar","len":100}}} } [] [2020-08-25 10:26:14] Espo.DEBUG: DBAL: Table [entity_team] exists. [] [] [2020-08-25 10:26:14] Espo.DEBUG: Schema\Converter - End: building schema [] [] [2020-08-25 10:26:15] Espo.INFO: SCHEMA, Execute Query: CREATE FULLTEXT INDEX IDX_SYSTEM_FULL_TEXT_SEARCH ON `contact` (`phonenumber`, `kobo_comment`, `ben_s_x_mid`, `phonenumber2`, `kobo_id`, `survey_collector`, `first_name`, `last_name`) [] [] [2020-08-25 10:26:15] Espo.INFO: SCHEMA, Execute Query: CREATE INDEX IDX_VOUCHER_SIZE_ID ON `contact` (`voucher_size_id`) [] []