Revision 1111
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.my.sql | ||
|---|---|---|
| 25 | 25 |
|
| 26 | 26 |
|
| 27 | 27 |
-- |
| 28 |
-- Name: taxonrank; Type: TYPE; Schema: public; Owner: - |
|
| 29 |
-- |
|
| 30 |
|
|
| 31 |
|
|
| 32 |
|
|
| 33 |
|
|
| 34 |
-- |
|
| 28 | 35 |
-- Name: aggregateoccurrence_plantobs_count_1(); Type: FUNCTION; Schema: public; Owner: - |
| 29 | 36 |
-- |
| 30 | 37 |
|
| ... | ... | |
| 1522 | 1529 |
plantname_id int(11) NOT NULL, |
| 1523 | 1530 |
plantname text NOT NULL, |
| 1524 | 1531 |
reference_id int(11), |
| 1525 |
dateentered timestamp NULL |
|
| 1532 |
dateentered timestamp NULL , |
|
| 1533 |
rank text NOT NULL |
|
| 1526 | 1534 |
); |
| 1527 | 1535 |
|
| 1528 | 1536 |
|
| ... | ... | |
| 1586 | 1594 |
plantstatus_id int(11) NOT NULL, |
| 1587 | 1595 |
plantconcept_id int(11) NOT NULL, |
| 1588 | 1596 |
party_id int(11), |
| 1589 |
plantlevel text, |
|
| 1590 | 1597 |
plantparent_id int(11), |
| 1591 | 1598 |
plantconceptstatus text DEFAULT 'undetermined', |
| 1592 | 1599 |
reference_id int(11), |
| ... | ... | |
| 4471 | 4478 |
|
| 4472 | 4479 |
|
| 4473 | 4480 |
-- |
| 4474 |
-- Name: plantstatus_plantlevel_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4475 |
-- |
|
| 4476 |
|
|
| 4477 |
CREATE INDEX plantstatus_plantlevel_x ON plantstatus (plantlevel); |
|
| 4478 |
|
|
| 4479 |
|
|
| 4480 |
-- |
|
| 4481 | 4481 |
-- Name: plantstatus_plantparent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4482 | 4482 |
-- |
| 4483 | 4483 |
|
Also available in: Unified diff
VegBIEN: Moved plantstatus.plantlevel to plantname.rank because the taxonomic rank is a property of the name itself