Biofeedback Newsletter Logo

National Library of Medicine celebrates 175 years of information innovation

  • user warning: Table './underdog2/cache' is marked as crashed and should be repaired query: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'schema' in /var/www/html/library/includes/cache.inc on line 26.
  • user warning: Table './underdog2/cache' is marked as crashed and should be repaired query: UPDATE cache SET data = 'a:82:{s:10:\"feedburner\";a:6:{s:11:\"description\";s:51:\"Stores information on FeedBurner feed redirections.\";s:6:\"fields\";a:2:{s:4:\"path\";a:4:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:128;s:8:\"not null\";b:1;s:11:\"description\";s:16:\"The source feed.\";}s:10:\"feedburner\";a:4:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:100;s:8:\"not null\";b:1;s:11:\"description\";s:16:\"FeedBurner feed.\";}}s:11:\"primary key\";a:1:{i:0;s:4:\"path\";}s:7:\"indexes\";a:1:{s:10:\"feedburner\";a:1:{i:0;s:10:\"feedburner\";}}s:6:\"module\";s:10:\"feedburner\";s:4:\"name\";s:10:\"feedburner\";}s:7:\"webform\";a:5:{s:11:\"description\";s:58:\"Table for storing additional properties for webform nodes.\";s:6:\"fields\";a:12:{s:3:\"nid\";a:4:{s:11:\"description\";s:32:\"The node identifier of a webform\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;}s:12:\"confirmation\";a:3:{s:11:\"description\";s:78:\"The confirmation message or URL displayed to the user after submitting a form.\";s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:1;}s:6:\"teaser\";a:5:{s:11:\"description\";s:76:\"Boolean value for whether the entire form should be displayed on the teaser.\";s:4:\"type\";s:3:\"int\";s:4:\"size\";s:4:\"tiny\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:11:\"submit_text\";a:3:{s:11:\"description\";s:43:\"The title of the submit button on the form.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;}s:12:\"submit_limit\";a:5:{s:11:\"description\";s:97:\"The number of submissions a single user is allowed to submit within an interval. -1 is unlimited.\";s:4:\"type\";s:3:\"int\";s:4:\"size\";s:4:\"tiny\";s:8:\"not null\";b:1;s:7:\"default\";i:-1;}s:15:\"submit_interval\";a:4:{s:11:\"description\";s:110:\"The amount of time in seconds that must pass before a user can submit another submission within the set limit.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:-1;}s:5:\"email\";a:3:{s:11:\"description\";s:60:\"The primary e-mail address for receiving submission results.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;}s:15:\"email_from_name\";a:3:{s:11:\"description\";s:50:\"The name of the sender in sent submission e-mails.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;}s:18:\"email_from_address\";a:3:{s:11:\"description\";s:53:\"The address of the sender in sent submission e-mails.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;}s:13:\"email_subject\";a:3:{s:11:\"description\";s:38:\"The subject of sent submission e-mails\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;}s:19:\"additional_validate\";a:3:{s:11:\"description\";s:61:\"PHP code for additional functionality when validating a form.\";s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:1;}s:17:\"additional_submit\";a:3:{s:11:\"description\";s:61:\"PHP code for additional functionality when submitting a form.\";s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:1;}}s:11:\"primary key\";a:1:{i:0;s:3:\"nid\";}s:6:\"module\";s:7:\"webform\";s:4:\"name\";s:7:\"webform\";}s:17:\"webform_component\";a:5:{s:11:\"description\";s:54:\"Stores information about components for webform nodes.\";s:6:\"fields\";a:11:{s:3:\"nid\";a:5:{s:11:\"description\";s:32:\"The node identifier of a webform\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:3:\"cid\";a:6:{s:11:\"description\";s:78:\"The identifier for this component within this node, starts at 0 for each node.\";s:4:\"type\";s:3:\"int\";s:4:\"size\";s:5:\"small\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:3:\"pid\";a:6:{s:11:\"description\";s:67:\"If this component has a parent fieldset, the cid of that component.\";s:4:\"type\";s:3:\"int\";s:4:\"size\";s:5:\"small\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:8:\"form_key\";a:3:{s:11:\"description\";s:88:\"When the form is displayed and processed, this key can be used to reference the results.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:128;}s:4:\"name\";a:3:{s:11:\"description\";s:29:\"The label for this component.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;}s:4:\"type\";a:3:{s:11:\"description\";s:67:\"The field type of this component (textfield, select, hidden, etc.).\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:16;}s:5:\"value\";a:3:{s:11:\"description\";s:66:\"The default value of the component when displayed to the end-user.\";s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:1;}s:5:\"extra\";a:3:{s:11:\"description\";s:77:\"Additional information unique to the display or processing of this component.\";s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:1;}s:9:\"mandatory\";a:5:{s:11:\"description\";s:47:\"Boolean flag for if this component is required.\";s:4:\"type\";s:3:\"int\";s:4:\"size\";s:4:\"tiny\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:5:\"email\";a:5:{s:11:\"description\";s:89:\"Boolean flag for if submitted values for this component will be included in sent e-mails.\";s:4:\"type\";s:3:\"int\";s:4:\"size\";s:4:\"tiny\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:6:\"weight\";a:5:{s:11:\"description\";s:54:\"Determines the position of this component in the form.\";s:4:\"type\";s:3:\"int\";s:4:\"size\";s:5:\"small\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}}s:11:\"primary key\";a:2:{i:0;s:3:\"nid\";i:1;s:3:\"cid\";}s:6:\"module\";s:7:\"webform\";s:4:\"name\";s:17:\"webform_component\";}s:13:\"webform_roles\";a:5:{s:11:\"description\";s:189:\"Holds access information regarding which roles are allowed to submit which webform nodes. Does not prevent access to the webform node entirely, use the {node_access} table for that purpose.\";s:6:\"fields\";a:2:{s:3:\"nid\";a:5:{s:11:\"description\";s:33:\"The node identifier of a webform.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:3:\"rid\";a:5:{s:11:\"description\";s:20:\"The role identifier.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}}s:11:\"primary key\";a:2:{i:0;s:3:\"nid\";i:1;s:3:\"rid\";}s:6:\"module\";s:7:\"webform\";s:4:\"name\";s:13:\"webform_roles\";}s:19:\"webform_submissions\";a:6:{s:11:\"description\";s:68:\"Holds general information about submissions outside of field values.\";s:6:\"fields\";a:5:{s:3:\"sid\";a:4:{s:11:\"description\";s:42:\"The unique identifier for this submission.\";s:4:\"type\";s:6:\"serial\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;}s:3:\"nid\";a:5:{s:11:\"description\";s:32:\"The node identifier of a webform\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:3:\"uid\";a:5:{s:11:\"description\";s:50:\"The id of the user that completed this submission.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:9:\"submitted\";a:4:{s:11:\"description\";s:41:\"Timestamp of when the form was submitted.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:11:\"remote_addr\";a:3:{s:11:\"description\";s:51:\"The IP address of the user that submitted the form.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:128;}}s:11:\"unique keys\";a:1:{s:7:\"sid_nid\";a:2:{i:0;s:3:\"sid\";i:1;s:3:\"nid\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"sid\";}s:6:\"module\";s:7:\"webform\";s:4:\"name\";s:19:\"webform_submissions\";}s:22:\"webform_submitted_data\";a:6:{s:11:\"description\";s:56:\"Stores all submitted field data for webform submissions.\";s:6:\"fields\";a:5:{s:3:\"nid\";a:5:{s:11:\"description\";s:32:\"The node identifier of a webform\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:3:\"sid\";a:5:{s:11:\"description\";s:42:\"The unique identifier for this submission.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:3:\"cid\";a:6:{s:11:\"description\";s:78:\"The identifier for this component within this node, starts at 0 for each node.\";s:4:\"type\";s:3:\"int\";s:4:\"size\";s:5:\"small\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:2:\"no\";a:6:{s:11:\"description\";s:131:\"Usually this value is 0, but if a field has multiple values (such as a time or date), it may require multiple rows in the database.\";s:4:\"type\";s:3:\"int\";s:4:\"size\";s:4:\"tiny\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:4:\"data\";a:4:{s:11:\"description\";s:73:\"The submitted value of this field, may be serialized for some components.\";s:4:\"type\";s:4:\"text\";s:4:\"size\";s:6:\"medium\";s:8:\"not null\";b:1;}}s:7:\"indexes\";a:2:{s:3:\"nid\";a:1:{i:0;s:3:\"nid\";}s:7:\"sid_nid\";a:2:{i:0;s:3:\"sid\";i:1;s:3:\"nid\";}}s:11:\"primary key\";a:4:{i:0;s:3:\"nid\";i:1;s:3:\"sid\";i:2;s:3:\"cid\";i:3;s:2:\"no\";}s:6:\"module\";s:7:\"webform\";s:4:\"name\";s:22:\"webform_submitted_data\";}s:19:\"aggregator_category\";a:6:{s:11:\"description\";s:54:\"Stores categories for aggregator feeds and feed items.\";s:6:\"fields\";a:4:{s:3:\"cid\";a:3:{s:4:\"type\";s:6:\"serial\";s:8:\"not null\";b:1;s:11:\"description\";s:43:\"Primary Key: Unique aggregator category ID.\";}s:5:\"title\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:22:\"Title of the category.\";}s:11:\"description\";a:4:{s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:1;s:4:\"size\";s:3:\"big\";s:11:\"description\";s:27:\"Description of the category\";}s:5:\"block\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";s:11:\"description\";s:61:\"The number of recent items to show within the category block.\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"cid\";}s:11:\"unique keys\";a:1:{s:5:\"title\";a:1:{i:0;s:5:\"title\";}}s:6:\"module\";s:10:\"aggregator\";s:4:\"name\";s:19:\"aggregator_category\";}s:24:\"aggregator_category_feed\";a:6:{s:11:\"description\";s:39:\"Bridge table; maps feeds to categories.\";s:6:\"fields\";a:2:{s:3:\"fid\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:33:\"The feed\'s {aggregator_feed}.fid.\";}s:3:\"cid\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:66:\"The {aggregator_category}.cid to which the feed is being assigned.\";}}s:11:\"primary key\";a:2:{i:0;s:3:\"cid\";i:1;s:3:\"fid\";}s:7:\"indexes\";a:1:{s:3:\"fid\";a:1:{i:0;s:3:\"fid\";}}s:6:\"module\";s:10:\"aggregator\";s:4:\"name\";s:24:\"aggregator_category_feed\";}s:24:\"aggregator_category_item\";a:6:{s:11:\"description\";s:44:\"Bridge table; maps feed items to categories.\";s:6:\"fields\";a:2:{s:3:\"iid\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:38:\"The feed item\'s {aggregator_item}.iid.\";}s:3:\"cid\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:71:\"The {aggregator_category}.cid to which the feed item is being assigned.\";}}s:11:\"primary key\";a:2:{i:0;s:3:\"cid\";i:1;s:3:\"iid\";}s:7:\"indexes\";a:1:{s:3:\"iid\";a:1:{i:0;s:3:\"iid\";}}s:6:\"module\";s:10:\"aggregator\";s:4:\"name\";s:24:\"aggregator_category_item\";}s:15:\"aggregator_feed\";a:6:{s:11:\"description\";s:44:\"Stores feeds to be parsed by the aggregator.\";s:6:\"fields\";a:11:{s:3:\"fid\";a:3:{s:4:\"type\";s:6:\"serial\";s:8:\"not null\";b:1;s:11:\"description\";s:28:\"Primary Key: Unique feed ID.\";}s:5:\"title\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:18:\"Title of the feed.\";}s:3:\"url\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:16:\"URL to the feed.\";}s:7:\"refresh\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:50:\"How often to check for new feed items, in seconds.\";}s:7:\"checked\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:60:\"Last time feed was checked for new items, as Unix timestamp.\";}s:4:\"link\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:74:\"The parent website of the feed; comes from the <link> element in the feed.\";}s:11:\"description\";a:4:{s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:1;s:4:\"size\";s:3:\"big\";s:11:\"description\";s:83:\"The parent website\'s description; comes from the <description> element in the feed.\";}s:5:\"image\";a:4:{s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:1;s:4:\"size\";s:3:\"big\";s:11:\"description\";s:31:\"An image representing the feed.\";}s:4:\"etag\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:59:\"Entity tag HTTP response header, used for validating cache.\";}s:8:\"modified\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:53:\"When the feed was last modified, as a Unix timestamp.\";}s:5:\"block\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";s:11:\"description\";s:47:\"Number of items to display in the feed\'s block.\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"fid\";}s:11:\"unique keys\";a:2:{s:3:\"url\";a:1:{i:0;s:3:\"url\";}s:5:\"title\";a:1:{i:0;s:5:\"title\";}}s:6:\"module\";s:10:\"aggregator\";s:4:\"name\";s:15:\"aggregator_feed\";}s:15:\"aggregator_item\";a:6:{s:11:\"description\";s:48:\"Stores the individual items imported from feeds.\";s:6:\"fields\";a:8:{s:3:\"iid\";a:3:{s:4:\"type\";s:6:\"serial\";s:8:\"not null\";b:1;s:11:\"description\";s:37:\"Primary Key: Unique ID for feed item.\";}s:3:\"fid\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:53:\"The {aggregator_feed}.fid to which this item belongs.\";}s:5:\"title\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:23:\"Title of the feed item.\";}s:4:\"link\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:22:\"Link to the feed item.\";}s:6:\"author\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:24:\"Author of the feed item.\";}s:11:\"description\";a:4:{s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:1;s:4:\"size\";s:3:\"big\";s:11:\"description\";s:22:\"Body of the feed item.\";}s:9:\"timestamp\";a:3:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:0;s:11:\"description\";s:44:\"Post date of feed item, as a Unix timestamp.\";}s:4:\"guid\";a:4:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:0;s:11:\"description\";s:36:\"Unique identifier for the feed item.\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"iid\";}s:7:\"indexes\";a:1:{s:3:\"fid\";a:1:{i:0;s:3:\"fid\";}}s:6:\"module\";s:10:\"aggregator\";s:4:\"name\";s:15:\"aggregator_item\";}s:19:\"antispam_spam_marks\";a:5:{s:6:\"fields\";a:8:{s:12:\"content_type\";a:4:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:20;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:10:\"content_id\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:12:\"spam_created\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:8:\"hostname\";a:4:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:128;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:4:\"mail\";a:4:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:128;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:9:\"signature\";a:4:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:40;s:8:\"not null\";b:0;s:7:\"default\";s:0:\"\";}s:9:\"spaminess\";a:3:{s:4:\"type\";s:5:\"float\";s:8:\"not null\";b:0;s:7:\"default\";i:1;}s:5:\"judge\";a:4:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:40;s:8:\"not null\";b:0;s:7:\"default\";s:0:\"\";}}s:10:\"unique key\";a:1:{s:7:\"content\";a:2:{i:0;s:12:\"content_type\";i:1;s:10:\"content_id\";}}s:7:\"indexes\";a:3:{s:12:\"spam_created\";a:1:{i:0;s:12:\"spam_created\";}s:8:\"hostname\";a:1:{i:0;s:8:\"hostname\";}s:4:\"mail\";a:1:{i:0;s:4:\"mail\";}}s:6:\"module\";s:8:\"antispam\";s:4:\"name\";s:19:\"antispam_spam_marks\";}s:18:\"antispam_moderator\";a:5:{s:6:\"fields\";a:2:{s:3:\"uid\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:9:\"email_for\";a:4:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:20;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"uid\";}s:7:\"indexes\";a:1:{s:9:\"email_for\";a:1:{i:0;s:9:\"email_for\";}}s:6:\"module\";s:8:\"antispam\";s:4:\"name\";s:18:\"antispam_moderator\";}s:16:\"antispam_counter\";a:4:{s:6:\"fields\";a:7:{s:2:\"id\";a:4:{s:11:\"description\";s:29:\"The record ID (unique number)\";s:4:\"type\";s:6:\"serial\";s:8:\"unsigned\";b:0;s:8:\"not null\";b:1;}s:4:\"date\";a:2:{s:4:\"type\";s:8:\"datetime\";s:8:\"not null\";b:1;}s:8:\"provider\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:0;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:13:\"spam_detected\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:0;s:8:\"not null\";b:0;s:7:\"default\";i:0;}s:12:\"ham_detected\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:0;s:8:\"not null\";b:0;s:7:\"default\";i:0;}s:14:\"false_negative\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:0;s:8:\"not null\";b:0;s:7:\"default\";i:0;}s:14:\"false_positive\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:0;s:8:\"not null\";b:0;s:7:\"default\";i:0;}}s:11:\"primary key\";a:1:{i:0;s:2:\"id\";}s:6:\"module\";s:8:\"antispam\";s:4:\"name\";s:16:\"antispam_counter\";}s:23:\"backup_migrate_profiles\";a:4:{s:6:\"fields\";a:6:{s:10:\"profile_id\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:32;s:8:\"not null\";b:1;s:7:\"default\";s:1:\"0\";s:11:\"description\";s:37:\"The primary identifier for a profile.\";}s:4:\"name\";a:4:{s:11:\"description\";s:24:\"The name of the profile.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;}s:8:\"filename\";a:4:{s:11:\"description\";s:24:\"The name of the profile.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:50;s:8:\"not null\";b:1;}s:16:\"append_timestamp\";a:6:{s:11:\"description\";s:35:\"Append a timestamp to the filename.\";s:4:\"type\";s:3:\"int\";s:4:\"size\";s:4:\"tiny\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:16:\"timestamp_format\";a:4:{s:11:\"description\";s:28:\"The format of the timestamp.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:14;s:8:\"not null\";b:1;}s:7:\"filters\";a:5:{s:11:\"description\";s:36:\"The filter settings for the profile.\";s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:1;s:9:\"serialize\";b:1;s:18:\"serialized default\";s:6:\"a:0:{}\";}}s:11:\"primary key\";a:1:{i:0;s:10:\"profile_id\";}s:6:\"module\";s:14:\"backup_migrate\";s:4:\"name\";s:23:\"backup_migrate_profiles\";}s:27:\"backup_migrate_destinations\";a:4:{s:6:\"fields\";a:5:{s:14:\"destination_id\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:32;s:8:\"not null\";b:1;s:7:\"default\";s:1:\"0\";s:11:\"description\";s:37:\"The primary identifier for a profile.\";}s:4:\"name\";a:4:{s:11:\"description\";s:24:\"The name of the profile.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;}s:4:\"type\";a:4:{s:11:\"description\";s:28:\"The type of the destination.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:32;s:8:\"not null\";b:1;}s:8:\"location\";a:3:{s:11:\"description\";s:43:\"The the location string of the destination.\";s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:1;}s:8:\"settings\";a:5:{s:11:\"description\";s:35:\"Other settings for the destination.\";s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:1;s:9:\"serialize\";b:1;s:18:\"serialized default\";s:6:\"a:0:{}\";}}s:11:\"primary key\";a:1:{i:0;s:14:\"destination_id\";}s:6:\"module\";s:14:\"backup_migrate\";s:4:\"name\";s:27:\"backup_migrate_destinations\";}s:24:\"backup_migrate_schedules\";a:4:{s:6:\"fields\";a:10:{s:11:\"schedule_id\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:32;s:8:\"not null\";b:1;s:7:\"default\";s:1:\"0\";s:11:\"description\";s:37:\"The primary identifier for a profile.\";}s:4:\"name\";a:4:{s:11:\"description\";s:24:\"The name of the profile.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;}s:9:\"source_id\";a:5:{s:11:\"description\";s:77:\"The {backup_migrate_destination}.destination_id of the source to backup from.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:32;s:7:\"default\";s:2:\"db\";s:8:\"not null\";b:1;}s:14:\"destination_id\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:32;s:8:\"not null\";b:1;s:7:\"default\";s:1:\"0\";s:11:\"description\";s:81:\"The {backup_migrate_destination}.destination_id of the destination to back up to.\";}s:10:\"profile_id\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:32;s:8:\"not null\";b:1;s:7:\"default\";s:1:\"0\";s:11:\"description\";s:37:\"The primary identifier for a profile.\";}s:4:\"keep\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:30:\"The number of backups to keep.\";}s:6:\"period\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:38:\"The number of seconds between backups.\";}s:8:\"last_run\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:33:\"The last time the backup was run.\";}s:7:\"enabled\";a:6:{s:11:\"description\";s:32:\"Whether the schedule is enabled.\";s:4:\"type\";s:3:\"int\";s:4:\"size\";s:4:\"tiny\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:4:\"cron\";a:6:{s:11:\"description\";s:47:\"Whether the schedule should be run during cron.\";s:4:\"type\";s:3:\"int\";s:4:\"size\";s:4:\"tiny\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}}s:11:\"primary key\";a:1:{i:0;s:11:\"schedule_id\";}s:6:\"module\";s:14:\"backup_migrate\";s:4:\"name\";s:24:\"backup_migrate_schedules\";}s:6:\"blocks\";a:7:{s:11:\"description\";s:62:\"Stores block settings, such as region and visibility settings.\";s:6:\"fields\";a:13:{s:3:\"bid\";a:3:{s:4:\"type\";s:6:\"serial\";s:8:\"not null\";b:1;s:11:\"description\";s:29:\"Primary Key: Unique block ID.\";}s:6:\"module\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:64;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:126:\"The module from which the block originates; for example, \'user\' for the Who\'s Online block, and \'block\' for any custom blocks.\";}s:5:\"delta\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:32;s:8:\"not null\";b:1;s:7:\"default\";s:1:\"0\";s:11:\"description\";s:36:\"Unique ID for block within a module.\";}s:5:\"theme\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:64;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:47:\"The theme under which the block settings apply.\";}s:6:\"status\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";s:11:\"description\";s:49:\"Block enabled status. (1 = enabled, 0 = disabled)\";}s:6:\"weight\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";s:11:\"description\";s:27:\"Block weight within region.\";}s:6:\"region\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:64;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:43:\"Theme region within which the block is set.\";}s:6:\"custom\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";s:11:\"description\";s:169:\"Flag to indicate how users may control visibility of the block. (0 = Users cannot control, 1 = On by default, but can be hidden, 2 = Hidden by default, but can be shown)\";}s:8:\"throttle\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";s:11:\"description\";s:113:\"Flag to indicate whether or not to remove block when website traffic is high. (1 = throttle, 0 = do not throttle)\";}s:10:\"visibility\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";s:11:\"description\";s:169:\"Flag to indicate how to show blocks on pages. (0 = Show on all pages except listed pages, 1 = Show only on listed pages, 2 = Use custom PHP code to determine visibility)\";}s:5:\"pages\";a:3:{s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:1;s:11:\"description\";s:148:\"Contents of the \"Pages\" block; contains either a list of paths on which to include/exclude the block or PHP code, depending on \"visibility\" setting.\";}s:5:\"title\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:64;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:148:\"Custom title for the block. (Empty string will use block default title, <none> will remove the title, text will cause block to use specified title.)\";}s:5:\"cache\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:1;s:4:\"size\";s:4:\"tiny\";s:11:\"description\";s:215:\"Binary flag to indicate block cache mode. (-1: Do not cache, 1: Cache per role, 2: Cache per user, 4: Cache per page, 8: Block cache global) See BLOCK_CACHE_* constants in block.module for more detailed information.\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"bid\";}s:11:\"unique keys\";a:1:{s:3:\"tmd\";a:3:{i:0;s:5:\"theme\";i:1;s:6:\"module\";i:2;s:5:\"delta\";}}s:7:\"indexes\";a:1:{s:4:\"list\";a:5:{i:0;s:5:\"theme\";i:1;s:6:\"status\";i:2;s:6:\"region\";i:3;s:6:\"weight\";i:4;s:6:\"module\";}}s:6:\"module\";s:5:\"block\";s:4:\"name\";s:6:\"blocks\";}s:12:\"blocks_roles\";a:6:{s:11:\"description\";s:57:\"Sets up access permissions for blocks based on user roles\";s:6:\"fields\";a:3:{s:6:\"module\";a:4:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:64;s:8:\"not null\";b:1;s:11:\"description\";s:48:\"The block\'s origin module, from {blocks}.module.\";}s:5:\"delta\";a:4:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:32;s:8:\"not null\";b:1;s:11:\"description\";s:60:\"The block\'s unique delta within module, from {blocks}.delta.\";}s:3:\"rid\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:11:\"description\";s:42:\"The user\'s role ID from {users_roles}.rid.\";}}s:11:\"primary key\";a:3:{i:0;s:6:\"module\";i:1;s:5:\"delta\";i:2;s:3:\"rid\";}s:7:\"indexes\";a:1:{s:3:\"rid\";a:1:{i:0;s:3:\"rid\";}}s:6:\"module\";s:5:\"block\";s:4:\"name\";s:12:\"blocks_roles\";}s:5:\"boxes\";a:6:{s:11:\"description\";s:38:\"Stores contents of custom-made blocks.\";s:6:\"fields\";a:4:{s:3:\"bid\";a:4:{s:4:\"type\";s:6:\"serial\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:11:\"description\";s:25:\"The block\'s {blocks}.bid.\";}s:4:\"body\";a:4:{s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:0;s:4:\"size\";s:3:\"big\";s:11:\"description\";s:15:\"Block contents.\";}s:4:\"info\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:128;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:18:\"Block description.\";}s:6:\"format\";a:5:{s:4:\"type\";s:3:\"int\";s:4:\"size\";s:5:\"small\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:69:\"Block body\'s {filter_formats}.format; for example, 1 = Filtered HTML.\";}}s:11:\"unique keys\";a:1:{s:4:\"info\";a:1:{i:0;s:4:\"info\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"bid\";}s:6:\"module\";s:5:\"block\";s:4:\"name\";s:5:\"boxes\";}s:11:\"cache_block\";a:6:{s:11:\"description\";s:204:\"Cache table for the Block module to store already built blocks, identified by module, delta, and various contexts which may change the block, such as theme, locale, and caching mode defined for the block.\";s:6:\"fields\";a:6:{s:3:\"cid\";a:5:{s:11:\"description\";s:29:\"Primary Key: Unique cache ID.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:4:\"data\";a:4:{s:11:\"description\";s:30:\"A collection of data to cache.\";s:4:\"type\";s:4:\"blob\";s:8:\"not null\";b:0;s:4:\"size\";s:3:\"big\";}s:6:\"expire\";a:4:{s:11:\"description\";s:79:\"A Unix timestamp indicating when the cache entry should expire, or 0 for never.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:7:\"created\";a:4:{s:11:\"description\";s:61:\"A Unix timestamp indicating when the cache entry was created.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:7:\"headers\";a:3:{s:11:\"description\";s:51:\"Any custom HTTP headers to be added to cached data.\";s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:0;}s:10:\"serialized\";a:5:{s:11:\"description\";s:64:\"A flag to indicate whether content is serialized (1) or not (0).\";s:4:\"type\";s:3:\"int\";s:4:\"size\";s:5:\"small\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}}s:7:\"indexes\";a:1:{s:6:\"expire\";a:1:{i:0;s:6:\"expire\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"cid\";}s:6:\"module\";s:5:\"block\";s:4:\"name\";s:11:\"cache_block\";}s:14:\"captcha_points\";a:5:{s:11:\"description\";s:69:\"This table describes which challenges should be added to which forms.\";s:6:\"fields\";a:3:{s:7:\"form_id\";a:4:{s:11:\"description\";s:44:\"The form_id of the form to add a CAPTCHA to.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:128;s:8:\"not null\";b:1;}s:6:\"module\";a:3:{s:11:\"description\";s:39:\"The module that provides the challenge.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:64;}s:4:\"type\";a:3:{s:11:\"description\";s:26:\"The challenge type to use.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:64;}}s:11:\"primary key\";a:1:{i:0;s:7:\"form_id\";}s:6:\"module\";s:7:\"captcha\";s:4:\"name\";s:14:\"captcha_points\";}s:16:\"captcha_sessions\";a:6:{s:11:\"description\";s:78:\"Stores the data about CAPTCHA sessions (solution, IP address, timestamp, ...).\";s:6:\"fields\";a:9:{s:4:\"csid\";a:3:{s:11:\"description\";s:19:\"CAPTCHA session ID.\";s:4:\"type\";s:6:\"serial\";s:8:\"not null\";b:1;}s:3:\"uid\";a:4:{s:11:\"description\";s:19:\"User\'s {users}.uid.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:3:\"sid\";a:5:{s:11:\"description\";s:23:\"Session ID of the user.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:64;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:10:\"ip_address\";a:4:{s:11:\"description\";s:26:\"IP address of the visitor.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:128;s:8:\"not null\";b:0;}s:9:\"timestamp\";a:4:{s:11:\"description\";s:61:\"A Unix timestamp indicating when the challenge was generated.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:7:\"form_id\";a:4:{s:11:\"description\";s:54:\"The form_id of the form where the CAPTCHA is added to.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:128;s:8:\"not null\";b:1;}s:8:\"solution\";a:5:{s:11:\"description\";s:26:\"Solution of the challenge.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:128;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:6:\"status\";a:4:{s:11:\"description\";s:53:\"Status of the CAPTCHA session (unsolved, solved, ...)\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:8:\"attempts\";a:4:{s:11:\"description\";s:23:\"The number of attempts.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}}s:11:\"primary key\";a:1:{i:0;s:4:\"csid\";}s:7:\"indexes\";a:1:{s:7:\"csid_ip\";a:2:{i:0;s:4:\"csid\";i:1;s:10:\"ip_address\";}}s:6:\"module\";s:7:\"captcha\";s:4:\"name\";s:16:\"captcha_sessions\";}s:8:\"comments\";a:6:{s:11:\"description\";s:36:\"Stores comments and associated data.\";s:6:\"fields\";a:14:{s:3:\"cid\";a:3:{s:4:\"type\";s:6:\"serial\";s:8:\"not null\";b:1;s:11:\"description\";s:31:\"Primary Key: Unique comment ID.\";}s:3:\"pid\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:117:\"The {comments}.cid to which this comment is a reply. If set to 0, this comment is not a reply to an existing comment.\";}s:3:\"nid\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:48:\"The {node}.nid to which this comment is a reply.\";}s:3:\"uid\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:101:\"The {users}.uid who authored the comment. If set to 0, this comment was created by an anonymous user.\";}s:7:\"subject\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:64;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:18:\"The comment title.\";}s:7:\"comment\";a:4:{s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:1;s:4:\"size\";s:3:\"big\";s:11:\"description\";s:17:\"The comment body.\";}s:8:\"hostname\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:128;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:23:\"The author\'s host name.\";}s:9:\"timestamp\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:89:\"The time that the comment was created, or last edited by its author, as a Unix timestamp.\";}s:6:\"status\";a:6:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";s:11:\"description\";s:69:\"The published status of a comment. (0 = Published, 1 = Not Published)\";}s:6:\"format\";a:5:{s:4:\"type\";s:3:\"int\";s:4:\"size\";s:5:\"small\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:48:\"The {filter_formats}.format of the comment body.\";}s:6:\"thread\";a:4:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:11:\"description\";s:62:\"The vancode representation of the comment\'s place in a thread.\";}s:4:\"name\";a:4:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:60;s:8:\"not null\";b:0;s:11:\"description\";s:124:\"The comment author\'s name. Uses {users}.name if the user is logged in, otherwise uses the value typed into the comment form.\";}s:4:\"mail\";a:4:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:64;s:8:\"not null\";b:0;s:11:\"description\";s:169:\"The comment author\'s e-mail address from the comment form, if user is anonymous, and the \'Anonymous users may/must leave their contact information\' setting is turned on.\";}s:8:\"homepage\";a:4:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:0;s:11:\"description\";s:172:\"The comment author\'s home page address from the comment form, if user is anonymous, and the \'Anonymous users may/must leave their contact information\' setting is turned on.\";}}s:7:\"indexes\";a:3:{s:3:\"pid\";a:1:{i:0;s:3:\"pid\";}s:3:\"nid\";a:1:{i:0;s:3:\"nid\";}s:6:\"status\";a:1:{i:0;s:6:\"status\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"cid\";}s:6:\"module\";s:7:\"comment\";s:4:\"name\";s:8:\"comments\";}s:23:\"node_comment_statistics\";a:6:{s:11:\"description\";s:82:\"Maintains statistics of node and comments posts to show \"new\" and \"updated\" flags.\";s:6:\"fields\";a:5:{s:3:\"nid\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:53:\"The {node}.nid for which the statistics are compiled.\";}s:22:\"last_comment_timestamp\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:99:\"The Unix timestamp of the last comment that was posted within this node, from {comments}.timestamp.\";}s:17:\"last_comment_name\";a:4:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:60;s:8:\"not null\";b:0;s:11:\"description\";s:83:\"The name of the latest author to post a comment on this node, from {comments}.name.\";}s:16:\"last_comment_uid\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:85:\"The user ID of the latest author to post a comment on this node, from {comments}.uid.\";}s:13:\"comment_count\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:42:\"The total number of comments on this node.\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"nid\";}s:7:\"indexes\";a:1:{s:22:\"node_comment_timestamp\";a:1:{i:0;s:22:\"last_comment_timestamp\";}}s:6:\"module\";s:7:\"comment\";s:4:\"name\";s:23:\"node_comment_statistics\";}s:14:\"content_access\";a:4:{s:6:\"fields\";a:2:{s:3:\"nid\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:8:\"settings\";a:3:{s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:0;s:4:\"size\";s:6:\"medium\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"nid\";}s:6:\"module\";s:14:\"content_access\";s:4:\"name\";s:14:\"content_access\";}s:12:\"custom_pager\";a:5:{s:11:\"description\";s:58:\"Stores data for previous/next pagers to be added to nodes.\";s:6:\"fields\";a:9:{s:3:\"pid\";a:4:{s:4:\"type\";s:6:\"serial\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:11:\"description\";s:41:\"Unique identifier for the {custom_pager}.\";}s:5:\"title\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:40:\"The visible title of the {custom_pager}.\";}s:8:\"list_php\";a:4:{s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:0;s:4:\"size\";s:3:\"big\";s:11:\"description\";s:40:\"Raw PHP to populate this {custom_pager}.\";}s:4:\"view\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:50:\"The name of the view used for this {custom_pager}.\";}s:4:\"args\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:62:\"A serialized array of arguments for the {custom_pager}\'s view.\";}s:8:\"position\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:16;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:59:\"The position where this {custom_pager} should be displayed.\";}s:14:\"visibility_php\";a:4:{s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:0;s:4:\"size\";s:3:\"big\";s:11:\"description\";s:65:\"Raw PHP to determine when the {custom_pager} should be displayed.\";}s:9:\"node_type\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:66:\"A specific node type this {custom_pager} should be displayed with.\";}s:12:\"reverse_list\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";s:11:\"description\";s:88:\"A boolean flag indicating that this {custom_pager} should be displayed in reverse order.\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"pid\";}s:6:\"module\";s:13:\"custom_pagers\";s:4:\"name\";s:12:\"custom_pager\";}s:7:\"filters\";a:7:{s:11:\"description\";s:74:\"Table that maps filters (HTML corrector) to input formats (Filtered HTML).\";s:6:\"fields\";a:5:{s:3:\"fid\";a:3:{s:4:\"type\";s:6:\"serial\";s:8:\"not null\";b:1;s:11:\"description\";s:41:\"Primary Key: Auto-incrementing filter ID.\";}s:6:\"format\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:74:\"Foreign key: The {filter_formats}.format to which this filter is assigned.\";}s:6:\"module\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:64;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:32:\"The origin module of the filter.\";}s:5:\"delta\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";s:11:\"description\";s:62:\"ID to identify which filter within module is being referenced.\";}s:6:\"weight\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";s:11:\"description\";s:31:\"Weight of filter within format.\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"fid\";}s:11:\"unique keys\";a:1:{s:3:\"fmd\";a:3:{i:0;s:6:\"format\";i:1;s:6:\"module\";i:2;s:5:\"delta\";}}s:7:\"indexes\";a:1:{s:4:\"list\";a:4:{i:0;s:6:\"format\";i:1;s:6:\"weight\";i:2;s:6:\"module\";i:3;s:5:\"delta\";}}s:6:\"module\";s:6:\"filter\";s:4:\"name\";s:7:\"filters\";}s:14:\"filter_formats\";a:6:{s:11:\"description\";s:73:\"Stores input formats: custom groupings of filters, such as Filtered HTML.\";s:6:\"fields\";a:4:{s:6:\"format\";a:3:{s:4:\"type\";s:6:\"serial\";s:8:\"not null\";b:1;s:11:\"description\";s:34:\"Primary Key: Unique ID for format.\";}s:4:\"name\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:41:\"Name of the input format (Filtered HTML).\";}s:5:\"roles\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:57:\"A comma-separated string of roles; references {role}.rid.\";}s:5:\"cache\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";s:11:\"description\";s:77:\"Flag to indicate whether format is cachable. (1 = cachable, 0 = not cachable)\";}}s:11:\"primary key\";a:1:{i:0;s:6:\"format\";}s:11:\"unique keys\";a:1:{s:4:\"name\";a:1:{i:0;s:4:\"name\";}}s:6:\"module\";s:6:\"filter\";s:4:\"name\";s:14:\"filter_formats\";}s:12:\"cache_filter\";a:6:{s:11:\"description\";s:128:\"Cache table for the Filter module to store already filtered pieces of text, identified by input format and md5 hash of the text.\";s:6:\"fields\";a:6:{s:3:\"cid\";a:5:{s:11:\"description\";s:29:\"Primary Key: Unique cache ID.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:4:\"data\";a:4:{s:11:\"description\";s:30:\"A collection of data to cache.\";s:4:\"type\";s:4:\"blob\";s:8:\"not null\";b:0;s:4:\"size\";s:3:\"big\";}s:6:\"expire\";a:4:{s:11:\"description\";s:79:\"A Unix timestamp indicating when the cache entry should expire, or 0 for never.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:7:\"created\";a:4:{s:11:\"description\";s:61:\"A Unix timestamp indicating when the cache entry was created.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:7:\"headers\";a:3:{s:11:\"description\";s:51:\"Any custom HTTP headers to be added to cached data.\";s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:0;}s:10:\"serialized\";a:5:{s:11:\"description\";s:64:\"A flag to indicate whether content is serialized (1) or not (0).\";s:4:\"type\";s:3:\"int\";s:4:\"size\";s:5:\"small\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}}s:7:\"indexes\";a:1:{s:6:\"expire\";a:1:{i:0;s:6:\"expire\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"cid\";}s:6:\"module\";s:6:\"filter\";s:4:\"name\";s:12:\"cache_filter\";}s:11:\"menu_custom\";a:5:{s:11:\"description\";s:74:\"Holds definitions for top-level custom menus (for example, Primary Links).\";s:6:\"fields\";a:3:{s:9:\"menu_name\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:32;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:80:\"Primary Key: Unique key for menu. This is used as a block delta so length is 32.\";}s:5:\"title\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:38:\"Menu title; displayed at top of block.\";}s:11:\"description\";a:3:{s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:0;s:11:\"description\";s:17:\"Menu description.\";}}s:11:\"primary key\";a:1:{i:0;s:9:\"menu_name\";}s:6:\"module\";s:4:\"menu\";s:4:\"name\";s:11:\"menu_custom\";}s:28:\"mobile_tools_roles_relations\";a:3:{s:6:\"fields\";a:2:{s:3:\"rid\";a:3:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;}s:4:\"mrid\";a:3:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;}}s:6:\"module\";s:12:\"mobile_tools\";s:4:\"name\";s:28:\"mobile_tools_roles_relations\";}s:4:\"node\";a:7:{s:11:\"description\";s:25:\"The base table for nodes.\";s:6:\"fields\";a:15:{s:3:\"nid\";a:4:{s:11:\"description\";s:34:\"The primary identifier for a node.\";s:4:\"type\";s:6:\"serial\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;}s:3:\"vid\";a:5:{s:11:\"description\";s:52:\"The current {node_revisions}.vid version identifier.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:4:\"type\";a:5:{s:11:\"description\";s:34:\"The {node_type}.type of this node.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:32;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:8:\"language\";a:5:{s:11:\"description\";s:38:\"The {languages}.language of this node.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:12;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:5:\"title\";a:5:{s:11:\"description\";s:63:\"The title of this node, always treated a non-markup plain text.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:3:\"uid\";a:4:{s:11:\"description\";s:81:\"The {users}.uid that owns this node; initially, this is the user that created it.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:6:\"status\";a:4:{s:11:\"description\";s:81:\"Boolean indicating whether the node is published (visible to non-administrators).\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:1;}s:7:\"created\";a:4:{s:11:\"description\";s:45:\"The Unix timestamp when the node was created.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:7:\"changed\";a:4:{s:11:\"description\";s:57:\"The Unix timestamp when the node was most recently saved.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:7:\"comment\";a:4:{s:11:\"description\";s:81:\"Whether comments are allowed on this node: 0 = no, 1 = read only, 2 = read/write.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:7:\"promote\";a:4:{s:11:\"description\";s:71:\"Boolean indicating whether the node should displayed on the front page.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:8:\"moderate\";a:4:{s:11:\"description\";s:93:\"Previously, a boolean indicating whether the node was \"in moderation\"; mostly no longer used.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:6:\"sticky\";a:4:{s:11:\"description\";s:96:\"Boolean indicating whether the node should be displayed at the top of lists in which it appears.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:4:\"tnid\";a:5:{s:11:\"description\";s:94:\"The translation set id for this node, which equals the node id of the source post in each set.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:9:\"translate\";a:4:{s:11:\"description\";s:71:\"A boolean indicating whether this translation page needs to be updated.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}}s:7:\"indexes\";a:10:{s:12:\"node_changed\";a:1:{i:0;s:7:\"changed\";}s:12:\"node_created\";a:1:{i:0;s:7:\"created\";}s:13:\"node_moderate\";a:1:{i:0;s:8:\"moderate\";}s:19:\"node_promote_status\";a:2:{i:0;s:7:\"promote\";i:1;s:6:\"status\";}s:16:\"node_status_type\";a:3:{i:0;s:6:\"status\";i:1;s:4:\"type\";i:2;s:3:\"nid\";}s:15:\"node_title_type\";a:2:{i:0;s:5:\"title\";i:1;a:2:{i:0;s:4:\"type\";i:1;i:4;}}s:9:\"node_type\";a:1:{i:0;a:2:{i:0;s:4:\"type\";i:1;i:4;}}s:3:\"uid\";a:1:{i:0;s:3:\"uid\";}s:4:\"tnid\";a:1:{i:0;s:4:\"tnid\";}s:9:\"translate\";a:1:{i:0;s:9:\"translate\";}}s:11:\"unique keys\";a:1:{s:3:\"vid\";a:1:{i:0;s:3:\"vid\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"nid\";}s:6:\"module\";s:4:\"node\";s:4:\"name\";s:4:\"node\";}s:11:\"node_access\";a:5:{s:11:\"description\";s:106:\"Identifies which realm/grant pairs a user must possess in order to view, update, or delete specific nodes.\";s:6:\"fields\";a:6:{s:3:\"nid\";a:5:{s:11:\"description\";s:35:\"The {node}.nid this record affects.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:3:\"gid\";a:5:{s:11:\"description\";s:98:\"The grant ID a user must possess in the specified realm to gain this row\'s privileges on the node.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:5:\"realm\";a:5:{s:11:\"description\";s:107:\"The realm in which the user must possess the grant ID. Each node access node can define one or more realms.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:10:\"grant_view\";a:6:{s:11:\"description\";s:79:\"Boolean indicating whether a user with the realm/grant pair can view this node.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";}s:12:\"grant_update\";a:6:{s:11:\"description\";s:79:\"Boolean indicating whether a user with the realm/grant pair can edit this node.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";}s:12:\"grant_delete\";a:6:{s:11:\"description\";s:81:\"Boolean indicating whether a user with the realm/grant pair can delete this node.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";}}s:11:\"primary key\";a:3:{i:0;s:3:\"nid\";i:1;s:3:\"gid\";i:2;s:5:\"realm\";}s:6:\"module\";s:4:\"node\";s:4:\"name\";s:11:\"node_access\";}s:12:\"node_counter\";a:5:{s:11:\"description\";s:30:\"Access statistics for {node}s.\";s:6:\"fields\";a:4:{s:3:\"nid\";a:4:{s:11:\"description\";s:36:\"The {node}.nid for these statistics.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:10:\"totalcount\";a:6:{s:11:\"description\";s:53:\"The total number of times the {node} has been viewed.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:3:\"big\";}s:8:\"daycount\";a:6:{s:11:\"description\";s:59:\"The total number of times the {node} has been viewed today.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:6:\"medium\";}s:9:\"timestamp\";a:5:{s:11:\"description\";s:48:\"The most recent time the {node} has been viewed.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}}s:11:\"primary key\";a:1:{i:0;s:3:\"nid\";}s:6:\"module\";s:4:\"node\";s:4:\"name\";s:12:\"node_counter\";}s:14:\"node_revisions\";a:6:{s:11:\"description\";s:56:\"Stores information about each saved version of a {node}.\";s:6:\"fields\";a:9:{s:3:\"nid\";a:5:{s:11:\"description\";s:35:\"The {node} this version belongs to.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:3:\"vid\";a:4:{s:11:\"description\";s:40:\"The primary identifier for this version.\";s:4:\"type\";s:6:\"serial\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;}s:3:\"uid\";a:4:{s:11:\"description\";s:42:\"The {users}.uid that created this version.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:5:\"title\";a:5:{s:11:\"description\";s:26:\"The title of this version.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:4:\"body\";a:4:{s:11:\"description\";s:25:\"The body of this version.\";s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:1;s:4:\"size\";s:3:\"big\";}s:6:\"teaser\";a:4:{s:11:\"description\";s:27:\"The teaser of this version.\";s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:1;s:4:\"size\";s:3:\"big\";}s:3:\"log\";a:4:{s:11:\"description\";s:53:\"The log entry explaining the changes in this version.\";s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:1;s:4:\"size\";s:3:\"big\";}s:9:\"timestamp\";a:4:{s:11:\"description\";s:58:\"A Unix timestamp indicating when this version was created.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:6:\"format\";a:4:{s:11:\"description\";s:45:\"The input format used by this version\'s body.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}}s:7:\"indexes\";a:2:{s:3:\"nid\";a:1:{i:0;s:3:\"nid\";}s:3:\"uid\";a:1:{i:0;s:3:\"uid\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"vid\";}s:6:\"module\";s:4:\"node\";s:4:\"name\";s:14:\"node_revisions\";}s:9:\"node_type\";a:5:{s:11:\"description\";s:50:\"Stores information about all defined {node} types.\";s:6:\"fields\";a:14:{s:4:\"type\";a:4:{s:11:\"description\";s:39:\"The machine-readable name of this type.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:32;s:8:\"not null\";b:1;}s:4:\"name\";a:5:{s:11:\"description\";s:37:\"The human-readable name of this type.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:6:\"module\";a:4:{s:11:\"description\";s:37:\"The module that implements this type.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;}s:11:\"description\";a:4:{s:11:\"description\";s:33:\"A brief description of this type.\";s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:1;s:4:\"size\";s:6:\"medium\";}s:4:\"help\";a:4:{s:11:\"description\";s:71:\"Help information shown to the user when creating a {node} of this type.\";s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:1;s:4:\"size\";s:6:\"medium\";}s:9:\"has_title\";a:5:{s:11:\"description\";s:65:\"Boolean indicating whether this type uses the {node}.title field.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:4:\"size\";s:4:\"tiny\";}s:11:\"title_label\";a:5:{s:11:\"description\";s:57:\"The label displayed for the title field on the edit form.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:8:\"has_body\";a:5:{s:11:\"description\";s:74:\"Boolean indicating whether this type uses the {node_revisions}.body field.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:4:\"size\";s:4:\"tiny\";}s:10:\"body_label\";a:5:{s:11:\"description\";s:56:\"The label displayed for the body field on the edit form.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:14:\"min_word_count\";a:5:{s:11:\"description\";s:50:\"The minimum number of words the body must contain.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:4:\"size\";s:5:\"small\";}s:6:\"custom\";a:5:{s:11:\"description\";s:137:\"A boolean indicating whether this type is defined by a module (FALSE) or by a user via a module like the Content Construction Kit (TRUE).\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";}s:8:\"modified\";a:5:{s:11:\"description\";s:108:\"A boolean indicating whether this type has been modified by an administrator; currently not used in any way.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";}s:6:\"locked\";a:5:{s:11:\"description\";s:88:\"A boolean indicating whether the administrator can change the machine name of this type.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";}s:9:\"orig_type\";a:5:{s:11:\"description\";s:128:\"The original machine-readable name of this node type. This may be different from the current type name if the locked field is 0.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}}s:11:\"primary key\";a:1:{i:0;s:4:\"type\";}s:6:\"module\";s:4:\"node\";s:4:\"name\";s:9:\"node_type\";}s:14:\"search_dataset\";a:5:{s:11:\"description\";s:35:\"Stores items that will be searched.\";s:6:\"fields\";a:4:{s:3:\"sid\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:39:\"Search item ID, e.g. node ID for nodes.\";}s:4:\"type\";a:4:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:16;s:8:\"not null\";b:0;s:11:\"description\";s:24:\"Type of item, e.g. node.\";}s:4:\"data\";a:4:{s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:1;s:4:\"size\";s:3:\"big\";s:11:\"description\";s:44:\"List of space-separated words from the item.\";}s:7:\"reindex\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:29:\"Set to force node reindexing.\";}}s:11:\"unique keys\";a:1:{s:8:\"sid_type\";a:2:{i:0;s:3:\"sid\";i:1;s:4:\"type\";}}s:6:\"module\";s:6:\"search\";s:4:\"name\";s:14:\"search_dataset\";}s:12:\"search_index\";a:6:{s:11:\"description\";s:61:\"Stores the search index, associating words, items and scores.\";s:6:\"fields\";a:4:{s:4:\"word\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:50;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:64:\"The {search_total}.word that is associated with the search item.\";}s:3:\"sid\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:74:\"The {search_dataset}.sid of the searchable item to which the word belongs.\";}s:4:\"type\";a:4:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:16;s:8:\"not null\";b:0;s:11:\"description\";s:75:\"The {search_dataset}.type of the searchable item to which the word belongs.\";}s:5:\"score\";a:3:{s:4:\"type\";s:5:\"float\";s:8:\"not null\";b:0;s:11:\"description\";s:59:\"The numeric score of the word, higher being more important.\";}}s:7:\"indexes\";a:2:{s:8:\"sid_type\";a:2:{i:0;s:3:\"sid\";i:1;s:4:\"type\";}s:4:\"word\";a:1:{i:0;s:4:\"word\";}}s:11:\"unique keys\";a:1:{s:13:\"word_sid_type\";a:3:{i:0;s:4:\"word\";i:1;s:3:\"sid\";i:2;s:4:\"type\";}}s:6:\"module\";s:6:\"search\";s:4:\"name\";s:12:\"search_index\";}s:12:\"search_total\";a:5:{s:11:\"description\";s:31:\"Stores search totals for words.\";s:6:\"fields\";a:2:{s:4:\"word\";a:5:{s:11:\"description\";s:45:\"Primary Key: Unique word in the search index.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:50;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:5:\"count\";a:3:{s:11:\"description\";s:93:\"The count of the word in the index using Zipf\'s law to equalize the probability distribution.\";s:4:\"type\";s:5:\"float\";s:8:\"not null\";b:0;}}s:11:\"primary key\";a:1:{i:0;s:4:\"word\";}s:6:\"module\";s:6:\"search\";s:4:\"name\";s:12:\"search_total\";}s:17:\"search_node_links\";a:6:{s:11:\"description\";s:122:\"Stores items (like nodes) that link to other nodes, used to improve search scores for nodes that are frequently linked to.\";s:6:\"fields\";a:4:{s:3:\"sid\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:80:\"The {search_dataset}.sid of the searchable item containing the link to the node.\";}s:4:\"type\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:16;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:81:\"The {search_dataset}.type of the searchable item containing the link to the node.\";}s:3:\"nid\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:39:\"The {node}.nid that this item links to.\";}s:7:\"caption\";a:4:{s:4:\"type\";s:4:\"text\";s:4:\"size\";s:3:\"big\";s:8:\"not null\";b:0;s:11:\"description\";s:40:\"The text used to link to the {node}.nid.\";}}s:11:\"primary key\";a:3:{i:0;s:3:\"sid\";i:1;s:4:\"type\";i:2;s:3:\"nid\";}s:7:\"indexes\";a:1:{s:3:\"nid\";a:1:{i:0;s:3:\"nid\";}}s:6:\"module\";s:6:\"search\";s:4:\"name\";s:17:\"search_node_links\";}s:9:\"accesslog\";a:6:{s:11:\"description\";s:46:\"Stores site access information for statistics.\";s:6:\"fields\";a:9:{s:3:\"aid\";a:3:{s:4:\"type\";s:6:\"serial\";s:8:\"not null\";b:1;s:11:\"description\";s:33:\"Primary Key: Unique accesslog ID.\";}s:3:\"sid\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:64;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:45:\"Browser session ID of user that visited page.\";}s:5:\"title\";a:4:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:0;s:11:\"description\";s:22:\"Title of page visited.\";}s:4:\"path\";a:4:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:0;s:11:\"description\";s:56:\"Internal path to page visited (relative to Drupal root.)\";}s:3:\"url\";a:4:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:0;s:11:\"description\";s:13:\"Referrer URI.\";}s:8:\"hostname\";a:4:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:128;s:8:\"not null\";b:0;s:11:\"description\";s:39:\"Hostname of user that visited the page.\";}s:3:\"uid\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:0;s:7:\"default\";i:0;s:11:\"description\";s:39:\"User {users}.uid that visited the page.\";}s:5:\"timer\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:48:\"Time in milliseconds that the page took to load.\";}s:9:\"timestamp\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:39:\"Timestamp of when the page was visited.\";}}s:7:\"indexes\";a:2:{s:19:\"accesslog_timestamp\";a:1:{i:0;s:9:\"timestamp\";}s:3:\"uid\";a:1:{i:0;s:3:\"uid\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"aid\";}s:6:\"module\";s:10:\"statistics\";s:4:\"name\";s:9:\"accesslog\";}s:8:\"variable\";a:5:{s:11:\"description\";s:215:\"Named variable/value pairs created by Drupal core or any other module or theme. All variables are cached in memory at the start of every Drupal request so developers should not be careless about what is stored here.\";s:6:\"fields\";a:2:{s:4:\"name\";a:5:{s:11:\"description\";s:25:\"The name of the variable.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:128;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:5:\"value\";a:4:{s:11:\"description\";s:26:\"The value of the variable.\";s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:1;s:4:\"size\";s:3:\"big\";}}s:11:\"primary key\";a:1:{i:0;s:4:\"name\";}s:6:\"module\";s:6:\"system\";s:4:\"name\";s:8:\"variable\";}s:7:\"actions\";a:5:{s:11:\"description\";s:26:\"Stores action information.\";s:6:\"fields\";a:5:{s:3:\"aid\";a:5:{s:11:\"description\";s:31:\"Primary Key: Unique actions ID.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:1:\"0\";}s:4:\"type\";a:5:{s:11:\"description\";s:82:\"The object that that action acts on (node, user, comment, system or custom types.)\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:32;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:8:\"callback\";a:5:{s:11:\"description\";s:57:\"The callback function that executes when the action runs.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:10:\"parameters\";a:4:{s:11:\"description\";s:49:\"Parameters to be passed to the callback function.\";s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:1;s:4:\"size\";s:3:\"big\";}s:11:\"description\";a:5:{s:11:\"description\";s:26:\"Description of the action.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:1:\"0\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"aid\";}s:6:\"module\";s:6:\"system\";s:4:\"name\";s:7:\"actions\";}s:11:\"actions_aid\";a:5:{s:11:\"description\";s:42:\"Stores action IDs for non-default actions.\";s:6:\"fields\";a:1:{s:3:\"aid\";a:4:{s:11:\"description\";s:31:\"Primary Key: Unique actions ID.\";s:4:\"type\";s:6:\"serial\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;}}s:11:\"primary key\";a:1:{i:0;s:3:\"aid\";}s:6:\"module\";s:6:\"system\";s:4:\"name\";s:11:\"actions_aid\";}s:5:\"batch\";a:6:{s:11:\"description\";s:76:\"Stores details about batches (processes that run in multiple HTTP requests).\";s:6:\"fields\";a:4:{s:3:\"bid\";a:4:{s:11:\"description\";s:29:\"Primary Key: Unique batch ID.\";s:4:\"type\";s:6:\"serial\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;}s:5:\"token\";a:4:{s:11:\"description\";s:165:\"A string token generated against the current user\'s session id and the batch id, used to ensure that only the user who submitted the batch can effectively access it.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:64;s:8:\"not null\";b:1;}s:9:\"timestamp\";a:3:{s:11:\"description\";s:112:\"A Unix timestamp indicating when this batch was submitted for processing. Stale batches are purged at cron time.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;}s:5:\"batch\";a:4:{s:11:\"description\";s:64:\"A serialized array containing the processing data for the batch.\";s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:0;s:4:\"size\";s:3:\"big\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"bid\";}s:7:\"indexes\";a:1:{s:5:\"token\";a:1:{i:0;s:5:\"token\";}}s:6:\"module\";s:6:\"system\";s:4:\"name\";s:5:\"batch\";}s:5:\"cache\";a:6:{s:11:\"description\";s:140:\"Generic cache table for caching things not separated out into their own tables. Contributed modules may also use this to store cached items.\";s:6:\"fields\";a:6:{s:3:\"cid\";a:5:{s:11:\"description\";s:29:\"Primary Key: Unique cache ID.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:4:\"data\";a:4:{s:11:\"description\";s:30:\"A collection of data to cache.\";s:4:\"type\";s:4:\"blob\";s:8:\"not null\";b:0;s:4:\"size\";s:3:\"big\";}s:6:\"expire\";a:4:{s:11:\"description\";s:79:\"A Unix timestamp indicating when the cache entry should expire, or 0 for never.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:7:\"created\";a:4:{s:11:\"description\";s:61:\"A Unix timestamp indicating when the cache entry was created.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:7:\"headers\";a:3:{s:11:\"description\";s:51:\"Any custom HTTP headers to be added to cached data.\";s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:0;}s:10:\"serialized\";a:5:{s:11:\"description\";s:64:\"A flag to indicate whether content is serialized (1) or not (0).\";s:4:\"type\";s:3:\"int\";s:4:\"size\";s:5:\"small\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}}s:7:\"indexes\";a:1:{s:6:\"expire\";a:1:{i:0;s:6:\"expire\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"cid\";}s:6:\"module\";s:6:\"system\";s:4:\"name\";s:5:\"cache\";}s:10:\"cache_form\";a:6:{s:11:\"description\";s:125:\"Cache table for the form system to store recently built forms and their storage data, to be used in subsequent page requests.\";s:6:\"fields\";a:6:{s:3:\"cid\";a:5:{s:11:\"description\";s:29:\"Primary Key: Unique cache ID.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:4:\"data\";a:4:{s:11:\"description\";s:30:\"A collection of data to cache.\";s:4:\"type\";s:4:\"blob\";s:8:\"not null\";b:0;s:4:\"size\";s:3:\"big\";}s:6:\"expire\";a:4:{s:11:\"description\";s:79:\"A Unix timestamp indicating when the cache entry should expire, or 0 for never.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:7:\"created\";a:4:{s:11:\"description\";s:61:\"A Unix timestamp indicating when the cache entry was created.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:7:\"headers\";a:3:{s:11:\"description\";s:51:\"Any custom HTTP headers to be added to cached data.\";s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:0;}s:10:\"serialized\";a:5:{s:11:\"description\";s:64:\"A flag to indicate whether content is serialized (1) or not (0).\";s:4:\"type\";s:3:\"int\";s:4:\"size\";s:5:\"small\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}}s:7:\"indexes\";a:1:{s:6:\"expire\";a:1:{i:0;s:6:\"expire\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"cid\";}s:6:\"module\";s:6:\"system\";s:4:\"name\";s:10:\"cache_form\";}s:10:\"cache_page\";a:6:{s:11:\"description\";s:91:\"Cache table used to store compressed pages for anonymous users, if page caching is enabled.\";s:6:\"fields\";a:6:{s:3:\"cid\";a:5:{s:11:\"description\";s:29:\"Primary Key: Unique cache ID.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:4:\"data\";a:4:{s:11:\"description\";s:30:\"A collection of data to cache.\";s:4:\"type\";s:4:\"blob\";s:8:\"not null\";b:0;s:4:\"size\";s:3:\"big\";}s:6:\"expire\";a:4:{s:11:\"description\";s:79:\"A Unix timestamp indicating when the cache entry should expire, or 0 for never.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:7:\"created\";a:4:{s:11:\"description\";s:61:\"A Unix timestamp indicating when the cache entry was created.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:7:\"headers\";a:3:{s:11:\"description\";s:51:\"Any custom HTTP headers to be added to cached data.\";s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:0;}s:10:\"serialized\";a:5:{s:11:\"description\";s:64:\"A flag to indicate whether content is serialized (1) or not (0).\";s:4:\"type\";s:3:\"int\";s:4:\"size\";s:5:\"small\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}}s:7:\"indexes\";a:1:{s:6:\"expire\";a:1:{i:0;s:6:\"expire\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"cid\";}s:6:\"module\";s:6:\"system\";s:4:\"name\";s:10:\"cache_page\";}s:10:\"cache_menu\";a:6:{s:11:\"description\";s:132:\"Cache table for the menu system to store router information as well as generated link trees for various menu/page/user combinations.\";s:6:\"fields\";a:6:{s:3:\"cid\";a:5:{s:11:\"description\";s:29:\"Primary Key: Unique cache ID.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:4:\"data\";a:4:{s:11:\"description\";s:30:\"A collection of data to cache.\";s:4:\"type\";s:4:\"blob\";s:8:\"not null\";b:0;s:4:\"size\";s:3:\"big\";}s:6:\"expire\";a:4:{s:11:\"description\";s:79:\"A Unix timestamp indicating when the cache entry should expire, or 0 for never.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:7:\"created\";a:4:{s:11:\"description\";s:61:\"A Unix timestamp indicating when the cache entry was created.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:7:\"headers\";a:3:{s:11:\"description\";s:51:\"Any custom HTTP headers to be added to cached data.\";s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:0;}s:10:\"serialized\";a:5:{s:11:\"description\";s:64:\"A flag to indicate whether content is serialized (1) or not (0).\";s:4:\"type\";s:3:\"int\";s:4:\"size\";s:5:\"small\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}}s:7:\"indexes\";a:1:{s:6:\"expire\";a:1:{i:0;s:6:\"expire\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"cid\";}s:6:\"module\";s:6:\"system\";s:4:\"name\";s:10:\"cache_menu\";}s:5:\"files\";a:6:{s:11:\"description\";s:38:\"Stores information for uploaded files.\";s:6:\"fields\";a:8:{s:3:\"fid\";a:4:{s:11:\"description\";s:29:\"Primary Key: Unique files ID.\";s:4:\"type\";s:6:\"serial\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;}s:3:\"uid\";a:5:{s:11:\"description\";s:60:\"The {users}.uid of the user who is associated with the file.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:8:\"filename\";a:5:{s:11:\"description\";s:17:\"Name of the file.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:8:\"filepath\";a:5:{s:11:\"description\";s:41:\"Path of the file relative to Drupal root.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:8:\"filemime\";a:5:{s:11:\"description\";s:19:\"The file MIME type.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:8:\"filesize\";a:5:{s:11:\"description\";s:30:\"The size of the file in bytes.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:6:\"status\";a:4:{s:11:\"description\";s:65:\"A flag indicating whether file is temporary (1) or permanent (0).\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:9:\"timestamp\";a:5:{s:11:\"description\";s:43:\"UNIX timestamp for when the file was added.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}}s:7:\"indexes\";a:3:{s:3:\"uid\";a:1:{i:0;s:3:\"uid\";}s:6:\"status\";a:1:{i:0;s:6:\"status\";}s:9:\"timestamp\";a:1:{i:0;s:9:\"timestamp\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"fid\";}s:6:\"module\";s:6:\"system\";s:4:\"name\";s:5:\"files\";}s:5:\"flood\";a:6:{s:11:\"description\";s:79:\"Flood controls the threshold of events, such as the number of contact attempts.\";s:6:\"fields\";a:4:{s:3:\"fid\";a:3:{s:11:\"description\";s:22:\"Unique flood event ID.\";s:4:\"type\";s:6:\"serial\";s:8:\"not null\";b:1;}s:5:\"event\";a:5:{s:11:\"description\";s:29:\"Name of event (e.g. contact).\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:64;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:8:\"hostname\";a:5:{s:11:\"description\";s:24:\"Hostname of the visitor.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:128;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:9:\"timestamp\";a:4:{s:11:\"description\";s:23:\"Timestamp of the event.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}}s:11:\"primary key\";a:1:{i:0;s:3:\"fid\";}s:7:\"indexes\";a:1:{s:5:\"allow\";a:3:{i:0;s:5:\"event\";i:1;s:8:\"hostname\";i:2;s:9:\"timestamp\";}}s:6:\"module\";s:6:\"system\";s:4:\"name\";s:5:\"flood\";}s:7:\"history\";a:6:{s:11:\"description\";s:50:\"A record of which {users} have read which {node}s.\";s:6:\"fields\";a:3:{s:3:\"uid\";a:4:{s:11:\"description\";s:41:\"The {users}.uid that read the {node} nid.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:3:\"nid\";a:4:{s:11:\"description\";s:29:\"The {node}.nid that was read.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:9:\"timestamp\";a:4:{s:11:\"description\";s:46:\"The Unix timestamp at which the read occurred.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}}s:11:\"primary key\";a:2:{i:0;s:3:\"uid\";i:1;s:3:\"nid\";}s:7:\"indexes\";a:1:{s:3:\"nid\";a:1:{i:0;s:3:\"nid\";}}s:6:\"module\";s:6:\"system\";s:4:\"name\";s:7:\"history\";}s:11:\"menu_router\";a:6:{s:11:\"description\";s:56:\"Maps paths to various callbacks (access, page and title)\";s:6:\"fields\";a:20:{s:4:\"path\";a:5:{s:11:\"description\";s:49:\"Primary Key: the Drupal path this entry describes\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:14:\"load_functions\";a:5:{s:11:\"description\";s:129:\"A serialized array of function names (like node_load) to be called to load an object corresponding to a part of the current path.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:16:\"to_arg_functions\";a:5:{s:11:\"description\";s:134:\"A serialized array of function names (like user_current_to_arg) to be called to replace a part of the router path with another string.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:15:\"access_callback\";a:5:{s:11:\"description\";s:86:\"The callback which determines the access to this router path. Defaults to user_access.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:16:\"access_arguments\";a:3:{s:11:\"description\";s:56:\"A serialized array of arguments for the access callback.\";s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:0;}s:13:\"page_callback\";a:5:{s:11:\"description\";s:47:\"The name of the function that renders the page.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:14:\"page_arguments\";a:3:{s:11:\"description\";s:54:\"A serialized array of arguments for the page callback.\";s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:0;}s:3:\"fit\";a:4:{s:11:\"description\";s:53:\"A numeric representation of how specific the path is.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:12:\"number_parts\";a:5:{s:11:\"description\";s:36:\"Number of parts in this router path.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:5:\"small\";}s:10:\"tab_parent\";a:5:{s:11:\"description\";s:98:\"Only for local tasks (tabs) - the router path of the parent page (which may also be a local task).\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:8:\"tab_root\";a:5:{s:11:\"description\";s:118:\"Router path of the closest non-tab parent page. For pages that are not local tasks, this will be the same as the path.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:5:\"title\";a:5:{s:11:\"description\";s:81:\"The title for the current page, or the title for the tab if this is a local task.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:14:\"title_callback\";a:5:{s:11:\"description\";s:54:\"A function which will alter the title. Defaults to t()\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:15:\"title_arguments\";a:5:{s:11:\"description\";s:133:\"A serialized array of arguments for the title callback. If empty, the title will be used as the sole argument for the title callback.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:4:\"type\";a:4:{s:11:\"description\";s:74:\"Numeric representation of the type of the menu item, like MENU_LOCAL_TASK.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:14:\"block_callback\";a:5:{s:11:\"description\";s:92:\"Name of a function used to render the block on the system administration page for this item.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:11:\"description\";a:3:{s:11:\"description\";s:27:\"A description of this item.\";s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:1;}s:8:\"position\";a:5:{s:11:\"description\";s:90:\"The position of the block (left or right) on the system administration page for this item.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:6:\"weight\";a:4:{s:11:\"description\";s:78:\"Weight of the element. Lighter weights are higher up, heavier weights go down.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:4:\"file\";a:3:{s:11:\"description\";s:92:\"The file to include for this element, usually the page callback function lives in this file.\";s:4:\"type\";s:4:\"text\";s:4:\"size\";s:6:\"medium\";}}s:7:\"indexes\";a:2:{s:3:\"fit\";a:1:{i:0;s:3:\"fit\";}s:10:\"tab_parent\";a:1:{i:0;s:10:\"tab_parent\";}}s:11:\"primary key\";a:1:{i:0;s:4:\"path\";}s:6:\"module\";s:6:\"system\";s:4:\"name\";s:11:\"menu_router\";}s:10:\"menu_links\";a:6:{s:11:\"description\";s:44:\"Contains the individual links within a menu.\";s:6:\"fields\";a:25:{s:9:\"menu_name\";a:5:{s:11:\"description\";s:98:\"The menu name. All links with the same menu name (such as \'navigation\') are part of the same menu.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:32;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:4:\"mlid\";a:4:{s:11:\"description\";s:51:\"The menu link ID (mlid) is the integer primary key.\";s:4:\"type\";s:6:\"serial\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;}s:4:\"plid\";a:5:{s:11:\"description\";s:126:\"The parent link ID (plid) is the mlid of the link above in the hierarchy, or zero if the link is at the top level in its menu.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:9:\"link_path\";a:5:{s:11:\"description\";s:53:\"The Drupal path or external path this link points to.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:11:\"router_path\";a:5:{s:11:\"description\";s:114:\"For links corresponding to a Drupal path (external = 0), this connects the link to a {menu_router}.path for joins.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:10:\"link_title\";a:5:{s:11:\"description\";s:99:\"The text displayed for the link, which may be modified by a title callback stored in {menu_router}.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:7:\"options\";a:3:{s:11:\"description\";s:115:\"A serialized array of options to be passed to the url() or l() function, such as a query string or HTML attributes.\";s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:0;}s:6:\"module\";a:5:{s:11:\"description\";s:48:\"The name of the module that generated this link.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:6:\"system\";}s:6:\"hidden\";a:5:{s:11:\"description\";s:168:\"A flag for whether the link should be rendered in menus. (1 = a disabled menu item that may be shown on admin screens, -1 = a menu callback, 0 = a normal, visible link)\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:5:\"small\";}s:8:\"external\";a:5:{s:11:\"description\";s:120:\"A flag to indicate if the link points to a full URL starting with a protocol, like http:// (1 = external, 0 = internal).\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:5:\"small\";}s:12:\"has_children\";a:5:{s:11:\"description\";s:99:\"Flag indicating whether any links have this link as a parent (1 = children exist, 0 = no children).\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:5:\"small\";}s:8:\"expanded\";a:5:{s:11:\"description\";s:210:\"Flag for whether this link should be rendered as expanded in menus - expanded links always have their child links displayed, instead of only when the link is in the active trail (1 = expanded, 0 = not expanded)\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:5:\"small\";}s:6:\"weight\";a:4:{s:11:\"description\";s:59:\"Link weight among links in the same menu at the same depth.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:5:\"depth\";a:5:{s:11:\"description\";s:80:\"The depth relative to the top level. A link with plid == 0 will have depth == 1.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:5:\"small\";}s:10:\"customized\";a:5:{s:11:\"description\";s:110:\"A flag to indicate that the user has manually created or edited the link (1 = customized, 0 = not customized).\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:5:\"small\";}s:2:\"p1\";a:5:{s:11:\"description\";s:219:\"The first mlid in the materialized path. If N = depth, then pN must equal the mlid. If depth > 1 then p(N-1) must equal the plid. All pX where X > depth must equal zero. The columns p1 .. p9 are also called the parents.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:2:\"p2\";a:5:{s:11:\"description\";s:49:\"The second mlid in the materialized path. See p1.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:2:\"p3\";a:5:{s:11:\"description\";s:48:\"The third mlid in the materialized path. See p1.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:2:\"p4\";a:5:{s:11:\"description\";s:49:\"The fourth mlid in the materialized path. See p1.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:2:\"p5\";a:5:{s:11:\"description\";s:48:\"The fifth mlid in the materialized path. See p1.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:2:\"p6\";a:5:{s:11:\"description\";s:48:\"The sixth mlid in the materialized path. See p1.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:2:\"p7\";a:5:{s:11:\"description\";s:50:\"The seventh mlid in the materialized path. See p1.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:2:\"p8\";a:5:{s:11:\"description\";s:49:\"The eighth mlid in the materialized path. See p1.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:2:\"p9\";a:5:{s:11:\"description\";s:48:\"The ninth mlid in the materialized path. See p1.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:7:\"updated\";a:5:{s:11:\"description\";s:81:\"Flag that indicates that this link was generated during the update from Drupal 5.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:5:\"small\";}}s:7:\"indexes\";a:4:{s:9:\"path_menu\";a:2:{i:0;a:2:{i:0;s:9:\"link_path\";i:1;i:128;}i:1;s:9:\"menu_name\";}s:22:\"menu_plid_expand_child\";a:4:{i:0;s:9:\"menu_name\";i:1;s:4:\"plid\";i:2;s:8:\"expanded\";i:3;s:12:\"has_children\";}s:12:\"menu_parents\";a:10:{i:0;s:9:\"menu_name\";i:1;s:2:\"p1\";i:2;s:2:\"p2\";i:3;s:2:\"p3\";i:4;s:2:\"p4\";i:5;s:2:\"p5\";i:6;s:2:\"p6\";i:7;s:2:\"p7\";i:8;s:2:\"p8\";i:9;s:2:\"p9\";}s:11:\"router_path\";a:1:{i:0;a:2:{i:0;s:11:\"router_path\";i:1;i:128;}}}s:11:\"primary key\";a:1:{i:0;s:4:\"mlid\";}s:6:\"module\";s:6:\"system\";s:4:\"name\";s:10:\"menu_links\";}s:8:\"sessions\";a:6:{s:11:\"description\";s:139:\"Drupal\'s session handlers read and write into the sessions table. Each record represents a user session, either anonymous or authenticated.\";s:6:\"fields\";a:6:{s:3:\"uid\";a:4:{s:11:\"description\";s:68:\"The {users}.uid corresponding to a session, or 0 for anonymous user.\";s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;}s:3:\"sid\";a:5:{s:11:\"description\";s:71:\"Primary key: A session ID. The value is generated by PHP\'s Session API.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:64;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:8:\"hostname\";a:5:{s:11:\"description\";s:52:\"The IP address that last used this session ID (sid).\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:128;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:9:\"timestamp\";a:4:{s:11:\"description\";s:104:\"The Unix timestamp when this session last requested a page. Old records are purged by PHP automatically.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:5:\"cache\";a:4:{s:11:\"description\";s:118:\"The time of this user\'s last post. This is used when the site has specified a minimum_cache_lifetime. See cache_get().\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:7:\"session\";a:4:{s:11:\"description\";s:208:\"The serialized contents of $_SESSION, an array of name/value pairs that persists across page requests by this session ID. Drupal loads $_SESSION from here at the start of each request and saves it at the end.\";s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:0;s:4:\"size\";s:3:\"big\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"sid\";}s:7:\"indexes\";a:2:{s:9:\"timestamp\";a:1:{i:0;s:9:\"timestamp\";}s:3:\"uid\";a:1:{i:0;s:3:\"uid\";}}s:6:\"module\";s:6:\"system\";s:4:\"name\";s:8:\"sessions\";}s:6:\"system\";a:6:{s:11:\"description\";s:105:\"A list of all modules, themes, and theme engines that are or have been installed in Drupal\'s file system.\";s:6:\"fields\";a:10:{s:8:\"filename\";a:5:{s:11:\"description\";s:103:\"The path of the primary file for this item, relative to the Drupal root; e.g. modules/node/node.module.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:4:\"name\";a:5:{s:11:\"description\";s:32:\"The name of the item; e.g. node.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:4:\"type\";a:5:{s:11:\"description\";s:60:\"The type of the item, either module, theme, or theme_engine.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:5:\"owner\";a:5:{s:11:\"description\";s:55:\"A theme\'s \'parent\'. Can be either a theme or an engine.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:6:\"status\";a:4:{s:11:\"description\";s:55:\"Boolean indicating whether or not this item is enabled.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:8:\"throttle\";a:5:{s:11:\"description\";s:102:\"Boolean indicating whether this item is disabled when the throttle.module disables throttleable items.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";}s:9:\"bootstrap\";a:4:{s:11:\"description\";s:138:\"Boolean indicating whether this module is loaded during Drupal\'s early bootstrapping phase (e.g. even before the page cache is consulted).\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:14:\"schema_version\";a:5:{s:11:\"description\";s:238:\"The module\'s database schema version number. -1 if the module is not installed (its tables do not exist); 0 or the largest N of the module\'s hook_update_N() function that has either been run or existed when the module was first installed.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:-1;s:4:\"size\";s:5:\"small\";}s:6:\"weight\";a:4:{s:11:\"description\";s:127:\"The order in which this module\'s hooks should be invoked relative to other modules. Equal-weighted modules are ordered by name.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:4:\"info\";a:3:{s:11:\"description\";s:166:\"A serialized array containing information from the module\'s .info file; keys can include name, description, package, version, core, dependencies, dependents, and php.\";s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:0;}}s:11:\"primary key\";a:1:{i:0;s:8:\"filename\";}s:7:\"indexes\";a:2:{s:7:\"modules\";a:4:{i:0;a:2:{i:0;s:4:\"type\";i:1;i:12;}i:1;s:6:\"status\";i:2;s:6:\"weight\";i:3;s:8:\"filename\";}s:9:\"bootstrap\";a:5:{i:0;a:2:{i:0;s:4:\"type\";i:1;i:12;}i:1;s:6:\"status\";i:2;s:9:\"bootstrap\";i:3;s:6:\"weight\";i:4;s:8:\"filename\";}}s:6:\"module\";s:6:\"system\";s:4:\"name\";s:6:\"system\";}s:9:\"url_alias\";a:7:{s:11:\"description\";s:95:\"A list of URL aliases for Drupal paths; a user may visit either the source or destination path.\";s:6:\"fields\";a:4:{s:3:\"pid\";a:4:{s:11:\"description\";s:31:\"A unique path alias identifier.\";s:4:\"type\";s:6:\"serial\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;}s:3:\"src\";a:5:{s:11:\"description\";s:48:\"The Drupal path this alias is for; e.g. node/12.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:128;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:3:\"dst\";a:5:{s:11:\"description\";s:49:\"The alias for this path; e.g. title-of-the-story.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:128;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:8:\"language\";a:5:{s:11:\"description\";s:151:\"The language this alias is for; if blank, the alias will be used for unknown languages. Each Drupal path can have an alias for each supported language.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:12;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}}s:11:\"unique keys\";a:1:{s:12:\"dst_language\";a:2:{i:0;s:3:\"dst\";i:1;s:8:\"language\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"pid\";}s:7:\"indexes\";a:1:{s:3:\"src\";a:1:{i:0;s:3:\"src\";}}s:6:\"module\";s:6:\"system\";s:4:\"name\";s:9:\"url_alias\";}s:9:\"term_data\";a:6:{s:11:\"description\";s:24:\"Stores term information.\";s:6:\"fields\";a:5:{s:3:\"tid\";a:4:{s:4:\"type\";s:6:\"serial\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:11:\"description\";s:28:\"Primary Key: Unique term ID.\";}s:3:\"vid\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:69:\"The {vocabulary}.vid of the vocabulary to which the term is assigned.\";}s:4:\"name\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:14:\"The term name.\";}s:11:\"description\";a:4:{s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:0;s:4:\"size\";s:3:\"big\";s:11:\"description\";s:26:\"A description of the term.\";}s:6:\"weight\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";s:11:\"description\";s:51:\"The weight of this term in relation to other terms.\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"tid\";}s:7:\"indexes\";a:2:{s:13:\"taxonomy_tree\";a:3:{i:0;s:3:\"vid\";i:1;s:6:\"weight\";i:2;s:4:\"name\";}s:8:\"vid_name\";a:2:{i:0;s:3:\"vid\";i:1;s:4:\"name\";}}s:6:\"module\";s:8:\"taxonomy\";s:4:\"name\";s:9:\"term_data\";}s:14:\"term_hierarchy\";a:6:{s:11:\"description\";s:51:\"Stores the hierarchical relationship between terms.\";s:6:\"fields\";a:2:{s:3:\"tid\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:45:\"Primary Key: The {term_data}.tid of the term.\";}s:6:\"parent\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:77:\"Primary Key: The {term_data}.tid of the term\'s parent. 0 indicates no parent.\";}}s:7:\"indexes\";a:1:{s:6:\"parent\";a:1:{i:0;s:6:\"parent\";}}s:11:\"primary key\";a:2:{i:0;s:3:\"tid\";i:1;s:6:\"parent\";}s:6:\"module\";s:8:\"taxonomy\";s:4:\"name\";s:14:\"term_hierarchy\";}s:9:\"term_node\";a:6:{s:11:\"description\";s:42:\"Stores the relationship of terms to nodes.\";s:6:\"fields\";a:3:{s:3:\"nid\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:40:\"Primary Key: The {node}.nid of the node.\";}s:3:\"vid\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:40:\"Primary Key: The {node}.vid of the node.\";}s:3:\"tid\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:64:\"Primary Key: The {term_data}.tid of a term assigned to the node.\";}}s:7:\"indexes\";a:2:{s:3:\"vid\";a:1:{i:0;s:3:\"vid\";}s:3:\"nid\";a:1:{i:0;s:3:\"nid\";}}s:11:\"primary key\";a:2:{i:0;s:3:\"tid\";i:1;s:3:\"vid\";}s:6:\"module\";s:8:\"taxonomy\";s:4:\"name\";s:9:\"term_node\";}s:13:\"term_relation\";a:7:{s:11:\"description\";s:52:\"Stores non-hierarchical relationships between terms.\";s:6:\"fields\";a:3:{s:4:\"trid\";a:3:{s:4:\"type\";s:6:\"serial\";s:8:\"not null\";b:1;s:11:\"description\";s:37:\"Primary Key: Unique term relation ID.\";}s:4:\"tid1\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:56:\"The {term_data}.tid of the first term in a relationship.\";}s:4:\"tid2\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:57:\"The {term_data}.tid of the second term in a relationship.\";}}s:11:\"unique keys\";a:1:{s:9:\"tid1_tid2\";a:2:{i:0;s:4:\"tid1\";i:1;s:4:\"tid2\";}}s:7:\"indexes\";a:1:{s:4:\"tid2\";a:1:{i:0;s:4:\"tid2\";}}s:11:\"primary key\";a:1:{i:0;s:4:\"trid\";}s:6:\"module\";s:8:\"taxonomy\";s:4:\"name\";s:13:\"term_relation\";}s:12:\"term_synonym\";a:6:{s:11:\"description\";s:21:\"Stores term synonyms.\";s:6:\"fields\";a:3:{s:4:\"tsid\";a:3:{s:4:\"type\";s:6:\"serial\";s:8:\"not null\";b:1;s:11:\"description\";s:36:\"Primary Key: Unique term synonym ID.\";}s:3:\"tid\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:32:\"The {term_data}.tid of the term.\";}s:4:\"name\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:24:\"The name of the synonym.\";}}s:7:\"indexes\";a:2:{s:3:\"tid\";a:1:{i:0;s:3:\"tid\";}s:8:\"name_tid\";a:2:{i:0;s:4:\"name\";i:1;s:3:\"tid\";}}s:11:\"primary key\";a:1:{i:0;s:4:\"tsid\";}s:6:\"module\";s:8:\"taxonomy\";s:4:\"name\";s:12:\"term_synonym\";}s:10:\"vocabulary\";a:6:{s:11:\"description\";s:30:\"Stores vocabulary information.\";s:6:\"fields\";a:11:{s:3:\"vid\";a:4:{s:4:\"type\";s:6:\"serial\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:11:\"description\";s:34:\"Primary Key: Unique vocabulary ID.\";}s:4:\"name\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:23:\"Name of the vocabulary.\";}s:11:\"description\";a:4:{s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:0;s:4:\"size\";s:3:\"big\";s:11:\"description\";s:30:\"Description of the vocabulary.\";}s:4:\"help\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:40:\"Help text to display for the vocabulary.\";}s:9:\"relations\";a:6:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";s:11:\"description\";s:91:\"Whether or not related terms are enabled within the vocabulary. (0 = disabled, 1 = enabled)\";}s:9:\"hierarchy\";a:6:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";s:11:\"description\";s:93:\"The type of hierarchy allowed within the vocabulary. (0 = disabled, 1 = single, 2 = multiple)\";}s:8:\"multiple\";a:6:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";s:11:\"description\";s:105:\"Whether or not multiple terms from this vocabulary may be assigned to a node. (0 = disabled, 1 = enabled)\";}s:8:\"required\";a:6:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";s:11:\"description\";s:94:\"Whether or not terms are required for nodes using this vocabulary. (0 = disabled, 1 = enabled)\";}s:4:\"tags\";a:6:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";s:11:\"description\";s:86:\"Whether or not free tagging is enabled for the vocabulary. (0 = disabled, 1 = enabled)\";}s:6:\"module\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:40:\"The module which created the vocabulary.\";}s:6:\"weight\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";s:11:\"description\";s:63:\"The weight of the vocabulary in relation to other vocabularies.\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"vid\";}s:7:\"indexes\";a:1:{s:4:\"list\";a:2:{i:0;s:6:\"weight\";i:1;s:4:\"name\";}}s:6:\"module\";s:8:\"taxonomy\";s:4:\"name\";s:10:\"vocabulary\";}s:21:\"vocabulary_node_types\";a:6:{s:11:\"description\";s:54:\"Stores which node types vocabularies may be used with.\";s:6:\"fields\";a:2:{s:3:\"vid\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:52:\"Primary Key: the {vocabulary}.vid of the vocabulary.\";}s:4:\"type\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:32;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:70:\"The {node}.type of the node type for which the vocabulary may be used.\";}}s:11:\"primary key\";a:2:{i:0;s:4:\"type\";i:1;s:3:\"vid\";}s:7:\"indexes\";a:1:{s:3:\"vid\";a:1:{i:0;s:3:\"vid\";}}s:6:\"module\";s:8:\"taxonomy\";s:4:\"name\";s:21:\"vocabulary_node_types\";}s:16:\"tinymce_settings\";a:5:{s:11:\"description\";s:1:\"-\";s:6:\"fields\";a:2:{s:4:\"name\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:128;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:1:\"-\";}s:8:\"settings\";a:3:{s:4:\"type\";s:4:\"text\";s:4:\"size\";s:6:\"normal\";s:11:\"description\";s:1:\"-\";}}s:11:\"primary key\";a:1:{i:0;s:4:\"name\";}s:6:\"module\";s:7:\"tinymce\";s:4:\"name\";s:16:\"tinymce_settings\";}s:12:\"tinymce_role\";a:5:{s:11:\"description\";s:1:\"-\";s:6:\"fields\";a:2:{s:4:\"name\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:128;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:1:\"-\";}s:3:\"rid\";a:6:{s:4:\"type\";s:3:\"int\";s:4:\"size\";s:4:\"tiny\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:1:\"-\";}}s:11:\"primary key\";a:2:{i:0;s:4:\"name\";i:1;s:3:\"rid\";}s:6:\"module\";s:7:\"tinymce\";s:4:\"name\";s:12:\"tinymce_role\";}s:12:\"cache_update\";a:6:{s:11:\"description\";s:109:\"Cache table for the Update module to store information about available releases, fetched from central server.\";s:6:\"fields\";a:6:{s:3:\"cid\";a:5:{s:11:\"description\";s:29:\"Primary Key: Unique cache ID.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:4:\"data\";a:4:{s:11:\"description\";s:30:\"A collection of data to cache.\";s:4:\"type\";s:4:\"blob\";s:8:\"not null\";b:0;s:4:\"size\";s:3:\"big\";}s:6:\"expire\";a:4:{s:11:\"description\";s:79:\"A Unix timestamp indicating when the cache entry should expire, or 0 for never.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:7:\"created\";a:4:{s:11:\"description\";s:61:\"A Unix timestamp indicating when the cache entry was created.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:7:\"headers\";a:3:{s:11:\"description\";s:51:\"Any custom HTTP headers to be added to cached data.\";s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:0;}s:10:\"serialized\";a:5:{s:11:\"description\";s:64:\"A flag to indicate whether content is serialized (1) or not (0).\";s:4:\"type\";s:3:\"int\";s:4:\"size\";s:5:\"small\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}}s:7:\"indexes\";a:1:{s:6:\"expire\";a:1:{i:0;s:6:\"expire\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"cid\";}s:6:\"module\";s:6:\"update\";s:4:\"name\";s:12:\"cache_update\";}s:6:\"upload\";a:6:{s:11:\"description\";s:56:\"Stores uploaded file information and table associations.\";s:6:\"fields\";a:6:{s:3:\"fid\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:29:\"Primary Key: The {files}.fid.\";}s:3:\"nid\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:49:\"The {node}.nid associated with the uploaded file.\";}s:3:\"vid\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:62:\"Primary Key: The {node}.vid associated with the uploaded file.\";}s:11:\"description\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:33:\"Description of the uploaded file.\";}s:4:\"list\";a:6:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";s:11:\"description\";s:71:\"Whether the file should be visibly listed on the node: yes(1) or no(0).\";}s:6:\"weight\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";s:11:\"description\";s:64:\"Weight of this upload in relation to other uploads in this node.\";}}s:11:\"primary key\";a:2:{i:0;s:3:\"vid\";i:1;s:3:\"fid\";}s:7:\"indexes\";a:2:{s:3:\"fid\";a:1:{i:0;s:3:\"fid\";}s:3:\"nid\";a:1:{i:0;s:3:\"nid\";}}s:6:\"module\";s:6:\"upload\";s:4:\"name\";s:6:\"upload\";}s:6:\"access\";a:5:{s:11:\"description\";s:25:\"Stores site access rules.\";s:6:\"fields\";a:4:{s:3:\"aid\";a:3:{s:4:\"type\";s:6:\"serial\";s:8:\"not null\";b:1;s:11:\"description\";s:30:\"Primary Key: Unique access ID.\";}s:4:\"mask\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:36:\"Text mask used for filtering access.\";}s:4:\"type\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:40:\"Type of access rule: name, mail or host.\";}s:6:\"status\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";s:11:\"description\";s:46:\"Whether rule is to allow(1) or deny(0) access.\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"aid\";}s:6:\"module\";s:4:\"user\";s:4:\"name\";s:6:\"access\";}s:7:\"authmap\";a:6:{s:11:\"description\";s:42:\"Stores distributed authentication mapping.\";s:6:\"fields\";a:4:{s:3:\"aid\";a:4:{s:11:\"description\";s:31:\"Primary Key: Unique authmap ID.\";s:4:\"type\";s:6:\"serial\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;}s:3:\"uid\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:19:\"User\'s {users}.uid.\";}s:8:\"authname\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:128;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:27:\"Unique authentication name.\";}s:6:\"module\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:128;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:47:\"Module which is controlling the authentication.\";}}s:11:\"unique keys\";a:1:{s:8:\"authname\";a:1:{i:0;s:8:\"authname\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"aid\";}s:6:\"module\";s:4:\"user\";s:4:\"name\";s:7:\"authmap\";}s:10:\"permission\";a:6:{s:11:\"description\";s:29:\"Stores permissions for users.\";s:6:\"fields\";a:4:{s:3:\"pid\";a:3:{s:4:\"type\";s:6:\"serial\";s:8:\"not null\";b:1;s:11:\"description\";s:34:\"Primary Key: Unique permission ID.\";}s:3:\"rid\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:53:\"The {role}.rid to which the permissions are assigned.\";}s:4:\"perm\";a:4:{s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:0;s:4:\"size\";s:3:\"big\";s:11:\"description\";s:35:\"List of permissions being assigned.\";}s:3:\"tid\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:67:\"Originally intended for taxonomy-based permissions, but never used.\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"pid\";}s:7:\"indexes\";a:1:{s:3:\"rid\";a:1:{i:0;s:3:\"rid\";}}s:6:\"module\";s:4:\"user\";s:4:\"name\";s:10:\"permission\";}s:4:\"role\";a:6:{s:11:\"description\";s:18:\"Stores user roles.\";s:6:\"fields\";a:2:{s:3:\"rid\";a:4:{s:4:\"type\";s:6:\"serial\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:11:\"description\";s:28:\"Primary Key: Unique role id.\";}s:4:\"name\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:64;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:17:\"Unique role name.\";}}s:11:\"unique keys\";a:1:{s:4:\"name\";a:1:{i:0;s:4:\"name\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"rid\";}s:6:\"module\";s:4:\"user\";s:4:\"name\";s:4:\"role\";}s:5:\"users\";a:7:{s:11:\"description\";s:17:\"Stores user data.\";s:6:\"fields\";a:18:{s:3:\"uid\";a:4:{s:4:\"type\";s:6:\"serial\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:11:\"description\";s:28:\"Primary Key: Unique user ID.\";}s:4:\"name\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:60;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:17:\"Unique user name.\";}s:4:\"pass\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:32;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:27:\"User\'s password (md5 hash).\";}s:4:\"mail\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:64;s:8:\"not null\";b:0;s:7:\"default\";s:0:\"\";s:11:\"description\";s:21:\"User\'s email address.\";}s:4:\"mode\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";s:11:\"description\";s:80:\"Per-user comment display mode (threaded vs. flat), used by the {comment} module.\";}s:4:\"sort\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:0;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";s:11:\"description\";s:84:\"Per-user comment sort order (newest vs. oldest first), used by the {comment} module.\";}s:9:\"threshold\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:0;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";s:11:\"description\";s:81:\"Previously used by the {comment} module for per-user preferences; no longer used.\";}s:5:\"theme\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:21:\"User\'s default theme.\";}s:9:\"signature\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:17:\"User\'s signature.\";}s:7:\"created\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:36:\"Timestamp for when user was created.\";}s:6:\"access\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:51:\"Timestamp for previous time user accessed the site.\";}s:5:\"login\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:32:\"Timestamp for user\'s last login.\";}s:6:\"status\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";s:11:\"description\";s:44:\"Whether the user is active(1) or blocked(0).\";}s:8:\"timezone\";a:4:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:8;s:8:\"not null\";b:0;s:11:\"description\";s:16:\"User\'s timezone.\";}s:8:\"language\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:12;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:24:\"User\'s default language.\";}s:7:\"picture\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";s:11:\"description\";s:36:\"Path to the user\'s uploaded picture.\";}s:4:\"init\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:64;s:8:\"not null\";b:0;s:7:\"default\";s:0:\"\";s:11:\"description\";s:48:\"Email address used for initial account creation.\";}s:4:\"data\";a:4:{s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:0;s:4:\"size\";s:3:\"big\";s:11:\"description\";s:269:\"A serialized array of name value pairs that are related to the user. Any form values posted during user edit are stored and are loaded into the $user object during user_load(). Use of this field is discouraged and it will likely disappear in a future version of Drupal.\";}}s:7:\"indexes\";a:3:{s:6:\"access\";a:1:{i:0;s:6:\"access\";}s:7:\"created\";a:1:{i:0;s:7:\"created\";}s:4:\"mail\";a:1:{i:0;s:4:\"mail\";}}s:11:\"unique keys\";a:1:{s:4:\"name\";a:1:{i:0;s:4:\"name\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"uid\";}s:6:\"module\";s:4:\"user\";s:4:\"name\";s:5:\"users\";}s:11:\"users_roles\";a:6:{s:11:\"description\";s:20:\"Maps users to roles.\";s:6:\"fields\";a:2:{s:3:\"uid\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:34:\"Primary Key: {users}.uid for user.\";}s:3:\"rid\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:33:\"Primary Key: {role}.rid for role.\";}}s:11:\"primary key\";a:2:{i:0;s:3:\"uid\";i:1;s:3:\"rid\";}s:7:\"indexes\";a:1:{s:3:\"rid\";a:1:{i:0;s:3:\"rid\";}}s:6:\"module\";s:4:\"user\";s:4:\"name\";s:11:\"users_roles\";}s:10:\"views_view\";a:6:{s:11:\"description\";s:35:\"Stores the general data for a view.\";s:6:\"fields\";a:7:{s:3:\"vid\";a:5:{s:4:\"type\";s:6:\"serial\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:11:\"description\";s:50:\"The view ID of the field, defined by the database.\";s:9:\"no export\";b:1;}s:4:\"name\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";s:2:\"32\";s:7:\"default\";s:0:\"\";s:8:\"not null\";b:1;s:11:\"description\";s:210:\"The unique name of the view. This is the primary field views are loaded from, and is used so that views may be internal and not necessarily in the database. May only be alphanumeric characters plus underscores.\";}s:11:\"description\";a:4:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";s:3:\"255\";s:7:\"default\";s:0:\"\";s:11:\"description\";s:50:\"A description of the view for the admin interface.\";}s:3:\"tag\";a:4:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";s:3:\"255\";s:7:\"default\";s:0:\"\";s:11:\"description\";s:53:\"A tag used to group/sort views in the admin interface\";}s:8:\"view_php\";a:2:{s:4:\"type\";s:4:\"blob\";s:11:\"description\";s:92:\"A chunk of PHP code that can be used to provide modifications to the view prior to building.\";}s:10:\"base_table\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:64;s:7:\"default\";s:0:\"\";s:8:\"not null\";b:1;s:11:\"description\";s:71:\"What table this view is based on, such as node, user, comment, or term.\";}s:12:\"is_cacheable\";a:4:{s:4:\"type\";s:3:\"int\";s:7:\"default\";i:0;s:4:\"size\";s:4:\"tiny\";s:11:\"description\";s:73:\"A boolean to indicate whether or not this view may have its query cached.\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"vid\";}s:11:\"unique keys\";a:1:{s:4:\"name\";a:1:{i:0;s:4:\"name\";}}s:6:\"module\";s:5:\"views\";s:4:\"name\";s:10:\"views_view\";}s:13:\"views_display\";a:6:{s:11:\"description\";s:57:\"Stores information about each display attached to a view.\";s:6:\"fields\";a:6:{s:3:\"vid\";a:6:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:37:\"The view this display is attached to.\";s:9:\"no export\";b:1;}s:2:\"id\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";s:2:\"64\";s:7:\"default\";s:0:\"\";s:8:\"not null\";b:1;s:11:\"description\";s:134:\"An identifier for this display; usually generated from the display_plugin, so should be something like page or page_1 or block_2, etc.\";}s:13:\"display_title\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";s:2:\"64\";s:7:\"default\";s:0:\"\";s:8:\"not null\";b:1;s:11:\"description\";s:56:\"The title of the display, viewable by the administrator.\";}s:14:\"display_plugin\";a:5:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";s:2:\"64\";s:7:\"default\";s:0:\"\";s:8:\"not null\";b:1;s:11:\"description\";s:95:\"The type of the display. Usually page, block or embed, but is pluggable so may be other things.\";}s:8:\"position\";a:3:{s:4:\"type\";s:3:\"int\";s:7:\"default\";i:0;s:11:\"description\";s:42:\"The order in which this display is loaded.\";}s:15:\"display_options\";a:5:{s:4:\"type\";s:4:\"text\";s:4:\"size\";s:3:\"big\";s:11:\"description\";s:130:\"A serialized array of options for this display; it contains options that are generally only pertinent to that display plugin type.\";s:9:\"serialize\";b:1;s:18:\"serialized default\";s:6:\"a:0:{}\";}}s:7:\"indexes\";a:1:{s:3:\"vid\";a:2:{i:0;s:3:\"vid\";i:1;s:8:\"position\";}}s:11:\"primary key\";a:2:{i:0;s:3:\"vid\";i:1;s:2:\"id\";}s:6:\"module\";s:5:\"views\";s:4:\"name\";s:13:\"views_display\";}s:11:\"cache_views\";a:6:{s:11:\"description\";s:140:\"Generic cache table for caching things not separated out into their own tables. Contributed modules may also use this to store cached items.\";s:6:\"fields\";a:6:{s:3:\"cid\";a:5:{s:11:\"description\";s:29:\"Primary Key: Unique cache ID.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:4:\"data\";a:4:{s:11:\"description\";s:30:\"A collection of data to cache.\";s:4:\"type\";s:4:\"blob\";s:8:\"not null\";b:0;s:4:\"size\";s:3:\"big\";}s:6:\"expire\";a:4:{s:11:\"description\";s:79:\"A Unix timestamp indicating when the cache entry should expire, or 0 for never.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:7:\"created\";a:4:{s:11:\"description\";s:61:\"A Unix timestamp indicating when the cache entry was created.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:7:\"headers\";a:3:{s:11:\"description\";s:51:\"Any custom HTTP headers to be added to cached data.\";s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:0;}s:10:\"serialized\";a:5:{s:11:\"description\";s:64:\"A flag to indicate whether content is serialized (1) or not (0).\";s:4:\"type\";s:3:\"int\";s:4:\"size\";s:5:\"small\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}}s:7:\"indexes\";a:1:{s:6:\"expire\";a:1:{i:0;s:6:\"expire\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"cid\";}s:6:\"module\";s:5:\"views\";s:4:\"name\";s:11:\"cache_views\";}s:18:\"views_object_cache\";a:5:{s:11:\"description\";s:124:\"A special cache used to store objects that are being edited; it serves to save state in an ordinarily stateless environment.\";s:6:\"fields\";a:5:{s:3:\"sid\";a:3:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";s:2:\"64\";s:11:\"description\";s:44:\"The session ID this cache object belongs to.\";}s:4:\"name\";a:3:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";s:2:\"32\";s:11:\"description\";s:47:\"The name of the view this cache is attached to.\";}s:3:\"obj\";a:3:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";s:2:\"32\";s:11:\"description\";s:135:\"The name of the object this cache is attached to; this essentially represents the owner so that several sub-systems can use this cache.\";}s:7:\"updated\";a:5:{s:4:\"type\";s:3:\"int\";s:8:\"unsigned\";b:1;s:8:\"not null\";b:1;s:7:\"default\";i:0;s:11:\"description\";s:43:\"The time this cache was created or updated.\";}s:4:\"data\";a:4:{s:4:\"type\";s:4:\"text\";s:11:\"description\";s:29:\"Serialized data being stored.\";s:9:\"serialize\";b:1;s:4:\"size\";s:3:\"big\";}}s:7:\"indexes\";a:2:{s:12:\"sid_obj_name\";a:3:{i:0;s:3:\"sid\";i:1;s:3:\"obj\";i:2;s:4:\"name\";}s:7:\"updated\";a:1:{i:0;s:7:\"updated\";}}s:6:\"module\";s:5:\"views\";s:4:\"name\";s:18:\"views_object_cache\";}s:16:\"cache_views_data\";a:6:{s:11:\"description\";s:81:\"Cache table for views to store pre-rendered queries, results, and display output.\";s:6:\"fields\";a:6:{s:3:\"cid\";a:5:{s:11:\"description\";s:29:\"Primary Key: Unique cache ID.\";s:4:\"type\";s:7:\"varchar\";s:6:\"length\";i:255;s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:4:\"data\";a:4:{s:11:\"description\";s:30:\"A collection of data to cache.\";s:4:\"type\";s:4:\"blob\";s:8:\"not null\";b:0;s:4:\"size\";s:3:\"big\";}s:6:\"expire\";a:4:{s:11:\"description\";s:79:\"A Unix timestamp indicating when the cache entry should expire, or 0 for never.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:7:\"created\";a:4:{s:11:\"description\";s:61:\"A Unix timestamp indicating when the cache entry was created.\";s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;}s:7:\"headers\";a:3:{s:11:\"description\";s:51:\"Any custom HTTP headers to be added to cached data.\";s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:0;}s:10:\"serialized\";a:5:{s:11:\"description\";s:64:\"A flag to indicate whether content is serialized (1) or not (0).\";s:4:\"type\";s:3:\"int\";s:4:\"size\";s:5:\"small\";s:8:\"not null\";b:1;s:7:\"default\";i:1;}}s:7:\"indexes\";a:1:{s:6:\"expire\";a:1:{i:0;s:6:\"expire\";}}s:11:\"primary key\";a:1:{i:0;s:3:\"cid\";}s:6:\"module\";s:5:\"views\";s:4:\"name\";s:16:\"cache_views_data\";}s:13:\"devel_queries\";a:5:{s:6:\"fields\";a:4:{s:3:\"qid\";a:3:{s:4:\"type\";s:6:\"serial\";s:8:\"not null\";b:1;s:10:\"disp-width\";s:2:\"10\";}s:8:\"function\";a:4:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";s:3:\"255\";s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}s:5:\"query\";a:2:{s:4:\"type\";s:4:\"text\";s:8:\"not null\";b:1;}s:4:\"hash\";a:4:{s:4:\"type\";s:7:\"varchar\";s:6:\"length\";s:3:\"255\";s:8:\"not null\";b:1;s:7:\"default\";s:0:\"\";}}s:11:\"primary key\";a:1:{i:0;s:4:\"hash\";}s:7:\"indexes\";a:1:{s:3:\"qid\";a:1:{i:0;s:3:\"qid\";}}s:6:\"module\";s:5:\"devel\";s:4:\"name\";s:13:\"devel_queries\";}s:11:\"devel_times\";a:5:{s:6:\"fields\";a:3:{s:3:\"tid\";a:3:{s:4:\"type\";s:6:\"serial\";s:8:\"not null\";b:1;s:10:\"disp-width\";s:2:\"10\";}s:3:\"qid\";a:4:{s:4:\"type\";s:3:\"int\";s:8:\"not null\";b:1;s:7:\"default\";i:0;s:10:\"disp-width\";s:2:\"10\";}s:4:\"time\";a:2:{s:4:\"type\";s:5:\"float\";s:8:\"not null\";b:0;}}s:11:\"primary key\";a:1:{i:0;s:3:\"tid\";}s:7:\"indexes\";a:1:{s:3:\"qid\";a:1:{i:0;s:3:\"qid\";}}s:6:\"module\";s:5:\"devel\";s:4:\"name\";s:11:\"devel_times\";}}', created = 1406659711, expire = 0, headers = '', serialized = 1 WHERE cid = 'schema' in /var/www/html/library/includes/cache.inc on line 109.

