Difference between revisions of "Freeside:1.7:Documentation:Developer:Schema changes"

Latest revision as of 11:24, 20 July 2009

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

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 tablename for 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.

@@ Line 7: / Line 7: @@
 * 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]]
+* 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 ===