diff options
author | Arthur Valadares | 2009-06-29 19:24:43 +0000 |
---|---|---|
committer | Arthur Valadares | 2009-06-29 19:24:43 +0000 |
commit | dc9900d73fff6e8f9caaa81e19966f608692b9b8 (patch) | |
tree | b304b81c670018b2432c9b6d0597366aaa1aec53 /OpenSim/Data/MSSQL/Resources/023_RegionStore.sql | |
parent | * C# compiler is not smart enough to understand ClientLoop is under very heav... (diff) | |
download | opensim-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 '')
-rw-r--r-- | OpenSim/Data/MSSQL/Resources/023_RegionStore.sql | 6 |
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 @@ | |||
1 | BEGIN TRANSACTION | 1 | BEGIN TRANSACTION |
2 | 2 | ||
3 | ALTER TABLE regionsettings DROP COLUMN loaded_creation_date; | 3 | ALTER TABLE regionsettings DROP COLUMN loaded_creation_date |
4 | ALTER TABLE regionsettings DROP COLUMN loaded_creation_time; | 4 | ALTER TABLE regionsettings DROP COLUMN loaded_creation_time |
5 | ALTER TABLE regionsettings ADD COLUMN loaded_creation_datetime int unsigned NOT NULL default 0; | 5 | ALTER TABLE regionsettings ADD loaded_creation_datetime int NOT NULL default 0 |
6 | 6 | ||
7 | COMMIT | 7 | COMMIT |