DELETE FROM ShoppingCartItem
DELETE FROM OrderNote
DELETE FROM RecurringPayment
DELETE FROM RewardPointsHistory
DELETE FROM [Order]
DELETE FROM PredefinedProductAttributeValue
DELETE FROM RelatedProduct
DELETE FROM ProductAttribute
DELETE FROM Picture
DELETE FROM Product_Category_Mapping
DELETE FROM Product
DELETE FROM PredefinedProductAttributeValue
DELETE FROM Product_Picture_Mapping
DELETE FROM Product_ProductAttribute_Mapping
DELETE FROM PredefinedProductAttributeValue
DELETE FROM Product_ProductTag_Mapping
DELETE FROM Product_SpecificationAttribute_Mapping
DELETE FROM ProductReview
DELETE FROM ProductReviewHelpfulness
Delete UrlRecord Where EntityName = 'Product'
DBCC CHECKIDENT (ShoppingCartItem, RESEED, 0)
DBCC CHECKIDENT (OrderNote, RESEED, 0)
DBCC CHECKIDENT (RecurringPayment, RESEED, 0)
DBCC CHECKIDENT (RewardPointsHistory, RESEED, 0)
DBCC CHECKIDENT ([Order], RESEED, 0)
DBCC CHECKIDENT (RelatedProduct, RESEED, 0)
DBCC CHECKIDENT (ProductAttribute, RESEED, 0)
DBCC CHECKIDENT (Picture, RESEED, 0)
DBCC CHECKIDENT (Product_Category_Mapping, RESEED, 0)
DBCC CHECKIDENT (Product, RESEED, 0)
DBCC CHECKIDENT (PredefinedProductAttributeValue, RESEED, 0)
DBCC CHECKIDENT (Product_Picture_Mapping, RESEED, 0)
DBCC CHECKIDENT (Product_ProductAttribute_Mapping, RESEED, 0)
DBCC CHECKIDENT (Product_SpecificationAttribute_Mapping, RESEED, 0)
DBCC CHECKIDENT (PredefinedProductAttributeValue, RESEED, 0)
DBCC CHECKIDENT (ProductReview, RESEED, 0)
DBCC CHECKIDENT (ProductReviewHelpfulness, RESEED,0)
DELETE FROM Category;
DBCC CHECKIDENT (Category, RESEED, 0)
DELETE FROM ShoppingCartItem
DELETE FROM OrderNote
DELETE FROM RecurringPayment
DELETE FROM RewardPointsHistory
DELETE FROM GiftCard
DELETE FROM [Order]
DELETE FROM PredefinedProductAttributeValue
DELETE FROM RelatedProduct
DELETE FROM ProductAttribute
DELETE FROM Picture
DELETE FROM Product_Category_Mapping
DELETE FROM Product
DELETE FROM PredefinedProductAttributeValue
DELETE FROM Product_Picture_Mapping
DELETE FROM Product_ProductAttribute_Mapping
DELETE FROM PredefinedProductAttributeValue
DELETE FROM Product_ProductTag_Mapping
DELETE FROM Product_SpecificationAttribute_Mapping
DELETE FROM ProductReview
DELETE FROM ProductReviewHelpfulness
DELETE FROM Forums_PrivateMessage
Delete UrlRecord Where EntityName = 'Product'
DBCC CHECKIDENT (ShoppingCartItem, RESEED, 0)
DBCC CHECKIDENT (OrderNote, RESEED, 0)
DBCC CHECKIDENT (RecurringPayment, RESEED, 0)
DBCC CHECKIDENT (RewardPointsHistory, RESEED, 0)
DBCC CHECKIDENT ([Order], RESEED, 0)
DBCC CHECKIDENT (RelatedProduct, RESEED, 0)
DBCC CHECKIDENT (ProductAttribute, RESEED, 0)
DBCC CHECKIDENT (Picture, RESEED, 0)
DBCC CHECKIDENT (Product_Category_Mapping, RESEED, 0)
DBCC CHECKIDENT (Product, RESEED, 0)
DBCC CHECKIDENT (PredefinedProductAttributeValue, RESEED, 0)
DBCC CHECKIDENT (Product_Picture_Mapping, RESEED, 0)
DBCC CHECKIDENT (Product_ProductAttribute_Mapping, RESEED, 0)
DBCC CHECKIDENT (Product_SpecificationAttribute_Mapping, RESEED, 0)
DBCC CHECKIDENT (PredefinedProductAttributeValue, RESEED, 0)
DBCC CHECKIDENT (ProductReview, RESEED, 0)
DBCC CHECKIDENT (ProductReviewHelpfulness, RESEED,0)
CREATE PROCEDURE [dbo].[RESET_DB]
(
@ResetCategories bit,
@ResetManufacturers bit
)
AS
SET NOCOUNT ON;
----------------------------------------------------------------------------------------
-- Delete Product and Order and related tables and data.
DELETE FROM ShoppingCartItem;
DELETE FROM OrderNote;
DELETE FROM RecurringPayment;
DELETE FROM RewardPointsHistory;
DELETE FROM [Order]; -- many deletes cascade from here
DELETE FROM ProductAttributeCombination;
DELETE FROM RelatedProduct;
DELETE FROM ProductAttributeValue;
DELETE FROM ProductAttribute;
DELETE FROM Picture;
DELETE FROM Product_Category_Mapping;
DELETE FROM Product;
DELETE FROM Product_Picture_Mapping;
DELETE FROM Product_ProductAttribute_Mapping;
DELETE FROM Product_ProductTag_Mapping;
DELETE FROM Product_SpecificationAttribute_Mapping;
DELETE FROM ProductReview;
DELETE FROM ProductReviewHelpfulness;
DELETE UrlRecord Where EntityName = 'Product';
-- Delete Category and related tables and data.
IF (@ResetCategories = 1) BEGIN
DELETE FROM Category;
DELETE UrlRecord Where EntityName = 'Category';
END
-- Delete Manufacturer and related tables and data.
IF (@ResetManufacturers = 1) BEGIN
DELETE FROM Manufacturer;
DELETE UrlRecord Where EntityName = 'Manufacturer';
END
-- Reseed IDENTITY property
DBCC CHECKIDENT (ShoppingCartItem, RESEED, 0);
DBCC CHECKIDENT (OrderNote, RESEED, 0);
DBCC CHECKIDENT (RecurringPayment, RESEED, 0);
DBCC CHECKIDENT (RewardPointsHistory, RESEED, 0);
DBCC CHECKIDENT ([Order], RESEED, 0);
DBCC CHECKIDENT(ProductAttributeCombination, RESEED, 0);
DBCC CHECKIDENT (RelatedProduct, RESEED, 0)
DBCC CHECKIDENT ([ProductAttributeValue], RESEED, 0);
DBCC CHECKIDENT (ProductAttribute, RESEED, 0);
DBCC CHECKIDENT (Picture, RESEED, 0);
DBCC CHECKIDENT (Product_Category_Mapping, RESEED, 0);
DBCC CHECKIDENT (Product, RESEED, 0);
DBCC CHECKIDENT (Product_Picture_Mapping, RESEED, 0);
DBCC CHECKIDENT (Product_ProductAttribute_Mapping, RESEED, 0);
DBCC CHECKIDENT (Product_SpecificationAttribute_Mapping, RESEED, 0);
DBCC CHECKIDENT (ProductReview, RESEED, 0);
DBCC CHECKIDENT (ProductReviewHelpfulness, RESEED, 0);
IF (@ResetCategories = 1) BEGIN
DBCC CHECKIDENT (Category, RESEED, 0);
END
IF (@ResetManufacturers = 1) BEGIN
DBCC CHECKIDENT (Manufacturer, RESEED, 0);
END
-- Rebuild indexes on Product and Order and related tables.
ALTER INDEX ALL ON dbo.ShoppingCartItem REBUILD;
ALTER INDEX ALL ON dbo.OrderNote REBUILD;
ALTER INDEX ALL ON dbo.RecurringPayment REBUILD;
ALTER INDEX ALL ON dbo.RewardPointsHistory REBUILD;
ALTER INDEX ALL ON dbo.[Order] REBUILD;
ALTER INDEX ALL ON dbo.ProductAttributeCombination REBUILD;
ALTER INDEX ALL ON dbo.RelatedProduct REBUILD;
ALTER INDEX ALL ON dbo.ProductAttribute REBUILD;
ALTER INDEX ALL ON dbo.Picture REBUILD;
ALTER INDEX ALL ON dbo.Product_Category_Mapping REBUILD;
ALTER INDEX ALL ON dbo.Product REBUILD;
ALTER INDEX ALL ON dbo.Product_Picture_Mapping REBUILD;
ALTER INDEX ALL ON dbo.Product_ProductAttribute_Mapping REBUILD;
ALTER INDEX ALL ON dbo.Product_SpecificationAttribute_Mapping REBUILD;
ALTER INDEX ALL ON dbo.ProductReview REBUILD;
ALTER INDEX ALL ON dbo.ProductReviewHelpfulness REBUILD;
IF (@ResetCategories = 1) BEGIN
ALTER INDEX ALL ON dbo.Category REBUILD;
END
IF (@ResetManufacturers = 1) BEGIN
ALTER INDEX ALL ON dbo.Manufacturer REBUILD;
END
-- Update statistics
EXEC sp_updatestats;
/*---- EOSP ----*/
DELETE FROM ActivityLog
DELETE FROM Affiliate
DELETE FROM BlogComment
DELETE FROM BlogPost
DELETE FROM Category
DELETE FROM Customer_CustomerRole_Mapping WHERE Customer_ID > 1
DELETE FROM CustomerAddresses
UPDATE Customer SET BillingAddress_Id = NULL, ShippingAddress_Id = NULL
DELETE FROM Customer WHERE ID > 3
DELETE FROM [Address]
DELETE FROM CustomerPassword WHERE ID > 3
DELETE FROM Download
DELETE FROM Forums_Forum
DELETE FROM GenericAttribute WHERE EntityId > 1
DELETE FROM GiftCard
DELETE FROM [Log]
DELETE FROM Manufacturer
DELETE FROM News
DELETE FROM NewsComment
DELETE FROM [Order]
DELETE FROM OrderItem
DELETE FROM OrderNote
DELETE FROM Picture
DELETE FROM PictureBinary
DELETE FROM Poll
DELETE FROM PollAnswer
DELETE FROM PollVotingRecord
DELETE FROM Product
DELETE FROM Product_Category_Mapping
DELETE FROM Product_Picture_Mapping
DELETE FROM Product_ProductAttribute_Mapping
DELETE FROM Product_ProductTag_Mapping
DELETE FROM ProductAttribute
DELETE FROM ProductAttributeCombination
DELETE FROM ProductAttributeValue
DELETE FROM ProductReview
DELETE FROM ProductReviewHelpfulness
DELETE FROM ProductTag
DELETE FROM QueuedEmail
DELETE FROM RecurringPaymentHistory
DELETE FROM RelatedProduct
DELETE FROM ReturnRequest
DELETE FROM RewardPointsHistory
DELETE FROM SearchTerm
DELETE FROM ShoppingCartItem
DELETE FROM SpecificationAttribute
DELETE FROM SpecificationAttributeOption
DELETE FROM StorePickupPoint
DELETE FROM UrlRecord WHERE ID > 12
DELETE FROM Vendor
DELETE FROM Warehouse
DBCC CHECKIDENT (ActivityLog, RESEED, 0)
DBCC CHECKIDENT ([Address], RESEED, 0)
DBCC CHECKIDENT (Affiliate, RESEED, 0)
DBCC CHECKIDENT (BlogComment, RESEED, 0)
DBCC CHECKIDENT (BlogPost, RESEED, 0)
DBCC CHECKIDENT (Category, RESEED, 0)
DBCC CHECKIDENT (Download, RESEED, 0)
DBCC CHECKIDENT (Forums_Forum, RESEED, 0)
DBCC CHECKIDENT (GiftCard, RESEED, 0)
DBCC CHECKIDENT ([Log], RESEED, 0)
DBCC CHECKIDENT (Manufacturer, RESEED, 0)
DBCC CHECKIDENT (News, RESEED, 0)
DBCC CHECKIDENT (NewsComment, RESEED, 0)
DBCC CHECKIDENT ([Order], RESEED, 0)
DBCC CHECKIDENT (OrderItem, RESEED, 0)
DBCC CHECKIDENT (OrderNote, RESEED, 0)
DBCC CHECKIDENT (Picture, RESEED, 0)
DBCC CHECKIDENT (PictureBinary, RESEED, 0)
DBCC CHECKIDENT (Poll, RESEED, 0)
DBCC CHECKIDENT (PollAnswer, RESEED, 0)
DBCC CHECKIDENT (PollVotingRecord, RESEED, 0)
DBCC CHECKIDENT (Product, RESEED, 0)
DBCC CHECKIDENT (Product_Category_Mapping, RESEED, 0)
DBCC CHECKIDENT (Product_Picture_Mapping, RESEED, 0)
DBCC CHECKIDENT (Product_ProductAttribute_Mapping, RESEED, 0)
DBCC CHECKIDENT (ProductAttribute, RESEED, 0)
DBCC CHECKIDENT (ProductAttributeCombination, RESEED, 0)
DBCC CHECKIDENT (ProductAttributeValue, RESEED, 0)
DBCC CHECKIDENT (ProductReview, RESEED, 0)
DBCC CHECKIDENT (ProductReviewHelpfulness, RESEED, 0)
DBCC CHECKIDENT (ProductTag, RESEED, 0)
DBCC CHECKIDENT (QueuedEmail, RESEED, 0)
DBCC CHECKIDENT (RecurringPaymentHistory, RESEED, 0)
DBCC CHECKIDENT (RelatedProduct, RESEED, 0)
DBCC CHECKIDENT (ReturnRequest, RESEED, 0)
DBCC CHECKIDENT (RewardPointsHistory, RESEED, 0)
DBCC CHECKIDENT (SearchTerm, RESEED, 0)
DBCC CHECKIDENT (ShoppingCartItem, RESEED, 0)
DBCC CHECKIDENT (SpecificationAttribute, RESEED, 0)
DBCC CHECKIDENT (SpecificationAttributeOption, RESEED, 0)
DBCC CHECKIDENT (StorePickupPoint, RESEED, 0)
DBCC CHECKIDENT (Vendor, RESEED, 0)
DBCC CHECKIDENT (Warehouse, RESEED, 0)
