Mercurial > hg > purlService

annotate createPurlDB.sql @ 0:08a476cdcfea

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
first
author dwinter
date Wed, 31 Oct 2012 14:57:53 +0100
parents
children fb2a3b4542a4
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
0
dwinter
parents:
diff changeset
1 -- Table: purls
dwinter
parents:
diff changeset
2
dwinter
parents:
diff changeset
3 -- DROP TABLE purls;
dwinter
parents:
diff changeset
4
dwinter
parents:
diff changeset
5 CREATE TABLE purls
dwinter
parents:
diff changeset
6 (
dwinter
parents:
diff changeset
7 purl text NOT NULL,
dwinter
parents:
diff changeset
8 path text,
dwinter
parents:
diff changeset
9 is_index_meta boolean NOT NULL,
dwinter
parents:
diff changeset
10 created_by text,
dwinter
parents:
diff changeset
11 created_at timestamp with time zone,
dwinter
parents:
diff changeset
12 last_change_by text,
dwinter
parents:
diff changeset
13 last_change_at text,
dwinter
parents:
diff changeset
14 validity integer NOT NULL,
dwinter
parents:
diff changeset
15 server_url text,
dwinter
parents:
diff changeset
16 CONSTRAINT purl PRIMARY KEY (purl )
dwinter
parents:
diff changeset
17 )
dwinter
parents:
diff changeset
18 WITH (
dwinter
parents:
diff changeset
19 OIDS=FALSE
dwinter
parents:
diff changeset
20 );
dwinter
parents:
diff changeset
21 ALTER TABLE purls
dwinter
parents:
diff changeset
22 OWNER TO postgres;
dwinter
parents:
diff changeset
23 GRANT ALL ON TABLE purls TO postgres;
dwinter
parents:
diff changeset
24 GRANT ALL ON TABLE purls TO "purlUSER";