1 files changed, 9 insertions, 0 deletions

diff --git a/OpenSim/Data/MySQL/Resources/UpgradeItemsTableToVersion2.sql b/OpenSim/Data/MySQL/Resources/UpgradeItemsTableToVersion2.sql
new file mode 100644
index 0000000..d1ef504
--- /dev/null
+++ b/OpenSim/Data/MySQL/Resources/UpgradeItemsTableToVersion2.sql
@@ -0,0 +1,9 @@
+ALTER TABLE `inventoryitems` 
+        CHANGE COLUMN `type` `assetType` int(11) default NULL,
+        ADD COLUMN `invType` int(11) default NULL,
+        ADD COLUMN `creatorID` varchar(36) default NULL,
+        ADD COLUMN `inventoryBasePermissions` int(10) unsigned NOT NULL default 0,
+        ADD COLUMN `inventoryEveryOnePermissions` int(10) unsigned NOT NULL default 0,
+COMMENT='Rev. 2';
+
+UPDATE `inventoryitems` SET invType=assetType;