-- http://www.phpmyadmin.net
--




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

--
-- Table structure for table `medlist`
--

CREATE TABLE IF NOT EXISTS `medlist` (
  `patient_id` varchar(50) NOT NULL,
  `med_id` int(11) NOT NULL AUTO_INCREMENT,
  `med_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `dosage` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `time_per_day` int(3) NOT NULL,
  `active_ind` tinyint(1) NOT NULL,
  `num_dosages` int(4) NOT NULL,
  `num_refills` int(4) NOT NULL,
  `end_date` datetime NOT NULL,
  `date` datetime NOT NULL,
  `creator` varchar(50) NOT NULL,
  `updater` varchar(50) NOT NULL,
  `update_action` varchar(20) NOT NULL,
  `update_time` datetime NOT NULL,
  PRIMARY KEY (`patient_id`,`med_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `medlist`
--

INSERT INTO `medlist` (`patient_id`, `med_id`, `med_name`, `dosage`, `time_per_day`, `active_ind`, `num_dosages`, `num_refills`, `end_date`, `date`, `creator`, `updater`, `update_action`, `update_time`) VALUES
('olavien', 22, 'Nosal', '10mg', 4, 1, 9, 2, '2015-12-25 16:14:29', '2015-12-25 16:14:29', 'banksy', 'banksy', 'CREATED', '2015-12-25 16:14:29'),
('olavien', 20, 'M2003', '20mg', 4, 1, 4, 4, '2015-12-25 16:08:10', '2015-12-25 16:08:10', 'banksy', 'banksy', 'CREATED', '2015-12-25 16:08:10'),
('olavien', 21, 'MO09', '9mg', 3, 0, 4, 5, '2015-12-25 16:14:06', '2015-12-25 16:14:06', 'banksy', 'banksy', 'DELETED', '2015-12-25 16:14:12'),
('olavien', 19, 'M2002', '20mg', 4, 0, 4, 4, '2015-12-25 15:58:17', '2015-12-25 15:58:17', 'banksy', 'banksy', 'CHANGED', '2015-12-25 16:08:10'),
('olavien', 18, 'M2001', '10mg', 4, 0, 5, 6, '2015-12-25 15:57:56', '2015-12-25 15:57:56', 'olavien', 'banksy', 'CHANGED', '2015-12-25 15:58:17'),
('olavien', 17, 'm200', '10mg', 4, 0, 6, 6, '2015-12-25 15:55:31', '2015-12-25 15:55:31', 'banksy', 'olavien', 'CHANGED', '2015-12-25 15:57:56'),
('olavien', 16, 'Dele', '100mg', 3, 0, 3, 5, '2015-12-25 14:06:37', '2015-12-25 14:06:37', 'olavien', 'olavien', 'DELETED', '2015-12-25 14:06:41'),
('olavien', 15, 'M100', '100mg', 2, 0, 4, 5, '2015-12-25 14:06:21', '2015-12-25 14:06:21', 'olavien', 'banksy', 'DELETED', '2015-12-25 16:09:41'),
('olavien', 14, 'M10', '10mg', 3, 0, 4, 5, '2015-12-25 13:49:50', '2015-12-25 13:49:50', 'olavien', 'olavien', 'CHANGED', '2015-12-25 14:06:21');

