--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/createPurlDB.sql	Wed Oct 31 14:57:53 2012 +0100
@@ -0,0 +1,24 @@
+-- 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";