::: tip 注意：

  • Mysql 5.7 +

本文档拿 Centos 8 ， Mysql 8.0 做演示
:::

更新系统

  1. # 更新过无需更新
  2. yum -y update

安装 Mysql

  1. yum install -y @mysql

启动 Mysql

  1. systemctl start mysqld

初始化 Mysql

  1. mysql_secure_installation

mysql1

安装成功验证

  1. [root@VM-8-9-centos ~]# mysql -u root -p 
  2. Enter password: 
  3. Welcome to the MySQL monitor.  Commands end with ; or \g.
  4. Your MySQL connection id is 16
  5. Server version: 8.0.21 Source distribution
  7. Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
  9. Oracle is a registered trademark of Oracle Corporation and/or its
  10. affiliates. Other names may be trademarks of their respective
  11. owners.
  13. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  15. mysql>

允许远程访问

  1. # 设置后方便远程管理数据库
  2. use mysql;
  3. update user set host='%' where user='root';
  4. flush privileges;

防火墙放开

  1. firewall-cmd --add-port=3306/tcp --permanent
  2. firewall-cmd --reload

命令行 导入 SQL

本方法适合没有开启远程访问的用户

  1. # 建立数据库
  2. mysql>create database w5_db;
  4. # 使用数据库
  5. mysql>use w5_db;
  7. # 设置数据库编码
  8. mysql>set names utf8mb4;
  10. # 导入数据，SQL 语句在下面（注意sql文件的路径）
  11. mysql>source /home/w5.sql;

图形 导入 SQL

本方法适合开启远程访问的用户
1.连接 Mysql
mysql2
2.创建 DB
mysql3
3.执行 SQL，SQL语句在下面 （也可以选择右键导入）
mysql4

