-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               10.4.14-MariaDB - mariadb.org binary distribution
-- Server OS:                    Win64
-- HeidiSQL Version:             12.3.0.6589
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


-- Dumping database structure for manga
CREATE DATABASE IF NOT EXISTS `manga` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;
USE `manga`;

-- Dumping structure for table manga.author
CREATE TABLE IF NOT EXISTS `author` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `author` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT 'autors',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=256 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='albuma autors';

-- Dumping data for table manga.author: ~127 rows (approximately)
INSERT INTO `author` (`id`, `author`) VALUES
	(1, 'Eiichiro Oda'),
	(2, 'Masashi Kishimoto'),
	(3, 'Reki Kawahara'),
	(4, 'Akira Toriyama'),
	(5, 'Tetsuo Hara'),
	(6, 'Buronson'),
	(7, 'Sui Ishida'),
	(8, 'Kentaro Miura'),
	(9, 'Kouji Mori'),
	(10, 'ONE'),
	(11, 'Yusuke Murata'),
	(12, 'Tite Kubo'),
	(13, 'Kohei Horikoshi'),
	(14, 'Tsugumi Ohba'),
	(15, 'Takeshi Obata'),
	(16, 'Hirohiko Araki'),
	(17, 'Hajime Isayama'),
	(18, 'Hiromu Arakawa'),
	(19, 'Katsuhiro Otomo'),
	(20, 'Yoshihiro Togashi'),
	(21, 'Koyoharu Gotouge'),
	(22, 'Gege Akutami'),
	(23, 'Hiro Mashima'),
	(24, 'Yūki Tabata'),
	(25, 'Nekotarou'),
	(26, 'Yuki Kawaguchi'),
	(27, 'Takashi Hazama'),
	(28, 'Hige'),
	(29, 'Nachi Kio'),
	(30, 'Bonjin Hirameki'),
	(31, 'Ayumi Tsubaki'),
	(32, 'Kentarou Hino'),
	(33, 'Hanokage'),
	(34, 'Riichiro Inagaki'),
	(35, 'Boichi'),
	(36, 'Ashi'),
	(37, 'Keyaki Uchiuchi'),
	(38, 'Inori'),
	(39, 'Aonoshimo'),
	(40, 'Aka Akasaka'),
	(41, 'Satoru Yamaguchi'),
	(42, 'Akihiro Ononaka'),
	(43, 'Utashima'),
	(44, 'Tomoki Izumi'),
	(45, 'Tomoki Matsumoto'),
	(46, 'Okina Baba'),
	(47, 'Tsukasa Abe'),
	(48, 'WATAGIRI Saya'),
	(49, 'Hirotsugu Ryusen'),
	(50, 'Fuzichoco'),
	(51, 'Natsu Hyuuga'),
	(52, 'Nekotofu'),
	(53, 'Zachou Aloha'),
	(54, 'Un Hanikura'),
	(55, 'Kugane Maruyama'),
	(56, 'Hugin Miyama'),
	(57, 'Tsubasa Yamaguchi'),
	(58, 'Fefu Kazuno'),
	(59, 'Yasaiko Midorihana'),
	(60, 'Dai-616 Tokubetsu Jouhou Daitai'),
	(61, 'Akira Minamoto'),
	(62, 'Akihito Tsukushi'),
	(63, 'Makoto Yukimura'),
	(64, 'Syougo Kinugasa'),
	(65, 'Nagaru Tanigawa'),
	(66, 'Aka Akasaka'),
	(67, 'Mengo Yokoyari'),
	(68, 'Fuse'),
	(69, 'Yomi Sarachi'),
	(70, 'Muneyuki Kaneshiro'),
	(71, 'Naoki Urasawa'),
	(72, 'Yana Toboso'),
	(73, 'Hitoma Iruma'),
	(74, 'Somato'),
	(75, 'Kouta Hirano'),
	(76, 'Paru Itagaki'),
	(77, 'Shinobu Ohtaka'),
	(78, 'Izumo Ito'),
	(79, 'Yusei Matsui'),
	(80, 'Yuyuko Takemiya'),
	(81, 'Tomohito Oda'),
	(82, 'Kousuke Oono'),
	(83, 'Jougi Shiraishi'),
	(84, 'Itsuki Nanao'),
	(85, 'Azure'),
	(86, 'Kotoyama'),
	(87, 'Hajime Kamoshida'),
	(88, 'Aneko Yusagi'),
	(89, 'Coolkyousinnjya'),
	(90, 'Natsume Akatsuki'),
	(91, 'Boichi'),
	(92, 'Jin'),
	(93, 'Mahiro Satou'),
	(94, 'Kazue Kato'),
	(95, 'Clamp'),
	(96, 'Kagami Yoshimizu'),
	(97, 'Eretto'),
	(98, 'Rifujin na Magonote'),
	(99, 'Rimukoro'),
	(100, 'Yū Sasuga'),
	(101, 'Ken\'ichi Tachibana'),
	(102, 'Mashimesa Emoto'),
	(103, 'Shikayo Shirakaba'),
	(104, 'Burazza Anikkii'),
	(105, 'Yona Etou'),
	(106, 'Kumo Kagyu'),
	(107, 'Kōsuke Kurose'),
	(108, 'Akira Kareno'),
	(109, 'ue'),
	(110, 'Takumi Yanai'),
	(111, 'Tetsuya Tashiro'),
	(112, 'Takaya Kagami'),
	(113, 'Yamato Yamamoto'),
	(114, 'Kanata Yanagino'),
	(115, 'Hotondoshindeiru'),
	(116, 'Miya Kazuki'),
	(117, 'Suzuka'),
	(118, 'Yoshihide Fujiwara'),
	(119, 'Ryuchi Matsuda'),
	(120, 'Bkub Okawa'),
	(121, 'Saeki-san'),
	(122, 'Wan Shibata'),
	(123, 'Jun Maeda'),
	(124, 'Haruka Komowata'),
	(125, 'Petos'),
	(126, 'Nami Sano'),
	(127, 'Kazuki Takahashi');

-- Dumping structure for table manga.description
CREATE TABLE IF NOT EXISTS `description` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'apraksta id',
  `description` varchar(1500) COLLATE utf8_unicode_ci NOT NULL COMMENT 'albuma apraksts',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='albuma apraksts';

