summaryrefslogtreecommitdiffstats
path: root/abs/core/mythdb-initial/custom.sql
blob: 0f21e3a492b8cec1b66b183abe8cb7b463985f37 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
--
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');

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');

INSERT INTO `settings` (`value`, `data`, `hostname`) VALUES
('OverrideExitMenu','3','apheleia'),
('NetworkControlEnabled','1','apheleia'),
('SecurityPin','0000','apheleia'),
('BackendStopCommand','sudo sv stop mythbackend' ,'apheleia'),
('BackendStartCommand','sudo sv start mythbackend' ,'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' ;