From dfeb9a0b5c07a85ec8aed591206468cee83ce637 Mon Sep 17 00:00:00 2001
From: AlexRa
Date: Thu, 6 May 2010 23:16:36 +0300
Subject: MS SQL migrations converted to the new format

---
 OpenSim/Data/MSSQL/Resources/FriendsStore.migrations | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)
 create mode 100644 OpenSim/Data/MSSQL/Resources/FriendsStore.migrations

(limited to 'OpenSim/Data/MSSQL/Resources/FriendsStore.migrations')

diff --git a/OpenSim/Data/MSSQL/Resources/FriendsStore.migrations b/OpenSim/Data/MSSQL/Resources/FriendsStore.migrations
new file mode 100644
index 0000000..f981a91
--- /dev/null
+++ b/OpenSim/Data/MSSQL/Resources/FriendsStore.migrations
@@ -0,0 +1,20 @@
+:VERSION 1
+
+BEGIN TRANSACTION
+
+CREATE TABLE [Friends] (
+[PrincipalID] uniqueidentifier NOT NULL, 
+[Friend] varchar(255) NOT NULL, 
+[Flags] char(16) NOT NULL DEFAULT '0',
+[Offered] varchar(32) NOT NULL DEFAULT 0)
+ ON [PRIMARY]
+
+COMMIT
+
+:VERSION 2
+
+BEGIN TRANSACTION
+
+INSERT INTO Friends (PrincipalID, Friend, Flags, Offered) SELECT [ownerID], [friendID], [friendPerms], 0 FROM userfriends;
+
+COMMIT
\ No newline at end of file
-- 
cgit v1.1