/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50616
Source Host           : localhost:3306
Source Database       : checador_corp

Target Server Type    : MYSQL
Target Server Version : 50616
File Encoding         : 65001

Date: 2014-07-25 10:37:31
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for cat_empleados
-- ----------------------------
DROP TABLE IF EXISTS `cat_empleados`;
CREATE TABLE `cat_empleados` (
  `id_empleado` int(5) NOT NULL AUTO_INCREMENT,
  `key_empresa` int(4) NOT NULL,
  `key_departamento` int(4) NOT NULL,
  `key_area` int(4) NOT NULL,
  `nombre_empleado` varchar(250) DEFAULT NULL,
  `fecha_creacion` date DEFAULT NULL,
  `apellido_p_empleado` varchar(60) DEFAULT NULL,
  `apellido_m_empleado` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`id_empleado`,`key_empresa`,`key_departamento`,`key_area`)
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cat_empleados
-- ----------------------------
INSERT INTO `cat_empleados` VALUES ('1', '2', '1', '1', 'KARINA ELIZABETH', null, 'BURGUEÑO', 'PIÑA');
INSERT INTO `cat_empleados` VALUES ('2', '2', '1', '1', 'HERNAN', null, 'LOPEZ', 'GAMEZ');
INSERT INTO `cat_empleados` VALUES ('3', '2', '1', '1', 'JORGE', null, 'QUIÑONES', 'SOTO');
INSERT INTO `cat_empleados` VALUES ('4', '2', '1', '1', 'ANA CAROLINA', null, 'GONZALEZ', 'RUIZ');
INSERT INTO `cat_empleados` VALUES ('5', '2', '1', '1', 'GREGORIO', null, 'GUZMAN', 'RENTERIA');
INSERT INTO `cat_empleados` VALUES ('6', '2', '1', '1', 'VICTOR ANTONIO', null, 'RAMIREZ', 'PERAZA');
INSERT INTO `cat_empleados` VALUES ('7', '3', '1', '1', 'JUAN RAMON', null, 'ARBALLO', 'GUTIERREZ');
INSERT INTO `cat_empleados` VALUES ('8', '3', '1', '1', 'PATRICIA GUADALUPE', null, 'NIEBLA', 'DIAZ');
INSERT INTO `cat_empleados` VALUES ('11', '3', '1', '1', 'MARTHA GUADALUPE', null, 'CASTRO', 'BUSTAMANTE');
INSERT INTO `cat_empleados` VALUES ('12', '3', '1', '1', 'JESUS GILBERTO', null, 'VELAZQUEZ', 'BURGUEÑO');
INSERT INTO `cat_empleados` VALUES ('13', '3', '1', '1', 'FRANCISCO RAFAEL', null, 'MENDEZ', 'GUEVARA');
INSERT INTO `cat_empleados` VALUES ('16', '1', '1', '1', 'AGUSTIN', null, 'AVILA', 'ALFARO');
INSERT INTO `cat_empleados` VALUES ('20', '1', '1', '1', 'CINTHYA LIZETH', null, 'CRUZ', 'FLORES');
INSERT INTO `cat_empleados` VALUES ('22', '1', '1', '1', 'JOSE ANGEL', null, 'MORENO', 'SALAS');
INSERT INTO `cat_empleados` VALUES ('24', '7', '1', '1', 'CARLOS ALBERTO', null, 'LOPEZ', 'BURGUEÑO');
INSERT INTO `cat_empleados` VALUES ('25', '7', '1', '1', 'IRVING MITCHELL', null, 'SOTELO', 'BARAJAS');
INSERT INTO `cat_empleados` VALUES ('26', '7', '1', '1', 'EDGAR MARTIN', null, 'LIZARRAGA', 'OSUNA');
INSERT INTO `cat_empleados` VALUES ('29', '4', '1', '1', 'OSCAR', null, 'LOPEZ', 'GAMEZ');
INSERT INTO `cat_empleados` VALUES ('30', '6', '1', '1', 'MARLENNE PATRICIA', null, 'ISIORDIA', 'DIAZ');
INSERT INTO `cat_empleados` VALUES ('31', '6', '1', '1', 'IRMA LILIA', null, 'CHAVEZ', 'RODRIGUEZ');
INSERT INTO `cat_empleados` VALUES ('32', '6', '1', '1', 'MARIO ALBERTO', null, 'GONZALEZ', 'MOLINA');
INSERT INTO `cat_empleados` VALUES ('33', '6', '1', '1', 'CLAUDIA ELIZABETH', null, 'LOPEZ', 'SALAS');
INSERT INTO `cat_empleados` VALUES ('34', '6', '1', '1', 'GABRIELA', null, 'MONTELONGO', 'OSUNA');
INSERT INTO `cat_empleados` VALUES ('35', '6', '1', '1', 'NORMA ANGELICA', null, 'SOLANO', 'GARCIA');
INSERT INTO `cat_empleados` VALUES ('36', '4', '1', '1', 'DARINKA VERONICA', null, 'BARAJAS', 'ANDRADE');
INSERT INTO `cat_empleados` VALUES ('37', '4', '1', '1', 'SAMANTHA YARED', null, 'BARAJAS', 'ANDRADE');
INSERT INTO `cat_empleados` VALUES ('38', '4', '1', '1', 'LUIS ENRIQUE', null, 'BARAJAS', 'BURGUEÑO');
INSERT INTO `cat_empleados` VALUES ('39', '4', '1', '1', 'KAREN', null, 'OSUNA', 'GRANADOS');
INSERT INTO `cat_empleados` VALUES ('49', '2', '1', '1', 'MANUEL', null, 'BARRAZA', 'GONZALEZ');
INSERT INTO `cat_empleados` VALUES ('51', '3', '1', '1', 'SANTOS MARTIN', null, 'GOMEZ', 'DORADO');
INSERT INTO `cat_empleados` VALUES ('53', '4', '1', '1', 'PERLA DANIELA', null, 'PERAZA', 'ROCHA');
INSERT INTO `cat_empleados` VALUES ('55', '1', '1', '1', 'DIANA SELENNE', null, 'TIRADO', 'ONTIVEROS');
INSERT INTO `cat_empleados` VALUES ('57', '1', '1', '1', 'VICTOR JAVIER', null, 'GOMEZ', 'FIGUEROA');
INSERT INTO `cat_empleados` VALUES ('60', '3', '1', '1', 'JORGE IVAN', null, 'OCHOA', 'ROMERO');
INSERT INTO `cat_empleados` VALUES ('65', '3', '1', '1', 'ROSAURA', null, 'DELGADO', 'GARCIA');
INSERT INTO `cat_empleados` VALUES ('69', '3', '1', '1', 'TERESA DE JESUS', null, 'VALDEZ', 'NIEBLA');
INSERT INTO `cat_empleados` VALUES ('71', '2', '1', '1', 'ALMA RUTH', null, 'FERRUSQUIA', 'ALVAREZ');
INSERT INTO `cat_empleados` VALUES ('72', '3', '1', '1', 'PERLA PATRICIA', null, 'GONZALES', 'SANCHEZ');
INSERT INTO `cat_empleados` VALUES ('73', '1', '1', '1', 'PAOLA JANETH', null, 'CAÑEDO', 'VELARDE');

