diff options
author | Justin Clark-Casey (justincc) | 2010-07-26 23:26:22 +0100 |
---|---|---|
committer | Justin Clark-Casey (justincc) | 2010-07-26 23:34:23 +0100 |
commit | 109ddd1bd5fcabf3155e579fe6eb15e07869b9b8 (patch) | |
tree | 0e0dff6724b3c6d7ae8ac21b9a11dee4bb8ab24e /OpenSim/Data/MSSQL/Resources/RegionStore.migrations | |
parent | add mysql support for media on a prim (diff) | |
download | opensim-SC-109ddd1bd5fcabf3155e579fe6eb15e07869b9b8.zip opensim-SC-109ddd1bd5fcabf3155e579fe6eb15e07869b9b8.tar.gz opensim-SC-109ddd1bd5fcabf3155e579fe6eb15e07869b9b8.tar.bz2 opensim-SC-109ddd1bd5fcabf3155e579fe6eb15e07869b9b8.tar.xz |
add mssql support for media on a prim
compiles but not tested. please test and correct if necessary!
Diffstat (limited to 'OpenSim/Data/MSSQL/Resources/RegionStore.migrations')
-rw-r--r-- | OpenSim/Data/MSSQL/Resources/RegionStore.migrations | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/RegionStore.migrations b/OpenSim/Data/MSSQL/Resources/RegionStore.migrations index e912d64..e2e8cbb 100644 --- a/OpenSim/Data/MSSQL/Resources/RegionStore.migrations +++ b/OpenSim/Data/MSSQL/Resources/RegionStore.migrations | |||
@@ -1,4 +1,4 @@ | |||
1 | | 1 | |
2 | :VERSION 1 | 2 | :VERSION 1 |
3 | 3 | ||
4 | CREATE TABLE [dbo].[prims]( | 4 | CREATE TABLE [dbo].[prims]( |
@@ -925,5 +925,12 @@ ALTER TABLE regionsettings ADD loaded_creation_datetime int NOT NULL default 0 | |||
925 | 925 | ||
926 | COMMIT | 926 | COMMIT |
927 | 927 | ||
928 | :VERSION 24 | ||
929 | -- Added post 0.7 | ||
930 | |||
931 | BEGIN TRANSACTION | ||
928 | 932 | ||
933 | ALTER TABLE prims ADD COLUMN MediaURL varchar(255) | ||
934 | ALTER TABLE primshapes ADD COLUMN Media TEXT | ||
929 | 935 | ||
936 | COMMIT \ No newline at end of file | ||