-- Table structure for table `field_data_body`
--

CREATE TABLE IF NOT EXISTS `field_data_body` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `body_value` longtext,
  `body_summary` longtext,
  `body_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `body_format` (`body_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 2 (body)';

--
-- Dumping data for table `field_data_body`
--

INSERT INTO `field_data_body` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `body_value`, `body_summary`, `body_format`) VALUES
('node', 'mt_product', 0, 2, 2, 'und', 0, '<p>From new product presentations to D2C Learning Lounge sessions to the Women in Business Pavilion, there is something for everyone everyday of the show. Please note that events with this symbol beside them <img alt="AAP Button" height="16" src="images/AAP25.jpg" width="25">&nbsp;require an All Access Pass to attend.</p>', '', 'full_html'),
('node', 'page', 0, 4, 4, 'und', 0, '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.</p>\r\n\r\n<blockquote>"Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum."</blockquote>\r\n\r\n<h2>Header 2</h2>\r\nLorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.\r\n\r\n<h2><a href="#">Linked Header 2</a></h2>\r\nLorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.\r\n\r\n<h3>Header 3</h3>\r\nLorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.\r\n\r\n<h4>Header 4</h4>\r\nLorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.\r\n\r\n<h2>Code snippet</h2>\r\n\r\n<code>#header h1 a <br />\r\ndisplay: block;<br />\r\nheight: 80px;<br />\r\nwidth: 300px;<br />\r\n</code>\r\n\r\n<h2>Messages</h2>\r\n\r\n<div class="messages status">Save $100 and register before July 1, 2013!</div>\r\n<div class="messages error">Sample error message. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</div>\r\n<div class="messages warning">Sample warning message. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</div>\r\n\r\n<h2>Paragraph With Links</h2>\r\n<p>Lorem ipsum dolor sit amet, <a href="#">consectetuer adipiscing</a> elit. Donec odio. Quisque volutpat mattis eros. <a href="#">Nullam malesuada</a> erat ut turpis. Suspendisse urna nibh, viverra non, semper suscipit, posuere a, pede.</p>\r\n\r\n<h2>Ordered List</h2>\r\n<ol>\r\n<li>This is a sample <strong>Ordered List</strong>.</li>\r\n<li>Lorem ipsum dolor sit amet consectetuer.</li>\r\n<li>Condimentum quis.</li>\r\n<li>Congue Quisque augue elit dolor.\r\n<ol>\r\n<li>Something goes here.</li>\r\n<li>And another here</li>\r\n<li>Then one more</li>\r\n</ol>\r\n</li>\r\n<li>Congue Quisque augue elit dolor nibh.</li>\r\n</ol>\r\n\r\n<h2>Unordered List</h2>\r\n<ul>\r\n<li>This is a sample <strong>Unordered List</strong>.</li>\r\n<li>Condimentum quis.</li>\r\n<li>Congue Quisque augue elit dolor.\r\n<ul>\r\n<li>Something goes here.</li>\r\n<li>And another here\r\n<ul>\r\n<li>Something here as well</li>      \r\n<li>Something here as well</li>\r\n<li>Something here as well</li>\r\n</ul>\r\n</li>\r\n<li>Then one more</li>\r\n</ul>\r\n</li>\r\n<li>Nunc cursus sem et pretium sapien eget.</li>\r\n</ul>\r\n\r\n<h2>Fieldset</h2>\r\n<fieldset> <legend>Account information</legend> </fieldset>\r\n\r\n<h2>Table</h2>\r\n\r\n<table border="1">\r\n\r\n<tr>\r\n<th>Header 1</th>\r\n<th>Header 2</th>\r\n</tr>\r\n\r\n<tr class="odd">\r\n<td>row 1, cell 1</td>\r\n<td>row 1, cell 2</td>\r\n</tr>\r\n\r\n<tr class="even">\r\n<td>row 2, cell 1</td>\r\n<td>row 2, cell 2</td>\r\n</tr>\r\n\r\n<tr class="odd">\r\n<td>row 3, cell 1</td>\r\n<td>row 3, cell 2</td>\r\n</tr>\r\n\r\n</table>', '', 'full_html'),
('node', 'page', 0, 5, 5, 'und', 0, '<p>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, which includes members that maximize revenues through direct-to-consumer marketing on television, online, mobile and on radio.</p><h2>Future Show Dates/Locations</h2><p><strong>2013</strong><br>September 24-26, 2013<br>Wynn Las Vegas<br>Las Vegas, Nevada</p><p><strong>2014</strong><br>September 16-18, 2014<br>Wynn Las Vegas<br>Las Vegas, Nevada</p><p><strong>2015</strong><br>October 6-8, 2015<br>Wynn Las Vegas<br>Las Vegas, Nevada</p><h2>History</h2><p>The ERA Annual Convention was renamed the ERA D2C Convention in 2009. The show has always been held in Las Vegas, Nevada and the first ERA Annual Convention was held in 1990 soon after the birth of the infomercial. The show has since grown to more than 4,000 attendees and 160+ exhibitors and sponsors.</p><h2>Sponsor</h2><p>The ERA D2C Convention is sponsored, produced and managed by the Electronic Retailing Association (ERA). Show proceeds are used to fund industry and member services.</p>', '', 'full_html'),
('node', 'mt_service', 0, 7, 7, 'und', 0, '<p>Protect your investment and maximize your ROI with sponsorship opportunities at the ERA D2C Convention. Sponsorships deliver the greatest access to the biggest gathering of the direct response elite. With everything from luncheons to reception sponsorships available, there''s an opportunity to fit every need and budget. Stand out and you''ll move ahead.</p>', '', 'full_html'),
('node', 'article', 0, 29, 29, 'und', 0, '<p>This is a test of jerry''s article and blah blah blah . lj;sadhfousdafnv posadjvgpasdf vpoasdfbvjkj''a mefasd;bvjasdfio basofjbvkpasdfoj bpasjepqmrbvg qwer v.</p>', '', 'full_html'),
('node', 'blog', 0, 12, 12, 'und', 0, ' <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad <a href="#">minim veniam</a>, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>\r\n <blockquote>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco...</blockquote>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.</p>', '', 'filtered_html'),
('node', 'mt_testimonial', 0, 10, 10, 'und', 0, '<p>“We attend many conventions each year but the D2C show is at the top of our list. The entire ERA team does an excellent job bringing educational topics, attendees, marketers and vendors together, and the value we get from this show always exceeds our expectations.”</p>', '', 'full_html'),
('node', 'page', 0, 14, 14, 'und', 0, '<p>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, which includes members that maximize revenues through direct-to-consumer marketing on television, online, mobile and on radio.</p><h2>Future Show Dates/Locations</h2><p><strong>2013</strong> September 24-26, 2013 Venue: Wynn Las Vegas Location: Las Vegas, Nevada</p><h3>2014</h3><p>September 16-18, 2014 Wynn Las Vegas, Las Vegas, Nevada 2015 October 6-8, 2015 Wynn Las Vegas, Las Vegas, Nevada History The ERA Annual Convention was renamed the ERA D2C Convention in 2009. The show has always been held in Las Vegas, Nevada and the first ERA Annual Convention was held in 1990 soon after the birth of the infomercial. The show has since grown to more than 4,000 attendees and 160+ exhibitors and sponsors. Sponsor The 2012 ERA D2C Convention is sponsored, produced and managed by the Electronic Retailing Association (ERA). Show proceeds are used to fund industry and member services. Contact Us Electronic Retailing Association (ERA) 607 14th Street, N.W. Suite 530 Washington, D.C. 20005, USA Phone: +1 800-987-6462 or +1 703-841-1751 Fax: 425.977.1036 webadmin@retailing.org www.retailing.org</p>', '', 'full_html'),
('node', 'mt_product', 0, 1, 1, 'und', 0, '<p>Move and shake with the best. The 2013 ERA D2C Convention is THE place to mix it up with industry leaders just like you. The show is packed with networking events where you’ll make the connections and seal the deals that will strengthen your business. Please note that events with this symbol beside them – <img alt="All Access Pass required" height="16" src="http://www.d2cshow.org/images/AAP25.jpg" width="25"> – require an All Access Pass to attend.</p>', '', 'full_html'),
('node', 'page', 0, 45, 45, 'und', 0, '<p>The Electronic Retailing Association (ERA) has enacted the following Speaker Policy for its education conferences and special events, including The Great Ideas Summit and the ERA D2C Convention. Speakers should adhere to the following:&nbsp;</p>\r\n<ul>\r\n	<li>\r\n		A supplier company may speak one time each at The Great Ideas Summit and the ERA D2C Convention, if selected. The supplier may NOT speak at the same conference in subsequent years if the company does not support ERA as a sponsor or exhibitor of that specific event. &nbsp;</li>\r\n	<li>\r\n		A supplier company that is a &ldquo;non-&shy;‐member&rdquo; may speak one time each at The Great Ideas Summit and the ERA D2C Convention, if selected. The supplier may NOT speak at the same conference during subsequent years if the company is a &ldquo;non-&shy;‐member.&rdquo;</li>\r\n	<li>\r\n		Supplier companies that are ERA members will have priority over &ldquo;non-&shy;‐member&rdquo; suppliers in the speaker-&shy;‐selection process.&nbsp;</li>\r\n	<li>\r\n		All selected speakers must complete and sign the ERA Speaker Contract below, which will be distributed to all speakers, and return to ERA by the published deadline.</li>\r\n	<li>\r\n		All selected speakers must be registered with an All Access Pass no later than 30 days prior to the conference date. Speakers will be provided a discounted speaker rate. <strong>(Note: Any speaker who fails to register by the deadline will be removed from the education schedule and replaced, if necessary.)</strong></li>\r\n	<li>\r\n		All speakers will be responsible for all travel arrangements and expenses that they incur.</li>\r\n</ul>\r\n<p>Please contact <a href="mailto:vpaynich@retailing.org">Vi Paynich</a> if you have any questions or comments.</p>\r\n', '', 'full_html'),
('node', 'mt_product', 0, 3, 3, 'und', 0, '<p>The ERA Moxie Awards Gala<sup>TM</sup> is direct response marketing''s premiere celebration honoring the best campaigns of the year. Moxie''s famous posh <span style="color: #0000ff;">BLUE</span> carpet welcomes guests for a grand entrance. The Gala features live music, exceptional dinner and superb company. Join us as we celebrate the industry''s most coveted award and D2C''s most exclusive event.</p><p><strong>Thursday, September 26, 2013</strong><br>Margaux Ballroom<br>7:00 p.m. - 9:30 p.m.</p><div><p><strong>Glitz. Glamour. Glory.</strong></p></div><h2>Tickets</h2><p>The ERA Moxie Awards&nbsp;Gala is a separately ticketed event. In order to attend, you must register for an All Access Pass or a Show Floor Only Pass for the D2C Show and then purchase a ticket (or table) to the Moxie Awards Gala. Here''s a list of the <a href="http://www.retailing.org/events/era-moxie-awards/2012-moxie-winners">2012 ERA Moxie Awards Gala Winners</a>.</p><h2>How to purchase Moxie Awards Gala tickets:</h2><ul><li><strong>Already registered for D2C?</strong> All attendees, exhibitors and sponsors, please purchase your <a href="https://s4.goeshow.com/era/d2cshow/2013/asc_welcome.cfm">Moxie tickets</a> here. Use the login info included in your confirmation email. Click on the first bullet “Moxie Awards Gala Tickets” and proceed to purchase your Moxie tables or individual tickets.</li><li><strong>Not yet registered for D2C?</strong> Register for D2C and then purchase your <a href="https://s4.goeshow.com/era/d2cshow/2013/reg_form.cfm">Moxie tickets</a>.</li></ul><h2>Moxie Gala Tables</h2><p>Reserve a table for you and your guests. Choose where you’d like your table to be at the Gala, receive a table-top sign with your company’s logo and seats for twelve people. <a href="mailto:keppsteiner@retailing.org?Subject=Moxie Awards Gala Table Request">Reserve your table today</a>.</p><h2>Awards Archive</h2><p><a href="http://www.retailing.org/events/era-moxie-awards/2012-moxie-winners">2012 Winners</a><br><a href="http://www.retailing.org/2011-moxie-award-winners" target="_blank">2011 Winners</a></p><p>&nbsp;</p>', '', 'full_html'),
('node', 'page', 0, 18, 18, 'und', 0, '<p>The 2013 ERA D2C Convention takes place in Las Vegas at the Wynn Las Vegas from September 24-26, 2013.</p><p><strong>2013 Show Dates and Location</strong><br>September 24-26, 2013<br>Venue: Wynn Las Vegas&nbsp;<br>Location: Las Vegas, Nevada</p><p>A detailed schedule will be coming soon!</p><p>&nbsp;</p>', '', 'full_html'),
('node', 'page', 0, 21, 21, 'und', 0, '<table border="1" cellpadding="1" cellspacing="1"><thead><tr><th scope="col">All Access Pass</th><th scope="col">Show Floor Only Pass</th></tr></thead><tbody><tr><td><em>Enjoy open access to all D2C activities including:</em></td><td><em>Provides limited access to D2C activities.</em></td></tr><tr><td><ul><li>Online Attendee List</li><li>Opening Reception</li><li>ALL networking events</li><li>Keynote Presentation</li><li>Meet &amp; Greet Lounge</li><li>ERA Circle Bar</li><li>All Access Pass Lounge</li><li>Free Networking Lunches on the Show Floor</li><li>Networking Breakfasts on Wed. &amp;&nbsp;&nbsp;Thurs.</li><li>Discounted show bag inserts (while supplies last)</li></ul></td><td><ul><li>Meet &amp; Greet Lounge</li><li>Keynote Presentation</li><li>ERA Circle Bar</li><li>Show Floor (including the D2C Learning Lounge)</li><li>Free Networking Lunches on the Show Floor</li></ul><p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p></td></tr></tbody></table><br><h2>Individual Registration Rates</h2><table border="1"><tbody><tr><th>Badge Type</th><th>Thru June 30</th><th>July 1 - Sept. 20</th><th>Onsite</th></tr><tr class="odd"><td>All Access Pass - ERA Members</td><td>$850</td><td>$1,129</td><td>$1,329</td></tr><tr class="even"><td>All Access Pass - Non-Members</td><td>$1,399</td><td>$1,599</td><td>$1,699</td></tr><tr class="odd"><td>Additional All Access Pass - ERA Members</td><td>$650</td><td>$929</td><td>$1,129</td></tr><tr class="even"><td>Show Floor Only Pass - ERA Members</td><td>FREE</td><td>$149</td><td>$249</td></tr><tr class="odd"><td>Show Floor Only Pass - ERA Members</td><td>$99</td><td>$199</td><td>$299</td></tr></tbody></table><br><h2>Moxie Awards Gala Tickets</h2><table border="1"><tbody><tr><th>&nbsp;</th><th>Thru June 30</th><th>July 1 - Sept. 20</th><th>Onsite</th></tr><tr class="odd"><td>ERA Members</td><td>$179</td><td>$199</td><td>$249</td></tr><tr class="even"><td>Non-Members</td><td>$299</td><td>$349</td><td>$399</td></tr><tr class="odd"><td>Reserved Table for Twelve</td><td>$2,149</td><td>$2,289</td><td>$2,789</td></tr></tbody></table><p><br><strong>Already registered for D2C?</strong> Please purchase your <a href="https://s4.goeshow.com/era/d2cshow/2013/asc_welcome.cfm">Moxie tickets</a> here. Use the login info included in your confirmation email. Click on the first bullet “Moxie Awards Gala Tickets” and proceed to purchase your Moxie table or individual tickets.</p><p class="mainarticle"><a href="/content/registration-policies"><strong><span style="font-size: large;">Registration Policies</span></strong></a><br>&nbsp;</p><p class="mainarticle">&nbsp;</p>', '', 'full_html'),
('node', 'page', 0, 43, 43, 'und', 0, '<div>\r\n  <h2>Pricing Table &ndash; Style 2</h2>\r\n\r\n  <table class="gen-table pricing-table responsive">\r\n    <thead>\r\n      <tr>\r\n        <th class="empty-left-top">&nbsp;</th>\r\n        <th>\r\n          <span class="title">Basic</span>\r\n          <span class="price">\r\n            <span>&#36;20</span>\r\n            <sup>/month</sup>\r\n          </span> \r\n        </th>\r\n        <th>\r\n          <span class="title">Standard</span>\r\n          <span class="price">\r\n            <span>&#36;50</span>\r\n            <sup>/month</sup>\r\n          </span>  \r\n        </th>\r\n        <th class="featured">\r\n          <span class="title">Plus</span>\r\n          <span class="price">\r\n            <span>&#36;100</span>\r\n            <sup>/month</sup>\r\n          </span> \r\n        </th>\r\n        <th>\r\n          <span class="title">Pro</span>\r\n          <span class="price">\r\n            <span>&#36;150</span>\r\n            <sup>/month</sup>\r\n          </span> \r\n        </th>\r\n      </tr>\r\n    </thead>\r\n    <tfoot>\r\n      <tr>\r\n        <td class="empty-left-bottom">&nbsp;</td>\r\n        <td><a class="button black" href="#">Order Now</a></td>\r\n        <td><a class="button black" href="#">Order Now</a></td>\r\n        <td><a class="button" href="#">Order Now</a></td>\r\n        <td><a class="button black" href="#">Order Now</a></td>\r\n      </tr>\r\n    </tfoot>\r\n    <tbody>\r\n      <tr>\r\n        <th>Users</th>\r\n        <td>5</td>\r\n        <td>20</td>\r\n        <td>60</td>\r\n        <td>120</td>\r\n      </tr>\r\n      <tr class="odd">\r\n        <th>Forms</th>\r\n        <td>10</td>\r\n        <td>Unlimited</td>\r\n        <td>Unlimited</td>\r\n        <td>Unlimited</td>\r\n      </tr>\r\n      <tr>\r\n        <th>Reports</th>\r\n        <td>20</td>\r\n        <td>Unlimited</td>\r\n        <td>Unlimited</td>\r\n        <td>Unlimited</td>\r\n      </tr>\r\n      <tr class="odd">\r\n        <th>Entries / Month</th>\r\n        <td>500</td>\r\n        <td>3,000</td>\r\n        <td>15,000</td>\r\n        <td>100,000</td>\r\n      </tr>\r\n      <tr>\r\n        <th>SSL Encryption</th>\r\n        <td>&mdash;</td>\r\n        <td><span class="check">&nbsp;</span></td>\r\n        <td><span class="check">&nbsp;</span></td>\r\n        <td><span class="check">&nbsp;</span></td>\r\n      </tr>\r\n      <tr class="odd">\r\n        <th>Payment Integration</th>\r\n        <td>&mdash;</td>\r\n        <td><span class="check">&nbsp;</span></td>\r\n        <td><span class="check">&nbsp;</span></td>\r\n        <td><span class="check">&nbsp;</span></td>\r\n      </tr>\r\n      <tr class="row-last">\r\n        <th>Storage</th>\r\n        <td>3 GB</td>\r\n        <td>15 GB</td>\r\n        <td>40 GB</td>\r\n        <td>100 GB</td>\r\n      </tr>\r\n    </tbody>\r\n  </table>\r\n</div>', '', 'full_html'),
('node', 'page', 0, 38, 38, 'und', 0, '<br><p><span style="line-height: 1.538em;">Thank you for your willingness to share your time, knowledge, and resources as a content leader at the 2013 ERA D2C Convention. Below you will find all the resources you need create a successful session for D2C attendees.</span></p><div><span style="line-height: 1.538em;">Get the word out about the conference using our twitter hashtag </span><a href="http://www.twitter.com/search/d2c2013" style="line-height: 1.538em;">#d2c2013</a><span style="line-height: 1.538em;">.</span></div><div>&nbsp;</div><div><strong>Speaker Dates and Deadlines:</strong></div><div>&nbsp;</div><ol><li>Accept speaker letter of agreement: TBD</li><li><span style="line-height: 1.538em;">Update content leader profile: TBD</span></li><li><span style="line-height: 1.538em;">Read the Speaker Manual: TBD</span></li><li><span style="line-height: 1.538em;">Register for the Conference: June 30, 2013</span></li><li><span style="line-height: 1.538em;">Reserve hotel room (if applicable): TBD</span></li><li><span style="line-height: 1.538em;">Attend Speaker Orientation Conference Call: TBD</span></li></ol><div>&nbsp;</div><div>Should you have any questions please contact Vi Paynich at <a href="mailto:vpaynich@retailing.org">vpaynich@retailing.org</a>.</div><div>&nbsp;</div><div>Speaker Policy</div>', '', 'full_html'),
('node', 'page', 0, 37, 37, 'und', 0, '<p>Do you have an innovative idea or topic you want to share with your fellow ERA members and the industry at large? Then the 2013 ERA D2C Convention may be the perfect setting for you! This is your opportunity to participate in the premier annual direct-to-consumer conference in the marketing space and impart your expertise with others in the industry.&nbsp;<span style="line-height: 1.538em;">Once again, the Electronic Retailing Association (ERA) is initiating a crowd-sourcing strategy for the education program at the 2013 ERA D2C Convention.</span></p><p>This year, ERA is offering two different session formats: One-hour Session/Panel discussion and Lightning Sessions (a 15-minute presentation). Please note there are two separate Submission Forms for a One-hour Session and Lightning Session.</p><p>Sessions to be presented will be chosen by a vote of the ERA Content Committee, the ERA Staff and ERA members.</p><p><strong>Getting Started</strong></p><ol><li><a href="/pdfs/D2C2013_Session_Guidelines_011513.pdf">Review the Submission Guidelines</a></li><li>Complete one (or both) of the Session Submission Forms</li></ol><ul style="margin-left: 40px;"><li><a href="/content/session-submission-form">One-hour Session/Panel</a></li><li><a href="/content/session-submission-form">Lightning Session</a> (15-minute format)</li></ul><p><strong>Deadline:</strong>&nbsp;<strong>Wednesday, March 27, 2013</strong></p><p><strong>Questions:</strong><br>Vi Paynich<br>909-606-3406<br><a href="mailto:vpaynich@retailing.org?subject=D2C%20Education%20Session%20Submission%20Question">vpaynich@retailing.org</a></p>', '', 'full_html'),
('node', 'page', 0, 40, 40, 'und', 0, '<h2>Cancellation/Refund Policy&nbsp;</h2><div>All cancellations must be received in writing. <strong>Cancellations received on or before August 25, 2013 are eligible for a 50% refund. No refunds will be made after August 25, 2013.</strong> No-shows will not be refunded. Substitutions from the same company can be made at no charge (see Substitution Policy).</div><div>&nbsp;</div><h2>Substitution Policy</h2><div>Substitution of registrations from the same company is permitted prior to the conference and onsite. Only one substitution is permitted per original registrant. The individual submitting the substitution request is responsible for all financial obligations (any balance due) associated with that substitution as well as updating any contact information. Substitutions cannot be made after a badge has been issued.</div><div>&nbsp;</div><h2>Group Badge Distribution/Pick-Up</h2><div>Group badge pick-up is permitted although not encouraged. In the event that one person from a company collects badges for multiple employees that person accepts full responsibility for those badges. ERA will not re-issue badges directly to those individuals.</div><div>&nbsp;</div><h2>Badge Sharing</h2><div>Each badge is intended for the exclusive use of the person named on the badge. Business cards cannot be used in place of or inserted on top of badges. In the event two or more individuals are found to be sharing a badge, the badge will be immediately voided and no refunds issued. Voided badges will not be available for re-issue. Attendees may be asked to show valid identification. Failure to present a photo ID matching the name on the badge in question upon request will result in the forfeiture of the badge.</div><div>&nbsp;</div><h2>Badge Downgrades&nbsp;</h2><div>A badge downgrade from an All Access Pass to a Show Floor Only Pass is considered a cancellation of the original All Access Pass (see the Cancellation Policy for refund information). The new registration for the Show Floor Only Pass will be based on current registration rates.</div><div>&nbsp;</div><h2>Guest Passes</h2><div>Guest passes must be pre-registered on or before September 20, 2013. New registration requests onsite for Guest Passes through the Exhibitor Invites program are not allowed.</div><div>&nbsp;</div><h2>ERA Member Pricing Policy</h2><div>In order to receive ERA member pricing for all ERA events, the member must be in good standing at the time the registration is made AND at the time of the event. If ERA membership has lapsed, the individual will be required to pay the difference between ERA member and non-member rates before an attendee badge is provided.</div><div>&nbsp;</div><div><h2>Company Name Policy</h2></div><div>In order to receive member pricing the company name on the attendee badge must match the company name on the ERA membership.</div><div>&nbsp;</div><h2>Consent to Use of Photographic Images</h2><div>Registration and attendance at, or participation in, ERA meetings and other activities constitutes an agreement by the registrant to ERA''s use and distribution (both now and in the future) of the registrant or attendee''s image or voice in photographs, videotapes, electronic reproductions and audiotapes of such events and activities.</div><div>&nbsp;</div><h2>Children, Friends and Family</h2><div>The D2C Convention is a trade-only event. Children, friends and family who accompany an attendee to Las Vegas will not be granted access to the ERA D2C Convention unless they are over the age of 18 and have proof of industry affiliation and are a registered attendee. Absolutely no one under the age of 18 is permitted on the show floor including infants or children in strollers.</div><div>&nbsp;</div><h2>Questions?</h2><div>Contact ERA Customer Service at <a href="mailto:registration@retailing.org">registration@retailing.org</a> or call 703-841-1751.</div>', '', 'full_html'),
('node', 'mt_service', 0, 6, 6, 'und', 0, '<p>The D2C Show provides your company with an unparalleled marketing opportunity to get before industry decision-makers.Nearly 4,000 attendees from all facets of direct response marketing come to D2C to learn about the latest technologies and network with their peers. It''s everyone from managers to C-level executives to inventors to founders. It''s where they come to make decisions about where they want to take their business in the years to come — and what they''ll buy to make those plans happen.</p>', '', 'full_html'),
('node', 'mt_testimonial', 0, 9, 9, 'und', 0, '<p>“It was impossible for visitors not to see us at ERA D2C and we had lots of good conversations. You have given us many opportunities for networking and the ﬁrst time placement at the show was great"</p>', '', 'full_html'),
('node', 'page', 0, 23, 23, 'und', 0, '<p>The ERA D2C Convention is truly a global stage for the direct response industry. Attendees from more than 60 countries have traveled to Las Vegas in the past to network with leaders from around the world and to attend the best education sessions for the DR industry.</p><p><strong>Need a visa</strong>? You can now complete the <a href="https://evisaforms.state.gov/ds156.asp?lang=1" target="_blank">visa application form online</a>.</p>', '', 'full_html'),
('node', 'mt_testimonial', 0, 49, 49, 'und', 0, '<p>Attending the ERA D2C convention gave UPS an opportunity to help attendees understand their supply chains. &nbsp;We focused on the customer buying experience and how logistics can support their goals. &nbsp;The ERA match- making service allowed UPS to accomplish this with new potential clients.</p>', '', 'full_html'),
('node', 'page', 0, 26, 26, 'und', 0, '<p><span style="line-height: 1.538em;">If you wish to pay by check or wire transfer, please fill out the </span><a href="/pdfs/D2C2013_Group_WireandCheck_Reg.xlsx" style="line-height: 1.538em;">Check/Wire transfer template</a><span style="line-height: 1.538em;"> and return to </span><a href="mailto:registration@retailing.org" style="line-height: 1.538em;">registration@retailing.org</a><span style="line-height: 1.538em;">. Once your payment is received we will process your registrations.&nbsp;</span><span style="line-height: 1.538em;">If you have any questions regarding registration please refer to the&nbsp;</span><a href="#FAQ" style="line-height: 1.538em;">FAQ''s</a><span style="line-height: 1.538em;">&nbsp;below</span><span style="line-height: 1.538em;">.</span></p><ul><li><strong><a href="/pdfs/D2C2013_Group_WireandCheck_Reg.xlsx" style="line-height: 1.538em;">Check/Wire transfer template</a></strong></li></ul><p><strong style="line-height: 1.538em;"><span style="text-decoration: underline;">FAQ''s</span></strong><a name="FAQ"></a></p><p><strong>Q: I sent in a check for registrations, when will I receive confirmation?</strong><br><span style="line-height: 1.538em;">A: Once we receive your check we will immediately process your registrations and you will receive an email confirmation.</span></p><p><strong>Q: If I am paying by credit card and do not have a group to register, where can I register?</strong><br><span style="line-height: 1.538em;">A: Visit the </span><a href="https://s4.goeshow.com/era/d2cshow/2013/reg_form.cfm" style="line-height: 1.538em;">registration site</a><span style="line-height: 1.538em;"> and follow the steps to register.</span></p><p><strong>Q:Where should I send my registration check?</strong><br><span style="line-height: 1.538em;">A: Please send to:</span></p><p>Electronic Retailing Association<br>607 14th St. NW, Suite 530<br>Washington, DC 20005</p><p><strong>Q: I have a question about the registration process, who should I contact?</strong><br><span style="line-height: 1.538em;">A: Please contact </span><a href="mailto:registration@retailing.org" style="line-height: 1.538em;">registration@retailing.org</a><span style="line-height: 1.538em;"> and we will get back to you shortly to assist you with registration.</span></p><p>&nbsp;</p><p>&nbsp;</p>', '', 'full_html'),
('node', 'page', 0, 24, 24, 'und', 0, '<h2><span style="color:#D84A27;">D2C Provides New Business, Ideas and Solutions!</span></h2><p>More than 3,400 DR decision-makers, including many of your competitors, attend the 2013 ERA D2C Convention to get ideas and find answers to their direct response problems. They will see new solutions demonstrated ... and choose the best for their needs.</p><div>At D2C they find ways to drive new business and optimize ROI. They know that to survive and succeed, they must keep up with the latest DR trends ... and stay ahead of their competitors!</div><h2><span style="color:#D84A27;">Find All the People You NeeD2C</span></h2><ul><li><span style="font-size:20px;"><strong>63%</strong></span> believed there was a good mix of exhibitors, products and services on the show floor</li><li><span style="font-size:20px;"><strong>53%</strong></span> said the opportunities to network were excellent</li><li><span style="font-size:20px;"><strong>60%</strong></span> signed a deal as a result of attending the show</li><li><span style="font-size:20px;"><strong>54%</strong></span> had at least 10 meetings during the show (and 31% had more tan 20 meetings!)</li><li><span style="font-size:20px;"><strong>55%</strong></span> generated at least 6 leads as a result of attending the show (and 23% generated at least 10 leads!)</li></ul><h2><span style="color:#D84A27;">Who Should Attend D2C?</span></h2><p>Everyone involved in direct response marketing benefits from the networking, business development, exhibitors and education sessions at the D2C show!</p><ul><li>Executives building a business</li><li><div>Decision makers involved in DR marketing purchases</div></li><li><div><span style="line-height: 1.538em;">Marketers in search of&nbsp;new products and services</span></div></li><li><div>Agencies providing creative and production services</div></li><li><div><span style="line-height: 1.538em;">Media Buyers who purchase TV and radio time</span></div></li><li><div><span style="line-height: 1.538em;">Suppliers who fulfill orders</span></div></li><li><div><span style="line-height: 1.538em;">All staff members and suppliers you count on for new ideas</span></div></li></ul>', '', 'full_html'),
('node', 'article', 0, 27, 27, 'und', 0, '<p>Registration for the 2013 ERA D2C Convention opens on Monday, February, 25, 2013. Look for special offers from ERA on February 25 and SAVE big!</p>', '', 'full_html'),
('node', 'page', 0, 30, 30, 'und', 0, '<table border="1" cellpadding="1" cellspacing="1" style="width: 625px; height: 214px;"><thead><tr><th scope="col">All Access Pass</th><th scope="col">Show Floor Only Pass</th></tr></thead><tbody><tr><td><em>Enjoy open access to all D2C activities including:</em></td><td><em>Provides limited access to D2C activities.</em></td></tr><tr><td><ul><li>Online Attendee List</li><li>Opening Reception</li><li>ALL networking events</li><li>Keynote Presentation</li><li>Meet &amp; Greet Lounge</li><li>ERA Circle Bar</li><li>All Access Pass Lounge</li><li>Free Networking Lunches on the Show Floor</li><li>Networking Breakfasts on Wed. &amp;&nbsp;&nbsp;Thurs.</li><li>Discounted show bag inserts (while supplies last)</li></ul></td><td><ul><li>Meet &amp; Greet Lounge</li><li>Keynote Presentation</li><li>ERA Circle Bar</li><li>Show Floor (including the D2C Learning Lounge)</li><li>Free Networking Lunches on the Show Floor</li></ul><p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p></td></tr></tbody></table><h2>Exhibitor/Sponsor Registration Rates</h2><table border="1" cellpadding="1" cellspacing="1" style="width: 625px;"><thead><tr><th scope="col" style="text-align: left;">Badge Type</th><th scope="col">Thru June 30</th><th scope="col">July 1 - Sept. 20</th><th scope="col">OnSite</th></tr></thead><tbody><tr><td>All Access Pass<br>(<span style="font-size: 0.923em; line-height: 1.538em;">Two free All Access Passes for each 100 sq. ft. of exhibit space)</span></td><td>FREE</td><td>FREE</td><td>FREE</td></tr><tr><td><p>Additional All Access Pass for Exhibitors/Sponsors from the same company:</p></td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr><tr><td><p style="margin-left: 40px;">ERA Members</p></td><td>$599</td><td>$799</td><td>$999</td></tr><tr><td><p style="margin-left: 40px;">Non-Members</p></td><td>$699</td><td>$999</td><td>$1,199</td></tr><tr><td>Show Floor Only Pass (Four free Show Floor Only Passes for each 100 sq. ft. of exhibit space)</td><td>FREE</td><td>FREE</td><td>FREE</td></tr><tr><td>Additional Show Floor Only Pass for&nbsp;Exhibitors/Sponsors from same company:</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr><tr><td><p style="margin-left: 40px;">ERA Members</p></td><td>FREE</td><td>$149</td><td>$249</td></tr><tr><td><p style="margin-left: 40px;">Non-Members</p></td><td>$99</td><td>$199</td><td>$299</td></tr></tbody></table><h2>Moxie Awards Gala Tickets</h2><table border="1" cellpadding="1" cellspacing="1" style="width: 625px;"><thead><tr><th scope="col">&nbsp;</th><th scope="col">THRU JUNE 30</th><th scope="col">JULY 1 - SEPT. 20</th><th scope="col">ONSITE</th></tr></thead><tbody><tr><td>ERA Members</td><td>$179</td><td>$199</td><td>$249</td></tr><tr><td>Non-Members</td><td>$299</td><td>$349</td><td>$399</td></tr><tr><td>Reserved Table for Twelve</td><td>$2,149</td><td>$2,289</td><td>$2,789</td></tr></tbody></table><p>&nbsp;</p><p><strong>Already registered for D2C?</strong> Please purchase your <a href="https://s4.goeshow.com/era/d2cshow/2013/asc_welcome.cfm">Moxie tickets</a> here. Use the login info included in your confirmation email. Click on the first bullet “Moxie Awards Gala Tickets” and proceed to purchase your Moxie table or individual tickets.</p><p class="mainarticle"><a href="/content/registration-policies"><strong><span style="font-size: large;">Registration Policies</span></strong></a><br>&nbsp;</p><p class="mainarticle">&nbsp;</p>', '', 'full_html'),
('node', 'mt_event', 0, 83, 83, 'und', 0, '<p>The ERA Moxie Awards Gala<sup>TM</sup> is direct response marketing''s premiere celebration honoring the best campaigns of the year. Moxie''s famous posh <span style="color: rgb(0, 0, 255);">BLUE</span> carpet welcomes guests for a grand entrance. The Gala features live music, exceptional dinner and superb company. Join us as we celebrate the industry''s most coveted award and D2C''s most exclusive event.</p><p><strong>Thursday, September 26, 2013</strong><br>Margaux Ballroom<br>7:00 p.m. - 9:30 p.m.</p><div><p><strong>Glitz. Glamour. Glory.</strong></p></div><h2>Tickets</h2><p>The ERA Moxie Awards&nbsp;Gala is a separately ticketed event. In order to attend, you must register for an All Access Pass or a Show Floor Only Pass for the D2C Show and then purchase a ticket (or table) to the Moxie Awards Gala. Here''s a list of the <a href="http://www.retailing.org/events/era-moxie-awards/2012-moxie-winners">2012 ERA Moxie Awards Gala Winners</a>.</p><h2>How to purchase Moxie Awards Gala tickets:</h2><ul><li><strong>Already registered for D2C?</strong> All attendees, exhibitors and sponsors, please purchase your <a href="https://s4.goeshow.com/era/d2cshow/2013/asc_welcome.cfm">Moxie tickets</a> here. Use the login info included in your confirmation email. Click on the first bullet “Moxie Awards Gala Tickets” and proceed to purchase your Moxie tables or individual tickets.</li><li><strong>Not yet registered for D2C?</strong> Register for D2C and then purchase your <a href="https://s4.goeshow.com/era/d2cshow/2013/reg_form.cfm">Moxie tickets</a>.</li></ul><h2>Moxie Gala Tables</h2><p>Reserve a table for you and your guests. Choose where you’d like your table to be at the Gala, receive a table-top sign with your company’s logo and seats for twelve people. <a href="mailto:keppsteiner@retailing.org?Subject=Moxie Awards Gala Table Request">Reserve your table today</a>.</p><h2>Awards Archive</h2><p><a href="http://www.retailing.org/events/era-moxie-awards/2012-moxie-winners">2012 Winners</a><br><a href="http://www.retailing.org/2011-moxie-award-winners" target="_blank">2011 Winners</a></p><p>&nbsp;</p>', '', 'full_html'),
('node', 'speaker', 0, 34, 34, 'und', 0, '<p>Dave Martin is the Vice President of Marketing &amp; Content at the Electronic Retailing Association (ERA). Dave has worked for ERA since early 2009. Before that Dave worked in global telecommunications marketing, product management, and product development both in the United States and Europe. Dave has a BA from SUNY Buffalo, a MIA from Columbia University, and a MA from the Katholieke Universiteit Leuven in Leuven, Belgium. Dave is fluent in Spanish and enjoys photography, acoustic guitar, and coaching little league baseball in his spare time.</p>', '', 'full_html'),
('node', 'page', 0, 41, 41, 'und', 0, '<p>The Electronic Retailing Association ("Company", “we” or “us”) is committed to protecting the privacy of our customer''s personal information. This statement applies with respect to the information that we collect from the Company website, located at www.retailing.org (the "Website"). Amendments to this statement will be posted at this URL and will be effective when posted. Your continued use of this site following the posting of any amendment, modification or change shall constitute your acceptance thereof.</p><h4>Information Collected</h4><p>We collect two types of information: personally identifiable information (PII) and non-personally identifiable information (Non-PII), which is also referred to as aggregate and anonymous data.</p><h4>PII.</h4><p>We do not collect any personally identifiable information about you unless you voluntarily submit such information to us, by, for example, filling out a survey or registration form. The types of information that may be requested include your name, address, e-mail address, and telephone number.</p><h4>Non-PII.</h4><p>We collect non-personally identifiable information about you in a number of ways, including tracking your activities through your IP address, computer settings or most-recently visited URL.</p><ul><li>Use of IP Addresses. We use your IP Address to help diagnose problems with our server, and to administer our Website.</li><li>Use of Cookies. When you view our Website, we might store some information on your computer. This information will be in the form of a "cookie" or similar file. Cookies are small pieces of information stored on your hard drive, not on our site. Cookies do not spy on you or otherwise invade your privacy, and they cannot invade your hard drive and steal information. Rather, they help you navigate a Website as easily as possible. We use cookies to deliver content specific to your interests and to prevent you from reentering all your registration data at each connection.</li></ul><h4>Use of Information</h4><p>PII.&nbsp;<span style="line-height: 1.538em;">In general, we will only use the information you provide to us for the purpose for which such information was provided. We may also use this information to deliver to you information about our company and promotional material from some of our partners, or to conduct trend analysis, pattern detection, and site administration. Your information may also be used to contact you when necessary. Users may opt-out of receiving future mailings from Company by following the instructions set forth in the opt-out section below. </span></p><p><span style="line-height: 1.538em;">PII. Non-personal demographic and profile data is used to tailor your experience at our site, showing you content we think you might be interested in. </span></p><h4><span style="line-height: 1.538em;">How we share your information </span></h4><p><span style="line-height: 1.538em;">Except as provided below, we do not share your PII with third parties without your permission. </span></p><ul><li><span style="line-height: 1.538em;">We may share PII about you as a customer, former customer or user of the Website to with other companies that may want to contact you with offers consistent with your stated preferences. Users may opt-out of receiving future mailings from other entities by following the instructions set forth in the opt-out section below.</span></li><li><span style="line-height: 1.538em;">We may disclose PII you provide via the Website in connection with the sale, assignment, or other transfer of the business or a portion of the business of the Website, including a corporate merger, consolidation, restructuring, sale of assets or other corporate change of our company.</span></li><li><span style="line-height: 1.538em;">We may disclose PII when required by law wherein we have a good-faith belief that such action is necessary to comply with a current judicial proceeding, a criminal investigation, a court order, or legal process served on the Website. We may also share your personal information if we believe it is necessary in order to investigate, prevent, or take action regarding illegal activities, suspected fraud, situations involving potential threats to the physical safety of any person, violations of the terms of use, or as otherwise required by law. </span></li><li><span style="line-height: 1.538em;">We also may disclose information to outside companies that help us bring you the products and services we offer or that are necessary to process the transaction your request. For example, we may work with an outside company to: (a) process credit card transactions; (b) manage a database of customer information; (c) assist us in distributing e-mails; (d) assist us with direct marketing and data collection; (e) provide us storage and analysis; (f) provide fraud prevention; and (g) other services designed to assist us in maximizing our business potential. We require that these outside companies agree to keep confidential all information we share with them and to use the information only to perform their obligations in the agreements. </span></li><li><span style="line-height: 1.538em;">In addition, we may disclose or sell your PII to third-parties with your permission. </span></li><li><span style="line-height: 1.538em;">Company may share Non-PII with business partners, sponsors and other third parties. We reserve the right to use, transfer, sell, and share aggregated, anonymous data about our users as a group for any business purpose, such as analyzing usage trends and seeking compatible advertisers and partners. </span></li></ul><h4><span style="line-height: 1.538em;">Security </span></h4><p><span style="line-height: 1.538em;">The Website has industry standard security measures in place to protect the loss, misuse and alteration of the information under our control. While there is no such thing as "perfect security" on the Internet, we will take all reasonable steps to insure the safety of your personal information. Other Websites; Links Our Website may contain links to other websites. We are not responsible for the privacy practices or the content of such websites. </span></p><h4><span style="line-height: 1.538em;">Choice; Opt Out </span></h4><p><span style="line-height: 1.538em;">You may opt-out of receiving communications from our partners, and from us, by visiting the <a href="http://www.highroadsolution.com/era_preference_center/EmailSearch.aspx" target="_blank">ERA eNewsletter Preference Center</a>. </span></p><h4><span style="line-height: 1.538em;">Miscellaneous </span></h4><p><span style="line-height: 1.538em;">The Website is operated and controlled by Company in the United States, and is intended for use only by people within the United States. We make no representations that any materials on the Website are appropriate for use outside of the United States. We also do not intend for the site to be used by children under the age of 13, nor do we seek to collect information about children under this age. If you are under the age of 13, we request that you do not provide us with any PII.</span></p>', '', 'full_html'),
('node', 'page', 0, 22, 22, 'und', 0, '<p>Below you will find instructions on how to register a group of <u><strong>FIVE</strong></u> or more. If you have any questions regarding registration please refer to the <a href="#FAQ">FAQ''s</a> below.&nbsp;<span style="line-height: 1.538em;">As a VIP service to larger companies that are attending D2C, we offer group registration if you need to register </span><strong style="line-height: 1.538em;"><u>FIVE or more employees</u></strong><span style="line-height: 1.538em;"> to the show.</span></p><p>Please fill out the <u><strong><a href="/pdfs/D2C2013_Group_WireandCheck_Reg.xlsx">group registration template</a></strong></u> and send to <a href="mailto:registration@retailing.org">registration@retailing.org</a>. We will contact you upon receipt for payment information. Please note that only <u>ONE method of payment</u> will be accepted for group registrations.</p><p><strong><span style="text-decoration: underline;">FAQ''s</span></strong><a name="FAQ"></a></p><p><strong>Q: I sent in a check for registrations, when will I receive confirmation?</strong><br><span style="line-height: 1.538em;">A: Once we receive your check we will immediately process your registrations and you will receive an email confirmation.</span></p><p><strong>Q: If I am paying by credit card and do not have a group to register, where can I register?</strong><br><span style="line-height: 1.538em;">A: Visit the </span><a href="https://s4.goeshow.com/era/d2cshow/2013/reg_form.cfm" style="line-height: 1.538em;">registration site</a><span style="line-height: 1.538em;"> and follow the steps to register.</span></p><p><strong>Q: How many methods of payment may be used for a group registration?</strong><br><span style="line-height: 1.538em;">A: Only ONE method of payment will be accepted for a group registration. If you would like to use seperate payments, you must do the registrations through the </span><a href="https://s4.goeshow.com/era/d2cshow/2013/reg_form.cfm" style="line-height: 1.538em;">registration site</a><span style="line-height: 1.538em;">.</span></p><p><strong>Q: Where should I send my registration check?</strong><br><span style="line-height: 1.538em;">A: Please send to:</span></p><p>Electronic Retailing Association<br>607 14th St. NW, Suite 530<br>Washington, DC 20005</p><p><strong>Q: I have a question about the registration process, who should I contact?</strong><br><span style="line-height: 1.538em;">A: Please contact </span><a href="mailto:registration@retailing.org" style="line-height: 1.538em;">registration@retailing.org</a><span style="line-height: 1.538em;"> and we will get back to you shortly to assist you with registration.</span></p><p>&nbsp;</p><p>&nbsp;</p>', '', 'full_html');
INSERT INTO `field_data_body` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `body_value`, `body_summary`, `body_format`) VALUES
('node', 'register', 0, 47, 47, 'und', 0, '<br><p>Below you will find instructions on how to register a group of <u><strong>FIVE</strong></u> or more. If you have any questions regarding registration please refer to the <a href="#FAQ">FAQ''s</a> below.&nbsp;<span style="line-height: 1.538em;">As a VIP service to larger companies that are attending D2C, we offer group registration if you need to register </span><strong style="line-height: 1.538em;"><u>FIVE or more employees</u></strong><span style="line-height: 1.538em;"> to the show.</span></p><p>Please fill out the <u><strong><a href="/pdfs/D2C2013_Group_WireandCheck_Reg.xlsx">group registration template</a></strong></u> and send to <a href="mailto:registration@retailing.org">registration@retailing.org</a>. We will contact you upon receipt for payment information. Please note that only <u>ONE method of payment</u> will be accepted for group registrations.</p><p><strong><span style="text-decoration: underline;">FAQ''s</span></strong><a name="FAQ"></a></p><p><strong>Q: I sent in a check for registrations, when will I receive confirmation?</strong><br><span style="line-height: 1.538em;">A: Once we receive your check we will immediately process your registrations and you will receive an email confirmation.</span></p><p><strong>Q: If I am paying by credit card and do not have a group to register, where can I register?</strong><br><span style="line-height: 1.538em;">A: Visit the </span><a href="https://s4.goeshow.com/era/d2cshow/2013/reg_form.cfm" style="line-height: 1.538em;">registration site</a><span style="line-height: 1.538em;"> and follow the steps to register.</span></p><p><strong>Q: How many methods of payment may be used for a group registration?</strong><br><span style="line-height: 1.538em;">A: Only ONE method of payment will be accepted for a group registration. If you would like to use seperate payments, you must do the registrations through the </span><a href="https://s4.goeshow.com/era/d2cshow/2013/reg_form.cfm" style="line-height: 1.538em;">registration site</a><span style="line-height: 1.538em;">.</span></p><p><strong>Q: Where should I send my registration check?</strong><br><span style="line-height: 1.538em;">A: Please send to:</span></p><p>Electronic Retailing Association<br>607 14th St. NW, Suite 530<br>Washington, DC 20005</p><p><strong>Q: I have a question about the registration process, who should I contact?</strong><br><span style="line-height: 1.538em;">A: Please contact </span><a href="mailto:registration@retailing.org" style="line-height: 1.538em;">registration@retailing.org</a><span style="line-height: 1.538em;"> and we will get back to you shortly to assist you with registration.</span></p><p>&nbsp;</p><p>&nbsp;</p>', '', 'full_html'),
('node', 'register', 0, 46, 46, 'und', 0, '<h2>Badge Types</h2><table border="1" cellpadding="1" cellspacing="1" style="width: 625px; height: 214px;"><thead><tr><th scope="col">All Access Pass</th><th scope="col">Show Floor Only Pass</th></tr></thead><tbody><tr><td><em>Enjoy open access to all D2C activities including:</em></td><td><em>Provides limited access to D2C activities.</em></td></tr><tr><td><ul><li>Online Attendee List</li><li>Opening Reception</li><li>ALL networking events</li><li>Keynote Presentation</li><li>Meet &amp; Greet Lounge</li><li>ERA Circle Bar</li><li>All Access Pass Lounge</li><li>Free Networking Lunches on the Show Floor</li><li>Networking Breakfasts on Wed. &amp;&nbsp;&nbsp;Thurs.</li><li>Discounted show bag inserts (while supplies last)</li></ul></td><td><ul><li>Meet &amp; Greet Lounge</li><li>Keynote Presentation</li><li>ERA Circle Bar</li><li>Show Floor (including the D2C Learning Lounge)</li><li>Free Networking Lunches on the Show Floor</li></ul><p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p></td></tr></tbody></table><h2>Exhibitor/Sponsor Registration Rates</h2><table border="1" cellpadding="1" cellspacing="1" style="width: 625px;"><thead><tr><th scope="col" style="text-align: left;">Badge Type</th><th scope="col">Thru June 30</th><th scope="col">July 1 - Sept. 20</th><th scope="col">OnSite</th></tr></thead><tbody><tr><td><strong>All Access Pass</strong><br>(<span style="font-size: 0.923em; line-height: 1.538em;">Two free All Access Passes for each 100 sq. ft. of exhibit space)</span></td><td>FREE</td><td>FREE</td><td>FREE</td></tr><tr><td><p><strong>Additional All Access Pass</strong> for Exhibitors/Sponsors from the same company:</p></td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr><tr><td><p style="margin-left: 40px;">ERA Members</p></td><td>$599</td><td>$799</td><td>$999</td></tr><tr><td><p style="margin-left: 40px;">Non-Members</p></td><td>$699</td><td>$999</td><td>$1,199</td></tr><tr><td><strong>Show Floor Only Pass</strong> (Four free Show Floor Only Passes for each 100 sq. ft. of exhibit space)</td><td>FREE</td><td>FREE</td><td>FREE</td></tr><tr><td><strong>Additional Show Floor Only Pass</strong> for&nbsp;Exhibitors/Sponsors from same company:</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr><tr><td><p style="margin-left: 40px;">ERA Members</p></td><td>FREE</td><td>$149</td><td>$249</td></tr><tr><td><p style="margin-left: 40px;">Non-Members</p></td><td>$99</td><td>$199</td><td>$299</td></tr></tbody></table><h2>Moxie Awards Gala Tickets</h2><table border="1" cellpadding="1" cellspacing="1" style="width: 625px;"><thead><tr><th scope="col">&nbsp;</th><th scope="col">THRU JUNE 30</th><th scope="col">JULY 1 - SEPT. 20</th><th scope="col">ONSITE</th></tr></thead><tbody><tr><td>ERA Members</td><td>$179</td><td>$199</td><td>$249</td></tr><tr><td>Non-Members</td><td>$299</td><td>$349</td><td>$399</td></tr><tr><td>Reserved Table for Twelve</td><td>$2,149</td><td>$2,289</td><td>$2,789</td></tr></tbody></table><p>&nbsp;</p><p><strong>Already registered for D2C?</strong> Please purchase your <a href="https://s4.goeshow.com/era/d2cshow/2013/asc_welcome.cfm">Moxie tickets</a> here. Use the login info included in your confirmation email. Click on the first bullet “Moxie Awards Gala Tickets” and proceed to purchase your Moxie table or individual tickets.</p><p class="mainarticle"><a href="/content/registration-policies"><strong><span style="font-size: large;">Registration Policies</span></strong></a><br>&nbsp;</p><p class="mainarticle">&nbsp;</p>', '', 'full_html'),
('node', 'register', 0, 44, 44, 'und', 0, '<h2>Badge Types</h2><table border="1" cellpadding="1" cellspacing="1"><thead><tr><th scope="col">All Access Pass</th><th scope="col">Show Floor Only Pass</th></tr></thead><tbody><tr><td><em>Enjoy open access to all D2C activities including:</em></td><td><em>Provides limited access to D2C activities.</em></td></tr><tr><td><ul><li>Online Attendee List</li><li>Opening Reception</li><li>ALL networking events</li><li>Keynote Presentation</li><li>Meet &amp; Greet Lounge</li><li>ERA Circle Bar</li><li>All Access Pass Lounge</li><li>Free Networking Lunches on the Show Floor</li><li>Networking Breakfasts on Wed. &amp;&nbsp;&nbsp;Thurs.</li><li>Discounted show bag inserts (while supplies last)</li></ul></td><td><ul><li>Meet &amp; Greet Lounge</li><li>Keynote Presentation</li><li>ERA Circle Bar</li><li>Show Floor (including the D2C Learning Lounge)</li><li>Free Networking Lunches on the Show Floor</li></ul><p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p></td></tr></tbody></table><br><h2>Individual Registration Rates</h2><table border="1"><tbody><tr><th>Badge Type</th><th>Thru June 30</th><th>July 1 - Sept. 20</th><th>Onsite</th></tr><tr class="odd"><td>All Access Pass - ERA Members</td><td>$850</td><td>$1,129</td><td>$1,329</td></tr><tr class="even"><td>All Access Pass - Non-Members</td><td>$1,399</td><td>$1,599</td><td>$1,699</td></tr><tr class="odd"><td>Additional All Access Pass - ERA Members</td><td>$650</td><td>$929</td><td>$1,129</td></tr><tr class="even"><td>Show Floor Only Pass - ERA Members</td><td>FREE</td><td>$149</td><td>$249</td></tr><tr class="odd"><td>Show Floor Only Pass - ERA Members</td><td>$99</td><td>$199</td><td>$299</td></tr></tbody></table><br><h2>Moxie Awards Gala Tickets</h2><table border="1"><tbody><tr><th>&nbsp;</th><th>Thru June 30</th><th>July 1 - Sept. 20</th><th>Onsite</th></tr><tr class="odd"><td>ERA Members</td><td>$179</td><td>$199</td><td>$249</td></tr><tr class="even"><td>Non-Members</td><td>$299</td><td>$349</td><td>$399</td></tr><tr class="odd"><td>Reserved Table for Twelve</td><td>$2,149</td><td>$2,289</td><td>$2,789</td></tr></tbody></table><p><br><strong>Already registered for D2C?</strong> Please <a href="https://s4.goeshow.com/era/d2cshow/2013/asc_login.cfm" target="_blank">purchase your Moxie tickets</a> here. Use the login information included in your registration confirmation email. Click on the first bullet “Moxie Awards Gala Tickets” and proceed to purchase your Moxie table or individual tickets.</p><p class="mainarticle"><a href="/content/registration-policies"><strong><span style="font-size: large;">Registration Policies</span></strong></a><br>&nbsp;</p><p class="mainarticle">&nbsp;</p>', '', 'full_html'),
('node', 'page', 0, 89, 89, 'und', 0, '<h2>WYNN LAS VEGAS</h2><div>Official hotel of the ERA D2C Convention</div><div>3131 Las Vegas Boulevard South</div><div>Las Vegas, NV 89109</div><div>702-770-7100&nbsp;</div><h2><a href="https://www.completereg.com/ERA/">Resort Rooms</a></h2><div>ERA has secured specially negotiated Wynn Las Vegas and Encore Las Vegas room rates for ERA D2C Convention attendees. To secure ERA preferred rates you MUST first register for the 2013 ERA D2C Convention and then visit the <a href="https://www.completereg.com/ERA/"><strong>Housing Website</strong></a>. All reservations must be made by August 29, 2013. ERA staff are NOT responsible for securing hotel rooms.</div><ul><li>Resort Rooms (Wynn Las Vegas) for single or double occupancy: $199/night</li><li>Tower King Rooms (Wynn Las Vegas) for single or double occupancy: $249/night</li><li>Resort Rooms (Encore Las Vegas) for single or double occupancy: $219/night</li></ul><p><strong><a href="https://www.completereg.com/ERA/">Housing Website</a></strong></p><p>For questions regarding hotel reservations please contact the Housing Help Desk at <strong><a href="mailto:housing@retailing.org">housing@retailing.org</a></strong> or 703-908-1029.</p><h2><a href="mailto:keppsteiner@retailing.org">Reserve Your Suite Through ERA</a></h2><div>Conduct business meetings in the luxury and privacy of your own hospitality suite. Reserve a Parlor Suite, Salon Suite or Fairway Villa at the Wynn Las Vegas at special rates through ERA by August 29, 2013. Booking your suite through ERA is the only way to receive catering AND freight delivery to suites in the Wynn. A three night minimum stay is required. To book suites please contact Karen Eppsteiner at <a href="mailto:keppsteiner@retailing.org">keppsteiner@retailing.org</a> or 703-841-8283 for availability and rate information. Choose from:</div><ul><li>Parlor Suite - One Bedroom: $950/night member, $1,150/night non-member</li><li>Parlor Suite - Two Bedroom: $1,250/night member, $1,500/night non-member</li><li>Salon Suite - One Bedroom: $1,100/night member, $1,300/night non-member</li><li>Salon Suite - Two Bedroom: $1,400/night member, $1,700/night non-member</li><li>Fairway Villa - One Bedroom: $1,300/night member, $1,500/night non-member</li><li>Fairway Villa - Two Bedroom: $2,400/night member, $2,900/night non-member</li></ul><div>** Please contact Karen Eppsteiner at <a href="mailto:keppsteiner@retailing.org">keppsteiner@retailing.org</a> or 703-841-8283 for availability and rate information on One/Two Bedroom suites.</div><div>&nbsp;</div><div>IMPORTANT NOTICE: In the past ERA has received reports of wholesalers contacting attendees and offering "great deals" on hotels for the ERA D2C Convention. While it is not illegal for a travel firm or booking agent to solicit potential customers, it can be difficult to determine the legitimacy of offers from these organizations. Those who opt for alternatives to the ERA negotiated rates may find themselves at risk. ERA reminds its attendees that we have no affiliation with any of these room brokers. The official ERA Housing Office is CompleteReg.</div><div>&nbsp;</div><h2>Important Contact Info for the Wynn</h2><ul><li>Concierge: 702-770-7070 or 888-320-7122</li><li>Restaurant Reservations: 702-248-DINE (3463) or 888-352-DINE (3463), <a href="mailto:dining@wynnlasvegas.com">dining@wynnlasvegas.com</a></li><li>The Salon: 702-770-3900</li><li>The Spa: 702-770-3900</li><li>Wynn Golf and Country Club: 888-320-7122</li><li>Business Services Center: 702-770-2370 or 800-320-7123 x. 2370, <a href="mailto:businesscenter@wynnlasvegas.com">businesscenter@wynnlasvegas.com</a></li></ul><h2>Travel</h2><div><div>Getting to Vegas is a breeze. With over 1,000 flights arriving and departing on a daily basis, Las Vegas McCarran International Airport is easily accessible from around the world.</div><div>&nbsp;</div><h3>Getting From Las Vegas McCarran International Airport to the Wynn</h3><ul><li>Distance from the Wynn: 7.5 miles and 10-15 minutes</li><li>By Taxi: Taxi cabs are available on the east side of baggage claim, outside door exits 1-4. Please know that most taxis will not accept credit card payments and there is a $1.80 charge on all fares originating at the airport. The max number of passengers allowed in any taxi is five.</li><li>By Shuttle or Limo: A large variety of shuttle bus and limousine services and are located on the west side of baggage claim, outside door exits 7-13. Shuttles that stop at the Wynn Las Vegas run $6 or $6.50 one way and $12 or $13 for round trip service. Limousine service runs from $48/hour and up. <a href="https://www.mccarran.com/" target="_blank">View specific companies and rates that service McCarran</a>.</li><li>By Rental Car: Dedicated McCarran Rent-A-Car Center shuttles depart approximately every five minutes from exits 10 or 11 to the new McCarran Rent-A-Car Center. For information about the McCarran Rent-A-Car Center, call 702-261-6001. <a href="https://www.mccarran.com/" target="_blank">View the list of rental car companies that service McCarran</a>.</li></ul></div><p>&nbsp;</p>', '', 'full_html');

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

