Project

General

Profile

« Previous | Next » 

Revision 10477

schemas/VegCore/VegCore.ERD.mwb: place: factored optional geocoords, geopath out into separate geoplace table (with both nullable), which validatable_geoplace (renamed from geoplace, with both NOT NULL) extends

View differences:

schemas/VegCore/document.mwb.xml
5362 5362
                      <value type="string" key="oldName">parent</value>
5363 5363
                      <link type="object" struct-name="GrtObject" key="owner">c6723d8a-a7a0-11e2-b667-080027bcf912</link>
5364 5364
                    </value>
5365
                    <value type="object" struct-name="db.mysql.Column" id="c6724334-a7a0-11e2-b667-080027bcf912" struct-checksum="0x783b5183">
5365
                    <value type="object" struct-name="db.mysql.Column" id="7eeac720-f6e2-11e2-b6d1-080027bcf912" struct-checksum="0x783b5183">
5366 5366
                      <value type="int" key="autoIncrement">0</value>
5367 5367
                      <value type="string" key="characterSetName"></value>
5368
                      <value _ptr_="0xb2782a0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
5368
                      <value _ptr_="0xcb66300" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
5369 5369
                      <value type="string" key="collationName"></value>
5370 5370
                      <value type="string" key="datatypeExplicitParams"></value>
5371 5371
                      <value type="string" key="defaultValue"></value>
5372 5372
                      <value type="int" key="defaultValueIsNull">1</value>
5373
                      <value _ptr_="0xb278620" type="list" content-type="string" key="flags"/>
5373
                      <value _ptr_="0xccaac78" type="list" content-type="string" key="flags"/>
5374 5374
                      <value type="int" key="isNotNull">0</value>
5375 5375
                      <value type="int" key="length">767</value>
5376 5376
                      <value type="int" key="precision">-1</value>
5377 5377
                      <value type="int" key="scale">-1</value>
5378 5378
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
5379 5379
                      <value type="string" key="comment"></value>
5380
                      <value type="string" key="name">geocoords</value>
5381
                      <value type="string" key="oldName">geocoords</value>
5380
                      <value type="string" key="name">geoplace</value>
5381
                      <value type="string" key="oldName">geoplace</value>
5382 5382
                      <link type="object" struct-name="GrtObject" key="owner">c6723d8a-a7a0-11e2-b667-080027bcf912</link>
5383 5383
                    </value>
5384
                    <value type="object" struct-name="db.mysql.Column" id="c67244c4-a7a0-11e2-b667-080027bcf912" struct-checksum="0x783b5183">
5385
                      <value type="int" key="autoIncrement">0</value>
5386
                      <value type="string" key="characterSetName"></value>
5387
                      <value _ptr_="0xb278770" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
5388
                      <value type="string" key="collationName"></value>
5389
                      <value type="string" key="datatypeExplicitParams"></value>
5390
                      <value type="string" key="defaultValue"></value>
5391
                      <value type="int" key="defaultValueIsNull">1</value>
5392
                      <value _ptr_="0xb278af0" type="list" content-type="string" key="flags"/>
5393
                      <value type="int" key="isNotNull">0</value>
5394
                      <value type="int" key="length">767</value>
5395
                      <value type="int" key="precision">-1</value>
5396
                      <value type="int" key="scale">-1</value>
5397
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
5398
                      <value type="string" key="comment"></value>
5399
                      <value type="string" key="name">geopath</value>
5400
                      <value type="string" key="oldName">geopath</value>
5401
                      <link type="object" struct-name="GrtObject" key="owner">c6723d8a-a7a0-11e2-b667-080027bcf912</link>
5402
                    </value>
5403 5384
                    <value type="object" struct-name="db.mysql.Column" id="c672467c-a7a0-11e2-b667-080027bcf912" struct-checksum="0x783b5183">
5404 5385
                      <value type="int" key="autoIncrement">0</value>
5405 5386
                      <value type="string" key="characterSetName"></value>
......
5444 5425
                  <value type="string" key="defaultCollationName">utf8_bin</value>
5445 5426
                  <value type="int" key="delayKeyWrite">0</value>
5446 5427
                  <value _ptr_="0xb2776a0" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
5447
                    <value type="object" struct-name="db.mysql.ForeignKey" id="c67254b4-a7a0-11e2-b667-080027bcf912" struct-checksum="0x70a8fc40">
5448
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
5449
                      <value _ptr_="0xb279138" type="list" content-type="object" content-struct-name="db.Column" key="columns">
5450
                        <link type="object">c6724000-a7a0-11e2-b667-080027bcf912</link>
5428
                    <value type="object" struct-name="db.mysql.ForeignKey" id="7eeac536-f6e2-11e2-b6d1-080027bcf912" struct-checksum="0x70a8fc40">
5429
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">15161a3e-f6e2-11e2-b6d1-080027bcf912</link>
5430
                      <value _ptr_="0xcb984d0" type="list" content-type="object" content-struct-name="db.Column" key="columns">
5431
                        <link type="object">7eeac720-f6e2-11e2-b6d1-080027bcf912</link>
5451 5432
                      </value>
5452 5433
                      <value type="int" key="deferability">0</value>
5453 5434
                      <value type="string" key="deleteRule">CASCADE</value>
5454
                      <link type="object" struct-name="db.Index" key="index">c6724820-a7a0-11e2-b667-080027bcf912</link>
5455
                      <value type="int" key="mandatory">0</value>
5456
                      <value type="int" key="many">0</value>
5457
                      <value type="int" key="modelOnly">0</value>
5458
                      <link type="object" struct-name="db.Table" key="owner">c6723d8a-a7a0-11e2-b667-080027bcf912</link>
5459
                      <value _ptr_="0xb2794a0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
5460
                        <link type="object">be8cd7b2-a6e0-11e2-95e9-080027bcf912</link>
5461
                      </value>
5462
                      <value type="int" key="referencedMandatory">1</value>
5463
                      <value type="string" key="updateRule">CASCADE</value>
5464
                      <value type="string" key="comment"></value>
5465
                      <value type="string" key="name">fk_place_record1</value>
5466
                      <value type="string" key="oldName">fk_place_record1</value>
5467
                    </value>
5468
                    <value type="object" struct-name="db.mysql.ForeignKey" id="c6725626-a7a0-11e2-b667-080027bcf912" struct-checksum="0x70a8fc40">
5469
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8d4a58-a6e0-11e2-95e9-080027bcf912</link>
5470
                      <value _ptr_="0xb279510" type="list" content-type="object" content-struct-name="db.Column" key="columns">
5471
                        <link type="object">c6724334-a7a0-11e2-b667-080027bcf912</link>
5472
                      </value>
5473
                      <value type="int" key="deferability">0</value>
5474
                      <value type="string" key="deleteRule">CASCADE</value>
5475
                      <link type="object" struct-name="db.Index" key="index">c6724b72-a7a0-11e2-b667-080027bcf912</link>
5435
                      <link type="object" struct-name="db.Index" key="index">7eeadc2e-f6e2-11e2-b6d1-080027bcf912</link>
5476 5436
                      <value type="int" key="mandatory">1</value>
5477 5437
                      <value type="int" key="many">1</value>
5478 5438
                      <value type="int" key="modelOnly">0</value>
5479 5439
                      <link type="object" struct-name="db.Table" key="owner">c6723d8a-a7a0-11e2-b667-080027bcf912</link>
5480
                      <value _ptr_="0xb279898" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
5481
                        <link type="object">be8d4cd8-a6e0-11e2-95e9-080027bcf912</link>
5440
                      <value _ptr_="0xcd64a38" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
5441
                        <link type="object">15162024-f6e2-11e2-b6d1-080027bcf912</link>
5482 5442
                      </value>
5483 5443
                      <value type="int" key="referencedMandatory">0</value>
5484 5444
                      <value type="string" key="updateRule">CASCADE</value>
5485 5445
                      <value type="string" key="comment"></value>
5486
                      <value type="string" key="name">fk_place_coordinates1</value>
5487
                      <value type="string" key="oldName">fk_place_coordinates1</value>
5446
                      <value type="string" key="name">fk_place_geoplace1</value>
5447
                      <value type="string" key="oldName">fk_place_geoplace1</value>
5488 5448
                    </value>
5489 5449
                    <value type="object" struct-name="db.mysql.ForeignKey" id="c6725784-a7a0-11e2-b667-080027bcf912" struct-checksum="0x70a8fc40">
5490 5450
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">c6723d8a-a7a0-11e2-b667-080027bcf912</link>
......
5507 5467
                      <value type="string" key="name">fk_place1</value>
5508 5468
                      <value type="string" key="oldName">fk_place1</value>
5509 5469
                    </value>
5510
                    <value type="object" struct-name="db.mysql.ForeignKey" id="c6725a5e-a7a0-11e2-b667-080027bcf912" struct-checksum="0x70a8fc40">
5511
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">c6722390-a7a0-11e2-b667-080027bcf912</link>
5512
                      <value _ptr_="0xb279d00" type="list" content-type="object" content-struct-name="db.Column" key="columns">
5513
                        <link type="object">c67244c4-a7a0-11e2-b667-080027bcf912</link>
5470
                    <value type="object" struct-name="db.mysql.ForeignKey" id="c67254b4-a7a0-11e2-b667-080027bcf912" struct-checksum="0x70a8fc40">
5471
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
5472
                      <value _ptr_="0xb279138" type="list" content-type="object" content-struct-name="db.Column" key="columns">
5473
                        <link type="object">c6724000-a7a0-11e2-b667-080027bcf912</link>
5514 5474
                      </value>
