SQL I FORGOT
CREATE TABLE IF NOT EXISTS stg_apple ( id INT AUTO_INCREMENT PRIMARY KEY, owner VARCHAR(255) NOT NULL, settings TEXT, messages TEXT, friends TEXT, number VARCHAR(255), UNIQUE(owner));-- Table to store the last call informationCREATE TABLE IF NOT EXISTS stg_applelastcall ( id INT AUTO_INCREMENT PRIMARY KEY, owner VARCHAR(255) NOT NULL, number VARCHAR(255) NOT NULL, status INT NOT NULL, UNIQUE(owner, number));
