Revision 7059
Added by Aaron Marcuse-Kubitza almost 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 5059 | 5059 |
|
| 5060 | 5060 |
|
| 5061 | 5061 |
-- |
| 5062 |
-- Name: analytical_stem_datasource_projectID_locationID_dateColle_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5062 |
-- Name: analytical_stem_datasource_projectID_locationID_dateCollect_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5063 | 5063 |
-- |
| 5064 | 5064 |
|
| 5065 |
CREATE INDEX `analytical_stem_datasource_projectID_locationID_dateColle_idx` ON analytical_stem (datasource, `projectID`, `locationID`, `dateCollected`); |
|
| 5065 |
CREATE INDEX `analytical_stem_datasource_projectID_locationID_dateCollect_idx` ON analytical_stem (datasource, `projectID`, `locationID`, `dateCollected`);
|
|
| 5066 | 5066 |
|
| 5067 | 5067 |
|
| 5068 | 5068 |
-- |
| schemas/vegbien.sql | ||
|---|---|---|
| 6172 | 6172 |
|
| 6173 | 6173 |
|
| 6174 | 6174 |
-- |
| 6175 |
-- Name: analytical_stem_datasource_projectID_locationID_dateColle_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6175 |
-- Name: analytical_stem_datasource_projectID_locationID_dateCollect_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 6176 | 6176 |
-- |
| 6177 | 6177 |
|
| 6178 |
CREATE INDEX "analytical_stem_datasource_projectID_locationID_dateColle_idx" ON analytical_stem USING btree (datasource, "projectID", "locationID", "dateCollected"); |
|
| 6178 |
CREATE INDEX "analytical_stem_datasource_projectID_locationID_dateCollect_idx" ON analytical_stem USING btree (datasource, "projectID", "locationID", "dateCollected");
|
|
| 6179 | 6179 |
|
| 6180 | 6180 |
|
| 6181 | 6181 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: Regenerated analytical_stem using sync_analytical_stem_to_view()