diff options
| author | Diva Canto | 2011-04-30 20:27:17 -0700 |
|---|---|---|
| committer | Diva Canto | 2011-04-30 20:27:17 -0700 |
| commit | 60e4c4e3e2512e9a202d3c328402332eff970c7b (patch) | |
| tree | 4bc7442847a170114d93d53966d0c62d47083d1a /OpenSim/Data/MSSQL/Resources/GridStore.migrations | |
| parent | Increased the timeouts here too. They were very low. (diff) | |
| parent | Added MrMonkE to the contributors. Fixed contributors. (diff) | |
| download | opensim-SC_OLD-60e4c4e3e2512e9a202d3c328402332eff970c7b.zip opensim-SC_OLD-60e4c4e3e2512e9a202d3c328402332eff970c7b.tar.gz opensim-SC_OLD-60e4c4e3e2512e9a202d3c328402332eff970c7b.tar.bz2 opensim-SC_OLD-60e4c4e3e2512e9a202d3c328402332eff970c7b.tar.xz | |
Merge branch '0.7.1-dev' of ssh://opensimulator.org/var/git/opensim into 0.7.1-dev
Diffstat (limited to 'OpenSim/Data/MSSQL/Resources/GridStore.migrations')
| -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 | ||