ignore tmp files
modified comments
renamed file
adjusted to new table structure
fixed audit deletes on view
adjusted table structure to new db layout