CREATE TABLE GPAYQUICKPASS (
    MERCHANTID          VARCHAR2(500),
    MERCHANTNAME        VARCHAR2(500),
    GATEWAY             VARCHAR2(500),
    GATEWAYMERCHANTID   VARCHAR2(500),
    AUTHMETHODS         VARCHAR2(500),
    CARDNETWORKS        VARCHAR2(500),
    NRORG               NUMBER 	      DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') 		NOT NULL,
    IDATIVO             VARCHAR2(1)     DEFAULT 'S'					NOT NULL,
    DTINCLUSAO          DATE            DEFAULT SYSDATE,
    DTULTATU            DATE            DEFAULT SYSDATE,
    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 CKC_IDATIVO_GPAYQUICKPASS CHECK (IDATIVO IN ('S','N'))
)

/
INSERT INTO GPAYQUICKPASS (MERCHANTID,MERCHANTNAME,GATEWAY,GATEWAYMERCHANTID,AUTHMETHODS,CARDNETWORKS) 
    VALUES (NULL,NULL,NULL,NULL,'PAN_ONLY;CRYPTOGRAM_3DS','AMEX;DISCOVER;INTERAC;JCB;MASTERCARD;VISA')
/
COMMIT
/