/sigmah/src/test/resources/dbunit/client-sites-h2.db.xml
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 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 33 <!-- User setup --> 34 35 <userLogin userId="1" name="Alex" email="akbertram@gmail.com" password="$2a$10$zc7fiaYWXwIN7w4LtFQL7u1ng3vbSNaJ7X24hzISDRMpWpvOHZu1." locale="fr" newUser="1" /> 36 <userLogin userId="2" name="Bavon" email="bavon@nrc.org" password="$2a$10$zc7fiaYWXwIN7w4LtFQL7u1ng3vbSNaJ7X24hzISDRMpWpvOHZu1." locale="fr" newUser="1" /> 37 <userLogin userId="5" name="Christian" email="christian@nrc.org" password="xyz" locale="fr" newUser="1" /> 38 <userLogin userId="3" name="Lisa" email="lisa@solidarites" password="xyz" locale="fr" newUser="1" /> 39 40 <userLogin userId="4" name="Marlene" email="marlene@solidarites" password="xyz" locale="fr" newUser="1" /> 41 42 <!-- Attributes --> 43 44 <!-- NFI Attribute 1: Cause --> 45 46 <attributeGroup attributeGroupId="1" 47 name="cause" 48 multipleAllowed="1" 49 sortOrder="2"/> 50 51 <attribute attributeGroupId="1" 52 attributeId="1" 53 sortOrder="2" 54 name="Catastrophe Naturelle" /> 55 <attribute attributeGroupId="1" 56 attributeId="2" 57 sortOrder="1" 58 name="Deplacement"/> 59 60 <!-- NFI Attribute 2: Contenu de Kit --> 61 62 <attributeGroup attributeGroupId="2" 63 name="contenu du kit" 64 multipleAllowed="1" 65 sortOrder="1"/> 66 67 <attribute attributeGroupId="2" 68 attributeId="3" 69 name="Casserole" 70 sortOrder="1" /> 71 72 <attribute attributeGroupId="2" 73 attributeId="4" 74 name="Soap" 75 sortOrder="2" /> 76 77 <!-- Database: PEAR --> 78 79 <userDatabase databaseId="1" name="PEAR" countryId="1" ownerUserId="1" 80 lastSchemaUpdate="1971-10-10" /> 81 82 83 <!-- PEAR Activity 1 : NFI Distribution --> 84 85 <activity activityId="1" 86 databaseId="1" 87 name="NFI" 88 reportingFrequency="0" 89 allowEdit="1" 90 isAssessment="0" 91 sortOrder="1" 92 locationTypeId="1"/> 93 94 95 <attributeGroupInActivity activityId="1" attributeGroupId="1"/> 96 <attributeGroupInActivity activityId="1" attributeGroupId="2"/> 97 98 <!-- NFI Indicator 1: Beneficiaries --> 99 100 <indicator indicatorId="1" 101 activityId="1" 102 name="beneficiaries" 103 units="menages" 104 aggregation="0" 105 category="inputs" 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 name="baches" 117 units="menages" 118 aggregation="0" 119 collectIntervention="1" 120 collectMonitoring="1" 121 category="outputs" 122 listHeader="header" 123 description="desc" 124 sortOrder="1"/> 125 126 <!-- NFI Indicator 3: Number of Distributions --> 127 128 <indicator indicatorId="103" 129 activityId="1" 130 name="Nb. of distributions" 131 units="distributions" 132 aggregation="2" 133 collectIntervention="0" 134 collectMonitoring="0" 135 category="outputs" 136 listHeader="distribs" 137 description="Nomber of distributions effectuees" 138 sortOrder="3"/> 139 140 141 <!-- PEAR Activity 2 : Kits Scolaire --> 142 143 <activity activityId="2" 144 databaseId="1" 145 name="Distribution de Kits Scolaire" 146 reportingFrequency="0" 147 allowEdit="1" 148 isAssessment="0" 149 sortOrder="1" 150 locationTypeId="1"/> 151 152 <attributeGroupInActivity activityId="2" attributeGroupId="1"/> 153 154 <!-- Database: PEAR PLUS --> 155 156 <userDatabase databaseId="2" name="PEAR Plus" countryId="1" ownerUserId="1" 157 lastSchemaUpdate="1971-10-10"/> 158 159 <!-- PEAR PLUS Activity #1 - Support to health centers (monthly reporting) --> 160 161 <activity activityId="3" 162 databaseId="2" 163 name="Appui aux centres de sant?" 164 reportingFrequency="1" 165 allowEdit="1" 166 isAssessment="0" 167 sortOrder="1" 168 locationTypeId="1"/> 169 170 171 <!-- Appui CS Indicator 1: Utilisation Rate --> 172 173 <indicator indicatorId="5" 174 activityId="3" 175 name="Utilisaton rate" 176 units="nc/hab/month" 177 aggregation="1" 178 collectIntervention="1" 179 collectMonitoring="0" 180 category="outputs" 181 listHeader="header" 182 description="desc" 183 sortOrder="1"/> 184 185 <activity activityId="4" 186 databaseId="2" 187 name="Reunification of child soliders" 188 reportingFrequency="1" 189 allowEdit="1" 190 isAssessment="0" 191 sortOrder="1" 192 locationTypeId="3"/> 193 194 <indicator indicatorId="6" 195 activityId="4" 196 name="Number of children" 197 units="children" 198 aggregation="1" 199 collectIntervention="1" 200 collectMonitoring="0" 201 listHeader="kids" 202 description="desc" 203 sortOrder="1"/> 204 205 206 207 <!-- PEAR Partners --> 208 209 <partner partnerId="1" name="NRC" /> 210 <partnerInDatabase partnerId="1" databaseId="1"/> 211 212 <partner partnerId="2" name="Solidarites" /> 213 <partnerInDatabase partnerId="2" databaseId="1"/> 214 215 <!-- id=1 NFI Distribution at Penekusu, Sud Kivu 2 jan 2009--> 216 217 <location locationId="1" name="Penekusu" locationTypeId="1" X="1.532" Y="27.323" DateCreated="1971-10-10" DateEdited="1971-10-10" /> 218 <locationAdminLink locationId="1" adminEntityId="2"/> 219 <locationAdminLink locationId="1" adminEntityId="12"/> 220 221 <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"/> 222 <attributeValue siteId="1" attributeId="1" value="0"/> 223 <attributeValue siteId="1" attributeId="2" value="1"/> 224 225 <reportingPeriod reportingPeriodId="1" siteId="1" monitoring="0" date1="1971-10-10" date2="1971-10-10" DateCreated="1971-10-10" DateEdited="1971-10-10"/> 226 <indicatorValue reportingPeriodId="1" indicatorId="1" value="1500"/> 227 <indicatorValue reportingPeriodId="1" indicatorId="2" value="500"/> 228 229 230 <!-- id=2 NFI Distribution at Ngwshe, Sud Kivu 16 jan 2009 --> 231 232 <location locationId="2" name="Ngshwe" locationTypeId="1" X="1.323" Y="28.232" DateCreated="1971-10-10" DateEdited="1971-10-10"/> 233 <locationAdminLink locationId="2" adminEntityId="2"/> 234 <locationAdminLink locationId="2" adminEntityId="11"/> 235 236 <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"/> 237 <attributeValue siteId="2" attributeId="1" value="1"/> 238 <attributeValue siteId="2" attributeId="2" value="1"/> 239 240 <reportingPeriod reportingPeriodId="2" siteId="2" monitoring="0" date1="1971-10-10" date2="1971-10-10" DateCreated="1971-10-10" DateEdited="1971-10-10"/> 241 <indicatorValue reportingPeriodId="2" indicatorId="1" value="3600"/> 242 <indicatorValue reportingPeriodId="2" indicatorId="2" value="1200"/> 243 244 <!-- id=3 NFI Distribution at Boga, Ituri 2008 --> 245 246 <location locationId="3" name="Boga" locationTypeId="1" X="3.323" Y="27.232" DateCreated="1971-10-10" DateEdited="1971-10-10"/> 247 <locationAdminLink locationId="3" adminEntityId="4"/> 248 <locationAdminLink locationId="3" adminEntityId="21"/> 249 250 <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"/> 251 <attributeValue siteId="3" attributeId="1" value="1"/> 252 <attributeValue siteId="3" attributeId="2" value="0"/> 253 254 <reportingPeriod reportingPeriodId="3" siteId="3" monitoring="0" date1="1971-10-10" date2="1971-10-10" DateCreated="1971-10-10" DateEdited="1971-10-10"/> 255 <indicatorValue reportingPeriodId="3" indicatorId="1" value="10000"/> 256 <indicatorValue reportingPeriodId="3" indicatorId="2" value="500"/> 257 258 259 <!-- PEAR Plus Health Center Support in Ngweshe --> 260 261 <location locationId="9" name="CS Ngweshe" locationTypeId="2" X="3.23" Y="27.232" DateCreated="1971-10-10" DateEdited="1971-10-10"/> 262 <locationAdminLink locationId="9" adminEntityId="2"/> 263 <locationAdminLink locationId="9" adminEntityId="11"/> 264 265 <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" /> 266 267 <reportingPeriod reportingPeriodId="91" siteId="9" monitoring="0" date1="1971-10-10" date2="1971-10-10" DateCreated="1971-10-10" DateEdited="1971-10-10" /> 268 <indicatorValue reportingPeriodId="91" indicatorId="5" value="0.1"/> 269 270 <reportingPeriod reportingPeriodId="92" siteId="9" monitoring="0" date1="1971-10-10" date2="1971-10-10" DateCreated="1971-10-10" DateEdited="1971-10-10"/> 271 <indicatorValue reportingPeriodId="92" indicatorId="5" value="0.3"/> 272 273 <reportingPeriod reportingPeriodId="93" siteId="9" monitoring="0" date1="1971-10-10" date2="1971-10-10" DateCreated="1971-10-10" DateEdited="1971-10-10"/> 274 <indicatorValue reportingPeriodId="93" indicatorId="5" value="0.4"/> 275 276 277 <!-- Kit scolaires in Bukavu --> 278 <location locationId="4" name="Boga" locationTypeId="1" X="3.323" Y="27.232" DateCreated="1971-10-10" DateEdited="1971-10-10"/> 279 <locationAdminLink locationId="4" adminEntityId="2"/> 280 <locationAdminLink locationId="4" adminEntityId="10"/> 281 282 <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" /> 283 284 <!-- Kit scolaires in Boga Ituri --> 285 286 <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"/> 287 288 289 290 291 <!-- PEAR Plus child reunification in Walungu --> 292 293 <location locationId="6" name="Walungu" locationTypeId="3" DateCreated="1971-10-10" DateEdited="1971-10-10" /> 294 <locationAdminLink locationId="6" adminEntityId="3"/> 295 <locationAdminLink locationId="6" adminEntityId="11"/> 296 297 <site siteId="6" activityId="4" locationId="6" partnerId="1" Status="1" target="0" 298 Date1="1971-10-10" Date2="1971-10-10" 299 DateCreated="1971-10-10" DateEdited="1971-10-10" /> 300 301 <reportingPeriod reportingPeriodId="601" siteId="6" monitoring="0" date1="1971-10-10" date2="1971-10-10" 302 DateCreated="1971-10-10" DateEdited="1971-10-10"/> 303 <indicatorValue reportingPeriodId="601" indicatorId="6" value="35"/> 304 305 <reportingPeriod reportingPeriodId="602" siteId="6" monitoring="0" date1="1971-10-10" date2="1971-10-10" 306 DateCreated="1971-10-10" DateEdited="1971-10-10"/> 307 <indicatorValue reportingPeriodId="602" indicatorId="6" value="70"/> 308 309 310 <!-- PEAR Plus child reunification in Shabunda --> 311 312 <location locationId="7" name="Shabunda" locationTypeId="3" DateCreated="1971-10-10" DateEdited="1971-10-10" /> 313 <locationAdminLink locationId="7" adminEntityId="3"/> 314 <locationAdminLink locationId="7" adminEntityId="12"/> 315 316 <site siteId="7" activityId="4" locationId="7" partnerId="1" Status="1" target="0" 317 Date1="1971-10-10" Date2="1971-10-10" 318 DateCreated="1971-10-10" DateEdited="1971-10-10"/> 319 320 321 322</dataset>