SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

/*
Rollback della patch parallela Python.

Non ripristina oggetti legacy, perche' la patch parallela non li modifica.
Rimuove solo gli oggetti dbo.py_* e la tabella di prenotazione Python.
*/

IF OBJECT_ID(N'dbo.py_sp_ControllaPrenotazionePackingListPalletNew', N'P') IS NOT NULL
    DROP PROCEDURE dbo.py_sp_ControllaPrenotazionePackingListPalletNew;
GO

IF OBJECT_ID(N'dbo.py_sp_xExePackingListPalletPrenota', N'P') IS NOT NULL
    DROP PROCEDURE dbo.py_sp_xExePackingListPalletPrenota;
GO

IF OBJECT_ID(N'dbo.py_sp_xExePackingListPallet', N'P') IS NOT NULL
    DROP PROCEDURE dbo.py_sp_xExePackingListPallet;
GO

IF OBJECT_ID(N'dbo.py_ViewPackingListRestante', N'V') IS NOT NULL
    DROP VIEW dbo.py_ViewPackingListRestante;
GO

IF OBJECT_ID(N'dbo.py_XMag_ViewPackingList', N'V') IS NOT NULL
    DROP VIEW dbo.py_XMag_ViewPackingList;
GO

IF OBJECT_ID(N'dbo.PyPickingListReservation', N'U') IS NOT NULL
    DROP TABLE dbo.PyPickingListReservation;
GO