ecsteam-gcp-servicebroker-db.sql

-- MySQL dump 10.13  Distrib 5.7.16, for osx10.12 (x86_64)
--
-- Host: 172.28.6.53    Database: servicebroker
-- ------------------------------------------------------
-- Server version	5.5.5-10.1.18-MariaDB
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `migrations`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `migration_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
);
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (4,'2016-10-20 23:47:00','2016-10-20 23:47:00',NULL,0);

--
-- Table structure for table `plan_details`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `plan_details` (
  `id` varchar(255) NOT NULL DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `service_id` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `features` text,
  PRIMARY KEY (`id`)
);
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `plan_details`
--

INSERT INTO `plan_details` VALUES ('1be467bc-82b5-46ae-a177-fe5f6be74d9a','2016-10-20 23:47:00','2016-10-22 15:59:30',NULL,'628629e3-79f5-4255-b981-d14c6c7856be','default','\"\"');
INSERT INTO `plan_details` VALUES ('23188783-c40e-45bb-8a52-bac898641feb','2016-10-22 14:01:49','2016-10-22 15:59:30',NULL,'4bc59b9a-8520-409f-85da-1c7552315863','small-d0-standard','{\"max_disk_size\":\"10\",\"pricing_plan\":\"PER_USE\",\"tier\":\"D0\"}');
INSERT INTO `plan_details` VALUES ('5637ea66-89b6-4de8-88be-0ca9a16591dd','2016-10-22 14:01:49','2016-10-22 15:59:30',NULL,'4bc59b9a-8520-409f-85da-1c7552315863','medium-d4-standard','{\"max_disk_size\":\"10\",\"pricing_plan\":\"PER_USE\",\"tier\":\"D4\"}');
INSERT INTO `plan_details` VALUES ('a3739015-f7ff-4680-af0a-33bb5bdbbda8','2016-10-20 23:47:00','2016-10-22 15:59:30',NULL,'b9e4332e-b42b-4680-bda5-ea1506797474','standard','{\"storage_class\":\"STANDARD\"}');
INSERT INTO `plan_details` VALUES ('c3270b4e-1afe-43ca-ac37-0476c476558f','2016-10-20 23:47:00','2016-10-22 15:59:30',NULL,'b9e4332e-b42b-4680-bda5-ea1506797474','nearline','{\"storage_class\":\"NEARLINE\"}');
INSERT INTO `plan_details` VALUES ('c99e00ab-d1eb-4978-a50e-05c99d19c9ff','2016-10-22 14:11:51','2016-10-22 15:59:30',NULL,'4bc59b9a-8520-409f-85da-1c7552315863','large-d8-standard','{\"max_disk_size\":\"50\",\"pricing_plan\":\"PER_USE\",\"tier\":\"D8\"}');
INSERT INTO `plan_details` VALUES ('ddba95b3-938a-49de-ad1f-c5874fb38248','2016-10-20 23:47:00','2016-10-22 15:59:30',NULL,'5ad2dce0-51f7-4ede-8b46-293d6df1e8d4','default','\"\"');
INSERT INTO `plan_details` VALUES ('ec7113a9-b88c-4c4c-abf8-a61759ed0942','2016-10-20 23:47:00','2016-10-22 15:59:30',NULL,'f80c0a3e-bd4d-4809-a900-b4e33a6450f1','default','\"\"');
INSERT INTO `plan_details` VALUES ('f504a74b-be8f-4b49-aa7e-c16843986300','2016-10-20 23:47:00','2016-10-22 15:59:30',NULL,'b9e4332e-b42b-4680-bda5-ea1506797474','reduced_availability','{\"storage_class\":\"DURABLE_REDUCED_AVAILABILITY\"}');

--
-- Table structure for table `provision_request_details`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `provision_request_details` (
  `id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `service_instance_id` varchar(255) DEFAULT NULL,
  `request_details` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_provision_request_details_deleted_at` (`deleted_at`)
);
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `provision_request_details`
--

INSERT INTO `provision_request_details` VALUES (4,'2016-10-21 16:19:02','2016-10-21 16:19:02',NULL,'789a8443-bb5d-47fe-a34e-36d28ed4bf8a','{\"name\":\"ecs_mydataset\"}');
INSERT INTO `provision_request_details` VALUES (7,'2016-10-22 14:09:44','2016-10-22 14:09:44',NULL,'6124a302-efd3-4971-b391-a2dd1c6546fd','{\"database_name\":\"mydb\",\"instance_name\":\"dev-small-mysql-01\"}');

--
-- Table structure for table `service_binding_credentials`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `service_binding_credentials` (
  `id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `other_details` text,
  `service_id` varchar(255) DEFAULT NULL,
  `service_instance_id` varchar(255) DEFAULT NULL,
  `binding_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_service_binding_credentials_deleted_at` (`deleted_at`)
);
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `service_binding_credentials`
--

