X-Git-Url: http://www.aleph1.co.uk/gitweb/?p=yaffs-website;a=blobdiff_plain;f=web%2Fcore%2Fmodules%2Fmigrate_drupal%2Ftests%2Ffixtures%2Fdrupal6.php;fp=web%2Fcore%2Fmodules%2Fmigrate_drupal%2Ftests%2Ffixtures%2Fdrupal6.php;h=185a7b6a78d9446bab1dfc09866f012778241229;hp=059ba786991fdc4befac1893239129f56a9851c3;hb=0bf8d09d2542548982e81a441b1f16e75873a04f;hpb=74df008bdbb3a11eeea356744f39b802369bda3c diff --git a/web/core/modules/migrate_drupal/tests/fixtures/drupal6.php b/web/core/modules/migrate_drupal/tests/fixtures/drupal6.php index 059ba7869..185a7b6a7 100644 --- a/web/core/modules/migrate_drupal/tests/fixtures/drupal6.php +++ b/web/core/modules/migrate_drupal/tests/fixtures/drupal6.php @@ -746,7 +746,7 @@ $connection->insert('blocks') 'throttle' => '0', 'visibility' => '0', 'pages' => '', - 'title' => '', + 'title' => 'zu - Navigation', 'cache' => '-1', )) ->values(array( @@ -1990,6 +1990,38 @@ $connection->insert('comments') '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( @@ -2168,6 +2200,18 @@ $connection->insert('content_field_company') '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', @@ -2716,6 +2760,30 @@ $connection->insert('content_node_field') 'active' => '1', 'locked' => '0', )) +->values(array( + 'field_name' => 'field_company_2', + 'type' => 'nodereference', + 'global_settings' => 'a:1:{s:19:"referenceable_types";a:10:{s:7:"company";s:7:"company";s:7:"article";i:0;s:8:"employee";i:0;s:5:"forum";i:0;s:10:"test_event";i:0;s:9:"test_page";i:0;s:11:"test_planet";i:0;s:10:"test_story";i:0;s:7:"sponsor";i:0;s:5:"story";i:0;}}', + 'required' => '0', + 'multiple' => '0', + 'db_storage' => '1', + 'module' => 'nodereference', + 'db_columns' => 'a:1:{s:3:"nid";a:4:{s:4:"type";s:3:"int";s:8:"unsigned";b:1;s:8:"not null";b:0;s:5:"index";b:1;}}', + 'active' => '1', + 'locked' => '0', +)) +->values(array( + 'field_name' => 'field_company_3', + 'type' => 'nodereference', + 'global_settings' => 'a:1:{s:19:"referenceable_types";a:10:{s:7:"company";s:7:"company";s:7:"article";i:0;s:8:"employee";i:0;s:5:"forum";i:0;s:10:"test_event";i:0;s:9:"test_page";i:0;s:11:"test_planet";i:0;s:10:"test_story";i:0;s:7:"sponsor";i:0;s:5:"story";i:0;}}', + 'required' => '0', + 'multiple' => '0', + 'db_storage' => '1', + 'module' => 'nodereference', + 'db_columns' => 'a:1:{s:3:"nid";a:4:{s:4:"type";s:3:"int";s:8:"unsigned";b:1;s:8:"not null";b:0;s:5:"index";b:1;}}', + 'active' => '1', + 'locked' => '0', +)) ->values(array( 'field_name' => 'field_multivalue', 'type' => 'number_decimal', @@ -2728,6 +2796,30 @@ $connection->insert('content_node_field') 'active' => '1', 'locked' => '0', )) +->values(array( + 'field_name' => 'field_reference', + 'type' => 'nodereference', + 'global_settings' => 'a:1:{s:19:"referenceable_types";a:11:{s:4:"page";s:4:"page";s:7:"article";i:0;s:7:"company";i:0;s:8:"employee";i:0;s:5:"forum";i:0;s:10:"test_event";i:0;s:9:"test_page";i:0;s:11:"test_planet";i:0;s:10:"test_story";i:0;s:7:"sponsor";i:0;s:5:"story";i:0;}}', + 'required' => '0', + 'multiple' => '0', + 'db_storage' => '1', + 'module' => 'nodereference', + 'db_columns' => 'a:1:{s:3:"nid";a:4:{s:4:"type";s:3:"int";s:8:"unsigned";b:1;s:8:"not null";b:0;s:5:"index";b:1;}}', + 'active' => '1', + 'locked' => '0', +)) +->values(array( + 'field_name' => 'field_reference_2', + 'type' => 'nodereference', + 'global_settings' => 'a:1:{s:19:"referenceable_types";a:11:{s:4:"page";s:4:"page";s:7:"article";i:0;s:7:"company";i:0;s:8:"employee";i:0;s:5:"forum";i:0;s:10:"test_event";i:0;s:9:"test_page";i:0;s:11:"test_planet";i:0;s:10:"test_story";i:0;s:7:"sponsor";i:0;s:5:"story";i:0;}}', + 'required' => '0', + 'multiple' => '0', + 'db_storage' => '1', + 'module' => 'nodereference', + 'db_columns' => 'a:1:{s:3:"nid";a:4:{s:4:"type";s:3:"int";s:8:"unsigned";b:1;s:8:"not null";b:0;s:5:"index";b:1;}}', + 'active' => '1', + 'locked' => '0', +)) ->values(array( 'field_name' => 'field_test', 'type' => 'text', @@ -2920,6 +3012,18 @@ $connection->insert('content_node_field') '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', @@ -3074,6 +3178,30 @@ $connection->insert('content_node_field_instance') 'widget_module' => 'nodereference', 'widget_active' => '1', )) +->values(array( + 'field_name' => 'field_company_2', + 'type_name' => 'employee', + 'weight' => '33', + 'label' => 'Company 2', + 'widget_type' => 'nodereference_buttons', + 'widget_settings' => 'a:4:{s:18:"autocomplete_match";s:8:"contains";s:4:"size";i:60;s:13:"default_value";a:1:{i:0;a:1:{s:3:"nid";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' => 'nodereference', + 'widget_active' => '1', +)) +->values(array( + 'field_name' => 'field_company_3', + 'type_name' => 'employee', + 'weight' => '34', + 'label' => 'Company 3', + 'widget_type' => 'nodereference_autocomplete', + 'widget_settings' => 'a:4:{s:18:"autocomplete_match";s:8:"contains";s:4:"size";s:2:"60";s:13:"default_value";a:1:{i:0;a:2:{s:3:"nid";N;s:14:"_error_element";s:50:"default_value_widget][field_company_3][0][nid][nid";}}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' => 'nodereference', + 'widget_active' => '1', +)) ->values(array( 'field_name' => 'field_multivalue', 'type_name' => 'test_planet', @@ -3086,6 +3214,30 @@ $connection->insert('content_node_field_instance') 'widget_module' => 'number', 'widget_active' => '1', )) +->values(array( + 'field_name' => 'field_reference', + 'type_name' => 'page', + 'weight' => '31', + 'label' => 'Reference', + 'widget_type' => 'nodereference_select', + 'widget_settings' => 'a:4:{s:18:"autocomplete_match";s:8:"contains";s:4:"size";i:60;s:13:"default_value";a:1:{i:0;a:1:{s:3:"nid";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' => 'nodereference', + 'widget_active' => '1', +)) +->values(array( + 'field_name' => 'field_reference_2', + 'type_name' => 'page', + 'weight' => '32', + 'label' => 'Reference', + 'widget_type' => 'nodereference_select', + 'widget_settings' => 'a:4:{s:18:"autocomplete_match";s:8:"contains";s:4:"size";i:60;s:13:"default_value";a:1:{i:0;a:1:{s:3:"nid";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' => 'nodereference', + 'widget_active' => '1', +)) ->values(array( 'field_name' => 'field_test', 'type_name' => 'story', @@ -3290,6 +3442,18 @@ $connection->insert('content_node_field_instance') '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', @@ -3374,6 +3538,18 @@ $connection->schema()->createTable('content_type_employee', array( 'size' => 'normal', 'unsigned' => TRUE, ), + 'field_company_2_nid' => array( + 'type' => 'int', + 'not null' => FALSE, + 'size' => 'normal', + 'unsigned' => TRUE, + ), + 'field_company_3_nid' => array( + 'type' => 'int', + 'not null' => FALSE, + 'size' => 'normal', + 'unsigned' => TRUE, + ), ), 'primary key' => array( 'vid', @@ -3385,6 +3561,12 @@ $connection->schema()->createTable('content_type_employee', array( 'field_commander_uid' => array( 'field_commander_uid', ), + 'field_company_2_nid' => array( + 'field_company_2_nid', + ), + 'field_company_3_nid' => array( + 'field_company_3_nid', + ), ), 'mysql_character_set' => 'utf8', )); @@ -3394,11 +3576,29 @@ $connection->insert('content_type_employee') 'vid', 'nid', 'field_commander_uid', + 'field_company_2_nid', + 'field_company_3_nid', )) ->values(array( 'vid' => '21', '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(); @@ -3423,13 +3623,71 @@ $connection->schema()->createTable('content_type_page', array( 'not null' => FALSE, 'size' => 'normal', ), + 'field_reference_nid' => array( + 'type' => 'int', + 'not null' => FALSE, + 'size' => 'normal', + 'unsigned' => TRUE, + ), + 'field_reference_2_nid' => array( + 'type' => 'int', + 'not null' => FALSE, + 'size' => 'normal', + 'unsigned' => TRUE, + ), ), 'primary key' => array( 'vid', ), + 'indexes' => array( + 'field_reference_nid' => array( + 'field_reference_nid', + ), + 'field_reference_2_nid' => array( + 'field_reference_2_nid', + ), + ), 'mysql_character_set' => 'utf8', )); +$connection->insert('content_type_page') +->fields(array( + 'vid', + 'nid', + 'field_text_field_value', + 'field_reference_nid', + 'field_reference_2_nid', +)) +->values(array( + 'vid' => '13', + 'nid' => '10', + 'field_text_field_value' => NULL, + 'field_reference_nid' => '13', + 'field_reference_2_nid' => '13', +)) +->values(array( + 'vid' => '14', + 'nid' => '11', + 'field_text_field_value' => NULL, + 'field_reference_nid' => '20', + 'field_reference_2_nid' => '20', +)) +->values(array( + 'vid' => '16', + 'nid' => '13', + 'field_text_field_value' => NULL, + 'field_reference_nid' => '10', + 'field_reference_2_nid' => '10', +)) +->values(array( + 'vid' => '23', + 'nid' => '20', + '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( @@ -3588,6 +3846,11 @@ $connection->schema()->createTable('content_type_story', array( 'not null' => FALSE, 'length' => '100', ), + 'field_test_string_selectlist_value' => array( + 'type' => 'text', + 'not null' => FALSE, + 'size' => 'big', + ), ), 'primary key' => array( 'vid', @@ -3631,6 +3894,7 @@ $connection->insert('content_type_story') 'field_test_text_single_checkbox2_value', 'field_test_datestamp_value2', 'field_test_datetime_value2', + 'field_test_string_selectlist_value', )) ->values(array( 'nid' => '1', @@ -3662,6 +3926,7 @@ $connection->insert('content_type_story') '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', @@ -3693,6 +3958,7 @@ $connection->insert('content_type_story') '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', @@ -3724,6 +3990,7 @@ $connection->insert('content_type_story') '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', @@ -3755,6 +4022,7 @@ $connection->insert('content_type_story') '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', @@ -3786,6 +4054,7 @@ $connection->insert('content_type_story') '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(); @@ -8490,6 +8759,16 @@ $connection->insert('history') '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( @@ -8530,6 +8809,30 @@ $connection->schema()->createTable('i18n_blocks', array( '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( @@ -8626,7 +8929,7 @@ $connection->insert('i18n_strings') )) ->values(array( 'lid' => '509', - 'objectid' => 'profile_sell_address', + 'objectid' => 'profile_sell_Address', 'type' => 'field', 'property' => 'title', 'objectindex' => '0', @@ -8634,7 +8937,7 @@ $connection->insert('i18n_strings') )) ->values(array( 'lid' => '510', - 'objectid' => 'profile_sell_address', + 'objectid' => 'profile_sell_Address', 'type' => 'field', 'property' => 'explanation', 'objectindex' => '0', @@ -8714,7 +9017,7 @@ $connection->insert('i18n_strings') )) ->values(array( 'lid' => '520', - 'objectid' => 'profile_love_migrations', + 'objectid' => 'profile_really_really_love_migrations', 'type' => 'field', 'property' => 'title', 'objectindex' => '0', @@ -8722,7 +9025,7 @@ $connection->insert('i18n_strings') )) ->values(array( 'lid' => '521', - 'objectid' => 'profile_love_migrations', + 'objectid' => 'profile_really_really_love_migrations', 'type' => 'field', 'property' => 'explanation', 'objectindex' => '0', @@ -9640,6 +9943,134 @@ $connection->insert('i18n_strings') 'objectindex' => '7', 'format' => '0', )) +->values(array( + 'lid' => '1674', + 'objectid' => '463', + 'type' => 'item', + 'property' => 'title', + 'objectindex' => '463', + 'format' => '0', +)) +->values(array( + 'lid' => '1675', + 'objectid' => '463', + 'type' => 'item', + 'property' => 'description', + 'objectindex' => '463', + 'format' => '0', +)) +->values(array( + 'lid' => '1676', + 'objectid' => '138', + 'type' => 'item', + 'property' => 'title', + 'objectindex' => '138', + 'format' => '0', +)) +->values(array( + 'lid' => '1677', + 'objectid' => '138', + 'type' => 'item', + 'property' => 'description', + 'objectindex' => '138', + 'format' => '0', +)) +->values(array( + 'lid' => '1678', + 'objectid' => 'profile_really_really_love_migrating', + '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', +)) ->execute(); $connection->schema()->createTable('i18n_variable', array( @@ -13960,14 +14391,14 @@ $connection->insert('locales_source') )) ->values(array( 'lid' => '509', - 'location' => 'field:profile_sell_address:title', + 'location' => 'field:profile_sell_Address:title', 'textgroup' => 'profile', 'source' => 'Sell your email address?', 'version' => '1', )) ->values(array( 'lid' => '510', - 'location' => 'field:profile_sell_address:explanation', + 'location' => 'field:profile_sell_Address:explanation', 'textgroup' => 'profile', 'source' => "If you check this box, we'll sell your address to spammers to help line the pockets of our shareholders. Thanks!", 'version' => '1', @@ -14037,14 +14468,14 @@ $connection->insert('locales_source') )) ->values(array( 'lid' => '520', - 'location' => 'field:profile_love_migrations:title', + 'location' => 'field:profile_really_really_love_migrations:title', 'textgroup' => 'profile', - 'source' => 'I love migrations', + 'source' => 'I really, really, really love migrations', 'version' => '1', )) ->values(array( 'lid' => '521', - 'location' => 'field:profile_love_migrations:explanation', + 'location' => 'field:profile_really_really_love_migrations:explanation', 'textgroup' => 'profile', 'source' => 'If you check this box, you love migrations.', 'version' => '1', @@ -14770,13 +15201,6 @@ $connection->insert('locales_source') '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', @@ -22106,6 +22530,118 @@ $connection->insert('locales_source') 'source' => 'Forums', 'version' => '1', )) +->values(array( + 'lid' => '1674', + 'location' => 'item:463:title', + 'textgroup' => 'menu', + 'source' => 'fr - Test 1', + 'version' => '1', +)) +->values(array( + 'lid' => '1675', + 'location' => 'item:463:description', + 'textgroup' => 'menu', + 'source' => 'fr - Test menu link 1', + 'version' => '1', +)) +->values(array( + 'lid' => '1676', + 'location' => 'item:138:title', + 'textgroup' => 'menu', + 'source' => 'Test 1', + 'version' => '1', +)) +->values(array( + 'lid' => '1677', + 'location' => 'item:138:description', + 'textgroup' => 'menu', + 'source' => 'Test menu link 1', + 'version' => '1', +)) +->values(array( + 'lid' => '1678', + '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', +)) ->execute(); $connection->schema()->createTable('locales_target', array( @@ -26284,7 +26820,7 @@ $connection->insert('locales_target') 'language' => 'fr', 'plid' => '0', 'plural' => '0', - 'i18n_status' => '0', + 'i18n_status' => '1', )) ->values(array( 'lid' => '521', @@ -26712,7 +27248,7 @@ $connection->insert('locales_target') )) ->values(array( 'lid' => '575', - 'translation' => 'fr - An example text field.', + 'translation' => 'fr - An example text field.', 'language' => 'fr', 'plid' => '0', 'plural' => '0', @@ -26824,7 +27360,7 @@ $connection->insert('locales_target') )) ->values(array( 'lid' => '589', - 'translation' => 'fr - An example image field.', + 'translation' => 'fr - An example file field.', 'language' => 'fr', 'plid' => '0', 'plural' => '0', @@ -26942,6 +27478,14 @@ $connection->insert('locales_target') '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', @@ -26958,6 +27502,22 @@ $connection->insert('locales_target') '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', @@ -27054,14 +27614,6 @@ $connection->insert('locales_target') 'plural' => '0', 'i18n_status' => '0', )) -->values(array( - 'lid' => '626', - 'translation' => 'fr - Text Single Checkbox Field', - 'language' => 'fr', - 'plid' => '0', - 'plural' => '0', - 'i18n_status' => '0', -)) ->values(array( 'lid' => '627', 'translation' => 'fr - An example text field using a single on/off checkbox.', @@ -27150,6 +27702,22 @@ $connection->insert('locales_target') 'plural' => '0', 'i18n_status' => '0', )) +->values(array( + 'lid' => '1678', + 'translation' => 'fr - I really, really, really love migrating ', + 'language' => 'fr', + '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' => '66', 'translation' => 'zu - CCK - Aucune Intégration aux Vues', @@ -27230,6 +27798,22 @@ $connection->insert('locales_target') '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', @@ -27246,6 +27830,22 @@ $connection->insert('locales_target') 'plural' => '0', 'i18n_status' => '0', )) +->values(array( + 'lid' => '1690', + 'translation' => 'Okumnyama', + 'language' => 'zu', + 'plid' => '0', + 'plural' => '0', + 'i18n_status' => '0', +)) +->values(array( + 'lid' => '1691', + 'translation' => 'Mhlophe', + 'language' => 'zu', + 'plid' => '0', + 'plural' => '0', + 'i18n_status' => '0', +)) ->execute(); $connection->schema()->createTable('menu_custom', array( @@ -27635,7 +28235,7 @@ $connection->insert('menu_links') 'link_path' => 'user/login', 'router_path' => 'user/login', 'link_title' => 'Test 1', - 'options' => 'a:1:{s:10:"attributes";a:1:{s:5:"title";s:16:"Test menu link 1";}}', + 'options' => 'a:2:{s:10:"attributes";a:1:{s:5:"title";s:16:"Test menu link 1";}s:8:"langcode";s:2:"en";}', 'module' => 'menu', 'hidden' => '0', 'external' => '0', @@ -33649,6 +34249,141 @@ $connection->insert('menu_links') 'p9' => '0', 'updated' => '0', )) +->values(array( + 'menu_name' => 'primary-links', + 'mlid' => '459', + 'plid' => '0', + 'link_path' => 'node/10', + 'router_path' => 'node/%', + 'link_title' => 'The Real McCoy', + 'options' => 'a:2:{s:10:"attributes";a:1:{s:5:"title";s:0:"";}s:5:"alter";b:1;}', + 'module' => 'menu', + 'hidden' => '0', + 'external' => '0', + 'has_children' => '0', + 'expanded' => '0', + 'weight' => '0', + 'depth' => '1', + 'customized' => '1', + 'p1' => '459', + 'p2' => '0', + 'p3' => '0', + 'p4' => '0', + 'p5' => '0', + 'p6' => '0', + 'p7' => '0', + 'p8' => '0', + 'p9' => '0', + 'updated' => '0', +)) +->values(array( + 'menu_name' => 'primary-links', + 'mlid' => '460', + 'plid' => '0', + 'link_path' => 'node/11', + 'router_path' => 'node/%', + 'link_title' => 'Le Vrai McCoy', + 'options' => 'a:2:{s:10:"attributes";a:1:{s:5:"title";s:0:"";}s:5:"alter";b:1;}', + 'module' => 'menu', + 'hidden' => '0', + 'external' => '0', + 'has_children' => '0', + 'expanded' => '0', + 'weight' => '0', + 'depth' => '1', + 'customized' => '1', + 'p1' => '460', + 'p2' => '0', + 'p3' => '0', + 'p4' => '0', + 'p5' => '0', + 'p6' => '0', + 'p7' => '0', + 'p8' => '0', + 'p9' => '0', + 'updated' => '0', +)) +->values(array( + 'menu_name' => 'primary-links', + 'mlid' => '461', + 'plid' => '0', + 'link_path' => 'node/12', + 'router_path' => 'node/%', + 'link_title' => 'Abantu zulu', + 'options' => 'a:2:{s:10:"attributes";a:1:{s:5:"title";s:0:"";}s:5:"alter";b:1;}', + 'module' => 'menu', + 'hidden' => '0', + 'external' => '0', + 'has_children' => '0', + 'expanded' => '0', + 'weight' => '0', + 'depth' => '1', + 'customized' => '1', + 'p1' => '461', + 'p2' => '0', + 'p3' => '0', + 'p4' => '0', + 'p5' => '0', + 'p6' => '0', + 'p7' => '0', + 'p8' => '0', + 'p9' => '0', + 'updated' => '0', +)) +->values(array( + 'menu_name' => 'primary-links', + 'mlid' => '462', + 'plid' => '0', + 'link_path' => 'node/13', + 'router_path' => 'node/%', + 'link_title' => 'The Zulu People', + 'options' => 'a:2:{s:10:"attributes";a:1:{s:5:"title";s:0:"";}s:5:"alter";b:1;}', + 'module' => 'menu', + 'hidden' => '0', + 'external' => '0', + 'has_children' => '0', + 'expanded' => '0', + 'weight' => '0', + 'depth' => '1', + 'customized' => '1', + 'p1' => '462', + 'p2' => '0', + 'p3' => '0', + 'p4' => '0', + 'p5' => '0', + 'p6' => '0', + 'p7' => '0', + 'p8' => '0', + 'p9' => '0', + 'updated' => '0', +)) +->values(array( + 'menu_name' => 'secondary-links', + 'mlid' => '463', + 'plid' => '139', + 'link_path' => 'user/login', + 'router_path' => 'user/login', + 'link_title' => 'fr - Test 1', + 'options' => 'a:3:{s:10:"attributes";a:1:{s:5:"title";s:21:"fr - Test menu link 1";}s:8:"langcode";s:2:"fr";s:5:"alter";b:1;}', + 'module' => 'menu', + 'hidden' => '0', + 'external' => '0', + 'has_children' => '0', + 'expanded' => '0', + 'weight' => '-49', + 'depth' => '2', + 'customized' => '1', + 'p1' => '139', + 'p2' => '459', + 'p3' => '0', + 'p4' => '0', + 'p5' => '0', + 'p6' => '0', + 'p7' => '0', + 'p8' => '0', + 'p9' => '0', + 'updated' => '0', +)) ->execute(); $connection->schema()->createTable('menu_router', array( @@ -43283,6 +44018,57 @@ $connection->insert('node') 'tnid' => '0', 'translate' => '0', )) +->values(array( + 'nid' => '20', + 'vid' => '23', + 'type' => 'page', + 'language' => 'fr', + 'title' => 'Le peuple zoulou', + 'uid' => '1', + 'status' => '1', + 'created' => '1520613038', + 'changed' => '1520613305', + 'comment' => '0', + 'promote' => '1', + '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( @@ -43489,6 +44275,20 @@ $connection->insert('node_comment_statistics') '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( @@ -43564,6 +44364,30 @@ $connection->insert('node_counter') 'daycount' => '1', 'timestamp' => '1478755314', )) +->values(array( + 'nid' => '10', + 'totalcount' => '5', + 'daycount' => '1', + 'timestamp' => '1521137459', +)) +->values(array( + 'nid' => '11', + 'totalcount' => '3', + 'daycount' => '1', + 'timestamp' => '1521137463', +)) +->values(array( + 'nid' => '12', + 'totalcount' => '3', + 'daycount' => '0', + 'timestamp' => '1521137469', +)) +->values(array( + 'nid' => '13', + 'totalcount' => '2', + 'daycount' => '1', + 'timestamp' => '1521137470', +)) ->values(array( 'nid' => '14', 'totalcount' => '1', @@ -43600,6 +44424,18 @@ $connection->insert('node_counter') '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( @@ -43686,17 +44522,6 @@ $connection->insert('node_revisions') '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', @@ -43917,6 +44742,50 @@ $connection->insert('node_revisions') 'timestamp' => '1501955771', 'format' => '1', )) +->values(array( + 'nid' => '20', + 'vid' => '23', + 'uid' => '1', + 'title' => 'Le peuple zoulou', + 'body' => 'Le peuple zoulou.', + '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( @@ -44183,7 +45052,7 @@ $connection->insert('node_type') 'custom' => '1', 'modified' => '1', 'locked' => '0', - 'orig_type' => 'page', + 'orig_type' => 'test_page', )) ->values(array( 'type' => 'test_planet', @@ -44414,7 +45283,7 @@ $connection->insert('profile_fields') ->values(array( 'fid' => '10', 'title' => 'Sell your email address?', - 'name' => 'profile_sell_address', + 'name' => 'profile_sell_Address', 'explanation' => "If you check this box, we'll sell your address to spammers to help line the pockets of our shareholders. Thanks!", 'category' => 'Communication preferences', 'page' => 'People who want us to sell their address', @@ -44488,8 +45357,8 @@ $connection->insert('profile_fields') )) ->values(array( 'fid' => '15', - 'title' => 'I love migrations', - 'name' => 'profile_love_migrations', + 'title' => 'I really, really, really love migrations', + 'name' => 'profile_really_really_love_migrations', 'explanation' => 'If you check this box, you love migrations.', 'category' => 'Personal information', 'page' => 'People who love migrations', @@ -44501,6 +45370,21 @@ $connection->insert('profile_fields') 'autocomplete' => '0', 'options' => '', )) +->values(array( + 'fid' => '16', + 'title' => 'I really, really, really love migrating', + 'name' => 'profile_really_really_love_migrating', + 'explanation' => '', + 'category' => 'Personal information', + 'page' => '', + 'type' => 'checkbox', + 'weight' => '0', + 'required' => '0', + 'register' => '0', + 'visibility' => '2', + 'autocomplete' => '0', + 'options' => '', +)) ->execute(); $connection->schema()->createTable('profile_values', array( @@ -44713,6 +45597,11 @@ $connection->insert('profile_values') 'uid' => '17', 'value' => 'a:3:{s:5:"month";s:2:"12";s:3:"day";s:2:"18";s:4:"year";s:4:"1942";}', )) +->values(array( + 'fid' => '15', + 'uid' => '2', + 'value' => '1', +)) ->execute(); $connection->schema()->createTable('role', array( @@ -46330,12 +47219,12 @@ $connection->insert('term_node') )) ->values(array( 'nid' => '1', - 'vid' => '2', + 'vid' => '2001', 'tid' => '4', )) ->values(array( 'nid' => '1', - 'vid' => '2', + 'vid' => '2001', 'tid' => '5', )) ->values(array( @@ -47851,7 +48740,7 @@ $connection->insert('variable') )) ->values(array( 'name' => 'i18ntaxonomy_vocabulary', - 'value' => 'a:2:{i:1;s:1:"3";i:2;s:1:"2";}', + 'value' => 'a:3:{i:1;s:1:"3";i:2;s:1:"2";i:3;s:1:"1";}', )) ->values(array( 'name' => 'i18n_lock_node_article',