diff options
| author | Charles Krinke | 2008-11-19 18:36:04 +0000 |
|---|---|---|
| committer | Charles Krinke | 2008-11-19 18:36:04 +0000 |
| commit | 9babdb109504221903464dfa714a445bdf89fa9e (patch) | |
| tree | 1fdf1b9bc0853094d7f1ec20a635826e22e6aa20 /OpenSim/Data/MSSQL/Resources | |
| parent | Mantis#2656. Thank you kindly, Nlin for a patch that: (diff) | |
| download | opensim-SC_OLD-9babdb109504221903464dfa714a445bdf89fa9e.zip opensim-SC_OLD-9babdb109504221903464dfa714a445bdf89fa9e.tar.gz opensim-SC_OLD-9babdb109504221903464dfa714a445bdf89fa9e.tar.bz2 opensim-SC_OLD-9babdb109504221903464dfa714a445bdf89fa9e.tar.xz | |
Mantis#2657. Thank you kindly, StrawberryFride for a patch that:
Added access_time and create_time, plus the new sun position
data to MSSQL code.
Diffstat (limited to '')
| -rw-r--r-- | OpenSim/Data/MSSQL/Resources/003_AssetStore.sql | 6 | ||||
| -rw-r--r-- | OpenSim/Data/MSSQL/Resources/010_RegionStore.sql | 7 |
2 files changed, 13 insertions, 0 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/003_AssetStore.sql b/OpenSim/Data/MSSQL/Resources/003_AssetStore.sql new file mode 100644 index 0000000..1776cac --- /dev/null +++ b/OpenSim/Data/MSSQL/Resources/003_AssetStore.sql | |||
| @@ -0,0 +1,6 @@ | |||
| 1 | BEGIN TRANSACTION | ||
| 2 | |||
| 3 | ALTER TABLE assets add create_time integer default 0 | ||
| 4 | ALTER TABLE assets add access_time integer default 0 | ||
| 5 | |||
| 6 | COMMIT | ||
diff --git a/OpenSim/Data/MSSQL/Resources/010_RegionStore.sql b/OpenSim/Data/MSSQL/Resources/010_RegionStore.sql new file mode 100644 index 0000000..2eed71d --- /dev/null +++ b/OpenSim/Data/MSSQL/Resources/010_RegionStore.sql | |||
| @@ -0,0 +1,7 @@ | |||
| 1 | BEGIN TRANSACTION | ||
| 2 | |||
| 3 | ALTER TABLE regionsettings ADD sunvectorx float NOT NULL default 0; | ||
| 4 | ALTER TABLE regionsettings ADD sunvectory float NOT NULL default 0; | ||
| 5 | ALTER TABLE regionsettings ADD sunvectorz float NOT NULL default 0; | ||
| 6 | |||
| 7 | COMMIT | ||