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/Avatar.migrations | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)
 create 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
new file mode 100644
index 0000000..759e939
--- /dev/null
+++ b/OpenSim/Data/MSSQL/Resources/Avatar.migrations
@@ -0,0 +1,17 @@
+: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
\ No newline at end of file
-- 
cgit v1.1