newdevs:code:add-fields
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
newdevs:code:add-fields [2021/07/29 18:30] – [1. Update the fieldmapper] tmccanna | newdevs:code:add-fields [2024/03/28 22:15] (current) – [3. Edit seed data and create an upgrade script] sandbergja | ||
---|---|---|---|
Line 15: | Line 15: | ||
**''< | **''< | ||
**''< | **''< | ||
- | </ | + | '' |
The field name must match the column name that you add to the database table. The ' | The field name must match the column name that you add to the database table. The ' | ||
Line 21: | Line 21: | ||
===== 2. Update the schema ===== | ===== 2. Update the schema ===== | ||
- | New installations of Evergreen will use this code when the database tables are created. | + | New installations of Evergreen will use the code in the Pg folder |
File location: Open-ILS\src\sql\Pg\005.schema.actors.sql | File location: Open-ILS\src\sql\Pg\005.schema.actors.sql | ||
Line 34: | Line 34: | ||
- | ===== 3. Create | + | ===== 3. Edit seed data and create |
- | Upgrade | + | Updates to the seed data files as well as upgrade |
File location: Open-ILS\src\sql\Pg\upgrade\XXXX.federal_codes.sql | File location: Open-ILS\src\sql\Pg\upgrade\XXXX.federal_codes.sql | ||
'' | '' | ||
- | '' | + | '' |
'' | '' | ||
- | If you are developing an upgrade script to submit to the Evergreen community, the new upgrade script you create will likely be more complicated. See other examples in the upgrade folder. The " | + | If you are developing an upgrade script to submit to the Evergreen community, the new upgrade script you create will likely be more complicated. See other examples in the upgrade folder. The " |
+ | |||
+ | For more information on upgrade scripts, see [[newdevs: | ||
+ | |||
newdevs/code/add-fields.txt · Last modified: 2024/03/28 22:15 by sandbergja