How do I add fields to the opportunities table so that they propagate?
From within Studio > Opportunities > Fields
I added fields. Pardon, I don't understand the next step to effect a change on the database structure and GUI for creating and viewing opportunities.
The Fields that are available for the module are listed here by Field Name.
To configure the properties for a field, click the Field Name.
To create a new field, click Add Field. The label along with the other properties of the new field can be edited after creation by clicking the Field Name.
After the module is deployed, the new fields created in Module Builder are regarded as standard fields in the deployed module in Studio.
Yet, there's no change to the underlying database:
mysql>
mysql> describe sugarcrm.opportunities;
+------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+-------+
| id | char(36) | NO | PRI | NULL | |
| name | varchar(50) | YES | MUL | NULL | |
| date_entered | datetime | YES | | NULL | |
| date_modified | datetime | YES | | NULL | |
| modified_user_id | char(36) | YES | | NULL | |
| created_by | char(36) | YES | | NULL | |
| description | text | YES | | NULL | |
| deleted | tinyint(1) | YES | | 0 | |
| assigned_user_id | char(36) | YES | MUL | NULL | |
| opportunity_type | varchar(255) | YES | | NULL | |
| campaign_id | char(36) | YES | | NULL | |
| lead_source | varchar(50) | YES | | NULL | |
| amount | double | YES | | NULL | |
| amount_usdollar | double | YES | | NULL | |
| currency_id | char(36) | YES | | NULL | |
| date_closed | date | YES | | NULL | |
| next_step | varchar(100) | YES | | NULL | |
| sales_stage | varchar(255) | YES | | NULL | |
| probability | double | YES | | NULL | |
+------------------+--------------+------+-----+---------+-------+
19 rows in set (0.00 sec)
mysql>
Nor do the additional fields appear in the GUI when at "create opportunity".
What do I need to do to cause the fields I created in the Studio
to actually get created, not just in the database, but in the interface for SugarCRM?
Surely I don't have to delve into the PHP?