/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 50527
Source Host : localhost:3306
Source Database : test
Target Server Type : MYSQL
Target Server Version : 50527
File Encoding : 65001
Date: 2016-03-18 14:02:21
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for smse_access_permission
-- ----------------------------
DROP TABLE IF EXISTS `smse_access_permission`;
CREATE TABLE `smse_access_permission` (
`ID` varchar(36) NOT NULL,
`NAME` varchar(200) DEFAULT NULL,
`URL` varchar(200) DEFAULT NULL,
`MENU_ID` varchar(36) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of smse_access_permission
-- ----------------------------
INSERT INTO `smse_access_permission` VALUES ('21943DC037B743EDE053433210AC4939', '菜单管理', 'system!initMenu.html', '21943DC037B643EDE053433210AC4939');
INSERT INTO `smse_access_permission` VALUES ('21FAD71BFE984AA1E053433210AC638C', '用户新增页面初始化', 'system!initUserAdd.html', '21FAD71BFE974AA1E053433210AC638C');
INSERT INTO `smse_access_permission` VALUES ('21FAD71BFE994AA1E053433210AC638C', '用户新增数据保存', 'system!saveUserAdd.html', '21FAD71BFE974AA1E053433210AC638C');
INSERT INTO `smse_access_permission` VALUES ('21FAD71BFE9B4AA1E053433210AC638C', '用户列表初始化', 'system!initUserList.html', '21FAD71BFE9A4AA1E053433210AC638C');
INSERT INTO `smse_access_permission` VALUES ('21FAD71BFE9C4AA1E053433210AC638C', '异步加载列表数据', 'system!getUserList.html', '21FAD71BFE9A4AA1E053433210AC638C');
INSERT INTO `smse_access_permission` VALUES ('21FAD71BFE9D4AA1E053433210AC638C', '用户明细页面初始化', 'system!initUserDetail.html', '21FAD71BFE9A4AA1E053433210AC638C');
INSERT INTO `smse_access_permission` VALUES ('21FAD71BFE9E4AA1E053433210AC638C', '用户编辑页面初始化', 'system!initUserEdit.html', '21FAD71BFE9A4AA1E053433210AC638C');
INSERT INTO `smse_access_permission` VALUES ('21FAD71BFE9F4AA1E053433210AC638C', '用户删除', 'system!deleteUser.html', '21FAD71BFE9A4AA1E053433210AC638C');
INSERT INTO `smse_access_permission` VALUES ('21FAD71BFEA04AA1E053433210AC638C', '用户编辑页面数据保存', 'system!saveUserEdit.html', '21FAD71BFE9A4AA1E053433210AC638C');
INSERT INTO `smse_access_permission` VALUES ('21FAD71BFEA24AA1E053433210AC638C', '角色新增页面初始化', 'system!initRoleAdd.html', '21FAD71BFEA14AA1E053433210AC638C');
INSERT INTO `smse_access_permission` VALUES ('21FAD71BFEA34AA1E053433210AC638C', '角色新增页面数据保存', 'system!saveRoleAdd.html', '21FAD71BFEA14AA1E053433210AC638C');
INSERT INTO `smse_access_permission` VALUES ('21FAD71BFEA54AA1E053433210AC638C', '角色列表页面初始化', 'system!initRoleList.html', '21FAD71BFEA44AA1E053433210AC638C');
INSERT INTO `smse_access_permission` VALUES ('21FAD71BFEA64AA1E053433210AC638C', '异步加载角色列表数据', 'system!getRoleList.html', '21FAD71BFEA44AA1E053433210AC638C');
INSERT INTO `smse_access_permission` VALUES ('21FAD71BFEA74AA1E053433210AC638C', '角色明细页面初始化', 'system!initRoleDetail.html', '21FAD71BFEA44AA1E053433210AC638C');
INSERT INTO `smse_access_permission` VALUES ('21FAD71BFEA84AA1E053433210AC638C', '角色编辑页面初始化', 'system!initRoleEdit.html', '21FAD71BFEA44AA1E053433210AC638C');
INSERT INTO `smse_access_permission` VALUES ('21FAD71BFEA94AA1E053433210AC638C', '角色编辑页面数据保存', 'system!saveRoleEdit.html', '21FAD71BFEA44AA1E053433210AC638C');
INSERT INTO `smse_access_permission` VALUES ('21FAD71BFEAA4AA1E053433210AC638C', '角色删除', 'system!deleteRole.html', '21FAD71BFEA44AA1E053433210AC638C');
-- ----------------------------
-- Table structure for smse_menu
-- ----------------------------
DROP TABLE IF EXISTS `smse_menu`;
CREATE TABLE `smse_menu` (
`ID` varchar(36) NOT NULL,
`NAME` varchar(200) DEFAULT NULL,
`URL` varchar(200) DEFAULT NULL,
`ICON` varchar(200) DEFAULT NULL,
`VISIBLE` varchar(200) DEFAULT NULL,
`PID` varchar(36) DEFAULT NULL,
`SORT` int(11) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of smse_menu
-- ----------------------------
INSERT INTO `smse_menu` VALUES ('21943DC037B443EDE053433210AC4939', '系统管理', '', '', '1', null, '9999');
INSERT INTO `smse_menu` VALUES ('21943DC037B643EDE053433210AC4939', '菜单管理', 'system!initMenu.html', '', '1', '21943DC037B443EDE053433210AC4939', '3');
INSERT INTO `smse_menu` VALUES ('21FAD71BFE954AA1E053433210AC638C', '用户管理', '#', '', '1', '21943DC037B443EDE053433210AC4939', '1');
INSERT INTO `smse_menu` VALUES ('21FAD71BFE964AA1E053433210AC638C', '角色管理', '#', '', '1', '21943DC037B443EDE053433210AC4939', '2');
INSERT INTO `smse_menu` VALUES ('21FAD71BFE974AA1E053433210AC638C', '用户新增', 'system!initUserAdd.html', '', '1', '21FAD71BFE954AA1E053433210AC638C', '1');
INSERT INTO `smse_menu` VALUES ('21FAD71BFE9A4AA1E053433210AC638C', '用户列表', 'system!initUserList.html', '', '1', '21FAD71BFE954AA1E053433210AC638C', '2');
INSERT INTO `smse_menu` VALUES ('21FAD71BFEA14AA1E053433210AC638C', '角色新增', 'system!initRoleAdd.html', '', '1', '21FAD71BFE964AA1E053433210AC638C', '1');
INSERT INTO `smse_menu` VALUES ('21FAD71BFEA44AA1E053433210AC638C', '角色列表', 'system!initRoleList.html', '', '1', '21FAD71BFE964AA1E053433210AC638C', '2');
-- ----------------------------
-- Table structure for smse_role
-- ----------------------------
DROP TABLE IF EXISTS `smse_role`;
CREATE TABLE `smse_role` (
`ID` varchar(36) NOT NULL,
`NAME` varchar(200) DEFAULT NULL,
`ROLE` varchar(200) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of smse_role
-- ----------------------------
INSERT INTO `smse_role` VALUES ('21943DC037B343EDE053433210AC4939', '系统管理员', 'root');
-- ----------------------------
-- Table structure for smse_role_menu_link
-- ----------------------------
DROP TABLE IF EXISTS `smse_role_menu_link`;
CREATE TABLE `smse_role_menu_link` (
`ROLE_ID` varchar(36) DEFAULT NULL,
`MENU_ID` varchar(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of smse_role_menu_link
-- ----------------------------
INSERT INTO `smse_role_menu_link` VALUES ('21943DC037B343EDE053433210AC4939', '21FAD71BFE964AA1E053433210AC638C');
INSERT INTO `smse_role_menu_link` VALUES ('21943DC037B343EDE053433210AC4939', '21943DC037B443EDE053433210AC4939');
INSERT INTO `smse_role_menu_link` VALUES ('21943DC037B343EDE053433210AC4939', '21FAD71BFE974AA1E053433210AC638C');
INSERT INTO `smse_role_menu_link` VALUES ('21943DC037B343EDE053433210AC4939', '21FAD71BFE9A4AA1E053433210AC638C');
INSERT INTO `smse_role_menu_link` VALUES ('21943DC037B343EDE053433210AC4939', '21943DC037B643EDE053433210AC4939');
INSERT INTO `smse_role_menu_link` VALUES ('21943DC037B343EDE053433210AC4939', '21FAD71BFE954AA1E053433210AC638C');
INSERT INTO `smse_role_menu_link` VALUES ('21943DC037B343EDE053433210AC4939', '21FAD71BFEA14AA1E053433210AC638C');
INSERT INTO `smse_role_menu_link` VALUES ('21943DC037B343EDE053433210AC4939', '21FAD71BFEA44AA1E053433210AC638C');
-- ----------------------------
-- Table structure for smse_user
-- ----------------------------
DROP TABLE IF EXISTS `smse_user`;
CREATE TABLE `smse_user` (
`ID` varchar(36) NOT NULL,
`NAME` varchar(200) DEFAULT NULL,
`USERNAME` varchar(200) DEFAULT NULL,
`PASSWORD` varchar(200) DEFAULT NULL,
`MOBILE` varchar(200) DEFAULT NULL,
`EMAIL` varchar(200) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of smse_user
-- ----------------------------
INSERT INTO `smse_user` VALUES ('21943DC037B243EDE053433210AC4939', '大木桶', 'root', 'root123', '13478772431', '1007951312@qq.com');
-- ----------------------------
-- Table structure for smse_user_role_link
-- ----------------------------
DROP TABLE IF EXISTS `smse_user_role_link`;
CREATE TABLE `smse_user_role_link` (
`USER_ID` varchar(36) DEFAULT NULL,
`ROLE_ID` varchar(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of smse_user_role_link
-- ----------------------------
INSERT INTO `smse_user_role_link` VALUES ('21943DC037B243EDE053433210AC4939', '21943DC037B343EDE053433210AC4939');
