diff options
Diffstat (limited to 'OpenSim/Framework/Data.MySQL/Resources/UpgradeItemsTableToVersion2.sql')
-rw-r--r-- | OpenSim/Framework/Data.MySQL/Resources/UpgradeItemsTableToVersion2.sql | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/OpenSim/Framework/Data.MySQL/Resources/UpgradeItemsTableToVersion2.sql b/OpenSim/Framework/Data.MySQL/Resources/UpgradeItemsTableToVersion2.sql index c47786c..d1ef504 100644 --- a/OpenSim/Framework/Data.MySQL/Resources/UpgradeItemsTableToVersion2.sql +++ b/OpenSim/Framework/Data.MySQL/Resources/UpgradeItemsTableToVersion2.sql | |||
@@ -1,9 +1,9 @@ | |||
1 | ALTER TABLE `inventoryitems` | 1 | ALTER TABLE `inventoryitems` |
2 | CHANGE COLUMN `type` `assetType` int(11) default NULL, | 2 | CHANGE COLUMN `type` `assetType` int(11) default NULL, |
3 | ADD COLUMN `invType` int(11) default NULL, | 3 | ADD COLUMN `invType` int(11) default NULL, |
4 | ADD COLUMN `creatorID` varchar(36) default NULL, | 4 | ADD COLUMN `creatorID` varchar(36) default NULL, |
5 | ADD COLUMN `inventoryBasePermissions` int(10) unsigned NOT NULL default 0, | 5 | ADD COLUMN `inventoryBasePermissions` int(10) unsigned NOT NULL default 0, |
6 | ADD COLUMN `inventoryEveryOnePermissions` int(10) unsigned NOT NULL default 0, | 6 | ADD COLUMN `inventoryEveryOnePermissions` int(10) unsigned NOT NULL default 0, |
7 | COMMENT='Rev. 2'; | 7 | COMMENT='Rev. 2'; |
8 | 8 | ||
9 | UPDATE `inventoryitems` SET invType=assetType; | 9 | UPDATE `inventoryitems` SET invType=assetType; |