diff options
author | Diva Canto | 2011-04-28 07:28:29 -0700 |
---|---|---|
committer | Justin Clark-Casey (justincc) | 2011-04-29 00:33:10 +0100 |
commit | 975cebea0b639a235ce1b13d6de66abef04d6df8 (patch) | |
tree | a696a0f184def95c5c1e8e73b54cd3696b23236e /OpenSim/Data/MSSQL/Resources/GridStore.migrations | |
parent | Stop CHANGED_INVENTORY firing twice if a notecard is edited in prim. (diff) | |
download | opensim-SC_OLD-975cebea0b639a235ce1b13d6de66abef04d6df8.zip opensim-SC_OLD-975cebea0b639a235ce1b13d6de66abef04d6df8.tar.gz opensim-SC_OLD-975cebea0b639a235ce1b13d6de66abef04d6df8.tar.bz2 opensim-SC_OLD-975cebea0b639a235ce1b13d6de66abef04d6df8.tar.xz |
Thank you MrMonkE for a patch that seems to bring the MSSQL data layer up to speed with 0.7.x.
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/MSSQL/Resources/GridStore.migrations | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/GridStore.migrations b/OpenSim/Data/MSSQL/Resources/GridStore.migrations index d2ca27a..c6342fc 100644 --- a/OpenSim/Data/MSSQL/Resources/GridStore.migrations +++ b/OpenSim/Data/MSSQL/Resources/GridStore.migrations | |||
@@ -222,4 +222,17 @@ ALTER TABLE [regions] ADD [Token] varchar(255) NOT NULL DEFAULT 0; | |||
222 | 222 | ||
223 | COMMIT | 223 | COMMIT |
224 | 224 | ||
225 | :VERSION 8 | ||
225 | 226 | ||
227 | BEGIN TRANSACTION | ||
228 | ALTER TABLE regions ALTER COLUMN regionName VarChar(128) | ||
229 | |||
230 | DROP INDEX IX_regions_name ON dbo.regions | ||
231 | ALTER TABLE regions ALTER COLUMN regionName VarChar(128) null | ||
232 | |||
233 | CREATE NONCLUSTERED INDEX IX_regions_name ON dbo.regions | ||
234 | ( | ||
235 | regionName | ||
236 | ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] | ||
237 | |||
238 | COMMIT \ No newline at end of file | ||