drupal7.php

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

use Drupal\Core\Database\Database;

$connection = Database::getConnection();

$connection->schema()->createTable('i18n_block_language', array(
  'fields' => array(
    'module' => array(
      'type' => 'varchar',
      'not null' => TRUE,
      'length' => '64',
    ),
    'delta' => array(
      'type' => 'varchar',
      'not null' => TRUE,
      'length' => '32',
    ),
    'language' => array(
      'type' => 'varchar',
      'not null' => TRUE,
      'length' => '12',
      'default' => '',
    ),
  ),
  'primary key' => array(
    'module',
    'delta',
    'language',
  ),
  'indexes' => array(
    'language' => array(
      'language',
    ),
  ),
  'mysql_character_set' => 'utf8',
));

$connection->schema()->createTable('i18n_string', array(
  'fields' => array(
    'lid' => array(
      'type' => 'int',
      'not null' => TRUE,
      'size' => 'normal',
      'default' => '0',
    ),
    'textgroup' => array(
      'type' => 'varchar',
      'not null' => TRUE,
      'length' => '50',
      'default' => 'default',
    ),
    'context' => array(
      'type' => 'varchar',
      'not null' => TRUE,
      'length' => '255',
      'default' => '',
    ),
    'objectid' => array(
      'type' => 'varchar',
      'not null' => TRUE,
      'length' => '255',
      'default' => '',
    ),
    'type' => array(
      'type' => 'varchar',
      'not null' => TRUE,
      'length' => '255',
      'default' => '',
    ),
    'property' => array(
      'type' => 'varchar',
      'not null' => TRUE,
      'length' => '255',
      'default' => '',
    ),
    'objectindex' => array(
      'type' => 'int',
      'not null' => TRUE,
      'size' => 'big',
      'default' => '0',
    ),
    'format' => array(
      'type' => 'varchar',
      'not null' => FALSE,
      'length' => '255',
    ),
  ),
  'primary key' => array(
    'lid',
  ),
  'indexes' => array(
    'group_context' => array(
      'textgroup',
      array(
        'context',
        '50',
      ),
    ),
  ),
  'mysql_character_set' => 'utf8',
));

$connection->insert('i18n_string')
->fields(array(
  'lid',
  'textgroup',
  'context',
  'objectid',
  'type',
  'property',
  'objectindex',
  'format',
))
->values(array(
  'lid' => '57',
  'textgroup' => 'blocks',
  'context' => 'block:1:title',
  'objectid' => '1',
  'type' => 'block',
  'property' => 'title',
  'objectindex' => '1',
  'format' => '',
))
->values(array(
  'lid' => '60',
  'textgroup' => 'blocks',
  'context' => 'block:1:body',
  'objectid' => '1',
  'type' => 'block',
  'property' => 'body',
  'objectindex' => '1',
  'format' => 'filtered_html',
))
->values(array(
  'lid' => '61',
  'textgroup' => 'node',
  'context' => 'type:article:name',
  'objectid' => 'article',
  'type' => 'type',
  'property' => 'name',
  'objectindex' => '0',
  'format' => '',
))
->values(array(
  'lid' => '62',
  'textgroup' => 'node',
  'context' => 'type:article:title_label',
  'objectid' => 'article',
  'type' => 'type',
  'property' => 'title_label',
  'objectindex' => '0',
  'format' => '',
))
->values(array(
  'lid' => '63',
  'textgroup' => 'node',
  'context' => 'type:article:description',
  'objectid' => 'article',
  'type' => 'type',
  'property' => 'description',
  'objectindex' => '0',
  'format' => '',
))
->values(array(
  'lid' => '64',
  'textgroup' => 'node',
  'context' => 'type:article:help',
  'objectid' => 'article',
  'type' => 'type',
  'property' => 'help',
  'objectindex' => '0',
  'format' => '',
))
->values(array(
  'lid' => '65',
  'textgroup' => 'node',
  'context' => 'type:book:name',
  'objectid' => 'book',
  'type' => 'type',
  'property' => 'name',
  'objectindex' => '0',
  'format' => '',
))
->values(array(
  'lid' => '66',
  'textgroup' => 'node',
  'context' => 'type:book:title_label',
  'objectid' => 'book',
  'type' => 'type',
  'property' => 'title_label',
  'objectindex' => '0',
  'format' => '',
))
->values(array(
  'lid' => '67',
  'textgroup' => 'node',
  'context' => 'type:book:description',
  'objectid' => 'book',
  'type' => 'type',
  'property' => 'description',
  'objectindex' => '0',
  'format' => '',
))
->values(array(
  'lid' => '68',
  'textgroup' => 'node',
  'context' => 'type:page:name',
  'objectid' => 'page',
  'type' => 'type',
  'property' => 'name',
  'objectindex' => '0',
  'format' => '',
))
->values(array(
  'lid' => '69',
  'textgroup' => 'node',
  'context' => 'type:page:title_label',
  'objectid' => 'page',
  'type' => 'type',
  'property' => 'title_label',
  'objectindex' => '0',
  'format' => '',
))
->values(array(
  'lid' => '70',
  'textgroup' => 'node',
  'context' => 'type:page:description',
  'objectid' => 'page',
  'type' => 'type',
  'property' => 'description',
  'objectindex' => '0',
  'format' => '',
))
->values(array(
  'lid' => '71',
  'textgroup' => 'node',
  'context' => 'type:page:help',
  'objectid' => 'page',
  'type' => 'type',
  'property' => 'help',
  'objectindex' => '0',
  'format' => '',
))
->values(array(
  'lid' => '72',
  'textgroup' => 'node',
  'context' => 'type:test_content_type:name',
  'objectid' => 'test_content_type',
  'type' => 'type',
  'property' => 'name',
  'objectindex' => '0',
  'format' => '',
))
->values(array(
  'lid' => '73',
  'textgroup' => 'node',
  'context' => 'type:test_content_type:title_label',
  'objectid' => 'test_content_type',
  'type' => 'type',
  'property' => 'title_label',
  'objectindex' => '0',
  'format' => '',
))
->values(array(
  'lid' => '74',
  'textgroup' => 'node',
  'context' => 'type:test_content_type:description',
  'objectid' => 'test_content_type',
  'type' => 'type',
  'property' => 'description',
  'objectindex' => '0',
  'format' => '',
))
->values(array(
  'lid' => '75',
  'textgroup' => 'node',
  'context' => 'type:test_content_type:help',
  'objectid' => 'test_content_type',
  'type' => 'type',
  'property' => 'help',
  'objectindex' => '0',
  'format' => '',
))
->execute();

