ALTER TABLE QRCODELOCALPESQ ADD IDEXIBENUTR VARCHAR2(1) DEFAULT 'S' NOT NULL
/ 
 
ALTER TABLE QRCODELOCALPESQ ADD 
	CONSTRAINT CKC_IDEXIBENUTR_QRCODELOCALPSQ CHECK (IDEXIBENUTR IN ('S','N'))
/

ALTER TABLE QRCODELOCALPESQ ADD IDTAMCARDIMG VARCHAR2(1) DEFAULT 'F' NOT NULL 
/ 

ALTER TABLE QRCODELOCALPESQ ADD  
	CONSTRAINT CKC_IDTAMCARDIMG_QRCODELOCALPQ CHECK (IDTAMCARDIMG IN ('F','H'))
/

ALTER TABLE APPCONFIG DROP CONSTRAINT CKC_IDAPLICATIVO_APPCONFIG
/

ALTER TABLE AVALIACAOPRATO ADD IDCONSUMO VARCHAR2(1) DEFAULT 'N' NOT NULL
/

ALTER TABLE AVALIACAOPRATO ADD 
	CONSTRAINT CKC_IDCONSUMO_AVALIACAOPRATO CHECK (IDCONSUMO IN ('S','N'))
/
ALTER TABLE APP_USUARIOAPLICATIVO ADD NRQRCODELOCALPESQ NUMBER NULL
/

ALTER TABLE APP_USUARIOAPLICATIVO ADD 
   CONSTRAINT FKMYO00019QRCODELOCALPESQ FOREIGN KEY (NRQRCODELOCALPESQ) 
		REFERENCES QRCODELOCALPESQ (NRQRCODELOCALPESQ)
/
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 FKPLA01229LOCALPESQ FOREIGN KEY (NRLOCALPESQ) 
		REFERENCES LOCALPESQ(NRLOCALPESQ) ON DELETE CASCADE
/

CREATE INDEX PLA01229_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 FKPLA01230LOCALPESQ FOREIGN KEY (NRLOCALPESQ) 
		REFERENCES LOCALPESQ(NRLOCALPESQ) ON DELETE CASCADE 
/

CREATE INDEX PLA01230_FK ON AVALIACAOPRATO (NRLOCALPESQ)
/

ALTER TABLE RESPOSTA ADD IDTIPORESPOSTA VARCHAR2(30)  NULL