~ubuntu-branches/ubuntu/maverick/datakiosk/maverick

« back to all changes in this revision

Viewing changes to src/samples/world-mysql.pro

  • Committer: Bazaar Package Importer
  • Author(s): Jonathan Riddell
  • Date: 2005-06-27 22:48:06 UTC
  • Revision ID: james.westby@ubuntu.com-20050627224806-8farkci1dc2onhbs
Tags: upstream-0.7
ImportĀ upstreamĀ versionĀ 0.7

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
<!DOCTYPE DataKiosk><DataKiosk version="1.0">
 
2
<property name="icon">
 
3
    <string>/home/manyoso/datakiosk/samples/country.png</string>
 
4
</property>
 
5
<connection>
 
6
    <property name="name">
 
7
        <string>(default)</string>
 
8
    </property>
 
9
    <property name="driver">
 
10
        <string>QMYSQL3</string>
 
11
    </property>
 
12
    <property name="database">
 
13
        <string>world</string>
 
14
    </property>
 
15
    <property name="username">
 
16
        <string>manyoso</string>
 
17
    </property>
 
18
    <property name="hostname">
 
19
        <string>localhost</string>
 
20
    </property>
 
21
    <property name="port">
 
22
        <string>-1</string>
 
23
    </property>
 
24
    <table>
 
25
        <property name="name">
 
26
            <string>City</string>
 
27
        </property>
 
28
        <field>
 
29
            <property name="name">
 
30
                <string>ID</string>
 
31
            </property>
 
32
        </field>
 
33
        <field>
 
34
            <property name="name">
 
35
                <string>Name</string>
 
36
            </property>
 
37
        </field>
 
38
        <field>
 
39
            <property name="name">
 
40
                <string>CountryCode</string>
 
41
            </property>
 
42
        </field>
 
43
        <field>
 
44
            <property name="name">
 
45
                <string>District</string>
 
46
            </property>
 
47
        </field>
 
48
        <field>
 
49
            <property name="name">
 
50
                <string>Population</string>
 
51
            </property>
 
52
        </field>
 
53
    </table>
 
54
    <table>
 
55
        <property name="name">
 
56
            <string>Country</string>
 
57
        </property>
 
58
        <field>
 
59
            <property name="name">
 
60
                <string>Code</string>
 
61
            </property>
 
62
        </field>
 
63
        <field>
 
64
            <property name="name">
 
65
                <string>Name</string>
 
66
            </property>
 
67
        </field>
 
68
        <field>
 
69
            <property name="name">
 
70
                <string>Continent</string>
 
71
            </property>
 
72
        </field>
 
73
        <field>
 
74
            <property name="name">
 
75
                <string>Region</string>
 
76
            </property>
 
77
        </field>
 
78
        <field>
 
79
            <property name="name">
 
80
                <string>SurfaceArea</string>
 
81
            </property>
 
82
        </field>
 
83
        <field>
 
84
            <property name="name">
 
85
                <string>IndepYear</string>
 
86
            </property>
 
87
        </field>
 
88
        <field>
 
89
            <property name="name">
 
90
                <string>Population</string>
 
91
            </property>
 
92
        </field>
 
93
        <field>
 
94
            <property name="name">
 
95
                <string>LifeExpectancy</string>
 
96
            </property>
 
97
        </field>
 
98
        <field>
 
99
            <property name="name">
 
100
                <string>GNP</string>
 
101
            </property>
 
102
        </field>
 
103
        <field>
 
104
            <property name="name">
 
105
                <string>GNPOld</string>
 
106
            </property>
 
107
        </field>
 
108
        <field>
 
109
            <property name="name">
 
110
                <string>LocalName</string>
 
111
            </property>
 
112
        </field>
 
113
        <field>
 
114
            <property name="name">
 
115
                <string>GovernmentForm</string>
 
116
            </property>
 
117
        </field>
 
118
        <field>
 
119
            <property name="name">
 
120
                <string>HeadOfState</string>
 
121
            </property>
 
122
        </field>
 
123
        <field>
 
124
            <property name="name">
 
125
                <string>Capital</string>
 
126
            </property>
 
127
        </field>
 
128
        <field>
 
129
            <property name="name">
 
130
                <string>Code2</string>
 
131
            </property>
 
132
        </field>
 
133
    </table>
 
134
    <table>
 
135
        <property name="name">
 
136
            <string>CountryLanguage</string>
 
137
        </property>
 
138
        <field>
 
139
            <property name="name">
 
140
                <string>CountryCode</string>
 
141
            </property>
 
142
        </field>
 
143
        <field>
 
144
            <property name="name">
 
145
                <string>Language</string>
 
146
            </property>
 
147
        </field>
 
148
        <field>
 
149
            <property name="name">
 
150
                <string>IsOfficial</string>
 
151
            </property>
 
152
        </field>
 
153
        <field>
 
154
            <property name="name">
 
155
                <string>Percentage</string>
 
156
            </property>
 
157
        </field>
 
158
    </table>
 
159
</connection>
 
160
<datatable>
 
161
    <property name="connection">
 
162
        <string>(default)</string>
 
163
    </property>
 
164
    <property name="tablename">
 
165
        <string>Country</string>
 
166
    </property>
 
167
    <property name="number">
 
168
        <string>0</string>
 
169
    </property>
 
170
    <property name="parentname">
 
171
        <string></string>
 
172
    </property>
 
173
    <property name="relationtoparent">
 
174
        <string>0</string>
 
175
    </property>
 
176
    <property name="parentkey">
 
177
        <string></string>
 
178
    </property>
 
179
    <property name="foreignkey">
 
180
        <string></string>
 
181
    </property>
 
182
    <property name="name">
 
183
        <string>Countries</string>
 
184
    </property>
 
185
    <property name="icon">
 
186
        <string>/home/manyoso/dev/kde/trunk/extragear/office/datakiosk/samples/country.png</string>
 
187
    </property>
 
188
    <property name="readonly">
 
189
        <string>false</string>
 
190
    </property>
 
191
    <property name="confirminsert">
 
192
        <string>false</string>
 
193
    </property>
 
194
    <property name="confirmupdate">
 
195
        <string>false</string>
 
196
    </property>
 
197
    <property name="confirmdelete">
 
198
        <string>true</string>
 
199
    </property>
 
200
    <property name="confirmcancel">
 
201
        <string>false</string>
 
