Skip to content
This repository was archived by the owner on Apr 18, 2024. It is now read-only.
This repository was archived by the owner on Apr 18, 2024. It is now read-only.

Reset DB feature #110

@pavelskipenes

Description

@pavelskipenes

Add new feature where db is being reset and getting ready for next year.
Transactions:

  • TRUNCATE svommer_web.access_log
  • TRUNCATE svommer_web.friday_beer
  • TRUNCATE svommer_web.orders
  • Generate CIN hash for each user in svommer_member.members and save it to svommer_member.member_CIN.
  • TRUNCATE svommer_member.members
  • DELETE FROM svommer_web.friday_beer WHERE last_used + 5 years > NOW()

Metadata

Metadata

Assignees

No one assigned

    Labels

    adminAdmin related pages

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions