CREATE TABLE `people` (
  `person` smallint(3) unsigned NOT NULL AUTO_INCREMENT,
  `title` char(10) NOT NULL,
  `first_name` char(20) NOT NULL DEFAULT '',
  `second_name` char(20) NOT NULL DEFAULT '',
  `email` char(50) NOT NULL DEFAULT '',
  `affiliation` char(250) NOT NULL DEFAULT '',
  `website` char(200) DEFAULT NULL,
  `bio` text,
  `address` text,
  `display_order` smallint(3) DEFAULT NULL,
  PRIMARY KEY (`person`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8
