ALTER TABLE `#__kunena_users`
  CHANGE COLUMN `canSubscribe` `canSubscribe` tinyint(1) NOT NULL default '-1';