Gecko [ ifk.uw.edu.pl ]

Name	Size	Permission
drupal-6.bare.database.php	229.95 KB	-rw-r--r--
drupal-6.comments.database.php	747 B	-rw-r--r--
drupal-6.duplicate-permission....	175 B	-rw-r--r--
drupal-6.filled.database.php	563.05 KB	-rw-r--r--
drupal-6.forum.database.php	4.65 KB	-rw-r--r--
drupal-6.locale.database.php	5.33 KB	-rw-r--r--
drupal-6.menu.database.php	3.71 KB	-rw-r--r--
drupal-6.node_type_broken.data...	651 B	-rw-r--r--
drupal-6.translatable.database...	2.22 KB	-rw-r--r--
drupal-6.trigger.database.php	1.6 KB	-rw-r--r--
drupal-6.upload.database.php	9.43 KB	-rw-r--r--
drupal-6.user-no-password-toke...	270 B	-rw-r--r--
drupal-6.user-password-token.d...	1.09 KB	-rw-r--r--
drupal-7.aggregator.database.p...	20.53 KB	-rw-r--r--
drupal-7.bare.minimal.database...	38.91 KB	-rw-r--r--
drupal-7.bare.standard_all.dat...	75.61 KB	-rw-r--r--
drupal-7.field.database.php	480 B	-rw-r--r--
drupal-7.filled.minimal.databa...	40.83 KB	-rw-r--r--
drupal-7.filled.standard_all.d...	95.32 KB	-rw-r--r--
drupal-7.trigger.database.php	509 B	-rw-r--r--
update.aggregator.test	1.46 KB	-rw-r--r--
update.field.test	1.68 KB	-rw-r--r--
update.trigger.test	1.05 KB	-rw-r--r--
update.user.test	928 B	-rw-r--r--
upgrade.comment.test	877 B	-rw-r--r--
upgrade.filter.test	1.85 KB	-rw-r--r--
upgrade.forum.test	2.28 KB	-rw-r--r--
upgrade.locale.test	4.3 KB	-rw-r--r--
upgrade.menu.test	3.68 KB	-rw-r--r--
upgrade.node.test	5.34 KB	-rw-r--r--
upgrade.poll.test	2.05 KB	-rw-r--r--
upgrade.taxonomy.test	8.93 KB	-rw-r--r--
upgrade.test	24.55 KB	-rw-r--r--
upgrade.translatable.test	1.96 KB	-rw-r--r--
upgrade.trigger.test	1.18 KB	-rw-r--r--
upgrade.upload.test	3.89 KB	-rw-r--r--
upgrade.user.test	3.52 KB	-rw-r--r--

Code Editor : drupal-6.forum.database.php

<?php

/**
 * Database additions for forum tests.
 */

db_create_table('forum', array(
  'fields' => array(
    'nid' => array(
      'type' => 'int',
      'unsigned' => TRUE,
      'not null' => TRUE,
      'default' => 0,
    ),
    'vid' => array(
      'type' => 'int',
      'unsigned' => TRUE,
      'not null' => TRUE,
      'default' => 0,
    ),
    'tid' => array(
      'type' => 'int',
      'unsigned' => TRUE,
      'not null' => TRUE,
      'default' => 0,
    ),
  ),
  'indexes' => array(
    'nid' => array(
      'nid',
    ),
    'tid' => array(
      'tid',
    ),
  ),
  'primary key' => array(
    'vid',
  ),
  'module' => 'forum',
  'name' => 'forum',
));
db_insert('forum')->fields(array(
  'nid',
  'vid',
  'tid',
))
->values(array(
  'nid' => '51',
  'vid' => '61',
  'tid' => '81',
))
->execute();

db_insert('node')->fields(array(
  'nid',
  'vid',
  'type',
  'language',
  'title',
  'uid',
  'status',
  'created',
  'changed',
  'comment',
  'promote',
  'moderate',
  'sticky',
  'tnid',
  'translate',
))
->values(array(
  'nid' => '51',
  'vid' => '61',
  'type' => 'forum',
  'language' => '',
  'title' => 'Apples',
  'uid' => '1',
  'status' => '1',
  'created' => '1298363952',
  'changed' => '1298363952',
  'comment' => '2',
  'promote' => '0',
  'moderate' => '0',
  'sticky' => '0',
  'tnid' => '0',
  'translate' => '0',
))
->execute();

