spring security数据库表结构实例代码
PD建模图
建模语句
alter table SYS_AUTHORITIES_RESOURCES
drop constraint FK_SYS_AUTH_REFERENCE_SYS_AUTH;
alter table SYS_AUTHORITIES_RESOURCES
drop constraint FK_SYS_AUTH_REFERENCE_SYS_RESO;
alter table SYS_RESOURCES
drop constraint FK_SYS_RESO_REFERENCE_SYS_MODU;
alter table SYS_ROLES_AUTHORITIES
drop constraint FK_SYS_ROLE_REFERENCE_SYS_ROLE;
alter table SYS_ROLES_AUTHORITIES
drop constraint FK_SYS_ROLE_REFERENCE_SYS_AUTH;
alter table SYS_ROLES_MOUDLES
drop constraint FK_SYS_ROLE_REFERENCE_SYS_MODU;
alter table SYS_ROLES_MOUDLES
drop constraint FK_S_ROLE_REFERENCE_SYS_ROLE;
alter table SYS_USERS_ROLES
drop constraint FK_SYS_USER_REFERENCE_SYS_USER;
alter table SYS_USERS_ROLES
drop constraint FK_SYS_USER_REFERENCE_SYS_ROLE;
drop table PERSISTENT_LOGINS cascade constraints;
drop table SYS_AUTHORITIES cascade constraints;
drop table SYS_AUTHORITIES_RESOURCES cascade constraints;
drop table SYS_MODULES cascade constraints;
drop table SYS_RESOURCES cascade constraints;
drop table SYS_ROLES cascade constraints;
drop table SYS_ROLES_AUTHORITIES cascade constraints;
drop table SYS_ROLES_MOUDLES cascade constraints;
drop table SYS_USERS cascade constraints;
drop table SYS_USERS_ROLES cascade constraints;
/*==============================================================*/
/* Table: PERSISTENT_LOGINS */
/*==============================================================*/
create table PERSISTENT_LOGINS (
USERNAME VARCHAR2(64),
SERIES VARCHAR2(64) not null,
TOKEN VARCHAR2(64),
LAST_USED TIMESTAMP,
constraint PK_PERSISTENT_LOGINS primary key (SERIES)
);
comment on table PERSISTENT_LOGINS is
'Spring Remember me 持久化';
/*==============================================================*/
/* Table: SYS_AUTHORITIES */
/*==============================================================*/
create table SYS_AUTHORITIES (
AUTHORITY_ID VARCHAR2(100) not null,
AUTHORITY_MARK VARCHAR2(100),
AUTHORITY_NAME VARCHAR2(100) not null,
AUTHORITY_DESC VARCHAR2(200),
MESSAGE VARCHAR2(100),
ENABLE NUMBER,
ISSYS NUMBER,
MODULE_ID VARCHAR2(100),
constraint PK_SYS_AUTHORITIES primary key (AUTHORITY_ID)
);
/*==============================================================*/
/* Table: SYS_AUTHORITIES_RESOURCES */
/*==============================================================*/
create table SYS_AUTHORITIES_RESOURCES (
ID VARCHAR2(100) not null,
RESOURCE_ID VARCHAR2(100) not null,
AUTHORITY_ID VARCHAR2(100) not null,
constraint PK_SYS_AUTHORITIES_RESOURCES primary key (ID)
);
/*==============================================================*/
/* Table: SYS_MODULES */
/*==============================================================*/
create table SYS_MODULES (
MODULE_ID VARCHAR2(100) not null,
MODULE_NAME VARCHAR2(100) not null,
MODULE_DESC VARCHAR2(200),
MODULE_TYPE VARCHAR2(100),
PARENT VARCHAR2(100),
MODULE_URL VARCHAR2(100),
I_LEVEL NUMBER,
LEAF NUMBER,
APPLICATION VARCHAR2(100),
CONTROLLER VARCHAR2(100),
ENABLE NUMBER(1),
PRIORITY NUMBER,
constraint PK_SYS_MODULES primary key (MODULE_ID)
);
comment on column SYS_MODULES.I_LEVEL is
'1';
/*==============================================================*/
/* Table: SYS_RESOURCES */
/*==============================================================*/
create table SYS_RESOURCES (
RESOURCE_ID VARCHAR2(100) not null,
RESOURCE_TYPE VARCHAR2(100),
RESOURCE_NAME VARCHAR2(100),
RESOURCE_DESC VARCHAR2(200),
RESOURCE_PATH VARCHAR2(200),
PRIORITY VARCHAR2(100),
ENABLE NUMBER,
ISSYS NUMBER,
MODULE_ID VARCHAR2(100),
constraint PK_SYS_RESOURCES primary key (RESOURCE_ID)
);
comment on column SYS_RESOURCES.RESOURCE_TYPE is
'URL,METHOD';
/*==============================================================*/
/* Table: SYS_ROLES */
/*==============================================================*/
create table SYS_ROLES (
ROLE_ID VARCHAR2(100) not null,
ROLE_NAME VARCHAR2(100),
ROLE_DESC VARCHAR2(200),
ENABLE NUMBER,
ISSYS NUMBER,
MODULE_ID VARCHAR2(100),
constraint PK_SYS_ROLES primary key (ROLE_ID)
);
/*==============================================================*/
/* Table: SYS_ROLES_AUTHORITIES */
/*==============================================================*/
create table SYS_ROLES_AUTHORITIES (
ID VARCHAR2(100) not null,
AUTHORITY_ID VARCHAR2(100) not null,
ROLE_ID VARCHAR2(100) not null,
constraint PK_SYS_ROLES_AUTHORITIES primary key (ID)
);
/*==============================================================*/
/* Table: SYS_ROLES_MOUDLES */
/*==============================================================*/
create table SYS_ROLES_MOUDLES (
ID VARCHAR2(100) not null,
MODULE_ID VARCHAR2(100) not null,
ROLE_ID VARCHAR2(100) not null,
constraint PK_SYS_ROLES_MOUDLES primary key (ID)
);
comment on table SYS_ROLES_MOUDLES is
'控制角色对模块的访问权，主要用于生成菜单';
/*==============================================================*/
/* Table: SYS_USERS */
/*==============================================================*/
create table SYS_USERS (
USER_ID VARCHAR2(100) not null,
USERNAME VARCHAR2(100) not null,
NAME VARCHAR2(100),
PASSWORD VARCHAR2(100) not null,
DT_CREATE DATE default SYSDATE,
LAST_LOGIN DATE,
DEADLINE DATE,
LOGIN_IP VARCHAR2(100),
V_QZJGID VARCHAR2(100),
V_QZJGMC VARCHAR2(100),
DEP_ID VARCHAR2(100),
DEP_NAME VARCHAR2(100),
ENABLED NUMBER,
ACCOUNT_NON_EXPIRED NUMBER,
ACCOUNT_NON_LOCKED NUMBER,
CREDENTIALS_NON_EXPIRED NUMBER,
constraint PK_SYS_USERS primary key (USER_ID)
);
/*==============================================================*/
/* Table: SYS_USERS_ROLES */
/*==============================================================*/
create table SYS_USERS_ROLES (
ID VARCHAR2(100) not null,
ROLE_ID VARCHAR2(100) not null,
USER_ID VARCHAR2(100) not null,
constraint PK_SYS_USERS_ROLES primary key (ID)
);
alter table SYS_AUTHORITIES_RESOURCES
add constraint FK_SYS_AUTH_REFERENCE_SYS_AUTH foreign key (AUTHORITY_ID)
references SYS_AUTHORITIES (AUTHORITY_ID);
alter table SYS_AUTHORITIES_RESOURCES
add constraint FK_SYS_AUTH_REFERENCE_SYS_RESO foreign key (RESOURCE_ID)
references SYS_RESOURCES (RESOURCE_ID);
alter table SYS_RESOURCES
add constraint FK_SYS_RESO_REFERENCE_SYS_MODU foreign key (MODULE_ID)
references SYS_MODULES (MODULE_ID);
alter table SYS_ROLES_AUTHORITIES
add constraint FK_SYS_ROLE_REFERENCE_SYS_ROLE foreign key (ROLE_ID)
references SYS_ROLES (ROLE_ID);
alter table SYS_ROLES_AUTHORITIES
add constraint FK_SYS_ROLE_REFERENCE_SYS_AUTH foreign key (AUTHORITY_ID)
references SYS_AUTHORITIES (AUTHORITY_ID);
alter table SYS_ROLES_MOUDLES
add constraint FK_SYS_ROLE_REFERENCE_SYS_MODU foreign key (MODULE_ID)
references SYS_MODULES (MODULE_ID);
alter table SYS_ROLES_MOUDLES
add constraint FK_S_ROLE_REFERENCE_SYS_ROLE foreign key (ROLE_ID)
references SYS_ROLES (ROLE_ID);
alter table SYS_USERS_ROLES
add constraint FK_SYS_USER_REFERENCE_SYS_USER foreign key (USER_ID)
references SYS_USERS (USER_ID);
alter table SYS_USERS_ROLES
add constraint FK_SYS_USER_REFERENCE_SYS_ROLE foreign key (ROLE_ID)
references SYS_ROLES (ROLE_ID);
总结
以上所述是小编给大家介绍的security" title="spring security">spring security数据库表结构实例代码，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对网站的支持！
以上是 spring security数据库表结构实例代码 的全部内容， 来源链接： utcz.com/p/214533.html
