Club Drupal

<?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();

}