Revision 6004
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 5060 | 5060 |
-- Name: method_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5061 | 5061 |
-- |
| 5062 | 5062 |
|
| 5063 |
CREATE UNIQUE INDEX method_unique ON method USING btree (name, (COALESCE(description, '\\N'::text))); |
|
| 5063 |
CREATE UNIQUE INDEX method_unique ON method USING btree (reference_id, name, (COALESCE(description, '\\N'::text)));
|
|
| 5064 | 5064 |
|
| 5065 | 5065 |
|
| 5066 | 5066 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: method: method_unique: Added reference_id to make method unique within the datasource instead of globally unique within VegBIEN