More cmap schema
Miskell, Craig
Craig.Miskell at agresearch.co.nz
Sun Jul 18 20:06:52 EDT 2004
I just poked a bit more, and discovered that the cmap_species data has 6
columns, but my schema only has 5. Schema:
CREATE TABLE cmap_species (
species_id number(11) DEFAULT '0' NOT NULL,
accession_id varchar2(20) DEFAULT '' NOT NULL,
common_name varchar2(64) DEFAULT '' NOT NULL,
full_name varchar2(64) DEFAULT '' NOT NULL,
display_order number(11) DEFAULT '1' NOT NULL,
CONSTRAINT pk_cmap_species PRIMARY KEY (species_id)
);
Data:
1 rice Rice Oryza sativa 1 4530
6 wheat Wheat Triticum aestivum 3 4565
2 barley Barley Hordeum vulgare 3 4513
3 oat Oat Avena sp. 3 50455
4 maize Maize Zea mays 4 4577
5 sorghum Sorghum Sorghum bicolor 4 4558
11 wildrice Wild rice Zizania palustris 2
103762
12 rye Rye Secale cereale 3
I'm definitely using cmap 0.11, which the gramene installation docs
indicate is correct for rel 13.0. It looks like I've missed something
critical - any suggestions?
Thanks,
Craig Miskell,
Technical Support,
AgResearch Invermay
03 489-9279
D: is just a data disk. That's why it's called "D", for "DATA".
C: is the Windows OS disk, so it's called "C", for "CRAP". --
David P. Murphy
=======================================================================
Attention: The information contained in this message and/or attachments
from AgResearch Limited is intended only for the persons or entities
to which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipients is prohibited by AgResearch
Limited. If you have received this message in error, please notify the
sender immediately.
=======================================================================
More information about the Gramene
mailing list