master

分支 (1)

管理

管理

master

baiding
/
db_baiding.sql

/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50709
Source Host           : localhost:3306
Source Database       : db_baiding

Target Server Type    : MYSQL
Target Server Version : 50709
File Encoding         : 65001

Date: 2015-12-31 12:55:45
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for s_log
-- ----------------------------
DROP TABLE IF EXISTS `s_log`;
CREATE TABLE `s_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `account` varchar(50) DEFAULT NULL,
  `action_time` bigint(20) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `ip` varchar(50) DEFAULT NULL,
  `methods` varchar(255) DEFAULT NULL,
  `oper_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of s_log
-- ----------------------------
INSERT INTO `s_log` VALUES ('1', 'admin', null, '登录成功', '0:0:0:0:0:0:0:1', '登录', '2015-12-31 12:33:19');
INSERT INTO `s_log` VALUES ('2', 'admin', null, '登录成功', '0:0:0:0:0:0:0:1', '登录', '2015-12-31 12:36:34');
INSERT INTO `s_log` VALUES ('3', 'admin', null, '登录成功', '0:0:0:0:0:0:0:1', '登录', '2015-12-31 12:36:38');
INSERT INTO `s_log` VALUES ('4', 'admin', null, '登录成功', '0:0:0:0:0:0:0:1', '登录', '2015-12-31 12:38:41');
INSERT INTO `s_log` VALUES ('5', 'admin', null, '登录成功', '0:0:0:0:0:0:0:1', '登录', '2015-12-31 12:39:45');
INSERT INTO `s_log` VALUES ('6', 'tanghom', null, '登录成功', '0:0:0:0:0:0:0:1', '登录', '2015-12-31 12:41:06');
INSERT INTO `s_log` VALUES ('7', 'tanghom', null, '登录成功', '0:0:0:0:0:0:0:1', '登录', '2015-12-31 12:45:55');
INSERT INTO `s_log` VALUES ('8', 'admin', null, '登录成功', '0:0:0:0:0:0:0:1', '登录', '2015-12-31 12:50:52');

-- ----------------------------
-- Table structure for s_organization
-- ----------------------------
DROP TABLE IF EXISTS `s_organization`;
CREATE TABLE `s_organization` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `description` varchar(255) DEFAULT NULL,
  `is_hide` bit(1) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `pid` bigint(20) DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of s_organization
-- ----------------------------
INSERT INTO `s_organization` VALUES ('1', '技术部', '', '技术部', '0', '1');

-- ----------------------------
-- Table structure for s_resources
-- ----------------------------
DROP TABLE IF EXISTS `s_resources`;
CREATE TABLE `s_resources` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `description` varchar(255) DEFAULT NULL,
  `icon` varchar(50) DEFAULT NULL,
  `is_hide` int(11) DEFAULT NULL,
  `res_key` varchar(50) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `pid` bigint(20) DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `url` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of s_resources
-- ----------------------------
INSERT INTO `s_resources` VALUES ('1', '系统设置', '', '0', 'system', '系统设置', '0', '999', null, '/');
INSERT INTO `s_resources` VALUES ('2', '', '', '0', 'role_set', '角色管理', '1', '3', null, '/role/list.shtml');
INSERT INTO `s_resources` VALUES ('3', '', '', '0', 'user_set', '用户管理', '1', '1', null, '/user/list.shtml');
INSERT INTO `s_resources` VALUES ('4', '', '', '0', 'organzition_set', '部门管理', '1', '2', null, '/organzition/index.shtml');
INSERT INTO `s_resources` VALUES ('5', '', '', '0', 'resources_set', '菜单管理', '1', '4', null, '/resources/list.shtml');

