BEGIN TRANSACTION;


-- *******************************************************************************
-- *******************************************************************************
--                    CUSTOMER CONFIGURABLE DEFAULT DATA
-- *******************************************************************************
-- *******************************************************************************


-- ===============================================================================
--      Multizone Playback Configuration
-- ===============================================================================
-- This example configures one output device in one zone, for one control context
INSERT INTO outputdevices(type, permanent, name, devicepath) VALUES(1, 1, 'defaultoutput', 'snd:/dev/snd/pcmPreferredp');
INSERT INTO zones(zoneid, name) SELECT 1, 'defaultzone';
INSERT INTO zoneoutputs(zoneid, outputdeviceid) SELECT 1, outputdeviceid FROM outputdevices WHERE name='defaultoutput';
INSERT INTO renderers(path) VALUES('/dev/io-media');
INSERT INTO controlcontexts(zoneid, rendid, name) VALUES( 1, 1, 'default' );

-- Example shows two output devices, one attached to zone 1
--INSERT INTO outputdevices(type, permanent, name, devicepath) VALUES(1, 1, 'output1', 'snd:/dev/snd/pcmC0D0p');
--INSERT INTO outputdevices(type, permanent, name, devicepath) VALUES(1, 1, 'output2', 'snd:/dev/snd/pcmC0D1p');
--INSERT INTO zones(zoneid, name) SELECT 1, 'defaultzone';
--INSERT INTO zoneoutputs(zoneid, outputdeviceid) SELECT 1, outputdeviceid FROM outputdevices WHERE name='output1';
--INSERT INTO zoneoutputs(zoneid, outputdeviceid) SELECT 1, outputdeviceid FROM outputdevices WHERE name='output2';
--INSERT INTO renderers(path) VALUES('/dev/io-media');
--INSERT INTO controlcontexts(zoneid, rendid, name) VALUES( 1, 1, 'default' );

-- Multizone configuration example.  Two CC's, two Zones, one output device each
-- One io-media for both:
--INSERT INTO renderers(path) VALUES('/dev/io-media');

-- zone1:
--INSERT INTO outputdevices(type, permanent, name, devicepath) VALUES(1, 1, 'output1', 'snd:/dev/snd/pcmC0D1p');
--INSERT INTO zones(zoneid, name) SELECT 1, 'zone1';
--INSERT INTO zoneoutputs(zoneid, outputdeviceid) SELECT 1, outputdeviceid FROM outputdevices WHERE name='output1';
--INSERT INTO controlcontexts(zoneid, rendid, name) VALUES( 1, 1, 'cc1' );

-- zone2:
--INSERT INTO outputdevices(type, permanent, name, devicepath) VALUES(1, 1, 'output2', 'snd:/dev/snd/pcmC1D1p');
--INSERT INTO zones(zoneid, name) SELECT 2, 'zone2';
--INSERT INTO zoneoutputs(zoneid, outputdeviceid) SELECT 2, outputdeviceid FROM outputdevices WHERE name='output2';
--INSERT INTO controlcontexts(zoneid, rendid, name) VALUES( 2, 1, 'cc2' );


-- ===============================================================================
--      Device Monitoring
-- ===============================================================================
INSERT INTO slots(path,zoneid, name, slottype) VALUES('/media/drive', 1, 'HardDrive', 3);
INSERT INTO slots(path,zoneid, name, slottype) VALUES('/fs/usb0', 1, 'USB', 1);
INSERT INTO slots(path,zoneid, name, slottype) VALUES('/fs/usb1', 1, 'USB', 1);
INSERT INTO slots(path,zoneid, name, slottype) VALUES('/fs/cd0', 1, 'CD/DVD', 2);
INSERT INTO slots(path,zoneid, name, slottype) VALUES('/fs/cd1', 1, 'CD/DVD', 2);
-- The following two entries are duplicates of the previous two entries. This
-- is done so that the MME will always work, regardless of MCD configuration.
-- It it possible to have MCD always mount/unmount /fs/cd*, but in other
-- configurations /fs/cd* will always be present even when no media is
-- inserted.
INSERT INTO slots(path,zoneid, name, slottype) VALUES('/dev/cd0', 1, 'CD/DVD', 2);
INSERT INTO slots(path,zoneid, name, slottype) VALUES('/dev/cd1', 1, 'CD/DVD', 2);
INSERT INTO slots(path,zoneid, name, slottype) VALUES('/fs/ipod0', 1, 'iPod', 4);
INSERT INTO slots(path,zoneid, name, slottype) VALUES('/fs/pfs0', 1, 'PlaysForSure', 4);
INSERT INTO slots(path,zoneid, name, slottype) VALUES('/fs/upnp0', 1, 'UPnP', 4);
INSERT INTO slots(path,zoneid, name, slottype) VALUES('/fs/avrcp0', 1, 'Bluetooth', 4);
INSERT INTO slots(path,zoneid, name, slottype) VALUES('/fs/sd0', 1, 'SD/MMC', 8);
--INSERT INTO slots(path,zoneid, name, slottype) VALUES('/dev/socket', 1, 'INTERNET', 10);