2011 marks the 175th anniversary of the National Library of Medicine (NLM), part of the National Institutes of Health. The world's largest medical library and the producer of electronic information resources used by millions of people every day, NLM has changed the way scientific and medical information is organized, stored, accessed, and disseminated. From its founding in 1836 as the library of the U.S. Army Surgeon General to its present position at NIH, NLM's hallmark has been information innovation, leading to exciting scientific discoveries that ultimately improve the public health.

"When you look at the Library's history, you see a fantastic voyage," said Donald A.B. Lindberg, M.D., NLM director since 1984. "Each leg of the journey has brought us closer to our goal of providing access to biomedical information - anytime, anywhere - for scientists, health professionals, and the public. In the time I've been here, we've embraced the Internet as the primary mode of delivering our services," he continued. "We have also expanded our portfolio to include genetic sequence data, high-resolution anatomic images, clinical trials information, and a wide array of high-quality information for consumers. We look forward to whatever astonishing developments the next 175 years might bring."

Key advances in the Library's history include:

  • NLM has made it easy to find and search the biomedical literature.
  • Index Medicus, a groundbreaking index of medical journal articles first published in 1879, evolved into MEDLINE, the first marriage of online search technology and nationwide telecommunications, in 1971.
  • In its current form, PubMed/MEDLINE connects indexed references to many kinds of related information, including gene sequences, chemical information, and the full text of articles stored on publishers' websites, or at NLM itself. Freely available via the Internet since 1997, PubMed/MEDLINE is the most frequently consulted scientific/medical database in the world.
  • NLM established librarian training programs and the National Network of Libraries of Medicine in the late 1960s to equalize access to the biomedical literature across the country. Now with nearly 6,000 members, NLM and this network of academic, hospital, and public libraries partner with community-based organizations to bring high-quality information services to health professionals and the public - regardless of geographic location, socioeconomic status, or level of access to computers and telecommunications.
  • NLM has conducted and supported training programs and groundbreaking informatics research and development for more than 40 years. The Library, its grantees, and its former trainees continue to play essential roles in the development of electronic health records, health data standards, and the exchange of health information.
  • NLM is home to the National Center for Biotechnology Information (NCBI), established in 1988 as a national resource for molecular biology information. Today, NCBI is an indispensible international repository and software tool developer for genetic sequences and other scientific data, and a pioneer and leader in linking data and published research results to promote new scientific discoveries.
  • NLM began intensive development of Web health information services for the general public in 1998 with the release of MedlinePlus.gov. Now available in English and Spanish, MedlinePlus is one of many NLM consumer health information products also available on mobile devices such as smartphones
  • NLM released ClinicalTrials.gov in 2000. It is now the world's largest source of information about clinical trials recruiting for patients and healthy volunteers, and also provides summary results of some trials long before they appear in the published literature.
  • NLM began providing toxicology and environmental health data for use in emergency response and disaster management in the mid-1960s. Today, it produces information services to help health professionals, disaster information specialists, and the general public cope with emergencies and disasters. Topics addressed range from children swallowing household cleaners to overturned trucks carrying hazardous materials to the widespread effects of hurricanes, earthquakes, wildfires, and oil spills.
  • NLM has a state-of-the-art data center, to ensure uninterrupted access to essential information services that are accessed billions of times each year. This center has maximized the utilization of available computing resources by introducing centralized shared data storage, energy efficiency initiatives, and the establishment of an offsite redundant data center for disaster recovery.

For details on NLM's history, its programs and services, and its anniversary year calendar, visit the 175th anniversary website: http://www.nlm.nih.gov/175.

The National Library of Medicine (NLM) is the world's largest library of the health sciences and collections, organizes and makes available biomedical science information to scientists, health professionals and the public. For more information, visit the website at http://www.nlm.nih.gov.

About the National Institutes of Health (NIH): NIH, the nation's medical research agency, includes 27 Institutes and Centers and is a component of the U.S. Department of Health and Human Services. NIH is the primary federal agency conducting and supporting basic, clinical, and translational medical research, and is investigating the causes, treatments, and cures for both common and rare diseases. For more information about NIH and its programs, visit www.nih.gov.

From: http://www.nih.gov/news/health/mar2011/nlm-14.htm

 

Next Article: BL Supports Breast Cancer Research