From 0c7cc04631ff050702a2874b5f18b4f5bd67ee99 Mon Sep 17 00:00:00 2001
From: Slim Amamou <slim@alef.dari>
Date: Wed, 19 Sep 2007 17:19:45 +0200
Subject: [PATCH] enhanced apply-sql-patch it can print sql statements to
 initialize the database

---
 apply-sql-patch | 15 ++++++++++++++-
 1 file changed, 14 insertions(+), 1 deletion(-)

diff --git a/apply-sql-patch b/apply-sql-patch
index b95136b..df4a8ef 100755
--- a/apply-sql-patch
+++ b/apply-sql-patch
@@ -2,12 +2,25 @@
 
 # applies SQL patch to a database and inserts a revision control entry in the
 # database.
+# usage :
+# apply-sql-patch (without arguments)
+# prints sql statements to initialise the datbase
+# apply-sql-patch <patch-file>
+# applies the patch to the database
+
+if [ $? -eq 0 ] 
+then cat<<EOF
+create table ctrl_patch (id integer auto_increment primary key, time timestamp, name varchar(128) unique);
+insert into ctrl_patch values (NULL,NULL, 'patch-create-ctrl_patch.sql');
+EOF
+exit
+fi
 
 patch=$1
 db=markkit
 db_user=root
 
-ctrl_patch_query="insert into ctrl_patch values ('', '$patch')"
+ctrl_patch_query="insert into ctrl_patch values (NULL,NULL, '$patch')"
 
 cat $patch
 mysql -u $db_user $db < $patch
-- 
2.11.4.GIT