...
Learn about the property’s settings in that article. In this article we focus on the property settings that are needed for overriding.
Note: Be sure to use a positionForm value that does not yet exist. Have a look at the base table’s property definitions to see the positionForm values in each in order to pick the position you like the property to show up in.
See these lines from the property’s settings:
...
Based on the property definition settings above, we’d we create the following MySQL table:
#__configbox_external_product_appends
As per convention, custom tables are prefixed as ‘external' in general, extension tables use the base table’s name followed by the word ‘appends’.
Column name | Type | Notes |
|---|---|---|
product_id | INT UNSIGNED PRIMARY KEY | This relates to your ‘foreignTableKey’. The column should be the table’s primary keyIt’s recommended to make it a primary key column and of same type as the primary key of the base table. On top of that set a foreign key constraint with ON DELETE CASCADE, ON UPDATE CASCADE. |
is_new | TINYINT UNSIGNED | The column for the property ‘is_new’ |
For creating the DB (extension table in an organized way, see Application Update Script) .
Test the outcome
For troubleshooting, have a look at the configbox_errors log file for model configuration issues. configbox_upgrade_errors for any DB schema change problems.