Adding a New Column To Schema

1. Add the column to the database on the local system where we use sqlite:

   % cd $HOME/Reg
   % sqlite3 retreatcenter.db
   sqlite> alter table program add column status text default '' not null;
   sqlite> .quit
   

2. Update the sql script 'mkprog' in case we need to recreate the 'program' table from scratch (unlikely):

   % cd $HOME/Reg/migration
   % vi mkprog
     and add: status text not null default ''
     at the bottom of the 'create table program ('.
   

3. Update the appropriate Catalyst Model class:

   % cd $HOME/Reg/lib/RetreatCenterDB
   % vi Program.pm
   
   There will be a line like this:
   
   __PACKAGE__->add_columns(qw/
   
   at the bottom of that statement add:
   
       status
   

4. In the same model .pm file as above add documentation of the new column. Add 'status' and its definition (and usage) to the bottom (after __END__) in alphabetical order. If the definition spans more than one line the second and subsequent lines should be indented with 4 spaces.

5. Check that the new model matches the database and generate the new schema doc:

   % cd $HOME/Reg/lib/RetreatCenterDB
   % ./check_doc
   % ./gen_doc
   

6. If the new column is a foreign key to another table you will likely want to add a relationship (belongs_to or has_many or ...). See the other model classes, find a similar situation, and mimic that.

7. This should complete the addition of the column. Now to use it in the Controller classes.

8. Before pushing all of these changes to kali we need to log in to kali and alter the 'program' table in the MySQL database there. Use the same alter table line as above.

   There is no need alter the mysql table on newkali. The entire schema and data will soon be copied from kali to newkali.