silvanus/TODO.md

## Variable Structures

guildInfo = {
    guildId: "",
    treeName: "name",
    treeHeight: 0,
    treeMessageId: "",
    treeChannelId: "",
    leaderboardMessageId: "",
    leaderboardChannelId: "",
    reminderMessage: "",
    reminderChannelId: "",
    remindedStatus: 0,
    reminderOptIn: 0,
}

## New Table Planning
Table: `silvanus`.timers

id | INT | NOT NULL | AUTO INCREMENT | PRIMARY KEY
status | VARCHAR(10) | NOT NULL | DEFAULT "WAITING"
dc_timecode | INT | NOT NULL | Discord timecode
guild_id | INT UNSIGNED | NOT NULL | Discord guild ID for referencing `silvanus`.guildInfo


Table: `silvanus`.auto_role_status

id | INT | NOT NULL | AUTO INCREMENT | PRIMARY KEY
user_id | INT UNSIGNED | NOT NULL
guild_id | INT UNSIGNED | NOT NULL
status | VARCHAR(10) | NOT NULL | DEFAULT "REMOVED" | OPTION: {"REMOVED", "ADDED"}