<?php

/**

 * @file

 * Filled installation of Drupal 6.17, for test purposes.

 *

 * This file was generated by the dump-database-d6.sh tool, from an

 * installation of Drupal 6, filled with data using the generate-d6-content.sh

 * tool. It has the following modules installed:

 *  - block

 *  - color

 *  - comment

 *  - dblog

 *  - filter

 *  - help

 *  - menu

 *  - node

 *  - path

 *  - poll

 *  - system

 *  - taxonomy

 *  - update

 *  - user

 */

db_create_table('access', array(

  'fields' => array(

    'aid' => array(

      'type' => 'serial',

      'not null' => TRUE,

    ),

    'mask' => array(

      'type' => 'varchar',

      'length' => 255,

      'not null' => TRUE,

      'default' => '',

    ),

    'type' => array(

      'type' => 'varchar',

      'length' => 255,

      'not null' => TRUE,

      'default' => '',

    ),

    'status' => array(

      'type' => 'int',

      'not null' => TRUE,

      'default' => 0,

      'size' => 'tiny',

    ),

  ),

  'primary key' => array(

    'aid',

  ),

  'module' => 'user',

  'name' => 'access',

));

db_create_table('actions', array(

  'fields' => array(

    'aid' => array(

      'type' => 'varchar',

      'length' => 255,

      'not null' => TRUE,

      'default' => '0',

    ),

    'type' => array(

      'type' => 'varchar',

      'length' => 32,

      'not null' => TRUE,

      'default' => '',

    ),

    'callback' => array(

      'type' => 'varchar',

      'length' => 255,

      'not null' => TRUE,

      'default' => '',

    ),

    'parameters' => array(

      'type' => 'text',

      'not null' => TRUE,

      'size' => 'big',

    ),

    'description' => array(

      'type' => 'varchar',

      'length' => 255,

      'not null' => TRUE,

      'default' => '0',

    ),

  ),

  'primary key' => array(

    'aid',

  ),

  'module' => 'system',

  'name' => 'actions',

));

db_insert('actions')->fields(array(

  'aid',

  'type',

  'callback',

  'parameters',

  'description',

))

->values(array(

  'aid' => 'comment_publish_action',

  'type' => 'comment',

  'callback' => 'comment_publish_action',

  'parameters' => '',

  'description' => 'Publish comment',

))

->values(array(

  'aid' => 'comment_unpublish_action',

  'type' => 'comment',

  'callback' => 'comment_unpublish_action',

  'parameters' => '',

  'description' => 'Unpublish comment',

))

->values(array(

  'aid' => 'node_make_sticky_action',

  'type' => 'node',

  'callback' => 'node_make_sticky_action',

  'parameters' => '',

  'description' => 'Make post sticky',

))

->values(array(

  'aid' => 'node_make_unsticky_action',

  'type' => 'node',

  'callback' => 'node_make_unsticky_action',

  'parameters' => '',

  'description' => 'Make post unsticky',

))

->values(array(

  'aid' => 'node_promote_action',

  'type' => 'node',

  'callback' => 'node_promote_action',

  'parameters' => '',

  'description' => 'Promote post to front page',

))

->values(array(

  'aid' => 'node_publish_action',

  'type' => 'node',

  'callback' => 'node_publish_action',

  'parameters' => '',

  'description' => 'Publish post',

))

->values(array(

  'aid' => 'node_save_action',

  'type' => 'node',

  'callback' => 'node_save_action',

  'parameters' => '',

  'description' => 'Save post',

))

->values(array(

  'aid' => 'node_unpromote_action',

  'type' => 'node',

  'callback' => 'node_unpromote_action',

  'parameters' => '',

  'description' => 'Remove post from front page',

))

->values(array(

  'aid' => 'node_unpublish_action',

  'type' => 'node',

  'callback' => 'node_unpublish_action',

  'parameters' => '',

  'description' => 'Unpublish post',

))

