API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 28th, 2020
121
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 24.41 KB | None | 0 0
raw download clone embed print report
  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
  16. CREATE DATABASE IF NOT EXISTS `animal_care` /*!40100 DEFAULT CHARACTER SET utf8 */;
  17. USE `animal_care`;
  18.  
  19. -- Volcando estructura para tabla animal_care.animal
  20. CREATE 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)
  49. DELETE FROM `animal`;
  50. /*!40000 ALTER TABLE `animal` DISABLE KEYS */;
  51. INSERT 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
  59. CREATE 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)
  68. DELETE FROM `estado`;
  69. /*!40000 ALTER TABLE `estado` DISABLE KEYS */;
  70. INSERT 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
  76. CREATE 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)
  85. DELETE FROM `imagen`;
  86. /*!40000 ALTER TABLE `imagen` DISABLE KEYS */;
  87. INSERT 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
  96. CREATE 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)
  105. DELETE FROM `provincia`;
  106. /*!40000 ALTER TABLE `provincia` DISABLE KEYS */;
  107. INSERT 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
  161. CREATE 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)
  186. DELETE FROM `publicacion`;
  187. /*!40000 ALTER TABLE `publicacion` DISABLE KEYS */;
  188. INSERT 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
  196. CREATE 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)
  208. DELETE FROM `raza_animal`;
  209. /*!40000 ALTER TABLE `raza_animal` DISABLE KEYS */;
  210. INSERT 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
  302. CREATE 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)
  311. DELETE FROM `rol_usuario`;
  312. /*!40000 ALTER TABLE `rol_usuario` DISABLE KEYS */;
  313. INSERT 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
  320. CREATE 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)
  329. DELETE FROM `sexo_animal`;
  330. /*!40000 ALTER TABLE `sexo_animal` DISABLE KEYS */;
  331. INSERT 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
  337. CREATE 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)
  346. DELETE FROM `tipo_animal`;
  347. /*!40000 ALTER TABLE `tipo_animal` DISABLE KEYS */;
  348. INSERT 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
  353. CREATE 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)
  377. DELETE FROM `usuario`;
  378. /*!40000 ALTER TABLE `usuario` DISABLE KEYS */;
  379. INSERT 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 */;
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!