truckin along
[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/reporter/</stage1>
7                         <stage2>/tmp/reporter/</stage2>
8                         <stage3>/tmp/reporter/</stage3>
9                 </files>
10                 <database>
11                         <host>10.0.0.2</host>
12                         <name>demo-dev</name>
13                         <user>postgres</user>
14                         <password/>
15                 </database>
16         </setup>
17
18         <tables>
19
20                 <table id="silly.fact" partition="true">
21                         <name>Silly Fact table</name>
22                         <description>Silly Fact table</description>
23                         <tablename>stats.silly_fact</tablename>
24
25                         <partition>
26                                 <field>said_when</field>
27                                 <!-- Valid options:  years, months, weeks, days, hours, minutes, seconds  -->
28                                 <chunk>months</chunk>
29                                 <start>2005-09-01</start>
30                                 <end>2005-12-31</end>
31                         </partition>
32
33                         <fields>
34                                 <field
35                                   name="silly_word_dim"
36                                   datatype="int"
37                                   indexed="true">
38                                         <label>Silly word dim</label>
39                                         <description>Silly word entry dimension link</description>
40                                 </field>
41                                 <field
42                                   name="silly_sayer_dim"
43                                   datatype="int"
44                                   indexed="true">
45                                         <label>Silly sayer dim</label>
46                                         <description>Silly sayer entry dimension link</description>
47                                 </field>
48                                 <field
49                                   name="said_when"
50                                   datatype="timestamptz"
51                                   core="true"
52                                   indexed="true"
53                                   default="now()">
54                                         <label>Silly word timestamp</label>
55                                         <description>Silly word entry timestamp</description>
56                                 </field>
57                         </fields>
58                         <links>
59                                 <link
60                                   field="silly_word_dim"
61                                   table="silly.word_dim"
62                                   key="id"
63                                   type="has_a"/>
64                                 <link
65                                   field="silly_sayer_dim"
66                                   table="silly.sayer_dim"
67                                   key="id"
68                                   type="has_a"/>
69                         </links>
70                 </table>
71
72                 <table id="silly.word_dim">
73                         <name>Silly word list</name>
74                         <description>Silly word list</description>
75                         <tablename>stats.words</tablename>
76                         <fields>
77                                 <field
78                                   name="id"
79                                   primary="1"
80                                   create-type="serial"
81                                   datatype="int"/>
82                                 <field
83                                   name="word"
84                                   datatype="text"
85                                   indexed="true"
86                                   index-type="BTREE"/>
87                         </fields>
88                 </table>
89
90                 <table id="silly.sayer_dim">
91                         <name>Silly word sayer list</name>
92                         <description>Silly word sayer list</description>
93                         <tablename>stats.silly_sayers</tablename>
94                         <fields>
95                                 <field
96                                   name="id"
97                                   primary="1"
98                                   create-type="serial"
99                                   datatype="int"/>
100                                 <field
101                                   name="sayer"
102                                   datatype="text"
103                                   indexed="true"
104                                   index-type="BTREE"/>
105                         </fields>
106                 </table>
107
108         </tables>
109 </reporter>