paascloud数据库脚本

/* Navicat MySQL Data Transfer Source Server : paascloud-dev Source Server Version : 50719 Source Host : 192.168.241.21:3306 Source Database : paascloud_tpc Target Server Type : MYSQL Target Server Version : 50719 File Encoding : 65001 Date: 2018-03-19 16:19:10 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for JOB_EXECUTION_LOG -- ---------------------------- DROP TABLE IF EXISTS `JOB_EXECUTION_LOG`; CREATE TABLE `JOB_EXECUTION_LOG` ( `id` varchar(40) NOT NULL, `job_name` varchar(100) NOT NULL, `task_id` varchar(255) NOT NULL, `hostname` varchar(255) NOT NULL, `ip` varchar(50) NOT NULL, `sharding_item` int(11) NOT NULL, `execution_source` varchar(20) NOT NULL, `failure_cause` varchar(4000) DEFAULT NULL, `is_success` int(11) NOT NULL, `start_time` timestamp NULL DEFAULT NULL, `complete_time` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='任务表'; -- ---------------------------- -- Records of JOB_EXECUTION_LOG -- ---------------------------- INSERT INTO `JOB_EXECUTION_LOG` VALUES ('0df08216-5406-42db-a86a-d7b831588616', 'com.paascloud.provider.job.simple.HandleUserJwtTokenJob', 'com.paascloud.provider.job.simple.HandleUserJwtTokenJob@-@0@-@READY@-@192.168.32.191@-@24512', 'passcloud-pc', '192.168.32.191', '0', 'NORMAL_TRIGGER', null, '1', '2018-03-02 10:33:00', '2018-03-02 10:33:00'); INSERT INTO `JOB_EXECUTION_LOG` VALUES ('0df2bc60-93fa-4b07-a265-ca56bd614c44', 'com.paascloud.provider.job.dataflow.HandleUserTokenJob', 'com.paascloud.provider.job.dataflow.HandleUserTokenJob@-@0@-@READY@-@192.168.1.13@-@636', 'passcloud-pc', '192.168.1.13', '0', 'NORMAL_TRIGGER', null, '1', '2018-02-18 13:40:00', '2018-02-18 13:40:00'); INSERT INTO `JOB_EXECUTION_LOG` VALUES ('0df44156-6a94-4577-b63a-7cfb3780a707', 'com.paascloud.provider.job.dataflow.HandleWaitingConfirmMessageJob', 'com.paascloud.provider.job.dataflow.HandleWaitingConfirmMessageJob@-@0@-@READY@-@192.168.1.13@-@2508', 'passcloud-pc', '192.168.1.13', '0', 'NORMAL_TRIGGER', null, '1', '2018-02-15 22:10:00', '2018-02-15 22:10:00'); INSERT INTO `JOB_EXECUTION_LOG` VALUES ('0df6b80e-4881-48dc-87f9-ccf24b0f1304', 'com.paascloud.provider.job.dataflow.HandleSendingMessageJob', 'com.paascloud.provider.job.dataflow.HandleSendingMessageJob@-@0@-@READY@-@192.168.32.191@-@14012', 'passcloud-pc', '192.168.32.191', '0', 'NORMAL_TRIGGER', null, '1', '2018-03-11 10:59:30', '2018-03-11 10:59:30'); INSERT INTO `JOB_EXECUTION_LOG` VALUES ('0e016f2d-9ca7-4649-ae98-fef2adbeb50b', 'com.paascloud.provider.job.simple.HandleUserJwtTokenJob', 'com.paascloud.provider.job.simple.HandleUserJwtTokenJob@-@0@-@READY@-@192.168.1.13@-@26064', 'passcloud-pc', '192.168.1.13', '0', 'NORMAL_TRIGGER', null, '1', '2018-02-18 00:43:00', '2018-02-18 00:43:00'); INSERT INTO `JOB_EXECUTION_LOG` VALUES ('0e038155-1234-423c-b20b-ca43e772fe0f', 'com.paascloud.provider.job.dataflow.HandleSendingMessageJob', 'com.paascloud.provider.job.dataflow.HandleSendingMessageJob@-@0@-@READY@-@192.168.32.191@-@29624', 'passcloud-pc', '192.168.32.191', '0', 'NORMAL_TRIGGER', null, '1', '2018-03-08 00:02:00', '2018-03-08 00:02:00'); INSERT INTO `JOB_EXECUTION_LOG` VALUES ('0e0434f2-845c-456a-acd7-fe3db3087b97', 'com.paascloud.provider.job.dataflow.HandleSendingMessageJob', 'com.paascloud.provider.job.dataflow.HandleSendingMessageJob@-@0@-@READY@-@192.168.1.13@-@21304', 'passcloud-pc', '192.168.1.13', '0', 'NORMAL_TRIGGER', null, '1', '2018-02-21 17:30:00', '2018-02-21 17:30:00'); INSERT INTO `JOB_EXECUTION_LOG` VALUES ('0e0aad7d-6ed0-4a97-81b0-49868dcecb31', 'com.paascloud.provider.job.dataflow.HandleSendingMessageJob', 'com.paascloud.provider.job.dataflow.HandleSendingMessageJob@-@0@-@READY@-@192.168.32.191@-@14012', 'passcloud-pc', '192.168.32.191', '0', 'NORMAL_TRIGGER', null, '1', '2018-03-10 20:57:00', '2018-03-10 20:57:00'); INSERT INTO `JOB_EXECUTION_LOG` VALUES ('0e0e9573-ed6e-444f-998b-ee9aa62c6d99', 'com.paascloud.provider.job.dataflow.HandleSendingMessageJob', 'com.paascloud.provider.job.dataflow.HandleSendingMessageJob@-@0@-@READY@-@192.168.1.13@-@14552', 'passcloud-pc', '192.168.1.13', '0', 'NORMAL_TRIGGER', null, '1', '2018-02-25 11:37:00', '2018-02-25 11:37:00'); INSERT INTO `JOB_EXECUTION_LOG` VALUES ('0e0f15e0-72da-48ab-8bc1-30faebdcb03b', 'com.paascloud.provider.job.simple.HandleUserJwtTokenJob', 'com.paascloud.provider.job.simple.HandleUserJwtTokenJob@-@0@-@READY@-@192.168.32.191@-@24512', 'passcloud-pc', '192.168.32.191', '0', 'NORMAL_TRIGGER', null, '1', '2018-03-02 11:40:00', '2018-03-02 11:40:00'); INSERT INTO `JOB_EXECUTION_LOG` VALUES ('0e19abce-42d3-427f-a63f-4c625abeaf63', 'com.paascloud.provider.job.dataflow.HandleSendingMessageJob', 'com.paascloud.provider.job.dataflow.HandleSendingMessageJob@-@0@-@READY@-@192.168.32.191@-@31116', 'passcloud-pc', '192.168.32.191', '0', 'NORMAL_TRIGGER', null, '1', '2018-03-02 18:34:00', '2018-03-02 18:34:00'); INSERT INTO `JOB_EXECUTION_LOG` VALUES ('0e1a83f7-99c1-456e-9d63-7b57bd209348', 'com.paascloud.provider.job.simple.DeleteRpcProducerMessageJob', 'com.paascloud.provider.job.simple.DeleteRpcProducerMessageJob@-@0@-@READY@-@192.168.1.13@-@19108', 'passcloud-pc', '192.168.1.13', '0', 'NORMAL_TRIGGER', null, '1', '2018-02-21 16:18:00', '2018-02-21 16:18:00'); INSERT INTO `JOB_EXECUTION_LOG` VALUES ('0e1d499f-871d-42cc-bcb6-6654d6c3e470', 'com.paascloud.provider.job.dataflow.HandleSendingMessageJob', 'com.paascloud.provider.job.dataflow.HandleSendingMessageJob@-@0@-@READY@-@192.168.32.191@-@14012', 'passcloud-pc', '192.168.32.191', '0', 'NORMAL_TRIGGER', null, '1', '2018-03-10 22:10:30', '2018-03-10 22:10:30'); INSERT INTO `JOB_EXECUTION_LOG` VALUES ('0e1d750a-5dcd-40f1-a3e3-a0e654b531a2', 'com.paascloud.provider.job.dataflow.HandleSendingMessageJob', 'com.paascloud.provider.job.dataflow.HandleSendingMessageJob@-@0@-@READY@-@192.168.32.191@-@11356', 'passcloud-pc', '192.168.32.191', '0', 'NORMAL_TRIGGER', null, '1', '2018-03-14 16:52:00', '2018-03-14 16:52:00'); INSERT INTO `JOB_EXECUTION_LOG` VALUES ('0e20480f-b223-4080-a73a-3cae2b87dfc2', 'com.paascloud.provider.job.dataflow.HandleSendingMessageJob', 'com.paascloud.provider.job.dataflow.HandleSendingMessageJob@-@0@-@READY@-@192.168.32.191@-@11356', 'passcloud-pc', '192.168.32.191', '0', 'NORMAL_TRIGGER', null, '1', '2018-03-14 22:05:30', '2018-03-14 22:05:30'); INSERT INTO `JOB_EXECUTION_LOG` VALUES ('0e21970e-7380-4fbb-9ce6-802f29969b70', 'com.paascloud.provider.job.dataflow.HandleSendingMessageJob', 'com.paascloud.provider.job.dataflow.HandleSendingMessageJob@-@0@-@READY@-@192.168.1.13@-@21364', 'passcloud-pc', '192.168.1.13', '0', 'NORMAL_TRIGGER', null, '1', '2018-03-10 12:45:30', '2018-03-10 12:45:30'); INSERT INTO `JOB_EXECUTION_LOG` VALUES ('0e251b10-62fc-4063-92de-a2fc7f97a003', 'com.paascloud.provider.job.simple.HandleUserJwtTokenJob', 'com.paascloud.provider.job.simple.HandleUserJwtTokenJob@-@0@-@READY@-@192.168.1.13@-@10024', 'passcloud-pc', '192.168.1.13', '0', 'NORMAL_TRIGGER', null, '1', '2018-02-16 23:49:00', '2018-02-16 23:49:00'); INSERT INTO `JOB_EXECUTION_LOG` VALUES ('0e25bf0d-0345-4d26-88af-faf81f9ca6b2', 'com.paascloud.provider.job.dataflow.HandleSendingMessageJob', 'com.paascloud.provider.job.dataflow.HandleSendingMessageJob@-@0@-@READY@-@192.168.32.191@-@21452', 'passcloud-pc', '192.168.32.191', '0', 'NORMAL_TRIGGER', null, '1', '2018-03-12 18:11:00', '2018-03-12 18:11:00'); INSERT INTO `JOB_EXECUTION_LOG` VALUES ('0e2967aa-ee30-4c38-8ffc-26a097ce7442', 'com.paascloud.provider.job.dataflow.HandleSendingMessageJob', 'com.paascloud.provider.job.dataflow.HandleSendingMessageJob@-@0@-@READY@-@192.168.1.13@-@20436', 'passcloud-pc', '192.168.1.13', '0', 'NORMAL_TRIGGER', null, '1', '2018-02-25 22:42:00', '2018-02-25 22:42:00'); INSERT INTO `JOB_EXECUTION_LOG` VALUES ('0e2a8792-c9ff-42da-a4a8-5f0e6e89cb8b', 'com.paascloud.pro