ALTER TABLE PRODUTO ADD (
  IDPRODDIMEVAR VARCHAR2(1) DEFAULT NULL NULL, 
  VRALTURAPROD DOUBLE PRECISION DEFAULT NULL NULL, 
  VRCOMPRIPROD DOUBLE PRECISION DEFAULT NULL NULL
)
/
ALTER TABLE PRODUTO ADD CONSTRAINT CHECK_9293 CHECK (IDPRODDIMEVAR IN ('S', 'N', NULL))
/
ALTER TABLE PARAMPEDIDO ADD (
  IDOBRDIMENSAO VARCHAR2(1) DEFAULT 'N' NOT NULL, 
  IDINFPROCFAB VARCHAR2(1) DEFAULT 'N' NOT NULL
)
/
ALTER TABLE PARAMPEDIDO ADD CONSTRAINT CHECK_9296 CHECK (IDOBRDIMENSAO IN ('S', 'N'))
/
ALTER TABLE PARAMPEDIDO ADD CONSTRAINT CHECK_9297 CHECK (IDINFPROCFAB IN ('S', 'N'))
/
ALTER TABLE PROCFABRICA ADD (
  IDCALCINSUPROP VARCHAR2(1) DEFAULT 'N' NOT NULL
)
/
ALTER TABLE PROCFABRICA ADD CONSTRAINT CHECK_9298 CHECK (IDCALCINSUPROP IN ('S', 'N'))
/
ALTER TABLE ITEMPEDIDO ADD (
  VRALTURAPROD DOUBLE PRECISION DEFAULT NULL NULL, 
  VRCOMPRIPROD DOUBLE PRECISION DEFAULT NULL NULL
)
/
ALTER TABLE PROCFABRICA ADD (
  VRALTPADRPROD DOUBLE PRECISION DEFAULT NULL NULL, 
  VRCOMPADRPROD DOUBLE PRECISION DEFAULT NULL NULL
)
/
ALTER TABLE PRODFILI ADD (
  CDALMOXREUT VARCHAR2(6) DEFAULT NULL NULL, 
  CDLOCALREUT VARCHAR2(6) DEFAULT NULL NULL
)