db_winXReloaded_230313.sql

-- --------------------------------------------------------
-- Host:                         185.254.96.204
-- Server Version:               5.7.41-log - MySQL Community Server (GPL)
-- Server Betriebssystem:        Win64
-- HeidiSQL Version:             12.1.0.6537
-- --------------------------------------------------------

/*!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 */;


-- Exportiere Datenbank Struktur für db_winx
CREATE DATABASE IF NOT EXISTS `db_winx` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `db_winx`;

-- Exportiere Struktur von Tabelle db_winx.answers
CREATE TABLE IF NOT EXISTS `answers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question_id` int(11) NOT NULL,
  `is_correct` enum('1','0') NOT NULL DEFAULT '0',
  `answer` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `foreign_key` (`question_id`)
) ENGINE=InnoDB AUTO_INCREMENT=284 DEFAULT CHARSET=utf8mb4 COMMENT='Die Antworten nach Fragen Sortiert';

-- Exportiere Daten aus Tabelle db_winx.answers: ~283 rows (ungefähr)
REPLACE INTO `answers` (`id`, `question_id`, `is_correct`, `answer`) VALUES
	(1, 1, '0', 'Europe'),
	(2, 1, '0', 'Asia'),
	(3, 1, '1', 'South America'),
	(4, 1, '0', 'Australia'),
	(5, 1, '0', 'North America'),
	(6, 2, '1', 'Freddie Mercury'),
	(7, 2, '0', 'David Bowie'),
	(8, 2, '0', 'Elton John'),
	(9, 2, '0', 'Bruce Springsteen'),
	(10, 2, '0', 'John Lennon'),
	(11, 3, '0', 'Hey Jude'),
	(12, 3, '0', 'Imagine'),
	(13, 3, '1', 'Let it Be'),
	(14, 3, '0', 'Yesterday'),
	(15, 3, '0', 'Help!'),
	(16, 4, '0', 'Giacomo Puccini'),
	(17, 4, '0', 'Wolfgang Amadeus Mozart'),
	(18, 4, '1', 'Gioachino Rossini'),
	(19, 4, '0', 'Ludwig van Beethoven'),
	(20, 4, '0', 'Giuseppe Verdi'),
	(21, 5, '0', 'Swan Lake'),
	(22, 5, '1', 'The Nutcracker'),
	(23, 5, '0', 'The Sleeping Beauty'),
	(24, 5, '0', 'Romeo and Juliet'),
	(25, 5, '0', 'Cinderella'),
	(26, 6, '1', 'Rhapsody in Blue'),
	(27, 6, '0', 'Concerto in F'),
	(28, 6, '0', 'An American in Paris'),
	(29, 6, '0', 'Prelude No. 2'),
	(30, 6, '0', 'Piano Concerto No. 2'),
	(31, 7, '1', 'Russia'),
	(32, 7, '0', 'Canada'),
	(33, 7, '0', 'China'),
	(34, 7, '0', 'United States'),
	(35, 7, '0', 'Antarctica'),
	(36, 8, '0', 'Paris'),
	(37, 8, '0', 'Madrid'),
	(38, 8, '0', 'Berlin'),
	(39, 8, '1', 'Rome'),
	(40, 8, '0', 'London'),
	(41, 9, '1', 'Euro'),
	(42, 9, '0', 'Dollar'),
	(43, 9, '0', 'Pound'),
	(44, 9, '0', 'Yen'),
	(45, 9, '0', 'Franc'),
	(46, 10, '0', 'South Africa'),
	(47, 10, '0', 'Nigeria'),
	(48, 10, '0', 'Egypt'),
	(49, 10, '1', 'Ethiopia'),
	(50, 10, '0', 'Morocco'),
	(51, 11, '0', 'Monaco'),
	(52, 11, '0', 'San Marino'),
	(53, 11, '1', 'Vatican City'),
	(54, 11, '0', 'Nauru'),
	(55, 11, '0', 'Tuvalu'),
	(56, 12, '1', 'All Eyez on Me'),
	(57, 12, '0', 'The Chronic'),
	(58, 12, '0', 'The Slim Shady LP'),
	(59, 12, '0', 'Ready to Die'),
	(60, 12, '0', 'Life After Death'),
	(61, 13, '1', 'Led Zeppelin'),
	(62, 13, '0', 'Black Sabbath'),
	(63, 13, '0', 'The Who'),
	(64, 13, '0', 'Deep Purple'),
	(65, 13, '0', 'Pink Floyd'),
	(66, 14, '1', 'Thriller'),
	(67, 14, '0', 'Beat It'),
	(68, 14, '0', 'Billie Jean'),
	(69, 14, '0', 'Bad'),
	(70, 14, '0', 'Man in the Mirror'),
	(71, 15, '0', 'Suspicious Minds'),
	(72, 15, '0', 'Blue Suede Shoes'),
	(73, 15, '0', 'Heartbreak Hotel'),
	(74, 15, '0', 'Hound Dog'),
	(75, 15, '1', 'Love Me Tender'),
	(76, 16, '0', 'Someone Like You'),
	(77, 16, '0', 'Hello'),
	(78, 16, '1', 'Set Fire to the Rain'),
	(79, 16, '0', 'Rolling in the Deep'),
	(80, 16, '0', 'Skyfall'),
	(81, 17, '1', 'Missing in Action'),
	(82, 17, '0', 'Invasion U.S.A.'),
	(83, 17, '0', 'The Octagon'),
	(84, 17, '0', 'Delta Force'),
	(85, 17, '0', 'Code of Silence'),
	(86, 18, '1', 'Carlos Ray Norris'),
	(87, 18, '0', 'Charles Richard Norris'),
	(88, 18, '0', 'Charles Robert Norris'),
	(89, 18, '0', 'Charles Raymond Norris'),
	(90, 18, '0', 'Carl Richard Norris'),
	(91, 19, '1', 'Martial Arts'),
	(92, 19, '0', 'Comedian'),
	(93, 19, '0', 'Actor'),
	(94, 19, '0', 'Philanthropist'),
	(95, 19, '0', 'Politician'),
	(96, 20, '1', '10th Degree Black Belt'),
	(97, 20, '0', '8th Degree Black Belt'),
	(98, 20, '0', '9th Degree Black Belt'),
	(99, 20, '0', '7th Degree Black Belt'),
	(100, 20, '0', '6th Degree Black Belt'),
	(101, 21, '1', '1940'),
	(102, 21, '0', '1941'),
	(103, 21, '0', '1942'),
	(104, 21, '0', '1943'),
	(105, 21, '0', '1944'),
	(106, 22, '0', 'Felis catus'),
	(107, 22, '1', 'Felis silvestris catus'),
	(108, 22, '0', 'Panthera tigris'),
	(109, 22, '0', 'Canis lupus'),
	(110, 22, '0', 'Equus caballus'),
	(111, 23, '1', 'Lion'),
	(112, 23, '0', 'Tiger'),
	(113, 23, '0', 'Jaguar'),
	(114, 23, '0', 'Leopard'),
	(115, 23, '0', 'Elephant'),
	(116, 24, '1', 'Ostrich'),
	(117, 24, '0', 'Emu'),
	(118, 24, '0', 'Kiwi'),
	(119, 24, '0', 'Pelican'),
	(120, 24, '0', 'Swan'),
	(121, 25, '1', 'Bumblebee Bat'),
	(122, 25, '0', 'Pygmy Shrew'),
	(123, 25, '0', 'Etruscan Shrew'),
	(124, 25, '0', 'Harvest Mouse'),
	(125, 25, '0', 'African Pygmy Mouse'),
	(126, 26, '1', 'Eagle'),
	(127, 26, '0', 'Hawk'),
	(128, 26, '0', 'Falcon'),
	(129, 26, '0', 'Owl'),
	(130, 26, '0', 'Pelican'),
	(131, 27, '1', 'Avengers: Endgame'),
	(132, 27, '0', 'Avatar'),
	(133, 27, '0', 'Titanic'),
	(134, 27, '0', 'Star Wars: The Force Awakens'),
	(135, 27, '0', 'Avengers: Infinity War'),
	(136, 28, '0', '1917'),
	(137, 28, '1', 'Parasite'),
	(138, 28, '0', 'Joker'),
	(139, 28, '0', 'The Irishman'),
	(140, 28, '0', 'Once Upon a Time in Hollywood'),
	(141, 29, '1', 'Frank Darabont'),
	(142, 29, '0', 'Martin Scorsese'),
	(143, 29, '0', 'Quentin Tarantino'),
	(144, 29, '0', 'Steven Spielberg'),
	(145, 29, '0', 'David Fincher'),
	(146, 30, '1', 'Harrison Ford'),
	(147, 30, '0', 'Tom Hanks'),
	(148, 30, '0', 'Matt Damon'),
	(149, 30, '0', 'Brad Pitt'),
	(150, 30, '0', 'George Clooney'),
	(151, 31, '1', 'Superior'),
	(152, 31, '1', 'Huron'),
	(153, 31, '1', 'Michigan'),
	(154, 31, '1', 'Erie'),
	(155, 31, '1', 'Ontario'),
	(156, 32, '1', 'Neil Armstrong'),
	(157, 32, '1', 'Buzz Aldrin'),
	(158, 32, '0', 'Michael Collins'),
	(159, 33, '1', 'Executive'),
	(160, 33, '1', 'Legislative'),
	(161, 33, '1', 'Judicial'),
	(162, 34, '1', 'Spring'),
	(163, 34, '1', 'Summer'),
	(164, 34, '1', 'Fall'),
	(165, 34, '1', 'Winter'),
	(166, 35, '1', 'Europe'),
	(167, 35, '1', 'Asia'),
	(168, 35, '1', 'Africa'),
	(169, 35, '0', 'North America'),
	(170, 35, '0', 'South America'),
	(171, 36, '1', 'George Washington'),
	(172, 36, '1', 'John Adams'),
	(173, 36, '0', 'Thomas Jefferson'),
	(174, 37, '0', 'Fire'),
	(175, 37, '1', 'Water'),
	(176, 37, '1', 'Air'),
	(177, 37, '1', 'Earth'),
	(178, 38, '1', 'Scout Finch'),
	(179, 38, '1', 'Jem Finch'),
	(180, 38, '1', 'Atticus Finch'),
	(181, 38, '0', 'Tom Robinson'),
	(182, 39, '1', 'Atlantic'),
	(183, 39, '1', 'Indian'),
	(184, 39, '0', 'Southern'),
	(185, 39, '0', 'Arctic'),
	(186, 39, '1', 'Pacific'),
	(187, 40, '1', 'Moe Howard'),
	(188, 40, '1', 'Curly Howard'),
	(189, 40, '1', 'Larry Fine'),
	(190, 41, '1', 'Great Pyramid of Giza'),
	(191, 41, '1', 'Hanging Gardens of Babylon'),
	(192, 41, '0', 'Colossus of Rhodes'),
	(193, 41, '1', 'Lighthouse of Alexandria'),
	(194, 41, '0', 'Mausoleum at Halicarnassus'),
	(195, 42, '1', 'Elizabeth Bennet'),
	(196, 42, '1', 'Mr. Darcy'),
	(197, 43, '1', 'Red'),
	(198, 43, '1', 'White'),
	(199, 43, '1', 'Blue'),
	(200, 44, '1', 'George Washington'),
	(201, 44, '1', 'Thomas Jefferson'),
	(202, 44, '1', 'Benjamin Franklin'),
	(203, 44, '1', 'John Adams'),
	(204, 45, '0', 'Payload section'),
	(205, 45, '1', 'Service module'),
	(206, 45, '1', 'Command module'),
	(207, 45, '0', 'Propulsion system'),
	(208, 45, '1', 'Reentry module'),
	(209, 46, '0', 'Mars'),
	(210, 46, '0', 'Earth'),
	(211, 46, '1', 'Saturn'),
	(212, 46, '1', 'Jupiter'),
	(213, 47, '1', 'Neil Armstrong'),
	(214, 47, '1', 'Buzz Aldrin'),
	(215, 47, '0', 'Michael Collins'),
	(216, 48, '1', 'Russian Orbital Segment'),
	(217, 48, '1', 'US Orbital Segment'),
	(218, 48, '1', 'European Orbital Segment'),
	(219, 49, '1', 'Yuri Gagarin'),
	(220, 49, '0', 'Neil Armstrong'),
	(221, 49, '1', 'Alan Shepard'),
	(222, 50, '1', 'John Young'),
	(223, 50, '1', 'Bob Crippen'),
	(224, 51, '1', 'Launch'),
	(225, 51, '1', 'Orbit'),
	(226, 51, '1', 'Reentry'),
	(227, 52, '1', 'Chemical propulsion'),
	(228, 52, '1', 'Solar electric propulsion'),
	(229, 53, '1', 'Sean Connery'),
	(230, 53, '1', 'Daniel Craig'),
	(231, 53, '1', 'Roger Moore'),
	(232, 53, '0', 'Tom Cruise'),
	(233, 54, '1', 'Meryl Streep'),
	(234, 54, '1', 'Emma Stone'),
	(235, 54, '1', 'Brie Larson'),
	(236, 54, '0', 'Scarlett Johansson'),
	(237, 55, '1', 'The Godfather'),
	(238, 55, '1', 'Titanic'),
	(239, 55, '1', 'Forrest Gump'),
	(240, 55, '1', 'Moonlight'),
	(241, 56, '1', 'Jurassic Park'),
	(242, 56, '0', 'The Terminator'),
	(243, 56, '1', 'E.T. the Extra-Terrestrial'),
	(244, 56, '1', 'Jaws'),
	(245, 57, '1', 'The Shawshank Redemption'),
	(246, 57, '1', 'The Green Mile'),
	(247, 57, '1', 'The Shining'),
	(248, 57, '0', 'The Godfather'),
	(249, 58, '1', 'Michael Keaton'),
	(250, 58, '1', 'George Clooney'),
	(251, 58, '1', 'Ben Affleck'),
	(252, 58, '1', 'Christian Bale'),
	(253, 59, '1', 'The Lion King'),
	(254, 59, '0', 'Frozen'),
	(255, 59, '0', 'Shrek'),
	(256, 59, '1', 'Aladdin'),
	(257, 60, '1', 'Anthony Hopkins'),
	(258, 60, '1', 'Denzel Washington'),
	(259, 60, '1', 'Leonardo DiCaprio'),
	(260, 60, '0', 'Will Smith'),
	(261, 61, '1', 'yes'),
	(262, 61, '0', 'no'),
	(263, 62, '1', 'The Beatles'),
	(264, 62, '1', 'The Rolling Stones'),
	(265, 62, '1', 'The Who'),
	(266, 62, '0', 'Guns N\' Roses'),
	(267, 63, '1', 'Beyoncé'),
	(268, 63, '1', 'Taylor Swift'),
	(269, 63, '1', 'Adele'),
	(270, 63, '0', 'Justin Bieber'),
	(271, 64, '1', 'Nirvana'),
	(272, 64, '1', 'Metallica'),
	(273, 64, '0', 'Led Zeppelin'),
	(274, 64, '1', 'Red Hot Chili Peppers'),
	(275, 65, '1', 'Bob Dylan'),
	(276, 65, '1', 'Leonard Cohen'),
	(277, 65, '0', 'Bruce Springsteen'),
	(278, 65, '0', 'Joni Mitchell'),
	(279, 66, '0', '"Stayin\' Alive" by the Bee Gees'),
	(280, 66, '1', '"Billie Jean" by Michael Jackson'),
	(281, 66, '1', '"Smooth" by Santana featuring Rob Thomas'),
	(282, 66, '1', '"Somebody That I Used to Know" by Gotye'),
	(283, 51, '1', 'Meco (main engine cut off)');

