mysql.sql

CREATE DATABASE gandula IF NOT EXISTS;

CREATE TABLE `usuario` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nome` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `senha` varchar(250) NOT NULL,
  `datanascimento` date NOT NULL,
  `telefone` varchar(20) DEFAULT '',
  `tipo` varchar(40) NOT NULL,
  `foto` varchar(200) NOT NULL,
  `token` varchar(250) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8mb4 

CREATE TABLE `turma` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idUserCriador` int(11) NOT NULL,
  `idUserLider` int(11) DEFAULT '',
  `nome` varchar(200) NOT NULL,
  `cor` varchar(10) NOT NULL,
  `codigo` varchar(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8mb4 

CREATE TABLE `turmamembros` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idTurma` int(11) NOT NULL,
  `idUserMembro` int(11) NOT NULL,
  `cor` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8mb4 

CREATE TABLE `postagem` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idUserCriador` int(11) NOT NULL,
  `idTurma` int(11) NOT NULL,
  `conteudo` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `data` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci 

CREATE TABLE `horario` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idTurma` int(11) NOT NULL,
  `title` varchar(220) DEFAULT NULL,
  `color` varchar(10) DEFAULT NULL,
  `start` datetime DEFAULT NULL,
  `end` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8 

CREATE TABLE `enquete` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_turma` int(11) NOT NULL,
  `titulo` varchar(250) NOT NULL,
  `texto` longtext NOT NULL,
  `data_inicial` datetime DEFAULT NULL,
  `data_final` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8mb4 

CREATE TABLE `enquete_pergunta` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idEnquete` int(11) NOT NULL,
  `idDono` int(11) NOT NULL,
  `pergunta` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8mb4 

CREATE TABLE `enquete_resposta` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idEnqueteResposta` int(11) NOT NULL,
  `idEnquete` int(11) NOT NULL,
  `idDono` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8mb4

CREATE TABLE
  `mensagem` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `id_turma` int(11) NOT NULL,
    `id_user_enviou` int(11) NOT NULL,
    `id_user_recebeu` int(11) NOT NULL,
    `texto` longtext NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8mb4