-- Table: purls

-- DROP TABLE purls;

CREATE TABLE purls
(
  purl text NOT NULL,
  path text,
  is_index_meta boolean NOT NULL,
  created_by text,
  created_at timestamp with time zone,
  last_change_by text,
  last_change_at text,
  validity integer NOT NULL,
  server_url text,
  CONSTRAINT purl PRIMARY KEY (purl )
)
WITH (
  OIDS=FALSE
);
ALTER TABLE purls
  OWNER TO postgres;
GRANT ALL ON TABLE purls TO postgres;
GRANT ALL ON TABLE purls TO "purlUSER";