Files
lifehackerhansol bdef90216f General rework of the todo table
- A title is added to each todo
- A topic ID is added to each todo embed
- The topic ID must be used to close an open topic
- listopen is changed to show title instead of description
2024-10-09 00:41:10 -07:00

18 lines
323 B
SQL

CREATE TABLE IF NOT EXISTS todo
(
id SERIAL PRIMARY KEY,
guild_id BIGINT,
title TEXT,
message TEXT,
priority_level INT,
message_id BIGINT,
message_link TEXT
);
CREATE TABLE IF NOT EXISTS settings
(
guild_id BIGINT PRIMARY KEY,
output_channel_id BIGINT,
allowed_role_ids BIGINT[]
);