
CREATE TABLE admin (
  id INT AUTO_INCREMENT PRIMARY KEY,
  username VARCHAR(50) NOT NULL,
  password VARCHAR(255) NOT NULL
);

INSERT INTO admin (username, password) VALUES ('admin', SHA1('admin123'));

CREATE TABLE manual_ads (
  id INT AUTO_INCREMENT PRIMARY KEY,
  reseller_id INT NOT NULL,
  title VARCHAR(255),
  image VARCHAR(500),
  link VARCHAR(500),
  duration INT,
  active TINYINT(1) DEFAULT 1
);