5515 5475
                      <value type="int" key="deferability">0</value>
5516 5476
                      <value type="string" key="deleteRule">CASCADE</value>
5517
                      <link type="object" struct-name="db.Index" key="index">c6725180-a7a0-11e2-b667-080027bcf912</link>
5518
                      <value type="int" key="mandatory">1</value>
5519
                      <value type="int" key="many">1</value>
5477
                      <link type="object" struct-name="db.Index" key="index">c6724820-a7a0-11e2-b667-080027bcf912</link>
5478
                      <value type="int" key="mandatory">0</value>
5479
                      <value type="int" key="many">0</value>
5520 5480
                      <value type="int" key="modelOnly">0</value>
5521 5481
                      <link type="object" struct-name="db.Table" key="owner">c6723d8a-a7a0-11e2-b667-080027bcf912</link>
5522
                      <value _ptr_="0xb27a088" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
5523
                        <link type="object">c67225de-a7a0-11e2-b667-080027bcf912</link>
5482
                      <value _ptr_="0xb2794a0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
5483
                        <link type="object">be8cd7b2-a6e0-11e2-95e9-080027bcf912</link>
5524 5484
                      </value>
5525
                      <value type="int" key="referencedMandatory">0</value>
5485
                      <value type="int" key="referencedMandatory">1</value>
5526 5486
                      <value type="string" key="updateRule">CASCADE</value>
5527 5487
                      <value type="string" key="comment"></value>
5528
                      <value type="string" key="name">fk_place_place_path1</value>
5529
                      <value type="string" key="oldName">fk_place_place_path1</value>
5488
                      <value type="string" key="name">fk_place_record1</value>
5489
                      <value type="string" key="oldName">fk_place_record1</value>
5530 5490
                    </value>
5531 5491
                  </value>
5532 5492
                  <value _ptr_="0xb2776f0" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
......
5553 5513
                      <value type="string" key="oldName">PRIMARY</value>
5554 5514
                      <link type="object" struct-name="GrtObject" key="owner">c6723d8a-a7a0-11e2-b667-080027bcf912</link>
5555 5515
                    </value>
5556
                    <value type="object" struct-name="db.mysql.Index" id="c6724b72-a7a0-11e2-b667-080027bcf912" struct-checksum="0x309b847a">
5557
                      <value _ptr_="0xb27a4f8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
5558
                        <value type="object" struct-name="db.mysql.IndexColumn" id="c6724d3e-a7a0-11e2-b667-080027bcf912" struct-checksum="0x62630b3c">
5559
                          <value type="int" key="columnLength">0</value>
5560
                          <value type="string" key="comment"></value>
5561
                          <value type="int" key="descend">0</value>
5562
                          <link type="object" struct-name="db.Column" key="referencedColumn">c6724334-a7a0-11e2-b667-080027bcf912</link>
5563
                          <value type="string" key="name"></value>
5564
                          <link type="object" struct-name="GrtObject" key="owner">c6724b72-a7a0-11e2-b667-080027bcf912</link>
5565
                        </value>
5566
                      </value>
5567
                      <value type="string" key="indexKind"></value>
5568
                      <value type="int" key="keyBlockSize">0</value>
5569
                      <value type="string" key="withParser"></value>
5570
                      <value type="string" key="comment"></value>
5571
                      <value type="int" key="deferability">0</value>
5572
                      <value type="string" key="indexType">INDEX</value>
5573
                      <value type="int" key="isPrimary">0</value>
5574
                      <value type="string" key="name">fk_place_coordinates1_idx</value>
5575
                      <value type="int" key="unique">0</value>
5576
                      <value type="string" key="oldName">fk_place_coordinates1_idx</value>
5577
                      <link type="object" struct-name="GrtObject" key="owner">c6723d8a-a7a0-11e2-b667-080027bcf912</link>
5578
                    </value>
5579 5516
                    <value type="object" struct-name="db.mysql.Index" id="c6724e7e-a7a0-11e2-b667-080027bcf912" struct-checksum="0x309b847a">
5580 5517
                      <value _ptr_="0xb27abd8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
5581 5518
                        <value type="object" struct-name="db.mysql.IndexColumn" id="c6725040-a7a0-11e2-b667-080027bcf912" struct-checksum="0x62630b3c">
......
5599 5536
                      <value type="string" key="oldName">fk_place1_idx</value>
5600 5537
                      <link type="object" struct-name="GrtObject" key="owner">c6723d8a-a7a0-11e2-b667-080027bcf912</link>
5601 5538
                    </value>
5602
                    <value type="object" struct-name="db.mysql.Index" id="c6725180-a7a0-11e2-b667-080027bcf912" struct-checksum="0x309b847a">
5603
                      <value _ptr_="0xb27b2b8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
5604
                        <value type="object" struct-name="db.mysql.IndexColumn" id="c6725374-a7a0-11e2-b667-080027bcf912" struct-checksum="0x62630b3c">
5539
                    <value type="object" struct-name="db.mysql.Index" id="7eeadc2e-f6e2-11e2-b6d1-080027bcf912" struct-checksum="0x309b847a">
5540
                      <value _ptr_="0xcd3c090" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
5541
                        <value type="object" struct-name="db.mysql.IndexColumn" id="7eeaddaa-f6e2-11e2-b6d1-080027bcf912" struct-checksum="0x62630b3c">
5605 5542
                          <value type="int" key="columnLength">0</value>
5606 5543
                          <value type="string" key="comment"></value>
5607 5544
                          <value type="int" key="descend">0</value>
5608
                          <link type="object" struct-name="db.Column" key="referencedColumn">c67244c4-a7a0-11e2-b667-080027bcf912</link>
5545
                          <link type="object" struct-name="db.Column" key="referencedColumn">7eeac720-f6e2-11e2-b6d1-080027bcf912</link>
5609 5546
                          <value type="string" key="name"></value>
5610
                          <link type="object" struct-name="GrtObject" key="owner">c6725180-a7a0-11e2-b667-080027bcf912</link>
5547
                          <link type="object" struct-name="GrtObject" key="owner">7eeadc2e-f6e2-11e2-b6d1-080027bcf912</link>
5611 5548
                        </value>
5612 5549
                      </value>
5613 5550
                      <value type="string" key="indexKind"></value>
......
5617 5554
                      <value type="int" key="deferability">0</value>
5618 5555
                      <value type="string" key="indexType">INDEX</value>
5619 5556
                      <value type="int" key="isPrimary">0</value>
5620
                      <value type="string" key="name">fk_place_place_path1_idx</value>
5557
                      <value type="string" key="name">fk_place_geoplace1_idx</value>
5621 5558
                      <value type="int" key="unique">0</value>
5622
                      <value type="string" key="oldName">fk_place_place_path1_idx</value>
5559
                      <value type="string" key="oldName">fk_place_geoplace1_idx</value>
5623 5560
                      <link type="object" struct-name="GrtObject" key="owner">c6723d8a-a7a0-11e2-b667-080027bcf912</link>
5624 5561
                    </value>
5625 5562
                  </value>
......
5653 5590
                  <value type="int" key="commentedOut">0</value>
5654 5591
                  <value type="string" key="createDate">2013-04-17 13:52</value>
5655 5592
                  <value _ptr_="0xb277478" type="dict" key="customData"/>
5656
                  <value type="string" key="lastChangeDate">2013-07-27 09:27</value>
5593
                  <value type="string" key="lastChangeDate">2013-07-27 10:38</value>
5657 5594
                  <value type="int" key="modelOnly">0</value>
5658 5595
                  <value type="string" key="name">place</value>
5659 5596
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
5940 5877
                      <value type="string" key="name">fk_geovalidation_coordinates1</value>
5941 5878
                      <value type="string" key="oldName">fk_geovalidation_coordinates1</value>
5942 5879
                    </value>
5880
                    <value type="object" struct-name="db.mysql.ForeignKey" id="705abb34-f6e2-11e2-b6d1-080027bcf912" struct-checksum="0x70a8fc40">
5881
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">15161a3e-f6e2-11e2-b6d1-080027bcf912</link>
5882
                      <value _ptr_="0xc7188a0" type="list" content-type="object" content-struct-name="db.Column" key="columns">
5883
                        <link type="object">be8f7b0c-a6e0-11e2-95e9-080027bcf912</link>
5884
                      </value>
5885
                      <value type="int" key="deferability">0</value>
5886
                      <value type="string" key="deleteRule">CASCADE</value>
5887
                      <value type="int" key="mandatory">1</value>
5888
                      <value type="int" key="many">1</value>
5889
                      <value type="int" key="modelOnly">0</value>
5890
                      <link type="object" struct-name="db.Table" key="owner">be8f78aa-a6e0-11e2-95e9-080027bcf912</link>
5891
                      <value _ptr_="0xc758e80" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
5892
                        <link type="object">15162024-f6e2-11e2-b6d1-080027bcf912</link>
5893
                      </value>
5894
                      <value type="int" key="referencedMandatory">1</value>
5895
                      <value type="string" key="updateRule">CASCADE</value>
5896
                      <value type="string" key="comment"></value>
5897
                      <value type="string" key="name">fk_validatable_geoplace_geoplace1</value>
5898
                      <value type="string" key="oldName">fk_validatable_geoplace_geoplace1</value>
5899
                    </value>
5943 5900
                  </value>
5944 5901
                  <value _ptr_="0xb27e8e8" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
5945 5902
                    <value type="object" struct-name="db.mysql.Index" id="be8f8084-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a">
......
6073 6030
                  <value type="int" key="commentedOut">0</value>
6074 6031
                  <value type="string" key="createDate">2013-04-16 14:58</value>