INSERT INTO `service_binding_credentials` VALUES (4,'2016-10-21 16:44:11','2016-10-21 16:44:11',NULL,'{\"Name\":\"pcf-binding-863b8199\",\"Email\":\"pcf-binding-863b8199@ecs-pcf-on-gce-2016.iam.gserviceaccount.com\",\"UniqueId\":\"117029198826369567551\",\"PrivateKeyData\":\"ewogICJ0eXBlIjogInNlcnZpY2VfYWNjb3VudCIsCiAgInByb2plY3RfaWQiOiAiZWNzLXBjZi1vbi1nY2UtMjAxNiIsCiAgInByaXZhdGVfa2V5X2lkIjogImU2Yzk3MmM4NTc5MmQwYjc5NjUyZTVkOGQ2OWQ0MjcwZDljYTcxOWMiLAogICJwcml2YXRlX2tleSI6ICItLS0tLUJFR0lOIFBSSVZBVEUgS0VZLS0tLS1cbk1JSUV2UUlCQURBTkJna3Foa2lHOXcwQkFRRUZBQVNDQktjd2dnU2pBZ0VBQW9JQkFRQzRwOWZJZXlZaHRpV0Zcbm5MMnVXZzBWRFZNa3ZjU0xqWE5NbG9Kb0lRTWdDQmNMVmxXQWozRjFvdEYvQVhvS2FWRks1L2lXNnNvakw0Qm5cbmpyV1JreGQ3c01VQzFoTThScENEb3Q3MXpyckZuR2x2dTJNdnp0TTlhNEdnbWNNUVZmd1JKaGNaZW9LOGwraElcbkFtNW1HYnR3bkhhY1F5T3hTY3d5QjNSckgxc05mVGNCUnZqZFFkYkR1MkdPQzdGQXVTMFE4MUtzcW1TTStiODVcbm1QZU8xZVpTeFprZ3c3cHZ1eHVIVWJlMXFEWjNFa0FTc054cldXYk5Zd0NvaWhwamdWNk5zN3BhbWs4aTJ2YlhcbkZmU21VNm94SzNrci9VRkYvWnhZOHBNYklGb3R0c2p1ZmxGSExNNGRsUCtEWVh2M0Fza1lRRm9lZ3ZzbWovQjlcbjZjMCtTRkk3QWdNQkFBRUNnZ0VBT1BYTllsSmFtTnVQQjRBcUlyWTBndUh4Vzh3TjdONWRTcXJDMzB3UG9ybmNcbkllc254Tmg2cjBiaVNNTXoyakpTbVVDbE5paUc0Z090SUVTdFRaS0tFK1diWUJ5WkltYkIvVmtvWGJxL2NtV2xcblFJb1ZOcEllSnp3YWFHZ0YrK3dLTFdBS2tCbHlhcXFSUkdVN21OTW5OcjJNK1BiYzg3dEgrY2JDNnFocGRlYzdcbm9GUXBPZHFmNjJncVNHUks3bGdabE1JUEZXVFRHVThNUTZQS0dqcFBlUEI1WUZFWWY2QTJWZGZBUi9mL3E5bDJcbmVNR2pKZjJzS3J3aDN3QXh6THVHeEdiUTlkakdqZkdRZkc4WFY3YUkrRHBCY1RRRThWZml5c3VpRTVNVmhRRStcblA0Q0NMVmJVQkpyblpNc1dram8wWmFPaHJTbUpPam9yR2IzY3lORzlRUUtCZ1FEcXhDeHJtWUxQbzFwNXdQY1BcbkZKYXltdXBFNS9vVUZ4eGZuSXIxTnlYaU1yeU9TZmJvakFoUDNXUlBIaVJWZUJLNWlwelM5YnA5L2dhNTUzbElcbkRIcmxucnNwd0ducENibVlxMzF5dldJWWh4UXBJRjJNWFljTXNnV0JodWcydDg4ejBwU1pUU2FubmR3U1plSDlcbnRVa0ZCQVBOYStjekJCdm1yVDloRXBJanJ3S0JnUURKVzJXWmpEdUNwSzdXeGsrbkdsNG1Bd0hQK29peWpGUFVcbnNHZEp5YzJ0WGJzMXlHSWlheUtwd0QwbythMVJTNndmRWZSSFhMQm9jMFVFM1p1WnY3VklOTTBqVmVNTDg3ODRcbjZrSS9rZGp4YWdaZm1rdHhrcko3VzE4dHdJYWpBT2wzVU05MWpCZ3FhQWZLK3A0TGd0c0MvZkxvckdOZjhjaVBcbnNTVzdBT0RCTlFLQmdFNjFQbjlFbEVxdzVhQjBSV0JVOHNFbWx1eExLZGlhZHZUSE12OUxZZlFZTm9jdDNRM1NcbkJPZGh2a09ZUTI0ME4zTGxPZmF3VTdueDlLZFhKNTQwTU8vUzY4VHZzWkpqcEVtL0ZPdm0rb0JtcVNld3BpeHRcbkh0M3V3VkhQdlFLN1ZVaDJqVU5vVGxGYjUzQnpuL1REVnB2TDRNcDZKcVUvOTJxN0lzaVV4VklaQW9HQURNcGNcbmV0TjRtRVRqd2tyWWxuSExWempMcmExcGI0WVFjU3MvZEdWNFJqSDFDV2FRTFVXRzd5ZUIrdzlaSGhmamVCbklcbjNadWFyUmZkWTRDOE9Kai81L1ZLcnBydkVEeE1nazRISlVpYmNrSmM0MGZHMFJFVGUxaURoRUY5aSs4cjVXTmhcbnVrTEs2aTZ2aUFwQmJkUERHNzZMNXBIRXdqeDJsQUladG5aSTBKMENnWUVBeDN3TjdhU0lCUjYxcVorY2RtcDZcbjZKMURmamwwcjAzd3B0MzFPTGZnbDZiaHdmWFRnNDRVNG9wekl2OHBkRDNSUTEvbCt0dENQU1d5T1IwVmZEVzBcbmovOThDQXM3ZmFVK1l4WExFeFBSVFpZdEJRMnJ0aEZVbi9RYzlHbFVnVGxXTlVIMTNaU1NVdlF6azRYN1BZK0dcblB2WHBRaFUxVi8ydFZIeHZTMVhDZEJvPVxuLS0tLS1FTkQgUFJJVkFURSBLRVktLS0tLVxuIiwKICAiY2xpZW50X2VtYWlsIjogInBjZi1iaW5kaW5nLTg2M2I4MTk5QGVjcy1wY2Ytb24tZ2NlLTIwMTYuaWFtLmdzZXJ2aWNlYWNjb3VudC5jb20iLAogICJjbGllbnRfaWQiOiAiMTE3MDI5MTk4ODI2MzY5NTY3NTUxIiwKICAiYXV0aF91cmkiOiAiaHR0cHM6Ly9hY2NvdW50cy5nb29nbGUuY29tL28vb2F1dGgyL2F1dGgiLAogICJ0b2tlbl91cmkiOiAiaHR0cHM6Ly9hY2NvdW50cy5nb29nbGUuY29tL28vb2F1dGgyL3Rva2VuIiwKICAiYXV0aF9wcm92aWRlcl94NTA5X2NlcnRfdXJsIjogImh0dHBzOi8vd3d3Lmdvb2dsZWFwaXMuY29tL29hdXRoMi92MS9jZXJ0cyIsCiAgImNsaWVudF94NTA5X2NlcnRfdXJsIjogImh0dHBzOi8vd3d3Lmdvb2dsZWFwaXMuY29tL3JvYm90L3YxL21ldGFkYXRhL3g1MDkvcGNmLWJpbmRpbmctODYzYjgxOTklNDBlY3MtcGNmLW9uLWdjZS0yMDE2LmlhbS5nc2VydmljZWFjY291bnQuY29tIgp9Cg==\"}','f80c0a3e-bd4d-4809-a900-b4e33a6450f1','789a8443-bb5d-47fe-a34e-36d28ed4bf8a','863b8199-05a2-4f41-a363-5313af5c0e29');

