From 134f86e8d5c414409631b25b8c6f0ee45fbd8631 Mon Sep 17 00:00:00 2001 From: David Walter Seikel Date: Thu, 3 Nov 2016 21:44:39 +1000 Subject: Initial update to OpenSim 0.8.2.1 source code. --- OpenSim/Data/MSSQL/Resources/Avatar.migrations | 64 -------------------------- 1 file changed, 64 deletions(-) delete mode 100644 OpenSim/Data/MSSQL/Resources/Avatar.migrations (limited to 'OpenSim/Data/MSSQL/Resources/Avatar.migrations') diff --git a/OpenSim/Data/MSSQL/Resources/Avatar.migrations b/OpenSim/Data/MSSQL/Resources/Avatar.migrations deleted file mode 100644 index 61f7b56..0000000 --- a/OpenSim/Data/MSSQL/Resources/Avatar.migrations +++ /dev/null @@ -1,64 +0,0 @@ -:VERSION 1 - -BEGIN TRANSACTION - -CREATE TABLE [Avatars] ( -[PrincipalID] uniqueidentifier NOT NULL, -[Name] varchar(32) NOT NULL, -[Value] varchar(255) NOT NULL DEFAULT '', -PRIMARY KEY CLUSTERED -( - [PrincipalID] ASC, [Name] ASC -)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] -) ON [PRIMARY] - - -COMMIT - -:VERSION 2 - -BEGIN TRANSACTION - -CREATE TABLE dbo.Tmp_Avatars - ( - PrincipalID uniqueidentifier NOT NULL, - [Name] varchar(32) NOT NULL, - Value text NOT NULL DEFAULT '', - ) ON [PRIMARY] - TEXTIMAGE_ON [PRIMARY] - -IF EXISTS(SELECT * FROM dbo.Avatars) - EXEC('INSERT INTO dbo.Tmp_Avatars (PrincipalID, Name, Value) - SELECT PrincipalID, CONVERT(text, Name), Value FROM dbo.Avatars WITH (HOLDLOCK TABLOCKX)') - -DROP TABLE dbo.Avatars - -EXECUTE sp_rename N'dbo.Tmp_Avatars', N'Avatars', 'OBJECT' - -COMMIT - -:VERSION 3 - -BEGIN TRANSACTION - -CREATE TABLE dbo.Tmp_Avatars - ( - PrincipalID uniqueidentifier NOT NULL, - [Name] varchar(32) NOT NULL, - Value text NOT NULL DEFAULT '', - PRIMARY KEY CLUSTERED -( - [PrincipalID] ASC, [Name] ASC -)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] -) ON [PRIMARY] - TEXTIMAGE_ON [PRIMARY] - -IF EXISTS(SELECT * FROM dbo.Avatars) - EXEC('INSERT INTO dbo.Tmp_Avatars (PrincipalID, Name, Value) - SELECT PrincipalID, CONVERT(text, Name), Value FROM dbo.Avatars WITH (HOLDLOCK TABLOCKX)') - -DROP TABLE dbo.Avatars - -EXECUTE sp_rename N'dbo.Tmp_Avatars', N'Avatars', 'OBJECT' -COMMIT - -- cgit v1.1