UpgradeItemsTableToVersion3.sql 413 B

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