SQL Statement help

I'm writing a restore function for my application and basically it drops a table and recreates based on an earlier backup. When I run the SQL query, an error occured. Can you please tell me what's wrong with my SQL statement here?

drop table if exists tbl_transaction;
create table tbl_transaction (
  trans_num int(11) not null auto_increment,
  transtype_id varchar(100) not null,
  license_id varchar(100) not null,
  trans_qty int(11) default '0' not null,
  trans_date date default '0000-00-00' not null,
  trans_alloc_date date default '0000-00-00' not null,
  trans_po_num varchar(100),
  trans_po_date date default '0000-00-00',
  trans_do_num varchar(100),
  trans_do_date date default '0000-00-00',
  trans_inv_num varchar(100),
  trans_inv_date date default '0000-00-00',
  trans_timestamp timestamp default 'CURRENT_TIMESTAMP',
  trans_remarks varchar(100)
);

Code (markup):

 

I think that it might be the case that auto_increment columns need to be key.

 

Oops!! Trying it..

--edit--
Yes, it worked!! Thanks for the help. Greened you