Project

General

Profile

« Previous | Next » 

Revision 10465

schemas/VegCore/VegCore.ERD.mwb: plot, subplot: added hstore extenders (dimensions, coordinates)

View differences:

schemas/VegCore/document.mwb.xml
5485 5485
                      <value type="string" key="oldName">y_m</value>
5486 5486
                      <link type="object" struct-name="GrtObject" key="owner">be8f67e8-a6e0-11e2-95e9-080027bcf912</link>
5487 5487
                    </value>
5488
                    <value type="object" struct-name="db.mysql.Column" id="d0d97d8a-f6c7-11e2-a35e-080027bcf912" struct-checksum="0x783b5183">
5489
                      <value type="int" key="autoIncrement">0</value>
5490
                      <value type="string" key="characterSetName"></value>
5491
                      <value _ptr_="0xb3a7f00" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
5492
                      <value type="string" key="collationName"></value>
5493
                      <value type="string" key="datatypeExplicitParams">('hstore')</value>
5494
                      <value type="string" key="defaultValue"></value>
5495
                      <value type="int" key="defaultValueIsNull">0</value>
5496
                      <value _ptr_="0xacea240" type="list" content-type="string" key="flags"/>
5497
                      <value type="int" key="isNotNull">0</value>
5498
                      <value type="int" key="length">-1</value>
5499
                      <value type="int" key="precision">-1</value>
5500
                      <value type="int" key="scale">-1</value>
5501
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.set</link>
5502
                      <value type="string" key="comment"></value>
5503
                      <value type="string" key="name">coordinates</value>
5504
                      <value type="string" key="oldName"></value>
5505
                      <link type="object" struct-name="GrtObject" key="owner">be8f67e8-a6e0-11e2-95e9-080027bcf912</link>
5506
                    </value>
5488 5507
                  </value>
5489 5508
                  <value type="string" key="connectionString"></value>
5490 5509
                  <value type="string" key="defaultCharacterSetName">utf8</value>
......
5567 5586
                  <value type="int" key="commentedOut">0</value>
5568 5587
                  <value type="string" key="createDate">2013-04-16 14:58</value>
5569 5588
                  <value _ptr_="0xa3b7860" type="dict" key="customData"/>
5570
                  <value type="string" key="lastChangeDate">2013-04-24 14:31</value>
5589
                  <value type="string" key="lastChangeDate">2013-07-27 07:21</value>
5571 5590
                  <value type="int" key="modelOnly">0</value>
5572 5591
                  <value type="string" key="name">subplot</value>
5573 5592
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
8214 8233
                      <value type="string" key="oldName">footprint_geom_WKT</value>
8215 8234
                      <link type="object" struct-name="GrtObject" key="owner">9f4bd98c-a6fb-11e2-9461-080027bcf912</link>
8216 8235
                    </value>
8236
                    <value type="object" struct-name="db.mysql.Column" id="94ad6c18-f6c7-11e2-a35e-080027bcf912" struct-checksum="0x783b5183">
8237
                      <value type="int" key="autoIncrement">0</value>
8238
                      <value type="string" key="characterSetName"></value>
8239
                      <value _ptr_="0xad54398" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
8240
                      <value type="string" key="collationName"></value>
8241
                      <value type="string" key="datatypeExplicitParams">('hstore')</value>
8242
                      <value type="string" key="defaultValue"></value>
8243
                      <value type="int" key="defaultValueIsNull">0</value>
8244
                      <value _ptr_="0xac6e3a0" type="list" content-type="string" key="flags"/>
8245
                      <value type="int" key="isNotNull">0</value>
8246
                      <value type="int" key="length">-1</value>
8247
                      <value type="int" key="precision">-1</value>
8248
                      <value type="int" key="scale">-1</value>
8249
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.set</link>
8250
                      <value type="string" key="comment"></value>
8251
                      <value type="string" key="name">dimensions</value>
8252
                      <value type="string" key="oldName"></value>
8253
                      <link type="object" struct-name="GrtObject" key="owner">9f4bd98c-a6fb-11e2-9461-080027bcf912</link>
8254
                    </value>
8217 8255
                  </value>
8218 8256
                  <value type="string" key="connectionString"></value>
8219 8257
                  <value type="string" key="defaultCharacterSetName">utf8</value>
......
8297 8335
                  <value type="int" key="commentedOut">0</value>
8298 8336
                  <value type="string" key="createDate">2013-04-16 14:58</value>
8299 8337
                  <value _ptr_="0xa3df5d8" type="dict" key="customData"/>
8300
                  <value type="string" key="lastChangeDate">2013-07-27 07:08</value>
8338
                  <value type="string" key="lastChangeDate">2013-07-27 07:19</value>
8301 8339
                  <value type="int" key="modelOnly">0</value>
8302 8340
                  <value type="string" key="name">plot</value>
8303 8341
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
12341 12379
                <value type="real" key="left">4.97e+02</value>
12342 12380
                <value type="int" key="locked">0</value>
12343 12381
                <value type="int" key="manualSizing">0</value>
12344
                <value type="real" key="top">7.88e+02</value>
12382
                <value type="real" key="top">8.19e+02</value>
12345 12383
                <value type="real" key="width">1.55e+02</value>
