diff options
-rw-r--r-- | OpenSim/Data/MSSQL/MSSQLInventoryData.cs | 2 | ||||
-rw-r--r-- | OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql | 3 |
2 files changed, 3 insertions, 2 deletions
diff --git a/OpenSim/Data/MSSQL/MSSQLInventoryData.cs b/OpenSim/Data/MSSQL/MSSQLInventoryData.cs index 0c1c3f1..128fb8f 100644 --- a/OpenSim/Data/MSSQL/MSSQLInventoryData.cs +++ b/OpenSim/Data/MSSQL/MSSQLInventoryData.cs | |||
@@ -317,7 +317,7 @@ namespace OpenSim.Data.MSSQL | |||
317 | item.CreationDate = (int) reader["creationDate"]; | 317 | item.CreationDate = (int) reader["creationDate"]; |
318 | item.GroupID = new LLUUID(reader["groupID"].ToString()); | 318 | item.GroupID = new LLUUID(reader["groupID"].ToString()); |
319 | item.GroupOwned = Convert.ToBoolean(reader["groupOwned"]); | 319 | item.GroupOwned = Convert.ToBoolean(reader["groupOwned"]); |
320 | item.Flags = (uint) reader["flags"]; | 320 | item.Flags = Convert.ToUInt32(reader["flags"]); |
321 | 321 | ||
322 | return item; | 322 | return item; |
323 | } | 323 | } |
diff --git a/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql b/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql index 6f6bb43..7a76d47 100644 --- a/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql +++ b/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql | |||
@@ -22,7 +22,7 @@ CREATE TABLE [inventoryitems] ( | |||
22 | [saleType] [tinyint] default NULL, | 22 | [saleType] [tinyint] default NULL, |
23 | [creationDate] [int] default NULL, | 23 | [creationDate] [int] default NULL, |
24 | [groupID] [varchar](36) default NULL, | 24 | [groupID] [varchar](36) default NULL, |
25 | [groupOwned] [tinyint] default NULL, | 25 | [groupOwned] [bit] default NULL, |
26 | [flags] [int] unsigned default NULL, | 26 | [flags] [int] unsigned default NULL, |
27 | PRIMARY KEY CLUSTERED | 27 | PRIMARY KEY CLUSTERED |
28 | ( | 28 | ( |
@@ -43,3 +43,4 @@ CREATE NONCLUSTERED INDEX [folder] ON [inventoryitems] | |||
43 | 43 | ||
44 | SET ANSI_PADDING OFF | 44 | SET ANSI_PADDING OFF |
45 | 45 | ||
46 | |||