31 lines
1.7 KiB
SQL
Executable File
31 lines
1.7 KiB
SQL
Executable File
-- # $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;
|
|
|