3 # Create table t1 having two integer field f1 ,f2 with primary key f1 .Create table t2 having two integer field f1,f2 with foreign key f1 refers t1 (f1) and Create table t3 having two integer field f1,f2 with foreign key f1 refers t1 (f1). drop FK table t2 but not drop t3.Then drop PK table t1. It should be failed.
5 QUITFILE
=${PWD}/tools
/csql
/quit.sql
9 REL_PATH
=`pwd`/tools
/csql
12 echo "drop table t3;" >${REL_PATH}/drp1.sql
13 echo "drop table t1;" >>${REL_PATH}/drp1.sql
15 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_fk_pk_fk.sql
18 rm -f ${REL_PATH}/drp1.sql
22 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drp1.sql
25 rm -f ${REL_PATH}/drp1.sql
29 rm -f ${REL_PATH}/drp1.sql