diff options
author | PixelTomsen | 2012-02-13 21:58:33 +0100 |
---|---|---|
committer | Justin Clark-Casey (justincc) | 2012-02-14 02:04:02 +0000 |
commit | db90dea9bdb176179675a07d95efb3e5e5f017cb (patch) | |
tree | 6645704eb29bb0ddfac30d376f400b2e51799cf6 | |
parent | Revert "Add GridStore migration for MSSQL." (diff) | |
download | opensim-SC-db90dea9bdb176179675a07d95efb3e5e5f017cb.zip opensim-SC-db90dea9bdb176179675a07d95efb3e5e5f017cb.tar.gz opensim-SC-db90dea9bdb176179675a07d95efb3e5e5f017cb.tar.bz2 opensim-SC-db90dea9bdb176179675a07d95efb3e5e5f017cb.tar.xz |
Fix: MSSQLDB Grid - unable to register region http://opensimulator.org/mantis/view.php?id=5886
-rw-r--r-- | OpenSim/Data/MSSQL/Resources/GridStore.migrations | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/GridStore.migrations b/OpenSim/Data/MSSQL/Resources/GridStore.migrations index c6342fc..de0cea7 100644 --- a/OpenSim/Data/MSSQL/Resources/GridStore.migrations +++ b/OpenSim/Data/MSSQL/Resources/GridStore.migrations | |||
@@ -235,4 +235,11 @@ CREATE NONCLUSTERED INDEX IX_regions_name ON dbo.regions | |||
235 | regionName | 235 | regionName |
236 | ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] | 236 | ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] |
237 | 237 | ||
238 | COMMIT \ No newline at end of file | 238 | COMMIT |
239 | |||
240 | :VERSION 9 | ||
241 | |||
242 | BEGIN TRANSACTION | ||
243 | ALTER TABLE regions ADD parcelMapTexture uniqueidentifier NULL; | ||
244 | |||
245 | COMMIT | ||