6075 6032
                  <value _ptr_="0xb27e670" type="dict" key="customData"/>
6076
                  <value type="string" key="lastChangeDate">2013-07-27 09:05</value>
6033
                  <value type="string" key="lastChangeDate">2013-07-27 10:30</value>
6077 6034
                  <value type="int" key="modelOnly">0</value>
6078
                  <value type="string" key="name">geoplace</value>
6035
                  <value type="string" key="name">validatable_geoplace</value>
6079 6036
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
6080 6037
                  <value type="string" key="temp_sql"></value>
6081 6038
                  <value type="string" key="comment"></value>
6082
                  <value type="string" key="oldName">geoplace</value>
6039
                  <value type="string" key="oldName">validatable_geoplace</value>
6083 6040
                </value>
6084 6041
                <value type="object" struct-name="db.mysql.Table" id="c672f914-a7a0-11e2-b667-080027bcf912" struct-checksum="0x1a403946">
6085 6042
                  <value type="string" key="avgRowLength"></value>
......
10354 10311
                  <value type="string" key="comment"></value>
10355 10312
                  <value type="string" key="oldName">sampling_event</value>
10356 10313
                </value>
10314
                <value type="object" struct-name="db.mysql.Table" id="15161a3e-f6e2-11e2-b6d1-080027bcf912" struct-checksum="0x1a403946">
10315
                  <value type="string" key="avgRowLength"></value>
10316
                  <value type="int" key="checksum">0</value>
10317
                  <value _ptr_="0xc743318" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
10318
                    <value type="object" struct-name="db.mysql.Column" id="15162024-f6e2-11e2-b6d1-080027bcf912" struct-checksum="0x783b5183">
10319
                      <value type="int" key="autoIncrement">0</value>
10320
                      <value type="string" key="characterSetName"></value>
10321
                      <value _ptr_="0xcc2d998" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
10322
                      <value type="string" key="collationName"></value>
10323
                      <value type="string" key="datatypeExplicitParams"></value>
10324
                      <value type="string" key="defaultValue"></value>
10325
                      <value type="int" key="defaultValueIsNull">0</value>
10326
                      <value _ptr_="0xcbfa908" type="list" content-type="string" key="flags"/>
10327
                      <value type="int" key="isNotNull">1</value>
10328
                      <value type="int" key="length">767</value>
10329
                      <value type="int" key="precision">-1</value>
10330
                      <value type="int" key="scale">-1</value>
10331
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
10332
                      <value type="string" key="comment"></value>
10333
                      <value type="string" key="name">id</value>
10334
                      <value type="string" key="oldName">id</value>
10335
                      <link type="object" struct-name="GrtObject" key="owner">15161a3e-f6e2-11e2-b6d1-080027bcf912</link>
10336
                    </value>
10337
                    <value type="object" struct-name="db.mysql.Column" id="15162484-f6e2-11e2-b6d1-080027bcf912" struct-checksum="0x783b5183">
10338
                      <value type="int" key="autoIncrement">0</value>
10339
                      <value type="string" key="characterSetName"></value>
10340
                      <value _ptr_="0xcd23910" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
10341
                      <value type="string" key="collationName"></value>
10342
                      <value type="string" key="datatypeExplicitParams"></value>
10343
                      <value type="string" key="defaultValue"></value>
10344
                      <value type="int" key="defaultValueIsNull">0</value>
10345
                      <value _ptr_="0xcd940c0" type="list" content-type="string" key="flags"/>
10346
                      <value type="int" key="isNotNull">0</value>
10347
                      <value type="int" key="length">767</value>
10348
                      <value type="int" key="precision">-1</value>
10349
                      <value type="int" key="scale">-1</value>
10350
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
10351
                      <value type="string" key="comment"></value>
10352
                      <value type="string" key="name">geocoords</value>
10353
                      <value type="string" key="oldName">geocoords</value>
10354
                      <link type="object" struct-name="GrtObject" key="owner">15161a3e-f6e2-11e2-b6d1-080027bcf912</link>
10355
                    </value>
10356
                    <value type="object" struct-name="db.mysql.Column" id="15162704-f6e2-11e2-b6d1-080027bcf912" struct-checksum="0x783b5183">
10357
                      <value type="int" key="autoIncrement">0</value>
10358
                      <value type="string" key="characterSetName"></value>
10359
                      <value _ptr_="0xc8b5658" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
10360
                      <value type="string" key="collationName"></value>
10361
                      <value type="string" key="datatypeExplicitParams"></value>
10362
                      <value type="string" key="defaultValue"></value>
10363
                      <value type="int" key="defaultValueIsNull">0</value>
10364
                      <value _ptr_="0xcc3d948" type="list" content-type="string" key="flags"/>
10365
                      <value type="int" key="isNotNull">0</value>
10366
                      <value type="int" key="length">767</value>
10367
                      <value type="int" key="precision">-1</value>
10368
                      <value type="int" key="scale">-1</value>
10369
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
10370
                      <value type="string" key="comment"></value>
10371
                      <value type="string" key="name">geopath</value>
10372
                      <value type="string" key="oldName">geopath</value>
10373
                      <link type="object" struct-name="GrtObject" key="owner">15161a3e-f6e2-11e2-b6d1-080027bcf912</link>
10374
                    </value>
10375
                  </value>
10376
                  <value type="string" key="connectionString"></value>
10377
                  <value type="string" key="defaultCharacterSetName">utf8</value>
10378
                  <value type="string" key="defaultCollationName">utf8_bin</value>
10379
                  <value type="int" key="delayKeyWrite">0</value>
10380
                  <value _ptr_="0xcbdb020" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
10381
                    <value type="object" struct-name="db.mysql.ForeignKey" id="1516297a-f6e2-11e2-b6d1-080027bcf912" struct-checksum="0x70a8fc40">
10382
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">c6722390-a7a0-11e2-b667-080027bcf912</link>
10383
                      <value _ptr_="0xc4d7ae0" type="list" content-type="object" content-struct-name="db.Column" key="columns">
10384
                        <link type="object">15162704-f6e2-11e2-b6d1-080027bcf912</link>
10385
                      </value>
10386
                      <value type="int" key="deferability">0</value>
10387
                      <value type="string" key="deleteRule">CASCADE</value>
10388
                      <link type="object" struct-name="db.Index" key="index">151635b4-f6e2-11e2-b6d1-080027bcf912</link>
10389
                      <value type="int" key="mandatory">1</value>
10390
                      <value type="int" key="many">1</value>
10391
                      <value type="int" key="modelOnly">0</value>
10392
                      <link type="object" struct-name="db.Table" key="owner">15161a3e-f6e2-11e2-b6d1-080027bcf912</link>
10393
                      <value _ptr_="0xc70f048" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
10394
                        <link type="object">c67225de-a7a0-11e2-b667-080027bcf912</link>
10395
                      </value>
10396
                      <value type="int" key="referencedMandatory">0</value>
10397
                      <value type="string" key="updateRule">CASCADE</value>
10398
                      <value type="string" key="comment"></value>
10399
                      <value type="string" key="name">fk_geovalidation_place_path10</value>
10400
                      <value type="string" key="oldName">fk_geovalidation_place_path10</value>
10401
                    </value>
10402
                    <value type="object" struct-name="db.mysql.ForeignKey" id="15162bc8-f6e2-11e2-b6d1-080027bcf912" struct-checksum="0x70a8fc40">
10403
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8d4a58-a6e0-11e2-95e9-080027bcf912</link>
10404
                      <value _ptr_="0xce3fd80" type="list" content-type="object" content-struct-name="db.Column" key="columns">
10405
                        <link type="object">15162484-f6e2-11e2-b6d1-080027bcf912</link>
10406
                      </value>
10407
                      <value type="int" key="deferability">0</value>
10408
                      <value type="string" key="deleteRule">CASCADE</value>
10409
                      <link type="object" struct-name="db.Index" key="index">151638a2-f6e2-11e2-b6d1-080027bcf912</link>
10410
                      <value type="int" key="mandatory">1</value>
10411
                      <value type="int" key="many">1</value>
10412
                      <value type="int" key="modelOnly">0</value>
10413
                      <link type="object" struct-name="db.Table" key="owner">15161a3e-f6e2-11e2-b6d1-080027bcf912</link>
10414
                      <value _ptr_="0xc8b54c8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
10415
                        <link type="object">be8d4cd8-a6e0-11e2-95e9-080027bcf912</link>
10416
                      </value>
10417
                      <value type="int" key="referencedMandatory">0</value>
10418
                      <value type="string" key="updateRule">CASCADE</value>
10419
                      <value type="string" key="comment"></value>
10420
                      <value type="string" key="name">fk_geovalidation_coordinates10</value>
10421
                      <value type="string" key="oldName">fk_geovalidation_coordinates10</value>
10422
                    </value>
10423
                  </value>
10424
                  <value _ptr_="0xbfe4bb8" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
10425
                    <value type="object" struct-name="db.mysql.Index" id="15162dbc-f6e2-11e2-b6d1-080027bcf912" struct-checksum="0x309b847a">
10426
                      <value _ptr_="0xce00700" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
10427
                        <value type="object" struct-name="db.mysql.IndexColumn" id="15163320-f6e2-11e2-b6d1-080027bcf912" struct-checksum="0x62630b3c">
10428
                          <value type="int" key="columnLength">0</value>
10429
                          <value type="string" key="comment"></value>
10430
                          <value type="int" key="descend">0</value>
10431
                          <link type="object" struct-name="db.Column" key="referencedColumn">15162024-f6e2-11e2-b6d1-080027bcf912</link>
10432
                          <value type="string" key="name"></value>
