erikzimmermann/ClanSystem

Database table structuring

Opened this issue · 7 comments

erikzimmermann commented
  • Plan tables
  • Implement table creation
  • Implement loading and saving methods
dorsax commented

UUID of players is the primary key of players.
clan-statistics and rank-permission have a constraint primary key consisting of both foreign keys.

https://drawsql.app/dor_sax/diagrams/clansystem

image

erikzimmermann commented
  • statistics and permissions table in code?
  • table for plugin version
  • triggers: onDelete cascade
dorsax commented

Table creation for MySQL written: https://pastebin.com/5eJ3pbM2

erikzimmermann commented

Don't forget the money value from #28

dorsax commented

Added a double for money in table clans:
https://pastebin.com/NTpiR9ws

erikzimmermann commented

The inheritance table for ranks is missing.

dorsax commented

A versioning table is missing, too

  • 😄1