Revision 6792
Added by Aaron Marcuse-Kubitza almost 12 years ago
| vegbien.sql | ||
|---|---|---|
| 6300 | 6300 |
-- Name: sourcelist_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6301 | 6301 |
-- |
| 6302 | 6302 |
|
| 6303 |
CREATE UNIQUE INDEX sourcelist_unique ON sourcelist USING btree (source_id, (COALESCE(name, '\N'::text)));
|
|
| 6303 |
CREATE UNIQUE INDEX sourcelist_unique ON sourcelist USING btree (source_id, name);
|
|
| 6304 | 6304 |
|
| 6305 | 6305 |
|
| 6306 | 6306 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: sourcelist_unique: Removed COALESCE around name because it's NOT NULL