-- Dumping data for table manga.description: ~92 rows (approximately)
INSERT INTO `description` (`id`, `description`) VALUES
	(1, 'Gol D. Roger, a man referred to as the "Pirate King," is set to be executed by the World Government. But just before his demise, he confirms the existence of a great treasure, One Piece, located somewhere within the vast ocean known as the Grand Line. Announcing that One Piece can be claimed by anyone worthy enough to reach it, the Pirate King is executed and the Great Age of Pirates begins. Twenty-two years later, a young man by the name of Monkey D. Luffy is ready to embark on his own adventure, searching for One Piece and striving to become the new Pirate King. Armed with just a straw hat, a small boat, and an elastic body, he sets out on a fantastic journey to gather his own crew and a worthy ship that will take them across the Grand Line to claim the greatest status on the high seas.'),
	(2, 'Whenever Naruto Uzumaki proclaims that he will someday become the Hokage—a title bestowed upon the best ninja in the Village Hidden in the Leaves—no one takes him seriously. Since birth, Naruto has been shunned and ridiculed by his fellow villagers. But their contempt isn\'t because Naruto is loud-mouthed, mischievous, or because of his ineptitude in the ninja arts, but because there is a demon inside him. Prior to Naruto\'s birth, the powerful and deadly Nine-Tailed Fox attacked the village. In order to stop the rampage, the Fourth Hokage sacrificed his life to seal the demon inside the body of the newborn Naruto. And so when he is assigned to Team 7—along with his new teammates Sasuke Uchiha and Sakura Haruno, under the mentorship of veteran ninja Kakashi Hatake—Naruto is forced to work together with other people for the first time in his life. Through undergoing vigorous training and taking on challenging missions, Naruto must learn what it means to work in a team and carve his own route toward becoming a full-fledged ninja recognized by his village.'),
	(3, 'In the year 2022, gamers rejoice as Sword Art Online-a VRMMORPG (Virtual Reality Massively Multiplayer Online Role Playing Game) like no other-opens its virtual doors, allowing players to take full advantage of the ultimate in gaming technology: NerveGear, a system that allows users to completely immerse themselves in the game world by manipulating their brain waves to create a wholly realistic gaming experience. But when the game goes live, the elation of the players quickly turns to horror as they discover that, for all its amazing features, SAO is missing one of the most basic functions of any MMORPG-a log-out button. Now trapped in the virtual world of Aincrad, their bodies held captive by NerveGear in the real world, users are issued a chilling ultimatum: conquer all one hundred floors of Aincrad to regain your freedom. But in the warped world of SAO, "game over" means certain death-both virtual and real...'),
	(4, 'Bulma, a headstrong 16-year-old girl, is on a quest to find the mythical Dragon Balls—seven scattered magic orbs that grant the finder a single wish. She has but one desire in mind: a perfect boyfriend. On her journey, Bulma stumbles upon Gokuu Son, a powerful orphan who has only ever known one human besides her. Gokuu possesses one of the Dragon Balls, it being a memento from his late grandfather. In exchange for it, Bulma invites Gokuu to be a companion in her travels. By Bulma\'s side, Gokuu discovers a world completely alien to him. Powerful enemies embark on their own pursuits of the Dragon Balls, pushing Gokuu beyond his limits in order to protect Bulma and their growing circle of allies. However, Gokuu has secrets unbeknownst to even himself; the incredible strength within him stems from a mysterious source, one that threatens the many people he grows to hold dear. As his prowess in martial arts flourishes, Gokuu attracts stronger opponents whose villainous plans could collapse beneath his might. He undertakes the endless venture of combat training to defend his loved ones and the fate of the planet itself.'),
	(5, 'The year is 199X. The Earth has been devastated by nuclear war. The seas have dried up and the land is cracked and desolate. Most living things on the planet have become extinct apart from the human race. In this new age violence rules as civilization is lost and the strong rule the weak in a world where food and water are the only thing with value. At this time a mysterious man named Kenshirou appears with his deadly martial art, the 2000 years old Hokuto Shinken. With his deadly style eliminating the evil is he the savior of the new era?'),
	(6, 'Lurking within the shadows of Tokyo are frightening beings known as "ghouls," who satisfy their hunger by feeding on humans once night falls. An organization known as the Commission of Counter Ghoul (CCG) has been established in response to the constant attacks on citizens and as a means of purging these creatures. However, the problem lies in identifying ghouls as they disguise themselves as humans, living amongst the masses so that hunting prey will be easier. Ken Kaneki, an unsuspecting university freshman, finds himself caught in a world between humans and ghouls when his date turns out to be a ghoul after his flesh. Barely surviving this encounter after being taken to a hospital, he discovers that he has turned into a half-ghoul as a result of the surgery he received. Unable to satisfy his intense craving for human meat through conventional means, Kaneki is taken in by friendly ghouls who run a coffee shop in order to help him with his transition. As he begins what he thinks will be a peaceful new life, little does he know that he is about to find himself at the center of a war between his new comrades and the forces of the CCG, and that his new existence has caught the attention of ghouls all over Tokyo.'),
	(7, 'Guts, a former mercenary now known as the "Black Swordsman," is out for revenge. After a tumultuous childhood, he finally finds someone he respects and believes he can trust, only to have everything fall apart when this person takes away everything important to Guts for the purpose of fulfilling his own desires. Now marked for death, Guts becomes condemned to a fate in which he is relentlessly pursued by demonic beings. Setting out on a dreadful quest riddled with misfortune, Guts, armed with a massive sword and monstrous strength, will let nothing stop him, not even death itself, until he is finally able to take the head of the one who stripped him—and his loved one—of their humanity.'),
	(8, 'After rigorously training for three years, the ordinary Saitama has gained immense strength which allows him to take out anyone and anything with just one punch. He decides to put his new skill to good use by becoming a hero. However, he quickly becomes bored with easily defeating monsters, and wants someone to give him a challenge to bring back the spark of being a hero. Upon bearing witness to Saitama\'s amazing power, Genos, a cyborg, is determined to become Saitama\'s apprentice. During this time, Saitama realizes he is neither getting the recognition that he deserves nor known by the people due to him not being a part of the Hero Association. Wanting to boost his reputation, Saitama decides to have Genos register with him, in exchange for taking him in as a pupil. Together, the two begin working their way up toward becoming true heroes, hoping to find strong enemies and earn respect in the process.'),
	(9, 'For as long as he can remember, high school student Ichigo Kurosaki has been able to see the spirits of the dead, but that has not stopped him from leading an ordinary life. One day, Ichigo returns home to find an intruder in his room who introduces herself as Rukia Kuchiki, a Soul Reaper tasked with helping souls pass over. Suddenly, the two are jolted from their conversation when a Hollow—an evil spirit known for consuming souls—attacks. As Ichigo makes a brash attempt to stop the Hollow, Rukia steps in and shields him from a counterattack. Injured and unable to keep fighting, Rukia suggests a risky plan—transfer half of her Soul Reaper powers to Ichigo. He accepts and, to Rukia\'s surprise, ends up absorbing her powers entirely, allowing him to easily dispatch the Hollow. Now a Soul Reaper himself, Ichigo must take up Rukia\'s duties of exterminating Hollows and protecting spirits, both living and dead. Along with his friends Orihime Inoue and Yasutora Sado—who later discover spiritual abilities of their own—Ichigo soon learns that the consequences of becoming a Soul Reaper and dealing with the world of spirits are far greater than he ever imagined.'),
	(10, 'One day, a four-year-old boy came to a sudden realization: the world is not fair. Eighty percent of the world\'s population wield special abilities, known as "quirks," which have given many the power to make their childhood dreams of becoming a superhero a reality. Unfortunately, Izuku Midoriya was one of the few born without a quirk, suffering from discrimination because of it. Yet, he refuses to give up on his dream of becoming a hero; determined to do the impossible, Izuku sets his sights on the elite hero training academy, UA High. However, everything changes after a chance meeting with the number one hero and Izuku\'s idol, All Might. Discovering that his dream is not a dead end, the powerless boy undergoes special training, working harder than ever before. Eventually, this leads to him inheriting All Might\'s power, and with his newfound abilities, gets into his school of choice, beginning his grueling journey to become the successor of the best hero on the planet.'),
	(11, 'Ryuk, a god of death, drops his Death Note into the human world for personal pleasure. In Japan, prodigious high school student Light Yagami stumbles upon it. Inside the notebook, he finds a chilling message: those whose names are written in it shall die. Its nonsensical nature amuses Light; but when he tests its power by writing the name of a criminal in it, they suddenly meet their demise. Realizing the Death Note\'s vast potential, Light commences a series of nefarious murders under the pseudonym "Kira," vowing to cleanse the world of corrupt individuals and create a perfect society where crime ceases to exist. However, the police quickly catch on, and they enlist the help of L—a mastermind detective—to uncover the culprit. Death Note tells the thrilling tale of Light and L as they clash in a great battle-of-minds, one that will determine the future of the world.'),
	(12, 'While the gold rush takes Europe by storm, a young Jonathan Joestar lives a life of luxury with his father at their estate in Liverpool, England. Jonathan, known by his peers as JoJo, spends his days playing the part of a gentleman and living a carefree life. However, those peaceful days soon came to an end when Dio Brando intrudes upon him. Dio is young boy from London who is adopted into the Joestar family due to a debt Jonathan\'s father owed to Dio\'s father. While Jonathan is receptive towards having a new brother, Dio schemes against the Joestars in order to inherit the fortune. As Dio\'s schemes get out of hand, Jonathan is forced to confront him once and for all. Thus begins the story of the Joestar bloodline, as Jonathan matures with and eventually combats his adoptive brother while encountering bizarre new friends and foes.'),
	(13, 'Hundreds of years ago, horrifying creatures which resembled humans appeared. These mindless, towering giants, called "Titans," proved to be an existential threat, as they preyed on whatever humans they could find in order to satisfy a seemingly unending appetite. Unable to effectively combat the Titans, mankind was forced to barricade themselves within large walls surrounding what may very well be humanity\'s last safe haven in the world. In the present day, life within the walls has finally found peace, since the residents have not dealt with Titans for many years. Eren Yeager, Mikasa Ackerman, and Armin Arlert are three young children who dream of experiencing all that the world has to offer, having grown up hearing stories of the wonders beyond the walls. But when the state of tranquility is suddenly shattered by the attack of a massive 60-meter Titan, they quickly learn just how cruel the world can be. On that day, Eren makes a promise to himself that he will do whatever it takes to eradicate every single Titan off the face of the Earth, with the hope that one day, humanity will once again be able to live outside the walls without fear.'),
	(14, 'Alchemists are knowledgeable and naturally talented individuals who can manipulate and modify matter due to their art. Yet despite the wide range of possibilities, alchemy is not as all-powerful as most would believe. Human transmutation is strictly forbidden, and whoever attempts it risks severe consequences. Even so, siblings Edward and Alphonse Elric decide to ignore this great taboo and bring their mother back to life. Unfortunately, not only do they fail in resurrecting her, they also pay an extremely high price for their arrogance: Edward loses his left leg and Alphonse his entire body. Furthermore, Edward also gives up his right arm in order to seal his brother\'s soul into a suit of armor. Years later, the young alchemists travel across the country looking for the Philosopher\'s Stone, in the hopes of recovering their old bodies with its power. However, their quest for the fated stone also leads them to unravel far darker secrets than they could ever imagine.'),
	(15, '1988: It is World War III. Tokyo is decimated by a mysterious black explosion, unmatched in magnitude. 2019: Fast forward 31 years. Neo-Tokyo, hastily built on the ruins of old Tokyo, is a sprawling cityscape of neon extravaganza. It is a fusion of towering skyscrapers and cutting-edge technology that is permeated through and through with an explosive, hyper-violent cocktail of biker gangs, poverty, and revolutionaries. In this derelict metropolis live Tetsuo Shima and Shoutarou Kaneda, two bikers who are the best of friends and the fiercest of rivals, despite being affiliated with the same gang. Desperate to prove himself as Kaneda\'s equal, Tetsuo unwittingly pulls a stunt that culminates in the awakening of a cryptic existence that threatens to change both the face of Neo-Tokyo and the lives of those who call the city their home—the awakening of a government secret simply known as Akira.'),
	(16, '"Secret treasure hoards, undiscovered wealth... mystical places, unexplored frontiers... \'The mysterious unknown.\' There\'s magic in such words for those captivated by its spell. They are called \'Hunters\'!" Gon Freecss wants to become a Hunter so he can find his father, a man who abandoned him to pursue a life of adventure. But it\'s not that simple: only one in one hundred thousand can pass the Hunter Exam, and that is just the first obstacle on his journey. During the Hunter Exam, Gon befriends many other potential Hunters, such as the mysterious Killua; the revenge-driven Kurapika; and Leorio, who aims to become a doctor. There\'s a world of adventure and peril awaiting, and those who embrace it with open arms can become the greatest Hunters of them all!'),
	(17, 'Tanjirou Kamado lives with his impoverished family on a remote mountain. As the oldest sibling, he took upon the responsibility of ensuring his family\'s livelihood after the death of his father. On a cold winter day, he goes down to the local village in order to sell some charcoal. As dusk falls, he is forced to spend the night in the house of a curious man who cautions him of strange creatures that roam the night: malevolent demons who crave human flesh. When he finally makes his way home, Tanjirou\'s worst nightmare comes true. His entire family has been brutally slaughtered with the sole exception of his sister Nezuko, who has turned into a flesh-eating demon. Engulfed in hatred and despair, Tanjirou desperately tries to stop Nezuko from attacking other people, setting out on a journey to avenge his family and find a way to turn his beloved sister back into a human.'),
	(18, 'Hidden in plain sight, an age-old conflict rages on. Supernatural monsters known as "Curses" terrorize humanity from the shadows, and powerful humans known as "Jujutsu" sorcerers use mystical arts to exterminate them. When high school student Yuuji Itadori finds a dried-up finger of the legendary Curse Sukuna Ryoumen, he suddenly finds himself joining this bloody conflict. Attacked by a Curse attracted to the finger\'s power, Yuuji makes a reckless decision to protect himself, gaining the power to combat Curses in the process but also unwittingly unleashing the malicious Sukuna into the world once more. Though Yuuji can control and confine Sukuna to his own body, the Jujutsu world classifies Yuuji as a dangerous, high-level Curse who must be exterminated. Detained and sentenced to death, Yuuji meets Satoru Gojou—a teacher at Jujutsu High School—who explains that despite his imminent execution, there is an alternative for him. Being a rare vessel to Sukuna, if Yuuji were to die, then Sukuna would perish too. Therefore, if Yuuji were to consume the many other remnants of Sukuna, then Yuuji\'s subsequent execution would truly eradicate the malicious demon. Taking up this chance to make the world safer and live his life for a little longer, Yuuji enrolls in Jujutsu High, jumping headfirst into a harsh and unforgiving battlefield.'),
	(19, 'In the mystical realm of Earth Land, magic exists at the core of everyday life for its inhabitants, from transportation to utilities and everything in between. However, even with all its benefits, magic can also be used for great evil; therefore, to prevent dark forces from upsetting the natural order of things, there exists a system of magical guilds in the Kingdom of Fiore. Under the command of their respective guild masters, these guilds are made up of witches and wizards who take on various job requests to earn fame and fortune. One particular guild stands high above the rest in both strength and spirit, and its name is Fairy Tail. In his quest to find his dragon foster father—Igneel—Natsu Dragneel, a fiery and reckless mage, and his partner Happy run into a young celestial mage by the name of Lucy Heartfilia, who reveals that it\'s her dream to become a full-fledged wizard and join the Fairy Tail guild. After rescuing her from an abduction attempt, Natsu offers her a home in Fairy Tail. Now a member of the guild, Lucy teams up with Natsu and befriends fellow wizards Gray Fullbuster and Erza "Titania" Scarlet. Together, this motley crew set out on their many adventures, gaining many faithful allies and deadly foes along the way.'),
	(20, 'In a world full of magic, Asta—an orphan who is overly loud and energetic—possesses none whatsoever. Despite this, he dreams of becoming the Wizard King, a title bestowed upon the strongest mage in the Clover Kingdom. Possessing the same aspiration, Asta\'s childhood friend and rival Yuno has been blessed with the ability to control powerful wind magic. Even with this overwhelming gap between them, hoping to somehow awaken his magical abilities and catch up to Yuno, Asta trains his body relentlessly every day. In the Clover Kingdom, once a person turns 15 years old, it is time for them to receive their Grimoire, an item allowing its wielder to use their magic to its full capacity. At the ceremony, Yuno obtains a Grimoire with a legendary four-leaf clover, indicating the exceptional strength of its wielder, while Asta pointlessly waits for his. Feeling dejected, yet unwilling to give up, Asta sees Yuno caught by a mage who is trying to steal Yuno\'s special Grimoire. Despite being completely overpowered by Yuno\'s captor, Asta\'s will to keep fighting rewards him with his very own Grimoire—one with an unheard-of black five-leaf clover.'),
	(21, 'Shirakaba Yuki is a girl with the Catulus syndrome, which afflicts her with cat ears and a tail, plus some cat-like behavior. In the middle of her high school entrance ceremony, Ayano Riko—who is also a first year—comes in with a mountain of cats on her back. Apparently she\'s a cat magnet... Unexpectedly they become friends?'),
	(22, 'In a world of fantasy creatures and dreadful monsters, the Hunters Guild, a large agency of mercenaries, welcomes dangerous jobs of slaughtering the beasts for money. Though many rumors are spread about the greed of the hunters, no one can deny that the job always ends up being done. When a small hamlet is plagued by a man-eating werewolf amongst its citizens, the mayor hires a hunter to take it down. Grimm—the hunter who arrives—leaves the villagers in doubt due to her childlike appearance, but, as they have no alternative, they pray that she lives up to the guild\'s reputation. Velou, whose parents were eaten by a werewolf when he was young, wishes to join the hunt but is deemed too inexperienced. However, when tasked with guiding Grimm through the forests and eventually fighting the werewolf alongside her, he is invited to join the Hunters Guild. Though Velou finds the offer to exterminate werewolves enticing, he still worries about his hamlet. Grimm, intent on recruiting new hunters into the guild, decides to put his worries to rest.'),
	(23, 'Wakaba Asahina is a shy and slightly awkward girl. She is coerced by her classmates as a punishment game to confess to Haruto Iruma, the number one most hated boy in school. Though her relationship with Haruto starts out with an air of gloom for Wakaba, her depressing school life is dyed with color when she discovers that they share more in common than what she thinks.Wakaba Asahina is a shy and slightly awkward girl. She is coerced by her classmates as a punishment game to confess to Haruto Iruma, the number one most hated boy in school. Though her relationship with Haruto starts out with an air of gloom for Wakaba, her depressing school life is dyed with color when she discovers that they share more in common than what she thinks.'),
	(24, 'Hashiba Kyouya is a 28-year-old game developer. With his company going bankrupt, and him losing his job, he returns to his hometown. Looking at the success of creators of his age, he finds himself regretting his life decisions as he lay distressed on his bed. But when he opens his eyes, he finds that he has traveled 10 years back to the time before he entered college. Will he finally make things right? This is a story about a failed person who is given a second opportunity to follow his dreams.'),
	(25, 'Amanogawa Town is a peaceful country town, but now it\'s in crisis. Demons are attacking and are filling people\'s hearts with pain. Suddenly, a cute pretty girl dressed in a magical girl\'s costume appears. However, her true identity is a 88-year-old grandma!'),
	(26, 'A zombie panic breaks out in Tokyo, and a high school girl named Hino-chan, who is a part-timer, has to wait out till X-Day. Stuck in a convenience store and waiting to be rescued... . When all of a sudden, zombies have flooded the world. Will Hino-chan be able to excape from the convenience store before the food and supplies run out!?'),
	(27, 'Alice Amakawa was 10 years old when her mother and family servant left the house. Now 16 years old, Alice lives with only a small talking pet she calls Papi and one duty: to keep the house and the rest of Nemiki City away from the family pets—plushie-like but very destructive aliens known as Cosmofs. With this exhausting task and six long years of solitude, Alice hopes for nothing but her small family to return. On her birthday, Alice\'s monotonous life begins to change as she soon becomes a target of the Space Police due to her mother\'s connection to the Cosmofs as well as her own ability to hunt them. During her escape, the Cosmofs make one simple request that begins an adventure that transcends time, leaving Alice several years in the past where she meets a younger Raika Amakawa and her servant Imori. Alice is glad to see the family that she has long wished to see again, but as fate would have it, her happiness is not guaranteed to last...'),
	(28, 'When a mysterious light suddenly engulfs Earth, humanity is left petrified, frozen in stone. Thousands of years later, the world is teeming with vegetation, and forests have taken the places of cities that once stood proudly. One of the very first to emerge from their stone prison is Taiju Ooki, who finds that his good friend, a brilliant young scientist named Senkuu, has been preparing for his awakening. While Taiju wishes to save the girl he loves, Senkuu is determined to figure out the cause behind the strange phenomenon and restore the world to its former glory. But when they free the infamously powerful Tsukasa Shishiou in order to gain an upper hand against the dangers in an unfamiliar world, they realize that their new comrade has other plans. Tsukasa sees their predicament as a chance to start over; free from the corruption and destruction wrought by technology, he will stop at nothing to achieve his goals. With both sides unable to see eye to eye, Senkuu and his devotion to science will clash with Tsukasa and his primal nature in what will truly be a battle of the ages.'),
	(29, 'The orphan Ren was riding the carriage after being sold, when she got involved into an accident, and got her previous life\'s memories back! "I was... a middle-aged man!" Indeed, she was a researcher in his thirties in her previous life, and had been living as an orphan girl up to now! Ren will make use of her talents in magic and knowledge in science to survive in this harsh world in order to escape from the investor who bought her!'),
	(30, 'Ordinary office worker Rei Oohashi wakes up one day to find herself as Rae Taylor, the heroine of her favorite otome game, Revolution. Surrounded by attractive men all vying for her attention would be any maiden\'s dream—but that is not the case for Rae! None of them can hold a candle to the villainess, Claire François, whose blonde, drill-shaped ringlets only accentuate her haughty irresistible charm. In the original story, Claire harasses and bullies the heroine, which drives the latter closer to the male love interests. But Rae has no intention of pursuing any of the men; her heart is set on Claire herself! Unused to being on the receiving end of affection, Claire is left at the mercy of Rae\'s endless teasing. With the power of true love, can Rae successfully convey her heartfelt feelings to the villainess?'),
	(31, 'Considered a genius due to having the highest grades in the country, Miyuki Shirogane leads the prestigious Shuchiin Academy\'s student council as its president, working alongside the beautiful and wealthy vice president Kaguya Shinomiya. The two are often regarded as the perfect couple by students despite them not being in any sort of romantic relationship. However, the truth is that after spending so much time together, the two have developed feelings for one another; unfortunately, neither is willing to confess, as doing so would be a sign of weakness. With their pride as elite students on the line, Miyuki and Kaguya embark on a quest to do whatever is necessary to get a confession out of the other. Through their daily antics, the battle of love begins!'),
	(32, 'Catarina Claes is the eight-year-old daughter of a duke. One day, she hits her head and recovers the memories of her past life, and she comes a horrifying realization—she is in a world similar to that of an otome game she once played, and she is the main villain! To make matters worse, in every possible conclusion, whether exile or death, she is met with a terrible end. Using her knowledge of how the game unfolds, Catarina must now do whatever it takes to change her fate. Whether she must cultivate her skills as a farmer or befriend every character that comes her way, nothing is ever too much for her to handle. As the years go on, everything seems to be going as planned. However, Catarina realizes that she made a mistake in her previous life, as she never actually finished the game before death; and so a new, secret route may just prove to be her undoing.'),
	(33, 'Hiiragi Utena has always looked up to magical girls and fantasized about transforming into a cool heroine who fights evil. So, when a doll-like figure approaches her one evening, claiming that she has magical power lying dormant within, she trembles in excitement. But her colorful dream is quickly shattered in an ironic turn of events when she transforms into a villain! Disinterested in associating with the forces of evil, she tries to quit when a group of magical girls appear and declare war. A battle ensues and Hiiragi soon discovers that she enjoys inflicting pain on others as her true nature starts to emerge. Mahou Shoujo ni Akogarete follows Hiiragi as she begins her new life as the leader of villains, fighting against magical girls and indulging in her newfound sadistic nature to her heart\'s content.'),
	(34, 'Somehow, when I woke up in the morning... I found myself in a strange world with a strange girl?! This is definitely Different World Summoning!! It\'s the Beginning of My Exciting Adventurer Life... I thought But... "I couldn\'t speak a single word!" The summoner is a cute demon lord (maybe)?! We use gestures because we don\'t understand each other\'s language in an isekai communication love comedy!!'),
	(35, 'Miko Yotsuya is a typical high school student whose life turns upside down when she suddenly starts to see gruesome and hideous monsters. Despite being completely terrified, Miko carries on with her daily life, pretending not to notice the horrors that surround her. She must endure the fear in order to keep herself and her friend Hana Yurikawa out of danger, even if that means coming face to face with the absolute worst. Blending both comedy and horror, Mieruko-chan tells the story of a girl who tries to deal with the paranormal by acting indifferent toward it.'),
	(36, 'Normal high school girl Irie Yuunagi suddenly has her blood sucked by a strange man one night. Yuunagi wakes up as a vampire and learns that she has been added to the man who bit her, Rin\'s, family. She begins to learn about the rules of the vampire world from Rin.'),
	(37, 'When a mysterious explosion killed an entire class full of high school students, the souls of everyone in class was transported into a fantasy world and reincarnated. While some students were reincarnated as princes or prodigies, others were not as blessed. Our heroine, who was the lowest in the class, discovered that she was reincarnated as a spider!? Now at the bottom of the food chain, she needs to adapts to the current situation with willpower in order to live! Stuck in a dangerous labyrinth filled with monsters, it\'s eat or be eaten! This is the story of a spider doing whatever she can in order to survive!'),
	(38, 'The demon king has been defeated, and the victorious hero party returns home before disbanding. The four—mage Frieren, hero Himmel, priest Heiter, and warrior Eisen—reminisce about their decade-long journey as the moment to bid each other farewell arrives. But the passing of time is different for elves, thus Frieren witnesses her companions slowly pass away one by one. Before his death, Heiter manages to foist a young human apprentice called Fern onto Frieren. Driven by the elf\'s passion for collecting a myriad of magic spells, the pair embarks on a seemingly aimless journey, revisiting the places that the heroes of yore had visited. Along their travels, Frieren slowly confronts her regrets of missed opportunities to form deeper bonds with her now-deceased comrades.'),
	(39, 'Pure Azurite is a "cool blue" magical knight. Problem is, she doesn\'t really like being one.'),
	(40, 'In one of the worlds that exist within virtual reality, Kagami held the title of one of the Nine Sages, a position that placed him at the pinnacle of magicians. One day, he fell asleep in-game after pulling an all-nighter. When he opened his eyes, what he found was a world that was different to the one before... More important than anything else, was that the grizzled and dignified veteran\'s body that he was used to, had now turned into an innocent little girl\'s. If his true identity was leaked, honestly speaking it was a situation where it was very possible that the solemn image he had built up until now would be destroyed. And to deal with this problem, the excuse that he came up with was...'),
	(41, 'In an imperial court in ancient China, it has been a few months since a 17-year-old girl known as Maomao was kidnapped and forced to work as a low-level servant at the emperor\'s palace. Still, she manages to retain her curious and pragmatic spirit, planning to work until her years of servitude are over. One day, however, she catches wind of the fact that the emperor\'s two infants have fallen gravely ill. She decides to secretly take action, drawing on her experience as a pharmacist raised in the poor red-light district. Despite Maomao\'s attempts to remain anonymous, she soon catches the eye of Jinshi, an influential eunuch who recognizes her talents. Maomao soon finds herself in the emperor\'s inner court, where she gradually makes a name for herself by utilizing her knowledge and eccentric personality to solve various medical mysteries.'),
	(42, 'Mahiro Oyama was just a normal erotic-game loving dude...until he woke up one morning as a woman! Turns out his mad-scientist little sister, Mihari, tried out one of her new experiments on him... with a disastrous outcome, as far as Mahiro\'s concerned! But Mihari is as determined to study him as he is determined to go back to his shut-in, game-playing life, and one thing\'s for sure... life is going to get a whole lot weirder from here on out'),
	(43, 'Utilizing a system called "Sense," each player aims to create their unique character in the VRMMORPG "Only Sense Online." Joining this realm is Yun, an absolute beginner in the world of gaming, equipped with some of the worst customized "Sense" ever. While his two sisters, both veterans in this world, criticize his choices of equipment, he continues to delve into the skill sets he has acquired. Along his way, he meets the art of "production" and people that have mastered this art. Watch as a total novice creates a revolution in the gaming world and create the "ultimate" support class.'),
	(44, 'Yggdrasil is a virtual reality game renowned for the freedom it offers its players. After a simple tutorial, players are left to explore the world and can customize anything and everything, from their classes to their weapons. However, in the year 2138, the game sees its final hours as its servers shut down at midnight. Momonga, a devoted player of Yggdrasil, decides to spend the game\'s last hours inside his guild, Ainz Ooal Gown. Strangely, at the stroke of midnight, the game does not log him out. Instead, Momonga finds himself transported to another world, one that is seemingly identical to that of Yggdrasil. Facing an already abnormal situation, he discovers that the NPCs have gained sentience. Trapped in his avatar\'s skeletal body and desperate to uncover the cause of his predicament and find other players like him, Momonga sets out to take control of the new world with the help of his loyal subjects.'),
	(45, 'Second-year high school student Yatora Yaguchi is bored with his normal life. He studies well and plays around with his friends, but in truth, he does not enjoy either of those activities. Bound by norms, he secretly envies those who do things differently. That is until he discovers the joy of drawing. When he sees a painting made by a member of the Art Club, Yatora becomes fascinated with the colors used in it. Later, in an art exercise, he tries to convey his language without words but instead through painting. After that experience, Yatora finds himself so invested in art that he decides that it is what he wants to do for a living. But there stand multiple obstacles in his way: his parents who are hesitant over his unique choices, his more experienced peers, and the study of a subject much deeper than he initially expected.'),
	(46, 'Takuto Ira succumbed to illness at a young age and ended up reincarnating in a world that resembled the strategy simulation game, "Eternal Nations," which he loved playing when he was alive. What appeared in front of him was Atou, a girl belonging to the evil civilization that he used to play as, "Mynoghra." The two of them decided to create a new country in this world once again.'),
	(47, 'In her first life, she was obsessed with the "Arachnea," a spider-like race in the video game she adored. As an evil-aligned faction, they sought nothing but victory; the more they conquered, the more they grew, using the bodies of their enemies as fuel to multiply and expand the ever-growing swarm. When she awakens, she is in a body younger than her former one and finds herself surrounded by the Arachnea, who call her "Her Majesty." She soon realizes that she too is connected to the hivemind, and her precious Arachnea still wish for victory—over who and for what ends, that is unclear, but their lust to win is undeniable. To fulfill their desires, she leads the Arachnea, destroying all who are vile in the world. From the religious zealots who murder those unlike them, to the immoral slavers who deal in the lives of others, none are free from her path of carnage. You can plead, weep, or beg, but she has no mercy—the swarm of the Arachnea lives only for victory and to serve Her Majesty.'),
	(48, 'The Abyss, a hole of unprecedented depth—one young girl and a robot brave its dangers to find the truth. The town of Orth is a special one, as it is built around the edges of the massive Abyss, a wonder which has never been fully explored. Those who venture too far down never return, but those brave enough to traverse its territories are known as "Cave Raiders" and are heralded as legends. Within this town lives a young girl called Riko, the child of one of the most famous Cave Raiders of all time who disappeared on an expedition many years ago. One day, Riko\'s life changes when she meets a strange robot called Reg, who seems to appear from within the Abyss. Believing this to be a sign from her mother stuck at the bottom of the Abyss, Riko descends into its depths with Reg, ready to confront all the dangers within it.'),
	(49, 'Thorfinn, son of one of the Vikings\' greatest warriors, is among the finest fighters in the merry band of mercenaries run by the cunning Askeladd, an impressive feat for a person his age. However, Thorfinn is not part of the group for the plunder it entails—instead, for having caused his family great tragedy, the boy has vowed to kill Askeladd in a fair duel. Not yet skilled enough to defeat him, but unable to abandon his vengeance, Thorfinn spends his boyhood with the mercenary crew, honing his skills on the battlefield among the war-loving Danes, where killing is just another pleasure of life. One day, when Askeladd receives word that Danish prince Canute has been taken hostage, he hatches an ambitious plot—one that will decide the next King of England and drastically alter the lives of Thorfinn, Canute, and himself. Set in 11th-century Europe, Vinland Saga tells a bloody epic in an era where violence, madness, and injustice are inescapable, providing a paradise for the battle-crazed and utter hell for the rest who live in it.'),
	(50, 'Receiving funding from the government to nurture the next generation\'s hopefuls, Tokyo Metropolitan Advanced Nurturing High School brings together the brightest youth of Japan onto a single campus. At this seemingly perfect institution, the reserved Kiyotaka Ayanokouji arrives as an incoming member of class 1-D, where he befriends one of his classmates, the antisocial Suzune Horikita. At first, his peers revel in the academy\'s leisurely lifestyle, taking advantage of all of its state-of-the-art facilities. Soon enough, however, the facade of Tokyo Metropolitan Advanced Nurturing High School gives way to its true nature—only the top scoring classes can fully utilize the school\'s offerings, and Class D is the furthest from such a status. Standing at the bottom of the hierarchy, Class D houses all of the school\'s "worst" students. Following this rude awakening, Ayanokouji, Horikita, and the rest of Class D must overcome their differences and clash against other classes in order to climb to the coveted position of Class A by any means necessary.'),
	(51, 'As the students of Class 1-5 introduce themselves at the beginning of their high school careers, the cynical but otherwise fairly ordinary boy known as Kyon sits down, having just finished his piece. However, when the girl sitting behind him stands up to give her speech, the words she utters dumbfound the entire class. Proclaiming that she has no interest in ordinary humans and is in search of the supernatural, Haruhi Suzumiya makes her unforgettable debut. Doubting Haruhi\'s sincerity, Kyon lets his curiosity get the better of him and attempts to befriend her in spite of his classmates\' warnings. Unfortunately, as the eccentric girl slowly opens up to him, Kyon realizes she is dead serious. Moreover, a conversation between the two sparks a dangerous idea in Haruhi\'s mind: since she is bored with the mundanity of the school\'s clubs, she should just create her own. With this, the SOS Brigade is born, and Kyon is quickly dragged into a life of absurdity. Taking over the Literary Club\'s room, Haruhi soon enlists three new members into her organization: the stoic Yuki Nagato, the timid Mikuru Asahina, and the supposedly mysterious transfer student Itsuki Koizumi. Having thrown together this group of students, Haruhi drags the squad around on adventures in search of the exciting and supernatural, much to Kyon\'s chagrin. However, he soon discovers that there is more to the new recruits than meets the eye, and that which Haruhi wishes for may be much closer than she realizes...'),
	(52, 'Sixteen-year-old Ai Hoshino is a talented and beautiful idol who is adored by her fans. She is the personification of a pure, young maiden. But all that glitters is not gold. Gorou Amemiya is a countryside gynecologist and a big fan of Ai. So when the pregnant idol shows up at his hospital, he is beyond bewildered. Gorou promises her a safe delivery. Little does he know, an encounter with a mysterious figure would result in his untimely death—or so he thought. Opening his eyes in the lap of his beloved idol, Gorou finds that he has been reborn as Aquamarine Hoshino—Ai\'s newborn son! With his world turned upside down, Gorou soon learns that the world of showbiz is paved with thorns, where talent does not always beget success. Will he manage to protect Ai\'s smile that he loves so much with the help of an eccentric and unexpected ally?'),
	(53, 'Lonely thirty-seven-year-old Satoru Mikami is stuck in a dead-end job, unhappy with his mundane life, but after dying at the hands of a robber, he awakens to a fresh start in a fantasy realm...as a slime monster! As he acclimates to his goopy new existence, his exploits with the other monsters set off a chain of events that will change his new world forever!'),
	(54, 'The story of Steins;Gate takes place in Akihabara and is about a group of friends who have managed to customize their microwave into a device that can send text messages to the past. As they perform different experiments, an organization named SERN who has been doing their own research on time travel tracks them down and now the characters have to find a way to avoid being captured by them.'),
	(55, 'After reflecting on the current state of Japanese soccer, the Japanese Football Association decides to hire the enigmatic and eccentric coach Jinpachi Ego to achieve their dream of winning the World Cup. Believing that Japan has lacked an egoistic striker hungry for goals, Jinpachi initiates the Blue Lock—a prison-like facility where three hundred talented strikers from high schools all over Japan are isolated and pitted against each other. The sole survivor of Blue Lock will earn the right to become the national team\'s striker, and those who are defeated shall be banned from joining the team forever. Selected to join this risky project is Yoichi Isagi, a striker who failed to bring his high school soccer team to the national tournament. After choosing to pass to a teammate who missed instead of scoring on his own, he could not help but wonder if the results would have been different had he been more selfish. Using this golden opportunity given by the Blue Lock Project, Yoichi aims to clear his doubts and chase his ultimate desire—to become the greatest striker in the world and lead Japan to World Cup glory.'),
	(56, 'As the conflict between Kenji Endo, his childhood friends, and cult leader "Friend" comes to an end, two mysteries remain—Friend\'s true identity and whether the threat of an "anti-photon bomb" before his death was legitimate. Hoping to find an answer, Kenji, alongside the United Nations, decides to use a virtual reality program created from Friend\'s childhood memories in this conclusion to a long journey that will span dozens of decades.'),
	(57, 'Tucked away in the English countryside lies the ominous manor of the Phantomhives, a family which has established itself as the cold and ruthless "Queen\'s Watchdog" as well as the head of London\'s criminal underground. After a tragedy leaves the Earl and his wife dead, many are shocked when their son, a young boy named Ciel, claims his place as the new Earl of the Phantomhive house. At first, many perceive him only as a child surrounded by a few eccentric servants. But they soon begin to realize that it is foolish to meddle with Ciel and his demonic butler Sebastian. Taking place at the end of the 19th century, Kuroshitsuji follows these two as they face countless mysteries and dangers that plague England and threaten the Queen, uncovering the truth about what really happened to Ciel\'s parents in the process.'),
	(58, 'Adachi and Shimamura, two young women who attend the same high school, are inseparable friends. Whether playing table tennis, chatting about favorite TV shows, or just relaxing together, they\'re happy to share their days. When Adachi\'s friendship turns into romantic attraction, the relationship begins to change, one day at a time.'),
	(59, 'Emilico is just one of many "Living Dolls" serving in the Shadows House, residents of which are pitch black from head to toe and constantly leak soot that stains the house black. Each "Shadow" is partnered with a Doll, which strangely resembles the other. As a Living Doll, Emilico must keep the house sparkling clean as well as act as the face for her master, Kate. In turn, Kate supports Emilico and treats her as her confidant. As far as either of them can remember, this has always been the way their world works. However, the bond between a Shadow and a Doll isn\'t quite clear. Administrators watch over the young pairs from the higher levels of the mansion and judge them—but for what purpose?'),
	(60, 'For centuries, many secret organizations have taken part in exterminating various types of dangerous monsters. One of them is the England-based Hellsing, run by its cunning leader, Sir Integra Fairbrook Wingates Hellsing. Her greatest hunter, and trump card, is Alucard, an unbeatable vampire genetically modified by her father. Despite him being one of "them," he swore to be her protector and servant. A new crisis begins and with the help of Seras Victoria, his recently turned vampire partner, Alucard has to uncover the truth behind the mysterious vampire attacks. Not every human is bound to be his ally in this battle, and he will not hesitate to kill anyone who stands in his way.'),
	(61, 'In a world populated by anthropomorphic animals, there exists a bias: carnivores are just mindless predators in the eyes of many herbivores. However, when an alpaca named Tem is murdered within the walls of Cherryton High School, the fear toward carnivores skyrockets to an all-time high. Legoshi, a student at this school, is a gray wolf who is quite awkward despite his fearsome appearance. When turmoil affects his school life, he is forced to confront the divide between herbivores and carnivores, as well as his own place in this society. This is further complicated by his supposedly romantic feelings toward a herbivore, which might not be what they seem. Beastars details Legoshi\'s struggles against his inner demons while living in a society that is unforgiving toward his kind.'),
	(62, 'Fourteen years ago, mysterious buildings called "Dungeons" started to rise in various places around the world. Within these dungeons, powerful beings called djinns rule over. When a person successfully conquers the dungeon, the djinn offers their immense strength in the form of Metal Vessels, recognizing him or her as a worthy king candidate. Adventurers from many empires and kingdoms venture into the dungeons in search of their bountiful treasures and the power of djinns. However, to travel through them is not an easy task, and only Magi—legendary magicians who choose kings and develop countries—can guide people through. After being trapped in a room for most of his life, a young Magi named Aladdin finally sets out on a journey to explore the world along with his friend, a djinn named Ugo, who he can summon from his flute. Through a series of fateful encounters, Aladdin meets new various friends and allies, and together they begin an adventure that will change the fate of the world.'),
	(63, 'One morning, fifteen-year-old Yuuko Yoshida wakes up to discover she has sprouted demon horns and a tail! Not only that, she learns from her mom that she has supernatural powers and an important mission—to restore her family\'s glory by defeating the local magical girl. The magical girl in question is Momo Chiyoda, a student at Yuuko\'s school. With strength that is only mediocre at best, Yuuko\'s task to vanquish Momo will prove more challenging than she realizes in this topsy-turvy magical girl comedy.'),
	(64, 'In the blink of an eye, the night sky is forever changed when, with a great explosion, the moon is blasted into a permanent crescent. Confronting the governments of the world, a yellow tentacled monster boasts that it was the one responsible for the catastrophe, and in a year\'s time, it will do the same to Earth. Zooming around at Mach 20, the creature makes a peculiar demand: a teaching position at the prestigious Kunugigaoka Junior High School. Desperate to keep the creature in one place, the government agrees, and so the students of Class 3-E find themselves faced with an impossible task—assassinate the creature responsible for destroying the moon. Although the fate of the world now rests on their shoulders, the class has more personal issues to deal with. Trapped at the bottom of Kunugigaoka\'s hierarchical education system, they face harsh discrimination from both teachers and students alike. Defeatism abound, they don\'t believe themselves capable of success in daily life, let alone against a monster that surpasses the abilities of any human. But as the enigmatic creature—whom they dub Koro-sensei—educates them in both assassination and academia, the children slowly find the courage to rise up and take aim at their target: the greatest teacher the world has ever seen.'),
	(65, 'Takasu Ryuuji might look like a thug, but he\'s actually a nice guy. Making friends when you\'ve got an unintentionally scary face is tough—and don\'t even get him started on girlfriends. But with his secret crush in his class, the start of his second year of high school is off to a good start...until he crosses paths with Aisaka Taiga. Beautiful, frightening, and not quite five feet tall, the girl known as the Palmtop Tiger is the one person in school even scarier than Ryuuji himself—and he\'s just made the mistake of making her very, very angry.'),
	(66, 'It\'s Shouko Komi\'s first day at the prestigious Itan Private High School, and she has already risen to the status of the school\'s Madonna. With long black hair and a tall, graceful appearance, she captures the attention of anyone who comes across her. There\'s just one problem though—despite her popularity, Shouko is terrible at communicating with others. Hitohito Tadano is your average high school boy. With his life motto of "read the situation and make sure to stay away from trouble," he quickly finds that sitting next to Shouko has made him the enemy of everyone in his class! One day, knocked out by accident, Hitohito later wakes up to the sound of Shouko\'s "meow." He lies that he heard nothing, causing Shouko to run away. But before she can escape, Hitohito surmises that Shouko is not able to talk to others easily—in fact, she has never been able to make a single friend. Hitohito resolves to help Shouko with her goal of making one hundred friends so that she can overcome her communication disorder.'),
	(67, '"Immortal Tatsu," the legendary yakuza who single-handedly defeated a rival gang with a lead pipe, is a name known to strike fear in both hardened police officers and vicious criminals. Soon after his sudden disappearance, he resurfaces with a slight change in profession. Now equipped with an apron, Tatsu has given up violence and is trying to make an honest living as a house husband. While adapting to mundane household tasks, Tatsu finds that being a house husband has its own challenges, from the battlefield known as supermarket sales to failures in the kitchen. Despite living peacefully, misunderstandings seem to follow him left and right. Gokushufudou follows the daily life of the comically serious ex-yakuza as he leaves behind his dangerous previous life to become a stay-at-home husband.'),
	(68, 'Although Elaina spends her free time reading various works, one particular book stands out from the rest: The Adventures of Nike—a short collection of stories recounting the exhilarating undertakings of a traveling witch. Inspired by Nike\'s fascinating journey, Elaina wishes to follow in her footsteps and explore the world herself. After Elaina announces her dreams to her family, they set but one condition: Elaina must become a capable witch like Nike. Fueled by her desire to venture into the unknown, Elaina becomes the youngest girl to achieve the title of Apprentice Witch and subsequently advances to a full-fledged witch. Now dubbed the Ashen Witch—thanks to her unique silver hair—Elaina leaves her home and sets out on her own journey. She soon visits all sorts of mysterious and fascinating countries, meets and befriends a range of personalities, and most importantly, fulfills her lifelong quench for exploration.'),
	(69, 'Kou Yamori seems like a typical middle school student on the surface. Relatively good at studies and amiable with his classmates, he puts a lot of effort into maintaining this facade. One day, however, he decides to stop pretending and quits school, developing insomnia as a result of having no daytime outlet for his energy. When taking walks alone at night, he feels marginally better, though he is aware that his inability to sleep should be considered a serious problem. On one such walk, Kou meets a weird girl, Nazuna Nanakusa, who diagnoses the cause of his sleeplessness: despite making changes in his life, he is still holding himself back from experiencing true freedom. She says that he won\'t be able to sleep unless he is satisfied with how he spends his waking hours. When it appears that she has resolved his current worries, Nazuna invites him back to her apartment to share her futon. After a while, unaware that he is only feigning unconsciousness, she leans over him—and bites his neck!'),
	(70, 'Sorata Kanda, an amicable student enrolled at Suimei High School, is evicted out of the student dorms for adopting a stray cat. Having his kindness backfire on him, he ends up at the notorious "Sakura Hall," where he meets its residents—a cast of eccentric, artistic prodigies. Stuck with an increasing number of stray cats in addition to being average amongst geniuses, Sorata is determined to find new owners for these cats and leave Sakura Hall for good. Shortly after moving in, his life is further thrown into disarray as he is tasked with taking care of Mashiro Shiina, a new transfer student and aspiring manga author. Despite being a world-renowned artist, she lacks common sense and is utterly incapable of looking out for herself. With the support of their fellow Sakura Hall residents, Sorata and Mashiro grow ever closer as they weave through the webs of expectations and determine their self-worth, striving to discover their true calling in life.'),
	(71, 'Stories of old tell of four otherworldly heroes—wielding the sword, spear, bow, and shield—who defended the land from wave after wave of calamity. With the fate of the world in balance, the kingdom of Melromarc summons these legendary figures; in modern-day Japan, the call is answered, and the unwitting heroes are transported to this fantasy universe. Thrust into Melromarc and given the title of "Shield Hero," otaku Naofumi Iwatani is labeled the weakest due to his lack of offensive capability and apparent inexperience. When the heroes part ways to start their journeys, he only has one willing companion: the beautiful princess Malty Melromarc. However, she soon betrays him, steals all his money, and accuses him of taking advantage of her. For his alleged crimes, Naofumi is branded a criminal and made outcast of society. With hatred filling his heart, he sets out alone, vowing vengeance against those who wronged him.'),
	(72, 'For Kobayashi, every workday is the same tiring routine, followed by a night of drinking with coworkers to let herself loose. However, her stale life changes one morning when she is greeted at her front door by the huge face of a dragon. Introducing herself as Tooru, the dragon transforms into a young woman in a maid outfit. Having met Kobayashi drunk in the mountains the night before, she accepts Kobayashi\'s invitation to live with her as her personal housemaid. Kobayashi-san Chi no Maid Dragon follows the daily life of Kobayashi, her dragon maid Tooru, and various other dragons as they move past their differences to grow closer together.'),
	(73, 'Kazuma Satou is a reserved 16-year-old who loses his life in a tragic yet laughable accident. After his untimely death, Kazuma finds himself standing before Aqua—the self-proclaimed water goddess who presents him two with choices: to ascend to heaven or reincarnate in a real fantasy world. Picking the latter, Kazuma gets tasked with defeating the Demon King, an occurring threat in his new world. However, Aqua\'s provocative attitude strikes a nerve, and in the heat of the moment, Kazuma takes her along. Kazuma and Aqua, now stuck together in another world, embark on a journey. They soon acquire two more companions: Megumin, an archwizard wielding devastating explosion magic; and Lalatina "Darkness" Dustiness Ford, a crusader with a worrisome case of masochism. The four of them form an odd party, each member contributing their unique share of power and a peculiar personality. Unfortunately, their adventure soon proves to be challenging and costly, Kazuma\'s new life may be nothing but a headache.'),
	(74, 'The story revolves around Ken, a man from an upper-class family that was orphaned young due to his family\'s involvement with the Yakuza; he became a high school delinquent known for fighting. The only thing that motivates him to take action is through his romantic affections for a classmate, Yumi. After learning she decided to move to Korea to become a police officer, Ken leaves his life in Japan behind and tries to follow in Yumi\'s footsteps; due to unforeseen circumstances, he incidentally becomes the head of a local gang and tries to hide it from Yumi. As the leader, the gang is renamed the Sun-Ken Rock Group.'),
	(75, 'Shintarou Kisaragi—a NEET who shut himself inside his room for two years—had been living his life normally until he met a cyber girl named Ene, who appeared in his computer screen when someone anonymously sent him a mysterious e-mail one year ago. One day, Ene messes with Shintarou\'s PC, which forces him to go to the outside world for the first time in two years.'),
	(76, 'After a fight with his foster father Shirou Fujimoto, Rin Okumura\'s life is transformed overnight when Rin is revealed to be the son of the demon lord Satan, king of the demonic realm of Gehenna. Soon after, his foster father becomes possessed and dies at the hands of Satan, leaving Rin and his twin brother Yukio alone in the world. Seeking revenge for Fujimoto\'s death, Rin attends True Cross Academy with Yukio in order to become an exorcist and join the Knights of the True Cross. Rin\'s new path, however, is filled with many difficulties. While new classes and dealing with his peers are already troublesome enough, he is also forced to conceal his newfound demonic powers and parentage. In addition, plenty of evildoers want to use him for their own ends. One misstep could lead to disaster, as not everyone at True Cross Academy is exactly who they seem to be...'),
	(77, 'Misaki Hayato returns to his hometown and enrolls in the same high school as his two childhood friends. A lot has changed in the years he has been gone, his former best friends are seemingly distant from each other and leading relatively normal high school lives. Hayato\'s sudden arrival soon changes that and sends shockwaves through the entire town\'s delinquent population with his willingness to do anything for his friends and his love for a good fight.'),
	(78, 'When eating a chocolate cornet, which end do you begin with, the top or the bottom? Which side is the top and which is the bottom? For that matter, what is a chocolate cornet? The proper way to eat pastries is only one of the many everyday occurrences explored by the girls of Ms. Kuroi\'s class. Meet Konata, an athletic and intelligent girl too dedicated to her favorite primetime anime to excel in anything but otaku culture; Miyuki, the cute, bespectacled living example of moe with an encyclopedic knowledge of all subjects; Kagami, the bitter-sweet, tough but shy straight-man to Konata\'s constant teasing and pranks; and her younger fraternal twin sister, Tsukasa, a kind but air-headed klutz. Witness this study in the human condition as our heroines explore the unexplored in questioning the ordinary!'),
	(79, 'Killed while saving a stranger from a traffic collision, a 34-year-old NEET is reincarnated into a world of magic as Rudeus Greyrat, a newborn baby. With knowledge, experience, and regrets from his previous life retained, Rudeus vows to lead a fulfilling life and not repeat his past mistakes. Now gifted with a tremendous amount of magical power as well as the mind of a grown adult, Rudeus is seen as a genius in the making by his new parents. Soon, he finds himself studying under powerful warriors, such as his swordsman father and a mage named Roxy Migurdia—all in order to hone his apparent talents. But despite his innocent exterior, Rudeus is still a perverted otaku, who uses his wealth of knowledge to make moves on women whom he could never make in his previous life.'),
	(80, 'The everyday life of Nakano, a salaryman working for an exploitative company, is suddenly intruded upon by the fox, Senko-san (800-year-old little girl). Whether it be cooking, cleaning, or special service(?)... she\'ll heal his exhaustion with her tender "care."'),
	(81, 'With the space program attempting to travel to Mars, 21st century scientists were tasked with warming up the planet so that humans could survive on its surface. They came up with an efficient and cost effective plan of sending cockroaches and mold to the surface so that the mold would absorb the sunlight and the insect corpses would serve as a food source for the mold. It is now the year 2577 and the first manned ship to Mars has landed on the planet and the six crew members are ready for their mission. But what they find are giant mutated humanoid cockroaches with incredible physical strength. The crew members are easily wiped out, but not before sending a transmission back to Earth. Now, humanity will send elite warriors to exterminate the mutated bugs and claim back Mars.'),
	(82, 'Most would call the Levantret territory a frozen wasteland. The sun does not shine for half of the year, and even when it does, the inhabitants must still endure the frigid cold. Even so, what Levantret does have is a boundless sky, spanned by the ethereal Northern Lights. The local lord, Ritzhardt "Ritz" Salonen Levantret, loves his homeland more than anyone else. He is in search of a wife, but few women are willing to give up their lives of luxury and move out to the boonies. High society calls him the "Yeti of the Borderlands" and looks down on his simple lifestyle. At a dinner party, Ritz is enraptured by the decorated lady-knight Sieglinde "Sieg" von Wettin and immediately asks to marry her. To the surprise of most, she accepts a "trial marriage" of one year. For Sieg, this is a chance to discover what it means to be a "wife" after spending the majority of her life in the military. On the other hand, Ritz wants to show her everything his beloved home has to offer. In the wintry Levantret, from hunting in the blistering cold to handicrafts around the cozy hearth, every day is filled with new and warm memories.'),
	(83, 'The hero\'s son and the ghost of the Demon King are the master and pupil!? Eirth, the son of the hero who defeated the Great Demon King, is troubled. Always expected to achieve great things, but unable to meet those expectations. No matter the effort he puts in, and the results he obtains, it\'s never enough for them. "I\'m a disappointment compared to my father" or "Don\'t you know you\'re the son of the hero!!" Living every day like this, Eirth meets his destiny in the room containing the sword of his father, the hero. "Interesting. I will train you. I have only free time now." Eirth receives special personal training from the Demon King just to get back at his parents and the world. In the coming days, his parents, the heroes of the past, his first love, the princess childhood friend, the geniuses of the era, and the world will tremble before him.'),
	(84, 'A young priestess has formed her first adventuring party, but almost immediately they find themselves in distress. It\'s the Goblin Slayer who comes to their rescue—a man who\'s dedicated his life to the extermination of all goblins, by any means necessary. And when rumors of his feats begin to circulate, there\'s no telling who might come calling next...'),
	(85, 'Five years have passed since the tragic incident ended the peaceful life on Regul Aire once and for all. The Beast have reached the floating island and are threatening the last survivors. Tiat, Collon, Pannibal, and Lakhesh have become fairy soldiers and are continuing the role of their predecessors, fighting for the safety of Regul Aire. And just like all the other fairy soldiers of the warehouse, they need a guardian of the military, and so on one fateful day, Tiat encounters Feodor Jessman, a young imp and fourth-grade military officer. At the first glance he appears like a typical honor student, however, it\'s not for long until he reveals his true colors. What will his secret ambitions bring for the four young girls and even the future of Regul Aire?'),
	(86, 'One day in the 21st century, a gate opened in the middle of the Ginza district of Tokyo. Out of the gate poured soldiers and strange creatures, and they soon made Ginza look like an image of hell. The gate apparently connected Japan to another world, a world with a militant empire and many supernatural creatures. The Japanese Self-Defense Force decided to send a small group, led by a soldier who\'s also an otaku, into the other world on a reconnaissance mission. They\'re meant to learn what they can about the empire (and its plans), the world, and the people. They\'re hardly in the world yet, though, when they come across a village destroyed by a giant fire-breathing dragon. The only survivor is an unconscious elven girl they find hidden in a well. Now they feel like they must warn the nearby towns about the dragon, and do what they can to help. On the way, they\'ll meet more magical, female companions, and learn more about this dangerous new world.'),
	(87, 'The ruthless Minister Honest exploits the ignorance of a new young Emperor and deviously rules the country from the shadows with twisted morals and no regard for human life. As a result of this, an epidemic of crime and corruption has spread throughout the country\'s capital city, and a state of society ensues where the privileged have absolute domination over the lesser. However, there exists an organization to combat this rife abuse of power: Night Raid, a secret division of the oppositionary Revolutionary Army. It is composed of a small team of ruthless assassins who murder all those who partake in or turn a blind eye to the Empire\'s outrageous wrongdoings. Tatsumi is a naïve, sword-wielding young man on a journey to save his impoverished village. Soon, he witnesses the bloody horrors and cruelty of the capital firsthand. Overcome with hatred, Tatsumi is swayed by Night Raid\'s profound cause and decides to join them, embarking on a painful and dangerous mission to exact revenge on Minister Honest. Tatsumi gains many invaluable experiences as he unravels the ethics of conflicting ideologies, life and death, all while working toward the restoration of a humane world.'),
	(88, 'The secret hidden in Mikaela\'s name. The deadly fight with the "human" Crowley, and the encounter with Ferid. The story will uncover their travels. A shocking new series that will move closer to the truth and origin of vampires!'),
	(89, 'William is the lone human in a city of the dead. Born with vague memories of a past life in contemporary Japan where he failed to do anything useful, he is determined not to make the same mistake again, and that this time, his life will be lived. But what does that really mean? Raised by a group of the undead, William must discover what circumstances brought him to this city and these people as well as what it means to not just exist, but to live a full life.'),
	(90, '​Seventeen years ago, Takafumi\'s uncle fell into a coma, but now he\'s back like a man risen from his grave. Soon, Takafumi discovers two bizarre things: His uncle treasures video games above all else, and, while comatose, he was actually transported to another world as some heroic guardian! Now, not only does Takafumi have to room with an uncle who is literally magical, he also has to catch the guy up on two decades of history—smartphones, high-speed internet, modern anime tropes...and the traumatic outcome of the \'90s console war!'),
	(91, '"God, even if I\'m reincarnated, please let me keep reading lots of books..." This was the dying wish of Urano Motosu, a university student who loved to read books, no matter the genre or type. She treasured books to such an extent that she aimed to graduate with a librarian\'s certificate—which she was on the verge of acquiring if it weren\'t for an earthquake that caused her bookshelf to collapse and crush her to death. Though she may not have been granted the job of her dreams, she was at least granted another chance at life. Awakening as a frail five-year-old girl named Maine, she finds herself in a foreign medieval city populated by people with strange-colored hair. This new world fascinates Maine, but her lack of strength and the low status of her family and shelter disappoints her. To make things worse, she realizes that public literacy is low and books are rare and expensive in this city. Although Maine\'s past life has ended, her love for books has not—and thus begins the story of this bookworm\'s quest to make her own books.'),
	(92, 'Kenji is a manga about a Japanese teenager named Kenji, who practices the martial art Bajiquan, and his encounters with other martial artists, some of which are from real life, e.g. Adam Hsu and Liu Chia-Liang. This series primarily features Baji Quan, but also gets into Praying Mantis Kung Fu, Bagua Zhang, Chen Taiji Quan, Pi Quan, Xingyi Quan, Xin Yi Liu He Quan, Shaolin Quan, Hung Ga, Daito Ryu Aikijujutsu, Shotokan Karate and numerous other styles. Kenji\'s nemesis is a gangster named Tony Tan who practices Hung Gar and later Xinyiliuhequan.'),
	(93, 'Two high school girls, the short and exceptionally quick to anger Popuko, and the tall and much more calm Pipimi, do insane things and swear like sailors in this absurdist comedy filled with references and meta humor.'),
	(94, 'Having lost his parents, eight-year-old Yuuichirou Amane is taken in by the Hyakuya Orphanage, where he struggles to bond with his new "family." However, this soon becomes the least of his worries, when a major pandemic suddenly strikes, killing all above the age of 13. Taking advantage of the chaos, vampires—who previously laid dormant underground—rise up and enslave the surviving humans, using them as livestock to harvest blood. Four years later, Yuuichirou and his family have adjusted to life under vampire control, although Yuuichirou still aspires to kill all vampires and end their reign of terror. This often puts him at odds with fellow orphan Mikaela Hyakuya, who emphasizes using wit and ingenuity to survive. Having garnered favor among high-ranking vampires, Mikaela gains inside knowledge and uses this to plan a daring escape. But during the attempt, the group of orphans is intercepted by vampire officer Ferid Bathory, who proceeds to massacre them. Yuuichirou is the only member of the group to escape to the surface, where he is discovered by the Moon Demon Company, a military unit dedicated to hunting down vampires. Given an invitation to join, Yuuichirou swiftly accepts, finally being presented an opportunity to achieve his ambitions and avenge his family.'),
	(95, 'The spin-off focusing on Kishibe Rohan, an eccentric mangaka with the ability to read people\'s memories, an ability called "Heaven\'s Door." He seeks out the supernatural to see for himself what his mysterious ability is all about.'),
	(96, 'Mahiru is a beautiful girl whose classmates all call her an "angel." Not only is she a star athlete with perfect grades—she\'s also drop-dead gorgeous. Amane‚ an average guy and self-admitted slob‚ has never thought much of the divine beauty‚ despite attending the same school. Everything changes‚ however‚ when he happens to see Mahiru sitting alone in a park during a rainstorm. Thus begins the strange relationship between this incredibly unlikely pair!'),
	(97, 'While on the surface Yuu Otosaka appears to be just another charming and intelligent teenager, he has a secret—he has the ability to slip into people\'s minds and fully control their body for five seconds at a time. Yuu has been using this skill for years to gain the highest grades, which allowed him to enter a prestigious high school. When the enigmatic Nao Tomori catches Yuu using his power, she coerces him and his sister Ayumi into transferring to Hoshinoumi Academy, a school for students with supernatural abilities. The student council of the school, led by Nao, is tasked with secretly tracking down adolescents who abuse their powers. Yuu is forced to join the student council and together, they face formidable challenges that bring him closer to the shocking truth that his own, seemingly incomplete ability, might be more powerful than he could have ever imagined. An original story from Jun Maeda, creator of Angel Beats and Clannad, Charlotte explores the supernatural lives of these teenagers and the price they must pay for being special.'),
	(98, 'Succubus, Dullahan and Vampire. They are known as Ajin, or "demi"s and are slightly different than the average human. They have lived alongside humans for ages under persecution. However, in recent years, they have become accepted as members of society. This manga follows a high school biology teacher who has a great interest in demis and his interaction with the various demis in his school, each with their own cute problems.'),
	(99, 'High school student Sakamoto is the definition of perfection. Good looks, intelligence, athleticism, kindness—he has it all! Everywhere he goes, all the ladies love him and all the boys are mad with jealousy. No amount of tricks or traps can ensnare Sakamoto as he evades and outmaneuvers his critics with ease; not even a male model can stand against his cool and collected demeanor as he glides through life with grace and elegance. Whatever situation he\'s in, Sakamoto will overcome anything in absolute perfection.'),
	(100, 'High school student Yuugi Mutou spends his days being bullied between classes and his nights playing board games and solving puzzles in his bedroom. Yuugi\'s penchant for gameplay comes from his grandfather, whose game shop also serves as a house for the two. One night, Yuugi manages to solve the Millennium Puzzle, a seemingly impossible challenge that awakens his inner darkness and converts it into an alternate persona: Yami Yuugi. Transforming into the more bold and dangerous persona against his will in moments of great distress, Yuugi begins to moonlight as a vengeful vigilante, challenging bullies and evil-doers to risky games where failure results in fates worse than death. Yuugi and his alter ego befriend some of the very students who once bullied him, forming unbreakable companionships with them. But the group must contend with villains far deadlier than the high school punks they originally rallied against, enemies who use games for nefarious purposes and threaten Yuugi and his friends\' very lives.');

