diff options
author | Charles Krinke | 2008-06-05 13:57:58 +0000 |
---|---|---|
committer | Charles Krinke | 2008-06-05 13:57:58 +0000 |
commit | c289c2b6d48cb9f46a7573ed70705a13dda9c772 (patch) | |
tree | 140dbd721114536369c97a0a0470ec16f13efc45 /OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql | |
parent | Mantis#1451. Thank you kindly, Mikem for a patch that addresses: (diff) | |
download | opensim-SC_OLD-c289c2b6d48cb9f46a7573ed70705a13dda9c772.zip opensim-SC_OLD-c289c2b6d48cb9f46a7573ed70705a13dda9c772.tar.gz opensim-SC_OLD-c289c2b6d48cb9f46a7573ed70705a13dda9c772.tar.bz2 opensim-SC_OLD-c289c2b6d48cb9f46a7573ed70705a13dda9c772.tar.xz |
Mantis#1450. Thank you kindly, Boscata for a patch that addresses:
I have detected a bug of conversion data type in OpenSim.Data.MSSQL.MSSQLInventoryData.addInventoryItem(InventoryItemBase item)
in the GroupOwned field.
My sollution is to change the flield to bit in the table. In the
readInventoryItem(IDataReader reader) change too item.Flags =
(uint) reader["flags"]; to item.Flags = Convert.ToUInt32(reader["flags"]);
Now Inventory runs fine.
Diffstat (limited to 'OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql')
-rw-r--r-- | OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql | 3 |
1 files changed, 2 insertions, 1 deletions
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 | |||