 --
 
 INSERT INTO `ct_hp` (`ID_SV`, `ID_HP`, `DIEM_CHU`, `DIEM_10`, `DIEM_4`, `CAI_THIEN`, `TL`) VALUES
-(1, 1, 'A', 9.8, 4, 1, 1),
-(1, 3, NULL, NULL, NULL, 0, 0),
-(1, 6, NULL, NULL, NULL, 0, 0),
-(3, 1, 'B', 7.8, 3.5, 0, 1),
-(3, 6, NULL, NULL, NULL, 0, 0),
-(3, 7, 'A', 9, 4, 0, 1),
-(3, 8, 'F', 3.5, 0, 0, 0),
-(3, 9, NULL, NULL, NULL, 0, 0),
+(1, 1, 'B+', 8, 3.5, 1, 1),
+(1, 3, 'F', 3, 0, 0, 0),
+(1, 4, 'B', 7.8, 3, 0, 1),
+(1, 5, 'B', 7.6, 3, 0, 1),
+(1, 6, 'D', 4, 1, 0, 1),
+(1, 7, 'A', 9, 4, 0, 1),
+(1, 8, 'F', 3.5, 0, 0, 0),
+(1, 9, 'M', 11, 5, 0, 1),
+(1, 10, 'B+', 8.7, 3.5, 1, 1),
+(3, 2, 'F', 3, 0, 0, 0),
 (8, 1, 'D', 4.1, 1, 0, 1),
-(8, 5, 'B', 7.6, 3, 0, 1),
 (8, 6, 'C', 5, 2, 1, 1),
-(8, 7, NULL, NULL, NULL, 0, 0),
-(8, 9, NULL, NULL, NULL, 0, 0),
+(8, 7, NULL, NULL, NULL, 0, 1),
+(8, 9, NULL, NULL, NULL, 0, 1),
 (8, 10, 'D+', 4.7, 1.5, 0, 1),
 (9, 4, 'B+', 8.6, 3.5, 0, 1),
-(11, 6, NULL, NULL, NULL, 0, 0),
+(11, 6, NULL, NULL, NULL, 0, 1),
 (16, 1, 'C', 5.4, 2, 0, 1),
 (16, 3, 'A', 9.6, 4, 0, 1),
 (17, 4, 'B', 7.2, 3, 0, 1),
-(17, 5, 'F', 3.4, 0, 0, 0),
-(17, 6, 'C+', 5.6, 2.5, 0, 1),
-(17, 10, 'B+', 8.7, 3.5, 1, 1);
+(17, 5, 'F', 3.4, 0, 0, 1),
+(17, 6, 'C+', 5.6, 2.5, 0, 1);
 
 -- --------------------------------------------------------
 

-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Nov 10, 2015 at 06:56 AM
-- Server version: 5.6.24
-- PHP Version: 5.6.8



CREATE TABLE IF NOT EXISTS `thang_diem` (
  `ID` int(10) unsigned NOT NULL,
  `THANG_DIEM` varchar(150) COLLATE utf8_bin NOT NULL,
  `TD_AP_DUNG` date NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `thang_diem`
--

INSERT INTO `thang_diem` (`ID`, `THANG_DIEM`, `TD_AP_DUNG`) VALUES
(1, 'A-9-Y-Y-4.0,B-7-Y-Y-3.0,C-6-Y-Y-2.0,D-4.0-Y-Y-1.0,F-0-N-N-0,M-11-Y-N-5,I-11-N-N-5,W-11-N-N-5', '2010-08-01'),
(2, 'A-9-Y-Y-4.0,B+-8-Y-Y-3.5,B-7-Y-Y-3.0,C+-6.5-Y-Y-2.5,C-6-Y-Y-2.0,D+-5-Y-Y-1.5,D-4.0-Y-Y-1.0,F-0-N-N-0,M-11-Y-N-5,I-11-N-N-5,W-11-N-N-5', '2012-08-01');

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

