From ada4748a25c39b226534ff0475569a8bd25e17ab Mon Sep 17 00:00:00 2001
From: ilotterytea <iltsu@alright.party>
Date: Wed, 7 May 2025 18:57:32 +0500
Subject: feat: user actions

---
 database.sql | 8 ++++++++
 1 file changed, 8 insertions(+)

(limited to 'database.sql')

diff --git a/database.sql b/database.sql
index c540587..657264d 100644
--- a/database.sql
+++ b/database.sql
@@ -112,6 +112,14 @@ CREATE TABLE IF NOT EXISTS mod_actions(
     created_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP
 );
 
+CREATE TABLE IF NOT EXISTS actions (
+    id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
+    user_id CHAR(32) NOT NULL REFERENCES users(id) ON DELETE CASCADE,
+    action_type TEXT NOT NULL,
+    action_payload TEXT NOT NULL,
+    created_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP
+);
+
 -- -------------------------
 --       INSERTIONS      
 -- -------------------------
-- 
cgit v1.2.3