如何将一个oracle生成的sql文件转换为mysql用的sql文件?

gondor 发布于 2016/05/09 10:19
阅读 933
收藏 0
要保留数据,并且不用安装oracle
加载中
0
gondor
gondor

oracle的sql文件内容如下,不复杂,哪位懂oracle的sql语法的大侠帮忙手动改为mysql用的吧。

/*
Navicat Oracle Data Transfer
Oracle Client Version : 11.2.0.3.0


Source Server         : local
Source Server Version : 100200
Source Host           : 127.0.0.1:1521
Source Schema         : TEST


Target Server Type    : ORACLE
Target Server Version : 100200
File Encoding         : 65001


Date: 2015-12-25 16:38:44
*/




-- ----------------------------
-- Table structure for MENU
-- ----------------------------
DROP TABLE "TEST"."MENU";
CREATE TABLE "TEST"."MENU" (
"MENUID" NUMBER(10) NOT NULL ,
"MENUNAME" VARCHAR2(255 BYTE) NULL ,
"MENUURL" VARCHAR2(255 BYTE) NULL ,
"PARENTID" NUMBER(10) NULL ,
"LEVAL" NUMBER(10) NULL 
)
LOGGING
NOCOMPRESS
NOCACHE


;


-- ----------------------------
-- Records of MENU
-- ----------------------------
INSERT INTO "TEST"."MENU" VALUES ('5', '角色管理', 'rolelist.do', '3', '2');
INSERT INTO "TEST"."MENU" VALUES ('3', '系统管理', '#', '0', '1');
INSERT INTO "TEST"."MENU" VALUES ('4', '用户管理', 'userlist.do', '3', '2');
INSERT INTO "TEST"."MENU" VALUES ('6', '权限管理', 'permissionlist.do', '3', '2');
INSERT INTO "TEST"."MENU" VALUES ('7', '菜单管理', 'menulist.do', '3', '2');
INSERT INTO "TEST"."MENU" VALUES ('8', '日志管理', '#', '0', '1');
INSERT INTO "TEST"."MENU" VALUES ('9', '日志管理', 'loglist.do', '8', '2');


-- ----------------------------
-- Table structure for PERMISSION
-- ----------------------------
DROP TABLE "TEST"."PERMISSION";
CREATE TABLE "TEST"."PERMISSION" (
"PERID" NUMBER(10) NOT NULL ,
"PERNAME" VARCHAR2(200 BYTE) NULL ,
"DESCRIPTION" VARCHAR2(200 BYTE) NULL ,
"PARENTID" NUMBER(10) NULL 
)
LOGGING
NOCOMPRESS
NOCACHE


;


-- ----------------------------
-- Records of PERMISSION
-- ----------------------------
INSERT INTO "TEST"."PERMISSION" VALUES ('1', 'user:*', '用户管理权限', '0');
INSERT INTO "TEST"."PERMISSION" VALUES ('2', 'role:*', '角色管理权限', '0');
INSERT INTO "TEST"."PERMISSION" VALUES ('3', 'permission:*', '权限管理权限', '0');
INSERT INTO "TEST"."PERMISSION" VALUES ('4', 'menu:*', '菜单管理权限', '0');
INSERT INTO "TEST"."PERMISSION" VALUES ('5', 'log:*', '日志管理权限', '0');


-- ----------------------------
-- Table structure for ROLE
-- ----------------------------
DROP TABLE "TEST"."ROLE";
CREATE TABLE "TEST"."ROLE" (
"ROLEID" NUMBER(10) NULL ,
"ROLENAME" VARCHAR2(20 BYTE) NULL ,
"ROLEDESCRIPTION" VARCHAR2(255 BYTE) NULL 
)
LOGGING
NOCOMPRESS
NOCACHE


;


-- ----------------------------
-- Records of ROLE
-- ----------------------------
INSERT INTO "TEST"."ROLE" VALUES ('1', 'admin', '管理员');


-- ----------------------------
-- Table structure for ROLE_MENU
-- ----------------------------
DROP TABLE "TEST"."ROLE_MENU";
CREATE TABLE "TEST"."ROLE_MENU" (
"ID" NUMBER(20) NOT NULL ,
"ROLEID" NUMBER(20) NULL ,
"MENUID" NUMBER(20) NULL 
)
LOGGING
NOCOMPRESS
NOCACHE


;


