job_scheduler.install in Job Scheduler 7
Same filename and directory in other branches
Schema definitions install/update/uninstall hooks.
File
job_scheduler.installView source
<?php
/**
* @file
* Schema definitions install/update/uninstall hooks.
*/
/**
* Implementation of hook_schema().
*/
function job_scheduler_schema() {
$schema = array();
$schema['job_schedule'] = array(
'description' => 'Schedule of jobs to be executed.',
'fields' => array(
'name' => array(
'type' => 'varchar',
'length' => 128,
'not null' => TRUE,
'default' => '',
'description' => 'Name of the schedule.',
),
'type' => array(
'type' => 'varchar',
'length' => 128,
'not null' => TRUE,
'default' => '',
'description' => 'Type identifier of the job.',
),
'id' => array(
'type' => 'int',
'not null' => TRUE,
'default' => 0,
'unsigned' => TRUE,
'description' => 'Numeric identifier of the job.',
),
'last' => array(
'type' => 'int',
'unsigned' => TRUE,
'default' => 0,
'not null' => TRUE,
'description' => 'Timestamp when a job was last executed.',
),
'period' => array(
'type' => 'int',
'unsigned' => TRUE,
'default' => 0,
'not null' => TRUE,
'description' => 'Time period after which job is to be executed.',
),
'next' => array(
'type' => 'int',
'unsigned' => TRUE,
'default' => 0,
'not null' => TRUE,
'description' => 'Timestamp when a job is to be executed (next = last + period), used for fast ordering.',
),
'periodic' => array(
'type' => 'int',
'size' => 'small',
'unsigned' => TRUE,
'default' => 0,
'not null' => TRUE,
'description' => 'If true job will be automatically rescheduled with same period.',
),
'scheduled' => array(
'type' => 'int',
'unsigned' => TRUE,
'default' => 0,
'not null' => TRUE,
'description' => 'Timestamp when a job was scheduled. 0 if a job is currently not scheduled.',
),
),
'indexes' => array(
'name_type_id' => array(
'name',
'type',
'id',
),
'name_type' => array(
'name',
'type',
),
'next' => array(
'next',
),
'scheduled' => array(
'scheduled',
),
),
);
return $schema;
}
/**
* Fix indexes on next.
*/
function job_scheduler_update_6101() {
$ret = array();
db_drop_index($ret, 'job_schedule', 'last_period');
db_drop_index($ret, 'job_schedule', 'periodic');
db_add_index($ret, 'job_schedule', 'next', array(
'next',
));
return $ret;
}
/**
* Rename 'callback' to 'name' field.
*/
function job_scheduler_update_7100() {
db_drop_index('job_schedule', 'callback_type_id');
db_drop_index('job_schedule', 'callback_type');
$spec = array(
'type' => 'varchar',
'length' => 128,
'not null' => TRUE,
'default' => '',
'description' => 'Name of the schedule.',
);
db_change_field('job_schedule', 'callback', 'name', $spec);
db_add_index('job_schedule', 'name_type_id', array(
'name',
'type',
'id',
));
db_add_index('job_schedule', 'name_type', array(
'name',
'type',
));
}
Functions
Name![]() |
Description |
---|---|
job_scheduler_schema | Implementation of hook_schema(). |
job_scheduler_update_6101 | Fix indexes on next. |
job_scheduler_update_7100 | Rename 'callback' to 'name' field. |