202
    </property>
 
203
    <property name="sorting">
 
204
        <string>true</string>
 
205
    </property>
 
206
    <sort>
 
207
        <property name="orderby">
 
208
            <string>Continent ASC</string>
 
209
        </property>
 
210
    </sort>
 
211
    <sort>
 
212
        <property name="orderby">
 
213
            <string>Name ASC</string>
 
214
        </property>
 
215
    </sort>
 
216
    <datafield>
 
217
        <property name="name">
 
218
            <string>Code</string>
 
219
        </property>
 
220
        <property name="type">
 
221
            <string>3</string>
 
222
        </property>
 
223
        <property name="required">
 
224
            <string>0</string>
 
225
        </property>
 
226
        <property name="calculated">
 
227
            <string>false</string>
 
228
        </property>
 
229
        <property name="virtual">
 
230
            <string>false</string>
 
231
        </property>
 
232
        <property name="equation">
 
233
            <string></string>
 
234
        </property>
 
235
        <property name="label">
 
236
            <string>Code</string>
 
237
        </property>
 
238
        <property name="number">
 
239
            <string>-1</string>
 
240
        </property>
 
241
        <property name="width">
 
242
            <string>-1</string>
 
243
        </property>
 
244
        <property name="foreign">
 
245
            <string>false</string>
 
246
        </property>
 
247
        <property name="primary">
 
248
            <string>true</string>
 
249
        </property>
 
250
        <property name="hidden">
 
251
            <string>true</string>
 
252
        </property>
 
253
        <property name="resizable">
 
254
            <string>false</string>
 
255
        </property>
 
256
        <property name="sortable">
 
257
            <string>false</string>
 
258
        </property>
 
259
    </datafield>
 
260
    <datafield>
 
261
        <property name="name">
 
262
            <string>LifeExpectancy</string>
 
263
        </property>
 
264
        <property name="type">
 
265
            <string>19</string>
 
266
        </property>
 
267
        <property name="required">
 
268
            <string>0</string>
 
269
        </property>
 
270
        <property name="calculated">
 
271
            <string>false</string>
 
272
        </property>
 
273
        <property name="virtual">
 
274
            <string>false</string>
 
275
        </property>
 
276
        <property name="equation">
 
277
            <string></string>
 
278
        </property>
 
279
        <property name="label">
 
280
            <string>LifeExpectancy</string>
 
281
        </property>
 
282
        <property name="number">
 
283
            <string>-1</string>
 
284
        </property>
 
285
        <property name="width">
 
286
            <string>-1</string>
 
287
        </property>
 
288
        <property name="foreign">
 
289
            <string>false</string>
 
290
        </property>
 
291
        <property name="primary">
 
292
            <string>false</string>
 
293
        </property>
 
294
        <property name="hidden">
 
295
            <string>true</string>
 
296
        </property>
 
297
        <property name="resizable">
 
298
            <string>true</string>
 
299
        </property>
 
300
        <property name="sortable">
 
301
            <string>true</string>
 
302
        </property>
 
303
    </datafield>
 
304
    <datafield>
 
305
        <property name="name">
 
306
            <string>GNPOld</string>
 
307
        </property>
 
308
        <property name="type">
 
309
            <string>19</string>
 
310
        </property>
 
311
        <property name="required">
 
312
            <string>0</string>
 
313
        </property>
 
314
        <property name="calculated">
 
315
            <string>false</string>
 
316
        </property>
 
317
        <property name="virtual">
 
318
            <string>false</string>
 
319
        </property>
 
320
        <property name="equation">
 
321
            <string></string>
 
322
        </property>
 
323
        <property name="label">
 
324
            <string>GNPOld</string>
 
325
        </property>
 
326
        <property name="number">
 
327
            <string>-1</string>
 
328
        </property>
 
329
        <property name="width">
 
330
            <string>-1</string>
 
331
        </property>
 
332
        <property name="foreign">
 
333
            <string>false</string>
 
334
        </property>
 
335
        <property name="primary">
 
336
            <string>false</string>
 
337
        </property>
 
338
        <property name="hidden">
 
339
            <string>true</string>
 
340
        </property>
 
341
        <property name="resizable">
 
342
            <string>true</string>
 
343
        </property>
 
344
        <property name="sortable">
 
345
            <string>true</string>
 
346
        </property>
 
347
    </datafield>
 
348
    <datafield>
 
349
        <property name="name">
 
350
            <string>LocalName</string>
 
351
        </property>
 
352
        <property name="type">
 
353
            <string>3</string>
 
354
        </property>
 
355
        <property name="required">
 
356
            <string>0</string>
 
357
        </property>
 
358
        <property name="calculated">
 
359
            <string>false</string>
 
360
        </property>
 
361
        <property name="virtual">
 
362
            <string>false</string>
 
363
        </property>
 
364
        <property name="equation">
 
365
            <string></string>
 
366
        </property>
 
367
        <property name="label">
 
368
            <string>LocalName</string>
 
369
        </property>
 
370
        <property name="number">
 
371
            <string>-1</string>
 
372
        </property>
 
373
        <property name="width">
 
374
            <string>-1</string>
 
375
        </property>
 
376
        <property name="foreign">
 
377
            <string>false</string>
 
378
        </property>
 
379
        <property name="primary">
 
380
            <string>false</string>
 
381
        </property>
 
382
        <property name="hidden">
 
383
            <string>true</string>
 
384
        </property>
 
385
        <property name="resizable">
 
386
            <string>true</string>
 
387
        </property>
 
388
        <property name="sortable">
 
389
            <string>true</string>
 
390
        </property>
 
391
    </datafield>
 
392
    <datafield>
 
393
        <property name="name">
 
394
            <string>GovernmentForm</string>
 
395
        </property>
 
396
        <property name="type">
 
397
            <string>3</string>
 
398
        </property>
 
399
        <property name="required">
 
400
            <string>0</string>
 
401
        </property>
 
402
        <property name="calculated">
 
403
            <string>false</string>
 
404
        </property>
 
405
        <property name="virtual">
 
406
            <string>false</string>
 
407
        </property>
 
408
        <property name="equation">
 
409
            <string></string>
 
410
        </property>
 
411
        <property name="label">
 
412
            <string>GovernmentForm</string>
 
413
        </property>
 
414
        <property name="number">
 
415
            <string>-1</string>
 
416
        </property>
 
417
        <property name="width">
 
