[Tikiwiki-cvs] tiki/doc/devtools diffsql.sh,1.2.2.1,1.2.2.2

[<pk...@us...>]

Update of /cvsroot/tikiwiki/tiki/doc/devtools
In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv22168

Modified Files:
      Tag: BRANCH-1-10
	diffsql.sh 
Log Message:
[MOD] diffsql: change mysqldump options in order to have one value per line when tables are populated. This way, it is easier to see the differences.

Index: diffsql.sh
===================================================================
RCS file: /cvsroot/tikiwiki/tiki/doc/devtools/diffsql.sh,v
retrieving revision 1.2.2.1
retrieving revision 1.2.2.2
diff -u -d -r1.2.2.1 -r1.2.2.2
--- diffsql.sh	14 Feb 2008 21:41:39 -0000	1.2.2.1
+++ diffsql.sh	14 Feb 2008 22:25:23 -0000	1.2.2.2
@@ -12,6 +12,8 @@
 
 db=tikisqldiff
 
+dumpopts="--skip-opt -c"
+
 echo --- generate first diff file : old sql upgraded
 
 echo make sure there is no old db
@@ -27,7 +29,7 @@
 mysql -u$user -p$pass -f $db < $update
 
 echo dump updated db to file
-mysqldump -e -c -u$user -p$pass $db > lastversion.dump
+mysqldump $dumpopts -u$user -p$pass $db > lastversion.dump
 
 
 echo --- generate second diff file : new sql
@@ -42,7 +44,7 @@
 mysql -u$user -p$pass $db < $new
 
 echo dump db to file
-mysqldump -e -c -u$user -p$pass $db > newversion.dump
+mysqldump $dumpopts -u$user -p$pass $db > newversion.dump
 
 echo remove temporary db again
 mysqladmin -u$user -p$pass drop $db