Project

General

Profile

« Previous | Next » 

Revision 10976

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: event: added event_unique_within_parent, event_unique_within_place unique indexes

View differences:

schemas/VegCore/VegCore.pg.sql
184 184 
  "place" text DEFAULT NULL,
185 185 
  "participants" text DEFAULT NULL,
186 186 
  PRIMARY KEY ("id"),
187 
  /*CONSTRAINT "event_unique_within_parent" */UNIQUE ("parent","name"),
188 
  /*CONSTRAINT "event_unique_within_place" */UNIQUE ("place","date_range","participants"),
187 189 
  /*KEY "fk_event_place1_idx" ("place")*/CHECK (true),
188 190 
  /*KEY "fk_event1_idx" ("parent")*/CHECK (true),
189 191 
  /*KEY "fk_event_party_list1_idx" ("participants")*/CHECK (true),
schemas/VegCore/document.mwb.xml
4811 4811 
                      <value type="string" key="oldName">fk_event_party_list1_idx</value>
4812 4812 
                      <link type="object" struct-name="GrtObject" key="owner">c672743a-a7a0-11e2-b667-080027bcf912</link>
4813 4813 
                    </value>
4814 
                    <value type="object" struct-name="db.mysql.Index" id="9ff2d244-1dfe-11e3-9d67-080027bcf912" struct-checksum="0x309b847a">
4815 
                      <value _ptr_="0xc5cdc98" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
4816 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="c600469c-1dfe-11e3-9d67-080027bcf912" struct-checksum="0x62630b3c">
4817 
                          <value type="int" key="columnLength">0</value>
4818 
                          <value type="string" key="comment"></value>
4819 
                          <value type="int" key="descend">0</value>
4820 
                          <link type="object" struct-name="db.Column" key="referencedColumn">c672785e-a7a0-11e2-b667-080027bcf912</link>
4821 
                          <value type="string" key="name"></value>
4822 
                          <link type="object" struct-name="GrtObject" key="owner">9ff2d244-1dfe-11e3-9d67-080027bcf912</link>
4823 
                        </value>
4824 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="c902781a-1dfe-11e3-9d67-080027bcf912" struct-checksum="0x62630b3c">
4825 
                          <value type="int" key="columnLength">0</value>
4826 
                          <value type="string" key="comment"></value>
4827 
                          <value type="int" key="descend">0</value>
4828 
                          <link type="object" struct-name="db.Column" key="referencedColumn">c6727a2a-a7a0-11e2-b667-080027bcf912</link>
4829 
                          <value type="string" key="name"></value>
4830 
                          <link type="object" struct-name="GrtObject" key="owner">9ff2d244-1dfe-11e3-9d67-080027bcf912</link>
4831 
                        </value>
4832 
                      </value>
4833 
                      <value type="string" key="indexKind"></value>
4834 
                      <value type="int" key="keyBlockSize">0</value>
4835 
                      <value type="string" key="withParser"></value>
4836 
                      <value type="string" key="comment"></value>
4837 
                      <value type="int" key="deferability">0</value>
4838 
                      <value type="string" key="indexType">UNIQUE</value>
4839 
                      <value type="int" key="isPrimary">0</value>
4840 
                      <value type="string" key="name">event_unique_within_parent</value>
4841 
                      <value type="int" key="unique">1</value>
4842 
                      <value type="string" key="oldName"></value>
4843 
                      <link type="object" struct-name="GrtObject" key="owner">c672743a-a7a0-11e2-b667-080027bcf912</link>
4844 
                    </value>
4845 
                    <value type="object" struct-name="db.mysql.Index" id="48c4e182-1dff-11e3-9d67-080027bcf912" struct-checksum="0x309b847a">
4846 
                      <value _ptr_="0xc515da8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
4847 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="4f2b178a-1dff-11e3-9d67-080027bcf912" struct-checksum="0x62630b3c">
4848 
                          <value type="int" key="columnLength">0</value>
4849 
                          <value type="string" key="comment"></value>
4850 
                          <value type="int" key="descend">0</value>
4851 
                          <link type="object" struct-name="db.Column" key="referencedColumn">c6727d54-a7a0-11e2-b667-080027bcf912</link>
4852 
                          <value type="string" key="name"></value>
4853 
                          <link type="object" struct-name="GrtObject" key="owner">48c4e182-1dff-11e3-9d67-080027bcf912</link>
4854 
                        </value>
4855 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="5e3664aa-1dff-11e3-9d67-080027bcf912" struct-checksum="0x62630b3c">
4856 
                          <value type="int" key="columnLength">0</value>
4857 
                          <value type="string" key="comment"></value>
4858 
                          <value type="int" key="descend">0</value>
4859 
                          <link type="object" struct-name="db.Column" key="referencedColumn">c6727bce-a7a0-11e2-b667-080027bcf912</link>
4860 
                          <value type="string" key="name"></value>
4861 
                          <link type="object" struct-name="GrtObject" key="owner">48c4e182-1dff-11e3-9d67-080027bcf912</link>
4862 
                        </value>
