CREATE TABLE `ticket` (
  `id` INT(11) NOT NULL,
  `prelegent` VARCHAR(300) COLLATE utf8_bin NOT NULL,
  `asystent` VARCHAR(300) COLLATE utf8_bin NOT NULL,
  `asystent1` VARCHAR(50) COLLATE utf8_bin DEFAULT NULL,
  `asystent2` VARCHAR(50) COLLATE utf8_bin DEFAULT NULL,
  `asystent3` VARCHAR(50) COLLATE utf8_bin DEFAULT NULL,
  `asystent4` VARCHAR(50) COLLATE utf8_bin DEFAULT NULL,
  `kierowca` VARCHAR(300) COLLATE utf8_bin NOT NULL,
  `rodzaj_wyjazdu` VARCHAR(100) CHARACTER SET latin1 DEFAULT NULL,
  `miejscowosc` VARCHAR(100) COLLATE utf8_bin DEFAULT NULL,
  `miejscowosc1` VARCHAR(100) COLLATE utf8_bin DEFAULT NULL,
  `miejscowosc2` VARCHAR(100) COLLATE utf8_bin DEFAULT NULL,
  `miejscowosc3` VARCHAR(100) COLLATE utf8_bin DEFAULT NULL,
  `miejscowosc4` VARCHAR(100) COLLATE utf8_bin DEFAULT NULL,
  `miejscowosc5` VARCHAR(100) COLLATE utf8_bin DEFAULT NULL,
  `data` VARCHAR(10) CHARACTER SET latin1 DEFAULT NULL,
  `data1` VARCHAR(10) CHARACTER SET latin1 DEFAULT NULL,
  `data2` VARCHAR(10) CHARACTER SET latin1 DEFAULT NULL,
  `data3` VARCHAR(10) CHARACTER SET latin1 DEFAULT NULL,
  `data4` VARCHAR(10) COLLATE utf8_bin DEFAULT NULL,
  `data5` VARCHAR(10) COLLATE utf8_bin DEFAULT NULL,
  `hotel` VARCHAR(100) COLLATE utf8_bin DEFAULT NULL,
  `hotel1` VARCHAR(100) COLLATE utf8_bin DEFAULT NULL,
  `hotel2` VARCHAR(100) COLLATE utf8_bin DEFAULT NULL,
  `hotel3` VARCHAR(100) COLLATE utf8_bin DEFAULT NULL,
  `hotel4` VARCHAR(50) COLLATE utf8_bin DEFAULT NULL,
  `hotel5` VARCHAR(50) COLLATE utf8_bin DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;