INSERT INTO WebClient
(
	WebClientID,
	CustomerID,
	ClientToken,
	ClientName,
	UserName,
	UserPassword,
	AdminContactEmail,
	ShowPrices,
	PriceMarkup,
	ShowContactLink,
	ContactName,
	ContactEmail,
	ContactPhone
)
VALUES
(
	NULL,
	'{{{CustomerID}}}',
	'{{{ClientToken}}}',
	'{{{DisplayName}}}',
	'{{{UserName}}}',
	PASSWORD( '{{{UserPassword}}}' ),
	'{{{AdminContactEmail}}}',
	'{{{ShowPrices}}}',
	{{#PriceMarkup}}'{{{PriceMarkup}}}'{{/PriceMarkup}}{{^PriceMarkup}}NULL{{/PriceMarkup}},
	'{{{ShowContactPage}}}',
    {{#ContactName}}'{{{ContactName}}}'{{/ContactName}}{{^ContactName}}NULL{{/ContactName}},
    {{#ContactEmail}}'{{{ContactEmail}}}'{{/ContactEmail}}{{^ContactEmail}}NULL{{/ContactEmail}},
    {{#ContactPhone}}'{{{ContactPhone}}}'{{/ContactPhone}}{{^ContactPhone}}NULL{{/ContactPhone}} 
)