mythdb-initial: added defaults for filesystem types for install

- remove some duplicate entries resulting from an insert before delete.

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