aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL
diff options
context:
space:
mode:
authorArthur Valadares2009-06-29 19:24:43 +0000
committerArthur Valadares2009-06-29 19:24:43 +0000
commitdc9900d73fff6e8f9caaa81e19966f608692b9b8 (patch)
treeb304b81c670018b2432c9b6d0597366aaa1aec53 /OpenSim/Data/MSSQL
parent* C# compiler is not smart enough to understand ClientLoop is under very heav... (diff)
downloadopensim-SC_OLD-dc9900d73fff6e8f9caaa81e19966f608692b9b8.zip
opensim-SC_OLD-dc9900d73fff6e8f9caaa81e19966f608692b9b8.tar.gz
opensim-SC_OLD-dc9900d73fff6e8f9caaa81e19966f608692b9b8.tar.bz2
opensim-SC_OLD-dc9900d73fff6e8f9caaa81e19966f608692b9b8.tar.xz
Thanks StrawberryFride, for a patch that fixes MSSQL migration:
Minor tweak to a region migration SQL script for the OAR DateTime field - SQL Server syntax slightly different from MySQL (and there is no unsigned in MSSQL, sadly)
Diffstat (limited to 'OpenSim/Data/MSSQL')
-rw-r--r--OpenSim/Data/MSSQL/Resources/023_RegionStore.sql6
1 files changed, 3 insertions, 3 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/023_RegionStore.sql b/OpenSim/Data/MSSQL/Resources/023_RegionStore.sql
index 61b08f1..75a16f3 100644
--- a/OpenSim/Data/MSSQL/Resources/023_RegionStore.sql
+++ b/OpenSim/Data/MSSQL/Resources/023_RegionStore.sql
@@ -1,7 +1,7 @@
1BEGIN TRANSACTION 1BEGIN TRANSACTION
2 2
3ALTER TABLE regionsettings DROP COLUMN loaded_creation_date; 3ALTER TABLE regionsettings DROP COLUMN loaded_creation_date
4ALTER TABLE regionsettings DROP COLUMN loaded_creation_time; 4ALTER TABLE regionsettings DROP COLUMN loaded_creation_time
5ALTER TABLE regionsettings ADD COLUMN loaded_creation_datetime int unsigned NOT NULL default 0; 5ALTER TABLE regionsettings ADD loaded_creation_datetime int NOT NULL default 0
6 6
7COMMIT 7COMMIT