update database script to reflect programmatic model