 #
 
 CREATE TABLE dnafrag_region (
-  synteny_region_id           int(10) unsigned DEFAULT '0' NOT NULL, # unique internal id
-  dnafrag_id                  bigint unsigned DEFAULT '0' NOT NULL, # FK dnafrag.dnafrag_id
-  dnafrag_start               int(10) unsigned DEFAULT '0' NOT NULL,
-  dnafrag_end                 int(10) unsigned DEFAULT '0' NOT NULL,
-  dnafrag_strand              tinyint(4) DEFAULT '0' NOT NULL,
+  synteny_region_id           int(10) unsigned DEFAULT 0 NOT NULL, # unique internal id
+  dnafrag_id                  bigint unsigned DEFAULT 0 NOT NULL, # FK dnafrag.dnafrag_id
+  dnafrag_start               int(10) unsigned DEFAULT 0 NOT NULL,
+  dnafrag_end                 int(10) unsigned DEFAULT 0 NOT NULL,
+  dnafrag_strand              tinyint(4) DEFAULT 0 NOT NULL,
 
   FOREIGN KEY (synteny_region_id) REFERENCES synteny_region(synteny_region_id),
   FOREIGN KEY (dnafrag_id) REFERENCES dnafrag(dnafrag_id),

CREATE TABLE member (
  member_id                   int(10) unsigned NOT NULL auto_increment, # unique internal id
  stable_id                   varchar(128) NOT NULL, # e.g. ENSP000001234 or P31946
  version                     int(10) DEFAULT '0',
  source_name                 ENUM('ENSEMBLGENE','ENSEMBLPEP','Uniprot/SPTREMBL','Uniprot/SWISSPROT','ENSEMBLTRANS','EXTERNALCDS') NOT NULL,
  taxon_id                    int(10) unsigned NOT NULL, # FK taxon.taxon_id
  genome_db_id                int(10) unsigned, # FK genome_db.genome_db_id


CREATE TABLE dnafrag (
  dnafrag_id                  bigint unsigned NOT NULL auto_increment, # unique internal id
  length                      int(11) DEFAULT 0 NOT NULL,
  name                        varchar(40) DEFAULT '' NOT NULL,
  genome_db_id                int(10) unsigned DEFAULT 0 NOT NULL, # FK genome_db.genome_db_id
  coord_system_name           varchar(40) DEFAULT NULL,
  is_reference                tinyint(1) DEFAULT 1,

