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




--
-- Database: `era_d2cshow`
--

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

--
-- 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=MyISAM 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'),
('pathauto_node_update_action', 'node', 'pathauto_node_update_action', '', 'Update node alias'),
('pathauto_taxonomy_term_update_action', 'taxonomy_term', 'pathauto_taxonomy_term_update_action', '', 'Update taxonomy term alias'),
('pathauto_user_update_action', 'user', 'pathauto_user_update_action', '', 'Update user alias');

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

--
-- 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=MyISAM 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=MyISAM 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=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Stores block settings, such as region and visibility...' AUTO_INCREMENT=155 ;

--
-- 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, 0, '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, 3, 'dashboard_sidebar', 0, 0, '', '', -1),
(12, 'search', 'form', 'seven', 1, 2, '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, '', '<none>', -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, '', '<none>', -1),
(30, 'user', 'online', 'seven', 1, 0, 'dashboard_sidebar', 0, 0, '', '', -1),
(31, 'comment', 'recent', 'tophit', 0, 0, '-1', 0, 0, '', '', 1),
(32, 'node', 'recent', 'tophit', 0, 0, '-1', 0, 0, '', '', 1),
(33, 'node', 'syndicate', 'tophit', 0, 0, '-1', 0, 0, '', '', -1),
(34, 'search', 'form', 'tophit', 1, -16, 'header_right', 0, 0, '', '', -1),
(35, 'shortcut', 'shortcuts', 'tophit', 0, 0, '-1', 0, 0, '', '', -1),
(36, 'system', 'help', 'tophit', 1, 0, 'help', 0, 0, '', '', -1),
(37, 'system', 'main', 'tophit', 1, -14, 'content', 0, 0, '', '', -1),
(38, 'system', 'main-menu', 'tophit', 0, -15, '-1', 0, 0, '', '<none>', -1),
(39, 'system', 'management', 'tophit', 0, 0, '-1', 0, 0, '', '', -1),
(40, 'system', 'navigation', 'tophit', 0, -10, '-1', 0, 0, '', '', -1),
(41, 'system', 'powered-by', 'tophit', 0, -8, '-1', 0, 0, '', '', -1),
(42, 'system', 'user-menu', 'tophit', 0, 0, '-1', 0, 0, '', '', -1),
(43, 'user', 'login', 'tophit', 0, -10, '-1', 0, 0, '', '', -1),
(44, 'user', 'new', 'tophit', 0, 0, '-1', 0, 0, '', '', 1),
(45, 'user', 'online', 'tophit', 0, 0, '-1', 0, 0, '', '', -1),
(46, 'block', '1', 'bartik', 0, 0, '-1', 0, 1, '<front>', '', -1),
(47, 'block', '1', 'seven', 0, 0, '-1', 0, 1, '<front>', '', -1),
(48, 'block', '1', 'tophit', 1, 0, 'highlighted', 0, 1, '<front>', '', -1),
(52, 'block', '3', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(53, 'block', '3', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(54, 'block', '3', 'tophit', 1, -14, 'footer', 0, 0, '', '', -1),
(55, 'block', '4', 'bartik', 0, 0, '-1', 0, 0, '', 'About', -1),
(56, 'block', '4', 'seven', 0, 0, '-1', 0, 0, '', 'About', -1),
(57, 'block', '4', 'tophit', 1, 0, 'footer_first', 0, 0, '', 'About', -1),
(61, 'block', '6', 'bartik', 0, 0, '-1', 0, 0, '', 'Connect with us', -1),
(62, 'block', '6', 'seven', 0, 0, '-1', 0, 0, '', 'Connect with us', -1),
(63, 'block', '6', 'tophit', 1, 0, 'footer_third', 0, 0, '', 'Connect with us', -1),
(64, 'views', 'promoted_posts-block_1', 'tophit', 1, -15, 'promoted', 0, 1, '<front>', '', -1),
(65, 'views', 'promoted_posts-block_1', 'bartik', 0, 0, '-1', 0, 1, '<front>', '', -1),
(66, 'views', 'promoted_posts-block_1', 'seven', 0, 0, '-1', 0, 1, '<front>', '', -1),
(67, 'blog', 'recent', 'bartik', 0, 0, '-1', 0, 0, '', '', 1),
(68, 'blog', 'recent', 'seven', 1, 1, 'dashboard_sidebar', 0, 0, '', '', 1),
(69, 'blog', 'recent', 'tophit', 0, 0, '-1', 0, 0, '', '', 1),
(70, 'views', 'slideshow-block_1', 'tophit', 1, 0, 'banner', 0, 1, '<front>', '', -1),
(71, 'views', 'slideshow-block_1', 'bartik', 0, 0, '-1', 0, 1, '<front>', '', -1),
(72, 'views', 'slideshow-block_1', 'seven', 0, 0, '-1', 0, 1, '<front>', '', -1),
(73, 'block', '7', 'bartik', 0, 0, '-1', 0, 1, 'contact*', 'Contact information', -1),
(74, 'block', '7', 'seven', 0, 0, '-1', 0, 1, 'contact*', 'Contact information', -1),
(75, 'block', '7', 'tophit', 1, -15, 'sidebar_first', 0, 1, 'contact*', 'Contact information', -1),
(76, 'views', 'testimonials-block_1', 'tophit', 1, -14, 'sidebar_first', 0, 0, 'contact*\r\nnode/5\r\ncontent/session-submission-form-one-hour-format', '', -1),
(77, 'views', 'latest_products-block_1', 'tophit', 1, -17, 'sidebar_first', 0, 0, 'contact*\r\ncontent/session-submission-form', '', -1),
(78, 'views', 'testimonials-block_1', 'bartik', 0, 0, '-1', 0, 0, 'contact*\r\nnode/5\r\ncontent/session-submission-form-one-hour-format', '', -1),
(79, 'views', 'latest_products-block_1', 'bartik', 0, 0, '-1', 0, 0, 'contact*\r\ncontent/session-submission-form', '', -1),
(80, 'views', 'testimonials-block_1', 'seven', 0, 0, '-1', 0, 0, 'contact*\r\nnode/5\r\ncontent/session-submission-form-one-hour-format', '', -1),
(81, 'views', 'latest_products-block_1', 'seven', 0, 0, '-1', 0, 0, 'contact*\r\ncontent/session-submission-form', '', -1),
(82, 'views', 'products_in_use-block_1', 'tophit', 1, -15, 'footer_second', 0, 0, '', 'D2C Highlights', -1),
(83, 'views', 'products_in_use-block_1', 'bartik', 0, 0, '-1', 0, 0, '', 'D2C Highlights', -1),
(84, 'views', 'products_in_use-block_1', 'seven', 0, 0, '-1', 0, 0, '', 'D2C Highlights', -1),
(85, 'block', '8', 'bartik', 0, 0, '-1', 0, 1, 'contact*\r\nnode/5', 'Map', -1),
(86, 'block', '8', 'seven', 0, 0, '-1', 0, 1, 'contact*\r\nnode/5', 'Map', -1),
(87, 'block', '8', 'tophit', 0, -11, '-1', 0, 1, 'contact*\r\nnode/5', 'Map', -1),
(88, 'superfish', '1', 'bartik', 0, 0, '-1', 0, 0, '', '<none>', -1),
(89, 'superfish', '2', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(90, 'superfish', '3', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(91, 'superfish', '4', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(92, 'superfish', '1', 'seven', 0, 0, '-1', 0, 0, '', '<none>', -1),
(93, 'superfish', '2', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(94, 'superfish', '3', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(95, 'superfish', '4', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(96, 'superfish', '1', 'tophit', 1, 0, 'navigation', 0, 0, '', '<none>', -1),
(97, 'superfish', '2', 'tophit', 0, 0, '-1', 0, 0, '', '', -1),
(98, 'superfish', '3', 'tophit', 0, 0, '-1', 0, 0, '', '', -1),
(99, 'superfish', '4', 'tophit', 0, 0, '-1', 0, 0, '', '', -1),
(100, 'menu', 'menu-secondary-menu', 'tophit', 1, -15, 'footer', 0, 0, '', '<none>', -1),
(101, 'menu', 'menu-secondary-menu', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(102, 'menu', 'menu-secondary-menu', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(103, 'mtt_twitter', 'latest_tweets', 'bartik', 0, 0, '-1', 0, 0, 'contact*\r\ncontent/session-submission-form-one-hour-format', 'Latest updates from Twitter', -1),
(104, 'mtt_twitter', 'latest_tweets', 'seven', 0, 0, '-1', 0, 0, 'contact*\r\ncontent/session-submission-form-one-hour-format', 'Latest updates from Twitter', -1),
(105, 'mtt_twitter', 'latest_tweets', 'tophit', 1, -13, 'sidebar_first', 0, 0, 'contact*\r\ncontent/session-submission-form-one-hour-format', 'Latest updates from Twitter', -1),
(106, 'views', 'show_news-block', 'tophit', 1, 0, 'content', 0, 1, 'content/show-news', '<none>', -1),
(107, 'views', 'show_news-block', 'bartik', 0, 0, '-1', 0, 1, 'content/show-news', '<none>', -1),
(108, 'views', 'show_news-block', 'seven', 0, 0, '-1', 0, 1, 'content/show-news', '<none>', -1),
(109, 'block', '9', 'bartik', 0, 0, '-1', 0, 0, '', '<none>', -1),
(110, 'block', '9', 'seven', 0, 0, '-1', 0, 0, '', '<none>', -1),
(111, 'block', '9', 'tophit', 0, -16, '-1', 0, 0, '', '<none>', -1),
(112, 'menu', 'menu-header-link-menu', 'tophit', 1, -17, 'header_right', 0, 0, '', '<none>', -1),
(113, 'menu', 'menu-header-link-menu', 'bartik', 0, 0, '-1', 0, 0, '', '', -1),
(114, 'menu', 'menu-header-link-menu', 'seven', 0, 0, '-1', 0, 0, '', '', -1),
(115, 'block', '10', 'bartik', 0, 0, '-1', 0, 1, 'node/6\r\nexhibit', 'Exhibitor Documents', -1),
(116, 'block', '10', 'seven', 0, 0, '-1', 0, 1, 'node/6\r\nexhibit', 'Exhibitor Documents', -1),
(117, 'block', '10', 'tophit', 1, -16, 'sidebar_first', 0, 1, 'node/6\r\nexhibit', 'Exhibitor Documents', -1),
(118, 'block', '11', 'bartik', 0, 0, '-1', 0, 0, '<home>', '<none>', -1),
(119, 'block', '11', 'seven', 0, 0, '-1', 0, 0, '<home>', '<none>', -1),
(120, 'block', '11', 'tophit', 1, -18, 'sidebar_first', 0, 0, '<home>', '<none>', -1),
(121, 'block', '4', 'garland', 0, 0, '-1', 0, 0, '', '', -1),
(122, 'block', '6', 'garland', 0, 0, '-1', 0, 0, '', '', -1),
(123, 'block', '7', 'garland', 0, 0, '-1', 0, 0, '', '', -1),
(124, 'block', '10', 'garland', 0, 0, '-1', 0, 0, '', '', -1),
(125, 'block', '1', 'garland', 0, 0, '-1', 0, 0, '', '', -1),
(126, 'block', '9', 'garland', 0, 0, '-1', 0, 0, '', '', -1),
(127, 'block', '8', 'garland', 0, 0, '-1', 0, 0, '', '', -1),
(128, 'block', '11', 'garland', 0, 0, '-1', 0, 0, '', '', -1),
(129, 'block', '3', 'garland', 0, 0, '-1', 0, 0, '', '', -1),
(130, 'blog', 'recent', 'garland', 0, 0, '-1', 0, 0, '', '', 1),
(131, 'comment', 'recent', 'garland', 0, 0, '-1', 0, 0, '', '', 1),
(132, 'menu', 'menu-header-link-menu', 'garland', 0, 0, '-1', 0, 0, '', '', -1),
(133, 'menu', 'menu-secondary-menu', 'garland', 0, 0, '-1', 0, 0, '', '', -1),
(134, 'mtt_twitter', 'latest_tweets', 'garland', 0, 0, '-1', 0, 0, '', '', -1),
(135, 'node', 'syndicate', 'garland', 0, 0, '-1', 0, 0, '', '', -1),
(136, 'node', 'recent', 'garland', 0, 0, '-1', 0, 0, '', '', 1),
(137, 'search', 'form', 'garland', 0, 0, '-1', 0, 0, '', '', -1),
(138, 'shortcut', 'shortcuts', 'garland', 0, 0, '-1', 0, 0, '', '', -1),
(139, 'superfish', '1', 'garland', 0, 0, '-1', 0, 0, '', '', -1),
(140, 'system', 'main', 'garland', 1, 0, 'content', 0, 0, '', '', -1),
(141, 'system', 'powered-by', 'garland', 0, 10, '-1', 0, 0, '', '', -1),
(142, 'system', 'help', 'garland', 1, 5, 'help', 0, 0, '', '', -1),
(143, 'system', 'navigation', 'garland', 0, 0, '-1', 0, 0, '', '', -1),
(144, 'system', 'management', 'garland', 0, 0, '-1', 0, 0, '', '', -1),
(145, 'system', 'user-menu', 'garland', 0, 0, '-1', 0, 0, '', '', -1),
(146, 'system', 'main-menu', 'garland', 0, 0, '-1', 0, 0, '', '', -1),
(147, 'user', 'login', 'garland', 0, 0, '-1', 0, 0, '', '', -1),
(148, 'user', 'new', 'garland', 0, 0, '-1', 0, 0, '', '', 1),
(149, 'user', 'online', 'garland', 0, 0, '-1', 0, 0, '', '', -1),
(150, 'views', 'latest_products-block_1', 'garland', 0, 0, '-1', 0, 0, '', '', -1),
(151, 'views', 'testimonials-block_1', 'garland', 0, 0, '-1', 0, 0, '', '', -1),
(152, 'views', 'promoted_posts-block_1', 'garland', 0, 0, '-1', 0, 0, '', '', -1),
(153, 'views', 'slideshow-block_1', 'garland', 0, 0, '-1', 0, 0, '', '', -1),
(154, 'views', 'show_news-block', '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=MyISAM 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=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Stores contents of custom-made blocks.' AUTO_INCREMENT=12 ;

--
-- Dumping data for table `block_custom`
--

INSERT INTO `block_custom` (`bid`, `body`, `info`, `format`) VALUES
(1, '<div class="intro">The ONE Show for Direct-to-Consumer Marketing</div>', 'Intro message', 'full_html'),
(3, '<p>Copyright © Electronic Retailing Association. All rights reserved.</p>', 'Subfooter Message', 'full_html'),
(4, 'The ERA D2C Convention is produced by the Electronic Retailing Association (ERA), the only trade association in the U.S. and internationally that represents leaders of the direct-to-consumer marketplace.<br/><br/>\r\n<strong><?php print l("Read more","node/5"); ?></strong>', 'About', 'php_code'),
(10, '<ul><li><strong><a href="/pdfs/D2C2013_ExhibitSpaceSuiteContract.pdf">Exhibit Space &amp; Suite Contract</a></strong></li><li><strong><a href="/pdfs/D2C2013_VillaSuiteContract.pdf">Villa and Suite Contract</a></strong></li><li><strong><a href="/pdfs/D2C2013_FloorPlan.pdf">Show Floor Map</a></strong></li></ul>', 'Exhibitor Documents', 'full_html'),
(6, 'Follow us on social media, interact with us and find out the latest shoe news.\r\n\r\n<ul class="social-bookmarks">\r\n<li class="facebook"><a href="http://www.facebook.com/ERAD2C?fref=ts"></a></li>\r\n<li class="twitter"><a href="http://twitter.com/davemartin_era"></a></li>\r\n<li class="flickr"><a href="http://www.flickr.com/photos/electronicretailing/collections/"></a></li>\r\n<li class="youtube"><a href="http://www.youtube.com/user/electronicretailing"></a></li>\r\n</ul>\r\n\r\n<div class="preload-social-bookmarks">\r\n<div class="facebook"></div>\r\n<div class="twitter"></div>\r\n<div class="flickr"></div>\r\n<div class="youtube"></div>\r\n</div>', 'Connect with us block', 'full_html'),
(7, '<div class="sidebar-contact-form">Electronic Retailing Association<br>607 14th Street, N.W. Suite 530<br>Washington, D.C. 20005, USA<br>Tel: +1 (703) 841-1751<br>Fax: +1 (425) 977-1036</div>', 'Contact information', 'full_html'),
(11, '<p><a href="http://s4.goeshow.com/era/d2cshow/2013/index.cfm" target="_blank"><img align="center" alt="" src="/images/register_now_button_blue_200.gif"></a></p>', 'Register Now', 'full_html'),
(8, '<p> Find our location in the map below.</p>\r\n<div id="map"><img title="Map" alt="Map" src="<?php print base_path();?>sites/default/files/map.jpg"></div>', 'Map', 'php_code'),
(9, '<p><a href="/content/about-us">About</a>&nbsp; &nbsp;<a href="contact">Contact Us</a>&nbsp; &nbsp;<a href="/user">Log In</a></p>', 'Links in Header', 'full_html');

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

--
-- 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=MyISAM 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=MyISAM 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=MyISAM 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
('ctools_plugin_files:ctools:content_types', 0x[encoded data, 27956 characters], 0, 1361833031, 1),
('filter_formats:en', 0x613a363a7b733a383a227068705f636f6465223b4f3a383a22737464436c617373223a353a7b733a363a22666f726d6174223b733a383a227068705f636f6465223b733a343a226e616d65223b733a383a2250485020636f6465223b733a353a226361636865223b733a313a2230223b733a363a22737461747573223b733a313a2231223b733a363a22776569676874223b733a333a222d3130223b7d733a393a2266756c6c5f68746d6c223b4f3a383a22737464436c617373223a353a7b733a363a22666f726d6174223b733a393a2266756c6c5f68746d6c223b733a343a226e616d65223b733a393a2246756c6c2048544d4c223b733a353a226361636865223b733a313a2231223b733a363a22737461747573223b733a313a2231223b733a363a22776569676874223b733a313a2231223b7d733a363a22636b68746d6c223b4f3a383a22737464436c617373223a353a7b733a363a22666f726d6174223b733a363a22636b68746d6c223b733a343a226e616d65223b733a363a22434b48544d4c223b733a353a226361636865223b733a313a2231223b733a363a22737461747573223b733a313a2231223b733a363a22776569676874223b733a313a2232223b7d733a31333a2266696c74657265645f68746d6c223b4f3a383a22737464436c617373223a353a7b733a363a22666f726d6174223b733a31333a2266696c74657265645f68746d6c223b733a343a226e616d65223b733a31333a2246696c74657265642048544d4c223b733a353a226361636865223b733a313a2231223b733a363a22737461747573223b733a313a2231223b733a363a22776569676874223b733a313a2233223b7d733a31303a22706c61696e5f74657874223b4f3a383a22737464436c617373223a353a7b733a363a22666f726d6174223b733a31303a22706c61696e5f74657874223b733a343a226e616d65223b733a31303a22506c61696e2074657874223b733a353a226361636865223b733a313a2231223b733a363a22737461747573223b733a313a2231223b733a363a22776569676874223b733a323a223130223b7d733a373a2264735f636f6465223b4f3a383a22737464436c617373223a353a7b733a363a22666f726d6174223b733a373a2264735f636f6465223b733a343a226e616d65223b733a31383a22446973706c617920537569746520636f6465223b733a353a226361636865223b733a313a2230223b733a363a22737461747573223b733a313a2231223b733a363a22776569676874223b733a323a223132223b7d7d, 0, 1361833031, 1),
('ctools_plugin_files:panels:styles', 0x613a313a7b733a363a2270616e656c73223b613a363a7b733a31353a22726f756e6465645f636f726e657273223b4f3a383a22737464436c617373223a333a7b733a333a22757269223b733a36373a2273697465732f616c6c2f6d6f64756c65732f70616e656c732f706c7567696e732f7374796c65732f636f726e6572732f726f756e6465645f636f726e6572732e696e63223b733a383a2266696c656e616d65223b733a31393a22726f756e6465645f636f726e6572732e696e63223b733a343a226e616d65223b733a31353a22726f756e6465645f636f726e657273223b7d733a383a227374796c697a6572223b4f3a383a22737464436c617373223a333a7b733a333a22757269223b733a35323a2273697465732f616c6c2f6d6f64756c65732f70616e656c732f706c7567696e732f7374796c65732f7374796c697a65722e696e63223b733a383a2266696c656e616d65223b733a31323a227374796c697a65722e696e63223b733a343a226e616d65223b733a383a227374796c697a6572223b7d733a373a2264656661756c74223b4f3a383a22737464436c617373223a333a7b733a333a22757269223b733a35313a2273697465732f616c6c2f6d6f64756c65732f70616e656c732f706c7567696e732f7374796c65732f64656661756c742e696e63223b733a383a2266696c656e616d65223b733a31313a2264656661756c742e696e63223b733a343a226e616d65223b733a373a2264656661756c74223b7d733a353a22626c6f636b223b4f3a383a22737464436c617373223a333a7b733a333a22757269223b733a34393a2273697465732f616c6c2f6d6f64756c65732f70616e656c732f706c7567696e732f7374796c65732f626c6f636b2e696e63223b733a383a2266696c656e616d65223b733a393a22626c6f636b2e696e63223b733a343a226e616d65223b733a353a22626c6f636b223b7d733a353a226e616b6564223b4f3a383a22737464436c617373223a333a7b733a333a22757269223b733a34393a2273697465732f616c6c2f6d6f64756c65732f70616e656c732f706c7567696e732f7374796c65732f6e616b65642e696e63223b733a383a2266696c656e616d65223b733a393a226e616b65642e696e63223b733a343a226e616d65223b733a353a226e616b6564223b7d733a343a226c697374223b4f3a383a22737464436c617373223a333a7b733a333a22757269223b733a34383a2273697465732f616c6c2f6d6f64756c65732f70616e656c732f706c7567696e732f7374796c65732f6c6973742e696e63223b733a383a2266696c656e616d65223b733a383a226c6973742e696e63223b733a343a226e616d65223b733a343a226c697374223b7d7d7d, 0, 1361833031, 1),
('ctools_plugin_files:stylizer:style_bases', 0x613a313a7b733a363a2270616e656c73223b613a343a7b733a31363a22726567696f6e5f706c61696e5f626f78223b4f3a383a22737464436c617373223a333a7b733a333a22757269223b733a38393a2273697465732f616c6c2f6d6f64756c65732f70616e656c732f706c7567696e732f7374796c655f62617365732f726567696f6e2f726567696f6e5f706c61696e5f626f782f726567696f6e5f706c61696e5f626f782e696e63223b733a383a2266696c656e616d65223b733a32303a22726567696f6e5f706c61696e5f626f782e696e63223b733a343a226e616d65223b733a31363a22726567696f6e5f706c61696e5f626f78223b7d733a32313a22726567696f6e5f726f756e6465645f736861646f77223b4f3a383a22737464436c617373223a333a7b733a333a22757269223b733a39393a2273697465732f616c6c2f6d6f64756c65732f70616e656c732f706c7567696e732f7374796c655f62617365732f726567696f6e2f726567696f6e5f726f756e6465645f736861646f772f726567696f6e5f726f756e6465645f736861646f772e696e63223b733a383a2266696c656e616d65223b733a32353a22726567696f6e5f726f756e6465645f736861646f772e696e63223b733a343a226e616d65223b733a32313a22726567696f6e5f726f756e6465645f736861646f77223b7d733a31343a2270616e655f706c61696e5f626f78223b4f3a383a22737464436c617373223a333a7b733a333a22757269223b733a38333a2273697465732f616c6c2f6d6f64756c65732f70616e656c732f706c7567696e732f7374796c655f62617365732f70616e652f70616e655f706c61696e5f626f782f70616e655f706c61696e5f626f782e696e63223b733a383a2266696c656e616d65223b733a31383a2270616e655f706c61696e5f626f782e696e63223b733a343a226e616d65223b733a31343a2270616e655f706c61696e5f626f78223b7d733a31393a2270616e655f726f756e6465645f736861646f77223b4f3a383a22737464436c617373223a333a7b733a333a22757269223b733a39333a2273697465732f616c6c2f6d6f64756c65732f70616e656c732f706c7567696e732f7374796c655f62617365732f70616e652f70616e655f726f756e6465645f736861646f772f70616e655f726f756e6465645f736861646f772e696e63223b733a383a2266696c656e616d65223b733a32333a2270616e655f726f756e6465645f736861646f772e696e63223b733a343a226e616d65223b733a31393a2270616e655f726f756e6465645f736861646f77223b7d7d7d, 0, 1361833031, 1);
INSERT INTO `cache` (`cid`, `data`, `expire`, `created`, `serialized`) VALUES
('theme_registry:build:modules', 0x[encoded data, 295046 characters], 0, 1361833031, 1);
INSERT INTO `cache` (`cid`, `data`, `expire`, `created`, `serialized`) VALUES
('schema:runtime:', 0x[encoded data, 53494 characters], 0, 1361880699, 1);
