array( 'job_id' => array('type' => 'serial', 'unsigned' => TRUE, 'not null' => TRUE), 'uid' => array ('type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'description' => 'The Drupal userid of the submitee'), 'job_name' => array('type' => 'varchar','length' => 255, 'not null' => TRUE), 'modulename' => array('type' => 'varchar','length' => 50, 'not null' => TRUE, 'description' => 'The module name that provides the callback for this job'), 'callback' => array('type' => 'varchar','length' => 255, 'not null' => TRUE), 'arguments' => array('type' => 'text', 'size' => 'normal', 'not null' => FALSE), 'progress' => array('type' => 'int', 'unsigned' => TRUE, 'default' => 0, 'not null' => FALSE, 'description' => 'a value from 0 to 100 indicating percent complete'), 'status' => array('type' => 'varchar','length' => 50, 'not null' => TRUE), 'submit_date' => array ('type' => 'int', 'not null' => TRUE, 'description' => 'UNIX integer submit time'), 'start_time' => array ('type' => 'int', 'not null' => FALSE, 'description' => 'UNIX integer start time'), 'end_time' => array ('type' => 'int', 'not null' => FALSE, 'description' => 'UNIX integer end time'), 'error_msg' => array('type' => 'text','size' => 'normal', 'not null' => FALSE), 'pid' => array ('type' => 'int', 'unsigned' => TRUE, 'not null' => FALSE, 'description' => 'The process id for the job'), 'priority' => array ('type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => '0', 'description' => 'The job priority'), 'mlock' => array ('type' => 'int', 'unsigned' => TRUE, 'not null' => FALSE, 'description' => 'If set to 1 then all jobs for the module are held until this one finishes'), 'lock' => array ('type' => 'int', 'unsigned' => TRUE, 'not null' => FALSE, 'description' => 'If set to 1 then all jobs are held until this one finishes'), ), 'indexes' => array( 'job_id' => array('job_id'), 'job_name' => array('job_name') ), 'primary key' => array('job_id'), ); $schema['tripal_mviews'] = array( 'fields' => array( 'mview_id' => array('type' => 'serial', 'unsigned' => TRUE, 'not null' => TRUE), 'name' => array('type' => 'varchar','length' => 255, 'not null' => TRUE), 'modulename' => array('type' => 'varchar','length' => 50, 'not null' => TRUE, 'description' => 'The module name that provides the callback for this job'), 'mv_table' => array('type' => 'varchar','length' => 128, 'not null' => TRUE), 'mv_specs' => array('type' => 'text', 'size' => 'normal', 'not null' => TRUE), 'indexed' => array('type' => 'text', 'size' => 'normal', 'not null' => TRUE), 'query' => array('type' => 'text', 'size' => 'normal', 'not null' => TRUE), 'special_index' => array('type' => 'text', 'size' => 'normal', 'not null' => FALSE), 'last_update' => array ('type' => 'int', 'not null' => FALSE, 'description' => 'UNIX integer time'), ), 'indexes' => array( 'mview_id' => array('mview_id') ), 'unique keys' => array( 'mv_table' => array('mv_table'), 'mv_name' => array('name'), ), 'primary key' => array('mview_id'), ); return $schema; } ?>