diff options
Diffstat (limited to 'OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql')
-rw-r--r-- | OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql b/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql index 5bb27ba..435d269 100644 --- a/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql +++ b/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql | |||
@@ -17,7 +17,13 @@ CREATE TABLE [inventoryitems] ( | |||
17 | [invType] [int] default NULL, | 17 | [invType] [int] default NULL, |
18 | [creatorID] [varchar](36) default NULL, | 18 | [creatorID] [varchar](36) default NULL, |
19 | [inventoryBasePermissions] [int] NOT NULL default 0, | 19 | [inventoryBasePermissions] [int] NOT NULL default 0, |
20 | [inventoryEveryOnePermissions] [int] NOT NULL default 0, | 20 | [inventoryEveryOnePermissions] [int] NOT NULL default 0, |
21 | [salePrice] [int] default NULL, | ||
22 | [saleType] [smallint] default NULL, | ||
23 | [creationDate] [int] default NULL, | ||
24 | [groupID] [varchar](36) default NULL, | ||
25 | [groupOwned] [smallint] default NULL, | ||
26 | [flags] [int] unsigned default NULL, | ||
21 | PRIMARY KEY CLUSTERED | 27 | PRIMARY KEY CLUSTERED |
22 | ( | 28 | ( |
23 | [inventoryID] ASC | 29 | [inventoryID] ASC |