diff options
| -rwxr-xr-x | abs/core/mythdb-initial/PKGBUILD | 4 | ||||
| -rw-r--r-- | abs/core/mythdb-initial/custom.sql | 50 |
2 files changed, 49 insertions, 5 deletions
diff --git a/abs/core/mythdb-initial/PKGBUILD b/abs/core/mythdb-initial/PKGBUILD index 3798efd..40eb814 100755 --- a/abs/core/mythdb-initial/PKGBUILD +++ b/abs/core/mythdb-initial/PKGBUILD @@ -1,6 +1,6 @@ pkgname=mythdb-initial pkgver=2 -pkgrel=37 +pkgrel=43 pkgdesc="setup the initial mythtv database for linhes" url="" license="" @@ -21,4 +21,4 @@ build() { } md5sums=('9dcf8c574e69fde6b1b2fa1eed95ded4' 'ad0e57ac5e7c3677808a670e16634bba' - 'bcd52dfa9465f06cb3ec093e29eeea60') + 'f27605c438276e818b3bf3efe78359b4') diff --git a/abs/core/mythdb-initial/custom.sql b/abs/core/mythdb-initial/custom.sql index 0f21e3a..a172b01 100644 --- a/abs/core/mythdb-initial/custom.sql +++ b/abs/core/mythdb-initial/custom.sql @@ -25,6 +25,14 @@ INSERT INTO `settings` (`value`, `data`, `hostname`) VALUES ('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); @@ -37,7 +45,7 @@ INSERT INTO `settings` (`value`, `data`, `hostname`) VALUES ('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'), @@ -88,12 +96,37 @@ INSERT INTO `storagegroup` (`groupname`, `hostname`, `dirname`) VALUES ('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' ,'apheleia'), -('BackendStartCommand','sudo sv start mythbackend' ,'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'); @@ -101,6 +134,17 @@ INSERT INTO `settings` (`value`, `data`, `hostname`) VALUES 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'); + |