2 # Create table t1 having two integer field f1 ,f2 with primary key f1 .
3 # create table t2 having two integer field f3,f4 with foreign key f3 refers t1 (f1) and a primary key f4
4 # create table t3 having two integer field f5,f6 with foreign key f5 refers t2 (f4).It Should be passed.
7 QUITFILE
=${PWD}/tools
/csql
/quit.sql
11 REL_PATH
=`pwd`/tools
/csql
14 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/foreign143.ksh
17 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_t3_t2_t1.sql
18 rm -f ${REL_PATH}/drp1.sql
22 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_t3_t2_t1.sql