· 5 years ago · Mar 25, 2020, 12:58 AM
1-- phpMyAdmin SQL Dump
2-- version 4.9.2
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1:3306
6-- Tempo de geração: 25-Mar-2020 às 00:53
7-- Versão do servidor: 8.0.18
8-- versão do PHP: 7.4.0
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Banco de dados: `infomeds`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Estrutura da tabela `tb_permissions`
29--
30
31DROP TABLE IF EXISTS `tb_permissions`;
32CREATE TABLE IF NOT EXISTS `tb_permissions` (
33 `id` int(11) NOT NULL AUTO_INCREMENT,
34 `user_id` int(11) NOT NULL,
35 `user_email` varchar(60) NOT NULL,
36 `permission_type` int(11) NOT NULL,
37 PRIMARY KEY (`id`),
38 KEY `fk_tb_permissions_tb_users1_idx` (`user_id`)
39) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
40
41--
42-- Extraindo dados da tabela `tb_permissions`
43--
44
45INSERT INTO `tb_permissions` (`id`, `user_id`, `user_email`, `permission_type`) VALUES
46(1, 1, 'wagnerspg@hotmail.com', 1);
47
48-- --------------------------------------------------------
49
50--
51-- Estrutura da tabela `tb_pharmacy`
52--
53
54DROP TABLE IF EXISTS `tb_pharmacy`;
55CREATE TABLE IF NOT EXISTS `tb_pharmacy` (
56 `id_pharm` int(11) NOT NULL AUTO_INCREMENT,
57 `name_pharm` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
58 `cnpj_pharm` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
59 `city_pharm` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
60 `state_pharm` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
61 `cep_pharm` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
62 `address_pharm` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
63 `telephone_pharm` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
64 `responsible_pharm` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
65 `email_pharm` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
66 `active_pharm` int(11) NOT NULL,
67 PRIMARY KEY (`id_pharm`)
68) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
69
70--
71-- Extraindo dados da tabela `tb_pharmacy`
72--
73
74INSERT INTO `tb_pharmacy` (`id_pharm`, `name_pharm`, `cnpj_pharm`, `city_pharm`, `state_pharm`, `cep_pharm`, `address_pharm`, `telephone_pharm`, `responsible_pharm`, `email_pharm`, `active_pharm`) VALUES
75(1, 'Farmácia Atacadão', '75315333013197', 'Aparecida de Goiânia', 'Goias', '74000000', 'AV Rio Verde, S/N,', '6232099315', 'Anderson Nunes', 'anderrrsonnn@gmail.com', 1),
76(2, 'Droga Pop', '12547852000125', 'Aparecida de Goiania', 'MA', '74355465', 'Rua Bla bla bla ', '62993441016', 'Wagner', 'wagnerspg@hotmail.com', 1);
77
78-- --------------------------------------------------------
79
80--
81-- Estrutura da tabela `tb_users`
82--
83
84DROP TABLE IF EXISTS `tb_users`;
85CREATE TABLE IF NOT EXISTS `tb_users` (
86 `user_id` int(11) NOT NULL AUTO_INCREMENT,
87 `firstname` varchar(20) NOT NULL,
88 `lastname` varchar(80) NOT NULL,
89 `cpf` varchar(11) NOT NULL,
90 `rg` varchar(11) DEFAULT NULL,
91 `birthday` date NOT NULL,
92 `naturalness` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
93 `crf` varchar(45) DEFAULT NULL,
94 `address` varchar(255) NOT NULL,
95 `telephone` varchar(12) NOT NULL,
96 `email` varchar(250) NOT NULL,
97 `password` varchar(128) NOT NULL,
98 `pharmacy_id` int(11) DEFAULT NULL,
99 `user_active` int(11) NOT NULL,
100 PRIMARY KEY (`user_id`),
101 KEY `fk_tb_users_tb_pharmacy1_idx` (`pharmacy_id`)
102) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
103
104--
105-- Extraindo dados da tabela `tb_users`
106--
107
108INSERT INTO `tb_users` (`user_id`, `firstname`, `lastname`, `cpf`, `rg`, `birthday`, `naturalness`, `crf`, `address`, `telephone`, `email`, `password`, `pharmacy_id`, `user_active`) VALUES
109(1, 'Wagner', 'Corrêa Rosa Veiga', '75192624134', '5725370', '0000-00-00', 'GO', NULL, 'Rua 49, Qd 76 Lote 05', '62993104894', 'wagnerspg@hotmail.com', 'fna9hkjuq', 1, 1),
110(2, 'Anderson', 'Nunes', '74125896325', '4525369', '1994-03-06', 'GO', '', 'Rua Montividil', '62984522002', 'anderrrsonnn@gmail.com', 'dasdsadsa', 2, 1),
111(3, 'Teste', 'testinho', '47856912302', '5623987', '0000-00-00', 'MA', '', 'Rua Bla bla bla', '62993441016', 'teste@hotmail.com', 'dsadasdasdas', 2, 1),
112(4, 'Droga', 'Pop', '7519262445', '', '1994-03-06', 'MA', '', 'Rua Bla bla bla', '62993441016', 'wagnerspg@hotmail.com', 'I9)Lqf7<*Kh', 1, 1);
113
114--
115-- Restrições para despejos de tabelas
116--
117
118--
119-- Limitadores para a tabela `tb_permissions`
120--
121ALTER TABLE `tb_permissions`
122 ADD CONSTRAINT `fk_tb_permissions_tb_users1` FOREIGN KEY (`user_id`) REFERENCES `tb_users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
123
124--
125-- Limitadores para a tabela `tb_users`
126--
127ALTER TABLE `tb_users`
128 ADD CONSTRAINT `fk_tb_users_tb_pharmacy1` FOREIGN KEY (`pharmacy_id`) REFERENCES `tb_pharmacy` (`id_pharm`) ON DELETE CASCADE ON UPDATE CASCADE;
129COMMIT;
130
131/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
132/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
133/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;