[Summary view] [Print] [Text view]

   1  <?php
   2  // $Id: aggregator.install,v 1.14.2.2 2009/01/06 15:46:36 goba Exp $
   3  
   4  /**
   5   * Implementation of hook_install().
   6   */
   7  function aggregator_install() {
   8    // Create tables.
   9    drupal_install_schema('aggregator');
  10  }
  11  
  12  /**
  13   * Implementation of hook_uninstall().
  14   */
  15  function aggregator_uninstall() {
  16    // Remove tables.
  17    drupal_uninstall_schema('aggregator');
  18  
  19    variable_del('aggregator_allowed_html_tags');
  20    variable_del('aggregator_summary_items');
  21    variable_del('aggregator_clear');
  22    variable_del('aggregator_category_selector');
  23  }
  24  
  25  /**
  26   * Implementation of hook_schema().
  27   */
  28  function aggregator_schema() {
  29    $schema['aggregator_category'] = array(
  30      'description' => 'Stores categories for aggregator feeds and feed items.',
  31      'fields' => array(
  32        'cid'  => array(
  33          'type' => 'serial',
  34          'not null' => TRUE,
  35          'description' => 'Primary Key: Unique aggregator category ID.',
  36        ),
  37        'title' => array(
  38          'type' => 'varchar',
  39          'length' => 255,
  40          'not null' => TRUE,
  41          'default' => '',
  42          'description' => 'Title of the category.',
  43        ),
  44        'description' => array(
  45          'type' => 'text',
  46          'not null' => TRUE,
  47          'size' => 'big',
  48          'description' => 'Description of the category',
  49        ),
  50        'block' => array(
  51          'type' => 'int',
  52          'not null' => TRUE,
  53          'default' => 0,
  54          'size' => 'tiny',
  55          'description' => 'The number of recent items to show within the category block.',
  56        )
  57      ),
  58      'primary key' => array('cid'),
  59      'unique keys' => array('title' => array('title')),
  60    );
  61  
  62    $schema['aggregator_category_feed'] = array(
  63      'description' => 'Bridge table; maps feeds to categories.',
  64      'fields' => array(
  65        'fid' => array(
  66          'type' => 'int',
  67          'not null' => TRUE,
  68          'default' => 0,
  69          'description' => "The feed's {aggregator_feed}.fid.",
  70        ),
  71        'cid' => array(
  72          'type' => 'int',
  73          'not null' => TRUE,
  74          'default' => 0,
  75          'description' => 'The {aggregator_category}.cid to which the feed is being assigned.',
  76        )
  77      ),
  78      'primary key' => array('cid', 'fid'),
  79      'indexes' => array('fid' => array('fid')),
  80    );
  81  
  82    $schema['aggregator_category_item'] = array(
  83      'description' => 'Bridge table; maps feed items to categories.',
  84      'fields' => array(
  85        'iid' => array(
  86          'type' => 'int',
  87          'not null' => TRUE,
  88          'default' => 0,
  89          'description' => "The feed item's {aggregator_item}.iid.",
  90        ),
  91        'cid' => array(
  92          'type' => 'int',
  93          'not null' => TRUE,
  94          'default' => 0,
  95          'description' => 'The {aggregator_category}.cid to which the feed item is being assigned.',
  96        )
  97      ),
  98      'primary key' => array('cid', 'iid'),
  99      'indexes' => array('iid' => array('iid')),
 100    );
 101  
 102    $schema['aggregator_feed'] = array(
 103      'description' => 'Stores feeds to be parsed by the aggregator.',
 104      'fields' => array(
 105        'fid' => array(
 106          'type' => 'serial',
 107          'not null' => TRUE,
 108          'description' => 'Primary Key: Unique feed ID.',
 109        ),
 110        'title' => array(
 111          'type' => 'varchar',
 112          'length' => 255,
 113          'not null' => TRUE,
 114          'default' => '',
 115          'description' => 'Title of the feed.',
 116        ),
 117        'url' => array(
 118          'type' => 'varchar',
 119          'length' => 255,
 120          'not null' => TRUE,
 121          'default' => '',
 122          'description' => 'URL to the feed.',
 123        ),
 124        'refresh' => array(
 125          'type' => 'int',
 126          'not null' => TRUE,
 127          'default' => 0,
 128          'description' => 'How often to check for new feed items, in seconds.',
 129        ),
 130        'checked' => array(
 131          'type' => 'int',
 132          'not null' => TRUE,
 133          'default' => 0,
 134          'description' => 'Last time feed was checked for new items, as Unix timestamp.',
 135        ),
 136        'link' => array(
 137          'type' => 'varchar',
 138          'length' => 255,
 139          'not null' => TRUE,
 140          'default' => '',
 141          'description' => 'The parent website of the feed; comes from the &lt;link&gt; element in the feed.',
 142        ),
 143        'description' => array(
 144          'type' => 'text',
 145          'not null' => TRUE,
 146          'size' => 'big',
 147          'description' => "The parent website's description; comes from the &lt;description&gt; element in the feed.",
 148        ),
 149        'image' => array(
 150          'type' => 'text',
 151          'not null' => TRUE,
 152          'size' => 'big',
 153          'description' => 'An image representing the feed.',
 154        ),
 155        'etag' => array(
 156          'type' => 'varchar',
 157          'length' => 255,
 158          'not null' => TRUE,
 159          'default' => '',
 160          'description' => 'Entity tag HTTP response header, used for validating cache.',
 161        ),
 162        'modified' => array(
 163          'type' => 'int',
 164          'not null' => TRUE,
 165          'default' => 0,
 166          'description' => 'When the feed was last modified, as a Unix timestamp.',
 167        ),
 168        'block' => array(
 169          'type' => 'int',
 170          'not null' => TRUE,
 171          'default' => 0,
 172          'size' => 'tiny',
 173          'description' => "Number of items to display in the feed's block.",
 174        )
 175      ),
 176      'primary key' => array('fid'),
 177      'unique keys' => array(
 178        'url'  => array('url'),
 179        'title' => array('title'),
 180      ),
 181    );
 182  
 183    $schema['aggregator_item'] = array(
 184      'description' => 'Stores the individual items imported from feeds.',
 185      'fields' => array(
 186        'iid'  => array(
 187          'type' => 'serial',
 188          'not null' => TRUE,
 189          'description' => 'Primary Key: Unique ID for feed item.',
 190        ),
 191        'fid' => array(
 192          'type' => 'int',
 193          'not null' => TRUE,
 194          'default' => 0,
 195          'description' => 'The {aggregator_feed}.fid to which this item belongs.',
 196        ),
 197        'title' => array(
 198          'type' => 'varchar',
 199          'length' => 255,
 200          'not null' => TRUE,
 201          'default' => '',
 202          'description' => 'Title of the feed item.',
 203        ),
 204        'link' => array(
 205          'type' => 'varchar',
 206          'length' => 255,
 207          'not null' => TRUE,
 208          'default' => '',
 209          'description' => 'Link to the feed item.',
 210        ),
 211        'author' => array(
 212          'type' => 'varchar',
 213          'length' => 255,
 214          'not null' => TRUE,
 215          'default' => '',
 216          'description' => 'Author of the feed item.',
 217        ),
 218        'description' => array(
 219          'type' => 'text',
 220          'not null' => TRUE,
 221          'size' => 'big',
 222          'description' => 'Body of the feed item.',
 223        ),
 224        'timestamp' => array(
 225          'type' => 'int',
 226          'not null' => FALSE,
 227          'description' => 'Post date of feed item, as a Unix timestamp.',
 228        ),
 229        'guid' => array(
 230          'type' => 'varchar',
 231          'length' => 255,
 232          'not null' => FALSE,
 233          'description' => 'Unique identifier for the feed item.',
 234        )
 235      ),
 236      'primary key' => array('iid'),
 237      'indexes' => array('fid' => array('fid')),
 238    );
 239  
 240    return $schema;
 241  }