CREATE TABLE `item_primary` (
  `ID` int(11),
  `author` varchar(3) DEFAULT NULL COMMENT 'Initials',
  `reviewer` varchar(3) DEFAULT NULL COMMENT 'Initials',
  `verified` int(1) DEFAULT NULL COMMENT '0: Not Verified, 1: Verified, 2: Error',
  `privacy` int(1) DEFAULT NULL COMMENT '0: Not Private; 1: Private (Draft); 2: Private (Private).',
  `created` timestamp DEFAULT CURRENT_TIMESTAMP COMMENT 'Created time (GMT). Use offset to determine local time.',
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Modified time (GMT).',
  `type` varchar(12) DEFAULT NULL COMMENT 'E.g. book, image, etc.',
  `slug` varchar(12) DEFAULT NULL COMMENT 'Short name of the object (i.e. the first part in a key:value pair).',
  `value` varchar(255) DEFAULT NULL COMMENT 'The nugget we are after. Could be a single value or an array (JSON)',
  `title` varchar(255) DEFAULT NULL COMMENT 'Full name of the object',
  `summary` tinytext DEFAULT NULL COMMENT 'Short description. Summary. As needed.',
  `description` longtext DEFAULT NULL COMMENT 'Long description, as needed.'
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;


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

ALTER TABLE `item_primary`
  MODIFY `ID` int(20) UNSIGNED NOT NULL AUTO_INCREMENT;