Revision 3218
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 4175 | 4175 |
|
| 4176 | 4176 |
|
| 4177 | 4177 |
-- |
| 4178 |
-- Name: locationevent_location_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4179 |
-- |
|
| 4180 |
|
|
| 4181 |
|
|
| 4182 |
|
|
| 4183 |
|
|
| 4184 |
-- |
|
| 4185 | 4178 |
-- Name: locationevent_location_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4186 | 4179 |
-- |
| 4187 | 4180 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 4706 | 4706 |
|
| 4707 | 4707 |
|
| 4708 | 4708 |
-- |
| 4709 |
-- Name: locationevent_location_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4710 |
-- |
|
| 4711 |
|
|
| 4712 |
CREATE INDEX locationevent_location_id ON locationevent USING btree ((COALESCE(location_id, 2147483647))); |
|
| 4713 |
|
|
| 4714 |
|
|
| 4715 |
-- |
|
| 4716 | 4709 |
-- Name: locationevent_location_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4717 | 4710 |
-- |
| 4718 | 4711 |
|
Also available in: Unified diff
schemas/vegbien.sql: locationevent: Removed no longer needed COALESCE index on location_id now that location_id is NOT NULL