15sys_check_chain.sql 1.4 KB

1234567891011121314151617181920212223242526272829303132333435
  1. USE `cnbg_20240511_001`;
  2. SET NAMES utf8mb4;
  3. SET FOREIGN_KEY_CHECKS = 0;
  4. -- ----------------------------
  5. -- Table structure for sys_check_chain
  6. -- ----------------------------
  7. DROP TABLE IF EXISTS `sys_check_chain`;
  8. CREATE TABLE `sys_check_chain`
  9. (
  10. `chain_id` INT AUTO_INCREMENT COMMENT 'Id',
  11. `chain_name` VARCHAR(64) NOT NULL COMMENT '审批链名称',
  12. `node_qty` VARCHAR(64) NOT NULL COMMENT '节点数',
  13. `del_flag` VARCHAR(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
  14. `create_by` VARCHAR(64) NOT NULL DEFAULT 'admin' COMMENT '创建人',
  15. `update_by` VARCHAR(64) NOT NULL DEFAULT 'admin' COMMENT '修改人',
  16. `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  17. `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  18. PRIMARY KEY `pk_id` (`chain_id`) USING BTREE,
  19. UNIQUE KEY `uk_name` (`chain_name`) USING BTREE
  20. ) ENGINE = InnoDB
  21. COMMENT ='审批链';
  22. -- ----------------------------
  23. -- Records of sys_check_chain
  24. -- ----------------------------
  25. BEGIN;
  26. INSERT INTO sys_check_chain (chain_id, chain_name, node_qty, del_flag, create_by, update_by, create_time, update_time)
  27. VALUES (1, '中生营销行为证据链审批流', '6', '0', 'admin', 'admin', '2024-05-22 10:26:23', '2024-05-22 10:26:23');
  28. COMMIT;
  29. SET FOREIGN_KEY_CHECKS = 1;