Project

General

Profile

« Previous | Next » 

Revision 11031

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: source.name: require this field (for records, populate it from id_within_dataset)

View differences:

schemas/VegCore/VegCore.pg.sql
704 704 
CREATE TABLE "record" (
705 705 
  "id" text NOT NULL,
706 706 
  "dataset" text NOT NULL,
707 
  "id_within_dataset" text NOT NULL,
707 
  "id_within_dataset" text NOT NULL /*COMMENT 'also put this in source.name'*/,
708 708 
  PRIMARY KEY ("id"),
709 709 
  /*CONSTRAINT "record_unique" */UNIQUE ("dataset","id_within_dataset"),
710 710 
  /*KEY "fk_record_source1_idx" ("dataset")*/CHECK (true),
......
845 845 
/*!40101 SET character_set_client = utf8 */;
846 846 
CREATE TABLE "source" (
847 847 
  "id" text NOT NULL,
848 
  "name" text NOT NULL,
848 849 
  "parent" text DEFAULT NULL,
849 
  "name" text DEFAULT NULL,
850 850 
  "info" hstore DEFAULT NULL,
851 851 
  PRIMARY KEY ("id"),
852 852 
  /*CONSTRAINT "source_unique" */UNIQUE ("parent","name"),
schemas/VegCore/document.mwb.xml
12540 12540 
                      <value type="int" key="precision">-1</value>
12541 12541 
                      <value type="int" key="scale">-1</value>
12542 12542 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
12543 
                      <value type="string" key="comment"></value>
12543 
                      <value type="string" key="comment">also put this in source.name</value>
12544 12544 
                      <value type="string" key="name">id_within_dataset</value>
12545 
                      <value type="string" key="oldName">dataset_record_id</value>
12545 
                      <value type="string" key="oldName">id_within_dataset</value>
12546 12546 
                      <link type="object" struct-name="GrtObject" key="owner">0de39e86-1dec-11e3-b571-080027bcf912</link>
12547 12547 
                    </value>
12548 12548 
                  </value>
......
12702 12702 
                  <value type="int" key="commentedOut">0</value>
12703 12703 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
12704 12704 
                  <value _ptr_="0xaa9aad8" type="dict" key="customData"/>
12705 
                  <value type="string" key="lastChangeDate">2013-09-21 19:00</value>
12705 
                  <value type="string" key="lastChangeDate">2013-09-21 19:19</value>
12706 12706 
                  <value type="int" key="modelOnly">0</value>
12707 12707 
                  <value type="string" key="name">record</value>
12708 12708 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
12733 12733 
                      <value type="string" key="oldName">id</value>
12734 12734 
                      <link type="object" struct-name="GrtObject" key="owner">afc401d4-1df9-11e3-bbb6-080027bcf912</link>
12735 12735 
                    </value>
12736 
                    <value type="object" struct-name="db.mysql.Column" id="afc409b8-1df9-11e3-bbb6-080027bcf912" struct-checksum="0x783b5183">
12736 
                    <value type="object" struct-name="db.mysql.Column" id="afc40c10-1df9-11e3-bbb6-080027bcf912" struct-checksum="0x783b5183">
12737 12737 
                      <value type="int" key="autoIncrement">0</value>
12738 12738 
                      <value type="string" key="characterSetName"></value>
12739 
                      <value _ptr_="0xaa9eac0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
12739 
                      <value _ptr_="0xaa9ef70" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
12740 12740 
                      <value type="string" key="collationName"></value>
12741 12741 
                      <value type="string" key="datatypeExplicitParams"></value>
12742 12742 
                      <value type="string" key="defaultValue"></value>
12743 
                      <value type="int" key="defaultValueIsNull">1</value>
12744 
                      <value _ptr_="0xaa9ee20" type="list" content-type="string" key="flags"/>
12745 
                      <value type="int" key="isNotNull">0</value>
12743 
                      <value type="int" key="defaultValueIsNull">0</value>
12744 
                      <value _ptr_="0xaa9f2f0" type="list" content-type="string" key="flags"/>
12745 
                      <value type="int" key="isNotNull">1</value>
12746 12746 
                      <value type="int" key="length">767</value>
12747 12747 
                      <value type="int" key="precision">-1</value>
12748 12748 
                      <value type="int" key="scale">-1</value>
12749 12749 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
12750 12750 
                      <value type="string" key="comment"></value>
12751 
                      <value type="string" key="name">parent</value>
12752 
                      <value type="string" key="oldName">parent</value>
12751 
                      <value type="string" key="name">name</value>
12752 
                      <value type="string" key="oldName">name</value>
12753 12753 
                      <link type="object" struct-name="GrtObject" key="owner">afc401d4-1df9-11e3-bbb6-080027bcf912</link>
12754 12754 
                    </value>
12755 
                    <value type="object" struct-name="db.mysql.Column" id="afc40c10-1df9-11e3-bbb6-080027bcf912" struct-checksum="0x783b5183">
12755 
                    <value type="object" struct-name="db.mysql.Column" id="afc409b8-1df9-11e3-bbb6-080027bcf912" struct-checksum="0x783b5183">
12756 12756 
                      <value type="int" key="autoIncrement">0</value>
12757 12757 
                      <value type="string" key="characterSetName"></value>
12758 
                      <value _ptr_="0xaa9ef70" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
12758 
                      <value _ptr_="0xaa9eac0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
12759 12759 
                      <value type="string" key="collationName"></value>
12760 12760 
                      <value type="string" key="datatypeExplicitParams"></value>
12761 12761 
                      <value type="string" key="defaultValue"></value>
12762 12762 
                      <value type="int" key="defaultValueIsNull">1</value>
12763 
                      <value _ptr_="0xaa9f2f0" type="list" content-type="string" key="flags"/>
12763 
                      <value _ptr_="0xaa9ee20" type="list" content-type="string" key="flags"/>
12764 12764 
                      <value type="int" key="isNotNull">0</value>
12765 12765 
                      <value type="int" key="length">767</value>
12766 12766 
                      <value type="int" key="precision">-1</value>
12767 12767 
                      <value type="int" key="scale">-1</value>
12768 12768 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
12769 12769 
                      <value type="string" key="comment"></value>
12770 
                      <value type="string" key="name">name</value>
12771 
                      <value type="string" key="oldName">name</value>
12770 
                      <value type="string" key="name">parent</value>
12771 
                      <value type="string" key="oldName">parent</value>
12772 12772 
                      <link type="object" struct-name="GrtObject" key="owner">afc401d4-1df9-11e3-bbb6-080027bcf912</link>
12773 12773 
                    </value>
12774 12774 
                    <value type="object" struct-name="db.mysql.Column" id="afc4158e-1df9-11e3-bbb6-080027bcf912" struct-checksum="0x783b5183">
......
12927 12927 
                  <value type="int" key="commentedOut">0</value>
12928 12928 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
12929 12929 
                  <value _ptr_="0xaa9e148" type="dict" key="customData"/>
12930 
                  <value type="string" key="lastChangeDate">2013-09-15 04:44</value>
12930 
                  <value type="string" key="lastChangeDate">2013-09-21 19:19</value>
12931 12931 
                  <value type="int" key="modelOnly">0</value>
12932 12932 
                  <value type="string" key="name">source</value>
12933 12933 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
17588 17588 
              <value type="int" key="visible">1</value>
17589 17589 
              <value type="string" key="name"></value>
17590 17590 
            </value>
17591 
            <value _ptr_="0xaaa5ef8" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
17591 
            <value _ptr_="0xaaa5ef8" type="list" content-type="object" content-struct-name="model.Object" key="selection">
17592 
              <link type="object">0de3d5b8-1dec-11e3-b571-080027bcf912</link>
17593 
            </value>
17592 17594 
            <value type="int" key="updateBlocked">0</value>
17593 17595 
            <value type="real" key="width">1.6215e+03</value>
17594 17596 
            <value type="real" key="x">0.e+00</value>
......
17601 17603 
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17602 17604 
        <value _ptr_="0xa9f7a68" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17603 17605 
        <value _ptr_="0xa22a678" type="dict" key="syncProfiles">
17604 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="4927f0ee-232a-11e3-a5a2-080027bcf912" struct-checksum="0xc64972c2" key="">
17605 
            <value _ptr_="0xc135f88" type="dict" key="lastKnownDBNames">
17606 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="d6c73090-232a-11e3-a5a2-080027bcf912" struct-checksum="0xc64972c2" key="">
17607 
            <value _ptr_="0xbc21470" type="dict" key="lastKnownDBNames">
17606 17608 
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17607 17609 
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
17608 17610 
              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>
......
17631 17633 
              <value type="string" key="0de39e86-1dec-11e3-b571-080027bcf912">record</value>
17632 17634 
              <value type="string" key="0de3a2aa-1dec-11e3-b571-080027bcf912">id</value>
17633 17635 
              <value type="string" key="0de3a61a-1dec-11e3-b571-080027bcf912">dataset</value>
17634 
              <value type="string" key="0de3ab06-1dec-11e3-b571-080027bcf912">dataset_record_id</value>
17636 
              <value type="string" key="0de3ab06-1dec-11e3-b571-080027bcf912">id_within_dataset</value>
17635 17637 
              <value type="string" key="0de3afc0-1dec-11e3-b571-080027bcf912">fk_record_source10</value>
17636 17638 
              <value type="string" key="0de3b22c-1dec-11e3-b571-080027bcf912">PRIMARY</value>
17637 17639 
              <value type="string" key="0de3b510-1dec-11e3-b571-080027bcf912">record_unique</value>
......
18234 18236 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18235 18237 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18236 18238 
      <value type="string" key="caption">New Model</value>
18237 
      <value type="string" key="dateChanged">2013-09-21 19:00</value>
18239 
      <value type="string" key="dateChanged">2013-09-21 19:20</value>
18238 18240 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18239 18241 
      <value type="string" key="description"></value>
18240 18242 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
702 702 
CREATE TABLE `record` (
703 703 
  `id` varbinary(767) NOT NULL,
704 704 
  `dataset` varbinary(767) NOT NULL,
705 
  `id_within_dataset` varbinary(767) NOT NULL,
705 
  `id_within_dataset` varbinary(767) NOT NULL COMMENT 'also put this in source.name',
706 706 
  PRIMARY KEY (`id`),
707 707 
  UNIQUE KEY `record_unique` (`dataset`,`id_within_dataset`),
708 708 
  KEY `fk_record_source1_idx` (`dataset`),
......
843 843 
/*!40101 SET character_set_client = utf8 */;
844 844 
CREATE TABLE `source` (
845 845 
  `id` varbinary(767) NOT NULL,
846 
  `name` varbinary(767) NOT NULL,
846 847 
  `parent` varbinary(767) DEFAULT NULL,
847 
  `name` varbinary(767) DEFAULT NULL,
848 848 
  `info` set('hstore') COLLATE utf8_bin DEFAULT NULL,
849 849 
  PRIMARY KEY (`id`),
850 850 
  UNIQUE KEY `source_unique` (`parent`,`name`),

Also available in: Unified diff