418
            <string>-1</string>
 
419
        </property>
 
420
        <property name="foreign">
 
421
            <string>false</string>
 
422
        </property>
 
423
        <property name="primary">
 
424
            <string>false</string>
 
425
        </property>
 
426
        <property name="hidden">
 
427
            <string>true</string>
 
428
        </property>
 
429
        <property name="resizable">
 
430
            <string>true</string>
 
431
        </property>
 
432
        <property name="sortable">
 
433
            <string>true</string>
 
434
        </property>
 
435
    </datafield>
 
436
    <datafield>
 
437
        <property name="name">
 
438
            <string>HeadOfState</string>
 
439
        </property>
 
440
        <property name="type">
 
441
            <string>3</string>
 
442
        </property>
 
443
        <property name="required">
 
444
            <string>0</string>
 
445
        </property>
 
446
        <property name="calculated">
 
447
            <string>false</string>
 
448
        </property>
 
449
        <property name="virtual">
 
450
            <string>false</string>
 
451
        </property>
 
452
        <property name="equation">
 
453
            <string></string>
 
454
        </property>
 
455
        <property name="label">
 
456
            <string>HeadOfState</string>
 
457
        </property>
 
458
        <property name="number">
 
459
            <string>-1</string>
 
460
        </property>
 
461
        <property name="width">
 
462
            <string>-1</string>
 
463
        </property>
 
464
        <property name="foreign">
 
465
            <string>false</string>
 
466
        </property>
 
467
        <property name="primary">
 
468
            <string>false</string>
 
469
        </property>
 
470
        <property name="hidden">
 
471
            <string>true</string>
 
472
        </property>
 
473
        <property name="resizable">
 
474
            <string>true</string>
 
475
        </property>
 
476
        <property name="sortable">
 
477
            <string>true</string>
 
478
        </property>
 
479
    </datafield>
 
480
    <datafield>
 
481
        <property name="name">
 
482
            <string>Code2</string>
 
483
        </property>
 
484
        <property name="type">
 
485
            <string>3</string>
 
486
        </property>
 
487
        <property name="required">
 
488
            <string>0</string>
 
489
        </property>
 
490
        <property name="calculated">
 
491
            <string>false</string>
 
492
        </property>
 
493
        <property name="virtual">
 
494
            <string>false</string>
 
495
        </property>
 
496
        <property name="equation">
 
497
            <string></string>
 
498
        </property>
 
499
        <property name="label">
 
500
            <string>Code2</string>
 
501
        </property>
 
502
        <property name="number">
 
503
            <string>-1</string>
 
504
        </property>
 
505
        <property name="width">
 
506
            <string>-1</string>
 
507
        </property>
 
508
        <property name="foreign">
 
509
            <string>false</string>
 
510
        </property>
 
511
        <property name="primary">
 
512
            <string>false</string>
 
513
        </property>
 
514
        <property name="hidden">
 
515
            <string>true</string>
 
516
        </property>
 
517
        <property name="resizable">
 
518
            <string>true</string>
 
519
        </property>
 
520
        <property name="sortable">
 
521
            <string>true</string>
 
522
        </property>
 
523
    </datafield>
 
524
    <datafield>
 
525
        <property name="name">
 
526
            <string>Name</string>
 
527
        </property>
 
528
        <property name="type">
 
529
            <string>3</string>
 
530
        </property>
 
531
        <property name="required">
 
532
            <string>0</string>
 
533
        </property>
 
534
        <property name="calculated">
 
535
            <string>false</string>
 
536
        </property>
 
537
        <property name="virtual">
 
538
            <string>false</string>
 
539
        </property>
 
540
        <property name="equation">
 
541
            <string></string>
 
542
        </property>
 
543
        <property name="label">
 
544
            <string>Name</string>
 
545
        </property>
 
546
        <property name="number">
 
547
            <string>0</string>
 
548
        </property>
 
549
        <property name="width">
 
550
            <string>100</string>
 
551
        </property>
 
552
        <property name="foreign">
 
553
            <string>false</string>
 
554
        </property>
 
555
        <property name="primary">
 
556
            <string>false</string>
 
557
        </property>
 
558
        <property name="hidden">
 
559
            <string>false</string>
 
560
        </property>
 
561
        <property name="resizable">
 
562
            <string>true</string>
 
563
        </property>
 
564
        <property name="sortable">
 
565
            <string>true</string>
 
566
        </property>
 
567
    </datafield>
 
568
    <datafield>
 
569
        <property name="name">
 
570
            <string>Continent</string>
 
571
        </property>
 
572
        <property name="type">
 
573
            <string>3</string>
 
574
        </property>
 
575
        <property name="required">
 
576
            <string>0</string>
 
577
        </property>
 
578
        <property name="calculated">
 
579
            <string>false</string>
 
580
        </property>
 
581
        <property name="virtual">
 
582
            <string>false</string>
 
583
        </property>
 
584
        <property name="equation">
 
585
            <string></string>
 
586
        </property>
 
587
        <property name="label">
 
588
            <string>Continent</string>
 
589
        </property>
 
590
        <property name="number">
 
591
            <string>1</string>
 
592
        </property>
 
593
        <property name="width">
 
594
            <string>100</string>
 
595
        </property>
 
596
        <property name="foreign">
 
597
            <string>false</string>
 
598
        </property>
 
599
        <property name="primary">
 
600
            <string>false</string>
 
601
        </property>
 
602
        <property name="hidden">
 
603
            <string>false</string>
 
604
        </property>
 
605
        <property name="resizable">
 
606
            <string>true</string>
 
607
        </property>
 
608
        <property name="sortable">
 
609
            <string>true</string>
 
610
        </property>
 
611
    </datafield>
 
612
    <datafield>
 
613
        <property name="name">
 
614
            <string>Capital</string>
 
615
        </property>
 
616
        <property name="type">
 
617
            <string>16</string>
 
618
        </property>
 
619
        <property name="required">
 
620
            <string>0</string>
 
621
        </property>
 
622
        <property name="calculated">
 
623
            <string>false</string>
 
624
        </property>
 
625
        <property name="virtual">
 
626
            <string>false</string>
 
627
        </property>
 
628
        <property name="equation">
 
629
            <string></string>
 
630
        </property>
 
631
        <property name="label">
 
632
            <string>Capital</string>
 
633
        </property>
 
634
        <property name="number">
 
