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; 
 
 
 
create table PERSISTENT_LOGINS ( 
  USERNAMEVARCHAr2(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 持久化'; 
 
 
 
create table SYS_AUTHORITIES ( 
  AUTHORITY_ID     VARCHAr2(100)   not null, 
  AUTHORITY_MARK    VARCHAr2(100), 
  AUTHORITY_NAME    VARCHAr2(100)   not null, 
  AUTHORITY_DESC    VARCHAr2(200), 
  MESSAGEVARCHAr2(100), 
  ENABLE NUMBER, 
  ISSYS NUMBER, 
  MODULE_ID      VARCHAr2(100), 
  constraint PK_SYS_AUTHORITIES primary key (AUTHORITY_ID) 
); 
 
 
 
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) 
); 
 
 
 
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_LEVELNUMBER, 
  LEAF  NUMBER, 
  APPLICATION     VARCHAr2(100), 
  ConTROLLER      VARCHAr2(100), 
  ENABLE NUMBER(1), 
  PRIORITYNUMBER, 
  constraint PK_SYS_MODULES primary key (MODULE_ID) 
); 
comment on column SYS_MODULES.I_LEVEL is 
'1'; 
 
 
 
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), 
  PRIORITYVARCHAr2(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'; 
 
 
 
create table SYS_ROLES ( 
  ROLE_IDVARCHAr2(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) 
); 
 
 
 
create table SYS_ROLES_AUTHORITIES ( 
  ID   VARCHAr2(100)   not null, 
  AUTHORITY_ID     VARCHAr2(100)   not null, 
  ROLE_IDVARCHAr2(100)   not null, 
  constraint PK_SYS_ROLES_AUTHORITIES primary key (ID) 
); 
 
 
 
create table SYS_ROLES_MOUDLES ( 
  ID   VARCHAr2(100)   not null, 
  MODULE_ID      VARCHAr2(100)   not null, 
  ROLE_IDVARCHAr2(100)   not null, 
  constraint PK_SYS_ROLES_MOUDLES primary key (ID) 
); 
comment on table SYS_ROLES_MOUDLES is 
'控制角色对模块的访问权，主要用于生成菜单'; 
 
 
 
create table SYS_USERS ( 
  USER_IDVARCHAr2(100)   not null, 
  USERNAMEVARCHAr2(100)   not null, 
  NAME  VARCHAr2(100), 
  PASSWORDVARCHAr2(100)   not null, 
  DT_CREATE      DATEdefault SYSDATE, 
  LAST_LOGIN      DATE, 
  DEADLINEDATE, 
  LOGIN_IPVARCHAr2(100), 
  V_QZJGIDVARCHAr2(100), 
  V_QZJGMCVARCHAr2(100), 
  DEP_ID VARCHAr2(100), 
  DEP_NAMEVARCHAr2(100), 
  ENABLEDNUMBER, 
  ACCOUNT_NON_EXPIRED NUMBER, 
  ACCOUNT_NON_LOCKED  NUMBER, 
  CREDENTIALS_NON_EXPIRED NUMBER, 
  constraint PK_SYS_USERS primary key (USER_ID) 
); 
 
 
 
create table SYS_USERS_ROLES ( 
  ID   VARCHAr2(100)   not null, 
  ROLE_IDVARCHAr2(100)   not null, 
  USER_IDVARCHAr2(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); 

总结

以上所述是小编给大家介绍的spring security数据库表结构实例代码，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对考高分网网站的支持！