Database: Setup Drugs Table

Create drugs table

CREATE TABLE IF NOT EXISTS `drugs` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,
  `brand_name` varchar(50) NULL,
  `indications` varchar(255) NULL,
  `adverse_reactions` varchar(255) NULL,
  `counseling_points` varchar(500) NULL,
  `notes` varchar(255) NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;