pre-massive sql edits update