IF NOT EXISTS (
    SELECT 1 FROM sys.tables WHERE object_id = OBJECT_ID('dbo.proProgramaOrden')
)
BEGIN
    CREATE TABLE dbo.proProgramaOrden (
        idOP    int          NOT NULL,
        linea   int          NOT NULL,
        NP      int          NOT NULL,   -- 0 para OP de stock
        codbus  varchar(50)  NOT NULL,
        orden   int          NOT NULL,
        CONSTRAINT PK_proProgramaOrden PRIMARY KEY CLUSTERED (idOP, linea, NP, codbus)
    )
END
GO
