function agreement_schema in Agreement 7.2
Same name and namespace in other branches
- 8.2 agreement.install \agreement_schema()
- 6.2 agreement.install \agreement_schema()
- 6 agreement.install \agreement_schema()
- 3.0.x agreement.install \agreement_schema()
Implements hook_schema().
1 call to agreement_schema()
- agreement_update_7201 in ./
agreement.install - 7201: Add a type column to {agreement} table.
File
- ./
agreement.install, line 61 - Install, update and uninstall functions for Agreement module.
Code
function agreement_schema() {
$schema['agreement'] = array(
'fields' => array(
'id' => array(
'type' => 'serial',
'unsigned' => TRUE,
'not null' => TRUE,
),
'type' => array(
'type' => 'varchar',
'length' => 100,
'not null' => TRUE,
'default' => 'default',
),
'uid' => array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
),
'agreed' => array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
),
'sid' => array(
'type' => 'varchar',
'length' => 46,
),
'agreed_date' => array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
),
),
'primary key' => array(
'id',
),
'indexes' => array(
'type_uid' => array(
'type',
'uid',
),
),
);
$schema['agreement_type'] = array(
'fields' => array(
'id' => array(
'type' => 'serial',
'unsigned' => TRUE,
'not null' => TRUE,
),
'name' => array(
'type' => 'varchar',
'length' => 100,
'not null' => TRUE,
),
'type' => array(
'type' => 'varchar',
'length' => 150,
'not null' => TRUE,
),
'path' => array(
'type' => 'varchar',
'length' => 150,
'not null' => TRUE,
),
'settings' => array(
'type' => 'blob',
'size' => 'big',
'not null' => TRUE,
),
'agreement' => array(
'type' => 'text',
'not null' => FALSE,
),
),
'primary key' => array(
'id',
),
'unique keys' => array(
'name' => array(
'name',
),
'path' => array(
'path',
),
),
);
return $schema;
}