10433
                          <link type="object" struct-name="GrtObject" key="owner">15162dbc-f6e2-11e2-b6d1-080027bcf912</link>
10434
                        </value>
10435
                      </value>
10436
                      <value type="string" key="indexKind"></value>
10437
                      <value type="int" key="keyBlockSize">0</value>
10438
                      <value type="string" key="withParser"></value>
10439
                      <value type="string" key="comment"></value>
10440
                      <value type="int" key="deferability">0</value>
10441
                      <value type="string" key="indexType">PRIMARY</value>
10442
                      <value type="int" key="isPrimary">1</value>
10443
                      <value type="string" key="name">PRIMARY</value>
10444
                      <value type="int" key="unique">0</value>
10445
                      <value type="string" key="oldName">PRIMARY</value>
10446
                      <link type="object" struct-name="GrtObject" key="owner">15161a3e-f6e2-11e2-b6d1-080027bcf912</link>
10447
                    </value>
10448
                    <value type="object" struct-name="db.mysql.Index" id="151635b4-f6e2-11e2-b6d1-080027bcf912" struct-checksum="0x309b847a">
10449
                      <value _ptr_="0xca289d0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
10450
                        <value type="object" struct-name="db.mysql.IndexColumn" id="151636ea-f6e2-11e2-b6d1-080027bcf912" struct-checksum="0x62630b3c">
10451
                          <value type="int" key="columnLength">0</value>
10452
                          <value type="string" key="comment"></value>
10453
                          <value type="int" key="descend">0</value>
10454
                          <link type="object" struct-name="db.Column" key="referencedColumn">15162704-f6e2-11e2-b6d1-080027bcf912</link>
10455
                          <value type="string" key="name"></value>
10456
                          <link type="object" struct-name="GrtObject" key="owner">151635b4-f6e2-11e2-b6d1-080027bcf912</link>
10457
                        </value>
10458
                      </value>
10459
                      <value type="string" key="indexKind"></value>
10460
                      <value type="int" key="keyBlockSize">0</value>
10461
                      <value type="string" key="withParser"></value>
10462
                      <value type="string" key="comment"></value>
10463
                      <value type="int" key="deferability">0</value>
10464
                      <value type="string" key="indexType">INDEX</value>
10465
                      <value type="int" key="isPrimary">0</value>
10466
                      <value type="string" key="name">fk_geovalidation_place_path1_idx</value>
10467
                      <value type="int" key="unique">0</value>
10468
                      <value type="string" key="oldName">fk_geovalidation_place_path1_idx</value>
10469
                      <link type="object" struct-name="GrtObject" key="owner">15161a3e-f6e2-11e2-b6d1-080027bcf912</link>
10470
                    </value>
10471
                    <value type="object" struct-name="db.mysql.Index" id="151638a2-f6e2-11e2-b6d1-080027bcf912" struct-checksum="0x309b847a">
10472
                      <value _ptr_="0xc45ac00" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
10473
                        <value type="object" struct-name="db.mysql.IndexColumn" id="151639c4-f6e2-11e2-b6d1-080027bcf912" struct-checksum="0x62630b3c">
10474
                          <value type="int" key="columnLength">0</value>
10475
                          <value type="string" key="comment"></value>
10476
                          <value type="int" key="descend">0</value>
10477
                          <link type="object" struct-name="db.Column" key="referencedColumn">15162484-f6e2-11e2-b6d1-080027bcf912</link>
10478
                          <value type="string" key="name"></value>
10479
                          <link type="object" struct-name="GrtObject" key="owner">151638a2-f6e2-11e2-b6d1-080027bcf912</link>
10480
                        </value>
10481
                      </value>
10482
                      <value type="string" key="indexKind"></value>
10483
                      <value type="int" key="keyBlockSize">0</value>
10484
                      <value type="string" key="withParser"></value>
10485
                      <value type="string" key="comment"></value>
10486
                      <value type="int" key="deferability">0</value>
10487
                      <value type="string" key="indexType">INDEX</value>
10488
                      <value type="int" key="isPrimary">0</value>
10489
                      <value type="string" key="name">fk_geovalidation_coordinates1_idx</value>
10490
                      <value type="int" key="unique">0</value>
10491
                      <value type="string" key="oldName">fk_geovalidation_coordinates1_idx</value>
10492
                      <link type="object" struct-name="GrtObject" key="owner">15161a3e-f6e2-11e2-b6d1-080027bcf912</link>
10493
                    </value>
10494
                    <value type="object" struct-name="db.mysql.Index" id="15163b68-f6e2-11e2-b6d1-080027bcf912" struct-checksum="0x309b847a">
10495
                      <value _ptr_="0xca09488" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
10496
                        <value type="object" struct-name="db.mysql.IndexColumn" id="15163c80-f6e2-11e2-b6d1-080027bcf912" struct-checksum="0x62630b3c">
10497
                          <value type="int" key="columnLength">0</value>
10498
                          <value type="string" key="comment"></value>
10499
                          <value type="int" key="descend">0</value>
10500
                          <link type="object" struct-name="db.Column" key="referencedColumn">15162704-f6e2-11e2-b6d1-080027bcf912</link>
10501
                          <value type="string" key="name"></value>
10502
                          <link type="object" struct-name="GrtObject" key="owner">15163b68-f6e2-11e2-b6d1-080027bcf912</link>
10503
                        </value>
10504
                        <value type="object" struct-name="db.mysql.IndexColumn" id="15163dac-f6e2-11e2-b6d1-080027bcf912" struct-checksum="0x62630b3c">
10505
                          <value type="int" key="columnLength">0</value>
10506
                          <value type="string" key="comment"></value>
10507
                          <value type="int" key="descend">0</value>
10508
                          <link type="object" struct-name="db.Column" key="referencedColumn">15162484-f6e2-11e2-b6d1-080027bcf912</link>
10509
                          <value type="string" key="name"></value>
10510
                          <link type="object" struct-name="GrtObject" key="owner">15163b68-f6e2-11e2-b6d1-080027bcf912</link>
10511
                        </value>
10512
                      </value>
10513
                      <value type="string" key="indexKind"></value>
10514
                      <value type="int" key="keyBlockSize">0</value>
10515
                      <value type="string" key="withParser"></value>
10516
                      <value type="string" key="comment"></value>
10517
                      <value type="int" key="deferability">0</value>
10518
                      <value type="string" key="indexType">UNIQUE</value>
10519
                      <value type="int" key="isPrimary">0</value>
10520
                      <value type="string" key="name">validatable_place_unique</value>
10521
                      <value type="int" key="unique">1</value>
10522
                      <value type="string" key="oldName">validatable_place_unique</value>
10523
                      <link type="object" struct-name="GrtObject" key="owner">15161a3e-f6e2-11e2-b6d1-080027bcf912</link>
10524
                    </value>
10525
                  </value>
10526
                  <value type="string" key="maxRows"></value>
10527
                  <value type="string" key="mergeInsert"></value>
10528
                  <value type="string" key="mergeUnion"></value>
10529
                  <value type="string" key="minRows"></value>
10530
                  <value type="string" key="nextAutoInc"></value>
10531
                  <value type="string" key="packKeys"></value>
10532
                  <value type="int" key="partitionCount">0</value>
10533
                  <value _ptr_="0xce63ea8" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
10534
                  <value type="string" key="partitionExpression"></value>
10535
                  <value type="string" key="partitionType"></value>
10536
                  <value type="string" key="password"></value>
10537
                  <link type="object" struct-name="db.mysql.Index" key="primaryKey">15162dbc-f6e2-11e2-b6d1-080027bcf912</link>
10538
                  <value type="string" key="raidChunkSize"></value>
10539
                  <value type="string" key="raidChunks"></value>
10540
                  <value type="string" key="raidType"></value>
10541
                  <value type="string" key="rowFormat"></value>
10542
                  <value type="int" key="subpartitionCount">0</value>
10543
                  <value type="string" key="subpartitionExpression"></value>
10544
                  <value type="string" key="subpartitionType"></value>
10545
                  <value type="string" key="tableDataDir"></value>
10546
                  <value type="string" key="tableEngine">InnoDB</value>
10547
                  <value type="string" key="tableIndexDir"></value>
10548
                  <value _ptr_="0xca14d48" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
10549
                  <value type="int" key="isStub">0</value>
10550
                  <value type="int" key="isSystem">0</value>
10551
                  <value type="int" key="isTemporary">0</value>
10552
                  <value type="string" key="temporaryScope"></value>
10553
                  <value type="int" key="commentedOut">0</value>
10554
                  <value type="string" key="createDate">2013-04-16 14:58</value>
10555
                  <value _ptr_="0xcd006b8" type="dict" key="customData"/>
10556
                  <value type="string" key="lastChangeDate">2013-07-27 10:31</value>
10557
                  <value type="int" key="modelOnly">0</value>
10558
                  <value type="string" key="name">geoplace</value>
10559
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
10560
                  <value type="string" key="temp_sql"></value>
10561
                  <value type="string" key="comment"></value>
10562
                  <value type="string" key="oldName">geoplace</value>
10563
                </value>
10357 10564
              </value>
10358 10565
              <value _ptr_="0xb23a648" type="list" content-type="object" content-struct-name="db.mysql.View" key="views"/>
10359 10566
              <value type="string" key="defaultCharacterSetName">utf8</value>
......
11228 11435
                <value type="int" key="visible">1</value>
11229 11436
                <value type="string" key="name"></value>
11230 11437
              </value>
11231
              <value type="object" struct-name="workbench.physical.Connection" id="d16d5666-a7a0-11e2-b667-080027bcf912" struct-checksum="0x9baebc92">
