· 7 years ago · Sep 11, 2018, 10:52 AM
1DROP TABLE IF EXISTS `access_types`;
2CREATE TABLE `access_types` (
3 `type` int(10) unsigned NOT NULL,
4 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
5 PRIMARY KEY (`type`),
6 UNIQUE KEY `access_types_name_unique` (`name`)
7) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
8
9INSERT INTO `access_types` (`type`, `name`) VALUES
10(1, 'Read'),
11(2, 'Write');
12
13DROP TABLE IF EXISTS `entities`;
14CREATE TABLE `entities` (
15 `id` int(10) unsigned NOT NULL,
16 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
17 `logo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
18 `created_at` timestamp NULL DEFAULT NULL,
19 `updated_at` timestamp NULL DEFAULT NULL,
20 PRIMARY KEY (`id`)
21) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
22
23INSERT INTO `entities` (`id`, `name`, `logo`, `created_at`, `updated_at`) VALUES
24(1, 'Evollu', 'evollu.png', NULL, NULL),
25(2, 'GLINTT', NULL, NULL, NULL),
26(4, 'Farmácia de demonstração', NULL, NULL, NULL),
27(5, 'Farmácia 1', NULL, NULL, NULL),
28(6, 'Farmácia 2', NULL, NULL, NULL),
29(10, 'Widex', 'widex.png', NULL, NULL),
30(101, 'Farmácia Benfica', NULL, NULL, NULL),
31(102, 'Fórum Almada', NULL, NULL, NULL),
32(103, 'Farmácia joão Castro Rodrigues', NULL, NULL, NULL),
33(104, 'Farmácia Lisboa', NULL, NULL, NULL),
34(105, 'Farmácia Veritas Oueiras', NULL, NULL, NULL),
35(106, 'Farmácia Dias e Brito', NULL, NULL, NULL),
36(107, 'Farmácia Veritas', NULL, NULL, NULL);
37
38DROP TABLE IF EXISTS `info_types`;
39CREATE TABLE `info_types` (
40 `type` int(10) unsigned NOT NULL,
41 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
42 PRIMARY KEY (`type`),
43 UNIQUE KEY `info_types_name_unique` (`name`)
44) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
45
46INSERT INTO `info_types` (`type`, `name`) VALUES
47(2000, 'lead'),
48(1000, 'reference'),
49(100, 'user');
50
51DROP TABLE IF EXISTS `users`;
52CREATE TABLE `users` (
53 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
54 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
55 `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
56 `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
57 `entity_id` int(10) unsigned NOT NULL,
58 `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
59 `created_at` timestamp NULL DEFAULT NULL,
60 `updated_at` timestamp NULL DEFAULT NULL,
61 `deleted_at` timestamp NULL DEFAULT NULL,
62 PRIMARY KEY (`id`),
63 UNIQUE KEY `users_email_unique` (`email`),
64 KEY `users_entity_id_foreign` (`entity_id`),
65 CONSTRAINT `users_entity_id_foreign` FOREIGN KEY (`entity_id`) REFERENCES `entities` (`id`)
66) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
67
68INSERT INTO `users` (`id`, `name`, `email`, `password`, `entity_id`, `remember_token`, `created_at`, `updated_at`, `deleted_at`) VALUES
69(1, 'Luis Marcelino', 'luis.marcelino@evollu.com', '$2y$10$oCTddBW4jmMTyOxVoWXT2Oez8K7In99BJr8NaU/CdlswoeQmak0Jm', 1, NULL, NULL, NULL, NULL),
70(2, 'Sergio Paulo', 'sergio.paulo@evollu.com', '$2y$10$n4aqjOLikUlyZbzg3RvbmuZ5CVxeJmzAO808rzf.b5tZTuxQkUti.', 1, NULL, NULL, NULL, NULL),
71(3, 'Vitor Jesus', 'vitor.jesus@evollu.com', '$2y$10$NPr25znWbKSinNutAz60Mez/IPYkaO1KVjJ7KJ3mLswFU6y6wyYj6', 1, NULL, NULL, NULL, NULL),
72(4, 'Demo Farmácia', 'demo.farma@evollu.com', '$2y$10$QXzDNOWOOI.XGSBd0cpf7ecAZqEZXPYHd/lA42658HWPrmlRhzZj.', 4, NULL, NULL, NULL, NULL),
73(5, 'Farma1', 'farma1@mail.com', '$2y$10$8FznY8bbX5gCss0xX25F4ugWJm2vIWXZb.bUqcig46TwkWGEk0VPS', 4, NULL, NULL, NULL, NULL),
74(6, 'Farma2', 'farma2@mail.com', '$2y$10$g1iVtjF2xS/46dMfgi6ew.qBJh5lL1nbgZrC22NOt5lArxQuvsUDa', 4, NULL, NULL, NULL, NULL),
75(7, 'Farma3', 'farma3@mail.com', '$2y$10$M3EwJoJQqIte9BUEZotiCes8OxSuACIJ0MhgV1yneW6MHTnQ3cjZm', 5, NULL, NULL, NULL, NULL),
76(8, 'Farma4', 'farma4@mail.com', '$2y$10$QXn4ghnaX6C0y39Hvetp0uW0Ty6RLEgXY0roMjQ5nFJsdJEGEV/NW', 6, NULL, NULL, NULL, NULL),
77(9, 'widex', 'widex@mail.com', '$2y$10$cVkQ1nkOu3P2zL7j9VFG/ecbsEdnqTOlgr5iYkoUb/R.QrUYrmJQ6', 10, NULL, NULL, NULL, NULL),
78(10, 'Farmácia Benfica', 'farmaciabenfica.lx@gmail.com', '$2y$10$jBu8rNN7AvTYvPZLZPi0oe3ujZrMVQwG2aE/cQDqfNztS587.5lnu', 101, NULL, NULL, NULL, NULL),
79(11, 'Fórum Almada', 'farmacia.almadaforum@gmail.com', '$2y$10$laVZ0ZnEa9nekrKuOR74quY02Yt4jJAcINKFhxcRyre4ySqSBTv1G', 102, NULL, NULL, NULL, NULL),
80(12, 'Farmácia JCR', 'farmacia.jcr@gmail.com', '$2y$10$1vjOlfiuDk/3SGjje1.xx.2DLOtv9rvU4jX/rBGYK/qxW3DFYWMA2', 103, NULL, NULL, NULL, NULL),
81(13, 'Farmácia Lisboa', 'farmacialisboatelheiras@wedotalent.pt', '$2y$10$NJ6/YeA3Ib6GE.uXAULECu6JLlD99B8UhoQc5efcKKPf8.T4Njefa', 104, NULL, NULL, NULL, NULL),
82(14, 'Farmácia Dias e Brito', 'farmaciadiasebrito@gmail.com', '$2y$10$/VGme25tlwEaDPQk0XxmTuGczwSqS4zc6FwnJPVmcM1G5vthw7L/i', 106, NULL, NULL, NULL, NULL),
83(15, 'Margarida Seixas', 'margarida.seixas@pharmateam.com', '$2y$10$fjoj0anFaS.HucZCeHxzt.Bp3jR41Ai/t8.vMuPW4NrAaQ7Yhy2zq', 107, NULL, NULL, NULL, NULL),
84(16, 'Marta Silvério', 'marta.silverio@evollu.com', '$2y$10$Wxr/oOqs5B1nEoAtgpYUUuHz5.QvCfZ.gISKe0zNQBU1T6qsUxmru', 1, NULL, NULL, NULL, NULL),
85(17, 'Tiago Nunes', 'tiago.nunes@widex.pt', '$2y$10$FK4YZxlSBuKsVcJtbeq6yemrJ7Ds46pUXyCP0pgmGgg16YSqOz9lq', 10, NULL, NULL, NULL, NULL),
86(18, 'Alexandra Frazão', 'alexandra.frazao@widex.pt', '$2y$10$F980BAwbWEya7q129Ww.TeaNFUKCAUZAM3HkOezDKAH2zQUTrQMJW', 10, NULL, NULL, NULL, NULL),
87(19, 'Ricardo Domingues', 'ricardo.domingues@evollu.com', '$2y$10$oCTddBW4jmMTyOxVoWXT2Oez8K7In99BJr8NaU/CdlswoeQmak0Jm', 1, NULL, NULL, NULL, NULL);
88
89DROP TABLE IF EXISTS `users_permissions`;
90CREATE TABLE `users_permissions` (
91 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
92 `user_id` int(10) unsigned NOT NULL,
93 `entity_id` int(10) unsigned NOT NULL,
94 `access_type` int(10) unsigned NOT NULL,
95 `info_type` int(10) unsigned NOT NULL,
96 `updated_by` int(10) unsigned DEFAULT NULL,
97 `created_at` timestamp NULL DEFAULT NULL,
98 `updated_at` timestamp NULL DEFAULT NULL,
99 PRIMARY KEY (`id`),
100 KEY `users_permissions_user_id_foreign` (`user_id`),
101 KEY `users_permissions_entity_id_foreign` (`entity_id`),
102 KEY `users_permissions_access_type_foreign` (`access_type`),
103 KEY `users_permissions_info_type_foreign` (`info_type`),
104 KEY `users_permissions_updated_by_foreign` (`updated_by`),
105 CONSTRAINT `users_permissions_access_type_foreign` FOREIGN KEY (`access_type`) REFERENCES `access_types` (`type`),
106 CONSTRAINT `users_permissions_entity_id_foreign` FOREIGN KEY (`entity_id`) REFERENCES `entities` (`id`),
107 CONSTRAINT `users_permissions_info_type_foreign` FOREIGN KEY (`info_type`) REFERENCES `info_types` (`type`),
108 CONSTRAINT `users_permissions_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
109 CONSTRAINT `users_permissions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
110) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
111
112INSERT INTO `users_permissions` (`id`, `user_id`, `entity_id`, `access_type`, `info_type`, `updated_by`, `created_at`, `updated_at`) VALUES
113(1, 1, 1, 2, 1000, NULL, NULL, NULL),
114(2, 1, 5, 2, 1000, NULL, NULL, NULL),
115(3, 1, 1, 2, 2000, NULL, NULL, NULL),
116(4, 1, 4, 2, 2000, NULL, NULL, NULL),
117(5, 1, 4, 1, 1000, NULL, NULL, NULL),
118(6, 2, 1, 2, 1000, NULL, NULL, NULL),
119(7, 2, 6, 2, 1000, NULL, NULL, NULL),
120(8, 2, 4, 2, 1000, NULL, NULL, NULL),
121(9, 2, 4, 2, 2000, NULL, NULL, NULL),
122(10, 3, 1, 2, 1000, NULL, NULL, NULL),
123(11, 3, 1, 2, 2000, NULL, NULL, NULL),
124(12, 4, 4, 2, 1000, NULL, NULL, NULL),
125(13, 10, 101, 2, 1000, NULL, NULL, NULL),
126(14, 11, 102, 2, 1000, NULL, NULL, NULL),
127(15, 12, 103, 2, 1000, NULL, NULL, NULL),
128(16, 13, 104, 2, 1000, NULL, NULL, NULL),
129(17, 14, 106, 2, 1000, NULL, NULL, NULL),
130(18, 15, 107, 2, 1000, NULL, NULL, NULL),
131(19, 16, 4, 2, 1000, NULL, NULL, NULL),
132(20, 16, 1, 2, 1000, NULL, NULL, NULL),
133(21, 16, 1, 2, 2000, NULL, NULL, NULL),
134(22, 19, 4, 1, 100, NULL, NULL, NULL),
135(23, 19, 1, 2, 100, NULL, NULL, NULL),
136(26, 19, 1, 2, 1000, NULL, NULL, NULL),
137(27, 19, 1, 2, 2000, NULL, NULL, NULL);
138
139
140DROP TABLE IF EXISTS `authorization_codes`;
141CREATE TABLE `authorization_codes` (
142 `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
143 `user_id` int(10) unsigned NOT NULL,
144 `client_id` int(10) unsigned NOT NULL,
145 `scope` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
146 `ttl` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
147 PRIMARY KEY (`code`),
148 KEY `authorization_codes_user_id_foreign` (`user_id`),
149 KEY `authorization_codes_client_id_foreign` (`client_id`),
150 CONSTRAINT `authorization_codes_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`),
151 CONSTRAINT `authorization_codes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
152) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
153
154
155DROP TABLE IF EXISTS `clients`;
156CREATE TABLE `clients` (
157 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
158 `redirect_uri` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
159 `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
160 `description` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
161 `secret` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
162 PRIMARY KEY (`id`)
163) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
164
165INSERT INTO `clients` (`id`, `redirect_uri`, `name`, `description`, `secret`) VALUES
166(1, 'leads-dev.evollu.com', 'Leads', 'Evollu Leads', 'secretp@ssword');
167
168DROP TABLE IF EXISTS `refresh_tokens`;
169CREATE TABLE `refresh_tokens` (
170 `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
171 `user_id` int(10) unsigned NOT NULL,
172 `client_id` int(10) unsigned NOT NULL,
173 `scope` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
174 PRIMARY KEY (`token`),
175 KEY `refresh_tokens_user_id_foreign` (`user_id`),
176 KEY `refresh_tokens_client_id_foreign` (`client_id`),
177 CONSTRAINT `refresh_tokens_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`),
178 CONSTRAINT `refresh_tokens_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
179) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
180
181
182DROP TABLE IF EXISTS `tokens`;
183CREATE TABLE `tokens` (
184 `token` varchar(400) COLLATE latin1_bin NOT NULL,
185 `user_id` int(10) unsigned NOT NULL,
186 `client_id` int(10) unsigned NOT NULL,
187 `scope` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
188 `ttl` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
189 PRIMARY KEY (`token`),
190 KEY `tokens_user_id_foreign` (`user_id`),
191 KEY `tokens_client_id_foreign` (`client_id`),
192 CONSTRAINT `tokens_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`),
193 CONSTRAINT `tokens_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
194) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin;