set('Chemistry','Biology','Physics','Mathematics[C]','Mathematics[N]','English[K]','English[M]','Social studies','Thai','Accounting','ICT','PE','Music[TH]','Music[IN]','Community','Health and hygiene','Guidance') COLLATE utf8_unicode_ci NOT NULL,
  `Day` date NOT NULL,
  `Description` text COLLATE utf8_unicode_ci NOT NULL,
  `Status` set('Complete','Not complete') COLLATE utf8_unicode_ci NOT NULL,
  `Type` set('Homework','Test','Reading') COLLATE utf8_unicode_ci NOT NULL,
  `CompleteDate` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--