11232
                <value type="string" key="caption">fk_place_coordinates1</value>
11233
                <value type="real" key="captionXOffs">0.e+00</value>
11234
                <value type="real" key="captionYOffs">0.e+00</value>
11235
                <value type="string" key="comment"></value>
11236
                <value type="real" key="endCaptionXOffs">0.e+00</value>
11237
                <value type="real" key="endCaptionYOffs">0.e+00</value>
11238
                <value type="string" key="extraCaption"></value>
11239
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
11240
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
11241
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">c6725626-a7a0-11e2-b667-080027bcf912</link>
11242
                <value type="real" key="middleSegmentOffset">0.e+00</value>
11243
                <value type="real" key="startCaptionXOffs">0.e+00</value>
11244
                <value type="real" key="startCaptionYOffs">0.e+00</value>
11245
                <value type="int" key="drawSplit">0</value>
11246
                <link type="object" struct-name="model.Figure" key="endFigure">2EDCE9EA-B246-4F71-9D67-BD04855202B6</link>
11247
                <link type="object" struct-name="model.Figure" key="startFigure">286AE59E-913E-4F00-A662-693F828EFB6F</link>
11248
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
11249
                <value type="int" key="visible">1</value>
11250
                <value type="string" key="name"></value>
11251
              </value>
11252 11438
              <value type="object" struct-name="workbench.physical.Connection" id="d16d7448-a7a0-11e2-b667-080027bcf912" struct-checksum="0x9baebc92">
11253 11439
                <value type="string" key="caption">fk_place1</value>
11254 11440
                <value type="real" key="captionXOffs">0.e+00</value>
......
11270 11456
                <value type="int" key="visible">1</value>
11271 11457
                <value type="string" key="name"></value>
11272 11458
              </value>
11273
              <value type="object" struct-name="workbench.physical.Connection" id="d16d8cf8-a7a0-11e2-b667-080027bcf912" struct-checksum="0x9baebc92">
11274
                <value type="string" key="caption">fk_place_place_path1</value>
11275
                <value type="real" key="captionXOffs">0.e+00</value>
11276
                <value type="real" key="captionYOffs">0.e+00</value>
11277
                <value type="string" key="comment"></value>
11278
                <value type="real" key="endCaptionXOffs">0.e+00</value>
11279
                <value type="real" key="endCaptionYOffs">0.e+00</value>
11280
                <value type="string" key="extraCaption"></value>
11281
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
11282
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
11283
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">c6725a5e-a7a0-11e2-b667-080027bcf912</link>
11284
                <value type="real" key="middleSegmentOffset">0.e+00</value>
11285
                <value type="real" key="startCaptionXOffs">0.e+00</value>
11286
                <value type="real" key="startCaptionYOffs">0.e+00</value>
11287
                <value type="int" key="drawSplit">0</value>
11288
                <link type="object" struct-name="model.Figure" key="endFigure">2E4C661D-4F5E-45E6-9290-A20ABF3BCBCD</link>
11289
                <link type="object" struct-name="model.Figure" key="startFigure">286AE59E-913E-4F00-A662-693F828EFB6F</link>
11290
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
11291
                <value type="int" key="visible">1</value>
11292
                <value type="string" key="name"></value>
11293
              </value>
11294 11459
              <value type="object" struct-name="workbench.physical.Connection" id="d16df3aa-a7a0-11e2-b667-080027bcf912" struct-checksum="0x9baebc92">
11295 11460
                <value type="string" key="caption">fk_event_place1</value>
11296 11461
                <value type="real" key="captionXOffs">0.e+00</value>
......
11347 11512
                <value type="real" key="middleSegmentOffset">0.e+00</value>
11348 11513
                <value type="real" key="startCaptionXOffs">0.e+00</value>
11349 11514
                <value type="real" key="startCaptionYOffs">0.e+00</value>
11350
                <value type="int" key="drawSplit">0</value>
11515
                <value type="int" key="drawSplit">1</value>
11351 11516
                <link type="object" struct-name="model.Figure" key="endFigure">2E4C661D-4F5E-45E6-9290-A20ABF3BCBCD</link>
11352 11517
                <link type="object" struct-name="model.Figure" key="startFigure">988D9E58-7324-4913-A132-BF8CAD6050C8</link>
11353 11518
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
......
11368 11533
                <value type="real" key="middleSegmentOffset">0.e+00</value>
11369 11534
                <value type="real" key="startCaptionXOffs">0.e+00</value>
11370 11535
                <value type="real" key="startCaptionYOffs">0.e+00</value>
11371
                <value type="int" key="drawSplit">0</value>
11536
                <value type="int" key="drawSplit">1</value>
11372 11537
                <link type="object" struct-name="model.Figure" key="endFigure">2EDCE9EA-B246-4F71-9D67-BD04855202B6</link>
11373 11538
                <link type="object" struct-name="model.Figure" key="startFigure">988D9E58-7324-4913-A132-BF8CAD6050C8</link>
11374 11539
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
......
12635 12800
                <value type="int" key="visible">1</value>
12636 12801
                <value type="string" key="name"></value>
12637 12802
              </value>
12803
              <value type="object" struct-name="workbench.physical.Connection" id="1516da78-f6e2-11e2-b6d1-080027bcf912" struct-checksum="0x9baebc92">
12804
                <value type="string" key="caption">fk_geovalidation_place_path10</value>
12805
                <value type="real" key="captionXOffs">0.e+00</value>
12806
                <value type="real" key="captionYOffs">0.e+00</value>
12807
                <value type="string" key="comment"></value>
12808
                <value type="real" key="endCaptionXOffs">0.e+00</value>
12809
                <value type="real" key="endCaptionYOffs">0.e+00</value>
12810
                <value type="string" key="extraCaption"></value>
12811
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
12812
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
12813
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">1516297a-f6e2-11e2-b6d1-080027bcf912</link>
12814
                <value type="real" key="middleSegmentOffset">0.e+00</value>
12815
                <value type="real" key="startCaptionXOffs">0.e+00</value>
12816
                <value type="real" key="startCaptionYOffs">0.e+00</value>
12817
                <value type="int" key="drawSplit">0</value>
12818
                <link type="object" struct-name="model.Figure" key="endFigure">2E4C661D-4F5E-45E6-9290-A20ABF3BCBCD</link>
12819
                <link type="object" struct-name="model.Figure" key="startFigure">15165544-f6e2-11e2-b6d1-080027bcf912</link>
12820
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12821
                <value type="int" key="visible">1</value>
12822
                <value type="string" key="name"></value>
12823
              </value>
12824
              <value type="object" struct-name="workbench.physical.Connection" id="1516e496-f6e2-11e2-b6d1-080027bcf912" struct-checksum="0x9baebc92">
12825
                <value type="string" key="caption">fk_geovalidation_coordinates10</value>
12826
                <value type="real" key="captionXOffs">0.e+00</value>
12827
                <value type="real" key="captionYOffs">0.e+00</value>
12828
                <value type="string" key="comment"></value>
12829
                <value type="real" key="endCaptionXOffs">0.e+00</value>
12830
                <value type="real" key="endCaptionYOffs">0.e+00</value>
12831
                <value type="string" key="extraCaption"></value>
12832
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
12833
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
12834
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">15162bc8-f6e2-11e2-b6d1-080027bcf912</link>
12835
                <value type="real" key="middleSegmentOffset">0.e+00</value>
12836
                <value type="real" key="startCaptionXOffs">0.e+00</value>
12837
                <value type="real" key="startCaptionYOffs">0.e+00</value>
12838
                <value type="int" key="drawSplit">0</value>
12839
                <link type="object" struct-name="model.Figure" key="endFigure">2EDCE9EA-B246-4F71-9D67-BD04855202B6</link>
12840
                <link type="object" struct-name="model.Figure" key="startFigure">15165544-f6e2-11e2-b6d1-080027bcf912</link>
12841
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12842
                <value type="int" key="visible">1</value>
12843
                <value type="string" key="name"></value>
12844
              </value>
12845
              <value type="object" struct-name="workbench.physical.Connection" id="705ad164-f6e2-11e2-b6d1-080027bcf912" struct-checksum="0x9baebc92">
12846
                <value type="string" key="caption">fk_validatable_geoplace_geoplace1</value>
12847
                <value type="real" key="captionXOffs">0.e+00</value>
12848
                <value type="real" key="captionYOffs">0.e+00</value>
12849
                <value type="string" key="comment"></value>
12850
                <value type="real" key="endCaptionXOffs">0.e+00</value>
12851
                <value type="real" key="endCaptionYOffs">0.e+00</value>
12852
                <value type="string" key="extraCaption"></value>
12853
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
12854
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
12855
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">705abb34-f6e2-11e2-b6d1-080027bcf912</link>
12856
                <value type="real" key="middleSegmentOffset">0.e+00</value>
12857
                <value type="real" key="startCaptionXOffs">0.e+00</value>
12858
                <value type="real" key="startCaptionYOffs">0.e+00</value>
12859
                <value type="int" key="drawSplit">0</value>
12860
                <link type="object" struct-name="model.Figure" key="endFigure">15165544-f6e2-11e2-b6d1-080027bcf912</link>
12861
                <link type="object" struct-name="model.Figure" key="startFigure">988D9E58-7324-4913-A132-BF8CAD6050C8</link>
12862
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12863
                <value type="int" key="visible">1</value>
12864
                <value type="string" key="name"></value>
12865
              </value>
12866
              <value type="object" struct-name="workbench.physical.Connection" id="7eeae3ae-f6e2-11e2-b6d1-080027bcf912" struct-checksum="0x9baebc92">
