CREATE INDEX QFOMARPROD_01 ON QFOMARPROD (CDMARCA, CDPRODUTO, IDAPRMARPRO, IDAUTMARPRO, DTVALAPROVA)
/
CREATE INDEX ITEMCOLE_05 ON ITEMCOLE (CDPRODUTO, DTINIVALITM DESC)
/
CREATE INDEX PREVCONS_02 ON PREVCONS (CDFILIAL, DTPREVCONS, CDPRODUTO, QTPREVCONS)
/
ALTER TABLE PARASUPRI ADD (
  IDENVIAEMAILFORNSMTP VARCHAR2(1) DEFAULT NULL NULL
)
/
ALTER TABLE PARASUPRI ADD CONSTRAINT CKC_IDENVIAEMAILFORNSMTP CHECK (IDENVIAEMAILFORNSMTP IS NULL OR (IDENVIAEMAILFORNSMTP IN ('S', 'N', 'A')))