text: CREATE TABLE `users` (
    `id` int(11) NOT NULL,
    `name` varchar(45) NOT NULL,
    `views` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  INSERT INTO `users` (`id`, `name`, `views`) VALUES
  (1, 'bob', 0),
  (2, 'joe', 0);
  
  ALTER TABLE `users`
    ADD PRIMARY KEY (`id`);
  
  ALTER TABLE `users`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  COMMIT;