12867
                <value type="string" key="caption">fk_place_geoplace1</value>
12868
                <value type="real" key="captionXOffs">0.e+00</value>
12869
                <value type="real" key="captionYOffs">0.e+00</value>
12870
                <value type="string" key="comment"></value>
12871
                <value type="real" key="endCaptionXOffs">0.e+00</value>
12872
                <value type="real" key="endCaptionYOffs">0.e+00</value>
12873
                <value type="string" key="extraCaption"></value>
12874
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
12875
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
12876
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">7eeac536-f6e2-11e2-b6d1-080027bcf912</link>
12877
                <value type="real" key="middleSegmentOffset">0.e+00</value>
12878
                <value type="real" key="startCaptionXOffs">0.e+00</value>
12879
                <value type="real" key="startCaptionYOffs">0.e+00</value>
12880
                <value type="int" key="drawSplit">0</value>
12881
                <link type="object" struct-name="model.Figure" key="endFigure">15165544-f6e2-11e2-b6d1-080027bcf912</link>
12882
                <link type="object" struct-name="model.Figure" key="startFigure">286AE59E-913E-4F00-A662-693F828EFB6F</link>
12883
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12884
                <value type="int" key="visible">1</value>
12885
                <value type="string" key="name"></value>
12886
              </value>
12638 12887
            </value>
12639 12888
            <value type="string" key="description"></value>
12640 12889
            <value _ptr_="0xb2c2dd8" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
12704 12953
                <value type="int" key="expanded">1</value>
12705 12954
                <value type="real" key="height">1.e+02</value>
12706 12955
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12707
                <value type="real" key="left">4.18e+02</value>
12956
                <value type="real" key="left">4.36e+02</value>
12708 12957
                <value type="int" key="locked">0</value>
12709 12958
                <value type="int" key="manualSizing">0</value>
12710
                <value type="real" key="top">1.51e+02</value>
12959
                <value type="real" key="top">1.7e+01</value>
12711 12960
                <value type="real" key="width">1.11e+02</value>
12712 12961
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12713 12962
                <value type="int" key="visible">1</value>
......
12727 12976
                <value type="real" key="left">5.6e+02</value>
12728 12977
                <value type="int" key="locked">0</value>
12729 12978
                <value type="int" key="manualSizing">0</value>
12730
                <value type="real" key="top">3.77e+02</value>
12979
                <value type="real" key="top">3.68e+02</value>
12731 12980
                <value type="real" key="width">8.1e+01</value>
12732 12981
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12733 12982
                <value type="int" key="visible">1</value>
......
12742 12991
                <value type="int" key="triggersExpanded">0</value>
12743 12992
                <value type="string" key="color">#ffcc33</value>
12744 12993
                <value type="int" key="expanded">1</value>
12745
                <value type="real" key="height">1.69e+02</value>
12994
                <value type="real" key="height">1.46e+02</value>
12746 12995
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12747
                <value type="real" key="left">4.34e+02</value>
12996
                <value type="real" key="left">4.33e+02</value>
12748 12997
                <value type="int" key="locked">0</value>
12749 12998
                <value type="int" key="manualSizing">0</value>
12750
                <value type="real" key="top">2.84e+02</value>
12999
                <value type="real" key="top">3.01e+02</value>
12751 13000
                <value type="real" key="width">8.e+01</value>
12752 13001
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12753 13002
                <value type="int" key="visible">1</value>
......
12767 13016
                <value type="real" key="left">6.78e+02</value>
12768 13017
                <value type="int" key="locked">0</value>
12769 13018
                <value type="int" key="manualSizing">0</value>
12770
                <value type="real" key="top">4.54e+02</value>
13019
                <value type="real" key="top">4.45e+02</value>
12771 13020
                <value type="real" key="width">9.e+01</value>
12772 13021
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12773 13022
                <value type="int" key="visible">1</value>
......
12784 13033
                <value type="int" key="expanded">1</value>
12785 13034
                <value type="real" key="height">1.92e+02</value>
12786 13035
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12787
                <value type="real" key="left">2.57e+02</value>
13036
                <value type="real" key="left">2.82e+02</value>
12788 13037
                <value type="int" key="locked">0</value>
12789 13038
                <value type="int" key="manualSizing">0</value>
12790
                <value type="real" key="top">6.e+01</value>
13039
                <value type="real" key="top">1.46e+02</value>
12791 13040
                <value type="real" key="width">9.6e+01</value>
12792 13041
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12793 13042
                <value type="int" key="visible">1</value>
......
12824 13073
                <value type="int" key="expanded">1</value>
12825 13074
                <value type="real" key="height">1.e+02</value>
12826 13075
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12827
                <value type="real" key="left">4.23e+02</value>
13076
                <value type="real" key="left">5.64e+02</value>
12828 13077
                <value type="int" key="locked">0</value>
12829 13078
                <value type="int" key="manualSizing">0</value>
12830
                <value type="real" key="top">2.3e+01</value>
12831
                <value type="real" key="width">1.02e+02</value>
13079
                <value type="real" key="top">2.24e+02</value>
13080
                <value type="real" key="width">1.7e+02</value>
12832 13081
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12833 13082
                <value type="int" key="visible">1</value>
12834
                <value type="string" key="name">geoplace</value>
13083
                <value type="string" key="name">validatable_geoplace</value>
12835 13084
              </value>
12836 13085
              <value type="object" struct-name="workbench.physical.TableFigure" id="FF3A48D7-490E-4E77-B97B-1F51BF51FA8A" struct-checksum="0x3b14eccb">
12837 13086
                <value type="int" key="columnsExpanded">1</value>
......
13590 13839
                <value type="int" key="expanded">1</value>
13591 13840
                <value type="real" key="height">1.69e+02</value>
13592 13841
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13593
                <value type="real" key="left">5.88e+02</value>
13842
                <value type="real" key="left">5.98e+02</value>
13594 13843
                <value type="int" key="locked">0</value>
13595 13844
                <value type="int" key="manualSizing">0</value>
13596
                <value type="real" key="top">1.4e+01</value>
13845
                <value type="real" key="top">1.1e+01</value>
13597 13846
                <value type="real" key="width">1.4e+02</value>
13598 13847
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13599 13848
                <value type="int" key="visible">1</value>
......
13899 14148
                <value type="int" key="visible">1</value>
13900 14149
                <value type="string" key="name">sampling_event</value>
13901 14150
              </value>
14151
              <value type="object" struct-name="workbench.physical.TableFigure" id="15165544-f6e2-11e2-b6d1-080027bcf912" struct-checksum="0x3b14eccb">
14152
                <value type="int" key="columnsExpanded">1</value>
14153
                <value type="int" key="foreignKeysExpanded">0</value>
14154
                <value type="int" key="indicesExpanded">0</value>
14155
                <value type="int" key="summarizeDisplay">-1</value>
14156
                <link type="object" struct-name="db.Table" key="table">15161a3e-f6e2-11e2-b6d1-080027bcf912</link>
14157
                <value type="int" key="triggersExpanded">0</value>
14158
                <value type="string" key="color">#ffcc33</value>
14159
                <value type="int" key="expanded">1</value>
14160
                <value type="real" key="height">1.e+02</value>
14161
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14162
                <value type="real" key="left">4.22e+02</value>
14163
                <value type="int" key="locked">0</value>
14164
                <value type="int" key="manualSizing">0</value>
14165
                <value type="real" key="top">1.6e+02</value>
14166
                <value type="real" key="width">1.02e+02</value>
14167
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
14168
                <value type="int" key="visible">1</value>
14169
                <value type="string" key="name">geoplace</value>
14170
              </value>
13902 14171
            </value>
13903 14172
            <value type="real" key="height">1.2865e+03</value>
13904 14173
            <value _ptr_="0xb2c2e28" type="list" content-type="object" content-struct-name="model.Layer" key="layers">
......
14009 14278
                <link type="object">9d6cbe7a-f678-11e2-9716-080027bcf912</link>
14010 14279
                <link type="object">59b361b0-f6ba-11e2-aebb-080027bcf912</link>
14011 14280
                <link type="object">7f17a4b0-f6c0-11e2-af44-080027bcf912</link>
14281
                <link type="object">15165544-f6e2-11e2-b6d1-080027bcf912</link>
14012 14282
              </value>
14013 14283
              <value _ptr_="0xb2fec80" type="list" content-type="object" content-struct-name="model.Group" key="groups"/>
14014 14284
              <value type="real" key="height">1.2865e+03</value>
......
14036 14306
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
14037 14307
        <value _ptr_="0xb2394c0" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
14038 14308
        <value _ptr_="0xaa26720" type="dict" key="syncProfiles">
14039
          <value type="object" struct-name="db.mgmt.SyncProfile" id="5457deb8-f6e1-11e2-b6d1-080027bcf912" struct-checksum="0xc64972c2" key="">
14040
            <value _ptr_="0xca0cf50" type="dict" key="lastKnownDBNames">
14309
          <value type="object" struct-name="db.mgmt.SyncProfile" id="96eb31dc-f6e4-11e2-b6d1-080027bcf912" struct-checksum="0xc64972c2" key="">
14310
            <value _ptr_="0xd23ecb8" type="dict" key="lastKnownDBNames">
14041 14311
              <value type="string" key="049df920-a91b-11e2-bdec-080027bcf912">organization</value>
14042 14312
              <value type="string" key="049dfc5e-a91b-11e2-bdec-080027bcf912">id</value>
14043 14313
              <value type="string" key="049dff1a-a91b-11e2-bdec-080027bcf912">info</value>
