1 files changed, 9 insertions, 0 deletions

diff --git a/OpenSim/Framework/Data.MySQL/Resources/UpgradeItemsTableToVersion2.sql b/OpenSim/Framework/Data.MySQL/Resources/UpgradeItemsTableToVersion2.sql
new file mode 100644
index 0000000..c47786c
--- /dev/null
+++ b/OpenSim/Framework/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;