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