modified schema, database initialization transactions for testing