From 8588c008c5c9533b1574ae812ae325799d95f664 Mon Sep 17 00:00:00 2001 From: Britney Fransen Date: Sun, 17 Sep 2017 23:46:47 +0000 Subject: mythdb-initial: update for mythtv 29 --- abs/core/mythdb-initial/PKGBUILD | 6 +++--- abs/core/mythdb-initial/mc.sql | 24 ++++++++++++----------- abs/core/mythdb-initial/mythdb.install | 36 ++++++++++++++++------------------ 3 files changed, 33 insertions(+), 33 deletions(-) diff --git a/abs/core/mythdb-initial/PKGBUILD b/abs/core/mythdb-initial/PKGBUILD index e7052f4..6b0c402 100755 --- a/abs/core/mythdb-initial/PKGBUILD +++ b/abs/core/mythdb-initial/PKGBUILD @@ -1,6 +1,6 @@ pkgname=mythdb-initial -pkgver=8.4 -pkgrel=5 +pkgver=8.5 +pkgrel=1 pkgdesc="setup the initial mythtv database for linhes" url="" license=() @@ -20,6 +20,6 @@ package() { cp $srcdir/custom.sql $pkgdir/data/database/custom.sql } -md5sums=('5f3492d396142d394c095749363fd03d' +md5sums=('0d89ab0038df8985249fe1e25f1b0dd7' 'ad0e57ac5e7c3677808a670e16634bba' '1701d4b347aebe6cee63408c90cd7a74') diff --git a/abs/core/mythdb-initial/mc.sql b/abs/core/mythdb-initial/mc.sql index 8d683f0..50d1f1b 100644 --- a/abs/core/mythdb-initial/mc.sql +++ b/abs/core/mythdb-initial/mc.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 5.6.28, for Linux (x86_64) +-- MySQL dump 10.13 Distrib 5.6.35, for Linux (x86_64) -- --- Host: localhost Database: mythconverg +-- Host: localhost Database: mythconverg (mythtv 29) -- ------------------------------------------------------ --- Server version 5.6.28 +-- Server version 5.6.35 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -88,6 +88,8 @@ CREATE TABLE `capturecard` ( `quicktune` tinyint(4) NOT NULL DEFAULT '0', `schedorder` int(10) unsigned NOT NULL DEFAULT '1', `livetvorder` int(10) unsigned NOT NULL DEFAULT '1', + `reclimit` int(10) unsigned NOT NULL DEFAULT '1', + `schedgroup` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`cardid`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -870,7 +872,7 @@ CREATE TABLE `housekeeping` ( LOCK TABLES `housekeeping` WRITE; /*!40000 ALTER TABLE `housekeeping` DISABLE KEYS */; -INSERT INTO `housekeeping` VALUES ('BackupDB',NULL,'2016-04-21 18:49:32','2016-04-21 18:49:32'); +INSERT INTO `housekeeping` VALUES ('BackupDB',NULL,'2017-09-17 23:08:05',NULL); /*!40000 ALTER TABLE `housekeeping` ENABLE KEYS */; UNLOCK TABLES; @@ -1116,7 +1118,7 @@ CREATE TABLE `keybindings` ( LOCK TABLES `keybindings` WRITE; /*!40000 ALTER TABLE `keybindings` DISABLE KEYS */; -INSERT INTO `keybindings` VALUES ('Global','UP','Up Arrow','Up','apheleia'),('Global','DOWN','Down Arrow','Down','apheleia'),('Global','LEFT','Left Arrow','Left','apheleia'),('Global','RIGHT','Right Arrow','Right','apheleia'),('Global','NEXT','Move to next widget','Tab','apheleia'),('Global','PREVIOUS','Move to preview widget','Backtab','apheleia'),('Global','SELECT','Select','Return,Enter,Space','apheleia'),('Global','BACKSPACE','Backspace','Backspace','apheleia'),('Global','ESCAPE','Escape','Esc','apheleia'),('Global','MENU','Pop-up menu','M','apheleia'),('Global','INFO','More information','I','apheleia'),('Global','DELETE','Delete','D','apheleia'),('Global','EDIT','Edit','E','apheleia'),('Global','SCREENSHOT','Save screenshot','','apheleia'),('Global','HANDLEMEDIA','Play a media resource','','apheleia'),('Global','PAGEUP','Page Up','PgUp','apheleia'),('Global','PAGEDOWN','Page Down','PgDown','apheleia'),('Global','PAGETOP','Page to top of list','','apheleia'),('Global','PAGEMIDDLE','Page to middle of list','','apheleia'),('Global','PAGEBOTTOM','Page to bottom of list','','apheleia'),('Global','PREVVIEW','Previous View','Home','apheleia'),('Global','NEXTVIEW','Next View','End','apheleia'),('Global','HELP','Help','F1','apheleia'),('Global','EJECT','Eject Removable Media','','apheleia'),('Global','CUT','Cut text from textedit','Ctrl+X','apheleia'),('Global','COPY','Copy text from textedit','Ctrl+C','apheleia'),('Global','PASTE','Paste text into textedit','Ctrl+V','apheleia'),('Global','NEWLINE','Insert newline into textedit','Ctrl+Return','apheleia'),('Global','UNDO','Undo','Ctrl+Z','apheleia'),('Global','REDO','Redo','Ctrl+Y','apheleia'),('Global','SEARCH','Show incremental search dialog','Ctrl+S','apheleia'),('Global','0','0','0','apheleia'),('Global','1','1','1','apheleia'),('Global','2','2','2','apheleia'),('Global','3','3','3','apheleia'),('Global','4','4','4','apheleia'),('Global','5','5','5','apheleia'),('Global','6','6','6','apheleia'),('Global','7','7','7','apheleia'),('Global','8','8','8','apheleia'),('Global','9','9','9','apheleia'),('Global','TVPOWERON','Turn the display on','','apheleia'),('Global','TVPOWEROFF','Turn the display off','','apheleia'),('Global','SYSEVENT01','Trigger System Key Event #1','','apheleia'),('Global','SYSEVENT02','Trigger System Key Event #2','','apheleia'),('Global','SYSEVENT03','Trigger System Key Event #3','','apheleia'),('Global','SYSEVENT04','Trigger System Key Event #4','','apheleia'),('Global','SYSEVENT05','Trigger System Key Event #5','','apheleia'),('Global','SYSEVENT06','Trigger System Key Event #6','','apheleia'),('Global','SYSEVENT07','Trigger System Key Event #7','','apheleia'),('Global','SYSEVENT08','Trigger System Key Event #8','','apheleia'),('Global','SYSEVENT09','Trigger System Key Event #9','','apheleia'),('Global','SYSEVENT10','Trigger System Key Event #10','','apheleia'),('Browser','ZOOMIN','Zoom in on browser window','.,>','apheleia'),('Browser','ZOOMOUT','Zoom out on browser window',',,<','apheleia'),('Browser','TOGGLEINPUT','Toggle where keyboard input goes to','F1','apheleia'),('Browser','MOUSEUP','Move mouse pointer up','2','apheleia'),('Browser','MOUSEDOWN','Move mouse pointer down','8','apheleia'),('Browser','MOUSELEFT','Move mouse pointer left','4','apheleia'),('Browser','MOUSERIGHT','Move mouse pointer right','6','apheleia'),('Browser','MOUSELEFTBUTTON','Mouse Left button click','5','apheleia'),('Browser','PAGEDOWN','Scroll down half a page','9','apheleia'),('Browser','PAGEUP','Scroll up half a page','3','apheleia'),('Browser','PAGELEFT','Scroll left half a page','7','apheleia'),('Browser','PAGERIGHT','Scroll right half a page','1','apheleia'),('Browser','NEXTLINK','Move selection to next link','Z','apheleia'),('Browser','PREVIOUSLINK','Move selection to previous link','Q','apheleia'),('Browser','FOLLOWLINK','Follow selected link','Return,Space,Enter','apheleia'),('Browser','HISTORYBACK','Go back to previous page','R,Backspace','apheleia'),('Browser','HISTORYFORWARD','Go forward to previous page','F','apheleia'),('Main Menu','EXITPROMPT','Display System Exit Prompt','Esc','apheleia'),('Main Menu','EXIT','System Exit','','apheleia'),('Main Menu','STANDBYMODE','Enter Standby Mode','','apheleia'); +INSERT INTO `keybindings` VALUES ('Global','UP','Up Arrow','Up','apheleia'),('Global','DOWN','Down Arrow','Down','apheleia'),('Global','LEFT','Left Arrow','Left','apheleia'),('Global','RIGHT','Right Arrow','Right','apheleia'),('Global','NEXT','Move to next widget','Tab','apheleia'),('Global','PREVIOUS','Move to preview widget','Backtab','apheleia'),('Global','SELECT','Select','Return,Enter,Space','apheleia'),('Global','BACKSPACE','Backspace','Backspace','apheleia'),('Global','ESCAPE','Escape','Esc','apheleia'),('Global','MENU','Pop-up menu','M','apheleia'),('Global','INFO','More information','I','apheleia'),('Global','DELETE','Delete','D','apheleia'),('Global','EDIT','Edit','E','apheleia'),('Global','SCREENSHOT','Save screenshot','','apheleia'),('Global','HANDLEMEDIA','Play a media resource','','apheleia'),('Global','PAGEUP','Page Up','PgUp','apheleia'),('Global','PAGEDOWN','Page Down','PgDown','apheleia'),('Global','PAGETOP','Page to top of list','','apheleia'),('Global','PAGEMIDDLE','Page to middle of list','','apheleia'),('Global','PAGEBOTTOM','Page to bottom of list','','apheleia'),('Global','PREVVIEW','Previous View','Home','apheleia'),('Global','NEXTVIEW','Next View','End','apheleia'),('Global','HELP','Help','F1','apheleia'),('Global','EJECT','Eject Removable Media','','apheleia'),('Global','CUT','Cut text from textedit','Ctrl+X','apheleia'),('Global','COPY','Copy text from textedit','Ctrl+C','apheleia'),('Global','PASTE','Paste text into textedit','Ctrl+V','apheleia'),('Global','NEWLINE','Insert newline into textedit','Ctrl+Return','apheleia'),('Global','UNDO','Undo','Ctrl+Z','apheleia'),('Global','REDO','Redo','Ctrl+Y','apheleia'),('Global','SEARCH','Show incremental search dialog','Ctrl+S','apheleia'),('Global','0','0','0','apheleia'),('Global','1','1','1','apheleia'),('Global','2','2','2','apheleia'),('Global','3','3','3','apheleia'),('Global','4','4','4','apheleia'),('Global','5','5','5','apheleia'),('Global','6','6','6','apheleia'),('Global','7','7','7','apheleia'),('Global','8','8','8','apheleia'),('Global','9','9','9','apheleia'),('Global','TVPOWERON','Turn the display on','','apheleia'),('Global','TVPOWEROFF','Turn the display off','','apheleia'),('Global','SYSEVENT01','Trigger System Key Event #1','','apheleia'),('Global','SYSEVENT02','Trigger System Key Event #2','','apheleia'),('Global','SYSEVENT03','Trigger System Key Event #3','','apheleia'),('Global','SYSEVENT04','Trigger System Key Event #4','','apheleia'),('Global','SYSEVENT05','Trigger System Key Event #5','','apheleia'),('Global','SYSEVENT06','Trigger System Key Event #6','','apheleia'),('Global','SYSEVENT07','Trigger System Key Event #7','','apheleia'),('Global','SYSEVENT08','Trigger System Key Event #8','','apheleia'),('Global','SYSEVENT09','Trigger System Key Event #9','','apheleia'),('Global','SYSEVENT10','Trigger System Key Event #10','','apheleia'),('Browser','ZOOMIN','Zoom in on browser window','.,>','apheleia'),('Browser','ZOOMOUT','Zoom out on browser window',',,<','apheleia'),('Browser','TOGGLEINPUT','Toggle where keyboard input goes to','F1','apheleia'),('Browser','MOUSEUP','Move mouse pointer up','2','apheleia'),('Browser','MOUSEDOWN','Move mouse pointer down','8','apheleia'),('Browser','MOUSELEFT','Move mouse pointer left','4','apheleia'),('Browser','MOUSERIGHT','Move mouse pointer right','6','apheleia'),('Browser','MOUSELEFTBUTTON','Mouse Left button click','5','apheleia'),('Browser','PAGEDOWN','Scroll down half a page','9','apheleia'),('Browser','PAGEUP','Scroll up half a page','3','apheleia'),('Browser','PAGELEFT','Scroll left half a page','7','apheleia'),('Browser','PAGERIGHT','Scroll right half a page','1','apheleia'),('Browser','NEXTLINK','Move selection to next link','Z','apheleia'),('Browser','PREVIOUSLINK','Move selection to previous link','Q','apheleia'),('Browser','FOLLOWLINK','Follow selected link','Return,Space,Enter','apheleia'),('Browser','HISTORYBACK','Go back to previous page','R,Backspace','apheleia'),('Browser','HISTORYFORWARD','Go forward to previous page','F','apheleia'),('Main Menu','EXITPROMPT','Display System Exit Prompt','Esc','apheleia'),('Main Menu','EXIT','System Exit','','apheleia'),('Main Menu','STANDBYMODE','Enter Standby Mode','','apheleia'),('Global','UP','Up Arrow','Up','zeal'),('Global','DOWN','Down Arrow','Down','zeal'),('Global','LEFT','Left Arrow','Left','zeal'),('Global','RIGHT','Right Arrow','Right','zeal'),('Global','NEXT','Move to next widget','Tab','zeal'),('Global','PREVIOUS','Move to preview widget','Backtab','zeal'),('Global','SELECT','Select','Return,Enter,Space','zeal'),('Global','BACKSPACE','Backspace','Backspace','zeal'),('Global','ESCAPE','Escape','Esc','zeal'),('Global','MENU','Pop-up menu','M','zeal'),('Global','INFO','More information','I','zeal'),('Global','DELETE','Delete','D','zeal'),('Global','EDIT','Edit','E','zeal'),('Global','SCREENSHOT','Save screenshot','','zeal'),('Global','HANDLEMEDIA','Play a media resource','','zeal'),('Global','PAGEUP','Page Up','PgUp','zeal'),('Global','PAGEDOWN','Page Down','PgDown','zeal'),('Global','PAGETOP','Page to top of list','','zeal'),('Global','PAGEMIDDLE','Page to middle of list','','zeal'),('Global','PAGEBOTTOM','Page to bottom of list','','zeal'),('Global','PREVVIEW','Previous View','Home','zeal'),('Global','NEXTVIEW','Next View','End','zeal'),('Global','HELP','Help','F1','zeal'),('Global','EJECT','Eject Removable Media','','zeal'),('Global','CUT','Cut text from textedit','Ctrl+X','zeal'),('Global','COPY','Copy text from textedit','Ctrl+C','zeal'),('Global','PASTE','Paste text into textedit','Ctrl+V','zeal'),('Global','NEWLINE','Insert newline into textedit','Ctrl+Return','zeal'),('Global','UNDO','Undo','Ctrl+Z','zeal'),('Global','REDO','Redo','Ctrl+Y','zeal'),('Global','SEARCH','Show incremental search dialog','Ctrl+S','zeal'),('Global','0','0','0','zeal'),('Global','1','1','1','zeal'),('Global','2','2','2','zeal'),('Global','3','3','3','zeal'),('Global','4','4','4','zeal'),('Global','5','5','5','zeal'),('Global','6','6','6','zeal'),('Global','7','7','7','zeal'),('Global','8','8','8','zeal'),('Global','9','9','9','zeal'),('Global','TVPOWERON','Turn the display on','','zeal'),('Global','TVPOWEROFF','Turn the display off','','zeal'),('Global','SYSEVENT01','Trigger System Key Event #1','','zeal'),('Global','SYSEVENT02','Trigger System Key Event #2','','zeal'),('Global','SYSEVENT03','Trigger System Key Event #3','','zeal'),('Global','SYSEVENT04','Trigger System Key Event #4','','zeal'),('Global','SYSEVENT05','Trigger System Key Event #5','','zeal'),('Global','SYSEVENT06','Trigger System Key Event #6','','zeal'),('Global','SYSEVENT07','Trigger System Key Event #7','','zeal'),('Global','SYSEVENT08','Trigger System Key Event #8','','zeal'),('Global','SYSEVENT09','Trigger System Key Event #9','','zeal'),('Global','SYSEVENT10','Trigger System Key Event #10','','zeal'),('Browser','ZOOMIN','Zoom in on browser window','.,>','zeal'),('Browser','ZOOMOUT','Zoom out on browser window',',,<','zeal'),('Browser','TOGGLEINPUT','Toggle where keyboard input goes to','F1','zeal'),('Browser','MOUSEUP','Move mouse pointer up','2','zeal'),('Browser','MOUSEDOWN','Move mouse pointer down','8','zeal'),('Browser','MOUSELEFT','Move mouse pointer left','4','zeal'),('Browser','MOUSERIGHT','Move mouse pointer right','6','zeal'),('Browser','MOUSELEFTBUTTON','Mouse Left button click','5','zeal'),('Browser','PAGEDOWN','Scroll down half a page','9','zeal'),('Browser','PAGEUP','Scroll up half a page','3','zeal'),('Browser','PAGELEFT','Scroll left half a page','7','zeal'),('Browser','PAGERIGHT','Scroll right half a page','1','zeal'),('Browser','NEXTLINK','Move selection to next link','Z','zeal'),('Browser','PREVIOUSLINK','Move selection to previous link','Q','zeal'),('Browser','FOLLOWLINK','Follow selected link','Return,Space,Enter','zeal'),('Browser','HISTORYBACK','Go back to previous page','R,Backspace','zeal'),('Browser','HISTORYFORWARD','Go forward to previous page','F','zeal'),('Main Menu','EXITPROMPT','Display System Exit Prompt','Esc','zeal'),('Main Menu','EXIT','System Exit','','zeal'),('Main Menu','STANDBYMODE','Enter Standby Mode','','zeal'); /*!40000 ALTER TABLE `keybindings` ENABLE KEYS */; UNLOCK TABLES; @@ -1665,10 +1667,10 @@ CREATE TABLE `record` ( `recordid` int(10) unsigned NOT NULL AUTO_INCREMENT, `type` int(10) unsigned NOT NULL DEFAULT '0', `chanid` int(10) unsigned DEFAULT NULL, - `starttime` time NOT NULL DEFAULT '00:00:00', - `startdate` date NOT NULL DEFAULT '0000-00-00', - `endtime` time NOT NULL DEFAULT '00:00:00', - `enddate` date NOT NULL DEFAULT '0000-00-00', + `starttime` time DEFAULT NULL, + `startdate` date DEFAULT NULL, + `endtime` time DEFAULT NULL, + `enddate` date DEFAULT NULL, `title` varchar(128) NOT NULL DEFAULT '', `subtitle` varchar(128) NOT NULL DEFAULT '', `description` varchar(16000) NOT NULL DEFAULT '', @@ -2203,7 +2205,7 @@ CREATE TABLE `settings` ( LOCK TABLES `settings` WRITE; /*!40000 ALTER TABLE `settings` DISABLE KEYS */; -INSERT INTO `settings` VALUES ('mythfilldatabaseLastRunStart','',NULL),('mythfilldatabaseLastRunEnd','',NULL),('mythfilldatabaseLastRunStatus','',NULL),('DataDirectMessage','',NULL),('HaveRepeats','0',NULL),('DBSchemaVer','1344',NULL),('WebBrowserZoomLevel','1','apheleia'),('Language','en_US',NULL),('Country','US',NULL),('FreqTable','us-bcast',NULL),('ISO639Language0','eng',NULL),('ISO639Language1','eng',NULL),('TVFormat','NTSC',NULL),('VbiFormat','NTSC Closed Caption',NULL),('DateFormat','ddd MMM d yyyy','apheleia'),('MythArchiveDateFormat','%a %b %d %Y','apheleia'),('MythArchiveTimeFormat','%I:%M %p','apheleia'),('MythArchiveVideoFormat','NTSC','apheleia'),('ShortDateFormat','M/d','apheleia'),('TimeFormat','h:mm AP','apheleia'),('BackupDBLastRunStart','2016-04-21 18:49:31',NULL),('BackupDBLastRunEnd','2016-04-21 18:49:32',NULL),('HardwareProfileEnabled','0',NULL),('BackendServerIP','127.0.0.1','apheleia'),('BackendServerIP6','::1','apheleia'),('AllowLinkLocal','1','apheleia'),('BackendServerPort','6543','apheleia'),('BackendStatusPort','6544','apheleia'),('MasterServerIP','127.0.0.1',NULL),('MasterServerPort','6543',NULL),('MasterBackendOverride','1',NULL),('DeletesFollowLinks','0',NULL),('TruncateDeletesSlowly','0','apheleia'),('HDRingbufferSize','9400',NULL),('StorageScheduler','BalancedFreeSpace',NULL),('UPnP/WMPSource','0',NULL),('DisableAutomaticBackup','0',NULL),('DisableFirewireReset','0','apheleia'),('EITTransportTimeout','5',NULL),('EITCrawIdleStart','60',NULL),('blockSDWUwithoutClient','1',NULL),('idleWaitForRecordingTime','15',NULL),('StartupSecsBeforeRecording','120',NULL),('WakeupTimeFormat','hh:mm yyyy-MM-dd',NULL),('ServerHaltCommand','sudo /sbin/halt -p',NULL),('WOLbackendConnectRetry','5',NULL),('BackendStopCommand','killall mythbackend',NULL),('BackendStartCommand','mythbackend',NULL),('JobQueueMaxSimultaneousJobs','1','apheleia'),('JobQueueCheckFrequency','60','apheleia'),('JobQueueWindowStart','00:00','apheleia'),('JobQueueWindowEnd','23:59','apheleia'),('JobQueueCPU','0','apheleia'),('JobAllowMetadata','1','apheleia'),('JobAllowCommFlag','1','apheleia'),('JobAllowTranscode','1','apheleia'),('JobAllowUserJob1','0','apheleia'),('JobAllowUserJob2','0','apheleia'),('JobAllowUserJob3','0','apheleia'),('JobAllowUserJob4','0','apheleia'),('JobsRunOnRecordHost','0',NULL),('AutoCommflagWhileRecording','0',NULL),('JobQueueCommFlagCommand','mythcommflag',NULL),('JobQueueTranscodeCommand','mythtranscode',NULL),('AutoTranscodeBeforeAutoCommflag','0',NULL),('SaveTranscoding','0',NULL),('UserJobDesc1','User Job #1',NULL),('UserJobDesc2','User Job #2',NULL),('UserJobDesc3','User Job #3',NULL),('UserJobDesc4','User Job #4',NULL),('MythFillEnabled','1',NULL),('MythFillDatabasePath','mythfilldatabase',NULL),('MythFillMaxHour','23',NULL),('MythFillGrabberSuggestsTime','1',NULL),('DateFormat','ddd MMM d yyyy','apheleia'),('MythArchiveDateFormat','%a %b %d %Y','apheleia'),('MythArchiveTimeFormat','%I:%M %p','apheleia'),('MythArchiveVideoFormat','NTSC','apheleia'),('ShortDateFormat','M/d','apheleia'),('TimeFormat','h:mm AP','apheleia'),('WebBrowserZoomLevel','1','apheleia'),('ImageStorageGroupName','Images',NULL),('ImageSortOrder','0',NULL),('ImageShowHiddenFiles','0',NULL),('ImageSlideShowTime','3500',NULL),('ImageTransitionType','1',NULL),('ImageTransitionTime','1000',NULL); +INSERT INTO `settings` VALUES ('mythfilldatabaseLastRunStart','',NULL),('mythfilldatabaseLastRunEnd','',NULL),('mythfilldatabaseLastRunStatus','',NULL),('DataDirectMessage','',NULL),('HaveRepeats','0',NULL),('DBSchemaVer','1348',NULL),('WebBrowserZoomLevel','1','apheleia'),('Language','en_US',NULL),('Country','US',NULL),('FreqTable','us-bcast',NULL),('ISO639Language0','eng',NULL),('ISO639Language1','eng',NULL),('TVFormat','NTSC',NULL),('VbiFormat','NTSC Closed Caption',NULL),('DateFormat','ddd MMM d yyyy','apheleia'),('MythArchiveDateFormat','%a %b %d %Y','apheleia'),('MythArchiveTimeFormat','%I:%M %p','apheleia'),('MythArchiveVideoFormat','NTSC','apheleia'),('ShortDateFormat','M/d','apheleia'),('TimeFormat','h:mm AP','apheleia'),('BackupDBLastRunStart','2017-09-17 23:08:04',NULL),('BackupDBLastRunEnd','2017-09-17 23:08:05',NULL),('HardwareProfileEnabled','0',NULL),('BackendServerIP','127.0.0.1','apheleia'),('BackendServerIP6','::1','apheleia'),('AllowLinkLocal','1','apheleia'),('BackendServerPort','6543','apheleia'),('BackendStatusPort','6544','apheleia'),('MasterServerIP','127.0.0.1',NULL),('MasterServerPort','6543',NULL),('MasterBackendOverride','1',NULL),('DeletesFollowLinks','0',NULL),('TruncateDeletesSlowly','0','apheleia'),('HDRingbufferSize','9400',NULL),('StorageScheduler','BalancedFreeSpace',NULL),('UPnP/WMPSource','0',NULL),('DisableAutomaticBackup','0',NULL),('DisableFirewireReset','0','apheleia'),('EITTransportTimeout','5',NULL),('EITCrawIdleStart','60',NULL),('blockSDWUwithoutClient','1',NULL),('idleWaitForRecordingTime','15',NULL),('StartupSecsBeforeRecording','120',NULL),('WakeupTimeFormat','hh:mm yyyy-MM-dd',NULL),('ServerHaltCommand','sudo /sbin/halt -p',NULL),('WOLbackendConnectRetry','5',NULL),('BackendStopCommand','killall mythbackend',NULL),('BackendStartCommand','mythbackend',NULL),('JobQueueMaxSimultaneousJobs','1','apheleia'),('JobQueueCheckFrequency','60','apheleia'),('JobQueueWindowStart','00:00','apheleia'),('JobQueueWindowEnd','23:59','apheleia'),('JobQueueCPU','0','apheleia'),('JobAllowMetadata','1','apheleia'),('JobAllowCommFlag','1','apheleia'),('JobAllowTranscode','1','apheleia'),('JobAllowUserJob1','0','apheleia'),('JobAllowUserJob2','0','apheleia'),('JobAllowUserJob3','0','apheleia'),('JobAllowUserJob4','0','apheleia'),('JobsRunOnRecordHost','0',NULL),('AutoCommflagWhileRecording','0',NULL),('JobQueueCommFlagCommand','mythcommflag',NULL),('JobQueueTranscodeCommand','mythtranscode',NULL),('AutoTranscodeBeforeAutoCommflag','0',NULL),('SaveTranscoding','0',NULL),('UserJobDesc1','User Job #1',NULL),('UserJobDesc2','User Job #2',NULL),('UserJobDesc3','User Job #3',NULL),('UserJobDesc4','User Job #4',NULL),('MythFillEnabled','1',NULL),('MythFillDatabasePath','mythfilldatabase',NULL),('MythFillMaxHour','23',NULL),('MythFillGrabberSuggestsTime','1',NULL),('DateFormat','ddd MMM d yyyy','apheleia'),('MythArchiveDateFormat','%a %b %d %Y','apheleia'),('MythArchiveTimeFormat','%I:%M %p','apheleia'),('MythArchiveVideoFormat','NTSC','apheleia'),('ShortDateFormat','M/d','apheleia'),('TimeFormat','h:mm AP','apheleia'),('WebBrowserZoomLevel','1','apheleia'),('ImageStorageGroupName','Images',NULL),('ImageSortOrder','0',NULL),('ImageShowHiddenFiles','0',NULL),('ImageSlideShowTime','3500',NULL),('ImageTransitionType','1',NULL),('ImageTransitionTime','1000',NULL),('DateFormat','ddd MMM d yyyy','zeal'),('MythArchiveDateFormat','%a %b %d %Y','zeal'),('MythArchiveTimeFormat','%I:%M %p','zeal'),('MythArchiveVideoFormat','NTSC','zeal'),('ShortDateFormat','M/d','zeal'),('TimeFormat','h:mm AP','zeal'),('WebBrowserZoomLevel','1','zeal'),('MasterServerName','apheleia',NULL),('BackendServerAddr','127.0.0.1','apheleia'); /*!40000 ALTER TABLE `settings` ENABLE KEYS */; UNLOCK TABLES; @@ -2784,4 +2786,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2016-04-21 14:50:08 +-- Dump completed on 2017-09-17 18:11:37 diff --git a/abs/core/mythdb-initial/mythdb.install b/abs/core/mythdb-initial/mythdb.install index be4e64f..1302d30 100755 --- a/abs/core/mythdb-initial/mythdb.install +++ b/abs/core/mythdb-initial/mythdb.install @@ -1,30 +1,28 @@ mydate=`date +%m-%d-%y` HOST=`hostname` post_install() { - mysqldump mythconverg >/data/database/mythconverg.${mydate}.sql - #load timezone info for mythtv .26 - mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql - mysql -u root -e 'drop database mythconverg;' + mysqldump mythconverg >/data/database/mythconverg.${mydate}.sql + #load timezone info for mythtv .26 + mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql + mysql -u root -e 'drop database mythconverg;' mysql -u root -e 'create database mythconverg;' - echo installing the default database - if [ $HOST = 'apheleia' ] - then - cp /data/database/mc.sql.initial /data/database/mc.sql.fixed - cp /data/database/permissions.sql /data/database/permissions.sql.fixed - cp /data/database/custom.sql /data/database/custom.sql.fixed - else - sed -e "s/apheleia/$HOST/g" /data/database/mc.sql.initial > /data/database/mc.sql.fixed - sed -e "s/apheleia/$HOST/g" /data/database/permissions.sql > /data/database/permissions.sql.fixed - sed -e "s/apheleia/$HOST/g" /data/database/custom.sql > /data/database/custom.sql.fixed - + echo installing the default database + if [ $HOST = 'apheleia' ] + then + cp /data/database/mc.sql.initial /data/database/mc.sql.fixed + cp /data/database/permissions.sql /data/database/permissions.sql.fixed + cp /data/database/custom.sql /data/database/custom.sql.fixed + else + sed -e "s/apheleia/$HOST/g" /data/database/mc.sql.initial > /data/database/mc.sql.fixed + sed -e "s/apheleia/$HOST/g" /data/database/permissions.sql > /data/database/permissions.sql.fixed + sed -e "s/apheleia/$HOST/g" /data/database/custom.sql > /data/database/custom.sql.fixed fi - MC="/data/database/mc.sql.fixed" - mysql mythconverg < $MC 2>/dev/null - mysql < /data/database/permissions.sql.fixed 2>/dev/null - mysql mythconverg < /data/database/custom.sql.fixed 2>/dev/null + mysql mythconverg < $MC 2>/dev/null + mysql < /data/database/permissions.sql.fixed 2>/dev/null + mysql mythconverg < /data/database/custom.sql.fixed 2>/dev/null # rm /data/database/mc.sql.initial # rm /data/database/custom.sql.fixed -- cgit v0.12