-- DELETE FROM `settings` where `value`='HostMyhostname'; -- INSERT INTO `settings` (`value`,`data`,`hostname`) VALUES ('HostMyhostname','type_hostname_here','apheleia'); -- INSERT INTO `settings` (`value`, `data`, `hostname`) VALUES ('Hostpluginmytharchive','1','apheleia'), ('Hostpluginmythbrowser','1','apheleia'), ('Hostpluginmythcontrols','1','apheleia'), ('Hostpluginmythflix','1','apheleia'), ('Hostpluginmythgallery','1','apheleia'), ('Hostpluginmythgame','1','apheleia'), ('HostpluginmythgameFceu','1','apheleia'), ('HostpluginmythgameMame','1','apheleia'), ('HostpluginmythgameZsnes','1','apheleia'), ('Hostpluginmythmovietime','1','apheleia'), ('Hostpluginmythmusic','1','apheleia'), ('Hostpluginmythnews','1','apheleia'), ('Hostpluginmythphone','1','apheleia'), ('Hostpluginmythsmolt','1','apheleia'), ('Hostpluginmythvideo','1','apheleia'), ('Hostpluginmythvideo_dvdcss','0','apheleia'), ('Hostpluginmythweather','1','apheleia'), ('Hostpluginmythappletrailers','1','apheleia'), ('HostAudiotype','ALSA','apheleia'); -- Clear out old values because mysql is mysql DELETE from settings where value in ('WOLbackendReconnectWaitTime','AutoStartFrontend', 'AllowQuitShutdown','BackendServerIP' 'BackendServerIP6','HaltCommand' 'RebootCommand','Theme' 'LircSocket'); INSERT INTO `settings` (`value`, `data`, `hostname`) VALUES ('WOLbackendReconnectWaitTime','5',NULL); INSERT INTO `settings` (`value`, `data`, `hostname`) VALUES ('AutoStartFrontend' ,'1' , 'apheleia'), ('AllowQuitShutdown' ,'4' , 'apheleia'), ('BackendServerIP' ,'127.0.0.1' , 'apheleia'), ('BackendServerIP6' ,'::1' , 'apheleia'), ('HaltCommand' ,'sudo /sbin/halt' , 'apheleia'), ('RebootCommand' ,'sudo /sbin/reboot' , 'apheleia'), ('Theme' ,'LinHES' , 'apheleia'), ('LircSocket' ,'/var/run/lirc/lircd' , 'apheleia'); -- INSERT INTO `settings` (`value`, `data`, `hostname`) VALUES ('NonID3FileNameFormat' ,'GENRE/ARTIST/ALBUM/TRACK_TITLE' , 'apheleia'), ('CDDevice' ,'/dev/cdrom' , 'apheleia'), ('MusicAudioDevice' ,'default' , 'apheleia'), ('MythArchiveCopyRemoteFiles' ,'1' , 'apheleia'), ('GalleryDir' ,'/myth/gallery' , 'apheleia'), ('MusicLocation' ,'/myth/music/' , 'apheleia'), ('mythgame.screenshotdir' ,'/myth/games/screenshots' , 'apheleia'), ('mythgame.fanartdir' ,'/myth/games/fanart' , 'apheleia'), ('mythgame.boxartdir' ,'/myth/games/boxart' , 'apheleia'), ('MythArchiveTempDir' ,'/myth/tmp' , 'apheleia'); -- MythVideo old local dir..replaced by storage groups, but should set values to null INSERT INTO `settings` (`value`, `data`, `hostname`) VALUES ('ScreenShotPath' ,'' , 'apheleia'), ('VideoStartupDir' ,'' , 'apheleia'), ('mythvideo.TrailersDir' ,'' , 'apheleia'), ('VideoArtworkDir' ,'' , 'apheleia'), ('mythvideo.screenshotDir' ,'' , 'apheleia'), ('mythvideo.bannerDir' ,'' , 'apheleia'), ('mythvideo.fanartDir' ,'' , 'apheleia'); -- MythVideo old local dir..replaced by storage groups /* INSERT INTO `settings` (`value`, `data`, `hostname`) VALUES ('ScreenShotPath' ,'/myth/video_stuff/screenshots' , 'apheleia'), ('VideoStartupDir' ,'/myth/video' , 'apheleia'), ('mythvideo.TrailersDir' ,'/myth/video_stuff/trailers' , 'apheleia'), ('VideoArtworkDir' ,'/myth/video_stuff/coverart' , 'apheleia'), ('mythvideo.screenshotDir' ,'/myth/video_stuff/screenshots' , 'apheleia'), ('mythvideo.bannerDir' ,'/myth/video_stuff/banners' , 'apheleia'), ('mythvideo.fanartDir' ,'/myth/video_stuff/fanart' , 'apheleia'); */ INSERT INTO `storagegroup` (`groupname`, `hostname`, `dirname`) VALUES ('Default' ,'apheleia' ,'/myth/tv/'), ('LiveTV' ,'apheleia' ,'/myth/tv/live/'), ('Screenshots' ,'apheleia' ,'/myth/video_stuff/screenshots/'), ('Videos' ,'apheleia' ,'/myth/video/'), ('Coverart' ,'apheleia' ,'/myth/video_stuff/coverart/'), ('Banners' ,'apheleia' ,'/myth/video_stuff/banners/'), ('Fanart' ,'apheleia' ,'/myth/video_stuff/fanart/'), ('Trailers' ,'apheleia' ,'/myth/video_stuff/trailers/'), ('DB Backups' ,'apheleia' ,'/data/storage/disk0/backup/mythtv_backups'); -- Clear out old values because mysql is mysql DELETE from settings where value in ('OverrideExitMenu','NetworkControlEnabled''SecurityPin', 'BackendStopCommand', 'BackendStartCommand'); INSERT INTO `settings` (`value`, `data`, `hostname`) VALUES ('OverrideExitMenu','3','apheleia'), ('NetworkControlEnabled','1','apheleia'), ('SecurityPin','0000','apheleia'), ('BackendStopCommand','sudo sv stop mythbackend' ,NULL), ('BackendStartCommand','sudo sv start mythbackend' ,NULL); -- -- Clear out old user jobs DELETE FROM `settings` where value in ('JobAllowUserJob1', 'JobAllowUserJob2', 'JobAllowUserJob3', 'JobAllowUserJob4'); INSERT INTO `settings` (`value`, `data`, `hostname`) VALUES ('JobAllowUserJob1','1','apheleia'), ('JobAllowUserJob1','2','apheleia'), ('JobAllowUserJob1','3','apheleia'), ('JobAllowUserJob1','4','apheleia'); -- INSERT INTO `settings` (`value`, `data`, `hostname`) VALUES ('MiscStatusScript','/usr/LH/bin/misc_status_info.sh','apheleia'); UPDATE `keybindings` set `keylist` = "Alt+Esc" WHERE `action` = 'EXITPROMPT' ; -- Defaults for OS install INSERT INTO `settings` (`value`, `data`, `hostname`) VALUES ('HOSTuprootfstype','ext3' , 'apheleia'), ('HOSTOSsize', '5' , 'apheleia'), ('HOSTrootfstype', 'ext3' , 'apheleia'), ('HOSTHOMEsize', '3' , 'apheleia'), ('HOSTDatabasesize','3' , 'apheleia'), ('HostUseSWAP', '1' , 'apheleia'), ('HostUseALLdata', '1' , 'apheleia'), ('HOSTdatafstype', 'xfs' , 'apheleia');