diff options
| author | Shireesh Anjal <shireesh@gluster.com> | 2011-05-25 18:12:48 +0530 |
|---|---|---|
| committer | Shireesh Anjal <shireesh@gluster.com> | 2011-05-30 12:20:17 +0530 |
| commit | 66eeb6a273b1a60813375a4bf55bcc38e1a3d00a (patch) | |
| tree | 74826193b1f83e558768e04b97da1c054e8cf259 /src/com.gluster.storage.management.server/WebContent/data/scripts/1.0.0/3-cluster-servers.sql | |
| parent | 4435678fe7c1ca8f857dd008088b3d33ddec0484 (diff) | |
Design changes - introducing cluster-server mapping on gateway
Diffstat (limited to 'src/com.gluster.storage.management.server/WebContent/data/scripts/1.0.0/3-cluster-servers.sql')
| -rw-r--r-- | src/com.gluster.storage.management.server/WebContent/data/scripts/1.0.0/3-cluster-servers.sql | 16 |
1 files changed, 16 insertions, 0 deletions
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 new file mode 100644 index 00000000..17ca62d2 --- /dev/null +++ b/src/com.gluster.storage.management.server/WebContent/data/scripts/1.0.0/3-cluster-servers.sql @@ -0,0 +1,16 @@ +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 |