Revision 868
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 4988 | 4988 |
|
| 4989 | 4989 |
|
| 4990 | 4990 |
-- |
| 4991 |
-- Name: party_givenname; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4992 |
-- |
|
| 4993 |
|
|
| 4994 |
CREATE INDEX party_givenname ON party (givenname); |
|
| 4995 |
|
|
| 4996 |
|
|
| 4997 |
-- |
|
| 4991 | 4998 |
-- Name: party_keys; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4992 | 4999 |
-- |
| 4993 | 5000 |
|
| ... | ... | |
| 4995 | 5002 |
|
| 4996 | 5003 |
|
| 4997 | 5004 |
-- |
| 5005 |
-- Name: party_middlename; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5006 |
-- |
|
| 5007 |
|
|
| 5008 |
CREATE INDEX party_middlename ON party (middlename); |
|
| 5009 |
|
|
| 5010 |
|
|
| 5011 |
-- |
|
| 5012 |
-- Name: party_organizationname; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5013 |
-- |
|
| 5014 |
|
|
| 5015 |
CREATE INDEX party_organizationname ON party (organizationname); |
|
| 5016 |
|
|
| 5017 |
|
|
| 5018 |
-- |
|
| 5019 |
-- Name: party_surname; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5020 |
-- |
|
| 5021 |
|
|
| 5022 |
CREATE INDEX party_surname ON party (surname); |
|
| 5023 |
|
|
| 5024 |
|
|
| 5025 |
-- |
|
| 4998 | 5026 |
-- Name: partymember_childparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4999 | 5027 |
-- |
| 5000 | 5028 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 5434 | 5434 |
|
| 5435 | 5435 |
|
| 5436 | 5436 |
-- |
| 5437 |
-- Name: party_givenname; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5438 |
-- |
|
| 5439 |
|
|
| 5440 |
CREATE INDEX party_givenname ON party USING btree (givenname); |
|
| 5441 |
|
|
| 5442 |
|
|
| 5443 |
-- |
|
| 5437 | 5444 |
-- Name: party_keys; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5438 | 5445 |
-- |
| 5439 | 5446 |
|
| ... | ... | |
| 5441 | 5448 |
|
| 5442 | 5449 |
|
| 5443 | 5450 |
-- |
| 5451 |
-- Name: party_middlename; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5452 |
-- |
|
| 5453 |
|
|
| 5454 |
CREATE INDEX party_middlename ON party USING btree (middlename); |
|
| 5455 |
|
|
| 5456 |
|
|
| 5457 |
-- |
|
| 5458 |
-- Name: party_organizationname; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5459 |
-- |
|
| 5460 |
|
|
| 5461 |
CREATE INDEX party_organizationname ON party USING btree (organizationname); |
|
| 5462 |
|
|
| 5463 |
|
|
| 5464 |
-- |
|
| 5465 |
-- Name: party_surname; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5466 |
-- |
|
| 5467 |
|
|
| 5468 |
CREATE INDEX party_surname ON party USING btree (surname); |
|
| 5469 |
|
|
| 5470 |
|
|
| 5471 |
-- |
|
| 5444 | 5472 |
-- Name: partymember_childparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5445 | 5473 |
-- |
| 5446 | 5474 |
|
Also available in: Unified diff
vegbien.sql: Added indexes for each field in party used in duplicate elimination (for use by sql.put()'s DuplicateKeyException handler)