db_insert('node_revisions')->fields(array(
  'nid',
  'vid',
  'uid',
  'title',
  'body',
  'teaser',
  'log',
  'timestamp',
  'format',
))
->values(array(
  'nid' => '51',
  'vid' => '61',
  'uid' => '1',
  'title' => 'Apples',
  'body' => 'A fruit.',
  'teaser' => 'A fruit.',
  'log' => '',
  'timestamp' => '1298363952',
  'format' => '1',
))
->execute();

db_insert('node_comment_statistics')->fields(array(
  'nid',
  'last_comment_timestamp',
  'last_comment_name',
  'last_comment_uid',
  'comment_count',
))
->values(array(
  'nid' => '51',
  'last_comment_timestamp' => '1298363952',
  'last_comment_name' => NULL,
  'last_comment_uid' => '1',
  'comment_count' => '0',
))
->execute();

db_insert('node_type')->fields(array(
  'type',
  'name',
  'module',
  'description',
  'help',
  'has_title',
  'title_label',
  'has_body',
  'body_label',
  'min_word_count',
  'custom',
  'modified',
  'locked',
  'orig_type',
))
->values(array(
  'type' => 'forum',
  'name' => 'Forum topic',
  'module' => 'forum',
  'description' => 'A <em>forum topic</em> is the initial post to a new discussion thread within a forum.',
  'help' => '',
  'has_title' => '1',
  'title_label' => 'Subject',
  'has_body' => '1',
  'body_label' => 'Body',
  'min_word_count' => '0',
  'custom' => '0',
  'modified' => '0',
  'locked' => '1',
  'orig_type' => 'forum',
))
->execute();

db_update('system')->fields(array(
  'schema_version' => '6000',
  'status' => '1',
))
->condition('filename', 'modules/forum/forum.module')
->execute();

db_insert('term_data')->fields(array(
  'tid',
  'vid',
  'name',
  'description',
  'weight',
))
->values(array(
  'tid' => '81',
  'vid' => '101',
  'name' => 'Fruits',
  'description' => 'Fruits.',
  'weight' => '0',
))
->execute();

db_insert('term_hierarchy')->fields(array(
  'tid',
  'parent',
))
->values(array(
  'tid' => '81',
  'parent' => '0',
))
->execute();

db_insert('term_node')->fields(array(
  'nid',
  'vid',
  'tid',
))
->values(array(
  'nid' => '51',
  'vid' => '61',
  'tid' => '81',
))
->execute();

db_insert('variable')->fields(array(
  'name',
  'value',
))
->values(array(
  'name' => 'forum_nav_vocabulary',
  'value' => 's:3:"101";',
))
->values(array(
  'name' => 'forum_containers',
  'value' => 'a:1:{i:0;s:3:"101";}',
))
->execute();

db_insert('vocabulary')->fields(array(
  'vid',
  'name',
  'description',
  'help',
  'relations',
  'hierarchy',
  'multiple',
  'required',
  'tags',
  'module',
  'weight',
))
->values(array(
  'vid' => '101',
  'name' => 'Upgrade test for forums',
  'description' => 'Vocabulary used for Forums. The name is changed from the default "Forums" so that the upgrade path may be tested.',
  'help' => '',
  'relations' => '1',
  'hierarchy' => '1',
  'multiple' => '0',
  'required' => '0',
  'tags' => '0',
  'module' => 'forum',
  'weight' => '-10',
))
->execute();

db_insert('vocabulary_node_types')->fields(array(
  'vid',
  'type',
))
->values(array(
  'vid' => '101',
  'type' => 'forum',
))
->execute();

// Provide all users with the ability to create forum topics.
$results = db_select('permission', 'p')
  ->fields('p')
  ->execute();

foreach ($results as $result) {
  $permissions = $result->perm . ', create forum topics';
  db_update('permission')
    ->fields(array(
      'perm' => $permissions,
    ))
    ->condition('rid', $result->rid)
    ->execute();
}

${this.title}

Code Editor : drupal-6.forum.database.php