diff options
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/CreateItemsTable.sql')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/CreateItemsTable.sql | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/OpenSim/Data/MySQL/Resources/CreateItemsTable.sql b/OpenSim/Data/MySQL/Resources/CreateItemsTable.sql index 1723ee3..c8b7481 100644 --- a/OpenSim/Data/MySQL/Resources/CreateItemsTable.sql +++ b/OpenSim/Data/MySQL/Resources/CreateItemsTable.sql | |||
@@ -12,7 +12,13 @@ CREATE TABLE `inventoryitems` ( | |||
12 | `creatorID` varchar(36) default NULL, | 12 | `creatorID` varchar(36) default NULL, |
13 | `inventoryBasePermissions` int(10) unsigned NOT NULL default 0, | 13 | `inventoryBasePermissions` int(10) unsigned NOT NULL default 0, |
14 | `inventoryEveryOnePermissions` int(10) unsigned NOT NULL default 0, | 14 | `inventoryEveryOnePermissions` int(10) unsigned NOT NULL default 0, |
15 | `salePrice` int(11) default NULL, | ||
16 | `saleType` tinyint(4) default NULL, | ||
17 | `creationDate` int(11) default NULL, | ||
18 | `groupID` varchar(63) default NULL, | ||
19 | `groupOwned` tinyint(4) default NULL, | ||
20 | `flags` int(11) unsigned default NULL, | ||
15 | PRIMARY KEY (`inventoryID`), | 21 | PRIMARY KEY (`inventoryID`), |
16 | KEY `owner` (`avatarID`), | 22 | KEY `owner` (`avatarID`), |
17 | KEY `folder` (`parentFolderID`) | 23 | KEY `folder` (`parentFolderID`) |
18 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 2'; | 24 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 3'; |