> ALTER TABLE bayes_vars MODIFY id SMALLINT UNSIGNED NOT NULL; Whoops - doing that will prevent any new users from being created in your Bayes database. Add auto_increment:
ALTER TABLE bayes_vars MODIFY id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT; -- _________________________________________________________________________ Andrew Donkin Waikato University, Hamilton, New Zealand
