Revision 2888
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 4289 | 4289 |
|
| 4290 | 4290 |
|
| 4291 | 4291 |
-- |
| 4292 |
-- Name: method_description; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4293 |
-- |
|
| 4294 |
|
|
| 4295 |
|
|
| 4296 |
|
|
| 4297 |
|
|
| 4298 |
-- |
|
| 4299 |
-- Name: method_name; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4300 |
-- |
|
| 4301 |
|
|
| 4302 |
CREATE INDEX method_name ON method (name); |
|
| 4303 |
|
|
| 4304 |
|
|
| 4305 |
-- |
|
| 4292 | 4306 |
-- Name: method_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4293 | 4307 |
-- |
| 4294 | 4308 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 4816 | 4816 |
|
| 4817 | 4817 |
|
| 4818 | 4818 |
-- |
| 4819 |
-- Name: method_description; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4820 |
-- |
|
| 4821 |
|
|
| 4822 |
CREATE INDEX method_description ON method USING btree ((COALESCE(description, '\\N'::text))); |
|
| 4823 |
|
|
| 4824 |
|
|
| 4825 |
-- |
|
| 4826 |
-- Name: method_name; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4827 |
-- |
|
| 4828 |
|
|
| 4829 |
CREATE INDEX method_name ON method USING btree (name); |
|
| 4830 |
|
|
| 4831 |
|
|
| 4832 |
-- |
|
| 4819 | 4833 |
-- Name: method_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4820 | 4834 |
-- |
| 4821 | 4835 |
|
| 4822 |
CREATE UNIQUE INDEX method_unique ON method USING btree (name, (COALESCE(description, ''::text))); |
|
| 4836 |
CREATE UNIQUE INDEX method_unique ON method USING btree (name, (COALESCE(description, '\\N'::text)));
|
|
| 4823 | 4837 |
|
| 4824 | 4838 |
|
| 4825 | 4839 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: method: Changed indexes to use `COALESCE` to match what sql_gen now does