117 lines
3.7 KiB
SQL
Executable File
117 lines
3.7 KiB
SQL
Executable File
-- # $Id$
|
|
-- # $HeadURL$
|
|
-- # $Author$
|
|
|
|
-- Test data for AVM
|
|
|
|
INSERT INTO avm.avm_tvc_channel (id, name, ssrc, port) VALUES
|
|
( 1, 'TVC01', 9001, 54322),
|
|
( 2, 'TVC02', 9002, 54324),
|
|
( 3, 'TVC03', 9003, 54326),
|
|
( 4, 'TVC04', 9004, 54328),
|
|
( 5, 'TVC05', 9005, 54330),
|
|
( 6, 'TVC06', 9006, 54332),
|
|
( 7, 'TVC07', 9007, 54334),
|
|
( 8, 'TVC08', 9008, 54336),
|
|
( 9, 'TVC09', 9009, 54338),
|
|
(10, 'TVC10', 9010, 54340),
|
|
(11, 'TVC11', 9011, 54342),
|
|
(12, 'TVC12', 9012, 54344),
|
|
(13, 'TVC13', 9013, 54346),
|
|
(14, 'TVC14', 9014, 54348),
|
|
(15, 'TVC15', 9015, 54350),
|
|
(16, 'TVC16', 9016, 54352),
|
|
(17, 'TVC17', 9017, 54354),
|
|
(18, 'TVC18', 9018, 54356),
|
|
(19, 'TVC19', 9019, 54358),
|
|
(20, 'TVC20', 9020, 54360),
|
|
(21, 'TVC21', 9021, 54362),
|
|
(22, 'TVC22', 9022, 54364),
|
|
(23, 'TVC23', 9023, 54366),
|
|
(24, 'TVC24', 9024, 54368),
|
|
(25, 'TVC25', 9025, 54370),
|
|
(26, 'TVC26', 9026, 54372),
|
|
(27, 'TVC27', 9027, 54374),
|
|
(28, 'TVC28', 9028, 54376),
|
|
(29, 'TVC29', 9029, 54378),
|
|
(30, 'TVC30', 9030, 54380),
|
|
(31, 'TVC00', 9000, 54320);
|
|
|
|
ALTER SEQUENCE avm.avm_tvc_channel_id_seq RESTART WITH 51;
|
|
|
|
INSERT INTO avm.avm_cnr_channel (id, name, ssrc, addac_channel, ptt_control) VALUES
|
|
( 1, 'HF_01', 1001, 1, TRUE),
|
|
( 2, 'HF_02', 1002, 2, TRUE),
|
|
( 3, 'VHF01', 1003, 3, TRUE),
|
|
( 4, 'VHF02', 1004, 4, TRUE),
|
|
( 5, 'VHF03', 1005, 5, TRUE),
|
|
( 6, 'VHF04', 1006, 6, TRUE),
|
|
( 7, 'VHF05', 1007, 7, TRUE),
|
|
( 8, 'VHF06', 1008, 8, TRUE),
|
|
( 9, 'VHF07', 1009, 9, TRUE),
|
|
(10, 'VHF08', 1010, 10, TRUE),
|
|
(11, 'VHF09', 1011, 11, TRUE),
|
|
(12, 'VHF10', 1012, 12, TRUE),
|
|
(13, 'VHF11', 1013, 13, TRUE),
|
|
(14, 'VHF12', 1014, 14, TRUE),
|
|
(15, 'VHF13', 1015, 15, TRUE),
|
|
(16, 'VHF14', 1016, 16, TRUE),
|
|
(17, 'VHF15', 1017, 17, TRUE),
|
|
(18, 'VHF16', 1018, 18, TRUE),
|
|
(19, 'VHF17', 1019, 19, TRUE),
|
|
(20, 'VHF18', 1020, 20, TRUE),
|
|
(21, 'VHF19', 1021, 21, TRUE),
|
|
(22, 'VHF20', 1022, 22, TRUE),
|
|
(23, 'VHF21', 1023, 23, TRUE),
|
|
(24, 'VHF22', 1024, 24, TRUE),
|
|
(25, 'VHF23', 1025, 25, TRUE),
|
|
(26, 'VHF24', 1026, 26, TRUE),
|
|
(27, 'VHF25', 1027, 27, TRUE),
|
|
(28, 'VHF26', 1028, 28, TRUE),
|
|
(29, 'VHF27', 1029, 29, TRUE),
|
|
(30, 'VHF28', 1030, 30, TRUE),
|
|
(31, 'VHF29', 1031, 31, TRUE),
|
|
(32, 'VHF30', 1032, 32, TRUE),
|
|
(33, 'VHF31', 1033, 33, TRUE),
|
|
(34, 'VHF32', 1034, 34, TRUE),
|
|
(35, 'VHF33', 1035, 35, TRUE),
|
|
(36, 'VHF34', 1036, 36, TRUE),
|
|
(37, 'VHF35', 1037, 37, TRUE),
|
|
(38, 'VHF36', 1038, 38, TRUE),
|
|
(39, 'VHF37', 1039, 39, TRUE),
|
|
(40, 'VHF38', 1040, 40, TRUE),
|
|
(41, 'VHF39', 1041, 41, TRUE),
|
|
(42, 'VHF40', 1042, 42, TRUE),
|
|
(43, 'VHF41', 1043, 43, TRUE),
|
|
(44, 'VHF42', 1044, 44, TRUE),
|
|
(45, 'VHF43', 1045, 45, TRUE),
|
|
(46, 'VHF44', 1046, 46, TRUE),
|
|
(47, 'VHF45', 1047, 47, TRUE),
|
|
(48, 'VHF46', 1048, 48, TRUE),
|
|
(49, 'VHF47', 1049, 49, TRUE),
|
|
(50, 'VHF48', 1050, 50, TRUE),
|
|
(51, 'VHF49', 1051, 51, TRUE),
|
|
(52, 'VHF50', 1052, 52, TRUE),
|
|
(53, 'REL01', 1053, 53, TRUE),
|
|
(54, 'UHF01', 1054, 54, TRUE),
|
|
(55, 'UHF02', 1055, 55, TRUE),
|
|
(56, 'UHF03', 1056, 56, TRUE);
|
|
(57, 'R01' , 1057, 57, TRUE);
|
|
(58, 'R02' , 1058, 58, TRUE);
|
|
|
|
ALTER SEQUENCE avm.avm_cnr_channel_id_seq RESTART WITH 57;
|
|
|
|
INSERT INTO avm.avm_video_team (id, name, ssrc, port, program_id, time_offset)
|
|
VALUES ( 1, 'MVS01', 9872, 20001, 1, 6300),
|
|
( 2, 'MVS02', 9872, 20002, 1, 6300),
|
|
( 3, 'MVS03', 9872, 20003, 1, 6300),
|
|
( 4, 'MVS04', 9872, 20004, 1, 6300),
|
|
( 5, 'MVS05', 9872, 20005, 1, 6300),
|
|
( 6, 'MVS06', 9872, 20006, 1, 6300),
|
|
( 7, 'MVS07', 9872, 20007, 1, 6300),
|
|
( 8, 'MVS08', 9872, 20008, 1, 6300),
|
|
( 9, 'MVS09', 9872, 20009, 1, 6300),
|
|
(10, 'MVS10', 9872, 20010, 1, 6300);
|
|
|
|
ALTER SEQUENCE avm.avm_video_team_id_seq RESTART WITH 11;
|