summaryrefslogtreecommitdiffstats
path: root/src/com.gluster.storage.management.gateway/WebContent/data/scripts/1.0.0/1-security-schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/com.gluster.storage.management.gateway/WebContent/data/scripts/1.0.0/1-security-schema.sql')
-rw-r--r--src/com.gluster.storage.management.gateway/WebContent/data/scripts/1.0.0/1-security-schema.sql26
1 files changed, 0 insertions, 26 deletions
diff --git a/src/com.gluster.storage.management.gateway/WebContent/data/scripts/1.0.0/1-security-schema.sql b/src/com.gluster.storage.management.gateway/WebContent/data/scripts/1.0.0/1-security-schema.sql
deleted file mode 100644
index 4f61fc9d..00000000
--- a/src/com.gluster.storage.management.gateway/WebContent/data/scripts/1.0.0/1-security-schema.sql
+++ /dev/null
@@ -1,26 +0,0 @@
-create table users(
- username varchar(32) not null primary key,
- password varchar(124) not null,
- enabled smallint not null
- );
-
- create table authorities (
- username varchar(32) not null,
- authority varchar(50) not null,
- constraint fk_authorities_users foreign key(username) references users(username));
- create unique index ix_auth_username on authorities (username,authority);
-
-create table groups (
- id bigint generated by default as identity(start with 0) primary key,
- group_name varchar(50) not null);
-
-create table group_authorities (
- group_id bigint not null,
- authority varchar(50) not null,
- constraint fk_group_authorities_group foreign key(group_id) references groups(id));
-
-create table group_members (
- id bigint generated by default as identity(start with 0) primary key,
- username varchar(32) not null,
- group_id bigint not null,
- constraint fk_group_members_group foreign key(group_id) references groups(id));