Revision 6476
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 4876 | 4876 |
|
| 4877 | 4877 |
|
| 4878 | 4878 |
-- |
| 4879 |
-- Name: analytical_aggregate_by_institutionCode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4880 |
-- |
|
| 4881 |
|
|
| 4882 |
CREATE INDEX `analytical_aggregate_by_institutionCode` ON analytical_aggregate (`institutionCode`, `plotName`, `dateCollected`); |
|
| 4883 |
|
|
| 4884 |
|
|
| 4885 |
-- |
|
| 4886 |
-- Name: analytical_stem_by_institutionCode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4887 |
-- |
|
| 4888 |
|
|
| 4889 |
CREATE INDEX `analytical_stem_by_institutionCode` ON analytical_stem (`institutionCode`, `plotName`, `dateCollected`); |
|
| 4890 |
|
|
| 4891 |
|
|
| 4892 |
-- |
|
| 4879 | 4893 |
-- Name: commclass_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4880 | 4894 |
-- |
| 4881 | 4895 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 5927 | 5927 |
|
| 5928 | 5928 |
|
| 5929 | 5929 |
-- |
| 5930 |
-- Name: analytical_aggregate_by_institutionCode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5931 |
-- |
|
| 5932 |
|
|
| 5933 |
CREATE INDEX "analytical_aggregate_by_institutionCode" ON analytical_aggregate USING btree ("institutionCode", "plotName", "dateCollected");
|
|
| 5934 |
|
|
| 5935 |
|
|
| 5936 |
-- |
|
| 5937 |
-- Name: analytical_stem_by_institutionCode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5938 |
-- |
|
| 5939 |
|
|
| 5940 |
CREATE INDEX "analytical_stem_by_institutionCode" ON analytical_stem USING btree ("institutionCode", "plotName", "dateCollected");
|
|
| 5941 |
|
|
| 5942 |
|
|
| 5943 |
-- |
|
| 5930 | 5944 |
-- Name: commclass_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5931 | 5945 |
-- |
| 5932 | 5946 |
|
Also available in: Unified diff
schemas/vegbien.sql: analytical_*: Added index on NOT NULL columns, starting with institutionCode