further angular.js implementation; extend sql schema for security and repository details