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
|
--
-- Copyright (C) 2004-2008 by CERN/IT/GD/CT
-- All rights reserved
--
-- @(#)$RCSfile: dpm_oracle_tbl.sql,v $ $Revision: 1.14 $ $Date: 2008/09/24 11:25:00 $ CERN IT-GD/CT Jean-Philippe Baud
-- Create Disk Pool Manager Oracle tables.
CREATE TABLE dpm_pool (
poolname VARCHAR2(15),
defsize NUMBER,
gc_start_thresh NUMBER(3),
gc_stop_thresh NUMBER(3),
def_lifetime NUMBER(10),
defpintime NUMBER(10),
max_lifetime NUMBER(10),
maxpintime NUMBER(10),
fss_policy VARCHAR2(15),
gc_policy VARCHAR2(15),
mig_policy VARCHAR2(15),
rs_policy VARCHAR2(15),
groups VARCHAR2(255),
ret_policy CHAR(1),
s_type CHAR(1));
CREATE TABLE dpm_fs (
poolname VARCHAR2(15),
server VARCHAR2(63),
fs VARCHAR2(79),
status NUMBER(10));
CREATE TABLE dpm_pending_req (
r_ordinal NUMBER(10),
r_token VARCHAR2(36),
r_uid NUMBER(10),
r_gid NUMBER(10),
client_dn VARCHAR2(255),
clienthost VARCHAR2(63),
r_type CHAR(1),
u_token VARCHAR2(255),
flags NUMBER,
retrytime NUMBER(10),
nbreqfiles NUMBER(10),
ctime NUMBER(10),
stime NUMBER(10),
etime NUMBER(10),
status NUMBER(10),
errstring VARCHAR2(255),
groups VARCHAR2(255));
CREATE TABLE dpm_req (
r_ordinal NUMBER(10),
r_token VARCHAR2(36),
r_uid NUMBER(10),
r_gid NUMBER(10),
client_dn VARCHAR2(255),
clienthost VARCHAR2(63),
r_type CHAR(1),
u_token VARCHAR2(255),
flags NUMBER,
retrytime NUMBER(10),
nbreqfiles NUMBER(10),
ctime NUMBER(10),
stime NUMBER(10),
etime NUMBER(10),
status NUMBER(10),
errstring VARCHAR2(255),
groups VARCHAR2(255));
CREATE TABLE dpm_get_filereq (
r_token VARCHAR2(36),
f_ordinal NUMBER(10),
r_uid NUMBER(10),
from_surl VARCHAR2(1103),
protocol VARCHAR2(7),
lifetime NUMBER(10),
f_type CHAR(1),
s_token CHAR(36),
ret_policy CHAR(1),
flags NUMBER,
server VARCHAR2(63),
pfn VARCHAR2(1103),
actual_size NUMBER,
status NUMBER(10),
errstring VARCHAR2(255));
CREATE TABLE dpm_put_filereq (
r_token VARCHAR2(36),
f_ordinal NUMBER(10),
to_surl VARCHAR2(1103),
protocol VARCHAR2(7),
lifetime NUMBER(10),
f_lifetime NUMBER(10),
f_type CHAR(1),
s_token CHAR(36),
ret_policy CHAR(1),
ac_latency CHAR(1),
requested_size NUMBER,
server VARCHAR2(63),
pfn VARCHAR2(1103),
actual_size NUMBER,
status NUMBER(10),
errstring VARCHAR2(255));
CREATE TABLE dpm_copy_filereq (
r_token VARCHAR2(36),
f_ordinal NUMBER(10),
from_surl VARCHAR2(1103),
to_surl VARCHAR2(1103),
f_lifetime NUMBER(10),
f_type CHAR(1),
s_token CHAR(36),
ret_policy CHAR(1),
ac_latency CHAR(1),
flags NUMBER,
actual_size NUMBER,
status NUMBER(10),
errstring VARCHAR2(255));
CREATE TABLE dpm_space_reserv (
s_token CHAR(36),
client_dn VARCHAR2(255),
s_uid NUMBER(10),
s_gid NUMBER(10),
ret_policy CHAR(1),
ac_latency CHAR(1),
s_type CHAR(1),
u_token VARCHAR2(255),
t_space NUMBER,
g_space NUMBER,
u_space NUMBER,
poolname VARCHAR2(15),
assign_time NUMBER(10),
expire_time NUMBER(10),
groups VARCHAR2(255));
CREATE SEQUENCE dpm_unique_id START WITH 1 INCREMENT BY 1;
ALTER TABLE dpm_pool
ADD CONSTRAINT pk_poolname PRIMARY KEY (poolname);
ALTER TABLE dpm_fs
ADD CONSTRAINT pk_fs PRIMARY KEY (poolname, server, fs)
ADD CONSTRAINT fk_fs FOREIGN KEY (poolname) REFERENCES dpm_pool(poolname);
ALTER TABLE dpm_pending_req
ADD CONSTRAINT pk_p_token PRIMARY KEY (r_token);
ALTER TABLE dpm_req
ADD CONSTRAINT pk_token PRIMARY KEY (r_token);
ALTER TABLE dpm_get_filereq
ADD CONSTRAINT pk_g_fullid PRIMARY KEY (r_token, f_ordinal);
ALTER TABLE dpm_put_filereq
ADD CONSTRAINT pk_p_fullid PRIMARY KEY (r_token, f_ordinal);
ALTER TABLE dpm_copy_filereq
ADD CONSTRAINT pk_c_fullid PRIMARY KEY (r_token, f_ordinal);
ALTER TABLE dpm_space_reserv
ADD CONSTRAINT pk_s_token PRIMARY KEY (s_token);
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 NUMBER(1), minor NUMBER(1), patch NUMBER(1));
INSERT INTO schema_version_dpm VALUES (3, 2, 0);
|
