github.com/EngineerKamesh/gofullstack@v0.0.0-20180609171605-d41341d7d4ee/volume4/section3/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