From dc9900d73fff6e8f9caaa81e19966f608692b9b8 Mon Sep 17 00:00:00 2001
From: Arthur Valadares
Date: Mon, 29 Jun 2009 19:24:43 +0000
Subject: 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)

---
 OpenSim/Data/MSSQL/Resources/023_RegionStore.sql | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

(limited to 'OpenSim/Data/MSSQL')

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 @@
 BEGIN TRANSACTION
 
-ALTER TABLE regionsettings DROP COLUMN loaded_creation_date;
-ALTER TABLE regionsettings DROP COLUMN loaded_creation_time;
-ALTER TABLE regionsettings ADD COLUMN loaded_creation_datetime int unsigned NOT NULL default 0;
+ALTER TABLE regionsettings DROP COLUMN loaded_creation_date
+ALTER TABLE regionsettings DROP COLUMN loaded_creation_time
+ALTER TABLE regionsettings ADD loaded_creation_datetime int NOT NULL default 0
 
 COMMIT
-- 
cgit v1.1