History: Project Management - New table tiki_projects_history

!::New table: tiki_projects_history::
---
New Table so that an edit history for Projects can be maintained. Uses a similar approach as already exists for Task History.

All the new fields identified so far are as follows, but this is highly likely to be changed/refined once the development is under way:

!!!Tables:
||__::Field::__|__::Type::__|__::Null::__|__::Default::__|__::Comments::__
belongs_to_project| int(14) | No |  | projectId that this is a history record of
project_version| int(14) | No | 0 | sequential record version of the project
project_title| varchar(200) |  |  | title of the project
project_description| text |  |  | description of the project
last editor| varchar(200) |  |  | userId of whoever edited the project last
jeopardy_status| char(1) | No | g | history record of red, amber, green designation of project status
priority| int(2) |  | 1 | history record of project priority 1-5 (1-lowest, 5-highest)
target_complete| int(14) |  |  | history record of time stamp for formal project target completion date
 ||

!!!Indexes:
||__::Keyname::__|__::Type::__|__::FieldId(s)::__
PRIMARY| PRIMARY | belongs_to_project + project_version
 ||

Table of contents for section:{toc pagename="Project Management - DB Table design" maxdepth="1"}

Table of contents for main document:{toc pagename="Project Management Development" maxdepth="1"}