--
-- Host: 127.0.0.1    Database: fuego_games
-- ------------------------------------------------------


--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `version` varchar(255) NOT NULL,
  `class` varchar(255) NOT NULL,
  `group` varchar(255) NOT NULL,
  `namespace` varchar(255) NOT NULL,
  `time` int(11) NOT NULL,
  `batch` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=139 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (134,'2022-05-25-165850','App\\Database\\Migrations\\Usuarios','default','App',1654865540,1),(135,'2022-05-27-125212','App\\Database\\Migrations\\Quiz','default','App',1654865540,1),(136,'2022-05-29-201101','App\\Database\\Migrations\\QuizAlternativas','default','App',1654865540,1),(137,'2022-05-30-015330','App\\Database\\Migrations\\QuizPerguntas','default','App',1654865540,1),(138,'2022-06-07-025633','App\\Database\\Migrations\\RespostasGames','default','App',1654865540,1);

--
-- Table structure for table `quiz`
--

CREATE TABLE `quiz` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `titulo` varchar(350) NOT NULL,
  `evento` varchar(150) NOT NULL,
  `cliente` varchar(250) NOT NULL,
  `corFundoTela` varchar(10) NOT NULL,
  `corBotaoStart` varchar(10) NOT NULL,
  `corFundoTitulo` varchar(10) NOT NULL,
  `corFundoTempo` varchar(10) NOT NULL,
  `corTextoTela` varchar(10) NOT NULL,
  `corTextoBotaoStart` varchar(10) NOT NULL,
  `corTextoTitulo` varchar(10) NOT NULL,
  `corTextoTempo` varchar(10) NOT NULL,
  `qtRegistrosRanking` int(5) NOT NULL,
  `imagemFundoRanking` varchar(150) NOT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `quiz`
--

INSERT INTO `quiz` VALUES (1,'Novo Quiz 2','hypera','Default Cliente','#1b5c9e','#595959','#CCCCCC','#343a40','#343a40','#ffffff','#CCCCCC','Default Cl',0,'','2022-06-10 09:52:44','2022-06-23 20:13:47',1);

--
-- Table structure for table `quizAlternativas`
--

CREATE TABLE `quizAlternativas` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `titulo` varchar(350) NOT NULL,
  `peso` int(10) NOT NULL,
  `idQuizPergunta` int(10) NOT NULL,
  `respostaCorreta` int(10) NOT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `quizAlternativas`
--

INSERT INTO `quizAlternativas` VALUES (1,'Alternativa A',0,1,1,'2022-06-10 09:52:53','2022-06-10 09:52:53',1),(2,'Alternativa B',0,1,0,'2022-06-10 09:52:53','2022-06-10 09:52:53',1),(3,'Alternativa C',0,1,0,'2022-06-10 09:52:53','2022-06-10 09:52:53',1),(4,'Alternativa AA',0,2,1,'2022-06-10 09:52:53','2022-06-10 09:52:53',1),(5,'Alternativa BB',0,2,0,'2022-06-10 09:52:53','2022-06-10 09:52:53',1),(6,'Alternativa BC',0,2,0,'2022-06-10 09:52:53','2022-06-10 09:52:53',1),(7,'Alternativa AAA',0,3,1,'2022-06-10 09:52:53','2022-06-10 09:52:53',1),(8,'Alternativa BBB',0,3,0,'2022-06-10 09:52:53','2022-06-10 09:52:53',1),(9,'Alternativa BBC',0,3,0,'2022-06-10 09:52:53','2022-06-10 09:52:53',1);

--
-- Table structure for table `quizPerguntas`
--

CREATE TABLE `quizPerguntas` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `titulo` varchar(350) NOT NULL,
  `peso` int(10) NOT NULL,
  `tempo` int(10) NOT NULL,
  `idQuiz` int(10) NOT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `quizPerguntas`
--

INSERT INTO `quizPerguntas` VALUES (1,'Pergunta Padrão 1 2',50,60,1,'2022-06-10 09:52:49','2022-06-23 20:14:33',1),(2,'Pergunta Padrão 2',50,60,1,'2022-06-10 09:52:49','2022-06-10 09:52:49',1),(3,'Pergunta Padrão 3',50,60,1,'2022-06-10 09:52:49','2022-06-10 09:52:49',1);

--
-- Table structure for table `respostasGames`
--

CREATE TABLE `respostasGames` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `nome` varchar(250) NOT NULL,
  `idCadastro` int(10) NOT NULL,
  `idPergunta` int(10) NOT NULL,
  `idAlternativa` int(10) NOT NULL,
  `tempoInicio` int(10) NOT NULL,
  `tempoFim` int(10) NOT NULL,
  `tempo` int(10) NOT NULL,
  `peso` int(10) NOT NULL,
  `respostaCorreta` int(10) NOT NULL,
  `respostaSelecionada` int(10) NOT NULL,
  `acertou` int(2) NOT NULL,
  `plataforma` varchar(100) NOT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `respostasGames`
--

INSERT INTO `respostasGames` VALUES (37,'diego',2,1,1,60,58,2,50,0,0,1,'','2022-06-19 21:16:15','2022-06-19 21:16:15',0),(38,'diego',2,2,5,60,0,0,50,0,1,0,'','2022-06-19 21:16:16','2022-06-19 21:16:16',0),(48,'diego',2,3,7,60,660,-600,50,0,0,1,'','2022-06-20 07:31:12','2022-06-20 07:31:12',0);


