/usr/share/lcgdm/create_dpm_tables_postgres.sql is in dpm-server-postgres 1.9.0-2.
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 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 | --
-- Copyright (C) 2004-2011 by CERN/IT/GD/CT
-- All rights reserved
--
-- @(#)$RCSfile: dpm_postgresql_tbl.sql,v $ $Revision: 7068 $ $Date: 2012-08-30 12:04:36 +0200 (Thu, 30 Aug 2012) $ CERN IT-GD/CT Jean-Philippe Baud
-- Create Disk Pool Manager PostgreSQL tables.
CREATE TABLE dpm_pool (
rowid BIGSERIAL PRIMARY KEY,
poolname VARCHAR(15),
defsize BIGINT,
gc_start_thresh INTEGER,
gc_stop_thresh INTEGER,
def_lifetime INTEGER,
defpintime INTEGER,
max_lifetime INTEGER,
maxpintime INTEGER,
fss_policy VARCHAR(15),
gc_policy VARCHAR(15),
mig_policy VARCHAR(15),
rs_policy VARCHAR(15),
groups VARCHAR(255),
ret_policy CHAR(1),
s_type CHAR(1),
pooltype VARCHAR(32),
poolmeta TEXT);
CREATE TABLE dpm_fs (
rowid BIGSERIAL PRIMARY KEY,
poolname VARCHAR(15),
server VARCHAR(63),
fs VARCHAR(79),
status INTEGER,
weight INTEGER);
CREATE TABLE dpm_pending_req (
rowid BIGSERIAL PRIMARY KEY,
r_ordinal INTEGER,
r_token VARCHAR(36),
r_uid INTEGER,
r_gid INTEGER,
client_dn VARCHAR(255),
clienthost VARCHAR(63),
r_type CHAR(1),
u_token VARCHAR(255),
flags INTEGER,
retrytime INTEGER,
nbreqfiles INTEGER,
ctime INTEGER,
stime INTEGER,
etime INTEGER,
status INTEGER,
errstring VARCHAR(255),
groups VARCHAR(255));
CREATE TABLE dpm_req (
rowid BIGSERIAL PRIMARY KEY,
r_ordinal INTEGER,
r_token VARCHAR(36),
r_uid INTEGER,
r_gid INTEGER,
client_dn VARCHAR(255),
clienthost VARCHAR(63),
r_type CHAR(1),
u_token VARCHAR(255),
flags INTEGER,
retrytime INTEGER,
nbreqfiles INTEGER,
ctime INTEGER,
stime INTEGER,
etime INTEGER,
status INTEGER,
errstring VARCHAR(255),
groups VARCHAR(255));
CREATE TABLE dpm_get_filereq (
rowid BIGSERIAL PRIMARY KEY,
r_token VARCHAR(36),
f_ordinal INTEGER,
r_uid INTEGER,
from_surl VARCHAR(1103),
protocol VARCHAR(7),
lifetime INTEGER,
f_type CHAR(1),
s_token CHAR(36),
ret_policy CHAR(1),
flags INTEGER,
server VARCHAR(63),
pfn VARCHAR(1103),
actual_size BIGINT,
status INTEGER,
errstring VARCHAR(255));
CREATE TABLE dpm_put_filereq (
rowid BIGSERIAL PRIMARY KEY,
r_token VARCHAR(36),
f_ordinal INTEGER,
to_surl VARCHAR(1103),
protocol VARCHAR(7),
lifetime INTEGER,
f_lifetime INTEGER,
f_type CHAR(1),
s_token CHAR(36),
ret_policy CHAR(1),
ac_latency CHAR(1),
requested_size BIGINT,
server VARCHAR(63),
pfn VARCHAR(1103),
actual_size BIGINT,
status INTEGER,
errstring VARCHAR(255));
CREATE TABLE dpm_copy_filereq (
rowid BIGSERIAL PRIMARY KEY,
r_token VARCHAR(36),
f_ordinal INTEGER,
from_surl VARCHAR(1103),
to_surl VARCHAR(1103),
f_lifetime INTEGER,
f_type CHAR(1),
s_token CHAR(36),
ret_policy CHAR(1),
ac_latency CHAR(1),
flags INTEGER,
actual_size BIGINT,
status INTEGER,
errstring VARCHAR(255));
CREATE TABLE dpm_space_reserv (
rowid BIGSERIAL PRIMARY KEY,
s_token CHAR(36),
client_dn VARCHAR(255),
s_uid INTEGER,
s_gid INTEGER,
ret_policy CHAR(1),
ac_latency CHAR(1),
s_type CHAR(1),
u_token VARCHAR(255),
t_space BIGINT,
g_space BIGINT,
u_space BIGINT,
poolname VARCHAR(15),
assign_time INTEGER,
expire_time INTEGER,
groups VARCHAR(255));
CREATE SEQUENCE dpm_unique_id START 1;
ALTER TABLE dpm_pool
ADD CONSTRAINT pk_poolname UNIQUE (poolname);
ALTER TABLE dpm_fs
ADD CONSTRAINT pk_fs UNIQUE (poolname, server, fs);
ALTER TABLE dpm_pending_req
ADD CONSTRAINT pk_p_token UNIQUE (r_token);
ALTER TABLE dpm_req
ADD CONSTRAINT pk_token UNIQUE (r_token);
ALTER TABLE dpm_get_filereq
ADD CONSTRAINT pk_g_fullid UNIQUE (r_token, f_ordinal);
ALTER TABLE dpm_put_filereq
ADD CONSTRAINT pk_p_fullid UNIQUE (r_token, f_ordinal);
ALTER TABLE dpm_copy_filereq
ADD CONSTRAINT pk_c_fullid UNIQUE (r_token, f_ordinal);
ALTER TABLE dpm_space_reserv
ADD CONSTRAINT pk_s_token UNIQUE (s_token);
ALTER TABLE dpm_fs
ADD CONSTRAINT fk_fs FOREIGN KEY (poolname) REFERENCES dpm_pool(poolname);
CREATE INDEX P_U_DESC_IDX ON dpm_pending_req (u_token);
CREATE INDEX U_DESC_IDX ON dpm_req (u_token);
CREATE INDEX G_SURL_IDX ON dpm_get_filereq (FROM_SURL);
CREATE INDEX P_SURL_IDX ON dpm_put_filereq (TO_SURL);
CREATE INDEX CF_SURL_IDX ON dpm_copy_filereq (FROM_SURL);
CREATE INDEX CT_SURL_IDX ON dpm_copy_filereq (TO_SURL);
CREATE INDEX G_PFN_IDX ON dpm_get_filereq (pfn);
CREATE INDEX P_PFN_IDX ON dpm_put_filereq (pfn);
-- Create the "schema_version" table
CREATE TABLE schema_version_dpm (
major INTEGER NOT NULL,
minor INTEGER NOT NULL,
patch INTEGER NOT NULL);
INSERT INTO schema_version_dpm (major, minor, patch) VALUES (3, 4, 0);
|