summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rwxr-xr-xabs/core/mythdb-initial/PKGBUILD4
-rw-r--r--abs/core/mythdb-initial/custom.sql50
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');
+