--
-- Table structure for table `field_data_comment_body`
--

CREATE TABLE IF NOT EXISTS `field_data_comment_body` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `comment_body_value` longtext,
  `comment_body_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `comment_body_format` (`comment_body_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 1 (comment_body)';

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

--
-- Table structure for table `field_data_field_address`
--

CREATE TABLE IF NOT EXISTS `field_data_field_address` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_address_country` varchar(2) DEFAULT '' COMMENT 'Two letter ISO country code of this address.',
  `field_address_administrative_area` varchar(255) DEFAULT '' COMMENT 'The administrative area of this address. (i.e. State/Province)',
  `field_address_sub_administrative_area` varchar(255) DEFAULT '' COMMENT 'The sub administrative area of this address.',
  `field_address_locality` varchar(255) DEFAULT '' COMMENT 'The locality of this address. (i.e. City)',
  `field_address_dependent_locality` varchar(255) DEFAULT '' COMMENT 'The dependent locality of this address.',
  `field_address_postal_code` varchar(255) DEFAULT '' COMMENT 'The postal code of this address.',
  `field_address_thoroughfare` varchar(255) DEFAULT '' COMMENT 'The thoroughfare of this address. (i.e. Street address)',
  `field_address_premise` varchar(255) DEFAULT '' COMMENT 'The premise of this address. (i.e. Apartment / Suite number)',
  `field_address_sub_premise` varchar(255) DEFAULT '' COMMENT 'The sub_premise of this address.',
  `field_address_organisation_name` varchar(255) DEFAULT '' COMMENT 'Contents of a primary OrganisationName element in the xNL XML.',
  `field_address_name_line` varchar(255) DEFAULT '' COMMENT 'Contents of a primary NameLine element in the xNL XML.',
  `field_address_first_name` varchar(255) DEFAULT '' COMMENT 'Contents of the FirstName element of a primary PersonName element in the xNL XML.',
  `field_address_last_name` varchar(255) DEFAULT '' COMMENT 'Contents of the LastName element of a primary PersonName element in the xNL XML.',
  `field_address_data` longtext COMMENT 'Additional data for this address.',
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 60 (field_address)';

--
-- Dumping data for table `field_data_field_address`
--

INSERT INTO `field_data_field_address` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_address_country`, `field_address_administrative_area`, `field_address_sub_administrative_area`, `field_address_locality`, `field_address_dependent_locality`, `field_address_postal_code`, `field_address_thoroughfare`, `field_address_premise`, `field_address_sub_premise`, `field_address_organisation_name`, `field_address_name_line`, `field_address_first_name`, `field_address_last_name`, `field_address_data`) VALUES
('node', 'exhibitor', 0, 60, 60, 'und', 0, 'US', 'CA', NULL, 'Simi Valley', NULL, '93063', '4195 Valley Fair Street', 'Suite 203', NULL, '', NULL, '', '', NULL),
('node', 'exhibitor', 0, 31, 31, 'und', 0, 'US', '', NULL, '', NULL, '', '', '', NULL, '', NULL, '', '', NULL),
('node', 'exhibitor', 0, 80, 80, 'und', 0, 'US', 'CA', NULL, 'Pico Rivera', NULL, '90660', '5138 Industry Ave.', '', NULL, '', NULL, '', '', NULL),
('node', 'exhibitor', 0, 59, 59, 'und', 0, 'US', '', NULL, '', NULL, '', '', '', NULL, '', NULL, '', '', NULL),
('node', 'exhibitor', 0, 56, 56, 'und', 0, 'US', '', NULL, '', NULL, '', '', '', NULL, '', NULL, '', '', NULL),
('node', 'exhibitor', 0, 57, 57, 'und', 0, 'US', '', NULL, '', NULL, '', '', '', NULL, '', NULL, '', '', NULL),
('node', 'exhibitor', 0, 58, 58, 'und', 0, 'US', '', NULL, '', NULL, '', '', '', NULL, '', NULL, '', '', NULL);

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

