1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
|
<?xml version="1.0"?>
<serv_op>
<parameters id="INDEX_DEF_P" _name="Index description">
<parameter id="INDEX_NAME" _name="Name" _descr="Index name" gdatype="gchararray" nullok="FALSE"/>
<parameter id="INDEX_TYPE" _name="Unique" gdatype="gchararray" source="types:0">
<gda_value>UNIQUE</gda_value>
</parameter>
<parameter id="INDEX_ON_TABLE" _name="On table" gdatype="gchararray" nullok="FALSE" source="_DICT_TABLES_"/>
<parameter id="INDEX_METHOD" _name="Method" gdatype="gchararray" source="method:0"/>
<parameter id="INDEX_TABLESPACE" _name="Tablespace" gdatype="gchararray"/>
<parameter id="INDEX_PREDICATE" _name="Predicate" _descr="Constraint expression for a partial index" gdatype="gchararray"/>
</parameters>
<!-- Index fields -->
<sequence id="INDEX_FIELDS_S" _name="Indexed field(s)" minitems="1" maxitems="3">
<parameter id="INDEX_FIELD" _name="Indexed field or expression" gdatype="gchararray" nullok="FALSE" source="_INDEX_ON_TABLE/DICT_FIELDS_">
<gda_value>indexed_field</gda_value>
</parameter>
</sequence>
<!-- Sources -->
<sources>
<gda_array name="types">
<gda_array_field name="id" gdatype="gchararray"/>
<gda_array_field name="text" gdatype="gchararray"/>
<gda_array_data>
<gda_array_row>
<gda_value>UNIQUE</gda_value>
<gda_value>Enforce unicity of indexed data</gda_value>
</gda_array_row>
<gda_array_row>
<gda_value></gda_value>
<gda_value>Allow non unicity of indexed data</gda_value>
</gda_array_row>
</gda_array_data>
</gda_array>
<gda_array name="method">
<gda_array_field name="id" gdatype="gchararray"/>
<gda_array_field name="text" gdatype="gchararray"/>
<gda_array_data>
<gda_array_row>
<gda_value>btree</gda_value>
<gda_value>Btree</gda_value>
</gda_array_row>
<gda_array_row>
<gda_value>hash</gda_value>
<gda_value>Hash</gda_value>
</gda_array_row>
<gda_array_row>
<gda_value>rtree</gda_value>
<gda_value>Rtree</gda_value>
</gda_array_row>
<gda_array_row>
<gda_value>gist</gda_value>
<gda_value>Gist</gda_value>
</gda_array_row>
</gda_array_data>
</gda_array>
</sources>
</serv_op>
|