4863 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="5ecc96e6-1dff-11e3-9d67-080027bcf912" struct-checksum="0x62630b3c">
4864 
                          <value type="int" key="columnLength">0</value>
4865 
                          <value type="string" key="comment"></value>
4866 
                          <value type="int" key="descend">0</value>
4867 
                          <link type="object" struct-name="db.Column" key="referencedColumn">251c2b92-f67b-11e2-aebb-080027bcf912</link>
4868 
                          <value type="string" key="name"></value>
4869 
                          <link type="object" struct-name="GrtObject" key="owner">48c4e182-1dff-11e3-9d67-080027bcf912</link>
4870 
                        </value>
4871 
                      </value>
4872 
                      <value type="string" key="indexKind"></value>
4873 
                      <value type="int" key="keyBlockSize">0</value>
4874 
                      <value type="string" key="withParser"></value>
4875 
                      <value type="string" key="comment"></value>
4876 
                      <value type="int" key="deferability">0</value>
4877 
                      <value type="string" key="indexType">UNIQUE</value>
4878 
                      <value type="int" key="isPrimary">0</value>
4879 
                      <value type="string" key="name">event_unique_within_place</value>
4880 
                      <value type="int" key="unique">1</value>
4881 
                      <value type="string" key="oldName"></value>
4882 
                      <link type="object" struct-name="GrtObject" key="owner">c672743a-a7a0-11e2-b667-080027bcf912</link>
4883 
                    </value>
4814 4884 
                  </value>
4815 4885 
                  <value type="string" key="maxRows"></value>
4816 4886 
                  <value type="string" key="mergeInsert"></value>
......
4842 4912 
                  <value type="int" key="commentedOut">0</value>
4843 4913 
                  <value type="string" key="createDate">2013-04-17 13:52</value>
4844 4914 
                  <value _ptr_="0xb4aff50" type="dict" key="customData"/>
4845 
                  <value type="string" key="lastChangeDate">2013-07-30 18:38</value>
4915 
                  <value type="string" key="lastChangeDate">2013-09-15 05:07</value>
4846 4916 
                  <value type="int" key="modelOnly">0</value>
4847 4917 
                  <value type="string" key="name">event</value>
4848 4918 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
15750 15820 
                <value type="real" key="left">5.75e+02</value>
15751 15821 
                <value type="int" key="locked">0</value>
15752 15822 
                <value type="int" key="manualSizing">0</value>
15753 
                <value type="real" key="top">4.34e+02</value>
15823 
                <value type="real" key="top">4.35e+02</value>
15754 15824 
                <value type="real" key="width">8.1e+01</value>
15755 15825 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15756 15826 
                <value type="int" key="visible">1</value>
......
17400 17470 
              <value type="int" key="visible">1</value>
17401 17471 
              <value type="string" key="name"></value>
17402 17472 
            </value>
17403 
            <value _ptr_="0xb52ce88" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
17473 
            <value _ptr_="0xb52ce88" type="list" content-type="object" content-struct-name="model.Object" key="selection">
17474 
              <link type="object">C43D5355-2E9C-4315-BA47-B9741D1BB3B9</link>
17475 
            </value>
17404 17476 
            <value type="int" key="updateBlocked">0</value>
17405 17477 
            <value type="real" key="width">1.6215e+03</value>
17406 17478 
            <value type="real" key="x">0.e+00</value>
......
17413 17485 
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17414 17486 
        <value _ptr_="0xb480be0" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17415 17487 
        <value _ptr_="0xaa5bc98" type="dict" key="syncProfiles">
17416 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="5a06b116-1dfd-11e3-9d67-080027bcf912" struct-checksum="0xc64972c2" key="">
17417 
            <value _ptr_="0xc42b800" type="dict" key="lastKnownDBNames">
17488 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="ceafdd62-1dfd-11e3-9d67-080027bcf912" struct-checksum="0xc64972c2" key="">
17489 
            <value _ptr_="0xc623700" type="dict" key="lastKnownDBNames">
17418 17490 
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17419 17491 
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
17420 17492 
              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>
......
18040 18112 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18041 18113 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18042 18114 
      <value type="string" key="caption">New Model</value>
18043 
      <value type="string" key="dateChanged">2013-09-15 04:55</value>
18115 
      <value type="string" key="dateChanged">2013-09-15 05:07</value>
18044 18116 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18045 18117 
      <value type="string" key="description"></value>
18046 18118 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
182 182 
  `place` varbinary(767) DEFAULT NULL,
183 183 
  `participants` varbinary(767) DEFAULT NULL,
184 184 
  PRIMARY KEY (`id`),
185 
  UNIQUE KEY `event_unique_within_parent` (`parent`,`name`),
186 
  UNIQUE KEY `event_unique_within_place` (`place`,`date_range`,`participants`),
185 187 
  KEY `fk_event_place1_idx` (`place`),
186 188 
  KEY `fk_event1_idx` (`parent`),
187 189 
  KEY `fk_event_party_list1_idx` (`participants`),

Also available in: Unified diff