SET IDENTITY_INSERT [Store] ON 

INSERT [Store] ([Id], [Name], [Url], [SslEnabled], [Hosts], [DefaultLanguageId], [DisplayOrder], [CompanyName], [CompanyAddress], [CompanyPhoneNumber], [CompanyVat]) VALUES (1, N'Your store name', N'http://www.yourstore.com/', 0, N'yourstore.com,www.yourstore.com', 0, 1, N'Your company name', N'your company country, state, zip, street, etc', N'(123) 456-78901', NULL)
SET IDENTITY_INSERT [Store]  OFF
GO
SET IDENTITY_INSERT [ProductAvailabilityRange] ON 

INSERT [ProductAvailabilityRange] ([Id], [Name], [DisplayOrder]) VALUES (1, N'2-4 days', 1)
INSERT [ProductAvailabilityRange] ([Id], [Name], [DisplayOrder]) VALUES (2, N'7-10 days', 2)
INSERT [ProductAvailabilityRange] ([Id], [Name], [DisplayOrder]) VALUES (3, N'2 week', 3)
SET IDENTITY_INSERT [ProductAvailabilityRange]  OFF
GO
SET IDENTITY_INSERT [MessageTemplate] ON 

INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (1, N'Blog.BlogComment', NULL, N'%Store.Name%. New blog comment.', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
A new blog comment has been created for blog post "%BlogComment.BlogPostTitle%".
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (2, N'QuantityBelow.StoreOwnerNotification', NULL, N'%Store.Name%. Quantity below notification. %Product.Name%', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
%Product.Name% (ID: %Product.ID%) low quantity.
<br />
<br />
Quantity: %Product.StockQuantity%
<br />
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (3, N'QuantityBelow.AttributeCombination.StoreOwnerNotification', NULL, N'%Store.Name%. Quantity below notification. %Product.Name%', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
%Product.Name% (ID: %Product.ID%) low quantity.
<br />
%AttributeCombination.Formatted%
<br />
Quantity: %AttributeCombination.StockQuantity%
<br />
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (4, N'ReturnRequestStatusChanged.CustomerNotification', NULL, N'%Store.Name%. Return request status was changed.', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
Hello %Customer.FullName%,
<br />
Your return request #%ReturnRequest.CustomNumber% status has been changed.
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (5, N'Service.EmailAFriend', NULL, N'%Store.Name%. Referred Item', N'<p>
<a href="%Store.URL%"> %Store.Name%</a>
<br />
<br />
%EmailAFriend.Email% was shopping on %Store.Name% and wanted to share the following item with you.
<br />
<br />
<b><a target="_blank" href="%Product.ProductURLForCustomer%">%Product.Name%</a></b>
<br />
%Product.ShortDescription%
<br />
<br />
For more info click <a target="_blank" href="%Product.ProductURLForCustomer%">here</a>
<br />
<br />
<br />
%EmailAFriend.PersonalMessage%
<br />
<br />
%Store.Name%
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (6, N'Wishlist.EmailAFriend', NULL, N'%Store.Name%. Wishlist', N'<p>
<a href="%Store.URL%"> %Store.Name%</a>
<br />
<br />
%Wishlist.Email% was shopping on %Store.Name% and wanted to share a wishlist with you.
<br />
<br />
<br />
For more info click <a target="_blank" href="%Wishlist.URLForCustomer%">here</a>
<br />
<br />
<br />
%Wishlist.PersonalMessage%
<br />
<br />
%Store.Name%
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (7, N'Customer.NewOrderNote', NULL, N'%Store.Name%. New order note has been added', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
Hello %Customer.FullName%,
<br />
New order note has been added to your account:
<br />
"%Order.NewNoteText%".
<br />
<a target="_blank" href="%Order.OrderURLForCustomer%">%Order.OrderURLForCustomer%</a>
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (8, N'RecurringPaymentCancelled.StoreOwnerNotification', NULL, N'%Store.Name%. Recurring payment cancelled', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
%if (%RecurringPayment.CancelAfterFailedPayment%) The last payment for the recurring payment ID=%RecurringPayment.ID% failed, so it was cancelled. endif% %if (!%RecurringPayment.CancelAfterFailedPayment%) %Customer.FullName% (%Customer.Email%) has just cancelled a recurring payment ID=%RecurringPayment.ID%. endif%
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (9, N'RecurringPaymentCancelled.CustomerNotification', NULL, N'%Store.Name%. Recurring payment cancelled', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
Hello %Customer.FullName%,
<br />
%if (%RecurringPayment.CancelAfterFailedPayment%) It appears your credit card didn''t go through for this recurring payment (<a href="%Order.OrderURLForCustomer%" target="_blank">%Order.OrderURLForCustomer%</a>)
<br />
So your subscription has been cancelled. endif% %if (!%RecurringPayment.CancelAfterFailedPayment%) The recurring payment ID=%RecurringPayment.ID% was cancelled. endif%
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (10, N'RecurringPaymentFailed.CustomerNotification', NULL, N'%Store.Name%. Last recurring payment failed', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
Hello %Customer.FullName%,
<br />
It appears your credit card didn''t go through for this recurring payment (<a href="%Order.OrderURLForCustomer%" target="_blank">%Order.OrderURLForCustomer%</a>)
<br /> %if (%RecurringPayment.RecurringPaymentType% == "Manual") 
You can recharge balance and manually retry payment or cancel it on the order history page. endif% %if (%RecurringPayment.RecurringPaymentType% == "Automatic") 
You can recharge balance and wait, we will try to make the payment again, or you can cancel it on the order history page. endif%
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (11, N'OrderPlaced.VendorNotification', NULL, N'%Store.Name%. Order placed', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
%Customer.FullName% (%Customer.Email%) has just placed an order.
<br />
<br />
Order Number: %Order.OrderNumber%
<br />
Date Ordered: %Order.CreatedOn%
<br />
<br />
%Order.Product(s)%
</p>
', 0, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (12, N'OrderPlaced.AffiliateNotification', NULL, N'%Store.Name%. Order placed', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
%Customer.FullName% (%Customer.Email%) has just placed an order.
<br />
<br />
Order Number: %Order.OrderNumber%
<br />
Date Ordered: %Order.CreatedOn%
<br />
<br />
%Order.Product(s)%
</p>
', 0, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (13, N'OrderRefunded.CustomerNotification', NULL, N'%Store.Name%. Order #%Order.OrderNumber% refunded', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
Hello %Order.CustomerFullName%,
<br />
Thanks for buying from <a href="%Store.URL%">%Store.Name%</a>. Order #%Order.OrderNumber% has been has been refunded. Please allow 7-14 days for the refund to be reflected in your account.
<br />
<br />
Amount refunded: %Order.AmountRefunded%
<br />
<br />
Below is the summary of the order.
<br />
<br />
Order Number: %Order.OrderNumber%
<br />
Order Details: <a href="%Order.OrderURLForCustomer%" target="_blank">%Order.OrderURLForCustomer%</a>
<br />
Date Ordered: %Order.CreatedOn%
<br />
<br />
<br />
<br />
Billing Address
<br />
%Order.BillingFirstName% %Order.BillingLastName%
<br />
%Order.BillingAddress1%
<br />
%Order.BillingCity% %Order.BillingZipPostalCode%
<br />
%Order.BillingStateProvince% %Order.BillingCountry%
<br />
<br />
<br />
<br />
%if (%Order.Shippable%) Shipping Address
<br />
%Order.ShippingFirstName% %Order.ShippingLastName%
<br />
%Order.ShippingAddress1%
<br />
%Order.ShippingCity% %Order.ShippingZipPostalCode%
<br />
%Order.ShippingStateProvince% %Order.ShippingCountry%
<br />
<br /
>Shipping Method: %Order.ShippingMethod%
<br />
<br />
 endif% %Order.Product(s)%
</p>
', 0, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (14, N'OrderRefunded.StoreOwnerNotification', NULL, N'%Store.Name%. Order #%Order.OrderNumber% refunded', N'%Store.Name%. Order #%Order.OrderNumber% refunded'', N''
<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
Order #%Order.OrderNumber% has been just refunded
<br />
<br />
Amount refunded: %Order.AmountRefunded%
<br />
<br />
Date Ordered: %Order.CreatedOn%
</p>
', 0, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (15, N'OrderPaid.StoreOwnerNotification', NULL, N'%Store.Name%. Order #%Order.OrderNumber% paid', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
Order #%Order.OrderNumber% has been just paid
<br />
Date Ordered: %Order.CreatedOn%
</p>
', 0, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (16, N'OrderPaid.CustomerNotification', NULL, N'%Store.Name%. Order #%Order.OrderNumber% paid', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
Hello %Order.CustomerFullName%,
<br />
Thanks for buying from <a href="%Store.URL%">%Store.Name%</a>. Order #%Order.OrderNumber% has been just paid. Below is the summary of the order.
<br />
<br />
Order Number: %Order.OrderNumber%
<br />
Order Details: <a href="%Order.OrderURLForCustomer%" target="_blank">%Order.OrderURLForCustomer%</a>
<br />
Date Ordered: %Order.CreatedOn%
<br />
<br />
<br />
<br />
Billing Address
<br />
%Order.BillingFirstName% %Order.BillingLastName%
<br />
%Order.BillingAddress1%
<br />
%Order.BillingCity% %Order.BillingZipPostalCode%
<br />
%Order.BillingStateProvince% %Order.BillingCountry%
<br />
<br />
<br />
<br />
%if (%Order.Shippable%) Shipping Address
<br />
%Order.ShippingFirstName% %Order.ShippingLastName%
<br />
%Order.ShippingAddress1%
<br />
%Order.ShippingCity% %Order.ShippingZipPostalCode%
<br />
%Order.ShippingStateProvince% %Order.ShippingCountry%
<br />
<br />
Shipping Method: %Order.ShippingMethod%
<br />
<br />
 endif% %Order.Product(s)%
</p>
', 0, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (17, N'OrderPaid.VendorNotification', NULL, N'%Store.Name%. Order #%Order.OrderNumber% paid', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
Order #%Order.OrderNumber% has been just paid.
<br />
<br />
Order Number: %Order.OrderNumber%
<br />
Date Ordered: %Order.CreatedOn%
<br />
<br />
%Order.Product(s)%
</p>
', 0, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (18, N'OrderPaid.AffiliateNotification', NULL, N'%Store.Name%. Order #%Order.OrderNumber% paid', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
Order #%Order.OrderNumber% has been just paid.
<br />
<br />
Order Number: %Order.OrderNumber%
<br />
Date Ordered: %Order.CreatedOn%
<br />
<br />
%Order.Product(s)%
</p>
', 0, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (19, N'VendorAccountApply.StoreOwnerNotification', NULL, N'%Store.Name%. New vendor account submitted.', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
%Customer.FullName% (%Customer.Email%) has just submitted for a vendor account. Details are below:
<br />
Vendor name: %Vendor.Name%
<br />
Vendor email: %Vendor.Email%
<br />
<br />
You can activate it in admin area.
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (20, N'VendorInformationChange.StoreOwnerNotification', NULL, N'%Store.Name%. Vendor information change.', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
Vendor %Vendor.Name% (%Vendor.Email%) has just changed information about itself.
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (21, N'ProductReview.Reply.CustomerNotification', NULL, N'%Store.Name%. Product review reply.', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
Hello %Customer.FullName%,
<br />
You received a reply from the store administration to your review for product "%ProductReview.ProductName%".
</p>
', 0, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (22, N'Product.ProductReview', NULL, N'%Store.Name%. New product review.', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
A new product review has been written for product "%ProductReview.ProductName%".
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (23, N'ShipmentSent.CustomerNotification', NULL, N'Your order from %Store.Name% has been shipped.', N'<p>
<a href="%Store.URL%"> %Store.Name%</a>
<br />
<br />
Hello %Order.CustomerFullName%!,
<br />
Good news! You order has been shipped.
<br />
Order Number: %Order.OrderNumber%
<br />
Order Details: <a href="%Order.OrderURLForCustomer%" target="_blank">%Order.OrderURLForCustomer%</a>
<br />
Date Ordered: %Order.CreatedOn%
<br />
<br />
<br />
<br />
Billing Address
<br />
%Order.BillingFirstName% %Order.BillingLastName%
<br />
%Order.BillingAddress1%
<br />
%Order.BillingCity% %Order.BillingZipPostalCode%
<br />
%Order.BillingStateProvince% %Order.BillingCountry%
<br />
<br />
<br />
<br />
%if (%Order.Shippable%) Shipping Address
<br />
%Order.ShippingFirstName% %Order.ShippingLastName%
<br />
%Order.ShippingAddress1%
<br />
%Order.ShippingCity% %Order.ShippingZipPostalCode%
<br />
%Order.ShippingStateProvince% %Order.ShippingCountry%
<br />
<br />
Shipping Method: %Order.ShippingMethod%
<br />
<br />
 endif% Shipped Products:
<br />
<br />
%Shipment.Product(s)%
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (24, N'OrderPlaced.StoreOwnerNotification', NULL, N'%Store.Name%. Purchase Receipt for Order #%Order.OrderNumber%', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
%Order.CustomerFullName% (%Order.CustomerEmail%) has just placed an order from your store. Below is the summary of the order.
<br />
<br />
Order Number: %Order.OrderNumber%
<br />
Date Ordered: %Order.CreatedOn%
<br />
<br />
<br />
<br />
Billing Address
<br />
%Order.BillingFirstName% %Order.BillingLastName%
<br />
%Order.BillingAddress1%
<br />
%Order.BillingCity% %Order.BillingZipPostalCode%
<br />
%Order.BillingStateProvince% %Order.BillingCountry%
<br />
<br />
<br />
<br />
%if (%Order.Shippable%) Shipping Address
<br />
%Order.ShippingFirstName% %Order.ShippingLastName%
<br />
%Order.ShippingAddress1%
<br />
%Order.ShippingCity% %Order.ShippingZipPostalCode%
<br />
%Order.ShippingStateProvince% %Order.ShippingCountry%
<br />
<br />
Shipping Method: %Order.ShippingMethod%
<br />
<br />
 endif% %Order.Product(s)%
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (25, N'Customer.BackInStock', NULL, N'%Store.Name%. Back in stock notification', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
Hello %Customer.FullName%,
<br />
Product <a target="_blank" href="%BackInStockSubscription.ProductUrl%">%BackInStockSubscription.ProductName%</a> is in stock.
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (26, N'Customer.EmailValidationMessage', NULL, N'%Store.Name%. Email validation', N'<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
To activate your account <a href="%Customer.AccountActivationURL%">click here</a>.
<br />
<br />
%Store.Name%
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (27, N'Customer.EmailRevalidationMessage', NULL, N'%Store.Name%. Email validation', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
Hello %Customer.FullName%!
<br />
To validate your new email address <a href="%Customer.EmailRevalidationURL%">click here</a>.
<br />
<br />
%Store.Name%
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (28, N'Customer.NewPM', NULL, N'%Store.Name%. You have received a new private message', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
You have received a new private message.
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (29, N'Customer.PasswordRecovery', NULL, N'%Store.Name%. Password recovery', N'<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
To change your password <a href="%Customer.PasswordRecoveryURL%">click here</a>.
<br />
<br />
%Store.Name%
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (30, N'Customer.WelcomeMessage', NULL, N'Welcome to %Store.Name%', N'We welcome you to <a href="%Store.URL%"> %Store.Name%</a>.
<br />
<br />
You can now take part in the various services we have to  offer you. Some of these services include:
<br />
<br />
Permanent Cart - Any products added to your online cart remain there until you remove them, or check them out.
<br />
Address Book - We can now deliver your products to another address other than yours! This is perfect to send birthday gifts direct to the birthday-person themselves.
<br />
Order History - View your history of purchases that you have made with us.
<br />
Products Reviews - Share your opinions on products with our other customers.
<br />
<br />
For help with any of our online services, please email the store-owner: <a href="mailto:%Store.Email%">%Store.Email%</a>.
<br />
<br />
Note: This email address was provided on our registration page. If you own the email and did not register on our site, please send an email to <a href="mailto:%Store.Email%">%Store.Email%</a>.
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (31, N'Forums.NewForumPost', NULL, N'%Store.Name%. New Post Notification.', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
A new post has been created in the topic <a href="%Forums.TopicURL%">"%Forums.TopicName%"</a> at <a href="%Forums.ForumURL%">"%Forums.ForumName%"</a> forum.
<br />
<br />
Click <a href="%Forums.TopicURL%">here</a> for more info.
<br />
<br />
Post author: %Forums.PostAuthor%
<br />
Post body: %Forums.PostBody%
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (32, N'Forums.NewForumTopic', NULL, N'%Store.Name%. New Topic Notification.', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
A new topic <a href="%Forums.TopicURL%">"%Forums.TopicName%"</a> has been created at <a href="%Forums.ForumURL%">"%Forums.ForumName%"</a> forum.
<br />
<br />
Click <a href="%Forums.TopicURL%">here</a> for more info.
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (33, N'GiftCard.Notification', NULL, N'%GiftCard.SenderName% has sent you a gift card for %Store.Name%', N'<p>
You have received a gift card for %Store.Name%
</p>
<p>
Dear %GiftCard.RecipientName%,
<br />
<br />
%GiftCard.SenderName% (%GiftCard.SenderEmail%) has sent you a %GiftCard.Amount% gift cart for <a href="%Store.URL%"> %Store.Name%</a>
</p>
<p>
You gift card code is %GiftCard.CouponCode%
</p>
<p>
%GiftCard.Message%
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (34, N'Service.ContactUs', NULL, N'%Store.Name%. Contact us', N'<p>
%ContactUs.Body%
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (35, N'NewCustomer.Notification', NULL, N'%Store.Name%. New customer registration', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
A new customer registered with your store. Below are the customer''s details:
<br />
Full name: %Customer.FullName%
<br />
Email: %Customer.Email%
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (36, N'NewReturnRequest.CustomerNotification', NULL, N'%Store.Name%. New return request.', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
Hello %Customer.FullName%!
<br />
You have just submitted a new return request. Details are below:
<br />
Request ID: %ReturnRequest.CustomNumber%
<br />
Product: %ReturnRequest.Product.Quantity% x Product: %ReturnRequest.Product.Name%
<br />
Reason for return: %ReturnRequest.Reason%
<br />
Requested action: %ReturnRequest.RequestedAction%
<br />
Customer comments:
<br />
%ReturnRequest.CustomerComment%
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (37, N'News.NewsComment', NULL, N'%Store.Name%. New news comment.', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
A new news comment has been created for news "%NewsComment.NewsTitle%".
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (38, N'NewsLetterSubscription.ActivationMessage', NULL, N'%Store.Name%. Subscription activation message.', N'<p>
<a href="%NewsLetterSubscription.ActivationUrl%">Click here to confirm your subscription to our list.</a>
</p>
<p>
If you received this email by mistake, simply delete it.
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (39, N'NewsLetterSubscription.DeactivationMessage', NULL, N'%Store.Name%. Subscription deactivation message.', N'<p>
<a href="%NewsLetterSubscription.DeactivationUrl%">Click here to unsubscribe from our newsletter.</a>
</p>
<p>
If you received this email by mistake, simply delete it.
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (40, N'NewVATSubmitted.StoreOwnerNotification', NULL, N'%Store.Name%. New VAT number is submitted.', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
%Customer.FullName% (%Customer.Email%) has just submitted a new VAT number. Details are below:
<br />
VAT number: %Customer.VatNumber%
<br />
VAT number status: %Customer.VatNumberStatus%
<br />
Received name: %VatValidationResult.Name%
<br />
Received address: %VatValidationResult.Address%
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (41, N'OrderCancelled.CustomerNotification', NULL, N'%Store.Name%. Your order cancelled', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
Hello %Order.CustomerFullName%,
<br />
Your order has been cancelled. Below is the summary of the order.
<br />
<br />
Order Number: %Order.OrderNumber%
<br />
Order Details: <a target="_blank" href="%Order.OrderURLForCustomer%">%Order.OrderURLForCustomer%</a>
<br />
Date Ordered: %Order.CreatedOn%
<br />
<br />
<br />
<br />
Billing Address
<br />
%Order.BillingFirstName% %Order.BillingLastName%
<br />
%Order.BillingAddress1%
<br />
%Order.BillingCity% %Order.BillingZipPostalCode%
<br />
%Order.BillingStateProvince% %Order.BillingCountry%
<br />
<br />
<br />
<br />
%if (%Order.Shippable%) Shipping Address
<br />
%Order.ShippingFirstName% %Order.ShippingLastName%
<br />
%Order.ShippingAddress1%
<br />
%Order.ShippingCity% %Order.ShippingZipPostalCode%
<br />
%Order.ShippingStateProvince% %Order.ShippingCountry%
<br />
<br />
Shipping Method: %Order.ShippingMethod%
<br />
<br />
 endif% %Order.Product(s)%
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (42, N'OrderCompleted.CustomerNotification', NULL, N'%Store.Name%. Your order completed', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
Hello %Order.CustomerFullName%,
<br />
Your order has been completed. Below is the summary of the order.
<br />
<br />
Order Number: %Order.OrderNumber%
<br />
Order Details: <a target="_blank" href="%Order.OrderURLForCustomer%">%Order.OrderURLForCustomer%</a>
<br />
Date Ordered: %Order.CreatedOn%
<br />
<br />
<br />
<br />
Billing Address
<br />
%Order.BillingFirstName% %Order.BillingLastName%
<br />
%Order.BillingAddress1%
<br />
%Order.BillingCity% %Order.BillingZipPostalCode%
<br />
%Order.BillingStateProvince% %Order.BillingCountry%
<br />
<br />
<br />
<br />
%if (%Order.Shippable%) Shipping Address
<br />
%Order.ShippingFirstName% %Order.ShippingLastName%
<br />
%Order.ShippingAddress1%
<br />
%Order.ShippingCity% %Order.ShippingZipPostalCode%
<br />
%Order.ShippingStateProvince% %Order.ShippingCountry%
<br />
<br />
Shipping Method: %Order.ShippingMethod%
<br />
<br />
 endif% %Order.Product(s)%
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (43, N'ShipmentDelivered.CustomerNotification', NULL, N'Your order from %Store.Name% has been delivered.', N'<p>
<a href="%Store.URL%"> %Store.Name%</a>
<br />
<br />
Hello %Order.CustomerFullName%,
<br />
Good news! You order has been delivered.
<br />
Order Number: %Order.OrderNumber%
<br />
Order Details: <a href="%Order.OrderURLForCustomer%" target="_blank">%Order.OrderURLForCustomer%</a>
<br />
Date Ordered: %Order.CreatedOn%
<br />
<br />
<br />
<br />
Billing Address
<br />
%Order.BillingFirstName% %Order.BillingLastName%
<br />
%Order.BillingAddress1%
<br />
%Order.BillingCity% %Order.BillingZipPostalCode%
<br />
%Order.BillingStateProvince% %Order.BillingCountry%
<br />
<br />
<br />
<br />
%if (%Order.Shippable%) Shipping Address
<br />
%Order.ShippingFirstName% %Order.ShippingLastName%
<br />
%Order.ShippingAddress1%
<br />
%Order.ShippingCity% %Order.ShippingZipPostalCode%
<br />
%Order.ShippingStateProvince% %Order.ShippingCountry%
<br />
<br />
Shipping Method: %Order.ShippingMethod%
<br />
<br />
 endif% Delivered Products:
<br />
<br />
%Shipment.Product(s)%
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (44, N'OrderPlaced.CustomerNotification', NULL, N'Order receipt from %Store.Name%.', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
Hello %Order.CustomerFullName%,
<br />
Thanks for buying from <a href="%Store.URL%">%Store.Name%</a>. Below is the summary of the order.
<br />
<br />
Order Number: %Order.OrderNumber%
<br />
Order Details: <a target="_blank" href="%Order.OrderURLForCustomer%">%Order.OrderURLForCustomer%</a>
<br />
Date Ordered: %Order.CreatedOn%
<br />
<br />
<br />
<br />
Billing Address
<br />
%Order.BillingFirstName% %Order.BillingLastName%
<br />
%Order.BillingAddress1%
<br />
%Order.BillingCity% %Order.BillingZipPostalCode%
<br />
%Order.BillingStateProvince% %Order.BillingCountry%
<br />
<br />
<br />
<br />
%if (%Order.Shippable%) Shipping Address
<br />
%Order.ShippingFirstName% %Order.ShippingLastName%
<br />
%Order.ShippingAddress1%
<br />
%Order.ShippingCity% %Order.ShippingZipPostalCode%
<br />
%Order.ShippingStateProvince% %Order.ShippingCountry%
<br />
<br />
Shipping Method: %Order.ShippingMethod%
<br />
<br />
 endif% %Order.Product(s)%
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (45, N'NewReturnRequest.StoreOwnerNotification', NULL, N'%Store.Name%. New return request.', N'<p>
<a href="%Store.URL%">%Store.Name%</a>
<br />
<br />
%Customer.FullName% has just submitted a new return request. Details are below:
<br />
Request ID: %ReturnRequest.CustomNumber%
<br />
Product: %ReturnRequest.Product.Quantity% x Product: %ReturnRequest.Product.Name%
<br />
Reason for return: %ReturnRequest.Reason%
<br />
Requested action: %ReturnRequest.RequestedAction%
<br />
Customer comments:
<br />
%ReturnRequest.CustomerComment%
</p>
', 1, NULL, 0, 0, 1, 0)
INSERT [MessageTemplate] ([Id], [Name], [BccEmailAddresses], [Subject], [Body], [IsActive], [DelayBeforeSend], [DelayPeriodId], [AttachedDownloadId], [EmailAccountId], [LimitedToStores]) VALUES (46, N'Service.ContactVendor', NULL, N'%Store.Name%. Contact us', N'<p>
%ContactUs.Body%
</p>
', 1, NULL, 0, 0, 1, 0)
SET IDENTITY_INSERT [MessageTemplate]  OFF
GO
SET IDENTITY_INSERT [ManufacturerTemplate] ON 

INSERT [ManufacturerTemplate] ([Id], [Name], [ViewPath], [DisplayOrder]) VALUES (1, N'Products in Grid or Lines', N'ManufacturerTemplate.ProductsInGridOrLines', 1)
SET IDENTITY_INSERT [ManufacturerTemplate]  OFF
GO
SET IDENTITY_INSERT [ProductTemplate] ON 

INSERT [ProductTemplate] ([Id], [Name], [ViewPath], [DisplayOrder], [IgnoredProductTypes]) VALUES (1, N'Simple product', N'ProductTemplate.Simple', 10, N'10')
INSERT [ProductTemplate] ([Id], [Name], [ViewPath], [DisplayOrder], [IgnoredProductTypes]) VALUES (2, N'Grouped product (with variants)', N'ProductTemplate.Grouped', 100, N'5')
SET IDENTITY_INSERT [ProductTemplate]  OFF
GO
SET IDENTITY_INSERT [CategoryTemplate] ON 

INSERT [CategoryTemplate] ([Id], [Name], [ViewPath], [DisplayOrder]) VALUES (1, N'Products in Grid or Lines', N'CategoryTemplate.ProductsInGridOrLines', 1)
SET IDENTITY_INSERT [CategoryTemplate]  OFF
GO
SET IDENTITY_INSERT [TopicTemplate] ON 

INSERT [TopicTemplate] ([Id], [Name], [ViewPath], [DisplayOrder]) VALUES (1, N'Default template', N'TopicDetails', 1)
SET IDENTITY_INSERT [TopicTemplate]  OFF
GO
SET IDENTITY_INSERT [MeasureDimension] ON 

INSERT [MeasureDimension] ([Id], [Name], [SystemKeyword], [Ratio], [DisplayOrder]) VALUES (1, N'inch(es)', N'inches', CAST(1.00000000 AS Decimal(18, 8)), 1)
INSERT [MeasureDimension] ([Id], [Name], [SystemKeyword], [Ratio], [DisplayOrder]) VALUES (2, N'feet', N'feet', CAST(0.08333333 AS Decimal(18, 8)), 2)
INSERT [MeasureDimension] ([Id], [Name], [SystemKeyword], [Ratio], [DisplayOrder]) VALUES (3, N'meter(s)', N'meters', CAST(0.02540000 AS Decimal(18, 8)), 3)
INSERT [MeasureDimension] ([Id], [Name], [SystemKeyword], [Ratio], [DisplayOrder]) VALUES (4, N'millimetre(s)', N'millimetres', CAST(25.40000000 AS Decimal(18, 8)), 4)
SET IDENTITY_INSERT [MeasureDimension]  OFF
GO
SET IDENTITY_INSERT [MeasureWeight] ON 

INSERT [MeasureWeight] ([Id], [Name], [SystemKeyword], [Ratio], [DisplayOrder]) VALUES (1, N'ounce(s)', N'ounce', CAST(16.00000000 AS Decimal(18, 8)), 1)
INSERT [MeasureWeight] ([Id], [Name], [SystemKeyword], [Ratio], [DisplayOrder]) VALUES (2, N'lb(s)', N'lb', CAST(1.00000000 AS Decimal(18, 8)), 2)
INSERT [MeasureWeight] ([Id], [Name], [SystemKeyword], [Ratio], [DisplayOrder]) VALUES (3, N'kg(s)', N'kg', CAST(0.45359237 AS Decimal(18, 8)), 3)
INSERT [MeasureWeight] ([Id], [Name], [SystemKeyword], [Ratio], [DisplayOrder]) VALUES (4, N'gram(s)', N'grams', CAST(453.59237000 AS Decimal(18, 8)), 4)
SET IDENTITY_INSERT [MeasureWeight]  OFF
GO
SET IDENTITY_INSERT [Language] ON 

INSERT [Language] ([Id], [Name], [LanguageCulture], [UniqueSeoCode], [FlagImageFileName], [Rtl], [LimitedToStores], [DefaultCurrencyId], [Published], [DisplayOrder]) VALUES (1, N'English', N'en-US', N'en', N'us.png', 0, 0, 0, 1, 1)
SET IDENTITY_INSERT [Language]  OFF
GO
SET IDENTITY_INSERT [Currency] ON 

INSERT [Currency] ([Id], [Name], [CurrencyCode], [Rate], [DisplayLocale], [CustomFormatting], [LimitedToStores], [Published], [DisplayOrder], [CreatedOnUtc], [UpdatedOnUtc], [RoundingTypeId]) VALUES (1, N'US Dollar', N'USD', CAST(1.0000 AS Decimal(18, 4)), N'en-US', N'', 0, 1, 1, CAST(N'2019-05-27T15:28:21.2825209' AS DateTime2), CAST(N'2019-05-27T15:28:21.2825687' AS DateTime2), 0)
INSERT [Currency] ([Id], [Name], [CurrencyCode], [Rate], [DisplayLocale], [CustomFormatting], [LimitedToStores], [Published], [DisplayOrder], [CreatedOnUtc], [UpdatedOnUtc], [RoundingTypeId]) VALUES (2, N'Australian Dollar', N'AUD', CAST(1.3400 AS Decimal(18, 4)), N'en-AU', N'', 0, 0, 2, CAST(N'2019-05-27T15:28:21.2826963' AS DateTime2), CAST(N'2019-05-27T15:28:21.2826963' AS DateTime2), 0)
INSERT [Currency] ([Id], [Name], [CurrencyCode], [Rate], [DisplayLocale], [CustomFormatting], [LimitedToStores], [Published], [DisplayOrder], [CreatedOnUtc], [UpdatedOnUtc], [RoundingTypeId]) VALUES (3, N'British Pound', N'GBP', CAST(0.7500 AS Decimal(18, 4)), N'en-GB', N'', 0, 0, 3, CAST(N'2019-05-27T15:28:21.2826963' AS DateTime2), CAST(N'2019-05-27T15:28:21.2826967' AS DateTime2), 0)
INSERT [Currency] ([Id], [Name], [CurrencyCode], [Rate], [DisplayLocale], [CustomFormatting], [LimitedToStores], [Published], [DisplayOrder], [CreatedOnUtc], [UpdatedOnUtc], [RoundingTypeId]) VALUES (4, N'Canadian Dollar', N'CAD', CAST(1.3200 AS Decimal(18, 4)), N'en-CA', N'', 0, 0, 4, CAST(N'2019-05-27T15:28:21.2826967' AS DateTime2), CAST(N'2019-05-27T15:28:21.2826967' AS DateTime2), 0)
INSERT [Currency] ([Id], [Name], [CurrencyCode], [Rate], [DisplayLocale], [CustomFormatting], [LimitedToStores], [Published], [DisplayOrder], [CreatedOnUtc], [UpdatedOnUtc], [RoundingTypeId]) VALUES (5, N'Chinese Yuan Renminbi', N'CNY', CAST(6.4300 AS Decimal(18, 4)), N'zh-CN', N'', 0, 0, 5, CAST(N'2019-05-27T15:28:21.2826970' AS DateTime2), CAST(N'2019-05-27T15:28:21.2826970' AS DateTime2), 0)
INSERT [Currency] ([Id], [Name], [CurrencyCode], [Rate], [DisplayLocale], [CustomFormatting], [LimitedToStores], [Published], [DisplayOrder], [CreatedOnUtc], [UpdatedOnUtc], [RoundingTypeId]) VALUES (6, N'Euro', N'EUR', CAST(0.8600 AS Decimal(18, 4)), N'', N'€0.00', 0, 1, 6, CAST(N'2019-05-27T15:28:21.2826994' AS DateTime2), CAST(N'2019-05-27T15:28:21.2826994' AS DateTime2), 0)
INSERT [Currency] ([Id], [Name], [CurrencyCode], [Rate], [DisplayLocale], [CustomFormatting], [LimitedToStores], [Published], [DisplayOrder], [CreatedOnUtc], [UpdatedOnUtc], [RoundingTypeId]) VALUES (7, N'Hong Kong Dollar', N'HKD', CAST(7.8400 AS Decimal(18, 4)), N'zh-HK', N'', 0, 0, 7, CAST(N'2019-05-27T15:28:21.2826997' AS DateTime2), CAST(N'2019-05-27T15:28:21.2826997' AS DateTime2), 0)
INSERT [Currency] ([Id], [Name], [CurrencyCode], [Rate], [DisplayLocale], [CustomFormatting], [LimitedToStores], [Published], [DisplayOrder], [CreatedOnUtc], [UpdatedOnUtc], [RoundingTypeId]) VALUES (8, N'Japanese Yen', N'JPY', CAST(110.4500 AS Decimal(18, 4)), N'ja-JP', N'', 0, 0, 8, CAST(N'2019-05-27T15:28:21.2826997' AS DateTime2), CAST(N'2019-05-27T15:28:21.2826997' AS DateTime2), 0)
INSERT [Currency] ([Id], [Name], [CurrencyCode], [Rate], [DisplayLocale], [CustomFormatting], [LimitedToStores], [Published], [DisplayOrder], [CreatedOnUtc], [UpdatedOnUtc], [RoundingTypeId]) VALUES (9, N'Russian Rouble', N'RUB', CAST(63.2500 AS Decimal(18, 4)), N'ru-RU', N'', 0, 0, 9, CAST(N'2019-05-27T15:28:21.2826997' AS DateTime2), CAST(N'2019-05-27T15:28:21.2827001' AS DateTime2), 0)
INSERT [Currency] ([Id], [Name], [CurrencyCode], [Rate], [DisplayLocale], [CustomFormatting], [LimitedToStores], [Published], [DisplayOrder], [CreatedOnUtc], [UpdatedOnUtc], [RoundingTypeId]) VALUES (10, N'Swedish Krona', N'SEK', CAST(8.8000 AS Decimal(18, 4)), N'sv-SE', N'', 0, 0, 10, CAST(N'2019-05-27T15:28:21.2827001' AS DateTime2), CAST(N'2019-05-27T15:28:21.2827001' AS DateTime2), 60)
INSERT [Currency] ([Id], [Name], [CurrencyCode], [Rate], [DisplayLocale], [CustomFormatting], [LimitedToStores], [Published], [DisplayOrder], [CreatedOnUtc], [UpdatedOnUtc], [RoundingTypeId]) VALUES (11, N'Indian Rupee', N'INR', CAST(68.0300 AS Decimal(18, 4)), N'en-IN', N'', 0, 0, 12, CAST(N'2019-05-27T15:28:21.2827004' AS DateTime2), CAST(N'2019-05-27T15:28:21.2827004' AS DateTime2), 0)
SET IDENTITY_INSERT [Currency]  OFF
GO
SET IDENTITY_INSERT [TaxCategory] ON 

INSERT [TaxCategory] ([Id], [Name], [DisplayOrder]) VALUES (1, N'Books', 1)
INSERT [TaxCategory] ([Id], [Name], [DisplayOrder]) VALUES (2, N'Electronics & Software', 5)
INSERT [TaxCategory] ([Id], [Name], [DisplayOrder]) VALUES (3, N'Downloadable Products', 10)
INSERT [TaxCategory] ([Id], [Name], [DisplayOrder]) VALUES (4, N'Jewelry', 15)
INSERT [TaxCategory] ([Id], [Name], [DisplayOrder]) VALUES (5, N'Apparel', 20)
SET IDENTITY_INSERT [TaxCategory]  OFF
GO
SET IDENTITY_INSERT [ShippingMethod] ON 

INSERT [ShippingMethod] ([Id], [Name], [Description], [DisplayOrder]) VALUES (1, N'Ground', N'Shipping by land transport', 1)
INSERT [ShippingMethod] ([Id], [Name], [Description], [DisplayOrder]) VALUES (2, N'Next Day Air', N'The one day air shipping', 2)
INSERT [ShippingMethod] ([Id], [Name], [Description], [DisplayOrder]) VALUES (3, N'2nd Day Air', N'The two day air shipping', 3)
SET IDENTITY_INSERT [ShippingMethod]  OFF
GO
SET IDENTITY_INSERT [Country] ON 

INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (1, N'United States', 1, 1, N'US', N'USA', 840, 0, 1, 1, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (2, N'Latvia', 1, 1, N'LV', N'LVA', 428, 1, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (3, N'Lebanon', 1, 1, N'LB', N'LBN', 422, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (4, N'Lesotho', 1, 1, N'LS', N'LSO', 426, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (5, N'Liberia', 1, 1, N'LR', N'LBR', 430, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (6, N'Libyan Arab Jamahiriya', 1, 1, N'LY', N'LBY', 434, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (7, N'Liechtenstein', 1, 1, N'LI', N'LIE', 438, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (8, N'Lithuania', 1, 1, N'LT', N'LTU', 440, 1, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (9, N'Luxembourg', 1, 1, N'LU', N'LUX', 442, 1, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (10, N'Macau', 1, 1, N'MO', N'MAC', 446, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (11, N'Macedonia', 1, 1, N'MK', N'MKD', 807, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (12, N'Madagascar', 1, 1, N'MG', N'MDG', 450, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (13, N'Malawi', 1, 1, N'MW', N'MWI', 454, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (14, N'Lao People''s Democratic Republic', 1, 1, N'LA', N'LAO', 418, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (15, N'Maldives', 1, 1, N'MV', N'MDV', 462, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (16, N'Malta', 1, 1, N'MT', N'MLT', 470, 1, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (17, N'Marshall Islands', 1, 1, N'MH', N'MHL', 584, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (18, N'Martinique', 1, 1, N'MQ', N'MTQ', 474, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (19, N'Mauritania', 1, 1, N'MR', N'MRT', 478, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (20, N'Mauritius', 1, 1, N'MU', N'MUS', 480, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (21, N'Mayotte', 1, 1, N'YT', N'MYT', 175, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (22, N'Micronesia', 1, 1, N'FM', N'FSM', 583, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (23, N'Moldova', 1, 1, N'MD', N'MDA', 498, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (24, N'Monaco', 1, 1, N'MC', N'MCO', 492, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (25, N'Mongolia', 1, 1, N'MN', N'MNG', 496, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (26, N'Montenegro', 1, 1, N'ME', N'MNE', 499, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (27, N'Montserrat', 1, 1, N'MS', N'MSR', 500, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (28, N'Mali', 1, 1, N'ML', N'MLI', 466, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (29, N'Morocco', 1, 1, N'MA', N'MAR', 504, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (30, N'Kyrgyzstan', 1, 1, N'KG', N'KGZ', 417, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (31, N'Kiribati', 1, 1, N'KI', N'KIR', 296, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (32, N'Eritrea', 1, 1, N'ER', N'ERI', 232, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (33, N'Estonia', 1, 1, N'EE', N'EST', 233, 1, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (34, N'Ethiopia', 1, 1, N'ET', N'ETH', 231, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (35, N'Falkland Islands (Malvinas)', 1, 1, N'FK', N'FLK', 238, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (36, N'Faroe Islands', 1, 1, N'FO', N'FRO', 234, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (37, N'Fiji', 1, 1, N'FJ', N'FJI', 242, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (38, N'French Guiana', 1, 1, N'GF', N'GUF', 254, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (39, N'French Polynesia', 1, 1, N'PF', N'PYF', 258, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (40, N'French Southern Territories', 1, 1, N'TF', N'ATF', 260, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (41, N'Gabon', 1, 1, N'GA', N'GAB', 266, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (42, N'Gambia', 1, 1, N'GM', N'GMB', 270, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (43, N'Ghana', 1, 1, N'GH', N'GHA', 288, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (44, N'Korea', 1, 1, N'KR', N'KOR', 410, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (45, N'Greenland', 1, 1, N'GL', N'GRL', 304, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (46, N'Guadeloupe', 1, 1, N'GP', N'GLP', 312, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (47, N'Guam', 1, 1, N'GU', N'GUM', 316, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (48, N'Guinea', 1, 1, N'GN', N'GIN', 324, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (49, N'Guinea-bissau', 1, 1, N'GW', N'GNB', 624, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (50, N'Guyana', 1, 1, N'GY', N'GUY', 328, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (51, N'Haiti', 1, 1, N'HT', N'HTI', 332, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (52, N'Heard and Mc Donald Islands', 1, 1, N'HM', N'HMD', 334, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (53, N'Honduras', 1, 1, N'HN', N'HND', 340, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (54, N'Iceland', 1, 1, N'IS', N'ISL', 352, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (55, N'Iran (Islamic Republic of)', 1, 1, N'IR', N'IRN', 364, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (56, N'Iraq', 1, 1, N'IQ', N'IRQ', 368, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (57, N'Kenya', 1, 1, N'KE', N'KEN', 404, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (58, N'Grenada', 1, 1, N'GD', N'GRD', 308, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (59, N'Mozambique', 1, 1, N'MZ', N'MOZ', 508, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (60, N'Myanmar', 1, 1, N'MM', N'MMR', 104, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (61, N'Namibia', 1, 1, N'NA', N'NAM', 516, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (62, N'St. Helena', 1, 1, N'SH', N'SHN', 654, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (63, N'St. Pierre and Miquelon', 1, 1, N'PM', N'SPM', 666, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (64, N'Sudan', 1, 1, N'SD', N'SDN', 736, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (65, N'Suriname', 1, 1, N'SR', N'SUR', 740, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (66, N'Svalbard and Jan Mayen Islands', 1, 1, N'SJ', N'SJM', 744, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (67, N'Swaziland', 1, 1, N'SZ', N'SWZ', 748, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (68, N'Syrian Arab Republic', 1, 1, N'SY', N'SYR', 760, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (69, N'Tajikistan', 1, 1, N'TJ', N'TJK', 762, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (70, N'Tanzania', 1, 1, N'TZ', N'TZA', 834, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (71, N'Togo', 1, 1, N'TG', N'TGO', 768, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (72, N'Tokelau', 1, 1, N'TK', N'TKL', 772, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (73, N'Tonga', 1, 1, N'TO', N'TON', 776, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (74, N'Sri Lanka', 1, 1, N'LK', N'LKA', 144, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (75, N'Trinidad and Tobago', 1, 1, N'TT', N'TTO', 780, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (76, N'Turkmenistan', 1, 1, N'TM', N'TKM', 795, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (77, N'Turks and Caicos Islands', 1, 1, N'TC', N'TCA', 796, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (78, N'Tuvalu', 1, 1, N'TV', N'TUV', 798, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (79, N'Uganda', 1, 1, N'UG', N'UGA', 800, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (80, N'Vanuatu', 1, 1, N'VU', N'VUT', 548, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (81, N'Vatican City State (Holy See)', 1, 1, N'VA', N'VAT', 336, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (82, N'Viet Nam', 1, 1, N'VN', N'VNM', 704, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (83, N'Virgin Islands (British)', 1, 1, N'VG', N'VGB', 92, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (84, N'Virgin Islands (U.S.)', 1, 1, N'VI', N'VIR', 850, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (85, N'Wallis and Futuna Islands', 1, 1, N'WF', N'WLF', 876, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (86, N'Western Sahara', 1, 1, N'EH', N'ESH', 732, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (87, N'Yemen', 1, 1, N'YE', N'YEM', 887, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (88, N'Tunisia', 1, 1, N'TN', N'TUN', 788, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (89, N'South Sudan', 1, 1, N'SS', N'SSD', 728, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (90, N'South Georgia & South Sandwich Islands', 1, 1, N'GS', N'SGS', 239, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (91, N'Somalia', 1, 1, N'SO', N'SOM', 706, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (92, N'Nauru', 1, 1, N'NR', N'NRU', 520, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (93, N'Nepal', 1, 1, N'NP', N'NPL', 524, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (94, N'Netherlands Antilles', 1, 1, N'AN', N'ANT', 530, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (95, N'New Caledonia', 1, 1, N'NC', N'NCL', 540, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (96, N'Nicaragua', 1, 1, N'NI', N'NIC', 558, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (97, N'Niger', 1, 1, N'NE', N'NER', 562, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (98, N'Nigeria', 1, 1, N'NG', N'NGA', 566, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (99, N'Niue', 1, 1, N'NU', N'NIU', 570, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (100, N'Norfolk Island', 1, 1, N'NF', N'NFK', 574, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (101, N'Northern Mariana Islands', 1, 1, N'MP', N'MNP', 580, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (102, N'Oman', 1, 1, N'OM', N'OMN', 512, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (103, N'Palau', 1, 1, N'PW', N'PLW', 585, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (104, N'Panama', 1, 1, N'PA', N'PAN', 591, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (105, N'Papua New Guinea', 1, 1, N'PG', N'PNG', 598, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (106, N'Pitcairn', 1, 1, N'PN', N'PCN', 612, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (107, N'Reunion', 1, 1, N'RE', N'REU', 638, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (108, N'Rwanda', 1, 1, N'RW', N'RWA', 646, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (109, N'Saint Kitts and Nevis', 1, 1, N'KN', N'KNA', 659, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (110, N'Saint Lucia', 1, 1, N'LC', N'LCA', 662, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (111, N'Saint Vincent and the Grenadines', 1, 1, N'VC', N'VCT', 670, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (112, N'Samoa', 1, 1, N'WS', N'WSM', 882, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (113, N'San Marino', 1, 1, N'SM', N'SMR', 674, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (114, N'Sao Tome and Principe', 1, 1, N'ST', N'STP', 678, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (115, N'Senegal', 1, 1, N'SN', N'SEN', 686, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (116, N'Seychelles', 1, 1, N'SC', N'SYC', 690, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (117, N'Sierra Leone', 1, 1, N'SL', N'SLE', 694, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (118, N'Solomon Islands', 1, 1, N'SB', N'SLB', 90, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (119, N'Equatorial Guinea', 1, 1, N'GQ', N'GNQ', 226, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (120, N'Zambia', 1, 1, N'ZM', N'ZMB', 894, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (121, N'El Salvador', 1, 1, N'SV', N'SLV', 222, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (122, N'Djibouti', 1, 1, N'DJ', N'DJI', 262, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (123, N'Egypt', 1, 1, N'EG', N'EGY', 818, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (124, N'Finland', 1, 1, N'FI', N'FIN', 246, 1, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (125, N'France', 1, 1, N'FR', N'FRA', 250, 1, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (126, N'Georgia', 1, 1, N'GE', N'GEO', 268, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (127, N'Germany', 1, 1, N'DE', N'DEU', 276, 1, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (128, N'Gibraltar', 1, 1, N'GI', N'GIB', 292, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (129, N'Greece', 1, 1, N'GR', N'GRC', 300, 1, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (130, N'Guatemala', 1, 1, N'GT', N'GTM', 320, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (131, N'Hong Kong', 1, 1, N'HK', N'HKG', 344, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (132, N'Hungary', 1, 1, N'HU', N'HUN', 348, 1, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (133, N'India', 1, 1, N'IN', N'IND', 356, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (134, N'Indonesia', 1, 1, N'ID', N'IDN', 360, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (135, N'Ecuador', 1, 1, N'EC', N'ECU', 218, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (136, N'Ireland', 1, 1, N'IE', N'IRL', 372, 1, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (137, N'Italy', 1, 1, N'IT', N'ITA', 380, 1, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (138, N'Jamaica', 1, 1, N'JM', N'JAM', 388, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (139, N'Japan', 1, 1, N'JP', N'JPN', 392, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (140, N'Jordan', 1, 1, N'JO', N'JOR', 400, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (141, N'Kazakhstan', 1, 1, N'KZ', N'KAZ', 398, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (142, N'Korea, Democratic People''s Republic of', 1, 1, N'KP', N'PRK', 408, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (143, N'Kuwait', 1, 1, N'KW', N'KWT', 414, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (144, N'Malaysia', 1, 1, N'MY', N'MYS', 458, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (145, N'Mexico', 1, 1, N'MX', N'MEX', 484, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (146, N'Netherlands', 1, 1, N'NL', N'NLD', 528, 1, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (147, N'New Zealand', 1, 1, N'NZ', N'NZL', 554, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (148, N'Norway', 1, 1, N'NO', N'NOR', 578, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (149, N'Israel', 1, 1, N'IL', N'ISR', 376, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (150, N'Pakistan', 1, 1, N'PK', N'PAK', 586, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (151, N'East Timor', 1, 1, N'TL', N'TLS', 626, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (152, N'Denmark', 1, 1, N'DK', N'DNK', 208, 1, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (153, N'Canada', 1, 1, N'CA', N'CAN', 124, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (154, N'Argentina', 1, 1, N'AR', N'ARG', 32, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (155, N'Armenia', 1, 1, N'AM', N'ARM', 51, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (156, N'Aruba', 1, 1, N'AW', N'ABW', 533, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (157, N'Australia', 1, 1, N'AU', N'AUS', 36, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (158, N'Austria', 1, 1, N'AT', N'AUT', 40, 1, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (159, N'Azerbaijan', 1, 1, N'AZ', N'AZE', 31, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (160, N'Bahamas', 1, 1, N'BS', N'BHS', 44, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (161, N'Bangladesh', 1, 1, N'BD', N'BGD', 50, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (162, N'Belarus', 1, 1, N'BY', N'BLR', 112, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (163, N'Belgium', 1, 1, N'BE', N'BEL', 56, 1, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (164, N'Belize', 1, 1, N'BZ', N'BLZ', 84, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (165, N'Dominican Republic', 1, 1, N'DO', N'DOM', 214, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (166, N'Bermuda', 1, 1, N'BM', N'BMU', 60, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (167, N'Bosnia and Herzegowina', 1, 1, N'BA', N'BIH', 70, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (168, N'Brazil', 1, 1, N'BR', N'BRA', 76, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (169, N'Bulgaria', 1, 1, N'BG', N'BGR', 100, 1, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (170, N'Cayman Islands', 1, 1, N'KY', N'CYM', 136, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (171, N'Chile', 1, 1, N'CL', N'CHL', 152, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (172, N'China', 1, 1, N'CN', N'CHN', 156, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (173, N'Colombia', 1, 1, N'CO', N'COL', 170, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (174, N'Costa Rica', 1, 1, N'CR', N'CRI', 188, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (175, N'Croatia', 1, 1, N'HR', N'HRV', 191, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (176, N'Cuba', 1, 1, N'CU', N'CUB', 192, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (177, N'Cyprus', 1, 1, N'CY', N'CYP', 196, 1, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (178, N'Czech Republic', 1, 1, N'CZ', N'CZE', 203, 1, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (179, N'Bolivia', 1, 1, N'BO', N'BOL', 68, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (180, N'Palestine', 1, 1, N'PS', N'PSE', 275, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (181, N'Paraguay', 1, 1, N'PY', N'PRY', 600, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (182, N'Peru', 1, 1, N'PE', N'PER', 604, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (183, N'Angola', 1, 1, N'AO', N'AGO', 24, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (184, N'Anguilla', 1, 1, N'AI', N'AIA', 660, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (185, N'Antarctica', 1, 1, N'AQ', N'ATA', 10, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (186, N'Antigua and Barbuda', 1, 1, N'AG', N'ATG', 28, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (187, N'Bahrain', 1, 1, N'BH', N'BHR', 48, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (188, N'Barbados', 1, 1, N'BB', N'BRB', 52, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (189, N'Benin', 1, 1, N'BJ', N'BEN', 204, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (190, N'Bhutan', 1, 1, N'BT', N'BTN', 64, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (191, N'Botswana', 1, 1, N'BW', N'BWA', 72, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (192, N'Bouvet Island', 1, 1, N'BV', N'BVT', 74, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (193, N'British Indian Ocean Territory', 1, 1, N'IO', N'IOT', 86, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (194, N'Brunei Darussalam', 1, 1, N'BN', N'BRN', 96, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (195, N'Andorra', 1, 1, N'AD', N'AND', 20, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (196, N'Burkina Faso', 1, 1, N'BF', N'BFA', 854, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (197, N'Cambodia', 1, 1, N'KH', N'KHM', 116, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (198, N'Cameroon', 1, 1, N'CM', N'CMR', 120, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (199, N'Cape Verde', 1, 1, N'CV', N'CPV', 132, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (200, N'Central African Republic', 1, 1, N'CF', N'CAF', 140, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (201, N'Chad', 1, 1, N'TD', N'TCD', 148, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (202, N'Christmas Island', 1, 1, N'CX', N'CXR', 162, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (203, N'Cocos (Keeling) Islands', 1, 1, N'CC', N'CCK', 166, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (204, N'Comoros', 1, 1, N'KM', N'COM', 174, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (205, N'Congo', 1, 1, N'CG', N'COG', 178, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (206, N'Congo (Democratic Republic of the)', 1, 1, N'CD', N'COD', 180, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (207, N'Cook Islands', 1, 1, N'CK', N'COK', 184, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (208, N'Cote D''Ivoire', 1, 1, N'CI', N'CIV', 384, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (209, N'Burundi', 1, 1, N'BI', N'BDI', 108, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (210, N'American Samoa', 1, 1, N'AS', N'ASM', 16, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (211, N'Algeria', 1, 1, N'DZ', N'DZA', 12, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (212, N'Albania', 1, 1, N'AL', N'ALB', 8, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (213, N'Philippines', 1, 1, N'PH', N'PHL', 608, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (214, N'Poland', 1, 1, N'PL', N'POL', 616, 1, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (215, N'Portugal', 1, 1, N'PT', N'PRT', 620, 1, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (216, N'Puerto Rico', 1, 1, N'PR', N'PRI', 630, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (217, N'Qatar', 1, 1, N'QA', N'QAT', 634, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (218, N'Romania', 1, 1, N'RO', N'ROM', 642, 1, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (219, N'Russian Federation', 1, 1, N'RU', N'RUS', 643, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (220, N'Saudi Arabia', 1, 1, N'SA', N'SAU', 682, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (221, N'Singapore', 1, 1, N'SG', N'SGP', 702, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (222, N'Slovakia (Slovak Republic)', 1, 1, N'SK', N'SVK', 703, 1, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (223, N'Slovenia', 1, 1, N'SI', N'SVN', 705, 1, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (224, N'South Africa', 1, 1, N'ZA', N'ZAF', 710, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (225, N'Spain', 1, 1, N'ES', N'ESP', 724, 1, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (226, N'Sweden', 1, 1, N'SE', N'SWE', 752, 1, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (227, N'Switzerland', 1, 1, N'CH', N'CHE', 756, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (228, N'Taiwan', 1, 1, N'TW', N'TWN', 158, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (229, N'Thailand', 1, 1, N'TH', N'THA', 764, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (230, N'Turkey', 1, 1, N'TR', N'TUR', 792, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (231, N'Ukraine', 1, 1, N'UA', N'UKR', 804, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (232, N'United Arab Emirates', 1, 1, N'AE', N'ARE', 784, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (233, N'United Kingdom', 1, 1, N'GB', N'GBR', 826, 1, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (234, N'United States minor outlying islands', 1, 1, N'UM', N'UMI', 581, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (235, N'Uruguay', 1, 1, N'UY', N'URY', 858, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (236, N'Uzbekistan', 1, 1, N'UZ', N'UZB', 860, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (237, N'Venezuela', 1, 1, N'VE', N'VEN', 862, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (238, N'Serbia', 1, 1, N'RS', N'SRB', 688, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (239, N'Afghanistan', 1, 1, N'AF', N'AFG', 4, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (240, N'Dominica', 1, 1, N'DM', N'DMA', 212, 0, 1, 100, 0)
INSERT [Country] ([Id], [Name], [AllowsBilling], [AllowsShipping], [TwoLetterIsoCode], [ThreeLetterIsoCode], [NumericIsoCode], [SubjectToVat], [Published], [DisplayOrder], [LimitedToStores]) VALUES (241, N'Zimbabwe', 1, 1, N'ZW', N'ZWE', 716, 0, 1, 100, 0)
SET IDENTITY_INSERT [Country]  OFF
GO
SET IDENTITY_INSERT [StateProvince] ON 

INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (1, 1, N'AA (Armed Forces Americas)', N'AA', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (2, 1, N'Texas', N'TX', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (3, 1, N'Tennessee', N'TN', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (4, 1, N'South Dakota', N'SD', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (5, 1, N'South Carolina', N'SC', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (6, 1, N'Rhode Island', N'RI', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (7, 1, N'Puerto Rico', N'PR', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (8, 1, N'Pennsylvania', N'PA', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (9, 1, N'Palau', N'PW', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (10, 1, N'Oregon', N'OR', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (11, 1, N'Oklahoma', N'OK', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (12, 1, N'Ohio', N'OH', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (13, 1, N'Northern Mariana Islands', N'MP', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (14, 1, N'North Dakota', N'ND', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (15, 1, N'North Carolina', N'NC', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (16, 1, N'New York', N'NY', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (17, 1, N'Utah', N'UT', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (18, 1, N'New Mexico', N'NM', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (19, 1, N'Vermont', N'VT', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (20, 1, N'Virginia', N'VA', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (21, 153, N'Quebec', N'QC', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (22, 153, N'Prince Edward Island', N'PE', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (23, 153, N'Ontario', N'ON', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (24, 153, N'Nunavut', N'NU', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (25, 153, N'Nova Scotia', N'NS', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (26, 153, N'Northwest Territories', N'NT', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (27, 153, N'Newfoundland and Labrador', N'NL', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (28, 153, N'New Brunswick', N'NB', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (29, 153, N'Manitoba', N'MB', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (30, 153, N'British Columbia', N'BC', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (31, 153, N'Alberta', N'AB', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (32, 1, N'Wyoming', N'WY', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (33, 1, N'Wisconsin', N'WI', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (34, 1, N'West Virginia', N'WV', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (35, 1, N'Washington', N'WA', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (36, 1, N'Virgin Islands', N'VI', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (37, 153, N'Saskatchewan', N'SK', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (38, 1, N'New Jersey', N'NJ', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (39, 1, N'Nevada', N'NV', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (40, 1, N'Georgia', N'GA', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (41, 1, N'Florida', N'FL', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (42, 1, N'Federated States of Micronesia', N'FM', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (43, 1, N'District of Columbia', N'DC', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (44, 1, N'Delaware', N'DE', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (45, 1, N'Connecticut', N'CT', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (46, 1, N'Colorado', N'CO', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (47, 1, N'California', N'CA', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (48, 1, N'Arkansas', N'AR', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (49, 1, N'Arizona', N'AZ', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (50, 1, N'AP (Armed Forces Pacific)', N'AP', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (51, 1, N'American Samoa', N'AS', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (52, 1, N'Alaska', N'AK', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (53, 1, N'Alabama', N'AL', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (54, 1, N'AE (Armed Forces Europe)', N'AE', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (55, 1, N'Guam', N'GU', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (56, 1, N'New Hampshire', N'NH', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (57, 1, N'Hawaii', N'HI', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (58, 1, N'Illinois', N'IL', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (59, 1, N'Nebraska', N'NE', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (60, 1, N'Montana', N'MT', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (61, 1, N'Missouri', N'MO', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (62, 1, N'Mississippi', N'MS', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (63, 1, N'Minnesota', N'MN', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (64, 1, N'Michigan', N'MI', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (65, 1, N'Massachusetts', N'MA', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (66, 1, N'Maryland', N'MD', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (67, 1, N'Marshall Islands', N'MH', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (68, 1, N'Maine', N'ME', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (69, 1, N'Louisiana', N'LA', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (70, 1, N'Kentucky', N'KY', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (71, 1, N'Kansas', N'KS', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (72, 1, N'Iowa', N'IA', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (73, 1, N'Indiana', N'IN', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (74, 1, N'Idaho', N'ID', 1, 1)
INSERT [StateProvince] ([Id], [CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (75, 153, N'Yukon Territory', N'YT', 1, 1)
SET IDENTITY_INSERT [StateProvince]  OFF
GO
SET IDENTITY_INSERT [ActivityLogType] ON 

INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (1, N'AddNewAddressAttribute', N'Add a new address attribute', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (2, N'EditManufacturer', N'Edit a manufacturer', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (3, N'EditMeasureDimension', N'Edit a measure dimension', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (4, N'EditMeasureWeight', N'Edit a measure weight', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (5, N'EditMessageTemplate', N'Edit a message template', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (6, N'EditNews', N'Edit a news', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (7, N'EditOrder', N'Edit an order', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (8, N'EditLanguage', N'Edit a language', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (9, N'EditPlugin', N'Edit a plugin', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (10, N'EditProductAttribute', N'Edit a product attribute', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (11, N'EditProductReview', N'Edit a product review', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (12, N'EditPromotionProviders', N'Edit promotion providers', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (13, N'EditReturnRequest', N'Edit a return request', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (14, N'EditReviewType', N'Edit a review type', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (15, N'EditSettings', N'Edit setting(s)', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (16, N'EditProduct', N'Edit a product', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (17, N'EditGiftCard', N'Edit a gift card', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (18, N'EditEmailAccount', N'Edit an email account', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (19, N'EditDiscount', N'Edit a discount', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (20, N'DeleteWidget', N'Delete a widget', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (21, N'EditActivityLogTypes', N'Edit activity log types', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (22, N'EditAddressAttribute', N'Edit an address attribute', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (23, N'EditAddressAttributeValue', N'Edit an address attribute value', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (24, N'EditAffiliate', N'Edit an affiliate', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (25, N'EditBlogPost', N'Edit a blog post', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (26, N'EditCampaign', N'Edit a campaign', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (27, N'EditCategory', N'Edit category', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (28, N'EditCheckoutAttribute', N'Edit a checkout attribute', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (29, N'EditCountry', N'Edit a country', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (30, N'EditCurrency', N'Edit a currency', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (31, N'EditCustomer', N'Edit a customer', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (32, N'EditCustomerAttribute', N'Edit a customer attribute', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (33, N'EditCustomerAttributeValue', N'Edit a customer attribute value', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (34, N'EditCustomerRole', N'Edit a customer role', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (35, N'EditStateProvince', N'Edit a state or province', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (36, N'EditStore', N'Edit a store', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (37, N'EditTask', N'Edit a task', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (38, N'EditSpecAttribute', N'Edit a specification attribute', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (39, N'PublicStore.ContactUs', N'Public store. Use contact us form', 0)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (40, N'PublicStore.AddToCompareList', N'Public store. Add to compare list', 0)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (41, N'PublicStore.AddToShoppingCart', N'Public store. Add to shopping cart', 0)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (42, N'PublicStore.AddToWishlist', N'Public store. Add to wishlist', 0)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (43, N'PublicStore.Login', N'Public store. Login', 0)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (44, N'PublicStore.Logout', N'Public store. Logout', 0)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (45, N'PublicStore.AddProductReview', N'Public store. Add product review', 0)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (46, N'PublicStore.AddNewsComment', N'Public store. Add news comment', 0)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (47, N'PublicStore.AddBlogComment', N'Public store. Add blog comment', 0)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (48, N'PublicStore.AddForumTopic', N'Public store. Add forum topic', 0)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (49, N'PublicStore.EditForumTopic', N'Public store. Edit forum topic', 0)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (50, N'PublicStore.DeleteForumTopic', N'Public store. Delete forum topic', 0)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (51, N'PublicStore.AddForumPost', N'Public store. Add forum post', 0)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (52, N'PublicStore.EditForumPost', N'Public store. Edit forum post', 0)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (53, N'PublicStore.DeleteForumPost', N'Public store. Delete forum post', 0)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (54, N'PublicStore.SendPM', N'Public store. Send PM', 0)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (55, N'DeleteWarehouse', N'Delete a warehouse', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (56, N'PublicStore.PlaceOrder', N'Public store. Place an order', 0)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (57, N'PublicStore.ViewManufacturer', N'Public store. View a manufacturer', 0)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (58, N'EditVendor', N'Edit a vendor', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (59, N'EditVendorAttribute', N'Edit a vendor attribute', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (60, N'EditVendorAttributeValue', N'Edit a vendor attribute value', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (61, N'EditWarehouse', N'Edit a warehouse', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (62, N'EditTopic', N'Edit a topic', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (63, N'EditWidget', N'Edit a widget', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (64, N'Impersonation.Started', N'Customer impersonation session. Started', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (65, N'Impersonation.Finished', N'Customer impersonation session. Finished', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (66, N'ImportCategories', N'Categories were imported', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (67, N'ImportManufacturers', N'Manufacturers were imported', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (68, N'ImportProducts', N'Products were imported', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (69, N'ImportStates', N'States were imported', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (70, N'InstallNewPlugin', N'Install a new plugin', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (71, N'UninstallPlugin', N'Uninstall a plugin', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (72, N'PublicStore.ViewCategory', N'Public store. View a category', 0)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (73, N'PublicStore.ViewProduct', N'Public store. View a product', 0)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (74, N'UploadNewPlugin', N'Upload a plugin', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (75, N'DeleteVendorAttributeValue', N'Delete a vendor attribute value', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (76, N'DeleteVendor', N'Delete a vendor', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (77, N'AddNewNews', N'Add a new news', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (78, N'AddNewProduct', N'Add a new product', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (79, N'AddNewProductAttribute', N'Add a new product attribute', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (80, N'AddNewSetting', N'Add a new setting', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (81, N'AddNewSpecAttribute', N'Add a new specification attribute', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (82, N'AddNewStateProvince', N'Add a new state or province', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (83, N'AddNewMeasureWeight', N'Add a new measure weight', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (84, N'AddNewStore', N'Add a new store', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (85, N'AddNewReviewType', N'Add a new review type', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (86, N'AddNewVendor', N'Add a new vendor', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (87, N'AddNewVendorAttribute', N'Add a new vendor attribute', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (88, N'AddNewVendorAttributeValue', N'Add a new vendor attribute value', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (89, N'AddNewWarehouse', N'Add a new warehouse', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (90, N'AddNewWidget', N'Add a new widget', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (91, N'AddNewTopic', N'Add a new topic', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (92, N'AddNewMeasureDimension', N'Add a new measure dimension', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (93, N'AddNewManufacturer', N'Add a new manufacturer', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (94, N'AddNewLanguage', N'Add a new language', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (95, N'AddNewAddressAttributeValue', N'Add a new address attribute value', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (96, N'AddNewAffiliate', N'Add a new affiliate', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (97, N'AddNewBlogPost', N'Add a new blog post', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (98, N'AddNewCampaign', N'Add a new campaign', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (99, N'AddNewCategory', N'Add a new category', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (100, N'AddNewCheckoutAttribute', N'Add a new checkout attribute', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (101, N'AddNewCountry', N'Add a new country', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (102, N'AddNewCurrency', N'Add a new currency', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (103, N'AddNewCustomer', N'Add a new customer', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (104, N'AddNewCustomerAttribute', N'Add a new customer attribute', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (105, N'AddNewCustomerAttributeValue', N'Add a new customer attribute value', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (106, N'AddNewCustomerRole', N'Add a new customer role', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (107, N'AddNewDiscount', N'Add a new discount', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (108, N'AddNewEmailAccount', N'Add a new email account', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (109, N'AddNewGiftCard', N'Add a new gift card', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (110, N'DeleteActivityLog', N'Delete activity log', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (111, N'DeleteAddressAttribute', N'Delete an address attribute', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (112, N'DeleteAddressAttributeValue', N'Delete an address attribute value', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (113, N'DeleteAffiliate', N'Delete an affiliate', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (114, N'DeleteNews', N'Delete a news', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (115, N'DeleteNewsComment', N'Delete a news comment', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (116, N'DeleteOrder', N'Delete an order', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (117, N'DeletePlugin', N'Delete a plugin', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (118, N'DeleteProduct', N'Delete a product', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (119, N'DeleteProductAttribute', N'Delete a product attribute', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (120, N'DeleteProductReview', N'Delete a product review', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (121, N'DeleteReturnRequest', N'Delete a return request', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (122, N'DeleteReviewType', N'Delete a review type', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (123, N'DeleteSetting', N'Delete a setting', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (124, N'DeleteSpecAttribute', N'Delete a specification attribute', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (125, N'DeleteStateProvince', N'Delete a state or province', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (126, N'DeleteStore', N'Delete a store', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (127, N'DeleteSystemLog', N'Delete system log', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (128, N'DeleteTopic', N'Delete a topic', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (129, N'DeleteMessageTemplate', N'Delete a message template', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (130, N'DeleteVendorAttribute', N'Delete a vendor attribute', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (131, N'DeleteMeasureWeight', N'Delete a measure weight', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (132, N'DeleteManufacturer', N'Delete a manufacturer', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (133, N'DeleteBlogPost', N'Delete a blog post', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (134, N'DeleteBlogPostComment', N'Delete a blog post comment', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (135, N'DeleteCampaign', N'Delete a campaign', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (136, N'DeleteCategory', N'Delete category', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (137, N'DeleteCheckoutAttribute', N'Delete a checkout attribute', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (138, N'DeleteCountry', N'Delete a country', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (139, N'DeleteCurrency', N'Delete a currency', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (140, N'DeleteCustomer', N'Delete a customer', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (141, N'DeleteCustomerAttribute', N'Delete a customer attribute', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (142, N'DeleteCustomerAttributeValue', N'Delete a customer attribute value', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (143, N'DeleteCustomerRole', N'Delete a customer role', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (144, N'DeleteDiscount', N'Delete a discount', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (145, N'DeleteEmailAccount', N'Delete an email account', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (146, N'DeleteGiftCard', N'Delete a gift card', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (147, N'DeleteLanguage', N'Delete a language', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (148, N'DeleteMeasureDimension', N'Delete a measure dimension', 1)
INSERT [ActivityLogType] ([Id], [SystemKeyword], [Name], [Enabled]) VALUES (149, N'UploadNewTheme', N'Upload a theme', 1)
SET IDENTITY_INSERT [ActivityLogType]  OFF
GO
SET IDENTITY_INSERT [ScheduleTask] ON 

INSERT [ScheduleTask] ([Id], [Name], [Seconds], [Type], [Enabled], [StopOnError], [LastStartUtc], [LastEndUtc], [LastSuccessUtc]) VALUES (1, N'Send emails', 60, N'Nop.Services.Messages.QueuedMessagesSendTask, Nop.Services', 1, 0, NULL, NULL, NULL)
INSERT [ScheduleTask] ([Id], [Name], [Seconds], [Type], [Enabled], [StopOnError], [LastStartUtc], [LastEndUtc], [LastSuccessUtc]) VALUES (2, N'Keep alive', 300, N'Nop.Services.Common.KeepAliveTask, Nop.Services', 1, 0, NULL, NULL, NULL)
INSERT [ScheduleTask] ([Id], [Name], [Seconds], [Type], [Enabled], [StopOnError], [LastStartUtc], [LastEndUtc], [LastSuccessUtc]) VALUES (3, N'Delete guests', 600, N'Nop.Services.Customers.DeleteGuestsTask, Nop.Services', 1, 0, NULL, NULL, NULL)
INSERT [ScheduleTask] ([Id], [Name], [Seconds], [Type], [Enabled], [StopOnError], [LastStartUtc], [LastEndUtc], [LastSuccessUtc]) VALUES (4, N'Clear cache', 600, N'Nop.Services.Caching.ClearCacheTask, Nop.Services', 0, 0, NULL, NULL, NULL)
INSERT [ScheduleTask] ([Id], [Name], [Seconds], [Type], [Enabled], [StopOnError], [LastStartUtc], [LastEndUtc], [LastSuccessUtc]) VALUES (5, N'Clear log', 3600, N'Nop.Services.Logging.ClearLogTask, Nop.Services', 0, 0, NULL, NULL, NULL)
INSERT [ScheduleTask] ([Id], [Name], [Seconds], [Type], [Enabled], [StopOnError], [LastStartUtc], [LastEndUtc], [LastSuccessUtc]) VALUES (6, N'Update currency exchange rates', 3600, N'Nop.Services.Directory.UpdateExchangeRateTask, Nop.Services', 1, 0, NULL, NULL, NULL)
SET IDENTITY_INSERT [ScheduleTask]  OFF
GO
SET IDENTITY_INSERT [Address] ON 

INSERT [Address] ([Id], [FirstName], [LastName], [Email], [Company], [CountryId], [StateProvinceId], [County], [City], [Address1], [Address2], [ZipPostalCode], [PhoneNumber], [FaxNumber], [CustomAttributes], [CreatedOnUtc]) VALUES (1, N'John', N'Smith', N'admin@yourStore.com', N'Nop Solutions Ltd', 1, 16, NULL, N'New York', N'21 West 52nd Street', N'', N'10021', N'12345678', N'', NULL, CAST(N'2019-05-27T15:28:27.5511932' AS DateTime2))
INSERT [Address] ([Id], [FirstName], [LastName], [Email], [Company], [CountryId], [StateProvinceId], [County], [City], [Address1], [Address2], [ZipPostalCode], [PhoneNumber], [FaxNumber], [CustomAttributes], [CreatedOnUtc]) VALUES (2, N'Steve', N'Gates', N'steve_gates@nopCommerce.com', N'Steve Company', 1, 47, NULL, N'Los Angeles', N'750 Bel Air Rd.', N'', N'90077', N'87654321', N'', NULL, CAST(N'2019-05-27T15:28:30.2774009' AS DateTime2))
INSERT [Address] ([Id], [FirstName], [LastName], [Email], [Company], [CountryId], [StateProvinceId], [County], [City], [Address1], [Address2], [ZipPostalCode], [PhoneNumber], [FaxNumber], [CustomAttributes], [CreatedOnUtc]) VALUES (3, N'Arthur', N'Holmes', N'arthur_holmes@nopCommerce.com', N'Holmes Company', 233, NULL, NULL, N'London', N'221B Baker Street', N'', N'NW1 6XE', N'111222333', N'', NULL, CAST(N'2019-05-27T15:28:30.3518212' AS DateTime2))
INSERT [Address] ([Id], [FirstName], [LastName], [Email], [Company], [CountryId], [StateProvinceId], [County], [City], [Address1], [Address2], [ZipPostalCode], [PhoneNumber], [FaxNumber], [CustomAttributes], [CreatedOnUtc]) VALUES (4, N'James', N'Pan', N'james_pan@nopCommerce.com', N'Pan Company', 233, NULL, NULL, N'St Andrews', N'St Katharine’s West 16', N'', N'KY16 9AX', N'369258147', N'', NULL, CAST(N'2019-05-27T15:28:30.4091390' AS DateTime2))
INSERT [Address] ([Id], [FirstName], [LastName], [Email], [Company], [CountryId], [StateProvinceId], [County], [City], [Address1], [Address2], [ZipPostalCode], [PhoneNumber], [FaxNumber], [CustomAttributes], [CreatedOnUtc]) VALUES (5, N'Brenda', N'Lindgren', N'brenda_lindgren@nopCommerce.com', N'Brenda Company', 1, 52, NULL, N'Ketchikan', N'1249 Tongass Avenue, Suite B', N'', N'99901', N'14785236', N'', NULL, CAST(N'2019-05-27T15:28:30.4696158' AS DateTime2))
INSERT [Address] ([Id], [FirstName], [LastName], [Email], [Company], [CountryId], [StateProvinceId], [County], [City], [Address1], [Address2], [ZipPostalCode], [PhoneNumber], [FaxNumber], [CustomAttributes], [CreatedOnUtc]) VALUES (6, N'Victoria', N'Terces', N'victoria_victoria@nopCommerce.com', N'Terces Company', 153, 37, NULL, N'Saskatoon', N'201 1st Avenue South', N'', N'S7K 1J9', N'45612378', N'', NULL, CAST(N'2019-05-27T15:28:30.5378398' AS DateTime2))
INSERT [Address] ([Id], [FirstName], [LastName], [Email], [Company], [CountryId], [StateProvinceId], [County], [City], [Address1], [Address2], [ZipPostalCode], [PhoneNumber], [FaxNumber], [CustomAttributes], [CreatedOnUtc]) VALUES (7, NULL, NULL, NULL, NULL, 1, 16, NULL, N'New York', N'21 West 52nd Street', NULL, N'10021', NULL, NULL, NULL, CAST(N'2019-05-27T15:28:45.1107474' AS DateTime2))
INSERT [Address] ([Id], [FirstName], [LastName], [Email], [Company], [CountryId], [StateProvinceId], [County], [City], [Address1], [Address2], [ZipPostalCode], [PhoneNumber], [FaxNumber], [CustomAttributes], [CreatedOnUtc]) VALUES (8, NULL, NULL, NULL, NULL, 1, 47, NULL, N'Los Angeles', N'300 South Spring Stree', NULL, N'90013', NULL, NULL, NULL, CAST(N'2019-05-27T15:28:45.1385235' AS DateTime2))
INSERT [Address] ([Id], [FirstName], [LastName], [Email], [Company], [CountryId], [StateProvinceId], [County], [City], [Address1], [Address2], [ZipPostalCode], [PhoneNumber], [FaxNumber], [CustomAttributes], [CreatedOnUtc]) VALUES (9, N'John', N'Smith', N'affiliate_email@gmail.com', N'Company name here...', 1, 16, NULL, N'New York', N'21 West 52nd Street', NULL, N'10021', N'123456789', NULL, NULL, CAST(N'2019-05-27T15:28:45.3079192' AS DateTime2))
INSERT [Address] ([Id], [FirstName], [LastName], [Email], [Company], [CountryId], [StateProvinceId], [County], [City], [Address1], [Address2], [ZipPostalCode], [PhoneNumber], [FaxNumber], [CustomAttributes], [CreatedOnUtc]) VALUES (10, N'Steve', N'Gates', N'steve_gates@nopCommerce.com', N'Steve Company', 1, 47, NULL, N'Los Angeles', N'750 Bel Air Rd.', N'', N'90077', N'87654321', N'', NULL, CAST(N'2019-05-27T15:28:30.2774009' AS DateTime2))
INSERT [Address] ([Id], [FirstName], [LastName], [Email], [Company], [CountryId], [StateProvinceId], [County], [City], [Address1], [Address2], [ZipPostalCode], [PhoneNumber], [FaxNumber], [CustomAttributes], [CreatedOnUtc]) VALUES (11, N'Steve', N'Gates', N'steve_gates@nopCommerce.com', N'Steve Company', 1, 47, NULL, N'Los Angeles', N'750 Bel Air Rd.', N'', N'90077', N'87654321', N'', NULL, CAST(N'2019-05-27T15:28:30.2774009' AS DateTime2))
INSERT [Address] ([Id], [FirstName], [LastName], [Email], [Company], [CountryId], [StateProvinceId], [County], [City], [Address1], [Address2], [ZipPostalCode], [PhoneNumber], [FaxNumber], [CustomAttributes], [CreatedOnUtc]) VALUES (12, N'Arthur', N'Holmes', N'arthur_holmes@nopCommerce.com', N'Holmes Company', 233, NULL, NULL, N'London', N'221B Baker Street', N'', N'NW1 6XE', N'111222333', N'', NULL, CAST(N'2019-05-27T15:28:30.3518212' AS DateTime2))
INSERT [Address] ([Id], [FirstName], [LastName], [Email], [Company], [CountryId], [StateProvinceId], [County], [City], [Address1], [Address2], [ZipPostalCode], [PhoneNumber], [FaxNumber], [CustomAttributes], [CreatedOnUtc]) VALUES (13, N'Arthur', N'Holmes', N'arthur_holmes@nopCommerce.com', N'Holmes Company', 233, NULL, NULL, N'London', N'221B Baker Street', N'', N'NW1 6XE', N'111222333', N'', NULL, CAST(N'2019-05-27T15:28:30.3518212' AS DateTime2))
INSERT [Address] ([Id], [FirstName], [LastName], [Email], [Company], [CountryId], [StateProvinceId], [County], [City], [Address1], [Address2], [ZipPostalCode], [PhoneNumber], [FaxNumber], [CustomAttributes], [CreatedOnUtc]) VALUES (14, N'James', N'Pan', N'james_pan@nopCommerce.com', N'Pan Company', 233, NULL, NULL, N'St Andrews', N'St Katharine’s West 16', N'', N'KY16 9AX', N'369258147', N'', NULL, CAST(N'2019-05-27T15:28:30.4091390' AS DateTime2))
INSERT [Address] ([Id], [FirstName], [LastName], [Email], [Company], [CountryId], [StateProvinceId], [County], [City], [Address1], [Address2], [ZipPostalCode], [PhoneNumber], [FaxNumber], [CustomAttributes], [CreatedOnUtc]) VALUES (15, N'Brenda', N'Lindgren', N'brenda_lindgren@nopCommerce.com', N'Brenda Company', 1, 52, NULL, N'Ketchikan', N'1249 Tongass Avenue, Suite B', N'', N'99901', N'14785236', N'', NULL, CAST(N'2019-05-27T15:28:30.4696158' AS DateTime2))
INSERT [Address] ([Id], [FirstName], [LastName], [Email], [Company], [CountryId], [StateProvinceId], [County], [City], [Address1], [Address2], [ZipPostalCode], [PhoneNumber], [FaxNumber], [CustomAttributes], [CreatedOnUtc]) VALUES (16, N'Brenda', N'Lindgren', N'brenda_lindgren@nopCommerce.com', N'Brenda Company', 1, 52, NULL, N'Ketchikan', N'1249 Tongass Avenue, Suite B', N'', N'99901', N'14785236', N'', NULL, CAST(N'2019-05-27T15:28:30.4696158' AS DateTime2))
INSERT [Address] ([Id], [FirstName], [LastName], [Email], [Company], [CountryId], [StateProvinceId], [County], [City], [Address1], [Address2], [ZipPostalCode], [PhoneNumber], [FaxNumber], [CustomAttributes], [CreatedOnUtc]) VALUES (17, N'Brenda', N'Lindgren', N'brenda_lindgren@nopCommerce.com', N'Brenda Company', 1, 52, NULL, N'Ketchikan', N'1249 Tongass Avenue, Suite B', N'', N'99901', N'14785236', N'', NULL, CAST(N'2019-05-27T15:28:30.4696158' AS DateTime2))
INSERT [Address] ([Id], [FirstName], [LastName], [Email], [Company], [CountryId], [StateProvinceId], [County], [City], [Address1], [Address2], [ZipPostalCode], [PhoneNumber], [FaxNumber], [CustomAttributes], [CreatedOnUtc]) VALUES (18, N'Victoria', N'Terces', N'victoria_victoria@nopCommerce.com', N'Terces Company', 153, 37, NULL, N'Saskatoon', N'201 1st Avenue South', N'', N'S7K 1J9', N'45612378', N'', NULL, CAST(N'2019-05-27T15:28:30.5378398' AS DateTime2))
INSERT [Address] ([Id], [FirstName], [LastName], [Email], [Company], [CountryId], [StateProvinceId], [County], [City], [Address1], [Address2], [ZipPostalCode], [PhoneNumber], [FaxNumber], [CustomAttributes], [CreatedOnUtc]) VALUES (19, N'Victoria', N'Terces', N'victoria_victoria@nopCommerce.com', N'Terces Company', 153, 37, NULL, N'Saskatoon', N'201 1st Avenue South', N'', N'S7K 1J9', N'45612378', N'', NULL, CAST(N'2019-05-27T15:28:30.5378398' AS DateTime2))
INSERT [Address] ([Id], [FirstName], [LastName], [Email], [Company], [CountryId], [StateProvinceId], [County], [City], [Address1], [Address2], [ZipPostalCode], [PhoneNumber], [FaxNumber], [CustomAttributes], [CreatedOnUtc]) VALUES (20, NULL, NULL, NULL, NULL, 1, 16, NULL, N'New York', N'21 West 52nd Street', NULL, N'10021', NULL, NULL, NULL, CAST(N'2019-05-27T15:28:59.7263102' AS DateTime2))
SET IDENTITY_INSERT [Address]  OFF
GO
SET IDENTITY_INSERT [Customer] ON 

INSERT [Customer] ([Id], [CustomerGuid], [Username], [Email], [EmailToRevalidate], [AdminComment], [IsTaxExempt], [AffiliateId], [VendorId], [HasShoppingCartItems], [RequireReLogin], [FailedLoginAttempts], [CannotLoginUntilDateUtc], [Active], [Deleted], [IsSystemAccount], [SystemName], [LastIpAddress], [CreatedOnUtc], [LastLoginDateUtc], [LastActivityDateUtc], [RegisteredInStoreId], [BillingAddress_Id], [ShippingAddress_Id]) VALUES (1, N'f6c0f4bc-3219-40ff-ba48-746ab89b9356', N'admin@yourStore.com', N'admin@yourStore.com', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, NULL, N'127.0.0.1', CAST(N'2019-05-27T15:28:27.5258262' AS DateTime2), NULL, CAST(N'2019-05-27T15:28:27.5258768' AS DateTime2), 1, 1, 1)
INSERT [Customer] ([Id], [CustomerGuid], [Username], [Email], [EmailToRevalidate], [AdminComment], [IsTaxExempt], [AffiliateId], [VendorId], [HasShoppingCartItems], [RequireReLogin], [FailedLoginAttempts], [CannotLoginUntilDateUtc], [Active], [Deleted], [IsSystemAccount], [SystemName], [LastIpAddress], [CreatedOnUtc], [LastLoginDateUtc], [LastActivityDateUtc], [RegisteredInStoreId], [BillingAddress_Id], [ShippingAddress_Id]) VALUES (2, N'a8fce858-7e76-4169-aa48-3e39f0d9412f', NULL, N'builtin@search_engine_record.com', NULL, N'Built-in system guest record used for requests from search engines.', 0, 0, 0, 0, 0, 0, NULL, 1, 0, 1, N'SearchEngine', NULL, CAST(N'2019-05-27T15:28:27.9219565' AS DateTime2), NULL, CAST(N'2019-05-27T15:28:27.9219565' AS DateTime2), 1, NULL, NULL)
INSERT [Customer] ([Id], [CustomerGuid], [Username], [Email], [EmailToRevalidate], [AdminComment], [IsTaxExempt], [AffiliateId], [VendorId], [HasShoppingCartItems], [RequireReLogin], [FailedLoginAttempts], [CannotLoginUntilDateUtc], [Active], [Deleted], [IsSystemAccount], [SystemName], [LastIpAddress], [CreatedOnUtc], [LastLoginDateUtc], [LastActivityDateUtc], [RegisteredInStoreId], [BillingAddress_Id], [ShippingAddress_Id]) VALUES (3, N'b72cba5f-86cf-483b-8987-74c0f2f05495', NULL, N'builtin@background-task-record.com', NULL, N'Built-in system record used for background tasks.', 0, 0, 0, 0, 0, 0, NULL, 1, 0, 1, N'BackgroundTask', NULL, CAST(N'2019-05-27T15:28:27.9386273' AS DateTime2), NULL, CAST(N'2019-05-27T15:28:27.9386273' AS DateTime2), 1, NULL, NULL)
INSERT [Customer] ([Id], [CustomerGuid], [Username], [Email], [EmailToRevalidate], [AdminComment], [IsTaxExempt], [AffiliateId], [VendorId], [HasShoppingCartItems], [RequireReLogin], [FailedLoginAttempts], [CannotLoginUntilDateUtc], [Active], [Deleted], [IsSystemAccount], [SystemName], [LastIpAddress], [CreatedOnUtc], [LastLoginDateUtc], [LastActivityDateUtc], [RegisteredInStoreId], [BillingAddress_Id], [ShippingAddress_Id]) VALUES (4, N'08f246cd-a68f-4d31-9f7a-796de86c9fb3', N'steve_gates@nopCommerce.com', N'steve_gates@nopCommerce.com', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, NULL, NULL, CAST(N'2019-05-27T15:28:30.2711180' AS DateTime2), NULL, CAST(N'2019-05-27T15:28:30.2711180' AS DateTime2), 1, 2, 2)
INSERT [Customer] ([Id], [CustomerGuid], [Username], [Email], [EmailToRevalidate], [AdminComment], [IsTaxExempt], [AffiliateId], [VendorId], [HasShoppingCartItems], [RequireReLogin], [FailedLoginAttempts], [CannotLoginUntilDateUtc], [Active], [Deleted], [IsSystemAccount], [SystemName], [LastIpAddress], [CreatedOnUtc], [LastLoginDateUtc], [LastActivityDateUtc], [RegisteredInStoreId], [BillingAddress_Id], [ShippingAddress_Id]) VALUES (5, N'9b8dd3d2-818f-4209-a615-51b95d0cd604', N'arthur_holmes@nopCommerce.com', N'arthur_holmes@nopCommerce.com', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, NULL, NULL, CAST(N'2019-05-27T15:28:30.3452116' AS DateTime2), NULL, CAST(N'2019-05-27T15:28:30.3452120' AS DateTime2), 1, 3, 3)
INSERT [Customer] ([Id], [CustomerGuid], [Username], [Email], [EmailToRevalidate], [AdminComment], [IsTaxExempt], [AffiliateId], [VendorId], [HasShoppingCartItems], [RequireReLogin], [FailedLoginAttempts], [CannotLoginUntilDateUtc], [Active], [Deleted], [IsSystemAccount], [SystemName], [LastIpAddress], [CreatedOnUtc], [LastLoginDateUtc], [LastActivityDateUtc], [RegisteredInStoreId], [BillingAddress_Id], [ShippingAddress_Id]) VALUES (6, N'b5edd40f-b424-4d2b-8503-17a74f7f90c2', N'james_pan@nopCommerce.com', N'james_pan@nopCommerce.com', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, NULL, NULL, CAST(N'2019-05-27T15:28:30.4087164' AS DateTime2), NULL, CAST(N'2019-05-27T15:28:30.4087164' AS DateTime2), 1, 4, 4)
INSERT [Customer] ([Id], [CustomerGuid], [Username], [Email], [EmailToRevalidate], [AdminComment], [IsTaxExempt], [AffiliateId], [VendorId], [HasShoppingCartItems], [RequireReLogin], [FailedLoginAttempts], [CannotLoginUntilDateUtc], [Active], [Deleted], [IsSystemAccount], [SystemName], [LastIpAddress], [CreatedOnUtc], [LastLoginDateUtc], [LastActivityDateUtc], [RegisteredInStoreId], [BillingAddress_Id], [ShippingAddress_Id]) VALUES (7, N'38130602-5bfc-43f4-a795-a37b74257053', N'brenda_lindgren@nopCommerce.com', N'brenda_lindgren@nopCommerce.com', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, NULL, NULL, CAST(N'2019-05-27T15:28:30.4635192' AS DateTime2), NULL, CAST(N'2019-05-27T15:28:30.4635192' AS DateTime2), 1, 5, 5)
INSERT [Customer] ([Id], [CustomerGuid], [Username], [Email], [EmailToRevalidate], [AdminComment], [IsTaxExempt], [AffiliateId], [VendorId], [HasShoppingCartItems], [RequireReLogin], [FailedLoginAttempts], [CannotLoginUntilDateUtc], [Active], [Deleted], [IsSystemAccount], [SystemName], [LastIpAddress], [CreatedOnUtc], [LastLoginDateUtc], [LastActivityDateUtc], [RegisteredInStoreId], [BillingAddress_Id], [ShippingAddress_Id]) VALUES (8, N'7e08c6ff-3401-424c-89f7-a2c682fbde2c', N'victoria_victoria@nopCommerce.com', N'victoria_victoria@nopCommerce.com', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, NULL, NULL, CAST(N'2019-05-27T15:28:30.5255692' AS DateTime2), NULL, CAST(N'2019-05-27T15:28:30.5255692' AS DateTime2), 1, 6, 6)
SET IDENTITY_INSERT [Customer]  OFF
GO
INSERT [CustomerAddresses] ([Customer_Id], [Address_Id]) VALUES (1, 1)
INSERT [CustomerAddresses] ([Customer_Id], [Address_Id]) VALUES (4, 2)
INSERT [CustomerAddresses] ([Customer_Id], [Address_Id]) VALUES (5, 3)
INSERT [CustomerAddresses] ([Customer_Id], [Address_Id]) VALUES (6, 4)
INSERT [CustomerAddresses] ([Customer_Id], [Address_Id]) VALUES (7, 5)
INSERT [CustomerAddresses] ([Customer_Id], [Address_Id]) VALUES (8, 6)
GO
INSERT [Customer_CustomerRole_Mapping] ([Customer_Id], [CustomerRole_Id]) VALUES (1, 1)
INSERT [Customer_CustomerRole_Mapping] ([Customer_Id], [CustomerRole_Id]) VALUES (1, 2)
INSERT [Customer_CustomerRole_Mapping] ([Customer_Id], [CustomerRole_Id]) VALUES (1, 3)
INSERT [Customer_CustomerRole_Mapping] ([Customer_Id], [CustomerRole_Id]) VALUES (2, 4)
INSERT [Customer_CustomerRole_Mapping] ([Customer_Id], [CustomerRole_Id]) VALUES (3, 4)
INSERT [Customer_CustomerRole_Mapping] ([Customer_Id], [CustomerRole_Id]) VALUES (4, 3)
INSERT [Customer_CustomerRole_Mapping] ([Customer_Id], [CustomerRole_Id]) VALUES (5, 3)
INSERT [Customer_CustomerRole_Mapping] ([Customer_Id], [CustomerRole_Id]) VALUES (6, 3)
INSERT [Customer_CustomerRole_Mapping] ([Customer_Id], [CustomerRole_Id]) VALUES (7, 3)
INSERT [Customer_CustomerRole_Mapping] ([Customer_Id], [CustomerRole_Id]) VALUES (8, 3)
GO
SET IDENTITY_INSERT [DeliveryDate] ON 

INSERT [DeliveryDate] ([Id], [Name], [DisplayOrder]) VALUES (1, N'1-2 days', 1)
INSERT [DeliveryDate] ([Id], [Name], [DisplayOrder]) VALUES (2, N'3-5 days', 5)
INSERT [DeliveryDate] ([Id], [Name], [DisplayOrder]) VALUES (3, N'1 week', 10)
SET IDENTITY_INSERT [DeliveryDate]  OFF
GO
SET IDENTITY_INSERT [ReturnRequestAction] ON 

INSERT [ReturnRequestAction] ([Id], [Name], [DisplayOrder]) VALUES (1, N'Repair', 1)
INSERT [ReturnRequestAction] ([Id], [Name], [DisplayOrder]) VALUES (2, N'Replacement', 2)
INSERT [ReturnRequestAction] ([Id], [Name], [DisplayOrder]) VALUES (3, N'Store Credit', 3)
SET IDENTITY_INSERT [ReturnRequestAction]  OFF
GO
SET IDENTITY_INSERT [ReturnRequestReason] ON 

INSERT [ReturnRequestReason] ([Id], [Name], [DisplayOrder]) VALUES (1, N'Received Wrong Product', 1)
INSERT [ReturnRequestReason] ([Id], [Name], [DisplayOrder]) VALUES (2, N'Wrong Product Ordered', 2)
INSERT [ReturnRequestReason] ([Id], [Name], [DisplayOrder]) VALUES (3, N'There Was A Problem With The Product', 3)
SET IDENTITY_INSERT [ReturnRequestReason]  OFF
GO

SET IDENTITY_INSERT [UrlRecord] ON 

INSERT [UrlRecord] ([Id], [EntityId], [EntityName], [Slug], [IsActive], [LanguageId]) VALUES (1, 1, N'Topic', N'about-us', 1, 0)
INSERT [UrlRecord] ([Id], [EntityId], [EntityName], [Slug], [IsActive], [LanguageId]) VALUES (2, 2, N'Topic', N'checkoutasguestorregister', 1, 0)
INSERT [UrlRecord] ([Id], [EntityId], [EntityName], [Slug], [IsActive], [LanguageId]) VALUES (3, 3, N'Topic', N'conditions-of-use', 1, 0)
INSERT [UrlRecord] ([Id], [EntityId], [EntityName], [Slug], [IsActive], [LanguageId]) VALUES (4, 4, N'Topic', N'contactus', 1, 0)
INSERT [UrlRecord] ([Id], [EntityId], [EntityName], [Slug], [IsActive], [LanguageId]) VALUES (5, 5, N'Topic', N'forums', 1, 0)
INSERT [UrlRecord] ([Id], [EntityId], [EntityName], [Slug], [IsActive], [LanguageId]) VALUES (6, 6, N'Topic', N'welcome-to-our-store', 1, 0)
INSERT [UrlRecord] ([Id], [EntityId], [EntityName], [Slug], [IsActive], [LanguageId]) VALUES (7, 7, N'Topic', N'about-login-registration', 1, 0)
INSERT [UrlRecord] ([Id], [EntityId], [EntityName], [Slug], [IsActive], [LanguageId]) VALUES (8, 8, N'Topic', N'privacy-notice', 1, 0)
INSERT [UrlRecord] ([Id], [EntityId], [EntityName], [Slug], [IsActive], [LanguageId]) VALUES (9, 9, N'Topic', N'pagenotfound', 1, 0)
INSERT [UrlRecord] ([Id], [EntityId], [EntityName], [Slug], [IsActive], [LanguageId]) VALUES (10, 10, N'Topic', N'shipping-returns', 1, 0)
INSERT [UrlRecord] ([Id], [EntityId], [EntityName], [Slug], [IsActive], [LanguageId]) VALUES (11, 11, N'Topic', N'applyvendor', 1, 0)
INSERT [UrlRecord] ([Id], [EntityId], [EntityName], [Slug], [IsActive], [LanguageId]) VALUES (12, 12, N'Topic', N'terms-of-services-for-vendors', 1, 0)
SET IDENTITY_INSERT [UrlRecord]  OFF
GO