   `entry_url_ios` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
   `entry_url_source` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
   `entry_screenshot_url` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
-  `entry_color` varchar(45) COLLATE utf8mb4_bin DEFAULT 'FFFFFF',
-  `entry_deleted` tinyint(1) DEFAULT '0',
-  PRIMARY KEY (`change_id`)
-) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
+  `entry_color` varchar(45) COLLATE utf8mb4_bin DEFAULT NULL,
+  `entry_deleted` tinyint(1) DEFAULT '0'
+) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
+
+-- --------------------------------------------------------
 
 --
 -- Table structure for table `jam`
 --
+
 CREATE TABLE `jam` (
-  `jam_id` int(11) NOT NULL AUTO_INCREMENT,
+  `jam_id` int(11) NOT NULL,
   `jam_datetime` datetime DEFAULT NULL,
   `jam_ip` varchar(45) COLLATE utf8mb4_bin DEFAULT NULL,
   `jam_user_agent` mediumtext COLLATE utf8mb4_bin,
-  `jam_username` varchar(45) COLLATE utf8mb4_bin DEFAULT NULL,
+  `jam_username` varchar(255) COLLATE utf8mb4_bin NOT NULL,
   `jam_jam_number` int(11) DEFAULT NULL,
   `jam_theme` mediumtext COLLATE utf8mb4_bin,
   `jam_start_datetime` datetime DEFAULT NULL,
   `jam_colors` text COLLATE utf8mb4_bin,
-  `jam_deleted` tinyint(1) DEFAULT '0',
-  PRIMARY KEY (`jam_id`)
-) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
+  `jam_deleted` tinyint(1) DEFAULT '0'
+) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
+
+-- --------------------------------------------------------
 
 --
 -- Table structure for table `poll`
 --
 
 CREATE TABLE `poll` (
-  `poll_id` int(11) NOT NULL AUTO_INCREMENT,
+  `poll_id` int(11) NOT NULL,
   `poll_question` mediumtext COLLATE utf8mb4_bin,
   `poll_type` varchar(45) COLLATE utf8mb4_bin DEFAULT NULL,
   `poll_start_datetime` datetime DEFAULT NULL,
   `poll_end_datetime` datetime DEFAULT NULL,
-  `poll_deleted` tinyint(4) DEFAULT '0',
-  PRIMARY KEY (`poll_id`)
-) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
+  `poll_deleted` tinyint(4) DEFAULT '0'
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
+
+-- --------------------------------------------------------
 
 --
 -- Table structure for table `poll_option`
 --
 
 CREATE TABLE `poll_option` (
-  `option_id` int(11) NOT NULL AUTO_INCREMENT,
+  `option_id` int(11) NOT NULL,
   `option_poll_id` int(11) DEFAULT NULL,
-  `option_poll_text` mediumtext COLLATE utf8mb4_bin,
-  PRIMARY KEY (`option_id`)
-) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
+  `option_poll_text` mediumtext COLLATE utf8mb4_bin
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
+
+-- --------------------------------------------------------
 
 --
 -- Table structure for table `poll_vote`
 --
 
 CREATE TABLE `poll_vote` (
-  `vote_id` int(11) NOT NULL AUTO_INCREMENT,
+  `vote_id` int(11) NOT NULL,
   `vote_option_id` int(11) DEFAULT NULL,
   `vote_username` varchar(45) COLLATE utf8mb4_bin DEFAULT NULL,
-  `vote_deleted` tinyint(4) DEFAULT '0',
-  PRIMARY KEY (`vote_id`)
-) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
+  `vote_deleted` tinyint(4) DEFAULT '0'
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
+
+-- --------------------------------------------------------
 
 --
 -- Table structure for table `satisfaction`
 --
 
 CREATE TABLE `satisfaction` (
-  `satisfaction_id` int(11) NOT NULL AUTO_INCREMENT,
+  `satisfaction_id` int(11) NOT NULL,
   `satisfaction_datetime` datetime NOT NULL,
   `satisfaction_ip` varchar(45) NOT NULL,
   `satisfaction_user_agent` varchar(255) NOT NULL,
   `satisfaction_question_id` varchar(255) NOT NULL,
   `satisfaction_username` varchar(45) NOT NULL,
-  `satisfaction_score` int(11) NOT NULL,
-  PRIMARY KEY (`satisfaction_id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=1 ;
+  `satisfaction_score` int(11) NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
 
 --
 -- Table structure for table `session`

  `user_email` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `user_twitter` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `user_bio` mediumtext COLLATE utf8mb4_bin,
  `user_role` int(11) DEFAULT '0',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `user_username_UNIQUE` (`user_username`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
  `entry_url_source` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `entry_screenshot_url` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `entry_color` varchar(45) COLLATE utf8mb4_bin DEFAULT 'FFFFFF',
  `entry_deleted` tinyint(1) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Triggers `entry`
--
DELIMITER $$
CREATE TRIGGER `entry_delete` BEFORE DELETE ON `entry` FOR EACH ROW BEGIN
    INSERT INTO `entry_changelog`
		(`change_id`,
		`change_type`,
		`change_datetime`,
		`entry_id`,
		`entry_datetime`,
		`entry_ip`,
		`entry_user_agent`,
		`entry_jam_id`,
		`entry_jam_number`,
		`entry_title`,
		`entry_description`,
		`entry_author`,
		`entry_url`,
		`entry_url_web`,
		`entry_url_windows`,
		`entry_url_linux`,
		`entry_url_mac`,
		`entry_url_android`,
		`entry_url_ios`,
		`entry_url_source`,
		`entry_screenshot_url`,
		`entry_color`,
		`entry_deleted`)
	VALUES
		(null,
		"DELETE",
		Now(),
		old.entry_id,
		old.entry_datetime,
		old.entry_ip,
		old.entry_user_agent,
		old.entry_jam_id,
		old.entry_jam_number,
		old.entry_title,
		old.entry_description,
		old.entry_author,
		old.entry_url,
		old.entry_url_web,
		old.entry_url_windows,
		old.entry_url_linux,
		old.entry_url_mac,
		old.entry_url_android,
		old.entry_url_ios,
		old.entry_url_source,
		old.entry_screenshot_url,
		old.entry_color,
		old.entry_deleted);
END
$$
DELIMITER ;
DELIMITER $$
CREATE TRIGGER `entry_insert` AFTER INSERT ON `entry` FOR EACH ROW BEGIN
    INSERT INTO `entry_changelog`
		(`change_id`,
		`change_type`,
