Revision 5951
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 4189 | 4189 |
|
| 4190 | 4190 |
|
| 4191 | 4191 |
-- |
| 4192 |
-- Name: reference_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4193 |
-- |
|
| 4194 |
|
|
| 4195 |
|
|
| 4196 |
|
|
| 4197 |
|
|
| 4198 |
-- |
|
| 4192 | 4199 |
-- Name: referencejournal_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4193 | 4200 |
-- |
| 4194 | 4201 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 5054 | 5054 |
|
| 5055 | 5055 |
|
| 5056 | 5056 |
-- |
| 5057 |
-- Name: reference_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5058 |
-- |
|
| 5059 |
|
|
| 5060 |
CREATE UNIQUE INDEX reference_unique ON reference USING btree ((COALESCE(shortname, '\\N'::text))); |
|
| 5061 |
|
|
| 5062 |
|
|
| 5063 |
-- |
|
| 5057 | 5064 |
-- Name: referencejournal_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5058 | 5065 |
-- |
| 5059 | 5066 |
|
Also available in: Unified diff
schemas/vegbien.sql: reference: Added unique index