$connection->schema()->createTable('accesslog', array(
  'fields' => array(
    'aid' => array(
      'type' => 'serial',
      'not null' => TRUE,
      'size' => 'normal',
    ),
    'sid' => array(
      'type' => 'varchar',
      'not null' => TRUE,
      'length' => '128',
      'default' => '',
    ),
    'title' => array(
      'type' => 'varchar',
      'not null' => FALSE,
      'length' => '255',
    ),
    'path' => array(
      'type' => 'varchar',
      'not null' => FALSE,
      'length' => '255',
    ),
    'url' => array(
      'type' => 'text',
      'not null' => FALSE,
      'size' => 'normal',
    ),
    'hostname' => array(
      'type' => 'varchar',
      'not null' => FALSE,
      'length' => '128',
    ),
    'uid' => array(
      'type' => 'int',
      'not null' => FALSE,
      'size' => 'normal',
      'default' => '0',
      'unsigned' => TRUE,
    ),
    'timer' => array(
      'type' => 'int',
      'not null' => TRUE,
      'size' => 'normal',
      'default' => '0',
      'unsigned' => TRUE,
    ),
    'timestamp' => array(
      'type' => 'int',
      'not null' => TRUE,
      'size' => 'normal',
      'default' => '0',
      'unsigned' => TRUE,
    ),
  ),
  'primary key' => array(
    'aid',
  ),
  'mysql_character_set' => 'utf8',
));

