Error upon database migrate_module _001 (installation)

[locvfx]

Error Number: 1075

Incorrect table definition; there can be only one auto column and it must be defined as a key

CREATE TABLE bf_news_articles ( id int(11) NOT NULL AUTO_INCREMENT, author int(11) NOT NULL DEFAULT '-1', title varchar(255) NOT NULL, date int(11) DEFAULT NULL, body longtext, attachment varchar(1000) NOT NULL, image_align varchar(255) NOT NULL, image_caption varchar(255) NOT NULL, tags varchar(255) NOT NULL, created_on int(11) NOT NULL DEFAULT '0', created_by int(11) NOT NULL DEFAULT '-1', modified_on int(11) NOT NULL DEFAULT '0', modified_by int(11) NOT NULL DEFAULT '-1', status_id tinyint(1) NOT NULL DEFAULT '0', category_id tinyint(1) NOT NULL DEFAULT '0', date_published int(11) DEFAULT NULL, deleted tinyint(1) NOT NULL DEFAULT '0' ) DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci

Filename: *****/bonfire/modules/news/migrations/001_Install_news.php

Line Number: 43