text: /*
  Navicat MySQL Data Transfer
  
  Source Server         : 05-61.19.22.203-บางกระทุ่ม
  Source Server Version : 50542
  Source Host           : 61.19.22.203:3306
  Source Database       : dhdc
  
  Target Server Type    : MYSQL
  Target Server Version : 50542
  File Encoding         : 65001
  
  Date: 2017-01-26 09:46:44
  */
  
  SET FOREIGN_KEY_CHECKS=0;
  
  -- ----------------------------
  -- Table structure for log_ehr
  -- ----------------------------
  DROP TABLE IF EXISTS `log_ehr`;
  CREATE TABLE `log_ehr` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `username` varchar(255) DEFAULT NULL,
    `ip` varchar(255) DEFAULT NULL,
    `patient_cid` varchar(255) DEFAULT NULL,
    `datetime` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of log_ehr
  -- ----------------------------
  INSERT INTO `log_ehr` VALUES ('1', 'admin', '::1', '3650500021634', '2017-01-24 22:39:44');
  INSERT INTO `log_ehr` VALUES ('2', 'admin', '::1', '3650500021634', '2017-01-24 22:41:49');
  INSERT INTO `log_ehr` VALUES ('3', 'admin', '::1', '3650500010683', '2017-01-24 22:45:09');
  INSERT INTO `log_ehr` VALUES ('4', 'cm02', '182.53.116.225', '3650500183243', '2017-01-24 22:47:49');
  INSERT INTO `log_ehr` VALUES ('5', 'cm02', '182.53.116.225', '3650500183243', '2017-01-24 22:48:07');
  INSERT INTO `log_ehr` VALUES ('6', 'cm02', '182.53.116.225', '3650500183243', '2017-01-24 22:48:11');
  INSERT INTO `log_ehr` VALUES ('7', 'cm02', '182.53.116.225', '3650500181933', '2017-01-24 22:48:33');
  INSERT INTO `log_ehr` VALUES ('8', 'cm02', '182.53.116.225', '3650500175062', '2017-01-24 22:48:45');
  INSERT INTO `log_ehr` VALUES ('9', 'cm02', '182.53.116.225', '3650500183243', '2017-01-24 22:50:26');
  INSERT INTO `log_ehr` VALUES ('10', 'cm02', '182.53.116.225', '3650500183243', '2017-01-24 22:51:27');
  INSERT INTO `log_ehr` VALUES ('11', 'cm02', '182.53.116.225', '3650500183243', '2017-01-24 22:52:11');
  INSERT INTO `log_ehr` VALUES ('12', 'cm02', '182.53.116.225', '3650500183243', '2017-01-24 22:52:15');
  INSERT INTO `log_ehr` VALUES ('13', 'cm02', '182.53.116.225', '3650500187915', '2017-01-24 22:55:09');
  INSERT INTO `log_ehr` VALUES ('14', 'cm02', '182.53.116.225', '3650500187915', '2017-01-24 23:01:10');
  INSERT INTO `log_ehr` VALUES ('15', 'cm02', '182.53.116.225', '3650500176107', '2017-01-24 23:01:17');
  INSERT INTO `log_ehr` VALUES ('16', 'cm02', '182.53.116.225', '3650500176107', '2017-01-24 23:02:49');
  INSERT INTO `log_ehr` VALUES ('17', 'cm02', '182.53.116.225', '3650500176107', '2017-01-24 23:03:55');
  INSERT INTO `log_ehr` VALUES ('18', 'cm02', '182.53.116.225', '3650500181836', '2017-01-24 23:04:15');
  INSERT INTO `log_ehr` VALUES ('19', 'cm02', '182.53.116.225', '3650500154871', '2017-01-24 23:04:59');
  INSERT INTO `log_ehr` VALUES ('20', 'cm02', '182.53.116.225', '3650500209072', '2017-01-24 23:05:17');
  INSERT INTO `log_ehr` VALUES ('21', 'cm02', '182.53.116.225', '3650500176107', '2017-01-24 23:06:57');
  INSERT INTO `log_ehr` VALUES ('22', 'cm02', '182.53.116.225', '3650500183812', '2017-01-24 23:08:24');
  INSERT INTO `log_ehr` VALUES ('23', 'cm02', '182.53.116.225', '3650500172331', '2017-01-24 23:10:43');
  INSERT INTO `log_ehr` VALUES ('24', 'cm02', '182.53.116.225', '3650500172331', '2017-01-24 23:17:49');
  INSERT INTO `log_ehr` VALUES ('25', 'cm02', '182.53.116.225', '3650500183243', '2017-01-24 23:18:11');
  INSERT INTO `log_ehr` VALUES ('26', 'cm02', '182.53.116.225', '3650500175691', '2017-01-24 23:22:45');
  INSERT INTO `log_ehr` VALUES ('27', 'cm02', '182.53.116.225', '3650500179661', '2017-01-24 23:24:54');
  INSERT INTO `log_ehr` VALUES ('28', 'cm02', '182.53.116.225', '3650500167361', '2017-01-24 23:25:59');
  INSERT INTO `log_ehr` VALUES ('29', 'cm02', '182.53.116.225', '3650500167361', '2017-01-24 23:35:59');
  INSERT INTO `log_ehr` VALUES ('30', 'cm02', '182.53.116.225', '3650500170265', '2017-01-24 23:36:37');
  INSERT INTO `log_ehr` VALUES ('31', 'cm02', '182.53.116.225', '3650500170265', '2017-01-24 23:37:36');
  INSERT INTO `log_ehr` VALUES ('32', 'cm02', '66.249.82.132', '3650500209072', '2017-01-24 23:40:25');
  INSERT INTO `log_ehr` VALUES ('33', 'cm02', '66.249.82.132', '3650500209072', '2017-01-24 23:41:52');
  INSERT INTO `log_ehr` VALUES ('34', 'cm02', '66.249.82.135', '3650500183243', '2017-01-24 23:44:01');
  INSERT INTO `log_ehr` VALUES ('35', 'cm02', '66.249.82.135', '3650500183243', '2017-01-25 01:20:17');
  INSERT INTO `log_ehr` VALUES ('36', 'cm02', '66.249.82.132', '3650500181496', '2017-01-25 01:21:15');
  INSERT INTO `log_ehr` VALUES ('37', 'cm02', '66.249.82.135', '3650500181496', '2017-01-25 01:21:27');
  INSERT INTO `log_ehr` VALUES ('38', 'cm02', '66.249.82.129', '3650500181496', '2017-01-25 01:22:52');
  INSERT INTO `log_ehr` VALUES ('39', 'cm02', '64.233.173.6', '3650500159466', '2017-01-25 07:13:19');
  INSERT INTO `log_ehr` VALUES ('40', 'cm02', '64.233.173.4', '3650500159466', '2017-01-25 07:14:40');
  INSERT INTO `log_ehr` VALUES ('41', 'cm02', '64.233.173.4', '3650500209072', '2017-01-25 07:24:00');
  INSERT INTO `log_ehr` VALUES ('42', 'cm02', '64.233.173.2', '3650500209072', '2017-01-25 07:24:03');
  INSERT INTO `log_ehr` VALUES ('43', 'cm02', '64.233.173.2', '3650500181836', '2017-01-25 07:24:38');
  INSERT INTO `log_ehr` VALUES ('44', 'cm02', '64.233.173.2', '3650500200717', '2017-01-25 07:28:15');
  INSERT INTO `log_ehr` VALUES ('45', 'cm02', '64.233.173.6', '3650500200717', '2017-01-25 07:29:00');
  INSERT INTO `log_ehr` VALUES ('46', 'cm02', '64.233.173.2', '3650500183243', '2017-01-25 08:05:46');
  INSERT INTO `log_ehr` VALUES ('47', 'cm02', '64.233.173.6', '3650500183243', '2017-01-25 08:05:54');
  INSERT INTO `log_ehr` VALUES ('48', 'cm02', '64.233.173.6', '3650500183243', '2017-01-25 08:05:59');
  INSERT INTO `log_ehr` VALUES ('49', 'cm02', '182.53.116.225', '3650500183243', '2017-01-25 08:12:37');
  INSERT INTO `log_ehr` VALUES ('50', 'cm02', '64.233.173.2', '3650500183243', '2017-01-25 08:49:56');
  INSERT INTO `log_ehr` VALUES ('51', 'cm02', '64.233.173.2', '3650500183243', '2017-01-25 08:50:00');
  INSERT INTO `log_ehr` VALUES ('52', 'cm02', '64.233.173.6', '3650500183243', '2017-01-25 08:50:01');
  INSERT INTO `log_ehr` VALUES ('53', 'cm02', '110.77.179.70', '3650500183243', '2017-01-25 09:18:04');
  INSERT INTO `log_ehr` VALUES ('54', 'cm02', '110.77.179.70', '3650500183243', '2017-01-25 09:20:09');
  INSERT INTO `log_ehr` VALUES ('55', 'cm02', '110.77.179.70', '3650500179661', '2017-01-25 09:57:14');
  INSERT INTO `log_ehr` VALUES ('56', 'cm02', '110.77.179.70', '3650500154871', '2017-01-25 10:05:33');
  INSERT INTO `log_ehr` VALUES ('57', 'cm02', '110.77.179.70', '3650500160286', '2017-01-25 10:07:03');
  INSERT INTO `log_ehr` VALUES ('58', 'cm02', '110.77.179.70', '3650500159466', '2017-01-25 10:16:29');
  INSERT INTO `log_ehr` VALUES ('59', 'cm02', '110.77.179.70', '3650500167361', '2017-01-25 11:06:29');
  INSERT INTO `log_ehr` VALUES ('60', 'cm02', '110.77.179.70', '3650500209072', '2017-01-25 11:15:29');
  INSERT INTO `log_ehr` VALUES ('61', 'cm02', '110.77.179.70', '3650500175691', '2017-01-25 11:20:09');
  INSERT INTO `log_ehr` VALUES ('62', 'cm02', '110.77.179.70', '3650500183570', '2017-01-25 11:24:23');
  INSERT INTO `log_ehr` VALUES ('63', 'cm02', '110.77.179.70', '3650500181496', '2017-01-25 11:28:19');
  INSERT INTO `log_ehr` VALUES ('64', 'cm02', '110.77.179.70', '3650500181836', '2017-01-25 11:36:51');
  INSERT INTO `log_ehr` VALUES ('65', 'cm02', '110.77.179.70', '3650500181933', '2017-01-25 11:38:44');
  INSERT INTO `log_ehr` VALUES ('66', 'cm02', '110.77.179.70', '3650500175062', '2017-01-25 11:42:08');
  INSERT INTO `log_ehr` VALUES ('67', 'cm02', '110.77.179.70', '3650500174201', '2017-01-25 11:47:31');
  INSERT INTO `log_ehr` VALUES ('68', 'cm02', '110.77.179.70', '3650500176107', '2017-01-25 11:49:20');
  INSERT INTO `log_ehr` VALUES ('69', 'cm02', '110.77.179.70', '3650500183812', '2017-01-25 11:52:43');
  INSERT INTO `log_ehr` VALUES ('70', 'cm02', '110.77.179.70', '3650500207835', '2017-01-25 11:54:32');
  INSERT INTO `log_ehr` VALUES ('71', 'cm02', '110.77.179.70', '3650500176654', '2017-01-25 11:57:43');
  INSERT INTO `log_ehr` VALUES ('72', 'cm02', '110.77.175.253', '3650500190860', '2017-01-25 11:59:19');
  INSERT INTO `log_ehr` VALUES ('73', 'cm02', '110.77.175.253', '3670800627996', '2017-01-25 12:03:36');
  INSERT INTO `log_ehr` VALUES ('74', 'cm02', '110.77.175.253', '3650500200717', '2017-01-25 12:04:21');
  INSERT INTO `log_ehr` VALUES ('75', 'cm02', '110.77.175.253', '3650500170273', '2017-01-25 12:08:35');
  INSERT INTO `log_ehr` VALUES ('76', 'cm02', '110.77.175.253', '3650500170265', '2017-01-25 12:13:07');
  INSERT INTO `log_ehr` VALUES ('77', 'cm02', '110.77.175.253', '3650500172331', '2017-01-25 12:18:36');
  INSERT INTO `log_ehr` VALUES ('78', 'cm02', '203.157.118.99', '3650500183243', '2017-01-25 12:36:32');
  INSERT INTO `log_ehr` VALUES ('79', 'cm02', '203.157.118.99', '3650500183243', '2017-01-25 12:37:24');
  INSERT INTO `log_ehr` VALUES ('80', 'cm02', '203.157.118.99', '3650500154871', '2017-01-25 12:38:16');
  INSERT INTO `log_ehr` VALUES ('81', 'cm02', '203.157.118.99', '3650500160286', '2017-01-25 12:38:50');
  INSERT INTO `log_ehr` VALUES ('82', 'cm02', '203.157.118.99', '3650500183243', '2017-01-25 13:01:48');
  INSERT INTO `log_ehr` VALUES ('83', 'cm02', '203.157.118.99', '3650500185564', '2017-01-25 14:15:46');
  INSERT INTO `log_ehr` VALUES ('84', 'admin', '::1', '3650500010683', '2017-01-25 14:17:35');
  INSERT INTO `log_ehr` VALUES ('85', 'cm02', '203.157.118.99', '3650500185564', '2017-01-25 14:29:20');
  INSERT INTO `log_ehr` VALUES ('86', 'cm02', '203.157.118.99', '3650500185564', '2017-01-25 14:29:27');
  INSERT INTO `log_ehr` VALUES ('87', 'cm02', '64.233.173.6', '3650500160286', '2017-01-25 14:38:21');
  INSERT INTO `log_ehr` VALUES ('88', 'cm02', '203.157.118.99', '3650500175691', '2017-01-25 15:39:33');
  INSERT INTO `log_ehr` VALUES ('89', 'cm02', '110.77.175.253', '3650500185564', '2017-01-25 15:57:35');
  INSERT INTO `log_ehr` VALUES ('90', 'cm02', '110.77.175.253', '3650500172331', '2017-01-25 15:57:46');
  INSERT INTO `log_ehr` VALUES ('91', 'cm02', '110.77.175.253', '3650500185564', '2017-01-25 16:28:36');
  INSERT INTO `log_ehr` VALUES ('92', 'cm02', '64.233.173.6', '3650500159466', '2017-01-25 18:03:26');
  INSERT INTO `log_ehr` VALUES ('93', 'cm02', '64.233.173.2', '3650500183243', '2017-01-26 07:43:05');
  INSERT INTO `log_ehr` VALUES ('94', 'cm02', '64.233.173.6', '3650500183243', '2017-01-26 07:53:52');
  INSERT INTO `log_ehr` VALUES ('95', 'cm02', '64.233.173.6', '3650500183243', '2017-01-26 07:55:30');
  