$connection->insert('accesslog')
->fields(array(
  'aid',
  'sid',
  'title',
  'path',
  'url',
  'hostname',
  'uid',
  'timer',
  'timestamp',
))
->values(array(
  'aid' => '92',
  'sid' => 'a8ksMY2GH4yXK0-PsLNAlCv4zNnapnyCpx4lryZDEfk',
  'title' => '',
  'path' => 'node',
  'url' => 'http://drupal7.local/?q=user/register',
  'hostname' => '127.0.0.1',
  'uid' => '0',
  'timer' => '655',
  'timestamp' => '1444944970',
))
->values(array(
  'aid' => '93',
  'sid' => 'e89G2redQpxRTIndbV3qH8snVR621DqSQ2s4vciJedA',
  'title' => '',
  'path' => 'node',
  'url' => 'http://drupal7.local/',
  'hostname' => '127.0.0.1',
  'uid' => '0',
  'timer' => '214',
  'timestamp' => '1444944974',
))
->values(array(
  'aid' => '94',
  'sid' => 'KkVxQTCiKqKEGNcRs7GYrmXXbEk4szXCHVTknFkbiG0',
  'title' => 'User account',
  'path' => 'user/login',
  'url' => '',
  'hostname' => '127.0.0.1',
  'uid' => '0',
  'timer' => '259',
  'timestamp' => '1444945094',
))
->values(array(
  'aid' => '95',
  'sid' => 'FA1BMWZvsAAE1G-OBMzfiJyA12sh588cOKSmEmxFQiA',
  'title' => 'My account',
  'path' => 'user/login',
  'url' => 'http://drupal7.local/?q=user/login',
  'hostname' => '127.0.0.1',
  'uid' => '1',
  'timer' => '217',
  'timestamp' => '1444945097',
))
->values(array(
  'aid' => '96',
  'sid' => 'FA1BMWZvsAAE1G-OBMzfiJyA12sh588cOKSmEmxFQiA',
  'title' => 'root',
  'path' => 'user/1',
  'url' => 'http://drupal7.local/?q=user/login',
  'hostname' => '127.0.0.1',
  'uid' => '1',
  'timer' => '211',
  'timestamp' => '1444945097',
))
->values(array(
  'aid' => '97',
  'sid' => 'FA1BMWZvsAAE1G-OBMzfiJyA12sh588cOKSmEmxFQiA',
  'title' => 'Modules',
  'path' => 'admin/modules',
  'url' => 'http://drupal7.local/user/1',
  'hostname' => '127.0.0.1',
  'uid' => '1',
  'timer' => '619',
  'timestamp' => '1444945104',
))
->values(array(
  'aid' => '98',
  'sid' => 'FA1BMWZvsAAE1G-OBMzfiJyA12sh588cOKSmEmxFQiA',
  'title' => 'Configuration',
  'path' => 'admin/config',
  'url' => 'http://drupal7.local/admin/modules',
  'hostname' => '127.0.0.1',
  'uid' => '1',
  'timer' => '273',
  'timestamp' => '1444945114',
))
->values(array(
  'aid' => '99',
  'sid' => 'FA1BMWZvsAAE1G-OBMzfiJyA12sh588cOKSmEmxFQiA',
  'title' => 'Languages',
  'path' => 'admin/config/regional/language',
  'url' => 'http://drupal7.local/admin/config',
  'hostname' => '127.0.0.1',
  'uid' => '1',
  'timer' => '213',
  'timestamp' => '1444945121',
))
->values(array(
  'aid' => '100',
  'sid' => 'FA1BMWZvsAAE1G-OBMzfiJyA12sh588cOKSmEmxFQiA',
  'title' => 'Languages',
  'path' => 'admin/config/regional/language/add',
  'url' => 'http://drupal7.local/admin/config/regional/language',
  'hostname' => '127.0.0.1',
  'uid' => '1',
  'timer' => '148',
  'timestamp' => '1444945122',
))
->values(array(
  'aid' => '101',
  'sid' => 'FA1BMWZvsAAE1G-OBMzfiJyA12sh588cOKSmEmxFQiA',
  'title' => 'Languages',
  'path' => 'admin/config/regional/language/add',
  'url' => 'http://drupal7.local/admin/config/regional/language/add',
  'hostname' => '127.0.0.1',
  'uid' => '1',
  'timer' => '260',
  'timestamp' => '1444945153',
))
->values(array(
  'aid' => '102',
  'sid' => 'FA1BMWZvsAAE1G-OBMzfiJyA12sh588cOKSmEmxFQiA',
  'title' => 'Languages',
  'path' => 'admin/config/regional/language/add',
  'url' => '',
  'hostname' => '127.0.0.1',
  'uid' => '1',
  'timer' => '195',
  'timestamp' => '1444945160',
))
->values(array(
  'aid' => '103',
  'sid' => 'FA1BMWZvsAAE1G-OBMzfiJyA12sh588cOKSmEmxFQiA',
  'title' => 'Languages',
  'path' => 'admin/config/regional/language/add',
  'url' => 'http://drupal7.local/?q=admin/config/regional/language/add',
  'hostname' => '127.0.0.1',
  'uid' => '1',
  'timer' => '177',
  'timestamp' => '1444945168',
))
->values(array(
  'aid' => '104',
  'sid' => 'FA1BMWZvsAAE1G-OBMzfiJyA12sh588cOKSmEmxFQiA',
  'title' => 'Languages',
  'path' => 'admin/config/regional/language',
  'url' => 'http://drupal7.local/?q=admin/config/regional/language/add',
  'hostname' => '127.0.0.1',
  'uid' => '1',
  'timer' => '145',
  'timestamp' => '1444945168',
))
->values(array(
  'aid' => '105',
  'sid' => 'FA1BMWZvsAAE1G-OBMzfiJyA12sh588cOKSmEmxFQiA',
  'title' => 'Languages',
  'path' => 'admin/config/regional/language',
  'url' => '',
  'hostname' => '127.0.0.1',
  'uid' => '1',
  'timer' => '159',
  'timestamp' => '1444945175',
))
->values(array(
  'aid' => '106',
  'sid' => 'FA1BMWZvsAAE1G-OBMzfiJyA12sh588cOKSmEmxFQiA',
  'title' => 'Languages',
  'path' => 'admin/config/regional/language',
  'url' => 'http://drupal7.local/?q=admin/config/regional/language',
  'hostname' => '127.0.0.1',
  'uid' => '1',
  'timer' => '152',
  'timestamp' => '1444945176',
))
->values(array(
  'aid' => '107',
  'sid' => 'FA1BMWZvsAAE1G-OBMzfiJyA12sh588cOKSmEmxFQiA',
  'title' => 'Languages',
  'path' => 'admin/config/regional/language',
  'url' => 'http://drupal7.local/?q=admin/config/regional/language',
  'hostname' => '127.0.0.1',
  'uid' => '1',
  'timer' => '148',
  'timestamp' => '1444945176',
))
->values(array(
  'aid' => '108',
  'sid' => 'FA1BMWZvsAAE1G-OBMzfiJyA12sh588cOKSmEmxFQiA',
  'title' => 'Structure',
  'path' => 'admin/structure',
  'url' => 'http://drupal7.local/admin/config/regional/language',
  'hostname' => '127.0.0.1',
  'uid' => '1',
  'timer' => '156',
  'timestamp' => '1444945206',
))
->values(array(
  'aid' => '109',
  'sid' => 'FA1BMWZvsAAE1G-OBMzfiJyA12sh588cOKSmEmxFQiA',
  'title' => 'Content types',
  'path' => 'admin/structure/types',
  'url' => 'http://drupal7.local/admin/structure',
  'hostname' => '127.0.0.1',
  'uid' => '1',
  'timer' => '154',
  'timestamp' => '1444945208',
))
->values(array(
  'aid' => '110',
  'sid' => 'FA1BMWZvsAAE1G-OBMzfiJyA12sh588cOKSmEmxFQiA',
  'title' => 'Blog entry',
  'path' => 'admin/structure/types/manage/blog',
  'url' => 'http://drupal7.local/admin/structure/types',
  'hostname' => '127.0.0.1',
  'uid' => '1',
  'timer' => '203',
  'timestamp' => '1444945211',
))
->values(array(
  'aid' => '111',
  'sid' => 'FA1BMWZvsAAE1G-OBMzfiJyA12sh588cOKSmEmxFQiA',
  'title' => 'Parent menu items',
  'path' => 'admin/structure/menu/parents',
  'url' => 'http://drupal7.local/admin/structure/types/manage/blog',
  'hostname' => '127.0.0.1',
  'uid' => '1',
  'timer' => '211',
  'timestamp' => '1444945211',
))
->values(array(
  'aid' => '112',
  'sid' => 'FA1BMWZvsAAE1G-OBMzfiJyA12sh588cOKSmEmxFQiA',
  'title' => 'Blog entry',
  'path' => 'admin/structure/types/manage/blog',
  'url' => 'http://drupal7.local/admin/structure/types/manage/blog',
  'hostname' => '127.0.0.1',
  'uid' => '1',
  'timer' => '224',
  'timestamp' => '1444945236',
))
->values(array(
  'aid' => '113',
  'sid' => 'FA1BMWZvsAAE1G-OBMzfiJyA12sh588cOKSmEmxFQiA',
  'title' => 'Parent menu items',
  'path' => 'admin/structure/menu/parents',
  'url' => 'http://drupal7.local/admin/structure/types/manage/blog',
  'hostname' => '127.0.0.1',
  'uid' => '1',
  'timer' => '165',
  'timestamp' => '1444945237',
))
->values(array(
  'aid' => '114',
  'sid' => 'FA1BMWZvsAAE1G-OBMzfiJyA12sh588cOKSmEmxFQiA',
  'title' => 'Blog entry',
  'path' => 'admin/structure/types/manage/blog',
  'url' => '',
  'hostname' => '127.0.0.1',
  'uid' => '1',
  'timer' => '155',
  'timestamp' => '1444945242',
))
->values(array(
  'aid' => '115',
  'sid' => 'FA1BMWZvsAAE1G-OBMzfiJyA12sh588cOKSmEmxFQiA',
  'title' => 'Parent menu items',
  'path' => 'admin/structure/menu/parents',
  'url' => 'http://drupal7.local/?q=admin/structure/types/manage/blog',
  'hostname' => '127.0.0.1',
  'uid' => '1',
  'timer' => '217',
  'timestamp' => '1444945242',
))
->values(array(
  'aid' => '116',
  'sid' => 'FA1BMWZvsAAE1G-OBMzfiJyA12sh588cOKSmEmxFQiA',
  'title' => 'Blog entry',
  'path' => 'admin/structure/types/manage/blog',
  'url' => 'http://drupal7.local/?q=admin/structure/types/manage/blog',
  'hostname' => '127.0.0.1',
  'uid' => '1',
  'timer' => '667',
  'timestamp' => '1444945246',
))
->values(array(
  'aid' => '117',
  'sid' => 'FA1BMWZvsAAE1G-OBMzfiJyA12sh588cOKSmEmxFQiA',
  'title' => 'Content types',
  'path' => 'admin/structure/types',
  'url' => 'http://drupal7.local/?q=admin/structure/types/manage/blog',
  'hostname' => '127.0.0.1',
  'uid' => '1',
  'timer' => '149',
  'timestamp' => '1444945246',
))
->execute();

