Clean up schema for table lfs_objects_projects
Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.
From https://gitlab.com/gitlab-com/infrastructure/issues/1709 (private to GitLab employees):
-
Wrong data type: created_at should be timestamptz -
Wrong data type: updated_at should be timestamptz -
Missing constraint: created_at NOT NULL -
Missing constraint: updated_at NOT NULL -
Missing FK: project_id -> projects -
Missing FK: lfs_object_id -> lfs_objects -
Missing constraint: UNIQUE (lfs_object_id, project_id) (1848 entries violate this rule)
Edited by 🤖 GitLab Bot 🤖