-- ----------------------------
-- Records of ROLE_MENU
-- ----------------------------
INSERT INTO "TEST"."ROLE_MENU" VALUES ('1', '1', '3');
INSERT INTO "TEST"."ROLE_MENU" VALUES ('2', '1', '4');
INSERT INTO "TEST"."ROLE_MENU" VALUES ('3', '1', '5');
INSERT INTO "TEST"."ROLE_MENU" VALUES ('4', '1', '6');
INSERT INTO "TEST"."ROLE_MENU" VALUES ('5', '1', '7');
INSERT INTO "TEST"."ROLE_MENU" VALUES ('6', '1', '8');
INSERT INTO "TEST"."ROLE_MENU" VALUES ('7', '1', '9');


-- ----------------------------
-- Table structure for ROLE_PERMISSION
-- ----------------------------
DROP TABLE "TEST"."ROLE_PERMISSION";
CREATE TABLE "TEST"."ROLE_PERMISSION" (
"ID" NUMBER(10) NOT NULL ,
"PERID" NUMBER(10) NULL ,
"ROLEID" NUMBER(10) NULL 
)
LOGGING
NOCOMPRESS
NOCACHE


;


-- ----------------------------
-- Records of ROLE_PERMISSION
-- ----------------------------
INSERT INTO "TEST"."ROLE_PERMISSION" VALUES ('1', '1', '1');
INSERT INTO "TEST"."ROLE_PERMISSION" VALUES ('2', '2', '1');
INSERT INTO "TEST"."ROLE_PERMISSION" VALUES ('3', '3', '1');
INSERT INTO "TEST"."ROLE_PERMISSION" VALUES ('4', '4', '1');
INSERT INTO "TEST"."ROLE_PERMISSION" VALUES ('5', '5', '1');


-- ----------------------------
-- Table structure for SYS_LOG
-- ----------------------------
DROP TABLE "TEST"."SYS_LOG";
CREATE TABLE "TEST"."SYS_LOG" (
"ID" NUMBER(20) NOT NULL ,
"DESCRIPTION" VARCHAR2(255 BYTE) NULL ,
"METHOD" VARCHAR2(255 BYTE) NULL ,
"TYPE" VARCHAR2(10 BYTE) NULL ,
"IP" VARCHAR2(20 BYTE) NULL ,
"EXCEPTIONCODE" VARCHAR2(255 BYTE) NULL ,
"EXCEPTIONDETAIL" VARCHAR2(255 BYTE) NULL ,
"PARAMS" VARCHAR2(255 BYTE) NULL ,
"USERNAME" VARCHAR2(100 BYTE) NULL ,
"CREATEDATE" DATE NULL 
)
LOGGING
NOCOMPRESS
NOCACHE


;


