CREATE TABLE drive_offers (
  id INT AUTO_INCREMENT PRIMARY KEY,
  operator VARCHAR(50),
  name VARCHAR(100),
  price FLOAT,
  discount FLOAT,
  buyrate FLOAT,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE offer_requests (
  id INT AUTO_INCREMENT PRIMARY KEY,
  userid INT,
  number VARCHAR(20),
  offer_id INT,
  price FLOAT,
  status VARCHAR(20) DEFAULT 'pending',
  note TEXT,
  image VARCHAR(255),
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);