2 # Create table t1 having two integer field f1 ,f2 with primary key f1 and create table t2 having two integer field f1,f2 with foreign key f1 refers t1 (f1).use csqldump toll for dumping the foreign key information.
4 input
=${PWD}/tools
/csqldump
/foreign1.sql
8 REL_PATH
=${PWD}/tools
/csqldump
11 echo "DROP TABLE t2;" >$REL_PATH/drp1.sql
12 echo "DROP TABLE t1;" >>$REL_PATH/drp1.sql
14 if [ "$VALGRIND" = "true" ]
16 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s $REL_PATH/foreign1.sql
2> $0.valgr
18 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s $REL_PATH/foreign1.sql
>/dev
/null
2>&1
21 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s $REL_PATH/drp1.sql
> /dev
/null
2>&1
22 rm -f $REL_PATH/drp1.sql
27 if [ "$VALGRIND" = "true" ]
29 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csqldump
2>> $0.valgr
31 $CSQL_INSTALL_ROOT/bin
/csqldump
34 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s $REL_PATH/drp1.sql
> /dev
/null
2>&1
35 rm -f $REL_PATH/drp1.sql
40 if [ "$VALGRIND" = "true" ]
42 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s $REL_PATH/drp1.sql
2>> $0.valgr
44 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s $REL_PATH/drp1.sql
> /dev
/null
2>&1
47 rm -f $REL_PATH/drp1.sql
52 rm -f $REL_PATH/drp1.sql