installation/sdnc/src/main/scripts/rmForeignKey.sh

   1 #!/bin/bash
   2
   3 MYSQL_USER=${MYSQL_USER:-sdnctl}
   4 MYSQL_PWD=${MYSQL_PWD:-gamma}
   5 MYSQL_DB=${MYSQL_DB:-sdnctl}
   6 MYSQL_HOST=${MYSQL_HOST:-dbhost}
   7
   8
   9 if [ $# -ne 2 ]
  10 then
  11   echo "Usage: $0 table foreign-key"
  12   exit 1
  13 fi
  14
  15 mysql --user=${MYSQL_USER} --password=${MYSQL_PWD} --host ${MYSQL_HOST} ${MYSQL_DB} <<EOF
  16 ALTER TABLE $1
  17 DROP FOREIGN KEY $2;
  18 EOF