/* * Copyright 2019-2029 geekidea(https://github.com/geekidea) * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ create table IP ( ID NUMBER(20) not null constraint IP_PK primary key, IP_START VARCHAR2(15) not null, IP_END VARCHAR2(15) not null, AREA VARCHAR2(100) not null, OPERATOR VARCHAR2(200) not null, IP_START_NUM NUMBER(20) not null, IP_END_NUM NUMBER(20) not null ) / create table SYS_LOG ( LOG_ID NUMBER(20) not null constraint SYS_LOG_PK primary key, TYPE NUMBER(1), CONTENT VARCHAR2(255), CREATE_ID NUMBER(20), CREATE_TIME DATE default sysdate ) / comment on table SYS_LOG is '系统日志' / comment on column SYS_LOG.LOG_ID is '主键' / comment on column SYS_LOG.CONTENT is '内容' / comment on column SYS_LOG.CREATE_ID is '创建人ID' / comment on column SYS_LOG.CREATE_TIME is '创建时间' / create table FOO_BAR ( ID NUMBER(20) not null constraint FOO_BAR_PK primary key, NAME VARCHAR2(20) not null, FOO VARCHAR2(20), BAR VARCHAR2(20) not null, REMARK VARCHAR2(200), STATE NUMBER(11) default '1', VERSION NUMBER(11) default '0', CREATE_TIME DATE default sysdate, UPDATE_TIME DATE ) / comment on table FOO_BAR is 'FooBar' / comment on column FOO_BAR.ID is '主键' / comment on column FOO_BAR.NAME is '名称' / comment on column FOO_BAR.FOO is 'Foo' / comment on column FOO_BAR.BAR is 'Bar' / comment on column FOO_BAR.REMARK is '备注' / comment on column FOO_BAR.STATE is '状态，0：禁用，1：启用' / comment on column FOO_BAR.VERSION is '版本' / comment on column FOO_BAR.CREATE_TIME is '创建时间' / comment on column FOO_BAR.UPDATE_TIME is '修改时间' / create table SYS_DEPARTMENT ( ID NUMBER(20) not null, NAME VARCHAR2(32) not null, PARENT_ID NUMBER(20), "LEVEL" NUMBER(2), STATE NUMBER(11) default '1', SORT NUMBER(11) default '0', REMARK VARCHAR2(200), VERSION NUMBER(11) default '0', CREATE_TIME DATE default sysdate, UPDATE_TIME DATE ) / comment on table SYS_DEPARTMENT is '部门' / comment on column SYS_DEPARTMENT.ID is '主键' / comment on column SYS_DEPARTMENT.NAME is '部门名称' / comment on column SYS_DEPARTMENT.PARENT_ID is '父id' / comment on column SYS_DEPARTMENT."LEVEL" is '部门层级' / comment on column SYS_DEPARTMENT.STATE is '状态，0：禁用，1：启用' / comment on column SYS_DEPARTMENT.SORT is '排序' / comment on column SYS_DEPARTMENT.REMARK is '备注' / comment on column SYS_DEPARTMENT.VERSION is '版本' / comment on column SYS_DEPARTMENT.CREATE_TIME is '创建时间' / comment on column SYS_DEPARTMENT.UPDATE_TIME is '修改时间' / create unique index SYS_DEPARTMENT_NAME_UINDEX on SYS_DEPARTMENT (NAME) / create table SYS_USER ( ID NUMBER(20) not null constraint SYS_USER_PK primary key, USERNAME VARCHAR2(20) not null, NICKNAME VARCHAR2(20), PASSWORD VARCHAR2(64) not null, SALT VARCHAR2(32), PHONE VARCHAR2(20) not null, GENDER NUMBER(11) default '1', HEAD VARCHAR2(200), REMARK VARCHAR2(200), STATE NUMBER(11) default '1', DEPARTMENT_ID NUMBER(20) not null, ROLE_ID NUMBER(20) not null, DELETED NUMBER(11) default '0', VERSION NUMBER(11) default '0', CREATE_TIME DATE default sysdate, UPDATE_TIME DATE ) / comment on table SYS_USER is '系统用户' / comment on column SYS_USER.ID is '主键' / comment on column SYS_USER.USERNAME is '用户名' / comment on column SYS_USER.NICKNAME is '昵称' / comment on column SYS_USER.PASSWORD is '密码' / comment on column SYS_USER.SALT is '盐值' / comment on column SYS_USER.PHONE is '手机号码' / comment on column SYS_USER.GENDER is '性别，0：女，1：男，默认1' / comment on column SYS_USER.HEAD is '头像' / comment on column SYS_USER.REMARK is 'remark' / comment on column SYS_USER.STATE is '状态，0：禁用，1：启用，2：锁定' / comment on column SYS_USER.DEPARTMENT_ID is '部门id' / comment on column SYS_USER.ROLE_ID is '角色id' / comment on column SYS_USER.DELETED is '逻辑删除，0：未删除，1：已删除' / comment on column SYS_USER.VERSION is '版本' / comment on column SYS_USER.CREATE_TIME is '创建时间' / comment on column SYS_USER.UPDATE_TIME is '修改时间' / create index SYS_USER_USERNAME_INDEX on SYS_USER (USERNAME) / create table SYS_ROLE ( ID NUMBER(20) not null, NAME VARCHAR2(32) not null, CODE VARCHAR2(100) not null, TYPE NUMBER(11), STATE NUMBER(11) default '1', REMARK VARCHAR2(200), VERSION NUMBER(11) default '0', CREATE_TIME DATE default sysdate, UPDATE_TIME DATE ) / comment on table SYS_ROLE is '系统角色' / comment on column SYS_ROLE.ID is '主键' / comment on column SYS_ROLE.NAME is '角色名称' / comment on column SYS_ROLE.CODE is '角色唯一编码' / comment on column SYS_ROLE.TYPE is '角色类型' / comment on column SYS_ROLE.STATE is '角色状态，0：禁用，1：启用' / comment on column SYS_ROLE.REMARK is '备注' / comment on column SYS_ROLE.VERSION is '版本' / comment on column SYS_ROLE.CREATE_TIME is '创建时间' / comment on column SYS_ROLE.UPDATE_TIME is '修改时间' / create unique index SYS_ROLE_NAME_INDEX on SYS_ROLE (NAME) / create unique index SYS_ROLE_CODE_UINDEX on SYS_ROLE (CODE) / create table SYS_PERMISSION ( ID NUMBER(20) not null constraint SYS_PERMISSION_PK primary key, NAME VARCHAR2(32), PARENT_ID NUMBER(20), URL VARCHAR2(200), CODE VARCHAR2(100) not null, ICON VARCHAR2(100), TYPE NUMBER(11) not null, "LEVEL" NUMBER(11) not null, STATE NUMBER(11) default '1', SORT NUMBER(11) default '0', REMARK VARCHAR2(200), VERSION NUMBER(11) default '0', CREATE_TIME DATE default sysdate, UPDATE_TIME DATE ) / comment on table SYS_PERMISSION is '系统权限' / comment on column SYS_PERMISSION.ID is '主键' / comment on column SYS_PERMISSION.NAME is '权限名称' / comment on column SYS_PERMISSION.PARENT_ID is '父id' / comment on column SYS_PERMISSION.URL is '路径' / comment on column SYS_PERMISSION.CODE is '唯一编码' / comment on column SYS_PERMISSION.ICON is '图标' / comment on column SYS_PERMISSION.TYPE is '类型，1：菜单，2：按钮' / comment on column SYS_PERMISSION."LEVEL" is '层级，1：第一级，2：第二级，N：第N级' / comment on column SYS_PERMISSION.STATE is '状态，0：禁用，1：启用' / comment on column SYS_PERMISSION.SORT is '排序' / comment on column SYS_PERMISSION.REMARK is '备注' / comment on column SYS_PERMISSION.VERSION is '版本' / comment on column SYS_PERMISSION.CREATE_TIME is '创建时间' / comment on column SYS_PERMISSION.UPDATE_TIME is '修改时间' / create index SYS_PERMISSION_CODE_INDEX on SYS_PERMISSION (CODE) / create table SYS_ROLE_PERMISSION ( ID NUMBER(20) not null constraint SYS_ROLE_PERMISSION_PK primary key, ROLE_ID NUMBER(20) not null, PERMISSION_ID NUMBER(20) not null, STATE NUMBER(11) default '1', REMARK VARCHAR2(200), VERSION NUMBER(11) default '0', CREATE_TIME DATE default sysdate, UPDATE_TIME DATE ) / comment on table SYS_ROLE_PERMISSION is '角色权限关系' / comment on column SYS_ROLE_PERMISSION.ID is '主键' / comment on column SYS_ROLE_PERMISSION.ROLE_ID is '角色id' / comment on column SYS_ROLE_PERMISSION.PERMISSION_ID is '权限id' / comment on column SYS_ROLE_PERMISSION.STATE is '状态，0：禁用，1：启用' / comment on column SYS_ROLE_PERMISSION.REMARK is '备注' / comment on column SYS_ROLE_PERMISSION.VERSION is '版本' / comment on column SYS_ROLE_PERMISSION.CREATE_TIME is '创建时间' / comment on column SYS_ROLE_PERMISSION.UPDATE_TIME is '修改时间' / create index SYS_ROLE_PERMISSION_ID_ID_IN on SYS_ROLE_PERMISSION (ROLE_ID, PERMISSION_ID) / -- Create sequence create sequence FOO_BAR_SEQUENCE minvalue 1 maxvalue 9999999999999 start with 1 increment by 1 cache 20; create sequence IP_SEQUENCE minvalue 1 maxvalue 9999999999999 start with 1 increment by 1 cache 20; create sequence SYS_DEPARTMENT_SEQUENCE minvalue 1 maxvalue 9999999999999 start with 1 increment by 1 cache 20; create sequence SYS_LOG_SEQUENCE minvalue 1 maxvalue 9999999999999 start with 1 increment by 1 cache 20; create sequence SYS_PERMISSION_SEQUENCE minvalue 1 maxvalue 9999999999999 start with 1 increment by 1 cache 20; create sequence SYS_ROLE_SEQUENCE minvalue 1 maxvalue 9999999999999 start with 1 increment by 1 cache 20; create sequence SYS_ROLE_PERMISSION_SEQUENCE minvalue 1 maxvalue 9999999999999 start with 1 increment by 1 cache 20; create sequence SYS_USER_SEQUENCE minvalue 1 maxvalue 9999999999999 start with 1 increment by 1 cache 20; INSERT INTO SYS_DEPARTMENT (ID, NAME, PARENT_ID, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (1, '管理部', null, 1, 1, 0, null, 0, TO_DATE('2019-10-25 09:46:49', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_DEPARTMENT (ID, NAME, PARENT_ID, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (2, '技术部', null, 1, 1, 0, null, 0, TO_DATE('2019-11-01 20:45:43', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_DEPARTMENT (ID, NAME, PARENT_ID, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (20, '前端开发部', 2, 2, 1, 0, null, 0, TO_DATE('2019-11-01 20:48:38', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_DEPARTMENT (ID, NAME, PARENT_ID, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (21, '后台开发部', 2, 2, 1, 0, null, 0, TO_DATE('2019-11-01 20:48:38', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_DEPARTMENT (ID, NAME, PARENT_ID, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (22, '测试部', 2, 2, 1, 0, null, 0, TO_DATE('2019-11-01 20:48:38', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_DEPARTMENT (ID, NAME, PARENT_ID, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (201, '前端一组', 20, 3, 1, 0, null, 0, TO_DATE('2019-11-01 20:48:38', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_DEPARTMENT (ID, NAME, PARENT_ID, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (202, '前端二组', 20, 3, 1, 0, null, 0, TO_DATE('2019-11-01 20:48:38', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_DEPARTMENT (ID, NAME, PARENT_ID, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (203, '后台一组', 21, 3, 1, 0, null, 0, TO_DATE('2019-11-01 20:48:38', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_DEPARTMENT (ID, NAME, PARENT_ID, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (204, '后台二组', 21, 3, 1, 0, null, 0, TO_DATE('2019-11-01 20:48:38', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_DEPARTMENT (ID, NAME, PARENT_ID, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (205, '测试一组', 22, 3, 1, 0, null, 0, TO_DATE('2019-11-01 20:48:38', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (1, '系统管理', null, null, 'system:management', null, 1, 1, 1, 0, null, 0, TO_DATE('2019-10-26 11:12:40', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (100, '用户管理', 1, null, 'sys:user:management', null, 1, 2, 1, 0, null, 0, TO_DATE('2019-10-26 11:15:48', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (200, '角色管理', 1, null, 'sys:role:management', null, 1, 2, 1, 0, null, 0, TO_DATE('2019-10-26 11:15:48', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (300, '权限管理', 1, null, 'sys:permission:management', null, 1, 2, 1, 0, null, 0, TO_DATE('2019-10-26 11:15:48', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (400, '部门管理', 1, null, 'sys:department:management', null, 1, 2, 1, 0, null, 0, TO_DATE('2019-10-26 11:15:48', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (1000, '用户新增', 100, null, 'sys:user:add', null, 2, 3, 1, 0, null, 0, TO_DATE('2019-10-26 11:18:40', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (1001, '用户修改', 100, null, 'sys:user:update', null, 2, 3, 1, 0, null, 0, TO_DATE('2019-10-26 11:18:40', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (1002, '用户删除', 100, null, 'sys:user:delete', null, 2, 3, 1, 0, null, 0, TO_DATE('2019-10-26 11:18:40', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (1003, '用户详情', 100, null, 'sys:user:info', null, 2, 3, 1, 0, null, 0, TO_DATE('2019-10-26 11:18:40', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (1004, '用户分页列表', 100, null, 'sys:user:page', null, 2, 3, 1, 0, null, 0, TO_DATE('2019-10-26 11:18:40', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (1005, '用户修改密码', 100, null, 'sys:user:update:password', null, 2, 3, 1, 0, null, 0, TO_DATE('2019-10-26 11:18:40', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (1006, '用户修改头像', 100, null, 'sys:user:update:head', null, 2, 3, 1, 0, null, 0, TO_DATE('2019-10-26 11:18:40', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (2000, '角色新增', 200, null, 'sys:role:add', null, 2, 3, 1, 0, null, 0, TO_DATE('2019-10-26 11:18:40', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (2001, '角色修改', 200, null, 'sys:role:update', null, 2, 3, 1, 0, null, 0, TO_DATE('2019-10-26 11:18:40', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (2002, '角色删除', 200, null, 'sys:role:delete', null, 2, 3, 1, 0, null, 0, TO_DATE('2019-10-26 11:18:40', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (2003, '角色详情', 200, null, 'sys:role:info', null, 2, 3, 1, 0, null, 0, TO_DATE('2019-10-26 11:18:40', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (2004, '角色分页列表', 200, null, 'sys:role:page', null, 2, 3, 1, 0, null, 0, TO_DATE('2019-10-26 11:18:40', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (3000, '权限新增', 300, null, 'sys:permission:add', null, 2, 3, 1, 0, null, 0, TO_DATE('2019-10-26 11:18:40', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (3001, '权限修改', 300, null, 'sys:permission:update', null, 2, 3, 1, 0, null, 0, TO_DATE('2019-10-26 11:18:40', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (3002, '权限删除', 300, null, 'sys:permission:delete', null, 2, 3, 1, 0, null, 0, TO_DATE('2019-10-26 11:18:40', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (3003, '权限详情', 300, null, 'sys:permission:info', null, 2, 3, 1, 0, null, 0, TO_DATE('2019-10-26 11:18:40', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (3004, '权限分页列表', 300, null, 'sys:permission:page', null, 2, 3, 1, 0, null, 0, TO_DATE('2019-10-26 11:18:40', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (3005, '权限所有列表', 300, null, 'sys:permission:all:menu:list', null, 2, 3, 1, 0, null, 0, TO_DATE('2019-10-26 11:18:40', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (3006, '权限所有树形列表', 300, null, 'sys:permission:all:menu:tree', null, 2, 3, 1, 0, null, 0, TO_DATE('2019-10-26 11:18:40', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (3007, '权限用户列表', 300, null, 'sys:permission:menu:list', null, 2, 3, 1, 0, null, 0, TO_DATE('2019-10-26 11:18:40', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (3008, '权限用户树形列表', 300, null, 'sys:permission:menu:tree', null, 2, 3, 1, 0, null, 0, TO_DATE('2019-10-26 11:18:40', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (3009, '权限用户代码列表', 300, null, 'sys:permission:codes', null, 2, 3, 1, 0, null, 0, TO_DATE('2019-10-26 11:18:40', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (4000, '部门新增', 400, null, 'sys:department:add', null, 2, 3, 1, 0, null, 0, TO_DATE('2019-10-26 11:18:40', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (4001, '部门修改', 400, null, 'sys:department:update', null, 2, 3, 1, 0, null, 0, TO_DATE('2019-10-26 11:18:40', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (4002, '部门删除', 400, null, 'sys:department:delete', null, 2, 3, 1, 0, null, 0, TO_DATE('2019-10-26 11:18:40', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (4003, '部门详情', 400, null, 'sys:department:info', null, 2, 3, 1, 0, null, 0, TO_DATE('2019-10-26 11:18:40', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_PERMISSION (ID, NAME, PARENT_ID, URL, CODE, ICON, TYPE, "LEVEL", STATE, SORT, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (4004, '部门分页列表', 400, null, 'sys:department:page', null, 2, 3, 1, 0, null, 0, TO_DATE('2019-10-26 11:18:40', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE (ID, NAME, CODE, TYPE, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (1, '管理员', 'admin', null, 1, null, 0, TO_DATE('2019-10-25 09:47:21', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE (ID, NAME, CODE, TYPE, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (2, 'test', 'test', null, 1, null, 0, TO_DATE('2019-10-25 09:48:02', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (1, 1, 1, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (2, 1, 100, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (3, 1, 200, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (4, 1, 300, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (5, 1, 400, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (6, 1, 1000, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (7, 1, 1001, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (8, 1, 1002, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (9, 1, 1003, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (10, 1, 1004, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (11, 1, 1005, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (12, 1, 1006, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (13, 1, 2000, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (14, 1, 2001, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (15, 1, 2002, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (16, 1, 2003, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (17, 1, 2004, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (18, 1, 3000, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (19, 1, 3001, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (20, 1, 3002, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (21, 1, 3003, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (22, 1, 3004, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (23, 1, 3005, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (24, 1, 3006, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (25, 1, 3007, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (26, 1, 3008, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (27, 1, 3009, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (28, 1, 4001, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (29, 1, 4002, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (30, 1, 4003, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (31, 1, 4004, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (100, 1, 1, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (101, 1, 100, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (102, 1, 1000, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (103, 1, 1001, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (104, 1, 1002, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (105, 1, 1003, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_ROLE_PERMISSION (ID, ROLE_ID, PERMISSION_ID, STATE, REMARK, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (106, 1, 1004, 1, null, 0, TO_DATE('2019-10-26 22:16:19', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_USER (ID, USERNAME, NICKNAME, PASSWORD, SALT, PHONE, GENDER, HEAD, REMARK, STATE, DEPARTMENT_ID, ROLE_ID, DELETED, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (1, 'admin', '管理员', '11a254dab80d52bc4a347e030e54d861a9d2cdb2af2185a9ca4a7318e830d04d', '666', '1', 1, 'http://localhost:8888//resource/201910281559227.jpg', 'Administrator Account', 1, 1, 1, 0, 1, TO_DATE('2019-08-26 00:52:01', 'YYYY-MM-DD HH24:MI:SS'), null); INSERT INTO SYS_USER (ID, USERNAME, NICKNAME, PASSWORD, SALT, PHONE, GENDER, HEAD, REMARK, STATE, DEPARTMENT_ID, ROLE_ID, DELETED, VERSION, CREATE_TIME, UPDATE_TIME) VALUES (2, 'test', '测试人员', '34783fb724b259beb71a1279f7cd93bdcfd92a273d566f926419a37825c500df', '087c2e9857f35f1e243367f3b89b81c1', '2', 1, null, 'Tester Account', 1, 1, 2, 0, 0, TO_DATE('2019-10-05 14:04:27', 'YYYY-MM-DD HH24:MI:SS'), null);