HEADS UP: schema change

Jon Parise jon@csh.rit.edu
Mon, 25 Jun 2001 18:20:51 -0400


The database schema changed in the last commit when I added the
new 'task_depends' field.

To update your database, issue the follow SQL:

    alter table nag_tasks add task_depends int null;
    alter table nag_tasks alter task_depends set default -1;
    update nag_tasks set task_depends = -1;

... or some variation thereof.

-- 
Jon Parise (jon@csh.rit.edu)  .  Rochester Inst. of Technology
http://www.csh.rit.edu/~jon/  :  Computer Science House Member