Revision 2961
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 4695 | 4695 |
|
| 4696 | 4696 |
|
| 4697 | 4697 |
-- |
| 4698 |
-- Name: specimenreplicate_sourceaccessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4699 |
-- |
|
| 4700 |
|
|
| 4701 |
|
|
| 4702 |
|
|
| 4703 |
|
|
| 4704 |
-- |
|
| 4698 | 4705 |
-- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4699 | 4706 |
-- |
| 4700 | 4707 |
|
| schemas/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