-- https://www.phpmyadmin.net/
--
-- Servidor: 127.0.0.1
-- Tiempo de generación: 22-02-2025 a las 07:45:15
-- Versión del servidor: 10.4.32-MariaDB
-- Versión de PHP: 8.2.12

START TRANSACTION;



--
-- Base de datos: `danibd2.0`
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `citas`
--

CREATE TABLE `citas` (
  `id` int(11) NOT NULL,
  `id_paciente` int(11) DEFAULT NULL,
  `fecha` date DEFAULT NULL,
  `hora_i` time DEFAULT NULL,
  `hora_f` time DEFAULT NULL,
  `razon` varchar(100) DEFAULT NULL,
  `id_medico` int(11) NOT NULL,
  `asistencia` int(1) NOT NULL,
  `tel` text NOT NULL,
  `nombre` text NOT NULL,
  `eliminado` int(1) NOT NULL,
  `alerta_cancelacion` int(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `citas`
--

INSERT INTO `citas` (`id`, `id_paciente`, `fecha`, `hora_i`, `hora_f`, `razon`, `id_medico`, `asistencia`, `tel`, `nombre`, `eliminado`, `alerta_cancelacion`) VALUES
(25, 0, '2025-01-14', '13:00:00', '13:30:00', 'extraccion', 1, 0, '6621465001', 'christian daniel salgado quintero', 0, 0),
(26, 0, '2025-01-16', '16:00:00', '17:00:00', 'Preparación y toma de molde c/silicona ', 1, 0, '632857282836', 'Margarita de Jesús ', 0, 0),
(27, 0, '2025-01-17', '12:00:00', '12:15:00', 'Rv de prótesis ', 1, 0, '54546434511', 'Jesús cardenas ', 0, 0),
(28, 0, '2025-01-17', '14:00:00', '15:00:00', 'Consulta 1era vez ', 1, 0, '54546434511', 'Socorro Berrelleza  ', 0, 0),
(29, 0, '2025-01-18', '11:00:00', '11:30:00', 'T.de m. Con cucharilla individual ', 1, 0, '6484848494', 'Angel calderon ', 0, 0),
(30, 0, '2025-01-18', '13:00:00', '13:30:00', 'T.de m. Y rx para brackets ', 1, 0, '6626025114', 'Fernanda Ayala ', 0, 0),
(31, 0, '2025-01-18', '14:00:00', '14:30:00', 'Limpieza ', 1, 0, '6622814511', 'Fidel Molina moreno ', 0, 0),
(32, 0, '2025-01-17', '13:00:00', '13:30:00', 'Limpieza ', 1, 0, '6629378857', 'José Wilfrido Argüelles cardenas ', 0, 0),
(33, 0, '2025-01-20', '16:00:00', '16:30:00', 'Limpieza ', 1, 0, '2321345404', 'Arturo Ortiz Nasta ', 0, 0),
(34, 0, '2025-01-22', '13:00:00', '14:00:00', 'Preparar y provisional ', 1, 0, '6621888416', 'Laura Elena Adriano encinas ', 0, 0),
(35, 0, '2025-01-17', '17:00:00', '18:00:00', 'Cavidad ', 1, 0, '6629485685', 'Esmeralda montiel', 0, 0),
(36, 0, '2025-01-23', '16:00:00', '17:00:00', 'Preparar y provisional ', 1, 0, '6624003742', 'Margarita Guzmán de Jesús ', 0, 0),
(37, 0, '2025-01-29', '12:00:00', '12:30:00', 'Valoración blanqueamiento ', 1, 1, '6624186291', 'Patricia Judith Pérez Pérez ', 0, 0),
(38, 0, '2025-01-28', '13:00:00', '14:00:00', 'Revisión de carillas ', 1, 0, '22983385', 'Lydia Pérez Villarreal ', 0, 0),
(39, 0, '2025-01-30', '16:00:00', '16:30:00', 'Revisión de férula ', 1, 0, '6623297548', 'Omar edubiel Casimiro gay ', 0, 0),
(40, 0, '2025-01-31', '13:00:00', '14:00:00', 'Relleno 1', 1, 0, '6629371180', 'Elena gpe Ortega ', 0, 0),
(41, 0, '2025-02-01', '14:00:00', '14:30:00', 'Revisión y radiografía ', 1, 0, '6621905506', 'Elizabeth Zazueta ', 1, 0),
(42, 0, '2025-02-01', '09:00:00', '10:00:00', 'Relleno/carilla ', 1, 1, '6484545494', 'Lucia gpe poqui ', 0, 0),
(43, 0, '2025-01-17', '18:00:00', '19:15:00', 'Extracción', 1, 0, '2831310672', 'Perla García ', 0, 0),
(44, 0, '2025-01-18', '16:00:00', '17:00:00', 'Limpieza + extracción ', 1, 0, '56454548787', 'Laura elen amado', 0, 0),
(45, 0, '2025-01-22', '12:00:00', '12:15:00', 'Toma de molde p/ Guarda ', 1, 0, '6621686184', 'Julissa garibali', 0, 0),
(46, 0, '2025-01-29', '17:00:00', '18:15:00', 'Exo', 1, 0, '6624156442', 'Rafaela algandar ', 0, 0),
(47, 0, '2025-01-29', '18:00:00', '19:15:00', 'Cavidad ', 1, 0, '6622875890', 'Susana Cota', 0, 0),
(48, 0, '2025-01-30', '13:00:00', '13:30:00', 'Entrega kit de blanqueamiento ', 1, 0, '6624186291', 'Patricia Judith Pérez Pérez ', 0, 0),
(49, 0, '2025-01-31', '15:00:00', '18:00:00', 'Resinas inyectadas y cambio de provisionales ', 1, 0, '6623814311', 'Angel calderon ', 0, 0),
(50, 0, '2025-02-01', '11:00:00', '13:30:00', 'Resinas inyectadas ', 1, 0, '6623814311', 'Angel calderon ', 1, 1),
(51, 0, '2025-02-01', '16:00:00', '17:15:00', 'Relleno 1', 1, 0, '6623690338', 'Laura Elena amado ', 1, 0),
(52, 0, '2025-02-03', '12:00:00', '13:00:00', 'Cavidad de acceso ', 1, 0, '6624201210', 'Edgar Ulises Pérez M', 0, 0),
(53, 0, '2025-02-03', '16:00:00', '17:00:00', 'Preparación y t. M. C/ silicon ', 1, 0, '6624003742', 'Margarita Guzmán de Jesús ', 0, 0),
(54, 0, '2025-02-04', '13:00:00', '13:30:00', 'Consulta  ', 1, 1, '6624244670', 'Johana González Lara ', 0, 0),
(55, 0, '2025-02-04', '14:00:00', '15:00:00', 'Entrega guarda + pulido de resinas  d/otra clínica ', 1, 0, '22983385', 'Lydia Pérez Villarreal ', 0, 0),
(56, 0, '2025-02-11', '15:00:00', '16:00:00', 'Relleno ', 1, 0, '6624024716', 'Flor Briseida rosas ramos ', 0, 0),
(57, 0, '2025-02-12', '13:00:00', '13:30:00', 'Rv de prótesis ', 1, 0, '6622065246', 'Martín Alejandro hdz villa ', 0, 0),
(58, 0, '2025-02-15', '13:00:00', '13:30:00', 'Rv de resinas inyectadas ', 1, 0, '6621868448', 'Consuelo Haydee Torres Parra ', 0, 0),
(59, 0, '2025-02-15', '14:00:00', '14:30:00', 'Rv y rx de endo 48', 1, 0, '6621905506', 'Elizabeth Zazueta ', 0, 0),
(60, 0, '2025-02-13', '13:00:00', '13:30:00', 'Rx de blanqueamiento ', 1, 0, '6624186291', 'Patricia Judith Pérez o. ', 0, 0),
(61, 0, '2025-02-13', '14:00:00', '14:30:00', 'Toma de molde con silicona ', 1, 0, '6624003742', 'Margarita Guzmán de Jesús ', 0, 0),
(62, 0, '2025-02-19', '10:00:00', '11:00:00', 'Valoracion ', 1, 0, '6621828029', 'Alexis Guzmán ', 0, 0);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `inventario`
--

CREATE TABLE `inventario` (
  `id` int(11) NOT NULL,
  `id_producto` int(11) DEFAULT NULL,
  `caducidad` date DEFAULT NULL,
  `lote` text DEFAULT NULL,
  `entrada` date DEFAULT NULL,
  `salida` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `medicos`
--

CREATE TABLE `medicos` (
  `id` int(11) NOT NULL,
  `nombre` varchar(100) DEFAULT NULL,
  `apellido` varchar(100) DEFAULT NULL,
  `email` text DEFAULT NULL,
  `tel` text DEFAULT NULL,
  `clave` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `medicos`
--

INSERT INTO `medicos` (`id`, `nombre`, `apellido`, `email`, `tel`, `clave`) VALUES
(1, 'daniela guadalupe', 'salgado quintero', 'danielasalgado696@gmail.com', '6621248293', '$2y$10$DH.ZxoKf2p42X6I8QYkTIexq1Y/s8r0FxIrAW6rBjTEZCoet9BbaG');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `pacientes`
--

CREATE TABLE `pacientes` (
  `id` int(11) NOT NULL,
  `nombres` varchar(100) NOT NULL,
  `apellidos` varchar(100) NOT NULL,
  `direccion` varchar(200) NOT NULL,
  `sexo` varchar(10) NOT NULL,
  `email` varchar(200) NOT NULL,
  `tell` varchar(12) NOT NULL,
  `clave` varchar(300) NOT NULL,
  `hospd` text DEFAULT NULL,
  `trat` text DEFAULT NULL,
  `medto` text DEFAULT NULL,
  `alerg` text DEFAULT NULL,
  `anesia` text DEFAULT NULL,
  `hptitis` text DEFAULT NULL,
  `diabts` text DEFAULT NULL,
  `hipeart` text DEFAULT NULL,
  `cdtias` text DEFAULT NULL,
  `fuma` text DEFAULT NULL,
  `plumas` text DEFAULT NULL,
  `rechina` text DEFAULT NULL,
  `embar` text DEFAULT NULL,
  `anticons` text DEFAULT NULL,
  `notas` text DEFAULT NULL,
  `f` text DEFAULT NULL,
  `nacimiento` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `pacientes`
--

INSERT INTO `pacientes` (`id`, `nombres`, `apellidos`, `direccion`, `sexo`, `email`, `tell`, `clave`, `hospd`, `trat`, `medto`, `alerg`, `anesia`, `hptitis`, `diabts`, `hipeart`, `cdtias`, `fuma`, `plumas`, `rechina`, `embar`, `anticons`, `notas`, `f`, `nacimiento`) VALUES
(6, 'alicia ', 'chipres granillo ', 'miguel hidalgo/ 13 de septiembre', 'femenino', 'danielasalgadobiodent@gmail.com', '6623989071', '*', 'No', 'No', 'No', ' No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'Si', 'Diu', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAPoAAADICAYAAADBXvybAAAAAXNSR0IArs4c6QAAAERlWElmTU0AKgAAAAgAAYdpAAQAAAABAAAAGgAAAAAAA6ABAAMAAAABAAEAAKACAAQAAAABAAAA+qADAAQAAAABAAAAyAAAAAB2lQbVAAAKP0lEQVR4Ae3dWagkVxkH8IvEjcEgmmiMC6ghal4ct2DcMGJcMlEfJmrwzXEDk0BAUUSRiyDGIW8mghh3iHGJYDSoMaCMo0KiMuAuQVE00UzUKGqCiPH/YTc6zNJ9u6u6q/r8DnzUne5Tp875nfqmlq7bd2tLIUCAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIEBgBQKnz7mN+85ZTzUCBAYo8MP06ewZ/bos7++fUcfbGyBwnw0YgyEcLfCuvPSjxM1Hv3XEK3flX6ce8Yp/ECAwCoEz0st7E7WcVfakwg2zKnmfAIHhCXw6Xaoj+jylTu1nHfXnaUcdAmsXOHntPVhdB16WTdW1+bzlsan4q3krq0dgqAKvSsc+mXjIUDvYYb9qjL9OnLeDNnel7t92UF9VAoMUODO9+kPi+kH2rttOXZPm3r9Ak5XolfAKgVEL1FHunsRpox7FiTt/cd4+eOIqx323Tt3rFF4hMGqBOnX/TuLSUY/i+J3fnbfqLnstFyl1M27W5+2LtGudAQm08Dn6gXjfnajr9U0sV2ZQlyQOLTi4w1nPZ+kL4o1ltVYS/fGZkMclnjSWiZmzn3VN/pvEVXPWP1a1O/KiRD+WzAa91kKi/2IyX1/P8pUbNHcvzVguStTRfJlSR/QHL9OAdYcv0EKi1ywcSNye2JTT9/qFlasTb0z8KbFMqRuVEn0ZwRGs21KiP3IyH88awbzM6uKHUuHDia/NqjjH+/+eo44qIxdoKdGfl7n6bGLsR/XtyT43XU7+aUHg+AKtJPr0Ov2WUIz5Ov3F6f8bEm86/pR6h8DRAq0keo38QOJBiV8m9iTGVuq6/KOJfYnbxtZ5/V2vQEuJ/ttQn5UY6+l7l9fl693rbH3lAi0l+j8nup/Lsk7f77dy7cU3uD1ZdbpcvCVrNinQUqJPJ/j3+eGmxOumLwx8eX7657p84JM09O6dNPQO9tS/d6fdeoBmV+KKnrbRRbP1/Hp9kcTehOvyLkQbbaPFI3pNdT0Xfk7iFYl68GSI5ZR06prE2xJ1BqIQWFig1UQvsFsTz53IfSvLeb5jbVJ9JYtK8s8n6iZcn6XlfaBP10G1bZK3tl6fGfli4ruJlwxkdupjtPqUoC4x+i4PyAbu6nsj2l+vgET/r39dp78m8ZHEdmKd5T3Z+KMS+1bUifrNNYm+Iux1bUai/0++bs49I/HUxJcS9YDKqks98XZhov7TWVV5WDZ0eFUbs531CEj0I93rzvbLE99P3JKob1VdVXl+NrQ/UUl+Z2JVpY7oEn1V2rbTu8B2tlAxb6kk/11ie94Vlqz3k6xfnwKsuvjOuFWLr2F7jujHR6/T9zqVf1qivkW2z1P596b9mxN1U3DVpY7od6x6o7a3WgGJfmLvOpWvI/sPEnUqf0Gi6/L0NHhp4h1dNzxHe7smdf4+R11VCIxCYDu9rFi0vDAr/ixRd+brYZauSt0EfHNXje2wHX+pZYdgY63uiD7/zNXTaU9M1I2ySvh9iWXLNME/uGxDC67vRtyCcGNbTaLvfMbenlXqplklel1TV/IvUh6RlS5PrOOUfdpfiT6V2PClRF9sgr+d1Z6TqOVPE/U8+k7L+7LCBxLf2+mKHdZ3I65DzCE3JdGXm539Wb2+K/7ZiYOTZRYzS93UOzvxzpk1+61Qf5jRZ+j9Gg+idYm+/DTU9Xqdytfz6XUqX39U4USlkuuqxGUnqrSi9x6e7Uj0FWGvczMSvTv9SvS6Xq878pX85yaOVa7Mi9cmbjzWmyt+rf7T+fOKt2lzaxCQ6N2i1x35+uaaumb/QuKSxP+Xi/OPxyTqht4QSiX6sn8AYgjj0IcZAifNeN/biwlcn9XqZt2nEvVZ9VsSuxN1NH9KYihFog9lJnruh0TvD/jHaXqa7Nfl5/o4rY7whxJDKQ9NRxzRhzIbPfbDqXuPuGn6H4m9iUcn6vr9m4khFUf0Ic1Gj32R6D3iTpo+P8u6u10Px9RHcHUqP5RSif7HoXRGP/oTcOren221fEbiE4n6HfN6pv2GRP1a6BDKAyeduHsIndGHfgUc0fv1/Viar8/VK8mr1HX7UIrr86HMxAr6IdH7Q746Tf88cUV/m1iqZdfnS/GNa2Wn7v3M11vT7BMS06+T7mcry7Xq+nw5v1GtLdG7n649abIeiDmn+6Y7bdERvVPOYTcm0budn0ryLydekLi126Y7b02id0463AZdo3c3N2emqUryCxLf6K7Z3lo6OS17WKY33mE1LNG7m4/6CK0eca2P0MZQKtHvGUNH9XF5AafuyxtOW9ie/jCi5b0j6quuLiHgiL4EnlUJjEVAoo9lpvSTwBICEn0JPKsSGIuARB/LTOkngSUEWkv01sa7xK5h1U0SaGnH/0sm7v6bNHnGQmBegZYS/a9BOWVeGPUIbJJAS4l+ZyZOom/S3msscwu0luj1O9gKgeYEWkr0+sokR/TmdnEDLoGWEr1O3R3R7fdNCrSW6I7oTe7mBt1SotdsuyFnn29SoLVEd53e5G5u0K0luut0+3yTAq0luiN6k7u5QbeW6K7R7fNNCrSY6Kc1OdMG3bRAa4l+MLP9zKZn3OCbFGgt0b+SWT43cXqTs23QzQq0luj/ykx/JvHqZmfcwJsUaC3Ra5Ir0S9qcrYNulmBFhP9xsz2qYndzc66gTcn0GKi1yQ7fW9uV297wBK97fk3+kYEWk30Q5nfw4kXNTLPhtm4QKuJXtN+bcLd98YToJXht5zo0+t0f3+ulb294XG2nOi3Zd7rzxvvbXj+Db0RgZYTvab444nX1g8KgU0WaD3Rr8vkPjlx1iZPsrERILC1dXkQKhQCBDZYoI7mt2/w+AyNAIGJwFezPI8GAQKbLeBroDd7fo2OAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBAgQIECAAAECBDZe4D81C+NCLrNzEQAAAABJRU5ErkJggg==', '1978-04-22'),
(7, 'martina rosalina', 'ramirez, pacheco', 'no domicilio', 'femenino', 'danielasalgadobiodent@gmail.com', '6624433569', '*', 'No', 'No', 'No', ' No', 'No', 'No ', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'data:image/png;base64,[encoded data, 4812 characters]', '1992-01-20'),
(8, 'maría de lourdes', 'garcía colotl', 'el triunfito', 'femenino', 'danielasalgadobiodent@gmail.com', '6624658103', '*', 'No', 'No', 'No', ' No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAPoAAADICAYAAADBXvybAAAAAXNSR0IArs4c6QAAAERlWElmTU0AKgAAAAgAAYdpAAQAAAABAAAAGgAAAAAAA6ABAAMAAAABAAEAAKACAAQAAAABAAAA+qADAAQAAAABAAAAyAAAAAB2lQbVAAAJoUlEQVR4Ae3dX6gtVR0H8FtZVBRBhZBF3ge7vvTH5FJElEiUkVlKvSgRBIEpGXR7igoOhPSPRIqI6kUCoYewSCmkP5SFL6WYQmH5cCHt30P1EBj9s9/X9sDh3PNn9t4ze86a/VnwO7P3zJq11nzmrD1/9tp7nzghESBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIrCLwglVWsg4BAsdH4IIjmvLWWn7XEXksJkDgmAs8VO17zSFtfGot+1vFhYfksYjA6AJPG72G+Vbw8cWmfeGQTXyilqWTv7TiZ4fks4gAgWMocFG1KZ0406PSGyrDg0dlspwAgeMn8I1qUndE79O6dPR0eIkAgUYErq525tp8mfTRyvzlZVaQlwCBaQXSydPZl0m5Ts9NudyckwgQWELgGUvkHSprTtdz2r5KyttsebtNIkCgp8AHK98tPfMOlW2ZG3D71fmZmrmz3wLzCIwt0Oqp5J8L5mVj4+wp/5P1/BMVj+yZ3/fp430zykdgaIHzhi5wQ+U9p+p504bqSjWXV7y84to8kQi0JtDqEf0HBZ33sW/eEPj7qp4vbagu1RAYXKDVjv5oSTy74qaK04OrnFvgG2vWj86dbQ6BNgRa7ej/Ld509s9WfGpk6lOL8n8zcj2KJzCaQKsdPSDp6N1R9sbRhE6cuKzKvmfE8hVNYHSBljv670rnJRUZdfbpihdVjJFyfX77GAUrk8CmBFru6Dmin1/xi4ovVoxxCv/uKjfp7v9P/CXQpsB5bTb7yVb/vf6+cNH+j9X0VxVfrfj9Yl4md1Ss88mxM7X+pgfmpN0SgUEFWj6i54bc7vTmerK7kz+vnn+vYqdilfSuxUrfXGVl6xA4TgItH9H3Oj5WM3b2zPxcPf9KxZ0V11fsfiGopwemZ9aSDFn9wIE5LCDQkEDLR/Q+zOnYV1XcV/Hzir6fOvt85c11eQbmDJnm9MI6pIuyRhZovaP37Tg75fjeiky/XXFpxUEpLwZXVHzkoAwrzv9DrZfLCYnAxgVa7uh/Kq2Mee+bflgZL6n4SUUe31rx/Ird6cp68q2KvKX2j90LBnj8aJVx0QDlKILAVglcU1ubo/MqKR08Hf2vFR9eFJBOnvHzmY6RLq5CfztGwcokMGeBV9fGPbDmBuYUPi8W6YBjdvI0M9+4mzoylQgQ6CmQo3KOyEOkX1chObW+rWKsEXZV9JMvKDmySwQ2KtDyNfpfFlJ7r7OXBczot7xgZDht3qJ7uGKssfOPVNmu0wtBIrCMQE7dcwq/Trq3Vu6Guqac0xXfX0QeD5kyVPdDQxaoLAJ9BFo+omf7zlacrFg1XbdYcffot4ydzyi73H3Pp+Nurhgq5YXpFUMVphwC2yJwa23omRU3trvL/rpD1s/1+m0VGUf/4op102urgAzekQgQWELg2sp7+xL5u6xvqQfL3GUf6hT+6Yt6M5UIEOgpcLLy/bFn3i7bqXqQTp7OPkXKET1HdokAgSUEHqy8h/108X5FpbNPlb5WFd8wVeXq3U6B1m/GZa9lOOuyX/085fe/3V/tvTQNlwhsSmBbO/qmfPerR0ffT8U8AkcIPKuW55o70xaSG3It7KWZtXEOR/THa5+scvo+1a78V1XsqD6V/pbWO4eOnl3XUkdPe3X0KEgElhTIXffcfW8lZcjtHa00VjsJHCeBvJ9+8jg16JC2PLeW5b5CphKB0QXm9NnofLjl3xW/HF1t/Qr+WUW8alFMS2ci62+5EiYRmMs1evDurrhiEsXVKs0XXlyz2qrWIrC9Aidr05cdDjulltP3KfXV3bTAKsNhp9zg3JDLt9NKBEYVmNOpe6Bae5stn3m/etQ9rHACMxR4e23T0D+6MCaT0/cxdZU9W4HWhsNmR+T0/T2z3SM2jMBIAjmi58jeSnpbNfTeVhqrnW0KzO0aPXuhtev07y7+dTJaTiJAoKdAa8Nhs1np5I7qPXewbAQ6gZaGw3ZtTkd3VO80TAn0EMgXRrZ2g8tRvceOlWU1gTleo0finorLViOZbK3uu+Ud1SfbBSpuTaDV7093VG/tP017JxVo+euacq3+zkn1VE6gIYH7qq0tfn/6O6rd7sA39I/WQlPneo0e+/srWvxa5e8s/nFcqy8gTNYX0NHXNxyjhFuq0DNjFKxMAnMTaPWGXLcfvK/eSZgSOESg5Rty2Sx34A/ZuRYR2C3Q6g25bhsc1TsJ07UE5nyNHpjckLtkLaFpV3atPq3/bGqfe0f/ae2p1ze8t4yWa3jnafrmBE5VVWc3V90oNV1epT5WccEopSuUwEwEztZ2pMO3nHaq8Xe2vAHaPq3AnH7A4SDJbtBMrtdbTT+uhl9XcXFFHksECOwReH89//qeeS0+zal7TuFf2WLjtZnA2AJzuE7vjC7sHpgSIHCuwNma1fp1+rlbZQ6BngLbcI0eilyn/6figTyRCGybwNzfR+/251314KruiSkBAvMU8Iso89yvtqqnwLacune/R/6Ucmnh99N77j7ZCPQT2JZT92jk98j9oGG//wu5CDQr4PS92V2n4esKbMupe5y60/f8EGM+vioRIDBTgdO1XU9UXDnT7bNZBAgsBNLJdXb/DgS2QKDr7EbLbcHOtonbLaCTb/f+t/UECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQGBOAv8DJM/ahvtwa3cAAAAASUVORK5CYII=', '1986-01-20'),
(9, 'fátima abigaíl', 'venegas, tolentino', 'calle león avicario', 'femenino', 'danielasalgadobiodent@gmail.com', '6621951735', '*', 'No', 'No', 'No', ' No', 'No', 'No ', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'data:image/png;base64,[encoded data, 5380 characters]', '2009-01-20'),
(10, 'erika gabriela', 'samaniego rivera', 'nicolás bravo, diana, laura y río muerto', 'femenino', 'danielasalgadobiodent@gmail.com', '6629360047', '*', 'No', 'No', 'No', ' No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'data:image/png;base64,[encoded data, 5308 characters]', '1979-01-20'),
(11, 'perla lizbeth', 'garcia gonzález', 'benjamín gil y benito juárez', 'femenino', 'danielasalgadobiodent@gmail.com', '2831310673', '*', 'No', 'No', 'No', ' No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'data:image/png;base64,[encoded data, 4772 characters]', '2007-01-20'),
(12, 'esmeralda ', 'espinoza, montiel', 'aquiles serdán', 'femenino', 'danielasalgadobiodent@gmail.com', '6629485685', '*', 'No', 'No', 'No', ' No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'data:image/png;base64,[encoded data, 5284 characters]', '1985-01-20'),
(13, 'elizabeth', 'zazueta flores', 'frutar colinas calles, 13 de marzo y 6 de abril', 'femenino', 'danielasalgadobiodent@gmail.com', '6621905506', '*', 'No', 'No', 'No', ' No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'data:image/png;base64,[encoded data, 4376 characters]', '1978-01-20'),
(14, 'edwin alexis', 'hernández Álvarez', 'hmo', 'masculino', 'danielasalgadobiodent@gmail.com', '6623471834', '*', 'No', 'No', 'No', ' No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', '*', '*', '*', 'data:image/png;base64,[encoded data, 4868 characters]', '2016-10-21'),
(15, 'rita', 'quezada chaparro', 'lázaro cárdenas, emiliano zapata, 16 de septiembre', 'femenino', 'danielasalgadobiodent@gmail.com', '6624204129', '*', 'No', 'No', 'No', ' No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'data:image/png;base64,[encoded data, 4804 characters]', '1943-03-20');
INSERT INTO `pacientes` (`id`, `nombres`, `apellidos`, `direccion`, `sexo`, `email`, `tell`, `clave`, `hospd`, `trat`, `medto`, `alerg`, `anesia`, `hptitis`, `diabts`, `hipeart`, `cdtias`, `fuma`, `plumas`, `rechina`, `embar`, `anticons`, `notas`, `f`, `nacimiento`) VALUES
(16, 'patricia', 'tapia, anaya', 'hmo', 'femenino', 'danielasalgadobiodent@gmail.com', '6623617892', '*', 'No', 'No', 'No', ' No', 'No', 'No', 'No', 'Si', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'data:image/png;base64,[encoded data, 4764 characters]', '1974-08-17'),
(17, 'gregoria', 'belmontes leyva', 'avenida nicolás bravo, 20 de noviembre y 30 de julio, 412', 'femenino', 'danielasalgadobiodent@gmail.com', '6624000728', '*', 'No', 'No', 'No', ' No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'data:image/png;base64,[encoded data, 4372 characters]', '1980-01-20'),
(18, 'jesús, antonio', 'puentes Álvarez', 'avenida morelos entre boulevard y 13 de septiembre', 'masculino', 'danielasalgadobiodent@gmail.com', '6624177018', '*', 'No', 'No', 'No', ' No', 'No', 'No', 'No', 'Si', 'No', 'No', 'No', 'No', '*', '*', '*', 'data:image/png;base64,[encoded data, 5240 characters]', '1956-01-20'),
(19, 'juan noel', 'duran pérez', 'carretera de allá de kino 408', 'masculino', 'danielasalgadobiodent@gmail.com', '6624158247', '*', 'No', 'No', 'No', ' No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', '*', '*', '*', 'data:image/png;base64,[encoded data, 4980 characters]', '1992-01-20'),
(20, 'norberto', 'pastillas figueroa', 'danielasalgadobiodent@gmail.com', 'masculino', 'danielasalgadobiodent@gmail.com', '6623276445', '*', 'No', 'No', 'No', ' No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', '*', '*', '*', 'data:image/png;base64,[encoded data, 4756 characters]', '1989-07-23'),
(21, 'noemí', 'cisneros, rascón', 'josé maría morelos, esquina 20 de noviembre', 'femenino', 'danielasalgadobiodent@gmail.com', '6622907245', '*', 'No', 'No', 'No', ' No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'data:image/png;base64,[encoded data, 4924 characters]', '1985-01-20'),
(22, 'ernesto', 'ponce virgen', 'carretera norte kilómetro, 19', 'masculino', 'danielasalgadobiodent@gmail.com', '3231042985', '*', 'No', 'No', 'No', ' No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', '*', '*', '*', 'data:image/png;base64,[encoded data, 5028 characters]', '1973-01-20'),
(23, 'guadalupe victoria', 'herrera q', 'ignacio zaragoza, 1412', 'femenino', 'danielasalgadobiodent@gmail.com', '6622231809', '*', 'No', 'No', 'No', ' No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'data:image/png;base64,[encoded data, 4656 characters]', '1965-07-28'),
(24, 'maximina ', 'díaz mórale ', 'las palmas, leyva, oaxaca', 'femenino', 'danielasalgadobiodent@gmail.com', '6621139333', '*', 'No', 'No', 'No', ' No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAPoAAADICAYAAADBXvybAAAAAXNSR0IArs4c6QAAAERlWElmTU0AKgAAAAgAAYdpAAQAAAABAAAAGgAAAAAAA6ABAAMAAAABAAEAAKACAAQAAAABAAAA+qADAAQAAAABAAAAyAAAAAB2lQbVAAALJUlEQVR4Ae3dW6isVR0A8G36IKGQEZQSZXRKSSyN6EECO93scgyjC9ZDEWmnOIFgQQQRE9hDdCFI45hG1ENKZIUZeSlClKIe0gghy4eyshOVFUT50O3/z5nDnM3M3jPfZb71zfot+DOzZ761vrV+a//3N99t9s6OQoAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQIECBAgQIAAAQJbJfDcGM0k4qlbNSqDIUDguEAm+X8jbon4wfFXPRmtwBNG23Md71PgbdH4tRFvnK5k9tjnOrXdo4BE7xF35E3/edr/j8TjxyNOHfl4qu6+RK96+lca/HdjqTsiPrXS0hYqUkCiFzktxXXq/dGjSyJeV1zPdGglAYm+ElP1Cz0WAu+N+HzEWdVrjBBAoo9w0gbq8l2x3hsirh9o/VbbQkCit8CrsOpkOubZY4UE4xyyRB/nvA3Z68Ox8isjDg7ZCeteT0Cir+dl6Z2dRwLhqoiPwRiPgEQfz1yV1NOvTTvzppI6pS/LBST6chvv7C3w6Xj76r0X8W4pAhK9lJkYXz9mW/U3j6/r9fVYotc3512O+EPR2OciDnTZqLa6F5DozUwnUS3jxRE1l7tj8Hkd/BdrRhjD2CX6+rM0iSoXR5we8YWImyJq3qJ9Msb/YMSNEUqhAhK92cTkliyv/z4/4oGIX0Z8OKLWckUM/JyID9QKUPq4JXr7GbommnhOxHkRP4t4SUSN5Z0x6A9GvKLGwZc+ZonezQw9FM28NeKjEfdE1HiXVxpksh+NcO96IJRUJHq3s5GnnA5F3BYx5mQ/uSFLjvuOCPeuNwTsq5pE717229Hk2JM9DzT+oSHN7N711zesr1oPAhK9Gep+bmNP9rOD5Vgzmp28dz2vmMsr53yEb4jYdbX9fmG7Xt82tPenGMRpKwxkzMl+dozvVyuMcdkit8YbPsIv0/H6KATeEr386ho9zX31/OrkV61RZ+hF/xIdeHLLTuTWPA/QvbZlO6oTGETgoljrD9dccyZ5JvsYDtBlgmeid1Fy3L+OaPtHo4u+aIPAWgLPiKV/s1aNxxeebdlLT/YLo7v3Nxjfsip5iexXlr3pdQKlCuRxjdw6Nzm+MYZkf0OM7Zsd498b7R3puE3NEehdILfouWVvUkpP9vy21880GdgedS6I9/KPYz4qAwg02SoN0M3iVvnb6NHTG/aq9KPx+U8V/95wbMuq3R9vvC/i2mULeL1fAYnezDe36E0TPdc4n+wlHo3/VzOWPWtdF+8+HJH77MqGBSR6M/Dcop/ZrOrxWpnsl0Tk+ebSD9Ad73TLJ7lVvzzi1S3bUX1NAYm+Jth08d/FY5st+mytd8aTQxFjvzZ+Np79Hh+NBQ5HXB/hlNt+Wh2+L9GbYf4xquW+bBdl/mN8DVv22wPt5gj761389qzYhkRfEWrXYnnDx9N2vdbmx9qSPe9bz7MWR9qgqUugb4EXxAp+2sNKcos+9BV0k+hDRt/FKbe+hefat0Wfw1jjaW7Ru/roPr/a+S37UNeIN70XfX4cqzx3ym0VJcsMKnBSrD23vPnYR3lZNJrXm+dR6k2Xz8YK84DZpkpeHuuU26a0rWdtgWNRo8v99N0dOC9e+EnEpr+t5Tuxzk0eFMyj73njy2siFALFCeQ+eu6r91meGI3fMo18vomS32h7ziZWNLeOvJ4gT1meNfeapwSKEMhz4PkLuomSW/XcuudWvs+S++e5S7Kp/fT5sUzih1vnX/CcQAkCX45OvH2DHcn99dxvv6zHdeaWPLfoQ5VvxYonQ63cegksEvhEvHjVojd6fO1gtJ3fHX9TxIEe1pP75rmPPlTJj+75Ef7SoTqwret1eq35zD4WVc9oXr1Rze9HrfMjHojo47/DnBvtPhQxVHkkVvyeiKMR9tc7nAWJ3hzz382rtq55TbQw/99hujrn/spo9/bWvWvXQH58vyEir4dXCAwuMIkeZAxd8uN2Fx/nnxft/H7owcytPw/MTeZ+9rSFgC16C7xCqubVdF18nM8Di18qZEzZjfwIf2VEiffrZ/+USgQmMc6MksqB6EweqMst/DsiTo9YteTWPLfqJZW8iCYvpnFLa0mzUllfJjHejBLLy6NTX4/Ic+L5mFvrvZL+6nh/6H3z6MLCkpfH5mWySguBU1rUVbVcge9F1zIyufNbXfPce34s/0bELyLyjEGW0yIu+v+znZ13TR9Le8hbWu+NOBJxXWmdG0t/ThpLRwvs52Tap9ljgV08oUuZ9BdHvOiEVx//g3DPrtdK+zFvab0v4sKIvOtNIbAxgUmsKUPZjEBu0XPLrjQQcNS9AZoqgwjkx/aHI9zS2oBfojdAU2Uwgbze//IIt7SuOQUSfU0wiw8q8Gis/d0RN0a4RHaNqZDoa2BZtAiB/B78vET2aBG9GUknJPpIJko3TxCYxE95xigflRUEJPoKSBYpUuBw9Covkb20yN4V1imJXtiE6M7KAm5pXZmq2f/4XqN5ixLoVcAtrSvy2qKvCGWxYgUm0bO8pj8flSUCEn0JjJdHJeCW1n2mS6LvA+TtUQjk/voVEXnazS2tC6ZMoi9A8dIoBfJLLW+O8F9aF0yfRF+A4qXRCuQtrf5L64Lpk+gLULw0aoG8Hj636nlrqzIVkOh+FbZNIO9XnyX7to2t8XgkemM6FQsWcEvrrsmR6LtA/Lg1Am5pnZtKiT6H4elWCbildW46JfochqdbJzC7pbX6//oi0bfud9uAdglMpj/PHne9XcePEr2Oea59lLNbWp9fK8QptQ7cuKsSyEtk8/vr87++VFls0auc9ioHXW2S52xL9Cp/5w26NgGJXtuMG2+VAhK9ymk36NoEJHptM268VQpI9Cqn3aBrE5Dotc248VYpINGrnHaDrk1Aotc248ZbpYBEr3LaDbo2AYle24wbb5UCEr3KaTfo2gQkem0zbrxVCkj0KqfdoGsTkOi1zbjxVikg0dtN+6ntqqtNYDMCEr25831R9dnNq6tJgMAYBJ4SnfxnhG/pGcNsVd7Hkysff5vh/yMqvzTibxE/j1AIFCvgo3u7qbktqh9q14TaBAiULpD76MdK76T+ESDQXuDH0cTB9s1ogUB/AvbR29ueGU3k94Xf2b4pLRAgUKrAC6NjD5baOf0iQKA7gUz0THiFQJECPrp3My3PimaeGXF3N81phQCBEgXyYFwelFMIENhygTzNlqfbFALFCfjo3t2UnBtNPSniR901qSUCBEoTuCw6dFdpndIfAgS6FcibW/Iml7zZRSFQlICP7t1Nx3+iqQsi/hrhvHp3rloiUJzAGcX1SIcIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgAABAgQIECBAgACBfQX+B2WfBH4ARjivAAAAAElFTkSuQmCC', '1978-08-21');
INSERT INTO `pacientes` (`id`, `nombres`, `apellidos`, `direccion`, `sexo`, `email`, `tell`, `clave`, `hospd`, `trat`, `medto`, `alerg`, `anesia`, `hptitis`, `diabts`, `hipeart`, `cdtias`, `fuma`, `plumas`, `rechina`, `embar`, `anticons`, `notas`, `f`, `nacimiento`) VALUES
(25, 'maría de la luz', 'rivera', 'tejido el triunfo', 'femenino', 'danielasalgadobiodent@gmail.com', '6623626122', '*', 'No', 'No', 'No', ' No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'No', 'data:image/png;base64,[encoded data, 4464 characters]', '1966-09-23');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `productos`
--

CREATE TABLE `productos` (
  `id` int(11) NOT NULL,
  `nombre` varchar(100) DEFAULT NULL,
  `descr` text DEFAULT NULL,
  `barras` varchar(50) NOT NULL,
  `unidad` varchar(50) NOT NULL,
  `marca` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `citas`
--
ALTER TABLE `citas`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `inventario`
--
ALTER TABLE `inventario`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `medicos`
--
ALTER TABLE `medicos`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `pacientes`
--
ALTER TABLE `pacientes`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `productos`
--
ALTER TABLE `productos`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `citas`
--
ALTER TABLE `citas`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=63;

--
-- AUTO_INCREMENT de la tabla `inventario`
--
ALTER TABLE `inventario`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT de la tabla `medicos`
--
ALTER TABLE `medicos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `pacientes`
--
ALTER TABLE `pacientes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT de la tabla `productos`
--
ALTER TABLE `productos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
COMMIT;

