drop table if exists employees;
create table employees (
  id         int           not null auto_increment,
  title      varchar(100)  not null,
  firstname  varchar(100)  not null,
  lastname   varchar(100)  not null,
  salary     int,
  primary key (id)
);
insert into employees (title, firstname, lastname)
  values ('Sergeant', 'Malcolm', 'Reynolds');