/* ------------------------------------------------------------
   FILE:         C:\Inetpub\wwwroot\bvc2004\BVSQL\Populate.sql
   
   DESCRIPTION:  Insert scripts for the following table(s)/view(s):

     [dbo].[bvc_Affiliate], [dbo].[bvc_Category], [dbo].[bvc_ComponentSetting]
     [dbo].[bvc_Country], [dbo].[bvc_CustomPage], [dbo].[bvc_Discount]
     [dbo].[bvc_DiscountProduct], [dbo].[bvc_DownloadKey], [dbo].[bvc_EventLog]
     [dbo].[bvc_GiftCertificate], [dbo].[bvc_HomepageBlock], [dbo].[bvc_HomepageBlockItem]
     [dbo].[bvc_MailingList], [dbo].[bvc_MailingListMember], [dbo].[bvc_Manufacturer]
     [dbo].[bvc_Order], [dbo].[bvc_OrderCoupon], [dbo].[bvc_OrderItem]
     [dbo].[bvc_OrderItemStatus], [dbo].[bvc_OrderNote], [dbo].[bvc_OrderPayment]
     [dbo].[bvc_OrderStatus], [dbo].[bvc_Package], [dbo].[bvc_PackageXOrder]
     [dbo].[bvc_PaymentCard], [dbo].[bvc_Policy], [dbo].[bvc_PricingLevel]
     [dbo].[bvc_Product], [dbo].[bvc_ProductChoices], [dbo].[bvc_ProductChoices_Item]
     [dbo].[bvc_ProductFile], [dbo].[bvc_ProductImage], [dbo].[bvc_ProductInventory]
     [dbo].[bvc_ProductProperty], [dbo].[bvc_ProductPropertyChoice]
     [dbo].[bvc_ProductPropertyValue], [dbo].[bvc_ProductReview]
     [dbo].[bvc_ProductType], [dbo].[bvc_ProductTypeProperty], [dbo].[bvc_ProductVolumeDiscounts]
     [dbo].[bvc_ProductXCategory], [dbo].[bvc_ProductXProduct], [dbo].[bvc_ProductXProductChoices]
     [dbo].[bvc_Referral], [dbo].[bvc_Region], [dbo].[bvc_Role], [dbo].[bvc_RoleXRolePermission]
     [dbo].[bvc_Sale], [dbo].[bvc_SaleXCategory], [dbo].[bvc_SaleXProduct]
     [dbo].[bvc_SecurityToken], [dbo].[bvc_ShipMethod], [dbo].[bvc_ShipMethodTable]
     [dbo].[bvc_ShipMethodXCountry], [dbo].[bvc_ShipMethodXRegion]
     [dbo].[bvc_SiteTerm], [dbo].[bvc_Tax], [dbo].[bvc_TaxClass]
     [dbo].[bvc_User], [dbo].[bvc_UserXRole], [dbo].[bvc_Vendor]
     [dbo].[bvc_WebAppSetting], [dbo].[bvc_WishList]
   
   AUTHOR:       BVSoftware                                             
   
   CREATED:      11/1/2004 7:21:10 PM                                   
   ------------------------------------------------------------ */
   
SET NOCOUNT ON

Print 'Disabling all Constraints'
exec sp_msforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'

Print 'Disabling all Triggers'
exec sp_msforeachtable 'ALTER TABLE ? DISABLE TRIGGER ALL'

PRINT 'Deleting from table: [dbo].[bvc_WishList]'
DELETE FROM [dbo].[bvc_WishList]

PRINT 'Deleting from table: [dbo].[bvc_WebAppSetting]'
DELETE FROM [dbo].[bvc_WebAppSetting]

PRINT 'Deleting from table: [dbo].[bvc_Vendor]'
DELETE FROM [dbo].[bvc_Vendor]

PRINT 'Deleting from table: [dbo].[bvc_UserXRole]'
DELETE FROM [dbo].[bvc_UserXRole]

PRINT 'Deleting from table: [dbo].[bvc_User]'
DELETE FROM [dbo].[bvc_User]

PRINT 'Deleting from table: [dbo].[bvc_TaxClass]'
DELETE FROM [dbo].[bvc_TaxClass]

PRINT 'Deleting from table: [dbo].[bvc_Tax]'
DELETE FROM [dbo].[bvc_Tax]

PRINT 'Deleting from table: [dbo].[bvc_SiteTerm]'
DELETE FROM [dbo].[bvc_SiteTerm]

PRINT 'Deleting from table: [dbo].[bvc_ShipMethodXRegion]'
DELETE FROM [dbo].[bvc_ShipMethodXRegion]

PRINT 'Deleting from table: [dbo].[bvc_ShipMethodXCountry]'
DELETE FROM [dbo].[bvc_ShipMethodXCountry]

PRINT 'Deleting from table: [dbo].[bvc_ShipMethodTable]'
DELETE FROM [dbo].[bvc_ShipMethodTable]

PRINT 'Deleting from table: [dbo].[bvc_ShipMethod]'
DELETE FROM [dbo].[bvc_ShipMethod]

PRINT 'Deleting from table: [dbo].[bvc_SecurityToken]'
DELETE FROM [dbo].[bvc_SecurityToken]

PRINT 'Deleting from table: [dbo].[bvc_SaleXProduct]'
DELETE FROM [dbo].[bvc_SaleXProduct]

PRINT 'Deleting from table: [dbo].[bvc_SaleXCategory]'
DELETE FROM [dbo].[bvc_SaleXCategory]

PRINT 'Deleting from table: [dbo].[bvc_Sale]'
DELETE FROM [dbo].[bvc_Sale]

PRINT 'Deleting from table: [dbo].[bvc_RoleXRolePermission]'
DELETE FROM [dbo].[bvc_RoleXRolePermission]

PRINT 'Deleting from table: [dbo].[bvc_Role]'
DELETE FROM [dbo].[bvc_Role]

PRINT 'Deleting from table: [dbo].[bvc_Region]'
DELETE FROM [dbo].[bvc_Region]

PRINT 'Deleting from table: [dbo].[bvc_Referral]'
DELETE FROM [dbo].[bvc_Referral]

PRINT 'Deleting from table: [dbo].[bvc_ProductXProductChoices]'
DELETE FROM [dbo].[bvc_ProductXProductChoices]

PRINT 'Deleting from table: [dbo].[bvc_ProductXProduct]'
DELETE FROM [dbo].[bvc_ProductXProduct]

PRINT 'Deleting from table: [dbo].[bvc_ProductXCategory]'
DELETE FROM [dbo].[bvc_ProductXCategory]

PRINT 'Deleting from table: [dbo].[bvc_ProductVolumeDiscounts]'
DELETE FROM [dbo].[bvc_ProductVolumeDiscounts]

PRINT 'Deleting from table: [dbo].[bvc_ProductTypeProperty]'
DELETE FROM [dbo].[bvc_ProductTypeProperty]

PRINT 'Deleting from table: [dbo].[bvc_ProductType]'
DELETE FROM [dbo].[bvc_ProductType]

PRINT 'Deleting from table: [dbo].[bvc_ProductReview]'
DELETE FROM [dbo].[bvc_ProductReview]

PRINT 'Deleting from table: [dbo].[bvc_ProductPropertyValue]'
DELETE FROM [dbo].[bvc_ProductPropertyValue]

PRINT 'Deleting from table: [dbo].[bvc_ProductPropertyChoice]'
DELETE FROM [dbo].[bvc_ProductPropertyChoice]

PRINT 'Deleting from table: [dbo].[bvc_ProductProperty]'
DELETE FROM [dbo].[bvc_ProductProperty]

PRINT 'Deleting from table: [dbo].[bvc_ProductInventory]'
DELETE FROM [dbo].[bvc_ProductInventory]

PRINT 'Deleting from table: [dbo].[bvc_ProductImage]'
DELETE FROM [dbo].[bvc_ProductImage]

PRINT 'Deleting from table: [dbo].[bvc_ProductFile]'
DELETE FROM [dbo].[bvc_ProductFile]

PRINT 'Deleting from table: [dbo].[bvc_ProductChoices_Item]'
DELETE FROM [dbo].[bvc_ProductChoices_Item]

PRINT 'Deleting from table: [dbo].[bvc_ProductChoices]'
DELETE FROM [dbo].[bvc_ProductChoices]

PRINT 'Deleting from table: [dbo].[bvc_Product]'
DELETE FROM [dbo].[bvc_Product]

PRINT 'Deleting from table: [dbo].[bvc_PricingLevel]'
DELETE FROM [dbo].[bvc_PricingLevel]

PRINT 'Deleting from table: [dbo].[bvc_Policy]'
DELETE FROM [dbo].[bvc_Policy]

PRINT 'Deleting from table: [dbo].[bvc_PaymentCard]'
DELETE FROM [dbo].[bvc_PaymentCard]

PRINT 'Deleting from table: [dbo].[bvc_PackageXOrder]'
DELETE FROM [dbo].[bvc_PackageXOrder]

PRINT 'Deleting from table: [dbo].[bvc_Package]'
DELETE FROM [dbo].[bvc_Package]

PRINT 'Deleting from table: [dbo].[bvc_OrderStatus]'
DELETE FROM [dbo].[bvc_OrderStatus]

PRINT 'Deleting from table: [dbo].[bvc_OrderPayment]'
DELETE FROM [dbo].[bvc_OrderPayment]

PRINT 'Deleting from table: [dbo].[bvc_OrderNote]'
DELETE FROM [dbo].[bvc_OrderNote]

PRINT 'Deleting from table: [dbo].[bvc_OrderItemStatus]'
DELETE FROM [dbo].[bvc_OrderItemStatus]

PRINT 'Deleting from table: [dbo].[bvc_OrderItem]'
DELETE FROM [dbo].[bvc_OrderItem]

PRINT 'Deleting from table: [dbo].[bvc_OrderCoupon]'
DELETE FROM [dbo].[bvc_OrderCoupon]

PRINT 'Deleting from table: [dbo].[bvc_Order]'
DELETE FROM [dbo].[bvc_Order]

PRINT 'Deleting from table: [dbo].[bvc_Manufacturer]'
DELETE FROM [dbo].[bvc_Manufacturer]

PRINT 'Deleting from table: [dbo].[bvc_MailingListMember]'
DELETE FROM [dbo].[bvc_MailingListMember]

PRINT 'Deleting from table: [dbo].[bvc_MailingList]'
DELETE FROM [dbo].[bvc_MailingList]

PRINT 'Deleting from table: [dbo].[bvc_HomepageBlockItem]'
DELETE FROM [dbo].[bvc_HomepageBlockItem]

PRINT 'Deleting from table: [dbo].[bvc_HomepageBlock]'
DELETE FROM [dbo].[bvc_HomepageBlock]

PRINT 'Deleting from table: [dbo].[bvc_GiftCertificate]'
DELETE FROM [dbo].[bvc_GiftCertificate]

PRINT 'Deleting from table: [dbo].[bvc_EventLog]'
DELETE FROM [dbo].[bvc_EventLog]

PRINT 'Deleting from table: [dbo].[bvc_DownloadKey]'
DELETE FROM [dbo].[bvc_DownloadKey]

PRINT 'Deleting from table: [dbo].[bvc_DiscountProduct]'
DELETE FROM [dbo].[bvc_DiscountProduct]

PRINT 'Deleting from table: [dbo].[bvc_Discount]'
DELETE FROM [dbo].[bvc_Discount]

