schema.sql

来自「SpringSide开源代码」· SQL 代码 · 共 26 行

drop table USERS_ROLES;
drop table USERS;
drop table ROLES;


CREATE TABLE USERS (
ID INTEGER PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
LOGIN_NAME VARCHAR(20) NOT NULL UNIQUE,
PASSWORD VARCHAR(64),
NAME VARCHAR(20),
EMAIL VARCHAR(50)
);

CREATE TABLE ROLES (
ID INTEGER PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
NAME VARCHAR(20) NOT NULL UNIQUE
);

CREATE TABLE USERS_ROLES (
USER_ID INTEGER not null,
ROLE_ID INTEGER not null,
FOREIGN KEY (ROLE_ID) references ROLES(ID),
FOREIGN KEY (USER_ID) references USERS(ID)
);