function support_pm_update_6001 in Support Ticketing System 7
Same name and namespace in other branches
- 6 support_pm/support_pm.install \support_pm_update_6001()
Add project tables.
File
- support_pm/
support_pm.install, line 124
Code
function support_pm_update_6001() {
$schema['support_project'] = array(
'description' => 'Defines projects that can be assigned to client tickets.',
'fields' => array(
'projid' => array(
'type' => 'serial',
'not null' => TRUE,
'unsigned' => TRUE,
),
'project' => array(
'type' => 'varchar',
'length' => 255,
'not null' => FALSE,
'default' => '',
),
'disabled' => array(
'type' => 'int',
'size' => 'tiny',
'not null' => TRUE,
'default' => 0,
),
'weight' => array(
'type' => 'int',
'not null' => TRUE,
'unsigned' => FALSE,
'default' => 0,
),
),
'primary key' => array(
'projid',
),
'keys' => array(
'project' => array(
'project',
'disabled',
'weight',
),
),
);
$schema['support_project_client'] = array(
'description' => 'Stores which projects can be assigned to which clients.',
'fields' => array(
'projid' => array(
'type' => 'int',
'not null' => TRUE,
'unsigned' => TRUE,
'default' => 0,
),
'clid' => array(
'type' => 'int',
'not null' => TRUE,
'unsigned' => TRUE,
'default' => 0,
),
),
'primary key' => array(
'projid',
'clid',
),
);
$schema['support_project_ticket'] = array(
'description' => 'Stores which projects are assigned to tickets.',
'fields' => array(
'nid' => array(
'type' => 'int',
'not null' => TRUE,
'unsigned' => TRUE,
'default' => 0,
),
'projid' => array(
'type' => 'int',
'not null' => TRUE,
'unsigned' => TRUE,
'default' => 0,
),
),
'primary key' => array(
'nid',
'projid',
),
);
db_create_table('support_project', $schema['support_project']);
db_create_table('support_project_client', $schema['support_project_client']);
db_create_table('support_project_ticket', $schema['support_project_ticket']);
// We've added new menus, flush caches and rebuild menus.
drupal_flush_all_caches();
menu_rebuild();
}