PageRenderTime 41ms CodeModel.GetById 23ms app.highlight 11ms RepoModel.GetById 1ms app.codeStats 0ms

/sigmah/src/test/resources/dbunit/sites-simple1.db.xml

http://sigma-h.googlecode.com/
XML | 366 lines | 239 code | 97 blank | 30 comment | 0 complexity | 9f64f4bdca1dfba25cfd1627ce130a3a MD5 | raw file
  1<?xml version="1.0"?>
  2<!--
  3  ~ All Sigmah code is released under the GNU General Public License v3
  4  ~ See COPYRIGHT.txt and LICENSE.txt.
  5  -->
  6
  7<dataset>
  8
  9
 10	<!-- Country setup -->
 11
 12	<country countryId="1" name="Rdc" x1="0" y1="0" x2="0" y2="0" />
 13
 14    <adminLevel countryId="1" adminLevelId="1" name="Province" AllowAdd="0"	/>
 15    <adminLevel countryId="1" adminLevelId="2" name="Territoire" AllowAdd="0" ParentId="1"/>    
 16
 17	<locationType locationTypeId="1" countryId="1" name="localite" reuse="1"/>
 18	<locationType locationTypeId="2" countryId="1" name="Health Center" reuse="1"/>
 19    <locationType locationTypeId="3" countryId="1" name="Territorie" reuse="1" BoundAdminLevelId="2"/>
 20	
 21	<adminEntity adminLevelId="1" adminEntityId="1" name="Kinshasa" code="10" x1="0" y1="0" x2="0" y2="0"/>
 22	<adminEntity adminLevelId="1" adminEntityId="2" name="Sud Kivu" code="20" x1="0" y1="0" x2="0" y2="0"/>
 23	<adminEntity adminLevelId="1" adminEntityId="3" name="Nord Kivu" code="30" x1="0" y1="0" x2="0" y2="0"/>
 24	<adminEntity adminLevelId="1" adminEntityId="4" name="Ituri" code="40" x1="0" y1="0" x2="0" y2="0"/>
 25
 26	<adminEntity adminLevelId="2" adminEntityId="10" adminEntityParentId="4" name="Bukavu" code="203" x1="0" y1="0" x2="0" y2="0"/>
 27	<adminEntity adminLevelId="2" adminEntityId="11" adminEntityParentId="2" name="Walungu" code="201" x1="0" y1="0" x2="0" y2="0"/>
 28	<adminEntity adminLevelId="2" adminEntityId="12" adminEntityParentId="2" name="Shabunda" code="202" x1="0" y1="0" x2="0" y2="0"/>
 29	<adminEntity adminLevelId="2" adminEntityId="13" adminEntityParentId="2" name="Kalehe" code="203" x1="0" y1="0" x2="0" y2="0"/>
 30	<adminEntity adminLevelId="2" adminEntityId="21" adminEntityParentId="4" name="Irumu" code="203" x1="0" y1="0" x2="0" y2="0"/>
 31
 32	<!--  User setup -->
 33	<userLogin userId="1" name="Alex" email="akbertram@gmail.com" password="$2a$10$zc7fiaYWXwIN7w4LtFQL7u1ng3vbSNaJ7X24hzISDRMpWpvOHZu1." locale="fr" newUser="1" />
 34	<userLogin userId="2" name="Bavon" email="bavon@nrc.org" password="$2a$10$zc7fiaYWXwIN7w4LtFQL7u1ng3vbSNaJ7X24hzISDRMpWpvOHZu1." locale="fr" newUser="1" />
 35	<userLogin userId="5" name="Christian" email="christian@nrc.org" password="xyz" locale="fr" newUser="1" />
 36	<userLogin userId="3" name="Lisa" email="lisa@solidarites" password="xyz" locale="fr" newUser="1" />
 37	
 38	<userLogin userId="4" name="Marlene" email="marlene@solidarites" password="xyz" locale="fr" newUser="1" />	
 39	
 40	<!--  Attributes -->
 41		
 42	<!--  NFI Attribute 1: Cause -->
 43		
 44		<attributeGroup attributeGroupId="1"
 45			name="cause"
 46			multipleAllowed="1"
 47			sortOrder="2"/>
 48			
 49			<attribute attributeGroupId="1"
 50				attributeId="1"
 51				sortOrder="2"
 52				name="Catastrophe Naturelle" />
 53			<attribute attributeGroupId="1"
 54				attributeId="2"
 55				sortOrder="1"
 56				name="Deplacement"/>
 57		
 58	<!--  NFI Attribute 2: Contenu de Kit -->
 59	
 60	<attributeGroup attributeGroupId="2"
 61		name="contenu du kit"
 62		multipleAllowed="1"
 63		sortOrder="1"/>
 64		
 65			<attribute attributeGroupId="2"
 66				attributeId="3"
 67				name="Casserole"
 68				sortOrder="1" />
 69			
 70			<attribute attributeGroupId="2"
 71				attributeId="4"
 72				name="Soap"
 73				sortOrder="2" />
 74	
 75	<!--  Database: PEAR -->
 76
 77	<userDatabase databaseId="1" name="PEAR" countryId="1" ownerUserId="1"
 78                  lastSchemaUpdate="2009-01-01" />
 79
 80	
 81		<!--  PEAR Activity 1 : NFI Distribution -->	
 82	
 83		<activity activityId="1"
 84			databaseId="1"
 85			name="NFI"
 86			reportingFrequency="0"
 87			allowEdit="1"
 88			isAssessment="0"
 89			sortOrder="1"
 90			locationTypeId="1"/>
 91			
 92	
 93			<attributeGroupInActivity activityId="1" attributeGroupId="1"/>
 94			<attributeGroupInActivity activityId="1" attributeGroupId="2"/>		
 95			
 96			<!-- NFI Indicator 1: Beneficiaries -->
 97				
 98			<indicator indicatorId="1"
 99				activityId="1"
