array( 'aid' => array( 'type' => 'serial', 'not null' => TRUE, ), 'sid' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', ), 'title' => array( 'type' => 'varchar', 'length' => 255, 'not null' => FALSE, ), 'path' => array( 'type' => 'varchar', 'length' => 255, 'not null' => FALSE, ), 'url' => array( 'type' => 'text', 'not null' => FALSE, ), 'hostname' => array( 'type' => 'varchar', 'length' => 128, 'not null' => FALSE, ), 'uid' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => FALSE, 'default' => 0, ), 'timer' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0, ), 'timestamp' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0, ), ), 'indexes' => array( 'accesslog_timestamp' => array( 'timestamp', ), 'uid' => array( 'uid', ), ), 'primary key' => array( 'aid', ), 'foreign keys' => array( 'visitor' => array( 'table' => 'users', 'columns' => array( 'uid' => 'uid', ), ), ), 'module' => 'statistics', 'name' => 'accesslog', )); 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' => 'blob', 'not null' => TRUE, 'size' => 'big', ), 'label' => 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', 'label', )) ->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(); db_create_table('aggregator_category', array( 'fields' => array( 'cid' => array( 'type' => 'serial', 'not null' => TRUE, ), 'title' => array( 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => '', ), 'description' => array( 'type' => 'text', 'not null' => TRUE, 'size' => 'big', ), 'block' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, 'size' => 'tiny', ), ), 'primary key' => array( 'cid', ), 'unique keys' => array( 'title' => array( 'title', ), ), 'module' => 'aggregator', 'name' => 'aggregator_category', )); db_create_table('aggregator_category_feed', array( 'fields' => array( 'fid' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, ), 'cid' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, ), ), 'primary key' => array( 'cid', 'fid', ), 'indexes' => array( 'fid' => array( 'fid', ), ), 'foreign keys' => array( 'aggregator_category' => array( 'table' => 'aggregator_category', 'columns' => array( 'cid' => 'cid', ), ), ), 'module' => 'aggregator', 'name' => 'aggregator_category_feed', )); db_create_table('aggregator_category_item', array( 'fields' => array( 'iid' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, ), 'cid' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, ), ), 'primary key' => array( 'cid', 'iid', ), 'indexes' => array( 'iid' => array( 'iid', ), ), 'foreign keys' => array( 'aggregator_category' => array( 'table' => 'aggregator_category', 'columns' => array( 'cid' => 'cid', ), ), ), 'module' => 'aggregator', 'name' => 'aggregator_category_item', )); db_create_table('aggregator_feed', array( 'fields' => array( 'fid' => array( 'type' => 'serial', 'not null' => TRUE, ), 'title' => array( 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => '', ), 'url' => array( 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => '', ), 'refresh' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, ), 'checked' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, ), 'queued' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, ), 'link' => array( 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => '', ), 'description' => array( 'type' => 'text', 'not null' => TRUE, 'size' => 'big', ), 'image' => array( 'type' => 'text', 'not null' => TRUE, 'size' => 'big', ), 'hash' => array( 'type' => 'varchar', 'length' => 64, 'not null' => TRUE, 'default' => '', ), 'etag' => array( 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => '', ), 'modified' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, ), 'block' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, 'size' => 'tiny', ), ), 'primary key' => array( 'fid', ), 'unique keys' => array( 'url' => array( 'url', ), 'title' => array( 'title', ), ), 'indexes' => array( 'queued' => array( 'queued', ), ), 'module' => 'aggregator', 'name' => 'aggregator_feed', )); db_create_table('aggregator_item', array( 'fields' => array( 'iid' => array( 'type' => 'serial', 'not null' => TRUE, ), 'fid' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, ), 'title' => array( 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => '', ), 'link' => array( 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => '', ), 'author' => array( 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => '', ), 'description' => array( 'type' => 'text', 'not null' => TRUE, 'size' => 'big', ), 'timestamp' => array( 'type' => 'int', 'not null' => FALSE, ), 'guid' => array( 'type' => 'varchar', 'length' => 255, 'not null' => FALSE, ), ), 'primary key' => array( 'iid', ), 'indexes' => array( 'fid' => array( 'fid', ), ), 'foreign keys' => array( 'aggregator_feed' => array( 'table' => 'aggregator_feed', 'columns' => array( 'fid' => 'fid', ), ), ), 'module' => 'aggregator', 'name' => 'aggregator_item', )); 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', ), 'foreign keys' => array( 'user' => array( 'table' => 'users', 'columns' => array( 'uid' => 'uid', ), ), ), 'module' => 'user', 'name' => 'authmap', )); db_create_table('batch', array( 'fields' => array( 'bid' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, ), 'token' => array( 'type' => 'varchar', 'length' => 64, 'not null' => TRUE, ), 'timestamp' => array( 'type' => 'int', 'not null' => TRUE, ), 'batch' => array( 'type' => 'blob', 'not null' => FALSE, 'size' => 'big', ), ), 'primary key' => array( 'bid', ), 'indexes' => array( 'token' => array( 'token', ), ), 'module' => 'system', 'name' => 'batch', )); db_create_table('block', 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, ), 'region' => array( 'type' => 'varchar', 'length' => 64, 'not null' => TRUE, 'default' => '', ), 'custom' => 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' => '', 'translatable' => TRUE, ), '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' => 'block', )); db_insert('block')->fields(array( 'bid', 'module', 'delta', 'theme', 'status', 'weight', 'region', 'custom', 'visibility', 'pages', 'title', 'cache', )) ->values(array( 'bid' => '1', 'module' => 'system', 'delta' => 'main', 'theme' => 'bartik', 'status' => '1', 'weight' => '0', 'region' => 'content', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', )) ->values(array( 'bid' => '2', 'module' => 'search', 'delta' => 'form', 'theme' => 'bartik', 'status' => '1', 'weight' => '-1', 'region' => 'sidebar_first', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', )) ->values(array( 'bid' => '3', 'module' => 'node', 'delta' => 'recent', 'theme' => 'seven', 'status' => '1', 'weight' => '10', 'region' => 'dashboard_main', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', )) ->values(array( 'bid' => '4', 'module' => 'user', 'delta' => 'login', 'theme' => 'bartik', 'status' => '1', 'weight' => '0', 'region' => 'sidebar_first', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', )) ->values(array( 'bid' => '5', 'module' => 'system', 'delta' => 'navigation', 'theme' => 'bartik', 'status' => '1', 'weight' => '0', 'region' => 'sidebar_first', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', )) ->values(array( 'bid' => '6', 'module' => 'system', 'delta' => 'powered-by', 'theme' => 'bartik', 'status' => '1', 'weight' => '10', 'region' => 'footer', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', )) ->values(array( 'bid' => '7', 'module' => 'system', 'delta' => 'help', 'theme' => 'bartik', 'status' => '1', 'weight' => '0', 'region' => 'help', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', )) ->values(array( 'bid' => '8', 'module' => 'system', 'delta' => 'main', 'theme' => 'seven', 'status' => '1', 'weight' => '0', 'region' => 'content', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', )) ->values(array( 'bid' => '9', 'module' => 'system', 'delta' => 'help', 'theme' => 'seven', 'status' => '1', 'weight' => '0', 'region' => 'help', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', )) ->values(array( 'bid' => '10', 'module' => 'user', 'delta' => 'login', 'theme' => 'seven', 'status' => '1', 'weight' => '10', 'region' => 'content', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', )) ->values(array( 'bid' => '11', 'module' => 'user', 'delta' => 'new', 'theme' => 'seven', 'status' => '1', 'weight' => '0', 'region' => 'dashboard_sidebar', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', )) ->values(array( 'bid' => '12', 'module' => 'search', 'delta' => 'form', 'theme' => 'seven', 'status' => '1', 'weight' => '-10', 'region' => 'dashboard_sidebar', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', )) ->values(array( 'bid' => '13', 'module' => 'comment', 'delta' => 'recent', 'theme' => 'bartik', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '1', )) ->values(array( 'bid' => '14', 'module' => 'node', 'delta' => 'syndicate', 'theme' => 'bartik', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', )) ->values(array( 'bid' => '15', 'module' => 'node', 'delta' => 'recent', 'theme' => 'bartik', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '1', )) ->values(array( 'bid' => '16', 'module' => 'shortcut', 'delta' => 'shortcuts', 'theme' => 'bartik', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', )) ->values(array( 'bid' => '17', 'module' => 'system', 'delta' => 'management', 'theme' => 'bartik', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', )) ->values(array( 'bid' => '18', 'module' => 'system', 'delta' => 'user-menu', 'theme' => 'bartik', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', )) ->values(array( 'bid' => '19', 'module' => 'system', 'delta' => 'main-menu', 'theme' => 'bartik', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', )) ->values(array( 'bid' => '20', 'module' => 'user', 'delta' => 'new', 'theme' => 'bartik', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '1', )) ->values(array( 'bid' => '21', 'module' => 'user', 'delta' => 'online', 'theme' => 'bartik', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', )) ->values(array( 'bid' => '22', 'module' => 'comment', 'delta' => 'recent', 'theme' => 'seven', 'status' => '1', 'weight' => '0', 'region' => 'dashboard_inactive', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '1', )) ->values(array( 'bid' => '23', 'module' => 'node', 'delta' => 'syndicate', 'theme' => 'seven', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', )) ->values(array( 'bid' => '24', 'module' => 'shortcut', 'delta' => 'shortcuts', 'theme' => 'seven', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', )) ->values(array( 'bid' => '25', 'module' => 'system', 'delta' => 'powered-by', 'theme' => 'seven', 'status' => '0', 'weight' => '10', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', )) ->values(array( 'bid' => '26', 'module' => 'system', 'delta' => 'navigation', 'theme' => 'seven', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', )) ->values(array( 'bid' => '27', 'module' => 'system', 'delta' => 'management', 'theme' => 'seven', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', )) ->values(array( 'bid' => '28', 'module' => 'system', 'delta' => 'user-menu', 'theme' => 'seven', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', )) ->values(array( 'bid' => '29', 'module' => 'system', 'delta' => 'main-menu', 'theme' => 'seven', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', )) ->values(array( 'bid' => '30', 'module' => 'user', 'delta' => 'online', 'theme' => 'seven', 'status' => '1', 'weight' => '0', 'region' => 'dashboard_inactive', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', )) ->values(array( 'bid' => '31', 'module' => 'blog', 'delta' => 'recent', 'theme' => 'bartik', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '1', )) ->values(array( 'bid' => '32', 'module' => 'book', 'delta' => 'navigation', 'theme' => 'bartik', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '5', )) ->values(array( 'bid' => '33', 'module' => 'locale', 'delta' => 'language', 'theme' => 'bartik', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', )) ->values(array( 'bid' => '34', 'module' => 'poll', 'delta' => 'recent', 'theme' => 'bartik', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '1', )) ->values(array( 'bid' => '35', 'module' => 'forum', 'delta' => 'active', 'theme' => 'bartik', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-2', )) ->values(array( 'bid' => '36', 'module' => 'forum', 'delta' => 'new', 'theme' => 'bartik', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-2', )) ->values(array( 'bid' => '37', 'module' => 'blog', 'delta' => 'recent', 'theme' => 'seven', 'status' => '1', 'weight' => '0', 'region' => 'dashboard_inactive', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '1', )) ->values(array( 'bid' => '38', 'module' => 'book', 'delta' => 'navigation', 'theme' => 'seven', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '5', )) ->values(array( 'bid' => '39', 'module' => 'locale', 'delta' => 'language', 'theme' => 'seven', 'status' => '0', 'weight' => '0', 'region' => '-1', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-1', )) ->values(array( 'bid' => '40', 'module' => 'poll', 'delta' => 'recent', 'theme' => 'seven', 'status' => '1', 'weight' => '0', 'region' => 'dashboard_inactive', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '1', )) ->values(array( 'bid' => '41', 'module' => 'forum', 'delta' => 'active', 'theme' => 'seven', 'status' => '1', 'weight' => '0', 'region' => 'dashboard_inactive', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-2', )) ->values(array( 'bid' => '42', 'module' => 'forum', 'delta' => 'new', 'theme' => 'seven', 'status' => '1', 'weight' => '0', 'region' => 'dashboard_inactive', 'custom' => '0', 'visibility' => '0', 'pages' => '', 'title' => '', 'cache' => '-2', )) ->execute(); db_create_table('block_custom', array( 'fields' => array( 'bid' => array( 'type' => 'serial', 'unsigned' => TRUE, 'not null' => TRUE, ), 'body' => array( 'type' => 'text', 'not null' => FALSE, 'size' => 'big', 'translatable' => TRUE, ), 'info' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', ), 'format' => array( 'type' => 'varchar', 'length' => 255, 'not null' => FALSE, ), ), 'unique keys' => array( 'info' => array( 'info', ), ), 'primary key' => array( 'bid', ), 'module' => 'block', 'name' => 'block_custom', )); db_create_table('block_node_type', array( 'fields' => array( 'module' => array( 'type' => 'varchar', 'length' => 64, 'not null' => TRUE, ), 'delta' => array( 'type' => 'varchar', 'length' => 32, 'not null' => TRUE, ), 'type' => array( 'type' => 'varchar', 'length' => 32, 'not null' => TRUE, ), ), 'primary key' => array( 'module', 'delta', 'type', ), 'indexes' => array( 'type' => array( 'type', ), ), 'module' => 'node', 'name' => 'block_node_type', )); db_create_table('block_role', 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' => 'block_role', )); db_create_table('blocked_ips', array( 'fields' => array( 'iid' => array( 'type' => 'serial', 'unsigned' => TRUE, 'not null' => TRUE, ), 'ip' => array( 'type' => 'varchar', 'length' => 40, 'not null' => TRUE, 'default' => '', ), ), 'indexes' => array( 'blocked_ip' => array( 'ip', ), ), 'primary key' => array( 'iid', ), 'module' => 'system', 'name' => 'blocked_ips', )); db_create_table('book', array( 'fields' => array( 'mlid' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0, ), 'nid' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0, ), 'bid' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0, ), ), 'primary key' => array( 'mlid', ), 'unique keys' => array( 'nid' => array( 'nid', ), ), 'indexes' => array( 'bid' => array( 'bid', ), ), 'module' => 'book', 'name' => 'book', )); 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, ), 'serialized' => array( 'type' => 'int', 'size' => 'small', 'not null' => TRUE, 'default' => 0, ), ), 'indexes' => array( 'expire' => array( 'expire', ), ), 'primary key' => array( 'cid', ), 'module' => 'system', 'name' => 'cache', )); db_create_table('cache_block', 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, ), 'serialized' => array( 'type' => 'int', 'size' => 'small', 'not null' => TRUE, 'default' => 0, ), ), 'indexes' => array( 'expire' => array( 'expire', ), ), 'primary key' => array( 'cid', ), 'module' => 'block', 'name' => 'cache_block', )); db_create_table('cache_bootstrap', 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, ), 'serialized' => array( 'type' => 'int', 'size' => 'small', 'not null' => TRUE, 'default' => 0, ), ), 'indexes' => array( 'expire' => array( 'expire', ), ), 'primary key' => array( 'cid', ), 'module' => 'system', 'name' => 'cache_bootstrap', )); db_create_table('cache_field', 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, ), 'serialized' => array( 'type' => 'int', 'size' => 'small', 'not null' => TRUE, 'default' => 0, ), ), 'indexes' => array( 'expire' => array( 'expire', ), ), 'primary key' => array( 'cid', ), 'module' => 'field', 'name' => 'cache_field', )); db_create_table('cache_filter', 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, ), 'serialized' => array( 'type' => 'int', 'size' => 'small', 'not null' => TRUE, 'default' => 0, ), ), 'indexes' => array( 'expire' => array( 'expire', ), ), 'primary key' => array( 'cid', ), 'module' => 'filter', 'name' => 'cache_filter', )); db_create_table('cache_form', 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, ), 'serialized' => array( 'type' => 'int', 'size' => 'small', 'not null' => TRUE, 'default' => 0, ), ), 'indexes' => array( 'expire' => array( 'expire', ), ), 'primary key' => array( 'cid', ), 'module' => 'system', 'name' => 'cache_form', )); db_create_table('cache_image', 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, ), 'serialized' => array( 'type' => 'int', 'size' => 'small', 'not null' => TRUE, 'default' => 0, ), ), 'indexes' => array( 'expire' => array( 'expire', ), ), 'primary key' => array( 'cid', ), 'module' => 'image', 'name' => 'cache_image', )); db_create_table('cache_menu', 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, ), 'serialized' => array( 'type' => 'int', 'size' => 'small', 'not null' => TRUE, 'default' => 0, ), ), 'indexes' => array( 'expire' => array( 'expire', ), ), 'primary key' => array( 'cid', ), 'module' => 'system', 'name' => 'cache_menu', )); db_create_table('cache_page', 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, ), 'serialized' => array( 'type' => 'int', 'size' => 'small', 'not null' => TRUE, 'default' => 0, ), ), 'indexes' => array( 'expire' => array( 'expire', ), ), 'primary key' => array( 'cid', ), 'module' => 'system', 'name' => 'cache_page', )); db_create_table('cache_path', 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, ), 'serialized' => array( 'type' => 'int', 'size' => 'small', 'not null' => TRUE, 'default' => 0, ), ), 'indexes' => array( 'expire' => array( 'expire', ), ), 'primary key' => array( 'cid', ), 'module' => 'system', 'name' => 'cache_path', )); db_create_table('cache_update', 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, ), 'serialized' => array( 'type' => 'int', 'size' => 'small', 'not null' => TRUE, 'default' => 0, ), ), 'indexes' => array( 'expire' => array( 'expire', ), ), 'primary key' => array( 'cid', ), 'module' => 'update', 'name' => 'cache_update', )); db_create_table('comment', array( 'fields' => array( 'cid' => array( 'type' => 'serial', 'not null' => TRUE, ), 'pid' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, ), 'nid' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, ), 'uid' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, ), 'subject' => array( 'type' => 'varchar', 'length' => 64, 'not null' => TRUE, 'default' => '', ), 'hostname' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', ), 'created' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, ), 'changed' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, ), 'status' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 1, 'size' => 'tiny', ), 'thread' => array( 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, ), 'name' => array( 'type' => 'varchar', 'length' => 60, 'not null' => FALSE, ), 'mail' => array( 'type' => 'varchar', 'length' => 64, 'not null' => FALSE, ), 'homepage' => array( 'type' => 'varchar', 'length' => 255, 'not null' => FALSE, ), 'language' => array( 'type' => 'varchar', 'length' => 12, 'not null' => TRUE, 'default' => '', ), ), 'indexes' => array( 'comment_status_pid' => array( 'pid', 'status', ), 'comment_num_new' => array( 'nid', 'status', 'created', 'cid', 'thread', ), 'comment_uid' => array( 'uid', ), 'comment_nid_language' => array( 'nid', 'language', ), ), 'primary key' => array( 'cid', ), 'foreign keys' => array( 'comment_node' => array( 'table' => 'node', 'columns' => array( 'nid' => 'nid', ), ), 'comment_author' => array( 'table' => 'users', 'columns' => array( 'uid' => 'uid', ), ), ), 'module' => 'comment', 'name' => 'comment', )); db_create_table('contact', array( 'fields' => array( 'cid' => array( 'type' => 'serial', 'unsigned' => TRUE, 'not null' => TRUE, ), 'category' => array( 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => '', 'translatable' => TRUE, ), 'recipients' => array( 'type' => 'text', 'not null' => TRUE, 'size' => 'big', ), 'reply' => array( 'type' => 'text', 'not null' => TRUE, 'size' => 'big', ), 'weight' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, ), 'selected' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, 'size' => 'tiny', ), ), 'primary key' => array( 'cid', ), 'unique keys' => array( 'category' => array( 'category', ), ), 'indexes' => array( 'list' => array( 'weight', 'category', ), ), 'module' => 'contact', 'name' => 'contact', )); db_insert('contact')->fields(array( 'cid', 'category', 'recipients', 'reply', 'weight', 'selected', )) ->values(array( 'cid' => '1', 'category' => 'Website feedback', 'recipients' => 'admin@example.com', 'reply' => '', 'weight' => '0', 'selected' => '1', )) ->execute(); db_create_table('date_format_locale', array( 'fields' => array( 'format' => array( 'type' => 'varchar', 'length' => 100, 'not null' => TRUE, ), 'type' => array( 'type' => 'varchar', 'length' => 64, 'not null' => TRUE, ), 'language' => array( 'type' => 'varchar', 'length' => 12, 'not null' => TRUE, ), ), 'primary key' => array( 'type', 'language', ), 'module' => 'system', 'name' => 'date_format_locale', )); db_create_table('date_format_type', array( 'fields' => array( 'type' => array( 'type' => 'varchar', 'length' => 64, 'not null' => TRUE, ), 'title' => array( 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, ), 'locked' => array( 'type' => 'int', 'size' => 'tiny', 'default' => 0, 'not null' => TRUE, ), ), 'primary key' => array( 'type', ), 'indexes' => array( 'title' => array( 'title', ), ), 'module' => 'system', 'name' => 'date_format_type', )); db_insert('date_format_type')->fields(array( 'type', 'title', 'locked', )) ->values(array( 'type' => 'long', 'title' => 'Long', 'locked' => '1', )) ->values(array( 'type' => 'medium', 'title' => 'Medium', 'locked' => '1', )) ->values(array( 'type' => 'short', 'title' => 'Short', 'locked' => '1', )) ->execute(); db_create_table('date_formats', array( 'fields' => array( 'dfid' => array( 'type' => 'serial', 'not null' => TRUE, 'unsigned' => TRUE, ), 'format' => array( 'type' => 'varchar', 'length' => 100, 'not null' => TRUE, ), 'type' => array( 'type' => 'varchar', 'length' => 64, 'not null' => TRUE, ), 'locked' => array( 'type' => 'int', 'size' => 'tiny', 'default' => 0, 'not null' => TRUE, ), ), 'primary key' => array( 'dfid', ), 'unique keys' => array( 'formats' => array( 'format', 'type', ), ), 'module' => 'system', 'name' => 'date_formats', )); db_insert('date_formats')->fields(array( 'dfid', 'format', 'type', 'locked', )) ->values(array( 'dfid' => '1', 'format' => 'Y-m-d H:i', 'type' => 'short', 'locked' => '1', )) ->values(array( 'dfid' => '2', 'format' => 'm/d/Y - H:i', 'type' => 'short', 'locked' => '1', )) ->values(array( 'dfid' => '3', 'format' => 'd/m/Y - H:i', 'type' => 'short', 'locked' => '1', )) ->values(array( 'dfid' => '4', 'format' => 'Y/m/d - H:i', 'type' => 'short', 'locked' => '1', )) ->values(array( 'dfid' => '5', 'format' => 'd.m.Y - H:i', 'type' => 'short', 'locked' => '1', )) ->values(array( 'dfid' => '6', 'format' => 'm/d/Y - g:ia', 'type' => 'short', 'locked' => '1', )) ->values(array( 'dfid' => '7', 'format' => 'd/m/Y - g:ia', 'type' => 'short', 'locked' => '1', )) ->values(array( 'dfid' => '8', 'format' => 'Y/m/d - g:ia', 'type' => 'short', 'locked' => '1', )) ->values(array( 'dfid' => '9', 'format' => 'M j Y - H:i', 'type' => 'short', 'locked' => '1', )) ->values(array( 'dfid' => '10', 'format' => 'j M Y - H:i', 'type' => 'short', 'locked' => '1', )) ->values(array( 'dfid' => '11', 'format' => 'Y M j - H:i', 'type' => 'short', 'locked' => '1', )) ->values(array( 'dfid' => '12', 'format' => 'M j Y - g:ia', 'type' => 'short', 'locked' => '1', )) ->values(array( 'dfid' => '13', 'format' => 'j M Y - g:ia', 'type' => 'short', 'locked' => '1', )) ->values(array( 'dfid' => '14', 'format' => 'Y M j - g:ia', 'type' => 'short', 'locked' => '1', )) ->values(array( 'dfid' => '15', 'format' => 'D, Y-m-d H:i', 'type' => 'medium', 'locked' => '1', )) ->values(array( 'dfid' => '16', 'format' => 'D, m/d/Y - H:i', 'type' => 'medium', 'locked' => '1', )) ->values(array( 'dfid' => '17', 'format' => 'D, d/m/Y - H:i', 'type' => 'medium', 'locked' => '1', )) ->values(array( 'dfid' => '18', 'format' => 'D, Y/m/d - H:i', 'type' => 'medium', 'locked' => '1', )) ->values(array( 'dfid' => '19', 'format' => 'F j, Y - H:i', 'type' => 'medium', 'locked' => '1', )) ->values(array( 'dfid' => '20', 'format' => 'j F, Y - H:i', 'type' => 'medium', 'locked' => '1', )) ->values(array( 'dfid' => '21', 'format' => 'Y, F j - H:i', 'type' => 'medium', 'locked' => '1', )) ->values(array( 'dfid' => '22', 'format' => 'D, m/d/Y - g:ia', 'type' => 'medium', 'locked' => '1', )) ->values(array( 'dfid' => '23', 'format' => 'D, d/m/Y - g:ia', 'type' => 'medium', 'locked' => '1', )) ->values(array( 'dfid' => '24', 'format' => 'D, Y/m/d - g:ia', 'type' => 'medium', 'locked' => '1', )) ->values(array( 'dfid' => '25', 'format' => 'F j, Y - g:ia', 'type' => 'medium', 'locked' => '1', )) ->values(array( 'dfid' => '26', 'format' => 'j F Y - g:ia', 'type' => 'medium', 'locked' => '1', )) ->values(array( 'dfid' => '27', 'format' => 'Y, F j - g:ia', 'type' => 'medium', 'locked' => '1', )) ->values(array( 'dfid' => '28', 'format' => 'j. F Y - G:i', 'type' => 'medium', 'locked' => '1', )) ->values(array( 'dfid' => '29', 'format' => 'l, F j, Y - H:i', 'type' => 'long', 'locked' => '1', )) ->values(array( 'dfid' => '30', 'format' => 'l, j F, Y - H:i', 'type' => 'long', 'locked' => '1', )) ->values(array( 'dfid' => '31', 'format' => 'l, Y, F j - H:i', 'type' => 'long', 'locked' => '1', )) ->values(array( 'dfid' => '32', 'format' => 'l, F j, Y - g:ia', 'type' => 'long', 'locked' => '1', )) ->values(array( 'dfid' => '33', 'format' => 'l, j F Y - g:ia', 'type' => 'long', 'locked' => '1', )) ->values(array( 'dfid' => '34', 'format' => 'l, Y, F j - g:ia', 'type' => 'long', 'locked' => '1', )) ->values(array( 'dfid' => '35', 'format' => 'l, j. F Y - G:i', 'type' => 'long', 'locked' => '1', )) ->execute(); db_create_table('field_config', array( 'fields' => array( 'id' => array( 'type' => 'serial', 'not null' => TRUE, ), 'field_name' => array( 'type' => 'varchar', 'length' => 32, 'not null' => TRUE, ), 'type' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, ), 'module' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', ), 'active' => array( 'type' => 'int', 'size' => 'tiny', 'not null' => TRUE, 'default' => 0, ), 'storage_type' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, ), 'storage_module' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', ), 'storage_active' => array( 'type' => 'int', 'size' => 'tiny', 'not null' => TRUE, 'default' => 0, ), 'locked' => array( 'type' => 'int', 'size' => 'tiny', 'not null' => TRUE, 'default' => 0, ), 'data' => array( 'type' => 'blob', 'size' => 'big', 'not null' => TRUE, 'serialize' => TRUE, ), 'cardinality' => array( 'type' => 'int', 'size' => 'tiny', 'not null' => TRUE, 'default' => 0, ), 'translatable' => array( 'type' => 'int', 'size' => 'tiny', 'not null' => TRUE, 'default' => 0, ), 'deleted' => array( 'type' => 'int', 'size' => 'tiny', 'not null' => TRUE, 'default' => 0, ), ), 'primary key' => array( 'id', ), 'indexes' => array( 'field_name' => array( 'field_name', ), 'active' => array( 'active', ), 'storage_active' => array( 'storage_active', ), 'deleted' => array( 'deleted', ), 'module' => array( 'module', ), 'storage_module' => array( 'storage_module', ), 'type' => array( 'type', ), 'storage_type' => array( 'storage_type', ), ), 'module' => 'field', 'name' => 'field_config', )); db_insert('field_config')->fields(array( 'id', 'field_name', 'type', 'module', 'active', 'storage_type', 'storage_module', 'storage_active', 'locked', 'data', 'cardinality', 'translatable', 'deleted', )) ->values(array( '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(array( '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:1;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' => '1', 'deleted' => '0', )) ->values(array( '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:6:{s:8:"settings";a:1:{s:14:"allowed_values";a:1:{i:0;a:2:{s:10:"vocabulary";s:4:"tags";s:6:"parent";i:0;}}}s:12:"entity_types";a:0:{}s:12:"translatable";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: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";}}}', 'cardinality' => '-1', 'translatable' => '0', 'deleted' => '0', )) ->values(array( '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:12:"translatable";b:1;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:"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' => '1', 'deleted' => '0', )) ->values(array( 'id' => '5', 'field_name' => 'taxonomy_forums', '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:6:{s:8:"settings";a:1:{s:14:"allowed_values";a:1:{i:0;a:2:{s:10:"vocabulary";s:6:"forums";s:6:"parent";i:0;}}}s:12:"entity_types";a:0:{}s:12:"translatable";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: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";}}}', 'cardinality' => '1', 'translatable' => '0', 'deleted' => '0', )) ->execute(); db_create_table('field_config_instance', array( 'fields' => array( 'id' => array( 'type' => 'serial', 'not null' => TRUE, ), 'field_id' => array( 'type' => 'int', 'not null' => TRUE, ), 'field_name' => array( 'type' => 'varchar', 'length' => 32, 'not null' => TRUE, 'default' => '', ), 'entity_type' => array( 'type' => 'varchar', 'length' => 32, 'not null' => TRUE, 'default' => '', ), 'bundle' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', ), 'data' => array( 'type' => 'blob', 'size' => 'big', 'not null' => TRUE, 'serialize' => TRUE, ), 'deleted' => array( 'type' => 'int', 'size' => 'tiny', 'not null' => TRUE, 'default' => 0, ), ), 'primary key' => array( 'id', ), 'indexes' => array( 'field_name_bundle' => array( 'field_name', 'entity_type', 'bundle', ), 'deleted' => array( 'deleted', ), ), 'module' => 'field', 'name' => 'field_config_instance', )); db_insert('field_config_instance')->fields(array( 'id', 'field_id', 'field_name', 'entity_type', 'bundle', 'data', 'deleted', )) ->values(array( '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(array( 'id' => '2', 'field_id' => '2', 'field_name' => 'body', 'entity_type' => 'node', 'bundle' => 'page', 'data' => 'a:7:{s:5:"label";s:4:"Body";s:11:"widget_type";s:26:"text_textarea_with_summary";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: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:"required";b:0;s:11:"description";s:0:"";}', 'deleted' => '0', )) ->values(array( '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(array( 'id' => '4', 'field_id' => '2', 'field_name' => 'body', 'entity_type' => 'node', 'bundle' => 'article', 'data' => 'a:7:{s:5:"label";s:4:"Body";s:11:"widget_type";s:26:"text_textarea_with_summary";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: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:"required";b:0;s:11:"description";s:0:"";}', 'deleted' => '0', )) ->values(array( '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";i:-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:1:{s:18:"user_register_form";b:0;}s:8:"required";b:0;}', 'deleted' => '0', )) ->values(array( '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:8:{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:18:"user_register_form";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";i:-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(array( 'id' => '7', 'field_id' => '1', 'field_name' => 'comment_body', 'entity_type' => 'comment', 'bundle' => 'comment_node_book', '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(array( 'id' => '8', 'field_id' => '2', 'field_name' => 'body', 'entity_type' => 'node', 'bundle' => 'book', 'data' => 'a:7:{s:5:"label";s:4:"Body";s:11:"widget_type";s:26:"text_textarea_with_summary";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: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:"required";b:0;s:11:"description";s:0:"";}', 'deleted' => '0', )) ->values(array( 'id' => '9', '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(array( 'id' => '10', 'field_id' => '1', 'field_name' => 'comment_body', 'entity_type' => 'comment', 'bundle' => 'comment_node_poll', '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(array( 'id' => '11', 'field_id' => '2', 'field_name' => 'body', 'entity_type' => 'node', 'bundle' => 'blog', 'data' => 'a:7:{s:5:"label";s:4:"Body";s:11:"widget_type";s:26:"text_textarea_with_summary";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: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:"required";b:0;s:11:"description";s:0:"";}', 'deleted' => '0', )) ->values(array( 'id' => '12', 'field_id' => '5', 'field_name' => 'taxonomy_forums', 'entity_type' => 'node', 'bundle' => 'forum', 'data' => 'a:6:{s:5:"label";s:6:"Forums";s:8:"required";b:1;s:6:"widget";a:4:{s:4:"type";s:14:"options_select";s:8:"settings";a:0:{}s:6:"weight";i:0;s:6:"module";s:7:"options";}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:1:{s:18:"user_register_form";b:0;}s:11:"description";s:0:"";}', 'deleted' => '0', )) ->values(array( 'id' => '13', '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(array( 'id' => '14', 'field_id' => '2', 'field_name' => 'body', 'entity_type' => 'node', 'bundle' => 'forum', 'data' => 'a:7:{s:5:"label";s:4:"Body";s:11:"widget_type";s:26:"text_textarea_with_summary";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: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:"required";b:0;s:11:"description";s:0:"";}', 'deleted' => '0', )) ->execute(); db_create_table('field_data_body', array( 'fields' => array( 'entity_type' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', ), 'bundle' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', ), 'deleted' => array( 'type' => 'int', 'size' => 'tiny', 'not null' => TRUE, 'default' => 0, ), 'entity_id' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, ), 'revision_id' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => FALSE, ), 'language' => array( 'type' => 'varchar', 'length' => 32, 'not null' => TRUE, 'default' => '', ), 'delta' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, ), 'body_value' => array( 'type' => 'text', 'size' => 'big', 'not null' => FALSE, ), 'body_summary' => array( 'type' => 'text', 'size' => 'big', 'not null' => FALSE, ), 'body_format' => array( 'type' => 'varchar', 'length' => 255, 'not null' => FALSE, ), ), 'primary key' => array( 'entity_type', 'entity_id', 'deleted', 'delta', 'language', ), 'indexes' => array( 'entity_type' => array( 'entity_type', ), 'bundle' => array( 'bundle', ), 'deleted' => array( 'deleted', ), 'entity_id' => array( 'entity_id', ), 'revision_id' => array( 'revision_id', ), 'language' => array( 'language', ), 'body_format' => array( 'body_format', ), ), 'foreign keys' => array( 'body_format' => array( 'table' => 'filter_format', 'columns' => array( 'body_format' => 'format', ), ), ), 'module' => 'field_sql_storage', 'name' => 'field_data_body', )); db_create_table('field_data_comment_body', array( 'fields' => array( 'entity_type' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', ), 'bundle' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', ), 'deleted' => array( 'type' => 'int', 'size' => 'tiny', 'not null' => TRUE, 'default' => 0, ), 'entity_id' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, ), 'revision_id' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => FALSE, ), 'language' => array( 'type' => 'varchar', 'length' => 32, 'not null' => TRUE, 'default' => '', ), 'delta' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, ), 'comment_body_value' => array( 'type' => 'text', 'size' => 'big', 'not null' => FALSE, ), 'comment_body_format' => array( 'type' => 'varchar', 'length' => 255, 'not null' => FALSE, ), ), 'primary key' => array( 'entity_type', 'entity_id', 'deleted', 'delta', 'language', ), 'indexes' => array( 'entity_type' => array( 'entity_type', ), 'bundle' => array( 'bundle', ), 'deleted' => array( 'deleted', ), 'entity_id' => array( 'entity_id', ), 'revision_id' => array( 'revision_id', ), 'language' => array( 'language', ), 'comment_body_format' => array( 'comment_body_format', ), ), 'foreign keys' => array( 'comment_body_format' => array( 'table' => 'filter_format', 'columns' => array( 'comment_body_format' => 'format', ), ), ), 'module' => 'field_sql_storage', 'name' => 'field_data_comment_body', )); db_create_table('field_data_field_image', array( 'fields' => array( 'entity_type' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', ), 'bundle' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', ), 'deleted' => array( 'type' => 'int', 'size' => 'tiny', 'not null' => TRUE, 'default' => 0, ), 'entity_id' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, ), 'revision_id' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => FALSE, ), 'language' => array( 'type' => 'varchar', 'length' => 32, 'not null' => TRUE, 'default' => '', ), 'delta' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, ), 'field_image_fid' => array( 'type' => 'int', 'not null' => FALSE, 'unsigned' => TRUE, ), 'field_image_alt' => array( 'type' => 'varchar', 'length' => 128, 'not null' => FALSE, ), 'field_image_title' => array( 'type' => 'varchar', 'length' => 128, 'not null' => FALSE, ), ), 'primary key' => array( 'entity_type', 'entity_id', 'deleted', 'delta', 'language', ), 'indexes' => array( 'entity_type' => array( 'entity_type', ), 'bundle' => array( 'bundle', ), 'deleted' => array( 'deleted', ), 'entity_id' => array( 'entity_id', ), 'revision_id' => array( 'revision_id', ), 'language' => array( 'language', ), 'field_image_fid' => array( 'field_image_fid', ), ), 'foreign keys' => array( 'field_image_fid' => array( 'table' => 'file_managed', 'columns' => array( 'field_image_fid' => 'fid', ), ), ), 'module' => 'field_sql_storage', 'name' => 'field_data_field_image', )); db_create_table('field_data_field_tags', array( 'fields' => array( 'entity_type' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', ), 'bundle' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', ), 'deleted' => array( 'type' => 'int', 'size' => 'tiny', 'not null' => TRUE, 'default' => 0, ), 'entity_id' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, ), 'revision_id' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => FALSE, ), 'language' => array( 'type' => 'varchar', 'length' => 32, 'not null' => TRUE, 'default' => '', ), 'delta' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, ), 'field_tags_tid' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => FALSE, ), ), 'primary key' => array( 'entity_type', 'entity_id', 'deleted', 'delta', 'language', ), 'indexes' => array( 'entity_type' => array( 'entity_type', ), 'bundle' => array( 'bundle', ), 'deleted' => array( 'deleted', ), 'entity_id' => array( 'entity_id', ), 'revision_id' => array( 'revision_id', ), 'language' => array( 'language', ), 'field_tags_tid' => array( 'field_tags_tid', ), ), 'foreign keys' => array( 'field_tags_tid' => array( 'table' => 'taxonomy_term_data', 'columns' => array( 'field_tags_tid' => 'tid', ), ), ), 'module' => 'field_sql_storage', 'name' => 'field_data_field_tags', )); db_create_table('field_data_taxonomy_forums', array( 'fields' => array( 'entity_type' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', ), 'bundle' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', ), 'deleted' => array( 'type' => 'int', 'size' => 'tiny', 'not null' => TRUE, 'default' => 0, ), 'entity_id' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, ), 'revision_id' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => FALSE, ), 'language' => array( 'type' => 'varchar', 'length' => 32, 'not null' => TRUE, 'default' => '', ), 'delta' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, ), 'taxonomy_forums_tid' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => FALSE, ), ), 'primary key' => array( 'entity_type', 'entity_id', 'deleted', 'delta', 'language', ), 'indexes' => array( 'entity_type' => array( 'entity_type', ), 'bundle' => array( 'bundle', ), 'deleted' => array( 'deleted', ), 'entity_id' => array( 'entity_id', ), 'revision_id' => array( 'revision_id', ), 'language' => array( 'language', ), 'taxonomy_forums_tid' => array( 'taxonomy_forums_tid', ), ), 'foreign keys' => array( 'taxonomy_forums_tid' => array( 'table' => 'taxonomy_term_data', 'columns' => array( 'taxonomy_forums_tid' => 'tid', ), ), ), 'module' => 'field_sql_storage', 'name' => 'field_data_taxonomy_forums', )); db_create_table('field_revision_body', array( 'fields' => array( 'entity_type' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', ), 'bundle' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', ), 'deleted' => array( 'type' => 'int', 'size' => 'tiny', 'not null' => TRUE, 'default' => 0, ), 'entity_id' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, ), 'revision_id' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, ), 'language' => array( 'type' => 'varchar', 'length' => 32, 'not null' => TRUE, 'default' => '', ), 'delta' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, ), 'body_value' => array( 'type' => 'text', 'size' => 'big', 'not null' => FALSE, ), 'body_summary' => array( 'type' => 'text', 'size' => 'big', 'not null' => FALSE, ), 'body_format' => array( 'type' => 'varchar', 'length' => 255, 'not null' => FALSE, ), ), 'primary key' => array( 'entity_type', 'entity_id', 'revision_id', 'deleted', 'delta', 'language', ), 'indexes' => array( 'entity_type' => array( 'entity_type', ), 'bundle' => array( 'bundle', ), 'deleted' => array( 'deleted', ), 'entity_id' => array( 'entity_id', ), 'revision_id' => array( 'revision_id', ), 'language' => array( 'language', ), 'body_format' => array( 'body_format', ), ), 'foreign keys' => array( 'body_format' => array( 'table' => 'filter_format', 'columns' => array( 'body_format' => 'format', ), ), ), 'module' => 'field_sql_storage', 'name' => 'field_revision_body', )); db_create_table('field_revision_comment_body', array( 'fields' => array( 'entity_type' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', ), 'bundle' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', ), 'deleted' => array( 'type' => 'int', 'size' => 'tiny', 'not null' => TRUE, 'default' => 0, ), 'entity_id' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, ), 'revision_id' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, ), 'language' => array( 'type' => 'varchar', 'length' => 32, 'not null' => TRUE, 'default' => '', ), 'delta' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, ), 'comment_body_value' => array( 'type' => 'text', 'size' => 'big', 'not null' => FALSE, ), 'comment_body_format' => array( 'type' => 'varchar', 'length' => 255, 'not null' => FALSE, ), ), 'primary key' => array( 'entity_type', 'entity_id', 'revision_id', 'deleted', 'delta', 'language', ), 'indexes' => array( 'entity_type' => array( 'entity_type', ), 'bundle' => array( 'bundle', ), 'deleted' => array( 'deleted', ), 'entity_id' => array( 'entity_id', ), 'revision_id' => array( 'revision_id', ), 'language' => array( 'language', ), 'comment_body_format' => array( 'comment_body_format', ), ), 'foreign keys' => array( 'comment_body_format' => array( 'table' => 'filter_format', 'columns' => array( 'comment_body_format' => 'format', ), ), ), 'module' => 'field_sql_storage', 'name' => 'field_revision_comment_body', )); db_create_table('field_revision_field_image', array( 'fields' => array( 'entity_type' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', ), 'bundle' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', ), 'deleted' => array( 'type' => 'int', 'size' => 'tiny', 'not null' => TRUE, 'default' => 0, ), 'entity_id' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, ), 'revision_id' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, ), 'language' => array( 'type' => 'varchar', 'length' => 32, 'not null' => TRUE, 'default' => '', ), 'delta' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, ), 'field_image_fid' => array( 'type' => 'int', 'not null' => FALSE, 'unsigned' => TRUE, ), 'field_image_alt' => array( 'type' => 'varchar', 'length' => 128, 'not null' => FALSE, ), 'field_image_title' => array( 'type' => 'varchar', 'length' => 128, 'not null' => FALSE, ), ), 'primary key' => array( 'entity_type', 'entity_id', 'revision_id', 'deleted', 'delta', 'language', ), 'indexes' => array( 'entity_type' => array( 'entity_type', ), 'bundle' => array( 'bundle', ), 'deleted' => array( 'deleted', ), 'entity_id' => array( 'entity_id', ), 'revision_id' => array( 'revision_id', ), 'language' => array( 'language', ), 'field_image_fid' => array( 'field_image_fid', ), ), 'foreign keys' => array( 'field_image_fid' => array( 'table' => 'file_managed', 'columns' => array( 'field_image_fid' => 'fid', ), ), ), 'module' => 'field_sql_storage', 'name' => 'field_revision_field_image', )); db_create_table('field_revision_field_tags', array( 'fields' => array( 'entity_type' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', ), 'bundle' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', ), 'deleted' => array( 'type' => 'int', 'size' => 'tiny', 'not null' => TRUE, 'default' => 0, ), 'entity_id' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, ), 'revision_id' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, ), 'language' => array( 'type' => 'varchar', 'length' => 32, 'not null' => TRUE, 'default' => '', ), 'delta' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, ), 'field_tags_tid' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => FALSE, ), ), 'primary key' => array( 'entity_type', 'entity_id', 'revision_id', 'deleted', 'delta', 'language', ), 'indexes' => array( 'entity_type' => array( 'entity_type', ), 'bundle' => array( 'bundle', ), 'deleted' => array( 'deleted', ), 'entity_id' => array( 'entity_id', ), 'revision_id' => array( 'revision_id', ), 'language' => array( 'language', ), 'field_tags_tid' => array( 'field_tags_tid', ), ), 'foreign keys' => array( 'field_tags_tid' => array( 'table' => 'taxonomy_term_data', 'columns' => array( 'field_tags_tid' => 'tid', ), ), ), 'module' => 'field_sql_storage', 'name' => 'field_revision_field_tags', )); db_create_table('field_revision_taxonomy_forums', array( 'fields' => array( 'entity_type' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', ), 'bundle' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', ), 'deleted' => array( 'type' => 'int', 'size' => 'tiny', 'not null' => TRUE, 'default' => 0, ), 'entity_id' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, ), 'revision_id' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, ), 'language' => array( 'type' => 'varchar', 'length' => 32, 'not null' => TRUE, 'default' => '', ), 'delta' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, ), 'taxonomy_forums_tid' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => FALSE, ), ), 'primary key' => array( 'entity_type', 'entity_id', 'revision_id', 'deleted', 'delta', 'language', ), 'indexes' => array( 'entity_type' => array( 'entity_type', ), 'bundle' => array( 'bundle', ), 'deleted' => array( 'deleted', ), 'entity_id' => array( 'entity_id', ), 'revision_id' => array( 'revision_id', ), 'language' => array( 'language', ), 'taxonomy_forums_tid' => array( 'taxonomy_forums_tid', ), ), 'foreign keys' => array( 'taxonomy_forums_tid' => array( 'table' => 'taxonomy_term_data', 'columns' => array( 'taxonomy_forums_tid' => 'tid', ), ), ), 'module' => 'field_sql_storage', 'name' => 'field_revision_taxonomy_forums', )); db_create_table('file_managed', array( 'fields' => array( 'fid' => array( 'type' => 'serial', 'unsigned' => TRUE, 'not null' => TRUE, ), 'uid' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0, ), 'filename' => array( 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => '', ), 'uri' => array( 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => '', ), 'filemime' => array( 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => '', ), 'filesize' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0, ), 'status' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, 'size' => 'tiny', ), 'timestamp' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0, ), ), 'indexes' => array( 'uid' => array( 'uid', ), 'status' => array( 'status', ), 'timestamp' => array( 'timestamp', ), ), 'unique keys' => array( 'uri' => array( 'uri', ), ), 'primary key' => array( 'fid', ), 'foreign keys' => array( 'file_owner' => array( 'table' => 'users', 'columns' => array( 'uid' => 'uid', ), ), ), 'module' => 'system', 'name' => 'file_managed', )); db_create_table('file_usage', array( 'fields' => array( 'fid' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, ), 'module' => array( 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => '', ), 'type' => array( 'type' => 'varchar', 'length' => 64, 'not null' => TRUE, 'default' => '', ), 'id' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0, ), 'count' => array( 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0, ), ), 'primary key' => array( 'fid', 'type', 'id', 'module', ), 'indexes' => array( 'type_id' => array( 'type', 'id', ), 'fid_count' => array( 'fid', 'count', ), 'fid_module' => array( 'fid', 'module', ), ), 'module' => 'system', 'name' => 'file_usage', )); db_create_table('filter', array( 'fields' => array( 'format' => array( 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, ), 'module' => array( 'type' => 'varchar', 'length' => 64, 'not null' => TRUE, 'default' => '', ), 'name' => array( 'type' => 'varchar', 'length' => 32, 'not null' => TRUE, 'default' => '', ), 'weight' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, ), 'status' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, ), 'settings' => array( 'type' => 'blob', 'not null' => FALSE, 'size' => 'big', 'serialize' => TRUE, ), ), 'primary key' => array( 'format', 'name', ), 'indexes' => array( 'list' => array( 'weight', 'module', 'name', ), ), 'module' => 'filter', 'name' => 'filter', )); db_insert('filter')->fields(array( 'format', 'module', 'name', 'weight', 'status', 'settings', )) ->values(array( 'format' => 'filtered_html', 'module' => 'filter', 'name' => 'filter_autop', 'weight' => '2', 'status' => '1', 'settings' => 'a:0:{}', )) ->values(array( 'format' => 'filtered_html', 'module' => 'filter', 'name' => 'filter_html', 'weight' => '1', 'status' => '1', 'settings' => 'a:3:{s:12:"allowed_html";s:74:"