reworked sql file after talking with fontenot. fixed merge error in api/index.php