workbench_moderation_migrate-1.0.0-alpha4/tests/fixtures/wm-drupal7/node_revision.php

<?php
// phpcs:ignoreFile
/**
 * @file
 * A database agnostic dump for testing purposes.
 *
 * This file was generated by the Drupal 9.2.7 db-tools.php script.
 */

use Drupal\Core\Database\Database;

$connection = Database::getConnection();

$connection->schema()->createTable('node_revision', array(
  'fields' => array(
    'nid' => array(
      'type' => 'int',
      'not null' => TRUE,
      'size' => 'normal',
      'default' => '0',
      'unsigned' => TRUE,
    ),
    'vid' => array(
      'type' => 'serial',
      'not null' => TRUE,
      'size' => 'normal',
      'unsigned' => TRUE,
    ),
    'uid' => array(
      'type' => 'int',
      'not null' => TRUE,
      'size' => 'normal',
      'default' => '0',
    ),
    'title' => array(
      'type' => 'varchar',
      'not null' => TRUE,
      'length' => '255',
      'default' => '',
    ),
    'log' => array(
      'type' => 'text',
      'not null' => TRUE,
      'size' => 'big',
    ),
    'timestamp' => array(
      'type' => 'int',
      'not null' => TRUE,
      'size' => 'normal',
      'default' => '0',
    ),
    'status' => array(
      'type' => 'int',
      'not null' => TRUE,
      'size' => 'normal',
      'default' => '1',
    ),
    'comment' => array(
      'type' => 'int',
      'not null' => TRUE,
      'size' => 'normal',
      'default' => '0',
    ),
    'promote' => array(
      'type' => 'int',
      'not null' => TRUE,
      'size' => 'normal',
      'default' => '0',
    ),
    'sticky' => array(
      'type' => 'int',
      'not null' => TRUE,
      'size' => 'normal',
      'default' => '0',
    ),
  ),
  'primary key' => array(
    'vid',
  ),
  'indexes' => array(
    'nid' => array(
      'nid',
    ),
    'uid' => array(
      'uid',
    ),
  ),
  'mysql_character_set' => 'utf8',
));