......
14057 14327
              <value type="string" key="0ab99812-a7a1-11e2-b667-080027bcf912">fk_individual_observation_individual1</value>
14058 14328
              <value type="string" key="110c72d2-a73f-11e2-9fbf-080027bcf912">stem_observation_unique</value>
14059 14329
              <value type="string" key="11c10cc8-a90c-11e2-8576-080027bcf912">source_unique</value>
14330
              <value type="string" key="15161a3e-f6e2-11e2-b6d1-080027bcf912">geoplace</value>
14331
              <value type="string" key="15162024-f6e2-11e2-b6d1-080027bcf912">id</value>
14332
              <value type="string" key="15162484-f6e2-11e2-b6d1-080027bcf912">geocoords</value>
14333
              <value type="string" key="15162704-f6e2-11e2-b6d1-080027bcf912">geopath</value>
14334
              <value type="string" key="1516297a-f6e2-11e2-b6d1-080027bcf912">fk_geovalidation_place_path10</value>
14335
              <value type="string" key="15162bc8-f6e2-11e2-b6d1-080027bcf912">fk_geovalidation_coordinates10</value>
14336
              <value type="string" key="15162dbc-f6e2-11e2-b6d1-080027bcf912">PRIMARY</value>
14337
              <value type="string" key="151635b4-f6e2-11e2-b6d1-080027bcf912">fk_geovalidation_place_path1_idx</value>
14338
              <value type="string" key="151638a2-f6e2-11e2-b6d1-080027bcf912">fk_geovalidation_coordinates1_idx</value>
14339
              <value type="string" key="15163b68-f6e2-11e2-b6d1-080027bcf912">validatable_place_unique</value>
14060 14340
              <value type="string" key="16537a20-a7a7-11e2-8ba6-080027bcf912">taxon_observation</value>
14061 14341
              <value type="string" key="16537d54-a7a7-11e2-8ba6-080027bcf912">id</value>
14062 14342
              <value type="string" key="16538808-a7a7-11e2-8ba6-080027bcf912">growth_form</value>
......
14215 14495
              <value type="string" key="6ec4a89c-ad05-11e2-b309-080027bcf912">fk_specimen_individual1</value>
14216 14496
              <value type="string" key="6ec4aa86-ad05-11e2-b309-080027bcf912">individual</value>
14217 14497
              <value type="string" key="6ec4c2fa-ad05-11e2-b309-080027bcf912">fk_specimen_individual1_idx</value>
14498
              <value type="string" key="705abb34-f6e2-11e2-b6d1-080027bcf912">fk_validatable_geoplace_geoplace1</value>
14218 14499
              <value type="string" key="74709b22-a795-11e2-84c3-080027bcf912">slope_incline_deg</value>
14219 14500
              <value type="string" key="782db00a-a782-11e2-afd5-080027bcf912">match_info</value>
14501
              <value type="string" key="7eeac536-f6e2-11e2-b6d1-080027bcf912">fk_place_geoplace1</value>
14502
              <value type="string" key="7eeac720-f6e2-11e2-b6d1-080027bcf912">geoplace</value>
14503
              <value type="string" key="7eeadc2e-f6e2-11e2-b6d1-080027bcf912">fk_place_geoplace1_idx</value>
14220 14504
              <value type="string" key="7f176964-f6c0-11e2-af44-080027bcf912">sampling_event</value>
14221 14505
              <value type="string" key="7f176d06-f6c0-11e2-af44-080027bcf912">id</value>
14222 14506
              <value type="string" key="7f177512-f6c0-11e2-af44-080027bcf912">fk_project_event10</value>
......
14357 14641
              <value type="string" key="be8f67e8-a6e0-11e2-95e9-080027bcf912">subplot</value>
14358 14642
              <value type="string" key="be8f6a86-a6e0-11e2-95e9-080027bcf912">id</value>
14359 14643
              <value type="string" key="be8f6c7a-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
14360
              <value type="string" key="be8f78aa-a6e0-11e2-95e9-080027bcf912">geoplace</value>
14644
              <value type="string" key="be8f78aa-a6e0-11e2-95e9-080027bcf912">validatable_geoplace</value>
14361 14645
              <value type="string" key="be8f7b0c-a6e0-11e2-95e9-080027bcf912">id</value>
14362 14646
              <value type="string" key="be8f8084-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
14363 14647
              <value type="string" key="be8fa0fa-a6e0-11e2-95e9-080027bcf912">project</value>
......
14392 14676
              <value type="string" key="c6723d8a-a7a0-11e2-b667-080027bcf912">place</value>
14393 14677
              <value type="string" key="c6724000-a7a0-11e2-b667-080027bcf912">id</value>
14394 14678
              <value type="string" key="c67241b8-a7a0-11e2-b667-080027bcf912">parent</value>
14395
              <value type="string" key="c6724334-a7a0-11e2-b667-080027bcf912">geocoords</value>
14396
              <value type="string" key="c67244c4-a7a0-11e2-b667-080027bcf912">geopath</value>
14397 14679
              <value type="string" key="c672467c-a7a0-11e2-b667-080027bcf912">locality</value>
14398 14680
              <value type="string" key="c6724820-a7a0-11e2-b667-080027bcf912">PRIMARY</value>
14399
              <value type="string" key="c6724b72-a7a0-11e2-b667-080027bcf912">fk_place_coordinates1_idx</value>
14400 14681
              <value type="string" key="c6724e7e-a7a0-11e2-b667-080027bcf912">fk_place1_idx</value>
14401
              <value type="string" key="c6725180-a7a0-11e2-b667-080027bcf912">fk_place_place_path1_idx</value>
14402 14682
              <value type="string" key="c67254b4-a7a0-11e2-b667-080027bcf912">fk_place_record1</value>
14403
              <value type="string" key="c6725626-a7a0-11e2-b667-080027bcf912">fk_place_coordinates1</value>
14404 14683
              <value type="string" key="c6725784-a7a0-11e2-b667-080027bcf912">fk_place1</value>
14405
              <value type="string" key="c6725a5e-a7a0-11e2-b667-080027bcf912">fk_place_place_path1</value>
14406 14684
              <value type="string" key="c672743a-a7a0-11e2-b667-080027bcf912">event</value>
14407 14685
              <value type="string" key="c67276b0-a7a0-11e2-b667-080027bcf912">id</value>
14408 14686
              <value type="string" key="c672785e-a7a0-11e2-b667-080027bcf912">parent</value>
......
14557 14835
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
14558 14836
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
14559 14837
      <value type="string" key="caption">New Model</value>
14560
      <value type="string" key="dateChanged">2013-07-27 10:24</value>
14838
      <value type="string" key="dateChanged">2013-07-27 10:47</value>
14561 14839
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
14562 14840
      <value type="string" key="description"></value>
