CREATE TABLE `drugobjects` (
  `id` int(11) NOT NULL,
  `identifier` varchar(500) COLLATE utf8mb4_bin NOT NULL,
  `drugid` int(11) NOT NULL,
  `coords` varchar(500) COLLATE utf8mb4_bin NOT NULL,
  `rotation` varchar(500) COLLATE utf8mb4_bin NOT NULL,
  `drugtype` int(11) NOT NULL,
  `drugdata` longtext COLLATE utf8mb4_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

ALTER TABLE `drugobjects`
  ADD PRIMARY KEY (`id`),
  ADD KEY `identifier` (`identifier`(191)),
  ADD KEY `drugid` (`drugid`);

ALTER TABLE `drugobjects`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
COMMIT;