$connection->schema()->createTable('actions', array(
  'fields' => array(
    'aid' => array(
      'type' => 'varchar',
      'not null' => TRUE,
      'length' => '255',
      'default' => '0',
    ),
    'type' => array(
      'type' => 'varchar',
      'not null' => TRUE,
      'length' => '32',
      'default' => '',
    ),
    'callback' => array(
      'type' => 'varchar',
      'not null' => TRUE,
      'length' => '255',
      'default' => '',
    ),
    'parameters' => array(
      'type' => 'blob',
      'not null' => TRUE,
      'size' => 'normal',
    ),
    'label' => array(
      'type' => 'varchar',
      'not null' => TRUE,
      'length' => '255',
      'default' => '0',
    ),
  ),
  'primary key' => array(
    'aid',
  ),
  'mysql_character_set' => 'utf8',
));

$connection->insert('actions')
->fields(array(
  'aid',
  'type',
  'callback',
  'parameters',
  'label',
))
->values(array(
  '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(array(
  '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(array(
  '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(array(
  '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(array(
  '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(array(
  '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(array(
  'aid' => 'comment_publish_action',
  'type' => 'comment',
  'callback' => 'comment_publish_action',
  'parameters' => '',
  'label' => 'Publish comment',
))
->values(array(
  'aid' => 'comment_save_action',
  'type' => 'comment',
  'callback' => 'comment_save_action',
  'parameters' => '',
  'label' => 'Save comment',
))
->values(array(
  'aid' => 'comment_unpublish_action',
  'type' => 'comment',
  'callback' => 'comment_unpublish_action',
  'parameters' => '',
  'label' => 'Unpublish comment',
))
->values(array(
  'aid' => 'node_make_sticky_action',
  'type' => 'node',
  'callback' => 'node_make_sticky_action',
  'parameters' => '',
  'label' => 'Make content sticky',
))
->values(array(
  'aid' => 'node_make_unsticky_action',
  'type' => 'node',
  'callback' => 'node_make_unsticky_action',
  'parameters' => '',
  'label' => 'Make content unsticky',
))
->values(array(
  'aid' => 'node_promote_action',
  'type' => 'node',
  'callback' => 'node_promote_action',
  'parameters' => '',
  'label' => 'Promote content to front page',
))
->values(array(
  'aid' => 'node_publish_action',
  'type' => 'node',
  'callback' => 'node_publish_action',
  'parameters' => '',
  'label' => 'Publish content',
))
->values(array(
  'aid' => 'node_save_action',
  'type' => 'node',
  'callback' => 'node_save_action',
  'parameters' => '',
  'label' => 'Save content',
))
->values(array(
  'aid' => 'node_unpromote_action',
  'type' => 'node',
  'callback' => 'node_unpromote_action',
  'parameters' => '',
  'label' => 'Remove content from front page',
))
->values(array(
  'aid' => 'node_unpublish_action',
  'type' => 'node',
  'callback' => 'node_unpublish_action',
  'parameters' => '',
  'label' => 'Unpublish content',
))
->values(array(
  'aid' => 'system_block_ip_action',
  'type' => 'user',
  'callback' => 'system_block_ip_action',
  'parameters' => '',
  'label' => 'Ban IP address of current user',
))
->values(array(
  'aid' => 'user_block_user_action',
  'type' => 'user',
  'callback' => 'user_block_user_action',
  'parameters' => '',
  'label' => 'Block current user',
))
->execute();

