diff options
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, |