INSERT INTO `subscription_messages` (`subscription_message_id`, `message_send`, `message_subject`, `message_reply_to`, `message_text`, `message_format`, `subscription_id`, `message_type`, `message_send1`) VALUES (1, 'FLS', 'Subscription', 'shop@freeway.com', '<table style="border: 1px solid rgb(187, 187, 187);" align="center" cellpadding="20" cellspacing="0"><tbody><tr><td><table align="center" cellpadding="5" cellspacing="10" width="700"><tbody><tr><td><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td width="10"><br></td>					<td>%%Store_Logo%%</td>					<td width="10"><br></td>				</tr>			</tbody></table>			</td>		</tr>		<tr>			<td>			<table cellpadding="2" cellspacing="0" width="700">				<tbody><tr>					<td><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">Dear <b> %%First_Name%% %%Last_Name%%</b>,</font></td>				</tr>				<tr>					<td><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">Thank you for making your Subscription. The details of your order are below:</font></td></tr></tbody></table></td></tr><tr><td><table style="empty-cells: show;" border="1" cellpadding="2" cellspacing="2" width="700"><tbody><tr><td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b><font color="#000000">Order Number </font></b></font></td><td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><font color="#000000">%%Order_Number%%</font></font></td></tr><tr><td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b>Order Date</b></font></td>					<td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">%%Order_Date%%</font></td>				</tr>				<tr>					<td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b>Detailed Invoice</b></font></td>					<td align="left">						<font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><span style="font-family: Arial,Helvetica,sans-serif; font-size: 13px; text-decoration: none;">%%Detailed_Invoice_Link%%</span></font></td></tr><tr><td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b>Order Comments</b></font></td><td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">%%Order_Comments%%</font></td></tr><tr><td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><font color="#000000"><b>Billed to</b></font></font></td>					<td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><font color="#000000">%%Billed_to%%</font></font></td>				</tr>				<tr>					<td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b>Payment Method</b></font></td>					<td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">%%Payment_Method%%</font></td></tr><tr><td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b>Subtotal</b></font></td><td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">%%Sub-Total%%</font></td></tr><tr><td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b>Tax</b></font></td><td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">%%Tax_Amount%%</font></td>				</tr>				<tr>					<td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b>Total</b></font></td>					<td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">%%Total%%</font></td>				</tr>				<tr></tr>			</tbody></table></td>				</tr>		<tr height="5">			<td><br></td>		</tr>		<tr>			<td>				<table cellpadding="0" cellspacing="0" width="700"><tbody><tr><td align="left" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b>With thanks, </b></font></td></tr><tr><td style="font-family: Arial,Helvetica,sans-serif; font-size: 13px; font-weight: bold; text-decoration: none;">%%Store_Link%%</td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table>', 'H', 2, 'RCF', 0),
(2, 'FLS', 'Subscription', 'shop@freeway.com', '<table style="border: 1px solid rgb(187, 187, 187);" align="center" cellpadding="20" cellspacing="0"><tbody><tr>	<td>	<table align="center" cellpadding="5" cellspacing="10" width="700"><tbody><tr><td><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td width="10"><br></td><td>%%Store_Logo%%</td><td width="10"><br></td></tr></tbody></table></td></tr><tr><td><table cellpadding="2" cellspacing="0" width="700"><tbody><tr>					<td><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">Dear <b> %%First_Name%% %%Last_Name%%</b>,</font></td>				</tr>				<tr>					<td><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">Thank you for making your Subscription. The details of your order are below:</font></td>				</tr>			</tbody></table>			</td>		</tr>		<tr>			<td>				 <table style="empty-cells: show;" border="1" cellpadding="2" cellspacing="2" width="700">				<tbody><tr>	<td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b><font color="#000000">Order Number </font></b></font></td><td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><font color="#000000">%%Order_Number%%</font></font></td></tr><tr>					<td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b>Order Date</b></font></td>					<td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">%%Order_Date%%</font></td>				</tr>				<tr>					<td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b>Detailed Invoice</b></font></td>					<td align="left">						<font color="#000000" face="Arial, Helvetica, sans-serif" size="2">							<span style="font-family: Arial,Helvetica,sans-serif; font-size: 13px; text-decoration: none;">%%Detailed_Invoice_Link%%</span>						</font>					</td>	</tr><tr><td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b>Order Comments</b></font></td><td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">%%Order_Comments%%</font></td></tr><tr><td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><font color="#000000"><b>Billed to</b></font></font></td><td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><font color="#000000">%%Billed_to%%</font></font></td>				</tr>				<tr>					<td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b>Payment Method</b></font></td>					<td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">%%Payment_Method%%</font></td>				</tr>				<tr>					<td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b>Subtotal</b></font></td><td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">%%Sub-Total%%</font></td></tr><tr><td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b>Tax</b></font></td><td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">%%Tax_Amount%%</font></td></tr><tr><td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b>Total</b></font></td>					<td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">%%Total%%</font></td>				</tr>				<tr></tr>			</tbody></table></td>				</tr>		<tr height="5">			<td><br></td>		</tr>		<tr>			<td>				<table cellpadding="0" cellspacing="0" width="700">					<tbody><tr>						<td align="left" valign="top">						<font color="#000000" face="Arial, Helvetica, sans-serif" size="2">							<b>With thanks, </b>						</font>						</td></tr><tr><td style="font-family: Arial,Helvetica,sans-serif; font-size: 13px; font-weight: bold; text-decoration: none;">%%Store_Link%%</td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table>', 'H', 3, 'RCF', 0),
(3, 'FLS', 'Subscription', 'shop@freeway.com', '<table style="border: 1px solid rgb(187, 187, 187);" align="center" cellpadding="20" cellspacing="0"><tbody><tr><td><table align="center" cellpadding="5" cellspacing="10" width="700"><tbody><tr><td><table border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td width="10"><br></td><td>%%Store_Logo%%</td><td width="10"><br></td></tr></tbody></table></td></tr><tr><td><table cellpadding="2" cellspacing="0" width="700">				<tbody><tr>					<td><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">Dear <b> %%First_Name%% %%Last_Name%%</b>,</font></td>				</tr>				<tr>					<td><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">Thank you for making your Subscription. The details of your order are below:</font></td>				</tr>			</tbody></table>			</td>		</tr>		<tr>			<td>				 <table style="empty-cells: show;" border="1" cellpadding="2" cellspacing="2" width="700">				<tbody><tr>	<td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b><font color="#000000">Order Number </font></b></font></td><td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><font color="#000000">%%Order_Number%%</font></font></td></tr><tr><td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b>Order Date</b></font></td><td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">%%Order_Date%%</font></td>				</tr>				<tr>					<td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b>Detailed Invoice</b></font></td>					<td align="left">						<font color="#000000" face="Arial, Helvetica, sans-serif" size="2">							<span style="font-family: Arial,Helvetica,sans-serif; font-size: 13px; text-decoration: none;">%%Detailed_Invoice_Link%%</span>						</font>					</td>	</tr><tr><td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b>Order Comments</b></font></td><td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">%%Order_Comments%%</font></td></tr><tr><td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><font color="#000000"><b>Billed to</b></font></font></td><td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><font color="#000000">%%Billed_to%%</font></font></td>				</tr>				<tr>					<td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b>Payment Method</b></font></td>					<td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">%%Payment_Method%%</font></td>				</tr>				<tr>					<td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b>Subtotal</b></font></td><td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">%%Sub-Total%%</font></td></tr><tr><td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b>Tax</b></font></td><td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">%%Tax_Amount%%</font></td></tr><tr><td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b>Total</b></font></td>					<td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">%%Total%%</font></td>				</tr>				<tr></tr>			</tbody></table></td>				</tr>		<tr height="5">			<td><br></td>		</tr>		<tr>			<td>				<table cellpadding="0" cellspacing="0" width="700">					<tbody><tr>						<td align="left" valign="top">						<font color="#000000" face="Arial, Helvetica, sans-serif" size="2">							<b>With thanks, </b>						</font>						</td></tr><tr><td style="font-family: Arial,Helvetica,sans-serif; font-size: 13px; font-weight: bold; text-decoration: none;">%%Store_Link%%</td></tr></tbody></table></td></tr></tbody></table>	</td></tr></tbody></table>', 'H', 4, 'RCF', 0);

