text: DROP TABLE IF EXISTS audit.credentials;
  CREATE TABLE audit.credentials
  (
  	audit_id SERIAL NOT NULL PRIMARY KEY,
  	operation CHAR(1)   NOT NULL,
  	actioned_ts TIMESTAMP NOT NULL DEFAULT NOW(),
  
  	id INTEGER NOT NULL,
  	inserted_ts TIMESTAMP NOT NULL,
  	updated_ts TIMESTAMP NOT NULL,
  	actioned_by VARCHAR(25) NULL,
  
  	reason VARCHAR(50)  NOT NULL
  );
  CREATE INDEX idx_audit_credentials_id ON audit.user_profile(id);
  