summaryrefslogtreecommitdiffstats
path: root/python_pgms/cloud-on-fly/cloud.sql
blob: 9abcf0895620df000db9b63a1f42051a3136a89b (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
create table cloud_seed(
	cloud_id int unique,
	cloud_name varchar(50),
	status varchar(10),
	type varchar(15),
	version  varchar(10)
);

create table server_process(
	server varchar(50),
	cloud_id int,
	server_pid int,
	export_dir varchar(100),
	port int,
	snum int,
	status varchar(15),
	logfile varchar(50)
);

create table client_process(
	client varchar(50) ,
	cloud_id int,
	client_pid int,
	mount_pt varchar(100),
	port int,
	cnum int,
	status varchar(15),
	logfile varchar(50)
);

create table server_pool(
	servername varchar(50) ,
	status varchar(10),
	ipaddress varchar(15) 
);

create table client_pool(
	clientname varchar(50) ,
	status varchar(10),
	ipaddress varchar(15) 
);

insert into server_pool (servername,status,ipaddress) values 
	 ("ec2-67-202-6-25.compute-1.amazonaws.com","free","10.212.187.79");
insert into server_pool (servername,status,ipaddress) values
	 ("ec2-174-129-181-3.compute-1.amazonaws.com","free","10.244.145.156");
insert into server_pool (servername,status,ipaddress) values 
	 ("ec2-75-101-171-113.compute-1.amazonaws.com","free","10.244.43.207");
insert into server_pool (servername,status,ipaddress) values 
	 ("ec2-67-202-34-30.compute-1.amazonaws.com","free","10.244.163.32");


insert into client_pool (clientname,status,ipaddress) values 
	("ec2-72-44-36-203.compute-1.amazonaws.com","free","10.245.222.227");