CREATE SCHEMA `micovendb` DEFAULT CHARACTER SET utf8 ;
    
    CREATE TABLE `micovendb`.`usuario` (
  `email` VARCHAR(200) NOT NULL,
  `nombre` VARCHAR(150) NOT NULL,
  `apellidopaterno` VARCHAR(150) NOT NULL,
  `apellidomaterno` VARCHAR(150) NULL,
  `password` VARCHAR(150) NOT NULL,
  PRIMARY KEY (`email`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;

insert into usuario values ('kapo1978@hotmail.com','José Martín','Lara','López','adminlara');