-- ----------------------------
-- Table structure for s_role
-- ----------------------------
DROP TABLE IF EXISTS `s_role`;
CREATE TABLE `s_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `description` varchar(200) DEFAULT NULL,
  `role_key` varchar(50) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of s_role
-- ----------------------------
INSERT INTO `s_role` VALUES ('1', null, 'admin', '管理员');

-- ----------------------------
-- Table structure for s_role_resources
-- ----------------------------
DROP TABLE IF EXISTS `s_role_resources`;
CREATE TABLE `s_role_resources` (
  `role_id` bigint(20) NOT NULL,
  `resources_id` bigint(20) NOT NULL,
  KEY `FK_opcykx8rnoajej2coo4ow6y71` (`resources_id`),
  KEY `FK_6e4dcx92msiidm1yowgsf6wj6` (`role_id`),
  CONSTRAINT `FK_6e4dcx92msiidm1yowgsf6wj6` FOREIGN KEY (`role_id`) REFERENCES `s_role` (`id`),
  CONSTRAINT `FK_opcykx8rnoajej2coo4ow6y71` FOREIGN KEY (`resources_id`) REFERENCES `s_resources` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of s_role_resources
-- ----------------------------
INSERT INTO `s_role_resources` VALUES ('1', '1');
INSERT INTO `s_role_resources` VALUES ('1', '3');
INSERT INTO `s_role_resources` VALUES ('1', '4');
INSERT INTO `s_role_resources` VALUES ('1', '2');
INSERT INTO `s_role_resources` VALUES ('1', '5');

-- ----------------------------
-- Table structure for s_user
-- ----------------------------
DROP TABLE IF EXISTS `s_user`;
CREATE TABLE `s_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `avator` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `locked` int(11) DEFAULT NULL,
  `login_name` varchar(128) DEFAULT NULL,
  `login_pwd` varchar(128) DEFAULT NULL,
  `name` varchar(128) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `pinyin` varchar(128) DEFAULT NULL,
  `sex` varchar(32) DEFAULT NULL,
  `org_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_4u9uk8l8d0hl4kb612nd18e09` (`org_id`),
  CONSTRAINT `FK_4u9uk8l8d0hl4kb612nd18e09` FOREIGN KEY (`org_id`) REFERENCES `s_organization` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of s_user
-- ----------------------------
INSERT INTO `s_user` VALUES ('1', null, null, '0', 'admin', 'e10adc3949ba59abbe56e057f20f883e', '管理员', null, null, '男', '1');
INSERT INTO `s_user` VALUES ('2', null, null, '0', 'tanghom', 'e10adc3949ba59abbe56e057f20f883e', '汤宏', null, 'tanghong', '男', '1');

-- ----------------------------
-- Table structure for s_user_role
-- ----------------------------
DROP TABLE IF EXISTS `s_user_role`;
CREATE TABLE `s_user_role` (
  `user_id` bigint(20) NOT NULL,
  `role_id` bigint(20) NOT NULL,
  KEY `FK_6kp78v4d8o3ron7via6fji0h9` (`role_id`),
  KEY `FK_jxgmm3t1tthrpqn3sr988ci4k` (`user_id`),
  CONSTRAINT `FK_6kp78v4d8o3ron7via6fji0h9` FOREIGN KEY (`role_id`) REFERENCES `s_role` (`id`),
  CONSTRAINT `FK_jxgmm3t1tthrpqn3sr988ci4k` FOREIGN KEY (`user_id`) REFERENCES `s_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of s_user_role
-- ----------------------------
INSERT INTO `s_user_role` VALUES ('1', '1');
INSERT INTO `s_user_role` VALUES ('2', '1');

-- ----------------------------
-- Table structure for t_message
-- ----------------------------
DROP TABLE IF EXISTS `t_message`;
CREATE TABLE `t_message` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `content` text,
  `read_time` datetime DEFAULT NULL,
  `send_time` datetime DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `sender_id` bigint(20) DEFAULT NULL,
  `to_user_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_flakc9nd9issn3ul5pl07o4p6` (`sender_id`),
  KEY `FK_muhy76kahyebn93ahksxk179t` (`to_user_id`),
  CONSTRAINT `FK_flakc9nd9issn3ul5pl07o4p6` FOREIGN KEY (`sender_id`) REFERENCES `s_user` (`id`),
  CONSTRAINT `FK_muhy76kahyebn93ahksxk179t` FOREIGN KEY (`to_user_id`) REFERENCES `s_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_message
-- ----------------------------