Thank you for your support. Your contribution will help us build even better tools.

Thank you for your support. Your participation will help save thousands of acres of rainforest.

Thank you for your support. Your contribution will help us build even better tools.

Thank you for your support. Your participation will help save thousands of acres of rainforest.

{ts}Item{/ts}

{ts}Qty{/ts}

{ts}Each{/ts}

{ts}Subtotal{/ts}

{ts}Tax Rate{/ts}

{ts}Tax Amount{/ts}

{ts}Total{/ts}

\n {if $line.html_type eq \'Text\'}{$line.label}{else}{$line.field_title} - {$line.label}{/if} {if $line.description}

{$line.description|truncate:30:\"...\"}

{/if}\n

\n {$line.qty}\n

\n {$line.unit_price|crmMoney:$currency}\n

\n {$line.unit_price*$line.qty|crmMoney:$currency}\n

\n {$line.tax_rate|string_format:\"%.2f\"}%\n

\n {$line.tax_amount|crmMoney:$currency}\n

\n {$line.line_total+$line.tax_amount|crmMoney:$currency}\n

{ts}Item{/ts}

{ts}Qty{/ts}

{ts}Each{/ts}

{ts}Subtotal{/ts}

{ts}Tax Rate{/ts}

{ts}Tax Amount{/ts}

{ts}Total{/ts}

\n {if $line.html_type eq \'Text\'}{$line.label}{else}{$line.field_title} - {$line.label}{/if} {if $line.description}

{$line.description|truncate:30:\"...\"}

{/if}\n

\n {$line.qty}\n

\n {$line.unit_price|crmMoney:$currency}\n

\n {$line.unit_price*$line.qty|crmMoney:$currency}\n

\n {$line.tax_rate|string_format:\"%.2f\"}%\n

\n {$line.tax_amount|crmMoney:$currency}\n

\n {$line.line_total+$line.tax_amount|crmMoney:$currency}\n

{ts}Item{/ts}

{ts}Qty{/ts}

{ts}Each{/ts}

{ts}Subtotal{/ts}

{ts}Tax Rate{/ts}

{ts}Tax Amount{/ts}

{ts}Total{/ts}

\n {if $line.html_type eq \'Text\'}{$line.label}{else}{$line.field_title} - {$line.label}{/if} {if $line.description}

{$line.description|truncate:30:\"...\"}

{/if}\n

\n {$line.qty}\n

\n {$line.unit_price|crmMoney:$currency}\n

\n {$line.unit_price*$line.qty|crmMoney:$currency}\n

\n {$line.tax_rate|string_format:\"%.2f\"}%\n

\n {$line.tax_amount|crmMoney:$currency}\n

\n {$line.line_total+$line.tax_amount|crmMoney:$currency}\n

\n {if $config->empoweredBy}\n \n \n \n \n

\n {/if}\n \n \n \n \n \n \n \n {if $organization_name}\n \n {else}\n \n {/if}\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

{ts}INVOICE{/ts}	{ts}Invoice Date:{/ts}	{$domain_organization}
{contact.display_name} ({$organization_name})	{contact.display_name}	{$invoice_date}	\n \n {if $domain_street_address }{$domain_street_address}{/if}\n {if $domain_supplemental_address_1 }{$domain_supplemental_address_1}{/if}\n \n
{$street_address} {$supplemental_address_1}	{ts}Invoice Number:{/ts}	\n \n {if $domain_supplemental_address_2 }{$domain_supplemental_address_2}{/if}\n {if $domain_state }{$domain_state}{/if}\n \n
{$supplemental_address_2} {$stateProvinceAbbreviation}	{$invoice_number}	\n \n {if $domain_city}{$domain_city}{/if}\n {if $domain_postal_code }{$domain_postal_code}{/if}\n \n
{$city} {$postal_code}	{ts}Reference:{/ts}	{if $domain_country}{$domain_country}{/if}
{$country}	{if !empty($source)}{$source}{/if}	{if $domain_email}{$domain_email}{/if}
		{if $domain_phone}{$domain_phone}{/if}

\n\n \n \n \n \n \n \n \n \n {foreach from=$lineItem item=value key=priceset name=taxpricevalue}\n {if $smarty.foreach.taxpricevalue.index eq 0}\n {else}\n {/if}\n \n \n \n \n {if $value.tax_amount != \'\'}\n \n {else}\n \n {/if}\n \n \n {/foreach}\n \n \n \n \n \n {if !empty($dataArray)}\n {foreach from=$dataArray item=value key=priceset}\n \n \n {if $priceset}\n \n \n {elseif $priceset == 0}\n \n \n {/if}\n \n {/foreach}\n {/if}\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\n

\n \n \n \n {if $contribution_status_id == $pendingStatusId && $is_pay_later == 1}\n \n \n \n \n {/if}\n

{ts}Description{/ts}	{ts}Quantity{/ts}	{ts}Unit Price{/ts}	{$taxTerm}	{ts 1=$currency}Amount %1{/ts}
\n {if $value.html_type eq \'Text\'}\n {$value.label}\n {else}\n {$value.field_title} - {$value.label}\n {/if}\n {if $value.description}\n {$value.description\|truncate:30:\"...\"} \n {/if}\n \n	{$value.qty}	{$value.unit_price\|crmMoney:$currency}	{if $value.tax_rate}{$value.tax_rate}%{/if}	{if $taxTerm}{ts 1=$taxTerm}-{/ts}{/if}	{$value.subTotal\|crmMoney:$currency}
	{ts}Sub Total{/ts}	{$subTotal\|crmMoney:$currency}
	{if $taxTerm}{ts 1=$taxTerm 2=$priceset}TOTAL %1 %2%{/ts}{/if}	{$value\|crmMoney:$currency}	{if $taxTerm}{ts 1=$taxTerm}TOTAL %1{/ts}{/if}	{$value\|crmMoney:$currency}
	{ts 1=$currency}TOTAL %1{/ts}	{$amount\|crmMoney:$currency}
	\n {if $contribution_status_id == $refundedStatusId}\n {ts}Amount Credited{/ts}\n {else}\n {ts}Amount Paid{/ts}\n {/if}\n \n	{$amountPaid\|crmMoney:$currency}

	{ts}AMOUNT DUE:{/ts}	{$amountDue\|crmMoney:$currency}

{ts 1=$dueDate}DUE DATE: %1{/ts}

\n \n \n \n\n {if $contribution_status_id == $pendingStatusId && $is_pay_later == 1}\n \n \n \n \n

\n\n \n \n \n \n \n

{ts}PAYMENT ADVICE{/ts}

{ts}To:{/ts}

\n {$domain_organization}
\n {$domain_street_address} {$domain_supplemental_address_1}
\n {$domain_supplemental_address_2} {$domain_state}
\n {$domain_city} {$domain_postal_code}
\n {$domain_country}
\n {$domain_email}

\n {$domain_phone}
\n

{$notes}\n

\n \n \n \n \n \n \n \n \n \n \n {if $is_pay_later == 1}\n \n \n \n \n {else}\n \n \n \n \n {/if}\n \n \n \n \n \n \n \n

{ts}Customer:{/ts}	{contact.display_name}
{ts}Invoice Number:{/ts}	{$invoice_number}

{ts}Amount Due:{/ts}	{$amount\|crmMoney:$currency}
{ts}Amount Due:{/ts}	{$amountDue\|crmMoney:$currency}
{ts}Due Date:{/ts}	{$dueDate}

\n {/if}\n\n {if $contribution_status_id == $refundedStatusId || $contribution_status_id == $cancelledStatusId}\n {if $config->empoweredBy}\n \n \n \n \n

\n {/if}\n\n \n \n \n \n \n \n \n {if $organization_name}\n \n {else}\n \n {/if}\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

{ts}CREDIT NOTE{/ts}	{ts}Date:{/ts}	{$domain_organization}
{contact.display_name} ({$organization_name})	{contact.display_name}	{$invoice_date}	\n \n {if $domain_street_address }{$domain_street_address}{/if}\n {if $domain_supplemental_address_1 }{$domain_supplemental_address_1}{/if}\n \n
{$street_address} {$supplemental_address_1}	{ts}Credit Note Number:{/ts}	\n \n {if $domain_supplemental_address_2 }{$domain_supplemental_address_2}{/if}\n {if $domain_state }{$domain_state}{/if}\n \n
{$supplemental_address_2} {$stateProvinceAbbreviation}	{$creditnote_id}	\n \n {if $domain_city}{$domain_city}{/if}\n {if $domain_postal_code }{$domain_postal_code}{/if}\n \n
{$city} {$postal_code}	{ts}Reference:{/ts}	\n \n {if $domain_country}{$domain_country}{/if}\n \n
	{$source}	\n \n {if $domain_email}{$domain_email}{/if}\n \n
		\n \n {if $domain_phone}{$domain_phone}{/if}\n \n

\n\n \n \n \n \n

\n {* FIXME: style this table so that it looks like the text version (justification, etc.) *}\n \n \n \n \n \n \n \n {foreach from=$lineItem item=value key=priceset name=pricevalue}\n {if $smarty.foreach.pricevalue.index eq 0}\n \n {else}\n \n {/if}\n \n \n \n \n {if $value.tax_amount != \'\'}\n \n {else}\n \n {/if}\n \n \n {/foreach}\n \n \n \n \n \n \n {if !empty($dataArray)}\n {foreach from=$dataArray item=value key=priceset}\n \n \n {if $priceset}\n \n \n {elseif $priceset == 0}\n \n \n {/if}\n \n {/foreach}\n {/if}\n \n \n \n \n \n \n \n \n \n {if $is_pay_later == 0}\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n {/if}\n

\n \n \n \n \n \n \n \n

{ts}Description{/ts}	{ts}Quantity{/ts}	{ts}Unit Price{/ts}	{$taxTerm}	{ts 1=$currency}Amount %1{/ts}


\n \n {if $value.html_type eq \'Text\'}\n {$value.label}\n {else}\n {$value.field_title} - {$value.label}\n {/if}\n {if $value.description}\n {$value.description\|truncate:30:\"...\"} \n {/if}\n \n	{$value.qty}	{$value.unit_price\|crmMoney:$currency}	{if $value.tax_rate}{$value.tax_rate}%{/if}	{if $taxTerm}{ts 1=$taxTerm}No %1{/ts}{/if}	{$value.subTotal\|crmMoney:$currency}

	{ts}Sub Total{/ts}	{$subTotal\|crmMoney:$currency}
	{if $taxTerm}{ts 1=$taxTerm 2=$priceset}TOTAL %1 %2%{/ts}{/if}	{$value\|crmMoney:$currency}	{if $taxTerm}{ts 1=$taxTerm}TOTAL NO %1{/ts}{/if}	{$value\|crmMoney:$currency}

	{ts 1=$currency}TOTAL %1{/ts}	{$amount\|crmMoney:$currency}
	{ts}LESS Credit to invoice(s){/ts}	{$amount\|crmMoney:$currency}

	{ts}REMAINING CREDIT{/ts}	{$amountDue\|crmMoney:$currency}

\n\n \n \n \n \n

\n\n \n \n \n \n \n

{ts}CREDIT ADVICE{/ts}

{ts}Please do not pay on this advice. Deduct the amount of this Credit Note from your next payment to us{/ts}

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

	{ts}Customer:{/ts}	{contact.display_name}
	{ts}Credit Note#:{/ts}	{$creditnote_id}

	{ts}Credit Amount:{/ts}	{$amount\|crmMoney:$currency}

\n {/if}\n\n \n \n\n',1,816,'contribution_invoice_receipt',1,0,0,NULL), - (10,'Contributions - Invoice','{if $title}\n {if $component}\n {if $component == \'event\'}\n {ts 1=$title}Event Registration Invoice: %1{/ts}\n {else}\n {ts 1=$title}Contribution Invoice: %1{/ts}\n {/if}\n {/if}\n{else}\n {ts}Invoice{/ts}\n{/if}\n - {contact.display_name}\n','{ts}Contribution Invoice{/ts}\n','\n\n \n \n \n \n \n

\n {if $config->empoweredBy}\n \n \n \n \n

\n {/if}\n \n \n \n \n \n \n \n {if $organization_name}\n \n {else}\n \n {/if}\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

{ts}INVOICE{/ts}	{ts}Invoice Date:{/ts}	{$domain_organization}
{contact.display_name} ({$organization_name})	{contact.display_name}	{$invoice_date}	\n \n {if $domain_street_address }{$domain_street_address}{/if}\n {if $domain_supplemental_address_1 }{$domain_supplemental_address_1}{/if}\n \n
{$street_address} {$supplemental_address_1}	{ts}Invoice Number:{/ts}	\n \n {if $domain_supplemental_address_2 }{$domain_supplemental_address_2}{/if}\n {if $domain_state }{$domain_state}{/if}\n \n
{$supplemental_address_2} {$stateProvinceAbbreviation}	{$invoice_number}	\n \n {if $domain_city}{$domain_city}{/if}\n {if $domain_postal_code }{$domain_postal_code}{/if}\n \n
{$city} {$postal_code}	{ts}Reference:{/ts}	{if $domain_country}{$domain_country}{/if}
{$country}	{if !empty($source)}{$source}{/if}	{if $domain_email}{$domain_email}{/if}
		{if $domain_phone}{$domain_phone}{/if}

{ts}Description{/ts}	{ts}Quantity{/ts}	{ts}Unit Price{/ts}	{$taxTerm}	{ts 1=$currency}Amount %1{/ts}
\n {if $value.html_type eq \'Text\'}\n {$value.label}\n {else}\n {$value.field_title} - {$value.label}\n {/if}\n {if $value.description}\n {$value.description\|truncate:30:\"...\"} \n {/if}\n \n	{$value.qty}	{$value.unit_price\|crmMoney:$currency}	{if $value.tax_rate}{$value.tax_rate}%{/if}	{if $taxTerm}{ts 1=$taxTerm}-{/ts}{/if}	{$value.subTotal\|crmMoney:$currency}
	{ts}Sub Total{/ts}	{$subTotal\|crmMoney:$currency}
	{if $taxTerm}{ts 1=$taxTerm 2=$priceset}TOTAL %1 %2%{/ts}{/if}	{$value\|crmMoney:$currency}	{if $taxTerm}{ts 1=$taxTerm}TOTAL %1{/ts}{/if}	{$value\|crmMoney:$currency}
	{ts 1=$currency}TOTAL %1{/ts}	{$amount\|crmMoney:$currency}
	\n {if $contribution_status_id == $refundedStatusId}\n {ts}Amount Credited{/ts}\n {else}\n {ts}Amount Paid{/ts}\n {/if}\n \n	{$amountPaid\|crmMoney:$currency}

	{ts}AMOUNT DUE:{/ts}	{$amountDue\|crmMoney:$currency}

{ts 1=$dueDate}DUE DATE: %1{/ts}

\n\n {if $contribution_status_id == $pendingStatusId && $is_pay_later == 1}\n \n \n \n \n

\n\n \n \n \n \n \n

{ts}PAYMENT ADVICE{/ts}

{ts}To:{/ts}

\n {$domain_phone}
\n

{$notes}\n

\n \n \n \n \n \n \n \n \n \n \n {if $is_pay_later == 1}\n \n \n \n \n {else}\n \n \n \n \n {/if}\n \n \n \n \n \n \n \n

{ts}Customer:{/ts}	{contact.display_name}
{ts}Invoice Number:{/ts}	{$invoice_number}

{ts}Amount Due:{/ts}	{$amount\|crmMoney:$currency}
{ts}Amount Due:{/ts}	{$amountDue\|crmMoney:$currency}
{ts}Due Date:{/ts}	{$dueDate}

\n {/if}\n\n {if $contribution_status_id == $refundedStatusId || $contribution_status_id == $cancelledStatusId}\n {if $config->empoweredBy}\n \n \n \n \n

\n {/if}\n\n \n \n \n \n \n \n \n {if $organization_name}\n \n {else}\n \n {/if}\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

{ts}CREDIT NOTE{/ts}	{ts}Date:{/ts}	{$domain_organization}
{contact.display_name} ({$organization_name})	{contact.display_name}	{$invoice_date}	\n \n {if $domain_street_address }{$domain_street_address}{/if}\n {if $domain_supplemental_address_1 }{$domain_supplemental_address_1}{/if}\n \n
{$street_address} {$supplemental_address_1}	{ts}Credit Note Number:{/ts}	\n \n {if $domain_supplemental_address_2 }{$domain_supplemental_address_2}{/if}\n {if $domain_state }{$domain_state}{/if}\n \n
{$supplemental_address_2} {$stateProvinceAbbreviation}	{$creditnote_id}	\n \n {if $domain_city}{$domain_city}{/if}\n {if $domain_postal_code }{$domain_postal_code}{/if}\n \n
{$city} {$postal_code}	{ts}Reference:{/ts}	\n \n {if $domain_country}{$domain_country}{/if}\n \n
	{$source}	\n \n {if $domain_email}{$domain_email}{/if}\n \n
		\n \n {if $domain_phone}{$domain_phone}{/if}\n \n

\n\n \n \n \n \n

{ts}Description{/ts}	{ts}Quantity{/ts}	{ts}Unit Price{/ts}	{$taxTerm}	{ts 1=$currency}Amount %1{/ts}


\n \n {if $value.html_type eq \'Text\'}\n {$value.label}\n {else}\n {$value.field_title} - {$value.label}\n {/if}\n {if $value.description}\n {$value.description\|truncate:30:\"...\"} \n {/if}\n \n	{$value.qty}	{$value.unit_price\|crmMoney:$currency}	{if $value.tax_rate}{$value.tax_rate}%{/if}	{if $taxTerm}{ts 1=$taxTerm}No %1{/ts}{/if}	{$value.subTotal\|crmMoney:$currency}

	{ts}Sub Total{/ts}	{$subTotal\|crmMoney:$currency}
	{if $taxTerm}{ts 1=$taxTerm 2=$priceset}TOTAL %1 %2%{/ts}{/if}	{$value\|crmMoney:$currency}	{if $taxTerm}{ts 1=$taxTerm}TOTAL NO %1{/ts}{/if}	{$value\|crmMoney:$currency}

	{ts 1=$currency}TOTAL %1{/ts}	{$amount\|crmMoney:$currency}
	{ts}LESS Credit to invoice(s){/ts}	{$amount\|crmMoney:$currency}

	{ts}REMAINING CREDIT{/ts}	{$amountDue\|crmMoney:$currency}

\n\n \n \n \n \n

\n\n \n \n \n \n \n

{ts}CREDIT ADVICE{/ts}

{ts}Please do not pay on this advice. Deduct the amount of this Credit Note from your next payment to us{/ts}

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

	{ts}Customer:{/ts}	{contact.display_name}
	{ts}Credit Note#:{/ts}	{$creditnote_id}

	{ts}Credit Amount:{/ts}	{$amount\|crmMoney:$currency}

\n {/if}\n\n \n \n\n',1,816,'contribution_invoice_receipt',0,1,0,NULL), + (9,'Contributions - Invoice','{if $title}\n {if $component}\n {if $component == \'event\'}\n {ts 1=$title}Event Registration Invoice: %1{/ts}\n {else}\n {ts 1=$title}Contribution Invoice: %1{/ts}\n {/if}\n {/if}\n{else}\n {ts}Invoice{/ts}\n{/if}\n - {contact.display_name}\n','{ts}Contribution Invoice{/ts}\n','\n\n \n \n \n \n \n

\n {if $config->empoweredBy}\n \n \n \n \n

\n {/if}\n \n \n \n \n \n \n \n {if $organization_name}\n \n {else}\n \n {/if}\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

{ts}INVOICE{/ts}	{ts}Invoice Date:{/ts}	{domain.name}
{contact.display_name} ({$organization_name})	{contact.display_name}	{$invoice_date}	\n \n {domain.street_address}\n {domain.supplemental_address_1}\n \n
{$street_address} {$supplemental_address_1}	{ts}Invoice Number:{/ts}	\n \n {domain.supplemental_address_2}\n {domain.state_province_id:label}\n \n
{$supplemental_address_2} {$stateProvinceAbbreviation}	{contribution.invoice_number}	\n \n {domain.city}\n {domain.postal_code}\n \n
{$city} {$postal_code}	{ts}Reference:{/ts}	{domain.country_id:label}
{$country}	{contribution.source}	{domain.email}
		{domain.phone}

{ts}Description{/ts}	{ts}Quantity{/ts}	{ts}Unit Price{/ts}	{domain.tax_term}	{ts 1=$currency}Amount %1{/ts}
\n {if $value.html_type eq \'Text\'}\n {$value.label}\n {else}\n {$value.field_title} - {$value.label}\n {/if}\n {if $value.description}\n {$value.description\|truncate:30:\"...\"} \n {/if}\n \n	{$value.qty}	{$value.unit_price\|crmMoney:$currency}	{if $value.tax_rate}{$value.tax_rate}%{/if}	{if $taxTerm}{ts 1=$taxTerm}-{/ts}{/if}	{$value.subTotal\|crmMoney:$currency}
	{ts}Sub Total{/ts}	{$subTotal\|crmMoney:$currency}
	{if $taxTerm}{ts 1=$taxTerm 2=$priceset}TOTAL %1 %2%{/ts}{/if}	{$value\|crmMoney:$currency}	{if $taxTerm}{ts 1=$taxTerm}TOTAL %1{/ts}{/if}	{$value\|crmMoney:$currency}
	{ts 1=$currency}TOTAL %1{/ts}	{$amount\|crmMoney:$currency}
	\n {if $contribution_status_id == $refundedStatusId}\n {ts}Amount Credited{/ts}\n {else}\n {ts}Amount Paid{/ts}\n {/if}\n \n	{$amountPaid\|crmMoney:$currency}

	{ts}AMOUNT DUE:{/ts}	{$amountDue\|crmMoney:$currency}

{ts 1=$dueDate}DUE DATE: %1{/ts}

\n\n {if $contribution_status_id == $pendingStatusId && $is_pay_later == 1}\n \n \n \n \n

\n\n \n \n \n \n \n

{ts}PAYMENT ADVICE{/ts}

{ts}To:{/ts}

\n {domain.name}
\n {domain.street_address} {domain.supplemental_address_1}
\n {domain.supplemental_address_2} {domain.state_province_id:label}
\n {domain.city} {domain.postal_code}
\n {domain.country_id:label}
\n {domain.email}

\n {domain.phone}
\n

{$notes}\n

\n \n \n \n \n \n \n \n \n \n \n {if $is_pay_later == 1}\n \n \n \n \n {else}\n \n \n \n \n {/if}\n \n \n \n \n \n \n \n

{ts}Customer:{/ts}	{contact.display_name}
{ts}Invoice Number:{/ts}	{$invoice_number}

{ts}Amount Due:{/ts}	{$amount\|crmMoney:$currency}
{ts}Amount Due:{/ts}	{$amountDue\|crmMoney:$currency}
{ts}Due Date:{/ts}	{$dueDate}

\n {/if}\n\n {if $contribution_status_id == $refundedStatusId || $contribution_status_id == $cancelledStatusId}\n {if $config->empoweredBy}\n \n \n \n \n

\n {/if}\n\n \n \n \n \n \n \n \n {if $organization_name}\n \n {else}\n \n {/if}\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

{ts}CREDIT NOTE{/ts}	{ts}Date:{/ts}	{domain.name}
{contact.display_name} ({$organization_name})	{contact.display_name}	{$invoice_date}	\n \n {domain.street_address}\n {domain.supplemental_address_1}\n \n
{$street_address} {$supplemental_address_1}	{ts}Credit Note Number:{/ts}	\n \n {domain.supplemental_address_2}\n {domain.state_province_id:label}\n \n
{$supplemental_address_2} {$stateProvinceAbbreviation}	{$creditnote_id}	\n \n {domain.city}\n {domain.postal_code}\n \n
{$city} {$postal_code}	{ts}Reference:{/ts}	\n \n {domain.country_id:label}\n \n
	{$source}	\n \n {domain.email}\n \n
		\n \n {domain.phone}\n \n

\n\n \n \n \n \n

{ts}Description{/ts}	{ts}Quantity{/ts}	{ts}Unit Price{/ts}	{$taxTerm}	{ts 1=$currency}Amount %1{/ts}


\n \n {if $value.html_type eq \'Text\'}\n {$value.label}\n {else}\n {$value.field_title} - {$value.label}\n {/if}\n {if $value.description}\n {$value.description\|truncate:30:\"...\"} \n {/if}\n \n	{$value.qty}	{$value.unit_price\|crmMoney:$currency}	{if $value.tax_rate}{$value.tax_rate}%{/if}	{if $taxTerm}{ts 1=$taxTerm}No %1{/ts}{/if}	{$value.subTotal\|crmMoney:$currency}

	{ts}Sub Total{/ts}	{$subTotal\|crmMoney:$currency}
	{if $taxTerm}{ts 1=$taxTerm 2=$priceset}TOTAL %1 %2%{/ts}{/if}	{$value\|crmMoney:$currency}	{if $taxTerm}{ts 1=$taxTerm}TOTAL NO %1{/ts}{/if}	{$value\|crmMoney:$currency}

	{ts 1=$currency}TOTAL %1{/ts}	{$amount\|crmMoney:$currency}
	{ts}LESS Credit to invoice(s){/ts}	{$amount\|crmMoney:$currency}

	{ts}REMAINING CREDIT{/ts}	{$amountDue\|crmMoney:$currency}

\n\n \n \n \n \n

\n\n \n \n \n \n \n

{ts}CREDIT ADVICE{/ts}

{ts}Please do not pay on this advice. Deduct the amount of this Credit Note from your next payment to us{/ts}

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

	{ts}Customer:{/ts}	{contact.display_name}
	{ts}Credit Note#:{/ts}	{$creditnote_id}

	{ts}Credit Amount:{/ts}	{$amount\|crmMoney:$currency}

\n {/if}\n\n \n \n\n',1,816,'contribution_invoice_receipt',1,0,0,NULL), + (10,'Contributions - Invoice','{if $title}\n {if $component}\n {if $component == \'event\'}\n {ts 1=$title}Event Registration Invoice: %1{/ts}\n {else}\n {ts 1=$title}Contribution Invoice: %1{/ts}\n {/if}\n {/if}\n{else}\n {ts}Invoice{/ts}\n{/if}\n - {contact.display_name}\n','{ts}Contribution Invoice{/ts}\n','\n\n \n \n \n \n \n

\n {if $config->empoweredBy}\n \n \n \n \n

\n {/if}\n \n \n \n \n \n \n \n {if $organization_name}\n \n {else}\n \n {/if}\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

{ts}INVOICE{/ts}	{ts}Invoice Date:{/ts}	{domain.name}
{contact.display_name} ({$organization_name})	{contact.display_name}	{$invoice_date}	\n \n {domain.street_address}\n {domain.supplemental_address_1}\n \n
{$street_address} {$supplemental_address_1}	{ts}Invoice Number:{/ts}	\n \n {domain.supplemental_address_2}\n {domain.state_province_id:label}\n \n
{$supplemental_address_2} {$stateProvinceAbbreviation}	{contribution.invoice_number}	\n \n {domain.city}\n {domain.postal_code}\n \n
{$city} {$postal_code}	{ts}Reference:{/ts}	{domain.country_id:label}
{$country}	{contribution.source}	{domain.email}
		{domain.phone}

{ts}Description{/ts}	{ts}Quantity{/ts}	{ts}Unit Price{/ts}	{domain.tax_term}	{ts 1=$currency}Amount %1{/ts}
\n {if $value.html_type eq \'Text\'}\n {$value.label}\n {else}\n {$value.field_title} - {$value.label}\n {/if}\n {if $value.description}\n {$value.description\|truncate:30:\"...\"} \n {/if}\n \n	{$value.qty}	{$value.unit_price\|crmMoney:$currency}	{if $value.tax_rate}{$value.tax_rate}%{/if}	{if $taxTerm}{ts 1=$taxTerm}-{/ts}{/if}	{$value.subTotal\|crmMoney:$currency}
	{ts}Sub Total{/ts}	{$subTotal\|crmMoney:$currency}
	{if $taxTerm}{ts 1=$taxTerm 2=$priceset}TOTAL %1 %2%{/ts}{/if}	{$value\|crmMoney:$currency}	{if $taxTerm}{ts 1=$taxTerm}TOTAL %1{/ts}{/if}	{$value\|crmMoney:$currency}
	{ts 1=$currency}TOTAL %1{/ts}	{$amount\|crmMoney:$currency}
	\n {if $contribution_status_id == $refundedStatusId}\n {ts}Amount Credited{/ts}\n {else}\n {ts}Amount Paid{/ts}\n {/if}\n \n	{$amountPaid\|crmMoney:$currency}

	{ts}AMOUNT DUE:{/ts}	{$amountDue\|crmMoney:$currency}

{ts 1=$dueDate}DUE DATE: %1{/ts}

\n\n {if $contribution_status_id == $pendingStatusId && $is_pay_later == 1}\n \n \n \n \n

\n\n \n \n \n - + {if $organization_name} @@ -28,8 +28,8 @@ @@ -38,35 +38,35 @@ - + - + - - + + - +

{ts}PAYMENT ADVICE{/ts}

{ts}To:{/ts}

\n {domain.phone}
\n

{$notes}\n

\n \n \n \n \n \n \n \n \n \n \n {if $is_pay_later == 1}\n \n \n \n \n {else}\n \n \n \n \n {/if}\n \n \n \n \n \n \n \n

{ts}Customer:{/ts}	{contact.display_name}
{ts}Invoice Number:{/ts}	{$invoice_number}

{ts}Amount Due:{/ts}	{$amount\|crmMoney:$currency}
{ts}Amount Due:{/ts}	{$amountDue\|crmMoney:$currency}
{ts}Due Date:{/ts}	{$dueDate}

\n {/if}\n\n {if $contribution_status_id == $refundedStatusId || $contribution_status_id == $cancelledStatusId}\n {if $config->empoweredBy}\n \n \n \n \n

\n {/if}\n\n \n \n \n \n \n \n \n {if $organization_name}\n \n {else}\n \n {/if}\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

{ts}CREDIT NOTE{/ts}	{ts}Date:{/ts}	{domain.name}
{contact.display_name} ({$organization_name})	{contact.display_name}	{$invoice_date}	\n \n {domain.street_address}\n {domain.supplemental_address_1}\n \n
{$street_address} {$supplemental_address_1}	{ts}Credit Note Number:{/ts}	\n \n {domain.supplemental_address_2}\n {domain.state_province_id:label}\n \n
{$supplemental_address_2} {$stateProvinceAbbreviation}	{$creditnote_id}	\n \n {domain.city}\n {domain.postal_code}\n \n
{$city} {$postal_code}	{ts}Reference:{/ts}	\n \n {domain.country_id:label}\n \n
	{$source}	\n \n {domain.email}\n \n
		\n \n {domain.phone}\n \n

\n\n \n \n \n \n

{ts}Description{/ts}	{ts}Quantity{/ts}	{ts}Unit Price{/ts}	{$taxTerm}	{ts 1=$currency}Amount %1{/ts}


\n \n {if $value.html_type eq \'Text\'}\n {$value.label}\n {else}\n {$value.field_title} - {$value.label}\n {/if}\n {if $value.description}\n {$value.description\|truncate:30:\"...\"} \n {/if}\n \n	{$value.qty}	{$value.unit_price\|crmMoney:$currency}	{if $value.tax_rate}{$value.tax_rate}%{/if}	{if $taxTerm}{ts 1=$taxTerm}No %1{/ts}{/if}	{$value.subTotal\|crmMoney:$currency}

	{ts}Sub Total{/ts}	{$subTotal\|crmMoney:$currency}
	{if $taxTerm}{ts 1=$taxTerm 2=$priceset}TOTAL %1 %2%{/ts}{/if}	{$value\|crmMoney:$currency}	{if $taxTerm}{ts 1=$taxTerm}TOTAL NO %1{/ts}{/if}	{$value\|crmMoney:$currency}

	{ts 1=$currency}TOTAL %1{/ts}	{$amount\|crmMoney:$currency}
	{ts}LESS Credit to invoice(s){/ts}	{$amount\|crmMoney:$currency}

	{ts}REMAINING CREDIT{/ts}	{$amountDue\|crmMoney:$currency}

\n\n \n \n \n \n

\n\n \n \n \n \n \n

{ts}CREDIT ADVICE{/ts}

{ts}Please do not pay on this advice. Deduct the amount of this Credit Note from your next payment to us{/ts}

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

	{ts}Customer:{/ts}	{contact.display_name}
	{ts}Credit Note#:{/ts}	{$creditnote_id}

	{ts}Credit Amount:{/ts}	{$amount\|crmMoney:$currency}

\n {/if}\n\n \n \n\n',1,816,'contribution_invoice_receipt',0,1,0,NULL), (11,'Contributions - Recurring Start and End Notification','{ts}Recurring Contribution Notification{/ts} - {contact.display_name}\n','{assign var=\"greeting\" value=\"{contact.email_greeting}\"}{if $greeting}{$greeting},{/if}\n\n{if $recur_txnType eq \'START\'}\n{if $auto_renew_membership}\n{ts}Thanks for your auto renew membership sign-up.{/ts}\n\n\n{ts 1=$recur_frequency_interval 2=$recur_frequency_unit}This membership will be automatically renewed every %1 %2(s).{/ts}\n\n{if $cancelSubscriptionUrl}\n{ts 1=$cancelSubscriptionUrl}You can cancel the auto-renewal option by visiting this web page.{/ts}\n\n{/if}\n\n{if $updateSubscriptionBillingUrl}\n{ts 1=$updateSubscriptionBillingUrl}You can update billing details for this automatically renewed membership by visiting this web page.{/ts}\n\n{/if}\n{else}\n{ts}Thanks for your recurring contribution sign-up.{/ts}\n\n\n{ts 1=$recur_frequency_interval 2=$recur_frequency_unit 3=$recur_installments}This recurring contribution will be automatically processed every %1 %2(s){/ts}{if $recur_installments } {ts 1=$recur_installments} for a total of %1 installment(s){/ts}{/if}.\n\n{ts}Start Date{/ts}: {$recur_start_date|crmDate}\n\n{if $cancelSubscriptionUrl}\n{ts 1=$cancelSubscriptionUrl}You can cancel the recurring contribution option by visiting this web page.{/ts}\n\n{/if}\n\n{if $updateSubscriptionBillingUrl}\n{ts 1=$updateSubscriptionBillingUrl}You can update billing details for this recurring contribution by visiting this web page.{/ts}\n\n{/if}\n\n{if $updateSubscriptionUrl}\n{ts 1=$updateSubscriptionUrl}You can update recurring contribution amount or change the number of installments for this recurring contribution by visiting this web page.{/ts}\n\n{/if}\n{/if}\n\n{elseif $recur_txnType eq \'END\'}\n{if $auto_renew_membership}\n{ts}Your auto renew membership sign-up has ended and your membership will not be automatically renewed.{/ts}\n\n\n{else}\n{ts}Your recurring contribution term has ended.{/ts}\n\n\n{ts 1=$recur_installments}You have successfully completed %1 recurring contributions. Thank you.{/ts}\n\n\n==================================================\n{ts 1=$recur_installments}Interval of Subscription for %1 installment(s){/ts}\n\n==================================================\n{ts}Start Date{/ts}: {$recur_start_date|crmDate}\n\n{ts}End Date{/ts}: {$recur_end_date|crmDate}\n\n{/if}\n{/if}\n','\n\n\n \n \n\n\n\n{capture assign=headerStyle}colspan=\"2\" style=\"text-align: left; padding: 4px; border-bottom: 1px solid #999; background-color: #eee;\"{/capture}\n{capture assign=labelStyle }style=\"padding: 4px; border-bottom: 1px solid #999; background-color: #f7f7f7;\"{/capture}\n{capture assign=valueStyle }style=\"padding: 4px; border-bottom: 1px solid #999;\"{/capture}\n\n \n\n \n \n \n\n \n\n \n \n \n\n \n \n \n\n {if $recur_txnType eq \'START\'}\n {if $auto_renew_membership}\n \n \n \n {if $cancelSubscriptionUrl}\n \n \n \n {/if}\n {if $updateSubscriptionBillingUrl}\n \n \n \n {/if}\n {else}\n \n \n \n {if $cancelSubscriptionUrl}\n \n \n \n {/if}\n {if $updateSubscriptionBillingUrl}\n \n \n \n {/if}\n {if $updateSubscriptionUrl}\n \n \n \n {/if}\n {/if}\n\n {elseif $recur_txnType eq \'END\'}\n\n {if $auto_renew_membership}\n \n \n \n {else}\n \n \n \n \n \n \n\n {/if}\n {/if}\n\n

\n {assign var=\"greeting\" value=\"{contact.email_greeting}\"}{if $greeting}

{$greeting},

{/if}\n

{ts}Thanks for your auto renew membership sign-up.{/ts}

{ts 1=$recur_frequency_interval 2=$recur_frequency_unit}This membership will be automatically renewed every %1 %2(s). {/ts}

\n {ts 1=$cancelSubscriptionUrl}You can cancel the auto-renewal option by visiting this web page.{/ts}\n

\n {ts 1=$updateSubscriptionBillingUrl}You can update billing details for this automatically renewed membership by visiting this web page.{/ts}\n

{ts}Thanks for your recurring contribution sign-up.{/ts}

{ts 1=$recur_frequency_interval 2=$recur_frequency_unit}This recurring contribution will be automatically processed every %1 %2(s){/ts}{if $recur_installments }{ts 1=$recur_installments} for a total of %1 installment(s){/ts}{/if}.

{ts}Start Date{/ts}: {$recur_start_date|crmDate}

\n {ts 1=$cancelSubscriptionUrl} You can cancel the recurring contribution option by visiting this web page.{/ts}\n

\n {ts 1=$updateSubscriptionBillingUrl}You can update billing details for this recurring contribution by visiting this web page.{/ts}\n

\n {ts 1=$updateSubscriptionUrl}You can update recurring contribution amount or change the number of installments details for this recurring contribution by visiting this web page.{/ts}\n

{ts}Your auto renew membership sign-up has ended and your membership will not be automatically renewed.{/ts}

{ts}Your recurring contribution term has ended.{/ts}

{ts 1=$recur_installments}You have successfully completed %1 recurring contributions. Thank you.{/ts}

\n \n \n \n \n \n \n \n \n \n \n \n \n

\n {ts 1=$recur_installments}Interval of Subscription for %1 installment(s){/ts}\n
\n {ts}Start Date{/ts}\n	\n {$recur_start_date\|crmDate}\n
\n {ts}End Date{/ts}\n	\n {$recur_end_date\|crmDate}\n

\n\n\n\n',1,817,'contribution_recurring_notify',1,0,0,NULL), (12,'Contributions - Recurring Start and End Notification','{ts}Recurring Contribution Notification{/ts} - {contact.display_name}\n','{assign var=\"greeting\" value=\"{contact.email_greeting}\"}{if $greeting}{$greeting},{/if}\n\n{if $recur_txnType eq \'START\'}\n{if $auto_renew_membership}\n{ts}Thanks for your auto renew membership sign-up.{/ts}\n\n\n{ts 1=$recur_frequency_interval 2=$recur_frequency_unit}This membership will be automatically renewed every %1 %2(s).{/ts}\n\n{if $cancelSubscriptionUrl}\n{ts 1=$cancelSubscriptionUrl}You can cancel the auto-renewal option by visiting this web page.{/ts}\n\n{/if}\n\n{if $updateSubscriptionBillingUrl}\n{ts 1=$updateSubscriptionBillingUrl}You can update billing details for this automatically renewed membership by visiting this web page.{/ts}\n\n{/if}\n{else}\n{ts}Thanks for your recurring contribution sign-up.{/ts}\n\n\n{ts 1=$recur_frequency_interval 2=$recur_frequency_unit 3=$recur_installments}This recurring contribution will be automatically processed every %1 %2(s){/ts}{if $recur_installments } {ts 1=$recur_installments} for a total of %1 installment(s){/ts}{/if}.\n\n{ts}Start Date{/ts}: {$recur_start_date|crmDate}\n\n{if $cancelSubscriptionUrl}\n{ts 1=$cancelSubscriptionUrl}You can cancel the recurring contribution option by visiting this web page.{/ts}\n\n{/if}\n\n{if $updateSubscriptionBillingUrl}\n{ts 1=$updateSubscriptionBillingUrl}You can update billing details for this recurring contribution by visiting this web page.{/ts}\n\n{/if}\n\n{if $updateSubscriptionUrl}\n{ts 1=$updateSubscriptionUrl}You can update recurring contribution amount or change the number of installments for this recurring contribution by visiting this web page.{/ts}\n\n{/if}\n{/if}\n\n{elseif $recur_txnType eq \'END\'}\n{if $auto_renew_membership}\n{ts}Your auto renew membership sign-up has ended and your membership will not be automatically renewed.{/ts}\n\n\n{else}\n{ts}Your recurring contribution term has ended.{/ts}\n\n\n{ts 1=$recur_installments}You have successfully completed %1 recurring contributions. Thank you.{/ts}\n\n\n==================================================\n{ts 1=$recur_installments}Interval of Subscription for %1 installment(s){/ts}\n\n==================================================\n{ts}Start Date{/ts}: {$recur_start_date|crmDate}\n\n{ts}End Date{/ts}: {$recur_end_date|crmDate}\n\n{/if}\n{/if}\n','\n\n\n \n \n\n\n\n{capture assign=headerStyle}colspan=\"2\" style=\"text-align: left; padding: 4px; border-bottom: 1px solid #999; background-color: #eee;\"{/capture}\n{capture assign=labelStyle }style=\"padding: 4px; border-bottom: 1px solid #999; background-color: #f7f7f7;\"{/capture}\n{capture assign=valueStyle }style=\"padding: 4px; border-bottom: 1px solid #999;\"{/capture}\n\n \n\n \n \n \n\n \n\n \n \n \n\n \n \n \n\n {if $recur_txnType eq \'START\'}\n {if $auto_renew_membership}\n \n \n \n {if $cancelSubscriptionUrl}\n \n \n \n {/if}\n {if $updateSubscriptionBillingUrl}\n \n \n \n {/if}\n {else}\n \n \n \n {if $cancelSubscriptionUrl}\n \n \n \n {/if}\n {if $updateSubscriptionBillingUrl}\n \n \n \n {/if}\n {if $updateSubscriptionUrl}\n \n \n \n {/if}\n {/if}\n\n {elseif $recur_txnType eq \'END\'}\n\n {if $auto_renew_membership}\n \n \n \n {else}\n \n \n \n \n \n \n\n {/if}\n {/if}\n\n

\n {assign var=\"greeting\" value=\"{contact.email_greeting}\"}{if $greeting}

{$greeting},

{/if}\n

{ts}Thanks for your auto renew membership sign-up.{/ts}

{ts 1=$recur_frequency_interval 2=$recur_frequency_unit}This membership will be automatically renewed every %1 %2(s). {/ts}

\n {ts 1=$cancelSubscriptionUrl}You can cancel the auto-renewal option by visiting this web page.{/ts}\n

\n {ts 1=$updateSubscriptionBillingUrl}You can update billing details for this automatically renewed membership by visiting this web page.{/ts}\n

{ts}Thanks for your recurring contribution sign-up.{/ts}

{ts}Start Date{/ts}: {$recur_start_date|crmDate}

\n {ts 1=$cancelSubscriptionUrl} You can cancel the recurring contribution option by visiting this web page.{/ts}\n

\n {ts 1=$updateSubscriptionBillingUrl}You can update billing details for this recurring contribution by visiting this web page.{/ts}\n

\n {ts 1=$updateSubscriptionUrl}You can update recurring contribution amount or change the number of installments details for this recurring contribution by visiting this web page.{/ts}\n

{ts}Your auto renew membership sign-up has ended and your membership will not be automatically renewed.{/ts}

{ts}Your recurring contribution term has ended.{/ts}

{ts 1=$recur_installments}You have successfully completed %1 recurring contributions. Thank you.{/ts}

\n \n \n \n \n \n \n \n \n \n \n \n \n

\n {ts 1=$recur_installments}Interval of Subscription for %1 installment(s){/ts}\n
\n {ts}Start Date{/ts}\n	\n {$recur_start_date\|crmDate}\n
\n {ts}End Date{/ts}\n	\n {$recur_end_date\|crmDate}\n

\n\n\n\n',1,817,'contribution_recurring_notify',0,1,0,NULL), (13,'Contributions - Recurring Cancellation Notification','{ts}Recurring Contribution Cancellation Notification{/ts} - {contact.display_name}\n','{assign var=\"greeting\" value=\"{contact.email_greeting}\"}{if $greeting}{$greeting},{/if}\n\n{ts 1=$amount 2=$recur_frequency_interval 3=$recur_frequency_unit}Your recurring contribution of %1, every %2 %3 has been cancelled as requested.{/ts}\n','\n\n\n \n \n\n\n\n{capture assign=headerStyle}colspan=\"2\" style=\"text-align: left; padding: 4px; border-bottom: 1px solid #999; background-color: #eee;\"{/capture}\n{capture assign=labelStyle }style=\"padding: 4px; border-bottom: 1px solid #999; background-color: #f7f7f7;\"{/capture}\n{capture assign=valueStyle }style=\"padding: 4px; border-bottom: 1px solid #999;\"{/capture}\n\n \n\n \n \n \n\n \n\n \n \n \n \n

\n {assign var=\"greeting\" value=\"{contact.email_greeting}\"}{if $greeting}

{$greeting},

{/if}\n

{ts 1=$amount 2=$recur_frequency_interval 3=$recur_frequency_unit}Your recurring contribution of %1, every %2 %3 has been cancelled as requested.{/ts}

\n\n\n\n',1,818,'contribution_recurring_cancelled',1,0,0,NULL), @@ -5606,26 +5594,26 @@ UNLOCK TABLES; LOCK TABLES `civicrm_note` WRITE; /*!40000 ALTER TABLE `civicrm_note` DISABLE KEYS */; INSERT INTO `civicrm_note` (`id`, `entity_table`, `entity_id`, `note`, `contact_id`, `note_date`, `created_date`, `modified_date`, `subject`, `privacy`) VALUES - (1,'civicrm_contact',24,'Chart out route map for next 10k run',1,'2022-05-04 18:47:24','2022-05-04 18:47:24','2022-01-03 02:19:22',NULL,'0'), - (2,'civicrm_contact',134,'Connect for presentation',1,'2022-05-04 18:47:24','2022-05-04 18:47:24','2021-10-26 02:12:57',NULL,'0'), - (3,'civicrm_contact',61,'Invite members for the Steve Prefontaine 10k dream run',1,'2022-05-04 18:47:24','2022-05-04 18:47:24','2022-01-03 08:47:18',NULL,'0'), - (4,'civicrm_contact',146,'Arrange collection of funds from members',1,'2022-05-04 18:47:24','2022-05-04 18:47:24','2022-05-02 03:17:35',NULL,'0'), - (5,'civicrm_contact',125,'Reminder screening of \"Black\" on next Friday',1,'2022-05-04 18:47:24','2022-05-04 18:47:24','2021-06-06 10:34:35',NULL,'0'), - (6,'civicrm_contact',2,'Contact the Commissioner of Charities',1,'2022-05-04 18:47:24','2022-05-04 18:47:24','2021-10-12 04:40:20',NULL,'0'), - (7,'civicrm_contact',197,'Send reminder for annual dinner',1,'2022-05-04 18:47:24','2022-05-04 18:47:24','2021-08-23 10:30:14',NULL,'0'), - (8,'civicrm_contact',29,'Invite members for the Steve Prefontaine 10k dream run',1,'2022-05-04 18:47:24','2022-05-04 18:47:24','2021-12-03 06:15:24',NULL,'0'), - (9,'civicrm_contact',109,'Organize the Terry Fox run',1,'2022-05-04 18:47:24','2022-05-04 18:47:24','2021-08-22 09:41:05',NULL,'0'), - (10,'civicrm_contact',178,'Send newsletter for April 2005',1,'2022-05-04 18:47:24','2022-05-04 18:47:24','2021-10-30 06:13:48',NULL,'0'), - (11,'civicrm_contact',49,'Send newsletter for April 2005',1,'2022-05-04 18:47:24','2022-05-04 18:47:24','2021-09-26 04:47:14',NULL,'0'), - (12,'civicrm_contact',76,'Arrange for cricket match with Sunil Gavaskar',1,'2022-05-04 18:47:24','2022-05-04 18:47:24','2021-06-20 08:02:00',NULL,'0'), - (13,'civicrm_contact',132,'Send reminder for annual dinner',1,'2022-05-04 18:47:24','2022-05-04 18:47:24','2021-08-02 11:05:43',NULL,'0'), - (14,'civicrm_contact',89,'Invite members for the Steve Prefontaine 10k dream run',1,'2022-05-04 18:47:24','2022-05-04 18:47:24','2022-01-08 21:48:15',NULL,'0'), - (15,'civicrm_contact',109,'Send reminder for annual dinner',1,'2022-05-04 18:47:24','2022-05-04 18:47:24','2022-02-09 18:14:19',NULL,'0'), - (16,'civicrm_contact',49,'Arrange collection of funds from members',1,'2022-05-04 18:47:24','2022-05-04 18:47:24','2022-01-02 23:59:47',NULL,'0'), - (17,'civicrm_contact',157,'Chart out route map for next 10k run',1,'2022-05-04 18:47:24','2022-05-04 18:47:24','2021-10-18 21:39:43',NULL,'0'), - (18,'civicrm_contact',146,'Reminder screening of \"Black\" on next Friday',1,'2022-05-04 18:47:24','2022-05-04 18:47:24','2021-10-31 05:16:00',NULL,'0'), - (19,'civicrm_contact',57,'Contact the Commissioner of Charities',1,'2022-05-04 18:47:24','2022-05-04 18:47:24','2021-08-05 11:28:18',NULL,'0'), - (20,'civicrm_contact',54,'Send newsletter for April 2005',1,'2022-05-04 18:47:24','2022-05-04 18:47:24','2021-07-25 22:54:47',NULL,'0'); + (1,'civicrm_contact',4,'Invite members for the Steve Prefontaine 10k dream run',1,'2022-06-15 13:01:41','2022-06-15 13:01:41','2021-10-24 21:52:55',NULL,'0'), + (2,'civicrm_contact',159,'Get the registration done for NGO status',1,'2022-06-15 13:01:41','2022-06-15 13:01:41','2021-12-23 14:23:08',NULL,'0'), + (3,'civicrm_contact',154,'Arrange for cricket match with Sunil Gavaskar',1,'2022-06-15 13:01:41','2022-06-15 13:01:41','2022-05-22 10:47:11',NULL,'0'), + (4,'civicrm_contact',178,'Chart out route map for next 10k run',1,'2022-06-15 13:01:41','2022-06-15 13:01:41','2021-09-27 05:35:31',NULL,'0'), + (5,'civicrm_contact',52,'Arrange for cricket match with Sunil Gavaskar',1,'2022-06-15 13:01:41','2022-06-15 13:01:41','2022-01-01 06:57:38',NULL,'0'), + (6,'civicrm_contact',170,'Organize the Terry Fox run',1,'2022-06-15 13:01:41','2022-06-15 13:01:41','2022-03-31 05:27:28',NULL,'0'), + (7,'civicrm_contact',62,'Invite members for the Steve Prefontaine 10k dream run',1,'2022-06-15 13:01:41','2022-06-15 13:01:41','2022-04-18 13:05:02',NULL,'0'), + (8,'civicrm_contact',113,'Organize the Terry Fox run',1,'2022-06-15 13:01:41','2022-06-15 13:01:41','2021-08-10 07:25:36',NULL,'0'), + (9,'civicrm_contact',17,'Send newsletter for April 2005',1,'2022-06-15 13:01:41','2022-06-15 13:01:41','2021-06-27 09:10:04',NULL,'0'), + (10,'civicrm_contact',13,'Arrange collection of funds from members',1,'2022-06-15 13:01:41','2022-06-15 13:01:41','2022-04-29 23:45:03',NULL,'0'), + (11,'civicrm_contact',33,'Get the registration done for NGO status',1,'2022-06-15 13:01:41','2022-06-15 13:01:41','2022-02-25 19:00:16',NULL,'0'), + (12,'civicrm_contact',4,'Send reminder for annual dinner',1,'2022-06-15 13:01:41','2022-06-15 13:01:41','2022-06-02 05:00:39',NULL,'0'), + (13,'civicrm_contact',187,'Reminder screening of \"Black\" on next Friday',1,'2022-06-15 13:01:41','2022-06-15 13:01:41','2021-09-04 03:59:11',NULL,'0'), + (14,'civicrm_contact',4,'Organize the Terry Fox run',1,'2022-06-15 13:01:41','2022-06-15 13:01:41','2022-01-17 14:26:45',NULL,'0'), + (15,'civicrm_contact',9,'Get the registration done for NGO status',1,'2022-06-15 13:01:41','2022-06-15 13:01:41','2022-01-28 11:16:07',NULL,'0'), + (16,'civicrm_contact',64,'Arrange for cricket match with Sunil Gavaskar',1,'2022-06-15 13:01:41','2022-06-15 13:01:41','2021-10-03 17:46:55',NULL,'0'), + (17,'civicrm_contact',36,'Reminder screening of \"Black\" on next Friday',1,'2022-06-15 13:01:41','2022-06-15 13:01:41','2021-12-10 09:23:24',NULL,'0'), + (18,'civicrm_contact',24,'Reminder screening of \"Black\" on next Friday',1,'2022-06-15 13:01:41','2022-06-15 13:01:41','2022-06-14 02:08:21',NULL,'0'), + (19,'civicrm_contact',129,'Arrange for cricket match with Sunil Gavaskar',1,'2022-06-15 13:01:41','2022-06-15 13:01:41','2022-03-02 22:42:17',NULL,'0'), + (20,'civicrm_contact',104,'Arrange collection of funds from members',1,'2022-06-15 13:01:41','2022-06-15 13:01:41','2021-07-26 10:29:55',NULL,'0'); /*!40000 ALTER TABLE `civicrm_note` ENABLE KEYS */; UNLOCK TABLES; @@ -6073,9 +6061,9 @@ INSERT INTO `civicrm_option_value` (`id`, `option_group_id`, `label`, `value`, ` (321,33,'Fax','3','Fax',NULL,0,0,3,NULL,0,0,1,NULL,NULL,NULL,NULL,NULL), (322,33,'Pager','4','Pager',NULL,0,0,4,NULL,0,0,1,NULL,NULL,NULL,NULL,NULL), (323,33,'Voicemail','5','Voicemail',NULL,0,0,5,NULL,0,0,1,NULL,NULL,NULL,NULL,NULL), - (324,34,'Participant Role','1','ParticipantRole',NULL,0,0,1,NULL,0,0,1,NULL,NULL,NULL,NULL,NULL), - (325,34,'Participant Event Name','2','ParticipantEventName',NULL,0,0,2,NULL,0,0,1,NULL,NULL,NULL,NULL,NULL), - (326,34,'Participant Event Type','3','ParticipantEventType',NULL,0,0,3,NULL,0,0,1,NULL,NULL,NULL,NULL,NULL), + (324,34,'Participants (Role)','1','ParticipantRole','role_id',0,0,1,NULL,0,0,1,NULL,NULL,NULL,NULL,NULL), + (325,34,'Participants (Event Name)','2','ParticipantEventName','event_id',0,0,2,NULL,0,0,1,NULL,NULL,NULL,NULL,NULL), + (326,34,'Participants (Event Type)','3','ParticipantEventType','event_id.event_type_id',0,0,3,NULL,0,0,1,NULL,NULL,NULL,NULL,NULL), (327,35,'Public','1','public',NULL,0,0,1,NULL,0,0,1,NULL,NULL,NULL,NULL,NULL), (328,35,'Admin','2','admin',NULL,0,0,2,NULL,0,0,1,NULL,NULL,NULL,NULL,NULL), (329,36,'IMAP','1','IMAP',NULL,0,0,1,NULL,0,0,1,NULL,NULL,NULL,NULL,NULL), @@ -6361,7 +6349,7 @@ INSERT INTO `civicrm_option_value` (`id`, `option_group_id`, `label`, `value`, ` (609,54,'Rejected','2','Rejected',NULL,0,0,2,NULL,0,1,1,4,1,NULL,NULL,NULL), (610,54,'None','3','None',NULL,0,0,3,NULL,0,1,1,4,1,NULL,NULL,NULL), (611,56,'Survey','Survey','civicrm_survey',NULL,0,0,1,NULL,0,0,1,NULL,NULL,NULL,NULL,NULL), - (612,56,'Cases','Case','civicrm_case',NULL,0,0,2,'CRM_Case_PseudoConstant::caseType;',0,0,1,NULL,NULL,NULL,NULL,NULL), + (612,56,'Cases','Case','civicrm_case','case_type_id',0,0,2,NULL,0,0,1,NULL,NULL,NULL,NULL,NULL), (613,84,'Abkhaz','ab','ab_GE',NULL,0,0,1,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL), (614,84,'Afar','aa','aa_ET',NULL,0,0,2,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL), (615,84,'Afrikaans','af','af_ZA',NULL,0,0,3,NULL,0,0,1,NULL,NULL,NULL,NULL,NULL), @@ -6616,56 +6604,56 @@ UNLOCK TABLES; LOCK TABLES `civicrm_participant` WRITE; /*!40000 ALTER TABLE `civicrm_participant` DISABLE KEYS */; INSERT INTO `civicrm_participant` (`id`, `contact_id`, `event_id`, `status_id`, `role_id`, `register_date`, `source`, `fee_level`, `is_test`, `is_pay_later`, `fee_amount`, `registered_by_id`, `discount_id`, `fee_currency`, `campaign_id`, `discount_amount`, `cart_id`, `must_wait`, `transferred_to_contact_id`) VALUES - (1,74,1,1,'1','2009-01-21 00:00:00','Check','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (2,102,2,2,'2','2008-05-07 00:00:00','Credit Card','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (3,140,3,3,'3','2008-05-05 00:00:00','Credit Card','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (4,153,1,4,'4','2008-10-21 00:00:00','Direct Transfer','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (5,137,2,1,'1','2008-01-10 00:00:00','Check','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (6,171,3,2,'2','2008-03-05 00:00:00','Direct Transfer','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (7,61,1,3,'3','2009-07-21 00:00:00','Direct Transfer','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (8,34,2,4,'4','2009-03-07 00:00:00','Credit Card','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (9,196,3,1,'1','2008-02-05 00:00:00','Direct Transfer','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (10,52,1,2,'2','2008-02-01 00:00:00','Check','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (11,58,2,3,'3','2009-01-10 00:00:00','Direct Transfer','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (12,100,3,4,'4','2009-03-06 00:00:00','Credit Card','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (13,60,1,1,'2','2008-06-04 00:00:00','Credit Card','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (14,73,2,2,'3','2008-01-10 00:00:00','Direct Transfer','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (15,139,3,4,'1','2008-07-04 00:00:00','Check','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (16,87,1,4,'2','2009-01-21 00:00:00','Credit Card','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (17,7,2,2,'3','2008-01-10 00:00:00','Credit Card','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (18,49,3,3,'1','2009-03-05 00:00:00','Credit Card','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (19,65,1,2,'1','2008-10-21 00:00:00','Direct Transfer','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (20,190,2,4,'1','2009-01-10 00:00:00','Credit Card','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (21,41,3,1,'4','2008-03-25 00:00:00','Check','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (22,151,1,2,'3','2009-10-21 00:00:00','Direct Transfer','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (23,157,2,4,'1','2008-01-10 00:00:00','Direct Transfer','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (24,75,3,3,'1','2008-03-11 00:00:00','Credit Card','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (25,56,3,2,'2','2008-04-05 00:00:00','Direct Transfer','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (26,201,1,1,'1','2009-01-21 00:00:00','Check','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (27,162,2,2,'2','2008-05-07 00:00:00','Credit Card','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (28,1,3,3,'3','2009-12-12 00:00:00','Direct Transfer','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (29,79,1,4,'4','2009-12-13 00:00:00','Credit Card','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (30,71,2,1,'1','2009-12-14 00:00:00','Direct Transfer','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (31,183,3,2,'2','2009-12-15 00:00:00','Credit Card','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (32,133,1,3,'3','2009-07-21 00:00:00','Check','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (33,107,2,4,'4','2009-03-07 00:00:00','Direct Transfer','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (34,33,3,1,'1','2009-12-15 00:00:00','Credit Card','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (35,4,1,2,'2','2009-12-13 00:00:00','Direct Transfer','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (36,68,2,3,'3','2009-01-10 00:00:00','Direct Transfer','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (37,53,3,4,'4','2009-03-06 00:00:00','Check','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (38,177,1,1,'2','2009-12-13 00:00:00','Direct Transfer','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (39,104,2,2,'3','2008-01-10 00:00:00','Direct Transfer','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (40,96,3,4,'1','2009-12-14 00:00:00','Credit Card','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (41,174,1,4,'2','2009-01-21 00:00:00','Credit Card','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (42,101,2,2,'3','2009-12-15 00:00:00','Credit Card','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (43,176,3,3,'1','2009-03-05 00:00:00','Credit Card','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (44,134,1,2,'1','2009-12-13 00:00:00','Direct Transfer','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (45,67,2,4,'1','2009-01-10 00:00:00','Direct Transfer','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (46,78,3,1,'4','2009-12-13 00:00:00','Check','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (47,191,1,2,'3','2009-10-21 00:00:00','Credit Card','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (48,70,2,4,'1','2009-12-10 00:00:00','Credit Card','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (49,150,3,3,'1','2009-03-11 00:00:00','Credit Card','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), - (50,111,3,2,'2','2009-04-05 00:00:00','Check','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL); + (1,103,1,1,'1','2009-01-21 00:00:00','Check','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (2,182,2,2,'2','2008-05-07 00:00:00','Credit Card','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (3,15,3,3,'3','2008-05-05 00:00:00','Credit Card','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (4,185,1,4,'4','2008-10-21 00:00:00','Direct Transfer','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (5,166,2,1,'1','2008-01-10 00:00:00','Check','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (6,148,3,2,'2','2008-03-05 00:00:00','Direct Transfer','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (7,7,1,3,'3','2009-07-21 00:00:00','Direct Transfer','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (8,25,2,4,'4','2009-03-07 00:00:00','Credit Card','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (9,89,3,1,'1','2008-02-05 00:00:00','Direct Transfer','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (10,131,1,2,'2','2008-02-01 00:00:00','Check','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (11,54,2,3,'3','2009-01-10 00:00:00','Direct Transfer','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (12,176,3,4,'4','2009-03-06 00:00:00','Credit Card','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (13,180,1,1,'2','2008-06-04 00:00:00','Credit Card','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (14,2,2,2,'3','2008-01-10 00:00:00','Direct Transfer','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (15,135,3,4,'1','2008-07-04 00:00:00','Check','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (16,142,1,4,'2','2009-01-21 00:00:00','Credit Card','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (17,106,2,2,'3','2008-01-10 00:00:00','Credit Card','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (18,97,3,3,'1','2009-03-05 00:00:00','Credit Card','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (19,163,1,2,'1','2008-10-21 00:00:00','Direct Transfer','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (20,19,2,4,'1','2009-01-10 00:00:00','Credit Card','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (21,177,3,1,'4','2008-03-25 00:00:00','Check','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (22,82,1,2,'3','2009-10-21 00:00:00','Direct Transfer','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (23,56,2,4,'1','2008-01-10 00:00:00','Direct Transfer','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (24,156,3,3,'1','2008-03-11 00:00:00','Credit Card','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (25,12,3,2,'2','2008-04-05 00:00:00','Direct Transfer','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (26,170,1,1,'1','2009-01-21 00:00:00','Check','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (27,193,2,2,'2','2008-05-07 00:00:00','Credit Card','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (28,81,3,3,'3','2009-12-12 00:00:00','Direct Transfer','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (29,70,1,4,'4','2009-12-13 00:00:00','Credit Card','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (30,85,2,1,'1','2009-12-14 00:00:00','Direct Transfer','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (31,40,3,2,'2','2009-12-15 00:00:00','Credit Card','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (32,105,1,3,'3','2009-07-21 00:00:00','Check','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (33,169,2,4,'4','2009-03-07 00:00:00','Direct Transfer','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (34,112,3,1,'1','2009-12-15 00:00:00','Credit Card','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (35,192,1,2,'2','2009-12-13 00:00:00','Direct Transfer','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (36,120,2,3,'3','2009-01-10 00:00:00','Direct Transfer','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (37,83,3,4,'4','2009-03-06 00:00:00','Check','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (38,102,1,1,'2','2009-12-13 00:00:00','Direct Transfer','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (39,187,2,2,'3','2008-01-10 00:00:00','Direct Transfer','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (40,13,3,4,'1','2009-12-14 00:00:00','Credit Card','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (41,119,1,4,'2','2009-01-21 00:00:00','Credit Card','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (42,34,2,2,'3','2009-12-15 00:00:00','Credit Card','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (43,42,3,3,'1','2009-03-05 00:00:00','Credit Card','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (44,48,1,2,'1','2009-12-13 00:00:00','Direct Transfer','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (45,60,2,4,'1','2009-01-10 00:00:00','Direct Transfer','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (46,66,3,1,'4','2009-12-13 00:00:00','Check','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (47,190,1,2,'3','2009-10-21 00:00:00','Credit Card','Single',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (48,104,2,4,'1','2009-12-10 00:00:00','Credit Card','Soprano',0,0,50.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (49,159,3,3,'1','2009-03-11 00:00:00','Credit Card','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL), + (50,3,3,2,'2','2009-04-05 00:00:00','Check','Tiny-tots (ages 5-8)',0,0,800.00,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL); /*!40000 ALTER TABLE `civicrm_participant` ENABLE KEYS */; UNLOCK TABLES; @@ -6676,56 +6664,56 @@ UNLOCK TABLES; LOCK TABLES `civicrm_participant_payment` WRITE; /*!40000 ALTER TABLE `civicrm_participant_payment` DISABLE KEYS */; INSERT INTO `civicrm_participant_payment` (`id`, `participant_id`, `contribution_id`) VALUES - (1,1,63), - (2,2,64), - (3,3,65), - (4,4,66), - (5,5,67), - (6,6,68), - (7,7,69), + (1,14,63), + (2,50,64), + (3,7,65), + (4,25,66), + (5,40,67), + (6,3,68), + (7,20,69), (8,8,70), - (9,9,71), - (10,10,72), - (11,11,73), - (12,12,74), - (13,13,75), - (14,14,76), - (15,15,77), - (16,16,78), - (17,17,79), - (18,18,80), - (19,19,81), - (20,20,82), - (21,21,83), - (22,22,84), - (23,23,85), - (24,24,86), - (25,25,87), - (26,26,88), - (27,27,89), - (28,28,90), - (29,29,91), - (30,30,92), - (31,31,93), - (32,32,94), - (33,33,95), - (34,34,96), - (35,35,97), - (36,36,98), - (37,37,99), - (38,38,100), - (39,39,101), - (40,40,102), - (41,41,103), - (42,42,104), - (43,43,105), - (44,44,106), - (45,45,107), - (46,46,108), - (47,47,109), - (48,48,110), - (49,49,111), - (50,50,112); + (9,42,71), + (10,31,72), + (11,43,73), + (12,44,74), + (13,11,75), + (14,23,76), + (15,45,77), + (16,46,78), + (17,29,79), + (18,28,80), + (19,22,81), + (20,37,82), + (21,30,83), + (22,9,84), + (23,18,85), + (24,38,86), + (25,1,87), + (26,48,88), + (27,32,89), + (28,17,90), + (29,34,91), + (30,41,92), + (31,36,93), + (32,10,94), + (33,15,95), + (34,16,96), + (35,6,97), + (36,24,98), + (37,49,99), + (38,19,100), + (39,5,101), + (40,33,102), + (41,26,103), + (42,12,104), + (43,21,105), + (44,13,106), + (45,2,107), + (46,4,108), + (47,39,109), + (48,47,110), + (49,35,111), + (50,27,112); /*!40000 ALTER TABLE `civicrm_participant_payment` ENABLE KEYS */; UNLOCK TABLES; @@ -6799,7 +6787,7 @@ UNLOCK TABLES; LOCK TABLES `civicrm_pcp` WRITE; /*!40000 ALTER TABLE `civicrm_pcp` DISABLE KEYS */; INSERT INTO `civicrm_pcp` (`id`, `contact_id`, `status_id`, `title`, `intro_text`, `page_text`, `donate_link_text`, `page_id`, `page_type`, `pcp_block_id`, `is_thermometer`, `is_honor_roll`, `goal_amount`, `currency`, `is_active`, `is_notify`) VALUES - (1,22,2,'My Personal Civi Fundraiser','I\'m on a mission to get all my friends and family to help support my favorite open-source civic sector CRM.','

Friends and family - please help build much needed infrastructure for the civic sector by supporting my personal campaign!

\r\n

You can learn more about CiviCRM here.

\r\n

Then click the Contribute Now button to go to our easy-to-use online contribution form.

','Contribute Now',1,'contribute',1,1,1,5000.00,'USD',1,1); + (1,106,2,'My Personal Civi Fundraiser','I\'m on a mission to get all my friends and family to help support my favorite open-source civic sector CRM.','

Friends and family - please help build much needed infrastructure for the civic sector by supporting my personal campaign!

\r\n

You can learn more about CiviCRM here.

\r\n

Then click the Contribute Now button to go to our easy-to-use online contribution form.

','Contribute Now',1,'contribute',1,1,1,5000.00,'USD',1,1); /*!40000 ALTER TABLE `civicrm_pcp` ENABLE KEYS */; UNLOCK TABLES; @@ -6821,157 +6809,158 @@ UNLOCK TABLES; LOCK TABLES `civicrm_phone` WRITE; /*!40000 ALTER TABLE `civicrm_phone` DISABLE KEYS */; INSERT INTO `civicrm_phone` (`id`, `contact_id`, `location_type_id`, `is_primary`, `is_billing`, `mobile_provider_id`, `phone`, `phone_ext`, `phone_numeric`, `phone_type_id`) VALUES - (1,23,1,1,0,NULL,'708-3417',NULL,'7083417',2), - (2,23,1,0,0,NULL,'(279) 477-7352',NULL,'2794777352',2), - (3,65,1,1,0,NULL,'(603) 467-9930',NULL,'6034679930',2), - (4,22,1,1,0,NULL,'627-7356',NULL,'6277356',2), - (5,83,1,1,0,NULL,'294-7244',NULL,'2947244',2), - (6,83,1,0,0,NULL,'(747) 692-7780',NULL,'7476927780',2), - (7,197,1,1,0,NULL,'(425) 560-1332',NULL,'4255601332',1), - (8,161,1,1,0,NULL,'601-4338',NULL,'6014338',2), - (9,161,1,0,0,NULL,'(673) 734-6463',NULL,'6737346463',1), - (10,199,1,1,0,NULL,'637-6321',NULL,'6376321',2), - (11,199,1,0,0,NULL,'215-2253',NULL,'2152253',1), - (12,116,1,1,0,NULL,'(531) 337-3985',NULL,'5313373985',2), - (13,149,1,1,0,NULL,'548-9673',NULL,'5489673',2), - (14,149,1,0,0,NULL,'(416) 750-4367',NULL,'4167504367',2), - (15,100,1,1,0,NULL,'857-1600',NULL,'8571600',2), - (16,115,1,1,0,NULL,'(457) 386-6497',NULL,'4573866497',1), - (17,76,1,1,0,NULL,'500-2696',NULL,'5002696',2), - (18,76,1,0,0,NULL,'278-8782',NULL,'2788782',1), - (19,107,1,1,0,NULL,'(500) 770-2467',NULL,'5007702467',2), - (20,107,1,0,0,NULL,'738-7138',NULL,'7387138',2), - (21,28,1,1,0,NULL,'(689) 587-9122',NULL,'6895879122',2), - (22,54,1,1,0,NULL,'(447) 414-8609',NULL,'4474148609',2), - (23,54,1,0,0,NULL,'(214) 825-2121',NULL,'2148252121',1), - (24,9,1,1,0,NULL,'539-5902',NULL,'5395902',1), - (25,9,1,0,0,NULL,'(435) 478-4584',NULL,'4354784584',2), - (26,10,1,1,0,NULL,'703-5713',NULL,'7035713',1), - (27,160,1,1,0,NULL,'663-1557',NULL,'6631557',1), - (28,130,1,1,0,NULL,'(831) 433-3294',NULL,'8314333294',2), - (29,130,1,0,0,NULL,'852-1565',NULL,'8521565',1), - (30,77,1,1,0,NULL,'(874) 667-8284',NULL,'8746678284',1), - (31,77,1,0,0,NULL,'227-4193',NULL,'2274193',1), - (32,179,1,1,0,NULL,'(795) 320-6519',NULL,'7953206519',1), - (33,179,1,0,0,NULL,'401-1141',NULL,'4011141',1), - (34,45,1,1,0,NULL,'(846) 687-1000',NULL,'8466871000',2), - (35,132,1,1,0,NULL,'853-3743',NULL,'8533743',1), - (36,132,1,0,0,NULL,'834-6740',NULL,'8346740',1), - (37,151,1,1,0,NULL,'(298) 685-2041',NULL,'2986852041',1), - (38,101,1,1,0,NULL,'(277) 352-5501',NULL,'2773525501',1), - (39,101,1,0,0,NULL,'(758) 339-3813',NULL,'7583393813',2), - (40,172,1,1,0,NULL,'(720) 384-1997',NULL,'7203841997',2), - (41,123,1,1,0,NULL,'(728) 708-1019',NULL,'7287081019',2), - (42,196,1,1,0,NULL,'643-9661',NULL,'6439661',2), - (43,194,1,1,0,NULL,'(694) 610-2477',NULL,'6946102477',1), - (44,44,1,1,0,NULL,'293-4224',NULL,'2934224',2), - (45,88,1,1,0,NULL,'(485) 849-6183',NULL,'4858496183',2), - (46,88,1,0,0,NULL,'313-7367',NULL,'3137367',1), - (47,42,1,1,0,NULL,'233-1501',NULL,'2331501',1), - (48,42,1,0,0,NULL,'(780) 581-2509',NULL,'7805812509',1), - (49,91,1,1,0,NULL,'405-2611',NULL,'4052611',1), - (50,17,1,1,0,NULL,'488-2819',NULL,'4882819',1), - (51,75,1,1,0,NULL,'863-2240',NULL,'8632240',2), - (52,164,1,1,0,NULL,'(857) 792-4959',NULL,'8577924959',2), - (53,164,1,0,0,NULL,'(678) 356-2823',NULL,'6783562823',2), - (54,92,1,1,0,NULL,'227-2848',NULL,'2272848',1), - (55,13,1,1,0,NULL,'(468) 393-2241',NULL,'4683932241',1), - (56,103,1,1,0,NULL,'344-8654',NULL,'3448654',2), - (57,103,1,0,0,NULL,'(891) 802-6989',NULL,'8918026989',2), - (58,61,1,1,0,NULL,'(706) 223-9711',NULL,'7062239711',2), - (59,61,1,0,0,NULL,'660-5274',NULL,'6605274',1), - (60,174,1,1,0,NULL,'852-6011',NULL,'8526011',2), - (61,174,1,0,0,NULL,'(342) 504-3867',NULL,'3425043867',2), - (62,50,1,1,0,NULL,'859-9572',NULL,'8599572',1), - (63,175,1,1,0,NULL,'(552) 783-7598',NULL,'5527837598',1), - (64,25,1,1,0,NULL,'333-9488',NULL,'3339488',1), - (65,25,1,0,0,NULL,'547-9248',NULL,'5479248',2), - (66,39,1,1,0,NULL,'(513) 555-3476',NULL,'5135553476',1), - (67,198,1,1,0,NULL,'(681) 685-4997',NULL,'6816854997',1), - (68,5,1,1,0,NULL,'554-2204',NULL,'5542204',2), - (69,33,1,1,0,NULL,'(352) 263-1860',NULL,'3522631860',1), - (70,33,1,0,0,NULL,'(462) 300-9711',NULL,'4623009711',2), - (71,150,1,1,0,NULL,'534-9616',NULL,'5349616',1), - (72,150,1,0,0,NULL,'774-6634',NULL,'7746634',2), - (73,182,1,1,0,NULL,'(854) 482-5636',NULL,'8544825636',1), - (74,182,1,0,0,NULL,'458-8815',NULL,'4588815',2), - (75,7,1,1,0,NULL,'311-1778',NULL,'3111778',1), - (76,82,1,1,0,NULL,'(518) 461-6928',NULL,'5184616928',1), - (77,60,1,1,0,NULL,'(715) 587-6814',NULL,'7155876814',2), - (78,14,1,1,0,NULL,'(455) 225-6757',NULL,'4552256757',2), - (79,14,1,0,0,NULL,'(356) 387-9454',NULL,'3563879454',2), - (80,86,1,1,0,NULL,'386-7358',NULL,'3867358',1), - (81,86,1,0,0,NULL,'213-7429',NULL,'2137429',1), - (82,53,1,1,0,NULL,'(486) 407-2242',NULL,'4864072242',1), - (83,53,1,0,0,NULL,'728-9030',NULL,'7289030',1), - (84,145,1,1,0,NULL,'820-9924',NULL,'8209924',2), - (85,155,1,1,0,NULL,'(534) 495-3215',NULL,'5344953215',2), - (86,85,1,1,0,NULL,'477-3337',NULL,'4773337',2), - (87,85,1,0,0,NULL,'(656) 865-4964',NULL,'6568654964',1), - (88,154,1,1,0,NULL,'(290) 647-6227',NULL,'2906476227',1), - (89,176,1,1,0,NULL,'256-9211',NULL,'2569211',2), - (90,176,1,0,0,NULL,'(428) 384-2993',NULL,'4283842993',2), - (91,2,1,1,0,NULL,'822-1342',NULL,'8221342',2), - (92,117,1,1,0,NULL,'(452) 252-4613',NULL,'4522524613',2), - (93,117,1,0,0,NULL,'387-3364',NULL,'3873364',2), - (94,97,1,1,0,NULL,'(381) 223-3674',NULL,'3812233674',2), - (95,97,1,0,0,NULL,'502-8822',NULL,'5028822',2), - (96,89,1,1,0,NULL,'577-4274',NULL,'5774274',2), - (97,89,1,0,0,NULL,'257-8847',NULL,'2578847',2), - (98,168,1,1,0,NULL,'528-5079',NULL,'5285079',1), - (99,133,1,1,0,NULL,'429-4813',NULL,'4294813',2), - (100,133,1,0,0,NULL,'(549) 391-2605',NULL,'5493912605',2), - (101,46,1,1,0,NULL,'(896) 832-1932',NULL,'8968321932',1), - (102,46,1,0,0,NULL,'845-3253',NULL,'8453253',2), - (103,108,1,1,0,NULL,'527-5780',NULL,'5275780',2), - (104,108,1,0,0,NULL,'498-8218',NULL,'4988218',2), - (105,16,1,1,0,NULL,'(532) 294-4409',NULL,'5322944409',2), - (106,16,1,0,0,NULL,'252-1405',NULL,'2521405',2), - (107,166,1,1,0,NULL,'(548) 368-4937',NULL,'5483684937',1), - (108,135,1,1,0,NULL,'765-5855',NULL,'7655855',2), - (109,63,1,1,0,NULL,'579-5706',NULL,'5795706',2), - (110,63,1,0,0,NULL,'(300) 554-4792',NULL,'3005544792',2), - (111,11,1,1,0,NULL,'(606) 401-9865',NULL,'6064019865',1), - (112,11,1,0,0,NULL,'(828) 818-5288',NULL,'8288185288',2), - (113,134,1,1,0,NULL,'585-7273',NULL,'5857273',2), - (114,134,1,0,0,NULL,'(748) 376-5656',NULL,'7483765656',2), - (115,200,1,1,0,NULL,'726-5776',NULL,'7265776',1), - (116,200,1,0,0,NULL,'481-5231',NULL,'4815231',1), - (117,102,1,1,0,NULL,'(670) 605-7391',NULL,'6706057391',1), - (118,102,1,0,0,NULL,'272-9588',NULL,'2729588',1), - (119,118,1,1,0,NULL,'539-9451',NULL,'5399451',2), - (120,49,1,1,0,NULL,'(782) 303-8939',NULL,'7823038939',1), - (121,49,1,0,0,NULL,'(538) 766-4850',NULL,'5387664850',2), - (122,57,1,1,0,NULL,'(855) 623-9239',NULL,'8556239239',1), - (123,52,1,1,0,NULL,'668-9320',NULL,'6689320',1), - (124,140,1,1,0,NULL,'(289) 273-5548',NULL,'2892735548',2), - (125,48,1,1,0,NULL,'611-3177',NULL,'6113177',2), - (126,78,1,1,0,NULL,'521-3032',NULL,'5213032',2), - (127,78,1,0,0,NULL,'496-3759',NULL,'4963759',1), - (128,40,1,1,0,NULL,'541-2339',NULL,'5412339',2), - (129,104,1,1,0,NULL,'(852) 589-1991',NULL,'8525891991',1), - (130,69,1,1,0,NULL,'(729) 862-9416',NULL,'7298629416',1), - (131,35,1,1,0,NULL,'752-9455',NULL,'7529455',2), - (132,177,1,1,0,NULL,'(362) 740-4409',NULL,'3627404409',1), - (133,177,1,0,0,NULL,'837-8081',NULL,'8378081',2), - (134,72,1,1,0,NULL,'662-4365',NULL,'6624365',2), - (135,110,1,1,0,NULL,'(677) 792-6348',NULL,'6777926348',1), - (136,167,1,1,0,NULL,'730-5692',NULL,'7305692',2), - (137,167,1,0,0,NULL,'(798) 576-1662',NULL,'7985761662',2), - (138,18,1,1,0,NULL,'575-3640',NULL,'5753640',1), - (139,111,1,1,0,NULL,'(447) 481-4956',NULL,'4474814956',1), - (140,111,1,0,0,NULL,'(238) 545-1581',NULL,'2385451581',1), - (141,185,1,1,0,NULL,'598-6736',NULL,'5986736',1), - (142,158,1,1,0,NULL,'(547) 612-4358',NULL,'5476124358',1), - (143,158,1,0,0,NULL,'(360) 506-9362',NULL,'3605069362',2), - (144,192,1,1,0,NULL,'(773) 596-2304',NULL,'7735962304',2), - (145,192,1,0,0,NULL,'616-2704',NULL,'6162704',2), - (146,146,1,1,0,NULL,'735-2949',NULL,'7352949',2), - (147,26,1,1,0,NULL,'778-4613',NULL,'7784613',1), - (148,26,1,0,0,NULL,'(536) 569-4942',NULL,'5365694942',2), - (149,NULL,1,0,0,NULL,'204 222-1000',NULL,'2042221000',1), - (150,NULL,1,0,0,NULL,'204 223-1000',NULL,'2042231000',1), - (151,NULL,1,0,0,NULL,'303 323-1000',NULL,'3033231000',1); + (1,73,1,1,0,NULL,'816-8449',NULL,'8168449',2), + (2,77,1,1,0,NULL,'487-7910',NULL,'4877910',2), + (3,77,1,0,0,NULL,'827-4994',NULL,'8274994',1), + (4,133,1,1,0,NULL,'414-7744',NULL,'4147744',2), + (5,133,1,0,0,NULL,'893-2764',NULL,'8932764',1), + (6,14,1,1,0,NULL,'422-1587',NULL,'4221587',2), + (7,14,1,0,0,NULL,'(707) 214-7485',NULL,'7072147485',1), + (8,90,1,1,0,NULL,'565-9598',NULL,'5659598',1), + (9,90,1,0,0,NULL,'(812) 339-7369',NULL,'8123397369',2), + (10,135,1,1,0,NULL,'300-9051',NULL,'3009051',1), + (11,135,1,0,0,NULL,'662-3099',NULL,'6623099',1), + (12,47,1,1,0,NULL,'776-8454',NULL,'7768454',2), + (13,136,1,1,0,NULL,'(210) 764-5089',NULL,'2107645089',1), + (14,136,1,0,0,NULL,'569-8277',NULL,'5698277',2), + (15,26,1,1,0,NULL,'(204) 837-8082',NULL,'2048378082',2), + (16,139,1,1,0,NULL,'(206) 549-7393',NULL,'2065497393',2), + (17,86,1,1,0,NULL,'(201) 538-9391',NULL,'2015389391',2), + (18,86,1,0,0,NULL,'814-9214',NULL,'8149214',2), + (19,168,1,1,0,NULL,'614-6121',NULL,'6146121',2), + (20,78,1,1,0,NULL,'(473) 322-4496',NULL,'4733224496',2), + (21,78,1,0,0,NULL,'498-7905',NULL,'4987905',2), + (22,100,1,1,0,NULL,'(789) 316-8794',NULL,'7893168794',2), + (23,100,1,0,0,NULL,'(687) 727-5879',NULL,'6877275879',2), + (24,71,1,1,0,NULL,'(869) 837-2236',NULL,'8698372236',1), + (25,71,1,0,0,NULL,'(532) 255-5993',NULL,'5322555993',1), + (26,108,1,1,0,NULL,'(384) 439-2774',NULL,'3844392774',2), + (27,110,1,1,0,NULL,'(271) 755-8159',NULL,'2717558159',1), + (28,110,1,0,0,NULL,'(576) 637-9764',NULL,'5766379764',1), + (29,175,1,1,0,NULL,'768-5914',NULL,'7685914',1), + (30,175,1,0,0,NULL,'218-6918',NULL,'2186918',2), + (31,28,1,1,0,NULL,'(303) 375-5879',NULL,'3033755879',1), + (32,70,1,1,0,NULL,'331-4521',NULL,'3314521',2), + (33,70,1,0,0,NULL,'301-7673',NULL,'3017673',2), + (34,164,1,1,0,NULL,'892-3246',NULL,'8923246',1), + (35,101,1,1,0,NULL,'666-4869',NULL,'6664869',2), + (36,9,1,1,0,NULL,'687-8159',NULL,'6878159',1), + (37,9,1,0,0,NULL,'(837) 300-7569',NULL,'8373007569',2), + (38,138,1,1,0,NULL,'(737) 765-3386',NULL,'7377653386',1), + (39,2,1,1,0,NULL,'812-4086',NULL,'8124086',1), + (40,74,1,1,0,NULL,'831-1111',NULL,'8311111',1), + (41,10,1,1,0,NULL,'(890) 529-6377',NULL,'8905296377',1), + (42,141,1,1,0,NULL,'422-3547',NULL,'4223547',1), + (43,79,1,1,0,NULL,'(646) 227-3854',NULL,'6462273854',1), + (44,12,1,1,0,NULL,'349-4156',NULL,'3494156',1), + (45,12,1,0,0,NULL,'690-7785',NULL,'6907785',2), + (46,93,1,1,0,NULL,'828-4196',NULL,'8284196',1), + (47,93,1,0,0,NULL,'(413) 501-8996',NULL,'4135018996',2), + (48,66,1,1,0,NULL,'(359) 671-2715',NULL,'3596712715',2), + (49,66,1,0,0,NULL,'542-7245',NULL,'5427245',2), + (50,37,1,1,0,NULL,'(694) 534-1403',NULL,'6945341403',1), + (51,25,1,1,0,NULL,'535-3391',NULL,'5353391',2), + (52,27,1,1,0,NULL,'788-7675',NULL,'7887675',2), + (53,27,1,0,0,NULL,'(308) 412-2460',NULL,'3084122460',2), + (54,89,1,1,0,NULL,'245-6143',NULL,'2456143',2), + (55,89,1,0,0,NULL,'606-8481',NULL,'6068481',2), + (56,184,1,1,0,NULL,'(674) 352-3083',NULL,'6743523083',2), + (57,3,1,1,0,NULL,'627-8761',NULL,'6278761',1), + (58,146,1,1,0,NULL,'(269) 583-4157',NULL,'2695834157',1), + (59,146,1,0,0,NULL,'(762) 878-3935',NULL,'7628783935',2), + (60,55,1,1,0,NULL,'784-3399',NULL,'7843399',1), + (61,55,1,0,0,NULL,'(506) 632-5382',NULL,'5066325382',2), + (62,148,1,1,0,NULL,'(209) 596-8556',NULL,'2095968556',1), + (63,4,1,1,0,NULL,'(356) 624-1704',NULL,'3566241704',2), + (64,4,1,0,0,NULL,'683-2087',NULL,'6832087',2), + (65,41,1,1,0,NULL,'466-3426',NULL,'4663426',1), + (66,171,1,1,0,NULL,'(301) 805-6027',NULL,'3018056027',1), + (67,171,1,0,0,NULL,'611-7597',NULL,'6117597',2), + (68,81,1,1,0,NULL,'285-4654',NULL,'2854654',2), + (69,81,1,0,0,NULL,'(746) 420-1878',NULL,'7464201878',2), + (70,200,1,1,0,NULL,'(860) 447-8927',NULL,'8604478927',2), + (71,200,1,0,0,NULL,'477-3807',NULL,'4773807',2), + (72,84,1,1,0,NULL,'(750) 323-5557',NULL,'7503235557',1), + (73,84,1,0,0,NULL,'(490) 657-9257',NULL,'4906579257',1), + (74,64,1,1,0,NULL,'(576) 500-2298',NULL,'5765002298',2), + (75,64,1,0,0,NULL,'541-7349',NULL,'5417349',1), + (76,53,1,1,0,NULL,'(892) 883-8999',NULL,'8928838999',2), + (77,53,1,0,0,NULL,'(494) 364-8281',NULL,'4943648281',2), + (78,143,1,1,0,NULL,'(672) 444-5045',NULL,'6724445045',2), + (79,143,1,0,0,NULL,'(410) 699-8938',NULL,'4106998938',1), + (80,199,1,1,0,NULL,'(490) 249-8405',NULL,'4902498405',1), + (81,31,1,1,0,NULL,'(205) 673-2880',NULL,'2056732880',1), + (82,31,1,0,0,NULL,'(475) 801-2661',NULL,'4758012661',1), + (83,18,1,1,0,NULL,'(295) 246-3787',NULL,'2952463787',2), + (84,18,1,0,0,NULL,'503-3837',NULL,'5033837',2), + (85,56,1,1,0,NULL,'(881) 383-8811',NULL,'8813838811',2), + (86,20,1,1,0,NULL,'(643) 339-1472',NULL,'6433391472',2), + (87,150,1,1,0,NULL,'724-7681',NULL,'7247681',1), + (88,52,1,1,0,NULL,'(560) 509-9071',NULL,'5605099071',1), + (89,52,1,0,0,NULL,'(218) 462-2740',NULL,'2184622740',1), + (90,49,1,1,0,NULL,'775-6794',NULL,'7756794',2), + (91,128,1,1,0,NULL,'407-5965',NULL,'4075965',2), + (92,33,1,1,0,NULL,'635-5993',NULL,'6355993',1), + (93,33,1,0,0,NULL,'339-3327',NULL,'3393327',2), + (94,35,1,1,0,NULL,'(721) 347-6301',NULL,'7213476301',2), + (95,105,1,1,0,NULL,'(399) 435-5663',NULL,'3994355663',2), + (96,173,1,1,0,NULL,'773-2419',NULL,'7732419',1), + (97,119,1,1,0,NULL,'880-8371',NULL,'8808371',1), + (98,119,1,0,0,NULL,'247-4873',NULL,'2474873',1), + (99,103,1,1,0,NULL,'(665) 562-3463',NULL,'6655623463',2), + (100,97,1,1,0,NULL,'573-9494',NULL,'5739494',1), + (101,97,1,0,0,NULL,'418-9211',NULL,'4189211',1), + (102,149,1,1,0,NULL,'(357) 439-3800',NULL,'3574393800',1), + (103,149,1,0,0,NULL,'(235) 282-1891',NULL,'2352821891',2), + (104,190,1,1,0,NULL,'336-3410',NULL,'3363410',1), + (105,17,1,1,0,NULL,'307-9951',NULL,'3079951',1), + (106,32,1,1,0,NULL,'(202) 272-9127',NULL,'2022729127',1), + (107,60,1,1,0,NULL,'(213) 214-8895',NULL,'2132148895',1), + (108,60,1,0,0,NULL,'(343) 282-8632',NULL,'3432828632',2), + (109,29,1,1,0,NULL,'(395) 490-9439',NULL,'3954909439',2), + (110,94,1,1,0,NULL,'(652) 613-3664',NULL,'6526133664',1), + (111,95,1,1,0,NULL,'(523) 295-7983',NULL,'5232957983',2), + (112,95,1,0,0,NULL,'(295) 716-7439',NULL,'2957167439',2), + (113,82,1,1,0,NULL,'537-9607',NULL,'5379607',1), + (114,82,1,0,0,NULL,'578-4004',NULL,'5784004',1), + (115,197,1,1,0,NULL,'647-4185',NULL,'6474185',2), + (116,197,1,0,0,NULL,'677-4006',NULL,'6774006',1), + (117,7,1,1,0,NULL,'(803) 466-9992',NULL,'8034669992',2), + (118,130,1,1,0,NULL,'(790) 416-7026',NULL,'7904167026',2), + (119,130,1,0,0,NULL,'(277) 285-7525',NULL,'2772857525',1), + (120,96,1,1,0,NULL,'280-6840',NULL,'2806840',2), + (121,63,1,1,0,NULL,'538-2720',NULL,'5382720',1), + (122,38,1,1,0,NULL,'(348) 558-9068',NULL,'3485589068',1), + (123,151,1,1,0,NULL,'408-1270',NULL,'4081270',2), + (124,196,1,1,0,NULL,'897-6592',NULL,'8976592',1), + (125,153,1,1,0,NULL,'239-9154',NULL,'2399154',1), + (126,40,1,1,0,NULL,'(568) 858-2908',NULL,'5688582908',1), + (127,155,1,1,0,NULL,'(255) 819-1829',NULL,'2558191829',2), + (128,155,1,0,0,NULL,'579-6399',NULL,'5796399',2), + (129,112,1,1,0,NULL,'401-1932',NULL,'4011932',2), + (130,117,1,1,0,NULL,'526-9657',NULL,'5269657',1), + (131,109,1,1,0,NULL,'(403) 212-4516',NULL,'4032124516',2), + (132,185,1,1,0,NULL,'633-5732',NULL,'6335732',1), + (133,201,1,1,0,NULL,'577-3400',NULL,'5773400',1), + (134,201,1,0,0,NULL,'463-9704',NULL,'4639704',2), + (135,166,1,1,0,NULL,'241-5024',NULL,'2415024',1), + (136,166,1,0,0,NULL,'(318) 762-1387',NULL,'3187621387',1), + (137,169,1,1,0,NULL,'385-1427',NULL,'3851427',2), + (138,169,1,0,0,NULL,'310-7593',NULL,'3107593',1), + (139,192,1,1,0,NULL,'(552) 893-2461',NULL,'5528932461',2), + (140,192,1,0,0,NULL,'(389) 440-5588',NULL,'3894405588',1), + (141,194,1,1,0,NULL,'412-8972',NULL,'4128972',1), + (142,194,1,0,0,NULL,'288-7315',NULL,'2887315',1), + (143,83,1,1,0,NULL,'(353) 543-4243',NULL,'3535434243',2), + (144,57,1,1,0,NULL,'(650) 634-7684',NULL,'6506347684',2), + (145,125,1,1,0,NULL,'(812) 398-9519',NULL,'8123989519',2), + (146,19,1,1,0,NULL,'341-1044',NULL,'3411044',1), + (147,98,1,1,0,NULL,'(313) 663-1175',NULL,'3136631175',2), + (148,98,1,0,0,NULL,'288-3404',NULL,'2883404',2), + (149,177,1,1,0,NULL,'(601) 859-5894',NULL,'6018595894',2), + (150,NULL,1,0,0,NULL,'204 222-1000',NULL,'2042221000',1), + (151,NULL,1,0,0,NULL,'204 223-1000',NULL,'2042231000',1), + (152,NULL,1,0,0,NULL,'303 323-1000',NULL,'3033231000',1); /*!40000 ALTER TABLE `civicrm_phone` ENABLE KEYS */; UNLOCK TABLES; @@ -7206,220 +7195,220 @@ UNLOCK TABLES; LOCK TABLES `civicrm_relationship` WRITE; /*!40000 ALTER TABLE `civicrm_relationship` DISABLE KEYS */; INSERT INTO `civicrm_relationship` (`id`, `contact_id_a`, `contact_id_b`, `relationship_type_id`, `start_date`, `end_date`, `is_active`, `description`, `is_permission_a_b`, `is_permission_b_a`, `case_id`, `created_date`, `modified_date`) VALUES - (1,60,7,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (2,129,7,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (3,60,82,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (4,129,82,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (5,129,60,4,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (6,82,6,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (7,60,6,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (8,129,6,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (9,7,6,7,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (10,82,7,2,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (11,171,14,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (12,189,14,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (13,171,86,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (14,189,86,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (15,189,171,4,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (16,86,125,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (17,171,125,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (18,189,125,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (19,14,125,7,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (20,86,14,2,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (21,113,53,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (22,155,53,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (23,113,145,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (24,155,145,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (25,155,113,4,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (26,145,55,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (27,113,55,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (28,155,55,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (29,53,55,7,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (30,145,53,2,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (31,90,119,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (32,81,119,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (33,90,85,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (34,81,85,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (35,81,90,4,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (36,85,156,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (37,90,156,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (38,81,156,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (39,119,156,7,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (40,85,119,2,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (41,2,154,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (42,117,154,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (43,2,176,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (44,117,176,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (45,117,2,4,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (46,176,51,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (47,2,51,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (48,117,51,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (49,154,51,7,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (50,176,154,2,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (51,99,97,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (52,89,97,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (53,99,59,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (54,89,59,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (55,89,99,4,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (56,59,34,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (57,99,34,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (58,89,34,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (59,97,34,7,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (60,59,97,2,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (61,133,153,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (62,46,153,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (63,133,168,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (64,46,168,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (65,46,133,4,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (66,168,56,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (67,133,56,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (68,46,56,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (69,153,56,7,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (70,168,153,2,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (71,166,108,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (72,135,108,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (73,166,16,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (74,135,16,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (75,135,166,4,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (76,16,96,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (77,166,96,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (78,135,96,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (79,108,96,7,NULL,NULL,0,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (80,16,108,2,NULL,NULL,0,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (81,180,63,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (82,11,63,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (83,180,74,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (84,11,74,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (85,11,180,4,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (86,74,124,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (87,180,124,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (88,11,124,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (89,63,124,7,NULL,NULL,0,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (90,74,63,2,NULL,NULL,0,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (91,200,134,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (92,102,134,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (93,200,148,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (94,102,148,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (95,102,200,4,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (96,148,183,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (97,200,183,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (98,102,183,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (99,134,183,7,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (100,148,134,2,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (101,109,186,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (102,187,186,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (103,109,118,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (104,187,118,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (105,187,109,4,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (106,118,31,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (107,109,31,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (108,187,31,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (109,186,31,7,NULL,NULL,0,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (110,118,186,2,NULL,NULL,0,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (111,57,195,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (112,52,195,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (113,57,49,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (114,52,49,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (115,52,57,4,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (116,49,122,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (117,57,122,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (118,52,122,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (119,195,122,7,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (120,49,195,2,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (121,48,20,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (122,131,20,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (123,48,140,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (124,131,140,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (125,131,48,4,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (126,140,64,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (127,48,64,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (128,131,64,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (129,20,64,7,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (130,140,20,2,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (131,162,78,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (132,4,78,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (133,162,37,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (134,4,37,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (135,4,162,4,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (136,37,47,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (137,162,47,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (138,4,47,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (139,78,47,7,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (140,37,78,2,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (141,69,40,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (142,35,40,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (143,69,104,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (144,35,104,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (145,35,69,4,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (146,104,24,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (147,69,24,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (148,35,24,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (149,40,24,7,NULL,NULL,0,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (150,104,40,2,NULL,NULL,0,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (151,36,177,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (152,110,177,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (153,36,72,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (154,110,72,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (155,110,36,4,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (156,72,190,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (157,36,190,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (158,110,190,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (159,177,190,7,NULL,NULL,0,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (160,72,177,2,NULL,NULL,0,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (161,111,167,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (162,3,167,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (163,111,18,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (164,3,18,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (165,3,111,4,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (166,18,19,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (167,111,19,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (168,3,19,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (169,167,19,7,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (170,18,167,2,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (171,201,159,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (172,143,159,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (173,201,128,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (174,143,128,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (175,143,201,4,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (176,128,165,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (177,201,165,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (178,143,165,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (179,159,165,7,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (180,128,159,2,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (181,192,185,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (182,191,185,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (183,192,158,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (184,191,158,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (185,191,192,4,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (186,158,112,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (187,192,112,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (188,191,112,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (189,185,112,7,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (190,158,185,2,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (191,26,146,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (192,43,146,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (193,26,127,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (194,43,127,1,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (195,43,26,4,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (196,127,152,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (197,26,152,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (198,43,152,8,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (199,146,152,7,NULL,NULL,0,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (200,127,146,2,NULL,NULL,0,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (201,143,41,5,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (202,148,70,5,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (203,14,71,5,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (204,184,93,5,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (205,181,95,5,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (206,36,98,5,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (207,69,114,5,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (208,191,120,5,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (209,29,121,5,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (210,62,139,5,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (211,37,157,5,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (212,103,163,5,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (213,33,169,5,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'), - (214,182,173,5,NULL,NULL,1,NULL,0,0,NULL,'2022-05-04 18:47:23','2022-05-04 18:47:23'); + (1,150,20,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (2,102,20,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (3,150,156,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (4,102,156,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (5,102,150,4,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (6,156,51,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (7,150,51,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (8,102,51,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (9,20,51,7,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (10,156,20,2,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (11,128,52,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (12,44,52,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (13,128,49,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (14,44,49,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (15,44,128,4,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (16,49,172,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (17,128,172,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (18,44,172,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (19,52,172,7,NULL,NULL,0,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (20,49,52,2,NULL,NULL,0,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (21,118,33,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (22,186,33,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (23,118,35,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (24,186,35,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (25,186,118,4,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (26,35,140,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (27,118,140,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (28,186,140,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (29,33,140,7,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (30,35,33,2,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (31,105,129,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (32,173,129,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (33,105,158,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (34,173,158,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (35,173,105,4,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (36,158,13,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (37,105,13,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (38,173,13,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (39,129,13,7,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (40,158,129,2,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (41,103,119,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (42,97,119,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (43,103,134,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (44,97,134,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (45,97,103,4,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (46,134,45,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (47,103,45,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (48,97,45,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (49,119,45,7,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (50,134,119,2,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (51,180,75,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (52,114,75,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (53,180,149,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (54,114,149,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (55,114,180,4,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (56,149,161,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (57,180,161,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (58,114,161,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (59,75,161,7,NULL,NULL,0,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (60,149,75,2,NULL,NULL,0,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (61,32,190,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (62,60,190,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (63,32,17,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (64,60,17,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (65,60,32,4,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (66,17,67,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (67,32,67,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (68,60,67,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (69,190,67,7,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (70,17,190,2,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (71,94,72,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (72,95,72,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (73,94,29,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (74,95,29,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (75,95,94,4,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (76,29,8,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (77,94,8,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (78,95,8,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (79,72,8,7,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (80,29,72,2,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (81,7,82,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (82,43,82,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (83,7,197,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (84,43,197,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (85,43,7,4,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (86,197,176,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (87,7,176,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (88,43,176,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (89,82,176,7,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (90,197,82,2,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (91,96,130,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (92,63,130,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (93,96,23,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (94,63,23,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (95,63,96,4,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (96,23,5,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (97,96,5,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (98,63,5,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (99,130,5,7,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (100,23,130,2,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (101,174,68,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (102,42,68,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (103,174,38,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (104,42,38,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (105,42,174,4,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (106,38,69,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (107,174,69,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (108,42,69,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (109,68,69,7,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (110,38,68,2,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:37','2022-06-15 13:01:37'), + (111,24,151,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (112,153,151,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (113,24,196,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (114,153,196,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (115,153,24,4,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (116,196,183,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (117,24,183,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (118,153,183,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (119,151,183,7,NULL,NULL,0,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (120,196,151,2,NULL,NULL,0,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (121,170,40,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (122,155,40,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (123,170,137,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (124,155,137,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (125,155,170,4,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (126,137,157,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (127,170,157,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (128,155,157,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (129,40,157,7,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (130,137,40,2,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (131,117,198,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (132,109,198,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (133,117,112,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (134,109,112,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (135,109,117,4,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (136,112,76,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (137,117,76,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (138,109,76,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (139,198,76,7,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (140,112,198,2,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (141,87,179,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (142,115,179,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (143,87,147,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (144,115,147,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (145,115,87,4,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (146,147,131,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (147,87,131,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (148,115,131,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (149,179,131,7,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (150,147,179,2,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (151,185,91,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (152,201,91,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (153,185,154,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (154,201,154,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (155,201,185,4,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (156,154,160,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (157,185,160,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (158,201,160,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (159,91,160,7,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (160,154,91,2,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (161,166,120,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (162,169,120,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (163,166,15,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (164,169,15,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (165,169,166,4,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (166,15,181,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (167,166,181,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (168,169,181,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (169,120,181,7,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (170,15,120,2,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (171,194,22,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (172,83,22,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (173,194,192,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (174,83,192,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (175,83,194,4,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (176,192,39,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (177,194,39,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (178,83,39,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (179,22,39,7,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (180,192,22,2,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (181,19,57,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (182,121,57,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (183,19,125,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (184,121,125,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (185,121,19,4,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (186,125,50,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (187,19,50,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (188,121,50,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (189,57,50,7,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (190,125,57,2,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (191,98,16,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (192,177,16,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (193,98,54,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (194,177,54,1,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (195,177,98,4,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (196,54,182,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (197,98,182,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (198,177,182,8,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (199,16,182,7,NULL,NULL,0,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (200,54,16,2,NULL,NULL,0,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (201,166,21,5,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (202,30,34,5,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (203,18,48,5,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (204,89,61,5,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (205,138,80,5,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (206,129,99,5,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (207,43,113,5,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (208,185,116,5,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (209,58,122,5,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (210,155,124,5,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (211,91,126,5,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (212,187,152,5,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (213,190,163,5,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'), + (214,82,191,5,NULL,NULL,1,NULL,0,0,NULL,'2022-06-15 13:01:38','2022-06-15 13:01:38'); /*!40000 ALTER TABLE `civicrm_relationship` ENABLE KEYS */; UNLOCK TABLES; @@ -7430,434 +7419,434 @@ UNLOCK TABLES; LOCK TABLES `civicrm_relationship_cache` WRITE; /*!40000 ALTER TABLE `civicrm_relationship_cache` DISABLE KEYS */; INSERT INTO `civicrm_relationship_cache` (`id`, `relationship_id`, `relationship_type_id`, `orientation`, `near_contact_id`, `near_relation`, `far_contact_id`, `far_relation`, `is_active`, `start_date`, `end_date`, `case_id`) VALUES - (1,1,1,'a_b',60,'Child of',7,'Parent of',1,NULL,NULL,NULL), - (2,1,1,'b_a',7,'Parent of',60,'Child of',1,NULL,NULL,NULL), - (3,2,1,'a_b',129,'Child of',7,'Parent of',1,NULL,NULL,NULL), - (4,2,1,'b_a',7,'Parent of',129,'Child of',1,NULL,NULL,NULL), - (5,3,1,'a_b',60,'Child of',82,'Parent of',1,NULL,NULL,NULL), - (6,3,1,'b_a',82,'Parent of',60,'Child of',1,NULL,NULL,NULL), - (7,4,1,'a_b',129,'Child of',82,'Parent of',1,NULL,NULL,NULL), - (8,4,1,'b_a',82,'Parent of',129,'Child of',1,NULL,NULL,NULL), - (9,5,4,'a_b',129,'Sibling of',60,'Sibling of',1,NULL,NULL,NULL), - (10,5,4,'b_a',60,'Sibling of',129,'Sibling of',1,NULL,NULL,NULL), - (11,6,8,'a_b',82,'Household Member of',6,'Household Member is',1,NULL,NULL,NULL), - (12,6,8,'b_a',6,'Household Member is',82,'Household Member of',1,NULL,NULL,NULL), - (13,7,8,'a_b',60,'Household Member of',6,'Household Member is',1,NULL,NULL,NULL), - (14,7,8,'b_a',6,'Household Member is',60,'Household Member of',1,NULL,NULL,NULL), - (15,8,8,'a_b',129,'Household Member of',6,'Household Member is',1,NULL,NULL,NULL), - (16,8,8,'b_a',6,'Household Member is',129,'Household Member of',1,NULL,NULL,NULL), - (17,9,7,'a_b',7,'Head of Household for',6,'Head of Household is',1,NULL,NULL,NULL), - (18,9,7,'b_a',6,'Head of Household is',7,'Head of Household for',1,NULL,NULL,NULL), - (19,10,2,'a_b',82,'Spouse of',7,'Spouse of',1,NULL,NULL,NULL), - (20,10,2,'b_a',7,'Spouse of',82,'Spouse of',1,NULL,NULL,NULL), - (21,11,1,'a_b',171,'Child of',14,'Parent of',1,NULL,NULL,NULL), - (22,11,1,'b_a',14,'Parent of',171,'Child of',1,NULL,NULL,NULL), - (23,12,1,'a_b',189,'Child of',14,'Parent of',1,NULL,NULL,NULL), - (24,12,1,'b_a',14,'Parent of',189,'Child of',1,NULL,NULL,NULL), - (25,13,1,'a_b',171,'Child of',86,'Parent of',1,NULL,NULL,NULL), - (26,13,1,'b_a',86,'Parent of',171,'Child of',1,NULL,NULL,NULL), - (27,14,1,'a_b',189,'Child of',86,'Parent of',1,NULL,NULL,NULL), - (28,14,1,'b_a',86,'Parent of',189,'Child of',1,NULL,NULL,NULL), - (29,15,4,'a_b',189,'Sibling of',171,'Sibling of',1,NULL,NULL,NULL), - (30,15,4,'b_a',171,'Sibling of',189,'Sibling of',1,NULL,NULL,NULL), - (31,16,8,'a_b',86,'Household Member of',125,'Household Member is',1,NULL,NULL,NULL), - (32,16,8,'b_a',125,'Household Member is',86,'Household Member of',1,NULL,NULL,NULL), - (33,17,8,'a_b',171,'Household Member of',125,'Household Member is',1,NULL,NULL,NULL), - (34,17,8,'b_a',125,'Household Member is',171,'Household Member of',1,NULL,NULL,NULL), - (35,18,8,'a_b',189,'Household Member of',125,'Household Member is',1,NULL,NULL,NULL), - (36,18,8,'b_a',125,'Household Member is',189,'Household Member of',1,NULL,NULL,NULL), - (37,19,7,'a_b',14,'Head of Household for',125,'Head of Household is',1,NULL,NULL,NULL), - (38,19,7,'b_a',125,'Head of Household is',14,'Head of Household for',1,NULL,NULL,NULL), - (39,20,2,'a_b',86,'Spouse of',14,'Spouse of',1,NULL,NULL,NULL), - (40,20,2,'b_a',14,'Spouse of',86,'Spouse of',1,NULL,NULL,NULL), - (41,21,1,'a_b',113,'Child of',53,'Parent of',1,NULL,NULL,NULL), - (42,21,1,'b_a',53,'Parent of',113,'Child of',1,NULL,NULL,NULL), - (43,22,1,'a_b',155,'Child of',53,'Parent of',1,NULL,NULL,NULL), - (44,22,1,'b_a',53,'Parent of',155,'Child of',1,NULL,NULL,NULL), - (45,23,1,'a_b',113,'Child of',145,'Parent of',1,NULL,NULL,NULL), - (46,23,1,'b_a',145,'Parent of',113,'Child of',1,NULL,NULL,NULL), - (47,24,1,'a_b',155,'Child of',145,'Parent of',1,NULL,NULL,NULL), - (48,24,1,'b_a',145,'Parent of',155,'Child of',1,NULL,NULL,NULL), - (49,25,4,'a_b',155,'Sibling of',113,'Sibling of',1,NULL,NULL,NULL), - (50,25,4,'b_a',113,'Sibling of',155,'Sibling of',1,NULL,NULL,NULL), - (51,26,8,'a_b',145,'Household Member of',55,'Household Member is',1,NULL,NULL,NULL), - (52,26,8,'b_a',55,'Household Member is',145,'Household Member of',1,NULL,NULL,NULL), - (53,27,8,'a_b',113,'Household Member of',55,'Household Member is',1,NULL,NULL,NULL), - (54,27,8,'b_a',55,'Household Member is',113,'Household Member of',1,NULL,NULL,NULL), - (55,28,8,'a_b',155,'Household Member of',55,'Household Member is',1,NULL,NULL,NULL), - (56,28,8,'b_a',55,'Household Member is',155,'Household Member of',1,NULL,NULL,NULL), - (57,29,7,'a_b',53,'Head of Household for',55,'Head of Household is',1,NULL,NULL,NULL), - (58,29,7,'b_a',55,'Head of Household is',53,'Head of Household for',1,NULL,NULL,NULL), - (59,30,2,'a_b',145,'Spouse of',53,'Spouse of',1,NULL,NULL,NULL), - (60,30,2,'b_a',53,'Spouse of',145,'Spouse of',1,NULL,NULL,NULL), - (61,31,1,'a_b',90,'Child of',119,'Parent of',1,NULL,NULL,NULL), - (62,31,1,'b_a',119,'Parent of',90,'Child of',1,NULL,NULL,NULL), - (63,32,1,'a_b',81,'Child of',119,'Parent of',1,NULL,NULL,NULL), - (64,32,1,'b_a',119,'Parent of',81,'Child of',1,NULL,NULL,NULL), - (65,33,1,'a_b',90,'Child of',85,'Parent of',1,NULL,NULL,NULL), - (66,33,1,'b_a',85,'Parent of',90,'Child of',1,NULL,NULL,NULL), - (67,34,1,'a_b',81,'Child of',85,'Parent of',1,NULL,NULL,NULL), - (68,34,1,'b_a',85,'Parent of',81,'Child of',1,NULL,NULL,NULL), - (69,35,4,'a_b',81,'Sibling of',90,'Sibling of',1,NULL,NULL,NULL), - (70,35,4,'b_a',90,'Sibling of',81,'Sibling of',1,NULL,NULL,NULL), - (71,36,8,'a_b',85,'Household Member of',156,'Household Member is',1,NULL,NULL,NULL), - (72,36,8,'b_a',156,'Household Member is',85,'Household Member of',1,NULL,NULL,NULL), - (73,37,8,'a_b',90,'Household Member of',156,'Household Member is',1,NULL,NULL,NULL), - (74,37,8,'b_a',156,'Household Member is',90,'Household Member of',1,NULL,NULL,NULL), - (75,38,8,'a_b',81,'Household Member of',156,'Household Member is',1,NULL,NULL,NULL), - (76,38,8,'b_a',156,'Household Member is',81,'Household Member of',1,NULL,NULL,NULL), - (77,39,7,'a_b',119,'Head of Household for',156,'Head of Household is',1,NULL,NULL,NULL), - (78,39,7,'b_a',156,'Head of Household is',119,'Head of Household for',1,NULL,NULL,NULL), - (79,40,2,'a_b',85,'Spouse of',119,'Spouse of',1,NULL,NULL,NULL), - (80,40,2,'b_a',119,'Spouse of',85,'Spouse of',1,NULL,NULL,NULL), - (81,41,1,'a_b',2,'Child of',154,'Parent of',1,NULL,NULL,NULL), - (82,41,1,'b_a',154,'Parent of',2,'Child of',1,NULL,NULL,NULL), - (83,42,1,'a_b',117,'Child of',154,'Parent of',1,NULL,NULL,NULL), - (84,42,1,'b_a',154,'Parent of',117,'Child of',1,NULL,NULL,NULL), - (85,43,1,'a_b',2,'Child of',176,'Parent of',1,NULL,NULL,NULL), - (86,43,1,'b_a',176,'Parent of',2,'Child of',1,NULL,NULL,NULL), - (87,44,1,'a_b',117,'Child of',176,'Parent of',1,NULL,NULL,NULL), - (88,44,1,'b_a',176,'Parent of',117,'Child of',1,NULL,NULL,NULL), - (89,45,4,'a_b',117,'Sibling of',2,'Sibling of',1,NULL,NULL,NULL), - (90,45,4,'b_a',2,'Sibling of',117,'Sibling of',1,NULL,NULL,NULL), - (91,46,8,'a_b',176,'Household Member of',51,'Household Member is',1,NULL,NULL,NULL), - (92,46,8,'b_a',51,'Household Member is',176,'Household Member of',1,NULL,NULL,NULL), - (93,47,8,'a_b',2,'Household Member of',51,'Household Member is',1,NULL,NULL,NULL), - (94,47,8,'b_a',51,'Household Member is',2,'Household Member of',1,NULL,NULL,NULL), - (95,48,8,'a_b',117,'Household Member of',51,'Household Member is',1,NULL,NULL,NULL), - (96,48,8,'b_a',51,'Household Member is',117,'Household Member of',1,NULL,NULL,NULL), - (97,49,7,'a_b',154,'Head of Household for',51,'Head of Household is',1,NULL,NULL,NULL), - (98,49,7,'b_a',51,'Head of Household is',154,'Head of Household for',1,NULL,NULL,NULL), - (99,50,2,'a_b',176,'Spouse of',154,'Spouse of',1,NULL,NULL,NULL), - (100,50,2,'b_a',154,'Spouse of',176,'Spouse of',1,NULL,NULL,NULL), - (101,51,1,'a_b',99,'Child of',97,'Parent of',1,NULL,NULL,NULL), - (102,51,1,'b_a',97,'Parent of',99,'Child of',1,NULL,NULL,NULL), - (103,52,1,'a_b',89,'Child of',97,'Parent of',1,NULL,NULL,NULL), - (104,52,1,'b_a',97,'Parent of',89,'Child of',1,NULL,NULL,NULL), - (105,53,1,'a_b',99,'Child of',59,'Parent of',1,NULL,NULL,NULL), - (106,53,1,'b_a',59,'Parent of',99,'Child of',1,NULL,NULL,NULL), - (107,54,1,'a_b',89,'Child of',59,'Parent of',1,NULL,NULL,NULL), - (108,54,1,'b_a',59,'Parent of',89,'Child of',1,NULL,NULL,NULL), - (109,55,4,'a_b',89,'Sibling of',99,'Sibling of',1,NULL,NULL,NULL), - (110,55,4,'b_a',99,'Sibling of',89,'Sibling of',1,NULL,NULL,NULL), - (111,56,8,'a_b',59,'Household Member of',34,'Household Member is',1,NULL,NULL,NULL), - (112,56,8,'b_a',34,'Household Member is',59,'Household Member of',1,NULL,NULL,NULL), - (113,57,8,'a_b',99,'Household Member of',34,'Household Member is',1,NULL,NULL,NULL), - (114,57,8,'b_a',34,'Household Member is',99,'Household Member of',1,NULL,NULL,NULL), - (115,58,8,'a_b',89,'Household Member of',34,'Household Member is',1,NULL,NULL,NULL), - (116,58,8,'b_a',34,'Household Member is',89,'Household Member of',1,NULL,NULL,NULL), - (117,59,7,'a_b',97,'Head of Household for',34,'Head of Household is',1,NULL,NULL,NULL), - (118,59,7,'b_a',34,'Head of Household is',97,'Head of Household for',1,NULL,NULL,NULL), - (119,60,2,'a_b',59,'Spouse of',97,'Spouse of',1,NULL,NULL,NULL), - (120,60,2,'b_a',97,'Spouse of',59,'Spouse of',1,NULL,NULL,NULL), - (121,61,1,'a_b',133,'Child of',153,'Parent of',1,NULL,NULL,NULL), - (122,61,1,'b_a',153,'Parent of',133,'Child of',1,NULL,NULL,NULL), - (123,62,1,'a_b',46,'Child of',153,'Parent of',1,NULL,NULL,NULL), - (124,62,1,'b_a',153,'Parent of',46,'Child of',1,NULL,NULL,NULL), - (125,63,1,'a_b',133,'Child of',168,'Parent of',1,NULL,NULL,NULL), - (126,63,1,'b_a',168,'Parent of',133,'Child of',1,NULL,NULL,NULL), - (127,64,1,'a_b',46,'Child of',168,'Parent of',1,NULL,NULL,NULL), - (128,64,1,'b_a',168,'Parent of',46,'Child of',1,NULL,NULL,NULL), - (129,65,4,'a_b',46,'Sibling of',133,'Sibling of',1,NULL,NULL,NULL), - (130,65,4,'b_a',133,'Sibling of',46,'Sibling of',1,NULL,NULL,NULL), - (131,66,8,'a_b',168,'Household Member of',56,'Household Member is',1,NULL,NULL,NULL), - (132,66,8,'b_a',56,'Household Member is',168,'Household Member of',1,NULL,NULL,NULL), - (133,67,8,'a_b',133,'Household Member of',56,'Household Member is',1,NULL,NULL,NULL), - (134,67,8,'b_a',56,'Household Member is',133,'Household Member of',1,NULL,NULL,NULL), - (135,68,8,'a_b',46,'Household Member of',56,'Household Member is',1,NULL,NULL,NULL), - (136,68,8,'b_a',56,'Household Member is',46,'Household Member of',1,NULL,NULL,NULL), - (137,69,7,'a_b',153,'Head of Household for',56,'Head of Household is',1,NULL,NULL,NULL), - (138,69,7,'b_a',56,'Head of Household is',153,'Head of Household for',1,NULL,NULL,NULL), - (139,70,2,'a_b',168,'Spouse of',153,'Spouse of',1,NULL,NULL,NULL), - (140,70,2,'b_a',153,'Spouse of',168,'Spouse of',1,NULL,NULL,NULL), - (141,71,1,'a_b',166,'Child of',108,'Parent of',1,NULL,NULL,NULL), - (142,71,1,'b_a',108,'Parent of',166,'Child of',1,NULL,NULL,NULL), - (143,72,1,'a_b',135,'Child of',108,'Parent of',1,NULL,NULL,NULL), - (144,72,1,'b_a',108,'Parent of',135,'Child of',1,NULL,NULL,NULL), - (145,73,1,'a_b',166,'Child of',16,'Parent of',1,NULL,NULL,NULL), - (146,73,1,'b_a',16,'Parent of',166,'Child of',1,NULL,NULL,NULL), - (147,74,1,'a_b',135,'Child of',16,'Parent of',1,NULL,NULL,NULL), - (148,74,1,'b_a',16,'Parent of',135,'Child of',1,NULL,NULL,NULL), - (149,75,4,'a_b',135,'Sibling of',166,'Sibling of',1,NULL,NULL,NULL), - (150,75,4,'b_a',166,'Sibling of',135,'Sibling of',1,NULL,NULL,NULL), - (151,76,8,'a_b',16,'Household Member of',96,'Household Member is',1,NULL,NULL,NULL), - (152,76,8,'b_a',96,'Household Member is',16,'Household Member of',1,NULL,NULL,NULL), - (153,77,8,'a_b',166,'Household Member of',96,'Household Member is',1,NULL,NULL,NULL), - (154,77,8,'b_a',96,'Household Member is',166,'Household Member of',1,NULL,NULL,NULL), - (155,78,8,'a_b',135,'Household Member of',96,'Household Member is',1,NULL,NULL,NULL), - (156,78,8,'b_a',96,'Household Member is',135,'Household Member of',1,NULL,NULL,NULL), - (157,79,7,'a_b',108,'Head of Household for',96,'Head of Household is',0,NULL,NULL,NULL), - (158,79,7,'b_a',96,'Head of Household is',108,'Head of Household for',0,NULL,NULL,NULL), - (159,80,2,'a_b',16,'Spouse of',108,'Spouse of',0,NULL,NULL,NULL), - (160,80,2,'b_a',108,'Spouse of',16,'Spouse of',0,NULL,NULL,NULL), - (161,81,1,'a_b',180,'Child of',63,'Parent of',1,NULL,NULL,NULL), - (162,81,1,'b_a',63,'Parent of',180,'Child of',1,NULL,NULL,NULL), - (163,82,1,'a_b',11,'Child of',63,'Parent of',1,NULL,NULL,NULL), - (164,82,1,'b_a',63,'Parent of',11,'Child of',1,NULL,NULL,NULL), - (165,83,1,'a_b',180,'Child of',74,'Parent of',1,NULL,NULL,NULL), - (166,83,1,'b_a',74,'Parent of',180,'Child of',1,NULL,NULL,NULL), - (167,84,1,'a_b',11,'Child of',74,'Parent of',1,NULL,NULL,NULL), - (168,84,1,'b_a',74,'Parent of',11,'Child of',1,NULL,NULL,NULL), - (169,85,4,'a_b',11,'Sibling of',180,'Sibling of',1,NULL,NULL,NULL), - (170,85,4,'b_a',180,'Sibling of',11,'Sibling of',1,NULL,NULL,NULL), - (171,86,8,'a_b',74,'Household Member of',124,'Household Member is',1,NULL,NULL,NULL), - (172,86,8,'b_a',124,'Household Member is',74,'Household Member of',1,NULL,NULL,NULL), - (173,87,8,'a_b',180,'Household Member of',124,'Household Member is',1,NULL,NULL,NULL), - (174,87,8,'b_a',124,'Household Member is',180,'Household Member of',1,NULL,NULL,NULL), - (175,88,8,'a_b',11,'Household Member of',124,'Household Member is',1,NULL,NULL,NULL), - (176,88,8,'b_a',124,'Household Member is',11,'Household Member of',1,NULL,NULL,NULL), - (177,89,7,'a_b',63,'Head of Household for',124,'Head of Household is',0,NULL,NULL,NULL), - (178,89,7,'b_a',124,'Head of Household is',63,'Head of Household for',0,NULL,NULL,NULL), - (179,90,2,'a_b',74,'Spouse of',63,'Spouse of',0,NULL,NULL,NULL), - (180,90,2,'b_a',63,'Spouse of',74,'Spouse of',0,NULL,NULL,NULL), - (181,91,1,'a_b',200,'Child of',134,'Parent of',1,NULL,NULL,NULL), - (182,91,1,'b_a',134,'Parent of',200,'Child of',1,NULL,NULL,NULL), - (183,92,1,'a_b',102,'Child of',134,'Parent of',1,NULL,NULL,NULL), - (184,92,1,'b_a',134,'Parent of',102,'Child of',1,NULL,NULL,NULL), - (185,93,1,'a_b',200,'Child of',148,'Parent of',1,NULL,NULL,NULL), - (186,93,1,'b_a',148,'Parent of',200,'Child of',1,NULL,NULL,NULL), - (187,94,1,'a_b',102,'Child of',148,'Parent of',1,NULL,NULL,NULL), - (188,94,1,'b_a',148,'Parent of',102,'Child of',1,NULL,NULL,NULL), - (189,95,4,'a_b',102,'Sibling of',200,'Sibling of',1,NULL,NULL,NULL), - (190,95,4,'b_a',200,'Sibling of',102,'Sibling of',1,NULL,NULL,NULL), - (191,96,8,'a_b',148,'Household Member of',183,'Household Member is',1,NULL,NULL,NULL), - (192,96,8,'b_a',183,'Household Member is',148,'Household Member of',1,NULL,NULL,NULL), - (193,97,8,'a_b',200,'Household Member of',183,'Household Member is',1,NULL,NULL,NULL), - (194,97,8,'b_a',183,'Household Member is',200,'Household Member of',1,NULL,NULL,NULL), - (195,98,8,'a_b',102,'Household Member of',183,'Household Member is',1,NULL,NULL,NULL), - (196,98,8,'b_a',183,'Household Member is',102,'Household Member of',1,NULL,NULL,NULL), - (197,99,7,'a_b',134,'Head of Household for',183,'Head of Household is',1,NULL,NULL,NULL), - (198,99,7,'b_a',183,'Head of Household is',134,'Head of Household for',1,NULL,NULL,NULL), - (199,100,2,'a_b',148,'Spouse of',134,'Spouse of',1,NULL,NULL,NULL), - (200,100,2,'b_a',134,'Spouse of',148,'Spouse of',1,NULL,NULL,NULL), - (201,101,1,'a_b',109,'Child of',186,'Parent of',1,NULL,NULL,NULL), - (202,101,1,'b_a',186,'Parent of',109,'Child of',1,NULL,NULL,NULL), - (203,102,1,'a_b',187,'Child of',186,'Parent of',1,NULL,NULL,NULL), - (204,102,1,'b_a',186,'Parent of',187,'Child of',1,NULL,NULL,NULL), - (205,103,1,'a_b',109,'Child of',118,'Parent of',1,NULL,NULL,NULL), - (206,103,1,'b_a',118,'Parent of',109,'Child of',1,NULL,NULL,NULL), - (207,104,1,'a_b',187,'Child of',118,'Parent of',1,NULL,NULL,NULL), - (208,104,1,'b_a',118,'Parent of',187,'Child of',1,NULL,NULL,NULL), - (209,105,4,'a_b',187,'Sibling of',109,'Sibling of',1,NULL,NULL,NULL), - (210,105,4,'b_a',109,'Sibling of',187,'Sibling of',1,NULL,NULL,NULL), - (211,106,8,'a_b',118,'Household Member of',31,'Household Member is',1,NULL,NULL,NULL), - (212,106,8,'b_a',31,'Household Member is',118,'Household Member of',1,NULL,NULL,NULL), - (213,107,8,'a_b',109,'Household Member of',31,'Household Member is',1,NULL,NULL,NULL), - (214,107,8,'b_a',31,'Household Member is',109,'Household Member of',1,NULL,NULL,NULL), - (215,108,8,'a_b',187,'Household Member of',31,'Household Member is',1,NULL,NULL,NULL), - (216,108,8,'b_a',31,'Household Member is',187,'Household Member of',1,NULL,NULL,NULL), - (217,109,7,'a_b',186,'Head of Household for',31,'Head of Household is',0,NULL,NULL,NULL), - (218,109,7,'b_a',31,'Head of Household is',186,'Head of Household for',0,NULL,NULL,NULL), - (219,110,2,'a_b',118,'Spouse of',186,'Spouse of',0,NULL,NULL,NULL), - (220,110,2,'b_a',186,'Spouse of',118,'Spouse of',0,NULL,NULL,NULL), - (221,111,1,'a_b',57,'Child of',195,'Parent of',1,NULL,NULL,NULL), - (222,111,1,'b_a',195,'Parent of',57,'Child of',1,NULL,NULL,NULL), - (223,112,1,'a_b',52,'Child of',195,'Parent of',1,NULL,NULL,NULL), - (224,112,1,'b_a',195,'Parent of',52,'Child of',1,NULL,NULL,NULL), - (225,113,1,'a_b',57,'Child of',49,'Parent of',1,NULL,NULL,NULL), - (226,113,1,'b_a',49,'Parent of',57,'Child of',1,NULL,NULL,NULL), - (227,114,1,'a_b',52,'Child of',49,'Parent of',1,NULL,NULL,NULL), - (228,114,1,'b_a',49,'Parent of',52,'Child of',1,NULL,NULL,NULL), - (229,115,4,'a_b',52,'Sibling of',57,'Sibling of',1,NULL,NULL,NULL), - (230,115,4,'b_a',57,'Sibling of',52,'Sibling of',1,NULL,NULL,NULL), - (231,116,8,'a_b',49,'Household Member of',122,'Household Member is',1,NULL,NULL,NULL), - (232,116,8,'b_a',122,'Household Member is',49,'Household Member of',1,NULL,NULL,NULL), - (233,117,8,'a_b',57,'Household Member of',122,'Household Member is',1,NULL,NULL,NULL), - (234,117,8,'b_a',122,'Household Member is',57,'Household Member of',1,NULL,NULL,NULL), - (235,118,8,'a_b',52,'Household Member of',122,'Household Member is',1,NULL,NULL,NULL), - (236,118,8,'b_a',122,'Household Member is',52,'Household Member of',1,NULL,NULL,NULL), - (237,119,7,'a_b',195,'Head of Household for',122,'Head of Household is',1,NULL,NULL,NULL), - (238,119,7,'b_a',122,'Head of Household is',195,'Head of Household for',1,NULL,NULL,NULL), - (239,120,2,'a_b',49,'Spouse of',195,'Spouse of',1,NULL,NULL,NULL), - (240,120,2,'b_a',195,'Spouse of',49,'Spouse of',1,NULL,NULL,NULL), - (241,121,1,'a_b',48,'Child of',20,'Parent of',1,NULL,NULL,NULL), - (242,121,1,'b_a',20,'Parent of',48,'Child of',1,NULL,NULL,NULL), - (243,122,1,'a_b',131,'Child of',20,'Parent of',1,NULL,NULL,NULL), - (244,122,1,'b_a',20,'Parent of',131,'Child of',1,NULL,NULL,NULL), - (245,123,1,'a_b',48,'Child of',140,'Parent of',1,NULL,NULL,NULL), - (246,123,1,'b_a',140,'Parent of',48,'Child of',1,NULL,NULL,NULL), - (247,124,1,'a_b',131,'Child of',140,'Parent of',1,NULL,NULL,NULL), - (248,124,1,'b_a',140,'Parent of',131,'Child of',1,NULL,NULL,NULL), - (249,125,4,'a_b',131,'Sibling of',48,'Sibling of',1,NULL,NULL,NULL), - (250,125,4,'b_a',48,'Sibling of',131,'Sibling of',1,NULL,NULL,NULL), - (251,126,8,'a_b',140,'Household Member of',64,'Household Member is',1,NULL,NULL,NULL), - (252,126,8,'b_a',64,'Household Member is',140,'Household Member of',1,NULL,NULL,NULL), - (253,127,8,'a_b',48,'Household Member of',64,'Household Member is',1,NULL,NULL,NULL), - (254,127,8,'b_a',64,'Household Member is',48,'Household Member of',1,NULL,NULL,NULL), - (255,128,8,'a_b',131,'Household Member of',64,'Household Member is',1,NULL,NULL,NULL), - (256,128,8,'b_a',64,'Household Member is',131,'Household Member of',1,NULL,NULL,NULL), - (257,129,7,'a_b',20,'Head of Household for',64,'Head of Household is',1,NULL,NULL,NULL), - (258,129,7,'b_a',64,'Head of Household is',20,'Head of Household for',1,NULL,NULL,NULL), - (259,130,2,'a_b',140,'Spouse of',20,'Spouse of',1,NULL,NULL,NULL), - (260,130,2,'b_a',20,'Spouse of',140,'Spouse of',1,NULL,NULL,NULL), - (261,131,1,'a_b',162,'Child of',78,'Parent of',1,NULL,NULL,NULL), - (262,131,1,'b_a',78,'Parent of',162,'Child of',1,NULL,NULL,NULL), - (263,132,1,'a_b',4,'Child of',78,'Parent of',1,NULL,NULL,NULL), - (264,132,1,'b_a',78,'Parent of',4,'Child of',1,NULL,NULL,NULL), - (265,133,1,'a_b',162,'Child of',37,'Parent of',1,NULL,NULL,NULL), - (266,133,1,'b_a',37,'Parent of',162,'Child of',1,NULL,NULL,NULL), - (267,134,1,'a_b',4,'Child of',37,'Parent of',1,NULL,NULL,NULL), - (268,134,1,'b_a',37,'Parent of',4,'Child of',1,NULL,NULL,NULL), - (269,135,4,'a_b',4,'Sibling of',162,'Sibling of',1,NULL,NULL,NULL), - (270,135,4,'b_a',162,'Sibling of',4,'Sibling of',1,NULL,NULL,NULL), - (271,136,8,'a_b',37,'Household Member of',47,'Household Member is',1,NULL,NULL,NULL), - (272,136,8,'b_a',47,'Household Member is',37,'Household Member of',1,NULL,NULL,NULL), - (273,137,8,'a_b',162,'Household Member of',47,'Household Member is',1,NULL,NULL,NULL), - (274,137,8,'b_a',47,'Household Member is',162,'Household Member of',1,NULL,NULL,NULL), - (275,138,8,'a_b',4,'Household Member of',47,'Household Member is',1,NULL,NULL,NULL), - (276,138,8,'b_a',47,'Household Member is',4,'Household Member of',1,NULL,NULL,NULL), - (277,139,7,'a_b',78,'Head of Household for',47,'Head of Household is',1,NULL,NULL,NULL), - (278,139,7,'b_a',47,'Head of Household is',78,'Head of Household for',1,NULL,NULL,NULL), - (279,140,2,'a_b',37,'Spouse of',78,'Spouse of',1,NULL,NULL,NULL), - (280,140,2,'b_a',78,'Spouse of',37,'Spouse of',1,NULL,NULL,NULL), - (281,141,1,'a_b',69,'Child of',40,'Parent of',1,NULL,NULL,NULL), - (282,141,1,'b_a',40,'Parent of',69,'Child of',1,NULL,NULL,NULL), - (283,142,1,'a_b',35,'Child of',40,'Parent of',1,NULL,NULL,NULL), - (284,142,1,'b_a',40,'Parent of',35,'Child of',1,NULL,NULL,NULL), - (285,143,1,'a_b',69,'Child of',104,'Parent of',1,NULL,NULL,NULL), - (286,143,1,'b_a',104,'Parent of',69,'Child of',1,NULL,NULL,NULL), - (287,144,1,'a_b',35,'Child of',104,'Parent of',1,NULL,NULL,NULL), - (288,144,1,'b_a',104,'Parent of',35,'Child of',1,NULL,NULL,NULL), - (289,145,4,'a_b',35,'Sibling of',69,'Sibling of',1,NULL,NULL,NULL), - (290,145,4,'b_a',69,'Sibling of',35,'Sibling of',1,NULL,NULL,NULL), - (291,146,8,'a_b',104,'Household Member of',24,'Household Member is',1,NULL,NULL,NULL), - (292,146,8,'b_a',24,'Household Member is',104,'Household Member of',1,NULL,NULL,NULL), - (293,147,8,'a_b',69,'Household Member of',24,'Household Member is',1,NULL,NULL,NULL), - (294,147,8,'b_a',24,'Household Member is',69,'Household Member of',1,NULL,NULL,NULL), - (295,148,8,'a_b',35,'Household Member of',24,'Household Member is',1,NULL,NULL,NULL), - (296,148,8,'b_a',24,'Household Member is',35,'Household Member of',1,NULL,NULL,NULL), - (297,149,7,'a_b',40,'Head of Household for',24,'Head of Household is',0,NULL,NULL,NULL), - (298,149,7,'b_a',24,'Head of Household is',40,'Head of Household for',0,NULL,NULL,NULL), - (299,150,2,'a_b',104,'Spouse of',40,'Spouse of',0,NULL,NULL,NULL), - (300,150,2,'b_a',40,'Spouse of',104,'Spouse of',0,NULL,NULL,NULL), - (301,151,1,'a_b',36,'Child of',177,'Parent of',1,NULL,NULL,NULL), - (302,151,1,'b_a',177,'Parent of',36,'Child of',1,NULL,NULL,NULL), - (303,152,1,'a_b',110,'Child of',177,'Parent of',1,NULL,NULL,NULL), - (304,152,1,'b_a',177,'Parent of',110,'Child of',1,NULL,NULL,NULL), - (305,153,1,'a_b',36,'Child of',72,'Parent of',1,NULL,NULL,NULL), - (306,153,1,'b_a',72,'Parent of',36,'Child of',1,NULL,NULL,NULL), - (307,154,1,'a_b',110,'Child of',72,'Parent of',1,NULL,NULL,NULL), - (308,154,1,'b_a',72,'Parent of',110,'Child of',1,NULL,NULL,NULL), - (309,155,4,'a_b',110,'Sibling of',36,'Sibling of',1,NULL,NULL,NULL), - (310,155,4,'b_a',36,'Sibling of',110,'Sibling of',1,NULL,NULL,NULL), - (311,156,8,'a_b',72,'Household Member of',190,'Household Member is',1,NULL,NULL,NULL), - (312,156,8,'b_a',190,'Household Member is',72,'Household Member of',1,NULL,NULL,NULL), - (313,157,8,'a_b',36,'Household Member of',190,'Household Member is',1,NULL,NULL,NULL), - (314,157,8,'b_a',190,'Household Member is',36,'Household Member of',1,NULL,NULL,NULL), - (315,158,8,'a_b',110,'Household Member of',190,'Household Member is',1,NULL,NULL,NULL), - (316,158,8,'b_a',190,'Household Member is',110,'Household Member of',1,NULL,NULL,NULL), - (317,159,7,'a_b',177,'Head of Household for',190,'Head of Household is',0,NULL,NULL,NULL), - (318,159,7,'b_a',190,'Head of Household is',177,'Head of Household for',0,NULL,NULL,NULL), - (319,160,2,'a_b',72,'Spouse of',177,'Spouse of',0,NULL,NULL,NULL), - (320,160,2,'b_a',177,'Spouse of',72,'Spouse of',0,NULL,NULL,NULL), - (321,161,1,'a_b',111,'Child of',167,'Parent of',1,NULL,NULL,NULL), - (322,161,1,'b_a',167,'Parent of',111,'Child of',1,NULL,NULL,NULL), - (323,162,1,'a_b',3,'Child of',167,'Parent of',1,NULL,NULL,NULL), - (324,162,1,'b_a',167,'Parent of',3,'Child of',1,NULL,NULL,NULL), - (325,163,1,'a_b',111,'Child of',18,'Parent of',1,NULL,NULL,NULL), - (326,163,1,'b_a',18,'Parent of',111,'Child of',1,NULL,NULL,NULL), - (327,164,1,'a_b',3,'Child of',18,'Parent of',1,NULL,NULL,NULL), - (328,164,1,'b_a',18,'Parent of',3,'Child of',1,NULL,NULL,NULL), - (329,165,4,'a_b',3,'Sibling of',111,'Sibling of',1,NULL,NULL,NULL), - (330,165,4,'b_a',111,'Sibling of',3,'Sibling of',1,NULL,NULL,NULL), - (331,166,8,'a_b',18,'Household Member of',19,'Household Member is',1,NULL,NULL,NULL), - (332,166,8,'b_a',19,'Household Member is',18,'Household Member of',1,NULL,NULL,NULL), - (333,167,8,'a_b',111,'Household Member of',19,'Household Member is',1,NULL,NULL,NULL), - (334,167,8,'b_a',19,'Household Member is',111,'Household Member of',1,NULL,NULL,NULL), - (335,168,8,'a_b',3,'Household Member of',19,'Household Member is',1,NULL,NULL,NULL), - (336,168,8,'b_a',19,'Household Member is',3,'Household Member of',1,NULL,NULL,NULL), - (337,169,7,'a_b',167,'Head of Household for',19,'Head of Household is',1,NULL,NULL,NULL), - (338,169,7,'b_a',19,'Head of Household is',167,'Head of Household for',1,NULL,NULL,NULL), - (339,170,2,'a_b',18,'Spouse of',167,'Spouse of',1,NULL,NULL,NULL), - (340,170,2,'b_a',167,'Spouse of',18,'Spouse of',1,NULL,NULL,NULL), - (341,171,1,'a_b',201,'Child of',159,'Parent of',1,NULL,NULL,NULL), - (342,171,1,'b_a',159,'Parent of',201,'Child of',1,NULL,NULL,NULL), - (343,172,1,'a_b',143,'Child of',159,'Parent of',1,NULL,NULL,NULL), - (344,172,1,'b_a',159,'Parent of',143,'Child of',1,NULL,NULL,NULL), - (345,173,1,'a_b',201,'Child of',128,'Parent of',1,NULL,NULL,NULL), - (346,173,1,'b_a',128,'Parent of',201,'Child of',1,NULL,NULL,NULL), - (347,174,1,'a_b',143,'Child of',128,'Parent of',1,NULL,NULL,NULL), - (348,174,1,'b_a',128,'Parent of',143,'Child of',1,NULL,NULL,NULL), - (349,175,4,'a_b',143,'Sibling of',201,'Sibling of',1,NULL,NULL,NULL), - (350,175,4,'b_a',201,'Sibling of',143,'Sibling of',1,NULL,NULL,NULL), - (351,176,8,'a_b',128,'Household Member of',165,'Household Member is',1,NULL,NULL,NULL), - (352,176,8,'b_a',165,'Household Member is',128,'Household Member of',1,NULL,NULL,NULL), - (353,177,8,'a_b',201,'Household Member of',165,'Household Member is',1,NULL,NULL,NULL), - (354,177,8,'b_a',165,'Household Member is',201,'Household Member of',1,NULL,NULL,NULL), - (355,178,8,'a_b',143,'Household Member of',165,'Household Member is',1,NULL,NULL,NULL), - (356,178,8,'b_a',165,'Household Member is',143,'Household Member of',1,NULL,NULL,NULL), - (357,179,7,'a_b',159,'Head of Household for',165,'Head of Household is',1,NULL,NULL,NULL), - (358,179,7,'b_a',165,'Head of Household is',159,'Head of Household for',1,NULL,NULL,NULL), - (359,180,2,'a_b',128,'Spouse of',159,'Spouse of',1,NULL,NULL,NULL), - (360,180,2,'b_a',159,'Spouse of',128,'Spouse of',1,NULL,NULL,NULL), - (361,181,1,'a_b',192,'Child of',185,'Parent of',1,NULL,NULL,NULL), - (362,181,1,'b_a',185,'Parent of',192,'Child of',1,NULL,NULL,NULL), - (363,182,1,'a_b',191,'Child of',185,'Parent of',1,NULL,NULL,NULL), - (364,182,1,'b_a',185,'Parent of',191,'Child of',1,NULL,NULL,NULL), - (365,183,1,'a_b',192,'Child of',158,'Parent of',1,NULL,NULL,NULL), - (366,183,1,'b_a',158,'Parent of',192,'Child of',1,NULL,NULL,NULL), - (367,184,1,'a_b',191,'Child of',158,'Parent of',1,NULL,NULL,NULL), - (368,184,1,'b_a',158,'Parent of',191,'Child of',1,NULL,NULL,NULL), - (369,185,4,'a_b',191,'Sibling of',192,'Sibling of',1,NULL,NULL,NULL), - (370,185,4,'b_a',192,'Sibling of',191,'Sibling of',1,NULL,NULL,NULL), - (371,186,8,'a_b',158,'Household Member of',112,'Household Member is',1,NULL,NULL,NULL), - (372,186,8,'b_a',112,'Household Member is',158,'Household Member of',1,NULL,NULL,NULL), - (373,187,8,'a_b',192,'Household Member of',112,'Household Member is',1,NULL,NULL,NULL), - (374,187,8,'b_a',112,'Household Member is',192,'Household Member of',1,NULL,NULL,NULL), - (375,188,8,'a_b',191,'Household Member of',112,'Household Member is',1,NULL,NULL,NULL), - (376,188,8,'b_a',112,'Household Member is',191,'Household Member of',1,NULL,NULL,NULL), - (377,189,7,'a_b',185,'Head of Household for',112,'Head of Household is',1,NULL,NULL,NULL), - (378,189,7,'b_a',112,'Head of Household is',185,'Head of Household for',1,NULL,NULL,NULL), - (379,190,2,'a_b',158,'Spouse of',185,'Spouse of',1,NULL,NULL,NULL), - (380,190,2,'b_a',185,'Spouse of',158,'Spouse of',1,NULL,NULL,NULL), - (381,191,1,'a_b',26,'Child of',146,'Parent of',1,NULL,NULL,NULL), - (382,191,1,'b_a',146,'Parent of',26,'Child of',1,NULL,NULL,NULL), - (383,192,1,'a_b',43,'Child of',146,'Parent of',1,NULL,NULL,NULL), - (384,192,1,'b_a',146,'Parent of',43,'Child of',1,NULL,NULL,NULL), - (385,193,1,'a_b',26,'Child of',127,'Parent of',1,NULL,NULL,NULL), - (386,193,1,'b_a',127,'Parent of',26,'Child of',1,NULL,NULL,NULL), - (387,194,1,'a_b',43,'Child of',127,'Parent of',1,NULL,NULL,NULL), - (388,194,1,'b_a',127,'Parent of',43,'Child of',1,NULL,NULL,NULL), - (389,195,4,'a_b',43,'Sibling of',26,'Sibling of',1,NULL,NULL,NULL), - (390,195,4,'b_a',26,'Sibling of',43,'Sibling of',1,NULL,NULL,NULL), - (391,196,8,'a_b',127,'Household Member of',152,'Household Member is',1,NULL,NULL,NULL), - (392,196,8,'b_a',152,'Household Member is',127,'Household Member of',1,NULL,NULL,NULL), - (393,197,8,'a_b',26,'Household Member of',152,'Household Member is',1,NULL,NULL,NULL), - (394,197,8,'b_a',152,'Household Member is',26,'Household Member of',1,NULL,NULL,NULL), - (395,198,8,'a_b',43,'Household Member of',152,'Household Member is',1,NULL,NULL,NULL), - (396,198,8,'b_a',152,'Household Member is',43,'Household Member of',1,NULL,NULL,NULL), - (397,199,7,'a_b',146,'Head of Household for',152,'Head of Household is',0,NULL,NULL,NULL), - (398,199,7,'b_a',152,'Head of Household is',146,'Head of Household for',0,NULL,NULL,NULL), - (399,200,2,'a_b',127,'Spouse of',146,'Spouse of',0,NULL,NULL,NULL), - (400,200,2,'b_a',146,'Spouse of',127,'Spouse of',0,NULL,NULL,NULL), - (401,201,5,'a_b',143,'Employee of',41,'Employer of',1,NULL,NULL,NULL), - (402,201,5,'b_a',41,'Employer of',143,'Employee of',1,NULL,NULL,NULL), - (403,202,5,'a_b',148,'Employee of',70,'Employer of',1,NULL,NULL,NULL), - (404,202,5,'b_a',70,'Employer of',148,'Employee of',1,NULL,NULL,NULL), - (405,203,5,'a_b',14,'Employee of',71,'Employer of',1,NULL,NULL,NULL), - (406,203,5,'b_a',71,'Employer of',14,'Employee of',1,NULL,NULL,NULL), - (407,204,5,'a_b',184,'Employee of',93,'Employer of',1,NULL,NULL,NULL), - (408,204,5,'b_a',93,'Employer of',184,'Employee of',1,NULL,NULL,NULL), - (409,205,5,'a_b',181,'Employee of',95,'Employer of',1,NULL,NULL,NULL), - (410,205,5,'b_a',95,'Employer of',181,'Employee of',1,NULL,NULL,NULL), - (411,206,5,'a_b',36,'Employee of',98,'Employer of',1,NULL,NULL,NULL), - (412,206,5,'b_a',98,'Employer of',36,'Employee of',1,NULL,NULL,NULL), - (413,207,5,'a_b',69,'Employee of',114,'Employer of',1,NULL,NULL,NULL), - (414,207,5,'b_a',114,'Employer of',69,'Employee of',1,NULL,NULL,NULL), - (415,208,5,'a_b',191,'Employee of',120,'Employer of',1,NULL,NULL,NULL), - (416,208,5,'b_a',120,'Employer of',191,'Employee of',1,NULL,NULL,NULL), - (417,209,5,'a_b',29,'Employee of',121,'Employer of',1,NULL,NULL,NULL), - (418,209,5,'b_a',121,'Employer of',29,'Employee of',1,NULL,NULL,NULL), - (419,210,5,'a_b',62,'Employee of',139,'Employer of',1,NULL,NULL,NULL), - (420,210,5,'b_a',139,'Employer of',62,'Employee of',1,NULL,NULL,NULL), - (421,211,5,'a_b',37,'Employee of',157,'Employer of',1,NULL,NULL,NULL), - (422,211,5,'b_a',157,'Employer of',37,'Employee of',1,NULL,NULL,NULL), - (423,212,5,'a_b',103,'Employee of',163,'Employer of',1,NULL,NULL,NULL), - (424,212,5,'b_a',163,'Employer of',103,'Employee of',1,NULL,NULL,NULL), - (425,213,5,'a_b',33,'Employee of',169,'Employer of',1,NULL,NULL,NULL), - (426,213,5,'b_a',169,'Employer of',33,'Employee of',1,NULL,NULL,NULL), - (427,214,5,'a_b',182,'Employee of',173,'Employer of',1,NULL,NULL,NULL), - (428,214,5,'b_a',173,'Employer of',182,'Employee of',1,NULL,NULL,NULL); + (1,1,1,'a_b',150,'Child of',20,'Parent of',1,NULL,NULL,NULL), + (2,1,1,'b_a',20,'Parent of',150,'Child of',1,NULL,NULL,NULL), + (3,2,1,'a_b',102,'Child of',20,'Parent of',1,NULL,NULL,NULL), + (4,2,1,'b_a',20,'Parent of',102,'Child of',1,NULL,NULL,NULL), + (5,3,1,'a_b',150,'Child of',156,'Parent of',1,NULL,NULL,NULL), + (6,3,1,'b_a',156,'Parent of',150,'Child of',1,NULL,NULL,NULL), + (7,4,1,'a_b',102,'Child of',156,'Parent of',1,NULL,NULL,NULL), + (8,4,1,'b_a',156,'Parent of',102,'Child of',1,NULL,NULL,NULL), + (9,5,4,'a_b',102,'Sibling of',150,'Sibling of',1,NULL,NULL,NULL), + (10,5,4,'b_a',150,'Sibling of',102,'Sibling of',1,NULL,NULL,NULL), + (11,6,8,'a_b',156,'Household Member of',51,'Household Member is',1,NULL,NULL,NULL), + (12,6,8,'b_a',51,'Household Member is',156,'Household Member of',1,NULL,NULL,NULL), + (13,7,8,'a_b',150,'Household Member of',51,'Household Member is',1,NULL,NULL,NULL), + (14,7,8,'b_a',51,'Household Member is',150,'Household Member of',1,NULL,NULL,NULL), + (15,8,8,'a_b',102,'Household Member of',51,'Household Member is',1,NULL,NULL,NULL), + (16,8,8,'b_a',51,'Household Member is',102,'Household Member of',1,NULL,NULL,NULL), + (17,9,7,'a_b',20,'Head of Household for',51,'Head of Household is',1,NULL,NULL,NULL), + (18,9,7,'b_a',51,'Head of Household is',20,'Head of Household for',1,NULL,NULL,NULL), + (19,10,2,'a_b',156,'Spouse of',20,'Spouse of',1,NULL,NULL,NULL), + (20,10,2,'b_a',20,'Spouse of',156,'Spouse of',1,NULL,NULL,NULL), + (21,11,1,'a_b',128,'Child of',52,'Parent of',1,NULL,NULL,NULL), + (22,11,1,'b_a',52,'Parent of',128,'Child of',1,NULL,NULL,NULL), + (23,12,1,'a_b',44,'Child of',52,'Parent of',1,NULL,NULL,NULL), + (24,12,1,'b_a',52,'Parent of',44,'Child of',1,NULL,NULL,NULL), + (25,13,1,'a_b',128,'Child of',49,'Parent of',1,NULL,NULL,NULL), + (26,13,1,'b_a',49,'Parent of',128,'Child of',1,NULL,NULL,NULL), + (27,14,1,'a_b',44,'Child of',49,'Parent of',1,NULL,NULL,NULL), + (28,14,1,'b_a',49,'Parent of',44,'Child of',1,NULL,NULL,NULL), + (29,15,4,'a_b',44,'Sibling of',128,'Sibling of',1,NULL,NULL,NULL), + (30,15,4,'b_a',128,'Sibling of',44,'Sibling of',1,NULL,NULL,NULL), + (31,16,8,'a_b',49,'Household Member of',172,'Household Member is',1,NULL,NULL,NULL), + (32,16,8,'b_a',172,'Household Member is',49,'Household Member of',1,NULL,NULL,NULL), + (33,17,8,'a_b',128,'Household Member of',172,'Household Member is',1,NULL,NULL,NULL), + (34,17,8,'b_a',172,'Household Member is',128,'Household Member of',1,NULL,NULL,NULL), + (35,18,8,'a_b',44,'Household Member of',172,'Household Member is',1,NULL,NULL,NULL), + (36,18,8,'b_a',172,'Household Member is',44,'Household Member of',1,NULL,NULL,NULL), + (37,19,7,'a_b',52,'Head of Household for',172,'Head of Household is',0,NULL,NULL,NULL), + (38,19,7,'b_a',172,'Head of Household is',52,'Head of Household for',0,NULL,NULL,NULL), + (39,20,2,'a_b',49,'Spouse of',52,'Spouse of',0,NULL,NULL,NULL), + (40,20,2,'b_a',52,'Spouse of',49,'Spouse of',0,NULL,NULL,NULL), + (41,21,1,'a_b',118,'Child of',33,'Parent of',1,NULL,NULL,NULL), + (42,21,1,'b_a',33,'Parent of',118,'Child of',1,NULL,NULL,NULL), + (43,22,1,'a_b',186,'Child of',33,'Parent of',1,NULL,NULL,NULL), + (44,22,1,'b_a',33,'Parent of',186,'Child of',1,NULL,NULL,NULL), + (45,23,1,'a_b',118,'Child of',35,'Parent of',1,NULL,NULL,NULL), + (46,23,1,'b_a',35,'Parent of',118,'Child of',1,NULL,NULL,NULL), + (47,24,1,'a_b',186,'Child of',35,'Parent of',1,NULL,NULL,NULL), + (48,24,1,'b_a',35,'Parent of',186,'Child of',1,NULL,NULL,NULL), + (49,25,4,'a_b',186,'Sibling of',118,'Sibling of',1,NULL,NULL,NULL), + (50,25,4,'b_a',118,'Sibling of',186,'Sibling of',1,NULL,NULL,NULL), + (51,26,8,'a_b',35,'Household Member of',140,'Household Member is',1,NULL,NULL,NULL), + (52,26,8,'b_a',140,'Household Member is',35,'Household Member of',1,NULL,NULL,NULL), + (53,27,8,'a_b',118,'Household Member of',140,'Household Member is',1,NULL,NULL,NULL), + (54,27,8,'b_a',140,'Household Member is',118,'Household Member of',1,NULL,NULL,NULL), + (55,28,8,'a_b',186,'Household Member of',140,'Household Member is',1,NULL,NULL,NULL), + (56,28,8,'b_a',140,'Household Member is',186,'Household Member of',1,NULL,NULL,NULL), + (57,29,7,'a_b',33,'Head of Household for',140,'Head of Household is',1,NULL,NULL,NULL), + (58,29,7,'b_a',140,'Head of Household is',33,'Head of Household for',1,NULL,NULL,NULL), + (59,30,2,'a_b',35,'Spouse of',33,'Spouse of',1,NULL,NULL,NULL), + (60,30,2,'b_a',33,'Spouse of',35,'Spouse of',1,NULL,NULL,NULL), + (61,31,1,'a_b',105,'Child of',129,'Parent of',1,NULL,NULL,NULL), + (62,31,1,'b_a',129,'Parent of',105,'Child of',1,NULL,NULL,NULL), + (63,32,1,'a_b',173,'Child of',129,'Parent of',1,NULL,NULL,NULL), + (64,32,1,'b_a',129,'Parent of',173,'Child of',1,NULL,NULL,NULL), + (65,33,1,'a_b',105,'Child of',158,'Parent of',1,NULL,NULL,NULL), + (66,33,1,'b_a',158,'Parent of',105,'Child of',1,NULL,NULL,NULL), + (67,34,1,'a_b',173,'Child of',158,'Parent of',1,NULL,NULL,NULL), + (68,34,1,'b_a',158,'Parent of',173,'Child of',1,NULL,NULL,NULL), + (69,35,4,'a_b',173,'Sibling of',105,'Sibling of',1,NULL,NULL,NULL), + (70,35,4,'b_a',105,'Sibling of',173,'Sibling of',1,NULL,NULL,NULL), + (71,36,8,'a_b',158,'Household Member of',13,'Household Member is',1,NULL,NULL,NULL), + (72,36,8,'b_a',13,'Household Member is',158,'Household Member of',1,NULL,NULL,NULL), + (73,37,8,'a_b',105,'Household Member of',13,'Household Member is',1,NULL,NULL,NULL), + (74,37,8,'b_a',13,'Household Member is',105,'Household Member of',1,NULL,NULL,NULL), + (75,38,8,'a_b',173,'Household Member of',13,'Household Member is',1,NULL,NULL,NULL), + (76,38,8,'b_a',13,'Household Member is',173,'Household Member of',1,NULL,NULL,NULL), + (77,39,7,'a_b',129,'Head of Household for',13,'Head of Household is',1,NULL,NULL,NULL), + (78,39,7,'b_a',13,'Head of Household is',129,'Head of Household for',1,NULL,NULL,NULL), + (79,40,2,'a_b',158,'Spouse of',129,'Spouse of',1,NULL,NULL,NULL), + (80,40,2,'b_a',129,'Spouse of',158,'Spouse of',1,NULL,NULL,NULL), + (81,41,1,'a_b',103,'Child of',119,'Parent of',1,NULL,NULL,NULL), + (82,41,1,'b_a',119,'Parent of',103,'Child of',1,NULL,NULL,NULL), + (83,42,1,'a_b',97,'Child of',119,'Parent of',1,NULL,NULL,NULL), + (84,42,1,'b_a',119,'Parent of',97,'Child of',1,NULL,NULL,NULL), + (85,43,1,'a_b',103,'Child of',134,'Parent of',1,NULL,NULL,NULL), + (86,43,1,'b_a',134,'Parent of',103,'Child of',1,NULL,NULL,NULL), + (87,44,1,'a_b',97,'Child of',134,'Parent of',1,NULL,NULL,NULL), + (88,44,1,'b_a',134,'Parent of',97,'Child of',1,NULL,NULL,NULL), + (89,45,4,'a_b',97,'Sibling of',103,'Sibling of',1,NULL,NULL,NULL), + (90,45,4,'b_a',103,'Sibling of',97,'Sibling of',1,NULL,NULL,NULL), + (91,46,8,'a_b',134,'Household Member of',45,'Household Member is',1,NULL,NULL,NULL), + (92,46,8,'b_a',45,'Household Member is',134,'Household Member of',1,NULL,NULL,NULL), + (93,47,8,'a_b',103,'Household Member of',45,'Household Member is',1,NULL,NULL,NULL), + (94,47,8,'b_a',45,'Household Member is',103,'Household Member of',1,NULL,NULL,NULL), + (95,48,8,'a_b',97,'Household Member of',45,'Household Member is',1,NULL,NULL,NULL), + (96,48,8,'b_a',45,'Household Member is',97,'Household Member of',1,NULL,NULL,NULL), + (97,49,7,'a_b',119,'Head of Household for',45,'Head of Household is',1,NULL,NULL,NULL), + (98,49,7,'b_a',45,'Head of Household is',119,'Head of Household for',1,NULL,NULL,NULL), + (99,50,2,'a_b',134,'Spouse of',119,'Spouse of',1,NULL,NULL,NULL), + (100,50,2,'b_a',119,'Spouse of',134,'Spouse of',1,NULL,NULL,NULL), + (101,51,1,'a_b',180,'Child of',75,'Parent of',1,NULL,NULL,NULL), + (102,51,1,'b_a',75,'Parent of',180,'Child of',1,NULL,NULL,NULL), + (103,52,1,'a_b',114,'Child of',75,'Parent of',1,NULL,NULL,NULL), + (104,52,1,'b_a',75,'Parent of',114,'Child of',1,NULL,NULL,NULL), + (105,53,1,'a_b',180,'Child of',149,'Parent of',1,NULL,NULL,NULL), + (106,53,1,'b_a',149,'Parent of',180,'Child of',1,NULL,NULL,NULL), + (107,54,1,'a_b',114,'Child of',149,'Parent of',1,NULL,NULL,NULL), + (108,54,1,'b_a',149,'Parent of',114,'Child of',1,NULL,NULL,NULL), + (109,55,4,'a_b',114,'Sibling of',180,'Sibling of',1,NULL,NULL,NULL), + (110,55,4,'b_a',180,'Sibling of',114,'Sibling of',1,NULL,NULL,NULL), + (111,56,8,'a_b',149,'Household Member of',161,'Household Member is',1,NULL,NULL,NULL), + (112,56,8,'b_a',161,'Household Member is',149,'Household Member of',1,NULL,NULL,NULL), + (113,57,8,'a_b',180,'Household Member of',161,'Household Member is',1,NULL,NULL,NULL), + (114,57,8,'b_a',161,'Household Member is',180,'Household Member of',1,NULL,NULL,NULL), + (115,58,8,'a_b',114,'Household Member of',161,'Household Member is',1,NULL,NULL,NULL), + (116,58,8,'b_a',161,'Household Member is',114,'Household Member of',1,NULL,NULL,NULL), + (117,59,7,'a_b',75,'Head of Household for',161,'Head of Household is',0,NULL,NULL,NULL), + (118,59,7,'b_a',161,'Head of Household is',75,'Head of Household for',0,NULL,NULL,NULL), + (119,60,2,'a_b',149,'Spouse of',75,'Spouse of',0,NULL,NULL,NULL), + (120,60,2,'b_a',75,'Spouse of',149,'Spouse of',0,NULL,NULL,NULL), + (121,61,1,'a_b',32,'Child of',190,'Parent of',1,NULL,NULL,NULL), + (122,61,1,'b_a',190,'Parent of',32,'Child of',1,NULL,NULL,NULL), + (123,62,1,'a_b',60,'Child of',190,'Parent of',1,NULL,NULL,NULL), + (124,62,1,'b_a',190,'Parent of',60,'Child of',1,NULL,NULL,NULL), + (125,63,1,'a_b',32,'Child of',17,'Parent of',1,NULL,NULL,NULL), + (126,63,1,'b_a',17,'Parent of',32,'Child of',1,NULL,NULL,NULL), + (127,64,1,'a_b',60,'Child of',17,'Parent of',1,NULL,NULL,NULL), + (128,64,1,'b_a',17,'Parent of',60,'Child of',1,NULL,NULL,NULL), + (129,65,4,'a_b',60,'Sibling of',32,'Sibling of',1,NULL,NULL,NULL), + (130,65,4,'b_a',32,'Sibling of',60,'Sibling of',1,NULL,NULL,NULL), + (131,66,8,'a_b',17,'Household Member of',67,'Household Member is',1,NULL,NULL,NULL), + (132,66,8,'b_a',67,'Household Member is',17,'Household Member of',1,NULL,NULL,NULL), + (133,67,8,'a_b',32,'Household Member of',67,'Household Member is',1,NULL,NULL,NULL), + (134,67,8,'b_a',67,'Household Member is',32,'Household Member of',1,NULL,NULL,NULL), + (135,68,8,'a_b',60,'Household Member of',67,'Household Member is',1,NULL,NULL,NULL), + (136,68,8,'b_a',67,'Household Member is',60,'Household Member of',1,NULL,NULL,NULL), + (137,69,7,'a_b',190,'Head of Household for',67,'Head of Household is',1,NULL,NULL,NULL), + (138,69,7,'b_a',67,'Head of Household is',190,'Head of Household for',1,NULL,NULL,NULL), + (139,70,2,'a_b',17,'Spouse of',190,'Spouse of',1,NULL,NULL,NULL), + (140,70,2,'b_a',190,'Spouse of',17,'Spouse of',1,NULL,NULL,NULL), + (141,71,1,'a_b',94,'Child of',72,'Parent of',1,NULL,NULL,NULL), + (142,71,1,'b_a',72,'Parent of',94,'Child of',1,NULL,NULL,NULL), + (143,72,1,'a_b',95,'Child of',72,'Parent of',1,NULL,NULL,NULL), + (144,72,1,'b_a',72,'Parent of',95,'Child of',1,NULL,NULL,NULL), + (145,73,1,'a_b',94,'Child of',29,'Parent of',1,NULL,NULL,NULL), + (146,73,1,'b_a',29,'Parent of',94,'Child of',1,NULL,NULL,NULL), + (147,74,1,'a_b',95,'Child of',29,'Parent of',1,NULL,NULL,NULL), + (148,74,1,'b_a',29,'Parent of',95,'Child of',1,NULL,NULL,NULL), + (149,75,4,'a_b',95,'Sibling of',94,'Sibling of',1,NULL,NULL,NULL), + (150,75,4,'b_a',94,'Sibling of',95,'Sibling of',1,NULL,NULL,NULL), + (151,76,8,'a_b',29,'Household Member of',8,'Household Member is',1,NULL,NULL,NULL), + (152,76,8,'b_a',8,'Household Member is',29,'Household Member of',1,NULL,NULL,NULL), + (153,77,8,'a_b',94,'Household Member of',8,'Household Member is',1,NULL,NULL,NULL), + (154,77,8,'b_a',8,'Household Member is',94,'Household Member of',1,NULL,NULL,NULL), + (155,78,8,'a_b',95,'Household Member of',8,'Household Member is',1,NULL,NULL,NULL), + (156,78,8,'b_a',8,'Household Member is',95,'Household Member of',1,NULL,NULL,NULL), + (157,79,7,'a_b',72,'Head of Household for',8,'Head of Household is',1,NULL,NULL,NULL), + (158,79,7,'b_a',8,'Head of Household is',72,'Head of Household for',1,NULL,NULL,NULL), + (159,80,2,'a_b',29,'Spouse of',72,'Spouse of',1,NULL,NULL,NULL), + (160,80,2,'b_a',72,'Spouse of',29,'Spouse of',1,NULL,NULL,NULL), + (161,81,1,'a_b',7,'Child of',82,'Parent of',1,NULL,NULL,NULL), + (162,81,1,'b_a',82,'Parent of',7,'Child of',1,NULL,NULL,NULL), + (163,82,1,'a_b',43,'Child of',82,'Parent of',1,NULL,NULL,NULL), + (164,82,1,'b_a',82,'Parent of',43,'Child of',1,NULL,NULL,NULL), + (165,83,1,'a_b',7,'Child of',197,'Parent of',1,NULL,NULL,NULL), + (166,83,1,'b_a',197,'Parent of',7,'Child of',1,NULL,NULL,NULL), + (167,84,1,'a_b',43,'Child of',197,'Parent of',1,NULL,NULL,NULL), + (168,84,1,'b_a',197,'Parent of',43,'Child of',1,NULL,NULL,NULL), + (169,85,4,'a_b',43,'Sibling of',7,'Sibling of',1,NULL,NULL,NULL), + (170,85,4,'b_a',7,'Sibling of',43,'Sibling of',1,NULL,NULL,NULL), + (171,86,8,'a_b',197,'Household Member of',176,'Household Member is',1,NULL,NULL,NULL), + (172,86,8,'b_a',176,'Household Member is',197,'Household Member of',1,NULL,NULL,NULL), + (173,87,8,'a_b',7,'Household Member of',176,'Household Member is',1,NULL,NULL,NULL), + (174,87,8,'b_a',176,'Household Member is',7,'Household Member of',1,NULL,NULL,NULL), + (175,88,8,'a_b',43,'Household Member of',176,'Household Member is',1,NULL,NULL,NULL), + (176,88,8,'b_a',176,'Household Member is',43,'Household Member of',1,NULL,NULL,NULL), + (177,89,7,'a_b',82,'Head of Household for',176,'Head of Household is',1,NULL,NULL,NULL), + (178,89,7,'b_a',176,'Head of Household is',82,'Head of Household for',1,NULL,NULL,NULL), + (179,90,2,'a_b',197,'Spouse of',82,'Spouse of',1,NULL,NULL,NULL), + (180,90,2,'b_a',82,'Spouse of',197,'Spouse of',1,NULL,NULL,NULL), + (181,91,1,'a_b',96,'Child of',130,'Parent of',1,NULL,NULL,NULL), + (182,91,1,'b_a',130,'Parent of',96,'Child of',1,NULL,NULL,NULL), + (183,92,1,'a_b',63,'Child of',130,'Parent of',1,NULL,NULL,NULL), + (184,92,1,'b_a',130,'Parent of',63,'Child of',1,NULL,NULL,NULL), + (185,93,1,'a_b',96,'Child of',23,'Parent of',1,NULL,NULL,NULL), + (186,93,1,'b_a',23,'Parent of',96,'Child of',1,NULL,NULL,NULL), + (187,94,1,'a_b',63,'Child of',23,'Parent of',1,NULL,NULL,NULL), + (188,94,1,'b_a',23,'Parent of',63,'Child of',1,NULL,NULL,NULL), + (189,95,4,'a_b',63,'Sibling of',96,'Sibling of',1,NULL,NULL,NULL), + (190,95,4,'b_a',96,'Sibling of',63,'Sibling of',1,NULL,NULL,NULL), + (191,96,8,'a_b',23,'Household Member of',5,'Household Member is',1,NULL,NULL,NULL), + (192,96,8,'b_a',5,'Household Member is',23,'Household Member of',1,NULL,NULL,NULL), + (193,97,8,'a_b',96,'Household Member of',5,'Household Member is',1,NULL,NULL,NULL), + (194,97,8,'b_a',5,'Household Member is',96,'Household Member of',1,NULL,NULL,NULL), + (195,98,8,'a_b',63,'Household Member of',5,'Household Member is',1,NULL,NULL,NULL), + (196,98,8,'b_a',5,'Household Member is',63,'Household Member of',1,NULL,NULL,NULL), + (197,99,7,'a_b',130,'Head of Household for',5,'Head of Household is',1,NULL,NULL,NULL), + (198,99,7,'b_a',5,'Head of Household is',130,'Head of Household for',1,NULL,NULL,NULL), + (199,100,2,'a_b',23,'Spouse of',130,'Spouse of',1,NULL,NULL,NULL), + (200,100,2,'b_a',130,'Spouse of',23,'Spouse of',1,NULL,NULL,NULL), + (201,101,1,'a_b',174,'Child of',68,'Parent of',1,NULL,NULL,NULL), + (202,101,1,'b_a',68,'Parent of',174,'Child of',1,NULL,NULL,NULL), + (203,102,1,'a_b',42,'Child of',68,'Parent of',1,NULL,NULL,NULL), + (204,102,1,'b_a',68,'Parent of',42,'Child of',1,NULL,NULL,NULL), + (205,103,1,'a_b',174,'Child of',38,'Parent of',1,NULL,NULL,NULL), + (206,103,1,'b_a',38,'Parent of',174,'Child of',1,NULL,NULL,NULL), + (207,104,1,'a_b',42,'Child of',38,'Parent of',1,NULL,NULL,NULL), + (208,104,1,'b_a',38,'Parent of',42,'Child of',1,NULL,NULL,NULL), + (209,105,4,'a_b',42,'Sibling of',174,'Sibling of',1,NULL,NULL,NULL), + (210,105,4,'b_a',174,'Sibling of',42,'Sibling of',1,NULL,NULL,NULL), + (211,106,8,'a_b',38,'Household Member of',69,'Household Member is',1,NULL,NULL,NULL), + (212,106,8,'b_a',69,'Household Member is',38,'Household Member of',1,NULL,NULL,NULL), + (213,107,8,'a_b',174,'Household Member of',69,'Household Member is',1,NULL,NULL,NULL), + (214,107,8,'b_a',69,'Household Member is',174,'Household Member of',1,NULL,NULL,NULL), + (215,108,8,'a_b',42,'Household Member of',69,'Household Member is',1,NULL,NULL,NULL), + (216,108,8,'b_a',69,'Household Member is',42,'Household Member of',1,NULL,NULL,NULL), + (217,109,7,'a_b',68,'Head of Household for',69,'Head of Household is',1,NULL,NULL,NULL), + (218,109,7,'b_a',69,'Head of Household is',68,'Head of Household for',1,NULL,NULL,NULL), + (219,110,2,'a_b',38,'Spouse of',68,'Spouse of',1,NULL,NULL,NULL), + (220,110,2,'b_a',68,'Spouse of',38,'Spouse of',1,NULL,NULL,NULL), + (221,111,1,'a_b',24,'Child of',151,'Parent of',1,NULL,NULL,NULL), + (222,111,1,'b_a',151,'Parent of',24,'Child of',1,NULL,NULL,NULL), + (223,112,1,'a_b',153,'Child of',151,'Parent of',1,NULL,NULL,NULL), + (224,112,1,'b_a',151,'Parent of',153,'Child of',1,NULL,NULL,NULL), + (225,113,1,'a_b',24,'Child of',196,'Parent of',1,NULL,NULL,NULL), + (226,113,1,'b_a',196,'Parent of',24,'Child of',1,NULL,NULL,NULL), + (227,114,1,'a_b',153,'Child of',196,'Parent of',1,NULL,NULL,NULL), + (228,114,1,'b_a',196,'Parent of',153,'Child of',1,NULL,NULL,NULL), + (229,115,4,'a_b',153,'Sibling of',24,'Sibling of',1,NULL,NULL,NULL), + (230,115,4,'b_a',24,'Sibling of',153,'Sibling of',1,NULL,NULL,NULL), + (231,116,8,'a_b',196,'Household Member of',183,'Household Member is',1,NULL,NULL,NULL), + (232,116,8,'b_a',183,'Household Member is',196,'Household Member of',1,NULL,NULL,NULL), + (233,117,8,'a_b',24,'Household Member of',183,'Household Member is',1,NULL,NULL,NULL), + (234,117,8,'b_a',183,'Household Member is',24,'Household Member of',1,NULL,NULL,NULL), + (235,118,8,'a_b',153,'Household Member of',183,'Household Member is',1,NULL,NULL,NULL), + (236,118,8,'b_a',183,'Household Member is',153,'Household Member of',1,NULL,NULL,NULL), + (237,119,7,'a_b',151,'Head of Household for',183,'Head of Household is',0,NULL,NULL,NULL), + (238,119,7,'b_a',183,'Head of Household is',151,'Head of Household for',0,NULL,NULL,NULL), + (239,120,2,'a_b',196,'Spouse of',151,'Spouse of',0,NULL,NULL,NULL), + (240,120,2,'b_a',151,'Spouse of',196,'Spouse of',0,NULL,NULL,NULL), + (241,121,1,'a_b',170,'Child of',40,'Parent of',1,NULL,NULL,NULL), + (242,121,1,'b_a',40,'Parent of',170,'Child of',1,NULL,NULL,NULL), + (243,122,1,'a_b',155,'Child of',40,'Parent of',1,NULL,NULL,NULL), + (244,122,1,'b_a',40,'Parent of',155,'Child of',1,NULL,NULL,NULL), + (245,123,1,'a_b',170,'Child of',137,'Parent of',1,NULL,NULL,NULL), + (246,123,1,'b_a',137,'Parent of',170,'Child of',1,NULL,NULL,NULL), + (247,124,1,'a_b',155,'Child of',137,'Parent of',1,NULL,NULL,NULL), + (248,124,1,'b_a',137,'Parent of',155,'Child of',1,NULL,NULL,NULL), + (249,125,4,'a_b',155,'Sibling of',170,'Sibling of',1,NULL,NULL,NULL), + (250,125,4,'b_a',170,'Sibling of',155,'Sibling of',1,NULL,NULL,NULL), + (251,126,8,'a_b',137,'Household Member of',157,'Household Member is',1,NULL,NULL,NULL), + (252,126,8,'b_a',157,'Household Member is',137,'Household Member of',1,NULL,NULL,NULL), + (253,127,8,'a_b',170,'Household Member of',157,'Household Member is',1,NULL,NULL,NULL), + (254,127,8,'b_a',157,'Household Member is',170,'Household Member of',1,NULL,NULL,NULL), + (255,128,8,'a_b',155,'Household Member of',157,'Household Member is',1,NULL,NULL,NULL), + (256,128,8,'b_a',157,'Household Member is',155,'Household Member of',1,NULL,NULL,NULL), + (257,129,7,'a_b',40,'Head of Household for',157,'Head of Household is',1,NULL,NULL,NULL), + (258,129,7,'b_a',157,'Head of Household is',40,'Head of Household for',1,NULL,NULL,NULL), + (259,130,2,'a_b',137,'Spouse of',40,'Spouse of',1,NULL,NULL,NULL), + (260,130,2,'b_a',40,'Spouse of',137,'Spouse of',1,NULL,NULL,NULL), + (261,131,1,'a_b',117,'Child of',198,'Parent of',1,NULL,NULL,NULL), + (262,131,1,'b_a',198,'Parent of',117,'Child of',1,NULL,NULL,NULL), + (263,132,1,'a_b',109,'Child of',198,'Parent of',1,NULL,NULL,NULL), + (264,132,1,'b_a',198,'Parent of',109,'Child of',1,NULL,NULL,NULL), + (265,133,1,'a_b',117,'Child of',112,'Parent of',1,NULL,NULL,NULL), + (266,133,1,'b_a',112,'Parent of',117,'Child of',1,NULL,NULL,NULL), + (267,134,1,'a_b',109,'Child of',112,'Parent of',1,NULL,NULL,NULL), + (268,134,1,'b_a',112,'Parent of',109,'Child of',1,NULL,NULL,NULL), + (269,135,4,'a_b',109,'Sibling of',117,'Sibling of',1,NULL,NULL,NULL), + (270,135,4,'b_a',117,'Sibling of',109,'Sibling of',1,NULL,NULL,NULL), + (271,136,8,'a_b',112,'Household Member of',76,'Household Member is',1,NULL,NULL,NULL), + (272,136,8,'b_a',76,'Household Member is',112,'Household Member of',1,NULL,NULL,NULL), + (273,137,8,'a_b',117,'Household Member of',76,'Household Member is',1,NULL,NULL,NULL), + (274,137,8,'b_a',76,'Household Member is',117,'Household Member of',1,NULL,NULL,NULL), + (275,138,8,'a_b',109,'Household Member of',76,'Household Member is',1,NULL,NULL,NULL), + (276,138,8,'b_a',76,'Household Member is',109,'Household Member of',1,NULL,NULL,NULL), + (277,139,7,'a_b',198,'Head of Household for',76,'Head of Household is',1,NULL,NULL,NULL), + (278,139,7,'b_a',76,'Head of Household is',198,'Head of Household for',1,NULL,NULL,NULL), + (279,140,2,'a_b',112,'Spouse of',198,'Spouse of',1,NULL,NULL,NULL), + (280,140,2,'b_a',198,'Spouse of',112,'Spouse of',1,NULL,NULL,NULL), + (281,141,1,'a_b',87,'Child of',179,'Parent of',1,NULL,NULL,NULL), + (282,141,1,'b_a',179,'Parent of',87,'Child of',1,NULL,NULL,NULL), + (283,142,1,'a_b',115,'Child of',179,'Parent of',1,NULL,NULL,NULL), + (284,142,1,'b_a',179,'Parent of',115,'Child of',1,NULL,NULL,NULL), + (285,143,1,'a_b',87,'Child of',147,'Parent of',1,NULL,NULL,NULL), + (286,143,1,'b_a',147,'Parent of',87,'Child of',1,NULL,NULL,NULL), + (287,144,1,'a_b',115,'Child of',147,'Parent of',1,NULL,NULL,NULL), + (288,144,1,'b_a',147,'Parent of',115,'Child of',1,NULL,NULL,NULL), + (289,145,4,'a_b',115,'Sibling of',87,'Sibling of',1,NULL,NULL,NULL), + (290,145,4,'b_a',87,'Sibling of',115,'Sibling of',1,NULL,NULL,NULL), + (291,146,8,'a_b',147,'Household Member of',131,'Household Member is',1,NULL,NULL,NULL), + (292,146,8,'b_a',131,'Household Member is',147,'Household Member of',1,NULL,NULL,NULL), + (293,147,8,'a_b',87,'Household Member of',131,'Household Member is',1,NULL,NULL,NULL), + (294,147,8,'b_a',131,'Household Member is',87,'Household Member of',1,NULL,NULL,NULL), + (295,148,8,'a_b',115,'Household Member of',131,'Household Member is',1,NULL,NULL,NULL), + (296,148,8,'b_a',131,'Household Member is',115,'Household Member of',1,NULL,NULL,NULL), + (297,149,7,'a_b',179,'Head of Household for',131,'Head of Household is',1,NULL,NULL,NULL), + (298,149,7,'b_a',131,'Head of Household is',179,'Head of Household for',1,NULL,NULL,NULL), + (299,150,2,'a_b',147,'Spouse of',179,'Spouse of',1,NULL,NULL,NULL), + (300,150,2,'b_a',179,'Spouse of',147,'Spouse of',1,NULL,NULL,NULL), + (301,151,1,'a_b',185,'Child of',91,'Parent of',1,NULL,NULL,NULL), + (302,151,1,'b_a',91,'Parent of',185,'Child of',1,NULL,NULL,NULL), + (303,152,1,'a_b',201,'Child of',91,'Parent of',1,NULL,NULL,NULL), + (304,152,1,'b_a',91,'Parent of',201,'Child of',1,NULL,NULL,NULL), + (305,153,1,'a_b',185,'Child of',154,'Parent of',1,NULL,NULL,NULL), + (306,153,1,'b_a',154,'Parent of',185,'Child of',1,NULL,NULL,NULL), + (307,154,1,'a_b',201,'Child of',154,'Parent of',1,NULL,NULL,NULL), + (308,154,1,'b_a',154,'Parent of',201,'Child of',1,NULL,NULL,NULL), + (309,155,4,'a_b',201,'Sibling of',185,'Sibling of',1,NULL,NULL,NULL), + (310,155,4,'b_a',185,'Sibling of',201,'Sibling of',1,NULL,NULL,NULL), + (311,156,8,'a_b',154,'Household Member of',160,'Household Member is',1,NULL,NULL,NULL), + (312,156,8,'b_a',160,'Household Member is',154,'Household Member of',1,NULL,NULL,NULL), + (313,157,8,'a_b',185,'Household Member of',160,'Household Member is',1,NULL,NULL,NULL), + (314,157,8,'b_a',160,'Household Member is',185,'Household Member of',1,NULL,NULL,NULL), + (315,158,8,'a_b',201,'Household Member of',160,'Household Member is',1,NULL,NULL,NULL), + (316,158,8,'b_a',160,'Household Member is',201,'Household Member of',1,NULL,NULL,NULL), + (317,159,7,'a_b',91,'Head of Household for',160,'Head of Household is',1,NULL,NULL,NULL), + (318,159,7,'b_a',160,'Head of Household is',91,'Head of Household for',1,NULL,NULL,NULL), + (319,160,2,'a_b',154,'Spouse of',91,'Spouse of',1,NULL,NULL,NULL), + (320,160,2,'b_a',91,'Spouse of',154,'Spouse of',1,NULL,NULL,NULL), + (321,161,1,'a_b',166,'Child of',120,'Parent of',1,NULL,NULL,NULL), + (322,161,1,'b_a',120,'Parent of',166,'Child of',1,NULL,NULL,NULL), + (323,162,1,'a_b',169,'Child of',120,'Parent of',1,NULL,NULL,NULL), + (324,162,1,'b_a',120,'Parent of',169,'Child of',1,NULL,NULL,NULL), + (325,163,1,'a_b',166,'Child of',15,'Parent of',1,NULL,NULL,NULL), + (326,163,1,'b_a',15,'Parent of',166,'Child of',1,NULL,NULL,NULL), + (327,164,1,'a_b',169,'Child of',15,'Parent of',1,NULL,NULL,NULL), + (328,164,1,'b_a',15,'Parent of',169,'Child of',1,NULL,NULL,NULL), + (329,165,4,'a_b',169,'Sibling of',166,'Sibling of',1,NULL,NULL,NULL), + (330,165,4,'b_a',166,'Sibling of',169,'Sibling of',1,NULL,NULL,NULL), + (331,166,8,'a_b',15,'Household Member of',181,'Household Member is',1,NULL,NULL,NULL), + (332,166,8,'b_a',181,'Household Member is',15,'Household Member of',1,NULL,NULL,NULL), + (333,167,8,'a_b',166,'Household Member of',181,'Household Member is',1,NULL,NULL,NULL), + (334,167,8,'b_a',181,'Household Member is',166,'Household Member of',1,NULL,NULL,NULL), + (335,168,8,'a_b',169,'Household Member of',181,'Household Member is',1,NULL,NULL,NULL), + (336,168,8,'b_a',181,'Household Member is',169,'Household Member of',1,NULL,NULL,NULL), + (337,169,7,'a_b',120,'Head of Household for',181,'Head of Household is',1,NULL,NULL,NULL), + (338,169,7,'b_a',181,'Head of Household is',120,'Head of Household for',1,NULL,NULL,NULL), + (339,170,2,'a_b',15,'Spouse of',120,'Spouse of',1,NULL,NULL,NULL), + (340,170,2,'b_a',120,'Spouse of',15,'Spouse of',1,NULL,NULL,NULL), + (341,171,1,'a_b',194,'Child of',22,'Parent of',1,NULL,NULL,NULL), + (342,171,1,'b_a',22,'Parent of',194,'Child of',1,NULL,NULL,NULL), + (343,172,1,'a_b',83,'Child of',22,'Parent of',1,NULL,NULL,NULL), + (344,172,1,'b_a',22,'Parent of',83,'Child of',1,NULL,NULL,NULL), + (345,173,1,'a_b',194,'Child of',192,'Parent of',1,NULL,NULL,NULL), + (346,173,1,'b_a',192,'Parent of',194,'Child of',1,NULL,NULL,NULL), + (347,174,1,'a_b',83,'Child of',192,'Parent of',1,NULL,NULL,NULL), + (348,174,1,'b_a',192,'Parent of',83,'Child of',1,NULL,NULL,NULL), + (349,175,4,'a_b',83,'Sibling of',194,'Sibling of',1,NULL,NULL,NULL), + (350,175,4,'b_a',194,'Sibling of',83,'Sibling of',1,NULL,NULL,NULL), + (351,176,8,'a_b',192,'Household Member of',39,'Household Member is',1,NULL,NULL,NULL), + (352,176,8,'b_a',39,'Household Member is',192,'Household Member of',1,NULL,NULL,NULL), + (353,177,8,'a_b',194,'Household Member of',39,'Household Member is',1,NULL,NULL,NULL), + (354,177,8,'b_a',39,'Household Member is',194,'Household Member of',1,NULL,NULL,NULL), + (355,178,8,'a_b',83,'Household Member of',39,'Household Member is',1,NULL,NULL,NULL), + (356,178,8,'b_a',39,'Household Member is',83,'Household Member of',1,NULL,NULL,NULL), + (357,179,7,'a_b',22,'Head of Household for',39,'Head of Household is',1,NULL,NULL,NULL), + (358,179,7,'b_a',39,'Head of Household is',22,'Head of Household for',1,NULL,NULL,NULL), + (359,180,2,'a_b',192,'Spouse of',22,'Spouse of',1,NULL,NULL,NULL), + (360,180,2,'b_a',22,'Spouse of',192,'Spouse of',1,NULL,NULL,NULL), + (361,181,1,'a_b',19,'Child of',57,'Parent of',1,NULL,NULL,NULL), + (362,181,1,'b_a',57,'Parent of',19,'Child of',1,NULL,NULL,NULL), + (363,182,1,'a_b',121,'Child of',57,'Parent of',1,NULL,NULL,NULL), + (364,182,1,'b_a',57,'Parent of',121,'Child of',1,NULL,NULL,NULL), + (365,183,1,'a_b',19,'Child of',125,'Parent of',1,NULL,NULL,NULL), + (366,183,1,'b_a',125,'Parent of',19,'Child of',1,NULL,NULL,NULL), + (367,184,1,'a_b',121,'Child of',125,'Parent of',1,NULL,NULL,NULL), + (368,184,1,'b_a',125,'Parent of',121,'Child of',1,NULL,NULL,NULL), + (369,185,4,'a_b',121,'Sibling of',19,'Sibling of',1,NULL,NULL,NULL), + (370,185,4,'b_a',19,'Sibling of',121,'Sibling of',1,NULL,NULL,NULL), + (371,186,8,'a_b',125,'Household Member of',50,'Household Member is',1,NULL,NULL,NULL), + (372,186,8,'b_a',50,'Household Member is',125,'Household Member of',1,NULL,NULL,NULL), + (373,187,8,'a_b',19,'Household Member of',50,'Household Member is',1,NULL,NULL,NULL), + (374,187,8,'b_a',50,'Household Member is',19,'Household Member of',1,NULL,NULL,NULL), + (375,188,8,'a_b',121,'Household Member of',50,'Household Member is',1,NULL,NULL,NULL), + (376,188,8,'b_a',50,'Household Member is',121,'Household Member of',1,NULL,NULL,NULL), + (377,189,7,'a_b',57,'Head of Household for',50,'Head of Household is',1,NULL,NULL,NULL), + (378,189,7,'b_a',50,'Head of Household is',57,'Head of Household for',1,NULL,NULL,NULL), + (379,190,2,'a_b',125,'Spouse of',57,'Spouse of',1,NULL,NULL,NULL), + (380,190,2,'b_a',57,'Spouse of',125,'Spouse of',1,NULL,NULL,NULL), + (381,191,1,'a_b',98,'Child of',16,'Parent of',1,NULL,NULL,NULL), + (382,191,1,'b_a',16,'Parent of',98,'Child of',1,NULL,NULL,NULL), + (383,192,1,'a_b',177,'Child of',16,'Parent of',1,NULL,NULL,NULL), + (384,192,1,'b_a',16,'Parent of',177,'Child of',1,NULL,NULL,NULL), + (385,193,1,'a_b',98,'Child of',54,'Parent of',1,NULL,NULL,NULL), + (386,193,1,'b_a',54,'Parent of',98,'Child of',1,NULL,NULL,NULL), + (387,194,1,'a_b',177,'Child of',54,'Parent of',1,NULL,NULL,NULL), + (388,194,1,'b_a',54,'Parent of',177,'Child of',1,NULL,NULL,NULL), + (389,195,4,'a_b',177,'Sibling of',98,'Sibling of',1,NULL,NULL,NULL), + (390,195,4,'b_a',98,'Sibling of',177,'Sibling of',1,NULL,NULL,NULL), + (391,196,8,'a_b',54,'Household Member of',182,'Household Member is',1,NULL,NULL,NULL), + (392,196,8,'b_a',182,'Household Member is',54,'Household Member of',1,NULL,NULL,NULL), + (393,197,8,'a_b',98,'Household Member of',182,'Household Member is',1,NULL,NULL,NULL), + (394,197,8,'b_a',182,'Household Member is',98,'Household Member of',1,NULL,NULL,NULL), + (395,198,8,'a_b',177,'Household Member of',182,'Household Member is',1,NULL,NULL,NULL), + (396,198,8,'b_a',182,'Household Member is',177,'Household Member of',1,NULL,NULL,NULL), + (397,199,7,'a_b',16,'Head of Household for',182,'Head of Household is',0,NULL,NULL,NULL), + (398,199,7,'b_a',182,'Head of Household is',16,'Head of Household for',0,NULL,NULL,NULL), + (399,200,2,'a_b',54,'Spouse of',16,'Spouse of',0,NULL,NULL,NULL), + (400,200,2,'b_a',16,'Spouse of',54,'Spouse of',0,NULL,NULL,NULL), + (401,201,5,'a_b',166,'Employee of',21,'Employer of',1,NULL,NULL,NULL), + (402,201,5,'b_a',21,'Employer of',166,'Employee of',1,NULL,NULL,NULL), + (403,202,5,'a_b',30,'Employee of',34,'Employer of',1,NULL,NULL,NULL), + (404,202,5,'b_a',34,'Employer of',30,'Employee of',1,NULL,NULL,NULL), + (405,203,5,'a_b',18,'Employee of',48,'Employer of',1,NULL,NULL,NULL), + (406,203,5,'b_a',48,'Employer of',18,'Employee of',1,NULL,NULL,NULL), + (407,204,5,'a_b',89,'Employee of',61,'Employer of',1,NULL,NULL,NULL), + (408,204,5,'b_a',61,'Employer of',89,'Employee of',1,NULL,NULL,NULL), + (409,205,5,'a_b',138,'Employee of',80,'Employer of',1,NULL,NULL,NULL), + (410,205,5,'b_a',80,'Employer of',138,'Employee of',1,NULL,NULL,NULL), + (411,206,5,'a_b',129,'Employee of',99,'Employer of',1,NULL,NULL,NULL), + (412,206,5,'b_a',99,'Employer of',129,'Employee of',1,NULL,NULL,NULL), + (413,207,5,'a_b',43,'Employee of',113,'Employer of',1,NULL,NULL,NULL), + (414,207,5,'b_a',113,'Employer of',43,'Employee of',1,NULL,NULL,NULL), + (415,208,5,'a_b',185,'Employee of',116,'Employer of',1,NULL,NULL,NULL), + (416,208,5,'b_a',116,'Employer of',185,'Employee of',1,NULL,NULL,NULL), + (417,209,5,'a_b',58,'Employee of',122,'Employer of',1,NULL,NULL,NULL), + (418,209,5,'b_a',122,'Employer of',58,'Employee of',1,NULL,NULL,NULL), + (419,210,5,'a_b',155,'Employee of',124,'Employer of',1,NULL,NULL,NULL), + (420,210,5,'b_a',124,'Employer of',155,'Employee of',1,NULL,NULL,NULL), + (421,211,5,'a_b',91,'Employee of',126,'Employer of',1,NULL,NULL,NULL), + (422,211,5,'b_a',126,'Employer of',91,'Employee of',1,NULL,NULL,NULL), + (423,212,5,'a_b',187,'Employee of',152,'Employer of',1,NULL,NULL,NULL), + (424,212,5,'b_a',152,'Employer of',187,'Employee of',1,NULL,NULL,NULL), + (425,213,5,'a_b',190,'Employee of',163,'Employer of',1,NULL,NULL,NULL), + (426,213,5,'b_a',163,'Employer of',190,'Employee of',1,NULL,NULL,NULL), + (427,214,5,'a_b',82,'Employee of',191,'Employer of',1,NULL,NULL,NULL), + (428,214,5,'b_a',191,'Employer of',82,'Employee of',1,NULL,NULL,NULL); /*!40000 ALTER TABLE `civicrm_relationship_cache` ENABLE KEYS */; UNLOCK TABLES; @@ -12025,90 +12014,90 @@ UNLOCK TABLES; LOCK TABLES `civicrm_subscription_history` WRITE; /*!40000 ALTER TABLE `civicrm_subscription_history` DISABLE KEYS */; INSERT INTO `civicrm_subscription_history` (`id`, `contact_id`, `group_id`, `date`, `method`, `status`, `tracking`) VALUES - (1,23,2,'2022-03-14 14:54:56','Email','Added',NULL), - (2,65,2,'2021-06-14 23:43:43','Admin','Added',NULL), - (3,15,2,'2021-12-25 02:21:28','Admin','Added',NULL), - (4,22,2,'2021-12-22 09:10:56','Admin','Added',NULL), - (5,170,2,'2021-10-05 09:26:53','Admin','Added',NULL), - (6,83,2,'2021-11-09 05:13:35','Admin','Added',NULL), - (7,197,2,'2021-06-30 08:36:14','Admin','Added',NULL), - (8,161,2,'2021-09-29 05:15:01','Admin','Added',NULL), - (9,199,2,'2022-02-03 14:23:01','Admin','Added',NULL), - (10,116,2,'2022-03-28 23:42:00','Admin','Added',NULL), - (11,147,2,'2022-04-21 12:52:18','Email','Added',NULL), - (12,149,2,'2021-08-06 09:34:53','Admin','Added',NULL), - (13,136,2,'2021-10-30 11:41:28','Admin','Added',NULL), - (14,100,2,'2021-08-29 14:27:04','Admin','Added',NULL), - (15,115,2,'2022-04-04 12:26:22','Admin','Added',NULL), - (16,76,2,'2021-11-24 19:48:48','Admin','Added',NULL), - (17,107,2,'2021-06-26 10:34:12','Email','Added',NULL), - (18,28,2,'2022-05-03 06:36:05','Admin','Added',NULL), - (19,54,2,'2021-05-20 03:23:14','Admin','Added',NULL), - (20,9,2,'2022-04-06 17:43:16','Email','Added',NULL), - (21,10,2,'2021-09-15 04:56:07','Email','Added',NULL), - (22,160,2,'2021-06-28 09:57:08','Email','Added',NULL), - (23,130,2,'2021-05-30 14:20:13','Admin','Added',NULL), - (24,193,2,'2021-10-21 18:51:44','Email','Added',NULL), - (25,66,2,'2021-11-08 15:48:08','Admin','Added',NULL), - (26,77,2,'2021-12-23 07:10:17','Admin','Added',NULL), - (27,179,2,'2022-02-23 04:29:55','Email','Added',NULL), - (28,45,2,'2021-08-16 16:26:45','Email','Added',NULL), - (29,132,2,'2022-01-31 15:19:49','Admin','Added',NULL), - (30,68,2,'2022-01-27 18:20:13','Email','Added',NULL), - (31,142,2,'2022-03-14 09:20:16','Admin','Added',NULL), - (32,151,2,'2022-01-08 05:14:08','Admin','Added',NULL), - (33,101,2,'2021-05-14 01:13:22','Admin','Added',NULL), - (34,138,2,'2021-07-24 16:22:35','Email','Added',NULL), - (35,38,2,'2021-08-11 05:03:30','Email','Added',NULL), - (36,144,2,'2021-09-17 14:08:21','Email','Added',NULL), - (37,172,2,'2022-04-26 00:25:29','Admin','Added',NULL), - (38,123,2,'2021-05-19 18:19:34','Email','Added',NULL), - (39,196,2,'2021-12-17 02:40:35','Admin','Added',NULL), - (40,194,2,'2022-01-24 20:44:20','Email','Added',NULL), - (41,181,2,'2021-10-19 12:23:38','Admin','Added',NULL), - (42,126,2,'2022-02-17 08:06:39','Admin','Added',NULL), - (43,27,2,'2021-06-16 14:21:58','Admin','Added',NULL), - (44,84,2,'2021-10-29 18:55:10','Email','Added',NULL), - (45,87,2,'2022-04-26 02:08:01','Email','Added',NULL), - (46,44,2,'2021-09-30 23:08:44','Email','Added',NULL), - (47,67,2,'2021-11-28 12:41:32','Email','Added',NULL), - (48,88,2,'2021-12-15 16:48:51','Email','Added',NULL), - (49,42,2,'2021-12-31 08:27:41','Email','Added',NULL), - (50,91,2,'2022-01-24 21:43:03','Email','Added',NULL), - (51,17,2,'2021-06-20 14:45:50','Email','Added',NULL), - (52,29,2,'2022-02-11 15:01:37','Email','Added',NULL), - (53,32,2,'2021-05-30 23:24:59','Email','Added',NULL), - (54,75,2,'2021-11-18 10:32:23','Email','Added',NULL), - (55,178,2,'2021-11-26 22:07:01','Admin','Added',NULL), - (56,80,2,'2022-01-21 19:18:05','Admin','Added',NULL), - (57,164,2,'2021-11-29 17:42:45','Email','Added',NULL), - (58,92,2,'2022-02-16 05:44:32','Email','Added',NULL), - (59,13,2,'2021-11-19 21:28:23','Email','Added',NULL), - (60,103,2,'2021-12-24 04:15:12','Email','Added',NULL), - (61,21,3,'2021-12-02 21:57:05','Email','Added',NULL), - (62,61,3,'2022-04-09 12:12:23','Email','Added',NULL), - (63,174,3,'2021-10-05 15:04:34','Email','Added',NULL), - (64,50,3,'2021-05-20 00:20:43','Email','Added',NULL), - (65,175,3,'2021-09-24 02:50:49','Email','Added',NULL), - (66,62,3,'2022-04-11 11:02:13','Email','Added',NULL), - (67,188,3,'2021-07-30 19:33:05','Admin','Added',NULL), - (68,106,3,'2021-06-20 08:24:33','Email','Added',NULL), - (69,79,3,'2022-04-02 09:15:20','Admin','Added',NULL), - (70,25,3,'2022-03-20 05:18:27','Admin','Added',NULL), - (71,184,3,'2022-03-03 05:41:37','Email','Added',NULL), - (72,39,3,'2021-10-11 02:45:59','Admin','Added',NULL), - (73,198,3,'2021-12-12 08:08:42','Admin','Added',NULL), - (74,5,3,'2021-08-15 00:39:25','Email','Added',NULL), - (75,73,3,'2022-01-20 10:33:13','Email','Added',NULL), - (76,23,4,'2022-01-06 23:15:24','Admin','Added',NULL), - (77,161,4,'2021-08-22 06:17:59','Email','Added',NULL), - (78,115,4,'2022-04-18 22:25:12','Email','Added',NULL), - (79,160,4,'2022-01-18 01:13:43','Email','Added',NULL), - (80,132,4,'2022-04-27 08:59:06','Email','Added',NULL), - (81,144,4,'2021-09-28 02:51:41','Email','Added',NULL), - (82,27,4,'2022-02-15 22:35:14','Email','Added',NULL), - (83,91,4,'2021-09-29 14:05:58','Admin','Added',NULL), - (84,202,4,'2022-03-03 16:41:08','Email','Added',NULL); + (1,188,2,'2021-07-26 04:24:00','Email','Added',NULL), + (2,73,2,'2022-03-12 18:49:14','Admin','Added',NULL), + (3,77,2,'2022-01-28 00:22:42','Admin','Added',NULL), + (4,106,2,'2022-04-05 18:22:06','Email','Added',NULL), + (5,133,2,'2022-04-13 07:36:20','Email','Added',NULL), + (6,14,2,'2022-04-08 22:40:49','Email','Added',NULL), + (7,162,2,'2021-07-08 17:14:05','Email','Added',NULL), + (8,111,2,'2021-11-29 13:12:19','Admin','Added',NULL), + (9,30,2,'2021-09-13 23:49:56','Email','Added',NULL), + (10,90,2,'2021-09-15 08:02:05','Admin','Added',NULL), + (11,58,2,'2021-10-12 03:22:10','Admin','Added',NULL), + (12,135,2,'2022-05-02 01:38:33','Email','Added',NULL), + (13,195,2,'2021-10-19 07:14:52','Email','Added',NULL), + (14,142,2,'2021-10-26 12:31:09','Email','Added',NULL), + (15,46,2,'2021-12-05 19:25:36','Email','Added',NULL), + (16,11,2,'2022-06-08 09:19:36','Email','Added',NULL), + (17,187,2,'2022-05-28 17:51:09','Admin','Added',NULL), + (18,47,2,'2022-06-12 15:35:11','Email','Added',NULL), + (19,136,2,'2021-08-03 17:28:14','Email','Added',NULL), + (20,26,2,'2022-05-17 23:17:19','Admin','Added',NULL), + (21,59,2,'2022-01-24 20:00:31','Admin','Added',NULL), + (22,139,2,'2021-08-10 06:11:27','Email','Added',NULL), + (23,86,2,'2022-03-26 23:45:31','Email','Added',NULL), + (24,168,2,'2021-12-14 18:04:52','Admin','Added',NULL), + (25,123,2,'2021-08-17 20:31:28','Admin','Added',NULL), + (26,78,2,'2022-04-30 03:37:26','Email','Added',NULL), + (27,100,2,'2021-08-16 22:59:23','Admin','Added',NULL), + (28,71,2,'2022-03-27 15:02:43','Email','Added',NULL), + (29,108,2,'2022-03-11 08:16:00','Email','Added',NULL), + (30,110,2,'2021-07-03 09:48:44','Admin','Added',NULL), + (31,104,2,'2022-04-21 15:01:53','Email','Added',NULL), + (32,62,2,'2021-12-18 12:05:32','Email','Added',NULL), + (33,175,2,'2021-08-05 18:24:35','Email','Added',NULL), + (34,28,2,'2022-03-15 00:10:04','Admin','Added',NULL), + (35,70,2,'2022-05-28 22:08:53','Admin','Added',NULL), + (36,164,2,'2021-06-19 07:22:37','Admin','Added',NULL), + (37,107,2,'2022-02-11 20:53:59','Email','Added',NULL), + (38,101,2,'2021-12-31 05:28:46','Email','Added',NULL), + (39,9,2,'2021-08-01 10:19:25','Admin','Added',NULL), + (40,138,2,'2021-09-25 14:03:05','Admin','Added',NULL), + (41,2,2,'2021-11-17 10:58:22','Admin','Added',NULL), + (42,74,2,'2021-06-28 11:59:54','Admin','Added',NULL), + (43,10,2,'2021-11-26 06:00:53','Admin','Added',NULL), + (44,141,2,'2021-12-20 19:40:19','Email','Added',NULL), + (45,79,2,'2022-03-03 06:12:08','Admin','Added',NULL), + (46,12,2,'2022-04-12 01:43:36','Email','Added',NULL), + (47,93,2,'2022-03-02 18:17:11','Admin','Added',NULL), + (48,66,2,'2021-08-01 11:37:54','Email','Added',NULL), + (49,193,2,'2021-10-03 18:56:25','Email','Added',NULL), + (50,37,2,'2022-01-31 04:51:53','Email','Added',NULL), + (51,165,2,'2022-05-04 00:49:53','Email','Added',NULL), + (52,25,2,'2021-06-27 18:11:53','Email','Added',NULL), + (53,27,2,'2021-12-07 23:22:15','Email','Added',NULL), + (54,65,2,'2022-02-13 08:48:05','Admin','Added',NULL), + (55,88,2,'2021-12-10 10:13:26','Admin','Added',NULL), + (56,89,2,'2022-06-05 23:45:14','Admin','Added',NULL), + (57,36,2,'2021-12-01 05:32:11','Email','Added',NULL), + (58,184,2,'2021-11-12 14:24:35','Email','Added',NULL), + (59,167,2,'2021-07-27 17:17:25','Admin','Added',NULL), + (60,189,2,'2021-11-01 20:14:21','Admin','Added',NULL), + (61,3,3,'2022-06-04 06:09:29','Email','Added',NULL), + (62,146,3,'2021-11-19 01:53:55','Admin','Added',NULL), + (63,55,3,'2021-08-25 16:19:25','Email','Added',NULL), + (64,148,3,'2021-08-22 15:14:27','Admin','Added',NULL), + (65,4,3,'2021-10-25 20:26:24','Admin','Added',NULL), + (66,41,3,'2022-03-04 14:46:43','Admin','Added',NULL), + (67,144,3,'2022-05-13 14:17:53','Admin','Added',NULL), + (68,171,3,'2022-04-20 11:54:59','Email','Added',NULL), + (69,81,3,'2022-03-26 08:17:39','Admin','Added',NULL), + (70,200,3,'2021-07-05 01:59:21','Admin','Added',NULL), + (71,145,3,'2022-03-30 05:11:16','Email','Added',NULL), + (72,92,3,'2021-12-01 03:13:02','Email','Added',NULL), + (73,84,3,'2022-01-01 04:23:08','Admin','Added',NULL), + (74,64,3,'2022-04-23 23:50:05','Email','Added',NULL), + (75,53,3,'2021-12-26 08:11:42','Email','Added',NULL), + (76,188,4,'2021-11-25 02:51:06','Email','Added',NULL), + (77,111,4,'2021-07-14 06:26:43','Admin','Added',NULL), + (78,46,4,'2021-12-03 23:43:18','Email','Added',NULL), + (79,139,4,'2021-09-27 22:15:26','Admin','Added',NULL), + (80,108,4,'2021-12-08 05:12:23','Admin','Added',NULL), + (81,164,4,'2021-08-16 22:15:20','Admin','Added',NULL), + (82,10,4,'2022-01-20 09:04:37','Email','Added',NULL), + (83,37,4,'2021-06-16 17:36:32','Admin','Added',NULL), + (84,202,4,'2021-10-30 12:15:34','Email','Added',NULL); /*!40000 ALTER TABLE `civicrm_subscription_history` ENABLE KEYS */; UNLOCK TABLES; @@ -12334,24 +12323,24 @@ UNLOCK TABLES; LOCK TABLES `civicrm_website` WRITE; /*!40000 ALTER TABLE `civicrm_website` DISABLE KEYS */; INSERT INTO `civicrm_website` (`id`, `contact_id`, `url`, `website_type_id`) VALUES - (1,121,'http://arizonaservices.org',1), - (2,139,'http://ngmusictrust.org',1), - (3,93,'http://floridadevelopmentalliance.org',1), - (4,71,'http://mlkingmusic.org',1), - (5,169,'http://wisconsinsoftwarepartners.org',1), - (6,95,'http://tennesseeaction.org',1), - (7,120,'http://vnhealthservices.org',1), - (8,137,'http://floridatechnologysolutions.org',1), - (9,173,'http://globalassociation.org',1), - (10,141,'http://ncartsalliance.org',1), - (11,70,'http://tennesseepoetry.org',1), - (12,114,'http://wvliteracyservices.org',1), - (13,157,'http://nebraskaalliance.org',1), - (14,41,'http://ohioeducationfund.org',1), - (15,8,'http://npempowermentpartners.org',1), - (16,105,'http://urbanassociation.org',1), - (17,94,'http://bakersfieldsoftware.org',1), - (18,163,'http://evansvillepeace.org',1); + (1,163,'http://wvempowermenttrust.org',1), + (2,80,'http://auburnenvironmental.org',1), + (3,99,'http://friendswellnessfellowship.org',1), + (4,61,'http://athenssystems.org',1), + (5,132,'http://greentrust.org',1), + (6,152,'http://northpointinitiative.org',1), + (7,178,'http://urbansystems.org',1), + (8,126,'http://forbestownlegal.org',1), + (9,124,'http://progressiveartspartners.org',1), + (10,85,'http://nymusicpartnership.org',1), + (11,127,'http://clartscenter.org',1), + (12,34,'http://baymusic.org',1), + (13,113,'http://lincolntrust.org',1), + (14,6,'http://unitedmusic.org',1), + (15,116,'http://sacramentopartners.org',1), + (16,122,'http://secondmusic.org',1), + (17,191,'http://californiasystems.org',1), + (18,159,'http://griffinenvironmental.org',1); /*!40000 ALTER TABLE `civicrm_website` ENABLE KEYS */; UNLOCK TABLES; @@ -12383,13 +12372,12 @@ UNLOCK TABLES; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; -/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2022-05-04 18:47:27 +-- Dump completed on 2022-06-15 13:01:51 -- +--------------------------------------------------------------------+ -- | Copyright CiviCRM LLC. All rights reserved. | -- | | diff --git a/tests/phpunit/CRM/Contribute/Form/Task/InvoiceTest.php b/tests/phpunit/CRM/Contribute/Form/Task/InvoiceTest.php index e13e0b967c..1af09ca493 100644 --- a/tests/phpunit/CRM/Contribute/Form/Task/InvoiceTest.php +++ b/tests/phpunit/CRM/Contribute/Form/Task/InvoiceTest.php @@ -9,6 +9,9 @@ +--------------------------------------------------------------------+ */ +use Civi\Api4\Address; +use Civi\Api4\Domain; + /** * Test APIv3 civicrm_contribute_* functions * @@ -170,7 +173,9 @@ class CRM_Contribute_Form_Task_InvoiceTest extends CiviUnitTestCase { */ public function testThatInvoiceShowsTheActualContributionCurrencyInsteadOfTheDefaultOne(): void { $this->setDefaultCurrency('USD'); - + $contactID = Domain::get()->addSelect('contact_id')->execute()->first()['contact_id']; + Address::create()->setValues(['contact_id' => $contactID, 'city' => 'Beverley Hills', 'state_province_id:label' => 'California', 'country_id:label' => 'United States', 'postal_code' => 90210])->execute(); + Civi::cache('metadata')->clear(); $this->_individualId = $this->individualCreate(); $contributionID = $this->setupContribution(); @@ -189,7 +194,10 @@ class CRM_Contribute_Form_Task_InvoiceTest extends CiviUnitTestCase { $this->assertStringContainsString('Â£100.00', $invoiceHTML); $this->assertStringContainsString('Amount GBP', $invoiceHTML); $this->assertStringContainsString('TOTAL GBP', $invoiceHTML); - + $this->assertStringContainsString('California', $invoiceHTML); + $this->assertStringContainsString('90210', $invoiceHTML); + $this->assertStringContainsString('United States', $invoiceHTML); + $this->assertStringContainsString('Default Domain Name', $invoiceHTML); } /** diff --git a/tests/phpunit/CRM/Utils/TokenConsistencyTest.php b/tests/phpunit/CRM/Utils/TokenConsistencyTest.php index 6b68dd0198..51dcd0c7aa 100644 --- a/tests/phpunit/CRM/Utils/TokenConsistencyTest.php +++ b/tests/phpunit/CRM/Utils/TokenConsistencyTest.php @@ -722,6 +722,8 @@ December 21st, 2007 /** * Test that domain tokens are consistently rendered. + * + * @throws \CRM_Core_Exception */ public function testDomainTokenConsistency(): void { $tokens = CRM_Core_SelectValues::domainTokens(); @@ -730,10 +732,16 @@ December 21st, 2007 'controller' => __CLASS__, 'smarty' => FALSE, ]); - $tokens['{domain.id}'] = 'Domain ID'; - $tokens['{domain.description}'] = 'Domain Description'; - $tokens['{domain.now}'] = 'Current time/date'; + $contactID = \Civi\Api4\Domain::get()->addSelect('contact_id')->execute()->first()['contact_id']; + Address::create()->setValues(['contact_id' => $contactID, 'city' => 'Beverley Hills', 'state_province_id:label' => 'California', 'country_id:label' => 'United States', 'postal_code' => 90210])->execute(); $this->assertEquals($tokens, $tokenProcessor->listTokens()); + $tokenProcessor->addMessage('message', implode("\n", array_keys($tokens)), 'text/plain'); + $tokenProcessor->addRow(); + $tokenProcessor->evaluate(); + $this->assertStringContainsString('Beverley Hills +90210 +California +United States', $tokenProcessor->getRow(0)->render('message')); } /** @@ -791,6 +799,14 @@ December 21st, 2007 '{domain.description}' => ts('Domain Description'), '{domain.now}' => 'Current time/date', '{domain.tax_term}' => 'Sales tax term (e.g VAT)', + '{domain.street_address}' => 'Domain (organization) street address', + '{domain.supplemental_address_1}' => 'Domain (organization) Supplemental Address', + '{domain.supplemental_address_2}' => 'Domain (organization) Supplemental Address 2', + '{domain.supplemental_address_3}' => 'Domain (organization) Supplemental Address 3', + '{domain.city}' => 'Domain (organization) City', + '{domain.postal_code}' => 'Domain (organization) Postal Code', + '{domain.state_province_id:label}' => 'Domain (organization) State', + '{domain.country_id:label}' => 'Domain (organization) Country', ]; } diff --git a/xml/templates/message_templates/contribution_invoice_receipt_html.tpl b/xml/templates/message_templates/contribution_invoice_receipt_html.tpl index d0a6d7f03d..d2a8b62de8 100644 --- a/xml/templates/message_templates/contribution_invoice_receipt_html.tpl +++ b/xml/templates/message_templates/contribution_invoice_receipt_html.tpl @@ -17,7 +17,7 @@

{ts}INVOICE{/ts}

{ts}Invoice Date:{/ts}

{$domain_organization}

{domain.name}

{$invoice_date}

- {if $domain_street_address }{$domain_street_address}{/if} - {if $domain_supplemental_address_1 }{$domain_supplemental_address_1}{/if} + {domain.street_address} + {domain.supplemental_address_1}

{ts}Invoice Number:{/ts}

- {if $domain_supplemental_address_2 }{$domain_supplemental_address_2}{/if} - {if $domain_state }{$domain_state}{/if} + {domain.supplemental_address_2} + {domain.state_province_id:label}

{$supplemental_address_2} {$stateProvinceAbbreviation}

{$invoice_number}

{contribution.invoice_number}

- {if $domain_city}{$domain_city}{/if} - {if $domain_postal_code }{$domain_postal_code}{/if} + {domain.city} + {domain.postal_code}

{$city} {$postal_code}

{ts}Reference:{/ts}

{if $domain_country}{$domain_country}{/if}

{domain.country_id:label}

{$country}

{if !empty($source)}{$source}{/if}

{if $domain_email}{$domain_email}{/if}

{contribution.source}

{domain.email}

{if $domain_phone}{$domain_phone}{/if}

{domain.phone}

@@ -75,7 +75,7 @@ {ts}Description{/ts} {ts}Quantity{/ts} {ts}Unit Price{/ts} - {$taxTerm} + {domain.tax_term} {ts 1=$currency}Amount %1{/ts} {foreach from=$lineItem item=value key=priceset name=taxpricevalue} @@ -175,13 +175,13 @@ - + {if $organization_name} @@ -240,8 +240,8 @@ @@ -250,8 +250,8 @@ @@ -260,8 +260,8 @@ @@ -270,7 +270,7 @@ @@ -279,7 +279,7 @@ @@ -288,7 +288,7 @@ @@ -302,7 +302,7 @@ - + {foreach from=$lineItem item=value key=priceset name=pricevalue} -- 2.25.1

{ts}Description{/ts}	{ts}Quantity{/ts}	{ts}Unit Price{/ts}	{$taxTerm}
{ts}PAYMENT ADVICE{/ts} {ts}To:{/ts} - {$domain_organization} - {$domain_street_address} {$domain_supplemental_address_1} - {$domain_supplemental_address_2} {$domain_state} - {$domain_city} {$domain_postal_code} - {$domain_country} - {$domain_email} - {$domain_phone} + {domain.name} + {domain.street_address} {domain.supplemental_address_1} + {domain.supplemental_address_2} {domain.state_province_id:label} + {domain.city} {domain.postal_code} + {domain.country_id:label} + {domain.email} + {domain.phone} {$notes}	@@ -229,7 +229,7 @@
{ts}CREDIT NOTE{/ts}	{ts}Date:{/ts}	{$domain_organization}	{domain.name}
{$invoice_date}	- {if $domain_street_address }{$domain_street_address}{/if} - {if $domain_supplemental_address_1 }{$domain_supplemental_address_1}{/if} + {domain.street_address} + {domain.supplemental_address_1}
{ts}Credit Note Number:{/ts}	- {if $domain_supplemental_address_2 }{$domain_supplemental_address_2}{/if} - {if $domain_state }{$domain_state}{/if} + {domain.supplemental_address_2} + {domain.state_province_id:label}
{$creditnote_id}	- {if $domain_city}{$domain_city}{/if} - {if $domain_postal_code }{$domain_postal_code}{/if} + {domain.city} + {domain.postal_code}
{ts}Reference:{/ts}	- {if $domain_country}{$domain_country}{/if} + {domain.country_id:label}
{$source}	- {if $domain_email}{$domain_email}{/if} + {domain.email}
	- {if $domain_phone}{$domain_phone}{/if} + {domain.phone}