Change varchar fields to TEXT to prevent row size issue
https://bugs.mysql.com/bug.php?id=69336
Simply convert the huge varchar fields to TEXT types. This types require much less space for a single row. In MySQL strict, the _optin table can't be created anymore.