2iiktt33

1-- phpMyAdmin SQL Dump
2-- version 4.0.4.1
3-- http://www.phpmyadmin.net
4--
5-- Servidor: 127.0.0.1
6-- Tiempo de generación: 12-01-2020 a las 12:24:59
7-- Versión del servidor: 5.6.11
8-- Versión de PHP: 5.5.0
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Base de datos: `proyectofinal`
15--
16CREATE DATABASE IF NOT EXISTS `proyectofinal` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
17USE `proyectofinal`;
18
19-- --------------------------------------------------------
20
21--
22-- Estructura de tabla para la tabla `ambulatorios`
23--
24
25CREATE TABLE IF NOT EXISTS `ambulatorios` (
26  `id` int(11) NOT NULL AUTO_INCREMENT,
27  `nombre` varchar(120) NOT NULL,
28  PRIMARY KEY (`id`)
29) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=114 ;
30
31--
32-- Volcado de datos para la tabla `ambulatorios`
33--
34
35INSERT INTO `ambulatorios` (`id`, `nombre`) VALUES
36(1, 'Centro médico Cabañal'),
37(2, 'Ambulatorio la Paz'),
38(5, 'Ambulatorio Av del puerto'),
39(55, 'Ambulatorio Prueba'),
40(108, 'Ambulatorio Final'),
41(109, 'Ambulatorio PruebaFinal'),
42(110, 'Ambulatorio CSV'),
43(111, 'Ambulatorio Germanias'),
44(112, 'Ambulatorio PruebaFinalFINAL'),
45(113, 'Ambulatorio CSVFINAL');
46
47-- --------------------------------------------------------
48
49--
50-- Estructura de tabla para la tabla `citas`
51--
52
53CREATE TABLE IF NOT EXISTS `citas` (
54  `id` int(11) NOT NULL AUTO_INCREMENT,
55  `paciente` varchar(9) NOT NULL,
56  `estado` varchar(20) NOT NULL,
57  `fecha` datetime NOT NULL,
58  `ambulatorio_id` int(11) NOT NULL,
59  PRIMARY KEY (`id`),
60  KEY `en_ambulatorio` (`ambulatorio_id`)
61) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=46 ;
62
63--
64-- Volcado de datos para la tabla `citas`
65--
66
67INSERT INTO `citas` (`id`, `paciente`, `estado`, `fecha`, `ambulatorio_id`) VALUES
68(1, '44510234L', '0', '2019-12-20 00:00:00', 1),
69(18, '12345678Z', '0', '2020-01-02 20:33:12', 108),
70(19, '12345678Z', '0', '2020-01-02 20:36:17', 108),
71(20, '12345678Z', '0', '2020-01-03 00:14:33', 108),
72(21, '77777777F', '0', '2020-01-03 00:16:20', 109),
73(22, '123456CSV', '0', '2020-01-03 00:39:28', 110),
74(23, '12345678S', '0', '2020-01-03 00:39:28', 2),
75(24, '123456CSV', '0', '2020-01-03 00:42:20', 110),
76(25, '12345678S', '0', '2020-01-03 00:42:20', 2),
77(26, '123456CSV', '0', '2020-01-03 00:44:24', 110),
78(27, '12345CSV2', '0', '2020-01-03 00:44:24', 111),
79(28, '123456CSV', '0', '2020-01-03 00:47:13', 110),
80(29, '12345CSV2', '0', '2020-01-03 00:47:13', 111),
81(30, '123456CSV', '0', '2020-01-03 00:52:05', 110),
82(31, '12345CSV2', '0', '2020-01-03 00:52:05', 111),
83(32, '123456CSV', '0', '2020-01-03 00:55:54', 110),
84(33, '44510234L', '0', '2020-01-03 00:55:54', 111),
85(34, '44510234L', '0', '2020-01-03 01:00:24', 110),
86(35, '123456CSV', '0', '2020-01-03 01:01:11', 110),
87(36, '12345CSV2', '0', '2020-01-03 01:01:11', 111),
88(37, '99999999F', '0', '2020-01-03 01:04:00', 112),
89(38, '99999999F', '0', '2020-01-03 01:05:51', 112),
90(39, '123456CSV', '0', '2020-01-03 01:06:26', 110),
91(40, '12345CSV2', '0', '2020-01-03 01:06:26', 111),
92(41, 'F11111111', '0', '2020-01-03 01:10:42', 113),
93(42, 'C11111111', '0', '2020-01-03 01:10:43', 111),
94(43, '99999999F', '0', '2020-01-03 01:18:43', 112),
95(44, 'F11111111', '0', '2020-01-03 01:18:49', 113),
96(45, 'C11111111', '0', '2020-01-03 01:18:49', 111);
97
98-- --------------------------------------------------------
99
100--
101-- Estructura de tabla para la tabla `compra_farmacia`
102--
103
104CREATE TABLE IF NOT EXISTS `compra_farmacia` (
105  `id` int(11) NOT NULL AUTO_INCREMENT,
106  `precio` double NOT NULL,
107  `paciente` varchar(9) NOT NULL,
108  `farmacia_id` int(11) NOT NULL,
109  `receta_id` int(11) NOT NULL,
110  PRIMARY KEY (`id`),
111  KEY `compra_de_receta` (`receta_id`),
112  KEY `compra_en_farmacia` (`farmacia_id`)
113) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
114
115--
116-- Volcado de datos para la tabla `compra_farmacia`
117--
118
119INSERT INTO `compra_farmacia` (`id`, `precio`, `paciente`, `farmacia_id`, `receta_id`) VALUES
120(1, 43, '44529743H', 2, 1);
121
122-- --------------------------------------------------------
123
124--
125-- Estructura de tabla para la tabla `farmacias`
126--
127
128CREATE TABLE IF NOT EXISTS `farmacias` (
129  `id` int(11) NOT NULL AUTO_INCREMENT,
130  `nombre` varchar(120) NOT NULL,
131  PRIMARY KEY (`id`)
132) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
133
134--
135-- Volcado de datos para la tabla `farmacias`
136--
137
138INSERT INTO `farmacias` (`id`, `nombre`) VALUES
139(1, 'Farmacia de guardia'),
140(2, 'Farmacia rogalí');
141
142-- --------------------------------------------------------
143
144--
145-- Estructura de tabla para la tabla `medicamento_stock`
146--
147
148CREATE TABLE IF NOT EXISTS `medicamento_stock` (
149  `id` int(11) NOT NULL AUTO_INCREMENT,
150  `fecha` date NOT NULL,
151  `tipo` varchar(120) NOT NULL,
152  `nombre` varchar(120) NOT NULL,
153  `cantidad` text NOT NULL,
154  `stock` int(11) NOT NULL,
155  `farmacia_id` int(11) NOT NULL,
156  PRIMARY KEY (`id`),
157  KEY `fk_farmacia_id` (`farmacia_id`)
158) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
159
160-- --------------------------------------------------------
161
162--
163-- Estructura de tabla para la tabla `recetas`
164--
165
166CREATE TABLE IF NOT EXISTS `recetas` (
167  `cita_id` int(11) DEFAULT NULL,
168  `paciente` varchar(9) NOT NULL,
169  `doctor` varchar(9) DEFAULT NULL,
170  `medicamentos` longtext NOT NULL,
171  KEY `fk_cita_id` (`cita_id`)
172) ENGINE=InnoDB DEFAULT CHARSET=latin1;
173
174--
175-- Volcado de datos para la tabla `recetas`
176--
177
178INSERT INTO `recetas` (`cita_id`, `paciente`, `doctor`, `medicamentos`) VALUES
179(1, '44529743H', '', 'Mucha agua'),
180(19, '12345678Z', '', 'ibuprofeno'),
181(19, '12345678Z', NULL, '¬í\0sr\0java.util.ArrayListxÒ™Ça\0
I\0sizexp\0\0\0w\0\0\0sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\rantidepresivot\0dosist\01 dosis al diax\0sq\0~\0?@\0\0\0\0\0w\0\0\0\0\0\0q\0~\0t\0\nibuprofenoq\0~\0t\03 dosis al diax\0x'),
182(19, '12345678Z', NULL, '¬í\0sr\0java.util.ArrayListxÒ™Ça\0
I\0sizexp\0\0\0w\0\0\0sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\rantidepresivot\0dosist\01 dosis al diax\0sq\0~\0?@\0\0\0\0\0w\0\0\0\0\0\0q\0~\0t\0\nibuprofenoq\0~\0t\03 dosis al diax\0x'),
183(19, '12345678Z', NULL, '1'),
184(19, '12345678Z', NULL, '¬í\0ur\0[Ljava.lang.Object;ÎXŸs)l\0\0xp\0\0\0sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\rantidepresivot\0dosist\01 dosis al diax\0sq\0~\0?@\0\0\0\0\0w\0\0\0\0\0\0q\0~\0t\0\nibuprofenoq\0~\0t\03 dosis al diax\0'),
185(19, '12345678Z', NULL, '¬í\0ur\0[Ljava.lang.Object;ÎXŸs)l\0\0xp\0\0\0sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\rantidepresivot\0dosist\01 dosis al diax\0sq\0~\0?@\0\0\0\0\0w\0\0\0\0\0\0q\0~\0t\0\nibuprofenoq\0~\0t\03 dosis al diax\0'),
186(19, '12345678Z', NULL, '0'),
187(19, '12345678Z', NULL, '¬í\0sr\0java.util.ArrayListxÒ™Ça\0
I\0sizexp\0\0\0w\0\0\0sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\rantidepresivot\0dosist\01 dosis al diax\0sq\0~\0?@\0\0\0\0\0w\0\0\0\0\0\0q\0~\0t\0\nibuprofenoq\0~\0t\03 dosis al diax\0x'),
188(19, '12345678Z', NULL, '¬í\0sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\rantidepresivot\0dosist\01 dosis al diax\0'),
189(19, '12345678Z', NULL, '¬í\0sr\0java.util.ArrayListxÒ™Ça\0
I\0sizexp\0\0\0w\0\0\0sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\rantidepresivot\0dosist\01 dosis al diax\0sq\0~\0?@\0\0\0\0\0w\0\0\0\0\0\0q\0~\0t\0\nibuprofenoq\0~\0t\03 dosis al diax\0x'),
190(21, '77777777F', NULL, '¬í\0sr\0java.util.ArrayListxÒ™Ça\0
I\0sizexp\0\0\0w\0\0\0sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\rantidepresivot\0dosist\01 dosis al diax\0sq\0~\0?@\0\0\0\0\0w\0\0\0\0\0\0q\0~\0t\0\nibuprofenoq\0~\0t\03 dosis al diax\0x'),
191(22, '123456CSV', NULL, '¬í\0sr\0java.util.ArrayListxÒ™Ça\0
I\0sizexp\0\0\0
w\0\0\0
sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\rantidepresivot\0dosist\01 dosis diariax\0x'),
192(23, '12345678S', NULL, '¬í\0sr\0java.util.ArrayListxÒ™Ça\0
I\0sizexp\0\0\0
w\0\0\0
sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\nibuprofenot\0dosist\02 dosis diariasx\0x'),
193(24, '123456CSV', NULL, '¬í\0sr\0java.util.ArrayListxÒ™Ça\0
I\0sizexp\0\0\0
w\0\0\0
sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\rantidepresivot\0dosist\01 dosis diariax\0x'),
194(26, '123456CSV', NULL, '¬í\0sr\0java.util.ArrayListxÒ™Ça\0
I\0sizexp\0\0\0
w\0\0\0
sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\rantidepresivot\0dosist\01 dosis diariax\0x'),
195(26, '123456CSV', NULL, '¬í\0sr\0java.util.ArrayListxÒ™Ça\0
I\0sizexp\0\0\0
w\0\0\0
sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\rantidepresivot\0dosist\01 dosis diariax\0x'),
196(28, '123456CSV', NULL, '¬í\0sr\0java.util.ArrayListxÒ™Ça\0
I\0sizexp\0\0\0
w\0\0\0
sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\rantidepresivot\0dosist\01 dosis diariax\0x'),
197(29, '12345CSV2', NULL, '¬í\0sr\0java.util.ArrayListxÒ™Ça\0
I\0sizexp\0\0\0
w\0\0\0
sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\nibuprofenot\0dosist\02 dosis diariasx\0x'),
198(28, '123456CSV', NULL, '¬í\0sr\0java.util.ArrayListxÒ™Ça\0
I\0sizexp\0\0\0
w\0\0\0
sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\rantidepresivot\0dosist\01 dosis diariax\0x'),
199(29, '12345CSV2', NULL, '¬í\0sr\0java.util.ArrayListxÒ™Ça\0
I\0sizexp\0\0\0
w\0\0\0
sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\nibuprofenot\0dosist\02 dosis diariasx\0x'),
200(28, '123456CSV', NULL, '¬í\0sr\0java.util.ArrayListxÒ™Ça\0
I\0sizexp\0\0\0
w\0\0\0
sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\rantidepresivot\0dosist\01 dosis diariax\0x'),
201(29, '12345CSV2', NULL, '¬í\0sr\0java.util.ArrayListxÒ™Ça\0
I\0sizexp\0\0\0
w\0\0\0
sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\nibuprofenot\0dosist\02 dosis diariasx\0x'),
202(28, '123456CSV', NULL, '¬í\0sr\0java.util.ArrayListxÒ™Ça\0
I\0sizexp\0\0\0
w\0\0\0
sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\rantidepresivot\0dosist\01 dosis diariax\0x'),
203(30, '123456CSV', NULL, '¬í\0sr\0java.util.ArrayListxÒ™Ça\0
I\0sizexp\0\0\0
w\0\0\0
sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\rantidepresivot\0dosist\01 dosis diariax\0x'),
204(34, '123456CSV', NULL, '¬í\0sr\0java.util.ArrayListxÒ™Ça\0
I\0sizexp\0\0\0
w\0\0\0
sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\rantidepresivot\0dosist\01 dosis diariax\0x'),
205(34, '123456CSV', NULL, '¬í\0sr\0java.util.ArrayListxÒ™Ça\0
I\0sizexp\0\0\0
w\0\0\0
sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\rantidepresivot\0dosist\01 dosis diariax\0x'),
206(36, '12345CSV2', NULL, '¬í\0sr\0java.util.ArrayListxÒ™Ça\0
I\0sizexp\0\0\0
w\0\0\0
sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\nibuprofenot\0dosist\02 dosis diariasx\0x'),
207(37, '99999999F', NULL, '¬í\0sr\0java.util.ArrayListxÒ™Ça\0
I\0sizexp\0\0\0w\0\0\0sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\rantidepresivot\0dosist\01 dosis al diax\0sq\0~\0?@\0\0\0\0\0w\0\0\0\0\0\0q\0~\0t\0\nibuprofenoq\0~\0t\03 dosis al diax\0x'),
208(39, '123456CSV', NULL, '¬í\0sr\0java.util.ArrayListxÒ™Ça\0
I\0sizexp\0\0\0
w\0\0\0
sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\rantidepresivot\0dosist\01 dosis diariax\0x'),
209(40, '12345CSV2', NULL, '¬í\0sr\0java.util.ArrayListxÒ™Ça\0
I\0sizexp\0\0\0
w\0\0\0
sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\nibuprofenot\0dosist\02 dosis diariasx\0x'),
210(NULL, 'F11111111', NULL, '¬í\0sr\0java.util.ArrayListxÒ™Ça\0
I\0sizexp\0\0\0
w\0\0\0
sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\rantidepresivot\0dosist\01 dosis diariax\0x'),
211(NULL, 'C11111111', NULL, '¬í\0sr\0java.util.ArrayListxÒ™Ça\0
I\0sizexp\0\0\0
w\0\0\0
sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\nibuprofenot\0dosist\02 dosis diariasx\0x'),
212(43, '99999999F', NULL, '¬í\0sr\0java.util.ArrayListxÒ™Ça\0
I\0sizexp\0\0\0w\0\0\0sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\rantidepresivot\0dosist\01 dosis al diax\0sq\0~\0?@\0\0\0\0\0w\0\0\0\0\0\0q\0~\0t\0\nibuprofenoq\0~\0t\03 dosis al diax\0x'),
213(NULL, 'F11111111', NULL, '¬í\0sr\0java.util.ArrayListxÒ™Ça\0
I\0sizexp\0\0\0
w\0\0\0
sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\rantidepresivot\0dosist\01 dosis diariax\0x'),
214(45, 'C11111111', NULL, '¬í\0sr\0java.util.ArrayListxÒ™Ça\0
I\0sizexp\0\0\0
w\0\0\0
sr\0java.util.LinkedHashMap4ÀN\\lÀû\0
Z\0accessOrderxr\0java.util.HashMapÚÁÃ`Ñ\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0\nmedicaciont\0\nibuprofenot\0dosist\02 dosis diariasx\0x');
215
216--
217-- Restricciones para tablas volcadas
218--
219
220--
221-- Filtros para la tabla `citas`
222--
223ALTER TABLE `citas`
224  ADD CONSTRAINT `en_ambulatorio` FOREIGN KEY (`ambulatorio_id`) REFERENCES `ambulatorios` (`id`);
225
226--
227-- Filtros para la tabla `compra_farmacia`
228--
229ALTER TABLE `compra_farmacia`
230  ADD CONSTRAINT `compra_de_receta` FOREIGN KEY (`receta_id`) REFERENCES `recetas` (`cita_id`),
231  ADD CONSTRAINT `compra_en_farmacia` FOREIGN KEY (`farmacia_id`) REFERENCES `farmacias` (`id`);
232
233--
234-- Filtros para la tabla `medicamento_stock`
235--
236ALTER TABLE `medicamento_stock`
237  ADD CONSTRAINT `fk_farmacia_id` FOREIGN KEY (`farmacia_id`) REFERENCES `farmacias` (`id`);
238
239--
240-- Filtros para la tabla `recetas`
241--
242ALTER TABLE `recetas`
243  ADD CONSTRAINT `fk_cita_id` FOREIGN KEY (`cita_id`) REFERENCES `citas` (`id`);