Hi there,
I need to add 3 new custom columns to the link table between "email" and "email_address" (email_email_address).
The 3 columns are : 2 varchars fields and 1 datetime
To add them I edited my already existant "custom/Espo/Custom/Resources/metadata/entityDefs/Email.json" file and added the following code (based on the default Espo entityDefs/Email.json).
Then, as usual I run
, no error is triggered or logged
BUT
the table is unchanged, nothing happened.
Regards,
Firyo.
I need to add 3 new custom columns to the link table between "email" and "email_address" (email_email_address).
The 3 columns are : 2 varchars fields and 1 datetime
To add them I edited my already existant "custom/Espo/Custom/Resources/metadata/entityDefs/Email.json" file and added the following code (based on the default Espo entityDefs/Email.json).
Code:
"toEmailAddresses": { "type": "hasMany", "entity": "EmailAddress", "relationName": "emailEmailAddress", "conditions": { "addressType": "to" }, "additionalColumns": { "addressType": { "type": "varchar", "len": "4" }, "mailLastStatus": { "type": "varchar" }, "mailLastDateTime": { "type": "datetime" }, "messageId": { "type": "varchar" } } }, "ccEmailAddresses": { "type": "hasMany", "entity": "EmailAddress", "relationName": "emailEmailAddress", "conditions": { "addressType": "cc" }, "additionalColumns": { "addressType": { "type": "varchar", "len": "4" }, "mailLastStatus": { "type": "varchar" }, "mailLastDateTime": { "type": "datetime" }, "messageId": { "type": "varchar" } }, "layoutDefaultSidePanelDisabled": true }, "bccEmailAddresses": { "type": "hasMany", "entity": "EmailAddress", "relationName": "emailEmailAddress", "conditions": { "addressType": "bcc" }, "additionalColumns": { "addressType": { "type": "varchar", "len": "4" }, "mailLastStatus": { "type": "varchar" }, "mailLastDateTime": { "type": "datetime" }, "messageId": { "type": "varchar" } },
Code:
php ./rebuild.php
BUT
the table is unchanged, nothing happened.
Regards,
Firyo.
Comment