mcstafford.com

First, the obvious: Make sure the parent table has a unique key for validation when trying to create a foreign key.

Having said that, “Cant’ create table” is a poorly phrased response for situations in which “the obvious” rules have not been followed. If you’re still confused, re-read the first paragraph more carefully. Failing that… you may want to get someone else to resolve this error. Seriously.

getopts_demo() {
local loop=0 OPTERR=0 optstring=":ab:c:de:"

  echo "# processing getopts ${optstring} on '${@}'"

  while getopts ${optstring} OPT; do
    msg=""
    case ${OPT} in
      \?    )
        msg="failure -${OPTARG} is invalid"; OPTERR=$[${OPTERR}+1];;
      :     )
        msg="failure -${OPTARG} requires a value." OPTERR=$[${OPTERR}+1];;
      a|d   ) msg="success -${OPT} -> ${OPT}flag=1";;
      b|c|e ) msg="success -${OPT}=${OPTARG}";;
    esac
    loop=$[${loop}+1]
    cat << EOF
  # loop=${loop}
    OPTIND=${OPTIND:-} OPT=${OPT}
    OPTARG=${OPTARG:-''} OPTERR=${OPTERR:-}
    msg=${msg}
EOF
  done
  return ${OPTERR}
}

set -o nounset
getopts_demo -a -b world -e -f -g -c
echo "# ?=${?}"

# processing getopts :ab:c:de: on '-a -b world -e -f -g -c'
  # loop=1
    OPTIND=2 OPT=a
    OPTARG='' OPTERR=0
    msg=success -a -> aflag=1
  # loop=2
    OPTIND=4 OPT=b
    OPTARG=world OPTERR=0
    msg=success -b=world
  # loop=3
    OPTIND=6 OPT=e
    OPTARG=-f OPTERR=0
    msg=success -e=-f
  # loop=4
    OPTIND=7 OPT=?
    OPTARG=g OPTERR=1
    msg=failure -g is invalid
  # loop=5
    OPTIND=8 OPT=:
    OPTARG=c OPTERR=2
    msg=failure -c requires a value.
# ?=2

I’m finally ready to begin. Welcome!