$connection->insert('node_revision')
->fields(array(
  'nid',
  'vid',
  'uid',
  'title',
  'log',
  'timestamp',
  'status',
  'comment',
  'promote',
  'sticky',
))
->values(array(
  'nid' => '1',
  'vid' => '101',
  'uid' => '1',
  'title' => 'Published node with multiple states (279706) initial draft sent to review [1]',
  'log' => 'Published node with multiple states (279706) initial draft sent to review [1]',
  'timestamp' => '1634048858',
  'status' => '0',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '1',
  'vid' => '102',
  'uid' => '1',
  'title' => 'Published node with multiple states (279706) initial reviewed and published [2]',
  'log' => 'Published node with multiple states (279706) initial reviewed and published [2]',
  'timestamp' => '1634048872',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '1',
  'vid' => '103',
  'uid' => '1',
  'title' => 'Published node with multiple states (279706) published version was edited and kept published (this is restored in revision 112) [3]',
  'log' => 'Published node with multiple states (279706) published version was edited and kept published (this is restored in revision 112) [3]',
  'timestamp' => '1634048897',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '1',
  'vid' => '104',
  'uid' => '1',
  'title' => 'Published node with multiple states (279706) new draft [4]',
  'log' => 'Published node with multiple states (279706) new draft [4]',
  'timestamp' => '1634048911',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '1',
  'vid' => '105',
  'uid' => '1',
  'title' => 'Published node with multiple states (279706) published version was edited and kept published (this is restored in revision 112) [3]',
  'log' => 'Published node with multiple states (279706) published version was edited and kept published (this is restored in revision 112) [3]',
  'timestamp' => '1634048911',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '1',
  'vid' => '106',
  'uid' => '1',
  'title' => 'Published node with multiple states (279706) edit of the new draft, sent to review (review sets back to draft on moderation tab) [5,6]',
  'log' => 'Published node with multiple states (279706) edit of the new draft, sent to review (review sets back to draft on moderation tab) [5,6]',
  'timestamp' => '1634048958',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '1',
  'vid' => '107',
  'uid' => '1',
  'title' => 'Published node with multiple states (279706) published version was edited and kept published (this is restored in revision 112) [3]',
  'log' => 'Published node with multiple states (279706) published version was edited and kept published (this is restored in revision 112) [3]',
  'timestamp' => '1634048933',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '1',
  'vid' => '108',
  'uid' => '1',
  'title' => 'Published node with multiple states (279706) published version was edited and kept published (this is restored in revision 112) [3]',
  'log' => 'Published node with multiple states (279706) published version was edited and kept published (this is restored in revision 112) [3]',
  'timestamp' => '1634048958',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '1',
  'vid' => '109',
  'uid' => '1',
  'title' => 'Published node with multiple states (279706) Previously rejected new draft sent to review [7]',
  'log' => 'Published node with multiple states (279706) Previously rejected new draft sent to review [7]',
  'timestamp' => '1634049000',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '1',
  'vid' => '110',
  'uid' => '1',
  'title' => 'Published node with multiple states (279706) published version was edited and kept published (this is restored in revision 112) [3]',
  'log' => 'Published node with multiple states (279706) published version was edited and kept published (this is restored in revision 112) [3]',
  'timestamp' => '1634049000',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '1',
  'vid' => '111',
  'uid' => '1',
  'title' => 'Published node with multiple states (279706) New draft reviewed and published [8]',
  'log' => 'Published node with multiple states (279706) New draft reviewed and published [8]',
  'timestamp' => '1634049035',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '1',
  'vid' => '112',
  'uid' => '1',
  'title' => 'Published node with multiple states (279706) published version was edited and kept published (this is restored in revision 112) [3]',
  'log' => 'Copy of the revision from <em class="placeholder">Tue, 10/12/2021 - 14:28</em>.',
  'timestamp' => '1634049056',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '2',
  'vid' => '201',
  'uid' => '1',
  'title' => 'Never ever published node (280856) initial draft saved as draft [1]',
  'log' => 'Never ever published node (280856) initial draft saved as draft [1]',
  'timestamp' => '1634049454',
  'status' => '0',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '2',
  'vid' => '202',
  'uid' => '1',
  'title' => 'Never ever published node (280856) initial draft edited and saved again as draft [2]',
  'log' => 'Never ever published node (280856) initial draft edited and saved again as draft [2]',
  'timestamp' => '1634049483',
  'status' => '0',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '2',
  'vid' => '203',
  'uid' => '1',
  'title' => 'Never ever published node (280856) initial draft sent to review (review sets back to draft) [3,4]',
  'log' => 'Never ever published node (280856) initial draft sent to review (review sets back to draft) [3,4]',
  'timestamp' => '1634049518',
  'status' => '0',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '2',
  'vid' => '204',
  'uid' => '1',
  'title' => 'Never ever published node (280856) initial draft sent to review again [5]',
  'log' => 'Never ever published node (280856) initial draft sent to review again [5]',
  'timestamp' => '1634049538',
  'status' => '0',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '3',
  'vid' => '301',
  'uid' => '1',
  'title' => 'Node with forward revision (beginning of 263651) initially saved as published [1]',
  'log' => 'Node with forward revision (beginning of 263651) initially saved as published [1]',
  'timestamp' => '1634050731',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '3',
  'vid' => '302',
  'uid' => '1',
  'title' => 'Node with forward revision (beginning of 263651) new draft [2]',
  'log' => 'Node with forward revision (beginning of 263651) new draft [2]',
  'timestamp' => '1634050745',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '3',
  'vid' => '303',
  'uid' => '1',
  'title' => 'Node with forward revision (beginning of 263651) initially saved as published [1]',
  'log' => 'Node with forward revision (beginning of 263651) initially saved as published [1]',
  'timestamp' => '1634050745',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '3',
  'vid' => '304',
  'uid' => '1',
  'title' => 'Node with forward revision (beginning of 263651) new draft edited, kept draft [3]',
  'log' => 'Node with forward revision (beginning of 263651) new draft edited, kept draft [3]',
  'timestamp' => '1634050760',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '3',
  'vid' => '305',
  'uid' => '1',
  'title' => 'Node with forward revision (beginning of 263651) initially saved as published [1]',
  'log' => 'Node with forward revision (beginning of 263651) initially saved as published [1]',
  'timestamp' => '1634050760',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '4',
  'vid' => '401',
  'uid' => '1',
  'title' => 'Unpublished node which was published before (270401) initial draft sent to review [1]',
  'log' => 'Unpublished node which was published before (270401) initial draft sent to review [1]',
  'timestamp' => '1634050903',
  'status' => '0',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '4',
  'vid' => '402',
  'uid' => '1',
  'title' => 'Unpublished node which was published before (270401) initial reviewed and published (review sets back to review on moderation tab) [2,4]',
  'log' => 'Unpublished node which was published before (270401) initial reviewed and published (review sets back to review on moderation tab) [2,4]',
  'timestamp' => '1634050922',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '4',
  'vid' => '403',
  'uid' => '1',
  'title' => 'Unpublished node which was published before (270401) new draft [3]',
  'log' => 'Unpublished node which was published before (270401) new draft [3]',
  'timestamp' => '1634051011',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '4',
  'vid' => '404',
  'uid' => '1',
  'title' => 'Unpublished node which was published before (270401) initial reviewed and published (review sets back to review on moderation tab) [2,4]',
  'log' => 'Unpublished node which was published before (270401) initial reviewed and published (review sets back to review on moderation tab) [2,4]',
  'timestamp' => '1634051021',
  'status' => '0',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '5',
  'vid' => '501',
  'uid' => '1',
  'title' => 'Node with multiple published revisions (279026) initial draft saved as published [1]',
  'log' => 'Node with multiple published revisions (279026) initial draft saved as published [1]',
  'timestamp' => '1634129103',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '5',
  'vid' => '502',
  'uid' => '1',
  'title' => 'Node with multiple published revisions (279026) new draft [2]',
  'log' => 'Node with multiple published revisions (279026) new draft [2]',
  'timestamp' => '1634129128',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '5',
  'vid' => '503',
  'uid' => '1',
  'title' => 'Node with multiple published revisions (279026) initial draft saved as published [1]',
  'log' => 'Node with multiple published revisions (279026) initial draft saved as published [1]',
  'timestamp' => '1634129128',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '5',
  'vid' => '504',
  'uid' => '1',
  'title' => 'Node with multiple published revisions (279026) new draft edited [3]',
  'log' => 'Node with multiple published revisions (279026) new draft edited [3]',
  'timestamp' => '1634129955',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '5',
  'vid' => '505',
  'uid' => '1',
  'title' => 'Node with multiple published revisions (279026) initial draft saved as published [1]',
  'log' => 'Node with multiple published revisions (279026) initial draft saved as published [1]',
  'timestamp' => '1634129955',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '5',
  'vid' => '506',
  'uid' => '1',
  'title' => 'Node with multiple published revisions (279026) new draft published [4]',
  'log' => 'Node with multiple published revisions (279026) new draft published [4]',
  'timestamp' => '1634129997',
  'status' => '0',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '5',
  'vid' => '507',
  'uid' => '1',
  'title' => 'Node with multiple published revisions (279026) initial draft saved as published [1]',
  'log' => 'Copy of the revision from <em class="placeholder">Wed, 10/13/2021 - 12:45</em>.',
  'timestamp' => '1634130038',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '5',
  'vid' => '508',
  'uid' => '1',
  'title' => 'Node with multiple published revisions (279026) newer draft [7]',
  'log' => 'Node with multiple published revisions (279026) newer draft [7]',
  'timestamp' => '1634135026',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '5',
  'vid' => '509',
  'uid' => '1',
  'title' => 'Node with multiple published revisions (279026) initial draft saved as published [1]',
  'log' => 'Copy of the revision from <em class="placeholder">Wed, 10/13/2021 - 12:45</em>.',
  'timestamp' => '1634135026',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '5',
  'vid' => '510',
  'uid' => '1',
  'title' => 'Node with multiple published revisions (279026) newer draft sent to review [8]',
  'log' => 'Node with multiple published revisions (279026) newer draft sent to review [8]',
  'timestamp' => '1634135122',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '5',
  'vid' => '511',
  'uid' => '1',
  'title' => 'Node with multiple published revisions (279026) initial draft saved as published [1]',
  'log' => 'Copy of the revision from <em class="placeholder">Wed, 10/13/2021 - 12:45</em>.',
  'timestamp' => '1634135122',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '5',
  'vid' => '512',
  'uid' => '1',
  'title' => 'Node with multiple published revisions (279026) newer draft published [9]',
  'log' => 'Node with multiple published revisions (279026) newer draft published [9]',
  'timestamp' => '1634135144',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '5',
  'vid' => '513',
  'uid' => '1',
  'title' => 'Node with multiple published revisions (279026) published version was edited and kept published [10]',
  'log' => 'Node with multiple published revisions (279026) published version was edited and kept published [10]',
  'timestamp' => '1634135170',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '5',
  'vid' => '514',
  'uid' => '1',
  'title' => 'Node with multiple published revisions (279026) yet another draft [11]',
  'log' => 'Node with multiple published revisions (279026) yet another draft [11]',
  'timestamp' => '1634135186',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->values(array(
  'nid' => '5',
  'vid' => '515',
  'uid' => '1',
  'title' => 'Node with multiple published revisions (279026) published version was edited and kept published [10]',
  'log' => 'Node with multiple published revisions (279026) published version was edited and kept published [10]',
  'timestamp' => '1634135186',
  'status' => '1',
  'comment' => '0',
  'promote' => '0',
  'sticky' => '0',
))
->execute();