-- 1. Create table to store active abandoned cart data
CREATE TABLE IF NOT EXISTS scart (
    customers_id INT NOT NULL,
    date_added DATETIME NOT NULL,
    PRIMARY KEY (customers_id)
) ENGINE=InnoDB;

-- 2. Create table to log emails sent (prevents duplicate spamming)
CREATE TABLE IF NOT EXISTS scart_emailed (
    customers_id INT NOT NULL,
    date_emailed DATETIME NOT NULL,
    PRIMARY KEY (customers_id)
) ENGINE=InnoDB;