93 lines
7.2 KiB
SQL
93 lines
7.2 KiB
SQL
BEGIN TRANSACTION;
|
|
|
|
|
|
-- *******************************************************************************
|
|
-- *******************************************************************************
|
|
-- CUSTOMER CONFIGURABLE DEFAULT DATA
|
|
-- *******************************************************************************
|
|
-- *******************************************************************************
|
|
|
|
|
|
-- ===============================================================================
|
|
-- Multizone Playback Configuration
|
|
-- ===============================================================================
|
|
-- NBT Specific Begin
|
|
INSERT INTO outputdevices(type, permanent, name, devicepath) VALUES(1, 1, 'output1', '/dev/io-amp/input_stereo_0');
|
|
INSERT INTO outputdevices(type, permanent, name, devicepath) VALUES(1, 1, 'output2', '/dev/io-amp/input_stereo_1');
|
|
INSERT INTO outputdevices(type, permanent, name, devicepath) VALUES(1, 1, 'output3', '/dev/io-amp/input_stereo_2');
|
|
INSERT INTO outputdevices(type, permanent, name, devicepath) VALUES(1, 1, 'output4', '/dev/io-amp/input_multich_0');
|
|
INSERT INTO outputdevices(type, permanent, name, devicepath) VALUES(1, 1, 'output5', 'display://video-output-id=0');
|
|
INSERT INTO outputdevices(type, permanent, name, devicepath) VALUES(1, 1, 'output6', 'display://video-output-id=1');
|
|
INSERT INTO outputdevices(type, permanent, name, devicepath) VALUES(1, 1, 'output7', 'tcp://@:6050');
|
|
INSERT INTO outputdevices(type, permanent, name, devicepath) VALUES(1, 1, 'output8', '/dev/io-amp/input_mono_1');
|
|
INSERT INTO outputdevices(type, permanent, name, devicepath) VALUES(1, 1, 'output9', '/dev/io-amp/input_stereo_5');
|
|
|
|
--Add different Zones
|
|
INSERT INTO zones(zoneid, name) SELECT 1, 'zone1';
|
|
INSERT INTO zones(zoneid, name) SELECT 2, 'zone2';
|
|
INSERT INTO zones(zoneid, name) SELECT 3, 'zone3';
|
|
INSERT INTO zones(zoneid, name) SELECT 4, 'multichannel';
|
|
INSERT INTO zones(zoneid, name) SELECT 5, 'zoneVN';
|
|
INSERT INTO zones(zoneid, name) SELECT 6, 'zone4';
|
|
|
|
-- zoneoutputs are now attached dynamically
|
|
-- below lines maintained here for reference
|
|
-- Static AudioOutput mapping
|
|
INSERT INTO zoneoutputs(zoneid, outputdeviceid) SELECT 1, outputdeviceid FROM outputdevices WHERE name='output1';
|
|
INSERT INTO zoneoutputs(zoneid, outputdeviceid) SELECT 2, outputdeviceid FROM outputdevices WHERE name='output2';
|
|
INSERT INTO zoneoutputs(zoneid, outputdeviceid) SELECT 3, outputdeviceid FROM outputdevices WHERE name='output3';
|
|
INSERT INTO zoneoutputs(zoneid, outputdeviceid) SELECT 4, outputdeviceid FROM outputdevices WHERE name='output4';
|
|
INSERT INTO zoneoutputs(zoneid, outputdeviceid) SELECT 5, outputdeviceid FROM outputdevices WHERE name='output8';
|
|
INSERT INTO zoneoutputs(zoneid, outputdeviceid) SELECT 6, outputdeviceid FROM outputdevices WHERE name='output9';
|
|
-- Static VideoOutput mapping
|
|
INSERT INTO zoneoutputs(zoneid, outputdeviceid) SELECT 6, outputdeviceid FROM outputdevices WHERE name='output5';
|
|
INSERT INTO zoneoutputs(zoneid, outputdeviceid) SELECT 4, outputdeviceid FROM outputdevices WHERE name='output6';
|
|
|
|
INSERT INTO renderers(path) VALUES('/dev/io-media');
|
|
INSERT INTO renderers(path) VALUES('/dev/ipod-io-media');
|
|
|
|
INSERT INTO controlcontexts(zoneid, rendid, name) VALUES( 1, 1, 'zone1' );
|
|
INSERT INTO controlcontexts(zoneid, rendid, name) VALUES( 2, 1, 'zone2' );
|
|
INSERT INTO controlcontexts(zoneid, rendid, name) VALUES( 3, 1, 'zone3' );
|
|
INSERT INTO controlcontexts(zoneid, rendid, name) VALUES( 4, 1, 'multichannel' );
|
|
INSERT INTO controlcontexts(zoneid, rendid, name) VALUES( 5, 1, 'zoneVN' );
|
|
INSERT INTO controlcontexts(zoneid, rendid, name) VALUES( 6, 1, 'zone4' );
|
|
|
|
-- ===============================================================================
|
|
-- Device Monitoring
|
|
-- ===============================================================================
|
|
--Temporarily commenting USB and HDD
|
|
INSERT INTO slots(path,zoneid, name, slottype, max_lib_entries) VALUES('/fs/usb0', 1, 'USB', 1, 16000);
|
|
INSERT INTO slots(path,zoneid, name, slottype, max_lib_entries) VALUES('/fs/usb1', 1, 'USB', 1, 16000);
|
|
INSERT INTO slots(path,zoneid, name, slottype, max_lib_entries) VALUES('/fs/usb2', 1, 'USB', 1, 16000);
|
|
INSERT INTO slots(path,zoneid, name, slottype, max_lib_entries) VALUES('/fs/usb3', 1, 'USB', 1, 16000);
|
|
INSERT INTO slots(path,zoneid, name, slottype, max_lib_entries) VALUES('/fs/usb4', 1, 'USB', 1, 16000);
|
|
INSERT INTO slots(path,zoneid, name, slottype, max_lib_entries) VALUES('/fs/usb5', 1, 'USB', 1, 16000);
|
|
INSERT INTO slots(path,zoneid, name, slottype, max_lib_entries) VALUES('/fs/usb6', 1, 'USB', 1, 16000);
|
|
INSERT INTO slots(path,zoneid, name, slottype, max_lib_entries) VALUES('/fs/usb7', 1, 'USB', 1, 16000);
|
|
INSERT INTO slots(path,zoneid, name, slottype, max_lib_entries) VALUES('/fs/usb8', 1, 'USB', 1, 16000);
|
|
INSERT INTO slots(path,zoneid, name, slottype, max_lib_entries) VALUES('/fs/usb9', 1, 'USB', 1, 16000);
|
|
INSERT INTO slots(path,zoneid, name, slottype, max_lib_entries) VALUES('/fs/usb10', 1, 'USB', 1, 16000);
|
|
INSERT INTO slots(path,zoneid, name, slottype, max_lib_entries) VALUES('/fs/usb11', 1, 'USB', 1, 16000);
|
|
INSERT INTO slots(path,zoneid, name, slottype, max_lib_entries) VALUES('/fs/usb12', 1, 'USB', 1, 16000);
|
|
INSERT INTO slots(path,zoneid, name, slottype, max_lib_entries) VALUES('/fs/usb13', 1, 'USB', 1, 16000);
|
|
INSERT INTO slots(path,zoneid, name, slottype, max_lib_entries) VALUES('/fs/usb14', 1, 'USB', 1, 16000);
|
|
INSERT INTO slots(path,zoneid, name, slottype, max_lib_entries) VALUES('/fs/cd0', 1, 'CD/DVD', 2, 3000);
|
|
INSERT INTO slots(path,zoneid, name, slottype, max_lib_entries) VALUES('/mnt/quota/mm/EntServer', 1, 'HardDisk', 3, 40000);
|
|
INSERT INTO slots(path,zoneid, name, slottype, max_lib_entries) VALUES('/fs/upnp0', 1 , 'UPNP', 4, 16000);
|
|
INSERT INTO slots(path,zoneid, name, slottype, max_lib_entries) VALUES('/fs/ipod0', 1 , 'ipod', 4, 16000);
|
|
INSERT INTO slots(path,zoneid, name, slottype, max_lib_entries) VALUES('/fs/ipod1', 1 , 'ipod', 4, 16000);
|
|
INSERT INTO slots(path,zoneid, name, slottype, max_lib_entries) VALUES('/fs/ipod2', 1 , 'ipod', 4, 16000);
|
|
INSERT INTO slots(path,zoneid, name, slottype, max_lib_entries) VALUES('/fs/seripod',1 , 'ipod', 4, 16000);
|
|
INSERT INTO slots(path,zoneid, name, slottype, max_lib_entries) VALUES('/fs/btipod', 1 , 'ipod', 4, 16000);
|
|
INSERT INTO slots(path,zoneid, name, slottype, max_lib_entries) VALUES('/dev/tuner/dmb', 1 , 'DMB-Radio', 12, 16000);
|
|
INSERT INTO slots(path,zoneid, name, slottype, max_lib_entries) VALUES('/dev/socket',1, 'SocketDMBSlave', 10, 16000);
|
|
INSERT INTO slots(path,zoneid, name, slottype, max_lib_entries) VALUES('/fs/avrcp00',1, 'Bluetooth', 4, 16000);
|
|
INSERT INTO slots(path,zoneid, name, slottype, max_lib_entries) VALUES('/fs/pfs0', 1, 'PlayForSure', 4, 16000);
|
|
INSERT INTO slots(path,zoneid, name, slottype, max_lib_entries) VALUES('/fs/pfs1', 1, 'PlayForSure', 4, 16000);
|
|
INSERT INTO slots(path,zoneid, name, slottype, max_lib_entries) VALUES('/fs/pfs2', 1, 'PlayForSure', 4, 16000);
|
|
INSERT INTO slots(path,zoneid, name, slottype, max_lib_entries) VALUES('/mnt/quota/mm/Voicenotes', 1, 'Voicenotes', 3, 203);
|
|
INSERT INTO slots(path,zoneid, name, slottype, max_lib_entries) VALUES('/mnt/quota/mm/OnlineEntertainment/Content', 1, 'OnlineEntertainment', 3, 40000);
|
|
|
|
COMMIT;
|