Dong Shin 06.05.2012

  • checked in fresh copy of ProjPortfolioMgrClient to SVN and moved ProjPortfolioMgrClient to old
  • deployed new PPM and PA at the Fort. new fields seem working
  • User Management errors – Database Null?
    • fixed
  • Delete User errors – fixed
    • DBUpdateSQLs06052012.sql in src/main/resources/database directory
    • caused by cascading foreign keys… this fixes it
      • ALTER TABLE `projects` DROP FOREIGN KEY `projects_ibfk_3` ;
        ALTER TABLE `projects` ADD FOREIGN KEY ( `proj_mgr_login` ) REFERENCES `project_portfolio`.`users` (        `login`) ON DELETE SET NULL ON UPDATE CASCADE ;ALTER TABLE `projects` DROP FOREIGN KEY `projects_ibfk_2` ;
        ALTER TABLE `projects` ADD FOREIGN KEY ( `proj_admin_login` ) REFERENCES `project_portfolio`.`users` (`login`) ON DELETE SET NULL ON UPDATE CASCADE ;ALTER TABLE `projects` DROP FOREIGN KEY `projects_ibfk_1` ;
        ALTER TABLE `projects` ADD FOREIGN KEY ( `portfolio_mgr_login` ) REFERENCES `project_portfolio`.`users` (`login`) ON DELETE SET NULL ON UPDATE CASCADE ;ALTER TABLE `projects` DROP FOREIGN KEY `projects_ibfk_4` ;
        ALTER TABLE `projects` ADD FOREIGN KEY ( `portfolio_admin_login` ) REFERENCES `project_portfolio`.`users` (`login`) ON DELETE SET NULL ON UPDATE CASCADE ;