Setting Up Local SQL Database

1. Install and Configure XAMPP

Install xampp from here: https://sourceforge.net/projects/xampp/files/XAMPP%20Mac%20OS%20X/8.0.2/. After installing, there will be xampp folder in your Applications. Open xamppfiles folder, and find the manager-osx file of type application. Open it and start MySQL database and Apache Web Server under manage servers.

2. Set up SQL Database

Go to http://localhost/phpmyadmin/ to set up the database. Click New and create a database called “analysis”. Then, with the analysis database selected, navigate to the SQL tab. Paste in the following query and click “Go” at the bottom of the page to create a table named “entries”: CREATE TABLE entries (id INTEGER PRIMARY KEY AUTO_INCREMENT, site_id INTEGER, domain varchar(255), dns_link BOOLEAN, sent_gpc BOOLEAN, uspapi_before_gpc varchar(255), uspapi_after_gpc varchar(255),uspapi_opted_out varchar(255), usp_cookies_before_gpc varchar(255), usp_cookies_after_gpc varchar(255), usp_cookies_opted_out varchar(255));