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 primary key f3 .
4 # Create table t3 having two integer field f5,f6 with foreign key f5 refers t1 (f1) and foreign key f6 refers t2 (f3).
5 # Drop table t3. Then drop table t1 and t2. It should be Passed
8 QUITFILE
=${PWD}/tools
/csql
/quit.sql
12 REL_PATH
=`pwd`/tools
/csql
15 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/foreign146.sql
18 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_t3_t2_t1.sql
19 rm -f ${REL_PATH}/drp1.sql
23 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_t3_t2_t1.sql