Dong Shin 06.15.2012

  • Copy Project capability wouldn’t quite do the jobs users wanted to do because it doesn’t copy of the monthly financial data. We proposed that another functionality to copy/duplicate entire project data.
  • working on duplicating project data
  • changing database structure and logging in to DBUpdateSQLs06152012.sql
  • copy a project
    • INSERT INTO projects (
      project_number, title, exec_summary, description, location, begin_year, end_year,
      total_budget, proj_mgr_login, proj_admin_login, portfolio_mgr_login, portfolio_admin_login,
      priority, services, TRL_start, TRL_current, TRL_end, TCL_start, TCL_current, TCL_end,
      TP_start, TP_current, TP_end)
      SELECT project_number, title, exec_summary, description, location, begin_year, end_year,
      total_budget, proj_mgr_login, proj_admin_login, portfolio_mgr_login, portfolio_admin_login,
      priority, services, TRL_start, TRL_current, TRL_end, TCL_start, TCL_current, TCL_end,
      TP_start, TP_current, TP_end
      FROM projects
      WHERE uid=0