1
<!DOCTYPE DataKiosk><DataKiosk version="1.0">
3
<string>/home/manyoso/datakiosk/samples/country.png</string>
7
<string>(default)</string>
9
<property name="driver">
10
<string>QMYSQL3</string>
12
<property name="database">
13
<string>world</string>
15
<property name="username">
16
<string>manyoso</string>
18
<property name="hostname">
19
<string>localhost</string>
21
<property name="port">
25
<property name="name">
29
<property name="name">
34
<property name="name">
39
<property name="name">
40
<string>CountryCode</string>
44
<property name="name">
45
<string>District</string>
49
<property name="name">
50
<string>Population</string>
55
<property name="name">
56
<string>Country</string>
59
<property name="name">
64
<property name="name">
69
<property name="name">
70
<string>Continent</string>
74
<property name="name">
75
<string>Region</string>
79
<property name="name">
80
<string>SurfaceArea</string>
84
<property name="name">
85
<string>IndepYear</string>
89
<property name="name">
90
<string>Population</string>
94
<property name="name">
95
<string>LifeExpectancy</string>
99
<property name="name">
104
<property name="name">
105
<string>GNPOld</string>
109
<property name="name">
110
<string>LocalName</string>
114
<property name="name">
115
<string>GovernmentForm</string>
119
<property name="name">
120
<string>HeadOfState</string>
124
<property name="name">
125
<string>Capital</string>
129
<property name="name">
130
<string>Code2</string>
135
<property name="name">
136
<string>CountryLanguage</string>
139
<property name="name">
140
<string>CountryCode</string>
144
<property name="name">
145
<string>Language</string>
149
<property name="name">
150
<string>IsOfficial</string>
154
<property name="name">
155
<string>Percentage</string>
161
<property name="connection">
162
<string>(default)</string>
164
<property name="tablename">
165
<string>Country</string>
167
<property name="number">
170
<property name="parentname">
173
<property name="relationtoparent">
176
<property name="parentkey">
179
<property name="foreignkey">
182
<property name="name">
183
<string>Countries</string>
185
<property name="icon">
186
<string>/home/manyoso/dev/kde/trunk/extragear/office/datakiosk/samples/country.png</string>
188
<property name="readonly">
189
<string>false</string>
191
<property name="confirminsert">
192
<string>false</string>
194
<property name="confirmupdate">
195
<string>false</string>
197
<property name="confirmdelete">
198
<string>true</string>
200
<property name="confirmcancel">
201
<string>false</string>
203
<property name="sorting">
204
<string>true</string>
207
<property name="orderby">
208
<string>Continent ASC</string>
212
<property name="orderby">
213
<string>Name ASC</string>
217
<property name="name">
218
<string>Code</string>
220
<property name="type">
223
<property name="required">
226
<property name="calculated">
227
<string>false</string>
229
<property name="virtual">
230
<string>false</string>
232
<property name="equation">
235
<property name="label">
236
<string>Code</string>
238
<property name="number">
241
<property name="width">
244
<property name="foreign">
245
<string>false</string>
247
<property name="primary">
248
<string>true</string>
250
<property name="hidden">
251
<string>true</string>
253
<property name="resizable">
254
<string>false</string>
256
<property name="sortable">
257
<string>false</string>
261
<property name="name">
262
<string>LifeExpectancy</string>
264
<property name="type">
267
<property name="required">
270
<property name="calculated">
271
<string>false</string>
273
<property name="virtual">
274
<string>false</string>
276
<property name="equation">
279
<property name="label">
280
<string>LifeExpectancy</string>
282
<property name="number">
285
<property name="width">
288
<property name="foreign">
289
<string>false</string>
291
<property name="primary">
292
<string>false</string>
294
<property name="hidden">
295
<string>true</string>
297
<property name="resizable">
298
<string>true</string>
300
<property name="sortable">
301
<string>true</string>
305
<property name="name">
306
<string>GNPOld</string>
308
<property name="type">
311
<property name="required">
314
<property name="calculated">
315
<string>false</string>
317
<property name="virtual">
318
<string>false</string>
320
<property name="equation">
323
<property name="label">
324
<string>GNPOld</string>
326
<property name="number">
329
<property name="width">
332
<property name="foreign">
333
<string>false</string>
335
<property name="primary">
336
<string>false</string>
338
<property name="hidden">
339
<string>true</string>
341
<property name="resizable">
342
<string>true</string>
344
<property name="sortable">
345
<string>true</string>
349
<property name="name">
350
<string>LocalName</string>
352
<property name="type">
355
<property name="required">
358
<property name="calculated">
359
<string>false</string>
361
<property name="virtual">
362
<string>false</string>
364
<property name="equation">
367
<property name="label">
368
<string>LocalName</string>
370
<property name="number">
373
<property name="width">
376
<property name="foreign">
377
<string>false</string>
379
<property name="primary">
380
<string>false</string>
382
<property name="hidden">
383
<string>true</string>
385
<property name="resizable">
386
<string>true</string>
388
<property name="sortable">
389
<string>true</string>
393
<property name="name">
394
<string>GovernmentForm</string>
396
<property name="type">
399
<property name="required">
402
<property name="calculated">
403
<string>false</string>
405
<property name="virtual">
406
<string>false</string>
408
<property name="equation">
411
<property name="label">
412
<string>GovernmentForm</string>
414
<property name="number">
417
<property name="width">
420
<property name="foreign">
421
<string>false</string>
423
<property name="primary">
424
<string>false</string>
426
<property name="hidden">
427
<string>true</string>
429
<property name="resizable">
430
<string>true</string>
432
<property name="sortable">
433
<string>true</string>
437
<property name="name">
438
<string>HeadOfState</string>
440
<property name="type">
443
<property name="required">
446
<property name="calculated">
447
<string>false</string>
449
<property name="virtual">
450
<string>false</string>
452
<property name="equation">
455
<property name="label">
456
<string>HeadOfState</string>
458
<property name="number">
461
<property name="width">
464
<property name="foreign">
465
<string>false</string>
467
<property name="primary">
468
<string>false</string>
470
<property name="hidden">
471
<string>true</string>
473
<property name="resizable">
474
<string>true</string>
476
<property name="sortable">
477
<string>true</string>
481
<property name="name">
482
<string>Code2</string>
484
<property name="type">
487
<property name="required">
490
<property name="calculated">
491
<string>false</string>
493
<property name="virtual">
494
<string>false</string>
496
<property name="equation">
499
<property name="label">
500
<string>Code2</string>
502
<property name="number">
505
<property name="width">
508
<property name="foreign">
509
<string>false</string>
511
<property name="primary">
512
<string>false</string>
514
<property name="hidden">
515
<string>true</string>
517
<property name="resizable">
518
<string>true</string>
520
<property name="sortable">
521
<string>true</string>
525
<property name="name">
526
<string>Name</string>
528
<property name="type">
531
<property name="required">
534
<property name="calculated">
535
<string>false</string>
537
<property name="virtual">
538
<string>false</string>
540
<property name="equation">
543
<property name="label">
544
<string>Name</string>
546
<property name="number">
549
<property name="width">
552
<property name="foreign">
553
<string>false</string>
555
<property name="primary">
556
<string>false</string>
558
<property name="hidden">
559
<string>false</string>
561
<property name="resizable">
562
<string>true</string>
564
<property name="sortable">
565
<string>true</string>
569
<property name="name">
570
<string>Continent</string>
572
<property name="type">
575
<property name="required">
578
<property name="calculated">
579
<string>false</string>
581
<property name="virtual">
582
<string>false</string>
584
<property name="equation">
587
<property name="label">
588
<string>Continent</string>
590
<property name="number">
593
<property name="width">
596
<property name="foreign">
597
<string>false</string>
599
<property name="primary">
600
<string>false</string>
602
<property name="hidden">
603
<string>false</string>
605
<property name="resizable">
606
<string>true</string>
608
<property name="sortable">
609
<string>true</string>
613
<property name="name">
614
<string>Capital</string>
616
<property name="type">
619
<property name="required">
622
<property name="calculated">
623
<string>false</string>
625
<property name="virtual">
626
<string>false</string>
628
<property name="equation">
631
<property name="label">
632
<string>Capital</string>
634
<property name="number">
637
<property name="width">
640
<property name="foreign">
641
<string>true</string>
643
<property name="primary">
644
<string>false</string>
646
<property name="hidden">
647
<string>false</string>
649
<property name="resizable">
650
<string>true</string>
652
<property name="sortable">
653
<string>true</string>
656
<property name="table">
657
<string>City</string>
659
<property name="key">
662
<property name="field">
663
<string>Name</string>
665
<property name="type">
668
<property name="number">
671
<property name="editorwidth">
675
<property name="name">
676
<string>Name</string>
678
<property name="type">
681
<property name="number">
684
<property name="editorwidth">
687
<property name="foreign">
688
<string>false</string>
690
<property name="primary">
691
<string>true</string>
693
<property name="reporter">
694
<string>false</string>
696
<property name="hidden">
697
<string>false</string>
701
<property name="name">
702
<string>CountryCode</string>
704
<property name="type">
707
<property name="number">
710
<property name="editorwidth">
713
<property name="foreign">
714
<string>true</string>
716
<property name="primary">
717
<string>false</string>
719
<property name="reporter">
720
<string>false</string>
722
<property name="hidden">
723
<string>false</string>
726
<property name="table">
727
<string>Country</string>
729
<property name="key">
730
<string>Code</string>
732
<property name="field">
733
<string>Continent</string>
735
<property name="constraint">
736
<string>Code</string>
738
<property name="type">
741
<property name="number">
744
<property name="editorwidth">
748
<property name="name">
749
<string>Continent</string>
751
<property name="type">
754
<property name="number">
757
<property name="editorwidth">
760
<property name="foreign">
761
<string>false</string>
763
<property name="primary">
764
<string>true</string>
766
<property name="reporter">
767
<string>false</string>
769
<property name="hidden">
770
<string>false</string>
776
<property name="name">
777
<string>District</string>
779
<property name="type">
782
<property name="number">
785
<property name="editorwidth">
788
<property name="foreign">
789
<string>false</string>
791
<property name="primary">
792
<string>false</string>
794
<property name="reporter">
795
<string>false</string>
797
<property name="hidden">
798
<string>false</string>
804
<property name="name">
807
<property name="type">
810
<property name="required">
813
<property name="calculated">
814
<string>false</string>
816
<property name="virtual">
817
<string>false</string>
819
<property name="equation">
822
<property name="label">
825
<property name="number">
828
<property name="width">
831
<property name="foreign">
832
<string>false</string>
834
<property name="primary">
835
<string>false</string>
837
<property name="hidden">
838
<string>false</string>
840
<property name="resizable">
841
<string>true</string>
843
<property name="sortable">
844
<string>true</string>
848
<property name="name">
849
<string>SurfaceArea</string>
851
<property name="type">
854
<property name="required">
857
<property name="calculated">
858
<string>false</string>
860
<property name="virtual">
861
<string>false</string>
863
<property name="equation">
866
<property name="label">
867
<string>Surface Area</string>
869
<property name="number">
872
<property name="width">
875
<property name="foreign">
876
<string>false</string>
878
<property name="primary">
879
<string>false</string>
881
<property name="hidden">
882
<string>false</string>
884
<property name="resizable">
885
<string>true</string>
887
<property name="sortable">
888
<string>true</string>
892
<property name="name">
893
<string>Region</string>
895
<property name="type">
898
<property name="required">
901
<property name="calculated">
902
<string>false</string>
904
<property name="virtual">
905
<string>false</string>
907
<property name="equation">
910
<property name="label">
911
<string>Region</string>
913
<property name="number">
916
<property name="width">
919
<property name="foreign">
920
<string>false</string>
922
<property name="primary">
923
<string>false</string>
925
<property name="hidden">
926
<string>false</string>
928
<property name="resizable">
929
<string>true</string>
931
<property name="sortable">
932
<string>true</string>
936
<property name="name">
937
<string>Population</string>
939
<property name="type">
942
<property name="required">
945
<property name="calculated">
946
<string>false</string>
948
<property name="virtual">
949
<string>false</string>
951
<property name="equation">
954
<property name="label">
955
<string>Population</string>
957
<property name="number">
960
<property name="width">
963
<property name="foreign">
964
<string>false</string>
966
<property name="primary">
967
<string>false</string>
969
<property name="hidden">
970
<string>false</string>
972
<property name="resizable">
973
<string>true</string>
975
<property name="sortable">
976
<string>true</string>
980
<property name="name">
981
<string>IndepYear</string>
983
<property name="type">
986
<property name="required">
989
<property name="calculated">
990
<string>false</string>
992
<property name="virtual">
993
<string>false</string>
995
<property name="equation">
998
<property name="label">
999
<string>Independence</string>
1001
<property name="number">
1004
<property name="width">
1005
<string>100</string>
1007
<property name="foreign">
1008
<string>false</string>
1010
<property name="primary">
1011
<string>false</string>
1013
<property name="hidden">
1014
<string>false</string>
1016
<property name="resizable">
1017
<string>true</string>
1019
<property name="sortable">
1020
<string>true</string>
1025
<property name="connection">
1026
<string>(default)</string>
1028
<property name="tablename">
1029
<string>CountryLanguage</string>
1031
<property name="number">
1034
<property name="parentname">
1035
<string>Countries</string>
1037
<property name="relationtoparent">
1040
<property name="parentkey">
1041
<string>Code</string>
1043
<property name="foreignkey">
1044
<string>CountryCode</string>
1046
<property name="name">
1047
<string>Languages</string>
1049
<property name="icon">
1050
<string>/home/manyoso/dev/kde/trunk/extragear/office/datakiosk/samples/language.png</string>
1052
<property name="readonly">
1053
<string>false</string>
1055
<property name="confirminsert">
1056
<string>false</string>
1058
<property name="confirmupdate">
1059
<string>false</string>
1061
<property name="confirmdelete">
1062
<string>true</string>
1064
<property name="confirmcancel">
1065
<string>false</string>
1067
<property name="sorting">
1068
<string>true</string>
1071
<property name="name">
1072
<string>CountryCode</string>
1074
<property name="type">
1077
<property name="required">
1080
<property name="calculated">
1081
<string>false</string>
1083
<property name="virtual">
1084
<string>false</string>
1086
<property name="equation">
1089
<property name="label">
1090
<string>CountryCode</string>
1092
<property name="number">
1095
<property name="width">
1098
<property name="foreign">
1099
<string>false</string>
1101
<property name="primary">
1102
<string>true</string>
1104
<property name="hidden">
1105
<string>true</string>
1107
<property name="resizable">
1108
<string>false</string>
1110
<property name="sortable">
1111
<string>false</string>
1115
<property name="name">
1116
<string>Language</string>
1118
<property name="type">
1121
<property name="required">
1124
<property name="calculated">
1125
<string>false</string>
1127
<property name="virtual">
1128
<string>false</string>
1130
<property name="equation">
1133
<property name="label">
1134
<string>Language</string>
1136
<property name="number">
1139
<property name="width">
1140
<string>100</string>
1142
<property name="foreign">
1143
<string>false</string>
1145
<property name="primary">
1146
<string>true</string>
1148
<property name="hidden">
1149
<string>false</string>
1151
<property name="resizable">
1152
<string>false</string>
1154
<property name="sortable">
1155
<string>false</string>
1159
<property name="name">
1160
<string>IsOfficial</string>
1162
<property name="type">
1165
<property name="required">
1168
<property name="calculated">
1169
<string>false</string>
1171
<property name="virtual">
1172
<string>false</string>
1174
<property name="equation">
1177
<property name="label">
1178
<string>Official</string>
1180
<property name="number">
1183
<property name="width">
1184
<string>100</string>
1186
<property name="foreign">
1187
<string>false</string>
1189
<property name="primary">
1190
<string>false</string>
1192
<property name="hidden">
1193
<string>false</string>
1195
<property name="resizable">
1196
<string>true</string>
1198
<property name="sortable">
1199
<string>true</string>
1203
<property name="name">
1204
<string>Percentage</string>
1206
<property name="type">
1209
<property name="required">
1212
<property name="calculated">
1213
<string>false</string>
1215
<property name="virtual">
1216
<string>false</string>
1218
<property name="equation">
1221
<property name="label">
1222
<string>Percentage</string>
1224
<property name="number">
1227
<property name="width">
1228
<string>100</string>
1230
<property name="foreign">
1231
<string>false</string>
1233
<property name="primary">
1234
<string>false</string>
1236
<property name="hidden">
1237
<string>false</string>
1239
<property name="resizable">
1240
<string>true</string>
1242
<property name="sortable">
1243
<string>true</string>
1247
<property name="name">
1248
<string>#Speakers</string>
1250
<property name="type">
1253
<property name="required">
1256
<property name="calculated">
1257
<string>true</string>
1259
<property name="virtual">
1260
<string>true</string>
1262
<property name="equation">
1263
<string>[f:Countries.Population] * [f:Languages.Percentage] / [#:100]</string>
1265
<property name="label">
1266
<string>#Speakers</string>
1268
<property name="number">
1271
<property name="width">
1274
<property name="foreign">
1275
<string>false</string>
1277
<property name="primary">
1278
<string>false</string>
1280
<property name="hidden">
1281
<string>false</string>
1283
<property name="resizable">
1284
<string>false</string>
1286
<property name="sortable">
1287
<string>false</string>
1292
<property name="connection">
1293
<string>(default)</string>
1295
<property name="tablename">
1296
<string>City</string>
1298
<property name="number">
1301
<property name="parentname">
1302
<string>Countries</string>
1304
<property name="relationtoparent">
1307
<property name="parentkey">
1308
<string>Code</string>
1310
<property name="foreignkey">
1311
<string>CountryCode</string>
1313
<property name="name">
1314
<string>Cities</string>
1316
<property name="icon">
1317
<string>/home/manyoso/dev/kde/trunk/extragear/office/datakiosk/samples/city.png</string>
1319
<property name="readonly">
1320
<string>false</string>
1322
<property name="confirminsert">
1323
<string>false</string>
1325
<property name="confirmupdate">
1326
<string>false</string>
1328
<property name="confirmdelete">
1329
<string>true</string>
1331
<property name="confirmcancel">
1332
<string>false</string>
1334
<property name="sorting">
1335
<string>true</string>
1338
<property name="name">
1341
<property name="type">
1344
<property name="required">
1347
<property name="calculated">
1348
<string>false</string>
1350
<property name="virtual">
1351
<string>false</string>
1353
<property name="equation">
1356
<property name="label">
1359
<property name="number">
1362
<property name="width">
1365
<property name="foreign">
1366
<string>false</string>
1368
<property name="primary">
1369
<string>true</string>
1371
<property name="hidden">
1372
<string>true</string>
1374
<property name="resizable">
1375
<string>false</string>
1377
<property name="sortable">
1378
<string>false</string>
1382
<property name="name">
1383
<string>CountryCode</string>
1385
<property name="type">
1388
<property name="required">
1391
<property name="calculated">
1392
<string>false</string>
1394
<property name="virtual">
1395
<string>false</string>
1397
<property name="equation">
1400
<property name="label">
1401
<string>CountryCode</string>
1403
<property name="number">
1406
<property name="width">
1409
<property name="foreign">
1410
<string>false</string>
1412
<property name="primary">
1413
<string>false</string>
1415
<property name="hidden">
1416
<string>true</string>
1418
<property name="resizable">
1419
<string>true</string>
1421
<property name="sortable">
1422
<string>true</string>
1426
<property name="name">
1427
<string>Name</string>
1429
<property name="type">
1432
<property name="required">
1435
<property name="calculated">
1436
<string>false</string>
1438
<property name="virtual">
1439
<string>false</string>
1441
<property name="equation">
1444
<property name="label">
1445
<string>Name</string>
1447
<property name="number">
1450
<property name="width">
1451
<string>100</string>
1453
<property name="foreign">
1454
<string>false</string>
1456
<property name="primary">
1457
<string>false</string>
1459
<property name="hidden">
1460
<string>false</string>
1462
<property name="resizable">
1463
<string>true</string>
1465
<property name="sortable">
1466
<string>true</string>
1470
<property name="name">
1471
<string>District</string>
1473
<property name="type">
1476
<property name="required">
1479
<property name="calculated">
1480
<string>false</string>
1482
<property name="virtual">
1483
<string>false</string>
1485
<property name="equation">
1488
<property name="label">
1489
<string>District</string>
1491
<property name="number">
1494
<property name="width">
1495
<string>100</string>
1497
<property name="foreign">
1498
<string>false</string>
1500
<property name="primary">
1501
<string>false</string>
1503
<property name="hidden">
1504
<string>false</string>
1506
<property name="resizable">
1507
<string>true</string>
1509
<property name="sortable">
1510
<string>true</string>
1514
<property name="name">
1515
<string>Population</string>
1517
<property name="type">
1520
<property name="required">
1523
<property name="calculated">
1524
<string>false</string>
1526
<property name="virtual">
1527
<string>false</string>
1529
<property name="equation">
1532
<property name="label">
1533
<string>Population</string>
1535
<property name="number">
1538
<property name="width">
1539
<string>100</string>
1541
<property name="foreign">
1542
<string>false</string>
1544
<property name="primary">
1545
<string>false</string>
1547
<property name="hidden">
1548
<string>false</string>
1550
<property name="resizable">
1551
<string>true</string>
1553
<property name="sortable">
1554
<string>true</string>
1559
<property name="name">
1560
<string>Large cities in the Mid East</string>
1562
<property name="searchmode">
1565
<property name="searchlevel">
1568
<property name="parentname">
1569
<string>Countries</string>
1572
<property name="query">
1573
<string>Middle East</string>
1575
<property name="datatable">
1576
<string>Countries</string>
1578
<property name="datafield">
1579
<string>Region</string>
1581
<property name="prompt">
1582
<string>false</string>
1584
<property name="matchmode">
1589
<property name="query">
1590
<string>3000000</string>
1592
<property name="datatable">
1593
<string>Cities</string>
1595
<property name="datafield">
1596
<string>Population</string>
1598
<property name="prompt">
1599
<string>false</string>
1601
<property name="matchmode">
1607
<property name="name">
1608
<string>Cities Report</string>
1610
<property name="icon">
1611
<string>kugar.png</string>
1613
<property name="templateurl">
1614
<string>/home/manyoso/dev/kde/trunk/extragear/office/datakiosk/samples/world-mysql.kut</string>
1616
<property name="parentname">
1617
<string>Countries</string>
1620
<property name="name">
1621
<string>Countries</string>
1625
<property name="name">
1626
<string>Cities</string>
1630
<property name="orderby">
1631
<string>Countries.Name ASC</string>
1635
<property name="orderby">
1636
<string>Cities.Population DESC</string>