From fae1b1d479a6d6414849141fc62fdb126f4e5031 Mon Sep 17 00:00:00 2001
From: James Meyer <james.meyer@operamail.com>
Date: Sat, 30 Jan 2010 18:55:10 -0600
Subject: mythdb-initial: add custom.sql -: add mythsmolt jumppoint to
 custom.sql

---
 abs/core-testing/mythdb-initial/PKGBUILD       | 5 +++--
 abs/core-testing/mythdb-initial/custom.sql     | 3 +++
 abs/core-testing/mythdb-initial/mythdb.install | 4 ++++
 3 files changed, 10 insertions(+), 2 deletions(-)
 create mode 100644 abs/core-testing/mythdb-initial/custom.sql

diff --git a/abs/core-testing/mythdb-initial/PKGBUILD b/abs/core-testing/mythdb-initial/PKGBUILD
index a7c7ffa..d683ce1 100755
--- a/abs/core-testing/mythdb-initial/PKGBUILD
+++ b/abs/core-testing/mythdb-initial/PKGBUILD
@@ -1,6 +1,6 @@
 pkgname=mythdb-initial
 pkgver=1
-pkgrel=43
+pkgrel=48
 pkgdesc="setup the initial mythtv database for linhes"
 url=""
 license=""
@@ -10,7 +10,7 @@ conflicts=()
 replaces=()
 backup=()
 install=mythdb.install
-source=(mc.sql permissions.sql)
+source=(mc.sql permissions.sql custom.sql)
 md5sums=()
 arch=('i686')
 build() {
@@ -18,4 +18,5 @@ build() {
   mkdir -p $startdir/pkg/data/database
   cp mc.sql  $startdir/pkg/data/database/mc.sql.initial
   cp permissions.sql  $startdir/pkg/data/database/permissions.sql
+  cp custom.sql  $startdir/pkg/data/database/custom.sql
 }
diff --git a/abs/core-testing/mythdb-initial/custom.sql b/abs/core-testing/mythdb-initial/custom.sql
new file mode 100644
index 0000000..1033a9e
--- /dev/null
+++ b/abs/core-testing/mythdb-initial/custom.sql
@@ -0,0 +1,3 @@
+INSERT INTO `jumppoints` (`destination`, `description`,`keylist`,`hostname`) VALUES
+('MythSmolt','Hardware profiler','Ctrl+Alt+p','larch5')
+
diff --git a/abs/core-testing/mythdb-initial/mythdb.install b/abs/core-testing/mythdb-initial/mythdb.install
index 4834c69..a4dcb84 100755
--- a/abs/core-testing/mythdb-initial/mythdb.install
+++ b/abs/core-testing/mythdb-initial/mythdb.install
@@ -11,16 +11,20 @@ post_install() {
 	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/larch5/$HOST/g" /data/database/mc.sql.initial > /data/database/mc.sql.fixed
 	    sed -e "s/larch5/$HOST/g" /data/database/permissions.sql > /data/database/permissions.sql.fixed
+	    sed -e "s/larch5/$HOST/g" /data/database/custom.sql > /data/database/custom.sql.fixed
 
 	fi
 		
 	mysql mythconverg < /data/database/mc.sql.fixed 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
 }
 post_upgrade() {
 	echo "nothing to do"
-- 
cgit v0.12