Revision 13861
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.my.sql | ||
|---|---|---|
| 15348 | 15348 |
|
| 15349 | 15349 |
|
| 15350 | 15350 |
-- |
| 15351 |
-- Name: tnrs_match; Type: TABLE; Schema: TNRS; Owner: -; Tablespace:
|
|
| 15351 |
-- Name: taxon_match; Type: TABLE; Schema: TNRS; Owner: -; Tablespace:
|
|
| 15352 | 15352 |
-- |
| 15353 | 15353 |
|
| 15354 |
CREATE TABLE tnrs_match (
|
|
| 15354 |
CREATE TABLE taxon_match (
|
|
| 15355 | 15355 |
batch varchar(255) NOT NULL, |
| 15356 | 15356 |
match_num int(11) NOT NULL, |
| 15357 | 15357 |
`Name_number` int(11) NOT NULL, |
| ... | ... | |
| 15396 | 15396 |
|
| 15397 | 15397 |
|
| 15398 | 15398 |
-- |
| 15399 |
-- Name: TABLE tnrs_match; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15399 |
-- Name: TABLE taxon_match; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15400 | 15400 |
-- |
| 15401 | 15401 |
|
| 15402 | 15402 |
|
| ... | ... | |
| 15619 | 15619 |
-- Name: tnrs_pkey; Type: CONSTRAINT; Schema: TNRS; Owner: -; Tablespace: |
| 15620 | 15620 |
-- |
| 15621 | 15621 |
|
| 15622 |
ALTER TABLE tnrs_match
|
|
| 15622 |
ALTER TABLE taxon_match
|
|
| 15623 | 15623 |
ADD CONSTRAINT tnrs_pkey PRIMARY KEY (batch, match_num); |
| 15624 | 15624 |
|
| 15625 | 15625 |
|
| ... | ... | |
| 15654 | 15654 |
-- Name: tnrs_Name_submitted_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
| 15655 | 15655 |
-- |
| 15656 | 15656 |
|
| 15657 |
CREATE INDEX `tnrs_Name_submitted_idx` ON tnrs_match (`Name_submitted`);
|
|
| 15657 |
CREATE INDEX `tnrs_Name_submitted_idx` ON taxon_match (`Name_submitted`);
|
|
| 15658 | 15658 |
|
| 15659 | 15659 |
|
| 15660 | 15660 |
-- |
| ... | ... | |
| 15723 | 15723 |
-- Name: tnrs_batch_fkey; Type: FK CONSTRAINT; Schema: TNRS; Owner: - |
| 15724 | 15724 |
-- |
| 15725 | 15725 |
|
| 15726 |
ALTER TABLE tnrs_match
|
|
| 15726 |
ALTER TABLE taxon_match
|
|
| 15727 | 15727 |
ADD CONSTRAINT tnrs_batch_fkey FOREIGN KEY (batch) REFERENCES batch(id) ON UPDATE CASCADE ON DELETE CASCADE; |
| 15728 | 15728 |
|
| 15729 | 15729 |
|
| ... | ... | |
| 15738 | 15738 |
|
| 15739 | 15739 |
|
| 15740 | 15740 |
-- |
| 15741 |
-- Name: tnrs_match; Type: ACL; Schema: TNRS; Owner: -
|
|
| 15741 |
-- Name: taxon_match; Type: ACL; Schema: TNRS; Owner: -
|
|
| 15742 | 15742 |
-- |
| 15743 | 15743 |
|
| 15744 | 15744 |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: tnrs_match: renamed to taxon_match to use the normalized VegCore name for this, and to avoid repeating the schema name