tx-manager.sql 1001 B

1234567891011121314151617181920
  1. CREATE DATABASE IF NOT EXISTS `mics_tx-manager` DEFAULT CHARACTER SET = utf8;
  2. Use `mics_tx-manager`;
  3. -- ----------------------------
  4. -- Table structure for tx-manager
  5. -- ----------------------------
  6. DROP TABLE IF EXISTS `t_tx_exception`;
  7. CREATE TABLE `t_tx_exception` (
  8. `id` bigint(20) NOT NULL AUTO_INCREMENT,
  9. `group_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  10. `unit_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  11. `mod_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  12. `transaction_state` tinyint(4) NULL DEFAULT NULL,
  13. `registrar` tinyint(4) NULL DEFAULT NULL,
  14. `remark` varchar(4096) NULL DEFAULT NULL,
  15. `ex_state` tinyint(4) NULL DEFAULT NULL COMMENT '0 未解决 1已解决',
  16. `create_time` datetime(0) NULL DEFAULT NULL,
  17. PRIMARY KEY (`id`) USING BTREE
  18. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;