summaryrefslogtreecommitdiffstats
path: root/abs/core/mythdb-initial/custom.sql
diff options
context:
space:
mode:
authorJames Meyer <james.meyer@operamail.com>2012-11-06 19:24:48 (GMT)
committerJames Meyer <james.meyer@operamail.com>2012-11-06 19:24:48 (GMT)
commit485ea73d269e2f5b7deacdac4d845ee871c22ac5 (patch)
tree7d3e1e4757188d2f9c9eddbb5240a919a7e8b882 /abs/core/mythdb-initial/custom.sql
parentfb65a64342c34c65045889121c310494d26e34ec (diff)
downloadlinhes_pkgbuild-485ea73d269e2f5b7deacdac4d845ee871c22ac5.zip
linhes_pkgbuild-485ea73d269e2f5b7deacdac4d845ee871c22ac5.tar.gz
linhes_pkgbuild-485ea73d269e2f5b7deacdac4d845ee871c22ac5.tar.bz2
mythdb-initial: added defaults for filesystem types for install
- remove some duplicate entries resulting from an insert before delete.
Diffstat (limited to 'abs/core/mythdb-initial/custom.sql')
-rw-r--r--abs/core/mythdb-initial/custom.sql50
1 files changed, 47 insertions, 3 deletions
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');
+