Files
qt5-legatus-legacy/Lts/Tests/DatabaseInitialisation/guez_avm_values_test.sql
2026-08-13 18:33:10 +02:00

37 lines
3.0 KiB
SQL
Executable File

-- # $Id$
-- # $HeadURL$
-- # $Author$
-- test data for MVS, using MSE 200-204
INSERT INTO avm.avm_video_receiver (id, team_id, main_structure_element_id, stream_name) VALUES ( 1, 1, 200, 'MVS01');
INSERT INTO avm.avm_video_receiver (id, team_id, main_structure_element_id, stream_name) VALUES ( 2, 1, 201, 'MVS01');
INSERT INTO avm.avm_video_receiver (id, team_id, main_structure_element_id, stream_name) VALUES ( 3, 1, 202, 'MVS01');
INSERT INTO avm.avm_video_receiver (id, team_id, main_structure_element_id, stream_name) VALUES ( 4, 1, 203, 'MVS01');
INSERT INTO avm.avm_video_receiver (id, team_id, main_structure_element_id, stream_name) VALUES ( 5, 1, 204, 'MVS01');
INSERT INTO avm.avm_video_receiver (id, team_id, main_structure_element_id, stream_name) VALUES ( 6, 2, 200, 'MVS02');
INSERT INTO avm.avm_video_receiver (id, team_id, main_structure_element_id, stream_name) VALUES ( 7, 2, 201, 'MVS02');
INSERT INTO avm.avm_video_receiver (id, team_id, main_structure_element_id, stream_name) VALUES ( 8, 2, 202, 'MVS02');
INSERT INTO avm.avm_video_receiver (id, team_id, main_structure_element_id, stream_name) VALUES ( 9, 2, 203, 'MVS02');
INSERT INTO avm.avm_video_receiver (id, team_id, main_structure_element_id, stream_name) VALUES (10, 2, 204, 'MVS02');
INSERT INTO avm.avm_video_receiver (id, team_id, main_structure_element_id, stream_name) VALUES (11, 3, 200, 'MVS03');
INSERT INTO avm.avm_video_receiver (id, team_id, main_structure_element_id, stream_name) VALUES (12, 3, 201, 'MVS03');
INSERT INTO avm.avm_video_receiver (id, team_id, main_structure_element_id, stream_name) VALUES (13, 3, 202, 'MVS03');
INSERT INTO avm.avm_video_receiver (id, team_id, main_structure_element_id, stream_name) VALUES (14, 3, 203, 'MVS03');
INSERT INTO avm.avm_video_receiver (id, team_id, main_structure_element_id, stream_name) VALUES (15, 3, 204, 'MVS03');
INSERT INTO avm.avm_video_receiver (id, team_id, main_structure_element_id, stream_name) VALUES (16, 4, 200, 'MVS04');
INSERT INTO avm.avm_video_receiver (id, team_id, main_structure_element_id, stream_name) VALUES (17, 4, 201, 'MVS04');
INSERT INTO avm.avm_video_receiver (id, team_id, main_structure_element_id, stream_name) VALUES (18, 4, 202, 'MVS04');
INSERT INTO avm.avm_video_receiver (id, team_id, main_structure_element_id, stream_name) VALUES (19, 4, 203, 'MVS04');
INSERT INTO avm.avm_video_receiver (id, team_id, main_structure_element_id, stream_name) VALUES (20, 4, 204, 'MVS04');
INSERT INTO avm.avm_video_receiver (id, team_id, main_structure_element_id, stream_name) VALUES (21, 5, 200, 'MVS05');
INSERT INTO avm.avm_video_receiver (id, team_id, main_structure_element_id, stream_name) VALUES (22, 5, 201, 'MVS05');
INSERT INTO avm.avm_video_receiver (id, team_id, main_structure_element_id, stream_name) VALUES (23, 5, 202, 'MVS05');
INSERT INTO avm.avm_video_receiver (id, team_id, main_structure_element_id, stream_name) VALUES (24, 5, 203, 'MVS05');
INSERT INTO avm.avm_video_receiver (id, team_id, main_structure_element_id, stream_name) VALUES (25, 5, 204, 'MVS05');
ALTER SEQUENCE avm.avm_video_receiver_id_seq RESTART WITH 26;