Difference between revisions of "Freeside:1.7:Documentation:Developer:Schema changes"
From Freeside
Lilmansplace (talk | contribs) |
(Spam removal) |
||
| (11 intermediate revisions by 4 users not shown) | |||
| Line 6: | Line 6: | ||
=== Essential documentation === | === Essential documentation === | ||
| − | * | + | * The upgrade script will automatically handle new tables as well as new columns, removed columns and changes to indices. Column changes (other than NULLability) are '''not''' handled. |
| − | * | + | * If other schema changes are required (such as changed columns, renamed or removed tables, etc.), add a quick note to the upgrade instructions at [[Freeside:1.7:Documentation:Upgrading]] and/or [[Freeside:1.9:Documentation:Upgrading-HEAD]] |
=== Skeleton class autogeneration === | === Skeleton class autogeneration === | ||
| Line 16: | Line 16: | ||
* Edit the resulting FS/FS/table.pm | * Edit the resulting FS/FS/table.pm | ||
* FS/MANIFEST is updated and FS/t/table.t is added. Don't forget to cvs add FS/FS/table.pm and FS/t/table.t and check them in. | * FS/MANIFEST is updated and FS/t/table.t is added. Don't forget to cvs add FS/FS/table.pm and FS/t/table.t and check them in. | ||
| + | |||
| + | === Required Documentation === | ||
| + | * For new tables: add to FS/FS.pm | ||
=== Optional: Documentation looking for adopters or innovative autogeneration === | === Optional: Documentation looking for adopters or innovative autogeneration === | ||
| − | |||
* somehwat neglected: httemplate/docs/schema.html | * somehwat neglected: httemplate/docs/schema.html | ||
* really neglected: httemplate/docs/schema.dia | * really neglected: httemplate/docs/schema.dia | ||
Latest revision as of 12:24, 20 July 2009
Contents
Schema.pm
- Required
- Edit the big data structure in FS/FS/Schema.pm and add your tables and columns
Essential documentation
- The upgrade script will automatically handle new tables as well as new columns, removed columns and changes to indices. Column changes (other than NULLability) are not handled.
- If other schema changes are required (such as changed columns, renamed or removed tables, etc.), add a quick note to the upgrade instructions at Freeside:1.7:Documentation:Upgrading and/or Freeside:1.9:Documentation:Upgrading-HEAD
Skeleton class autogeneration
- For new tables. Optional but recommended. We're trying to save you work!
- Make sure the tables have been added to FS/FS/Schema.pm and run
make install-perl-modules - From the root freeside directory, run
bin/generate-table-module tablenamefor each table. - Edit the resulting FS/FS/table.pm
- FS/MANIFEST is updated and FS/t/table.t is added. Don't forget to cvs add FS/FS/table.pm and FS/t/table.t and check them in.
Required Documentation
- For new tables: add to FS/FS.pm
Optional: Documentation looking for adopters or innovative autogeneration
- somehwat neglected: httemplate/docs/schema.html
- really neglected: httemplate/docs/schema.dia
