CREATE TABLE `entries_tags` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `entry_id` int(11) NOT NULL,
 `tag_id` int(11) NOT NULL,
 PRIMARY KEY (`id`),
 KEY `entry_id` (`entry_id`),
 KEY `tag_id` (`tag_id`),
 KEY `entry_id_2` (`entry_id`,`tag_id`),
 CONSTRAINT `entries_tags_ibfk_1` FOREIGN KEY (`entry_id`) REFERENCES `entries` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
 CONSTRAINT `entries_tags_ibfk_2` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1171845 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

CREATE TABLE `entries` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `title` text COLLATE utf8_unicode_ci NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1000002 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

CREATE TABLE `tags` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci