ParkPass setup

Builds the database tables and loads demo data. Safe to run more than once, it will not duplicate anything.

This creates 16 tables: users, parks, precincts, campgrounds, sites, bookings, passes, damage reports, wildlife sightings, maintenance jobs, patrols, closures, operator bookings, capacity readings and an audit log.

Demo accounts

Password for all of them: parkpass2026

EmailRoleWhat they can do
visitor@parkpass.demoPark visitorBook a site, hold passes, report damage and wildlife
ranger@parkpass.demoField rangerWork queue, patrols, track closures
maintenance@parkpass.demoMaintenance officerJob list, assign and close out work
conservation@parkpass.demoConservation officerSightings register, sustainability dashboard
operator@parkpass.demoTour operatorLodge group bookings and permits
admin@parkpass.demoAdministratorEverything, plus users and precincts

Before you submit: delete install.php and db_test.php from the server, and change the demo passwords.