Revision 1067
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 4095 | 4095 |
|
| 4096 | 4096 |
|
| 4097 | 4097 |
-- |
| 4098 |
-- Name: method_keys; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4099 |
-- |
|
| 4100 |
|
|
| 4101 |
|
|
| 4102 |
|
|
| 4103 |
|
|
| 4104 |
-- |
|
| 4098 | 4105 |
-- Name: namedplace_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4099 | 4106 |
-- |
| 4100 | 4107 |
|
| ... | ... | |
| 4382 | 4389 |
|
| 4383 | 4390 |
|
| 4384 | 4391 |
-- |
| 4392 |
-- Name: plotmethod_keys; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4393 |
-- |
|
| 4394 |
|
|
| 4395 |
|
|
| 4396 |
|
|
| 4397 |
|
|
| 4398 |
-- |
|
| 4385 | 4399 |
-- Name: project_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4386 | 4400 |
-- |
| 4387 | 4401 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 4456 | 4456 |
|
| 4457 | 4457 |
|
| 4458 | 4458 |
-- |
| 4459 |
-- Name: method_keys; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4460 |
-- |
|
| 4461 |
|
|
| 4462 |
CREATE UNIQUE INDEX method_keys ON method USING btree (name, (COALESCE(description, ''::text))); |
|
| 4463 |
|
|
| 4464 |
|
|
| 4465 |
-- |
|
| 4459 | 4466 |
-- Name: namedplace_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4460 | 4467 |
-- |
| 4461 | 4468 |
|
| ... | ... | |
| 4743 | 4750 |
|
| 4744 | 4751 |
|
| 4745 | 4752 |
-- |
| 4753 |
-- Name: plotmethod_keys; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4754 |
-- |
|
| 4755 |
|
|
| 4756 |
CREATE UNIQUE INDEX plotmethod_keys ON plotmethod USING btree (name, (COALESCE(description, ''::text))); |
|
| 4757 |
|
|
| 4758 |
|
|
| 4759 |
-- |
|
| 4746 | 4760 |
-- Name: project_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4747 | 4761 |
-- |
| 4748 | 4762 |
|
Also available in: Unified diff
vegbien.sql: Added method and plotmethod UNIQUE indexes