updating schema, adding transactions for user stub