From 256a0466cbbbfa95d3321920e7d50fb130da9f3e Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Tue, 23 Nov 2004 06:43:21 +0000
Subject: - Patch #13334 by Axel: added a simple script to prefix a database
 scheme.

---
 scripts/prefix.sh | 21 +++++++++++++++++++++
 1 file changed, 21 insertions(+)
 create mode 100644 scripts/prefix.sh

(limited to 'scripts')

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
+
-- 
cgit v1.2.3