Debian Codegraph @

manuals/en/developers/t-dev-dbpool.tex

raw
1 \begin{longtable}{llX}
2 \caption{Pool table layout}\label{blb:dev:pool:table:layout} \\
3 \toprule
4 \rowcolor{bheader}
5 \multicolumn{1}{c}{\bheader{Column Name}} &
6 \multicolumn{1}{l}{\bheader{Data Type}} &
7 \multicolumn{1}{l}{\bheader{Remark}} \\
8 \midrule
9 \endfirsthead
10 \toprule
11 \rowcolor{bheader}
12 \multicolumn{1}{c}{\bheader{Column Name}} &
13 \multicolumn{1}{l}{\bheader{Data Type}} &
14 \multicolumn{1}{l}{\bheader{Remark}} \\
15 \midrule
16 \endhead
17 \midrule
18 \multicolumn{3}{c}{\bnextpage{}} \\
19 \endfoot
20 \bottomrule
21 \endlastfoot
22 PoolId & integer & Primary Key \\
23 \midrule
24 Name & Tinyblob & Pool Name \\
25 \midrule
26 NumVols & Integer & Number of Volumes in the Pool \\
27 \midrule
28 MaxVols & Integer & Maximum Volumes in the Pool \\
29 \midrule
30 UseOnce & tinyint & Use volume once \\
31 \midrule
32 UseCatalog & tinyint & Set to use catalog \\
33 \midrule
34 AcceptAnyVolume & tinyint & Accept any volume from Pool \\
35 \midrule
36 VolRetention & bigint & 64 bit seconds to retain volume \\
37 \midrule
38 VolUseDuration & bigint & 64 bit seconds volume can be used \\
39 \midrule
40 MaxVolJobs & integer & max jobs on volume \\
41 \midrule
42 MaxVolFiles & integer & max \acs{EOF} marks to put on Volume \\
43 \midrule
44 MaxVolBytes & bigint & max bytes to write on Volume \\
45 \midrule
46 MaxPoolBytes & bigint & max bytes to write on the Pool \\
47 \midrule
48 AutoPrune & tinyint & \byesorno{} for autopruning \\
49 \midrule
50 Recycle & tinyint & \byesorno{} for allowing auto recycling of Volume \\
51 \midrule
52 ActionOnPurge & tinyint & Default Volume ActionOnPurge \\
53 \midrule
54 PoolType & enum & Backup, Copy, Cloned, Archive, Migration \\
55 \midrule
56 LabelType & tinyint & Type of label \acs{ANSI} / \bacula{} \\
57 \midrule
58 LabelFormat & Tinyblob & Label format \\
59 \midrule
60 Enabled & tinyint & Whether or not Volume can be written \\
61 \midrule
62 ScratchPoolId & integer & Id of Scratch Pool \\
63 \midrule
64 RecyclePoolId & integer & Pool ID where to recycle Volume \\
65 \midrule
66 NextPoolId & integer & Pool ID of next Pool \\
67 \midrule
68 MigrationHighBytes & bigint & High water mark for migration \\
69 \midrule
70 MigrationLowBytes & bigint & Low water mark for migration \\
71 \midrule
72 MigrationTime & bigint & Time before migration \\
73 \end{longtable}