folders

Purpose: Stores data pertaining to personal folders.
Note: System folders are build automatically from the modules table.
Joins: users tables.

FieldTypePurpose
idint(4)Primary Key – auto increment.
ownerIDint(10) unsignedID of the user who's folder it is.
nametextTitle of the folder as displayed in the user interface.
createddatetimeDatetime record of when the folder was created
colorenum('yellow','red','green','blue','gray')Colour preference for the folder
deleteddatetimeDatetime when deleted. Active folders have this field as NULL