OpenSim/Data/MySQL/Resources/UpgradeItemsTableToVersion3.sql


1
2
3
4
5
6
7
8

ALTER TABLE `inventoryitems` 
	ADD COLUMN `salePrice` int(11) NOT NULL default 0,
	ADD COLUMN `saleType` tinyint(4) NOT NULL default 0,
	ADD COLUMN `creationDate` int(11) NOT NULL default 3000,
	ADD COLUMN `groupID` varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
	ADD COLUMN `groupOwned` tinyint(4) NOT NULL default 0,
	ADD COLUMN `flags` int(11) unsigned NOT NULL default 0,
COMMENT='Rev. 3';