Revision 11400
Added by Aaron Marcuse-Kubitza over 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 875 | 875 |
|
| 876 | 876 |
CREATE TABLE analytical_stem ( |
| 877 | 877 |
datasource varchar(255) NOT NULL, |
| 878 |
`institutionCode` varchar(255),
|
|
| 879 |
`collectionCode` varchar(255),
|
|
| 878 |
`specimenHolderInstitutions` varchar(255),
|
|
| 879 |
collection varchar(255),
|
|
| 880 | 880 |
`catalogNumber` varchar(255), |
| 881 | 881 |
`occurrenceID` varchar(255), |
| 882 | 882 |
country varchar(255), |
| ... | ... | |
| 5164 | 5164 |
|
| 5165 | 5165 |
|
| 5166 | 5166 |
-- |
| 5167 |
-- Name: analytical_stem_datasource_institutionCode_collectionCode_c_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5167 |
-- Name: analytical_stem_datasource_occurrenceID_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5168 | 5168 |
-- |
| 5169 | 5169 |
|
| 5170 |
CREATE INDEX `analytical_stem_datasource_institutionCode_collectionCode_c_idx` ON analytical_stem (datasource, `institutionCode`, `collectionCode`, `catalogNumber`);
|
|
| 5170 |
CREATE INDEX `analytical_stem_datasource_occurrenceID_idx` ON analytical_stem (datasource, `occurrenceID`);
|
|
| 5171 | 5171 |
|
| 5172 | 5172 |
|
| 5173 | 5173 |
-- |
| 5174 |
-- Name: analytical_stem_datasource_occurrenceID_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5174 |
-- Name: analytical_stem_datasource_projectID_locationID_dateCollect_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5175 | 5175 |
-- |
| 5176 | 5176 |
|
| 5177 |
CREATE INDEX `analytical_stem_datasource_occurrenceID_idx` ON analytical_stem (datasource, `occurrenceID`);
|
|
| 5177 |
CREATE INDEX `analytical_stem_datasource_projectID_locationID_dateCollect_idx` ON analytical_stem (datasource, `projectID`, `locationID`, `dateCollected`);
|
|
| 5178 | 5178 |
|
| 5179 | 5179 |
|
| 5180 | 5180 |
-- |
| 5181 |
-- Name: analytical_stem_datasource_projectID_locationID_dateCollect_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5181 |
-- Name: analytical_stem_datasource_specimenHolderInstitutions_colle_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5182 | 5182 |
-- |
| 5183 | 5183 |
|
| 5184 |
CREATE INDEX `analytical_stem_datasource_projectID_locationID_dateCollect_idx` ON analytical_stem (datasource, `projectID`, `locationID`, `dateCollected`);
|
|
| 5184 |
CREATE INDEX `analytical_stem_datasource_specimenHolderInstitutions_colle_idx` ON analytical_stem (datasource, `specimenHolderInstitutions`, collection, `catalogNumber`);
|
|
| 5185 | 5185 |
|
| 5186 | 5186 |
|
| 5187 | 5187 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: regenerated using `make schemas/remake`. note that analytical_stem_view column renamings need this step after a search-and-replace of the column names, in order to remove excess "" around all-lowercase names and reset generated index names.