forked from HWYWL/script
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathscript_info.sql
More file actions
47 lines (41 loc) · 3.14 KB
/
Copy pathscript_info.sql
File metadata and controls
47 lines (41 loc) · 3.14 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
/*
Navicat MySQL Data Transfer
Source Server : MySQL
Source Server Version : 50720
Source Host : localhost:3306
Source Database : script
Target Server Type : MYSQL
Target Server Version : 50720
File Encoding : 65001
Date: 2018-05-01 01:24:09
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for script_info
-- ----------------------------
DROP TABLE IF EXISTS `script_info`;
CREATE TABLE `script_info` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`path` varchar(255) DEFAULT NULL COMMENT '脚本路径',
`command` varchar(255) DEFAULT NULL COMMENT '命令',
`type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0：linux命令、1：linux shll脚本、2：windows命令、3：windows bat脚本',
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
`enable` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0：启用、1：失效',
`host` varchar(255) DEFAULT NULL COMMENT '远程脚本IP',
`user_name` varchar(255) DEFAULT NULL COMMENT '服务器账号',
`pass_word` varchar(255) DEFAULT NULL COMMENT '服务器密码',
`del` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0：正常使用、-1：已被删除',
`crtTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='用戶表';
-- ----------------------------
-- Records of script_info
-- ----------------------------
INSERT INTO `script_info` VALUES ('1', 'H:/Program Files/nginx-1.13.10/nginx.bat', 'H:/Program Files/nginx-1.13.10/nginx.bat', '3', 'nainx启动脚本', '0', null, null, null, '0', '2018-04-27 17:23:24');
INSERT INTO `script_info` VALUES ('2', 'H:/Program Files/MongoDBServer3.4/inmongod.exe', 'H:/Program Files/MongoDBServer3.4/inmongod.exe', '3', 'MongoDB启动脚本', '0', 'null', 'null', 'null', '-1', '2018-04-27 17:24:09');
INSERT INTO `script_info` VALUES ('3', 'I:/Program Files/elasticsearch-5.5.2-noed1/bin/elasticsearch.bat', 'I:/Program Files/elasticsearch-5.5.2-noed1/bin/elasticsearch.bat', '3', 'elasticsearch-5.5.2-noed1启动脚本', '0', null, null, null, '0', '2018-04-27 17:24:57');
INSERT INTO `script_info` VALUES ('4', 'H:/Program Files/elasticsearch-5.5.2-noed2/inelasticsearch.bat', 'H:/Program Files/elasticsearch-5.5.2-noed2/inelasticsearch.bat', '3', 'elasticsearch-5.5.2-noed2启动脚本', '0', null, null, null, '0', '2018-04-27 17:25:07');
INSERT INTO `script_info` VALUES ('5', 'H:/Program Files/elasticsearch-5.5.2-noed3/inelasticsearch.bat', 'H:/Program Files/elasticsearch-5.5.2-noed3/inelasticsearch.bat', '3', 'elasticsearch-5.5.2-noed3启动脚本', '0', null, null, null, '0', '2018-04-27 17:25:18');
INSERT INTO `script_info` VALUES ('6', null, 'ipconfig', '2', '查看IP地址', '0', null, null, null, '0', '2018-04-30 23:29:58');
INSERT INTO `script_info` VALUES ('7', null, 'ifconfig', '0', '查看IP地址', '0', '111.230.10.220', 'root', '123456', '0', '2018-05-01 00:19:10');
INSERT INTO `script_info` VALUES ('8', '/home/yi/software/tale/tale-cli', 'cd /home/yi/software/tale && ./tale-cli status', '1', '查看Tale博客状态', '0', '111.230.10.220', 'root', '123456', '0', '2018-05-01 00:42:46');