text: 
  CREATE TABLE IF NOT EXISTS `qalle_brottsregister` (
    `id` int(255) NOT NULL AUTO_INCREMENT,
    `identifier` varchar(50) NOT NULL,
    `firstname` varchar(255) NOT NULL,
    `lastname` varchar(255) NOT NULL,
    `dateofcrime` varchar(255) NOT NULL,
    `crime` varchar(255) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;
  