$connection->schema()->createTable('aggregator_category', array(
  'fields' => array(
    'cid' => array(
      'type' => 'serial',
      'not null' => TRUE,
      'size' => 'normal',
    ),
    'title' => array(
      'type' => 'varchar',
      'not null' => TRUE,
      'length' => '255',
      'default' => '',
    ),
    'description' => array(
      'type' => 'text',
      'not null' => TRUE,
      'size' => 'normal',
    ),
    'block' => array(
      'type' => 'int',
      'not null' => TRUE,
      'size' => 'normal',
      'default' => '0',
    ),
  ),
  'primary key' => array(
    'cid',
  ),
  'mysql_character_set' => 'utf8',
));

$connection->schema()->createTable('aggregator_category_feed', array(
  'fields' => array(
    'fid' => array(
      'type' => 'int',
      'not null' => TRUE,
      'size' => 'normal',
      'default' => '0',
    ),
    'cid' => array(
      'type' => 'int',
      'not null' => TRUE,
      'size' => 'normal',
      'default' => '0',
    ),
  ),
  'primary key' => array(
    'fid',
    'cid',
  ),
  'mysql_character_set' => 'utf8',
));

$connection->schema()->createTable('aggregator_category_item', array(
  'fields' => array(
    'iid' => array(
      'type' => 'int',
      'not null' => TRUE,
      'size' => 'normal',
      'default' => '0',
    ),
    'cid' => array(
      'type' => 'int',
      'not null' => TRUE,
      'size' => 'normal',
      'default' => '0',
    ),
  ),
  'primary key' => array(
    'iid',
    'cid',
  ),
  'mysql_character_set' => 'utf8',
));

