/usr/share/pegasus/sql/create-pg-rc.sql is in pegasus-wms 4.4.0+dfsg-7.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 | --
-- schema: org.griphyn.common.catalog.ReplicaCatalog
-- driver: PostGreSQL 7.4.*
-- $Revision$
--
INSERT INTO pegasus_schema(name,catalog,version) VALUES ('JDBCRC','rc','1.3');
CREATE SEQUENCE rc_lfn_id;
CREATE TABLE rc_lfn (
id BIGINT DEFAULT nextval('rc_lfn_id'::text),
lfn VARCHAR(255) NOT NULL,
pfn VARCHAR(255) NOT NULL,
site VARCHAR(255),
CONSTRAINT pk_rc_lfn PRIMARY KEY(id),
CONSTRAINT sk_rc_lfn UNIQUE(lfn,pfn,site)
);
CREATE INDEX ix_rc_lfn ON rc_lfn(lfn);
CREATE TABLE rc_attr (
id BIGINT,
name VARCHAR(64) NOT NULL,
value VARCHAR(255) NOT NULL,
CONSTRAINT pk_rc_attr PRIMARY KEY(id,name),
CONSTRAINT fk_rc_attr FOREIGN KEY(id) REFERENCES rc_lfn(id)
ON DELETE CASCADE
);
CREATE INDEX ix_rc_attr ON rc_attr(name);
|