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.upload.database.php

<?php

db_insert('files')->fields(array(
  'fid',
  'uid',
  'filename',
  'filepath',
  'filemime',
  'filesize',
  'status',
  'timestamp',
))
/*
 * This entry is deliberately omitted to test the upgrade routine when facing
 * possible data corruption.
 *
->values(array(
  'fid' => '1',
  'uid' => '1',
  'filename' => 'powered-blue-80x15.png',
  'filepath' => 'sites/default/files/powered-blue-80x15.png',
  'filemime' => 'image/png',
  'filesize' => '1011',
  'status' => '1',
  'timestamp' => '1285700240',
)) */
->values(array(
  'fid' => '2',
  'uid' => '1',
  'filename' => 'powered-blue-80x15.png',
  'filepath' => 'sites/default/files/powered-blue-80x15_0.png',
  'filemime' => 'image/png',
  'filesize' => '1011',
  'status' => '1',
  'timestamp' => '1285700317',
))
->values(array(
  'fid' => '3',
  'uid' => '1',
  'filename' => 'powered-blue-88x31.png',
  'filepath' => 'sites/default/files/powered-blue-88x31.png',
  'filemime' => 'image/png',
  'filesize' => '2113',
  'status' => '1',
  'timestamp' => '1285700343',
))
->values(array(
  'fid' => '4',
  'uid' => '1',
  'filename' => 'powered-blue-135x42.png',
  'filepath' => 'sites/default/files/powered-blue-135x42.png',
  'filemime' => 'image/png',
  'filesize' => '3027',
  'status' => '1',
  'timestamp' => '1285700366',
))
->values(array(
  'fid' => '5',
  'uid' => '1',
  'filename' => 'powered-black-80x15.png',
  'filepath' => 'sites/default/files/powered-black-80x15.png',
  'filemime' => 'image/png',
  'filesize' => '1467',
  'status' => '1',
  'timestamp' => '1285700529',
))
->values(array(
  'fid' => '6',
  'uid' => '1',
  'filename' => 'powered-black-135x42.png',
  'filepath' => 'sites/default/files/powered-black-135x42.png',
  'filemime' => 'image/png',
  'filesize' => '2817',
  'status' => '1',
  'timestamp' => '1285700552',
))
->values(array(
  'fid' => '7',
  'uid' => '1',
  'filename' => 'forum-hot-new.png',
  'filepath' => 'sites/default/files/forum-hot-new.png',
  'filemime' => 'image/png',
  'filesize' => '237',
  'status' => '1',
  'timestamp' => '1285708937',
))
->values(array(
  'fid' => '8',
  'uid' => '1',
  'filename' => 'forum-hot.png',
  'filepath' => 'sites/default/files/forum-hot.png',
  'filemime' => 'image/png',
  'filesize' => '229',
  'status' => '1',
  'timestamp' => '1285708944',
))
->values(array(
  'fid' => '9',
  'uid' => '1',
  'filename' => 'forum-new.png',
  'filepath' => 'sites/default/files/forum-new.png',
  'filemime' => 'image/png',
  'filesize' => '175',
  'status' => '1',
  'timestamp' => '1285708950',
))
->values(array(
  'fid' => '10',
  'uid' => '1',
  'filename' => 'forum-sticky.png',
  'filepath' => 'sites/default/files/forum-sticky.png',
  'filemime' => 'image/png',
  'filesize' => '329',
  'status' => '1',
  'timestamp' => '1285708957',
))
/*
 * This is a case where the path is repeated twice.
 */
->values(array(
  'fid' => '11',
  'uid' => '1',
  'filename' => 'crazy-basename.png',
  'filepath' => '/drupal-6/file/directory/path/drupal-6/file/directory/path/crazy-basename.png',
  'filemime' => 'image/png',
  'filesize' => '329',
  'status' => '1',
  'timestamp' => '1285708958',
))
->execute();