-- ===============================================================================
--      LANGUAGE CONFIGURATION
-- ===============================================================================
-- English
INSERT INTO languages(
      language,
      lang_code,
      unknown,
      unknown_artist,
      unknown_album,
      unknown_genre,
      unknown_category,
      synchronizing,
      unknown_language,
      unknown_track,
      unknown_chapter,
      unknown_title,
      unknown_group
      )
values(
      "English",
      "en",
      "Unknown",
      "Unknown Artist",
      "Unknown Album",
      "Unknown Genre",
      "Unknown Category",
      "Synchronizing",
      "Unknown Language",
      "Track",
      "Chapter",
      "Title",
      "Group"
      );


-- French
INSERT INTO languages(
      language,
      lang_code,
      unknown,
      unknown_artist,
      unknown_album,
      unknown_genre,
      unknown_category,
      synchronizing,
      unknown_language,
      unknown_track,
      unknown_chapter,
      unknown_title,
      unknown_group
      )
values(
      "Français",
      "fr",
      "Inconnu",
      "Artiste inconnu",
      "Album inconnu",
      "Genre inconnu",
      "Categorie inconnue",
      "Synchronisation",
      "Langue inconnue",
      "Piste",
      "Chapitre",
      "Titre",
      "Groupe"
      );

-- German
INSERT INTO languages(
      language,
      lang_code,
      unknown,
      unknown_artist,
      unknown_album,
      unknown_genre,
      unknown_category,
      synchronizing,
      unknown_language,
      unknown_track,
      unknown_chapter,
      unknown_title,
      unknown_group
      )
values(
      "Deutsch",
      "de",
      "Unbekannt",
      "Unbekannter Kunstler",
      "Unbekanntes Album",
      "Unbekanntes Genre",
      "Unbekannte Kategorie",
      "Synchronisieren",
      "Unbekannte Sprache",
      "Track",
      "Kapitel",
      "Titel",
      "Gruppe"
      );

-- Select the default language
UPDATE languages SET active=1 WHERE language_id=1;



-- ===============================================================================
--      Media copier encode format configuration
-- ===============================================================================
-- Most platforms should support these:
INSERT INTO encodeformats(name, mime) VALUES('copy', 'copy');
INSERT INTO encodeformats(name, mime, bitrate, extension) VALUES('wave', 'wav', 0, '.wav');

-- Not all platforms support these:
--INSERT INTO encodeformats(name, mime, bitrate, extension) VALUES('Renesas AAC (SH4 only)', 'aac', 0, '.aac');
--INSERT INTO encodeformats(name, mime, bitrate, extension) VALUES('Margi DSP WMA 128000', 'wma', 128000, '.wma');
--INSERT INTO encodeformats(name, mime, bitrate, extension) VALUES('Margi DSP WMA 192000', 'wma', 192000, '.wma');
--INSERT INTO encodeformats(name, mime, bitrate, extension) VALUES('ogg', 'ogg', 0, '.ogg');



-- *******************************************************************************
-- *******************************************************************************
--                          REQUIRED DEFAULT DATA
--                    ** Do not customize this section **
-- *******************************************************************************
-- *******************************************************************************
-- Unknown is always 1
INSERT INTO library_genres(genre_id, genre)
   VALUES(1, (SELECT unknown_genre FROM languages WHERE active=1));
INSERT INTO library_artists(artist_id, artist)
   VALUES(1, (SELECT unknown_artist FROM languages WHERE active=1));
INSERT INTO library_albums(album_id, album)
   VALUES(1, (SELECT unknown_album FROM languages WHERE active=1));
INSERT INTO library_categories(category_id, category)
   VALUES(1, (SELECT unknown_category FROM languages WHERE active=1));
INSERT INTO library_languages(language_id, language)
   VALUES(1, (SELECT unknown_language FROM languages WHERE active=1));
--INSERT INTO library_moods(mood_id, mood)
--   VALUES(1, (SELECT unknown FROM languages WHERE active=1));
--INSERT INTO library_composers(composer_id, composer)
--   VALUES(1, (SELECT unknown FROM languages WHERE active=1));


COMMIT;