github.com/EngineerKamesh/gofullstack@v0.0.0-20180609171605-d41341d7d4ee/volume4/section2/gopherface/config/gfdbdump.sql (about) 1 -- MySQL dump 10.13 Distrib 5.7.18, for Linux (x86_64) 2 -- 3 -- Host: localhost Database: gopherfacedb 4 -- ------------------------------------------------------ 5 -- Server version 5.7.18 6 7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; 8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; 9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; 10 /*!40101 SET NAMES utf8 */; 11 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; 12 /*!40103 SET TIME_ZONE='+00:00' */; 13 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; 14 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; 15 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; 16 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; 17 18 -- 19 -- Table structure for table `friend_relation` 20 -- 21 22 DROP TABLE IF EXISTS `friend_relation`; 23 /*!40101 SET @saved_cs_client = @@character_set_client */; 24 /*!40101 SET character_set_client = utf8 */; 25 CREATE TABLE `friend_relation` ( 26 `owner_uuid` varchar(64) COLLATE utf8_unicode_ci NOT NULL, 27 `friend_uuid` varchar(64) COLLATE utf8_unicode_ci NOT NULL, 28 `created_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 29 `updated_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 30 UNIQUE KEY `relation` (`owner_uuid`,`friend_uuid`) 31 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 32 /*!40101 SET character_set_client = @saved_cs_client */; 33 34 -- 35 -- Dumping data for table `friend_relation` 36 -- 37 38 LOCK TABLES `friend_relation` WRITE; 39 /*!40000 ALTER TABLE `friend_relation` DISABLE KEYS */; 40 INSERT INTO `friend_relation` VALUES ('0d364cb6-7284-04ec-a7c5-5d794a035d61','4496dcd7-d29f-8153-56fa-dae61af5f4c2','2017-09-17 03:56:06','2017-09-17 03:56:06'),('0d364cb6-7284-04ec-a7c5-5d794a035d61','6f2a919b-b626-9402-2a5d-c290cf14afb3','2017-09-17 03:12:38','2017-09-17 03:12:38'),('6f2a919b-b626-9402-2a5d-c290cf14afb3','4496dcd7-d29f-8153-56fa-dae61af5f4c2','2017-09-17 03:09:15','2017-09-17 03:09:15'); 41 /*!40000 ALTER TABLE `friend_relation` ENABLE KEYS */; 42 UNLOCK TABLES; 43 44 -- 45 -- Table structure for table `post` 46 -- 47 48 DROP TABLE IF EXISTS `post`; 49 /*!40101 SET @saved_cs_client = @@character_set_client */; 50 /*!40101 SET character_set_client = utf8 */; 51 CREATE TABLE `post` ( 52 `uuid` varchar(64) COLLATE utf8_unicode_ci NOT NULL, 53 `title` varchar(65) COLLATE utf8_unicode_ci NOT NULL, 54 `body` varchar(255) COLLATE utf8_unicode_ci NOT NULL, 55 `mood` int(11) DEFAULT NULL, 56 `created_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 57 `updated_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP 58 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 59 /*!40101 SET character_set_client = @saved_cs_client */; 60 61 -- 62 -- Dumping data for table `post` 63 -- 64 65 LOCK TABLES `post` WRITE; 66 /*!40000 ALTER TABLE `post` DISABLE KEYS */; 67 INSERT INTO `post` VALUES ('4496dcd7-d29f-8153-56fa-dae61af5f4c2','Golang is awesome!','Hi! My name is ThreeD Gopher and this is my very first post on the Interwebs!\n\nI like programming in Go on the front-end and the back-end and I like making new gopher pals also!\n\nHit me up!',1,'2017-09-17 03:07:52','2017-09-17 03:07:52'),('6f2a919b-b626-9402-2a5d-c290cf14afb3','Welcome ThreeD!','Hey ThreeD!\n\nWelcome to GopherFace. Glad you could finally join the party!',8,'2017-09-17 03:10:18','2017-09-17 03:10:18'),('0d364cb6-7284-04ec-a7c5-5d794a035d61','I was busy merging code.','I was just going about my business merging code, but I had to look at what was going on in the GopherFace Feed!',9,'2017-09-17 03:12:03','2017-09-17 03:12:03'); 68 /*!40000 ALTER TABLE `post` ENABLE KEYS */; 69 UNLOCK TABLES; 70 71 -- 72 -- Table structure for table `user` 73 -- 74 75 DROP TABLE IF EXISTS `user`; 76 /*!40101 SET @saved_cs_client = @@character_set_client */; 77 /*!40101 SET character_set_client = utf8 */; 78 CREATE TABLE `user` ( 79 `id` tinyint(1) unsigned NOT NULL AUTO_INCREMENT, 80 `username` varchar(18) COLLATE utf8_unicode_ci NOT NULL, 81 `uuid` varchar(64) COLLATE utf8_unicode_ci NOT NULL, 82 `first_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL, 83 `last_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL, 84 `password_hash` char(64) COLLATE utf8_unicode_ci NOT NULL, 85 `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL, 86 `created_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 87 `updated_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 88 PRIMARY KEY (`id`), 89 UNIQUE KEY `username` (`username`) 90 ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 91 /*!40101 SET character_set_client = @saved_cs_client */; 92 93 -- 94 -- Dumping data for table `user` 95 -- 96 97 LOCK TABLES `user` WRITE; 98 /*!40000 ALTER TABLE `user` DISABLE KEYS */; 99 INSERT INTO `user` VALUES (1,'3DGopher','4496dcd7-d29f-8153-56fa-dae61af5f4c2','ThreeD','Gopher','d754ed9f64ac293b10268157f283ee23256fb32a4f8dedb25c8446ca5bcb0bb3','3dgopher@test.com','2017-09-16 03:16:51','2017-09-16 03:16:51'),(2,'Molly','6f2a919b-b626-9402-2a5d-c290cf14afb3','Molly','Gopher','d754ed9f64ac293b10268157f283ee23256fb32a4f8dedb25c8446ca5bcb0bb3','mollygopher@test.com','2017-09-16 03:23:44','2017-09-16 03:23:44'),(3,'Wintermute','0d364cb6-7284-04ec-a7c5-5d794a035d61','Wintermute','Gopher','d754ed9f64ac293b10268157f283ee23256fb32a4f8dedb25c8446ca5bcb0bb3','wintermute@test.com','2017-09-16 03:24:49','2017-09-16 03:24:49'),(4,'Case','935d0561-cebb-85ac-ab81-62685aee98a6','Case','Gopher','d754ed9f64ac293b10268157f283ee23256fb32a4f8dedb25c8446ca5bcb0bb3','case@test.com','2017-09-16 03:25:23','2017-09-16 03:25:23'),(5,'Linda','839964f4-140d-03c6-547c-9143092cef77','Linda','Gopher','d754ed9f64ac293b10268157f283ee23256fb32a4f8dedb25c8446ca5bcb0bb3','linda@test.com','2017-09-16 03:26:24','2017-09-16 03:26:24'),(6,'Riviera','0199063b-9936-ef19-04f3-7e38448e2b9c','Riviera','Gopher','d754ed9f64ac293b10268157f283ee23256fb32a4f8dedb25c8446ca5bcb0bb3','riviera@test.com','2017-09-16 03:27:10','2017-09-16 03:27:10'),(7,'Flatline','bc2589e1-130b-ff25-9c8d-c6459417270a','Flatline','Gopher','d754ed9f64ac293b10268157f283ee23256fb32a4f8dedb25c8446ca5bcb0bb3','flatline@test.com','2017-09-16 03:27:51','2017-09-16 03:27:51'),(8,'Jane','9e9e7389-6c07-3f4f-6404-665d3f53929b','Jane','Gopher','d754ed9f64ac293b10268157f283ee23256fb32a4f8dedb25c8446ca5bcb0bb3','jane@test.com','2017-09-16 03:28:45','2017-09-16 03:28:45'),(9,'Aerol','ea6c4fff-5471-3784-e91b-1e645482adde','Aerol','Gopher','d754ed9f64ac293b10268157f283ee23256fb32a4f8dedb25c8446ca5bcb0bb3','aerol@test.com','2017-09-16 03:29:29','2017-09-16 03:29:29'),(10,'Marie','6f7c4c58-a074-a8ed-8599-29699edbffac','Marie','Gopher','d754ed9f64ac293b10268157f283ee23256fb32a4f8dedb25c8446ca5bcb0bb3','marie@test.com','2017-09-16 03:31:10','2017-09-16 03:31:10'); 100 /*!40000 ALTER TABLE `user` ENABLE KEYS */; 101 UNLOCK TABLES; 102 103 -- 104 -- Table structure for table `user_profile` 105 -- 106 107 DROP TABLE IF EXISTS `user_profile`; 108 /*!40101 SET @saved_cs_client = @@character_set_client */; 109 /*!40101 SET character_set_client = utf8 */; 110 CREATE TABLE `user_profile` ( 111 `uuid` varchar(64) COLLATE utf8_unicode_ci NOT NULL, 112 `about` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', 113 `location` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', 114 `interests` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', 115 `profile_image_path` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', 116 `created_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 117 `updated_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 118 PRIMARY KEY (`uuid`), 119 UNIQUE KEY `uuid` (`uuid`) 120 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 121 /*!40101 SET character_set_client = @saved_cs_client */; 122 123 -- 124 -- Dumping data for table `user_profile` 125 -- 126 127 LOCK TABLES `user_profile` WRITE; 128 /*!40000 ALTER TABLE `user_profile` DISABLE KEYS */; 129 INSERT INTO `user_profile` VALUES ('0199063b-9936-ef19-04f3-7e38448e2b9c','I am an actor and performer.','Straylight','Acting','/static/uploads/images/b2dcbd58-9489-132e-b393-9965aa40d146_thumb.png','2017-09-16 03:48:28','2017-09-16 03:49:08'),('0d364cb6-7284-04ec-a7c5-5d794a035d61','I enjoy creating plans and making calculations.','Matrix','Merging Code','/static/uploads/images/2c2ef747-38b9-9968-8215-ce28099a8b63_thumb.png','2017-09-16 03:49:19','2017-09-16 03:51:01'),('4496dcd7-d29f-8153-56fa-dae61af5f4c2','I like to program in Go on both the back-end and the front-end.','Los Angeles','Go, Web Development','/static/uploads/images/3cc3af2b-9fb2-86b5-05b5-80e32a08b9d6_thumb.png','2017-09-16 03:18:48','2017-09-16 22:38:33'),('6f2a919b-b626-9402-2a5d-c290cf14afb3','I am a multi-talented individual.','Chiba City','Getting things done.','/static/uploads/images/0ef62347-cead-bfbf-6d23-7cdd84f8b080_thumb.png','2017-09-16 03:44:54','2017-09-16 03:48:09'),('6f7c4c58-a074-a8ed-8599-29699edbffac','I\'m into artificial intelligence.','Matrix','AI','/static/uploads/images/6f3196b0-ccdc-c335-3984-f1e6b206e6a1_thumb.png','2017-09-16 03:42:43','2017-09-16 03:43:48'),('839964f4-140d-03c6-547c-9143092cef77','I like to analyze logic.','Matrix','Coding','/static/uploads/images/5a4cd16c-93f1-5bff-cefb-5173e6d8f941_thumb.png','2017-09-16 03:39:39','2017-09-16 03:42:24'),('935d0561-cebb-85ac-ab81-62685aee98a6','Don\'t mind me, I\'m just finding my way through cyberspace.','Chiba City','Solving complex cases.','/static/uploads/images/38a52ac9-7704-60e7-b690-abfec7309162_thumb.png','2017-09-16 03:34:06','2017-09-16 03:35:13'),('9e9e7389-6c07-3f4f-6404-665d3f53929b','I love to party and have fun.','Straylight','Cloning','/static/uploads/images/f79db6c9-3189-20c0-f0fc-bbe5e5f57335_thumb.png','2017-09-16 03:37:22','2017-09-16 03:39:19'),('bc2589e1-130b-ff25-9c8d-c6459417270a','I\'m a console cowboy!','ROM','System Programming','/static/uploads/images/c868ac58-d7b6-f0b4-93f1-4d7249f55226_thumb.png','2017-09-16 03:35:34','2017-09-16 03:37:07'),('ea6c4fff-5471-3784-e91b-1e645482adde','Just another Zionite tagging along with Case and Molly.','Villa Straylight','Piloting, Crafts','/static/uploads/images/605f6d17-d3f2-9090-ada7-27e72d1ebf72_thumb.png','2017-09-16 03:31:53','2017-09-16 03:33:51'); 130 /*!40000 ALTER TABLE `user_profile` ENABLE KEYS */; 131 UNLOCK TABLES; 132 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; 133 134 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; 135 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; 136 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; 137 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; 138 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; 139 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; 140 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; 141 142 -- Dump completed on 2017-09-17 12:50:10