Revision 2887
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 4660 | 4660 |
|
| 4661 | 4661 |
|
| 4662 | 4662 |
-- |
| 4663 |
-- Name: specimenreplicate_catalognumber_dwc; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4664 |
-- |
|
| 4665 |
|
|
| 4666 |
|
|
| 4667 |
|
|
| 4668 |
|
|
| 4669 |
-- |
|
| 4663 | 4670 |
-- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4664 | 4671 |
-- |
| 4665 | 4672 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 5187 | 5187 |
|
| 5188 | 5188 |
|
| 5189 | 5189 |
-- |
| 5190 |
-- Name: specimenreplicate_catalognumber_dwc; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5191 |
-- |
|
| 5192 |
|
|
| 5193 |
CREATE INDEX specimenreplicate_catalognumber_dwc ON specimenreplicate USING btree ((COALESCE(catalognumber_dwc, '\\N'::text))); |
|
| 5194 |
|
|
| 5195 |
|
|
| 5196 |
-- |
|
| 5190 | 5197 |
-- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5191 | 5198 |
-- |
| 5192 | 5199 |
|
Also available in: Unified diff
schemas/vegbien.sql: specimenreplicate: Added indexes using COALESCE to match what sql_gen does