--
-- Table structure for table `service_instance_details`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `service_instance_details` (
  `id` varchar(255) NOT NULL DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `other_details` text,
  `service_id` varchar(255) DEFAULT NULL,
  `plan_id` varchar(255) DEFAULT NULL,
  `space_guid` varchar(255) DEFAULT NULL,
  `organization_guid` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
);
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `service_instance_details`
--

INSERT INTO `service_instance_details` VALUES ('6124a302-efd3-4971-b391-a2dd1c6546fd','2016-10-22 14:09:44','2016-10-22 14:12:50',NULL,'dev-small-mysql-01','us-central','https://www.googleapis.com/sql/v1beta4/projects/ecs-pcf-on-gce-2016/instances/dev-small-mysql-01','{\"Name\":\"2fad10a5-4574-4f2b-80dd-6b6abea94c2b\",\"Error\":\"\",\"InsertTime\":\"2016-10-22T14:09:44.170Z\",\"OperationType\":\"CREATE\",\"StartTime\":\"\",\"Status\":\"DONE\",\"TargetId\":\"dev-small-mysql-01\"}','4bc59b9a-8520-409f-85da-1c7552315863','23188783-c40e-45bb-8a52-bac898641feb','4596d7a4-cafd-4afd-924a-a00916e3efed','8f1b50cc-978b-433d-91da-b4552c8ada22');
INSERT INTO `service_instance_details` VALUES ('789a8443-bb5d-47fe-a34e-36d28ed4bf8a','2016-10-21 16:19:02','2016-10-21 16:19:02',NULL,'ecs_mydataset','US','https://www.googleapis.com/bigquery/v2/projects/ecs-pcf-on-gce-2016/datasets/ecs_mydataset','{}','f80c0a3e-bd4d-4809-a900-b4e33a6450f1','ec7113a9-b88c-4c4c-abf8-a61759ed0942','b7decc92-e551-47a4-99f2-06fc58b2910d','776fec1a-df52-4510-b52c-97f6731a93ee');
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2016-10-22 10:31:32