Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Clean stored procedures and tables #969

Closed
5 tasks done
jerricotandelacruz opened this issue Apr 10, 2024 · 2 comments
Closed
5 tasks done

Clean stored procedures and tables #969

jerricotandelacruz opened this issue Apr 10, 2024 · 2 comments
Assignees

Comments

@jerricotandelacruz
Copy link
Collaborator

jerricotandelacruz commented Apr 10, 2024

  • Remove unused stored procedures
  • Remove unused tables
  • Remove column OSSsponsor in table ProjectApprovals (GHManagement)
  • Remove column ApproverUserPrincipalName in table ProjectApprovals (GHManagement)
  • Format create table syntax
@jerricotandelacruz jerricotandelacruz self-assigned this May 17, 2024
@jerricotandelacruz
Copy link
Collaborator Author

jerricotandelacruz commented May 28, 2024

  • Create new folder for new tables
  • Create new folder for new stored procedures
  • Rename all existing tables via post-deployment

@jerricotandelacruz
Copy link
Collaborator Author

jerricotandelacruz commented Jun 5, 2024

  • ActivityTypes > ActivityType
  • CommunityApprovals > ApprovalRequest
  • ApprovalRequestApprovers > ApprovalRequestApprover
  • Communities > Community
  • CommunityActivities > CommunityActivity
  • CommunityActivitiesContributionAreas > CommunitylActivityContributionArea 
  • CommunityActivitiesHelpTypes > CommunityActivityHelpType
  • CommunityApprovalRequests > CommunityApprovalRequest
  • CommunityApproversList > CommunityApprover
  • CommunityMembers > CommunityMember
  • CommunitySponsors > CommunitySponsor
  • CommunityTags > CommunityTag
  • ContributionAreas > ContributionArea
  • ExternalLinks > ExternalLink
  • GitHubAccess > GitHubAccessDirectoryGroup
  • GitHubCopilot > GitHubCopilot
  • GitHubCopilotApprovalRequests > GitHubCopilotApprovalRequest
  • Category > GuidanceCategory
  • CategoryArticle > GuidanceCategoryArticle
  • Organizations > Organization
  • OrganizationAcess > OrganizationAccess
  • OrganizationAccessApprovalRequests > OrganizationAccessApprovalRequest
  • OrganizationApprovalRequests > OrganizationApprovalRequest
  • OSSContributionSponsors > OSSContributionSponsor
  • RegionalOrganizations > RegionalOrganization
  • RelatedCommunities > RelatedCommunity
  • Projects > Repository
  • ProjectApprovals > RepositoryApproval
  • ApprovalTypes > RepositoryApprovalType
  • Approvers > RepositoryApprover
  • RepoOwners > RepositoryOwner
  • RepoTopics > RepositoryTopic
  • Users > User

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment