Revision 2636
Added by Aaron Marcuse-Kubitza about 12 years ago
| py_functions.sql | ||
|---|---|---|
| 188 | 188 |
|
| 189 | 189 |
|
| 190 | 190 |
-- |
| 191 |
-- Name: _dateRangeEnd_value; Type: INDEX; Schema: py_functions; Owner: bien; Tablespace: |
|
| 192 |
-- |
|
| 193 |
|
|
| 194 |
CREATE INDEX "_dateRangeEnd_value" ON "_dateRangeEnd" USING btree (value); |
|
| 195 |
|
|
| 196 |
|
|
| 197 |
-- |
|
| 191 | 198 |
-- Name: _dateRangeStart_unique; Type: INDEX; Schema: py_functions; Owner: bien; Tablespace: |
| 192 | 199 |
-- |
| 193 | 200 |
|
| ... | ... | |
| 195 | 202 |
|
| 196 | 203 |
|
| 197 | 204 |
-- |
| 205 |
-- Name: _dateRangeStart_value; Type: INDEX; Schema: py_functions; Owner: bien; Tablespace: |
|
| 206 |
-- |
|
| 207 |
|
|
| 208 |
CREATE INDEX "_dateRangeStart_value" ON "_dateRangeStart" USING btree (value); |
|
| 209 |
|
|
| 210 |
|
|
| 211 |
-- |
|
| 212 |
-- Name: _namePart_first; Type: INDEX; Schema: py_functions; Owner: bien; Tablespace: |
|
| 213 |
-- |
|
| 214 |
|
|
| 215 |
CREATE INDEX "_namePart_first" ON "_namePart" USING btree (first); |
|
| 216 |
|
|
| 217 |
|
|
| 218 |
-- |
|
| 219 |
-- Name: _namePart_last; Type: INDEX; Schema: py_functions; Owner: bien; Tablespace: |
|
| 220 |
-- |
|
| 221 |
|
|
| 222 |
CREATE INDEX "_namePart_last" ON "_namePart" USING btree (last); |
|
| 223 |
|
|
| 224 |
|
|
| 225 |
-- |
|
| 226 |
-- Name: _namePart_middle; Type: INDEX; Schema: py_functions; Owner: bien; Tablespace: |
|
| 227 |
-- |
|
| 228 |
|
|
| 229 |
CREATE INDEX "_namePart_middle" ON "_namePart" USING btree (middle); |
|
| 230 |
|
|
| 231 |
|
|
| 232 |
-- |
|
| 198 | 233 |
-- Name: _namePart_unique; Type: INDEX; Schema: py_functions; Owner: bien; Tablespace: |
| 199 | 234 |
-- |
| 200 | 235 |
|
Also available in: Unified diff
schemas/functions.sql: Added indexes on all relational function parameters since the unique index will not be used for lookups