1 创建数据库
CREATE DATABASE IF NOT EXISTS t_system_config DEFAULT CHARSET utf8 COLLATE utf8_general_ci;

2 创建User表
use t_system_config;
DROP TABLE IF EXISTS t_system_user;

create table  if not exists t_system_user
(
   id INT NOT NULL primary key  AUTO_INCREMENT,
   userid VARCHAR(128) NOT NULL,
   username VARCHAR(100) NOT NULL,
   name VARCHAR(100) NOT NULL,
   pwd VARCHAR(100) NOT NULL,
   role INT NOT NULL,
   createtime TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
   token VARCHAR(109) NOT NULL DEFAULT ''   ,
   UNIQUE(userid),
   UNIQUE(username,pwd)
)


User表初始化一条数据
use t_system_config;
insert into t_system_user(userid,username,name,pwd,role)
values('otuDfAxq04hQx1BKjsaNkfkIIFnEwdmdGiSSnYpLFa689bnF5uI1481730028524','root','刘志强','.',1);

3 Product表创建
use t_system_config;
DROP TABLE IF EXISTS t_system_product;

create table  if not exists t_system_product
(
   id INT NOT NULL primary key  AUTO_INCREMENT,
   pid  VARCHAR(128) NOT NULL,
   pname VARCHAR(100) NOT NULL,
   pcode VARCHAR(100) NOT NULL,
   pdesc VARCHAR(200) NOT NULL,  
   createtime TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
   email VARCHAR(1000) NOT NULL DEFAULT '' ,
   mobile VARCHAR(1000) NOT NULL DEFAULT '',
   createBy VARCHAR(128) NOT NULL,
   UNIQUE(pname),
   UNIQUE(pcode)
)

4 组内成员表创建
use t_system_config;
DROP TABLE IF EXISTS t_system_group_member;

create table  if not exists t_system_group_member
(
   id INT NOT NULL primary key  AUTO_INCREMENT,
   userid VARCHAR(128) NOT NULL,
   username VARCHAR(100) NOT NULL,
   name VARCHAR(100) NOT NULL,
   pwd VARCHAR(100) NOT NULL,
   role INT NOT NULL,
   createtime TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
   token VARCHAR(109) NOT NULL DEFAULT ''   ,
   createBy VARCHAR(128) NOT NULL,
   UNIQUE(userid),
   UNIQUE(username,pwd)
)

5 service指标模板
use t_system_config;
DROP TABLE IF EXISTS t_system_service_template;

create table  if not exists t_system_service_template
(
   id INT NOT NULL primary key  AUTO_INCREMENT,
   serviceId VARCHAR(128) NOT NULL,
   serviceName VARCHAR(100) NOT NULL,
   serviceCode VARCHAR(100) NOT NULL,
   description VARCHAR(2000) NOT NULL,  
   createTime TIMESTAMP DEFAULT CURRENT_TIMESTAMP,

   totalCount INT NOT NULL,
   thresholdCount INT NOT NULL,

   succeedRatioThreshold INT NOT NULL,
   averageTimeCostThreshold INT NOT NULL,
   maxTimeCostThreshold INT NOT NULL,
   minTimeCostThreshold INT NOT NULL,
   maxInvokedCount INT NOT NULL,
   minInvokedCount INT NOT NULL,
   
   alarmPeriod INT NOT NULL,

   UNIQUE(serviceId),
   UNIQUE(serviceName),
   UNIQUE(serviceCode)
)

6 产品定制服务参数表
use t_system_config;
DROP TABLE IF EXISTS t_system_product_service_template;

create table  if not exists t_system_product_service_template
(
   id INT NOT NULL primary key  AUTO_INCREMENT,   
   serviceId VARCHAR(128) NOT NULL,
   serviceName VARCHAR(100) NOT NULL,
   serviceCode VARCHAR(100) NOT NULL,
   description VARCHAR(2000) NOT NULL,  
   createTime TIMESTAMP DEFAULT CURRENT_TIMESTAMP,

   totalCount INT NOT NULL,
   thresholdCount INT NOT NULL,

   succeedRatioThreshold INT NOT NULL,
   averageTimeCostThreshold INT NOT NULL,
   maxTimeCostThreshold INT NOT NULL,
   minTimeCostThreshold INT NOT NULL,
   maxInvokedCount INT NOT NULL,
   minInvokedCount INT NOT NULL,
   
   alarmPeriod INT NOT NULL,
   productId VARCHAR(128) NOT NULL COMMENT '产品编码,类似于外键,其它与service_template表完全一致',

   UNIQUE(serviceId),
   UNIQUE(productId,serviceCode)
)