CREATE TABLE users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(100) NOT NULL,
  email VARCHAR(120) NOT NULL UNIQUE,
  password_hash VARCHAR(255) NOT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE products (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(120) NOT NULL,
  price INT NOT NULL,
  image_url TEXT NULL,
  description TEXT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE articles (
  id INT AUTO_INCREMENT PRIMARY KEY,
  title VARCHAR(160) NOT NULL,
  content TEXT NOT NULL,
  image_url TEXT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Optional seed
INSERT INTO articles(title, content, image_url) VALUES
('Tips Memilih Skincare', 'Kenali jenis kulitmu dulu ya...', 'https://picsum.photos/600/400?1'),
('Cara Memilih Lipstik', 'Pilih warna sesuai undertone...', 'https://picsum.photos/600/400?2');

INSERT INTO products(name, price, image_url, description) VALUES
('Beauty Blender', 25000, 'https://picsum.photos/600/600?3', 'Spons makeup lembut.'),
('Brush Set', 85000, 'https://picsum.photos/600/600?4', 'Satu set kuas lengkap.'),
('Skincare Headband', 15000, 'https://picsum.photos/600/600?5', 'Biar hairline aman saat skincare.');
