Create views and procedures

please check the database to see the views and procedures,
i have also updated some data
and we need to review the procedures, it seems like some php on the front end don't match the PHPADMIN tables. i will review tomorrow.