Project

General

Profile

« Previous | Next » 

Revision 10501

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: georeferencing: added hstore extender

View differences:

schemas/VegCore/document.mwb.xml
10272 10272 
                      <value type="string" key="oldName">geoplace</value>
10273 10273 
                      <link type="object" struct-name="GrtObject" key="owner">83dbd4da-f6e8-11e2-9cf1-080027bcf912</link>
10274 10274 
                    </value>
10275 
                    <value type="object" struct-name="db.mysql.Column" id="4f2d2f86-f986-11e2-8a2e-080027bcf912" struct-checksum="0x783b5183">
10276 
                      <value type="int" key="autoIncrement">0</value>
10277 
                      <value type="string" key="characterSetName"></value>
10278 
                      <value _ptr_="0xc0b22d0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
10279 
                      <value type="string" key="collationName"></value>
10280 
                      <value type="string" key="datatypeExplicitParams">('hstore')</value>
10281 
                      <value type="string" key="defaultValue"></value>
10282 
                      <value type="int" key="defaultValueIsNull">0</value>
10283 
                      <value _ptr_="0xc0433d0" type="list" content-type="string" key="flags"/>
10284 
                      <value type="int" key="isNotNull">0</value>
10285 
                      <value type="int" key="length">-1</value>
10286 
                      <value type="int" key="precision">-1</value>
10287 
                      <value type="int" key="scale">-1</value>
10288 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.set</link>
10289 
                      <value type="string" key="comment"></value>
10290 
                      <value type="string" key="name">info</value>
10291 
                      <value type="string" key="oldName"></value>
10292 
                      <link type="object" struct-name="GrtObject" key="owner">83dbd4da-f6e8-11e2-9cf1-080027bcf912</link>
10293 
                    </value>
10275 10294 
                  </value>
10276 10295 
                  <value type="string" key="connectionString"></value>
10277 10296 
                  <value type="string" key="defaultCharacterSetName">utf8</value>
......
10486 10505 
                  <value type="int" key="commentedOut">0</value>
10487 10506 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
10488 10507 
                  <value _ptr_="0xac09888" type="dict" key="customData"/>
10489 
                  <value type="string" key="lastChangeDate">2013-07-30 18:00</value>
10508 
                  <value type="string" key="lastChangeDate">2013-07-30 19:10</value>
10490 10509 
                  <value type="int" key="modelOnly">0</value>
10491 10510 
                  <value type="string" key="name">georeferencing</value>
10492 10511 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
12868 12887 
                <value type="real" key="left">3.05e+02</value>
12869 12888 
                <value type="int" key="locked">0</value>
12870 12889 
                <value type="int" key="manualSizing">0</value>
12871 
                <value type="real" key="top">1.75e+02</value>
12890 
                <value type="real" key="top">1.89e+02</value>
12872 12891 
                <value type="real" key="width">1.25e+02</value>
12873 12892 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12874 12893 
                <value type="int" key="visible">1</value>
......
14069 14088 
                <value type="int" key="triggersExpanded">0</value>
14070 14089 
                <value type="string" key="color">#ffcc33</value>
14071 14090 
                <value type="int" key="expanded">1</value>
14072 
                <value type="real" key="height">1.23e+02</value>
14091 
                <value type="real" key="height">1.46e+02</value>
14073 14092 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14074 14093 
                <value type="real" key="left">2.66e+02</value>
14075 14094 
                <value type="int" key="locked">0</value>
14076 14095 
                <value type="int" key="manualSizing">0</value>
14077 
                <value type="real" key="top">1.9e+01</value>
14096 
                <value type="real" key="top">8.e+00</value>
14078 14097 
                <value type="real" key="width">1.36e+02</value>
14079 14098 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
14080 14099 
                <value type="int" key="visible">1</value>
......
14762 14781 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
14763 14782 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
14764 14783 
      <value type="string" key="caption">New Model</value>
14765 
      <value type="string" key="dateChanged">2013-07-30 19:07</value>
14784 
      <value type="string" key="dateChanged">2013-07-30 19:11</value>
14766 14785 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
14767 14786 
      <value type="string" key="description"></value>
14768 14787 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
238 238 
  `input_place` varbinary(767) NOT NULL,
239 239 
  `georeferenced_by` varbinary(767) DEFAULT NULL,
240 240 
  `geoplace` varbinary(767) DEFAULT NULL,
241 
  `info` set('hstore') COLLATE utf8_bin DEFAULT NULL,
241 242 
  PRIMARY KEY (`id`),
242 243 
  KEY `fk_georef_place1_idx` (`input_place`),
243 244 
  KEY `fk_georeferencing_party_list1_idx` (`georeferenced_by`),
schemas/VegCore/VegCore.pg.sql
240 240 
  "input_place" text NOT NULL,
241 241 
  "georeferenced_by" text DEFAULT NULL,
242 242 
  "geoplace" text DEFAULT NULL,
243 
  "info" hstore DEFAULT NULL,
243 244 
  PRIMARY KEY ("id"),
244 245 
  /*KEY "fk_georef_place1_idx" ("input_place")*/CHECK (true),
245 246 
  /*KEY "fk_georeferencing_party_list1_idx" ("georeferenced_by")*/CHECK (true),

Also available in: Unified diff