Magento – Why and how does Magento differentiate between setup, read, and write database resources

This script working fine. May be you have some mistake. Check again following issue.

1. Clear cache
2. Your module need have proper permission(like read+write+execute permission)

Now run!

Enjoy coding :)

I think you need remove params 6 in addForeignKey function because in:

/**
 * Add Foreign Key to table
 *
 * @param string $fkName        the foreign key name
 * @param string $column        the foreign key column name
 * @param string $refTable      the reference table name
 * @param string $refColumn     the reference table column name
 * @param string $onDelete      the action on delete row
 * @return $this
 * @throws \Zend_Db_Exception
 * @SuppressWarnings(PHPMD.CyclomaticComplexity)
 */
public function addForeignKey($fkName, $column, $refTable, $refColumn, $onDelete = null)
{
    $upperName = strtoupper($fkName);

    // validate column name
    if (!isset($this->_columns[strtoupper($column)])) {
        throw new \Zend_Db_Exception('Undefined column "' . $column . '"');
    }

    switch ($onDelete) {
        case self::ACTION_CASCADE:
        case self::ACTION_RESTRICT:
        case self::ACTION_SET_DEFAULT:
        case self::ACTION_SET_NULL:
            break;
        default:
            $onDelete = self::ACTION_NO_ACTION;
    }

    $this->_foreignKeys[$upperName] = [
        'FK_NAME' => $fkName,
        'COLUMN_NAME' => $column,
        'REF_TABLE_NAME' => $refTable,
        'REF_COLUMN_NAME' => $refColumn,
        'ON_DELETE' => $onDelete
    ];

    return $this;
}