1 files changed, 54 insertions, 0 deletions
diff --git a/python_pgms/cloud-on-fly/cloud.sql b/python_pgms/cloud-on-fly/cloud.sql
new file mode 100644
index 0000000..9abcf08
--- /dev/null
+++ b/python_pgms/cloud-on-fly/cloud.sql
@@ -0,0 +1,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");