diff options
| author | Diva Canto | 2011-04-28 07:28:29 -0700 |
|---|---|---|
| committer | Diva Canto | 2011-04-28 07:28:29 -0700 |
| commit | 7ecf6895842eff93155e49d2f7fa4cd833510726 (patch) | |
| tree | 76caa8db816b9b6d83dc945135e2a7f16c740d48 /OpenSim/Data/MSSQL/Resources/AuthStore.migrations | |
| parent | Fix a bug where physical objects rezzed with an initial velocity by script do... (diff) | |
| download | opensim-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/AuthStore.migrations')
| -rw-r--r-- | OpenSim/Data/MSSQL/Resources/AuthStore.migrations | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/AuthStore.migrations b/OpenSim/Data/MSSQL/Resources/AuthStore.migrations index 5b90ca3..eb91296 100644 --- a/OpenSim/Data/MSSQL/Resources/AuthStore.migrations +++ b/OpenSim/Data/MSSQL/Resources/AuthStore.migrations | |||
| @@ -22,7 +22,11 @@ COMMIT | |||
| 22 | 22 | ||
| 23 | BEGIN TRANSACTION | 23 | BEGIN TRANSACTION |
| 24 | 24 | ||
| 25 | INSERT INTO auth (UUID, passwordHash, passwordSalt, webLoginKey, accountType) SELECT [UUID] AS UUID, [passwordHash] AS passwordHash, [passwordSalt] AS passwordSalt, [webLoginKey] AS webLoginKey, 'UserAccount' as [accountType] FROM users; | 25 | IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[users]') AND type in (N'U')) |
| 26 | INSERT INTO auth (UUID, passwordHash, passwordSalt, webLoginKey, accountType) SELECT [UUID] AS UUID, [passwordHash] AS passwordHash, [passwordSalt] AS passwordSalt, [webLoginKey] AS webLoginKey, 'UserAccount' as [accountType] FROM users; | ||
| 27 | |||
| 28 | COMMIT | ||
| 29 | |||
| 30 | |||
| 26 | 31 | ||
| 27 | 32 | ||
| 28 | COMMIT \ No newline at end of file | ||