updated db tables and added resources