removed apsolute paths from sql, added composite forign keys