[phpBT-dev] createdb with dynamic tablenames

[Patrick M. <mai...@st...>]

now, that it's possible to tell phpbt to use other tablenames createdb.sql
still creates hard coded names. to make this part dynamic we need some
kind of template for createdb.sql, for example createdb.sql.template,
which contains entries like

  DROP TABLE IF EXISTS TBL_OS;
  CREATE TABLE TBL_OS (

Those enrtries like TBL_OS have to be replaced by real tablenames.
Therefor I could create a shell-script like the following

  PREFIX="phpbt_"

  cat createdb.sql.template | sed "
    s/TBL_OS/${PREFIX}os/g
    s/TBL_BUG/${PREFIX}bug/g
  " > createdb.sql

this script can be modified to use an argument as prefix and can be used
in configure.

it could be a function, but I would like to have a script independent
from configure to create the createdb.sql.

what do you think?

Should this go in this release or the next?

--
http://home.nikocity.de/mairif
http://www.caravan-network.de