| 123456789 |
- 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;
|
