· 5 years ago · Mar 28, 2020, 08:36 PM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Versión del servidor: 10.4.12-MariaDB - mariadb.org binary distribution
4-- SO del servidor: Win64
5-- HeidiSQL Versión: 11.0.0.5919
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14
15-- Volcando estructura de base de datos para animal_care
16CREATE DATABASE IF NOT EXISTS `animal_care` /*!40100 DEFAULT CHARACTER SET utf8 */;
17USE `animal_care`;
18
19-- Volcando estructura para tabla animal_care.animal
20CREATE TABLE IF NOT EXISTS `animal` (
21 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
22 `nombre` varchar(50) DEFAULT NULL,
23 `descripcion` varchar(255) DEFAULT NULL,
24 `fecha_nacimiento` date DEFAULT NULL,
25 `estado_id` int(11) unsigned NOT NULL,
26 `usuario_id` int(11) unsigned NOT NULL,
27 `tipo_animal_id` int(11) unsigned NOT NULL,
28 `raza_animal_id` int(11) unsigned DEFAULT NULL,
29 `sexo_animal_id` int(11) unsigned DEFAULT NULL,
30 `imagen_id` int(11) unsigned DEFAULT NULL,
31 `creacion` timestamp NOT NULL DEFAULT current_timestamp(),
32 `ultima_actualizacion` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
33 PRIMARY KEY (`id`),
34 KEY `FK_animal_tipo_animal` (`tipo_animal_id`),
35 KEY `FK_animal_raza_animal` (`raza_animal_id`),
36 KEY `FK_animal_sexo_animal` (`sexo_animal_id`),
37 KEY `FK_animal_estado` (`estado_id`),
38 KEY `FK_animal_usuario` (`usuario_id`),
39 KEY `FK_animal_imagen` (`imagen_id`),
40 CONSTRAINT `FK_animal_estado` FOREIGN KEY (`estado_id`) REFERENCES `estado` (`id`) ON UPDATE CASCADE,
41 CONSTRAINT `FK_animal_imagen` FOREIGN KEY (`imagen_id`) REFERENCES `imagen` (`id`) ON UPDATE CASCADE,
42 CONSTRAINT `FK_animal_raza_animal` FOREIGN KEY (`raza_animal_id`) REFERENCES `raza_animal` (`id`) ON UPDATE CASCADE,
43 CONSTRAINT `FK_animal_sexo_animal` FOREIGN KEY (`sexo_animal_id`) REFERENCES `sexo_animal` (`id`) ON UPDATE CASCADE,
44 CONSTRAINT `FK_animal_tipo_animal` FOREIGN KEY (`tipo_animal_id`) REFERENCES `tipo_animal` (`id`) ON UPDATE CASCADE,
45 CONSTRAINT `FK_animal_usuario` FOREIGN KEY (`usuario_id`) REFERENCES `usuario` (`id`) ON UPDATE CASCADE
46) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
47
48-- Volcando datos para la tabla animal_care.animal: ~0 rows (aproximadamente)
49DELETE FROM `animal`;
50/*!40000 ALTER TABLE `animal` DISABLE KEYS */;
51INSERT INTO `animal` (`id`, `nombre`, `descripcion`, `fecha_nacimiento`, `estado_id`, `usuario_id`, `tipo_animal_id`, `raza_animal_id`, `sexo_animal_id`, `imagen_id`, `creacion`, `ultima_actualizacion`) VALUES
52 (1, 'animal', 'descanimal', '2020-03-28', 1, 12, 1, 1, 1, 1, '2020-03-28 15:01:48', '2020-03-28 15:53:47'),
53 (2, 'animal2', 'descanimal', '2020-03-28', 1, 12, 1, NULL, 2, 3, '2020-03-28 15:01:48', '2020-03-28 18:00:55'),
54 (3, 'animal3', 'descanimal', '2020-03-28', 1, 12, 1, 44, 1, 4, '2020-03-28 15:01:48', '2020-03-28 18:00:48'),
55 (4, 'animal4', 'descanimal', '2020-03-28', 1, 12, 1, 85, 1, 5, '2020-03-28 15:01:48', '2020-03-28 17:59:50');
56/*!40000 ALTER TABLE `animal` ENABLE KEYS */;
57
58-- Volcando estructura para tabla animal_care.estado
59CREATE TABLE IF NOT EXISTS `estado` (
60 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
61 `nombre` varchar(50) NOT NULL,
62 `creacion` timestamp NOT NULL DEFAULT current_timestamp(),
63 `ultima_actualizacion` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
64 PRIMARY KEY (`id`)
65) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
66
67-- Volcando datos para la tabla animal_care.estado: ~2 rows (aproximadamente)
68DELETE FROM `estado`;
69/*!40000 ALTER TABLE `estado` DISABLE KEYS */;
70INSERT INTO `estado` (`id`, `nombre`, `creacion`, `ultima_actualizacion`) VALUES
71 (1, 'Activo', '2020-03-07 17:29:52', '2020-03-07 17:29:52'),
72 (2, 'Inactivo', '2020-03-07 17:29:52', '2020-03-07 17:29:52');
73/*!40000 ALTER TABLE `estado` ENABLE KEYS */;
74
75-- Volcando estructura para tabla animal_care.imagen
76CREATE TABLE IF NOT EXISTS `imagen` (
77 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
78 `url` varchar(2048) NOT NULL,
79 `creacion` timestamp NOT NULL DEFAULT current_timestamp(),
80 `ultima_actualizacion` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
81 PRIMARY KEY (`id`)
82) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
83
84-- Volcando datos para la tabla animal_care.imagen: ~0 rows (aproximadamente)
85DELETE FROM `imagen`;
86/*!40000 ALTER TABLE `imagen` DISABLE KEYS */;
87INSERT INTO `imagen` (`id`, `url`, `creacion`, `ultima_actualizacion`) VALUES
88 (1, 'https://www.mundoperros.es/wp-content/uploads/2018/01/perro-callejero-1-830x553.jpg', '2020-03-28 15:53:40', '2020-03-28 15:53:40'),
89 (3, 'https://cdn2.melodijolola.com/media/files/styles/nota_imagen/public/field/image/istock-1134106600.jpg', '2020-03-28 15:53:40', '2020-03-28 17:58:12'),
90 (4, 'https://static.nationalgeographic.es/files/styles/image_1900/public/01-stray-dogs-nationalgeographic_1927666.jpg', '2020-03-28 15:53:40', '2020-03-28 17:58:14'),
91 (5, 'https://www.elcomercio.com/files/article_main/uploads/2019/08/22/5d5f2626e09a0.jpeg', '2020-03-28 15:53:40', '2020-03-28 17:58:19'),
92 (6, 'https://www.la-razon.com/suplementos/mia/mascota_LRZIMA20140305_0044_11.jpg', '2020-03-28 15:53:40', '2020-03-28 17:58:24');
93/*!40000 ALTER TABLE `imagen` ENABLE KEYS */;
94
95-- Volcando estructura para tabla animal_care.provincia
96CREATE TABLE IF NOT EXISTS `provincia` (
97 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
98 `nombre` varchar(50) NOT NULL,
99 `creacion` timestamp NOT NULL DEFAULT current_timestamp(),
100 `ultima_actualizacion` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
101 PRIMARY KEY (`id`)
102) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
103
104-- Volcando datos para la tabla animal_care.provincia: ~50 rows (aproximadamente)
105DELETE FROM `provincia`;
106/*!40000 ALTER TABLE `provincia` DISABLE KEYS */;
107INSERT INTO `provincia` (`id`, `nombre`, `creacion`, `ultima_actualizacion`) VALUES
108 (1, 'A Coruña', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
109 (2, 'Álava', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
110 (3, 'Albacete', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
111 (4, 'Alicante', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
112 (5, 'Almería', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
113 (6, 'Asturias', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
114 (7, 'Ávila', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
115 (8, 'Badajoz', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
116 (9, 'Baleares', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
117 (10, 'Barcelona', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
118 (11, 'Burgos', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
119 (12, 'Cáceres', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
120 (13, 'Cádiz', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
121 (14, 'Cantabria', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
122 (15, 'Castellón', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
123 (16, 'Ciudad Real', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
124 (17, 'Córdoba', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
125 (18, 'Cuenca', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
126 (19, 'Girona', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
127 (20, 'Granada', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
128 (21, 'Guadalajara', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
129 (22, 'Gipuzkoa', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
130 (23, 'Huelva', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
131 (24, 'Huesca', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
132 (25, 'Jaén', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
133 (26, 'La Rioja', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
134 (27, 'Las Palmas', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
135 (28, 'León', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
136 (29, 'Lérida', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
137 (30, 'Lugo', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
138 (31, 'Madrid', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
139 (32, 'Málaga', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
140 (33, 'Murcia', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
141 (34, 'Navarra', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
142 (35, 'Ourense', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
143 (36, 'Palencia', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
144 (37, 'Pontevedra', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
145 (38, 'Salamanca', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
146 (39, 'Segovia', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
147 (40, 'Sevilla', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
148 (41, 'Soria', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
149 (42, 'Tarragona', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
150 (43, 'Santa Cruz de Tenerife', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
151 (44, 'Teruel', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
152 (45, 'Toledo', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
153 (46, 'Valencia', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
154 (47, 'Valladolid', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
155 (48, 'Vizcaya', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
156 (49, 'Zamora', '2020-03-07 17:27:12', '2020-03-07 17:27:12'),
157 (50, 'Zaragoza', '2020-03-07 17:27:12', '2020-03-07 17:27:12');
158/*!40000 ALTER TABLE `provincia` ENABLE KEYS */;
159
160-- Volcando estructura para tabla animal_care.publicacion
161CREATE TABLE IF NOT EXISTS `publicacion` (
162 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
163 `titulo` varchar(50) NOT NULL,
164 `descripcion` varchar(255) DEFAULT NULL,
165 `referencia` varchar(50) DEFAULT NULL,
166 `direccion` varchar(255) DEFAULT NULL,
167 `visualizaciones` int(11) unsigned NOT NULL DEFAULT 0,
168 `estado_id` int(11) unsigned NOT NULL,
169 `usuario_id` int(11) unsigned DEFAULT NULL,
170 `provincia_id` int(11) unsigned DEFAULT NULL,
171 `animal_id` int(11) unsigned NOT NULL,
172 `creacion` timestamp NOT NULL DEFAULT current_timestamp(),
173 `ultima_actualizacion` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
174 PRIMARY KEY (`id`),
175 KEY `FK_publicacion_provincia` (`provincia_id`),
176 KEY `FK_publicacion_animal` (`animal_id`),
177 KEY `FK_publicacion_estado` (`estado_id`),
178 KEY `FK_publicacion_usuario` (`usuario_id`),
179 CONSTRAINT `FK_publicacion_animal` FOREIGN KEY (`animal_id`) REFERENCES `animal` (`id`) ON UPDATE CASCADE,
180 CONSTRAINT `FK_publicacion_estado` FOREIGN KEY (`estado_id`) REFERENCES `estado` (`id`) ON UPDATE CASCADE,
181 CONSTRAINT `FK_publicacion_provincia` FOREIGN KEY (`provincia_id`) REFERENCES `provincia` (`id`) ON UPDATE CASCADE,
182 CONSTRAINT `FK_publicacion_usuario` FOREIGN KEY (`usuario_id`) REFERENCES `usuario` (`id`) ON UPDATE CASCADE
183) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
184
185-- Volcando datos para la tabla animal_care.publicacion: ~1 rows (aproximadamente)
186DELETE FROM `publicacion`;
187/*!40000 ALTER TABLE `publicacion` DISABLE KEYS */;
188INSERT INTO `publicacion` (`id`, `titulo`, `descripcion`, `referencia`, `direccion`, `visualizaciones`, `estado_id`, `usuario_id`, `provincia_id`, `animal_id`, `creacion`, `ultima_actualizacion`) VALUES
189 (1, 'titulo 1 2 3', 'descpubl', 'ref-123', 'rocafort', 0, 1, 12, 2, 1, '2020-03-28 15:02:33', '2020-03-28 19:41:23'),
190 (2, 'titul2o', 'descpubl', 'ref-123', 'rocafort', 0, 1, 12, 7, 2, '2020-03-28 15:02:33', '2020-03-28 17:59:24'),
191 (3, '3', 'descpubl', 'ref-123', 'rocafort', 0, 1, 12, 22, 3, '2020-03-28 15:02:33', '2020-03-28 17:59:25'),
192 (4, '4', 'descpubl', 'ref-123', 'rocafort', 0, 1, 12, 20, 4, '2020-03-28 15:02:33', '2020-03-28 17:59:27');
193/*!40000 ALTER TABLE `publicacion` ENABLE KEYS */;
194
195-- Volcando estructura para tabla animal_care.raza_animal
196CREATE TABLE IF NOT EXISTS `raza_animal` (
197 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
198 `nombre` varchar(50) NOT NULL,
199 `tipo_animal_id` int(11) unsigned NOT NULL,
200 `creacion` timestamp NOT NULL DEFAULT current_timestamp(),
201 `ultima_actualizacion` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
202 PRIMARY KEY (`id`),
203 KEY `FK_raza_animal_tipo_animal` (`tipo_animal_id`),
204 CONSTRAINT `FK_raza_animal_tipo_animal` FOREIGN KEY (`tipo_animal_id`) REFERENCES `tipo_animal` (`id`) ON UPDATE CASCADE
205) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
206
207-- Volcando datos para la tabla animal_care.raza_animal: ~88 rows (aproximadamente)
208DELETE FROM `raza_animal`;
209/*!40000 ALTER TABLE `raza_animal` DISABLE KEYS */;
210INSERT INTO `raza_animal` (`id`, `nombre`, `tipo_animal_id`, `creacion`, `ultima_actualizacion`) VALUES
211 (1, 'Alano', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
212 (2, 'Alaskan Malamute', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
213 (3, 'American Staffordshire Terrier', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
214 (4, 'American Water Spaniel', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
215 (5, 'Antiguo Pastor Inglés', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
216 (6, 'Basset Azul de Gaseogne', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
217 (7, 'Basset Hound', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
218 (8, 'Basset leonado de Bretaña', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
219 (9, 'Beagle', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
220 (10, 'Bearded Collie', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
221 (11, 'Bichón Maltés', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
222 (12, 'Bobtail', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
223 (13, 'Border Collie', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
224 (14, 'Boston Terrier', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
225 (15, 'Boxer', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
226 (16, 'Bull Terrier', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
227 (17, 'Bulldog Americano', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
228 (18, 'Bulldog Francés', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
229 (19, 'Bulldog Inglés', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
230 (20, 'Caniche', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
231 (21, 'Carlino', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
232 (22, 'Chihuahua', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
233 (23, 'Cirneco del Etna', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
234 (24, 'Chow Chow', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
235 (25, 'Cocker Spaniel Americano', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
236 (26, 'Cocker Spaniel Inglés', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
237 (27, 'Dálmata', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
238 (28, 'Dobermann', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
239 (29, 'Dogo Alemán', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
240 (30, 'Dogo Argentino', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
241 (31, 'Dogo de Burdeos', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
242 (32, 'Finlandés', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
243 (33, 'Fox Terrier de pelo liso', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
244 (34, 'Fox Terrier', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
245 (35, 'Foxhound Americano', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
246 (36, 'Foxhound Inglés', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
247 (37, 'Galgo Afgano', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
248 (38, 'Gigante de los Pirineos', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
249 (39, 'Golden Retriever', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
250 (40, 'Gran Danés', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
251 (41, 'Husky Siberiano', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
252 (42, 'Laika de Siberia Occidental', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
253 (43, 'Laika Ruso-europeo', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
254 (44, 'Labrador Retriever', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
255 (45, 'Mastín del Pirineo', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
256 (46, 'Mastin del Tibet', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
257 (47, 'Mastín Español', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
258 (48, 'Mastín Napolitano', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
259 (49, 'Pastor Alemán', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
260 (50, 'Pastor Australiano', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
261 (51, 'Pastor Belga', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
262 (52, 'Pastor de Brie', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
263 (53, 'Pastor de los Pirineos de Cara Rosa', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
264 (54, 'Pekinés', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
265 (55, 'Perdiguero Chesapeake Bay', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
266 (56, 'Perdiguero de Drentse', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
267 (57, 'Perdiguero de Pelo lido', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
268 (58, 'Perdiguero de pelo rizado', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
269 (59, 'Perdiguero Portugués', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
270 (60, 'Pitbull', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
271 (61, 'Podenco Ibicenco', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
272 (62, 'Podenco Portugués', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
273 (63, 'presa canario', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
274 (64, 'Presa Mallorquin', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
275 (65, 'Rottweiler', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
276 (66, 'Rough Collie', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
277 (67, 'Sabueso Español', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
278 (68, 'Sabueso Hélenico', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
279 (69, 'Sabueso Italiano', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
280 (70, 'Sabueso Suizo', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
281 (71, 'Samoyedo', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
282 (72, 'San Bernardo', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
283 (73, 'Scottish Terrier', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
284 (74, 'Setter Irlandés', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
285 (75, 'Shar Pei', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
286 (76, 'Shiba Inu', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
287 (77, 'Siberian Husky', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
288 (78, 'Staffordshire Bull Terrier', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
289 (79, 'Teckel', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
290 (80, 'Terranova', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
291 (81, 'Terrier Australiano', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
292 (82, 'Terrier Escocés', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
293 (83, 'Terrier Irlandés', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
294 (84, 'Terrier Japonés', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
295 (85, 'Terrier Negro Ruso', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
296 (86, 'Terrier Norfolk', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
297 (87, 'Terrier Norwich', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19'),
298 (88, 'Yorkshire Terrier', 1, '2020-03-07 17:28:19', '2020-03-07 17:28:19');
299/*!40000 ALTER TABLE `raza_animal` ENABLE KEYS */;
300
301-- Volcando estructura para tabla animal_care.rol_usuario
302CREATE TABLE IF NOT EXISTS `rol_usuario` (
303 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
304 `nombre` varchar(50) NOT NULL,
305 `creacion` timestamp NOT NULL DEFAULT current_timestamp(),
306 `ultima_actualizacion` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
307 PRIMARY KEY (`id`)
308) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
309
310-- Volcando datos para la tabla animal_care.rol_usuario: ~3 rows (aproximadamente)
311DELETE FROM `rol_usuario`;
312/*!40000 ALTER TABLE `rol_usuario` DISABLE KEYS */;
313INSERT INTO `rol_usuario` (`id`, `nombre`, `creacion`, `ultima_actualizacion`) VALUES
314 (1, 'Superadmin', '2020-03-07 17:28:23', '2020-03-07 17:28:23'),
315 (2, 'Particular', '2020-03-07 17:28:23', '2020-03-07 17:28:23'),
316 (3, 'Profesional', '2020-03-07 17:28:23', '2020-03-07 17:28:23');
317/*!40000 ALTER TABLE `rol_usuario` ENABLE KEYS */;
318
319-- Volcando estructura para tabla animal_care.sexo_animal
320CREATE TABLE IF NOT EXISTS `sexo_animal` (
321 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
322 `nombre` varchar(50) NOT NULL,
323 `creacion` timestamp NOT NULL DEFAULT current_timestamp(),
324 `ultima_actualizacion` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
325 PRIMARY KEY (`id`)
326) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
327
328-- Volcando datos para la tabla animal_care.sexo_animal: ~2 rows (aproximadamente)
329DELETE FROM `sexo_animal`;
330/*!40000 ALTER TABLE `sexo_animal` DISABLE KEYS */;
331INSERT INTO `sexo_animal` (`id`, `nombre`, `creacion`, `ultima_actualizacion`) VALUES
332 (1, 'Macho', '2020-03-07 17:28:26', '2020-03-07 17:28:26'),
333 (2, 'Hembra', '2020-03-07 17:28:26', '2020-03-07 17:28:26');
334/*!40000 ALTER TABLE `sexo_animal` ENABLE KEYS */;
335
336-- Volcando estructura para tabla animal_care.tipo_animal
337CREATE TABLE IF NOT EXISTS `tipo_animal` (
338 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
339 `nombre` varchar(50) NOT NULL,
340 `creacion` timestamp NOT NULL DEFAULT current_timestamp(),
341 `ultima_actualizacion` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
342 PRIMARY KEY (`id`)
343) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
344
345-- Volcando datos para la tabla animal_care.tipo_animal: ~0 rows (aproximadamente)
346DELETE FROM `tipo_animal`;
347/*!40000 ALTER TABLE `tipo_animal` DISABLE KEYS */;
348INSERT INTO `tipo_animal` (`id`, `nombre`, `creacion`, `ultima_actualizacion`) VALUES
349 (1, 'Perro', '2020-03-07 17:28:32', '2020-03-07 17:28:32');
350/*!40000 ALTER TABLE `tipo_animal` ENABLE KEYS */;
351
352-- Volcando estructura para tabla animal_care.usuario
353CREATE TABLE IF NOT EXISTS `usuario` (
354 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
355 `nombre` varchar(50) NOT NULL,
356 `apellido` varchar(50) NOT NULL,
357 `email` varchar(255) NOT NULL,
358 `password` varchar(255) NOT NULL,
359 `direccion` varchar(255) DEFAULT NULL,
360 `telefono_1` varchar(15) DEFAULT NULL,
361 `telefono_2` varchar(15) DEFAULT NULL,
362 `rol_usuario_id` int(11) unsigned NOT NULL,
363 `provincia_id` int(11) unsigned DEFAULT NULL,
364 `imagen_id` int(11) unsigned DEFAULT NULL,
365 `creacion` timestamp NOT NULL DEFAULT current_timestamp(),
366 `ultima_actualizacion` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
367 PRIMARY KEY (`id`),
368 KEY `FK_usuario_provincia` (`provincia_id`),
369 KEY `FK_usuario_rol_usuario` (`rol_usuario_id`),
370 KEY `FK_usuario_imagen` (`imagen_id`),
371 CONSTRAINT `FK_usuario_imagen` FOREIGN KEY (`imagen_id`) REFERENCES `imagen` (`id`) ON UPDATE CASCADE,
372 CONSTRAINT `FK_usuario_provincia` FOREIGN KEY (`provincia_id`) REFERENCES `provincia` (`id`) ON UPDATE CASCADE,
373 CONSTRAINT `FK_usuario_rol_usuario` FOREIGN KEY (`rol_usuario_id`) REFERENCES `rol_usuario` (`id`) ON UPDATE CASCADE
374) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
375
376-- Volcando datos para la tabla animal_care.usuario: ~3 rows (aproximadamente)
377DELETE FROM `usuario`;
378/*!40000 ALTER TABLE `usuario` DISABLE KEYS */;
379INSERT INTO `usuario` (`id`, `nombre`, `apellido`, `email`, `password`, `direccion`, `telefono_1`, `telefono_2`, `rol_usuario_id`, `provincia_id`, `imagen_id`, `creacion`, `ultima_actualizacion`) VALUES
380 (12, 'Andres', 'Figueira', 'andresfigueiram2@gmail.com', '$2y$10$Ti0nwBod5KeQpjgz2DRn3uQvMLwx69fBqZF5L/gD4XF845evhbse2', NULL, NULL, NULL, 2, NULL, NULL, '2020-03-28 14:32:28', '2020-03-28 14:32:28'),
381 (13, 'Andres', 'Figueira', 'andresfigueiram3@gmail.com', '$2y$10$PArB5qCR/xj0oUIEh7pYJ.FKvWhiIsrtyN49YxPYmYFEUzBKO6.S6', NULL, NULL, NULL, 2, NULL, NULL, '2020-03-28 14:34:34', '2020-03-28 14:34:34'),
382 (14, 'Andres', 'figueira', 'andresfigueiram@gmail.com', '$2y$10$dE8KisWXeU5c3ckdQF8WxOVktOWlRydKu9xSgKz3YZfF4Du..TshW', NULL, NULL, NULL, 2, NULL, NULL, '2020-03-28 14:44:54', '2020-03-28 14:44:54');
383/*!40000 ALTER TABLE `usuario` ENABLE KEYS */;
384
385/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
386/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
387/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;