databaseType() === 'mysql') { $sql_mode = $connection->query("SELECT @@sql_mode;")->fetchField(); $connection->query("SET sql_mode = '$sql_mode,NO_AUTO_VALUE_ON_ZERO'"); } $connection->schema()->createTable('actions', [ 'fields' => [ 'aid' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '255', 'default' => '0', ], 'type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'callback' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '255', 'default' => '', ], 'parameters' => [ 'type' => 'blob', 'not null' => TRUE, 'size' => 'normal', ], 'label' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '255', 'default' => '0', ], ], 'primary key' => [ 'aid', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->insert('actions') ->fields([ 'aid', 'type', 'callback', 'parameters', 'label', ]) ->values([ 'aid' => '2', 'type' => 'comment', 'callback' => 'comment_unpublish_by_keyword_action', 'parameters' => 'a:1:{s:8:"keywords";a:1:{i:0;s:6:"drupal";}}', 'label' => 'Unpublish comment containing keyword(s)', ]) ->values([ 'aid' => '3', 'type' => 'node', 'callback' => 'node_assign_owner_action', 'parameters' => 'a:1:{s:9:"owner_uid";s:1:"2";}', 'label' => 'Change the author of content', ]) ->values([ 'aid' => '4', 'type' => 'node', 'callback' => 'node_unpublish_by_keyword_action', 'parameters' => 'a:1:{s:8:"keywords";a:1:{i:0;s:6:"drupal";}}', 'label' => 'Unpublish content containing keyword(s)', ]) ->values([ 'aid' => '5', 'type' => 'system', 'callback' => 'system_message_action', 'parameters' => 'a:1:{s:7:"message";s:21:"Drupal migration test";}', 'label' => 'Display a message to the user', ]) ->values([ 'aid' => '6', 'type' => 'system', 'callback' => 'system_send_email_action', 'parameters' => 'a:3:{s:9:"recipient";s:16:"test@example.com";s:7:"subject";s:21:"Drupal migration test";s:7:"message";s:21:"Drupal migration test";}', 'label' => 'Send e-mail', ]) ->values([ 'aid' => '7', 'type' => 'system', 'callback' => 'system_goto_action', 'parameters' => 'a:1:{s:3:"url";s:22:"https://www.drupal.org";}', 'label' => 'Redirect to URL', ]) ->values([ 'aid' => 'comment_publish_action', 'type' => 'comment', 'callback' => 'comment_publish_action', 'parameters' => '', 'label' => 'Publish comment', ]) ->values([ 'aid' => 'comment_save_action', 'type' => 'comment', 'callback' => 'comment_save_action', 'parameters' => '', 'label' => 'Save comment', ]) ->values([ 'aid' => 'comment_unpublish_action', 'type' => 'comment', 'callback' => 'comment_unpublish_action', 'parameters' => '', 'label' => 'Unpublish comment', ]) ->values([ 'aid' => 'node_make_sticky_action', 'type' => 'node', 'callback' => 'node_make_sticky_action', 'parameters' => '', 'label' => 'Make content sticky', ]) ->values([ 'aid' => 'node_make_unsticky_action', 'type' => 'node', 'callback' => 'node_make_unsticky_action', 'parameters' => '', 'label' => 'Make content unsticky', ]) ->values([ 'aid' => 'node_promote_action', 'type' => 'node', 'callback' => 'node_promote_action', 'parameters' => '', 'label' => 'Promote content to front page', ]) ->values([ 'aid' => 'node_publish_action', 'type' => 'node', 'callback' => 'node_publish_action', 'parameters' => '', 'label' => 'Publish content', ]) ->values([ 'aid' => 'node_save_action', 'type' => 'node', 'callback' => 'node_save_action', 'parameters' => '', 'label' => 'Save content', ]) ->values([ 'aid' => 'node_unpromote_action', 'type' => 'node', 'callback' => 'node_unpromote_action', 'parameters' => '', 'label' => 'Remove content from front page', ]) ->values([ 'aid' => 'node_unpublish_action', 'type' => 'node', 'callback' => 'node_unpublish_action', 'parameters' => '', 'label' => 'Unpublish content', ]) ->values([ 'aid' => 'system_block_ip_action', 'type' => 'user', 'callback' => 'system_block_ip_action', 'parameters' => '', 'label' => 'Ban IP address of current user', ]) ->values([ 'aid' => 'user_block_user_action', 'type' => 'user', 'callback' => 'user_block_user_action', 'parameters' => '', 'label' => 'Block current user', ]) ->execute(); $connection->schema()->createTable('authmap', [ 'fields' => [ 'aid' => [ 'type' => 'serial', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'uid' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'authname' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'module' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], ], 'primary key' => [ 'aid', ], 'indexes' => [ 'uid_module' => [ 'uid', 'module', ], ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('batch', [ 'fields' => [ 'bid' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'token' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '64', ], 'timestamp' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', ], 'batch' => [ 'type' => 'blob', 'not null' => FALSE, 'size' => 'normal', ], ], 'primary key' => [ 'bid', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('block', [ 'fields' => [ 'bid' => [ 'type' => 'serial', 'not null' => TRUE, 'size' => 'normal', ], 'module' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '64', 'default' => '', ], 'delta' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '0', ], 'theme' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '64', 'default' => '', ], 'status' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'weight' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'region' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '64', 'default' => '', ], 'custom' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'visibility' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'pages' => [ 'type' => 'text', 'not null' => TRUE, 'size' => 'normal', ], 'title' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '255', 'default' => '', ], 'cache' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '1', ], 'i18n_mode' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], ], 'primary key' => [ 'bid', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->insert('block') ->fields([ 'bid', 'module', 'delta', 'theme', 'status', 'weight', 'region', 'custom', 'visibility', 'pages', 'title', 'cache', 'i18n_mode', ]) ->values([ 'bid' => '1', 'module' => 'system', 'delta' => 'main', 'theme' => 'bartik', 'status' => '1', 'weight' => '0', 'region' => 'content', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', 'i18n_mode' => '0', ]) ->values([ 'bid' => '2', 'module' => 'search', 'delta' => 'form', 'theme' => 'bartik', 'status' => '1', 'weight' => '-1', 'region' => 'sidebar_first', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', 'i18n_mode' => '0', ]) ->values([ 'bid' => '3', 'module' => 'node', 'delta' => 'recent', 'theme' => 'seven', 'status' => '0', 'weight' => '10', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', 'i18n_mode' => '0', ]) ->values([ 'bid' => '4', 'module' => 'user', 'delta' => 'login', 'theme' => 'bartik', 'status' => '1', 'weight' => '0', 'region' => 'sidebar_first', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => 'User login title', 'cache' => '-1', 'i18n_mode' => '1', ]) ->values([ 'bid' => '5', 'module' => 'system', 'delta' => 'navigation', 'theme' => 'bartik', 'status' => '1', 'weight' => '0', 'region' => 'sidebar_first', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', 'i18n_mode' => '0', ]) ->values([ 'bid' => '6', 'module' => 'system', 'delta' => 'powered-by', 'theme' => 'bartik', 'status' => '1', 'weight' => '10', 'region' => 'footer', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', 'i18n_mode' => '0', ]) ->values([ 'bid' => '7', 'module' => 'system', 'delta' => 'help', 'theme' => 'bartik', 'status' => '1', 'weight' => '0', 'region' => 'help', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', 'i18n_mode' => '0', ]) ->values([ 'bid' => '8', 'module' => 'system', 'delta' => 'main', 'theme' => 'seven', 'status' => '1', 'weight' => '0', 'region' => 'content', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', 'i18n_mode' => '0', ]) ->values([ 'bid' => '9', 'module' => 'system', 'delta' => 'help', 'theme' => 'seven', 'status' => '1', 'weight' => '0', 'region' => 'help', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', 'i18n_mode' => '0', ]) ->values([ 'bid' => '10', 'module' => 'user', 'delta' => 'login', 'theme' => 'seven', 'status' => '1', 'weight' => '10', 'region' => 'content', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => 'User login title', 'cache' => '-1', 'i18n_mode' => '1', ]) ->values([ 'bid' => '11', 'module' => 'user', 'delta' => 'new', 'theme' => 'seven', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', 'i18n_mode' => '0', ]) ->values([ 'bid' => '12', 'module' => 'search', 'delta' => 'form', 'theme' => 'seven', 'status' => '0', 'weight' => '-10', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', 'i18n_mode' => '0', ]) ->values([ 'bid' => '13', 'module' => 'comment', 'delta' => 'recent', 'theme' => 'bartik', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '1', 'i18n_mode' => '0', ]) ->values([ 'bid' => '14', 'module' => 'node', 'delta' => 'syndicate', 'theme' => 'bartik', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', 'i18n_mode' => '0', ]) ->values([ 'bid' => '15', 'module' => 'node', 'delta' => 'recent', 'theme' => 'bartik', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '1', 'i18n_mode' => '0', ]) ->values([ 'bid' => '16', 'module' => 'shortcut', 'delta' => 'shortcuts', 'theme' => 'bartik', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', 'i18n_mode' => '0', ]) ->values([ 'bid' => '17', 'module' => 'system', 'delta' => 'management', 'theme' => 'bartik', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', 'i18n_mode' => '0', ]) ->values([ 'bid' => '18', 'module' => 'system', 'delta' => 'user-menu', 'theme' => 'bartik', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', 'i18n_mode' => '0', ]) ->values([ 'bid' => '19', 'module' => 'system', 'delta' => 'main-menu', 'theme' => 'bartik', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', 'i18n_mode' => '0', ]) ->values([ 'bid' => '20', 'module' => 'user', 'delta' => 'new', 'theme' => 'bartik', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '1', 'i18n_mode' => '0', ]) ->values([ 'bid' => '21', 'module' => 'user', 'delta' => 'online', 'theme' => 'bartik', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', 'i18n_mode' => '0', ]) ->values([ 'bid' => '22', 'module' => 'comment', 'delta' => 'recent', 'theme' => 'seven', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '1', 'i18n_mode' => '0', ]) ->values([ 'bid' => '23', 'module' => 'node', 'delta' => 'syndicate', 'theme' => 'seven', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', 'i18n_mode' => '0', ]) ->values([ 'bid' => '24', 'module' => 'shortcut', 'delta' => 'shortcuts', 'theme' => 'seven', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', 'i18n_mode' => '0', ]) ->values([ 'bid' => '25', 'module' => 'system', 'delta' => 'powered-by', 'theme' => 'seven', 'status' => '0', 'weight' => '10', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', 'i18n_mode' => '0', ]) ->values([ 'bid' => '26', 'module' => 'system', 'delta' => 'navigation', 'theme' => 'seven', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', 'i18n_mode' => '0', ]) ->values([ 'bid' => '27', 'module' => 'system', 'delta' => 'management', 'theme' => 'seven', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', 'i18n_mode' => '0', ]) ->values([ 'bid' => '28', 'module' => 'system', 'delta' => 'user-menu', 'theme' => 'seven', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', 'i18n_mode' => '0', ]) ->values([ 'bid' => '29', 'module' => 'system', 'delta' => 'main-menu', 'theme' => 'seven', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', 'i18n_mode' => '0', ]) ->values([ 'bid' => '30', 'module' => 'user', 'delta' => 'online', 'theme' => 'seven', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', 'i18n_mode' => '0', ]) ->values([ 'bid' => '33', 'module' => 'locale', 'delta' => 'language', 'theme' => 'bartik', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', 'i18n_mode' => '0', ]) ->values([ 'bid' => '38', 'module' => 'locale', 'delta' => 'language', 'theme' => 'seven', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', 'i18n_mode' => '0', ]) ->values([ 'bid' => '49', 'module' => 'locale', 'delta' => 'language_content', 'theme' => 'bartik', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', 'i18n_mode' => '0', ]) ->values([ 'bid' => '50', 'module' => 'locale', 'delta' => 'language_content', 'theme' => 'seven', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', 'i18n_mode' => '0', ]) ->execute(); $connection->schema()->createTable('block_custom', [ 'fields' => [ 'bid' => [ 'type' => 'serial', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'body' => [ 'type' => 'text', 'not null' => FALSE, 'size' => 'normal', ], 'info' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'format' => [ 'type' => 'varchar', 'not null' => FALSE, 'length' => '255', ], ], 'primary key' => [ 'bid', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('block_node_type', [ 'fields' => [ 'module' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '64', ], 'delta' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', ], 'type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', ], ], 'primary key' => [ 'module', 'delta', 'type', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('block_role', [ 'fields' => [ 'module' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '64', ], 'delta' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', ], 'rid' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], ], 'primary key' => [ 'module', 'delta', 'rid', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('blocked_ips', [ 'fields' => [ 'iid' => [ 'type' => 'serial', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'ip' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '40', 'default' => '', ], ], 'primary key' => [ 'iid', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->insert('blocked_ips') ->fields([ 'iid', 'ip', ]) ->values([ 'iid' => '1', 'ip' => '111.111.111.111', ]) ->execute(); $connection->schema()->createTable('comment', [ 'fields' => [ 'cid' => [ 'type' => 'serial', 'not null' => TRUE, 'size' => 'normal', ], 'pid' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'nid' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'uid' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'subject' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '64', 'default' => '', ], 'hostname' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'created' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'changed' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'status' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '1', 'unsigned' => TRUE, ], 'thread' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '255', ], 'name' => [ 'type' => 'varchar', 'not null' => FALSE, 'length' => '60', ], 'mail' => [ 'type' => 'varchar', 'not null' => FALSE, 'length' => '64', ], 'homepage' => [ 'type' => 'varchar', 'not null' => FALSE, 'length' => '255', ], 'language' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '12', 'default' => '', ], ], 'primary key' => [ 'cid', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('contact', [ 'fields' => [ 'cid' => [ 'type' => 'serial', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'category' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '255', 'default' => '', ], 'recipients' => [ 'type' => 'text', 'not null' => TRUE, 'size' => 'normal', ], 'reply' => [ 'type' => 'text', 'not null' => TRUE, 'size' => 'normal', ], 'weight' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'selected' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], ], 'primary key' => [ 'cid', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->insert('contact') ->fields([ 'cid', 'category', 'recipients', 'reply', 'weight', 'selected', ]) ->values([ 'cid' => '1', 'category' => 'Website testing', 'recipients' => 'joseph@flattandsons.com', 'reply' => '', 'weight' => '0', 'selected' => '1', ]) ->execute(); $connection->schema()->createTable('date_format_locale', [ 'fields' => [ 'format' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '100', ], 'type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '64', ], 'language' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '12', ], ], 'primary key' => [ 'type', 'language', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('date_format_type', [ 'fields' => [ 'type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '64', ], 'title' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '255', ], 'locked' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], ], 'primary key' => [ 'type', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->insert('date_format_type') ->fields([ 'type', 'title', 'locked', ]) ->values([ 'type' => 'long', 'title' => 'Long', 'locked' => '1', ]) ->values([ 'type' => 'medium', 'title' => 'Medium', 'locked' => '1', ]) ->values([ 'type' => 'short', 'title' => 'Short', 'locked' => '1', ]) ->execute(); $connection->schema()->createTable('date_formats', [ 'fields' => [ 'dfid' => [ 'type' => 'serial', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'format' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '100', ], 'type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '64', ], 'locked' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], ], 'primary key' => [ 'dfid', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->insert('date_formats') ->fields([ 'dfid', 'format', 'type', 'locked', ]) ->values([ 'dfid' => '1', 'format' => 'Y-m-d H:i', 'type' => 'short', 'locked' => '1', ]) ->values([ 'dfid' => '2', 'format' => 'm/d/Y - H:i', 'type' => 'short', 'locked' => '1', ]) ->values([ 'dfid' => '3', 'format' => 'd/m/Y - H:i', 'type' => 'short', 'locked' => '1', ]) ->values([ 'dfid' => '4', 'format' => 'Y/m/d - H:i', 'type' => 'short', 'locked' => '1', ]) ->values([ 'dfid' => '5', 'format' => 'd.m.Y - H:i', 'type' => 'short', 'locked' => '1', ]) ->values([ 'dfid' => '6', 'format' => 'm/d/Y - g:ia', 'type' => 'short', 'locked' => '1', ]) ->values([ 'dfid' => '7', 'format' => 'd/m/Y - g:ia', 'type' => 'short', 'locked' => '1', ]) ->values([ 'dfid' => '8', 'format' => 'Y/m/d - g:ia', 'type' => 'short', 'locked' => '1', ]) ->values([ 'dfid' => '9', 'format' => 'M j Y - H:i', 'type' => 'short', 'locked' => '1', ]) ->values([ 'dfid' => '10', 'format' => 'j M Y - H:i', 'type' => 'short', 'locked' => '1', ]) ->values([ 'dfid' => '11', 'format' => 'Y M j - H:i', 'type' => 'short', 'locked' => '1', ]) ->values([ 'dfid' => '12', 'format' => 'M j Y - g:ia', 'type' => 'short', 'locked' => '1', ]) ->values([ 'dfid' => '13', 'format' => 'j M Y - g:ia', 'type' => 'short', 'locked' => '1', ]) ->values([ 'dfid' => '14', 'format' => 'Y M j - g:ia', 'type' => 'short', 'locked' => '1', ]) ->values([ 'dfid' => '15', 'format' => 'D, Y-m-d H:i', 'type' => 'medium', 'locked' => '1', ]) ->values([ 'dfid' => '16', 'format' => 'D, m/d/Y - H:i', 'type' => 'medium', 'locked' => '1', ]) ->values([ 'dfid' => '17', 'format' => 'D, d/m/Y - H:i', 'type' => 'medium', 'locked' => '1', ]) ->values([ 'dfid' => '18', 'format' => 'D, Y/m/d - H:i', 'type' => 'medium', 'locked' => '1', ]) ->values([ 'dfid' => '19', 'format' => 'F j, Y - H:i', 'type' => 'medium', 'locked' => '1', ]) ->values([ 'dfid' => '20', 'format' => 'j F, Y - H:i', 'type' => 'medium', 'locked' => '1', ]) ->values([ 'dfid' => '21', 'format' => 'Y, F j - H:i', 'type' => 'medium', 'locked' => '1', ]) ->values([ 'dfid' => '22', 'format' => 'D, m/d/Y - g:ia', 'type' => 'medium', 'locked' => '1', ]) ->values([ 'dfid' => '23', 'format' => 'D, d/m/Y - g:ia', 'type' => 'medium', 'locked' => '1', ]) ->values([ 'dfid' => '24', 'format' => 'D, Y/m/d - g:ia', 'type' => 'medium', 'locked' => '1', ]) ->values([ 'dfid' => '25', 'format' => 'F j, Y - g:ia', 'type' => 'medium', 'locked' => '1', ]) ->values([ 'dfid' => '26', 'format' => 'j F Y - g:ia', 'type' => 'medium', 'locked' => '1', ]) ->values([ 'dfid' => '27', 'format' => 'Y, F j - g:ia', 'type' => 'medium', 'locked' => '1', ]) ->values([ 'dfid' => '28', 'format' => 'j. F Y - G:i', 'type' => 'medium', 'locked' => '1', ]) ->values([ 'dfid' => '29', 'format' => 'l, F j, Y - H:i', 'type' => 'long', 'locked' => '1', ]) ->values([ 'dfid' => '30', 'format' => 'l, j F, Y - H:i', 'type' => 'long', 'locked' => '1', ]) ->values([ 'dfid' => '31', 'format' => 'l, Y, F j - H:i', 'type' => 'long', 'locked' => '1', ]) ->values([ 'dfid' => '32', 'format' => 'l, F j, Y - g:ia', 'type' => 'long', 'locked' => '1', ]) ->values([ 'dfid' => '33', 'format' => 'l, j F Y - g:ia', 'type' => 'long', 'locked' => '1', ]) ->values([ 'dfid' => '34', 'format' => 'l, Y, F j - g:ia', 'type' => 'long', 'locked' => '1', ]) ->values([ 'dfid' => '35', 'format' => 'l, j. F Y - G:i', 'type' => 'long', 'locked' => '1', ]) ->values([ 'dfid' => '36', 'format' => 'r', 'type' => 'custom', 'locked' => '0', ]) ->execute(); $connection->schema()->createTable('entity_translation', [ 'fields' => [ 'entity_type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'entity_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'revision_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'language' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'source' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'uid' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'status' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '1', ], 'translate' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'created' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'changed' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], ], 'primary key' => [ 'entity_type', 'entity_id', 'language', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('entity_translation_revision', [ 'fields' => [ 'entity_type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'entity_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'revision_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'language' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'source' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'uid' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'status' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '1', ], 'translate' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'created' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'changed' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], ], 'primary key' => [ 'entity_type', 'revision_id', 'language', ], 'indexes' => [ 'revision_id' => [ 'revision_id', ], ], 'mysql_character_set' => 'utf8mb3', ]); $connection->insert('entity_translation_revision') ->fields([ 'entity_type', 'entity_id', 'revision_id', 'language', 'source', 'uid', 'status', 'translate', 'created', 'changed', ]) ->values([ 'entity_type' => 'node', 'entity_id' => '1', 'revision_id' => '1', 'language' => 'en', 'source' => '', 'uid' => '1', 'status' => '1', 'translate' => '0', 'created' => '1529615790', 'changed' => '1529615790', ]) ->values([ 'entity_type' => 'node', 'entity_id' => '11', 'revision_id' => '15', 'language' => 'en', 'source' => '', 'uid' => '1', 'status' => '1', 'translate' => '0', 'created' => '1568261523', 'changed' => '1568261523', ]) ->values([ 'entity_type' => 'node', 'entity_id' => '11', 'revision_id' => '16', 'language' => 'en', 'source' => '', 'uid' => '1', 'status' => '1', 'translate' => '0', 'created' => '1568261523', 'changed' => '1568261523', ]) ->values([ 'entity_type' => 'node', 'entity_id' => '11', 'revision_id' => '16', 'language' => 'is', 'source' => 'en', 'uid' => '1', 'status' => '1', 'translate' => '0', 'created' => '1568261548', 'changed' => '1568261548', ]) ->values([ 'entity_type' => 'node', 'entity_id' => '11', 'revision_id' => '17', 'language' => 'en', 'source' => '', 'uid' => '1', 'status' => '1', 'translate' => '0', 'created' => '1568261523', 'changed' => '1568261687', ]) ->values([ 'entity_type' => 'node', 'entity_id' => '11', 'revision_id' => '17', 'language' => 'is', 'source' => 'en', 'uid' => '1', 'status' => '1', 'translate' => '0', 'created' => '1568261548', 'changed' => '1568261548', ]) ->values([ 'entity_type' => 'node', 'entity_id' => '11', 'revision_id' => '18', 'language' => 'en', 'source' => '', 'uid' => '1', 'status' => '1', 'translate' => '0', 'created' => '1568261523', 'changed' => '1568261687', ]) ->values([ 'entity_type' => 'node', 'entity_id' => '11', 'revision_id' => '18', 'language' => 'fr', 'source' => 'en', 'uid' => '1', 'status' => '1', 'translate' => '0', 'created' => '1568261721', 'changed' => '1568261721', ]) ->values([ 'entity_type' => 'node', 'entity_id' => '11', 'revision_id' => '18', 'language' => 'is', 'source' => 'en', 'uid' => '1', 'status' => '1', 'translate' => '0', 'created' => '1568261548', 'changed' => '1568261548', ]) ->execute(); $connection->schema()->createTable('field_config', [ 'fields' => [ 'id' => [ 'type' => 'serial', 'not null' => TRUE, 'size' => 'normal', ], 'field_name' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', ], 'type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', ], 'module' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'active' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'storage_type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', ], 'storage_module' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'storage_active' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'locked' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'data' => [ 'type' => 'blob', 'not null' => TRUE, 'size' => 'normal', ], 'cardinality' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'translatable' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'deleted' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], ], 'primary key' => [ 'id', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->insert('field_config') ->fields([ 'id', 'field_name', 'type', 'module', 'active', 'storage_type', 'storage_module', 'storage_active', 'locked', 'data', 'cardinality', 'translatable', 'deleted', ]) ->values([ 'id' => '1', 'field_name' => 'comment_body', 'type' => 'text_long', 'module' => 'text', 'active' => '1', 'storage_type' => 'field_sql_storage', 'storage_module' => 'field_sql_storage', 'storage_active' => '1', 'locked' => '0', 'data' => 'a:6:{s:12:"entity_types";a:1:{i:0;s:7:"comment";}s:12:"translatable";b:0;s:8:"settings";a:0:{}s:7:"storage";a:4:{s:4:"type";s:17:"field_sql_storage";s:8:"settings";a:0:{}s:6:"module";s:17:"field_sql_storage";s:6:"active";i:1;}s:12:"foreign keys";a:1:{s:6:"format";a:2:{s:5:"table";s:13:"filter_format";s:7:"columns";a:1:{s:6:"format";s:6:"format";}}}s:7:"indexes";a:1:{s:6:"format";a:1:{i:0;s:6:"format";}}}', 'cardinality' => '1', 'translatable' => '0', 'deleted' => '0', ]) ->values([ 'id' => '2', 'field_name' => 'body', 'type' => 'text_with_summary', 'module' => 'text', 'active' => '1', 'storage_type' => 'field_sql_storage', 'storage_module' => 'field_sql_storage', 'storage_active' => '1', 'locked' => '0', 'data' => 'a:6:{s:12:"entity_types";a:1:{i:0;s:4:"node";}s:12:"translatable";b:0;s:8:"settings";a:0:{}s:7:"storage";a:4:{s:4:"type";s:17:"field_sql_storage";s:8:"settings";a:0:{}s:6:"module";s:17:"field_sql_storage";s:6:"active";i:1;}s:12:"foreign keys";a:1:{s:6:"format";a:2:{s:5:"table";s:13:"filter_format";s:7:"columns";a:1:{s:6:"format";s:6:"format";}}}s:7:"indexes";a:1:{s:6:"format";a:1:{i:0;s:6:"format";}}}', 'cardinality' => '1', 'translatable' => '0', 'deleted' => '0', ]) ->values([ 'id' => '3', 'field_name' => 'field_tags', 'type' => 'taxonomy_term_reference', 'module' => 'taxonomy', 'active' => '1', 'storage_type' => 'field_sql_storage', 'storage_module' => 'field_sql_storage', 'storage_active' => '1', 'locked' => '0', 'data' => 'a:7:{s:8:"settings";a:3:{s:14:"allowed_values";a:1:{i:0;a:2:{s:10:"vocabulary";s:4:"tags";s:6:"parent";i:0;}}s:21:"options_list_callback";s:28:"i18n_taxonomy_allowed_values";s:23:"entity_translation_sync";b:0;}s:12:"entity_types";a:0:{}s:12:"translatable";s:1:"0";s:7:"storage";a:5:{s:4:"type";s:17:"field_sql_storage";s:8:"settings";a:0:{}s:6:"module";s:17:"field_sql_storage";s:6:"active";s:1:"1";s:7:"details";a:1:{s:3:"sql";a:2:{s:18:"FIELD_LOAD_CURRENT";a:1:{s:21:"field_data_field_tags";a:1:{s:3:"tid";s:14:"field_tags_tid";}}s:19:"FIELD_LOAD_REVISION";a:1:{s:25:"field_revision_field_tags";a:1:{s:3:"tid";s:14:"field_tags_tid";}}}}}s:12:"foreign keys";a:1:{s:3:"tid";a:2:{s:5:"table";s:18:"taxonomy_term_data";s:7:"columns";a:1:{s:3:"tid";s:3:"tid";}}}s:7:"indexes";a:1:{s:3:"tid";a:1:{i:0;s:3:"tid";}}s:2:"id";s:1:"3";}', 'cardinality' => '-1', 'translatable' => '0', 'deleted' => '0', ]) ->values([ 'id' => '4', 'field_name' => 'field_image', 'type' => 'image', 'module' => 'image', 'active' => '1', 'storage_type' => 'field_sql_storage', 'storage_module' => 'field_sql_storage', 'storage_active' => '1', 'locked' => '0', 'data' => 'a:6:{s:7:"indexes";a:1:{s:3:"fid";a:1:{i:0;s:3:"fid";}}s:8:"settings";a:2:{s:10:"uri_scheme";s:6:"public";s:13:"default_image";b:0;}s:7:"storage";a:4:{s:4:"type";s:17:"field_sql_storage";s:8:"settings";a:0:{}s:6:"module";s:17:"field_sql_storage";s:6:"active";i:1;}s:12:"entity_types";a:0:{}s:12:"translatable";b:0;s:12:"foreign keys";a:1:{s:3:"fid";a:2:{s:5:"table";s:12:"file_managed";s:7:"columns";a:1:{s:3:"fid";s:3:"fid";}}}}', 'cardinality' => '1', 'translatable' => '0', 'deleted' => '0', ]) ->values([ 'id' => '6', 'field_name' => 'field_boolean', 'type' => 'list_boolean', 'module' => 'list', 'active' => '1', 'storage_type' => 'field_sql_storage', 'storage_module' => 'field_sql_storage', 'storage_active' => '1', 'locked' => '0', 'data' => 'a:7:{s:12:"translatable";s:1:"0";s:12:"entity_types";a:0:{}s:8:"settings";a:2:{s:14:"allowed_values";a:2:{i:0;s:3:"Off";i:1;s:1:"1";}s:23:"allowed_values_function";s:0:"";}s:7:"storage";a:5:{s:4:"type";s:17:"field_sql_storage";s:8:"settings";a:0:{}s:6:"module";s:17:"field_sql_storage";s:6:"active";s:1:"1";s:7:"details";a:1:{s:3:"sql";a:2:{s:18:"FIELD_LOAD_CURRENT";a:1:{s:24:"field_data_field_boolean";a:1:{s:5:"value";s:19:"field_boolean_value";}}s:19:"FIELD_LOAD_REVISION";a:1:{s:28:"field_revision_field_boolean";a:1:{s:5:"value";s:19:"field_boolean_value";}}}}}s:12:"foreign keys";a:0:{}s:7:"indexes";a:1:{s:5:"value";a:1:{i:0;s:5:"value";}}s:2:"id";s:1:"6";}', 'cardinality' => '1', 'translatable' => '0', 'deleted' => '0', ]) ->values([ 'id' => '11', 'field_name' => 'field_file', 'type' => 'file', 'module' => 'file', 'active' => '1', 'storage_type' => 'field_sql_storage', 'storage_module' => 'field_sql_storage', 'storage_active' => '1', 'locked' => '0', 'data' => 'a:7:{s:12:"translatable";s:1:"0";s:12:"entity_types";a:0:{}s:8:"settings";a:3:{s:13:"display_field";i:0;s:15:"display_default";i:0;s:10:"uri_scheme";s:6:"public";}s:7:"storage";a:5:{s:4:"type";s:17:"field_sql_storage";s:8:"settings";a:0:{}s:6:"module";s:17:"field_sql_storage";s:6:"active";s:1:"1";s:7:"details";a:1:{s:3:"sql";a:2:{s:18:"FIELD_LOAD_CURRENT";a:1:{s:21:"field_data_field_file";a:3:{s:3:"fid";s:14:"field_file_fid";s:7:"display";s:18:"field_file_display";s:11:"description";s:22:"field_file_description";}}s:19:"FIELD_LOAD_REVISION";a:1:{s:25:"field_revision_field_file";a:3:{s:3:"fid";s:14:"field_file_fid";s:7:"display";s:18:"field_file_display";s:11:"description";s:22:"field_file_description";}}}}}s:12:"foreign keys";a:1:{s:3:"fid";a:2:{s:5:"table";s:12:"file_managed";s:7:"columns";a:1:{s:3:"fid";s:3:"fid";}}}s:7:"indexes";a:1:{s:3:"fid";a:1:{i:0;s:3:"fid";}}s:2:"id";s:2:"11";}', 'cardinality' => '1', 'translatable' => '0', 'deleted' => '0', ]) ->values([ 'id' => '15', 'field_name' => 'field_link', 'type' => 'link_field', 'module' => 'link', 'active' => '1', 'storage_type' => 'field_sql_storage', 'storage_module' => 'field_sql_storage', 'storage_active' => '1', 'locked' => '0', 'data' => 'a:7:{s:12:"translatable";s:1:"0";s:12:"entity_types";a:0:{}s:8:"settings";a:7:{s:10:"attributes";a:3:{s:6:"target";s:7:"default";s:5:"class";s:0:"";s:3:"rel";s:0:"";}s:3:"url";i:0;s:5:"title";s:8:"optional";s:11:"title_value";s:0:"";s:15:"title_maxlength";i:128;s:13:"enable_tokens";i:1;s:7:"display";a:1:{s:10:"url_cutoff";i:80;}}s:7:"storage";a:5:{s:4:"type";s:17:"field_sql_storage";s:8:"settings";a:0:{}s:6:"module";s:17:"field_sql_storage";s:6:"active";s:1:"1";s:7:"details";a:1:{s:3:"sql";a:2:{s:18:"FIELD_LOAD_CURRENT";a:1:{s:21:"field_data_field_link";a:3:{s:3:"url";s:14:"field_link_url";s:5:"title";s:16:"field_link_title";s:10:"attributes";s:21:"field_link_attributes";}}s:19:"FIELD_LOAD_REVISION";a:1:{s:25:"field_revision_field_link";a:3:{s:3:"url";s:14:"field_link_url";s:5:"title";s:16:"field_link_title";s:10:"attributes";s:21:"field_link_attributes";}}}}}s:12:"foreign keys";a:0:{}s:7:"indexes";a:0:{}s:2:"id";s:2:"15";}', 'cardinality' => '1', 'translatable' => '0', 'deleted' => '0', ]) ->values([ 'id' => '41', 'field_name' => 'subject_field', 'type' => 'text', 'module' => 'text', 'active' => '1', 'storage_type' => 'field_sql_storage', 'storage_module' => 'field_sql_storage', 'storage_active' => '1', 'locked' => '0', 'data' => 'a:6:{s:12:"translatable";b:1;s:12:"entity_types";a:0:{}s:8:"settings";a:2:{s:10:"max_length";i:255;s:23:"entity_translation_sync";b:0;}s:7:"storage";a:4:{s:4:"type";s:17:"field_sql_storage";s:8:"settings";a:0:{}s:6:"module";s:17:"field_sql_storage";s:6:"active";i:1;}s:12:"foreign keys";a:1:{s:6:"format";a:2:{s:5:"table";s:13:"filter_format";s:7:"columns";a:1:{s:6:"format";s:6:"format";}}}s:7:"indexes";a:1:{s:6:"format";a:1:{i:0;s:6:"format";}}}', 'cardinality' => '1', 'translatable' => '1', 'deleted' => '0', ]) ->values([ 'id' => '48', 'field_name' => 'field_color', 'type' => 'list_text', 'module' => 'list', 'active' => '1', 'storage_type' => 'field_sql_storage', 'storage_module' => 'field_sql_storage', 'storage_active' => '1', 'locked' => '0', 'data' => 'a:7:{s:12:"translatable";b:1;s:12:"entity_types";a:0:{}s:8:"settings";a:3:{s:14:"allowed_values";a:3:{i:0;s:5:"Green";i:1;s:5:"Black";i:2;s:5:"White";}s:23:"allowed_values_function";s:0:"";s:23:"entity_translation_sync";b:0;}s:7:"storage";a:5:{s:4:"type";s:17:"field_sql_storage";s:8:"settings";a:0:{}s:6:"module";s:17:"field_sql_storage";s:6:"active";s:1:"1";s:7:"details";a:1:{s:3:"sql";a:2:{s:18:"FIELD_LOAD_CURRENT";a:1:{s:22:"field_data_field_color";a:1:{s:5:"value";s:17:"field_color_value";}}s:19:"FIELD_LOAD_REVISION";a:1:{s:26:"field_revision_field_color";a:1:{s:5:"value";s:17:"field_color_value";}}}}}s:12:"foreign keys";a:0:{}s:7:"indexes";a:1:{s:5:"value";a:1:{i:0;s:5:"value";}}s:2:"id";s:2:"48";}', 'cardinality' => '1', 'translatable' => '1', 'deleted' => '0', ]) ->values([ 'id' => '49', 'field_name' => 'field_rating', 'type' => 'list_text', 'module' => 'list', 'active' => '1', 'storage_type' => 'field_sql_storage', 'storage_module' => 'field_sql_storage', 'storage_active' => '1', 'locked' => '0', 'data' => 'a:7:{s:12:"translatable";b:1;s:12:"entity_types";a:0:{}s:8:"settings";a:3:{s:14:"allowed_values";a:3:{i:1;s:4:"High";i:2;s:6:"Medium";i:3;s:3:"Low";}s:23:"allowed_values_function";s:0:"";s:23:"entity_translation_sync";b:0;}s:7:"storage";a:5:{s:4:"type";s:17:"field_sql_storage";s:8:"settings";a:0:{}s:6:"module";s:17:"field_sql_storage";s:6:"active";s:1:"1";s:7:"details";a:1:{s:3:"sql";a:2:{s:18:"FIELD_LOAD_CURRENT";a:1:{s:23:"field_data_field_rating";a:1:{s:5:"value";s:18:"field_rating_value";}}s:19:"FIELD_LOAD_REVISION";a:1:{s:27:"field_revision_field_rating";a:1:{s:5:"value";s:18:"field_rating_value";}}}}}s:12:"foreign keys";a:0:{}s:7:"indexes";a:1:{s:5:"value";a:1:{i:0;s:5:"value";}}s:2:"id";s:2:"49";}', 'cardinality' => '1', 'translatable' => '1', 'deleted' => '0', ]) ->values([ 'id' => '54', 'field_name' => 'field_termplain', 'type' => 'taxonomy_term_reference', 'module' => 'taxonomy', 'active' => '1', 'storage_type' => 'field_sql_storage', 'storage_module' => 'field_sql_storage', 'storage_active' => '1', 'locked' => '0', 'data' => 'a:7:{s:12:"translatable";s:1:"1";s:12:"entity_types";a:0:{}s:8:"settings";a:3:{s:14:"allowed_values";a:1:{i:0;a:2:{s:10:"vocabulary";s:4:"tags";s:6:"parent";s:1:"0";}}s:21:"options_list_callback";s:0:"";s:23:"entity_translation_sync";b:0;}s:7:"storage";a:5:{s:4:"type";s:17:"field_sql_storage";s:8:"settings";a:0:{}s:6:"module";s:17:"field_sql_storage";s:6:"active";s:1:"1";s:7:"details";a:1:{s:3:"sql";a:2:{s:18:"FIELD_LOAD_CURRENT";a:1:{s:26:"field_data_field_termplain";a:1:{s:3:"tid";s:19:"field_termplain_tid";}}s:19:"FIELD_LOAD_REVISION";a:1:{s:30:"field_revision_field_termplain";a:1:{s:3:"tid";s:19:"field_termplain_tid";}}}}}s:12:"foreign keys";a:1:{s:3:"tid";a:2:{s:5:"table";s:18:"taxonomy_term_data";s:7:"columns";a:1:{s:3:"tid";s:3:"tid";}}}s:7:"indexes";a:1:{s:3:"tid";a:1:{i:0;s:3:"tid";}}s:2:"id";s:2:"54";}', 'cardinality' => '1', 'translatable' => '1', 'deleted' => '0', ]) ->values([ 'id' => '55', 'field_name' => 'field_termrss', 'type' => 'taxonomy_term_reference', 'module' => 'taxonomy', 'active' => '1', 'storage_type' => 'field_sql_storage', 'storage_module' => 'field_sql_storage', 'storage_active' => '1', 'locked' => '0', 'data' => 'a:7:{s:12:"translatable";s:1:"1";s:12:"entity_types";a:0:{}s:8:"settings";a:3:{s:14:"allowed_values";a:1:{i:0;a:2:{s:10:"vocabulary";s:19:"sujet_de_discussion";s:6:"parent";s:1:"0";}}s:21:"options_list_callback";s:0:"";s:23:"entity_translation_sync";b:0;}s:7:"storage";a:5:{s:4:"type";s:17:"field_sql_storage";s:8:"settings";a:0:{}s:6:"module";s:17:"field_sql_storage";s:6:"active";s:1:"1";s:7:"details";a:1:{s:3:"sql";a:2:{s:18:"FIELD_LOAD_CURRENT";a:1:{s:24:"field_data_field_termrss";a:1:{s:3:"tid";s:17:"field_termrss_tid";}}s:19:"FIELD_LOAD_REVISION";a:1:{s:28:"field_revision_field_termrss";a:1:{s:3:"tid";s:17:"field_termrss_tid";}}}}}s:12:"foreign keys";a:1:{s:3:"tid";a:2:{s:5:"table";s:18:"taxonomy_term_data";s:7:"columns";a:1:{s:3:"tid";s:3:"tid";}}}s:7:"indexes";a:1:{s:3:"tid";a:1:{i:0;s:3:"tid";}}s:2:"id";s:2:"55";}', 'cardinality' => '1', 'translatable' => '1', 'deleted' => '0', ]) ->values([ 'id' => '59', 'field_name' => 'field_file_mfw', 'type' => 'file', 'module' => 'file', 'active' => '1', 'storage_type' => 'field_sql_storage', 'storage_module' => 'field_sql_storage', 'storage_active' => '1', 'locked' => '0', 'data' => 'a:7:{s:12:"translatable";i:0;s:12:"entity_types";a:0:{}s:8:"settings";a:4:{s:13:"display_field";i:0;s:15:"display_default";i:0;s:10:"uri_scheme";s:6:"public";s:23:"entity_translation_sync";a:1:{i:0;s:3:"fid";}}s:7:"storage";a:5:{s:4:"type";s:17:"field_sql_storage";s:8:"settings";a:0:{}s:6:"module";s:17:"field_sql_storage";s:6:"active";s:1:"1";s:7:"details";a:1:{s:3:"sql";a:2:{s:18:"FIELD_LOAD_CURRENT";a:1:{s:25:"field_data_field_file_mfw";a:3:{s:3:"fid";s:18:"field_file_mfw_fid";s:7:"display";s:22:"field_file_mfw_display";s:11:"description";s:26:"field_file_mfw_description";}}s:19:"FIELD_LOAD_REVISION";a:1:{s:29:"field_revision_field_file_mfw";a:3:{s:3:"fid";s:18:"field_file_mfw_fid";s:7:"display";s:22:"field_file_mfw_display";s:11:"description";s:26:"field_file_mfw_description";}}}}}s:12:"foreign keys";a:1:{s:3:"fid";a:2:{s:5:"table";s:12:"file_managed";s:7:"columns";a:1:{s:3:"fid";s:3:"fid";}}}s:7:"indexes";a:1:{s:3:"fid";a:1:{i:0;s:3:"fid";}}s:2:"id";s:2:"56";}', 'cardinality' => '1', 'translatable' => '0', 'deleted' => '0', ]) ->values([ 'id' => '60', 'field_name' => 'field_image_miw', 'type' => 'image', 'module' => 'image', 'active' => '1', 'storage_type' => 'field_sql_storage', 'storage_module' => 'field_sql_storage', 'storage_active' => '1', 'locked' => '0', 'data' => 'a:7:{s:12:"translatable";i:0;s:12:"entity_types";a:0:{}s:8:"settings";a:3:{s:10:"uri_scheme";s:6:"public";s:13:"default_image";i:0;s:23:"entity_translation_sync";a:1:{i:0;s:3:"fid";}}s:7:"storage";a:5:{s:4:"type";s:17:"field_sql_storage";s:8:"settings";a:0:{}s:6:"module";s:17:"field_sql_storage";s:6:"active";s:1:"1";s:7:"details";a:1:{s:3:"sql";a:2:{s:18:"FIELD_LOAD_CURRENT";a:1:{s:26:"field_data_field_image_miw";a:5:{s:3:"fid";s:19:"field_image_miw_fid";s:3:"alt";s:19:"field_image_miw_alt";s:5:"title";s:21:"field_image_miw_title";s:5:"width";s:21:"field_image_miw_width";s:6:"height";s:22:"field_image_miw_height";}}s:19:"FIELD_LOAD_REVISION";a:1:{s:30:"field_revision_field_image_miw";a:5:{s:3:"fid";s:19:"field_image_miw_fid";s:3:"alt";s:19:"field_image_miw_alt";s:5:"title";s:21:"field_image_miw_title";s:5:"width";s:21:"field_image_miw_width";s:6:"height";s:22:"field_image_miw_height";}}}}}s:12:"foreign keys";a:1:{s:3:"fid";a:2:{s:5:"table";s:12:"file_managed";s:7:"columns";a:1:{s:3:"fid";s:3:"fid";}}}s:7:"indexes";a:1:{s:3:"fid";a:1:{i:0;s:3:"fid";}}s:2:"id";s:2:"57";}', 'cardinality' => '1', 'translatable' => '0', 'deleted' => '0', ]) ->values([ 'id' => '62', 'field_name' => 'field_event', 'type' => 'datetime', 'module' => 'date', 'active' => '1', 'storage_type' => 'field_sql_storage', 'storage_module' => 'field_sql_storage', 'storage_active' => '1', 'locked' => '0', 'data' => 'a:7:{s:12:"translatable";i:0;s:12:"entity_types";a:0:{}s:8:"settings";a:7:{s:11:"granularity";a:6:{s:5:"month";s:5:"month";s:3:"day";s:3:"day";s:4:"hour";s:4:"hour";s:6:"minute";s:6:"minute";s:4:"year";s:4:"year";s:6:"second";i:0;}s:11:"tz_handling";s:4:"site";s:11:"timezone_db";s:3:"UTC";s:13:"cache_enabled";i:0;s:11:"cache_count";s:1:"4";s:6:"todate";s:8:"optional";s:23:"entity_translation_sync";b:0;}s:7:"storage";a:5:{s:4:"type";s:17:"field_sql_storage";s:8:"settings";a:0:{}s:6:"module";s:17:"field_sql_storage";s:6:"active";s:1:"1";s:7:"details";a:1:{s:3:"sql";a:2:{s:18:"FIELD_LOAD_CURRENT";a:1:{s:22:"field_data_field_event";a:2:{s:5:"value";s:17:"field_event_value";s:6:"value2";s:18:"field_event_value2";}}s:19:"FIELD_LOAD_REVISION";a:1:{s:26:"field_revision_field_event";a:2:{s:5:"value";s:17:"field_event_value";s:6:"value2";s:18:"field_event_value2";}}}}}s:12:"foreign keys";a:0:{}s:7:"indexes";a:2:{s:5:"value";a:2:{i:0;s:5:"value";i:1;s:6:"value2";}s:6:"value2";a:1:{i:0;s:6:"value2";}}s:2:"id";s:2:"54";}', 'cardinality' => '1', 'translatable' => '0', 'deleted' => '0', ]) ->execute(); $connection->schema()->createTable('field_config_instance', [ 'fields' => [ 'id' => [ 'type' => 'serial', 'not null' => TRUE, 'size' => 'normal', ], 'field_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', ], 'field_name' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'entity_type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'bundle' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'data' => [ 'type' => 'blob', 'not null' => TRUE, 'size' => 'normal', ], 'deleted' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], ], 'primary key' => [ 'id', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->insert('field_config_instance') ->fields([ 'id', 'field_id', 'field_name', 'entity_type', 'bundle', 'data', 'deleted', ]) ->values([ 'id' => '1', 'field_id' => '1', 'field_name' => 'comment_body', 'entity_type' => 'comment', 'bundle' => 'comment_node_page', 'data' => 'a:6:{s:5:"label";s:7:"Comment";s:8:"settings";a:2:{s:15:"text_processing";i:1;s:18:"user_register_form";b:0;}s:8:"required";b:1;s:7:"display";a:1:{s:7:"default";a:5:{s:5:"label";s:6:"hidden";s:4:"type";s:12:"text_default";s:6:"weight";i:0;s:8:"settings";a:0:{}s:6:"module";s:4:"text";}}s:6:"widget";a:4:{s:4:"type";s:13:"text_textarea";s:8:"settings";a:1:{s:4:"rows";i:5;}s:6:"weight";i:0;s:6:"module";s:4:"text";}s:11:"description";s:0:"";}', 'deleted' => '0', ]) ->values([ 'id' => '2', 'field_id' => '2', 'field_name' => 'body', 'entity_type' => 'node', 'bundle' => 'page', 'data' => 'a:6:{s:5:"label";s:4:"Body";s:6:"widget";a:4:{s:4:"type";s:26:"text_textarea_with_summary";s:8:"settings";a:2:{s:4:"rows";i:20;s:12:"summary_rows";i:5;}s:6:"weight";i:-4;s:6:"module";s:4:"text";}s:8:"settings";a:3:{s:15:"display_summary";b:1;s:15:"text_processing";i:1;s:18:"user_register_form";b:0;}s:7:"display";a:2:{s:7:"default";a:5:{s:5:"label";s:6:"hidden";s:4:"type";s:12:"text_default";s:8:"settings";a:0:{}s:6:"module";s:4:"text";s:6:"weight";i:0;}s:6:"teaser";a:5:{s:5:"label";s:6:"hidden";s:4:"type";s:23:"text_summary_or_trimmed";s:8:"settings";a:1:{s:11:"trim_length";i:600;}s:6:"module";s:4:"text";s:6:"weight";i:0;}}s:8:"required";b:0;s:11:"description";s:0:"";}', 'deleted' => '0', ]) ->values([ 'id' => '3', 'field_id' => '1', 'field_name' => 'comment_body', 'entity_type' => 'comment', 'bundle' => 'comment_node_article', 'data' => 'a:6:{s:5:"label";s:7:"Comment";s:8:"settings";a:2:{s:15:"text_processing";i:1;s:18:"user_register_form";b:0;}s:8:"required";b:1;s:7:"display";a:1:{s:7:"default";a:5:{s:5:"label";s:6:"hidden";s:4:"type";s:12:"text_default";s:6:"weight";i:0;s:8:"settings";a:0:{}s:6:"module";s:4:"text";}}s:6:"widget";a:4:{s:4:"type";s:13:"text_textarea";s:8:"settings";a:1:{s:4:"rows";i:5;}s:6:"weight";i:0;s:6:"module";s:4:"text";}s:11:"description";s:0:"";}', 'deleted' => '0', ]) ->values([ 'id' => '4', 'field_id' => '2', 'field_name' => 'body', 'entity_type' => 'node', 'bundle' => 'article', 'data' => 'a:6:{s:5:"label";s:4:"Body";s:6:"widget";a:4:{s:4:"type";s:26:"text_textarea_with_summary";s:8:"settings";a:2:{s:4:"rows";i:20;s:12:"summary_rows";i:5;}s:6:"weight";s:2:"-4";s:6:"module";s:4:"text";}s:8:"settings";a:4:{s:15:"display_summary";b:1;s:15:"text_processing";i:1;s:18:"user_register_form";b:0;s:23:"entity_translation_sync";b:0;}s:7:"display";a:3:{s:7:"default";a:5:{s:5:"label";s:6:"hidden";s:4:"type";s:12:"text_default";s:8:"settings";a:0:{}s:6:"module";s:4:"text";s:6:"weight";i:0;}s:6:"teaser";a:5:{s:5:"label";s:6:"hidden";s:4:"type";s:23:"text_summary_or_trimmed";s:8:"settings";a:1:{s:11:"trim_length";i:600;}s:6:"module";s:4:"text";s:6:"weight";i:0;}s:6:"custom";a:5:{s:5:"label";s:6:"hidden";s:4:"type";s:23:"text_summary_or_trimmed";s:8:"settings";a:1:{s:11:"trim_length";i:600;}s:6:"module";s:4:"text";s:6:"weight";i:11;}}s:8:"required";b:0;s:11:"description";s:0:"";}', 'deleted' => '0', ]) ->values([ 'id' => '5', 'field_id' => '3', 'field_name' => 'field_tags', 'entity_type' => 'node', 'bundle' => 'article', 'data' => 'a:6:{s:5:"label";s:4:"Tags";s:11:"description";s:63:"Enter a comma-separated list of words to describe your content.";s:6:"widget";a:4:{s:4:"type";s:21:"taxonomy_autocomplete";s:6:"weight";s:2:"-4";s:8:"settings";a:2:{s:4:"size";i:60;s:17:"autocomplete_path";s:21:"taxonomy/autocomplete";}s:6:"module";s:8:"taxonomy";}s:7:"display";a:2:{s:7:"default";a:5:{s:4:"type";s:28:"taxonomy_term_reference_link";s:6:"weight";i:10;s:5:"label";s:5:"above";s:8:"settings";a:0:{}s:6:"module";s:8:"taxonomy";}s:6:"teaser";a:5:{s:4:"type";s:28:"taxonomy_term_reference_link";s:6:"weight";i:10;s:5:"label";s:5:"above";s:8:"settings";a:0:{}s:6:"module";s:8:"taxonomy";}}s:8:"settings";a:2:{s:18:"user_register_form";b:0;s:23:"entity_translation_sync";b:0;}s:8:"required";b:0;}', 'deleted' => '0', ]) ->values([ 'id' => '6', 'field_id' => '4', 'field_name' => 'field_image', 'entity_type' => 'node', 'bundle' => 'article', 'data' => 'a:6:{s:5:"label";s:5:"Image";s:11:"description";s:40:"Upload an image to go with this article.";s:8:"required";b:0;s:8:"settings";a:10:{s:14:"file_directory";s:11:"field/image";s:15:"file_extensions";s:16:"png gif jpg jpeg";s:12:"max_filesize";s:0:"";s:14:"max_resolution";s:0:"";s:14:"min_resolution";s:0:"";s:9:"alt_field";b:1;s:11:"title_field";s:0:"";s:13:"default_image";i:0;s:18:"user_register_form";b:0;s:23:"entity_translation_sync";b:0;}s:6:"widget";a:4:{s:4:"type";s:11:"image_image";s:8:"settings";a:2:{s:18:"progress_indicator";s:8:"throbber";s:19:"preview_image_style";s:9:"thumbnail";}s:6:"weight";s:2:"-1";s:6:"module";s:5:"image";}s:7:"display";a:2:{s:7:"default";a:5:{s:5:"label";s:6:"hidden";s:4:"type";s:5:"image";s:8:"settings";a:2:{s:11:"image_style";s:5:"large";s:10:"image_link";s:0:"";}s:6:"weight";i:-1;s:6:"module";s:5:"image";}s:6:"teaser";a:5:{s:5:"label";s:6:"hidden";s:4:"type";s:5:"image";s:8:"settings";a:2:{s:11:"image_style";s:6:"medium";s:10:"image_link";s:7:"content";}s:6:"weight";i:-1;s:6:"module";s:5:"image";}}}', 'deleted' => '0', ]) ->values([ 'id' => '7', 'field_id' => '1', 'field_name' => 'comment_body', 'entity_type' => 'comment', 'bundle' => 'comment_node_blog', 'data' => 'a:6:{s:5:"label";s:7:"Comment";s:8:"settings";a:2:{s:15:"text_processing";i:1;s:18:"user_register_form";b:0;}s:8:"required";b:1;s:7:"display";a:1:{s:7:"default";a:5:{s:5:"label";s:6:"hidden";s:4:"type";s:12:"text_default";s:6:"weight";i:0;s:8:"settings";a:0:{}s:6:"module";s:4:"text";}}s:6:"widget";a:4:{s:4:"type";s:13:"text_textarea";s:8:"settings";a:1:{s:4:"rows";i:5;}s:6:"weight";i:0;s:6:"module";s:4:"text";}s:11:"description";s:0:"";}', 'deleted' => '0', ]) ->values([ 'id' => '8', 'field_id' => '2', 'field_name' => 'body', 'entity_type' => 'node', 'bundle' => 'blog', 'data' => 'a:6:{s:5:"label";s:4:"Body";s:6:"widget";a:4:{s:4:"type";s:26:"text_textarea_with_summary";s:8:"settings";a:2:{s:4:"rows";i:20;s:12:"summary_rows";i:5;}s:6:"weight";s:2:"-4";s:6:"module";s:4:"text";}s:8:"settings";a:4:{s:15:"display_summary";b:1;s:15:"text_processing";i:1;s:18:"user_register_form";b:0;s:23:"entity_translation_sync";b:0;}s:7:"display";a:2:{s:7:"default";a:5:{s:5:"label";s:6:"hidden";s:4:"type";s:12:"text_default";s:8:"settings";a:0:{}s:6:"module";s:4:"text";s:6:"weight";i:0;}s:6:"teaser";a:5:{s:5:"label";s:6:"hidden";s:4:"type";s:23:"text_summary_or_trimmed";s:8:"settings";a:1:{s:11:"trim_length";i:600;}s:6:"module";s:4:"text";s:6:"weight";i:0;}}s:8:"required";b:0;s:11:"description";s:0:"";}', 'deleted' => '0', ]) ->values([ 'id' => '12', 'field_id' => '1', 'field_name' => 'comment_body', 'entity_type' => 'comment', 'bundle' => 'comment_node_forum', 'data' => 'a:6:{s:5:"label";s:7:"Comment";s:8:"settings";a:2:{s:15:"text_processing";i:1;s:18:"user_register_form";b:0;}s:8:"required";b:1;s:7:"display";a:1:{s:7:"default";a:5:{s:5:"label";s:6:"hidden";s:4:"type";s:12:"text_default";s:6:"weight";i:0;s:8:"settings";a:0:{}s:6:"module";s:4:"text";}}s:6:"widget";a:4:{s:4:"type";s:13:"text_textarea";s:8:"settings";a:1:{s:4:"rows";i:5;}s:6:"weight";i:0;s:6:"module";s:4:"text";}s:11:"description";s:0:"";}', 'deleted' => '0', ]) ->values([ 'id' => '13', 'field_id' => '2', 'field_name' => 'body', 'entity_type' => 'node', 'bundle' => 'forum', 'data' => 'a:6:{s:5:"label";s:4:"Body";s:6:"widget";a:4:{s:4:"type";s:26:"text_textarea_with_summary";s:8:"settings";a:2:{s:4:"rows";i:20;s:12:"summary_rows";i:5;}s:6:"weight";i:1;s:6:"module";s:4:"text";}s:8:"settings";a:3:{s:15:"display_summary";b:1;s:15:"text_processing";i:1;s:18:"user_register_form";b:0;}s:7:"display";a:2:{s:7:"default";a:5:{s:5:"label";s:6:"hidden";s:4:"type";s:12:"text_default";s:8:"settings";a:0:{}s:6:"module";s:4:"text";s:6:"weight";i:11;}s:6:"teaser";a:5:{s:5:"label";s:6:"hidden";s:4:"type";s:23:"text_summary_or_trimmed";s:8:"settings";a:1:{s:11:"trim_length";i:600;}s:6:"module";s:4:"text";s:6:"weight";i:11;}}s:8:"required";b:0;s:11:"description";s:0:"";}', 'deleted' => '0', ]) ->values([ 'id' => '33', 'field_id' => '11', 'field_name' => 'field_file', 'entity_type' => 'user', 'bundle' => 'user', 'data' => 'a:6:{s:5:"label";s:4:"File";s:6:"widget";a:5:{s:6:"weight";s:1:"8";s:4:"type";s:12:"file_generic";s:6:"module";s:4:"file";s:6:"active";i:1;s:8:"settings";a:1:{s:18:"progress_indicator";s:8:"throbber";}}s:8:"settings";a:5:{s:14:"file_directory";s:0:"";s:15:"file_extensions";s:3:"txt";s:12:"max_filesize";s:0:"";s:17:"description_field";i:0;s:18:"user_register_form";i:0;}s:7:"display";a:1:{s:7:"default";a:5:{s:5:"label";s:5:"above";s:4:"type";s:12:"file_default";s:8:"settings";a:0:{}s:6:"module";s:4:"file";s:6:"weight";i:0;}}s:8:"required";i:0;s:11:"description";s:0:"";}', 'deleted' => '0', ]) ->values([ 'id' => '34', 'field_id' => '15', 'field_name' => 'field_link', 'entity_type' => 'node', 'bundle' => 'article', 'data' => 'a:7:{s:5:"label";s:4:"Link";s:6:"widget";a:5:{s:6:"weight";s:2:"10";s:4:"type";s:10:"link_field";s:6:"module";s:4:"link";s:6:"active";i:0;s:8:"settings";a:0:{}}s:8:"settings";a:13:{s:12:"absolute_url";i:1;s:12:"validate_url";i:1;s:3:"url";i:0;s:5:"title";s:8:"disabled";s:11:"title_value";s:19:"Unused Static Title";s:27:"title_label_use_field_label";i:0;s:15:"title_maxlength";s:3:"128";s:7:"display";a:1:{s:10:"url_cutoff";s:2:"81";}s:10:"attributes";a:6:{s:6:"target";s:6:"_blank";s:3:"rel";s:8:"nofollow";s:18:"configurable_class";i:0;s:5:"class";s:7:"classes";s:18:"configurable_title";i:1;s:5:"title";s:0:"";}s:10:"rel_remove";s:19:"rel_remove_external";s:13:"enable_tokens";i:1;s:18:"user_register_form";b:0;s:23:"entity_translation_sync";b:0;}s:7:"display";a:1:{s:7:"default";a:5:{s:5:"label";s:5:"above";s:4:"type";s:12:"link_default";s:6:"weight";s:1:"9";s:8:"settings";a:0:{}s:6:"module";s:4:"link";}}s:8:"required";i:0;s:11:"description";s:0:"";s:13:"default_value";N;}', 'deleted' => '0', ]) ->values([ 'id' => '37', 'field_id' => '15', 'field_name' => 'field_link', 'entity_type' => 'node', 'bundle' => 'blog', 'data' => 'a:7:{s:5:"label";s:4:"Link";s:6:"widget";a:5:{s:6:"weight";s:2:"10";s:4:"type";s:10:"link_field";s:6:"module";s:4:"link";s:6:"active";i:0;s:8:"settings";a:0:{}}s:8:"settings";a:14:{s:12:"absolute_url";i:1;s:12:"validate_url";i:1;s:3:"url";i:0;s:5:"title";s:8:"required";s:11:"title_value";s:19:"Unused Static Title";s:20:"title_allowed_values";s:0:"";s:27:"title_label_use_field_label";i:0;s:15:"title_maxlength";s:3:"128";s:7:"display";a:1:{s:10:"url_cutoff";s:2:"81";}s:10:"attributes";a:6:{s:6:"target";s:6:"_blank";s:3:"rel";s:8:"nofollow";s:18:"configurable_class";i:0;s:5:"class";s:7:"classes";s:18:"configurable_title";i:1;s:5:"title";s:0:"";}s:10:"rel_remove";s:19:"rel_remove_external";s:13:"enable_tokens";i:1;s:18:"user_register_form";b:0;s:23:"entity_translation_sync";b:0;}s:7:"display";a:1:{s:7:"default";a:5:{s:5:"label";s:5:"above";s:4:"type";s:12:"link_default";s:6:"weight";s:1:"9";s:8:"settings";a:0:{}s:6:"module";s:4:"link";}}s:8:"required";i:0;s:11:"description";s:0:"";s:13:"default_value";a:1:{i:0;a:3:{s:5:"title";s:6:"Drupal";s:3:"url";s:23:"https://www.drupal.org/";s:10:"attributes";a:1:{s:5:"title";s:14:"Home - Drupal ";}}}}', 'deleted' => '0', ]) ->values([ 'id' => '68', 'field_id' => '41', 'field_name' => 'subject_field', 'entity_type' => 'comment', 'bundle' => 'comment_node_article', 'data' => 'a:6:{s:5:"label";s:7:"Subject";s:11:"description";s:0:"";s:8:"required";b:1;s:8:"settings";a:4:{s:15:"text_processing";i:0;s:10:"hide_label";a:2:{s:4:"page";b:0;s:6:"entity";b:0;}s:18:"user_register_form";b:0;s:23:"entity_translation_sync";b:0;}s:6:"widget";a:4:{s:6:"weight";i:-5;s:4:"type";s:14:"text_textfield";s:8:"settings";a:1:{s:4:"size";i:60;}s:6:"module";s:4:"text";}s:7:"display";a:1:{s:7:"default";a:4:{s:4:"type";s:6:"hidden";s:5:"label";s:5:"above";s:8:"settings";a:0:{}s:6:"weight";i:1;}}}', 'deleted' => '0', ]) ->values([ 'id' => '76', 'field_id' => '48', 'field_name' => 'field_color', 'entity_type' => 'node', 'bundle' => 'blog', 'data' => 'a:7:{s:5:"label";s:5:"Color";s:6:"widget";a:5:{s:6:"weight";s:2:"11";s:4:"type";s:14:"options_select";s:6:"module";s:7:"options";s:6:"active";i:1;s:8:"settings";a:0:{}}s:8:"settings";a:2:{s:18:"user_register_form";b:0;s:23:"entity_translation_sync";b:0;}s:7:"display";a:1:{s:7:"default";a:5:{s:5:"label";s:5:"above";s:4:"type";s:12:"list_default";s:8:"settings";a:0:{}s:6:"module";s:4:"list";s:6:"weight";i:10;}}s:8:"required";i:0;s:11:"description";s:0:"";s:13:"default_value";N;}', 'deleted' => '0', ]) ->values([ 'id' => '77', 'field_id' => '49', 'field_name' => 'field_rating', 'entity_type' => 'node', 'bundle' => 'blog', 'data' => 'a:7:{s:5:"label";s:6:"Rating";s:6:"widget";a:5:{s:6:"weight";s:2:"12";s:4:"type";s:15:"options_buttons";s:6:"module";s:7:"options";s:6:"active";i:1;s:8:"settings";a:0:{}}s:8:"settings";a:2:{s:18:"user_register_form";b:0;s:23:"entity_translation_sync";b:0;}s:7:"display";a:1:{s:7:"default";a:5:{s:5:"label";s:5:"above";s:4:"type";s:12:"list_default";s:8:"settings";a:0:{}s:6:"module";s:4:"list";s:6:"weight";i:11;}}s:8:"required";i:0;s:11:"description";s:0:"";s:13:"default_value";N;}', 'deleted' => '0', ]) ->values([ 'id' => '78', 'field_id' => '6', 'field_name' => 'field_boolean', 'entity_type' => 'node', 'bundle' => 'blog', 'data' => 'a:6:{s:5:"label";s:7:"Boolean";s:6:"widget";a:4:{s:4:"type";s:13:"options_onoff";s:6:"weight";s:2:"14";s:8:"settings";a:1:{s:13:"display_label";i:0;}s:6:"module";s:7:"options";}s:8:"settings";a:2:{s:18:"user_register_form";b:0;s:23:"entity_translation_sync";b:0;}s:7:"display";a:1:{s:7:"default";a:5:{s:5:"label";s:5:"above";s:4:"type";s:12:"list_default";s:8:"settings";a:0:{}s:6:"module";s:4:"list";s:6:"weight";i:12;}}s:8:"required";b:0;s:11:"description";s:0:"";}', 'deleted' => '0', ]) ->values([ 'id' => '83', 'field_id' => '1', 'field_name' => 'comment_body', 'entity_type' => 'comment', 'bundle' => 'comment_node_et', 'data' => 'a:6:{s:5:"label";s:7:"Comment";s:8:"settings";a:2:{s:15:"text_processing";i:1;s:18:"user_register_form";b:0;}s:8:"required";b:1;s:7:"display";a:1:{s:7:"default";a:5:{s:5:"label";s:6:"hidden";s:4:"type";s:12:"text_default";s:6:"weight";i:0;s:8:"settings";a:0:{}s:6:"module";s:4:"text";}}s:6:"widget";a:4:{s:4:"type";s:13:"text_textarea";s:8:"settings";a:1:{s:4:"rows";i:5;}s:6:"weight";i:0;s:6:"module";s:4:"text";}s:11:"description";s:0:"";}', 'deleted' => '0', ]) ->values([ 'id' => '84', 'field_id' => '54', 'field_name' => 'field_termplain', 'entity_type' => 'node', 'bundle' => 'blog', 'data' => 'a:6:{s:5:"label";s:9:"termplain";s:6:"widget";a:4:{s:4:"type";s:15:"options_buttons";s:6:"weight";s:2:"15";s:8:"settings";a:0:{}s:6:"module";s:7:"options";}s:8:"settings";a:2:{s:18:"user_register_form";b:0;s:23:"entity_translation_sync";b:0;}s:7:"display";a:1:{s:7:"default";a:5:{s:5:"label";s:5:"above";s:4:"type";s:29:"taxonomy_term_reference_plain";s:6:"weight";s:2:"13";s:8:"settings";a:0:{}s:6:"module";s:8:"taxonomy";}}s:8:"required";b:0;s:11:"description";s:0:"";}', 'deleted' => '0', ]) ->values([ 'id' => '85', 'field_id' => '55', 'field_name' => 'field_termrss', 'entity_type' => 'node', 'bundle' => 'blog', 'data' => 'a:7:{s:5:"label";s:7:"termrss";s:6:"widget";a:5:{s:6:"weight";s:2:"16";s:4:"type";s:15:"options_buttons";s:6:"module";s:7:"options";s:6:"active";i:1;s:8:"settings";a:0:{}}s:8:"settings";a:2:{s:18:"user_register_form";b:0;s:23:"entity_translation_sync";b:0;}s:7:"display";a:1:{s:7:"default";a:5:{s:5:"label";s:5:"above";s:4:"type";s:36:"taxonomy_term_reference_rss_category";s:6:"weight";s:2:"14";s:8:"settings";a:0:{}s:6:"module";s:8:"taxonomy";}}s:8:"required";i:0;s:11:"description";s:0:"";s:13:"default_value";N;}', 'deleted' => '0', ]) ->values([ 'id' => '91', 'field_id' => '59', 'field_name' => 'field_file_mfw', 'entity_type' => 'node', 'bundle' => 'blog', 'data' => 'a:6:{s:5:"label";s:8:"file_mfw";s:6:"widget";a:5:{s:6:"weight";s:2:"17";s:4:"type";s:8:"file_mfw";s:6:"module";s:28:"multiupload_filefield_widget";s:6:"active";i:1;s:8:"settings";a:1:{s:18:"progress_indicator";s:8:"throbber";}}s:8:"settings";a:6:{s:14:"file_directory";s:0:"";s:15:"file_extensions";s:3:"txt";s:12:"max_filesize";s:0:"";s:17:"description_field";i:0;s:18:"user_register_form";b:0;s:23:"entity_translation_sync";b:0;}s:7:"display";a:1:{s:7:"default";a:5:{s:5:"label";s:5:"above";s:4:"type";s:12:"file_default";s:8:"settings";a:0:{}s:6:"module";s:4:"file";s:6:"weight";i:15;}}s:8:"required";i:0;s:11:"description";s:0:"";}', 'deleted' => '0', ]) ->values([ 'id' => '92', 'field_id' => '60', 'field_name' => 'field_image_miw', 'entity_type' => 'node', 'bundle' => 'blog', 'data' => 'a:6:{s:5:"label";s:9:"image_miw";s:6:"widget";a:5:{s:6:"weight";s:2:"18";s:4:"type";s:9:"image_miw";s:6:"module";s:29:"multiupload_imagefield_widget";s:6:"active";i:1;s:8:"settings";a:2:{s:18:"progress_indicator";s:8:"throbber";s:19:"preview_image_style";s:9:"thumbnail";}}s:8:"settings";a:10:{s:14:"file_directory";s:0:"";s:15:"file_extensions";s:16:"png gif jpg jpeg";s:12:"max_filesize";s:0:"";s:14:"max_resolution";s:0:"";s:14:"min_resolution";s:0:"";s:9:"alt_field";i:0;s:11:"title_field";i:0;s:13:"default_image";i:0;s:18:"user_register_form";b:0;s:23:"entity_translation_sync";b:0;}s:7:"display";a:1:{s:7:"default";a:5:{s:5:"label";s:5:"above";s:4:"type";s:5:"image";s:8:"settings";a:2:{s:11:"image_style";s:0:"";s:10:"image_link";s:0:"";}s:6:"module";s:5:"image";s:6:"weight";i:16;}}s:8:"required";i:0;s:11:"description";s:0:"";}', 'deleted' => '0', ]) ->values([ 'id' => '94', 'field_id' => '62', 'field_name' => 'field_event', 'entity_type' => 'node', 'bundle' => 'forum', 'data' => 'a:6:{s:5:"label";s:5:"event";s:6:"widget";a:5:{s:6:"weight";s:1:"2";s:4:"type";s:9:"date_text";s:6:"module";s:4:"date";s:6:"active";i:1;s:8:"settings";a:7:{s:12:"input_format";s:13:"m/d/Y - H:i:s";s:19:"input_format_custom";s:0:"";s:10:"year_range";s:5:"-3:+3";s:9:"increment";i:1;s:14:"label_position";s:5:"above";s:10:"text_parts";a:0:{}s:11:"no_fieldset";i:0;}}s:8:"settings";a:6:{s:13:"default_value";s:3:"now";s:18:"default_value_code";s:0:"";s:14:"default_value2";s:4:"same";s:19:"default_value_code2";s:0:"";s:18:"user_register_form";b:0;s:23:"entity_translation_sync";b:0;}s:7:"display";a:1:{s:7:"default";a:5:{s:5:"label";s:5:"above";s:4:"type";s:12:"date_default";s:8:"settings";a:6:{s:11:"format_type";s:4:"long";s:15:"multiple_number";s:0:"";s:13:"multiple_from";s:0:"";s:11:"multiple_to";s:0:"";s:6:"fromto";s:4:"both";s:19:"show_remaining_days";b:0;}s:6:"module";s:4:"date";s:6:"weight";i:12;}}s:8:"required";i:0;s:11:"description";s:0:"";}', 'deleted' => '0', ]) ->execute(); $connection->schema()->createTable('field_data_body', [ 'fields' => [ 'entity_type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'bundle' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'deleted' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'entity_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'revision_id' => [ 'type' => 'int', 'not null' => FALSE, 'size' => 'normal', 'unsigned' => TRUE, ], 'language' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'delta' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'body_value' => [ 'type' => 'text', 'not null' => FALSE, 'size' => 'normal', ], 'body_summary' => [ 'type' => 'text', 'not null' => FALSE, 'size' => 'normal', ], 'body_format' => [ 'type' => 'varchar', 'not null' => FALSE, 'length' => '255', ], ], 'primary key' => [ 'entity_type', 'deleted', 'entity_id', 'language', 'delta', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->insert('field_data_body') ->fields([ 'entity_type', 'bundle', 'deleted', 'entity_id', 'revision_id', 'language', 'delta', 'body_value', 'body_summary', 'body_format', ]) ->values([ 'entity_type' => 'node', 'bundle' => 'et', 'deleted' => '0', 'entity_id' => '11', 'revision_id' => '18', 'language' => 'und', 'delta' => '0', 'body_value' => '2nd', 'body_summary' => '', 'body_format' => 'filtered_html', ]) ->execute(); $connection->schema()->createTable('field_data_comment_body', [ 'fields' => [ 'entity_type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'bundle' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'deleted' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'entity_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'revision_id' => [ 'type' => 'int', 'not null' => FALSE, 'size' => 'normal', 'unsigned' => TRUE, ], 'language' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'delta' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'comment_body_value' => [ 'type' => 'text', 'not null' => FALSE, 'size' => 'normal', ], 'comment_body_format' => [ 'type' => 'varchar', 'not null' => FALSE, 'length' => '255', ], ], 'primary key' => [ 'entity_type', 'deleted', 'entity_id', 'language', 'delta', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('field_data_field_boolean', [ 'fields' => [ 'entity_type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'bundle' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'deleted' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'entity_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'revision_id' => [ 'type' => 'int', 'not null' => FALSE, 'size' => 'normal', 'unsigned' => TRUE, ], 'language' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'delta' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'field_boolean_value' => [ 'type' => 'int', 'not null' => FALSE, 'size' => 'normal', ], ], 'primary key' => [ 'entity_type', 'deleted', 'entity_id', 'language', 'delta', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('field_data_field_color', [ 'fields' => [ 'entity_type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'bundle' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'deleted' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'tiny', 'default' => '0', ], 'entity_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'revision_id' => [ 'type' => 'int', 'not null' => FALSE, 'size' => 'normal', 'unsigned' => TRUE, ], 'language' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'delta' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'field_color_value' => [ 'type' => 'varchar', 'not null' => FALSE, 'length' => '255', ], ], 'primary key' => [ 'entity_type', 'entity_id', 'deleted', 'delta', 'language', ], 'indexes' => [ 'entity_type' => [ 'entity_type', ], 'bundle' => [ 'bundle', ], 'deleted' => [ 'deleted', ], 'entity_id' => [ 'entity_id', ], 'revision_id' => [ 'revision_id', ], 'language' => [ 'language', ], 'field_color_value' => [ [ 'field_color_value', '191', ], ], ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('field_data_field_event', [ 'fields' => [ 'entity_type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'bundle' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'deleted' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'tiny', 'default' => '0', ], 'entity_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'revision_id' => [ 'type' => 'int', 'not null' => FALSE, 'size' => 'normal', 'unsigned' => TRUE, ], 'language' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'delta' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'field_event_value' => [ 'type' => 'datetime', 'not null' => FALSE, 'mysql_type' => 'datetime', 'pgsql_type' => 'timestamp without time zone', 'sqlite_type' => 'varchar', 'sqlsrv_type' => 'smalldatetime', ], 'field_event_value2' => [ 'type' => 'datetime', 'not null' => FALSE, 'mysql_type' => 'datetime', 'pgsql_type' => 'timestamp without time zone', 'sqlite_type' => 'varchar', 'sqlsrv_type' => 'smalldatetime', ], ], 'primary key' => [ 'entity_type', 'entity_id', 'deleted', 'delta', 'language', ], 'indexes' => [ 'entity_type' => [ 'entity_type', ], 'bundle' => [ 'bundle', ], 'deleted' => [ 'deleted', ], 'entity_id' => [ 'entity_id', ], 'revision_id' => [ 'revision_id', ], 'language' => [ 'language', ], 'field_event_value' => [ 'field_event_value', 'field_event_value2', ], 'field_event_value2' => [ 'field_event_value2', ], ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('field_data_field_file', [ 'fields' => [ 'entity_type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'bundle' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'deleted' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'entity_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'revision_id' => [ 'type' => 'int', 'not null' => FALSE, 'size' => 'normal', 'unsigned' => TRUE, ], 'language' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'delta' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'field_file_fid' => [ 'type' => 'int', 'not null' => FALSE, 'size' => 'normal', 'unsigned' => TRUE, ], 'field_file_display' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '1', 'unsigned' => TRUE, ], 'field_file_description' => [ 'type' => 'text', 'not null' => FALSE, 'size' => 'normal', ], ], 'primary key' => [ 'entity_type', 'deleted', 'entity_id', 'language', 'delta', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('field_data_field_image', [ 'fields' => [ 'entity_type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'bundle' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'deleted' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'entity_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'revision_id' => [ 'type' => 'int', 'not null' => FALSE, 'size' => 'normal', 'unsigned' => TRUE, ], 'language' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'delta' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'field_image_fid' => [ 'type' => 'int', 'not null' => FALSE, 'size' => 'normal', 'unsigned' => TRUE, ], 'field_image_alt' => [ 'type' => 'varchar', 'not null' => FALSE, 'length' => '512', ], 'field_image_title' => [ 'type' => 'varchar', 'not null' => FALSE, 'length' => '1024', ], 'field_image_width' => [ 'type' => 'int', 'not null' => FALSE, 'size' => 'normal', 'unsigned' => TRUE, ], 'field_image_height' => [ 'type' => 'int', 'not null' => FALSE, 'size' => 'normal', 'unsigned' => TRUE, ], ], 'primary key' => [ 'entity_type', 'deleted', 'entity_id', 'language', 'delta', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('field_data_field_link', [ 'fields' => [ 'entity_type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'bundle' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'deleted' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'entity_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'revision_id' => [ 'type' => 'int', 'not null' => FALSE, 'size' => 'normal', 'unsigned' => TRUE, ], 'language' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'delta' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'field_link_url' => [ 'type' => 'varchar', 'not null' => FALSE, 'length' => '2048', ], 'field_link_title' => [ 'type' => 'varchar', 'not null' => FALSE, 'length' => '255', ], 'field_link_attributes' => [ 'type' => 'text', 'not null' => FALSE, 'size' => 'normal', ], ], 'primary key' => [ 'entity_type', 'deleted', 'entity_id', 'language', 'delta', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('field_data_field_rating', [ 'fields' => [ 'entity_type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'bundle' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'deleted' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'tiny', 'default' => '0', ], 'entity_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'revision_id' => [ 'type' => 'int', 'not null' => FALSE, 'size' => 'normal', 'unsigned' => TRUE, ], 'language' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'delta' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'field_rating_value' => [ 'type' => 'varchar', 'not null' => FALSE, 'length' => '255', ], ], 'primary key' => [ 'entity_type', 'entity_id', 'deleted', 'delta', 'language', ], 'indexes' => [ 'entity_type' => [ 'entity_type', ], 'bundle' => [ 'bundle', ], 'deleted' => [ 'deleted', ], 'entity_id' => [ 'entity_id', ], 'revision_id' => [ 'revision_id', ], 'language' => [ 'language', ], 'field_rating_value' => [ [ 'field_rating_value', '191', ], ], ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('field_data_field_tags', [ 'fields' => [ 'entity_type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'bundle' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'deleted' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'entity_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'revision_id' => [ 'type' => 'int', 'not null' => FALSE, 'size' => 'normal', 'unsigned' => TRUE, ], 'language' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'delta' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'field_tags_tid' => [ 'type' => 'int', 'not null' => FALSE, 'size' => 'normal', 'unsigned' => TRUE, ], ], 'primary key' => [ 'entity_type', 'deleted', 'entity_id', 'language', 'delta', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('field_data_field_termplain', [ 'fields' => [ 'entity_type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'bundle' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'deleted' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'tiny', 'default' => '0', ], 'entity_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'revision_id' => [ 'type' => 'int', 'not null' => FALSE, 'size' => 'normal', 'unsigned' => TRUE, ], 'language' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'delta' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'field_termplain_tid' => [ 'type' => 'int', 'not null' => FALSE, 'size' => 'normal', 'unsigned' => TRUE, ], ], 'primary key' => [ 'entity_type', 'entity_id', 'deleted', 'delta', 'language', ], 'indexes' => [ 'entity_type' => [ 'entity_type', ], 'bundle' => [ 'bundle', ], 'deleted' => [ 'deleted', ], 'entity_id' => [ 'entity_id', ], 'revision_id' => [ 'revision_id', ], 'language' => [ 'language', ], 'field_termplain_tid' => [ 'field_termplain_tid', ], ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('field_data_field_termrss', [ 'fields' => [ 'entity_type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'bundle' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'deleted' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'tiny', 'default' => '0', ], 'entity_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'revision_id' => [ 'type' => 'int', 'not null' => FALSE, 'size' => 'normal', 'unsigned' => TRUE, ], 'language' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'delta' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'field_termrss_tid' => [ 'type' => 'int', 'not null' => FALSE, 'size' => 'normal', 'unsigned' => TRUE, ], ], 'primary key' => [ 'entity_type', 'entity_id', 'deleted', 'delta', 'language', ], 'indexes' => [ 'entity_type' => [ 'entity_type', ], 'bundle' => [ 'bundle', ], 'deleted' => [ 'deleted', ], 'entity_id' => [ 'entity_id', ], 'revision_id' => [ 'revision_id', ], 'language' => [ 'language', ], 'field_termrss_tid' => [ 'field_termrss_tid', ], ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('field_data_subject_field', [ 'fields' => [ 'entity_type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'bundle' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'deleted' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'tiny', 'default' => '0', ], 'entity_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'revision_id' => [ 'type' => 'int', 'not null' => FALSE, 'size' => 'normal', 'unsigned' => TRUE, ], 'language' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'delta' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'subject_field_value' => [ 'type' => 'varchar', 'not null' => FALSE, 'length' => '255', ], 'subject_field_format' => [ 'type' => 'varchar', 'not null' => FALSE, 'length' => '255', ], ], 'primary key' => [ 'entity_type', 'entity_id', 'deleted', 'delta', 'language', ], 'indexes' => [ 'entity_type' => [ 'entity_type', ], 'bundle' => [ 'bundle', ], 'deleted' => [ 'deleted', ], 'entity_id' => [ 'entity_id', ], 'revision_id' => [ 'revision_id', ], 'language' => [ 'language', ], 'subject_field_format' => [ [ 'subject_field_format', '191', ], ], ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('field_revision_body', [ 'fields' => [ 'entity_type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'bundle' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'deleted' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'entity_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'revision_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'language' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'delta' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'body_value' => [ 'type' => 'text', 'not null' => FALSE, 'size' => 'normal', ], 'body_summary' => [ 'type' => 'text', 'not null' => FALSE, 'size' => 'normal', ], 'body_format' => [ 'type' => 'varchar', 'not null' => FALSE, 'length' => '255', ], ], 'primary key' => [ 'entity_type', 'deleted', 'entity_id', 'revision_id', 'language', 'delta', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->insert('field_revision_body') ->fields([ 'entity_type', 'bundle', 'deleted', 'entity_id', 'revision_id', 'language', 'delta', 'body_value', 'body_summary', 'body_format', ]) ->values([ 'entity_type' => 'node', 'bundle' => 'et', 'deleted' => '0', 'entity_id' => '11', 'revision_id' => '15', 'language' => 'und', 'delta' => '0', 'body_value' => '1st', 'body_summary' => '', 'body_format' => 'filtered_html', ]) ->values([ 'entity_type' => 'node', 'bundle' => 'et', 'deleted' => '0', 'entity_id' => '11', 'revision_id' => '16', 'language' => 'und', 'delta' => '0', 'body_value' => '1st', 'body_summary' => '', 'body_format' => 'filtered_html', ]) ->values([ 'entity_type' => 'node', 'bundle' => 'et', 'deleted' => '0', 'entity_id' => '11', 'revision_id' => '17', 'language' => 'und', 'delta' => '0', 'body_value' => '2nd', 'body_summary' => '', 'body_format' => 'filtered_html', ]) ->values([ 'entity_type' => 'node', 'bundle' => 'et', 'deleted' => '0', 'entity_id' => '11', 'revision_id' => '18', 'language' => 'und', 'delta' => '0', 'body_value' => '2nd', 'body_summary' => '', 'body_format' => 'filtered_html', ]) ->execute(); $connection->schema()->createTable('field_revision_comment_body', [ 'fields' => [ 'entity_type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'bundle' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'deleted' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'entity_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'revision_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'language' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'delta' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'comment_body_value' => [ 'type' => 'text', 'not null' => FALSE, 'size' => 'normal', ], 'comment_body_format' => [ 'type' => 'varchar', 'not null' => FALSE, 'length' => '255', ], ], 'primary key' => [ 'entity_type', 'deleted', 'entity_id', 'revision_id', 'language', 'delta', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('field_revision_field_boolean', [ 'fields' => [ 'entity_type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'bundle' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'deleted' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'entity_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'revision_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'language' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'delta' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'field_boolean_value' => [ 'type' => 'int', 'not null' => FALSE, 'size' => 'normal', ], ], 'primary key' => [ 'entity_type', 'deleted', 'entity_id', 'revision_id', 'language', 'delta', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('field_revision_field_color', [ 'fields' => [ 'entity_type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'bundle' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'deleted' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'tiny', 'default' => '0', ], 'entity_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'revision_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'language' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'delta' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'field_color_value' => [ 'type' => 'varchar', 'not null' => FALSE, 'length' => '255', ], ], 'primary key' => [ 'entity_type', 'entity_id', 'revision_id', 'deleted', 'delta', 'language', ], 'indexes' => [ 'entity_type' => [ 'entity_type', ], 'bundle' => [ 'bundle', ], 'deleted' => [ 'deleted', ], 'entity_id' => [ 'entity_id', ], 'revision_id' => [ 'revision_id', ], 'language' => [ 'language', ], 'field_color_value' => [ [ 'field_color_value', '191', ], ], ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('field_revision_field_event', [ 'fields' => [ 'entity_type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'bundle' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'deleted' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'tiny', 'default' => '0', ], 'entity_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'revision_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'language' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'delta' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'field_event_value' => [ 'type' => 'datetime', 'not null' => FALSE, 'mysql_type' => 'datetime', 'pgsql_type' => 'timestamp without time zone', 'sqlite_type' => 'varchar', 'sqlsrv_type' => 'smalldatetime', ], 'field_event_value2' => [ 'type' => 'datetime', 'not null' => FALSE, 'mysql_type' => 'datetime', 'pgsql_type' => 'timestamp without time zone', 'sqlite_type' => 'varchar', 'sqlsrv_type' => 'smalldatetime', ], ], 'primary key' => [ 'entity_type', 'entity_id', 'revision_id', 'deleted', 'delta', 'language', ], 'indexes' => [ 'entity_type' => [ 'entity_type', ], 'bundle' => [ 'bundle', ], 'deleted' => [ 'deleted', ], 'entity_id' => [ 'entity_id', ], 'revision_id' => [ 'revision_id', ], 'language' => [ 'language', ], 'field_event_value' => [ 'field_event_value', 'field_event_value2', ], 'field_event_value2' => [ 'field_event_value2', ], ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('field_revision_field_file', [ 'fields' => [ 'entity_type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'bundle' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'deleted' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'entity_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'revision_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'language' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'delta' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'field_file_fid' => [ 'type' => 'int', 'not null' => FALSE, 'size' => 'normal', 'unsigned' => TRUE, ], 'field_file_display' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '1', 'unsigned' => TRUE, ], 'field_file_description' => [ 'type' => 'text', 'not null' => FALSE, 'size' => 'normal', ], ], 'primary key' => [ 'entity_type', 'deleted', 'entity_id', 'revision_id', 'language', 'delta', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('field_revision_field_image', [ 'fields' => [ 'entity_type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'bundle' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'deleted' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'entity_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'revision_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'language' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'delta' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'field_image_fid' => [ 'type' => 'int', 'not null' => FALSE, 'size' => 'normal', 'unsigned' => TRUE, ], 'field_image_alt' => [ 'type' => 'varchar', 'not null' => FALSE, 'length' => '512', ], 'field_image_title' => [ 'type' => 'varchar', 'not null' => FALSE, 'length' => '1024', ], 'field_image_width' => [ 'type' => 'int', 'not null' => FALSE, 'size' => 'normal', 'unsigned' => TRUE, ], 'field_image_height' => [ 'type' => 'int', 'not null' => FALSE, 'size' => 'normal', 'unsigned' => TRUE, ], ], 'primary key' => [ 'entity_type', 'deleted', 'entity_id', 'revision_id', 'language', 'delta', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('field_revision_field_link', [ 'fields' => [ 'entity_type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'bundle' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'deleted' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'entity_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'revision_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'language' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'delta' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'field_link_url' => [ 'type' => 'varchar', 'not null' => FALSE, 'length' => '2048', ], 'field_link_title' => [ 'type' => 'varchar', 'not null' => FALSE, 'length' => '255', ], 'field_link_attributes' => [ 'type' => 'text', 'not null' => FALSE, 'size' => 'normal', ], ], 'primary key' => [ 'entity_type', 'deleted', 'entity_id', 'revision_id', 'language', 'delta', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('field_revision_field_rating', [ 'fields' => [ 'entity_type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'bundle' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'deleted' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'tiny', 'default' => '0', ], 'entity_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'revision_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'language' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'delta' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'field_rating_value' => [ 'type' => 'varchar', 'not null' => FALSE, 'length' => '255', ], ], 'primary key' => [ 'entity_type', 'entity_id', 'revision_id', 'deleted', 'delta', 'language', ], 'indexes' => [ 'entity_type' => [ 'entity_type', ], 'bundle' => [ 'bundle', ], 'deleted' => [ 'deleted', ], 'entity_id' => [ 'entity_id', ], 'revision_id' => [ 'revision_id', ], 'language' => [ 'language', ], 'field_rating_value' => [ [ 'field_rating_value', '191', ], ], ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('field_revision_field_tags', [ 'fields' => [ 'entity_type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'bundle' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'deleted' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'entity_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'revision_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'language' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'delta' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'field_tags_tid' => [ 'type' => 'int', 'not null' => FALSE, 'size' => 'normal', 'unsigned' => TRUE, ], ], 'primary key' => [ 'entity_type', 'deleted', 'entity_id', 'revision_id', 'language', 'delta', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('field_revision_field_termplain', [ 'fields' => [ 'entity_type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'bundle' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'deleted' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'tiny', 'default' => '0', ], 'entity_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'revision_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'language' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'delta' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'field_termplain_tid' => [ 'type' => 'int', 'not null' => FALSE, 'size' => 'normal', 'unsigned' => TRUE, ], ], 'primary key' => [ 'entity_type', 'entity_id', 'revision_id', 'deleted', 'delta', 'language', ], 'indexes' => [ 'entity_type' => [ 'entity_type', ], 'bundle' => [ 'bundle', ], 'deleted' => [ 'deleted', ], 'entity_id' => [ 'entity_id', ], 'revision_id' => [ 'revision_id', ], 'language' => [ 'language', ], 'field_termplain_tid' => [ 'field_termplain_tid', ], ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('field_revision_field_termrss', [ 'fields' => [ 'entity_type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'bundle' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'deleted' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'tiny', 'default' => '0', ], 'entity_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'revision_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'language' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'delta' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'field_termrss_tid' => [ 'type' => 'int', 'not null' => FALSE, 'size' => 'normal', 'unsigned' => TRUE, ], ], 'primary key' => [ 'entity_type', 'entity_id', 'revision_id', 'deleted', 'delta', 'language', ], 'indexes' => [ 'entity_type' => [ 'entity_type', ], 'bundle' => [ 'bundle', ], 'deleted' => [ 'deleted', ], 'entity_id' => [ 'entity_id', ], 'revision_id' => [ 'revision_id', ], 'language' => [ 'language', ], 'field_termrss_tid' => [ 'field_termrss_tid', ], ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('field_revision_subject_field', [ 'fields' => [ 'entity_type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'bundle' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '128', 'default' => '', ], 'deleted' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'tiny', 'default' => '0', ], 'entity_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'revision_id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'language' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'delta' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'subject_field_value' => [ 'type' => 'varchar', 'not null' => FALSE, 'length' => '255', ], 'subject_field_format' => [ 'type' => 'varchar', 'not null' => FALSE, 'length' => '255', ], ], 'primary key' => [ 'entity_type', 'entity_id', 'revision_id', 'deleted', 'delta', 'language', ], 'indexes' => [ 'entity_type' => [ 'entity_type', ], 'bundle' => [ 'bundle', ], 'deleted' => [ 'deleted', ], 'entity_id' => [ 'entity_id', ], 'revision_id' => [ 'revision_id', ], 'language' => [ 'language', ], 'subject_field_format' => [ [ 'subject_field_format', '191', ], ], ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('file_managed', [ 'fields' => [ 'fid' => [ 'type' => 'serial', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'uid' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', 'unsigned' => TRUE, ], 'filename' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '255', 'default' => '', ], 'uri' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '255', 'default' => '', ], 'filemime' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '255', 'default' => '', ], 'filesize' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', 'unsigned' => TRUE, ], 'status' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'timestamp' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', 'unsigned' => TRUE, ], ], 'primary key' => [ 'fid', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('file_usage', [ 'fields' => [ 'fid' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'unsigned' => TRUE, ], 'module' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '255', 'default' => '', ], 'type' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '64', 'default' => '', ], 'id' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', 'unsigned' => TRUE, ], 'count' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', 'unsigned' => TRUE, ], ], 'primary key' => [ 'fid', 'module', 'type', 'id', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->schema()->createTable('filter', [ 'fields' => [ 'format' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '255', ], 'module' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '64', 'default' => '', ], 'name' => [ 'type' => 'varchar', 'not null' => TRUE, 'length' => '32', 'default' => '', ], 'weight' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'status' => [ 'type' => 'int', 'not null' => TRUE, 'size' => 'normal', 'default' => '0', ], 'settings' => [ 'type' => 'blob', 'not null' => FALSE, 'size' => 'normal', ], ], 'primary key' => [ 'format', 'name', ], 'mysql_character_set' => 'utf8mb3', ]); $connection->insert('filter') ->fields([ 'format', 'module', 'name', 'weight', 'status', 'settings', ]) ->values([ 'format' => 'custom_text_format', 'module' => 'filter', 'name' => 'filter_autop', 'weight' => '0', 'status' => '1', 'settings' => 'a:0:{}', ]) ->values([ 'format' => 'custom_text_format', 'module' => 'filter', 'name' => 'filter_html', 'weight' => '-10', 'status' => '1', 'settings' => 'a:3:{s:12:"allowed_html";s:82:"