diff options
Diffstat (limited to 'abs/core/mythdb-initial/custom.sql')
| -rw-r--r-- | abs/core/mythdb-initial/custom.sql | 186 |
1 files changed, 163 insertions, 23 deletions
diff --git a/abs/core/mythdb-initial/custom.sql b/abs/core/mythdb-initial/custom.sql index 71dba44..72a94f4 100644 --- a/abs/core/mythdb-initial/custom.sql +++ b/abs/core/mythdb-initial/custom.sql @@ -1,28 +1,168 @@ -- DELETE FROM `settings` where `value`='HostMyhostname'; -- -INSERT INTO `settings` (`value`,`data`,`hostname`) VALUES ('HostMyhostname','type_hostname_here','larch5'); +INSERT INTO `settings` (`value`,`data`,`hostname`) VALUES ('HostMyhostname','type_hostname_here','apheleia'); -- - - INSERT INTO `settings` (`value`, `data`, `hostname`) VALUES - ('Hostpluginmytharchive','1','larch5'), - ('Hostpluginmythbrowser','1','larch5'), - ('Hostpluginmythcontrols','1','larch5'), - ('Hostpluginmythflix','1','larch5'), - ('Hostpluginmythgallery','1','larch5'), - ('Hostpluginmythgame','1','larch5'), - ('HostpluginmythgameFceu','1','larch5'), - ('HostpluginmythgameMame','1','larch5'), - ('HostpluginmythgameZsnes','1','larch5'), - ('Hostpluginmythmovietime','1','larch5'), - ('Hostpluginmythmusic','1','larch5'), - ('Hostpluginmythnews','1','larch5'), - ('Hostpluginmythphone','1','larch5'), - ('Hostpluginmythsmolt','1','larch5'), - ('Hostpluginmythvideo','1','larch5'), - ('Hostpluginmythvideo_dvdcss','0','larch5'), - ('Hostpluginmythweather','1','larch5'), - ('HostAudiotype','ALSA','larch5'); - - INSERT INTO `settings` (`value`, `data`, `hostname`) VALUES + +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'), + ('HostBEWait','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'); +*/ + + +-- /myth based storage groups are obsolete, add_storage.py will create the ones it needs. +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/'), +-- ('Streaming' ,'apheleia' ,'/myth/streaming'), + ('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'), + ('JobAllowUserJob2','1','apheleia'), + ('JobAllowUserJob3','1','apheleia'), + ('JobAllowUserJob4','1','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' ; + +-- Force windowmanager to enlightnemnet, install supplemental and use enhanced +INSERT INTO `settings` (`value`, `data`, `hostname`) VALUES +('HostWindowManager' , 'enlightenment' ,'apheleia'), +('HOSTSupplemental' , '1' ,'apheleia'), +('HostEnhancedWMStyle', '1' ,'apheleia'); + + +-- Defaults for OS install +INSERT INTO `settings` (`value`, `data`, `hostname`) VALUES +('HOSTuprootfstype','ext3' , 'apheleia'), +('HOSTOSsize', '5' , 'apheleia'), +('HOSTrootfstype', 'ext3' , 'apheleia'), +('HOSTHOMEsize', '3' , 'apheleia'), +('HOSTDatabasesize','5' , 'apheleia'), +('HostUseSWAP', '1' , 'apheleia'), +('HostUseALLdata', '1' , 'apheleia'), +('HOSTdatafstype', 'xfs' , 'apheleia'); + +-- Add a dummy tuner so BE will at least start +INSERT INTO `capturecard` (`videodevice`,`cardtype`,`defaultinput`,`hostname`) VALUES +('file://tmp/demo.mpg' , 'DEMO', 'Television', 'apheleia'); + +INSERT INTO `videosource` (`name`, `xmltvgrabber`) VALUES +('DEMO_VIDEO_SOURCE' , '/bin/true'); + +INSERT INTO `cardinput` (`cardid`,`sourceid`,`inputname`) VALUES +('1','1','MPEG2TS'); + + + |