From c0f9ee43affe07b93b553c0af9e705dd88bfe772 Mon Sep 17 00:00:00 2001
From: fusion32 <marcopuzziello@gmail.com>
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

