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
|
<?xml version="1.0"?>
<serv_op>
<parameters id="INDEX_DEF_P" _name="Index description">
<parameter id="INDEX_TYPE" _name="Type" gdatype="gchararray" source="types:0">
<gda_value>UNIQUE</gda_value>
</parameter>
<parameter id="INDEX_NAME" _name="Name" _descr="Index name" gdatype="gchararray" nullok="FALSE"/>
<parameter id="INDEX_ON_TABLE" _name="On table" gdatype="gchararray" nullok="FALSE" source="_DICT_TABLES_"/>
<parameter id="INDEX_IFNOTEXISTS" _name="Only if it does not yet exist" _descr="Create index only if it does not yet exist" gdatype="gboolean">
<gda_value>FALSE</gda_value>
</parameter>
</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>
<!-- To translators: "Compare method" refers to the method SQLite has to compare values -->
<parameter id="INDEX_COLLATE" _name="Compare method" _descr="Collation name (BINARY|NOCASE)" gdatype="gchararray"/>
<parameter id="INDEX_SORT_ORDER" _name="Sort type" gdatype="gchararray" source="sort:0"/>
</sequence>
<!-- Sources -->
<sources>
<gda_array name="sort">
<gda_array_field name="id" gdatype="gchararray"/>
<gda_array_field name="text" gdatype="gchararray"/>
<gda_array_data>
<gda_array_row>
<gda_value>ASC</gda_value>
<gda_value>Ascending</gda_value>
</gda_array_row>
<gda_array_row>
<gda_value>DESC</gda_value>
<gda_value>Descending</gda_value>
</gda_array_row>
</gda_array_data>
</gda_array>
<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>Unique</gda_value>
</gda_array_row>
</gda_array_data>
</gda_array>
</sources>
</serv_op>
|
