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