oracle.sql 454 B

123456789101112
  1. CREATE TABLE tcc_fence_log
  2. (
  3. xid VARCHAR2(128) NOT NULL,
  4. branch_id NUMBER(19) NOT NULL,
  5. action_name VARCHAR2(64) NOT NULL,
  6. status NUMBER(3) NOT NULL,
  7. gmt_create TIMESTAMP(3) NOT NULL,
  8. gmt_modified TIMESTAMP(3) NOT NULL,
  9. PRIMARY KEY (xid, branch_id)
  10. );
  11. CREATE INDEX idx_gmt_modified ON tcc_fence_log (gmt_modified);
  12. CREATE INDEX idx_status ON tcc_fence_log (status);