Dong Shin 02.02.2011

  • PPM Changes
    • fixed a bug Funding Request not updating project_id
    • Remaining to Distribute calculation – keep subtracting Amount from FY BUDGET
    • add outlay to Reimbursable and Direct Cites
      • ALTER TABLE `funding_requests` ADD `outlay_amount` DOUBLE NULL AFTER `reimbursable_amount`
      • ALTER TABLE `direct_cites` ADD `outlay_amount` DOUBLE NULL AFTER `obligation_amount`
    • add contract info for Reimbursable in funding_request
      • ALTER TABLE `funding_requests` ADD `contract_id` INT NULL ,
        ADD INDEX ( `contract_id` )
      • ALTER TABLE `funding_requests` ADD FOREIGN KEY ( `contract_id` ) REFERENCES `project_portfolio`.`contracts` (
        `uid`) ON DELETE SET NULL ON UPDATE CASCADE ;

  • backing up FGMDEV
    • created a shell script and added to crontab – /exchange/backups/backup.sh
      • runs at 1AM everyday, keep last 3 days of data
      • ftp information (vizncon@philfeldman.com to backups directory)
      • ~4GB of data, 90 minutes package and transfer……
    • SVN – svnadmin dump /path/to/reponame > /tmp/reponame.dump ;
    • Nexus Maven Repo
      • zip up /opt/sonatype-work
    • Blog
      • zip up /opt/lampp/htdocs/blogs and /opt/lampp/SCT-Blog
      • back up MySQL Database; fgmdev_blog and sct_blog
        • /opt/lampp/bin/mysqldump -u root –password=edge fgmdev_blog > /exchange/backups/fgmdev_blog.dump