CREATE TABLE IF NOT EXISTS unit (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `dateCreated` datetime NOT NULL,
  `lastModified` datetime NOT NULL,
  `identifier` bigint(20) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `version` int(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `identifier` (`identifier`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2925 ;

ALTER TABLE role
ADD unit_id bigint(20) DEFAULT NULL;