-- Dumping structure for table manga.genre
CREATE TABLE IF NOT EXISTS `genre` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `genre` varchar(30) COLLATE utf8_unicode_ci NOT NULL COMMENT 'žanrs',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='žanrs';

-- Dumping data for table manga.genre: ~26 rows (approximately)
INSERT INTO `genre` (`id`, `genre`) VALUES
	(1, 'Shonen'),
	(2, 'Slice of life'),
	(3, 'Isekai'),
	(4, 'Fantasy'),
	(5, 'Dark fantasy'),
	(6, 'Mystery'),
	(7, 'Action'),
	(8, 'Comedy'),
	(9, 'Sci-Fi'),
	(10, 'Horror'),
	(11, 'Adventure'),
	(12, 'Romance'),
	(13, 'Martial arts'),
	(14, 'Drama'),
	(15, 'Psychological'),
	(16, 'Supernatural'),
	(17, 'School'),
	(18, 'Historical'),
	(19, 'Seinen'),
	(20, 'Yuri'),
	(21, 'Web comic'),
	(22, 'Survival'),
	(23, 'Ecchi'),
	(24, 'Gender Bender'),
	(25, 'Villainess'),
	(28, 'Sports');

-- Dumping structure for table manga.image
CREATE TABLE IF NOT EXISTS `image` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT 'nosaukums',
  `score` decimal(5,2) NOT NULL COMMENT 'vērtējums',
  `manga_id` int(11) unsigned NOT NULL COMMENT 'albuma id',
  PRIMARY KEY (`id`),
  KEY `manga_id` (`manga_id`),
  CONSTRAINT `manga` FOREIGN KEY (`manga_id`) REFERENCES `title` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='bilde';

