From 0d12b25f91cfcbb09687d774389d85b8c8ffa249 Mon Sep 17 00:00:00 2001 From: Shireesh Anjal Date: Mon, 1 Aug 2011 11:54:01 +0530 Subject: Renamed project and package com.gluster.storage.management.server to com.gluster.storage.management.gateway --- .../data/scripts/1.0.0/1-security-schema.sql | 26 ++++++++++++++++++++++ 1 file changed, 26 insertions(+) create mode 100644 src/com.gluster.storage.management.gateway/WebContent/data/scripts/1.0.0/1-security-schema.sql (limited to 'src/com.gluster.storage.management.gateway/WebContent/data/scripts/1.0.0/1-security-schema.sql') 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 new file mode 100644 index 00000000..fdde5823 --- /dev/null +++ b/src/com.gluster.storage.management.gateway/WebContent/data/scripts/1.0.0/1-security-schema.sql @@ -0,0 +1,26 @@ +create table users( + username varchar(50) not null primary key, + password varchar(50) not null, + enabled smallint not null + ); + + create table authorities ( + username varchar(50) 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(50) not null, + group_id bigint not null, + constraint fk_group_members_group foreign key(group_id) references groups(id)); -- cgit