I've got some additional information here. I looked through the SQLDataProvider files in the package and noticed that the Smith_ShoppingCart table dropped and recreated with fewer columns in 04.01.00, but there are still references to deleted columns in a couple stored procedures.
Here's the original Smith_ShoppingCart creation in 01.00.00:
if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}Smith_ShoppingCart'))
drop table {databaseOwner}{objectQualifier}Smith_ShoppingCart
GO
CREATE TABLE {databaseOwner}[{objectQualifier}Smith_ShoppingCart](
[CartID] [int] IDENTITY(1,1) NOT NULL,
[ProductID] [int] NOT NULL,
[Manufacturer] [varchar](50) NULL,
[ModelName] [varchar](50) NULL,
[UnitCost] [decimal](18, 0) NULL,
[QuantityOnHand] [int] NULL,
[Quantity] [int] NULL,
[Weight] [decimal](18, 0) NULL,
[ProductName] [varchar](50) NULL,
[ProductSku] [varchar](50) NULL,
[IsRequired] [bit] NULL,
[BundleID] [int] NULL,
[AddDnnRole] [varchar](50) NULL,
[Recurring] [bit] NULL,
[RequireLogin] [bit] NULL,
[UsePriPriceWght] [bit] NULL,
[MasterBundleID] [int] NULL,
[LineItem] [int] NULL,
[RoleExpireDays] [varchar](50) NULL,
[MemberPrice] [decimal](18, 0) NULL,
[TaxExempt] [bit] NULL,
[ShipCodes] [varchar](100) NULL,
[ShipText] [nvarchar](500) NULL,
[ShipCost] [money] NULL,
CONSTRAINT [PK_Smith_ShoppingCart_1] PRIMARY KEY CLUSTERED
(
[CartID] ASC
)
)
GO
Here is the drop and create of the Smith_ShoppingCart table in 04.01.00:
if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}Smith_ShoppingCart'))
drop table {databaseOwner}{objectQualifier}Smith_ShoppingCart
GO
CREATE TABLE {databaseOwner}[{objectQualifier}Smith_ShoppingCart](
[CartID] [int] IDENTITY(1,1) NOT NULL,
[ProductID] [int] NOT NULL,
[Quantity] [decimal](10, 2) NULL,
[ProductName] [varchar](255) NULL,
[CartCookie] [varchar](30) NULL,
[IsRequired] [bit] NULL,
CONSTRAINT [PK_Smith_ShoppingCart_1] PRIMARY KEY CLUSTERED
(
[CartID] ASC
)
)
GO
Here are the two stored procedures referencing columns that no longer exist:
Created in 01.00.00
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'{databaseOwner}{objectQualifier}Smith_DeleteShoppingCartBundle'))
drop procedure {databaseOwner}{objectQualifier}Smith_DeleteShoppingCartBundle
GO
CREATE PROCEDURE {databaseOwner}{objectQualifier}Smith_DeleteShoppingCartBundle
(
@bundleID int,
@masterBundleID int
)
AS
BEGIN
DELETE FROM {objectQualifier}Smith_ShoppingCart
WHERE [BundleID] = @bundleID AND [MasterBundleID] = @masterBundleID
END
GO
Created in 01.00.02
if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}Smith_DeleteDuplicateShoppingCartBundle')) drop procedure {databaseOwner}{objectQualifier}Smith_DeleteDuplicateShoppingCartBundle
GO
CREATE PROCEDURE {databaseOwner}{objectQualifier}Smith_DeleteDuplicateShoppingCartBundle
(
@bundleID int,
@cartID int
)
AS
BEGIN
DELETE FROM {objectQualifier}Smith_ShoppingCart
WHERE [BundleID] = @bundleID AND CARTID = @cartID
END
GO
Both of these procedures are very old and I'm guessing they're depricated. Can anyone confirm if these are still needed? Can I delete them without problem?