Revision 3667
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 2179 | 2179 |
-- |
| 2180 | 2180 |
|
| 2181 | 2181 |
CREATE TABLE specimenreplicate ( |
| 2182 |
taxonoccurrence_id int(11) NOT NULL AUTO_INCREMENT,
|
|
| 2182 |
taxonoccurrence_id int(11) NOT NULL, |
|
| 2183 | 2183 |
plantobservation_id int(11), |
| 2184 | 2184 |
institution_id int(11), |
| 2185 | 2185 |
collectioncode_dwc text, |
| schemas/filter_ERD.csv | ||
|---|---|---|
| 4 | 4 |
"^ALTER TABLE (?!party|address|telephone)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES party\b[^;]*;",, |
| 5 | 5 |
,,"specimenreplicate inheritance" |
| 6 | 6 |
"^(CREATE TABLE specimenreplicate \()([^;]*\)\s*;)","\1 |
| 7 |
taxonoccurrence_id int(11) NOT NULL AUTO_INCREMENT,\2
|
|
| 7 |
taxonoccurrence_id int(11) NOT NULL,\2 |
|
| 8 | 8 |
ALTER TABLE specimenreplicate |
| 9 | 9 |
ADD CONSTRAINT specimenreplicate_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE; |
| 10 | 10 |
", |
Also available in: Unified diff
schemas/filter_ERD.csv: Removed AUTO_INCREMENT because that is not added to any other tables