CREATE TABLE `positions` (
  `PositionIDLNK` int(11) NOT NULL AUTO_INCREMENT,
  `Position` varchar(255) NOT NULL,
  `DisplayOrder` int(11) NOT NULL,
  `Deleted` varchar(1) NOT NULL,
  PRIMARY KEY (`PositionIDLNK`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1