USE my_db_name;

-- ONLY use ONE of the statements below, Swedish OR English !!!!!!!!!!!!!!!!!!!!!!!!
-- ONLY use ONE of the statements below, Swedish OR English !!!!!!!!!!!!!!!!!!!!!!!!
-- ONLY use ONE of the statements below, Swedish OR English !!!!!!!!!!!!!!!!!!!!!!!!

-- Swedish
-- New discount system for members of your own club
insert into `Typediscount` (`Discount`, `DiscountOrder`, `InUse`, `Userid`, `LastUpd`) values ('Standard medlem', -1, 'Y', 'Auto', Now());
insert into `Planeprice` (`PlaneReg`, `Discount`, `Altitude`, `Price`, `Userid`, `LastUpd`, `ClimatePrice`)
	select `PlaneReg`, 'Standard medlem', `Altitude`, `Price`, 'Auto', Now(), `ClimatePrice` from `Planeprice` where `Discount`=(select `Discount` from `Typediscount` where `DiscountOrder`=0);


-- English
-- New discount system for members of your own club
insert into `Typediscount` (`Discount`, `DiscountOrder`, `InUse`, `Userid`, `LastUpd`) values ('Regular member', -1, 'Y', 'Auto', Now());
insert into `Planeprice` (`PlaneReg`, `Discount`, `Altitude`, `Price`, `Userid`, `LastUpd`, `ClimatePrice`)
	select `PlaneReg`, 'Regular member', `Altitude`, `Price`, 'Auto', Now(), `ClimatePrice` from `Planeprice` where `Discount`=(select `Discount` from `Typediscount` where `DiscountOrder`=0);






-- New attribute
ALTER TABLE `Typealtitudes` ADD `AltitudeWishlist` char(1);
UPDATE `Typealtitudes` SET `AltitudeWishlist`='Y';

-- New version number
UPDATE `intDbinfo` SET `Dbversion` = '9.1.2';