PRINT 'Deleting from table: [dbo].[bvc_CustomPage]'
DELETE FROM [dbo].[bvc_CustomPage]

PRINT 'Deleting from table: [dbo].[bvc_Country]'
DELETE FROM [dbo].[bvc_Country]

PRINT 'Deleting from table: [dbo].[bvc_ComponentSetting]'
DELETE FROM [dbo].[bvc_ComponentSetting]

PRINT 'Deleting from table: [dbo].[bvc_Category]'
DELETE FROM [dbo].[bvc_Category]

PRINT 'Deleting from table: [dbo].[bvc_Affiliate]'
DELETE FROM [dbo].[bvc_Affiliate]

/* No records are in [dbo].[bvc_Affiliate] */

/* No records are in [dbo].[bvc_Category] */

/* No fields selected for scripting in [dbo].[bvc_ComponentSetting] */

/* Insert scripts for table: [dbo].[bvc_Country] */
PRINT 'Inserting rows into table: [dbo].[bvc_Country]'

INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('ar-AE', 'U.A.E.', 0, 'AE')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('ar-BH', 'Bahrain', 0, 'BH')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('ar-DZ', 'Algeria', 0, 'DZ')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('ar-EG', 'Egypt', 0, 'EG')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('ar-IQ', 'Iraq', 0, 'IQ')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('ar-JO', 'Jordan', 0, 'JO')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('ar-KW', 'Kuwait', 0, 'KW')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('ar-LB', 'Lebanon', 0, 'LB')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('ar-LY', 'Libya', 0, 'LY')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('ar-MA', 'Morocco', 0, 'MA')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('ar-OM', 'Oman', 0, 'OM')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('ar-QA', 'Qatar', 0, 'QA')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('ar-SA', 'Saudi Arabia', 0, 'SA')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('ar-SY', 'Syrian Arab Republic', 0, 'SY')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('ar-TN', 'Tunisia', 0, 'TN')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('ar-YE', 'Yemen', 0, 'YE')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('az-AZ-Latn', 'Azerbaijan', 0, 'AZ')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('be-BY', 'Belarus', 0, 'BY')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('bg-BG', 'Bulgaria', 0, 'BG')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('cs-CZ', 'Czech Republic', 0, 'CZ')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('da-DK', 'Denmark', 0, 'DK')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('de-AT', 'Austria', 0, 'AT')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('de-DE', 'Germany', 0, 'DE')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('de-LI', 'Liechtenstein', 0, 'LI')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('div-MV', 'Maldives', 0, 'MV')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('el-GR', 'Greece', 0, 'GR')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('en-AU', 'Australia', 0, 'AU')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('en-BZ', 'Belize', 0, 'BZ')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('en-CA', 'Canada', 1, 'CA')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('en-CB', 'Caribbean', 0, 'CB')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('en-GB', 'United Kingdom', 1, 'GB')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('en-IE', 'Ireland', 0, 'IE')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('en-JM', 'Jamaica', 0, 'JM')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('en-NZ', 'New Zealand', 0, 'NZ')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('en-PH', 'Philippines', 0, 'PH')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('en-TT', 'Trinidad and Tobago', 0, 'TT')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('en-US', 'United States', 1, 'US')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('en-ZA', 'South Africa', 0, 'ZA')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('en-ZW', 'Zimbabwe', 0, 'ZW')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('es-AR', 'Argentina', 0, 'AR')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('es-BO', 'Bolivia', 0, 'BO')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('es-CL', 'Chile', 0, 'CL')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('es-CO', 'Colombia', 0, 'CO')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('es-CR', 'Costa Rica', 0, 'CR')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('es-DO', 'Dominican Republic', 0, 'DO')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('es-EC', 'Ecuador', 0, 'EC')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('es-ES', 'Spain', 1, 'ES')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('es-GT', 'Guatemala', 0, 'GT')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('es-HN', 'Honduras', 0, 'ZZ')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('es-MX', 'Mexico', 0, 'MX')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('es-NI', 'Nicaragua', 0, 'NI')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('es-PA', 'Panama', 0, 'PA')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('es-PE', 'Peru', 0, 'PE')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('es-PR', 'Puerto Rico', 1, 'PR')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('es-PY', 'Paraguay', 0, 'PY')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('es-SV', 'El Salvador', 0, 'SV')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('es-UY', 'Uruguay', 0, 'UY')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('es-VE', 'Venezuela', 0, 'VE')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('et-EE', 'Estonia', 0, 'EE')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('fa-IR', 'Iran', 0, 'IR')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('fi-FI', 'Finland', 0, 'FI')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('fo-FO', 'Faroe Islands', 0, 'FO')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('fr-BE', 'Belgium', 0, 'BE')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('fr-CH', 'Switzerland', 0, 'CH')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('fr-FR', 'France', 0, 'FR')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('fr-LU', 'Luxembourg', 0, 'LU')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('fr-MC', 'Monaco', 0, 'MC')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('he-IL', 'Israel', 0, 'IL')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('hi-IN', 'India', 0, 'IN')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('hr-HR', 'Croatia', 0, 'HR')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('hu-HU', 'Hungary', 0, 'HU')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('hy-AM', 'Armenia', 0, 'AM')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('id-ID', 'Indonesia', 0, 'ID')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('is-IS', 'Iceland', 0, 'IS')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('it-IT', 'Italy', 0, 'IT')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('ja-JP', 'Japan', 0, 'JP')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('ka-GE', 'Georgia', 0, 'GE')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('kk-KZ', 'Kazakhstan', 0, 'KZ')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('ko-KR', 'Korea', 0, 'KR')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('lt-LT', 'Lithuania', 0, 'LT')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('lv-LV', 'Latvia', 0, 'LV')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('mk-MK', 'Macedonia', 0, 'MK')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('mn-MN', 'Mongolia', 0, 'MN')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('ms-BN', 'Brunei Darussalam', 0, 'BN')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('ms-MY', 'Malaysia', 0, 'MY')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('nb-NO', 'Norway', 0, 'NO')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('nl-NL', 'Netherlands', 0, 'NL')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('pl-PL', 'Poland', 0, 'PL')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('pt-BR', 'Brazil', 0, 'BR')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('pt-PT', 'Portugal', 0, 'PT')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('ro-RO', 'Romania', 0, 'RO')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('ru-RU', 'Russia', 0, 'RU')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('sk-SK', 'Slovakia', 0, 'SK')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('sl-SI', 'Slovenia', 0, 'SI')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('sq-AL', 'Albania', 0, 'AL')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('sr-SP-Latn', 'Serbia', 0, 'SP')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('sv-SE', 'Sweden', 0, 'SE')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('sw-KE', 'Kenya', 0, 'KE')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('th-TH', 'Thailand', 0, 'TH')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('tr-TR', 'Turkey', 0, 'TR')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('uk-UA', 'Ukraine', 0, 'UA')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('ur-PK', 'Pakistan', 0, 'PK')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('uz-UZ-Latn', 'Uzbekistan', 0, 'UZ')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('vi-VN', 'Viet Nam', 0, 'VN')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('zh-CN', 'China', 0, 'CN')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('zh-HK', 'Hong Kong', 0, 'HK')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('zh-MO', 'Macau', 0, 'MO')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('zh-SG', 'Singapore', 0, 'SG')
INSERT INTO [dbo].[bvc_Country] ([Code], [DisplayName], [Active], [UPSCode]) VALUES ('zh-TW', 'Taiwan', 0, 'TW')

/* No records are in [dbo].[bvc_CustomPage] */

/* No records are in [dbo].[bvc_Discount] */

/* No records are in [dbo].[bvc_DiscountProduct] */

/* No records are in [dbo].[bvc_DownloadKey] */

/* No records are in [dbo].[bvc_EventLog] */

/* No records are in [dbo].[bvc_GiftCertificate] */

/* Insert scripts for table: [dbo].[bvc_HomepageBlock] */
PRINT 'Inserting rows into table: [dbo].[bvc_HomepageBlock]'

SET IDENTITY_INSERT [dbo].[bvc_HomepageBlock] ON

INSERT INTO [dbo].[bvc_HomepageBlock] ([ID], [ColumnNumber], [SortOrder], [BlockType], [BlockContent]) VALUES (6, 3, 3, 1, N'1')
INSERT INTO [dbo].[bvc_HomepageBlock] ([ID], [ColumnNumber], [SortOrder], [BlockType], [BlockContent]) VALUES (38, 1, 6, 7, N'2')
INSERT INTO [dbo].[bvc_HomepageBlock] ([ID], [ColumnNumber], [SortOrder], [BlockType], [BlockContent]) VALUES (43, 3, 2, 6, N'1')
INSERT INTO [dbo].[bvc_HomepageBlock] ([ID], [ColumnNumber], [SortOrder], [BlockType], [BlockContent]) VALUES (56, 5, 2, 7, N'2')
INSERT INTO [dbo].[bvc_HomepageBlock] ([ID], [ColumnNumber], [SortOrder], [BlockType], [BlockContent]) VALUES (57, 4, 2, 7, N'2')
INSERT INTO [dbo].[bvc_HomepageBlock] ([ID], [ColumnNumber], [SortOrder], [BlockType], [BlockContent]) VALUES (60, 4, 1, 9, N'2')
INSERT INTO [dbo].[bvc_HomepageBlock] ([ID], [ColumnNumber], [SortOrder], [BlockType], [BlockContent]) VALUES (61, 1, 4, 9, N'2')
INSERT INTO [dbo].[bvc_HomepageBlock] ([ID], [ColumnNumber], [SortOrder], [BlockType], [BlockContent]) VALUES (62, 5, 1, 9, N'2')
INSERT INTO [dbo].[bvc_HomepageBlock] ([ID], [ColumnNumber], [SortOrder], [BlockType], [BlockContent]) VALUES (63, 2, 2, 1, N'2')
INSERT INTO [dbo].[bvc_HomepageBlock] ([ID], [ColumnNumber], [SortOrder], [BlockType], [BlockContent]) VALUES (64, 2, 5, 1, N'2')

SET IDENTITY_INSERT [dbo].[bvc_HomepageBlock] OFF


/* Insert scripts for table: [dbo].[bvc_HomepageBlockItem] */
PRINT 'Inserting rows into table: [dbo].[bvc_HomepageBlockItem]'

SET IDENTITY_INSERT [dbo].[bvc_HomepageBlockItem] ON

INSERT INTO [dbo].[bvc_HomepageBlockItem] ([ID], [SortOrder], [ItemContent], [BlockID]) VALUES (17, 1, N'<span class="BVText">&nbsp;<br><i>&quot;Sample Quote Number One!&quot;</i><br>-Anonymous<br>&nbsp;</span>', 6)
INSERT INTO [dbo].[bvc_HomepageBlockItem] ([ID], [SortOrder], [ItemContent], [BlockID]) VALUES (18, 2, N'<span class="BVText">&nbsp;<br><i>&quot;Sample Quote Number Two!&quot;</i><br>-Anonymous<br>&nbsp;</span>', 6)
INSERT INTO [dbo].[bvc_HomepageBlockItem] ([ID], [SortOrder], [ItemContent], [BlockID]) VALUES (92, 1, N'<div id="HomepageSample1"></div>', 63)
INSERT INTO [dbo].[bvc_HomepageBlockItem] ([ID], [SortOrder], [ItemContent], [BlockID]) VALUES (93, 1, N'<div id="HomePageSample2">This is a sample content block. You can remove this block and the one above it if you wish. Both samples are given as examples of how to use the CSS files and images to make theme specific areas.</div>', 64)
INSERT INTO [dbo].[bvc_HomepageBlockItem] ([ID], [SortOrder], [ItemContent], [BlockID]) VALUES (97, 3, N'<span class="BVText">&nbsp;<br><i>&quot;Sample Quote Number Three!&quot;</i><br>-Anonymous<br>&nbsp;</span>', 6)

