Dong Shin 06.26.2012

  • working on Project Totals display
    • need new table – yearly_totals
      • # create new table yearly_totals
        CREATE TABLE `yearly_totals` (
        `uid` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
        `project_id` INT NOT NULL ,
        `fiscal_year` INT NOT NULL ,
        `allocated_amount` DOUBLE NOT NULL ,
        INDEX ( `project_id` )
        ) ENGINE = InnoDB;ALTER TABLE `yearly_totals` ADD FOREIGN KEY ( `project_id` ) REFERENCES `project_portfolio`.`projects` (
        `uid`) ON DELETE CASCADE ON UPDATE CASCADE ;
    • created DataGrid to display the yearly totals