drupal6.php in Range 8
A database agnostic dump for testing purposes.
This file was generated by the Drupal db-tools.php script and then modified:
- only necessary tables & records were preserved
File
tests/fixtures/drupal6.phpView source
<?php
// @codingStandardsIgnoreFile
/**
* @file
* A database agnostic dump for testing purposes.
*
* This file was generated by the Drupal db-tools.php script and then modified:
* - only necessary tables & records were preserved
*/
use Drupal\Core\Database\Database;
$connection = Database::getConnection();
$connection
->schema()
->createTable('content_field_decimal', array(
'fields' => array(
'vid' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
'unsigned' => TRUE,
),
'nid' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
'unsigned' => TRUE,
),
'delta' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
'unsigned' => TRUE,
),
'field_decimal_value' => array(
'type' => 'numeric',
'not null' => FALSE,
'precision' => '12',
'scale' => '1',
),
),
'primary key' => array(
'vid',
'delta',
),
'indexes' => array(
'nid' => array(
'nid',
),
),
'mysql_character_set' => 'utf8',
));
$connection
->insert('content_field_decimal')
->fields(array(
'vid',
'nid',
'delta',
'field_decimal_value',
))
->values(array(
'vid' => '1',
'nid' => '1',
'delta' => '0',
'field_decimal_value' => '55.6',
))
->values(array(
'vid' => '1',
'nid' => '1',
'delta' => '1',
'field_decimal_value' => '67.7',
))
->values(array(
'vid' => '1',
'nid' => '1',
'delta' => '2',
'field_decimal_value' => '88.9',
))
->execute();
$connection
->schema()
->createTable('content_node_field', array(
'fields' => array(
'field_name' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '32',
'default' => '',
),
'type' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '127',
'default' => '',
),
'global_settings' => array(
'type' => 'text',
'not null' => TRUE,
'size' => 'medium',
),
'required' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'tiny',
'default' => '0',
),
'multiple' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'tiny',
'default' => '0',
),
'db_storage' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'tiny',
'default' => '1',
),
'module' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '127',
'default' => '',
),
'db_columns' => array(
'type' => 'text',
'not null' => TRUE,
'size' => 'medium',
),
'active' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'tiny',
'default' => '0',
),
'locked' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'tiny',
'default' => '0',
),
),
'primary key' => array(
'field_name',
),
'mysql_character_set' => 'utf8',
));
$connection
->insert('content_node_field')
->fields(array(
'field_name',
'type',
'global_settings',
'required',
'multiple',
'db_storage',
'module',
'db_columns',
'active',
'locked',
))
->values(array(
'field_name' => 'field_decimal',
'type' => 'range_decimal',
'global_settings' => 'a:9:{s:6:"prefix";s:0:"";s:6:"suffix";s:0:"";s:3:"min";s:1:"5";s:3:"max";s:2:"50";s:14:"allowed_values";s:0:"";s:18:"allowed_values_php";s:0:"";s:9:"precision";s:2:"12";s:5:"scale";s:1:"1";s:7:"decimal";s:1:".";}',
'required' => '0',
'multiple' => '1',
'db_storage' => '0',
'module' => 'range',
'db_columns' => 'a:1:{s:5:"value";a:5:{s:4:"type";s:7:"numeric";s:9:"precision";s:2:"12";s:5:"scale";s:1:"1";s:8:"not null";b:0;s:8:"sortable";b:1;}}',
'active' => '1',
'locked' => '0',
))
->values(array(
'field_name' => 'field_float',
'type' => 'range_float',
'global_settings' => 'a:6:{s:6:"prefix";s:0:"";s:6:"suffix";s:6:"SUFFIX";s:3:"min";s:1:"<";s:3:"max";s:4:"1000";s:14:"allowed_values";s:0:"";s:18:"allowed_values_php";s:0:"";}',
'required' => '0',
'multiple' => '0',
'db_storage' => '1',
'module' => 'range',
'db_columns' => 'a:1:{s:5:"value";a:3:{s:4:"type";s:5:"float";s:8:"not null";b:0;s:8:"sortable";b:1;}}',
'active' => '1',
'locked' => '0',
))
->values(array(
'field_name' => 'field_integer',
'type' => 'range_integer',
'global_settings' => 'a:6:{s:6:"prefix";s:0:"";s:6:"suffix";s:0:"";s:3:"min";s:1:"<";s:3:"max";s:1:">";s:14:"allowed_values";s:0:"";s:18:"allowed_values_php";s:0:"";}',
'required' => '0',
'multiple' => '0',
'db_storage' => '1',
'module' => 'range',
'db_columns' => 'a:1:{s:5:"value";a:3:{s:4:"type";s:3:"int";s:8:"not null";b:0;s:8:"sortable";b:1;}}',
'active' => '1',
'locked' => '0',
))
->execute();
$connection
->schema()
->createTable('content_node_field_instance', array(
'fields' => array(
'field_name' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '32',
'default' => '',
),
'type_name' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '32',
'default' => '',
),
'weight' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
),
'label' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '255',
'default' => '',
),
'widget_type' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '32',
'default' => '',
),
'widget_settings' => array(
'type' => 'text',
'not null' => TRUE,
'size' => 'medium',
),
'display_settings' => array(
'type' => 'text',
'not null' => TRUE,
'size' => 'medium',
),
'description' => array(
'type' => 'text',
'not null' => TRUE,
'size' => 'medium',
),
'widget_module' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '127',
'default' => '',
),
'widget_active' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'tiny',
'default' => '0',
),
),
'primary key' => array(
'field_name',
'type_name',
),
'mysql_character_set' => 'utf8',
));
$connection
->insert('content_node_field_instance')
->fields(array(
'field_name',
'type_name',
'weight',
'label',
'widget_type',
'widget_settings',
'display_settings',
'description',
'widget_module',
'widget_active',
))
->values(array(
'field_name' => 'field_decimal',
'type_name' => 'page',
'weight' => '31',
'label' => 'Decimal',
'widget_type' => 'range',
'widget_settings' => 'a:2:{s:13:"default_value";a:1:{i:0;a:2:{s:5:"value";d:15;s:14:"_error_element";s:45:"default_value_widget][field_decimal][0][value";}}s:17:"default_value_php";N;}',
'display_settings' => 'a:6:{s:6:"weight";s:2:"31";s:6:"parent";s:0:"";i:4;a:2:{s:6:"format";s:4:"us_2";s:7:"exclude";i:0;}s:5:"label";a:1:{s:6:"format";s:5:"above";}s:6:"teaser";a:2:{s:6:"format";s:7:"default";s:7:"exclude";i:0;}s:4:"full";a:2:{s:6:"format";s:11:"unformatted";s:7:"exclude";i:0;}}',
'description' => '',
'widget_module' => 'range',
'widget_active' => '1',
))
->values(array(
'field_name' => 'field_float',
'type_name' => 'page',
'weight' => '32',
'label' => 'Float',
'widget_type' => 'range',
'widget_settings' => 'a:2:{s:13:"default_value";a:1:{i:0;a:2:{s:5:"value";s:0:"";s:14:"_error_element";s:43:"default_value_widget][field_float][0][value";}}s:17:"default_value_php";N;}',
'display_settings' => 'a:6:{s:6:"weight";s:2:"32";s:6:"parent";s:0:"";i:4;a:2:{s:6:"format";s:4:"be_1";s:7:"exclude";i:0;}s:5:"label";a:1:{s:6:"format";s:5:"above";}s:6:"teaser";a:2:{s:6:"format";s:7:"default";s:7:"exclude";i:0;}s:4:"full";a:2:{s:6:"format";s:11:"unformatted";s:7:"exclude";i:0;}}',
'description' => '',
'widget_module' => 'range',
'widget_active' => '1',
))
->values(array(
'field_name' => 'field_integer',
'type_name' => 'page',
'weight' => '33',
'label' => 'Integer',
'widget_type' => 'range',
'widget_settings' => 'a:2:{s:13:"default_value";a:1:{i:0;a:2:{s:5:"value";s:0:"";s:14:"_error_element";s:45:"default_value_widget][field_integer][0][value";}}s:17:"default_value_php";N;}',
'display_settings' => 'a:6:{s:6:"weight";s:2:"33";s:6:"parent";s:0:"";i:4;a:2:{s:6:"format";s:4:"fr_0";s:7:"exclude";i:0;}s:5:"label";a:1:{s:6:"format";s:5:"above";}s:6:"teaser";a:2:{s:6:"format";s:7:"default";s:7:"exclude";i:0;}s:4:"full";a:2:{s:6:"format";s:11:"unformatted";s:7:"exclude";i:0;}}',
'description' => '',
'widget_module' => 'range',
'widget_active' => '1',
))
->execute();
$connection
->schema()
->createTable('content_type_page', array(
'fields' => array(
'vid' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
'unsigned' => TRUE,
),
'nid' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
'unsigned' => TRUE,
),
'field_float_value' => array(
'type' => 'float',
'not null' => FALSE,
'size' => 'normal',
),
'field_integer_value' => array(
'type' => 'int',
'not null' => FALSE,
'size' => 'normal',
),
),
'primary key' => array(
'vid',
),
'indexes' => array(
'nid' => array(
'nid',
),
),
'mysql_character_set' => 'utf8',
));
$connection
->insert('content_type_page')
->fields(array(
'vid',
'nid',
'field_float_value',
'field_integer_value',
))
->values(array(
'vid' => '1',
'nid' => '1',
'field_float_value' => NULL,
'field_integer_value' => '120',
))
->execute();
$connection
->schema()
->createTable('filter_formats', array(
'fields' => array(
'format' => array(
'type' => 'serial',
'not null' => TRUE,
'size' => 'normal',
),
'name' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '255',
'default' => '',
),
'roles' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '255',
'default' => '',
),
'cache' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'tiny',
'default' => '0',
),
),
'primary key' => array(
'format',
),
'unique keys' => array(
'name' => array(
'name',
),
),
'mysql_character_set' => 'utf8',
));
$connection
->insert('filter_formats')
->fields(array(
'format',
'name',
'roles',
'cache',
))
->values(array(
'format' => '1',
'name' => 'Filtered HTML',
'roles' => ',1,2,',
'cache' => '1',
))
->values(array(
'format' => '2',
'name' => 'Full HTML',
'roles' => '',
'cache' => '1',
))
->execute();
$connection
->schema()
->createTable('filters', array(
'fields' => array(
'fid' => array(
'type' => 'serial',
'not null' => TRUE,
'size' => 'normal',
),
'format' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
),
'module' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '64',
'default' => '',
),
'delta' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'tiny',
'default' => '0',
),
'weight' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'tiny',
'default' => '0',
),
),
'primary key' => array(
'fid',
),
'unique keys' => array(
'fmd' => array(
'format',
'module',
'delta',
),
),
'indexes' => array(
'list' => array(
'format',
'weight',
'module',
'delta',
),
),
'mysql_character_set' => 'utf8',
));
$connection
->insert('filters')
->fields(array(
'fid',
'format',
'module',
'delta',
'weight',
))
->values(array(
'fid' => '1',
'format' => '1',
'module' => 'filter',
'delta' => '2',
'weight' => '0',
))
->values(array(
'fid' => '2',
'format' => '1',
'module' => 'filter',
'delta' => '0',
'weight' => '1',
))
->values(array(
'fid' => '3',
'format' => '1',
'module' => 'filter',
'delta' => '1',
'weight' => '2',
))
->values(array(
'fid' => '4',
'format' => '1',
'module' => 'filter',
'delta' => '3',
'weight' => '10',
))
->values(array(
'fid' => '5',
'format' => '2',
'module' => 'filter',
'delta' => '2',
'weight' => '0',
))
->values(array(
'fid' => '6',
'format' => '2',
'module' => 'filter',
'delta' => '1',
'weight' => '1',
))
->values(array(
'fid' => '7',
'format' => '2',
'module' => 'filter',
'delta' => '3',
'weight' => '10',
))
->execute();
$connection
->schema()
->createTable('node', array(
'fields' => array(
'nid' => array(
'type' => 'serial',
'not null' => TRUE,
'size' => 'normal',
'unsigned' => TRUE,
),
'vid' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
'unsigned' => TRUE,
),
'type' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '32',
'default' => '',
),
'language' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '12',
'default' => '',
),
'title' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '255',
'default' => '',
),
'uid' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
),
'status' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '1',
),
'created' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
),
'changed' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
),
'comment' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
),
'promote' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
),
'moderate' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
),
'sticky' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
),
'tnid' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
'unsigned' => TRUE,
),
'translate' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
),
),
'primary key' => array(
'nid',
),
'unique keys' => array(
'vid' => array(
'vid',
),
),
'indexes' => array(
'node_changed' => array(
'changed',
),
'node_created' => array(
'created',
),
'node_moderate' => array(
'moderate',
),
'node_promote_status' => array(
'promote',
'status',
),
'node_status_type' => array(
'status',
'type',
'nid',
),
'node_title_type' => array(
'title',
array(
'type',
'4',
),
),
'node_type' => array(
array(
'type',
'4',
),
),
'uid' => array(
'uid',
),
'tnid' => array(
'tnid',
),
'translate' => array(
'translate',
),
),
'mysql_character_set' => 'utf8',
));
$connection
->insert('node')
->fields(array(
'nid',
'vid',
'type',
'language',
'title',
'uid',
'status',
'created',
'changed',
'comment',
'promote',
'moderate',
'sticky',
'tnid',
'translate',
))
->values(array(
'nid' => '1',
'vid' => '1',
'type' => 'page',
'language' => '',
'title' => 'Test',
'uid' => '1',
'status' => '1',
'created' => '1590533450',
'changed' => '1590579473',
'comment' => '0',
'promote' => '0',
'moderate' => '0',
'sticky' => '0',
'tnid' => '0',
'translate' => '0',
))
->execute();
$connection
->schema()
->createTable('node_access', array(
'fields' => array(
'nid' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
'unsigned' => TRUE,
),
'gid' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
'unsigned' => TRUE,
),
'realm' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '255',
'default' => '',
),
'grant_view' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'tiny',
'default' => '0',
'unsigned' => TRUE,
),
'grant_update' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'tiny',
'default' => '0',
'unsigned' => TRUE,
),
'grant_delete' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'tiny',
'default' => '0',
'unsigned' => TRUE,
),
),
'primary key' => array(
'nid',
'gid',
'realm',
),
'mysql_character_set' => 'utf8',
));
$connection
->insert('node_access')
->fields(array(
'nid',
'gid',
'realm',
'grant_view',
'grant_update',
'grant_delete',
))
->values(array(
'nid' => '0',
'gid' => '0',
'realm' => 'all',
'grant_view' => '1',
'grant_update' => '0',
'grant_delete' => '0',
))
->execute();
$connection
->schema()
->createTable('node_revisions', array(
'fields' => array(
'nid' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
'unsigned' => TRUE,
),
'vid' => array(
'type' => 'serial',
'not null' => TRUE,
'size' => 'normal',
'unsigned' => TRUE,
),
'uid' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
),
'title' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '255',
'default' => '',
),
'body' => array(
'type' => 'text',
'not null' => TRUE,
'size' => 'big',
),
'teaser' => array(
'type' => 'text',
'not null' => TRUE,
'size' => 'big',
),
'log' => array(
'type' => 'text',
'not null' => TRUE,
'size' => 'big',
),
'timestamp' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
),
'format' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
),
),
'primary key' => array(
'vid',
),
'indexes' => array(
'nid' => array(
'nid',
),
'uid' => array(
'uid',
),
),
'mysql_character_set' => 'utf8',
));
$connection
->insert('node_revisions')
->fields(array(
'nid',
'vid',
'uid',
'title',
'body',
'teaser',
'log',
'timestamp',
'format',
))
->values(array(
'nid' => '1',
'vid' => '1',
'uid' => '1',
'title' => 'Test',
'body' => '',
'teaser' => '',
'log' => '',
'timestamp' => '1590579473',
'format' => '1',
))
->execute();
$connection
->schema()
->createTable('node_type', array(
'fields' => array(
'type' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '32',
),
'name' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '255',
'default' => '',
),
'module' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '255',
),
'description' => array(
'type' => 'text',
'not null' => TRUE,
'size' => 'medium',
),
'help' => array(
'type' => 'text',
'not null' => TRUE,
'size' => 'medium',
),
'has_title' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'tiny',
'unsigned' => TRUE,
),
'title_label' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '255',
'default' => '',
),
'has_body' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'tiny',
'unsigned' => TRUE,
),
'body_label' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '255',
'default' => '',
),
'min_word_count' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'small',
'unsigned' => TRUE,
),
'custom' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'tiny',
'default' => '0',
),
'modified' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'tiny',
'default' => '0',
),
'locked' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'tiny',
'default' => '0',
),
'orig_type' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '255',
'default' => '',
),
),
'primary key' => array(
'type',
),
'mysql_character_set' => 'utf8',
));
$connection
->insert('node_type')
->fields(array(
'type',
'name',
'module',
'description',
'help',
'has_title',
'title_label',
'has_body',
'body_label',
'min_word_count',
'custom',
'modified',
'locked',
'orig_type',
))
->values(array(
'type' => 'page',
'name' => 'Page',
'module' => 'node',
'description' => "A <em>page</em>, similar in form to a <em>story</em>, is a simple method for creating and displaying information that rarely changes, such as an \"About us\" section of a website. By default, a <em>page</em> entry does not allow visitor comments and is not featured on the site's initial home page.",
'help' => '',
'has_title' => '1',
'title_label' => 'Title',
'has_body' => '1',
'body_label' => 'Body',
'min_word_count' => '0',
'custom' => '1',
'modified' => '1',
'locked' => '0',
'orig_type' => 'page',
))
->execute();
$connection
->schema()
->createTable('permission', array(
'fields' => array(
'pid' => array(
'type' => 'serial',
'not null' => TRUE,
'size' => 'normal',
),
'rid' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
'unsigned' => TRUE,
),
'perm' => array(
'type' => 'text',
'not null' => FALSE,
'size' => 'big',
),
'tid' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
'unsigned' => TRUE,
),
),
'primary key' => array(
'pid',
),
'indexes' => array(
'rid' => array(
'rid',
),
),
'mysql_character_set' => 'utf8',
));
$connection
->insert('permission')
->fields(array(
'pid',
'rid',
'perm',
'tid',
))
->values(array(
'pid' => '1',
'rid' => '1',
'perm' => 'access content',
'tid' => '0',
))
->values(array(
'pid' => '2',
'rid' => '2',
'perm' => 'access comments, access content, post comments, post comments without approval',
'tid' => '0',
))
->execute();
$connection
->schema()
->createTable('role', array(
'fields' => array(
'rid' => array(
'type' => 'serial',
'not null' => TRUE,
'size' => 'normal',
'unsigned' => TRUE,
),
'name' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '64',
'default' => '',
),
),
'primary key' => array(
'rid',
),
'unique keys' => array(
'name' => array(
'name',
),
),
'mysql_character_set' => 'utf8',
));
$connection
->insert('role')
->fields(array(
'rid',
'name',
))
->values(array(
'rid' => '1',
'name' => 'anonymous user',
))
->values(array(
'rid' => '2',
'name' => 'authenticated user',
))
->execute();
$connection
->schema()
->createTable('system', array(
'fields' => array(
'filename' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '255',
'default' => '',
),
'name' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '255',
'default' => '',
),
'type' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '255',
'default' => '',
),
'owner' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '255',
'default' => '',
),
'status' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
),
'throttle' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'tiny',
'default' => '0',
),
'bootstrap' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
),
'schema_version' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'small',
'default' => '-1',
),
'weight' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
),
'info' => array(
'type' => 'text',
'not null' => FALSE,
'size' => 'normal',
),
),
'primary key' => array(
'filename',
),
'indexes' => array(
'modules' => array(
array(
'type',
'12',
),
'status',
'weight',
'filename',
),
'bootstrap' => array(
array(
'type',
'12',
),
'status',
'bootstrap',
'weight',
'filename',
),
'type_name' => array(
array(
'type',
'12',
),
'name',
),
),
'mysql_character_set' => 'utf8',
));
$connection
->insert('system')
->fields(array(
'filename',
'name',
'type',
'owner',
'status',
'throttle',
'bootstrap',
'schema_version',
'weight',
'info',
))
->values(array(
'filename' => 'modules/filter/filter.module',
'name' => 'filter',
'type' => 'module',
'owner' => '',
'status' => '1',
'throttle' => '0',
'bootstrap' => '0',
'schema_version' => '0',
'weight' => '0',
'info' => 'a:10:{s:4:"name";s:6:"Filter";s:11:"description";s:60:"Handles the filtering of content in preparation for display.";s:7:"package";s:15:"Core - required";s:7:"version";s:4:"6.53";s:4:"core";s:3:"6.x";s:7:"project";s:6:"drupal";s:9:"datestamp";s:10:"1589983358";s:12:"dependencies";a:0:{}s:10:"dependents";a:0:{}s:3:"php";s:5:"4.3.5";}',
))
->values(array(
'filename' => 'modules/node/node.module',
'name' => 'node',
'type' => 'module',
'owner' => '',
'status' => '1',
'throttle' => '0',
'bootstrap' => '0',
'schema_version' => '0',
'weight' => '0',
'info' => 'a:10:{s:4:"name";s:4:"Node";s:11:"description";s:66:"Allows content to be submitted to the site and displayed on pages.";s:7:"package";s:15:"Core - required";s:7:"version";s:4:"6.53";s:4:"core";s:3:"6.x";s:7:"project";s:6:"drupal";s:9:"datestamp";s:10:"1589983358";s:12:"dependencies";a:0:{}s:10:"dependents";a:0:{}s:3:"php";s:5:"4.3.5";}',
))
->values(array(
'filename' => 'modules/system/system.module',
'name' => 'system',
'type' => 'module',
'owner' => '',
'status' => '1',
'throttle' => '0',
'bootstrap' => '0',
'schema_version' => '6056',
'weight' => '0',
'info' => 'a:10:{s:4:"name";s:6:"System";s:11:"description";s:54:"Handles general site configuration for administrators.";s:7:"package";s:15:"Core - required";s:7:"version";s:4:"6.53";s:4:"core";s:3:"6.x";s:7:"project";s:6:"drupal";s:9:"datestamp";s:10:"1589983358";s:12:"dependencies";a:0:{}s:10:"dependents";a:0:{}s:3:"php";s:5:"4.3.5";}',
))
->values(array(
'filename' => 'modules/user/user.module',
'name' => 'user',
'type' => 'module',
'owner' => '',
'status' => '1',
'throttle' => '0',
'bootstrap' => '0',
'schema_version' => '0',
'weight' => '0',
'info' => 'a:10:{s:4:"name";s:4:"User";s:11:"description";s:47:"Manages the user registration and login system.";s:7:"package";s:15:"Core - required";s:7:"version";s:4:"6.53";s:4:"core";s:3:"6.x";s:7:"project";s:6:"drupal";s:9:"datestamp";s:10:"1589983358";s:12:"dependencies";a:0:{}s:10:"dependents";a:0:{}s:3:"php";s:5:"4.3.5";}',
))
->values(array(
'filename' => 'sites/all/modules/cck/content.module',
'name' => 'content',
'type' => 'module',
'owner' => '',
'status' => '1',
'throttle' => '0',
'bootstrap' => '0',
'schema_version' => '6010',
'weight' => '0',
'info' => 'a:10:{s:4:"name";s:7:"Content";s:11:"description";s:50:"Allows administrators to define new content types.";s:7:"package";s:3:"CCK";s:4:"core";s:3:"6.x";s:7:"version";s:8:"6.x-2.12";s:7:"project";s:3:"cck";s:9:"datestamp";s:10:"1539021600";s:12:"dependencies";a:0:{}s:10:"dependents";a:0:{}s:3:"php";s:5:"4.3.5";}',
))
->values(array(
'filename' => 'sites/all/modules/range/range.module',
'name' => 'range',
'type' => 'module',
'owner' => '',
'status' => '1',
'throttle' => '0',
'bootstrap' => '0',
'schema_version' => '0',
'weight' => '0',
'info' => 'a:10:{s:4:"name";s:5:"Range";s:11:"description";s:95:"Defines numeric fields within a range of possible values and displays them colored accordingly.";s:12:"dependencies";a:1:{i:0;s:7:"content";}s:7:"package";s:3:"CCK";s:4:"core";s:3:"6.x";s:7:"version";s:7:"6.x-1.1";s:7:"project";s:5:"range";s:9:"datestamp";s:10:"1235258443";s:10:"dependents";a:0:{}s:3:"php";s:5:"4.3.5";}',
))
->execute();
$connection
->schema()
->createTable('users', array(
'fields' => array(
'uid' => array(
'type' => 'serial',
'not null' => TRUE,
'size' => 'normal',
'unsigned' => TRUE,
),
'name' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '60',
'default' => '',
),
'pass' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '32',
'default' => '',
),
'mail' => array(
'type' => 'varchar',
'not null' => FALSE,
'length' => '64',
'default' => '',
),
'mode' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'tiny',
'default' => '0',
),
'sort' => array(
'type' => 'int',
'not null' => FALSE,
'size' => 'tiny',
'default' => '0',
),
'threshold' => array(
'type' => 'int',
'not null' => FALSE,
'size' => 'tiny',
'default' => '0',
),
'theme' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '255',
'default' => '',
),
'signature' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '255',
'default' => '',
),
'signature_format' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'small',
'default' => '0',
),
'created' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
),
'access' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
),
'login' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
),
'status' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'tiny',
'default' => '0',
),
'timezone' => array(
'type' => 'varchar',
'not null' => FALSE,
'length' => '8',
),
'language' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '12',
'default' => '',
),
'picture' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '255',
'default' => '',
),
'init' => array(
'type' => 'varchar',
'not null' => FALSE,
'length' => '64',
'default' => '',
),
'data' => array(
'type' => 'text',
'not null' => FALSE,
'size' => 'big',
),
),
'primary key' => array(
'uid',
),
'unique keys' => array(
'name' => array(
'name',
),
),
'indexes' => array(
'access' => array(
'access',
),
'created' => array(
'created',
),
'mail' => array(
'mail',
),
),
'mysql_character_set' => 'utf8',
));
$connection
->insert('users')
->fields(array(
'uid',
'name',
'pass',
'mail',
'mode',
'sort',
'threshold',
'theme',
'signature',
'signature_format',
'created',
'access',
'login',
'status',
'timezone',
'language',
'picture',
'init',
'data',
))
->values(array(
'uid' => '1',
'name' => 'root',
'pass' => '',
'mail' => 'root@localhost',
'mode' => '0',
'sort' => '0',
'threshold' => '0',
'theme' => '',
'signature' => '',
'signature_format' => '0',
'created' => '1590525687',
'access' => '1590579421',
'login' => '1590525711',
'status' => '1',
'timezone' => NULL,
'language' => '',
'picture' => '',
'init' => 'root@localhost',
'data' => 'a:0:{}',
))
->execute();
$connection
->schema()
->createTable('users_roles', array(
'fields' => array(
'uid' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
'unsigned' => TRUE,
),
'rid' => array(
'type' => 'int',
'not null' => TRUE,
'size' => 'normal',
'default' => '0',
'unsigned' => TRUE,
),
),
'primary key' => array(
'uid',
'rid',
),
'indexes' => array(
'rid' => array(
'rid',
),
),
'mysql_character_set' => 'utf8',
));
$connection
->schema()
->createTable('variable', array(
'fields' => array(
'name' => array(
'type' => 'varchar',
'not null' => TRUE,
'length' => '128',
'default' => '',
),
'value' => array(
'type' => 'text',
'not null' => TRUE,
'size' => 'big',
),
),
'primary key' => array(
'name',
),
'mysql_character_set' => 'utf8',
));