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