Revision 6876
Added by Aaron Marcuse-Kubitza almost 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 3375 | 3375 |
CREATE TABLE trait ( |
| 3376 | 3376 |
trait_id int(11) NOT NULL, |
| 3377 | 3377 |
taxonlabel_id int(11) NOT NULL, |
| 3378 |
type varchar(255) NOT NULL,
|
|
| 3378 |
name varchar(255) NOT NULL,
|
|
| 3379 | 3379 |
value varchar(255) |
| 3380 | 3380 |
); |
| 3381 | 3381 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 4472 | 4472 |
CREATE TABLE trait ( |
| 4473 | 4473 |
trait_id integer NOT NULL, |
| 4474 | 4474 |
taxonlabel_id integer NOT NULL, |
| 4475 |
type text NOT NULL,
|
|
| 4475 |
name text NOT NULL,
|
|
| 4476 | 4476 |
value text |
| 4477 | 4477 |
); |
| 4478 | 4478 |
|
Also available in: Unified diff
schemas/vegbien.sql: trait: Renamed type to name because TraitObservation stores trait names rather than types