4.3 Creating Tables and Roles

As a Unix user who is also a postgresql superuser:

$ cd ./provisioning/schema
$ psql trip <10_trip_role.sql
$ psql trip <20_schema.sql
$ psql trip <30_permissions.sql
$ psql trip <35_user_roles.sql

Optionally, populate the database with data that can be used to perform end-to-end tests. Do not insert the test data into a production database as it contains default application admin user credentials.

$ psql trip <90_test-data.sql

• Lookup Tables
• Indexes for Query Performance