/usr/share/lcgdm/create_dpm_tables_mysql.sql is in dpm-server-mysql 1.8.7-3.1+b1.
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 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 | --
-- Copyright (C) 2004-2011 by CERN/IT/GD/CT
-- All rights reserved
--
-- @(#)$RCSfile: dpm_mysql_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 MySQL tables.
CREATE DATABASE dpm_db;
USE dpm_db;
CREATE TABLE dpm_pool (
rowid BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
poolname VARCHAR(15) BINARY,
defsize BIGINT UNSIGNED,
gc_start_thresh INTEGER,
gc_stop_thresh INTEGER,
def_lifetime INTEGER,
defpintime INTEGER,
max_lifetime INTEGER,
maxpintime INTEGER,
fss_policy VARCHAR(15) BINARY,
gc_policy VARCHAR(15) BINARY,
mig_policy VARCHAR(15) BINARY,
rs_policy VARCHAR(15) BINARY,
groups VARCHAR(255) BINARY,
ret_policy CHAR(1),
s_type CHAR(1),
pooltype VARCHAR(32),
poolmeta TEXT)
ENGINE = InnoDB;
CREATE TABLE dpm_fs (
rowid BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
poolname VARCHAR(15) BINARY,
server VARCHAR(63) BINARY,
fs VARCHAR(79) BINARY,
status INTEGER,
weight INTEGER)
ENGINE = InnoDB;
CREATE TABLE dpm_pending_req (
rowid BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
r_ordinal INTEGER,
r_token VARCHAR(36) BINARY,
r_uid INTEGER,
r_gid INTEGER,
client_dn VARCHAR(255) BINARY,
clienthost VARCHAR(63) BINARY,
r_type CHAR(1) BINARY,
u_token VARCHAR(255) BINARY,
flags INTEGER,
retrytime INTEGER,
nbreqfiles INTEGER,
ctime INTEGER,
stime INTEGER,
etime INTEGER,
status INTEGER,
errstring VARCHAR(255) BINARY,
groups VARCHAR(255))
ENGINE = InnoDB;
CREATE TABLE dpm_req (
rowid BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
r_ordinal INTEGER,
r_token VARCHAR(36) BINARY,
r_uid INTEGER,
r_gid INTEGER,
client_dn VARCHAR(255) BINARY,
clienthost VARCHAR(63) BINARY,
r_type CHAR(1) BINARY,
u_token VARCHAR(255) BINARY,
flags INTEGER,
retrytime INTEGER,
nbreqfiles INTEGER,
ctime INTEGER,
stime INTEGER,
etime INTEGER,
status INTEGER,
errstring VARCHAR(255) BINARY,
groups VARCHAR(255))
ENGINE = InnoDB;
CREATE TABLE dpm_get_filereq (
rowid BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
r_token VARCHAR(36) BINARY,
f_ordinal INTEGER,
r_uid INTEGER,
from_surl BLOB,
protocol VARCHAR(7) BINARY,
lifetime INTEGER,
f_type CHAR(1) BINARY,
s_token CHAR(36) BINARY,
ret_policy CHAR(1),
flags INTEGER,
server VARCHAR(63) BINARY,
pfn BLOB,
actual_size BIGINT UNSIGNED,
status INTEGER,
errstring VARCHAR(255) BINARY)
ENGINE = InnoDB;
CREATE TABLE dpm_put_filereq (
rowid BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
r_token VARCHAR(36) BINARY,
f_ordinal INTEGER,
to_surl BLOB,
protocol VARCHAR(7) BINARY,
lifetime INTEGER,
f_lifetime INTEGER,
f_type CHAR(1) BINARY,
s_token CHAR(36) BINARY,
ret_policy CHAR(1),
ac_latency CHAR(1),
requested_size BIGINT UNSIGNED,
server VARCHAR(63) BINARY,
pfn BLOB,
actual_size BIGINT UNSIGNED,
status INTEGER,
errstring VARCHAR(255) BINARY)
ENGINE = InnoDB;
CREATE TABLE dpm_copy_filereq (
rowid BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
r_token VARCHAR(36) BINARY,
f_ordinal INTEGER,
from_surl BLOB,
to_surl BLOB,
f_lifetime INTEGER,
f_type CHAR(1) BINARY,
s_token CHAR(36) BINARY,
ret_policy CHAR(1),
ac_latency CHAR(1),
flags INTEGER,
actual_size BIGINT UNSIGNED,
status INTEGER,
errstring VARCHAR(255) BINARY)
ENGINE = InnoDB;
CREATE TABLE dpm_space_reserv (
rowid BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
s_token CHAR(36) BINARY,
client_dn VARCHAR(255) BINARY,
s_uid INTEGER,
s_gid INTEGER,
ret_policy CHAR(1),
ac_latency CHAR(1),
s_type CHAR(1) BINARY,
u_token VARCHAR(255) BINARY,
t_space BIGINT UNSIGNED,
g_space BIGINT UNSIGNED,
u_space BIGINT,
poolname VARCHAR(15) BINARY,
assign_time INTEGER,
expire_time INTEGER,
groups VARCHAR(255) BINARY)
ENGINE = InnoDB;
CREATE TABLE dpm_unique_id (
id BIGINT UNSIGNED)
ENGINE = InnoDB;
ALTER TABLE dpm_pool
ADD UNIQUE (poolname);
ALTER TABLE dpm_fs
ADD UNIQUE pk_fs (poolname, server, fs);
ALTER TABLE dpm_pending_req
ADD UNIQUE (r_token);
ALTER TABLE dpm_req
ADD UNIQUE (r_token);
ALTER TABLE dpm_get_filereq
ADD UNIQUE pk_g_fullid (r_token, f_ordinal);
ALTER TABLE dpm_put_filereq
ADD UNIQUE pk_p_fullid (r_token, f_ordinal);
ALTER TABLE dpm_copy_filereq
ADD UNIQUE pk_c_fullid (r_token, f_ordinal);
ALTER TABLE dpm_space_reserv
ADD 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(255));
CREATE INDEX P_SURL_IDX ON dpm_put_filereq(TO_SURL(255));
CREATE INDEX CF_SURL_IDX ON dpm_copy_filereq(FROM_SURL(255));
CREATE INDEX CT_SURL_IDX ON dpm_copy_filereq(TO_SURL(255));
CREATE INDEX G_PFN_IDX ON dpm_get_filereq(pfn(255));
CREATE INDEX P_PFN_IDX ON dpm_put_filereq(pfn(255));
-- Create the "schema_version" table
DROP TABLE IF EXISTS schema_version_dpm;
CREATE TABLE schema_version_dpm (
major INTEGER NOT NULL,
minor INTEGER NOT NULL,
patch INTEGER NOT NULL
) ENGINE=INNODB;
INSERT INTO schema_version_dpm (major, minor, patch)
VALUES (3, 4, 0);
|