diff options
Diffstat (limited to 'OpenSim/Data/SQLite/Resources/EstateStore.migrations')
-rw-r--r-- | OpenSim/Data/SQLite/Resources/EstateStore.migrations | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/OpenSim/Data/SQLite/Resources/EstateStore.migrations b/OpenSim/Data/SQLite/Resources/EstateStore.migrations index 37fa1d9..30e04fd 100644 --- a/OpenSim/Data/SQLite/Resources/EstateStore.migrations +++ b/OpenSim/Data/SQLite/Resources/EstateStore.migrations | |||
@@ -63,7 +63,16 @@ CREATE TABLE IF NOT EXISTS estateban ( | |||
63 | bannedIpHostMask varchar(16) NOT NULL, | 63 | bannedIpHostMask varchar(16) NOT NULL, |
64 | bannedNameMask varchar(64) default NULL | 64 | bannedNameMask varchar(64) default NULL |
65 | ); | 65 | ); |
66 | |||
66 | CREATE INDEX estate_ban_estate_id on estateban(EstateID); | 67 | CREATE INDEX estate_ban_estate_id on estateban(EstateID); |
67 | 68 | ||
68 | COMMIT; | 69 | COMMIT; |
69 | 70 | ||
71 | :VERSION 11 | ||
72 | BEGIN; | ||
73 | ALTER TABLE `estateban` | ||
74 | ADD COLUMN `banningUUID` varchar(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', | ||
75 | ADD COLUMN `banTime` integer NOT NULL DEFAULT 0; | ||
76 | COMMIT; | ||
77 | |||
78 | |||