-- ----------------------------
-- Table structure for cat_empresas
-- ----------------------------
DROP TABLE IF EXISTS `cat_empresas`;
CREATE TABLE `cat_empresas` (
  `id_empresa` int(3) NOT NULL AUTO_INCREMENT,
  `nombre_empresa` varchar(200) DEFAULT NULL,
  `fecha_creacion` date DEFAULT NULL,
  `hora_entrada` time DEFAULT NULL,
  `hora_salida_comida` time DEFAULT NULL,
  `hora_entrada_comida` time DEFAULT NULL,
  `hora_salida` time DEFAULT NULL,
  PRIMARY KEY (`id_empresa`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cat_empresas
-- ----------------------------
INSERT INTO `cat_empresas` VALUES ('1', 'SAF', null, '08:30:00', '13:30:00', '16:00:00', '18:00:00');
INSERT INTO `cat_empresas` VALUES ('2', 'BLM', null, '08:30:00', '13:30:00', '16:00:00', '18:00:00');
INSERT INTO `cat_empresas` VALUES ('3', 'SOFA', null, '08:30:00', '13:30:00', '16:00:00', '18:00:00');
INSERT INTO `cat_empresas` VALUES ('4', 'VIDELI', null, '09:00:00', '17:00:00', null, null);
INSERT INTO `cat_empresas` VALUES ('5', 'DIKA', null, null, null, null, null);
INSERT INTO `cat_empresas` VALUES ('6', 'AXESSO', null, null, null, null, null);
INSERT INTO `cat_empresas` VALUES ('7', 'SITI', null, '08:30:00', '13:30:00', '16:00:00', '18:00:00');

-- ----------------------------
-- Table structure for checadas
-- ----------------------------
DROP TABLE IF EXISTS `checadas`;
CREATE TABLE `checadas` (
  `id_checado` int(11) NOT NULL AUTO_INCREMENT,
  `key_empleado` int(11) NOT NULL,
  `key_empresa` int(11) DEFAULT NULL,
  `fecha_checado` date DEFAULT NULL,
  `hora_entrada` time DEFAULT NULL,
  `hora_salida_comida` time DEFAULT NULL,
  `hora_entrada_comida` time DEFAULT NULL,
  `hora_salida` time DEFAULT NULL,
  `ultima_actualizacion` time DEFAULT NULL,
  `usuario` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id_checado`,`key_empleado`)
) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of checadas
-- ----------------------------
INSERT INTO `checadas` VALUES ('1', '1', '2', '2014-07-20', '09:31:18', '09:32:30', '00:00:00', '00:00:00', '09:32:30', 'corporativo');
INSERT INTO `checadas` VALUES ('2', '2', '2', '2014-07-20', '09:31:20', '00:00:00', '00:00:00', '00:00:00', '09:31:20', 'corporativo');
INSERT INTO `checadas` VALUES ('3', '3', '2', '2014-07-20', '09:32:37', '00:00:00', '00:00:00', '00:00:00', '09:32:37', 'corporativo');
INSERT INTO `checadas` VALUES ('4', '4', '2', '2014-07-20', '09:32:38', '00:00:00', '00:00:00', '00:00:00', '09:32:38', 'corporativo');
INSERT INTO `checadas` VALUES ('5', '5', '2', '2014-07-20', '09:32:41', '00:00:00', '00:00:00', '00:00:00', '09:32:41', 'corporativo');
INSERT INTO `checadas` VALUES ('6', '6', '2', '2014-07-20', '09:32:42', '00:00:00', '00:00:00', '00:00:00', '09:32:42', 'corporativo');
INSERT INTO `checadas` VALUES ('7', '7', '3', '2014-07-20', '09:32:44', '00:00:00', '00:00:00', '00:00:00', '09:32:44', 'corporativo');
INSERT INTO `checadas` VALUES ('8', '8', '3', '2014-07-20', '09:32:49', '00:00:00', '00:00:00', '00:00:00', '09:32:49', 'corporativo');
INSERT INTO `checadas` VALUES ('9', '11', '3', '2014-07-20', '09:32:56', '00:00:00', '00:00:00', '00:00:00', '09:32:56', 'corporativo');
INSERT INTO `checadas` VALUES ('10', '12', '3', '2014-07-20', '09:32:59', '00:00:00', '00:00:00', '00:00:00', '09:32:59', 'corporativo');
INSERT INTO `checadas` VALUES ('11', '13', '3', '2014-07-20', '09:33:00', '00:00:00', '00:00:00', '00:00:00', '09:33:00', 'corporativo');
INSERT INTO `checadas` VALUES ('12', '16', '1', '2014-07-20', '09:33:09', '00:00:00', '00:00:00', '00:00:00', '09:33:09', 'corporativo');
INSERT INTO `checadas` VALUES ('13', '20', '1', '2014-07-20', '09:33:26', '00:00:00', '00:00:00', '00:00:00', '09:33:26', 'corporativo');
INSERT INTO `checadas` VALUES ('14', '22', '1', '2014-07-20', '09:33:31', '00:00:00', '00:00:00', '00:00:00', '09:33:31', 'corporativo');
INSERT INTO `checadas` VALUES ('15', '24', '7', '2014-07-20', '09:35:53', '00:00:00', '00:00:00', '00:00:00', '09:35:53', 'corporativo');
INSERT INTO `checadas` VALUES ('16', '25', '7', '2014-07-20', '09:35:56', '00:00:00', '00:00:00', '00:00:00', '09:35:56', 'corporativo');
INSERT INTO `checadas` VALUES ('17', '26', '7', '2014-07-20', '09:35:58', '00:00:00', '00:00:00', '00:00:00', '09:35:58', 'corporativo');
INSERT INTO `checadas` VALUES ('18', '55', '1', '2014-07-20', '09:38:50', '00:00:00', '00:00:00', '00:00:00', '09:38:50', 'admin');
INSERT INTO `checadas` VALUES ('19', '57', '1', '2014-07-20', '09:38:52', '00:00:00', '00:00:00', '00:00:00', '09:38:52', 'admin');
INSERT INTO `checadas` VALUES ('20', '73', '1', '2014-07-20', '09:39:02', '00:00:00', '00:00:00', '00:00:00', '09:39:02', 'admin');
INSERT INTO `checadas` VALUES ('21', '1', '2', '2014-07-20', '09:41:12', '09:41:13', '09:41:14', '09:41:14', '09:41:14', 'admin');
INSERT INTO `checadas` VALUES ('22', '2', '2', '2014-07-21', '09:41:15', '09:41:15', '09:41:16', '09:41:16', '09:41:16', 'admin');
INSERT INTO `checadas` VALUES ('23', '3', '2', '2014-07-21', '09:41:17', '09:41:18', '09:41:18', '09:41:19', '09:41:19', 'admin');
INSERT INTO `checadas` VALUES ('24', '4', '2', '2014-07-21', '09:41:20', '09:41:21', '09:41:22', '09:41:23', '09:41:23', 'admin');
INSERT INTO `checadas` VALUES ('25', '5', '2', '2014-07-21', '09:41:23', '09:41:24', '09:41:25', '09:41:26', '09:41:26', 'admin');
INSERT INTO `checadas` VALUES ('26', '6', '2', '2014-07-21', '09:41:28', '09:41:29', '09:41:30', '09:41:30', '09:41:30', 'admin');
INSERT INTO `checadas` VALUES ('27', '7', '3', '2014-07-21', '09:41:31', '09:41:32', '09:41:33', '09:41:33', '09:41:33', 'admin');
INSERT INTO `checadas` VALUES ('28', '8', '3', '2014-07-21', '09:41:36', '09:41:37', '09:41:38', '09:41:39', '09:41:39', 'admin');
INSERT INTO `checadas` VALUES ('29', '11', '3', '2014-07-21', '09:41:44', '00:00:00', '00:00:00', '00:00:00', '09:41:44', 'admin');
INSERT INTO `checadas` VALUES ('30', '12', '3', '2014-07-21', '09:41:46', '09:41:48', '09:41:49', '09:41:50', '09:41:50', 'admin');
INSERT INTO `checadas` VALUES ('31', '13', '3', '2014-07-21', '09:41:51', '09:41:52', '09:41:52', '09:41:53', '09:41:53', 'admin');
INSERT INTO `checadas` VALUES ('32', '16', '1', '2014-07-21', '09:42:01', '09:42:03', '09:42:04', '09:42:05', '09:42:05', 'admin');
INSERT INTO `checadas` VALUES ('33', '20', '1', '2014-07-21', '09:43:14', '09:43:16', '09:43:17', '09:43:18', '09:43:18', 'admin');
INSERT INTO `checadas` VALUES ('34', '22', '1', '2014-07-21', '09:43:21', '09:43:23', '09:43:24', '09:43:25', '09:43:25', 'admin');
INSERT INTO `checadas` VALUES ('35', '24', '7', '2014-07-21', '09:43:28', '09:43:29', '09:43:30', '09:43:31', '09:43:31', 'admin');
INSERT INTO `checadas` VALUES ('36', '25', '7', '2014-07-21', '09:43:34', '09:43:34', '09:43:35', '09:43:36', '09:43:36', 'admin');
INSERT INTO `checadas` VALUES ('37', '26', '7', '2014-07-21', '09:43:37', '09:43:39', '09:43:39', '09:43:41', '09:43:41', 'admin');
INSERT INTO `checadas` VALUES ('38', '55', '1', '2014-07-21', '09:43:45', '09:43:46', '09:43:46', '09:43:47', '09:43:47', 'admin');
INSERT INTO `checadas` VALUES ('39', '57', '1', '2014-07-21', '09:43:48', '09:43:49', '09:43:50', '09:43:50', '09:43:50', 'admin');
INSERT INTO `checadas` VALUES ('40', '71', '2', '2014-07-21', '09:43:52', '09:43:53', '09:43:55', '09:44:34', '09:44:34', 'admin');
INSERT INTO `checadas` VALUES ('41', '73', '1', '2014-07-21', '09:44:25', '09:44:26', '09:44:27', '09:44:28', '09:44:28', 'admin');
INSERT INTO `checadas` VALUES ('42', '72', '3', '2014-07-21', '09:44:30', '09:44:31', '09:44:33', '09:44:38', '09:44:38', 'admin');
INSERT INTO `checadas` VALUES ('44', '65', '3', '2014-07-21', '09:45:31', '09:45:31', '09:45:32', '09:45:33', '09:45:33', 'admin');
INSERT INTO `checadas` VALUES ('45', '60', '3', '2014-07-21', '09:51:52', '00:00:00', '00:00:00', '00:00:00', '09:51:52', 'admin');
INSERT INTO `checadas` VALUES ('46', '29', '4', '2014-07-21', '09:55:13', '09:55:19', '00:00:00', '00:00:00', '09:55:19', 'admin');
INSERT INTO `checadas` VALUES ('47', '53', '4', '2014-07-21', '09:55:15', '09:55:18', '09:55:18', '00:00:00', '09:55:18', 'admin');
INSERT INTO `checadas` VALUES ('48', '36', '4', '2014-07-21', '09:55:28', '09:55:28', '09:55:29', '09:55:29', '09:55:29', 'admin');
INSERT INTO `checadas` VALUES ('49', '37', '4', '2014-07-21', '09:55:30', '09:55:30', '09:55:31', '00:00:00', '09:55:31', 'admin');
INSERT INTO `checadas` VALUES ('50', '38', '4', '2014-07-21', '09:55:31', '09:55:35', '09:55:37', '00:00:00', '09:55:37', 'admin');
INSERT INTO `checadas` VALUES ('51', '39', '4', '2014-07-21', '09:55:38', '09:55:39', '09:55:40', '09:55:40', '09:55:40', 'admin');
INSERT INTO `checadas` VALUES ('52', '1', '2', '2014-07-22', '09:58:05', '09:58:05', '09:58:06', '00:00:00', '09:58:06', 'admin');
INSERT INTO `checadas` VALUES ('53', '2', '2', '2014-07-22', '09:58:08', '09:58:09', '09:58:55', '00:00:00', '09:58:55', 'admin');
INSERT INTO `checadas` VALUES ('54', '3', '2', '2014-07-22', '09:58:10', '09:58:11', '00:00:00', '00:00:00', '09:58:11', 'admin');
INSERT INTO `checadas` VALUES ('55', '4', '2', '2014-07-22', '09:58:12', '09:58:13', '00:00:00', '00:00:00', '09:58:13', 'admin');
INSERT INTO `checadas` VALUES ('56', '5', '2', '2014-07-22', '09:58:13', '09:58:14', '00:00:00', '00:00:00', '09:58:14', 'admin');
INSERT INTO `checadas` VALUES ('57', '6', '2', '2014-07-22', '09:58:15', '09:58:16', '00:00:00', '00:00:00', '09:58:16', 'admin');
INSERT INTO `checadas` VALUES ('58', '7', '3', '2014-07-22', '09:58:16', '09:58:17', '00:00:00', '00:00:00', '09:58:17', 'admin');
INSERT INTO `checadas` VALUES ('59', '8', '3', '2014-07-22', '09:58:17', '09:58:18', '00:00:00', '00:00:00', '09:58:18', 'admin');
INSERT INTO `checadas` VALUES ('60', '11', '3', '2014-07-22', '09:58:24', '09:58:26', '09:58:26', '00:00:00', '09:58:26', 'admin');
INSERT INTO `checadas` VALUES ('61', '12', '3', '2014-07-22', '09:58:27', '09:58:28', '00:00:00', '00:00:00', '09:58:28', 'admin');
INSERT INTO `checadas` VALUES ('62', '13', '3', '2014-07-22', '09:58:29', '09:58:31', '00:00:00', '00:00:00', '09:58:31', 'admin');
INSERT INTO `checadas` VALUES ('63', '16', '1', '2014-07-22', '09:58:35', '09:58:37', '00:00:00', '00:00:00', '09:58:37', 'admin');
INSERT INTO `checadas` VALUES ('64', '20', '1', '2014-07-22', '09:58:48', '09:58:50', '00:00:00', '00:00:00', '09:58:50', 'admin');
INSERT INTO `checadas` VALUES ('65', '22', '1', '2014-07-22', '09:58:54', '09:58:56', '00:00:00', '00:00:00', '09:58:56', 'admin');
INSERT INTO `checadas` VALUES ('66', '24', '7', '2014-07-22', '09:58:59', '09:59:01', '00:00:00', '00:00:00', '09:59:01', 'admin');
INSERT INTO `checadas` VALUES ('67', '25', '7', '2014-07-22', '09:59:02', '09:59:03', '00:00:00', '00:00:00', '09:59:03', 'admin');
INSERT INTO `checadas` VALUES ('68', '26', '7', '2014-07-22', '09:59:04', '09:59:04', '00:00:00', '00:00:00', '09:59:04', 'admin');
INSERT INTO `checadas` VALUES ('69', '29', '4', '2014-07-22', '09:59:12', '09:59:13', '00:00:00', '00:00:00', '09:59:13', 'admin');
INSERT INTO `checadas` VALUES ('70', '30', '6', '2014-07-22', '09:59:14', '09:59:15', '00:00:00', '00:00:00', '09:59:15', 'admin');
INSERT INTO `checadas` VALUES ('71', '31', '6', '2014-07-22', '09:59:17', '09:59:17', '00:00:00', '00:00:00', '09:59:17', 'admin');
INSERT INTO `checadas` VALUES ('72', '32', '6', '2014-07-22', '09:59:18', '09:59:19', '00:00:00', '00:00:00', '09:59:19', 'admin');
INSERT INTO `checadas` VALUES ('73', '34', '6', '2014-07-22', '09:59:21', '09:59:24', '00:00:00', '00:00:00', '09:59:24', 'admin');
INSERT INTO `checadas` VALUES ('74', '33', '6', '2014-07-22', '09:59:22', '09:59:23', '00:00:00', '00:00:00', '09:59:23', 'admin');
INSERT INTO `checadas` VALUES ('75', '35', '6', '2014-07-22', '09:59:25', '00:00:00', '00:00:00', '00:00:00', '09:59:25', 'admin');
INSERT INTO `checadas` VALUES ('76', '37', '4', '2014-07-22', '09:59:29', '00:00:00', '00:00:00', '00:00:00', '09:59:29', 'admin');
INSERT INTO `checadas` VALUES ('77', '38', '4', '2014-07-22', '09:59:31', '00:00:00', '00:00:00', '00:00:00', '09:59:31', 'admin');
INSERT INTO `checadas` VALUES ('78', '39', '4', '2014-07-22', '09:59:31', '00:00:00', '00:00:00', '00:00:00', '09:59:31', 'admin');
INSERT INTO `checadas` VALUES ('79', '71', '2', '2014-07-22', '09:59:44', '09:59:46', '00:00:00', '00:00:00', '09:59:46', 'admin');
INSERT INTO `checadas` VALUES ('80', '72', '3', '2014-07-22', '09:59:48', '09:59:49', '00:00:00', '00:00:00', '09:59:49', 'admin');
INSERT INTO `checadas` VALUES ('81', '73', '1', '2014-07-22', '09:59:50', '09:59:51', '00:00:00', '00:00:00', '09:59:51', 'admin');
INSERT INTO `checadas` VALUES ('82', '16', '1', '2014-07-23', '10:01:21', '00:00:00', '00:00:00', '00:00:00', '10:01:21', 'admin');
INSERT INTO `checadas` VALUES ('83', '73', '1', '2014-07-23', '10:01:27', '10:01:28', '00:00:00', '00:00:00', '10:01:28', 'admin');
INSERT INTO `checadas` VALUES ('84', '22', '1', '2014-07-23', '10:01:32', '10:01:34', '00:00:00', '00:00:00', '10:01:34', 'admin');
INSERT INTO `checadas` VALUES ('85', '2', '2', '2014-07-23', '10:01:32', '00:00:00', '00:00:00', '00:00:00', '10:01:32', 'admin');
INSERT INTO `checadas` VALUES ('86', '24', '7', '2014-07-23', '10:01:38', '00:00:00', '00:00:00', '00:00:00', '10:01:38', 'admin');
INSERT INTO `checadas` VALUES ('87', '20', '1', '2014-07-23', '10:02:15', '00:00:00', '00:00:00', '00:00:00', '10:02:15', 'admin');
INSERT INTO `checadas` VALUES ('88', '55', '1', '2014-07-23', '10:02:22', '10:02:26', '00:00:00', '00:00:00', '10:02:26', 'admin');
INSERT INTO `checadas` VALUES ('89', '57', '1', '2014-07-23', '10:02:23', '00:00:00', '00:00:00', '00:00:00', '10:02:23', 'admin');
INSERT INTO `checadas` VALUES ('90', '16', '1', '2014-07-24', '10:03:14', '00:00:00', '00:00:00', '00:00:00', '10:03:14', 'admin');
INSERT INTO `checadas` VALUES ('91', '20', '1', '2014-07-24', '10:03:17', '10:03:18', '00:00:00', '00:00:00', '10:03:18', 'admin');
INSERT INTO `checadas` VALUES ('92', '22', '1', '2014-07-24', '10:03:17', '00:00:00', '00:00:00', '00:00:00', '10:03:17', 'admin');
INSERT INTO `checadas` VALUES ('93', '55', '1', '2014-07-24', '10:03:20', '10:03:22', '00:00:00', '00:00:00', '10:03:22', 'admin');
INSERT INTO `checadas` VALUES ('94', '57', '1', '2014-07-24', '10:03:20', '10:03:21', '00:00:00', '00:00:00', '10:03:21', 'admin');
INSERT INTO `checadas` VALUES ('95', '25', '7', '2014-07-26', '09:45:29', '09:45:30', '09:45:32', '09:45:33', '09:45:33', 'admin');
INSERT INTO `checadas` VALUES ('96', '26', '7', '2014-07-26', '09:45:31', '09:45:32', '00:00:00', '00:00:00', '09:45:32', 'admin');
INSERT INTO `checadas` VALUES ('97', '20', '1', '2014-07-26', '09:45:35', '00:00:00', '00:00:00', '00:00:00', '09:45:35', 'admin');
INSERT INTO `checadas` VALUES ('98', '16', '1', '2014-07-26', '09:45:38', '09:45:39', '00:00:00', '00:00:00', '09:45:39', 'admin');
INSERT INTO `checadas` VALUES ('99', '73', '1', '2014-07-26', '09:45:42', '00:00:00', '00:00:00', '00:00:00', '09:45:42', 'admin');
INSERT INTO `checadas` VALUES ('100', '72', '3', '2014-07-26', '09:45:43', '00:00:00', '00:00:00', '00:00:00', '09:45:43', 'admin');
INSERT INTO `checadas` VALUES ('101', '71', '2', '2014-07-26', '09:45:44', '00:00:00', '00:00:00', '00:00:00', '09:45:44', 'admin');
INSERT INTO `checadas` VALUES ('102', '29', '4', '2014-07-26', '10:12:35', '00:00:00', '00:00:00', '00:00:00', '10:12:35', 'admin');
INSERT INTO `checadas` VALUES ('103', '30', '6', '2014-07-26', '10:12:37', '00:00:00', '00:00:00', '00:00:00', '10:12:37', 'admin');
INSERT INTO `checadas` VALUES ('104', '31', '6', '2014-07-26', '10:12:38', '00:00:00', '00:00:00', '00:00:00', '10:12:38', 'admin');
INSERT INTO `checadas` VALUES ('105', '55', '1', '2014-07-26', '10:15:35', '10:15:39', '10:15:41', '00:00:00', '10:15:41', 'admin');
INSERT INTO `checadas` VALUES ('106', '57', '1', '2014-07-26', '10:15:37', '10:15:38', '10:15:40', '00:00:00', '10:15:40', 'admin');
INSERT INTO `checadas` VALUES ('107', '55', '1', '2014-07-25', '10:17:39', '10:17:44', '00:00:00', '00:00:00', '10:17:44', 'admin');
INSERT INTO `checadas` VALUES ('108', '20', '1', '2014-07-25', '10:17:41', '10:17:43', '00:00:00', '00:00:00', '10:17:43', 'admin');
INSERT INTO `checadas` VALUES ('109', '57', '1', '2014-07-25', '10:17:45', '10:17:46', '00:00:00', '00:00:00', '10:17:46', 'admin');
INSERT INTO `checadas` VALUES ('110', '16', '1', '2014-07-25', '10:17:47', '10:17:48', '00:00:00', '00:00:00', '10:17:48', 'admin');

-- ----------------------------
-- Table structure for config_horarios
-- ----------------------------
DROP TABLE IF EXISTS `config_horarios`;
CREATE TABLE `config_horarios` (
  `id_configuracion` int(11) NOT NULL AUTO_INCREMENT,
  `key_empresa` int(11) NOT NULL,
  `hora_entrada_config` time DEFAULT NULL,
  `hora_salida_comida_config` time DEFAULT NULL,
  `hora_entrada_comida_config` time DEFAULT NULL,
  `hora_salida_config` time DEFAULT NULL,
  PRIMARY KEY (`id_configuracion`,`key_empresa`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of config_horarios
-- ----------------------------

-- ----------------------------
-- Table structure for usuarios
-- ----------------------------
DROP TABLE IF EXISTS `usuarios`;
CREATE TABLE `usuarios` (
  `id_usuario` int(3) NOT NULL AUTO_INCREMENT,
  `nombre_usuario` varchar(50) DEFAULT NULL,
  `password` varchar(60) DEFAULT NULL,
  `fecha_creacion` date DEFAULT NULL,
  PRIMARY KEY (`id_usuario`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of usuarios
-- ----------------------------
INSERT INTO `usuarios` VALUES ('1', 'admin', 'gravekeeper', '2014-07-17');
INSERT INTO `usuarios` VALUES ('2', 'agustin', 'alfaro10', '2014-07-25');
INSERT INTO `usuarios` VALUES ('3', 'videliuser', 'california', '2014-07-25');
INSERT INTO `usuarios` VALUES ('4', 'dikauser', 'paris', '2014-07-25');
INSERT INTO `usuarios` VALUES ('5', 'axessouser', 'hafu', '2014-07-25');
INSERT INTO `usuarios` VALUES ('6', 'corporativo', 'allright', '2014-07-25');