wtf-tracker-cvs

[Gryphon S. <gry...@us...>]

Update of /cvsroot/wtf-tracker/wtf/db/migration
In directory sc8-pr-cvs9.sourceforge.net:/tmp/cvs-serv17860/db/migration

Added Files:
	1.02_to_1.03.sql 
Log Message:
Changes to support the addition of feature request 1618513: vacation scheduler and OOO calendar

--- NEW FILE: 1.02_to_1.03.sql ---
# SQL to migrate the database from release 1.02 (or 1.02a) to 1.03

ALTER TABLE codeline ADD UNIQUE product(product);
UPDATE authz SET ordering = ordering + 1 WHERE ordering > 2;
INSERT INTO authz ( name, ordering, description ) VALUES ( 'ooo_calendar', 3, 'User can view a calendar of company-wide vacation and sick days taken by all employees.' );
INSERT INTO authz_employee ( authz_id, employee_id ) SELECT 9, id FROM employee WHERE active = 1;