SET IDENTITY_INSERT [dbo].[bvc_HomepageBlockItem] OFF


/* Insert scripts for table: [dbo].[bvc_MailingList] */
PRINT 'Inserting rows into table: [dbo].[bvc_MailingList]'

SET IDENTITY_INSERT [dbo].[bvc_MailingList] ON

INSERT INTO [dbo].[bvc_MailingList] ([ID], [Name], [Private]) VALUES (1, N'Store Mailing List', 0)

SET IDENTITY_INSERT [dbo].[bvc_MailingList] OFF


/* No records are in [dbo].[bvc_MailingListMember] */

/* No records are in [dbo].[bvc_Manufacturer] */

/* No records are in [dbo].[bvc_Order] */

/* No records are in [dbo].[bvc_OrderCoupon] */

/* No records are in [dbo].[bvc_OrderItem] */

/* Insert scripts for table: [dbo].[bvc_OrderItemStatus] */
PRINT 'Inserting rows into table: [dbo].[bvc_OrderItemStatus]'

INSERT INTO [dbo].[bvc_OrderItemStatus] ([id], [name]) VALUES (-1, N'Canceled')
INSERT INTO [dbo].[bvc_OrderItemStatus] ([id], [name]) VALUES (1, N'In Process')
INSERT INTO [dbo].[bvc_OrderItemStatus] ([id], [name]) VALUES (2, N'Shipped')
INSERT INTO [dbo].[bvc_OrderItemStatus] ([id], [name]) VALUES (3, N'Back Ordered')

/* No records are in [dbo].[bvc_OrderNote] */

/* No records are in [dbo].[bvc_OrderPayment] */

/* Insert scripts for table: [dbo].[bvc_OrderStatus] */
PRINT 'Inserting rows into table: [dbo].[bvc_OrderStatus]'

INSERT INTO [dbo].[bvc_OrderStatus] ([ID], [Name]) VALUES (-1, N'Canceled')
INSERT INTO [dbo].[bvc_OrderStatus] ([ID], [Name]) VALUES (1, N'Shopping Cart')
INSERT INTO [dbo].[bvc_OrderStatus] ([ID], [Name]) VALUES (2, N'In Process')
INSERT INTO [dbo].[bvc_OrderStatus] ([ID], [Name]) VALUES (3, N'Completed')

/* No records are in [dbo].[bvc_Package] */

/* No records are in [dbo].[bvc_PackageXOrder] */

/* Insert scripts for table: [dbo].[bvc_PaymentCard] */
PRINT 'Inserting rows into table: [dbo].[bvc_PaymentCard]'

SET IDENTITY_INSERT [dbo].[bvc_PaymentCard] ON

INSERT INTO [dbo].[bvc_PaymentCard] ([ID], [Active], [Name], [Code]) VALUES (1, 1, N'American Express', N'4')
INSERT INTO [dbo].[bvc_PaymentCard] ([ID], [Active], [Name], [Code]) VALUES (2, 1, N'Visa', N'1')
INSERT INTO [dbo].[bvc_PaymentCard] ([ID], [Active], [Name], [Code]) VALUES (3, 1, N'MasterCard', N'2')
INSERT INTO [dbo].[bvc_PaymentCard] ([ID], [Active], [Name], [Code]) VALUES (4, 1, N'Discover', N'3')
INSERT INTO [dbo].[bvc_PaymentCard] ([ID], [Active], [Name], [Code]) VALUES (5, 0, N'Diner''s Club', N'5')
INSERT INTO [dbo].[bvc_PaymentCard] ([ID], [Active], [Name], [Code]) VALUES (6, 0, N'JCB (Japanese Credit Bureau)', N'6')

SET IDENTITY_INSERT [dbo].[bvc_PaymentCard] OFF


/* Insert scripts for table: [dbo].[bvc_Policy] */
PRINT 'Inserting rows into table: [dbo].[bvc_Policy]'

SET IDENTITY_INSERT [dbo].[bvc_Policy] ON

INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (51, N'Collection of Information', N'<P>We collect personally identifiable information, like names, postal addresses, email addresses, etc., when voluntarily submitted by our visitors. The information you provide is used to fulfill your specific request. This information is only used to fulfill your specific request, unless you give us permission to use it in another manner, for example to add you to one of our mailing lists.</P>', 1, 3)
INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (54, N'Distribution of Information', N'<P>We may share information with governmental agencies or other companies assisting us in fraud prevention or investigation. We may do so when: (1) permitted or required by law; or, (2) trying to protect against or prevent actual or potential fraud or unauthorized transactions; or, (3) investigating fraud which has already taken place. The information is not provided to these companies for marketing purposes.</P>', 1, 5)
INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (55, N'Commitment to Data Security', N'<P>Your personally identifiable information is kept secure. Only authorized employees, agents and contractors (who have agreed to keep information secure and confidential) have access to this information. All emails and newsletters from this site allow you to opt out of further mailings.</P>', 1, 8)
INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (57, N'Privacy Contact information', N'<P>If you have any questions, concerns, or comments about our privacy policy you may contact us using the information below:</P>
<UL>
<LI>By E-Mail: xxxxxx@xxxxxx.xxx 
<LI>By Phone: xxx-xxx-xxxx</LI></UL>', 1, 9)
INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (76, N'How can I contact you?', N'Click on the Contact Us button in the main menu', 2, 1)
INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (80, N'', N'<P>Thank you for visiting our web site. This privacy policy tells you how we use personal information collected at this site. Please read this privacy policy before using the site or submitting any personal information. By using the site, you are accepting the practices described in this privacy policy. These practices may be changed, but any changes will be posted and changes will only apply to activities and information on a going forward, not retroactive basis. You are encouraged to review the privacy policy whenever you visit the site to make sure that you understand how any personal information you provide will be used. </P>
<P>Note, the privacy practices set forth in this privacy policy are for this web site only. If you link to other web sites, please review the privacy policies posted at those sites.</P>', 1, 1)
INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (81, N'Cookie/Tracking Technology', N'<P>The Site may use cookie and tracking technology depending on the features offered. Cookie and tracking technology are useful for gathering information such as browser type and operating system, tracking the number of visitors to the Site, and understanding how visitors use the Site. Cookies can also help customize the Site for visitors. Personal information cannot be collected via cookies and other tracking technology, however, if you previously provided personally identifiable information, cookies may be tied to such information. Aggregate cookie and tracking information may be shared with third parties.</P>', 1, 4)
INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (82, N'', N'<P>We reserve the right to make changes to this policy. Any changes to this policy will be posted.</P>', 1, 11)
INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (100, N'BVC 2004', N'<BR>&nbsp; This is a<FONT size=4> </FONT><EM><FONT size=4>test</FONT> </EM>release of <STRONG><FONT color=#808000><U>BV Commerce 3<BR><BR></U></FONT><FONT style="BACKGROUND-COLOR: #ffffff" face="Courier New" color=red size=3>NDA RESTRICTIONS APPLY</FONT></STRONG>', 5, 1)
INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (101, N'Welcome to your account', N'<p>Your account lets you track your orders, change your password and e-mail address and manage your address book. You can also easily jump to your shopping cart or logout.</p>', 6, 1)
INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (117, N'Terms And Conditions', N'<P>By visiting or shopping at this web site, you accept the following terms and conditions. Please read them carefully.</P>
<H3>Copyright</H3>
<P>All content included on this site, such as text, graphics, logos, button icons, images, audio clips, digital downloads, data compilations, and software, is the property of this site''s owner or its content suppliers and protected by United States and international copyright laws. The compilation of all content on this site is the exclusive property of this site''s owner and protected by U.S. and international copyright laws. All software used on this site is the property of this site''s owner or its software suppliers and protected by United States and international copyright laws.</P>
<H3>Disclaimer of Warranties and Limitation of Liability</H3>
<P>THIS SITE IS PROVIDED ON AN "AS IS" AND "AS AVAILABLE" BASIS. NO REPRESENTATIONS OR WARRANTIES OF ANY KIND ARE MADE, EXPRESS OR IMPLIED, AS TO THE OPERATION OF THIS SITE OR THE INFORMATION, CONTENT, MATERIALS, OR PRODUCTS INCLUDED ON THIS SITE. YOU EXPRESSLY AGREE THAT YOUR USE OF THIS SITE IS AT YOUR SOLE RISK.</P>
<P>TO THE FULL EXTENT PERMISSIBLE BY APPLICABLE LAW, THIS SITE''S OWNER DISCLAIMS ALL WARRANTIES, EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THIS SITE''S OWNER DOES NOT WARRANT THAT THIS SITE, ITS SERVERS, OR E-MAIL SENT FROM THIS SITE ARE FREE OF VIRUSES OR OTHER HARMFUL COMPONENTS. THIS SITE''S OWNER WILL NOT BE LIABLE FOR ANY DAMAGES OF ANY KIND ARISING FROM THE USE OF THIS SITE, INCLUDING, BUT NOT LIMITED TO DIRECT, INDIRECT, INCIDENTAL, PUNITIVE, AND CONSEQUENTIAL DAMAGES. </P>
<P>CERTAIN STATE LAWS DO NOT ALLOW LIMITATIONS ON IMPLIED WARRANTIES OR THE EXCLUSION OR LIMITATION OF CERTAIN DAMAGES. IF THESE LAWS APPLY TO YOU, SOME OR ALL OF THE ABOVE DISCLAIMERS, EXCLUSIONS, OR LIMITATIONS MAY NOT APPLY TO YOU, AND YOU MIGHT HAVE ADDITIONAL RIGHTS. </P>', 7, 1)
INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (118, N'', N'Business hours are M-F 9am through 5pm Eastern Standard Time.', 8, 1)
INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (125, N'Customer Service', N'Customer Service Content Here', 9, 1)
INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (126, N'Affilate Program Terms', N'As an affiliate you agree to...<br>
&nbsp;<br>', 100, 1)
INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (128, N'Affiliate Intoduction', N'Our affiliate is a great way to...<br>
&nbsp;<br>', 101, 1)
INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (129, N'EmailReceiptBody', N'<html>
 <head>
 <meta name=vs_targetSchema content="http://schemas.microsoft.com/intellisense/ie5">
<style type="text/css"> A { text-decoration: none; }
	A:link { color: #3366cc; text-decoration: none; }
	A:visited { color: #663399; text-decoration: none; }
	A:active { color: #cccccc; text-decoration: none; }
	A:Hover { text-decoration: underline; }
	BODY, TD, CENTER, P { font-family: Geneva, Verdana, Arial, Helvetica; font-size: 10px; color: #333333; }
	.body { font-family: Geneva, Verdana, Arial, Helvetica; font-size: 10px; color: #333333; }
	.content { font-family: Arial, Helvetica, sans-serif; font-size: 11px; font-weight: normal; color: #000000; }
	.title { font-family: Helvetica, Arial, sans-serif; font-size: 10px; font-weight: normal; color: #000000; }
	.headline { font-family: Helvetica, Arial, sans-serif; font-size: 14px; font-weight: bold; color: #000000; }
	.message { font-family: Geneva, Verdana, Arial, Helvetica; font-size: 9px; }
	</style>
 </head>
<body bgcolor="#ffffff" LINK="#3366cc" VLINK="#3366cc" ALINK="#3366cc" LEFTMARGIN="0" TOPMARGIN="0">
	<table cellSpacing=1 cellPadding=3 width="100%" border="0" runat="server">
	<tr>
		<td colSpan=2><IMG src="[[logo]]" border=0></td>
	</tr>
	<tr>
		<td class=FormLabel colSpan=2>
                <hr>
                [[downloadinfo]]&nbsp;
		</td>
	</tr>
	<TR>
		<TD class=FormLabel vAlign=top align=left width="50%">
		<b>Billed To:</b><br>
		[[billingaddress]]<br>
		[[username]]
		</TD>
		<TD class=FormLabel vAlign=top align=left width="50%">
			<b>Order Number:</b> [[ordernumber]]<BR>
			<b>Order Time:</b> [[timeoforder]]<br>
			<b>Current Status:</b> [[status]]&nbsp;<BR>
			<b>Payment Method:</b> [[paymentmethod]]&nbsp;<br>
			<b>Promotional Code(s):</b> [[coupons]]&nbsp;<br>
			<b>Special Instructions:</b> [[specialinstructions]]&nbsp;<br>			
		</TD>		
	</TR>
	<tr>
		<td colspan="2">
			<table border="0" cellspacing="0" cellpadding="5" width="100%">
			<tr>
				<td colspan="4"><hr></td>
			</tr>
			<tr>
                                <td><b>Qty</b></td>
				<td><b>SKU</b></td>
				<td><b>Product Name</b></td>
				<td align="right"><b>Unit Price</b></td>
			</tr>
			<tr>
				<td colspan="4"><hr></td>
			</tr>
			[[items]]
			<tr>
				<td colspan="4"><hr></td>
			</tr>
			<tr>
				<td colspan="4" align="right">
					<table border="0" cellspacing="0" cellpadding="3">
					<TR>
							<TD vAlign=top align=left>SubTotal:</TD>
							<TD vAlign=top align=right>[[subtotal]] </TD></TR>
						<TR>
							<TD  vAlign=top align=left>Tax: </TD>
							<TD  vAlign=top align=right>[[taxtotal]] </TD></TR>
						<TR>
							<TD  vAlign=top align=left>Shipping:</TD>
							<TD  vAlign=top align=right>[[shippingtotal]] </TD></TR>
						<TR>
							<TD  vAlign=top align=left>Handling: </TD>
							<TD  vAlign=top align=right>[[handlingtotal]] </TD></TR>
						<TR>
							<TD  vAlign=top align=left>Gift Wrap: </TD>
							<TD  vAlign=top align=right>[[giftwraptotal]] </TD></TR>
						<TR>
							<TD  vAlign=top align=left><B>Grand Total:</B> </TD>
							<TD  vAlign=top align=right>[[grandtotal]] </TD>
						</TR>
					</table>
				</td>
			</tr>
			<tr>
				<td colspan="4"><hr></td>
			</tr>
		</table>
		<!--<TABLE cellSpacing=1 cellPadding=3 width="100%" border=0 ID="Table1">
			<TR>
				<TD class=Header>Item</TD></TR>
			<TR>
				<TD class=ContentCell>[[items]]</TD></TR></TBODY></TABLE></TD></TR>
			<TR>
				<TD class="" vAlign=top align=right colSpan=3>
					<TABLE id=Table2 cellSpacing=0 cellPadding=5 border=0>						
						<TR>
							<TD class=FormLabel vAlign=top align=left><B>SubTotal</B> </TD>
							<TD class=FormLabel vAlign=top align=right>[[subtotal]] </TD></TR>
						<TR>
							<TD class=FormLabel vAlign=top align=left><B>Tax</B> </TD>
							<TD class=FormLabel vAlign=top align=right>[[taxtotal]] </TD></TR>
						<TR>
							<TD class=FormLabel vAlign=top align=left><B>Shipping</B> </TD>
							<TD class=FormLabel vAlign=top align=right>[[shippingtotal]] </TD></TR>
						<TR>
							<TD class=FormLabel vAlign=top align=left><B>Handling</B> </TD>
							<TD class=FormLabel vAlign=top align=right>[[handlingtotal]] </TD></TR>
						<TR>
							<TD class=FormLabel vAlign=top align=left>&nbsp; </TD>
							<TD class=FormLabel vAlign=top align=right>
						<HR noShade>
						</TD></TR>
						<TR>
							<TD class=FormLabel vAlign=top align=left><B>Grand Total:</B> </TD>
							<TD class=FormLabel vAlign=top align=right>[[grandtotal]] </TD>
						</TR>
					</TABLE>
				</TD>
			</TR>
			</TBODY>
			</TABLE>-->		
		</td>
	</tr>
	<tr>
		<td colspan="2"><b>Please retain for your records.</b></td>
	</tr>						
</table>
</body>
</html>
', 200, 1)
INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (130, N'EmailReceiptDownload', N'<TABLE cellSpacing=0 cellPadding=5 width="100%" border=0>
<TR>
  <TD vAlign=top align=left>Your order contains electronic downloads. After your payment has been processed you can download your file(s) by clicking <A href="[[downloadlink]]">here</A>. <BR>&nbsp;<BR>
For your reference, your download key is <A href="[[downloadlink]]">[[downloadkey]]</A></TD>
</TR>
</TABLE>', 201, 1)
INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (131, N'EmailReceiptItems', N'<tr>
				<td align=left valign=top>[[item_qty]]</td>
				<td align=left valign=top>[[item_sku]]</td>
				<td align=left valign=top>[[item_name]]<br>[[item_status]]<br>[[item_attributes]]</td>
				<td align=right valign=top>[[item_price]]</td>
			</tr>
', 202, 1)
INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (132, N'EmailUpdateBody', N'<html>
 <head>
 <meta name=vs_targetSchema content="http://schemas.microsoft.com/intellisense/ie5">
<style type="text/css"> A { text-decoration: none; }
	A:link { color: #3366cc; text-decoration: none; }
	A:visited { color: #663399; text-decoration: none; }
	A:active { color: #cccccc; text-decoration: none; }
	A:Hover { text-decoration: underline; }
	BODY, TD, CENTER, P { font-family: Geneva, Verdana, Arial, Helvetica; font-size: 10px; color: #333333; }
	.body { font-family: Geneva, Verdana, Arial, Helvetica; font-size: 10px; color: #333333; }
	.content { font-family: Arial, Helvetica, sans-serif; font-size: 11px; font-weight: normal; color: #000000; }
	.title { font-family: Helvetica, Arial, sans-serif; font-size: 10px; font-weight: normal; color: #000000; }
	.headline { font-family: Helvetica, Arial, sans-serif; font-size: 14px; font-weight: bold; color: #000000; }
	.message { font-family: Geneva, Verdana, Arial, Helvetica; font-size: 9px; }
	</style>
 </head>
<body bgcolor="#ffffff" LINK="#3366cc" VLINK="#3366cc" ALINK="#3366cc" LEFTMARGIN="0" TOPMARGIN="0">
	<table cellSpacing=1 cellPadding=3 width="100%" border="0" runat="server">
	<tr>
		<td colSpan=2><IMG src="[[logo]]" border=0></td>
	</tr>
	<tr>
		<td class=FormLabel colSpan=2>
                <hr>
                [[downloadinfo]]&nbsp;
		</td>
	</tr>
	<TR>
		<TD class=FormLabel vAlign=top align=left width="50%">
		<b>Billed To:</b><br>
		[[billingaddress]]<br>
		[[username]]
		</TD>
		<TD class=FormLabel vAlign=top align=left width="50%">
			<b>Order Number:</b> [[ordernumber]]<BR>
			<b>Order Time:</b> [[timeoforder]]<br>
			<b>Current Status:</b> [[status]]&nbsp;<BR>
			<b>Payment Method:</b> [[paymentmethod]]&nbsp;<br>
			<b>Promotional Code(s):</b> [[coupons]]&nbsp;<br>
			<b>Special Instructions:</b> [[specialinstructions]]&nbsp;<br>			
		</TD>		
	</TR>
	<tr>
		<td colspan="2">
			<table border="0" cellspacing="0" cellpadding="5" width="100%">
			<tr>
				<td colspan="4"><hr></td>
			</tr>
			<tr>
                                <td><b>Qty</b></td>
				<td><b>SKU</b></td>
				<td><b>Product Name</b></td>
				<td align="right"><b>Unit Price</b></td>
			</tr>
			<tr>
				<td colspan="4"><hr></td>
			</tr>
			[[items]]
			<tr>
				<td colspan="4"><hr></td>
			</tr>
			<tr>
				<td colspan="4" align="right">
					<table border="0" cellspacing="0" cellpadding="3">
					<TR>
							<TD vAlign=top align=left>SubTotal:</TD>
							<TD vAlign=top align=right>[[subtotal]] </TD></TR>
						<TR>
							<TD  vAlign=top align=left>Tax: </TD>
							<TD  vAlign=top align=right>[[taxtotal]] </TD></TR>
						<TR>
							<TD  vAlign=top align=left>Shipping:</TD>
							<TD  vAlign=top align=right>[[shippingtotal]] </TD></TR>
						<TR>
							<TD  vAlign=top align=left>Handling: </TD>
							<TD  vAlign=top align=right>[[handlingtotal]] </TD></TR>
						<TR>
							<TD  vAlign=top align=left>Gift Wrap: </TD>
							<TD  vAlign=top align=right>[[giftwraptotal]] </TD></TR>
						<TR>
							<TD  vAlign=top align=left><B>Grand Total:</B> </TD>
							<TD  vAlign=top align=right>[[grandtotal]] </TD>
						</TR>
					</table>
				</td>
			</tr>
			<tr>
				<td colspan="4"><hr></td>
			</tr>
		</table>			
		</td>
	</tr>
	<tr>
		<td colspan="2"><b>Please retain for your records.</b></td>
	</tr>						
</table>
</body>
</html>
', 300, 1)
INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (133, N'EmailUpdateDownload', N'<TABLE cellSpacing=0 cellPadding=5 width="100%" border=0>
<TR>
  <TD vAlign=top align=left>Your order contains electronic downloads. After your payment has been processed you can download your file(s) by clicking <A href="[[downloadlink]]">here</A>. <BR>&nbsp;<BR>
For your reference, your download key is <A href="[[downloadlink]]">[[downloadkey]]</A></TD>
</TR>
</TABLE>', 301, 1)
INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (134, N'EmailUpdateItems', N'			<tr>
				<td align=left valign=top>[[item_qty]]</td>
				<td align=left valign=top>[[item_sku]]</td>
				<td align=left valign=top>[[item_name]]<br>[[item_status]]<br>[[item_attributes]]</td>
				<td align=right valign=top>[[item_price]]</td>
			</tr>
', 302, 1)
INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (135, N'EmailAdminReceiptBody', N'<html>
 <head>
 <meta name=vs_targetSchema content="http://schemas.microsoft.com/intellisense/ie5">
<style type="text/css"> A { text-decoration: none; }
	A:link { color: #3366cc; text-decoration: none; }
	A:visited { color: #663399; text-decoration: none; }
	A:active { color: #cccccc; text-decoration: none; }
	A:Hover { text-decoration: underline; }
	BODY, TD, CENTER, P { font-family: Geneva, Verdana, Arial, Helvetica; font-size: 10px; color: #333333; }
	.body { font-family: Geneva, Verdana, Arial, Helvetica; font-size: 10px; color: #333333; }
	.content { font-family: Arial, Helvetica, sans-serif; font-size: 11px; font-weight: normal; color: #000000; }
	.title { font-family: Helvetica, Arial, sans-serif; font-size: 10px; font-weight: normal; color: #000000; }
	.headline { font-family: Helvetica, Arial, sans-serif; font-size: 14px; font-weight: bold; color: #000000; }
	.message { font-family: Geneva, Verdana, Arial, Helvetica; font-size: 9px; }
	</style>
 </head>
<body bgcolor="#ffffff" LINK="#3366cc" VLINK="#3366cc" ALINK="#3366cc" LEFTMARGIN="0" TOPMARGIN="0">
	<table cellSpacing=1 cellPadding=3 width="100%" border="0" runat="server">
	<tr>
		<td colSpan=2><IMG src="[[logo]]" border=0></td>
	</tr>
	<tr>
		<td class=FormLabel colSpan=2>
                <hr><a href=[[adminlink]]>View Order Details</a><br>
                [[downloadinfo]]&nbsp;
		</td>
	</tr>
	<TR>
		<TD class=FormLabel vAlign=top align=left width="50%">
		<b>Billed To:</b><br>
		[[billingaddress]]<br>
		[[username]]
		</TD>
		<TD class=FormLabel vAlign=top align=left width="50%">
			<b>Order Number:</b> [[ordernumber]]<BR>
			<b>Order Time:</b> [[timeoforder]]<br>
			<b>Current Status:</b> [[status]]&nbsp;<BR>
			<b>Payment Method:</b> [[paymentmethod]]&nbsp;<br>
			<b>Promotional Code(s):</b> [[coupons]]&nbsp;<br>
			<b>Special Instructions:</b> [[specialinstructions]]&nbsp;<br>			
		</TD>		
	</TR>
	<tr>
		<td colspan="2">
			<table border="0" cellspacing="0" cellpadding="5" width="100%">
			<tr>
				<td colspan="4"><hr></td>
			</tr>
			<tr>
                                <td><b>Qty</b></td>
				<td><b>SKU</b></td>
				<td><b>Product Name</b></td>
				<td align="right"><b>Unit Price</b></td>
			</tr>
			<tr>
				<td colspan="4"><hr></td>
			</tr>
			[[items]]
			<tr>
				<td colspan="4"><hr></td>
			</tr>
			<tr>
				<td colspan="4" align="right">
					<table border="0" cellspacing="0" cellpadding="3">
					<TR>
							<TD vAlign=top align=left>SubTotal:</TD>
							<TD vAlign=top align=right>[[subtotal]] </TD></TR>
						<TR>
							<TD  vAlign=top align=left>Tax: </TD>
							<TD  vAlign=top align=right>[[taxtotal]] </TD></TR>
						<TR>
							<TD  vAlign=top align=left>Shipping:</TD>
							<TD  vAlign=top align=right>[[shippingtotal]] </TD></TR>
						<TR>
							<TD  vAlign=top align=left>Handling: </TD>
							<TD  vAlign=top align=right>[[handlingtotal]] </TD></TR>
						<TR>
							<TD  vAlign=top align=left>Gift Wrap: </TD>
							<TD  vAlign=top align=right>[[giftwraptotal]] </TD></TR>
						<TR>
							<TD  vAlign=top align=left><B>Grand Total:</B> </TD>
							<TD  vAlign=top align=right>[[grandtotal]] </TD>
						</TR>
					</table>
				</td>
			</tr>
			<tr>
				<td colspan="4"><hr></td>
			</tr>
		</table>			
		</td>
	</tr>
	<tr>
		<td colspan="2"><b>Please retain for your records.</b></td>
	</tr>						
</table>
</body>
</html>
', 400, 1)
INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (136, N'EmailAdminReceiptDownload', N'<TABLE cellSpacing=0 cellPadding=5 width="100%" border=0>
<TR>
  <TD vAlign=top align=left>Your order contains electronic downloads. After your payment has been processed you can download your file(s) by clicking <A href="[[downloadlink]]">here</A>. <BR>&nbsp;<BR>
For your reference, your download key is <A href="[[downloadlink]]">[[downloadkey]]</A></TD>
</TR>
</TABLE>', 401, 1)
INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (137, N'EmailAdminReceiptItems', N'			<tr>
				<td align=left valign=top>[[item_qty]]</td>
				<td align=left valign=top>[[item_sku]]</td>
				<td align=left valign=top>[[item_name]]<br>[[item_status]]<br>[[item_attributes]]</td>
				<td align=right valign=top>[[item_price]]</td>
			</tr>
', 402, 1)
INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (138, N'EmailAdminForgotPasswordBody', N'<font face="Arial">Your password has been reset.</font><br />&nbsp;<br /><font face="Arial">Username: <strong>[[username]] <br /></strong>Password: <strong>[[newpassword]] <br /></strong><br />You can login with your new information here: [[loginpage]] [[timestamp]]</font>', 500, 1)
INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (139, N'ReturnFormIntro', N'<p>
To return an item please fill out this form completely.
</p>', 900, 1)
INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (140, N'ReturnFormPolicy', N'<ul><li>Items must be returned within 15 days of receipt.</li><li>Returned items may be subject to a restocking fee.</li><li>All items must be returned in the original containers.</li></ul>', 910, 1)
INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (141, N'ReturnFormComplete', N'<p>Thank you. Your request has been received. If you have any other questions please contact our customer service center.</p>', 920, 1)
INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (142, N'Shipping Policy', N'<p>All shipping charges are estimated. Actual shipping charges may vary.</p>', 3, 1)
INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (143, N'Return Policy', N'All returns are subject to approval by a store manager.', 4, 1)
INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (144, N'EmailDropShipperBody', N'<html>
 <head>
 <meta name=vs_targetSchema content="http://schemas.microsoft.com/intellisense/ie5">
<style type="text/css"> A { text-decoration: none; }
	A:link { color: #3366cc; text-decoration: none; }
	A:visited { color: #663399; text-decoration: none; }
	A:active { color: #cccccc; text-decoration: none; }
	A:Hover { text-decoration: underline; }
	BODY, TD, CENTER, P { font-family: Geneva, Verdana, Arial, Helvetica; font-size: 10px; color: #333333; }
	.body { font-family: Geneva, Verdana, Arial, Helvetica; font-size: 10px; color: #333333; }
	.content { font-family: Arial, Helvetica, sans-serif; font-size: 11px; font-weight: normal; color: #000000; }
	.title { font-family: Helvetica, Arial, sans-serif; font-size: 10px; font-weight: normal; color: #000000; }
	.headline { font-family: Helvetica, Arial, sans-serif; font-size: 14px; font-weight: bold; color: #000000; }
	.message { font-family: Geneva, Verdana, Arial, Helvetica; font-size: 9px; }
	</style>
 </head>
<body bgcolor="#ffffff" LINK="#3366cc" VLINK="#3366cc" ALINK="#3366cc" LEFTMARGIN="0" TOPMARGIN="0">
	<table cellSpacing=1 cellPadding=3 width="100%" border="0" runat="server">
	<tr>
		<td colSpan=2><IMG src="[[logo]]" border=0></td>
	</tr>
		<TR>
		<TD class=FormLabel vAlign=top align=left width="50%">
		<b>Billed To:</b><br>
		[[billingaddress]]<br>
		[[username]]
		</TD>
		<TD class=FormLabel vAlign=top align=left width="50%">
			<b>Order Number:</b> [[ordernumber]]<BR>
			<b>Order Time:</b> [[timeoforder]]<br>
			<b>Current Status:</b> [[status]]&nbsp;<BR>
			<b>Special Instructions:</b> [[specialinstructions]]&nbsp;<br>
					</TD>		
	</TR>
	<tr>
		<td colspan="2">
			<table border="0" cellspacing="0" cellpadding="5" width="100%">
			<tr>
				<td colspan="3"><hr></td>
			</tr>
			<tr>
                                <td><b>Qty</b></td>
				<td><b>SKU</b></td>
				<td><b>Product Name</b></td>
			</tr>
			<tr>
				<td colspan="3"><hr></td>
			</tr>
			[[items]]
			<tr>
				<td colspan="3"><hr></td>
			</tr>
		</table>
				
		</td>
	</tr>
	<tr>
		<td colspan="2"><b>Please retain for your records.</b></td>
	</tr>						
</table>
</body>
</html>
', 600, 1)
INSERT INTO [dbo].[bvc_Policy] ([ID], [Name], [Description], [Type], [SortOrder]) VALUES (145, N'EmailDropShipperItems', N'<tr>
				<td align=left valign=top>[[item_qty]]</td>
				<td align=left valign=top>[[item_sku]]</td>
				<td align=left valign=top>[[item_name]]<br>[[item_status]]<br>[[item_attributes]]</td>			
</tr>
', 601, 1)

SET IDENTITY_INSERT [dbo].[bvc_Policy] OFF


/* Insert scripts for table: [dbo].[bvc_PricingLevel] */
PRINT 'Inserting rows into table: [dbo].[bvc_PricingLevel]'

INSERT INTO [dbo].[bvc_PricingLevel] ([PricingLevel], [PricingType], [Amount]) VALUES (1, 6, 0)
INSERT INTO [dbo].[bvc_PricingLevel] ([PricingLevel], [PricingType], [Amount]) VALUES (2, 6, 0)
INSERT INTO [dbo].[bvc_PricingLevel] ([PricingLevel], [PricingType], [Amount]) VALUES (3, 6, 0)
INSERT INTO [dbo].[bvc_PricingLevel] ([PricingLevel], [PricingType], [Amount]) VALUES (4, 6, 0)
INSERT INTO [dbo].[bvc_PricingLevel] ([PricingLevel], [PricingType], [Amount]) VALUES (5, 6, 0)
INSERT INTO [dbo].[bvc_PricingLevel] ([PricingLevel], [PricingType], [Amount]) VALUES (6, 6, 0)
INSERT INTO [dbo].[bvc_PricingLevel] ([PricingLevel], [PricingType], [Amount]) VALUES (7, 6, 0)
INSERT INTO [dbo].[bvc_PricingLevel] ([PricingLevel], [PricingType], [Amount]) VALUES (8, 6, 0)
INSERT INTO [dbo].[bvc_PricingLevel] ([PricingLevel], [PricingType], [Amount]) VALUES (9, 6, 0)
INSERT INTO [dbo].[bvc_PricingLevel] ([PricingLevel], [PricingType], [Amount]) VALUES (10, 6, 0)

/* No records are in [dbo].[bvc_Product] */

/* No records are in [dbo].[bvc_ProductChoices] */

/* No records are in [dbo].[bvc_ProductChoices_Item] */

/* No records are in [dbo].[bvc_ProductFile] */

/* No records are in [dbo].[bvc_ProductImage] */

/* No records are in [dbo].[bvc_ProductInventory] */

/* Insert scripts for table: [dbo].[bvc_ProductProperty] */
PRINT 'Inserting rows into table: [dbo].[bvc_ProductProperty]'

SET IDENTITY_INSERT [dbo].[bvc_ProductProperty] ON

INSERT INTO [dbo].[bvc_ProductProperty] ([ID], [PropertyName], [DisplayName], [DisplayOnSite], [DisplayToDropShipper], [TypeCode], [DefaultValue], [CultureCode]) VALUES (577, N'Artist', N'Artist:', 1, 1, 1, N'', 'en-US')
INSERT INTO [dbo].[bvc_ProductProperty] ([ID], [PropertyName], [DisplayName], [DisplayOnSite], [DisplayToDropShipper], [TypeCode], [DefaultValue], [CultureCode]) VALUES (578, N'Author', N'Author:', 1, 0, 1, N'', 'en-US')
INSERT INTO [dbo].[bvc_ProductProperty] ([ID], [PropertyName], [DisplayName], [DisplayOnSite], [DisplayToDropShipper], [TypeCode], [DefaultValue], [CultureCode]) VALUES (579, N'Book Publisher', N'Publishing House:', 1, 0, 2, N'139', 'en-US')
INSERT INTO [dbo].[bvc_ProductProperty] ([ID], [PropertyName], [DisplayName], [DisplayOnSite], [DisplayToDropShipper], [TypeCode], [DefaultValue], [CultureCode]) VALUES (580, N'Book Title', N'Title:', 1, 0, 1, N'', 'en-US')
INSERT INTO [dbo].[bvc_ProductProperty] ([ID], [PropertyName], [DisplayName], [DisplayOnSite], [DisplayToDropShipper], [TypeCode], [DefaultValue], [CultureCode]) VALUES (581, N'ISBN', N'ISBN:', 1, 1, 1, N'', 'en-US')
INSERT INTO [dbo].[bvc_ProductProperty] ([ID], [PropertyName], [DisplayName], [DisplayOnSite], [DisplayToDropShipper], [TypeCode], [DefaultValue], [CultureCode]) VALUES (582, N'Publication Date', N'Publication Date:', 1, 0, 4, N'1/27/2004', 'en-US')
INSERT INTO [dbo].[bvc_ProductProperty] ([ID], [PropertyName], [DisplayName], [DisplayOnSite], [DisplayToDropShipper], [TypeCode], [DefaultValue], [CultureCode]) VALUES (583, N'Record Label', N'Record Label:', 1, 0, 1, N'', 'en-US')
INSERT INTO [dbo].[bvc_ProductProperty] ([ID], [PropertyName], [DisplayName], [DisplayOnSite], [DisplayToDropShipper], [TypeCode], [DefaultValue], [CultureCode]) VALUES (584, N'SerialNumber', N'SerialNumber', 0, 0, 1, N'0', 'en-US')
INSERT INTO [dbo].[bvc_ProductProperty] ([ID], [PropertyName], [DisplayName], [DisplayOnSite], [DisplayToDropShipper], [TypeCode], [DefaultValue], [CultureCode]) VALUES (585, N'Shipper''s Part Number', N'Shipper Part Number', 0, 1, 1, N'', 'en-US')
INSERT INTO [dbo].[bvc_ProductProperty] ([ID], [PropertyName], [DisplayName], [DisplayOnSite], [DisplayToDropShipper], [TypeCode], [DefaultValue], [CultureCode]) VALUES (586, N'Shipping Time', N'Availability:', 1, 0, 2, N'198', 'en-US')
INSERT INTO [dbo].[bvc_ProductProperty] ([ID], [PropertyName], [DisplayName], [DisplayOnSite], [DisplayToDropShipper], [TypeCode], [DefaultValue], [CultureCode]) VALUES (587, N'Tracks', N'Tracks:', 1, 0, 1, N'<ul>
<li>Track 1</li>
<li>Track 2</li>
</ul>', 'en-US')
INSERT INTO [dbo].[bvc_ProductProperty] ([ID], [PropertyName], [DisplayName], [DisplayOnSite], [DisplayToDropShipper], [TypeCode], [DefaultValue], [CultureCode]) VALUES (588, N'UK Price', N'UK Price:', 1, 0, 3, N'', 'en-GB')

SET IDENTITY_INSERT [dbo].[bvc_ProductProperty] OFF


/* Insert scripts for table: [dbo].[bvc_ProductPropertyChoice] */
PRINT 'Inserting rows into table: [dbo].[bvc_ProductPropertyChoice]'

SET IDENTITY_INSERT [dbo].[bvc_ProductPropertyChoice] ON

INSERT INTO [dbo].[bvc_ProductPropertyChoice] ([ID], [PropertyID], [ChoiceName], [SortOrder]) VALUES (521, 579, N'Random House', 1)
INSERT INTO [dbo].[bvc_ProductPropertyChoice] ([ID], [PropertyID], [ChoiceName], [SortOrder]) VALUES (522, 579, N'Bantam Books', 2)
INSERT INTO [dbo].[bvc_ProductPropertyChoice] ([ID], [PropertyID], [ChoiceName], [SortOrder]) VALUES (523, 586, N'Usually Ships within 24 hours', 1)
INSERT INTO [dbo].[bvc_ProductPropertyChoice] ([ID], [PropertyID], [ChoiceName], [SortOrder]) VALUES (524, 586, N'Ships in 2 to 3 days', 2)
INSERT INTO [dbo].[bvc_ProductPropertyChoice] ([ID], [PropertyID], [ChoiceName], [SortOrder]) VALUES (525, 586, N'Ships in 5 to 7 days', 3)
INSERT INTO [dbo].[bvc_ProductPropertyChoice] ([ID], [PropertyID], [ChoiceName], [SortOrder]) VALUES (526, 586, N'1 to 2 weeks', 4)
INSERT INTO [dbo].[bvc_ProductPropertyChoice] ([ID], [PropertyID], [ChoiceName], [SortOrder]) VALUES (527, 586, N'Backordered', 5)
INSERT INTO [dbo].[bvc_ProductPropertyChoice] ([ID], [PropertyID], [ChoiceName], [SortOrder]) VALUES (528, 586, N'Immediate Electronic Download', 6)

SET IDENTITY_INSERT [dbo].[bvc_ProductPropertyChoice] OFF


/* No records are in [dbo].[bvc_ProductPropertyValue] */

/* No records are in [dbo].[bvc_ProductReview] */

/* Insert scripts for table: [dbo].[bvc_ProductType] */
PRINT 'Inserting rows into table: [dbo].[bvc_ProductType]'

SET IDENTITY_INSERT [dbo].[bvc_ProductType] ON

INSERT INTO [dbo].[bvc_ProductType] ([ID], [ProductTypeName]) VALUES (-100, N'Amazon.com Product')
INSERT INTO [dbo].[bvc_ProductType] ([ID], [ProductTypeName]) VALUES (168, N'Generic Product')
INSERT INTO [dbo].[bvc_ProductType] ([ID], [ProductTypeName]) VALUES (177, N'Book')
INSERT INTO [dbo].[bvc_ProductType] ([ID], [ProductTypeName]) VALUES (178, N'CD')

SET IDENTITY_INSERT [dbo].[bvc_ProductType] OFF


/* Insert scripts for table: [dbo].[bvc_ProductTypeProperty] */
PRINT 'Inserting rows into table: [dbo].[bvc_ProductTypeProperty]'

INSERT INTO [dbo].[bvc_ProductTypeProperty] ([ProductTypeID], [ProductPropertyID], [SortOrder]) VALUES (177, 578, 2)
INSERT INTO [dbo].[bvc_ProductTypeProperty] ([ProductTypeID], [ProductPropertyID], [SortOrder]) VALUES (177, 579, 3)
INSERT INTO [dbo].[bvc_ProductTypeProperty] ([ProductTypeID], [ProductPropertyID], [SortOrder]) VALUES (177, 580, 1)
INSERT INTO [dbo].[bvc_ProductTypeProperty] ([ProductTypeID], [ProductPropertyID], [SortOrder]) VALUES (177, 582, 4)
INSERT INTO [dbo].[bvc_ProductTypeProperty] ([ProductTypeID], [ProductPropertyID], [SortOrder]) VALUES (177, 581, 5)
INSERT INTO [dbo].[bvc_ProductTypeProperty] ([ProductTypeID], [ProductPropertyID], [SortOrder]) VALUES (178, 577, 1)
INSERT INTO [dbo].[bvc_ProductTypeProperty] ([ProductTypeID], [ProductPropertyID], [SortOrder]) VALUES (178, 583, 2)
INSERT INTO [dbo].[bvc_ProductTypeProperty] ([ProductTypeID], [ProductPropertyID], [SortOrder]) VALUES (178, 587, 3)
INSERT INTO [dbo].[bvc_ProductTypeProperty] ([ProductTypeID], [ProductPropertyID], [SortOrder]) VALUES (178, 588, 4)

/* No records are in [dbo].[bvc_ProductVolumeDiscounts] */

/* No records are in [dbo].[bvc_ProductXCategory] */

/* No records are in [dbo].[bvc_ProductXProduct] */

/* No records are in [dbo].[bvc_ProductXProductChoices] */

/* No records are in [dbo].[bvc_Referral] */

/* Insert scripts for table: [dbo].[bvc_Region] */
PRINT 'Inserting rows into table: [dbo].[bvc_Region]'

SET IDENTITY_INSERT [dbo].[bvc_Region] ON

INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (1, N'Alabama', N'AL', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (2, N'Alaska', N'AK', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (3, N'Arizona', N'AZ', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (4, N'Arkansas', N'AR', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (5, N'California', N'CA', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (6, N'Colorado', N'CO', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (7, N'Connecticut', N'CT', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (8, N'Delaware', N'DE', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (9, N'District Of Columbia', N'DC', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (10, N'Florida', N'FL', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (11, N'Georgia', N'GA', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (12, N'Hawaii', N'HI', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (13, N'Idaho', N'ID', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (14, N'Iowa', N'IA', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (15, N'Kansas', N'KS', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (16, N'Kentucky', N'KY', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (17, N'Louisiana', N'LA', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (18, N'Maine', N'ME', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (19, N'Maryland', N'MD', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (20, N'Massachusetts', N'MA', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (21, N'Michigan', N'MI', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (22, N'Minnesota', N'MN', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (23, N'Mississippi', N'MS', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (24, N'Missouri', N'MO', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (25, N'Montana', N'MT', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (26, N'Nebraska', N'NE', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (27, N'Nevada', N'NV', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (28, N'New Hampshire', N'NH', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (29, N'New Jersey', N'NJ', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (30, N'New Mexico', N'NM', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (31, N'New York', N'NY', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (32, N'North Carolina', N'NC', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (33, N'North Dakota', N'ND', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (34, N'Ohio', N'OH', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (35, N'Oklahoma', N'OK', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (36, N'Pennsylvania', N'PA', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (37, N'Illinois', N'IL', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (38, N'Indiana', N'IN', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (39, N'Oregon', N'OR', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (40, N'Rhode Island', N'RI', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (41, N'South Carolina', N'SC', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (42, N'South Dakota', N'SD', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (43, N'Tennessee', N'TN', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (44, N'Texas', N'TX', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (45, N'Utah', N'UT', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (46, N'Vermont', N'VT', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (47, N'Virginia', N'VA', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (48, N'Washington', N'WA', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (49, N'West Virginia', N'WV', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (50, N'Wisconsin', N'WI', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (51, N'Wyoming', N'WY', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (92, N'Alberta', N'', N'en-CA')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (93, N'British Columbia', N'', N'en-CA')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (94, N'Manitoba', N'', N'en-CA')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (95, N'New Brunswick', N'', N'en-CA')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (96, N'Newfoundland', N'', N'en-CA')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (97, N'Northwest Territories', N'', N'en-CA')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (98, N'Nova Scotia', N'', N'en-CA')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (99, N'Nunavut', N'', N'en-CA')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (100, N'Ontario', N'', N'en-CA')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (101, N'Prince Edward Island', N'', N'en-CA')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (102, N'Quebec', N'', N'en-CA')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (103, N'Saskatchewan', N'', N'en-CA')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (104, N'Yukon Territory', N'', N'en-CA')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (105, N'U.S. Virgin Islands', N'VI', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (106, N'Armed Forces Africa', N'AE', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (107, N'Armed Forces Americas', N'AA', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (108, N'Armed Forces Canada', N'AE', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (109, N'Armed Forces Europe', N'AE', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (110, N'Armed Forces Middle', N'AE', N'en-US')
INSERT INTO [dbo].[bvc_Region] ([ID], [Name], [Abbreviation], [CountryCode]) VALUES (111, N'Armed Forces Pacific', N'AP', N'en-US')

SET IDENTITY_INSERT [dbo].[bvc_Region] OFF


/* Insert scripts for table: [dbo].[bvc_Role] */
PRINT 'Inserting rows into table: [dbo].[bvc_Role]'

INSERT INTO [dbo].[bvc_Role] ([RoleName]) VALUES (N'Administrator')
INSERT INTO [dbo].[bvc_Role] ([RoleName]) VALUES (N'Content Admin')
INSERT INTO [dbo].[bvc_Role] ([RoleName]) VALUES (N'Order Admin')
INSERT INTO [dbo].[bvc_Role] ([RoleName]) VALUES (N'People Admin')
INSERT INTO [dbo].[bvc_Role] ([RoleName]) VALUES (N'Product Admin')
INSERT INTO [dbo].[bvc_Role] ([RoleName]) VALUES (N'Report Users')
INSERT INTO [dbo].[bvc_Role] ([RoleName]) VALUES (N'Settings Admin')
INSERT INTO [dbo].[bvc_Role] ([RoleName]) VALUES (N'Web Services Access')

/* Insert scripts for table: [dbo].[bvc_RoleXRolePermission] */
PRINT 'Inserting rows into table: [dbo].[bvc_RoleXRolePermission]'

INSERT INTO [dbo].[bvc_RoleXRolePermission] ([RoleName], [PermissionID]) VALUES (N'Administrator', 1)
INSERT INTO [dbo].[bvc_RoleXRolePermission] ([RoleName], [PermissionID]) VALUES (N'Administrator', 2)
INSERT INTO [dbo].[bvc_RoleXRolePermission] ([RoleName], [PermissionID]) VALUES (N'Administrator', 1000)
INSERT INTO [dbo].[bvc_RoleXRolePermission] ([RoleName], [PermissionID]) VALUES (N'Administrator', 2000)
INSERT INTO [dbo].[bvc_RoleXRolePermission] ([RoleName], [PermissionID]) VALUES (N'Administrator', 3000)
INSERT INTO [dbo].[bvc_RoleXRolePermission] ([RoleName], [PermissionID]) VALUES (N'Administrator', 4000)
INSERT INTO [dbo].[bvc_RoleXRolePermission] ([RoleName], [PermissionID]) VALUES (N'Administrator', 5000)
INSERT INTO [dbo].[bvc_RoleXRolePermission] ([RoleName], [PermissionID]) VALUES (N'Administrator', 6000)
INSERT INTO [dbo].[bvc_RoleXRolePermission] ([RoleName], [PermissionID]) VALUES (N'Content Admin', 1)
INSERT INTO [dbo].[bvc_RoleXRolePermission] ([RoleName], [PermissionID]) VALUES (N'Content Admin', 5000)
INSERT INTO [dbo].[bvc_RoleXRolePermission] ([RoleName], [PermissionID]) VALUES (N'Order Admin', 1)
INSERT INTO [dbo].[bvc_RoleXRolePermission] ([RoleName], [PermissionID]) VALUES (N'Order Admin', 3000)
INSERT INTO [dbo].[bvc_RoleXRolePermission] ([RoleName], [PermissionID]) VALUES (N'People Admin', 1)
INSERT INTO [dbo].[bvc_RoleXRolePermission] ([RoleName], [PermissionID]) VALUES (N'People Admin', 2000)
INSERT INTO [dbo].[bvc_RoleXRolePermission] ([RoleName], [PermissionID]) VALUES (N'Product Admin', 1)
INSERT INTO [dbo].[bvc_RoleXRolePermission] ([RoleName], [PermissionID]) VALUES (N'Product Admin', 1000)
INSERT INTO [dbo].[bvc_RoleXRolePermission] ([RoleName], [PermissionID]) VALUES (N'Report Users', 1)
INSERT INTO [dbo].[bvc_RoleXRolePermission] ([RoleName], [PermissionID]) VALUES (N'Report Users', 4000)
INSERT INTO [dbo].[bvc_RoleXRolePermission] ([RoleName], [PermissionID]) VALUES (N'Settings Admin', 1)
INSERT INTO [dbo].[bvc_RoleXRolePermission] ([RoleName], [PermissionID]) VALUES (N'Settings Admin', 6000)
INSERT INTO [dbo].[bvc_RoleXRolePermission] ([RoleName], [PermissionID]) VALUES (N'Web Services Access', 2)

/* No records are in [dbo].[bvc_Sale] */

/* No records are in [dbo].[bvc_SaleXCategory] */

/* No records are in [dbo].[bvc_SaleXProduct] */

/* No records are in [dbo].[bvc_SecurityToken] */

/* Insert scripts for table: [dbo].[bvc_ShipMethod] */
PRINT 'Inserting rows into table: [dbo].[bvc_ShipMethod]'

SET IDENTITY_INSERT [dbo].[bvc_ShipMethod] ON

INSERT INTO [dbo].[bvc_ShipMethod] ([ID], [Name], [Type], [Adjustment], [AdjustmentType]) VALUES (93, N'Per Item', 1300,  0, 1)

SET IDENTITY_INSERT [dbo].[bvc_ShipMethod] OFF


/* Insert scripts for table: [dbo].[bvc_ShipMethodTable] */
PRINT 'Inserting rows into table: [dbo].[bvc_ShipMethodTable]'

SET IDENTITY_INSERT [dbo].[bvc_ShipMethodTable] ON

INSERT INTO [dbo].[bvc_ShipMethodTable] ([ID], [MethodID], [Total], [Charge]) VALUES (48, 93,  0,  1.25)

SET IDENTITY_INSERT [dbo].[bvc_ShipMethodTable] OFF


/* No records are in [dbo].[bvc_ShipMethodXCountry] */

/* No records are in [dbo].[bvc_ShipMethodXRegion] */

/* Insert scripts for table: [dbo].[bvc_SiteTerm] */
PRINT 'Inserting rows into table: [dbo].[bvc_SiteTerm]'

INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'AddressBook', N'Address Book')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'AverageRating', N'Average Rating')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'Categories', N'Categories')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'Category', N'Category')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'ChangeEmail', N'Change Email')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'ChangePassword', N'Change Password')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'Checkout', N'Checkout')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'ConfirmNewPassword', N'Confirm New Password')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'ConfirmNewUsername', N'Confirm New Email Address')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'ConfirmPassword', N'Confirm Password')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'ContactUs', N'Contact Us')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'CreateANewAccount', N'Create New Account')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'CustomerReviews', N'Customer Reviews')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'CustomerService', N'Customer Service')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'DownloadFiles', N'Download Files')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'EmptyCart', N'Your Cart is Empty')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'ForgotPassword', N'Forgot Password')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'Help', N'Help')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'Home', N'Home')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'ImageExtensionError', N'Images must be .jpg .gif or .png')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'ItemFound', N'item found')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'ItemsFound', N'items found')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'ListPrice', N'List Price')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'Login', N'Sign In')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'Logout', N'Sign Out')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'MailingList', N'Mailing List')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'MailingLists', N'Mailing Lists')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'MakeAnyChangesAbove', N'Make any changes above?')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'MyAccount', N'Your Account')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'NewPassword', N'New Password')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'NewUsername', N'New Email Address')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'OrderHistory', N'Order History')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'Page', N'Page')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'Password', N'Password')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'PrivacyPolicy', N'Privacy Policy')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'Product', N'Product')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'Products', N'Products')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'RelatedItems', N'You may also like...')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'Search', N'Search')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'ShoppingCart', N'Shopping Cart')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'SitePrice', N'Your Price')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'SKU', N'SKU')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'TermsAndConditions', N'Terms and Conditions')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'Themes', N'Themes')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'Username', N'Email Address')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'ViewAll', N'&nbsp;View All')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'ViewByPages', N'View By Pages')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'ViewCart', N'View Cart')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'WasThisReviewHelpful', N'Was this review helpful?')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'WishList', N'Wish List')
INSERT INTO [dbo].[bvc_SiteTerm] ([SiteTerm], [SiteTermValue]) VALUES (N'WriteAReview', N'Write a Review for this Product')

/* Insert scripts for table: [dbo].[bvc_Tax] */
PRINT 'Inserting rows into table: [dbo].[bvc_Tax]'

SET IDENTITY_INSERT [dbo].[bvc_Tax] ON

INSERT INTO [dbo].[bvc_Tax] ([ID], [CountryCode], [RegionCode], [PostalCode], [TaxClass], [Rate]) VALUES (6, N'en-US', 47, N'', 0,  4.5)

SET IDENTITY_INSERT [dbo].[bvc_Tax] OFF


/* Insert scripts for table: [dbo].[bvc_TaxClass] */
PRINT 'Inserting rows into table: [dbo].[bvc_TaxClass]'

SET IDENTITY_INSERT [dbo].[bvc_TaxClass] ON

INSERT INTO [dbo].[bvc_TaxClass] ([ID], [DisplayName]) VALUES (1, N'Food and Beverages')
INSERT INTO [dbo].[bvc_TaxClass] ([ID], [DisplayName]) VALUES (2, N'EU Taxable Item')
INSERT INTO [dbo].[bvc_TaxClass] ([ID], [DisplayName]) VALUES (5, N'Alcohol')
INSERT INTO [dbo].[bvc_TaxClass] ([ID], [DisplayName]) VALUES (6, N'Tobacco')

SET IDENTITY_INSERT [dbo].[bvc_TaxClass] OFF


/* Insert scripts for table: [dbo].[bvc_User] */
PRINT 'Inserting rows into table: [dbo].[bvc_User]'

SET IDENTITY_INSERT [dbo].[bvc_User] ON

INSERT INTO [dbo].[bvc_User] ([ID], [UserName], [Password], [FirstName], [LastName], [Salt], [TaxExempt], [Email], [CreationDate], [LastLoginDate], [PasswordHint], [Comment], [PricingLevel]) VALUES (30, N'admin@bvcommerce.com', N'r0227FSenzG6tXlG9chLnw==', N'Admin', N'User', N'7d426863-f23e-4a0f-9ced-4a3414c977cc', 0, N'admin@bvcommerce.com', '20031230 00:00:00:000', '20031230 00:00:00:000', N'', N'', 0)

SET IDENTITY_INSERT [dbo].[bvc_User] OFF


/* Insert scripts for table: [dbo].[bvc_UserXRole] */
PRINT 'Inserting rows into table: [dbo].[bvc_UserXRole]'

INSERT INTO [dbo].[bvc_UserXRole] ([UserID], [RoleName]) VALUES (30, N'Administrator')

/* No records are in [dbo].[bvc_Vendor] */

/* Insert scripts for table: [dbo].[bvc_WebAppSetting] */
PRINT 'Inserting rows into table: [dbo].[bvc_WebAppSetting]'

INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'AdminOrderReceiptFrom', 'admin@bvcommerce.com')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'AdminOrderReceiptInHTML', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'AdminOrderReceiptSubject', 'New Store Order [[ordernumber]]')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'AffiliateCommission', '10')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'AffiliateCommissionType', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'AffiliateConflictResolution', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'AffiliateQueryStringName', 'affid')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'AffiliateReferralDays', '60')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'AffiliateSignupAllowed', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'AllowFreeOrders', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'AllowMultipleShippingAddresses', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'AllowPersonalizedThemes', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'AmazonAssociateID', 'bvsoftware-20')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES ('AutoEmailStatusChanges', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'BillAddressRequireCompany', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'BillAddressRequireFax', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'BillAddressRequireFirstName', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'BillAddressRequireLastName', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'BillAddressRequirePhone', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'BillAddressRequireWebSiteURL', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'BillAddressShowCompany', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'BillAddressShowFax', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'BillAddressShowMiddleInitial', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'BillAddressShowPhone', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'BillAddressShowWebSiteURL', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'CartCookieName', 'BVC2004ShoppingCartCookieID')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'CartCookieTime', '2880')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'CategoryAdvancedDescriptionSpace', '150')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'CCProcessorID', '6D6F658F-493C-4EF2-A9EB-29B001FA8096')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ChargeAtCheckout', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ChargeTaxOnShipping', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'CheckoutShowSpecialInstructions', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'CleanUpCartDays', '30')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'CleanUpCCDays', '7')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'CleanUpIntervalDays', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'CleanUpLastRun', '4/27/2004 10:18:38 PM')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES ('ContactAddress', '<?xml version="1.0" encoding="utf-16"?>
<Address>
   <ID>-1</ID>
   <FirstName />
   <LastName />
   <CompanyName>BV Commerce Store</CompanyName>
   <StreeLine1>123 Any Street</StreeLine1>
   <City>Richmond</City>
   <StateName>Virginia</StateName>
   <StateCode>47</StateCode>
   <PostalCode>23233</PostalCode>
   <CountryName>United States</CountryName>
   <CountryCode>en-US</CountryCode>
   <PhoneNumber>2125555555</PhoneNumber>
   <WebSiteUrl>http://</WebSiteUrl>
</Address>')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ContactAddressID', '1150')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ContactEmail', 'admin@bvcommerce.com')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ContactFax', '')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'Copyright', '2004 - Your Company')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'CurrentStyleSheet', 'BVThemes/Tech 1 Blue/styles.css')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'DefaultOrderManagerDateRange', '7')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'DisableInventory', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'DisableProductCaching', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'EmailDropShipperFrom', 'admin@bvcommerce.com')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'EmailDropShipperInHTML', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'EmailDropShipperOnAuthorization', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'EmailDropShipperSubject', 'Drop Ship Request: [[ordernumber]]')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'EmailMerchantAddress', 'admin@bvcommerce.com')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'EmailMerchantFlag', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'FedExAccountNumber', '')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'FedExAlwaysUseResidential', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'FedExCarrierCode', 'FDXG')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'FedExCustomerNumber', '')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'FedExDropOffType', 'BUSINESSSERVICECENTER')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'FedExMeterNumber', '')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'FedExServiceType', 'GROUNDHOMEDELIVERY')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'FedExServiceURL', 'https://gateway.fedex.com/GatewayDC')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ForgotPasswordMailFrom', 'admin@bvcommerce.com')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ForgotPasswordMailInHTML', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ForgotPasswordMailSubject', 'Password Reminder For [[username]]')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'GiftCertificatesAllowed', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'GiftCertificatesMaximum', '199.99')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'GiftCertificatesMinimum', '10.00')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'GiftWrapCharge', '1.00')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'GiftWrapEnabled', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'HandlingFee', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'HandlingFeeType', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'Images_ForceSizes', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'Images_MediumHeight', '175')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'Images_MediumWidth', '175')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'Images_SmallHeight', '110')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'Images_SmallWidth', '110')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'Images_TinyHeight', '64')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'Images_TinyWidth', '64')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'InventoryLowEmail', 'admin@bvcommerce.com')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'InventoryLowHours', '99999')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'InventoryLowLastRun', '4/27/2004 1:57:22 PM')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'LastOrderNumber', '100')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'LeftCategoryLevels', '2')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'MailServer', '')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'MailServerPassword', '')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'MailServerUseAuthentication', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'MailServerUsername', '')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'MainMenuShowCategories', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'MenuMaxTabs', '6')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'MergeCartItems', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'MetaDescription', 'BVSoftware.com supplies E-Commerce solutions to small businesses.')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'MetaKeywords', 'BV Software, BV Commerce, E-commerce,Store,Sales')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'NewProductBadgeAllowed', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'NewProductBadgeDays', '60')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'OrderLimitAmount', '99999.99')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'OrderLimitQuantity', '9999')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'OrderMinimumAmount', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'OrderMinimumQuantity', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'OrderNumberStepHigh', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'OrderNumberStepLow', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'OrderReceiptFrom', 'admin@bvcommerce.com')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'OrderReceiptInHTML', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'OrderReceiptSubject', 'Order receipt for order [[ordernumber]]')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'OrderUpdateFrom', 'admin@bvcommerce.com')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'OrderUpdateInHTML', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'OrderUpdateSubject', 'Status update for order [[ordernumber]]')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'PagerLast', 'Previous&nbsp;|')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'PagerNext', '|&nbsp;Next&nbsp;')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'PagerPrefix', '&nbsp;')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'PagerShowNextLast', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'PagerSpacer', '&nbsp;|&nbsp;')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'PagerSuffix', '&nbsp;')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'PaymentDescriptionCheck', 'send a check by mail.')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'PaymentDescriptionEmail', 'Email us to arrange for payment. Please do not send credit card information by email.')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'PaymentDescriptionFax', 'fax in your payment information')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'PaymentDescriptionPayPal', 'send a payment through PayPal')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'PaymentDescriptionPurchaseOrder', 'PO Number')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'PaymentDescriptionTelephone', 'call in your payment information')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'PaymentEnabledCheck', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'PaymentEnabledCreditCard', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'PaymentEnabledEmail', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'PaymentEnabledFax', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'PaymentEnabledPayPal', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'PaymentEnabledPurchaseOrder', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'PaymentEnabledTelephone', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'PaymentInstructionsCheck', 'Please mail your check to: xxxxxxx')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'PaymentInstructionsCreditCard', 'Your order has been received. Thank you.')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'PaymentInstructionsEmail', 'Email us to arrange for payment. Please do not send credit card information by email.')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'PaymentInstructionsFax', 'Please fax your payment information to (xxx) xxx-xxxx')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'PaymentInstructionsPayPal', 'Your order has been entered into our systems. Please click the PayPal logo to pay by PayPal and complete this transaction. When your payment has been verified your order will be shipped.')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'PaymentInstructionsPurchaseOrder', 'Your order has been received. Your billing department will receive an invoice shortly.')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'PaymentInstructionsTelephone', 'Please call (xxx) xxx-xxxx with your order number and payment information')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'PayPalItemDescription', 'Items from My Store')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'PayPalUsername', '')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'PoweredByAffiliateID', '')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'PricingLevelsBelowCostAllowed', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ProductReviewAllow', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ProductReviewCount', '3')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ProductReviewModerate', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ProductReviewShow', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ProductReviewShowKarma', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ProductReviewShowRating', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'RequireCVV', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'RequirePhoneNumber', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'RequireTermsAgreement', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ReturnFormAllowed', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ReturnFormEmail', 'admin@bvcommerce.com')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'SaveCartIDToCookie', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'SearchResultsColumns', '3')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'SearchResultsDisplayStyle', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'SearchResultsRows', '2')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ShipAddressRequireCompany', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ShipAddressRequireFax', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ShipAddressRequireFirstName', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ShipAddressRequireLastName', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ShipAddressRequirePhone', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ShipAddressRequireWebSiteURL', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ShipAddressShowCompany', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ShipAddressShowFax', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ShipAddressShowMiddleInitial', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ShipAddressShowPhone', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ShipAddressShowWebSiteURL', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'Shipping_UPS_License', '')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'Shipping_UPS_Password', '')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'Shipping_UPS_Server', 'https://www.ups.com/ups.app/xml/')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'Shipping_UPS_Username', '')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'Shipping_USPS_Server', 'http://Production.shippingapis.com/ShippingAPI.dll')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ShippingNoAvailableMethodsMessage', 'Shipping charges can not be calculated at this time. You may continue with your order and we will contact you later with more shipping information.')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ShippingRealTimeProvider', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ShippingUPSDefaultPackaging', '2')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ShippingUPSDefaultPaymentMethod', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ShippingUPSDefaultService', '3')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ShippingUPSWriteXml', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ShipURL_FedEx', 'http://www.fedex.com/cgi-bin/tracking?action=track&language=english&cntry_code=us&initial=x&tracknumbers=')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ShipURL_UPS', 'http://wwwapps.ups.com/etracking/tracking.cgi?tracknums_displayed=1&TypeOfInquiryNumber=T&InquiryNumber1=')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ShipURL_USPS', 'http://trkcnfrm1.smi.usps.com/netdata-cgi/db2www/cbd_243.d2w/output?CAMEFROM=OK&strOrigTrackNum=')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ShowHomeLinkInCategoryTree', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ShowImagesInCart', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ShowMiniCartTotals', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ShowPoweredBy', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ShowSubCategoriesWithProducts', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'ShowWelcomeText', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'SiteCultureCode', 'en-US')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'SiteName', 'BVC 2004 Store')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'StoreCartsInSession', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'StoreClosed', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'StoreClosedDescription', '<IMG src="Images/Closed.jpg" border="0"><BR>&nbsp;<BR>&nbsp;<BR><SPAN class=Text>Our store is closed while we update. We appreciate your patience.<BR>&nbsp;<BR>&nbsp;<BR>While we update you may order by telephone at <B>(xxx)-xxx-xxxx</B></SPAN><br>&nbsp;<br>&nbsp;')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'StoreUsersInSession', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'UPSRestrictions', '1')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'UserCookieName', 'BVC2004SiteCookie')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'UseSSL', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'UseSSLForAdmin', '0')
INSERT INTO [dbo].[bvc_WebAppSetting] ([SettingName], [SettingValue]) VALUES (N'WishListShowOnCart', '1')

/* No records are in [dbo].[bvc_WishList] */

Print 'Enabling all Constraints'
exec sp_msforeachtable 'ALTER TABLE ? CHECK CONSTRAINT ALL'

Print 'Enabling all Triggers'
exec sp_msforeachtable 'ALTER TABLE ? ENABLE TRIGGER ALL'

