function ultimate_cron_update_6106 in Ultimate Cron 6

Change schema to SQL 99 compliance.

File

./ultimate_cron.install, line 287

Installation file for Ultimate Cron

Code

function ultimate_cron_update_6106() {
  $ret = array();
  db_drop_unique_key($ret, 'ultimate_cron', 'idx_function');
  db_change_field($ret, 'ultimate_cron', 'function', 'name', array(
    'description' => 'Function name',
    'type' => 'varchar',
    'length' => 127,
    'not null' => TRUE,
  ));
  db_add_unique_key($ret, 'ultimate_cron', 'idx_name', array(
    'name',
  ));
  db_change_field($ret, 'ultimate_cron_log', 'function', 'name', array(
    'description' => 'Function name',
    'type' => 'varchar',
    'length' => 127,
    'not null' => TRUE,
  ));
  db_change_field($ret, 'ultimate_cron_log', 'start', 'start_stamp', array(
    'description' => 'Timstamp of execution start',
    'type' => 'float',
    'size' => 'big',
    'not null' => TRUE,
    'default' => 0,
  ));
  db_change_field($ret, 'ultimate_cron_log', 'end', 'end_stamp', array(
    'description' => 'Timstamp of execution end',
    'type' => 'float',
    'size' => 'big',
    'not null' => TRUE,
    'default' => 0,
  ));
  db_change_field($ret, 'ultimate_cron_log', 'status', 'exec_status', array(
    'description' => 'Status of the execution',
    'type' => 'int',
    'size' => 'normal',
    'not null' => FALSE,
    'default' => NULL,
  ));
  db_add_field($ret, 'ultimate_cron_log', 'service_host', array(
    'description' => 'Service host',
    'type' => 'varchar',
    'length' => 127,
    'not null' => TRUE,
  ));
  return $ret;
}