blob: 17ca62d25a50e0298bdb6caa0fe1fd9087ee9f85 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
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);
|
