Added show command effect and updated database schema

fixes #135