 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
 
-CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
-USE `mydb` ;
+CREATE SCHEMA IF NOT EXISTS `sitap` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
+USE `sitap` ;
 
 -- -----------------------------------------------------
--- Table `mydb`.`tbl_usuario`
+-- Table `sitap`.`tbl_usuario`
 -- -----------------------------------------------------
-CREATE TABLE IF NOT EXISTS `mydb`.`tbl_usuario` (
-  `idusuario` INT NOT NULL,
+CREATE TABLE IF NOT EXISTS `sitap`.`tbl_usuario` (
+  `idusuario` INT NOT NULL AUTO_INCREMENT,
   `nome` VARCHAR(35) NULL,
   `senha` VARCHAR(30) NULL,
   `email` VARCHAR(40) NULL,

  `estado` VARCHAR(45) NULL,
  `endereco` VARCHAR(45) NULL,
  `cep` VARCHAR(45) NULL,
  `tbl_usuariocol` VARCHAR(45) NULL,
  PRIMARY KEY (`idusuario`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`tbl_admin`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`tbl_admin` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `nome` VARCHAR(45) NULL,
  `senha` VARCHAR(45) NULL,

  INDEX `fk_tbl_artigo_has_tbl_fotos_tbl_artigo1_idx` (`tbl_artigo_id` ASC),
  CONSTRAINT `fk_tbl_artigo_has_tbl_fotos_tbl_artigo1`
    FOREIGN KEY (`tbl_artigo_id`)
    REFERENCES `sitap`.`tbl_artigo` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_tbl_artigo_has_tbl_fotos_tbl_fotos1`
    FOREIGN KEY (`tbl_fotos_id`)
    REFERENCES `sitap`.`tbl_fotos` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `sitap`.`tbl_categoria`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sitap`.`tbl_categoria` (
  `id` INT NOT NULL,
  `nome` VARCHAR(45) NULL,
  `descricao` VARCHAR(100) NULL,
