aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql
diff options
context:
space:
mode:
authorCharles Krinke2008-06-05 13:57:58 +0000
committerCharles Krinke2008-06-05 13:57:58 +0000
commitc289c2b6d48cb9f46a7573ed70705a13dda9c772 (patch)
tree140dbd721114536369c97a0a0470ec16f13efc45 /OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql
parentMantis#1451. Thank you kindly, Mikem for a patch that addresses: (diff)
downloadopensim-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.sql3
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
44SET ANSI_PADDING OFF 44SET ANSI_PADDING OFF
45 45
46