[Biojava-dev] BioJava Nightly Build + BioSQL/MySQL problem...

[Michael Griffith]

Wonderful!  It works! Thanks to everyone!

As an aside there seems to be a table definition missing from the schema:

CREATE TABLE term_relationship_term (
    term_relationship_id INTEGER NOT NULL,
    term_id INTEGER NOT NULL,
        PRIMARY KEY ( term_relationship_id, term_id ),
        UNIQUE ( term_relationship_id ),
        UNIQUE ( term_id ) );

Cheers!

MG

On 8/3/04 1:09 PM, "Thomas Down" <td2 at sanger.ac.uk> wrote:

> 
> On 3 Aug 2004, at 18:56, Michael Griffith wrote:
> 
>> Thomas,
>> 
>> Thanks!  Not being an expert with mySQL -- how do you change the field
>> def?
>> I added [BINARY] after the Varchar def and tried creating the field as
>> Binary.  How should it be defined?
> 
> Actually, it looks like the solution to this may depend on the version
> of MySQL you're using.  See:
> 
>      http://dev.mysql.com/doc/mysql/en/CHAR.html
> 
> But on the version I'm running (4.0.17 I think), the following seems to
> work:
> 
> CREATE TABLE term (
>        term_id   INT(10) UNSIGNED NOT NULL auto_increment,
>        name               VARCHAR(255) BINARY NOT NULL,
>        definition         TEXT,
>        identifier         VARCHAR(40),
>        is_obsolete        CHAR(1),
>        ontology_id        INT(10) UNSIGNED NOT NULL,
>        PRIMARY KEY (term_id),
>        UNIQUE (name,ontology_id),
>        UNIQUE (identifier)
> ) TYPE=INNODB;
> 
> 
> Hope this works for you,
> 
>      Thomas.
> 
> _______________________________________________
> biojava-dev mailing list
> biojava-dev at biojava.org
> http://biojava.org/mailman/listinfo/biojava-dev
>