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/Avatar.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 '')
-rw-r--r-- | OpenSim/Data/MSSQL/Resources/Avatar.migrations | 25 |
1 files changed, 24 insertions, 1 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/Avatar.migrations b/OpenSim/Data/MSSQL/Resources/Avatar.migrations index 759e939..5364153 100644 --- a/OpenSim/Data/MSSQL/Resources/Avatar.migrations +++ b/OpenSim/Data/MSSQL/Resources/Avatar.migrations | |||
@@ -13,5 +13,28 @@ PRIMARY KEY CLUSTERED | |||
13 | ) ON [PRIMARY] | 13 | ) ON [PRIMARY] |
14 | 14 | ||
15 | 15 | ||
16 | COMMIT | ||
17 | |||
18 | :VERSION 2 | ||
19 | |||
20 | BEGIN TRANSACTION | ||
21 | |||
22 | CREATE TABLE dbo.Tmp_Avatars | ||
23 | ( | ||
24 | PrincipalID uniqueidentifier NOT NULL, | ||
25 | [Name] varchar(32) NOT NULL, | ||
26 | Value text NOT NULL DEFAULT '', | ||
27 | ) ON [PRIMARY] | ||
28 | TEXTIMAGE_ON [PRIMARY] | ||
29 | |||
30 | IF EXISTS(SELECT * FROM dbo.Avatars) | ||
31 | EXEC('INSERT INTO dbo.Tmp_Avatars (PrincipalID, Name, Value) | ||
32 | SELECT PrincipalID, CONVERT(text, Name), Value FROM dbo.Avatars WITH (HOLDLOCK TABLOCKX)') | ||
33 | |||
34 | DROP TABLE dbo.Avatars | ||
35 | |||
36 | EXECUTE sp_rename N'dbo.Tmp_Avatars', N'Avatars', 'OBJECT' | ||
37 | |||
38 | COMMIT | ||
39 | |||
16 | 40 | ||
17 | COMMIT \ No newline at end of file | ||