CREATE TABLE users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  username VARCHAR(50) UNIQUE NOT NULL,
  password_hash VARCHAR(255) NOT NULL,
  fullname VARCHAR(100) NOT NULL,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE palettes (
  id INT AUTO_INCREMENT PRIMARY KEY,
  produit VARCHAR(255) NOT NULL,
  sscc VARCHAR(50) UNIQUE NOT NULL,
  gtin VARCHAR(50) NOT NULL,
  motif VARCHAR(255) DEFAULT NULL,
  zone VARCHAR(100) DEFAULT NULL,
  commentaire TEXT DEFAULT NULL,
  created_by INT NOT NULL,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  archived TINYINT(1) DEFAULT 0,
  FOREIGN KEY (created_by) REFERENCES users(id)
);