3 # Create table t1 having three integer field f1 ,f2,f3 with composite primary key (f1,f2) and create table t2 having three integer field f1,f2,f3 with foreign key (f1,f3) refers t1 (f1,f2). It should pass.
4 # This case also tests field name( Means FK field name may or may not be same as PK field name.)
6 QUITFILE
=${PWD}/tools
/csql
/quit.sql
10 REL_PATH
=`pwd`/tools
/csql
13 echo "drop table t2;" >${REL_PATH}/drp1.sql
14 echo "drop table t1;" >>${REL_PATH}/drp1.sql
16 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/fieldname_fk_pk.sql
19 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drp1.sql
20 rm -f ${REL_PATH}/drp1.sql
24 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drp1.sql
27 rm -f ${REL_PATH}/drp1.sql
31 rm -f ${REL_PATH}/drp1.sql