HSDataPlatform/UpgradeSentry.sql

/*
SQLyog Ultimate v9.10 
MySQL - 5.5.55-log : Database - hsdataplatform
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`hsdataplatform` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `hsdataplatform`;

/*Table structure for table `admin` */

DROP TABLE IF EXISTS `admin`;

CREATE TABLE `admin` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自动编号',
  `username` varchar(100) DEFAULT NULL COMMENT '用户名',
  `password` varchar(100) DEFAULT NULL COMMENT '密码',
  `salt` varchar(32) DEFAULT NULL COMMENT '盐',
  `showname` varchar(100) DEFAULT NULL COMMENT '显示名称',
  `accountlock` int(11) DEFAULT '0' COMMENT '是否锁定',
  `addtime` datetime DEFAULT NULL COMMENT '注册时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

/*Data for the table `admin` */

insert  into `admin`(`id`,`username`,`password`,`salt`,`showname`,`accountlock`,`addtime`) values (1,'admin','5549b337675c88342b3286d2898217e0','d293c7b755fb04c777ac4e89b5b19464','超级管理员',0,'2017-04-12 14:21:32'),(2,'mtas','5549b337675c88342b3286d2898217e0','d293c7b755fb04c777ac4e89b5b19464','MTAS管理员',0,'2017-04-25 09:08:53'),(3,'cts','5ebaf8cc4eb10b46aaa257303e54d759','1e347f992843f77ee3a2ca882692d6e2','订单管理员',0,NULL),(4,'koala','a633aa39ff9cc972e85bbf4a93ac93a7','44a8f66fd1ee03547e3861f85705aa28','鉴权管理员',0,'2017-04-26 09:20:18');

/*Table structure for table `admin_role` */

DROP TABLE IF EXISTS `admin_role`;

CREATE TABLE `admin_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `roleid` bigint(20) DEFAULT NULL,
  `userid` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;

/*Data for the table `admin_role` */

insert  into `admin_role`(`id`,`roleid`,`userid`) values (1,1,1),(5,4,3),(6,5,3),(7,3,2),(8,6,2),(16,5,13),(17,5,13),(18,5,13);

/*Table structure for table `apply` */

DROP TABLE IF EXISTS `apply`;

CREATE TABLE `apply` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自动编号',
  `projectName` varchar(32) DEFAULT NULL COMMENT '项目名称',
  `secretId` varchar(64) DEFAULT NULL COMMENT '秘钥Id',
  `secretKey` varchar(32) DEFAULT NULL COMMENT '秘钥',
  `apply` varchar(200) DEFAULT NULL COMMENT '申请人',
  `addtime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;

/*Data for the table `apply` */

insert  into `apply`(`id`,`projectName`,`secretId`,`secretKey`,`apply`,`addtime`) values (30,'testproject','zew2SWP1kXwk','61f19seERYHLXTYywJZpezLl4c5Q4ols',NULL,'2018-03-08 10:06:13');

/*Table structure for table `cacheserver` */

DROP TABLE IF EXISTS `cacheserver`;

CREATE TABLE `cacheserver` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '缓存服务器ID',
  `serverip` varchar(15) DEFAULT NULL COMMENT '服务器IP地址',
  `serverdescription` varchar(200) DEFAULT NULL COMMENT '服务器简介',
  `cachetype` int(11) DEFAULT '0' COMMENT '0 redis 1 memcache 2 mongo 3 other',
  `registertime` datetime DEFAULT NULL COMMENT '注册时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `cacheserver` */

insert  into `cacheserver`(`id`,`serverip`,`serverdescription`,`cachetype`,`registertime`) values (1,'192.168.107.112','客户端缓存',1,'2017-04-13 14:47:52'),(2,'192.168.107.112','鉴权服务缓存',0,'2017-04-13 14:48:13');

/*Table structure for table `deployserver` */

DROP TABLE IF EXISTS `deployserver`;

