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 '')
-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`) |