-- --------------------------------------------------------
-- Host:                         10.0.0.2
-- Server version:               10.0.28-MariaDB-0+deb8u1 - (Debian)
-- Server OS:                    debian-linux-gnu
-- HeidiSQL Version:             9.4.0.5125
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

-- Dumping structure for table pk_archive.tags
CREATE TABLE IF NOT EXISTS `tags` (
  `tag_id` int(11) NOT NULL,
  `tag_type` enum('rating','genre','character','relationship','warning') COLLATE utf8mb4_unicode_ci NOT NULL,
  `tag_value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tag_display_value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`tag_id`),
  KEY `tag_type` (`tag_type`),
  KEY `tag_value` (`tag_value`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pk_archive.tags: ~21 rows (approximately)
DELETE FROM `tags`;
/*!40000 ALTER TABLE `tags` DISABLE KEYS */;
INSERT INTO `tags` (`tag_id`, `tag_type`, `tag_value`, `tag_display_value`) VALUES
	(20761, 'genre', 'angst', 'Angst'),
	(20762, 'rating', 'pg13', 'PG13'),
	(20763, 'warning', 'books 1 - 4', 'Books 1 - 4'),
	(20764, 'relationship', 'h/hr', 'Harry & Hermione'),
	(20765, 'genre', 'drama', 'Drama'),
	(20766, 'genre', 'romance', 'Romance'),
	(20767, 'rating', 'pg', 'PG'),
	(20768, 'rating', 'g', 'G'),
	(20769, 'relationship', 'l/j', 'Lily & James'),
	(20770, 'genre', 'humor', 'Humor'),
	(20771, 'relationship', 'd/g', 'Draco & Ginny'),
	(20772, 'genre', 'action/adventure', 'Action & Adventure'),
	(20773, 'rating', 'nc17', 'NC17'),
	(20774, 'warning', 'book 7 spoilers!', 'Books 1 - 7'),
	(20775, 'warning', 'books 1 - 5', 'Books 1 - 5'),
	(20776, 'rating', 'r', 'R'),
	(20777, 'genre', 'mystery', 'Mystery'),
	(20778, 'genre', 'horror', 'Horror'),
	(20779, 'genre', 'suspense', 'Suspense'),
	(20780, 'relationship', 'r/ll', 'Ron & Luna'),
	(20781, 'warning', 'books 1 - 6', 'Books 1 - 6');
/*!40000 ALTER TABLE `tags` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
