 
 ################################################################################
 #
-# Table structure for table 'regulatory_motif'
-#
-
-CREATE TABLE regulatory_motif (
-
-  regulatory_motif_id   INT NOT NULL auto_increment,
-  name                  VARCHAR(255) NOT NULL,
-  type                  ENUM('miRNA_target', 'promoter'),
-
-  PRIMARY KEY(regulatory_motif_id)
+# Table structure for table 'regulatory_factor'
+#
+
+CREATE TABLE regulatory_factor (
+
+  regulatory_factor_id   INT NOT NULL auto_increment,
+  name                   VARCHAR(255) NOT NULL,
+  type                   ENUM('miRNA_target', 'transcription_factor', 'transcription_factor_complex'),
+
+  PRIMARY KEY(regulatory_factor_id)
 
 ) COLLATE=latin1_swedish_ci TYPE=MyISAM;
 

#
# Table structure for table 'regulatory_feature'
#

CREATE TABLE regulatory_feature (


  regulatory_feature_id INT NOT NULL,               # FK to regulatory_feature
  ensembl_object_type   ENUM( 'Transcript', 'Translation', 'Gene') NOT NULL,
  ensembl_object_id     INT NOT NULL,               # FK to transcript,gene etc
  influence             ENUM('positive', 'negative', 'mixed', 'unknown'),
  evidence              VARCHAR(255),

  KEY regulatory_feature_idx (regulatory_feature_id),
  KEY ensembl_object_idx (ensembl_object_type, ensembl_object_id)
