diff options
| author | UbitUmarov | 2019-08-18 20:35:24 +0100 |
|---|---|---|
| committer | UbitUmarov | 2019-08-18 20:35:24 +0100 |
| commit | 7f52bcbc7f1f518d49b84a5c642b3b065e0bb656 (patch) | |
| tree | f33dd032b2230fd74859cbe1cdb6ba0e0def0c5f /OpenSim/Data/SQLite/Resources/EstateStore.migrations | |
| parent | try to update PGSQL estateban (diff) | |
| download | opensim-SC-7f52bcbc7f1f518d49b84a5c642b3b065e0bb656.zip opensim-SC-7f52bcbc7f1f518d49b84a5c642b3b065e0bb656.tar.gz opensim-SC-7f52bcbc7f1f518d49b84a5c642b3b065e0bb656.tar.bz2 opensim-SC-7f52bcbc7f1f518d49b84a5c642b3b065e0bb656.tar.xz | |
try to update SQLite estateban
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 | |||