-- Dumping data for table manga.image: ~100 rows (approximately)
INSERT INTO `image` (`id`, `name`, `score`, `manga_id`) VALUES
	(1, 'One piece img', 4.70, 1),
	(2, 'Naruto img', 4.00, 2),
	(3, 'SAO img', 1.10, 3),
	(4, 'DBZ img', 4.50, 4),
	(5, 'North star img', 4.00, 5),
	(6, 'Tokyo Ghoul img', 3.90, 6),
	(7, 'Berserk img', 5.00, 7),
	(8, 'One-Punch man img', 4.70, 8),
	(9, 'Bleach img', 4.30, 9),
	(10, 'My Hero img', 4.00, 10),
	(11, 'Death note img', 4.30, 11),
	(12, 'Jojo img', 3.60, 12),
	(13, 'AoT img', 4.30, 13),
	(14, 'FmA', 4.50, 14),
	(15, 'Akira img', 4.34, 15),
	(16, 'HxH img', 4.35, 16),
	(17, 'Demon slayer img', 4.13, 17),
	(18, 'Jujutsu Kaisen img', 4.00, 18),
	(19, 'Fairy img', 3.78, 19),
	(20, 'Black Clover img', 3.90, 20),
	(21, 'Catulus img', 3.76, 21),
	(22, 'Redhood img', 3.21, 22),
	(23, 'Chubby img', 3.76, 23),
	(24, 'Remake img', 3.62, 24),
	(25, 'Csbamge img', 3.32, 25),
	(26, 'Cotd100 img', 3.30, 26),
	(27, 'Cosmo img', 3.38, 27),
	(28, 'Dr. Stone img', 4.10, 28),
	(29, 'TisubiwraaGiaw img', 3.34, 29),
	(30, 'Iilwtv img', 3.89, 30),
	(31, 'Love is war img', 4.47, 31),
	(32, 'All routes lead to doom img', 3.90, 32),
	(33, 'Go Magical Girls img', 3.91, 33),
	(34, 'Iwsbtdk img', 3.53, 34),
	(35, 'Mieruko-chan img', 3.96, 35),
	(36, 'Vampiress Lord img', 3.70, 36),
	(37, 'So I\'m a Spider img', 3.93, 37),
	(38, 'Frieren img', 4.30, 38),
	(39, 'Pure Azurite img', 4.20, 39),
	(40, 'Pupil of Wise Man img', 3.57, 40),
	(41, 'Apothecary Diaries img', 4.22, 41),
	(42, 'Onimai img', 3.85, 42),
	(43, 'Only Sense img', 3.59, 43),
	(44, 'Overlord img', 4.33, 44),
	(45, 'Blue Period img', 4.34, 45),
	(46, 'IMMHnBdHSS img', 3.68, 46),
	(47, 'Her Majesty\'s Swarm img', 3.57, 47),
	(48, 'Made in abyss img', 4.39, 48),
	(49, 'Vinland Saga img', 4.50, 49),
	(50, 'Classroom Elite img', 4.47, 50),
	(51, 'Suzumiya Haruhi img', 4.28, 51),
	(52, 'Oshi no Ko img', 4.26, 52),
	(53, 'Reincarnated as a Slime img', 4.25, 53),
	(54, 'Steins;Gate img', 4.25, 54),
	(55, 'Blue Lock img', 4.22, 55),
	(56, '21st Century Boys img', 4.22, 56),
	(57, 'Black Butler img', 4.21, 57),
	(58, 'Adachi to Shimamura img', 4.20, 58),
	(59, 'Shadows House img', 4.19, 59),
	(60, 'Hellsing img', 4.15, 60),
	(61, 'Beastars img', 4.14, 61),
	(62, 'Magi img', 4.14, 62),
	(63, 'Machikado Mazoku img', 4.14, 63),
	(64, 'Assassination Classroom img', 4.14, 64),
	(65, 'Toradora! img', 4.13, 65),
	(66, 'Komi img', 4.11, 66),
	(67, 'Gokushufudou img', 4.09, 67),
	(68, 'Wandering Witch Elaina img', 4.08, 68),
	(69, 'Call of the Night img', 4.06, 69),
	(70, 'Pet na Kanojo img', 4.00, 70),
	(71, 'Shield Hero img', 4.00, 71),
	(72, 'Dragon Maid img', 3.99, 72),
	(73, 'KonoSuba img', 3.99, 73),
	(74, 'Sun-Ken Rock img', 3.98, 74),
	(75, 'Kagerou Daze img', 3.97, 75),
	(76, 'Blue Exorcist img', 3.96, 76),
	(77, 'Clover img', 3.94, 77),
	(78, 'Lucky Star img', 3.94, 78),
	(79, 'Mushoku Tensei img', 3.39, 79),
	(80, 'Senko-san img', 3.93, 80),
	(81, 'Terra Formars img', 3.64, 81),
	(82, 'HKtMnYK img', 3.93, 82),
	(83, 'ABCObFMaD img', 3.93, 83),
	(84, 'Goblin Slayer img', 3.93, 84),
	(85, 'DyhwTEMImyoa img', 3.93, 85),
	(86, 'Gate img', 3.93, 86),
	(87, 'Akame ga Kill img', 3.92, 87),
	(88, 'OnSKMnM img', 3.92, 88),
	(89, 'Faraway Paladin img', 3.92, 89),
	(90, 'Isekai Ojisan img', 3.92, 90),
	(91, 'Bookworm img', 3.90, 91),
	(92, 'Kenji img', 3.90, 92),
	(93, 'Pop Team Epic img', 3.90, 93),
	(94, 'Owari no Seraph img', 3.89, 94),
	(95, 'Kishibe Rohan img', 3.89, 95),
	(96, 'SItNAIASBH img', 3.89, 96),
	(97, 'Charlotte img', 3.89, 97),
	(98, 'Interviews with Monster Girls img', 3.88, 98),
	(99, 'Sakamoto img', 3.88, 99),
	(100, 'Yu-Gi-Oh! img', 3.82, 100);

