ALTER TABLE LOJA ADD IDCRMBONUS VARCHAR2(1) DEFAULT 'N' NOT NULL
   CONSTRAINT CKC_IDCRMBONUS_LOJA CHECK (IDCRMBONUS IN ('S','N'))
/

ALTER TABLE LOJA ADD CDURLCRMBONUS VARCHAR2(100) NULL
/

ALTER TABLE LOJA ADD CDAUTHCRMBONUS VARCHAR2(100) NULL
/

ALTER TABLE LOJA ADD CDCODECRMBONUS VARCHAR2(100) NULL
/