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