-- # $Id$
-- # $HeadURL$
-- # $Author$

-- 39Q XG 1000000 0000000 = 52.0773822899, 23.5064684201 (  0.9089217868,  0.4102652694 )
INSERT INTO asm.asm_training_area(id, name, bottom_left_x, bottom_left_y, height, width) VALUES (1, 'Alhamra', 0.9089217868, 0.4102652694, 60000, 70000);
-- 40R CP 9000000 0000000 = 55.9071785561, 25.3125026410 (  0.9757643413,  0.4417865130 )
INSERT INTO asm.asm_training_area(id, name, bottom_left_x, bottom_left_y, height, width) VALUES (3, 'Thoban1', 0.9757643413, 0.4417865130,  7000, 16000);
-- 40R DN 0000000 9000000 = 56.0072483221, 25.2229115575 (  0.9775108882,  0.4402228536 )
INSERT INTO asm.asm_training_area(id, name, bottom_left_x, bottom_left_y, height, width) VALUES (4, 'Thoban2', 0.9775108882, 0.4402228536, 12000,  7000);
-- 32U MD 8800000 7500000 =  8.8210891905, 53.0244018451 (  0.1539570500,  0.9254503961 )
INSERT INTO asm.asm_training_area(id, name, bottom_left_x, bottom_left_y, height, width) VALUES (6, 'Bremen',  0.1539570500,  0.9254503961, 12800, 12800);

ALTER SEQUENCE asm.asm_training_area_id_seq RESTART WITH 7;

-- default values for Technical areas
-- Alhamra
INSERT INTO asm.asm_technical_area (id, name, training_area_id, position_x, position_y, width, length, charge_type_id)
  VALUES (1, 'Mout Area', 1, 0.914694298065828026, 0.419672824247224019, 639, 417, 421);

-- Bremen
INSERT INTO asm.asm_technical_area (id, name, training_area_id, position_x, position_y, width, length, charge_type_id)
  VALUES (2, 'Mout Area', 6, 0.155279386360796, 0.92597355781270696, 91, 69, 421);

ALTER SEQUENCE asm.asm_technical_area_id_seq RESTART WITH 3;

-- Locations
--INSERT INTO asm.asm_location(id, name, description) VALUES (9, 'Default', 'Default location');
--ALTER SEQUENCE asm.asm_location_id_seq RESTART WITH 10;