summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorJames Meyer <james.meyer@operamail.com>2010-01-31 00:55:10 (GMT)
committerJames Meyer <james.meyer@operamail.com>2010-01-31 00:55:10 (GMT)
commitfae1b1d479a6d6414849141fc62fdb126f4e5031 (patch)
tree0901d4b5d7c070f076863ac16b62728d45993959
parent6ce5f7daf1ab8a3ba4b792e50c34f59b8af94304 (diff)
downloadlinhes_pkgbuild-fae1b1d479a6d6414849141fc62fdb126f4e5031.zip
linhes_pkgbuild-fae1b1d479a6d6414849141fc62fdb126f4e5031.tar.gz
linhes_pkgbuild-fae1b1d479a6d6414849141fc62fdb126f4e5031.tar.bz2
mythdb-initial: add custom.sql
-: add mythsmolt jumppoint to custom.sql
-rwxr-xr-xabs/core-testing/mythdb-initial/PKGBUILD5
-rw-r--r--abs/core-testing/mythdb-initial/custom.sql3
-rwxr-xr-xabs/core-testing/mythdb-initial/mythdb.install4
3 files changed, 10 insertions, 2 deletions
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"