Revision 10444
Added by Aaron Marcuse-Kubitza over 11 years ago
| MySQL.schema.sql | ||
|---|---|---|
| 1293 | 1293 |
"sync_resolution_id" integer NOT NULL, |
| 1294 | 1294 |
"source" varchar(100) DEFAULT NULL, |
| 1295 | 1295 |
"table_name" varchar(50) DEFAULT NULL, |
| 1296 |
"sync_lsid_full" varchar(150) DEFAULT NULL, |
|
| 1296 |
"sync_lsid_full" varchar(150) DEFAULT NULL /*COMMENT 'Length is based upon sum of max length of lsid text fields plus version'*/,
|
|
| 1297 | 1297 |
"sync_lsid_version" integer DEFAULT NULL, |
| 1298 |
"previous_lsid_full" varchar(150) DEFAULT NULL, |
|
| 1298 |
"previous_lsid_full" varchar(150) DEFAULT NULL /*COMMENT 'Length is based upon sum of max length of lsid text fields plus version'*/,
|
|
| 1299 | 1299 |
"previous_lsid_version" integer DEFAULT NULL, |
| 1300 |
"resolved_lsid_full" varchar(150) DEFAULT NULL, |
|
| 1300 |
"resolved_lsid_full" varchar(150) DEFAULT NULL /*COMMENT 'Length is based upon sum of max length of lsid text fields plus version'*/,
|
|
| 1301 | 1301 |
"resolved_lsid_version" integer DEFAULT NULL, |
| 1302 | 1302 |
"conflicted" integer DEFAULT NULL, |
| 1303 | 1303 |
"resolved" integer DEFAULT NULL, |
| ... | ... | |
| 1567 | 1567 |
"veg_indv_id" integer NOT NULL, |
| 1568 | 1568 |
"veg_subunit_id" integer DEFAULT NULL, |
| 1569 | 1569 |
"Rep_Collection_LSID_Object_ID" varchar(15) DEFAULT NULL, |
| 1570 |
"Collection_LSID_Object_ID" varchar(15) DEFAULT NULL, |
|
| 1570 |
"Collection_LSID_Object_ID" varchar(15) DEFAULT NULL /*COMMENT 'lsid of the collection collected from this individual'*/,
|
|
| 1571 | 1571 |
"tag_nbr" varchar(10) DEFAULT NULL, |
| 1572 | 1572 |
"x" float DEFAULT NULL, |
| 1573 | 1573 |
"y" float DEFAULT NULL, |
Also available in: Unified diff
bin/my2pg: comment out COMMENTs instead of removing them so that they will be included in the PostgreSQL translation. COMMENTs contain important metadata about columns, such as definitions and the meanings of integer flag values.