create_required_data.sql

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 [EmailAccount] ON 

INSERT [EmailAccount] ([Id], [Email], [DisplayName], [Host], [Port], [Username], [Password], [EnableSsl], [UseDefaultCredentials]) VALUES (1, N'test@mail.com', N'Store name', N'smtp.mail.com', 25, N'123', N'123', 0, 0)
SET IDENTITY_INSERT [EmailAccount]  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 [Topic] ON 

INSERT [Topic] ([Id], [SystemName], [IncludeInSitemap], [IncludeInTopMenu], [IncludeInFooterColumn1], [IncludeInFooterColumn2], [IncludeInFooterColumn3], [DisplayOrder], [AccessibleWhenStoreClosed], [IsPasswordProtected], [Password], [Title], [Body], [Published], [TopicTemplateId], [MetaKeywords], [MetaDescription], [MetaTitle], [SubjectToAcl], [LimitedToStores]) VALUES (1, N'AboutUs', 0, 0, 1, 0, 0, 20, 0, 0, NULL, N'About us', N'<p>Put your &quot;About Us&quot; information here. You can edit this in the admin site.</p>', 1, 1, NULL, NULL, NULL, 0, 0)
INSERT [Topic] ([Id], [SystemName], [IncludeInSitemap], [IncludeInTopMenu], [IncludeInFooterColumn1], [IncludeInFooterColumn2], [IncludeInFooterColumn3], [DisplayOrder], [AccessibleWhenStoreClosed], [IsPasswordProtected], [Password], [Title], [Body], [Published], [TopicTemplateId], [MetaKeywords], [MetaDescription], [MetaTitle], [SubjectToAcl], [LimitedToStores]) VALUES (2, N'CheckoutAsGuestOrRegister', 0, 0, 0, 0, 0, 1, 0, 0, NULL, N'', N'<p><strong>Register and save time!</strong><br />Register with us for future convenience:</p><ul><li>Fast and easy check out</li><li>Easy access to your order history and status</li></ul>', 1, 1, NULL, NULL, NULL, 0, 0)
INSERT [Topic] ([Id], [SystemName], [IncludeInSitemap], [IncludeInTopMenu], [IncludeInFooterColumn1], [IncludeInFooterColumn2], [IncludeInFooterColumn3], [DisplayOrder], [AccessibleWhenStoreClosed], [IsPasswordProtected], [Password], [Title], [Body], [Published], [TopicTemplateId], [MetaKeywords], [MetaDescription], [MetaTitle], [SubjectToAcl], [LimitedToStores]) VALUES (3, N'ConditionsOfUse', 0, 0, 1, 0, 0, 15, 0, 0, NULL, N'Conditions of Use', N'<p>Put your conditions of use information here. You can edit this in the admin site.</p>', 1, 1, NULL, NULL, NULL, 0, 0)
INSERT [Topic] ([Id], [SystemName], [IncludeInSitemap], [IncludeInTopMenu], [IncludeInFooterColumn1], [IncludeInFooterColumn2], [IncludeInFooterColumn3], [DisplayOrder], [AccessibleWhenStoreClosed], [IsPasswordProtected], [Password], [Title], [Body], [Published], [TopicTemplateId], [MetaKeywords], [MetaDescription], [MetaTitle], [SubjectToAcl], [LimitedToStores]) VALUES (4, N'ContactUs', 0, 0, 0, 0, 0, 1, 0, 0, NULL, N'', N'<p>Put your contact information here. You can edit this in the admin site.</p>', 1, 1, NULL, NULL, NULL, 0, 0)
INSERT [Topic] ([Id], [SystemName], [IncludeInSitemap], [IncludeInTopMenu], [IncludeInFooterColumn1], [IncludeInFooterColumn2], [IncludeInFooterColumn3], [DisplayOrder], [AccessibleWhenStoreClosed], [IsPasswordProtected], [Password], [Title], [Body], [Published], [TopicTemplateId], [MetaKeywords], [MetaDescription], [MetaTitle], [SubjectToAcl], [LimitedToStores]) VALUES (5, N'ForumWelcomeMessage', 0, 0, 0, 0, 0, 1, 0, 0, NULL, N'Forums', N'<p>Put your welcome message here. You can edit this in the admin site.</p>', 1, 1, NULL, NULL, NULL, 0, 0)
INSERT [Topic] ([Id], [SystemName], [IncludeInSitemap], [IncludeInTopMenu], [IncludeInFooterColumn1], [IncludeInFooterColumn2], [IncludeInFooterColumn3], [DisplayOrder], [AccessibleWhenStoreClosed], [IsPasswordProtected], [Password], [Title], [Body], [Published], [TopicTemplateId], [MetaKeywords], [MetaDescription], [MetaTitle], [SubjectToAcl], [LimitedToStores]) VALUES (6, N'HomepageText', 0, 0, 0, 0, 0, 1, 0, 0, NULL, N'Welcome to our store', N'<p>Online shopping is the process consumers go through to purchase products or services over the Internet. You can edit this in the admin site.</p><p>If you have questions, see the <a href="http://docs.nopcommerce.com/">Documentation</a>, or post in the <a href="https://www.nopcommerce.com/boards/">Forums</a> at <a href="https://www.nopcommerce.com">nopCommerce.com</a></p>', 1, 1, NULL, NULL, NULL, 0, 0)
INSERT [Topic] ([Id], [SystemName], [IncludeInSitemap], [IncludeInTopMenu], [IncludeInFooterColumn1], [IncludeInFooterColumn2], [IncludeInFooterColumn3], [DisplayOrder], [AccessibleWhenStoreClosed], [IsPasswordProtected], [Password], [Title], [Body], [Published], [TopicTemplateId], [MetaKeywords], [MetaDescription], [MetaTitle], [SubjectToAcl], [LimitedToStores]) VALUES (7, N'LoginRegistrationInfo', 0, 0, 0, 0, 0, 1, 0, 0, NULL, N'About login / registration', N'<p>Put your login / registration information here. You can edit this in the admin site.</p>', 1, 1, NULL, NULL, NULL, 0, 0)
INSERT [Topic] ([Id], [SystemName], [IncludeInSitemap], [IncludeInTopMenu], [IncludeInFooterColumn1], [IncludeInFooterColumn2], [IncludeInFooterColumn3], [DisplayOrder], [AccessibleWhenStoreClosed], [IsPasswordProtected], [Password], [Title], [Body], [Published], [TopicTemplateId], [MetaKeywords], [MetaDescription], [MetaTitle], [SubjectToAcl], [LimitedToStores]) VALUES (8, N'PrivacyInfo', 0, 0, 1, 0, 0, 10, 0, 0, NULL, N'Privacy notice', N'<p>Put your privacy policy information here. You can edit this in the admin site.</p>', 1, 1, NULL, NULL, NULL, 0, 0)
INSERT [Topic] ([Id], [SystemName], [IncludeInSitemap], [IncludeInTopMenu], [IncludeInFooterColumn1], [IncludeInFooterColumn2], [IncludeInFooterColumn3], [DisplayOrder], [AccessibleWhenStoreClosed], [IsPasswordProtected], [Password], [Title], [Body], [Published], [TopicTemplateId], [MetaKeywords], [MetaDescription], [MetaTitle], [SubjectToAcl], [LimitedToStores]) VALUES (9, N'PageNotFound', 0, 0, 0, 0, 0, 1, 0, 0, NULL, N'', N'<p><strong>The page you requested was not found, and we have a fine guess why.</strong></p><ul><li>If you typed the URL directly, please make sure the spelling is correct.</li><li>The page no longer exists. In this case, we profusely apologize for the inconvenience and for any damage this may cause.</li></ul>', 1, 1, NULL, NULL, NULL, 0, 0)
INSERT [Topic] ([Id], [SystemName], [IncludeInSitemap], [IncludeInTopMenu], [IncludeInFooterColumn1], [IncludeInFooterColumn2], [IncludeInFooterColumn3], [DisplayOrder], [AccessibleWhenStoreClosed], [IsPasswordProtected], [Password], [Title], [Body], [Published], [TopicTemplateId], [MetaKeywords], [MetaDescription], [MetaTitle], [SubjectToAcl], [LimitedToStores]) VALUES (10, N'ShippingInfo', 0, 0, 1, 0, 0, 5, 0, 0, NULL, N'Shipping & returns', N'<p>Put your shipping &amp; returns information here. You can edit this in the admin site.</p>', 1, 1, NULL, NULL, NULL, 0, 0)
INSERT [Topic] ([Id], [SystemName], [IncludeInSitemap], [IncludeInTopMenu], [IncludeInFooterColumn1], [IncludeInFooterColumn2], [IncludeInFooterColumn3], [DisplayOrder], [AccessibleWhenStoreClosed], [IsPasswordProtected], [Password], [Title], [Body], [Published], [TopicTemplateId], [MetaKeywords], [MetaDescription], [MetaTitle], [SubjectToAcl], [LimitedToStores]) VALUES (11, N'ApplyVendor', 0, 0, 0, 0, 0, 1, 0, 0, NULL, N'', N'<p>Put your apply vendor instructions here. You can edit this in the admin site.</p>', 1, 1, NULL, NULL, NULL, 0, 0)
INSERT [Topic] ([Id], [SystemName], [IncludeInSitemap], [IncludeInTopMenu], [IncludeInFooterColumn1], [IncludeInFooterColumn2], [IncludeInFooterColumn3], [DisplayOrder], [AccessibleWhenStoreClosed], [IsPasswordProtected], [Password], [Title], [Body], [Published], [TopicTemplateId], [MetaKeywords], [MetaDescription], [MetaTitle], [SubjectToAcl], [LimitedToStores]) VALUES (12, N'VendorTermsOfService', 0, 0, 0, 0, 0, 1, 0, 0, NULL, N'Terms of services for vendors', N'<p>Put your terms of service information here. You can edit this in the admin site.</p>', 1, 1, NULL, NULL, NULL, 0, 0)
SET IDENTITY_INSERT [Topic]  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 [Setting] ON 

INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (1, N'pdfsettings.logopictureid', N'0', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (2, N'pdfsettings.letterpagesizeenabled', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (3, N'pdfsettings.renderordernotes', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (4, N'pdfsettings.disablepdfinvoicesforpendingorders', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (5, N'pdfsettings.fontfilename', N'FreeSerif.ttf', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (6, N'pdfsettings.invoicefootertextcolumn1', N'', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (7, N'pdfsettings.invoicefootertextcolumn2', N'', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (8, N'sitemapsettings.sitemapenabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (9, N'sitemapsettings.sitemappagesize', N'200', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (10, N'sitemapsettings.sitemapincludeblogposts', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (11, N'sitemapsettings.sitemapincludecategories', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (12, N'sitemapsettings.sitemapincludemanufacturers', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (13, N'sitemapsettings.sitemapincludenews', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (14, N'sitemapsettings.sitemapincludeproducts', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (15, N'sitemapsettings.sitemapincludeproducttags', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (16, N'sitemapsettings.sitemapincludetopics', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (17, N'sitemapxmlsettings.sitemapxmlenabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (18, N'sitemapxmlsettings.sitemapxmlincludeblogposts', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (19, N'sitemapxmlsettings.sitemapxmlincludecategories', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (20, N'sitemapxmlsettings.sitemapxmlincludecustomurls', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (21, N'sitemapxmlsettings.sitemapxmlincludemanufacturers', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (22, N'sitemapxmlsettings.sitemapxmlincludenews', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (23, N'sitemapxmlsettings.sitemapxmlincludeproducts', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (24, N'sitemapxmlsettings.sitemapxmlincludeproducttags', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (25, N'sitemapxmlsettings.sitemapxmlincludetopics', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (26, N'sitemapxmlsettings.sitemapcustomurls', N'', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (27, N'commonsettings.subjectfieldoncontactusform', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (28, N'commonsettings.usesystememailforcontactusform', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (29, N'commonsettings.usestoredprocedureforloadingcategories', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (30, N'commonsettings.displayjavascriptdisabledwarning', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (31, N'commonsettings.usefulltextsearch', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (32, N'commonsettings.fulltextmode', N'ExactMatch', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (33, N'commonsettings.log404errors', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (34, N'commonsettings.breadcrumbdelimiter', N'/', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (35, N'commonsettings.renderxuacompatible', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (36, N'commonsettings.xuacompatiblevalue', N'IE=edge', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (37, N'commonsettings.ignorelogwordlist', N'', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (38, N'commonsettings.bbcodeeditoropenlinksinnewwindow', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (39, N'commonsettings.popupfortermsofservicelinks', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (40, N'commonsettings.jquerymigratescriptloggingactive', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (41, N'commonsettings.supportpreviousnopcommerceversions', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (42, N'commonsettings.useresponsecompression', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (43, N'commonsettings.staticfilescachecontrol', N'public,max-age=604800', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (44, N'commonsettings.faviconandappiconsheadcode', N'<link rel="apple-touch-icon" sizes="180x180" href="/icons/icons_0/apple-touch-icon.png"><link rel="icon" type="image/png" sizes="32x32" href="/icons/icons_0/favicon-32x32.png"><link rel="icon" type="image/png" sizes="192x192" href="/icons/icons_0/android-chrome-192x192.png"><link rel="icon" type="image/png" sizes="16x16" href="/icons/icons_0/favicon-16x16.png"><link rel="manifest" href="/icons/icons_0/site.webmanifest"><link rel="mask-icon" href="/icons/icons_0/safari-pinned-tab.svg" color="#5bbad5"><link rel="shortcut icon" href="/icons/icons_0/favicon.ico"><meta name="msapplication-TileColor" content="#2d89ef"><meta name="msapplication-TileImage" content="/icons/icons_0/mstile-144x144.png"><meta name="msapplication-config" content="/icons/icons_0/browserconfig.xml"><meta name="theme-color" content="#ffffff">', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (45, N'commonsettings.enablehtmlminification', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (46, N'commonsettings.enablejsbundling', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (47, N'commonsettings.enablecssbundling', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (48, N'commonsettings.scheduletaskruntimeout', N'', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (49, N'seosettings.pagetitleseparator', N'. ', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (50, N'seosettings.pagetitleseoadjustment', N'PagenameAfterStorename', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (51, N'seosettings.defaulttitle', N'Your store', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (52, N'seosettings.defaultmetakeywords', N'', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (53, N'seosettings.defaultmetadescription', N'', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (54, N'seosettings.generateproductmetadescription', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (55, N'seosettings.convertnonwesternchars', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (56, N'seosettings.allowunicodecharsinurls', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (57, N'seosettings.canonicalurlsenabled', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (58, N'seosettings.querystringincanonicalurlsenabled', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (59, N'seosettings.wwwrequirement', N'NoMatter', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (60, N'seosettings.twittermetatags', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (61, N'seosettings.opengraphmetatags', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (62, N'seosettings.reservedurlrecordslugs', N'admin,install,recentlyviewedproducts,newproducts,compareproducts,clearcomparelist,setproductreviewhelpfulness,login,register,logout,cart,wishlist,emailwishlist,checkout,onepagecheckout,contactus,passwordrecovery,subscribenewsletter,blog,boards,inboxupdate,sentupdate,news,sitemap,search,config,eucookielawaccept,page-not-found,con,lpt1,lpt2,lpt3,lpt4,lpt5,lpt6,lpt7,lpt8,lpt9,com1,com2,com3,com4,com5,com6,com7,com8,com9,null,prn,aux', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (63, N'seosettings.customheadtags', N'', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (64, N'adminareasettings.defaultgridpagesize', N'15', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (65, N'adminareasettings.popupgridpagesize', N'7', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (66, N'adminareasettings.gridpagesizes', N'7, 15, 20, 50, 100', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (67, N'adminareasettings.richeditoradditionalsettings', N'', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (68, N'adminareasettings.richeditorallowjavascript', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (69, N'adminareasettings.richeditorallowstyletag', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (70, N'adminareasettings.usericheditorforcustomeremails', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (71, N'adminareasettings.usericheditorinmessagetemplates', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (72, N'adminareasettings.hideadvertisementsonadminarea', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (73, N'adminareasettings.checkcopyrightremovalkey', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (74, N'adminareasettings.lastnewstitleadminarea', N'', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (75, N'adminareasettings.useisodateformatinjsonresult', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (76, N'producteditorsettings.producttype', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (77, N'producteditorsettings.visibleindividually', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (78, N'producteditorsettings.producttemplate', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (79, N'producteditorsettings.admincomment', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (80, N'producteditorsettings.vendor', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (81, N'producteditorsettings.stores', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (82, N'producteditorsettings.acl', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (83, N'producteditorsettings.showonhomepage', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (84, N'producteditorsettings.displayorder', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (85, N'producteditorsettings.allowcustomerreviews', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (86, N'producteditorsettings.producttags', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (87, N'producteditorsettings.manufacturerpartnumber', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (88, N'producteditorsettings.gtin', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (89, N'producteditorsettings.productcost', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (90, N'producteditorsettings.tierprices', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (91, N'producteditorsettings.discounts', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (92, N'producteditorsettings.disablebuybutton', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (93, N'producteditorsettings.disablewishlistbutton', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (94, N'producteditorsettings.availableforpreorder', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (95, N'producteditorsettings.callforprice', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (96, N'producteditorsettings.oldprice', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (97, N'producteditorsettings.customerentersprice', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (98, N'producteditorsettings.pangv', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (99, N'producteditorsettings.requireotherproductsaddedtothecart', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (100, N'producteditorsettings.isgiftcard', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (101, N'producteditorsettings.downloadableproduct', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (102, N'producteditorsettings.recurringproduct', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (103, N'producteditorsettings.isrental', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (104, N'producteditorsettings.freeshipping', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (105, N'producteditorsettings.shipseparately', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (106, N'producteditorsettings.additionalshippingcharge', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (107, N'producteditorsettings.deliverydate', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (108, N'producteditorsettings.telecommunicationsbroadcastingelectronicservices', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (109, N'producteditorsettings.productavailabilityrange', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (110, N'producteditorsettings.usemultiplewarehouses', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (111, N'producteditorsettings.warehouse', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (112, N'producteditorsettings.displaystockavailability', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (113, N'producteditorsettings.displaystockquantity', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (114, N'producteditorsettings.minimumstockquantity', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (115, N'producteditorsettings.lowstockactivity', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (116, N'producteditorsettings.notifyadminforquantitybelow', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (117, N'producteditorsettings.backorders', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (118, N'producteditorsettings.allowbackinstocksubscriptions', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (119, N'producteditorsettings.minimumcartquantity', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (120, N'producteditorsettings.maximumcartquantity', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (121, N'producteditorsettings.allowedquantities', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (122, N'producteditorsettings.allowaddingonlyexistingattributecombinations', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (123, N'producteditorsettings.notreturnable', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (124, N'producteditorsettings.weight', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (125, N'producteditorsettings.dimensions', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (126, N'producteditorsettings.availablestartdate', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (127, N'producteditorsettings.availableenddate', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (128, N'producteditorsettings.markasnew', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (129, N'producteditorsettings.markasnewstartdate', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (130, N'producteditorsettings.markasnewenddate', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (131, N'producteditorsettings.published', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (132, N'producteditorsettings.relatedproducts', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (133, N'producteditorsettings.crosssellsproducts', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (134, N'producteditorsettings.seo', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (135, N'producteditorsettings.purchasedwithorders', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (136, N'producteditorsettings.productattributes', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (137, N'producteditorsettings.specificationattributes', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (138, N'producteditorsettings.manufacturers', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (139, N'producteditorsettings.stockquantityhistory', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (140, N'gdprsettings.gdprenabled', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (141, N'gdprsettings.logprivacypolicyconsent', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (142, N'gdprsettings.lognewsletterconsent', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (143, N'gdprsettings.loguserprofilechanges', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (144, N'catalogsettings.allowviewunpublishedproductpage', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (145, N'catalogsettings.displaydiscontinuedmessageforunpublishedproducts', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (146, N'catalogsettings.publishbackproductwhencancellingorders', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (147, N'catalogsettings.showskuonproductdetailspage', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (148, N'catalogsettings.showskuoncatalogpages', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (149, N'catalogsettings.showmanufacturerpartnumber', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (150, N'catalogsettings.showgtin', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (151, N'catalogsettings.showfreeshippingnotification', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (152, N'catalogsettings.allowproductsorting', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (153, N'catalogsettings.allowproductviewmodechanging', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (154, N'catalogsettings.defaultviewmode', N'grid', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (155, N'catalogsettings.showproductsfromsubcategories', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (156, N'catalogsettings.showcategoryproductnumber', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (157, N'catalogsettings.showcategoryproductnumberincludingsubcategories', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (158, N'catalogsettings.categorybreadcrumbenabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (159, N'catalogsettings.showsharebutton', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (160, N'catalogsettings.pagesharecode', N'<!-- AddThis Button BEGIN --><div class="addthis_toolbox addthis_default_style "><a class="addthis_button_preferred_1"></a><a class="addthis_button_preferred_2"></a><a class="addthis_button_preferred_3"></a><a class="addthis_button_preferred_4"></a><a class="addthis_button_compact"></a><a class="addthis_counter addthis_bubble_style"></a></div><script src="http://s7.addthis.com/js/250/addthis_widget.js#pubid=nopsolutions"></script><!-- AddThis Button END -->', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (161, N'catalogsettings.productreviewsmustbeapproved', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (162, N'catalogsettings.defaultproductratingvalue', N'5', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (163, N'catalogsettings.allowanonymoususerstoreviewproduct', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (164, N'catalogsettings.productreviewpossibleonlyafterpurchasing', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (165, N'catalogsettings.notifystoreowneraboutnewproductreviews', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (166, N'catalogsettings.notifycustomeraboutproductreviewreply', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (167, N'catalogsettings.showproductreviewsperstore', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (168, N'catalogsettings.showproductreviewstabonaccountpage', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (169, N'catalogsettings.productreviewspagesizeonaccountpage', N'10', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (170, N'catalogsettings.productreviewssortbycreateddateascending', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (171, N'catalogsettings.emailafriendenabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (172, N'catalogsettings.allowanonymoususerstoemailafriend', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (173, N'catalogsettings.recentlyviewedproductsnumber', N'3', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (174, N'catalogsettings.recentlyviewedproductsenabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (175, N'catalogsettings.newproductsnumber', N'6', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (176, N'catalogsettings.newproductsenabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (177, N'catalogsettings.compareproductsenabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (178, N'catalogsettings.compareproductsnumber', N'4', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (179, N'catalogsettings.productsearchautocompleteenabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (180, N'catalogsettings.productsearchautocompletenumberofproducts', N'10', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (181, N'catalogsettings.showproductimagesinsearchautocomplete', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (182, N'catalogsettings.showlinktoallresultinsearchautocomplete', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (183, N'catalogsettings.productsearchtermminimumlength', N'3', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (184, N'catalogsettings.showbestsellersonhomepage', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (185, N'catalogsettings.numberofbestsellersonhomepage', N'4', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (186, N'catalogsettings.searchpageproductsperpage', N'6', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (187, N'catalogsettings.searchpageallowcustomerstoselectpagesize', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (188, N'catalogsettings.searchpagepagesizeoptions', N'6, 3, 9, 18', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (189, N'catalogsettings.productsalsopurchasedenabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (190, N'catalogsettings.productsalsopurchasednumber', N'4', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (191, N'catalogsettings.ajaxprocessattributechange', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (192, N'catalogsettings.numberofproducttags', N'15', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (193, N'catalogsettings.productsbytagpagesize', N'6', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (194, N'catalogsettings.productsbytagallowcustomerstoselectpagesize', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (195, N'catalogsettings.productsbytagpagesizeoptions', N'6, 3, 9, 18', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (196, N'catalogsettings.includeshortdescriptionincompareproducts', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (197, N'catalogsettings.includefulldescriptionincompareproducts', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (198, N'catalogsettings.includefeaturedproductsinnormallists', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (199, N'catalogsettings.uselinksinrequiredproductwarnings', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (200, N'catalogsettings.displaytierpriceswithdiscounts', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (201, N'catalogsettings.ignorediscounts', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (202, N'catalogsettings.ignorefeaturedproducts', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (203, N'catalogsettings.ignoreacl', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (204, N'catalogsettings.ignorestorelimitations', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (205, N'catalogsettings.cacheproductprices', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (206, N'catalogsettings.maximumbackinstocksubscriptions', N'200', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (207, N'catalogsettings.manufacturersblockitemstodisplay', N'2', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (208, N'catalogsettings.displaytaxshippinginfofooter', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (209, N'catalogsettings.displaytaxshippinginfoproductdetailspage', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (210, N'catalogsettings.displaytaxshippinginfoproductboxes', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (211, N'catalogsettings.displaytaxshippinginfoshoppingcart', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (212, N'catalogsettings.displaytaxshippinginfowishlist', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (213, N'catalogsettings.displaytaxshippinginfoorderdetailspage', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (214, N'catalogsettings.defaultcategorypagesizeoptions', N'6, 3, 9', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (215, N'catalogsettings.defaultcategorypagesize', N'6', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (216, N'catalogsettings.defaultmanufacturerpagesizeoptions', N'6, 3, 9', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (217, N'catalogsettings.defaultmanufacturerpagesize', N'6', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (218, N'catalogsettings.productsortingenumdisabled', N'', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (219, N'catalogsettings.productsortingenumdisplayorder', N'', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (220, N'catalogsettings.exportimportproductattributes', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (221, N'catalogsettings.exportimportproductuselimitedtostores', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (222, N'catalogsettings.exportimportproductspecificationattributes', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (223, N'catalogsettings.exportimportusedropdownlistsforassociatedentities', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (224, N'catalogsettings.exportimportproductcategorybreadcrumb', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (225, N'catalogsettings.exportimportcategoriesusingcategoryname', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (226, N'catalogsettings.exportimportallowdownloadimages', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (227, N'catalogsettings.exportimportsplitproductsfile', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (228, N'catalogsettings.exportimportproductscountinonefile', N'500', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (229, N'catalogsettings.removerequiredproducts', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (230, N'catalogsettings.exportimportrelatedentitiesbyname', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (231, N'catalogsettings.countdisplayedyearsdatepicker', N'1', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (232, N'catalogsettings.displaydatepreorderavailability', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (233, N'catalogsettings.useajaxloadmenu', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (234, N'localizationsettings.defaultadminlanguageid', N'1', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (235, N'localizationsettings.useimagesforlanguageselection', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (236, N'localizationsettings.seofriendlyurlsforlanguagesenabled', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (237, N'localizationsettings.automaticallydetectlanguage', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (238, N'localizationsettings.loadalllocalerecordsonstartup', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (239, N'localizationsettings.loadalllocalizedpropertiesonstartup', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (240, N'localizationsettings.loadallurlrecordsonstartup', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (241, N'localizationsettings.ignorertlpropertyforadminarea', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (242, N'customersettings.usernamesenabled', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (243, N'customersettings.checkusernameavailabilityenabled', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (244, N'customersettings.allowuserstochangeusernames', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (245, N'customersettings.usernamevalidationenabled', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (246, N'customersettings.usernamevalidationuseregex', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (247, N'customersettings.usernamevalidationrule', N'', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (248, N'customersettings.defaultpasswordformat', N'Hashed', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (249, N'customersettings.hashedpasswordformat', N'SHA512', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (250, N'customersettings.passwordminlength', N'6', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (251, N'customersettings.passwordrequirelowercase', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (252, N'customersettings.passwordrequireuppercase', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (253, N'customersettings.passwordrequirenonalphanumeric', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (254, N'customersettings.passwordrequiredigit', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (255, N'customersettings.unduplicatedpasswordsnumber', N'4', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (256, N'customersettings.passwordrecoverylinkdaysvalid', N'7', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (257, N'customersettings.passwordlifetime', N'90', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (258, N'customersettings.failedpasswordallowedattempts', N'0', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (259, N'customersettings.failedpasswordlockoutminutes', N'30', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (260, N'customersettings.userregistrationtype', N'Standard', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (261, N'customersettings.allowcustomerstouploadavatars', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (262, N'customersettings.avatarmaximumsizebytes', N'20000', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (263, N'customersettings.defaultavatarenabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (264, N'customersettings.showcustomerslocation', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (265, N'customersettings.showcustomersjoindate', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (266, N'customersettings.allowviewingprofiles', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (267, N'customersettings.notifynewcustomerregistration', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (268, N'customersettings.hidedownloadableproductstab', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (269, N'customersettings.hidebackinstocksubscriptionstab', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (270, N'customersettings.downloadableproductsvalidateuser', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (271, N'customersettings.customernameformat', N'ShowFirstName', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (272, N'customersettings.newsletterenabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (273, N'customersettings.newslettertickedbydefault', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (274, N'customersettings.hidenewsletterblock', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (275, N'customersettings.newsletterblockallowtounsubscribe', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (276, N'customersettings.onlinecustomerminutes', N'20', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (277, N'customersettings.storelastvisitedpage', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (278, N'customersettings.storeipaddresses', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (279, N'customersettings.suffixdeletedcustomers', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (280, N'customersettings.enteringemailtwice', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (281, N'customersettings.requireregistrationfordownloadableproducts', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (282, N'customersettings.allowcustomerstocheckgiftcardbalance', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (283, N'customersettings.deleteguesttaskolderthanminutes', N'1440', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (284, N'customersettings.genderenabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (285, N'customersettings.dateofbirthenabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (286, N'customersettings.dateofbirthrequired', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (287, N'customersettings.dateofbirthminimumage', N'', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (288, N'customersettings.companyenabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (289, N'customersettings.companyrequired', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (290, N'customersettings.streetaddressenabled', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (291, N'customersettings.streetaddressrequired', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (292, N'customersettings.streetaddress2enabled', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (293, N'customersettings.streetaddress2required', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (294, N'customersettings.zippostalcodeenabled', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (295, N'customersettings.zippostalcoderequired', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (296, N'customersettings.cityenabled', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (297, N'customersettings.cityrequired', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (298, N'customersettings.countyenabled', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (299, N'customersettings.countyrequired', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (300, N'customersettings.countryenabled', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (301, N'customersettings.countryrequired', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (302, N'customersettings.stateprovinceenabled', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (303, N'customersettings.stateprovincerequired', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (304, N'customersettings.phoneenabled', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (305, N'customersettings.phonerequired', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (306, N'customersettings.faxenabled', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (307, N'customersettings.faxrequired', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (308, N'customersettings.acceptprivacypolicyenabled', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (309, N'addresssettings.companyenabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (310, N'addresssettings.companyrequired', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (311, N'addresssettings.streetaddressenabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (312, N'addresssettings.streetaddressrequired', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (313, N'addresssettings.streetaddress2enabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (314, N'addresssettings.streetaddress2required', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (315, N'addresssettings.zippostalcodeenabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (316, N'addresssettings.zippostalcoderequired', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (317, N'addresssettings.cityenabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (318, N'addresssettings.cityrequired', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (319, N'addresssettings.countyenabled', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (320, N'addresssettings.countyrequired', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (321, N'addresssettings.countryenabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (322, N'addresssettings.stateprovinceenabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (323, N'addresssettings.phoneenabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (324, N'addresssettings.phonerequired', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (325, N'addresssettings.faxenabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (326, N'addresssettings.faxrequired', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (327, N'addresssettings.preselectcountryifonlyone', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (328, N'mediasettings.avatarpicturesize', N'120', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (329, N'mediasettings.productthumbpicturesize', N'415', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (330, N'mediasettings.productdetailspicturesize', N'550', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (331, N'mediasettings.productthumbpicturesizeonproductdetailspage', N'100', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (332, N'mediasettings.associatedproductpicturesize', N'220', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (333, N'mediasettings.categorythumbpicturesize', N'450', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (334, N'mediasettings.manufacturerthumbpicturesize', N'420', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (335, N'mediasettings.vendorthumbpicturesize', N'450', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (336, N'mediasettings.cartthumbpicturesize', N'80', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (337, N'mediasettings.minicartthumbpicturesize', N'70', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (338, N'mediasettings.autocompletesearchthumbpicturesize', N'20', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (339, N'mediasettings.imagesquarepicturesize', N'32', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (340, N'mediasettings.defaultpicturezoomenabled', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (341, N'mediasettings.maximumimagesize', N'1980', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (342, N'mediasettings.defaultimagequality', N'80', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (343, N'mediasettings.multiplethumbdirectories', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (344, N'mediasettings.importproductimagesusinghash', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (345, N'mediasettings.azurecachecontrolheader', N'', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (346, N'mediasettings.useabsoluteimagepath', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (347, N'storeinformationsettings.hidepoweredbynopcommerce', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (348, N'storeinformationsettings.storeclosed', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (349, N'storeinformationsettings.logopictureid', N'0', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (350, N'storeinformationsettings.defaultstoretheme', N'DefaultClean', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (351, N'storeinformationsettings.allowcustomertoselecttheme', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (352, N'storeinformationsettings.displayminiprofilerinpublicstore', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (353, N'storeinformationsettings.displayminiprofilerforadminonly', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (354, N'storeinformationsettings.displayeucookielawwarning', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (355, N'storeinformationsettings.facebooklink', N'http://www.facebook.com/nopCommerce', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (356, N'storeinformationsettings.twitterlink', N'https://twitter.com/nopCommerce', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (357, N'storeinformationsettings.youtubelink', N'http://www.youtube.com/user/nopCommerce', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (358, N'externalauthenticationsettings.requireemailvalidation', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (359, N'externalauthenticationsettings.allowcustomerstoremoveassociations', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (360, N'externalauthenticationsettings.activeauthenticationmethodsystemnames', N'', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (361, N'rewardpointssettings.enabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (362, N'rewardpointssettings.exchangerate', N'1', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (363, N'rewardpointssettings.minimumrewardpointstouse', N'0', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (364, N'rewardpointssettings.maximumrewardpointstouseperorder', N'0', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (365, N'rewardpointssettings.pointsforregistration', N'0', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (366, N'rewardpointssettings.registrationpointsvalidity', N'30', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (367, N'rewardpointssettings.pointsforpurchases_amount', N'10', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (368, N'rewardpointssettings.pointsforpurchases_points', N'1', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (369, N'rewardpointssettings.purchasespointsvalidity', N'45', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (370, N'rewardpointssettings.minordertotaltoawardpoints', N'0', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (371, N'rewardpointssettings.activationdelay', N'0', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (372, N'rewardpointssettings.activationdelayperiodid', N'0', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (373, N'rewardpointssettings.displayhowmuchwillbeearned', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (374, N'rewardpointssettings.pointsaccumulatedforallstores', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (375, N'rewardpointssettings.pagesize', N'10', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (376, N'currencysettings.displaycurrencylabel', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (377, N'currencysettings.primarystorecurrencyid', N'1', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (378, N'currencysettings.primaryexchangeratecurrencyid', N'1', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (379, N'currencysettings.activeexchangerateprovidersystemname', N'CurrencyExchange.ECB', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (380, N'currencysettings.autoupdateenabled', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (381, N'measuresettings.basedimensionid', N'1', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (382, N'measuresettings.baseweightid', N'2', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (383, N'messagetemplatessettings.caseinvariantreplacement', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (384, N'messagetemplatessettings.color1', N'#b9babe', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (385, N'messagetemplatessettings.color2', N'#ebecee', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (386, N'messagetemplatessettings.color3', N'#dde2e6', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (387, N'shoppingcartsettings.displaycartafteraddingproduct', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (388, N'shoppingcartsettings.displaywishlistafteraddingproduct', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (389, N'shoppingcartsettings.maximumshoppingcartitems', N'1000', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (390, N'shoppingcartsettings.maximumwishlistitems', N'1000', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (391, N'shoppingcartsettings.allowoutofstockitemstobeaddedtowishlist', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (392, N'shoppingcartsettings.moveitemsfromwishlisttocart', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (393, N'shoppingcartsettings.cartssharedbetweenstores', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (394, N'shoppingcartsettings.showproductimagesonshoppingcart', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (395, N'shoppingcartsettings.showproductimagesonwishlist', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (396, N'shoppingcartsettings.showdiscountbox', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (397, N'shoppingcartsettings.showgiftcardbox', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (398, N'shoppingcartsettings.crosssellsnumber', N'4', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (399, N'shoppingcartsettings.emailwishlistenabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (400, N'shoppingcartsettings.allowanonymoususerstoemailwishlist', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (401, N'shoppingcartsettings.minishoppingcartenabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (402, N'shoppingcartsettings.showproductimagesinminishoppingcart', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (403, N'shoppingcartsettings.minishoppingcartproductnumber', N'5', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (404, N'shoppingcartsettings.roundpricesduringcalculation', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (405, N'shoppingcartsettings.grouptierpricesfordistinctshoppingcartitems', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (406, N'shoppingcartsettings.allowcartitemediting', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (407, N'shoppingcartsettings.renderassociatedattributevaluequantity', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (408, N'ordersettings.isreorderallowed', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (409, N'ordersettings.minordersubtotalamount', N'0', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (410, N'ordersettings.minordersubtotalamountincludingtax', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (411, N'ordersettings.minordertotalamount', N'0', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (412, N'ordersettings.autoupdateordertotalsoneditingorder', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (413, N'ordersettings.anonymouscheckoutallowed', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (414, N'ordersettings.checkoutdisabled', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (415, N'ordersettings.termsofserviceonshoppingcartpage', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (416, N'ordersettings.termsofserviceonorderconfirmpage', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (417, N'ordersettings.onepagecheckoutenabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (418, N'ordersettings.onepagecheckoutdisplayordertotalsonpaymentinfotab', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (419, N'ordersettings.disablebillingaddresscheckoutstep', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (420, N'ordersettings.disableordercompletedpage', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (421, N'ordersettings.attachpdfinvoicetoorderplacedemail', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (422, N'ordersettings.attachpdfinvoicetoorderpaidemail', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (423, N'ordersettings.attachpdfinvoicetoordercompletedemail', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (424, N'ordersettings.generatepdfinvoiceincustomerlanguage', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (425, N'ordersettings.returnrequestsenabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (426, N'ordersettings.returnrequestsallowfiles', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (427, N'ordersettings.returnrequestsfilemaximumsize', N'2048', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (428, N'ordersettings.returnrequestnumbermask', N'', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (429, N'ordersettings.numberofdaysreturnrequestavailable', N'365', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (430, N'ordersettings.activategiftcardsaftercompletingorder', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (431, N'ordersettings.deactivategiftcardsaftercancellingorder', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (432, N'ordersettings.deactivategiftcardsafterdeletingorder', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (433, N'ordersettings.minimumorderplacementinterval', N'30', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (434, N'ordersettings.completeorderwhendelivered', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (435, N'ordersettings.customordernumbermask', N'', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (436, N'ordersettings.exportwithproducts', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (437, N'ordersettings.allowadminstobuycallforpriceproducts', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (438, N'ordersettings.deletegiftcardusagehistory', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (439, N'securitysettings.forcesslforallpages', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (440, N'securitysettings.encryptionkey', N'8883890619141320', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (441, N'securitysettings.adminareaallowedipaddresses', N'', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (442, N'securitysettings.enablexsrfprotectionforadminarea', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (443, N'securitysettings.enablexsrfprotectionforpublicstore', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (444, N'securitysettings.honeypotenabled', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (445, N'securitysettings.honeypotinputname', N'hpinput', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (446, N'securitysettings.pluginstaticfileextensionsblacklist', N'', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (447, N'securitysettings.allownonasciicharactersinheaders', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (448, N'shippingsettings.activeshippingratecomputationmethodsystemnames', N'Shipping.FixedByWeightByTotal', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (449, N'shippingsettings.activepickuppointprovidersystemnames', N'Pickup.PickupInStore', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (450, N'shippingsettings.shiptosameaddress', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (451, N'shippingsettings.allowpickupinstore', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (452, N'shippingsettings.displaypickuppointsonmap', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (453, N'shippingsettings.ignoreadditionalshippingchargeforpickupinstore', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (454, N'shippingsettings.googlemapsapikey', N'', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (455, N'shippingsettings.usewarehouselocation', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (456, N'shippingsettings.notifycustomeraboutshippingfrommultiplelocations', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (457, N'shippingsettings.freeshippingoverxenabled', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (458, N'shippingsettings.freeshippingoverxvalue', N'0', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (459, N'shippingsettings.freeshippingoverxincludingtax', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (460, N'shippingsettings.estimateshippingenabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (461, N'shippingsettings.displayshipmenteventstocustomers', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (462, N'shippingsettings.displayshipmenteventstostoreowner', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (463, N'shippingsettings.hideshippingtotal', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (464, N'shippingsettings.shippingoriginaddressid', N'0', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (465, N'shippingsettings.returnvalidoptionsifthereareany', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (466, N'shippingsettings.bypassshippingmethodselectionifonlyone', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (467, N'shippingsettings.usecuberootmethod', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (468, N'shippingsettings.considerassociatedproductsdimensions', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (469, N'shippingsettings.shipseparatelyoneitemeach', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (470, N'paymentsettings.activepaymentmethodsystemnames', N'Payments.CheckMoneyOrder,Payments.Manual', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (471, N'paymentsettings.allowrepostingpayments', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (472, N'paymentsettings.bypasspaymentmethodselectionifonlyone', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (473, N'paymentsettings.showpaymentmethoddescriptions', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (474, N'paymentsettings.skippaymentinfostepforredirectionpaymentmethods', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (475, N'paymentsettings.cancelrecurringpaymentsafterfailedpayment', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (476, N'paymentsettings.regenerateorderguidinterval', N'180', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (477, N'taxsettings.taxbasedon', N'BillingAddress', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (478, N'taxsettings.taxbasedonpickuppointaddress', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (479, N'taxsettings.taxdisplaytype', N'ExcludingTax', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (480, N'taxsettings.activetaxprovidersystemname', N'Tax.FixedOrByCountryStateZip', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (481, N'taxsettings.defaulttaxaddressid', N'0', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (482, N'taxsettings.displaytaxsuffix', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (483, N'taxsettings.displaytaxrates', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (484, N'taxsettings.pricesincludetax', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (485, N'taxsettings.allowcustomerstoselecttaxdisplaytype', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (486, N'taxsettings.hidezerotax', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (487, N'taxsettings.hidetaxinordersummary', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (488, N'taxsettings.forcetaxexclusionfromordersubtotal', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (489, N'taxsettings.defaulttaxcategoryid', N'0', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (490, N'taxsettings.shippingistaxable', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (491, N'taxsettings.shippingpriceincludestax', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (492, N'taxsettings.shippingtaxclassid', N'0', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (493, N'taxsettings.paymentmethodadditionalfeeistaxable', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (494, N'taxsettings.paymentmethodadditionalfeeincludestax', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (495, N'taxsettings.paymentmethodadditionalfeetaxclassid', N'0', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (496, N'taxsettings.euvatenabled', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (497, N'taxsettings.euvatshopcountryid', N'0', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (498, N'taxsettings.euvatallowvatexemption', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (499, N'taxsettings.euvatusewebservice', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (500, N'taxsettings.euvatassumevalid', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (501, N'taxsettings.euvatemailadminwhennewvatsubmitted', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (502, N'taxsettings.logerrors', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (503, N'datetimesettings.defaultstoretimezoneid', N'', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (504, N'datetimesettings.allowcustomerstosettimezone', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (505, N'blogsettings.enabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (506, N'blogsettings.postspagesize', N'10', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (507, N'blogsettings.allownotregistereduserstoleavecomments', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (508, N'blogsettings.notifyaboutnewblogcomments', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (509, N'blogsettings.numberoftags', N'15', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (510, N'blogsettings.showheaderrssurl', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (511, N'blogsettings.blogcommentsmustbeapproved', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (512, N'blogsettings.showblogcommentsperstore', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (513, N'newssettings.enabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (514, N'newssettings.allownotregistereduserstoleavecomments', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (515, N'newssettings.notifyaboutnewnewscomments', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (516, N'newssettings.shownewsonmainpage', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (517, N'newssettings.mainpagenewscount', N'3', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (518, N'newssettings.newsarchivepagesize', N'10', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (519, N'newssettings.showheaderrssurl', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (520, N'newssettings.newscommentsmustbeapproved', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (521, N'newssettings.shownewscommentsperstore', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (522, N'forumsettings.forumsenabled', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (523, N'forumsettings.relativedatetimeformattingenabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (524, N'forumsettings.allowcustomerstoeditposts', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (525, N'forumsettings.allowcustomerstomanagesubscriptions', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (526, N'forumsettings.allowgueststocreateposts', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (527, N'forumsettings.allowgueststocreatetopics', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (528, N'forumsettings.allowcustomerstodeleteposts', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (529, N'forumsettings.allowpostvoting', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (530, N'forumsettings.maxvotesperday', N'30', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (531, N'forumsettings.topicsubjectmaxlength', N'450', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (532, N'forumsettings.strippedtopicmaxlength', N'45', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (533, N'forumsettings.postmaxlength', N'4000', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (534, N'forumsettings.topicspagesize', N'10', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (535, N'forumsettings.postspagesize', N'10', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (536, N'forumsettings.searchresultspagesize', N'10', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (537, N'forumsettings.activediscussionspagesize', N'50', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (538, N'forumsettings.latestcustomerpostspagesize', N'10', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (539, N'forumsettings.showcustomerspostcount', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (540, N'forumsettings.forumeditor', N'BBCodeEditor', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (541, N'forumsettings.signaturesenabled', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (542, N'forumsettings.allowprivatemessages', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (543, N'forumsettings.showalertforpm', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (544, N'forumsettings.privatemessagespagesize', N'10', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (545, N'forumsettings.forumsubscriptionspagesize', N'10', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (546, N'forumsettings.notifyaboutprivatemessages', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (547, N'forumsettings.pmsubjectmaxlength', N'450', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (548, N'forumsettings.pmtextmaxlength', N'4000', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (549, N'forumsettings.homepageactivediscussionstopiccount', N'5', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (550, N'forumsettings.activediscussionsfeedcount', N'25', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (551, N'forumsettings.activediscussionsfeedenabled', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (552, N'forumsettings.forumfeedsenabled', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (553, N'forumsettings.forumfeedcount', N'10', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (554, N'forumsettings.forumsearchtermminimumlength', N'3', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (555, N'vendorsettings.defaultvendorpagesizeoptions', N'6, 3, 9', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (556, N'vendorsettings.vendorsblockitemstodisplay', N'0', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (557, N'vendorsettings.showvendoronproductdetailspage', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (558, N'vendorsettings.showvendoronorderdetailspage', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (559, N'vendorsettings.allowcustomerstocontactvendors', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (560, N'vendorsettings.allowcustomerstoapplyforvendoraccount', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (561, N'vendorsettings.termsofserviceenabled', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (562, N'vendorsettings.allowsearchbyvendor', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (563, N'vendorsettings.allowvendorstoeditinfo', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (564, N'vendorsettings.notifystoreowneraboutvendorinformationchange', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (565, N'vendorsettings.maximumproductnumber', N'3000', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (566, N'vendorsettings.allowvendorstoimportproducts', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (567, N'emailaccountsettings.defaultemailaccountid', N'1', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (568, N'widgetsettings.activewidgetsystemnames', N'Widgets.NivoSlider', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (569, N'displaydefaultmenuitemsettings.displayhomepagemenuitem', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (570, N'displaydefaultmenuitemsettings.displaynewproductsmenuitem', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (571, N'displaydefaultmenuitemsettings.displayproductsearchmenuitem', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (572, N'displaydefaultmenuitemsettings.displaycustomerinfomenuitem', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (573, N'displaydefaultmenuitemsettings.displayblogmenuitem', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (574, N'displaydefaultmenuitemsettings.displayforumsmenuitem', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (575, N'displaydefaultmenuitemsettings.displaycontactusmenuitem', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (576, N'displaydefaultfooteritemsettings.displaysitemapfooteritem', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (577, N'displaydefaultfooteritemsettings.displaycontactusfooteritem', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (578, N'displaydefaultfooteritemsettings.displayproductsearchfooteritem', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (579, N'displaydefaultfooteritemsettings.displaynewsfooteritem', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (580, N'displaydefaultfooteritemsettings.displayblogfooteritem', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (581, N'displaydefaultfooteritemsettings.displayforumsfooteritem', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (582, N'displaydefaultfooteritemsettings.displayrecentlyviewedproductsfooteritem', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (583, N'displaydefaultfooteritemsettings.displaycompareproductsfooteritem', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (584, N'displaydefaultfooteritemsettings.displaynewproductsfooteritem', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (585, N'displaydefaultfooteritemsettings.displaycustomerinfofooteritem', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (586, N'displaydefaultfooteritemsettings.displaycustomerordersfooteritem', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (587, N'displaydefaultfooteritemsettings.displaycustomeraddressesfooteritem', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (588, N'displaydefaultfooteritemsettings.displayshoppingcartfooteritem', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (589, N'displaydefaultfooteritemsettings.displaywishlistfooteritem', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (590, N'displaydefaultfooteritemsettings.displayapplyvendoraccountfooteritem', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (591, N'captchasettings.enabled', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (592, N'captchasettings.showonloginpage', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (593, N'captchasettings.showonregistrationpage', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (594, N'captchasettings.showoncontactuspage', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (595, N'captchasettings.showonemailwishlisttofriendpage', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (596, N'captchasettings.showonemailproducttofriendpage', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (597, N'captchasettings.showonblogcommentpage', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (598, N'captchasettings.showonnewscommentpage', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (599, N'captchasettings.showonproductreviewpage', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (600, N'captchasettings.showonapplyvendorpage', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (601, N'captchasettings.showonforgotpasswordpage', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (602, N'captchasettings.recaptchapublickey', N'', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (603, N'captchasettings.recaptchaprivatekey', N'', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (604, N'captchasettings.recaptchatheme', N'', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (605, N'captchasettings.recaptchadefaultlanguage', N'', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (606, N'captchasettings.automaticallychooselanguage', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (607, N'messagessettings.usepopupnotifications', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (608, N'proxysettings.enabled', N'False', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (609, N'proxysettings.address', N'', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (610, N'proxysettings.port', N'', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (611, N'proxysettings.username', N'', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (612, N'proxysettings.password', N'', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (613, N'proxysettings.bypassonlocal', N'True', 0)
INSERT [Setting] ([Id], [Name], [Value], [StoreId]) VALUES (614, N'proxysettings.preauthenticate', N'True', 0)
SET IDENTITY_INSERT [Setting]  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
SET IDENTITY_INSERT [CustomerPassword] ON 

INSERT [CustomerPassword] ([Id], [CustomerId], [Password], [PasswordFormatId], [PasswordSalt], [CreatedOnUtc]) VALUES (1, 1, N'E506F2F61EA937CC0E91B6E0CEF9879BE0A401A5B601B462DA1AEA2E0D8958CA8B2A33E91A66B3B02E63E8CFADBF46D98038B926844038384812B175056702F0', 1, N'mlejm0s=', CAST(N'2019-05-27T15:28:27.8881553' AS DateTime2))
INSERT [CustomerPassword] ([Id], [CustomerId], [Password], [PasswordFormatId], [PasswordSalt], [CreatedOnUtc]) VALUES (2, 4, N'123456', 0, N'', CAST(N'2019-05-27T15:28:30.3334537' AS DateTime2))
INSERT [CustomerPassword] ([Id], [CustomerId], [Password], [PasswordFormatId], [PasswordSalt], [CreatedOnUtc]) VALUES (3, 5, N'123456', 0, N'', CAST(N'2019-05-27T15:28:30.3965342' AS DateTime2))
INSERT [CustomerPassword] ([Id], [CustomerId], [Password], [PasswordFormatId], [PasswordSalt], [CreatedOnUtc]) VALUES (4, 6, N'123456', 0, N'', CAST(N'2019-05-27T15:28:30.4524167' AS DateTime2))
INSERT [CustomerPassword] ([Id], [CustomerId], [Password], [PasswordFormatId], [PasswordSalt], [CreatedOnUtc]) VALUES (5, 7, N'123456', 0, N'', CAST(N'2019-05-27T15:28:30.5132173' AS DateTime2))
INSERT [CustomerPassword] ([Id], [CustomerId], [Password], [PasswordFormatId], [PasswordSalt], [CreatedOnUtc]) VALUES (6, 8, N'123456', 0, N'', CAST(N'2019-05-27T15:28:30.5810922' AS DateTime2))
SET IDENTITY_INSERT [CustomerPassword]  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
SET IDENTITY_INSERT [GenericAttribute] ON 

INSERT [GenericAttribute] ([Id], [EntityId], [KeyGroup], [Key], [Value], [StoreId]) VALUES (1, 1, N'Customer', N'FirstName', N'John', 0)
INSERT [GenericAttribute] ([Id], [EntityId], [KeyGroup], [Key], [Value], [StoreId]) VALUES (2, 1, N'Customer', N'LastName', N'Smith', 0)
INSERT [GenericAttribute] ([Id], [EntityId], [KeyGroup], [Key], [Value], [StoreId]) VALUES (3, 4, N'Customer', N'FirstName', N'Steve', 0)
INSERT [GenericAttribute] ([Id], [EntityId], [KeyGroup], [Key], [Value], [StoreId]) VALUES (4, 4, N'Customer', N'LastName', N'Gates', 0)
INSERT [GenericAttribute] ([Id], [EntityId], [KeyGroup], [Key], [Value], [StoreId]) VALUES (5, 5, N'Customer', N'FirstName', N'Arthur', 0)
INSERT [GenericAttribute] ([Id], [EntityId], [KeyGroup], [Key], [Value], [StoreId]) VALUES (6, 5, N'Customer', N'LastName', N'Holmes', 0)
INSERT [GenericAttribute] ([Id], [EntityId], [KeyGroup], [Key], [Value], [StoreId]) VALUES (7, 6, N'Customer', N'FirstName', N'James', 0)
INSERT [GenericAttribute] ([Id], [EntityId], [KeyGroup], [Key], [Value], [StoreId]) VALUES (8, 6, N'Customer', N'LastName', N'Pan', 0)
INSERT [GenericAttribute] ([Id], [EntityId], [KeyGroup], [Key], [Value], [StoreId]) VALUES (9, 7, N'Customer', N'FirstName', N'Brenda', 0)
INSERT [GenericAttribute] ([Id], [EntityId], [KeyGroup], [Key], [Value], [StoreId]) VALUES (10, 7, N'Customer', N'LastName', N'Lindgren', 0)
INSERT [GenericAttribute] ([Id], [EntityId], [KeyGroup], [Key], [Value], [StoreId]) VALUES (11, 8, N'Customer', N'FirstName', N'Victoria', 0)
INSERT [GenericAttribute] ([Id], [EntityId], [KeyGroup], [Key], [Value], [StoreId]) VALUES (12, 8, N'Customer', N'LastName', N'Terces', 0)
SET IDENTITY_INSERT [GenericAttribute]  OFF
GO
SET IDENTITY_INSERT [CustomerRole] ON 

INSERT [CustomerRole] ([Id], [Name], [FreeShipping], [TaxExempt], [Active], [IsSystemRole], [SystemName], [EnablePasswordLifetime], [OverrideTaxDisplayType], [DefaultTaxDisplayTypeId], [PurchasedWithProductId]) VALUES (1, N'Administrators', 0, 0, 1, 1, N'Administrators', 0, 0, 0, 0)
INSERT [CustomerRole] ([Id], [Name], [FreeShipping], [TaxExempt], [Active], [IsSystemRole], [SystemName], [EnablePasswordLifetime], [OverrideTaxDisplayType], [DefaultTaxDisplayTypeId], [PurchasedWithProductId]) VALUES (2, N'Forum Moderators', 0, 0, 1, 1, N'ForumModerators', 0, 0, 0, 0)
INSERT [CustomerRole] ([Id], [Name], [FreeShipping], [TaxExempt], [Active], [IsSystemRole], [SystemName], [EnablePasswordLifetime], [OverrideTaxDisplayType], [DefaultTaxDisplayTypeId], [PurchasedWithProductId]) VALUES (3, N'Registered', 0, 0, 1, 1, N'Registered', 0, 0, 0, 0)
INSERT [CustomerRole] ([Id], [Name], [FreeShipping], [TaxExempt], [Active], [IsSystemRole], [SystemName], [EnablePasswordLifetime], [OverrideTaxDisplayType], [DefaultTaxDisplayTypeId], [PurchasedWithProductId]) VALUES (4, N'Guests', 0, 0, 1, 1, N'Guests', 0, 0, 0, 0)
INSERT [CustomerRole] ([Id], [Name], [FreeShipping], [TaxExempt], [Active], [IsSystemRole], [SystemName], [EnablePasswordLifetime], [OverrideTaxDisplayType], [DefaultTaxDisplayTypeId], [PurchasedWithProductId]) VALUES (5, N'Vendors', 0, 0, 1, 1, N'Vendors', 0, 0, 0, 0)
SET IDENTITY_INSERT [CustomerRole]  OFF
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