->values(array(

  'aid' => 'user_block_ip_action',

  'type' => 'user',

  'callback' => 'user_block_ip_action',

  'parameters' => '',

  'description' => 'Ban IP address of current user',

))

->values(array(

  'aid' => 'user_block_user_action',

  'type' => 'user',

  'callback' => 'user_block_user_action',

  'parameters' => '',

  'description' => 'Block current user',

))

->execute();

db_create_table('actions_aid', array(

  'fields' => array(

    'aid' => array(

      'type' => 'serial',

      'unsigned' => TRUE,

      'not null' => TRUE,

    ),

  ),

  'primary key' => array(

    'aid',

  ),

  'module' => 'system',

  'name' => 'actions_aid',

));

db_create_table('authmap', array(

  'fields' => array(

    'aid' => array(

      'type' => 'serial',

      'unsigned' => TRUE,

      'not null' => TRUE,

    ),

    'uid' => array(

      'type' => 'int',

      'not null' => TRUE,

      'default' => 0,

    ),

    'authname' => array(

      'type' => 'varchar',

      'length' => 128,

      'not null' => TRUE,

      'default' => '',

    ),

    'module' => array(

      'type' => 'varchar',

      'length' => 128,

      'not null' => TRUE,

      'default' => '',

    ),

  ),

  'unique keys' => array(

    'authname' => array(

      'authname',

    ),

  ),

  'primary key' => array(

    'aid',

  ),

  'module' => 'user',

  'name' => 'authmap',

));

db_create_table('batch', array(

  'fields' => array(

    'bid' => array(

      'type' => 'serial',

      'unsigned' => TRUE,

      'not null' => TRUE,

    ),

    'token' => array(

      'type' => 'varchar',

      'length' => 64,

      'not null' => TRUE,

    ),

    'timestamp' => array(

      'type' => 'int',

      'not null' => TRUE,

    ),

    'batch' => array(

      'type' => 'text',

      'not null' => FALSE,

      'size' => 'big',

    ),

  ),

  'primary key' => array(

    'bid',

  ),

  'indexes' => array(

    'token' => array(

      'token',

    ),

  ),

  'module' => 'system',

  'name' => 'batch',

));

db_create_table('blocks', array(

  'fields' => array(

    'bid' => array(

      'type' => 'serial',

      'not null' => TRUE,

    ),

    'module' => array(

      'type' => 'varchar',

      'length' => 64,

      'not null' => TRUE,

      'default' => '',

    ),

    'delta' => array(

      'type' => 'varchar',

      'length' => 32,

      'not null' => TRUE,

      'default' => '0',

    ),

    'theme' => array(

      'type' => 'varchar',

      'length' => 64,

      'not null' => TRUE,

      'default' => '',

    ),

    'status' => array(

      'type' => 'int',

      'not null' => TRUE,

      'default' => 0,

      'size' => 'tiny',

    ),

    'weight' => array(

      'type' => 'int',

      'not null' => TRUE,

      'default' => 0,

      'size' => 'tiny',

    ),

    'region' => array(

      'type' => 'varchar',

      'length' => 64,

      'not null' => TRUE,

      'default' => '',

    ),

    'custom' => array(

      'type' => 'int',

      'not null' => TRUE,

      'default' => 0,

      'size' => 'tiny',

    ),

    'throttle' => array(

      'type' => 'int',

      'not null' => TRUE,

      'default' => 0,

      'size' => 'tiny',

    ),

    'visibility' => array(

      'type' => 'int',

      'not null' => TRUE,

      'default' => 0,

      'size' => 'tiny',

    ),

    'pages' => array(

      'type' => 'text',

      'not null' => TRUE,

    ),

    'title' => array(

      'type' => 'varchar',

      'length' => 64,

      'not null' => TRUE,

      'default' => '',

    ),

    'cache' => array(

      'type' => 'int',

      'not null' => TRUE,

      'default' => 1,

      'size' => 'tiny',

    ),

  ),

  'primary key' => array(

    'bid',

  ),

  'unique keys' => array(

    'tmd' => array(

      'theme',

      'module',

      'delta',

    ),

  ),

  'indexes' => array(

    'list' => array(

      'theme',

      'status',

      'region',

      'weight',

      'module',

    ),

  ),

  'module' => 'block',

  'name' => 'blocks',

));

