function feed_path_publisher_schema in Feed Path Publisher 7

Same name and namespace in other branches

1. 6 feed_path_publisher.install \feed_path_publisher_schema()

Implements hook_schema().

File

./feed_path_publisher.install, line 12

Install, update and uninstall functions for the feed_path_publisher module.

Code

function feed_path_publisher_schema() {
  $schema['feed_path_publisher'] = array(
    'fields' => array(
      'fppid' => array(
        'type' => 'serial',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'disp-width' => '10',
      ),
      'title' => array(
        'type' => 'varchar',
        'length' => '50',
        'not null' => TRUE,
      ),
      'path_prefix' => array(
        'type' => 'varchar',
        'length' => '100',
        'not null' => TRUE,
      ),
      'feed' => array(
        'type' => 'varchar',
        'length' => '200',
        'not null' => TRUE,
      ),
      'weight' => array(
        'type' => 'int',
        'not null' => TRUE,
        'disp-width' => '11',
      ),
    ),
    'primary key' => array(
      'fppid',
    ),
    'unique keys' => array(
      'path_prefix' => array(
        'path_prefix',
        'feed',
      ),
    ),
    'indexes' => array(
      'listing' => array(
        'weight',
        'path_prefix',
        'title',
      ),
    ),
  );
  $schema['feed_path_publisher_roles'] = array(
    'fields' => array(
      'fpprid' => array(
        'type' => 'serial',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'disp-width' => '10',
      ),
      'fppid' => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'disp-width' => '10',
      ),
      'show_hide' => array(
        'type' => 'varchar',
        'length' => '50',
        'not null' => TRUE,
      ),
      'rids' => array(
        'type' => 'varchar',
        'length' => '100',
        'not null' => TRUE,
      ),
    ),
    'primary key' => array(
      'fpprid',
    ),
  );
  return $schema;
}