jejejeje escribo desde Falcón Venezuela......
aqui las tablas....
CREATE TABLE IF NOT EXISTS `entrada` (
`cedula` int(8) NOT NULL,
`fechaEntrada` varchar(8) collate utf8_spanish_ci NOT NULL,
`horaEntrada` varchar(8) collate utf8_spanish_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
INSERT INTO `entrada` (`cedula`, `fechaEntrada`, `horaEntrada`) VALUES
(16333540, '26-10-12', '10:59:10'),
(16333540, '26-10-12', '06:06:09');
CREATE TABLE IF NOT EXISTS `horarioprof` (
`cedula` int(8) NOT NULL,
`apellidosNombres` varchar(50) collate utf8_spanish_ci NOT NULL,
`seccion` varchar(10) collate utf8_spanish_ci NOT NULL,
`materia` varchar(50) collate utf8_spanish_ci NOT NULL,
`horario` varchar(100) collate utf8_spanish_ci NOT NULL,
`aula` varchar(6) collate utf8_spanish_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
INSERT INTO `horarioprof` (`cedula`, `apellidosNombres`, `seccion`, `materia`, `horario`, `aula`) VALUES
(15806718, 'SIBADA LUQUEZ, OLGA ODALY', 'A3AA01', 'ARA.ADU.NOM.', 'Lunes Hora:07:30am a 08:50am', 'A204'),
(16333540, 'PINEDA ACEVEDO, JERSO ELIMAR', 'A5GA01', 'APL.MOD.INF.', 'Martes Hora:07:30am a 08:50am', 'A113'),
(16333540, 'PINEDA ACEVEDO, JERSO ELIMAR', 'A1FA01', 'INT.INFORMAT.', 'Martes Hora:09:00am a 10:20am', 'A206'),
(17309046, 'DE LA ROSA TORRES, JUAN FRANCI', 'A3NA02', 'APL.MOD.INF.', 'Martes Hora:06:00pm a 07:20pm', 'A108'),
(16333540, 'PINEDA ACEVEDO, JERSO ELIMAR', 'A5GA02', 'APL.MOD.INF.', 'Martes Hora:06:00pm a 07:20pm', 'A113'),
CREATE TABLE IF NOT EXISTS `salida` (
`cedula` int(8) NOT NULL,
`fechaSalida` varchar(8) NOT NULL,
`horaSalida` varchar(8)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
INSERT INTO `salida` (`cedula`, `fechaSalida`, `horaSalida`) VALUES
(16333540, '26-10-12', '12:30:00');