635
            <string>2</string>
 
636
        </property>
 
637
        <property name="width">
 
638
            <string>100</string>
 
639
        </property>
 
640
        <property name="foreign">
 
641
            <string>true</string>
 
642
        </property>
 
643
        <property name="primary">
 
644
            <string>false</string>
 
645
        </property>
 
646
        <property name="hidden">
 
647
            <string>false</string>
 
648
        </property>
 
649
        <property name="resizable">
 
650
            <string>true</string>
 
651
        </property>
 
652
        <property name="sortable">
 
653
            <string>true</string>
 
654
        </property>
 
655
        <datarelation>
 
656
            <property name="table">
 
657
                <string>City</string>
 
658
            </property>
 
659
            <property name="key">
 
660
                <string>ID</string>
 
661
            </property>
 
662
            <property name="field">
 
663
                <string>Name</string>
 
664
            </property>
 
665
            <property name="type">
 
666
                <string>3</string>
 
667
            </property>
 
668
            <property name="number">
 
669
                <string>0</string>
 
670
            </property>
 
671
            <property name="editorwidth">
 
672
                <string>177</string>
 
673
            </property>
 
674
            <datafield>
 
675
                <property name="name">
 
676
                    <string>Name</string>
 
677
                </property>
 
678
                <property name="type">
 
679
                    <string>3</string>
 
680
                </property>
 
681
                <property name="number">
 
682
                    <string>0</string>
 
683
                </property>
 
684
                <property name="editorwidth">
 
685
                    <string>177</string>
 
686
                </property>
 
687
                <property name="foreign">
 
688
                    <string>false</string>
 
689
                </property>
 
690
                <property name="primary">
 
691
                    <string>true</string>
 
692
                </property>
 
693
                <property name="reporter">
 
694
                    <string>false</string>
 
695
                </property>
 
696
                <property name="hidden">
 
697
                    <string>false</string>
 
698
                </property>
 
699
            </datafield>
 
700
            <datafield>
 
701
                <property name="name">
 
702
                    <string>CountryCode</string>
 
703
                </property>
 
704
                <property name="type">
 
705
                    <string>3</string>
 
706
                </property>
 
707
                <property name="number">
 
708
                    <string>1</string>
 
709
                </property>
 
710
                <property name="editorwidth">
 
711
                    <string>100</string>
 
712
                </property>
 
713
                <property name="foreign">
 
714
                    <string>true</string>
 
715
                </property>
 
716
                <property name="primary">
 
717
                    <string>false</string>
 
718
                </property>
 
719
                <property name="reporter">
 
720
                    <string>false</string>
 
721
                </property>
 
722
                <property name="hidden">
 
723
                    <string>false</string>
 
724
                </property>
 
725
                <datarelation>
 
726
                    <property name="table">
 
727
                        <string>Country</string>
 
728
                    </property>
 
729
                    <property name="key">
 
730
                        <string>Code</string>
 
731
                    </property>
 
732
                    <property name="field">
 
733
                        <string>Continent</string>
 
734
                    </property>
 
735
                    <property name="constraint">
 
736
                        <string>Code</string>
 
737
                    </property>
 
738
                    <property name="type">
 
739
                        <string>3</string>
 
740
                    </property>
 
741
                    <property name="number">
 
742
                        <string>0</string>
 
743
                    </property>
 
744
                    <property name="editorwidth">
 
745
                        <string>0</string>
 
746
                    </property>
 
747
                    <datafield>
 
748
                        <property name="name">
 
749
                            <string>Continent</string>
 
750
                        </property>
 
751
                        <property name="type">
 
752
                            <string>3</string>
 
753
                        </property>
 
754
                        <property name="number">
 
755
                            <string>0</string>
 
756
                        </property>
 
757
                        <property name="editorwidth">
 
758
                            <string>0</string>
 
759
                        </property>
 
760
                        <property name="foreign">
 
761
                            <string>false</string>
 
762
                        </property>
 
763
                        <property name="primary">
 
764
                            <string>true</string>
 
765
                        </property>
 
766
                        <property name="reporter">
 
767
                            <string>false</string>
 
768
                        </property>
 
769
                        <property name="hidden">
 
770
                            <string>false</string>
 
771
                        </property>
 
772
                    </datafield>
 
773
                </datarelation>
 
774
            </datafield>
 
775
            <datafield>
 
776
                <property name="name">
 
777
                    <string>District</string>
 
778
                </property>
 
779
                <property name="type">
 
780
                    <string>3</string>
 
781
                </property>
 
782
                <property name="number">
 
783
                    <string>2</string>
 
784
                </property>
 
785
                <property name="editorwidth">
 
786
                    <string>136</string>
 
787
                </property>
 
788
                <property name="foreign">
 
789
                    <string>false</string>
 
790
                </property>
 
791
                <property name="primary">
 
792
                    <string>false</string>
 
793
                </property>
 
794
                <property name="reporter">
 
795
                    <string>false</string>
 
796
                </property>
 
797
                <property name="hidden">
 
798
                    <string>false</string>
 
799
                </property>
 
800
            </datafield>
 
801
        </datarelation>
 
802
    </datafield>
 
803
    <datafield>
 
804
        <property name="name">
 
805
            <string>GNP</string>
 
806
        </property>
 
807
        <property name="type">
 
808
            <string>19</string>
 
809
        </property>
 
810
        <property name="required">
 
811
            <string>0</string>
 
812
        </property>
 
813
        <property name="calculated">
 
814
            <string>false</string>
 
815
        </property>
 
816
        <property name="virtual">
 
817
            <string>false</string>
 
818
        </property>
 
819
        <property name="equation">
 
820
            <string></string>
 
821
        </property>
 
822
        <property name="label">
 
823
            <string>GNP</string>
 
824
        </property>
 
825
        <property name="number">
 
826
            <string>3</string>
 
827
        </property>
 
828
        <property name="width">
 
829
            <string>100</string>
 
830
        </property>
 
831
        <property name="foreign">
 
832
            <string>false</string>
 
833
        </property>
 
834
        <property name="primary">
 
835
            <string>false</string>
 
836
        </property>
 
837
        <property name="hidden">
 
838
            <string>false</string>
 
839
        </property>
 
840
        <property name="resizable">
 
841
            <string>true</string>
 
842
        </property>
 
843
        <property name="sortable">
 
844
            <string>true</string>
 