CREATE TABLE `deployserver` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `productioncode` varchar(32) DEFAULT NULL COMMENT '项目唯一标识',
  `productionname` varchar(64) DEFAULT NULL COMMENT '项目名称',
  `serverip` varchar(15) DEFAULT NULL COMMENT '部署服务IP地址',
  `webdomain` varchar(64) DEFAULT NULL COMMENT '网站域名',
  `webdescript` varchar(255) DEFAULT NULL COMMENT '网站描述',
  `webvirtuepath` varchar(32) DEFAULT NULL COMMENT '网站虚拟路径',
  `websitedir` varchar(100) DEFAULT NULL COMMENT '网站物理路径',
  `ftpip` varchar(15) DEFAULT NULL COMMENT '网站FTP地址',
  `ftpport` varchar(10) DEFAULT NULL COMMENT 'ftp端口号',
  `ftpusername` varchar(32) DEFAULT NULL COMMENT 'ftp用户名',
  `ftppassword` varchar(128) DEFAULT NULL COMMENT 'ftp密码',
  `ftppath` varchar(100) DEFAULT NULL COMMENT 'ftp路径',
  `currentversion` varchar(64) DEFAULT NULL COMMENT '当前机器上的版本号',
  `addtime` datetime DEFAULT NULL COMMENT '服务器注册时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `deployserver` */

/*Table structure for table `menu` */

DROP TABLE IF EXISTS `menu`;

CREATE TABLE `menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自动编号',
  `menucode` varchar(32) DEFAULT NULL COMMENT '编码',
  `menuname` varchar(64) DEFAULT NULL COMMENT '标题',
  `menuicon` varchar(32) DEFAULT NULL COMMENT '图标',
  `menuaction` varchar(200) DEFAULT NULL COMMENT '连接',
  `menutype` int(11) DEFAULT '0' COMMENT '0:分组 1:菜单 2:功能 ',
  `menusequence` int(11) DEFAULT '0',
  `menushow` int(11) DEFAULT '1' COMMENT '0:隐藏 1:显示',
  `parentmenu` bigint(20) DEFAULT NULL COMMENT '父级菜单',
  `menushowtype` varchar(16) DEFAULT NULL COMMENT '展现形式',
  `addtime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;

/*Data for the table `menu` */

insert  into `menu`(`id`,`menucode`,`menuname`,`menuicon`,`menuaction`,`menutype`,`menusequence`,`menushow`,`parentmenu`,`menushowtype`,`addtime`) values (8,'cache','缓存中心','fi-laptop','javascript:void(0);',0,2,1,NULL,NULL,'2017-04-13 11:16:23'),(9,'cachelist','缓存管理','fi-usb','/cache/view/profile.action',1,1,1,8,'tab','2017-04-13 11:18:03'),(19,'log','日志管理','fi-social-blogger','javascript:void(0);',0,7,1,NULL,NULL,'2017-11-14 15:40:19'),(20,'mtlog','客户端日志','fi-social-blogger','/log/view/mtlog.action',1,1,1,19,'tab','2017-11-14 15:40:21'),(21,'messagequeue','索引队列','fi-social-blogger','javascript:void(0);',0,8,1,NULL,NULL,'2017-12-06 09:56:04'),(22,'activemq','ActiveMQ','fi-social-blogger','/activemq/view/broker.action',1,1,1,21,'tab','2017-12-06 09:57:01'),(23,'solr','Solr管理','fi-social-blogger','/solr/view/broker.action',1,2,1,21,'tab','2017-12-06 11:16:40'),(29,'applyauth','申请授权','fi-social-blogger','/cts/view/apply.action',1,8,1,1,'tab','2018-03-07 11:10:45');

/*Table structure for table `module_action` */

DROP TABLE IF EXISTS `module_action`;

CREATE TABLE `module_action` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `moduleid` bigint(20) DEFAULT NULL,
  `actionid` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

/*Data for the table `module_action` */

/*Table structure for table `product` */

DROP TABLE IF EXISTS `product`;

CREATE TABLE `product` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `productcode` varchar(32) DEFAULT NULL,
  `productname` varchar(128) DEFAULT NULL,
  `productdomain` varchar(64) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `product` */

