From 4206dd79626773b3f667e9af0ca007aa35a7c6f3 Mon Sep 17 00:00:00 2001 From: ilotterytea Date: Wed, 2 Jul 2025 15:24:16 +0500 Subject: feat: lua storage --- migrations/2025-07-02T10-01-06_luastorage/down.sql | 3 +++ migrations/2025-07-02T10-01-06_luastorage/up.sql | 18 ++++++++++++++++++ 2 files changed, 21 insertions(+) create mode 100644 migrations/2025-07-02T10-01-06_luastorage/down.sql create mode 100644 migrations/2025-07-02T10-01-06_luastorage/up.sql (limited to 'migrations') diff --git a/migrations/2025-07-02T10-01-06_luastorage/down.sql b/migrations/2025-07-02T10-01-06_luastorage/down.sql new file mode 100644 index 0000000..4711155 --- /dev/null +++ b/migrations/2025-07-02T10-01-06_luastorage/down.sql @@ -0,0 +1,3 @@ +-- This file should undo anything in 'up.sql' +DROP TABLE lua_user_storage; +DROP TABLE lua_channel_storage; \ No newline at end of file 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