countdown-bot

commit b0bcb33e4298c0ebe58fd7dfab0d9a63a0ca5b09
parent 97c3b9887c7a71bfdfa9bf1c429ec2382dcb1d85
Author: Asher Morgan <59518073+ashermorgan@users.noreply.github.com>
Date:   Sat,  6 Apr 2024 20:36:41 -0700

Add basic schema

Diffstat:
A
models/ddl.sql
 | 
15
+++++++++++++++

1 file changed, 15 insertions(+), 0 deletions(-)
diff --git a/models/ddl.sql b/models/ddl.sql
@@ -0,0 +1,15 @@
+DROP TABLE IF EXISTS messages;
+DROP TABLE IF EXISTS countdowns;
+
+CREATE TABLE countdowns (
+    countdownID INT PRIMARY KEY, -- Discord channel ID
+    serverID INT NOT NULL
+);
+
+CREATE TABLE messages (
+    messageID INT PRIMARY KEY, -- Discord message ID
+    countdownID INT REFERENCES countdowns(countdownID),
+    userID INT NOT NULL, -- Discord user ID
+    value INT NOT NULL,
+    timestamp TIMESTAMP NOT NULL
+);