Revision 10449
Added by Aaron Marcuse-Kubitza over 11 years ago
schemas/VegCore/document.mwb.xml | ||
---|---|---|
2 | 2 |
<data grt_format="2.0" document_type="MySQL Workbench Model" version="1.4.4"> |
3 | 3 |
<value type="object" struct-name="workbench.Document" id="DD51DD12-152C-46FD-90D9-84EB5F9F500F" struct-checksum="0x7131bf99"> |
4 | 4 |
<value type="object" struct-name="workbench.logical.Model" id="9FB30CD5-3D20-4492-935C-7986A48D7820" struct-checksum="0xf4220370" key="logicalModel"> |
5 |
<value _ptr_="0xbc6d1e0" type="list" content-type="object" content-struct-name="workbench.logical.Diagram" key="diagrams"/>
|
|
6 |
<value _ptr_="0xb4e84c0" type="dict" key="customData"/>
|
|
7 |
<value _ptr_="0xbc6d4c0" type="list" content-type="object" content-struct-name="model.Marker" key="markers"/>
|
|
8 |
<value _ptr_="0xb4e8518" type="dict" key="options"/>
|
|
5 |
<value _ptr_="0xb2bce90" type="list" content-type="object" content-struct-name="workbench.logical.Diagram" key="diagrams"/>
|
|
6 |
<value _ptr_="0xab44d80" type="dict" key="customData"/>
|
|
7 |
<value _ptr_="0xb2bd160" type="list" content-type="object" content-struct-name="model.Marker" key="markers"/>
|
|
8 |
<value _ptr_="0xab44dd8" type="dict" key="options"/>
|
|
9 | 9 |
<value type="string" key="name"></value> |
10 | 10 |
<link type="object" struct-name="GrtObject" key="owner">DD51DD12-152C-46FD-90D9-84EB5F9F500F</link> |
11 | 11 |
</value> |
12 |
<value _ptr_="0xb9eb168" type="list" content-type="object" content-struct-name="workbench.OverviewPanel" key="overviewPanels"/>
|
|
13 |
<value _ptr_="0xbc6d158" type="list" content-type="object" content-struct-name="workbench.physical.Model" key="physicalModels">
|
|
12 |
<value _ptr_="0xb2bbff0" type="list" content-type="object" content-struct-name="workbench.OverviewPanel" key="overviewPanels"/>
|
|
13 |
<value _ptr_="0xb2bce08" type="list" content-type="object" content-struct-name="workbench.physical.Model" key="physicalModels">
|
|
14 | 14 |
<value type="object" struct-name="workbench.physical.Model" id="257B05AA-CE39-49DE-9522-6B703F985F32" struct-checksum="0x5f896d18"> |
15 | 15 |
<value type="object" struct-name="db.mysql.Catalog" id="42266085-54CC-4441-8553-68BBE0286A05" struct-checksum="0x82ad3466" key="catalog"> |
16 |
<value _ptr_="0xbc6e2e8" type="list" content-type="object" content-struct-name="db.mysql.LogFileGroup" key="logFileGroups"/>
|
|
17 |
<value _ptr_="0xbc6e360" type="list" content-type="object" content-struct-name="db.mysql.Schema" key="schemata">
|
|
16 |
<value _ptr_="0xb2bdf88" type="list" content-type="object" content-struct-name="db.mysql.LogFileGroup" key="logFileGroups"/>
|
|
17 |
<value _ptr_="0xb2be000" type="list" content-type="object" content-struct-name="db.mysql.Schema" key="schemata">
|
|
18 | 18 |
<value type="object" struct-name="db.mysql.Schema" id="be8cb246-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x20b94c22"> |
19 |
<value _ptr_="0xbc6e580" type="list" content-type="object" content-struct-name="db.mysql.RoutineGroup" key="routineGroups"/>
|
|
20 |
<value _ptr_="0xbc6e968" type="list" content-type="object" content-struct-name="db.mysql.Routine" key="routines"/>
|
|
21 |
<value _ptr_="0xbc6e998" type="list" content-type="object" content-struct-name="db.mysql.Sequence" key="sequences"/>
|
|
22 |
<value _ptr_="0xbc6e9f0" type="list" content-type="object" content-struct-name="db.mysql.StructuredDatatype" key="structuredTypes"/>
|
|
23 |
<value _ptr_="0xbc6ea20" type="list" content-type="object" content-struct-name="db.mysql.Synonym" key="synonyms"/>
|
|
24 |
<value _ptr_="0xbc6ea50" type="list" content-type="object" content-struct-name="db.mysql.Table" key="tables">
|
|
19 |
<value _ptr_="0xb2be220" type="list" content-type="object" content-struct-name="db.mysql.RoutineGroup" key="routineGroups"/>
|
|
20 |
<value _ptr_="0xb2be608" type="list" content-type="object" content-struct-name="db.mysql.Routine" key="routines"/>
|
|
21 |
<value _ptr_="0xb2be638" type="list" content-type="object" content-struct-name="db.mysql.Sequence" key="sequences"/>
|
|
22 |
<value _ptr_="0xb2be690" type="list" content-type="object" content-struct-name="db.mysql.StructuredDatatype" key="structuredTypes"/>
|
|
23 |
<value _ptr_="0xb2be6c0" type="list" content-type="object" content-struct-name="db.mysql.Synonym" key="synonyms"/>
|
|
24 |
<value _ptr_="0xb2be6f0" type="list" content-type="object" content-struct-name="db.mysql.Table" key="tables">
|
|
25 | 25 |
<value type="object" struct-name="db.mysql.Table" id="be8fe70e-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x1a403946"> |
26 | 26 |
<value type="string" key="avgRowLength"></value> |
27 | 27 |
<value type="int" key="checksum">0</value> |
28 |
<value _ptr_="0xbc6ebc8" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
|
|
28 |
<value _ptr_="0xb2be868" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
|
|
29 | 29 |
<value type="object" struct-name="db.mysql.Column" id="be8fe97a-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183"> |
30 | 30 |
<value type="int" key="autoIncrement">0</value> |
31 | 31 |
<value type="string" key="characterSetName"></value> |
32 |
<value _ptr_="0xbc6f360" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
32 |
<value _ptr_="0xb2bf000" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
33 | 33 |
<value type="string" key="collationName"></value> |
34 | 34 |
<value type="string" key="datatypeExplicitParams"></value> |
35 | 35 |
<value type="string" key="defaultValue"></value> |
36 | 36 |
<value type="int" key="defaultValueIsNull">0</value> |
37 |
<value _ptr_="0xbc6f688" type="list" content-type="string" key="flags"/>
|
|
37 |
<value _ptr_="0xb2bf328" type="list" content-type="string" key="flags"/>
|
|
38 | 38 |
<value type="int" key="isNotNull">1</value> |
39 | 39 |
<value type="int" key="length">767</value> |
40 | 40 |
<value type="int" key="precision">-1</value> |
... | ... | |
48 | 48 |
<value type="object" struct-name="db.mysql.Column" id="c8868c00-a793-11e2-84c3-080027bcf912" struct-checksum="0x783b5183"> |
49 | 49 |
<value type="int" key="autoIncrement">0</value> |
50 | 50 |
<value type="string" key="characterSetName"></value> |
51 |
<value _ptr_="0xbc6f7d8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
51 |
<value _ptr_="0xb2bf478" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
52 | 52 |
<value type="string" key="collationName"></value> |
53 | 53 |
<value type="string" key="datatypeExplicitParams">('hstore')</value> |
54 | 54 |
<value type="string" key="defaultValue"></value> |
55 | 55 |
<value type="int" key="defaultValueIsNull">0</value> |
56 |
<value _ptr_="0xbc6fb00" type="list" content-type="string" key="flags"/>
|
|
56 |
<value _ptr_="0xb2bf7a0" type="list" content-type="string" key="flags"/>
|
|
57 | 57 |
<value type="int" key="isNotNull">0</value> |
58 | 58 |
<value type="int" key="length">-1</value> |
59 | 59 |
<value type="int" key="precision">-1</value> |
... | ... | |
69 | 69 |
<value type="string" key="defaultCharacterSetName">utf8</value> |
70 | 70 |
<value type="string" key="defaultCollationName">utf8_bin</value> |
71 | 71 |
<value type="int" key="delayKeyWrite">0</value> |
72 |
<value _ptr_="0xbc6f100" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
|
|
72 |
<value _ptr_="0xb2beda0" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
|
|
73 | 73 |
<value type="object" struct-name="db.mysql.ForeignKey" id="be8fee8e-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x70a8fc40"> |
74 | 74 |
<link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cd56e-a6e0-11e2-95e9-080027bcf912</link> |
75 |
<value _ptr_="0xbc6fc78" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
75 |
<value _ptr_="0xb2bf918" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
76 | 76 |
<link type="object">be8fe97a-a6e0-11e2-95e9-080027bcf912</link> |
77 | 77 |
</value> |
78 | 78 |
<value type="int" key="deferability">0</value> |
... | ... | |
82 | 82 |
<value type="int" key="many">0</value> |
83 | 83 |
<value type="int" key="modelOnly">0</value> |
84 | 84 |
<link type="object" struct-name="db.Table" key="owner">be8fe70e-a6e0-11e2-95e9-080027bcf912</link> |
85 |
<value _ptr_="0xbc6ff68" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
85 |
<value _ptr_="0xb2bfc08" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
86 | 86 |
<link type="object">be8cd7b2-a6e0-11e2-95e9-080027bcf912</link> |
87 | 87 |
</value> |
88 | 88 |
<value type="int" key="referencedMandatory">1</value> |
... | ... | |
92 | 92 |
<value type="string" key="oldName">fk_collection_source10</value> |
93 | 93 |
</value> |
94 | 94 |
</value> |
95 |
<value _ptr_="0xbc6f130" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
|
|
95 |
<value _ptr_="0xb2bedd0" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
|
|
96 | 96 |
<value type="object" struct-name="db.mysql.Index" id="be8feb50-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a"> |
97 |
<value _ptr_="0xbc6ffd8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
97 |
<value _ptr_="0xb2bfc78" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
98 | 98 |
<value type="object" struct-name="db.mysql.IndexColumn" id="c37e8388-ac44-11e2-820d-080027bcf912" struct-checksum="0x62630b3c"> |
99 | 99 |
<value type="int" key="columnLength">0</value> |
100 | 100 |
<value type="string" key="comment"></value> |
... | ... | |
124 | 124 |
<value type="string" key="nextAutoInc"></value> |
125 | 125 |
<value type="string" key="packKeys"></value> |
126 | 126 |
<value type="int" key="partitionCount">0</value> |
127 |
<value _ptr_="0xbc6f1c0" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
|
|
127 |
<value _ptr_="0xb2bee60" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
|
|
128 | 128 |
<value type="string" key="partitionExpression"></value> |
129 | 129 |
<value type="string" key="partitionType"></value> |
130 | 130 |
<value type="string" key="password"></value> |
... | ... | |
139 | 139 |
<value type="string" key="tableDataDir"></value> |
140 | 140 |
<value type="string" key="tableEngine">InnoDB</value> |
141 | 141 |
<value type="string" key="tableIndexDir"></value> |
142 |
<value _ptr_="0xbc6f160" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
|
|
142 |
<value _ptr_="0xb2bee00" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
|
|
143 | 143 |
<value type="int" key="isStub">0</value> |
144 | 144 |
<value type="int" key="isSystem">0</value> |
145 | 145 |
<value type="int" key="isTemporary">0</value> |
146 | 146 |
<value type="string" key="temporaryScope"></value> |
147 | 147 |
<value type="int" key="commentedOut">0</value> |
148 | 148 |
<value type="string" key="createDate">2013-04-16 14:58</value> |
149 |
<value _ptr_="0xb4ebdd0" type="dict" key="customData"/>
|
|
149 |
<value _ptr_="0xab48690" type="dict" key="customData"/>
|
|
150 | 150 |
<value type="string" key="lastChangeDate">2013-04-23 11:36</value> |
151 | 151 |
<value type="int" key="modelOnly">0</value> |
152 | 152 |
<value type="string" key="name">party</value> |
... | ... | |
158 | 158 |
<value type="object" struct-name="db.mysql.Table" id="be8ce932-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x1a403946"> |
159 | 159 |
<value type="string" key="avgRowLength"></value> |
160 | 160 |
<value type="int" key="checksum">0</value> |
161 |
<value _ptr_="0xbc70340" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
|
|
161 |
<value _ptr_="0xb2bffe0" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
|
|
162 | 162 |
<value type="object" struct-name="db.mysql.Column" id="be8cebb2-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183"> |
163 | 163 |
<value type="int" key="autoIncrement">0</value> |
164 | 164 |
<value type="string" key="characterSetName"></value> |
165 |
<value _ptr_="0xbc70d48" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
165 |
<value _ptr_="0xb2c09e8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
166 | 166 |
<value type="string" key="collationName"></value> |
167 | 167 |
<value type="string" key="datatypeExplicitParams"></value> |
168 | 168 |
<value type="string" key="defaultValue"></value> |
169 | 169 |
<value type="int" key="defaultValueIsNull">0</value> |
170 |
<value _ptr_="0xbc71070" type="list" content-type="string" key="flags"/>
|
|
170 |
<value _ptr_="0xb2c0d10" type="list" content-type="string" key="flags"/>
|
|
171 | 171 |
<value type="int" key="isNotNull">1</value> |
172 | 172 |
<value type="int" key="length">767</value> |
173 | 173 |
<value type="int" key="precision">-1</value> |
... | ... | |
181 | 181 |
<value type="object" struct-name="db.mysql.Column" id="be8ced88-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183"> |
182 | 182 |
<value type="int" key="autoIncrement">0</value> |
183 | 183 |
<value type="string" key="characterSetName"></value> |
184 |
<value _ptr_="0xbc711c0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
184 |
<value _ptr_="0xb2c0e60" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
185 | 185 |
<value type="string" key="collationName"></value> |
186 | 186 |
<value type="string" key="datatypeExplicitParams"></value> |
187 | 187 |
<value type="string" key="defaultValue"></value> |
188 | 188 |
<value type="int" key="defaultValueIsNull">0</value> |
189 |
<value _ptr_="0xbc714e8" type="list" content-type="string" key="flags"/>
|
|
189 |
<value _ptr_="0xb2c1188" type="list" content-type="string" key="flags"/>
|
|
190 | 190 |
<value type="int" key="isNotNull">1</value> |
191 | 191 |
<value type="int" key="length">767</value> |
192 | 192 |
<value type="int" key="precision">-1</value> |
... | ... | |
200 | 200 |
<value type="object" struct-name="db.mysql.Column" id="be8cef2c-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183"> |
201 | 201 |
<value type="int" key="autoIncrement">0</value> |
202 | 202 |
<value type="string" key="characterSetName"></value> |
203 |
<value _ptr_="0xbc71638" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
203 |
<value _ptr_="0xb2c12d8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
204 | 204 |
<value type="string" key="collationName"></value> |
205 | 205 |
<value type="string" key="datatypeExplicitParams"></value> |
206 | 206 |
<value type="string" key="defaultValue"></value> |
207 | 207 |
<value type="int" key="defaultValueIsNull">0</value> |
208 |
<value _ptr_="0xbc71960" type="list" content-type="string" key="flags"/>
|
|
208 |
<value _ptr_="0xb2c1600" type="list" content-type="string" key="flags"/>
|
|
209 | 209 |
<value type="int" key="isNotNull">1</value> |
210 | 210 |
<value type="int" key="length">767</value> |
211 | 211 |
<value type="int" key="precision">-1</value> |
... | ... | |
219 | 219 |
<value type="object" struct-name="db.mysql.Column" id="95e0feca-a793-11e2-84c3-080027bcf912" struct-checksum="0x783b5183"> |
220 | 220 |
<value type="int" key="autoIncrement">0</value> |
221 | 221 |
<value type="string" key="characterSetName"></value> |
222 |
<value _ptr_="0xbc71ab0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
222 |
<value _ptr_="0xb2c1750" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
223 | 223 |
<value type="string" key="collationName"></value> |
224 | 224 |
<value type="string" key="datatypeExplicitParams">('hstore')</value> |
225 | 225 |
<value type="string" key="defaultValue"></value> |
226 | 226 |
<value type="int" key="defaultValueIsNull">0</value> |
227 |
<value _ptr_="0xbc71dd8" type="list" content-type="string" key="flags"/>
|
|
227 |
<value _ptr_="0xb2c1a78" type="list" content-type="string" key="flags"/>
|
|
228 | 228 |
<value type="int" key="isNotNull">0</value> |
229 | 229 |
<value type="int" key="length">-1</value> |
230 | 230 |
<value type="int" key="precision">-1</value> |
... | ... | |
240 | 240 |
<value type="string" key="defaultCharacterSetName">utf8</value> |
241 | 241 |
<value type="string" key="defaultCollationName">utf8_bin</value> |
242 | 242 |
<value type="int" key="delayKeyWrite">0</value> |
243 |
<value _ptr_="0xbc70ae8" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
|
|
243 |
<value _ptr_="0xb2c0788" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
|
|
244 | 244 |
<value type="object" struct-name="db.mysql.ForeignKey" id="be8cf9fe-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x70a8fc40"> |
245 | 245 |
<link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cd56e-a6e0-11e2-95e9-080027bcf912</link> |
246 |
<value _ptr_="0xbc71f50" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
246 |
<value _ptr_="0xb2c1bf0" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
247 | 247 |
<link type="object">be8cebb2-a6e0-11e2-95e9-080027bcf912</link> |
248 | 248 |
</value> |
249 | 249 |
<value type="int" key="deferability">0</value> |
... | ... | |
253 | 253 |
<value type="int" key="many">0</value> |
254 | 254 |
<value type="int" key="modelOnly">0</value> |
255 | 255 |
<link type="object" struct-name="db.Table" key="owner">be8ce932-a6e0-11e2-95e9-080027bcf912</link> |
256 |
<value _ptr_="0xbc72240" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
256 |
<value _ptr_="0xb2c1ee0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
257 | 257 |
<link type="object">be8cd7b2-a6e0-11e2-95e9-080027bcf912</link> |
258 | 258 |
</value> |
259 | 259 |
<value type="int" key="referencedMandatory">1</value> |
... | ... | |
264 | 264 |
</value> |
265 | 265 |
<value type="object" struct-name="db.mysql.ForeignKey" id="be8cfb66-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x70a8fc40"> |
266 | 266 |
<link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cd56e-a6e0-11e2-95e9-080027bcf912</link> |
267 |
<value _ptr_="0xbc722b0" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
267 |
<value _ptr_="0xb2c1f50" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
268 | 268 |
<link type="object">be8ced88-a6e0-11e2-95e9-080027bcf912</link> |
269 | 269 |
</value> |
270 | 270 |
<value type="int" key="deferability">0</value> |
... | ... | |
274 | 274 |
<value type="int" key="many">0</value> |
275 | 275 |
<value type="int" key="modelOnly">0</value> |
276 | 276 |
<link type="object" struct-name="db.Table" key="owner">be8ce932-a6e0-11e2-95e9-080027bcf912</link> |
277 |
<value _ptr_="0xbc725a0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
277 |
<value _ptr_="0xb2c2240" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
278 | 278 |
<link type="object">be8cd7b2-a6e0-11e2-95e9-080027bcf912</link> |
279 | 279 |
</value> |
280 | 280 |
<value type="int" key="referencedMandatory">1</value> |
... | ... | |
285 | 285 |
</value> |
286 | 286 |
<value type="object" struct-name="db.mysql.ForeignKey" id="be8cfcb0-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x70a8fc40"> |
287 | 287 |
<link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cd56e-a6e0-11e2-95e9-080027bcf912</link> |
288 |
<value _ptr_="0xbc72610" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
288 |
<value _ptr_="0xb2c22b0" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
289 | 289 |
<link type="object">be8cef2c-a6e0-11e2-95e9-080027bcf912</link> |
290 | 290 |
</value> |
291 | 291 |
<value type="int" key="deferability">0</value> |
... | ... | |
295 | 295 |
<value type="int" key="many">0</value> |
296 | 296 |
<value type="int" key="modelOnly">0</value> |
297 | 297 |
<link type="object" struct-name="db.Table" key="owner">be8ce932-a6e0-11e2-95e9-080027bcf912</link> |
298 |
<value _ptr_="0xbc72900" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
298 |
<value _ptr_="0xb2c25a0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
299 | 299 |
<link type="object">be8cd7b2-a6e0-11e2-95e9-080027bcf912</link> |
300 | 300 |
</value> |
301 | 301 |
<value type="int" key="referencedMandatory">1</value> |
... | ... | |
305 | 305 |
<value type="string" key="oldName">fk_relationship_related_record</value> |
306 | 306 |
</value> |
307 | 307 |
</value> |
308 |
<value _ptr_="0xbc70b18" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
|
|
308 |
<value _ptr_="0xb2c07b8" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
|
|
309 | 309 |
<value type="object" struct-name="db.mysql.Index" id="be8cf0d0-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a"> |
310 |
<value _ptr_="0xbc72970" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
310 |
<value _ptr_="0xb2c2610" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
311 | 311 |
<value type="object" struct-name="db.mysql.IndexColumn" id="be8cf2ec-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x62630b3c"> |
312 | 312 |
<value type="int" key="columnLength">0</value> |
313 | 313 |
<value type="string" key="comment"></value> |
... | ... | |
330 | 330 |
<link type="object" struct-name="GrtObject" key="owner">be8ce932-a6e0-11e2-95e9-080027bcf912</link> |
331 | 331 |
</value> |
332 | 332 |
<value type="object" struct-name="db.mysql.Index" id="be8cf42c-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a"> |
333 |
<value _ptr_="0xbc72cd8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
333 |
<value _ptr_="0xb2c2978" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
334 | 334 |
<value type="object" struct-name="db.mysql.IndexColumn" id="be8cf5e4-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x62630b3c"> |
335 | 335 |
<value type="int" key="columnLength">0</value> |
336 | 336 |
<value type="string" key="comment"></value> |
... | ... | |
353 | 353 |
<link type="object" struct-name="GrtObject" key="owner">be8ce932-a6e0-11e2-95e9-080027bcf912</link> |
354 | 354 |
</value> |
355 | 355 |
<value type="object" struct-name="db.mysql.Index" id="be8cf71a-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a"> |
356 |
<value _ptr_="0xbc73308" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
356 |
<value _ptr_="0xb2c2fa8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
357 | 357 |
<value type="object" struct-name="db.mysql.IndexColumn" id="be8cf8c8-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x62630b3c"> |
358 | 358 |
<value type="int" key="columnLength">0</value> |
359 | 359 |
<value type="string" key="comment"></value> |
... | ... | |
383 | 383 |
<value type="string" key="nextAutoInc"></value> |
384 | 384 |
<value type="string" key="packKeys"></value> |
385 | 385 |
<value type="int" key="partitionCount">0</value> |
386 |
<value _ptr_="0xbc70ba8" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
|
|
386 |
<value _ptr_="0xb2c0848" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
|
|
387 | 387 |
<value type="string" key="partitionExpression"></value> |
388 | 388 |
<value type="string" key="partitionType"></value> |
389 | 389 |
<value type="string" key="password"></value> |
... | ... | |
398 | 398 |
<value type="string" key="tableDataDir"></value> |
399 | 399 |
<value type="string" key="tableEngine">InnoDB</value> |
400 | 400 |
<value type="string" key="tableIndexDir"></value> |
401 |
<value _ptr_="0xbc70b48" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
|
|
401 |
<value _ptr_="0xb2c07e8" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
|
|
402 | 402 |
<value type="int" key="isStub">0</value> |
403 | 403 |
<value type="int" key="isSystem">0</value> |
404 | 404 |
<value type="int" key="isTemporary">0</value> |
405 | 405 |
<value type="string" key="temporaryScope"></value> |
406 | 406 |
<value type="int" key="commentedOut">0</value> |
407 | 407 |
<value type="string" key="createDate">2013-04-16 14:58</value> |
408 |
<value _ptr_="0xbc6a970" type="dict" key="customData"/>
|
|
408 |
<value _ptr_="0xb2ba5f0" type="dict" key="customData"/>
|
|
409 | 409 |
<value type="string" key="lastChangeDate">2013-04-24 14:35</value> |
410 | 410 |
<value type="int" key="modelOnly">0</value> |
411 | 411 |
<value type="string" key="name">relationship</value> |
... | ... | |
417 | 417 |
<value type="object" struct-name="db.mysql.Table" id="be8cc04c-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x1a403946"> |
418 | 418 |
<value type="string" key="avgRowLength"></value> |
419 | 419 |
<value type="int" key="checksum">0</value> |
420 |
<value _ptr_="0xbc73938" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
|
|
420 |
<value _ptr_="0xb2c35d8" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
|
|
421 | 421 |
<value type="object" struct-name="db.mysql.Column" id="be8cc362-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183"> |
422 | 422 |
<value type="int" key="autoIncrement">0</value> |
423 | 423 |
<value type="string" key="characterSetName"></value> |
424 |
<value _ptr_="0xbc74340" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
424 |
<value _ptr_="0xb2c3fe0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
425 | 425 |
<value type="string" key="collationName"></value> |
426 | 426 |
<value type="string" key="datatypeExplicitParams"></value> |
427 | 427 |
<value type="string" key="defaultValue"></value> |
428 | 428 |
<value type="int" key="defaultValueIsNull">0</value> |
429 |
<value _ptr_="0xbc74668" type="list" content-type="string" key="flags"/>
|
|
429 |
<value _ptr_="0xb2c4308" type="list" content-type="string" key="flags"/>
|
|
430 | 430 |
<value type="int" key="isNotNull">1</value> |
431 | 431 |
<value type="int" key="length">767</value> |
432 | 432 |
<value type="int" key="precision">-1</value> |
... | ... | |
440 | 440 |
<value type="object" struct-name="db.mysql.Column" id="be8cc59c-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183"> |
441 | 441 |
<value type="int" key="autoIncrement">0</value> |
442 | 442 |
<value type="string" key="characterSetName"></value> |
443 |
<value _ptr_="0xbc747b8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
443 |
<value _ptr_="0xb2c4458" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
444 | 444 |
<value type="string" key="collationName"></value> |
445 | 445 |
<value type="string" key="datatypeExplicitParams"></value> |
446 | 446 |
<value type="string" key="defaultValue"></value> |
447 | 447 |
<value type="int" key="defaultValueIsNull">0</value> |
448 |
<value _ptr_="0xbc74ae0" type="list" content-type="string" key="flags"/>
|
|
448 |
<value _ptr_="0xb2c4780" type="list" content-type="string" key="flags"/>
|
|
449 | 449 |
<value type="int" key="isNotNull">1</value> |
450 | 450 |
<value type="int" key="length">767</value> |
451 | 451 |
<value type="int" key="precision">-1</value> |
... | ... | |
459 | 459 |
<value type="object" struct-name="db.mysql.Column" id="d9b5781e-a90b-11e2-8576-080027bcf912" struct-checksum="0x783b5183"> |
460 | 460 |
<value type="int" key="autoIncrement">0</value> |
461 | 461 |
<value type="string" key="characterSetName"></value> |
462 |
<value _ptr_="0xbc74c30" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
462 |
<value _ptr_="0xb2c48d0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
463 | 463 |
<value type="string" key="collationName"></value> |
464 | 464 |
<value type="string" key="datatypeExplicitParams"></value> |
465 | 465 |
<value type="string" key="defaultValue"></value> |
466 | 466 |
<value type="int" key="defaultValueIsNull">0</value> |
467 |
<value _ptr_="0xbc74f58" type="list" content-type="string" key="flags"/>
|
|
467 |
<value _ptr_="0xb2c4bf8" type="list" content-type="string" key="flags"/>
|
|
468 | 468 |
<value type="int" key="isNotNull">1</value> |
469 | 469 |
<value type="int" key="length">767</value> |
470 | 470 |
<value type="int" key="precision">-1</value> |
... | ... | |
478 | 478 |
<value type="object" struct-name="db.mysql.Column" id="c7c1e862-a91b-11e2-bdec-080027bcf912" struct-checksum="0x783b5183"> |
479 | 479 |
<value type="int" key="autoIncrement">0</value> |
480 | 480 |
<value type="string" key="characterSetName"></value> |
481 |
<value _ptr_="0xbc750a8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
481 |
<value _ptr_="0xb2c4d48" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
482 | 482 |
<value type="string" key="collationName"></value> |
483 | 483 |
<value type="string" key="datatypeExplicitParams"></value> |
484 | 484 |
<value type="string" key="defaultValue"></value> |
485 | 485 |
<value type="int" key="defaultValueIsNull">1</value> |
486 |
<value _ptr_="0xbc753d0" type="list" content-type="string" key="flags"/>
|
|
486 |
<value _ptr_="0xb2c5070" type="list" content-type="string" key="flags"/>
|
|
487 | 487 |
<value type="int" key="isNotNull">0</value> |
488 | 488 |
<value type="int" key="length">767</value> |
489 | 489 |
<value type="int" key="precision">-1</value> |
... | ... | |
497 | 497 |
<value type="object" struct-name="db.mysql.Column" id="c8552b14-a7bc-11e2-8af2-080027bcf912" struct-checksum="0x783b5183"> |
498 | 498 |
<value type="int" key="autoIncrement">0</value> |
499 | 499 |
<value type="string" key="characterSetName"></value> |
500 |
<value _ptr_="0xbc75520" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
500 |
<value _ptr_="0xb2c51c0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
501 | 501 |
<value type="string" key="collationName"></value> |
502 | 502 |
<value type="string" key="datatypeExplicitParams"></value> |
503 | 503 |
<value type="string" key="defaultValue"></value> |
504 | 504 |
<value type="int" key="defaultValueIsNull">1</value> |
505 |
<value _ptr_="0xbc75848" type="list" content-type="string" key="flags"/>
|
|
505 |
<value _ptr_="0xb2c54e8" type="list" content-type="string" key="flags"/>
|
|
506 | 506 |
<value type="int" key="isNotNull">0</value> |
507 | 507 |
<value type="int" key="length">767</value> |
508 | 508 |
<value type="int" key="precision">-1</value> |
... | ... | |
510 | 510 |
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link> |
511 | 511 |
<value type="string" key="comment"></value> |
512 | 512 |
<value type="string" key="name">owner</value> |
513 |
<value type="string" key="oldName">contact</value>
|
|
513 |
<value type="string" key="oldName">owner</value>
|
|
514 | 514 |
<link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link> |
515 | 515 |
</value> |
516 | 516 |
<value type="object" struct-name="db.mysql.Column" id="e5155806-a793-11e2-84c3-080027bcf912" struct-checksum="0x783b5183"> |
517 | 517 |
<value type="int" key="autoIncrement">0</value> |
518 | 518 |
<value type="string" key="characterSetName"></value> |
519 |
<value _ptr_="0xbc75998" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
519 |
<value _ptr_="0xb2c5638" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
520 | 520 |
<value type="string" key="collationName"></value> |
521 | 521 |
<value type="string" key="datatypeExplicitParams">('hstore')</value> |
522 | 522 |
<value type="string" key="defaultValue"></value> |
523 | 523 |
<value type="int" key="defaultValueIsNull">0</value> |
524 |
<value _ptr_="0xbc75cc0" type="list" content-type="string" key="flags"/>
|
|
524 |
<value _ptr_="0xb2c5960" type="list" content-type="string" key="flags"/>
|
|
525 | 525 |
<value type="int" key="isNotNull">0</value> |
526 | 526 |
<value type="int" key="length">-1</value> |
527 | 527 |
<value type="int" key="precision">-1</value> |
... | ... | |
537 | 537 |
<value type="string" key="defaultCharacterSetName">utf8</value> |
538 | 538 |
<value type="string" key="defaultCollationName">utf8_bin</value> |
539 | 539 |
<value type="int" key="delayKeyWrite">0</value> |
540 |
<value _ptr_="0xbc740e0" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
|
|
540 |
<value _ptr_="0xb2c3d80" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
|
|
541 | 541 |
<value type="object" struct-name="db.mysql.ForeignKey" id="be8cce5c-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x70a8fc40"> |
542 | 542 |
<link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cc04c-a6e0-11e2-95e9-080027bcf912</link> |
543 |
<value _ptr_="0xbc75e38" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
543 |
<value _ptr_="0xb2c5ad8" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
544 | 544 |
<link type="object">be8cc59c-a6e0-11e2-95e9-080027bcf912</link> |
545 | 545 |
</value> |
546 | 546 |
<value type="int" key="deferability">0</value> |
... | ... | |
550 | 550 |
<value type="int" key="many">1</value> |
551 | 551 |
<value type="int" key="modelOnly">0</value> |
552 | 552 |
<link type="object" struct-name="db.Table" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link> |
553 |
<value _ptr_="0xbc76128" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
553 |
<value _ptr_="0xb2c5dc8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
554 | 554 |
<link type="object">be8cc362-a6e0-11e2-95e9-080027bcf912</link> |
555 | 555 |
</value> |
556 | 556 |
<value type="int" key="referencedMandatory">1</value> |
... | ... | |
561 | 561 |
</value> |
562 | 562 |
<value type="object" struct-name="db.mysql.ForeignKey" id="c8552934-a7bc-11e2-8af2-080027bcf912" struct-checksum="0x70a8fc40"> |
563 | 563 |
<link type="object" struct-name="db.mysql.Table" key="referencedTable">be8fe70e-a6e0-11e2-95e9-080027bcf912</link> |
564 |
<value _ptr_="0xbc76198" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
564 |
<value _ptr_="0xb2c5e38" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
565 | 565 |
<link type="object">c8552b14-a7bc-11e2-8af2-080027bcf912</link> |
566 | 566 |
</value> |
567 | 567 |
<value type="int" key="deferability">0</value> |
... | ... | |
571 | 571 |
<value type="int" key="many">1</value> |
572 | 572 |
<value type="int" key="modelOnly">0</value> |
573 | 573 |
<link type="object" struct-name="db.Table" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link> |
574 |
<value _ptr_="0xbc76488" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
574 |
<value _ptr_="0xb2c6128" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
575 | 575 |
<link type="object">be8fe97a-a6e0-11e2-95e9-080027bcf912</link> |
576 | 576 |
</value> |
577 | 577 |
<value type="int" key="referencedMandatory">0</value> |
... | ... | |
582 | 582 |
</value> |
583 | 583 |
<value type="object" struct-name="db.mysql.ForeignKey" id="c7c1e6aa-a91b-11e2-bdec-080027bcf912" struct-checksum="0x70a8fc40"> |
584 | 584 |
<link type="object" struct-name="db.mysql.Table" key="referencedTable">be8fe70e-a6e0-11e2-95e9-080027bcf912</link> |
585 |
<value _ptr_="0xbc764f8" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
585 |
<value _ptr_="0xb2c6198" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
586 | 586 |
<link type="object">c7c1e862-a91b-11e2-bdec-080027bcf912</link> |
587 | 587 |
</value> |
588 | 588 |
<value type="int" key="deferability">0</value> |
... | ... | |
592 | 592 |
<value type="int" key="many">1</value> |
593 | 593 |
<value type="int" key="modelOnly">0</value> |
594 | 594 |
<link type="object" struct-name="db.Table" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link> |
595 |
<value _ptr_="0xbc767e8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
595 |
<value _ptr_="0xb2c6488" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
596 | 596 |
<link type="object">be8fe97a-a6e0-11e2-95e9-080027bcf912</link> |
597 | 597 |
</value> |
598 | 598 |
<value type="int" key="referencedMandatory">0</value> |
... | ... | |
602 | 602 |
<value type="string" key="oldName">fk_source_party2</value> |
603 | 603 |
</value> |
604 | 604 |
</value> |
605 |
<value _ptr_="0xbc74110" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
|
|
605 |
<value _ptr_="0xb2c3db0" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
|
|
606 | 606 |
<value type="object" struct-name="db.mysql.Index" id="be8cc75e-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a"> |
607 |
<value _ptr_="0xbc76858" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
607 |
<value _ptr_="0xb2c64f8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
608 | 608 |
<value type="object" struct-name="db.mysql.IndexColumn" id="be8cc970-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x62630b3c"> |
609 | 609 |
<value type="int" key="columnLength">0</value> |
610 | 610 |
<value type="string" key="comment"></value> |
... | ... | |
627 | 627 |
<link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link> |
628 | 628 |
</value> |
629 | 629 |
<value type="object" struct-name="db.mysql.Index" id="be8ccb14-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a"> |
630 |
<value _ptr_="0xbc76bc0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
630 |
<value _ptr_="0xb2c6860" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
631 | 631 |
<value type="object" struct-name="db.mysql.IndexColumn" id="be8cccfe-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x62630b3c"> |
632 | 632 |
<value type="int" key="columnLength">0</value> |
633 | 633 |
<value type="string" key="comment"></value> |
... | ... | |
650 | 650 |
<link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link> |
651 | 651 |
</value> |
652 | 652 |
<value type="object" struct-name="db.mysql.Index" id="c8554edc-a7bc-11e2-8af2-080027bcf912" struct-checksum="0x309b847a"> |
653 |
<value _ptr_="0xbc771f0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
653 |
<value _ptr_="0xb2c6e90" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
654 | 654 |
<value type="object" struct-name="db.mysql.IndexColumn" id="c85550b2-a7bc-11e2-8af2-080027bcf912" struct-checksum="0x62630b3c"> |
655 | 655 |
<value type="int" key="columnLength">0</value> |
656 | 656 |
<value type="string" key="comment"></value> |
... | ... | |
673 | 673 |
<link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link> |
674 | 674 |
</value> |
675 | 675 |
<value type="object" struct-name="db.mysql.Index" id="11c10cc8-a90c-11e2-8576-080027bcf912" struct-checksum="0x309b847a"> |
676 |
<value _ptr_="0xbc77820" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
676 |
<value _ptr_="0xb2c74c0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
677 | 677 |
<value type="object" struct-name="db.mysql.IndexColumn" id="151fbf2c-a90c-11e2-8576-080027bcf912" struct-checksum="0x62630b3c"> |
678 | 678 |
<value type="int" key="columnLength">0</value> |
679 | 679 |
<value type="string" key="comment"></value> |
... | ... | |
704 | 704 |
<link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link> |
705 | 705 |
</value> |
706 | 706 |
<value type="object" struct-name="db.mysql.Index" id="c7c2089c-a91b-11e2-bdec-080027bcf912" struct-checksum="0x309b847a"> |
707 |
<value _ptr_="0xbc77e50" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
707 |
<value _ptr_="0xb2c7af0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
708 | 708 |
<value type="object" struct-name="db.mysql.IndexColumn" id="c7c20a4a-a91b-11e2-bdec-080027bcf912" struct-checksum="0x62630b3c"> |
709 | 709 |
<value type="int" key="columnLength">0</value> |
710 | 710 |
<value type="string" key="comment"></value> |
... | ... | |
734 | 734 |
<value type="string" key="nextAutoInc"></value> |
735 | 735 |
<value type="string" key="packKeys"></value> |
736 | 736 |
<value type="int" key="partitionCount">0</value> |
737 |
<value _ptr_="0xbc741a0" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
|
|
737 |
<value _ptr_="0xb2c3e40" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
|
|
738 | 738 |
<value type="string" key="partitionExpression"></value> |
739 | 739 |
<value type="string" key="partitionType"></value> |
740 | 740 |
<value type="string" key="password"></value> |
... | ... | |
749 | 749 |
<value type="string" key="tableDataDir"></value> |
750 | 750 |
<value type="string" key="tableEngine">InnoDB</value> |
751 | 751 |
<value type="string" key="tableIndexDir"></value> |
752 |
<value _ptr_="0xbc74140" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
|
|
752 |
<value _ptr_="0xb2c3de0" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
|
|
753 | 753 |
<value type="int" key="isStub">0</value> |
754 | 754 |
<value type="int" key="isSystem">0</value> |
755 | 755 |
<value type="int" key="isTemporary">0</value> |
756 | 756 |
<value type="string" key="temporaryScope"></value> |
757 | 757 |
<value type="int" key="commentedOut">0</value> |
758 | 758 |
<value type="string" key="createDate">2013-04-16 14:58</value> |
759 |
<value _ptr_="0xbc6c910" type="dict" key="customData"/>
|
|
759 |
<value _ptr_="0xb2bc580" type="dict" key="customData"/>
|
|
760 | 760 |
<value type="string" key="lastChangeDate">2013-04-24 14:43</value> |
761 | 761 |
<value type="int" key="modelOnly">0</value> |
762 | 762 |
<value type="string" key="name">source</value> |
... | ... | |
768 | 768 |
<value type="object" struct-name="db.mysql.Table" id="be8df962-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x1a403946"> |
769 | 769 |
<value type="string" key="avgRowLength"></value> |
770 | 770 |
<value type="int" key="checksum">0</value> |
771 |
<value _ptr_="0xbc78760" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
|
|
771 |
<value _ptr_="0xb2c8400" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
|
|
772 | 772 |
<value type="object" struct-name="db.mysql.Column" id="be8dfbf6-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183"> |
773 | 773 |
<value type="int" key="autoIncrement">0</value> |
774 | 774 |
<value type="string" key="characterSetName"></value> |
775 |
<value _ptr_="0xbc79168" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
775 |
<value _ptr_="0xb2c8e08" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
776 | 776 |
<value type="string" key="collationName"></value> |
777 | 777 |
<value type="string" key="datatypeExplicitParams"></value> |
778 | 778 |
<value type="string" key="defaultValue"></value> |
779 | 779 |
<value type="int" key="defaultValueIsNull">0</value> |
780 |
<value _ptr_="0xbc79490" type="list" content-type="string" key="flags"/>
|
|
780 |
<value _ptr_="0xb2c9130" type="list" content-type="string" key="flags"/>
|
|
781 | 781 |
<value type="int" key="isNotNull">1</value> |
782 | 782 |
<value type="int" key="length">767</value> |
783 | 783 |
<value type="int" key="precision">-1</value> |
... | ... | |
791 | 791 |
<value type="object" struct-name="db.mysql.Column" id="ed1eb468-ad0e-11e2-b309-080027bcf912" struct-checksum="0x783b5183"> |
792 | 792 |
<value type="int" key="autoIncrement">0</value> |
793 | 793 |
<value type="string" key="characterSetName"></value> |
794 |
<value _ptr_="0xbc795e0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
794 |
<value _ptr_="0xb2c9280" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
795 | 795 |
<value type="string" key="collationName"></value> |
796 | 796 |
<value type="string" key="datatypeExplicitParams"></value> |
797 | 797 |
<value type="string" key="defaultValue"></value> |
798 | 798 |
<value type="int" key="defaultValueIsNull">0</value> |
799 |
<value _ptr_="0xbc79908" type="list" content-type="string" key="flags"/>
|
|
799 |
<value _ptr_="0xb2c95a8" type="list" content-type="string" key="flags"/>
|
|
800 | 800 |
<value type="int" key="isNotNull">1</value> |
801 | 801 |
<value type="int" key="length">767</value> |
802 | 802 |
<value type="int" key="precision">-1</value> |
... | ... | |
810 | 810 |
<value type="object" struct-name="db.mysql.Column" id="45a3f404-ad0f-11e2-b309-080027bcf912" struct-checksum="0x783b5183"> |
811 | 811 |
<value type="int" key="autoIncrement">0</value> |
812 | 812 |
<value type="string" key="characterSetName"></value> |
813 |
<value _ptr_="0xbc79a58" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
813 |
<value _ptr_="0xb2c96f8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
814 | 814 |
<value type="string" key="collationName"></value> |
815 | 815 |
<value type="string" key="datatypeExplicitParams"></value> |
816 | 816 |
<value type="string" key="defaultValue"></value> |
817 | 817 |
<value type="int" key="defaultValueIsNull">0</value> |
818 |
<value _ptr_="0xbc79d80" type="list" content-type="string" key="flags"/>
|
|
818 |
<value _ptr_="0xb2c9a20" type="list" content-type="string" key="flags"/>
|
|
819 | 819 |
<value type="int" key="isNotNull">1</value> |
820 | 820 |
<value type="int" key="length">767</value> |
821 | 821 |
<value type="int" key="precision">-1</value> |
... | ... | |
831 | 831 |
<value type="string" key="defaultCharacterSetName">utf8</value> |
832 | 832 |
<value type="string" key="defaultCollationName">utf8_bin</value> |
833 | 833 |
<value type="int" key="delayKeyWrite">0</value> |
834 |
<value _ptr_="0xbc78f08" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
|
|
834 |
<value _ptr_="0xb2c8ba8" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
|
|
835 | 835 |
<value type="object" struct-name="db.mysql.ForeignKey" id="be8e0240-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x70a8fc40"> |
836 | 836 |
<link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cd56e-a6e0-11e2-95e9-080027bcf912</link> |
837 |
<value _ptr_="0xbc79ef8" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
837 |
<value _ptr_="0xb2c9b98" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
838 | 838 |
<link type="object">be8dfbf6-a6e0-11e2-95e9-080027bcf912</link> |
839 | 839 |
</value> |
840 | 840 |
<value type="int" key="deferability">0</value> |
... | ... | |
844 | 844 |
<value type="int" key="many">0</value> |
845 | 845 |
<value type="int" key="modelOnly">0</value> |
846 | 846 |
<link type="object" struct-name="db.Table" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link> |
847 |
<value _ptr_="0xbc7a1e8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
847 |
<value _ptr_="0xb2c9e88" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
848 | 848 |
<link type="object">be8cd7b2-a6e0-11e2-95e9-080027bcf912</link> |
849 | 849 |
</value> |
850 | 850 |
<value type="int" key="referencedMandatory">1</value> |
... | ... | |
855 | 855 |
</value> |
856 | 856 |
<value type="object" struct-name="db.mysql.ForeignKey" id="ed1eb2a6-ad0e-11e2-b309-080027bcf912" struct-checksum="0x70a8fc40"> |
857 | 857 |
<link type="object" struct-name="db.mysql.Table" key="referencedTable">049df920-a91b-11e2-bdec-080027bcf912</link> |
858 |
<value _ptr_="0xbc7a258" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
858 |
<value _ptr_="0xb2c9ef8" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
859 | 859 |
<link type="object">ed1eb468-ad0e-11e2-b309-080027bcf912</link> |
860 | 860 |
</value> |
861 | 861 |
<value type="int" key="deferability">0</value> |
... | ... | |
865 | 865 |
<value type="int" key="many">1</value> |
866 | 866 |
<value type="int" key="modelOnly">0</value> |
867 | 867 |
<link type="object" struct-name="db.Table" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link> |
868 |
<value _ptr_="0xbc7a548" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
868 |
<value _ptr_="0xb2ca1e8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
869 | 869 |
<link type="object">049dfc5e-a91b-11e2-bdec-080027bcf912</link> |
870 | 870 |
</value> |
871 | 871 |
<value type="int" key="referencedMandatory">1</value> |
... | ... | |
875 | 875 |
<value type="string" key="oldName">fk_collection_organization1</value> |
876 | 876 |
</value> |
877 | 877 |
</value> |
878 |
<value _ptr_="0xbc78f38" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
|
|
878 |
<value _ptr_="0xb2c8bd8" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
|
|
879 | 879 |
<value type="object" struct-name="db.mysql.Index" id="ed1ec98a-ad0e-11e2-b309-080027bcf912" struct-checksum="0x309b847a"> |
880 |
<value _ptr_="0xbc7a5b8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
880 |
<value _ptr_="0xb2ca258" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
881 | 881 |
<value type="object" struct-name="db.mysql.IndexColumn" id="ed1ecb1a-ad0e-11e2-b309-080027bcf912" struct-checksum="0x62630b3c"> |
882 | 882 |
<value type="int" key="columnLength">0</value> |
883 | 883 |
<value type="string" key="comment"></value> |
... | ... | |
900 | 900 |
<link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link> |
901 | 901 |
</value> |
902 | 902 |
<value type="object" struct-name="db.mysql.Index" id="6b54505e-ad0f-11e2-b309-080027bcf912" struct-checksum="0x309b847a"> |
903 |
<value _ptr_="0xbc7a920" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
903 |
<value _ptr_="0xb2ca5c0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
904 | 904 |
<value type="object" struct-name="db.mysql.IndexColumn" id="6dd2beb0-ad0f-11e2-b309-080027bcf912" struct-checksum="0x62630b3c"> |
905 | 905 |
<value type="int" key="columnLength">0</value> |
906 | 906 |
<value type="string" key="comment"></value> |
... | ... | |
931 | 931 |
<link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link> |
932 | 932 |
</value> |
933 | 933 |
<value type="object" struct-name="db.mysql.Index" id="81937b1c-ad12-11e2-b309-080027bcf912" struct-checksum="0x309b847a"> |
934 |
<value _ptr_="0xbc7af50" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
934 |
<value _ptr_="0xb2cabf0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
935 | 935 |
<value type="object" struct-name="db.mysql.IndexColumn" id="8194729c-ad12-11e2-b309-080027bcf912" struct-checksum="0x62630b3c"> |
936 | 936 |
<value type="int" key="columnLength">0</value> |
937 | 937 |
<value type="string" key="comment"></value> |
... | ... | |
954 | 954 |
<link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link> |
955 | 955 |
</value> |
956 | 956 |
<value type="object" struct-name="db.mysql.Index" id="8ed70288-ad14-11e2-9617-080027bcf912" struct-checksum="0x309b847a"> |
957 |
<value _ptr_="0xbc7b860" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
957 |
<value _ptr_="0xb2cb500" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
958 | 958 |
<value type="object" struct-name="db.mysql.IndexColumn" id="8ed7a80a-ad14-11e2-9617-080027bcf912" struct-checksum="0x62630b3c"> |
959 | 959 |
<value type="int" key="columnLength">0</value> |
960 | 960 |
<value type="string" key="comment"></value> |
... | ... | |
984 | 984 |
<value type="string" key="nextAutoInc"></value> |
985 | 985 |
<value type="string" key="packKeys"></value> |
986 | 986 |
<value type="int" key="partitionCount">0</value> |
987 |
<value _ptr_="0xbc78fc8" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
|
|
987 |
<value _ptr_="0xb2c8c68" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
|
|
988 | 988 |
<value type="string" key="partitionExpression"></value> |
989 | 989 |
<value type="string" key="partitionType"></value> |
990 | 990 |
<value type="string" key="password"></value> |
... | ... | |
999 | 999 |
<value type="string" key="tableDataDir"></value> |
1000 | 1000 |
<value type="string" key="tableEngine">InnoDB</value> |
1001 | 1001 |
<value type="string" key="tableIndexDir"></value> |
1002 |
<value _ptr_="0xbc78f68" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
|
|
1002 |
<value _ptr_="0xb2c8c08" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
|
|
1003 | 1003 |
<value type="int" key="isStub">0</value> |
1004 | 1004 |
<value type="int" key="isSystem">0</value> |
1005 | 1005 |
<value type="int" key="isTemporary">0</value> |
1006 | 1006 |
<value type="string" key="temporaryScope"></value> |
1007 | 1007 |
<value type="int" key="commentedOut">0</value> |
1008 | 1008 |
<value type="string" key="createDate">2013-04-16 14:58</value> |
1009 |
<value _ptr_="0xb4e6c58" type="dict" key="customData"/>
|
|
1009 |
<value _ptr_="0xada5080" type="dict" key="customData"/>
|
|
1010 | 1010 |
<value type="string" key="lastChangeDate">2013-04-24 14:34</value> |
1011 | 1011 |
<value type="int" key="modelOnly">0</value> |
1012 | 1012 |
<value type="string" key="name">collection</value> |
... | ... | |
1018 | 1018 |
<value type="object" struct-name="db.mysql.Table" id="687f12b8-a780-11e2-afd5-080027bcf912" struct-checksum="0x1a403946"> |
1019 | 1019 |
<value type="string" key="avgRowLength"></value> |
1020 | 1020 |
<value type="int" key="checksum">0</value> |
1021 |
<value _ptr_="0xbc7be90" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
|
|
1021 |
<value _ptr_="0xb2cbb30" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
|
|
1022 | 1022 |
<value type="object" struct-name="db.mysql.Column" id="687f1542-a780-11e2-afd5-080027bcf912" struct-checksum="0x783b5183"> |
1023 | 1023 |
<value type="int" key="autoIncrement">0</value> |
1024 | 1024 |
<value type="string" key="characterSetName"></value> |
1025 |
<value _ptr_="0xbc7c898" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1025 |
<value _ptr_="0xb2cc538" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1026 | 1026 |
<value type="string" key="collationName"></value> |
1027 | 1027 |
<value type="string" key="datatypeExplicitParams"></value> |
1028 | 1028 |
<value type="string" key="defaultValue"></value> |
1029 | 1029 |
<value type="int" key="defaultValueIsNull">0</value> |
1030 |
<value _ptr_="0xbc7cbc0" type="list" content-type="string" key="flags"/>
|
|
1030 |
<value _ptr_="0xb2cc860" type="list" content-type="string" key="flags"/>
|
|
1031 | 1031 |
<value type="int" key="isNotNull">1</value> |
1032 | 1032 |
<value type="int" key="length">767</value> |
1033 | 1033 |
<value type="int" key="precision">-1</value> |
... | ... | |
1041 | 1041 |
<value type="object" struct-name="db.mysql.Column" id="687f1718-a780-11e2-afd5-080027bcf912" struct-checksum="0x783b5183"> |
1042 | 1042 |
<value type="int" key="autoIncrement">0</value> |
1043 | 1043 |
<value type="string" key="characterSetName"></value> |
1044 |
<value _ptr_="0xbc7cd10" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1044 |
<value _ptr_="0xb2cc9b0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1045 | 1045 |
<value type="string" key="collationName"></value> |
1046 | 1046 |
<value type="string" key="datatypeExplicitParams"></value> |
1047 | 1047 |
<value type="string" key="defaultValue"></value> |
1048 | 1048 |
<value type="int" key="defaultValueIsNull">0</value> |
1049 |
<value _ptr_="0xbc7d038" type="list" content-type="string" key="flags"/>
|
|
1049 |
<value _ptr_="0xb2cccd8" type="list" content-type="string" key="flags"/>
|
|
1050 | 1050 |
<value type="int" key="isNotNull">1</value> |
1051 | 1051 |
<value type="int" key="length">767</value> |
1052 | 1052 |
<value type="int" key="precision">-1</value> |
... | ... | |
1060 | 1060 |
<value type="object" struct-name="db.mysql.Column" id="687f18b2-a780-11e2-afd5-080027bcf912" struct-checksum="0x783b5183"> |
1061 | 1061 |
<value type="int" key="autoIncrement">0</value> |
1062 | 1062 |
<value type="string" key="characterSetName"></value> |
1063 |
<value _ptr_="0xbc7d188" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1063 |
<value _ptr_="0xb2cce28" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1064 | 1064 |
<value type="string" key="collationName"></value> |
1065 | 1065 |
<value type="string" key="datatypeExplicitParams"></value> |
1066 | 1066 |
<value type="string" key="defaultValue"></value> |
1067 | 1067 |
<value type="int" key="defaultValueIsNull">1</value> |
1068 |
<value _ptr_="0xbc7d4b0" type="list" content-type="string" key="flags"/>
|
|
1068 |
<value _ptr_="0xb2cd150" type="list" content-type="string" key="flags"/>
|
|
1069 | 1069 |
<value type="int" key="isNotNull">0</value> |
1070 | 1070 |
<value type="int" key="length">767</value> |
1071 | 1071 |
<value type="int" key="precision">-1</value> |
... | ... | |
1079 | 1079 |
<value type="object" struct-name="db.mysql.Column" id="687f1a6a-a780-11e2-afd5-080027bcf912" struct-checksum="0x783b5183"> |
1080 | 1080 |
<value type="int" key="autoIncrement">0</value> |
1081 | 1081 |
<value type="string" key="characterSetName"></value> |
1082 |
<value _ptr_="0xbc7d600" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1082 |
<value _ptr_="0xb2cd2a0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1083 | 1083 |
<value type="string" key="collationName"></value> |
1084 | 1084 |
<value type="string" key="datatypeExplicitParams"></value> |
1085 | 1085 |
<value type="string" key="defaultValue"></value> |
1086 | 1086 |
<value type="int" key="defaultValueIsNull">1</value> |
1087 |
<value _ptr_="0xbc7d928" type="list" content-type="string" key="flags"/>
|
|
1087 |
<value _ptr_="0xb2cd5c8" type="list" content-type="string" key="flags"/>
|
|
1088 | 1088 |
<value type="int" key="isNotNull">0</value> |
1089 | 1089 |
<value type="int" key="length">767</value> |
1090 | 1090 |
<value type="int" key="precision">-1</value> |
... | ... | |
1098 | 1098 |
<value type="object" struct-name="db.mysql.Column" id="687f1c2c-a780-11e2-afd5-080027bcf912" struct-checksum="0x783b5183"> |
1099 | 1099 |
<value type="int" key="autoIncrement">0</value> |
1100 | 1100 |
<value type="string" key="characterSetName"></value> |
1101 |
<value _ptr_="0xbc7da78" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1101 |
<value _ptr_="0xb2cd718" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1102 | 1102 |
<value type="string" key="collationName"></value> |
1103 | 1103 |
<value type="string" key="datatypeExplicitParams"></value> |
1104 | 1104 |
<value type="string" key="defaultValue"></value> |
1105 | 1105 |
<value type="int" key="defaultValueIsNull">1</value> |
1106 |
<value _ptr_="0xbc7dda0" type="list" content-type="string" key="flags"/>
|
|
1106 |
<value _ptr_="0xb2cda40" type="list" content-type="string" key="flags"/>
|
|
1107 | 1107 |
<value type="int" key="isNotNull">0</value> |
1108 | 1108 |
<value type="int" key="length">767</value> |
1109 | 1109 |
<value type="int" key="precision">-1</value> |
... | ... | |
1117 | 1117 |
<value type="object" struct-name="db.mysql.Column" id="29c29602-a7a4-11e2-8ba6-080027bcf912" struct-checksum="0x783b5183"> |
1118 | 1118 |
<value type="int" key="autoIncrement">0</value> |
1119 | 1119 |
<value type="string" key="characterSetName"></value> |
1120 |
<value _ptr_="0xbc7def0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1120 |
<value _ptr_="0xb2cdb90" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1121 | 1121 |
<value type="string" key="collationName"></value> |
1122 | 1122 |
<value type="string" key="datatypeExplicitParams"></value> |
1123 | 1123 |
<value type="string" key="defaultValue"></value> |
1124 | 1124 |
<value type="int" key="defaultValueIsNull">1</value> |
1125 |
<value _ptr_="0xbc7e218" type="list" content-type="string" key="flags"/>
|
|
1125 |
<value _ptr_="0xb2cdeb8" type="list" content-type="string" key="flags"/>
|
|
1126 | 1126 |
<value type="int" key="isNotNull">0</value> |
1127 | 1127 |
<value type="int" key="length">767</value> |
1128 | 1128 |
<value type="int" key="precision">-1</value> |
... | ... | |
1136 | 1136 |
<value type="object" struct-name="db.mysql.Column" id="687f1dda-a780-11e2-afd5-080027bcf912" struct-checksum="0x783b5183"> |
1137 | 1137 |
<value type="int" key="autoIncrement">0</value> |
1138 | 1138 |
<value type="string" key="characterSetName"></value> |
1139 |
<value _ptr_="0xbc7e368" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1139 |
<value _ptr_="0xb2ce008" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1140 | 1140 |
<value type="string" key="collationName"></value> |
1141 | 1141 |
<value type="string" key="datatypeExplicitParams"></value> |
1142 | 1142 |
<value type="string" key="defaultValue"></value> |
1143 | 1143 |
<value type="int" key="defaultValueIsNull">1</value> |
1144 |
<value _ptr_="0xbc7e690" type="list" content-type="string" key="flags"/>
|
|
1144 |
<value _ptr_="0xb2ce330" type="list" content-type="string" key="flags"/>
|
|
1145 | 1145 |
<value type="int" key="isNotNull">0</value> |
1146 | 1146 |
<value type="int" key="length">767</value> |
1147 | 1147 |
<value type="int" key="precision">-1</value> |
... | ... | |
1157 | 1157 |
<value type="string" key="defaultCharacterSetName">utf8</value> |
1158 | 1158 |
<value type="string" key="defaultCollationName">utf8_bin</value> |
1159 | 1159 |
<value type="int" key="delayKeyWrite">0</value> |
1160 |
<value _ptr_="0xbc7c638" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
|
|
1160 |
<value _ptr_="0xb2cc2d8" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
|
|
1161 | 1161 |
<value type="object" struct-name="db.mysql.ForeignKey" id="687f25a0-a780-11e2-afd5-080027bcf912" struct-checksum="0x70a8fc40"> |
1162 | 1162 |
<link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cd56e-a6e0-11e2-95e9-080027bcf912</link> |
1163 |
<value _ptr_="0xbc7e808" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
1163 |
<value _ptr_="0xb2ce4a8" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
1164 | 1164 |
<link type="object">687f1542-a780-11e2-afd5-080027bcf912</link> |
1165 | 1165 |
</value> |
1166 | 1166 |
<value type="int" key="deferability">0</value> |
... | ... | |
1170 | 1170 |
<value type="int" key="many">0</value> |
1171 | 1171 |
<value type="int" key="modelOnly">0</value> |
1172 | 1172 |
<link type="object" struct-name="db.Table" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link> |
1173 |
<value _ptr_="0xbc7eaf8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
1173 |
<value _ptr_="0xb2ce798" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
1174 | 1174 |
<link type="object">be8cd7b2-a6e0-11e2-95e9-080027bcf912</link> |
1175 | 1175 |
</value> |
1176 | 1176 |
<value type="int" key="referencedMandatory">1</value> |
... | ... | |
1181 | 1181 |
</value> |
1182 | 1182 |
<value type="object" struct-name="db.mysql.ForeignKey" id="687f26f4-a780-11e2-afd5-080027bcf912" struct-checksum="0x70a8fc40"> |
1183 | 1183 |
<link type="object" struct-name="db.mysql.Table" key="referencedTable">4c3ffc96-a741-11e2-9fbf-080027bcf912</link> |
1184 |
<value _ptr_="0xbc7eb68" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
1184 |
<value _ptr_="0xb2ce808" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
1185 | 1185 |
<link type="object">687f1718-a780-11e2-afd5-080027bcf912</link> |
1186 | 1186 |
</value> |
1187 | 1187 |
<value type="int" key="deferability">0</value> |
... | ... | |
1191 | 1191 |
<value type="int" key="many">1</value> |
1192 | 1192 |
<value type="int" key="modelOnly">0</value> |
1193 | 1193 |
<link type="object" struct-name="db.Table" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link> |
1194 |
<value _ptr_="0xbc7ee58" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
1194 |
<value _ptr_="0xb2ceaf8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
1195 | 1195 |
<link type="object">4c40001a-a741-11e2-9fbf-080027bcf912</link> |
1196 | 1196 |
</value> |
1197 | 1197 |
<value type="int" key="referencedMandatory">1</value> |
... | ... | |
1201 | 1201 |
<value type="string" key="oldName">fk_taxon_concept_taxon_string10</value> |
1202 | 1202 |
</value> |
1203 | 1203 |
</value> |
1204 |
<value _ptr_="0xbc7c668" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
|
|
1204 |
<value _ptr_="0xb2cc308" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
|
|
1205 | 1205 |
<value type="object" struct-name="db.mysql.Index" id="687f1f92-a780-11e2-afd5-080027bcf912" struct-checksum="0x309b847a"> |
1206 |
<value _ptr_="0xbc7eec8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
1206 |
<value _ptr_="0xb2ceb68" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
1207 | 1207 |
<value type="object" struct-name="db.mysql.IndexColumn" id="687f217c-a780-11e2-afd5-080027bcf912" struct-checksum="0x62630b3c"> |
1208 | 1208 |
<value type="int" key="columnLength">0</value> |
1209 | 1209 |
<value type="string" key="comment"></value> |
... | ... | |
1226 | 1226 |
<link type="object" struct-name="GrtObject" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link> |
1227 | 1227 |
</value> |
1228 | 1228 |
<value type="object" struct-name="db.mysql.Index" id="687f22b2-a780-11e2-afd5-080027bcf912" struct-checksum="0x309b847a"> |
1229 |
<value _ptr_="0xbc7f230" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
1229 |
<value _ptr_="0xb2ceed0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
1230 | 1230 |
<value type="object" struct-name="db.mysql.IndexColumn" id="687f246a-a780-11e2-afd5-080027bcf912" struct-checksum="0x62630b3c"> |
1231 | 1231 |
<value type="int" key="columnLength">0</value> |
1232 | 1232 |
<value type="string" key="comment"></value> |
... | ... | |
1256 | 1256 |
<value type="string" key="nextAutoInc"></value> |
1257 | 1257 |
<value type="string" key="packKeys"></value> |
1258 | 1258 |
<value type="int" key="partitionCount">0</value> |
1259 |
<value _ptr_="0xbc7c6f8" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
|
|
1259 |
<value _ptr_="0xb2cc398" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
|
|
1260 | 1260 |
<value type="string" key="partitionExpression"></value> |
1261 | 1261 |
<value type="string" key="partitionType"></value> |
1262 | 1262 |
<value type="string" key="password"></value> |
... | ... | |
1271 | 1271 |
<value type="string" key="tableDataDir"></value> |
1272 | 1272 |
<value type="string" key="tableEngine">InnoDB</value> |
1273 | 1273 |
<value type="string" key="tableIndexDir"></value> |
1274 |
<value _ptr_="0xbc7c698" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
|
|
1274 |
<value _ptr_="0xb2cc338" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
|
|
1275 | 1275 |
<value type="int" key="isStub">0</value> |
1276 | 1276 |
<value type="int" key="isSystem">0</value> |
1277 | 1277 |
<value type="int" key="isTemporary">0</value> |
1278 | 1278 |
<value type="string" key="temporaryScope"></value> |
1279 | 1279 |
<value type="int" key="commentedOut">0</value> |
1280 | 1280 |
<value type="string" key="createDate">2013-04-17 10:01</value> |
1281 |
<value _ptr_="0xbc6c758" type="dict" key="customData"/>
|
|
1281 |
<value _ptr_="0xb2bc3c8" type="dict" key="customData"/>
|
|
1282 | 1282 |
<value type="string" key="lastChangeDate">2013-04-17 14:17</value> |
1283 | 1283 |
<value type="int" key="modelOnly">0</value> |
1284 | 1284 |
<value type="string" key="name">taxon_name</value> |
... | ... | |
1290 | 1290 |
<value type="object" struct-name="db.mysql.Table" id="be8cd56e-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x1a403946"> |
1291 | 1291 |
<value type="string" key="avgRowLength"></value> |
1292 | 1292 |
<value type="int" key="checksum">0</value> |
1293 |
<value _ptr_="0xbc7f860" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
|
|
1293 |
<value _ptr_="0xb2cf500" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
|
|
1294 | 1294 |
<value type="object" struct-name="db.mysql.Column" id="be8cd7b2-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183"> |
1295 | 1295 |
<value type="int" key="autoIncrement">0</value> |
1296 | 1296 |
<value type="string" key="characterSetName"></value> |
1297 |
<value _ptr_="0xb4e7570" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1297 |
<value _ptr_="0xb2cff08" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1298 | 1298 |
<value type="string" key="collationName"></value> |
1299 | 1299 |
<value type="string" key="datatypeExplicitParams"></value> |
1300 | 1300 |
<value type="string" key="defaultValue"></value> |
1301 | 1301 |
<value type="int" key="defaultValueIsNull">0</value> |
1302 |
<value _ptr_="0xbc6c8b8" type="list" content-type="string" key="flags"/>
|
|
1302 |
<value _ptr_="0xb2d0230" type="list" content-type="string" key="flags"/>
|
|
1303 | 1303 |
<value type="int" key="isNotNull">1</value> |
1304 | 1304 |
<value type="int" key="length">767</value> |
1305 | 1305 |
<value type="int" key="precision">-1</value> |
... | ... | |
1313 | 1313 |
<value type="object" struct-name="db.mysql.Column" id="be8cd956-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183"> |
1314 | 1314 |
<value type="int" key="autoIncrement">0</value> |
1315 | 1315 |
<value type="string" key="characterSetName"></value> |
1316 |
<value _ptr_="0xb4c8770" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1316 |
<value _ptr_="0xb2d0380" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1317 | 1317 |
<value type="string" key="collationName"></value> |
1318 | 1318 |
<value type="string" key="datatypeExplicitParams"></value> |
1319 | 1319 |
<value type="string" key="defaultValue"></value> |
1320 | 1320 |
<value type="int" key="defaultValueIsNull">0</value> |
1321 |
<value _ptr_="0xb4e7630" type="list" content-type="string" key="flags"/>
|
|
1321 |
<value _ptr_="0xb2d06a8" type="list" content-type="string" key="flags"/>
|
|
1322 | 1322 |
<value type="int" key="isNotNull">1</value> |
1323 | 1323 |
<value type="int" key="length">767</value> |
1324 | 1324 |
<value type="int" key="precision">-1</value> |
... | ... | |
1332 | 1332 |
<value type="object" struct-name="db.mysql.Column" id="ea3bec44-acef-11e2-bdae-080027bcf912" struct-checksum="0x783b5183"> |
1333 | 1333 |
<value type="int" key="autoIncrement">0</value> |
1334 | 1334 |
<value type="string" key="characterSetName"></value> |
1335 |
<value _ptr_="0xb4ed968" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1335 |
<value _ptr_="0xb2d07f8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1336 | 1336 |
<value type="string" key="collationName"></value> |
1337 | 1337 |
<value type="string" key="datatypeExplicitParams"></value> |
1338 | 1338 |
<value type="string" key="defaultValue"></value> |
1339 | 1339 |
<value type="int" key="defaultValueIsNull">0</value> |
1340 |
<value _ptr_="0xbc6bbe0" type="list" content-type="string" key="flags"/>
|
|
1340 |
<value _ptr_="0xb2d0b20" type="list" content-type="string" key="flags"/>
|
|
1341 | 1341 |
<value type="int" key="isNotNull">0</value> |
1342 | 1342 |
<value type="int" key="length">767</value> |
1343 | 1343 |
<value type="int" key="precision">-1</value> |
... | ... | |
1351 | 1351 |
<value type="object" struct-name="db.mysql.Column" id="a09e45d4-a79d-11e2-a346-080027bcf912" struct-checksum="0x783b5183"> |
1352 | 1352 |
<value type="int" key="autoIncrement">0</value> |
1353 | 1353 |
<value type="string" key="characterSetName"></value> |
1354 |
<value _ptr_="0xb4b3ea0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1354 |
<value _ptr_="0xb2d0c70" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1355 | 1355 |
<value type="string" key="collationName"></value> |
1356 | 1356 |
<value type="string" key="datatypeExplicitParams"></value> |
1357 | 1357 |
<value type="string" key="defaultValue"></value> |
1358 | 1358 |
<value type="int" key="defaultValueIsNull">1</value> |
1359 |
<value _ptr_="0xb4c1950" type="list" content-type="string" key="flags"/>
|
|
1359 |
<value _ptr_="0xb2d0f98" type="list" content-type="string" key="flags"/>
|
|
1360 | 1360 |
<value type="int" key="isNotNull">0</value> |
1361 | 1361 |
<value type="int" key="length">767</value> |
1362 | 1362 |
<value type="int" key="precision">-1</value> |
... | ... | |
1370 | 1370 |
<value type="object" struct-name="db.mysql.Column" id="43f62c16-ad1a-11e2-9d85-080027bcf912" struct-checksum="0x783b5183"> |
1371 | 1371 |
<value type="int" key="autoIncrement">0</value> |
1372 | 1372 |
<value type="string" key="characterSetName"></value> |
1373 |
<value _ptr_="0xb4ede50" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1373 |
<value _ptr_="0xb2d10e8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1374 | 1374 |
<value type="string" key="collationName"></value> |
1375 | 1375 |
<value type="string" key="datatypeExplicitParams">('hstore')</value> |
1376 | 1376 |
<value type="string" key="defaultValue"></value> |
1377 | 1377 |
<value type="int" key="defaultValueIsNull">0</value> |
1378 |
<value _ptr_="0xbc6c5c8" type="list" content-type="string" key="flags"/>
|
|
1378 |
<value _ptr_="0xb2d1410" type="list" content-type="string" key="flags"/>
|
|
1379 | 1379 |
<value type="int" key="isNotNull">0</value> |
1380 | 1380 |
<value type="int" key="length">-1</value> |
1381 | 1381 |
<value type="int" key="precision">-1</value> |
... | ... | |
1391 | 1391 |
<value type="string" key="defaultCharacterSetName">utf8</value> |
1392 | 1392 |
<value type="string" key="defaultCollationName">utf8_bin</value> |
1393 | 1393 |
<value type="int" key="delayKeyWrite">0</value> |
1394 |
<value _ptr_="0xbc6b0a8" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
|
|
1394 |
<value _ptr_="0xb2cfca8" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
|
|
1395 | 1395 |
<value type="object" struct-name="db.mysql.ForeignKey" id="be8ce0b8-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x70a8fc40"> |
1396 | 1396 |
<link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cc04c-a6e0-11e2-95e9-080027bcf912</link> |
1397 |
<value _ptr_="0xb4f1f00" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
1397 |
<value _ptr_="0xb2d1588" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
1398 | 1398 |
<link type="object">be8cd956-a6e0-11e2-95e9-080027bcf912</link> |
1399 | 1399 |
</value> |
1400 | 1400 |
<value type="int" key="deferability">0</value> |
... | ... | |
1404 | 1404 |
<value type="int" key="many">1</value> |
1405 | 1405 |
<value type="int" key="modelOnly">0</value> |
1406 | 1406 |
<link type="object" struct-name="db.Table" key="owner">be8cd56e-a6e0-11e2-95e9-080027bcf912</link> |
1407 |
<value _ptr_="0xb744e38" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
1407 |
<value _ptr_="0xb2d1878" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
1408 | 1408 |
<link type="object">be8cc362-a6e0-11e2-95e9-080027bcf912</link> |
1409 | 1409 |
</value> |
1410 | 1410 |
<value type="int" key="referencedMandatory">1</value> |
... | ... | |
1414 | 1414 |
<value type="string" key="oldName">fk_record_source1</value> |
1415 | 1415 |
</value> |
1416 | 1416 |
</value> |
1417 |
<value _ptr_="0xb4ea4b8" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
|
|
1417 |
<value _ptr_="0xb2cfcd8" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
|
|
1418 | 1418 |
<value type="object" struct-name="db.mysql.Index" id="be8cdac8-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a"> |
1419 |
<value _ptr_="0xb4ea2b0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
1419 |
<value _ptr_="0xb2d18e8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
1420 | 1420 |
<value type="object" struct-name="db.mysql.IndexColumn" id="be8cdc94-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x62630b3c"> |
1421 | 1421 |
<value type="int" key="columnLength">0</value> |
1422 | 1422 |
<value type="string" key="comment"></value> |
... | ... | |
1439 | 1439 |
<link type="object" struct-name="GrtObject" key="owner">be8cd56e-a6e0-11e2-95e9-080027bcf912</link> |
1440 | 1440 |
</value> |
1441 | 1441 |
<value type="object" struct-name="db.mysql.Index" id="be8cddca-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a"> |
1442 |
<value _ptr_="0xb4e7060" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
1442 |
<value _ptr_="0xb2d1c50" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
1443 | 1443 |
<value type="object" struct-name="db.mysql.IndexColumn" id="be8cdf82-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x62630b3c"> |
1444 | 1444 |
<value type="int" key="columnLength">0</value> |
1445 | 1445 |
<value type="string" key="comment"></value> |
... | ... | |
1462 | 1462 |
<link type="object" struct-name="GrtObject" key="owner">be8cd56e-a6e0-11e2-95e9-080027bcf912</link> |
1463 | 1463 |
</value> |
1464 | 1464 |
<value type="object" struct-name="db.mysql.Index" id="fbf69d1e-a79d-11e2-a346-080027bcf912" struct-checksum="0x309b847a"> |
1465 |
<value _ptr_="0xb744260" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
1465 |
<value _ptr_="0xb2d2280" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
1466 | 1466 |
<value type="object" struct-name="db.mysql.IndexColumn" id="fecdc3c8-a79d-11e2-a346-080027bcf912" struct-checksum="0x62630b3c"> |
1467 | 1467 |
<value type="int" key="columnLength">0</value> |
1468 | 1468 |
<value type="string" key="comment"></value> |
... | ... | |
1508 | 1508 |
<value type="string" key="nextAutoInc"></value> |
1509 | 1509 |
<value type="string" key="packKeys"></value> |
1510 | 1510 |
<value type="int" key="partitionCount">0</value> |
1511 |
<value _ptr_="0xb4ea6c8" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
|
|
1511 |
<value _ptr_="0xb2cfd68" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
|
|
1512 | 1512 |
<value type="string" key="partitionExpression"></value> |
1513 | 1513 |
<value type="string" key="partitionType"></value> |
1514 | 1514 |
<value type="string" key="password"></value> |
... | ... | |
1523 | 1523 |
<value type="string" key="tableDataDir"></value> |
1524 | 1524 |
<value type="string" key="tableEngine">InnoDB</value> |
1525 | 1525 |
<value type="string" key="tableIndexDir"></value> |
1526 |
<value _ptr_="0xb4ea670" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
|
|
1526 |
<value _ptr_="0xb2cfd08" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
|
|
1527 | 1527 |
<value type="int" key="isStub">0</value> |
1528 | 1528 |
<value type="int" key="isSystem">0</value> |
1529 | 1529 |
<value type="int" key="isTemporary">0</value> |
1530 | 1530 |
<value type="string" key="temporaryScope"></value> |
1531 | 1531 |
<value type="int" key="commentedOut">0</value> |
1532 | 1532 |
<value type="string" key="createDate">2013-04-16 14:58</value> |
1533 |
<value _ptr_="0xb745028" type="dict" key="customData"/>
|
|
1533 |
<value _ptr_="0xab485e0" type="dict" key="customData"/>
|
|
1534 | 1534 |
<value type="string" key="lastChangeDate">2013-04-24 13:05</value> |
1535 | 1535 |
<value type="int" key="modelOnly">0</value> |
1536 | 1536 |
<value type="string" key="name">record</value> |
... | ... | |
1542 | 1542 |
<value type="object" struct-name="db.mysql.Table" id="be8e3ecc-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x1a403946"> |
1543 | 1543 |
<value type="string" key="avgRowLength"></value> |
1544 | 1544 |
<value type="int" key="checksum">0</value> |
1545 |
<value _ptr_="0xbc6c398" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
|
|
1545 |
<value _ptr_="0xb2d28b0" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
|
|
1546 | 1546 |
<value type="object" struct-name="db.mysql.Column" id="be8e4142-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183"> |
1547 | 1547 |
<value type="int" key="autoIncrement">0</value> |
1548 | 1548 |
<value type="string" key="characterSetName"></value> |
1549 |
<value _ptr_="0xb4d5628" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1549 |
<value _ptr_="0xb2d3878" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1550 | 1550 |
<value type="string" key="collationName"></value> |
1551 | 1551 |
<value type="string" key="datatypeExplicitParams"></value> |
1552 | 1552 |
<value type="string" key="defaultValue"></value> |
1553 | 1553 |
<value type="int" key="defaultValueIsNull">0</value> |
1554 |
<value _ptr_="0xb745080" type="list" content-type="string" key="flags"/>
|
|
1554 |
<value _ptr_="0xb2d3ba0" type="list" content-type="string" key="flags"/>
|
|
1555 | 1555 |
<value type="int" key="isNotNull">1</value> |
1556 | 1556 |
<value type="int" key="length">767</value> |
1557 | 1557 |
<value type="int" key="precision">-1</value> |
... | ... | |
1565 | 1565 |
<value type="object" struct-name="db.mysql.Column" id="273737e8-a796-11e2-84c3-080027bcf912" struct-checksum="0x783b5183"> |
1566 | 1566 |
<value type="int" key="autoIncrement">0</value> |
1567 | 1567 |
<value type="string" key="characterSetName"></value> |
1568 |
<value _ptr_="0xb7451a8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1568 |
<value _ptr_="0xb2d3cf0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1569 | 1569 |
<value type="string" key="collationName"></value> |
1570 | 1570 |
<value type="string" key="datatypeExplicitParams"></value> |
1571 | 1571 |
<value type="string" key="defaultValue"></value> |
1572 | 1572 |
<value type="int" key="defaultValueIsNull">1</value> |
1573 |
<value _ptr_="0xbc6bd08" type="list" content-type="string" key="flags"/>
|
|
1573 |
<value _ptr_="0xb2d4018" type="list" content-type="string" key="flags"/>
|
|
1574 | 1574 |
<value type="int" key="isNotNull">0</value> |
1575 | 1575 |
<value type="int" key="length">767</value> |
1576 | 1576 |
<value type="int" key="precision">-1</value> |
... | ... | |
1586 | 1586 |
<value type="string" key="defaultCharacterSetName">utf8</value> |
1587 | 1587 |
<value type="string" key="defaultCollationName">utf8_bin</value> |
1588 | 1588 |
<value type="int" key="delayKeyWrite">0</value> |
1589 |
<value _ptr_="0xb4e86f8" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
|
|
1589 |
<value _ptr_="0xb2d3618" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
|
|
1590 | 1590 |
<value type="object" struct-name="db.mysql.ForeignKey" id="be8e4688-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x70a8fc40"> |
1591 | 1591 |
<link type="object" struct-name="db.mysql.Table" key="referencedTable">c672a8d8-a7a0-11e2-b667-080027bcf912</link> |
1592 |
<value _ptr_="0xbc6be58" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
1592 |
<value _ptr_="0xb2d4190" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
1593 | 1593 |
<link type="object">be8e4142-a6e0-11e2-95e9-080027bcf912</link> |
1594 | 1594 |
</value> |
1595 | 1595 |
<value type="int" key="deferability">0</value> |
... | ... | |
1599 | 1599 |
<value type="int" key="many">0</value> |
1600 | 1600 |
<value type="int" key="modelOnly">0</value> |
1601 | 1601 |
<link type="object" struct-name="db.Table" key="owner">be8e3ecc-a6e0-11e2-95e9-080027bcf912</link> |
1602 |
<value _ptr_="0xb4ec718" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
1602 |
<value _ptr_="0xb2d4480" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
1603 | 1603 |
<link type="object">c672abda-a7a0-11e2-b667-080027bcf912</link> |
1604 | 1604 |
</value> |
1605 | 1605 |
<value type="int" key="referencedMandatory">1</value> |
... | ... | |
1609 | 1609 |
<value type="string" key="oldName">fk_individual_record1</value> |
1610 | 1610 |
</value> |
1611 | 1611 |
</value> |
1612 |
<value _ptr_="0xb4e8748" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
|
|
1612 |
<value _ptr_="0xb2d3648" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
|
|
1613 | 1613 |
<value type="object" struct-name="db.mysql.Index" id="be8e4322-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a"> |
1614 |
<value _ptr_="0xb4ec790" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
1614 |
<value _ptr_="0xb2d44f0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
1615 | 1615 |
<value type="object" struct-name="db.mysql.IndexColumn" id="8903c758-ac45-11e2-820d-080027bcf912" struct-checksum="0x62630b3c"> |
1616 | 1616 |
<value type="int" key="columnLength">0</value> |
1617 | 1617 |
<value type="string" key="comment"></value> |
... | ... | |
1641 | 1641 |
<value type="string" key="nextAutoInc"></value> |
1642 | 1642 |
<value type="string" key="packKeys"></value> |
1643 | 1643 |
<value type="int" key="partitionCount">0</value> |
1644 |
<value _ptr_="0xb4e87f8" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
|
|
1644 |
<value _ptr_="0xb2d36d8" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
|
|
1645 | 1645 |
<value type="string" key="partitionExpression"></value> |
1646 | 1646 |
<value type="string" key="partitionType"></value> |
1647 | 1647 |
<value type="string" key="password"></value> |
... | ... | |
1656 | 1656 |
<value type="string" key="tableDataDir"></value> |
1657 | 1657 |
<value type="string" key="tableEngine">InnoDB</value> |
1658 | 1658 |
<value type="string" key="tableIndexDir"></value> |
1659 |
<value _ptr_="0xb4e8798" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
|
|
1659 |
<value _ptr_="0xb2d3678" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
|
|
1660 | 1660 |
<value type="int" key="isStub">0</value> |
1661 | 1661 |
<value type="int" key="isSystem">0</value> |
1662 | 1662 |
<value type="int" key="isTemporary">0</value> |
1663 | 1663 |
<value type="string" key="temporaryScope"></value> |
1664 | 1664 |
<value type="int" key="commentedOut">0</value> |
1665 | 1665 |
<value type="string" key="createDate">2013-04-16 14:58</value> |
1666 |
<value _ptr_="0xb502068" type="dict" key="customData"/>
|
|
1666 |
<value _ptr_="0xb2bb358" type="dict" key="customData"/>
|
|
1667 | 1667 |
<value type="string" key="lastChangeDate">2013-04-24 14:33</value> |
1668 | 1668 |
<value type="int" key="modelOnly">0</value> |
1669 | 1669 |
<value type="string" key="name">individual</value> |
... | ... | |
1675 | 1675 |
<value type="object" struct-name="db.mysql.Table" id="4c3ffc96-a741-11e2-9fbf-080027bcf912" struct-checksum="0x1a403946"> |
1676 | 1676 |
<value type="string" key="avgRowLength"></value> |
1677 | 1677 |
<value type="int" key="checksum">0</value> |
1678 |
<value _ptr_="0xb4ecb70" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
|
|
1678 |
<value _ptr_="0xb2d4858" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
|
|
1679 | 1679 |
<value type="object" struct-name="db.mysql.Column" id="4c40001a-a741-11e2-9fbf-080027bcf912" struct-checksum="0x783b5183"> |
1680 | 1680 |
<value type="int" key="autoIncrement">0</value> |
1681 | 1681 |
<value type="string" key="characterSetName"></value> |
1682 |
<value _ptr_="0xbc6b620" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1682 |
<value _ptr_="0xb2d5260" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1683 | 1683 |
<value type="string" key="collationName"></value> |
1684 | 1684 |
<value type="string" key="datatypeExplicitParams"></value> |
1685 | 1685 |
<value type="string" key="defaultValue"></value> |
1686 | 1686 |
<value type="int" key="defaultValueIsNull">0</value> |
1687 |
<value _ptr_="0xbc6b650" type="list" content-type="string" key="flags"/>
|
|
1687 |
<value _ptr_="0xb2d5588" type="list" content-type="string" key="flags"/>
|
|
1688 | 1688 |
<value type="int" key="isNotNull">1</value> |
1689 | 1689 |
<value type="int" key="length">767</value> |
1690 | 1690 |
<value type="int" key="precision">-1</value> |
... | ... | |
1700 | 1700 |
<value type="string" key="defaultCharacterSetName">utf8</value> |
1701 | 1701 |
<value type="string" key="defaultCollationName">utf8_bin</value> |
1702 | 1702 |
<value type="int" key="delayKeyWrite">0</value> |
1703 |
<value _ptr_="0xbc6b380" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys"/>
|
|
1704 |
<value _ptr_="0xbc6b3d0" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
|
|
1703 |
<value _ptr_="0xb2d5000" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys"/>
|
|
1704 |
<value _ptr_="0xb2d5030" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
|
|
1705 | 1705 |
<value type="object" struct-name="db.mysql.Index" id="4c4005b0-a741-11e2-9fbf-080027bcf912" struct-checksum="0x309b847a"> |
1706 |
<value _ptr_="0xb4ec428" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
1706 |
<value _ptr_="0xb2d56d8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
1707 | 1707 |
<value type="object" struct-name="db.mysql.IndexColumn" id="4c4006e6-a741-11e2-9fbf-080027bcf912" struct-checksum="0x62630b3c"> |
1708 | 1708 |
<value type="int" key="columnLength">0</value> |
1709 | 1709 |
<value type="string" key="comment"></value> |
... | ... | |
1733 | 1733 |
<value type="string" key="nextAutoInc"></value> |
1734 | 1734 |
<value type="string" key="packKeys"></value> |
1735 | 1735 |
<value type="int" key="partitionCount">0</value> |
1736 |
<value _ptr_="0xbc6b480" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
|
|
1736 |
<value _ptr_="0xb2d50c0" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
|
|
1737 | 1737 |
<value type="string" key="partitionExpression"></value> |
1738 | 1738 |
<value type="string" key="partitionType"></value> |
1739 | 1739 |
<value type="string" key="password"></value> |
... | ... | |
1748 | 1748 |
<value type="string" key="tableDataDir"></value> |
1749 | 1749 |
<value type="string" key="tableEngine">InnoDB</value> |
1750 | 1750 |
<value type="string" key="tableIndexDir"></value> |
1751 |
<value _ptr_="0xbc6b420" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
|
|
1751 |
<value _ptr_="0xb2d5060" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
|
|
1752 | 1752 |
<value type="int" key="isStub">0</value> |
1753 | 1753 |
<value type="int" key="isSystem">0</value> |
1754 | 1754 |
<value type="int" key="isTemporary">0</value> |
1755 | 1755 |
<value type="string" key="temporaryScope"></value> |
1756 | 1756 |
<value type="int" key="commentedOut">0</value> |
1757 | 1757 |
<value type="string" key="createDate">2013-04-16 14:58</value> |
1758 |
<value _ptr_="0xbc6b168" type="dict" key="customData"/>
|
|
1759 |
<value type="string" key="lastChangeDate">2013-04-17 02:50</value>
|
|
1758 |
<value _ptr_="0xab45250" type="dict" key="customData"/>
|
|
1759 |
<value type="string" key="lastChangeDate">2013-07-26 20:32</value>
|
|
1760 | 1760 |
<value type="int" key="modelOnly">0</value> |
1761 | 1761 |
<value type="string" key="name">taxon_string</value> |
1762 | 1762 |
<link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link> |
1763 | 1763 |
<value type="string" key="temp_sql"></value> |
1764 |
<value type="string" key="comment"></value> |
|
1764 |
<value type="string" key="comment">to get the parsed_taxon_assertion (TNRS result) for a taxon_string, join using taxon_string.string<-taxon_assertion(string)::parsed_taxon_assertion[source='TNRS.version'] (see wiki.vegpath.org/SQL_dotpaths)</value>
|
|
1765 | 1765 |
<value type="string" key="oldName">taxon_string</value> |
1766 | 1766 |
</value> |
1767 | 1767 |
<value type="object" struct-name="db.mysql.Table" id="be8fb202-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x1a403946"> |
1768 | 1768 |
<value type="string" key="avgRowLength"></value> |
1769 | 1769 |
<value type="int" key="checksum">0</value> |
1770 |
<value _ptr_="0xb4e9a50" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
|
|
1770 |
<value _ptr_="0xb2d5a68" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
|
|
1771 | 1771 |
<value type="object" struct-name="db.mysql.Column" id="be8fb5ae-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183"> |
1772 | 1772 |
<value type="int" key="autoIncrement">0</value> |
1773 | 1773 |
<value type="string" key="characterSetName"></value> |
1774 |
<value _ptr_="0xb4e7e70" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1774 |
<value _ptr_="0xb2d6470" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1775 | 1775 |
<value type="string" key="collationName"></value> |
1776 | 1776 |
<value type="string" key="datatypeExplicitParams"></value> |
1777 | 1777 |
<value type="string" key="defaultValue"></value> |
1778 | 1778 |
<value type="int" key="defaultValueIsNull">0</value> |
1779 |
<value _ptr_="0xb4e81d0" type="list" content-type="string" key="flags"/>
|
|
1779 |
<value _ptr_="0xb2d6798" type="list" content-type="string" key="flags"/>
|
|
1780 | 1780 |
<value type="int" key="isNotNull">1</value> |
1781 | 1781 |
<value type="int" key="length">767</value> |
1782 | 1782 |
<value type="int" key="precision">-1</value> |
... | ... | |
1790 | 1790 |
<value type="object" struct-name="db.mysql.Column" id="be8fb7a2-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183"> |
1791 | 1791 |
<value type="int" key="autoIncrement">0</value> |
1792 | 1792 |
<value type="string" key="characterSetName"></value> |
1793 |
<value _ptr_="0xb4e8320" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1793 |
<value _ptr_="0xb2d68e8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1794 | 1794 |
<value type="string" key="collationName"></value> |
1795 | 1795 |
<value type="string" key="datatypeExplicitParams"></value> |
1796 | 1796 |
<value type="string" key="defaultValue"></value> |
1797 | 1797 |
<value type="int" key="defaultValueIsNull">1</value> |
1798 |
<value _ptr_="0xb4ecfb8" type="list" content-type="string" key="flags"/>
|
|
1798 |
<value _ptr_="0xb2d6c10" type="list" content-type="string" key="flags"/>
|
|
1799 | 1799 |
<value type="int" key="isNotNull">0</value> |
1800 | 1800 |
<value type="int" key="length">767</value> |
1801 | 1801 |
<value type="int" key="precision">-1</value> |
... | ... | |
1809 | 1809 |
<value type="object" struct-name="db.mysql.Column" id="4c32a89c-a76a-11e2-92a3-080027bcf912" struct-checksum="0x783b5183"> |
1810 | 1810 |
<value type="int" key="autoIncrement">0</value> |
1811 | 1811 |
<value type="string" key="characterSetName"></value> |
1812 |
<value _ptr_="0xb4ed108" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1812 |
<value _ptr_="0xb2d6d60" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1813 | 1813 |
<value type="string" key="collationName"></value> |
1814 | 1814 |
<value type="string" key="datatypeExplicitParams"></value> |
1815 | 1815 |
<value type="string" key="defaultValue"></value> |
1816 | 1816 |
<value type="int" key="defaultValueIsNull">0</value> |
1817 |
<value _ptr_="0xb4ed488" type="list" content-type="string" key="flags"/>
|
|
1817 |
<value _ptr_="0xb2d7088" type="list" content-type="string" key="flags"/>
|
|
1818 | 1818 |
<value type="int" key="isNotNull">0</value> |
1819 | 1819 |
<value type="int" key="length">-1</value> |
1820 | 1820 |
<value type="int" key="precision">-1</value> |
... | ... | |
1828 | 1828 |
<value type="object" struct-name="db.mysql.Column" id="782db00a-a782-11e2-afd5-080027bcf912" struct-checksum="0x783b5183"> |
1829 | 1829 |
<value type="int" key="autoIncrement">0</value> |
1830 | 1830 |
<value type="string" key="characterSetName"></value> |
1831 |
<value _ptr_="0xb4ed5d8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1831 |
<value _ptr_="0xb2d71d8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1832 | 1832 |
<value type="string" key="collationName"></value> |
1833 | 1833 |
<value type="string" key="datatypeExplicitParams">('hstore')</value> |
1834 | 1834 |
<value type="string" key="defaultValue"></value> |
1835 | 1835 |
<value type="int" key="defaultValueIsNull">0</value> |
1836 |
<value _ptr_="0xb4ee038" type="list" content-type="string" key="flags"/>
|
|
1836 |
<value _ptr_="0xb2d7500" type="list" content-type="string" key="flags"/>
|
|
1837 | 1837 |
<value type="int" key="isNotNull">0</value> |
1838 | 1838 |
<value type="int" key="length">-1</value> |
1839 | 1839 |
<value type="int" key="precision">-1</value> |
... | ... | |
1849 | 1849 |
<value type="string" key="defaultCharacterSetName">utf8</value> |
1850 | 1850 |
<value type="string" key="defaultCollationName">utf8_bin</value> |
1851 | 1851 |
<value type="int" key="delayKeyWrite">0</value> |
1852 |
<value _ptr_="0xb4e7bd0" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
|
|
1852 |
<value _ptr_="0xb2d6210" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
|
|
1853 | 1853 |
<value type="object" struct-name="db.mysql.ForeignKey" id="be8fc08a-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x70a8fc40"> |
1854 | 1854 |
<link type="object" struct-name="db.mysql.Table" key="referencedTable">be8d17d6-a6e0-11e2-95e9-080027bcf912</link> |
1855 |
<value _ptr_="0xb4ee1b0" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
1855 |
<value _ptr_="0xb2d7678" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
1856 | 1856 |
<link type="object">be8fb5ae-a6e0-11e2-95e9-080027bcf912</link> |
1857 | 1857 |
</value> |
1858 | 1858 |
<value type="int" key="deferability">0</value> |
... | ... | |
1862 | 1862 |
<value type="int" key="many">0</value> |
1863 | 1863 |
<value type="int" key="modelOnly">0</value> |
1864 | 1864 |
<link type="object" struct-name="db.Table" key="owner">be8fb202-a6e0-11e2-95e9-080027bcf912</link> |
1865 |
<value _ptr_="0xb4ee518" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
1865 |
<value _ptr_="0xb2d7968" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
1866 | 1866 |
<link type="object">be8d1ac4-a6e0-11e2-95e9-080027bcf912</link> |
1867 | 1867 |
</value> |
1868 | 1868 |
<value type="int" key="referencedMandatory">1</value> |
... | ... | |
1873 | 1873 |
</value> |
1874 | 1874 |
<value type="object" struct-name="db.mysql.ForeignKey" id="a3e070f8-a77c-11e2-afd5-080027bcf912" struct-checksum="0x70a8fc40"> |
1875 | 1875 |
<link type="object" struct-name="db.mysql.Table" key="referencedTable">1832712c-a77d-11e2-afd5-080027bcf912</link> |
1876 |
<value _ptr_="0xb4ee588" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
1876 |
<value _ptr_="0xb2d79d8" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
1877 | 1877 |
<link type="object">be8fb7a2-a6e0-11e2-95e9-080027bcf912</link> |
1878 | 1878 |
</value> |
1879 | 1879 |
<value type="int" key="deferability">0</value> |
... | ... | |
1883 | 1883 |
<value type="int" key="many">1</value> |
1884 | 1884 |
<value type="int" key="modelOnly">0</value> |
1885 | 1885 |
<link type="object" struct-name="db.Table" key="owner">be8fb202-a6e0-11e2-95e9-080027bcf912</link> |
1886 |
<value _ptr_="0xb4ee910" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
1886 |
<value _ptr_="0xb2d7cc8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
1887 | 1887 |
<link type="object">18327370-a77d-11e2-afd5-080027bcf912</link> |
1888 | 1888 |
</value> |
1889 | 1889 |
<value type="int" key="referencedMandatory">1</value> |
... | ... | |
1893 | 1893 |
<value type="string" key="oldName">fk_parsed_taxon_assertion_taxon_name1</value> |
1894 | 1894 |
</value> |
1895 | 1895 |
</value> |
1896 |
<value _ptr_="0xb4e7c20" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
|
|
1896 |
<value _ptr_="0xb2d6240" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
|
|
1897 | 1897 |
<value type="object" struct-name="db.mysql.Index" id="be8fb98c-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a"> |
1898 |
<value _ptr_="0xb4ee9a0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
1898 |
<value _ptr_="0xb2d7d38" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
1899 | 1899 |
<value type="object" struct-name="db.mysql.IndexColumn" id="be8fbbb2-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x62630b3c"> |
1900 | 1900 |
<value type="int" key="columnLength">0</value> |
1901 | 1901 |
<value type="string" key="comment"></value> |
... | ... | |
1918 | 1918 |
<link type="object" struct-name="GrtObject" key="owner">be8fb202-a6e0-11e2-95e9-080027bcf912</link> |
1919 | 1919 |
</value> |
1920 | 1920 |
<value type="object" struct-name="db.mysql.Index" id="9b6b7d6a-ad0c-11e2-b309-080027bcf912" struct-checksum="0x309b847a"> |
1921 |
<value _ptr_="0xb4e8ec0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
1921 |
<value _ptr_="0xb2d80a0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
1922 | 1922 |
<value type="object" struct-name="db.mysql.IndexColumn" id="9b6c8c14-ad0c-11e2-b309-080027bcf912" struct-checksum="0x62630b3c"> |
1923 | 1923 |
<value type="int" key="columnLength">0</value> |
1924 | 1924 |
<value type="string" key="comment"></value> |
... | ... | |
1948 | 1948 |
<value type="string" key="nextAutoInc"></value> |
1949 | 1949 |
<value type="string" key="packKeys"></value> |
1950 | 1950 |
<value type="int" key="partitionCount">0</value> |
1951 |
<value _ptr_="0xb4e7cd0" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
|
|
1951 |
<value _ptr_="0xb2d62d0" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
|
|
1952 | 1952 |
<value type="string" key="partitionExpression"></value> |
1953 | 1953 |
<value type="string" key="partitionType"></value> |
1954 | 1954 |
<value type="string" key="password"></value> |
... | ... | |
1963 | 1963 |
<value type="string" key="tableDataDir"></value> |
1964 | 1964 |
<value type="string" key="tableEngine">InnoDB</value> |
1965 | 1965 |
<value type="string" key="tableIndexDir"></value> |
1966 |
<value _ptr_="0xb4e7c70" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
|
|
1966 |
<value _ptr_="0xb2d6270" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
|
|
1967 | 1967 |
<value type="int" key="isStub">0</value> |
1968 | 1968 |
<value type="int" key="isSystem">0</value> |
1969 | 1969 |
<value type="int" key="isTemporary">0</value> |
1970 | 1970 |
<value type="string" key="temporaryScope"></value> |
1971 | 1971 |
<value type="int" key="commentedOut">0</value> |
1972 | 1972 |
<value type="string" key="createDate">2013-04-16 14:58</value> |
1973 |
<value _ptr_="0xb4ea0d8" type="dict" key="customData"/>
|
|
1973 |
<value _ptr_="0xab45510" type="dict" key="customData"/>
|
|
1974 | 1974 |
<value type="string" key="lastChangeDate">2013-04-24 11:27</value> |
1975 | 1975 |
<value type="int" key="modelOnly">0</value> |
1976 | 1976 |
<value type="string" key="name">parsed_taxon_assertion</value> |
... | ... | |
1982 | 1982 |
<value type="object" struct-name="db.mysql.Table" id="be8e9930-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x1a403946"> |
1983 | 1983 |
<value type="string" key="avgRowLength"></value> |
1984 | 1984 |
<value type="int" key="checksum">0</value> |
1985 |
<value _ptr_="0xb4e95a0" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
|
|
1985 |
<value _ptr_="0xb2d86d0" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
|
|
1986 | 1986 |
<value type="object" struct-name="db.mysql.Column" id="be8e9bba-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183"> |
1987 | 1987 |
<value type="int" key="autoIncrement">0</value> |
1988 | 1988 |
<value type="string" key="characterSetName"></value> |
1989 |
<value _ptr_="0xbc6a080" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1989 |
<value _ptr_="0xb2d90d8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
1990 | 1990 |
<value type="string" key="collationName"></value> |
1991 | 1991 |
<value type="string" key="datatypeExplicitParams"></value> |
1992 | 1992 |
<value type="string" key="defaultValue"></value> |
1993 | 1993 |
<value type="int" key="defaultValueIsNull">0</value> |
1994 |
<value _ptr_="0xbc6a3e0" type="list" content-type="string" key="flags"/>
|
|
1994 |
<value _ptr_="0xb2d9400" type="list" content-type="string" key="flags"/>
|
|
1995 | 1995 |
<value type="int" key="isNotNull">1</value> |
1996 | 1996 |
<value type="int" key="length">767</value> |
1997 | 1997 |
<value type="int" key="precision">-1</value> |
... | ... | |
2005 | 2005 |
<value type="object" struct-name="db.mysql.Column" id="3c9e6a14-a90f-11e2-8576-080027bcf912" struct-checksum="0x783b5183"> |
2006 | 2006 |
<value type="int" key="autoIncrement">0</value> |
2007 | 2007 |
<value type="string" key="characterSetName"></value> |
2008 |
<value _ptr_="0xbc6a530" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
2008 |
<value _ptr_="0xb2d9550" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
2009 | 2009 |
<value type="string" key="collationName"></value> |
2010 | 2010 |
<value type="string" key="datatypeExplicitParams"></value> |
2011 | 2011 |
<value type="string" key="defaultValue"></value> |
2012 | 2012 |
<value type="int" key="defaultValueIsNull">0</value> |
2013 |
<value _ptr_="0xbc6a890" type="list" content-type="string" key="flags"/>
|
|
2013 |
<value _ptr_="0xb2d9878" type="list" content-type="string" key="flags"/>
|
|
2014 | 2014 |
<value type="int" key="isNotNull">1</value> |
2015 | 2015 |
<value type="int" key="length">767</value> |
2016 | 2016 |
<value type="int" key="precision">-1</value> |
... | ... | |
2024 | 2024 |
<value type="object" struct-name="db.mysql.Column" id="dc8d1c42-ad19-11e2-9d85-080027bcf912" struct-checksum="0x783b5183"> |
2025 | 2025 |
<value type="int" key="autoIncrement">0</value> |
2026 | 2026 |
<value type="string" key="characterSetName"></value> |
2027 |
<value _ptr_="0xb4ea918" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
2027 |
<value _ptr_="0xb2d99c8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
|
2028 | 2028 |
<value type="string" key="collationName"></value> |
2029 | 2029 |
<value type="string" key="datatypeExplicitParams">('hstore')</value> |
2030 | 2030 |
<value type="string" key="defaultValue"></value> |
2031 | 2031 |
<value type="int" key="defaultValueIsNull">0</value> |
2032 |
<value _ptr_="0xb4eac98" type="list" content-type="string" key="flags"/>
|
|
2032 |
<value _ptr_="0xb2d9cf0" type="list" content-type="string" key="flags"/>
|
|
2033 | 2033 |
<value type="int" key="isNotNull">0</value> |
2034 | 2034 |
<value type="int" key="length">-1</value> |
2035 | 2035 |
<value type="int" key="precision">-1</value> |
... | ... | |
2045 | 2045 |
<value type="string" key="defaultCharacterSetName">utf8</value> |
2046 | 2046 |
<value type="string" key="defaultCollationName">utf8_bin</value> |
2047 | 2047 |
<value type="int" key="delayKeyWrite">0</value> |
2048 |
<value _ptr_="0xbc69de0" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
|
|
2048 |
<value _ptr_="0xb2d8e78" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
|
|
2049 | 2049 |
<value type="object" struct-name="db.mysql.ForeignKey" id="be8ea0f6-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x70a8fc40"> |
2050 | 2050 |
<link type="object" struct-name="db.mysql.Table" key="referencedTable">16537a20-a7a7-11e2-8ba6-080027bcf912</link> |
2051 |
<value _ptr_="0xb4eae10" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
2051 |
<value _ptr_="0xb2d9e68" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
2052 | 2052 |
<link type="object">be8e9bba-a6e0-11e2-95e9-080027bcf912</link> |
2053 | 2053 |
</value> |
2054 | 2054 |
<value type="int" key="deferability">0</value> |
... | ... | |
2058 | 2058 |
<value type="int" key="many">0</value> |
2059 | 2059 |
<value type="int" key="modelOnly">0</value> |
2060 | 2060 |
<link type="object" struct-name="db.Table" key="owner">be8e9930-a6e0-11e2-95e9-080027bcf912</link> |
2061 |
<value _ptr_="0xb4eb178" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
2061 |
<value _ptr_="0xb2da158" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
2062 | 2062 |
<link type="object">16537d54-a7a7-11e2-8ba6-080027bcf912</link> |
2063 | 2063 |
</value> |
2064 | 2064 |
<value type="int" key="referencedMandatory">1</value> |
... | ... | |
2069 | 2069 |
</value> |
2070 | 2070 |
<value type="object" struct-name="db.mysql.ForeignKey" id="3c9e685c-a90f-11e2-8576-080027bcf912" struct-checksum="0x70a8fc40"> |
2071 | 2071 |
<link type="object" struct-name="db.mysql.Table" key="referencedTable">1832712c-a77d-11e2-afd5-080027bcf912</link> |
2072 |
<value _ptr_="0xb4eb1e8" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
2072 |
<value _ptr_="0xb2da1c8" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
2073 | 2073 |
<link type="object">3c9e6a14-a90f-11e2-8576-080027bcf912</link> |
2074 | 2074 |
</value> |
2075 | 2075 |
<value type="int" key="deferability">0</value> |
... | ... | |
2079 | 2079 |
<value type="int" key="many">1</value> |
2080 | 2080 |
<value type="int" key="modelOnly">0</value> |
2081 | 2081 |
<link type="object" struct-name="db.Table" key="owner">be8e9930-a6e0-11e2-95e9-080027bcf912</link> |
2082 |
<value _ptr_="0xb4eb570" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
2082 |
<value _ptr_="0xb2da4b8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
2083 | 2083 |
<link type="object">18327370-a77d-11e2-afd5-080027bcf912</link> |
2084 | 2084 |
</value> |
2085 | 2085 |
<value type="int" key="referencedMandatory">1</value> |
... | ... | |
2089 | 2089 |
<value type="string" key="oldName">fk_aggregate_observation_taxon_name1</value> |
2090 | 2090 |
</value> |
2091 | 2091 |
</value> |
2092 |
<value _ptr_="0xbc69e30" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
|
|
2092 |
<value _ptr_="0xb2d8ea8" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
|
|
2093 | 2093 |
<value type="object" struct-name="db.mysql.Index" id="be8e9d90-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a"> |
2094 |
<value _ptr_="0xb4eb600" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
2094 |
<value _ptr_="0xb2da528" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
2095 | 2095 |
<value type="object" struct-name="db.mysql.IndexColumn" id="63c4ca14-ac45-11e2-820d-080027bcf912" struct-checksum="0x62630b3c"> |
2096 | 2096 |
<value type="int" key="columnLength">0</value> |
2097 | 2097 |
<value type="string" key="comment"></value> |
... | ... | |
2114 | 2114 |
<link type="object" struct-name="GrtObject" key="owner">be8e9930-a6e0-11e2-95e9-080027bcf912</link> |
2115 | 2115 |
</value> |
2116 | 2116 |
<value type="object" struct-name="db.mysql.Index" id="a622b3dc-ad0b-11e2-b309-080027bcf912" struct-checksum="0x309b847a"> |
2117 |
<value _ptr_="0xbc80290" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
2117 |
<value _ptr_="0xb2da890" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
2118 | 2118 |
<value type="object" struct-name="db.mysql.IndexColumn" id="a623e720-ad0b-11e2-b309-080027bcf912" struct-checksum="0x62630b3c"> |
2119 | 2119 |
<value type="int" key="columnLength">0</value> |
2120 | 2120 |
<value type="string" key="comment"></value> |
... | ... | |
2144 | 2144 |
<value type="string" key="nextAutoInc"></value> |
2145 | 2145 |
<value type="string" key="packKeys"></value> |
2146 | 2146 |
<value type="int" key="partitionCount">0</value> |
2147 |
<value _ptr_="0xbc69ee0" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
|
|
2147 |
<value _ptr_="0xb2d8f38" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
|
|
2148 | 2148 |
<value type="string" key="partitionExpression"></value> |
2149 | 2149 |
<value type="string" key="partitionType"></value> |
2150 | 2150 |
<value type="string" key="password"></value> |
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: taxon_string: documented that to get the parsed_taxon_assertion (TNRS result) for a taxon_string, you would join using the SQL dotpath taxon_string.string<-taxon_assertion(string)::parsed_taxon_assertion[source='TNRS.version'] (see wiki.vegpath.org/SQL_dotpaths). important how-to comments such as this one are now included in the version-controlled MySQL schema file itself, not just the .mwb file and the staging copy on vegbiendev.