aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/Resources/UserAccount.migrations
diff options
context:
space:
mode:
authorDiva Canto2011-04-28 07:28:29 -0700
committerDiva Canto2011-04-28 07:28:29 -0700
commit7ecf6895842eff93155e49d2f7fa4cd833510726 (patch)
tree76caa8db816b9b6d83dc945135e2a7f16c740d48 /OpenSim/Data/MSSQL/Resources/UserAccount.migrations
parentFix a bug where physical objects rezzed with an initial velocity by script do... (diff)
downloadopensim-SC_OLD-7ecf6895842eff93155e49d2f7fa4cd833510726.zip
opensim-SC_OLD-7ecf6895842eff93155e49d2f7fa4cd833510726.tar.gz
opensim-SC_OLD-7ecf6895842eff93155e49d2f7fa4cd833510726.tar.bz2
opensim-SC_OLD-7ecf6895842eff93155e49d2f7fa4cd833510726.tar.xz
Thank you MrMonkE for a patch that seems to bring the MSSQL data layer up to speed with 0.7.x.
Diffstat (limited to 'OpenSim/Data/MSSQL/Resources/UserAccount.migrations')
-rw-r--r--OpenSim/Data/MSSQL/Resources/UserAccount.migrations2
1 files changed, 1 insertions, 1 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/UserAccount.migrations b/OpenSim/Data/MSSQL/Resources/UserAccount.migrations
index 8534e23..a81704d 100644
--- a/OpenSim/Data/MSSQL/Resources/UserAccount.migrations
+++ b/OpenSim/Data/MSSQL/Resources/UserAccount.migrations
@@ -19,7 +19,7 @@ CREATE TABLE [UserAccounts] (
19:VERSION 2 19:VERSION 2
20 20
21BEGIN TRANSACTION 21BEGIN TRANSACTION
22 22IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[users]') AND type in (N'U'))
23INSERT INTO UserAccounts (PrincipalID, ScopeID, FirstName, LastName, Email, ServiceURLs, Created) SELECT [UUID] AS PrincipalID, '00000000-0000-0000-0000-000000000000' AS ScopeID, 23INSERT INTO UserAccounts (PrincipalID, ScopeID, FirstName, LastName, Email, ServiceURLs, Created) SELECT [UUID] AS PrincipalID, '00000000-0000-0000-0000-000000000000' AS ScopeID,
24username AS FirstName, 24username AS FirstName,
25lastname AS LastName, 25lastname AS LastName,