-- ----------------------------
-- Records of SYS_LOG
-- ----------------------------
INSERT INTO "TEST"."SYS_LOG" VALUES ('45', '删除用户', 'com.shiro.controller.UserController.deleteUser()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-08-28 08:41:24', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('41', '查看所有的角色', 'com.shiro.controller.RoleController.findAllRoles()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-08-28 08:31:39', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('44', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-08-28 08:40:32', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('48', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-08-28 09:06:57', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('49', '删除用户', 'com.shiro.controller.UserController.deleteUser()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-08-28 09:07:05', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('50', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-08-28 09:14:49', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('51', '删除用户', 'com.shiro.controller.UserController.deleteUser()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-08-28 09:14:56', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('66', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-08-28 09:58:48', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('522', '查看所有的权限', 'com.shiro.controller.PermissionController.queryAllPermission()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-07 11:05:09', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('523', '查看所有的日志', 'com.shiro.controller.LogController.queryAllLog()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-07 11:05:10', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('521', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-07 11:05:06', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('485', '查看所有的日志', 'com.shiro.controller.LogController.queryAllLog()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-01 13:06:58', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('483', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-01 13:06:56', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('484', '查看所有的权限', 'com.shiro.controller.PermissionController.queryAllPermission()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-01 13:06:58', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('501', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-06 08:38:41', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('502', '查看所有的权限', 'com.shiro.controller.PermissionController.queryAllPermission()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-06 08:38:44', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('503', '查看所有的日志', 'com.shiro.controller.LogController.queryAllLog()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-06 08:38:45', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('469', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-01 11:07:51', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('470', '查看所有的权限', 'com.shiro.controller.PermissionController.queryAllPermission()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-01 11:07:55', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('471', '查看所有的日志', 'com.shiro.controller.LogController.queryAllLog()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-01 11:07:56', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('472', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-01 11:07:57', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('476', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-01 12:41:00', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('477', '查看所有的权限', 'com.shiro.controller.PermissionController.queryAllPermission()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-01 12:41:02', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('478', '查看所有的日志', 'com.shiro.controller.LogController.queryAllLog()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-01 12:41:04', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('479', '查看所有的日志', 'com.shiro.controller.LogController.queryAllLog()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-01 12:41:05', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('480', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-01 12:44:01', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('481', '查看所有的权限', 'com.shiro.controller.PermissionController.queryAllPermission()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-01 12:44:03', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('482', '查看所有的日志', 'com.shiro.controller.LogController.queryAllLog()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-01 12:44:03', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('504', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-06 08:41:13', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('505', '查看所有的日志', 'com.shiro.controller.LogController.queryAllLog()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-06 08:41:14', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('509', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-06 16:50:16', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('510', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-06 16:52:55', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('449', '查看所有的权限', 'com.shiro.controller.PermissionController.queryAllPermission()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-08-31 15:34:59', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('450', '查看所有的日志', 'com.shiro.controller.LogController.queryAllLog()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-08-31 15:35:00', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('448', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-08-31 15:34:57', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('451', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-08-31 16:42:59', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('452', '查看所有的日志', 'com.shiro.controller.LogController.queryAllLog()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-08-31 16:43:01', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('453', '查看所有的权限', 'com.shiro.controller.PermissionController.queryAllPermission()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-08-31 16:43:13', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('506', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-06 08:44:07', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('507', '查看所有的权限', 'com.shiro.controller.PermissionController.queryAllPermission()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-06 08:44:10', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('508', '查看所有的日志', 'com.shiro.controller.LogController.queryAllLog()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-06 08:44:11', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('511', '查看所有的权限', 'com.shiro.controller.PermissionController.queryAllPermission()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-06 16:52:58', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('512', '查看所有的日志', 'com.shiro.controller.LogController.queryAllLog()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-06 16:52:58', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('467', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-01 08:49:04', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('468', '查看所有的权限', 'com.shiro.controller.PermissionController.queryAllPermission()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-01 08:49:05', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('447', '查看所有的日志', 'com.shiro.controller.LogController.queryAllLog()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-08-31 13:23:40', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('462', '查看所有的权限', 'com.shiro.controller.PermissionController.queryAllPermission()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-01 08:45:14', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('463', '查看所有的日志', 'com.shiro.controller.LogController.queryAllLog()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-01 08:45:15', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('461', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-01 08:45:12', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('466', '查看所有的日志', 'com.shiro.controller.LogController.queryAllLog()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-01 08:46:35', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('464', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-01 08:46:33', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('465', '查看所有的权限', 'com.shiro.controller.PermissionController.queryAllPermission()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-01 08:46:34', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('473', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-01 12:35:54', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('474', '查看所有的权限', 'com.shiro.controller.PermissionController.queryAllPermission()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-01 12:35:56', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('475', '查看所有的日志', 'com.shiro.controller.LogController.queryAllLog()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-09-01 12:35:56', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('574', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 15:24:26', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('575', '查看所有的角色', 'com.shiro.controller.RoleController.findAllRoles()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 15:24:31', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('576', '查看所有的权限', 'com.shiro.controller.PermissionController.queryAllPermission()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 15:24:32', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('577', '查看所有的权限', 'com.shiro.controller.PermissionController.queryAllPermission()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 15:25:14', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('578', '查看所有的角色', 'com.shiro.controller.RoleController.findAllRoles()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 15:25:15', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('579', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 15:25:16', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('541', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 14:43:03', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('542', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 14:43:35', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('543', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 14:43:39', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('544', '查看所有的角色', 'com.shiro.controller.RoleController.findAllRoles()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 14:44:56', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('545', '查看所有的角色', 'com.shiro.controller.RoleController.findAllRoles()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 14:44:59', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('546', '查看所有的权限', 'com.shiro.controller.PermissionController.queryAllPermission()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 14:46:57', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('547', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 14:47:13', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('548', '查看所有的角色', 'com.shiro.controller.RoleController.findAllRoles()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 14:47:19', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('549', '查看所有的权限', 'com.shiro.controller.PermissionController.queryAllPermission()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 14:47:22', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('550', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 14:47:26', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('551', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 14:47:39', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('552', '查看所有的角色', 'com.shiro.controller.RoleController.findAllRoles()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 14:47:42', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('553', '查看所有的权限', 'com.shiro.controller.PermissionController.queryAllPermission()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 14:53:49', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('554', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 14:55:01', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('555', '删除用户', 'com.shiro.controller.UserController.deleteUser()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 14:55:09', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('556', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 14:55:42', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('557', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 14:58:02', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('558', '查看所有的角色', 'com.shiro.controller.RoleController.findAllRoles()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 14:58:07', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('559', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 15:00:04', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('560', '查看所有的角色', 'com.shiro.controller.RoleController.findAllRoles()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 15:00:06', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('561', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 15:00:08', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('562', '查看所有的角色', 'com.shiro.controller.RoleController.findAllRoles()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 15:00:10', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('563', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 15:00:14', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('564', '查看所有的角色', 'com.shiro.controller.RoleController.findAllRoles()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 15:00:18', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('565', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 15:00:25', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('566', '查看所有的角色', 'com.shiro.controller.RoleController.findAllRoles()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 15:00:27', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('567', '查看所有的权限', 'com.shiro.controller.PermissionController.queryAllPermission()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 15:00:30', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('568', '查看所有的权限', 'com.shiro.controller.PermissionController.queryAllPermission()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 15:01:21', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('569', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 15:23:13', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('570', '查看所有的角色', 'com.shiro.controller.RoleController.findAllRoles()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 15:23:15', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('571', '查看所有的权限', 'com.shiro.controller.PermissionController.queryAllPermission()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 15:23:16', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('572', '查看所有的权限', 'com.shiro.controller.PermissionController.queryAllPermission()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 15:23:23', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('573', '查看所有的权限', 'com.shiro.controller.PermissionController.queryAllPermission()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-21 15:24:01', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('581', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-22 15:16:46', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('582', '查看所有的角色', 'com.shiro.controller.RoleController.findAllRoles()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-22 15:16:55', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('583', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-22 15:17:37', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('584', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-22 15:17:49', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('585', '查看所有的权限', 'com.shiro.controller.PermissionController.queryAllPermission()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-22 15:17:54', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('586', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-22 15:18:01', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('587', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-22 15:18:58', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('588', '查看所有的角色', 'com.shiro.controller.RoleController.findAllRoles()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-22 15:18:59', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('589', '查看所有的权限', 'com.shiro.controller.PermissionController.queryAllPermission()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-22 15:19:00', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('590', '查看所有的权限', 'com.shiro.controller.PermissionController.queryAllPermission()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-22 15:19:07', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('591', '查看所有的权限', 'com.shiro.controller.PermissionController.queryAllPermission()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-22 15:19:10', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('592', '查看所有的权限', 'com.shiro.controller.PermissionController.queryAllPermission()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-22 15:19:14', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('593', '查看所有的权限', 'com.shiro.controller.PermissionController.queryAllPermission()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-22 15:19:31', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('594', '查看所有的角色', 'com.shiro.controller.RoleController.findAllRoles()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-22 15:19:44', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('595', '查看所有的角色', 'com.shiro.controller.RoleController.findAllRoles()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-22 15:19:55', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "TEST"."SYS_LOG" VALUES ('596', '查询所有的用户', 'com.shiro.controller.UserController.queryAllUsers()', '0', '127.0.0.1', null, null, null, 'admin', TO_DATE('2015-12-22 15:20:05', 'YYYY-MM-DD HH24:MI:SS'));


-- ----------------------------
-- Table structure for TEST_USER
-- ----------------------------
DROP TABLE "TEST"."TEST_USER";
CREATE TABLE "TEST"."TEST_USER" (
"ID" NUMBER(10) NOT NULL ,
"USERNAME" VARCHAR2(50 BYTE) NULL ,
"PASSWORD" VARCHAR2(50 BYTE) NULL 
)
LOGGING
NOCOMPRESS
NOCACHE


;


-- ----------------------------
-- Records of TEST_USER
-- ----------------------------
INSERT INTO "TEST"."TEST_USER" VALUES ('1', 'admin', '111');


-- ----------------------------
-- Table structure for USER_ROLE
-- ----------------------------
DROP TABLE "TEST"."USER_ROLE";
CREATE TABLE "TEST"."USER_ROLE" (
"USERID" NUMBER(10) NULL ,
"ROLEID" NUMBER(10) NULL ,
"ID" NUMBER(10) NOT NULL 
)
LOGGING
NOCOMPRESS
NOCACHE


;


-- ----------------------------
-- Records of USER_ROLE
-- ----------------------------
INSERT INTO "TEST"."USER_ROLE" VALUES ('1', '1', '1');


-- ----------------------------
-- Indexes structure for table MENU
-- ----------------------------


-- ----------------------------
-- Checks structure for table MENU
-- ----------------------------
ALTER TABLE "TEST"."MENU" ADD CHECK ("MENUID" IS NOT NULL);


-- ----------------------------
-- Primary Key structure for table MENU
-- ----------------------------
ALTER TABLE "TEST"."MENU" ADD PRIMARY KEY ("MENUID");


-- ----------------------------
-- Indexes structure for table PERMISSION
-- ----------------------------


-- ----------------------------
-- Checks structure for table PERMISSION
-- ----------------------------
ALTER TABLE "TEST"."PERMISSION" ADD CHECK ("PERID" IS NOT NULL);
ALTER TABLE "TEST"."PERMISSION" ADD CHECK (PERID IS NOT NULL);


-- ----------------------------
-- Primary Key structure for table PERMISSION
-- ----------------------------
ALTER TABLE "TEST"."PERMISSION" ADD PRIMARY KEY ("PERID");


-- ----------------------------
-- Indexes structure for table ROLE_MENU
-- ----------------------------


-- ----------------------------
-- Checks structure for table ROLE_MENU
-- ----------------------------
ALTER TABLE "TEST"."ROLE_MENU" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "TEST"."ROLE_MENU" ADD CHECK (id IS NOT NULL);


-- ----------------------------
-- Primary Key structure for table ROLE_MENU
-- ----------------------------
ALTER TABLE "TEST"."ROLE_MENU" ADD PRIMARY KEY ("ID");


-- ----------------------------
-- Indexes structure for table ROLE_PERMISSION
-- ----------------------------


-- ----------------------------
-- Checks structure for table ROLE_PERMISSION
-- ----------------------------
ALTER TABLE "TEST"."ROLE_PERMISSION" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "TEST"."ROLE_PERMISSION" ADD CHECK (ID IS NOT NULL);


-- ----------------------------
-- Primary Key structure for table ROLE_PERMISSION
-- ----------------------------
ALTER TABLE "TEST"."ROLE_PERMISSION" ADD PRIMARY KEY ("ID");


-- ----------------------------
-- Indexes structure for table SYS_LOG
-- ----------------------------


-- ----------------------------
-- Triggers structure for table SYS_LOG
-- ----------------------------
CREATE OR REPLACE TRIGGER "TEST"."SYS_LOG_TRIGGER" BEFORE INSERT ON "TEST"."SYS_LOG" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW WHEN (new.id is null)
BEGIN
  select sys_log_seq.nextval into :new.id from dual;  
END;
-- ----------------------------
-- Checks structure for table SYS_LOG
-- ----------------------------
ALTER TABLE "TEST"."SYS_LOG" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "TEST"."SYS_LOG" ADD CHECK (ID IS NOT NULL);


-- ----------------------------
-- Primary Key structure for table SYS_LOG
-- ----------------------------
ALTER TABLE "TEST"."SYS_LOG" ADD PRIMARY KEY ("ID");


-- ----------------------------
-- Indexes structure for table TEST_USER
-- ----------------------------


-- ----------------------------
-- Checks structure for table TEST_USER
-- ----------------------------
ALTER TABLE "TEST"."TEST_USER" ADD CHECK ("ID" IS NOT NULL);


-- ----------------------------
-- Primary Key structure for table TEST_USER
-- ----------------------------
ALTER TABLE "TEST"."TEST_USER" ADD PRIMARY KEY ("ID");


-- ----------------------------
-- Indexes structure for table USER_ROLE
-- ----------------------------


-- ----------------------------
-- Checks structure for table USER_ROLE
-- ----------------------------
ALTER TABLE "TEST"."USER_ROLE" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "TEST"."USER_ROLE" ADD CHECK (ID IS NOT NULL);


-- ----------------------------
-- Primary Key structure for table USER_ROLE
-- ----------------------------
ALTER TABLE "TEST"."USER_ROLE" ADD PRIMARY KEY ("ID");


0
Mx_JHJ
Mx_JHJ
这个不就是oracle的语法吗,还要怎么改
0
Mx_JHJ
Mx_JHJ
只是约束那里要改一下
OSCHINA
登录后可查看更多优质内容
返回顶部
顶部