From f210cf01956eecc92495d005174a8cd6cef27a55 Mon Sep 17 00:00:00 2001
From: lbsa71
Date: Wed, 2 Apr 2008 13:06:52 +0000
Subject: * Added AvatarAppearance.sql for MSSQL

---
 .../Data.MSSQL/Resources/AvatarAppearance.sql      | 44 ++++++++++++++++++++++
 1 file changed, 44 insertions(+)
 create mode 100644 OpenSim/Framework/Data.MSSQL/Resources/AvatarAppearance.sql

(limited to 'OpenSim/Framework')

diff --git a/OpenSim/Framework/Data.MSSQL/Resources/AvatarAppearance.sql b/OpenSim/Framework/Data.MSSQL/Resources/AvatarAppearance.sql
new file mode 100644
index 0000000..ccefba2
--- /dev/null
+++ b/OpenSim/Framework/Data.MSSQL/Resources/AvatarAppearance.sql
@@ -0,0 +1,44 @@
+--
+-- Create schema avatar_appearance
+--
+
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+
+CREATE TABLE [avatarappearance]  (
+  [UUID]  uniqueidentifier NOT NULL,
+  [Serial]  int NOT NULL,
+  [WearableItem0]  uniqueidentifier NOT NULL,
+  [WearableAsset0]  uniqueidentifier NOT NULL,
+  [WearableItem1]  uniqueidentifier NOT NULL,
+  [WearableAsset1]  uniqueidentifier NOT NULL,
+  [WearableItem2]  uniqueidentifier NOT NULL,
+  [WearableAsset2]  uniqueidentifier NOT NULL,
+  [WearableItem3]  uniqueidentifier NOT NULL,
+  [WearableAsset3]  uniqueidentifier NOT NULL,
+  [WearableItem4]  uniqueidentifier NOT NULL,
+  [WearableAsset4]  uniqueidentifier NOT NULL,
+  [WearableItem5]  uniqueidentifier NOT NULL,
+  [WearableAsset5]  uniqueidentifier NOT NULL,
+  [WearableItem6]  uniqueidentifier NOT NULL,
+  [WearableAsset6]  uniqueidentifier NOT NULL,
+  [WearableItem7]  uniqueidentifier NOT NULL,
+  [WearableAsset7]  uniqueidentifier NOT NULL,
+  [WearableItem8]  uniqueidentifier NOT NULL,
+  [WearableAsset8]  uniqueidentifier NOT NULL,
+  [WearableItem9]  uniqueidentifier NOT NULL,
+  [WearableAsset9]  uniqueidentifier NOT NULL,
+  [WearableItem10]  uniqueidentifier NOT NULL,
+  [WearableAsset10]  uniqueidentifier NOT NULL,
+  [WearableItem11]  uniqueidentifier NOT NULL,
+  [WearableAsset11]  uniqueidentifier NOT NULL,
+  [WearableItem12]  uniqueidentifier NOT NULL,
+  [WearableAsset12]  uniqueidentifier NOT NULL
+
+  PRIMARY KEY  CLUSTERED (
+  [UUID]
+  ) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
+) ON [PRIMARY]
+
+SET ANSI_PADDING OFF
-- 
cgit v1.1