whole lot more moving

author: Sean Dague 2008-04-02 15:24:31 +0000
committer: Sean Dague 2008-04-02 15:24:31 +0000
commit: c52c68f314c67c76c7181a6d0828f476290fbd66 (patch)
tree: 66ab347502892902a096fa985f31b25738eb1381 /OpenSim/Framework/Data.MSSQL/Resources
parent: reorganizing namespaces to put all the Data stuff into it's own namespace (diff)
download: opensim-SC_OLD-c52c68f314c67c76c7181a6d0828f476290fbd66.zip
opensim-SC_OLD-c52c68f314c67c76c7181a6d0828f476290fbd66.tar.gz
opensim-SC_OLD-c52c68f314c67c76c7181a6d0828f476290fbd66.tar.bz2
opensim-SC_OLD-c52c68f314c67c76c7181a6d0828f476290fbd66.tar.xz
9 files changed, 0 insertions, 283 deletions
diff --git a/OpenSim/Framework/Data.MSSQL/Resources/AvatarAppearance.sql b/OpenSim/Framework/Data.MSSQL/Resources/AvatarAppearance.sql
deleted file mode 100644
index ccefba2..0000000
--- a/OpenSim/Framework/Data.MSSQL/Resources/AvatarAppearance.sql
+++ /dev/null
@@ -1,44 +0,0 @@
--
-- 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
diff --git a/OpenSim/Framework/Data.MSSQL/Resources/CreateAssetsTable.sql b/OpenSim/Framework/Data.MSSQL/Resources/CreateAssetsTable.sql
deleted file mode 100644
index c7cb21a..0000000
--- a/OpenSim/Framework/Data.MSSQL/Resources/CreateAssetsTable.sql
+++ /dev/null
@@ -1,19 +0,0 @@
-SET ANSI_NULLS ON
-SET QUOTED_IDENTIFIER ON
-SET ANSI_PADDING ON
-CREATE TABLE [assets] (
-  [id] [varchar](36) NOT NULL,
-  [name] [varchar](64) NOT NULL,
-  [description] [varchar](64) NOT NULL,
-  [assetType] [tinyint] NOT NULL,
-  [invType] [tinyint] NOT NULL,
-  [local] [tinyint] NOT NULL,
-  [temporary] [tinyint] NOT NULL,
-  [data] [image] NOT NULL,
-PRIMARY KEY CLUSTERED 
-(
-        [id] ASC
-)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
diff --git a/OpenSim/Framework/Data.MSSQL/Resources/CreateFoldersTable.sql b/OpenSim/Framework/Data.MSSQL/Resources/CreateFoldersTable.sql
deleted file mode 100644
index 95d183a..0000000
--- a/OpenSim/Framework/Data.MSSQL/Resources/CreateFoldersTable.sql
+++ /dev/null
@@ -1,27 +0,0 @@
-SET ANSI_NULLS ON
-SET QUOTED_IDENTIFIER ON
-SET ANSI_PADDING ON
-CREATE TABLE [inventoryfolders] (
-  [folderID] [varchar](36) NOT NULL default '',
-  [agentID] [varchar](36) default NULL,
-  [parentFolderID] [varchar](36) default NULL,
-  [folderName] [varchar](64) default NULL,
-  [type] [smallint] NOT NULL default 0,
-  [version] [int] NOT NULL default 0,  
-  PRIMARY KEY CLUSTERED
-(
-        [folderID] ASC
-)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
-) ON [PRIMARY]
-CREATE NONCLUSTERED INDEX [owner] ON [inventoryfolders]
-(
-        [agentID] ASC
-)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
-CREATE NONCLUSTERED INDEX [parent] ON [inventoryfolders]
-(
-        [parentFolderID] ASC
-)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
-SET ANSI_PADDING OFF
diff --git a/OpenSim/Framework/Data.MSSQL/Resources/CreateItemsTable.sql b/OpenSim/Framework/Data.MSSQL/Resources/CreateItemsTable.sql
deleted file mode 100644
index 5bb27ba..0000000
--- a/OpenSim/Framework/Data.MSSQL/Resources/CreateItemsTable.sql
+++ /dev/null
@@ -1,39 +0,0 @@
-SET ANSI_NULLS ON
-SET QUOTED_IDENTIFIER ON
-SET ANSI_PADDING ON
-CREATE TABLE [inventoryitems] (
-  [inventoryID] [varchar](36) NOT NULL default '',
-  [assetID] [varchar](36) default NULL,
-  [assetType] [int] default NULL,
-  [parentFolderID] [varchar](36) default NULL,
-  [avatarID] [varchar](36) default NULL,
-  [inventoryName] [varchar](64) default NULL,
-  [inventoryDescription] [varchar](128) default NULL,
-  [inventoryNextPermissions] [int] default NULL,
-  [inventoryCurrentPermissions] [int] default NULL,
-  [invType] [int] default NULL,
-  [creatorID] [varchar](36) default NULL,
-  [inventoryBasePermissions] [int] NOT NULL default 0,
-  [inventoryEveryOnePermissions] [int] NOT NULL default 0, 
-  PRIMARY KEY CLUSTERED
-(
-        [inventoryID] ASC
-)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
-) ON [PRIMARY]
-CREATE NONCLUSTERED INDEX [owner] ON [inventoryitems]
-(
-        [avatarID] ASC
-)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
-CREATE NONCLUSTERED INDEX [folder] ON [inventoryitems]
-(
-        [parentFolderID] ASC
-)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
-SET ANSI_PADDING OFF
diff --git a/OpenSim/Framework/Data.MSSQL/Resources/CreateUserFriendsTable.sql b/OpenSim/Framework/Data.MSSQL/Resources/CreateUserFriendsTable.sql
deleted file mode 100644
index 6f5885e..0000000
--- a/OpenSim/Framework/Data.MSSQL/Resources/CreateUserFriendsTable.sql
+++ /dev/null
@@ -1,14 +0,0 @@
-SET ANSI_NULLS ON
-SET QUOTED_IDENTIFIER ON
-SET ANSI_PADDING ON
-CREATE TABLE [dbo].[userfriends](
-[ownerID] [varchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
-[friendID] [varchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
-[friendPerms] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
-[datetimestamp] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
-) ON [PRIMARY]
-SET ANSI_PADDING OFF
diff --git a/OpenSim/Framework/Data.MSSQL/Resources/Mssql-agents.sql b/OpenSim/Framework/Data.MSSQL/Resources/Mssql-agents.sql
deleted file mode 100644
index ad53173..0000000
--- a/OpenSim/Framework/Data.MSSQL/Resources/Mssql-agents.sql
+++ /dev/null
@@ -1,37 +0,0 @@
-SET ANSI_NULLS ON
-SET QUOTED_IDENTIFIER ON
-SET ANSI_PADDING ON
-CREATE TABLE [agents] (
-  [UUID] [varchar](36) NOT NULL,
-  [sessionID] [varchar](36) NOT NULL,
-  [secureSessionID] [varchar](36) NOT NULL,
-  [agentIP] [varchar](16) NOT NULL,
-  [agentPort] [int] NOT NULL,
-  [agentOnline] [tinyint] NOT NULL,
-  [loginTime] [int] NOT NULL,
-  [logoutTime] [int] NOT NULL,
-  [currentRegion] [varchar](36) NOT NULL,
-  [currentHandle] [bigint] NOT NULL,
-  [currentPos] [varchar](64) NOT NULL,
-  PRIMARY KEY CLUSTERED
-(
-        [UUID] ASC
-)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
-) ON [PRIMARY]
-CREATE NONCLUSTERED INDEX [session] ON [agents]
-(
-        [sessionID] ASC
-)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
-CREATE NONCLUSTERED INDEX [ssession] ON [agents]
-(
-        [secureSessionID] ASC
-)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
-SET ANSI_PADDING OFF
diff --git a/OpenSim/Framework/Data.MSSQL/Resources/Mssql-logs.sql b/OpenSim/Framework/Data.MSSQL/Resources/Mssql-logs.sql
deleted file mode 100644
index 3b747d8..0000000
--- a/OpenSim/Framework/Data.MSSQL/Resources/Mssql-logs.sql
+++ /dev/null
@@ -1,20 +0,0 @@
-SET ANSI_NULLS ON
-SET QUOTED_IDENTIFIER ON
-SET ANSI_PADDING ON
-CREATE TABLE [logs] (
-  [logID] [int] NOT NULL,
-  [target] [varchar](36) default NULL,
-  [server] [varchar](64) default NULL,
-  [method] [varchar](64) default NULL,
-  [arguments] [varchar](255) default NULL,
-  [priority] [int] default NULL,
-  [message] [ntext],
-  PRIMARY KEY CLUSTERED
-(
-        [logID] ASC
-)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
-) ON [PRIMARY]
diff --git a/OpenSim/Framework/Data.MSSQL/Resources/Mssql-regions.sql b/OpenSim/Framework/Data.MSSQL/Resources/Mssql-regions.sql
deleted file mode 100644
index b29a2ab..0000000
--- a/OpenSim/Framework/Data.MSSQL/Resources/Mssql-regions.sql
+++ /dev/null
@@ -1,41 +0,0 @@
-SET ANSI_NULLS ON
-SET QUOTED_IDENTIFIER ON
-SET ANSI_PADDING ON
-CREATE TABLE [dbo].[regions](
- [regionHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
- [regionName] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
- [uuid] [varchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
- [regionRecvKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
- [regionSecret] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
- [regionSendKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
- [regionDataURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
- [serverIP] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
- [serverPort] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
- [serverURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
- [locX] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
- [locY] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
- [locZ] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
- [eastOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
- [westOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
- [southOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
- [northOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
- [regionAssetURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
- [regionAssetRecvKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
- [regionAssetSendKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
- [regionUserURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
- [regionUserRecvKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
- [regionUserSendKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
- [regionMapTexture] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
- [serverHttpPort] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
- [serverRemotingPort] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
- [owner_uuid] [varchar](36) COLLATE Latin1_General_CI_AS NULL,
-PRIMARY KEY CLUSTERED 
-(
- [uuid] ASC
-)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
-) ON [PRIMARY]
-SET ANSI_PADDING OFF
diff --git a/OpenSim/Framework/Data.MSSQL/Resources/Mssql-users.sql b/OpenSim/Framework/Data.MSSQL/Resources/Mssql-users.sql
deleted file mode 100644
index abcc091..0000000
--- a/OpenSim/Framework/Data.MSSQL/Resources/Mssql-users.sql
+++ /dev/null
@@ -1,42 +0,0 @@
-SET ANSI_NULLS ON
-SET QUOTED_IDENTIFIER ON
-SET ANSI_PADDING ON
-CREATE TABLE [users] (
-  [UUID] [varchar](36) NOT NULL default '',
-  [username] [varchar](32) NOT NULL,
-  [lastname] [varchar](32) NOT NULL,
-  [passwordHash] [varchar](32) NOT NULL,
-  [passwordSalt] [varchar](32) NOT NULL,
-  [homeRegion] [bigint] default NULL,
-  [homeLocationX] [float] default NULL,
-  [homeLocationY] [float] default NULL,
-  [homeLocationZ] [float] default NULL,
-  [homeLookAtX] [float] default NULL,
-  [homeLookAtY] [float] default NULL,
-  [homeLookAtZ] [float] default NULL,
-  [created] [int] NOT NULL,
-  [lastLogin] [int] NOT NULL,
-  [userInventoryURI] [varchar](255) default NULL,
-  [userAssetURI] [varchar](255) default NULL,
-  [profileCanDoMask] [int] default NULL,
-  [profileWantDoMask] [int] default NULL,
-  [profileAboutText] [ntext],
-  [profileFirstText] [ntext],
-  [profileImage] [varchar](36) default NULL,
-  [profileFirstImage] [varchar](36) default NULL,
-  [webLoginKey] [varchar](36) default NULL,
-  PRIMARY KEY CLUSTERED
-(
-        [UUID] ASC
-)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
-) ON [PRIMARY]
-CREATE NONCLUSTERED INDEX [usernames] ON [users]
-(
-        [username] ASC,
-        [lastname] ASC
-)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
author	Sean Dague	2008-04-02 15:24:31 +0000
committer	Sean Dague	2008-04-02 15:24:31 +0000
commit	c52c68f314c67c76c7181a6d0828f476290fbd66 (patch)
tree	66ab347502892902a096fa985f31b25738eb1381 /OpenSim/Framework/Data.MSSQL/Resources
parent	reorganizing namespaces to put all the Data stuff into it's own namespace (diff)
download	opensim-SC_OLD-c52c68f314c67c76c7181a6d0828f476290fbd66.zip opensim-SC_OLD-c52c68f314c67c76c7181a6d0828f476290fbd66.tar.gz opensim-SC_OLD-c52c68f314c67c76c7181a6d0828f476290fbd66.tar.bz2 opensim-SC_OLD-c52c68f314c67c76c7181a6d0828f476290fbd66.tar.xz

diff --git a/OpenSim/Framework/Data.MSSQL/Resources/AvatarAppearance.sql b/OpenSim/Framework/Data.MSSQL/Resources/AvatarAppearance.sql deleted file mode 100644 index ccefba2..0000000 --- a/OpenSim/Framework/Data.MSSQL/Resources/AvatarAppearance.sql +++ /dev/null
@@ -1,44 +0,0 @@
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


diff --git a/OpenSim/Framework/Data.MSSQL/Resources/CreateAssetsTable.sql b/OpenSim/Framework/Data.MSSQL/Resources/CreateAssetsTable.sql deleted file mode 100644 index c7cb21a..0000000 --- a/OpenSim/Framework/Data.MSSQL/Resources/CreateAssetsTable.sql +++ /dev/null
@@ -1,19 +0,0 @@
1	SET ANSI_NULLS ON
2	SET QUOTED_IDENTIFIER ON
3	SET ANSI_PADDING ON
4	CREATE TABLE [assets] (
5	[id] [varchar](36) NOT NULL,
6	[name] [varchar](64) NOT NULL,
7	[description] [varchar](64) NOT NULL,
8	[assetType] [tinyint] NOT NULL,
9	[invType] [tinyint] NOT NULL,
10	[local] [tinyint] NOT NULL,
11	[temporary] [tinyint] NOT NULL,
12	[data] [image] NOT NULL,
13	PRIMARY KEY CLUSTERED
14	(
15	[id] ASC
16	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
17	) ON [PRIMARY]
18
19	SET ANSI_PADDING OFF


diff --git a/OpenSim/Framework/Data.MSSQL/Resources/CreateFoldersTable.sql b/OpenSim/Framework/Data.MSSQL/Resources/CreateFoldersTable.sql deleted file mode 100644 index 95d183a..0000000 --- a/OpenSim/Framework/Data.MSSQL/Resources/CreateFoldersTable.sql +++ /dev/null
@@ -1,27 +0,0 @@
1	SET ANSI_NULLS ON
2	SET QUOTED_IDENTIFIER ON
3	SET ANSI_PADDING ON
4	CREATE TABLE [inventoryfolders] (
5	[folderID] [varchar](36) NOT NULL default '',
6	[agentID] [varchar](36) default NULL,
7	[parentFolderID] [varchar](36) default NULL,
8	[folderName] [varchar](64) default NULL,
9	[type] [smallint] NOT NULL default 0,
10	[version] [int] NOT NULL default 0,
11	PRIMARY KEY CLUSTERED
12	(
13	[folderID] ASC
14	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
15	) ON [PRIMARY]
16
17	CREATE NONCLUSTERED INDEX [owner] ON [inventoryfolders]
18	(
19	[agentID] ASC
20	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
21
22	CREATE NONCLUSTERED INDEX [parent] ON [inventoryfolders]
23	(
24	[parentFolderID] ASC
25	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
26
27	SET ANSI_PADDING OFF


diff --git a/OpenSim/Framework/Data.MSSQL/Resources/CreateItemsTable.sql b/OpenSim/Framework/Data.MSSQL/Resources/CreateItemsTable.sql deleted file mode 100644 index 5bb27ba..0000000 --- a/OpenSim/Framework/Data.MSSQL/Resources/CreateItemsTable.sql +++ /dev/null
@@ -1,39 +0,0 @@
1	SET ANSI_NULLS ON
2
3	SET QUOTED_IDENTIFIER ON
4
5	SET ANSI_PADDING ON
6
7	CREATE TABLE [inventoryitems] (
8	[inventoryID] [varchar](36) NOT NULL default '',
9	[assetID] [varchar](36) default NULL,
10	[assetType] [int] default NULL,
11	[parentFolderID] [varchar](36) default NULL,
12	[avatarID] [varchar](36) default NULL,
13	[inventoryName] [varchar](64) default NULL,
14	[inventoryDescription] [varchar](128) default NULL,
15	[inventoryNextPermissions] [int] default NULL,
16	[inventoryCurrentPermissions] [int] default NULL,
17	[invType] [int] default NULL,
18	[creatorID] [varchar](36) default NULL,
19	[inventoryBasePermissions] [int] NOT NULL default 0,
20	[inventoryEveryOnePermissions] [int] NOT NULL default 0,
21	PRIMARY KEY CLUSTERED
22	(
23	[inventoryID] ASC
24	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
25	) ON [PRIMARY]
26
27
28	CREATE NONCLUSTERED INDEX [owner] ON [inventoryitems]
29	(
30	[avatarID] ASC
31	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
32
33	CREATE NONCLUSTERED INDEX [folder] ON [inventoryitems]
34	(
35	[parentFolderID] ASC
36	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
37
38	SET ANSI_PADDING OFF
39


diff --git a/OpenSim/Framework/Data.MSSQL/Resources/CreateUserFriendsTable.sql b/OpenSim/Framework/Data.MSSQL/Resources/CreateUserFriendsTable.sql deleted file mode 100644 index 6f5885e..0000000 --- a/OpenSim/Framework/Data.MSSQL/Resources/CreateUserFriendsTable.sql +++ /dev/null
@@ -1,14 +0,0 @@
1	SET ANSI_NULLS ON
2
3	SET QUOTED_IDENTIFIER ON
4
5	SET ANSI_PADDING ON
6
7	CREATE TABLE [dbo].[userfriends](
8	[ownerID] [varchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
9	[friendID] [varchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
10	[friendPerms] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
11	[datetimestamp] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
12	) ON [PRIMARY]
13
14	SET ANSI_PADDING OFF


diff --git a/OpenSim/Framework/Data.MSSQL/Resources/Mssql-agents.sql b/OpenSim/Framework/Data.MSSQL/Resources/Mssql-agents.sql deleted file mode 100644 index ad53173..0000000 --- a/OpenSim/Framework/Data.MSSQL/Resources/Mssql-agents.sql +++ /dev/null
@@ -1,37 +0,0 @@
1	SET ANSI_NULLS ON
2
3	SET QUOTED_IDENTIFIER ON
4
5	SET ANSI_PADDING ON
6
7	CREATE TABLE [agents] (
8	[UUID] [varchar](36) NOT NULL,
9	[sessionID] [varchar](36) NOT NULL,
10	[secureSessionID] [varchar](36) NOT NULL,
11	[agentIP] [varchar](16) NOT NULL,
12	[agentPort] [int] NOT NULL,
13	[agentOnline] [tinyint] NOT NULL,
14	[loginTime] [int] NOT NULL,
15	[logoutTime] [int] NOT NULL,
16	[currentRegion] [varchar](36) NOT NULL,
17	[currentHandle] [bigint] NOT NULL,
18	[currentPos] [varchar](64) NOT NULL,
19	PRIMARY KEY CLUSTERED
20	(
21	[UUID] ASC
22	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
23	) ON [PRIMARY]
24
25
26	CREATE NONCLUSTERED INDEX [session] ON [agents]
27	(
28	[sessionID] ASC
29	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
30
31	CREATE NONCLUSTERED INDEX [ssession] ON [agents]
32	(
33	[secureSessionID] ASC
34	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
35
36	SET ANSI_PADDING OFF
37


diff --git a/OpenSim/Framework/Data.MSSQL/Resources/Mssql-logs.sql b/OpenSim/Framework/Data.MSSQL/Resources/Mssql-logs.sql deleted file mode 100644 index 3b747d8..0000000 --- a/OpenSim/Framework/Data.MSSQL/Resources/Mssql-logs.sql +++ /dev/null
@@ -1,20 +0,0 @@
1	SET ANSI_NULLS ON
2
3	SET QUOTED_IDENTIFIER ON
4
5	SET ANSI_PADDING ON
6
7	CREATE TABLE [logs] (
8	[logID] [int] NOT NULL,
9	[target] [varchar](36) default NULL,
10	[server] [varchar](64) default NULL,
11	[method] [varchar](64) default NULL,
12	[arguments] [varchar](255) default NULL,
13	[priority] [int] default NULL,
14	[message] [ntext],
15	PRIMARY KEY CLUSTERED
16	(
17	[logID] ASC
18	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
19	) ON [PRIMARY]
20


diff --git a/OpenSim/Framework/Data.MSSQL/Resources/Mssql-regions.sql b/OpenSim/Framework/Data.MSSQL/Resources/Mssql-regions.sql deleted file mode 100644 index b29a2ab..0000000 --- a/OpenSim/Framework/Data.MSSQL/Resources/Mssql-regions.sql +++ /dev/null
@@ -1,41 +0,0 @@
1	SET ANSI_NULLS ON
2
3	SET QUOTED_IDENTIFIER ON
4
5	SET ANSI_PADDING ON
6
7	CREATE TABLE [dbo].[regions](
8	[regionHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
9	[regionName] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
10	[uuid] [varchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
11	[regionRecvKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
12	[regionSecret] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
13	[regionSendKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
14	[regionDataURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
15	[serverIP] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
16	[serverPort] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
17	[serverURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
18	[locX] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
19	[locY] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
20	[locZ] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
21	[eastOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
22	[westOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
23	[southOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
24	[northOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
25	[regionAssetURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
26	[regionAssetRecvKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
27	[regionAssetSendKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
28	[regionUserURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
29	[regionUserRecvKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
30	[regionUserSendKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
31	[regionMapTexture] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
32	[serverHttpPort] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
33	[serverRemotingPort] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
34	[owner_uuid] [varchar](36) COLLATE Latin1_General_CI_AS NULL,
35	PRIMARY KEY CLUSTERED
36	(
37	[uuid] ASC
38	)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
39	) ON [PRIMARY]
40
41	SET ANSI_PADDING OFF


diff --git a/OpenSim/Framework/Data.MSSQL/Resources/Mssql-users.sql b/OpenSim/Framework/Data.MSSQL/Resources/Mssql-users.sql deleted file mode 100644 index abcc091..0000000 --- a/OpenSim/Framework/Data.MSSQL/Resources/Mssql-users.sql +++ /dev/null
@@ -1,42 +0,0 @@
1	SET ANSI_NULLS ON
2
3	SET QUOTED_IDENTIFIER ON
4
5	SET ANSI_PADDING ON
6
7	CREATE TABLE [users] (
8	[UUID] [varchar](36) NOT NULL default '',
9	[username] [varchar](32) NOT NULL,
10	[lastname] [varchar](32) NOT NULL,
11	[passwordHash] [varchar](32) NOT NULL,
12	[passwordSalt] [varchar](32) NOT NULL,
13	[homeRegion] [bigint] default NULL,
14	[homeLocationX] [float] default NULL,
15	[homeLocationY] [float] default NULL,
16	[homeLocationZ] [float] default NULL,
17	[homeLookAtX] [float] default NULL,
18	[homeLookAtY] [float] default NULL,
19	[homeLookAtZ] [float] default NULL,
20	[created] [int] NOT NULL,
21	[lastLogin] [int] NOT NULL,
22	[userInventoryURI] [varchar](255) default NULL,
23	[userAssetURI] [varchar](255) default NULL,
24	[profileCanDoMask] [int] default NULL,
25	[profileWantDoMask] [int] default NULL,
26	[profileAboutText] [ntext],
27	[profileFirstText] [ntext],
28	[profileImage] [varchar](36) default NULL,
29	[profileFirstImage] [varchar](36) default NULL,
30	[webLoginKey] [varchar](36) default NULL,
31	PRIMARY KEY CLUSTERED
32	(
33	[UUID] ASC
34	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
35	) ON [PRIMARY]
36
37
38	CREATE NONCLUSTERED INDEX [usernames] ON [users]
39	(
40	[username] ASC,
41	[lastname] ASC
42	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]