New table: tiki_projects

---

New table that allows a hierarchical project structure to be created so that projects can have sub-projects and be part of an overall programme. This new Project table is similar in layout to the existing Task Table.

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
projectId	int(14)	No	0	sequentially assigned by system
child_of	int(14)	No	-1	parent projectId to allow project hierarchy. If set to -1 then this project is the top level of an overall programme and may have sub projects
creator	varchar(200)	No		userId of the project creator
created	int(14)	No		time stamp when project is created
project_manager	varchar(200)	No		userId of the assigned project manager
last_version	int(4)	No	0	tracks which is the latest version in table tiki_projects_history
started	int(14)			time stamp for formal project start date
actual_complete	int(14)			time stamp for project actual completion date

Indexes:

Keyname	Type	FieldId(s)
PRIMARY	PRIMARY	projectId + child_of
creator	UNIQUE	creator + created

Table of contents for section:

Table of contents for main document: