diff options
| author | fusion32 <marcopuzziello@gmail.com> | 2025-07-13 13:16:38 -0300 |
|---|---|---|
| committer | fusion32 <marcopuzziello@gmail.com> | 2025-07-13 13:16:38 -0300 |
| commit | c0f9ee43affe07b93b553c0af9e705dd88bfe772 (patch) | |
| tree | c3cc2a180d22c63642cb0d088696813df9065e48 /sql/schema.sql | |
| parent | f827fcc84815c3727aae652d2a60a801b2432768 (diff) | |
| download | querymanager-c0f9ee43affe07b93b553c0af9e705dd88bfe772.tar.gz querymanager-c0f9ee43affe07b93b553c0af9e705dd88bfe772.zip | |
impl BANISH_ACCOUNT
Diffstat (limited to 'sql/schema.sql')
| -rw-r--r-- | sql/schema.sql | 3 |
1 files changed, 3 insertions, 0 deletions
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, |