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', current timestamp);
insert into Planeprice (PlaneReg, Discount, Altitude, Price, Userid, LastUpd, ClimatePrice)
	select PlaneReg, 'Standard medlem', Altitude, Price, 'Auto', current timestamp, 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', current timestamp);
insert into Planeprice (PlaneReg, Discount, Altitude, Price, Userid, LastUpd, ClimatePrice)
	select PlaneReg, 'Regular member', Altitude, Price, 'Auto', current timestamp, 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';