· 8 years ago · Mar 03, 2018, 04:58 PM
1CREATE TABLE IF NOT EXISTS `medicine` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `data_pills_taken` tinyint(4) NOT NULL,
4 `data_pills_total` tinyint(4) NOT NULL,
5 `datetime_occured` datetime NOT NULL,
6 UNIQUE KEY `id` (`id`)
7)