CREATE TABLE tcc_fence_log ( xid VARCHAR2(128) NOT NULL, branch_id NUMBER(19) NOT NULL, action_name VARCHAR2(64) NOT NULL, status NUMBER(3) NOT NULL, gmt_create TIMESTAMP(3) NOT NULL, gmt_modified TIMESTAMP(3) NOT NULL, PRIMARY KEY (xid, branch_id) ); CREATE INDEX idx_gmt_modified ON tcc_fence_log (gmt_modified); CREATE INDEX idx_status ON tcc_fence_log (status);