-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Servidor: localhost:3306
-- Tiempo de generación: 11-08-2025 a las 15:02:52
-- Versión del servidor: 10.11.14-MariaDB
-- Versión de PHP: 8.4.10

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Base de datos: `sanrafa_promo_cita`
--

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

--
-- Estructura de tabla para la tabla `general_cita`
--

CREATE TABLE `general_cita` (
  `IdCita` int(11) NOT NULL,
  `IdHorario` int(11) NOT NULL,
  `IdFecha` int(11) NOT NULL,
  `IdSucursal` int(11) NOT NULL,
  `IdProyecto` int(11) NOT NULL,
  `Hora` time NOT NULL,
  `Fecha` date NOT NULL,
  `NumSocio` varchar(32) NOT NULL,
  `Telefono` varchar(32) NOT NULL,
  `Correo` varchar(256) NOT NULL,
  `Estado` char(1) NOT NULL,
  `HoraCita` time DEFAULT NULL,
  `NoCita` int(11) DEFAULT NULL,
  `Identificador` varchar(36) DEFAULT NULL,
  `Sucursal` varchar(256) DEFAULT NULL,
  `Proyecto` varchar(128) DEFAULT NULL,
  `HoraRegistro` datetime DEFAULT NULL,
  `HoraCancelacion` datetime DEFAULT NULL,
  `Nombre` varchar(256) DEFAULT NULL,
  `ApPaterno` varchar(128) DEFAULT NULL,
  `ApMaterno` varchar(128) DEFAULT NULL,
  `NumSif` varchar(32) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `general_cita` (`IdCita`, `IdHorario`, `IdFecha`, `IdSucursal`, `IdProyecto`, `Hora`, `Fecha`, `NumSocio`, `Telefono`, `Correo`, `Estado`, `HoraCita`, `NoCita`, `Identificador`, `Sucursal`, `Proyecto`, `HoraRegistro`, `HoraCancelacion`, `Nombre`, `ApPaterno`, `ApMaterno`, `NumSif`) VALUES
(781, 3628, 503, 21, 45, '16:30:00', '2025-08-12', '10100165555', '', 'Walidoverman87@gmail.com', 'A', '16:30:00', 1, '78de8b58-6655-11f0-abfa-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-07-21 11:09:22', NULL, 'JORGE DANIEL', 'SILVA', 'HERNANDEZ', '011710015629'),
(1140, 3968, 542, 25, 45, '16:30:00', '2025-08-11', '10190299078', '', 'racso.2587@gmail.com', 'A', '16:30:00', 1, '7b377c56-6660-11f0-abfa-ac1f6b4044d0', 'San Sebastián ', 'Útiles escolares 2025', '2025-07-21 12:28:10', NULL, 'FATIMA VANESSA', 'CARDENAS', 'ULLOA', '10190299078'),
(1175, 3621, 503, 21, 45, '11:00:00', '2025-08-12', '10050346952', '', 'barbie21garcia@gmail.com', 'A', '11:00:00', 1, 'd89fbb68-6661-11f0-abfa-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-07-21 12:37:56', NULL, 'JONATHAN ZABDIEL', 'AGUILAR', 'GARCIA', '10050346952'),
(1217, 3612, 501, 21, 45, '10:00:00', '2025-08-09', '10150324740', '', 'gilj8888@gmail.com', 'A', '10:00:00', 1, '15b2e822-6664-11f0-abfa-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-07-21 12:53:58', NULL, 'CRISTOPHER MARTIN', 'GIL', 'ZARRAZAGA', '10150324740'),
(1222, 3612, 501, 21, 45, '10:00:00', '2025-08-09', '10100267713', '', 'gilj8888@gmail.com', 'A', '10:03:00', 2, '46b23cf0-6664-11f0-abfa-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-07-21 12:55:20', NULL, 'YEIMI JEREMI', 'GIL', 'ZARRAZAGA', '10100267713'),
(1762, 3626, 503, 21, 45, '15:30:00', '2025-08-12', '10110281985', '', 'Garcianamber42@gmail ', 'A', '15:30:00', 1, '93df611b-668d-11f0-abfa-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-07-21 17:50:59', NULL, 'ALAN ADRIAN', 'SANCHEZ', 'ZARAGOZA', '10110281985'),
(1944, 3628, 503, 21, 45, '16:30:00', '2025-08-12', '10140265889', '', 'daneet_13@hotmail.com', 'A', '16:33:00', 2, 'd5ec1c39-66a0-11f0-abfa-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-07-21 20:08:50', NULL, 'ESMERALDA JOSSELYN', 'GARCIA', 'PEREZ', '10140265889'),
(2775, 3964, 542, 25, 45, '12:30:00', '2025-08-11', '10190299323', '', 'castellanosrocio189@gmail.com', 'A', '12:30:00', 1, '259b4f74-677d-11f0-abfa-ac1f6b4044d0', 'San Sebastián ', 'Útiles escolares 2025', '2025-07-22 22:25:52', NULL, 'VIVIANA YAMILET', 'ALEJO', 'PALOS', '10190299323'),
(2880, 3952, 541, 25, 45, '10:00:00', '2025-08-09', '10190301289', '', 'yenizapata067@gmail.com', 'A', '10:00:00', 1, '6f193d95-67e3-11f0-abfa-ac1f6b4044d0', 'San Sebastián ', 'Útiles escolares 2025', '2025-07-23 10:38:03', NULL, 'DANIA AMPARO', 'CIPRIANES', 'ZAPATA', '10190301289'),
(2881, 3952, 541, 25, 45, '10:00:00', '2025-08-09', '10190301287', '', 'yenizapata067@gmail.com', 'A', '10:03:00', 2, 'd3581da3-67e3-11f0-abfa-ac1f6b4044d0', 'San Sebastián ', 'Útiles escolares 2025', '2025-07-23 10:40:52', NULL, 'SERGIO BERNAL', 'CIPRIANES', 'ZAPATA', '10190301287'),
(3195, 3617, 503, 21, 45, '09:00:00', '2025-08-12', '10150267537', '', 'zamarronesmeralda96@gmail.com ', 'A', '09:00:00', 1, '72e17270-6850-11f0-abfa-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-07-23 23:38:25', NULL, 'RIHANA ARAMY', 'AVILA', 'ZAMARRON', '10150267537'),
(3279, 3965, 542, 25, 45, '15:00:00', '2025-08-11', '10100164289', '', 'redel2204@gmail.com', 'A', '15:00:00', 1, '6e39349d-68b1-11f0-abfa-ac1f6b4044d0', 'San Sebastián ', 'Útiles escolares 2025', '2025-07-24 11:12:38', NULL, 'EDEL ALEJANDRO', 'ARAGON', 'GUTIERREZ', '011710011671'),
(3280, 3965, 542, 25, 45, '15:00:00', '2025-08-11', '10190300609', '', 'redel2204@gmail.com', 'A', '15:03:00', 2, 'c1816c65-68b1-11f0-abfa-ac1f6b4044d0', 'San Sebastián ', 'Útiles escolares 2025', '2025-07-24 11:14:57', NULL, 'CAROL RENATA', 'ARAGON', 'GUTIERREZ', '10190300609'),
(3356, 3627, 503, 21, 45, '16:00:00', '2025-08-12', '10150348135', '', 'Garcianamber42@gmail ', 'A', '16:00:00', 1, '213f09f7-68c4-11f0-abfa-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-07-24 13:26:29', NULL, 'NAOMI MAYTE', 'SANCHEZ', 'ZARAGOZA', '10150348135'),
(3358, 3626, 503, 21, 45, '15:30:00', '2025-08-12', '10150348136', '', 'Garcianamber42@gmail ', 'A', '15:33:00', 2, '4628826b-68c4-11f0-abfa-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-07-24 13:27:31', NULL, 'VICTOR GABRIEL', 'SANCHEZ', 'ZARAGOZA', '10150348136'),
(3393, 3616, 501, 21, 45, '12:00:00', '2025-08-09', '10140247164', '', 'monserratnavarrolepe@gmail.com', 'A', '12:00:00', 1, '3ac6be83-68d5-11f0-abfa-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-07-24 15:28:53', NULL, 'CESAR GABRIEL', 'MEDINA', 'NAVARRO', '10140247164'),
(3394, 3616, 501, 21, 45, '12:00:00', '2025-08-09', '10140247163', '', 'monserratnavarrolepe@gmail.com', 'A', '12:03:00', 2, '8514c6eb-68d5-11f0-abfa-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-07-24 15:30:58', NULL, 'LAILA GUADALUPE', 'MEDINA', 'NAVARRO', '10140247163'),
(4348, 3952, 541, 25, 45, '10:00:00', '2025-08-09', '10150284802', '', 'hz_cortes@hotmail.com', 'A', '10:06:00', 3, '44b2f8d2-6cc1-11f0-abfa-ac1f6b4044d0', 'San Sebastián ', 'Útiles escolares 2025', '2025-07-29 15:16:03', NULL, 'TIANA NATALIA', 'MARTINEZ', 'HERNANDEZ', '10150284802'),
(4350, 3952, 541, 25, 45, '10:00:00', '2025-08-09', '10150284805', '', 'hz_cortes@hotmail.com', 'A', '10:09:00', 4, 'b2d0ebe2-6cc1-11f0-abfa-ac1f6b4044d0', 'San Sebastián ', 'Útiles escolares 2025', '2025-07-29 15:19:07', NULL, 'JAZMIN ', 'MARTINEZ', 'HERNANDEZ', '10150284805'),
(4579, 3616, 501, 21, 45, '12:00:00', '2025-08-09', '10150330055', '', 'claudia_eli_92@hotmail.com', 'A', '12:06:00', 3, '088e572f-6db8-11f0-abfa-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-07-30 20:42:27', NULL, 'VAYOLETH CELESTE', 'VILLALVAZO', 'DE ANDA', '10150330055'),
(4858, 3957, 542, 25, 45, '09:00:00', '2025-08-11', '10030091916', '', 'jacqueline.cervantes24@jaliscoedu.mx', 'A', '09:00:00', 1, 'ec0b8b7a-6f16-11f0-abfa-ac1f6b4044d0', 'San Sebastián ', 'Útiles escolares 2025', '2025-08-01 14:34:12', NULL, 'CITLALLI MONTSERRAT', 'CERVANTES', 'MARTINEZ', '011703268753'),
(5014, 4038, 551, 26, 45, '12:00:00', '2025-08-09', '10200312098', '', 'kennyadmicgdl@gmail.com', 'A', '12:00:00', 1, '6b28abb3-6fdb-11f0-abfa-ac1f6b4044d0', 'Constitución', 'Útiles escolares 2025', '2025-08-02 14:00:46', NULL, 'BENJAMIN ALEJANDRO', 'HERNANDEZ', 'DAVILA', '10200312098'),
(5015, 4038, 551, 26, 45, '12:00:00', '2025-08-09', '10200312096', '', 'kennyadmicgdl@gmail.com', 'A', '12:03:00', 2, 'c00b3ee2-6fdb-11f0-abfa-ac1f6b4044d0', 'Constitución', 'Útiles escolares 2025', '2025-08-02 14:03:08', NULL, 'MADISON MARIA', 'HERNANDEZ', 'DAVILA', '10200312096'),
(5067, 3955, 541, 25, 45, '11:30:00', '2025-08-09', '10150293867', '', 'brendadelgadom@unag.mx', 'A', '11:30:00', 1, 'f9fbd6ef-7091-11f0-abfa-ac1f6b4044d0', 'San Sebastián ', 'Útiles escolares 2025', '2025-08-03 11:47:33', NULL, 'LIAM DAVID', 'ZUÑIGA', 'DELGADO', '10150293867'),
(5084, 3955, 541, 25, 45, '11:30:00', '2025-08-09', '10040104637', '', 'Vaztojuan@gmail.com', 'A', '11:33:00', 2, 'c8b105b4-70a4-11f0-abfa-ac1f6b4044d0', 'San Sebastián ', 'Útiles escolares 2025', '2025-08-03 14:02:11', NULL, 'YORDI LEOBARDO', 'VAZQUEZ', 'QUIÑONES', '011704268774'),
(5150, 3957, 542, 25, 45, '09:00:00', '2025-08-11', '10040103452', '', 'anarosadeleon.1972@hotmail.com', 'A', '09:03:00', 2, 'b6562a18-713d-11f0-abfa-ac1f6b4044d0', 'San Sebastián ', 'Útiles escolares 2025', '2025-08-04 08:16:52', NULL, 'CAROLINA FERNANDA', 'GARCIA', 'DE LEON', '011704264339'),
(5321, 3615, 501, 21, 45, '11:30:00', '2025-08-09', '10040103751', '', 'cebara@yahoo.com.mx', 'A', '11:30:00', 1, 'c9a2a9de-71ac-11f0-abfa-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-08-04 21:31:59', NULL, 'JUAN PABLO', 'BARAJAS', 'DIAZ', '011704265645'),
(5322, 3615, 501, 21, 45, '11:30:00', '2025-08-09', '10040103758', '', 'cebara@yahoo.com.mx', 'A', '11:33:00', 2, '357528c9-71ad-11f0-abfa-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-08-04 21:35:00', NULL, 'CARLOS JAVIER', 'BARAJAS', 'DIAZ', '011704265647'),
(5323, 3615, 501, 21, 45, '11:30:00', '2025-08-09', '10040325467', '', 'cebara@yahoo.com.mx', 'A', '11:36:00', 3, '5e42fed1-71ad-11f0-abfa-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-08-04 21:36:08', NULL, 'CHRISTOPHER ', 'BARAJAS', 'DIAZ', '10040325467'),
(5340, 4034, 551, 26, 45, '10:00:00', '2025-08-09', '10200317167', '', 'lyly_beriful@hotmail.com', 'A', '10:00:00', 1, '73b5dc67-71db-11f0-abfa-ac1f6b4044d0', 'Constitución', 'Útiles escolares 2025', '2025-08-05 03:06:01', NULL, 'LIA KATHERINE', 'CASTELLON', 'JASSO', '10200317167'),
(5418, 3616, 501, 21, 45, '12:00:00', '2025-08-09', '10150266172', '', 'lopezlopezmariadelrocio12@gmail.com', 'A', '12:09:00', 4, '454bf926-723e-11f0-81f8-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-08-05 14:53:42', NULL, 'CECILIA ELIZABETH', 'JUAREZ', 'LOPEZ', '10150266172'),
(5451, 4034, 551, 26, 45, '10:00:00', '2025-08-09', '10090224851', '', 'gtjg13a@gmail.com', 'A', '10:03:00', 2, 'e3fe1c55-7261-11f0-81f8-ac1f6b4044d0', 'Constitución', 'Útiles escolares 2025', '2025-08-05 19:08:41', NULL, 'ANGEL EDUARDO', 'GOMEZ', 'ARELIS', '10090224851'),
(5480, 3613, 501, 21, 45, '10:30:00', '2025-08-09', '10150267209', '', 'evaarevalomontes@gmail.com', 'A', '10:30:00', 1, '22d6afb3-7279-11f0-81f8-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-08-05 21:55:04', NULL, 'LESLY ADILENE', 'ROMERO', 'AREVALO', '10150267209'),
(5500, 3624, 503, 21, 45, '12:30:00', '2025-08-12', '10150337484', '', 'Saravelazquez5922@gmai.com ', 'A', '12:30:00', 1, '1ffc6a3c-72cb-11f0-81f8-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-08-06 07:41:58', NULL, 'ALAN LEONEL', 'CARRERO', 'VELAZQUEZ', '10150337484'),
(5606, 3612, 501, 21, 45, '10:00:00', '2025-08-09', '10040221912', '', 'jrgs76@gmail.com', 'A', '10:06:00', 3, '101f00a1-7312-11f0-81f8-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-08-06 16:09:46', NULL, 'JOSE MATEO', 'GONZALEZ', 'GUTIERREZ', '10040221912'),
(5628, 3628, 503, 21, 45, '16:30:00', '2025-08-12', '10020248714', '', 'Auroraalvarado.@.mx.gob', 'A', '16:36:00', 3, '0488e3b1-731d-11f0-81f8-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-08-06 17:28:11', NULL, 'GIOVANNI ALBERTO', 'GONZALEZ', 'ALVARADO', '10020248714'),
(5629, 3628, 503, 21, 45, '16:30:00', '2025-08-12', '10020248716', '', 'Auroraalvarado@.com.mx', 'A', '16:39:00', 4, '8b231fc3-731d-11f0-81f8-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-08-06 17:31:56', NULL, 'KEVIN ALEXIS', 'GONZALEZ', 'ALVARADO', '10020248716'),
(5649, 3628, 503, 21, 45, '16:30:00', '2025-08-12', '10040308345', '', 'mayra.mdnt@gmail.com', 'A', '16:42:00', 5, '7e9c5ddc-732b-11f0-81f8-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-08-06 19:11:48', NULL, 'SANTIAGO YAEL', 'BECERRIL', 'NAVARRETE', '10040308345'),
(5650, 3628, 503, 21, 45, '16:30:00', '2025-08-12', '10040268898', '', 'mayra.mdnt@gmail.com', 'A', '16:45:00', 6, 'bb3b139a-732b-11f0-81f8-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-08-06 19:13:30', NULL, 'DYLAN YOE', 'BECERRIL', 'NAVARRETE', '10040268898'),
(5663, 3957, 542, 25, 45, '09:00:00', '2025-08-11', '10050255373', '', 'perisu5@hotmail.com', 'A', '09:06:00', 3, '2705baf0-733b-11f0-81f8-ac1f6b4044d0', 'San Sebastián ', 'Útiles escolares 2025', '2025-08-06 21:03:53', NULL, 'EVELYN FATIMA', 'GARCIA', 'MORALES', '10050255373'),
(5664, 3957, 542, 25, 45, '09:00:00', '2025-08-11', '10050255379', '', 'perisu5@hotmail.com', 'A', '09:09:00', 4, 'ad9c4f84-733b-11f0-81f8-ac1f6b4044d0', 'San Sebastián ', 'Útiles escolares 2025', '2025-08-06 21:07:39', NULL, 'NESTOR SANTIAGO', 'GARCIA', 'MORALES', '10050255379'),
(5665, 3957, 542, 25, 45, '09:00:00', '2025-08-11', '10050328036', '', 'perisu5@hotmail.com', 'A', '09:12:00', 5, 'f35d7b81-733b-11f0-81f8-ac1f6b4044d0', 'San Sebastián ', 'Útiles escolares 2025', '2025-08-06 21:09:36', NULL, 'LEONARDO SEBASTIAN', 'GARCIA', 'MORALES', '10050328036'),
(5683, 3612, 501, 21, 45, '10:00:00', '2025-08-09', '10100337808', '', 'bberecl@hotmail.com', 'A', '10:09:00', 4, 'ecd58181-73a1-11f0-9446-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-08-07 09:19:34', NULL, 'ANGEL ISAAC', 'OBESO', 'CARRETERO', '10100337808'),
(5705, 3959, 542, 25, 45, '10:00:00', '2025-08-11', '10190303619', '', 'fabiolalopez79@hotmail.com', 'A', '10:00:00', 1, '239f82d6-73bc-11f0-9446-ac1f6b4044d0', 'San Sebastián ', 'Útiles escolares 2025', '2025-08-07 12:27:13', NULL, 'DAIRA SOFIA', 'VALDIVIA', 'LOPEZ', '10190303619'),
(5750, 3952, 541, 25, 45, '10:00:00', '2025-08-09', '10010022260', '', 'garciarizojulio@gmail.com', 'A', '10:12:00', 5, '04cb06ae-73ea-11f0-9446-ac1f6b4044d0', 'San Sebastián ', 'Útiles escolares 2025', '2025-08-07 17:55:38', NULL, 'EDGAR SAID', 'GARCIA', 'VAZQUEZ', '011701303187'),
(5793, 3613, 501, 21, 45, '10:30:00', '2025-08-09', '10150299157', '', 'aparicio.ada@gmail.com', 'A', '10:33:00', 2, 'ce50781a-746c-11f0-9446-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-08-08 09:31:50', NULL, 'IKER SALVADOR', 'ESPARZA', 'NUÑEZ', '10150299157'),
(5835, 3612, 501, 21, 45, '10:00:00', '2025-08-09', '10100295956', '', 'Kaederukawa1@hotmail.com', 'A', '10:12:00', 5, 'fb374483-7497-11f0-9446-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-08-08 14:40:54', NULL, 'SARAH CONSTANZA', 'CORONA', 'HERNANDEZ', '10100295956'),
(5894, 3619, 503, 21, 45, '10:00:00', '2025-08-12', '10040306621', '', 'miguelespino2407@gmail.com', 'A', '10:00:00', 1, 'f2985d2c-75aa-11f0-9446-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-08-09 23:29:11', NULL, 'JOSE MIGUEL', 'ESPINO', 'GUTIERREZ', '10040306621'),
(5896, 3961, 542, 25, 45, '11:00:00', '2025-08-11', '10040104978', '', 'leonelr3@gmail.com', 'A', '11:00:00', 1, '4acbde41-75e8-11f0-9446-ac1f6b4044d0', 'San Sebastián ', 'Útiles escolares 2025', '2025-08-10 06:48:18', NULL, 'JAMIE LEONEL', 'RAMOS', 'DE SANTIAGO', '011704269910'),
(5917, 3623, 503, 21, 45, '12:00:00', '2025-08-12', '10100164961', '', 'Juliocastillo3385@gmail.com', 'A', '12:00:00', 1, '839eb964-7646-11f0-9446-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-08-10 18:02:46', NULL, 'DIEGO EMILIANO', 'VEGA', 'SANTIAGO', '011710013907'),
(5918, 3623, 503, 21, 45, '12:00:00', '2025-08-12', '10100164959', '', 'Juliocastillo3385@gmail.com', 'A', '12:03:00', 2, 'bbbcd2bd-7646-11f0-9446-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-08-10 18:04:20', NULL, 'DAIANA KARELY', 'VEGA', 'SANTIAGO', '011710013905'),
(5936, 3618, 503, 21, 45, '09:30:00', '2025-08-12', '10100267844', '', 'verolopezhdez1@gmail.com', 'A', '09:30:00', 1, '2e627ff5-76b9-11f0-9446-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-08-11 07:43:34', NULL, 'KEVIN ANTONIO', 'CASTILLO', 'LOPEZ', '10100267844'),
(5948, 3628, 503, 21, 45, '16:30:00', '2025-08-12', '10070252652', '', 'martagm220267@gmail.com', 'A', '16:48:00', 7, '9c0170ed-76d1-11f0-9446-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-08-11 10:38:26', NULL, 'CECILIA NAOMI', 'SALAZAR', 'GASPAR', '10070252652'),
(5957, 3625, 503, 21, 45, '15:00:00', '2025-08-12', '10100164399', '', 'gabriela.ramirez@hotmail.com', 'A', '15:00:00', 1, '3868147d-76dc-11f0-9446-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-08-11 11:54:23', NULL, 'HECTOR DAVID', 'ADONA', 'RAMIREZ', '011710012101'),
(5965, 3625, 503, 21, 45, '15:00:00', '2025-08-12', '10100164400', '', 'gabriela.ramirez@hotmail.com', 'A', '15:03:00', 2, 'f6e8ba5d-76e8-11f0-9446-ac1f6b4044d0', 'Centro Sur ', 'Útiles escolares 2025', '2025-08-11 13:25:37', NULL, 'SANTIAGO ', 'ADONA', 'RAMIREZ', '011710012102');

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `general_cita`
--
ALTER TABLE `general_cita`
  ADD PRIMARY KEY (`IdCita`),
  ADD UNIQUE KEY `Uq_general_cita` (`Identificador`),
  ADD KEY `IX_NumSocio` (`IdProyecto`,`NumSocio`),
  ADD KEY `IX_NumSif` (`IdProyecto`,`NumSif`),
  ADD KEY `IX_Estado` (`Estado`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `general_cita`
--
ALTER TABLE `general_cita`
  MODIFY `IdCita` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5969;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
