[INFO] - Wish simulator SQL implementation

[paninizer]

See SQLite Schema

User stored in DB must have:

1. Discord UID
2. Primogem amount (currency for wishing)
3. Event wishes amount
4. Standard wishes amount
5. A list of Character objects that they have obtained
6. A list of Weapon objects that they have obtained

Character object:

• name
• ID (positive integer)
• times obtained
• first obtained date (optional, can skip)
• rarity (enum of 4/5 star that can be converted into positive int of 4/5)

Weapon object:

• name
• ID (positive integer)
• times obtained
• first obtained date (optional, can skip)
• rarity (enum of 3/4/5 star that can be converted into positive int of 3/4/5)

Considering the lack of array support in SQLite, this would be difficult to implement. Change schema to fit PostgreSQL would be acceptable but doing this in SQLite is preferable as hosting a Postgres database is somewhat of a pain.

[paninizer]

Note that in rust, the ID of Weapon and Character can be an u8 to save memory (since genshin currently does not have >255 characters or weapons).