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');    


CREATE TABLE `micovendb`.`cliente` (
  `whatsapp` VARCHAR(15) NOT NULL,
  `nombre` VARCHAR(150) NOT NULL,
  `apellidopaterno` VARCHAR(150) NOT NULL,
  `apellidomaterno` VARCHAR(150) NULL,
  PRIMARY KEY (`whatsapp`));


CREATE TABLE `micovendb`.`cuenta` (
  `idmovimiento` INT NOT NULL AUTO_INCREMENT,
  `whatsapp` VARCHAR(15) NOT NULL,
  `concepto` VARCHAR(200) NOT NULL,
  `fecha` DATE NOT NULL,
  `monto` DECIMAL(10,2) NOT NULL,
  `tipomovimiento` VARCHAR(100) NOT NULL,
  PRIMARY KEY (`idmovimiento`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;