Revision 2961
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.sql | ||
|---|---|---|
| 5222 | 5222 |
|
| 5223 | 5223 |
|
| 5224 | 5224 |
-- |
| 5225 |
-- Name: specimenreplicate_sourceaccessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5226 |
-- |
|
| 5227 |
|
|
| 5228 |
CREATE INDEX specimenreplicate_sourceaccessioncode ON specimenreplicate USING btree ((COALESCE(sourceaccessioncode, '\\N'::text))); |
|
| 5229 |
|
|
| 5230 |
|
|
| 5231 |
-- |
|
| 5225 | 5232 |
-- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5226 | 5233 |
-- |
| 5227 | 5234 |
|
Also available in: Unified diff
schemas/vegbien.sql: specimenreplicate: Added indexes using COALESCE to match what sql_gen does