Skip to content

Create new table for tracking private project creation/deletion

To have better oversight over private projects created, we should track their creation in a database. When created, a new entry would be populated containing the user ID, the project ID, and the date created. There should be a few extra columns that will be populated when the project is triggered for deletion as well which will help give us better insight into these projects. Below are the columns I'm initially thinking of tracking:

Name type Is PK Nullable
userId varchar(63) X N
projectId int(10) X N
projectPath varcahr(255) X N
parentProject int(10) Y
dateCreated datetime N
dateDeleted datetime Y
Edited by Martin Lowe