· 7 years ago · Sep 12, 2018, 08:20 AM
1-- Adminer 4.6.3 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `access_types`;
9CREATE 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
16INSERT INTO `access_types` (`type`, `name`) VALUES
17(1, 'Read'),
18(2, 'Write');
19
20DROP TABLE IF EXISTS `entities`;
21CREATE 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
30INSERT 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
45DROP TABLE IF EXISTS `info_types`;
46CREATE 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
53INSERT INTO `info_types` (`type`, `name`) VALUES
54(2000, 'lead'),
55(1000, 'reference'),
56(100, 'user');
57
58DROP TABLE IF EXISTS `users`;
59CREATE 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
75INSERT 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
96DROP TABLE IF EXISTS `users_permissions`;
97CREATE 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
119INSERT 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