* Added AvatarAppearance.sql for MSSQL

author: lbsa71 2008-04-02 13:06:52 +0000
committer: lbsa71 2008-04-02 13:06:52 +0000
commit: f210cf01956eecc92495d005174a8cd6cef27a55 (patch)
tree: e8e56fc5830ab42026a27451203d22081fae7c83
parent: * Reworked Data Framework so that MSSQL works (diff)
download: opensim-SC_OLD-f210cf01956eecc92495d005174a8cd6cef27a55.zip
opensim-SC_OLD-f210cf01956eecc92495d005174a8cd6cef27a55.tar.gz
opensim-SC_OLD-f210cf01956eecc92495d005174a8cd6cef27a55.tar.bz2
opensim-SC_OLD-f210cf01956eecc92495d005174a8cd6cef27a55.tar.xz
1 files changed, 44 insertions, 0 deletions
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
author	lbsa71	2008-04-02 13:06:52 +0000
committer	lbsa71	2008-04-02 13:06:52 +0000
commit	f210cf01956eecc92495d005174a8cd6cef27a55 (patch)
tree	e8e56fc5830ab42026a27451203d22081fae7c83
parent	* Reworked Data Framework so that MSSQL works (diff)
download	opensim-SC_OLD-f210cf01956eecc92495d005174a8cd6cef27a55.zip opensim-SC_OLD-f210cf01956eecc92495d005174a8cd6cef27a55.tar.gz opensim-SC_OLD-f210cf01956eecc92495d005174a8cd6cef27a55.tar.bz2 opensim-SC_OLD-f210cf01956eecc92495d005174a8cd6cef27a55.tar.xz

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 @@
	1	--
	2	-- Create schema avatar_appearance
	3	--
	4
	5	SET ANSI_NULLS ON
	6	SET QUOTED_IDENTIFIER ON
	7	SET ANSI_PADDING ON
	8
	9	CREATE TABLE [avatarappearance] (
	10	[UUID] uniqueidentifier NOT NULL,
	11	[Serial] int NOT NULL,
	12	[WearableItem0] uniqueidentifier NOT NULL,
	13	[WearableAsset0] uniqueidentifier NOT NULL,
	14	[WearableItem1] uniqueidentifier NOT NULL,
	15	[WearableAsset1] uniqueidentifier NOT NULL,
	16	[WearableItem2] uniqueidentifier NOT NULL,
	17	[WearableAsset2] uniqueidentifier NOT NULL,
	18	[WearableItem3] uniqueidentifier NOT NULL,
	19	[WearableAsset3] uniqueidentifier NOT NULL,
	20	[WearableItem4] uniqueidentifier NOT NULL,
	21	[WearableAsset4] uniqueidentifier NOT NULL,
	22	[WearableItem5] uniqueidentifier NOT NULL,
	23	[WearableAsset5] uniqueidentifier NOT NULL,
	24	[WearableItem6] uniqueidentifier NOT NULL,
	25	[WearableAsset6] uniqueidentifier NOT NULL,
	26	[WearableItem7] uniqueidentifier NOT NULL,
	27	[WearableAsset7] uniqueidentifier NOT NULL,
	28	[WearableItem8] uniqueidentifier NOT NULL,
	29	[WearableAsset8] uniqueidentifier NOT NULL,
	30	[WearableItem9] uniqueidentifier NOT NULL,
	31	[WearableAsset9] uniqueidentifier NOT NULL,
	32	[WearableItem10] uniqueidentifier NOT NULL,
	33	[WearableAsset10] uniqueidentifier NOT NULL,
	34	[WearableItem11] uniqueidentifier NOT NULL,
	35	[WearableAsset11] uniqueidentifier NOT NULL,
	36	[WearableItem12] uniqueidentifier NOT NULL,
	37	[WearableAsset12] uniqueidentifier NOT NULL
	38
	39	PRIMARY KEY CLUSTERED (
	40	[UUID]
	41	) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
	42	) ON [PRIMARY]
	43
	44	SET ANSI_PADDING OFF