added upgrade scripts
restored some scr
updated views