 
 CREATE TABLE drupal_node_track (
   drupal_node_track_id  INT(10) UNSIGNED NOT NULL UNIQUE AUTO_INCREMENT PRIMARY KEY,
-  drupal_id             INT(10) UNSIGNED,
-  track_id              INT(10) UNSIGNED,
+  drupal_id             INT(10) UNSIGNED NOT NULL,
+  track_id              INT(10) UNSIGNED NOT NULL,
   date                  TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
   
   FOREIGN KEY(drupal_id) REFERENCES drupal_node(drupal_id),


@column analysis_id              Analysis parameters id (primary key, internal identifier).
@column analysis_description_id  Analysis description primary id (foreigh key).
@column program                  Name of the Program used.
@column parameters               Complete command line parameters used.
@column track_id                 Track primary id (foreign key).
@column metasum                  Checksum of @program + @parameters.
@column date                     Entry timestamp.

  date                  TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  status                ENUM('ACTIVE', 'RETIRED') DEFAULT 'ACTIVE',
  
  FOREIGN KEY(track_id) REFERENCES track(track_id),
  
  KEY file_id_idx         (file_id),
  KEY file_track_id_idx   (track_id)
) ENGINE=InnoDB;

CREATE TRIGGER file_md5_upd_tr BEFORE UPDATE ON file
