From 4206dd79626773b3f667e9af0ca007aa35a7c6f3 Mon Sep 17 00:00:00 2001
From: ilotterytea <iltsu@alright.party>
Date: Wed, 2 Jul 2025 15:24:16 +0500
Subject: feat: lua storage

---
 migrations/2025-07-02T10-01-06_luastorage/up.sql | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)
 create mode 100644 migrations/2025-07-02T10-01-06_luastorage/up.sql

(limited to 'migrations/2025-07-02T10-01-06_luastorage/up.sql')

diff --git a/migrations/2025-07-02T10-01-06_luastorage/up.sql b/migrations/2025-07-02T10-01-06_luastorage/up.sql
new file mode 100644
index 0000000..dd61116
--- /dev/null
+++ b/migrations/2025-07-02T10-01-06_luastorage/up.sql
@@ -0,0 +1,18 @@
+-- Your SQL goes here
+CREATE TABLE IF NOT EXISTS lua_channel_storage(
+    id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
+    channel_id INTEGER NOT NULL REFERENCES channels(id) ON DELETE CASCADE,
+    lua_id TEXT NOT NULL,
+    value TEXT NOT NULL DEFAULT '',
+
+    CONSTRAINT unique_lua_script_per_channel UNIQUE (channel_id, lua_id)
+);
+
+CREATE TABLE IF NOT EXISTS lua_user_storage(
+    id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
+    user_id INTEGER NOT NULL REFERENCES users(id) ON DELETE CASCADE,
+    lua_id TEXT NOT NULL,
+    value TEXT NOT NULL DEFAULT '',
+
+    CONSTRAINT unique_lua_script_per_channel UNIQUE (user_id, lua_id)
+);
\ No newline at end of file
-- 
cgit v1.2.3

