50619 mysql版本_osmp.sql
/*
Navicat MySQL Data Transfer
Source Server : 10.2.1.46
Source Server Version : 50619
Source Host : 10.2.1.46:3306
Source Database : osmp
Target Server Type : MYSQL
Target Server Version : 50619
File Encoding : 65001
Date: 2016-08-09 15:45:41
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for dataServiceMapping
-- ----------------------------
DROP TABLE IF EXISTS `dataServiceMapping`;
CREATE TABLE `dataServiceMapping` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`bundle` varchar(100) DEFAULT NULL COMMENT '服务所处bundle名称',
`version` varchar(20) DEFAULT NULL COMMENT '服务所处bundle版本号',
`serviceName` varchar(50) DEFAULT NULL COMMENT '服务名称',
`interfaceName` varchar(50) DEFAULT NULL COMMENT '对应接口名称',
`updateTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `seq_interfaceName` (`interfaceName`) USING HASH
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of dataServiceMapping
-- ----------------------------
-- ----------------------------
-- Table structure for dataServices
-- ----------------------------
DROP TABLE IF EXISTS `dataServices`;
CREATE TABLE `dataServices` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`bundle` varchar(100) DEFAULT NULL COMMENT '所在bundle',
`version` varchar(20) DEFAULT NULL COMMENT 'bundle版本号',
`name` varchar(100) DEFAULT NULL COMMENT '服务名称',
`state` tinyint(1) DEFAULT '0' COMMENT '状态,1正常,0异常',
`updateTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`mark` varchar(1000) DEFAULT NULL,
`loadIp` char(15) DEFAULT NULL COMMENT '所在负载服务器地址',
`code` varchar(100) DEFAULT NULL COMMENT 'dataService服务映射接口code',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1491 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of dataServices
-- ----------------------------
INSERT INTO `dataServices` VALUES ('1490', 'osmp-test-service', '1.0.0', 'servicetest', '1', '2016-08-09 09:22:35', '测试DEMO', '', null);
-- ----------------------------
-- Table structure for errorLog
-- ----------------------------
DROP TABLE IF EXISTS `errorLog`;
CREATE TABLE `errorLog` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`bundle` varchar(100) DEFAULT NULL COMMENT '日志来源bundle',
`version` varchar(20) DEFAULT NULL COMMENT '版本号',
`service` varchar(100) DEFAULT NULL COMMENT '日志来源服务',
`message` text COMMENT '内容',
`exception` text COMMENT '异常堆栈信息',
`occurTime` bigint(15) DEFAULT NULL COMMENT '日志发生时间',
`insertTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`loadIp` char(15) DEFAULT NULL COMMENT '负载服务器IP',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of errorLog
-- ----------------------------
-- ----------------------------
-- Table structure for infoLog
-- ----------------------------
DROP TABLE IF EXISTS `infoLog`;
CREATE TABLE `infoLog` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`bundle` varchar(100) DEFAULT NULL COMMENT '日志来源bundle',
`version` varchar(20) DEFAULT NULL COMMENT '版本号',
`service` varchar(100) DEFAULT NULL COMMENT '来源服务',
`message` varchar(5000) DEFAULT NULL COMMENT '内容',
`occurTime` bigint(15) DEFAULT NULL COMMENT '日志发生时间',
`insertTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`loadIp` char(15) DEFAULT NULL COMMENT '负载服务器IP',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of infoLog
-- ----------------------------
-- ----------------------------
-- Table structure for interceptorMapping
-- ----------------------------
DROP TABLE IF EXISTS `interceptorMapping`;
CREATE TABLE `interceptorMapping` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`interceptorBundle` varchar(100) DEFAULT NULL COMMENT '拦截器所处组件版本号',
`interceptorVersion` varchar(20) DEFAULT NULL COMMENT '拦截器所处组件名称',
`interceptorName` varchar(50) DEFAULT NULL COMMENT '拦截器名称',
`serviceBundle` varchar(100) DEFAULT NULL COMMENT '业务服务所处组件名称',
`serviceVersion` varchar(20) DEFAULT NULL COMMENT '业务服务所处组件版本号',
`serviceName` varchar(50) DEFAULT NULL COMMENT '业务服务名称',
`level` int(4) DEFAULT '0' COMMENT '拦截器优先级，值越大级别越高,越先执行',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of interceptorMapping
-- ----------------------------
-- ----------------------------
-- Table structure for interceptors
-- ----------------------------
DROP TABLE IF EXISTS `interceptors`;
CREATE TABLE `interceptors` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`bundle` varchar(100) DEFAULT NULL COMMENT '所在bundle',
`version` varchar(20) DEFAULT NULL COMMENT '版本号',
`name` varchar(50) DEFAULT NULL,
`state` tinyint(1) DEFAULT NULL,
`updateTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`mark` varchar(1000) DEFAULT NULL,
`loadIp` char(15) DEFAULT NULL COMMENT '所在负载服务器地址',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of interceptors
-- ----------------------------
-- ----------------------------
-- Table structure for s_exportconfig
-- ----------------------------
DROP TABLE IF EXISTS `s_exportconfig`;
CREATE TABLE `s_exportconfig` (
`id` varchar(20) NOT NULL DEFAULT '',
`code` varchar(50) DEFAULT NULL,
`filename` varchar(50) DEFAULT NULL,
`tempname` varchar(50) DEFAULT NULL,
`paramtype` varchar(500) DEFAULT NULL,
`paramorder` varchar(500) DEFAULT NULL,
`sqltype` varchar(10) DEFAULT NULL,
`sql` varchar(1024) DEFAULT NULL,
`param` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of s_exportconfig
-- ----------------------------
-- ----------------------------
-- Table structure for t_condition
-- ----------------------------
DROP TABLE IF EXISTS `t_condition`;
CREATE TABLE `t_condition` (
`id` int(11) NOT NULL,
`request_ip` varchar(20) DEFAULT NULL COMMENT '发请求的服务器IP',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_condition
-- ----------------------------
-- ----------------------------
-- Table structure for t_dict
-- ----------------------------
DROP TABLE IF EXISTS `t_dict`;
CREATE TABLE `t_dict` (
`id` varchar(50) NOT NULL,
`code` varchar(50) DEFAULT NULL,
`name` varchar(50) DEFAULT NULL,
`type` int(1) DEFAULT NULL,
`tabName` varchar(50) DEFAULT NULL,
`keyFilde` varchar(50) DEFAULT NULL,
`valueFilde` varchar(50) DEFAULT NULL,
`propertiesFile` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_dict
-- ----------------------------
INSERT INTO `t_dict` VALUES ('412fc0f6-c826-4aeb-bcf7-9899b95ffd29', 'gz', '广州', '1', '', '', '', '');
INSERT INTO `t_dict` VALUES ('48dd16b7-ffe4-4cf1-bc9c-927564ef9296', 'bj', '北京', '1', '', '', '', '');
INSERT INTO `t_dict` VALUES ('49c94311-3242-4d9f-a733-53b244f85af7', '1001', '性别', '1', '', '', '', '');
INSERT INTO `t_dict` VALUES ('4e98d8b0-c4c2-4c3c-8722-3be97d809c88', 'status', '状态', '1', '', '', '', '');
INSERT INTO `t_dict` VALUES ('4ec6d01f-8b2c-4cbd-90a1-768b37f6018b', 'logical', '逻辑条件', '1', '', '', '', '');
INSERT INTO `t_dict` VALUES ('54fe849b-b0a4-49e5-af39-c27557e1689f', 'roleType', '策略类型', '1', '', '', '', '');
INSERT INTO `t_dict` VALUES ('cb210d52-ebcc-4c30-996b-183ac946d74c', 'area', '区域', '1', '', '', '', '');
-- ----------------------------
-- Table structure for t_dict_item
-- ----------------------------
DROP TABLE IF EXISTS `t_dict_item`;
CREATE TABLE `t_dict_item` (
`id` varchar(50) NOT NULL,
`parentCode` varchar(50) DEFAULT NULL,
`name` varchar(50) DEFAULT NULL,
`code` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_dict_item
-- ----------------------------
INSERT INTO `t_dict_item` VALUES ('10a08455-98e1-46db-a391-55fabd52a22e', 'area', '测试', 'manager');
INSERT INTO `t_dict_item` VALUES ('18743ecf-115f-4ed4-a33a-bdfa95d205a8', 'sc', '成都', 'cd');
INSERT INTO `t_dict_item` VALUES ('265bf382-6d77-48db-8448-58b541e0c36a', 'roleType', '服务名称', 'SERVICE');
INSERT INTO `t_dict_item` VALUES ('33dbe54b-01d4-4734-9b3b-7b0d4efd28b2', 'roleType', 'IP', 'IP');
INSERT INTO `t_dict_item` VALUES ('3506e585-1c6a-4d4a-b83f-8e02b03cb6e8', 'logical', '小于', 'less');
INSERT INTO `t_dict_item` VALUES ('37cc6f84-c1c7-4476-b766-393b924b7184', 'logical', '大于', 'great');
INSERT INTO `t_dict_item` VALUES ('42b6440c-102b-47da-a9f9-c7e9ee92e798', 'logical', '小于等于', 'notgreat');
INSERT INTO `t_dict_item` VALUES ('48adbf3a-846b-4ef5-b753-9dfb9f209b44', 'sc', '绵阳', 'my');
INSERT INTO `t_dict_item` VALUES ('5c69c139-8168-46c5-80fb-cfbfcfe22e8f', 'roleType', '请求的URL', 'URL');
INSERT INTO `t_dict_item` VALUES ('6579afbc-6659-48b5-a9fb-970d842dc45a', 'status', '禁止', '0');
INSERT INTO `t_dict_item` VALUES ('75b2e523-8fac-4f8d-bb52-c2c786e8e54d', 'ss', '男', 'nan');
INSERT INTO `t_dict_item` VALUES ('78b90d62-2528-402f-99f8-9ba6f6f699b3', 'area', '广州', 'gz');
INSERT INTO `t_dict_item` VALUES ('7dc57b33-42ea-4e9b-b1a0-5742161e690f', 'area', '重庆', 'cq');
INSERT INTO `t_dict_item` VALUES ('96501fbe-3cf1-410d-bf81-05f3ccea7060', 'sc', '江油', 'JY');
INSERT INTO `t_dict_item` VALUES ('97d10a78-a533-40d6-949f-292a779ed69c', 'gz', '中山市', 'zsj');
INSERT INTO `t_dict_item` VALUES ('99c4b19f-c54b-4ee4-a694-7f64d885eb76', 'logical', '大于等于', 'notless');
INSERT INTO `t_dict_item` VALUES ('a26e4bdd-03b9-45f1-9af7-fd0c386c899b', '1001', '女', '0');
INSERT INTO `t_dict_item` VALUES ('b25abd04-4a33-45ad-a34a-2bb547750e45', 'roleType', '项目名', 'PROJECT');
INSERT INTO `t_dict_item` VALUES ('b9a53d2d-8979-4446-b95b-a4e6dbd42928', 'area', '北京', 'bj');
INSERT INTO `t_dict_item` VALUES ('bbcf7029-1dae-4484-a0ba-1fccf7a6ec4b', 'bj', '北京市', 'bjs');
INSERT INTO `t_dict_item` VALUES ('c011aca9-6547-4e3c-9950-65bf1d0d8c41', 'logical', '等于', 'eq');
INSERT INTO `t_dict_item` VALUES ('dffe0478-f072-445e-a7e3-091bb2ce1fdb', 'roleType', '参数', 'ARGS');
INSERT INTO `t_dict_item` VALUES ('e2c17a6f-c5b6-46df-bffa-923627e09c32', 'sc', 'santai', 'st');
INSERT INTO `t_dict_item` VALUES ('e93e4135-b0b9-4eb0-b514-dc94cbae67dc', 'status', '正常', '1');
INSERT INTO `t_dict_item` VALUES ('ea7b717e-e2ce-449c-9918-2def8876f12e', 'area', '四川', 'sc');
INSERT INTO `t_dict_item` VALUES ('f131021f-5ed4-402e-b47f-cca25d420090', '1001', '男', '1');
INSERT INTO `t_dict_item` VALUES ('fe567490-a27a-4ff2-b23b-641c408d0060', 'logical', '不等于', 'nq');
INSERT INTO `t_dict_item` VALUES ('ffa9ba07-2d21-4c39-b785-49091eaf109b', 'gz', '白云区', 'byc');
-- ----------------------------
-- Table structure for t_properties
-- ----------------------------
DROP TABLE IF EXISTS `t_properties`;
CREATE TABLE `t_properties` (
`ID` varchar(50) NOT NULL,
`PROKEY` varchar(50) DEFAULT NULL,
`PROVALUE` varchar(200) DEFAULT NULL,
`NAME` varchar(50) DEFAULT NULL,
`REMARK` varchar(200) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_properties
-- ----------------------------
INSERT INTO `t_properties` VALUES ('4c664790-d8cf-4b2b-b002-0d234022580b', 'bundleList', 'http://10.34.50.53:8081/system/console/bundles.json', '插件列表获取地址', '');
INSERT INTO `t_properties` VALUES ('5b09b6bf-518a-4ac5-8e39-4f99c49c96c2', 'webpassword', 'smx', 'WEB中间件密码', '');
INSERT INTO `t_properties` VALUES ('70e05816-bf8b-4e34-a907-f0004e4943ae', 'configFresh', 'cxf/config/refresh', '插件容器配置刷新接口', '配置修改后通知容器刷新');
INSERT INTO `t_properties` VALUES ('854502bc-4321-4c1b-9088-54e435697547', 'webuser', 'smx', 'WEB中间件用户名', '');
INSERT INTO `t_properties` VALUES ('e1453c8e-60b1-47e2-8e3f-a42ee47e6133', 'bundleInfo', 'http://10.34.50.53:8081/system/console/bundles/', '插件详细获取地址', '');
-- ----------------------------
-- Table structure for t_servers
-- ----------------------------
DROP TABLE IF EXISTS `t_servers`;
CREATE TABLE `t_servers` (
`ID` varchar(50) NOT NULL,
`SERVER_NAME` varchar(50) DEFAULT NULL COMMENT '服务器名称',
`SERVER_IP` varchar(50) DEFAULT NULL COMMENT 'IP',
`SERVER_PORT` varchar(10) DEFAULT NULL COMMENT 'port',
`SSH_PORT` varchar(10) DEFAULT NULL COMMENT 'SSH端口',
`USER` varchar(20) DEFAULT NULL COMMENT '登陆用户名',
`PASSWORD` varchar(20) DEFAULT NULL COMMENT '密码',
`MANAGE_URL` varchar(50) DEFAULT NULL COMMENT '管理界面URL',
`COMMAND_PATH` varchar(100) DEFAULT NULL,
`STATE` int(5) DEFAULT NULL COMMENT '服务器状态',
`REMARK` varchar(100) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_servers
-- ----------------------------
-- ----------------------------
-- Table structure for t_strategy
-- ----------------------------
DROP TABLE IF EXISTS `t_strategy`;
CREATE TABLE `t_strategy` (
`id` varchar(50) NOT NULL,
`name` varchar(100) DEFAULT '',
`forward_ip` varchar(20) NOT NULL DEFAULT '' COMMENT '转发IP',
`remark` varchar(200) DEFAULT '',
`status` int(5) DEFAULT NULL COMMENT '1:正常 0：禁止',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_strategy
-- ----------------------------
INSERT INTO `t_strategy` VALUES ('05349100-6f51-48d5-bad2-472bdc589319', '限制104', '10.34.39.103', 'ff', '1');
INSERT INTO `t_strategy` VALUES ('3873534f-3171-41f1-ba04-dc0a7b6e4b04', '0013', '192.168.1.102', 'dd', '1');
INSERT INTO `t_strategy` VALUES ('3ca499ce-85d2-42e0-ae3f-162835ffa8f3', '10.34.41.138转发', '10.34.41.138', '测试的', '1');
INSERT INTO `t_strategy` VALUES ('93c2d08a-63ae-499f-8719-00b0c19703db', '灰度', '10.34.39.103', '圧', '1');
INSERT INTO `t_strategy` VALUES ('c49ec3aa-5c63-4400-ac52-6028e579d13e', '转到104', '10.34.39.104', 's ', '1');
INSERT INTO `t_strategy` VALUES ('cc9f1a03-41bc-492e-ba1e-5d080d9dfdfc', '秒杀', '10.34.39.103', 'fdf v', '1');
-- ----------------------------
-- Table structure for t_strategy_condition
-- ----------------------------
DROP TABLE IF EXISTS `t_strategy_condition`;
CREATE TABLE `t_strategy_condition` (
`id` varchar(50) NOT NULL,
`strategy_id` varchar(50) DEFAULT NULL,
`type` varchar(50) NOT NULL DEFAULT '',
`name_key` varchar(50) DEFAULT '',
`judge` varchar(50) NOT NULL DEFAULT '',
`value` varchar(200) DEFAULT '' COMMENT '条件',
`type_remark` varchar(100) DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_strategy_condition
-- ----------------------------
INSERT INTO `t_strategy_condition` VALUES ('044f2762-eb3c-422b-b1ce-361eb5617568', '05349100-6f51-48d5-bad2-472bdc589319', 'ARGS', 'area', 'eq', 'sc', '参数');
INSERT INTO `t_strategy_condition` VALUES ('06daec8c-f007-4e81-9f83-36893ba0503a', '3ca499ce-85d2-42e0-ae3f-162835ffa8f3', 'ARGS', 'area', 'eq', '001', '参数');
INSERT INTO `t_strategy_condition` VALUES ('18b60e48-4e79-4cc5-9a3e-7dd6cc785ce0', '3ca499ce-85d2-42e0-ae3f-162835ffa8f3', 'SERVICE', 'serviceName', 'eq', 'olquery', '服务名称');
INSERT INTO `t_strategy_condition` VALUES ('32b39b1d-af4f-4602-b780-ff0db2288a17', '93c2d08a-63ae-499f-8719-00b0c19703db', 'IP', 'IP', 'eq', '10.34.41.41', 'IP');
INSERT INTO `t_strategy_condition` VALUES ('3a447006-3944-42dd-9887-3558cc14d1a9', 'c49ec3aa-5c63-4400-ac52-6028e579d13e', 'IP', 'IP', 'eq', '10.34.39.52', 'IP');
INSERT INTO `t_strategy_condition` VALUES ('695a5270-2ca6-4c9d-91ae-79a2a97ff313', '93c2d08a-63ae-499f-8719-00b0c19703db', 'ARGS', 'AREA', 'eq', '1001', '参数');
INSERT INTO `t_strategy_condition` VALUES ('7c9d0d74-705d-432d-bfdb-048847873fc4', '3873534f-3171-41f1-ba04-dc0a7b6e4b04', 'IP', 'IP', 'eq', '168.13.2.2', 'IP');
INSERT INTO `t_strategy_condition` VALUES ('82c352c4-26ea-415b-a11e-d206caa88e47', '93c2d08a-63ae-499f-8719-00b0c19703db', 'PROJECT', 'FROM', 'nq', '0078', '项目名');
INSERT INTO `t_strategy_condition` VALUES ('8b7a51f0-dbc8-4200-b91a-ed007af86fff', 'c49ec3aa-5c63-4400-ac52-6028e579d13e', 'ARGS', 'snbid', 'eq', 'jswx-196', '参数');
INSERT INTO `t_strategy_condition` VALUES ('a042229f-2f42-4ce8-b250-1464182e3ec4', '3ca499ce-85d2-42e0-ae3f-162835ffa8f3', 'PROJECT', 'serviceName', 'eq', 'olweb1', '项目名');
INSERT INTO `t_strategy_condition` VALUES ('b7947219-6393-4455-9bd9-459978d0bfde', '05349100-6f51-48d5-bad2-472bdc589319', 'ARGS', 'SNBID', 'nq', 'WANGKPAAD', '参数');
INSERT INTO `t_strategy_condition` VALUES ('c8ed58c6-503a-49e6-9cbc-481e9462e26e', '05349100-6f51-48d5-bad2-472bdc589319', 'ARGS', 'area', 'eq', 'sc', '参数');
INSERT INTO `t_strategy_condition` VALUES ('c92f2283-9a75-409c-a63f-3cc7670ad93b', '05349100-6f51-48d5-bad2-472bdc589319', 'IP', 'IP', 'eq', '10.34.39.59', 'IP');
INSERT INTO `t_strategy_condition` VALUES ('cbad36fe-fe9f-401b-bcdb-f8833e0b4c88', '3ca499ce-85d2-42e0-ae3f-162835ffa8f3', 'IP', 'IP', 'eq', '10.35.39.102', 'IP');
INSERT INTO `t_strategy_condition` VALUES ('cd622695-8d63-436e-8eee-1488fbf059cc', '05349100-6f51-48d5-bad2-472bdc589319', 'ARGS', 'snbid', 'eq', 'jswx-196', '参数');
INSERT INTO `t_strategy_condition` VALUES ('e0dc2a9b-1ded-48de-a30b-c92e0c2eac2a', 'cc9f1a03-41bc-492e-ba1e-5d080d9dfdfc', 'ARGS', 'area', 'eq', 'sc', '参数');
INSERT INTO `t_strategy_condition` VALUES ('e6aaffbe-d5b4-4c2e-8528-38e079d55546', '3873534f-3171-41f1-ba04-dc0a7b6e4b04', 'ARGS', 'snbid', 'eq', 'aaaa', '参数');
INSERT INTO `t_strategy_condition` VALUES ('f155ad56-c86d-4654-8f27-f90e636eebc8', 'cc9f1a03-41bc-492e-ba1e-5d080d9dfdfc', 'SERVICE', 'service', 'eq', 'idservice', '服务名称');
-- ----------------------------
-- Table structure for t_sys_privilege
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_privilege`;
CREATE TABLE `t_sys_privilege` (
`ID` int(10) NOT NULL,
`NAME` varchar(50) DEFAULT NULL,
`URI` varchar(200) DEFAULT NULL,
`ICON` varchar(20) DEFAULT NULL,
`DESCRIPTION` varchar(50) DEFAULT NULL,
`ORD` int(10) DEFAULT NULL,
`PID` int(10) DEFAULT NULL,
`PRSTATE` int(20) DEFAULT NULL,
`TYPE` int(20) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_sys_privilege
-- ----------------------------
INSERT INTO `t_sys_privilege` VALUES ('10', '系统管理', '#', 'pencil', '系统管理', '2', '-1', '1', '1');
INSERT INTO `t_sys_privilege` VALUES ('20', '平台管理', '#', 'folder', '平台管理', '1', '-1', '1', '1');
INSERT INTO `t_sys_privilege` VALUES ('30', '参数设置', '#', 'pie', '系统参数设置', '3', '-1', '1', '1');
INSERT INTO `t_sys_privilege` VALUES ('40', '系统监控', '#', 'folder', '系统监控', '4', '-1', '1', '1');
INSERT INTO `t_sys_privilege` VALUES ('1001', '用户管理', 'user/toList.do', 'pie', '用户管理', '1', '10', '1', '1');
INSERT INTO `t_sys_privilege` VALUES ('1002', '角色管理', 'role/toList.do', 'pie', '角色管理', '2', '10', '1', '1');
INSERT INTO `t_sys_privilege` VALUES ('1003', '字典管理', 'dict/toList.do', 'pie', '字典管理', '3', '10', '1', '1');
INSERT INTO `t_sys_privilege` VALUES ('1004', '资源数据管理', 'properties/toList.do', 'pie', '资源数据管理', '4', '10', '1', '1');
INSERT INTO `t_sys_privilege` VALUES ('1005', '系统配置管理', 'config/toList.do', 'pie', '系统配置管理', '5', '10', '1', '1');
INSERT INTO `t_sys_privilege` VALUES ('2001', '组件管理', 'bundle/toList.do', 'pie', '组件管理', '1', '20', '1', '1');
INSERT INTO `t_sys_privilege` VALUES ('2002', '错误日志', 'errorLog/toList.do', 'pie', '错误日志', '2', '20', '1', '1');
INSERT INTO `t_sys_privilege` VALUES ('2003', 'INFO日志', 'infoLog/toList.do', 'pie', 'INFO日志', '3', '20', '1', '1');
INSERT INTO `t_sys_privilege` VALUES ('2004', '服务器管理', 'servers/toList.do', 'pie', '服务器管理', '4', '20', '1', '1');
INSERT INTO `t_sys_privilege` VALUES ('2005', '接口映射', 'sermapping/toList.do', 'pie', '接口映射', '5', '20', '1', '1');
INSERT INTO `t_sys_privilege` VALUES ('2006', '拦截器映射', 'interceptorMapping/toList.do', 'pie', '拦截器映射', '6', '20', '1', '1');
INSERT INTO `t_sys_privilege` VALUES ('2007', '缓存管理', 'cache/toList.do', 'pie', '缓存管理', '7', '20', '1', '1');
INSERT INTO `t_sys_privilege` VALUES ('2008', '策略管理', 'strategy/toList.do', 'pie', '策略管理', '8', '20', '1', '1');
INSERT INTO `t_sys_privilege` VALUES ('3001', '系统设置', 'sys_config/toConfigPage.do', 'pie', '系统设置', '1', '30', '1', '1');
INSERT INTO `t_sys_privilege` VALUES ('4001', '服务监控', 'services/toList.do', 'pie', '服务监控', '1', '40', '1', '1');
INSERT INTO `t_sys_privilege` VALUES ('4002', '拦截器监控', 'interceptors/toList.do', 'pie', '拦截器监控', '2', '40', '1', '1');
INSERT INTO `t_sys_privilege` VALUES ('4003', 'TEST', 'test/toList.do', 'pie', 'TEST', '3', '40', '1', '1');
INSERT INTO `t_sys_privilege` VALUES ('4004', '服务管理', 'dataService/toList.do', 'pie', '服务管理', '4', '20', '1', '1');
INSERT INTO `t_sys_privilege` VALUES ('4005', '数据库监控', 'dataBase/toList.do', 'pie', '数据库监控', '5', '40', '4', '4');
INSERT INTO `t_sys_privilege` VALUES ('4006', '性能监控', 'performance/toList.do', 'pie', '性能监控', '6', '40', '1', '1');
-- ----------------------------
-- Table structure for tb_role
-- ----------------------------
DROP TABLE IF EXISTS `tb_role`;
CREATE TABLE `tb_role` (
`id` varchar(50) NOT NULL,
`role_name` varchar(30) NOT NULL,
`status` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '1:正常 0：禁用',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tb_role
-- ----------------------------
INSERT INTO `tb_role` VALUES ('0cf81070-90ee-41d8-a82b-ca8337647868', '超级管理', '1');
INSERT INTO `tb_role` VALUES ('692af72f-4f65-465e-b57b-1f5792c4c18b', '测试2', '1');
INSERT INTO `tb_role` VALUES ('d117f5cf-b2fc-44e0-8648-820654f4a7fb', '测试角色', '1');
-- ----------------------------
-- Table structure for tb_role_privilege
-- ----------------------------
DROP TABLE IF EXISTS `tb_role_privilege`;
CREATE TABLE `tb_role_privilege` (
`id` varchar(50) NOT NULL,
`privilege_id` int(10) NOT NULL,
`role_id` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tb_role_privilege
-- ----------------------------
INSERT INTO `tb_role_privilege` VALUES ('1a3ca36d-8ebb-47cc-ba79-a169e6a46b13', '2002', 'd117f5cf-b2fc-44e0-8648-820654f4a7fb');
INSERT INTO `tb_role_privilege` VALUES ('1f33ad1a-fff8-4a12-83cf-eebd7291abd4', '10', '692af72f-4f65-465e-b57b-1f5792c4c18b');
INSERT INTO `tb_role_privilege` VALUES ('20070985-a30f-46e0-822c-5ecac5f812cc', '1003', 'd117f5cf-b2fc-44e0-8648-820654f4a7fb');
INSERT INTO `tb_role_privilege` VALUES ('219b0dd3-db95-481a-b496-5cb414bda4d0', '10', 'd117f5cf-b2fc-44e0-8648-820654f4a7fb');
INSERT INTO `tb_role_privilege` VALUES ('293d6504-ffe1-448b-9445-f41dafe844ac', '2005', 'd117f5cf-b2fc-44e0-8648-820654f4a7fb');
INSERT INTO `tb_role_privilege` VALUES ('3869ce36-3faa-4824-bc3c-0c9c79d37a9c', '2001', 'd117f5cf-b2fc-44e0-8648-820654f4a7fb');
INSERT INTO `tb_role_privilege` VALUES ('3d94ddc3-03ae-4edb-b007-323ab9ed2967', '1001', '692af72f-4f65-465e-b57b-1f5792c4c18b');
INSERT INTO `tb_role_privilege` VALUES ('4389da4a-b1d9-44b4-a1d8-386c02ab200d', '20', 'd117f5cf-b2fc-44e0-8648-820654f4a7fb');
INSERT INTO `tb_role_privilege` VALUES ('6181d96b-f41b-4c14-ba96-5d65c3069783', '4002', '692af72f-4f65-465e-b57b-1f5792c4c18b');
INSERT INTO `tb_role_privilege` VALUES ('b0837534-5445-44b3-9fa6-c9eec576ba09', '2004', 'd117f5cf-b2fc-44e0-8648-820654f4a7fb');
INSERT INTO `tb_role_privilege` VALUES ('d0d31903-37e2-4386-b731-d563de46b083', '4004', '692af72f-4f65-465e-b57b-1f5792c4c18b');
INSERT INTO `tb_role_privilege` VALUES ('d70854b2-09f0-414c-9117-df43afa5edd5', '20', '692af72f-4f65-465e-b57b-1f5792c4c18b');
INSERT INTO `tb_role_privilege` VALUES ('e6c06bc7-b687-4d6d-9230-768619f5d450', '40', '692af72f-4f65-465e-b57b-1f5792c4c18b');
-- ----------------------------
-- Table structure for tb_user
-- ----------------------------
DROP TABLE IF EXISTS `tb_user`;
CREATE TABLE `tb_user` (
`id` varchar(50) NOT NULL,
`name` varchar(100) NOT NULL,
`password` varchar(100) DEFAULT NULL,
`real_name` varchar(50) DEFAULT NULL,
`nick_name` varchar(50) DEFAULT NULL,
`status` tinyint(4) DEFAULT '1' COMMENT '1 正常\r\n 0禁止登录\r\n ',
`create_time` datetime NOT NULL,
`last_update_time` datetime DEFAULT NULL,
`last_login_ip` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tb_user
-- ----------------------------
INSERT INTO `tb_user` VALUES ('0cf81070-90ee-41d8-a82b-ca8337647868', 'admin', '827CCB0EEA8A706C4C34A16891F84E7B', '王哥哥', '砖夜攻城狮', '1', '2015-05-05 11:26:26', '2015-05-05 11:35:43', '10.34.43.59');
INSERT INTO `tb_user` VALUES ('fcdcb12e-7463-4e5c-a628-46be539af5b0', 'cs1', '827CCB0EEA8A706C4C34A16891F84E7B', 'cs1', 'cs1', '1', '2015-05-05 12:34:46', '2015-05-06 17:01:20', '127.0.0.1');
-- ----------------------------
-- Table structure for tb_user_role
-- ----------------------------
DROP TABLE IF EXISTS `tb_user_role`;
CREATE TABLE `tb_user_role` (
`id` varchar(50) NOT NULL,
`role_id` varchar(50) NOT NULL,
`user_id` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tb_user_role
-- ----------------------------
INSERT INTO `tb_user_role` VALUES ('0cf81070-90ee-41d8-a82b-ca8337647868', '0cf81070-90ee-41d8-a82b-ca8337647868', '0cf81070-90ee-41d8-a82b-ca8337647868');
INSERT INTO `tb_user_role` VALUES ('8fd4cac5-459f-45e2-9e27-4015d33cd403', 'd117f5cf-b2fc-44e0-8648-820654f4a7fb', 'fcdcb12e-7463-4e5c-a628-46be539af5b0');
INSERT INTO `tb_user_role` VALUES ('fe22dd25-992a-41b9-af93-11b485b39b7e', '692af72f-4f65-465e-b57b-1f5792c4c18b', 'fcdcb12e-7463-4e5c-a628-46be539af5b0');
DROP TABLE IF EXISTS `demo_user`;
CREATE TABLE `demo_user` (
`id` varchar(50) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`age` varchar(50) DEFAULT NULL,
`remark` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of demo_user
-- ----------------------------
INSERT INTO `demo_user` VALUES ('11', '22', '22', '22');
-- ----------------------------
-- Procedure structure for trunckTable
-- ----------------------------
DROP PROCEDURE IF EXISTS `trunckTable`;
DELIMITER ;;
CREATE DEFINER=`sicent`@`%` PROCEDURE `trunckTable`()
BEGIN
DECLARE done INT DEFAULT 0;
DECLARE tname CHAR(50);
DECLARE cur1 CURSOR FOR SELECT table_name from INFORMATION_SCHEMA.TABLES WHERE table_schema = 'osmp';
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
OPEN cur1;
REPEAT
FETCH cur1 INTO tname;
IF NOT done THEN
set @str=concat('truncate table ', tname);
prepare stmt1 from @str;
execute stmt1;
deallocate prepare stmt1;
END IF;
UNTIL done END REPEAT;
CLOSE cur1;
END
;;
DELIMITER ;
一键复制
编辑
Web IDE
原始数据
按行查看
历史