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 | |
| 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 'OpenSim/Data/MSSQL')
| -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 |