Revision 3735
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 3297 | 3297 |
|
| 3298 | 3298 |
|
| 3299 | 3299 |
-- |
| 3300 |
-- Name: plantobservation_aggregateoccurrence_id_1_to_1; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3301 |
-- |
|
| 3302 |
|
|
| 3303 |
ALTER TABLE plantobservation |
|
| 3304 |
ADD CONSTRAINT plantobservation_aggregateoccurrence_id_1_to_1 UNIQUE (aggregateoccurrence_id); |
|
| 3305 |
|
|
| 3306 |
|
|
| 3307 |
-- |
|
| 3308 | 3300 |
-- Name: plantobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3309 | 3301 |
-- |
| 3310 | 3302 |
|
| ... | ... | |
| 3761 | 3753 |
|
| 3762 | 3754 |
|
| 3763 | 3755 |
-- |
| 3756 |
-- Name: plantobservation_aggregateoccurrence_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 3757 |
-- |
|
| 3758 |
|
|
| 3759 |
CREATE UNIQUE INDEX plantobservation_aggregateoccurrence_1_to_1 ON plantobservation (aggregateoccurrence_id); |
|
| 3760 |
|
|
| 3761 |
|
|
| 3762 |
-- |
|
| 3764 | 3763 |
-- Name: plantobservation_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 3765 | 3764 |
-- |
| 3766 | 3765 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 3846 | 3846 |
|
| 3847 | 3847 |
|
| 3848 | 3848 |
-- |
| 3849 |
-- Name: plantobservation_aggregateoccurrence_id_1_to_1; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3850 |
-- |
|
| 3851 |
|
|
| 3852 |
ALTER TABLE ONLY plantobservation |
|
| 3853 |
ADD CONSTRAINT plantobservation_aggregateoccurrence_id_1_to_1 UNIQUE (aggregateoccurrence_id); |
|
| 3854 |
|
|
| 3855 |
|
|
| 3856 |
-- |
|
| 3857 | 3849 |
-- Name: plantobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3858 | 3850 |
-- |
| 3859 | 3851 |
|
| ... | ... | |
| 4307 | 4299 |
|
| 4308 | 4300 |
|
| 4309 | 4301 |
-- |
| 4302 |
-- Name: plantobservation_aggregateoccurrence_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4303 |
-- |
|
| 4304 |
|
|
| 4305 |
CREATE UNIQUE INDEX plantobservation_aggregateoccurrence_1_to_1 ON plantobservation USING btree (aggregateoccurrence_id); |
|
| 4306 |
|
|
| 4307 |
|
|
| 4308 |
-- |
|
| 4310 | 4309 |
-- Name: plantobservation_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4311 | 4310 |
-- |
| 4312 | 4311 |
|
Also available in: Unified diff
schemas/vegbien.sql: plantobservation: Corrected plantobservation_aggregateoccurrence_id_1_to_1's name to plantobservation_aggregateoccurrence_1_to_1 because it's 1:1 with aggregateoccurrence, not aggregateoccurrence_id. Made it a unique index for consistency with our general method of expressing unique constraints on potentially nullable columns.