$connection->schema()->createTable('aggregator_feed', array(
  'fields' => array(
    'fid' => array(
      'type' => 'serial',
      'not null' => TRUE,
      'size' => 'normal',
    ),
    'title' => array(
      'type' => 'varchar',
      'not null' => TRUE,
      'length' => '255',
      'default' => '',
    ),
    'url' => array(
      'type' => 'text',
      'not null' => TRUE,
      'size' => 'normal',
    ),
    'refresh' => array(
      'type' => 'int',
      'not null' => TRUE,
      'size' => 'normal',
      'default' => '0',
    ),
    'checked' => array(
      'type' => 'int',
      'not null' => TRUE,
      'size' => 'normal',
      'default' => '0',
    ),
    'queued' => array(
      'type' => 'int',
      'not null' => TRUE,
      'size' => 'normal',
      'default' => '0',
    ),
    'link' => array(
      'type' => 'text',
      'not null' => TRUE,
      'size' => 'normal',
    ),
    'description' => array(
      'type' => 'text',
      'not null' => TRUE,
      'size' => 'normal',
    ),
    'image' => array(
      'type' => 'text',
      'not null' => TRUE,
      'size' => 'normal',
    ),
    'hash' => array(
      'type' => 'varchar',
      'not null' => TRUE,
      'length' => '64',
      'default' => '',
    ),
    'etag' => array(
      'type' => 'varchar',
      'not null' => TRUE,
      'length' => '255',
      'default' => '',
    ),
    'modified' => array(
      'type' => 'int',
      'not null' => TRUE,
      'size' => 'normal',
      'default' => '0',
    ),
    'block' => array(
      'type' => 'int',
      'not null' => TRUE,
      'size' => 'normal',
      'default' => '0',
    ),
  ),
  'primary key' => array(
    'fid',
  ),
  'mysql_character_set' => 'utf8',
));

$connection->insert('aggregator_feed')
->fields(array(
  'fid',
  'title',
  'url',
  'refresh',
  'checked',
  'queued',
  'link',
  'description',
  'image',
  'hash',
  'etag',
  'modified',
  'block',