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;