|
2
|
1 -- Database: "purlDB"
|
|
|
2
|
|
|
3 -- DROP DATABASE "purlDB";
|
|
|
4
|
|
|
5 CREATE DATABASE "purlDB"
|
|
|
6 WITH OWNER = postgres
|
|
|
7 ENCODING = 'UTF8'
|
|
|
8 TABLESPACE = pg_default
|
|
|
9 LC_COLLATE = 'C'
|
|
|
10 LC_CTYPE = 'C'
|
|
|
11 CONNECTION LIMIT = -1;
|
|
|
12 GRANT CONNECT, TEMPORARY ON DATABASE "purlDB" TO public;
|
|
|
13 GRANT ALL ON DATABASE "purlDB" TO postgres;
|
|
|
14 GRANT ALL ON DATABASE "purlDB" TO "purlUSER";
|
|
|
15
|
|
|
16
|
|
0
|
17 -- Table: purls
|
|
|
18
|
|
|
19 -- DROP TABLE purls;
|
|
|
20
|
|
|
21 CREATE TABLE purls
|
|
|
22 (
|
|
|
23 purl text NOT NULL,
|
|
|
24 path text,
|
|
|
25 is_index_meta boolean NOT NULL,
|
|
|
26 created_by text,
|
|
|
27 created_at timestamp with time zone,
|
|
|
28 last_change_by text,
|
|
|
29 last_change_at text,
|
|
|
30 validity integer NOT NULL,
|
|
|
31 server_url text,
|
|
|
32 CONSTRAINT purl PRIMARY KEY (purl )
|
|
|
33 )
|
|
|
34 WITH (
|
|
|
35 OIDS=FALSE
|
|
|
36 );
|
|
|
37 ALTER TABLE purls
|
|
|
38 OWNER TO postgres;
|
|
|
39 GRANT ALL ON TABLE purls TO postgres;
|
|
|
40 GRANT ALL ON TABLE purls TO "purlUSER";
|
