removed unnecessary variable
fixed sql statement errors; removed redundant function call; added transactions
added git attributes file