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