text: truncate table `department`;
  truncate table `employee`;
  
  insert into `department` values (1, 'foo');
  insert into `department` values (2, 'bar');
  
  insert into `employee` values (1, 1, 'e1');
  insert into `employee` values (2, 2, 'e2');
  insert into `employee` values (3, 1, 'e3');
  insert into `employee` values (4, 2, 'e4');
  