-- http://www.phpmyadmin.net
--




--
-- Database: `expertways`
--

-- --------------------------------------------------------

--
-- Table structure for table `actions`
--

CREATE TABLE IF NOT EXISTS `actions` (
  `aid` varchar(255) NOT NULL DEFAULT '0' COMMENT 'Primary Key: Unique actions ID.',
  `type` varchar(32) NOT NULL DEFAULT '' COMMENT 'The object that that action acts on (node, user, comment, system or custom types.)',
  `callback` varchar(255) NOT NULL DEFAULT '' COMMENT 'The callback function that executes when the action runs.',
  `parameters` longblob NOT NULL COMMENT 'Parameters to be passed to the callback function.',
  `label` varchar(255) NOT NULL DEFAULT '0' COMMENT 'Label of the action.',
  PRIMARY KEY (`aid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores action information.';

--
-- Dumping data for table `actions`
--

INSERT INTO `actions` (`aid`, `type`, `callback`, `parameters`, `label`) VALUES
('comment_publish_action', 'comment', 'comment_publish_action', '', 'Publish comment'),
('comment_save_action', 'comment', 'comment_save_action', '', 'Save comment'),
('comment_unpublish_action', 'comment', 'comment_unpublish_action', '', 'Unpublish comment'),
('node_make_sticky_action', 'node', 'node_make_sticky_action', '', 'Make content sticky'),
('node_make_unsticky_action', 'node', 'node_make_unsticky_action', '', 'Make content unsticky'),
('node_promote_action', 'node', 'node_promote_action', '', 'Promote content to front page'),
('node_publish_action', 'node', 'node_publish_action', '', 'Publish content'),
('node_save_action', 'node', 'node_save_action', '', 'Save content'),
('node_unpromote_action', 'node', 'node_unpromote_action', '', 'Remove content from front page'),
('node_unpublish_action', 'node', 'node_unpublish_action', '', 'Unpublish content'),
('system_block_ip_action', 'user', 'system_block_ip_action', '', 'Ban IP address of current user'),
('user_block_user_action', 'user', 'user_block_user_action', '', 'Block current user');

-- --------------------------------------------------------

--
-- Table structure for table `authmap`
--

CREATE TABLE IF NOT EXISTS `authmap` (
  `aid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: Unique authmap ID.',
  `uid` int(11) NOT NULL DEFAULT '0' COMMENT 'User’s users.uid.',
  `authname` varchar(128) NOT NULL DEFAULT '' COMMENT 'Unique authentication name.',
  `module` varchar(128) NOT NULL DEFAULT '' COMMENT 'Module which is controlling the authentication.',
  PRIMARY KEY (`aid`),
  UNIQUE KEY `authname` (`authname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores distributed authentication mapping.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `batch`
--

CREATE TABLE IF NOT EXISTS `batch` (
  `bid` int(10) unsigned NOT NULL COMMENT 'Primary Key: Unique batch ID.',
  `token` varchar(64) NOT NULL COMMENT '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.',
  `timestamp` int(11) NOT NULL COMMENT 'A Unix timestamp indicating when this batch was submitted for processing. Stale batches are purged at cron time.',
  `batch` longblob COMMENT 'A serialized array containing the processing data for the batch.',
  PRIMARY KEY (`bid`),
  KEY `token` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores details about batches (processes that run in...';

-- --------------------------------------------------------

--
-- Table structure for table `block`
--

CREATE TABLE IF NOT EXISTS `block` (
  `bid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: Unique block ID.',
  `module` varchar(64) NOT NULL DEFAULT '' COMMENT 'The module from which the block originates; for example, ’user’ for the Who’s Online block, and ’block’ for any custom blocks.',
  `delta` varchar(32) NOT NULL DEFAULT '0' COMMENT 'Unique ID for block within a module.',
  `theme` varchar(64) NOT NULL DEFAULT '' COMMENT 'The theme under which the block settings apply.',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Block enabled status. (1 = enabled, 0 = disabled)',
  `weight` int(11) NOT NULL DEFAULT '0' COMMENT 'Block weight within region.',
  `region` varchar(64) NOT NULL DEFAULT '' COMMENT 'Theme region within which the block is set.',
  `custom` tinyint(4) NOT NULL DEFAULT '0' COMMENT '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)',
  `visibility` tinyint(4) NOT NULL DEFAULT '0' COMMENT '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)',
  `pages` text NOT NULL COMMENT '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.',
  `title` varchar(64) NOT NULL DEFAULT '' COMMENT '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.)',
  `cache` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'Binary flag to indicate block cache mode. (-2: Custom cache, -1: Do not cache, 1: Cache per role, 2: Cache per user, 4: Cache per page, 8: Block cache global) See DRUPAL_CACHE_* constants in ../includes/common.inc for more detailed information.',
  PRIMARY KEY (`bid`),
  UNIQUE KEY `tmd` (`theme`,`module`,`delta`),
  KEY `list` (`theme`,`status`,`region`,`weight`,`module`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Stores block settings, such as region and visibility...' AUTO_INCREMENT=46 ;

--
-- Dumping data for table `block`
--

INSERT INTO `block` (`bid`, `module`, `delta`, `theme`, `status`, `weight`, `region`, `custom`, `visibility`, `pages`, `title`, `cache`) VALUES
(1, 'system', 'main', 'bartik', 1, 0, 'content', 0, 0, '', '', -1),
(2, 'search', 'form', 'bartik', 1, -1, 'sidebar_first', 0, 0, '', '', -1),
(3, 'node', 'recent', 'seven', 1, 10, 'dashboard_main', 0, 0, '', '', -1),
(4, 'user', 'login', 'bartik', 1, 0, 'sidebar_first', 0, 0, '', '', -1),
(5, 'system', 'navigation', 'bartik', 1, 0, 'sidebar_first', 0, 0, '', '', -1),
(6, 'system', 'powered-by', 'bartik', 1, 10, 'footer', 0, 0, '', '', -1),
(7, 'system', 'help', 'bartik', 1, 0, 'help', 0, 0, '', '', -1),
(8, 'system', 'main', 'seven', 1, 0, 'content', 0, 0, '', '', -1),
(9, 'system', 'help', 'seven', 1, 0, 'help', 0, 0, '', '', -1),
(10, 'user', 'login', 'seven', 1, 10, 'content', 0, 0, '', '', -1),
(11, 'user', 'new', 'seven', 1, 0, 'dashboard_sidebar', 0, 0, '', '', -1),
(12, 'search', 'form', 'seven', 1, -10, 'dashboard_sidebar', 0, 0, '', '', -1),
(13, 'comment', 'recent', 'bartik', 0, 0, '-1', 0, 0, '', '', 1),
(14, 'node', 'syndicate', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(15, 'node', 'recent', 'bartik', 0, 0, '-1', 0, 0, '', '', 1),
(16, 'shortcut', 'shortcuts', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(17, 'system', 'management', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(18, 'system', 'user-menu', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(19, 'system', 'main-menu', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(20, 'user', 'new', 'bartik', 0, 0, '-1', 0, 0, '', '', 1),
(21, 'user', 'online', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(22, 'comment', 'recent', 'seven', 1, 0, 'dashboard_inactive', 0, 0, '', '', 1),
(23, 'node', 'syndicate', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(24, 'shortcut', 'shortcuts', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(25, 'system', 'powered-by', 'seven', 0, 10, '-1', 0, 0, '', '', -1),
(26, 'system', 'navigation', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(27, 'system', 'management', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(28, 'system', 'user-menu', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(29, 'system', 'main-menu', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(30, 'user', 'online', 'seven', 1, 0, 'dashboard_inactive', 0, 0, '', '', -1),
(31, 'comment', 'recent', 'garland', 0, 0, '-1', 0, 0, '', '', 1),
(32, 'node', 'recent', 'garland', 0, 0, '-1', 0, 0, '', '', 1),
(33, 'node', 'syndicate', 'garland', 0, 0, '-1', 0, 0, '', '', -1),
(34, 'search', 'form', 'garland', 1, -1, 'sidebar_first', 0, 0, '', '', -1),
(35, 'shortcut', 'shortcuts', 'garland', 0, 0, '-1', 0, 0, '', '', -1),
(36, 'system', 'help', 'garland', 1, 0, 'help', 0, 0, '', '', -1),
(37, 'system', 'main', 'garland', 1, 0, 'content', 0, 0, '', '', -1),
(38, 'system', 'main-menu', 'garland', 0, 0, '-1', 0, 0, '', '', -1),
(39, 'system', 'management', 'garland', 0, 0, '-1', 0, 0, '', '', -1),
(40, 'system', 'navigation', 'garland', 1, 0, 'sidebar_first', 0, 0, '', '', -1),
(41, 'system', 'powered-by', 'garland', 1, 10, 'footer', 0, 0, '', '', -1),
(42, 'system', 'user-menu', 'garland', 0, 0, '-1', 0, 0, '', '', -1),
(43, 'user', 'login', 'garland', 1, 0, 'sidebar_first', 0, 0, '', '', -1),
(44, 'user', 'new', 'garland', 0, 0, '-1', 0, 0, '', '', 1),
(45, 'user', 'online', 'garland', 0, 0, '-1', 0, 0, '', '', -1);

-- --------------------------------------------------------

--
-- Table structure for table `blocked_ips`
--

CREATE TABLE IF NOT EXISTS `blocked_ips` (
  `iid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: unique ID for IP addresses.',
  `ip` varchar(40) NOT NULL DEFAULT '' COMMENT 'IP address',
  PRIMARY KEY (`iid`),
  KEY `blocked_ip` (`ip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores blocked IP addresses.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `block_custom`
--

CREATE TABLE IF NOT EXISTS `block_custom` (
  `bid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'The block’s block.bid.',
  `body` longtext COMMENT 'Block contents.',
  `info` varchar(128) NOT NULL DEFAULT '' COMMENT 'Block description.',
  `format` varchar(255) DEFAULT NULL COMMENT 'The filter_format.format of the block body.',
  PRIMARY KEY (`bid`),
  UNIQUE KEY `info` (`info`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores contents of custom-made blocks.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `block_node_type`
--

CREATE TABLE IF NOT EXISTS `block_node_type` (
  `module` varchar(64) NOT NULL COMMENT 'The block’s origin module, from block.module.',
  `delta` varchar(32) NOT NULL COMMENT 'The block’s unique delta within module, from block.delta.',
  `type` varchar(32) NOT NULL COMMENT 'The machine-readable name of this type from node_type.type.',
  PRIMARY KEY (`module`,`delta`,`type`),
  KEY `type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sets up display criteria for blocks based on content types';

-- --------------------------------------------------------

--
-- Table structure for table `block_role`
--

CREATE TABLE IF NOT EXISTS `block_role` (
  `module` varchar(64) NOT NULL COMMENT 'The block’s origin module, from block.module.',
  `delta` varchar(32) NOT NULL COMMENT 'The block’s unique delta within module, from block.delta.',
  `rid` int(10) unsigned NOT NULL COMMENT 'The user’s role ID from users_roles.rid.',
  PRIMARY KEY (`module`,`delta`,`rid`),
  KEY `rid` (`rid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sets up access permissions for blocks based on user roles';

-- --------------------------------------------------------

--
-- Table structure for table `cache`
--

CREATE TABLE IF NOT EXISTS `cache` (
  `cid` varchar(255) NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.',
  `data` longblob COMMENT 'A collection of data to cache.',
  `expire` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or 0 for never.',
  `created` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry was created.',
  `serialized` smallint(6) NOT NULL DEFAULT '0' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).',
  PRIMARY KEY (`cid`),
  KEY `expire` (`expire`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Generic cache table for caching things not separated out...';

--
-- Dumping data for table `cache`
--

INSERT INTO `cache` (`cid`, `data`, `expire`, `created`, `serialized`) VALUES
('entity_info:en', 0x[encoded data, 24138 characters], 0, 1350839419, 1),
('filter_formats:en', 0x613a333a7b733a31333a2266696c74657265645f68746d6c223b4f3a383a22737464436c617373223a353a7b733a363a22666f726d6174223b733a31333a2266696c74657265645f68746d6c223b733a343a226e616d65223b733a31333a2246696c74657265642048544d4c223b733a353a226361636865223b733a313a2231223b733a363a22737461747573223b733a313a2231223b733a363a22776569676874223b733a313a2230223b7d733a393a2266756c6c5f68746d6c223b4f3a383a22737464436c617373223a353a7b733a363a22666f726d6174223b733a393a2266756c6c5f68746d6c223b733a343a226e616d65223b733a393a2246756c6c2048544d4c223b733a353a226361636865223b733a313a2231223b733a363a22737461747573223b733a313a2231223b733a363a22776569676874223b733a313a2231223b7d733a31303a22706c61696e5f74657874223b4f3a383a22737464436c617373223a353a7b733a363a22666f726d6174223b733a31303a22706c61696e5f74657874223b733a343a226e616d65223b733a31303a22506c61696e2074657874223b733a353a226361636865223b733a313a2231223b733a363a22737461747573223b733a313a2231223b733a363a22776569676874223b733a323a223130223b7d7d, 0, 1350839427, 1),
('filter_list_format', 0x[encoded data, 7402 characters], 0, 1350839427, 1),
('node_types:en', 0x4f3a383a22737464436c617373223a323a7b733a353a227479706573223b613a323a7b733a373a2261727469636c65223b4f3a383a22737464436c617373223a31343a7b733a343a2274797065223b733a373a2261727469636c65223b733a343a226e616d65223b733a373a2241727469636c65223b733a343a2262617365223b733a31323a226e6f64655f636f6e74656e74223b733a363a226d6f64756c65223b733a343a226e6f6465223b733a31313a226465736372697074696f6e223b733a38393a22557365203c656d3e61727469636c65733c2f656d3e20666f722074696d652d73656e73697469766520636f6e74656e74206c696b65206e6577732c2070726573732072656c6561736573206f7220626c6f6720706f7374732e223b733a343a2268656c70223b733a303a22223b733a393a226861735f7469746c65223b733a313a2231223b733a31313a227469746c655f6c6162656c223b733a353a225469746c65223b733a363a22637573746f6d223b733a313a2231223b733a383a226d6f646966696564223b733a313a2231223b733a363a226c6f636b6564223b733a313a2230223b733a383a2264697361626c6564223b733a313a2230223b733a393a226f7269675f74797065223b733a373a2261727469636c65223b733a31363a2264697361626c65645f6368616e676564223b623a303b7d733a343a2270616765223b4f3a383a22737464436c617373223a31343a7b733a343a2274797065223b733a343a2270616765223b733a343a226e616d65223b733a31303a2242617369632070616765223b733a343a2262617365223b733a31323a226e6f64655f636f6e74656e74223b733a363a226d6f64756c65223b733a343a226e6f6465223b733a31313a226465736372697074696f6e223b733a37373a22557365203c656d3e62617369632070616765733c2f656d3e20666f7220796f75722073746174696320636f6e74656e742c207375636820617320616e202741626f75742075732720706167652e223b733a343a2268656c70223b733a303a22223b733a393a226861735f7469746c65223b733a313a2231223b733a31313a227469746c655f6c6162656c223b733a353a225469746c65223b733a363a22637573746f6d223b733a313a2231223b733a383a226d6f646966696564223b733a313a2231223b733a363a226c6f636b6564223b733a313a2230223b733a383a2264697361626c6564223b733a313a2230223b733a393a226f7269675f74797065223b733a343a2270616765223b733a31363a2264697361626c65645f6368616e676564223b623a303b7d7d733a353a226e616d6573223b613a323a7b733a373a2261727469636c65223b733a373a2241727469636c65223b733a343a2270616765223b733a31303a2242617369632070616765223b7d7d, 0, 1350838895, 1);
INSERT INTO `cache` (`cid`, `data`, `expire`, `created`, `serialized`) VALUES
('schema', 0x[encoded data, 136044 characters], 0, 1350839049, 1);
INSERT INTO `cache` (`cid`, `data`, `expire`, `created`, `serialized`) VALUES
('schema:runtime:', 0x[encoded data, 4980 characters], 0, 1490342761, 1),
('schema:runtime:1', 0x[encoded data, 32112 characters], 0, 1414668124, 1);
INSERT INTO `cache` (`cid`, `data`, `expire`, `created`, `serialized`) VALUES
('theme_registry:bartik', 0x[encoded data, 72890 characters], 0, 1350838927, 1);
INSERT INTO `cache` (`cid`, `data`, `expire`, `created`, `serialized`) VALUES
('theme_registry:build:modules', 0x[encoded data, 87944 characters], 0, 1350838894, 1);
INSERT INTO `cache` (`cid`, `data`, `expire`, `created`, `serialized`) VALUES
('theme_registry:runtime:bartik', 0x[encoded data, 19150 characters], 0, 1350841015, 1),
('theme_registry:runtime:seven', 0x[encoded data, 29280 characters], 0, 1350840776, 1);
