API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 12th, 2018
115
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.03 KB | None | 0 0
raw download clone embed print report
  1. -- Adminer 4.6.3 MySQL dump
  2.  
  3. SET NAMES utf8;
  4. SET time_zone = '+00:00';
  5. SET foreign_key_checks = 0;
  6. SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
  7.  
  8. DROP TABLE IF EXISTS `access_types`;
  9. CREATE TABLE `access_types` (
  10. `type` int(10) unsigned NOT NULL,
  11. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  12. PRIMARY KEY (`type`),
  13. UNIQUE KEY `access_types_name_unique` (`name`)
  14. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  15.  
  16. INSERT INTO `access_types` (`type`, `name`) VALUES
  17. (1, 'Read'),
  18. (2, 'Write');
  19.  
  20. DROP TABLE IF EXISTS `entities`;
  21. CREATE TABLE `entities` (
  22. `id` int(10) unsigned NOT NULL,
  23. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  24. `logo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  25. `created_at` timestamp NULL DEFAULT NULL,
  26. `updated_at` timestamp NULL DEFAULT NULL,
  27. PRIMARY KEY (`id`)
  28. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  29.  
  30. INSERT INTO `entities` (`id`, `name`, `logo`, `created_at`, `updated_at`) VALUES
  31. (1, 'Evollu', 'evollu.png', NULL, NULL),
  32. (2, 'GLINTT', NULL, NULL, NULL),
  33. (4, 'Farmácia de demonstração', NULL, NULL, NULL),
  34. (5, 'Farmácia 1', NULL, NULL, NULL),
  35. (6, 'Farmácia 2', NULL, NULL, NULL),
  36. (10, 'Widex', 'widex.png', NULL, NULL),
  37. (101, 'Farmácia Benfica', NULL, NULL, NULL),
  38. (102, 'Fórum Almada', NULL, NULL, NULL),
  39. (103, 'Farmácia joão Castro Rodrigues', NULL, NULL, NULL),
  40. (104, 'Farmácia Lisboa', NULL, NULL, NULL),
  41. (105, 'Farmácia Veritas Oueiras', NULL, NULL, NULL),
  42. (106, 'Farmácia Dias e Brito', NULL, NULL, NULL),
  43. (107, 'Farmácia Veritas', NULL, NULL, NULL);
  44.  
  45. DROP TABLE IF EXISTS `info_types`;
  46. CREATE TABLE `info_types` (
  47. `type` int(10) unsigned NOT NULL,
  48. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  49. PRIMARY KEY (`type`),
  50. UNIQUE KEY `info_types_name_unique` (`name`)
  51. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  52.  
  53. INSERT INTO `info_types` (`type`, `name`) VALUES
  54. (2000, 'lead'),
  55. (1000, 'reference'),
  56. (100, 'user');
  57.  
  58. DROP TABLE IF EXISTS `users`;
  59. CREATE TABLE `users` (
  60. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  61. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  62. `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  63. `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  64. `entity_id` int(10) unsigned NOT NULL,
  65. `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  66. `created_at` timestamp NULL DEFAULT NULL,
  67. `updated_at` timestamp NULL DEFAULT NULL,
  68. `deleted_at` timestamp NULL DEFAULT NULL,
  69. PRIMARY KEY (`id`),
  70. UNIQUE KEY `users_email_unique` (`email`),
  71. KEY `users_entity_id_foreign` (`entity_id`),
  72. CONSTRAINT `users_entity_id_foreign` FOREIGN KEY (`entity_id`) REFERENCES `entities` (`id`)
  73. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  74.  
  75. INSERT INTO `users` (`id`, `name`, `email`, `password`, `entity_id`, `remember_token`, `created_at`, `updated_at`, `deleted_at`) VALUES
  76. (1, 'Luis Marcelino', 'luis.marcelino@evollu.com', '$2y$10$oCTddBW4jmMTyOxVoWXT2Oez8K7In99BJr8NaU/CdlswoeQmak0Jm', 1, NULL, NULL, NULL, NULL),
  77. (2, 'Sergio Paulo', 'sergio.paulo@evollu.com', '$2y$10$n4aqjOLikUlyZbzg3RvbmuZ5CVxeJmzAO808rzf.b5tZTuxQkUti.', 1, NULL, NULL, NULL, NULL),
  78. (3, 'Vitor Jesus', 'vitor.jesus@evollu.com', '$2y$10$NPr25znWbKSinNutAz60Mez/IPYkaO1KVjJ7KJ3mLswFU6y6wyYj6', 1, NULL, NULL, NULL, NULL),
  79. (4, 'Demo Farmácia', 'demo.farma@evollu.com', '$2y$10$QXzDNOWOOI.XGSBd0cpf7ecAZqEZXPYHd/lA42658HWPrmlRhzZj.', 4, NULL, NULL, NULL, NULL),
  80. (5, 'Farma1', 'farma1@mail.com', '$2y$10$8FznY8bbX5gCss0xX25F4ugWJm2vIWXZb.bUqcig46TwkWGEk0VPS', 4, NULL, NULL, NULL, NULL),
  81. (6, 'Farma2', 'farma2@mail.com', '$2y$10$g1iVtjF2xS/46dMfgi6ew.qBJh5lL1nbgZrC22NOt5lArxQuvsUDa', 4, NULL, NULL, NULL, NULL),
  82. (7, 'Farma3', 'farma3@mail.com', '$2y$10$M3EwJoJQqIte9BUEZotiCes8OxSuACIJ0MhgV1yneW6MHTnQ3cjZm', 5, NULL, NULL, NULL, NULL),
  83. (8, 'Farma4', 'farma4@mail.com', '$2y$10$QXn4ghnaX6C0y39Hvetp0uW0Ty6RLEgXY0roMjQ5nFJsdJEGEV/NW', 6, NULL, NULL, NULL, NULL),
  84. (9, 'widex', 'widex@mail.com', '$2y$10$cVkQ1nkOu3P2zL7j9VFG/ecbsEdnqTOlgr5iYkoUb/R.QrUYrmJQ6', 10, NULL, NULL, NULL, NULL),
  85. (10, 'Farmácia Benfica', 'farmaciabenfica.lx@gmail.com', '$2y$10$jBu8rNN7AvTYvPZLZPi0oe3ujZrMVQwG2aE/cQDqfNztS587.5lnu', 101, NULL, NULL, NULL, NULL),
  86. (11, 'Fórum Almada', 'farmacia.almadaforum@gmail.com', '$2y$10$laVZ0ZnEa9nekrKuOR74quY02Yt4jJAcINKFhxcRyre4ySqSBTv1G', 102, NULL, NULL, NULL, NULL),
  87. (12, 'Farmácia JCR', 'farmacia.jcr@gmail.com', '$2y$10$1vjOlfiuDk/3SGjje1.xx.2DLOtv9rvU4jX/rBGYK/qxW3DFYWMA2', 103, NULL, NULL, NULL, NULL),
  88. (13, 'Farmácia Lisboa', 'farmacialisboatelheiras@wedotalent.pt', '$2y$10$NJ6/YeA3Ib6GE.uXAULECu6JLlD99B8UhoQc5efcKKPf8.T4Njefa', 104, NULL, NULL, NULL, NULL),
  89. (14, 'Farmácia Dias e Brito', 'farmaciadiasebrito@gmail.com', '$2y$10$/VGme25tlwEaDPQk0XxmTuGczwSqS4zc6FwnJPVmcM1G5vthw7L/i', 106, NULL, NULL, NULL, NULL),
  90. (15, 'Margarida Seixas', 'margarida.seixas@pharmateam.com', '$2y$10$fjoj0anFaS.HucZCeHxzt.Bp3jR41Ai/t8.vMuPW4NrAaQ7Yhy2zq', 107, NULL, NULL, NULL, NULL),
  91. (16, 'Marta Silvério', 'marta.silverio@evollu.com', '$2y$10$Wxr/oOqs5B1nEoAtgpYUUuHz5.QvCfZ.gISKe0zNQBU1T6qsUxmru', 1, NULL, NULL, NULL, NULL),
  92. (17, 'Tiago Nunes', 'tiago.nunes@widex.pt', '$2y$10$FK4YZxlSBuKsVcJtbeq6yemrJ7Ds46pUXyCP0pgmGgg16YSqOz9lq', 10, NULL, NULL, NULL, NULL),
  93. (18, 'Alexandra Frazão', 'alexandra.frazao@widex.pt', '$2y$10$F980BAwbWEya7q129Ww.TeaNFUKCAUZAM3HkOezDKAH2zQUTrQMJW', 10, NULL, NULL, NULL, NULL),
  94. (19, 'Ricardo Domingues', 'ricardo.domingues@evollu.com', '$2y$10$oCTddBW4jmMTyOxVoWXT2Oez8K7In99BJr8NaU/CdlswoeQmak0Jm', 1, NULL, NULL, NULL, NULL);
  95.  
  96. DROP TABLE IF EXISTS `users_permissions`;
  97. CREATE TABLE `users_permissions` (
  98. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  99. `user_id` int(10) unsigned NOT NULL,
  100. `entity_id` int(10) unsigned NOT NULL,
  101. `access_type` int(10) unsigned NOT NULL,
  102. `info_type` int(10) unsigned NOT NULL,
  103. `updated_by` int(10) unsigned DEFAULT NULL,
  104. `created_at` timestamp NULL DEFAULT NULL,
  105. `updated_at` timestamp NULL DEFAULT NULL,
  106. PRIMARY KEY (`id`),
  107. KEY `users_permissions_user_id_foreign` (`user_id`),
  108. KEY `users_permissions_entity_id_foreign` (`entity_id`),
  109. KEY `users_permissions_access_type_foreign` (`access_type`),
  110. KEY `users_permissions_info_type_foreign` (`info_type`),
  111. KEY `users_permissions_updated_by_foreign` (`updated_by`),
  112. CONSTRAINT `users_permissions_access_type_foreign` FOREIGN KEY (`access_type`) REFERENCES `access_types` (`type`),
  113. CONSTRAINT `users_permissions_entity_id_foreign` FOREIGN KEY (`entity_id`) REFERENCES `entities` (`id`),
  114. CONSTRAINT `users_permissions_info_type_foreign` FOREIGN KEY (`info_type`) REFERENCES `info_types` (`type`),
  115. CONSTRAINT `users_permissions_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
  116. CONSTRAINT `users_permissions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
  117. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  118.  
  119. INSERT INTO `users_permissions` (`id`, `user_id`, `entity_id`, `access_type`, `info_type`, `updated_by`, `created_at`, `updated_at`) VALUES
  120. (1, 1, 1, 2, 1000, NULL, NULL, NULL),
  121. (2, 1, 5, 2, 1000, NULL, NULL, NULL),
  122. (3, 1, 1, 2, 2000, NULL, NULL, NULL),
  123. (4, 1, 4, 2, 2000, NULL, NULL, NULL),
  124. (5, 1, 4, 1, 1000, NULL, NULL, NULL),
  125. (6, 2, 1, 2, 1000, NULL, NULL, NULL),
  126. (7, 2, 6, 2, 1000, NULL, NULL, NULL),
  127. (8, 2, 4, 2, 1000, NULL, NULL, NULL),
  128. (9, 2, 4, 2, 2000, NULL, NULL, NULL),
  129. (10, 3, 1, 2, 1000, NULL, NULL, NULL),
  130. (11, 3, 1, 2, 2000, NULL, NULL, NULL),
  131. (12, 4, 4, 2, 1000, NULL, NULL, NULL),
  132. (13, 10, 101, 2, 1000, NULL, NULL, NULL),
  133. (14, 11, 102, 2, 1000, NULL, NULL, NULL),
  134. (15, 12, 103, 2, 1000, NULL, NULL, NULL),
  135. (16, 13, 104, 2, 1000, NULL, NULL, NULL),
  136. (17, 14, 106, 2, 1000, NULL, NULL, NULL),
  137. (18, 15, 107, 2, 1000, NULL, NULL, NULL),
  138. (19, 16, 4, 2, 1000, NULL, NULL, NULL),
  139. (20, 16, 1, 2, 1000, NULL, NULL, NULL),
  140. (21, 16, 1, 2, 2000, NULL, NULL, NULL),
  141. (22, 19, 4, 1, 100, NULL, NULL, NULL),
  142. (23, 19, 1, 2, 100, NULL, NULL, NULL),
  143. (26, 19, 1, 2, 1000, NULL, NULL, NULL),
  144. (27, 19, 1, 2, 2000, NULL, NULL, NULL);
  145.  
  146. -- 2018-09-12 08:17:04
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!