Revision 4468
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 3793 | 3793 |
|
| 3794 | 3794 |
|
| 3795 | 3795 |
-- |
| 3796 |
-- Name: project_unique_name_date; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 3797 |
-- |
|
| 3798 |
|
|
| 3799 |
|
|
| 3800 |
|
|
| 3801 |
|
|
| 3802 |
-- |
|
| 3796 | 3803 |
-- Name: project_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 3797 | 3804 |
-- |
| 3798 | 3805 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 4352 | 4352 |
|
| 4353 | 4353 |
|
| 4354 | 4354 |
-- |
| 4355 |
-- Name: project_unique_name_date; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4356 |
-- |
|
| 4357 |
|
|
| 4358 |
CREATE UNIQUE INDEX project_unique_name_date ON project USING btree (datasource_id, (COALESCE(projectname, '\\N'::text)), (COALESCE(startdate, 'infinity'::timestamp with time zone))) WHERE (sourceaccessioncode IS NULL); |
|
| 4359 |
|
|
| 4360 |
|
|
| 4361 |
-- |
|
| 4355 | 4362 |
-- Name: project_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4356 | 4363 |
-- |
| 4357 | 4364 |
|
Also available in: Unified diff
schemas/vegbien.sql: project: Added project_unique_name_date unique index for projects that don't have a sourceaccessioncode