File

tripal_analysis/tripal_analysis.install, line 31

Implements hooks from the Schema API

Code

function tripal_analysis_create_analysisfeatureprop() {
  // Create analysisfeatureprop table in chado.  This is needed for Chado 
  // version 1.11, the table exists in Chado 1.2. 
  if (!db_table_exists('analysisfeatureprop')) {
    $sql = "CREATE TABLE analysisfeatureprop (" .
      "  analysisfeatureprop_id SERIAL PRIMARY KEY, " .
      "  analysisfeature_id     INTEGER NOT NULL REFERENCES analysisfeature(analysisfeature_id) " .
      "    ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, " .
      "  type_id                INTEGER NOT NULL REFERENCES cvterm(cvterm_id) " .
      "    ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, " .
      "  value                  TEXT, " .
      "  rank                   INTEGER NOT NULL, " .
      "  CONSTRAINT analysisfeature_id_type_id_rank UNIQUE(analysisfeature_id, type_id, rank)" .
      ")";
    chado_query($sql);
  }
}