db_insert('blocks')->fields(array(

  'bid',

  'module',

  'delta',

  'theme',

  'status',

  'weight',

  'region',

  'custom',

  'throttle',

  'visibility',

  'pages',

  'title',

  'cache',

))

->values(array(

  'bid' => '1',

  'module' => 'user',

  'delta' => '0',

  'theme' => 'garland',

  'status' => '1',

  'weight' => '0',

  'region' => 'left',

  'custom' => '0',

  'throttle' => '0',

  'visibility' => '0',

  'pages' => '',

  'title' => '',

  'cache' => '-1',

))

->values(array(

  'bid' => '2',

  'module' => 'user',

  'delta' => '1',

  'theme' => 'garland',

  'status' => '1',

  'weight' => '0',

  'region' => 'left',

  'custom' => '0',

  'throttle' => '0',

  'visibility' => '0',

  'pages' => '',

  'title' => '',

  'cache' => '-1',

))

->values(array(

  'bid' => '3',

  'module' => 'system',

  'delta' => '0',

  'theme' => 'garland',

  'status' => '1',

  'weight' => '10',

  'region' => 'footer',

  'custom' => '0',

  'throttle' => '0',

  'visibility' => '0',

  'pages' => '',

  'title' => '',

  'cache' => '-1',

))

->execute();

db_create_table('blocks_roles', array(

  'fields' => array(

    'module' => array(

      'type' => 'varchar',

      'length' => 64,

      'not null' => TRUE,

    ),

    'delta' => array(

      'type' => 'varchar',

      'length' => 32,

      'not null' => TRUE,

    ),

    'rid' => array(

      'type' => 'int',

      'unsigned' => TRUE,

      'not null' => TRUE,

    ),

  ),

  'primary key' => array(

    'module',

    'delta',

    'rid',

  ),

  'indexes' => array(

    'rid' => array(

      'rid',

    ),

  ),

  'module' => 'block',

  'name' => 'blocks_roles',

));

db_create_table('boxes', array(

  'fields' => array(

    'bid' => array(

      'type' => 'serial',

      'unsigned' => TRUE,

      'not null' => TRUE,

    ),

    'body' => array(

      'type' => 'text',

      'not null' => FALSE,

      'size' => 'big',

    ),

    'info' => array(

      'type' => 'varchar',

      'length' => 128,

      'not null' => TRUE,

      'default' => '',

    ),

    'format' => array(

      'type' => 'int',

      'size' => 'small',

      'not null' => TRUE,

      'default' => 0,

    ),

  ),

  'unique keys' => array(

    'info' => array(

      'info',

    ),

  ),

  'primary key' => array(

    'bid',

  ),

  'module' => 'block',

  'name' => 'boxes',

));

db_create_table('cache', array(

  'fields' => array(

    'cid' => array(

      'type' => 'varchar',

      'length' => 255,

      'not null' => TRUE,

      'default' => '',

    ),

    'data' => array(

      'type' => 'blob',

      'not null' => FALSE,

      'size' => 'big',

    ),

    'expire' => array(

      'type' => 'int',

      'not null' => TRUE,

      'default' => 0,

    ),

    'created' => array(

      'type' => 'int',

      'not null' => TRUE,

      'default' => 0,

    ),

    'headers' => array(

      'type' => 'text',

      'not null' => FALSE,

    ),

    'serialized' => array(

      'type' => 'int',

      'size' => 'small',

      'not null' => TRUE,

      'default' => 0,