--
-- Table structure for table `field_data_field_address1`
--

CREATE TABLE IF NOT EXISTS `field_data_field_address1` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_address1_value` varchar(255) DEFAULT NULL,
  `field_address1_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_address1_format` (`field_address1_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 26 (field_address1)';

--
-- Dumping data for table `field_data_field_address1`
--

INSERT INTO `field_data_field_address1` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_address1_value`, `field_address1_format`) VALUES
('node', 'sponsor', 0, 32, 32, 'und', 0, '123 Main Street', NULL);

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

--
-- Table structure for table `field_data_field_address2`
--

CREATE TABLE IF NOT EXISTS `field_data_field_address2` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_address2_value` varchar(255) DEFAULT NULL,
  `field_address2_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_address2_format` (`field_address2_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 27 (field_address2)';

--
-- Dumping data for table `field_data_field_address2`
--

INSERT INTO `field_data_field_address2` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_address2_value`, `field_address2_format`) VALUES
('node', 'sponsor', 0, 32, 32, 'und', 0, 'Suite 444', NULL);

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

--
-- Table structure for table `field_data_field_booth`
--

CREATE TABLE IF NOT EXISTS `field_data_field_booth` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_booth_value` varchar(255) DEFAULT NULL,
  `field_booth_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_booth_format` (`field_booth_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 25 (field_booth)';

--
-- Dumping data for table `field_data_field_booth`
--

INSERT INTO `field_data_field_booth` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_booth_value`, `field_booth_format`) VALUES
('node', 'exhibitor', 0, 31, 31, 'und', 0, '302', NULL),
('node', 'exhibitor', 0, 58, 58, 'und', 0, '308', NULL),
('node', 'exhibitor', 0, 57, 57, 'und', 0, '523', NULL),
('node', 'exhibitor', 0, 56, 56, 'und', 0, '1121', NULL),
('node', 'exhibitor', 0, 59, 59, 'und', 0, '519', NULL),
('node', 'exhibitor', 0, 60, 60, 'und', 0, '402', NULL),
('node', 'exhibitor', 0, 80, 80, 'und', 0, '317', NULL);

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

--
-- Table structure for table `field_data_field_booth_contact`
--

CREATE TABLE IF NOT EXISTS `field_data_field_booth_contact` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_booth_contact_value` varchar(255) DEFAULT NULL,
  `field_booth_contact_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_booth_contact_format` (`field_booth_contact_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 36 (field_booth_contact)';

--
-- Dumping data for table `field_data_field_booth_contact`
--

INSERT INTO `field_data_field_booth_contact` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_booth_contact_value`, `field_booth_contact_format`) VALUES
('node', 'exhibitor', 0, 31, 31, 'und', 0, 'Dave Martin', NULL),
('node', 'exhibitor', 0, 58, 58, 'und', 0, 'Mark Chandley', NULL),
('node', 'exhibitor', 0, 57, 57, 'und', 0, 'Melissa Hiller', NULL),
('node', 'exhibitor', 0, 56, 56, 'und', 0, 'Gary Latz', NULL),
('node', 'exhibitor', 0, 59, 59, 'und', 0, 'Ross Krisel', NULL),
('node', 'exhibitor', 0, 60, 60, 'und', 0, 'Bruce Stone', NULL),
('node', 'exhibitor', 0, 80, 80, 'und', 0, 'Pamela Velarde', NULL);

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

--
-- Table structure for table `field_data_field_booth_type`
--

CREATE TABLE IF NOT EXISTS `field_data_field_booth_type` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_booth_type_value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_booth_type_value` (`field_booth_type_value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 41 (field_booth_type)';

--
-- Dumping data for table `field_data_field_booth_type`
--

INSERT INTO `field_data_field_booth_type` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_booth_type_value`) VALUES
('node', 'exhibitor', 0, 80, 80, 'und', 0, 'Booth'),
('node', 'exhibitor', 0, 31, 31, 'und', 0, 'Booth'),
('node', 'exhibitor', 0, 59, 59, 'und', 0, 'Booth'),
('node', 'exhibitor', 0, 57, 57, 'und', 0, 'Booth'),
('node', 'exhibitor', 0, 60, 60, 'und', 0, 'Booth'),
('node', 'exhibitor', 0, 58, 58, 'und', 0, 'Booth'),
('node', 'exhibitor', 0, 56, 56, 'und', 0, 'Booth');

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

--
-- Table structure for table `field_data_field_business_categories`
--

CREATE TABLE IF NOT EXISTS `field_data_field_business_categories` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_business_categories_value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_business_categories_value` (`field_business_categories_value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 48 (field_business_categories)';

--
-- Dumping data for table `field_data_field_business_categories`
--

INSERT INTO `field_data_field_business_categories` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_business_categories_value`) VALUES
('node', 'exhibitor', 0, 31, 31, 'und', 0, 'Agencies'),
('node', 'exhibitor', 0, 31, 31, 'und', 1, 'Media Services');

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