845
        </property>
 
846
    </datafield>
 
847
    <datafield>
 
848
        <property name="name">
 
849
            <string>SurfaceArea</string>
 
850
        </property>
 
851
        <property name="type">
 
852
            <string>19</string>
 
853
        </property>
 
854
        <property name="required">
 
855
            <string>0</string>
 
856
        </property>
 
857
        <property name="calculated">
 
858
            <string>false</string>
 
859
        </property>
 
860
        <property name="virtual">
 
861
            <string>false</string>
 
862
        </property>
 
863
        <property name="equation">
 
864
            <string></string>
 
865
        </property>
 
866
        <property name="label">
 
867
            <string>Surface Area</string>
 
868
        </property>
 
869
        <property name="number">
 
870
            <string>4</string>
 
871
        </property>
 
872
        <property name="width">
 
873
            <string>100</string>
 
874
        </property>
 
875
        <property name="foreign">
 
876
            <string>false</string>
 
877
        </property>
 
878
        <property name="primary">
 
879
            <string>false</string>
 
880
        </property>
 
881
        <property name="hidden">
 
882
            <string>false</string>
 
883
        </property>
 
884
        <property name="resizable">
 
885
            <string>true</string>
 
886
        </property>
 
887
        <property name="sortable">
 
888
            <string>true</string>
 
889
        </property>
 
890
    </datafield>
 
891
    <datafield>
 
892
        <property name="name">
 
893
            <string>Region</string>
 
894
        </property>
 
895
        <property name="type">
 
896
            <string>3</string>
 
897
        </property>
 
898
        <property name="required">
 
899
            <string>0</string>
 
900
        </property>
 
901
        <property name="calculated">
 
902
            <string>false</string>
 
903
        </property>
 
904
        <property name="virtual">
 
905
            <string>false</string>
 
906
        </property>
 
907
        <property name="equation">
 
908
            <string></string>
 
909
        </property>
 
910
        <property name="label">
 
911
            <string>Region</string>
 
912
        </property>
 
913
        <property name="number">
 
914
            <string>5</string>
 
915
        </property>
 
916
        <property name="width">
 
917
            <string>162</string>
 
918
        </property>
 
919
        <property name="foreign">
 
920
            <string>false</string>
 
921
        </property>
 
922
        <property name="primary">
 
923
            <string>false</string>
 
924
        </property>
 
925
        <property name="hidden">
 
926
            <string>false</string>
 
927
        </property>
 
928
        <property name="resizable">
 
929
            <string>true</string>
 
930
        </property>
 
931
        <property name="sortable">
 
932
            <string>true</string>
 
933
        </property>
 
934
    </datafield>
 
935
    <datafield>
 
936
        <property name="name">
 
937
            <string>Population</string>
 
938
        </property>
 
939
        <property name="type">
 
940
            <string>16</string>
 
941
        </property>
 
942
        <property name="required">
 
943
            <string>0</string>
 
944
        </property>
 
945
        <property name="calculated">
 
946
            <string>false</string>
 
947
        </property>
 
948
        <property name="virtual">
 
949
            <string>false</string>
 
950
        </property>
 
951
        <property name="equation">
 
952
            <string></string>
 
953
        </property>
 
954
        <property name="label">
 
955
            <string>Population</string>
 
956
        </property>
 
957
        <property name="number">
 
958
            <string>6</string>
 
959
        </property>
 
960
        <property name="width">
 
961
            <string>100</string>
 
962
        </property>
 
963
        <property name="foreign">
 
964
            <string>false</string>
 
965
        </property>
 
966
        <property name="primary">
 
967
            <string>false</string>
 
968
        </property>
 
969
        <property name="hidden">
 
970
            <string>false</string>
 
971
        </property>
 
972
        <property name="resizable">
 
973
            <string>true</string>
 
974
        </property>
 
975
        <property name="sortable">
 
976
            <string>true</string>
 
977
        </property>
 
978
    </datafield>
 
979
    <datafield>
 
980
        <property name="name">
 
981
            <string>IndepYear</string>
 
982
        </property>
 
983
        <property name="type">
 
984
            <string>16</string>
 
985
        </property>
 
986
        <property name="required">
 
987
            <string>0</string>
 
988
        </property>
 
989
        <property name="calculated">
 
990
            <string>false</string>
 
991
        </property>
 
992
        <property name="virtual">
 
993
            <string>false</string>
 
994
        </property>
 
995
        <property name="equation">
 
996
            <string></string>
 
997
        </property>
 
998
        <property name="label">
 
999
            <string>Independence</string>
 
1000
        </property>
 
1001
        <property name="number">
 
1002
            <string>7</string>
 
1003
        </property>
 
1004
        <property name="width">
 
1005
            <string>100</string>
 
1006
        </property>
 
1007
        <property name="foreign">
 
1008
            <string>false</string>
 
1009
        </property>
 
1010
        <property name="primary">
 
1011
            <string>false</string>
 
1012
        </property>
 
1013
        <property name="hidden">
 
1014
            <string>false</string>
 
1015
        </property>
 
1016
        <property name="resizable">
 
1017
            <string>true</string>
 
1018
        </property>
 
1019
        <property name="sortable">
 
1020
            <string>true</string>
 
1021
        </property>
 
1022
    </datafield>
 
1023
</datatable>
 
1024
<datatable>
 
1025
    <property name="connection">
 
1026
        <string>(default)</string>
 
1027
    </property>
 
1028
    <property name="tablename">
 
1029
        <string>CountryLanguage</string>
 
1030
    </property>
 
1031
    <property name="number">
 
1032
        <string>1</string>
 
1033
    </property>
 
1034
    <property name="parentname">
 
1035
        <string>Countries</string>
 
1036
    </property>
 
1037
    <property name="relationtoparent">
 
1038
        <string>2</string>
 
1039
    </property>
 
1040
    <property name="parentkey">
 
1041
        <string>Code</string>
 
1042
    </property>
 
1043
    <property name="foreignkey">
 
1044
        <string>CountryCode</string>
 
1045
    </property>
 
1046
    <property name="name">
 
1047
        <string>Languages</string>
 
1048
    </property>
 
1049
    <property name="icon">
 
1050
        <string>/home/manyoso/dev/kde/trunk/extragear/office/datakiosk/samples/language.png</string>
 
1051
    </property>
 
1052
    <property name="readonly">
 
