From 1142b0e41de39010de7845cf70d71dbb001fc1dc Mon Sep 17 00:00:00 2001 From: Shireesh Anjal Date: Fri, 25 Nov 2011 20:13:35 +0530 Subject: Renamed projects / packages com.gluster.* to org.gluster.* --- .../WebContent/data/scripts/1.0.0/0-version.sql | 2 -- .../data/scripts/1.0.0/1-security-schema.sql | 26 ---------------------- .../scripts/1.0.0/2-users-authorities-groups.sql | 18 --------------- .../data/scripts/1.0.0/3-cluster-servers.sql | 16 ------------- 4 files changed, 62 deletions(-) delete mode 100644 src/com.gluster.storage.management.gateway/WebContent/data/scripts/1.0.0/0-version.sql delete mode 100644 src/com.gluster.storage.management.gateway/WebContent/data/scripts/1.0.0/1-security-schema.sql delete mode 100644 src/com.gluster.storage.management.gateway/WebContent/data/scripts/1.0.0/2-users-authorities-groups.sql delete mode 100644 src/com.gluster.storage.management.gateway/WebContent/data/scripts/1.0.0/3-cluster-servers.sql (limited to 'src/com.gluster.storage.management.gateway/WebContent/data/scripts') diff --git a/src/com.gluster.storage.management.gateway/WebContent/data/scripts/1.0.0/0-version.sql b/src/com.gluster.storage.management.gateway/WebContent/data/scripts/1.0.0/0-version.sql deleted file mode 100644 index 4c3d81d1..00000000 --- a/src/com.gluster.storage.management.gateway/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.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)); 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 deleted file mode 100644 index 5bd73813..00000000 --- a/src/com.gluster.storage.management.gateway/WebContent/data/scripts/1.0.0/2-users-authorities-groups.sql +++ /dev/null @@ -1,18 +0,0 @@ --- Create users -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'); - --- 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,'gluster' from groups where group_name='Administrators'; \ No newline at end of file diff --git a/src/com.gluster.storage.management.gateway/WebContent/data/scripts/1.0.0/3-cluster-servers.sql b/src/com.gluster.storage.management.gateway/WebContent/data/scripts/1.0.0/3-cluster-servers.sql deleted file mode 100644 index 17ca62d2..00000000 --- a/src/com.gluster.storage.management.gateway/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 -- cgit