db_insert('node')->fields(array(
  'nid',
  'vid',
  'type',
  'language',
  'title',
  'uid',
  'status',
  'created',
  'changed',
  'comment',
  'promote',
  'moderate',
  'sticky',
  'tnid',
  'translate',
))
->values(array(
  'nid' => '38',
  'vid' => '50',
  'type' => 'page',
  'language' => '',
  'title' => 'node title 38 revision 50',
  'uid' => '1',
  'status' => '1',
  'created' => '1285603317',
  'changed' => '1285603317',
  'comment' => '0',
  'promote' => '0',
  'moderate' => '0',
  'sticky' => '0',
  'tnid' => '0',
  'translate' => '0',
))
->values(array(
  'nid' => '39',
  'vid' => '52',
  'type' => 'page',
  'language' => '',
  'title' => 'node title 39 revision 52',
  'uid' => '1',
  'status' => '1',
  'created' => '1285700317',
  'changed' => '1285700600',
  'comment' => '0',
  'promote' => '0',
  'moderate' => '0',
  'sticky' => '0',
  'tnid' => '0',
  'translate' => '0',
))
->values(array(
  'nid' => '40',
  'vid' => '53',
  'type' => 'page',
  'language' => '',
  'title' => 'node title 40 revision 53',
  'uid' => '1',
  'status' => '1',
  'created' => '1285709012',
  'changed' => '1285709012',
  'comment' => '0',
  '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' => '38',
  'vid' => '50',
  'uid' => '1',
  'title' => 'node title 38 revision 50',
  'body' => "Attachments:\r\npowered-blue-80x15.png",
  'teaser' => "Attachments:\r\npowered-blue-80x15.png",
  'log' => '',
  'timestamp' => '1285603317',
  'format' => '1',
))
->values(array(
  'nid' => '39',
  'vid' => '51',
  'uid' => '1',
  'title' => 'node title 39 revision 51',
  'body' => "Attachments:\r\npowered-blue-80x15.png\r\npowered-blue-88x31.png\r\npowered-blue-135x42.png",
  'teaser' => "Attachments:\r\npowered-blue-80x15.png\r\npowered-blue-88x31.png\r\npowered-blue-135x42.png",
  'log' => '',
  'timestamp' => '1285700487',
  'format' => '1',
))
->values(array(
  'nid' => '39',
  'vid' => '52',
  'uid' => '1',
  'title' => 'node title 39 revision 52',
  'body' => "Attachments:\r\npowered-blue-88x31.png\r\npowered-black-80x15.png\r\npowered-black-135x42.png",
  'teaser' => "Attachments:\r\npowered-blue-88x31.png\r\npowered-black-80x15.png\r\npowered-black-135x42.png",
  'log' => '',
  'timestamp' => '1285700600',
  'format' => '1',
))
->values(array(
  'nid' => '40',
  'vid' => '53',
  'uid' => '1',
  'title' => 'node title 40 revision 53',
  'body' => "Attachments:\r\nforum-hot-new.png\r\nforum-hot.png\r\nforum-sticky.png\r\nforum-new.png\r\ncrazy-basename.png",
  'teaser' => "Attachments:\r\nforum-hot-new.png\r\nforum-hot.png\r\nforum-sticky.png\r\nforum-new.png\r\ncrazy-basename.png",
  'log' => '',
  'timestamp' => '1285709012',
  'format' => '1',
))
 ->execute();

