Dong Shin 01.26.2011

  • PPM Changes
    • all necessary project data passed onto Financial Status Panel
    • added Program Element and FACTS PE to Create Project Panel
    • disabled changed check on Financial Data – wasn’t really needed because data save is automatic
    • new tables to support Financial Status
      • program_elements
        • CREATE TABLE `project_portfolio`.`program_elements` (
          `name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,PRIMARY KEY ( `name` )) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;

      • facts_pe
        • CREATE TABLE `project_portfolio`.`facts_pe` (
          `name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,PRIMARY KEY ( `name` )) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;

    • added program_elements and facts_pe fields to budget_centers and set relationships
      • ALTER TABLE `budget_centers` ADD `program_element` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
        ADD `facts_pe` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL
      • ALTER TABLE `budget_centers` ADD INDEX ( `program_element` )
      • ALTER TABLE `budget_centers` ADD INDEX ( `facts_pe` )
      • ALTER TABLE `budget_centers` ADD FOREIGN KEY ( `program_element` ) REFERENCES `project_portfolio`.`program_elements` (
        `name`) ON DELETE SET NULL ON UPDATE CASCADE ;

      • ALTER TABLE `budget_centers` ADD FOREIGN KEY ( `facts_pe` ) REFERENCES `project_portfolio`.`facts_pe` (
        `name`) ON DELETE SET NULL ON UPDATE CASCADE ;