Dong Shin 07.11.2012

  • bugs – not deleting Funding Requests when a project is deleted
    • sounds like database set up is not up-to-date, will check on-site tomorrow
  • PPM
    • corrected all database scripts to use project_portfolio
  • PA
    • configurable columns display – done
    • database update – added visible column in obligation_outlay_types table, FACTS set to invisible
      • ALTER TABLE `obligation_outlay_types` ADD `visible` BOOLEAN NULL DEFAULT NULL;
        UPDATE `obligation_outlay_types` SET `visible` = ‘1’ WHERE `obligation_outlay_types`.`uid` =1;
        UPDATE `obligation_outlay_types` SET `visible` = ‘1’ WHERE `obligation_outlay_types`.`uid` =2;
        UPDATE `obligation_outlay_types` SET `visible` = ‘1’ WHERE `obligation_outlay_types`.`uid` =3;
        UPDATE `obligation_outlay_types` SET `visible` = ‘1’ WHERE `obligation_outlay_types`.`uid` =4;
        UPDATE `obligation_outlay_types` SET `visible` = ‘1’ WHERE `obligation_outlay_types`.`uid` =5;
        UPDATE `obligation_outlay_types` SET `visible` = ‘0’ WHERE `obligation_outlay_types`.`uid` =6;