diff options
| author | Justin Clarke Casey | 2008-05-01 13:27:40 +0000 |
|---|---|---|
| committer | Justin Clarke Casey | 2008-05-01 13:27:40 +0000 |
| commit | d72bdf432a622f237b3030c1da9d1bccca20f83c (patch) | |
| tree | 80b72df740a2858ac9ca8c3707ef45ff81488f67 /OpenSim/Data/MySQL/Resources/CreateItemsTable.sql | |
| parent | * Change mysql inventory items table version 3 upgrade sql to provide explici... (diff) | |
| download | opensim-SC-d72bdf432a622f237b3030c1da9d1bccca20f83c.zip opensim-SC-d72bdf432a622f237b3030c1da9d1bccca20f83c.tar.gz opensim-SC-d72bdf432a622f237b3030c1da9d1bccca20f83c.tar.bz2 opensim-SC-d72bdf432a622f237b3030c1da9d1bccca20f83c.tar.xz | |
* Align new fields upgrade sql to have the same 'not null' and default settings as when an inventoryitems table is newly created
* Normalize logging titles in database code, though this doesn't yet cover invoking code
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/CreateItemsTable.sql')
| -rw-r--r-- | OpenSim/Data/MySQL/Resources/CreateItemsTable.sql | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/OpenSim/Data/MySQL/Resources/CreateItemsTable.sql b/OpenSim/Data/MySQL/Resources/CreateItemsTable.sql index 24ebccd..ffdbe17 100644 --- a/OpenSim/Data/MySQL/Resources/CreateItemsTable.sql +++ b/OpenSim/Data/MySQL/Resources/CreateItemsTable.sql | |||
| @@ -12,12 +12,12 @@ 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, | 15 | `salePrice` int(11) NOT NULL default 0, |
| 16 | `saleType` tinyint(4) default NULL, | 16 | `saleType` tinyint(4) NOT NULL default 0, |
| 17 | `creationDate` int(11) default NULL, | 17 | `creationDate` int(11) NOT NULL default 0, |
| 18 | `groupID` varchar(36) default NULL, | 18 | `groupID` varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000', |
| 19 | `groupOwned` tinyint(4) default NULL, | 19 | `groupOwned` tinyint(4) NOT NULL default 0, |
| 20 | `flags` int(11) unsigned default NULL, | 20 | `flags` int(11) unsigned NOT NULL default 0, |
| 21 | PRIMARY KEY (`inventoryID`), | 21 | PRIMARY KEY (`inventoryID`), |
| 22 | KEY `owner` (`avatarID`), | 22 | KEY `owner` (`avatarID`), |
| 23 | KEY `folder` (`parentFolderID`) | 23 | KEY `folder` (`parentFolderID`) |