comparison core/modules/migrate_drupal/tests/fixtures/drupal6.php @ 17:129ea1e6d783

Update, including to Drupal core 8.6.10

   'callback' => 'user_block_user_action',
   'parameters' => '',
   'description' => 'Block current user',
 ))
 ->execute();
-
 $connection->schema()->createTable('actions_aid', array(
   'fields' => array(
     'aid' => array(
       'type' => 'serial',
       'not null' => TRUE,

 ))
 ->values(array(
   'aid' => '6',
 ))
 ->execute();
-
 $connection->schema()->createTable('aggregator_category', array(
   'fields' => array(
     'cid' => array(
       'type' => 'serial',
       'not null' => TRUE,

   'etag' => '"213cc1365b96c310e92053c5551f0504"',
   'modified' => '0',
   'block' => '7',
 ))
 ->execute();
-
 $connection->schema()->createTable('aggregator_item', array(
   'fields' => array(
     'iid' => array(
       'type' => 'serial',
       'not null' => TRUE,

   'description' => "<h2 id='new'>What's new with Drupal 8?</h2>",
   'timestamp' => '1389297196',
   'guid' => '395218 at https://groups.drupal.org',
 ))
 ->execute();
-
 $connection->schema()->createTable('authmap', array(
   'fields' => array(
     'aid' => array(
       'type' => 'serial',
       'not null' => TRUE,

   'token' => '',
   'timestamp' => '1494966324',
   'batch' => NULL,
 ))
 ->execute();
-
 $connection->schema()->createTable('blocks', array(
   'fields' => array(
     'bid' => array(
       'type' => 'serial',
       'not null' => TRUE,

   'region' => 'left',
   'custom' => '0',
   'throttle' => '0',
   'visibility' => '0',
   'pages' => '',
-  'title' => '',
+  'title' => 'zu - Navigation',
   'cache' => '-1',
 ))
 ->values(array(
   'bid' => '3',
   'module' => 'system',

   'pages' => '',
   'title' => '',
   'cache' => '-1',
 ))
 ->execute();
-
 $connection->schema()->createTable('blocks_roles', array(
   'fields' => array(
     'module' => array(
       'type' => 'varchar',
       'not null' => TRUE,

   'module' => 'user',
   'delta' => '3',
   'rid' => '3',
 ))
 ->execute();
-
 $connection->schema()->createTable('book', array(
   'fields' => array(
     'mlid' => array(
       'type' => 'int',
       'not null' => TRUE,

   'mlid' => '5',
   'nid' => '8',
   'bid' => '8',
 ))
 ->execute();
-
 $connection->schema()->createTable('boxes', array(
   'fields' => array(
     'bid' => array(
       'type' => 'serial',
       'not null' => TRUE,

   'body' => '<h3>My second custom block body</h3>',
   'info' => 'My block 2',
   'format' => '2',
 ))
 ->execute();
-
 $connection->schema()->createTable('cache', array(
   'fields' => array(
     'cid' => array(
       'type' => 'varchar',
       'not null' => TRUE,

   'thread' => '01.00.00/',
   'name' => 'root',
   'mail' => '',
   'homepage' => '',
 ))
+->values(array(
+  'cid' => '7',
+  'pid' => '0',
+  'nid' => '21',
+  'uid' => '1',
+  'subject' => 'Comment to John Smith - EN',
+  'comment' => 'This is an English comment.',
+  'hostname' => '2001:14ba:13f8:300:d9d0:363c:9fe4:66e1',
+  'timestamp' => '1534014729',
+  'status' => '0',
+  'format' => '1',
+  'thread' => '01/',
+  'name' => 'root',
+  'mail' => '',
+  'homepage' => '',
+))
+->values(array(
+  'cid' => '8',
+  'pid' => '0',
+  'nid' => '22',
+  'uid' => '1',
+  'subject' => 'Comment to John Smith - FR',
+  'comment' => 'This is a French comment.',
+  'hostname' => '2001:14ba:13f8:300:d9d0:363c:9fe4:66e1',
+  'timestamp' => '1534014763',
+  'status' => '0',
+  'format' => '1',
+  'thread' => '01/',
+  'name' => 'root',
+  'mail' => '',
+  'homepage' => '',
+))
 ->execute();
-
 $connection->schema()->createTable('config', array(
   'fields' => array(
     'collection' => array(
       'type' => 'varchar',
       'not null' => TRUE,

   'collection' => '',
   'name' => 'system.file',
   'data' => 'a:1:{s:4:"path";a:1:{s:9:"temporary";s:4:"/tmp";}}',
 ))
 ->execute();
-
 $connection->schema()->createTable('contact', array(
   'fields' => array(
     'cid' => array(
       'type' => 'serial',
       'not null' => TRUE,

   'reply' => '',
   'weight' => '2',
   'selected' => '0',
 ))
 ->execute();
-
 $connection->schema()->createTable('content_field_company', array(
   'fields' => array(
     'vid' => array(
       'type' => 'int',
       'not null' => TRUE,

   'nid' => '18',
   'delta' => '0',
   'field_company_nid' => '15',
 ))
 ->values(array(
+  'vid' => '2002',
+  'nid' => '21',
+  'delta' => '0',
+  'field_company_nid' => NULL,
+))
+->values(array(
+  'vid' => '2003',
+  'nid' => '22',
+  'delta' => '0',
+  'field_company_nid' => NULL,
+))
+->values(array(
   'vid' => '21',
   'nid' => '18',
   'delta' => '1',
   'field_company_nid' => '16',
 ))
 ->execute();
-
 $connection->schema()->createTable('content_field_image', array(
   'fields' => array(
     'vid' => array(
       'type' => 'int',
       'not null' => TRUE,

   'field_image_fid' => '2',
   'field_image_list' => '1',
   'field_image_data' => 'a:2:{s:3:"alt";s:0:"";s:5:"title";s:0:"";}',
 ))
 ->execute();
-
 $connection->schema()->createTable('content_field_multivalue', array(
   'fields' => array(
     'vid' => array(
       'type' => 'int',
       'not null' => TRUE,

   'nid' => '3',
   'field_multivalue_value' => '44.00',
   'delta' => '1',
 ))
 ->execute();
-
 $connection->schema()->createTable('content_field_test', array(
   'fields' => array(
     'vid' => array(
       'type' => 'int',
       'not null' => TRUE,

   'nid' => '9',
   'field_test_value' => 'text for default value',
   'field_test_format' => '1',
 ))
 ->execute();
-
 $connection->schema()->createTable('content_field_test_text_single_checkbox', array(
   'fields' => array(
     'vid' => array(
       'type' => 'int',
       'not null' => TRUE,

   'vid' => '12',
   'nid' => '9',
   'field_test_text_single_checkbox_value' => '0',
 ))
 ->execute();
-
 $connection->schema()->createTable('content_field_test_two', array(
   'fields' => array(
     'vid' => array(
       'type' => 'int',
       'not null' => TRUE,

   'nid' => '1',
   'delta' => '1',
   'field_test_two_value' => '20',
 ))
 ->execute();
-
 $connection->schema()->createTable('content_group', array(
   'fields' => array(
     'group_type' => array(
       'type' => 'varchar',
       'not null' => TRUE,

   'db_columns' => 'a:1:{s:5:"value";a:3:{s:4:"type";s:7:"varchar";s:6:"length";i:255;s:8:"not null";b:0;}}',
   'active' => '1',
   'locked' => '0',
 ))
 ->values(array(
+  'field_name' => 'field_test_string_selectlist',
+  'type' => 'text',
+  'global_settings' => "a:4:{s:15:\"text_processing\";s:1:\"0\";s:10:\"max_length\";s:0:\"\";s:14:\"allowed_values\";s:18:\"A|Black\r\nB|White\r\n\";s:18:\"allowed_values_php\";s:0:\"\";}",
+  'required' => '0',
+  'multiple' => '0',
+  'db_storage' => '1',
+  'module' => 'text',
+  'db_columns' => 'a:1:{s:5:"value";a:5:{s:4:"type";s:4:"text";s:4:"size";s:3:"big";s:8:"not null";b:0;s:8:"sortable";b:1;s:5:"views";b:1;}}',
+  'active' => '1',
+  'locked' => '0',
+))
+->values(array(
   'field_name' => 'field_test_text_single_checkbox',
   'type' => 'text',
   'global_settings' => "a:4:{s:15:\"text_processing\";s:1:\"0\";s:10:\"max_length\";s:0:\"\";s:14:\"allowed_values\";s:18:\"0|Hello\r\n1|Goodbye\";s:18:\"allowed_values_php\";s:0:\"\";}",
   'required' => '0',
   'multiple' => '0',

   'db_columns' => 'a:1:{s:5:"value";a:3:{s:4:"type";s:3:"int";s:8:"not null";b:0;s:8:"sortable";b:1;}}',
   'active' => '1',
   'locked' => '0',
 ))
 ->execute();
-
 $connection->schema()->createTable('content_node_field_instance', array(
   'fields' => array(
     'field_name' => array(
       'type' => 'varchar',
       'not null' => TRUE,

   'description' => 'An example phone field.',
   'widget_module' => 'phone',
   'widget_active' => '1',
 ))
 ->values(array(
+  'field_name' => 'field_test_string_selectlist',
+  'type_name' => 'story',
+  'weight' => '31',
+  'label' => 'String Select List Field',
+  'widget_type' => 'optionwidgets_select',
+  'widget_settings' => 'a:2:{s:13:"default_value";a:1:{i:0;a:1:{s:5:"value";s:0:"";}}s:17:"default_value_php";N;}',
+  'display_settings' => 'a:5:{s:5:"label";a:2:{s:6:"format";s:5:"above";s:7:"exclude";i:0;}i:5;a:2:{s:6:"format";s:7:"default";s:7:"exclude";i:0;}s:6:"teaser";a:2:{s:6:"format";s:7:"default";s:7:"exclude";i:0;}s:4:"full";a:2:{s:6:"format";s:7:"default";s:7:"exclude";i:0;}i:4;a:2:{s:6:"format";s:7:"default";s:7:"exclude";i:0;}}',
+  'description' => '',
+  'widget_module' => 'optionwidgets',
+  'widget_active' => '1',
+))
+->values(array(
   'field_name' => 'field_test_text_single_checkbox',
   'type_name' => 'story',
   'weight' => '17',
   'label' => 'Text Single Checkbox Field',
   'widget_type' => 'optionwidgets_onoff',

   'description' => 'An example integer field.',
   'widget_module' => 'number',
   'widget_active' => '1',
 ))
 ->execute();
-
 $connection->schema()->createTable('content_type_employee', array(
   'fields' => array(
     'vid' => array(
       'type' => 'int',
       'not null' => TRUE,

   'nid' => '18',
   'field_commander_uid' => '8',
   'field_company_2_nid' => '15',
   'field_company_3_nid' => '16',
 ))
+->values(array(
+  'vid' => '2002',
+  'nid' => '21',
+  'field_commander_uid' => NULL,
+  'field_company_2_nid' => NULL,
+  'field_company_3_nid' => NULL,
+))
+->values(array(
+  'vid' => '2003',
+  'nid' => '22',
+  'field_commander_uid' => NULL,
+  'field_company_2_nid' => NULL,
+  'field_company_3_nid' => NULL,
+))
 ->execute();
-
 $connection->schema()->createTable('content_type_page', array(
   'fields' => array(
     'vid' => array(
       'type' => 'int',
       'not null' => TRUE,

   'field_text_field_value' => NULL,
   'field_reference_nid' => '11',
   'field_reference_2_nid' => '11',
 ))
 ->execute();
-
 $connection->schema()->createTable('content_type_story', array(
   'fields' => array(
     'nid' => array(
       'type' => 'int',
       'not null' => TRUE,

     ),
     'field_test_datetime_value2' => array(
       'type' => 'varchar',
       'not null' => FALSE,
       'length' => '100',
+    ),
+    'field_test_string_selectlist_value' => array(
+      'type' => 'text',
+      'not null' => FALSE,
+      'size' => 'big',
     ),
   ),
   'primary key' => array(
     'vid',
   ),

   'field_test_imagefield_list',
   'field_test_imagefield_data',
   'field_test_text_single_checkbox2_value',
   'field_test_datestamp_value2',
   'field_test_datetime_value2',
+  'field_test_string_selectlist_value',
 ))
 ->values(array(
   'nid' => '1',
   'vid' => '1',
   'uid' => '1',

   'field_test_imagefield_list' => NULL,
   'field_test_imagefield_data' => NULL,
   'field_test_text_single_checkbox2_value' => 'Hello',
   'field_test_datestamp_value2' => NULL,
   'field_test_datetime_value2' => NULL,
+  'field_test_string_selectlist_value' => NULL,
 ))
 ->values(array(
   'nid' => '1',
   'vid' => '2',
   'uid' => '1',

   'field_test_imagefield_list' => NULL,
   'field_test_imagefield_data' => NULL,
   'field_test_text_single_checkbox2_value' => NULL,
   'field_test_datestamp_value2' => NULL,
   'field_test_datetime_value2' => NULL,
+  'field_test_string_selectlist_value' => NULL,
 ))
 ->values(array(
   'nid' => '2',
   'vid' => '3',
   'uid' => '1',

   'field_test_imagefield_list' => NULL,
   'field_test_imagefield_data' => NULL,
   'field_test_text_single_checkbox2_value' => NULL,
   'field_test_datestamp_value2' => NULL,
   'field_test_datetime_value2' => NULL,
+  'field_test_string_selectlist_value' => NULL,
 ))
 ->values(array(
   'nid' => '2',
   'vid' => '5',
   'uid' => '1',

   'field_test_imagefield_list' => NULL,
   'field_test_imagefield_data' => NULL,
   'field_test_text_single_checkbox2_value' => NULL,
   'field_test_datestamp_value2' => NULL,
   'field_test_datetime_value2' => NULL,
+  'field_test_string_selectlist_value' => NULL,
 ))
 ->values(array(
   'nid' => '9',
   'vid' => '12',
   'uid' => '0',

   'field_test_imagefield_list' => '1',
   'field_test_imagefield_data' => 'a:2:{s:3:"alt";s:8:"Test alt";s:5:"title";s:10:"Test title";}',
   'field_test_text_single_checkbox2_value' => 'Off',
   'field_test_datestamp_value2' => '1391357160',
   'field_test_datetime_value2' => '2015-03-04 06:07:00',
+  'field_test_string_selectlist_value' => NULL,
 ))
 ->execute();
-
 $connection->schema()->createTable('content_type_test_page', array(
   'fields' => array(
     'vid' => array(
       'type' => 'int',
       'not null' => TRUE,

 ->values(array(
   'nid' => '9',
   'vid' => '11',
 ))
 ->execute();
-
 $connection->schema()->createTable('date_format_locale', array(
   'fields' => array(
     'format' => array(
       'type' => 'varchar',
       'not null' => TRUE,

   'type' => 'short',
   'title' => 'Short',
   'locked' => '1',
 ))
 ->execute();
-
 $connection->schema()->createTable('date_formats', array(
   'fields' => array(
     'dfid' => array(
       'type' => 'serial',
       'not null' => TRUE,

   'format' => 'l, j. F Y - G:i',
   'type' => 'long',
   'locked' => '1',
 ))
 ->execute();
-
 $connection->schema()->createTable('event', array(
   'fields' => array(
     'nid' => array(
       'type' => 'int',
       'not null' => TRUE,

   'offset_dst' => '00:00:00',
   'dst_region' => '0',
   'is_dst' => '0',
 ))
 ->execute();
-
 $connection->schema()->createTable('files', array(
   'fields' => array(
     'fid' => array(
       'type' => 'serial',
       'not null' => TRUE,

   'filesize' => '24',
   'status' => '0',
   'timestamp' => '1420858106',
 ))
 ->execute();
-
 $connection->schema()->createTable('filter_formats', array(
   'fields' => array(
     'format' => array(
       'type' => 'serial',
       'not null' => TRUE,

   'name' => 'PHP Code',
   'roles' => ',3,4,5,',
   'cache' => '0',
 ))
 ->execute();
-
 $connection->schema()->createTable('filters', array(
   'fields' => array(
     'fid' => array(
       'type' => 'serial',
       'not null' => TRUE,

   'module' => 'php',
   'delta' => '0',
   'weight' => '10',
 ))
 ->execute();
-
 $connection->schema()->createTable('flood', array(
   'fields' => array(
     'fid' => array(
       'type' => 'serial',
       'not null' => TRUE,

   'nid' => '19',
   'vid' => '22',
   'tid' => '8',
 ))
 ->execute();
-
 $connection->schema()->createTable('history', array(
   'fields' => array(
     'uid' => array(
       'type' => 'int',
       'not null' => TRUE,

 ->values(array(
   'uid' => '1',
   'nid' => '19',
   'timestamp' => '1501955803',
 ))
+->values(array(
+  'uid' => '1',
+  'nid' => '21',
+  'timestamp' => '1534014729',
+))
+->values(array(
+  'uid' => '1',
+  'nid' => '22',
+  'timestamp' => '1534014763',
+))
 ->execute();
-
 $connection->schema()->createTable('i18n_blocks', array(
   'fields' => array(
     'ibid' => array(
       'type' => 'serial',
       'not null' => TRUE,

     'ibid',
   ),
   'mysql_character_set' => 'utf8',
 ));
 
+$connection->insert('i18n_blocks')
+->fields(array(
+  'ibid',
+  'module',
+  'delta',
+  'type',
+  'language',
+))
+->values(array(
+  'ibid' => '1',
+  'module' => 'user',
+  'delta' => '1',
+  'type' => '0',
+  'language' => 'zu',
+))
+->values(array(
+  'ibid' => '2',
+  'module' => 'menu',
+  'delta' => 'menu-translation-test',
+  'type' => '0',
+  'language' => 'zu',
+))
+->execute();
 $connection->schema()->createTable('i18n_strings', array(
   'fields' => array(
     'lid' => array(
       'type' => 'int',
       'not null' => TRUE,

   'type' => 'field',
   'property' => 'title',
   'objectindex' => '0',
   'format' => '0',
 ))
+->values(array(
+  'lid' => '1679',
+  'objectid' => 'menu-translation-test',
+  'type' => 'menu',
+  'property' => 'title',
+  'objectindex' => '0',
+  'format' => '0',
+))
+->values(array(
+  'lid' => '1680',
+  'objectid' => 'employee-field_company',
+  'type' => 'field',
+  'property' => 'widget_label',
+  'objectindex' => '0',
+  'format' => '0',
+))
+->values(array(
+  'lid' => '1681',
+  'objectid' => 'employee-field_commander',
+  'type' => 'field',
+  'property' => 'widget_label',
+  'objectindex' => '0',
+  'format' => '0',
+))
+->values(array(
+  'lid' => '1682',
+  'objectid' => 'employee-field_company_2',
+  'type' => 'field',
+  'property' => 'widget_label',
+  'objectindex' => '0',
+  'format' => '0',
+))
+->values(array(
+  'lid' => '1683',
+  'objectid' => 'employee-field_company_3',
+  'type' => 'field',
+  'property' => 'widget_label',
+  'objectindex' => '0',
+  'format' => '0',
+))
+->values(array(
+  'lid' => '1684',
+  'objectid' => 'page-field_reference',
+  'type' => 'field',
+  'property' => 'widget_label',
+  'objectindex' => '0',
+  'format' => '0',
+))
+->values(array(
+  'lid' => '1685',
+  'objectid' => 'page-field_reference_2',
+  'type' => 'field',
+  'property' => 'widget_label',
+  'objectindex' => '0',
+  'format' => '0',
+))
+->values(array(
+  'lid' => '1686',
+  'objectid' => 'story-field_test_string_selectlist',
+  'type' => 'field',
+  'property' => 'widget_label',
+  'objectindex' => '0',
+  'format' => '0',
+))
+->values(array(
+  'lid' => '1689',
+  'objectid' => 'test_planet-field_test_text_single_checkbox',
+  'type' => 'field',
+  'property' => 'widget_label',
+  'objectindex' => '0',
+  'format' => '0',
+))
+->values(array(
+  'lid' => '1690',
+  'objectid' => 'field_test_string_selectlist',
+  'type' => 'field',
+  'property' => 'option_A',
+  'objectindex' => '0',
+  'format' => '0',
+))
+->values(array(
+  'lid' => '1691',
+  'objectid' => 'field_test_string_selectlist',
+  'type' => 'field',
+  'property' => 'option_B',
+  'objectindex' => '0',
+  'format' => '0',
+))
+->values(array(
+  'lid' => '1692',
+  'objectid' => '14',
+  'type' => 'term',
+  'property' => 'name',
+  'objectindex' => '14',
+  'format' => '0',
+))
+->values(array(
+  'lid' => '1693',
+  'objectid' => '15',
+  'type' => 'term',
+  'property' => 'name',
+  'objectindex' => '15',
+  'format' => '0',
+))
+->values(array(
+  'lid' => '1694',
+  'objectid' => '14',
+  'type' => 'term',
+  'property' => 'description',
+  'objectindex' => '14',
+  'format' => '0',
+))
+->values(array(
+  'lid' => '1695',
+  'objectid' => 'profile_count_trees',
+  'type' => 'field',
+  'property' => 'title',
+  'objectindex' => '0',
+  'format' => '0',
+))
+->values(array(
+  'lid' => '1696',
+  'objectid' => 'profile_count_trees',
+  'type' => 'field',
+  'property' => 'options',
+  'objectindex' => '0',
+  'format' => '0',
+))
 ->execute();
-
 $connection->schema()->createTable('i18n_variable', array(
   'fields' => array(
     'name' => array(
       'type' => 'varchar',
       'not null' => TRUE,

   'name' => 'user_signatures',
   'language' => 'zu',
   'value' => 's:1:"1";',
 ))
 ->execute();
-
 $connection->schema()->createTable('imagecache_action', array(
   'fields' => array(
     'actionid' => array(
       'type' => 'serial',
       'not null' => TRUE,

   'module' => 'imagecache',
   'action' => 'imagecache_rotate',
   'data' => 'a:3:{s:7:"degrees";s:2:"55";s:6:"random";i:0;s:7:"bgcolor";s:0:"";}',
 ))
 ->execute();
-
 $connection->schema()->createTable('imagecache_preset', array(
   'fields' => array(
     'presetid' => array(
       'type' => 'serial',
       'not null' => TRUE,

 ->values(array(
   'presetid' => '2',
   'presetname' => 'big_blue_cheese',
 ))
 ->execute();
-
 $connection->schema()->createTable('languages', array(
   'fields' => array(
     'language' => array(
       'type' => 'varchar',
       'not null' => TRUE,

   'prefix' => 'zu',
   'weight' => '0',
   'javascript' => '',
 ))
 ->execute();
-
 $connection->schema()->createTable('locales_source', array(
   'fields' => array(
     'lid' => array(
       'type' => 'serial',
       'not null' => TRUE,

   'textgroup' => 'cck',
   'source' => 'An example multi-valued decimal field.',
   'version' => '1',
 ))
 ->values(array(
-  'lid' => '626',
-  'location' => 'field:test_planet-field_test_text_single_checkbox:widget_label',
-  'textgroup' => 'cck',
-  'source' => 'Text Single Checkbox Field',
-  'version' => '1',
-))
-->values(array(
   'lid' => '627',
   'location' => 'field:test_planet-field_test_text_single_checkbox:widget_description',
   'textgroup' => 'cck',
   'source' => 'An example text field using a single on/off checkbox.',
   'version' => '1',

   'location' => 'field:profile_really_really_love_migrating:title',
   'textgroup' => 'profile',
   'source' => 'I really, really, really love migrating',
   'version' => '1',
 ))
+->values(array(
+  'lid' => '1679',
+  'location' => 'menu:menu-translation-test:title',
+  'textgroup' => 'menu',
+  'source' => 'Translation test',
+  'version' => '1',
+))
+->values(array(
+  'lid' => '1680',
+  'location' => 'field:employee-field_company:widget_label',
+  'textgroup' => 'cck',
+  'source' => 'Company',
+  'version' => '1',
+))
+->values(array(
+  'lid' => '1681',
+  'location' => 'field:employee-field_commander:widget_label',
+  'textgroup' => 'cck',
+  'source' => 'Commanding Officer',
+  'version' => '1',
+))
+->values(array(
+  'lid' => '1682',
+  'location' => 'field:employee-field_company_2:widget_label',
+  'textgroup' => 'cck',
+  'source' => 'Company 2',
+  'version' => '1',
+))
+->values(array(
+  'lid' => '1683',
+  'location' => 'field:employee-field_company_3:widget_label',
+  'textgroup' => 'cck',
+  'source' => 'Company 3',
+  'version' => '1',
+))
+->values(array(
+  'lid' => '1684',
+  'location' => 'field:page-field_reference:widget_label',
+  'textgroup' => 'cck',
+  'source' => 'Reference',
+  'version' => '1',
+))
+->values(array(
+  'lid' => '1685',
+  'location' => 'field:page-field_reference_2:widget_label',
+  'textgroup' => 'cck',
+  'source' => 'Reference',
+  'version' => '1',
+))
+->values(array(
+  'lid' => '1686',
+  'location' => 'field:story-field_test_string_selectlist:widget_label',
+  'textgroup' => 'cck',
+  'source' => 'String Select List Field',
+  'version' => '1',
+))
+->values(array(
+  'lid' => '1689',
+  'location' => 'field:test_planet-field_test_text_single_checkbox:widget_label',
+  'textgroup' => 'cck',
+  'source' => 'Text Single Checkbox Field',
+  'version' => '1',
+))
+->values(array(
+  'lid' => '1690',
+  'location' => 'field:field_test_string_selectlist:option_A',
+  'textgroup' => 'cck',
+  'source' => 'Black',
+  'version' => '1',
+))
+->values(array(
+  'lid' => '1691',
+  'location' => 'field:field_test_string_selectlist:option_B',
+  'textgroup' => 'cck',
+  'source' => 'White',
+  'version' => '1',
+))
+->values(array(
+  'lid' => '1692',
+  'location' => 'term:14:name',
+  'textgroup' => 'taxonomy',
+  'source' => 'Talos IV',
+  'version' => '1',
+))
+->values(array(
+  'lid' => '1693',
+  'location' => 'term:15:name',
+  'textgroup' => 'taxonomy',
+  'source' => 'Vulcan',
+  'version' => '1',
+))
+->values(array(
+  'lid' => '1694',
+  'location' => 'term:14:description',
+  'textgroup' => 'taxonomy',
+  'source' => 'The home of Captain Christopher Pike.',
+  'version' => '1',
+))
+->values(array(
+  'lid' => '1695',
+  'location' => 'field:profile_:title',
+  'textgroup' => 'profile',
+  'source' => 'Number of trees',
+  'version' => '1',
+))
+->values(array(
+  'lid' => '1696',
+  'location' => 'field:profile_:options',
+  'textgroup' => 'profile',
+  'source' => "10\r\n20\r\n50\r\n100\r\n1000",
+  'version' => '1',
+))
 ->execute();
-
 $connection->schema()->createTable('locales_target', array(
   'fields' => array(
     'lid' => array(
       'type' => 'int',
       'not null' => TRUE,

   'plural' => '0',
   'i18n_status' => '0',
 ))
 ->values(array(
   'lid' => '575',
-  'translation' => 'fr -  An example text field.',
+  'translation' => 'fr - An example text field.',
   'language' => 'fr',
   'plid' => '0',
   'plural' => '0',
   'i18n_status' => '0',
 ))

   'plural' => '0',
   'i18n_status' => '0',
 ))
 ->values(array(
   'lid' => '589',
-  'translation' => 'fr - An example image field.',
+  'translation' => 'fr - An example file field.',
   'language' => 'fr',
   'plid' => '0',
   'plural' => '0',
   'i18n_status' => '0',
 ))

   'plid' => '0',
   'plural' => '0',
   'i18n_status' => '0',
 ))
 ->values(array(
+  'lid' => '607',
+  'translation' => 'fr - 1.234',
+  'language' => 'fr',
+  'plid' => '0',
+  'plural' => '0',
+  'i18n_status' => '0',
+))
+->values(array(
   'lid' => '608',
   'translation' => 'fr - Integer Select List Field',
   'language' => 'fr',
   'plid' => '0',
   'plural' => '0',

   'plid' => '0',
   'plural' => '0',
   'i18n_status' => '0',
 ))
 ->values(array(
+  'lid' => '611',
+  'translation' => 'fr - 2341',
+  'language' => 'fr',
+  'plid' => '0',
+  'plural' => '0',
+  'i18n_status' => '0',
+))
+->values(array(
+  'lid' => '613',
+  'translation' => 'fr - 4123',
+  'language' => 'fr',
+  'plid' => '0',
+  'plural' => '0',
+  'i18n_status' => '0',
+))
+->values(array(
   'lid' => '614',
   'translation' => 'fr - Text Single Checkbox Field',
   'language' => 'fr',
   'plid' => '0',
   'plural' => '0',

   'i18n_status' => '0',
 ))
 ->values(array(
   'lid' => '625',
   'translation' => 'Un exemple plusieurs valeurs champ décimal.',
-  'language' => 'fr',
-  'plid' => '0',
-  'plural' => '0',
-  'i18n_status' => '0',
-))
-->values(array(
-  'lid' => '626',
-  'translation' => 'fr - Text Single Checkbox Field',
   'language' => 'fr',
   'plid' => '0',
   'plural' => '0',
   'i18n_status' => '0',
 ))

   'plid' => '0',
   'plural' => '0',
   'i18n_status' => '0',
 ))
 ->values(array(
+  'lid' => '607',
+  'translation' => 'zu - 1.234',
+  'language' => 'zu',
+  'plid' => '0',
+  'plural' => '0',
+  'i18n_status' => '0',
+))
+->values(array(
+  'lid' => '611',
+  'translation' => 'zu - 2341',
+  'language' => 'zu',
+  'plid' => '0',
+  'plural' => '0',
+  'i18n_status' => '0',
+))
+->values(array(
   'lid' => '621',
   'translation' => 'zu - Hello',
   'language' => 'zu',
   'plid' => '0',
   'plural' => '0',

   'language' => 'zu',
   'plid' => '0',
   'plural' => '0',
   'i18n_status' => '0',
 ))
+->values(array(
+  'lid' => '1672',
+  'translation' => 'zu - Type',
+  'language' => 'zu',
+  'plid' => '0',
+  'plural' => '0',
+  'i18n_status' => '0',
+))
+->values(array(
+  'lid' => '1690',
+  'translation' => 'Okumnyama',
+  'language' => 'zu',
+  'plid' => '0',
+  'plural' => '0',
+  'i18n_status' => '0',
+))
+->values(array(
+  'lid' => '1690',
+  'translation' => 'Noir',
+  'language' => 'fr',
+  'plid' => '0',
+  'plural' => '0',
+  'i18n_status' => '0',
+))
+->values(array(
+  'lid' => '1691',
+  'translation' => 'Mhlophe',
+  'language' => 'zu',
+  'plid' => '0',
+  'plural' => '0',
+  'i18n_status' => '0',
+))
+->values(array(
+  'lid' => '1672',
+  'translation' => 'fr - Type',
+  'language' => 'fr',
+  'plid' => '0',
+  'plural' => '0',
+  'i18n_status' => '0',
+))
+->values(array(
+  'lid' => '1692',
+  'translation' => 'fr - Talos IV',
+  'language' => 'fr',
+  'plid' => '0',
+  'plural' => '0',
+  'i18n_status' => '0',
+))
+->values(array(
+  'lid' => '1693',
+  'translation' => 'zu - Vulcan',
+  'language' => 'zu',
+  'plid' => '0',
+  'plural' => '0',
+  'i18n_status' => '0',
+))
+->values(array(
+  'lid' => '1694',
+  'translation' => 'zu - The home of Captain Christopher Pike.',
+  'language' => 'zu',
+  'plid' => '0',
+  'plural' => '0',
+  'i18n_status' => '0',
+))
+->values(array(
+  'lid' => '1694',
+  'translation' => 'fr - The home of Captain Christopher Pike.',
+  'language' => 'fr',
+  'plid' => '0',
+  'plural' => '0',
+  'i18n_status' => '0',
+))
+->values(array(
+  'lid' => '1696',
+  'translation' => "fr - 10\r\nfr - 20\r\nfr - 50\r\nfr - 100\r\nfr - 1000",
+  'language' => 'fr',
+  'plid' => '0',
+  'plural' => '0',
+  'i18n_status' => '0',
+))
 ->execute();
-
 $connection->schema()->createTable('menu_custom', array(
   'fields' => array(
     'menu_name' => array(
       'type' => 'varchar',
       'not null' => TRUE,

   'menu_name' => 'secondary-links',
   'title' => 'Secondary links',
   'description' => 'Secondary links are often used for pages like legal notices, contact details, and other secondary navigation items that play a lesser role than primary links',
 ))
 ->execute();
-
 $connection->schema()->createTable('menu_links', array(
   'fields' => array(
     'menu_name' => array(
       'type' => 'varchar',
       'not null' => TRUE,

   'p8' => '0',
   'p9' => '0',
   'updated' => '0',
 ))
 ->execute();
-
 $connection->schema()->createTable('menu_router', array(
   'fields' => array(
     'path' => array(
       'type' => 'varchar',
       'not null' => TRUE,

   'position' => '',
   'weight' => '0',
   'file' => 'sites/all/modules/i18n/i18n.admin.inc',
 ))
 ->values(array(
+  'path' => 'admin/settings/language/i18n/variables',
+  'load_functions' => '',
+  'to_arg_functions' => '',
+  'access_callback' => 'user_access',
+  'access_arguments' => 'a:1:{i:0;s:29:"administer site configuration";}',
+  'page_callback' => 'drupal_get_form',
+  'page_arguments' => 'a:1:{i:0;s:25:"i18n_admin_variables_form";}',
+  'fit' => '31',
+  'number_parts' => '5',
+  'tab_parent' => 'admin/settings/language/i18n',
+  'tab_root' => 'admin/settings/language',
+  'title' => 'Variables',
+  'title_callback' => 't',
+  'title_arguments' => '',
+  'type' => '128',
+  'block_callback' => '',
+  'description' => 'Multilingual variables.',
+  'position' => '',
+  'weight' => '0',
+  'file' => 'sites/all/modules/i18n/i18n.admin.inc',
+))
+->values(array(
   'path' => 'admin/settings/language/overview',
   'load_functions' => '',
   'to_arg_functions' => '',
   'access_callback' => 'user_access',
   'access_arguments' => 'a:1:{i:0;s:20:"administer languages";}',

   'position' => '',
   'weight' => '0',
   'file' => '',
 ))
 ->execute();
-
 $connection->schema()->createTable('node', array(
   'fields' => array(
     'nid' => array(
       'type' => 'serial',
       'not null' => TRUE,

   'moderate' => '0',
   'sticky' => '0',
   'tnid' => '12',
   'translate' => '0',
 ))
+->values(array(
+  'nid' => '21',
+  'vid' => '2002',
+  'type' => 'employee',
+  'language' => 'en',
+  'title' => 'John Smith - EN',
+  'uid' => '1',
+  'status' => '1',
+  'created' => '1534014650',
+  'changed' => '1534014650',
+  'comment' => '2',
+  'promote' => '1',
+  'moderate' => '0',
+  'sticky' => '0',
+  'tnid' => '21',
+  'translate' => '0',
+))
+->values(array(
+  'nid' => '22',
+  'vid' => '2003',
+  'type' => 'employee',
+  'language' => 'fr',
+  'title' => 'John Smith - FR',
+  'uid' => '1',
+  'status' => '1',
+  'created' => '1534014687',
+  'changed' => '1534014687',
+  'comment' => '2',
+  'promote' => '1',
+  'moderate' => '0',
+  'sticky' => '0',
+  'tnid' => '21',
+  'translate' => '0',
+))
 ->execute();
-
 $connection->schema()->createTable('node_access', array(
   'fields' => array(
     'nid' => array(
       'type' => 'int',
       'not null' => TRUE,

   'grant_view' => '1',
   'grant_update' => '0',
   'grant_delete' => '0',
 ))
 ->execute();
-
 $connection->schema()->createTable('node_comment_statistics', array(
   'fields' => array(
     'nid' => array(
       'type' => 'int',
       'not null' => TRUE,

   'last_comment_timestamp' => '1501955803',
   'last_comment_name' => '',
   'last_comment_uid' => '1',
   'comment_count' => '3',
 ))
+->values(array(
+  'nid' => '21',
+  'last_comment_timestamp' => '1534014729',
+  'last_comment_name' => '',
+  'last_comment_uid' => '1',
+  'comment_count' => '1',
+))
+->values(array(
+  'nid' => '22',
+  'last_comment_timestamp' => '1534014763',
+  'last_comment_name' => '',
+  'last_comment_uid' => '1',
+  'comment_count' => '1',
+))
 ->execute();
-
 $connection->schema()->createTable('node_counter', array(
   'fields' => array(
     'nid' => array(
       'type' => 'int',
       'not null' => TRUE,

   'nid' => '19',
   'totalcount' => '4',
   'daycount' => '4',
   'timestamp' => '1501955803',
 ))
+->values(array(
+  'nid' => '21',
+  'totalcount' => '3',
+  'daycount' => '3',
+  'timestamp' => '1534014729',
+))
+->values(array(
+  'nid' => '22',
+  'totalcount' => '3',
+  'daycount' => '3',
+  'timestamp' => '1534014763',
+))
 ->execute();
-
 $connection->schema()->createTable('node_revisions', array(
   'fields' => array(
     'nid' => array(
       'type' => 'int',
       'not null' => TRUE,

   'log' => '',
   'timestamp' => '1420861423',
   'format' => '1',
 ))
 ->values(array(
-  'nid' => '1',
-  'vid' => '2',
-  'uid' => '2',
-  'title' => 'Test title rev 2',
-  'body' => 'body test rev 2',
-  'teaser' => 'teaser test rev 2',
-  'log' => 'modified rev 2',
-  'timestamp' => '1390095702',
-  'format' => '1',
-))
-->values(array(
   'nid' => '2',
   'vid' => '3',
   'uid' => '1',
   'title' => 'Test title rev 3',
   'body' => 'test rev 3',

   'teaser' => 'Le peuple zoulou.',
   'log' => '',
   'timestamp' => '1520613305',
   'format' => '1',
 ))
+->values(array(
+  'nid' => '1',
+  'vid' => '2001',
+  'uid' => '2',
+  'title' => 'Test title rev 2',
+  'body' => 'body test rev 2',
+  'teaser' => 'teaser test rev 2',
+  'log' => 'modified rev 2',
+  'timestamp' => '1390095702',
+  'format' => '1',
+))
+->values(array(
+  'nid' => '21',
+  'vid' => '2002',
+  'uid' => '1',
+  'title' => 'John Smith - EN',
+  'body' => 'This is an English Bio text for employee John Smith. There is also a French translation to this node. Both language versions have comments.',
+  'teaser' => 'This is an English Bio text for employee John Smith. There is also a French translation to this node. Both language versions have comments.',
+  'log' => '',
+  'timestamp' => '1534014650',
+  'format' => '1',
+))
+->values(array(
+  'nid' => '22',
+  'vid' => '2003',
+  'uid' => '1',
+  'title' => 'John Smith - FR',
+  'body' => 'This is a French Bio text for employee John Smith. The original node is in English. Both language versions have comments.',
+  'teaser' => 'This is a French Bio text for employee John Smith. The original node is in English. Both language versions have comments.',
+  'log' => '',
+  'timestamp' => '1534014687',
+  'format' => '1',
+))
 ->execute();
-
 $connection->schema()->createTable('node_type', array(
   'fields' => array(
     'type' => array(
       'type' => 'varchar',
       'not null' => TRUE,

   'modified' => '1',
   'locked' => '0',
   'orig_type' => 'test_story',
 ))
 ->execute();
-
 $connection->schema()->createTable('permission', array(
   'fields' => array(
     'pid' => array(
       'type' => 'serial',
       'not null' => TRUE,

   'rid' => '4',
   'perm' => 'migrate test role 2 test permission, use PHP for settings, administer contact forms, skip comment approval, edit own blog content, edit any blog content, delete own blog content, delete any blog content, create forum content, delete any forum content, delete own forum content, edit any forum content, edit own forum content, administer nodes',
   'tid' => '0',
 ))
 ->execute();
-
 $connection->schema()->createTable('profile_fields', array(
   'fields' => array(
     'fid' => array(
       'type' => 'serial',
       'not null' => TRUE,

   'register' => '0',
   'visibility' => '2',
   'autocomplete' => '0',
   'options' => '',
 ))
+->values(array(
+  'fid' => '17',
+  'title' => 'Number of trees',
+  'name' => 'profile_count_trees',
+  'explanation' => '',
+  'category' => 'Personal information',
+  'page' => '',
+  'type' => 'selection',
+  'weight' => '0',
+  'required' => '0',
+  'register' => '0',
+  'visibility' => '2',
+  'autocomplete' => '0',
+  'options' => "10\r\n20\r\n50\r\n100\r\n1000",
+))
 ->execute();
-
 $connection->schema()->createTable('profile_values', array(
   'fields' => array(
     'fid' => array(
       'type' => 'int',
       'not null' => TRUE,

   'fid' => '15',
   'uid' => '2',
   'value' => '1',
 ))
 ->execute();
-
 $connection->schema()->createTable('role', array(
   'fields' => array(
     'rid' => array(
       'type' => 'serial',
       'not null' => TRUE,

 ->values(array(
   'rid' => '5',
   'name' => 'migrate test role 3 that is longer than thirty two characters',
 ))
 ->execute();
-
 $connection->schema()->createTable('semaphore', array(
   'fields' => array(
     'name' => array(
       'type' => 'varchar',
       'not null' => TRUE,

   'schema_version' => '-1',
   'weight' => '0',
   'info' => 'a:13:{s:4:"name";s:10:"Pushbutton";s:11:"description";s:52:"Tabled, multi-column theme in blue and orange tones.";s:7:"version";s:4:"6.38";s:4:"core";s:3:"6.x";s:6:"engine";s:11:"phptemplate";s:7:"project";s:6:"drupal";s:9:"datestamp";s:10:"1456343372";s:7:"regions";a:5:{s:4:"left";s:12:"Left sidebar";s:5:"right";s:13:"Right sidebar";s:7:"content";s:7:"Content";s:6:"header";s:6:"Header";s:6:"footer";s:6:"Footer";}s:8:"features";a:10:{i:0;s:20:"comment_user_picture";i:1;s:7:"favicon";i:2;s:7:"mission";i:3;s:4:"logo";i:4;s:4:"name";i:5;s:17:"node_user_picture";i:6;s:6:"search";i:7;s:6:"slogan";i:8;s:13:"primary_links";i:9;s:15:"secondary_links";}s:11:"stylesheets";a:1:{s:3:"all";a:1:{s:9:"style.css";s:27:"themes/pushbutton/style.css";}}s:7:"scripts";a:1:{s:9:"script.js";s:27:"themes/pushbutton/script.js";}s:10:"screenshot";s:32:"themes/pushbutton/screenshot.png";s:3:"php";s:5:"4.3.5";}',
 ))
 ->execute();
-
 $connection->schema()->createTable('term_data', array(
   'fields' => array(
     'tid' => array(
       'type' => 'serial',
       'not null' => TRUE,

   'description' => '',
   'weight' => '0',
   'language' => '',
   'trid' => '0',
 ))
+->values(array(
+  'tid' => '9',
+  'vid' => '3',
+  'name' => 'fr - term 4 of vocabulary 3',
+  'description' => '',
+  'weight' => '0',
+  'language' => 'fr',
+  'trid' => '1',
+))
+->values(array(
+  'tid' => '10',
+  'vid' => '3',
+  'name' => 'zu - term 4 of vocabulary 3',
+  'description' => '',
+  'weight' => '0',
+  'language' => 'zu',
+  'trid' => '1',
+))
+->values(array(
+  'tid' => '11',
+  'vid' => '3',
+  'name' => 'term 7 of vocabulary 3',
+  'description' => '',
+  'weight' => '0',
+  'language' => 'en',
+  'trid' => '2',
+))
+->values(array(
+  'tid' => '12',
+  'vid' => '3',
+  'name' => 'fr - term 7 of vocabulary 3',
+  'description' => '',
+  'weight' => '0',
+  'language' => 'fr',
+  'trid' => '2',
+))
+->values(array(
+  'tid' => '13',
+  'vid' => '3',
+  'name' => 'zu - term 7 of vocabulary 3',
+  'description' => '',
+  'weight' => '0',
+  'language' => 'zu',
+  'trid' => '2',
+))
+->values(array(
+  'tid' => '14',
+  'vid' => '5',
+  'name' => 'Talos IV',
+  'description' => 'The home of Captain Christopher Pike.',
+  'weight' => '0',
+  'language' => '',
+  'trid' => '0',
+))
+->values(array(
+  'tid' => '15',
+  'vid' => '5',
+  'name' => 'Vulcan',
+  'description' => '',
+  'weight' => '0',
+  'language' => '',
+  'trid' => '0',
+))
 ->execute();
-
 $connection->schema()->createTable('term_hierarchy', array(
   'fields' => array(
     'tid' => array(
       'type' => 'int',
       'not null' => TRUE,

 ->values(array(
   'tid' => '8',
   'parent' => '0',
 ))
 ->values(array(
+  'tid' => '9',
+  'parent' => '0',
+))
+->values(array(
+  'tid' => '10',
+  'parent' => '0',
+))
+->values(array(
+  'tid' => '11',
+  'parent' => '0',
+))
+->values(array(
+  'tid' => '12',
+  'parent' => '0',
+))
+->values(array(
+  'tid' => '13',
+  'parent' => '0',
+))
+->values(array(
+  'tid' => '14',
+  'parent' => '0',
+))
+->values(array(
+  'tid' => '15',
+  'parent' => '0',
+))
+->values(array(
   'tid' => '3',
   'parent' => '2',
 ))
 ->values(array(
   'tid' => '5',

 ->values(array(
   'tid' => '6',
   'parent' => '5',
 ))
 ->execute();
-
 $connection->schema()->createTable('term_node', array(
   'fields' => array(
     'nid' => array(
       'type' => 'int',
       'not null' => TRUE,

   'vid' => '3',
   'tid' => '3',
 ))
 ->values(array(
   'nid' => '1',
-  'vid' => '2',
+  'vid' => '2001',
   'tid' => '4',
 ))
 ->values(array(
   'nid' => '1',
-  'vid' => '2',
+  'vid' => '2001',
   'tid' => '5',
 ))
 ->values(array(
   'nid' => '19',
   'vid' => '22',
   'tid' => '8',
 ))
 ->execute();
-
 $connection->schema()->createTable('term_relation', array(
   'fields' => array(
     'trid' => array(
       'type' => 'serial',
       'not null' => TRUE,

   'description' => 'file 12-15-3',
   'list' => '0',
   'weight' => '0',
 ))
 ->execute();
-
 $connection->schema()->createTable('url_alias', array(
   'fields' => array(
     'pid' => array(
       'type' => 'serial',
       'not null' => TRUE,

   'src' => 'admin',
   'dst' => 'source-noslash',
   'language' => '',
 ))
 ->execute();
-
 $connection->schema()->createTable('users', array(
   'fields' => array(
     'uid' => array(
       'type' => 'serial',
       'not null' => TRUE,

   'pass_plain' => 'terry.saraniti',
   'expected_timezone' => NULL,
   'timezone_id' => '0',
 ))
 ->execute();
-
 $connection->schema()->createTable('users_roles', array(
   'fields' => array(
     'uid' => array(
       'type' => 'int',
       'not null' => TRUE,

 ->values(array(
   'uid' => '16',
   'rid' => '5',
 ))
 ->execute();
-
 $connection->schema()->createTable('variable', array(
   'fields' => array(
     'name' => array(
       'type' => 'varchar',
       'not null' => TRUE,

   'name' => 'i18nstrings_allowed_formats',
   'value' => 'a:2:{i:0;i:1;i:1;i:2;}',
 ))
 ->values(array(
   'name' => 'i18ntaxonomy_vocabulary',
-  'value' => 'a:2:{i:1;s:1:"3";i:2;s:1:"2";}',
+  'value' => 'a:4:{i:1;s:1:"3";i:2;s:1:"2";i:3;s:1:"3";i:5;s:1:"1";}',
 ))
 ->values(array(
   'name' => 'i18n_lock_node_article',
   'value' => 'i:1;',
 ))

 ->values(array(
   'name' => 'user_signatures',
   'value' => 's:1:"1";',
 ))
 ->execute();
-
 $connection->schema()->createTable('vocabulary', array(
   'fields' => array(
     'vid' => array(
       'type' => 'serial',
       'not null' => TRUE,

   'module' => 'taxonomy',
   'weight' => '0',
   'language' => '',
 ))
 ->execute();
-
 $connection->schema()->createTable('vocabulary_node_types', array(
   'fields' => array(
     'vid' => array(
       'type' => 'int',
       'not null' => TRUE,

 ->values(array(
   'vid' => '3',
   'type' => 'story',
 ))
 ->execute();
-
 $connection->schema()->createTable('watchdog', array(
   'fields' => array(
     'wid' => array(
       'type' => 'serial',
       'not null' => TRUE,