ALTER TABLE TBSPED_APURACAO
    ADD ID INTEGER;

CREATE SEQUENCE GTBSPED_APURACAO;

UPDATE TBSPED_APURACAO T SET
    T.ID = GEN_ID(GTBSPED_APURACAO, 1)
WHERE
    T.ID IS NULL;
	
ALTER TABLE TBSPED_APURACAO ALTER ID SET NOT NULL;