Conteúdo do arquivo

-- -----------------------------------------------------
-- Schema listajsp
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `listajsp` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
USE `listajsp` ;

-- -----------------------------------------------------
-- Table `listajsp`.`pedidos`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `listajsp`.`pedidos` (
  `idpedidos` INT NOT NULL AUTO_INCREMENT,
  `nomeCliente` VARCHAR(145) NOT NULL,
  `enderecoEntrega` VARCHAR(200) NULL,
  `valor` DECIMAL(10,2) NOT NULL,
  `descricao` VARCHAR(300) NULL,
  PRIMARY KEY (`idpedidos`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `listajsp`.`usuario`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `listajsp`.`usuario` (
  `login` VARCHAR(50) NOT NULL,
  `senha` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`login`))
ENGINE = InnoDB;