CREATE TABLE `people` (
  `ID` int(12) NOT NULL,
  `name` varchar(32) COLLATE utf8_hungarian_ci NOT NULL,
  `birthdate` date NOT NULL,
  `email` varchar(128) COLLATE utf8_hungarian_ci NOT NULL,
  `interests` varchar(256) COLLATE utf8_hungarian_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;

ALTER TABLE `people`
  ADD PRIMARY KEY (`ID`);


ALTER TABLE `people`
  MODIFY `ID` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;