-- Dumping structure for table manga.list
CREATE TABLE IF NOT EXISTS `list` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `manga_id` int(11) unsigned NOT NULL COMMENT 'albuma id',
  `user_id` int(11) unsigned NOT NULL COMMENT 'lietotāja id',
  PRIMARY KEY (`id`),
  KEY `manga_id` (`manga_id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `manga_list_id` FOREIGN KEY (`manga_id`) REFERENCES `title` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `user_list_id` FOREIGN KEY (`user_id`) REFERENCES `username` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='uzdevumu saraksts';

-- Dumping data for table manga.list: ~6 rows (approximately)
INSERT INTO `list` (`id`, `manga_id`, `user_id`) VALUES
	(1, 1, 1),
	(2, 3, 1),
	(3, 5, 1),
	(4, 2, 2),
	(5, 4, 2),
	(6, 6, 2);

-- Dumping structure for table manga.login
CREATE TABLE IF NOT EXISTS `login` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` int(11) unsigned NOT NULL COMMENT 'nosaukuma id',
  `password_id` int(11) unsigned NOT NULL COMMENT 'paroles id',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `password_id` (`password_id`),
  CONSTRAINT `password_id` FOREIGN KEY (`password_id`) REFERENCES `password` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `user_id` FOREIGN KEY (`user_id`) REFERENCES `username` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='login logs';

-- Dumping data for table manga.login: ~2 rows (approximately)
INSERT INTO `login` (`id`, `user_id`, `password_id`) VALUES
	(1, 1, 1),
	(2, 2, 2);

-- Dumping structure for table manga.panels
CREATE TABLE IF NOT EXISTS `panels` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `panels` int(11) DEFAULT NULL COMMENT 'panelu daudzums',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Dumping data for table manga.panels: ~100 rows (approximately)
INSERT INTO `panels` (`id`, `panels`) VALUES
	(1, 0),
	(2, 0),
	(3, 0),
	(4, 0),
	(5, 0),
	(6, 0),
	(7, 4),
	(8, 0),
	(9, 0),
	(10, 0),
	(11, 0),
	(12, 0),
	(13, 0),
	(14, 0),
	(15, 0),
	(16, 0),
	(17, 0),
	(18, 0),
	(19, 0),
	(20, 0),
	(21, 0),
	(22, 0),
	(23, 0),
	(24, 0),
	(25, 0),
	(26, 0),
	(27, 0),
	(28, 0),
	(29, 0),
	(30, 0),
	(31, 0),
	(32, 0),
	(33, 0),
	(34, 0),
	(35, 0),
	(36, 0),
	(37, 0),
	(38, 0),
	(39, 0),
	(40, 0),
	(41, 0),
	(42, 0),
	(43, 0),
	(44, 0),
	(45, 0),
	(46, 0),
	(47, 0),
	(48, 0),
	(49, 0),
	(50, 0),
	(51, 0),
	(52, 0),
	(53, 0),
	(54, 0),
	(55, 0),
	(56, 0),
	(57, 0),
	(58, 0),
	(59, 0),
	(60, 0),
	(61, 0),
	(62, 0),
	(63, 0),
	(64, 0),
	(65, 0),
	(66, 0),
	(67, 0),
	(68, 0),
	(69, 0),
	(70, 0),
	(71, 0),
	(72, 0),
	(73, 0),
	(74, 0),
	(75, 0),
	(76, 0),
	(77, 0),
	(78, 0),
	(79, 0),
	(80, 0),
	(81, 0),
	(82, 0),
	(83, 0),
	(84, 0),
	(85, 0),
	(86, 0),
	(87, 0),
	(88, 0),
	(89, 0),
	(90, 0),
	(91, 0),
	(92, 0),
	(93, 0),
	(94, 0),
	(95, 0),
	(96, 0),
	(97, 0),
	(98, 0),
	(99, 0),
	(100, 0);

-- Dumping structure for table manga.password
CREATE TABLE IF NOT EXISTS `password` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `password` char(60) COLLATE utf8_unicode_ci NOT NULL COMMENT 'lietotāju paroles',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='paroļu saraksts';

-- Dumping data for table manga.password: ~2 rows (approximately)
INSERT INTO `password` (`id`, `password`) VALUES
	(1, '123'),
	(2, 'password');

-- Dumping structure for table manga.status
CREATE TABLE IF NOT EXISTS `status` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `status` varchar(20) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Albuma status',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Dumping data for table manga.status: ~5 rows (approximately)
INSERT INTO `status` (`id`, `status`) VALUES
	(1, 'Finished publishing'),
	(2, 'Ongoing'),
	(3, 'Hiatus'),
	(4, 'Cancelled'),
	(5, 'Unknown');

-- Dumping structure for table manga.title
CREATE TABLE IF NOT EXISTS `title` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT 'nosaukums',
  `date_of_publishing` date NOT NULL COMMENT 'izlaišanas datums',
  `status_id` int(11) unsigned NOT NULL COMMENT 'statusa id',
  `genre_id` int(11) unsigned NOT NULL COMMENT 'Zanra id',
  `author_id` int(11) unsigned NOT NULL COMMENT 'autora id',
  `description_id` int(11) unsigned NOT NULL COMMENT 'albuma apraksta id',
  `panel_id` int(11) unsigned NOT NULL COMMENT 'panelu daudzuma id',
  PRIMARY KEY (`id`),
  KEY `genre_id` (`genre_id`),
  KEY `author_id` (`author_id`),
  KEY `status_id` (`status_id`),
  KEY `description_id` (`description_id`),
  KEY `panel_id` (`panel_id`),
  CONSTRAINT `FK_title_panels` FOREIGN KEY (`panel_id`) REFERENCES `panels` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `description` FOREIGN KEY (`description_id`) REFERENCES `description` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `status` FOREIGN KEY (`status_id`) REFERENCES `status` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `title_author` FOREIGN KEY (`author_id`) REFERENCES `title_author` (`title_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `title_genre` FOREIGN KEY (`genre_id`) REFERENCES `title_genre` (`title_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Albuma nosaukums';

-- Dumping data for table manga.title: ~100 rows (approximately)
INSERT INTO `title` (`id`, `name`, `date_of_publishing`, `status_id`, `genre_id`, `author_id`, `description_id`, `panel_id`) VALUES
	(1, 'One piece', '1997-07-22', 2, 1, 1, 1, 1),
	(2, 'Naruto', '1999-09-21', 1, 2, 2, 2, 2),
	(3, 'Sword art online', '2009-04-10', 1, 3, 3, 3, 3),
	(4, 'Dragon ball', '1989-04-26', 1, 4, 4, 4, 4),
	(5, 'Fist of the North Star', '1986-03-08', 1, 5, 5, 5, 5),
	(6, 'Tokyo Ghoul', '2011-09-08', 1, 6, 6, 6, 6),
	(7, 'Berserk', '1997-10-07', 2, 7, 7, 7, 7),
	(8, 'One-punch man', '2012-06-14', 2, 8, 8, 8, 8),
	(9, 'Bleach', '2001-08-07', 1, 9, 9, 9, 9),
	(10, 'My Hero Academia', '2014-08-07', 2, 10, 10, 10, 10),
	(11, 'Death note', '2003-12-01', 1, 11, 11, 11, 11),
	(12, 'JoJo’s Bizarre Adventure', '1987-01-01', 1, 12, 12, 12, 12),
	(13, 'Attack on Titan', '2009-09-09', 1, 13, 13, 13, 13),
	(14, 'Fullmetal Alchemist', '2001-07-12', 1, 14, 14, 14, 14),
	(15, 'Akira', '1982-12-20', 1, 15, 15, 15, 15),
	(16, 'Hunter x Hunter', '2005-04-05', 3, 16, 16, 16, 16),
	(17, 'Demon Slayer: Kimetsu no Yaiba', '2016-02-15', 1, 17, 17, 17, 17),
	(18, 'Jujutsu Kaisen', '2019-12-03', 2, 18, 18, 18, 18),
	(19, 'Fairy Tail', '2006-08-02', 1, 19, 19, 19, 19),
	(20, 'Black Clover', '2018-04-01', 1, 20, 20, 20, 20),
	(21, 'Catulus Syndrome', '2017-10-30', 1, 21, 21, 21, 21),
	(22, 'The Hunters Guild: Red Hood', '2021-11-04', 1, 22, 22, 22, 22),
	(23, 'Asahina Wakaba & Her Chubby-Chubby Boyfriend', '2019-11-25', 1, 23, 23, 23, 23),
	(24, 'Remake our Life!', '2019-04-09', 2, 24, 24, 24, 24),
	(25, 'Can she become a magical girl even xx?', '2016-12-28', 1, 25, 25, 25, 25),
	(26, 'Convenience Store of the Dead ~The Convenience Store Clerk Will Get Rescued in 100 Days~', '2021-01-28', 1, 26, 26, 26, 26),
	(27, 'Cosmo Familia*', '2017-11-24', 1, 27, 27, 27, 27),
	(28, 'Dr. Stone', '2017-03-06', 1, 28, 28, 28, 28),
	(29, 'This Is Screwed Up, but I Was Reincarnated as a GIRL in Another World!', '2010-10-04', 2, 29, 29, 29, 29),
	(30, 'I\'m in Love with the Villainess', '2020-06-18', 2, 30, 30, 30, 30),
	(31, 'Kaguya-sama: Love is War', '2015-05-19', 1, 31, 31, 31, 31),
	(32, 'My Next Life as a Villainess: All Routes Lead to Doom!', '2017-08-28', 2, 32, 32, 32, 32),
	(33, 'Gushing over Magical Girls', '2019-01-30', 2, 33, 33, 33, 33),
	(34, 'I Was Summoned By The Demon Lord, But I Can’t Understand Her Language', '2019-12-04', 1, 34, 34, 34, 34),
	(35, 'Mieruko-chan', '2018-11-02', 2, 35, 35, 35, 35),
	(36, 'Seifuku no Vampiress Lord', '2014-08-22', 1, 36, 36, 36, 36),
	(37, 'So I\'m a Spider, So What?', '2015-12-22', 2, 37, 37, 37, 37),
	(38, 'Frieren: Beyond Journey\'s End', '2020-04-28', 2, 38, 38, 38, 38),
	(39, 'Who Decided That Blues Had To Be Cool!?', '2020-11-17', 1, 39, 39, 39, 39),
	(40, 'She Professed Herself Pupil of the Wise Man', '2016-07-28', 2, 40, 40, 40, 40),
	(41, 'The Apothecary Diaries', '2017-05-25', 2, 41, 41, 41, 41),
	(42, 'Onimai: I\'m Now Your Sister!', '2018-06-27', 2, 42, 42, 42, 42),
	(43, 'Only Sense Online', '2014-12-09', 2, 43, 43, 43, 43),
	(44, 'Overlord', '2012-07-30', 2, 44, 44, 44, 44),
	(45, 'Blue Period', '2017-06-24', 2, 45, 45, 45, 45),
	(46, 'isekai Apocalypse Mynoghra ~The Conquest Of The World Starts With The Civilization Of Ruin~', '2020-03-27', 2, 46, 46, 46, 46),
	(47, 'Her Majesty\'s Swarm', '2018-10-07', 2, 47, 47, 47, 47),
	(48, 'Made in Abyss', '2012-10-20', 2, 48, 48, 48, 48),
	(49, 'Vinland Saga', '2005-04-13', 2, 49, 49, 49, 49),
	(50, 'Classroom of the Elite', '2015-05-25', 1, 50, 50, 50, 50),
	(51, 'Suzumiya Haruhi Series', '2003-06-06', 2, 51, 51, 51, 51),
	(52, 'Oshi no Ko', '2020-04-23', 2, 52, 52, 52, 52),
	(53, 'That Time I Got Reincarnated as a Slime', '2014-05-30', 2, 53, 53, 53, 53),
	(54, 'Steins;Gate', '2011-06-30', 1, 54, 54, 54, 54),
	(55, 'Blue Lock', '2018-08-01', 2, 55, 55, 55, 55),
	(56, '21st Century Boys', '2006-12-25', 1, 56, 56, 56, 56),
	(57, 'Black Butler', '2006-09-16', 2, 57, 57, 57, 57),
	(58, 'Adachi to Shimamura', '2012-10-10', 2, 58, 58, 58, 58),
	(59, 'Shadows House', '2018-09-06', 2, 59, 59, 59, 59),
	(60, 'Hellsing', '1997-04-30', 1, 60, 60, 60, 60),
	(61, 'Beastars', '2016-09-08', 1, 61, 61, 61, 61),
	(62, 'Magi', '2009-06-03', 1, 62, 62, 62, 62),
	(63, 'The Demon Girl Next Door', '2014-06-28', 2, 63, 63, 63, 63),
	(64, 'Assassination Classroom', '2012-07-02', 1, 64, 64, 64, 64),
	(65, 'Toradora!', '2006-03-10', 1, 65, 65, 65, 65),
	(66, 'Komi Can\'t Communicate', '2016-05-18', 2, 66, 66, 66, 66),
	(67, 'Gokushufudou', '2018-02-23', 2, 67, 67, 67, 67),
	(68, 'Wandering Witch: The Journey of Elaina', '2016-04-15', 2, 68, 68, 68, 68),
	(69, 'Call of the Night', '2019-08-28', 2, 69, 69, 69, 69),
	(70, 'Sakurasou no Pet na Kanojo', '2010-01-10', 1, 70, 70, 70, 70),
	(71, 'The Rising of the Shield Hero', '2013-08-22', 2, 71, 71, 71, 71),
	(72, 'Miss Kobayashi\'s Dragon Maid', '2010-05-25', 2, 72, 72, 72, 72),
	(73, 'KonoSuba: God\'s Blessing on This Wonderful World!', '2014-09-09', 2, 73, 73, 73, 73),
	(74, 'Sun-Ken Rock', '2006-04-24', 1, 74, 74, 74, 74),
	(75, 'Kagerou Daze', '2012-06-15', 2, 75, 75, 75, 75),
	(76, 'Blue Exorcist', '2009-04-04', 2, 76, 76, 76, 76),
	(77, 'Clover', '2007-04-05', 1, 77, 77, 77, 77),
	(78, 'Lucky Star', '2003-12-10', 2, 78, 78, 78, 78),
	(79, 'Mushoku Tensei: Jobless Reincarnation', '2014-01-23', 1, 79, 79, 79, 79),
	(80, 'Sewayaki Kitsune no Senko-san', '2017-10-06', 2, 80, 80, 80, 80),
	(81, 'Terra Formars', '2011-01-13', 1, 81, 81, 81, 81),
	(82, 'Hokuou Kizoku to Moukinzuma no Yukiguni Karigurashi', '2018-03-30', 5, 82, 82, 82, 82),
	(83, 'A Breakthrough Came Out by Forbidden Master and Disciple.', '2020-04-02', 1, 83, 83, 83, 83),
	(84, 'Goblin Slayer', '2016-02-15', 2, 84, 84, 84, 84),
	(85, 'Do you have what THE END? May I meet you once again?', '2016-04-01', 1, 85, 85, 85, 85),
	(86, 'Gate: Where the JSDF Fought', '2011-07-30', 2, 86, 86, 86, 86),
	(87, 'Akame ga Kill!', '2010-04-22', 1, 87, 87, 87, 87),
	(88, 'Owari no Seraph: Kyuuketsuki Mikaela no Monogatari', '2015-12-04', 1, 88, 88, 88, 88),
	(89, 'The Faraway Paladin', '2017-09-25', 2, 89, 89, 89, 89),
	(90, 'Isekai Ojisan', '2018-06-29', 2, 90, 90, 90, 90),
	(91, 'Ascendance of a Bookworm: I\'ll do Anything to Become a Librarian! Part 1 - If There Aren\'t Any Books', '2015-10-30', 1, 91, 91, 91, 91),
	(92, 'Kenji', '1987-12-09', 1, 92, 92, 92, 92),
	(93, 'Pop Team Epic', '2014-08-29', 2, 93, 93, 93, 93),
	(94, 'Owari no Seraph', '2012-07-03', 2, 94, 94, 94, 94),
	(95, 'Thus Spoke Kishibe Rohan', '1997-06-24', 2, 95, 95, 95, 95),
	(96, 'She Is the Neighbor Angel, I Am Spoilt By Her', '2022-01-06', 2, 96, 96, 96, 96),
	(97, 'Charlotte', '2015-07-30', 1, 97, 97, 97, 97),
	(98, 'Interviews with Monster Girls', '2014-07-05', 2, 98, 98, 98, 98),
	(99, 'Haven\'t You Heard? I\'m Sakamoto', '2011-08-11', 1, 99, 99, 99, 99),
	(100, 'Yu-Gi-Oh!', '1996-07-17', 1, 100, 100, 100, 100);

-- Dumping structure for table manga.title_author
CREATE TABLE IF NOT EXISTS `title_author` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `title_id` int(11) unsigned NOT NULL COMMENT 'albuma id',
  `author_id` int(11) unsigned NOT NULL COMMENT 'autora id',
  PRIMARY KEY (`id`),
  KEY `title_id` (`title_id`),
  KEY `author_id` (`author_id`),
  CONSTRAINT `author` FOREIGN KEY (`author_id`) REFERENCES `author` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=256 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Dumping data for table manga.title_author: ~130 rows (approximately)
INSERT INTO `title_author` (`id`, `title_id`, `author_id`) VALUES
	(1, 1, 1),
	(2, 2, 2),
	(3, 3, 3),
	(4, 4, 4),
	(5, 5, 5),
	(6, 5, 6),
	(7, 6, 7),
	(8, 7, 8),
	(9, 7, 9),
	(10, 8, 10),
	(11, 8, 11),
	(12, 9, 12),
	(13, 10, 13),
	(14, 11, 14),
	(15, 11, 15),
	(16, 12, 16),
	(17, 13, 17),
	(18, 14, 18),
	(19, 15, 19),
	(20, 16, 20),
	(21, 17, 21),
	(22, 18, 22),
	(23, 19, 23),
	(24, 20, 24),
	(25, 21, 25),
	(26, 22, 26),
	(27, 23, 27),
	(28, 23, 28),
	(29, 24, 29),
	(30, 24, 30),
	(31, 25, 31),
	(32, 26, 32),
	(33, 27, 33),
	(34, 28, 34),
	(35, 28, 35),
	(36, 29, 36),
	(37, 29, 37),
	(38, 30, 38),
	(39, 30, 39),
	(40, 31, 40),
	(41, 32, 41),
	(42, 33, 42),
	(43, 34, 43),
	(44, 35, 44),
	(45, 36, 45),
	(46, 37, 46),
	(47, 38, 47),
	(48, 39, 48),
	(49, 40, 49),
	(50, 40, 50),
	(51, 41, 51),
	(52, 42, 52),
	(53, 43, 53),
	(54, 43, 54),
	(55, 44, 55),
	(56, 44, 56),
	(57, 45, 57),
	(58, 46, 58),
	(59, 46, 59),
	(60, 47, 60),
	(61, 47, 61),
	(62, 48, 62),
	(63, 49, 63),
	(64, 50, 64),
	(65, 51, 65),
	(66, 52, 66),
	(67, 52, 67),
	(68, 53, 68),
	(69, 54, 69),
	(70, 55, 70),
	(71, 56, 71),
	(72, 57, 72),
	(73, 58, 73),
	(74, 59, 74),
	(75, 60, 75),
	(76, 61, 76),
	(77, 62, 77),
	(78, 63, 78),
	(79, 64, 79),
	(80, 65, 80),
	(81, 66, 81),
	(82, 67, 82),
	(83, 68, 83),
	(84, 68, 84),
	(85, 68, 85),
	(86, 69, 86),
	(87, 70, 87),
	(88, 71, 88),
	(89, 72, 89),
	(90, 73, 90),
	(91, 74, 91),
	(92, 75, 92),
	(93, 75, 93),
	(94, 76, 94),
	(95, 77, 95),
	(96, 78, 96),
	(97, 78, 97),
	(98, 79, 98),
	(99, 80, 99),
	(100, 81, 100),
	(101, 81, 101),
	(102, 82, 102),
	(103, 82, 103),
	(104, 83, 104),
	(105, 83, 105),
	(106, 84, 106),
	(107, 84, 107),
	(108, 85, 108),
	(109, 85, 109),
	(110, 86, 110),
	(111, 87, 111),
	(112, 88, 112),
	(113, 88, 113),
	(114, 89, 114),
	(115, 90, 115),
	(116, 91, 116),
	(117, 91, 117),
	(118, 92, 118),
	(119, 92, 119),
	(120, 93, 120),
	(121, 94, 112),
	(122, 94, 113),
	(123, 95, 16),
	(124, 96, 121),
	(125, 96, 122),
	(126, 97, 123),
	(127, 97, 124),
	(128, 98, 125),
	(129, 99, 126),
	(130, 100, 127);

-- Dumping structure for table manga.title_genre
CREATE TABLE IF NOT EXISTS `title_genre` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `title_id` int(11) unsigned NOT NULL COMMENT 'albuma id',
  `genre_id` int(11) unsigned NOT NULL COMMENT 'žanra id',
  PRIMARY KEY (`id`),
  KEY `genre` (`genre_id`) USING BTREE,
  KEY `title_id` (`title_id`),
  CONSTRAINT `Genre` FOREIGN KEY (`genre_id`) REFERENCES `genre` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=318 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='ar titulu saistītie žanri';

-- Dumping data for table manga.title_genre: ~313 rows (approximately)
INSERT INTO `title_genre` (`id`, `title_id`, `genre_id`) VALUES
	(1, 1, 1),
	(2, 1, 7),
	(3, 1, 11),
	(4, 1, 4),
	(5, 2, 1),
	(6, 2, 7),
	(7, 2, 11),
	(8, 2, 4),
	(9, 3, 7),
	(10, 3, 11),
	(11, 3, 4),
	(12, 3, 12),
	(13, 4, 7),
	(14, 4, 11),
	(15, 4, 8),
	(16, 4, 9),
	(17, 5, 7),
	(18, 5, 14),
	(19, 5, 9),
	(20, 5, 13),
	(21, 6, 7),
	(22, 6, 4),
	(23, 6, 10),
	(24, 7, 7),
	(25, 7, 11),
	(26, 7, 14),
	(27, 7, 4),
	(28, 7, 10),
	(29, 7, 15),
	(30, 7, 16),
	(31, 8, 7),
	(32, 8, 8),
	(33, 9, 1),
	(34, 9, 11),
	(35, 9, 4),
	(36, 10, 1),
	(37, 10, 17),
	(38, 10, 7),
	(39, 11, 16),
	(40, 11, 15),
	(41, 11, 6),
	(42, 12, 7),
	(43, 12, 11),
	(44, 12, 10),
	(45, 12, 1),
	(46, 12, 18),
	(47, 13, 7),
	(48, 13, 14),
	(49, 13, 1),
	(50, 14, 1),
	(51, 14, 11),
	(53, 14, 14),
	(54, 14, 4),
	(55, 14, 7),
	(56, 15, 7),
	(57, 15, 9),
	(58, 15, 19),
	(59, 16, 1),
	(60, 16, 7),
	(61, 16, 11),
	(62, 16, 4),
	(63, 17, 1),
	(64, 17, 7),
	(65, 17, 4),
	(66, 17, 18),
	(67, 18, 1),
	(68, 18, 7),
	(69, 18, 4),
	(70, 18, 17),
	(71, 19, 1),
	(72, 19, 7),
	(73, 19, 11),
	(74, 19, 4),
	(75, 20, 1),
	(76, 20, 7),
	(77, 20, 8),
	(78, 20, 4),
	(79, 21, 8),
	(80, 21, 20),
	(81, 21, 16),
	(82, 22, 7),
	(83, 22, 11),
	(84, 22, 4),
	(85, 23, 8),
	(86, 23, 14),
	(87, 23, 12),
	(88, 24, 8),
	(89, 24, 14),
	(90, 25, 8),
	(91, 25, 4),
	(92, 26, 14),
	(93, 26, 10),
	(94, 26, 8),
	(95, 26, 21),
	(96, 27, 14),
	(97, 27, 9),
	(98, 27, 16),
	(99, 27, 6),
	(100, 28, 11),
	(101, 28, 9),
	(102, 28, 6),
	(103, 28, 22),
	(104, 29, 8),
	(105, 29, 3),
	(106, 29, 11),
	(107, 29, 4),
	(108, 29, 23),
	(109, 29, 24),
	(110, 30, 8),
	(111, 30, 4),
	(112, 30, 20),
	(113, 30, 3),
	(114, 30, 25),
	(115, 30, 12),
	(116, 31, 12),
	(117, 31, 14),
	(118, 31, 8),
	(119, 31, 2),
	(120, 32, 8),
	(121, 32, 3),
	(122, 32, 12),
	(123, 32, 14),
	(124, 32, 25),
	(125, 33, 8),
	(126, 33, 23),
	(128, 33, 4),
	(129, 33, 20),
	(130, 34, 8),
	(131, 34, 3),
	(132, 34, 4),
	(133, 35, 8),
	(134, 35, 14),
	(135, 35, 10),
	(136, 35, 6),
	(137, 35, 15),
	(138, 35, 16),
	(139, 36, 8),
	(140, 36, 12),
	(141, 36, 16),
	(142, 37, 8),
	(143, 37, 11),
	(144, 37, 7),
	(145, 37, 3),
	(146, 37, 4),
	(147, 38, 11),
	(148, 38, 4),
	(149, 38, 2),
	(150, 39, 21),
	(151, 39, 8),
	(152, 39, 20),
	(153, 40, 11),
	(154, 40, 4),
	(155, 40, 24),
	(156, 41, 8),
	(157, 41, 18),
	(158, 41, 6),
	(159, 41, 14),
	(160, 42, 21),
	(161, 42, 24),
	(162, 42, 2),
	(163, 43, 11),
	(164, 43, 8),
	(165, 43, 2),
	(166, 43, 24),
	(167, 44, 7),
	(168, 44, 4),
	(169, 44, 3),
	(170, 44, 16),
	(171, 45, 14),
	(172, 46, 11),
	(173, 46, 4),
	(174, 46, 3),
	(175, 47, 7),
	(176, 47, 4),
	(177, 47, 10),
	(178, 47, 3),
	(179, 48, 11),
	(180, 48, 14),
	(181, 48, 4),
	(182, 48, 9),
	(183, 49, 7),
	(184, 49, 11),
	(185, 49, 14),
	(186, 49, 18),
	(187, 50, 14),
	(188, 50, 15),
	(189, 51, 8),
	(190, 51, 14),
	(191, 51, 9),
	(192, 51, 16),
	(193, 52, 14),
	(194, 52, 16),
	(195, 53, 4),
	(196, 53, 3),
	(197, 54, 9),
	(198, 54, 6),
	(199, 55, 28),
	(200, 56, 14),
	(201, 56, 6),
	(202, 56, 9),
	(203, 57, 7),
	(204, 57, 4),
	(205, 57, 6),
	(206, 57, 16),
	(207, 57, 18),
	(208, 58, 20),
	(209, 58, 2),
	(210, 59, 2),
	(211, 59, 16),
	(212, 60, 7),
	(213, 60, 10),
	(214, 60, 16),
	(215, 61, 14),
	(216, 61, 2),
	(217, 61, 15),
	(219, 62, 4),
	(220, 62, 1),
	(221, 63, 8),
	(222, 63, 2),
	(223, 64, 7),
	(224, 64, 8),
	(225, 65, 14),
	(226, 65, 12),
	(227, 66, 8),
	(228, 66, 12),
	(229, 67, 8),
	(230, 68, 11),
	(231, 68, 4),
	(232, 69, 12),
	(233, 69, 16),
	(234, 70, 8),
	(235, 70, 12),
	(236, 70, 2),
	(237, 71, 4),
	(238, 71, 3),
	(239, 72, 4),
	(240, 72, 2),
	(241, 73, 8),
	(242, 73, 4),
	(243, 73, 11),
	(244, 73, 3),
	(245, 74, 7),
	(246, 74, 14),
	(247, 74, 8),
	(248, 74, 23),
	(249, 75, 8),
	(250, 75, 12),
	(251, 75, 16),
	(252, 75, 9),
	(253, 76, 7),
	(254, 76, 4),
	(255, 77, 8),
	(256, 77, 7),
	(258, 77, 2),
	(259, 78, 4),
	(260, 78, 3),
	(261, 79, 8),
	(262, 79, 3),
	(263, 80, 8),
	(264, 80, 16),
	(265, 81, 7),
	(266, 81, 10),
	(267, 81, 9),
	(268, 82, 12),
	(269, 82, 2),
	(270, 83, 7),
	(271, 83, 11),
	(272, 83, 8),
	(273, 83, 4),
	(274, 84, 4),
	(275, 84, 7),
	(276, 85, 4),
	(277, 85, 14),
	(278, 86, 7),
	(279, 86, 11),
	(280, 86, 4),
	(281, 86, 3),
	(282, 87, 7),
	(283, 87, 4),
	(284, 88, 7),
	(285, 88, 14),
	(286, 89, 7),
	(287, 89, 11),
	(288, 89, 4),
	(289, 89, 3),
	(290, 90, 4),
	(291, 90, 8),
	(292, 90, 3),
	(293, 91, 4),
	(294, 91, 3),
	(295, 92, 7),
	(296, 92, 13),
	(297, 93, 8),
	(298, 94, 7),
	(299, 94, 14),
	(300, 94, 16),
	(301, 95, 6),
	(302, 95, 16),
	(303, 96, 8),
	(304, 96, 12),
	(305, 97, 14),
	(306, 97, 6),
	(307, 98, 4),
	(308, 98, 8),
	(309, 99, 8),
	(310, 100, 7),
	(311, 100, 11),
	(312, 100, 8),
	(313, 100, 14),
	(314, 100, 4),
	(315, 100, 6),
	(316, 100, 16),
	(317, 100, 18);

-- Dumping structure for view manga.title_view
-- Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `title_view` (
	`json` MEDIUMTEXT NULL COLLATE 'utf8_unicode_ci'
) ENGINE=MyISAM;

-- Dumping structure for table manga.username
CREATE TABLE IF NOT EXISTS `username` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT 'lietotāja nosaukums',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='lietotāju nosaukumu saraksts';

-- Dumping data for table manga.username: ~2 rows (approximately)
INSERT INTO `username` (`id`, `user`) VALUES
	(1, 'admin'),
	(2, 'test');

-- Dumping structure for view manga.title_view
-- Removing temporary table and create final VIEW structure
DROP TABLE IF EXISTS `title_view`;
CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `title_view` AS SELECT 
    CONCAT("[",
         GROUP_CONCAT(
              CONCAT('{"id":"',IFNULL(id,""),'",'),
              CONCAT('"name":"',IFNULL(name,""),'",'),
              CONCAT('"date_of_publishing":"',IFNULL(date_of_publishing,""),'",'),
              CONCAT('"status_id":"',IFNULL(status_id,""),'",'),
              CONCAT('"genre_id":"',IFNULL(genre_id,""),'",'),
              CONCAT('"author_id":"',IFNULL(author_id,""),'"}')
         )
    ,"]") 
AS json FROM title WHERE id<4520 ;

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
