K8S 搭建 Pinpoint (三、部署 MySQL5.7)

这里只给出 sql 语句

CREATE DATABASE /*!32312 IF NOT EXISTS*/`pinpoint` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `pinpoint`;

DROP TABLE IF EXISTS `BATCH_JOB_EXECUTION`;

CREATE TABLE `BATCH_JOB_EXECUTION` (
  `JOB_EXECUTION_ID` bigint(20) NOT NULL,
  `VERSION` bigint(20) DEFAULT NULL,
  `JOB_INSTANCE_ID` bigint(20) NOT NULL,
  `CREATE_TIME` datetime NOT NULL,
  `START_TIME` datetime DEFAULT NULL,
  `END_TIME` datetime DEFAULT NULL,
  `STATUS` varchar(10) DEFAULT NULL,
  `EXIT_CODE` varchar(2500) DEFAULT NULL,
  `EXIT_MESSAGE` varchar(2500) DEFAULT NULL,
  `LAST_UPDATED` datetime DEFAULT NULL,
  `JOB_CONFIGURATION_LOCATION` varchar(2500) DEFAULT NULL,
  PRIMARY KEY (`JOB_EXECUTION_ID`),
  KEY `JOB_INST_EXEC_FK` (`JOB_INSTANCE_ID`),
  CONSTRAINT `JOB_INST_EXEC_FK` FOREIGN KEY (`JOB_INSTANCE_ID`) REFERENCES `BATCH_JOB_INSTANCE` (`JOB_INSTANCE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `BATCH_JOB_EXECUTION` */

/*Table structure for table `BATCH_JOB_EXECUTION_CONTEXT` */

DROP TABLE IF EXISTS `BATCH_JOB_EXECUTION_CONTEXT`;

CREATE TABLE `BATCH_JOB_EXECUTION_CONTEXT` (
  `JOB_EXECUTION_ID` bigint(20) NOT NULL,
  `SHORT_CONTEXT` varchar(2500) NOT NULL,
  `SERIALIZED_CONTEXT` text,
  PRIMARY KEY (`JOB_EXECUTION_ID`),
  CONSTRAINT `JOB_EXEC_CTX_FK` FOREIGN KEY (`JOB_EXECUTION_ID`) REFERENCES `BATCH_JOB_EXECUTION` (`JOB_EXECUTION_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `BATCH_JOB_EXECUTION_CONTEXT` */

/*Table structure for table `BATCH_JOB_EXECUTION_PARAMS` */

DROP TABLE IF EXISTS `BATCH_JOB_EXECUTION_PARAMS`;

CREATE TABLE `BATCH_JOB_EXECUTION_PARAMS` (
  `JOB_EXECUTION_ID` bigint(20) NOT NULL,
  `TYPE_CD` varchar(6) NOT NULL,
  `KEY_NAME` varchar(100) NOT NULL,
  `STRING_VAL` varchar(250) DEFAULT NULL,
  `DATE_VAL` datetime DEFAULT NULL,
  `LONG_VAL` bigint(20) DEFAULT NULL,
  `DOUBLE_VAL` double DEFAULT NULL,
  `IDENTIFYING` char(1) NOT NULL,
  KEY `JOB_EXEC_PARAMS_FK` (`JOB_EXECUTION_ID`),
  CONSTRAINT `JOB_EXEC_PARAMS_FK` FOREIGN KEY (`JOB_EXECUTION_ID`) REFERENCES `BATCH_JOB_EXECUTION` (`JOB_EXECUTION_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `BATCH_JOB_EXECUTION_PARAMS` */

/*Table structure for table `BATCH_JOB_EXECUTION_SEQ` */

DROP TABLE IF EXISTS `BATCH_JOB_EXECUTION_SEQ`;

CREATE TABLE `BATCH_JOB_EXECUTION_SEQ` (
  `ID` bigint(20) NOT NULL,
  `UNIQUE_KEY` char(1) NOT NULL,
  UNIQUE KEY `UNIQUE_KEY_UN` (`UNIQUE_KEY`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `BATCH_JOB_EXECUTION_SEQ` */

insert  into `BATCH_JOB_EXECUTION_SEQ`(`ID`,`UNIQUE_KEY`) values 
(0,'0');

/*Table structure for table `BATCH_JOB_INSTANCE` */

DROP TABLE IF EXISTS `BATCH_JOB_INSTANCE`;

CREATE TABLE `BATCH_JOB_INSTANCE` (
  `JOB_INSTANCE_ID` bigint(20) NOT NULL,
  `VERSION` bigint(20) DEFAULT NULL,
  `JOB_NAME` varchar(100) NOT NULL,
  `JOB_KEY` varchar(32) NOT NULL,
  PRIMARY KEY (`JOB_INSTANCE_ID`),
  UNIQUE KEY `JOB_INST_UN` (`JOB_NAME`,`JOB_KEY`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `BATCH_JOB_INSTANCE` */

/*Table structure for table `BATCH_JOB_SEQ` */

DROP TABLE IF EXISTS `BATCH_JOB_SEQ`;

CREATE TABLE `BATCH_JOB_SEQ` (
  `ID` bigint(20) NOT NULL,
  `UNIQUE_KEY` char(1) NOT NULL,
  UNIQUE KEY `UNIQUE_KEY_UN` (`UNIQUE_KEY`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `BATCH_JOB_SEQ` */

insert  into `BATCH_JOB_SEQ`(`ID`,`UNIQUE_KEY`) values 
(0,'0');

/*Table structure for table `BATCH_STEP_EXECUTION` */

DROP TABLE IF EXISTS `BATCH_STEP_EXECUTION`;

CREATE TABLE `BATCH_STEP_EXECUTION` (
  `STEP_EXECUTION_ID` bigint(20) NOT NULL,
  `VERSION` bigint(20) NOT NULL,
  `STEP_NAME` varchar(100) NOT NULL,
  `JOB_EXECUTION_ID` bigint(20) NOT NULL,
  `START_TIME` datetime NOT NULL,
  `END_TIME` datetime DEFAULT NULL,
  `STATUS` varchar(10) DEFAULT NULL,
  `COMMIT_COUNT` bigint(20) DEFAULT NULL,
  `READ_COUNT` bigint(20) DEFAULT NULL,
  `FILTER_COUNT` bigint(20) DEFAULT NULL,
  `WRITE_COUNT` bigint(20) DEFAULT NULL,
  `READ_SKIP_COUNT` bigint(20) DEFAULT NULL,
  `WRITE_SKIP_COUNT` bigint(20) DEFAULT NULL,
  `PROCESS_SKIP_COUNT` bigint(20) DEFAULT NULL,
  `ROLLBACK_COUNT` bigint(20) DEFAULT NULL,
  `EXIT_CODE` varchar(2500) DEFAULT NULL,
  `EXIT_MESSAGE` varchar(2500) DEFAULT NULL,
  `LAST_UPDATED` datetime DEFAULT NULL,
  PRIMARY KEY (`STEP_EXECUTION_ID`),
  KEY `JOB_EXEC_STEP_FK` (`JOB_EXECUTION_ID`),
  CONSTRAINT `JOB_EXEC_STEP_FK` FOREIGN KEY (`JOB_EXECUTION_ID`) REFERENCES `BATCH_JOB_EXECUTION` (`JOB_EXECUTION_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `BATCH_STEP_EXECUTION` */

/*Table structure for table `BATCH_STEP_EXECUTION_CONTEXT` */

DROP TABLE IF EXISTS `BATCH_STEP_EXECUTION_CONTEXT`;

CREATE TABLE `BATCH_STEP_EXECUTION_CONTEXT` (
  `STEP_EXECUTION_ID` bigint(20) NOT NULL,
  `SHORT_CONTEXT` varchar(2500) NOT NULL,
  `SERIALIZED_CONTEXT` text,
  PRIMARY KEY (`STEP_EXECUTION_ID`),
  CONSTRAINT `STEP_EXEC_CTX_FK` FOREIGN KEY (`STEP_EXECUTION_ID`) REFERENCES `BATCH_STEP_EXECUTION` (`STEP_EXECUTION_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `BATCH_STEP_EXECUTION_CONTEXT` */

/*Table structure for table `BATCH_STEP_EXECUTION_SEQ` */

DROP TABLE IF EXISTS `BATCH_STEP_EXECUTION_SEQ`;

CREATE TABLE `BATCH_STEP_EXECUTION_SEQ` (
  `ID` bigint(20) NOT NULL,
  `UNIQUE_KEY` char(1) NOT NULL,
  UNIQUE KEY `UNIQUE_KEY_UN` (`UNIQUE_KEY`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `BATCH_STEP_EXECUTION_SEQ` */

insert  into `BATCH_STEP_EXECUTION_SEQ`(`ID`,`UNIQUE_KEY`) values 
(0,'0');

/*Table structure for table `agent_statistics` */

DROP TABLE IF EXISTS `agent_statistics`;

CREATE TABLE `agent_statistics` (
  `agent_count` int(10) unsigned NOT NULL,
  `date_val` datetime NOT NULL,
  PRIMARY KEY (`date_val`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `agent_statistics` */

/*Table structure for table `alarm_history` */

DROP TABLE IF EXISTS `alarm_history`;

CREATE TABLE `alarm_history` (
  `history_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `rule_id` int(10) unsigned NOT NULL,
  `application_id` varchar(30) NOT NULL,
  `checker_name` varchar(50) NOT NULL,
  `detected` char(1) DEFAULT NULL,
  `sequence_count` int(10) DEFAULT NULL,
  `timing_count` int(10) DEFAULT NULL,
  PRIMARY KEY (`history_id`),
  KEY `application_id_checker_name_idx` (`application_id`,`checker_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `alarm_history` */

/*Table structure for table `alarm_rule` */

DROP TABLE IF EXISTS `alarm_rule`;

CREATE TABLE `alarm_rule` (
  `rule_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `application_id` varchar(30) NOT NULL,
  `service_type` varchar(30) NOT NULL,
  `checker_name` varchar(50) NOT NULL,
  `threshold` int(10) DEFAULT NULL,
  `user_group_id` varchar(30) NOT NULL,
  `sms_send` char(1) DEFAULT NULL,
  `email_send` char(1) DEFAULT NULL,
  `notes` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`rule_id`),
  KEY `application_id_checker_name_user_group_id_idx` (`application_id`,`user_group_id`,`checker_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `alarm_rule` */

/*Table structure for table `puser` */

DROP TABLE IF EXISTS `puser`;

CREATE TABLE `puser` (
  `number` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` varchar(30) NOT NULL,
  `name` varchar(150) NOT NULL,
  `department` varchar(150) NOT NULL,
  `phonenumber` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`number`),
  UNIQUE KEY `user_id_idx` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `puser` */

/*Table structure for table `user_group` */

DROP TABLE IF EXISTS `user_group`;

CREATE TABLE `user_group` (
  `number` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id` varchar(30) NOT NULL,
  PRIMARY KEY (`number`),
  UNIQUE KEY `id_idx` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `user_group` */

/*Table structure for table `user_group_member` */

DROP TABLE IF EXISTS `user_group_member`;

CREATE TABLE `user_group_member` (
  `number` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_group_id` varchar(30) NOT NULL,
  `member_id` varchar(30) NOT NULL,
  PRIMARY KEY (`number`),
  UNIQUE KEY `user_group_id_member_id_idx` (`user_group_id`,`member_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;