Revision 10449
Added by Aaron Marcuse-Kubitza almost 11 years ago
| VegCore.my.sql | ||
|---|---|---|
| 378 | 378 |
`info` set('hstore') COLLATE utf8_bin DEFAULT NULL,
|
| 379 | 379 |
PRIMARY KEY (`id`), |
| 380 | 380 |
CONSTRAINT `fk_collection_source10` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
| 381 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a\n\nb';
|
|
| 381 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
|
| 382 | 382 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 383 | 383 |
|
| 384 | 384 |
-- |
| ... | ... | |
| 1063 | 1063 |
CREATE TABLE `taxon_string` ( |
| 1064 | 1064 |
`string` varbinary(767) NOT NULL, |
| 1065 | 1065 |
PRIMARY KEY (`string`) |
| 1066 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='to get the parsed_taxon_assertion (TNRS result) for a taxon_string, join using taxon_string.string<-taxon_assertion(string):parsed_taxon_assertion[source=''TNRS.version''] (see wiki.vegpath.org/SQL_dotpaths)'; |
|
| 1066 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='to get the parsed_taxon_assertion (TNRS result) for a taxon_string, join using taxon_string.string<-taxon_assertion(string)::parsed_taxon_assertion[source=''TNRS.version''] (see wiki.vegpath.org/SQL_dotpaths)';
|
|
| 1067 | 1067 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 1068 | 1068 |
|
| 1069 | 1069 |
-- |
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: taxon_string: documented that to get the parsed_taxon_assertion (TNRS result) for a taxon_string, you would join using the SQL dotpath taxon_string.string<-taxon_assertion(string)::parsed_taxon_assertion[source='TNRS.version'] (see wiki.vegpath.org/SQL_dotpaths). important how-to comments such as this one are now included in the version-controlled MySQL schema file itself, not just the .mwb file and the staging copy on vegbiendev.