 create table progress (
   bz_id                       int primary key,
   description                 varchar(100) not null
-)
+) Type=InnoDB
+
 insert into progress values (500, 'New')
 insert into progress values (10000, 'Initialize')
 insert into progress values (20000, 'Done')

  nextcheck                   datetime null,
  checkinterval               int null,
  bz_id                       int not null default 500,

  /* data columns */
  title                       varchar(255) not null,

insert into progress values (30000, 'Locked')
insert into progress values (30001, 'Delete')
insert into progress values (40000, 'Deleted')

create table authormapping (
  feed_id                     int null,
  author_from                 varchar(255) not null,
  author_to                   varchar(255) not null
) Type=InnoDB
alter table authormapping add constraint foreign key (feed_id) references feed (feed_id)
