diff options
| author | Justin Clarke Casey | 2008-09-29 20:26:34 +0000 |
|---|---|---|
| committer | Justin Clarke Casey | 2008-09-29 20:26:34 +0000 |
| commit | 464c3c709102954e502a5d3868bac615c73c64b4 (patch) | |
| tree | e9d9ab1eded503268cf379ed8bcd8d2853095105 /OpenSim/Data/MSSQL/Resources/007_RegionStore.sql | |
| parent | Mantis#2299. Thank you kindly, Idb for a patch that: (diff) | |
| download | opensim-SC_OLD-464c3c709102954e502a5d3868bac615c73c64b4.zip opensim-SC_OLD-464c3c709102954e502a5d3868bac615c73c64b4.tar.gz opensim-SC_OLD-464c3c709102954e502a5d3868bac615c73c64b4.tar.bz2 opensim-SC_OLD-464c3c709102954e502a5d3868bac615c73c64b4.tar.xz | |
* Add missing mssql migration files from http://opensimulator.org/mantis/view.php?id=2295
* Sorry about that
Diffstat (limited to '')
| -rw-r--r-- | OpenSim/Data/MSSQL/Resources/007_RegionStore.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/007_RegionStore.sql b/OpenSim/Data/MSSQL/Resources/007_RegionStore.sql new file mode 100644 index 0000000..684f937 --- /dev/null +++ b/OpenSim/Data/MSSQL/Resources/007_RegionStore.sql | |||
| @@ -0,0 +1,10 @@ | |||
| 1 | BEGIN TRANSACTION | ||
| 2 | |||
| 3 | ALTER TABLE prims ADD ColorR int not null default 0; | ||
| 4 | ALTER TABLE prims ADD ColorG int not null default 0; | ||
| 5 | ALTER TABLE prims ADD ColorB int not null default 0; | ||
| 6 | ALTER TABLE prims ADD ColorA int not null default 0; | ||
| 7 | ALTER TABLE prims ADD ParticleSystem IMAGE; | ||
| 8 | ALTER TABLE prims ADD ClickAction tinyint NOT NULL default 0; | ||
| 9 | |||
| 10 | COMMIT | ||