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:
Table of contents for main document: