function search_files_directories_schema in Search Files 6.2

Same name and namespace in other branches

1. 7.2 search_files_directories.install \search_files_directories_schema()

@file Installation and update procedures for the search directories module.

File

./search_files_directories.install, line 8

Installation and update procedures for the search directories module.

Code

function search_files_directories_schema() {
  $schema['search_files_directories_directories'] = array(
    'description' => t('list of directories that we will index'),
    'fields' => array(
      'id' => array(
        'type' => 'serial',
        'not null' => TRUE,
        'disp-width' => '11',
      ),
      'filepath' => array(
        'type' => 'varchar',
        'length' => '255',
        'not null' => TRUE,
      ),
      'uripath' => array(
        'type' => 'varchar',
        'length' => '255',
        'not null' => TRUE,
      ),
    ),
    'primary key' => array(
      'id',
    ),
    'unique keys' => array(
      'filepath' => array(
        'filepath',
      ),
    ),
  );
  $schema['search_files_directories_files'] = array(
    'description' => t('list of files in the directories, this is here because the the search_dataset table needs some sort of integer id to reference the file by'),
    'fields' => array(
      'id' => array(
        'type' => 'serial',
        'not null' => TRUE,
        'disp-width' => '11',
      ),
      'path' => array(
        'type' => 'varchar',
        'length' => '255',
        'not null' => TRUE,
      ),
      'directory_id' => array(
        'type' => 'int',
        'not null' => TRUE,
        'disp-width' => '11',
      ),
      'index_attempts' => array(
        'type' => 'int',
        'size' => 'tiny',
        'not null' => TRUE,
        'disp-width' => '4',
      ),
    ),
    'primary key' => array(
      'id',
    ),
    'unique keys' => array(
      'path' => array(
        'path',
      ),
    ),
  );
  return $schema;
}