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) 