From 69355b508f0fd012b08c773b950e7b0be96c9185 Mon Sep 17 00:00:00 2001 From: ilotterytea Date: Sun, 27 Apr 2025 21:14:44 +0500 Subject: feat: roles sql --- database.sql | 27 +++++++++++++++++++++++++++ 1 file changed, 27 insertions(+) (limited to 'database.sql') diff --git a/database.sql b/database.sql index 1c4cb79..bc352de 100644 --- a/database.sql +++ b/database.sql @@ -75,4 +75,31 @@ CREATE TABLE IF NOT EXISTS reports ( sent_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP, resolved_by INTEGER REFERENCES users(id), response_message TEXT +); + +CREATE TABLE IF NOT EXISTS roles ( + id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, + priority INTEGER NOT NULL DEFAULT 0, + name TEXT NOT NULL, + foreground_color TEXT NOT NULL DEFAULT '000,000,000', + background_color TEXT NOT NULL DEFAULT 'solid:255,255,255', + badge_id INTEGER NOT NULL DEFAULT 0, + + -- permissions + permission_upload BOOLEAN NOT NULL DEFAULT true, + permission_rate BOOLEAN NOT NULL DEFAULT true, + permission_emoteset_own BOOLEAN NOT NULL DEFAULT true, + permission_emoteset_all BOOLEAN NOT NULL DEFAULT false, + permission_report BOOLEAN NOT NULL DEFAULT true, + permission_report_review BOOLEAN NOT NULL DEFAULT false, + permission_approve_emotes BOOLEAN NOT NULL DEFAULT false, + permission_useredit_own BOOLEAN NOT NULL DEFAULT true, + permission_useredit_all BOOLEAN NOT NULL DEFAULT false, + permission_modsystem BOOLEAN NOT NULL DEFAULT false +); + +CREATE TABLE IF NOT EXISTS role_assigns( + id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, + user_id INTEGER NOT NULL UNIQUE REFERENCES users(id), + role_id INTEGER NOT NULL REFERENCES roles(id) ); \ No newline at end of file -- cgit v1.2.3