aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/Resources/007_RegionStore.sql
diff options
context:
space:
mode:
authorJustin Clarke Casey2008-09-29 20:26:34 +0000
committerJustin Clarke Casey2008-09-29 20:26:34 +0000
commit464c3c709102954e502a5d3868bac615c73c64b4 (patch)
treee9d9ab1eded503268cf379ed8bcd8d2853095105 /OpenSim/Data/MSSQL/Resources/007_RegionStore.sql
parentMantis#2299. Thank you kindly, Idb for a patch that: (diff)
downloadopensim-SC-464c3c709102954e502a5d3868bac615c73c64b4.zip
opensim-SC-464c3c709102954e502a5d3868bac615c73c64b4.tar.gz
opensim-SC-464c3c709102954e502a5d3868bac615c73c64b4.tar.bz2
opensim-SC-464c3c709102954e502a5d3868bac615c73c64b4.tar.xz
* Add missing mssql migration files from http://opensimulator.org/mantis/view.php?id=2295
* Sorry about that
Diffstat (limited to 'OpenSim/Data/MSSQL/Resources/007_RegionStore.sql')
-rw-r--r--OpenSim/Data/MSSQL/Resources/007_RegionStore.sql10
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 @@
1BEGIN TRANSACTION
2
3ALTER TABLE prims ADD ColorR int not null default 0;
4ALTER TABLE prims ADD ColorG int not null default 0;
5ALTER TABLE prims ADD ColorB int not null default 0;
6ALTER TABLE prims ADD ColorA int not null default 0;
7ALTER TABLE prims ADD ParticleSystem IMAGE;
8ALTER TABLE prims ADD ClickAction tinyint NOT NULL default 0;
9
10COMMIT