31 lines
832 B
Markdown
Executable File
31 lines
832 B
Markdown
Executable File
## 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"} |