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