SQL_WantedReasons - Nutty101/NPC-Police GitHub Wiki

Wanted Reasons SQL Table:

| Column Name | Column Description | | --- | --- | --- | | Player_ID | UUID of a minecraft player | | ServerName | Name of the server this was generated from | | Wanted_Reason | Reason the player is wanted for | | Target_Player | UUID of the player that was attacked | | Target_NPC | NPC ID of the NPC was that was attacked | | Witness_NPC | NPC ID of the NPC that witnessed this occurrence | | Bounty_Awarded | Total bounty awarded for this incident | | Initial_OffenseDate | First occurrence of the offense | | Last_OffenseDate | Last Date the offense occurred |

This supports a date range, as I am grouping attacks on players / NPCs. If the player murders the NPC/Player, this offense will be removed and converted to a murder (The bounty will also include the amount for the murder + all damage bounty)