ALTER TABLE AVALIACAOSERVICO ADD NMUSUARIO VARCHAR2(255) NULL
/

ALTER TABLE AVALIACAOSERVICO ADD HRCONSUMO VARCHAR2(4) NULL
/

ALTER TABLE AVALIACAOSERVICO ADD DSCONSUMO VARCHAR2(255) NULL 
/

ALTER TABLE AVALIACAOSERVICO ADD NRLOCALPESQ NUMBER NULL
/

ALTER TABLE AVALIACAOSERVICO ADD CONSTRAINT
      FKPLA01212LOCALPESQ FOREIGN KEY (NRLOCALPESQ) 
			REFERENCES LOCALPESQ (NRLOCALPESQ) ON DELETE CASCADE
/

CREATE INDEX PLA01212_FK ON AVALIACAOSERVICO (NRLOCALPESQ)
/

ALTER TABLE AVALIACAOPRATO ADD NMUSUARIO VARCHAR2(255) NULL
/

ALTER TABLE AVALIACAOPRATO ADD HRCONSUMO VARCHAR2(4) NULL
/

ALTER TABLE AVALIACAOPRATO ADD DSCONSUMO VARCHAR2(255) NULL
/

ALTER TABLE AVALIACAOPRATO ADD NRLOCALPESQ NUMBER NULL
/

ALTER TABLE AVALIACAOPRATO ADD CONSTRAINT 
      FKPLA01213LOCALPESQ FOREIGN KEY (NRLOCALPESQ) 
			REFERENCES LOCALPESQ(NRLOCALPESQ) ON DELETE CASCADE
/

CREATE INDEX PLA01213_FK ON AVALIACAOPRATO(NRLOCALPESQ)
/

ALTER TABLE TIPOCTPAGROP ADD IDTPVRCTPAGAR VARCHAR2(10) NULL
   CONSTRAINT CKC_TIPOCTPAGROP_IDTPVRCTPAGAR CHECK (IDTPVRCTPAGAR IN ('LIQUIDO', 'BRUTO'))