--
-- Table structure for table `field_data_field_city`
--

CREATE TABLE IF NOT EXISTS `field_data_field_city` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_city_value` varchar(255) DEFAULT NULL,
  `field_city_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_city_format` (`field_city_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 28 (field_city)';

--
-- Dumping data for table `field_data_field_city`
--

INSERT INTO `field_data_field_city` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_city_value`, `field_city_format`) VALUES
('node', 'sponsor', 0, 32, 32, 'und', 0, 'Nowhere', NULL);

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

--
-- Table structure for table `field_data_field_corporate_suite`
--

CREATE TABLE IF NOT EXISTS `field_data_field_corporate_suite` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_corporate_suite_value` varchar(255) DEFAULT NULL,
  `field_corporate_suite_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_corporate_suite_format` (`field_corporate_suite_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 50 (field_corporate_suite)';

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

--
-- Table structure for table `field_data_field_country`
--

CREATE TABLE IF NOT EXISTS `field_data_field_country` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_country_value` varchar(255) DEFAULT NULL,
  `field_country_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_country_format` (`field_country_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 31 (field_country)';

--
-- Dumping data for table `field_data_field_country`
--

INSERT INTO `field_data_field_country` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_country_value`, `field_country_format`) VALUES
('node', 'sponsor', 0, 32, 32, 'und', 0, 'United States', NULL);

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

--
-- Table structure for table `field_data_field_description`
--

CREATE TABLE IF NOT EXISTS `field_data_field_description` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_description_value` longtext,
  `field_description_summary` longtext,
  `field_description_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_description_format` (`field_description_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 37 (field_description)';

--
-- Dumping data for table `field_data_field_description`
--

INSERT INTO `field_data_field_description` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_description_value`, `field_description_summary`, `field_description_format`) VALUES
('node', 'exhibitor', 0, 31, 31, 'und', 0, '<p>Representing a more-than $300-billion market, the Electronic Retailing Association (ERA) is the only trade association that represents the global leaders of the direct-to-consumer marketplace—companies which use the power of direct response to sell goods and services on television, online and on radio. ERA’s members practice a sophisticated and accountable marketing methodology, leveraging video and audio to compel a direct and measurable response.</p>', '', 'full_html'),
('node', 'exhibitor', 0, 80, 80, 'und', 0, '<p>Bay Cities</p>', '', 'full_html'),
('node', 'exhibitor', 0, 59, 59, 'und', 0, '<p>Test, test, test</p>', '', 'full_html');

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

--
-- Table structure for table `field_data_field_email`
--

CREATE TABLE IF NOT EXISTS `field_data_field_email` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_email_value` varchar(255) DEFAULT NULL,
  `field_email_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_email_format` (`field_email_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 33 (field_email)';

--
-- Dumping data for table `field_data_field_email`
--

INSERT INTO `field_data_field_email` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_email_value`, `field_email_format`) VALUES
('node', 'exhibitor', 0, 31, 31, 'und', 0, 'dmartin@retailing.org', NULL),
('node', 'exhibitor', 0, 57, 57, 'und', 0, 'dave.cook@accessdevelopment.com', NULL),
('node', 'exhibitor', 0, 56, 56, 'und', 0, 'gary@a2bf.com', NULL),
('node', 'exhibitor', 0, 58, 58, 'und', 0, 'markc@adeptivsolutions.com', NULL),
('node', 'exhibitor', 0, 59, 59, 'und', 0, 'rkrisel@advontone.com', NULL),
('node', 'exhibitor', 0, 60, 60, 'und', 0, 'bstone@apcrc.com', NULL),
('node', 'exhibitor', 0, 80, 80, 'und', 0, 'pamelav@bay-cities.com', NULL);

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

--
-- Table structure for table `field_data_field_era_member`
--

CREATE TABLE IF NOT EXISTS `field_data_field_era_member` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_era_member_value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_era_member_value` (`field_era_member_value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 40 (field_era_member)';

--
-- Dumping data for table `field_data_field_era_member`
--

INSERT INTO `field_data_field_era_member` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_era_member_value`) VALUES
('node', 'exhibitor', 0, 31, 31, 'und', 0, 'Yes'),
('node', 'exhibitor', 0, 58, 58, 'und', 0, 'Yes'),
('node', 'exhibitor', 0, 57, 57, 'und', 0, 'No'),
('node', 'exhibitor', 0, 56, 56, 'und', 0, 'Yes'),
('node', 'exhibitor', 0, 59, 59, 'und', 0, 'Yes'),
('node', 'exhibitor', 0, 60, 60, 'und', 0, 'Yes'),
('node', 'exhibitor', 0, 80, 80, 'und', 0, 'Yes');

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

--
-- Table structure for table `field_data_field_image`
--

CREATE TABLE IF NOT EXISTS `field_data_field_image` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_image_fid` int(10) unsigned DEFAULT NULL COMMENT 'The file_managed.fid being referenced in this field.',
  `field_image_alt` varchar(512) DEFAULT NULL COMMENT 'Alternative image text, for the image’s ’alt’ attribute.',
  `field_image_title` varchar(1024) DEFAULT NULL COMMENT 'Image title text, for the image’s ’title’ attribute.',
  `field_image_width` int(10) unsigned DEFAULT NULL COMMENT 'The width of the image in pixels.',
  `field_image_height` int(10) unsigned DEFAULT NULL COMMENT 'The height of the image in pixels.',
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_image_fid` (`field_image_fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 4 (field_image)';

--
-- Dumping data for table `field_data_field_image`
--

INSERT INTO `field_data_field_image` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_image_fid`, `field_image_alt`, `field_image_title`, `field_image_width`, `field_image_height`) VALUES
('node', 'mt_service', 0, 6, 6, 'und', 5, 142, '', '', 950, 633),
('node', 'mt_product', 0, 1, 1, 'und', 2, 88, '', '', 950, 340),
('node', 'mt_product', 0, 1, 1, 'und', 1, 76, '', '', 2400, 1600),
('node', 'mt_service', 0, 6, 6, 'und', 7, 144, '', '', 950, 1425),
('node', 'mt_service', 0, 6, 6, 'und', 6, 143, '', '', 950, 633),
('node', 'mt_event', 0, 83, 83, 'und', 1, 169, '', '', 600, 737),
('node', 'mt_service', 0, 6, 6, 'und', 4, 141, '', '', 950, 633),
('node', 'mt_product', 0, 1, 1, 'und', 0, 75, '', '', 2400, 1600),
('node', 'blog', 0, 12, 12, 'und', 0, 36, 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.', 600, 350),
('node', 'mt_event', 0, 83, 83, 'und', 0, 168, '', '', 600, 664),
('node', 'mt_product', 0, 2, 2, 'und', 0, 110, '', '', 1632, 1224),
('node', 'mt_service', 0, 6, 6, 'und', 3, 140, '', '', 950, 633),
('node', 'mt_service', 0, 6, 6, 'und', 2, 139, '', '', 950, 633),
('node', 'mt_service', 0, 6, 6, 'und', 1, 138, '', '', 950, 633),
('node', 'mt_service', 0, 6, 6, 'und', 0, 137, '', '', 950, 633),
('node', 'mt_service', 0, 7, 7, 'und', 0, 57, 'Unlimited Sponsorship Opportunities', '', 918, 612),
('node', 'register', 0, 47, 47, 'und', 0, 114, '', '', 500, 267),
('node', 'mt_testimonial', 0, 49, 49, 'und', 0, 116, '', '', 500, 462),
('node', 'mt_product', 0, 3, 3, 'und', 3, 119, '', '', 600, 900),
('node', 'mt_product', 0, 3, 3, 'und', 4, 120, '', '', 600, 664),
('node', 'mt_product', 0, 3, 3, 'und', 5, 121, '', '', 700, 416),
('node', 'exhibitor', 0, 31, 31, 'und', 0, 89, '', '', 150, 83),
('node', 'sponsor', 0, 32, 32, 'und', 0, 90, '', '', 150, 39),
('node', 'mt_product', 0, 3, 3, 'und', 2, 118, '', '', 600, 737),
('node', 'mt_product', 0, 3, 3, 'und', 1, 117, '', '', 600, 429),
('node', 'mt_product', 0, 3, 3, 'und', 0, 59, '', '', 3507, 2338),
('node', 'speaker', 0, 34, 34, 'und', 0, 97, '', '', 75, 102),
('node', 'register', 0, 44, 44, 'und', 0, 134, '', '', 500, 333),
('node', 'page', 0, 38, 38, 'und', 0, 106, '', '', 400, 212);

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

--
-- Table structure for table `field_data_field_meeting_room`
--

CREATE TABLE IF NOT EXISTS `field_data_field_meeting_room` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_meeting_room_value` varchar(255) DEFAULT NULL,
  `field_meeting_room_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_meeting_room_format` (`field_meeting_room_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 51 (field_meeting_room)';

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

--
-- Table structure for table `field_data_field_mt_gallery_description`
--

CREATE TABLE IF NOT EXISTS `field_data_field_mt_gallery_description` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_mt_gallery_description_value` longtext,
  `field_mt_gallery_description_summary` longtext,
  `field_mt_gallery_description_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_mt_gallery_description_format` (`field_mt_gallery_description_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 18 (field_mt_gallery_description)';

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

--
-- Table structure for table `field_data_field_mt_gallery_image`
--

CREATE TABLE IF NOT EXISTS `field_data_field_mt_gallery_image` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_mt_gallery_image_fid` int(10) unsigned DEFAULT NULL COMMENT 'The file_managed.fid being referenced in this field.',
  `field_mt_gallery_image_alt` varchar(512) DEFAULT NULL COMMENT 'Alternative image text, for the image’s ’alt’ attribute.',
  `field_mt_gallery_image_title` varchar(1024) DEFAULT NULL COMMENT 'Image title text, for the image’s ’title’ attribute.',
  `field_mt_gallery_image_width` int(10) unsigned DEFAULT NULL COMMENT 'The width of the image in pixels.',
  `field_mt_gallery_image_height` int(10) unsigned DEFAULT NULL COMMENT 'The height of the image in pixels.',
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_mt_gallery_image_fid` (`field_mt_gallery_image_fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 17 (field_mt_gallery_image)';

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

--
-- Table structure for table `field_data_field_mt_slideshow_image`
--

CREATE TABLE IF NOT EXISTS `field_data_field_mt_slideshow_image` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_mt_slideshow_image_fid` int(10) unsigned DEFAULT NULL COMMENT 'The file_managed.fid being referenced in this field.',
  `field_mt_slideshow_image_alt` varchar(512) DEFAULT NULL COMMENT 'Alternative image text, for the image’s ’alt’ attribute.',
  `field_mt_slideshow_image_title` varchar(1024) DEFAULT NULL COMMENT 'Image title text, for the image’s ’title’ attribute.',
  `field_mt_slideshow_image_width` int(10) unsigned DEFAULT NULL COMMENT 'The width of the image in pixels.',
  `field_mt_slideshow_image_height` int(10) unsigned DEFAULT NULL COMMENT 'The height of the image in pixels.',
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_mt_slideshow_image_fid` (`field_mt_slideshow_image_fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 20 (field_mt_slideshow_image)';

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

--
-- Table structure for table `field_data_field_mt_slideshow_text`
--

CREATE TABLE IF NOT EXISTS `field_data_field_mt_slideshow_text` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_mt_slideshow_text_value` longtext,
  `field_mt_slideshow_text_summary` longtext,
  `field_mt_slideshow_text_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_mt_slideshow_text_format` (`field_mt_slideshow_text_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 21 (field_mt_slideshow_text)';

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

--
-- Table structure for table `field_data_field_name`
--

CREATE TABLE IF NOT EXISTS `field_data_field_name` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_name_value` varchar(30) DEFAULT NULL,
  `field_name_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_name_format` (`field_name_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 22 (field_name)';

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

--
-- Table structure for table `field_data_field_organization`
--

CREATE TABLE IF NOT EXISTS `field_data_field_organization` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_organization_value` varchar(255) DEFAULT NULL,
  `field_organization_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_organization_format` (`field_organization_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 46 (field_organization)';

--
-- Dumping data for table `field_data_field_organization`
--

INSERT INTO `field_data_field_organization` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_organization_value`, `field_organization_format`) VALUES
('node', 'speaker', 0, 34, 34, 'und', 0, 'ERA', NULL);

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

--
-- Table structure for table `field_data_field_org_type`
--

CREATE TABLE IF NOT EXISTS `field_data_field_org_type` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_org_type_value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_org_type_value` (`field_org_type_value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 39 (field_org_type)';

--
-- Dumping data for table `field_data_field_org_type`
--

INSERT INTO `field_data_field_org_type` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_org_type_value`) VALUES
('node', 'exhibitor', 0, 31, 31, 'und', 0, 'Marketer'),
('node', 'exhibitor', 0, 58, 58, 'und', 0, 'Supplier'),
('node', 'exhibitor', 0, 57, 57, 'und', 0, 'Supplier'),
('node', 'exhibitor', 0, 56, 56, 'und', 0, 'Supplier'),
('node', 'exhibitor', 0, 59, 59, 'und', 0, 'Supplier'),
('node', 'exhibitor', 0, 60, 60, 'und', 0, 'Supplier'),
('node', 'exhibitor', 0, 80, 80, 'und', 0, 'Supplier');

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

--
-- Table structure for table `field_data_field_phone`
--

CREATE TABLE IF NOT EXISTS `field_data_field_phone` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_phone_value` varchar(255) DEFAULT NULL,
  `field_phone_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_phone_format` (`field_phone_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 32 (field_phone)';

--
-- Dumping data for table `field_data_field_phone`
--

INSERT INTO `field_data_field_phone` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_phone_value`, `field_phone_format`) VALUES
('node', 'exhibitor', 0, 31, 31, 'und', 0, '703-908-1031', NULL),
('node', 'exhibitor', 0, 57, 57, 'und', 0, '800 840 0032', NULL),
('node', 'exhibitor', 0, 56, 56, 'und', 0, '866 843 3827 211', NULL),
('node', 'exhibitor', 0, 58, 58, 'und', 0, '855 233 7801', NULL),
('node', 'exhibitor', 0, 59, 59, 'und', 0, '954 671 6505', NULL),
('node', 'exhibitor', 0, 60, 60, 'und', 0, '805 526-2525', NULL),
('node', 'exhibitor', 0, 80, 80, 'und', 0, '562 948 3751', NULL);

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

--
-- Table structure for table `field_data_field_promoted_on_slideshow`
--

CREATE TABLE IF NOT EXISTS `field_data_field_promoted_on_slideshow` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_promoted_on_slideshow_value` int(11) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_promoted_on_slideshow_value` (`field_promoted_on_slideshow_value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 19 (field_promoted_on_slideshow)';

--
-- Dumping data for table `field_data_field_promoted_on_slideshow`
--

INSERT INTO `field_data_field_promoted_on_slideshow` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_promoted_on_slideshow_value`) VALUES
('node', 'mt_event', 0, 83, 83, 'und', 0, 0);

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

--
-- Table structure for table `field_data_field_show_guide_description`
--

CREATE TABLE IF NOT EXISTS `field_data_field_show_guide_description` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_show_guide_description_value` longtext,
  `field_show_guide_description_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_show_guide_description_format` (`field_show_guide_description_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 49 (field_show_guide_description)';

--
-- Dumping data for table `field_data_field_show_guide_description`
--

INSERT INTO `field_data_field_show_guide_description` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_show_guide_description_value`, `field_show_guide_description_format`) VALUES
('node', 'exhibitor', 0, 31, 31, 'und', 0, '<p>Representing a more-than $300-billion market, the Electronic Retailing Association (ERA) is the only trade association that represents the global leaders of the direct-to-consumer marketplace—companies which use the power of direct response to sell goods and services on television, online and on radio. ERA’s members practice a sophisticated and accountable marketing methodology, leveraging video and audio to compel a direct and measurable response.</p>', 'full_html');

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

--
-- Table structure for table `field_data_field_slideshow`
--

CREATE TABLE IF NOT EXISTS `field_data_field_slideshow` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_slideshow_value` int(11) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_slideshow_value` (`field_slideshow_value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 5 (field_slideshow)';

--
-- Dumping data for table `field_data_field_slideshow`
--

INSERT INTO `field_data_field_slideshow` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_slideshow_value`) VALUES
('node', 'mt_product', 0, 1, 1, 'und', 0, 0),
('node', 'mt_product', 0, 2, 2, 'und', 0, 0),
('node', 'mt_product', 0, 3, 3, 'und', 0, 1),
('node', 'mt_service', 0, 6, 6, 'und', 0, 0),
('node', 'mt_service', 0, 7, 7, 'und', 0, 0),
('node', 'blog', 0, 12, 12, 'und', 0, 0),
('node', 'register', 0, 44, 44, 'und', 0, 0),
('node', 'register', 0, 46, 46, 'und', 0, 0),
('node', 'register', 0, 47, 47, 'und', 0, 0),
('node', 'slideshow_new', 0, 85, 85, 'und', 0, 1),
('node', 'slideshow_new', 0, 87, 87, 'und', 0, 1),
('node', 'slideshow_new', 0, 92, 92, 'und', 0, 1);

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

--
-- Table structure for table `field_data_field_slideshow_entry_path`
--

CREATE TABLE IF NOT EXISTS `field_data_field_slideshow_entry_path` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_slideshow_entry_path_value` varchar(255) DEFAULT NULL,
  `field_slideshow_entry_path_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_slideshow_entry_path_format` (`field_slideshow_entry_path_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 8 (field_slideshow_entry_path)';

--
-- Dumping data for table `field_data_field_slideshow_entry_path`
--

INSERT INTO `field_data_field_slideshow_entry_path` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_slideshow_entry_path_value`, `field_slideshow_entry_path_format`) VALUES
('node', 'slideshow_new', 0, 85, 85, 'und', 0, 'http://www.d2cshow.org/register', NULL),
('node', 'slideshow_new', 0, 87, 87, 'und', 0, '/register', NULL);

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

--
-- Table structure for table `field_data_field_speaker_type`
--

CREATE TABLE IF NOT EXISTS `field_data_field_speaker_type` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_speaker_type_value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_speaker_type_value` (`field_speaker_type_value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 47 (field_speaker_type)';

--
-- Dumping data for table `field_data_field_speaker_type`
--

INSERT INTO `field_data_field_speaker_type` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_speaker_type_value`) VALUES
('node', 'speaker', 0, 34, 34, 'und', 0, 'Speaker');

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

--
-- Table structure for table `field_data_field_state`
--

CREATE TABLE IF NOT EXISTS `field_data_field_state` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_state_value` varchar(255) DEFAULT NULL,
  `field_state_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_state_format` (`field_state_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 29 (field_state)';

--
-- Dumping data for table `field_data_field_state`
--

INSERT INTO `field_data_field_state` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_state_value`, `field_state_format`) VALUES
('node', 'sponsor', 0, 32, 32, 'und', 0, 'NY', NULL);

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

--
-- Table structure for table `field_data_field_subtitle`
--

CREATE TABLE IF NOT EXISTS `field_data_field_subtitle` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_subtitle_value` longtext,
  `field_subtitle_summary` longtext,
  `field_subtitle_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_subtitle_format` (`field_subtitle_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 9 (field_subtitle)';

--
-- Dumping data for table `field_data_field_subtitle`
--

INSERT INTO `field_data_field_subtitle` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_subtitle_value`, `field_subtitle_summary`, `field_subtitle_format`) VALUES
('node', 'mt_testimonial', 0, 10, 10, 'und', 0, 'Moulton Logistics', '', 'filtered_html'),
('node', 'mt_testimonial', 0, 9, 9, 'und', 0, '<p>USA Fulfillment, Inc.</p>', '', 'full_html'),
('node', 'mt_testimonial', 0, 49, 49, 'und', 0, '<p>UPS Marketing, Retail &amp; Consumer Goods</p>', '', 'full_html');

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

--
-- Table structure for table `field_data_field_tags`
--

CREATE TABLE IF NOT EXISTS `field_data_field_tags` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_tags_tid` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_tags_tid` (`field_tags_tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 3 (field_tags)';

--
-- Dumping data for table `field_data_field_tags`
--

INSERT INTO `field_data_field_tags` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_tags_tid`) VALUES
('node', 'register', 0, 44, 44, 'und', 1, 10),
('node', 'mt_product', 0, 1, 1, 'und', 1, 11),
('node', 'mt_product', 0, 3, 3, 'und', 1, 12),
('node', 'article', 0, 27, 27, 'und', 0, 10),
('node', 'mt_service', 0, 7, 7, 'und', 1, 9),
('node', 'mt_service', 0, 7, 7, 'und', 0, 6),
('node', 'register', 0, 44, 44, 'und', 0, 19),
('node', 'article', 0, 29, 29, 'und', 0, 14),
('node', 'blog', 0, 12, 12, 'und', 0, 4),
('node', 'mt_product', 0, 3, 3, 'und', 0, 11),
('node', 'mt_product', 0, 1, 1, 'und', 0, 5),
('node', 'mt_product', 0, 2, 2, 'und', 0, 5),
('node', 'article', 0, 29, 29, 'und', 1, 10),
('node', 'mt_service', 0, 6, 6, 'und', 0, 6),
('node', 'sponsor', 0, 32, 32, 'und', 0, 9),
('node', 'exhibitor', 0, 31, 31, 'und', 0, 21),
('node', 'mt_service', 0, 6, 6, 'und', 1, 7),
('node', 'register', 0, 47, 47, 'und', 0, 10),
('node', 'register', 0, 47, 47, 'und', 1, 7),
('node', 'exhibitor', 0, 59, 59, 'und', 0, 21),
('node', 'exhibitor', 0, 56, 56, 'und', 0, 21),
('node', 'exhibitor', 0, 57, 57, 'und', 0, 21),
('node', 'exhibitor', 0, 58, 58, 'und', 0, 21),
('node', 'exhibitor', 0, 60, 60, 'und', 0, 21),
('node', 'exhibitor', 0, 80, 80, 'und', 0, 21);

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

--
-- Table structure for table `field_data_field_teaser`
--

CREATE TABLE IF NOT EXISTS `field_data_field_teaser` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_teaser_value` longtext,
  `field_teaser_summary` longtext,
  `field_teaser_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_teaser_format` (`field_teaser_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 7 (field_teaser)';

--
-- Dumping data for table `field_data_field_teaser`
--

INSERT INTO `field_data_field_teaser` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_teaser_value`, `field_teaser_summary`, `field_teaser_format`) VALUES
('node', 'mt_product', 0, 1, 1, 'und', 0, '<p>More than 20 Networking Events</p>', '', 'full_html'),
('node', 'mt_product', 0, 2, 2, 'und', 0, 'Slogan for your second product.', '', 'filtered_html'),
('node', 'mt_service', 0, 6, 6, 'und', 0, 'Qualified Prospects and Impressive ROI', '', 'filtered_html'),
('node', 'mt_product', 0, 3, 3, 'und', 0, 'Glitz. Glamour. Glory.', '', 'filtered_html');

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

--
-- Table structure for table `field_data_field_teaser_body`
--

CREATE TABLE IF NOT EXISTS `field_data_field_teaser_body` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_teaser_body_value` longtext,
  `field_teaser_body_summary` longtext,
  `field_teaser_body_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_teaser_body_format` (`field_teaser_body_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 54 (field_teaser_body)';

--
-- Dumping data for table `field_data_field_teaser_body`
--

INSERT INTO `field_data_field_teaser_body` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_teaser_body_value`, `field_teaser_body_summary`, `field_teaser_body_format`) VALUES
('node', 'mt_service', 0, 6, 6, 'und', 0, '<h2>Your Target Audience and Your Competition Will Be At D2C</h2><p><span style="line-height: 1.538em;">The D2c Show provides your company with an unparalleled marketing opportunity to get before industry decision-makers.</span></p><p>Nearly 4,000 attendees from all facets of direct response marketing come to D2C to learn about the latest technologies and network with their peers. It''s everyone from managers to C-level executives to inventors to founders. It''s where they come to make decisions about where they want to take their business in the years to come — and what they''ll buy to make those plans happen.</p>', '', 'full_html'),
('node', 'register', 0, 44, 44, 'und', 0, '<p>Individual registration is for members and non-members interested in attending the D2C Show. Exhibitors and Sponsors should use the Exhibitor Registration page to ensure correct pricing.</p>', '', 'full_html'),
('node', 'register', 0, 46, 46, 'und', 0, 'Exhibitor and Sponsor registration is for staff of exhibiting and sponsoring companies. Here you''ll learn about badge types, registration rates and registration policies.', '', 'php_code'),
('node', 'register', 0, 47, 47, 'und', 0, '<p>Sending five or more staff to the show? Don''t worry, we''ve got you covered. As a VIP service to large companies, we offer group registration so you only have to fill out one form and make one payment!</p>', '', 'full_html');

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

--
-- Table structure for table `field_data_field_teaser_image`
--

CREATE TABLE IF NOT EXISTS `field_data_field_teaser_image` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_teaser_image_fid` int(10) unsigned DEFAULT NULL COMMENT 'The file_managed.fid being referenced in this field.',
  `field_teaser_image_alt` varchar(512) DEFAULT NULL COMMENT 'Alternative image text, for the image’s ’alt’ attribute.',
  `field_teaser_image_title` varchar(1024) DEFAULT NULL COMMENT 'Image title text, for the image’s ’title’ attribute.',
  `field_teaser_image_width` int(10) unsigned DEFAULT NULL COMMENT 'The width of the image in pixels.',
  `field_teaser_image_height` int(10) unsigned DEFAULT NULL COMMENT 'The height of the image in pixels.',
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_teaser_image_fid` (`field_teaser_image_fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 6 (field_teaser_image)';

--
-- Dumping data for table `field_data_field_teaser_image`
--

INSERT INTO `field_data_field_teaser_image` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_teaser_image_fid`, `field_teaser_image_alt`, `field_teaser_image_title`, `field_teaser_image_width`, `field_teaser_image_height`) VALUES
('node', 'mt_product', 0, 1, 1, 'und', 0, 87, '', 'Move and shake with the best. ', 950, 340),
('node', 'mt_product', 0, 2, 2, 'und', 0, 109, '', '', 1632, 1224),
('node', 'mt_service', 0, 7, 7, 'und', 0, 56, '', '', 918, 612),
('node', 'mt_service', 0, 6, 6, 'und', 0, 145, '', '', 950, 633),
('node', 'register', 0, 44, 44, 'und', 0, 150, '', '', 500, 333),
('node', 'register', 0, 46, 46, 'und', 0, 152, '', '', 950, 633),
('node', 'register', 0, 47, 47, 'und', 0, 115, '', '', 500, 267),
('node', 'slideshow_new', 0, 87, 87, 'und', 0, 151, '', '', 918, 342),
('node', 'slideshow_new', 0, 85, 85, 'und', 0, 148, '', '', 918, 342),
('node', 'slideshow_new', 0, 92, 92, 'und', 0, 160, '', '', 918, 342),
('node', 'mt_event', 0, 83, 83, 'und', 0, 166, '', '', 600, 900);

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

--
-- Table structure for table `field_data_field_title`
--

CREATE TABLE IF NOT EXISTS `field_data_field_title` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_title_value` varchar(30) DEFAULT NULL,
  `field_title_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_title_format` (`field_title_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 23 (field_title)';

--
-- Dumping data for table `field_data_field_title`
--

INSERT INTO `field_data_field_title` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_title_value`, `field_title_format`) VALUES
('node', 'speaker', 0, 34, 34, 'und', 0, 'VP Marketing', NULL);

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

--
-- Table structure for table `field_data_field_website`
--

CREATE TABLE IF NOT EXISTS `field_data_field_website` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_website_value` varchar(255) DEFAULT NULL,
  `field_website_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_website_format` (`field_website_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 34 (field_website)';

--
-- Dumping data for table `field_data_field_website`
--

INSERT INTO `field_data_field_website` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_website_value`, `field_website_format`) VALUES
('node', 'exhibitor', 0, 31, 31, 'und', 0, 'Retailing.org', NULL),
('node', 'exhibitor', 0, 56, 56, 'und', 0, 'www.a2bfulfillment.com', NULL),
('node', 'exhibitor', 0, 57, 57, 'und', 0, 'www.accessdevelopment.com', NULL),
('node', 'exhibitor', 0, 58, 58, 'und', 0, 'www.adeptivsolutions.com', NULL),
('node', 'exhibitor', 0, 59, 59, 'und', 0, 'www.advantone.com', NULL),
('node', 'exhibitor', 0, 60, 60, 'und', 0, 'www.appliedperceptions.com', NULL),
('node', 'exhibitor', 0, 80, 80, 'und', 0, 'www.bay-cities.biz/', NULL);

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

--
-- Table structure for table `field_data_field_zip_code`
--

CREATE TABLE IF NOT EXISTS `field_data_field_zip_code` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_zip_code_value` varchar(255) DEFAULT NULL,
  `field_zip_code_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_zip_code_format` (`field_zip_code_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Data storage for field 30 (field_zip_code)';

--
-- Dumping data for table `field_data_field_zip_code`
--

INSERT INTO `field_data_field_zip_code` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_zip_code_value`, `field_zip_code_format`) VALUES
('node', 'sponsor', 0, 32, 32, 'und', 0, '12345', NULL);

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

--
-- Table structure for table `field_revision_body`
--

CREATE TABLE IF NOT EXISTS `field_revision_body` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `body_value` longtext,
  `body_summary` longtext,
  `body_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `body_format` (`body_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Revision archive storage for field 2 (body)';

--
-- Dumping data for table `field_revision_body`
--

INSERT INTO `field_revision_body` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `body_value`, `body_summary`, `body_format`) VALUES
('node', 'mt_product', 0, 2, 2, 'und', 0, '<p>From new product presentations to D2C Learning Lounge sessions to the Women in Business Pavilion, there is something for everyone everyday of the show. Please note that events with this symbol beside them <img alt="AAP Button" height="16" src="images/AAP25.jpg" width="25">&nbsp;require an All Access Pass to attend.</p>', '', 'full_html'),
('node', 'page', 0, 4, 4, 'und', 0, '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.</p>\r\n\r\n<blockquote>"Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum."</blockquote>\r\n\r\n<h2>Header 2</h2>\r\nLorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.\r\n\r\n<h2><a href="#">Linked Header 2</a></h2>\r\nLorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.\r\n\r\n<h3>Header 3</h3>\r\nLorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.\r\n\r\n<h4>Header 4</h4>\r\nLorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.\r\n\r\n<h2>Code snippet</h2>\r\n\r\n<code>#header h1 a <br />\r\ndisplay: block;<br />\r\nheight: 80px;<br />\r\nwidth: 300px;<br />\r\n</code>\r\n\r\n<h2>Messages</h2>\r\n\r\n<div class="messages status">Save $100 and register before July 1, 2013!</div>\r\n<div class="messages error">Sample error message. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</div>\r\n<div class="messages warning">Sample warning message. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</div>\r\n\r\n<h2>Paragraph With Links</h2>\r\n<p>Lorem ipsum dolor sit amet, <a href="#">consectetuer adipiscing</a> elit. Donec odio. Quisque volutpat mattis eros. <a href="#">Nullam malesuada</a> erat ut turpis. Suspendisse urna nibh, viverra non, semper suscipit, posuere a, pede.</p>\r\n\r\n<h2>Ordered List</h2>\r\n<ol>\r\n<li>This is a sample <strong>Ordered List</strong>.</li>\r\n<li>Lorem ipsum dolor sit amet consectetuer.</li>\r\n<li>Condimentum quis.</li>\r\n<li>Congue Quisque augue elit dolor.\r\n<ol>\r\n<li>Something goes here.</li>\r\n<li>And another here</li>\r\n<li>Then one more</li>\r\n</ol>\r\n</li>\r\n<li>Congue Quisque augue elit dolor nibh.</li>\r\n</ol>\r\n\r\n<h2>Unordered List</h2>\r\n<ul>\r\n<li>This is a sample <strong>Unordered List</strong>.</li>\r\n<li>Condimentum quis.</li>\r\n<li>Congue Quisque augue elit dolor.\r\n<ul>\r\n<li>Something goes here.</li>\r\n<li>And another here\r\n<ul>\r\n<li>Something here as well</li>      \r\n<li>Something here as well</li>\r\n<li>Something here as well</li>\r\n</ul>\r\n</li>\r\n<li>Then one more</li>\r\n</ul>\r\n</li>\r\n<li>Nunc cursus sem et pretium sapien eget.</li>\r\n</ul>\r\n\r\n<h2>Fieldset</h2>\r\n<fieldset> <legend>Account information</legend> </fieldset>\r\n\r\n<h2>Table</h2>\r\n\r\n<table border="1">\r\n\r\n<tr>\r\n<th>Header 1</th>\r\n<th>Header 2</th>\r\n</tr>\r\n\r\n<tr class="odd">\r\n<td>row 1, cell 1</td>\r\n<td>row 1, cell 2</td>\r\n</tr>\r\n\r\n<tr class="even">\r\n<td>row 2, cell 1</td>\r\n<td>row 2, cell 2</td>\r\n</tr>\r\n\r\n<tr class="odd">\r\n<td>row 3, cell 1</td>\r\n<td>row 3, cell 2</td>\r\n</tr>\r\n\r\n</table>', '', 'full_html'),
('node', 'page', 0, 5, 5, 'und', 0, '<p>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, which includes members that maximize revenues through direct-to-consumer marketing on television, online, mobile and on radio.</p><h2>Future Show Dates/Locations</h2><p><strong>2013</strong><br>September 24-26, 2013<br>Wynn Las Vegas<br>Las Vegas, Nevada</p><p><strong>2014</strong><br>September 16-18, 2014<br>Wynn Las Vegas<br>Las Vegas, Nevada</p><p><strong>2015</strong><br>October 6-8, 2015<br>Wynn Las Vegas<br>Las Vegas, Nevada</p><h2>History</h2><p>The ERA Annual Convention was renamed the ERA D2C Convention in 2009. The show has always been held in Las Vegas, Nevada and the first ERA Annual Convention was held in 1990 soon after the birth of the infomercial. The show has since grown to more than 4,000 attendees and 160+ exhibitors and sponsors.</p><h2>Sponsor</h2><p>The ERA D2C Convention is sponsored, produced and managed by the Electronic Retailing Association (ERA). Show proceeds are used to fund industry and member services.</p>', '', 'full_html'),
('node', 'mt_service', 0, 7, 7, 'und', 0, '<p>Protect your investment and maximize your ROI with sponsorship opportunities at the ERA D2C Convention. Sponsorships deliver the greatest access to the biggest gathering of the direct response elite. With everything from luncheons to reception sponsorships available, there''s an opportunity to fit every need and budget. Stand out and you''ll move ahead.</p>', '', 'full_html'),
('node', 'article', 0, 29, 29, 'und', 0, '<p>This is a test of jerry''s article and blah blah blah . lj;sadhfousdafnv posadjvgpasdf vpoasdfbvjkj''a mefasd;bvjasdfio basofjbvkpasdfoj bpasjepqmrbvg qwer v.</p>', '', 'full_html'),
('node', 'blog', 0, 12, 12, 'und', 0, ' <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad <a href="#">minim veniam</a>, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>\r\n <blockquote>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco...</blockquote>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.</p>', '', 'filtered_html'),
('node', 'mt_testimonial', 0, 10, 10, 'und', 0, '<p>“We attend many conventions each year but the D2C show is at the top of our list. The entire ERA team does an excellent job bringing educational topics, attendees, marketers and vendors together, and the value we get from this show always exceeds our expectations.”</p>', '', 'full_html'),
('node', 'page', 0, 14, 14, 'und', 0, '<p>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, which includes members that maximize revenues through direct-to-consumer marketing on television, online, mobile and on radio.</p><h2>Future Show Dates/Locations</h2><p><strong>2013</strong> September 24-26, 2013 Venue: Wynn Las Vegas Location: Las Vegas, Nevada</p><h3>2014</h3><p>September 16-18, 2014 Wynn Las Vegas, Las Vegas, Nevada 2015 October 6-8, 2015 Wynn Las Vegas, Las Vegas, Nevada History The ERA Annual Convention was renamed the ERA D2C Convention in 2009. The show has always been held in Las Vegas, Nevada and the first ERA Annual Convention was held in 1990 soon after the birth of the infomercial. The show has since grown to more than 4,000 attendees and 160+ exhibitors and sponsors. Sponsor The 2012 ERA D2C Convention is sponsored, produced and managed by the Electronic Retailing Association (ERA). Show proceeds are used to fund industry and member services. Contact Us Electronic Retailing Association (ERA) 607 14th Street, N.W. Suite 530 Washington, D.C. 20005, USA Phone: +1 800-987-6462 or +1 703-841-1751 Fax: 425.977.1036 webadmin@retailing.org www.retailing.org</p>', '', 'full_html'),
('node', 'mt_product', 0, 1, 1, 'und', 0, '<p>Move and shake with the best. The 2013 ERA D2C Convention is THE place to mix it up with industry leaders just like you. The show is packed with networking events where you’ll make the connections and seal the deals that will strengthen your business. Please note that events with this symbol beside them – <img alt="All Access Pass required" height="16" src="http://www.d2cshow.org/images/AAP25.jpg" width="25"> – require an All Access Pass to attend.</p>', '', 'full_html'),
('node', 'page', 0, 45, 45, 'und', 0, '<p>The Electronic Retailing Association (ERA) has enacted the following Speaker Policy for its education conferences and special events, including The Great Ideas Summit and the ERA D2C Convention. Speakers should adhere to the following:&nbsp;</p>\r\n<ul>\r\n	<li>\r\n		A supplier company may speak one time each at The Great Ideas Summit and the ERA D2C Convention, if selected. The supplier may NOT speak at the same conference in subsequent years if the company does not support ERA as a sponsor or exhibitor of that specific event. &nbsp;</li>\r\n	<li>\r\n		A supplier company that is a &ldquo;non-&shy;‐member&rdquo; may speak one time each at The Great Ideas Summit and the ERA D2C Convention, if selected. The supplier may NOT speak at the same conference during subsequent years if the company is a &ldquo;non-&shy;‐member.&rdquo;</li>\r\n	<li>\r\n		Supplier companies that are ERA members will have priority over &ldquo;non-&shy;‐member&rdquo; suppliers in the speaker-&shy;‐selection process.&nbsp;</li>\r\n	<li>\r\n		All selected speakers must complete and sign the ERA Speaker Contract below, which will be distributed to all speakers, and return to ERA by the published deadline.</li>\r\n	<li>\r\n		All selected speakers must be registered with an All Access Pass no later than 30 days prior to the conference date. Speakers will be provided a discounted speaker rate. <strong>(Note: Any speaker who fails to register by the deadline will be removed from the education schedule and replaced, if necessary.)</strong></li>\r\n	<li>\r\n		All speakers will be responsible for all travel arrangements and expenses that they incur.</li>\r\n</ul>\r\n<p>Please contact <a href="mailto:vpaynich@retailing.org">Vi Paynich</a> if you have any questions or comments.</p>\r\n', '', 'full_html'),
('node', 'mt_product', 0, 3, 3, 'und', 0, '<p>The ERA Moxie Awards Gala<sup>TM</sup> is direct response marketing''s premiere celebration honoring the best campaigns of the year. Moxie''s famous posh <span style="color: #0000ff;">BLUE</span> carpet welcomes guests for a grand entrance. The Gala features live music, exceptional dinner and superb company. Join us as we celebrate the industry''s most coveted award and D2C''s most exclusive event.</p><p><strong>Thursday, September 26, 2013</strong><br>Margaux Ballroom<br>7:00 p.m. - 9:30 p.m.</p><div><p><strong>Glitz. Glamour. Glory.</strong></p></div><h2>Tickets</h2><p>The ERA Moxie Awards&nbsp;Gala is a separately ticketed event. In order to attend, you must register for an All Access Pass or a Show Floor Only Pass for the D2C Show and then purchase a ticket (or table) to the Moxie Awards Gala. Here''s a list of the <a href="http://www.retailing.org/events/era-moxie-awards/2012-moxie-winners">2012 ERA Moxie Awards Gala Winners</a>.</p><h2>How to purchase Moxie Awards Gala tickets:</h2><ul><li><strong>Already registered for D2C?</strong> All attendees, exhibitors and sponsors, please purchase your <a href="https://s4.goeshow.com/era/d2cshow/2013/asc_welcome.cfm">Moxie tickets</a> here. Use the login info included in your confirmation email. Click on the first bullet “Moxie Awards Gala Tickets” and proceed to purchase your Moxie tables or individual tickets.</li><li><strong>Not yet registered for D2C?</strong> Register for D2C and then purchase your <a href="https://s4.goeshow.com/era/d2cshow/2013/reg_form.cfm">Moxie tickets</a>.</li></ul><h2>Moxie Gala Tables</h2><p>Reserve a table for you and your guests. Choose where you’d like your table to be at the Gala, receive a table-top sign with your company’s logo and seats for twelve people. <a href="mailto:keppsteiner@retailing.org?Subject=Moxie Awards Gala Table Request">Reserve your table today</a>.</p><h2>Awards Archive</h2><p><a href="http://www.retailing.org/events/era-moxie-awards/2012-moxie-winners">2012 Winners</a><br><a href="http://www.retailing.org/2011-moxie-award-winners" target="_blank">2011 Winners</a></p><p>&nbsp;</p>', '', 'full_html'),
('node', 'page', 0, 18, 18, 'und', 0, '<p>The 2013 ERA D2C Convention takes place in Las Vegas at the Wynn Las Vegas from September 24-26, 2013.</p><p><strong>2013 Show Dates and Location</strong><br>September 24-26, 2013<br>Venue: Wynn Las Vegas&nbsp;<br>Location: Las Vegas, Nevada</p><p>A detailed schedule will be coming soon!</p><p>&nbsp;</p>', '', 'full_html'),
('node', 'page', 0, 21, 21, 'und', 0, '<table border="1" cellpadding="1" cellspacing="1"><thead><tr><th scope="col">All Access Pass</th><th scope="col">Show Floor Only Pass</th></tr></thead><tbody><tr><td><em>Enjoy open access to all D2C activities including:</em></td><td><em>Provides limited access to D2C activities.</em></td></tr><tr><td><ul><li>Online Attendee List</li><li>Opening Reception</li><li>ALL networking events</li><li>Keynote Presentation</li><li>Meet &amp; Greet Lounge</li><li>ERA Circle Bar</li><li>All Access Pass Lounge</li><li>Free Networking Lunches on the Show Floor</li><li>Networking Breakfasts on Wed. &amp;&nbsp;&nbsp;Thurs.</li><li>Discounted show bag inserts (while supplies last)</li></ul></td><td><ul><li>Meet &amp; Greet Lounge</li><li>Keynote Presentation</li><li>ERA Circle Bar</li><li>Show Floor (including the D2C Learning Lounge)</li><li>Free Networking Lunches on the Show Floor</li></ul><p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p></td></tr></tbody></table><br><h2>Individual Registration Rates</h2><table border="1"><tbody><tr><th>Badge Type</th><th>Thru June 30</th><th>July 1 - Sept. 20</th><th>Onsite</th></tr><tr class="odd"><td>All Access Pass - ERA Members</td><td>$850</td><td>$1,129</td><td>$1,329</td></tr><tr class="even"><td>All Access Pass - Non-Members</td><td>$1,399</td><td>$1,599</td><td>$1,699</td></tr><tr class="odd"><td>Additional All Access Pass - ERA Members</td><td>$650</td><td>$929</td><td>$1,129</td></tr><tr class="even"><td>Show Floor Only Pass - ERA Members</td><td>FREE</td><td>$149</td><td>$249</td></tr><tr class="odd"><td>Show Floor Only Pass - ERA Members</td><td>$99</td><td>$199</td><td>$299</td></tr></tbody></table><br><h2>Moxie Awards Gala Tickets</h2><table border="1"><tbody><tr><th>&nbsp;</th><th>Thru June 30</th><th>July 1 - Sept. 20</th><th>Onsite</th></tr><tr class="odd"><td>ERA Members</td><td>$179</td><td>$199</td><td>$249</td></tr><tr class="even"><td>Non-Members</td><td>$299</td><td>$349</td><td>$399</td></tr><tr class="odd"><td>Reserved Table for Twelve</td><td>$2,149</td><td>$2,289</td><td>$2,789</td></tr></tbody></table><p><br><strong>Already registered for D2C?</strong> Please purchase your <a href="https://s4.goeshow.com/era/d2cshow/2013/asc_welcome.cfm">Moxie tickets</a> here. Use the login info included in your confirmation email. Click on the first bullet “Moxie Awards Gala Tickets” and proceed to purchase your Moxie table or individual tickets.</p><p class="mainarticle"><a href="/content/registration-policies"><strong><span style="font-size: large;">Registration Policies</span></strong></a><br>&nbsp;</p><p class="mainarticle">&nbsp;</p>', '', 'full_html'),
('node', 'page', 0, 43, 43, 'und', 0, '<div>\r\n  <h2>Pricing Table &ndash; Style 2</h2>\r\n\r\n  <table class="gen-table pricing-table responsive">\r\n    <thead>\r\n      <tr>\r\n        <th class="empty-left-top">&nbsp;</th>\r\n        <th>\r\n          <span class="title">Basic</span>\r\n          <span class="price">\r\n            <span>&#36;20</span>\r\n            <sup>/month</sup>\r\n          </span> \r\n        </th>\r\n        <th>\r\n          <span class="title">Standard</span>\r\n          <span class="price">\r\n            <span>&#36;50</span>\r\n            <sup>/month</sup>\r\n          </span>  \r\n        </th>\r\n        <th class="featured">\r\n          <span class="title">Plus</span>\r\n          <span class="price">\r\n            <span>&#36;100</span>\r\n            <sup>/month</sup>\r\n          </span> \r\n        </th>\r\n        <th>\r\n          <span class="title">Pro</span>\r\n          <span class="price">\r\n            <span>&#36;150</span>\r\n            <sup>/month</sup>\r\n          </span> \r\n        </th>\r\n      </tr>\r\n    </thead>\r\n    <tfoot>\r\n      <tr>\r\n        <td class="empty-left-bottom">&nbsp;</td>\r\n        <td><a class="button black" href="#">Order Now</a></td>\r\n        <td><a class="button black" href="#">Order Now</a></td>\r\n        <td><a class="button" href="#">Order Now</a></td>\r\n        <td><a class="button black" href="#">Order Now</a></td>\r\n      </tr>\r\n    </tfoot>\r\n    <tbody>\r\n      <tr>\r\n        <th>Users</th>\r\n        <td>5</td>\r\n        <td>20</td>\r\n        <td>60</td>\r\n        <td>120</td>\r\n      </tr>\r\n      <tr class="odd">\r\n        <th>Forms</th>\r\n        <td>10</td>\r\n        <td>Unlimited</td>\r\n        <td>Unlimited</td>\r\n        <td>Unlimited</td>\r\n      </tr>\r\n      <tr>\r\n        <th>Reports</th>\r\n        <td>20</td>\r\n        <td>Unlimited</td>\r\n        <td>Unlimited</td>\r\n        <td>Unlimited</td>\r\n      </tr>\r\n      <tr class="odd">\r\n        <th>Entries / Month</th>\r\n        <td>500</td>\r\n        <td>3,000</td>\r\n        <td>15,000</td>\r\n        <td>100,000</td>\r\n      </tr>\r\n      <tr>\r\n        <th>SSL Encryption</th>\r\n        <td>&mdash;</td>\r\n        <td><span class="check">&nbsp;</span></td>\r\n        <td><span class="check">&nbsp;</span></td>\r\n        <td><span class="check">&nbsp;</span></td>\r\n      </tr>\r\n      <tr class="odd">\r\n        <th>Payment Integration</th>\r\n        <td>&mdash;</td>\r\n        <td><span class="check">&nbsp;</span></td>\r\n        <td><span class="check">&nbsp;</span></td>\r\n        <td><span class="check">&nbsp;</span></td>\r\n      </tr>\r\n      <tr class="row-last">\r\n        <th>Storage</th>\r\n        <td>3 GB</td>\r\n        <td>15 GB</td>\r\n        <td>40 GB</td>\r\n        <td>100 GB</td>\r\n      </tr>\r\n    </tbody>\r\n  </table>\r\n</div>', '', 'full_html'),
('node', 'page', 0, 38, 38, 'und', 0, '<br><p><span style="line-height: 1.538em;">Thank you for your willingness to share your time, knowledge, and resources as a content leader at the 2013 ERA D2C Convention. Below you will find all the resources you need create a successful session for D2C attendees.</span></p><div><span style="line-height: 1.538em;">Get the word out about the conference using our twitter hashtag </span><a href="http://www.twitter.com/search/d2c2013" style="line-height: 1.538em;">#d2c2013</a><span style="line-height: 1.538em;">.</span></div><div>&nbsp;</div><div><strong>Speaker Dates and Deadlines:</strong></div><div>&nbsp;</div><ol><li>Accept speaker letter of agreement: TBD</li><li><span style="line-height: 1.538em;">Update content leader profile: TBD</span></li><li><span style="line-height: 1.538em;">Read the Speaker Manual: TBD</span></li><li><span style="line-height: 1.538em;">Register for the Conference: June 30, 2013</span></li><li><span style="line-height: 1.538em;">Reserve hotel room (if applicable): TBD</span></li><li><span style="line-height: 1.538em;">Attend Speaker Orientation Conference Call: TBD</span></li></ol><div>&nbsp;</div><div>Should you have any questions please contact Vi Paynich at <a href="mailto:vpaynich@retailing.org">vpaynich@retailing.org</a>.</div><div>&nbsp;</div><div>Speaker Policy</div>', '', 'full_html'),
('node', 'page', 0, 37, 37, 'und', 0, '<p>Do you have an innovative idea or topic you want to share with your fellow ERA members and the industry at large? Then the 2013 ERA D2C Convention may be the perfect setting for you! This is your opportunity to participate in the premier annual direct-to-consumer conference in the marketing space and impart your expertise with others in the industry.&nbsp;<span style="line-height: 1.538em;">Once again, the Electronic Retailing Association (ERA) is initiating a crowd-sourcing strategy for the education program at the 2013 ERA D2C Convention.</span></p><p>This year, ERA is offering two different session formats: One-hour Session/Panel discussion and Lightning Sessions (a 15-minute presentation). Please note there are two separate Submission Forms for a One-hour Session and Lightning Session.</p><p>Sessions to be presented will be chosen by a vote of the ERA Content Committee, the ERA Staff and ERA members.</p><p><strong>Getting Started</strong></p><ol><li><a href="/pdfs/D2C2013_Session_Guidelines_011513.pdf">Review the Submission Guidelines</a></li><li>Complete one (or both) of the Session Submission Forms</li></ol><ul style="margin-left: 40px;"><li><a href="/content/session-submission-form">One-hour Session/Panel</a></li><li><a href="/content/session-submission-form">Lightning Session</a> (15-minute format)</li></ul><p><strong>Deadline:</strong>&nbsp;<strong>Wednesday, March 27, 2013</strong></p><p><strong>Questions:</strong><br>Vi Paynich<br>909-606-3406<br><a href="mailto:vpaynich@retailing.org?subject=D2C%20Education%20Session%20Submission%20Question">vpaynich@retailing.org</a></p>', '', 'full_html'),
('node', 'page', 0, 40, 40, 'und', 0, '<h2>Cancellation/Refund Policy&nbsp;</h2><div>All cancellations must be received in writing. <strong>Cancellations received on or before August 25, 2013 are eligible for a 50% refund. No refunds will be made after August 25, 2013.</strong> No-shows will not be refunded. Substitutions from the same company can be made at no charge (see Substitution Policy).</div><div>&nbsp;</div><h2>Substitution Policy</h2><div>Substitution of registrations from the same company is permitted prior to the conference and onsite. Only one substitution is permitted per original registrant. The individual submitting the substitution request is responsible for all financial obligations (any balance due) associated with that substitution as well as updating any contact information. Substitutions cannot be made after a badge has been issued.</div><div>&nbsp;</div><h2>Group Badge Distribution/Pick-Up</h2><div>Group badge pick-up is permitted although not encouraged. In the event that one person from a company collects badges for multiple employees that person accepts full responsibility for those badges. ERA will not re-issue badges directly to those individuals.</div><div>&nbsp;</div><h2>Badge Sharing</h2><div>Each badge is intended for the exclusive use of the person named on the badge. Business cards cannot be used in place of or inserted on top of badges. In the event two or more individuals are found to be sharing a badge, the badge will be immediately voided and no refunds issued. Voided badges will not be available for re-issue. Attendees may be asked to show valid identification. Failure to present a photo ID matching the name on the badge in question upon request will result in the forfeiture of the badge.</div><div>&nbsp;</div><h2>Badge Downgrades&nbsp;</h2><div>A badge downgrade from an All Access Pass to a Show Floor Only Pass is considered a cancellation of the original All Access Pass (see the Cancellation Policy for refund information). The new registration for the Show Floor Only Pass will be based on current registration rates.</div><div>&nbsp;</div><h2>Guest Passes</h2><div>Guest passes must be pre-registered on or before September 20, 2013. New registration requests onsite for Guest Passes through the Exhibitor Invites program are not allowed.</div><div>&nbsp;</div><h2>ERA Member Pricing Policy</h2><div>In order to receive ERA member pricing for all ERA events, the member must be in good standing at the time the registration is made AND at the time of the event. If ERA membership has lapsed, the individual will be required to pay the difference between ERA member and non-member rates before an attendee badge is provided.</div><div>&nbsp;</div><div><h2>Company Name Policy</h2></div><div>In order to receive member pricing the company name on the attendee badge must match the company name on the ERA membership.</div><div>&nbsp;</div><h2>Consent to Use of Photographic Images</h2><div>Registration and attendance at, or participation in, ERA meetings and other activities constitutes an agreement by the registrant to ERA''s use and distribution (both now and in the future) of the registrant or attendee''s image or voice in photographs, videotapes, electronic reproductions and audiotapes of such events and activities.</div><div>&nbsp;</div><h2>Children, Friends and Family</h2><div>The D2C Convention is a trade-only event. Children, friends and family who accompany an attendee to Las Vegas will not be granted access to the ERA D2C Convention unless they are over the age of 18 and have proof of industry affiliation and are a registered attendee. Absolutely no one under the age of 18 is permitted on the show floor including infants or children in strollers.</div><div>&nbsp;</div><h2>Questions?</h2><div>Contact ERA Customer Service at <a href="mailto:registration@retailing.org">registration@retailing.org</a> or call 703-841-1751.</div>', '', 'full_html'),
('node', 'mt_service', 0, 6, 6, 'und', 0, '<p>The D2C Show provides your company with an unparalleled marketing opportunity to get before industry decision-makers.Nearly 4,000 attendees from all facets of direct response marketing come to D2C to learn about the latest technologies and network with their peers. It''s everyone from managers to C-level executives to inventors to founders. It''s where they come to make decisions about where they want to take their business in the years to come — and what they''ll buy to make those plans happen.</p>', '', 'full_html'),
('node', 'mt_testimonial', 0, 9, 9, 'und', 0, '<p>“It was impossible for visitors not to see us at ERA D2C and we had lots of good conversations. You have given us many opportunities for networking and the ﬁrst time placement at the show was great"</p>', '', 'full_html'),
('node', 'page', 0, 23, 23, 'und', 0, '<p>The ERA D2C Convention is truly a global stage for the direct response industry. Attendees from more than 60 countries have traveled to Las Vegas in the past to network with leaders from around the world and to attend the best education sessions for the DR industry.</p><p><strong>Need a visa</strong>? You can now complete the <a href="https://evisaforms.state.gov/ds156.asp?lang=1" target="_blank">visa application form online</a>.</p>', '', 'full_html'),
('node', 'mt_testimonial', 0, 49, 49, 'und', 0, '<p>Attending the ERA D2C convention gave UPS an opportunity to help attendees understand their supply chains. &nbsp;We focused on the customer buying experience and how logistics can support their goals. &nbsp;The ERA match- making service allowed UPS to accomplish this with new potential clients.</p>', '', 'full_html'),
('node', 'page', 0, 26, 26, 'und', 0, '<p><span style="line-height: 1.538em;">If you wish to pay by check or wire transfer, please fill out the </span><a href="/pdfs/D2C2013_Group_WireandCheck_Reg.xlsx" style="line-height: 1.538em;">Check/Wire transfer template</a><span style="line-height: 1.538em;"> and return to </span><a href="mailto:registration@retailing.org" style="line-height: 1.538em;">registration@retailing.org</a><span style="line-height: 1.538em;">. Once your payment is received we will process your registrations.&nbsp;</span><span style="line-height: 1.538em;">If you have any questions regarding registration please refer to the&nbsp;</span><a href="#FAQ" style="line-height: 1.538em;">FAQ''s</a><span style="line-height: 1.538em;">&nbsp;below</span><span style="line-height: 1.538em;">.</span></p><ul><li><strong><a href="/pdfs/D2C2013_Group_WireandCheck_Reg.xlsx" style="line-height: 1.538em;">Check/Wire transfer template</a></strong></li></ul><p><strong style="line-height: 1.538em;"><span style="text-decoration: underline;">FAQ''s</span></strong><a name="FAQ"></a></p><p><strong>Q: I sent in a check for registrations, when will I receive confirmation?</strong><br><span style="line-height: 1.538em;">A: Once we receive your check we will immediately process your registrations and you will receive an email confirmation.</span></p><p><strong>Q: If I am paying by credit card and do not have a group to register, where can I register?</strong><br><span style="line-height: 1.538em;">A: Visit the </span><a href="https://s4.goeshow.com/era/d2cshow/2013/reg_form.cfm" style="line-height: 1.538em;">registration site</a><span style="line-height: 1.538em;"> and follow the steps to register.</span></p><p><strong>Q:Where should I send my registration check?</strong><br><span style="line-height: 1.538em;">A: Please send to:</span></p><p>Electronic Retailing Association<br>607 14th St. NW, Suite 530<br>Washington, DC 20005</p><p><strong>Q: I have a question about the registration process, who should I contact?</strong><br><span style="line-height: 1.538em;">A: Please contact </span><a href="mailto:registration@retailing.org" style="line-height: 1.538em;">registration@retailing.org</a><span style="line-height: 1.538em;"> and we will get back to you shortly to assist you with registration.</span></p><p>&nbsp;</p><p>&nbsp;</p>', '', 'full_html'),
('node', 'page', 0, 24, 24, 'und', 0, '<h2><span style="color:#D84A27;">D2C Provides New Business, Ideas and Solutions!</span></h2><p>More than 3,400 DR decision-makers, including many of your competitors, attend the 2013 ERA D2C Convention to get ideas and find answers to their direct response problems. They will see new solutions demonstrated ... and choose the best for their needs.</p><div>At D2C they find ways to drive new business and optimize ROI. They know that to survive and succeed, they must keep up with the latest DR trends ... and stay ahead of their competitors!</div><h2><span style="color:#D84A27;">Find All the People You NeeD2C</span></h2><ul><li><span style="font-size:20px;"><strong>63%</strong></span> believed there was a good mix of exhibitors, products and services on the show floor</li><li><span style="font-size:20px;"><strong>53%</strong></span> said the opportunities to network were excellent</li><li><span style="font-size:20px;"><strong>60%</strong></span> signed a deal as a result of attending the show</li><li><span style="font-size:20px;"><strong>54%</strong></span> had at least 10 meetings during the show (and 31% had more tan 20 meetings!)</li><li><span style="font-size:20px;"><strong>55%</strong></span> generated at least 6 leads as a result of attending the show (and 23% generated at least 10 leads!)</li></ul><h2><span style="color:#D84A27;">Who Should Attend D2C?</span></h2><p>Everyone involved in direct response marketing benefits from the networking, business development, exhibitors and education sessions at the D2C show!</p><ul><li>Executives building a business</li><li><div>Decision makers involved in DR marketing purchases</div></li><li><div><span style="line-height: 1.538em;">Marketers in search of&nbsp;new products and services</span></div></li><li><div>Agencies providing creative and production services</div></li><li><div><span style="line-height: 1.538em;">Media Buyers who purchase TV and radio time</span></div></li><li><div><span style="line-height: 1.538em;">Suppliers who fulfill orders</span></div></li><li><div><span style="line-height: 1.538em;">All staff members and suppliers you count on for new ideas</span></div></li></ul>', '', 'full_html'),
('node', 'article', 0, 27, 27, 'und', 0, '<p>Registration for the 2013 ERA D2C Convention opens on Monday, February, 25, 2013. Look for special offers from ERA on February 25 and SAVE big!</p>', '', 'full_html'),
('node', 'page', 0, 30, 30, 'und', 0, '<table border="1" cellpadding="1" cellspacing="1" style="width: 625px; height: 214px;"><thead><tr><th scope="col">All Access Pass</th><th scope="col">Show Floor Only Pass</th></tr></thead><tbody><tr><td><em>Enjoy open access to all D2C activities including:</em></td><td><em>Provides limited access to D2C activities.</em></td></tr><tr><td><ul><li>Online Attendee List</li><li>Opening Reception</li><li>ALL networking events</li><li>Keynote Presentation</li><li>Meet &amp; Greet Lounge</li><li>ERA Circle Bar</li><li>All Access Pass Lounge</li><li>Free Networking Lunches on the Show Floor</li><li>Networking Breakfasts on Wed. &amp;&nbsp;&nbsp;Thurs.</li><li>Discounted show bag inserts (while supplies last)</li></ul></td><td><ul><li>Meet &amp; Greet Lounge</li><li>Keynote Presentation</li><li>ERA Circle Bar</li><li>Show Floor (including the D2C Learning Lounge)</li><li>Free Networking Lunches on the Show Floor</li></ul><p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p></td></tr></tbody></table><h2>Exhibitor/Sponsor Registration Rates</h2><table border="1" cellpadding="1" cellspacing="1" style="width: 625px;"><thead><tr><th scope="col" style="text-align: left;">Badge Type</th><th scope="col">Thru June 30</th><th scope="col">July 1 - Sept. 20</th><th scope="col">OnSite</th></tr></thead><tbody><tr><td>All Access Pass<br>(<span style="font-size: 0.923em; line-height: 1.538em;">Two free All Access Passes for each 100 sq. ft. of exhibit space)</span></td><td>FREE</td><td>FREE</td><td>FREE</td></tr><tr><td><p>Additional All Access Pass for Exhibitors/Sponsors from the same company:</p></td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr><tr><td><p style="margin-left: 40px;">ERA Members</p></td><td>$599</td><td>$799</td><td>$999</td></tr><tr><td><p style="margin-left: 40px;">Non-Members</p></td><td>$699</td><td>$999</td><td>$1,199</td></tr><tr><td>Show Floor Only Pass (Four free Show Floor Only Passes for each 100 sq. ft. of exhibit space)</td><td>FREE</td><td>FREE</td><td>FREE</td></tr><tr><td>Additional Show Floor Only Pass for&nbsp;Exhibitors/Sponsors from same company:</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr><tr><td><p style="margin-left: 40px;">ERA Members</p></td><td>FREE</td><td>$149</td><td>$249</td></tr><tr><td><p style="margin-left: 40px;">Non-Members</p></td><td>$99</td><td>$199</td><td>$299</td></tr></tbody></table><h2>Moxie Awards Gala Tickets</h2><table border="1" cellpadding="1" cellspacing="1" style="width: 625px;"><thead><tr><th scope="col">&nbsp;</th><th scope="col">THRU JUNE 30</th><th scope="col">JULY 1 - SEPT. 20</th><th scope="col">ONSITE</th></tr></thead><tbody><tr><td>ERA Members</td><td>$179</td><td>$199</td><td>$249</td></tr><tr><td>Non-Members</td><td>$299</td><td>$349</td><td>$399</td></tr><tr><td>Reserved Table for Twelve</td><td>$2,149</td><td>$2,289</td><td>$2,789</td></tr></tbody></table><p>&nbsp;</p><p><strong>Already registered for D2C?</strong> Please purchase your <a href="https://s4.goeshow.com/era/d2cshow/2013/asc_welcome.cfm">Moxie tickets</a> here. Use the login info included in your confirmation email. Click on the first bullet “Moxie Awards Gala Tickets” and proceed to purchase your Moxie table or individual tickets.</p><p class="mainarticle"><a href="/content/registration-policies"><strong><span style="font-size: large;">Registration Policies</span></strong></a><br>&nbsp;</p><p class="mainarticle">&nbsp;</p>', '', 'full_html'),
('node', 'mt_event', 0, 83, 83, 'und', 0, '<p>The ERA Moxie Awards Gala<sup>TM</sup> is direct response marketing''s premiere celebration honoring the best campaigns of the year. Moxie''s famous posh <span style="color: rgb(0, 0, 255);">BLUE</span> carpet welcomes guests for a grand entrance. The Gala features live music, exceptional dinner and superb company. Join us as we celebrate the industry''s most coveted award and D2C''s most exclusive event.</p><p><strong>Thursday, September 26, 2013</strong><br>Margaux Ballroom<br>7:00 p.m. - 9:30 p.m.</p><div><p><strong>Glitz. Glamour. Glory.</strong></p></div><h2>Tickets</h2><p>The ERA Moxie Awards&nbsp;Gala is a separately ticketed event. In order to attend, you must register for an All Access Pass or a Show Floor Only Pass for the D2C Show and then purchase a ticket (or table) to the Moxie Awards Gala. Here''s a list of the <a href="http://www.retailing.org/events/era-moxie-awards/2012-moxie-winners">2012 ERA Moxie Awards Gala Winners</a>.</p><h2>How to purchase Moxie Awards Gala tickets:</h2><ul><li><strong>Already registered for D2C?</strong> All attendees, exhibitors and sponsors, please purchase your <a href="https://s4.goeshow.com/era/d2cshow/2013/asc_welcome.cfm">Moxie tickets</a> here. Use the login info included in your confirmation email. Click on the first bullet “Moxie Awards Gala Tickets” and proceed to purchase your Moxie tables or individual tickets.</li><li><strong>Not yet registered for D2C?</strong> Register for D2C and then purchase your <a href="https://s4.goeshow.com/era/d2cshow/2013/reg_form.cfm">Moxie tickets</a>.</li></ul><h2>Moxie Gala Tables</h2><p>Reserve a table for you and your guests. Choose where you’d like your table to be at the Gala, receive a table-top sign with your company’s logo and seats for twelve people. <a href="mailto:keppsteiner@retailing.org?Subject=Moxie Awards Gala Table Request">Reserve your table today</a>.</p><h2>Awards Archive</h2><p><a href="http://www.retailing.org/events/era-moxie-awards/2012-moxie-winners">2012 Winners</a><br><a href="http://www.retailing.org/2011-moxie-award-winners" target="_blank">2011 Winners</a></p><p>&nbsp;</p>', '', 'full_html'),
('node', 'speaker', 0, 34, 34, 'und', 0, '<p>Dave Martin is the Vice President of Marketing &amp; Content at the Electronic Retailing Association (ERA). Dave has worked for ERA since early 2009. Before that Dave worked in global telecommunications marketing, product management, and product development both in the United States and Europe. Dave has a BA from SUNY Buffalo, a MIA from Columbia University, and a MA from the Katholieke Universiteit Leuven in Leuven, Belgium. Dave is fluent in Spanish and enjoys photography, acoustic guitar, and coaching little league baseball in his spare time.</p>', '', 'full_html'),
('node', 'page', 0, 41, 41, 'und', 0, '<p>The Electronic Retailing Association ("Company", “we” or “us”) is committed to protecting the privacy of our customer''s personal information. This statement applies with respect to the information that we collect from the Company website, located at www.retailing.org (the "Website"). Amendments to this statement will be posted at this URL and will be effective when posted. Your continued use of this site following the posting of any amendment, modification or change shall constitute your acceptance thereof.</p><h4>Information Collected</h4><p>We collect two types of information: personally identifiable information (PII) and non-personally identifiable information (Non-PII), which is also referred to as aggregate and anonymous data.</p><h4>PII.</h4><p>We do not collect any personally identifiable information about you unless you voluntarily submit such information to us, by, for example, filling out a survey or registration form. The types of information that may be requested include your name, address, e-mail address, and telephone number.</p><h4>Non-PII.</h4><p>We collect non-personally identifiable information about you in a number of ways, including tracking your activities through your IP address, computer settings or most-recently visited URL.</p><ul><li>Use of IP Addresses. We use your IP Address to help diagnose problems with our server, and to administer our Website.</li><li>Use of Cookies. When you view our Website, we might store some information on your computer. This information will be in the form of a "cookie" or similar file. Cookies are small pieces of information stored on your hard drive, not on our site. Cookies do not spy on you or otherwise invade your privacy, and they cannot invade your hard drive and steal information. Rather, they help you navigate a Website as easily as possible. We use cookies to deliver content specific to your interests and to prevent you from reentering all your registration data at each connection.</li></ul><h4>Use of Information</h4><p>PII.&nbsp;<span style="line-height: 1.538em;">In general, we will only use the information you provide to us for the purpose for which such information was provided. We may also use this information to deliver to you information about our company and promotional material from some of our partners, or to conduct trend analysis, pattern detection, and site administration. Your information may also be used to contact you when necessary. Users may opt-out of receiving future mailings from Company by following the instructions set forth in the opt-out section below. </span></p><p><span style="line-height: 1.538em;">PII. Non-personal demographic and profile data is used to tailor your experience at our site, showing you content we think you might be interested in. </span></p><h4><span style="line-height: 1.538em;">How we share your information </span></h4><p><span style="line-height: 1.538em;">Except as provided below, we do not share your PII with third parties without your permission. </span></p><ul><li><span style="line-height: 1.538em;">We may share PII about you as a customer, former customer or user of the Website to with other companies that may want to contact you with offers consistent with your stated preferences. Users may opt-out of receiving future mailings from other entities by following the instructions set forth in the opt-out section below.</span></li><li><span style="line-height: 1.538em;">We may disclose PII you provide via the Website in connection with the sale, assignment, or other transfer of the business or a portion of the business of the Website, including a corporate merger, consolidation, restructuring, sale of assets or other corporate change of our company.</span></li><li><span style="line-height: 1.538em;">We may disclose PII when required by law wherein we have a good-faith belief that such action is necessary to comply with a current judicial proceeding, a criminal investigation, a court order, or legal process served on the Website. We may also share your personal information if we believe it is necessary in order to investigate, prevent, or take action regarding illegal activities, suspected fraud, situations involving potential threats to the physical safety of any person, violations of the terms of use, or as otherwise required by law. </span></li><li><span style="line-height: 1.538em;">We also may disclose information to outside companies that help us bring you the products and services we offer or that are necessary to process the transaction your request. For example, we may work with an outside company to: (a) process credit card transactions; (b) manage a database of customer information; (c) assist us in distributing e-mails; (d) assist us with direct marketing and data collection; (e) provide us storage and analysis; (f) provide fraud prevention; and (g) other services designed to assist us in maximizing our business potential. We require that these outside companies agree to keep confidential all information we share with them and to use the information only to perform their obligations in the agreements. </span></li><li><span style="line-height: 1.538em;">In addition, we may disclose or sell your PII to third-parties with your permission. </span></li><li><span style="line-height: 1.538em;">Company may share Non-PII with business partners, sponsors and other third parties. We reserve the right to use, transfer, sell, and share aggregated, anonymous data about our users as a group for any business purpose, such as analyzing usage trends and seeking compatible advertisers and partners. </span></li></ul><h4><span style="line-height: 1.538em;">Security </span></h4><p><span style="line-height: 1.538em;">The Website has industry standard security measures in place to protect the loss, misuse and alteration of the information under our control. While there is no such thing as "perfect security" on the Internet, we will take all reasonable steps to insure the safety of your personal information. Other Websites; Links Our Website may contain links to other websites. We are not responsible for the privacy practices or the content of such websites. </span></p><h4><span style="line-height: 1.538em;">Choice; Opt Out </span></h4><p><span style="line-height: 1.538em;">You may opt-out of receiving communications from our partners, and from us, by visiting the <a href="http://www.highroadsolution.com/era_preference_center/EmailSearch.aspx" target="_blank">ERA eNewsletter Preference Center</a>. </span></p><h4><span style="line-height: 1.538em;">Miscellaneous </span></h4><p><span style="line-height: 1.538em;">The Website is operated and controlled by Company in the United States, and is intended for use only by people within the United States. We make no representations that any materials on the Website are appropriate for use outside of the United States. We also do not intend for the site to be used by children under the age of 13, nor do we seek to collect information about children under this age. If you are under the age of 13, we request that you do not provide us with any PII.</span></p>', '', 'full_html'),
('node', 'page', 0, 22, 22, 'und', 0, '<p>Below you will find instructions on how to register a group of <u><strong>FIVE</strong></u> or more. If you have any questions regarding registration please refer to the <a href="#FAQ">FAQ''s</a> below.&nbsp;<span style="line-height: 1.538em;">As a VIP service to larger companies that are attending D2C, we offer group registration if you need to register </span><strong style="line-height: 1.538em;"><u>FIVE or more employees</u></strong><span style="line-height: 1.538em;"> to the show.</span></p><p>Please fill out the <u><strong><a href="/pdfs/D2C2013_Group_WireandCheck_Reg.xlsx">group registration template</a></strong></u> and send to <a href="mailto:registration@retailing.org">registration@retailing.org</a>. We will contact you upon receipt for payment information. Please note that only <u>ONE method of payment</u> will be accepted for group registrations.</p><p><strong><span style="text-decoration: underline;">FAQ''s</span></strong><a name="FAQ"></a></p><p><strong>Q: I sent in a check for registrations, when will I receive confirmation?</strong><br><span style="line-height: 1.538em;">A: Once we receive your check we will immediately process your registrations and you will receive an email confirmation.</span></p><p><strong>Q: If I am paying by credit card and do not have a group to register, where can I register?</strong><br><span style="line-height: 1.538em;">A: Visit the </span><a href="https://s4.goeshow.com/era/d2cshow/2013/reg_form.cfm" style="line-height: 1.538em;">registration site</a><span style="line-height: 1.538em;"> and follow the steps to register.</span></p><p><strong>Q: How many methods of payment may be used for a group registration?</strong><br><span style="line-height: 1.538em;">A: Only ONE method of payment will be accepted for a group registration. If you would like to use seperate payments, you must do the registrations through the </span><a href="https://s4.goeshow.com/era/d2cshow/2013/reg_form.cfm" style="line-height: 1.538em;">registration site</a><span style="line-height: 1.538em;">.</span></p><p><strong>Q: Where should I send my registration check?</strong><br><span style="line-height: 1.538em;">A: Please send to:</span></p><p>Electronic Retailing Association<br>607 14th St. NW, Suite 530<br>Washington, DC 20005</p><p><strong>Q: I have a question about the registration process, who should I contact?</strong><br><span style="line-height: 1.538em;">A: Please contact </span><a href="mailto:registration@retailing.org" style="line-height: 1.538em;">registration@retailing.org</a><span style="line-height: 1.538em;"> and we will get back to you shortly to assist you with registration.</span></p><p>&nbsp;</p><p>&nbsp;</p>', '', 'full_html');
INSERT INTO `field_revision_body` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `body_value`, `body_summary`, `body_format`) VALUES
('node', 'register', 0, 47, 47, 'und', 0, '<br><p>Below you will find instructions on how to register a group of <u><strong>FIVE</strong></u> or more. If you have any questions regarding registration please refer to the <a href="#FAQ">FAQ''s</a> below.&nbsp;<span style="line-height: 1.538em;">As a VIP service to larger companies that are attending D2C, we offer group registration if you need to register </span><strong style="line-height: 1.538em;"><u>FIVE or more employees</u></strong><span style="line-height: 1.538em;"> to the show.</span></p><p>Please fill out the <u><strong><a href="/pdfs/D2C2013_Group_WireandCheck_Reg.xlsx">group registration template</a></strong></u> and send to <a href="mailto:registration@retailing.org">registration@retailing.org</a>. We will contact you upon receipt for payment information. Please note that only <u>ONE method of payment</u> will be accepted for group registrations.</p><p><strong><span style="text-decoration: underline;">FAQ''s</span></strong><a name="FAQ"></a></p><p><strong>Q: I sent in a check for registrations, when will I receive confirmation?</strong><br><span style="line-height: 1.538em;">A: Once we receive your check we will immediately process your registrations and you will receive an email confirmation.</span></p><p><strong>Q: If I am paying by credit card and do not have a group to register, where can I register?</strong><br><span style="line-height: 1.538em;">A: Visit the </span><a href="https://s4.goeshow.com/era/d2cshow/2013/reg_form.cfm" style="line-height: 1.538em;">registration site</a><span style="line-height: 1.538em;"> and follow the steps to register.</span></p><p><strong>Q: How many methods of payment may be used for a group registration?</strong><br><span style="line-height: 1.538em;">A: Only ONE method of payment will be accepted for a group registration. If you would like to use seperate payments, you must do the registrations through the </span><a href="https://s4.goeshow.com/era/d2cshow/2013/reg_form.cfm" style="line-height: 1.538em;">registration site</a><span style="line-height: 1.538em;">.</span></p><p><strong>Q: Where should I send my registration check?</strong><br><span style="line-height: 1.538em;">A: Please send to:</span></p><p>Electronic Retailing Association<br>607 14th St. NW, Suite 530<br>Washington, DC 20005</p><p><strong>Q: I have a question about the registration process, who should I contact?</strong><br><span style="line-height: 1.538em;">A: Please contact </span><a href="mailto:registration@retailing.org" style="line-height: 1.538em;">registration@retailing.org</a><span style="line-height: 1.538em;"> and we will get back to you shortly to assist you with registration.</span></p><p>&nbsp;</p><p>&nbsp;</p>', '', 'full_html'),
('node', 'register', 0, 46, 46, 'und', 0, '<h2>Badge Types</h2><table border="1" cellpadding="1" cellspacing="1" style="width: 625px; height: 214px;"><thead><tr><th scope="col">All Access Pass</th><th scope="col">Show Floor Only Pass</th></tr></thead><tbody><tr><td><em>Enjoy open access to all D2C activities including:</em></td><td><em>Provides limited access to D2C activities.</em></td></tr><tr><td><ul><li>Online Attendee List</li><li>Opening Reception</li><li>ALL networking events</li><li>Keynote Presentation</li><li>Meet &amp; Greet Lounge</li><li>ERA Circle Bar</li><li>All Access Pass Lounge</li><li>Free Networking Lunches on the Show Floor</li><li>Networking Breakfasts on Wed. &amp;&nbsp;&nbsp;Thurs.</li><li>Discounted show bag inserts (while supplies last)</li></ul></td><td><ul><li>Meet &amp; Greet Lounge</li><li>Keynote Presentation</li><li>ERA Circle Bar</li><li>Show Floor (including the D2C Learning Lounge)</li><li>Free Networking Lunches on the Show Floor</li></ul><p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p></td></tr></tbody></table><h2>Exhibitor/Sponsor Registration Rates</h2><table border="1" cellpadding="1" cellspacing="1" style="width: 625px;"><thead><tr><th scope="col" style="text-align: left;">Badge Type</th><th scope="col">Thru June 30</th><th scope="col">July 1 - Sept. 20</th><th scope="col">OnSite</th></tr></thead><tbody><tr><td><strong>All Access Pass</strong><br>(<span style="font-size: 0.923em; line-height: 1.538em;">Two free All Access Passes for each 100 sq. ft. of exhibit space)</span></td><td>FREE</td><td>FREE</td><td>FREE</td></tr><tr><td><p><strong>Additional All Access Pass</strong> for Exhibitors/Sponsors from the same company:</p></td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr><tr><td><p style="margin-left: 40px;">ERA Members</p></td><td>$599</td><td>$799</td><td>$999</td></tr><tr><td><p style="margin-left: 40px;">Non-Members</p></td><td>$699</td><td>$999</td><td>$1,199</td></tr><tr><td><strong>Show Floor Only Pass</strong> (Four free Show Floor Only Passes for each 100 sq. ft. of exhibit space)</td><td>FREE</td><td>FREE</td><td>FREE</td></tr><tr><td><strong>Additional Show Floor Only Pass</strong> for&nbsp;Exhibitors/Sponsors from same company:</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr><tr><td><p style="margin-left: 40px;">ERA Members</p></td><td>FREE</td><td>$149</td><td>$249</td></tr><tr><td><p style="margin-left: 40px;">Non-Members</p></td><td>$99</td><td>$199</td><td>$299</td></tr></tbody></table><h2>Moxie Awards Gala Tickets</h2><table border="1" cellpadding="1" cellspacing="1" style="width: 625px;"><thead><tr><th scope="col">&nbsp;</th><th scope="col">THRU JUNE 30</th><th scope="col">JULY 1 - SEPT. 20</th><th scope="col">ONSITE</th></tr></thead><tbody><tr><td>ERA Members</td><td>$179</td><td>$199</td><td>$249</td></tr><tr><td>Non-Members</td><td>$299</td><td>$349</td><td>$399</td></tr><tr><td>Reserved Table for Twelve</td><td>$2,149</td><td>$2,289</td><td>$2,789</td></tr></tbody></table><p>&nbsp;</p><p><strong>Already registered for D2C?</strong> Please purchase your <a href="https://s4.goeshow.com/era/d2cshow/2013/asc_welcome.cfm">Moxie tickets</a> here. Use the login info included in your confirmation email. Click on the first bullet “Moxie Awards Gala Tickets” and proceed to purchase your Moxie table or individual tickets.</p><p class="mainarticle"><a href="/content/registration-policies"><strong><span style="font-size: large;">Registration Policies</span></strong></a><br>&nbsp;</p><p class="mainarticle">&nbsp;</p>', '', 'full_html'),
('node', 'register', 0, 44, 44, 'und', 0, '<h2>Badge Types</h2><table border="1" cellpadding="1" cellspacing="1"><thead><tr><th scope="col">All Access Pass</th><th scope="col">Show Floor Only Pass</th></tr></thead><tbody><tr><td><em>Enjoy open access to all D2C activities including:</em></td><td><em>Provides limited access to D2C activities.</em></td></tr><tr><td><ul><li>Online Attendee List</li><li>Opening Reception</li><li>ALL networking events</li><li>Keynote Presentation</li><li>Meet &amp; Greet Lounge</li><li>ERA Circle Bar</li><li>All Access Pass Lounge</li><li>Free Networking Lunches on the Show Floor</li><li>Networking Breakfasts on Wed. &amp;&nbsp;&nbsp;Thurs.</li><li>Discounted show bag inserts (while supplies last)</li></ul></td><td><ul><li>Meet &amp; Greet Lounge</li><li>Keynote Presentation</li><li>ERA Circle Bar</li><li>Show Floor (including the D2C Learning Lounge)</li><li>Free Networking Lunches on the Show Floor</li></ul><p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p></td></tr></tbody></table><br><h2>Individual Registration Rates</h2><table border="1"><tbody><tr><th>Badge Type</th><th>Thru June 30</th><th>July 1 - Sept. 20</th><th>Onsite</th></tr><tr class="odd"><td>All Access Pass - ERA Members</td><td>$850</td><td>$1,129</td><td>$1,329</td></tr><tr class="even"><td>All Access Pass - Non-Members</td><td>$1,399</td><td>$1,599</td><td>$1,699</td></tr><tr class="odd"><td>Additional All Access Pass - ERA Members</td><td>$650</td><td>$929</td><td>$1,129</td></tr><tr class="even"><td>Show Floor Only Pass - ERA Members</td><td>FREE</td><td>$149</td><td>$249</td></tr><tr class="odd"><td>Show Floor Only Pass - ERA Members</td><td>$99</td><td>$199</td><td>$299</td></tr></tbody></table><br><h2>Moxie Awards Gala Tickets</h2><table border="1"><tbody><tr><th>&nbsp;</th><th>Thru June 30</th><th>July 1 - Sept. 20</th><th>Onsite</th></tr><tr class="odd"><td>ERA Members</td><td>$179</td><td>$199</td><td>$249</td></tr><tr class="even"><td>Non-Members</td><td>$299</td><td>$349</td><td>$399</td></tr><tr class="odd"><td>Reserved Table for Twelve</td><td>$2,149</td><td>$2,289</td><td>$2,789</td></tr></tbody></table><p><br><strong>Already registered for D2C?</strong> Please <a href="https://s4.goeshow.com/era/d2cshow/2013/asc_login.cfm" target="_blank">purchase your Moxie tickets</a> here. Use the login information included in your registration confirmation email. Click on the first bullet “Moxie Awards Gala Tickets” and proceed to purchase your Moxie table or individual tickets.</p><p class="mainarticle"><a href="/content/registration-policies"><strong><span style="font-size: large;">Registration Policies</span></strong></a><br>&nbsp;</p><p class="mainarticle">&nbsp;</p>', '', 'full_html'),
('node', 'page', 0, 89, 89, 'und', 0, '<h2>WYNN LAS VEGAS</h2><div>Official hotel of the ERA D2C Convention</div><div>3131 Las Vegas Boulevard South</div><div>Las Vegas, NV 89109</div><div>702-770-7100&nbsp;</div><h2><a href="https://www.completereg.com/ERA/">Resort Rooms</a></h2><div>ERA has secured specially negotiated Wynn Las Vegas and Encore Las Vegas room rates for ERA D2C Convention attendees. To secure ERA preferred rates you MUST first register for the 2013 ERA D2C Convention and then visit the <a href="https://www.completereg.com/ERA/"><strong>Housing Website</strong></a>. All reservations must be made by August 29, 2013. ERA staff are NOT responsible for securing hotel rooms.</div><ul><li>Resort Rooms (Wynn Las Vegas) for single or double occupancy: $199/night</li><li>Tower King Rooms (Wynn Las Vegas) for single or double occupancy: $249/night</li><li>Resort Rooms (Encore Las Vegas) for single or double occupancy: $219/night</li></ul><p><strong><a href="https://www.completereg.com/ERA/">Housing Website</a></strong></p><p>For questions regarding hotel reservations please contact the Housing Help Desk at <strong><a href="mailto:housing@retailing.org">housing@retailing.org</a></strong> or 703-908-1029.</p><h2><a href="mailto:keppsteiner@retailing.org">Reserve Your Suite Through ERA</a></h2><div>Conduct business meetings in the luxury and privacy of your own hospitality suite. Reserve a Parlor Suite, Salon Suite or Fairway Villa at the Wynn Las Vegas at special rates through ERA by August 29, 2013. Booking your suite through ERA is the only way to receive catering AND freight delivery to suites in the Wynn. A three night minimum stay is required. To book suites please contact Karen Eppsteiner at <a href="mailto:keppsteiner@retailing.org">keppsteiner@retailing.org</a> or 703-841-8283 for availability and rate information. Choose from:</div><ul><li>Parlor Suite - One Bedroom: $950/night member, $1,150/night non-member</li><li>Parlor Suite - Two Bedroom: $1,250/night member, $1,500/night non-member</li><li>Salon Suite - One Bedroom: $1,100/night member, $1,300/night non-member</li><li>Salon Suite - Two Bedroom: $1,400/night member, $1,700/night non-member</li><li>Fairway Villa - One Bedroom: $1,300/night member, $1,500/night non-member</li><li>Fairway Villa - Two Bedroom: $2,400/night member, $2,900/night non-member</li></ul><div>** Please contact Karen Eppsteiner at <a href="mailto:keppsteiner@retailing.org">keppsteiner@retailing.org</a> or 703-841-8283 for availability and rate information on One/Two Bedroom suites.</div><div>&nbsp;</div><div>IMPORTANT NOTICE: In the past ERA has received reports of wholesalers contacting attendees and offering "great deals" on hotels for the ERA D2C Convention. While it is not illegal for a travel firm or booking agent to solicit potential customers, it can be difficult to determine the legitimacy of offers from these organizations. Those who opt for alternatives to the ERA negotiated rates may find themselves at risk. ERA reminds its attendees that we have no affiliation with any of these room brokers. The official ERA Housing Office is CompleteReg.</div><div>&nbsp;</div><h2>Important Contact Info for the Wynn</h2><ul><li>Concierge: 702-770-7070 or 888-320-7122</li><li>Restaurant Reservations: 702-248-DINE (3463) or 888-352-DINE (3463), <a href="mailto:dining@wynnlasvegas.com">dining@wynnlasvegas.com</a></li><li>The Salon: 702-770-3900</li><li>The Spa: 702-770-3900</li><li>Wynn Golf and Country Club: 888-320-7122</li><li>Business Services Center: 702-770-2370 or 800-320-7123 x. 2370, <a href="mailto:businesscenter@wynnlasvegas.com">businesscenter@wynnlasvegas.com</a></li></ul><h2>Travel</h2><div><div>Getting to Vegas is a breeze. With over 1,000 flights arriving and departing on a daily basis, Las Vegas McCarran International Airport is easily accessible from around the world.</div><div>&nbsp;</div><h3>Getting From Las Vegas McCarran International Airport to the Wynn</h3><ul><li>Distance from the Wynn: 7.5 miles and 10-15 minutes</li><li>By Taxi: Taxi cabs are available on the east side of baggage claim, outside door exits 1-4. Please know that most taxis will not accept credit card payments and there is a $1.80 charge on all fares originating at the airport. The max number of passengers allowed in any taxi is five.</li><li>By Shuttle or Limo: A large variety of shuttle bus and limousine services and are located on the west side of baggage claim, outside door exits 7-13. Shuttles that stop at the Wynn Las Vegas run $6 or $6.50 one way and $12 or $13 for round trip service. Limousine service runs from $48/hour and up. <a href="https://www.mccarran.com/" target="_blank">View specific companies and rates that service McCarran</a>.</li><li>By Rental Car: Dedicated McCarran Rent-A-Car Center shuttles depart approximately every five minutes from exits 10 or 11 to the new McCarran Rent-A-Car Center. For information about the McCarran Rent-A-Car Center, call 702-261-6001. <a href="https://www.mccarran.com/" target="_blank">View the list of rental car companies that service McCarran</a>.</li></ul></div><p>&nbsp;</p>', '', 'full_html');

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

--
-- Table structure for table `field_revision_comment_body`
--

CREATE TABLE IF NOT EXISTS `field_revision_comment_body` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `comment_body_value` longtext,
  `comment_body_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `comment_body_format` (`comment_body_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Revision archive storage for field 1 (comment_body)';

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

--
-- Table structure for table `field_revision_field_address`
--

CREATE TABLE IF NOT EXISTS `field_revision_field_address` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_address_country` varchar(2) DEFAULT '' COMMENT 'Two letter ISO country code of this address.',
  `field_address_administrative_area` varchar(255) DEFAULT '' COMMENT 'The administrative area of this address. (i.e. State/Province)',
  `field_address_sub_administrative_area` varchar(255) DEFAULT '' COMMENT 'The sub administrative area of this address.',
  `field_address_locality` varchar(255) DEFAULT '' COMMENT 'The locality of this address. (i.e. City)',
  `field_address_dependent_locality` varchar(255) DEFAULT '' COMMENT 'The dependent locality of this address.',
  `field_address_postal_code` varchar(255) DEFAULT '' COMMENT 'The postal code of this address.',
  `field_address_thoroughfare` varchar(255) DEFAULT '' COMMENT 'The thoroughfare of this address. (i.e. Street address)',
  `field_address_premise` varchar(255) DEFAULT '' COMMENT 'The premise of this address. (i.e. Apartment / Suite number)',
  `field_address_sub_premise` varchar(255) DEFAULT '' COMMENT 'The sub_premise of this address.',
  `field_address_organisation_name` varchar(255) DEFAULT '' COMMENT 'Contents of a primary OrganisationName element in the xNL XML.',
  `field_address_name_line` varchar(255) DEFAULT '' COMMENT 'Contents of a primary NameLine element in the xNL XML.',
  `field_address_first_name` varchar(255) DEFAULT '' COMMENT 'Contents of the FirstName element of a primary PersonName element in the xNL XML.',
  `field_address_last_name` varchar(255) DEFAULT '' COMMENT 'Contents of the LastName element of a primary PersonName element in the xNL XML.',
  `field_address_data` longtext COMMENT 'Additional data for this address.',
  PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Revision archive storage for field 60 (field_address)';

--
-- Dumping data for table `field_revision_field_address`
--

INSERT INTO `field_revision_field_address` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_address_country`, `field_address_administrative_area`, `field_address_sub_administrative_area`, `field_address_locality`, `field_address_dependent_locality`, `field_address_postal_code`, `field_address_thoroughfare`, `field_address_premise`, `field_address_sub_premise`, `field_address_organisation_name`, `field_address_name_line`, `field_address_first_name`, `field_address_last_name`, `field_address_data`) VALUES
('node', 'exhibitor', 0, 60, 60, 'und', 0, 'US', 'CA', NULL, 'Simi Valley', NULL, '93063', '4195 Valley Fair Street', 'Suite 203', NULL, '', NULL, '', '', NULL),
('node', 'exhibitor', 0, 31, 31, 'und', 0, 'US', '', NULL, '', NULL, '', '', '', NULL, '', NULL, '', '', NULL),
('node', 'exhibitor', 0, 80, 80, 'und', 0, 'US', 'CA', NULL, 'Pico Rivera', NULL, '90660', '5138 Industry Ave.', '', NULL, '', NULL, '', '', NULL),
('node', 'exhibitor', 0, 59, 59, 'und', 0, 'US', '', NULL, '', NULL, '', '', '', NULL, '', NULL, '', '', NULL),
('node', 'exhibitor', 0, 56, 56, 'und', 0, 'US', '', NULL, '', NULL, '', '', '', NULL, '', NULL, '', '', NULL),
('node', 'exhibitor', 0, 57, 57, 'und', 0, 'US', '', NULL, '', NULL, '', '', '', NULL, '', NULL, '', '', NULL),
('node', 'exhibitor', 0, 58, 58, 'und', 0, 'US', '', NULL, '', NULL, '', '', '', NULL, '', NULL, '', '', NULL);

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

--
-- Table structure for table `field_revision_field_address1`
--

CREATE TABLE IF NOT EXISTS `field_revision_field_address1` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_address1_value` varchar(255) DEFAULT NULL,
  `field_address1_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_address1_format` (`field_address1_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Revision archive storage for field 26 (field_address1)';

--
-- Dumping data for table `field_revision_field_address1`
--

INSERT INTO `field_revision_field_address1` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_address1_value`, `field_address1_format`) VALUES
('node', 'sponsor', 0, 32, 32, 'und', 0, '123 Main Street', NULL);

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

--
-- Table structure for table `field_revision_field_address2`
--

CREATE TABLE IF NOT EXISTS `field_revision_field_address2` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_address2_value` varchar(255) DEFAULT NULL,
  `field_address2_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_address2_format` (`field_address2_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Revision archive storage for field 27 (field_address2)';

--
-- Dumping data for table `field_revision_field_address2`
--

INSERT INTO `field_revision_field_address2` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_address2_value`, `field_address2_format`) VALUES
('node', 'sponsor', 0, 32, 32, 'und', 0, 'Suite 444', NULL);

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

--
-- Table structure for table `field_revision_field_booth`
--

CREATE TABLE IF NOT EXISTS `field_revision_field_booth` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_booth_value` varchar(255) DEFAULT NULL,
  `field_booth_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_booth_format` (`field_booth_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Revision archive storage for field 25 (field_booth)';

--
-- Dumping data for table `field_revision_field_booth`
--

INSERT INTO `field_revision_field_booth` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_booth_value`, `field_booth_format`) VALUES
('node', 'exhibitor', 0, 31, 31, 'und', 0, '302', NULL),
('node', 'exhibitor', 0, 58, 58, 'und', 0, '308', NULL),
('node', 'exhibitor', 0, 57, 57, 'und', 0, '523', NULL),
('node', 'exhibitor', 0, 56, 56, 'und', 0, '1121', NULL),
('node', 'exhibitor', 0, 59, 59, 'und', 0, '519', NULL),
('node', 'exhibitor', 0, 60, 60, 'und', 0, '402', NULL),
('node', 'exhibitor', 0, 80, 80, 'und', 0, '317', NULL);

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

--
-- Table structure for table `field_revision_field_booth_contact`
--

CREATE TABLE IF NOT EXISTS `field_revision_field_booth_contact` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_booth_contact_value` varchar(255) DEFAULT NULL,
  `field_booth_contact_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_booth_contact_format` (`field_booth_contact_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Revision archive storage for field 36 (field_booth_contact)';

--
-- Dumping data for table `field_revision_field_booth_contact`
--

INSERT INTO `field_revision_field_booth_contact` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_booth_contact_value`, `field_booth_contact_format`) VALUES
('node', 'exhibitor', 0, 31, 31, 'und', 0, 'Dave Martin', NULL),
('node', 'exhibitor', 0, 58, 58, 'und', 0, 'Mark Chandley', NULL),
('node', 'exhibitor', 0, 57, 57, 'und', 0, 'Melissa Hiller', NULL),
('node', 'exhibitor', 0, 56, 56, 'und', 0, 'Gary Latz', NULL),
('node', 'exhibitor', 0, 59, 59, 'und', 0, 'Ross Krisel', NULL),
('node', 'exhibitor', 0, 60, 60, 'und', 0, 'Bruce Stone', NULL),
('node', 'exhibitor', 0, 80, 80, 'und', 0, 'Pamela Velarde', NULL);

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

--
-- Table structure for table `field_revision_field_booth_type`
--

CREATE TABLE IF NOT EXISTS `field_revision_field_booth_type` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_booth_type_value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_booth_type_value` (`field_booth_type_value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Revision archive storage for field 41 (field_booth_type)';

--
-- Dumping data for table `field_revision_field_booth_type`
--

INSERT INTO `field_revision_field_booth_type` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_booth_type_value`) VALUES
('node', 'exhibitor', 0, 80, 80, 'und', 0, 'Booth'),
('node', 'exhibitor', 0, 31, 31, 'und', 0, 'Booth'),
('node', 'exhibitor', 0, 59, 59, 'und', 0, 'Booth'),
('node', 'exhibitor', 0, 57, 57, 'und', 0, 'Booth'),
('node', 'exhibitor', 0, 60, 60, 'und', 0, 'Booth'),
('node', 'exhibitor', 0, 58, 58, 'und', 0, 'Booth'),
('node', 'exhibitor', 0, 56, 56, 'und', 0, 'Booth');

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

--
-- Table structure for table `field_revision_field_business_categories`
--

CREATE TABLE IF NOT EXISTS `field_revision_field_business_categories` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_business_categories_value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_business_categories_value` (`field_business_categories_value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Revision archive storage for field 48 (field_business...';

--
-- Dumping data for table `field_revision_field_business_categories`
--

INSERT INTO `field_revision_field_business_categories` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_business_categories_value`) VALUES
('node', 'exhibitor', 0, 31, 31, 'und', 0, 'Agencies'),
('node', 'exhibitor', 0, 31, 31, 'und', 1, 'Media Services');

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

--
-- Table structure for table `field_revision_field_city`
--

CREATE TABLE IF NOT EXISTS `field_revision_field_city` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_city_value` varchar(255) DEFAULT NULL,
  `field_city_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_city_format` (`field_city_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Revision archive storage for field 28 (field_city)';

--
-- Dumping data for table `field_revision_field_city`
--

INSERT INTO `field_revision_field_city` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_city_value`, `field_city_format`) VALUES
('node', 'sponsor', 0, 32, 32, 'und', 0, 'Nowhere', NULL);

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

--
-- Table structure for table `field_revision_field_corporate_suite`
--

CREATE TABLE IF NOT EXISTS `field_revision_field_corporate_suite` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_corporate_suite_value` varchar(255) DEFAULT NULL,
  `field_corporate_suite_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_corporate_suite_format` (`field_corporate_suite_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Revision archive storage for field 50 (field_corporate...';

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

--
-- Table structure for table `field_revision_field_country`
--

CREATE TABLE IF NOT EXISTS `field_revision_field_country` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_country_value` varchar(255) DEFAULT NULL,
  `field_country_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_country_format` (`field_country_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Revision archive storage for field 31 (field_country)';

--
-- Dumping data for table `field_revision_field_country`
--

INSERT INTO `field_revision_field_country` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_country_value`, `field_country_format`) VALUES
('node', 'sponsor', 0, 32, 32, 'und', 0, 'United States', NULL);

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

--
-- Table structure for table `field_revision_field_description`
--

CREATE TABLE IF NOT EXISTS `field_revision_field_description` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_description_value` longtext,
  `field_description_summary` longtext,
  `field_description_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_description_format` (`field_description_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Revision archive storage for field 37 (field_description)';

--
-- Dumping data for table `field_revision_field_description`
--

INSERT INTO `field_revision_field_description` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_description_value`, `field_description_summary`, `field_description_format`) VALUES
('node', 'exhibitor', 0, 31, 31, 'und', 0, '<p>Representing a more-than $300-billion market, the Electronic Retailing Association (ERA) is the only trade association that represents the global leaders of the direct-to-consumer marketplace—companies which use the power of direct response to sell goods and services on television, online and on radio. ERA’s members practice a sophisticated and accountable marketing methodology, leveraging video and audio to compel a direct and measurable response.</p>', '', 'full_html'),
('node', 'exhibitor', 0, 80, 80, 'und', 0, '<p>Bay Cities</p>', '', 'full_html'),
('node', 'exhibitor', 0, 59, 59, 'und', 0, '<p>Test, test, test</p>', '', 'full_html');

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

--
-- Table structure for table `field_revision_field_email`
--

CREATE TABLE IF NOT EXISTS `field_revision_field_email` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_email_value` varchar(255) DEFAULT NULL,
  `field_email_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_email_format` (`field_email_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Revision archive storage for field 33 (field_email)';

--
-- Dumping data for table `field_revision_field_email`
--

INSERT INTO `field_revision_field_email` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_email_value`, `field_email_format`) VALUES
('node', 'exhibitor', 0, 31, 31, 'und', 0, 'dmartin@retailing.org', NULL),
('node', 'exhibitor', 0, 57, 57, 'und', 0, 'dave.cook@accessdevelopment.com', NULL),
('node', 'exhibitor', 0, 56, 56, 'und', 0, 'gary@a2bf.com', NULL),
('node', 'exhibitor', 0, 58, 58, 'und', 0, 'markc@adeptivsolutions.com', NULL),
('node', 'exhibitor', 0, 59, 59, 'und', 0, 'rkrisel@advontone.com', NULL),
('node', 'exhibitor', 0, 60, 60, 'und', 0, 'bstone@apcrc.com', NULL),
('node', 'exhibitor', 0, 80, 80, 'und', 0, 'pamelav@bay-cities.com', NULL);

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

--
-- Table structure for table `field_revision_field_era_member`
--

CREATE TABLE IF NOT EXISTS `field_revision_field_era_member` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_era_member_value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_era_member_value` (`field_era_member_value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Revision archive storage for field 40 (field_era_member)';

--
-- Dumping data for table `field_revision_field_era_member`
--

INSERT INTO `field_revision_field_era_member` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_era_member_value`) VALUES
('node', 'exhibitor', 0, 31, 31, 'und', 0, 'Yes'),
('node', 'exhibitor', 0, 58, 58, 'und', 0, 'Yes'),
('node', 'exhibitor', 0, 57, 57, 'und', 0, 'No'),
('node', 'exhibitor', 0, 56, 56, 'und', 0, 'Yes'),
('node', 'exhibitor', 0, 59, 59, 'und', 0, 'Yes'),
('node', 'exhibitor', 0, 60, 60, 'und', 0, 'Yes'),
('node', 'exhibitor', 0, 80, 80, 'und', 0, 'Yes');

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

--
-- Table structure for table `field_revision_field_image`
--

CREATE TABLE IF NOT EXISTS `field_revision_field_image` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_image_fid` int(10) unsigned DEFAULT NULL COMMENT 'The file_managed.fid being referenced in this field.',
  `field_image_alt` varchar(512) DEFAULT NULL COMMENT 'Alternative image text, for the image’s ’alt’ attribute.',
  `field_image_title` varchar(1024) DEFAULT NULL COMMENT 'Image title text, for the image’s ’title’ attribute.',
  `field_image_width` int(10) unsigned DEFAULT NULL COMMENT 'The width of the image in pixels.',
  `field_image_height` int(10) unsigned DEFAULT NULL COMMENT 'The height of the image in pixels.',
  PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_image_fid` (`field_image_fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Revision archive storage for field 4 (field_image)';

--
-- Dumping data for table `field_revision_field_image`
--

INSERT INTO `field_revision_field_image` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_image_fid`, `field_image_alt`, `field_image_title`, `field_image_width`, `field_image_height`) VALUES
('node', 'mt_service', 0, 6, 6, 'und', 5, 142, '', '', 950, 633),
('node', 'mt_product', 0, 1, 1, 'und', 2, 88, '', '', 950, 340),
('node', 'mt_product', 0, 1, 1, 'und', 1, 76, '', '', 2400, 1600),
('node', 'mt_service', 0, 6, 6, 'und', 7, 144, '', '', 950, 1425),
('node', 'mt_service', 0, 6, 6, 'und', 6, 143, '', '', 950, 633),
('node', 'mt_event', 0, 83, 83, 'und', 1, 169, '', '', 600, 737),
('node', 'mt_service', 0, 6, 6, 'und', 4, 141, '', '', 950, 633),
('node', 'mt_product', 0, 1, 1, 'und', 0, 75, '', '', 2400, 1600),
('node', 'blog', 0, 12, 12, 'und', 0, 36, 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.', 600, 350),
('node', 'mt_event', 0, 83, 83, 'und', 0, 168, '', '', 600, 664),
('node', 'mt_product', 0, 2, 2, 'und', 0, 110, '', '', 1632, 1224),
('node', 'mt_service', 0, 6, 6, 'und', 3, 140, '', '', 950, 633),
('node', 'mt_service', 0, 6, 6, 'und', 2, 139, '', '', 950, 633),
('node', 'mt_service', 0, 6, 6, 'und', 1, 138, '', '', 950, 633),
('node', 'mt_service', 0, 6, 6, 'und', 0, 137, '', '', 950, 633),
('node', 'mt_service', 0, 7, 7, 'und', 0, 57, 'Unlimited Sponsorship Opportunities', '', 918, 612),
('node', 'register', 0, 47, 47, 'und', 0, 114, '', '', 500, 267),
('node', 'mt_testimonial', 0, 49, 49, 'und', 0, 116, '', '', 500, 462),
('node', 'mt_product', 0, 3, 3, 'und', 3, 119, '', '', 600, 900),
('node', 'mt_product', 0, 3, 3, 'und', 4, 120, '', '', 600, 664),
('node', 'mt_product', 0, 3, 3, 'und', 5, 121, '', '', 700, 416),
('node', 'exhibitor', 0, 31, 31, 'und', 0, 89, '', '', 150, 83),
('node', 'sponsor', 0, 32, 32, 'und', 0, 90, '', '', 150, 39),
('node', 'mt_product', 0, 3, 3, 'und', 2, 118, '', '', 600, 737),
('node', 'mt_product', 0, 3, 3, 'und', 1, 117, '', '', 600, 429),
('node', 'mt_product', 0, 3, 3, 'und', 0, 59, '', '', 3507, 2338),
('node', 'speaker', 0, 34, 34, 'und', 0, 97, '', '', 75, 102),
('node', 'register', 0, 44, 44, 'und', 0, 134, '', '', 500, 333),
('node', 'page', 0, 38, 38, 'und', 0, 106, '', '', 400, 212);

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

--
-- Table structure for table `field_revision_field_meeting_room`
--

CREATE TABLE IF NOT EXISTS `field_revision_field_meeting_room` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_meeting_room_value` varchar(255) DEFAULT NULL,
  `field_meeting_room_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_meeting_room_format` (`field_meeting_room_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Revision archive storage for field 51 (field_meeting_room)';

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

--
-- Table structure for table `field_revision_field_mt_gallery_description`
--

CREATE TABLE IF NOT EXISTS `field_revision_field_mt_gallery_description` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_mt_gallery_description_value` longtext,
  `field_mt_gallery_description_summary` longtext,
  `field_mt_gallery_description_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_mt_gallery_description_format` (`field_mt_gallery_description_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Revision archive storage for field 18 (field_mt_gallery...';

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

--
-- Table structure for table `field_revision_field_mt_gallery_image`
--

CREATE TABLE IF NOT EXISTS `field_revision_field_mt_gallery_image` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_mt_gallery_image_fid` int(10) unsigned DEFAULT NULL COMMENT 'The file_managed.fid being referenced in this field.',
  `field_mt_gallery_image_alt` varchar(512) DEFAULT NULL COMMENT 'Alternative image text, for the image’s ’alt’ attribute.',
  `field_mt_gallery_image_title` varchar(1024) DEFAULT NULL COMMENT 'Image title text, for the image’s ’title’ attribute.',
  `field_mt_gallery_image_width` int(10) unsigned DEFAULT NULL COMMENT 'The width of the image in pixels.',
  `field_mt_gallery_image_height` int(10) unsigned DEFAULT NULL COMMENT 'The height of the image in pixels.',
  PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_mt_gallery_image_fid` (`field_mt_gallery_image_fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Revision archive storage for field 17 (field_mt_gallery...';

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

--
-- Table structure for table `field_revision_field_mt_slideshow_image`
--

CREATE TABLE IF NOT EXISTS `field_revision_field_mt_slideshow_image` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_mt_slideshow_image_fid` int(10) unsigned DEFAULT NULL COMMENT 'The file_managed.fid being referenced in this field.',
  `field_mt_slideshow_image_alt` varchar(512) DEFAULT NULL COMMENT 'Alternative image text, for the image’s ’alt’ attribute.',
  `field_mt_slideshow_image_title` varchar(1024) DEFAULT NULL COMMENT 'Image title text, for the image’s ’title’ attribute.',
  `field_mt_slideshow_image_width` int(10) unsigned DEFAULT NULL COMMENT 'The width of the image in pixels.',
  `field_mt_slideshow_image_height` int(10) unsigned DEFAULT NULL COMMENT 'The height of the image in pixels.',
  PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_mt_slideshow_image_fid` (`field_mt_slideshow_image_fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Revision archive storage for field 20 (field_mt_slideshow...';

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

--
-- Table structure for table `field_revision_field_mt_slideshow_text`
--

CREATE TABLE IF NOT EXISTS `field_revision_field_mt_slideshow_text` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_mt_slideshow_text_value` longtext,
  `field_mt_slideshow_text_summary` longtext,
  `field_mt_slideshow_text_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_mt_slideshow_text_format` (`field_mt_slideshow_text_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Revision archive storage for field 21 (field_mt_slideshow...';

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

--
-- Table structure for table `field_revision_field_name`
--

CREATE TABLE IF NOT EXISTS `field_revision_field_name` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_name_value` varchar(30) DEFAULT NULL,
  `field_name_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_name_format` (`field_name_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Revision archive storage for field 22 (field_name)';

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

--
-- Table structure for table `field_revision_field_organization`
--

CREATE TABLE IF NOT EXISTS `field_revision_field_organization` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_organization_value` varchar(255) DEFAULT NULL,
  `field_organization_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_organization_format` (`field_organization_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Revision archive storage for field 46 (field_organization)';

--
-- Dumping data for table `field_revision_field_organization`
--

INSERT INTO `field_revision_field_organization` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_organization_value`, `field_organization_format`) VALUES
('node', 'speaker', 0, 34, 34, 'und', 0, 'ERA', NULL);

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

--
-- Table structure for table `field_revision_field_org_type`
--

CREATE TABLE IF NOT EXISTS `field_revision_field_org_type` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_org_type_value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_org_type_value` (`field_org_type_value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Revision archive storage for field 39 (field_org_type)';

--
-- Dumping data for table `field_revision_field_org_type`
--

INSERT INTO `field_revision_field_org_type` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_org_type_value`) VALUES
('node', 'exhibitor', 0, 31, 31, 'und', 0, 'Marketer'),
('node', 'exhibitor', 0, 58, 58, 'und', 0, 'Supplier'),
('node', 'exhibitor', 0, 57, 57, 'und', 0, 'Supplier'),
('node', 'exhibitor', 0, 56, 56, 'und', 0, 'Supplier'),
('node', 'exhibitor', 0, 59, 59, 'und', 0, 'Supplier'),
('node', 'exhibitor', 0, 60, 60, 'und', 0, 'Supplier'),
('node', 'exhibitor', 0, 80, 80, 'und', 0, 'Supplier');

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

--
-- Table structure for table `field_revision_field_phone`
--

CREATE TABLE IF NOT EXISTS `field_revision_field_phone` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_phone_value` varchar(255) DEFAULT NULL,
  `field_phone_format` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_phone_format` (`field_phone_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Revision archive storage for field 32 (field_phone)';

--
-- Dumping data for table `field_revision_field_phone`
--

INSERT INTO `field_revision_field_phone` (`entity_type`, `bundle`, `deleted`, `entity_id`, `revision_id`, `language`, `delta`, `field_phone_value`, `field_phone_format`) VALUES
('node', 'exhibitor', 0, 31, 31, 'und', 0, '703-908-1031', NULL),
('node', 'exhibitor', 0, 57, 57, 'und', 0, '800 840 0032', NULL),
('node', 'exhibitor', 0, 56, 56, 'und', 0, '866 843 3827 211', NULL),
('node', 'exhibitor', 0, 58, 58, 'und', 0, '855 233 7801', NULL),
('node', 'exhibitor', 0, 59, 59, 'und', 0, '954 671 6505', NULL),
('node', 'exhibitor', 0, 60, 60, 'und', 0, '805 526-2525', NULL),
('node', 'exhibitor', 0, 80, 80, 'und', 0, '562 948 3751', NULL);

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

--
-- Table structure for table `field_revision_field_promoted_on_slideshow`
--

CREATE TABLE IF NOT EXISTS `field_revision_field_promoted_on_slideshow` (
  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_promoted_on_slideshow_value` int(11) DEFAULT NULL,
  PRIMARY KEY (`entity_type`,`entity_id`,`revision_id`,`deleted`,`delta`,`language`),
  KEY `entity_type` (`entity_type`),
  KEY `bundle` (`bundle`),
  KEY `deleted` (`deleted`),
  KEY `entity_id` (`entity_id`),
  KEY `revision_id` (`revision_id`),
  KEY `language` (`language`),
  KEY `field_promoted_on_slideshow_value` (`field_promoted_on_slideshow_value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Revision archive storage for field 19 (field_promoted_on...';

--