1053
        <string>false</string>
 
1054
    </property>
 
1055
    <property name="confirminsert">
 
1056
        <string>false</string>
 
1057
    </property>
 
1058
    <property name="confirmupdate">
 
1059
        <string>false</string>
 
1060
    </property>
 
1061
    <property name="confirmdelete">
 
1062
        <string>true</string>
 
1063
    </property>
 
1064
    <property name="confirmcancel">
 
1065
        <string>false</string>
 
1066
    </property>
 
1067
    <property name="sorting">
 
1068
        <string>true</string>
 
1069
    </property>
 
1070
    <datafield>
 
1071
        <property name="name">
 
1072
            <string>CountryCode</string>
 
1073
        </property>
 
1074
        <property name="type">
 
1075
            <string>3</string>
 
1076
        </property>
 
1077
        <property name="required">
 
1078
            <string>0</string>
 
1079
        </property>
 
1080
        <property name="calculated">
 
1081
            <string>false</string>
 
1082
        </property>
 
1083
        <property name="virtual">
 
1084
            <string>false</string>
 
1085
        </property>
 
1086
        <property name="equation">
 
1087
            <string></string>
 
1088
        </property>
 
1089
        <property name="label">
 
1090
            <string>CountryCode</string>
 
1091
        </property>
 
1092
        <property name="number">
 
1093
            <string>-1</string>
 
1094
        </property>
 
1095
        <property name="width">
 
1096
            <string>-1</string>
 
1097
        </property>
 
1098
        <property name="foreign">
 
1099
            <string>false</string>
 
1100
        </property>
 
1101
        <property name="primary">
 
1102
            <string>true</string>
 
1103
        </property>
 
1104
        <property name="hidden">
 
1105
            <string>true</string>
 
1106
        </property>
 
1107
        <property name="resizable">
 
1108
            <string>false</string>
 
1109
        </property>
 
1110
        <property name="sortable">
 
1111
            <string>false</string>
 
1112
        </property>
 
1113
    </datafield>
 
1114
    <datafield>
 
1115
        <property name="name">
 
1116
            <string>Language</string>
 
1117
        </property>
 
1118
        <property name="type">
 
1119
            <string>3</string>
 
1120
        </property>
 
1121
        <property name="required">
 
1122
            <string>0</string>
 
1123
        </property>
 
1124
        <property name="calculated">
 
1125
            <string>false</string>
 
1126
        </property>
 
1127
        <property name="virtual">
 
1128
            <string>false</string>
 
1129
        </property>
 
1130
        <property name="equation">
 
1131
            <string></string>
 
1132
        </property>
 
1133
        <property name="label">
 
1134
            <string>Language</string>
 
1135
        </property>
 
1136
        <property name="number">
 
1137
            <string>0</string>
 
1138
        </property>
 
1139
        <property name="width">
 
1140
            <string>100</string>
 
1141
        </property>
 
1142
        <property name="foreign">
 
1143
            <string>false</string>
 
1144
        </property>
 
1145
        <property name="primary">
 
1146
            <string>true</string>
 
1147
        </property>
 
1148
        <property name="hidden">
 
1149
            <string>false</string>
 
1150
        </property>
 
1151
        <property name="resizable">
 
1152
            <string>false</string>
 
1153
        </property>
 
1154
        <property name="sortable">
 
1155
            <string>false</string>
 
1156
        </property>
 
1157
    </datafield>
 
1158
    <datafield>
 
1159
        <property name="name">
 
1160
            <string>IsOfficial</string>
 
1161
        </property>
 
1162
        <property name="type">
 
1163
            <string>3</string>
 
1164
        </property>
 
1165
        <property name="required">
 
1166
            <string>0</string>
 
1167
        </property>
 
1168
        <property name="calculated">
 
1169
            <string>false</string>
 
1170
        </property>
 
1171
        <property name="virtual">
 
1172
            <string>false</string>
 
1173
        </property>
 
1174
        <property name="equation">
 
1175
            <string></string>
 
1176
        </property>
 
1177
        <property name="label">
 
1178
            <string>Official</string>
 
1179
        </property>
 
1180
        <property name="number">
 
1181
            <string>1</string>
 
1182
        </property>
 
1183
        <property name="width">
 
1184
            <string>100</string>
 
1185
        </property>
 
1186
        <property name="foreign">
 
1187
            <string>false</string>
 
1188
        </property>
 
1189
        <property name="primary">
 
1190
            <string>false</string>
 
1191
        </property>
 
1192
        <property name="hidden">
 
1193
            <string>false</string>
 
1194
        </property>
 
1195
        <property name="resizable">
 
1196
            <string>true</string>
 
1197
        </property>
 
1198
        <property name="sortable">
 
1199
            <string>true</string>
 
1200
        </property>
 
1201
    </datafield>
 
1202
    <datafield>
 
1203
        <property name="name">
 
1204
            <string>Percentage</string>
 
1205
        </property>
 
1206
        <property name="type">
 
1207
            <string>19</string>
 
1208
        </property>
 
1209
        <property name="required">
 
1210
            <string>0</string>
 
1211
        </property>
 
1212
        <property name="calculated">
 
1213
            <string>false</string>
 
1214
        </property>
 
1215
        <property name="virtual">
 
1216
            <string>false</string>
 
1217
        </property>
 
1218
        <property name="equation">
 
1219
            <string></string>
 
1220
        </property>
 
1221
        <property name="label">
 
1222
            <string>Percentage</string>
 
1223
        </property>
 
1224
        <property name="number">
 
1225
            <string>2</string>
 
1226
        </property>
 
1227
        <property name="width">
 
1228
            <string>100</string>
 
1229
        </property>
 
1230
        <property name="foreign">
 
1231
            <string>false</string>
 
1232
        </property>
 
1233
        <property name="primary">
 
1234
            <string>false</string>
 
1235
        </property>
 
1236
        <property name="hidden">
 
1237
            <string>false</string>
 
1238
        </property>
 
1239
        <property name="resizable">
 
1240
            <string>true</string>
 
1241
        </property>
 
1242
        <property name="sortable">
 
1243
            <string>true</string>
 
1244
        </property>
 
1245
    </datafield>
 
1246
    <datafield>
 
1247
        <property name="name">
 
1248
            <string>#Speakers</string>
 
1249
        </property>
 
1250
        <property name="type">
 
1251
            <string>0</string>
 
