CREATE DATABASE faceid CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE faceid;

CREATE TABLE users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  nombre VARCHAR(120) NOT NULL,
  telefono VARCHAR(40),
  email VARCHAR(160) UNIQUE,
  selfie_path VARCHAR(255) NOT NULL,
  descriptor JSON NOT NULL,
  creado_en TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
