ALTER TABLE PRODUTO ADD IDTAMANHO VARCHAR2(5)
/

ALTER TABLE AUTOFORNE ADD CDOPERCONFAF VARCHAR2(12) NULL
/

ALTER TABLE ACEITEPEDCOL DROP CONSTRAINT PK_ACEITEPEDCOL
/

CREATE TABLE NOTIFICSUPPLY (
   NRNOTIFICSUPPLY    	VARCHAR2(10)  	NOT NULL,  
   CDFILIAL       		VARCHAR2(4)  	NOT NULL,
   CDOPERADOR     		VARCHAR2(12)  	NOT NULL, 
   NMNOTIFICACAO      	VARCHAR2(200)  	NOT NULL,
   DSTEXTNOTIFIC    	VARCHAR2(2000)  NOT NULL, 
   IDNOTIFICLIDO   		VARCHAR2(1) 	DEFAULT 'N'
		CONSTRAINT CKC_IDNOTIFICLIDO_NOTIFICSUP CHECK (IDNOTIFICLIDO IN ('S','N')),
   IDNOTIFICFAV   		VARCHAR2(1) 	DEFAULT 'N'
		CONSTRAINT CKC_IDNOTIFICFAV_NOTIFICSUP CHECK (IDNOTIFICFAV IN ('S','N')),
   NRORG          		NUMBER 			DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
   IDATIVO        		VARCHAR2(1) 	DEFAULT 'S' NOT NULL 
		CONSTRAINT CKC_IDATIVO_NOTIFICSUPPLY CHECK (IDATIVO IN ('S','N')),
   DTINCLUSAO     		DATE 			NULL,
   DTULTATU       		DATE 			NULL,
   NRORGINCLUSAO  		NUMBER 			DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg')  NULL,
   CDOPERINCLUSAO 		VARCHAR2(12) 	DEFAULT '1' NULL,
   NRORGULTATU    		NUMBER 			DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg')  NULL,
   CDOPERULTATU   		VARCHAR2(12) 	DEFAULT '1',
		CONSTRAINT PK_NOTIFICSUPPLY PRIMARY KEY (NRNOTIFICSUPPLY)
)
/