SQL 语句

  1. -- 请使用 utf8mb4 字符集，utf8mb4_general_ci 排序规则
  2. SET NAMES utf8mb4;
  3. SET FOREIGN_KEY_CHECKS = 0;
  5. -- ----------------------------
  6. -- Table structure for w5_logs
  7. -- ----------------------------
  8. DROP TABLE IF EXISTS `w5_logs`;
  9. CREATE TABLE `w5_logs` (
  10.   `id` int(11) NOT NULL AUTO_INCREMENT,
  11.   `only_id` varchar(30) NOT NULL DEFAULT '',
  12.   `uuid` varchar(100) NOT NULL,
  13.   `app_uuid` varchar(100) NOT NULL,
  14.   `app_name` varchar(20) NOT NULL DEFAULT '',
  15.   `result` text NOT NULL,
  16.   `status` int(2) NOT NULL DEFAULT '0',
  17.   `html` text,
  18.   `args` text,
  19.   `create_time` datetime DEFAULT NULL,
  20.   PRIMARY KEY (`id`)
  21. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  22. -- ----------------------------
  23. -- Records of w5_logs
  24. -- ----------------------------
  27. -- ----------------------------
  28. --  Table structure for `w5_report`
  29. -- ----------------------------
  30. DROP TABLE IF EXISTS `w5_report`;
  31. CREATE TABLE `w5_report` (
  32.   `id` int(11) NOT NULL AUTO_INCREMENT,
  33.   `report_no` varchar(30) NOT NULL DEFAULT '',
  34.   `workflow_name` varchar(50) NOT NULL DEFAULT '',
  35.   `remarks` varchar(255) NOT NULL DEFAULT '',
  36.   `create_time` datetime DEFAULT NULL,
  37.   PRIMARY KEY (`id`)
  38. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  41. CREATE TABLE `w5_timer` (
  42.   `id` int(11) NOT NULL AUTO_INCREMENT,
  43.   `timer_uuid` varchar(100) NOT NULL DEFAULT '',
  44.   `uuid` varchar(100) NOT NULL DEFAULT '',
  45.   `type` varchar(10) NOT NULL DEFAULT '',
  46.   `interval_type` varchar(10) NOT NULL DEFAULT '',
  47.   `time` varchar(50) NOT NULL DEFAULT '',
  48.   `start_date` varchar(50) NOT NULL DEFAULT '',
  49.   `end_date` varchar(50) NOT NULL DEFAULT '',
  50.   `jitter` int(11) NOT NULL DEFAULT '0',
  51.   `status` int(2) NOT NULL DEFAULT '0',
  52.   `update_time` datetime DEFAULT NULL,
  53.   `create_time` datetime DEFAULT NULL,
  54.   PRIMARY KEY (`id`),
  55.   UNIQUE KEY `uid` (`timer_uuid`) USING BTREE
  56. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  59. -- ----------------------------
  60. -- Table structure for w5_setting
  61. -- ----------------------------
  62. DROP TABLE IF EXISTS `w5_setting`;
  63. CREATE TABLE `w5_setting` (
  64.   `id` int(11) NOT NULL AUTO_INCREMENT,
  65.   `key` varchar(255) NOT NULL DEFAULT '',
  66.   `value` varchar(255) NOT NULL DEFAULT '',
  67.   `update_time` datetime DEFAULT NULL,
  68.   `create_time` datetime DEFAULT NULL,
  69.   PRIMARY KEY (`id`),
  70.   UNIQUE KEY `index_key` (`key`) USING BTREE
  71. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;
  73. -- ----------------------------
  74. -- Records of w5_setting
  75. -- ----------------------------
  76. BEGIN;
  77. INSERT INTO `w5_setting` VALUES (1, 'w5_key', '', '2020-12-02 21:16:15', '2020-11-29 00:32:15');
  78. INSERT INTO `w5_setting` VALUES (2, 'api_key', '', '2020-12-05 18:40:05', '2020-12-05 18:14:56');
  79. COMMIT;
  81. -- ----------------------------
  82. -- Table structure for w5_type
  83. -- ----------------------------
  84. DROP TABLE IF EXISTS `w5_type`;
  85. CREATE TABLE `w5_type` (
  86.   `id` int(11) NOT NULL AUTO_INCREMENT,
  87.   `type` int(2) NOT NULL DEFAULT '1',
  88.   `name` varchar(20) NOT NULL DEFAULT '',
  89.   `update_time` datetime DEFAULT NULL,
  90.   `create_time` datetime DEFAULT NULL,
  91.   PRIMARY KEY (`id`)
  92. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;
  94. -- ----------------------------
  95. -- Records of w5_type
  96. -- ----------------------------
  97. BEGIN;
  98. INSERT INTO `w5_type` VALUES (1, 1, '默认剧本', '2020-12-07 11:04:07', '2020-12-07 11:04:09');
  99. INSERT INTO `w5_type` VALUES (2, 2, '默认变量', '2020-12-07 11:04:16', '2020-12-07 11:04:18');
  100. COMMIT;
  102. -- ----------------------------
  103. -- Table structure for w5_users
  104. -- ----------------------------
  105. DROP TABLE IF EXISTS `w5_users`;
  106. CREATE TABLE `w5_users` (
  107.   `id` int(11) NOT NULL AUTO_INCREMENT,
  108.   `account` varchar(20) NOT NULL DEFAULT '',
  109.   `passwd` varchar(32) NOT NULL DEFAULT '',
  110.   `nick_name` varchar(20) NOT NULL DEFAULT '',
  111.   `email` varchar(50) NOT NULL DEFAULT '',
  112.   `token` varchar(32) NOT NULL DEFAULT '',
  113.   `status` int(11) NOT NULL DEFAULT '0',
  114.   `update_time` datetime DEFAULT NULL,
  115.   `create_time` datetime DEFAULT NULL,
  116.   PRIMARY KEY (`id`),
  117.   UNIQUE KEY `index_account` (`account`) USING BTREE
  118. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
  120. -- ----------------------------
  121. -- Records of w5_users
  122. -- ----------------------------
  123. BEGIN;
  124. INSERT INTO `w5_users` VALUES (1, 'admin', 'F38AFA9E15326959EF26DE613E821115', 'W5', 'admin@w5.io', '178E21C9907F568647717A00D004DDC1', 0, '2020-12-07 10:11:28', '2020-12-03 13:57:45');
  125. COMMIT;
  127. -- ----------------------------
  128. -- Table structure for w5_variablen
  129. -- ----------------------------
  130. DROP TABLE IF EXISTS `w5_variablen`;
  131. CREATE TABLE `w5_variablen` (
  132.   `id` int(11) NOT NULL AUTO_INCREMENT,
  133.   `type_id` int(11) NOT NULL DEFAULT '0',
  134.   `key` varchar(20) NOT NULL DEFAULT '',
  135.   `value` varchar(255) NOT NULL DEFAULT '',
  136.   `remarks` varchar(255) NOT NULL DEFAULT '',
  137.   `status` int(11) NOT NULL DEFAULT '0',
  138.   `update_time` datetime DEFAULT NULL,
  139.   `create_time` datetime DEFAULT NULL,
  140.   PRIMARY KEY (`id`),
  141.   UNIQUE KEY `index.key` (`key`) USING BTREE
  142. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  144. -- ----------------------------
  145. -- Records of w5_variablen
  146. -- ----------------------------
  147. BEGIN;
  148. COMMIT;
  150. -- ----------------------------
  151. -- Table structure for w5_version
  152. -- ----------------------------
  153. DROP TABLE IF EXISTS `w5_version`;
  154. CREATE TABLE `w5_version` (
  155.   `id` int(11) NOT NULL AUTO_INCREMENT,
  156.   `name` varchar(255) NOT NULL DEFAULT '',
  157.   `version` varchar(255) NOT NULL DEFAULT '',
  158.   `update_time` datetime DEFAULT NULL,
  159.   PRIMARY KEY (`id`)
  160. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;
  162. -- ----------------------------
  163. -- Records of w5_version
  164. -- ----------------------------
  165. BEGIN;
  166. INSERT INTO `w5_version` VALUES (1, 'w5', '0.2', '2020-12-07 10:10:56');
  167. INSERT INTO `w5_version` VALUES (2, 'apps', '0.2', '2020-12-07 10:10:56');
  168. COMMIT;
  170. -- ----------------------------
  171. -- Table structure for w5_workflow
  172. -- ----------------------------
  173. DROP TABLE IF EXISTS `w5_workflow`;
  174. CREATE TABLE `w5_workflow` (
  175.   `id` int(11) NOT NULL AUTO_INCREMENT,
  176.   `uuid` varchar(100) NOT NULL DEFAULT '',
  177.   `user_id` int(11) NOT NULL DEFAULT '0',
  178.   `type_id` int(11) NOT NULL DEFAULT '0',
  179.   `name` varchar(50) NOT NULL DEFAULT '',
  180.   `remarks` varchar(255) NOT NULL DEFAULT '',
  181.   `status` int(11) NOT NULL DEFAULT '0',
  182.   `start_app` varchar(100) NOT NULL DEFAULT '',
  183.   `end_app` varchar(100) NOT NULL DEFAULT '',
  184.   `input_app` varchar(100) NOT NULL DEFAULT '',
  185.   `webhook_app` varchar(100) NOT NULL DEFAULT '',
  186.   `timer_app` varchar(100) NOT NULL DEFAULT '',
  187.   `flow_json` text NOT NULL,
  188.   `flow_data` text NOT NULL,
  189.   `controller_data` text,
  190.   `local_var_data` text,
  191.   `update_time` datetime DEFAULT NULL,
  192.   `create_time` datetime DEFAULT NULL,
  193.   PRIMARY KEY (`id`),
  194.   UNIQUE KEY `index_uuid` (`uuid`) USING BTREE
  195. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  197. -- ----------------------------
  198. -- Records of w5_workflow
  199. -- ----------------------------
  200. BEGIN;
  201. COMMIT;
  203. SET FOREIGN_KEY_CHECKS = 1;