aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/Resources/FriendsStore.migrations
diff options
context:
space:
mode:
authorJustin Clark-Casey (justincc)2014-11-28 00:27:13 +0000
committerJustin Clark-Casey (justincc)2014-11-28 00:27:13 +0000
commitd9f7aa41c100ebbc8a9f817ec4d4e247b2bd27fd (patch)
tree745f9e4e150ccc1d1e81ee04ebda5fa46a5ed1b8 /OpenSim/Data/MSSQL/Resources/FriendsStore.migrations
parentStop writing SizeZ config parameter for now when creating regions from consol... (diff)
downloadopensim-SC_OLD-d9f7aa41c100ebbc8a9f817ec4d4e247b2bd27fd.zip
opensim-SC_OLD-d9f7aa41c100ebbc8a9f817ec4d4e247b2bd27fd.tar.gz
opensim-SC_OLD-d9f7aa41c100ebbc8a9f817ec4d4e247b2bd27fd.tar.bz2
opensim-SC_OLD-d9f7aa41c100ebbc8a9f817ec4d4e247b2bd27fd.tar.xz
Remove unmaintained MSSQL support.
This has not been maintained for more than 2 years, is unimplemented for newer features (e.g. built-in groups) and has no core developers using it. If somebody fixes these issues then it could be reinstated.
Diffstat (limited to 'OpenSim/Data/MSSQL/Resources/FriendsStore.migrations')
-rw-r--r--OpenSim/Data/MSSQL/Resources/FriendsStore.migrations50
1 files changed, 0 insertions, 50 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/FriendsStore.migrations b/OpenSim/Data/MSSQL/Resources/FriendsStore.migrations
deleted file mode 100644
index cc94c4e..0000000
--- a/OpenSim/Data/MSSQL/Resources/FriendsStore.migrations
+++ /dev/null
@@ -1,50 +0,0 @@
1:VERSION 1
2
3BEGIN TRANSACTION
4
5CREATE TABLE [Friends] (
6[PrincipalID] uniqueidentifier NOT NULL,
7[Friend] varchar(255) NOT NULL,
8[Flags] char(16) NOT NULL DEFAULT '0',
9[Offered] varchar(32) NOT NULL DEFAULT 0)
10 ON [PRIMARY]
11
12COMMIT
13
14:VERSION 2
15
16BEGIN TRANSACTION
17
18IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[userfriends]') AND type in (N'U'))
19INSERT INTO Friends (PrincipalID, Friend, Flags, Offered)
20SELECT [ownerID], [friendID], [friendPerms], 0 FROM userfriends;
21
22COMMIT
23
24:VERSION 3
25
26BEGIN TRANSACTION
27
28CREATE TABLE [Tmp_Friends]
29 ([PrincipalID] varchar(255) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
30[Friend] varchar(255) NOT NULL,
31[Flags] char(16) NOT NULL DEFAULT '0',
32[Offered] varchar(32) NOT NULL DEFAULT 0)
33ON [PRIMARY]
34
35
36IF EXISTS(SELECT * FROM dbo.Friends)
37 EXEC('INSERT INTO dbo.Tmp_Friends (PrincipalID, Friend, Flags, Offered)
38 SELECT CONVERT(varchar(255),PrincipalID), Friend, Flags, Offered FROM dbo.Friends WITH (HOLDLOCK TABLOCKX)')
39
40DROP TABLE dbo.Friends
41
42EXECUTE sp_rename N'dbo.Tmp_Friends', N'Friends', 'OBJECT'
43
44ALTER TABLE dbo.Friends ADD
45 PRIMARY KEY CLUSTERED
46(
47 [PrincipalID] ASC, [Friend] ASC
48)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
49
50COMMIT \ No newline at end of file