12346 12384
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12347 12385
                <value type="int" key="visible">1</value>
......
12356 12394
                <value type="int" key="triggersExpanded">0</value>
12357 12395
                <value type="string" key="color">#ffcc33</value>
12358 12396
                <value type="int" key="expanded">1</value>
12359
                <value type="real" key="height">1.e+02</value>
12397
                <value type="real" key="height">1.23e+02</value>
12360 12398
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12361 12399
                <value type="real" key="left">3.46e+02</value>
12362 12400
                <value type="int" key="locked">0</value>
12363 12401
                <value type="int" key="manualSizing">0</value>
12364
                <value type="real" key="top">6.58e+02</value>
12402
                <value type="real" key="top">6.82e+02</value>
12365 12403
                <value type="real" key="width">9.3e+01</value>
12366 12404
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12367 12405
                <value type="int" key="visible">1</value>
......
12381 12419
                <value type="real" key="left">5.02e+02</value>
12382 12420
                <value type="int" key="locked">0</value>
12383 12421
                <value type="int" key="manualSizing">0</value>
12384
                <value type="real" key="top">1.048e+03</value>
12422
                <value type="real" key="top">1.072e+03</value>
12385 12423
                <value type="real" key="width">1.45e+02</value>
12386 12424
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12387 12425
                <value type="int" key="visible">1</value>
......
12401 12439
                <value type="real" key="left">3.06e+02</value>
12402 12440
                <value type="int" key="locked">0</value>
12403 12441
                <value type="int" key="manualSizing">0</value>
12404
                <value type="real" key="top">8.1e+02</value>
12442
                <value type="real" key="top">8.41e+02</value>
12405 12443
                <value type="real" key="width">1.58e+02</value>
12406 12444
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12407 12445
                <value type="int" key="visible">1</value>
......
12421 12459
                <value type="real" key="left">3.32e+02</value>
12422 12460
                <value type="int" key="locked">0</value>
12423 12461
                <value type="int" key="manualSizing">0</value>
12424
                <value type="real" key="top">9.4e+02</value>
12462
                <value type="real" key="top">9.71e+02</value>
12425 12463
                <value type="real" key="width">1.14e+02</value>
12426 12464
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12427 12465
                <value type="int" key="visible">1</value>
......
13022 13060
                <value type="int" key="triggersExpanded">0</value>
13023 13061
                <value type="string" key="color">#ffcc33</value>
13024 13062
                <value type="int" key="expanded">1</value>
13025
                <value type="real" key="height">1.69e+02</value>
13063
                <value type="real" key="height">1.92e+02</value>
13026 13064
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13027 13065
                <value type="real" key="left">3.3e+02</value>
13028 13066
                <value type="int" key="locked">0</value>
......
14032 14070
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
14033 14071
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
14034 14072
      <value type="string" key="caption">New Model</value>
14035
      <value type="string" key="dateChanged">2013-07-27 07:16</value>
14073
      <value type="string" key="dateChanged">2013-07-27 07:22</value>
14036 14074
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
14037 14075
      <value type="string" key="description"></value>
14038 14076
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
511 511
  `shape` varbinary(767) DEFAULT NULL,
512 512
  `bounding_box_rect` varbinary(767) DEFAULT NULL,
513 513
  `footprint_geom_WKT` varbinary(767) DEFAULT NULL,
514
  `dimensions` set('hstore') COLLATE utf8_bin DEFAULT NULL,
514 515
  PRIMARY KEY (`id`),
515 516
  CONSTRAINT `fk_subplot_place1` FOREIGN KEY (`id`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
516 517
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
......
845 846
  `id` varbinary(767) NOT NULL,
846 847
  `x_m` double DEFAULT NULL,
847 848
  `y_m` double DEFAULT NULL,
849
  `coordinates` set('hstore') COLLATE utf8_bin DEFAULT NULL,
848 850
  PRIMARY KEY (`id`),
849 851
  CONSTRAINT `fk_subplot_plot1` FOREIGN KEY (`id`) REFERENCES `plot` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
850 852
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"subplot, line, or any other subsample  or subdivision of plot" ("SALVIAS":http://salvias.net/Documents/salvias_data_dictionary.html#Plot_data/subplot)';
schemas/VegCore/VegCore.pg.sql
513 513
  "shape" text DEFAULT NULL,
514 514
  "bounding_box_rect" text DEFAULT NULL,
515 515
  "footprint_geom_WKT" text DEFAULT NULL,
516
  "dimensions" hstore DEFAULT NULL,
516 517
  PRIMARY KEY ("id"),
517 518
  /*CONSTRAINT "fk_subplot_place1" FOREIGN KEY ("id") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
518 519
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;
......
847 848
  "id" text NOT NULL,
848 849
  "x_m" double precision DEFAULT NULL,
849 850
  "y_m" double precision DEFAULT NULL,
851
  "coordinates" hstore DEFAULT NULL,
850 852
  PRIMARY KEY ("id"),
851 853
  /*CONSTRAINT "fk_subplot_plot1" FOREIGN KEY ("id") REFERENCES "plot" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
852 854
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"subplot, line, or any other subsample  or subdivision of plot" ("SALVIAS":http://salvias.net/Documents/salvias_data_dictionary.html#Plot_data/subplot)'*/;

Also available in: Unified diff