Project consists of 3 items:
1) Create PHP API script, consist of 11 quite simple functions, every each one just make operations on SQL and returns to requester some data. Operations like simple insert/update/delete/select, nothing sophisticated.
example: function1($id) -> get all values from column2 of sql table where column1=$id, and return simple array
2) Create standalone PHP script with 4 functions, 3 of them are just doing SQL operations like gets data from one table, sroting it, changing data in other table, inserts/updates/selects. Also basic MySQL stuff, 1 function is uploading and downloading file from remote API (put_file($name,$raw), get_file($name), transfers are streams (large file support)
3) Create SQL 5 tables for those functions on local server (provided by us), structure (columns, names, data types) are prepared, but we are open to sugestions.