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.

Sign up for GitHub

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

Jump to bottom

Cleanup db #707

Open
6 of 14 tasks
Katrix opened this issue Nov 15, 2018 · 0 comments
Open
6 of 14 tasks

Cleanup db #707

Katrix opened this issue Nov 15, 2018 · 0 comments
Labels
component: backend component: database
Milestone
v2.0.x

Comments

@Katrix
Copy link
Member

Katrix commented Nov 15, 2018 •
edited
Loading

  • Add message table
  • Add nullable message_id column to logged_actions
  • Replace message stuff in notifications with message_id column
  • Remove name in organization
  • Replace comment in flags with message_id
  • Replace message in project_log_entries with message_id
  • Merge project_log_entries and project_log
  • Replace comment in project_version_reviews with message_id
  • Remove assets from project_versions. It's unused.
  • Remove owner_name on projects.
  • Replace notes on project with associative table between project and message_id.
  • Replace username in user_session with user_id
  • Run cleanup triggers a bit less often (every night)?
  • Create a materialized view for the front page which is updated every x hours
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
component: backend component: database
Projects
None yet
Milestone
v2.0.x
Development

No branches or pull requests
3 participants
@phase @Katrix @felixoi