-- TABLE 1: users
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
);

-- TABLE 2: houses (katalog rumah)
CREATE TABLE houses (
  id INT AUTO_INCREMENT PRIMARY KEY,
  title VARCHAR(150) NOT NULL,
  price BIGINT NOT NULL DEFAULT 0,
  location VARCHAR(150) NOT NULL,
  description TEXT,
  image_url VARCHAR(255),
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- TABLE 3: articles (artikel)
CREATE TABLE articles (
  id INT AUTO_INCREMENT PRIMARY KEY,
  title VARCHAR(150) NOT NULL,
  body TEXT NOT NULL,
  image_url VARCHAR(255),
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Seed contoh data
INSERT INTO houses(title, price, location, description, image_url)
VALUES
('Rumah Minimalis Type 45', 350000000, 'Medan', 'Dekat pusat kota, 2 kamar, 1 kamar mandi.',
 'https://picsum.photos/seed/house1/600/400'),
('Rumah Modern Type 90', 850000000, 'Jakarta', '3 kamar, 2 kamar mandi, carport.',
 'https://picsum.photos/seed/house2/600/400');

INSERT INTO articles(title, body, image_url)
VALUES
('Tips Membeli Rumah Pertama', 'Berikut tips membeli rumah pertama: cek lokasi, legalitas, budget, dll...',
 'https://picsum.photos/seed/article1/600/400');