Revision 1247
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 4259 | 4259 |
|
| 4260 | 4260 |
|
| 4261 | 4261 |
-- |
| 4262 |
-- Name: party_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4262 |
-- Name: party_unique_name; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4263 | 4263 |
-- |
| 4264 | 4264 |
|
| 4265 | 4265 |
|
| 4266 | 4266 |
|
| 4267 | 4267 |
|
| 4268 | 4268 |
-- |
| 4269 |
-- Name: party_unique_organizationname; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4270 |
-- |
|
| 4271 |
|
|
| 4272 |
|
|
| 4273 |
|
|
| 4274 |
|
|
| 4275 |
-- |
|
| 4269 | 4276 |
-- Name: partymember_childparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4270 | 4277 |
-- |
| 4271 | 4278 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 4656 | 4656 |
|
| 4657 | 4657 |
|
| 4658 | 4658 |
-- |
| 4659 |
-- Name: party_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4659 |
-- Name: party_unique_name; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4660 | 4660 |
-- |
| 4661 | 4661 |
|
| 4662 |
CREATE UNIQUE INDEX party_unique ON party USING btree ((COALESCE(givenname, ''::text)), (COALESCE(middlename, ''::text)), (COALESCE(surname, ''::text)), (COALESCE(organizationname, ''::text))); |
|
| 4662 |
CREATE UNIQUE INDEX party_unique_name ON party USING btree ((COALESCE(givenname, ''::text)), (COALESCE(middlename, ''::text)), (COALESCE(surname, ''::text)), (COALESCE(organizationname, ''::text)));
|
|
| 4663 | 4663 |
|
| 4664 | 4664 |
|
| 4665 | 4665 |
-- |
| 4666 |
-- Name: party_unique_organizationname; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4667 |
-- |
|
| 4668 |
|
|
| 4669 |
CREATE UNIQUE INDEX party_unique_organizationname ON party USING btree (organizationname) WHERE (((givenname IS NULL) AND (middlename IS NULL)) AND (surname IS NULL)); |
|
| 4670 |
|
|
| 4671 |
|
|
| 4672 |
-- |
|
| 4666 | 4673 |
-- Name: partymember_childparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4667 | 4674 |
-- |
| 4668 | 4675 |
|
Also available in: Unified diff
vegbien.sql: party: Added party_unique_organizationname constraint