   `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
+  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
+  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+  `is_deleted` int(11) NOT NULL DEFAULT '0'
 ) 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');
+INSERT INTO `patients` (`id`, `fullname`, `middlename`, `lastname`, `sex`, `birthdate`, `birthplace`, `address`, `contact_no`, `email`, `remarks`, `created_at`, `updated_at`, `is_deleted`) 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-30 23:46:04', 0),
+(2, 'Simon', 'Petersd', 'George', 1, '1996-05-18', '1996-05-18', 'Gensan', '123456', 'george.simon@gmail.com', 'asdsadasdasdasd', '2017-07-30 13:54:39', '2017-07-30 21:55:25', 0),
+(3, 'Maco', 'Gallemit', 'Cortes', 1, '1995-02-21', 'Dapitan City', 'Dapitan City', '09058208455', 'maco.techdepot@gmail.com', 'Gwapo', '2017-07-30 13:28:56', '2017-07-30 21:28:56', 0),
+(4, 'Aww', 'Aww', 'Doggy', 1, '1984-03-05', 'Cotabato', 'Cotabato', '02230230655', 'hacker@hac.com', 'Nice ni sya', '2017-07-30 16:26:06', '2017-07-31 00:26:06', 0);
 
 -- --------------------------------------------------------
 

-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jul 28, 2017 at 09:41 AM
-- Server version: 10.1.21-MariaDB
-- PHP Version: 7.1.1


--

INSERT INTO `cases` (`id`, `patient_id`, `title`, `description`, `weight`, `height`, `status`, `created_at`, `updated_at`) VALUES
(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');

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

