From Tinct Giraffe, 5 Days ago, written in Text.
Embed
  1. # ************************************************************
  2. # Sequel Pro SQL dump
  3. # Version 4541
  4. #
  5. # http://www.sequelpro.com/
  6. # https://github.com/sequelpro/sequelpro
  7. #
  8. # Hôte: 127.0.0.1 (MySQL 5.7.19)
  9. # Base de données: api_platform
  10. # Temps de génération: 2018-01-11 11:43:08 +0000
  11. # ************************************************************
  12.  
  13.  
  14. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  15. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  16. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  17. /*!40101 SET NAMES utf8 */;
  18. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  19. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  20. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  21.  
  22.  
  23. # Affichage de la table auth_client
  24. # ------------------------------------------------------------
  25.  
  26. DROP TABLE IF EXISTS `auth_client`;
  27.  
  28. CREATE TABLE `auth_client` (
  29.   `id` int(11) NOT NULL AUTO_INCREMENT,
  30.   `random_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  31.   `redirect_uris` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  32.   `secret` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  33.   `allowed_grant_types` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  34.   PRIMARY KEY (`id`)
  35. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  36.  
  37. LOCK TABLES `auth_client` WRITE;
  38. /*!40000 ALTER TABLE `auth_client` DISABLE KEYS */;
  39.  
  40. INSERT INTO `auth_client` (`id`, `random_id`, `redirect_uris`, `secret`, `allowed_grant_types`)
  41. VALUES
  42.         (1,'4d581r6ycvokc0048k8gk0gs8gokkccscs4oockk0k00004k84','a:1:{i:0;s:19:\"https://dev.ecni.fr\";}','624b3vz7yd4wwog0o8oowcgow0css4ooswco80wc8c4kcw8ggs','a:2:{i:0;s:18:\"authorization_code\";i:1;s:5:\"token\";}'),
  43.         (2,'647eboqlg9ogwwccog0cc4w08sw44oggoogcsowg4cgc4ockoo','a:1:{i:0;s:19:\"https://dev.ecni.fr\";}','2gkmgqea0pgko844oc80c4co0440wgo808gg0gcgwkooo8wcc0','a:4:{i:0;s:8:\"password\";i:1;s:5:\"token\";i:2;s:28:\"https://dev.ecni.fr/facebook\";i:3;s:26:\"https://dev.ecni.fr/google\";}'),
  44.         (3,'4d581r6ycvokc0048k8gk0gs8gokkccscs4oockk0k00004k84','a:1:{i:0;s:19:\"https://dev.ecni.fr\";}','624b3vz7yd4wwog0o8oowcgow0css4ooswco80wc8c4kcw8ggs','a:2:{i:0;s:18:\"authorization_code\";i:1;s:5:\"token\";}');
  45.  
  46. /*!40000 ALTER TABLE `auth_client` ENABLE KEYS */;
  47. UNLOCK TABLES;
  48.  
  49.  
  50. # Affichage de la table auth_code
  51. # ------------------------------------------------------------
  52.  
  53. DROP TABLE IF EXISTS `auth_code`;
  54.  
  55. CREATE TABLE `auth_code` (
  56.   `id` int(11) NOT NULL AUTO_INCREMENT,
  57.   `client_id` int(11) NOT NULL,
  58.   `user_id` int(11) DEFAULT NULL,
  59.   `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  60.   `redirect_uri` longtext COLLATE utf8_unicode_ci NOT NULL,
  61.   `expires_at` int(11) DEFAULT NULL,
  62.   `scope` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  63.   PRIMARY KEY (`id`),
  64.   UNIQUE KEY `UNIQ_5933D02C5F37A13B` (`token`),
  65.   KEY `IDX_5933D02C19EB6921` (`client_id`),
  66.   KEY `IDX_5933D02CA76ED395` (`user_id`)
  67. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  68.  
  69.  
  70.  
  71.  
  72. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  73. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  74. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  75. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  76. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  77. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  78.