-- Exportiere Struktur von Tabelle db_winx.lang
CREATE TABLE IF NOT EXISTS `lang` (
  `lang` enum('en','de') NOT NULL,
  `key` enum('reg_mail','reg_user','reg_pwd','reg_pwd2') NOT NULL,
  `value` varchar(255) NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='language table';

-- Exportiere Daten aus Tabelle db_winx.lang: ~1 rows (ungefähr)
REPLACE INTO `lang` (`lang`, `key`, `value`) VALUES
	('en', 'reg_mail', 'Email');

-- Exportiere Struktur von Tabelle db_winx.questions
CREATE TABLE IF NOT EXISTS `questions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `topic` enum('music','ch-norris','animals','movies','d-n-d','astronautics','technology','ai','geography','sports','science','informatics','gen-knowledge','general') COLLATE utf8mb4_unicode_ci NOT NULL,
  `question` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('SINGLE','MULTIPLE') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'SINGLE',
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'animal.jpg',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Exportiere Daten aus Tabelle db_winx.questions: ~66 rows (ungefähr)
REPLACE INTO `questions` (`id`, `topic`, `question`, `type`, `image`) VALUES
	(1, 'geography', 'On which continent lies São Paulo?', 'SINGLE', 'bg_geography.png'),
	(2, 'music', 'Who is the lead singer of the band "Queen"?', 'SINGLE', 'bg_music.png'),
	(3, 'music', 'What is the most famous song of the band "Beatles"?', 'SINGLE', 'bg_music.png'),
	(4, 'music', 'Who is the author of the famous opera "The Barber of Seville"?', 'SINGLE', 'bg_music.png'),
	(5, 'music', 'What is the name of the famous melody composed by Tchaikovsky in 1875-76?', 'SINGLE', 'bg_music.png'),
	(6, 'music', 'What is the name of the famous jazz standard composed by George Gershwin in 1924?', 'SINGLE', 'bg_music.png'),
	(7, 'geography', 'What is the largest country in the world by area?', 'SINGLE', 'bg_geography.png'),
	(8, 'geography', 'What is the capital city of Italy?', 'SINGLE', 'bg_geography.png'),
	(9, 'geography', 'What is the currency used in Spain?', 'SINGLE', 'bg_geography.png'),
	(10, 'geography', 'Which African country is known as the "Horn of Africa"?', 'SINGLE', 'bg_geography.png'),
	(11, 'geography', 'What is the smallest country in the world by area?', 'SINGLE', 'bg_geography.png'),
	(12, 'music', 'What is the name of the famous hip-hop album released by Tupac in 1996?', 'SINGLE', 'bg_music.png'),
	(13, 'music', 'Who is the author of the famous rock song "Stairway to Heaven"?', 'SINGLE', 'bg_music.png'),
	(14, 'music', 'What is the name of the famous song performed by Michael Jackson in 1982?', 'SINGLE', 'bg_music.png'),
	(15, 'music', 'What is the name of the famous song performed by Elvis Presley in 1957?', 'SINGLE', 'bg_music.png'),
	(16, 'music', 'What is the name of the famous song performed by Adele in 2011?', 'SINGLE', 'bg_music.png'),
	(17, 'ch-norris', 'Which movie starred Chuck Norris as the lead role?', 'SINGLE', 'bg_chnorris.png'),
	(18, 'ch-norris', 'What is the real name of Chuck Norris?', 'SINGLE', 'bg_chnorris.png'),
	(19, 'ch-norris', 'What is Chuck Norris famous for?', 'SINGLE', 'bg_chnorris.png'),
	(20, 'ch-norris', 'What kind of belt does Chuck Norris hold in martial arts?', 'SINGLE', 'bg_chnorris.png'),
	(21, 'ch-norris', 'Which year was Chuck Norris born?', 'SINGLE', 'bg_chnorris.png'),
	(22, 'animals', 'What is the scientific name for domestic cat?', 'SINGLE', 'bg_animals.png'),
	(23, 'animals', 'Which animal is known as the king of the jungle?', 'SINGLE', 'bg_animals.png'),
	(24, 'animals', 'What is the largest living bird by height?', 'SINGLE', 'bg_animals.png'),
	(25, 'animals', 'What is the smallest mammal in the world?', 'SINGLE', 'bg_animals.png'),
	(26, 'animals', 'What is the national bird of the United States?', 'SINGLE', 'bg_animals.png'),
	(27, 'movies', 'What is the highest-grossing movie of all time (unadjusted for inflation)?', 'SINGLE', 'bg_movies.png'),
	(28, 'movies', 'Which movie won the Best Picture Oscar in 2020?', 'SINGLE', 'bg_movies.png'),
	(29, 'movies', 'Who directed the movie "The Shawshank Redemption"?', 'SINGLE', 'bg_movies.png'),
	(30, 'movies', 'What is the real name of the actor who played Indiana Jones?', 'SINGLE', 'bg_movies.png'),
	(31, 'gen-knowledge', 'What are the Great Lakes of North America?', 'MULTIPLE', 'bg_genknowledge.png'),
	(32, 'gen-knowledge', 'Who were the first two people to walk on the Moon?', 'MULTIPLE', 'bg_genknowledge.png'),
	(33, 'gen-knowledge', 'What are the three main branches of government in the United States?', 'MULTIPLE', 'bg_genknowledge.png'),
	(34, 'gen-knowledge', 'What are the four seasons in a year?', 'MULTIPLE', 'bg_genknowledge.png'),
	(35, 'gen-knowledge', 'Which are the continents on Earth?', 'MULTIPLE', 'bg_genknowledge.png'),
	(36, 'gen-knowledge', 'Who are the first two US Presidents?', 'MULTIPLE', 'bg_genknowledge.png'),
	(37, 'gen-knowledge', 'What are the four basic elements of nature?', 'MULTIPLE', 'bg_genknowledge.png'),
	(38, 'gen-knowledge', 'Who are the four main characters in the novel "To Kill a Mockingbird"?', 'MULTIPLE', 'bg_genknowledge.png'),
	(39, 'gen-knowledge', 'What are the five oceans on Earth?', 'MULTIPLE', 'bg_genknowledge.png'),
	(40, 'gen-knowledge', 'Who are the three stooges?', 'MULTIPLE', 'bg_genknowledge.png'),
	(41, 'gen-knowledge', 'What are the seven wonders of the ancient world?', 'MULTIPLE', 'bg_genknowledge.png'),
	(42, 'gen-knowledge', 'Who are the two main characters in the novel "Pride and Prejudice"?', 'MULTIPLE', 'bg_genknowledge.png'),
	(43, 'gen-knowledge', 'What are the three colors in the French flag?', 'MULTIPLE', 'bg_genknowledge.png'),
	(44, 'gen-knowledge', 'Who are the four founding fathers of the United States?', 'MULTIPLE', 'bg_genknowledge.png'),
	(45, 'astronautics', 'What are the three main parts of a typical spacecraft?', 'MULTIPLE', 'bg_astronautics.png'),
	(46, 'astronautics', 'What are the four planets in our solar system with rings?', 'MULTIPLE', 'bg_astronautics.png'),
	(47, 'astronautics', 'Who were the first two astronauts to walk on the Moon?', 'MULTIPLE', 'bg_astronautics.png'),
	(48, 'astronautics', 'What are the three main components of the International Space Station (ISS)?', 'MULTIPLE', 'bg_astronautics.png'),
	(49, 'astronautics', 'Who were the first astronauts to fly in space?', 'MULTIPLE', 'bg_astronautics.png'),
	(50, 'astronautics', 'Who were the first astronauts to fly in the Space Shuttle program?', 'MULTIPLE', 'bg_astronautics.png'),
	(51, 'astronautics', 'What are the four main stages of a typical rocket launch?', 'MULTIPLE', 'bg_astronautics.png'),
	(52, 'astronautics', 'What are the two main types of spacecraft propulsion systems?', 'MULTIPLE', 'bg_astronautics.png'),
	(53, 'movies', 'Which of the following actors have portrayed James Bond in a movie?', 'MULTIPLE', 'bg_movies.png'),
	(54, 'movies', 'Which of the following actresses won an Academy Award for Best Actress?', 'MULTIPLE', 'bg_movies.png'),
	(55, 'movies', 'Which of the following movies won the Academy Award for Best Picture?', 'MULTIPLE', 'bg_movies.png'),
	(56, 'movies', 'Which of the following movies was directed by Steven Spielberg?', 'MULTIPLE', 'bg_movies.png'),
	(57, 'movies', 'Which of the following movies is based on a book by Stephen King?', 'MULTIPLE', 'bg_movies.png'),
	(58, 'movies', 'Which of the following actors played the character of Batman in a movie?', 'MULTIPLE', 'bg_movies.png'),
	(59, 'movies', 'Which of the following movies is a Disney animated classic?', 'MULTIPLE', 'bg_movies.png'),
	(60, 'movies', 'Which of the following actors have won an Academy Award for Best Actor?', 'MULTIPLE', 'bg_movies.png'),
	(61, 'general', 'Are you smart or not?', 'SINGLE', 'bg_general'),
	(62, 'music', 'Which of the following bands are considered part of the "British Invasion" of the 1960s?', 'MULTIPLE', 'bg_music.png'),
	(63, 'music', 'Which of the following musicians won the Grammy Award for Album of the Year?', 'MULTIPLE', 'bg_music.png'),
	(64, 'music', 'Which of the following bands have been inducted into the Rock and Roll Hall of Fame?', 'MULTIPLE', 'bg_music.png'),
	(65, 'music', 'Which of the following musicians have won the Nobel Prize in Literature?', 'MULTIPLE', 'bg_music.png'),
	(66, 'music', 'Which of the following songs have won the Grammy Award for Record of the Year?', 'MULTIPLE', 'bg_music.png');

-- Exportiere Struktur von Tabelle db_winx.summary
CREATE TABLE IF NOT EXISTS `summary` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `question_id` int(11) NOT NULL,
  `answer` varchar(50) NOT NULL,
  `correct` tinyint(4) NOT NULL DEFAULT '0',
  `timest` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=120 DEFAULT CHARSET=utf8mb4 COMMENT='Quiz Log des Opportunity quizes';

-- Exportiere Daten aus Tabelle db_winx.summary: ~119 rows (ungefähr)
REPLACE INTO `summary` (`id`, `user_id`, `question_id`, `answer`, `correct`, `timest`) VALUES
	(1, 1, 1, '3', 3, '1675163623'),
	(2, 1, 7, '1', 1, '1675163627'),
	(3, 1, 8, '4', 4, '1675163632'),
	(4, 1, 9, '1', 1, '1675163638'),
	(5, 1, 10, '1', 4, '1675163645'),
	(6, 1, 11, '3', 3, '1675163655'),
	(7, 1, 2, '2', 0, '1678272461'),
	(8, 1, 3, '2', 0, '1678272474'),
	(9, 1, 4, '2', 0, '1678272477'),
	(10, 1, 5, '2', 0, '1678272487'),
	(11, 1, 6, '1', 0, '1678272491'),
	(12, 1, 12, '1', 0, '1678272494'),
	(13, 1, 13, '1', 0, '1678272498'),
	(14, 1, 14, '1', 0, '1678272502'),
	(15, 1, 15, '1', 0, '1678272505'),
	(16, 1, 16, '1', 0, '1678272509'),
	(17, 1, 17, '4', 1, '1675164238'),
	(18, 1, 18, '1', 1, '1675164244'),
	(19, 1, 19, '3', 1, '1675164249'),
	(20, 1, 20, '1', 1, '1675164255'),
	(21, 1, 21, '1', 1, '1675164259'),
	(22, 2, 1, '2', 0, '1675853469'),
	(23, 2, 7, '1', 0, '1675853473'),
	(24, 2, 8, '4', 0, '1675853476'),
	(25, 2, 9, '1', 0, '1675853482'),
	(26, 2, 10, '3', 0, '1675853488'),
	(27, 2, 11, '3', 0, '1675853493'),
	(28, 6, 27, '2', 0, '1675861233'),
	(29, 6, 28, '2', 0, '1675861245'),
	(30, 6, 29, '2', 0, '1675861251'),
	(31, 6, 30, '1', 0, '1675861257'),
	(32, 4, 1, '3', 0, '1676015799'),
	(33, 4, 7, '1', 0, '1676015808'),
	(34, 4, 8, '4', 0, '1676015812'),
	(35, 4, 9, '1', 0, '1676015818'),
	(36, 4, 10, '4', 0, '1676015867'),
	(37, 4, 11, '3', 0, '1676015881'),
	(38, 3, 1, '2', 0, '1676540161'),
	(39, 3, 7, '1', 0, '1676540164'),
	(40, 3, 8, '1', 0, '1676540223'),
	(41, 3, 9, '1', 0, '1676540234'),
	(42, 4, 2, '5', 0, '1676037814'),
	(43, 4, 3, '1', 0, '1676037816'),
	(44, 4, 4, '1', 0, '1676037738'),
	(45, 4, 5, '1', 0, '1676037790'),
	(46, 4, 6, '5', 0, '1676037793'),
	(47, 4, 12, '5', 0, '1676037796'),
	(48, 4, 13, '5', 0, '1676037799'),
	(49, 4, 14, '5', 0, '1676037802'),
	(50, 4, 15, '5', 0, '1676037804'),
	(51, 4, 16, '1', 0, '1676037807'),
	(52, 3, 45, '1', 0, '1676537002'),
	(53, 3, 46, '3', 0, '1676537005'),
	(54, 3, 47, '1', 0, '1676537008'),
	(55, 3, 48, '1', 0, '1676537010'),
	(56, 3, 49, '1', 0, '1676537013'),
	(57, 3, 50, '1', 0, '1676537015'),
	(58, 3, 51, '1', 0, '1676537018'),
	(59, 3, 52, '1', 0, '1676537021'),
	(60, 3, 10, '1', 0, '1676540250'),
	(61, 3, 11, '1', 0, '1676540395'),
	(62, 3, 27, '4', 0, '1676540407'),
	(63, 3, 28, '1', 0, '1676540452'),
	(64, 3, 29, '4', 0, '1676540457'),
	(65, 3, 30, '3', 0, '1676540492'),
	(66, 3, 53, '3', 0, '1676540495'),
	(67, 3, 54, '2', 0, '1676540523'),
	(68, 3, 55, '3', 0, '1676540527'),
	(69, 3, 56, '1', 0, '1676540590'),
	(70, 3, 57, '1', 0, '1676540595'),
	(71, 3, 61, '1', 0, '1676468641'),
	(72, 3, 17, '5', 0, '1676468620'),
	(73, 3, 18, '1', 0, '1676468623'),
	(74, 3, 19, '3', 0, '1676468625'),
	(75, 3, 20, '5', 0, '1676468628'),
	(76, 3, 21, '3', 0, '1676468630'),
	(77, 3, 2, '3', 0, '1676476392'),
	(78, 3, 3, '1', 0, '1676476395'),
	(79, 3, 4, '1', 0, '1676472564'),
	(80, 3, 5, '2', 0, '1676472568'),
	(81, 3, 6, '4', 0, '1676472571'),
	(82, 3, 12, '2', 0, '1676472575'),
	(83, 3, 13, '1', 0, '1676472578'),
	(84, 3, 14, '2', 0, '1676472581'),
	(85, 3, 15, '1', 0, '1676472585'),
	(86, 3, 16, '2', 0, '1676472588'),
	(87, 3, 62, '3', 0, '1676472598'),
	(88, 3, 63, '3', 0, '1676472603'),
	(89, 3, 64, '4', 0, '1676472610'),
	(90, 3, 65, '2', 0, '1676472613'),
	(91, 3, 66, '4', 0, '1676472622'),
	(92, 3, 58, '1', 0, '1676540649'),
	(93, 3, 59, '1', 0, '1676540682'),
	(94, 3, 60, '1', 0, '1676540732'),
	(95, 1, 62, '3', 0, '1678272514'),
	(96, 1, 63, '2', 0, '1678272517'),
	(97, 1, 64, '3', 0, '1678272525'),
	(98, 1, 65, '2', 0, '1678272535'),
	(99, 1, 66, '2', 0, '1678272541'),
	(100, 1, 27, '3', 0, '1678272572'),
	(101, 1, 28, '3', 0, '1678272575'),
	(102, 1, 29, '3', 0, '1678272578'),
	(103, 1, 30, '2', 0, '1678272582'),
	(104, 1, 53, '3', 0, '1678272586'),
	(105, 1, 54, '3', 0, '1678272589'),
	(106, 1, 55, '3', 0, '1678272593'),
	(107, 1, 56, '3', 0, '1678272596'),
	(108, 1, 57, '3', 0, '1678272600'),
	(109, 1, 58, '3', 0, '1678272604'),
	(110, 1, 59, '3', 0, '1678272607'),
	(111, 1, 60, '2', 0, '1678272611'),
	(112, 1, 45, '2', 0, '1678272670'),
	(113, 1, 46, '4', 0, '1678272783'),
	(114, 1, 47, '3', 0, '1678272787'),
	(115, 1, 48, '2', 0, '1678272790'),
	(116, 1, 49, '1', 0, '1678272793'),
	(117, 1, 50, '2', 0, '1678272796'),
	(118, 1, 51, '1', 0, '1678272800'),
	(119, 1, 52, '2', 0, '1678272803');

-- Exportiere Struktur von Tabelle db_winx.users
CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(18) NOT NULL DEFAULT '0',
  `password_sha256` varchar(1024) NOT NULL,
  `email` varchar(50) NOT NULL DEFAULT 'standard@email.com',
  `created_at` varchar(50) DEFAULT NULL,
  `last_login` varchar(50) DEFAULT NULL,
  `ip` varchar(50) NOT NULL,
  `score` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='Benutzer Tabelle oop Project 1 PHP Quiz';

-- Exportiere Daten aus Tabelle db_winx.users: ~4 rows (ungefähr)
REPLACE INTO `users` (`id`, `username`, `password_sha256`, `email`, `created_at`, `last_login`, `ip`, `score`) VALUES
	(1, 'Trojan', 'dd67797d20b32f6df658be198b2fcd9d4e78fc6dc6861f798a10cc9b657c5417', 'sven.bledt@gmail.com', '1674738529', '1678272396', '172.26.0.1', 0),
	(2, 'Mogendar', '84fb3fdda934bf6e466529bcd728ac9a65e0abbe868709fa1d74b117345b891b', 'daniel00007.dks@gmail.com', '1675851073', '1676294775', '172.23.0.1', 0),
	(3, 'Krakatoom77', '0114faa0b64d2703d61cb61a006f826418ce9a1ff96cf43ce9a59bca1401474b', 'gaudenzraiber@yahoo.de', '1675851501', '1676536953', '172.30.0.1', 0),
	(4, 'Test', '1637143595870f8b2482c12ad3b1e28a66e937a308349d996e5b57689db0e0e6', 'testuser1922@hotmail.com', '1675861163', '1676037150', '172.23.0.1', 0);

/*!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) */;