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
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
|
<?xml version="1.0"?>
<serv_op>
<parameters id="TABLE_DEF_P" _name="Table's description">
<parameter id="TABLE_NAME" _name="Name" _descr="Table's name" gdatype="gchararray" nullok="FALSE">
<gda_value>table_name</gda_value>
</parameter>
<parameter id="TABLE_TABLESPACE" _name="Tablespace" gdatype="gchararray"/>
<parameter id="TABLE_WITH_OIDS" _name="With OIDs" gdatype="gboolean">
<gda_value>TRUE</gda_value>
</parameter>
<parameter id="TABLE_TEMP" _name="Temporary table" gdatype="gboolean">
<gda_value>FALSE</gda_value>
</parameter>
<parameter id="TABLE_COMMENT" _name="Temporary table" gdatype="gchararray"/>
</parameters>
<sequence id="TABLE_PARENTS_S" _name="Parent table(s)" _descr="Inheritance" status="OPT">
<parameter id="TABLE_PARENT_TABLE" _name="Parent table" gdatype="gchararray">
<gda_value>parent_table</gda_value>
</parameter>
<parameter id="TABLE_PARENT_COPY" _name="Keep coupled" _descr="Use INHERIT instead of LIKE" gdatype="gboolean">
<gda_value>FALSE</gda_value>
</parameter>
<parameter id="TABLE_PARENT_COPY_DEFAULTS" _name="Copy defaults" _descr="Copy default expressions" gdatype="gboolean">
<gda_value>FALSE</gda_value>
</parameter>
</sequence>
<!-- list of fields -->
<gda_array id="FIELDS_A" _name="Table's columns">
<gda_array_field id="COLUMN_NAME" _name="Field name" gdatype="gchararray" nullok="FALSE"/>
<gda_array_field id="COLUMN_TYPE" _name="Data type" gdatype="gchararray" hint="datatype" nullok="FALSE"/>
<gda_array_field id="COLUMN_SIZE" _name="Size" gdatype="guint"/>
<gda_array_field id="COLUMN_SCALE" _name="Scale" gdatype="guint"/>
<gda_array_field id="COLUMN_NNUL" _name="Not NULL" gdatype="gboolean"/>
<gda_array_field id="COLUMN_AUTOINC" _name="Auto increment" gdatype="gboolean"/>
<gda_array_field id="COLUMN_UNIQUE" _name="Unique" gdatype="gboolean"/>
<gda_array_field id="COLUMN_PKEY" _name="Primary key" gdatype="gboolean"/>
<gda_array_field id="COLUMN_DEFAULT" _name="Default" _descr="Default value" gdatype="gchararray"/>
<gda_array_field id="COLUMN_CHECK" _name="Check" _descr="Check constraint" gdatype="gchararray"/>
</gda_array>
<!-- foreign key spec -->
<sequence id="FKEY_S" _name="Foreign key">
<parameter id="FKEY_REF_TABLE" _name="Referenced table" gdatype="gchararray" nullok="FALSE" source="_DICT_TABLES_">
<gda_value>ref_table</gda_value>
</parameter>
<gda_array id="FKEY_FIELDS_A" _name="Fields" _descr="Fields in the foreign key">
<gda_array_field id="FK_FIELD" _name="Field" gdatype="gchararray" nullok="FALSE"/>
<gda_array_field id="FK_REF_PK_FIELD" _name="Referenced field" gdatype="gchararray" nullok="FALSE" source="_FKEY_REF_TABLE/DICT_FIELDS_"/>
<gda_array_data>
<gda_array_row>
<gda_value>id_ref</gda_value>
<gda_value>id</gda_value>
</gda_array_row>
</gda_array_data>
</gda_array>
<parameter id="FKEY_MATCH_TYPE" _name="Match type" _descr="Matching method if more than one field involved" gdatype="gchararray" source="match_types:0">
<gda_value>MATCH SIMPLE</gda_value>
</parameter>
<parameter id="FKEY_ONUPDATE" _name="On update action" gdatype="gchararray" source="action_cb:0">
<gda_value>NO ACTION</gda_value>
</parameter>
<parameter id="FKEY_ONDELETE" _name="On delete action" gdatype="gchararray" source="action_cb:0">
<gda_value>NO ACTION</gda_value>
</parameter>
<parameter id="FKEY_DEFERRABLE" _name="Deferrable" gdatype="gchararray" source="defer_state:0">
<gda_value>NOT DEFERRABLE</gda_value>
</parameter>
</sequence>
<!-- other table constraints -->
<sequence id="TABLE_CONSTRAINTS_S" _name="Global constraints">
<parameter id="CONSTRAINT_STRING" name="Constraint" gdatype="gchararray">
<gda_value>CHECK (column > 0)</gda_value>
</parameter>
</sequence>
<!-- Sources -->
<sources>
<gda_array name="match_types">
<gda_array_field name="id" gdatype="gchararray"/>
<gda_array_field name="text" gdatype="gchararray"/>
<gda_array_data>
<gda_array_row>
<gda_value>MATCH SIMPLE</gda_value>
<_gda_value>Match simple</_gda_value>
</gda_array_row>
<gda_array_row>
<gda_value>MATCH FULL</gda_value>
<_gda_value>Match full</_gda_value>
</gda_array_row>
</gda_array_data>
</gda_array>
<gda_array name="action_cb">
<gda_array_field name="id" gdatype="gchararray"/>
<gda_array_field name="text" gdatype="gchararray"/>
<gda_array_data>
<gda_array_row>
<gda_value>NO ACTION</gda_value>
<_gda_value>No action</_gda_value>
</gda_array_row>
<gda_array_row>
<gda_value>RESTRICT</gda_value>
<_gda_value>Restrict</_gda_value>
</gda_array_row>
<gda_array_row>
<gda_value>CASCADE</gda_value>
<_gda_value>Cascade</_gda_value>
</gda_array_row>
<gda_array_row>
<gda_value>SET NULL</gda_value>
<!-- To translators: Action of setting a value to NULL -->
<_gda_value>Set to NULL</_gda_value>
</gda_array_row>
<gda_array_row>
<gda_value>SET DEFAULT</gda_value>
<!-- To translators: Action of setting a value to its default value -->
<_gda_value>Set to default</_gda_value>
</gda_array_row>
</gda_array_data>
</gda_array>
<gda_array name="defer_state">
<gda_array_field name="id" gdatype="gchararray"/>
<gda_array_field name="text" gdatype="gchararray"/>
<gda_array_data>
<gda_array_row>
<gda_value>NOT DEFERRABLE</gda_value>
<_gda_value>Not deferrable</_gda_value>
</gda_array_row>
<gda_array_row>
<gda_value>DEFERRABLE INITIALLY IMMEDIATE</gda_value>
<_gda_value>Deferrable initially immediate</_gda_value>
</gda_array_row>
<gda_array_row>
<gda_value>DEFERRABLE INITIALLY DEFERRED</gda_value>
<_gda_value>Deferrable initially deferred</_gda_value>
</gda_array_row>
</gda_array_data>
</gda_array>
</sources>
</serv_op>
|