100				databaseId="1"
101				name="beneficiaries"
102				units="menages"
103				aggregation="0"
104				category="inputs"
105				objective="10000"
106				description="falling in lve"
107				listHeader="no header really"
108				collectIntervention="1"
109				collectMonitoring="1"
110				sortOrder="2"/>
111			
112			<!-- NFI Indicator 2: Bache  -->
113				
114			<indicator indicatorId="2"
115				activityId="1"
116				databaseId="1"
117				name="baches" 
118				units="menages"   
119				aggregation="0"
120				collectIntervention="1"  
121				collectMonitoring="1"  
122				category="outputs"  
123				listHeader="header"  
124				description="desc"  
125				sortOrder="1"/>
126
127            <!-- NFI Indicator 3: Number of Distributions -->
128
129            <indicator indicatorId="103"
130                activityId="1"
131                databaseId="1"
132                name="Nb. of distributions"
133                units="distributions"
134                aggregation="2"
135                collectIntervention="0"
136                collectMonitoring="0"
137                category="outputs"
138                listHeader="distribs"
139                description="Nomber of distributions effectuees"
140                sortOrder="3"/>
141
142							
143		<!--  PEAR Activity 2 :  Kits Scolaire -->
144	
145		<activity activityId="2"
146			databaseId="1"
147			name="Distribution de Kits Scolaire"
148			reportingFrequency="0"
149			allowEdit="1"
150			isAssessment="0"
151			sortOrder="1"
152			locationTypeId="1"/>
153			
154			<attributeGroupInActivity activityId="2" attributeGroupId="1"/>
155	
156	<!--  Database: PEAR PLUS -->
157	
158	<userDatabase databaseId="2" name="PEAR Plus" countryId="1" ownerUserId="1"
159                  lastSchemaUpdate="2009-01-01"/>
160
161		<!-- PEAR PLUS Activity #1 - Support to health centers (monthly reporting) -->
162
163		<activity activityId="3"
164			databaseId="2"
165			name="Appui aux centres de sant?Š"
166			reportingFrequency="1"
167			allowEdit="1"
168			isAssessment="0"
169			sortOrder="1"
170			locationTypeId="1"/>
171			
172			
173			<!-- Appui CS Indicator 1: Utilisation Rate  -->
174				
175			<indicator indicatorId="5"
176				activityId="3"
177				databaseId="2"
178				name="Utilisaton rate"
179				units="nc/hab/month"   
180				aggregation="1"  
181				collectIntervention="1"  
182				collectMonitoring="0"  
183				category="outputs"  
184				listHeader="header"  
185				description="desc"  
186				sortOrder="1"/>
187
188    <activity activityId="4"
189        databaseId="2"
190        name="Reunification of child soliders"
191        reportingFrequency="1"
192        allowEdit="1"
193        isAssessment="0"
194        sortOrder="1"
195        locationTypeId="3"/>
196
197            <indicator indicatorId="6"
198                 activityId="4"
199                 databaseId="2"
200                 name="Number of children"
201                 units="children"
202                 aggregation="1"
203                 collectIntervention="1"
204                 collectMonitoring="0"
205                 listHeader="kids"
206                 description="desc"
207                 sortOrder="1"/>
208
209
210	
211	<!--  PEAR Partners -->
212
213	<partner partnerId="1" name="NRC"  />
214	<partnerInDatabase partnerId="1" databaseId="1"/>
215	
216	<partner partnerId="2" name="Solidarites"  />
217	<partnerInDatabase partnerId="2" databaseId="1"/>
218
219    <!-- PEAR Plus Partners -->
220    <partnerInDatabase partnerId="1" databaseId="2"/>
221
222	<!-- Bavon at NRC has access to PEAR -->
223 	<userPermission userPermissionId="1"
224                     databaseId="1" userId="2" partnerId="1"
225                     allowView="1" allowViewAll="0"
226                     allowEdit="1" allowEditAll="0"
227                     allowManageUsers="1" allowManageAllUsers="1"
228                     allowDesign="0"
229                     lastSchemaUpdate="2009-01-01"/>
230
231	<!-- Christian at NRC had access, but has been fired -->
232
233 	<userPermission userPermissionId="2"
234                     databaseId="1" userId="5" partnerId="1"
235                     allowView="0" allowViewAll="0"
236                     allowEdit="0" allowEditAll="0"
237                     allowDesign="0"
238                     allowManageUsers="0" allowManageAllUsers="0"
239                     lastSchemaUpdate="2009-01-01"/>
240
241    <userPermission userPermissionId="3"
242                    databaseId="1" userId="3" partnerId="2"
243                    allowView="1" allowViewAll="0"
244                    allowEdit="1" allowEditAll="1"
245                    allowDesign="1"
246                    allowManageUsers="1" allowManageAllUsers="0"
247                    lastSchemaUpdate="2009-01-01"/>
248
249    <userPermission userPermissionId="4"
250                    databaseId="1" userId="4" partnerId="2"
251                    allowView="1" allowViewAll="0"
252                    allowEdit="0" allowEditAll="1"
253                    allowDesign="1"
254                    allowManageUsers="0" allowManageAllUsers="0"
255                    lastSchemaUpdate="2009-01-01"/>
256
257
258
259	<!-- id=1  NFI Distribution at Penekusu, Sud Kivu   2 jan 2009-->
260
261	<location locationId="1" name="Penekusu" locationTypeId="1" X="1.532" Y="27.323" DateCreated="2009-02-01" DateEdited="2009-02-01" />
262	<locationAdminLink locationId="1" adminEntityId="2"/>
263	<locationAdminLink locationId="1" adminEntityId="12"/>
264	
265	<site siteId="1" databaseId="1" activityId="1" locationId="1" partnerId="1" Status="1" target="0" Date1="2009-01-01" Date2="2009-01-02" DateCreated="2009-02-01" DateEdited="2009-02-01"/>
266	<attributeValue siteId="1" attributeId="1" value="0"/>
267	<attributeValue siteId="1" attributeId="2" value="1"/>
268	
269	<reportingPeriod reportingPeriodId="1" siteId="1" monitoring="0" date1="2009-01-01" date2="2009-01-02" DateCreated="2009-02-01" DateEdited="2009-02-01"/>
270	<indicatorValue reportingPeriodId="1" indicatorId="1" value="1500"/>
271	<indicatorValue reportingPeriodId="1" indicatorId="2" value="500"/>
272		
273	
274	<!-- id=2 NFI Distribution at Ngwshe, Sud Kivu 16 jan 2009 -->
275	
276	<location locationId="2" name="Ngshwe" locationTypeId="1" X="1.323" Y="28.232" DateCreated="2009-02-01" DateEdited="2009-02-01"/>
277	<locationAdminLink locationId="2" adminEntityId="2"/>
278	<locationAdminLink locationId="2" adminEntityId="11"/>
279	
280	<site siteId="2" databaseId="1" activityId="1"  locationId="2" partnerId="1" Status="1" target="1" Date1="2009-01-15" Date2="2009-01-16" DateCreated="2009-02-01" DateEdited="2009-02-01"/>
281	<attributeValue siteId="2" attributeId="1" value="1"/>2
282	<attributeValue siteId="2" attributeId="2" value="1"/>
283	
284	<reportingPeriod reportingPeriodId="2" siteId="2" monitoring="0" date1="2009-01-15" date2="2009-01-16" DateCreated="2009-02-01" DateEdited="2009-02-01"/>
285	<indicatorValue reportingPeriodId="2" indicatorId="1" value="3600"/>
286	<indicatorValue reportingPeriodId="2" indicatorId="2" value="1200"/>
287
288	<!-- id=3 NFI Distribution at Boga, Ituri 2008 -->
289	
290	<location locationId="3" name="Boga" locationTypeId="1" X="3.323" Y="27.232" DateCreated="2009-02-01" DateEdited="2009-02-01"/>
291	<locationAdminLink locationId="3" adminEntityId="4"/>
292	<locationAdminLink locationId="3" adminEntityId="21"/>
293	
294	<site siteId="3" databaseId="1" activityId="1" locationId="3" partnerId="2" Status="1" target="0" Date1="2008-10-05" Date2="2008-10-06" DateCreated="2009-02-01" DateEdited="2009-02-01"/>
295	<attributeValue siteId="3" attributeId="1" value="1"/>
296	<attributeValue siteId="3" attributeId="2" value="0"/>
297	
298	<reportingPeriod reportingPeriodId="3" siteId="3" monitoring="0" date1="2008-10-05" date2="2008-10-06" DateCreated="2009-02-01" DateEdited="2009-02-01"/>
299	<indicatorValue reportingPeriodId="3" indicatorId="1" value="10000"/>
300	<indicatorValue reportingPeriodId="3" indicatorId="2" value="500"/>
301
302	
303	<!--  PEAR Plus Health Center Support in Ngweshe -->
304
305	<location locationId="9" name="CS Ngweshe" locationTypeId="2" X="3.23" Y="27.232"  DateCreated="2009-01-01" DateEdited="2009-01-01"/>
306	<locationAdminLink locationId="9" adminEntityId="2"/>
307	<locationAdminLink locationId="9" adminEntityId="11"/>
308		
309	<site siteId="9" activityId="3" databaseId="2" locationId="9" partnerId="1" Status="1" target="0" Date1="2009-01-01" Date2="2009-12-31" DateCreated="2009-01-01" DateEdited="2009-01-01" />
310		
311	<reportingPeriod reportingPeriodId="91" siteId="9" monitoring="0" date1="2009-01-01" date2="2009-01-31" DateCreated="2009-02-01" DateEdited="2009-02-01" />
312		<indicatorValue reportingPeriodId="91" indicatorId="5" value="0.1"/>
313
314	<reportingPeriod reportingPeriodId="92" siteId="9" monitoring="0" date1="2009-02-01" date2="2009-02-28" DateCreated="2009-02-01" DateEdited="2009-02-01"/>
315		<indicatorValue reportingPeriodId="92" indicatorId="5" value="0.3"/>
316
317	<reportingPeriod reportingPeriodId="93" siteId="9" monitoring="0" date1="2009-03-01" date2="2009-03-30" DateCreated="2009-02-01" DateEdited="2009-02-01"/>
318		<indicatorValue reportingPeriodId="93" indicatorId="5" value="0.4"/>
319
320
321	<!--  Kit scolaires in Bukavu -->
322	<location locationId="4" name="Boga" locationTypeId="1" X="3.323" Y="27.232" DateCreated="2009-10-05" DateEdited="2009-10-05"/>
323	<locationAdminLink locationId="4" adminEntityId="2"/>
324	<locationAdminLink locationId="4" adminEntityId="10"/>
325	
326	<site siteId="4" activityId="2" databaseId="1" locationId="4" partnerId="2" Status="1" target="0" Date1="2008-10-06" Date2="2008-11-06" DateCreated="2009-10-05" DateEdited="2009-10-05" />
327
328	<!-- Kit scolaires in Boga Ituri -->
329
330	<site siteId="5" activityId="2" databaseId="1" locationId="3" partnerId="1" Status="1" target="0" Date1="2008-10-05" Date2="2008-10-05" DateCreated="2009-02-01" DateEdited="2009-02-01"/>
331
332
333
334
335    <!-- PEAR Plus child reunification in Walungu -->
336
337    <location locationId="6" name="Walungu" locationTypeId="3"  DateCreated="2009-02-01" DateEdited="2009-02-01" />
338    <locationAdminLink locationId="6" adminEntityId="3"/>
339	<locationAdminLink locationId="6" adminEntityId="11"/>
340
341    <site siteId="6" activityId="4" databaseId="2" locationId="6" partnerId="1" Status="1" target="0"
342          Date1="2009-01-01" Date2="2009-01-31"
343          DateCreated="2009-02-01" DateEdited="2009-02-01"  />
344
345    <reportingPeriod reportingPeriodId="601" siteId="6" monitoring="0" date1="2009-01-01" date2="2009-01-31"
346                     DateCreated="2009-01-01" DateEdited="2009-01-01"/>
347    <indicatorValue reportingPeriodId="601" indicatorId="6" value="35"/>
348
349    <reportingPeriod reportingPeriodId="602" siteId="6" monitoring="0" date1="2009-02-01" date2="2009-02-28"
350                     DateCreated="2009-01-01" DateEdited="2009-01-01"/>
351    <indicatorValue reportingPeriodId="602" indicatorId="6" value="70"/>
352
353
354    <!-- PEAR Plus child reunification in Shabunda -->
355
356    <location locationId="7" name="Shabunda" locationTypeId="3" DateCreated="2009-02-01" DateEdited="2009-02-01" />
357    <locationAdminLink locationId="7" adminEntityId="3"/>
358    <locationAdminLink locationId="7" adminEntityId="12"/>
359
360    <site siteId="7" activityId="4" databaseId="2" locationId="7" partnerId="1" Status="1" target="0"
361          Date1="2009-01-01" Date2="2009-01-31"
362          DateCreated="2009-02-01" DateEdited="2009-02-01"/>
363
364       
365
366</dataset>