Revision 10238
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/bien2_traits/bien2_staging.schema.sql | ||
|---|---|---|
| 60 | 60 |
"Authorship" varchar(255) DEFAULT NULL, |
| 61 | 61 |
"AuthorshipContact" varchar(100) DEFAULT NULL, |
| 62 | 62 |
PRIMARY KEY ("TraitObservationID"),
|
| 63 |
"TaxonomyID_index" boolean,
|
|
| 64 |
"Family_index" boolean,
|
|
| 65 |
"Taxon_index" boolean,
|
|
| 66 |
"TraitName_index" boolean,
|
|
| 67 |
"ReferenceID_index" boolean
|
|
| 63 |
/*KEY "TaxonomyID" ("TaxonomyID")*/CHECK (true),
|
|
| 64 |
/*KEY "Family" ("Family")*/CHECK (true),
|
|
| 65 |
/*KEY "Taxon" ("Taxon")*/CHECK (true),
|
|
| 66 |
/*KEY "TraitName" ("TraitName")*/CHECK (true),
|
|
| 67 |
/*KEY "ReferenceID" ("ReferenceID")*/CHECK (true)
|
|
| 68 | 68 |
); |
| 69 | 69 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 70 | 70 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
Also available in: Unified diff
inputs/bien2_traits/bien2_staging.schema.sql: regenerated from MySQL version so that dummy columns (which used to be generated by bin/my2pg) will be replaced with dummy CHECK constraints instead. this avoids needing to map several dummy columns all to OMIT, which was creating an unnecessary collision of staging table column names.