14563 14841
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
227 227
/*!40000 ALTER TABLE `geopath` ENABLE KEYS */;
228 228

  
229 229
--
230
-- Table structure for table `geoplace`
231
--
232

  
233
/*!40101 SET @saved_cs_client     = @@character_set_client */;
234
/*!40101 SET character_set_client = utf8 */;
235
CREATE TABLE `geoplace` (
236
  `id` varbinary(767) NOT NULL,
237
  `geocoords` varbinary(767) NOT NULL,
238
  `geopath` varbinary(767) NOT NULL,
239
  PRIMARY KEY (`id`),
240
  UNIQUE KEY `validatable_place_unique` (`geopath`,`geocoords`),
241
  KEY `fk_geovalidation_place_path1_idx` (`geopath`),
242
  KEY `fk_geovalidation_coordinates1_idx` (`geocoords`),
243
  CONSTRAINT `fk_geovalidation_place_path1` FOREIGN KEY (`geopath`) REFERENCES `geopath` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
244
  CONSTRAINT `fk_geovalidation_coordinates1` FOREIGN KEY (`geocoords`) REFERENCES `geocoords` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
245
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
246
/*!40101 SET character_set_client = @saved_cs_client */;
247

  
248
--
249
-- Dumping data for table `geoplace`
250
--
251

  
252
/*!40000 ALTER TABLE `geoplace` DISABLE KEYS */;
253
/*!40000 ALTER TABLE `geoplace` ENABLE KEYS */;
254

  
255
--
256 230
-- Table structure for table `geovalidation`
257 231
--
258 232

  
......
268 242
  PRIMARY KEY (`id`),
269 243
  KEY `fk_geovalidation_geoplace1_idx` (`input_geoplace`),
270 244
  KEY `fk_geovalidation_geoplace2_idx` (`scrubbed_geoplace`),
271
  CONSTRAINT `fk_geovalidation_geoplace1` FOREIGN KEY (`input_geoplace`) REFERENCES `geoplace` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
272
  CONSTRAINT `fk_geovalidation_geoplace2` FOREIGN KEY (`scrubbed_geoplace`) REFERENCES `geoplace` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
245
  CONSTRAINT `fk_geovalidation_geoplace1` FOREIGN KEY (`input_geoplace`) REFERENCES `validatable_geoplace` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
246
  CONSTRAINT `fk_geovalidation_geoplace2` FOREIGN KEY (`scrubbed_geoplace`) REFERENCES `validatable_geoplace` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
273 247
  CONSTRAINT `fk_geovalidation_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
274 248
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='The accuracy of the [[VegCore#Coordinates|Coordinates]], taking into account the [[VegCore#Placename|Placename]]';
275 249
/*!40101 SET character_set_client = @saved_cs_client */;
......
452 426
CREATE TABLE `place` (
453 427
  `id` varbinary(767) NOT NULL,
454 428
  `parent` varbinary(767) NOT NULL,
455
  `geocoords` varbinary(767) DEFAULT NULL,
456
  `geopath` varbinary(767) DEFAULT NULL,
429
  `geoplace` varbinary(767) DEFAULT NULL,
457 430
  `locality` varbinary(767) DEFAULT NULL,
458 431
  `coords` set('hstore') COLLATE utf8_bin DEFAULT NULL COMMENT 'for verbatim coordinates, etc.',
459 432
  PRIMARY KEY (`id`),
460
  KEY `fk_place_coordinates1_idx` (`geocoords`),
461 433
  KEY `fk_place1_idx` (`parent`),
462
  KEY `fk_place_place_path1_idx` (`geopath`),
463
  CONSTRAINT `fk_place_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
464
  CONSTRAINT `fk_place_coordinates1` FOREIGN KEY (`geocoords`) REFERENCES `geocoords` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
434
  KEY `fk_place_geoplace1_idx` (`geoplace`),
435
  CONSTRAINT `fk_place_geoplace1` FOREIGN KEY (`geoplace`) REFERENCES `geoplace` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
465 436
  CONSTRAINT `fk_place1` FOREIGN KEY (`parent`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
466
  CONSTRAINT `fk_place_place_path1` FOREIGN KEY (`geopath`) REFERENCES `geopath` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
437
  CONSTRAINT `fk_place_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
467 438
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"A spatial region" ("DwC":http://rs.tdwg.org/dwc/terms/#dcterms:Location) or point';
468 439
/*!40101 SET character_set_client = @saved_cs_client */;
469 440

  
......
1164 1135

  
1165 1136
/*!40000 ALTER TABLE `taxon_string` DISABLE KEYS */;
1166 1137
/*!40000 ALTER TABLE `taxon_string` ENABLE KEYS */;
1138

  
1139
--
1140
-- Table structure for table `validatable_geoplace`
1141
--
1142

  
1143
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1144
/*!40101 SET character_set_client = utf8 */;
1145
CREATE TABLE `validatable_geoplace` (
1146
  `id` varbinary(767) NOT NULL,
1147
  `geocoords` varbinary(767) NOT NULL,
1148
  `geopath` varbinary(767) NOT NULL,
1149
  PRIMARY KEY (`id`),
1150
  UNIQUE KEY `validatable_place_unique` (`geopath`,`geocoords`),
1151
  KEY `fk_geovalidation_place_path1_idx` (`geopath`),
1152
  KEY `fk_geovalidation_coordinates1_idx` (`geocoords`),
1153
  CONSTRAINT `fk_geovalidation_place_path1` FOREIGN KEY (`geopath`) REFERENCES `geopath` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1154
  CONSTRAINT `fk_geovalidation_coordinates1` FOREIGN KEY (`geocoords`) REFERENCES `geocoords` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1155
  CONSTRAINT `fk_validatable_geoplace_geoplace1` FOREIGN KEY (`id`) REFERENCES `geoplace` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1156
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1157
/*!40101 SET character_set_client = @saved_cs_client */;
1158

  
1159
--
1160
-- Dumping data for table `validatable_geoplace`
1161
--
1162

  
1163
/*!40000 ALTER TABLE `validatable_geoplace` DISABLE KEYS */;
1164
/*!40000 ALTER TABLE `validatable_geoplace` ENABLE KEYS */;
1167 1165
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1168 1166

  
1169 1167
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
schemas/VegCore/VegCore.pg.sql
229 229
/*!40000 ALTER TABLE "geopath" ENABLE KEYS */;
230 230

  
231 231
--
232
-- Table structure for table "geoplace"
233
--
234

  
235
/*!40101 SET @saved_cs_client     = @@character_set_client */;
236
/*!40101 SET character_set_client = utf8 */;
237
CREATE TABLE "geoplace" (
238
  "id" text NOT NULL,
239
  "geocoords" text NOT NULL,
240
  "geopath" text NOT NULL,
241
  PRIMARY KEY ("id"),
242
  /*CONSTRAINT "validatable_place_unique" */UNIQUE ("geopath","geocoords"),
243
  /*KEY "fk_geovalidation_place_path1_idx" ("geopath")*/CHECK (true),
244
  /*KEY "fk_geovalidation_coordinates1_idx" ("geocoords")*/CHECK (true),
245
  /*CONSTRAINT "fk_geovalidation_place_path1" FOREIGN KEY ("geopath") REFERENCES "geopath" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
246
  /*CONSTRAINT "fk_geovalidation_coordinates1" FOREIGN KEY ("geocoords") REFERENCES "geocoords" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
247
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;
248
/*!40101 SET character_set_client = @saved_cs_client */;
249

  
250
--
251
-- Dumping data for table "geoplace"
252
--
253

  
254
/*!40000 ALTER TABLE "geoplace" DISABLE KEYS */;
255
/*!40000 ALTER TABLE "geoplace" ENABLE KEYS */;
256

  
257
--
258 232
-- Table structure for table "geovalidation"
259 233
--
260 234

  
......
270 244
  PRIMARY KEY ("id"),
271 245
  /*KEY "fk_geovalidation_geoplace1_idx" ("input_geoplace")*/CHECK (true),
272 246
  /*KEY "fk_geovalidation_geoplace2_idx" ("scrubbed_geoplace")*/CHECK (true),
273
  /*CONSTRAINT "fk_geovalidation_geoplace1" FOREIGN KEY ("input_geoplace") REFERENCES "geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
274
  /*CONSTRAINT "fk_geovalidation_geoplace2" FOREIGN KEY ("scrubbed_geoplace") REFERENCES "geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
247
  /*CONSTRAINT "fk_geovalidation_geoplace1" FOREIGN KEY ("input_geoplace") REFERENCES "validatable_geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
248
  /*CONSTRAINT "fk_geovalidation_geoplace2" FOREIGN KEY ("scrubbed_geoplace") REFERENCES "validatable_geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
275 249
  /*CONSTRAINT "fk_geovalidation_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
276 250
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='The accuracy of the [[VegCore#Coordinates|Coordinates]], taking into account the [[VegCore#Placename|Placename]]'*/;
277 251
/*!40101 SET character_set_client = @saved_cs_client */;
......
454 428
CREATE TABLE "place" (
455 429
  "id" text NOT NULL,
456 430
  "parent" text NOT NULL,
457
  "geocoords" text DEFAULT NULL,
458
  "geopath" text DEFAULT NULL,
431
  "geoplace" text DEFAULT NULL,
459 432
  "locality" text DEFAULT NULL,
460 433
  "coords" hstore DEFAULT NULL /*COMMENT 'for verbatim coordinates, etc.'*/,
461 434
  PRIMARY KEY ("id"),
462
  /*KEY "fk_place_coordinates1_idx" ("geocoords")*/CHECK (true),
463 435
  /*KEY "fk_place1_idx" ("parent")*/CHECK (true),
464
  /*KEY "fk_place_place_path1_idx" ("geopath")*/CHECK (true),
465
  /*CONSTRAINT "fk_place_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
466
  /*CONSTRAINT "fk_place_coordinates1" FOREIGN KEY ("geocoords") REFERENCES "geocoords" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
436
  /*KEY "fk_place_geoplace1_idx" ("geoplace")*/CHECK (true),
437
  /*CONSTRAINT "fk_place_geoplace1" FOREIGN KEY ("geoplace") REFERENCES "geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
467 438
  /*CONSTRAINT "fk_place1" FOREIGN KEY ("parent") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
468
  /*CONSTRAINT "fk_place_place_path1" FOREIGN KEY ("geopath") REFERENCES "geopath" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
439
  /*CONSTRAINT "fk_place_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
469 440
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"A spatial region" ("DwC":http://rs.tdwg.org/dwc/terms/#dcterms:Location) or point'*/;
470 441
/*!40101 SET character_set_client = @saved_cs_client */;
471 442

  
......
1166 1137

  
1167 1138
/*!40000 ALTER TABLE "taxon_string" DISABLE KEYS */;
1168 1139
/*!40000 ALTER TABLE "taxon_string" ENABLE KEYS */;
1140

  
1141
--
1142
-- Table structure for table "validatable_geoplace"
1143
--
1144

  
1145
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1146
/*!40101 SET character_set_client = utf8 */;
1147
CREATE TABLE "validatable_geoplace" (
1148
  "id" text NOT NULL,
1149
  "geocoords" text NOT NULL,
1150
  "geopath" text NOT NULL,
1151
  PRIMARY KEY ("id"),
1152
  /*CONSTRAINT "validatable_place_unique" */UNIQUE ("geopath","geocoords"),
1153
  /*KEY "fk_geovalidation_place_path1_idx" ("geopath")*/CHECK (true),
1154
  /*KEY "fk_geovalidation_coordinates1_idx" ("geocoords")*/CHECK (true),
1155
  /*CONSTRAINT "fk_geovalidation_place_path1" FOREIGN KEY ("geopath") REFERENCES "geopath" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1156
  /*CONSTRAINT "fk_geovalidation_coordinates1" FOREIGN KEY ("geocoords") REFERENCES "geocoords" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1157
  /*CONSTRAINT "fk_validatable_geoplace_geoplace1" FOREIGN KEY ("id") REFERENCES "geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1158
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;
1159
/*!40101 SET character_set_client = @saved_cs_client */;
1160

  
1161
--
1162
-- Dumping data for table "validatable_geoplace"
1163
--
1164

  
1165
/*!40000 ALTER TABLE "validatable_geoplace" DISABLE KEYS */;
1166
/*!40000 ALTER TABLE "validatable_geoplace" ENABLE KEYS */;
1169 1167
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1170 1168

  
1171 1169
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

Also available in: Unified diff