diff options
| author | Dries Buytaert <dries@buytaert.net> | 2004-11-23 06:43:21 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2004-11-23 06:43:21 +0000 |
| commit | 256a0466cbbbfa95d3321920e7d50fb130da9f3e (patch) | |
| tree | 15c256bcddfde1b42cf35eac8376d8fc1563017e /scripts | |
| parent | b442fad027a7446aaa46068ecf180bc2c35b683c (diff) | |
| download | brdo-256a0466cbbbfa95d3321920e7d50fb130da9f3e.tar.gz brdo-256a0466cbbbfa95d3321920e7d50fb130da9f3e.tar.bz2 | |
- Patch #13334 by Axel: added a simple script to prefix a database scheme.
Diffstat (limited to 'scripts')
| -rw-r--r-- | scripts/prefix.sh | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/scripts/prefix.sh b/scripts/prefix.sh new file mode 100644 index 000000000..00793a8a5 --- /dev/null +++ b/scripts/prefix.sh @@ -0,0 +1,21 @@ +#!/bin/sh + +if [ $# != 2 ]; then + cat >&2 << EOH +This is Drupal database prefixer. + +Usage: + $0 prefix original_db.sql >prefixed_db.sql + +- all tables will prefixed with 'prefix' +EOH + +exit 1; +fi + +PRFX=$1; +sed "s/^CREATE TABLE /CREATE TABLE $PRFX/; + s/^INSERT INTO /INSERT INTO $PRFX/; + s/^REPLACE /REPLACE $PRFX/; + s/^ALTER TABLE /ALTER TABLE $PRFX/" $2 + |