View source
<?php
function upload_install() {
if (!db_table_exists('upload')) {
drupal_install_schema('upload');
}
}
function upload_uninstall() {
drupal_uninstall_schema('upload');
}
function upload_schema() {
$schema['upload'] = array(
'description' => 'Stores uploaded file information and table associations.',
'fields' => array(
'fid' => array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
'description' => 'Primary Key: The {files}.fid.',
),
'nid' => array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
'description' => 'The {node}.nid associated with the uploaded file.',
),
'vid' => array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
'description' => 'Primary Key: The {node}.vid associated with the uploaded file.',
),
'description' => array(
'type' => 'varchar',
'length' => 255,
'not null' => TRUE,
'default' => '',
'description' => 'Description of the uploaded file.',
),
'list' => array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
'size' => 'tiny',
'description' => 'Whether the file should be visibly listed on the node: yes(1) or no(0).',
),
'weight' => array(
'type' => 'int',
'not null' => TRUE,
'default' => 0,
'size' => 'tiny',
'description' => 'Weight of this upload in relation to other uploads in this node.',
),
),
'primary key' => array(
'vid',
'fid',
),
'indexes' => array(
'fid' => array(
'fid',
),
'nid' => array(
'nid',
),
),
);
return $schema;
}