   `careful` text COMMENT 'ข้อควรระวังในการให้บริการ',
   `d_update` datetime DEFAULT NULL,
   PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
 
 -- ----------------------------
 -- Records of plan
 -- ----------------------------
-INSERT INTO `plan` VALUES ('1', null, '2', '2017-01-05', 'blue', null, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', null);
-INSERT INTO `plan` VALUES ('2', null, '2', '2017-01-06', 'red', null, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', null);
-INSERT INTO `plan` VALUES ('3', null, '4', '2017-01-05', 'blue', null, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', null);
 INSERT INTO `plan` VALUES ('4', null, '6', '2017-01-06', 'red', null, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', null);
+INSERT INTO `plan` VALUES ('5', null, '5', '2017-01-06', 'blue', null, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', null);
+INSERT INTO `plan` VALUES ('6', null, '2', '2017-01-06', 'blue', '3', 'ติดเตียง', 'I1', 'กลุ่มที่ 4;ติดเตียง-2', '', '', '', '', '', '', '', '', '', '', '', '', '', null);
+INSERT INTO `plan` VALUES ('7', '07477', '4', '2017-01-06', 'blue', '2', '', 'I3', 'กลุ่มที่ 3;ติดเตียง-1', '', '', '', '', '', '', '', '', '', '', '', '', '', null);
 
 -- ----------------------------
 -- Table structure for plan_week

  `login_date` datetime DEFAULT NULL,
  `ip` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_log

  `d_create` datetime DEFAULT NULL,
  `d_update` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `plan` (`plan_id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of plan_week
-- ----------------------------
INSERT INTO `plan_week` VALUES ('1', null, '2', 'ดูแลโดยCG', '2017-01-02', '07:00:00', null, '08:00:00', null, null, null, null, '13', null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-01-07 16:57:26', null);
INSERT INTO `plan_week` VALUES ('2', null, '2', 'ดูแลโดยCG', '2017-01-03', '07:00:00', null, null, null, null, null, null, '13', null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-01-07 16:57:26', null);
INSERT INTO `plan_week` VALUES ('3', null, '2', 'ดูแลโดยCG', '2017-01-04', '07:00:00', null, null, null, null, null, null, '13', null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-01-07 16:57:26', null);
INSERT INTO `plan_week` VALUES ('4', null, '2', 'ดูแลโดยCG', '2017-01-05', '07:00:00', null, null, null, null, null, null, '13', null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-01-07 16:57:26', null);
INSERT INTO `plan_week` VALUES ('5', null, '2', 'ดูแลโดยCG', '2017-01-06', '07:00:00', null, null, null, null, null, null, '13', null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-01-07 16:57:26', null);
INSERT INTO `plan_week` VALUES ('6', null, '2', 'ดูแลโดยCG', '2017-01-07', '07:00:00', null, null, null, null, null, null, '13', null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-01-07 16:57:26', null);
INSERT INTO `plan_week` VALUES ('7', null, '2', 'ดูแลโดยCG', '2017-01-08', '07:00:00', null, null, null, null, null, null, '13', null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-01-07 16:57:26', null);
INSERT INTO `plan_week` VALUES ('8', null, '2', 'ดูแลโดยCG', '2017-01-02', '08:00:00', null, '09:00:00', null, null, null, null, '13', null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-01-07 16:59:19', null);
INSERT INTO `plan_week` VALUES ('9', null, '2', 'ดูแลโดยCG', '2017-01-03', '08:00:00', null, '09:00:00', null, null, null, null, '13', null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-01-07 16:59:19', null);
INSERT INTO `plan_week` VALUES ('10', null, '2', 'ดูแลโดยCG', '2017-01-04', '08:00:00', null, '09:00:00', null, null, null, null, '13', null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-01-07 16:59:19', null);
INSERT INTO `plan_week` VALUES ('11', null, '2', 'ดูแลโดยCG', '2017-01-05', '08:00:00', null, '09:00:00', null, null, null, null, '13', null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-01-07 16:59:19', null);
INSERT INTO `plan_week` VALUES ('12', null, '2', 'ดูแลโดยCG', '2017-01-06', '08:00:00', null, '09:00:00', null, null, null, null, '13', null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-01-07 16:59:19', null);
INSERT INTO `plan_week` VALUES ('13', null, '2', 'ดูแลโดยCG', '2017-01-07', '08:00:00', null, '09:00:00', null, null, null, null, '13', null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-01-07 16:59:19', null);
INSERT INTO `plan_week` VALUES ('14', null, '2', 'ดูแลโดยCG', '2017-01-08', '08:00:00', null, '09:00:00', null, null, null, null, '13', null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-01-07 16:59:19', null);

-- ----------------------------
-- Table structure for profile
-- ----------------------------
DROP TABLE IF EXISTS `profile`;
CREATE TABLE `profile` (
  `patient_id` int(11) NOT NULL,
  `cm_id` int(11) DEFAULT NULL,
  `cg_id` int(11) DEFAULT NULL,
  `cc` text,
  `pi` text,
  `fh` text,
  `ph` text,
  `mh` text,
  `nu` text,
  `he` text,
  `sh` text,
  `pe` text,
  `mse` text,
  `pl` text,
  `pm` text,
  `co` text,
  `d_update` datetime DEFAULT NULL,
  PRIMARY KEY (`patient_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of profile
-- ----------------------------

-- ----------------------------
-- Table structure for user