1252
        </property>
 
1253
        <property name="required">
 
1254
            <string>0</string>
 
1255
        </property>
 
1256
        <property name="calculated">
 
1257
            <string>true</string>
 
1258
        </property>
 
1259
        <property name="virtual">
 
1260
            <string>true</string>
 
1261
        </property>
 
1262
        <property name="equation">
 
1263
            <string>[f:Countries.Population] * [f:Languages.Percentage] / [#:100]</string>
 
1264
        </property>
 
1265
        <property name="label">
 
1266
            <string>#Speakers</string>
 
1267
        </property>
 
1268
        <property name="number">
 
1269
            <string>4</string>
 
1270
        </property>
 
1271
        <property name="width">
 
1272
            <string>-1</string>
 
1273
        </property>
 
1274
        <property name="foreign">
 
1275
            <string>false</string>
 
1276
        </property>
 
1277
        <property name="primary">
 
1278
            <string>false</string>
 
1279
        </property>
 
1280
        <property name="hidden">
 
1281
            <string>false</string>
 
1282
        </property>
 
1283
        <property name="resizable">
 
1284
            <string>false</string>
 
1285
        </property>
 
1286
        <property name="sortable">
 
1287
            <string>false</string>
 
1288
        </property>
 
1289
    </datafield>
 
1290
</datatable>
 
1291
<datatable>
 
1292
    <property name="connection">
 
1293
        <string>(default)</string>
 
1294
    </property>
 
1295
    <property name="tablename">
 
1296
        <string>City</string>
 
1297
    </property>
 
1298
    <property name="number">
 
1299
        <string>0</string>
 
1300
    </property>
 
1301
    <property name="parentname">
 
1302
        <string>Countries</string>
 
1303
    </property>
 
1304
    <property name="relationtoparent">
 
1305
        <string>2</string>
 
1306
    </property>
 
1307
    <property name="parentkey">
 
1308
        <string>Code</string>
 
1309
    </property>
 
1310
    <property name="foreignkey">
 
1311
        <string>CountryCode</string>
 
1312
    </property>
 
1313
    <property name="name">
 
1314
        <string>Cities</string>
 
1315
    </property>
 
1316
    <property name="icon">
 
1317
        <string>/home/manyoso/dev/kde/trunk/extragear/office/datakiosk/samples/city.png</string>
 
1318
    </property>
 
1319
    <property name="readonly">
 
1320
        <string>false</string>
 
1321
    </property>
 
1322
    <property name="confirminsert">
 
1323
        <string>false</string>
 
1324
    </property>
 
1325
    <property name="confirmupdate">
 
1326
        <string>false</string>
 
1327
    </property>
 
1328
    <property name="confirmdelete">
 
1329
        <string>true</string>
 
1330
    </property>
 
1331
    <property name="confirmcancel">
 
1332
        <string>false</string>
 
1333
    </property>
 
1334
    <property name="sorting">
 
1335
        <string>true</string>
 
1336
    </property>
 
1337
    <datafield>
 
1338
        <property name="name">
 
1339
            <string>ID</string>
 
1340
        </property>
 
1341
        <property name="type">
 
1342
            <string>16</string>
 
1343
        </property>
 
1344
        <property name="required">
 
1345
            <string>0</string>
 
1346
        </property>
 
1347
        <property name="calculated">
 
1348
            <string>false</string>
 
1349
        </property>
 
1350
        <property name="virtual">
 
1351
            <string>false</string>
 
1352
        </property>
 
1353
        <property name="equation">
 
1354
            <string></string>
 
1355
        </property>
 
1356
        <property name="label">
 
1357
            <string>ID</string>
 
1358
        </property>
 
1359
        <property name="number">
 
1360
            <string>-1</string>
 
1361
        </property>
 
1362
        <property name="width">
 
1363
            <string>-1</string>
 
1364
        </property>
 
1365
        <property name="foreign">
 
1366
            <string>false</string>
 
1367
        </property>
 
1368
        <property name="primary">
 
1369
            <string>true</string>
 
1370
        </property>
 
1371
        <property name="hidden">
 
1372
            <string>true</string>
 
1373
        </property>
 
1374
        <property name="resizable">
 
1375
            <string>false</string>
 
1376
        </property>
 
1377
        <property name="sortable">
 
1378
            <string>false</string>
 
1379
        </property>
 
1380
    </datafield>
 
1381
    <datafield>
 
1382
        <property name="name">
 
1383
            <string>CountryCode</string>
 
1384
        </property>
 
1385
        <property name="type">
 
1386
            <string>3</string>
 
1387
        </property>
 
1388
        <property name="required">
 
1389
            <string>0</string>
 
1390
        </property>
 
1391
        <property name="calculated">
 
1392
            <string>false</string>
 
1393
        </property>
 
1394
        <property name="virtual">
 
1395
            <string>false</string>
 
1396
        </property>
 
1397
        <property name="equation">
 
1398
            <string></string>
 
1399
        </property>
 
1400
        <property name="label">
 
1401
            <string>CountryCode</string>
 
1402
        </property>
 
1403
        <property name="number">
 
1404
            <string>-1</string>
 
1405
        </property>
 
1406
        <property name="width">
 
1407
            <string>-1</string>
 
1408
        </property>
 
1409
        <property name="foreign">
 
1410
            <string>false</string>
 
1411
        </property>
 
1412
        <property name="primary">
 
1413
            <string>false</string>
 
1414
        </property>
 
1415
        <property name="hidden">
 
1416
            <string>true</string>
 
1417
        </property>
 
1418
        <property name="resizable">
 
1419
            <string>true</string>
 
1420
        </property>
 
1421
        <property name="sortable">
 
1422
            <string>true</string>
 
1423
        </property>
 
1424
    </datafield>
 
1425
    <datafield>
 
1426
        <property name="name">
 
1427
            <string>Name</string>
 
1428
        </property>
 
1429
        <property name="type">
 
1430
            <string>3</string>
 
1431
        </property>
 
1432
        <property name="required">
 
1433
            <string>0</string>
 
1434
        </property>
 
1435
        <property name="calculated">
 
1436
            <string>false</string>
 
1437
        </property>
 
1438
        <property name="virtual">
 
1439
            <string>false</string>
 
1440
        </property>
 
1441
        <property name="equation">
 
1442
            <string></string>
 
1443
        </property>
 
1444
        <property name="label">
 
1445
            <string>Name</string>
 
1446
        </property>
 
1447
        <property name="number">
 
1448
            <string>0</string>
 
1449
        </property>
 
1450
        <property name="width">
 
1451
            <string>100</string>
 
1452
        </property>
 
1453
        <property name="foreign">
 
1454
            <string>false</string>
 
1455
        </property>
 
1456
        <property name="primary">
 
1457
            <string>false</string>
 
1458
        </property>
 
1459
        <property name="hidden">
 
1460
            <string>false</string>
 
1461
        </property>
 
1462
        <property name="resizable">
 
1463
            <string>true</string>
 
1464
        </property>
 
1465
        <property name="sortable">
 
1466
            <string>true</string>
 
1467
        </property>
 
1468
    </datafield>
 
1469
    <datafield>
 
1470
        <property name="name">
 
1471
            <string>District</string>
 
1472
        </property>
 
1473
        <property name="type">
 
1474
            <string>3</string>
 
1475
        </property>
 
1476
        <property name="required">
 
1477
            <string>0</string>
 
1478
        </property>
 
1479
        <property name="calculated">
 
1480
            <string>false</string>
 
1481
        </property>
 
1482
        <property name="virtual">
 
1483
            <string>false</string>
 
1484
        </property>
 
1485
        <property name="equation">
 
1486
            <string></string>
 
1487
        </property>
 
1488
        <property name="label">
 
1489
            <string>District</string>
 
1490
        </property>
 
1491
        <property name="number">
 
1492
            <string>1</string>
 
1493
        </property>
 
1494
        <property name="width">
 
1495
            <string>100</string>
 
1496
        </property>
 
1497
        <property name="foreign">
 
1498
            <string>false</string>
 
1499
        </property>
 
1500
        <property name="primary">
 
1501
            <string>false</string>
 
1502
        </property>
 
1503
        <property name="hidden">
 
1504
            <string>false</string>
 
1505
        </property>
 
1506
        <property name="resizable">
 
1507
            <string>true</string>
 
1508
        </property>
 
1509
        <property name="sortable">
 
1510
            <string>true</string>
 
1511
        </property>
 
1512
    </datafield>
 
1513
    <datafield>
 
1514
        <property name="name">
 
1515
            <string>Population</string>
 
1516
        </property>
 
1517
        <property name="type">
 
1518
            <string>16</string>
 
1519
        </property>
 
1520
        <property name="required">
 
1521
            <string>0</string>
 
1522
        </property>
 
1523
        <property name="calculated">
 
1524
            <string>false</string>
 
1525
        </property>
 
1526
        <property name="virtual">
 
1527
            <string>false</string>
 
1528
        </property>
 
1529
        <property name="equation">
 
1530
            <string></string>
 
1531
        </property>
 
1532
        <property name="label">
 
1533
            <string>Population</string>
 
1534
        </property>
 
1535
        <property name="number">
 
1536
            <string>2</string>
 
1537
        </property>
 
1538
        <property name="width">
 
1539
            <string>100</string>
 
1540
        </property>
 
1541
        <property name="foreign">
 
1542
            <string>false</string>
 
1543
        </property>
 
1544
        <property name="primary">
 
1545
            <string>false</string>
 
1546
        </property>
 
1547
        <property name="hidden">
 
1548
            <string>false</string>
 
1549
        </property>
 
1550
        <property name="resizable">
 
1551
            <string>true</string>
 
1552
        </property>
 
1553
        <property name="sortable">
 
1554
            <string>true</string>
 
1555
        </property>
 
1556
    </datafield>
 
1557
</datatable>
 
1558
<datasearch>
 
1559
    <property name="name">
 
1560
        <string>Large cities in the Mid East</string>
 
1561
    </property>
 
1562
    <property name="searchmode">
 
1563
        <string>1</string>
 
1564
    </property>
 
1565
    <property name="searchlevel">
 
1566
        <string>1</string>
 
1567
    </property>
 
1568
    <property name="parentname">
 
1569
        <string>Countries</string>
 
1570
    </property>
 
1571
    <component>
 
1572
        <property name="query">
 
1573
            <string>Middle East</string>
 
1574
        </property>
 
1575
        <property name="datatable">
 
1576
            <string>Countries</string>
 
1577
        </property>
 
1578
        <property name="datafield">
 
1579
            <string>Region</string>
 
1580
        </property>
 
1581
        <property name="prompt">
 
1582
            <string>false</string>
 
1583
        </property>
 
1584
        <property name="matchmode">
 
1585
            <string>2</string>
 
1586
        </property>
 
1587
    </component>
 
1588
    <component>
 
1589
        <property name="query">
 
1590
            <string>3000000</string>
 
1591
        </property>
 
1592
        <property name="datatable">
 
1593
            <string>Cities</string>
 
1594
        </property>
 
1595
        <property name="datafield">
 
1596
            <string>Population</string>
 
1597
        </property>
 
1598
        <property name="prompt">
 
1599
            <string>false</string>
 
1600
        </property>
 
1601
        <property name="matchmode">
 
1602
            <string>11</string>
 
1603
        </property>
 
1604
    </component>
 
1605
</datasearch>
 
1606
<datareport>
 
1607
    <property name="name">
 
1608
        <string>Cities Report</string>
 
1609
    </property>
 
1610
    <property name="icon">
 
1611
        <string>kugar.png</string>
 
1612
    </property>
 
1613
    <property name="templateurl">
 
1614
        <string>/home/manyoso/dev/kde/trunk/extragear/office/datakiosk/samples/world-mysql.kut</string>
 
1615
    </property>
 
1616
    <property name="parentname">
 
1617
        <string>Countries</string>
 
1618
    </property>
 
1619
    <table>
 
1620
        <property name="name">
 
1621
            <string>Countries</string>
 
1622
        </property>
 
1623
    </table>
 
1624
    <table>
 
1625
        <property name="name">
 
1626
            <string>Cities</string>
 
1627
        </property>
 
1628
    </table>
 
1629
    <sort>
 
1630
        <property name="orderby">
 
1631
            <string>Countries.Name ASC</string>
 
1632
        </property>
 
1633
    </sort>
 
1634
    <sort>
 
1635
        <property name="orderby">
 
1636
            <string>Cities.Population DESC</string>
 
1637
        </property>
 
1638
    </sort>
 
1639
</datareport>
 
1640
</DataKiosk>