Project

General

Profile

« Previous | Next » 

Revision 11041

schemas/VegCore/: moved ERD-related files to ERD/ subdir

View differences:

schemas/VegCore/VegCore.ERD.mwb.run
1
#!/bin/bash -e
2
# syncs VegCore.ERD.mwb's zip file contents
3
. "$(dirname "${BASH_SOURCE[0]}")"/../../lib/runscripts/util.run
4
.rel ../../lib/sh/archives.sh
5
.rel ../../lib/sh/local.sh
6
.rel ../../lib/sh/make.sh
7

  
8
if self_not_included; then
9

  
10
# to edit VegCore.ERD.mwb, you *must* use the Linux version of MySQL Workbench.
11
# the Mac version does not export the PDFs correctly: in the single-page PDF,
12
# the lines take very long to load; and in the printed PDF, the colors are wrong
13
# in Adobe Reader.
14
#
15
# unfortunately, you cannot switch back and forth between the two versions,
16
# because they render the lines with a different spacing, which makes the tables
17
# different sizes and misaligns the connector lines.
18
# it is especially unfortunate that the Mac version messes up the PDFs, because
19
# it uses a smaller line spacing and therefore smaller tables, which allows the
20
# tables to be spaced farther apart for better readability.
21

  
22
VegCore.my.sql/make()
23
{
24
	echo_func; set_make_vars
25
	database=VegCore create_db=1 mysqldump_local --skip-add-drop-table \
26
>"$target"
27
}
28

  
29
export_mysql()
30
{
31
	echo_func
32
	VegCore.my.sql/make
33
}
34

  
35
VegCore.pg.sql/make()
36
{
37
	echo_func; set_make_vars
38
	sql_ascii=1 my2pg <"${target%.pg.sql}.my.sql" >"$target"
39
}
40

  
41
export_postgres()
42
{
43
	echo_func
44
	VegCore.pg.sql/make
45
}
46

  
47
export_()
48
{
49
	echo_func
50
	(cd "$top_dir"; unzip_newer "$top_filename" document.mwb.xml)
51
	export_mysql
52
	export_postgres
53
}
54

  
55
import()
56
{
57
	echo_func
58
	(cd "$top_dir"; zip_newer "$top_filename" document.mwb.xml)
59
}
60

  
61
sync()
62
{
63
	echo_func
64
	export_
65
	import
66
}
67

  
68
all()
69
{
70
	echo_func
71
	sync
72
}
73

  
74
fi
75 0

  
schemas/VegCore/document.mwb.xml
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>
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff