Mercurial > hg > purlService

comparison 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
comparison
equal deleted inserted replaced
-1:000000000000 0:08a476cdcfea
1 -- Table: purls
2
3 -- DROP TABLE purls;
4
5 CREATE TABLE purls
6 (
7 purl text NOT NULL,
8 path text,
9 is_index_meta boolean NOT NULL,
10 created_by text,
11 created_at timestamp with time zone,
12 last_change_by text,
13 last_change_at text,
14 validity integer NOT NULL,
15 server_url text,
16 CONSTRAINT purl PRIMARY KEY (purl )
17 )
18 WITH (
19 OIDS=FALSE
20 );
21 ALTER TABLE purls
22 OWNER TO postgres;
23 GRANT ALL ON TABLE purls TO postgres;
24 GRANT ALL ON TABLE purls TO "purlUSER";