 --
 
 INSERT INTO `cases` (`id`, `patient_id`, `title`, `description`, `weight`, `height`, `status`, `created_at`, `updated_at`) VALUES
-(2, 2, 'Tubercolosis', '<p>asdadaskljdaklsjdklasjdkljasdkljasl;kdasd</p>', 55, 164, 0, '2017-07-26 23:38:42', '2017-07-26 15:38:42'),
-(3, 1, 'Cancer', '<p>asdasdasdasdasdasd</p>', 123, 185, 0, '2017-07-26 23:40:09', '2017-07-26 15:40:09');
+(2, 2, 'Tubercolosis', '<p>;kdasd</p>', 55, 164, 0, '2017-07-26 23:38:42', '2017-07-30 16:24:08'),
+(3, 1, 'Cancer', '<p>asdasdasdasdasdasd</p>', 123, 185, 0, '2017-07-26 23:40:09', '2017-07-26 15:40:09'),
+(4, 3, 'Fever', '<p>Damn Boi</p>', 65, 164, 0, '2017-07-30 22:48:02', '2017-07-30 14:48:02');
 
 -- --------------------------------------------------------
 

  `contact_no` varchar(100) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `remarks` text,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `patients`
--

INSERT INTO `patients` (`id`, `fullname`, `middlename`, `lastname`, `sex`, `birthdate`, `birthplace`, `address`, `contact_no`, `email`, `remarks`, `created_at`, `updated_at`) VALUES
(1, 'asd', 'asdasd', 'asd', 0, '2017-07-05', '2017-07-05', 'asdad', 'asd', 'asd@asd.com', 'asd', '2017-07-27 14:43:26', '2017-07-27 22:43:26'),
(2, 'Simon', 'Peters', 'George', 1, '1996-05-18', '1996-05-18', 'Gensn', '123456', 'george.simon@gmail.com', 'asdsadasdasdasd', '2017-07-27 14:49:25', '2017-07-27 22:49:25');

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


-- AUTO_INCREMENT for table `cases`
--
ALTER TABLE `cases`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `patients`
--
ALTER TABLE `patients`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `prescription`
--
