七）oracle 2 mysql

 

/*
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');