[Summary view] [Print] [Text view]

   1  <?php
   2  // $Id: comment.install,v 1.19.2.1 2009/01/06 15:46:36 goba Exp $
   3  
   4  /**
   5   * Implementation of hook_enable().
   6   */
   7  function comment_enable() {
   8    // Insert records into the node_comment_statistics for nodes that are missing.
   9    db_query("INSERT INTO {node_comment_statistics} (nid, last_comment_timestamp, last_comment_name, last_comment_uid, comment_count) SELECT n.nid, n.changed, NULL, n.uid, 0 FROM {node} n LEFT JOIN {node_comment_statistics} c ON n.nid = c.nid WHERE c.comment_count IS NULL");
  10  }
  11  
  12  /**
  13   * Changed node_comment_statistics to use node->changed to avoid future timestamps.
  14   */
  15  function comment_update_1() {
  16    // Change any future last comment timestamps to now.
  17    db_query('UPDATE {node_comment_statistics} SET last_comment_timestamp = %d WHERE last_comment_timestamp > %d', time(), time());
  18  
  19    // Unstuck node indexing timestamp if needed.
  20    if (($last = variable_get('node_cron_last', FALSE)) !== FALSE) {
  21      variable_set('node_cron_last', min(time(), $last));
  22    }
  23    return array();
  24  }
  25  
  26  function comment_update_6001() {
  27    $ret[] = update_sql("ALTER TABLE {comments} DROP score");
  28    $ret[] = update_sql("ALTER TABLE {comments} DROP users");
  29    return $ret;
  30  }
  31  
  32  /**
  33   * Changed comment settings from global to per-node -- copy global
  34   * settings to all node types.
  35   */
  36  function comment_update_6002() {
  37    // Comment module might not be enabled when this is run, but we need the
  38    // constants defined by the module for this update.
  39    drupal_load('module', 'comment');
  40    $settings = array(
  41      'comment_default_mode' => COMMENT_MODE_THREADED_EXPANDED,
  42      'comment_default_order' => COMMENT_ORDER_NEWEST_FIRST,
  43      'comment_default_per_page' => 50,
  44      'comment_controls' => COMMENT_CONTROLS_HIDDEN,
  45      'comment_anonymous' => COMMENT_ANONYMOUS_MAYNOT_CONTACT,
  46      'comment_subject_field' => 1,
  47      'comment_preview' => COMMENT_PREVIEW_REQUIRED,
  48      'comment_form_location' => COMMENT_FORM_SEPARATE_PAGE,
  49    );
  50    $types = node_get_types();
  51    foreach ($settings as $setting => $default) {
  52      $value = variable_get($setting, $default);
  53      foreach ($types as $type => $object) {
  54        variable_set($setting .'_'. $type, $value);
  55      }
  56      variable_del($setting);
  57    }
  58    return array(array('success' => TRUE, 'query' => 'Global comment settings copied to all node types.'));
  59  }
  60  
  61  /**
  62   * Add index to parent ID field.
  63   */
  64  function comment_update_6003() {
  65    $ret = array();
  66    db_add_index($ret, 'comments', 'pid', array('pid'));
  67    return $ret;
  68  }
  69  
  70  
  71  /**
  72   * Implementation of hook_schema().
  73   */
  74  function comment_schema() {
  75    $schema['comments'] = array(
  76      'description' => 'Stores comments and associated data.',
  77      'fields' => array(
  78        'cid' => array(
  79          'type' => 'serial',
  80          'not null' => TRUE,
  81          'description' => 'Primary Key: Unique comment ID.',
  82        ),
  83        'pid' => array(
  84          'type' => 'int',
  85          'not null' => TRUE,
  86          'default' => 0,
  87          'description' => 'The {comments}.cid to which this comment is a reply. If set to 0, this comment is not a reply to an existing comment.',
  88        ),
  89        'nid' => array(
  90          'type' => 'int',
  91          'not null' => TRUE,
  92          'default' => 0,
  93          'description' => 'The {node}.nid to which this comment is a reply.',
  94        ),
  95        'uid' => array(
  96          'type' => 'int',
  97          'not null' => TRUE,
  98          'default' => 0,
  99          'description' => 'The {users}.uid who authored the comment. If set to 0, this comment was created by an anonymous user.',
 100        ),
 101        'subject' => array(
 102          'type' => 'varchar',
 103          'length' => 64,
 104          'not null' => TRUE,
 105          'default' => '',
 106          'description' => 'The comment title.',
 107        ),
 108        'comment' => array(
 109          'type' => 'text',
 110          'not null' => TRUE,
 111          'size' => 'big',
 112          'description' => 'The comment body.',
 113        ),
 114        'hostname' => array(
 115          'type' => 'varchar',
 116          'length' => 128,
 117          'not null' => TRUE,
 118          'default' => '',
 119          'description' => "The author's host name.",
 120        ),
 121        'timestamp' => array(
 122          'type' => 'int',
 123          'not null' => TRUE,
 124          'default' => 0,
 125          'description' => 'The time that the comment was created, or last edited by its author, as a Unix timestamp.',
 126        ),
 127        'status' => array(
 128          'type' => 'int',
 129          'unsigned' => TRUE,
 130          'not null' => TRUE,
 131          'default' => 0,
 132          'size' => 'tiny',
 133          'description' => 'The published status of a comment. (0 = Published, 1 = Not Published)',
 134        ),
 135        'format' => array(
 136          'type' => 'int',
 137          'size' => 'small',
 138          'not null' => TRUE,
 139          'default' => 0,
 140          'description' => 'The {filter_formats}.format of the comment body.',
 141        ),
 142        'thread' => array(
 143          'type' => 'varchar',
 144          'length' => 255,
 145          'not null' => TRUE,
 146          'description' => "The vancode representation of the comment's place in a thread.",
 147        ),
 148        'name' => array(
 149          'type' => 'varchar',
 150          'length' => 60,
 151          'not null' => FALSE,
 152          'description' => "The comment author's name. Uses {users}.name if the user is logged in, otherwise uses the value typed into the comment form.",
 153        ),
 154        'mail' => array(
 155          'type' => 'varchar',
 156          'length' => 64,
 157          'not null' => FALSE,
 158          'description' => "The comment author's e-mail address from the comment form, if user is anonymous, and the 'Anonymous users may/must leave their contact information' setting is turned on.",
 159        ),
 160        'homepage' => array(
 161          'type' => 'varchar',
 162          'length' => 255,
 163          'not null' => FALSE,
 164          'description' => "The comment author's home page address from the comment form, if user is anonymous, and the 'Anonymous users may/must leave their contact information' setting is turned on.",
 165        )
 166      ),
 167      'indexes' => array(
 168        'pid'    => array('pid'),
 169        'nid'    => array('nid'),
 170        'status' => array('status'), // This index is probably unused
 171      ),
 172      'primary key' => array('cid'),
 173    );
 174  
 175    $schema['node_comment_statistics'] = array(
 176      'description' => 'Maintains statistics of node and comments posts to show "new" and "updated" flags.',
 177      'fields' => array(
 178        'nid' => array(
 179          'type' => 'int',
 180          'unsigned' => TRUE,
 181          'not null' => TRUE,
 182          'default' => 0,
 183          'description' => 'The {node}.nid for which the statistics are compiled.',
 184        ),
 185        'last_comment_timestamp' => array(
 186          'type' => 'int',
 187          'not null' => TRUE,
 188          'default' => 0,
 189          'description' => 'The Unix timestamp of the last comment that was posted within this node, from {comments}.timestamp.',
 190        ),
 191        'last_comment_name' => array(
 192          'type' => 'varchar',
 193          'length' => 60,
 194          'not null' => FALSE,
 195          'description' => 'The name of the latest author to post a comment on this node, from {comments}.name.',
 196        ),
 197        'last_comment_uid' => array(
 198          'type' => 'int',
 199          'not null' => TRUE,
 200          'default' => 0,
 201          'description' => 'The user ID of the latest author to post a comment on this node, from {comments}.uid.',
 202        ),
 203        'comment_count' => array(
 204          'type' => 'int',
 205          'unsigned' => TRUE,
 206          'not null' => TRUE,
 207          'default' => 0,
 208          'description' => 'The total number of comments on this node.',
 209        ),
 210      ),
 211      'primary key' => array('nid'),
 212      'indexes' => array(
 213        'node_comment_timestamp' => array('last_comment_timestamp')
 214      ),
 215    );
 216  
 217    return $schema;
 218  }
 219