/*Table structure for table `product_log` */

DROP TABLE IF EXISTS `product_log`;

CREATE TABLE `product_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自动编号',
  `productname` varchar(100) DEFAULT NULL COMMENT '产品名称',
  `logcontent` varchar(500) DEFAULT NULL COMMENT '日志内容',
  `productnum` varchar(100) DEFAULT NULL COMMENT '显示名称',
  `addtime` varchar(100) DEFAULT NULL COMMENT '添加时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `product_log` */

/*Table structure for table `queueserver` */

DROP TABLE IF EXISTS `queueserver`;

CREATE TABLE `queueserver` (
  `serverid` bigint(20) NOT NULL AUTO_INCREMENT,
  `servername` varchar(256) DEFAULT NULL,
  `servercode` varchar(64) DEFAULT NULL,
  `serverip` varchar(15) DEFAULT NULL,
  `port` int(11) DEFAULT '1099',
  `broker` varchar(64) DEFAULT 'localhost',
  `userproperties` varchar(256) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  PRIMARY KEY (`serverid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `queueserver` */

insert  into `queueserver`(`serverid`,`servername`,`servercode`,`serverip`,`port`,`broker`,`userproperties`,`addtime`) values (1,'107-112','107-112','192.168.107.112',8161,'localhost','9456b9f2d2b2faec31087c739653185c','2017-12-06 10:49:27'),(2,'100-150','10-150','192.168.100.150',8161,'localhost','9456b9f2d2b2faec31087c739653185c','2017-12-06 10:49:50');

/*Table structure for table `role_module` */

DROP TABLE IF EXISTS `role_module`;

CREATE TABLE `role_module` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `roleid` bigint(20) DEFAULT NULL,
  `moduleid` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8;

/*Data for the table `role_module` */

insert  into `role_module`(`id`,`roleid`,`moduleid`) values (8,1,8),(9,1,9);

/*Table structure for table `role_module_action` */

DROP TABLE IF EXISTS `role_module_action`;

CREATE TABLE `role_module_action` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `rolemoduleid` bigint(20) DEFAULT NULL,
  `actionid` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

/*Data for the table `role_module_action` */

/*Table structure for table `securekey` */

DROP TABLE IF EXISTS `securekey`;

