feat: user actions

1 files changed, 8 insertions, 0 deletions

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      
 -- -------------------------