/sigmah/src/test/resources/dbunit/client-sites-h2.db.xml

http://sigma-h.googlecode.com/ · XML · 322 lines · 204 code · 91 blank · 27 comment · 0 complexity · d5c44f261bbcf737c1f99b8f96a973b1 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. <dataset>
  7. <!-- Country setup -->
  8. <country countryId="1" name="Rdc" x1="0" y1="0" x2="0" y2="0" />
  9. <adminLevel countryId="1" adminLevelId="1" name="Province" AllowAdd="0" />
  10. <adminLevel countryId="1" adminLevelId="2" name="Territoire" AllowAdd="0" ParentId="1"/>
  11. <locationType locationTypeId="1" countryId="1" name="localite" reuse="1"/>
  12. <locationType locationTypeId="2" countryId="1" name="Health Center" reuse="1"/>
  13. <locationType locationTypeId="3" countryId="1" name="Territorie" reuse="1" BoundAdminLevelId="2"/>
  14. <adminEntity adminLevelId="1" adminEntityId="1" name="Kinshasa" code="10" x1="0" y1="0" x2="0" y2="0"/>
  15. <adminEntity adminLevelId="1" adminEntityId="2" name="Sud Kivu" code="20" x1="0" y1="0" x2="0" y2="0"/>
  16. <adminEntity adminLevelId="1" adminEntityId="3" name="Nord Kivu" code="30" x1="0" y1="0" x2="0" y2="0"/>
  17. <adminEntity adminLevelId="1" adminEntityId="4" name="Ituri" code="40" x1="0" y1="0" x2="0" y2="0"/>
  18. <adminEntity adminLevelId="2" adminEntityId="10" adminEntityParentId="4" name="Bukavu" code="203" x1="0" y1="0" x2="0" y2="0"/>
  19. <adminEntity adminLevelId="2" adminEntityId="11" adminEntityParentId="2" name="Walungu" code="201" x1="0" y1="0" x2="0" y2="0"/>
  20. <adminEntity adminLevelId="2" adminEntityId="12" adminEntityParentId="2" name="Shabunda" code="202" x1="0" y1="0" x2="0" y2="0"/>
  21. <adminEntity adminLevelId="2" adminEntityId="13" adminEntityParentId="2" name="Kalehe" code="203" x1="0" y1="0" x2="0" y2="0"/>
  22. <adminEntity adminLevelId="2" adminEntityId="21" adminEntityParentId="4" name="Irumu" code="203" x1="0" y1="0" x2="0" y2="0"/>
  23. <!-- User setup -->
  24. <userLogin userId="1" name="Alex" email="akbertram@gmail.com" password="$2a$10$zc7fiaYWXwIN7w4LtFQL7u1ng3vbSNaJ7X24hzISDRMpWpvOHZu1." locale="fr" newUser="1" />
  25. <userLogin userId="2" name="Bavon" email="bavon@nrc.org" password="$2a$10$zc7fiaYWXwIN7w4LtFQL7u1ng3vbSNaJ7X24hzISDRMpWpvOHZu1." locale="fr" newUser="1" />
  26. <userLogin userId="5" name="Christian" email="christian@nrc.org" password="xyz" locale="fr" newUser="1" />
  27. <userLogin userId="3" name="Lisa" email="lisa@solidarites" password="xyz" locale="fr" newUser="1" />
  28. <userLogin userId="4" name="Marlene" email="marlene@solidarites" password="xyz" locale="fr" newUser="1" />
  29. <!-- Attributes -->
  30. <!-- NFI Attribute 1: Cause -->
  31. <attributeGroup attributeGroupId="1"
  32. name="cause"
  33. multipleAllowed="1"
  34. sortOrder="2"/>
  35. <attribute attributeGroupId="1"
  36. attributeId="1"
  37. sortOrder="2"
  38. name="Catastrophe Naturelle" />
  39. <attribute attributeGroupId="1"
  40. attributeId="2"
  41. sortOrder="1"
  42. name="Deplacement"/>
  43. <!-- NFI Attribute 2: Contenu de Kit -->
  44. <attributeGroup attributeGroupId="2"
  45. name="contenu du kit"
  46. multipleAllowed="1"
  47. sortOrder="1"/>
  48. <attribute attributeGroupId="2"
  49. attributeId="3"
  50. name="Casserole"
  51. sortOrder="1" />
  52. <attribute attributeGroupId="2"
  53. attributeId="4"
  54. name="Soap"
  55. sortOrder="2" />
  56. <!-- Database: PEAR -->
  57. <userDatabase databaseId="1" name="PEAR" countryId="1" ownerUserId="1"
  58. lastSchemaUpdate="1971-10-10" />
  59. <!-- PEAR Activity 1 : NFI Distribution -->
  60. <activity activityId="1"
  61. databaseId="1"
  62. name="NFI"
  63. reportingFrequency="0"
  64. allowEdit="1"
  65. isAssessment="0"
  66. sortOrder="1"
  67. locationTypeId="1"/>
  68. <attributeGroupInActivity activityId="1" attributeGroupId="1"/>
  69. <attributeGroupInActivity activityId="1" attributeGroupId="2"/>
  70. <!-- NFI Indicator 1: Beneficiaries -->
  71. <indicator indicatorId="1"
  72. activityId="1"
  73. name="beneficiaries"
  74. units="menages"
  75. aggregation="0"
  76. category="inputs"
  77. description="falling in lve"
  78. listHeader="no header really"
  79. collectIntervention="1"
  80. collectMonitoring="1"
  81. sortOrder="2"/>
  82. <!-- NFI Indicator 2: Bache -->
  83. <indicator indicatorId="2"
  84. activityId="1"
  85. name="baches"
  86. units="menages"
  87. aggregation="0"
  88. collectIntervention="1"
  89. collectMonitoring="1"
  90. category="outputs"
  91. listHeader="header"
  92. description="desc"
  93. sortOrder="1"/>
  94. <!-- NFI Indicator 3: Number of Distributions -->
  95. <indicator indicatorId="103"
  96. activityId="1"
  97. name="Nb. of distributions"
  98. units="distributions"
  99. aggregation="2"
  100. collectIntervention="0"
  101. collectMonitoring="0"
  102. category="outputs"
  103. listHeader="distribs"
  104. description="Nomber of distributions effectuees"
  105. sortOrder="3"/>
  106. <!-- PEAR Activity 2 : Kits Scolaire -->
  107. <activity activityId="2"
  108. databaseId="1"
  109. name="Distribution de Kits Scolaire"
  110. reportingFrequency="0"
  111. allowEdit="1"
  112. isAssessment="0"
  113. sortOrder="1"
  114. locationTypeId="1"/>
  115. <attributeGroupInActivity activityId="2" attributeGroupId="1"/>
  116. <!-- Database: PEAR PLUS -->
  117. <userDatabase databaseId="2" name="PEAR Plus" countryId="1" ownerUserId="1"
  118. lastSchemaUpdate="1971-10-10"/>
  119. <!-- PEAR PLUS Activity #1 - Support to health centers (monthly reporting) -->
  120. <activity activityId="3"
  121. databaseId="2"
  122. name="Appui aux centres de sant?Š"
  123. reportingFrequency="1"
  124. allowEdit="1"
  125. isAssessment="0"
  126. sortOrder="1"
  127. locationTypeId="1"/>
  128. <!-- Appui CS Indicator 1: Utilisation Rate -->
  129. <indicator indicatorId="5"
  130. activityId="3"
  131. name="Utilisaton rate"
  132. units="nc/hab/month"
  133. aggregation="1"
  134. collectIntervention="1"
  135. collectMonitoring="0"
  136. category="outputs"
  137. listHeader="header"
  138. description="desc"
  139. sortOrder="1"/>
  140. <activity activityId="4"
  141. databaseId="2"
  142. name="Reunification of child soliders"
  143. reportingFrequency="1"
  144. allowEdit="1"
  145. isAssessment="0"
  146. sortOrder="1"
  147. locationTypeId="3"/>
  148. <indicator indicatorId="6"
  149. activityId="4"
  150. name="Number of children"
  151. units="children"
  152. aggregation="1"
  153. collectIntervention="1"
  154. collectMonitoring="0"
  155. listHeader="kids"
  156. description="desc"
  157. sortOrder="1"/>
  158. <!-- PEAR Partners -->
  159. <partner partnerId="1" name="NRC" />
  160. <partnerInDatabase partnerId="1" databaseId="1"/>
  161. <partner partnerId="2" name="Solidarites" />
  162. <partnerInDatabase partnerId="2" databaseId="1"/>
  163. <!-- id=1 NFI Distribution at Penekusu, Sud Kivu 2 jan 2009-->
  164. <location locationId="1" name="Penekusu" locationTypeId="1" X="1.532" Y="27.323" DateCreated="1971-10-10" DateEdited="1971-10-10" />
  165. <locationAdminLink locationId="1" adminEntityId="2"/>
  166. <locationAdminLink locationId="1" adminEntityId="12"/>
  167. <site siteId="1" activityId="1" locationId="1" partnerId="1" Status="1" target="0" Date1="1971-10-10" Date2="1971-10-10" DateCreated="1971-10-10" DateEdited="1971-10-10"/>
  168. <attributeValue siteId="1" attributeId="1" value="0"/>
  169. <attributeValue siteId="1" attributeId="2" value="1"/>
  170. <reportingPeriod reportingPeriodId="1" siteId="1" monitoring="0" date1="1971-10-10" date2="1971-10-10" DateCreated="1971-10-10" DateEdited="1971-10-10"/>
  171. <indicatorValue reportingPeriodId="1" indicatorId="1" value="1500"/>
  172. <indicatorValue reportingPeriodId="1" indicatorId="2" value="500"/>
  173. <!-- id=2 NFI Distribution at Ngwshe, Sud Kivu 16 jan 2009 -->
  174. <location locationId="2" name="Ngshwe" locationTypeId="1" X="1.323" Y="28.232" DateCreated="1971-10-10" DateEdited="1971-10-10"/>
  175. <locationAdminLink locationId="2" adminEntityId="2"/>
  176. <locationAdminLink locationId="2" adminEntityId="11"/>
  177. <site siteId="2" activityId="1" locationId="2" partnerId="1" Status="1" target="1" Date1="1971-10-10" Date2="1971-10-10" DateCreated="1971-10-10" DateEdited="1971-10-10"/>
  178. <attributeValue siteId="2" attributeId="1" value="1"/>
  179. <attributeValue siteId="2" attributeId="2" value="1"/>
  180. <reportingPeriod reportingPeriodId="2" siteId="2" monitoring="0" date1="1971-10-10" date2="1971-10-10" DateCreated="1971-10-10" DateEdited="1971-10-10"/>
  181. <indicatorValue reportingPeriodId="2" indicatorId="1" value="3600"/>
  182. <indicatorValue reportingPeriodId="2" indicatorId="2" value="1200"/>
  183. <!-- id=3 NFI Distribution at Boga, Ituri 2008 -->
  184. <location locationId="3" name="Boga" locationTypeId="1" X="3.323" Y="27.232" DateCreated="1971-10-10" DateEdited="1971-10-10"/>
  185. <locationAdminLink locationId="3" adminEntityId="4"/>
  186. <locationAdminLink locationId="3" adminEntityId="21"/>
  187. <site siteId="3" activityId="1" locationId="3" partnerId="2" Status="1" target="0" Date1="1971-10-10" Date2="1971-10-10" DateCreated="1971-10-10" DateEdited="1971-10-10"/>
  188. <attributeValue siteId="3" attributeId="1" value="1"/>
  189. <attributeValue siteId="3" attributeId="2" value="0"/>
  190. <reportingPeriod reportingPeriodId="3" siteId="3" monitoring="0" date1="1971-10-10" date2="1971-10-10" DateCreated="1971-10-10" DateEdited="1971-10-10"/>
  191. <indicatorValue reportingPeriodId="3" indicatorId="1" value="10000"/>
  192. <indicatorValue reportingPeriodId="3" indicatorId="2" value="500"/>
  193. <!-- PEAR Plus Health Center Support in Ngweshe -->
  194. <location locationId="9" name="CS Ngweshe" locationTypeId="2" X="3.23" Y="27.232" DateCreated="1971-10-10" DateEdited="1971-10-10"/>
  195. <locationAdminLink locationId="9" adminEntityId="2"/>
  196. <locationAdminLink locationId="9" adminEntityId="11"/>
  197. <site siteId="9" activityId="3" locationId="9" partnerId="1" Status="1" target="0" Date1="1971-10-10" Date2="1971-10-10" DateCreated="1971-10-10" DateEdited="1971-10-10" />
  198. <reportingPeriod reportingPeriodId="91" siteId="9" monitoring="0" date1="1971-10-10" date2="1971-10-10" DateCreated="1971-10-10" DateEdited="1971-10-10" />
  199. <indicatorValue reportingPeriodId="91" indicatorId="5" value="0.1"/>
  200. <reportingPeriod reportingPeriodId="92" siteId="9" monitoring="0" date1="1971-10-10" date2="1971-10-10" DateCreated="1971-10-10" DateEdited="1971-10-10"/>
  201. <indicatorValue reportingPeriodId="92" indicatorId="5" value="0.3"/>
  202. <reportingPeriod reportingPeriodId="93" siteId="9" monitoring="0" date1="1971-10-10" date2="1971-10-10" DateCreated="1971-10-10" DateEdited="1971-10-10"/>
  203. <indicatorValue reportingPeriodId="93" indicatorId="5" value="0.4"/>
  204. <!-- Kit scolaires in Bukavu -->
  205. <location locationId="4" name="Boga" locationTypeId="1" X="3.323" Y="27.232" DateCreated="1971-10-10" DateEdited="1971-10-10"/>
  206. <locationAdminLink locationId="4" adminEntityId="2"/>
  207. <locationAdminLink locationId="4" adminEntityId="10"/>
  208. <site siteId="4" activityId="2" locationId="4" partnerId="2" Status="1" target="0" Date1="1971-10-10" Date2="1971-10-10" DateCreated="1971-10-10" DateEdited="1971-10-10" />
  209. <!-- Kit scolaires in Boga Ituri -->
  210. <site siteId="5" activityId="2" locationId="3" partnerId="1" Status="1" target="0" Date1="1971-10-10" Date2="1971-10-10" DateCreated="1971-10-10" DateEdited="1971-10-10"/>
  211. <!-- PEAR Plus child reunification in Walungu -->
  212. <location locationId="6" name="Walungu" locationTypeId="3" DateCreated="1971-10-10" DateEdited="1971-10-10" />
  213. <locationAdminLink locationId="6" adminEntityId="3"/>
  214. <locationAdminLink locationId="6" adminEntityId="11"/>
  215. <site siteId="6" activityId="4" locationId="6" partnerId="1" Status="1" target="0"
  216. Date1="1971-10-10" Date2="1971-10-10"
  217. DateCreated="1971-10-10" DateEdited="1971-10-10" />
  218. <reportingPeriod reportingPeriodId="601" siteId="6" monitoring="0" date1="1971-10-10" date2="1971-10-10"
  219. DateCreated="1971-10-10" DateEdited="1971-10-10"/>
  220. <indicatorValue reportingPeriodId="601" indicatorId="6" value="35"/>
  221. <reportingPeriod reportingPeriodId="602" siteId="6" monitoring="0" date1="1971-10-10" date2="1971-10-10"
  222. DateCreated="1971-10-10" DateEdited="1971-10-10"/>
  223. <indicatorValue reportingPeriodId="602" indicatorId="6" value="70"/>
  224. <!-- PEAR Plus child reunification in Shabunda -->
  225. <location locationId="7" name="Shabunda" locationTypeId="3" DateCreated="1971-10-10" DateEdited="1971-10-10" />
  226. <locationAdminLink locationId="7" adminEntityId="3"/>
  227. <locationAdminLink locationId="7" adminEntityId="12"/>
  228. <site siteId="7" activityId="4" locationId="7" partnerId="1" Status="1" target="0"
  229. Date1="1971-10-10" Date2="1971-10-10"
  230. DateCreated="1971-10-10" DateEdited="1971-10-10"/>
  231. </dataset>