CREATE TABLE IF NOT EXISTS adverts (id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,title VARCHAR(180) NOT NULL,image VARCHAR(100) NOT NULL DEFAULT '',destination VARCHAR(1000) NOT NULL,placement VARCHAR(20) NOT NULL DEFAULT 'sidebar',starts DATE NOT NULL,ends DATE NOT NULL,sort_order INT NOT NULL DEFAULT 0,active TINYINT NOT NULL DEFAULT 0,created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP);