1 files changed, 0 insertions, 46 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql b/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql
index c3b0cb1..e69de29 100644
--- a/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql
+++ b/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql
@@ -1,46 +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,
-  [salePrice] [int] default NULL,
-  [saleType] [tinyint] default NULL,
-  [creationDate] [int] default NULL,
-  [groupID] [varchar](36) default NULL,
-  [groupOwned] [bit] default NULL,
-  [flags] [int] default NULL,
-  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/Data/MSSQL/Resources/CreateItemsTable.sql b/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql index c3b0cb1..e69de29 100644 --- a/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql +++ b/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql
@@ -1,46 +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	[salePrice] [int] default NULL,
22	[saleType] [tinyint] default NULL,
23	[creationDate] [int] default NULL,
24	[groupID] [varchar](36) default NULL,
25	[groupOwned] [bit] default NULL,
26	[flags] [int] default NULL,
27	PRIMARY KEY CLUSTERED
28	(
29	[inventoryID] ASC
30	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
31	) ON [PRIMARY]
32
33
34	CREATE NONCLUSTERED INDEX [owner] ON [inventoryitems]
35	(
36	[avatarID] ASC
37	)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]
38
39	CREATE NONCLUSTERED INDEX [folder] ON [inventoryitems]
40	(
41	[parentFolderID] 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]
43
44	SET ANSI_PADDING OFF
45
46