INSERT INTO `vm_instance` VALUES (105, 'vdijiajingmin', '138eebed-9558-4388-a181-38950f3fb9d2','vdijiajingmin','Running',201,49,'00:50:56:95:69:8c','172.16.107.48',1,1,1,1,NULL,NULL,'6WS1lh1prPtazvwIkg9Bseun3gYtJtAZz2eZUou2Dv4=',0,0,3,'2012-12-07 04:44:43','2012-12-07 04:34:32',NULL,'User','User',2,1,10,'3c7e465e-c225-4236-8dc8-11da14486613','VMware');
INSERT INTO `user_vm` VALUES (105,NULL,'vdijiajingmin',NULL);
INSERT INTO `security_group_vm_map`(security_group_id, instance_id) VALUES (1, 105);
INSERT INTO `volumes` VALUES (14,2,1, 201,NULL,105,0,'ROOT-105','aa98b27d-b6cb-46d1-af03-fe86eab493ea', 21474836480,'datastore-9065','ROOT-105',1,1,NULL,NULL,'ROOT','LVM',10,201,NULL,0,'2012-12-07 04:34:32',NULL,'2012-12-07 04:44:35',NULL,'Ready',NULL,3);
INSERT INTO `volumes` VALUES (15,2,1, 201,NULL,105,1,'DATA-105','d99e4233-db42-4aab-a3d5-97f6484fceac', 21474836480,'datastore-9065','Data-105',1,1,NULL,NULL,'DATADISK','LVM',11,201,NULL,0,'2012-12-07 04:34:32',NULL,'2012-12-07 04:44:35',NULL,'Ready',NULL,3);
INSERT INTO `nics` VALUES (8,'4e08bbcb-6b81-4013-9d2b-2884ae738110',105,'00:50:56:95:69:8c','172.16.107.48','255.255.255.0','172.16.107.1','Ip4','vlan://untagged',204,'Dhcp','Reserved','Start','DirectPodBasedNetworkGuru','3c7e465e-c225-4236-8dc8-11da14486613',0,'2012-12-07 04:34:32','ec2://untagged',NULL,1,'User','2012-12-07 04:34:32',NULL);
update user_ip_address set allocated = '2012-12-07 04:34:32', state='Allocated', network_id = 204, source_network_id=204 where public_ip_address='172.16.107.48';
update sequence set value = (select max(id)+1 from vm_instance) where name = 'vm_instance_seq';
INSERT INTO `user_vm` VALUES (105,NULL,'vdijiajingmin',NULL);
INSERT INTO `security_group_vm_map`(security_group_id, instance_id) VALUES (1, 105);
INSERT INTO `volumes` VALUES (14,2,1, 201,NULL,105,0,'ROOT-105','aa98b27d-b6cb-46d1-af03-fe86eab493ea', 21474836480,'datastore-9065','ROOT-105',1,1,NULL,NULL,'ROOT','LVM',10,201,NULL,0,'2012-12-07 04:34:32',NULL,'2012-12-07 04:44:35',NULL,'Ready',NULL,3);
INSERT INTO `volumes` VALUES (15,2,1, 201,NULL,105,1,'DATA-105','d99e4233-db42-4aab-a3d5-97f6484fceac', 21474836480,'datastore-9065','Data-105',1,1,NULL,NULL,'DATADISK','LVM',11,201,NULL,0,'2012-12-07 04:34:32',NULL,'2012-12-07 04:44:35',NULL,'Ready',NULL,3);
INSERT INTO `nics` VALUES (8,'4e08bbcb-6b81-4013-9d2b-2884ae738110',105,'00:50:56:95:69:8c','172.16.107.48','255.255.255.0','172.16.107.1','Ip4','vlan://untagged',204,'Dhcp','Reserved','Start','DirectPodBasedNetworkGuru','3c7e465e-c225-4236-8dc8-11da14486613',0,'2012-12-07 04:34:32','ec2://untagged',NULL,1,'User','2012-12-07 04:34:32',NULL);
update user_ip_address set allocated = '2012-12-07 04:34:32', state='Allocated', network_id = 204, source_network_id=204 where public_ip_address='172.16.107.48';
update sequence set value = (select max(id)+1 from vm_instance) where name = 'vm_instance_seq';