Index: table.sql
===================================================================
RCS file: /cvsroot/ensembl/ensembl/sql/table.sql,v
retrieving revision 1.440
diff -r1.440 table.sql
45,52c45,52
< 
<   asm_seq_region_id           INT(10) UNSIGNED NOT NULL,
<   cmp_seq_region_id           INT(10) UNSIGNED NOT NULL,
<   asm_start                   INT(10) NOT NULL,
<   asm_end                     INT(10) NOT NULL,
<   cmp_start                   INT(10) NOT NULL,
<   cmp_end                     INT(10) NOT NULL,
<   ori                         TINYINT  NOT NULL,
---
>   assembly_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
>   asm_seq_region_id           INTEGER UNSIGNED NOT NULL,
>   cmp_seq_region_id           INTEGER UNSIGNED NOT NULL,
>   asm_start                   INTEGER NOT NULL,
>   asm_end                     INTEGER NOT NULL,
>   cmp_start                   INTEGER NOT NULL,
>   cmp_end                     INTEGER NOT NULL,
>   ori                         TINYINT NOT NULL,
84,87c84,87
<   assembly_exception_id       INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
<   seq_region_id               INT(10) UNSIGNED NOT NULL,
<   seq_region_start            INT(10) UNSIGNED NOT NULL,
<   seq_region_end              INT(10) UNSIGNED NOT NULL,
---
>   assembly_exception_id       INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
>   seq_region_id               INTEGER UNSIGNED NOT NULL,
>   seq_region_start            INTEGER UNSIGNED NOT NULL,
>   seq_region_end              INTEGER UNSIGNED NOT NULL,
90,92c90,92
<   exc_seq_region_id           INT(10) UNSIGNED NOT NULL,
<   exc_seq_region_start        INT(10) UNSIGNED NOT NULL,
<   exc_seq_region_end          INT(10) UNSIGNED NOT NULL,
---
>   exc_seq_region_id           INTEGER UNSIGNED NOT NULL,
>   exc_seq_region_start        INTEGER UNSIGNED NOT NULL,
>   exc_seq_region_end          INTEGER UNSIGNED NOT NULL,
120c120
<   attrib_type_id              SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
---
>   attrib_type_id              INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
154,155c154,155
<   coord_system_id             INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
<   species_id                  INT(10) UNSIGNED NOT NULL DEFAULT 1,
---
>   coord_system_id             INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
>   species_id                  INTEGER UNSIGNED NOT NULL DEFAULT 1,
184c184
<   seq_region_id       INT(10) UNSIGNED NOT NULL,
---
>   seq_region_id       INTEGER UNSIGNED NOT NULL,
206c206
<   seq_region_id     INT(10) UNSIGNED NOT NULL,
---
>   seq_region_id     INTEGER UNSIGNED NOT NULL,
227c227
< @column is_current		    1 - exon is current. Always set to 1 in ensembl dbs, but needed for otterlace dbs
---
> @column is_current		    1 - exon is current.
240,244c240,244
<   exon_id                     INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
<   seq_region_id               INT(10) UNSIGNED NOT NULL,
<   seq_region_start            INT(10) UNSIGNED NOT NULL,
<   seq_region_end              INT(10) UNSIGNED NOT NULL,
<   seq_region_strand           TINYINT(2) NOT NULL,
---
>   exon_id                     INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
>   seq_region_id               INTEGER UNSIGNED NOT NULL,
>   seq_region_start            INTEGER UNSIGNED NOT NULL,
>   seq_region_end              INTEGER UNSIGNED NOT NULL,
>   seq_region_strand           TINYINT NOT NULL,
246,247c246,247
<   phase                       TINYINT(2) NOT NULL,
<   end_phase                   TINYINT(2) NOT NULL,
---
>   phase                       TINYINT NOT NULL,
>   end_phase                   TINYINT NOT NULL,
253c253
<   version                     SMALLINT UNSIGNED NOT NULL DEFAULT 1,
---
>   version                     INTEGER UNSIGNED NOT NULL DEFAULT 1,
269,274c269,271
< @column analysis_id                   Foreign key references to the @link analysis table.
< @column seq_region_id                 Foreign key references to the @link seq_region table.
< @column seq_region_start              Sequence start position.
< @column seq_region_end                Sequence end position.
< @column seq_region_strand             Sequence region strand: 1 - forward; -1 - reverse.
< @column hit_name		                  External entity name/identifier.
---
> @column previous_exon_id              Indicates the exon flanking upstream of the intron. Foreign key references to the @link exon table.
> @column next_exon_id                  Indicates the exon flanking downstream of the intron. Foreign key references to the @link exon table.
> @column hit_name		      External entity name/identifier.
277,309d273
< @column is_splice_canonical           Indicates if the splice junction can be considered canonical i.e. behaves according to accepted rules
< 
< @see transcript_intron_supporting_evidence
< 
< */
< 
< CREATE TABLE intron_supporting_evidence (
< 	intron_supporting_evidence_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
< 	analysis_id                   SMALLINT UNSIGNED NOT NULL,
< 	seq_region_id                 INT(10) UNSIGNED NOT NULL,
< 	seq_region_start              INT(10) UNSIGNED NOT NULL,
< 	seq_region_end                INT(10) UNSIGNED NOT NULL,
< 	seq_region_strand             TINYINT(2) NOT NULL,
< 	hit_name                      VARCHAR(100) NOT NULL,
< 	score                         DECIMAL(10,3),
< 	score_type                    ENUM('NONE', 'DEPTH') DEFAULT 'NONE',
< 	is_splice_canonical           BOOLEAN NOT NULL DEFAULT 0,
< 	
< 	PRIMARY KEY (intron_supporting_evidence_id),
< 	
< 	UNIQUE KEY (analysis_id, seq_region_id, seq_region_start, seq_region_end, seq_region_strand, hit_name),
< 	KEY seq_region_idx (seq_region_id, seq_region_start)
< 	
< ) COLLATE=latin1_swedish_ci ENGINE=MyISAM;
< 
< /**
< @table transcript_intron_supporting_evidence
< @desc Links intronic evidence to a pair of exons used within a transcript and to resolve the m:m relationship between introns and transcripts
< 
< @column intron_supporting_evidence_id Foreign key references to the @link intron_supporting_evidence table
< @column transcript_id                 Foreign key references to the @link transcript table.
< @column previous_exon_id              Foreign key to @link exon indicating the left hand flanking exon of the intron (assume forward strand)
< @column next_exon_id                  Foreign key to @link exon indicating the right hand flanking exon of the intron (assume forward strand)
311,312d274
< @see intron_supporting_evidence
< @see transcript
317,322c279,289
< CREATE TABLE transcript_intron_supporting_evidence (
< transcript_id                 INT(10) UNSIGNED NOT NULL,
< intron_supporting_evidence_id INT(10) UNSIGNED NOT NULL,
< previous_exon_id              INT(10) UNSIGNED NOT NULL,
< next_exon_id                  INT(10) UNSIGNED NOT NULL,
< PRIMARY KEY (intron_supporting_evidence_id, transcript_id)
---
> CREATE TABLE intron_supporting_evidence (
>   intron_supporting_evidence_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
>   previous_exon_id INTEGER UNSIGNED NOT NULL,
>   next_exon_id INTEGER UNSIGNED NOT NULL,
>   hit_name VARCHAR(100) NOT NULL,
>   score DECIMAL(10,3),
>   score_type ENUM('NONE', 'DEPTH') DEFAULT 'NONE',
>   
>   PRIMARY KEY (intron_supporting_evidence_id),
>   
>   UNIQUE KEY (previous_exon_id, next_exon_id)
325d291
< 
341,343c307,309
<   exon_id                     INT(10) UNSIGNED NOT NULL,
<   transcript_id               INT(10) UNSIGNED NOT NULL,
<   rank                        INT(10) NOT NULL,
---
>   exon_id                     INTEGER UNSIGNED NOT NULL,
>   transcript_id               INTEGER UNSIGNED NOT NULL,
>   rank                        INTEGER NOT NULL,
368c334
< @column is_current		    1 - gene is current. Always set to 1 in ensembl dbs, but needed for otterlace dbs
---
> @column is_current		    1 - gene is current.
383c349
<   gene_id                     INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
---
>   gene_id                     INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
385,390c351,356
<   analysis_id                 SMALLINT UNSIGNED NOT NULL,
<   seq_region_id               INT(10) UNSIGNED NOT NULL,
<   seq_region_start            INT(10) UNSIGNED NOT NULL,
<   seq_region_end              INT(10) UNSIGNED NOT NULL,
<   seq_region_strand           TINYINT(2) NOT NULL,
<   display_xref_id             INT(10) UNSIGNED,
---
>   analysis_id                 INTEGER UNSIGNED NOT NULL,
>   seq_region_id               INTEGER UNSIGNED NOT NULL,
>   seq_region_start            INTEGER UNSIGNED NOT NULL,
>   seq_region_end              INTEGER UNSIGNED NOT NULL,
>   seq_region_strand           TINYINT NOT NULL,
>   display_xref_id             INTEGER UNSIGNED,
395c361
<   canonical_transcript_id     INT(10) UNSIGNED NOT NULL,
---
>   canonical_transcript_id     INTEGER UNSIGNED NOT NULL,
398c364
<   version                     SMALLINT UNSIGNED NOT NULL DEFAULT 1,
---
>   version                     INTEGER UNSIGNED NOT NULL DEFAULT 1,
426,428c392,394
< 
<   gene_id                     INT(10) UNSIGNED NOT NULL DEFAULT '0',
<   attrib_type_id              SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
---
>   gene_attrib_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
>   gene_id                     INTEGER UNSIGNED NOT NULL DEFAULT '0',
>   attrib_type_id              INTEGER UNSIGNED NOT NULL DEFAULT '0',
453,456c419,422
<   karyotype_id                INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
<   seq_region_id               INT(10) UNSIGNED NOT NULL,
<   seq_region_start            INT(10) UNSIGNED NOT NULL,
<   seq_region_end              INT(10) UNSIGNED NOT NULL,
---
>   karyotype_id                INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
>   seq_region_id               INTEGER UNSIGNED NOT NULL,
>   seq_region_start            INTEGER UNSIGNED NOT NULL,
>   seq_region_end              INTEGER UNSIGNED NOT NULL,
492c458
<   species_id                  INT UNSIGNED DEFAULT 1,
---
>   species_id                  INTEGER UNSIGNED DEFAULT 1,
506c472
<   (NULL, 'schema_version',  '68');
---
>   (NULL, 'schema_version',  '67');
512,516c478,482
<   (NULL, 'patch', 'patch_67_68_a.sql|schema_version'),
<   (NULL, 'patch', 'patch_67_68_b.sql|xref_uniqueness'),
<   (NULL, 'patch', 'patch_67_68_c.sql|altering_intron_supporting_evidence'),
<   (NULL, 'patch', 'patch_67_68_d.sql|add_is_splice_canonical_and_seq_index'),
<   (NULL, 'patch', 'patch_67_68_e.sql|fix_67_68_e_xref_index')
---
>   (NULL, 'patch', 'patch_66_67_a.sql|schema_version'),
>   (NULL, 'patch', 'patch_66_67_b.sql|drop_stable_id_views'),
>   (NULL, 'patch', 'patch_66_67_c.sql|adding_intron_supporting_evidence'),
>   (NULL, 'patch', 'patch_66_67_d.sql|adding_gene_transcript_annotated'),
>   (NULL, 'patch', 'patch_66_67_e.sql|index_canonical_transcript_id')
533c499
< 
---
>   meta_coord_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
535,536c501,502
<   coord_system_id             INT(10) UNSIGNED NOT NULL,
<   max_length                  INT,
---
>   coord_system_id             INTEGER UNSIGNED NOT NULL,
>   max_length                  INTEGER,
563,567c529,533
<   operon_id                 INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
<   seq_region_id             INT(10) UNSIGNED NOT NULL,
<   seq_region_start          INT(10) UNSIGNED NOT NULL,
<   seq_region_end            INT(10) UNSIGNED NOT NULL,
<   seq_region_strand         TINYINT(2) NOT NULL,
---
>   operon_id                 INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
>   seq_region_id             INTEGER UNSIGNED NOT NULL,
>   seq_region_start          INTEGER UNSIGNED NOT NULL,
>   seq_region_end            INTEGER UNSIGNED NOT NULL,
>   seq_region_strand         TINYINT NOT NULL,
569c535
<   analysis_id               SMALLINT UNSIGNED NOT NULL,
---
>   analysis_id               INTEGER UNSIGNED NOT NULL,
571c537
<   version                   SMALLINT UNSIGNED NOT NULL DEFAULT 1,
---
>   version                   INTEGER UNSIGNED NOT NULL DEFAULT 1,
604,609c570,575
<   operon_transcript_id      INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
<   seq_region_id             INT(10) UNSIGNED NOT NULL,
<   seq_region_start          INT(10) UNSIGNED NOT NULL,
<   seq_region_end            INT(10) UNSIGNED NOT NULL,
<   seq_region_strand         TINYINT(2) NOT NULL,
<   operon_id                 INT(10) UNSIGNED NOT NULL,
---
>   operon_transcript_id      INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
>   seq_region_id             INTEGER UNSIGNED NOT NULL,
>   seq_region_start          INTEGER UNSIGNED NOT NULL,
>   seq_region_end            INTEGER UNSIGNED NOT NULL,
>   seq_region_strand         TINYINT NOT NULL,
>   operon_id                 INTEGER UNSIGNED NOT NULL,
611c577
<   analysis_id               SMALLINT UNSIGNED NOT NULL,
---
>   analysis_id               INTEGER UNSIGNED NOT NULL,
613c579
<   version                   SMALLINT UNSIGNED NOT NULL DEFAULT 1,
---
>   version                   INTEGER UNSIGNED NOT NULL DEFAULT 1,
635,636c601,603
<   operon_transcript_id      INT(10) UNSIGNED,
<   gene_id                   INT(10) UNSIGNED,
---
>   operon_transcript_gene_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
>   operon_transcript_id      INTEGER UNSIGNED,
>   gene_id                   INTEGER UNSIGNED,
662c629
<   seq_region_id               INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
---
>   seq_region_id               INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
664,665c631,632
<   coord_system_id             INT(10) UNSIGNED NOT NULL,
<   length                      INT(10) UNSIGNED NOT NULL,
---
>   coord_system_id             INTEGER UNSIGNED NOT NULL,
>   length                      INTEGER UNSIGNED NOT NULL,
691,693c658,660
< 
<   seq_region_id               INT(10) UNSIGNED NOT NULL DEFAULT '0',
<   attrib_type_id              SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
---
>   seq_region_attrib_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
>   seq_region_id               INTEGER UNSIGNED NOT NULL DEFAULT '0',
>   attrib_type_id              INTEGER UNSIGNED NOT NULL DEFAULT '0',
720c687
< @column is_current		    Indicates a current transcript. Always set to 1 in ensembl dbs, but needed for otterlace dbs
---
> @column is_current		    Indicates a current transcript.
732,739c699,706
<   transcript_id               INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
<   gene_id                     INT(10) UNSIGNED,
<   analysis_id                 SMALLINT UNSIGNED NOT NULL,
<   seq_region_id               INT(10) UNSIGNED NOT NULL,
<   seq_region_start            INT(10) UNSIGNED NOT NULL,
<   seq_region_end              INT(10) UNSIGNED NOT NULL,
<   seq_region_strand           TINYINT(2) NOT NULL,
<   display_xref_id             INT(10) UNSIGNED,
---
>   transcript_id               INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
>   gene_id                     INTEGER UNSIGNED,
>   analysis_id                 INTEGER UNSIGNED NOT NULL,
>   seq_region_id               INTEGER UNSIGNED NOT NULL,
>   seq_region_start            INTEGER UNSIGNED NOT NULL,
>   seq_region_end              INTEGER UNSIGNED NOT NULL,
>   seq_region_strand           TINYINT NOT NULL,
>   display_xref_id             INTEGER UNSIGNED,
744c711
<   canonical_translation_id    INT(10) UNSIGNED,
---
>   canonical_translation_id    INTEGER UNSIGNED,
746c713
<   version                     SMALLINT UNSIGNED NOT NULL DEFAULT 1,
---
>   version                     INTEGER UNSIGNED NOT NULL DEFAULT 1,
776,778c743,745
< 
<   transcript_id               INT(10) UNSIGNED NOT NULL DEFAULT '0',
<   attrib_type_id              SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
---
>   transcript_attrib_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
>   transcript_id               INTEGER UNSIGNED NOT NULL DEFAULT '0',
>   attrib_type_id              INTEGER UNSIGNED NOT NULL DEFAULT '0',
807,812c774,779
<   translation_id              INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
<   transcript_id               INT(10) UNSIGNED NOT NULL,
<   seq_start                   INT(10) NOT NULL,       # relative to exon start
<   start_exon_id               INT(10) UNSIGNED NOT NULL,
<   seq_end                     INT(10) NOT NULL,       # relative to exon start
<   end_exon_id                 INT(10) UNSIGNED NOT NULL,
---
>   translation_id              INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
>   transcript_id               INTEGER UNSIGNED NOT NULL,
>   seq_start                   INTEGER NOT NULL,       # relative to exon start
>   start_exon_id               INTEGER UNSIGNED NOT NULL,
>   seq_end                     INTEGER NOT NULL,       # relative to exon start
>   end_exon_id                 INTEGER UNSIGNED NOT NULL,
814c781
<   version                     SMALLINT UNSIGNED NOT NULL DEFAULT 1,
---
>   version                     INTEGER UNSIGNED NOT NULL DEFAULT 1,
840,842c807,809
< 
<   translation_id              INT(10) UNSIGNED NOT NULL DEFAULT '0',
<   attrib_type_id              SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
---
>   translation_attrib_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
>   translation_id              INTEGER UNSIGNED NOT NULL DEFAULT '0',
>   attrib_type_id              INTEGER UNSIGNED NOT NULL DEFAULT '0',
864,866c831,833
< 
<        transcript_id    INT(10) UNSIGNED NOT NULL,
<        gene_id          INT(10) UNSIGNED NOT NULL,
---
>   unconventional_transcript_association_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
>        transcript_id    INTEGER UNSIGNED NOT NULL,
>        gene_id          INTEGER UNSIGNED NOT NULL,
894,895c861,862
<   alt_allele_id         INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
<   gene_id               INT(10) UNSIGNED NOT NULL,
---
>   alt_allele_id         INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
>   gene_id               INTEGER UNSIGNED NOT NULL,
932c899
<   analysis_id                 SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
---
>   analysis_id                 INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
967,968c934,935
< 
<   analysis_id                  SMALLINT UNSIGNED NOT NULL,
---
>   analysis_description INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
>   analysis_id                  INTEGER UNSIGNED NOT NULL,
998,1002c965,969
<   density_feature_id    INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
<   density_type_id       INT(10) UNSIGNED NOT NULL,
<   seq_region_id         INT(10) UNSIGNED NOT NULL,
<   seq_region_start      INT(10) UNSIGNED NOT NULL,
<   seq_region_end        INT(10) UNSIGNED NOT NULL,
---
>   density_feature_id    INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
>   density_type_id       INTEGER UNSIGNED NOT NULL,
>   seq_region_id         INTEGER UNSIGNED NOT NULL,
>   seq_region_start      INTEGER UNSIGNED NOT NULL,
>   seq_region_end        INTEGER UNSIGNED NOT NULL,
1031,1032c998,999
<   density_type_id       INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
<   analysis_id           SMALLINT UNSIGNED NOT NULL,
---
>   density_type_id       INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
>   analysis_id           INTEGER UNSIGNED NOT NULL,
1061c1028
<        ditag_id          INT(10) UNSIGNED NOT NULL auto_increment,
---
>        ditag_id          INTEGER UNSIGNED NOT NULL auto_increment,
1064c1031
<        tag_count         smallint(6) UNSIGNED NOT NULL default 1,
---
>        tag_count         INTEGER UNSIGNED NOT NULL default 1,
1098,1108c1065,1075
<        ditag_feature_id   INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
<        ditag_id           INT(10) UNSIGNED NOT NULL default '0',
<        ditag_pair_id      INT(10) UNSIGNED NOT NULL default '0',
<        seq_region_id      INT(10) UNSIGNED NOT NULL default '0',
<        seq_region_start   INT(10) UNSIGNED NOT NULL default '0',
<        seq_region_end     INT(10) UNSIGNED NOT NULL default '0',
<        seq_region_strand  TINYINT(1) NOT NULL default '0',
<        analysis_id        SMALLINT UNSIGNED NOT NULL default '0',
<        hit_start          INT(10) UNSIGNED NOT NULL default '0',
<        hit_end            INT(10) UNSIGNED NOT NULL default '0',
<        hit_strand         TINYINT(1) NOT NULL default '0',
---
>        ditag_feature_id   INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
>        ditag_id           INTEGER UNSIGNED NOT NULL default '0',
>        ditag_pair_id      INTEGER UNSIGNED NOT NULL default '0',
>        seq_region_id      INTEGER UNSIGNED NOT NULL default '0',
>        seq_region_start   INTEGER UNSIGNED NOT NULL default '0',
>        seq_region_end     INTEGER UNSIGNED NOT NULL default '0',
>        seq_region_strand  TINYINT NOT NULL default '0',
>        analysis_id        INTEGER UNSIGNED NOT NULL default '0',
>        hit_start          INTEGER UNSIGNED NOT NULL default '0',
>        hit_end            INTEGER UNSIGNED NOT NULL default '0',
>        hit_strand         TINYINT NOT NULL default '0',
1151,1155c1118,1122
<   dna_align_feature_id        INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
<   seq_region_id               INT(10) UNSIGNED NOT NULL,
<   seq_region_start            INT(10) UNSIGNED NOT NULL,
<   seq_region_end              INT(10) UNSIGNED NOT NULL,
<   seq_region_strand           TINYINT(1) NOT NULL,
---
>   dna_align_feature_id        INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
>   seq_region_id               INTEGER UNSIGNED NOT NULL,
>   seq_region_start            INTEGER UNSIGNED NOT NULL,
>   seq_region_end              INTEGER UNSIGNED NOT NULL,
>   seq_region_strand           TINYINT NOT NULL,
1158c1125
<   hit_strand                  TINYINT(1) NOT NULL,
---
>   hit_strand                  TINYINT NOT NULL,
1160c1127
<   analysis_id                 SMALLINT UNSIGNED NOT NULL,
---
>   analysis_id                 INTEGER UNSIGNED NOT NULL,
1168c1135
<   pair_dna_align_feature_id   INT(10) UNSIGNED,
---
>   pair_dna_align_feature_id   INTEGER UNSIGNED,
1197c1164
<   map_id                      INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
---
>   map_id                      INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
1227,1228c1194,1195
<   marker_id                   INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
<   display_marker_synonym_id   INT(10) UNSIGNED,
---
>   marker_id                   INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
>   display_marker_synonym_id   INTEGER UNSIGNED,
1231,1233c1198,1200
<   min_primer_dist             INT(10) UNSIGNED NOT NULL,
<   max_primer_dist             INT(10) UNSIGNED NOT NULL,
<   priority                    INT,
---
>   min_primer_dist             INTEGER UNSIGNED NOT NULL,
>   max_primer_dist             INTEGER UNSIGNED NOT NULL,
>   priority                    INTEGER,
1265,1271c1232,1238
<   marker_feature_id           INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
<   marker_id                   INT(10) UNSIGNED NOT NULL,
<   seq_region_id               INT(10) UNSIGNED NOT NULL,
<   seq_region_start            INT(10) UNSIGNED NOT NULL,
<   seq_region_end              INT(10) UNSIGNED NOT NULL,
<   analysis_id                 SMALLINT UNSIGNED NOT NULL,
<   map_weight                  INT(10) UNSIGNED,
---
>   marker_feature_id           INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
>   marker_id                   INTEGER UNSIGNED NOT NULL,
>   seq_region_id               INTEGER UNSIGNED NOT NULL,
>   seq_region_start            INTEGER UNSIGNED NOT NULL,
>   seq_region_end              INTEGER UNSIGNED NOT NULL,
>   analysis_id                 INTEGER UNSIGNED NOT NULL,
>   map_weight                  INTEGER UNSIGNED,
1300,1301c1267,1268
<   marker_id                   INT(10) UNSIGNED NOT NULL,
<   map_id                      INT(10) UNSIGNED NOT NULL,
---
>   marker_id                   INTEGER UNSIGNED NOT NULL,
>   map_id                      INTEGER UNSIGNED NOT NULL,
1303c1270
<   marker_synonym_id           INT(10) UNSIGNED NOT NULL,
---
>   marker_synonym_id           INTEGER UNSIGNED NOT NULL,
1329,1330c1296,1297
<   marker_synonym_id           INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
<   marker_id                   INT(10) UNSIGNED NOT NULL,
---
>   marker_synonym_id           INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
>   marker_id                   INTEGER UNSIGNED NOT NULL,
1356,1358c1323,1325
< 
<   misc_feature_id             INT(10) UNSIGNED NOT NULL DEFAULT '0',
<   attrib_type_id              SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
---
>   misc_attrib_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
>   misc_feature_id             INTEGER UNSIGNED NOT NULL DEFAULT '0',
>   attrib_type_id              INTEGER UNSIGNED NOT NULL DEFAULT '0',
1385,1389c1352,1356
<   misc_feature_id             INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
<   seq_region_id               INT(10) UNSIGNED NOT NULL DEFAULT '0',
<   seq_region_start            INT(10) UNSIGNED NOT NULL DEFAULT '0',
<   seq_region_end              INT(10) UNSIGNED NOT NULL DEFAULT '0',
<   seq_region_strand           TINYINT(4) NOT NULL DEFAULT '0',
---
>   misc_feature_id             INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
>   seq_region_id               INTEGER UNSIGNED NOT NULL DEFAULT '0',
>   seq_region_start            INTEGER UNSIGNED NOT NULL DEFAULT '0',
>   seq_region_end              INTEGER UNSIGNED NOT NULL DEFAULT '0',
>   seq_region_strand           TINYINT NOT NULL DEFAULT '0',
1413,1414c1380,1381
<   misc_feature_id             INT(10) UNSIGNED NOT NULL DEFAULT '0',
<   misc_set_id                 SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
---
>   misc_feature_id             INTEGER UNSIGNED NOT NULL DEFAULT '0',
>   misc_set_id                 INTEGER UNSIGNED NOT NULL DEFAULT '0',
1441c1408
<   misc_set_id                 SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
---
>   misc_set_id                 INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
1445c1412
<   max_length                  INT UNSIGNED NOT NULL,
---
>   max_length                  INTEGER UNSIGNED NOT NULL,
1474,1479c1441,1446
<   prediction_exon_id          INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
<   prediction_transcript_id    INT(10) UNSIGNED NOT NULL,
<   exon_rank                   SMALLINT UNSIGNED NOT NULL,
<   seq_region_id               INT(10) UNSIGNED NOT NULL,
<   seq_region_start            INT(10) UNSIGNED NOT NULL,
<   seq_region_end              INT(10) UNSIGNED NOT NULL,
---
>   prediction_exon_id          INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
>   prediction_transcript_id    INTEGER UNSIGNED NOT NULL,
>   exon_rank                   INTEGER UNSIGNED NOT NULL,
>   seq_region_id               INTEGER UNSIGNED NOT NULL,
>   seq_region_start            INTEGER UNSIGNED NOT NULL,
>   seq_region_end              INTEGER UNSIGNED NOT NULL,
1510,1513c1477,1480
<   prediction_transcript_id    INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
<   seq_region_id               INT(10) UNSIGNED NOT NULL,
<   seq_region_start            INT(10) UNSIGNED NOT NULL,
<   seq_region_end              INT(10) UNSIGNED NOT NULL,
---
>   prediction_transcript_id    INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
>   seq_region_id               INTEGER UNSIGNED NOT NULL,
>   seq_region_start            INTEGER UNSIGNED NOT NULL,
>   seq_region_end              INTEGER UNSIGNED NOT NULL,
1515c1482
<   analysis_id                 SMALLINT UNSIGNED NOT NULL,
---
>   analysis_id                 INTEGER UNSIGNED NOT NULL,
1554,1560c1521,1527
<   protein_align_feature_id    INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
<   seq_region_id               INT(10) UNSIGNED NOT NULL,
<   seq_region_start            INT(10) UNSIGNED NOT NULL,
<   seq_region_end              INT(10) UNSIGNED NOT NULL,
<   seq_region_strand           TINYINT(1) DEFAULT '1' NOT NULL,
<   hit_start                   INT(10) NOT NULL,
<   hit_end                     INT(10) NOT NULL,
---
>   protein_align_feature_id    INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
>   seq_region_id               INTEGER UNSIGNED NOT NULL,
>   seq_region_start            INTEGER UNSIGNED NOT NULL,
>   seq_region_end              INTEGER UNSIGNED NOT NULL,
>   seq_region_strand           TINYINT DEFAULT '1' NOT NULL,
>   hit_start                   INTEGER NOT NULL,
>   hit_end                     INTEGER NOT NULL,
1562c1529
<   analysis_id                 SMALLINT UNSIGNED NOT NULL,
---
>   analysis_id                 INTEGER UNSIGNED NOT NULL,
1605,1610c1572,1577
<   protein_feature_id          INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
<   translation_id              INT(10) UNSIGNED NOT NULL,
<   seq_start                   INT(10) NOT NULL,
<   seq_end                     INT(10) NOT NULL,
<   hit_start                   INT(10) NOT NULL,
<   hit_end                     INT(10) NOT NULL,
---
>   protein_feature_id          INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
>   translation_id              INTEGER UNSIGNED NOT NULL,
>   seq_start                   INTEGER NOT NULL,
>   seq_end                     INTEGER NOT NULL,
>   hit_start                   INTEGER NOT NULL,
>   hit_end                     INTEGER NOT NULL,
1612c1579
<   analysis_id                 SMALLINT UNSIGNED NOT NULL,
---
>   analysis_id                 INTEGER UNSIGNED NOT NULL,
1646,1647c1613
< 
<   qtl_id                      INT(10) UNSIGNED AUTO_INCREMENT NOT NULL,
---
>   qtl_id                      INTEGER UNSIGNED AUTO_INCREMENT NOT NULL,
1650,1652c1616,1618
<   flank_marker_id_1           INT(10) UNSIGNED,
<   flank_marker_id_2           INT(10) UNSIGNED,
<   peak_marker_id              INT(10) UNSIGNED,
---
>   flank_marker_id_1           INTEGER UNSIGNED,
>   flank_marker_id_2           INTEGER UNSIGNED,
>   peak_marker_id              INTEGER UNSIGNED,
1681,1686c1647,1652
< 
<   seq_region_id         INT(10) UNSIGNED NOT NULL,
<   seq_region_start      INT(10) UNSIGNED NOT NULL,
<   seq_region_end        INT(10) UNSIGNED NOT NULL,
<   qtl_id                INT(10) UNSIGNED NOT NULL,
<   analysis_id           SMALLINT UNSIGNED NOT NULL,
---
>   qtl_feature_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
>   seq_region_id         INTEGER UNSIGNED NOT NULL,
>   seq_region_start      INTEGER UNSIGNED NOT NULL,
>   seq_region_end        INTEGER UNSIGNED NOT NULL,
>   qtl_id                INTEGER UNSIGNED NOT NULL,
>   analysis_id           INTEGER UNSIGNED NOT NULL,
1710,1711c1676,1677
<   qtl_synonym_id              INT(10) UNSIGNED AUTO_INCREMENT NOT NULL,
<   qtl_id                      INT(10) UNSIGNED NOT NULL,
---
>   qtl_synonym_id              INTEGER UNSIGNED AUTO_INCREMENT NOT NULL,
>   qtl_id                      INTEGER UNSIGNED NOT NULL,
1737c1703
<   repeat_consensus_id         INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
---
>   repeat_consensus_id         INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
1773,1781c1739,1747
<   repeat_feature_id           INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
<   seq_region_id               INT(10) UNSIGNED NOT NULL,
<   seq_region_start            INT(10) UNSIGNED NOT NULL,
<   seq_region_end              INT(10) UNSIGNED NOT NULL,
<   seq_region_strand           TINYINT(1) DEFAULT '1' NOT NULL,
<   repeat_start                INT(10) NOT NULL,
<   repeat_end                  INT(10) NOT NULL,
<   repeat_consensus_id         INT(10) UNSIGNED NOT NULL,
<   analysis_id                 SMALLINT UNSIGNED NOT NULL,
---
>   repeat_feature_id           INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
>   seq_region_id               INTEGER UNSIGNED NOT NULL,
>   seq_region_start            INTEGER UNSIGNED NOT NULL,
>   seq_region_end              INTEGER UNSIGNED NOT NULL,
>   seq_region_strand           TINYINT DEFAULT '1' NOT NULL,
>   repeat_start                INTEGER NOT NULL,
>   repeat_end                  INTEGER NOT NULL,
>   repeat_consensus_id         INTEGER UNSIGNED NOT NULL,
>   analysis_id                 INTEGER UNSIGNED NOT NULL,
1812,1816c1778,1782
<   simple_feature_id           INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
<   seq_region_id               INT(10) UNSIGNED NOT NULL,
<   seq_region_start            INT(10) UNSIGNED NOT NULL,
<   seq_region_end              INT(10) UNSIGNED NOT NULL,
<   seq_region_strand           TINYINT(1) NOT NULL,
---
>   simple_feature_id           INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
>   seq_region_id               INTEGER UNSIGNED NOT NULL,
>   seq_region_start            INTEGER UNSIGNED NOT NULL,
>   seq_region_end              INTEGER UNSIGNED NOT NULL,
>   seq_region_strand           TINYINT NOT NULL,
1818c1784
<   analysis_id                 SMALLINT UNSIGNED NOT NULL,
---
>   analysis_id                 INTEGER UNSIGNED NOT NULL,
1849c1815
<   splicing_event_id       INT(10)  UNSIGNED NOT NULL AUTO_INCREMENT,
---
>   splicing_event_id       INTEGER  UNSIGNED NOT NULL AUTO_INCREMENT,
1851,1856c1817,1822
<   gene_id                 INT(10) UNSIGNED NOT NULL,
<   seq_region_id           INT(10) UNSIGNED NOT NULL,
<   seq_region_start        INT(10) UNSIGNED NOT NULL,
<   seq_region_end          INT(10) UNSIGNED NOT NULL,
<   seq_region_strand       TINYINT(2) NOT NULL,
<   attrib_type_id          SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
---
>   gene_id                 INTEGER UNSIGNED NOT NULL,
>   seq_region_id           INTEGER UNSIGNED NOT NULL,
>   seq_region_start        INTEGER UNSIGNED NOT NULL,
>   seq_region_end          INTEGER UNSIGNED NOT NULL,
>   seq_region_strand       TINYINT NOT NULL,
>   attrib_type_id          INTEGER UNSIGNED NOT NULL DEFAULT 0,
1885,1890c1851,1856
<   splicing_event_feature_id INT(10)  UNSIGNED NOT NULL,
<   splicing_event_id         INT(10)  UNSIGNED NOT NULL,
<   exon_id                   INT(10)  UNSIGNED NOT NULL,
<   transcript_id             INT(10)  UNSIGNED NOT NULL,
<   feature_order             INT(10)  UNSIGNED NOT NULL,
<   transcript_association    INT(10)  UNSIGNED NOT NULL,
---
>   splicing_event_feature_id INTEGER  UNSIGNED NOT NULL,
>   splicing_event_id         INTEGER  UNSIGNED NOT NULL,
>   exon_id                   INTEGER  UNSIGNED NOT NULL,
>   transcript_id             INTEGER  UNSIGNED NOT NULL,
>   feature_order             INTEGER  UNSIGNED NOT NULL,
>   transcript_association    INTEGER  UNSIGNED NOT NULL,
1892,1893c1858,1859
<   start                     INT(10)  UNSIGNED NOT NULL,
<   end                       INT(10)  UNSIGNED NOT NULL,
---
>   start                     INTEGER  UNSIGNED NOT NULL,
>   end                       INTEGER  UNSIGNED NOT NULL,
1920,1923c1886,1889
<   splicing_transcript_pair_id INT(10)  UNSIGNED NOT NULL,
<   splicing_event_id           INT(10)  UNSIGNED NOT NULL,
<   transcript_id_1             INT(10)  UNSIGNED NOT NULL,
<   transcript_id_2             INT(10)  UNSIGNED NOT NULL,
---
>   splicing_transcript_pair_id INTEGER  UNSIGNED NOT NULL,
>   splicing_event_id           INTEGER  UNSIGNED NOT NULL,
>   transcript_id_1             INTEGER  UNSIGNED NOT NULL,
>   transcript_id_2             INTEGER  UNSIGNED NOT NULL,
1947,1948c1913,1914
< 
<   exon_id                     INT(10) UNSIGNED DEFAULT '0' NOT NULL,
---
>   supporting_feature_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
>   exon_id                     INTEGER UNSIGNED DEFAULT '0' NOT NULL,
1950c1916
<   feature_id                  INT(10) UNSIGNED DEFAULT '0' NOT NULL,
---
>   feature_id                  INTEGER UNSIGNED DEFAULT '0' NOT NULL,
1971,1972c1937,1938
< 
<   transcript_id               INT(10) UNSIGNED DEFAULT '0' NOT NULL,
---
>   transcript_supporting_feature_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, 
>   transcript_id               INTEGER UNSIGNED DEFAULT '0' NOT NULL,
1974c1940
<   feature_id                  INT(10) UNSIGNED DEFAULT '0' NOT NULL,
---
>   feature_id                  INTEGER UNSIGNED DEFAULT '0' NOT NULL,
2008c1974
< 
---
>   gene_archive_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
2010c1976
<   gene_version                SMALLINT NOT NULL DEFAULT 1,
---
>   gene_version                INTEGER NOT NULL DEFAULT 1,
2012c1978
<   transcript_version          SMALLINT NOT NULL DEFAULT 1,
---
>   transcript_version          INTEGER NOT NULL DEFAULT 1,
2014,2016c1980,1982
<   translation_version         SMALLINT NOT NULL DEFAULT 1,
<   peptide_archive_id          INT(10) UNSIGNED,
<   mapping_session_id          INT(10) UNSIGNED NOT NULL,
---
>   translation_version         INTEGER NOT NULL DEFAULT 1,
>   peptide_archive_id          INTEGER UNSIGNED,
>   mapping_session_id          INTEGER UNSIGNED NOT NULL,
2047c2013
<   mapping_session_id          INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
---
>   mapping_session_id          INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
2073c2039
<         mapping_set_id  INT(10) UNSIGNED NOT NULL,
---
>         mapping_set_id  INTEGER UNSIGNED NOT NULL,
2076c2042
<         PRIMARY KEY(schema_build)
---
>         PRIMARY KEY(mapping_set_id)
2101c2067
< 
---
>   stable_id_event_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
2103c2069
<   old_version               SMALLINT,
---
>   old_version               INTEGER,
2105,2106c2071,2072
<   new_version               SMALLINT,
<   mapping_session_id        INT(10) UNSIGNED NOT NULL DEFAULT '0',
---
>   new_version               INTEGER,
>   mapping_session_id        INTEGER UNSIGNED NOT NULL DEFAULT '0',
2132c2098
<   peptide_archive_id         INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
---
>   peptide_archive_id         INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
2157,2160c2123,2126
< 
<         external_seq_region_id  INT(10) UNSIGNED NOT NULL,
<         internal_seq_region_id  INT(10) UNSIGNED NOT NULL,
<         mapping_set_id          INT(10) UNSIGNED NOT NULL,
---
>   seq_region_mapping_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
>         external_seq_region_id  INTEGER UNSIGNED NOT NULL,
>         internal_seq_region_id  INTEGER UNSIGNED NOT NULL,
>         mapping_set_id          INTEGER UNSIGNED NOT NULL,
2191a2158,2160
>   object_xref_id         INTEGER UNSIGNED NOT NULL,
>   master_xref_id         INTEGER UNSIGNED NOT NULL,
>   dependent_xref_id      INTEGER UNSIGNED NOT NULL,
2193,2198c2162,2163
<   object_xref_id         INT NOT NULL,
<   master_xref_id         INT NOT NULL,
<   dependent_xref_id      INT NOT NULL,
< 
<   PRIMARY KEY( object_xref_id ),
<   KEY dependent ( dependent_xref_id ),
---
>   PRIMARY KEY (object_xref_id),
>   KEY dependent (dependent_xref_id),
2264c2229
<   xref_id                     INT(10) UNSIGNED NOT NULL,
---
>   xref_id                     INTEGER UNSIGNED NOT NULL,
2297,2304c2262,2269
<   object_xref_id          INT(10) UNSIGNED NOT NULL,
<   xref_identity           INT(5),
<   ensembl_identity        INT(5),
< 
<   xref_start              INT,
<   xref_end                INT,
<   ensembl_start           INT,
<   ensembl_end             INT,
---
>   object_xref_id          INTEGER UNSIGNED NOT NULL,
>   xref_identity           INTEGER,
>   ensembl_identity        INTEGER,
> 
>   xref_start              INTEGER,
>   xref_end                INTEGER,
>   ensembl_start           INTEGER,
>   ensembl_end             INTEGER,
2339,2340c2304,2305
<   object_xref_id              INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
<   ensembl_id                  INT(10) UNSIGNED NOT NULL,
---
>   object_xref_id              INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
>   ensembl_id                  INTEGER UNSIGNED NOT NULL,
2344c2309
<   xref_id                     INT UNSIGNED NOT NULL,
---
>   xref_id                     INTEGER UNSIGNED NOT NULL,
2346c2311
<   analysis_id                 SMALLINT UNSIGNED DEFAULT 0 NOT NULL,
---
>   analysis_id                 INTEGER UNSIGNED DEFAULT NULL,
2386,2388c2351,2353
< 
<   object_xref_id          INT(10) UNSIGNED DEFAULT '0' NOT NULL,
<   source_xref_id          INT(10) UNSIGNED DEFAULT NULL,
---
>   ontology_xref_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
>   object_xref_id          INTEGER UNSIGNED DEFAULT '0' NOT NULL,
>   source_xref_id          INTEGER UNSIGNED DEFAULT NULL,
2411,2412c2376,2377
<   seq_region_synonym_id       INT UNSIGNED NOT NULL  AUTO_INCREMENT,
<   seq_region_id               INT(10) UNSIGNED NOT NULL,
---
>   seq_region_synonym_id       INTEGER UNSIGNED NOT NULL  AUTO_INCREMENT,
>   seq_region_id               INTEGER UNSIGNED NOT NULL,
2447c2412
<   unmapped_object_id    INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
---
>   unmapped_object_id    INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
2449c2414
<   analysis_id           SMALLINT UNSIGNED NOT NULL,
---
>   analysis_id           INTEGER UNSIGNED NOT NULL,
2452c2417
<   unmapped_reason_id    SMALLINT(5) UNSIGNED NOT NULL,
---
>   unmapped_reason_id    INTEGER UNSIGNED NOT NULL,
2455c2420
<   ensembl_id            INT(10) UNSIGNED DEFAULT '0',
---
>   ensembl_id            INTEGER UNSIGNED DEFAULT '0',
2482c2447
<   unmapped_reason_id     SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
---
>   unmapped_reason_id     INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
2514c2479
<    xref_id                    INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
---
>    xref_id                    INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
2520c2485
<    info_type                  ENUM( 'NONE', 'PROJECTION', 'MISC', 'DEPENDENT',
---
>    info_type                  ENUM( 'PROJECTION', 'MISC', 'DEPENDENT',
2524,2525c2489,2490
<                                     'CHECKSUM' ) DEFAULT 'NONE' NOT NULL,
<    info_text                  VARCHAR(255) DEFAULT '' NOT NULL,
---
>                                     'CHECKSUM' ),
>    info_text                  VARCHAR(255),
2528c2493
<    UNIQUE KEY id_index (dbprimary_acc, external_db_id, info_type, info_text, version),
---
>    UNIQUE KEY id_index (dbprimary_acc, external_db_id, info_type, info_text),
2553a2519
>   interpro_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
2577,2579c2543,2545
<   data_file_id int(11) unsigned NOT NULL AUTO_INCREMENT,
<   coord_system_id int(11) NOT NULL,
<   analysis_id int(11) NOT NULL,
---
>   data_file_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
>   coord_system_id INTEGER UNSIGNED NOT NULL,
>   analysis_id INTEGER UNSIGNED NOT NULL,
2581,2582c2547,2548
<   version_lock tinyint(1) DEFAULT 0 NOT NULL,
<   absolute tinyint(1) DEFAULT 0 NOT NULL,
---
>   version_lock TINYINT DEFAULT 0 NOT NULL,
>   absolute TINYINT DEFAULT 0 NOT NULL,