diff options
Diffstat (limited to 'src/com.gluster.storage.management.gateway/WebContent/data/scripts')
2 files changed, 5 insertions, 8 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 index fdde5823..4f61fc9d 100644 --- 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 @@ -1,11 +1,11 @@ create table users( - username varchar(50) not null primary key, - password varchar(50) not null, + username varchar(32) not null primary key, + password varchar(124) not null, enabled smallint not null ); create table authorities ( - username varchar(50) not null, + 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); @@ -21,6 +21,6 @@ create table group_authorities ( create table group_members ( id bigint generated by default as identity(start with 0) primary key, - username varchar(50) not null, + username varchar(32) not null, group_id bigint not null, constraint fk_group_members_group foreign key(group_id) references groups(id)); diff --git a/src/com.gluster.storage.management.gateway/WebContent/data/scripts/1.0.0/2-users-authorities-groups.sql b/src/com.gluster.storage.management.gateway/WebContent/data/scripts/1.0.0/2-users-authorities-groups.sql index 35ccf965..5bd73813 100644 --- a/src/com.gluster.storage.management.gateway/WebContent/data/scripts/1.0.0/2-users-authorities-groups.sql +++ b/src/com.gluster.storage.management.gateway/WebContent/data/scripts/1.0.0/2-users-authorities-groups.sql @@ -1,11 +1,9 @@ -- Create users -insert into users(username, password, enabled) values ('gluster','gluster',1); -insert into users(username, password, enabled) values ('guest','guest',1); +insert into users(username, password, enabled) values ('gluster','syst3m',1); -- Assign authorities to users (to be removed after implementing user group functionality) insert into authorities(username,authority) values ('gluster','ROLE_USER'); insert into authorities(username,authority) values ('gluster','ROLE_ADMIN'); -insert into authorities(username,authority) values ('guest','ROLE_USER'); -- Create user groups insert into groups(group_name) values ('Users'); @@ -17,5 +15,4 @@ insert into group_authorities(group_id, authority) select id,'ROLE_USER' from gr insert into group_authorities(group_id, authority) select id,'ROLE_ADMIN' from groups where group_name='Administrators'; -- Assign group members -insert into group_members(group_id, username) select id,'guest' from groups where group_name='Users'; insert into group_members(group_id, username) select id,'gluster' from groups where group_name='Administrators';
\ No newline at end of file |