oracle 2 mysql_七）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');