db_create_table('upload', array(
  'fields' => array(
    'fid' => array(
      'type' => 'int',
      'unsigned' => TRUE,
      'not null' => TRUE,
      'default' => 0,
    ),
    'nid' => array(
      'type' => 'int',
      'unsigned' => TRUE,
      'not null' => TRUE,
      'default' => 0,
    ),
    'vid' => array(
      'type' => 'int',
      'unsigned' => TRUE,
      'not null' => TRUE,
      'default' => 0,
    ),
    'description' => array(
      'type' => 'varchar',
      'length' => 255,
      'not null' => TRUE,
      'default' => '',
    ),
    'list' => array(
      'type' => 'int',
      'unsigned' => TRUE,
      'not null' => TRUE,
      'default' => 0,
      'size' => 'tiny',
    ),
    'weight' => array(
      'type' => 'int',
      'not null' => TRUE,
      'default' => 0,
      'size' => 'tiny',
    ),
  ),
  'primary key' => array(
    'vid',
    'fid',
  ),
  'indexes' => array(
    'fid' => array(
      'fid',
    ),
    'nid' => array(
      'nid',
    ),
  ),
  'module' => 'upload',
  'name' => 'upload',
));
db_insert('upload')->fields(array(
  'fid',
  'nid',
  'vid',
  'description',
  'list',
  'weight',
))
->values(array(
  'fid' => '1',
  'nid' => '38',
  'vid' => '50',
  'description' => 'powered-blue-80x15.png',
  'list' => '1',
  'weight' => '0',
))
->values(array(
  'fid' => '2',
  'nid' => '39',
  'vid' => '51',
  'description' => 'powered-blue-80x15.png',
  'list' => '1',
  'weight' => '0',
))
->values(array(
  'fid' => '3',
  'nid' => '39',
  'vid' => '51',
  'description' => 'powered-blue-88x31.png',
  'list' => '1',
  'weight' => '0',
))
->values(array(
  'fid' => '4',
  'nid' => '39',
  'vid' => '51',
  'description' => 'powered-blue-135x42.png',
  'list' => '1',
  'weight' => '0',
))
->values(array(
  'fid' => '3',
  'nid' => '39',
  'vid' => '52',
  'description' => 'powered-blue-88x31.png',
  'list' => '1',
  'weight' => '0',
))
->values(array(
  'fid' => '5',
  'nid' => '39',
  'vid' => '52',
  'description' => 'powered-black-80x15.png',
  'list' => '1',
  'weight' => '0',
))
->values(array(
  'fid' => '6',
  'nid' => '39',
  'vid' => '52',
  'description' => 'powered-black-135x42.png',
  'list' => '1',
  'weight' => '0',
))
->values(array(
  'fid' => '7',
  'nid' => '40',
  'vid' => '53',
  'description' => 'forum-hot-new.png',
  'list' => '1',
  'weight' => '-4',
))
->values(array(
  'fid' => '8',
  'nid' => '40',
  'vid' => '53',
  'description' => 'forum-hot.png',
  'list' => '1',
  'weight' => '-3',
))
->values(array(
  'fid' => '10',
  'nid' => '40',
  'vid' => '53',
  'description' => 'forum-sticky.png',
  'list' => '1',
  'weight' => '-2',
))
->values(array(
  'fid' => '9',
  'nid' => '40',
  'vid' => '53',
  'description' => 'forum-new.png',
  'list' => '1',
  'weight' => '-1',
))
->values(array(
  'fid' => '11',
  'nid' => '40',
  'vid' => '53',
  'description' => 'crazy-basename.png',
  'list' => '1',
  'weight' => '0',
))
->execute();

// Add series of entries for invalid node vids to the {upload} table.
for ($i = 30; $i < 250; $i += 2) {
  db_insert('upload')->fields(array(
    'fid',
    'nid',
    'vid',
    'description',
    'list',
    'weight',
  ))
  // Invalid fid, invalid vid.
  ->values(array(
    'fid' => $i,
    'nid' => '40',
    'vid' => 24 + $i,
    'description' => 'crazy-basename.png',
    'list' => '1',
    'weight' => '0',
  ))
  // Valid fid, invalid vid.
  ->values(array(
    'fid' => 2,
    'nid' => '40',
    'vid' => 24 + $i + 1,
    'description' => 'crazy-basename.png',
    'list' => '1',
    'weight' => '0',
  ))
  ->execute();
}

${this.title}

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