Hi Andy,
There are no scripts for the database.
The tables in the database are generated with JPA Entities.
For example entities SessionInfo, WorkItemInfo, ProcessInstanceInfo)are classes with @ Entity annotation. These classes are within drools-persistence-jpa.jar and the tables are created when you deploy jpbm-console-server.