blob: 8c7f9365524f7b250b29893e8ef810d6ac1f8426 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
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
|
