summaryrefslogtreecommitdiffstats
path: root/src/com.gluster.storage.management.server/WebContent/data
diff options
context:
space:
mode:
authorShireesh Anjal <shireesh@gluster.com>2011-08-01 11:54:01 +0530
committerShireesh Anjal <shireesh@gluster.com>2011-08-01 11:54:01 +0530
commit0d12b25f91cfcbb09687d774389d85b8c8ffa249 (patch)
tree2d0dd66c137f207c0cecbf583b873d8b9a9f76c7 /src/com.gluster.storage.management.server/WebContent/data
parentdda8f6f9845787a16835cef9771263040add8216 (diff)
Renamed project and package com.gluster.storage.management.server to com.gluster.storage.management.gateway
Diffstat (limited to 'src/com.gluster.storage.management.server/WebContent/data')
-rw-r--r--src/com.gluster.storage.management.server/WebContent/data/scripts/1.0.0/0-version.sql2
-rw-r--r--src/com.gluster.storage.management.server/WebContent/data/scripts/1.0.0/1-security-schema.sql26
-rw-r--r--src/com.gluster.storage.management.server/WebContent/data/scripts/1.0.0/2-users-authorities-groups.sql21
-rw-r--r--src/com.gluster.storage.management.server/WebContent/data/scripts/1.0.0/3-cluster-servers.sql16
4 files changed, 0 insertions, 65 deletions
diff --git a/src/com.gluster.storage.management.server/WebContent/data/scripts/1.0.0/0-version.sql b/src/com.gluster.storage.management.server/WebContent/data/scripts/1.0.0/0-version.sql
deleted file mode 100644
index 4c3d81d1..00000000
--- a/src/com.gluster.storage.management.server/WebContent/data/scripts/1.0.0/0-version.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-create table version (version varchar(16) not null primary key);
-insert into version(version) values('1.0.0'); \ No newline at end of file
diff --git a/src/com.gluster.storage.management.server/WebContent/data/scripts/1.0.0/1-security-schema.sql b/src/com.gluster.storage.management.server/WebContent/data/scripts/1.0.0/1-security-schema.sql
deleted file mode 100644
index fdde5823..00000000
--- a/src/com.gluster.storage.management.server/WebContent/data/scripts/1.0.0/1-security-schema.sql
+++ /dev/null
@@ -1,26 +0,0 @@
-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));
diff --git a/src/com.gluster.storage.management.server/WebContent/data/scripts/1.0.0/2-users-authorities-groups.sql b/src/com.gluster.storage.management.server/WebContent/data/scripts/1.0.0/2-users-authorities-groups.sql
deleted file mode 100644
index 35ccf965..00000000
--- a/src/com.gluster.storage.management.server/WebContent/data/scripts/1.0.0/2-users-authorities-groups.sql
+++ /dev/null
@@ -1,21 +0,0 @@
--- Create users
-insert into users(username, password, enabled) values ('gluster','gluster',1);
-insert into users(username, password, enabled) values ('guest','guest',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');
-insert into groups(group_name) values ('Administrators');
-
--- Add authorities to groups (functionality not yet implemented in code)
-insert into group_authorities(group_id, authority) select id,'ROLE_USER' from groups where group_name='Users';
-insert into group_authorities(group_id, authority) select id,'ROLE_USER' from groups where group_name='Administrators';
-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
diff --git a/src/com.gluster.storage.management.server/WebContent/data/scripts/1.0.0/3-cluster-servers.sql b/src/com.gluster.storage.management.server/WebContent/data/scripts/1.0.0/3-cluster-servers.sql
deleted file mode 100644
index 17ca62d2..00000000
--- a/src/com.gluster.storage.management.server/WebContent/data/scripts/1.0.0/3-cluster-servers.sql
+++ /dev/null
@@ -1,16 +0,0 @@
-create table cluster_info (
- id bigint generated by default as identity,
- name varchar(255),
- primary key (id));
-
-create unique index ix_cluster_name on cluster_info (name);
-
-create table server_info (
- id bigint generated by default as identity,
- name varchar(255),
- cluster_id bigint,
- primary key (id));
-
-create unique index ix_cluster_server on server_info (name, cluster_id);
-
-alter table server_info add constraint FK_CLUSTER_ID foreign key (cluster_id) references cluster_info(id); \ No newline at end of file