CREATE TABLE IF NOT EXISTS treks (
  id SERIAL PRIMARY KEY,
  name VARCHAR(200) NOT NULL,
  destination VARCHAR(200) NOT NULL,
  duration_days INTEGER NOT NULL,
  max_group_size INTEGER NOT NULL DEFAULT 12,
  price_npr INTEGER NOT NULL,
  price_usd INTEGER NOT NULL,
  description TEXT,
  difficulty VARCHAR(50) NOT NULL DEFAULT 'moderate'
);

CREATE TABLE IF NOT EXISTS bookings (
  id SERIAL PRIMARY KEY,
  trek_id INTEGER NOT NULL REFERENCES treks(id),
  customer_name VARCHAR(200) NOT NULL,
  customer_email VARCHAR(200) NOT NULL,
  group_size INTEGER NOT NULL DEFAULT 1,
  booking_date DATE NOT NULL,
  status VARCHAR(50) NOT NULL DEFAULT 'pending',
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);