adding fields
[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                         <tablename>stats.silly_fact</tablename>
22
23                         <partition>
24                                 <field>said_when</field>
25                                 <!-- Valid options:  month, year, woy (week of year), doy (day of year) -->
26                                 <chunk>month</chunk>
27                                 <start>2005-09-01</start>
28                                 <end>2005-12-31</end>
29                         </partition>
30
31                         <fields>
32                                 <field
33                                   name="silly_word_dim"
34                                   datatype="int"
35                                   indexed="true">
36                                         <label>Silly word dim</label>
37                                         <description>Silly word entry dimension link</description>
38                                 </field>
39                                 <field
40                                   name="silly_sayer_dim"
41                                   datatype="int"
42                                   indexed="true">
43                                         <label>Silly sayer dim</label>
44                                         <description>Silly sayer entry dimension link</description>
45                                 </field>
46                                 <field
47                                   name="said_when"
48                                   datatype="timestamptz"
49                                   core="true"
50                                   indexed="true"
51                                   default="now()">
52                                         <label>Silly word timestamp</label>
53                                         <description>Silly word entry timestamp</description>
54                                 </field>
55                         </fields>
56                         <links>
57                                 <link
58                                   field="silly_word_dim"
59                                   table="silly.word_dim"
60                                   key="id"
61                                   type="has_a"/>
62                                 <link
63                                   field="silly_sayer_dim"
64                                   table="silly.sayer_dim"
65                                   key="id"
66                                   type="has_a"/>
67                         </links>
68                 </table>
69
70                 <table id="silly.word_dim">
71                         <name>Silly word list</name>
72                         <tablename>stats.words</tablename>
73                         <fields>
74                                 <field
75                                   name="id"
76                                   primary="1"
77                                   create-type="serial"
78                                   datatype="int"/>
79                                 <field
80                                   name="word"
81                                   datatype="text"
82                                   indexed="true"
83                                   index-type="BTREE"/>
84                         </fields>
85                 </table>
86
87                 <table id="silly.sayer_dim">
88                         <name>Silly word sayer list</name>
89                         <tablename>stats.silly_sayers</tablename>
90                         <fields>
91                                 <field
92                                   name="id"
93                                   primary="1"
94                                   create-type="serial"
95                                   datatype="int"/>
96                                 <field
97                                   name="sayer"
98                                   datatype="text"
99                                   indexed="true"
100                                   index-type="BTREE"/>
101                         </fields>
102                 </table>
103
104         </tables>
105 </reporter>