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:27] – [3. Create an upgrade script] tmccanna | newdevs:code:add-fields [2024/03/28 22:15] (current) – [3. Edit seed data and create an upgrade script] sandbergja | ||
---|---|---|---|
Line 12: | Line 12: | ||
Add the fields in the "class id=" | Add the fields in the "class id=" | ||
- | ''< | + | ''< |
- | '' | + | **'' |
+ | **''< | ||
+ | '' | ||
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 19: | 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 32: | 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. | + | 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. |
+ | |||
+ | For more information on upgrade scripts, see [[newdevs: | ||
+ | |||
newdevs/code/add-fields.1627597635.txt.gz · Last modified: 2022/02/10 13:34 (external edit)