-- Delete existing entries in table
DELETE SHIPPINGWEBPAIR

-- Add entries for UPS carrier
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (1,'CompanyorName','<<SHIPPINGEDIT.Company>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (1,'Contact','<<SHIPPINGEDIT.Name>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (1,'StreetAddress','<<SHIPPINGEDIT.StreetAddress>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (1,'Address2','<<SHIPPINGEDIT.StreetAddress2>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (1,'City','<<SHIPPINGEDIT.City>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (1,'State','<<SHIPPINGEDIT.State>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (1,'Zip','<<SHIPPINGEDIT.Zip>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (1,'Country1','<<SHIPPINGEDIT.Country>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (1,'Phone','<<SHIPPINGEDIT.PhoneNumber>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (1,'Weight','<<SHIPPINGEDIT.TotalWeight>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (1,'Insurance','<<SHIPPINGEDIT.DeclaredValue>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (1,'EmailMsgField',' Your order has shipped.')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (1,'Email','<<SHIPPINGEDIT.EMAILADDRESS>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (1,'InquiryNumber1','<<SHIPPINGEDIT.TRACKINGNUMBER>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (1,'EmailNotify1','<<SHIPPINGEDIT.EMAILADDRESS>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (1,'Reference1','<<SHIPPINGEDIT.TRANSACTIONNUMBER>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (1,'Reference2','<<SHIPPINGEDIT.NOTES>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (1,'ServiceDetail','<<SHIPPINGEDIT.Service>>')

-- Add entries for FedEx carrier
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (2,'recip_name','<<SHIPPINGEDIT.Name>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (2,'recip_comp','<<SHIPPINGEDIT.Company>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (2,'recip_addr1','<<SHIPPINGEDIT.StreetAddress>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (2,'recip_addr2','<<SHIPPINGEDIT.StreetAddress2>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (2,'recip_city','<<SHIPPINGEDIT.City>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (2,'recip_state','<<SHIPPINGEDIT.State>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (2,'recip_zip','<<SHIPPINGEDIT.Zip>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (2,'recip_phone','<<SHIPPINGEDIT.PhoneNumber>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (2,'send_name','<<Store.Name>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (2,'send_comp','<<Store.Name>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (2,'send_addr1','<<Store.Address1>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (2,'send_addr2','<<Store.Address2>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (2,'send_city','<<Store.City>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (2,'send_zip','<<Store.Zip>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (2,'send_state','<<Store.State>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (2,'send_phone','<<Store.Phone>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (2,'service','<<SHIPPINGEDIT.Service>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (2,'weight','<<SHIPPINGEDIT.TotalWeight>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (2,'dec_value','<<SHIPPINGEDIT.DeclaredValue>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (2,'ref_info','<<SHIPPINGEDIT.TRANSACTIONNUMBER>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (2,'recip_email0','<<SHIPPINGEDIT.EMAILADDRESS>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (2,'email_message','Your order has shipped.')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (2,'tracknumbers','<<SHIPPINGEDIT.TRACKINGNUMBER>>')
INSERT INTO SHIPPINGWEBPAIR (CarrierID, Variable, Value) VALUES (2,'Country','<<SHIPPINGEDIT.Country>>')

-- Add entries for FedEx carrier
INSERT INTO SHIPPINGWEBPAIR (URL, Variable, Value, LastUpdated) VALUES ('www.myquicksell.com/register','Name','<<Store.Name>>', CURRENT_TIMESTAMP)
INSERT INTO SHIPPINGWEBPAIR (URL, Variable, Value, LastUpdated) VALUES ('www.myquicksell.com/register','Address','<<Store.Address1>>', CURRENT_TIMESTAMP)
INSERT INTO SHIPPINGWEBPAIR (URL, Variable, Value, LastUpdated) VALUES ('www.myquicksell.com/register','Address2','<<Store.Address2>>', CURRENT_TIMESTAMP)
INSERT INTO SHIPPINGWEBPAIR (URL, Variable, Value, LastUpdated) VALUES ('www.myquicksell.com/register','City','<<Store.City>>', CURRENT_TIMESTAMP)
INSERT INTO SHIPPINGWEBPAIR (URL, Variable, Value, LastUpdated) VALUES ('www.myquicksell.com/register','State','<<Store.State>>', CURRENT_TIMESTAMP)
INSERT INTO SHIPPINGWEBPAIR (URL, Variable, Value, LastUpdated) VALUES ('www.myquicksell.com/register','Country','<<Store.Country>>', CURRENT_TIMESTAMP)
INSERT INTO SHIPPINGWEBPAIR (URL, Variable, Value, LastUpdated) VALUES ('www.myquicksell.com/register','Zip','<<Store.Zip>>', CURRENT_TIMESTAMP)
INSERT INTO SHIPPINGWEBPAIR (URL, Variable, Value, LastUpdated) VALUES ('www.myquicksell.com/register','PhoneNumber','<<Store.Phone>>', CURRENT_TIMESTAMP)
INSERT INTO SHIPPINGWEBPAIR (URL, Variable, Value, LastUpdated) VALUES ('www.myquicksell.com/register','FaxNumber','<<Store.Fax>>', CURRENT_TIMESTAMP)
INSERT INTO SHIPPINGWEBPAIR (URL, Variable, Value, LastUpdated) VALUES ('www.myquicksell.com/register','Email','<<Store.Email>>', CURRENT_TIMESTAMP)
INSERT INTO SHIPPINGWEBPAIR (URL, Variable, Value, LastUpdated) VALUES ('www.myquicksell.com/register','Product','QuickSell Commerce', CURRENT_TIMESTAMP)
INSERT INTO SHIPPINGWEBPAIR (URL, Variable, Value, LastUpdated) VALUES ('www.myquicksell.com/register','Version','<<License.Version>>', CURRENT_TIMESTAMP)
INSERT INTO SHIPPINGWEBPAIR (URL, Variable, Value, LastUpdated) VALUES ('www.myquicksell.com/register','SerialNumber','<<License.SerialNumber>>', CURRENT_TIMESTAMP)
INSERT INTO SHIPPINGWEBPAIR (URL, Variable, Value, LastUpdated) VALUES ('www.myquicksell.com/register','LicenseRating','<<License.License>>', CURRENT_TIMESTAMP)