CREATE TABLE `securekey` (
  `SecureKeyID` bigint(20) NOT NULL AUTO_INCREMENT,
  `UserName` varchar(255) DEFAULT NULL COMMENT '用户名',
  `SecureKey` varchar(64) DEFAULT NULL COMMENT '绑定的卡',
  `BindDateTime` datetime DEFAULT NULL COMMENT '绑定时间',
  `CycleStep` int(11) DEFAULT '0' COMMENT '循环布数',
  `SecureKeyType` int(11) DEFAULT '0' COMMENT '0:口令卡 1:动态口令',
  `SyncDateTime` datetime DEFAULT NULL COMMENT '上次同步时间',
  `ExpiresDateTime` datetime DEFAULT NULL COMMENT '过期时间',
  PRIMARY KEY (`SecureKeyID`),
  UNIQUE KEY `IDX_USERNAME` (`UserName`),
  KEY `IDX_SECUREKEY` (`SecureKey`),
  KEY `IDX_EXPIREDATETIME` (`ExpiresDateTime`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

/*Data for the table `securekey` */

insert  into `securekey`(`SecureKeyID`,`UserName`,`SecureKey`,`BindDateTime`,`CycleStep`,`SecureKeyType`,`SyncDateTime`,`ExpiresDateTime`) values (1,'admin','1000180201155542938','2018-02-01 15:56:08',0,0,'2018-02-01 15:55:42','2019-02-01 15:56:08');

/*Table structure for table `sentry_action` */

DROP TABLE IF EXISTS `sentry_action`;

CREATE TABLE `sentry_action` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `actioncode` varchar(16) DEFAULT NULL,
  `actionname` varchar(64) DEFAULT NULL,
  `actionico` varchar(16) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

/*Data for the table `sentry_action` */

insert  into `sentry_action`(`id`,`actioncode`,`actionname`,`actionico`,`addtime`) values (1,'view','浏览',NULL,'2017-04-20 09:03:16'),(2,'add','添加',NULL,'2017-04-20 09:03:32'),(3,'edit','修改',NULL,'2017-04-20 09:03:46'),(4,'delete','删除',NULL,'2017-04-20 09:04:08');

/*Table structure for table `sentry_role` */

DROP TABLE IF EXISTS `sentry_role`;

CREATE TABLE `sentry_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `rolecode` varchar(16) DEFAULT NULL,
  `rolename` varchar(64) DEFAULT NULL,
  `parentid` bigint(20) DEFAULT NULL,
  `addtiime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

/*Data for the table `sentry_role` */

insert  into `sentry_role`(`id`,`rolecode`,`rolename`,`parentid`,`addtiime`) values (1,'admin','管理员',NULL,'2017-04-20 09:00:32'),(2,'cts','订单中心',NULL,'2017-04-24 14:20:45'),(3,'mtas-developer','客户端API',NULL,'2017-04-24 14:21:04'),(4,'cts-product','产品组',2,'2017-04-24 15:19:07'),(5,'cts-developer','开发组',2,'2017-04-24 15:42:03'),(6,'mtas-developer','开发组',3,'2017-04-24 16:42:13'),(7,'mtas-product','产品组',3,'2017-04-24 16:42:45'),(8,'koala','鉴权中心',NULL,'2017-04-25 14:45:03'),(9,'koala-developer','开发组',8,'2017-04-25 14:47:53'),(11,'mtas-push','消息推送',NULL,'2017-10-12 16:34:58'),(13,'push-developer','开发组',11,'2017-10-12 16:36:52'),(15,'push-producter','产品组',11,'2017-10-12 16:37:24'),(16,'kefu','客服人员',NULL,'2017-12-29 16:11:41'),(17,'kefuzu','客服组',16,'2017-12-29 16:12:26');

/*Table structure for table `solrserver` */

DROP TABLE IF EXISTS `solrserver`;

CREATE TABLE `solrserver` (
  `solrsid` bigint(20) NOT NULL AUTO_INCREMENT,
  `solrcode` varchar(64) DEFAULT NULL,
  `solrname` varchar(256) DEFAULT NULL,
  `solrip` varchar(15) DEFAULT NULL,
  `solrservice` varchar(512) DEFAULT NULL,
  `solrentities` varchar(512) DEFAULT NULL,
  `addtime` datetime DEFAULT NULL,
  PRIMARY KEY (`solrsid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

/*Data for the table `solrserver` */

insert  into `solrserver`(`solrsid`,`solrcode`,`solrname`,`solrip`,`solrservice`,`solrentities`,`addtime`) values (1,'107-112','Solr-107-112','192.168.107.112','http://192.168.107.112:8080/solr','bianke:wenji;mt:magazine;favorites:collection','2017-12-07 10:43:50');

/*Table structure for table `user_module` */

DROP TABLE IF EXISTS `user_module`;

CREATE TABLE `user_module` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `userid` bigint(20) DEFAULT NULL,
  `moduleid` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `user_module` */

/*Table structure for table `versionfile` */

DROP TABLE IF EXISTS `versionfile`;

CREATE TABLE `versionfile` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `productcode` varchar(32) DEFAULT NULL COMMENT '产品标识',
  `version` varchar(64) DEFAULT NULL COMMENT '版本号',
  `filename` varchar(64) DEFAULT NULL COMMENT '产品文件名',
  `filepath` varchar(255) DEFAULT NULL COMMENT '存放路径',
  `addtime` datetime DEFAULT NULL COMMENT '添加日期',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `versionfile` */

insert  into `versionfile`(`id`,`productcode`,`version`,`filename`,`filepath`,`addtime`) values (1,'cnkicmps','V1.0','cmps201704181427','D:/website','2017-04-18 14:27:31'),(2,'cnkicmps','V1.0.1','cmps201704181500','D:/website','2017-04-18 14:30:42');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;