-- create a table
CREATE TABLE clientes (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  apellidos TEXT NOT NULL,
    correo TEXT NOT NULL,
    telefono TEXT NOT NULL);


CREATE TABLE mascotas (
id_mascota INTEGER PRIMARY KEY,
    nombre TEXT NOT NULL,
    raza TEXT NOT NULL,
    edad INT
    );
-- insert some values
INSERT INTO clientes VALUES (2008, 'Matias', 'Balderas', 'matias10@gmail.com', '5546737654' );
INSERT INTO clientes VALUES (2010, 'Joanna', 'Flores', 'joanna29@gmail.com', '5684934532');
INSERT INTO clientes VALUES (2007, 'daniel', 'francisto', 'francisco94@gmail.com', '5599334673' );
INSERT INTO mascotas VALUES (2004, 'negro', 'chihuahua', 13);
INSERT INTO mascotas VALUES (2003, 'blanco', 'maxtil', 9);

    
-- fetch some values
SELECT * FROM clientes;
SELECT * FROM mascotas;