CREATE TABLE PARAMHTTPGERAL 
(
 CDPARHTTPGER 		VARCHAR2(2) 	NOT NULL,
 NRORG                       	NUMBER 		DEFAULT 	 SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
 IDATIVO                    	VARCHAR2(1)     	DEFAULT 'S' NOT NULL
	CONSTRAINT CKC_IDATIVO_PARAMHTTPGERAL 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',
 IDUTPARAMHTTPGER 	VARCHAR2(1) DEFAULT 'S'
    CONSTRAINT CKC_IDUTPARAMHTTPGER CHECK (IDUTPARAMHTTPGER IS NULL OR (IDUTPARAMHTTPGER IN ('S','N'))),
 HTTPHOSADDR		VARCHAR2(1000),
 HTTPPORT 		VARCHAR2(6),
 IDUTHTTPPROXY 		INTEGER,
 HTTPPROXYHOST 		VARCHAR2(1000),
 HTTPPROXYPORT 		VARCHAR2(6),
 HTTPPROXYUSERID 	VARCHAR2(100),
 HTTPHTTPS 		INTEGER,
 CONSTRAINT PK_PARAMHTTPGERAL PRIMARY KEY (CDPARHTTPGER)
) 
/

CREATE TABLE PARAMHTTPFILIAL
(
 CDFILIAL VARCHAR2(2) NOT NULL,
 NRORG                       	NUMBER 		DEFAULT 	 SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
 IDATIVO                    	VARCHAR2(1)     	DEFAULT 'S' NOT NULL
	CONSTRAINT CKC_IDATIVO_PARAMHTTPFILIAL 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',
 HTTPHOSADDR 		VARCHAR2(1000),
 HTTPPORT 		VARCHAR2(6),
 IDUTHTTPPROXY 		INTEGER,
 HTTPPROXYHOST 		VARCHAR2(1000),
 HTTPPROXYPORT 		VARCHAR2(6),
 HTTPPROXYUSERID 	VARCHAR2(100),
 HTTPHTTPS 		INTEGER,
	CONSTRAINT PK_PARAMHTTPFILIAL PRIMARY KEY (CDFILIAL)
) 
/