INSERT INTO `services_messages` (`services_message_id`, `message_send`, `message_subject`, `message_reply_to`, `message_text`, `message_format`, `service_id`, `message_type`, `message_send1`) VALUES (1, '0', 'Service', 'shop@freeway.com', '<table style="border: 1px solid rgb(187, 187, 187);" align="center" cellpadding="20" cellspacing="0"><tbody><tr><td><table align="center" cellpadding="5" cellspacing="10" width="700">		<tbody><tr>			<td>			<table border="0" cellpadding="0" cellspacing="0" width="100%">				<tbody><tr>					<td width="10"><br></td>					<td>%%Store_Logo%%</td>					<td width="10"><br></td>				</tr>			</tbody></table>			</td>		</tr>		<tr>			<td>			<table cellpadding="2" cellspacing="0" width="700">				<tbody><tr>					<td><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">Dear <b> %%First_Name%% %%Last_Name%%</b>,</font></td>				</tr>				<tr>					<td><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">Thank you for making your Service. The details of your order are below:</font></td></tr></tbody></table></td></tr><tr><td><table style="empty-cells: show;" border="1" cellpadding="2" cellspacing="2" width="700"><tbody><tr><td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b><font color="#000000">Order Number </font></b></font></td><td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><font color="#000000">%%Order_Number%%</font></font></td>				</tr>				<tr>					<td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b>Order Date</b></font></td>					<td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">%%Order_Date%%</font></td>				</tr>				<tr>					<td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b>Detailed Invoice</b></font></td>					<td align="left">						<font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><span style="font-family: Arial,Helvetica,sans-serif; font-size: 13px; text-decoration: none;">%%Detailed_Invoice_Link%%</span></font></td></tr><tr><td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b>Order Comments</b></font></td><td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">%%Order_Comments%%</font></td>				</tr>				<tr>					<td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><font color="#000000"><b>Billed to</b></font></font></td>					<td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><font color="#000000">%%Billed_to%%</font></font></td>				</tr>				<tr>					<td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b>Payment Method</b></font></td>					<td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">%%Payment_Method%%</font></td></tr><tr><td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b>Subtotal</b></font></td><td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">%%Sub-Total%%</font></td></tr><tr><td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b>Tax</b></font></td>					<td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">%%Tax_Amount%%</font></td>				</tr>				<tr>					<td align="left" nowrap="nowrap" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b>Total</b></font></td>					<td align="left"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2">%%Total%%</font></td>				</tr>				<tr></tr>			</tbody></table></td>				</tr>		<tr height="5">			<td><br></td>		</tr>		<tr>			<td>				<table cellpadding="0" cellspacing="0" width="700">					<tbody><tr>						<td align="left" valign="top"><font color="#000000" face="Arial, Helvetica, sans-serif" size="2"><b>With thanks, </b></font></td></tr><tr><td style="font-family: Arial,Helvetica,sans-serif; font-size: 13px; font-weight: bold; text-decoration: none;">%%Store_Link%%</td>					</tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table>', 'H', 1, 'RCF', '0');

INSERT INTO `admin_files` ( `admin_files_name`, `admin_files_is_boxes`, `admin_files_to_boxes`, `admin_groups_id`, `admin_files_type`, `admin_files_help_id`, `admin_new_group_id`) VALUES ('version_upgrade.php', 0, 0, '1', 'D', 'D', NULL);

INSERT into sql_queries values('freeway_v1_4_3.sql',now());