Revision 4399
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 3730 | 3730 |
|
| 3731 | 3731 |
|
| 3732 | 3732 |
-- |
| 3733 |
-- Name: party_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 3734 |
-- |
|
| 3735 |
|
|
| 3736 |
|
|
| 3737 |
|
|
| 3738 |
|
|
| 3739 |
-- |
|
| 3733 | 3740 |
-- Name: party_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 3734 | 3741 |
-- |
| 3735 | 3742 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 4288 | 4288 |
|
| 4289 | 4289 |
|
| 4290 | 4290 |
-- |
| 4291 |
-- Name: party_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4292 |
-- |
|
| 4293 |
|
|
| 4294 |
CREATE UNIQUE INDEX party_datasource ON party USING btree (organizationname) WHERE (organizationname IS NOT NULL); |
|
| 4295 |
|
|
| 4296 |
|
|
| 4297 |
-- |
|
| 4291 | 4298 |
-- Name: party_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4292 | 4299 |
-- |
| 4293 | 4300 |
|
Also available in: Unified diff
schemas/vegbien.sql: party: Added party_datasource index on just the organizationname to facilitate querying just the datasources