 GRANT select, insert, update ON TABLE users.collectionContents to userManager;
 
 /*Append only collection history is VERY important*/
-GRANT select, insert ON TABLE users.collectionHistory to userManager;+GRANT select, insert ON TABLE users.collectionHistory to userManager;
+
+/*
+Set a backup user up so we are able to remotely dump table contents and
+nothing else.
+
+Backups can be safely run using
+'pg_dump -d userdata -U usermanager -f TARGET.sql'
+or -f omitted and piped to gzip!
+*/
+
+CREATE ROLE backupper WITH
+	LOGIN
+	ENCRYPTED
+	PASSWORD '$insertAnotherPasswordHere';
+
+GRANT usage ON SCHEMA public, users to backupper; 
+GRANT connect ON DATABASE userdata TO backupper;
+GRANT select ON ALL TABLES IN SCHEMA users TO backupper;
	
	lastUpdate timestamp NOT NULL,

	FOREIGN KEY (owner, collection) REFERENCES users.collections (owner, name),

	CONSTRAINT uniqueHistoryKey UNIQUE (owner, collection,
										cardName, setName,


This single table allows us to rebuild the complete, publicly visible
database.

NOTICE: No foreign key dependency as we want to be capable of rebuilding from
        this single table.

        Thus, we track when a row was created to avoid potential future issues
*/
CREATE TABLE users.collectionHistory (

