slight restructuring
[Evergreen.git] / Open-ILS / src / reporter / report_base.example.xml
1 <?xml version="1.0" encoding="UTF-8"?>
2 <reporter xmlns:xi="http://www.w3.org/2001/XInclude">
3
4         <setup>
5                 <files>
6                         <stage1>/tmp/</stage1>
7                         <stage2>/tmp/</stage2>
8                         <stage3>/tmp/</stage3>
9                 </files>
10                 <database>
11                         <host>10.0.0.2</host>
12                         <user>postgres</user>
13                         <password/>
14                 </database>
15         </setup>
16
17         <tables>
18
19                 <table id="silly.fact" partition="true">
20                         <tablename>stats.silly_fact</tablename>
21
22                         <partition>
23                                 <field>said_when</field>
24                                 <!-- Valid options:  month, year, woy (week of year), doy (day of year) -->
25                                 <chunk>month</chunk>
26                                 <start>2005-09-01</start>
27                                 <end>2005-12-31</end>
28                         </partition>
29
30                         <fields>
31                                 <field
32                                   name="silly_word_dim"
33                                   datatype="int"
34                                   indexed="true">
35                                         <label>Silly word dim</label>
36                                         <description>Silly word entry dimension link</description>
37                                 </field>
38                                 <field
39                                   name="silly_sayer_dim"
40                                   datatype="int"
41                                   indexed="true">
42                                         <label>Silly sayer dim</label>
43                                         <description>Silly sayer entry dimension link</description>
44                                 </field>
45                                 <field
46                                   name="said_when"
47                                   datatype="timestamptz"
48                                   core="true"
49                                   indexed="true"
50                                   default="now()">
51                                         <label>Silly word timestamp</label>
52                                         <description>Silly word entry timestamp</description>
53                                 </field>
54                         </fields>
55                         <links>
56                                 <link
57                                   field="silly_word_dim"
58                                   table="silly.word_dim"
59                                   key="id"
60                                   type="has_a"/>
61                                 <link
62                                   field="silly_sayer_dim"
63                                   table="silly.sayer_dim"
64                                   key="id"
65                                   type="has_a"/>
66                         </links>
67                 </table>
68
69                 <table id="silly.word_dim">
70                         <tablename>stats.words</tablename>
71                         <fields>
72                                 <field
73                                   name="id"
74                                   primary="1"
75                                   create-type="serial"
76                                   datatype="int"/>
77                                 <field
78                                   name="word"
79                                   datatype="text"
80                                   indexed="true"
81                                   index-type="BTREE"/>
82                         </fields>
83                 </table>
84
85                 <table id="silly.sayer_dim">
86                         <tablename>stats.silly_sayers</tablename>
87                         <fields>
88                                 <field
89                                   name="id"
90                                   primary="1"
91                                   create-type="serial"
92                                   datatype="int"/>
93                                 <field
94                                   name="sayer"
95                                   datatype="text"
96                                   indexed="true"
97                                   index-type="BTREE"/>
98                         </fields>
99                 </table>
100
101         </tables>
102 </reporter>