# ************************************************************
# Sequel Pro SQL dump
# Version 4096
#
# http://www.sequelpro.com/
# http://code.google.com/p/sequel-pro/
#
# Host: 127.0.0.1 (MySQL 5.5.33)
# Database: everwondr2
# Generation Time: 2014-01-21 12:34:46 +0000
# ************************************************************


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


# Dump of table partner_comm_tmpl
# ------------------------------------------------------------

DROP TABLE IF EXISTS `partner_comm_tmpl`;

CREATE TABLE `partner_comm_tmpl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(512) NOT NULL DEFAULT '',
  `subject` varchar(1024) NOT NULL DEFAULT '',
  `content` text NOT NULL,
  `url_title` varchar(215) NOT NULL DEFAULT '',
  `attachment_url_title` varchar(215) NOT NULL DEFAULT '',
  `type` enum('email','doc') DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

LOCK TABLES `partner_comm_tmpl` WRITE;
/*!40000 ALTER TABLE `partner_comm_tmpl` DISABLE KEYS */;

INSERT INTO `partner_comm_tmpl` (`id`, `name`, `subject`, `content`, `url_title`, `attachment_url_title`, `type`)
VALUES
	(1,'Everwondr Tech Email','EverWondr API Integration','<h2 style=\"{{ style.h2 }}\">EverWondr API Integration</h2>\n\n<p style=\"{{ style.p }}\">\n{{ partner.tech_contact }},<br/><br/>\n\nMy name is {{ current_user.full_name }}. My company, Everwondr, helps connect and network event calendars. {{ partner.user().full_name }} suggested I reach out to you to help get {{ partner.venue().name }} integrated on our network.\n</p>\n\n<br/><hr style=\"{{ style.hr }}\" /><br/>\n<p style=\"{{ style.p }}\">\n{% if event_frame_enabled %}\n<b style=\"{{ style.blocked_b }}\"><i>Event Frame:</i></b>\n{{ partner.user().full_name }} has chosen to set up an Event Frame API. The process to integrate should take no more than 30 minutes. Below is a link to the instructions, an API key and code to get you started. <br/><br/>\n\n<b>Example:</b> \n<a target=\"_blank\" href=\"http://visitncevents.com/events/frame_test/{{ event_frame.api_key }}\">http://visitncevents.com/events/frame_test/{{ event_frame.api_key }}</a><br/>\n<b>Instructions:</b> \n<a target=\"_blank\" href=\"http://visitncevents.com/p/api_setup/{{ event_frame.data_sub_type }}/{{ event_frame.api_key }}\">http://visitncevents.com/p/api_setup/{{ event_frame.data_sub_type }}/{{ event_frame.api_key }}</a><br/>\n<b>Key:</b> {{ event_frame.api_key }}\n<br/><br/><br/>\n{% endif %}\n\n{% if visit_frame_enabled %}\n\n<b style=\"{{ style.blocked_b }}\"><i>Visit Frame:</i></b>\n{{ partner.user().full_name }} has chosen to set up a Plan Your Visit Frame API. The process to integrate should take no more than 30 minutes. Below is a link to the instructions, an API key and code to get you started.  <br/><br/>\n\n<b>Example:</b> \n<a target=\"_blank\" href=\"http://visitncevents.com/visit/frame_test/{{ visit_frame.api_key }}\">http://visitncevents.com/visit/frame_test/{{ visit_frame.api_key }}</a><br/>\n<b>Instructions:</b>\n<a target=\"_blank\" href=\"http://visitncevents.com/p/api_setup/{{ visit_frame.data_sub_type }}/{{ visit_frame.api_key }}\">http://visitncevents.com/p/api_setup/{{ visit_frame.data_sub_type }}/{{ visit_frame.api_key }}</a>\n<br/>\n<b>Key:</b> {{ visit_frame.api_key }}\n<br/><br/><br/>\n{% endif %}\n\n{% if event_widget_enabled %}\n\n<b style=\"{{ style.blocked_b }}\"><i>Event Widget:</i></b>\n{{ partner.user().full_name }} has chosen to set up an Event Widget. The process to integrate should take no more than 30 minutes. Below is a link to the instructions, an API key and code to get you started.  <br/><br/>\n\n<b>Example:</b> \n<a target=\"_blank\" href=\"http://visitncevents.com/events/widget_test/{{ event_widget.api_key }}\">http://visitncevents.com/events/widget_test/{{ event_widget.api_key }}</a><br/>\n<b>Instructions:</b>\n<a target=\"_blank\" href=\"http://visitncevents.com/p/api_setup/{{ event_widget.data_sub_type }}/{{ event_widget.api_key }}\">http://visitncevents.com/p/api_setup/{{ event_widget.data_sub_type }}/{{ event_widget.api_key }}</a>\n<br/>\n<b>Key:</b> {{ event_widget.api_key }}\n<br/><br/><br/>\n{% endif %}\nThanks, <br/>\n{{ current_user.full_name }}<br/>\n<i>The EverWondr Network</i>\n</p>\n','tech-email','','email'),
	(2,'EverWondr Agreement','','<div class=\"poh-banner\"></div>\n<hr/>\n<p class=\"align-right\">Letter Of Agreement</p>\n<table class=\"memo-table\">\n	<tr>\n		<td>Date:</td>\n		<td>{{ date }}</td>\n	</tr>\n	<tr>\n		<td>Client:</td>\n		<td>\n			{{ partner.full_name | auto_br }}\n			{{ partner.title | auto_br }}\n			{{ partner.venue.name }} (hereinafter \"Client\") <br/>\n			{{ partner.venue.address_1 | auto_br }}\n			{{ partner.venue.address_2 | auto_br }}\n			{{ partner.venue.city }}, {{ partner.venue.state }} {{ partner.venue.zip }}\n		</td>\n	<tr>\n	<tr>\n		<td>Company:</td>	\n		<td>\n			Pursuit of Happiness, LLC (hereinafter \"Company\")<br/>\n			1000 Revolution Mill Drive, Suite 2<br/>\n			Greensboro, NC  27405<br/>\n			336.643.0387<br/>\n		</td>\n	</tr>\n	<tr>\n		<td>RE:</td>\n		<td>{{ partner.venue.name }} {{ agreement_type }}</td>\n	</tr>\n</table>\n\n<p>\nCompany hereby agrees to provide access to the EverWondr Events Network to the Client in accordance with and subject to the following terms and conditions.\n</p>\n<ol>\n	<li>	\n		NETWORK SERVICES\n		<ol>\n			<li>Company will provide server and support for event frame</li>\n			<li>Company will supply an admin tool for uploading, revising and tracking events, and listing venues.</li>\n			<li>Admin access to the URL in question, including passwords and any or all read/write/upload/download privileges to the admin tool, are not transferrable, and may not be shared with any other party or organization.</li>\n			<li>Company will hold two training sessions for attraction, venues and artists at initial launch. Additional training will be charged at a rate of $85/hour, including travel.</li>\n		</ol>\n	</li>\n	<li>\n		GENERAL PROVISIONS\n		<ol>\n			<li>\n				<u class=\"blocked\">Exclusive Arrangement</u>\n				Client agrees not to engage the services of any other events calendar Network during the term of this agreement without first obtaining the written consent of Company.\n			</li>\n			<li>\n				<u class=\"blocked\">Agent Relationship</u>\n				Company is authorized to act as Client?s agent in purchasing the materials and services required to host the site activities on behalf of Client.  \n			</li>\n			<li>\n				<u class=\"blocked\">Cancellation of Plans</u>\n				Client reserves the right, in its sole discretion, to modify, reject, cancel or stop any and all plans, schedules or work in process to launch the site; and in such event Company shall immediately take proper steps to carry out Client?s instructions; but Client agrees to reimburse Company for any direct losses Company may sustain derived from such modification, rejection, cancellation or stoppage ordered by client provided such modification, rejection, cancellation or stoppage was not the result of negligence or misconduct by Company. Client shall reimburse Company for all expenses incurred in connection with Client marketing communications previously authorized by Client, and to pay Company any service charges relating thereto, in accordance with the provisions of this Agreement.\n			</li>\n			<li>\n				<u class=\"blocked\">Failure of Suppliers to Perform</u>\n				Company will endeavor to the best of its knowledge and ability to guard against any loss to Client through failure of suppliers to properly execute their commitment, but we shall not be held responsible for any failure on their part.\n			</li>\n			<li>\n				<u class=\"blocked\">Indemnification of Network and Client</u>\n				Company agrees to exercise its best judgment in the preparation and execution of all activities for Client, with a view to avoiding any claims, proceedings, or suits being made or instituted against Client or Company. Company shall defend, indemnify, and hold Client, its officers, employees and agents harmless from and against any and all liability, loss, expense, including reasonable attorneys? fees, or claims for injury or damages arising out of the performance of the Agreement but only in proportion to and to the extent such liability, loss, expense, attorneys? fees, or claims for injury or damages are caused by or result from the negligent or intentional acts or omission of Company, its officers, agents or employees. Client shall defend, indemnify, and hold Company, its officers, employees, and agents harmless from and against any and all liability, loss, expense, including reasonable attorneys? fees, or claims for injury or damages arising out of the performance of this Agreement but only in proportion to and to the extent such liability, loss, expense, attorneys? fees, or claims for injury or damages are caused by or result from the negligent or intentional acts or omissions of Client, its officers, agents or employees.\n			</li>\n			<li>\n				<u class=\"blocked\">Client Partnership</u>\n				<ol>\n					<li>Client will supply a direct link to the EverWondr Events Calendar from the main navigation of their current site. (Event / Event Calendar)</li>\n					<li>Client agrees to set up training session with local attractions and venues.</li>\n				</ol>\n			</li>\n		</ol>\n	</li>\n	<li>\n		TERMS OF AGREEMENT\n		<p>\n			This agreement is for maintenance, administrative access and server fees for the template site/calendar for {{ partner.venue.name }}\n		</p>\n		<p>\n			This agreement shall begin on {{ partner.start_date | date(\"m/d/Y\") }} and shall continue in effect until {{ partner.end_date | date(\"m/d/Y\")  }}. Termination by either party may be for convenience. Termination by Client requires at least ninety (90) days written notice and full payment of remainder of contract. In the event of termination for convenience by client, client shall compensate Company for all direct costs incurred pursuant to this Agreement by Company. In the event of termination for convenience by Pursuit of Happiness, Pursuit of Happiness shall pay client back for any excess payments on a pro-rated basis. \n		</p>\n	</li>\n	<li>\n		PURSUIT OF HAPPINESS COMPENSATION\n		<p>\n			Company will provide an event upload, server support and maintenance for a fee of \n			${{ partner.cost_year + partner.cost_year_socialwondr }} per year for a period of {{ agreement_term }} years.\n		</p>\n	</li>\n	<li>\n		MISCELLANEOUS\n		<ol>\n			<li>\n				<u class=\"blocked\">Relationship of Parties.</u>\n				Company is an independent contractor of the Client. Neither Company nor any employee of the Company shall be deemed an officer, employee or agent of the Client. Company\'s personnel shall not be employees of, or have any contractual relationship with the Client.\n			</li>\n			<li>\n				<u class=\"blocked\">Limitation and Assignment.</u>\n				The Client and the Company each bind themselves, their successors, assigns and legal representatives to the terms of this Agreement. Neither the Company nor the Client shall assign or transfer its interest in this Agreement without the written consent of the other. \n			</li>\n			<li>\n				<u class=\"blocked\">Governing Law.</u>\n				This Agreement and the duties, responsibilities, obligations and rights of respective parties hereunder shall be governed by the laws of the State of North Carolina.\n			</li>\n			<li>\n				<u class=\"blocked\">Entire Agreement.</u>\n				This Agreement represents the entire and integrated agreement between the Client and the Company and supersedes all prior negotiations, representations or agreements, either written or oral.  This Agreement may be amended only by written instrument signed by both parties. \n			</li>\n			<li>\n				<u class=\"blocked\">Severability.</u>\n				If any provision of this Agreement is held as a matter of law to be unenforceable, the remainder of this Agreement shall be valid and binding upon the Parties. Any partner deemed to have caused negative impact to the EverWondr Network via direct or indirect actions, is subject to immediate removal. They will forfeit service and remain liable for full payment of the rest of their contract.\n			</li>\n			<li>\n				<u class=\"blocked\">Limitation and Assignment.</u>\n				The Client and the Company each bind themselves, their successors, assigns and legal representatives to the terms of this Agreement. Neither the Company nor the Client shall assign or transfer its interest in this Agreement without the written consent of the other. \n			</li>\n		</ol>\n	</li>\n	<li>\n		BILLING\n		<p>All fees to launch the site, host and maintain for the first year are due at the beginning of the contract. Annual server, maintenance and admin access fees will be billed to Client on the yearly anniversary of the launch date with payment due upon receipt. Payment is expected in full.</p>\n		<table class=\"mini-table\">\n			<tr>\n				<td>Payment Due</td>\n				<td>Amount</td>\n			</tr>\n			{% for payment in payments %}\n			<tr>\n				<td>{{ payment | date(\'m/d/Y\') }}</td>\n				<td>${{ partner.cost_year }}</td>\n			</tr>\n			{% endfor %}\n		</table>\n		{% if partner.cost_year_socialwondr > 0 %}\n		<p>SocialWondr Suite</p>\n		<p>\n			<b>WondrMail:</b><br/>\n			6 email pushes/year for WondrMail, additional pushes can be purchased for $65/each\n		</p>\n		<p>\n			<b>WondrList:</b><br/>\n			Unlimited access to flyer creation tool\n		</p>\n		<p>\n			<b>WondrWire:</b><br/>\n			Unlimited access to reverse publishing feature\n		</p>\n		<table class=\"mini-table\">\n			<tr>\n				<td>Payment Due</td>\n				<td>Amount</td>\n			</tr>\n			{% for payment in payments %}\n			<tr>\n				<td>{{ payment | date(\'m/d/Y\') }}</td>\n				<td>${{ partner.cost_year_socialwondr }}</td>\n			</tr>\n			{% endfor %}\n		</table>\n		{% endif %}\n		<ol>\n			<li>\n				<u class=\"blocked\">Agreement to Pay</u>\n				Client agrees to pay properly submitted Company invoices within 30 days of receipt.\n			</li>\n			<li>\n				<u class=\"blocked\">Overdue Accounts</u>\n				All past due accounts are subject to a late charge of 1-1/2% per month after 45 days from the original invoice date. After that date the account will be suspended and the site turned off until payment is made.\n			</li>\n			<li>\n				<u class=\"blocked\">Files/Records</u>\n				All databases, files and records are the property of Company and can be accessed only through written permission of Company.\n			</li>\n		</ol>\n	</li>\n</ol>\n\n<p>\n	Agreed and Accepted:<br/>\n	Pursuit Of Happiness, LLC\n</p>\n\n','ew-agreement','','doc'),
	(3,'EverWondr Invoice','','<div class=\"poh-banner\"></div>\n<hr/>\n<p class=\"align-right\">Invoice {{ invoice_number }}</p>\n<table class=\"memo-table\">\n	<tr>\n		<td>Date:</td>\n		<td>{{ date }}</td>\n	</tr>\n	<tr>\n		<td>Client:</td>\n		<td>\n			{{ partner.full_name | auto_br }}\n			{{ partner.title | auto_br }}\n			{{ partner.venue.name }} (hereinafter \"Client\") <br/>\n			{{ partner.venue.address_1 | auto_br }}\n			{{ partner.venue.address_2 | auto_br }}\n			{{ partner.venue.city }}, {{ partner.venue.state }} {{ partner.venue.zip }}\n		</td>\n	<tr>\n	<tr>\n		<td>Company:</td>	\n		<td>\n			Pursuit of Happiness, LLC (hereinafter \"Company\")<br/>\n			1000 Revolution Mill Drive, Suite 2<br/>\n			Greensboro, NC  27405<br/>\n			336.643.0387<br/>\n		</td>\n	</tr>\n	<tr>\n		<td>RE:</td>\n		<td>{{ partner.venue.name }} {{ agreement_type }} for Everwondr</td>\n	</tr>\n	<tr>\n		<td>EIN #:</td>\n		<td> {{ ein_number }}</td>\n	</tr>\n</table>\n\n<div class=\"left-padded-content\">\n<p>\nThis invoice is for FULL PAYMENT of the EverWondr Network Events Calendar for {{ invoice.start_date | date(\'F Y\') }} through {{ invoice.end_date | date(\'F Y\') }}. This is the {{ payment.count }} payment of a {{ agreement_term}}-year agreement. \n</p>\n\n<br/>\n<table class=\"mini-table ex-padding\">\n	{% if partner.cost_year_socialwondr %}\n	<tr>\n		<td>{{ invoice.start_date | date(\'F Y\') }}</td>\n		<td>${{ partner.cost_year_socialwondr }} / year for SocialWondr Suite</td>\n	</tr>\n	{% endif %}\n	{% if partner.cost_year > 0 %}\n	<tr>\n		<td>{{ invoice.start_date | date(\'F Y\') }}</td>\n		<td> ${{ partner.cost_year }} / year for {{ agreement_type }}</td>\n	</tr>\n	{% endif %}\n</table>\n<br/>\n<br/>\n<b class=\"total all-caps\">Total Due: ${{ partner.cost_year + partner.cost_year_socialwondr }}</b><br/>\n<span class=\"net-due\">Net due in 25 days, 15% increase on past due amounts</span>\n</div>','ew-invoice','','doc'),
	(5,'Everwondr Welcome Email','Welcome To EverWondr','<h2 style=\"{{ style.h2 }}\">Welcome To EverWondr</h2>\n\n<p style=\"{{ style.p }}\">The process has begun to bring your site into the EverWondr Network.</p>\n\n<p style=\"{{ style.p__left_padded_p }}\">\n	<b style=\"{{ style.all-caps }}\">What has been done:</b><br/>\n	 - Client Registered<br/>\n	{% if event_frame_enabled %}\n	- Event frame has been generated<br/>\n	{% endif %}\n	{% if visit_frame_enabled %}\n	- Plan Your Visit frame has been generated<br/>\n	{% endif %}\n	{% if event_widget_enabled %}\n	- Widget feed has been generated<br/>\n	{% endif %}\n	{% if event_api_enabled %}\n	- Data feed has been generated<br/>\n	{% endif %}\n	{% if event_frame_enabled or visit_frame_enabled or event_widget_enabled or event_api_enabled %}\n	- All code and keys sent to tech contact<br/>\n	{% endif %}\r\n</p>\n\n<p style=\"{{ style.p }}\">\n	This email will link you to your Partner Dashboard where you can monitor the progress of your integration and review a list of items we need to complete the process.\n</p>\n\n<p style=\"{{ style.p }}\">\nIf you should need anything during this period, feel free to contact us directly at <a style=\"{{ style.a }}\" href=\"mailto:help@everwondr.com\">help@everwondr.com</a>. \n</p>\n\n<p style=\"{{ style.p }}\">\n<b>Dashboard: </b><a href=\"http://everwondr.com/admin\">everwondr.com/admin</a><br/>\n<b>Email: </b>{{ partner.user().email }}<br/>\n<b>Password<sup>*</sup>: </b>{{ partner.temporary_password }}\n</p>\n\n<p style=\"{{ style.p }}\">\n<sup>*</sup> Your password can be changed at any time by clicking on the account icon after signing in.\n</p>','ew-welcome-email','','email'),
	(8,'Everwondr Invoice Email','Invoice From Everwondr','<h2 style=\"{{ style.h2 }}\">Everwondr Invoice Email</h2>\n\n{{ tech_contact }},<br/><br/>\n\nMy name is {{ user_full_name }}. My company, Everwondr, helps connect and network event calendars. {{ partner_full_name }} suggested I reach out to you to help get {{ venue_name }} integrated on our network.<br/><br/>\n\n<hr/>\n\n{% if event_frame_include %}\n<br/><br/>\n<b><i>Event Frame:</i></b>\n{{ partner_full_name }} has chosen to set up an Event Frame API. The process to integrate should take no more than 30 minutes. Below is a link to the instructions, an API key and code to get you started. <br/><br/>\n\n<b>Example:</b> http://visitncevents.com/events/frame_test/{{ event_frame_api_key }}<br/>\n<b>Instructions:</b> {{ event_frame_instruction_url }}<br/>\n<b>Key:</b> {{ event_frame_api_key }}\n{% endif %}\n\n{% if visit_frame_include %}\n<br/><br/>\n<b><i>Visit Frame:</i></b>\n{{ partner_full_name }} has chosen to set up a Plan Your Visit Frame API. The process to integrate should take no more than 30 minutes. Below is a link to the instructions, an API key and code to get you started.  <br/><br/>\n\n<b>Example:</b> http://visitncevents.com/visit/frame_test/{{ visit_frame_api_key }}<br/>\n<b>Instructions:</b> {{ visit_frame_instruction_url }}<br/>\n<b>Key:</b> {{ visit_frame_api_key }}\n{% endif %}\n\n\n','ew-invoice-email','ew-invoice','email');

/*!40000 ALTER TABLE `partner_comm_tmpl` ENABLE KEYS */;
UNLOCK TABLES;



/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
