appendix A Frogge Emporium database

 

This appendix provides the information needed to create the Frogge Emporium database schema and populate it with sample data.

A.1 Frogge Emporium database schema

To re-create the Frogge Emporium database and user, run the following in psql as user postgres:

CREATE USER frogge PASSWORD <password>;
CREATE DATABASE frogge OWNER frogge;

Then you can create the schema by running the file schema.sql as follows from the command line:

psql -U frogge -f schema.sql

schema.sql can be found at https://github.com/vyruss/postgresql-mistakes/.

The content of schema.sql is as follows:

A.2 Frogge Emporium database data