------------------------------------------------------------------------------
-- ADVANTAGE 2004.3.5
-- DB OBJECT CHANGES SINCE ADVANTAGE 2004.3.4
-- 24 JUN 2007
------------------------------------------------------------------------------


-- USE Advantage
-- GO



-------------------------------------------------------------------------------
-- TABLE MODS
-------------------------------------------------------------------------------


CREATE INDEX [IX_AO_Order_Candidates_AP_Products_ID] ON [dbo].[AO_Order_Candidates] ([AP_Products_ID])
GO

CREATE INDEX [IX_AO_Order_Candidates_Temp_AP_Products_ID] ON [dbo].[AO_Order_Candidates_Temp] ([AP_Products_ID])
GO

CREATE INDEX [IX_AO_Supplier_Product_Discounts_AP_Products_ID] ON [dbo].[AO_Supplier_Product_Discounts] ([AP_Products_ID])
GO

CREATE INDEX [IX_AP_Inventory_Adjustments_AP_Products_ID] ON [dbo].[AP_Inventory_Adjustments] ([AP_Products_ID])
GO

CREATE INDEX [IX_AP_Products_History_AP_Products_ID] ON [dbo].[AP_Products_History] ([AP_Products_ID])
GO

CREATE INDEX [IX_AP_Products_Stock_Takes_AP_Products_ID] ON [dbo].[AP_Products_Stock_Takes] ([AP_Products_ID])
GO

CREATE INDEX [IX_AP_Stock_Exchange_AP_Products_ID] ON [dbo].[AP_Stock_Exchange] ([AP_Products_ID])


-------------------------------------------------------------------------------

UPDATE AW_Motivational_Messages
SET Message = REPLACE(Message, '"', '''')

-------------------------------------------------------------------------------

ALTER TABLE [dbo].[Slu_AW_SMS_Messages] WITH NOCHECK ADD 
	CONSTRAINT [PK_Slu_AW_SMS_Messages] PRIMARY KEY  CLUSTERED 
	(
		[Slu_AW_SMS_Messages_ID]
	)  ON [PRIMARY] 
GO