ALTER TABLE OM_CONFIG_MEDIDA_VARIAVEL ADD IDTPSCRIPT VARCHAR2(3) DEFAULT 'PHP' NOT NULL
/

ALTER TABLE OM_COLETA_MEDIDA_VARIAVEL ADD IDTPSCRIPT VARCHAR2(3) DEFAULT 'PHP' NOT NULL
/

ALTER TABLE OM_PARAM_ORG ADD (
    DSSTRINGCONEXAO VARCHAR2(250),
    DSUSUARIOBANCO  VARCHAR2(100),
    DSSENHABANCO    VARCHAR2(100),
    IDCOLETOR       VARCHAR2(100),
    IDUTWALLET      VARCHAR2(1) DEFAULT 'N' NOT NULL
)
/

CREATE TABLE OM_PARAM_ORG_DEFAULT (
    ID              NUMBER(10) NOT NULL,
    DSSTRINGCONEXAO VARCHAR2(250),
    DSUSUARIOBANCO  VARCHAR2(100),
    DSSENHABANCO    VARCHAR2(100),
    IDCOLETOR       VARCHAR2(100),
    IDUTWALLET      VARCHAR2(1) 			DEFAULT 'N' NOT NULL,
    IDAMBORG        VARCHAR2(1) 			DEFAULT 'S' NOT NULL,
    NRORG           NUMBER 	     			DEFAULT         SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
    DTINCLUSAO      DATE, 
    DTULTATU        DATE, 
    NRORGINCLUSAO   NUMBER          		DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg')		NULL, 
    CDOPERINCLUSAO  VARCHAR2(12), 
    NRORGULTATU     NUMBER          		DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg')		NULL, 
    CDOPERULTATU    VARCHAR2(12), 
    IDATIVO         VARCHAR2(1) DEFAULT 'S' NOT NULL,
    
    CONSTRAINT PK_OM_PARAM_ORG_DEFAULT PRIMARY KEY(ID),
    CONSTRAINT CKC_IDATIVO_OM_PARAM_ORG_DEF CHECK (IDATIVO IN ('S','N'))
)
/