/usr/share/pegasus/sql/create-my-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 | --
-- schema: org.griphyn.common.catalog.ReplicaCatalog
-- driver: MySQL 4.*
-- $Revision$
--
INSERT INTO pegasus_schema VALUES ('JDBCRC','rc','1.3',current_user(),current_timestamp(0));
CREATE TABLE rc_lfn (
id BIGINT DEFAULT NULL auto_increment,
lfn VARCHAR(245) NOT NULL,
pfn VARCHAR(245) NOT NULL,
site VARCHAR(245),
CONSTRAINT pk_rc_lfn PRIMARY KEY(id),
CONSTRAINT sk_rc_lfn UNIQUE(lfn,pfn,site)
) engine=InnoDB;
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
) engine=InnoDB;
CREATE INDEX ix_rc_attr ON rc_attr(name);
|