From c0f9ee43affe07b93b553c0af9e705dd88bfe772 Mon Sep 17 00:00:00 2001 From: fusion32 Date: Sun, 13 Jul 2025 13:16:38 -0300 Subject: impl BANISH_ACCOUNT --- sql/schema.sql | 3 +++ 1 file changed, 3 insertions(+) (limited to 'sql/schema.sql') diff --git a/sql/schema.sql b/sql/schema.sql index f027e35..56c36fd 100644 --- a/sql/schema.sql +++ b/sql/schema.sql @@ -142,9 +142,12 @@ CREATE TABLE IF NOT EXISTS Banishments ( Reason TEXT NOT NULL, Comment TEXT NOT NULL, FinalWarning INTEGER NOT NULL, + Issued INTEGER NOT NULL, Until INTEGER NOT NULL, PRIMARY KEY (BanishmentID) ); +CREATE INDEX IF NOT EXISTS BanishmentsAccount + ON Banishments(AccountID, Until, FinalWarning); CREATE TABLE IF NOT EXISTS IPBanishments ( IPAddress INTEGER NOT NULL, -- cgit v1.2.3