DROP TABLE people CASCADE;
DROP TABLE people_audit;

CREATE TABLE people (
  person_id SERIAL PRIMARY KEY
, first_name TEXT NOT NULL
, middle_name TEXT
, last_name TEXT
);

CREATE TABLE people_audit (
  actor TEXT NOT NULL DEFAULT current_user
, action TEXT NOT NULL CHECK(action IN ('INSERT', 'UPDATE', 'DELETE'))
, action_timestamp TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT current_timestamp
, old_people people
, new_people people
);