1 |
|
<?xml version="1.0"?>
|
2 |
|
<data grt_format="2.0" document_type="MySQL Workbench Model" version="1.4.4">
|
3 |
|
<value type="object" struct-name="workbench.Document" id="DD51DD12-152C-46FD-90D9-84EB5F9F500F" struct-checksum="0x7131bf99">
|
4 |
|
<value type="object" struct-name="workbench.logical.Model" id="9FB30CD5-3D20-4492-935C-7986A48D7820" struct-checksum="0xf4220370" key="logicalModel">
|
5 |
|
<value _ptr_="0xa9f7338" type="list" content-type="object" content-struct-name="workbench.logical.Diagram" key="diagrams"/>
|
6 |
|
<value _ptr_="0xa9efa18" type="dict" key="customData"/>
|
7 |
|
<value _ptr_="0xa9f7618" type="list" content-type="object" content-struct-name="model.Marker" key="markers"/>
|
8 |
|
<value _ptr_="0xa9f3c88" type="dict" key="options"/>
|
9 |
|
<value type="string" key="name"></value>
|
10 |
|
<link type="object" struct-name="GrtObject" key="owner">DD51DD12-152C-46FD-90D9-84EB5F9F500F</link>
|
11 |
|
</value>
|
12 |
|
<value _ptr_="0x9f9ed88" type="list" content-type="object" content-struct-name="workbench.OverviewPanel" key="overviewPanels"/>
|
13 |
|
<value _ptr_="0xa9f72b0" type="list" content-type="object" content-struct-name="workbench.physical.Model" key="physicalModels">
|
14 |
|
<value type="object" struct-name="workbench.physical.Model" id="257B05AA-CE39-49DE-9522-6B703F985F32" struct-checksum="0x5f896d18">
|
15 |
|
<value type="object" struct-name="db.mysql.Catalog" id="42266085-54CC-4441-8553-68BBE0286A05" struct-checksum="0x82ad3466" key="catalog">
|
16 |
|
<value _ptr_="0xa9f8440" type="list" content-type="object" content-struct-name="db.mysql.LogFileGroup" key="logFileGroups"/>
|
17 |
|
<value _ptr_="0xa9f84b8" type="list" content-type="object" content-struct-name="db.mysql.Schema" key="schemata">
|
18 |
|
<value type="object" struct-name="db.mysql.Schema" id="be8cb246-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x20b94c22">
|
19 |
|
<value _ptr_="0xa9f86d8" type="list" content-type="object" content-struct-name="db.mysql.RoutineGroup" key="routineGroups"/>
|
20 |
|
<value _ptr_="0xa9f8ac0" type="list" content-type="object" content-struct-name="db.mysql.Routine" key="routines"/>
|
21 |
|
<value _ptr_="0xa9f8af0" type="list" content-type="object" content-struct-name="db.mysql.Sequence" key="sequences"/>
|
22 |
|
<value _ptr_="0xa9f8b48" type="list" content-type="object" content-struct-name="db.mysql.StructuredDatatype" key="structuredTypes"/>
|
23 |
|
<value _ptr_="0xa9f8b78" type="list" content-type="object" content-struct-name="db.mysql.Synonym" key="synonyms"/>
|
24 |
|
<value _ptr_="0xa9f8ba8" type="list" content-type="object" content-struct-name="db.mysql.Table" key="tables">
|
25 |
|
<value type="object" struct-name="db.mysql.Table" id="be8fe70e-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x1a403946">
|
26 |
|
<value type="string" key="avgRowLength"></value>
|
27 |
|
<value type="int" key="checksum">0</value>
|
28 |
|
<value _ptr_="0xa9f8d20" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
|
29 |
|
<value type="object" struct-name="db.mysql.Column" id="be8fe97a-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183">
|
30 |
|
<value type="int" key="autoIncrement">0</value>
|
31 |
|
<value type="string" key="characterSetName"></value>
|
32 |
|
<value _ptr_="0xa9f94b8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
33 |
|
<value type="string" key="collationName"></value>
|
34 |
|
<value type="string" key="datatypeExplicitParams"></value>
|
35 |
|
<value type="string" key="defaultValue"></value>
|
36 |
|
<value type="int" key="defaultValueIsNull">0</value>
|
37 |
|
<value _ptr_="0xa9f97e0" type="list" content-type="string" key="flags"/>
|
38 |
|
<value type="int" key="isNotNull">1</value>
|
39 |
|
<value type="int" key="length">767</value>
|
40 |
|
<value type="int" key="precision">-1</value>
|
41 |
|
<value type="int" key="scale">-1</value>
|
42 |
|
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
|
43 |
|
<value type="string" key="comment"></value>
|
44 |
|
<value type="string" key="name">id</value>
|
45 |
|
<value type="string" key="oldName">id</value>
|
46 |
|
<link type="object" struct-name="GrtObject" key="owner">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
|
47 |
|
</value>
|
48 |
|
<value type="object" struct-name="db.mysql.Column" id="8222d06e-1e00-11e3-9d67-080027bcf912" struct-checksum="0x783b5183">
|
49 |
|
<value type="int" key="autoIncrement">0</value>
|
50 |
|
<value type="string" key="characterSetName"></value>
|
51 |
|
<value _ptr_="0xa9f9930" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
52 |
|
<value type="string" key="collationName"></value>
|
53 |
|
<value type="string" key="datatypeExplicitParams"></value>
|
54 |
|
<value type="string" key="defaultValue"></value>
|
55 |
|
<value type="int" key="defaultValueIsNull">0</value>
|
56 |
|
<value _ptr_="0xa9f9c58" type="list" content-type="string" key="flags"/>
|
57 |
|
<value type="int" key="isNotNull">1</value>
|
58 |
|
<value type="int" key="length">767</value>
|
59 |
|
<value type="int" key="precision">-1</value>
|
60 |
|
<value type="int" key="scale">-1</value>
|
61 |
|
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
|
62 |
|
<value type="string" key="comment"></value>
|
63 |
|
<value type="string" key="name">name</value>
|
64 |
|
<value type="string" key="oldName">name</value>
|
65 |
|
<link type="object" struct-name="GrtObject" key="owner">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
|
66 |
|
</value>
|
67 |
|
<value type="object" struct-name="db.mysql.Column" id="e5502346-f676-11e2-9716-080027bcf912" struct-checksum="0x783b5183">
|
68 |
|
<value type="int" key="autoIncrement">0</value>
|
69 |
|
<value type="string" key="characterSetName"></value>
|
70 |
|
<value _ptr_="0xa9f9da8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
71 |
|
<value type="string" key="collationName"></value>
|
72 |
|
<value type="string" key="datatypeExplicitParams"></value>
|
73 |
|
<value type="string" key="defaultValue"></value>
|
74 |
|
<value type="int" key="defaultValueIsNull">1</value>
|
75 |
|
<value _ptr_="0xa9fa0d0" type="list" content-type="string" key="flags"/>
|
76 |
|
<value type="int" key="isNotNull">0</value>
|
77 |
|
<value type="int" key="length">767</value>
|
78 |
|
<value type="int" key="precision">-1</value>
|
79 |
|
<value type="int" key="scale">-1</value>
|
80 |
|
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
|
81 |
|
<value type="string" key="comment"></value>
|
82 |
|
<value type="string" key="name">organization</value>
|
83 |
|
<value type="string" key="oldName">organization</value>
|
84 |
|
<link type="object" struct-name="GrtObject" key="owner">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
|
85 |
|
</value>
|
86 |
|
<value type="object" struct-name="db.mysql.Column" id="c8868c00-a793-11e2-84c3-080027bcf912" struct-checksum="0x783b5183">
|
87 |
|
<value type="int" key="autoIncrement">0</value>
|
88 |
|
<value type="string" key="characterSetName"></value>
|
89 |
|
<value _ptr_="0xa9fa220" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
90 |
|
<value type="string" key="collationName"></value>
|
91 |
|
<value type="string" key="datatypeExplicitParams">('hstore')</value>
|
92 |
|
<value type="string" key="defaultValue"></value>
|
93 |
|
<value type="int" key="defaultValueIsNull">0</value>
|
94 |
|
<value _ptr_="0xa9fa548" type="list" content-type="string" key="flags"/>
|
95 |
|
<value type="int" key="isNotNull">0</value>
|
96 |
|
<value type="int" key="length">-1</value>
|
97 |
|
<value type="int" key="precision">-1</value>
|
98 |
|
<value type="int" key="scale">-1</value>
|
99 |
|
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.set</link>
|
100 |
|
<value type="string" key="comment"></value>
|
101 |
|
<value type="string" key="name">info</value>
|
102 |
|
<value type="string" key="oldName">info</value>
|
103 |
|
<link type="object" struct-name="GrtObject" key="owner">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
|
104 |
|
</value>
|
105 |
|
</value>
|
106 |
|
<value type="string" key="connectionString"></value>
|
107 |
|
<value type="string" key="defaultCharacterSetName">utf8</value>
|
108 |
|
<value type="string" key="defaultCollationName">utf8_bin</value>
|
109 |
|
<value type="int" key="delayKeyWrite">0</value>
|
110 |
|
<value _ptr_="0xa9f9258" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
|
111 |
|
<value type="object" struct-name="db.mysql.ForeignKey" id="e550209e-f676-11e2-9716-080027bcf912" struct-checksum="0x70a8fc40">
|
112 |
|
<link type="object" struct-name="db.mysql.Table" key="referencedTable">049df920-a91b-11e2-bdec-080027bcf912</link>
|
113 |
|
<value _ptr_="0xa9fa6c0" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
114 |
|
<link type="object">e5502346-f676-11e2-9716-080027bcf912</link>
|
115 |
|
</value>
|
116 |
|
<value type="int" key="deferability">0</value>
|
117 |
|
<value type="string" key="deleteRule">CASCADE</value>
|
118 |
|
<link type="object" struct-name="db.Index" key="index">e550389a-f676-11e2-9716-080027bcf912</link>
|
119 |
|
<value type="int" key="mandatory">1</value>
|
120 |
|
<value type="int" key="many">1</value>
|
121 |
|
<value type="int" key="modelOnly">0</value>
|
122 |
|
<link type="object" struct-name="db.Table" key="owner">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
|
123 |
|
<value _ptr_="0xa9fa9b0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
124 |
|
<link type="object">049dfc5e-a91b-11e2-bdec-080027bcf912</link>
|
125 |
|
</value>
|
126 |
|
<value type="int" key="referencedMandatory">0</value>
|
127 |
|
<value type="string" key="updateRule">CASCADE</value>
|
128 |
|
<value type="string" key="comment"></value>
|
129 |
|
<value type="string" key="name">fk_party_organization1</value>
|
130 |
|
<value type="string" key="oldName">fk_party_organization1</value>
|
131 |
|
</value>
|
132 |
|
<value type="object" struct-name="db.mysql.ForeignKey" id="be8fee8e-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x70a8fc40">
|
133 |
|
<link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
|
134 |
|
<value _ptr_="0xa9faa20" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
135 |
|
<link type="object">be8fe97a-a6e0-11e2-95e9-080027bcf912</link>
|
136 |
|
</value>
|
137 |
|
<value type="int" key="deferability">0</value>
|
138 |
|
<value type="string" key="deleteRule">CASCADE</value>
|
139 |
|
<link type="object" struct-name="db.Index" key="index">be8feb50-a6e0-11e2-95e9-080027bcf912</link>
|
140 |
|
<value type="int" key="mandatory">0</value>
|
141 |
|
<value type="int" key="many">0</value>
|
142 |
|
<value type="int" key="modelOnly">0</value>
|
143 |
|
<link type="object" struct-name="db.Table" key="owner">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
|
144 |
|
<value _ptr_="0xa9fad10" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
145 |
|
<link type="object">be8cd7b2-a6e0-11e2-95e9-080027bcf912</link>
|
146 |
|
</value>
|
147 |
|
<value type="int" key="referencedMandatory">1</value>
|
148 |
|
<value type="string" key="updateRule">CASCADE</value>
|
149 |
|
<value type="string" key="comment"></value>
|
150 |
|
<value type="string" key="name">fk_collection_source10</value>
|
151 |
|
<value type="string" key="oldName">fk_collection_source10</value>
|
152 |
|
</value>
|
153 |
|
</value>
|
154 |
|
<value _ptr_="0xa9f9288" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
|
155 |
|
<value type="object" struct-name="db.mysql.Index" id="be8feb50-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a">
|
156 |
|
<value _ptr_="0xa9fad80" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
157 |
|
<value type="object" struct-name="db.mysql.IndexColumn" id="c37e8388-ac44-11e2-820d-080027bcf912" struct-checksum="0x62630b3c">
|
158 |
|
<value type="int" key="columnLength">0</value>
|
159 |
|
<value type="string" key="comment"></value>
|
160 |
|
<value type="int" key="descend">0</value>
|
161 |
|
<link type="object" struct-name="db.Column" key="referencedColumn">be8fe97a-a6e0-11e2-95e9-080027bcf912</link>
|
162 |
|
<value type="string" key="name"></value>
|
163 |
|
<link type="object" struct-name="GrtObject" key="owner">be8feb50-a6e0-11e2-95e9-080027bcf912</link>
|
164 |
|
</value>
|
165 |
|
</value>
|
166 |
|
<value type="string" key="indexKind"></value>
|
167 |
|
<value type="int" key="keyBlockSize">0</value>
|
168 |
|
<value type="string" key="withParser"></value>
|
169 |
|
<value type="string" key="comment"></value>
|
170 |
|
<value type="int" key="deferability">0</value>
|
171 |
|
<value type="string" key="indexType">PRIMARY</value>
|
172 |
|
<value type="int" key="isPrimary">1</value>
|
173 |
|
<value type="string" key="name">PRIMARY</value>
|
174 |
|
<value type="int" key="unique">0</value>
|
175 |
|
<value type="string" key="oldName">PRIMARY</value>
|
176 |
|
<link type="object" struct-name="GrtObject" key="owner">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
|
177 |
|
</value>
|
178 |
|
<value type="object" struct-name="db.mysql.Index" id="e550389a-f676-11e2-9716-080027bcf912" struct-checksum="0x309b847a">
|
179 |
|
<value _ptr_="0xa9fb0e8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
180 |
|
<value type="object" struct-name="db.mysql.IndexColumn" id="e5503a2a-f676-11e2-9716-080027bcf912" struct-checksum="0x62630b3c">
|
181 |
|
<value type="int" key="columnLength">0</value>
|
182 |
|
<value type="string" key="comment"></value>
|
183 |
|
<value type="int" key="descend">0</value>
|
184 |
|
<link type="object" struct-name="db.Column" key="referencedColumn">e5502346-f676-11e2-9716-080027bcf912</link>
|
185 |
|
<value type="string" key="name"></value>
|
186 |
|
<link type="object" struct-name="GrtObject" key="owner">e550389a-f676-11e2-9716-080027bcf912</link>
|
187 |
|
</value>
|
188 |
|
</value>
|
189 |
|
<value type="string" key="indexKind"></value>
|
190 |
|
<value type="int" key="keyBlockSize">0</value>
|
191 |
|
<value type="string" key="withParser"></value>
|
192 |
|
<value type="string" key="comment"></value>
|
193 |
|
<value type="int" key="deferability">0</value>
|
194 |
|
<value type="string" key="indexType">INDEX</value>
|
195 |
|
<value type="int" key="isPrimary">0</value>
|
196 |
|
<value type="string" key="name">fk_party_organization1_idx</value>
|
197 |
|
<value type="int" key="unique">0</value>
|
198 |
|
<value type="string" key="oldName">fk_party_organization1_idx</value>
|
199 |
|
<link type="object" struct-name="GrtObject" key="owner">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
|
200 |
|
</value>
|
201 |
|
<value type="object" struct-name="db.mysql.Index" id="96b8693a-1e00-11e3-9d67-080027bcf912" struct-checksum="0x309b847a">
|
202 |
|
<value _ptr_="0xa9fb718" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
203 |
|
<value type="object" struct-name="db.mysql.IndexColumn" id="9d7d0032-1e00-11e3-9d67-080027bcf912" struct-checksum="0x62630b3c">
|
204 |
|
<value type="int" key="columnLength">0</value>
|
205 |
|
<value type="string" key="comment"></value>
|
206 |
|
<value type="int" key="descend">0</value>
|
207 |
|
<link type="object" struct-name="db.Column" key="referencedColumn">e5502346-f676-11e2-9716-080027bcf912</link>
|
208 |
|
<value type="string" key="name"></value>
|
209 |
|
<link type="object" struct-name="GrtObject" key="owner">96b8693a-1e00-11e3-9d67-080027bcf912</link>
|
210 |
|
</value>
|
211 |
|
<value type="object" struct-name="db.mysql.IndexColumn" id="9dff86e2-1e00-11e3-9d67-080027bcf912" struct-checksum="0x62630b3c">
|
212 |
|
<value type="int" key="columnLength">0</value>
|
213 |
|
<value type="string" key="comment"></value>
|
214 |
|
<value type="int" key="descend">0</value>
|
215 |
|
<link type="object" struct-name="db.Column" key="referencedColumn">8222d06e-1e00-11e3-9d67-080027bcf912</link>
|
216 |
|
<value type="string" key="name"></value>
|
217 |
|
<link type="object" struct-name="GrtObject" key="owner">96b8693a-1e00-11e3-9d67-080027bcf912</link>
|
218 |
|
</value>
|
219 |
|
</value>
|
220 |
|
<value type="string" key="indexKind"></value>
|
221 |
|
<value type="int" key="keyBlockSize">0</value>
|
222 |
|
<value type="string" key="withParser"></value>
|
223 |
|
<value type="string" key="comment"></value>
|
224 |
|
<value type="int" key="deferability">0</value>
|
225 |
|
<value type="string" key="indexType">INDEX</value>
|
226 |
|
<value type="int" key="isPrimary">0</value>
|
227 |
|
<value type="string" key="name">party_unique</value>
|
228 |
|
<value type="int" key="unique">0</value>
|
229 |
|
<value type="string" key="oldName">party_unique</value>
|
230 |
|
<link type="object" struct-name="GrtObject" key="owner">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
|
231 |
|
</value>
|
232 |
|
</value>
|
233 |
|
<value type="string" key="maxRows"></value>
|
234 |
|
<value type="string" key="mergeInsert"></value>
|
235 |
|
<value type="string" key="mergeUnion"></value>
|
236 |
|
<value type="string" key="minRows"></value>
|
237 |
|
<value type="string" key="nextAutoInc"></value>
|
238 |
|
<value type="string" key="packKeys"></value>
|
239 |
|
<value type="int" key="partitionCount">0</value>
|
240 |
|
<value _ptr_="0xa9f9318" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
|
241 |
|
<value type="string" key="partitionExpression"></value>
|
242 |
|
<value type="string" key="partitionType"></value>
|
243 |
|
<value type="string" key="password"></value>
|
244 |
|
<link type="object" struct-name="db.mysql.Index" key="primaryKey">be8feb50-a6e0-11e2-95e9-080027bcf912</link>
|
245 |
|
<value type="string" key="raidChunkSize"></value>
|
246 |
|
<value type="string" key="raidChunks"></value>
|
247 |
|
<value type="string" key="raidType"></value>
|
248 |
|
<value type="string" key="rowFormat"></value>
|
249 |
|
<value type="int" key="subpartitionCount">0</value>
|
250 |
|
<value type="string" key="subpartitionExpression"></value>
|
251 |
|
<value type="string" key="subpartitionType"></value>
|
252 |
|
<value type="string" key="tableDataDir"></value>
|
253 |
|
<value type="string" key="tableEngine">InnoDB</value>
|
254 |
|
<value type="string" key="tableIndexDir"></value>
|
255 |
|
<value _ptr_="0xa9f92b8" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
|
256 |
|
<value type="int" key="isStub">0</value>
|
257 |
|
<value type="int" key="isSystem">0</value>
|
258 |
|
<value type="int" key="isTemporary">0</value>
|
259 |
|
<value type="string" key="temporaryScope"></value>
|
260 |
|
<value type="int" key="commentedOut">0</value>
|
261 |
|
<value type="string" key="createDate">2013-04-16 14:58</value>
|
262 |
|
<value _ptr_="0xa229a70" type="dict" key="customData"/>
|
263 |
|
<value type="string" key="lastChangeDate">2013-09-15 05:16</value>
|
264 |
|
<value type="int" key="modelOnly">0</value>
|
265 |
|
<value type="string" key="name">party</value>
|
266 |
|
<link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
|
267 |
|
<value type="string" key="temp_sql"></value>
|
268 |
|
<value type="string" key="comment"></value>
|
269 |
|
<value type="string" key="oldName">party</value>
|
270 |
|
</value>
|
271 |
|
<value type="object" struct-name="db.mysql.Table" id="be8cc04c-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x1a403946">
|
272 |
|
<value type="string" key="avgRowLength"></value>
|
273 |
|
<value type="int" key="checksum">0</value>
|
274 |
|
<value _ptr_="0xa9fbd48" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
|
275 |
|
<value type="object" struct-name="db.mysql.Column" id="be8cc362-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183">
|
276 |
|
<value type="int" key="autoIncrement">0</value>
|
277 |
|
<value type="string" key="characterSetName"></value>
|
278 |
|
<value _ptr_="0xa9fca30" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
279 |
|
<value type="string" key="collationName"></value>
|
280 |
|
<value type="string" key="datatypeExplicitParams"></value>
|
281 |
|
<value type="string" key="defaultValue"></value>
|
282 |
|
<value type="int" key="defaultValueIsNull">0</value>
|
283 |
|
<value _ptr_="0xa9fcd58" type="list" content-type="string" key="flags"/>
|
284 |
|
<value type="int" key="isNotNull">1</value>
|
285 |
|
<value type="int" key="length">767</value>
|
286 |
|
<value type="int" key="precision">-1</value>
|
287 |
|
<value type="int" key="scale">-1</value>
|
288 |
|
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
|
289 |
|
<value type="string" key="comment"></value>
|
290 |
|
<value type="string" key="name">id</value>
|
291 |
|
<value type="string" key="oldName">id</value>
|
292 |
|
<link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
|
293 |
|
</value>
|
294 |
|
<value type="object" struct-name="db.mysql.Column" id="c7c1e862-a91b-11e2-bdec-080027bcf912" struct-checksum="0x783b5183">
|
295 |
|
<value type="int" key="autoIncrement">0</value>
|
296 |
|
<value type="string" key="characterSetName"></value>
|
297 |
|
<value _ptr_="0xa9fcea8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
298 |
|
<value type="string" key="collationName"></value>
|
299 |
|
<value type="string" key="datatypeExplicitParams"></value>
|
300 |
|
<value type="string" key="defaultValue"></value>
|
301 |
|
<value type="int" key="defaultValueIsNull">1</value>
|
302 |
|
<value _ptr_="0xa9fd1d0" type="list" content-type="string" key="flags"/>
|
303 |
|
<value type="int" key="isNotNull">0</value>
|
304 |
|
<value type="int" key="length">767</value>
|
305 |
|
<value type="int" key="precision">-1</value>
|
306 |
|
<value type="int" key="scale">-1</value>
|
307 |
|
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
|
308 |
|
<value type="string" key="comment"></value>
|
309 |
|
<value type="string" key="name">first_publisher</value>
|
310 |
|
<value type="string" key="oldName">first_publisher</value>
|
311 |
|
<link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
|
312 |
|
</value>
|
313 |
|
<value type="object" struct-name="db.mysql.Column" id="c8552b14-a7bc-11e2-8af2-080027bcf912" struct-checksum="0x783b5183">
|
314 |
|
<value type="int" key="autoIncrement">0</value>
|
315 |
|
<value type="string" key="characterSetName"></value>
|
316 |
|
<value _ptr_="0xa9fd320" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
317 |
|
<value type="string" key="collationName"></value>
|
318 |
|
<value type="string" key="datatypeExplicitParams"></value>
|
319 |
|
<value type="string" key="defaultValue"></value>
|
320 |
|
<value type="int" key="defaultValueIsNull">1</value>
|
321 |
|
<value _ptr_="0xa9fd648" type="list" content-type="string" key="flags"/>
|
322 |
|
<value type="int" key="isNotNull">0</value>
|
323 |
|
<value type="int" key="length">767</value>
|
324 |
|
<value type="int" key="precision">-1</value>
|
325 |
|
<value type="int" key="scale">-1</value>
|
326 |
|
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
|
327 |
|
<value type="string" key="comment">parties who must be given attribution, such as copyrightholders</value>
|
328 |
|
<value type="string" key="name">data_owners</value>
|
329 |
|
<value type="string" key="oldName">data_owners</value>
|
330 |
|
<link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
|
331 |
|
</value>
|
332 |
|
<value type="object" struct-name="db.mysql.Column" id="873d473c-1df1-11e3-bbb6-080027bcf912" struct-checksum="0x783b5183">
|
333 |
|
<value type="int" key="autoIncrement">0</value>
|
334 |
|
<value type="string" key="characterSetName"></value>
|
335 |
|
<value _ptr_="0xa9fd798" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
336 |
|
<value type="string" key="collationName"></value>
|
337 |
|
<value type="string" key="datatypeExplicitParams"></value>
|
338 |
|
<value type="string" key="defaultValue"></value>
|
339 |
|
<value type="int" key="defaultValueIsNull">1</value>
|
340 |
|
<value _ptr_="0xa9fdac0" type="list" content-type="string" key="flags"/>
|
341 |
|
<value type="int" key="isNotNull">0</value>
|
342 |
|
<value type="int" key="length">767</value>
|
343 |
|
<value type="int" key="precision">-1</value>
|
344 |
|
<value type="int" key="scale">-1</value>
|
345 |
|
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
|
346 |
|
<value type="string" key="comment"></value>
|
347 |
|
<value type="string" key="name">contacts</value>
|
348 |
|
<value type="string" key="oldName">contacts</value>
|
349 |
|
<link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
|
350 |
|
</value>
|
351 |
|
<value type="object" struct-name="db.mysql.Column" id="e5155806-a793-11e2-84c3-080027bcf912" struct-checksum="0x783b5183">
|
352 |
|
<value type="int" key="autoIncrement">0</value>
|
353 |
|
<value type="string" key="characterSetName"></value>
|
354 |
|
<value _ptr_="0xa9fdc10" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
355 |
|
<value type="string" key="collationName"></value>
|
356 |
|
<value type="string" key="datatypeExplicitParams">('hstore')</value>
|
357 |
|
<value type="string" key="defaultValue"></value>
|
358 |
|
<value type="int" key="defaultValueIsNull">0</value>
|
359 |
|
<value _ptr_="0xa9fdf38" type="list" content-type="string" key="flags"/>
|
360 |
|
<value type="int" key="isNotNull">0</value>
|
361 |
|
<value type="int" key="length">-1</value>
|
362 |
|
<value type="int" key="precision">-1</value>
|
363 |
|
<value type="int" key="scale">-1</value>
|
364 |
|
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.set</link>
|
365 |
|
<value type="string" key="comment"></value>
|
366 |
|
<value type="string" key="name">info</value>
|
367 |
|
<value type="string" key="oldName">info</value>
|
368 |
|
<link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
|
369 |
|
</value>
|
370 |
|
</value>
|
371 |
|
<value type="string" key="connectionString"></value>
|
372 |
|
<value type="string" key="defaultCharacterSetName">utf8</value>
|
373 |
|
<value type="string" key="defaultCollationName">utf8_bin</value>
|
374 |
|
<value type="int" key="delayKeyWrite">0</value>
|
375 |
|
<value _ptr_="0xa9fc7d0" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
|
376 |
|
<value type="object" struct-name="db.mysql.ForeignKey" id="c7c1e6aa-a91b-11e2-bdec-080027bcf912" struct-checksum="0x70a8fc40">
|
377 |
|
<link type="object" struct-name="db.mysql.Table" key="referencedTable">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
|
378 |
|
<value _ptr_="0xa9fe0b0" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
379 |
|
<link type="object">c7c1e862-a91b-11e2-bdec-080027bcf912</link>
|
380 |
|
</value>
|
381 |
|
<value type="int" key="deferability">0</value>
|
382 |
|
<value type="string" key="deleteRule">CASCADE</value>
|
383 |
|
<link type="object" struct-name="db.Index" key="index">c7c2089c-a91b-11e2-bdec-080027bcf912</link>
|
384 |
|
<value type="int" key="mandatory">1</value>
|
385 |
|
<value type="int" key="many">1</value>
|
386 |
|
<value type="int" key="modelOnly">0</value>
|
387 |
|
<link type="object" struct-name="db.Table" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
|
388 |
|
<value _ptr_="0xa9fe3a0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
389 |
|
<link type="object">be8fe97a-a6e0-11e2-95e9-080027bcf912</link>
|
390 |
|
</value>
|
391 |
|
<value type="int" key="referencedMandatory">0</value>
|
392 |
|
<value type="string" key="updateRule">CASCADE</value>
|
393 |
|
<value type="string" key="comment"></value>
|
394 |
|
<value type="string" key="name">fk_source_party2</value>
|
395 |
|
<value type="string" key="oldName">fk_source_party2</value>
|
396 |
|
</value>
|
397 |
|
<value type="object" struct-name="db.mysql.ForeignKey" id="61c193a8-1dee-11e3-b571-080027bcf912" struct-checksum="0x70a8fc40">
|
398 |
|
<link type="object" struct-name="db.mysql.Table" key="referencedTable">4001ec92-f678-11e2-9716-080027bcf912</link>
|
399 |
|
<value _ptr_="0xa9fe410" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
400 |
|
<link type="object">c8552b14-a7bc-11e2-8af2-080027bcf912</link>
|
401 |
|
</value>
|
402 |
|
<value type="int" key="deferability">0</value>
|
403 |
|
<value type="string" key="deleteRule">CASCADE</value>
|
404 |
|
<link type="object" struct-name="db.Index" key="index">61c1b04a-1dee-11e3-b571-080027bcf912</link>
|
405 |
|
<value type="int" key="mandatory">1</value>
|
406 |
|
<value type="int" key="many">1</value>
|
407 |
|
<value type="int" key="modelOnly">0</value>
|
408 |
|
<link type="object" struct-name="db.Table" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
|
409 |
|
<value _ptr_="0xa9fe700" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
410 |
|
<link type="object">4001ef9e-f678-11e2-9716-080027bcf912</link>
|
411 |
|
</value>
|
412 |
|
<value type="int" key="referencedMandatory">0</value>
|
413 |
|
<value type="string" key="updateRule">CASCADE</value>
|
414 |
|
<value type="string" key="comment"></value>
|
415 |
|
<value type="string" key="name">fk_source_party_list1</value>
|
416 |
|
<value type="string" key="oldName">fk_source_party_list1</value>
|
417 |
|
</value>
|
418 |
|
<value type="object" struct-name="db.mysql.ForeignKey" id="873d44bc-1df1-11e3-bbb6-080027bcf912" struct-checksum="0x70a8fc40">
|
419 |
|
<link type="object" struct-name="db.mysql.Table" key="referencedTable">4001ec92-f678-11e2-9716-080027bcf912</link>
|
420 |
|
<value _ptr_="0xa9fe770" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
421 |
|
<link type="object">873d473c-1df1-11e3-bbb6-080027bcf912</link>
|
422 |
|
</value>
|
423 |
|
<value type="int" key="deferability">0</value>
|
424 |
|
<value type="string" key="deleteRule">CASCADE</value>
|
425 |
|
<link type="object" struct-name="db.Index" key="index">d2855d46-1df2-11e3-bbb6-080027bcf912</link>
|
426 |
|
<value type="int" key="mandatory">1</value>
|
427 |
|
<value type="int" key="many">1</value>
|
428 |
|
<value type="int" key="modelOnly">0</value>
|
429 |
|
<link type="object" struct-name="db.Table" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
|
430 |
|
<value _ptr_="0xa9fea60" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
431 |
|
<link type="object">4001ef9e-f678-11e2-9716-080027bcf912</link>
|
432 |
|
</value>
|
433 |
|
<value type="int" key="referencedMandatory">0</value>
|
434 |
|
<value type="string" key="updateRule">CASCADE</value>
|
435 |
|
<value type="string" key="comment"></value>
|
436 |
|
<value type="string" key="name">fk_source_party1</value>
|
437 |
|
<value type="string" key="oldName">fk_source_party1</value>
|
438 |
|
</value>
|
439 |
|
<value type="object" struct-name="db.mysql.ForeignKey" id="7e2aa84c-1dfb-11e3-bbb6-080027bcf912" struct-checksum="0x70a8fc40">
|
440 |
|
<link type="object" struct-name="db.mysql.Table" key="referencedTable">afc401d4-1df9-11e3-bbb6-080027bcf912</link>
|
441 |
|
<value _ptr_="0xa9fead0" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
442 |
|
<link type="object">be8cc362-a6e0-11e2-95e9-080027bcf912</link>
|
443 |
|
</value>
|
444 |
|
<value type="int" key="deferability">0</value>
|
445 |
|
<value type="string" key="deleteRule">CASCADE</value>
|
446 |
|
<value type="int" key="mandatory">0</value>
|
447 |
|
<value type="int" key="many">0</value>
|
448 |
|
<value type="int" key="modelOnly">0</value>
|
449 |
|
<link type="object" struct-name="db.Table" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
|
450 |
|
<value _ptr_="0xa9fedc0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
451 |
|
<link type="object">afc4053a-1df9-11e3-bbb6-080027bcf912</link>
|
452 |
|
</value>
|
453 |
|
<value type="int" key="referencedMandatory">1</value>
|
454 |
|
<value type="string" key="updateRule">CASCADE</value>
|
455 |
|
<value type="string" key="comment"></value>
|
456 |
|
<value type="string" key="name">fk_dataset_source1</value>
|
457 |
|
<value type="string" key="oldName">fk_dataset_source1</value>
|
458 |
|
</value>
|
459 |
|
<value type="object" struct-name="db.mysql.ForeignKey" id="760751d2-2324-11e3-a5a2-080027bcf912" struct-checksum="0x70a8fc40">
|
460 |
|
<link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
|
461 |
|
<value _ptr_="0xb2c0160" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
462 |
|
<link type="object">be8cc362-a6e0-11e2-95e9-080027bcf912</link>
|
463 |
|
</value>
|
464 |
|
<value type="int" key="deferability">0</value>
|
465 |
|
<value type="string" key="deleteRule">CASCADE</value>
|
466 |
|
<value type="int" key="mandatory">0</value>
|
467 |
|
<value type="int" key="many">0</value>
|
468 |
|
<value type="int" key="modelOnly">0</value>
|
469 |
|
<link type="object" struct-name="db.Table" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
|
470 |
|
<value _ptr_="0xb2c0258" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
471 |
|
<link type="object">be8cd7b2-a6e0-11e2-95e9-080027bcf912</link>
|
472 |
|
</value>
|
473 |
|
<value type="int" key="referencedMandatory">1</value>
|
474 |
|
<value type="string" key="updateRule">CASCADE</value>
|
475 |
|
<value type="string" key="comment"></value>
|
476 |
|
<value type="string" key="name">fk_dataset_traceable1</value>
|
477 |
|
<value type="string" key="oldName">fk_dataset_traceable1</value>
|
478 |
|
</value>
|
479 |
|
</value>
|
480 |
|
<value _ptr_="0xa9fc800" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
|
481 |
|
<value type="object" struct-name="db.mysql.Index" id="be8cc75e-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a">
|
482 |
|
<value _ptr_="0xa9fee30" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
483 |
|
<value type="object" struct-name="db.mysql.IndexColumn" id="be8cc970-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x62630b3c">
|
484 |
|
<value type="int" key="columnLength">0</value>
|
485 |
|
<value type="string" key="comment"></value>
|
486 |
|
<value type="int" key="descend">0</value>
|
487 |
|
<link type="object" struct-name="db.Column" key="referencedColumn">be8cc362-a6e0-11e2-95e9-080027bcf912</link>
|
488 |
|
<value type="string" key="name"></value>
|
489 |
|
<link type="object" struct-name="GrtObject" key="owner">be8cc75e-a6e0-11e2-95e9-080027bcf912</link>
|
490 |
|
</value>
|
491 |
|
</value>
|
492 |
|
<value type="string" key="indexKind"></value>
|
493 |
|
<value type="int" key="keyBlockSize">0</value>
|
494 |
|
<value type="string" key="withParser"></value>
|
495 |
|
<value type="string" key="comment"></value>
|
496 |
|
<value type="int" key="deferability">0</value>
|
497 |
|
<value type="string" key="indexType">PRIMARY</value>
|
498 |
|
<value type="int" key="isPrimary">1</value>
|
499 |
|
<value type="string" key="name">PRIMARY</value>
|
500 |
|
<value type="int" key="unique">0</value>
|
501 |
|
<value type="string" key="oldName">PRIMARY</value>
|
502 |
|
<link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
|
503 |
|
</value>
|
504 |
|
<value type="object" struct-name="db.mysql.Index" id="c7c2089c-a91b-11e2-bdec-080027bcf912" struct-checksum="0x309b847a">
|
505 |
|
<value _ptr_="0xa9ff198" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
506 |
|
<value type="object" struct-name="db.mysql.IndexColumn" id="c7c20a4a-a91b-11e2-bdec-080027bcf912" struct-checksum="0x62630b3c">
|
507 |
|
<value type="int" key="columnLength">0</value>
|
508 |
|
<value type="string" key="comment"></value>
|
509 |
|
<value type="int" key="descend">0</value>
|
510 |
|
<link type="object" struct-name="db.Column" key="referencedColumn">c7c1e862-a91b-11e2-bdec-080027bcf912</link>
|
511 |
|
<value type="string" key="name"></value>
|
512 |
|
<link type="object" struct-name="GrtObject" key="owner">c7c2089c-a91b-11e2-bdec-080027bcf912</link>
|
513 |
|
</value>
|
514 |
|
</value>
|
515 |
|
<value type="string" key="indexKind"></value>
|
516 |
|
<value type="int" key="keyBlockSize">0</value>
|
517 |
|
<value type="string" key="withParser"></value>
|
518 |
|
<value type="string" key="comment"></value>
|
519 |
|
<value type="int" key="deferability">0</value>
|
520 |
|
<value type="string" key="indexType">INDEX</value>
|
521 |
|
<value type="int" key="isPrimary">0</value>
|
522 |
|
<value type="string" key="name">fk_source_party2_idx</value>
|
523 |
|
<value type="int" key="unique">0</value>
|
524 |
|
<value type="string" key="oldName">fk_source_party2_idx</value>
|
525 |
|
<link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
|
526 |
|
</value>
|
527 |
|
<value type="object" struct-name="db.mysql.Index" id="61c1b04a-1dee-11e3-b571-080027bcf912" struct-checksum="0x309b847a">
|
528 |
|
<value _ptr_="0xa9ff7c8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
529 |
|
<value type="object" struct-name="db.mysql.IndexColumn" id="61c1e9d4-1dee-11e3-b571-080027bcf912" struct-checksum="0x62630b3c">
|
530 |
|
<value type="int" key="columnLength">0</value>
|
531 |
|
<value type="string" key="comment"></value>
|
532 |
|
<value type="int" key="descend">0</value>
|
533 |
|
<link type="object" struct-name="db.Column" key="referencedColumn">c8552b14-a7bc-11e2-8af2-080027bcf912</link>
|
534 |
|
<value type="string" key="name"></value>
|
535 |
|
<link type="object" struct-name="GrtObject" key="owner">61c1b04a-1dee-11e3-b571-080027bcf912</link>
|
536 |
|
</value>
|
537 |
|
</value>
|
538 |
|
<value type="string" key="indexKind"></value>
|
539 |
|
<value type="int" key="keyBlockSize">0</value>
|
540 |
|
<value type="string" key="withParser"></value>
|
541 |
|
<value type="string" key="comment"></value>
|
542 |
|
<value type="int" key="deferability">0</value>
|
543 |
|
<value type="string" key="indexType">INDEX</value>
|
544 |
|
<value type="int" key="isPrimary">0</value>
|
545 |
|
<value type="string" key="name">fk_source_party_list1_idx</value>
|
546 |
|
<value type="int" key="unique">0</value>
|
547 |
|
<value type="string" key="oldName">fk_source_party_list1_idx</value>
|
548 |
|
<link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
|
549 |
|
</value>
|
550 |
|
<value type="object" struct-name="db.mysql.Index" id="d2855d46-1df2-11e3-bbb6-080027bcf912" struct-checksum="0x309b847a">
|
551 |
|
<value _ptr_="0xa9ffdf8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
552 |
|
<value type="object" struct-name="db.mysql.IndexColumn" id="d2867b72-1df2-11e3-bbb6-080027bcf912" struct-checksum="0x62630b3c">
|
553 |
|
<value type="int" key="columnLength">0</value>
|
554 |
|
<value type="string" key="comment"></value>
|
555 |
|
<value type="int" key="descend">0</value>
|
556 |
|
<link type="object" struct-name="db.Column" key="referencedColumn">873d473c-1df1-11e3-bbb6-080027bcf912</link>
|
557 |
|
<value type="string" key="name"></value>
|
558 |
|
<link type="object" struct-name="GrtObject" key="owner">d2855d46-1df2-11e3-bbb6-080027bcf912</link>
|
559 |
|
</value>
|
560 |
|
</value>
|
561 |
|
<value type="string" key="indexKind"></value>
|
562 |
|
<value type="int" key="keyBlockSize">0</value>
|
563 |
|
<value type="string" key="withParser"></value>
|
564 |
|
<value type="string" key="comment"></value>
|
565 |
|
<value type="int" key="deferability">0</value>
|
566 |
|
<value type="string" key="indexType">INDEX</value>
|
567 |
|
<value type="int" key="isPrimary">0</value>
|
568 |
|
<value type="string" key="name">fk_source_party1_idx</value>
|
569 |
|
<value type="int" key="unique">0</value>
|
570 |
|
<value type="string" key="oldName">fk_source_party1_idx</value>
|
571 |
|
<link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
|
572 |
|
</value>
|
573 |
|
</value>
|
574 |
|
<value type="string" key="maxRows"></value>
|
575 |
|
<value type="string" key="mergeInsert"></value>
|
576 |
|
<value type="string" key="mergeUnion"></value>
|
577 |
|
<value type="string" key="minRows"></value>
|
578 |
|
<value type="string" key="nextAutoInc"></value>
|
579 |
|
<value type="string" key="packKeys"></value>
|
580 |
|
<value type="int" key="partitionCount">0</value>
|
581 |
|
<value _ptr_="0xa9fc890" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
|
582 |
|
<value type="string" key="partitionExpression"></value>
|
583 |
|
<value type="string" key="partitionType"></value>
|
584 |
|
<value type="string" key="password"></value>
|
585 |
|
<link type="object" struct-name="db.mysql.Index" key="primaryKey">be8cc75e-a6e0-11e2-95e9-080027bcf912</link>
|
586 |
|
<value type="string" key="raidChunkSize"></value>
|
587 |
|
<value type="string" key="raidChunks"></value>
|
588 |
|
<value type="string" key="raidType"></value>
|
589 |
|
<value type="string" key="rowFormat"></value>
|
590 |
|
<value type="int" key="subpartitionCount">0</value>
|
591 |
|
<value type="string" key="subpartitionExpression"></value>
|
592 |
|
<value type="string" key="subpartitionType"></value>
|
593 |
|
<value type="string" key="tableDataDir"></value>
|
594 |
|
<value type="string" key="tableEngine">InnoDB</value>
|
595 |
|
<value type="string" key="tableIndexDir"></value>
|
596 |
|
<value _ptr_="0xa9fc830" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
|
597 |
|
<value type="int" key="isStub">0</value>
|
598 |
|
<value type="int" key="isSystem">0</value>
|
599 |
|
<value type="int" key="isTemporary">0</value>
|
600 |
|
<value type="string" key="temporaryScope"></value>
|
601 |
|
<value type="int" key="commentedOut">0</value>
|
602 |
|
<value type="string" key="createDate">2013-04-16 14:58</value>
|
603 |
|
<value _ptr_="0xa22e508" type="dict" key="customData"/>
|
604 |
|
<value type="string" key="lastChangeDate">2013-09-15 04:36</value>
|
605 |
|
<value type="int" key="modelOnly">0</value>
|
606 |
|
<value type="string" key="name">dataset</value>
|
607 |
|
<link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
|
608 |
|
<value type="string" key="temp_sql"></value>
|
609 |
|
<value type="string" key="comment">something requiring attribution</value>
|
610 |
|
<value type="string" key="oldName">dataset</value>
|
611 |
|
</value>
|
612 |
|
<value type="object" struct-name="db.mysql.Table" id="be8df962-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x1a403946">
|
613 |
|
<value type="string" key="avgRowLength"></value>
|
614 |
|
<value type="int" key="checksum">0</value>
|
615 |
|
<value _ptr_="0xaa00428" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
|
616 |
|
<value type="object" struct-name="db.mysql.Column" id="be8dfbf6-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183">
|
617 |
|
<value type="int" key="autoIncrement">0</value>
|
618 |
|
<value type="string" key="characterSetName"></value>
|
619 |
|
<value _ptr_="0xaa00e30" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
620 |
|
<value type="string" key="collationName"></value>
|
621 |
|
<value type="string" key="datatypeExplicitParams"></value>
|
622 |
|
<value type="string" key="defaultValue"></value>
|
623 |
|
<value type="int" key="defaultValueIsNull">0</value>
|
624 |
|
<value _ptr_="0xaa01158" type="list" content-type="string" key="flags"/>
|
625 |
|
<value type="int" key="isNotNull">1</value>
|
626 |
|
<value type="int" key="length">767</value>
|
627 |
|
<value type="int" key="precision">-1</value>
|
628 |
|
<value type="int" key="scale">-1</value>
|
629 |
|
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
|
630 |
|
<value type="string" key="comment"></value>
|
631 |
|
<value type="string" key="name">id</value>
|
632 |
|
<value type="string" key="oldName">id</value>
|
633 |
|
<link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
|
634 |
|
</value>
|
635 |
|
<value type="object" struct-name="db.mysql.Column" id="ed1eb468-ad0e-11e2-b309-080027bcf912" struct-checksum="0x783b5183">
|
636 |
|
<value type="int" key="autoIncrement">0</value>
|
637 |
|
<value type="string" key="characterSetName"></value>
|
638 |
|
<value _ptr_="0xaa012a8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
639 |
|
<value type="string" key="collationName"></value>
|
640 |
|
<value type="string" key="datatypeExplicitParams"></value>
|
641 |
|
<value type="string" key="defaultValue"></value>
|
642 |
|
<value type="int" key="defaultValueIsNull">0</value>
|
643 |
|
<value _ptr_="0xaa015d0" type="list" content-type="string" key="flags"/>
|
644 |
|
<value type="int" key="isNotNull">1</value>
|
645 |
|
<value type="int" key="length">767</value>
|
646 |
|
<value type="int" key="precision">-1</value>
|
647 |
|
<value type="int" key="scale">-1</value>
|
648 |
|
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
|
649 |
|
<value type="string" key="comment"></value>
|
650 |
|
<value type="string" key="name">institution</value>
|
651 |
|
<value type="string" key="oldName">institution</value>
|
652 |
|
<link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
|
653 |
|
</value>
|
654 |
|
<value type="object" struct-name="db.mysql.Column" id="45a3f404-ad0f-11e2-b309-080027bcf912" struct-checksum="0x783b5183">
|
655 |
|
<value type="int" key="autoIncrement">0</value>
|
656 |
|
<value type="string" key="characterSetName"></value>
|
657 |
|
<value _ptr_="0xaa01720" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
658 |
|
<value type="string" key="collationName"></value>
|
659 |
|
<value type="string" key="datatypeExplicitParams"></value>
|
660 |
|
<value type="string" key="defaultValue"></value>
|
661 |
|
<value type="int" key="defaultValueIsNull">0</value>
|
662 |
|
<value _ptr_="0xaa01a48" type="list" content-type="string" key="flags"/>
|
663 |
|
<value type="int" key="isNotNull">1</value>
|
664 |
|
<value type="int" key="length">767</value>
|
665 |
|
<value type="int" key="precision">-1</value>
|
666 |
|
<value type="int" key="scale">-1</value>
|
667 |
|
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
|
668 |
|
<value type="string" key="comment"></value>
|
669 |
|
<value type="string" key="name">name</value>
|
670 |
|
<value type="string" key="oldName">name</value>
|
671 |
|
<link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
|
672 |
|
</value>
|
673 |
|
</value>
|
674 |
|
<value type="string" key="connectionString"></value>
|
675 |
|
<value type="string" key="defaultCharacterSetName">utf8</value>
|
676 |
|
<value type="string" key="defaultCollationName">utf8_bin</value>
|
677 |
|
<value type="int" key="delayKeyWrite">0</value>
|
678 |
|
<value _ptr_="0xaa00bd0" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
|
679 |
|
<value type="object" struct-name="db.mysql.ForeignKey" id="be8e0240-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x70a8fc40">
|
680 |
|
<link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
|
681 |
|
<value _ptr_="0xaa01bc0" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
682 |
|
<link type="object">be8dfbf6-a6e0-11e2-95e9-080027bcf912</link>
|
683 |
|
</value>
|
684 |
|
<value type="int" key="deferability">0</value>
|
685 |
|
<value type="string" key="deleteRule">CASCADE</value>
|
686 |
|
<link type="object" struct-name="db.Index" key="index">81937b1c-ad12-11e2-b309-080027bcf912</link>
|
687 |
|
<value type="int" key="mandatory">0</value>
|
688 |
|
<value type="int" key="many">0</value>
|
689 |
|
<value type="int" key="modelOnly">0</value>
|
690 |
|
<link type="object" struct-name="db.Table" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
|
691 |
|
<value _ptr_="0xaa01eb0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
692 |
|
<link type="object">be8cd7b2-a6e0-11e2-95e9-080027bcf912</link>
|
693 |
|
</value>
|
694 |
|
<value type="int" key="referencedMandatory">1</value>
|
695 |
|
<value type="string" key="updateRule">CASCADE</value>
|
696 |
|
<value type="string" key="comment"></value>
|
697 |
|
<value type="string" key="name">fk_collection_source1</value>
|
698 |
|
<value type="string" key="oldName">fk_collection_source1</value>
|
699 |
|
</value>
|
700 |
|
<value type="object" struct-name="db.mysql.ForeignKey" id="ed1eb2a6-ad0e-11e2-b309-080027bcf912" struct-checksum="0x70a8fc40">
|
701 |
|
<link type="object" struct-name="db.mysql.Table" key="referencedTable">049df920-a91b-11e2-bdec-080027bcf912</link>
|
702 |
|
<value _ptr_="0xaa01f20" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
703 |
|
<link type="object">ed1eb468-ad0e-11e2-b309-080027bcf912</link>
|
704 |
|
</value>
|
705 |
|
<value type="int" key="deferability">0</value>
|
706 |
|
<value type="string" key="deleteRule">CASCADE</value>
|
707 |
|
<link type="object" struct-name="db.Index" key="index">ed1ec98a-ad0e-11e2-b309-080027bcf912</link>
|
708 |
|
<value type="int" key="mandatory">1</value>
|
709 |
|
<value type="int" key="many">1</value>
|
710 |
|
<value type="int" key="modelOnly">0</value>
|
711 |
|
<link type="object" struct-name="db.Table" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
|
712 |
|
<value _ptr_="0xaa02210" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
713 |
|
<link type="object">049dfc5e-a91b-11e2-bdec-080027bcf912</link>
|
714 |
|
</value>
|
715 |
|
<value type="int" key="referencedMandatory">1</value>
|
716 |
|
<value type="string" key="updateRule">CASCADE</value>
|
717 |
|
<value type="string" key="comment"></value>
|
718 |
|
<value type="string" key="name">fk_collection_organization1</value>
|
719 |
|
<value type="string" key="oldName">fk_collection_organization1</value>
|
720 |
|
</value>
|
721 |
|
</value>
|
722 |
|
<value _ptr_="0xaa00c00" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
|
723 |
|
<value type="object" struct-name="db.mysql.Index" id="ed1ec98a-ad0e-11e2-b309-080027bcf912" struct-checksum="0x309b847a">
|
724 |
|
<value _ptr_="0xaa02280" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
725 |
|
<value type="object" struct-name="db.mysql.IndexColumn" id="ed1ecb1a-ad0e-11e2-b309-080027bcf912" struct-checksum="0x62630b3c">
|
726 |
|
<value type="int" key="columnLength">0</value>
|
727 |
|
<value type="string" key="comment"></value>
|
728 |
|
<value type="int" key="descend">0</value>
|
729 |
|
<link type="object" struct-name="db.Column" key="referencedColumn">ed1eb468-ad0e-11e2-b309-080027bcf912</link>
|
730 |
|
<value type="string" key="name"></value>
|
731 |
|
<link type="object" struct-name="GrtObject" key="owner">ed1ec98a-ad0e-11e2-b309-080027bcf912</link>
|
732 |
|
</value>
|
733 |
|
</value>
|
734 |
|
<value type="string" key="indexKind"></value>
|
735 |
|
<value type="int" key="keyBlockSize">0</value>
|
736 |
|
<value type="string" key="withParser"></value>
|
737 |
|
<value type="string" key="comment"></value>
|
738 |
|
<value type="int" key="deferability">0</value>
|
739 |
|
<value type="string" key="indexType">INDEX</value>
|
740 |
|
<value type="int" key="isPrimary">0</value>
|
741 |
|
<value type="string" key="name">fk_collection_organization1_idx</value>
|
742 |
|
<value type="int" key="unique">0</value>
|
743 |
|
<value type="string" key="oldName">fk_collection_organization1_idx</value>
|
744 |
|
<link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
|
745 |
|
</value>
|
746 |
|
<value type="object" struct-name="db.mysql.Index" id="6b54505e-ad0f-11e2-b309-080027bcf912" struct-checksum="0x309b847a">
|
747 |
|
<value _ptr_="0xaa025e8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
748 |
|
<value type="object" struct-name="db.mysql.IndexColumn" id="6dd2beb0-ad0f-11e2-b309-080027bcf912" struct-checksum="0x62630b3c">
|
749 |
|
<value type="int" key="columnLength">0</value>
|
750 |
|
<value type="string" key="comment"></value>
|
751 |
|
<value type="int" key="descend">0</value>
|
752 |
|
<link type="object" struct-name="db.Column" key="referencedColumn">ed1eb468-ad0e-11e2-b309-080027bcf912</link>
|
753 |
|
<value type="string" key="name"></value>
|
754 |
|
<link type="object" struct-name="GrtObject" key="owner">6b54505e-ad0f-11e2-b309-080027bcf912</link>
|
755 |
|
</value>
|
756 |
|
<value type="object" struct-name="db.mysql.IndexColumn" id="6e294b90-ad0f-11e2-b309-080027bcf912" struct-checksum="0x62630b3c">
|
757 |
|
<value type="int" key="columnLength">0</value>
|
758 |
|
<value type="string" key="comment"></value>
|
759 |
|
<value type="int" key="descend">0</value>
|
760 |
|
<link type="object" struct-name="db.Column" key="referencedColumn">45a3f404-ad0f-11e2-b309-080027bcf912</link>
|
761 |
|
<value type="string" key="name"></value>
|
762 |
|
<link type="object" struct-name="GrtObject" key="owner">6b54505e-ad0f-11e2-b309-080027bcf912</link>
|
763 |
|
</value>
|
764 |
|
</value>
|
765 |
|
<value type="string" key="indexKind"></value>
|
766 |
|
<value type="int" key="keyBlockSize">0</value>
|
767 |
|
<value type="string" key="withParser"></value>
|
768 |
|
<value type="string" key="comment"></value>
|
769 |
|
<value type="int" key="deferability">0</value>
|
770 |
|
<value type="string" key="indexType">UNIQUE</value>
|
771 |
|
<value type="int" key="isPrimary">0</value>
|
772 |
|
<value type="string" key="name">collection_unique</value>
|
773 |
|
<value type="int" key="unique">1</value>
|
774 |
|
<value type="string" key="oldName">collection_unique</value>
|
775 |
|
<link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
|
776 |
|
</value>
|
777 |
|
<value type="object" struct-name="db.mysql.Index" id="81937b1c-ad12-11e2-b309-080027bcf912" struct-checksum="0x309b847a">
|
778 |
|
<value _ptr_="0xaa02c18" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
779 |
|
<value type="object" struct-name="db.mysql.IndexColumn" id="8194729c-ad12-11e2-b309-080027bcf912" struct-checksum="0x62630b3c">
|
780 |
|
<value type="int" key="columnLength">0</value>
|
781 |
|
<value type="string" key="comment"></value>
|
782 |
|
<value type="int" key="descend">0</value>
|
783 |
|
<link type="object" struct-name="db.Column" key="referencedColumn">be8dfbf6-a6e0-11e2-95e9-080027bcf912</link>
|
784 |
|
<value type="string" key="name"></value>
|
785 |
|
<link type="object" struct-name="GrtObject" key="owner">81937b1c-ad12-11e2-b309-080027bcf912</link>
|
786 |
|
</value>
|
787 |
|
</value>
|
788 |
|
<value type="string" key="indexKind"></value>
|
789 |
|
<value type="int" key="keyBlockSize">0</value>
|
790 |
|
<value type="string" key="withParser"></value>
|
791 |
|
<value type="string" key="comment"></value>
|
792 |
|
<value type="int" key="deferability">0</value>
|
793 |
|
<value type="string" key="indexType">INDEX</value>
|
794 |
|
<value type="int" key="isPrimary">0</value>
|
795 |
|
<value type="string" key="name">fk_collection_source1_idx</value>
|
796 |
|
<value type="int" key="unique">0</value>
|
797 |
|
<value type="string" key="oldName">fk_collection_source1_idx</value>
|
798 |
|
<link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
|
799 |
|
</value>
|
800 |
|
<value type="object" struct-name="db.mysql.Index" id="8ed70288-ad14-11e2-9617-080027bcf912" struct-checksum="0x309b847a">
|
801 |
|
<value _ptr_="0xaa03528" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
802 |
|
<value type="object" struct-name="db.mysql.IndexColumn" id="8ed7a80a-ad14-11e2-9617-080027bcf912" struct-checksum="0x62630b3c">
|
803 |
|
<value type="int" key="columnLength">0</value>
|
804 |
|
<value type="string" key="comment"></value>
|
805 |
|
<value type="int" key="descend">0</value>
|
806 |
|
<link type="object" struct-name="db.Column" key="referencedColumn">be8dfbf6-a6e0-11e2-95e9-080027bcf912</link>
|
807 |
|
<value type="string" key="name"></value>
|
808 |
|
<link type="object" struct-name="GrtObject" key="owner">8ed70288-ad14-11e2-9617-080027bcf912</link>
|
809 |
|
</value>
|
810 |
|
</value>
|
811 |
|
<value type="string" key="indexKind"></value>
|
812 |
|
<value type="int" key="keyBlockSize">0</value>
|
813 |
|
<value type="string" key="withParser"></value>
|
814 |
|
<value type="string" key="comment"></value>
|
815 |
|
<value type="int" key="deferability">0</value>
|
816 |
|
<value type="string" key="indexType">PRIMARY</value>
|
817 |
|
<value type="int" key="isPrimary">1</value>
|
818 |
|
<value type="string" key="name">PRIMARY</value>
|
819 |
|
<value type="int" key="unique">0</value>
|
820 |
|
<value type="string" key="oldName">PRIMARY</value>
|
821 |
|
<link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
|
822 |
|
</value>
|
823 |
|
</value>
|
824 |
|
<value type="string" key="maxRows"></value>
|
825 |
|
<value type="string" key="mergeInsert"></value>
|
826 |
|
<value type="string" key="mergeUnion"></value>
|
827 |
|
<value type="string" key="minRows"></value>
|
828 |
|
<value type="string" key="nextAutoInc"></value>
|
829 |
|
<value type="string" key="packKeys"></value>
|
830 |
|
<value type="int" key="partitionCount">0</value>
|
831 |
|
<value _ptr_="0xaa00c90" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
|
832 |
|
<value type="string" key="partitionExpression"></value>
|
833 |
|
<value type="string" key="partitionType"></value>
|
834 |
|
<value type="string" key="password"></value>
|
835 |
|
<link type="object" struct-name="db.mysql.Index" key="primaryKey">8ed70288-ad14-11e2-9617-080027bcf912</link>
|
836 |
|
<value type="string" key="raidChunkSize"></value>
|
837 |
|
<value type="string" key="raidChunks"></value>
|
838 |
|
<value type="string" key="raidType"></value>
|
839 |
|
<value type="string" key="rowFormat"></value>
|
840 |
|
<value type="int" key="subpartitionCount">0</value>
|
841 |
|
<value type="string" key="subpartitionExpression"></value>
|
842 |
|
<value type="string" key="subpartitionType"></value>
|
843 |
|
<value type="string" key="tableDataDir"></value>
|
844 |
|
<value type="string" key="tableEngine">InnoDB</value>
|
845 |
|
<value type="string" key="tableIndexDir"></value>
|
846 |
|
<value _ptr_="0xaa00c30" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
|
847 |
|
<value type="int" key="isStub">0</value>
|
848 |
|
<value type="int" key="isSystem">0</value>
|
849 |
|
<value type="int" key="isTemporary">0</value>
|
850 |
|
<value type="string" key="temporaryScope"></value>
|
851 |
|
<value type="int" key="commentedOut">0</value>
|
852 |
|
<value type="string" key="createDate">2013-04-16 14:58</value>
|
853 |
|
<value _ptr_="0xa9f16f8" type="dict" key="customData"/>
|
854 |
|
<value type="string" key="lastChangeDate">2013-04-24 14:34</value>
|
855 |
|
<value type="int" key="modelOnly">0</value>
|
856 |
|
<value type="string" key="name">collection</value>
|
857 |
|
<link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
|
858 |
|
<value type="string" key="temp_sql"></value>
|
859 |
|
<value type="string" key="comment">"the collection within the institution where a specimen is held" ("Brad Boyle":https://projects.nceas.ucsb.edu/nceas/attachments/download/621/vegbien_identifier_examples.xlsx#terms/collectionCode)</value>
|
860 |
|
<value type="string" key="oldName">collection</value>
|
861 |
|
</value>
|
862 |
|
<value type="object" struct-name="db.mysql.Table" id="687f12b8-a780-11e2-afd5-080027bcf912" struct-checksum="0x1a403946">
|
863 |
|
<value type="string" key="avgRowLength"></value>
|
864 |
|
<value type="int" key="checksum">0</value>
|
865 |
|
<value _ptr_="0xaa03b58" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
|
866 |
|
<value type="object" struct-name="db.mysql.Column" id="687f1542-a780-11e2-afd5-080027bcf912" struct-checksum="0x783b5183">
|
867 |
|
<value type="int" key="autoIncrement">0</value>
|
868 |
|
<value type="string" key="characterSetName"></value>
|
869 |
|
<value _ptr_="0xaa04560" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
870 |
|
<value type="string" key="collationName"></value>
|
871 |
|
<value type="string" key="datatypeExplicitParams"></value>
|
872 |
|
<value type="string" key="defaultValue"></value>
|
873 |
|
<value type="int" key="defaultValueIsNull">0</value>
|
874 |
|
<value _ptr_="0xaa04888" type="list" content-type="string" key="flags"/>
|
875 |
|
<value type="int" key="isNotNull">1</value>
|
876 |
|
<value type="int" key="length">767</value>
|
877 |
|
<value type="int" key="precision">-1</value>
|
878 |
|
<value type="int" key="scale">-1</value>
|
879 |
|
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
|
880 |
|
<value type="string" key="comment"></value>
|
881 |
|
<value type="string" key="name">id</value>
|
882 |
|
<value type="string" key="oldName">id</value>
|
883 |
|
<link type="object" struct-name="GrtObject" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link>
|
884 |
|
</value>
|
885 |
|
<value type="object" struct-name="db.mysql.Column" id="687f1718-a780-11e2-afd5-080027bcf912" struct-checksum="0x783b5183">
|
886 |
|
<value type="int" key="autoIncrement">0</value>
|
887 |
|
<value type="string" key="characterSetName"></value>
|
888 |
|
<value _ptr_="0xaa049d8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
889 |
|
<value type="string" key="collationName"></value>
|
890 |
|
<value type="string" key="datatypeExplicitParams"></value>
|
891 |
|
<value type="string" key="defaultValue"></value>
|
892 |
|
<value type="int" key="defaultValueIsNull">0</value>
|
893 |
|
<value _ptr_="0xaa04d00" type="list" content-type="string" key="flags"/>
|
894 |
|
<value type="int" key="isNotNull">1</value>
|
895 |
|
<value type="int" key="length">767</value>
|
896 |
|
<value type="int" key="precision">-1</value>
|
897 |
|
<value type="int" key="scale">-1</value>
|
898 |
|
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
|
899 |
|
<value type="string" key="comment"></value>
|
900 |
|
<value type="string" key="name">unique_name</value>
|
901 |
|
<value type="string" key="oldName">unique_name</value>
|
902 |
|
<link type="object" struct-name="GrtObject" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link>
|
903 |
|
</value>
|
904 |
|
<value type="object" struct-name="db.mysql.Column" id="687f18b2-a780-11e2-afd5-080027bcf912" struct-checksum="0x783b5183">
|
905 |
|
<value type="int" key="autoIncrement">0</value>
|
906 |
|
<value type="string" key="characterSetName"></value>
|
907 |
|
<value _ptr_="0xaa04e50" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
908 |
|
<value type="string" key="collationName"></value>
|
909 |
|
<value type="string" key="datatypeExplicitParams"></value>
|
910 |
|
<value type="string" key="defaultValue"></value>
|
911 |
|
<value type="int" key="defaultValueIsNull">1</value>
|
912 |
|
<value _ptr_="0xaa05178" type="list" content-type="string" key="flags"/>
|
913 |
|
<value type="int" key="isNotNull">0</value>
|
914 |
|
<value type="int" key="length">767</value>
|
915 |
|
<value type="int" key="precision">-1</value>
|
916 |
|
<value type="int" key="scale">-1</value>
|
917 |
|
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
|
918 |
|
<value type="string" key="comment"></value>
|
919 |
|
<value type="string" key="name">formal_name</value>
|
920 |
|
<value type="string" key="oldName">formal_name</value>
|
921 |
|
<link type="object" struct-name="GrtObject" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link>
|
922 |
|
</value>
|
923 |
|
<value type="object" struct-name="db.mysql.Column" id="687f1a6a-a780-11e2-afd5-080027bcf912" struct-checksum="0x783b5183">
|
924 |
|
<value type="int" key="autoIncrement">0</value>
|
925 |
|
<value type="string" key="characterSetName"></value>
|
926 |
|
<value _ptr_="0xaa052c8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
927 |
|
<value type="string" key="collationName"></value>
|
928 |
|
<value type="string" key="datatypeExplicitParams"></value>
|
929 |
|
<value type="string" key="defaultValue"></value>
|
930 |
|
<value type="int" key="defaultValueIsNull">1</value>
|
931 |
|
<value _ptr_="0xaa055f0" type="list" content-type="string" key="flags"/>
|
932 |
|
<value type="int" key="isNotNull">0</value>
|
933 |
|
<value type="int" key="length">767</value>
|
934 |
|
<value type="int" key="precision">-1</value>
|
935 |
|
<value type="int" key="scale">-1</value>
|
936 |
|
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
|
937 |
|
<value type="string" key="comment"></value>
|
938 |
|
<value type="string" key="name">taxon_name</value>
|
939 |
|
<value type="string" key="oldName">taxon_name</value>
|
940 |
|
<link type="object" struct-name="GrtObject" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link>
|
941 |
|
</value>
|
942 |
|
<value type="object" struct-name="db.mysql.Column" id="687f1c2c-a780-11e2-afd5-080027bcf912" struct-checksum="0x783b5183">
|
943 |
|
<value type="int" key="autoIncrement">0</value>
|
944 |
|
<value type="string" key="characterSetName"></value>
|
945 |
|
<value _ptr_="0xaa05740" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
946 |
|
<value type="string" key="collationName"></value>
|
947 |
|
<value type="string" key="datatypeExplicitParams"></value>
|
948 |
|
<value type="string" key="defaultValue"></value>
|
949 |
|
<value type="int" key="defaultValueIsNull">1</value>
|
950 |
|
<value _ptr_="0xaa05a68" type="list" content-type="string" key="flags"/>
|
951 |
|
<value type="int" key="isNotNull">0</value>
|
952 |
|
<value type="int" key="length">767</value>
|
953 |
|
<value type="int" key="precision">-1</value>
|
954 |
|
<value type="int" key="scale">-1</value>
|
955 |
|
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
|
956 |
|
<value type="string" key="comment"></value>
|
957 |
|
<value type="string" key="name">author</value>
|
958 |
|
<value type="string" key="oldName">author</value>
|
959 |
|
<link type="object" struct-name="GrtObject" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link>
|
960 |
|
</value>
|
961 |
|
<value type="object" struct-name="db.mysql.Column" id="29c29602-a7a4-11e2-8ba6-080027bcf912" struct-checksum="0x783b5183">
|
962 |
|
<value type="int" key="autoIncrement">0</value>
|
963 |
|
<value type="string" key="characterSetName"></value>
|
964 |
|
<value _ptr_="0xaa05bb8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
965 |
|
<value type="string" key="collationName"></value>
|
966 |
|
<value type="string" key="datatypeExplicitParams"></value>
|
967 |
|
<value type="string" key="defaultValue"></value>
|
968 |
|
<value type="int" key="defaultValueIsNull">1</value>
|
969 |
|
<value _ptr_="0xaa05ee0" type="list" content-type="string" key="flags"/>
|
970 |
|
<value type="int" key="isNotNull">0</value>
|
971 |
|
<value type="int" key="length">767</value>
|
972 |
|
<value type="int" key="precision">-1</value>
|
973 |
|
<value type="int" key="scale">-1</value>
|
974 |
|
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
|
975 |
|
<value type="string" key="comment"></value>
|
976 |
|
<value type="string" key="name">common_name</value>
|
977 |
|
<value type="string" key="oldName">common_name</value>
|
978 |
|
<link type="object" struct-name="GrtObject" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link>
|
979 |
|
</value>
|
980 |
|
<value type="object" struct-name="db.mysql.Column" id="687f1dda-a780-11e2-afd5-080027bcf912" struct-checksum="0x783b5183">
|
981 |
|
<value type="int" key="autoIncrement">0</value>
|
982 |
|
<value type="string" key="characterSetName"></value>
|
983 |
|
<value _ptr_="0xaa06030" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
984 |
|
<value type="string" key="collationName"></value>
|
985 |
|
<value type="string" key="datatypeExplicitParams"></value>
|
986 |
|
<value type="string" key="defaultValue"></value>
|
987 |
|
<value type="int" key="defaultValueIsNull">1</value>
|
988 |
|
<value _ptr_="0xaa06358" type="list" content-type="string" key="flags"/>
|
989 |
|
<value type="int" key="isNotNull">0</value>
|
990 |
|
<value type="int" key="length">767</value>
|
991 |
|
<value type="int" key="precision">-1</value>
|
992 |
|
<value type="int" key="scale">-1</value>
|
993 |
|
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
|
994 |
|
<value type="string" key="comment"></value>
|
995 |
|
<value type="string" key="name">rank</value>
|
996 |
|
<value type="string" key="oldName">rank</value>
|
997 |
|
<link type="object" struct-name="GrtObject" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link>
|
998 |
|
</value>
|
999 |
|
<value type="object" struct-name="db.mysql.Column" id="11b489bc-f97f-11e2-8a2e-080027bcf912" struct-checksum="0x783b5183">
|
1000 |
|
<value type="int" key="autoIncrement">0</value>
|
1001 |
|
<value type="string" key="characterSetName"></value>
|
1002 |
|
<value _ptr_="0xaa064a8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
1003 |
|
<value type="string" key="collationName"></value>
|
1004 |
|
<value type="string" key="datatypeExplicitParams"></value>
|
1005 |
|
<value type="string" key="defaultValue"></value>
|
1006 |
|
<value type="int" key="defaultValueIsNull">1</value>
|
1007 |
|
<value _ptr_="0xaa067d0" type="list" content-type="string" key="flags"/>
|
1008 |
|
<value type="int" key="isNotNull">0</value>
|
1009 |
|
<value type="int" key="length">767</value>
|
1010 |
|
<value type="int" key="precision">-1</value>
|
1011 |
|
<value type="int" key="scale">-1</value>
|
1012 |
|
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
|
1013 |
|
<value type="string" key="comment"></value>
|
1014 |
|
<value type="string" key="name">taxon_path</value>
|
1015 |
|
<value type="string" key="oldName">taxon_path</value>
|
1016 |
|
<link type="object" struct-name="GrtObject" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link>
|
1017 |
|
</value>
|
1018 |
|
</value>
|
1019 |
|
<value type="string" key="connectionString"></value>
|
1020 |
|
<value type="string" key="defaultCharacterSetName">utf8</value>
|
1021 |
|
<value type="string" key="defaultCollationName">utf8_bin</value>
|
1022 |
|
<value type="int" key="delayKeyWrite">0</value>
|
1023 |
|
<value _ptr_="0xaa04300" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
|
1024 |
|
<value type="object" struct-name="db.mysql.ForeignKey" id="687f25a0-a780-11e2-afd5-080027bcf912" struct-checksum="0x70a8fc40">
|
1025 |
|
<link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
|
1026 |
|
<value _ptr_="0xaa06948" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
1027 |
|
<link type="object">687f1542-a780-11e2-afd5-080027bcf912</link>
|
1028 |
|
</value>
|
1029 |
|
<value type="int" key="deferability">0</value>
|
1030 |
|
<value type="string" key="deleteRule">CASCADE</value>
|
1031 |
|
<link type="object" struct-name="db.Index" key="index">687f1f92-a780-11e2-afd5-080027bcf912</link>
|
1032 |
|
<value type="int" key="mandatory">0</value>
|
1033 |
|
<value type="int" key="many">0</value>
|
1034 |
|
<value type="int" key="modelOnly">0</value>
|
1035 |
|
<link type="object" struct-name="db.Table" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link>
|
1036 |
|
<value _ptr_="0xaa06c38" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
1037 |
|
<link type="object">be8cd7b2-a6e0-11e2-95e9-080027bcf912</link>
|
1038 |
|
</value>
|
1039 |
|
<value type="int" key="referencedMandatory">1</value>
|
1040 |
|
<value type="string" key="updateRule">CASCADE</value>
|
1041 |
|
<value type="string" key="comment"></value>
|
1042 |
|
<value type="string" key="name">fk_taxon_record10</value>
|
1043 |
|
<value type="string" key="oldName">fk_taxon_record10</value>
|
1044 |
|
</value>
|
1045 |
|
<value type="object" struct-name="db.mysql.ForeignKey" id="687f26f4-a780-11e2-afd5-080027bcf912" struct-checksum="0x70a8fc40">
|
1046 |
|
<link type="object" struct-name="db.mysql.Table" key="referencedTable">4c3ffc96-a741-11e2-9fbf-080027bcf912</link>
|
1047 |
|
<value _ptr_="0xaa06ca8" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
1048 |
|
<link type="object">687f1718-a780-11e2-afd5-080027bcf912</link>
|
1049 |
|
</value>
|
1050 |
|
<value type="int" key="deferability">0</value>
|
1051 |
|
<value type="string" key="deleteRule">CASCADE</value>
|
1052 |
|
<link type="object" struct-name="db.Index" key="index">687f22b2-a780-11e2-afd5-080027bcf912</link>
|
1053 |
|
<value type="int" key="mandatory">1</value>
|
1054 |
|
<value type="int" key="many">1</value>
|
1055 |
|
<value type="int" key="modelOnly">0</value>
|
1056 |
|
<link type="object" struct-name="db.Table" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link>
|
1057 |
|
<value _ptr_="0xaa06f98" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
1058 |
|
<link type="object">4c40001a-a741-11e2-9fbf-080027bcf912</link>
|
1059 |
|
</value>
|
1060 |
|
<value type="int" key="referencedMandatory">1</value>
|
1061 |
|
<value type="string" key="updateRule">CASCADE</value>
|
1062 |
|
<value type="string" key="comment"></value>
|
1063 |
|
<value type="string" key="name">fk_taxon_concept_taxon_string10</value>
|
1064 |
|
<value type="string" key="oldName">fk_taxon_concept_taxon_string10</value>
|
1065 |
|
</value>
|
1066 |
|
<value type="object" struct-name="db.mysql.ForeignKey" id="11b487b4-f97f-11e2-8a2e-080027bcf912" struct-checksum="0x70a8fc40">
|
1067 |
|
<link type="object" struct-name="db.mysql.Table" key="referencedTable">687f2f28-a780-11e2-afd5-080027bcf912</link>
|
1068 |
|
<value _ptr_="0xaa07008" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
1069 |
|
<link type="object">11b489bc-f97f-11e2-8a2e-080027bcf912</link>
|
1070 |
|
</value>
|
1071 |
|
<value type="int" key="deferability">0</value>
|
1072 |
|
<value type="string" key="deleteRule">CASCADE</value>
|
1073 |
|
<link type="object" struct-name="db.Index" key="index">11b49e5c-f97f-11e2-8a2e-080027bcf912</link>
|
1074 |
|
<value type="int" key="mandatory">1</value>
|
1075 |
|
<value type="int" key="many">1</value>
|
1076 |
|
<value type="int" key="modelOnly">0</value>
|
1077 |
|
<link type="object" struct-name="db.Table" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link>
|
1078 |
|
<value _ptr_="0xaa072f8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
1079 |
|
<link type="object">687f31c6-a780-11e2-afd5-080027bcf912</link>
|
1080 |
|
</value>
|
1081 |
|
<value type="int" key="referencedMandatory">0</value>
|
1082 |
|
<value type="string" key="updateRule">CASCADE</value>
|
1083 |
|
<value type="string" key="comment"></value>
|
1084 |
|
<value type="string" key="name">fk_taxon_name_taxon_path1</value>
|
1085 |
|
<value type="string" key="oldName">fk_taxon_name_taxon_path1</value>
|
1086 |
|
</value>
|
1087 |
|
</value>
|
1088 |
|
<value _ptr_="0xaa04330" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
|
1089 |
|
<value type="object" struct-name="db.mysql.Index" id="687f1f92-a780-11e2-afd5-080027bcf912" struct-checksum="0x309b847a">
|
1090 |
|
<value _ptr_="0xaa07368" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
1091 |
|
<value type="object" struct-name="db.mysql.IndexColumn" id="687f217c-a780-11e2-afd5-080027bcf912" struct-checksum="0x62630b3c">
|
1092 |
|
<value type="int" key="columnLength">0</value>
|
1093 |
|
<value type="string" key="comment"></value>
|
1094 |
|
<value type="int" key="descend">0</value>
|
1095 |
|
<link type="object" struct-name="db.Column" key="referencedColumn">687f1542-a780-11e2-afd5-080027bcf912</link>
|
1096 |
|
<value type="string" key="name"></value>
|
1097 |
|
<link type="object" struct-name="GrtObject" key="owner">687f1f92-a780-11e2-afd5-080027bcf912</link>
|
1098 |
|
</value>
|
1099 |
|
</value>
|
1100 |
|
<value type="string" key="indexKind"></value>
|
1101 |
|
<value type="int" key="keyBlockSize">0</value>
|
1102 |
|
<value type="string" key="withParser"></value>
|
1103 |
|
<value type="string" key="comment"></value>
|
1104 |
|
<value type="int" key="deferability">0</value>
|
1105 |
|
<value type="string" key="indexType">PRIMARY</value>
|
1106 |
|
<value type="int" key="isPrimary">1</value>
|
1107 |
|
<value type="string" key="name">PRIMARY</value>
|
1108 |
|
<value type="int" key="unique">0</value>
|
1109 |
|
<value type="string" key="oldName">PRIMARY</value>
|
1110 |
|
<link type="object" struct-name="GrtObject" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link>
|
1111 |
|
</value>
|
1112 |
|
<value type="object" struct-name="db.mysql.Index" id="687f22b2-a780-11e2-afd5-080027bcf912" struct-checksum="0x309b847a">
|
1113 |
|
<value _ptr_="0xaa076d0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
1114 |
|
<value type="object" struct-name="db.mysql.IndexColumn" id="687f246a-a780-11e2-afd5-080027bcf912" struct-checksum="0x62630b3c">
|
1115 |
|
<value type="int" key="columnLength">0</value>
|
1116 |
|
<value type="string" key="comment"></value>
|
1117 |
|
<value type="int" key="descend">0</value>
|
1118 |
|
<link type="object" struct-name="db.Column" key="referencedColumn">687f1718-a780-11e2-afd5-080027bcf912</link>
|
1119 |
|
<value type="string" key="name"></value>
|
1120 |
|
<link type="object" struct-name="GrtObject" key="owner">687f22b2-a780-11e2-afd5-080027bcf912</link>
|
1121 |
|
</value>
|
1122 |
|
</value>
|
1123 |
|
<value type="string" key="indexKind"></value>
|
1124 |
|
<value type="int" key="keyBlockSize">0</value>
|
1125 |
|
<value type="string" key="withParser"></value>
|
1126 |
|
<value type="string" key="comment"></value>
|
1127 |
|
<value type="int" key="deferability">0</value>
|
1128 |
|
<value type="string" key="indexType">INDEX</value>
|
1129 |
|
<value type="int" key="isPrimary">0</value>
|
1130 |
|
<value type="string" key="name">fk_taxon_concept_taxon_string10_idx</value>
|
1131 |
|
<value type="int" key="unique">0</value>
|
1132 |
|
<value type="string" key="oldName">fk_taxon_concept_taxon_string10_idx</value>
|
1133 |
|
<link type="object" struct-name="GrtObject" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link>
|
1134 |
|
</value>
|
1135 |
|
<value type="object" struct-name="db.mysql.Index" id="11b49e5c-f97f-11e2-8a2e-080027bcf912" struct-checksum="0x309b847a">
|
1136 |
|
<value _ptr_="0xaa07d00" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
1137 |
|
<value type="object" struct-name="db.mysql.IndexColumn" id="11b4a000-f97f-11e2-8a2e-080027bcf912" struct-checksum="0x62630b3c">
|
1138 |
|
<value type="int" key="columnLength">0</value>
|
1139 |
|
<value type="string" key="comment"></value>
|
1140 |
|
<value type="int" key="descend">0</value>
|
1141 |
|
<link type="object" struct-name="db.Column" key="referencedColumn">11b489bc-f97f-11e2-8a2e-080027bcf912</link>
|
1142 |
|
<value type="string" key="name"></value>
|
1143 |
|
<link type="object" struct-name="GrtObject" key="owner">11b49e5c-f97f-11e2-8a2e-080027bcf912</link>
|
1144 |
|
</value>
|
1145 |
|
</value>
|
1146 |
|
<value type="string" key="indexKind"></value>
|
1147 |
|
<value type="int" key="keyBlockSize">0</value>
|
1148 |
|
<value type="string" key="withParser"></value>
|
1149 |
|
<value type="string" key="comment"></value>
|
1150 |
|
<value type="int" key="deferability">0</value>
|
1151 |
|
<value type="string" key="indexType">INDEX</value>
|
1152 |
|
<value type="int" key="isPrimary">0</value>
|
1153 |
|
<value type="string" key="name">fk_taxon_name_taxon_path1_idx</value>
|
1154 |
|
<value type="int" key="unique">0</value>
|
1155 |
|
<value type="string" key="oldName">fk_taxon_name_taxon_path1_idx</value>
|
1156 |
|
<link type="object" struct-name="GrtObject" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link>
|
1157 |
|
</value>
|
1158 |
|
</value>
|
1159 |
|
<value type="string" key="maxRows"></value>
|
1160 |
|
<value type="string" key="mergeInsert"></value>
|
1161 |
|
<value type="string" key="mergeUnion"></value>
|
1162 |
|
<value type="string" key="minRows"></value>
|
1163 |
|
<value type="string" key="nextAutoInc"></value>
|
1164 |
|
<value type="string" key="packKeys"></value>
|
1165 |
|
<value type="int" key="partitionCount">0</value>
|
1166 |
|
<value _ptr_="0xaa043c0" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
|
1167 |
|
<value type="string" key="partitionExpression"></value>
|
1168 |
|
<value type="string" key="partitionType"></value>
|
1169 |
|
<value type="string" key="password"></value>
|
1170 |
|
<link type="object" struct-name="db.mysql.Index" key="primaryKey">687f1f92-a780-11e2-afd5-080027bcf912</link>
|
1171 |
|
<value type="string" key="raidChunkSize"></value>
|
1172 |
|
<value type="string" key="raidChunks"></value>
|
1173 |
|
<value type="string" key="raidType"></value>
|
1174 |
|
<value type="string" key="rowFormat"></value>
|
1175 |
|
<value type="int" key="subpartitionCount">0</value>
|
1176 |
|
<value type="string" key="subpartitionExpression"></value>
|
1177 |
|
<value type="string" key="subpartitionType"></value>
|
1178 |
|
<value type="string" key="tableDataDir"></value>
|
1179 |
|
<value type="string" key="tableEngine">InnoDB</value>
|
1180 |
|
<value type="string" key="tableIndexDir"></value>
|
1181 |
|
<value _ptr_="0xaa04360" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
|
1182 |
|
<value type="int" key="isStub">0</value>
|
1183 |
|
<value type="int" key="isSystem">0</value>
|
1184 |
|
<value type="int" key="isTemporary">0</value>
|
1185 |
|
<value type="string" key="temporaryScope"></value>
|
1186 |
|
<value type="int" key="commentedOut">0</value>
|
1187 |
|
<value type="string" key="createDate">2013-04-17 10:01</value>
|
1188 |
|
<value _ptr_="0xa9f3e98" type="dict" key="customData"/>
|
1189 |
|
<value type="string" key="lastChangeDate">2013-07-30 18:20</value>
|
1190 |
|
<value type="int" key="modelOnly">0</value>
|
1191 |
|
<value type="string" key="name">taxon_name</value>
|
1192 |
|
<link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
|
1193 |
|
<value type="string" key="temp_sql"></value>
|
1194 |
|
<value type="string" key="comment"></value>
|
1195 |
|
<value type="string" key="oldName">taxon_name</value>
|
1196 |
|
</value>
|
1197 |
|
<value type="object" struct-name="db.mysql.Table" id="be8cd56e-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x1a403946">
|
1198 |
|
<value type="string" key="avgRowLength"></value>
|
1199 |
|
<value type="int" key="checksum">0</value>
|
1200 |
|
<value _ptr_="0xaa08330" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
|
1201 |
|
<value type="object" struct-name="db.mysql.Column" id="be8cd7b2-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183">
|
1202 |
|
<value type="int" key="autoIncrement">0</value>
|
1203 |
|
<value type="string" key="characterSetName"></value>
|
1204 |
|
<value _ptr_="0xaa08d38" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
1205 |
|
<value type="string" key="collationName"></value>
|
1206 |
|
<value type="string" key="datatypeExplicitParams"></value>
|
1207 |
|
<value type="string" key="defaultValue"></value>
|
1208 |
|
<value type="int" key="defaultValueIsNull">0</value>
|
1209 |
|
<value _ptr_="0xaa09060" type="list" content-type="string" key="flags"/>
|
1210 |
|
<value type="int" key="isNotNull">1</value>
|
1211 |
|
<value type="int" key="length">767</value>
|
1212 |
|
<value type="int" key="precision">-1</value>
|
1213 |
|
<value type="int" key="scale">-1</value>
|
1214 |
|
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
|
1215 |
|
<value type="string" key="comment"></value>
|
1216 |
|
<value type="string" key="name">id</value>
|
1217 |
|
<value type="string" key="oldName">id</value>
|
1218 |
|
<link type="object" struct-name="GrtObject" key="owner">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
|
1219 |
|
</value>
|
1220 |
|
<value type="object" struct-name="db.mysql.Column" id="be8cd956-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183">
|
1221 |
|
<value type="int" key="autoIncrement">0</value>
|
1222 |
|
<value type="string" key="characterSetName"></value>
|
1223 |
|
<value _ptr_="0xaa091b0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
1224 |
|
<value type="string" key="collationName"></value>
|
1225 |
|
<value type="string" key="datatypeExplicitParams"></value>
|
1226 |
|
<value type="string" key="defaultValue"></value>
|
1227 |
|
<value type="int" key="defaultValueIsNull">0</value>
|
1228 |
|
<value _ptr_="0xaa094d8" type="list" content-type="string" key="flags"/>
|
1229 |
|
<value type="int" key="isNotNull">1</value>
|
1230 |
|
<value type="int" key="length">767</value>
|
1231 |
|
<value type="int" key="precision">-1</value>
|
1232 |
|
<value type="int" key="scale">-1</value>
|
1233 |
|
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
|
1234 |
|
<value type="string" key="comment"></value>
|
1235 |
|
<value type="string" key="name">source</value>
|
1236 |
|
<value type="string" key="oldName">source</value>
|
1237 |
|
<link type="object" struct-name="GrtObject" key="owner">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
|
1238 |
|
</value>
|
1239 |
|
<value type="object" struct-name="db.mysql.Column" id="f9d963a4-2326-11e3-a5a2-080027bcf912" struct-checksum="0x783b5183">
|
1240 |
|
<value type="int" key="autoIncrement">0</value>
|
1241 |
|
<value type="string" key="characterSetName"></value>
|
1242 |
|
<value _ptr_="0xab0e358" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
1243 |
|
<value type="string" key="collationName"></value>
|
1244 |
|
<value type="string" key="datatypeExplicitParams"></value>
|
1245 |
|
<value type="string" key="defaultValue"></value>
|
1246 |
|
<value type="int" key="defaultValueIsNull">0</value>
|
1247 |
|
<value _ptr_="0xa9ebd18" type="list" content-type="string" key="flags"/>
|
1248 |
|
<value type="int" key="isNotNull">1</value>
|
1249 |
|
<value type="int" key="length">767</value>
|
1250 |
|
<value type="int" key="precision">-1</value>
|
1251 |
|
<value type="int" key="scale">-1</value>
|
1252 |
|
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
|
1253 |
|
<value type="string" key="comment">the portion of the source record that this traceable refers to. denormalized source data often contains data for many VegCore tables in the same row, and the traceables for each of these table entries must be distinguished *from each other* since they share the same source. this is usually just the VegCore table name, sometimes with a distinguishing prefix (e.g. collector.party/identified_by.party; current_observation.taxon_determination/orig_observation.taxon_determination).</value>
|
1254 |
|
<value type="string" key="name">table_fragment</value>
|
1255 |
|
<value type="string" key="oldName">table_fragment</value>
|
1256 |
|
<link type="object" struct-name="GrtObject" key="owner">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
|
1257 |
|
</value>
|
1258 |
|
</value>
|
1259 |
|
<value type="string" key="connectionString"></value>
|
1260 |
|
<value type="string" key="defaultCharacterSetName">utf8</value>
|
1261 |
|
<value type="string" key="defaultCollationName">utf8_bin</value>
|
1262 |
|
<value type="int" key="delayKeyWrite">0</value>
|
1263 |
|
<value _ptr_="0xaa08ad8" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
|
1264 |
|
<value type="object" struct-name="db.mysql.ForeignKey" id="be8ce0b8-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x70a8fc40">
|
1265 |
|
<link type="object" struct-name="db.mysql.Table" key="referencedTable">afc401d4-1df9-11e3-bbb6-080027bcf912</link>
|
1266 |
|
<value _ptr_="0xaa09650" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
1267 |
|
<link type="object">be8cd956-a6e0-11e2-95e9-080027bcf912</link>
|
1268 |
|
</value>
|
1269 |
|
<value type="int" key="deferability">0</value>
|
1270 |
|
<value type="string" key="deleteRule">CASCADE</value>
|
1271 |
|
<value type="int" key="mandatory">1</value>
|
1272 |
|
<value type="int" key="many">1</value>
|
1273 |
|
<value type="int" key="modelOnly">0</value>
|
1274 |
|
<link type="object" struct-name="db.Table" key="owner">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
|
1275 |
|
<value _ptr_="0xaa09940" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
1276 |
|
<link type="object">afc4053a-1df9-11e3-bbb6-080027bcf912</link>
|
1277 |
|
</value>
|
1278 |
|
<value type="int" key="referencedMandatory">1</value>
|
1279 |
|
<value type="string" key="updateRule">CASCADE</value>
|
1280 |
|
<value type="string" key="comment"></value>
|
1281 |
|
<value type="string" key="name">fk_record_source1</value>
|
1282 |
|
<value type="string" key="oldName">fk_record_source1</value>
|
1283 |
|
</value>
|
1284 |
|
</value>
|
1285 |
|
<value _ptr_="0xaa08b08" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
|
1286 |
|
<value type="object" struct-name="db.mysql.Index" id="be8cdac8-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a">
|
1287 |
|
<value _ptr_="0xaa099b0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
1288 |
|
<value type="object" struct-name="db.mysql.IndexColumn" id="be8cdc94-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x62630b3c">
|
1289 |
|
<value type="int" key="columnLength">0</value>
|
1290 |
|
<value type="string" key="comment"></value>
|
1291 |
|
<value type="int" key="descend">0</value>
|
1292 |
|
<link type="object" struct-name="db.Column" key="referencedColumn">be8cd7b2-a6e0-11e2-95e9-080027bcf912</link>
|
1293 |
|
<value type="string" key="name"></value>
|
1294 |
|
<link type="object" struct-name="GrtObject" key="owner">be8cdac8-a6e0-11e2-95e9-080027bcf912</link>
|
1295 |
|
</value>
|
1296 |
|
</value>
|
1297 |
|
<value type="string" key="indexKind"></value>
|
1298 |
|
<value type="int" key="keyBlockSize">0</value>
|
1299 |
|
<value type="string" key="withParser"></value>
|
1300 |
|
<value type="string" key="comment"></value>
|
1301 |
|
<value type="int" key="deferability">0</value>
|
1302 |
|
<value type="string" key="indexType">PRIMARY</value>
|
1303 |
|
<value type="int" key="isPrimary">1</value>
|
1304 |
|
<value type="string" key="name">PRIMARY</value>
|
1305 |
|
<value type="int" key="unique">0</value>
|
1306 |
|
<value type="string" key="oldName">PRIMARY</value>
|
1307 |
|
<link type="object" struct-name="GrtObject" key="owner">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
|
1308 |
|
</value>
|
1309 |
|
<value type="object" struct-name="db.mysql.Index" id="fbf69d1e-a79d-11e2-a346-080027bcf912" struct-checksum="0x309b847a">
|
1310 |
|
<value _ptr_="0xaa09d18" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
1311 |
|
<value type="object" struct-name="db.mysql.IndexColumn" id="fecdc3c8-a79d-11e2-a346-080027bcf912" struct-checksum="0x62630b3c">
|
1312 |
|
<value type="int" key="columnLength">0</value>
|
1313 |
|
<value type="string" key="comment"></value>
|
1314 |
|
<value type="int" key="descend">0</value>
|
1315 |
|
<link type="object" struct-name="db.Column" key="referencedColumn">be8cd956-a6e0-11e2-95e9-080027bcf912</link>
|
1316 |
|
<value type="string" key="name"></value>
|
1317 |
|
<link type="object" struct-name="GrtObject" key="owner">fbf69d1e-a79d-11e2-a346-080027bcf912</link>
|
1318 |
|
</value>
|
1319 |
|
<value type="object" struct-name="db.mysql.IndexColumn" id="58de9676-2327-11e3-a5a2-080027bcf912" struct-checksum="0x62630b3c">
|
1320 |
|
<value type="int" key="columnLength">0</value>
|
1321 |
|
<value type="string" key="comment"></value>
|
1322 |
|
<value type="int" key="descend">0</value>
|
1323 |
|
<link type="object" struct-name="db.Column" key="referencedColumn">f9d963a4-2326-11e3-a5a2-080027bcf912</link>
|
1324 |
|
<value type="string" key="name"></value>
|
1325 |
|
<link type="object" struct-name="GrtObject" key="owner">fbf69d1e-a79d-11e2-a346-080027bcf912</link>
|
1326 |
|
</value>
|
1327 |
|
</value>
|
1328 |
|
<value type="string" key="indexKind"></value>
|
1329 |
|
<value type="int" key="keyBlockSize">0</value>
|
1330 |
|
<value type="string" key="withParser"></value>
|
1331 |
|
<value type="string" key="comment"></value>
|
1332 |
|
<value type="int" key="deferability">0</value>
|
1333 |
|
<value type="string" key="indexType">UNIQUE</value>
|
1334 |
|
<value type="int" key="isPrimary">0</value>
|
1335 |
|
<value type="string" key="name">traceable_unique</value>
|
1336 |
|
<value type="int" key="unique">1</value>
|
1337 |
|
<value type="string" key="oldName">traceable_unique</value>
|
1338 |
|
<link type="object" struct-name="GrtObject" key="owner">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
|
1339 |
|
</value>
|
1340 |
|
</value>
|
1341 |
|
<value type="string" key="maxRows"></value>
|
1342 |
|
<value type="string" key="mergeInsert"></value>
|
1343 |
|
<value type="string" key="mergeUnion"></value>
|
1344 |
|
<value type="string" key="minRows"></value>
|
1345 |
|
<value type="string" key="nextAutoInc"></value>
|
1346 |
|
<value type="string" key="packKeys"></value>
|
1347 |
|
<value type="int" key="partitionCount">0</value>
|
1348 |
|
<value _ptr_="0xaa08b98" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
|
1349 |
|
<value type="string" key="partitionExpression"></value>
|
1350 |
|
<value type="string" key="partitionType"></value>
|
1351 |
|
<value type="string" key="password"></value>
|
1352 |
|
<link type="object" struct-name="db.mysql.Index" key="primaryKey">be8cdac8-a6e0-11e2-95e9-080027bcf912</link>
|
1353 |
|
<value type="string" key="raidChunkSize"></value>
|
1354 |
|
<value type="string" key="raidChunks"></value>
|
1355 |
|
<value type="string" key="raidType"></value>
|
1356 |
|
<value type="string" key="rowFormat"></value>
|
1357 |
|
<value type="int" key="subpartitionCount">0</value>
|
1358 |
|
<value type="string" key="subpartitionExpression"></value>
|
1359 |
|
<value type="string" key="subpartitionType"></value>
|
1360 |
|
<value type="string" key="tableDataDir"></value>
|
1361 |
|
<value type="string" key="tableEngine">InnoDB</value>
|
1362 |
|
<value type="string" key="tableIndexDir"></value>
|
1363 |
|
<value _ptr_="0xaa08b38" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
|
1364 |
|
<value type="int" key="isStub">0</value>
|
1365 |
|
<value type="int" key="isSystem">0</value>
|
1366 |
|
<value type="int" key="isTemporary">0</value>
|
1367 |
|
<value type="string" key="temporaryScope"></value>
|
1368 |
|
<value type="int" key="commentedOut">0</value>
|
1369 |
|
<value type="string" key="createDate">2013-04-16 14:58</value>
|
1370 |
|
<value _ptr_="0xa2298b8" type="dict" key="customData"/>
|
1371 |
|
<value type="string" key="lastChangeDate">2013-09-21 18:56</value>
|
1372 |
|
<value type="int" key="modelOnly">0</value>
|
1373 |
|
<value type="string" key="name">traceable</value>
|
1374 |
|
<link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
|
1375 |
|
<value type="string" key="temp_sql"></value>
|
1376 |
|
<value type="string" key="comment">a row that can have associated source information</value>
|
1377 |
|
<value type="string" key="oldName">traceable</value>
|
1378 |
|
</value>
|
1379 |
|
<value type="object" struct-name="db.mysql.Table" id="be8e3ecc-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x1a403946">
|
1380 |
|
<value type="string" key="avgRowLength"></value>
|
1381 |
|
<value type="int" key="checksum">0</value>
|
1382 |
|
<value _ptr_="0xaa0a348" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
|
1383 |
|
<value type="object" struct-name="db.mysql.Column" id="be8e4142-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183">
|
1384 |
|
<value type="int" key="autoIncrement">0</value>
|
1385 |
|
<value type="string" key="characterSetName"></value>
|
1386 |
|
<value _ptr_="0xaa0ad50" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
1387 |
|
<value type="string" key="collationName"></value>
|
1388 |
|
<value type="string" key="datatypeExplicitParams"></value>
|
1389 |
|
<value type="string" key="defaultValue"></value>
|
1390 |
|
<value type="int" key="defaultValueIsNull">0</value>
|
1391 |
|
<value _ptr_="0xaa0b078" type="list" content-type="string" key="flags"/>
|
1392 |
|
<value type="int" key="isNotNull">1</value>
|
1393 |
|
<value type="int" key="length">767</value>
|
1394 |
|
<value type="int" key="precision">-1</value>
|
1395 |
|
<value type="int" key="scale">-1</value>
|
1396 |
|
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
|
1397 |
|
<value type="string" key="comment"></value>
|
1398 |
|
<value type="string" key="name">id</value>
|
1399 |
|
<value type="string" key="oldName">id</value>
|
schemas/VegCore/: moved ERD-related files to ERD/ subdir